DBA Data[Home] [Help]

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 237: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_reqs','No data found');

233:
234:
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_reqs','No data found');
238: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_reqs: 901 - ' ||
239: 'EXCEPTION - no data found sql error: ' || sqlcode;
240: IF (g_po_wf_debug = 'Y') THEN
241: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

242: END IF;
243:
244:
245: WHEN OTHERS THEN
246: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_reqs','SQL error ' || sqlcode);
247: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_reqs: 990 - ' ||
248: 'EXCEPTION - sql error: ' || sqlcode;
249: IF (g_po_wf_debug = 'Y') THEN
250: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

422: END IF;
423:
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_pos','No data found');
427:
428: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_pos: 901 - ' ||
429: 'EXCEPTION - no data found sql error: ' || sqlcode;
430: IF (g_po_wf_debug = 'Y') THEN

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

431: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
432: END IF;
433:
434: WHEN OTHERS THEN
435: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_pos','SQL error ' || sqlcode);
436:
437: l_progress := 'PO_APPROVAL_REMINDER_SV.Process unapprove_pos: 990 - ' ||
438: 'EXCEPTION - sql error: ' || sqlcode;
439: IF (g_po_wf_debug = 'Y') THEN

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

614: END IF;
615:
616: EXCEPTION
617: WHEN NO_DATA_FOUND THEN
618: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_releases','No data found');
619: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_Unapprove_releases: 901 - ' ||
620: 'EXCEPTION - no data found sql error: ' || sqlcode;
621: IF (g_po_wf_debug = 'Y') THEN
622: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

623: END IF;
624:
625:
626: WHEN OTHERS THEN
627: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Unapprove_releases','SQL error ' || sqlcode);
628: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_Unapprove_releases: 990 - ' ||
629: 'EXCEPTION - sql error: ' || sqlcode;
630: IF (g_po_wf_debug = 'Y') THEN
631: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

952: END IF;
953:
954: EXCEPTION
955: WHEN NO_DATA_FOUND THEN
956: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_po_acceptance','No data found');
957: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 901 - ' ||
958: 'EXCEPTION - no data found sql error: ' || sqlcode;
959: IF (g_po_wf_debug = 'Y') THEN
960: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

960: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
961: END IF;
962:
963: WHEN OTHERS THEN
964: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_po_acceptance','SQL error ' || sqlcode);
965: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_po_acceptance: 990 - ' ||
966: 'EXCEPTION - sql error: ' || sqlcode;
967: IF (g_po_wf_debug = 'Y') THEN
968: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

1303:
1304:
1305: EXCEPTION
1306: WHEN NO_DATA_FOUND THEN
1307: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rel_acceptance','No data found');
1308: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 901 - ' ||
1309: 'EXCEPTION - no data found sql error: ' || sqlcode;
1310: IF (g_po_wf_debug = 'Y') THEN
1311: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

1311: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1312: END IF;
1313:
1314: WHEN OTHERS THEN
1315: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rel_acceptance','SQL error ' || sqlcode);
1316: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rel_acceptance: 990 - ' ||
1317: 'EXCEPTION - sql error: ' || sqlcode;
1318: IF (g_po_wf_debug = 'Y') THEN
1319: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

1582:
1583:
1584: EXCEPTION
1585: WHEN NO_DATA_FOUND THEN
1586: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rfq_quote','No data found');
1587: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 901 - ' ||
1588: 'EXCEPTION - no data found sql error: ' || sqlcode;
1589: IF (g_po_wf_debug = 'Y') THEN
1590: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

1590: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1591: END IF;
1592:
1593: WHEN OTHERS THEN
1594: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_rfq_quote','SQL error ' || sqlcode);
1595: l_progress := 'PO_APPROVAL_REMINDER_SV.Process_rfq_quote: 990 - ' ||
1596: 'EXCEPTION - sql error: ' || sqlcode;
1597: IF (g_po_wf_debug = 'Y') THEN
1598: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

1733:
1734: EXCEPTION
1735:
1736: WHEN OTHERS THEN
1737: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Approval_Reminder','SQL error ' || sqlcode);
1738: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Approval_Reminder: 990 - ' ||
1739: 'EXCEPTION - sql error: ' || sqlcode;
1740: IF (g_po_wf_debug = 'Y') THEN
1741: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);

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

