DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on WF_CORE

Line 547: wf_core.context ('PORCPTWF','Select_Orders','No data found');

543: end if;
544:
545: EXCEPTION
546: WHEN NO_DATA_FOUND THEN
547: wf_core.context ('PORCPTWF','Select_Orders','No data found');
548: WHEN OTHERS THEN
549: wf_core.context ('PORCPTWF','Select_Orders','SQL error ' || sqlcode);
550: RAISE;
551:

Line 549: wf_core.context ('PORCPTWF','Select_Orders','SQL error ' || sqlcode);

545: EXCEPTION
546: WHEN NO_DATA_FOUND THEN
547: wf_core.context ('PORCPTWF','Select_Orders','No data found');
548: WHEN OTHERS THEN
549: wf_core.context ('PORCPTWF','Select_Orders','SQL error ' || sqlcode);
550: RAISE;
551:
552:
553: END Select_Orders;

Line 892: wf_core.context ('PORCPTWF','Select_Internal_Orders','No data found');

888: CLOSE porcpt_c;
889:
890: EXCEPTION
891: WHEN NO_DATA_FOUND THEN
892: wf_core.context ('PORCPTWF','Select_Internal_Orders','No data found');
893: WHEN OTHERS THEN
894: wf_core.context ('PORCPTWF','Select_Internal_Orders','SQL error ' || sqlcode);
895: RAISE;
896:

Line 894: wf_core.context ('PORCPTWF','Select_Internal_Orders','SQL error ' || sqlcode);

890: EXCEPTION
891: WHEN NO_DATA_FOUND THEN
892: wf_core.context ('PORCPTWF','Select_Internal_Orders','No data found');
893: WHEN OTHERS THEN
894: wf_core.context ('PORCPTWF','Select_Internal_Orders','SQL error ' || sqlcode);
895: RAISE;
896:
897:
898: END Select_Internal_Orders;

Line 1089: wf_core.context ('PORCPTWF','Start_Rcpt_Process','No data found');

1085:
1086: EXCEPTION
1087:
1088: WHEN NO_DATA_FOUND THEN
1089: wf_core.context ('PORCPTWF','Start_Rcpt_Process','No data found');
1090: WHEN OTHERS THEN
1091: wf_core.context ('PORCPTWF','Start_Rcpt_Process','SQL error ' || sqlcode);
1092: RAISE;
1093:

Line 1091: wf_core.context ('PORCPTWF','Start_Rcpt_Process','SQL error ' || sqlcode);

1087:
1088: WHEN NO_DATA_FOUND THEN
1089: wf_core.context ('PORCPTWF','Start_Rcpt_Process','No data found');
1090: WHEN OTHERS THEN
1091: wf_core.context ('PORCPTWF','Start_Rcpt_Process','SQL error ' || sqlcode);
1092: RAISE;
1093:
1094:
1095: END Start_Rcpt_Process;

Line 1267: wf_core.context ('PORCPTWF','Get_Order_Info','No data found');

1263:
1264: EXCEPTION
1265: WHEN NO_DATA_FOUND THEN
1266:
1267: wf_core.context ('PORCPTWF','Get_Order_Info','No data found');
1268:
1269: WHEN OTHERS THEN
1270:
1271: wf_core.context ('PORCPTWF','Get_Order_Info','SQL error ' || sqlcode);

Line 1271: wf_core.context ('PORCPTWF','Get_Order_Info','SQL error ' || sqlcode);

1267: wf_core.context ('PORCPTWF','Get_Order_Info','No data found');
1268:
1269: WHEN OTHERS THEN
1270:
1271: wf_core.context ('PORCPTWF','Get_Order_Info','SQL error ' || sqlcode);
1272:
1273: RAISE;
1274:
1275:

Line 1408: wf_core.context ('PORCPTWF','Get_Internal_Order_Info','No data found');

