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 293: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

289: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id
290: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
291: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
292: AND intf_locs.interface_line_location_id > p_max_intf_line_loc_id
293: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
294: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
295: ORDER BY 1;
296:
297: IF (PO_LOG.d_proc) THEN

Line 294: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

290: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
291: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
292: AND intf_locs.interface_line_location_id > p_max_intf_line_loc_id
293: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
294: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
295: ORDER BY 1;
296:
297: IF (PO_LOG.d_proc) THEN
298: PO_LOG.proc_end (d_module);

Line 446: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

442: x_line_locs.hd_style_id_tbl,
443:
444: -- set initial value for error_flag
445: x_line_locs.error_flag_tbl
446: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
447:
448: IF (PO_LOG.d_proc) THEN
449: PO_LOG.proc_end (d_module);
450: END IF;

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

499: IF (PO_LOG.d_proc) THEN
500: PO_LOG.proc_begin(d_module, 'count', x_line_locs.rec_count);
501: END IF;
502:
503: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
504:
505: -- assign a new key
506: l_key := PO_CORE_S.get_session_gt_nextval;
507:

Line 576: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

572: d_position := 60;
573:
574: -- derive tax_name from tax_code_id
575: IF (PO_PDOI_PARAMS.g_request.document_type =
576: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
577: derive_tax_name
578: (
579: p_key => l_key,
580: p_index_tbl => l_index_tbl,

Line 705: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

701: END IF;
702:
703: -- check derivation error for tax_name
704: IF (PO_PDOI_PARAMS.g_request.document_type =
705: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
706: IF (x_line_locs.tax_code_id_tbl(i) IS NOT NULL AND
707: x_line_locs.tax_name_tbl(i) IS NULL) THEN
708: IF (PO_LOG.d_stmt) THEN
709: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');

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

730: END IF;
731: END IF;
732: END LOOP;
733:
734: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
735:
736: IF (PO_LOG.d_proc) THEN
737: PO_LOG.proc_end (d_module);
738: END IF;

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

781: IF (PO_LOG.d_proc) THEN
782: PO_LOG.proc_begin(d_module);
783: END IF;
784:
785: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
786:
787: -- pick a new key from temp table which will be used in all default logic
788: l_key := PO_CORE_S.get_session_gt_nextval;
789:

Line 799: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

795: );
796:
797: -- handle default logic based on document types
798: IF (PO_PDOI_PARAMS.g_request.document_type =
799: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
800:
801: d_position := 10;
802:
803: default_locs_for_spo

Line 810: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

806: p_index_tbl => l_index_tbl,
807: x_line_locs => x_line_locs
808: );
809: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
810: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
811:
812: d_position := 20;
813:
814: default_locs_for_blanket

Line 821: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

817: p_index_tbl => l_index_tbl,
818: x_line_locs => x_line_locs
819: );
820: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
821: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
822:
823: d_position := 30;
824:
825: default_locs_for_quotation

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

845: x_program_id_tbl => x_line_locs.program_id_tbl,
846: x_program_update_date_tbl => x_line_locs.program_update_date_tbl
847: );
848:
849: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DEFAULT);
850:
851: IF (PO_LOG.d_proc) THEN
852: PO_LOG.proc_end (d_module);
853: END IF;

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

899: IF (PO_LOG.d_proc) THEN
900: PO_LOG.proc_begin(d_module);
901: END IF;
902:
903: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
904:
905: l_line_locations.interface_id := x_line_locs.intf_line_loc_id_tbl;
906: l_line_locations.purchase_basis := x_line_locs.ln_purchase_basis_tbl;
907: l_line_locations.need_by_date := x_line_locs.need_by_date_tbl;

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

1012:
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: END IF;
1015:
1016: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_VALIDATE);
1017:
1018: IF (PO_LOG.d_proc) THEN
1019: PO_LOG.proc_end (d_module);
1020: END IF;

Line 1077: process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED

1073: -- update line_location_interface table with the new line_location_id
1074: FORALL i IN 1..p_intf_line_loc_id_tbl.COUNT
1075: UPDATE po_line_locations_interface
1076: SET line_location_id = p_line_loc_id_tbl(i),
1077: process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
1078: WHERE interface_line_location_id = p_intf_line_loc_id_tbl(i)
1079: AND p_error_flag_tbl(i) = FND_API.g_FALSE;
1080:
1081: IF (PO_LOG.d_proc) THEN

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

1771:
1772: -- default price_override
1773: IF (x_line_locs.price_override_tbl(i) IS NULL AND
1774: x_line_locs.ln_order_type_lookup_code_tbl(i) <> 'FIXED PRICE' AND
1775: x_line_locs.ln_action_tbl(i) <> PO_PDOI_CONSTANTS.g_ACTION_UPDATE) THEN
1776: x_line_locs.price_override_tbl(i) := x_line_locs.ln_unit_price_tbl(i);
1777: END IF;
1778:
1779: -- default ship_to_location_id from header level

Line 3128: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

3124: -- Bug 5215781:
3125: -- set error_flag to TRUE for all remaining records if error threshold is
3126: -- hit for CATALOG UPLOAD
3127: IF (PO_PDOI_PARAMS.g_request.calling_module =
3128: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
3129: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
3130: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
3131: d_position := 20;
3132:

Line 3177: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

3173: := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines +1;
3174:
3175: -- check threshold
3176: IF (PO_PDOI_PARAMS.g_request.calling_module =
3177: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
3178: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
3179: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN
3180: IF (PO_LOG.d_stmt) THEN
3181: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',