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_PARAMS

Line 289: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id

285: AND intf_headers.draft_id = draft_lines.draft_id
286: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
287: AND draft_lines.draft_id = draft_headers.draft_id(+)
288: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
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)

Line 290: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

286: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
287: AND draft_lines.draft_id = draft_headers.draft_id(+)
288: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
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

Line 291: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

287: AND draft_lines.draft_id = draft_headers.draft_id(+)
288: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
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;

Line 575: IF (PO_PDOI_PARAMS.g_request.document_type =

571:
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,

Line 704: IF (PO_PDOI_PARAMS.g_request.document_type =

700: x_line_locs.error_flag_tbl(i) := FND_API.g_TRUE;
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

Line 798: IF (PO_PDOI_PARAMS.g_request.document_type =

794: x_num_list => l_index_tbl
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:

Line 809: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

805: p_key => l_key,
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:

Line 820: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

816: p_key => l_key,
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:

Line 964: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;

960:
961: l_parameter_name_tbl.EXTEND(5);
962: l_parameter_value_tbl.EXTEND(5);
963: l_parameter_name_tbl(1) := 'CREATE_OR_UPDATE_ITEM';
964: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;
965: l_parameter_name_tbl(2) := 'DOC_TYPE';
966: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_request.document_type;
967: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
968: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;

Line 966: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_request.document_type;

962: l_parameter_value_tbl.EXTEND(5);
963: l_parameter_name_tbl(1) := 'CREATE_OR_UPDATE_ITEM';
964: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;
965: l_parameter_name_tbl(2) := 'DOC_TYPE';
966: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_request.document_type;
967: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
968: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
969: l_parameter_name_tbl(4) := 'ALLOW_TAX_CODE_OVERRIDE';
970: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_profile.allow_tax_code_override;

Line 968: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;

964: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;
965: l_parameter_name_tbl(2) := 'DOC_TYPE';
966: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_request.document_type;
967: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
968: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
969: l_parameter_name_tbl(4) := 'ALLOW_TAX_CODE_OVERRIDE';
970: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_profile.allow_tax_code_override;
971: l_parameter_name_tbl(5) := 'INVENTORY_ORG_ID';
972: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416

Line 970: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_profile.allow_tax_code_override;

966: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_request.document_type;
967: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
968: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
969: l_parameter_name_tbl(4) := 'ALLOW_TAX_CODE_OVERRIDE';
970: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_profile.allow_tax_code_override;
971: l_parameter_name_tbl(5) := 'INVENTORY_ORG_ID';
972: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
973:
974: PO_VALIDATIONS.validate_pdoi

Line 972: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416

968: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
969: l_parameter_name_tbl(4) := 'ALLOW_TAX_CODE_OVERRIDE';
970: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_profile.allow_tax_code_override;
971: l_parameter_name_tbl(5) := 'INVENTORY_ORG_ID';
972: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
973:
974: PO_VALIDATIONS.validate_pdoi
975: (
976: p_line_locations => l_line_locations,

Line 977: p_doc_type => PO_PDOI_PARAMS.g_request.document_type,

973:
974: PO_VALIDATIONS.validate_pdoi
975: (
976: p_line_locations => l_line_locations,
977: p_doc_type => PO_PDOI_PARAMS.g_request.document_type,
978: p_parameter_name_tbl => l_parameter_name_tbl,
979: p_parameter_value_tbl => l_parameter_value_tbl,
980: x_result_type => l_result_type,
981: x_results => l_results

Line 1789: PO_PDOI_PARAMS.g_sys.inspection_required_flag);

1785: -- default inspection_required_flag from system if it cannot be
1786: -- be defaulted from item_id at the beginning of procedure
1787: x_line_locs.inspection_required_flag_tbl(i) :=
1788: NVL(x_line_locs.inspection_required_flag_tbl(i),
1789: PO_PDOI_PARAMS.g_sys.inspection_required_flag);
1790:
1791: -- default receipt_required_flag from system
1792: x_line_locs.receipt_required_flag_tbl(i) :=
1793: NVL(x_line_locs.receipt_required_flag_tbl(i),

Line 1794: PO_PDOI_PARAMS.g_sys.receiving_flag);

1790:
1791: -- default receipt_required_flag from system
1792: x_line_locs.receipt_required_flag_tbl(i) :=
1793: NVL(x_line_locs.receipt_required_flag_tbl(i),
1794: PO_PDOI_PARAMS.g_sys.receiving_flag);
1795:
1796: -- set tax_attribute_update_code to CREATE
1797: x_line_locs.tax_attribute_update_code_tbl(i) := 'CREATE';
1798:

Line 1831: PO_PDOI_PARAMS.g_sys.def_inv_org_id);

1827: -- default ship_to_organization_id from financial system parameter
1828: -- for STANDARD
1829: x_line_locs.ship_to_org_id_tbl(i) :=
1830: NVL(x_line_locs.ship_to_org_id_tbl(i),
1831: PO_PDOI_PARAMS.g_sys.def_inv_org_id);
1832:
1833: IF (PO_LOG.d_stmt) THEN
1834: PO_LOG.stmt(d_module, d_position, 'ship_to org id',
1835: x_line_locs.ship_to_org_id_tbl(i));

Line 2228: PO_PDOI_PARAMS.g_sys.inspection_required_flag);

2224:
2225: -- default inspection_required_flag from system
2226: x_line_locs.inspection_required_flag_tbl(i) :=
2227: NVL(x_line_locs.inspection_required_flag_tbl(i),
2228: PO_PDOI_PARAMS.g_sys.inspection_required_flag);
2229:
2230: -- default receipt_required_flag from system
2231: x_line_locs.receipt_required_flag_tbl(i) :=
2232: NVL(x_line_locs.receipt_required_flag_tbl(i),

Line 2233: PO_PDOI_PARAMS.g_sys.receiving_flag);

2229:
2230: -- default receipt_required_flag from system
2231: x_line_locs.receipt_required_flag_tbl(i) :=
2232: NVL(x_line_locs.receipt_required_flag_tbl(i),
2233: PO_PDOI_PARAMS.g_sys.receiving_flag);
2234:
2235: -- default allow_sub_receipts_flag, qty_rcv_tolerance, and
2236: -- qty_rcv_exception_code
2237: -- only call the rcv procedure when necessary

Line 2359: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

2355: FROM mtl_system_items
2356: WHERE p_item_id_tbl(i) IS NOT NULL
2357: AND x_inspection_required_flag_tbl(i) IS NULL
2358: AND inventory_item_id = p_item_id_tbl(i)
2359: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
2360:
2361: d_position := 10;
2362:
2363: -- get result from temp table

Line 2605: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

2601: WHERE p_item_id_tbl(i) IS NOT NULL
2602: AND (x_invoice_close_tolerance_tbl(i) IS NULL OR
2603: x_receive_close_tolerance_tbl(i) IS NULL)
2604: AND inventory_item_id = p_item_id_tbl(i)
2605: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
2606:
2607: d_position := 40;
2608:
2609: DELETE FROM po_session_gt

Line 2682: PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,

2678: END IF;
2679:
2680: x_invoice_close_tolerance_tbl(i) :=
2681: COALESCE(x_invoice_close_tolerance_tbl(i),
2682: PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
2683: 0);
2684: x_receive_close_tolerance_tbl(i) :=
2685: COALESCE(x_receive_close_tolerance_tbl(i),
2686: PO_PDOI_PARAMS.g_sys.receive_close_tolerance,

Line 2686: PO_PDOI_PARAMS.g_sys.receive_close_tolerance,

2682: PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
2683: 0);
2684: x_receive_close_tolerance_tbl(i) :=
2685: COALESCE(x_receive_close_tolerance_tbl(i),
2686: PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
2687: 0);
2688: END LOOP;
2689:
2690: IF (PO_LOG.d_proc) THEN

Line 2820: NVL(x_match_option_tbl(i), PO_PDOI_PARAMS.g_sys.invoice_match_option);

2816: PO_LOG.stmt(d_module, d_position, 'curr match option', x_match_option_tbl(i));
2817: END IF;
2818:
2819: x_match_option_tbl(i) :=
2820: NVL(x_match_option_tbl(i), PO_PDOI_PARAMS.g_sys.invoice_match_option);
2821: END LOOP;
2822:
2823: IF (PO_LOG.d_proc) THEN
2824: PO_LOG.proc_end (d_module);

Line 2938: PO_PDOI_PARAMS.g_product.inv_installed);

2934: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
2935: ELSIF (l_item_status = 'E') THEN
2936: IF (PO_LOG.d_stmt) THEN
2937: PO_LOG.stmt(d_module, d_position, 'INV installed',
2938: PO_PDOI_PARAMS.g_product.inv_installed);
2939: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
2940: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
2941: END IF;
2942:

Line 2940: PO_PDOI_PARAMS.g_sys.expense_accrual_code);

2936: IF (PO_LOG.d_stmt) THEN
2937: PO_LOG.stmt(d_module, d_position, 'INV installed',
2938: PO_PDOI_PARAMS.g_product.inv_installed);
2939: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
2940: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
2941: END IF;
2942:
2943: IF (PO_PDOI_PARAMS.g_product.inv_installed = FND_API.g_TRUE) then
2944: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';

Line 2943: IF (PO_PDOI_PARAMS.g_product.inv_installed = FND_API.g_TRUE) then

2939: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
2940: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
2941: END IF;
2942:
2943: IF (PO_PDOI_PARAMS.g_product.inv_installed = FND_API.g_TRUE) then
2944: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
2945: ELSE
2946: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') then
2947: x_accrue_on_receipt_flag_tbl(l_index) := 'N';

Line 2946: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') then

2942:
2943: IF (PO_PDOI_PARAMS.g_product.inv_installed = FND_API.g_TRUE) then
2944: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
2945: ELSE
2946: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') then
2947: x_accrue_on_receipt_flag_tbl(l_index) := 'N';
2948: ELSE
2949: x_accrue_on_receipt_flag_tbl(l_index) :=
2950: p_receipt_required_flag_tbl(l_index);

Line 2954: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') THEN

2950: p_receipt_required_flag_tbl(l_index);
2951: END IF;
2952: END IF;
2953: ELSE -- l_item_status := 'D'
2954: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') THEN
2955: x_accrue_on_receipt_flag_tbl(l_index) := 'N';
2956: ELSE
2957: x_accrue_on_receipt_flag_tbl(l_index) :=
2958: p_receipt_required_flag_tbl(l_index);

