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.

[Home] [Help]

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 979: if(ecx_utils.g_ret_code = 1 )

975: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
976: 'Completed inbound processing.');
977: end if;
978:
979: if(ecx_utils.g_ret_code = 1 )
980: then
981: ecx_debug.setErrorInfo(1, 10, 'ECX_MESSAGE_PROCESSED_WARNING');
982: else
983: ecx_debug.setErrorInfo(0, 10, 'ECX_MESSAGE_PROCESSED');

Line 987: ecx_utils.i_ret_code,

983: ecx_debug.setErrorInfo(0, 10, 'ECX_MESSAGE_PROCESSED');
984: end if;
985:
986: ecx_errorlog.inbound_engine(p_process_id,
987: ecx_utils.i_ret_code,
988: ecx_utils.i_errbuf);
989:
990: exception
991: when others then

Line 988: ecx_utils.i_errbuf);

984: end if;
985:
986: ecx_errorlog.inbound_engine(p_process_id,
987: ecx_utils.i_ret_code,
988: ecx_utils.i_errbuf);
989:
990: exception
991: when others then
992: rollback to before_processing;

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

989:
990: exception
991: when others then
992: rollback to before_processing;
993: if(ecx_utils.i_ret_code = 0) then
994: ecx_utils.i_ret_code := 2;
995: ecx_utils.i_errbuf := SQLERRM;
996: end if;
997:

Line 994: ecx_utils.i_ret_code := 2;

990: exception
991: when others then
992: rollback to before_processing;
993: if(ecx_utils.i_ret_code = 0) then
994: ecx_utils.i_ret_code := 2;
995: ecx_utils.i_errbuf := SQLERRM;
996: end if;
997:
998: if (ecx_utils.i_errbuf is null) then

Line 995: ecx_utils.i_errbuf := SQLERRM;

991: when others then
992: rollback to before_processing;
993: if(ecx_utils.i_ret_code = 0) then
994: ecx_utils.i_ret_code := 2;
995: ecx_utils.i_errbuf := SQLERRM;
996: end if;
997:
998: if (ecx_utils.i_errbuf is null) then
999: ecx_utils.i_errbuf := SQLERRM;

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

994: ecx_utils.i_ret_code := 2;
995: ecx_utils.i_errbuf := SQLERRM;
996: end if;
997:
998: if (ecx_utils.i_errbuf is null) then
999: ecx_utils.i_errbuf := SQLERRM;
1000: end if;
1001:
1002: if (ecx_utils.error_type is null)

Line 999: ecx_utils.i_errbuf := SQLERRM;

995: ecx_utils.i_errbuf := SQLERRM;
996: end if;
997:
998: if (ecx_utils.i_errbuf is null) then
999: ecx_utils.i_errbuf := SQLERRM;
1000: end if;
1001:
1002: if (ecx_utils.error_type is null)
1003: -- OR

Line 1002: if (ecx_utils.error_type is null)

998: if (ecx_utils.i_errbuf is null) then
999: ecx_utils.i_errbuf := SQLERRM;
1000: end if;
1001:
1002: if (ecx_utils.error_type is null)
1003: -- OR
1004: --(ecx_utils.error_type = 10 )
1005: then
1006: ecx_utils.error_type := 30;

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

1000: end if;
1001:
1002: if (ecx_utils.error_type is null)
1003: -- OR
1004: --(ecx_utils.error_type = 10 )
1005: then
1006: ecx_utils.error_type := 30;
1007: end if;
1008:

Line 1006: ecx_utils.error_type := 30;

1002: if (ecx_utils.error_type is null)
1003: -- OR
1004: --(ecx_utils.error_type = 10 )
1005: then
1006: ecx_utils.error_type := 30;
1007: end if;
1008:
1009: begin
1010: ecx_errorlog.inbound_engine(p_process_id,

Line 1011: ecx_utils.i_ret_code,

1007: end if;
1008:
1009: begin
1010: ecx_errorlog.inbound_engine(p_process_id,
1011: ecx_utils.i_ret_code,
1012: ecx_utils.i_errbuf);
1013: exception
1014: when others then
1015: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

Line 1012: ecx_utils.i_errbuf);

1008:
1009: begin
1010: ecx_errorlog.inbound_engine(p_process_id,
1011: ecx_utils.i_ret_code,
1012: ecx_utils.i_errbuf);
1013: exception
1014: when others then
1015: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1016: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

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

1023: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1024: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1025: 'Exception in inbound processing.');
1026: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1027: 'Error Type: '|| ecx_utils.error_type);
1028: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1029: 'Return Code: '|| ecx_utils.i_ret_code);
1030: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1031: 'Error Message: '|| ecx_utils.i_errbuf);

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

1025: 'Exception in inbound processing.');
1026: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1027: 'Error Type: '|| ecx_utils.error_type);
1028: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1029: 'Return Code: '|| ecx_utils.i_ret_code);
1030: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1031: 'Error Message: '|| ecx_utils.i_errbuf);
1032: end if;
1033: raise;

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

1027: 'Error Type: '|| ecx_utils.error_type);
1028: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1029: 'Return Code: '|| ecx_utils.i_ret_code);
1030: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1031: 'Error Message: '|| ecx_utils.i_errbuf);
1032: end if;
1033: raise;
1034: end processTPMessage;
1035:

Line 1345: ecx_debug.getMessage(ecx_utils.i_errbuf,

1341: then
1342: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1343: then
1344: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1345: ecx_debug.getMessage(ecx_utils.i_errbuf,
1346: ecx_utils.i_errparams));
1347: end if;
1348: raise rule_exception;
1349: end if;

Line 1346: ecx_utils.i_errparams));

1342: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1343: then
1344: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1345: ecx_debug.getMessage(ecx_utils.i_errbuf,
1346: ecx_utils.i_errparams));
1347: end if;
1348: raise rule_exception;
1349: end if;
1350:

Line 1437: ecx_debug.getMessage(ecx_utils.i_errbuf,

1433: then
1434: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1435: then
1436: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1437: ecx_debug.getMessage(ecx_utils.i_errbuf,
1438: ecx_utils.i_errparams));
1439: end if;
1440: raise rule_exception;
1441: end if;

Line 1438: ecx_utils.i_errparams));

1434: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1435: then
1436: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1437: ecx_debug.getMessage(ecx_utils.i_errbuf,
1438: ecx_utils.i_errparams));
1439: end if;
1440: raise rule_exception;
1441: end if;
1442:

Line 1450: ecx_utils.i_ret_code,

1446: ecx_errorlog.inbound_trigger(
1447: l_trigger_id,
1448: l_msgid,
1449: l_process_id,
1450: ecx_utils.i_ret_code,
1451: ecx_utils.i_errbuf,
1452: ecx_utils.i_errparams
1453: );
1454:

Line 1451: ecx_utils.i_errbuf,

1447: l_trigger_id,
1448: l_msgid,
1449: l_process_id,
1450: ecx_utils.i_ret_code,
1451: ecx_utils.i_errbuf,
1452: ecx_utils.i_errparams
1453: );
1454:
1455: wf_event.setErrorInfo(p_event,'ERROR');

Line 1452: ecx_utils.i_errparams

1448: l_msgid,
1449: l_process_id,
1450: ecx_utils.i_ret_code,
1451: ecx_utils.i_errbuf,
1452: ecx_utils.i_errparams
1453: );
1454:
1455: wf_event.setErrorInfo(p_event,'ERROR');
1456: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

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

1452: ecx_utils.i_errparams
1453: );
1454:
1455: wf_event.setErrorInfo(p_event,'ERROR');
1456: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1457: ecx_utils.i_errparams));
1458: p_event.event_key := l_msgid;
1459: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1460: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 1457: ecx_utils.i_errparams));

1453: );
1454:
1455: wf_event.setErrorInfo(p_event,'ERROR');
1456: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1457: ecx_utils.i_errparams));
1458: p_event.event_key := l_msgid;
1459: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1460: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1461: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);

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

1455: wf_event.setErrorInfo(p_event,'ERROR');
1456: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1457: ecx_utils.i_errparams));
1458: p_event.event_key := l_msgid;
1459: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1460: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1461: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1462: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1463: p_event.AddParameterToList('ECX_TP_HEADER_ID', p_tp_header_id);

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

1456: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1457: ecx_utils.i_errparams));
1458: p_event.event_key := l_msgid;
1459: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1460: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1461: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1462: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1463: p_event.AddParameterToList('ECX_TP_HEADER_ID', p_tp_header_id);
1464: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_tran_type);

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

1457: ecx_utils.i_errparams));
1458: p_event.event_key := l_msgid;
1459: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1460: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1461: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1462: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1463: p_event.AddParameterToList('ECX_TP_HEADER_ID', p_tp_header_id);
1464: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_tran_type);
1465: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE',l_tran_subtype);

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

1458: p_event.event_key := l_msgid;
1459: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1460: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1461: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1462: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1463: p_event.AddParameterToList('ECX_TP_HEADER_ID', p_tp_header_id);
1464: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_tran_type);
1465: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE',l_tran_subtype);
1466: p_event.AddParameterToList('ECX_PARTY_ID',l_party_id);

Line 1606: ecx_utils.i_ret_code,

1602: ecx_errorlog.inbound_trigger(
1603: l_trigger_id,
1604: l_msgid,
1605: l_process_id,
1606: ecx_utils.i_ret_code,
1607: ecx_utils.i_errbuf
1608: );
1609:
1610: l_queue_name := null;

Line 1607: ecx_utils.i_errbuf

1603: l_trigger_id,
1604: l_msgid,
1605: l_process_id,
1606: ecx_utils.i_ret_code,
1607: ecx_utils.i_errbuf
1608: );
1609:
1610: l_queue_name := null;
1611:

Line 1666: ecx_utils.i_ret_code := l_retcode;

1662: -- insert into the doclog table.
1663: l_payload := p_event.getEventData();
1664: if (l_payload is null) or
1665: (dbms_lob.getlength(l_payload) = 0) then
1666: ecx_utils.i_ret_code := l_retcode;
1667: ecx_utils.i_errbuf := l_retmsg;
1668: raise rule_exception;
1669: end if;
1670:

Line 1667: ecx_utils.i_errbuf := l_retmsg;

1663: l_payload := p_event.getEventData();
1664: if (l_payload is null) or
1665: (dbms_lob.getlength(l_payload) = 0) then
1666: ecx_utils.i_ret_code := l_retcode;
1667: ecx_utils.i_errbuf := l_retmsg;
1668: raise rule_exception;
1669: end if;
1670:
1671: l_transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');

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

1741: end if;
1742: elsif (l_retcode >= 2) then
1743: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1744: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1745: ecx_debug.getMessage(ecx_utils.i_errbuf, ecx_utils.i_errparams));
1746: end if;
1747: raise rule_exception;
1748: end if;
1749: end; -- save to doc_logs

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

