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_PDOI_POSTPROC_PVT dependencies on PO_PDOI_PARAMS

Line 16: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,

12: PROCEDURE process_rejected_records;
13:
14: PROCEDURE post_validate
15: ( p_doc_rec IN doc_row_type,
16: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,
17: x_header_rejected OUT NOCOPY VARCHAR2,
18: x_remove_draft OUT NOCOPY VARCHAR2 -- bug5129752
19: );
20:

Line 24: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,

20:
21:
22: PROCEDURE transfer_document_check
23: ( p_doc_rec IN doc_row_type,
24: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,
25: x_transfer_flag OUT NOCOPY VARCHAR2,
26: x_submit_for_buyer_acc_flag OUT NOCOPY VARCHAR2
27: );
28:

Line 205: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;

201:
202: l_transfer_flag VARCHAR2(1);
203: l_submit_for_buyer_acc_flag VARCHAR2(1);
204:
205: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
206: l_process_code PO_HEADERS_INTERFACE.process_code%TYPE;
207:
208: x_process_code VARCHAR2(1) := ''; -- bug 7277317
209: l_remove_draft VARCHAR2(1); -- bug5129752

Line 277: LIMIT PO_PDOI_PARAMS.g_request.batch_size;

273:
274: FETCH c_doc
275: BULK COLLECT
276: INTO l_docs_tbl
277: LIMIT PO_PDOI_PARAMS.g_request.batch_size;
278:
279: IF (PO_LOG.d_stmt) THEN
280: PO_LOG.stmt(d_module, d_position, 'num of records fetched: '
281: || l_docs_tbl.COUNT);

Line 296: l_doc_info := PO_PDOI_PARAMS.g_docs_info(l_doc_rec.interface_header_id);

