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.37.12020000.13 2013/04/09 07:05:54 ssindhe 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 201: wf_core.context('po_autocreate_doc','start_wf_process',x_progress);

197: END IF;
198:
199: exception
200: when others then
201: wf_core.context('po_autocreate_doc','start_wf_process',x_progress);
202: raise;
203: end start_wf_process;
204:
205:

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

249: end if;
250:
251: exception
252: when others then
253: wf_core.context('po_autocreate_doc','should_req_be_autocreated',x_progress);
254: raise;
255: end should_req_be_autocreated;
256:
257:

Line 549: po_autocreate_doc.start_wf_line_process (x_ItemType,

545: IF (g_po_wf_debug = 'Y') THEN
546: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
547: END IF;
548:
549: po_autocreate_doc.start_wf_line_process (x_ItemType,
550: x_ItemKey,
551: x_workflow_process,
552: x_group_id,
553: x_req_header_id,

Line 604: po_autocreate_doc.start_wf_line_process (x_ItemType,

600: IF (g_po_wf_debug = 'Y') THEN
601: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
602: END IF;
603:
604: po_autocreate_doc.start_wf_line_process (x_ItemType,
605: x_ItemKey,
606: x_workflow_process,
607: x_group_id,
608: x_req_header_id,

Line 658: po_autocreate_doc.start_wf_line_process (x_ItemType,

654: IF (g_po_wf_debug = 'Y') THEN
655: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
656: END IF;
657:
658: po_autocreate_doc.start_wf_line_process (x_ItemType,
659: x_ItemKey,
660: x_workflow_process,
661: x_group_id,
662: x_req_header_id,

Line 746: po_autocreate_doc.start_wf_line_process (x_ItemType,

742: IF (g_po_wf_debug = 'Y') THEN
743: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
744: END IF;
745:
746: po_autocreate_doc.start_wf_line_process (x_ItemType,
747: x_ItemKey,
748: x_workflow_process,
749: x_group_id,
750: x_req_header_id,

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

770: close c1;
771: else
772: CLOSE C_ConsumeReqLines;
773: end if;
774: wf_core.context('po_autocreate_doc','launch_req_line_processing',x_progress);
775: raise;
776: end launch_req_line_processing;
777:
778: /***************************************************************************

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

1149: END IF;
1150:
1151: exception
1152: when others then
1153: wf_core.context('po_autocreate_doc','get_req_info',x_progress);
1154: raise;
1155: end get_req_info;
1156:
1157:

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

1226:
1227:
1228: exception
1229: when others then
1230: wf_core.context('po_autocreate_doc','rfq_required_check',x_progress);
1231: raise;
1232: end rfq_required_check;
1233:
1234:

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

1488: END IF;
1489:
1490: exception
1491: when others then
1492: wf_core.context('po_autocreate_doc','get_supp_info_for_acrt',x_progress);
1493: raise;
1494: end get_supp_info_for_acrt;
1495:
1496:

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

1602: end if;
1603:
1604: exception
1605: when others then
1606: wf_core.context('po_autocreate_doc','is_source_doc_info_ok',x_progress);
1607: raise;
1608: end is_source_doc_info_ok;
1609:
1610: /***************************************************************************

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

1883: CLOSE c_contract;
1884: END IF;
1885: --
1886:
1887: wf_core.context('po_autocreate_doc','does_contract_exist',x_progress);
1888: raise;
1889:
1890: end does_contract_exist;
1891:

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

1936: end if;
1937:
1938: exception
1939: when others then
1940: wf_core.context('po_autocreate_doc','is_req_pcard_line',x_progress);
1941: raise;
1942: end is_req_pcard_line;
1943:
1944: /***************************************************************************

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

1995: end if;
1996:
1997: exception
1998: when others then
1999: wf_core.context('po_autocreate_doc','get_buyer_from_req_line',x_progress);
2000: raise;
2001: end get_buyer_from_req_line;
2002:
2003:

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

2099: end if;
2100:
2101: exception
2102: when others then
2103: wf_core.context('po_autocreate_doc','get_buyer_from_item',x_progress);
2104: raise;
2105: end get_buyer_from_item;
2106:
2107:

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

2256:
2257: exception
2258:
2259: when others then
2260: wf_core.context('po_autocreate_doc','get_buyer_from_category',x_progress);
2261: raise;
2262:
2263: end get_buyer_from_category;
2264:

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

2356: end if;
2357:
2358: exception
2359: when others then
2360: wf_core.context('po_autocreate_doc','get_buyer_from_source_doc',x_progress);
2361: raise;
2362: end get_buyer_from_source_doc;
2363:
2364: /***************************************************************************

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

2444:
2445: exception
2446:
2447: when others then
2448: wf_core.context('po_autocreate_doc','get_buyer_from_contract',x_progress);
2449: raise;
2450:
2451: end get_buyer_from_contract;
2452:

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

2529: end if;
2530:
2531: exception
2532: when others then
2533: wf_core.context('po_autocreate_doc','get_source_doc_type',x_progress);
2534: raise;
2535: end get_source_doc_type;
2536:
2537: /***************************************************************************

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

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

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

2771: --
2772:
2773: exception
2774: when others then
2775: wf_core.context('po_autocreate_doc','get_rel_gen_method',x_progress);
2776: raise;
2777: end get_rel_gen_method;
2778:
2779:

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

2822: end if;
2823:
2824: exception
2825: when others then
2826: wf_core.context('po_autocreate_doc','cont_wf_autocreate_rel_gen',x_progress);
2827: raise;
2828: end cont_wf_autocreate_rel_gen;
2829:
2830:

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

3044: END IF;
3045:
3046: exception
3047: when others then
3048: wf_core.context('po_autocreate_doc','insert_cand_req_lines_into_tbl',x_progress);
3049: raise;
3050: end insert_cand_req_lines_into_tbl;
3051:
3052:

Line 3789: if(po_autocreate_doc.insert_into_headers_interface

3785: end if;
3786:
3787: --
3788:
3789: if(po_autocreate_doc.insert_into_headers_interface
3790: (itemtype,
3791: itemkey,
3792: c2_group_id,
3793: c2_suggested_vendor_id,

Line 3810: po_autocreate_doc.insert_into_lines_interface (itemtype,

3806: end if;
3807:
3808:
3809:
3810: po_autocreate_doc.insert_into_lines_interface (itemtype,
3811: itemkey,
3812: x_interface_header_id,
3813: c2_req_line_id,
3814: c2_source_doc_line,

Line 3896: po_autocreate_doc.insert_into_lines_interface (itemtype,

3892: * as a previous one, so only insert a new line into the
3893: * po_lines_interface table.
3894: */
3895:
3896: po_autocreate_doc.insert_into_lines_interface (itemtype,
3897: itemkey,
3898: x_interface_header_id,
3899: c2_req_line_id,
3900: c2_source_doc_line,

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

4013: exception
4014: when others then
4015: close c1;
4016: close c2;
4017: wf_core.context('po_autocreate_doc','group_req_lines',x_progress);
4018: raise;
4019: end group_req_lines;
4020:
4021:

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

4817:
4818: --
4819: --For every iteration of the for-loop, need to set purchasing_org_id for
4820: --the PO document to be created. The purchasing_org_id retrieved here
4821: --is passed into po_autocreate_doc.start_wf_create_apprv_process.
4822:
4823: x_progress:= '5: launch_doc_creation_approval: before set_purchasing_org_id: ' ||
4824: ' x_org_id (from workflow)= '|| to_char(x_org_id) ||
4825: ' l_vendor_site_id (from interface table)='||to_char(l_vendor_site_id);

Line 4875: po_autocreate_doc.start_wf_create_apprv_process (x_ItemType,

4871: IF (g_po_wf_debug = 'Y') THEN
4872: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4873: END IF;
4874:
4875: po_autocreate_doc.start_wf_create_apprv_process (x_ItemType,
4876: x_ItemKey,
4877: x_workflow_process,
4878: x_interface_header_id,
4879: x_doc_type_to_create,

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

4896: END IF;
4897:
4898: exception
4899: when others then
4900: wf_core.context('po_autocreate_doc.launch_doc_creation_approval','launch_doc_creation_approval',
4901: x_progress);
4902: raise;
4903: end launch_doc_creation_approval;
4904:

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

5144: * in sending a notification to the buyer that the doc has been
5145: * created successfully.
5146: */
5147:
5148: po_autocreate_doc.setup_notification_data (itemtype, itemkey);
5149:
5150: resultout := wf_engine.eng_completed || ':' || 'CREATE_OK';
5151:
5152: x_progress:= '30: create_doc: result = CREATE_OK';

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

5165: end if;
5166:
5167: exception
5168: when others then
5169: wf_core.context('po_autocreate_doc','create_doc',x_progress);
5170: raise;
5171: end create_doc;
5172:
5173:

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

5517: end if;
5518:
5519: exception
5520: when others then
5521: wf_core.context('po_autocreate_doc','should_doc_be_approved',x_progress);
5522: raise;
5523: end should_doc_be_approved;
5524:
5525:

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

5852: --
5853:
5854: exception
5855: when others then
5856: wf_core.context('po_autocreate_doc','launch_po_approval',x_progress);
5857: raise;
5858: end launch_po_approval;
5859:
5860:

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

5901:
5902:
5903: exception
5904: when others then
5905: wf_core.context('po_autocreate_doc','purge_rows_from_temp_table',x_progress);
5906: raise;
5907: end purge_rows_from_temp_table;
5908:
5909: /***************************************************************************

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

5961: END IF;
5962:
5963: exception
5964: when others then
5965: wf_core.context('po_autocreate_doc','is_this_emergency_req',x_progress);
5966: raise;
5967: end is_this_emergency_req;
5968:
5969: /***************************************************************************

Line 6200: if(po_autocreate_doc.insert_into_headers_interface

6196: * information.
6197: */
6198: if (x_first_time_for_this_comb = 'TRUE') then
6199:
6200: if(po_autocreate_doc.insert_into_headers_interface
6201: (itemtype,
6202: itemkey,
6203: c_group_id,
6204: c_suggested_vendor_id,

Line 6224: po_autocreate_doc.insert_into_lines_interface (itemtype,

6220:
6221:
6222:
6223:
6224: po_autocreate_doc.insert_into_lines_interface (itemtype,
6225: itemkey,
6226: x_interface_header_id,
6227: c_req_line_id,
6228: --Bug 13496442, replace null values

Line 6257: po_autocreate_doc.insert_into_lines_interface (itemtype,

6253: * as a previous one, so only insert a new line into the
6254: * po_lines_interface table.
6255: */
6256:
6257: po_autocreate_doc.insert_into_lines_interface (itemtype,
6258: itemkey,
6259: x_interface_header_id,
6260: c_req_line_id,
6261: --Bug 13496442, replace null values

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

6315:
6316: exception
6317: when others then
6318: close c1;
6319: wf_core.context('po_autocreate_doc','put_on_one_po',x_progress);
6320: raise;
6321: end put_on_one_po;
6322:
6323: /***************************************************************************

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

6374: --
6375:
6376: begin
6377:
6378: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 001';
6379:
6380: /* Bug# 2681512: kagarwal
6381: ** We will get the document type display value from
6382: ** po document types for correct translation.

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

6432:
6433:
6434: -- Get Req Approval process.
6435:
6436: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 010';
6437:
6438: /* Bug# 2681512: kagarwal
6439: ** Getting the wf_item_type in the SQL above
6440:

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

6452: end;
6453: */
6454:
6455: IF ItemType IS NULL THEN
6456: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 020';
6457: return;
6458: END IF;
6459:
6460: -- Build the links.

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

6488: and pr.effective_end_date;*/
6489:
6490: -- Create wf process.
6491:
6492: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 040';
6493:
6494: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;
6495: ItemKey := to_char(p_req_header_id) || '-' || l_seq;
6496:

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

6497: wf_engine.CreateProcess( ItemType => ItemType,
6498: ItemKey => ItemKey,
6499: process => 'NOTIFY_RETURN_REQ');
6500:
6501: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 050 - '||
6502: 'itemtype: ' || ItemType || 'itemkey: ' || ItemKey;
6503: IF (g_po_wf_debug = 'Y') THEN
6504: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6505: END IF;

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

6625: avalue => l_responsibility_id);
6626: -- bug 5657496
6627:
6628: -- Start Process
6629: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 055';
6630: IF (g_po_wf_debug = 'Y') THEN
6631: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6632: END IF;
6633:

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

6689: return x_document_num;
6690:
6691: exception
6692: when others then
6693: wf_core.context('po_autocreate_doc','get_document_num',x_progress);
6694: raise;
6695:
6696: end get_document_num;
6697:

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

6735:
6736: exception
6737:
6738: when others then
6739: wf_core.context('po_autocreate_doc','is_contract_required_on_req',x_progress);
6740: raise;
6741:
6742: end is_contract_required_on_req;
6743:

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

6778:
6779: exception
6780:
6781: when others then
6782: wf_core.context('po_autocreate_doc','should_contract_be_used',x_progress);
6783: raise;
6784:
6785: end should_contract_be_used;
6786:

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

6825:
6826:
6827: exception
6828: when others then
6829: wf_core.context('po_autocreate_doc','non_catalog_item_check',x_progress);
6830: raise;
6831: end non_catalog_item_check;
6832:
6833:

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

7010: end if;
7011:
7012: exception
7013: when others then
7014: wf_core.context('po_autocreate_doc','is_contract_doc_info_ok',x_progress);
7015: raise;
7016:
7017: end is_contract_doc_info_ok;
7018:

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

7059:
7060: exception
7061:
7062: when others then
7063: wf_core.context('po_autocreate_doc','should_nctlog_src_frm_cntrct',x_progress);
7064: raise;
7065:
7066: end should_nctlog_src_frm_contract;
7067:

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

7174: END IF;
7175:
7176: exception
7177: when others then
7178: wf_core.context('po_autocreate_doc','is_src_doc_ga_other_ou',x_progress);
7179: raise;
7180: end is_src_doc_ga_frm_other_ou;
7181:
7182:

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

7239: WHEN NO_DATA_FOUND THEN
7240: x_result := FND_API.G_FALSE;
7241: WHEN OTHERS THEN
7242: x_result := FND_API.G_FALSE;
7243: WF_CORE.context('po_autocreate_doc','validate_buyer',l_progress);
7244: raise;
7245: END validate_buyer;
7246:
7247: --

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

7371: END IF;
7372:
7373: EXCEPTION
7374: WHEN OTHERS THEN
7375: wf_core.CONTEXT ('po_autocreate_doc', 'buyer_on_src_doc_ok',
7376: x_progress);
7377: RAISE;
7378: END buyer_on_src_doc_ok;
7379:

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

7489: END IF;
7490:
7491: EXCEPTION
7492: WHEN OTHERS THEN
7493: wf_core.CONTEXT('po_autocreate_doc', 'buyer_on_contract_ok', x_progress);
7494: RAISE;
7495: END buyer_on_contract_ok;
7496:
7497:

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

7568:
7569: EXCEPTION
7570:
7571: WHEN OTHERS THEN
7572: wf_core.CONTEXT ('po_autocreate_doc', 'purchasing_ou_check', x_progress);
7573: RAISE;
7574:
7575: END purchasing_ou_check;
7576:

Line 7744: wf_core.CONTEXT ('po_autocreate_doc',

7740: END IF;
7741: EXCEPTION
7742: WHEN OTHERS
7743: THEN
7744: wf_core.CONTEXT ('po_autocreate_doc',
7745: 'ok_to_create_in_diff_ou',
7746: x_progress
7747: );
7748: RAISE;

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

7824:
7825: EXCEPTION
7826:
7827: WHEN OTHERS THEN
7828: wf_core.context('po_autocreate_doc', 'set_purchasing_org_id', l_progress);
7829: RAISE;
7830:
7831: END set_purchasing_org_id;
7832:

Line 7923: wf_core.context('po_autocreate_doc',

7919: END IF;
7920:
7921: EXCEPTION
7922: WHEN OTHERS THEN
7923: wf_core.context('po_autocreate_doc',
7924: 'is_expense_line',
7925: l_progress);
7926: RAISE;
7927: END is_expense_line;

Line 7987: wf_core.context('po_autocreate_doc',

7983: WHERE labor_req_line_id = l_req_line_id);
7984:
7985: EXCEPTION
7986: WHEN OTHERS THEN
7987: wf_core.context('po_autocreate_doc',
7988: 'purge_expense_lines',
7989: l_progress);
7990: RAISE;
7991: END purge_expense_lines;

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

8029:
8030:
8031: exception
8032: when others then
8033: wf_core.context('po_autocreate_doc','temp_labor_item_check',x_progress);
8034: raise;
8035: end temp_labor_item_check;
8036:
8037: /***************************************************************************

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

8074:
8075: exception
8076:
8077: when others then
8078: wf_core.context('po_autocreate_doc','should_tmplbr_src_frm_cntract',x_progress);
8079: raise;
8080:
8081: end should_tmplbr_src_frm_contract;
8082:

Line 8126: END PO_AUTOCREATE_DOC;

8122:
8123:
8124:
8125:
8126: END PO_AUTOCREATE_DOC;