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.ECX_ERRORLOG dependencies on ECX_DEBUG

Line 8: l_procedure PLS_INTEGER := ecx_debug.g_procedure;

4: cursor c_ecx_errorno
5: is
6: select ecx_error_no_s.nextval
7: from dual;
8: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
9: l_statement PLS_INTEGER := ecx_debug.g_statement;
10: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
11: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
12: l_statementEnabled boolean := ecx_debug.g_statementEnabled;

Line 9: l_statement PLS_INTEGER := ecx_debug.g_statement;

5: is
6: select ecx_error_no_s.nextval
7: from dual;
8: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
9: l_statement PLS_INTEGER := ecx_debug.g_statement;
10: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
11: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
12: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
13: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;

Line 10: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;

6: select ecx_error_no_s.nextval
7: from dual;
8: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
9: l_statement PLS_INTEGER := ecx_debug.g_statement;
10: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
11: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
12: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
13: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
14:

Line 11: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;

7: from dual;
8: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
9: l_statement PLS_INTEGER := ecx_debug.g_statement;
10: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
11: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
12: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
13: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
14:
15: procedure outbound_engine

Line 12: l_statementEnabled boolean := ecx_debug.g_statementEnabled;

8: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
9: l_statement PLS_INTEGER := ecx_debug.g_statement;
10: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
11: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
12: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
13: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
14:
15: procedure outbound_engine
16: (

Line 13: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;

9: l_statement PLS_INTEGER := ecx_debug.g_statement;
10: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
11: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
12: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
13: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
14:
15: procedure outbound_engine
16: (
17: i_trigger_id IN number,

Line 233: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'otacb_'||i_outmsgid||'.log', 'otacb_'||i_outmsgid||'.log');

229: begin
230:
231: --- Sets the Log Directory in both Standalone and the Embedded mode
232: ecx_utils.getLogDirectory;
233: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'otacb_'||i_outmsgid||'.log', 'otacb_'||i_outmsgid||'.log');
234:
235: /* Assign local variables with the ecx_debug global variables*/
236: l_procedure := ecx_debug.g_procedure;
237: l_statement := ecx_debug.g_statement;

Line 235: /* Assign local variables with the ecx_debug global variables*/

231: --- Sets the Log Directory in both Standalone and the Embedded mode
232: ecx_utils.getLogDirectory;
233: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'otacb_'||i_outmsgid||'.log', 'otacb_'||i_outmsgid||'.log');
234:
235: /* Assign local variables with the ecx_debug global variables*/
236: l_procedure := ecx_debug.g_procedure;
237: l_statement := ecx_debug.g_statement;
238: l_unexpected := ecx_debug.g_unexpected;
239: l_procedureEnabled := ecx_debug.g_procedureEnabled;

Line 236: l_procedure := ecx_debug.g_procedure;

232: ecx_utils.getLogDirectory;
233: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'otacb_'||i_outmsgid||'.log', 'otacb_'||i_outmsgid||'.log');
234:
235: /* Assign local variables with the ecx_debug global variables*/
236: l_procedure := ecx_debug.g_procedure;
237: l_statement := ecx_debug.g_statement;
238: l_unexpected := ecx_debug.g_unexpected;
239: l_procedureEnabled := ecx_debug.g_procedureEnabled;
240: l_statementEnabled := ecx_debug.g_statementEnabled;

Line 237: l_statement := ecx_debug.g_statement;

233: ecx_debug.enable_debug_new(debug_mode, ecx_utils.g_logdir, 'otacb_'||i_outmsgid||'.log', 'otacb_'||i_outmsgid||'.log');
234:
235: /* Assign local variables with the ecx_debug global variables*/
236: l_procedure := ecx_debug.g_procedure;
237: l_statement := ecx_debug.g_statement;
238: l_unexpected := ecx_debug.g_unexpected;
239: l_procedureEnabled := ecx_debug.g_procedureEnabled;
240: l_statementEnabled := ecx_debug.g_statementEnabled;
241: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;

Line 238: l_unexpected := ecx_debug.g_unexpected;

234:
235: /* Assign local variables with the ecx_debug global variables*/
236: l_procedure := ecx_debug.g_procedure;
237: l_statement := ecx_debug.g_statement;
238: l_unexpected := ecx_debug.g_unexpected;
239: l_procedureEnabled := ecx_debug.g_procedureEnabled;
240: l_statementEnabled := ecx_debug.g_statementEnabled;
241: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
242:

Line 239: l_procedureEnabled := ecx_debug.g_procedureEnabled;

