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

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

98: AND intf_price_diffs.interface_line_location_id = intf_locs.interface_line_location_id(+)
99: AND intf_price_diffs.processing_id = PO_PDOI_PARAMS.g_processing_id
100: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
101: AND intf_price_diffs.price_diff_interface_id > p_max_intf_price_diff_id
102: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
103: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
104: ORDER BY intf_price_diffs.price_diff_interface_id;
105:
106: IF (PO_LOG.d_proc) THEN

Line 103: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED

99: AND intf_price_diffs.processing_id = PO_PDOI_PARAMS.g_processing_id
100: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
101: AND intf_price_diffs.price_diff_interface_id > p_max_intf_price_diff_id
102: AND NVL(intf_lines.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
103: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
104: ORDER BY intf_price_diffs.price_diff_interface_id;
105:
106: IF (PO_LOG.d_proc) THEN
107: PO_LOG.proc_end (d_module);

Line 176: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;

172: x_price_diffs.hd_style_id_tbl,
173:
174: -- set initial value for error_flag
175: x_price_diffs.error_flag_tbl
176: LIMIT PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE;
177:
178: IF (PO_LOG.d_proc) THEN
179: PO_LOG.proc_end (d_module);
180: END IF;

Line 221: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_DEFAULT);

217: IF (PO_LOG.d_proc) THEN
218: PO_LOG.proc_begin(d_module);
219: END IF;
220:
221: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_DEFAULT);
222:
223: d_position := 10;
224:
225: FOR i IN 1..x_price_diffs.rec_count

Line 245: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

241: -- default entity_type
242: IF (x_price_diffs.entity_type_tbl(i) IS NULL) THEN
243: IF (x_price_diffs.loc_line_loc_id_tbl(i) IS NOT NULL AND
244: PO_PDOI_PARAMS.g_request.document_type =
245: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
246: x_price_diffs.entity_type_tbl(i) := 'PRICE BREAK';
247: ELSE
248: IF (PO_PDOI_PARAMS.g_request.document_type =
249: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

Line 249: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

245: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
246: x_price_diffs.entity_type_tbl(i) := 'PRICE BREAK';
247: ELSE
248: IF (PO_PDOI_PARAMS.g_request.document_type =
249: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
250: x_price_diffs.entity_type_tbl(i) := 'BLANKET LINE';
251: ELSE
252: x_price_diffs.entity_type_tbl(i) := 'PO LINE';
253: END IF;

Line 306: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_DEFAULT);

302: );
303: END IF;
304: END LOOP;
305:
306: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_DEFAULT);
307:
308: IF (PO_LOG.d_proc) THEN
309: PO_LOG.proc_end (d_module);
310: END IF;

Line 361: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_VALIDATE);

357: IF (PO_LOG.d_proc) THEN
358: PO_LOG.proc_begin(d_module);
359: END IF;
360:
361: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_VALIDATE);
362:
363: l_price_differentials.interface_id := x_price_diffs.intf_price_diff_id_tbl;
364: l_price_differentials.price_type := x_price_diffs.price_type_tbl;
365: l_price_differentials.entity_type := x_price_diffs.entity_type_tbl;

Line 416: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_VALIDATE);

412:
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;
415:
416: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_VALIDATE);
417:
418: IF (PO_LOG.d_proc) THEN
419: PO_LOG.proc_end (d_module);
420: END IF;

Line 489: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

485: -- Bug 5215781:
486: -- set error_flag to TRUE for all remaining records if error threshold is
487: -- hit for CATALOG UPLOAD
488: IF (PO_PDOI_PARAMS.g_request.calling_module =
489: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
490: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
491: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
492: d_position := 20;
493:

Line 538: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND

534: := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines +1;
535:
536: -- check threshold
537: IF (PO_PDOI_PARAMS.g_request.calling_module =
538: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD AND
539: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
540: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN
541: IF (PO_LOG.d_stmt) THEN
542: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',