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.PORCPTWF dependencies on PORCPTWF

Line 1: PACKAGE BODY PORCPTWF AS

1: PACKAGE BODY PORCPTWF AS
2: /* $Header: PORCPWFB.pls 120.17.12000000.3 2007/10/22 04:29:07 pilamuru ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

Line 511: PORCPTWF.Start_Rcpt_Process(x_po_header_id,

507: where po_header_id = x_po_header_ID
508: and wf_item_key like x_po_header_ID||';'||x_requester_id||';%';
509:
510: --
511: PORCPTWF.Start_Rcpt_Process(x_po_header_id,
512: x_requester_id,
513: x_exp_receipt_date,
514: x_wf_itemkey,
515: x_revision_num,

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 863: PORCPTWF.Start_Rcpt_Process(x_header_id,

859: -- for every unique workflow Item key.
860:
861: -- ash_debug.debug('select order : Just before Start_Rcpt_Process','2');
862:
863: PORCPTWF.Start_Rcpt_Process(x_header_id,
864: x_requester_id,
865: x_exp_receipt_date,
866: x_wf_itemkey,
867: x_revision_num,

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 2820: PORCPTWF.initialize(x_requester_username,x_org_id);

2816: x_requester_username := wf_engine.GetItemAttrText ( itemtype => itemtype,
2817: itemkey => itemkey,
2818: aname => 'REQUESTER_USERNAME');
2819:
2820: PORCPTWF.initialize(x_requester_username,x_org_id);
2821:
2822: /** rewrite after initialize **/
2823: x_allow_inv_dest_receipts := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2824:

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:

Line 3779: PORCPTWF.initialize(x_requester_username,x_org_id);

3775: x_requester_username := wf_engine.GetItemAttrText ( itemtype => itemtype,
3776: itemkey => itemkey,
3777: aname => 'REQUESTER_USERNAME');
3778:
3779: PORCPTWF.initialize(x_requester_username,x_org_id);
3780:
3781: /** rewrite after initialize **/
3782: x_requester_id := wf_engine.GetItemAttrNumber(
3783: itemtype => itemtype,

Line 3984: END PORCPTWF;

3980: end if;
3981:
3982: END Does_invoice_match_exist;
3983:
3984: END PORCPTWF;