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_PURGE dependencies on ECX_MSG_LOGS

Line 24: TYPE t_error_id_tl is TABLE of ecx_msg_logs.error_id%type;

20: toDate in date,
21: commitFlag in boolean) IS
22:
23: TYPE t_trigger_id_tl is TABLE of ecx_outbound_logs.trigger_id%type;
24: TYPE t_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
25:
26: v_trigger_id_tl t_trigger_id_tl := t_trigger_id_tl();
27: v_error_id_tl t_error_id_tl;
28:

Line 35: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

31: l_Select VARCHAR2(2400);
32: l_trigger_ID ecx_outbound_logs.trigger_id%type;
33:
34: cursor get_out_error_id (p_trigger_id in ecx_outbound_logs.TRIGGER_ID%type) is
35: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
36:
37: bulk_delete_cycles pls_integer;
38: bulk_delete_first pls_integer;
39: bulk_delete_last pls_integer;

Line 131: delete from ecx_msg_logs where error_id = v_error_id_tl(j);

127: -- dbms_output.put_line('v_error_id_tl.count Purge_Outbound commiting ecx_error_msgs i = '|| to_char(i));
128: commit;
129: END IF;
130: FORALL j IN bulk_delete_first..bulk_delete_last
131: delete from ecx_msg_logs where error_id = v_error_id_tl(j);
132: IF (commitFlag) THEN
133: -- dbms_output.put_line('v_error_id_tl.count Purge_Outbound commiting ecx_msg_logs i = '|| to_char(i));
134: commit;
135: END IF;

Line 133: -- dbms_output.put_line('v_error_id_tl.count Purge_Outbound commiting ecx_msg_logs i = '|| to_char(i));

129: END IF;
130: FORALL j IN bulk_delete_first..bulk_delete_last
131: delete from ecx_msg_logs where error_id = v_error_id_tl(j);
132: IF (commitFlag) THEN
133: -- dbms_output.put_line('v_error_id_tl.count Purge_Outbound commiting ecx_msg_logs i = '|| to_char(i));
134: commit;
135: END IF;
136: end loop;
137: end if;

Line 206: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is

202: cursor get_ext_log_error_id (p_msgid in ecx_doclogs.msgid%type) is
203: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
204: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
205: select error_id from ecx_external_retry where msgid = p_msgid;
206: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
207: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
208: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
209: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
210:

Line 207: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

203: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
204: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
205: select error_id from ecx_external_retry where msgid = p_msgid;
206: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
207: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
208: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
209: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
210:
211: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;

Line 208: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is

204: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
205: select error_id from ecx_external_retry where msgid = p_msgid;
206: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
207: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
208: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
209: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
210:
211: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
212: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;

Line 209: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

205: select error_id from ecx_external_retry where msgid = p_msgid;
206: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
207: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
208: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
209: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
210:
211: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
212: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;
213: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;

Line 217: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;

213: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
214: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
215: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
216: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
217: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
218: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
219: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
220:
221: v_message_id_tl t_message_id_tl:= t_message_id_tl();

Line 218: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;

214: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
215: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
216: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
217: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
218: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
219: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
220:
221: v_message_id_tl t_message_id_tl:= t_message_id_tl();
222: v_itemtype_tl t_itemtype_id_tl := t_itemtype_id_tl();

Line 219: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;

215: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
216: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
217: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
218: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
219: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
220:
221: v_message_id_tl t_message_id_tl:= t_message_id_tl();
222: v_itemtype_tl t_itemtype_id_tl := t_itemtype_id_tl();
223: v_itemkey_tl t_itemkey_id_tl := t_itemkey_id_tl();

Line 348: delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);

344: fetch get_in_error_id bulk collect into v_in_error_id_tl ;
345: FORALL i IN 1..v_in_error_id_tl.count
346: delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);
347: FORALL i IN 1..v_in_error_id_tl.count
348: delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);
349: close get_in_error_id;
350: END LOOP;
351: close get_in_trigger_id;
352:

Line 362: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);

358: fetch get_out_error_id bulk collect into v_out_error_id_tl ;
359: FORALL i IN 1..v_out_error_id_tl.count
360: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);
361: FORALL i IN 1..v_out_error_id_tl.count
362: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);
363: close get_out_error_id;
364: END LOOP;
365: close get_out_trigger_id;
366:

Line 381: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);

377: FORALL i IN 1..v_ext_log_error_id_tl.count
378: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);
379:
380: FORALL i IN 1..v_ext_log_error_id_tl.count
381: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
382:
383: FORALL i IN 1..v_ext_ret_error_id_tl.count
384: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
385:

Line 387: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);

383: FORALL i IN 1..v_ext_ret_error_id_tl.count
384: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
385:
386: FORALL i IN 1..v_ext_ret_error_id_tl.count
387: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);
388:
389: delete from ecx_external_retry WHERE msgid =v_message_id_tl(i);
390: delete from ecx_inbound_logs WHERE msgid =v_message_id_tl(i);
391: delete from ecx_outbound_logs WHERE out_msgid =v_message_id_tl(i);

Line 479: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is

475: cursor get_ext_log_error_id (p_msgid in ecx_doclogs.msgid%type) is
476: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
477: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
478: select error_id from ecx_external_retry where msgid = p_msgid;
479: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
480: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
481: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
482: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
483:

Line 480: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

476: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
477: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
478: select error_id from ecx_external_retry where msgid = p_msgid;
479: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
480: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
481: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
482: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
483:
484:

Line 481: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is

477: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
478: select error_id from ecx_external_retry where msgid = p_msgid;
479: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
480: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
481: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
482: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
483:
484:
485: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;

Line 482: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

478: select error_id from ecx_external_retry where msgid = p_msgid;
479: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
480: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
481: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
482: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
483:
484:
485: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
486: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;

Line 491: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;

487: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
488: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
489: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
490: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
491: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
492: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
493: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
494:
495: v_msgid ecx_doclogs.msgid%type;

Line 492: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;

488: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
489: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
490: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
491: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
492: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
493: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
494:
495: v_msgid ecx_doclogs.msgid%type;
496: v_message_id_tl t_message_id_tl;

Line 493: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;

489: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
490: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
491: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
492: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
493: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
494:
495: v_msgid ecx_doclogs.msgid%type;
496: v_message_id_tl t_message_id_tl;
497: v_itemtype_tl t_itemtype_id_tl;

Line 551: delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);

547: fetch get_in_error_id bulk collect into v_in_error_id_tl ;
548: FORALL i IN 1..v_in_error_id_tl.count
549: delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);
550: FORALL i IN 1..v_in_error_id_tl.count
551: delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);
552: close get_in_error_id;
553: END LOOP;
554: close get_in_trigger_id;
555:

Line 565: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);

561: fetch get_out_error_id bulk collect into v_out_error_id_tl ;
562: FORALL i IN 1..v_out_error_id_tl.count
563: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);
564: FORALL i IN 1..v_out_error_id_tl.count
565: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);
566: close get_out_error_id;
567: END LOOP;
568: close get_out_trigger_id;
569:

Line 584: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);

580: FORALL i IN 1..v_ext_log_error_id_tl.count
581: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);
582:
583: FORALL i IN 1..v_ext_log_error_id_tl.count
584: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
585:
586: FORALL i IN 1..v_ext_ret_error_id_tl.count
587: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
588:

Line 590: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);

586: FORALL i IN 1..v_ext_ret_error_id_tl.count
587: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
588:
589: FORALL i IN 1..v_ext_ret_error_id_tl.count
590: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);
591:
592: delete from ecx_external_retry WHERE msgid =v_msgid;
593: delete from ecx_inbound_logs WHERE msgid =v_msgid;
594: delete from ecx_outbound_logs WHERE out_msgid =v_msgid;