1787:
1788: -- start to do the inbound processing and then dispatch the product
1789: -- team specified event.
1790: if (l_queue_name is null) then
1791: ecx_utils.g_direction := 'IN';
1792: ecx_utils.g_transaction_type := l_transaction_type;
1793: ecx_utils.g_transaction_subtype := l_transaction_subtype;
1794:
1795: setDebugMode (

Line 1792: ecx_utils.g_transaction_type := l_transaction_type;

1788: -- start to do the inbound processing and then dispatch the product
1789: -- team specified event.
1790: if (l_queue_name is null) then
1791: ecx_utils.g_direction := 'IN';
1792: ecx_utils.g_transaction_type := l_transaction_type;
1793: ecx_utils.g_transaction_subtype := l_transaction_subtype;
1794:
1795: setDebugMode (
1796: p_subscription_guid => p_subscription_guid,

Line 1793: ecx_utils.g_transaction_subtype := l_transaction_subtype;

1789: -- team specified event.
1790: if (l_queue_name is null) then
1791: ecx_utils.g_direction := 'IN';
1792: ecx_utils.g_transaction_type := l_transaction_type;
1793: ecx_utils.g_transaction_subtype := l_transaction_subtype;
1794:
1795: setDebugMode (
1796: p_subscription_guid => p_subscription_guid,
1797: p_transaction_type => l_transaction_type,

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

1804: 'FND Debug level is set to '
1805: || fnd_log.g_current_runtime_level );
1806: end if;
1807: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1808: if (ecx_utils.i_ret_code <> 2) then
1809: if (ecx_utils.g_event is not null and
1810: ecx_utils.g_event.event_name is not null) then
1811: p_event := ecx_utils.g_event;
1812:

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

1805: || fnd_log.g_current_runtime_level );
1806: end if;
1807: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1808: if (ecx_utils.i_ret_code <> 2) then
1809: if (ecx_utils.g_event is not null and
1810: ecx_utils.g_event.event_name is not null) then
1811: p_event := ecx_utils.g_event;
1812:
1813: setEventParam(

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

1806: end if;
1807: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1808: if (ecx_utils.i_ret_code <> 2) then
1809: if (ecx_utils.g_event is not null and
1810: ecx_utils.g_event.event_name is not null) then
1811: p_event := ecx_utils.g_event;
1812:
1813: setEventParam(
1814: p_msgid => l_msgid,

Line 1811: p_event := ecx_utils.g_event;

1807: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1808: if (ecx_utils.i_ret_code <> 2) then
1809: if (ecx_utils.g_event is not null and
1810: ecx_utils.g_event.event_name is not null) then
1811: p_event := ecx_utils.g_event;
1812:
1813: setEventParam(
1814: p_msgid => l_msgid,
1815: p_transaction_type => l_transaction_type,

Line 1856: ecx_utils.i_ret_code,

1852: ecx_errorlog.inbound_trigger(
1853: l_trigger_id,
1854: l_msgid,
1855: l_process_id,
1856: ecx_utils.i_ret_code,
1857: ecx_utils.i_errbuf
1858: );
1859: end if;
1860:

Line 1857: ecx_utils.i_errbuf

1853: l_trigger_id,
1854: l_msgid,
1855: l_process_id,
1856: ecx_utils.i_ret_code,
1857: ecx_utils.i_errbuf
1858: );
1859: end if;
1860:
1861: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;

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

1859: end if;
1860:
1861: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;
1862:
1863: if (ecx_utils.i_ret_code = 2) then
1864: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1865: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Error.');
1866: end if;
1867: ecx_debug.setErrorInfo(2,30, 'ECX_IN_RULE_PROCESING_ERROR');

Line 1883: ecx_utils.i_ret_code,

1879: ecx_errorlog.inbound_trigger(
1880: l_trigger_id,
1881: l_msgid,
1882: l_process_id,
1883: ecx_utils.i_ret_code,
1884: ecx_utils.i_errbuf,
1885: ecx_utils.i_errparams
1886: );
1887:

Line 1884: ecx_utils.i_errbuf,

1880: l_trigger_id,
1881: l_msgid,
1882: l_process_id,
1883: ecx_utils.i_ret_code,
1884: ecx_utils.i_errbuf,
1885: ecx_utils.i_errparams
1886: );
1887:
1888: wf_event.setErrorInfo(p_event,'ERROR');

Line 1885: ecx_utils.i_errparams

1881: l_msgid,
1882: l_process_id,
1883: ecx_utils.i_ret_code,
1884: ecx_utils.i_errbuf,
1885: ecx_utils.i_errparams
1886: );
1887:
1888: wf_event.setErrorInfo(p_event,'ERROR');
1889: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

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

1885: ecx_utils.i_errparams
1886: );
1887:
1888: wf_event.setErrorInfo(p_event,'ERROR');
1889: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1890: ecx_utils.i_errparams));
1891: if (p_event.event_key is null)
1892: then
1893: p_event.event_key := l_msgid;

Line 1890: ecx_utils.i_errparams));

1886: );
1887:
1888: wf_event.setErrorInfo(p_event,'ERROR');
1889: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1890: ecx_utils.i_errparams));
1891: if (p_event.event_key is null)
1892: then
1893: p_event.event_key := l_msgid;
1894: end if;

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

1891: if (p_event.event_key is null)
1892: then
1893: p_event.event_key := l_msgid;
1894: end if;
1895: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1896: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1897: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1898: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1899: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);

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

1892: then
1893: p_event.event_key := l_msgid;
1894: end if;
1895: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1896: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1897: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1898: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1899: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
1900: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_transaction_type);

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

1893: p_event.event_key := l_msgid;
1894: end if;
1895: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1896: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1897: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1898: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1899: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
1900: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_transaction_type);
1901: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE',l_transaction_subtype);

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

1894: end if;
1895: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1896: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
1897: p_event.AddParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
1898: p_event.AddParameterToList('ECX_ERROR_TYPE', ecx_utils.error_type);
1899: p_event.AddParameterToList('ECX_TP_HEADER_ID', l_tp_header_id);
1900: p_event.AddParameterToList('ECX_TRANSACTION_TYPE',l_transaction_type);
1901: p_event.AddParameterToList('ECX_TRANSACTION_SUBTYPE',l_transaction_subtype);
1902: p_event.AddParameterToList('ECX_PARTY_ID',l_party_id);