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

Line 310: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

306: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id
307: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
308: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
309: AND intf_locs.interface_line_location_id > p_max_intf_line_loc_id
310: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
311: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
312: AND intf_headers.style_id = pdsh.style_id(+) -- Bug#16751944
313: ORDER BY 1;
314:

Line 311: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

307: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
308: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
309: AND intf_locs.interface_line_location_id > p_max_intf_line_loc_id
310: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
311: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
312: AND intf_headers.style_id = pdsh.style_id(+) -- Bug#16751944
313: ORDER BY 1;
314:
315: IF (PO_LOG.d_proc) THEN

Line 478: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

474: x_line_locs.hd_currency_code_tbl, -- Bug 9294987
475:
476: -- set initial value for error_flag
477: x_line_locs.error_flag_tbl
478: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
479:
480: IF (PO_LOG.d_proc) THEN
481: PO_LOG.proc_end (d_module);
482: END IF;

Line 543: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);

539: IF (PO_LOG.d_proc) THEN
540: PO_LOG.proc_begin(d_module, 'count', x_line_locs.rec_count);
541: END IF;
542:
543: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
544:
545: -- assign a new key
546: l_key := PO_CORE_S.get_session_gt_nextval;
547:

Line 616: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

612: d_position := 60;
613:
614: -- derive tax_name from tax_code_id
615: IF (PO_PDOI_PARAMS.g_request.document_type =
616: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
617: derive_tax_name
618: (
619: p_key => l_key,
620: p_index_tbl => l_index_tbl,

Line 745: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

741: END IF;
742:
743: -- check derivation error for tax_name
744: IF (PO_PDOI_PARAMS.g_request.document_type =
745: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
746: IF (x_line_locs.tax_code_id_tbl(i) IS NOT NULL AND
747: x_line_locs.tax_name_tbl(i) IS NULL) THEN
748: IF (PO_LOG.d_stmt) THEN
749: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');

Line 832: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);

828: END IF; --
829: END LOOP;
830: --< Shared Proc 14223789 End >
831:
832: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
833:
834: IF (PO_LOG.d_proc) THEN
835: PO_LOG.proc_end (d_module);
836: END IF;

Line 883: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);

879: IF (PO_LOG.d_proc) THEN
880: PO_LOG.proc_begin(d_module);
881: END IF;
882:
883: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
884:
885: -- pick a new key from temp table which will be used in all default logic
886: l_key := PO_CORE_S.get_session_gt_nextval;
887:

Line 897: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

893: );
894:
895: -- handle default logic based on document types
896: IF (PO_PDOI_PARAMS.g_request.document_type =
897: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
898:
899: d_position := 10;
900:
901: default_locs_for_spo

Line 908: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

904: p_index_tbl => l_index_tbl,
905: x_line_locs => x_line_locs
906: );
907: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
908: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
909:
910: d_position := 20;
911:
912: default_locs_for_blanket

Line 919: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

915: p_index_tbl => l_index_tbl,
916: x_line_locs => x_line_locs
917: );
918: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
919: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
920:
921: d_position := 30;
922:
923: default_locs_for_quotation

Line 947: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);

943: x_program_id_tbl => x_line_locs.program_id_tbl,
944: x_program_update_date_tbl => x_line_locs.program_update_date_tbl
945: );
946:
947: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
948:
949: IF (PO_LOG.d_proc) THEN
950: PO_LOG.proc_end (d_module);
951: END IF;

Line 1001: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);

997: IF (PO_LOG.d_proc) THEN
998: PO_LOG.proc_begin(d_module);
999: END IF;
1000:
1001: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
1002:
1003: l_line_locations.interface_id := x_line_locs.intf_line_loc_id_tbl;
1004: l_line_locations.purchase_basis := x_line_locs.ln_purchase_basis_tbl;
1005: l_line_locations.need_by_date := x_line_locs.need_by_date_tbl;

Line 1119: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);

1115:
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;
1118:
1119: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
1120:
1121: IF (PO_LOG.d_proc) THEN
1122: PO_LOG.proc_end (d_module);
1123: END IF;

Line 1180: process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED

1176: -- update line_location_interface table with the new line_location_id
1177: FORALL i IN 1..p_intf_line_loc_id_tbl.COUNT
1178: UPDATE po_line_locations_interface
1179: SET line_location_id = p_line_loc_id_tbl(i),
1180: process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
1181: WHERE interface_line_location_id = p_intf_line_loc_id_tbl(i)
1182: AND p_error_flag_tbl(i) = FND_API.g_FALSE;
1183:
1184: IF (PO_LOG.d_proc) THEN

Line 1886: x_line_locs.ln_action_tbl(i) <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN

1882:
1883: -- default price_override
1884: IF (x_line_locs.price_override_tbl(i) IS NULL AND
1885: x_line_locs.ln_order_type_lookup_code_tbl(i) <> 'FIXED PRICE' AND
1886: x_line_locs.ln_action_tbl(i) <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN
1887: x_line_locs.price_override_tbl(i) := x_line_locs.ln_unit_price_tbl(i);
1888: END IF;
1889:
1890: -- default ship_to_location_id from header level

Line 3346: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

3342: -- Bug 5215781:
3343: -- set error_flag to TRUE for all remaining records if error threshold is
3344: -- hit for CATALOG UPLOAD
3345: IF (PO_PDOI_PARAMS.g_request.calling_module =
3346: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
3347: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
3348: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
3349: d_position := 20;
3350:

Line 3395: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

3391: := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines +1;
3392:
3393: -- check threshold
3394: IF (PO_PDOI_PARAMS.g_request.calling_module =
3395: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
3396: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
3397: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN
3398: IF (PO_LOG.d_stmt) THEN
3399: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',