Line 3127: IF (PO_PDOI_PARAMS.g_request.calling_module =

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

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

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

Line 3138: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN

3134: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);
3135: END IF;
3136:
3137: -- collect intf_line_loc_ids to remove the errors from error intf table
3138: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN
3139: d_position := 30;
3140:
3141: l_remove_err_line_tbl.EXTEND;
3142: l_remove_err_line_loc_tbl.EXTEND;

Line 3160: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN

3156: -- price break level errors will be counted in line errors and threshold will be
3157: -- checked; If threshold is hit, reject all price break records that are processed
3158: -- after the current record and remove the errors from interface table for those
3159: -- records
3160: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN
3161: d_position := 50;
3162:
3163: IF (PO_LOG.d_stmt) THEN
3164: PO_LOG.stmt(d_module, d_position, 'set error on line',

Line 3169: PO_PDOI_PARAMS.g_errored_lines(x_line_locs.intf_line_id_tbl(l_index)) := 'Y';

3165: x_line_locs.intf_line_id_tbl(l_index));
3166: END IF;
3167:
3168: -- set corresponding line to ERROR
3169: PO_PDOI_PARAMS.g_errored_lines(x_line_locs.intf_line_id_tbl(l_index)) := 'Y';
3170:
3171: l_intf_header_id := x_line_locs.intf_header_id_tbl(l_index);
3172: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
3173: := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines +1;

Line 3172: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines

3168: -- set corresponding line to ERROR
3169: PO_PDOI_PARAMS.g_errored_lines(x_line_locs.intf_line_id_tbl(l_index)) := 'Y';
3170:
3171: l_intf_header_id := x_line_locs.intf_header_id_tbl(l_index);
3172: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
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 =

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

3169: PO_PDOI_PARAMS.g_errored_lines(x_line_locs.intf_line_id_tbl(l_index)) := 'Y';
3170:
3171: l_intf_header_id := x_line_locs.intf_header_id_tbl(l_index);
3172: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
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

Line 3176: IF (PO_PDOI_PARAMS.g_request.calling_module =

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

Line 3178: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines

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

Line 3179: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN

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',
3182: x_line_locs.intf_line_id_tbl(l_index));
3183: END IF;

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

3181: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',
3182: x_line_locs.intf_line_id_tbl(l_index));
3183: END IF;
3184:
3185: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;
3186:
3187: -- reject all rows after this row
3188: FOR j IN l_index+1..x_line_locs.rec_count LOOP
3189: x_line_locs.error_flag_tbl(j) := FND_API.g_TRUE;