2090:
2091:
2092: EXCEPTION
2093: WHEN NO_DATA_FOUND THEN
2094: wf_core.context ('PO_APPROVAL_REMINDER_SV','Set_Doc_Type','No data found');
2095: l_progress := 'PO_APPROVAL_REMINDER_SV.Set_Doc_Type: 901 - ' ||
2096: 'EXCEPTION - no data found sql error: ' || sqlcode;
2097: IF (g_po_wf_debug = 'Y') THEN
2098: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

2098: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2099: END IF;
2100:
2101: WHEN OTHERS THEN
2102: wf_core.context ('PO_APPROVAL_REMINDER_SV','Set_Doc_Type','SQL error ' || sqlcode);
2103: l_progress := 'PO_APPROVAL_REMINDER_SV.Set_Doc_Type: 990 - ' ||
2104: 'EXCEPTION - sql error: ' || sqlcode;
2105: IF (g_po_wf_debug = 'Y') THEN
2106: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

2287:
2288:
2289: EXCEPTION
2290: WHEN NO_DATA_FOUND THEN
2291: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Doc_Approval','No data found');
2292: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Doc_Approval: 901 - ' ||
2293: 'EXCEPTION - no data found sql error: ' || sqlcode;
2294: IF (g_po_wf_debug = 'Y') THEN
2295: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

2296: END IF;
2297:
2298:
2299: WHEN OTHERS THEN
2300: wf_core.context ('PO_APPROVAL_REMINDER_SV','Start_Doc_Approval','SQL error ' || sqlcode);
2301: l_progress := 'PO_APPROVAL_REMINDER_SV.Start_Doc_Approval: 990 - ' ||
2302: 'EXCEPTION - sql error: ' || sqlcode;
2303: IF (g_po_wf_debug = 'Y') THEN
2304: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

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

2557:
2558: EXCEPTION
2559:
2560: WHEN OTHERS THEN
2561: wf_core.context ('PO_APPROVAL_REMINDER_SV','SetUpWorkFlow','SQL error ' || sqlcode);
2562: l_progress := 'PO_APPROVAL_REMINDER_SV.SetUpWorkFlow: 990 - ' ||
2563: 'EXCEPTION - sql error: ' || sqlcode;
2564: IF (g_po_wf_debug = 'Y') THEN
2565: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug('APVRMDER',l_itemkey,l_progress);

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

2760:
2761: EXCEPTION
2762:
2763: WHEN OTHERS THEN
2764: wf_core.context ('PO_APPROVAL_REMINDER_SV','Is_Forward_To_Valid','SQL error ' || sqlcode);
2765: x_progress := 'PO_APPROVAL_REMINDER_SV.Is_Forward_To_Valid: 990 - ' ||
2766: 'EXCEPTION - sql error: ' || sqlcode;
2767: IF (g_po_wf_debug = 'Y') THEN
2768: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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

3053: WHEN OTHERS THEN
3054: IF (g_po_wf_debug = 'Y') THEN
3055: PO_WF_DEBUG_PKG.insert_debug(null,null,x_progress);
3056: END IF;
3057: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Cancel_notification','SQL error ' || sqlcode);
3058: RAISE;
3059:
3060: END Cancel_Notif;
3061:

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

3103: WHEN OTHERS THEN
3104: IF (g_po_wf_debug = 'Y') THEN
3105: PO_WF_DEBUG_PKG.insert_debug(null,null,x_progress);
3106: END IF;
3107: wf_core.context ('PO_APPROVAL_REMINDER_SV','Process_Check_Status','SQL error ' || sqlcode);
3108: RAISE;
3109: return FALSE;
3110: END;
3111:

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

3158: p_item_end_date := NULL;
3159:
3160: WHEN OTHERS THEN
3161:
3162: wf_core.context ('PO_APPROVAL_REMINDER_SV','Item_exist','SQL error ' || sqlcode);
3163: l_progress := 'PO_APPROVAL_REMINDER_SV.Item_Exist: 990 - ' ||
3164: 'EXCEPTION - sql error: ' || sqlcode;
3165: IF (g_po_wf_debug = 'Y') THEN
3166: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);

Line 3638: wf_core.context( 'PO_APPROVAL_REMINDER_SV',

3634: resultout := wf_engine.eng_completed || ':' || l_line_reminder_type;
3635:
3636: EXCEPTION
3637: WHEN OTHERS THEN
3638: wf_core.context( 'PO_APPROVAL_REMINDER_SV',
3639: 'GET_TEMP_LABOR_REMINDER_TYPE' );
3640: RAISE;
3641: END get_po_line_reminder_type;
3642: