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.OE_PURGE_WF dependencies on WF_PURGE

Line 55: oe_debug_pub.add( 'Entering the procedure oe_purge_wf.purge_orphan_errors',1);

51: /*came up with the above cursor, to honour the attempt to close parameter, when
52: item type is passed as 'OMERROR' and a specific error key is passed*/
53: BEGIN
54: IF g_debug_level > 0 THEN
55: oe_debug_pub.add( 'Entering the procedure oe_purge_wf.purge_orphan_errors',1);
56: END IF ;
57: IF p_item_key IS NULL THEN
58: IF g_debug_level > 0 THEN
59: oe_debug_pub.add( 'Item key is not passed. Fetching all the orphan error flows.',2);

Line 84: wf_purge.items(itemtype => l_errors_tbl(i).ITEM_TYPE, itemkey => l_errors_tbl(i).ITEM_KEY, docommit => FALSE, force=>TRUE);

80: END;
81: IF g_debug_level > 0 THEN
82: oe_debug_pub.add( 'Purging the error flow for item_type and item_key'||l_errors_tbl(i).ITEM_TYPE||'and'||l_errors_tbl(i).ITEM_KEY,5);
83: END IF ;
84: wf_purge.items(itemtype => l_errors_tbl(i).ITEM_TYPE, itemkey => l_errors_tbl(i).ITEM_KEY, docommit => FALSE, force=>TRUE);
85: g_purge_count:=g_purge_count+1;
86: END LOOP ;
87: END IF ;
88: l_errors_tbl.DELETE ;

Line 120: wf_purge.items(itemtype => l_errors_tbl(i).ITEM_TYPE, itemkey => l_errors_tbl(i).ITEM_KEY, docommit => FALSE, force=>TRUE);

116: END;
117: IF g_debug_level > 0 THEN
118: oe_debug_pub.add( 'Purging the error flow for item_type and item_key'||l_errors_tbl(i).ITEM_TYPE||'and'||l_errors_tbl(i).ITEM_KEY,5);
119: END IF ;
120: wf_purge.items(itemtype => l_errors_tbl(i).ITEM_TYPE, itemkey => l_errors_tbl(i).ITEM_KEY, docommit => FALSE, force=>TRUE);
121: g_purge_count:=g_purge_count+1;
122: END LOOP ;
123: END IF ;
124: l_errors_tbl.DELETE ;

Line 131: oe_debug_pub.add( 'Exiting oe_purge_wf.purge_orphan_errors',1);

127: END LOOP ;
128: CLOSE specific_error;
129: END IF ;
130: IF g_debug_level > 0 THEN
131: oe_debug_pub.add( 'Exiting oe_purge_wf.purge_orphan_errors',1);
132: END IF ;
133: EXCEPTION
134: WHEN OTHERS THEN
135: IF g_debug_level > 0 THEN

Line 136: oe_debug_pub.add( 'In others exception of oe_purge_wf.purge_orphan_errors',1);

132: END IF ;
133: EXCEPTION
134: WHEN OTHERS THEN
135: IF g_debug_level > 0 THEN
136: oe_debug_pub.add( 'In others exception of oe_purge_wf.purge_orphan_errors',1);
137: END IF ;
138: oe_debug_pub.add( sqlerrm);
139: l_errors_tbl.DELETE ;
140: IF errors%isopen THEN

Line 258: WF_PURGE.ITEMS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY, DOCOMMIT=>FALSE, FORCE=>TRUE);

254: END;
255: IF g_debug_level > 0 THEN
256: oe_debug_pub.ADD('Purging the error item_type and error item_key'||l_error_tbl(j).ITEM_TYPE||'and'||l_error_tbl(j).ITEM_KEY,1 ) ;
257: END IF;
258: WF_PURGE.ITEMS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY, DOCOMMIT=>FALSE, FORCE=>TRUE);
259: g_purge_count:=g_purge_count+1;
260: END LOOP; --looping in the error table
261: l_error_tbl.DELETE ;
262: END IF;

Line 331: WF_PURGE.ITEMS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY, DOCOMMIT=>FALSE, FORCE=>TRUE);

327: END;
328: IF g_debug_level > 0 THEN
329: oe_debug_pub.ADD('Purging the error item type and error item key'||l_error_tbl(j).ITEM_TYPE||'and'||l_error_tbl(j).ITEM_KEY,3) ;
330: END IF;
331: WF_PURGE.ITEMS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY, DOCOMMIT=>FALSE, FORCE=>TRUE);
332: g_purge_count:=g_purge_count+1;
333: END LOOP; --error table count
334: l_error_tbl.DELETE ;
335: END IF;

Line 406: oe_debug_pub.add( 'Entering oe_purge_wf.purge_item_type:'||p_item_type ,1) ;

402: WHERE item_type=p_item_type
403: AND end_date <= (SYSDATE-g_age);
404: BEGIN
405: IF g_debug_level > 0 THEN
406: oe_debug_pub.add( 'Entering oe_purge_wf.purge_item_type:'||p_item_type ,1) ;
407: END IF;
408: OPEN to_purge ;
409: LOOP
410: FETCH to_purge BULK COLLECT INTO l_purge_tbl limit g_commit_frequency;

Line 420: WF_PURGE.ITEMS(ITEMTYPE =>l_purge_tbl(i).item_type, ITEMKEY=>l_purge_tbl(i).item_key, DOCOMMIT=>FALSE, FORCE=>TRUE);

416: BEGIN
417: IF g_debug_level > 0 THEN
418: oe_debug_pub.add( 'Before purging the item_key:'||l_purge_tbl(i).item_key ,1) ;
419: END IF;
420: WF_PURGE.ITEMS(ITEMTYPE =>l_purge_tbl(i).item_type, ITEMKEY=>l_purge_tbl(i).item_key, DOCOMMIT=>FALSE, FORCE=>TRUE);
421: g_purge_count:=g_purge_count+1;
422: EXCEPTION
423: WHEN OTHERS THEN
424: NULL;

Line 435: oe_debug_pub.add( 'Exiting oe_purge_wf.purge_item_type',1 ) ;

431: WHEN to_purge%NOTFOUND ;
432: END LOOP ;
433: CLOSE to_purge ;
434: IF g_debug_level > 0 THEN
435: oe_debug_pub.add( 'Exiting oe_purge_wf.purge_item_type',1 ) ;
436: END IF;
437: EXCEPTION
438: WHEN OTHERS THEN
439: oe_debug_pub.add(FND_FILE.OUTPUT,sqlerrm);

Line 472: oe_debug_pub.add( 'Entering oe_purge_wf.purge_om_flows',1) ;

468: WHERE end_date <= (SYSDATE-g_age)
469: AND item_type IN ('OEOH','OEOL','OENH','OEBH','OMERROR','OEAME'); -- AME ER 16084377
470: BEGIN
471: IF g_debug_level > 0 THEN
472: oe_debug_pub.add( 'Entering oe_purge_wf.purge_om_flows',1) ;
473: oe_debug_pub.add( 'Item type passed is:'||p_item_type,1);
474: oe_debug_pub.add( 'Item key passed is:'||p_item_key,1);
475: oe_debug_pub.add( 'Attempt to close passed is:'||p_attempt_to_close,1);
476: oe_debug_pub.add( 'Elapsed days After closure passed is:'||p_age,1);

Line 506: WF_PURGE.ITEMS(ITEMTYPE =>l_item_type, ITEMKEY=>p_item_key, DOCOMMIT=>FALSE, FORCE=>TRUE);

502: are passed.*/
503: IF g_debug_level > 0 THEN
504: oe_debug_pub.add( 'end date is not null');
505: END IF ;
506: WF_PURGE.ITEMS(ITEMTYPE =>l_item_type, ITEMKEY=>p_item_key, DOCOMMIT=>FALSE, FORCE=>TRUE);
507: g_purge_count:=g_purge_count+1;
508: ELSIF l_end_date IS NULL THEN
509:
510: IF p_attempt_to_close='Y'THEN

Line 538: WF_PURGE.ITEMS(ITEMTYPE =>l_item_type, ITEMKEY=>p_item_key, DOCOMMIT=>FALSE, FORCE=>TRUE);

534: IF l_end_date IS NOT NULL THEN
535: IF g_debug_level > 0 THEN
536: oe_debug_pub.add( 'Before Purging');
537: END IF ;
538: WF_PURGE.ITEMS(ITEMTYPE =>l_item_type, ITEMKEY=>p_item_key, DOCOMMIT=>FALSE, FORCE=>TRUE);
539: g_purge_count:=g_purge_count+1;
540: END IF ;
541: END IF ;
542: END IF ;

Line 599: WF_PURGE.ITEMS(ITEMTYPE =>l_purge_tbl(i).item_type, ITEMKEY=>l_purge_tbl(i).item_key, DOCOMMIT=>FALSE, FORCE=>TRUE);

595: BEGIN
596: IF g_debug_level > 0 THEN
597: oe_debug_pub.add( 'Before purging for item_type and item_key'||l_purge_tbl(i).item_type||','||l_purge_tbl(i).item_key );
598: END IF ;
599: WF_PURGE.ITEMS(ITEMTYPE =>l_purge_tbl(i).item_type, ITEMKEY=>l_purge_tbl(i).item_key, DOCOMMIT=>FALSE, FORCE=>TRUE);
600: g_purge_count:=g_purge_count+1;
601: EXCEPTION
602: WHEN OTHERS THEN
603: NULL;