Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
129 ghuddy 4
'                 REMOVE Packages
119 ghuddy 5
'               --- PROCESS FORM ---
6
'=====================================================
7
%>
8
<%
9
Option explicit
10
' Good idea to set when using redirect
129 ghuddy 11
Response.Expires = 0   ' always load the page, dont store
119 ghuddy 12
%>
13
<!--#include file="common/conf.asp"-->
14
<!--#include file="common/globals.asp"-->
15
<!--#include file="common/formating.asp"-->
16
<!--#include file="common/qstr.asp"-->
17
<!--#include file="common/common_subs.asp"-->
18
<!--#include file="common/common_dbedit.asp"-->
153 ghuddy 19
<!--#include file="common/daemon_instructions.asp"-->
165 brianf 20
<!--#include file="common/release_changed.asp"-->
119 ghuddy 21
<%
22
' Set rfile parameter. This is a return page after Login
23
Call objPMod.StoreParameter ( "rfile", "dependencies.asp" )
24
'------------ ACCESS CONTROL ------------------
25
%>
26
<!--#include file="_access_control_login.asp"-->
27
<!--#include file="_access_control_general.asp"-->
28
<!--#include file="_access_control_project.asp"-->
29
<%
30
'------------ Variable Definition -------------
31
'------------ Constants Declaration -----------
32
'------------ Variable Init -------------------
33
'----------------------------------------------
34
%>
35
<%
36
'--------------------------------------------------------------------------------------------------------------------------------------
37
Sub RemovePackage( )
129 ghuddy 38
   Dim ReturnCode
165 brianf 39
   Dim nPvId
40
   nPvId=Request("pv_id")
41
 
42
   Dim objRC: Set objRC = New ReleaseChanged
43
   Call objRC.Get_Package_Info (Request("rtag_id"),nPvId)
167 brianf 44
   Dim bReleased: bReleased = objRC.IsReleased(Request("rtag_id"),nPvId)
45
 
165 brianf 46
   OraDatabase.Parameters.Add "PV_ID",       nPvId,                  ORAPARM_INPUT, ORATYPE_NUMBER
129 ghuddy 47
   OraDatabase.Parameters.Add "RTAG_ID",     Request("rtag_id"),     ORAPARM_INPUT, ORATYPE_NUMBER
48
   OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId,ORAPARM_INPUT, ORATYPE_NUMBER
49
   OraDatabase.Parameters.Add "RETURN_CODE", NULL,                   ORAPARM_OUTPUT, ORATYPE_NUMBER
50
 
51
   If Request("btn") = "YES" Then
52
      ' Force Remove
53
      OraDatabase.Parameters.Add "FORCE_REMOVE", "Y", ORAPARM_INPUT, ORATYPE_NUMBER
54
 
55
   Else
56
      OraDatabase.Parameters.Add "FORCE_REMOVE", "N", ORAPARM_INPUT, ORATYPE_NUMBER
57
 
58
   End If
59
 
60
   objEH.TryORA ( OraSession )
61
   On Error Resume Next
62
 
63
   OraDatabase.ExecuteSQL _
165 brianf 64
   "BEGIN "&_
129 ghuddy 65
   "   :RETURN_CODE := PK_ENVIRONMENT.REMOVE_PACKAGE ( :PV_ID, :RTAG_ID, :USER_ID, :FORCE_REMOVE );"&_
66
   "END; "
67
 
68
   objEH.CatchORA ( OraSession )
69
 
70
   ReturnCode = OraDatabase.Parameters("RETURN_CODE").Value
71
 
72
   If ( ReturnCode <> 0 )  AND (Request("btn") <> "YES") Then
73
      'If (UserDetails ( "user_role" ) = "A") OR (UserDetails ( "user_role" ) = "S") Then
74
         ' Admin and System Admin users
75
         Call RaiseMsg ( enum_MSG_PACKAGE_IN_USE, Request("pv_id") &"|"& Request("rtag_id") &"|"& "_remove_package.asp")
76
 
77
      'Else
78
      '   ' Other users
79
      '   Call RaiseMsg ( enum_MSG_CANNOT_REMOVE_PACKAGE, Request("pv_id") &"|"& Request("rtag_id") &"|"& Request("envtab") &"|"& "_remove_packages.asp")
80
      '
81
      'End If
82
   End If
83
 
84
   OraDatabase.Parameters.Remove "PV_ID_LIST"
85
   OraDatabase.Parameters.Remove "RTAG_ID"
86
   OraDatabase.Parameters.Remove "USER_ID"
87
   OraDatabase.Parameters.Remove "FORCE_REMOVE"
88
   OraDatabase.Parameters.Remove "RETURN_CODE"
165 brianf 89
 
90
   If Not objEH.LastOraFailed Then
167 brianf 91
     If bReleased Then
92
       Call objRC.Run_ReleaseChanged(Request("rtag_id"),nPvId,enumRELEASE_CHANGE_MODE_PKG_REMOVED,false)
93
     End If  
165 brianf 94
   End If  
95
 
96
   Set objRC = Nothing
97
 
119 ghuddy 98
End Sub
99
'--------------------------------------------------------------------------------------------------------------------------------------
100
%>
101
<%
102
'-----------------------  MAIN LINE  ---------------------------
129 ghuddy 103
   On Error Resume Next
104
   objEH.Try
119 ghuddy 105
'--- Process submition ---
106
If (Request("pv_id") <> "")  AND (Request("rtag_id") <> "") Then
129 ghuddy 107
 
153 ghuddy 108
   If (DaemonInstructionPreventsEditing(Request("rtag_id"), Request("pv_id"))) Then
109
      Call RaiseMsg(enum_MSG_ERROR, "This package version has one or more daemon instructions present<br><br>"&_
110
                                    "Please delete them or allow them to be consumed before attempting to remove the package version from the release.")
111
   Else
112
      Call RemovePackage ()
129 ghuddy 113
 
153 ghuddy 114
      ' All mendatory parameters FOUND
115
      'If parBtn <> "NO" Then
116
      '
117
      '   retNOTRemove = -1
118
      '   Call CheckPackageInUse ( Request("pv_id"), QStrPar("rtag_id"), parBtn, retNOTRemove )
119
      '   Call Remove_Pkgs_From_Release( Format_MultiSelect_List( Request("pv_id") ), QStrPar("rtag_id"), retNOTRemove )
120
      '
121
      '
122
      '   If ( retNOTRemove <> -1 ) AND ( parBtn <> "YES" ) Then
123
      '      If (UserDetails ( "user_role" ) = "A") OR (UserDetails ( "user_role" ) = "S") Then
124
      '         ' Admin and System Admin users
125
      '         Call RaiseMsg ( enum_MSG_PACKAGE_IN_USE, Request("pv_id") &"|"& Request("rtag_id") &"|"& Request("envtab") &"|"& "_remove_packages.asp")
126
      '
127
      '      Else
128
      '         ' Other users
129
      '         Call RaiseMsg ( enum_MSG_CANNOT_REMOVE_PACKAGE, Request("pv_id") &"|"& Request("rtag_id") &"|"& Request("envtab") &"|"& "_remove_packages.asp")
130
      '
131
      '      End If
132
      '
133
      '   End If
134
      '
135
      'End If
129 ghuddy 136
 
137
 
138
 
153 ghuddy 139
      Response.Redirect("dependencies.asp?rtag_id="& Request("rtag_id") )
140
   End If
119 ghuddy 141
Else
129 ghuddy 142
         Err.Raise 8, "Please select the required package to delete."
143
   'Response.write "Some mandatory parameters are missing!" & "<br>" 'TODO
144
   'Response.write QSTR_All
119 ghuddy 145
End If
129 ghuddy 146
   objEH.Catch
119 ghuddy 147
%>
148
 
149
<!-- DESTRUCTOR ------->
129 ghuddy 150
<!--#include file="common/destructor.asp"-->