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_LINE_PROCESS_PVT dependencies on PO_PDOI_CONSTANTS

Line 297: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

293: AND intf_lines.processing_id = p_request_processing_id
294: AND intf_headers.processing_round_num = p_request_processing_round_num
295: AND intf_headers.processing_id = p_request_processing_id
296: AND intf_lines.line_num = txn_lines.line_num
297: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
298:
299: -- select lines which have same line num as lines in draft table
300: CURSOR c_dup_lines_in_draft(p_request_processing_id NUMBER,
301: p_request_processing_round_num NUMBER) IS

Line 315: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

311: AND intf_lines.processing_id = p_request_processing_id
312: AND intf_headers.processing_round_num = p_request_processing_round_num
313: AND intf_headers.processing_id = p_request_processing_id
314: AND intf_lines.line_num = draft_lines.line_num
315: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
316:
317: -- duplicate lines in interface table
318: l_dup_intf_header_id_tbl PO_TBL_NUMBER;
319: l_dup_intf_line_id_tbl PO_TBL_NUMBER;

Line 344: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

340: BULK COLLECT INTO
341: l_dup_intf_header_id_tbl,
342: l_dup_intf_line_id_tbl,
343: l_dup_intf_line_num_tbl
344: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
345:
346: d_position := 20;
347:
348: l_count := l_dup_intf_line_id_tbl.COUNT;

Line 384: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

380:
381: -- reject the lines and the lower level entities associated with it
382: PO_PDOI_UTL.reject_lines_intf
383: (
384: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
385: p_id_tbl => l_dup_intf_line_id_tbl,
386: p_cascade => FND_API.g_TRUE
387: );
388:

Line 391: IF (l_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN

387: );
388:
389: d_position := 50;
390:
391: IF (l_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN
392: EXIT;
393: END IF;
394: END LOOP;
395:

Line 413: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

409: BULK COLLECT INTO
410: l_dup_intf_header_id_tbl,
411: l_dup_intf_line_id_tbl,
412: l_dup_intf_line_num_tbl
413: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
414:
415: d_position := 80;
416:
417: l_count := l_dup_intf_line_id_tbl.COUNT;

Line 453: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

449:
450: -- reject the lines and the lower level entities associated with it
451: PO_PDOI_UTL.reject_lines_intf
452: (
453: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
454: p_id_tbl => l_dup_intf_line_id_tbl,
455: p_cascade => FND_API.g_TRUE
456: );
457:

Line 460: IF (l_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN

456: );
457:
458: d_position := 110;
459:
460: IF (l_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN
461: EXIT;
462: END IF;
463: END LOOP;
464:

Line 513: AND NVL(intf_lines.action, PO_PDOI_CONSTANTS.g_ACTION_ADD) <>

509: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
510: AND intf_lines.processing_id = p_request_processing_id
511: AND intf_headers.processing_round_num = p_request_processing_round_num
512: AND intf_headers.processing_id = p_request_processing_id
513: AND NVL(intf_lines.action, PO_PDOI_CONSTANTS.g_ACTION_ADD) <>
514: PO_PDOI_CONSTANTS.g_ACTION_ADD;
515:
516: -- interface line id of lines that need to be rejected
517: l_rej_intf_line_id_tbl PO_TBL_NUMBER;

Line 514: PO_PDOI_CONSTANTS.g_ACTION_ADD;

510: AND intf_lines.processing_id = p_request_processing_id
511: AND intf_headers.processing_round_num = p_request_processing_round_num
512: AND intf_headers.processing_id = p_request_processing_id
513: AND NVL(intf_lines.action, PO_PDOI_CONSTANTS.g_ACTION_ADD) <>
514: PO_PDOI_CONSTANTS.g_ACTION_ADD;
515:
516: -- interface line id of lines that need to be rejected
517: l_rej_intf_line_id_tbl PO_TBL_NUMBER;
518: l_rej_intf_header_id_tbl PO_TBL_NUMBER;

Line 573: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

569:
570: -- reject the lines and the lower level entities associated with it
571: PO_PDOI_UTL.reject_lines_intf
572: (
573: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
574: p_id_tbl => l_rej_intf_line_id_tbl,
575: p_cascade => FND_API.g_TRUE
576: );
577:

Line 634: IF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_ADD) THEN

630:
631: -- bug5107324
632: -- cursor now selects NULL into allow_desc_update_flag_tbl as well
633:
634: IF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_ADD) THEN
635: d_position := 10;
636:
637: OPEN x_lines_csr FOR
638: SELECT intf_lines.interface_line_id,

Line 749: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

745: NULL, -- quantity_committed
746: NULL, -- tax_attribute_update_code
747:
748: DECODE(intf_lines.process_code,
749: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
750: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
751: FND_API.g_FALSE, -- need_to_reject_flag_tbl
752: FND_API.g_FALSE, -- create_line_loc_tbl
753: -1, -- group_num

Line 767: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,

763: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
764: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
765: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
766: AND intf_lines.interface_line_id > p_max_intf_line_id
767: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
768: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
769:
770: UNION ALL
771:

Line 768: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

764: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
765: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
766: AND intf_lines.interface_line_id > p_max_intf_line_id
767: AND intf_headers.action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
768: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
769:
770: UNION ALL
771:
772: SELECT intf_lines.interface_line_id,

Line 882: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

878: NULL, -- cancel_flag
879: NULL, -- quantity_committed
880: NULL, -- tax_attribute_update_code
881:
882: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
883: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
884: FND_API.G_FALSE, -- need_to_reject_flag_tbl
885: FND_API.g_FALSE, -- create_line_loc_tbl
886: -1, -- group_num

Line 899: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

895: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
896: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
897: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
898: AND intf_lines.interface_line_id > p_max_intf_line_id
899: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
900: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
901: ORDER BY 1;
902: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN
903: d_position := 20;

Line 900: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

896: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
897: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
898: AND intf_lines.interface_line_id > p_max_intf_line_id
899: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
900: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
901: ORDER BY 1;
902: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN
903: d_position := 20;
904:

Line 902: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN

898: AND intf_lines.interface_line_id > p_max_intf_line_id
899: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
900: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
901: ORDER BY 1;
902: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN
903: d_position := 20;
904:
905: OPEN x_lines_csr FOR
906: SELECT intf_lines.interface_line_id,

Line 1016: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

1012: NULL, -- cancel_flag
1013: NULL, -- quantity_committed
1014: NULL, -- tax_attribute_update_code
1015:
1016: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1017: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1018: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1019: FND_API.g_FALSE, -- create_line_loc_tbl
1020: -1, -- group_num

Line 1033: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

1029: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1030: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1031: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1032: AND intf_lines.interface_line_id > p_max_intf_line_id
1033: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1034: AND PO_PDOI_PARAMS.g_request.document_type IN
1035: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1036: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1037: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD

Line 1035: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

1031: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1032: AND intf_lines.interface_line_id > p_max_intf_line_id
1033: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1034: AND PO_PDOI_PARAMS.g_request.document_type IN
1035: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1036: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1037: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
1038: ORDER BY intf_lines.interface_line_id;
1039: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC) THEN

Line 1036: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)

1032: AND intf_lines.interface_line_id > p_max_intf_line_id
1033: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1034: AND PO_PDOI_PARAMS.g_request.document_type IN
1035: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1036: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1037: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
1038: ORDER BY intf_lines.interface_line_id;
1039: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC) THEN
1040: d_position := 30;

Line 1037: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD

1033: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1034: AND PO_PDOI_PARAMS.g_request.document_type IN
1035: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1036: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1037: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
1038: ORDER BY intf_lines.interface_line_id;
1039: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC) THEN
1040: d_position := 30;
1041:

Line 1039: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC) THEN

1035: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1036: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1037: AND intf_lines.action = PO_PDOI_CONSTANTS.g_ACTION_ADD
1038: ORDER BY intf_lines.interface_line_id;
1039: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC) THEN
1040: d_position := 30;
1041:
1042: OPEN x_lines_csr FOR
1043: SELECT intf_lines.interface_line_id,

Line 1153: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

1149: NULL, -- cancel_flag
1150: NULL, -- quantity_committed
1151: NULL, -- tax_attribute_update_code
1152:
1153: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1154: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1155: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1156: FND_API.g_FALSE, -- create_line_loc_tbl
1157: -1, -- group_num

Line 1170: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

1166: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1167: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1168: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1169: AND intf_lines.interface_line_id > p_max_intf_line_id
1170: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1171: AND PO_PDOI_PARAMS.g_request.document_type IN
1172: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1173: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1174: AND intf_lines.action IS NULL

Line 1172: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

1168: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1169: AND intf_lines.interface_line_id > p_max_intf_line_id
1170: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1171: AND PO_PDOI_PARAMS.g_request.document_type IN
1172: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1173: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1174: AND intf_lines.action IS NULL
1175: AND NOT (intf_lines.item IS NULL AND
1176: intf_lines.vendor_product_num IS NULL AND

Line 1173: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)

1169: AND intf_lines.interface_line_id > p_max_intf_line_id
1170: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1171: AND PO_PDOI_PARAMS.g_request.document_type IN
1172: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1173: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1174: AND intf_lines.action IS NULL
1175: AND NOT (intf_lines.item IS NULL AND
1176: intf_lines.vendor_product_num IS NULL AND
1177: intf_lines.job_name IS NULL AND

Line 1180: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN

1176: intf_lines.vendor_product_num IS NULL AND
1177: intf_lines.job_name IS NULL AND
1178: intf_lines.item_description IS NOT NULL)
1179: ORDER BY intf_lines.interface_line_id;
1180: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN
1181: d_position := 40;
1182:
1183: OPEN x_lines_csr FOR
1184: SELECT intf_lines.interface_line_id,

Line 1294: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,

1290: NULL, -- cancel_flag
1291: NULL, -- quantity_committed
1292: NULL, -- tax_attribute_update_code
1293:
1294: DECODE(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT,
1295: FND_API.g_TRUE, FND_API.g_FALSE), -- error_flag_tbl
1296: FND_API.G_FALSE, -- need_to_reject_flag_tbl
1297: FND_API.g_FALSE, -- create_line_loc_tbl
1298: -1, -- group_num

Line 1311: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE

1307: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1308: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1309: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1310: AND intf_lines.interface_line_id > p_max_intf_line_id
1311: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1312: AND PO_PDOI_PARAMS.g_request.document_type IN
1313: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1314: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1315: AND intf_lines.action IS NULL

Line 1313: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

1309: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1310: AND intf_lines.interface_line_id > p_max_intf_line_id
1311: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1312: AND PO_PDOI_PARAMS.g_request.document_type IN
1313: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1314: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1315: AND intf_lines.action IS NULL
1316: AND intf_lines.item IS NULL
1317: AND intf_lines.vendor_product_num IS NULL

Line 1314: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)

1310: AND intf_lines.interface_line_id > p_max_intf_line_id
1311: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1312: AND PO_PDOI_PARAMS.g_request.document_type IN
1313: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1314: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)
1315: AND intf_lines.action IS NULL
1316: AND intf_lines.item IS NULL
1317: AND intf_lines.vendor_product_num IS NULL
1318: AND intf_lines.job_name IS NULL

Line 1490: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

1486: x_lines.group_num_tbl,
1487: x_lines.origin_line_num_tbl,
1488: x_lines.match_line_found_tbl,
1489: x_lines.allow_desc_update_flag_tbl -- bug5107324
1490: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
1491:
1492: IF (PO_LOG.d_proc) THEN
1493: PO_LOG.proc_end (d_module);
1494: END IF;

Line 1541: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

1537: IF (PO_LOG.d_proc) THEN
1538: PO_LOG.proc_begin(d_module, 'line counts', x_lines.rec_count);
1539: END IF;
1540:
1541: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
1542:
1543: -- assign a new key used in temporary table
1544: l_key := PO_CORE_S.get_session_gt_nextval;
1545:

Line 1631: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

1627:
1628: d_position := 70;
1629:
1630: IF (PO_PDOI_PARAMS.g_request.document_type IN
1631: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1632: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
1633: -- derive IP category_id from IP category_name
1634: derive_ip_category_id
1635: (

Line 1632: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

1628: d_position := 70;
1629:
1630: IF (PO_PDOI_PARAMS.g_request.document_type IN
1631: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1632: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
1633: -- derive IP category_id from IP category_name
1634: derive_ip_category_id
1635: (
1636: p_key => l_key,

Line 1821: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

1817: END IF;
1818:
1819: -- derivation error for ip_category_id
1820: IF (PO_PDOI_PARAMS.g_request.document_type IN
1821: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1822: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
1823: IF (x_lines.ip_category_tbl(i) IS NOT NULL AND
1824: x_lines.ip_category_id_tbl(i) IS NULL) THEN
1825: IF (PO_LOG.d_stmt) THEN

Line 1822: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

1818:
1819: -- derivation error for ip_category_id
1820: IF (PO_PDOI_PARAMS.g_request.document_type IN
1821: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1822: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
1823: IF (x_lines.ip_category_tbl(i) IS NOT NULL AND
1824: x_lines.ip_category_id_tbl(i) IS NULL) THEN
1825: IF (PO_LOG.d_stmt) THEN
1826: PO_LOG.stmt(d_module, d_position, 'ip category id derivation failed');

Line 1986: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

1982: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
1983: END IF;
1984: END LOOP;
1985:
1986: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
1987:
1988: IF (PO_LOG.d_proc) THEN
1989: PO_LOG.proc_end (d_module);
1990: END IF;

Line 2039: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

2035: IF (PO_LOG.d_proc) THEN
2036: PO_LOG.proc_begin(d_module, 'line counts', x_lines.rec_count);
2037: END IF;
2038:
2039: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2040:
2041: -- assign a new key used in temporary table
2042: l_key := PO_CORE_S.get_session_gt_nextval;
2043:

Line 2064: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

2060:
2061: d_position := 20;
2062:
2063: IF (PO_PDOI_PARAMS.g_request.document_type IN
2064: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2065: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2066: -- derive IP category_id from IP category_name
2067: derive_ip_category_id
2068: (

Line 2065: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

2061: d_position := 20;
2062:
2063: IF (PO_PDOI_PARAMS.g_request.document_type IN
2064: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2065: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2066: -- derive IP category_id from IP category_name
2067: derive_ip_category_id
2068: (
2069: p_key => l_key,

Line 2145: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

2141: END IF;
2142:
2143: -- derivation error for ip_category_id
2144: IF (PO_PDOI_PARAMS.g_request.document_type IN
2145: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2146: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2147: IF (x_lines.ip_category_tbl(i) IS NOT NULL AND
2148: x_lines.ip_category_id_tbl(i) IS NULL) THEN
2149: IF (PO_LOG.d_stmt) THEN

Line 2146: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

2142:
2143: -- derivation error for ip_category_id
2144: IF (PO_PDOI_PARAMS.g_request.document_type IN
2145: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2146: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2147: IF (x_lines.ip_category_tbl(i) IS NOT NULL AND
2148: x_lines.ip_category_id_tbl(i) IS NULL) THEN
2149: IF (PO_LOG.d_stmt) THEN
2150: PO_LOG.stmt(d_module, d_position, 'ip category id derivation failed');

Line 2200: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

2196: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
2197: END IF;
2198: END LOOP;
2199:
2200: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2201:
2202: IF (PO_LOG.d_proc) THEN
2203: PO_LOG.proc_end (d_module);
2204: END IF;

Line 2274: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);

2270: IF (PO_LOG.d_proc) THEN
2271: PO_LOG.proc_begin(d_module);
2272: END IF;
2273:
2274: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);
2275:
2276: -- get key value to identify rows in po_session_gt table
2277: l_key := PO_CORE_S.get_session_gt_nextval;
2278:

Line 2356: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

2352: l_ic_category_id_tbl := PO_TBL_NUMBER();
2353: l_ic_category_id_tbl.EXTEND(x_lines.rec_count);
2354:
2355: IF (PO_PDOI_PARAMS.g_request.document_type IN
2356: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2357: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2358:
2359: d_position := 50;
2360:

Line 2357: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

2353: l_ic_category_id_tbl.EXTEND(x_lines.rec_count);
2354:
2355: IF (PO_PDOI_PARAMS.g_request.document_type IN
2356: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2357: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2358:
2359: d_position := 50;
2360:
2361: -- get default po category ids from ip category ids

Line 2460: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

2456: d_position := 70;
2457:
2458: -- the following default logic is for BLANKET/STANDARD only
2459: IF (PO_PDOI_PARAMS.g_request.document_type IN
2460: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2461: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
2462: d_position := 80;
2463:
2464: IF (PO_LOG.d_stmt) THEN

Line 2461: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

2457:
2458: -- the following default logic is for BLANKET/STANDARD only
2459: IF (PO_PDOI_PARAMS.g_request.document_type IN
2460: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2461: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
2462: d_position := 80;
2463:
2464: IF (PO_LOG.d_stmt) THEN
2465: PO_LOG.stmt(d_module, d_position, 'set default value for blanket/spo');

Line 2490: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

2486:
2487: -- default min_release_amount, negotiated_flag and
2488: -- price_break_lookup_code for blanket
2489: IF (PO_PDOI_PARAMS.g_request.document_type =
2490: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
2491: d_position := 90;
2492:
2493: IF (PO_LOG.d_stmt) THEN
2494: PO_LOG.stmt(d_module, d_position, 'set default value for blanket');

Line 2559: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

2555: END LOOP;
2556:
2557:
2558: IF (PO_PDOI_PARAMS.g_request.document_type IN
2559: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2560: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2561:
2562: -- default ip category id from po category ids after all other defaulting
2563: -- for po category ids have happened

Line 2560: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN

2556:
2557:
2558: IF (PO_PDOI_PARAMS.g_request.document_type IN
2559: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2560: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
2561:
2562: -- default ip category id from po category ids after all other defaulting
2563: -- for po category ids have happened
2564:

Line 2611: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);

2607: x_program_id_tbl => x_lines.program_id_tbl,
2608: x_program_update_date_tbl => x_lines.program_update_date_tbl
2609: );
2610:
2611: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);
2612:
2613: IF (PO_LOG.d_proc) THEN
2614: PO_LOG.proc_end (d_module);
2615: END IF;

Line 2673: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

2669: PO_LOG.proc_begin(d_module, 'po_line_id', x_lines.po_line_id_tbl);
2670: PO_LOG.proc_begin(d_module, 'draft_id', x_lines.draft_id_tbl);
2671: END IF;
2672:
2673: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2674:
2675: -- assign a new key used in temporary table
2676: l_key := PO_CORE_S.get_session_gt_nextval;
2677:

Line 2741: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);

2737: x_lines.item_id_tbl(l_index) := l_item_id_tbl(i);
2738: x_lines.job_id_tbl(l_index) := l_job_id_tbl(i);
2739: END LOOP;
2740:
2741: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2742:
2743: IF (PO_LOG.d_proc) THEN
2744: PO_LOG.proc_end (d_module);
2745: END IF;

Line 2794: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);

2790: IF (PO_LOG.d_proc) THEN
2791: PO_LOG.proc_begin(d_module);
2792: END IF;
2793:
2794: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);
2795:
2796: -- initialize index table
2797: PO_PDOI_UTL.generate_ordered_num_list
2798: (

Line 2812: IF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN

2808:
2809: -- bug5129752
2810: -- For FORCE ALL, simply set all line action to 'ADD'
2811:
2812: IF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN
2813: d_position := 15;
2814:
2815: FOR i IN 1..x_lines.rec_count LOOP
2816: x_lines.po_line_id_tbl(i) :=

Line 2825: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

2821: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_num
2822: (x_lines.po_header_id_tbl(i));
2823: END IF;
2824:
2825: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
2826:
2827: END LOOP;
2828:
2829: ELSE

Line 2932: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

2928: d_position := 70;
2929:
2930: PO_PDOI_UTL.reject_lines_intf
2931: (
2932: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
2933: p_id_tbl => l_rej_intf_line_id_tbl,
2934: p_cascade => FND_API.g_TRUE
2935: );
2936:

Line 2937: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);

2933: p_id_tbl => l_rej_intf_line_id_tbl,
2934: p_cascade => FND_API.g_TRUE
2935: );
2936:
2937: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);
2938:
2939: IF (PO_LOG.d_proc) THEN
2940: PO_LOG.proc_end (d_module);
2941: END IF;

Line 3020: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

3016: x_lines.shipment_num_tbl(i));
3017: END IF;
3018: -- set to TRUE in certain conditions
3019: IF (PO_PDOI_PARAMS.g_request.document_type =
3020: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
3021: IF (x_lines.order_type_lookup_code_tbl(i) IN ('QUANTITY', 'RATE') AND
3022: x_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
3023: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3024: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;

Line 3022: x_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND

3018: -- set to TRUE in certain conditions
3019: IF (PO_PDOI_PARAMS.g_request.document_type =
3020: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
3021: IF (x_lines.order_type_lookup_code_tbl(i) IN ('QUANTITY', 'RATE') AND
3022: x_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
3023: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3024: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3025: END IF;
3026: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

Line 3027: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

3023: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3024: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3025: END IF;
3026: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3027: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
3028: IF (x_lines.order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') OR
3029: x_lines.quantity_tbl(i) > 0) THEN
3030: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3031: END IF;

Line 3033: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

3029: x_lines.quantity_tbl(i) > 0) THEN
3030: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3031: END IF;
3032: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3033: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
3034: IF (x_lines.order_type_lookup_code_tbl(i) = 'QUANTITY' AND
3035: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3036: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3037: END IF;

Line 3066: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE

3062:
3063: -- obsolete the location lines that have been marked
3064: FORALL i IN 1..l_obsoleted_loc_tbl.COUNT
3065: UPDATE po_line_locations_interface
3066: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
3067: WHERE interface_line_id = l_obsoleted_loc_tbl(i);
3068:
3069: /*
3070: PO_PDOI_UTL.reject_line_locations_intf

Line 3072: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,

3068:
3069: /*
3070: PO_PDOI_UTL.reject_line_locations_intf
3071: (
3072: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
3073: p_id_tbl => l_obsoleted_loc_tbl,
3074: p_cascade => FND_API.g_TRUE
3075: );
3076: */

Line 3124: IF (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

3120: d_position := 10;
3121:
3122: FOR i IN 1..x_lines.rec_count
3123: LOOP
3124: IF (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3125: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3126: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3127: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3128: OR

Line 3125: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND

3121:
3122: FOR i IN 1..x_lines.rec_count
3123: LOOP
3124: IF (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3125: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3126: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3127: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3128: OR
3129: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

Line 3126: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =

3122: FOR i IN 1..x_lines.rec_count
3123: LOOP
3124: IF (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3125: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3126: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3127: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3128: OR
3129: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3130: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND

Line 3127: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

3123: LOOP
3124: IF (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3125: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3126: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3127: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3128: OR
3129: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3130: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3131: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =

Line 3129: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

3125: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3126: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3127: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3128: OR
3129: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3130: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3131: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3132: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
3133:

Line 3130: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND

3126: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3127: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3128: OR
3129: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3130: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3131: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3132: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
3133:
3134: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

Line 3131: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =

3127: PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3128: OR
3129: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3130: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3131: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3132: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
3133:
3134: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
3135: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN

Line 3132: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN

3128: OR
3129: (NVL(x_lines.process_code_tbl(i), PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
3130: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING AND
3131: NVL(PO_PDOI_PARAMS.g_request.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING) =
3132: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
3133:
3134: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
3135: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
3136: IF (PO_LOG.d_stmt) THEN

Line 3140: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED;

3136: IF (PO_LOG.d_stmt) THEN
3137: PO_LOG.stmt(d_module, d_position, 'update line process code to ACCEPTED. Index = ', i);
3138: END IF;
3139:
3140: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED;
3141: END IF;
3142: END IF;
3143: END LOOP;
3144:

Line 3238: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);

3234: l_index := x_processing_row_tbl.NEXT(l_index);
3235: END LOOP;
3236: END IF;
3237:
3238: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);
3239:
3240: -- get key value for po_session_gt table
3241: l_key := PO_CORE_S.get_session_gt_nextval;
3242:

Line 3244: IF (p_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN

3240: -- get key value for po_session_gt table
3241: l_key := PO_CORE_S.get_session_gt_nextval;
3242:
3243: -- call individual uniqueness check procedure for each unique criteria
3244: IF (p_type = PO_PDOI_CONSTANTS.g_LINE_CSR_SYNC_ON_DESC) THEN
3245: d_position := 10;
3246:
3247: uniqueness_check_on_desc
3248: (

Line 3313: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

3309: x_lines.vendor_product_num_tbl(i) IS NULL AND
3310: x_lines.job_name_tbl(i) IS NULL AND
3311: x_lines.line_num_tbl(i) IS NULL) THEN
3312:
3313: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
3314: x_lines.group_num_tbl(i) := p_group_num;
3315: x_lines.po_line_id_tbl(i) := PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
3316: x_lines.line_num_tbl(i) :=
3317: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_num

Line 3342: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

3338: -- If there is release shipment for a blanket line, and uom is changed,
3339: -- the existing matching line will be expired and the new line's action
3340: -- will be ADD instead of UPDATE
3341: IF (PO_PDOI_PARAMS.g_request.document_type =
3342: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
3343: d_position := 80;
3344:
3345: -- derive unit_of_measure from uom_code
3346: PO_PDOI_UTL.generate_ordered_num_list

Line 3397: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

3393: PO_LOG.stmt(d_module, d_position, 'expired line id',
3394: x_lines.po_line_id_tbl(l_index));
3395: END IF;
3396:
3397: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
3398: l_count := l_count + 1;
3399: x_expire_line_id_tbl(l_count) := x_lines.po_line_id_tbl(l_index);
3400: x_lines.po_line_id_tbl(l_index) :=
3401: PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;

Line 3422: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);

3418: END IF;
3419: END LOOP;
3420: END IF;
3421:
3422: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);
3423:
3424: IF (PO_LOG.d_proc) THEN
3425: PO_LOG.proc_end (d_module);
3426: END IF;

Line 3485: IF (p_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_ADD) THEN

3481: LOOP
3482: d_position := 10;
3483:
3484: IF (p_group_num IS NULL OR p_lines.group_num_tbl(i) = p_group_num) THEN
3485: IF (p_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_ADD) THEN
3486: IF (PO_LOG.d_stmt) THEN
3487: PO_LOG.stmt(d_module, d_position, 'lines to create', i);
3488: END IF;
3489:

Line 3491: ELSIF (p_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN

3487: PO_LOG.stmt(d_module, d_position, 'lines to create', i);
3488: END IF;
3489:
3490: l_create_index_tbl(i) := i;
3491: ELSIF (p_lines.action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN
3492: IF (PO_LOG.d_stmt) THEN
3493: PO_LOG.stmt(d_module, d_position, 'lines to update', i);
3494: END IF;
3495:

Line 3579: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);

3575: IF (PO_LOG.d_proc) THEN
3576: PO_LOG.proc_begin(d_module, 'action', p_action);
3577: END IF;
3578:
3579: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);
3580:
3581: l_lines.interface_id := x_lines.intf_line_id_tbl;
3582: l_lines.over_tolerance_error_flag := x_lines.over_tolerance_err_flag_tbl;
3583: l_lines.expiration_date := x_lines.expiration_date_tbl;

Line 3729: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);

3725: );
3726:
3727: d_position := 100;
3728:
3729: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);
3730:
3731: IF (PO_LOG.d_proc) THEN
3732: PO_LOG.proc_end(d_module, 'result_type', l_result_type);
3733: END IF;

Line 5788: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

5784: PO_LOG.stmt(d_module, d_position, 'matched po line id', l_result_tbl(i));
5785: END IF;
5786:
5787: x_lines.po_line_id_tbl(l_index) := l_result_tbl(i);
5788: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
5789: END LOOP;
5790:
5791: d_position := 20;
5792:

Line 5813: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

5809: d_position := 30;
5810:
5811: x_lines.po_line_id_tbl(i) :=
5812: l_line_reference_tbl(l_po_header_id)(l_line_num);
5813: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
5814:
5815: IF (PO_LOG.d_stmt) THEN
5816: PO_LOG.stmt(d_module, d_position, 'match found for line num');
5817: PO_LOG.stmt(d_module, d_position, 'new po line id',

Line 5825: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

5821: d_position := 40;
5822:
5823: x_lines.po_line_id_tbl(i) :=
5824: PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
5825: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
5826:
5827: l_line_reference_tbl(l_po_header_id)(l_line_num) :=
5828: x_lines.po_line_id_tbl(i);
5829:

Line 5914: IF (x_lines.hd_action_tbl(i) <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND

5910: -- 4. document is not AMOUNT based BLANKET
5911: FOR i IN 1..x_lines.rec_count
5912: LOOP
5913: IF (x_lines.line_num_tbl(i) IS NULL) THEN
5914: IF (x_lines.hd_action_tbl(i) <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
5915: x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
5916: NOT (x_lines.order_type_lookup_code_tbl(i) = 'AMOUNT' AND
5917: PO_PDOI_PARAMS.g_request.document_type =
5918: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN

Line 5918: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN

5914: IF (x_lines.hd_action_tbl(i) <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE AND
5915: x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
5916: NOT (x_lines.order_type_lookup_code_tbl(i) = 'AMOUNT' AND
5917: PO_PDOI_PARAMS.g_request.document_type =
5918: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
5919: IF (PO_LOG.d_stmt) THEN
5920: PO_LOG.stmt(d_module, d_position, 'processing index', i);
5921: END IF;
5922:

Line 5929: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

5925: -- all lines will be marked as 'ADD'
5926: x_lines.po_line_id_tbl(i) := PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
5927: x_lines.line_num_tbl(i) :=
5928: PO_PDOI_MAINPROC_UTL_PVT.get_next_line_num(x_lines.po_header_id_tbl(i));
5929: x_lines.action_tbl(i) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
5930:
5931: IF (PO_LOG.d_stmt) THEN
5932: PO_LOG.stmt(d_module, d_position, 'new po line id', x_lines.po_line_id_tbl(i));
5933: PO_LOG.stmt(d_module, d_position, 'new line num', x_lines.line_num_tbl(i));

Line 6004: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

6000: END IF;
6001:
6002: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
6003: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
6004: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
6005: -- delete the corresponding node so the line won't be matched within batch
6006: l_processing_line_tbl.DELETE(i);
6007: END LOOP;
6008:

Line 6093: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

6089: LOOP
6090: l_index := l_index_tbl(i);
6091:
6092: x_lines.po_line_id_tbl(l_index) := PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
6093: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
6094: x_lines.line_num_tbl(l_index) := PO_PDOI_MAINPROC_UTL_PVT.get_next_line_num(x_lines.po_header_id_tbl(i));
6095: -- delete the corresponding node so the line won't be matched within batch
6096: l_processing_line_tbl.DELETE(i);
6097:

Line 6165: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

6161: l_match_index := l_match_index_tbl(i);
6162:
6163: x_lines.po_line_id_tbl(l_index) := x_lines.po_line_id_tbl(l_match_index);
6164: x_lines.line_num_tbl(l_index) := x_lines.line_num_tbl(l_match_index);
6165: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
6166:
6167: IF (PO_LOG.d_stmt) THEN
6168: PO_LOG.stmt(d_module, d_position, 'index', l_index);
6169: PO_LOG.stmt(d_module, d_position, 'match index', l_match_index);

Line 6537: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

6533: END IF;
6534:
6535: -- first match found
6536: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
6537: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
6538: x_lines.group_num_tbl(l_index) := p_group_num;
6539: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
6540: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
6541: x_processing_row_tbl.DELETE(l_index);

Line 6827: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

6823: END IF;
6824:
6825: -- first match found
6826: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
6827: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
6828: x_lines.group_num_tbl(l_index) := p_group_num;
6829: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
6830: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
6831: x_processing_row_tbl.DELETE(l_index);

Line 7093: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

7089: END IF;
7090:
7091: -- first match found
7092: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
7093: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
7094: x_lines.group_num_tbl(l_index) := p_group_num;
7095: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7096: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7097: x_processing_row_tbl.DELETE(l_index);

Line 7354: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

7350: END IF;
7351:
7352: -- first match found
7353: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
7354: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
7355: x_lines.group_num_tbl(l_index) := p_group_num;
7356: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7357: x_lines.line_num_tbl(l_index) := l_line_num_tbl(i);
7358: x_processing_row_tbl.DELETE(l_index);

Line 7593: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;

7589: LOOP
7590: l_index := l_index_tbl(i);
7591:
7592: x_lines.origin_line_num_tbl(l_index) := x_lines.line_num_tbl(l_index);
7593: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
7594: x_lines.group_num_tbl(l_index) := p_group_num;
7595: x_lines.po_line_id_tbl(l_index) := l_po_line_id_tbl(i);
7596: x_processing_row_tbl.DELETE(l_index);
7597:

Line 7747: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;

7743:
7744: d_position := 10;
7745: l_index := p_target_lines_index_tbl(i);
7746:
7747: x_lines.action_tbl(l_index) := PO_PDOI_CONSTANTS.g_ACTION_ADD;
7748: x_lines.group_num_tbl(l_index) := p_group_num;
7749: x_lines.po_line_id_tbl(l_index) := PO_PDOI_MAINPROC_UTL_PVT.get_next_po_line_id;
7750:
7751: IF (p_check_line_num_assign = FND_API.G_TRUE) THEN

Line 8051: IF (PO_PDOI_PARAMS.g_request.calling_module = PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

8047: END IF;
8048:
8049: d_position := 10;
8050:
8051: IF (PO_PDOI_PARAMS.g_request.calling_module = PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
8052: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded = FND_API.G_TRUE ) THEN
8053: x_lines.need_to_reject_flag_tbl(i) := FND_API.g_TRUE;
8054:
8055: -- bug 5215781:

Line 8084: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

8080:
8081: d_position := 30;
8082:
8083: IF (PO_PDOI_PARAMS.g_request.calling_module =
8084: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
8085: l_num_errored_lines = l_err_lines_tolerance) THEN
8086:
8087: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;
8088: END IF;