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_AUTOCREATE_DOC dependencies on PO_AUTOCREATE_DOC

Line 1: PACKAGE BODY PO_AUTOCREATE_DOC AS

1: PACKAGE BODY PO_AUTOCREATE_DOC AS
2: /* $Header: POXWATCB.pls 120.26 2008/02/19 03:49:27 adevadul 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 185: wf_core.context('po_autocreate_doc','start_wf_process',x_progress);

181: END IF;
182:
183: exception
184: when others then
185: wf_core.context('po_autocreate_doc','start_wf_process',x_progress);
186: raise;
187: end start_wf_process;
188:
189:

Line 237: wf_core.context('po_autocreate_doc','should_req_be_autocreated',x_progress);

233: end if;
234:
235: exception
236: when others then
237: wf_core.context('po_autocreate_doc','should_req_be_autocreated',x_progress);
238: raise;
239: end should_req_be_autocreated;
240:
241:

Line 469: po_autocreate_doc.start_wf_line_process (x_ItemType,

465: IF (g_po_wf_debug = 'Y') THEN
466: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
467: END IF;
468:
469: po_autocreate_doc.start_wf_line_process (x_ItemType,
470: x_ItemKey,
471: x_workflow_process,
472: x_group_id,
473: x_req_header_id,

Line 557: po_autocreate_doc.start_wf_line_process (x_ItemType,

553: IF (g_po_wf_debug = 'Y') THEN
554: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
555: END IF;
556:
557: po_autocreate_doc.start_wf_line_process (x_ItemType,
558: x_ItemKey,
559: x_workflow_process,
560: x_group_id,
561: x_req_header_id,

Line 585: wf_core.context('po_autocreate_doc','launch_req_line_processing',x_progress);

581: close c1;
582: else
583: CLOSE C_ConsumeReqLines;
584: end if;
585: wf_core.context('po_autocreate_doc','launch_req_line_processing',x_progress);
586: raise;
587: end launch_req_line_processing;
588:
589: /***************************************************************************

Line 952: wf_core.context('po_autocreate_doc','get_req_info',x_progress);

948: END IF;
949:
950: exception
951: when others then
952: wf_core.context('po_autocreate_doc','get_req_info',x_progress);
953: raise;
954: end get_req_info;
955:
956:

Line 1029: wf_core.context('po_autocreate_doc','rfq_required_check',x_progress);

1025:
1026:
1027: exception
1028: when others then
1029: wf_core.context('po_autocreate_doc','rfq_required_check',x_progress);
1030: raise;
1031: end rfq_required_check;
1032:
1033:

Line 1291: wf_core.context('po_autocreate_doc','get_supp_info_for_acrt',x_progress);

1287: END IF;
1288:
1289: exception
1290: when others then
1291: wf_core.context('po_autocreate_doc','get_supp_info_for_acrt',x_progress);
1292: raise;
1293: end get_supp_info_for_acrt;
1294:
1295:

Line 1389: wf_core.context('po_autocreate_doc','is_source_doc_info_ok',x_progress);

1385: end if;
1386:
1387: exception
1388: when others then
1389: wf_core.context('po_autocreate_doc','is_source_doc_info_ok',x_progress);
1390: raise;
1391: end is_source_doc_info_ok;
1392:
1393: /***************************************************************************

Line 1670: wf_core.context('po_autocreate_doc','does_contract_exist',x_progress);

1666: CLOSE c_contract;
1667: END IF;
1668: --
1669:
1670: wf_core.context('po_autocreate_doc','does_contract_exist',x_progress);
1671: raise;
1672:
1673: end does_contract_exist;
1674:

Line 1723: wf_core.context('po_autocreate_doc','is_req_pcard_line',x_progress);

1719: end if;
1720:
1721: exception
1722: when others then
1723: wf_core.context('po_autocreate_doc','is_req_pcard_line',x_progress);
1724: raise;
1725: end is_req_pcard_line;
1726:
1727: /***************************************************************************

Line 1782: wf_core.context('po_autocreate_doc','get_buyer_from_req_line',x_progress);

1778: end if;
1779:
1780: exception
1781: when others then
1782: wf_core.context('po_autocreate_doc','get_buyer_from_req_line',x_progress);
1783: raise;
1784: end get_buyer_from_req_line;
1785:
1786:

Line 1886: wf_core.context('po_autocreate_doc','get_buyer_from_item',x_progress);

1882: end if;
1883:
1884: exception
1885: when others then
1886: wf_core.context('po_autocreate_doc','get_buyer_from_item',x_progress);
1887: raise;
1888: end get_buyer_from_item;
1889:
1890:

Line 2041: wf_core.context('po_autocreate_doc','get_buyer_from_category',x_progress);

2037:
2038: exception
2039:
2040: when others then
2041: wf_core.context('po_autocreate_doc','get_buyer_from_category',x_progress);
2042: raise;
2043:
2044: end get_buyer_from_category;
2045:

Line 2141: wf_core.context('po_autocreate_doc','get_buyer_from_source_doc',x_progress);

2137: end if;
2138:
2139: exception
2140: when others then
2141: wf_core.context('po_autocreate_doc','get_buyer_from_source_doc',x_progress);
2142: raise;
2143: end get_buyer_from_source_doc;
2144:
2145: /***************************************************************************

Line 2229: wf_core.context('po_autocreate_doc','get_buyer_from_contract',x_progress);

2225:
2226: exception
2227:
2228: when others then
2229: wf_core.context('po_autocreate_doc','get_buyer_from_contract',x_progress);
2230: raise;
2231:
2232: end get_buyer_from_contract;
2233:

Line 2314: wf_core.context('po_autocreate_doc','get_source_doc_type',x_progress);

2310: end if;
2311:
2312: exception
2313: when others then
2314: wf_core.context('po_autocreate_doc','get_source_doc_type',x_progress);
2315: raise;
2316: end get_source_doc_type;
2317:
2318: /***************************************************************************

Line 2363: wf_core.context('po_autocreate_doc','one_time_item_check',x_progress);

2359: end if;
2360:
2361: exception
2362: when others then
2363: wf_core.context('po_autocreate_doc','one_time_item_check',x_progress);
2364: raise;
2365: end one_time_item_check;
2366:
2367:

Line 2532: wf_core.context('po_autocreate_doc','get_rel_gen_method',x_progress);

2528: --
2529:
2530: exception
2531: when others then
2532: wf_core.context('po_autocreate_doc','get_rel_gen_method',x_progress);
2533: raise;
2534: end get_rel_gen_method;
2535:
2536:

Line 2583: wf_core.context('po_autocreate_doc','cont_wf_autocreate_rel_gen',x_progress);

2579: end if;
2580:
2581: exception
2582: when others then
2583: wf_core.context('po_autocreate_doc','cont_wf_autocreate_rel_gen',x_progress);
2584: raise;
2585: end cont_wf_autocreate_rel_gen;
2586:
2587:

Line 2805: wf_core.context('po_autocreate_doc','insert_cand_req_lines_into_tbl',x_progress);

2801: END IF;
2802:
2803: exception
2804: when others then
2805: wf_core.context('po_autocreate_doc','insert_cand_req_lines_into_tbl',x_progress);
2806: raise;
2807: end insert_cand_req_lines_into_tbl;
2808:
2809:

Line 3476: if(po_autocreate_doc.insert_into_headers_interface

3472: end if;
3473:
3474: --
3475:
3476: if(po_autocreate_doc.insert_into_headers_interface
3477: (itemtype,
3478: itemkey,
3479: c2_group_id,
3480: c2_suggested_vendor_id,

Line 3497: po_autocreate_doc.insert_into_lines_interface (itemtype,

3493: end if;
3494:
3495:
3496:
3497: po_autocreate_doc.insert_into_lines_interface (itemtype,
3498: itemkey,
3499: x_interface_header_id,
3500: c2_req_line_id,
3501: c2_source_doc_line,

Line 3571: po_autocreate_doc.insert_into_lines_interface (itemtype,

3567: * as a previous one, so only insert a new line into the
3568: * po_lines_interface table.
3569: */
3570:
3571: po_autocreate_doc.insert_into_lines_interface (itemtype,
3572: itemkey,
3573: x_interface_header_id,
3574: c2_req_line_id,
3575: c2_source_doc_line,

Line 3692: wf_core.context('po_autocreate_doc','group_req_lines',x_progress);

3688: exception
3689: when others then
3690: close c1;
3691: close c2;
3692: wf_core.context('po_autocreate_doc','group_req_lines',x_progress);
3693: raise;
3694: end group_req_lines;
3695:
3696:

Line 4496: --is passed into po_autocreate_doc.start_wf_create_apprv_process.

4492:
4493: --
4494: --For every iteration of the for-loop, need to set purchasing_org_id for
4495: --the PO document to be created. The purchasing_org_id retrieved here
4496: --is passed into po_autocreate_doc.start_wf_create_apprv_process.
4497:
4498: x_progress:= '5: launch_doc_creation_approval: before set_purchasing_org_id: ' ||
4499: ' x_org_id (from workflow)= '|| to_char(x_org_id) ||
4500: ' l_vendor_site_id (from interface table)='||to_char(l_vendor_site_id);

Line 4550: po_autocreate_doc.start_wf_create_apprv_process (x_ItemType,

4546: IF (g_po_wf_debug = 'Y') THEN
4547: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4548: END IF;
4549:
4550: po_autocreate_doc.start_wf_create_apprv_process (x_ItemType,
4551: x_ItemKey,
4552: x_workflow_process,
4553: x_interface_header_id,
4554: x_doc_type_to_create,

Line 4575: wf_core.context('po_autocreate_doc.launch_doc_creation_approval','launch_doc_creation_approval',

4571: END IF;
4572:
4573: exception
4574: when others then
4575: wf_core.context('po_autocreate_doc.launch_doc_creation_approval','launch_doc_creation_approval',
4576: x_progress);
4577: raise;
4578: end launch_doc_creation_approval;
4579:

Line 4810: po_autocreate_doc.setup_notification_data (itemtype, itemkey);

4806: * in sending a notification to the buyer that the doc has been
4807: * created successfully.
4808: */
4809:
4810: po_autocreate_doc.setup_notification_data (itemtype, itemkey);
4811:
4812: resultout := wf_engine.eng_completed || ':' || 'CREATE_OK';
4813:
4814: x_progress:= '30: create_doc: result = CREATE_OK';

Line 4831: wf_core.context('po_autocreate_doc','create_doc',x_progress);

4827: end if;
4828:
4829: exception
4830: when others then
4831: wf_core.context('po_autocreate_doc','create_doc',x_progress);
4832: raise;
4833: end create_doc;
4834:
4835:

Line 5141: wf_core.context('po_autocreate_doc','should_doc_be_approved',x_progress);

5137: end if;
5138:
5139: exception
5140: when others then
5141: wf_core.context('po_autocreate_doc','should_doc_be_approved',x_progress);
5142: raise;
5143: end should_doc_be_approved;
5144:
5145:

Line 5475: wf_core.context('po_autocreate_doc','launch_po_approval',x_progress);

5471: --
5472:
5473: exception
5474: when others then
5475: wf_core.context('po_autocreate_doc','launch_po_approval',x_progress);
5476: raise;
5477: end launch_po_approval;
5478:
5479:

Line 5524: wf_core.context('po_autocreate_doc','purge_rows_from_temp_table',x_progress);

5520:
5521:
5522: exception
5523: when others then
5524: wf_core.context('po_autocreate_doc','purge_rows_from_temp_table',x_progress);
5525: raise;
5526: end purge_rows_from_temp_table;
5527:
5528: /***************************************************************************

Line 5584: wf_core.context('po_autocreate_doc','is_this_emergency_req',x_progress);

5580: END IF;
5581:
5582: exception
5583: when others then
5584: wf_core.context('po_autocreate_doc','is_this_emergency_req',x_progress);
5585: raise;
5586: end is_this_emergency_req;
5587:
5588: /***************************************************************************

Line 5787: if(po_autocreate_doc.insert_into_headers_interface

5783: * information.
5784: */
5785: if (x_first_time_for_this_comb = 'TRUE') then
5786:
5787: if(po_autocreate_doc.insert_into_headers_interface
5788: (itemtype,
5789: itemkey,
5790: c_group_id,
5791: c_suggested_vendor_id,

Line 5809: po_autocreate_doc.insert_into_lines_interface (itemtype,

5805:
5806:
5807:
5808:
5809: po_autocreate_doc.insert_into_lines_interface (itemtype,
5810: itemkey,
5811: x_interface_header_id,
5812: c_req_line_id,
5813: null,

Line 5841: po_autocreate_doc.insert_into_lines_interface (itemtype,

5837: * as a previous one, so only insert a new line into the
5838: * po_lines_interface table.
5839: */
5840:
5841: po_autocreate_doc.insert_into_lines_interface (itemtype,
5842: itemkey,
5843: x_interface_header_id,
5844: c_req_line_id,
5845: null,

Line 5901: wf_core.context('po_autocreate_doc','put_on_one_po',x_progress);

5897:
5898: exception
5899: when others then
5900: close c1;
5901: wf_core.context('po_autocreate_doc','put_on_one_po',x_progress);
5902: raise;
5903: end put_on_one_po;
5904:
5905: /***************************************************************************

Line 5956: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 001';

5952: -- bug 5657496 variable addition
5953:
5954: begin
5955:
5956: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 001';
5957:
5958: /* Bug# 2681512: kagarwal
5959: ** We will get the document type display value from
5960: ** po document types for correct translation.

Line 6009: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 010';

6005: and ty.document_subtype = hd.TYPE_LOOKUP_CODE;
6006:
6007: -- Get Req Approval process.
6008:
6009: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 010';
6010:
6011: /* Bug# 2681512: kagarwal
6012: ** Getting the wf_item_type in the SQL above
6013:

Line 6029: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 020';

6025: end;
6026: */
6027:
6028: IF ItemType IS NULL THEN
6029: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 020';
6030: return;
6031: END IF;
6032:
6033: -- Build the links.

Line 6065: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 040';

6061: and pr.effective_end_date;
6062:
6063: -- Create wf process.
6064:
6065: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 040';
6066:
6067: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;
6068: ItemKey := to_char(p_req_header_id) || '-' || l_seq;
6069:

Line 6074: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 050 - '||

6070: wf_engine.CreateProcess( ItemType => ItemType,
6071: ItemKey => ItemKey,
6072: process => 'NOTIFY_RETURN_REQ');
6073:
6074: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 050 - '||
6075: 'itemtype: ' || ItemType || 'itemkey: ' || ItemKey;
6076: IF (g_po_wf_debug = 'Y') THEN
6077: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6078: END IF;

Line 6193: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 055';

6189: avalue => l_responsibility_id);
6190: -- bug 5657496
6191:
6192: -- Start Process
6193: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 055';
6194: IF (g_po_wf_debug = 'Y') THEN
6195: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6196: END IF;
6197:

Line 6257: wf_core.context('po_autocreate_doc','get_document_num',x_progress);

6253: return x_document_num;
6254:
6255: exception
6256: when others then
6257: wf_core.context('po_autocreate_doc','get_document_num',x_progress);
6258: raise;
6259:
6260: end get_document_num;
6261:

Line 6303: wf_core.context('po_autocreate_doc','is_contract_required_on_req',x_progress);

6299:
6300: exception
6301:
6302: when others then
6303: wf_core.context('po_autocreate_doc','is_contract_required_on_req',x_progress);
6304: raise;
6305:
6306: end is_contract_required_on_req;
6307:

Line 6346: wf_core.context('po_autocreate_doc','should_contract_be_used',x_progress);

6342:
6343: exception
6344:
6345: when others then
6346: wf_core.context('po_autocreate_doc','should_contract_be_used',x_progress);
6347: raise;
6348:
6349: end should_contract_be_used;
6350:

Line 6393: wf_core.context('po_autocreate_doc','non_catalog_item_check',x_progress);

6389:
6390:
6391: exception
6392: when others then
6393: wf_core.context('po_autocreate_doc','non_catalog_item_check',x_progress);
6394: raise;
6395: end non_catalog_item_check;
6396:
6397:

Line 6562: wf_core.context('po_autocreate_doc','is_contract_doc_info_ok',x_progress);

6558: end if;
6559:
6560: exception
6561: when others then
6562: wf_core.context('po_autocreate_doc','is_contract_doc_info_ok',x_progress);
6563: raise;
6564:
6565: end is_contract_doc_info_ok;
6566:

Line 6611: wf_core.context('po_autocreate_doc','should_nctlog_src_frm_cntrct',x_progress);

6607:
6608: exception
6609:
6610: when others then
6611: wf_core.context('po_autocreate_doc','should_nctlog_src_frm_cntrct',x_progress);
6612: raise;
6613:
6614: end should_nctlog_src_frm_contract;
6615:

Line 6726: wf_core.context('po_autocreate_doc','is_src_doc_ga_other_ou',x_progress);

6722: END IF;
6723:
6724: exception
6725: when others then
6726: wf_core.context('po_autocreate_doc','is_src_doc_ga_other_ou',x_progress);
6727: raise;
6728: end is_src_doc_ga_frm_other_ou;
6729:
6730:

Line 6791: WF_CORE.context('po_autocreate_doc','validate_buyer',l_progress);

6787: WHEN NO_DATA_FOUND THEN
6788: x_result := FND_API.G_FALSE;
6789: WHEN OTHERS THEN
6790: x_result := FND_API.G_FALSE;
6791: WF_CORE.context('po_autocreate_doc','validate_buyer',l_progress);
6792: raise;
6793: END validate_buyer;
6794:
6795: --

Line 6923: wf_core.CONTEXT ('po_autocreate_doc', 'buyer_on_src_doc_ok',

6919: END IF;
6920:
6921: EXCEPTION
6922: WHEN OTHERS THEN
6923: wf_core.CONTEXT ('po_autocreate_doc', 'buyer_on_src_doc_ok',
6924: x_progress);
6925: RAISE;
6926: END buyer_on_src_doc_ok;
6927:

Line 7040: wf_core.CONTEXT('po_autocreate_doc', 'buyer_on_contract_ok', x_progress);

7036: END IF;
7037:
7038: EXCEPTION
7039: WHEN OTHERS THEN
7040: wf_core.CONTEXT('po_autocreate_doc', 'buyer_on_contract_ok', x_progress);
7041: RAISE;
7042: END buyer_on_contract_ok;
7043:
7044:

Line 7119: wf_core.CONTEXT ('po_autocreate_doc', 'purchasing_ou_check', x_progress);

7115:
7116: EXCEPTION
7117:
7118: WHEN OTHERS THEN
7119: wf_core.CONTEXT ('po_autocreate_doc', 'purchasing_ou_check', x_progress);
7120: RAISE;
7121:
7122: END purchasing_ou_check;
7123:

Line 7291: wf_core.CONTEXT ('po_autocreate_doc',

7287: END IF;
7288: EXCEPTION
7289: WHEN OTHERS
7290: THEN
7291: wf_core.CONTEXT ('po_autocreate_doc',
7292: 'ok_to_create_in_diff_ou',
7293: x_progress
7294: );
7295: RAISE;

Line 7375: wf_core.context('po_autocreate_doc', 'set_purchasing_org_id', l_progress);

7371:
7372: EXCEPTION
7373:
7374: WHEN OTHERS THEN
7375: wf_core.context('po_autocreate_doc', 'set_purchasing_org_id', l_progress);
7376: RAISE;
7377:
7378: END set_purchasing_org_id;
7379:

Line 7470: wf_core.context('po_autocreate_doc',

7466: END IF;
7467:
7468: EXCEPTION
7469: WHEN OTHERS THEN
7470: wf_core.context('po_autocreate_doc',
7471: 'is_expense_line',
7472: l_progress);
7473: RAISE;
7474: END is_expense_line;

Line 7534: wf_core.context('po_autocreate_doc',

7530: WHERE labor_req_line_id = l_req_line_id);
7531:
7532: EXCEPTION
7533: WHEN OTHERS THEN
7534: wf_core.context('po_autocreate_doc',
7535: 'purge_expense_lines',
7536: l_progress);
7537: RAISE;
7538: END purge_expense_lines;

Line 7580: wf_core.context('po_autocreate_doc','temp_labor_item_check',x_progress);

7576:
7577:
7578: exception
7579: when others then
7580: wf_core.context('po_autocreate_doc','temp_labor_item_check',x_progress);
7581: raise;
7582: end temp_labor_item_check;
7583:
7584: /***************************************************************************

Line 7625: wf_core.context('po_autocreate_doc','should_tmplbr_src_frm_cntract',x_progress);

7621:
7622: exception
7623:
7624: when others then
7625: wf_core.context('po_autocreate_doc','should_tmplbr_src_frm_cntract',x_progress);
7626: raise;
7627:
7628: end should_tmplbr_src_frm_contract;
7629:

Line 7632: END PO_AUTOCREATE_DOC;

7628: end should_tmplbr_src_frm_contract;
7629:
7630:
7631:
7632: END PO_AUTOCREATE_DOC;