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 306: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id

302: AND intf_headers.draft_id = draft_lines.draft_id
303: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
304: AND draft_lines.draft_id = draft_headers.draft_id(+)
305: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
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)

Line 307: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

303: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
304: AND draft_lines.draft_id = draft_headers.draft_id(+)
305: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
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

Line 308: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

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

Line 615: IF (PO_PDOI_PARAMS.g_request.document_type =

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

Line 744: IF (PO_PDOI_PARAMS.g_request.document_type =

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

Line 896: IF (PO_PDOI_PARAMS.g_request.document_type =

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

Line 907: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

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

Line 918: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

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

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

1063:
1064: l_parameter_name_tbl.EXTEND(5);
1065: l_parameter_value_tbl.EXTEND(5);
1066: l_parameter_name_tbl(1) := 'CREATE_OR_UPDATE_ITEM';
1067: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;
1068: l_parameter_name_tbl(2) := 'DOC_TYPE';
1069: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_request.document_type;
1070: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
1071: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;

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

1065: l_parameter_value_tbl.EXTEND(5);
1066: l_parameter_name_tbl(1) := 'CREATE_OR_UPDATE_ITEM';
1067: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;
1068: l_parameter_name_tbl(2) := 'DOC_TYPE';
1069: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_request.document_type;
1070: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
1071: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
1072: l_parameter_name_tbl(4) := 'ALLOW_TAX_CODE_OVERRIDE';
1073: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_profile.allow_tax_code_override;

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

1067: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_request.create_items;
1068: l_parameter_name_tbl(2) := 'DOC_TYPE';
1069: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_request.document_type;
1070: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
1071: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
1072: l_parameter_name_tbl(4) := 'ALLOW_TAX_CODE_OVERRIDE';
1073: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_profile.allow_tax_code_override;
1074: l_parameter_name_tbl(5) := 'INVENTORY_ORG_ID';
1075: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416

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

1069: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_request.document_type;
1070: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
1071: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
1072: l_parameter_name_tbl(4) := 'ALLOW_TAX_CODE_OVERRIDE';
1073: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_profile.allow_tax_code_override;
1074: l_parameter_name_tbl(5) := 'INVENTORY_ORG_ID';
1075: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
1076:
1077: PO_VALIDATIONS.validate_pdoi

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

1071: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
1072: l_parameter_name_tbl(4) := 'ALLOW_TAX_CODE_OVERRIDE';
1073: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_profile.allow_tax_code_override;
1074: l_parameter_name_tbl(5) := 'INVENTORY_ORG_ID';
1075: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
1076:
1077: PO_VALIDATIONS.validate_pdoi
1078: (
1079: p_line_locations => l_line_locations,

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

1076:
1077: PO_VALIDATIONS.validate_pdoi
1078: (
1079: p_line_locations => l_line_locations,
1080: p_doc_type => PO_PDOI_PARAMS.g_request.document_type,
1081: p_parameter_name_tbl => l_parameter_name_tbl,
1082: p_parameter_value_tbl => l_parameter_value_tbl,
1083: x_result_type => l_result_type,
1084: x_results => l_results

Line 1923: PO_PDOI_PARAMS.g_sys.inspection_required_flag));

1919: -- default inspection_required_flag from system if it cannot be
1920: -- be defaulted from item_id at the beginning of procedure
1921: x_line_locs.inspection_required_flag_tbl(i) :=
1922: NVL(x_line_locs.inspection_required_flag_tbl(i), NVL(l_insp_req_flag_temp,
1923: PO_PDOI_PARAMS.g_sys.inspection_required_flag));
1924:
1925: -- default receipt_required_flag from system
1926: x_line_locs.receipt_required_flag_tbl(i) :=
1927: NVL(x_line_locs.receipt_required_flag_tbl(i),NVL(l_receipt_req_flag_temp,

Line 1928: PO_PDOI_PARAMS.g_sys.receiving_flag));

1924:
1925: -- default receipt_required_flag from system
1926: x_line_locs.receipt_required_flag_tbl(i) :=
1927: NVL(x_line_locs.receipt_required_flag_tbl(i),NVL(l_receipt_req_flag_temp,
1928: PO_PDOI_PARAMS.g_sys.receiving_flag));
1929:
1930: -- set tax_attribute_update_code to CREATE
1931: x_line_locs.tax_attribute_update_code_tbl(i) := 'CREATE';
1932:

Line 1975: PO_PDOI_PARAMS.g_sys.def_inv_org_id);

1971: -- default ship_to_organization_id from financial system parameter
1972: -- for STANDARD
1973: x_line_locs.ship_to_org_id_tbl(i) :=
1974: NVL(x_line_locs.ship_to_org_id_tbl(i),
1975: PO_PDOI_PARAMS.g_sys.def_inv_org_id);
1976:
1977: IF (PO_LOG.d_stmt) THEN
1978: PO_LOG.stmt(d_module, d_position, 'ship_to org id',
1979: x_line_locs.ship_to_org_id_tbl(i));

Line 2407: PO_PDOI_PARAMS.g_sys.inspection_required_flag));

2403:
2404: -- default inspection_required_flag from system
2405: x_line_locs.inspection_required_flag_tbl(i) :=
2406: NVL(x_line_locs.inspection_required_flag_tbl(i), NVL(l_insp_req_flag_temp,
2407: PO_PDOI_PARAMS.g_sys.inspection_required_flag));
2408:
2409: -- default receipt_required_flag from system
2410: x_line_locs.receipt_required_flag_tbl(i) :=
2411: NVL(x_line_locs.receipt_required_flag_tbl(i),NVL(l_receipt_req_flag_temp,

Line 2412: PO_PDOI_PARAMS.g_sys.receiving_flag));

2408:
2409: -- default receipt_required_flag from system
2410: x_line_locs.receipt_required_flag_tbl(i) :=
2411: NVL(x_line_locs.receipt_required_flag_tbl(i),NVL(l_receipt_req_flag_temp,
2412: PO_PDOI_PARAMS.g_sys.receiving_flag));
2413:
2414:
2415: /* Added for price discount to work as part of 9039292 bug */
2416: IF ( x_line_locs.ln_unit_price_tbl(i) <> 0 ) THEN

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

2546: FROM mtl_system_items
2547: WHERE p_item_id_tbl(i) IS NOT NULL
2548: AND x_inspection_required_flag_tbl(i) IS NULL
2549: AND inventory_item_id = p_item_id_tbl(i)
2550: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
2551:
2552: d_position := 10;
2553:
2554: -- get result from temp table

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

2792: WHERE p_item_id_tbl(i) IS NOT NULL
2793: AND (x_invoice_close_tolerance_tbl(i) IS NULL OR
2794: x_receive_close_tolerance_tbl(i) IS NULL)
2795: AND inventory_item_id = p_item_id_tbl(i)
2796: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
2797:
2798: d_position := 40;
2799:
2800: DELETE FROM po_session_gt

Line 2873: PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,

2869: END IF;
2870:
2871: x_invoice_close_tolerance_tbl(i) :=
2872: COALESCE(x_invoice_close_tolerance_tbl(i),
2873: PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
2874: 0);
2875: x_receive_close_tolerance_tbl(i) :=
2876: COALESCE(x_receive_close_tolerance_tbl(i),
2877: PO_PDOI_PARAMS.g_sys.receive_close_tolerance,

Line 2877: PO_PDOI_PARAMS.g_sys.receive_close_tolerance,

2873: PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
2874: 0);
2875: x_receive_close_tolerance_tbl(i) :=
2876: COALESCE(x_receive_close_tolerance_tbl(i),
2877: PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
2878: 0);
2879: END LOOP;
2880:
2881: IF (PO_LOG.d_proc) THEN

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

3007: PO_LOG.stmt(d_module, d_position, 'curr match option', x_match_option_tbl(i));
3008: END IF;
3009:
3010: x_match_option_tbl(i) :=
3011: NVL(x_match_option_tbl(i), PO_PDOI_PARAMS.g_sys.invoice_match_option);
3012: END LOOP;
3013:
3014: IF (PO_LOG.d_proc) THEN
3015: PO_LOG.proc_end (d_module);

Line 3129: PO_PDOI_PARAMS.g_product.inv_installed);

3125: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
3126: ELSIF (l_item_status = 'E') THEN
3127: IF (PO_LOG.d_stmt) THEN
3128: PO_LOG.stmt(d_module, d_position, 'INV installed',
3129: PO_PDOI_PARAMS.g_product.inv_installed);
3130: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
3131: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
3132: END IF;
3133:

Line 3131: PO_PDOI_PARAMS.g_sys.expense_accrual_code);

3127: IF (PO_LOG.d_stmt) THEN
3128: PO_LOG.stmt(d_module, d_position, 'INV installed',
3129: PO_PDOI_PARAMS.g_product.inv_installed);
3130: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
3131: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
3132: END IF;
3133:
3134: IF (PO_PDOI_PARAMS.g_product.inv_installed = FND_API.g_TRUE) then
3135: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';

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

3130: PO_LOG.stmt(d_module, d_position, 'default expense accrual code',
3131: PO_PDOI_PARAMS.g_sys.expense_accrual_code);
3132: END IF;
3133:
3134: IF (PO_PDOI_PARAMS.g_product.inv_installed = FND_API.g_TRUE) then
3135: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
3136: ELSE
3137: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') then
3138: x_accrue_on_receipt_flag_tbl(l_index) := 'N';

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

3133:
3134: IF (PO_PDOI_PARAMS.g_product.inv_installed = FND_API.g_TRUE) then
3135: x_accrue_on_receipt_flag_tbl(l_index) := 'Y';
3136: ELSE
3137: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') then
3138: x_accrue_on_receipt_flag_tbl(l_index) := 'N';
3139: ELSE
3140: x_accrue_on_receipt_flag_tbl(l_index) :=
3141: p_receipt_required_flag_tbl(l_index);

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

3141: p_receipt_required_flag_tbl(l_index);
3142: END IF;
3143: END IF;
3144: ELSE -- l_item_status := 'D'
3145: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') THEN
3146: x_accrue_on_receipt_flag_tbl(l_index) := 'N';
3147: ELSE
3148: x_accrue_on_receipt_flag_tbl(l_index) :=
3149: p_receipt_required_flag_tbl(l_index);

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

3166: PO_LOG.stmt(d_module, d_position, 'l_item_status = ', l_item_status );
3167: END IF;
3168:
3169: -- set default value
3170: IF (PO_PDOI_PARAMS.g_sys.expense_accrual_code = 'PERIOD END') THEN
3171: x_accrue_on_receipt_flag_tbl(l_index) := 'N';
3172: ELSE
3173: x_accrue_on_receipt_flag_tbl(l_index) :=
3174: NVL(p_receipt_required_flag_tbl(l_index),'N');

Line 3345: IF (PO_PDOI_PARAMS.g_request.calling_module =

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

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

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

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

3352: PO_LOG.stmt(d_module, d_position, 'after error tolerance exceeded, collect error on index', l_index);
3353: END IF;
3354:
3355: -- collect intf_line_loc_ids to remove the errors from error intf table
3356: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN
3357: d_position := 30;
3358:
3359: l_remove_err_line_tbl.EXTEND;
3360: l_remove_err_line_loc_tbl.EXTEND;

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

3374: -- price break level errors will be counted in line errors and threshold will be
3375: -- checked; If threshold is hit, reject all price break records that are processed
3376: -- after the current record and remove the errors from interface table for those
3377: -- records
3378: IF (NOT PO_PDOI_PARAMS.g_errored_lines.EXISTS(x_line_locs.intf_line_id_tbl(l_index))) THEN
3379: d_position := 50;
3380:
3381: IF (PO_LOG.d_stmt) THEN
3382: PO_LOG.stmt(d_module, d_position, 'set error on line',

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

3383: x_line_locs.intf_line_id_tbl(l_index));
3384: END IF;
3385:
3386: -- set corresponding line to ERROR
3387: PO_PDOI_PARAMS.g_errored_lines(x_line_locs.intf_line_id_tbl(l_index)) := 'Y';
3388:
3389: l_intf_header_id := x_line_locs.intf_header_id_tbl(l_index);
3390: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
3391: := PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines +1;

Line 3390: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines

3386: -- set corresponding line to ERROR
3387: PO_PDOI_PARAMS.g_errored_lines(x_line_locs.intf_line_id_tbl(l_index)) := 'Y';
3388:
3389: l_intf_header_id := x_line_locs.intf_header_id_tbl(l_index);
3390: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
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 =

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

3387: PO_PDOI_PARAMS.g_errored_lines(x_line_locs.intf_line_id_tbl(l_index)) := 'Y';
3388:
3389: l_intf_header_id := x_line_locs.intf_header_id_tbl(l_index);
3390: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines
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

Line 3394: IF (PO_PDOI_PARAMS.g_request.calling_module =

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

Line 3396: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).number_of_errored_lines

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

Line 3397: = PO_PDOI_PARAMS.g_request.err_lines_tolerance) THEN

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

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

3399: PO_LOG.stmt(d_module, d_position, 'threshold hit on line',
3400: x_line_locs.intf_line_id_tbl(l_index));
3401: END IF;
3402:
3403: PO_PDOI_PARAMS.g_docs_info(l_intf_header_id).err_tolerance_exceeded := FND_API.g_TRUE;
3404:
3405: -- reject all rows after this row
3406: FOR j IN l_index+1..x_line_locs.rec_count LOOP
3407: x_line_locs.error_flag_tbl(j) := FND_API.g_TRUE;