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_RULE dependencies on ECX_UTILS

Line 114: ecx_utils.i_errparams));

110: else
111: wf_event.setErrorInfo(p_event,'WARNING');
112: -- MLS
113: p_event.setErrorMessage(retcode||':'||ecx_debug.getMessage(errmsg,
114: ecx_utils.i_errparams));
115: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
116: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
117: 'Resultout is FALSE- no delivery required.');
118: end if;

Line 142: when ecx_utils.program_exit then

138: wf_core.token('ECX_PARTY_SITE_ID', party_site_id);
139: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
140: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
141: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
142: when ecx_utils.program_exit then
143: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
144: wf_log_pkg.string(wf_log_pkg.level_error, l_module,'Program Exit');
145: end if;
146: ecx_exception_type := 'program_exit';

Line 148: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,

144: wf_log_pkg.string(wf_log_pkg.level_error, l_module,'Program Exit');
145: end if;
146: ecx_exception_type := 'program_exit';
147: -- Get the MLS message
148: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
149: ecx_utils.i_errparams));
150: wf_core.raise('ECX_PROGRAM_EXIT');
151: when others then
152: wf_core.raise('ECX_EVENT_ERROR');

Line 149: ecx_utils.i_errparams));

145: end if;
146: ecx_exception_type := 'program_exit';
147: -- Get the MLS message
148: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
149: ecx_utils.i_errparams));
150: wf_core.raise('ECX_PROGRAM_EXIT');
151: when others then
152: wf_core.raise('ECX_EVENT_ERROR');
153: end;

Line 237: ecx_utils.i_ret_code,

233: ecx_errorlog.inbound_trigger(
234: i_trigger_id,
235: v_msgid,
236: null,
237: ecx_utils.i_ret_code,
238: ecx_utils.i_errbuf
239: );
240:
241:

Line 238: ecx_utils.i_errbuf

234: i_trigger_id,
235: v_msgid,
236: null,
237: ecx_utils.i_ret_code,
238: ecx_utils.i_errbuf
239: );
240:
241:
242: -- Get the data from the Event

Line 313: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

309: ecx_debug.setErrorInfo(1,30,'ECX_PARAM_SELECT_ERROR',
310: 'p_guid',
311: p_subscription_guid);
312: wf_event.setErrorInfo(p_event,'ERROR');
313: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
314: ecx_utils.i_errparams));
315: p_event.event_key := v_msgid;
316: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
317: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 314: ecx_utils.i_errparams));

310: 'p_guid',
311: p_subscription_guid);
312: wf_event.setErrorInfo(p_event,'ERROR');
313: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
314: ecx_utils.i_errparams));
315: p_event.event_key := v_msgid;
316: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
317: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
318: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

Line 316: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);

312: wf_event.setErrorInfo(p_event,'ERROR');
313: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
314: ecx_utils.i_errparams));
315: p_event.event_key := v_msgid;
316: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
317: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
318: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
319: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
320: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);

Line 317: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

313: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
314: ecx_utils.i_errparams));
315: p_event.event_key := v_msgid;
316: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
317: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
318: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
319: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
320: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
321: p_event.addParameterToList('ECX_DIRECTION','IN');

Line 318: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

314: ecx_utils.i_errparams));
315: p_event.event_key := v_msgid;
316: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
317: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
318: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
319: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
320: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
321: p_event.addParameterToList('ECX_DIRECTION','IN');
322: return 'ERROR';

Line 319: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);

315: p_event.event_key := v_msgid;
316: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
317: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
318: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
319: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
320: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
321: p_event.addParameterToList('ECX_DIRECTION','IN');
322: return 'ERROR';
323: end;

Line 477: ecx_utils.i_ret_code,

473: ecx_errorlog.inbound_trigger(
474: i_trigger_id,
475: v_msgid,
476: v_msgid_out,
477: ecx_utils.i_ret_code,
478: ecx_utils.i_errbuf
479: );
480: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
481: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 478: ecx_utils.i_errbuf

474: i_trigger_id,
475: v_msgid,
476: v_msgid_out,
477: ecx_utils.i_ret_code,
478: ecx_utils.i_errbuf
479: );
480: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
481: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
482: 'Processed successfully.');

Line 494: ecx_utils.i_ret_code,

490: ecx_errorlog.inbound_trigger(
491: i_trigger_id,
492: v_msgid,
493: v_msgid_out,
494: ecx_utils.i_ret_code,
495: ecx_utils.i_errbuf,
496: ecx_utils.i_errparams);
497:
498: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

Line 495: ecx_utils.i_errbuf,

491: i_trigger_id,
492: v_msgid,
493: v_msgid_out,
494: ecx_utils.i_ret_code,
495: ecx_utils.i_errbuf,
496: ecx_utils.i_errparams);
497:
498: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
499: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

Line 496: ecx_utils.i_errparams);

492: v_msgid,
493: v_msgid_out,
494: ecx_utils.i_ret_code,
495: ecx_utils.i_errbuf,
496: ecx_utils.i_errparams);
497:
498: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
499: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
500: 'Error enqueuing to processing engine');

Line 505: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

501: end if;
502: wf_event.setErrorInfo(p_event,'ERROR');
503: --p_event.setErrorMessage('Error enqueuing to processing engine: ' || i_queue_name);
504: -- MLS
505: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
506: ecx_utils.i_errparams));
507: p_event.event_key := v_msgid;
508: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
509: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 506: ecx_utils.i_errparams));

502: wf_event.setErrorInfo(p_event,'ERROR');
503: --p_event.setErrorMessage('Error enqueuing to processing engine: ' || i_queue_name);
504: -- MLS
505: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
506: ecx_utils.i_errparams));
507: p_event.event_key := v_msgid;
508: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
509: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
510: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

Line 508: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);

504: -- MLS
505: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
506: ecx_utils.i_errparams));
507: p_event.event_key := v_msgid;
508: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
509: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
510: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
511: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
512: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);

Line 509: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

505: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
506: ecx_utils.i_errparams));
507: p_event.event_key := v_msgid;
508: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
509: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
510: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
511: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
512: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
513: p_event.addParameterToList('ECX_DIRECTION','IN');

Line 510: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

506: ecx_utils.i_errparams));
507: p_event.event_key := v_msgid;
508: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
509: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
510: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
511: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
512: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
513: p_event.addParameterToList('ECX_DIRECTION','IN');
514: return 'ERROR';

Line 511: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);

507: p_event.event_key := v_msgid;
508: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
509: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
510: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
511: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
512: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
513: p_event.addParameterToList('ECX_DIRECTION','IN');
514: return 'ERROR';
515: end;

Line 522: ecx_utils.i_ret_code,

518: ecx_errorlog.inbound_trigger(
519: i_trigger_id,
520: v_msgid,
521: v_msgid_out,
522: ecx_utils.i_ret_code,
523: ecx_utils.i_errbuf
524: );
525: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
526: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

Line 523: ecx_utils.i_errbuf

519: i_trigger_id,
520: v_msgid,
521: v_msgid_out,
522: ecx_utils.i_ret_code,
523: ecx_utils.i_errbuf
524: );
525: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
526: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
527: 'Queue name not found');

Line 532: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

528: end if;
529: wf_event.setErrorInfo(p_event,'ERROR');
530: -- MLS
531: --p_event.setErrorMessage('Unable to determine processing engine queue.');
532: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
533: ecx_utils.i_errparams));
534: p_event.event_key := v_msgid;
535: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
536: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 533: ecx_utils.i_errparams));

529: wf_event.setErrorInfo(p_event,'ERROR');
530: -- MLS
531: --p_event.setErrorMessage('Unable to determine processing engine queue.');
532: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
533: ecx_utils.i_errparams));
534: p_event.event_key := v_msgid;
535: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
536: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
537: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

Line 535: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);

531: --p_event.setErrorMessage('Unable to determine processing engine queue.');
532: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
533: ecx_utils.i_errparams));
534: p_event.event_key := v_msgid;
535: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
536: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
537: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
538: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
539: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);

Line 536: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

532: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
533: ecx_utils.i_errparams));
534: p_event.event_key := v_msgid;
535: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
536: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
537: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
538: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
539: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
540: p_event.addParameterToList('ECX_DIRECTION','IN');

Line 537: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

533: ecx_utils.i_errparams));
534: p_event.event_key := v_msgid;
535: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
536: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
537: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
538: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
539: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
540: p_event.addParameterToList('ECX_DIRECTION','IN');
541:

Line 538: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);

534: p_event.event_key := v_msgid;
535: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
536: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
537: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
538: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
539: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
540: p_event.addParameterToList('ECX_DIRECTION','IN');
541:
542: return 'ERROR';

Line 553: ecx_utils.i_ret_code,

549: ecx_errorlog.inbound_trigger(
550: i_trigger_id,
551: v_msgid,
552: v_msgid_out,
553: ecx_utils.i_ret_code,
554: ecx_utils.i_errbuf
555: );
556: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
557: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

Line 554: ecx_utils.i_errbuf

550: i_trigger_id,
551: v_msgid,
552: v_msgid_out,
553: ecx_utils.i_ret_code,
554: ecx_utils.i_errbuf
555: );
556: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
557: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
558: 'More than one row resulted while querying the queue name.');

Line 563: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

559: end if;
560: wf_event.setErrorInfo(p_event,'ERROR');
561: -- MLS
562: --p_event.setErrorMessage('More than one row resulted while querying the Queue Name.');
563: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
564: ecx_utils.i_errparams));
565: p_event.event_key := v_msgid;
566: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
567: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 564: ecx_utils.i_errparams));

560: wf_event.setErrorInfo(p_event,'ERROR');
561: -- MLS
562: --p_event.setErrorMessage('More than one row resulted while querying the Queue Name.');
563: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
564: ecx_utils.i_errparams));
565: p_event.event_key := v_msgid;
566: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
567: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
568: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

Line 566: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);

562: --p_event.setErrorMessage('More than one row resulted while querying the Queue Name.');
563: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
564: ecx_utils.i_errparams));
565: p_event.event_key := v_msgid;
566: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
567: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
568: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
569: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
570: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);

Line 567: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

563: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
564: ecx_utils.i_errparams));
565: p_event.event_key := v_msgid;
566: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
567: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
568: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
569: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
570: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
571: p_event.addParameterToList('ECX_DIRECTION','IN');

Line 568: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

564: ecx_utils.i_errparams));
565: p_event.event_key := v_msgid;
566: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
567: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
568: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
569: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
570: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
571: p_event.addParameterToList('ECX_DIRECTION','IN');
572:

Line 569: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);

565: p_event.event_key := v_msgid;
566: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
567: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
568: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
569: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
570: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
571: p_event.addParameterToList('ECX_DIRECTION','IN');
572:
573: return 'ERROR';

Line 591: ecx_utils.i_ret_code,

587: ecx_errorlog.inbound_trigger(
588: i_trigger_id,
589: v_msgid,
590: v_msgid_out,
591: ecx_utils.i_ret_code,
592: ecx_utils.i_errbuf,
593: ecx_utils.i_errparams);
594:
595: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

Line 592: ecx_utils.i_errbuf,

588: i_trigger_id,
589: v_msgid,
590: v_msgid_out,
591: ecx_utils.i_ret_code,
592: ecx_utils.i_errbuf,
593: ecx_utils.i_errparams);
594:
595: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
596: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

Line 593: ecx_utils.i_errparams);

589: v_msgid,
590: v_msgid_out,
591: ecx_utils.i_ret_code,
592: ecx_utils.i_errbuf,
593: ecx_utils.i_errparams);
594:
595: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
596: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
597: 'The Standard:'||l_standard_code||

Line 605: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

601: ' is not enabled in the XML Gateway Server. Pls check your Setup');
602: end if;
603: wf_event.setErrorInfo(p_event,'ERROR');
604: -- MLS
605: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
606: ecx_utils.i_errparams));
607: p_event.event_key := v_msgid;
608: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
609: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 606: ecx_utils.i_errparams));

602: end if;
603: wf_event.setErrorInfo(p_event,'ERROR');
604: -- MLS
605: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
606: ecx_utils.i_errparams));
607: p_event.event_key := v_msgid;
608: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
609: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
610: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

Line 608: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);

604: -- MLS
605: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
606: ecx_utils.i_errparams));
607: p_event.event_key := v_msgid;
608: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
609: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
610: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
611: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
612: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);

Line 609: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

605: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
606: ecx_utils.i_errparams));
607: p_event.event_key := v_msgid;
608: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
609: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
610: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
611: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
612: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
613: p_event.addParameterToList('ECX_DIRECTION','IN');

Line 610: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

606: ecx_utils.i_errparams));
607: p_event.event_key := v_msgid;
608: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
609: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
610: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
611: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
612: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
613: p_event.addParameterToList('ECX_DIRECTION','IN');
614:

Line 611: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);

607: p_event.event_key := v_msgid;
608: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
609: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
610: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
611: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
612: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
613: p_event.addParameterToList('ECX_DIRECTION','IN');
614:
615: return 'ERROR';

Line 623: ecx_utils.i_ret_code,

619: ecx_errorlog.inbound_trigger(
620: i_trigger_id,
621: v_msgid,
622: v_msgid_out,
623: ecx_utils.i_ret_code,
624: ecx_utils.i_errbuf
625: );
626: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
627: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

Line 624: ecx_utils.i_errbuf

620: i_trigger_id,
621: v_msgid,
622: v_msgid_out,
623: ecx_utils.i_ret_code,
624: ecx_utils.i_errbuf
625: );
626: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
627: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
628: 'Error in processing inbound rule.');

Line 631: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

627: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
628: 'Error in processing inbound rule.');
629: end if;
630: wf_event.setErrorInfo(p_event,'ERROR');
631: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
632: ecx_utils.i_errparams));
633: p_event.event_key := v_msgid;
634: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
635: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 632: ecx_utils.i_errparams));

628: 'Error in processing inbound rule.');
629: end if;
630: wf_event.setErrorInfo(p_event,'ERROR');
631: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
632: ecx_utils.i_errparams));
633: p_event.event_key := v_msgid;
634: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
635: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
636: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

Line 634: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);

630: wf_event.setErrorInfo(p_event,'ERROR');
631: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
632: ecx_utils.i_errparams));
633: p_event.event_key := v_msgid;
634: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
635: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
636: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
637: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
638: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);

Line 635: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

631: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
632: ecx_utils.i_errparams));
633: p_event.event_key := v_msgid;
634: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
635: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
636: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
637: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
638: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
639: p_event.addParameterToList('ECX_DIRECTION','IN');

Line 636: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

632: ecx_utils.i_errparams));
633: p_event.event_key := v_msgid;
634: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
635: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
636: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
637: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
638: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
639: p_event.addParameterToList('ECX_DIRECTION','IN');
640:

Line 637: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);

633: p_event.event_key := v_msgid;
634: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
635: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
636: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
637: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
638: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
639: p_event.addParameterToList('ECX_DIRECTION','IN');
640:
641: return 'ERROR';

Line 893: if ecx_utils.g_snd_tp_id is not null then

889: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
890: 'setEventParam');
891: end if;
892:
893: if ecx_utils.g_snd_tp_id is not null then
894: begin
895: select party_type
896: into l_party_type
897: from ecx_tp_headers

Line 898: where tp_header_id=ecx_utils.g_snd_tp_id;

894: begin
895: select party_type
896: into l_party_type
897: from ecx_tp_headers
898: where tp_header_id=ecx_utils.g_snd_tp_id;
899: exception
900: when others then
901: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
902: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 909: p_event.addParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);

905: end;
906: end if;
907:
908: p_event.addParameterToList('ECX_DEBUG_LEVEL', p_debug_mode);
909: p_event.addParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
910: p_event.addParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
911: p_event.addParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);

Line 910: p_event.addParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

906: end if;
907:
908: p_event.addParameterToList('ECX_DEBUG_LEVEL', p_debug_mode);
909: p_event.addParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
910: p_event.addParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
911: p_event.addParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);
914: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);

Line 911: p_event.addParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

907:
908: p_event.addParameterToList('ECX_DEBUG_LEVEL', p_debug_mode);
909: p_event.addParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
910: p_event.addParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
911: p_event.addParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);
914: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
915: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE', ecx_utils.g_transaction_subtype);

Line 912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);

908: p_event.addParameterToList('ECX_DEBUG_LEVEL', p_debug_mode);
909: p_event.addParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
910: p_event.addParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
911: p_event.addParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);
914: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
915: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE', ecx_utils.g_transaction_subtype);
916: p_event.addParameterToList('ECX_TP_HEADER_ID', ecx_utils.g_snd_tp_id);

Line 913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);

909: p_event.addParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
910: p_event.addParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
911: p_event.addParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);
914: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
915: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE', ecx_utils.g_transaction_subtype);
916: p_event.addParameterToList('ECX_TP_HEADER_ID', ecx_utils.g_snd_tp_id);
917: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 914: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);

910: p_event.addParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
911: p_event.addParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);
914: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
915: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE', ecx_utils.g_transaction_subtype);
916: p_event.addParameterToList('ECX_TP_HEADER_ID', ecx_utils.g_snd_tp_id);
917: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
918: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 915: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE', ecx_utils.g_transaction_subtype);

911: p_event.addParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);
914: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
915: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE', ecx_utils.g_transaction_subtype);
916: p_event.addParameterToList('ECX_TP_HEADER_ID', ecx_utils.g_snd_tp_id);
917: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
918: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
919: 'Tp Header Id: '|| ecx_utils.g_snd_tp_id);

Line 916: p_event.addParameterToList('ECX_TP_HEADER_ID', ecx_utils.g_snd_tp_id);

912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);
913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);
914: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
915: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE', ecx_utils.g_transaction_subtype);
916: p_event.addParameterToList('ECX_TP_HEADER_ID', ecx_utils.g_snd_tp_id);
917: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
918: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
919: 'Tp Header Id: '|| ecx_utils.g_snd_tp_id);
920: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 919: 'Tp Header Id: '|| ecx_utils.g_snd_tp_id);

915: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE', ecx_utils.g_transaction_subtype);
916: p_event.addParameterToList('ECX_TP_HEADER_ID', ecx_utils.g_snd_tp_id);
917: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
918: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
919: 'Tp Header Id: '|| ecx_utils.g_snd_tp_id);
920: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
921: 'Mesage Type from doclogs: '|| p_message_type);
922: end if;
923: p_event.addParameterToList('ECX_MSGID', p_msgid);

Line 987: if(ecx_utils.g_ret_code = 1 ) then

983: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
984: 'Completed inbound processing.');
985: end if;
986:
987: if(ecx_utils.g_ret_code = 1 ) then
988: ecx_debug.setErrorInfo(1, 10, 'ECX_MESSAGE_PROCESSED_WARNING');
989: else
990: ecx_debug.setErrorInfo(0, 10, 'ECX_MESSAGE_PROCESSED');
991: end if;

Line 995: ecx_utils.i_ret_code,

991: end if;
992: end if;
993:
994: ecx_errorlog.inbound_engine(p_process_id,
995: ecx_utils.i_ret_code,
996: ecx_utils.i_errbuf);
997:
998: exception
999: when others then

Line 996: ecx_utils.i_errbuf);

992: end if;
993:
994: ecx_errorlog.inbound_engine(p_process_id,
995: ecx_utils.i_ret_code,
996: ecx_utils.i_errbuf);
997:
998: exception
999: when others then
1000: rollback to before_processing;

Line 1001: if(ecx_utils.i_ret_code = 0) then

997:
998: exception
999: when others then
1000: rollback to before_processing;
1001: if(ecx_utils.i_ret_code = 0) then
1002: ecx_utils.i_ret_code := 2;
1003: ecx_utils.i_errbuf := SQLERRM;
1004: end if;
1005:

Line 1002: ecx_utils.i_ret_code := 2;

998: exception
999: when others then
1000: rollback to before_processing;
1001: if(ecx_utils.i_ret_code = 0) then
1002: ecx_utils.i_ret_code := 2;
1003: ecx_utils.i_errbuf := SQLERRM;
1004: end if;
1005:
1006: if (ecx_utils.i_errbuf is null) then

Line 1003: ecx_utils.i_errbuf := SQLERRM;

999: when others then
1000: rollback to before_processing;
1001: if(ecx_utils.i_ret_code = 0) then
1002: ecx_utils.i_ret_code := 2;
1003: ecx_utils.i_errbuf := SQLERRM;
1004: end if;
1005:
1006: if (ecx_utils.i_errbuf is null) then
1007: ecx_utils.i_errbuf := SQLERRM;

Line 1006: if (ecx_utils.i_errbuf is null) then

1002: ecx_utils.i_ret_code := 2;
1003: ecx_utils.i_errbuf := SQLERRM;
1004: end if;
1005:
1006: if (ecx_utils.i_errbuf is null) then
1007: ecx_utils.i_errbuf := SQLERRM;
1008: end if;
1009:
1010: if (ecx_utils.error_type is null)

Line 1007: ecx_utils.i_errbuf := SQLERRM;

1003: ecx_utils.i_errbuf := SQLERRM;
1004: end if;
1005:
1006: if (ecx_utils.i_errbuf is null) then
1007: ecx_utils.i_errbuf := SQLERRM;
1008: end if;
1009:
1010: if (ecx_utils.error_type is null)
1011: -- OR

Line 1010: if (ecx_utils.error_type is null)

1006: if (ecx_utils.i_errbuf is null) then
1007: ecx_utils.i_errbuf := SQLERRM;
1008: end if;
1009:
1010: if (ecx_utils.error_type is null)
1011: -- OR
1012: --(ecx_utils.error_type = 10 )
1013: then
1014: ecx_utils.error_type := 30;

Line 1012: --(ecx_utils.error_type = 10 )

1008: end if;
1009:
1010: if (ecx_utils.error_type is null)
1011: -- OR
1012: --(ecx_utils.error_type = 10 )
1013: then
1014: ecx_utils.error_type := 30;
1015: end if;
1016:

Line 1014: ecx_utils.error_type := 30;

1010: if (ecx_utils.error_type is null)
1011: -- OR
1012: --(ecx_utils.error_type = 10 )
1013: then
1014: ecx_utils.error_type := 30;
1015: end if;
1016:
1017: begin
1018: ecx_errorlog.inbound_engine(p_process_id,

Line 1019: ecx_utils.i_ret_code,

1015: end if;
1016:
1017: begin
1018: ecx_errorlog.inbound_engine(p_process_id,
1019: ecx_utils.i_ret_code,
1020: ecx_utils.i_errbuf);
1021: exception
1022: when others then
1023: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

Line 1020: ecx_utils.i_errbuf);

1016:
1017: begin
1018: ecx_errorlog.inbound_engine(p_process_id,
1019: ecx_utils.i_ret_code,
1020: ecx_utils.i_errbuf);
1021: exception
1022: when others then
1023: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1024: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

Line 1035: 'Error Type: '|| ecx_utils.error_type);

1031: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1032: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1033: 'Exception in inbound processing.');
1034: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1035: 'Error Type: '|| ecx_utils.error_type);
1036: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1037: 'Return Code: '|| ecx_utils.i_ret_code);
1038: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1039: 'Error Message: '|| ecx_utils.i_errbuf);

Line 1037: 'Return Code: '|| ecx_utils.i_ret_code);

1033: 'Exception in inbound processing.');
1034: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1035: 'Error Type: '|| ecx_utils.error_type);
1036: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1037: 'Return Code: '|| ecx_utils.i_ret_code);
1038: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1039: 'Error Message: '|| ecx_utils.i_errbuf);
1040: end if;
1041: raise;

Line 1039: 'Error Message: '|| ecx_utils.i_errbuf);

1035: 'Error Type: '|| ecx_utils.error_type);
1036: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1037: 'Return Code: '|| ecx_utils.i_ret_code);
1038: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1039: 'Error Message: '|| ecx_utils.i_errbuf);
1040: end if;
1041: raise;
1042: end processTPMessage;
1043:

Line 1353: ecx_debug.getMessage(ecx_utils.i_errbuf,

1349: then
1350: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1351: then
1352: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1353: ecx_debug.getMessage(ecx_utils.i_errbuf,
1354: ecx_utils.i_errparams));
1355: end if;
1356: raise rule_exception;
1357: end if;

Line 1354: ecx_utils.i_errparams));

1350: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1351: then
1352: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1353: ecx_debug.getMessage(ecx_utils.i_errbuf,
1354: ecx_utils.i_errparams));
1355: end if;
1356: raise rule_exception;
1357: end if;
1358:

Line 1445: ecx_debug.getMessage(ecx_utils.i_errbuf,

1441: then
1442: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1443: then
1444: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1445: ecx_debug.getMessage(ecx_utils.i_errbuf,
1446: ecx_utils.i_errparams));
1447: end if;
1448: raise rule_exception;
1449: end if;

Line 1446: ecx_utils.i_errparams));

1442: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1443: then
1444: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1445: ecx_debug.getMessage(ecx_utils.i_errbuf,
1446: ecx_utils.i_errparams));
1447: end if;
1448: raise rule_exception;
1449: end if;
1450:

Line 1458: ecx_utils.i_ret_code,

1454: ecx_errorlog.inbound_trigger(
1455: l_trigger_id,
1456: l_msgid,
1457: l_process_id,
1458: ecx_utils.i_ret_code,
1459: ecx_utils.i_errbuf,
1460: ecx_utils.i_errparams
1461: );
1462:

Line 1459: ecx_utils.i_errbuf,

1455: l_trigger_id,
1456: l_msgid,
1457: l_process_id,
1458: ecx_utils.i_ret_code,
1459: ecx_utils.i_errbuf,
1460: ecx_utils.i_errparams
1461: );
1462:
1463: wf_event.setErrorInfo(p_event,'ERROR');

Line 1460: ecx_utils.i_errparams

1456: l_msgid,
1457: l_process_id,
1458: ecx_utils.i_ret_code,
1459: ecx_utils.i_errbuf,
1460: ecx_utils.i_errparams
1461: );
1462:
1463: wf_event.setErrorInfo(p_event,'ERROR');
1464: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

Line 1464: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

1460: ecx_utils.i_errparams
1461: );
1462:
1463: wf_event.setErrorInfo(p_event,'ERROR');
1464: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1465: ecx_utils.i_errparams));
1466: p_event.event_key := l_msgid;
1467: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1468: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 1465: ecx_utils.i_errparams));

1461: );
1462:
1463: wf_event.setErrorInfo(p_event,'ERROR');
1464: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1465: ecx_utils.i_errparams));
1466: p_event.event_key := l_msgid;
1467: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1468: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1469: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

Line 1467: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);

1463: wf_event.setErrorInfo(p_event,'ERROR');
1464: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1465: ecx_utils.i_errparams));
1466: p_event.event_key := l_msgid;
1467: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1468: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1469: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1470: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1471: p_event.AddParameterToList('ECX_TP_HEADER_ID', p_tp_header_id);

Line 1468: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

1464: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1465: ecx_utils.i_errparams));
1466: p_event.event_key := l_msgid;
1467: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1468: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1469: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1470: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1471: p_event.AddParameterToList('ECX_TP_HEADER_ID', p_tp_header_id);
1472: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_tran_type);

Line 1469: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

1465: ecx_utils.i_errparams));
1466: p_event.event_key := l_msgid;
1467: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1468: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1469: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1470: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1471: p_event.AddParameterToList('ECX_TP_HEADER_ID', p_tp_header_id);
1472: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_tran_type);
1473: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE',l_tran_subtype);

Line 1470: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);

1466: p_event.event_key := l_msgid;
1467: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1468: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1469: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1470: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1471: p_event.AddParameterToList('ECX_TP_HEADER_ID', p_tp_header_id);
1472: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_tran_type);
1473: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE',l_tran_subtype);
1474: p_event.AddParameterToList('ECX_PARTY_ID',l_party_id);

Line 1614: ecx_utils.i_ret_code,

1610: ecx_errorlog.inbound_trigger(
1611: l_trigger_id,
1612: l_msgid,
1613: l_process_id,
1614: ecx_utils.i_ret_code,
1615: ecx_utils.i_errbuf
1616: );
1617:
1618: l_queue_name := null;

Line 1615: ecx_utils.i_errbuf

1611: l_trigger_id,
1612: l_msgid,
1613: l_process_id,
1614: ecx_utils.i_ret_code,
1615: ecx_utils.i_errbuf
1616: );
1617:
1618: l_queue_name := null;
1619:

Line 1674: ecx_utils.i_ret_code := l_retcode;

1670: -- insert into the doclog table.
1671: l_payload := p_event.getEventData();
1672: if (l_payload is null) or
1673: (dbms_lob.getlength(l_payload) = 0) then
1674: ecx_utils.i_ret_code := l_retcode;
1675: ecx_utils.i_errbuf := l_retmsg;
1676: raise rule_exception;
1677: end if;
1678:

Line 1675: ecx_utils.i_errbuf := l_retmsg;

1671: l_payload := p_event.getEventData();
1672: if (l_payload is null) or
1673: (dbms_lob.getlength(l_payload) = 0) then
1674: ecx_utils.i_ret_code := l_retcode;
1675: ecx_utils.i_errbuf := l_retmsg;
1676: raise rule_exception;
1677: end if;
1678:
1679: l_transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');

Line 1753: ecx_debug.getMessage(ecx_utils.i_errbuf, ecx_utils.i_errparams));

1749: end if;
1750: elsif (l_retcode >= 2) then
1751: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1752: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1753: ecx_debug.getMessage(ecx_utils.i_errbuf, ecx_utils.i_errparams));
1754: end if;
1755: raise rule_exception;
1756: end if;
1757: end; -- save to doc_logs

Line 1799: ecx_utils.g_direction := 'IN';

1795:
1796: -- start to do the inbound processing and then dispatch the product
1797: -- team specified event.
1798: if (l_queue_name is null) then
1799: ecx_utils.g_direction := 'IN';
1800: ecx_utils.g_transaction_type := l_transaction_type;
1801: ecx_utils.g_transaction_subtype := l_transaction_subtype;
1802:
1803: setDebugMode (

Line 1800: ecx_utils.g_transaction_type := l_transaction_type;

1796: -- start to do the inbound processing and then dispatch the product
1797: -- team specified event.
1798: if (l_queue_name is null) then
1799: ecx_utils.g_direction := 'IN';
1800: ecx_utils.g_transaction_type := l_transaction_type;
1801: ecx_utils.g_transaction_subtype := l_transaction_subtype;
1802:
1803: setDebugMode (
1804: p_subscription_guid => p_subscription_guid,

Line 1801: ecx_utils.g_transaction_subtype := l_transaction_subtype;

1797: -- team specified event.
1798: if (l_queue_name is null) then
1799: ecx_utils.g_direction := 'IN';
1800: ecx_utils.g_transaction_type := l_transaction_type;
1801: ecx_utils.g_transaction_subtype := l_transaction_subtype;
1802:
1803: setDebugMode (
1804: p_subscription_guid => p_subscription_guid,
1805: p_transaction_type => l_transaction_type,

Line 1816: if (ecx_utils.i_ret_code <> 2) then

1812: 'FND Debug level is set to '
1813: || fnd_log.g_current_runtime_level );
1814: end if;
1815: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1816: if (ecx_utils.i_ret_code <> 2) then
1817: if (ecx_utils.g_event is not null and
1818: ecx_utils.g_event.event_name is not null) then
1819: p_event := ecx_utils.g_event;
1820:

Line 1817: if (ecx_utils.g_event is not null and

1813: || fnd_log.g_current_runtime_level );
1814: end if;
1815: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1816: if (ecx_utils.i_ret_code <> 2) then
1817: if (ecx_utils.g_event is not null and
1818: ecx_utils.g_event.event_name is not null) then
1819: p_event := ecx_utils.g_event;
1820:
1821: setEventParam(

Line 1818: ecx_utils.g_event.event_name is not null) then

1814: end if;
1815: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1816: if (ecx_utils.i_ret_code <> 2) then
1817: if (ecx_utils.g_event is not null and
1818: ecx_utils.g_event.event_name is not null) then
1819: p_event := ecx_utils.g_event;
1820:
1821: setEventParam(
1822: p_msgid => l_msgid,

Line 1819: p_event := ecx_utils.g_event;

1815: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1816: if (ecx_utils.i_ret_code <> 2) then
1817: if (ecx_utils.g_event is not null and
1818: ecx_utils.g_event.event_name is not null) then
1819: p_event := ecx_utils.g_event;
1820:
1821: setEventParam(
1822: p_msgid => l_msgid,
1823: p_transaction_type => l_transaction_type,

Line 1864: ecx_utils.i_ret_code,

1860: ecx_errorlog.inbound_trigger(
1861: l_trigger_id,
1862: l_msgid,
1863: l_process_id,
1864: ecx_utils.i_ret_code,
1865: ecx_utils.i_errbuf
1866: );
1867: end if;
1868:

Line 1865: ecx_utils.i_errbuf

1861: l_trigger_id,
1862: l_msgid,
1863: l_process_id,
1864: ecx_utils.i_ret_code,
1865: ecx_utils.i_errbuf
1866: );
1867: end if;
1868:
1869: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;

Line 1871: if (ecx_utils.i_ret_code = 2) then

1867: end if;
1868:
1869: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;
1870:
1871: if (ecx_utils.i_ret_code = 2) then
1872: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1873: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Error.');
1874: end if;
1875: ecx_debug.setErrorInfo(2,30, 'ECX_IN_RULE_PROCESING_ERROR');

Line 1891: ecx_utils.i_ret_code,

1887: ecx_errorlog.inbound_trigger(
1888: l_trigger_id,
1889: l_msgid,
1890: l_process_id,
1891: ecx_utils.i_ret_code,
1892: ecx_utils.i_errbuf,
1893: ecx_utils.i_errparams
1894: );
1895:

Line 1892: ecx_utils.i_errbuf,

1888: l_trigger_id,
1889: l_msgid,
1890: l_process_id,
1891: ecx_utils.i_ret_code,
1892: ecx_utils.i_errbuf,
1893: ecx_utils.i_errparams
1894: );
1895:
1896: wf_event.setErrorInfo(p_event,'ERROR');

Line 1893: ecx_utils.i_errparams

1889: l_msgid,
1890: l_process_id,
1891: ecx_utils.i_ret_code,
1892: ecx_utils.i_errbuf,
1893: ecx_utils.i_errparams
1894: );
1895:
1896: wf_event.setErrorInfo(p_event,'ERROR');
1897: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

Line 1897: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

1893: ecx_utils.i_errparams
1894: );
1895:
1896: wf_event.setErrorInfo(p_event,'ERROR');
1897: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1898: ecx_utils.i_errparams));
1899: if (p_event.event_key is null)
1900: then
1901: p_event.event_key := l_msgid;

Line 1898: ecx_utils.i_errparams));

1894: );
1895:
1896: wf_event.setErrorInfo(p_event,'ERROR');
1897: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1898: ecx_utils.i_errparams));
1899: if (p_event.event_key is null)
1900: then
1901: p_event.event_key := l_msgid;
1902: end if;

Line 1903: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);

1899: if (p_event.event_key is null)
1900: then
1901: p_event.event_key := l_msgid;
1902: end if;
1903: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1904: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1905: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1906: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1907: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);

Line 1904: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

1900: then
1901: p_event.event_key := l_msgid;
1902: end if;
1903: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1904: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1905: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1906: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1907: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
1908: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_transaction_type);

Line 1905: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

1901: p_event.event_key := l_msgid;
1902: end if;
1903: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1904: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1905: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1906: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1907: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
1908: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_transaction_type);
1909: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE',l_transaction_subtype);

Line 1906: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);

1902: end if;
1903: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1904: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1905: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1906: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1907: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
1908: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_transaction_type);
1909: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE',l_transaction_subtype);
1910: p_event.AddParameterToList('ECX_PARTY_ID',l_party_id);