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.PO_APPROVAL_REMINDER_SV dependencies on WF_CORE

Line 65: wf_core.context ('PO_APPROVAL_REMINDER_SV','Select_Unapprove_docs ' || l_progress);

61: EXCEPTION
62:
63: WHEN OTHERS THEN
64:
65: wf_core.context ('PO_APPROVAL_REMINDER_SV','Select_Unapprove_docs ' || l_progress);
66: l_progress := 'PO_APPROVAL_REMINDER_SV.Select_Unapprove_docs: 990 - ' ||
67: 'EXCEPTION sql error: ' || sqlcode;
68: IF (g_po_wf_debug = 'Y') THEN
69: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 249: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_reqs','No data found');

245:
246:
247: EXCEPTION
248: WHEN NO_DATA_FOUND THEN
249: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_reqs','No data found');
250: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_reqs: 901 - ' ||
251: 'EXCEPTION - no data found sql error: ' || sqlcode;
252: IF (g_po_wf_debug = 'Y') THEN
253: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 258: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_reqs','SQL error ' || sqlcode);

254: END IF;
255:
256:
257: WHEN OTHERS THEN
258: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_reqs','SQL error ' || sqlcode);
259: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_reqs: 990 - ' ||
260: 'EXCEPTION - sql error: ' || sqlcode;
261: IF (g_po_wf_debug = 'Y') THEN
262: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 438: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_pos','No data found');

434: END IF;
435:
436: EXCEPTION
437: WHEN NO_DATA_FOUND THEN
438: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_pos','No data found');
439:
440: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_pos: 901 - ' ||
441: 'EXCEPTION - no data found sql error: ' || sqlcode;
442: IF (g_po_wf_debug = 'Y') THEN

Line 447: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_pos','SQL error ' || sqlcode);

443: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
444: END IF;
445:
446: WHEN OTHERS THEN
447: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_pos','SQL error ' || sqlcode);
448:
449: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_pos: 990 - ' ||
450: 'EXCEPTION - sql error: ' || sqlcode;
451: IF (g_po_wf_debug = 'Y') THEN

Line 630: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_releases','No data found');

626: END IF;
627:
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_releases','No data found');
631: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_Unapprove_releases: 901 - ' ||
632: 'EXCEPTION - no data found sql error: ' || sqlcode;
633: IF (g_po_wf_debug = 'Y') THEN
634: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 639: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_releases','SQL error ' || sqlcode);

635: END IF;
636:
637:
638: WHEN OTHERS THEN
639: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_releases','SQL error ' || sqlcode);
640: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_Unapprove_releases: 990 - ' ||
641: 'EXCEPTION - sql error: ' || sqlcode;
642: IF (g_po_wf_debug = 'Y') THEN
643: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 985: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_po_acceptance','No data found');

981: END IF;
982:
983: EXCEPTION
984: WHEN NO_DATA_FOUND THEN
985: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_po_acceptance','No data found');
986: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 901 - ' ||
987: 'EXCEPTION - no data found sql error: ' || sqlcode;
988: IF (g_po_wf_debug = 'Y') THEN
989: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 993: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_po_acceptance','SQL error ' || sqlcode);

989: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
990: END IF;
991:
992: WHEN OTHERS THEN
993: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_po_acceptance','SQL error ' || sqlcode);
994: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 990 - ' ||
995: 'EXCEPTION - sql error: ' || sqlcode;
996: IF (g_po_wf_debug = 'Y') THEN
997: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 1336: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rel_acceptance','No data found');

1332:
1333:
1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rel_acceptance','No data found');
1337: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 901 - ' ||
1338: 'EXCEPTION - no data found sql error: ' || sqlcode;
1339: IF (g_po_wf_debug = 'Y') THEN
1340: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 1344: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rel_acceptance','SQL error ' || sqlcode);

1340: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1341: END IF;
1342:
1343: WHEN OTHERS THEN
1344: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rel_acceptance','SQL error ' || sqlcode);
1345: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 990 - ' ||
1346: 'EXCEPTION - sql error: ' || sqlcode;
1347: IF (g_po_wf_debug = 'Y') THEN
1348: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 1616: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rfq_quote','No data found');

1612:
1613:
1614: EXCEPTION
1615: WHEN NO_DATA_FOUND THEN
1616: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rfq_quote','No data found');
1617: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 901 - ' ||
1618: 'EXCEPTION - no data found sql error: ' || sqlcode;
1619: IF (g_po_wf_debug = 'Y') THEN
1620: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 1624: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rfq_quote','SQL error ' || sqlcode);

1620: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1621: END IF;
1622:
1623: WHEN OTHERS THEN
1624: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rfq_quote','SQL error ' || sqlcode);
1625: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 990 - ' ||
1626: 'EXCEPTION - sql error: ' || sqlcode;
1627: IF (g_po_wf_debug = 'Y') THEN
1628: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 1767: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Approval_Reminder','SQL error ' || sqlcode);

1763:
1764: EXCEPTION
1765:
1766: WHEN OTHERS THEN
1767: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Approval_Reminder','SQL error ' || sqlcode);
1768: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder: 990 - ' ||
1769: 'EXCEPTION - sql error: ' || sqlcode;
1770: IF (g_po_wf_debug = 'Y') THEN
1771: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

Line 2128: wf_core.context ('PO_APPROVAL_REMINDER_SV','Set_Doc_Type','No data found');

2124:
2125:
2126: EXCEPTION
2127: WHEN NO_DATA_FOUND THEN
2128: wf_core.context ('PO_APPROVAL_REMINDER_SV','Set_Doc_Type','No data found');
2129: l_progress := 'PO_APPROVAL_REMINDER_SV.Set_Doc_Type: 901 - ' ||
2130: 'EXCEPTION - no data found sql error: ' || sqlcode;
2131: IF (g_po_wf_debug = 'Y') THEN
2132: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 2136: wf_core.context ('PO_APPROVAL_REMINDER_SV','Set_Doc_Type','SQL error ' || sqlcode);

2132: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2133: END IF;
2134:
2135: WHEN OTHERS THEN
2136: wf_core.context ('PO_APPROVAL_REMINDER_SV','Set_Doc_Type','SQL error ' || sqlcode);
2137: l_progress := 'PO_APPROVAL_REMINDER_SV.Set_Doc_Type: 990 - ' ||
2138: 'EXCEPTION - sql error: ' || sqlcode;
2139: IF (g_po_wf_debug = 'Y') THEN
2140: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 2325: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Doc_Approval','No data found');

2321:
2322:
2323: EXCEPTION
2324: WHEN NO_DATA_FOUND THEN
2325: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Doc_Approval','No data found');
2326: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Doc_Approval: 901 - ' ||
2327: 'EXCEPTION - no data found sql error: ' || sqlcode;
2328: IF (g_po_wf_debug = 'Y') THEN
2329: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 2334: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Doc_Approval','SQL error ' || sqlcode);

2330: END IF;
2331:
2332:
2333: WHEN OTHERS THEN
2334: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Doc_Approval','SQL error ' || sqlcode);
2335: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Doc_Approval: 990 - ' ||
2336: 'EXCEPTION - sql error: ' || sqlcode;
2337: IF (g_po_wf_debug = 'Y') THEN
2338: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line 2595: wf_core.context ('PO_APPROVAL_REMINDER_SV','SetUpWorkFlow','SQL error ' || sqlcode);

2591:
2592: EXCEPTION
2593:
2594: WHEN OTHERS THEN
2595: wf_core.context ('PO_APPROVAL_REMINDER_SV','SetUpWorkFlow','SQL error ' || sqlcode);
2596: l_progress := 'PO_APPROVAL_REMINDER_SV.SetUpWorkFlow: 990 - ' ||
2597: 'EXCEPTION - sql error: ' || sqlcode;
2598: IF (g_po_wf_debug = 'Y') THEN
2599: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug('APVRMDER',l_itemkey,l_progress);

Line 2798: wf_core.context ('PO_APPROVAL_REMINDER_SV','Is_Forward_To_Valid','SQL error ' || sqlcode);

2794:
2795: EXCEPTION
2796:
2797: WHEN OTHERS THEN
2798: wf_core.context ('PO_APPROVAL_REMINDER_SV','Is_Forward_To_Valid','SQL error ' || sqlcode);
2799: x_progress := 'PO_APPROVAL_REMINDER_SV.Is_Forward_To_Valid: 990 - ' ||
2800: 'EXCEPTION - sql error: ' || sqlcode;
2801: IF (g_po_wf_debug = 'Y') THEN
2802: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 3091: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Cancel_notification','SQL error ' || sqlcode);

3087: WHEN OTHERS THEN
3088: IF (g_po_wf_debug = 'Y') THEN
3089: PO_WF_DEBUG_PKG.insert_debug(null,null,x_progress);
3090: END IF;
3091: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Cancel_notification','SQL error ' || sqlcode);
3092: RAISE;
3093:
3094: END Cancel_Notif;
3095:

Line 3141: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Check_Status','SQL error ' || sqlcode);

3137: WHEN OTHERS THEN
3138: IF (g_po_wf_debug = 'Y') THEN
3139: PO_WF_DEBUG_PKG.insert_debug(null,null,x_progress);
3140: END IF;
3141: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Check_Status','SQL error ' || sqlcode);
3142: RAISE;
3143: return FALSE;
3144: END;
3145:

Line 3196: wf_core.context ('PO_APPROVAL_REMINDER_SV','Item_exist','SQL error ' || sqlcode);

3192: p_item_end_date := NULL;
3193:
3194: WHEN OTHERS THEN
3195:
3196: wf_core.context ('PO_APPROVAL_REMINDER_SV','Item_exist','SQL error ' || sqlcode);
3197: l_progress := 'PO_APPROVAL_REMINDER_SV.Item_Exist: 990 - ' ||
3198: 'EXCEPTION - sql error: ' || sqlcode;
3199: IF (g_po_wf_debug = 'Y') THEN
3200: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

Line 3672: wf_core.context( 'PO_APPROVAL_REMINDER_SV',

3668: resultout := wf_engine.eng_completed || ':' || l_line_reminder_type;
3669:
3670: EXCEPTION
3671: WHEN OTHERS THEN
3672: wf_core.context( 'PO_APPROVAL_REMINDER_SV',
3673: 'GET_TEMP_LABOR_REMINDER_TYPE' );
3674: RAISE;
3675: END get_po_line_reminder_type;
3676: