1 PACKAGE CZ_UTILS AUTHID CURRENT_USER AS
2 /* $Header: czcutils.pls 120.2 2006/01/18 04:23:49 amdixit ship $ */
3
4 nDebugLevel CZ_DB_SETTINGS.VALUE%TYPE:=NULL;
5 nReportLevel CZ_DB_SETTINGS.VALUE%TYPE:=1;
6 EPOCH_BEGIN_ DATE:=TO_DATE('12/1/109','MM/DD/YYYY');
7 EPOCH_END_ DATE:=TO_DATE('1/31/4711','MM/DD/YYYY');
8
9 FUNCTION LOG_REPORT (Msg in VARCHAR2, Urgency in NUMBER, ByCaller in VARCHAR2,
10 StatusCode in NUMBER) RETURN BOOLEAN;
11
12 FUNCTION LOG_REPORT (Msg in VARCHAR2, Urgency in NUMBER, ByCaller in VARCHAR2,
13 StatusCode in NUMBER, RunId in NUMBER) RETURN BOOLEAN;
14
15 FUNCTION REPORT (Msg in VARCHAR2, Urgency in NUMBER, ByCaller in VARCHAR2,
16 StatusCode in NUMBER) RETURN BOOLEAN;
17
18 FUNCTION TODATE (fromString in VARCHAR2) return DATE;
19 PRAGMA RESTRICT_REFERENCES (TODATE, WNDS, WNPS);
20
21 FUNCTION EPOCH_BEGIN RETURN DATE;
22 pragma restrict_references(EPOCH_BEGIN, wnds, wnps, rnds);
23
24 FUNCTION EPOCH_END RETURN DATE;
25 pragma restrict_references(EPOCH_END, wnds, wnps, rnds);
26
27 FUNCTION GET_PK_USEEXPANSION_FLAG(TABLE_NAME IN VARCHAR2,
28 inXFR_GROUP IN VARCHAR2)
29 RETURN NUMBER;
30
31 FUNCTION GET_NOUPDATE_FLAG(TABLE_NAME IN VARCHAR2,
32 COLUMN_NAME IN VARCHAR2,
33 inXFR_GROUP IN VARCHAR2)
34 RETURN NUMBER;
35
36 FUNCTION ISNUM(nVALUE IN VARCHAR2) RETURN BOOLEAN;
37
38 PROCEDURE GET_USER_NAME(forSPXID IN NUMBER, outNAME OUT NOCOPY VARCHAR2);
39
40 FUNCTION CONV_NUM(str VARCHAR2) return NUMBER;
41 pragma restrict_references(conv_num, wnds, wnps, rnds, rnps);
42
43 FUNCTION CONV_NUM(str VARCHAR2, format VARCHAR2) return number;
44 pragma restrict_references(conv_num, wnds, wnps, rnds, rnps);
45
46 FUNCTION SPX_UID RETURN INTEGER;
47 PRAGMA RESTRICT_REFERENCES (SPX_UID, WNDS, WNPS);
48
49 FUNCTION SPX_LOGIN_TYPE RETURN CHAR;
50 PRAGMA RESTRICT_REFERENCES (SPX_LOGIN_TYPE, WNDS, WNPS);
51
52 FUNCTION GET_TEXT(inMessageName IN VARCHAR2) RETURN VARCHAR2;
53 FUNCTION GET_TEXT(inMessageName IN VARCHAR2,
54 inToken1 IN VARCHAR2, inValue1 IN VARCHAR2) RETURN VARCHAR2;
55 FUNCTION GET_TEXT(inMessageName IN VARCHAR2,
56 inToken1 IN VARCHAR2, inValue1 IN VARCHAR2,
57 inToken2 IN VARCHAR2, inValue2 IN VARCHAR2) RETURN VARCHAR2;
58 FUNCTION GET_TEXT(inMessageName IN VARCHAR2,
59 inToken1 IN VARCHAR2, inValue1 IN VARCHAR2,
60 inToken2 IN VARCHAR2, inValue2 IN VARCHAR2,
61 inToken3 IN VARCHAR2, inValue3 IN VARCHAR2) RETURN VARCHAR2;
62 FUNCTION GET_TEXT(inMessageName IN VARCHAR2,
63 inToken1 IN VARCHAR2, inValue1 IN VARCHAR2,
64 inToken2 IN VARCHAR2, inValue2 IN VARCHAR2,
65 inToken3 IN VARCHAR2, inValue3 IN VARCHAR2,
66 inToken4 IN VARCHAR2, inValue4 IN VARCHAR2) RETURN VARCHAR2;
67 FUNCTION GET_TEXT(inMessageName IN VARCHAR2,
68 inToken1 IN VARCHAR2, inValue1 IN VARCHAR2,
69 inToken2 IN VARCHAR2, inValue2 IN VARCHAR2,
70 inToken3 IN VARCHAR2, inValue3 IN VARCHAR2,
71 inToken4 IN VARCHAR2, inValue4 IN VARCHAR2,
72 inToken5 IN VARCHAR2, inValue5 IN VARCHAR2) RETURN VARCHAR2;
73 FUNCTION GET_TEXT(inMessageName IN VARCHAR2,
74 inToken1 IN VARCHAR2, inValue1 IN VARCHAR2,
75 inToken2 IN VARCHAR2, inValue2 IN VARCHAR2,
76 inToken3 IN VARCHAR2, inValue3 IN VARCHAR2,
77 inToken4 IN VARCHAR2, inValue4 IN VARCHAR2,
78 inToken5 IN VARCHAR2, inValue5 IN VARCHAR2,
79 inToken6 IN VARCHAR2, inValue6 IN VARCHAR2) RETURN VARCHAR2;
80
81 FUNCTION check_installed_lang(p_server_id IN NUMBER) RETURN NUMBER;
82
83 PROCEDURE report_html_tags;
84
85 PROCEDURE LOG_REPORT (p_pkg_name VARCHAR2,
86 p_routine VARCHAR2,
87 p_ndebug NUMBER,
88 p_msg VARCHAR2,
89 p_log_level NUMBER);
90
91 FUNCTION retrieve_db_link(p_server_id IN PLS_INTEGER)
92 RETURN VARCHAR2;
93
94 /* use this procedure to add an error message
95 to the stack. In some cases, the return status needs to be set,
96 use the statement x_return_status := FND_API.G_RET_STS_ERROR;
97 to set the error condition before calling this routine
98 */
99
100 PROCEDURE add_error_message_to_stack(p_message_name IN VARCHAR2,
101 p_token_name1 IN VARCHAR2 ,
102 p_token_value1 IN VARCHAR2 ,
103 p_token_name2 IN VARCHAR2 ,
104 p_token_value2 IN VARCHAR2 ,
105 p_token_name3 IN VARCHAR2 ,
106 p_token_value3 IN VARCHAR2 ,
107 x_msg_count IN OUT NOCOPY NUMBER,
108 x_msg_data IN OUT NOCOPY VARCHAR2);
109
110 PROCEDURE add_error_message_to_stack(p_message_name IN VARCHAR2,
111 p_token_name1 IN VARCHAR2 ,
112 p_token_value1 IN VARCHAR2 ,
113 x_msg_count IN OUT NOCOPY NUMBER,
114 x_msg_data IN OUT NOCOPY VARCHAR2);
115
116
117 PROCEDURE add_error_message_to_stack(p_message_name IN VARCHAR2,
118 p_token_name1 IN VARCHAR2 ,
119 p_token_value1 IN VARCHAR2 ,
120 p_token_name2 IN VARCHAR2 ,
121 p_token_value2 IN VARCHAR2 ,
122 x_msg_count IN OUT NOCOPY NUMBER,
123 x_msg_data IN OUT NOCOPY VARCHAR2);
124
125
126 /* use this procedure to add an error message
127 to the stack. In some cases, the return status needs to be set,
128 use the statement return_status := FND_API.G_RET_STS_ERROR, and
129 add msg_count := 1 to initialize the message coutnt
130 to set the error condition before calling this routine
131 */
132
133 PROCEDURE add_exc_msg_to_fndstack
134 (p_package_name IN VARCHAR2,
135 p_procedure_name IN VARCHAR2,
136 p_error_message IN VARCHAR2);
137
138 END CZ_UTILS;