PACKAGE: APPS.ICX_POR_EXT_UTL

Source

1 PACKAGE ICX_POR_EXT_UTL AUTHID CURRENT_USER AS
2 /* $Header: ICXEXTUS.pls 120.1 2006/01/10 11:58:58 sbgeorge noship $*/
3 
4 
5 NOLOG_LEVEL     	PLS_INTEGER := -1;
6 MUST_LEVEL		PLS_INTEGER := 0;
7 ERROR_LEVEL		PLS_INTEGER := 1;
8 ANLYS_LEVEL		PLS_INTEGER := 2;
9 INFO_LEVEL		PLS_INTEGER := 3;
10 DEBUG_LEVEL		PLS_INTEGER := 4;
11 DETIL_LEVEL     	PLS_INTEGER := 100;
12 
13 gDebugLevel     	PLS_INTEGER := INFO_LEVEL;
14 
15 USE_FILE_SYSTEM		PLS_INTEGER := 1;
16 USE_CONCURRENT_LOG	PLS_INTEGER := 0;
17 
18 UTL_FILE_DIR		VARCHAR2(20) := 'UTL_FILE_DIR';
19 
20 gCommitSize  		PLS_INTEGER := 5000;
21 
22 gFatalException 	EXCEPTION;
23 gException 		EXCEPTION;
24 
25 -- PCREDDY: Bug # 3488764: Error message for file open error
26 UTL_FILE_ERR_MSG        VARCHAR2(1000) := fnd_global.newline ||
27   '=============================================================================' ||
28   fnd_global.newline ||
29   'Unable to write the debug messages to the log file.' ||
30   fnd_global.newline ||
31   'FIX:' ||
32   fnd_global.newline ||
33   'Ensure that the virtual path assigned to the ' ||
34   'APPLPTMP environment variable is valid, writable, and is referenced ' ||
35   'at the beginning of the UTL_FILE_DIR database parameter in init.ora.' ||
36   fnd_global.newline ||
37   '=============================================================================' ||
38   fnd_global.newline;
39 
40 PROCEDURE setDebugLevel(pLevel	IN PLS_INTEGER);
41 PROCEDURE debug(pLevel		IN PLS_INTEGER,
42                 pMsg		IN VARCHAR2) ;
43 PROCEDURE debug(pMsg		IN VARCHAR2) ;
44 
45 PROCEDURE pushError(pMsg	IN VARCHAR2);
46 PROCEDURE printStackTrace;
47 
48 PROCEDURE setFilePath(pFilePath	IN VARCHAR2 DEFAULT UTL_FILE_DIR);
49 FUNCTION  getFilePath RETURN VARCHAR2;
50 PROCEDURE setUseFile(pUseFile	IN PLS_INTEGER DEFAULT USE_FILE_SYSTEM);
51 PROCEDURE openLog(pFileName	IN varchar2,
52                   pOpenMode	IN varchar2 DEFAULT 'w');
53 PROCEDURE closeLog;
54 
55 PROCEDURE extCommit;
56 PROCEDURE extAFCommit;
57 PROCEDURE extRollback;
58 
59 FUNCTION getTableElement(pTable	IN DBMS_SQL.NUMBER_TABLE,
60                          pIndex IN BINARY_INTEGER)
61   RETURN VARCHAR2;
62 
63 FUNCTION getTableElement(pTable	IN DBMS_SQL.VARCHAR2_TABLE,
64                          pIndex IN BINARY_INTEGER)
65   RETURN VARCHAR2;
66 
67 FUNCTION getTableElement(pTable	IN DBMS_SQL.UROWID_TABLE,
68                          pIndex IN BINARY_INTEGER)
69   RETURN VARCHAR2;
70 
71 FUNCTION getTableElement(pTable	IN DBMS_SQL.DATE_TABLE,
72                          pIndex IN BINARY_INTEGER)
73   RETURN VARCHAR2;
74 
75 FUNCTION getIcxSchema RETURN VARCHAR2;
76 
77 FUNCTION getTimeStamp RETURN VARCHAR2;
78 
79 FUNCTION getDatabaseVersion RETURN NUMBER;
80 
81 END ICX_POR_EXT_UTL;