Subversion Repositories DevTools

Rev

Rev 5514 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
62 rsolanki 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|			          Log Download				 	 |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
Response.Expires = 0	' always load the page, dont store
12
%>
13
<!--#include file="common/globals.asp"-->
14
<!--#include file="common/config.asp"-->
15
<!--#include file="common/common_subs.asp"-->
16
<!--#include file="common/_popup_window_common.asp"-->
17
 
18
<%
19
'------------ VARIABLE DEFINITION -------------
20
'------------ CONSTANTS DECLARATION -----------
21
'------------ VARIABLE INIT -------------------
22
'------------ CONDITIONS ----------------------
23
'----------------------------------------------
24
%>
25
<%
26
'--------------------------------------------------------------------------------------------------------------------------
27
 
28
'--------------------------------------------------------------------------------------------------------------------------
29
%>
30
<%
31
'**************************** M  A  I  N ******************************
32
 
33
If Request("pkg_id") <> "" Then
34
 
35
	OraDatabase.Parameters.Add "PKG_ID", 	  Request("pkg_id"), 		ORAPARM_INPUT, ORATYPE_NUMBER
36
	OraDatabase.Parameters.Add "USER_ID", 	  objAccessControl.UserId, 		ORAPARM_INPUT, ORATYPE_NUMBER
37
	OraDatabase.Parameters.Add "COMMENT", 	  "Downloaded package version "&Request("pkg_version"), 		ORAPARM_INPUT, ORATYPE_NUMBER
38
 
5962 dpurdie 39
	On Error Resume Next
62 rsolanki 40
	objEH.TryORA ( OraSession )
41
 
42
	OraDatabase.ExecuteSQL _
43
	"BEGIN   pk_production.Log_Pkg_Trail ( :PKG_ID, :COMMENT, :USER_ID  );   END;"
44
 
45
	objEH.CatchORA ( OraSession )
46
 
47
	OraDatabase.Parameters.Remove "PKG_ID"	
48
	OraDatabase.Parameters.Remove "USER_ID"	
49
	OraDatabase.Parameters.Remove "COMMENT"	
50
 
51
Else
52
	Response.write "There is an error in download logging."
53
End If
54
 
55
	If objEH.Finally Then
56
		Call OpenInParentWindow (Request("url"))
57
		Call CloseWindow
58
	End If				
59
'**********************************************************************
5962 dpurdie 60
Call Destroy_All_Objects
62 rsolanki 61
%>
62