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 177: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;

173:
174: l_transfer_flag VARCHAR2(1);
175: l_submit_for_buyer_acc_flag VARCHAR2(1);
176:
177: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
178: l_process_code PO_HEADERS_INTERFACE.process_code%TYPE;
179:
180: x_process_code VARCHAR2(1) := ''; -- bug 7277317
181: l_remove_draft VARCHAR2(1); -- bug5129752

Line 204: LIMIT PO_PDOI_PARAMS.g_request.batch_size;

200:
201: FETCH c_doc
202: BULK COLLECT
203: INTO l_docs_tbl
204: LIMIT PO_PDOI_PARAMS.g_request.batch_size;
205:
206: IF (PO_LOG.d_stmt) THEN
207: PO_LOG.stmt(d_module, d_position, 'num of records fetched: '
208: || l_docs_tbl.COUNT);

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

219: SAVEPOINT po_pdoi_doc_postproc_sp;
220: d_position := 20;
221:
222: l_doc_rec := l_docs_tbl(i);
223: l_doc_info := PO_PDOI_PARAMS.g_docs_info(l_doc_rec.interface_header_id);
224:
225: IF (PO_PDOI_PARAMS.g_request.calling_module =
226: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
227: -- Copy processed lines info back to g_out structure. These values

Line 225: IF (PO_PDOI_PARAMS.g_request.calling_module =

221:
222: l_doc_rec := l_docs_tbl(i);
223: l_doc_info := PO_PDOI_PARAMS.g_docs_info(l_doc_rec.interface_header_id);
224:
225: IF (PO_PDOI_PARAMS.g_request.calling_module =
226: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
227: -- Copy processed lines info back to g_out structure. These values
228: -- will get returned to the caller of PDOI
229: PO_PDOI_PARAMS.g_out.processed_lines_count :=

Line 229: PO_PDOI_PARAMS.g_out.processed_lines_count :=

225: IF (PO_PDOI_PARAMS.g_request.calling_module =
226: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
227: -- Copy processed lines info back to g_out structure. These values
228: -- will get returned to the caller of PDOI
229: PO_PDOI_PARAMS.g_out.processed_lines_count :=
230: l_doc_info.number_of_processed_lines;
231: PO_PDOI_PARAMS.g_out.rejected_lines_count :=
232: l_doc_info.number_of_errored_lines;
233: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded :=

Line 231: PO_PDOI_PARAMS.g_out.rejected_lines_count :=

227: -- Copy processed lines info back to g_out structure. These values
228: -- will get returned to the caller of PDOI
229: PO_PDOI_PARAMS.g_out.processed_lines_count :=
230: l_doc_info.number_of_processed_lines;
231: PO_PDOI_PARAMS.g_out.rejected_lines_count :=
232: l_doc_info.number_of_errored_lines;
233: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded :=
234: l_doc_info.err_tolerance_exceeded;
235: END IF;

Line 233: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded :=

229: PO_PDOI_PARAMS.g_out.processed_lines_count :=
230: l_doc_info.number_of_processed_lines;
231: PO_PDOI_PARAMS.g_out.rejected_lines_count :=
232: l_doc_info.number_of_errored_lines;
233: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded :=
234: l_doc_info.err_tolerance_exceeded;
235: END IF;
236:
237: IF (PO_LOG.d_stmt) THEN

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

285: -- If user is creating a draft without transferring, we need
286: -- to get the functional lock of the document explicitly
287: PO_DRAFTS_PVT.lock_document
288: ( p_po_header_id => l_doc_rec.po_header_id,
289: p_role => PO_PDOI_PARAMS.g_request.role,
290: p_role_user_id => FND_GLOBAL.user_id,
291: p_unlock_current => FND_API.G_FALSE
292: );
293:

Line 329: IF (PO_PDOI_PARAMS.g_request.document_type =

325:
326: -- Call different module for post processing according to document
327: -- type and action
328:
329: IF (PO_PDOI_PARAMS.g_request.document_type =
330: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
331:
332: IF (l_doc_rec.action IN (PO_PDOI_CONSTANTS.g_ACTION_ADD,
333: PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL)) THEN

Line 351: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

347: x_process_code => x_process_code); -- bug 7277317
348:
349: END IF;
350:
351: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
352: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
353:
354: IF (l_doc_rec.action IN (PO_PDOI_CONSTANTS.g_ACTION_ADD,
355: PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL)) THEN

Line 371: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

367: update_quotation(p_doc_rec => l_doc_rec);
368:
369: END IF;
370:
371: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
372: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
373:
374: IF (l_doc_rec.action IN (PO_PDOI_CONSTANTS.g_ACTION_ADD,
375: PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL)) THEN

Line 625: WHERE processing_id = -PO_PDOI_PARAMS.g_processing_id

621: l_action_tbl,
622: l_dft_id_tbl,
623: l_po_header_id_tbl
624: FROM po_headers_interface PHI
625: WHERE processing_id = -PO_PDOI_PARAMS.g_processing_id
626: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num;
627:
628: d_position := 10;
629:

Line 626: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num;

622: l_dft_id_tbl,
623: l_po_header_id_tbl
624: FROM po_headers_interface PHI
625: WHERE processing_id = -PO_PDOI_PARAMS.g_processing_id
626: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num;
627:
628: d_position := 10;
629:
630: FOR i IN 1..l_intf_header_id_tbl.COUNT LOOP

Line 644: p_role => PO_PDOI_PARAMS.g_request.role

640: -- Update action
641:
642: IF (PO_DRAFTS_PVT.is_draft_applicable
643: ( p_po_header_id => l_po_header_id_tbl(i),
644: p_role => PO_PDOI_PARAMS.g_request.role
645: ) = FND_API.G_FALSE ) THEN
646:
647: d_position := 40;
648:

Line 721: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,

717: --End of Comments
718: ------------------------------------------------------------------------
719: PROCEDURE post_validate
720: ( p_doc_rec IN doc_row_type,
721: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,
722: x_header_rejected OUT NOCOPY VARCHAR2,
723: x_remove_draft OUT NOCOPY VARCHAR2 -- bug5129752
724: ) IS
725:

Line 750: IF (PO_PDOI_PARAMS.g_request.document_type =

746: -- 3) Quotation upload through catalog upload (bug5461177)
747:
748: IF ( p_doc_info.has_errors = FND_API.G_TRUE ) THEN
749:
750: IF (PO_PDOI_PARAMS.g_request.document_type =
751: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) THEN
752:
753: l_is_std_po := TRUE;
754:

Line 755: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

751: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) THEN
752:
753: l_is_std_po := TRUE;
754:
755: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
756: PO_PDOI_CONSTANTS.g_doc_type_BLANKET
757: AND p_doc_rec.ga_flag <> 'Y') THEN
758:
759: l_is_local_bpa := TRUE;

Line 761: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

757: AND p_doc_rec.ga_flag <> 'Y') THEN
758:
759: l_is_local_bpa := TRUE;
760:
761: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
762: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION) THEN
763:
764: l_is_quotation := TRUE;
765:

Line 772: PO_PDOI_PARAMS.g_request.calling_module =

768: IF (l_is_std_po
769: OR
770: ( (l_is_local_bpa OR l_is_quotation)
771: AND
772: PO_PDOI_PARAMS.g_request.calling_module =
773: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD )) THEN
774:
775: d_position := 10;
776:

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

819:
820: -- bug5129752
821: -- Calculate x_remove_draft flag
822:
823: IF ( PO_PDOI_PARAMS.g_docs_info(p_doc_rec.interface_header_id).new_draft =
824: FND_API.G_TRUE) THEN
825: x_remove_draft := FND_API.G_TRUE;
826: END IF;
827:

Line 876: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,

872: --End of Comments
873: ------------------------------------------------------------------------
874: PROCEDURE transfer_document_check
875: ( p_doc_rec IN doc_row_type,
876: p_doc_info IN PO_PDOI_PARAMS.doc_info_rec_type,
877: x_transfer_flag OUT NOCOPY VARCHAR2,
878: x_submit_for_buyer_acc_flag OUT NOCOPY VARCHAR2
879: ) IS
880:

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

894: -- transfer if
895: -- 1) document is not a global agreement, OR
896: -- 2) role of the user is BUYER
897:
898: IF (NOT (PO_PDOI_PARAMS.g_request.document_type =
899: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
900: AND
901: p_doc_rec.ga_flag = 'Y')
902: OR

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

899: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
900: AND
901: p_doc_rec.ga_flag = 'Y')
902: OR
903: PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER) THEN
904:
905: d_position := 10;
906: x_transfer_flag := FND_API.G_TRUE;
907: ELSE

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

912: -- If there is any line erroring out, or user explicitly prevents the
913: -- document to be submitted, then document will not be submitted for
914: -- buyer acceptance
915: IF (p_doc_info.number_of_errored_lines > 0
916: OR NVL(PO_PDOI_PARAMS.g_request.submit_dft_flag, 'N') = 'N') THEN
917:
918: x_submit_for_buyer_acc_flag := FND_API.G_FALSE;
919: ELSE
920: x_submit_for_buyer_acc_flag := FND_API.G_TRUE;

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

1106: PO_DRAFTS_PVT.unlock_document
1107: ( p_po_header_id => p_doc_rec.po_header_id
1108: );
1109:
1110: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_blanket = 'APPROVE') THEN
1111:
1112: --
1113: -- When importing blankets as approved, we need to rebuild the index
1114: -- for the catalog

Line 1174: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;

1170:
1171:
1172: l_approval_method VARCHAR2(30);
1173: l_return_status VARCHAR2(1);
1174: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
1175:
1176: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
1177:
1178: l_need_to_create_src_rules VARCHAR2(1);

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

1182: IF (PO_LOG.d_proc) THEN
1183: PO_LOG.proc_begin(d_module);
1184: END IF;
1185:
1186: l_doc_info := PO_PDOI_PARAMS.g_docs_info(p_doc_rec.interface_header_id);
1187:
1188: d_position := 10;
1189: l_need_to_create_src_rules := need_to_create_sourcing_rules
1190: ( p_doc_rec => p_doc_rec

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

1225: (
1226: p_intf_header_id => p_doc_rec.interface_header_id,
1227: p_po_header_id => p_doc_rec.po_header_id,
1228: p_document_num => p_doc_rec.document_num,
1229: p_batch_id => PO_PDOI_PARAMS.g_request.batch_id,
1230: p_document_type => p_doc_rec.document_type,
1231: p_document_subtype => p_doc_rec.document_subtype,
1232: p_commit_interval => 1, -- parameter removed in R12
1233: p_any_line_updated => l_doc_info.has_lines_updated,

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

1230: p_document_type => p_doc_rec.document_type,
1231: p_document_subtype => p_doc_rec.document_subtype,
1232: p_commit_interval => 1, -- parameter removed in R12
1233: p_any_line_updated => l_doc_info.has_lines_updated,
1234: p_buyer_id => PO_PDOI_PARAMS.g_request.buyer_id,
1235: p_agent_id => p_doc_rec.agent_id,
1236: p_vendor_id => p_doc_rec.vendor_id,
1237: p_vendor_name => p_doc_rec.vendor_name
1238: );

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

1286: p_auth_status => l_new_auth_status,
1287: p_status_lookup_code => NULL
1288: );
1289:
1290: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_blanket = 'APPROVE') THEN
1291: d_position := 80;
1292:
1293: IF (PO_LOG.d_stmt) THEN
1294: PO_LOG.stmt(d_module, d_position, 'Need to archive');

Line 1470: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;

1466:
1467:
1468: l_approval_method VARCHAR2(30);
1469:
1470: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
1471:
1472: l_need_to_create_src_rules VARCHAR2(1);
1473: l_lines src_rule_lines_rec_type;
1474:

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

1477: IF (PO_LOG.d_proc) THEN
1478: PO_LOG.proc_begin(d_module);
1479: END IF;
1480:
1481: l_doc_info := PO_PDOI_PARAMS.g_docs_info(p_doc_rec.interface_header_id);
1482:
1483: d_position := 20;
1484: l_need_to_create_src_rules := need_to_create_sourcing_rules
1485: ( p_doc_rec => p_doc_rec

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

1518: (
1519: p_intf_header_id => p_doc_rec.interface_header_id,
1520: p_po_header_id => p_doc_rec.po_header_id,
1521: p_document_num => p_doc_rec.document_num,
1522: p_batch_id => PO_PDOI_PARAMS.g_request.batch_id,
1523: p_document_type => p_doc_rec.document_type,
1524: p_document_subtype => p_doc_rec.document_subtype,
1525: p_commit_interval => 1, -- parameter removed in R12
1526: p_any_line_updated => l_doc_info.has_lines_updated,

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

1523: p_document_type => p_doc_rec.document_type,
1524: p_document_subtype => p_doc_rec.document_subtype,
1525: p_commit_interval => 1, -- parameter removed in R12
1526: p_any_line_updated => l_doc_info.has_lines_updated,
1527: p_buyer_id => PO_PDOI_PARAMS.g_request.buyer_id,
1528: p_agent_id => p_doc_rec.agent_id,
1529: p_vendor_id => p_doc_rec.vendor_id,
1530: p_vendor_name => p_doc_rec.vendor_name
1531: );

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

1738:
1739: /*6851752 End */
1740:
1741: IF (l_new_auth_status = 'APPROVED') THEN
1742: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_std_po = 'APPROVE') THEN
1743: d_position := 120;
1744: IF (PO_LOG.d_stmt) THEN
1745: PO_LOG.stmt(d_module, d_position, 'archiving...');
1746: END IF;

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

