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_VALIDATIONS dependencies on STANDARD

Line 83: c_doc_type_standard CONSTANT VARCHAR2(30) := 'STANDARD';

79: c_parameter_YES CONSTANT VARCHAR2(1) := PO_CORE_S.g_parameter_YES;
80: c_parameter_NO CONSTANT VARCHAR2(1) := PO_CORE_S.g_parameter_NO;
81:
82: c_doc_type_blanket CONSTANT VARCHAR2(30) := 'BLANKET';
83: c_doc_type_standard CONSTANT VARCHAR2(30) := 'STANDARD';
84: c_doc_type_quotation CONSTANT VARCHAR2(30) := 'QUOTATION';
85:
86:
87: /**

Line 151: c_validate_clm_standard_form CONSTANT VARCHAR2(30) := 'C_VALIDATE_CLM_STANDARD_FORM';

147: c_min_guar_perc_range_check CONSTANT VARCHAR2(30) := 'C_MIN_GUAR_PERC_RANGE_CHECK';
148: c_print_form_format_valid CONSTANT VARCHAR2(30) := 'C_PRINT_FORM_FORMAT_VALID';
149:
150: --CLM PDOI Integration
151: c_validate_clm_standard_form CONSTANT VARCHAR2(30) := 'C_VALIDATE_CLM_STANDARD_FORM';
152: c_validate_clm_document_format CONSTANT VARCHAR2(30) := 'C_VALIDATE_CLM_DOCUMENT_FORMAT';
153: c_validate_source_idv CONSTANT VARCHAR2(30) := 'C_VALIDATE_SOURCE_IDV';
154: c_validate_award_admin CONSTANT VARCHAR2(30) := 'C_VALIDATE_AWARD_ADMIN';
155: c_validate_contract_officer CONSTANT VARCHAR2(30) := 'C_CLM_CONTRACT_OFFICER';

Line 311: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';

307: c_line_num CONSTANT VARCHAR2(30) := 'C_LINE_NUM';
308: c_po_line_id CONSTANT VARCHAR2(30) := 'C_PO_LINE_ID';
309: c_line_type_id CONSTANT VARCHAR2(30) := 'C_LINE_TYPE_ID';
310: c_price_type_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_TYPE_LOOKUP_CODE';
311: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';
312: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';
313: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';
314: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';
315: c_price_break_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_BREAK_LOOKUP_CODE';

Line 312: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';

308: c_po_line_id CONSTANT VARCHAR2(30) := 'C_PO_LINE_ID';
309: c_line_type_id CONSTANT VARCHAR2(30) := 'C_LINE_TYPE_ID';
310: c_price_type_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_TYPE_LOOKUP_CODE';
311: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';
312: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';
313: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';
314: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';
315: c_price_break_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_BREAK_LOOKUP_CODE';
316: c_not_to_exceed_price CONSTANT VARCHAR2(30) := 'C_NOT_TO_EXCEED_PRICE';

Line 313: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';

309: c_line_type_id CONSTANT VARCHAR2(30) := 'C_LINE_TYPE_ID';
310: c_price_type_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_TYPE_LOOKUP_CODE';
311: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';
312: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';
313: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';
314: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';
315: c_price_break_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_BREAK_LOOKUP_CODE';
316: c_not_to_exceed_price CONSTANT VARCHAR2(30) := 'C_NOT_TO_EXCEED_PRICE';
317: c_release_num_null CONSTANT VARCHAR2(30) := 'C_RELEASE_NUM_NULL';

Line 314: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';

310: c_price_type_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_TYPE_LOOKUP_CODE';
311: c_start_date_standard CONSTANT VARCHAR2(30) := 'C_START_DATE_STANDARD';
312: c_item_id_standard CONSTANT VARCHAR2(30) := 'C_ITEM_ID_STANDARD';
313: c_quantity_standard CONSTANT VARCHAR2(30) := 'C_QUANTITY_STANDARD';
314: c_amount_standard CONSTANT VARCHAR2(30) := 'C_AMOUNT_STANDARD';
315: c_price_break_lookup_code CONSTANT VARCHAR2(30) := 'C_PRICE_BREAK_LOOKUP_CODE';
316: c_not_to_exceed_price CONSTANT VARCHAR2(30) := 'C_NOT_TO_EXCEED_PRICE';
317: c_release_num_null CONSTANT VARCHAR2(30) := 'C_RELEASE_NUM_NULL';
318: c_po_release_id_null CONSTANT VARCHAR2(30) := 'C_PO_RELEASE_ID_NULL';

Line 407: c_shipment_type_standard CONSTANT VARCHAR2(30) := 'C_SHIPMENT_TYPE_STANDARD';

403: ------------------------------------------------------------------
404: c_shipment_need_by_date CONSTANT VARCHAR2(30) := 'C_SHIPMENT_NEED_BY_DATE';
405: c_shipment_promised_date CONSTANT VARCHAR2(30) := 'C_SHIPMENT_PROMISED_DATE';
406: c_shipment_type_blanket CONSTANT VARCHAR2(30) := 'C_SHIPMENT_TYPE_BLANKET';
407: c_shipment_type_standard CONSTANT VARCHAR2(30) := 'C_SHIPMENT_TYPE_STANDARD';
408: c_shipment_type_quotation CONSTANT VARCHAR2(30) := 'C_SHIPMENT_TYPE_QUOTATION';
409: c_shipment_num CONSTANT VARCHAR2(30) := 'C_SHIPMENT_NUM';
410: c_shipment_quantity CONSTANT VARCHAR2(30) := 'C_SHIPMENT_QUANTITY';
411: c_shipment_price_override CONSTANT VARCHAR2(30) := 'C_SHIPMENT_PRICE_OVERRIDE';

Line 1085: -- PDOI Set Definitions for Standard PO

1081:
1082:
1083:
1084: ----------------------------------------------------------------------------
1085: -- PDOI Set Definitions for Standard PO
1086: ----------------------------------------------------------------------------
1087: c_pdoi_header_standard_vs CONSTANT po_tbl_varchar2000
1088: := po_tbl_varchar2000(c_confirming_order_flag,
1089: c_acceptance_due_date,

Line 1087: c_pdoi_header_standard_vs CONSTANT po_tbl_varchar2000

1083:
1084: ----------------------------------------------------------------------------
1085: -- PDOI Set Definitions for Standard PO
1086: ----------------------------------------------------------------------------
1087: c_pdoi_header_standard_vs CONSTANT po_tbl_varchar2000
1088: := po_tbl_varchar2000(c_confirming_order_flag,
1089: c_acceptance_due_date,
1090: c_firm_status_lookup_header,
1091: c_cancel_flag,

Line 1097: c_pdoi_line_standard_vs CONSTANT po_tbl_varchar2000

1093: c_print_count,
1094: c_frozen_flag,
1095: c_style_id);
1096:
1097: c_pdoi_line_standard_vs CONSTANT po_tbl_varchar2000
1098: := po_tbl_varchar2000(c_over_tolerance_error_flag,
1099: c_capital_expense_flag,
1100: c_not_to_exceed_price,
1101: c_start_date_standard,

Line 1101: c_start_date_standard,

1097: c_pdoi_line_standard_vs CONSTANT po_tbl_varchar2000
1098: := po_tbl_varchar2000(c_over_tolerance_error_flag,
1099: c_capital_expense_flag,
1100: c_not_to_exceed_price,
1101: c_start_date_standard,
1102: c_item_id_standard,
1103: c_quantity_standard,
1104: c_amount_standard,
1105: c_ip_category_id_null,

Line 1102: c_item_id_standard,

1098: := po_tbl_varchar2000(c_over_tolerance_error_flag,
1099: c_capital_expense_flag,
1100: c_not_to_exceed_price,
1101: c_start_date_standard,
1102: c_item_id_standard,
1103: c_quantity_standard,
1104: c_amount_standard,
1105: c_ip_category_id_null,
1106: c_line_secondary_uom,

Line 1103: c_quantity_standard,

1099: c_capital_expense_flag,
1100: c_not_to_exceed_price,
1101: c_start_date_standard,
1102: c_item_id_standard,
1103: c_quantity_standard,
1104: c_amount_standard,
1105: c_ip_category_id_null,
1106: c_line_secondary_uom,
1107: c_line_preferred_grade,

Line 1104: c_amount_standard,

1100: c_not_to_exceed_price,
1101: c_start_date_standard,
1102: c_item_id_standard,
1103: c_quantity_standard,
1104: c_amount_standard,
1105: c_ip_category_id_null,
1106: c_line_secondary_uom,
1107: c_line_preferred_grade,
1108: c_line_style_related_info,

Line 1123: c_pdoi_line_loc_standard_vs CONSTANT po_tbl_varchar2000

1119: c_pdoi_complex_po_att_check
1120: --
1121: );
1122:
1123: c_pdoi_line_loc_standard_vs CONSTANT po_tbl_varchar2000
1124: := po_tbl_varchar2000(c_enforce_ship_to_loc_code,
1125: c_shipment_type_standard,
1126: c_allow_sub_receipts_flag,
1127: c_days_early_receipt_allowed,

Line 1125: c_shipment_type_standard,

1121: );
1122:
1123: c_pdoi_line_loc_standard_vs CONSTANT po_tbl_varchar2000
1124: := po_tbl_varchar2000(c_enforce_ship_to_loc_code,
1125: c_shipment_type_standard,
1126: c_allow_sub_receipts_flag,
1127: c_days_early_receipt_allowed,
1128: c_receipt_days_exception_code,
1129: c_invoice_close_tolerance,

Line 2266: , p_clm_standard_form_tbl => p_headers.clm_standard_form

2262: p_header_id_tbl => p_headers.po_header_id
2263: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2264: , p_style_id_tbl => p_headers.style_id
2265: , p_draft_type_tbl => p_headers.draft_type
2266: , p_clm_standard_form_tbl => p_headers.clm_standard_form
2267: , p_document_format_tbl => p_headers.clm_document_format
2268: , p_clm_src_doc_id_tbl => p_headers.clm_source_document_id
2269: , p_clm_ext_idv_tbl => p_headers.clm_external_idv
2270: , p_clm_award_type_tbl => p_headers.clm_award_type

Line 2320: -- validate type_lookup_code not null and equal to BLANKET, STANDARD or QUOTATION.

2316: x_results => x_results,
2317: x_result_type => l_result_type);
2318:
2319: WHEN c_type_lookup_code THEN
2320: -- validate type_lookup_code not null and equal to BLANKET, STANDARD or QUOTATION.
2321: PO_VAL_HEADERS2.type_lookup_code(p_id_tbl => p_headers.interface_id,
2322: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2323: x_results => x_results,
2324: x_result_type => l_result_type);

Line 2744: WHEN c_validate_clm_standard_form THEN

2740:
2741: --PDOI CLM Integration Start
2742:
2743:
2744: WHEN c_validate_clm_standard_form THEN
2745: PO_VAL_HEADERS.validate_clm_standard_form
2746: (
2747: p_intf_header_id => p_headers.interface_id,
2748: p_clm_standard_form_tbl => p_headers.clm_standard_form,

Line 2745: PO_VAL_HEADERS.validate_clm_standard_form

2741: --PDOI CLM Integration Start
2742:
2743:
2744: WHEN c_validate_clm_standard_form THEN
2745: PO_VAL_HEADERS.validate_clm_standard_form
2746: (
2747: p_intf_header_id => p_headers.interface_id,
2748: p_clm_standard_form_tbl => p_headers.clm_standard_form,
2749: p_style_id_tbl => p_headers.style_id,

Line 2748: p_clm_standard_form_tbl => p_headers.clm_standard_form,

2744: WHEN c_validate_clm_standard_form THEN
2745: PO_VAL_HEADERS.validate_clm_standard_form
2746: (
2747: p_intf_header_id => p_headers.interface_id,
2748: p_clm_standard_form_tbl => p_headers.clm_standard_form,
2749: p_style_id_tbl => p_headers.style_id,
2750: x_results => x_results,
2751: x_result_type => l_result_type
2752: );

Line 2757: p_clm_standard_form_tbl => p_headers.clm_standard_form,

2753: WHEN c_validate_clm_document_format THEN
2754: PO_VAL_HEADERS.validate_clm_document_format
2755: (
2756: p_intf_header_id => p_headers.interface_id,
2757: p_clm_standard_form_tbl => p_headers.clm_standard_form,
2758: p_clm_document_format_tbl => p_headers.clm_document_format,
2759: p_style_id_tbl => p_headers.style_id,
2760: x_results => x_results,
2761: x_result_type => l_result_type

Line 3531: -- This method is called only for Standard PO and quotation documents

3527: -------------------------------------------------------------------------
3528: WHEN c_over_tolerance_error_flag THEN
3529: -- The lookup code specified in over_tolerance_error_flag with the lookup type
3530: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
3531: -- This method is called only for Standard PO and quotation documents
3532: PO_VAL_LINES2.over_tolerance_err_flag(p_id_tbl => p_lines.interface_id,
3533: p_over_tolerance_err_flag_tbl => p_lines.over_tolerance_error_flag,
3534: x_result_set_id => l_result_set_id,
3535: x_result_type => l_result_type);

Line 3569: -- If purchase basis is not 'TEMP LABOR' or document type is not STANDARD,

3565: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3566: x_results => x_results,
3567: x_result_type => l_result_type);
3568: WHEN c_contractor_name THEN
3569: -- If purchase basis is not 'TEMP LABOR' or document type is not STANDARD,
3570: -- contractor first name and last name fields should be empty
3571: PO_VAL_LINES2.contractor_name(p_id_tbl => p_lines.interface_id,
3572: p_doc_type => l_doc_type,
3573: p_purchase_basis_tbl => p_lines.purchase_basis,

Line 3754: WHEN c_start_date_standard THEN

3750: PO_VAL_LINES2.price_type_lookup_code(p_id_tbl => p_lines.interface_id,
3751: p_price_type_lookup_code_tbl => p_lines.price_type_lookup_code,
3752: x_result_set_id => l_result_set_id,
3753: x_result_type => l_result_type);
3754: WHEN c_start_date_standard THEN
3755: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'
3756: -- Expiration date if provided should be later than the start date
3757: -- If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
3758: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,

Line 3755: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'

3751: p_price_type_lookup_code_tbl => p_lines.price_type_lookup_code,
3752: x_result_set_id => l_result_set_id,
3753: x_result_type => l_result_type);
3754: WHEN c_start_date_standard THEN
3755: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'
3756: -- Expiration date if provided should be later than the start date
3757: -- If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
3758: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,
3759: p_start_date_tbl => p_lines.start_date,

Line 3758: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,

3754: WHEN c_start_date_standard THEN
3755: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'
3756: -- Expiration date if provided should be later than the start date
3757: -- If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
3758: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,
3759: p_start_date_tbl => p_lines.start_date,
3760: p_expiration_date_tbl => p_lines.expiration_date,
3761: p_purchase_basis_tbl => p_lines.purchase_basis,
3762: x_results => x_results,

Line 3764: WHEN c_item_id_standard THEN

3760: p_expiration_date_tbl => p_lines.expiration_date,
3761: p_purchase_basis_tbl => p_lines.purchase_basis,
3762: x_results => x_results,
3763: x_result_type => l_result_type);
3764: WHEN c_item_id_standard THEN
3765: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null, then bom_item_type cannot be 1 or 2.
3766: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,
3767: p_item_id_tbl => p_lines.item_id,
3768: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,

Line 3766: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,

3762: x_results => x_results,
3763: x_result_type => l_result_type);
3764: WHEN c_item_id_standard THEN
3765: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null, then bom_item_type cannot be 1 or 2.
3766: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,
3767: p_item_id_tbl => p_lines.item_id,
3768: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3769: p_inventory_org_id => l_inventory_org_id,
3770: x_result_set_id => l_result_set_id,

Line 3772: WHEN c_quantity_standard THEN

3768: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3769: p_inventory_org_id => l_inventory_org_id,
3770: x_result_set_id => l_result_set_id,
3771: x_result_type => l_result_type);
3772: WHEN c_quantity_standard THEN
3773: -- Quantity cannot be zero for SPO
3774: -- And qiantity cannot be empty for SPO if order type is QUANTITY/AMOUNT
3775: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,
3776: p_quantity_tbl => p_lines.quantity,

Line 3775: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,

3771: x_result_type => l_result_type);
3772: WHEN c_quantity_standard THEN
3773: -- Quantity cannot be zero for SPO
3774: -- And qiantity cannot be empty for SPO if order type is QUANTITY/AMOUNT
3775: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,
3776: p_quantity_tbl => p_lines.quantity,
3777: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3778: x_results => x_results,
3779: x_result_type => l_result_type);

Line 3780: WHEN c_amount_standard THEN

3776: p_quantity_tbl => p_lines.quantity,
3777: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3778: x_results => x_results,
3779: x_result_type => l_result_type);
3780: WHEN c_amount_standard THEN
3781: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null
3782: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,
3783: p_amount_tbl => p_lines.amount,
3784: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,

Line 3782: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,

3778: x_results => x_results,
3779: x_result_type => l_result_type);
3780: WHEN c_amount_standard THEN
3781: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null
3782: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,
3783: p_amount_tbl => p_lines.amount,
3784: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3785: x_results => x_results,
3786: x_result_type => l_result_type);

Line 4562: WHEN c_shipment_type_standard THEN

4558: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project
4559: p_doc_type => c_doc_type_blanket,
4560: x_results => x_results,
4561: x_result_type => l_result_type);
4562: WHEN c_shipment_type_standard THEN
4563: -- validate shipment type
4564: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
4565: p_shipment_type_tbl => p_line_locations.shipment_type,
4566: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project

Line 4567: p_doc_type => c_doc_type_standard,

4563: -- validate shipment type
4564: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
4565: p_shipment_type_tbl => p_line_locations.shipment_type,
4566: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project
4567: p_doc_type => c_doc_type_standard,
4568: x_results => x_results,
4569: x_result_type => l_result_type);
4570: WHEN c_shipment_type_quotation THEN
4571: -- validate shipment type

Line 4660: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal

4656: p_qty_rcv_exception_code_tbl => p_line_locations.qty_rcv_exception_code,
4657: x_result_set_id => l_result_set_id,
4658: x_result_type => l_result_type);
4659: WHEN c_enforce_ship_to_loc_code THEN
4660: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
4661: -- to NONE, REJECT or WARNING
4662: PO_VAL_SHIPMENTS2.enforce_ship_to_loc_code(p_id_tbl => p_line_locations.interface_id,
4663: p_enforce_ship_to_loc_code_tbl => p_line_locations.enforce_ship_to_location_code,
4664: p_shipment_type_tbl => p_line_locations.shipment_type,

Line 4668: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal

4664: p_shipment_type_tbl => p_line_locations.shipment_type,
4665: x_results => x_results,
4666: x_result_type => l_result_type);
4667: WHEN c_allow_sub_receipts_flag THEN
4668: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal
4669: -- to NONE, REJECT or WARNING
4670: PO_VAL_SHIPMENTS2.allow_sub_receipts_flag(p_id_tbl => p_line_locations.interface_id,
4671: p_shipment_type_tbl => p_line_locations.shipment_type,
4672: p_allow_sub_receipts_flag_tbl => p_line_locations.allow_substitute_receipts_flag,

Line 4676: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null

4672: p_allow_sub_receipts_flag_tbl => p_line_locations.allow_substitute_receipts_flag,
4673: x_results => x_results,
4674: x_result_type => l_result_type);
4675: WHEN c_days_early_receipt_allowed THEN
4676: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
4677: -- and less than zero.
4678: PO_VAL_SHIPMENTS2.days_early_receipt_allowed(p_id_tbl => p_line_locations.interface_id,
4679: p_shipment_type_tbl => p_line_locations.shipment_type,
4680: p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed,

Line 4684: -- If shipment_type is STANDARD and receipt_days_expection_code is not null

4680: p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed,
4681: x_results => x_results,
4682: x_result_type => l_result_type);
4683: WHEN c_receipt_days_exception_code THEN
4684: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
4685: -- and not 'NONE', 'REJECT' not 'WARNING'
4686: PO_VAL_SHIPMENTS2.receipt_days_exception_code(p_id_tbl => p_line_locations.interface_id,
4687: p_shipment_type_tbl => p_line_locations.shipment_type,
4688: p_rcpt_days_exception_code_tbl => p_line_locations.receipt_days_exception_code,

Line 4692: -- If shipment_type is STANDARD and invoice_close_tolerance is not null

4688: p_rcpt_days_exception_code_tbl => p_line_locations.receipt_days_exception_code,
4689: x_results => x_results,
4690: x_result_type => l_result_type);
4691: WHEN c_invoice_close_tolerance THEN
4692: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
4693: -- and less than or equal to zero or greater than or equal to 100.
4694: PO_VAL_SHIPMENTS2.invoice_close_tolerance(p_id_tbl => p_line_locations.interface_id,
4695: p_shipment_type_tbl => p_line_locations.shipment_type,
4696: p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance,

Line 4700: -- If shipment_type is STANDARD and receive_close_tolerance is not null

4696: p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance,
4697: x_results => x_results,
4698: x_result_type => l_result_type);
4699: WHEN c_receive_close_tolerance THEN
4700: -- If shipment_type is STANDARD and receive_close_tolerance is not null
4701: -- and less than or equal to zero or greater than or equal to 100.
4702: PO_VAL_SHIPMENTS2.receive_close_tolerance(p_id_tbl => p_line_locations.interface_id,
4703: p_shipment_type_tbl => p_line_locations.shipment_type,
4704: p_receive_close_tolerance_tbl => p_line_locations.receive_close_tolerance,

Line 6707: WHEN c_doc_type_standard THEN

6703: CASE p_doc_type
6704: WHEN c_doc_type_blanket THEN
6705: l_validation_set :=
6706: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_blanket_vs;
6707: WHEN c_doc_type_standard THEN
6708: l_validation_set :=
6709: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_standard_vs;
6710: WHEN c_doc_type_quotation THEN
6711: l_validation_set :=

Line 6709: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_standard_vs;

6705: l_validation_set :=
6706: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_blanket_vs;
6707: WHEN c_doc_type_standard THEN
6708: l_validation_set :=
6709: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_standard_vs;
6710: WHEN c_doc_type_quotation THEN
6711: l_validation_set :=
6712: l_validation_set MULTISET UNION DISTINCT c_pdoi_header_quotation_vs;
6713: ELSE

Line 6734: WHEN c_doc_type_standard THEN

6730: CASE p_doc_type
6731: WHEN c_doc_type_blanket THEN
6732: l_validation_set :=
6733: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_blanket_vs;
6734: WHEN c_doc_type_standard THEN
6735: l_validation_set :=
6736: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_standard_vs;
6737: WHEN c_doc_type_quotation THEN
6738: l_validation_set :=

Line 6736: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_standard_vs;

6732: l_validation_set :=
6733: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_blanket_vs;
6734: WHEN c_doc_type_standard THEN
6735: l_validation_set :=
6736: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_standard_vs;
6737: WHEN c_doc_type_quotation THEN
6738: l_validation_set :=
6739: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_quotation_vs;
6740: ELSE

Line 6779: WHEN c_doc_type_standard THEN

6775: CASE p_doc_type
6776: WHEN c_doc_type_blanket THEN
6777: l_validation_set :=
6778: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_blanket_vs;
6779: WHEN c_doc_type_standard THEN
6780: l_validation_set :=
6781: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_standard_vs;
6782: WHEN c_doc_type_quotation THEN
6783: l_validation_set :=

Line 6781: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_standard_vs;

6777: l_validation_set :=
6778: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_blanket_vs;
6779: WHEN c_doc_type_standard THEN
6780: l_validation_set :=
6781: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_standard_vs;
6782: WHEN c_doc_type_quotation THEN
6783: l_validation_set :=
6784: l_validation_set MULTISET UNION DISTINCT c_pdoi_line_loc_quotation_vs;
6785: ELSE

Line 6970: -- not before modifying a fully reserved standard PO.

6966: END log_validation_results_gt;
6967:
6968: --
6969: -- Added a function which checks whether the encumbered amount is correct or
6970: -- not before modifying a fully reserved standard PO.
6971: -------------------------------------------------------------------------------
6972: --Start of Comments
6973: --Name: check_encumbered_amount
6974: --Pre-reqs:

Line 7027: AND pod.distribution_type = 'STANDARD'

7023: ROUND(pll.PRICE_OVERRIDE * pod.QUANTITY_ORDERED * NVL(pod.RATE,1) +(NVL(pod.NONRECOVERABLE_TAX,0)*NVL(pod.rate,1)))
7024: ) <> ROUND(pod.encumbered_amount)
7025: AND pod.amount_changed_flag IS NULL
7026: AND pod.prevent_encumbrance_flag ='N'
7027: AND pod.distribution_type = 'STANDARD'
7028: AND pod.po_header_id= p_po_header_id);
7029:
7030: IF PO_LOG.d_stmt THEN
7031: PO_LOG.proc_end(d_mod,'x_return_status',x_return_status);