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_CONSTANTS

Line 189: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_POSTPROCESSING);

185: IF (PO_LOG.d_proc) THEN
186: PO_LOG.proc_begin(d_module);
187: END IF;
188:
189: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_POSTPROCESSING);
190:
191: process_rejected_records;
192:
193: OPEN c_doc;

Line 226: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN

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 :=
230: l_doc_info.number_of_processed_lines;

Line 308: l_process_code := PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED;

304: );
305:
306: END IF;
307:
308: l_process_code := PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED;
309: ELSE
310: d_position := 70;
311:
312: IF ( l_doc_info.has_lines_to_notify = FND_API.G_TRUE) THEN

Line 313: l_process_code := PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED;

309: ELSE
310: d_position := 70;
311:
312: IF ( l_doc_info.has_lines_to_notify = FND_API.G_TRUE) THEN
313: l_process_code := PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED;
314:
315: -- 5149827
316: -- If the changes are to go over price tolerance acceptance
317: -- process, they should be removed from the draft since

Line 323: l_process_code := PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED;

319: remove_notified_draft_lines
320: ( p_draft_id => l_doc_rec.draft_id
321: );
322: ELSE
323: l_process_code := PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED;
324: END IF;
325:
326: -- Call different module for post processing according to document
327: -- type and action

Line 330: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

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
334: d_position := 80;

Line 332: IF (l_doc_rec.action IN (PO_PDOI_CONSTANTS.g_ACTION_ADD,

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
334: d_position := 80;
335: create_blanket ( p_doc_rec => l_doc_rec,
336: x_process_code => x_process_code ); --bug 7277317

Line 333: PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL)) THEN

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
334: d_position := 80;
335: create_blanket ( p_doc_rec => l_doc_rec,
336: x_process_code => x_process_code ); --bug 7277317
337:

Line 338: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN

334: d_position := 80;
335: create_blanket ( p_doc_rec => l_doc_rec,
336: x_process_code => x_process_code ); --bug 7277317
337:
338: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN
339: d_position := 90;
340: expire_document(p_doc_rec => l_doc_rec);
341: create_blanket(p_doc_rec => l_doc_rec,
342: x_process_code => x_process_code); -- bug 7277317

Line 344: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN

340: expire_document(p_doc_rec => l_doc_rec);
341: create_blanket(p_doc_rec => l_doc_rec,
342: x_process_code => x_process_code); -- bug 7277317
343:
344: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN
345: d_position := 100;
346: update_blanket(p_doc_rec => l_doc_rec,
347: x_process_code => x_process_code); -- bug 7277317
348:

Line 352: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

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
356:

Line 354: IF (l_doc_rec.action IN (PO_PDOI_CONSTANTS.g_ACTION_ADD,

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
356:
357: d_position := 110;
358: create_quotation(p_doc_rec => l_doc_rec);

Line 355: PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL)) THEN

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
356:
357: d_position := 110;
358: create_quotation(p_doc_rec => l_doc_rec);
359:

Line 360: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN

356:
357: d_position := 110;
358: create_quotation(p_doc_rec => l_doc_rec);
359:
360: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN
361: d_position := 120;
362: expire_document(p_doc_rec => l_doc_rec);
363: create_quotation(p_doc_rec => l_doc_rec);
364:

Line 365: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN

361: d_position := 120;
362: expire_document(p_doc_rec => l_doc_rec);
363: create_quotation(p_doc_rec => l_doc_rec);
364:
365: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN
366: d_position := 130;
367: update_quotation(p_doc_rec => l_doc_rec);
368:
369: END IF;

Line 372: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

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
376: d_position := 140;

Line 374: IF (l_doc_rec.action IN (PO_PDOI_CONSTANTS.g_ACTION_ADD,

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
376: d_position := 140;
377: create_standard_po(p_doc_rec => l_doc_rec,
378: x_process_code => x_process_code); -- bug 7277317

Line 375: PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL)) THEN

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
376: d_position := 140;
377: create_standard_po(p_doc_rec => l_doc_rec,
378: x_process_code => x_process_code); -- bug 7277317
379:

Line 380: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN

376: d_position := 140;
377: create_standard_po(p_doc_rec => l_doc_rec,
378: x_process_code => x_process_code); -- bug 7277317
379:
380: ELSIF (l_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN
381: d_position := 150;
382: update_standard_po(p_doc_rec => l_doc_rec,
383: x_process_code => x_process_code); -- bug 7277317
384:

Line 439: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_POSTPROCESSING);

435: END LOOP;
436:
437: close c_doc;
438:
439: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_POSTPROCESSING);
440:
441: IF (PO_LOG.d_proc) THEN
442: PO_LOG.proc_end(d_module);
443: END IF;

Line 632: IF ( l_action_tbl(i) <> PO_PDOI_CONSTANTS.g_action_UPDATE ) THEN

628: d_position := 10;
629:
630: FOR i IN 1..l_intf_header_id_tbl.COUNT LOOP
631: -- If action is not 'UPDATE', remove draft
632: IF ( l_action_tbl(i) <> PO_PDOI_CONSTANTS.g_action_UPDATE ) THEN
633: d_position := 20;
634:
635: l_dft_to_delete_tbl.EXTEND;
636: l_dft_to_delete_tbl(l_dft_to_delete_tbl.COUNT) := l_dft_id_tbl(i);

Line 751: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) THEN

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:
755: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

Line 756: PO_PDOI_CONSTANTS.g_doc_type_BLANKET

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;
760:

Line 762: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION) 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:
766: END IF;

Line 773: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD )) THEN

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:
777: IF (PO_LOG.d_stmt) THEN

Line 796: IF ( p_doc_rec.action <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE ) THEN

792: IF (PO_LOG.d_stmt) THEN
793: PO_LOG.stmt(d_module, d_position, 'failed Check 2');
794: END IF;
795:
796: IF ( p_doc_rec.action <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE ) THEN
797: -- If action <> update, we need to tell user that the document created
798: -- has 0 line, and thus the failure
799:
800: PO_PDOI_ERR_UTL.add_fatal_error

Line 899: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET

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
903: PO_PDOI_PARAMS.g_request.role = PO_GLOBAL.g_role_BUYER) THEN

Line 1026: IF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL) THEN

1022: -- bug 7277317 added an if condition to check the return status of submission check
1023: -- proceed the below logic only if return status is success
1024: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1025: x_process_code := NULL;
1026: IF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL) THEN
1027: d_position := 40;
1028:
1029:
1030: IF (PO_LOG.d_stmt) THEN

Line 1038: ELSIF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE ) THEN

1034: start_po_approval_workflow
1035: ( p_doc_rec => p_doc_rec
1036: );
1037:
1038: ELSIF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE ) THEN
1039: d_position := 50;
1040:
1041: l_new_auth_status := 'APPROVED';
1042:

Line 1118: ( p_type => PO_PDOI_CONSTANTS.g_doc_type_BLANKET,

1114: -- for the catalog
1115: d_position := 130;
1116:
1117: rebuild_catalog_index
1118: ( p_type => PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
1119: p_doc_rec => p_doc_rec
1120: );
1121: --
1122:

Line 1260: IF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL) THEN

1256: -- bug 7277317 added an if condition to check the return status of submission check
1257: -- proceed the below logic only if return status is success
1258: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1259: x_process_code := NULL;
1260: IF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL) THEN
1261: d_position := 50;
1262:
1263: IF (PO_LOG.d_stmt) THEN
1264: PO_LOG.stmt(d_module, d_position, 'launch approval workflow');

Line 1271: ELSIF (l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN

1267: start_po_approval_workflow
1268: ( p_doc_rec => p_doc_rec
1269: );
1270:
1271: ELSIF (l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN
1272: l_new_auth_status := 'APPROVED';
1273:
1274: IF (l_need_to_create_src_rules = FND_API.G_TRUE) THEN
1275: d_position := 60;

Line 1307: ( p_type => PO_PDOI_CONSTANTS.g_doc_type_BLANKET,

1303: -- for the catalog
1304: d_position := 90;
1305:
1306: rebuild_catalog_index
1307: ( p_type => PO_PDOI_CONSTANTS.g_doc_type_BLANKET,
1308: p_doc_rec => p_doc_rec
1309: );
1310: --
1311:

Line 1400: IF (l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN

1396: IF (PO_LOG.d_stmt) THEN
1397: PO_LOG.stmt(d_module, d_position, 'l_approval_method', l_approval_method);
1398: END IF;
1399:
1400: IF (l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN
1401: IF (l_need_to_create_src_rules = FND_API.G_TRUE) THEN
1402: d_position := 50;
1403:
1404: IF (PO_LOG.d_stmt) THEN

Line 1429: ( p_type => PO_PDOI_CONSTANTS.g_doc_type_QUOTATION,

1425: -- for the catalog
1426: d_position := 70;
1427:
1428: rebuild_catalog_index
1429: ( p_type => PO_PDOI_CONSTANTS.g_doc_type_QUOTATION,
1430: p_doc_rec => p_doc_rec
1431: );
1432: --
1433:

Line 1545: IF (l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN

1541: IF (PO_LOG.d_stmt) THEN
1542: PO_LOG.stmt(d_module, d_position, 'l_approval_method', l_approval_method);
1543: END IF;
1544:
1545: IF (l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN
1546: IF (l_need_to_create_src_rules = FND_API.G_TRUE) THEN
1547: d_position := 60;
1548:
1549: IF (PO_LOG.d_stmt) THEN

Line 1568: ( p_type => PO_PDOI_CONSTANTS.g_doc_type_QUOTATION,

1564: -- for the catalog
1565: d_position := 70;
1566:
1567: rebuild_catalog_index
1568: ( p_type => PO_PDOI_CONSTANTS.g_doc_type_QUOTATION,
1569: p_doc_rec => p_doc_rec
1570: );
1571: --
1572:

Line 1662: IF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL) THEN

1658: -- bug 7277317 added an if condition to check the return status of submission check
1659: -- proceed the below logic only if return status is success
1660: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1661: x_process_code := NULL;
1662: IF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL) THEN
1663: d_position := 60;
1664:
1665: IF (PO_LOG.d_stmt) THEN
1666: PO_LOG.stmt(d_module, d_position, 'launching approval workflow');

Line 1673: ELSIF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN

1669: start_po_approval_workflow
1670: ( p_doc_rec => p_doc_rec
1671: );
1672:
1673: ELSIF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN
1674:
1675: l_new_auth_status := 'APPROVED';
1676: d_position := 70;
1677: l_need_to_encumber := need_to_encumber

Line 1854: IF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL) THEN

1850: -- bug 7277317 added an if condition to check the return status of submission check
1851: -- proceed the below logic only if return status is success
1852: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1853: x_process_code := NULL;
1854: IF ( l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL) THEN
1855: d_position := 40;
1856: IF (PO_LOG.d_stmt) THEN
1857: PO_LOG.stmt(d_module, d_position, 'start approval workflow');
1858: END IF;

Line 1864: ELSIF (l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN

1860: start_po_approval_workflow
1861: ( p_doc_rec => p_doc_rec
1862: );
1863:
1864: ELSIF (l_approval_method = PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE) THEN
1865: d_position := 50;
1866: l_update_auth_status := FND_API.G_TRUE;
1867: l_new_auth_status := 'APPROVED';
1868:

Line 2042: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION AND

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
2046: (PO_PDOI_CONSTANTS.g_doc_type_BLANKET,

Line 2046: (PO_PDOI_CONSTANTS.g_doc_type_BLANKET,

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:
2050: d_position := 10;

Line 2047: PO_PDOI_CONSTANTS.g_doc_type_STANDARD) 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:
2050: d_position := 10;
2051:

Line 2069: PO_PDOI_CONSTANTS.g_doc_type_QUOTATION) THEN

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'
2073: );

Line 2075: ( PO_PDOI_CONSTANTS.g_doc_type_BLANKET,

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
2079: ( x_table_name => 'PO_HEADERS'

Line 2076: PO_PDOI_CONSTANTS.g_doc_type_STANDARD)) THEN

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
2079: ( x_table_name => 'PO_HEADERS'
2080: );

Line 2439: -- PO_PDOI_CONSTANTS.g_appr_method_NONE: No approval

2435: -- Some attribute values of the document
2436: --IN OUT:
2437: --OUT:
2438: --x_approval_method
2439: -- PO_PDOI_CONSTANTS.g_appr_method_NONE: No approval
2440: -- PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE: Approve within PDOI
2441: -- PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL: Launch approval wf
2442: --End of Comments
2443: ------------------------------------------------------------------------

Line 2440: -- PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE: Approve within PDOI

2436: --IN OUT:
2437: --OUT:
2438: --x_approval_method
2439: -- PO_PDOI_CONSTANTS.g_appr_method_NONE: No approval
2440: -- PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE: Approve within PDOI
2441: -- PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL: Launch approval wf
2442: --End of Comments
2443: ------------------------------------------------------------------------
2444: PROCEDURE get_approval_method

Line 2441: -- PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL: Launch approval wf

2437: --OUT:
2438: --x_approval_method
2439: -- PO_PDOI_CONSTANTS.g_appr_method_NONE: No approval
2440: -- PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE: Approve within PDOI
2441: -- PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL: Launch approval wf
2442: --End of Comments
2443: ------------------------------------------------------------------------
2444: PROCEDURE get_approval_method
2445: ( p_doc_rec IN doc_row_type,

Line 2460: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_NONE;

2456: IF (PO_LOG.d_proc) THEN
2457: PO_LOG.proc_begin(d_module);
2458: END IF;
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:

Line 2467: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
2471: p_doc_rec.orig_user_hold_flag = 'Y') THEN

Line 2468: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

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
2471: p_doc_rec.orig_user_hold_flag = 'Y') THEN
2472:

Line 2475: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_NONE;

2471: p_doc_rec.orig_user_hold_flag = 'Y') THEN
2472:
2473: -- Do not approve the document. The authorization status will be set
2474: -- properly by the transfer program.
2475: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_NONE;
2476:
2477: ELSIF ( l_intended_approval_status = 'APPROVED') THEN
2478:
2479: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE;

Line 2479: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE;

2475: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_NONE;
2476:
2477: ELSIF ( l_intended_approval_status = 'APPROVED') THEN
2478:
2479: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE;
2480:
2481: ELSIF ( l_intended_approval_status = 'INITIATE APPROVAL') THEN
2482:
2483: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL;

Line 2483: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_INIT_APPROVAL;

2479: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE;
2480:
2481: ELSIF ( l_intended_approval_status = 'INITIATE APPROVAL') THEN
2482:
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 =

Line 2488: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

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
2492:

Line 2493: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE;

2489:
2490: IF ( p_doc_rec.orig_auth_status = 'A' OR
2491: l_intended_approval_status IN ('APPROVED', 'INITIATE APPROVAL')) THEN
2492:
2493: x_approval_method := PO_PDOI_CONSTANTS.g_appr_method_AUTO_APPROVE;
2494: END IF;
2495:
2496: END IF;
2497:

Line 2621: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

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
2625: l_approved_flag := NULL;

Line 2622: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

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
2625: l_approved_flag := NULL;
2626: l_approved_date := NULL;

Line 2641: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

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;
2645: END IF;

Line 2765: IF (p_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND

2761: x_doc_subtype => l_doc_subtype
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;

Line 2868: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD ) THEN

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
2872:

Line 2879: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET ) THEN

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
2883: p_doc_rec.action <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND

Line 2883: p_doc_rec.action <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND

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:
2887: l_need_to_encumber := FND_API.G_TRUE;

Line 3428: IF ( p_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL) THEN

3424: PO_LOG.stmt(d_module, d_position, 'Error in Submission Check #'||x_count||' --'||i.TEXT_LINE);
3425: END IF;
3426: END LOOP;
3427:
3428: IF ( p_doc_rec.action = PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL) THEN
3429: update_document_status
3430: ( p_doc_rec => p_doc_rec,
3431: p_auth_status => 'INCOMPLETE',
3432: p_status_lookup_code => NULL