1903: p_status_lookup_code => NULL
1904: );
1905:
1906: IF (l_new_auth_status = 'APPROVED') THEN
1907: IF (PO_PDOI_PARAMS.g_sys.when_to_archive_std_po = 'APPROVE') THEN
1908: d_position := 90;
1909: IF (PO_LOG.d_stmt) THEN
1910: PO_LOG.stmt(d_module, d_position, 'l_archiving...');
1911: END IF;

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

2037:
2038: -- bug5024833
2039: -- Do not generate the po number from the system if number generation
2040: -- method is Manual
2041: IF ( (PO_PDOI_PARAMS.g_request.document_type =
2042: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION AND
2043: PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'MANUAL')
2044: OR
2045: (PO_PDOI_PARAMS.g_request.document_type IN

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

2039: -- Do not generate the po number from the system if number generation
2040: -- method is Manual
2041: IF ( (PO_PDOI_PARAMS.g_request.document_type =
2042: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION AND
2043: PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'MANUAL')
2044: OR
2045: (PO_PDOI_PARAMS.g_request.document_type IN
2046: (PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
2047: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) AND

Line 2045: (PO_PDOI_PARAMS.g_request.document_type IN

2041: IF ( (PO_PDOI_PARAMS.g_request.document_type =
2042: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION AND
2043: PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'MANUAL')
2044: OR
2045: (PO_PDOI_PARAMS.g_request.document_type IN
2046: (PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
2047: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) AND
2048: PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'MANUAL')) THEN
2049:

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

2044: OR
2045: (PO_PDOI_PARAMS.g_request.document_type IN
2046: (PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
2047: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) AND
2048: PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'MANUAL')) THEN
2049:
2050: d_position := 10;
2051:
2052: IF (PO_LOG.d_stmt) THEN

Line 2068: IF (PO_PDOI_PARAMS.g_request.document_type =

2064:
2065: ELSE
2066: d_position := 30;
2067:
2068: IF (PO_PDOI_PARAMS.g_request.document_type =
2069: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION) THEN
2070:
2071: l_document_num := PO_CORE_SV1.default_po_unique_identifier
2072: ( x_table_name => 'PO_HEADERS_QUOTE'

Line 2074: ELSIF (PO_PDOI_PARAMS.g_request.document_type IN

2070:
2071: l_document_num := PO_CORE_SV1.default_po_unique_identifier
2072: ( x_table_name => 'PO_HEADERS_QUOTE'
2073: );
2074: ELSIF (PO_PDOI_PARAMS.g_request.document_type IN
2075: ( PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
2076: PO_PDOI_CONSTANTS.g_doc_type_STANDARD)) THEN
2077:
2078: l_document_num := PO_CORE_SV1.default_po_unique_identifier

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

2134: PO_LOG.proc_begin(d_module);
2135: END IF;
2136:
2137: IF ( NVL(p_doc_rec.load_sourcing_rules_flag,
2138: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag) = 'Y') THEN
2139: RETURN FND_API.G_TRUE;
2140: ELSE
2141: RETURN FND_API.G_FALSE;
2142: END IF;

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

2304: p_interface_header_id => p_doc_rec.interface_header_id,
2305: p_interface_line_id => p_lines.interface_line_id_tbl(i),
2306: p_document_id => p_doc_rec.po_header_id,
2307: p_po_line_id => p_lines.po_line_id_tbl(i),
2308: p_document_type => PO_PDOI_PARAMS.g_request.document_type,
2309: p_approval_status => p_approval_status,
2310: p_vendor_id => l_vendor_id,
2311: p_vendor_site_id => l_vendor_site_id,
2312: p_inv_org_id => PO_PDOI_PARAMS.g_request.sourcing_inv_org_id,

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

2308: p_document_type => PO_PDOI_PARAMS.g_request.document_type,
2309: p_approval_status => p_approval_status,
2310: p_vendor_id => l_vendor_id,
2311: p_vendor_site_id => l_vendor_site_id,
2312: p_inv_org_id => PO_PDOI_PARAMS.g_request.sourcing_inv_org_id,
2313: p_sourcing_level => PO_PDOI_PARAMS.g_request.sourcing_level,
2314: p_item_id => p_lines.item_id_tbl(i),
2315: p_category_id => p_lines.category_id_tbl(i),
2316: p_rel_gen_method => PO_PDOI_PARAMS.g_request.rel_gen_method,

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

2309: p_approval_status => p_approval_status,
2310: p_vendor_id => l_vendor_id,
2311: p_vendor_site_id => l_vendor_site_id,
2312: p_inv_org_id => PO_PDOI_PARAMS.g_request.sourcing_inv_org_id,
2313: p_sourcing_level => PO_PDOI_PARAMS.g_request.sourcing_level,
2314: p_item_id => p_lines.item_id_tbl(i),
2315: p_category_id => p_lines.category_id_tbl(i),
2316: p_rel_gen_method => PO_PDOI_PARAMS.g_request.rel_gen_method,
2317: p_rule_name => p_lines.sourcing_rule_name_tbl(i),

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

2312: p_inv_org_id => PO_PDOI_PARAMS.g_request.sourcing_inv_org_id,
2313: p_sourcing_level => PO_PDOI_PARAMS.g_request.sourcing_level,
2314: p_item_id => p_lines.item_id_tbl(i),
2315: p_category_id => p_lines.category_id_tbl(i),
2316: p_rel_gen_method => PO_PDOI_PARAMS.g_request.rel_gen_method,
2317: p_rule_name => p_lines.sourcing_rule_name_tbl(i),
2318: p_rule_name_prefix => 'PURCH_OPEN_INTERFACE',
2319: p_start_date => p_lines.effective_date_tbl(i),
2320: p_end_date => p_lines.expiration_date_tbl(i),

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

2379: END IF;
2380:
2381: -- bug5149827
2382: -- Delete draft if buyer initiates PDOI or document is not GA
2383: IF (PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER
2384: OR
2385: p_doc_rec.ga_flag <> 'Y') THEN
2386: l_delete_processed_draft := FND_API.G_TRUE;
2387: ELSE

Line 2463: NVL(p_doc_rec.intf_auth_status, PO_PDOI_PARAMS.g_request.approved_status);

2459:
2460: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_NONE;
2461:
2462: l_intended_approval_status :=
2463: NVL(p_doc_rec.intf_auth_status, PO_PDOI_PARAMS.g_request.approved_status);
2464:
2465: --------- Blanket or Standard PO -----------
2466: IF (PO_PDOI_PARAMS.g_request.document_type IN
2467: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

Line 2466: IF (PO_PDOI_PARAMS.g_request.document_type IN

2462: l_intended_approval_status :=
2463: NVL(p_doc_rec.intf_auth_status, PO_PDOI_PARAMS.g_request.approved_status);
2464:
2465: --------- Blanket or Standard PO -----------
2466: IF (PO_PDOI_PARAMS.g_request.document_type IN
2467: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2468: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
2469:
2470: IF ( l_intended_approval_status = 'INCOMPLETE' OR

Line 2487: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

2483: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL;
2484: END IF;
2485:
2486: --------- Quotation -----------
2487: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
2488: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
2489:
2490: IF ( p_doc_rec.orig_auth_status = 'A' OR
2491: l_intended_approval_status IN ('APPROVED', 'INITIATE APPROVAL')) THEN

Line 2620: IF (PO_PDOI_PARAMS.g_request.document_type IN

2616: IF (PO_LOG.d_proc) THEN
2617: PO_LOG.proc_begin(d_module);
2618: END IF;
2619:
2620: IF (PO_PDOI_PARAMS.g_request.document_type IN
2621: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2622: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
2623:
2624: IF (p_auth_status = 'INCOMPLETE') THEN

Line 2640: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

2636: ELSE
2637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2638: END IF;
2639:
2640: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
2641: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
2642:
2643: l_approved_flag := NULL;
2644: l_approved_date := NULL;

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

2686: END IF;
2687: -- need to update action history when we approve
2688: PO_FORWARD_SV1.update_action_history
2689: ( x_object_id => p_doc_rec.po_header_id,
2690: x_object_type_code => PO_PDOI_PARAMS.g_request.document_type,
2691: x_old_employee_id => p_doc_rec.agent_id,
2692: x_action_code => 'APPROVE',
2693: x_note => NULL,
2694: x_user_id => FND_GLOBAL.user_id,

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

2762: );
2763:
2764: -- run submission check for update action, if it's a federal instance
2765: IF (p_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
2766: PO_PDOI_PARAMS.g_sys.is_federal_instance = 'Y') THEN
2767: l_validate_document := PO_DOCUMENT_FUNDS_PVT.g_parameter_YES;
2768: ELSE
2769: l_validate_document := PO_DOCUMENT_FUNDS_PVT.g_parameter_NO;
2770: END IF;

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

2778: p_doc_level_id => p_doc_rec.po_header_id,
2779: p_use_enc_gt_flag => PO_DOCUMENT_FUNDS_PVT.g_parameter_NO,
2780: p_prevent_partial_flag => PO_DOCUMENT_FUNDS_PVT.g_parameter_YES,
2781: p_employee_id => p_doc_rec.agent_id,
2782: p_override_funds => PO_PDOI_PARAMS.g_profile.override_funds,
2783: p_validate_document => l_validate_document,
2784: x_po_return_code => l_po_return_code,
2785: x_online_report_id => l_online_report_id
2786: );

Line 2867: IF (PO_PDOI_PARAMS.g_request.document_type =

2863: -- For standard PO: If document is approved and po encumbrance is turned on
2864: -- For blanket PO: If document is approved for creation case, document is
2865: -- marked as encumbrance required, and both po and req encumbrance is
2866: -- turned on
2867: IF (PO_PDOI_PARAMS.g_request.document_type =
2868: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD ) THEN
2869:
2870: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2871: p_new_auth_status = 'APPROVED') THEN

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

2866: -- turned on
2867: IF (PO_PDOI_PARAMS.g_request.document_type =
2868: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD ) THEN
2869:
2870: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2871: p_new_auth_status = 'APPROVED') THEN
2872:
2873: l_need_to_encumber := FND_API.G_TRUE;
2874: ELSE

Line 2878: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

2874: ELSE
2875: l_need_to_encumber := FND_API.G_FALSE;
2876: END IF;
2877:
2878: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
2879: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET ) THEN
2880:
2881: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2882: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y' AND

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

2877:
2878: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
2879: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET ) THEN
2880:
2881: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2882: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y' AND
2883: p_doc_rec.action <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
2884: p_doc_rec.encumbrance_required_flag = 'Y' AND
2885: p_new_auth_status = 'APPROVED') THEN

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

2878: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
2879: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET ) THEN
2880:
2881: IF (PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2882: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y' AND
2883: p_doc_rec.action <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
2884: p_doc_rec.encumbrance_required_flag = 'Y' AND
2885: p_new_auth_status = 'APPROVED') THEN
2886:

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

3008: FaxFlag => l_fax_flag,
3009: FaxNumber => l_fax_number,
3010: EmailFlag => l_email_flag,
3011: EmailAddress => l_email_address,
3012: CreateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag,
3013: ReleaseGenMethod => PO_PDOI_PARAMS.g_request.rel_gen_method,
3014: UpdateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag
3015: );
3016:

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

3009: FaxNumber => l_fax_number,
3010: EmailFlag => l_email_flag,
3011: EmailAddress => l_email_address,
3012: CreateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag,
3013: ReleaseGenMethod => PO_PDOI_PARAMS.g_request.rel_gen_method,
3014: UpdateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag
3015: );
3016:
3017: IF (PO_LOG.d_proc) THEN

Line 3014: UpdateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag

3010: EmailFlag => l_email_flag,
3011: EmailAddress => l_email_address,
3012: CreateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag,
3013: ReleaseGenMethod => PO_PDOI_PARAMS.g_request.rel_gen_method,
3014: UpdateSourcingRule => PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag
3015: );
3016:
3017: IF (PO_LOG.d_proc) THEN
3018: PO_LOG.proc_end(d_module);