eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EC_DEBUG dependencies on EC_DEBUG

Line 1: PACKAGE BODY EC_DEBUG as

1: PACKAGE BODY EC_DEBUG as
2: /* $Header: ECDEBUGB.pls 120.2 2005/09/28 11:13:11 arsriniv ship $ */
3:
4: /* This procedure will enable debug messages. ie. the log file or the report
5: file of the concurrent request will have detailed messages to help the user

Line 46: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

42: nlength := (nlength + 80);
43: end loop;
44: exception
45: when others then
46: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
47: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
48: end SPLIT;
49:
50: /* This procedure populates the stack table with the program name and the

Line 47: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

43: end loop;
44: exception
45: when others then
46: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
47: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
48: end SPLIT;
49:
50: /* This procedure populates the stack table with the program name and the
51: time it started processing. */

Line 70: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

66: fnd_file.put_line(FND_FILE.LOG, INDENT_TEXT(1)|| 'Enter '||i_program_name||'->'||to_char(G_program_stack(ntbl_count).timestamp, 'DD-MON-YYYY HH24:MI:SS'));
67: end if;
68: exception
69: when others then
70: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
71: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
72: end PUSH;
73:
74: /* This procedure extracts data from the stack table and also provides the time

Line 71: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

67: end if;
68: exception
69: when others then
70: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
71: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
72: end PUSH;
73:
74: /* This procedure extracts data from the stack table and also provides the time
75: a program took to complete processing. */

Line 96: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

92: G_program_stack.DELETE(nposition);
93: end if;
94: exception
95: when others then
96: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
97: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
98: end POP;
99:
100: /* This function beautifies the output written to the log/report by adding the

Line 97: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

93: end if;
94: exception
95: when others then
96: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
97: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
98: end POP;
99:
100: /* This function beautifies the output written to the log/report by adding the
101: appropriate indentation. */

Line 118: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

114: return(vtemp_space);
115:
116: exception
117: when others then
118: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
119: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
120: end INDENT_TEXT;
121:
122: /* This is an overloaded procedure to set the tokens and retrieve the fnd

Line 119: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

115:
116: exception
117: when others then
118: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
119: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
120: end INDENT_TEXT;
121:
122: /* This is an overloaded procedure to set the tokens and retrieve the fnd
123: message and print it to the appropriate log/report file. */

Line 173: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

169: end if;
170:
171: exception
172: when others then
173: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
174: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
175: END PL;
176:
177: /* This is an overloaded procedure to split a message string into 132 character

Line 174: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

170:
171: exception
172: when others then
173: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
174: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
175: END PL;
176:
177: /* This is an overloaded procedure to split a message string into 132 character
178: strings. */

Line 192: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

188: SPLIT(i_string);
189: end if;
190: exception
191: when others then
192: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
193: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
194: END PL;
195:
196:

Line 193: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

189: end if;
190: exception
191: when others then
192: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
193: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
194: END PL;
195:
196:
197: /* This is an overloaded procedure to concatenate a given variable name and

Line 213: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

209: 'DD-MON-YYYY HH24:MI:SS'));
210: end if;
211: exception
212: when others then
213: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
214: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
215: end PL;
216:
217: /* This is an overloaded procedure to concatenate a given variable name and

Line 214: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

210: end if;
211: exception
212: when others then
213: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
214: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
215: end PL;
216:
217: /* This is an overloaded procedure to concatenate a given variable name and
218: the number value. */

Line 232: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

228: SPLIT(i_variable_name || G_separator || to_char(i_variable_value));
229: end if;
230: exception
231: when others then
232: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
233: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
234: end PL;
235:
236: /* This is an overloaded procedure to concatenate a given variable name and

Line 233: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

229: end if;
230: exception
231: when others then
232: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
233: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
234: end PL;
235:
236: /* This is an overloaded procedure to concatenate a given variable name and
237: the string value. */

Line 251: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

247: SPLIT(i_variable_name || G_separator || i_variable_value);
248: end if;
249: exception
250: when others then
251: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
252: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
253: end PL;
254:
255: /* This is an overloaded procedure to concatenate a given variable name and

Line 252: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

248: end if;
249: exception
250: when others then
251: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
252: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
253: end PL;
254:
255: /* This is an overloaded procedure to concatenate a given variable name and
256: the boolean value. */

Line 276: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

272: SPLIT(i_variable_name || G_separator || vtemp);
273: end if;
274: exception
275: when others then
276: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
277: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
278: end PL;
279:
280: /* This procedure finds a program_name in the stack table. */

Line 277: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

273: end if;
274: exception
275: when others then
276: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
277: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
278: end PL;
279:
280: /* This procedure finds a program_name in the stack table. */
281: PROCEDURE FIND_POS

Line 307: EC_DEBUG.PL(0,'EC','ECE_PLSQL_PROG_NAME','PROG_NAME', 'cIn_string');

303: end if;
304:
305: EXCEPTION
306: WHEN PROG_NOT_FOUND THEN
307: EC_DEBUG.PL(0,'EC','ECE_PLSQL_PROG_NAME','PROG_NAME', 'cIn_string');
308: app_exception.raise_exception;
309:
310: WHEN OTHERS THEN
311: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_DEBUG.FIND_POS');

Line 311: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_DEBUG.FIND_POS');

307: EC_DEBUG.PL(0,'EC','ECE_PLSQL_PROG_NAME','PROG_NAME', 'cIn_string');
308: app_exception.raise_exception;
309:
310: WHEN OTHERS THEN
311: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_DEBUG.FIND_POS');
312: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
313: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
314: app_exception.raise_exception;
315:

Line 312: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

308: app_exception.raise_exception;
309:
310: WHEN OTHERS THEN
311: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_DEBUG.FIND_POS');
312: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
313: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
314: app_exception.raise_exception;
315:
316: END FIND_POS;

Line 313: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

309:
310: WHEN OTHERS THEN
311: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_DEBUG.FIND_POS');
312: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
313: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
314: app_exception.raise_exception;
315:
316: END FIND_POS;
317:

Line 318: end EC_DEBUG;

314: app_exception.raise_exception;
315:
316: END FIND_POS;
317:
318: end EC_DEBUG;