292: SAVEPOINT po_pdoi_doc_postproc_sp;
293: d_position := 20;
294:
295: l_doc_rec := l_docs_tbl(i);
296: l_doc_info := PO_PDOI_PARAMS.g_docs_info(l_doc_rec.interface_header_id);
297:
298: IF (PO_PDOI_PARAMS.g_request.calling_module =
299: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
300: -- Copy processed lines info back to g_out structure. These values

Line 298: IF (PO_PDOI_PARAMS.g_request.calling_module =

294:
295: l_doc_rec := l_docs_tbl(i);
296: l_doc_info := PO_PDOI_PARAMS.g_docs_info(l_doc_rec.interface_header_id);
297:
298: IF (PO_PDOI_PARAMS.g_request.calling_module =
299: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
300: -- Copy processed lines info back to g_out structure. These values
301: -- will get returned to the caller of PDOI
302: PO_PDOI_PARAMS.g_out.processed_lines_count :=

Line 302: PO_PDOI_PARAMS.g_out.processed_lines_count :=

298: IF (PO_PDOI_PARAMS.g_request.calling_module =
299: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
300: -- Copy processed lines info back to g_out structure. These values
301: -- will get returned to the caller of PDOI
302: PO_PDOI_PARAMS.g_out.processed_lines_count :=
303: l_doc_info.number_of_processed_lines;
304: PO_PDOI_PARAMS.g_out.rejected_lines_count :=
305: l_doc_info.number_of_errored_lines;
306: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded :=

Line 304: PO_PDOI_PARAMS.g_out.rejected_lines_count :=

300: -- Copy processed lines info back to g_out structure. These values
301: -- will get returned to the caller of PDOI
302: PO_PDOI_PARAMS.g_out.processed_lines_count :=
303: l_doc_info.number_of_processed_lines;
304: PO_PDOI_PARAMS.g_out.rejected_lines_count :=
305: l_doc_info.number_of_errored_lines;
306: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded :=
307: l_doc_info.err_tolerance_exceeded;
308: END IF;

Line 306: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded :=

302: PO_PDOI_PARAMS.g_out.processed_lines_count :=
303: l_doc_info.number_of_processed_lines;
304: PO_PDOI_PARAMS.g_out.rejected_lines_count :=
305: l_doc_info.number_of_errored_lines;
306: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded :=
307: l_doc_info.err_tolerance_exceeded;
308: END IF;
309:
310: IF (PO_LOG.d_stmt) THEN

Line 319: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN

315: END IF;
316:
317: /*PDOI UDA Integration Starts
318: The below code is fired only in case of a clm po*/
319: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN
320: --fetch all uda_intf data & bulk collect
321:
322: open c_uda_intf(l_doc_rec.interface_header_id);
323: loop

Line 416: p_role => PO_PDOI_PARAMS.g_request.role,

412: -- If user is creating a draft without transferring, we need
413: -- to get the functional lock of the document explicitly
414: PO_DRAFTS_PVT.lock_document
415: ( p_po_header_id => l_doc_rec.po_header_id,
416: p_role => PO_PDOI_PARAMS.g_request.role,
417: p_role_user_id => FND_GLOBAL.user_id,
418: p_unlock_current => FND_API.G_FALSE
419: );
420:

Line 456: IF (PO_PDOI_PARAMS.g_request.document_type =

452:
453: -- Call different module for post processing according to document
454: -- type and action
455:
456: IF (PO_PDOI_PARAMS.g_request.document_type =
457: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
458:
459: IF (l_doc_rec.action IN (PO_PDOI_CONSTANTS.g_ACTION_ADD,
460: PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL)) THEN

Line 478: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

474: x_process_code => x_process_code); -- bug 7277317
475:
476: END IF;
477:
478: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
479: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
480:
481: IF (l_doc_rec.action IN (PO_PDOI_CONSTANTS.g_ACTION_ADD,
482: PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL)) THEN

Line 498: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

494: update_quotation(p_doc_rec => l_doc_rec);
495:
496: END IF;
497:
498: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
499: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
500:
501: IF (l_doc_rec.action IN (PO_PDOI_CONSTANTS.g_ACTION_ADD,
502: PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL)) THEN

Line 756: WHERE processing_id = -PO_PDOI_PARAMS.g_processing_id

752: l_action_tbl,
753: l_dft_id_tbl,
754: l_po_header_id_tbl
755: FROM po_headers_interface PHI
756: WHERE processing_id = -PO_PDOI_PARAMS.g_processing_id
757: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num;
758:
759: d_position := 10;
760:

Line 757: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num;

753: l_dft_id_tbl,
754: l_po_header_id_tbl
755: FROM po_headers_interface PHI
756: WHERE processing_id = -PO_PDOI_PARAMS.g_processing_id
757: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num;
758:
759: d_position := 10;
760:
761: FOR i IN 1..l_intf_header_id_tbl.COUNT LOOP

Line 775: p_role => PO_PDOI_PARAMS.g_request.role

771: -- Update action
772:
773: IF (PO_DRAFTS_PVT.is_draft_applicable
774: ( p_po_header_id => l_po_header_id_tbl(i),
775: p_role => PO_PDOI_PARAMS.g_request.role
776: ) = FND_API.G_FALSE ) THEN
777:
778: d_position := 40;
779:

Line 852: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,

848: --End of Comments
849: ------------------------------------------------------------------------
850: PROCEDURE post_validate
851: ( p_doc_rec IN doc_row_type,
852: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,
853: x_header_rejected OUT NOCOPY VARCHAR2,
854: x_remove_draft OUT NOCOPY VARCHAR2 -- bug5129752
855: ) IS
856:

Line 881: IF (PO_PDOI_PARAMS.g_request.document_type =

877: -- 3) Quotation upload through catalog upload (bug5461177)
878:
879: IF ( p_doc_info.has_errors = FND_API.G_TRUE ) THEN
880:
881: IF (PO_PDOI_PARAMS.g_request.document_type =
882: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) THEN
883:
884: l_is_std_po := TRUE;
885:

Line 886: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

882: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) THEN
883:
884: l_is_std_po := TRUE;
885:
886: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
887: PO_PDOI_CONSTANTS.g_doc_type_BLANKET
888: AND p_doc_rec.ga_flag <> 'Y') THEN
889:
890: l_is_local_bpa := TRUE;

Line 892: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

888: AND p_doc_rec.ga_flag <> 'Y') THEN
889:
890: l_is_local_bpa := TRUE;
891:
892: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
893: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION) THEN
894:
895: l_is_quotation := TRUE;
896:

Line 903: PO_PDOI_PARAMS.g_request.calling_module =

899: IF (l_is_std_po
900: OR
901: ( (l_is_local_bpa OR l_is_quotation)
902: AND
903: PO_PDOI_PARAMS.g_request.calling_module =
904: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD )) THEN
905:
906: d_position := 10;
907:

Line 954: IF ( PO_PDOI_PARAMS.g_docs_info(p_doc_rec.interface_header_id).new_draft =

950:
951: -- bug5129752
952: -- Calculate x_remove_draft flag
953:
954: IF ( PO_PDOI_PARAMS.g_docs_info(p_doc_rec.interface_header_id).new_draft =
955: FND_API.G_TRUE) THEN
956: x_remove_draft := FND_API.G_TRUE;
957: END IF;
958:

Line 1007: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,

1003: --End of Comments
1004: ------------------------------------------------------------------------
1005: PROCEDURE transfer_document_check
1006: ( p_doc_rec IN doc_row_type,
1007: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,
1008: x_transfer_flag OUT NOCOPY VARCHAR2,
1009: x_submit_for_buyer_acc_flag OUT NOCOPY VARCHAR2
1010: ) IS
1011:

Line 1029: IF (NOT (PO_PDOI_PARAMS.g_request.document_type =

1025: -- transfer if
1026: -- 1) document is not a global agreement, OR
1027: -- 2) role of the user is BUYER
1028:
1029: IF (NOT (PO_PDOI_PARAMS.g_request.document_type =
1030: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
1031: AND
1032: p_doc_rec.ga_flag = 'Y')
1033: OR

Line 1034: PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER) THEN

1030: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
1031: AND
1032: p_doc_rec.ga_flag = 'Y')
1033: OR
1034: PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER) THEN
1035:
1036: d_position := 10;
1037: x_transfer_flag := FND_API.G_TRUE;
1038: ELSE

Line 1047: OR NVL(PO_PDOI_PARAMS.g_request.submit_dft_flag, 'N') = 'N') THEN

1043: -- If there is any line erroring out, or user explicitly prevents the
1044: -- document to be submitted, then document will not be submitted for
1045: -- buyer acceptance
1046: IF (p_doc_info.number_of_errored_lines > 0
1047: OR NVL(PO_PDOI_PARAMS.g_request.submit_dft_flag, 'N') = 'N') THEN
1048:
1049: x_submit_for_buyer_acc_flag := FND_API.G_FALSE;
1050: ELSE
1051: x_submit_for_buyer_acc_flag := FND_API.G_TRUE;

Line 1140: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN

1136: transfer_draft_to_txn (p_doc_rec => p_doc_rec);
1137:
1138: d_position := 25;
1139: --CLM PDOI Integration
1140: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN
1141: assign_clm_document_number(p_doc_rec);
1142: END IF;
1143:
1144: d_position := 30;

Line 1153: IF PO_PDOI_PARAMS.g_request.approved_status IN ('APPROVED','INITIATE APPROVAL')

1149: );
1150:
1151: d_position := 35;
1152: --CLM PDOI Integration
1153: IF PO_PDOI_PARAMS.g_request.approved_status IN ('APPROVED','INITIATE APPROVAL')
1154: AND Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
1155: THEN
1156: set_fpdsng_report_info(p_doc_rec.po_header_id);
1157: END IF;

Line 1154: AND Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'

1150:
1151: d_position := 35;
1152: --CLM PDOI Integration
1153: IF PO_PDOI_PARAMS.g_request.approved_status IN ('APPROVED','INITIATE APPROVAL')
1154: AND Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
1155: THEN
1156: set_fpdsng_report_info(p_doc_rec.po_header_id);
1157: END IF;
1158:

Line 1271: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_blanket = 'APPROVE') THEN

1267: PO_DRAFTS_PVT.unlock_document
1268: ( p_po_header_id => p_doc_rec.po_header_id
1269: );
1270:
1271: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_blanket = 'APPROVE') THEN
1272:
1273: --
1274: -- When importing blankets as approved, we need to rebuild the index
1275: -- for the catalog

Line 1336: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;

1332:
1333:
1334: l_approval_method VARCHAR2(30);
1335: l_return_status VARCHAR2(1);
1336: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
1337:
1338: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
1339:
1340: l_need_to_create_src_rules VARCHAR2(1);

Line 1348: l_doc_info := PO_PDOI_PARAMS.g_docs_info(p_doc_rec.interface_header_id);

1344: IF (PO_LOG.d_proc) THEN
1345: PO_LOG.proc_begin(d_module);
1346: END IF;
1347:
1348: l_doc_info := PO_PDOI_PARAMS.g_docs_info(p_doc_rec.interface_header_id);
1349:
1350: d_position := 10;
1351: l_need_to_create_src_rules := need_to_create_sourcing_rules
1352: ( p_doc_rec => p_doc_rec

Line 1391: p_batch_id => PO_PDOI_PARAMS.g_request.batch_id,

1387: (
1388: p_intf_header_id => p_doc_rec.interface_header_id,
1389: p_po_header_id => p_doc_rec.po_header_id,
1390: p_document_num => p_doc_rec.document_num,
1391: p_batch_id => PO_PDOI_PARAMS.g_request.batch_id,
1392: p_document_type => p_doc_rec.document_type,
1393: p_document_subtype => p_doc_rec.document_subtype,
1394: p_commit_interval => 1, -- parameter removed in R12
1395: p_any_line_updated => l_doc_info.has_lines_updated,

Line 1396: p_buyer_id => PO_PDOI_PARAMS.g_request.buyer_id,

1392: p_document_type => p_doc_rec.document_type,
1393: p_document_subtype => p_doc_rec.document_subtype,
1394: p_commit_interval => 1, -- parameter removed in R12
1395: p_any_line_updated => l_doc_info.has_lines_updated,
1396: p_buyer_id => PO_PDOI_PARAMS.g_request.buyer_id,
1397: p_agent_id => p_doc_rec.agent_id,
1398: p_vendor_id => p_doc_rec.vendor_id,
1399: p_vendor_name => p_doc_rec.vendor_name
1400: );

Line 1472: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_blanket = 'APPROVE') THEN

1468: p_status_lookup_code => NULL
1469: );
1470: /* Bug10300319 need to do archive only for approve status */
1471: IF (l_new_auth_status = 'APPROVED') then
1472: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_blanket = 'APPROVE') THEN
1473: d_position := 80;
1474:
1475: IF (PO_LOG.d_stmt) THEN
1476: PO_LOG.stmt(d_module, d_position, 'Need to archive');

Line 1654: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;

1650:
1651:
1652: l_approval_method VARCHAR2(30);
1653:
1654: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
1655:
1656: l_need_to_create_src_rules VARCHAR2(1);
1657: l_lines src_rule_lines_rec_type;
1658:

Line 1665: l_doc_info := PO_PDOI_PARAMS.g_docs_info(p_doc_rec.interface_header_id);

1661: IF (PO_LOG.d_proc) THEN
1662: PO_LOG.proc_begin(d_module);
1663: END IF;
1664:
1665: l_doc_info := PO_PDOI_PARAMS.g_docs_info(p_doc_rec.interface_header_id);
1666:
1667: d_position := 20;
1668: l_need_to_create_src_rules := need_to_create_sourcing_rules
1669: ( p_doc_rec => p_doc_rec

Line 1706: p_batch_id => PO_PDOI_PARAMS.g_request.batch_id,

1702: (
1703: p_intf_header_id => p_doc_rec.interface_header_id,
1704: p_po_header_id => p_doc_rec.po_header_id,
1705: p_document_num => p_doc_rec.document_num,
1706: p_batch_id => PO_PDOI_PARAMS.g_request.batch_id,
1707: p_document_type => p_doc_rec.document_type,
1708: p_document_subtype => p_doc_rec.document_subtype,
1709: p_commit_interval => 1, -- parameter removed in R12
1710: p_any_line_updated => l_doc_info.has_lines_updated,

Line 1711: p_buyer_id => PO_PDOI_PARAMS.g_request.buyer_id,

1707: p_document_type => p_doc_rec.document_type,
1708: p_document_subtype => p_doc_rec.document_subtype,
1709: p_commit_interval => 1, -- parameter removed in R12
1710: p_any_line_updated => l_doc_info.has_lines_updated,
1711: p_buyer_id => PO_PDOI_PARAMS.g_request.buyer_id,
1712: p_agent_id => p_doc_rec.agent_id,
1713: p_vendor_id => p_doc_rec.vendor_id,
1714: p_vendor_name => p_doc_rec.vendor_name
1715: );

Line 1836: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN

1832: transfer_draft_to_txn (p_doc_rec => p_doc_rec);
1833:
1834: d_position := 15;
1835: --CLM PDOI Integration
1836: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN
1837: assign_clm_document_number(p_doc_rec);
1838: END IF;
1839:
1840: d_position := 20;

Line 1850: IF PO_PDOI_PARAMS.g_request.approved_status IN ('APPROVED','INITIATE APPROVAL')

1846: );
1847:
1848: d_position := 25;
1849: --CLM PDOI Integration
1850: IF PO_PDOI_PARAMS.g_request.approved_status IN ('APPROVED','INITIATE APPROVAL')
1851: AND Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
1852: THEN
1853: set_fpdsng_report_info(p_doc_rec.po_header_id);
1854: END IF;

Line 1851: AND Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'

1847:
1848: d_position := 25;
1849: --CLM PDOI Integration
1850: IF PO_PDOI_PARAMS.g_request.approved_status IN ('APPROVED','INITIATE APPROVAL')
1851: AND Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
1852: THEN
1853: set_fpdsng_report_info(p_doc_rec.po_header_id);
1854: END IF;
1855:

Line 1858: PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD */

1854: END IF;
1855:
1856: -- CLM Partial Funding Changes - Start
1857: /* At this point of time, Always
1858: PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD */
1859:
1860: IF (p_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL) THEN
1861:
1862: d_position := 30;

Line 2180: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_std_po = 'APPROVE') THEN

2176:
2177: /*6851752 End */
2178:
2179: IF (l_new_auth_status = 'APPROVED') THEN
2180: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_std_po = 'APPROVE') THEN
2181: d_position := 120;
2182: IF (PO_LOG.d_stmt) THEN
2183: PO_LOG.stmt(d_module, d_position, 'archiving...');
2184: END IF;

Line 2479: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_std_po = 'APPROVE') THEN

2475: p_status_lookup_code => NULL
2476: );
2477:
2478: IF (l_new_auth_status = 'APPROVED') THEN
2479: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_std_po = 'APPROVE') THEN
2480: d_position := 90;
2481: IF (PO_LOG.d_stmt) THEN
2482: PO_LOG.stmt(d_module, d_position, 'l_archiving...');
2483: END IF;

Line 2616: IF ( (PO_PDOI_PARAMS.g_request.document_type =

2612:
2613: -- bug5024833
2614: -- Do not generate the po number from the system if number generation
2615: -- method is Manual
2616: IF ( (PO_PDOI_PARAMS.g_request.document_type =
2617: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION AND
2618: PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'MANUAL')
2619: OR
2620: (PO_PDOI_PARAMS.g_request.document_type IN

Line 2618: PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'MANUAL')

2614: -- Do not generate the po number from the system if number generation
2615: -- method is Manual
2616: IF ( (PO_PDOI_PARAMS.g_request.document_type =
2617: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION AND
2618: PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'MANUAL')
2619: OR
2620: (PO_PDOI_PARAMS.g_request.document_type IN
2621: (PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
2622: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) AND

Line 2620: (PO_PDOI_PARAMS.g_request.document_type IN

2616: IF ( (PO_PDOI_PARAMS.g_request.document_type =
2617: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION AND
2618: PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'MANUAL')
2619: OR
2620: (PO_PDOI_PARAMS.g_request.document_type IN
2621: (PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
2622: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) AND
2623: PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'MANUAL')) THEN
2624:

Line 2623: PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'MANUAL')) THEN

2619: OR
2620: (PO_PDOI_PARAMS.g_request.document_type IN
2621: (PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
2622: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) AND
2623: PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'MANUAL')) THEN
2624:
2625: d_position := 10;
2626:
2627: IF (PO_LOG.d_stmt) THEN

Line 2643: IF (PO_PDOI_PARAMS.g_request.document_type =

2639:
2640: ELSE
2641: d_position := 30;
2642:
2643: IF (PO_PDOI_PARAMS.g_request.document_type =
2644: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION) THEN
2645:
2646: l_document_num := PO_CORE_SV1.default_po_unique_identifier
2647: ( x_table_name => 'PO_HEADERS_QUOTE'

Line 2649: ELSIF (PO_PDOI_PARAMS.g_request.document_type IN

2645:
2646: l_document_num := PO_CORE_SV1.default_po_unique_identifier
2647: ( x_table_name => 'PO_HEADERS_QUOTE'
2648: );
2649: ELSIF (PO_PDOI_PARAMS.g_request.document_type IN
2650: ( PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
2651: PO_PDOI_CONSTANTS.g_doc_type_STANDARD)) THEN
2652:
2653: l_document_num := PO_CORE_SV1.default_po_unique_identifier

Line 2716: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag) = 'Y') THEN

2712: PO_LOG.proc_begin(d_module);
2713: END IF;
2714:
2715: IF ( NVL(p_doc_rec.load_sourcing_rules_flag,
2716: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag) = 'Y') THEN
2717: RETURN FND_API.G_TRUE;
2718: ELSE
2719: RETURN FND_API.G_FALSE;
2720: END IF;

Line 2886: p_document_type => PO_PDOI_PARAMS.g_request.document_type,

2882: p_interface_header_id => p_doc_rec.interface_header_id,
2883: p_interface_line_id => p_lines.interface_line_id_tbl(i),
2884: p_document_id => p_doc_rec.po_header_id,
2885: p_po_line_id => p_lines.po_line_id_tbl(i),
2886: p_document_type => PO_PDOI_PARAMS.g_request.document_type,
2887: p_approval_status => p_approval_status,
2888: p_vendor_id => l_vendor_id,
2889: p_vendor_site_id => l_vendor_site_id,
2890: p_inv_org_id => PO_PDOI_PARAMS.g_request.sourcing_inv_org_id,

Line 2890: p_inv_org_id => PO_PDOI_PARAMS.g_request.sourcing_inv_org_id,

2886: p_document_type => PO_PDOI_PARAMS.g_request.document_type,
2887: p_approval_status => p_approval_status,
2888: p_vendor_id => l_vendor_id,
2889: p_vendor_site_id => l_vendor_site_id,
2890: p_inv_org_id => PO_PDOI_PARAMS.g_request.sourcing_inv_org_id,
2891: p_sourcing_level => PO_PDOI_PARAMS.g_request.sourcing_level,
2892: p_item_id => p_lines.item_id_tbl(i),
2893: p_category_id => p_lines.category_id_tbl(i),
2894: p_rel_gen_method => PO_PDOI_PARAMS.g_request.rel_gen_method,

Line 2891: p_sourcing_level => PO_PDOI_PARAMS.g_request.sourcing_level,

2887: p_approval_status => p_approval_status,
2888: p_vendor_id => l_vendor_id,
2889: p_vendor_site_id => l_vendor_site_id,
2890: p_inv_org_id => PO_PDOI_PARAMS.g_request.sourcing_inv_org_id,
2891: p_sourcing_level => PO_PDOI_PARAMS.g_request.sourcing_level,
2892: p_item_id => p_lines.item_id_tbl(i),
2893: p_category_id => p_lines.category_id_tbl(i),
2894: p_rel_gen_method => PO_PDOI_PARAMS.g_request.rel_gen_method,
2895: p_rule_name => p_lines.sourcing_rule_name_tbl(i),

Line 2894: p_rel_gen_method => PO_PDOI_PARAMS.g_request.rel_gen_method,

2890: p_inv_org_id => PO_PDOI_PARAMS.g_request.sourcing_inv_org_id,
2891: p_sourcing_level => PO_PDOI_PARAMS.g_request.sourcing_level,
2892: p_item_id => p_lines.item_id_tbl(i),
2893: p_category_id => p_lines.category_id_tbl(i),
2894: p_rel_gen_method => PO_PDOI_PARAMS.g_request.rel_gen_method,
2895: p_rule_name => p_lines.sourcing_rule_name_tbl(i),
2896: p_rule_name_prefix => 'PURCH_OPEN_INTERFACE',
2897: p_start_date => p_lines.effective_date_tbl(i),
2898: p_end_date => p_lines.expiration_date_tbl(i),

Line 2961: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER

2957: END IF;
2958:
2959: -- bug5149827
2960: -- Delete draft if buyer initiates PDOI or document is not GA
2961: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER
2962: OR
2963: p_doc_rec.ga_flag <> 'Y') THEN
2964: l_delete_processed_draft := FND_API.G_TRUE;
2965: ELSE

Line 3042: NVL(p_doc_rec.intf_auth_status, PO_PDOI_PARAMS.g_request.approved_status);*/

3038: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_NONE;
3039: --
3040:
3041: /*l_intended_approval_status :=
3042: NVL(p_doc_rec.intf_auth_status, PO_PDOI_PARAMS.g_request.approved_status);*/
3043:
3044: --<> ----
3045: IF p_doc_rec.intf_auth_status IS NULL THEN
3046: l_intended_approval_status := PO_PDOI_PARAMS.g_request.approved_status;

Line 3046: l_intended_approval_status := PO_PDOI_PARAMS.g_request.approved_status;

3042: NVL(p_doc_rec.intf_auth_status, PO_PDOI_PARAMS.g_request.approved_status);*/
3043:
3044: --<> ----
3045: IF p_doc_rec.intf_auth_status IS NULL THEN
3046: l_intended_approval_status := PO_PDOI_PARAMS.g_request.approved_status;
3047: ELSIF p_doc_rec.intf_auth_status in ('INCOMPLETE', 'APPROVED')
3048: AND PO_PDOI_PARAMS.g_request.approved_status = 'INITIATE APPROVAL' THEN
3049: l_intended_approval_status := 'INITIATE APPROVAL';
3050: ELSE

Line 3048: AND PO_PDOI_PARAMS.g_request.approved_status = 'INITIATE APPROVAL' THEN

3044: --<> ----
3045: IF p_doc_rec.intf_auth_status IS NULL THEN
3046: l_intended_approval_status := PO_PDOI_PARAMS.g_request.approved_status;
3047: ELSIF p_doc_rec.intf_auth_status in ('INCOMPLETE', 'APPROVED')
3048: AND PO_PDOI_PARAMS.g_request.approved_status = 'INITIATE APPROVAL' THEN
3049: l_intended_approval_status := 'INITIATE APPROVAL';
3050: ELSE
3051: l_intended_approval_status := p_doc_rec.intf_auth_status;
3052: END IF;

Line 3056: IF (PO_PDOI_PARAMS.g_request.document_type IN

3052: END IF;
3053: --<> ----
3054:
3055: --------- Blanket or Standard PO -----------
3056: IF (PO_PDOI_PARAMS.g_request.document_type IN
3057: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
3058: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
3059:
3060: IF ( l_intended_approval_status = 'INCOMPLETE' OR

Line 3077: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

3073: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL;
3074: END IF;
3075:
3076: --------- Quotation -----------
3077: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3078: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
3079:
3080: IF ( p_doc_rec.orig_auth_status = 'A' OR
3081: l_intended_approval_status IN ('APPROVED', 'INITIATE APPROVAL')) THEN

Line 3210: IF (PO_PDOI_PARAMS.g_request.document_type IN

3206: IF (PO_LOG.d_proc) THEN
3207: PO_LOG.proc_begin(d_module);
3208: END IF;
3209:
3210: IF (PO_PDOI_PARAMS.g_request.document_type IN
3211: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
3212: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
3213:
3214: IF (p_auth_status = 'INCOMPLETE') THEN

Line 3235: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

3231: ELSE
3232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3233: END IF;
3234:
3235: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3236: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
3237:
3238: l_approved_flag := NULL;
3239: l_approved_date := NULL;

Line 3285: x_object_type_code => PO_PDOI_PARAMS.g_request.document_type,

3281: END IF;
3282: -- need to update action history when we approve
3283: PO_FORWARD_SV1.update_action_history
3284: ( x_object_id => p_doc_rec.po_header_id,
3285: x_object_type_code => PO_PDOI_PARAMS.g_request.document_type,
3286: x_old_employee_id => p_doc_rec.agent_id,
3287: x_action_code => 'APPROVE',
3288: x_note => NULL,
3289: x_user_id => FND_GLOBAL.user_id,

Line 3361: PO_PDOI_PARAMS.g_sys.is_federal_instance = 'Y') THEN

3357: );
3358:
3359: -- run submission check for update action, if it's a federal instance
3360: IF (p_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
3361: PO_PDOI_PARAMS.g_sys.is_federal_instance = 'Y') THEN
3362: l_validate_document := PO_DOCUMENT_FUNDS_PVT.g_parameter_YES;
3363: ELSE
3364: l_validate_document := PO_DOCUMENT_FUNDS_PVT.g_parameter_NO;
3365: END IF;

Line 3377: p_override_funds => PO_PDOI_PARAMS.g_profile.override_funds,

3373: p_doc_level_id => p_doc_rec.po_header_id,
3374: p_use_enc_gt_flag => PO_DOCUMENT_FUNDS_PVT.g_parameter_NO,
3375: p_prevent_partial_flag => PO_DOCUMENT_FUNDS_PVT.g_parameter_YES,
3376: p_employee_id => p_doc_rec.agent_id,
3377: p_override_funds => PO_PDOI_PARAMS.g_profile.override_funds,
3378: p_validate_document => l_validate_document,
3379: x_po_return_code => l_po_return_code,
3380: x_online_report_id => l_online_report_id
3381: );

Line 3462: IF (PO_PDOI_PARAMS.g_request.document_type =

3458: -- For standard PO: If document is approved and po encumbrance is turned on
3459: -- For blanket PO: If document is approved for creation case, document is
3460: -- marked as encumbrance required, and both po and req encumbrance is
3461: -- turned on
3462: IF (PO_PDOI_PARAMS.g_request.document_type =
3463: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD ) THEN
3464:
3465: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
3466: p_new_auth_status = 'APPROVED') THEN

Line 3465: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND

3461: -- turned on
3462: IF (PO_PDOI_PARAMS.g_request.document_type =
3463: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD ) THEN
3464:
3465: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
3466: p_new_auth_status = 'APPROVED') THEN
3467:
3468: l_need_to_encumber := FND_API.G_TRUE;
3469: ELSE

Line 3473: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

3469: ELSE
3470: l_need_to_encumber := FND_API.G_FALSE;
3471: END IF;
3472:
3473: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3474: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET ) THEN
3475:
3476: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
3477: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y' AND

Line 3476: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND

3472:
3473: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3474: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET ) THEN
3475:
3476: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
3477: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y' AND
3478: p_doc_rec.action <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
3479: p_doc_rec.encumbrance_required_flag = 'Y' AND
3480: p_new_auth_status = 'APPROVED') THEN

Line 3477: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y' AND

3473: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3474: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET ) THEN
3475:
3476: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
3477: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y' AND
3478: p_doc_rec.action <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
3479: p_doc_rec.encumbrance_required_flag = 'Y' AND
3480: p_new_auth_status = 'APPROVED') THEN
3481:

Line 3598: IF(PO_PDOI_PARAMS.g_request.calling_module = PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD) THEN

3594: --<<8686214 end>>
3595:
3596: --Bug 13627272
3597:
3598: IF(PO_PDOI_PARAMS.g_request.calling_module = PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD) THEN
3599:
3600: BEGIN
3601: SELECT emp.person_id
3602: INTO l_current_employee_id

Line 3621: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN

3617:
3618: d_position := 20;
3619:
3620: --CLM PDOI Integration : Need to update AME info for approval
3621: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN
3622: UPDATE po_headers_all
3623: SET AME_TRANSACTION_TYPE = ( SELECT AME_TRANSACTION_TYPE FROM po_doc_style_headers
3624: WHERE style_id = p_doc_rec.style_id
3625: ),

Line 3653: CreateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag,

3649: FaxFlag => l_fax_flag,
3650: FaxNumber => l_fax_number,
3651: EmailFlag => l_email_flag,
3652: EmailAddress => l_email_address,
3653: CreateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag,
3654: ReleaseGenMethod => PO_PDOI_PARAMS.g_request.rel_gen_method,
3655: UpdateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag
3656: );
3657:

Line 3654: ReleaseGenMethod => PO_PDOI_PARAMS.g_request.rel_gen_method,

3650: FaxNumber => l_fax_number,
3651: EmailFlag => l_email_flag,
3652: EmailAddress => l_email_address,
3653: CreateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag,
3654: ReleaseGenMethod => PO_PDOI_PARAMS.g_request.rel_gen_method,
3655: UpdateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag
3656: );
3657:
3658: IF (PO_LOG.d_proc) THEN

Line 3655: UpdateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag

3651: EmailFlag => l_email_flag,
3652: EmailAddress => l_email_address,
3653: CreateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag,
3654: ReleaseGenMethod => PO_PDOI_PARAMS.g_request.rel_gen_method,
3655: UpdateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag
3656: );
3657:
3658: IF (PO_LOG.d_proc) THEN
3659: PO_LOG.proc_end(d_module);