235: /* Assign local variables with the ecx_debug global variables*/
236: l_procedure := ecx_debug.g_procedure;
237: l_statement := ecx_debug.g_statement;
238: l_unexpected := ecx_debug.g_unexpected;
239: l_procedureEnabled := ecx_debug.g_procedureEnabled;
240: l_statementEnabled := ecx_debug.g_statementEnabled;
241: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
242:
243: if (l_procedureEnabled) then

Line 240: l_statementEnabled := ecx_debug.g_statementEnabled;

236: l_procedure := ecx_debug.g_procedure;
237: l_statement := ecx_debug.g_statement;
238: l_unexpected := ecx_debug.g_unexpected;
239: l_procedureEnabled := ecx_debug.g_procedureEnabled;
240: l_statementEnabled := ecx_debug.g_statementEnabled;
241: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
242:
243: if (l_procedureEnabled) then
244: ecx_debug.push(i_method_name);

Line 241: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;

237: l_statement := ecx_debug.g_statement;
238: l_unexpected := ecx_debug.g_unexpected;
239: l_procedureEnabled := ecx_debug.g_procedureEnabled;
240: l_statementEnabled := ecx_debug.g_statementEnabled;
241: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
242:
243: if (l_procedureEnabled) then
244: ecx_debug.push(i_method_name);
245: end if;

Line 244: ecx_debug.push(i_method_name);

240: l_statementEnabled := ecx_debug.g_statementEnabled;
241: l_unexpectedEnabled := ecx_debug.g_unexpectedEnabled;
242:
243: if (l_procedureEnabled) then
244: ecx_debug.push(i_method_name);
245: end if;
246:
247: if i_outmsgid is null
248: then

Line 320: ecx_debug.log(l_statement,'ecx_errorlog.external_system- callback to Workflow Code',

316: /* End of Bug 2167164 */
317:
318: /** Begin of the Bug 1999883 Callback to Workflow Routine **/
319: if(l_statementEnabled) then
320: ecx_debug.log(l_statement,'ecx_errorlog.external_system- callback to Workflow Code',
321: i_method_name);
322: ecx_debug.log(l_statement,'i_outmsgid',i_outmsgid,i_method_name);
323: end if;
324:

Line 322: ecx_debug.log(l_statement,'i_outmsgid',i_outmsgid,i_method_name);

318: /** Begin of the Bug 1999883 Callback to Workflow Routine **/
319: if(l_statementEnabled) then
320: ecx_debug.log(l_statement,'ecx_errorlog.external_system- callback to Workflow Code',
321: i_method_name);
322: ecx_debug.log(l_statement,'i_outmsgid',i_outmsgid,i_method_name);
323: end if;
324:
325: Begin
326: Select count(*)

Line 384: ecx_debug.log(l_statement,'i_event_name',i_event_name,i_method_name);

380: raise;
381: end;
382:
383: if(l_statementEnabled) then
384: ecx_debug.log(l_statement,'i_event_name',i_event_name,i_method_name);
385: ecx_debug.log(l_statement,'i_event_key',i_event_key,i_method_name);
386: ecx_debug.log(l_statement,'i_block_mode',i_block_mode,i_method_name);
387: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);

Line 385: ecx_debug.log(l_statement,'i_event_key',i_event_key,i_method_name);

381: end;
382:
383: if(l_statementEnabled) then
384: ecx_debug.log(l_statement,'i_event_name',i_event_name,i_method_name);
385: ecx_debug.log(l_statement,'i_event_key',i_event_key,i_method_name);
386: ecx_debug.log(l_statement,'i_block_mode',i_block_mode,i_method_name);
387: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);

Line 386: ecx_debug.log(l_statement,'i_block_mode',i_block_mode,i_method_name);

382:
383: if(l_statementEnabled) then
384: ecx_debug.log(l_statement,'i_event_name',i_event_name,i_method_name);
385: ecx_debug.log(l_statement,'i_event_key',i_event_key,i_method_name);
386: ecx_debug.log(l_statement,'i_block_mode',i_block_mode,i_method_name);
387: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);

Line 387: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);

383: if(l_statementEnabled) then
384: ecx_debug.log(l_statement,'i_event_name',i_event_name,i_method_name);
385: ecx_debug.log(l_statement,'i_event_key',i_event_key,i_method_name);
386: ecx_debug.log(l_statement,'i_block_mode',i_block_mode,i_method_name);
387: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);

Line 388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);

384: ecx_debug.log(l_statement,'i_event_name',i_event_name,i_method_name);
385: ecx_debug.log(l_statement,'i_event_key',i_event_key,i_method_name);
386: ecx_debug.log(l_statement,'i_block_mode',i_block_mode,i_method_name);
387: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);
392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);

Line 389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);

385: ecx_debug.log(l_statement,'i_event_key',i_event_key,i_method_name);
386: ecx_debug.log(l_statement,'i_block_mode',i_block_mode,i_method_name);
387: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);
392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);

Line 390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);

386: ecx_debug.log(l_statement,'i_block_mode',i_block_mode,i_method_name);
387: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);
392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);

Line 391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);

387: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);
392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);
395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);

Line 392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);

388: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);
392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);
395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);
396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);

Line 393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);

389: ecx_debug.log(l_statement,'i_party_site_id',i_party_site_id,i_method_name);
390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);
392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);
395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);
396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);

Line 394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);

390: ecx_debug.log(l_statement,'i_msgid',i_msgid,i_method_name);
391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);
392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);
395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);
396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);
398: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name);

Line 395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);

391: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name);
392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);
395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);
396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);
398: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name);
399: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name);

Line 396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);

392: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);
395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);
396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);
398: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name);
399: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name);
400: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name);

Line 397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);

393: ecx_debug.log(l_statement,'i_document_number',i_document_number,i_method_name);
394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);
395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);
396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);
398: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name);
399: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name);
400: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name);
401: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name);

Line 398: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name);

394: ecx_debug.log(l_statement,'i_protocol_type',i_protocol_Type,i_method_name);
395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);
396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);
398: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name);
399: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name);
400: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name);
401: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name);
402: end if;

Line 399: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name);

395: ecx_debug.log(l_statement,'i_protocol_address',i_protocol_address,i_method_name);
396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);
398: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name);
399: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name);
400: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name);
401: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name);
402: end if;
403:

Line 400: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name);

396: ecx_debug.log(l_statement,'i_username',i_username,i_method_name);
397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);
398: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name);
399: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name);
400: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name);
401: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name);
402: end if;
403:
404: i_err_code := i_errmsg;

Line 401: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name);

397: ecx_debug.log(l_statement,'i_attribute1',i_attribute1,i_method_name);
398: ecx_debug.log(l_statement,'i_attribute2',i_attribute2,i_method_name);
399: ecx_debug.log(l_statement,'i_attribute3',i_attribute3,i_method_name);
400: ecx_debug.log(l_statement,'i_attribute4',i_attribute4,i_method_name);
401: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name);
402: end if;
403:
404: i_err_code := i_errmsg;
405: i_text_val := ecx_debug.getMessage(i_errmsg);

Line 405: i_text_val := ecx_debug.getMessage(i_errmsg);

401: ecx_debug.log(l_statement,'i_attribute5',i_attribute5,i_method_name);
402: end if;
403:
404: i_err_code := i_errmsg;
405: i_text_val := ecx_debug.getMessage(i_errmsg);
406: i_num_val := i_status;
407:
408: ---- Raise a custom Event
409:

Line 477: ecx_debug.log(l_statement,'Raising the Customized event', i_event_name,

473: p_parameterlist => i_params);
474:
475:
476: if(l_statementEnabled) then
477: ecx_debug.log(l_statement,'Raising the Customized event', i_event_name,
478: i_method_name);
479: end if;
480: i_random_value := wf_core.random;
481: i_event_key := i_event_key||i_random_value;

Line 498: ecx_debug.log(l_statement,'i_command',i_command,i_method_name);

494: wf_core.error_name := i_command;
495: wf_core.error_message := i_text_val;
496:
497: if(l_statementEnabled) then
498: ecx_debug.log(l_statement,'i_command',i_command,i_method_name);
499: ecx_debug.log(l_statement,'i_errmsg',i_errmsg,i_method_name);
500: ecx_debug.log(l_statement,'i_status',i_status,i_method_name);
501: ecx_debug.log(l_statement,'i_text_val',i_text_val,i_method_name);
502: ecx_debug.log(l_statement,'i_num_val',i_num_val,i_method_name);

Line 499: ecx_debug.log(l_statement,'i_errmsg',i_errmsg,i_method_name);

495: wf_core.error_message := i_text_val;
496:
497: if(l_statementEnabled) then
498: ecx_debug.log(l_statement,'i_command',i_command,i_method_name);
499: ecx_debug.log(l_statement,'i_errmsg',i_errmsg,i_method_name);
500: ecx_debug.log(l_statement,'i_status',i_status,i_method_name);
501: ecx_debug.log(l_statement,'i_text_val',i_text_val,i_method_name);
502: ecx_debug.log(l_statement,'i_num_val',i_num_val,i_method_name);
503: ecx_debug.log(l_statement,'i_item_type',i_item_type,i_method_name);

Line 500: ecx_debug.log(l_statement,'i_status',i_status,i_method_name);

496:
497: if(l_statementEnabled) then
498: ecx_debug.log(l_statement,'i_command',i_command,i_method_name);
499: ecx_debug.log(l_statement,'i_errmsg',i_errmsg,i_method_name);
500: ecx_debug.log(l_statement,'i_status',i_status,i_method_name);
501: ecx_debug.log(l_statement,'i_text_val',i_text_val,i_method_name);
502: ecx_debug.log(l_statement,'i_num_val',i_num_val,i_method_name);
503: ecx_debug.log(l_statement,'i_item_type',i_item_type,i_method_name);
504: ecx_debug.log(l_statement,'i_item_key',i_item_key,i_method_name);

Line 501: ecx_debug.log(l_statement,'i_text_val',i_text_val,i_method_name);

497: if(l_statementEnabled) then
498: ecx_debug.log(l_statement,'i_command',i_command,i_method_name);
499: ecx_debug.log(l_statement,'i_errmsg',i_errmsg,i_method_name);
500: ecx_debug.log(l_statement,'i_status',i_status,i_method_name);
501: ecx_debug.log(l_statement,'i_text_val',i_text_val,i_method_name);
502: ecx_debug.log(l_statement,'i_num_val',i_num_val,i_method_name);
503: ecx_debug.log(l_statement,'i_item_type',i_item_type,i_method_name);
504: ecx_debug.log(l_statement,'i_item_key',i_item_key,i_method_name);
505: ecx_debug.log(l_statement,'i_activity_id',i_activity_id,i_method_name);

Line 502: ecx_debug.log(l_statement,'i_num_val',i_num_val,i_method_name);

498: ecx_debug.log(l_statement,'i_command',i_command,i_method_name);
499: ecx_debug.log(l_statement,'i_errmsg',i_errmsg,i_method_name);
500: ecx_debug.log(l_statement,'i_status',i_status,i_method_name);
501: ecx_debug.log(l_statement,'i_text_val',i_text_val,i_method_name);
502: ecx_debug.log(l_statement,'i_num_val',i_num_val,i_method_name);
503: ecx_debug.log(l_statement,'i_item_type',i_item_type,i_method_name);
504: ecx_debug.log(l_statement,'i_item_key',i_item_key,i_method_name);
505: ecx_debug.log(l_statement,'i_activity_id',i_activity_id,i_method_name);
506: end if;

Line 503: ecx_debug.log(l_statement,'i_item_type',i_item_type,i_method_name);

499: ecx_debug.log(l_statement,'i_errmsg',i_errmsg,i_method_name);
500: ecx_debug.log(l_statement,'i_status',i_status,i_method_name);
501: ecx_debug.log(l_statement,'i_text_val',i_text_val,i_method_name);
502: ecx_debug.log(l_statement,'i_num_val',i_num_val,i_method_name);
503: ecx_debug.log(l_statement,'i_item_type',i_item_type,i_method_name);
504: ecx_debug.log(l_statement,'i_item_key',i_item_key,i_method_name);
505: ecx_debug.log(l_statement,'i_activity_id',i_activity_id,i_method_name);
506: end if;
507:

Line 504: ecx_debug.log(l_statement,'i_item_key',i_item_key,i_method_name);