1404:
1405: EXCEPTION
1406: WHEN NO_DATA_FOUND THEN
1407:
1408: wf_core.context ('PORCPTWF','Get_Internal_Order_Info','No data found');
1409:
1410: WHEN OTHERS THEN
1411:
1412: wf_core.context ('PORCPTWF','Get_Internal_Order_Info','SQL error ' || sqlcode);

Line 1412: wf_core.context ('PORCPTWF','Get_Internal_Order_Info','SQL error ' || sqlcode);

1408: wf_core.context ('PORCPTWF','Get_Internal_Order_Info','No data found');
1409:
1410: WHEN OTHERS THEN
1411:
1412: wf_core.context ('PORCPTWF','Get_Internal_Order_Info','SQL error ' || sqlcode);
1413:
1414: RAISE;
1415:
1416:

Line 1499: wf_core.context ('PORCPTWF','Get_Rcv_Order_URL','No data found');

1495:
1496:
1497: EXCEPTION
1498: WHEN NO_DATA_FOUND THEN
1499: wf_core.context ('PORCPTWF','Get_Rcv_Order_URL','No data found');
1500:
1501: WHEN OTHERS THEN
1502: wf_core.context ('PORCPTWF','Get_Rcv_Order_URL','SQL error ' || sqlcode);
1503:

Line 1502: wf_core.context ('PORCPTWF','Get_Rcv_Order_URL','SQL error ' || sqlcode);

1498: WHEN NO_DATA_FOUND THEN
1499: wf_core.context ('PORCPTWF','Get_Rcv_Order_URL','No data found');
1500:
1501: WHEN OTHERS THEN
1502: wf_core.context ('PORCPTWF','Get_Rcv_Order_URL','SQL error ' || sqlcode);
1503:
1504: RAISE;
1505:
1506:

Line 1582: wf_core.context ('PORCPTWF','Get_Rcv_Int_Order_URL','No data found');

1578:
1579:
1580: EXCEPTION
1581: WHEN NO_DATA_FOUND THEN
1582: wf_core.context ('PORCPTWF','Get_Rcv_Int_Order_URL','No data found');
1583:
1584: WHEN OTHERS THEN
1585: wf_core.context ('PORCPTWF','Get_Rcv_Int_Order_URL','SQL error ' || sqlcode);
1586:

Line 1585: wf_core.context ('PORCPTWF','Get_Rcv_Int_Order_URL','SQL error ' || sqlcode);

1581: WHEN NO_DATA_FOUND THEN
1582: wf_core.context ('PORCPTWF','Get_Rcv_Int_Order_URL','No data found');
1583:
1584: WHEN OTHERS THEN
1585: wf_core.context ('PORCPTWF','Get_Rcv_Int_Order_URL','SQL error ' || sqlcode);
1586:
1587: RAISE;
1588:
1589:

Line 2068: wf_core.context ('PORCPTWF','Process_Rcv_Trans','No data found');

2064:
2065:
2066: EXCEPTION
2067: WHEN NO_DATA_FOUND THEN
2068: wf_core.context ('PORCPTWF','Process_Rcv_Trans','No data found');
2069:
2070: WHEN OTHERS THEN
2071: wf_core.context ('PORCPTWF','Process_Rcv_Trans','SQL error ' || sqlcode);
2072:

Line 2071: wf_core.context ('PORCPTWF','Process_Rcv_Trans','SQL error ' || sqlcode);

2067: WHEN NO_DATA_FOUND THEN
2068: wf_core.context ('PORCPTWF','Process_Rcv_Trans','No data found');
2069:
2070: WHEN OTHERS THEN
2071: wf_core.context ('PORCPTWF','Process_Rcv_Trans','SQL error ' || sqlcode);
2072:
2073: RAISE;
2074:
2075:

Line 2149: wf_core.context ('PORCPTWF','Get_Requester_Manager','SQL error ' || sqlcode);

2145:
2146: WHEN OTHERS THEN
2147:
2148: -- htp.p (SQLERRM);
2149: wf_core.context ('PORCPTWF','Get_Requester_Manager','SQL error ' || sqlcode);
2150:
2151: RAISE;
2152:
2153:

Line 2242: wf_core.context ('PORCPTWF','po_revised','SQL error ' || sqlcode);

2238: exception
2239: when no_data_found then
2240: return TRUE;
2241: when others then
2242: wf_core.context ('PORCPTWF','po_revised','SQL error ' || sqlcode);
2243: raise;
2244:
2245: end po_revised;
2246:

Line 2378: wf_core.context ('PORCPTWF','purge_Orders','SQL error ' || sqlcode);

2374: END IF;
2375:
2376: EXCEPTION
2377: when others then
2378: wf_core.context ('PORCPTWF','purge_Orders','SQL error ' || sqlcode);
2379: IF (g_po_wf_debug = 'Y') THEN
2380: po_wf_debug_pkg.insert_debug(x_wf_itemtype,x_wf_itemkey,'purge_orders SQL error ' || sqlcode || ' error message: ' || substr(sqlerrm,1,512));
2381: END IF;
2382: END;

Line 2400: wf_core.context ('PORCPTWF','purge_orders','No data found');

2396: CLOSE porcpt_c;
2397:
2398: EXCEPTION
2399: WHEN NO_DATA_FOUND THEN
2400: wf_core.context ('PORCPTWF','purge_orders','No data found');
2401: WHEN OTHERS THEN
2402: wf_core.context ('PORCPTWF','purge_Orders','SQL error ' || sqlcode);
2403: RAISE;
2404:

Line 2402: wf_core.context ('PORCPTWF','purge_Orders','SQL error ' || sqlcode);

2398: EXCEPTION
2399: WHEN NO_DATA_FOUND THEN
2400: wf_core.context ('PORCPTWF','purge_orders','No data found');
2401: WHEN OTHERS THEN
2402: wf_core.context ('PORCPTWF','purge_Orders','SQL error ' || sqlcode);
2403: RAISE;
2404:
2405:
2406: END purge_Orders;

Line 2543: WF_CORE.context('PORCPTWF' , 'DOES_ITEM_EXIST', 'ERROR IN DOES_ITEM_EXIST');

2539:
2540: EXCEPTION
2541:
2542: WHEN OTHERS THEN
2543: WF_CORE.context('PORCPTWF' , 'DOES_ITEM_EXIST', 'ERROR IN DOES_ITEM_EXIST');
2544: RAISE;
2545: END does_item_exist;
2546:
2547:

Line 2636: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','No data found');

2632:
2633:
2634: EXCEPTION
2635: WHEN NO_DATA_FOUND THEN
2636: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','No data found');
2637:
2638: WHEN OTHERS THEN
2639: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','SQL error ' || sqlcode);
2640:

Line 2639: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','SQL error ' || sqlcode);

2635: WHEN NO_DATA_FOUND THEN
2636: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','No data found');
2637:
2638: WHEN OTHERS THEN
2639: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','SQL error ' || sqlcode);
2640:
2641: RAISE;
2642:
2643:

Line 3038: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','No data found');

3034:
3035:
3036: EXCEPTION
3037: WHEN NO_DATA_FOUND THEN
3038: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','No data found');
3039:
3040: WHEN OTHERS THEN
3041: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','SQL error ' || sqlcode);
3042:

Line 3041: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','SQL error ' || sqlcode);

3037: WHEN NO_DATA_FOUND THEN
3038: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','No data found');
3039:
3040: WHEN OTHERS THEN
3041: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','SQL error ' || sqlcode);
3042:
3043: RAISE;
3044:
3045:

Line 3530: wf_core.context ('PORCPTWF','GET_PO_RCV_NOTIF','SQL error ' || sqlcode);

3526:
3527: document := l_document;
3528: EXCEPTION
3529: WHEN OTHERS THEN
3530: wf_core.context ('PORCPTWF','GET_PO_RCV_NOTIF','SQL error ' || sqlcode);
3531:
3532: END;
3533:
3534: