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 100: PO_PDOI_PARAMS.g_current_round_num);

96: d_position := 0;
97:
98: IF (PO_LOG.d_proc) THEN
99: PO_LOG.proc_begin(d_module, 'start main process for header group',
100: PO_PDOI_PARAMS.g_current_round_num);
101: END IF;
102:
103: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);
104:

Line 119: IF (PO_PDOI_PARAMS.g_request.document_type IN

115: process_lines;
116:
117: d_position := 20;
118:
119: IF (PO_PDOI_PARAMS.g_request.document_type IN
120: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET, PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
121: process_attributes;
122: END IF;
123:

Line 130: IF (PO_PDOI_PARAMS.g_request.document_type =

126: process_line_locations;
127:
128: d_position := 40;
129:
130: IF (PO_PDOI_PARAMS.g_request.document_type =
131: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
132: process_distributions;
133: END IF;
134:

Line 143: IF (PO_PDOI_PARAMS.g_request.calling_module =

139: d_position := 60;
140:
141: -- Bug 5215781:
142: -- Remove all unprocessed records if error threshold is hit for CATALOG UPLOAD
143: IF (PO_PDOI_PARAMS.g_request.calling_module =
144: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
145: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
146: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
147: IF (PO_LOG.d_stmt) THEN

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

141: -- Bug 5215781:
142: -- Remove all unprocessed records if error threshold is hit for CATALOG UPLOAD
143: IF (PO_PDOI_PARAMS.g_request.calling_module =
144: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
145: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
146: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
147: IF (PO_LOG.d_stmt) THEN
148: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
149: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 149: PO_PDOI_PARAMS.g_request.interface_header_id);

145: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
146: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
147: IF (PO_LOG.d_stmt) THEN
148: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
149: PO_PDOI_PARAMS.g_request.interface_header_id);
150: END IF;
151:
152: PO_PDOI_UTL.reject_unprocessed_intf
153: (

Line 154: p_intf_header_id => PO_PDOI_PARAMS.g_request.interface_header_id

150: END IF;
151:
152: PO_PDOI_UTL.reject_unprocessed_intf
153: (
154: p_intf_header_id => PO_PDOI_PARAMS.g_request.interface_header_id
155: );
156: END IF;
157:
158: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);

Line 393: IF (PO_PDOI_PARAMS.g_request.calling_module =

389: -- when the process in initiated from CATALOG_UPLOAD and action in po_headers_interface ='UPDATE'
390:
391: d_position := 100;
392:
393: IF (PO_PDOI_PARAMS.g_request.calling_module =
394: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD)
395: THEN
396:
397: l_cat_upload_head_exists :=TRUE;

Line 411: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

407: l_headers.po_header_id_tbl,
408: l_delete_tbl
409:
410: FROM po_headers_interface
411: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
412: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
413: AND interface_header_id > l_max_intf_header_id
414: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
415: ORDER by interface_header_id;

Line 412: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num

408: l_delete_tbl
409:
410: FROM po_headers_interface
411: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
412: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
413: AND interface_header_id > l_max_intf_header_id
414: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
415: ORDER by interface_header_id;
416:

Line 534: IF (PO_PDOI_PARAMS.g_request.document_type =

530:
531: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
532:
533: -- reject lines with existing line_num when updating standard PO
534: IF (PO_PDOI_PARAMS.g_request.document_type =
535: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
536: PO_PDOI_LINE_PROCESS_PVT.reject_dup_lines_for_spo;
537: END IF;
538:

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

541: -- the only exception for this is when we re-process
542: -- the notified lines, the system has set the line
543: -- level action to either 'ADD' or 'UPADTE', we don't
544: -- need to check line level action for NOTOFIED lines
545: IF (PO_PDOI_PARAMS.g_request.process_code <>
546: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
547: PO_PDOI_LINE_PROCESS_PVT.reject_invalid_action_lines;
548: END IF;
549:

Line 600: AND processing_id = PO_PDOI_PARAMS.g_processing_id;

596:
597: -- delete all locations from po_line_locations_interface that are obsoleted
598: DELETE FROM po_line_locations_interface
599: WHERE process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
600: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
601:
602: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
603:
604: IF (PO_LOG.d_proc) THEN

Line 675: into PO_PDOI_PARAMS.g_request.interface_header_id

671:
672: /*
673: -- code added for debugging purpose
674: select interface_header_id
675: into PO_PDOI_PARAMS.g_request.interface_header_id
676: from po_headers_interface
677: where processing_id = PO_PDOI_PARAMS.g_processing_id
678: and processing_round_num = 1;
679: */

Line 677: where processing_id = PO_PDOI_PARAMS.g_processing_id

673: -- code added for debugging purpose
674: select interface_header_id
675: into PO_PDOI_PARAMS.g_request.interface_header_id
676: from po_headers_interface
677: where processing_id = PO_PDOI_PARAMS.g_processing_id
678: and processing_round_num = 1;
679: */
680:
681: -- Bug 5215781:

Line 683: IF (PO_PDOI_PARAMS.g_request.calling_module =

679: */
680:
681: -- Bug 5215781:
682: -- exit immediately if error threshold is hit for CATALOG UPLOAD
683: IF (PO_PDOI_PARAMS.g_request.calling_module =
684: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
685: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
686: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
687: IF (PO_LOG.d_stmt) THEN

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

681: -- Bug 5215781:
682: -- exit immediately if error threshold is hit for CATALOG UPLOAD
683: IF (PO_PDOI_PARAMS.g_request.calling_module =
684: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
685: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
686: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
687: IF (PO_LOG.d_stmt) THEN
688: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||
689: ' error threshold is hit for header ',

Line 690: PO_PDOI_PARAMS.g_request.interface_header_id);

686: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
687: IF (PO_LOG.d_stmt) THEN
688: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||
689: ' error threshold is hit for header ',
690: PO_PDOI_PARAMS.g_request.interface_header_id);
691: END IF;
692:
693: RETURN;
694: END IF;

Line 713: IF (PO_PDOI_PARAMS.g_request.calling_module =

709: LOOP
710: -- Bug 5215781:
711: -- check whether num of error lines exceeds the error
712: -- threshold for each batch
713: IF (PO_PDOI_PARAMS.g_request.calling_module =
714: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
715: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
716: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
717: IF (PO_LOG.d_stmt) THEN

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

711: -- check whether num of error lines exceeds the error
712: -- threshold for each batch
713: IF (PO_PDOI_PARAMS.g_request.calling_module =
714: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
715: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
716: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
717: IF (PO_LOG.d_stmt) THEN
718: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
719: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 719: PO_PDOI_PARAMS.g_request.interface_header_id);

715: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
716: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
717: IF (PO_LOG.d_stmt) THEN
718: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
719: PO_PDOI_PARAMS.g_request.interface_header_id);
720: END IF;
721:
722: -- no need to process remaining lines if error threshold is reached
723: EXIT;

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

809:
810: d_position := 70;
811:
812: -- create items if necessary
813: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
814: IF (PO_LOG.d_stmt) THEN
815: PO_LOG.stmt(d_module, d_position, 'create items for lines');
816: END IF;
817:

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

836: (
837: x_lines => l_lines
838: );
839:
840: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
841: THEN
842: --Call the api to convert base_line_num from interface to draft
843: set_intf_base_line_num_to_dft;
844: END IF;

Line 936: AND processing_id = PO_PDOI_PARAMS.g_processing_id

932: SELECT interface_line_id
933: BULK COLLECT INTO l_rej_intf_line_id_tbl
934: FROM po_lines_interface intf_line1
935: WHERE price_break_flag = 'Y'
936: AND processing_id = PO_PDOI_PARAMS.g_processing_id
937: AND EXISTS(
938: SELECT 'Y'
939: FROM po_lines_interface intf_line2
940: WHERE intf_line1.interface_header_id = intf_line2.interface_header_id

Line 958: WHERE intf_line1.processing_id = PO_PDOI_PARAMS.g_processing_id

954:
955: -- set status to NOTIFIED for price break lines if main po line is NOTIFIED
956: UPDATE po_lines_interface intf_line1
957: SET intf_line1.process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
958: WHERE intf_line1.processing_id = PO_PDOI_PARAMS.g_processing_id
959: AND intf_line1.price_break_flag = 'Y'
960: AND EXISTS(
961: SELECT 'Y'
962: FROM po_lines_interface intf_line2

Line 1056: IF (PO_PDOI_PARAMS.g_request.calling_module =

1052: END IF;
1053:
1054: -- Bug 5215781:
1055: -- exit immediately if error threshold is hit for CATALOG UPLOAD
1056: IF (PO_PDOI_PARAMS.g_request.calling_module =
1057: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1058: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1059: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1060: IF (PO_LOG.d_stmt) THEN

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

1054: -- Bug 5215781:
1055: -- exit immediately if error threshold is hit for CATALOG UPLOAD
1056: IF (PO_PDOI_PARAMS.g_request.calling_module =
1057: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1058: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1059: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1060: IF (PO_LOG.d_stmt) THEN
1061: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||
1062: ' error threshold is hit for header ',

Line 1063: PO_PDOI_PARAMS.g_request.interface_header_id);

1059: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1060: IF (PO_LOG.d_stmt) THEN
1061: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||
1062: ' error threshold is hit for header ',
1063: PO_PDOI_PARAMS.g_request.interface_header_id);
1064: END IF;
1065:
1066: RETURN;
1067: END IF;

Line 1086: IF (PO_PDOI_PARAMS.g_request.calling_module =

1082: LOOP
1083: -- Bug 5215781:
1084: -- check whether num of error lines exceeds the error
1085: -- threshold for the previous batch
1086: IF (PO_PDOI_PARAMS.g_request.calling_module =
1087: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1088: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1089: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1090: d_position := 20;

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

1084: -- check whether num of error lines exceeds the error
1085: -- threshold for the previous batch
1086: IF (PO_PDOI_PARAMS.g_request.calling_module =
1087: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1088: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1089: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1090: d_position := 20;
1091:
1092: IF (PO_LOG.d_stmt) THEN

Line 1094: PO_PDOI_PARAMS.g_request.interface_header_id);

1090: d_position := 20;
1091:
1092: IF (PO_LOG.d_stmt) THEN
1093: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
1094: PO_PDOI_PARAMS.g_request.interface_header_id);
1095: END IF;
1096:
1097: EXIT;
1098: END IF;

Line 1279: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

1275: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1276: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1277: po_headers_interface intf_headers
1278: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1279: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1280: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1281: AND intf_line2.price_break_flag = 'Y'
1282: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1283: AND intf_line2.interface_header_id = intf_line3.interface_header_id

Line 1280: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

1276: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1277: po_headers_interface intf_headers
1278: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1279: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1280: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1281: AND intf_line2.price_break_flag = 'Y'
1282: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1283: AND intf_line2.interface_header_id = intf_line3.interface_header_id
1284: AND intf_line2.po_line_id = intf_line3.po_line_id

Line 1282: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id

1278: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1279: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1280: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1281: AND intf_line2.price_break_flag = 'Y'
1282: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1283: AND intf_line2.interface_header_id = intf_line3.interface_header_id
1284: AND intf_line2.po_line_id = intf_line3.po_line_id
1285: AND NVL(intf_line3.price_break_flag, 'N') = 'N'
1286: AND intf_line3.interface_line_id < intf_line2.interface_line_id

Line 1311: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

1307: (SELECT intf_line2.interface_line_id, max(intf_line3.interface_line_id) AS match_intf_line_id
1308: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1309: po_headers_interface intf_headers
1310: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1311: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1312: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1313: AND intf_line2.price_break_flag = 'Y'
1314: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1315: AND intf_line2.interface_header_id = intf_line3.interface_header_id

Line 1312: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

1308: FROM po_lines_interface intf_line2, po_lines_interface intf_line3,
1309: po_headers_interface intf_headers
1310: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1311: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1312: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1313: AND intf_line2.price_break_flag = 'Y'
1314: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1315: AND intf_line2.interface_header_id = intf_line3.interface_header_id
1316: AND intf_line2.po_line_id = intf_line3.po_line_id

Line 1314: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id

1310: WHERE intf_line2.interface_header_id = intf_headers.interface_header_id
1311: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1312: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1313: AND intf_line2.price_break_flag = 'Y'
1314: AND intf_line2.processing_id = PO_PDOI_PARAMS.g_processing_id
1315: AND intf_line2.interface_header_id = intf_line3.interface_header_id
1316: AND intf_line2.po_line_id = intf_line3.po_line_id
1317: AND NVL(intf_line3.price_break_flag, 'N') = 'N'
1318: AND intf_line3.interface_line_id < intf_line2.interface_line_id

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

1430:
1431: d_position := 40;
1432:
1433: -- create items if necessary
1434: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
1435: IF (PO_LOG.d_stmt) THEN
1436: PO_LOG.stmt(d_module, d_position, 'create items from line info');
1437: END IF;
1438:

Line 1703: IF (PO_PDOI_PARAMS.g_request.calling_module =

1699: END IF;
1700:
1701: -- Bug 5215781:
1702: -- exit immediately if error threshold is hit for CATALOG UPLOAD
1703: IF (PO_PDOI_PARAMS.g_request.calling_module =
1704: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1705: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1706: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1707: IF (PO_LOG.d_stmt) THEN

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

1701: -- Bug 5215781:
1702: -- exit immediately if error threshold is hit for CATALOG UPLOAD
1703: IF (PO_PDOI_PARAMS.g_request.calling_module =
1704: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1705: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1706: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1707: IF (PO_LOG.d_stmt) THEN
1708: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||
1709: ' error threshold is hit for header ',

Line 1710: PO_PDOI_PARAMS.g_request.interface_header_id);

1706: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1707: IF (PO_LOG.d_stmt) THEN
1708: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||
1709: ' error threshold is hit for header ',
1710: PO_PDOI_PARAMS.g_request.interface_header_id);
1711: END IF;
1712:
1713: RETURN;
1714: END IF;

Line 1734: IF (PO_PDOI_PARAMS.g_request.calling_module =

1730: LOOP
1731: -- Bug 5215781:
1732: -- check whether num of error lines exceeds the error
1733: -- threshold for the previous batch
1734: IF (PO_PDOI_PARAMS.g_request.calling_module =
1735: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1736: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1737: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1738: d_position := 20;

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

1732: -- check whether num of error lines exceeds the error
1733: -- threshold for the previous batch
1734: IF (PO_PDOI_PARAMS.g_request.calling_module =
1735: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1736: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1737: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1738: d_position := 20;
1739:
1740: IF (PO_LOG.d_stmt) THEN

Line 1742: PO_PDOI_PARAMS.g_request.interface_header_id);

1738: d_position := 20;
1739:
1740: IF (PO_LOG.d_stmt) THEN
1741: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
1742: PO_PDOI_PARAMS.g_request.interface_header_id);
1743: END IF;
1744:
1745: EXIT;
1746: END IF;

Line 1789: IF (PO_PDOI_PARAMS.g_request.document_type =

1785:
1786: -- check whether provided shipment_num is unqiue across interface,
1787: -- draft and txn tables.
1788: -- logic is performed for Standard PO only
1789: IF (PO_PDOI_PARAMS.g_request.document_type =
1790: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1791: PO_PDOI_MAINPROC_UTL_PVT.check_shipment_num_unique
1792: (
1793: p_po_line_id_tbl => l_line_locs.ln_po_line_id_tbl,

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

1853: -- remove the logic here, same logic is moved to PO_PDOI_LINE_LOC_PROCESS_PVT
1854: /*
1855: -- bug4662687 START
1856: -- Report the lines that have shipment/price break errors
1857: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(l_line_locs.intf_line_id_tbl(i))) THEN
1858: PO_PDOI_PARAMS.g_errored_lines(l_line_locs.intf_line_id_tbl(i)) := 'Y';
1859: PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines
1860: := PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines +1;
1861:

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

1854: /*
1855: -- bug4662687 START
1856: -- Report the lines that have shipment/price break errors
1857: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(l_line_locs.intf_line_id_tbl(i))) THEN
1858: PO_PDOI_PARAMS.g_errored_lines(l_line_locs.intf_line_id_tbl(i)) := 'Y';
1859: PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines
1860: := PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines +1;
1861:
1862: END IF;

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

1855: -- bug4662687 START
1856: -- Report the lines that have shipment/price break errors
1857: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(l_line_locs.intf_line_id_tbl(i))) THEN
1858: PO_PDOI_PARAMS.g_errored_lines(l_line_locs.intf_line_id_tbl(i)) := 'Y';
1859: PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines
1860: := PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines +1;
1861:
1862: END IF;
1863: -- bug4662687 END

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

1856: -- Report the lines that have shipment/price break errors
1857: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(l_line_locs.intf_line_id_tbl(i))) THEN
1858: PO_PDOI_PARAMS.g_errored_lines(l_line_locs.intf_line_id_tbl(i)) := 'Y';
1859: PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines
1860: := PO_PDOI_PARAMS.g_docs_info(l_line_locs.intf_header_id_tbl(i)).number_of_errored_lines +1;
1861:
1862: END IF;
1863: -- bug4662687 END
1864: */

Line 1937: IF (PO_PDOI_PARAMS.g_request.document_type =

1933: CLOSE l_line_locs_csr;
1934: END IF;
1935:
1936: -- line location post processing
1937: IF (PO_PDOI_PARAMS.g_request.document_type =
1938: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1939: d_position := 130;
1940:
1941: -- update amount or quantity value on po_lines_draft_all based

Line 1948: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

1944: (
1945: p_po_line_id_tbl => l_processed_line_id_tbl,
1946: p_draft_id_tbl => l_processed_draft_id_tbl
1947: );
1948: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
1949: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1950: d_position := 140;
1951:
1952: -- delete all existing price breaks for quotation update

Line 2251: IF (PO_PDOI_PARAMS.g_request.calling_module =

2247: END IF;
2248:
2249: -- Bug 5215781:
2250: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2251: IF (PO_PDOI_PARAMS.g_request.calling_module =
2252: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2253: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2254: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2255: IF (PO_LOG.d_stmt) THEN

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

2249: -- Bug 5215781:
2250: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2251: IF (PO_PDOI_PARAMS.g_request.calling_module =
2252: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2253: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2254: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2255: IF (PO_LOG.d_stmt) THEN
2256: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||
2257: ' error threshold is hit for header ',

Line 2258: PO_PDOI_PARAMS.g_request.interface_header_id);

2254: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2255: IF (PO_LOG.d_stmt) THEN
2256: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||
2257: ' error threshold is hit for header ',
2258: PO_PDOI_PARAMS.g_request.interface_header_id);
2259: END IF;
2260:
2261: RETURN;
2262: END IF;

Line 2282: IF (PO_PDOI_PARAMS.g_request.calling_module =

2278: LOOP
2279: -- Bug 5215781:
2280: -- check whether num of error lines exceeds the error
2281: -- threshold for the previous batch
2282: IF (PO_PDOI_PARAMS.g_request.calling_module =
2283: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2284: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2285: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2286: d_position := 20;

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

2280: -- check whether num of error lines exceeds the error
2281: -- threshold for the previous batch
2282: IF (PO_PDOI_PARAMS.g_request.calling_module =
2283: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2284: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2285: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2286: d_position := 20;
2287:
2288: IF (PO_LOG.d_stmt) THEN

Line 2290: PO_PDOI_PARAMS.g_request.interface_header_id);

2286: d_position := 20;
2287:
2288: IF (PO_LOG.d_stmt) THEN
2289: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2290: PO_PDOI_PARAMS.g_request.interface_header_id);
2291: END IF;
2292:
2293: EXIT;
2294: END IF;

Line 2459: IF (PO_PDOI_PARAMS.g_request.calling_module =

2455: END IF;
2456:
2457: -- Bug 5215781:
2458: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2459: IF (PO_PDOI_PARAMS.g_request.calling_module =
2460: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2461: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2462: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2463: IF (PO_LOG.d_stmt) THEN

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

2457: -- Bug 5215781:
2458: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2459: IF (PO_PDOI_PARAMS.g_request.calling_module =
2460: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2461: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2462: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2463: IF (PO_LOG.d_stmt) THEN
2464: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||
2465: ' error threshold is hit for header ',

Line 2466: PO_PDOI_PARAMS.g_request.interface_header_id);

2462: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2463: IF (PO_LOG.d_stmt) THEN
2464: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||
2465: ' error threshold is hit for header ',
2466: PO_PDOI_PARAMS.g_request.interface_header_id);
2467: END IF;
2468:
2469: RETURN;
2470: END IF;

Line 2953: IF (PO_PDOI_PARAMS.g_request.calling_module =

2949: -- fetch records from line interface table and process the records
2950: LOOP
2951: -- check whether num of error lines exceeds the error
2952: -- threshold for each batch
2953: IF (PO_PDOI_PARAMS.g_request.calling_module =
2954: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2955: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2956: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2957: IF (PO_LOG.d_stmt) THEN

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

2951: -- check whether num of error lines exceeds the error
2952: -- threshold for each batch
2953: IF (PO_PDOI_PARAMS.g_request.calling_module =
2954: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2955: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2956: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2957: IF (PO_LOG.d_stmt) THEN
2958: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2959: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 2959: PO_PDOI_PARAMS.g_request.interface_header_id);

2955: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2956: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2957: IF (PO_LOG.d_stmt) THEN
2958: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2959: PO_PDOI_PARAMS.g_request.interface_header_id);
2960: END IF;
2961:
2962: -- no need to process remaining lines if error threshold is reached
2963: EXIT;

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

3063: (
3064: x_lines => l_lines
3065: );
3066: --CLM PDOI Integration
3067: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
3068: THEN
3069: --Call the set_clm_structure api to set clin slin structure
3070: set_clm_structure;
3071: --Call the api to convert base_line_num from interface to draft

Line 3181: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id

3177: AND intf_lines.interface_header_id =
3178: intf_headers.interface_header_id
3179: AND intf_lines.line_num = draft_lines.line_num
3180: AND intf_headers.po_header_id = draft_lines.po_header_id
3181: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
3182: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
3183: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
3184: AND draft_lines.draft_id = intf_headers.draft_id;
3185: BEGIN

Line 3182: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

3178: intf_headers.interface_header_id
3179: AND intf_lines.line_num = draft_lines.line_num
3180: AND intf_headers.po_header_id = draft_lines.po_header_id
3181: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
3182: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
3183: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
3184: AND draft_lines.draft_id = intf_headers.draft_id;
3185: BEGIN
3186:

Line 3183: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

3179: AND intf_lines.line_num = draft_lines.line_num
3180: AND intf_headers.po_header_id = draft_lines.po_header_id
3181: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
3182: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
3183: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
3184: AND draft_lines.draft_id = intf_headers.draft_id;
3185: BEGIN
3186:
3187: IF (PO_LOG.d_proc) THEN

Line 3242: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

3238: SELECT clm_base_line_num,
3239: po_line_id
3240: BULK COLLECT INTO l_clm_base_line_num_tbl, l_po_line_id_tbl
3241: FROM po_lines_interface
3242: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
3243: AND Nvl(clm_option_indicator,'*') = 'O';
3244:
3245: d_position := 10;
3246: IF (PO_LOG.d_proc) THEN