500: ecx_debug.log(l_statement,'i_status',i_status,i_method_name);
501: ecx_debug.log(l_statement,'i_text_val',i_text_val,i_method_name);
502: ecx_debug.log(l_statement,'i_num_val',i_num_val,i_method_name);
503: ecx_debug.log(l_statement,'i_item_type',i_item_type,i_method_name);
504: ecx_debug.log(l_statement,'i_item_key',i_item_key,i_method_name);
505: ecx_debug.log(l_statement,'i_activity_id',i_activity_id,i_method_name);
506: end if;
507:
508: wf_engine.CB(command => i_command,

Line 505: ecx_debug.log(l_statement,'i_activity_id',i_activity_id,i_method_name);

501: ecx_debug.log(l_statement,'i_text_val',i_text_val,i_method_name);
502: ecx_debug.log(l_statement,'i_num_val',i_num_val,i_method_name);
503: ecx_debug.log(l_statement,'i_item_type',i_item_type,i_method_name);
504: ecx_debug.log(l_statement,'i_item_key',i_item_key,i_method_name);
505: ecx_debug.log(l_statement,'i_activity_id',i_activity_id,i_method_name);
506: end if;
507:
508: wf_engine.CB(command => i_command,
509: context => i_item_type || ':' || i_item_key ||

Line 516: ecx_debug.log(l_statement,'wf error_name',wf_core.error_name,

512: number_value => i_num_val,
513: date_value => i_date);
514:
515: if(l_statementEnabled) then
516: ecx_debug.log(l_statement,'wf error_name',wf_core.error_name,
517: i_method_name);
518: ecx_debug.log(l_statement,'wf error_message',wf_core.error_message,
519: i_method_name);
520: ecx_debug.log(l_statement,'ecx_errorlog.external_system Callback DONE ',

Line 518: ecx_debug.log(l_statement,'wf error_message',wf_core.error_message,

514:
515: if(l_statementEnabled) then
516: ecx_debug.log(l_statement,'wf error_name',wf_core.error_name,
517: i_method_name);
518: ecx_debug.log(l_statement,'wf error_message',wf_core.error_message,
519: i_method_name);
520: ecx_debug.log(l_statement,'ecx_errorlog.external_system Callback DONE ',
521: i_method_name);
522: end if;

Line 520: ecx_debug.log(l_statement,'ecx_errorlog.external_system Callback DONE ',

516: ecx_debug.log(l_statement,'wf error_name',wf_core.error_name,
517: i_method_name);
518: ecx_debug.log(l_statement,'wf error_message',wf_core.error_message,
519: i_method_name);
520: ecx_debug.log(l_statement,'ecx_errorlog.external_system Callback DONE ',
521: i_method_name);
522: end if;
523: else
524: if(l_statementEnabled) then

Line 525: ecx_debug.log(l_statement,'ecx_errorlog.external_system-testing non block mode',

521: i_method_name);
522: end if;
523: else
524: if(l_statementEnabled) then
525: ecx_debug.log(l_statement,'ecx_errorlog.external_system-testing non block mode',
526: i_method_name);
527: ecx_debug.log(l_statement,'ecx_errorlog.external_system-i_status',
528: i_status,i_method_name);
529: end if;

Line 527: ecx_debug.log(l_statement,'ecx_errorlog.external_system-i_status',

523: else
524: if(l_statementEnabled) then
525: ecx_debug.log(l_statement,'ecx_errorlog.external_system-testing non block mode',
526: i_method_name);
527: ecx_debug.log(l_statement,'ecx_errorlog.external_system-i_status',
528: i_status,i_method_name);
529: end if;
530: if (i_status <> 0)
531: then

Line 609: ecx_debug.log(l_statement,'Raising the event - oracle.apps.ecx.processing.message.callback',

605: p_value => 'ECX_SA',
606: p_parameterlist => i_params);
607:
608: if(l_statementEnabled) then
609: ecx_debug.log(l_statement,'Raising the event - oracle.apps.ecx.processing.message.callback',
610: i_method_name);
611: end if;
612: wf_event.raise('oracle.apps.ecx.processing.message.callback',
613: i_transaction_type|| '-' || i_transaction_subtype || '-' ||

Line 619: ecx_debug.log(l_statement,'i_message_id', i_message_id,i_method_name);

615: null,
616: i_params
617: );
618: if(l_statementEnabled) then
619: ecx_debug.log(l_statement,'i_message_id', i_message_id,i_method_name);
620: end if;
621: end if;
622: end if;
623: end if;

Line 635: ecx_debug.pop(i_method_name);

631: Commit for the Autonomous transaction.
632: **/
633: commit;
634: if (l_procedureEnabled) then
635: ecx_debug.pop(i_method_name);
636: end if;
637: ecx_debug.print_log;
638: ecx_debug.disable_debug;
639:

Line 637: ecx_debug.print_log;

633: commit;
634: if (l_procedureEnabled) then
635: ecx_debug.pop(i_method_name);
636: end if;
637: ecx_debug.print_log;
638: ecx_debug.disable_debug;
639:
640: exception
641: when dup_val_on_index then

Line 638: ecx_debug.disable_debug;

634: if (l_procedureEnabled) then
635: ecx_debug.pop(i_method_name);
636: end if;
637: ecx_debug.print_log;
638: ecx_debug.disable_debug;
639:
640: exception
641: when dup_val_on_index then
642: o_ret_code := ecx_util_api.g_dup_error;

Line 645: ecx_debug.pop(i_method_name);

641: when dup_val_on_index then
642: o_ret_code := ecx_util_api.g_dup_error;
643: o_ret_msg := SQLERRM;
644: if (l_procedureEnabled) then
645: ecx_debug.pop(i_method_name);
646: end if;
647: ecx_debug.print_log;
648: ecx_debug.disable_debug;
649: when others then

Line 647: ecx_debug.print_log;

643: o_ret_msg := SQLERRM;
644: if (l_procedureEnabled) then
645: ecx_debug.pop(i_method_name);
646: end if;
647: ecx_debug.print_log;
648: ecx_debug.disable_debug;
649: when others then
650: rollback;
651: o_ret_code :=2;

Line 648: ecx_debug.disable_debug;

644: if (l_procedureEnabled) then
645: ecx_debug.pop(i_method_name);
646: end if;
647: ecx_debug.print_log;
648: ecx_debug.disable_debug;
649: when others then
650: rollback;
651: o_ret_code :=2;
652: o_ret_msg := SQLERRM||' - ECT_ERRLOG.EXTERNAL_SYSTEM';

Line 654: ecx_debug.pop(i_method_name);

650: rollback;
651: o_ret_code :=2;
652: o_ret_msg := SQLERRM||' - ECT_ERRLOG.EXTERNAL_SYSTEM';
653: if (l_procedureEnabled) then
654: ecx_debug.pop(i_method_name);
655: end if;
656: ecx_debug.print_log;
657: ecx_debug.disable_debug;
658: end external_system;

Line 656: ecx_debug.print_log;

652: o_ret_msg := SQLERRM||' - ECT_ERRLOG.EXTERNAL_SYSTEM';
653: if (l_procedureEnabled) then
654: ecx_debug.pop(i_method_name);
655: end if;
656: ecx_debug.print_log;
657: ecx_debug.disable_debug;
658: end external_system;
659:
660: procedure send_error

Line 657: ecx_debug.disable_debug;

653: if (l_procedureEnabled) then
654: ecx_debug.pop(i_method_name);
655: end if;
656: ecx_debug.print_log;
657: ecx_debug.disable_debug;
658: end external_system;
659:
660: procedure send_error
661: (

Line 821: x_retmsg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE',

817: for party_type_rec in c_party_type(p_transaction_type, p_transaction_subtype) loop
818: i_party_type := party_type_rec.party_type;
819: end loop;
820: elsif NOT(ecx_util_api.validate_party_type(p_party_type)) then
821: x_retmsg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE',
822: 'p_party_type',p_party_type);
823: x_retcode := 2;
824: end if;
825:

Line 1223: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_EXISTS','p_msgid',i_msgid);

1219:
1220: exception
1221: when dup_val_on_index then
1222: o_retcode := 1;
1223: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_EXISTS','p_msgid',i_msgid);
1224: ecx_debug.setErrorInfo(2, 30, 'ECX_DOCLOGS_EXISTS', 'p_msgid', i_msgid);
1225:
1226: when others then
1227: o_retcode := 2;

Line 1224: ecx_debug.setErrorInfo(2, 30, 'ECX_DOCLOGS_EXISTS', 'p_msgid', i_msgid);

1220: exception
1221: when dup_val_on_index then
1222: o_retcode := 1;
1223: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_EXISTS','p_msgid',i_msgid);
1224: ecx_debug.setErrorInfo(2, 30, 'ECX_DOCLOGS_EXISTS', 'p_msgid', i_msgid);
1225:
1226: when others then
1227: o_retcode := 2;
1228: o_retmsg := SQLERRM;

Line 1229: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_ERRORLOG.LOG_DOCUMENT');

1225:
1226: when others then
1227: o_retcode := 2;
1228: o_retmsg := SQLERRM;
1229: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_ERRORLOG.LOG_DOCUMENT');
1230: end log_document;
1231:
1232:
1233: procedure update_log_document

Line 1361: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_NOT_EXISTS', 'p_msgid', i_msgid);

1357: o_retmsg := 'SUCCESS';
1358: exception
1359: when no_data_found then
1360: o_retcode := 2;
1361: o_retmsg := ecx_debug.getTranslatedMessage('ECX_DOCLOGS_NOT_EXISTS', 'p_msgid', i_msgid);
1362: ecx_utils.i_ret_code := o_retcode;
1363: ecx_utils.i_errbuf := o_retmsg;
1364: when others then
1365: o_retcode := 2;