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_PARAMS

Line 99: AND intf_price_diffs.processing_id = PO_PDOI_PARAMS.g_processing_id

95: AND intf_headers.draft_id = draft_headers.draft_id(+)
96: AND intf_headers.po_header_id = txn_headers.po_header_id(+)
97: AND draft_lines.order_type_lookup_code = 'RATE'
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

Line 100: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

96: AND intf_headers.po_header_id = txn_headers.po_header_id(+)
97: AND draft_lines.order_type_lookup_code = 'RATE'
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;

Line 244: PO_PDOI_PARAMS.g_request.document_type =

240:
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 =

Line 248: IF (PO_PDOI_PARAMS.g_request.document_type =

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
250: x_price_diffs.entity_type_tbl(i) := 'BLANKET LINE';
251: ELSE
252: x_price_diffs.entity_type_tbl(i) := 'PO LINE';

Line 377: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.document_type;

373:
374: l_parameter_name_tbl.EXTEND(1);
375: l_parameter_value_tbl.EXTEND(1);
376: l_parameter_name_tbl(1) := 'DOC_TYPE';
377: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.document_type;
378:
379: PO_VALIDATIONS.validate_pdoi(p_price_differentials => l_price_differentials,
380: p_parameter_name_tbl => l_parameter_name_tbl,
381: p_parameter_value_tbl => l_parameter_value_tbl,

Line 488: IF (PO_PDOI_PARAMS.g_request.calling_module =

484:
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;

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

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:
494: IF (PO_LOG.d_stmt) THEN

Line 499: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_price_diffs.intf_line_id_tbl(l_index))) THEN

495: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);
496: END IF;
497:
498: -- collect price_diff_interface_ids to remove the errors from error intf table
499: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_price_diffs.intf_line_id_tbl(l_index))) THEN
500: d_position := 30;
501:
502: l_remove_err_line_tbl.EXTEND;
503: l_remove_err_price_diff_tbl.EXTEND;

Line 521: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_price_diffs.intf_line_id_tbl(l_index))) THEN

517: -- price diff level errors will be counted in line errors and threshold will be
518: -- checked; If threshold is hit, reject all price diff records that are processed
519: -- after the current record and remove the errors from interface table for those
520: -- records
521: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_price_diffs.intf_line_id_tbl(l_index))) THEN
522: d_position := 50;
523:
524: IF (PO_LOG.d_stmt) THEN
525: PO_LOG.stmt(d_module, d_position, 'set error on line',

Line 530: PO_PDOI_PARAMS.g_errored_lines(x_price_diffs.intf_line_id_tbl(l_index)) := 'Y';

526: x_price_diffs.intf_line_id_tbl(l_index));
527: END IF;
528:
529: -- set corresponding line to ERROR
530: PO_PDOI_PARAMS.g_errored_lines(x_price_diffs.intf_line_id_tbl(l_index)) := 'Y';
531:
532: l_intf_header_id := x_price_diffs.intf_header_id_tbl(l_index);
533: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
534: := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines +1;

Line 533: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines

529: -- set corresponding line to ERROR
530: PO_PDOI_PARAMS.g_errored_lines(x_price_diffs.intf_line_id_tbl(l_index)) := 'Y';
531:
532: l_intf_header_id := x_price_diffs.intf_header_id_tbl(l_index);
533: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
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 =

Line 534: := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines +1;

530: PO_PDOI_PARAMS.g_errored_lines(x_price_diffs.intf_line_id_tbl(l_index)) := 'Y';
531:
532: l_intf_header_id := x_price_diffs.intf_header_id_tbl(l_index);
533: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
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

Line 537: IF (PO_PDOI_PARAMS.g_request.calling_module =

533: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
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

Line 539: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines

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',
543: x_price_diffs.intf_line_id_tbl(l_index));

Line 540: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN

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',
543: x_price_diffs.intf_line_id_tbl(l_index));
544: END IF;

Line 546: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;

542: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',
543: x_price_diffs.intf_line_id_tbl(l_index));
544: END IF;
545:
546: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;
547:
548: -- reject all rows after this row
549: FOR j IN l_index+1..x_price_diffs.rec_count LOOP
550: x_price_diffs.error_flag_tbl(j) := FND_API.g_TRUE;