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 133: delete from ecx_msg_logs where error_id = v_error_id_tl(j);

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

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

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

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

212: cursor get_ext_log_error_id (p_msgid in ecx_doclogs.msgid%type) is
213: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
214: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
215: select error_id from ecx_external_retry where msgid = p_msgid;
216: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
217: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
218: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
219: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
220:

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

213: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
214: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
215: select error_id from ecx_external_retry where msgid = p_msgid;
216: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
217: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
218: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
219: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
220:
221: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;

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

214: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
215: select error_id from ecx_external_retry where msgid = p_msgid;
216: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
217: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
218: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
219: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
220:
221: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
222: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;

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

215: select error_id from ecx_external_retry where msgid = p_msgid;
216: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
217: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
218: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
219: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
220:
221: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
222: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;
223: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;

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

223: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
224: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
225: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
226: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
227: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
228: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
229: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
230:
231: v_message_id_tl t_message_id_tl:= t_message_id_tl();

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

224: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
225: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
226: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
227: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
228: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
229: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
230:
231: v_message_id_tl t_message_id_tl:= t_message_id_tl();
232: v_itemtype_tl t_itemtype_id_tl := t_itemtype_id_tl();

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

225: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
226: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
227: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
228: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
229: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
230:
231: v_message_id_tl t_message_id_tl:= t_message_id_tl();
232: v_itemtype_tl t_itemtype_id_tl := t_itemtype_id_tl();
233: v_itemkey_tl t_itemkey_id_tl := t_itemkey_id_tl();

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

355: fetch get_in_error_id bulk collect into v_in_error_id_tl ;
356: FORALL i IN 1..v_in_error_id_tl.count
357: delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);
358: FORALL i IN 1..v_in_error_id_tl.count
359: delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);
360: close get_in_error_id;
361: END LOOP;
362: close get_in_trigger_id;
363:

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

369: fetch get_out_error_id bulk collect into v_out_error_id_tl ;
370: FORALL i IN 1..v_out_error_id_tl.count
371: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);
372: FORALL i IN 1..v_out_error_id_tl.count
373: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);
374: close get_out_error_id;
375: END LOOP;
376: close get_out_trigger_id;
377:

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

388: FORALL i IN 1..v_ext_log_error_id_tl.count
389: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);
390:
391: FORALL i IN 1..v_ext_log_error_id_tl.count
392: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
393:
394: FORALL i IN 1..v_ext_ret_error_id_tl.count
395: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
396:

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

394: FORALL i IN 1..v_ext_ret_error_id_tl.count
395: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
396:
397: FORALL i IN 1..v_ext_ret_error_id_tl.count
398: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);
399:
400: delete from ecx_external_retry WHERE msgid =v_message_id_tl(i);
401: delete from ecx_inbound_logs WHERE msgid =v_message_id_tl(i);
402: delete from ecx_outbound_logs WHERE out_msgid =v_message_id_tl(i);

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

490: cursor get_ext_log_error_id (p_msgid in ecx_doclogs.msgid%type) is
491: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
492: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
493: select error_id from ecx_external_retry where msgid = p_msgid;
494: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
495: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
496: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
497: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
498:

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

491: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
492: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
493: select error_id from ecx_external_retry where msgid = p_msgid;
494: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
495: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
496: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
497: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
498:
499:

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

492: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
493: select error_id from ecx_external_retry where msgid = p_msgid;
494: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
495: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
496: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
497: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
498:
499:
500: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;

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

493: select error_id from ecx_external_retry where msgid = p_msgid;
494: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
495: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
496: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
497: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
498:
499:
500: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
501: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;

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

502: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
503: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
504: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
505: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
506: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
507: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
508: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
509:
510: v_msgid ecx_doclogs.msgid%type;

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

503: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
504: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
505: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
506: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
507: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
508: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
509:
510: v_msgid ecx_doclogs.msgid%type;
511: v_message_id_tl t_message_id_tl;

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

504: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
505: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
506: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
507: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
508: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
509:
510: v_msgid ecx_doclogs.msgid%type;
511: v_message_id_tl t_message_id_tl;
512: v_itemtype_tl t_itemtype_id_tl;

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

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

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

576: fetch get_out_error_id bulk collect into v_out_error_id_tl ;
577: FORALL i IN 1..v_out_error_id_tl.count
578: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);
579: FORALL i IN 1..v_out_error_id_tl.count
580: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);
581: close get_out_error_id;
582: END LOOP;
583: close get_out_trigger_id;
584:

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

595: FORALL i IN 1..v_ext_log_error_id_tl.count
596: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);
597:
598: FORALL i IN 1..v_ext_log_error_id_tl.count
599: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
600:
601: FORALL i IN 1..v_ext_ret_error_id_tl.count
602: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
603:

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

601: FORALL i IN 1..v_ext_ret_error_id_tl.count
602: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
603:
604: FORALL i IN 1..v_ext_ret_error_id_tl.count
605: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);
606:
607: delete from ecx_external_retry WHERE msgid =v_msgid;
608: delete from ecx_inbound_logs WHERE msgid =v_msgid;
609: delete from ecx_outbound_logs WHERE out_msgid =v_msgid;