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

Line 85: PO_PDOI_PARAMS.g_current_round_num);

81: d_position := 0;
82:
83: IF (PO_LOG.d_proc) THEN
84: PO_LOG.proc_begin(d_module, 'start main process for header group',
85: PO_PDOI_PARAMS.g_current_round_num);
86: END IF;
87:
88: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);
89:

Line 104: IF (PO_PDOI_PARAMS.g_request.document_type IN

100: process_lines;
101:
102: d_position := 20;
103:
104: IF (PO_PDOI_PARAMS.g_request.document_type IN
105: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET, PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
106: process_attributes;
107: END IF;
108:

Line 115: IF (PO_PDOI_PARAMS.g_request.document_type =

111: process_line_locations;
112:
113: d_position := 40;
114:
115: IF (PO_PDOI_PARAMS.g_request.document_type =
116: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
117: process_distributions;
118: END IF;
119:

Line 128: IF (PO_PDOI_PARAMS.g_request.calling_module =

124: d_position := 60;
125:
126: -- Bug 5215781:
127: -- Remove all unprocessed records if error threshold is hit for CATALOG UPLOAD
128: IF (PO_PDOI_PARAMS.g_request.calling_module =
129: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
130: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
131: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
132: IF (PO_LOG.d_stmt) THEN

Line 130: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

126: -- Bug 5215781:
127: -- Remove all unprocessed records if error threshold is hit for CATALOG UPLOAD
128: IF (PO_PDOI_PARAMS.g_request.calling_module =
129: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
130: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
131: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
132: IF (PO_LOG.d_stmt) THEN
133: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
134: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 134: PO_PDOI_PARAMS.g_request.interface_header_id);

130: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
131: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
132: IF (PO_LOG.d_stmt) THEN
133: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
134: PO_PDOI_PARAMS.g_request.interface_header_id);
135: END IF;
136:
137: PO_PDOI_UTL.reject_unprocessed_intf
138: (

Line 139: p_intf_header_id => PO_PDOI_PARAMS.g_request.interface_header_id

135: END IF;
136:
137: PO_PDOI_UTL.reject_unprocessed_intf
138: (
139: p_intf_header_id => PO_PDOI_PARAMS.g_request.interface_header_id
140: );
141: END IF;
142:
143: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);

Line 414: IF (PO_PDOI_PARAMS.g_request.document_type =

410:
411: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
412:
413: -- reject lines with existing line_num when updating standard PO
414: IF (PO_PDOI_PARAMS.g_request.document_type =
415: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
416: PO_PDOI_LINE_PROCESS_PVT.reject_dup_lines_for_spo;
417: END IF;
418:

Line 425: IF (PO_PDOI_PARAMS.g_request.process_code <>

421: -- the only exception for this is when we re-process
422: -- the notified lines, the system has set the line
423: -- level action to either 'ADD' or 'UPADTE', we don't
424: -- need to check line level action for NOTOFIED lines
425: IF (PO_PDOI_PARAMS.g_request.process_code <>
426: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
427: PO_PDOI_LINE_PROCESS_PVT.reject_invalid_action_lines;
428: END IF;
429:

Line 467: AND processing_id = PO_PDOI_PARAMS.g_processing_id;

463:
464: -- delete all locations from po_line_locations_interface that are obsoleted
465: DELETE FROM po_line_locations_interface
466: WHERE process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
467: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
468:
469: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
470:
471: IF (PO_LOG.d_proc) THEN

Line 538: into PO_PDOI_PARAMS.g_request.interface_header_id

534:
535: /*
536: -- code added for debugging purpose
537: select interface_header_id
538: into PO_PDOI_PARAMS.g_request.interface_header_id
539: from po_headers_interface
540: where processing_id = PO_PDOI_PARAMS.g_processing_id
541: and processing_round_num = 1;
542: */

Line 540: where processing_id = PO_PDOI_PARAMS.g_processing_id

536: -- code added for debugging purpose
537: select interface_header_id
538: into PO_PDOI_PARAMS.g_request.interface_header_id
539: from po_headers_interface
540: where processing_id = PO_PDOI_PARAMS.g_processing_id
541: and processing_round_num = 1;
542: */
543:
544: -- Bug 5215781:

Line 546: IF (PO_PDOI_PARAMS.g_request.calling_module =

542: */
543:
544: -- Bug 5215781:
545: -- exit immediately if error threshold is hit for CATALOG UPLOAD
546: IF (PO_PDOI_PARAMS.g_request.calling_module =
547: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
548: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
549: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
550: IF (PO_LOG.d_stmt) THEN

Line 548: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

544: -- Bug 5215781:
545: -- exit immediately if error threshold is hit for CATALOG UPLOAD
546: IF (PO_PDOI_PARAMS.g_request.calling_module =
547: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
548: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
549: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
550: IF (PO_LOG.d_stmt) THEN
551: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||
552: ' error threshold is hit for header ',

Line 553: PO_PDOI_PARAMS.g_request.interface_header_id);

549: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
550: IF (PO_LOG.d_stmt) THEN
551: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||
552: ' error threshold is hit for header ',
553: PO_PDOI_PARAMS.g_request.interface_header_id);
554: END IF;
555:
556: RETURN;
557: END IF;

Line 576: IF (PO_PDOI_PARAMS.g_request.calling_module =

572: LOOP
573: -- Bug 5215781:
574: -- check whether num of error lines exceeds the error
575: -- threshold for each batch
576: IF (PO_PDOI_PARAMS.g_request.calling_module =
577: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
578: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
579: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
580: IF (PO_LOG.d_stmt) THEN

Line 578: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

574: -- check whether num of error lines exceeds the error
575: -- threshold for each batch
576: IF (PO_PDOI_PARAMS.g_request.calling_module =
577: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
578: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
579: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
580: IF (PO_LOG.d_stmt) THEN
581: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
582: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 582: PO_PDOI_PARAMS.g_request.interface_header_id);

578: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
579: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
580: IF (PO_LOG.d_stmt) THEN
581: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
582: PO_PDOI_PARAMS.g_request.interface_header_id);
583: END IF;
584:
585: -- no need to process remaining lines if error threshold is reached
586: EXIT;

Line 667: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN

663:
664: d_position := 70;
665:
666: -- create items if necessary
667: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
668: IF (PO_LOG.d_stmt) THEN
669: PO_LOG.stmt(d_module, d_position, 'create items for lines');
670: END IF;
671:

Line 773: AND processing_id = PO_PDOI_PARAMS.g_processing_id

769: SELECT interface_line_id
770: BULK COLLECT INTO l_rej_intf_line_id_tbl
771: FROM po_lines_interface intf_line1
772: WHERE price_break_flag = 'Y'
773: AND processing_id = PO_PDOI_PARAMS.g_processing_id
774: AND EXISTS(
775: SELECT 'Y'
776: FROM po_lines_interface intf_line2
777: WHERE intf_line1.interface_header_id = intf_line2.interface_header_id

Line 795: WHERE intf_line1.processing_id = PO_PDOI_PARAMS.g_processing_id

791:
792: -- set status to NOTIFIED for price break lines if main po line is NOTIFIED
793: UPDATE po_lines_interface intf_line1
794: SET intf_line1.process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
795: WHERE intf_line1.processing_id = PO_PDOI_PARAMS.g_processing_id
796: AND intf_line1.price_break_flag = 'Y'
797: AND EXISTS(
798: SELECT 'Y'
799: FROM po_lines_interface intf_line2

Line 893: IF (PO_PDOI_PARAMS.g_request.calling_module =

889: END IF;
890:
891: -- Bug 5215781:
892: -- exit immediately if error threshold is hit for CATALOG UPLOAD
893: IF (PO_PDOI_PARAMS.g_request.calling_module =
894: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
895: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
896: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
897: IF (PO_LOG.d_stmt) THEN

Line 895: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

891: -- Bug 5215781:
892: -- exit immediately if error threshold is hit for CATALOG UPLOAD
893: IF (PO_PDOI_PARAMS.g_request.calling_module =
894: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
895: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
896: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
897: IF (PO_LOG.d_stmt) THEN
898: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||
899: ' error threshold is hit for header ',

Line 900: PO_PDOI_PARAMS.g_request.interface_header_id);

896: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
897: IF (PO_LOG.d_stmt) THEN
898: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||
899: ' error threshold is hit for header ',
900: PO_PDOI_PARAMS.g_request.interface_header_id);
901: END IF;
902:
903: RETURN;
904: END IF;

Line 923: IF (PO_PDOI_PARAMS.g_request.calling_module =

919: LOOP
920: -- Bug 5215781:
921: -- check whether num of error lines exceeds the error
922: -- threshold for the previous batch
923: IF (PO_PDOI_PARAMS.g_request.calling_module =
924: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
925: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
926: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
927: d_position := 20;

Line 925: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

921: -- check whether num of error lines exceeds the error
922: -- threshold for the previous batch
923: IF (PO_PDOI_PARAMS.g_request.calling_module =
924: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
925: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
926: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
927: d_position := 20;
928:
929: IF (PO_LOG.d_stmt) THEN

Line 931: PO_PDOI_PARAMS.g_request.interface_header_id);

927: d_position := 20;
928:
929: IF (PO_LOG.d_stmt) THEN
930: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
931: PO_PDOI_PARAMS.g_request.interface_header_id);
932: END IF;
933:
934: EXIT;
935: END IF;

Line 1116: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

1112: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1113: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1114: po_headers_interface intf_headers
1115: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1116: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1117: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1118: AND intf_line2.price_break_flag = 'Y'
1119: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1120: AND intf_line2.interface_header_id = intf_line3.interface_header_id

Line 1117: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

1113: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1114: po_headers_interface intf_headers
1115: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1116: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1117: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1118: AND intf_line2.price_break_flag = 'Y'
1119: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1120: AND intf_line2.interface_header_id = intf_line3.interface_header_id
1121: AND intf_line2.po_line_id = intf_line3.po_line_id

Line 1119: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id

1115: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1116: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1117: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1118: AND intf_line2.price_break_flag = 'Y'
1119: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1120: AND intf_line2.interface_header_id = intf_line3.interface_header_id
1121: AND intf_line2.po_line_id = intf_line3.po_line_id
1122: AND NVL(intf_line3.price_break_flag, 'N') = 'N'
1123: AND intf_line3.interface_line_id < intf_line2.interface_line_id

Line 1148: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

1144: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1145: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1146: po_headers_interface intf_headers
1147: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1148: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1149: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1150: AND intf_line2.price_break_flag = 'Y'
1151: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1152: AND intf_line2.interface_header_id = intf_line3.interface_header_id

Line 1149: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

1145: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1146: po_headers_interface intf_headers
1147: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1148: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1149: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1150: AND intf_line2.price_break_flag = 'Y'
1151: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1152: AND intf_line2.interface_header_id = intf_line3.interface_header_id
1153: AND intf_line2.po_line_id = intf_line3.po_line_id

Line 1151: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id

1147: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1148: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1149: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1150: AND intf_line2.price_break_flag = 'Y'
1151: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1152: AND intf_line2.interface_header_id = intf_line3.interface_header_id
1153: AND intf_line2.po_line_id = intf_line3.po_line_id
1154: AND NVL(intf_line3.price_break_flag, 'N') = 'N'
1155: AND intf_line3.interface_line_id < intf_line2.interface_line_id

Line 1271: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN

1267:
1268: d_position := 40;
1269:
1270: -- create items if necessary
1271: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
1272: IF (PO_LOG.d_stmt) THEN
1273: PO_LOG.stmt(d_module, d_position, 'create items from line info');
1274: END IF;
1275:

Line 1540: IF (PO_PDOI_PARAMS.g_request.calling_module =

1536: END IF;
1537:
1538: -- Bug 5215781:
1539: -- exit immediately if error threshold is hit for CATALOG UPLOAD
1540: IF (PO_PDOI_PARAMS.g_request.calling_module =
1541: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1542: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1543: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1544: IF (PO_LOG.d_stmt) THEN

Line 1542: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

1538: -- Bug 5215781:
1539: -- exit immediately if error threshold is hit for CATALOG UPLOAD
1540: IF (PO_PDOI_PARAMS.g_request.calling_module =
1541: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1542: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1543: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1544: IF (PO_LOG.d_stmt) THEN
1545: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||
1546: ' error threshold is hit for header ',

Line 1547: PO_PDOI_PARAMS.g_request.interface_header_id);

1543: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1544: IF (PO_LOG.d_stmt) THEN
1545: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||
1546: ' error threshold is hit for header ',
1547: PO_PDOI_PARAMS.g_request.interface_header_id);
1548: END IF;
1549:
1550: RETURN;
1551: END IF;

Line 1571: IF (PO_PDOI_PARAMS.g_request.calling_module =

1567: LOOP
1568: -- Bug 5215781:
1569: -- check whether num of error lines exceeds the error
1570: -- threshold for the previous batch
1571: IF (PO_PDOI_PARAMS.g_request.calling_module =
1572: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1573: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1574: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1575: d_position := 20;

Line 1573: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

1569: -- check whether num of error lines exceeds the error
1570: -- threshold for the previous batch
1571: IF (PO_PDOI_PARAMS.g_request.calling_module =
1572: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1573: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1574: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1575: d_position := 20;
1576:
1577: IF (PO_LOG.d_stmt) THEN

Line 1579: PO_PDOI_PARAMS.g_request.interface_header_id);

1575: d_position := 20;
1576:
1577: IF (PO_LOG.d_stmt) THEN
1578: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
1579: PO_PDOI_PARAMS.g_request.interface_header_id);
1580: END IF;
1581:
1582: EXIT;
1583: END IF;

Line 1626: IF (PO_PDOI_PARAMS.g_request.document_type =

1622:
1623: -- check whether provided shipment_num is unqiue across interface,
1624: -- draft and txn tables.
1625: -- logic is performed for Standard PO only
1626: IF (PO_PDOI_PARAMS.g_request.document_type =
1627: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1628: PO_PDOI_MAINPROC_UTL_PVT.check_shipment_num_unique
1629: (
1630: p_po_line_id_tbl => l_line_locs.ln_po_line_id_tbl,

Line 1694: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(l_line_locs.intf_line_id_tbl(i))) THEN

1690: -- remove the logic here, same logic is moved to PO_PDOI_LINE_LOC_PROCESS_PVT
1691: /*
1692: -- bug4662687 START
1693: -- Report the lines that have shipment/price break errors
1694: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(l_line_locs.intf_line_id_tbl(i))) THEN
1695: PO_PDOI_PARAMS.g_errored_lines(l_line_locs.intf_line_id_tbl(i)) := 'Y';
1696: PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines
1697: := PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines +1;
1698:

Line 1695: PO_PDOI_PARAMS.g_errored_lines(l_line_locs.intf_line_id_tbl(i)) := 'Y';

1691: /*
1692: -- bug4662687 START
1693: -- Report the lines that have shipment/price break errors
1694: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(l_line_locs.intf_line_id_tbl(i))) THEN
1695: PO_PDOI_PARAMS.g_errored_lines(l_line_locs.intf_line_id_tbl(i)) := 'Y';
1696: PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines
1697: := PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines +1;
1698:
1699: END IF;

Line 1696: PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines

1692: -- bug4662687 START
1693: -- Report the lines that have shipment/price break errors
1694: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(l_line_locs.intf_line_id_tbl(i))) THEN
1695: PO_PDOI_PARAMS.g_errored_lines(l_line_locs.intf_line_id_tbl(i)) := 'Y';
1696: PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines
1697: := PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines +1;
1698:
1699: END IF;
1700: -- bug4662687 END

Line 1697: := PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines +1;

1693: -- Report the lines that have shipment/price break errors
1694: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(l_line_locs.intf_line_id_tbl(i))) THEN
1695: PO_PDOI_PARAMS.g_errored_lines(l_line_locs.intf_line_id_tbl(i)) := 'Y';
1696: PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines
1697: := PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines +1;
1698:
1699: END IF;
1700: -- bug4662687 END
1701: */

Line 1774: IF (PO_PDOI_PARAMS.g_request.document_type =

1770: CLOSE l_line_locs_csr;
1771: END IF;
1772:
1773: -- line location post processing
1774: IF (PO_PDOI_PARAMS.g_request.document_type =
1775: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1776: d_position := 130;
1777:
1778: -- update amount or quantity value on po_lines_draft_all based

Line 1785: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

1781: (
1782: p_po_line_id_tbl => l_processed_line_id_tbl,
1783: p_draft_id_tbl => l_processed_draft_id_tbl
1784: );
1785: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1786: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1787: d_position := 140;
1788:
1789: -- delete all existing price breaks for quotation update

Line 2088: IF (PO_PDOI_PARAMS.g_request.calling_module =

2084: END IF;
2085:
2086: -- Bug 5215781:
2087: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2088: IF (PO_PDOI_PARAMS.g_request.calling_module =
2089: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2090: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2091: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2092: IF (PO_LOG.d_stmt) THEN

Line 2090: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

2086: -- Bug 5215781:
2087: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2088: IF (PO_PDOI_PARAMS.g_request.calling_module =
2089: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2090: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2091: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2092: IF (PO_LOG.d_stmt) THEN
2093: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||
2094: ' error threshold is hit for header ',

Line 2095: PO_PDOI_PARAMS.g_request.interface_header_id);

2091: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2092: IF (PO_LOG.d_stmt) THEN
2093: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||
2094: ' error threshold is hit for header ',
2095: PO_PDOI_PARAMS.g_request.interface_header_id);
2096: END IF;
2097:
2098: RETURN;
2099: END IF;

Line 2119: IF (PO_PDOI_PARAMS.g_request.calling_module =

2115: LOOP
2116: -- Bug 5215781:
2117: -- check whether num of error lines exceeds the error
2118: -- threshold for the previous batch
2119: IF (PO_PDOI_PARAMS.g_request.calling_module =
2120: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2121: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2122: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2123: d_position := 20;

Line 2121: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

2117: -- check whether num of error lines exceeds the error
2118: -- threshold for the previous batch
2119: IF (PO_PDOI_PARAMS.g_request.calling_module =
2120: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2121: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2122: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2123: d_position := 20;
2124:
2125: IF (PO_LOG.d_stmt) THEN

Line 2127: PO_PDOI_PARAMS.g_request.interface_header_id);

2123: d_position := 20;
2124:
2125: IF (PO_LOG.d_stmt) THEN
2126: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2127: PO_PDOI_PARAMS.g_request.interface_header_id);
2128: END IF;
2129:
2130: EXIT;
2131: END IF;

Line 2296: IF (PO_PDOI_PARAMS.g_request.calling_module =

2292: END IF;
2293:
2294: -- Bug 5215781:
2295: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2296: IF (PO_PDOI_PARAMS.g_request.calling_module =
2297: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2298: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2299: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2300: IF (PO_LOG.d_stmt) THEN

Line 2298: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)

2294: -- Bug 5215781:
2295: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2296: IF (PO_PDOI_PARAMS.g_request.calling_module =
2297: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2298: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2299: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2300: IF (PO_LOG.d_stmt) THEN
2301: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||
2302: ' error threshold is hit for header ',

Line 2303: PO_PDOI_PARAMS.g_request.interface_header_id);

2299: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2300: IF (PO_LOG.d_stmt) THEN
2301: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||
2302: ' error threshold is hit for header ',
2303: PO_PDOI_PARAMS.g_request.interface_header_id);
2304: END IF;
2305:
2306: RETURN;
2307: END IF;