1: PACKAGE BODY PO_VAL_SHIPMENTS2 AS
2: -- $Header: PO_VAL_SHIPMENTS2.plb 120.22.12020000.2 2013/03/19 06:01:30 srpantha ship $
3: c_entity_type_line_location CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_LINE_LOCATION;
4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_SHIPMENTS2');
6:
7: -- The module base for the subprogram.
8: d_need_by_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEED_BY_DATE');
9: d_promised_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROMISED_DATE');
4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_SHIPMENTS2');
6:
7: -- The module base for the subprogram.
8: d_need_by_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEED_BY_DATE');
9: d_promised_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROMISED_DATE');
10: d_shipment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_TYPE');
11: d_payment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PAYMENT_TYPE'); -- PDOI for Complex PO Project
12: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_SHIPMENTS2');
6:
7: -- The module base for the subprogram.
8: d_need_by_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEED_BY_DATE');
9: d_promised_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROMISED_DATE');
10: d_shipment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_TYPE');
11: d_payment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PAYMENT_TYPE'); -- PDOI for Complex PO Project
12: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
13: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
6:
7: -- The module base for the subprogram.
8: d_need_by_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEED_BY_DATE');
9: d_promised_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROMISED_DATE');
10: d_shipment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_TYPE');
11: d_payment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PAYMENT_TYPE'); -- PDOI for Complex PO Project
12: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
13: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
14: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT'); -- PDOI for Complex PO Project
7: -- The module base for the subprogram.
8: d_need_by_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEED_BY_DATE');
9: d_promised_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROMISED_DATE');
10: d_shipment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_TYPE');
11: d_payment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PAYMENT_TYPE'); -- PDOI for Complex PO Project
12: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
13: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
14: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT'); -- PDOI for Complex PO Project
15: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
8: d_need_by_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEED_BY_DATE');
9: d_promised_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROMISED_DATE');
10: d_shipment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_TYPE');
11: d_payment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PAYMENT_TYPE'); -- PDOI for Complex PO Project
12: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
13: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
14: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT'); -- PDOI for Complex PO Project
15: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
16: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
9: d_promised_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROMISED_DATE');
10: d_shipment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_TYPE');
11: d_payment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PAYMENT_TYPE'); -- PDOI for Complex PO Project
12: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
13: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
14: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT'); -- PDOI for Complex PO Project
15: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
16: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
17: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
10: d_shipment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_TYPE');
11: d_payment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PAYMENT_TYPE'); -- PDOI for Complex PO Project
12: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
13: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
14: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT'); -- PDOI for Complex PO Project
15: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
16: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
17: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
18: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
11: d_payment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PAYMENT_TYPE'); -- PDOI for Complex PO Project
12: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
13: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
14: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT'); -- PDOI for Complex PO Project
15: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
16: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
17: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
18: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
19: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
12: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
13: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
14: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT'); -- PDOI for Complex PO Project
15: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
16: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
17: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
18: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
19: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
20: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
13: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
14: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT'); -- PDOI for Complex PO Project
15: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
16: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
17: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
18: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
19: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
20: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
21: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
14: d_amount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT'); -- PDOI for Complex PO Project
15: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
16: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
17: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
18: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
19: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
20: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
21: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
22: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
15: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
16: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
17: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
18: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
19: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
20: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
21: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
22: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
23: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
16: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
17: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
18: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
19: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
20: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
21: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
22: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
23: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
24: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
17: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
18: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
19: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
20: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
21: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
22: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
23: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
24: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
25: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
18: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
19: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
20: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
21: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
22: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
23: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
24: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
25: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
26: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
19: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
20: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
21: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
22: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
23: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
24: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
25: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
26: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
27: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
20: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
21: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
22: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
23: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
24: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
25: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
26: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
27: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
28: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
21: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
22: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
23: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
24: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
25: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
26: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
27: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
28: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
29: d_advance_amt_le_amt CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ADVANCE_AMT_LE_AMT'); -- PDOI for Complex PO Project
22: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
23: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
24: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
25: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
26: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
27: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
28: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
29: d_advance_amt_le_amt CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ADVANCE_AMT_LE_AMT'); -- PDOI for Complex PO Project
30: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
23: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
24: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
25: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
26: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
27: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
28: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
29: d_advance_amt_le_amt CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ADVANCE_AMT_LE_AMT'); -- PDOI for Complex PO Project
30: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
31: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
24: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
25: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
26: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
27: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
28: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
29: d_advance_amt_le_amt CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ADVANCE_AMT_LE_AMT'); -- PDOI for Complex PO Project
30: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
31: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
32: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
25: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
26: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
27: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
28: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
29: d_advance_amt_le_amt CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ADVANCE_AMT_LE_AMT'); -- PDOI for Complex PO Project
30: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
31: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
32: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
33: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
26: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
27: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
28: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
29: d_advance_amt_le_amt CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ADVANCE_AMT_LE_AMT'); -- PDOI for Complex PO Project
30: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
31: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
32: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
33: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
34: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
27: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
28: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
29: d_advance_amt_le_amt CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ADVANCE_AMT_LE_AMT'); -- PDOI for Complex PO Project
30: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
31: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
32: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
33: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
34: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
35: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');
28: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
29: d_advance_amt_le_amt CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ADVANCE_AMT_LE_AMT'); -- PDOI for Complex PO Project
30: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
31: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
32: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
33: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
34: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
35: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');
36:
29: d_advance_amt_le_amt CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ADVANCE_AMT_LE_AMT'); -- PDOI for Complex PO Project
30: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
31: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
32: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
33: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
34: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
35: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');
36:
37: -- Indicates that the calling program is PDOI.
30: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
31: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
32: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
33: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
34: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
35: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');
36:
37: -- Indicates that the calling program is PDOI.
38: c_program_pdoi CONSTANT VARCHAR2(10) := 'PDOI';
31: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
32: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
33: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
34: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
35: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');
36:
37: -- Indicates that the calling program is PDOI.
38: c_program_pdoi CONSTANT VARCHAR2(10) := 'PDOI';
39: -- The application name of PO.
56: END IF;
57:
58: x_result_type := po_validations.c_result_type_success;
59:
60: IF po_log.d_proc THEN
61: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
62: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
63: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
64: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
57:
58: x_result_type := po_validations.c_result_type_success;
59:
60: IF po_log.d_proc THEN
61: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
62: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
63: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
64: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
65: END IF;
58: x_result_type := po_validations.c_result_type_success;
59:
60: IF po_log.d_proc THEN
61: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
62: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
63: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
64: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
65: END IF;
66:
59:
60: IF po_log.d_proc THEN
61: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
62: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
63: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
64: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
65: END IF;
66:
67: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
60: IF po_log.d_proc THEN
61: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
62: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
63: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
64: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
65: END IF;
66:
67: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
68: FOR i IN 1 .. p_id_tbl.COUNT LOOP
76: x_result_type := po_validations.c_result_type_failure;
77: END IF;
78: END LOOP;
79:
80: IF po_log.d_proc THEN
81: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
82: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
83: END IF;
84: EXCEPTION
77: END IF;
78: END LOOP;
79:
80: IF po_log.d_proc THEN
81: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
82: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
83: END IF;
84: EXCEPTION
85: WHEN OTHERS THEN
78: END LOOP;
79:
80: IF po_log.d_proc THEN
81: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
82: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
83: END IF;
84: EXCEPTION
85: WHEN OTHERS THEN
86: IF po_log.d_exc THEN
82: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
83: END IF;
84: EXCEPTION
85: WHEN OTHERS THEN
86: IF po_log.d_exc THEN
87: po_log.exc(d_mod, 0, NULL);
88: END IF;
89:
90: RAISE;
83: END IF;
84: EXCEPTION
85: WHEN OTHERS THEN
86: IF po_log.d_exc THEN
87: po_log.exc(d_mod, 0, NULL);
88: END IF;
89:
90: RAISE;
91: END need_by_date;
107: END IF;
108:
109: x_result_type := po_validations.c_result_type_success;
110:
111: IF po_log.d_proc THEN
112: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
113: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
114: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
115: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
108:
109: x_result_type := po_validations.c_result_type_success;
110:
111: IF po_log.d_proc THEN
112: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
113: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
114: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
115: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
116: END IF;
109: x_result_type := po_validations.c_result_type_success;
110:
111: IF po_log.d_proc THEN
112: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
113: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
114: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
115: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
116: END IF;
117:
110:
111: IF po_log.d_proc THEN
112: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
113: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
114: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
115: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
116: END IF;
117:
118: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
111: IF po_log.d_proc THEN
112: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
113: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
114: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
115: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
116: END IF;
117:
118: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
119: FOR i IN 1 .. p_id_tbl.COUNT LOOP
127: x_result_type := po_validations.c_result_type_failure;
128: END IF;
129: END LOOP;
130:
131: IF po_log.d_proc THEN
132: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
133: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
134: END IF;
135: EXCEPTION
128: END IF;
129: END LOOP;
130:
131: IF po_log.d_proc THEN
132: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
133: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN
129: END LOOP;
130:
131: IF po_log.d_proc THEN
132: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
133: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN
137: IF po_log.d_exc THEN
133: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN
137: IF po_log.d_exc THEN
138: po_log.exc(d_mod, 0, NULL);
139: END IF;
140:
141: RAISE;
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN
137: IF po_log.d_exc THEN
138: po_log.exc(d_mod, 0, NULL);
139: END IF;
140:
141: RAISE;
142: END promised_date;
160: END IF;
161:
162: x_result_type := po_validations.c_result_type_success;
163:
164: IF po_log.d_proc THEN
165: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
166: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
167: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
168: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
161:
162: x_result_type := po_validations.c_result_type_success;
163:
164: IF po_log.d_proc THEN
165: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
166: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
167: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
168: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
169: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
162: x_result_type := po_validations.c_result_type_success;
163:
164: IF po_log.d_proc THEN
165: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
166: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
167: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
168: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
169: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
170: END IF;
163:
164: IF po_log.d_proc THEN
165: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
166: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
167: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
168: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
169: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
170: END IF;
171:
164: IF po_log.d_proc THEN
165: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
166: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
167: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
168: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
169: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
170: END IF;
171:
172: -- if shipment_type is Null
165: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
166: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
167: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
168: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
169: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
170: END IF;
171:
172: -- if shipment_type is Null
173: FOR i IN 1 .. p_id_tbl.COUNT LOOP
197: x_result_type := po_validations.c_result_type_failure;
198: END IF;
199: END LOOP;
200:
201: IF po_log.d_proc THEN
202: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
203: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
204: END IF;
205: EXCEPTION
198: END IF;
199: END LOOP;
200:
201: IF po_log.d_proc THEN
202: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
203: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
204: END IF;
205: EXCEPTION
206: WHEN OTHERS THEN
199: END LOOP;
200:
201: IF po_log.d_proc THEN
202: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
203: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
204: END IF;
205: EXCEPTION
206: WHEN OTHERS THEN
207: IF po_log.d_exc THEN
203: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
204: END IF;
205: EXCEPTION
206: WHEN OTHERS THEN
207: IF po_log.d_exc THEN
208: po_log.exc(d_mod, 0, NULL);
209: END IF;
210:
211: RAISE;
204: END IF;
205: EXCEPTION
206: WHEN OTHERS THEN
207: IF po_log.d_exc THEN
208: po_log.exc(d_mod, 0, NULL);
209: END IF;
210:
211: RAISE;
212: END shipment_type;
242: END IF;
243:
244: x_result_type := po_validations.c_result_type_success;
245:
246: IF po_log.d_proc THEN
247: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
248: po_log.proc_begin(d_mod, 'po_line_id_tbl', po_line_id_tbl);
249: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
250: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
243:
244: x_result_type := po_validations.c_result_type_success;
245:
246: IF po_log.d_proc THEN
247: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
248: po_log.proc_begin(d_mod, 'po_line_id_tbl', po_line_id_tbl);
249: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
250: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
251: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
244: x_result_type := po_validations.c_result_type_success;
245:
246: IF po_log.d_proc THEN
247: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
248: po_log.proc_begin(d_mod, 'po_line_id_tbl', po_line_id_tbl);
249: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
250: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
251: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
252: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
245:
246: IF po_log.d_proc THEN
247: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
248: po_log.proc_begin(d_mod, 'po_line_id_tbl', po_line_id_tbl);
249: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
250: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
251: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
252: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
253: END IF;
246: IF po_log.d_proc THEN
247: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
248: po_log.proc_begin(d_mod, 'po_line_id_tbl', po_line_id_tbl);
249: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
250: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
251: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
252: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
253: END IF;
254:
247: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
248: po_log.proc_begin(d_mod, 'po_line_id_tbl', po_line_id_tbl);
249: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
250: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
251: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
252: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
253: END IF;
254:
255: FOR i IN 1 .. p_id_tbl.COUNT LOOP
248: po_log.proc_begin(d_mod, 'po_line_id_tbl', po_line_id_tbl);
249: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
250: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
251: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
252: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
253: END IF;
254:
255: FOR i IN 1 .. p_id_tbl.COUNT LOOP
256:
408: END IF;
409:
410: END LOOP;
411:
412: IF po_log.d_proc THEN
413: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
414: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
415: END IF;
416: EXCEPTION
409:
410: END LOOP;
411:
412: IF po_log.d_proc THEN
413: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
414: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
415: END IF;
416: EXCEPTION
417: WHEN OTHERS THEN
410: END LOOP;
411:
412: IF po_log.d_proc THEN
413: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
414: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
415: END IF;
416: EXCEPTION
417: WHEN OTHERS THEN
418: IF po_log.d_exc THEN
414: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
415: END IF;
416: EXCEPTION
417: WHEN OTHERS THEN
418: IF po_log.d_exc THEN
419: po_log.exc(d_mod, 0, NULL);
420: END IF;
421:
422: RAISE;
415: END IF;
416: EXCEPTION
417: WHEN OTHERS THEN
418: IF po_log.d_exc THEN
419: po_log.exc(d_mod, 0, NULL);
420: END IF;
421:
422: RAISE;
423: END payment_type;
448: IF (x_results IS NULL) THEN
449: x_results := po_validation_results_type.new_instance();
450: END IF;
451:
452: IF po_log.d_proc THEN
453: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
454: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
455: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
456: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
449: x_results := po_validation_results_type.new_instance();
450: END IF;
451:
452: IF po_log.d_proc THEN
453: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
454: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
455: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
456: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
457: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
450: END IF;
451:
452: IF po_log.d_proc THEN
453: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
454: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
455: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
456: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
457: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
458: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
451:
452: IF po_log.d_proc THEN
453: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
454: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
455: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
456: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
457: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
458: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
459: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
452: IF po_log.d_proc THEN
453: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
454: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
455: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
456: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
457: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
458: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
459: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
460: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
453: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
454: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
455: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
456: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
457: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
458: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
459: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
460: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
461: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
454: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
455: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
456: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
457: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
458: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
459: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
460: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
461: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
462: END IF;
455: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
456: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
457: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
458: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
459: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
460: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
461: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
462: END IF;
463:
456: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
457: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
458: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
459: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
460: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
461: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
462: END IF;
463:
464: x_result_type := po_validations.c_result_type_success;
457: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
458: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
459: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
460: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
461: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
462: END IF;
463:
464: x_result_type := po_validations.c_result_type_success;
465:
544: IF (SQL%ROWCOUNT > 0) THEN
545: x_result_type := po_validations.c_result_type_failure;
546: END IF;
547:
548: IF po_log.d_proc THEN
549: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
550: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
551: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
552: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
546: END IF;
547:
548: IF po_log.d_proc THEN
549: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
550: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
551: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
552: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
553: END IF;
554: EXCEPTION
547:
548: IF po_log.d_proc THEN
549: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
550: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
551: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
552: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
553: END IF;
554: EXCEPTION
555: WHEN OTHERS THEN
548: IF po_log.d_proc THEN
549: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
550: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
551: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
552: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
553: END IF;
554: EXCEPTION
555: WHEN OTHERS THEN
556: IF po_log.d_exc THEN
552: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
553: END IF;
554: EXCEPTION
555: WHEN OTHERS THEN
556: IF po_log.d_exc THEN
557: po_log.exc(d_mod, 0, NULL);
558: END IF;
559:
560: RAISE;
553: END IF;
554: EXCEPTION
555: WHEN OTHERS THEN
556: IF po_log.d_exc THEN
557: po_log.exc(d_mod, 0, NULL);
558: END IF;
559:
560: RAISE;
561: END shipment_num;
584: END IF;
585:
586: x_result_type := po_validations.c_result_type_success;
587:
588: IF po_log.d_proc THEN
589: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
590: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
591: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
592: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
585:
586: x_result_type := po_validations.c_result_type_success;
587:
588: IF po_log.d_proc THEN
589: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
590: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
591: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
592: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
593: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
586: x_result_type := po_validations.c_result_type_success;
587:
588: IF po_log.d_proc THEN
589: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
590: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
591: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
592: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
593: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
594: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
587:
588: IF po_log.d_proc THEN
589: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
590: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
591: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
592: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
593: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
594: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
595: po_log.proc_begin(d_mod, 'p_line_quantity_tbl', p_line_quantity_tbl); -- PDOI for Complex PO Project
588: IF po_log.d_proc THEN
589: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
590: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
591: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
592: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
593: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
594: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
595: po_log.proc_begin(d_mod, 'p_line_quantity_tbl', p_line_quantity_tbl); -- PDOI for Complex PO Project
596: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
589: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
590: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
591: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
592: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
593: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
594: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
595: po_log.proc_begin(d_mod, 'p_line_quantity_tbl', p_line_quantity_tbl); -- PDOI for Complex PO Project
596: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
597: END IF;
590: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
591: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
592: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
593: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
594: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
595: po_log.proc_begin(d_mod, 'p_line_quantity_tbl', p_line_quantity_tbl); -- PDOI for Complex PO Project
596: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
597: END IF;
598:
591: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
592: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
593: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
594: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
595: po_log.proc_begin(d_mod, 'p_line_quantity_tbl', p_line_quantity_tbl); -- PDOI for Complex PO Project
596: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
597: END IF;
598:
599: -- If order_type_lookup_code is RATE or FIXED PRICE,
592: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
593: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
594: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
595: po_log.proc_begin(d_mod, 'p_line_quantity_tbl', p_line_quantity_tbl); -- PDOI for Complex PO Project
596: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
597: END IF;
598:
599: -- If order_type_lookup_code is RATE or FIXED PRICE,
600: -- validate quantity must be null
647: --
648: END IF;
649: END LOOP;
650:
651: IF po_log.d_proc THEN
652: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
653: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
654: END IF;
655: EXCEPTION
648: END IF;
649: END LOOP;
650:
651: IF po_log.d_proc THEN
652: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
653: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
654: END IF;
655: EXCEPTION
656: WHEN OTHERS THEN
649: END LOOP;
650:
651: IF po_log.d_proc THEN
652: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
653: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
654: END IF;
655: EXCEPTION
656: WHEN OTHERS THEN
657: IF po_log.d_exc THEN
653: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
654: END IF;
655: EXCEPTION
656: WHEN OTHERS THEN
657: IF po_log.d_exc THEN
658: po_log.exc(d_mod, 0, NULL);
659: END IF;
660:
661: RAISE;
654: END IF;
655: EXCEPTION
656: WHEN OTHERS THEN
657: IF po_log.d_exc THEN
658: po_log.exc(d_mod, 0, NULL);
659: END IF;
660:
661: RAISE;
662: END quantity;
683: END IF;
684:
685: x_result_type := po_validations.c_result_type_success;
686:
687: IF po_log.d_proc THEN
688: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
689: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
690: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
684:
685: x_result_type := po_validations.c_result_type_success;
686:
687: IF po_log.d_proc THEN
688: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
689: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
690: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
692: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
685: x_result_type := po_validations.c_result_type_success;
686:
687: IF po_log.d_proc THEN
688: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
689: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
690: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
692: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
693: po_log.proc_begin(d_mod, 'p_line_amount_tbl', p_line_amount_tbl);
686:
687: IF po_log.d_proc THEN
688: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
689: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
690: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
692: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
693: po_log.proc_begin(d_mod, 'p_line_amount_tbl', p_line_amount_tbl);
694: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
687: IF po_log.d_proc THEN
688: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
689: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
690: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
692: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
693: po_log.proc_begin(d_mod, 'p_line_amount_tbl', p_line_amount_tbl);
694: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
695: END IF;
688: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
689: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
690: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
692: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
693: po_log.proc_begin(d_mod, 'p_line_amount_tbl', p_line_amount_tbl);
694: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
695: END IF;
696:
689: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
690: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
692: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
693: po_log.proc_begin(d_mod, 'p_line_amount_tbl', p_line_amount_tbl);
694: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
695: END IF;
696:
697: FOR i IN 1 .. p_id_tbl.COUNT LOOP
690: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
692: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
693: po_log.proc_begin(d_mod, 'p_line_amount_tbl', p_line_amount_tbl);
694: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
695: END IF;
696:
697: FOR i IN 1 .. p_id_tbl.COUNT LOOP
698:
715: x_result_type := po_validations.c_result_type_failure;
716: END IF;
717: END LOOP;
718:
719: IF po_log.d_proc THEN
720: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
721: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
722: END IF;
723: EXCEPTION
716: END IF;
717: END LOOP;
718:
719: IF po_log.d_proc THEN
720: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
721: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
722: END IF;
723: EXCEPTION
724: WHEN OTHERS THEN
717: END LOOP;
718:
719: IF po_log.d_proc THEN
720: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
721: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
722: END IF;
723: EXCEPTION
724: WHEN OTHERS THEN
725: IF po_log.d_exc THEN
721: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
722: END IF;
723: EXCEPTION
724: WHEN OTHERS THEN
725: IF po_log.d_exc THEN
726: po_log.exc(d_mod, 0, NULL);
727: END IF;
728:
729: RAISE;
722: END IF;
723: EXCEPTION
724: WHEN OTHERS THEN
725: IF po_log.d_exc THEN
726: po_log.exc(d_mod, 0, NULL);
727: END IF;
728:
729: RAISE;
730: END amount;
751: END IF;
752:
753: x_result_type := po_validations.c_result_type_success;
754:
755: IF po_log.d_proc THEN
756: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
757: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
758: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
759: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
752:
753: x_result_type := po_validations.c_result_type_success;
754:
755: IF po_log.d_proc THEN
756: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
757: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
758: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
759: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
760: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
753: x_result_type := po_validations.c_result_type_success;
754:
755: IF po_log.d_proc THEN
756: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
757: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
758: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
759: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
760: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
761: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
754:
755: IF po_log.d_proc THEN
756: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
757: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
758: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
759: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
760: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
761: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
762: po_log.proc_begin(d_mod, 'p_line_unit_price_tbl', p_line_unit_price_tbl); -- PDOI for Complex PO Project
755: IF po_log.d_proc THEN
756: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
757: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
758: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
759: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
760: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
761: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
762: po_log.proc_begin(d_mod, 'p_line_unit_price_tbl', p_line_unit_price_tbl); -- PDOI for Complex PO Project
763: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
756: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
757: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
758: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
759: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
760: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
761: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
762: po_log.proc_begin(d_mod, 'p_line_unit_price_tbl', p_line_unit_price_tbl); -- PDOI for Complex PO Project
763: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
764: END IF;
757: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
758: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
759: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
760: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
761: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
762: po_log.proc_begin(d_mod, 'p_line_unit_price_tbl', p_line_unit_price_tbl); -- PDOI for Complex PO Project
763: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
764: END IF;
765:
758: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
759: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
760: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
761: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
762: po_log.proc_begin(d_mod, 'p_line_unit_price_tbl', p_line_unit_price_tbl); -- PDOI for Complex PO Project
763: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
764: END IF;
765:
766: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null
759: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl); -- PDOI for Complex PO Project
760: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl); -- PDOI for Complex PO Project
761: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl); -- PDOI for Complex PO Project
762: po_log.proc_begin(d_mod, 'p_line_unit_price_tbl', p_line_unit_price_tbl); -- PDOI for Complex PO Project
763: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
764: END IF;
765:
766: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null
767: FOR i IN 1 .. p_id_tbl.COUNT LOOP
811: --
812: END IF;
813: END LOOP;
814:
815: IF po_log.d_proc THEN
816: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
817: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
818: END IF;
819: EXCEPTION
812: END IF;
813: END LOOP;
814:
815: IF po_log.d_proc THEN
816: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
817: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
818: END IF;
819: EXCEPTION
820: WHEN OTHERS THEN
813: END LOOP;
814:
815: IF po_log.d_proc THEN
816: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
817: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
818: END IF;
819: EXCEPTION
820: WHEN OTHERS THEN
821: IF po_log.d_exc THEN
817: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
818: END IF;
819: EXCEPTION
820: WHEN OTHERS THEN
821: IF po_log.d_exc THEN
822: po_log.exc(d_mod, 0, NULL);
823: END IF;
824:
825: RAISE;
818: END IF;
819: EXCEPTION
820: WHEN OTHERS THEN
821: IF po_log.d_exc THEN
822: po_log.exc(d_mod, 0, NULL);
823: END IF;
824:
825: RAISE;
826: END price_override;
844: END IF;
845:
846: x_result_type := po_validations.c_result_type_success;
847:
848: IF po_log.d_proc THEN
849: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
850: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
851: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
852: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
845:
846: x_result_type := po_validations.c_result_type_success;
847:
848: IF po_log.d_proc THEN
849: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
850: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
851: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
852: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
853: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
846: x_result_type := po_validations.c_result_type_success;
847:
848: IF po_log.d_proc THEN
849: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
850: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
851: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
852: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
853: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
854: END IF;
847:
848: IF po_log.d_proc THEN
849: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
850: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
851: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
852: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
853: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
854: END IF;
855:
848: IF po_log.d_proc THEN
849: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
850: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
851: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
852: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
853: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
854: END IF;
855:
856: -- If order_type_lookup_code is not FIXED PRICE and price_discount/price override cannot both be null
849: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
850: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
851: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
852: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
853: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
854: END IF;
855:
856: -- If order_type_lookup_code is not FIXED PRICE and price_discount/price override cannot both be null
857: -- and price discount cannot be greater than 100
885: x_result_type := po_validations.c_result_type_failure;
886: END IF;
887: END LOOP;
888:
889: IF po_log.d_proc THEN
890: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
891: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
892: END IF;
893: EXCEPTION
886: END IF;
887: END LOOP;
888:
889: IF po_log.d_proc THEN
890: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
891: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
892: END IF;
893: EXCEPTION
894: WHEN OTHERS THEN
887: END LOOP;
888:
889: IF po_log.d_proc THEN
890: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
891: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
892: END IF;
893: EXCEPTION
894: WHEN OTHERS THEN
895: IF po_log.d_exc THEN
891: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
892: END IF;
893: EXCEPTION
894: WHEN OTHERS THEN
895: IF po_log.d_exc THEN
896: po_log.exc(d_mod, 0, NULL);
897: END IF;
898:
899: RAISE;
892: END IF;
893: EXCEPTION
894: WHEN OTHERS THEN
895: IF po_log.d_exc THEN
896: po_log.exc(d_mod, 0, NULL);
897: END IF;
898:
899: RAISE;
900: END price_discount;
918: END IF;
919:
920: x_result_type := po_validations.c_result_type_success;
921:
922: IF po_log.d_proc THEN
923: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
924: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
925: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
926: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
919:
920: x_result_type := po_validations.c_result_type_success;
921:
922: IF po_log.d_proc THEN
923: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
924: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
925: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
926: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
927: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
920: x_result_type := po_validations.c_result_type_success;
921:
922: IF po_log.d_proc THEN
923: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
924: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
925: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
926: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
927: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
928: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
921:
922: IF po_log.d_proc THEN
923: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
924: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
925: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
926: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
927: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
928: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
929: END IF;
922: IF po_log.d_proc THEN
923: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
924: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
925: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
926: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
927: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
928: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
929: END IF;
930:
923: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
924: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
925: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
926: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
927: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
928: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
929: END IF;
930:
931: -- If item_id is not null and ship_to_organization_id is not null, and
924: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
925: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
926: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
927: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
928: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
929: END IF;
930:
931: -- If item_id is not null and ship_to_organization_id is not null, and
932: -- item_revision is not null and no record exists in mtl_item_revisions.
1084: IF (SQL%ROWCOUNT > 0) THEN
1085: x_result_type := po_validations.c_result_type_failure;
1086: END IF;
1087:
1088: IF po_log.d_proc THEN
1089: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1090: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1091: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1092: END IF;
1086: END IF;
1087:
1088: IF po_log.d_proc THEN
1089: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1090: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1091: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1092: END IF;
1093: EXCEPTION
1094: WHEN OTHERS THEN
1087:
1088: IF po_log.d_proc THEN
1089: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1090: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1091: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1092: END IF;
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: IF po_log.d_exc THEN
1091: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1092: END IF;
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: IF po_log.d_exc THEN
1096: po_log.exc(d_mod, 0, NULL);
1097: END IF;
1098:
1099: RAISE;
1092: END IF;
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: IF po_log.d_exc THEN
1096: po_log.exc(d_mod, 0, NULL);
1097: END IF;
1098:
1099: RAISE;
1100: END ship_to_organization_id;
1119: END IF;
1120:
1121: x_result_type := po_validations.c_result_type_success;
1122:
1123: IF po_log.d_proc THEN
1124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1125: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1126: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1127: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1120:
1121: x_result_type := po_validations.c_result_type_success;
1122:
1123: IF po_log.d_proc THEN
1124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1125: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1126: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1127: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1128: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1121: x_result_type := po_validations.c_result_type_success;
1122:
1123: IF po_log.d_proc THEN
1124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1125: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1126: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1127: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1128: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1129: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
1122:
1123: IF po_log.d_proc THEN
1124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1125: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1126: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1127: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1128: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1129: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
1130: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1123: IF po_log.d_proc THEN
1124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1125: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1126: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1127: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1128: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1129: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
1130: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1131: END IF;
1124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1125: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1126: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1127: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1128: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1129: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
1130: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1131: END IF;
1132:
1125: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1126: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1127: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1128: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1129: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
1130: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1131: END IF;
1132:
1133: -- validate price break attributes
1126: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1127: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1128: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1129: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
1130: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1131: END IF;
1132:
1133: -- validate price break attributes
1134: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1144: x_result_type := po_validations.c_result_type_failure;
1145: END IF;
1146: END LOOP;
1147:
1148: IF po_log.d_proc THEN
1149: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1150: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1151: END IF;
1152: EXCEPTION
1145: END IF;
1146: END LOOP;
1147:
1148: IF po_log.d_proc THEN
1149: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1150: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1151: END IF;
1152: EXCEPTION
1153: WHEN OTHERS THEN
1146: END LOOP;
1147:
1148: IF po_log.d_proc THEN
1149: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1150: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1151: END IF;
1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: IF po_log.d_exc THEN
1150: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1151: END IF;
1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: IF po_log.d_exc THEN
1155: po_log.exc(d_mod, 0, NULL);
1156: END IF;
1157:
1158: RAISE;
1151: END IF;
1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: IF po_log.d_exc THEN
1155: po_log.exc(d_mod, 0, NULL);
1156: END IF;
1157:
1158: RAISE;
1159: END price_break_attributes;
1179: END IF;
1180:
1181: x_result_type := po_validations.c_result_type_success;
1182:
1183: IF po_log.d_proc THEN
1184: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1185: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
1186: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1187: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1180:
1181: x_result_type := po_validations.c_result_type_success;
1182:
1183: IF po_log.d_proc THEN
1184: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1185: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
1186: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1187: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1188: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
1181: x_result_type := po_validations.c_result_type_success;
1182:
1183: IF po_log.d_proc THEN
1184: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1185: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
1186: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1187: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1188: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
1189: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
1182:
1183: IF po_log.d_proc THEN
1184: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1185: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
1186: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1187: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1188: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
1189: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
1190: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1183: IF po_log.d_proc THEN
1184: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1185: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
1186: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1187: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1188: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
1189: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
1190: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1191: END IF;
1184: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1185: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
1186: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1187: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1188: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
1189: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
1190: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1191: END IF;
1192:
1185: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
1186: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1187: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1188: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
1189: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
1190: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1191: END IF;
1192:
1193: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1186: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
1187: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
1188: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
1189: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
1190: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1191: END IF;
1192:
1193: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1194: -- Pricebreak effective from date cannot be earlier than blanket
1323: END IF;
1324:
1325: END LOOP;
1326:
1327: IF po_log.d_proc THEN
1328: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1329: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1330: END IF;
1331: EXCEPTION
1324:
1325: END LOOP;
1326:
1327: IF po_log.d_proc THEN
1328: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1329: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1330: END IF;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1325: END LOOP;
1326:
1327: IF po_log.d_proc THEN
1328: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1329: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1330: END IF;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: IF po_log.d_exc THEN
1329: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1330: END IF;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: IF po_log.d_exc THEN
1334: po_log.exc(d_mod, 0, NULL);
1335: END IF;
1336:
1337: RAISE;
1330: END IF;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: IF po_log.d_exc THEN
1334: po_log.exc(d_mod, 0, NULL);
1335: END IF;
1336:
1337: RAISE;
1338: END effective_dates;
1353: END IF;
1354:
1355: x_result_type := po_validations.c_result_type_success;
1356:
1357: IF po_log.d_proc THEN
1358: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1359: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);
1360: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1361: END IF;
1354:
1355: x_result_type := po_validations.c_result_type_success;
1356:
1357: IF po_log.d_proc THEN
1358: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1359: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);
1360: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1361: END IF;
1362:
1355: x_result_type := po_validations.c_result_type_success;
1356:
1357: IF po_log.d_proc THEN
1358: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1359: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);
1360: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1361: END IF;
1362:
1363: FORALL i IN 1 .. p_id_tbl.COUNT
1356:
1357: IF po_log.d_proc THEN
1358: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1359: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);
1360: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1361: END IF;
1362:
1363: FORALL i IN 1 .. p_id_tbl.COUNT
1364: INSERT INTO po_validation_results_gt
1396: ELSE
1397: x_result_type := po_validations.c_result_type_success;
1398: END IF;
1399:
1400: IF po_log.d_proc THEN
1401: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1402: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1403: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1404: END IF;
1398: END IF;
1399:
1400: IF po_log.d_proc THEN
1401: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1402: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1403: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1404: END IF;
1405: EXCEPTION
1406: WHEN OTHERS THEN
1399:
1400: IF po_log.d_proc THEN
1401: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1402: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1403: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1404: END IF;
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: IF po_log.d_exc THEN
1403: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1404: END IF;
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: IF po_log.d_exc THEN
1408: po_log.exc(d_mod, 0, NULL);
1409: END IF;
1410:
1411: RAISE;
1404: END IF;
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: IF po_log.d_exc THEN
1408: po_log.exc(d_mod, 0, NULL);
1409: END IF;
1410:
1411: RAISE;
1412: END qty_rcv_exception_code;
1429: END IF;
1430:
1431: x_result_type := po_validations.c_result_type_success;
1432:
1433: IF po_log.d_proc THEN
1434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1435: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1436: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1437: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1430:
1431: x_result_type := po_validations.c_result_type_success;
1432:
1433: IF po_log.d_proc THEN
1434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1435: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1436: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1437: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1438: END IF;
1431: x_result_type := po_validations.c_result_type_success;
1432:
1433: IF po_log.d_proc THEN
1434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1435: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1436: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1437: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1438: END IF;
1439:
1432:
1433: IF po_log.d_proc THEN
1434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1435: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1436: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1437: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1438: END IF;
1439:
1440: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
1433: IF po_log.d_proc THEN
1434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1435: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1436: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1437: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1438: END IF;
1439:
1440: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
1441: -- to NONE, REJECT or WARNING
1452: x_result_type := po_validations.c_result_type_failure;
1453: END IF;
1454: END LOOP;
1455:
1456: IF po_log.d_proc THEN
1457: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1458: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1459: END IF;
1460: EXCEPTION
1453: END IF;
1454: END LOOP;
1455:
1456: IF po_log.d_proc THEN
1457: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1458: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1459: END IF;
1460: EXCEPTION
1461: WHEN OTHERS THEN
1454: END LOOP;
1455:
1456: IF po_log.d_proc THEN
1457: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1458: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1459: END IF;
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: IF po_log.d_exc THEN
1458: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1459: END IF;
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: IF po_log.d_exc THEN
1463: po_log.exc(d_mod, 0, NULL);
1464: END IF;
1465:
1466: RAISE;
1459: END IF;
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: IF po_log.d_exc THEN
1463: po_log.exc(d_mod, 0, NULL);
1464: END IF;
1465:
1466: RAISE;
1467: END enforce_ship_to_loc_code;
1484: END IF;
1485:
1486: x_result_type := po_validations.c_result_type_success;
1487:
1488: IF po_log.d_proc THEN
1489: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1490: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1491: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1492: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1485:
1486: x_result_type := po_validations.c_result_type_success;
1487:
1488: IF po_log.d_proc THEN
1489: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1490: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1491: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1492: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1493: END IF;
1486: x_result_type := po_validations.c_result_type_success;
1487:
1488: IF po_log.d_proc THEN
1489: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1490: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1491: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1492: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1493: END IF;
1494:
1487:
1488: IF po_log.d_proc THEN
1489: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1490: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1491: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1492: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1493: END IF;
1494:
1495: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and
1488: IF po_log.d_proc THEN
1489: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1490: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1491: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1492: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1493: END IF;
1494:
1495: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and
1496: -- not equal to NONE, REJECT or WARNING
1505: x_result_type := po_validations.c_result_type_failure;
1506: END IF;
1507: END LOOP;
1508:
1509: IF po_log.d_proc THEN
1510: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1511: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1512: END IF;
1513: EXCEPTION
1506: END IF;
1507: END LOOP;
1508:
1509: IF po_log.d_proc THEN
1510: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1511: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1512: END IF;
1513: EXCEPTION
1514: WHEN OTHERS THEN
1507: END LOOP;
1508:
1509: IF po_log.d_proc THEN
1510: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1511: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1512: END IF;
1513: EXCEPTION
1514: WHEN OTHERS THEN
1515: IF po_log.d_exc THEN
1511: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1512: END IF;
1513: EXCEPTION
1514: WHEN OTHERS THEN
1515: IF po_log.d_exc THEN
1516: po_log.exc(d_mod, 0, NULL);
1517: END IF;
1518:
1519: RAISE;
1512: END IF;
1513: EXCEPTION
1514: WHEN OTHERS THEN
1515: IF po_log.d_exc THEN
1516: po_log.exc(d_mod, 0, NULL);
1517: END IF;
1518:
1519: RAISE;
1520: END allow_sub_receipts_flag;
1537: END IF;
1538:
1539: x_result_type := po_validations.c_result_type_success;
1540:
1541: IF po_log.d_proc THEN
1542: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1543: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1544: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1545: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1538:
1539: x_result_type := po_validations.c_result_type_success;
1540:
1541: IF po_log.d_proc THEN
1542: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1543: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1544: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1545: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1546: END IF;
1539: x_result_type := po_validations.c_result_type_success;
1540:
1541: IF po_log.d_proc THEN
1542: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1543: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1544: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1545: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1546: END IF;
1547:
1540:
1541: IF po_log.d_proc THEN
1542: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1543: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1544: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1545: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1546: END IF;
1547:
1548: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
1541: IF po_log.d_proc THEN
1542: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1543: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1544: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1545: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1546: END IF;
1547:
1548: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
1549: -- and less than zero.
1559: x_result_type := po_validations.c_result_type_failure;
1560: END IF;
1561: END LOOP;
1562:
1563: IF po_log.d_proc THEN
1564: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1565: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1566: END IF;
1567: EXCEPTION
1560: END IF;
1561: END LOOP;
1562:
1563: IF po_log.d_proc THEN
1564: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1565: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1566: END IF;
1567: EXCEPTION
1568: WHEN OTHERS THEN
1561: END LOOP;
1562:
1563: IF po_log.d_proc THEN
1564: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1565: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1566: END IF;
1567: EXCEPTION
1568: WHEN OTHERS THEN
1569: IF po_log.d_exc THEN
1565: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1566: END IF;
1567: EXCEPTION
1568: WHEN OTHERS THEN
1569: IF po_log.d_exc THEN
1570: po_log.exc(d_mod, 0, NULL);
1571: END IF;
1572:
1573: RAISE;
1566: END IF;
1567: EXCEPTION
1568: WHEN OTHERS THEN
1569: IF po_log.d_exc THEN
1570: po_log.exc(d_mod, 0, NULL);
1571: END IF;
1572:
1573: RAISE;
1574: END days_early_receipt_allowed;
1591: END IF;
1592:
1593: x_result_type := po_validations.c_result_type_success;
1594:
1595: IF po_log.d_proc THEN
1596: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1597: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1598: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1599: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1592:
1593: x_result_type := po_validations.c_result_type_success;
1594:
1595: IF po_log.d_proc THEN
1596: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1597: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1598: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1599: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1600: END IF;
1593: x_result_type := po_validations.c_result_type_success;
1594:
1595: IF po_log.d_proc THEN
1596: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1597: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1598: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1599: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1600: END IF;
1601:
1594:
1595: IF po_log.d_proc THEN
1596: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1597: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1598: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1599: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1600: END IF;
1601:
1602: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
1595: IF po_log.d_proc THEN
1596: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1597: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1598: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1599: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1600: END IF;
1601:
1602: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
1603: -- and not 'NONE', 'REJECT' not 'WARNING'
1613: x_result_type := po_validations.c_result_type_failure;
1614: END IF;
1615: END LOOP;
1616:
1617: IF po_log.d_proc THEN
1618: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1619: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1620: END IF;
1621: EXCEPTION
1614: END IF;
1615: END LOOP;
1616:
1617: IF po_log.d_proc THEN
1618: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1619: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1620: END IF;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1615: END LOOP;
1616:
1617: IF po_log.d_proc THEN
1618: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1619: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1620: END IF;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: IF po_log.d_exc THEN
1619: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1620: END IF;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: IF po_log.d_exc THEN
1624: po_log.exc(d_mod, 0, NULL);
1625: END IF;
1626:
1627: RAISE;
1620: END IF;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: IF po_log.d_exc THEN
1624: po_log.exc(d_mod, 0, NULL);
1625: END IF;
1626:
1627: RAISE;
1628: END receipt_days_exception_code;
1645: END IF;
1646:
1647: x_result_type := po_validations.c_result_type_success;
1648:
1649: IF po_log.d_proc THEN
1650: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1651: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1652: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1653: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1646:
1647: x_result_type := po_validations.c_result_type_success;
1648:
1649: IF po_log.d_proc THEN
1650: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1651: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1652: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1653: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1654: END IF;
1647: x_result_type := po_validations.c_result_type_success;
1648:
1649: IF po_log.d_proc THEN
1650: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1651: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1652: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1653: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1654: END IF;
1655:
1648:
1649: IF po_log.d_proc THEN
1650: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1651: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1652: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1653: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1654: END IF;
1655:
1656: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
1649: IF po_log.d_proc THEN
1650: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1651: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1652: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1653: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1654: END IF;
1655:
1656: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
1657: -- and less than or equal to zero or greater than or equal to 100.
1667: x_result_type := po_validations.c_result_type_failure;
1668: END IF;
1669: END LOOP;
1670:
1671: IF po_log.d_proc THEN
1672: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1673: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1674: END IF;
1675: EXCEPTION
1668: END IF;
1669: END LOOP;
1670:
1671: IF po_log.d_proc THEN
1672: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1673: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS THEN
1669: END LOOP;
1670:
1671: IF po_log.d_proc THEN
1672: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1673: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF po_log.d_exc THEN
1673: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF po_log.d_exc THEN
1678: po_log.exc(d_mod, 0, NULL);
1679: END IF;
1680:
1681: RAISE;
1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF po_log.d_exc THEN
1678: po_log.exc(d_mod, 0, NULL);
1679: END IF;
1680:
1681: RAISE;
1682: END invoice_close_tolerance;
1699: END IF;
1700:
1701: x_result_type := po_validations.c_result_type_success;
1702:
1703: IF po_log.d_proc THEN
1704: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1705: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1706: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1707: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1700:
1701: x_result_type := po_validations.c_result_type_success;
1702:
1703: IF po_log.d_proc THEN
1704: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1705: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1706: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1707: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1708: END IF;
1701: x_result_type := po_validations.c_result_type_success;
1702:
1703: IF po_log.d_proc THEN
1704: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1705: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1706: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1707: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1708: END IF;
1709:
1702:
1703: IF po_log.d_proc THEN
1704: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1705: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1706: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1707: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1708: END IF;
1709:
1710: -- If shipment_type is STANDARD and receive_close_tolerance is not null
1703: IF po_log.d_proc THEN
1704: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1705: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1706: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1707: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1708: END IF;
1709:
1710: -- If shipment_type is STANDARD and receive_close_tolerance is not null
1711: -- and less than or equal to zero or greater than or equal to 100.
1721: x_result_type := po_validations.c_result_type_failure;
1722: END IF;
1723: END LOOP;
1724:
1725: IF po_log.d_proc THEN
1726: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1727: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1728: END IF;
1729: EXCEPTION
1722: END IF;
1723: END LOOP;
1724:
1725: IF po_log.d_proc THEN
1726: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1727: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1728: END IF;
1729: EXCEPTION
1730: WHEN OTHERS THEN
1723: END LOOP;
1724:
1725: IF po_log.d_proc THEN
1726: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1727: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1728: END IF;
1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: IF po_log.d_exc THEN
1727: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1728: END IF;
1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: IF po_log.d_exc THEN
1732: po_log.exc(d_mod, 0, NULL);
1733: END IF;
1734:
1735: RAISE;
1728: END IF;
1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: IF po_log.d_exc THEN
1732: po_log.exc(d_mod, 0, NULL);
1733: END IF;
1734:
1735: RAISE;
1736: END receive_close_tolerance;
1752: END IF;
1753:
1754: x_result_type := po_validations.c_result_type_success;
1755:
1756: IF po_log.d_proc THEN
1757: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1758: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1759: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1760: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1753:
1754: x_result_type := po_validations.c_result_type_success;
1755:
1756: IF po_log.d_proc THEN
1757: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1758: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1759: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1760: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1761: END IF;
1754: x_result_type := po_validations.c_result_type_success;
1755:
1756: IF po_log.d_proc THEN
1757: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1758: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1759: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1760: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1761: END IF;
1762:
1755:
1756: IF po_log.d_proc THEN
1757: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1758: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1759: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1760: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1761: END IF;
1762:
1763: -- Validate that receiving routing id exists in rcv_routing_headers
1756: IF po_log.d_proc THEN
1757: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1758: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1759: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1760: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1761: END IF;
1762:
1763: -- Validate that receiving routing id exists in rcv_routing_headers
1764: FORALL i IN 1 .. p_id_tbl.COUNT
1791: IF (SQL%ROWCOUNT > 0) THEN
1792: x_result_type := po_validations.c_result_type_failure;
1793: END IF;
1794:
1795: IF po_log.d_proc THEN
1796: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1797: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1798: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1799: END IF;
1793: END IF;
1794:
1795: IF po_log.d_proc THEN
1796: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1797: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1798: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1799: END IF;
1800: EXCEPTION
1801: WHEN OTHERS THEN
1794:
1795: IF po_log.d_proc THEN
1796: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1797: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1798: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1799: END IF;
1800: EXCEPTION
1801: WHEN OTHERS THEN
1802: IF po_log.d_exc THEN
1798: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1799: END IF;
1800: EXCEPTION
1801: WHEN OTHERS THEN
1802: IF po_log.d_exc THEN
1803: po_log.exc(d_mod, 0, NULL);
1804: END IF;
1805:
1806: RAISE;
1799: END IF;
1800: EXCEPTION
1801: WHEN OTHERS THEN
1802: IF po_log.d_exc THEN
1803: po_log.exc(d_mod, 0, NULL);
1804: END IF;
1805:
1806: RAISE;
1807: END receiving_routing_id;
1822: END IF;
1823:
1824: x_result_type := po_validations.c_result_type_success;
1825:
1826: IF po_log.d_proc THEN
1827: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1828: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
1829: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1830: END IF;
1823:
1824: x_result_type := po_validations.c_result_type_success;
1825:
1826: IF po_log.d_proc THEN
1827: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1828: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
1829: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1830: END IF;
1831:
1824: x_result_type := po_validations.c_result_type_success;
1825:
1826: IF po_log.d_proc THEN
1827: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1828: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
1829: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1830: END IF;
1831:
1832: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1825:
1826: IF po_log.d_proc THEN
1827: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1828: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
1829: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1830: END IF;
1831:
1832: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1833: IF (p_accrue_on_receipt_flag_tbl(i) IS NOT NULL AND p_accrue_on_receipt_flag_tbl(i) NOT IN('N', 'Y')) THEN
1839: x_result_type := po_validations.c_result_type_failure;
1840: END IF;
1841: END LOOP;
1842:
1843: IF po_log.d_proc THEN
1844: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1845: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1846: END IF;
1847: EXCEPTION
1840: END IF;
1841: END LOOP;
1842:
1843: IF po_log.d_proc THEN
1844: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1845: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1846: END IF;
1847: EXCEPTION
1848: WHEN OTHERS THEN
1841: END LOOP;
1842:
1843: IF po_log.d_proc THEN
1844: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1845: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1846: END IF;
1847: EXCEPTION
1848: WHEN OTHERS THEN
1849: IF po_log.d_exc THEN
1845: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1846: END IF;
1847: EXCEPTION
1848: WHEN OTHERS THEN
1849: IF po_log.d_exc THEN
1850: po_log.exc(d_mod, 0, NULL);
1851: END IF;
1852:
1853: RAISE;
1846: END IF;
1847: EXCEPTION
1848: WHEN OTHERS THEN
1849: IF po_log.d_exc THEN
1850: po_log.exc(d_mod, 0, NULL);
1851: END IF;
1852:
1853: RAISE;
1854: END accrue_on_receipt_flag;
1873: END IF;
1874:
1875: x_result_type := po_validations.c_result_type_success;
1876:
1877: IF po_log.d_proc THEN
1878: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1879: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
1880: po_log.proc_begin(d_mod, 'p_advance_tbl', p_advance_tbl);
1881: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
1874:
1875: x_result_type := po_validations.c_result_type_success;
1876:
1877: IF po_log.d_proc THEN
1878: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1879: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
1880: po_log.proc_begin(d_mod, 'p_advance_tbl', p_advance_tbl);
1881: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
1882: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1875: x_result_type := po_validations.c_result_type_success;
1876:
1877: IF po_log.d_proc THEN
1878: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1879: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
1880: po_log.proc_begin(d_mod, 'p_advance_tbl', p_advance_tbl);
1881: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
1882: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1883: po_log.proc_begin(d_mod, 'p_price_tbl', p_price_tbl);
1876:
1877: IF po_log.d_proc THEN
1878: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1879: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
1880: po_log.proc_begin(d_mod, 'p_advance_tbl', p_advance_tbl);
1881: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
1882: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1883: po_log.proc_begin(d_mod, 'p_price_tbl', p_price_tbl);
1884: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1877: IF po_log.d_proc THEN
1878: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1879: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
1880: po_log.proc_begin(d_mod, 'p_advance_tbl', p_advance_tbl);
1881: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
1882: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1883: po_log.proc_begin(d_mod, 'p_price_tbl', p_price_tbl);
1884: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1885: END IF;
1878: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1879: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
1880: po_log.proc_begin(d_mod, 'p_advance_tbl', p_advance_tbl);
1881: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
1882: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1883: po_log.proc_begin(d_mod, 'p_price_tbl', p_price_tbl);
1884: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1885: END IF;
1886:
1879: po_log.proc_begin(d_mod, 'p_payment_type_tbl', p_payment_type_tbl);
1880: po_log.proc_begin(d_mod, 'p_advance_tbl', p_advance_tbl);
1881: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
1882: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1883: po_log.proc_begin(d_mod, 'p_price_tbl', p_price_tbl);
1884: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1885: END IF;
1886:
1887: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1880: po_log.proc_begin(d_mod, 'p_advance_tbl', p_advance_tbl);
1881: po_log.proc_begin(d_mod, 'p_amount_tbl', p_amount_tbl);
1882: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
1883: po_log.proc_begin(d_mod, 'p_price_tbl', p_price_tbl);
1884: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1885: END IF;
1886:
1887: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1888: IF (p_advance_tbl(i) IS NOT NULL AND Nvl(p_payment_type_tbl(i),'DELIVERY') = 'ADVANCE') THEN
1898: END IF;
1899: END IF;
1900: END LOOP;
1901:
1902: IF po_log.d_proc THEN
1903: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1904: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1905: END IF;
1906: EXCEPTION
1899: END IF;
1900: END LOOP;
1901:
1902: IF po_log.d_proc THEN
1903: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1904: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1905: END IF;
1906: EXCEPTION
1907: WHEN OTHERS THEN
1900: END LOOP;
1901:
1902: IF po_log.d_proc THEN
1903: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1904: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1905: END IF;
1906: EXCEPTION
1907: WHEN OTHERS THEN
1908: IF po_log.d_exc THEN
1904: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1905: END IF;
1906: EXCEPTION
1907: WHEN OTHERS THEN
1908: IF po_log.d_exc THEN
1909: po_log.exc(d_mod, 0, NULL);
1910: END IF;
1911:
1912: RAISE;
1905: END IF;
1906: EXCEPTION
1907: WHEN OTHERS THEN
1908: IF po_log.d_exc THEN
1909: po_log.exc(d_mod, 0, NULL);
1910: END IF;
1911:
1912: RAISE;
1913: END advance_amt_le_amt;
1926: IF x_result_set_id IS NULL THEN
1927: x_result_set_id := po_validations.next_result_set_id();
1928: END IF;
1929:
1930: IF po_log.d_proc THEN
1931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1932: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1933: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1934: END IF;
1927: x_result_set_id := po_validations.next_result_set_id();
1928: END IF;
1929:
1930: IF po_log.d_proc THEN
1931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1932: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1933: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1934: END IF;
1935:
1928: END IF;
1929:
1930: IF po_log.d_proc THEN
1931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1932: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1933: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1934: END IF;
1935:
1936: x_result_type := po_validations.c_result_type_success;
1929:
1930: IF po_log.d_proc THEN
1931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1932: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1933: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1934: END IF;
1935:
1936: x_result_type := po_validations.c_result_type_success;
1937:
1969: IF (SQL%ROWCOUNT > 0) THEN
1970: x_result_type := po_validations.c_result_type_failure;
1971: END IF;
1972:
1973: IF po_log.d_proc THEN
1974: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1975: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1976: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1977: END IF;
1971: END IF;
1972:
1973: IF po_log.d_proc THEN
1974: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1975: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1976: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1977: END IF;
1978: EXCEPTION
1979: WHEN OTHERS THEN
1972:
1973: IF po_log.d_proc THEN
1974: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1975: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1976: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1977: END IF;
1978: EXCEPTION
1979: WHEN OTHERS THEN
1980: IF po_log.d_exc THEN
1976: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1977: END IF;
1978: EXCEPTION
1979: WHEN OTHERS THEN
1980: IF po_log.d_exc THEN
1981: po_log.exc(d_mod, 0, NULL);
1982: END IF;
1983: RAISE;
1984:
1977: END IF;
1978: EXCEPTION
1979: WHEN OTHERS THEN
1980: IF po_log.d_exc THEN
1981: po_log.exc(d_mod, 0, NULL);
1982: END IF;
1983: RAISE;
1984:
1985: END style_related_info;
2004: IF x_result_set_id IS NULL THEN
2005: x_result_set_id := po_validations.next_result_set_id();
2006: END IF;
2007:
2008: IF po_log.d_proc THEN
2009: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2010: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
2011: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
2012: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2005: x_result_set_id := po_validations.next_result_set_id();
2006: END IF;
2007:
2008: IF po_log.d_proc THEN
2009: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2010: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
2011: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
2012: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2013: END IF;
2006: END IF;
2007:
2008: IF po_log.d_proc THEN
2009: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2010: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
2011: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
2012: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2013: END IF;
2014:
2007:
2008: IF po_log.d_proc THEN
2009: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2010: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
2011: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
2012: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2013: END IF;
2014:
2015: x_result_type := po_validations.c_result_type_success;
2008: IF po_log.d_proc THEN
2009: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2010: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
2011: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
2012: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2013: END IF;
2014:
2015: x_result_type := po_validations.c_result_type_success;
2016:
2102: IF (SQL%ROWCOUNT > 0) THEN
2103: x_result_type := po_validations.c_result_type_failure;
2104: END IF;
2105:
2106: IF po_log.d_proc THEN
2107: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2108: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2109: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2110: END IF;
2104: END IF;
2105:
2106: IF po_log.d_proc THEN
2107: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2108: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2109: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2110: END IF;
2111: EXCEPTION
2112: WHEN OTHERS THEN
2105:
2106: IF po_log.d_proc THEN
2107: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2108: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2109: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2110: END IF;
2111: EXCEPTION
2112: WHEN OTHERS THEN
2113: IF po_log.d_exc THEN
2109: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2110: END IF;
2111: EXCEPTION
2112: WHEN OTHERS THEN
2113: IF po_log.d_exc THEN
2114: po_log.exc(d_mod, 0, NULL);
2115: END IF;
2116:
2117: RAISE;
2110: END IF;
2111: EXCEPTION
2112: WHEN OTHERS THEN
2113: IF po_log.d_exc THEN
2114: po_log.exc(d_mod, 0, NULL);
2115: END IF;
2116:
2117: RAISE;
2118: END tax_name;
2130: IF x_result_set_id IS NULL THEN
2131: x_result_set_id := po_validations.next_result_set_id();
2132: END IF;
2133:
2134: IF po_log.d_proc THEN
2135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2136: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
2137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2138: END IF;
2131: x_result_set_id := po_validations.next_result_set_id();
2132: END IF;
2133:
2134: IF po_log.d_proc THEN
2135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2136: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
2137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2138: END IF;
2139:
2132: END IF;
2133:
2134: IF po_log.d_proc THEN
2135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2136: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
2137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2138: END IF;
2139:
2140: x_result_type := po_validations.c_result_type_success;
2133:
2134: IF po_log.d_proc THEN
2135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2136: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
2137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2138: END IF;
2139:
2140: x_result_type := po_validations.c_result_type_success;
2141:
2173: IF (SQL%ROWCOUNT > 0) THEN
2174: x_result_type := po_validations.c_result_type_failure;
2175: END IF;
2176:
2177: IF po_log.d_proc THEN
2178: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2179: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2180: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2181: END IF;
2175: END IF;
2176:
2177: IF po_log.d_proc THEN
2178: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2179: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2180: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2181: END IF;
2182: EXCEPTION
2183: WHEN OTHERS THEN
2176:
2177: IF po_log.d_proc THEN
2178: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2179: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2180: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2181: END IF;
2182: EXCEPTION
2183: WHEN OTHERS THEN
2184: IF po_log.d_exc THEN
2180: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2181: END IF;
2182: EXCEPTION
2183: WHEN OTHERS THEN
2184: IF po_log.d_exc THEN
2185: po_log.exc(d_mod, 0, NULL);
2186: END IF;
2187: RAISE;
2188:
2181: END IF;
2182: EXCEPTION
2183: WHEN OTHERS THEN
2184: IF po_log.d_exc THEN
2185: po_log.exc(d_mod, 0, NULL);
2186: END IF;
2187: RAISE;
2188:
2189: END fob_lookup_code;
2201: IF x_result_set_id IS NULL THEN
2202: x_result_set_id := po_validations.next_result_set_id();
2203: END IF;
2204:
2205: IF po_log.d_proc THEN
2206: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2207: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);
2208: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2209: END IF;
2202: x_result_set_id := po_validations.next_result_set_id();
2203: END IF;
2204:
2205: IF po_log.d_proc THEN
2206: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2207: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);
2208: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2209: END IF;
2210:
2203: END IF;
2204:
2205: IF po_log.d_proc THEN
2206: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2207: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);
2208: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2209: END IF;
2210:
2211: x_result_type := po_validations.c_result_type_success;
2204:
2205: IF po_log.d_proc THEN
2206: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2207: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);
2208: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2209: END IF;
2210:
2211: x_result_type := po_validations.c_result_type_success;
2212:
2244: IF (SQL%ROWCOUNT > 0) THEN
2245: x_result_type := po_validations.c_result_type_failure;
2246: END IF;
2247:
2248: IF po_log.d_proc THEN
2249: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2250: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2251: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2252: END IF;
2246: END IF;
2247:
2248: IF po_log.d_proc THEN
2249: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2250: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2251: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2252: END IF;
2253: EXCEPTION
2254: WHEN OTHERS THEN
2247:
2248: IF po_log.d_proc THEN
2249: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2250: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2251: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2252: END IF;
2253: EXCEPTION
2254: WHEN OTHERS THEN
2255: IF po_log.d_exc THEN
2251: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2252: END IF;
2253: EXCEPTION
2254: WHEN OTHERS THEN
2255: IF po_log.d_exc THEN
2256: po_log.exc(d_mod, 0, NULL);
2257: END IF;
2258: RAISE;
2259:
2252: END IF;
2253: EXCEPTION
2254: WHEN OTHERS THEN
2255: IF po_log.d_exc THEN
2256: po_log.exc(d_mod, 0, NULL);
2257: END IF;
2258: RAISE;
2259:
2260: END freight_terms;
2273: IF x_result_set_id IS NULL THEN
2274: x_result_set_id := po_validations.next_result_set_id();
2275: END IF;
2276:
2277: IF po_log.d_proc THEN
2278: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2279: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
2280: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2281: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2274: x_result_set_id := po_validations.next_result_set_id();
2275: END IF;
2276:
2277: IF po_log.d_proc THEN
2278: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2279: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
2280: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2281: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2282: END IF;
2275: END IF;
2276:
2277: IF po_log.d_proc THEN
2278: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2279: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
2280: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2281: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2282: END IF;
2283:
2276:
2277: IF po_log.d_proc THEN
2278: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2279: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
2280: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2281: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2282: END IF;
2283:
2284: x_result_type := po_validations.c_result_type_success;
2277: IF po_log.d_proc THEN
2278: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2279: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
2280: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
2281: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2282: END IF;
2283:
2284: x_result_type := po_validations.c_result_type_success;
2285:
2317: IF (SQL%ROWCOUNT > 0) THEN
2318: x_result_type := po_validations.c_result_type_failure;
2319: END IF;
2320:
2321: IF po_log.d_proc THEN
2322: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2323: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2324: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2325: END IF;
2319: END IF;
2320:
2321: IF po_log.d_proc THEN
2322: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2323: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2324: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2325: END IF;
2326: EXCEPTION
2327: WHEN OTHERS THEN
2320:
2321: IF po_log.d_proc THEN
2322: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2323: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2324: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2325: END IF;
2326: EXCEPTION
2327: WHEN OTHERS THEN
2328: IF po_log.d_exc THEN
2324: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2325: END IF;
2326: EXCEPTION
2327: WHEN OTHERS THEN
2328: IF po_log.d_exc THEN
2329: po_log.exc(d_mod, 0, NULL);
2330: END IF;
2331: RAISE;
2332:
2325: END IF;
2326: EXCEPTION
2327: WHEN OTHERS THEN
2328: IF po_log.d_exc THEN
2329: po_log.exc(d_mod, 0, NULL);
2330: END IF;
2331: RAISE;
2332:
2333: END freight_carrier;
2349: END IF;
2350:
2351: x_result_type := po_validations.c_result_type_success;
2352:
2353: IF po_log.d_proc THEN
2354: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2355: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2356: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2357: END IF;
2350:
2351: x_result_type := po_validations.c_result_type_success;
2352:
2353: IF po_log.d_proc THEN
2354: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2355: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2356: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2357: END IF;
2358:
2351: x_result_type := po_validations.c_result_type_success;
2352:
2353: IF po_log.d_proc THEN
2354: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2355: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2356: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2357: END IF;
2358:
2359: FOR i IN 1 .. p_id_tbl.COUNT LOOP
2352:
2353: IF po_log.d_proc THEN
2354: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
2355: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
2356: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
2357: END IF;
2358:
2359: FOR i IN 1 .. p_id_tbl.COUNT LOOP
2360: IF (p_order_type_lookup_code_tbl(i) IN ('AMOUNT', 'FIXED PRICE')) THEN
2367: x_result_type := po_validations.c_result_type_failure;
2368: END IF;
2369: END LOOP;
2370:
2371: IF po_log.d_proc THEN
2372: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2373: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2374: END IF;
2375: EXCEPTION
2368: END IF;
2369: END LOOP;
2370:
2371: IF po_log.d_proc THEN
2372: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2373: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2374: END IF;
2375: EXCEPTION
2376: WHEN OTHERS THEN
2369: END LOOP;
2370:
2371: IF po_log.d_proc THEN
2372: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2373: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2374: END IF;
2375: EXCEPTION
2376: WHEN OTHERS THEN
2377: IF po_log.d_exc THEN
2373: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
2374: END IF;
2375: EXCEPTION
2376: WHEN OTHERS THEN
2377: IF po_log.d_exc THEN
2378: po_log.exc(d_mod, 0, NULL);
2379: END IF;
2380:
2381: RAISE;
2374: END IF;
2375: EXCEPTION
2376: WHEN OTHERS THEN
2377: IF po_log.d_exc THEN
2378: po_log.exc(d_mod, 0, NULL);
2379: END IF;
2380:
2381: RAISE;
2382: END price_break;