[Home] [Help]
PACKAGE: APPS.ECX_DEBUG
Source
1 PACKAGE ECX_DEBUG AUTHID CURRENT_USER AS
2 -- $Header: ECXDEBGS.pls 120.6.12020000.3 2013/03/21 11:21:03 jmaddila ship $
3
4 TYPE prg_msg_stack_record IS RECORD(
5 message_text VARCHAR2(32000));
6
7 TYPE pl_stack_msg IS TABLE OF prg_msg_stack_record
8 INDEX BY BINARY_INTEGER;
9
10 g_debug_level PLS_INTEGER := 0;
11 g_file_name VARCHAR2(400);
12 g_file_path VARCHAR2(80);
13 g_sqlprefix VARCHAR2(200) := 'ecx.plsql.';
14 g_aflog_module_name VARCHAR2(2000) ;
15 g_message_stack pl_stack_msg;
16 g_separator VARCHAR2(3) := '==>';
17 g_use_cmanager_flag BOOLEAN := FALSE;
18 g_write_file_flag BOOLEAN := FALSE;
19 g_instlmode VARCHAR2(100);
20 g_procedure PLS_INTEGER;
21 g_statement PLS_INTEGER;
22 g_unexpected PLS_INTEGER;
23 g_procedureEnabled boolean;
24 g_statementEnabled boolean;
25 g_unexpectedEnabled boolean;
26 g_v_module_name varchar2(240) :='ecx.plsql.';
27 PROCEDURE enable_debug(i_level IN VARCHAR2 DEFAULT 0);
28
29 PROCEDURE enable_debug_new(p_level IN VARCHAR2 DEFAULT 0);
30
31 PROCEDURE enable_debug_new(
32 p_level IN VARCHAR2 DEFAULT 0,
33 p_file_path IN VARCHAR2,
34 p_file_name IN VARCHAR2,
35 p_aflog_module_name IN VARCHAR2);
36
37 PROCEDURE disable_debug;
38
39
40 --This procedure is for Inbound logging.This will be called after assigning all the respective global varables.
41 PROCEDURE module_enabled;
42 --This procedure is for Outbound logging. In Ecx_Outbound.Getxml this procedure will be called first to create the global virtual module name.
43 PROCEDURE module_enabled(p_message_standard IN VARCHAR2 ,p_transaction_type IN VARCHAR2,p_transaction_subtype IN VARCHAR2,p_document_id IN VARCHAR2);
44 --This procedure is for ecx_document.send and senddirect
45 PROCEDURE module_enabled(p_transaction_type IN VARCHAR2,p_transaction_subtype IN VARCHAR2,p_document_id IN VARCHAR2);
46 PROCEDURE split(i_string IN VARCHAR2);
47
48 PROCEDURE push(i_program_name IN VARCHAR2);
49
50 PROCEDURE pop(i_program_name IN VARCHAR2);
51
52 FUNCTION indent_text(i_main IN PLS_INTEGER DEFAULT 0) RETURN VARCHAR2;
53 --Stubbed versions of pl for bug 5055659
54 PROCEDURE pl(
55 i_level IN PLS_INTEGER DEFAULT 0,
56 i_app_short_name IN VARCHAR2,
57 i_message_name IN VARCHAR2,
58 i_token1 IN VARCHAR2 ,
59 i_value1 IN VARCHAR2 DEFAULT NULL,
60 i_token2 IN VARCHAR2 DEFAULT NULL,
61 i_value2 IN VARCHAR2 DEFAULT NULL,
62 i_token3 IN VARCHAR2 DEFAULT NULL,
63 i_value3 IN VARCHAR2 DEFAULT NULL,
64 i_token4 IN VARCHAR2 DEFAULT NULL,
65 i_value4 IN VARCHAR2 DEFAULT NULL,
66 i_token5 IN VARCHAR2 DEFAULT NULL,
67 i_value5 IN VARCHAR2 DEFAULT NULL,
68 i_token6 IN VARCHAR2 DEFAULT NULL,
69 i_value6 IN VARCHAR2 DEFAULT NULL);
70
71 PROCEDURE pl(i_level IN PLS_INTEGER,i_string IN VARCHAR2);
72
73 PROCEDURE pl(
74 i_level IN PLS_INTEGER,
75 i_variable_name IN VARCHAR2,
76 i_variable_value IN DATE);
77
78 PROCEDURE pl(
79 i_level IN PLS_INTEGER,
80 i_variable_name IN VARCHAR2,
81 i_variable_value IN NUMBER );
82
83 PROCEDURE pl(
84 i_level IN PLS_INTEGER,
85 i_variable_name IN VARCHAR2,
86 i_variable_value IN VARCHAR2);
87
88 PROCEDURE pl(
89 i_level IN PLS_INTEGER,
90 i_variable_name IN VARCHAR2,
91 i_variable_value IN BOOLEAN);
92 PROCEDURE pl(
93 i_level IN PLS_INTEGER,
94 i_variable_name IN VARCHAR2,
95 i_variable_value IN CLOB);
96
97 --End of stubbed versions
98
99 PROCEDURE log(
100 i_level IN PLS_INTEGER DEFAULT 0,
101 i_app_short_name IN VARCHAR2,
102 i_message_name IN VARCHAR2,
103 i_program_name IN VARCHAR2,
104 i_token1 IN VARCHAR2 ,
105 i_value1 IN VARCHAR2 DEFAULT NULL,
106 i_token2 IN VARCHAR2 DEFAULT NULL,
107 i_value2 IN VARCHAR2 DEFAULT NULL,
108 i_token3 IN VARCHAR2 DEFAULT NULL,
109 i_value3 IN VARCHAR2 DEFAULT NULL,
110 i_token4 IN VARCHAR2 DEFAULT NULL,
111 i_value4 IN VARCHAR2 DEFAULT NULL,
112 i_token5 IN VARCHAR2 DEFAULT NULL,
113 i_value5 IN VARCHAR2 DEFAULT NULL,
114 i_token6 IN VARCHAR2 DEFAULT NULL,
115 i_value6 IN VARCHAR2 DEFAULT NULL);
116
117
118 PROCEDURE log(i_level IN PLS_INTEGER,i_string IN VARCHAR2,
119 i_program_name IN VARCHAR2);
120
121 PROCEDURE log(
122 i_level IN PLS_INTEGER,
123 i_variable_name IN VARCHAR2,
124 i_variable_value IN DATE,
125 i_program_name IN VARCHAR2 );
126
127 PROCEDURE log(
128 i_level IN PLS_INTEGER,
129 i_variable_name IN VARCHAR2,
130 i_variable_value IN NUMBER,
131 i_program_name IN VARCHAR2 );
132
133 PROCEDURE log(
134 i_level IN PLS_INTEGER,
135 i_variable_name IN VARCHAR2,
136 i_variable_value IN VARCHAR2,
137 i_program_name IN VARCHAR2);
138
139 PROCEDURE log(
140 i_level IN PLS_INTEGER,
141 i_variable_name IN VARCHAR2,
142 i_variable_value IN BOOLEAN,
143 i_program_name IN VARCHAR2 );
144
145 PROCEDURE log(
146 i_level IN PLS_INTEGER,
147 i_variable_name IN VARCHAR2,
148 i_variable_value IN CLOB,
149 i_program_name IN VARCHAR2 );
150
151 PROCEDURE print_log;
152
153 PROCEDURE head(
154 p_output OUT NOCOPY VARCHAR2,
155 p_lines IN PLS_INTEGER DEFAULT 5,
156 p_delimiter IN VARCHAR2 DEFAULT ';');
157
158 PROCEDURE tail(
159 p_output OUT NOCOPY VARCHAR2,
160 p_lines IN PLS_INTEGER DEFAULT 5,
161 p_delimiter IN VARCHAR2 DEFAULT ';');
162
163 FUNCTION getTranslatedMessage(
164 i_message_name IN VARCHAR2,
165 i_token1 IN VARCHAR2 DEFAULT NULL,
166 i_value1 IN VARCHAR2 DEFAULT NULL,
167 i_token2 IN VARCHAR2 DEFAULT NULL,
168 i_value2 IN VARCHAR2 DEFAULT NULL,
169 i_token3 IN VARCHAR2 DEFAULT NULL,
170 i_value3 IN VARCHAR2 DEFAULT NULL,
171 i_token4 IN VARCHAR2 DEFAULT NULL,
172 i_value4 IN VARCHAR2 DEFAULT NULL,
173 i_token5 IN VARCHAR2 DEFAULT NULL,
174 i_value5 IN VARCHAR2 DEFAULT NULL,
175 i_token6 IN VARCHAR2 DEFAULT NULL,
176 i_value6 IN VARCHAR2 DEFAULT NULL,
177 i_token7 IN VARCHAR2 DEFAULT NULL,
178 i_value7 IN VARCHAR2 DEFAULT NULL,
179 i_token8 IN VARCHAR2 DEFAULT NULL,
180 i_value8 IN VARCHAR2 DEFAULT NULL,
181 i_token9 IN VARCHAR2 DEFAULT NULL,
182 i_value9 IN VARCHAR2 DEFAULT NULL,
183 i_token10 IN VARCHAR2 DEFAULT NULL,
184 i_value10 IN VARCHAR2 DEFAULT NULL) return varchar2;
185
186
187 /* sets ecx_utils.i_errbuf and the message parameters and values associated*/
188 /* with the message in ecx_utils.i_errbuf */
189 procedure setMessage(
190 p_message_name in varchar2,
191 p_token1 in varchar2 default null,
192 p_value1 in varchar2 default null,
193 p_token2 in varchar2 default null,
194 p_value2 in varchar2 default null,
195 p_token3 in varchar2 default null,
196 p_value3 in varchar2 default null,
197 p_token4 in varchar2 default null,
198 p_value4 in varchar2 default null,
199 p_token5 in varchar2 default null,
200 p_value5 in varchar2 default null,
201 p_token6 in varchar2 default null,
202 p_value6 in varchar2 default null,
203 p_token7 in varchar2 default null,
204 p_value7 in varchar2 default null,
205 p_token8 in varchar2 default null,
206 p_value8 in varchar2 default null,
207 p_token9 in varchar2 default null,
208 p_value9 in varchar2 default null,
209 p_token10 in varchar2 default null,
210 p_value10 in varchar2 default null);
211
212 /* sets the global variables: ecx_utils.error_type, ecx_utils.i_ret_code, */
213 /* ecx_utils.i_errbuf and the message parameters and values associated */
214 /* with the message in ecx_utils.i_errbuf */
215
216 procedure setErrorInfo(
217 p_error_code in pls_integer,
218 p_error_type in pls_integer,
219 p_errmsg_name in varchar2,
220 p_token1 in varchar2 default null,
221 p_value1 in varchar2 default null,
222 p_token2 in varchar2 default null,
223 p_value2 in varchar2 default null,
224 p_token3 in varchar2 default null,
225 p_value3 in varchar2 default null,
226 p_token4 in varchar2 default null,
227 p_value4 in varchar2 default null,
228 p_token5 in varchar2 default null,
229 p_value5 in varchar2 default null,
230 p_token6 in varchar2 default null,
231 p_value6 in varchar2 default null,
232 p_token7 in varchar2 default null,
233 p_value7 in varchar2 default null,
234 p_token8 in varchar2 default null,
235 p_value8 in varchar2 default null,
236 p_token9 in varchar2 default null,
237 p_value9 in varchar2 default null,
238 p_token10 in varchar2 default null,
239 p_value10 in varchar2 default null);
240
241 /* Returns translated message based on current userenv('LANG') */
242 FUNCTION getMessage(
243 p_message_name IN VARCHAR2,
244 p_message_params IN VARCHAR2 default null) return varchar2;
245
246
247 PROCEDURE getDebugLevels(l_statement OUT NOCOPY integer,l_procedure OUT NOCOPY integer);
248
249 PROCEDURE print_debug_spool(p_debug_array IN ECX_DBG_ARRAY_TYPE);
250
251 /*
252 *This procedure is to append given log messages to existing log (for given module name)
253 *bug16442475
254 */
255 PROCEDURE log(p_module IN VARCHAR2,p_msgs IN FND_TABLE_OF_VARCHAR2_4000);
256 END ECX_DEBUG;
257