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.22.12020000.4 2013/04/05 03:43:03 jiarsun 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 513: PORCPTWF.Start_Rcpt_Process(x_po_header_id,

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

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

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

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

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

Line 865: PORCPTWF.Start_Rcpt_Process(x_header_id,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2558:
2559: EXCEPTION
2560:
2561: WHEN OTHERS THEN
2562: WF_CORE.context('PORCPTWF' , 'DOES_ITEM_EXIST', 'ERROR IN DOES_ITEM_EXIST');
2563: RAISE;
2564: END does_item_exist;
2565:
2566: PROCEDURE is_expDate_valid(itemtype in varchar2,

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

2677:
2678:
2679: EXCEPTION
2680: WHEN NO_DATA_FOUND THEN
2681: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','No data found');
2682:
2683: WHEN OTHERS THEN
2684: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','SQL error ' || sqlcode);
2685:

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

2680: WHEN NO_DATA_FOUND THEN
2681: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','No data found');
2682:
2683: WHEN OTHERS THEN
2684: wf_core.context ('PORCPTWF','Get_Rcv_Internal_Order_URL','SQL error ' || sqlcode);
2685:
2686: RAISE;
2687:
2688:

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

2861: x_requester_username := wf_engine.GetItemAttrText ( itemtype => itemtype,
2862: itemkey => itemkey,
2863: aname => 'REQUESTER_USERNAME');
2864:
2865: PORCPTWF.initialize(x_requester_username,x_org_id);
2866:
2867: /** rewrite after initialize **/
2868: x_allow_inv_dest_receipts := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2869:

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

3079:
3080:
3081: EXCEPTION
3082: WHEN NO_DATA_FOUND THEN
3083: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','No data found');
3084:
3085: WHEN OTHERS THEN
3086: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','SQL error ' || sqlcode);
3087:

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

3082: WHEN NO_DATA_FOUND THEN
3083: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','No data found');
3084:
3085: WHEN OTHERS THEN
3086: wf_core.context ('PORCPTWF','Process_Rcv_Trans_Int','SQL error ' || sqlcode);
3087:
3088: RAISE;
3089:
3090:

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

3571:
3572: document := l_document;
3573: EXCEPTION
3574: WHEN OTHERS THEN
3575: wf_core.context ('PORCPTWF','GET_PO_RCV_NOTIF','SQL error ' || sqlcode);
3576:
3577: END;
3578:
3579:

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

3835: x_requester_username := wf_engine.GetItemAttrText ( itemtype => itemtype,
3836: itemkey => itemkey,
3837: aname => 'REQUESTER_USERNAME');
3838:
3839: PORCPTWF.initialize(x_requester_username,x_org_id);
3840:
3841: /** rewrite after initialize **/
3842: x_requester_id := wf_engine.GetItemAttrNumber(
3843: itemtype => itemtype,

Line 4068: END PORCPTWF;

4064: END is_complex_po;
4065: -- Bug 15921367
4066:
4067:
4068: END PORCPTWF;