eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_LOG

Line 5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_SHIPMENTS2');

1: PACKAGE BODY PO_VAL_SHIPMENTS2 AS
2: -- $Header: PO_VAL_SHIPMENTS2.plb 120.17.12010000.2 2008/10/29 11:47:48 lswamina 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');

Line 8: d_need_by_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'NEED_BY_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_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');

Line 9: d_promised_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROMISED_DATE');

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_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');

Line 10: d_shipment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_TYPE');

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_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');

Line 11: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');

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_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');

Line 12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');

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_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');

Line 13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');

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_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');

Line 14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');

10: d_shipment_type CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_TYPE');
11: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');

Line 15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');

11: d_shipment_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPMENT_NUM');
12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');

Line 16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');

12: d_quantity CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY');
13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');

Line 17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');

13: d_price_override CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_OVERRIDE');
14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');

Line 18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');

14: d_price_discount CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_DISCOUNT');
15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');

Line 19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');

15: d_ship_to_organization_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_ORGANIZATION_ID');
16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');

Line 20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');

16: d_price_break_attributes CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK_ATTRIBUTES');
17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');

Line 21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');

17: d_effective_dates CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'EFFECTIVE_DATES');
18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');

Line 22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');

18: d_qty_rcv_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QTY_RCV_EXCEPTION_CODE');
19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');

Line 23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');

19: d_enforce_ship_to_loc_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ENFORCE_SHIP_TO_LOC_CODE');
20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');

Line 24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');

20: d_allow_sub_receipts_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ALLOW_SUB_RECEIPTS_FLAG');
21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');

Line 25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');

21: d_days_early_receipt_allowed CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DAYS_EARLY_RECEIPT_ALLOWD');
22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
29: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');

Line 26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');

22: d_receipt_days_exception_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIPT_DAYS_EXCEPTION_CODE');
23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
29: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
30: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');

Line 27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');

23: d_invoice_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'INVOICE_CLOSE_TOLERANCE');
24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
29: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
30: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
31: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');

Line 28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');

24: d_receive_close_tolerance CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVE_CLOSE_TOLERANCE');
25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
29: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
30: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
31: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
32: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');

Line 29: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');

25: d_receiving_routing_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RECEIVING_ROUTING_ID');
26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
29: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
30: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
31: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
32: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');
33:

Line 30: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');

26: d_accrue_on_receipt_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCRUE_ON_RECEIPT_FLAG');
27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
29: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
30: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
31: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
32: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');
33:
34: -- Indicates that the calling program is PDOI.

Line 31: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');

27: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
29: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
30: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
31: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
32: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');
33:
34: -- Indicates that the calling program is PDOI.
35: c_program_pdoi CONSTANT VARCHAR2(10) := 'PDOI';

Line 32: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');

28: d_freight_terms CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS');
29: d_freight_carrier CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_CARRIER');
30: d_style_related_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_RELATED_INFO');
31: d_tax_name CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_NAME');
32: d_price_break CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRICE_BREAK');
33:
34: -- Indicates that the calling program is PDOI.
35: c_program_pdoi CONSTANT VARCHAR2(10) := 'PDOI';
36: -- The application name of PO.

Line 57: IF po_log.d_proc THEN

53: END IF;
54:
55: x_result_type := po_validations.c_result_type_success;
56:
57: IF po_log.d_proc THEN
58: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
59: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
60: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
61: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 58: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

54:
55: x_result_type := po_validations.c_result_type_success;
56:
57: IF po_log.d_proc THEN
58: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
59: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
60: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
61: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
62: END IF;

Line 59: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);

55: x_result_type := po_validations.c_result_type_success;
56:
57: IF po_log.d_proc THEN
58: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
59: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
60: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
61: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
62: END IF;
63:

Line 60: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);

56:
57: IF po_log.d_proc THEN
58: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
59: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
60: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
61: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
62: END IF;
63:
64: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null

Line 61: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

57: IF po_log.d_proc THEN
58: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
59: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
60: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
61: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
62: END IF;
63:
64: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
65: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 77: IF po_log.d_proc THEN

73: x_result_type := po_validations.c_result_type_failure;
74: END IF;
75: END LOOP;
76:
77: IF po_log.d_proc THEN
78: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
79: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
80: END IF;
81: EXCEPTION

Line 78: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

74: END IF;
75: END LOOP;
76:
77: IF po_log.d_proc THEN
78: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
79: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
80: END IF;
81: EXCEPTION
82: WHEN OTHERS THEN

Line 79: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

75: END LOOP;
76:
77: IF po_log.d_proc THEN
78: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
79: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
80: END IF;
81: EXCEPTION
82: WHEN OTHERS THEN
83: IF po_log.d_exc THEN

Line 83: IF po_log.d_exc THEN

79: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
80: END IF;
81: EXCEPTION
82: WHEN OTHERS THEN
83: IF po_log.d_exc THEN
84: po_log.exc(d_mod, 0, NULL);
85: END IF;
86:
87: RAISE;

Line 84: po_log.exc(d_mod, 0, NULL);

80: END IF;
81: EXCEPTION
82: WHEN OTHERS THEN
83: IF po_log.d_exc THEN
84: po_log.exc(d_mod, 0, NULL);
85: END IF;
86:
87: RAISE;
88: END need_by_date;

Line 108: IF po_log.d_proc THEN

104: END IF;
105:
106: x_result_type := po_validations.c_result_type_success;
107:
108: IF po_log.d_proc THEN
109: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
110: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
111: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
112: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 109: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

105:
106: x_result_type := po_validations.c_result_type_success;
107:
108: IF po_log.d_proc THEN
109: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
110: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
111: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
112: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
113: END IF;

Line 110: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);

106: x_result_type := po_validations.c_result_type_success;
107:
108: IF po_log.d_proc THEN
109: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
110: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
111: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
112: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
113: END IF;
114:

Line 111: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);

107:
108: IF po_log.d_proc THEN
109: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
110: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
111: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
112: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
113: END IF;
114:
115: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null

Line 112: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

108: IF po_log.d_proc THEN
109: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
110: po_log.proc_begin(d_mod, 'p_purchase_basis_tbl', p_purchase_basis_tbl);
111: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
112: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
113: END IF;
114:
115: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
116: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 128: IF po_log.d_proc THEN

124: x_result_type := po_validations.c_result_type_failure;
125: END IF;
126: END LOOP;
127:
128: IF po_log.d_proc THEN
129: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
130: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
131: END IF;
132: EXCEPTION

Line 129: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

125: END IF;
126: END LOOP;
127:
128: IF po_log.d_proc THEN
129: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
130: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN

Line 130: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

126: END LOOP;
127:
128: IF po_log.d_proc THEN
129: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
130: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF po_log.d_exc THEN

Line 134: IF po_log.d_exc THEN

130: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF po_log.d_exc THEN
135: po_log.exc(d_mod, 0, NULL);
136: END IF;
137:
138: RAISE;

Line 135: po_log.exc(d_mod, 0, NULL);

131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF po_log.d_exc THEN
135: po_log.exc(d_mod, 0, NULL);
136: END IF;
137:
138: RAISE;
139: END promised_date;

Line 159: IF po_log.d_proc THEN

155: END IF;
156:
157: x_result_type := po_validations.c_result_type_success;
158:
159: IF po_log.d_proc THEN
160: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
161: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
162: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
163: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 160: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

156:
157: x_result_type := po_validations.c_result_type_success;
158:
159: IF po_log.d_proc THEN
160: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
161: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
162: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
163: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
164: END IF;

Line 161: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

157: x_result_type := po_validations.c_result_type_success;
158:
159: IF po_log.d_proc THEN
160: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
161: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
162: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
163: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
164: END IF;
165:

Line 162: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);

158:
159: IF po_log.d_proc THEN
160: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
161: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
162: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
163: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
164: END IF;
165:
166: -- if shipment_type is Null

Line 163: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

159: IF po_log.d_proc THEN
160: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
161: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
162: po_log.proc_begin(d_mod, 'p_doc_type', p_doc_type);
163: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
164: END IF;
165:
166: -- if shipment_type is Null
167: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 189: IF po_log.d_proc THEN

185: x_result_type := po_validations.c_result_type_failure;
186: END IF;
187: END LOOP;
188:
189: IF po_log.d_proc THEN
190: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
191: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
192: END IF;
193: EXCEPTION

Line 190: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

186: END IF;
187: END LOOP;
188:
189: IF po_log.d_proc THEN
190: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
191: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
192: END IF;
193: EXCEPTION
194: WHEN OTHERS THEN

Line 191: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

187: END LOOP;
188:
189: IF po_log.d_proc THEN
190: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
191: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
192: END IF;
193: EXCEPTION
194: WHEN OTHERS THEN
195: IF po_log.d_exc THEN

Line 195: IF po_log.d_exc THEN

191: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
192: END IF;
193: EXCEPTION
194: WHEN OTHERS THEN
195: IF po_log.d_exc THEN
196: po_log.exc(d_mod, 0, NULL);
197: END IF;
198:
199: RAISE;

Line 196: po_log.exc(d_mod, 0, NULL);

192: END IF;
193: EXCEPTION
194: WHEN OTHERS THEN
195: IF po_log.d_exc THEN
196: po_log.exc(d_mod, 0, NULL);
197: END IF;
198:
199: RAISE;
200: END shipment_type;

Line 227: IF po_log.d_proc THEN

223: IF (x_results IS NULL) THEN
224: x_results := po_validation_results_type.new_instance();
225: END IF;
226:
227: IF po_log.d_proc THEN
228: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
229: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
230: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);

Line 228: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

224: x_results := po_validation_results_type.new_instance();
225: END IF;
226:
227: IF po_log.d_proc THEN
228: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
229: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
230: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
232: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);

Line 229: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);

225: END IF;
226:
227: IF po_log.d_proc THEN
228: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
229: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
230: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
232: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
233: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);

Line 230: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

226:
227: IF po_log.d_proc THEN
228: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
229: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
230: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
232: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
233: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
234: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);

227: IF po_log.d_proc THEN
228: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
229: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
230: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
232: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
233: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
234: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
235: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 232: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);

228: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
229: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
230: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
232: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
233: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
234: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
235: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
236: END IF;

Line 233: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);

229: po_log.proc_begin(d_mod, 'p_shipment_num_tbl', p_shipment_num_tbl);
230: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
232: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
233: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
234: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
235: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
236: END IF;
237:

Line 234: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

230: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
232: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
233: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
234: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
235: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
236: END IF;
237:
238: x_result_type := po_validations.c_result_type_success;

Line 235: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

231: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
232: po_log.proc_begin(d_mod, 'p_po_line_id_tbl', p_po_line_id_tbl);
233: po_log.proc_begin(d_mod, 'p_draft_id_tbl', p_draft_id_tbl);
234: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
235: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
236: END IF;
237:
238: x_result_type := po_validations.c_result_type_success;
239:

Line 314: IF po_log.d_proc THEN

310: IF (SQL%ROWCOUNT > 0) THEN
311: x_result_type := po_validations.c_result_type_failure;
312: END IF;
313:
314: IF po_log.d_proc THEN
315: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
316: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
317: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
318: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

Line 316: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

312: END IF;
313:
314: IF po_log.d_proc THEN
315: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
316: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
317: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
318: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
319: END IF;
320: EXCEPTION

Line 317: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

313:
314: IF po_log.d_proc THEN
315: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
316: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
317: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
318: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
319: END IF;
320: EXCEPTION
321: WHEN OTHERS THEN

Line 318: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

314: IF po_log.d_proc THEN
315: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
316: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
317: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
318: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
319: END IF;
320: EXCEPTION
321: WHEN OTHERS THEN
322: IF po_log.d_exc THEN

Line 322: IF po_log.d_exc THEN

318: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
319: END IF;
320: EXCEPTION
321: WHEN OTHERS THEN
322: IF po_log.d_exc THEN
323: po_log.exc(d_mod, 0, NULL);
324: END IF;
325:
326: RAISE;

Line 323: po_log.exc(d_mod, 0, NULL);

319: END IF;
320: EXCEPTION
321: WHEN OTHERS THEN
322: IF po_log.d_exc THEN
323: po_log.exc(d_mod, 0, NULL);
324: END IF;
325:
326: RAISE;
327: END shipment_num;

Line 349: IF po_log.d_proc THEN

345: END IF;
346:
347: x_result_type := po_validations.c_result_type_success;
348:
349: IF po_log.d_proc THEN
350: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
351: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
352: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
353: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 350: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

346:
347: x_result_type := po_validations.c_result_type_success;
348:
349: IF po_log.d_proc THEN
350: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
351: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
352: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
353: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
354: END IF;

Line 351: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);

347: x_result_type := po_validations.c_result_type_success;
348:
349: IF po_log.d_proc THEN
350: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
351: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
352: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
353: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
354: END IF;
355:

Line 352: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);

348:
349: IF po_log.d_proc THEN
350: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
351: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
352: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
353: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
354: END IF;
355:
356: -- If order_type_lookup_code is RATE or FIXED PRICE,

Line 353: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

349: IF po_log.d_proc THEN
350: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
351: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
352: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
353: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
354: END IF;
355:
356: -- If order_type_lookup_code is RATE or FIXED PRICE,
357: -- validate quantity must be null

Line 386: IF po_log.d_proc THEN

382:
383: END IF;
384: END LOOP;
385:
386: IF po_log.d_proc THEN
387: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
388: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
389: END IF;
390: EXCEPTION

Line 387: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

383: END IF;
384: END LOOP;
385:
386: IF po_log.d_proc THEN
387: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
388: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
389: END IF;
390: EXCEPTION
391: WHEN OTHERS THEN

Line 388: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

384: END LOOP;
385:
386: IF po_log.d_proc THEN
387: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
388: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
389: END IF;
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF po_log.d_exc THEN

Line 392: IF po_log.d_exc THEN

388: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
389: END IF;
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF po_log.d_exc THEN
393: po_log.exc(d_mod, 0, NULL);
394: END IF;
395:
396: RAISE;

Line 393: po_log.exc(d_mod, 0, NULL);

389: END IF;
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF po_log.d_exc THEN
393: po_log.exc(d_mod, 0, NULL);
394: END IF;
395:
396: RAISE;
397: END quantity;

Line 417: IF po_log.d_proc THEN

413: END IF;
414:
415: x_result_type := po_validations.c_result_type_success;
416:
417: IF po_log.d_proc THEN
418: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
419: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
420: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
421: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 418: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

414:
415: x_result_type := po_validations.c_result_type_success;
416:
417: IF po_log.d_proc THEN
418: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
419: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
420: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
421: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
422: END IF;

Line 419: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);

415: x_result_type := po_validations.c_result_type_success;
416:
417: IF po_log.d_proc THEN
418: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
419: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
420: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
421: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
422: END IF;
423:

Line 420: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);

416:
417: IF po_log.d_proc THEN
418: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
419: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
420: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
421: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
422: END IF;
423:
424: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null

Line 421: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

417: IF po_log.d_proc THEN
418: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
419: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
420: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
421: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
422: END IF;
423:
424: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null
425: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 451: IF po_log.d_proc THEN

447: x_result_type := po_validations.c_result_type_failure;
448: END IF;
449: END LOOP;
450:
451: IF po_log.d_proc THEN
452: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
453: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
454: END IF;
455: EXCEPTION

Line 452: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

448: END IF;
449: END LOOP;
450:
451: IF po_log.d_proc THEN
452: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
453: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
454: END IF;
455: EXCEPTION
456: WHEN OTHERS THEN

Line 453: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

449: END LOOP;
450:
451: IF po_log.d_proc THEN
452: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
453: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
454: END IF;
455: EXCEPTION
456: WHEN OTHERS THEN
457: IF po_log.d_exc THEN

Line 457: IF po_log.d_exc THEN

453: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
454: END IF;
455: EXCEPTION
456: WHEN OTHERS THEN
457: IF po_log.d_exc THEN
458: po_log.exc(d_mod, 0, NULL);
459: END IF;
460:
461: RAISE;

Line 458: po_log.exc(d_mod, 0, NULL);

454: END IF;
455: EXCEPTION
456: WHEN OTHERS THEN
457: IF po_log.d_exc THEN
458: po_log.exc(d_mod, 0, NULL);
459: END IF;
460:
461: RAISE;
462: END price_override;

Line 484: IF po_log.d_proc THEN

480: END IF;
481:
482: x_result_type := po_validations.c_result_type_success;
483:
484: IF po_log.d_proc THEN
485: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
486: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
487: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
488: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);

Line 485: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

481:
482: x_result_type := po_validations.c_result_type_success;
483:
484: IF po_log.d_proc THEN
485: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
486: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
487: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
488: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
489: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 486: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);

482: x_result_type := po_validations.c_result_type_success;
483:
484: IF po_log.d_proc THEN
485: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
486: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
487: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
488: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
489: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
490: END IF;

Line 487: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);

483:
484: IF po_log.d_proc THEN
485: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
486: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
487: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
488: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
489: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
490: END IF;
491:

Line 488: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);

484: IF po_log.d_proc THEN
485: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
486: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
487: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
488: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
489: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
490: END IF;
491:
492: -- If order_type_lookup_code is not FIXED PRICE and price_discount/price override cannot both be null

Line 489: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

485: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
486: po_log.proc_begin(d_mod, 'p_price_discount_tbl', p_price_discount_tbl);
487: po_log.proc_begin(d_mod, 'p_price_override_tbl', p_price_override_tbl);
488: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
489: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
490: END IF;
491:
492: -- If order_type_lookup_code is not FIXED PRICE and price_discount/price override cannot both be null
493: -- and price discount cannot be greater than 100

Line 525: IF po_log.d_proc THEN

521: x_result_type := po_validations.c_result_type_failure;
522: END IF;
523: END LOOP;
524:
525: IF po_log.d_proc THEN
526: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
527: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
528: END IF;
529: EXCEPTION

Line 526: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

522: END IF;
523: END LOOP;
524:
525: IF po_log.d_proc THEN
526: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
527: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
528: END IF;
529: EXCEPTION
530: WHEN OTHERS THEN

Line 527: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

523: END LOOP;
524:
525: IF po_log.d_proc THEN
526: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
527: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
528: END IF;
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF po_log.d_exc THEN

Line 531: IF po_log.d_exc THEN

527: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
528: END IF;
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF po_log.d_exc THEN
532: po_log.exc(d_mod, 0, NULL);
533: END IF;
534:
535: RAISE;

Line 532: po_log.exc(d_mod, 0, NULL);

528: END IF;
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF po_log.d_exc THEN
532: po_log.exc(d_mod, 0, NULL);
533: END IF;
534:
535: RAISE;
536: END price_discount;

Line 558: IF po_log.d_proc THEN

554: END IF;
555:
556: x_result_type := po_validations.c_result_type_success;
557:
558: IF po_log.d_proc THEN
559: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
560: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
561: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
562: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);

Line 559: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

555:
556: x_result_type := po_validations.c_result_type_success;
557:
558: IF po_log.d_proc THEN
559: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
560: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
561: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
562: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
563: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);

Line 560: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);

556: x_result_type := po_validations.c_result_type_success;
557:
558: IF po_log.d_proc THEN
559: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
560: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
561: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
562: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
563: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
564: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 561: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);

557:
558: IF po_log.d_proc THEN
559: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
560: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
561: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
562: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
563: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
564: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
565: END IF;

Line 562: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);

558: IF po_log.d_proc THEN
559: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
560: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
561: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
562: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
563: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
564: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
565: END IF;
566:

Line 563: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);

559: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
560: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
561: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
562: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
563: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
564: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
565: END IF;
566:
567: -- If item_id is not null and ship_to_organization_id is not null, and

Line 564: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

560: po_log.proc_begin(d_mod, 'p_ship_to_organization_id_tbl', p_ship_to_organization_id_tbl);
561: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
562: po_log.proc_begin(d_mod, 'p_item_revision_tbl', p_item_revision_tbl);
563: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
564: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
565: END IF;
566:
567: -- If item_id is not null and ship_to_organization_id is not null, and
568: -- item_revision is not null and no record exists in mtl_item_revisions.

Line 724: IF po_log.d_proc THEN

720: IF (SQL%ROWCOUNT > 0) THEN
721: x_result_type := po_validations.c_result_type_failure;
722: END IF;
723:
724: IF po_log.d_proc THEN
725: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
726: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
727: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
728: END IF;

Line 726: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

722: END IF;
723:
724: IF po_log.d_proc THEN
725: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
726: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
727: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
728: END IF;
729: EXCEPTION
730: WHEN OTHERS THEN

Line 727: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

723:
724: IF po_log.d_proc THEN
725: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
726: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
727: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
728: END IF;
729: EXCEPTION
730: WHEN OTHERS THEN
731: IF po_log.d_exc THEN

Line 731: IF po_log.d_exc THEN

727: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
728: END IF;
729: EXCEPTION
730: WHEN OTHERS THEN
731: IF po_log.d_exc THEN
732: po_log.exc(d_mod, 0, NULL);
733: END IF;
734:
735: RAISE;

Line 732: po_log.exc(d_mod, 0, NULL);

728: END IF;
729: EXCEPTION
730: WHEN OTHERS THEN
731: IF po_log.d_exc THEN
732: po_log.exc(d_mod, 0, NULL);
733: END IF;
734:
735: RAISE;
736: END ship_to_organization_id;

Line 759: IF po_log.d_proc THEN

755: END IF;
756:
757: x_result_type := po_validations.c_result_type_success;
758:
759: IF po_log.d_proc THEN
760: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
761: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
762: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
763: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);

Line 760: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

756:
757: x_result_type := po_validations.c_result_type_success;
758:
759: IF po_log.d_proc THEN
760: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
761: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
762: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
763: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
764: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);

Line 761: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);

757: x_result_type := po_validations.c_result_type_success;
758:
759: IF po_log.d_proc THEN
760: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
761: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
762: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
763: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
764: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
765: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);

Line 762: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);

758:
759: IF po_log.d_proc THEN
760: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
761: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
762: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
763: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
764: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
765: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
766: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 763: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);

759: IF po_log.d_proc THEN
760: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
761: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
762: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
763: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
764: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
765: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
766: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
767: END IF;

Line 764: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);

760: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
761: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
762: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
763: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
764: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
765: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
766: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
767: END IF;
768:

Line 765: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);

761: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
762: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
763: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
764: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
765: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
766: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
767: END IF;
768:
769: -- validate price break attributes

Line 766: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

762: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
763: po_log.proc_begin(d_mod, 'p_quantity_tbl', p_quantity_tbl);
764: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
765: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
766: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
767: END IF;
768:
769: -- validate price break attributes
770: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 784: IF po_log.d_proc THEN

780: x_result_type := po_validations.c_result_type_failure;
781: END IF;
782: END LOOP;
783:
784: IF po_log.d_proc THEN
785: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
786: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
787: END IF;
788: EXCEPTION

Line 785: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

781: END IF;
782: END LOOP;
783:
784: IF po_log.d_proc THEN
785: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
786: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
787: END IF;
788: EXCEPTION
789: WHEN OTHERS THEN

Line 786: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

782: END LOOP;
783:
784: IF po_log.d_proc THEN
785: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
786: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
787: END IF;
788: EXCEPTION
789: WHEN OTHERS THEN
790: IF po_log.d_exc THEN

Line 790: IF po_log.d_exc THEN

786: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
787: END IF;
788: EXCEPTION
789: WHEN OTHERS THEN
790: IF po_log.d_exc THEN
791: po_log.exc(d_mod, 0, NULL);
792: END IF;
793:
794: RAISE;

Line 791: po_log.exc(d_mod, 0, NULL);

787: END IF;
788: EXCEPTION
789: WHEN OTHERS THEN
790: IF po_log.d_exc THEN
791: po_log.exc(d_mod, 0, NULL);
792: END IF;
793:
794: RAISE;
795: END price_break_attributes;

Line 819: IF po_log.d_proc THEN

815: END IF;
816:
817: x_result_type := po_validations.c_result_type_success;
818:
819: IF po_log.d_proc THEN
820: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
821: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
822: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
823: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);

Line 820: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

816:
817: x_result_type := po_validations.c_result_type_success;
818:
819: IF po_log.d_proc THEN
820: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
821: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
822: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
823: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
824: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);

Line 821: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);

817: x_result_type := po_validations.c_result_type_success;
818:
819: IF po_log.d_proc THEN
820: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
821: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
822: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
823: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
824: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
825: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);

Line 822: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);

818:
819: IF po_log.d_proc THEN
820: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
821: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
822: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
823: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
824: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
825: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
826: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 823: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);

819: IF po_log.d_proc THEN
820: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
821: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
822: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
823: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
824: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
825: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
826: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
827: END IF;

Line 824: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);

820: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
821: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
822: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
823: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
824: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
825: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
826: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
827: END IF;
828:

Line 825: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);

821: po_log.proc_begin(d_mod, 'p_line_expiration_date_tbl', p_line_expiration_date_tbl);
822: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
823: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
824: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
825: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
826: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
827: END IF;
828:
829: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 826: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

822: po_log.proc_begin(d_mod, 'p_to_date_tbl', p_to_date_tbl);
823: po_log.proc_begin(d_mod, 'p_from_date_tbl', p_from_date_tbl);
824: po_log.proc_begin(d_mod, 'p_header_start_date_tbl', p_header_start_date_tbl);
825: po_log.proc_begin(d_mod, 'p_header_end_date_tbl', p_header_end_date_tbl);
826: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
827: END IF;
828:
829: FOR i IN 1 .. p_id_tbl.COUNT LOOP
830: -- Pricebreak effective from date cannot be earlier than blanket

Line 963: IF po_log.d_proc THEN

959: END IF;
960:
961: END LOOP;
962:
963: IF po_log.d_proc THEN
964: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
965: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
966: END IF;
967: EXCEPTION

Line 964: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

960:
961: END LOOP;
962:
963: IF po_log.d_proc THEN
964: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
965: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
966: END IF;
967: EXCEPTION
968: WHEN OTHERS THEN

Line 965: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

961: END LOOP;
962:
963: IF po_log.d_proc THEN
964: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
965: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
966: END IF;
967: EXCEPTION
968: WHEN OTHERS THEN
969: IF po_log.d_exc THEN

Line 969: IF po_log.d_exc THEN

965: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
966: END IF;
967: EXCEPTION
968: WHEN OTHERS THEN
969: IF po_log.d_exc THEN
970: po_log.exc(d_mod, 0, NULL);
971: END IF;
972:
973: RAISE;

Line 970: po_log.exc(d_mod, 0, NULL);

966: END IF;
967: EXCEPTION
968: WHEN OTHERS THEN
969: IF po_log.d_exc THEN
970: po_log.exc(d_mod, 0, NULL);
971: END IF;
972:
973: RAISE;
974: END effective_dates;

Line 993: IF po_log.d_proc THEN

989: END IF;
990:
991: x_result_type := po_validations.c_result_type_success;
992:
993: IF po_log.d_proc THEN
994: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
995: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);
996: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
997: END IF;

Line 994: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

990:
991: x_result_type := po_validations.c_result_type_success;
992:
993: IF po_log.d_proc THEN
994: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
995: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);
996: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
997: END IF;
998:

Line 995: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);

991: x_result_type := po_validations.c_result_type_success;
992:
993: IF po_log.d_proc THEN
994: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
995: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);
996: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
997: END IF;
998:
999: FORALL i IN 1 .. p_id_tbl.COUNT

Line 996: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

992:
993: IF po_log.d_proc THEN
994: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
995: po_log.proc_begin(d_mod, 'p_qty_rcv_exception_code_tbl', p_qty_rcv_exception_code_tbl);
996: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
997: END IF;
998:
999: FORALL i IN 1 .. p_id_tbl.COUNT
1000: INSERT INTO po_validation_results_gt

Line 1036: IF po_log.d_proc THEN

1032: ELSE
1033: x_result_type := po_validations.c_result_type_success;
1034: END IF;
1035:
1036: IF po_log.d_proc THEN
1037: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1038: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1039: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1040: END IF;

Line 1038: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1034: END IF;
1035:
1036: IF po_log.d_proc THEN
1037: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1038: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1039: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1040: END IF;
1041: EXCEPTION
1042: WHEN OTHERS THEN

Line 1039: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

1035:
1036: IF po_log.d_proc THEN
1037: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1038: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1039: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1040: END IF;
1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: IF po_log.d_exc THEN

Line 1043: IF po_log.d_exc THEN

1039: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1040: END IF;
1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: IF po_log.d_exc THEN
1044: po_log.exc(d_mod, 0, NULL);
1045: END IF;
1046:
1047: RAISE;

Line 1044: po_log.exc(d_mod, 0, NULL);

1040: END IF;
1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: IF po_log.d_exc THEN
1044: po_log.exc(d_mod, 0, NULL);
1045: END IF;
1046:
1047: RAISE;
1048: END qty_rcv_exception_code;

Line 1069: IF po_log.d_proc THEN

1065: END IF;
1066:
1067: x_result_type := po_validations.c_result_type_success;
1068:
1069: IF po_log.d_proc THEN
1070: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1071: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1072: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1073: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 1070: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1066:
1067: x_result_type := po_validations.c_result_type_success;
1068:
1069: IF po_log.d_proc THEN
1070: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1071: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1072: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1073: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1074: END IF;

Line 1071: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);

1067: x_result_type := po_validations.c_result_type_success;
1068:
1069: IF po_log.d_proc THEN
1070: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1071: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1072: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1073: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1074: END IF;
1075:

Line 1072: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

1068:
1069: IF po_log.d_proc THEN
1070: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1071: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1072: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1073: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1074: END IF;
1075:
1076: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal

Line 1073: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

1069: IF po_log.d_proc THEN
1070: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1071: po_log.proc_begin(d_mod, 'p_enforce_ship_to_loc_code_tbl', p_enforce_ship_to_loc_code_tbl);
1072: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1073: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1074: END IF;
1075:
1076: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
1077: -- to NONE, REJECT or WARNING

Line 1092: IF po_log.d_proc THEN

1088: x_result_type := po_validations.c_result_type_failure;
1089: END IF;
1090: END LOOP;
1091:
1092: IF po_log.d_proc THEN
1093: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1094: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1095: END IF;
1096: EXCEPTION

Line 1093: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1089: END IF;
1090: END LOOP;
1091:
1092: IF po_log.d_proc THEN
1093: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1094: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1095: END IF;
1096: EXCEPTION
1097: WHEN OTHERS THEN

Line 1094: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

1090: END LOOP;
1091:
1092: IF po_log.d_proc THEN
1093: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1094: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1095: END IF;
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: IF po_log.d_exc THEN

Line 1098: IF po_log.d_exc THEN

1094: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1095: END IF;
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: IF po_log.d_exc THEN
1099: po_log.exc(d_mod, 0, NULL);
1100: END IF;
1101:
1102: RAISE;

Line 1099: po_log.exc(d_mod, 0, NULL);

1095: END IF;
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: IF po_log.d_exc THEN
1099: po_log.exc(d_mod, 0, NULL);
1100: END IF;
1101:
1102: RAISE;
1103: END enforce_ship_to_loc_code;

Line 1124: IF po_log.d_proc THEN

1120: END IF;
1121:
1122: x_result_type := po_validations.c_result_type_success;
1123:
1124: IF po_log.d_proc THEN
1125: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1126: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1127: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 1125: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1121:
1122: x_result_type := po_validations.c_result_type_success;
1123:
1124: IF po_log.d_proc THEN
1125: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1126: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1127: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1129: END IF;

Line 1126: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

1122: x_result_type := po_validations.c_result_type_success;
1123:
1124: IF po_log.d_proc THEN
1125: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1126: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1127: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1129: END IF;
1130:

Line 1127: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);

1123:
1124: IF po_log.d_proc THEN
1125: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1126: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1127: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1129: END IF;
1130:
1131: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and

Line 1128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

1124: IF po_log.d_proc THEN
1125: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1126: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1127: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1129: END IF;
1130:
1131: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and
1132: -- not equal to NONE, REJECT or WARNING

Line 1145: IF po_log.d_proc THEN

1141: x_result_type := po_validations.c_result_type_failure;
1142: END IF;
1143: END LOOP;
1144:
1145: IF po_log.d_proc THEN
1146: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1147: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1148: END IF;
1149: EXCEPTION

Line 1146: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1142: END IF;
1143: END LOOP;
1144:
1145: IF po_log.d_proc THEN
1146: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1147: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1148: END IF;
1149: EXCEPTION
1150: WHEN OTHERS THEN

Line 1147: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

1143: END LOOP;
1144:
1145: IF po_log.d_proc THEN
1146: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1147: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1148: END IF;
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: IF po_log.d_exc THEN

Line 1151: IF po_log.d_exc THEN

1147: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1148: END IF;
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: IF po_log.d_exc THEN
1152: po_log.exc(d_mod, 0, NULL);
1153: END IF;
1154:
1155: RAISE;

Line 1152: po_log.exc(d_mod, 0, NULL);

1148: END IF;
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: IF po_log.d_exc THEN
1152: po_log.exc(d_mod, 0, NULL);
1153: END IF;
1154:
1155: RAISE;
1156: END allow_sub_receipts_flag;

Line 1177: IF po_log.d_proc THEN

1173: END IF;
1174:
1175: x_result_type := po_validations.c_result_type_success;
1176:
1177: IF po_log.d_proc THEN
1178: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1179: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1180: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1181: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 1178: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1174:
1175: x_result_type := po_validations.c_result_type_success;
1176:
1177: IF po_log.d_proc THEN
1178: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1179: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1180: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1181: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1182: END IF;

Line 1179: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

1175: x_result_type := po_validations.c_result_type_success;
1176:
1177: IF po_log.d_proc THEN
1178: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1179: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1180: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1181: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1182: END IF;
1183:

Line 1180: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);

1176:
1177: IF po_log.d_proc THEN
1178: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1179: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1180: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1181: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1182: END IF;
1183:
1184: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null

Line 1181: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

1177: IF po_log.d_proc THEN
1178: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1179: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1180: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1181: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1182: END IF;
1183:
1184: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
1185: -- and less than zero.

Line 1199: IF po_log.d_proc THEN

1195: x_result_type := po_validations.c_result_type_failure;
1196: END IF;
1197: END LOOP;
1198:
1199: IF po_log.d_proc THEN
1200: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1201: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1202: END IF;
1203: EXCEPTION

Line 1200: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1196: END IF;
1197: END LOOP;
1198:
1199: IF po_log.d_proc THEN
1200: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1201: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1202: END IF;
1203: EXCEPTION
1204: WHEN OTHERS THEN

Line 1201: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

1197: END LOOP;
1198:
1199: IF po_log.d_proc THEN
1200: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1201: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1202: END IF;
1203: EXCEPTION
1204: WHEN OTHERS THEN
1205: IF po_log.d_exc THEN

Line 1205: IF po_log.d_exc THEN

1201: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1202: END IF;
1203: EXCEPTION
1204: WHEN OTHERS THEN
1205: IF po_log.d_exc THEN
1206: po_log.exc(d_mod, 0, NULL);
1207: END IF;
1208:
1209: RAISE;

Line 1206: po_log.exc(d_mod, 0, NULL);

1202: END IF;
1203: EXCEPTION
1204: WHEN OTHERS THEN
1205: IF po_log.d_exc THEN
1206: po_log.exc(d_mod, 0, NULL);
1207: END IF;
1208:
1209: RAISE;
1210: END days_early_receipt_allowed;

Line 1231: IF po_log.d_proc THEN

1227: END IF;
1228:
1229: x_result_type := po_validations.c_result_type_success;
1230:
1231: IF po_log.d_proc THEN
1232: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1233: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1234: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 1232: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1228:
1229: x_result_type := po_validations.c_result_type_success;
1230:
1231: IF po_log.d_proc THEN
1232: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1233: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1234: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1236: END IF;

Line 1233: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

1229: x_result_type := po_validations.c_result_type_success;
1230:
1231: IF po_log.d_proc THEN
1232: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1233: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1234: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1236: END IF;
1237:

Line 1234: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);

1230:
1231: IF po_log.d_proc THEN
1232: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1233: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1234: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1236: END IF;
1237:
1238: -- If shipment_type is STANDARD and receipt_days_expection_code is not null

Line 1235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

1231: IF po_log.d_proc THEN
1232: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1233: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1234: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1236: END IF;
1237:
1238: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
1239: -- and not 'NONE', 'REJECT' not 'WARNING'

Line 1253: IF po_log.d_proc THEN

1249: x_result_type := po_validations.c_result_type_failure;
1250: END IF;
1251: END LOOP;
1252:
1253: IF po_log.d_proc THEN
1254: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1255: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1256: END IF;
1257: EXCEPTION

Line 1254: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1250: END IF;
1251: END LOOP;
1252:
1253: IF po_log.d_proc THEN
1254: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1255: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1256: END IF;
1257: EXCEPTION
1258: WHEN OTHERS THEN

Line 1255: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

1251: END LOOP;
1252:
1253: IF po_log.d_proc THEN
1254: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1255: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1256: END IF;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: IF po_log.d_exc THEN

Line 1259: IF po_log.d_exc THEN

1255: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1256: END IF;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: IF po_log.d_exc THEN
1260: po_log.exc(d_mod, 0, NULL);
1261: END IF;
1262:
1263: RAISE;

Line 1260: po_log.exc(d_mod, 0, NULL);

1256: END IF;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: IF po_log.d_exc THEN
1260: po_log.exc(d_mod, 0, NULL);
1261: END IF;
1262:
1263: RAISE;
1264: END receipt_days_exception_code;

Line 1285: IF po_log.d_proc THEN

1281: END IF;
1282:
1283: x_result_type := po_validations.c_result_type_success;
1284:
1285: IF po_log.d_proc THEN
1286: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1287: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1288: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1289: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 1286: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1282:
1283: x_result_type := po_validations.c_result_type_success;
1284:
1285: IF po_log.d_proc THEN
1286: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1287: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1288: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1289: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1290: END IF;

Line 1287: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

1283: x_result_type := po_validations.c_result_type_success;
1284:
1285: IF po_log.d_proc THEN
1286: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1287: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1288: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1289: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1290: END IF;
1291:

Line 1288: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);

1284:
1285: IF po_log.d_proc THEN
1286: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1287: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1288: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1289: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1290: END IF;
1291:
1292: -- If shipment_type is STANDARD and invoice_close_tolerance is not null

Line 1289: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

1285: IF po_log.d_proc THEN
1286: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1287: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1288: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1289: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1290: END IF;
1291:
1292: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
1293: -- and less than or equal to zero or greater than or equal to 100.

Line 1307: IF po_log.d_proc THEN

1303: x_result_type := po_validations.c_result_type_failure;
1304: END IF;
1305: END LOOP;
1306:
1307: IF po_log.d_proc THEN
1308: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1309: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1310: END IF;
1311: EXCEPTION

Line 1308: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1304: END IF;
1305: END LOOP;
1306:
1307: IF po_log.d_proc THEN
1308: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1309: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1310: END IF;
1311: EXCEPTION
1312: WHEN OTHERS THEN

Line 1309: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

1305: END LOOP;
1306:
1307: IF po_log.d_proc THEN
1308: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1309: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1310: END IF;
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: IF po_log.d_exc THEN

Line 1313: IF po_log.d_exc THEN

1309: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1310: END IF;
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: IF po_log.d_exc THEN
1314: po_log.exc(d_mod, 0, NULL);
1315: END IF;
1316:
1317: RAISE;

Line 1314: po_log.exc(d_mod, 0, NULL);

1310: END IF;
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: IF po_log.d_exc THEN
1314: po_log.exc(d_mod, 0, NULL);
1315: END IF;
1316:
1317: RAISE;
1318: END invoice_close_tolerance;

Line 1339: IF po_log.d_proc THEN

1335: END IF;
1336:
1337: x_result_type := po_validations.c_result_type_success;
1338:
1339: IF po_log.d_proc THEN
1340: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1341: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1342: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1343: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 1340: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1336:
1337: x_result_type := po_validations.c_result_type_success;
1338:
1339: IF po_log.d_proc THEN
1340: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1341: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1342: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1343: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1344: END IF;

Line 1341: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

1337: x_result_type := po_validations.c_result_type_success;
1338:
1339: IF po_log.d_proc THEN
1340: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1341: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1342: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1343: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1344: END IF;
1345:

Line 1342: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);

1338:
1339: IF po_log.d_proc THEN
1340: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1341: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1342: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1343: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1344: END IF;
1345:
1346: -- If shipment_type is STANDARD and receive_close_tolerance is not null

Line 1343: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

1339: IF po_log.d_proc THEN
1340: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1341: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1342: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1343: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1344: END IF;
1345:
1346: -- If shipment_type is STANDARD and receive_close_tolerance is not null
1347: -- and less than or equal to zero or greater than or equal to 100.

Line 1361: IF po_log.d_proc THEN

1357: x_result_type := po_validations.c_result_type_failure;
1358: END IF;
1359: END LOOP;
1360:
1361: IF po_log.d_proc THEN
1362: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1363: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1364: END IF;
1365: EXCEPTION

Line 1362: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1358: END IF;
1359: END LOOP;
1360:
1361: IF po_log.d_proc THEN
1362: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1363: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1364: END IF;
1365: EXCEPTION
1366: WHEN OTHERS THEN

Line 1363: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

1359: END LOOP;
1360:
1361: IF po_log.d_proc THEN
1362: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1363: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1364: END IF;
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: IF po_log.d_exc THEN

Line 1367: IF po_log.d_exc THEN

1363: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1364: END IF;
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: IF po_log.d_exc THEN
1368: po_log.exc(d_mod, 0, NULL);
1369: END IF;
1370:
1371: RAISE;

Line 1368: po_log.exc(d_mod, 0, NULL);

1364: END IF;
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: IF po_log.d_exc THEN
1368: po_log.exc(d_mod, 0, NULL);
1369: END IF;
1370:
1371: RAISE;
1372: END receive_close_tolerance;

Line 1392: IF po_log.d_proc THEN

1388: END IF;
1389:
1390: x_result_type := po_validations.c_result_type_success;
1391:
1392: IF po_log.d_proc THEN
1393: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1394: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1395: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1396: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 1393: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1389:
1390: x_result_type := po_validations.c_result_type_success;
1391:
1392: IF po_log.d_proc THEN
1393: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1394: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1395: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1396: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1397: END IF;

Line 1394: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);

1390: x_result_type := po_validations.c_result_type_success;
1391:
1392: IF po_log.d_proc THEN
1393: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1394: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1395: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1396: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1397: END IF;
1398:

Line 1395: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);

1391:
1392: IF po_log.d_proc THEN
1393: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1394: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1395: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1396: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1397: END IF;
1398:
1399: -- Validate that receiving routing id exists in rcv_routing_headers

Line 1396: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

1392: IF po_log.d_proc THEN
1393: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1394: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1395: po_log.proc_begin(d_mod, 'p_receiving_routing_id_tbl', p_receiving_routing_id_tbl);
1396: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1397: END IF;
1398:
1399: -- Validate that receiving routing id exists in rcv_routing_headers
1400: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1431: IF po_log.d_proc THEN

1427: IF (SQL%ROWCOUNT > 0) THEN
1428: x_result_type := po_validations.c_result_type_failure;
1429: END IF;
1430:
1431: IF po_log.d_proc THEN
1432: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1433: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1434: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1435: END IF;

Line 1433: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1429: END IF;
1430:
1431: IF po_log.d_proc THEN
1432: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1433: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1434: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1435: END IF;
1436: EXCEPTION
1437: WHEN OTHERS THEN

Line 1434: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

1430:
1431: IF po_log.d_proc THEN
1432: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1433: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1434: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1435: END IF;
1436: EXCEPTION
1437: WHEN OTHERS THEN
1438: IF po_log.d_exc THEN

Line 1438: IF po_log.d_exc THEN

1434: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1435: END IF;
1436: EXCEPTION
1437: WHEN OTHERS THEN
1438: IF po_log.d_exc THEN
1439: po_log.exc(d_mod, 0, NULL);
1440: END IF;
1441:
1442: RAISE;

Line 1439: po_log.exc(d_mod, 0, NULL);

1435: END IF;
1436: EXCEPTION
1437: WHEN OTHERS THEN
1438: IF po_log.d_exc THEN
1439: po_log.exc(d_mod, 0, NULL);
1440: END IF;
1441:
1442: RAISE;
1443: END receiving_routing_id;

Line 1462: IF po_log.d_proc THEN

1458: END IF;
1459:
1460: x_result_type := po_validations.c_result_type_success;
1461:
1462: IF po_log.d_proc THEN
1463: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1464: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
1465: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1466: END IF;

Line 1463: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1459:
1460: x_result_type := po_validations.c_result_type_success;
1461:
1462: IF po_log.d_proc THEN
1463: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1464: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
1465: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1466: END IF;
1467:

Line 1464: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);

1460: x_result_type := po_validations.c_result_type_success;
1461:
1462: IF po_log.d_proc THEN
1463: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1464: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
1465: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1466: END IF;
1467:
1468: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 1465: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

1461:
1462: IF po_log.d_proc THEN
1463: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1464: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
1465: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1466: END IF;
1467:
1468: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1469: IF (p_accrue_on_receipt_flag_tbl(i) IS NOT NULL AND p_accrue_on_receipt_flag_tbl(i) NOT IN('N', 'Y')) THEN

Line 1479: IF po_log.d_proc THEN

1475: x_result_type := po_validations.c_result_type_failure;
1476: END IF;
1477: END LOOP;
1478:
1479: IF po_log.d_proc THEN
1480: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1481: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1482: END IF;
1483: EXCEPTION

Line 1480: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1476: END IF;
1477: END LOOP;
1478:
1479: IF po_log.d_proc THEN
1480: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1481: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1482: END IF;
1483: EXCEPTION
1484: WHEN OTHERS THEN

Line 1481: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

1477: END LOOP;
1478:
1479: IF po_log.d_proc THEN
1480: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1481: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1482: END IF;
1483: EXCEPTION
1484: WHEN OTHERS THEN
1485: IF po_log.d_exc THEN

Line 1485: IF po_log.d_exc THEN

1481: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1482: END IF;
1483: EXCEPTION
1484: WHEN OTHERS THEN
1485: IF po_log.d_exc THEN
1486: po_log.exc(d_mod, 0, NULL);
1487: END IF;
1488:
1489: RAISE;

Line 1486: po_log.exc(d_mod, 0, NULL);

1482: END IF;
1483: EXCEPTION
1484: WHEN OTHERS THEN
1485: IF po_log.d_exc THEN
1486: po_log.exc(d_mod, 0, NULL);
1487: END IF;
1488:
1489: RAISE;
1490: END accrue_on_receipt_flag;

Line 1507: IF po_log.d_proc THEN

1503: IF x_result_set_id IS NULL THEN
1504: x_result_set_id := po_validations.next_result_set_id();
1505: END IF;
1506:
1507: IF po_log.d_proc THEN
1508: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1509: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1510: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1511: END IF;

Line 1508: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1504: x_result_set_id := po_validations.next_result_set_id();
1505: END IF;
1506:
1507: IF po_log.d_proc THEN
1508: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1509: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1510: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1511: END IF;
1512:

Line 1509: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);

1505: END IF;
1506:
1507: IF po_log.d_proc THEN
1508: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1509: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1510: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1511: END IF;
1512:
1513: x_result_type := po_validations.c_result_type_success;

Line 1510: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

1506:
1507: IF po_log.d_proc THEN
1508: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1509: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1510: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1511: END IF;
1512:
1513: x_result_type := po_validations.c_result_type_success;
1514:

Line 1550: IF po_log.d_proc THEN

1546: IF (SQL%ROWCOUNT > 0) THEN
1547: x_result_type := po_validations.c_result_type_failure;
1548: END IF;
1549:
1550: IF po_log.d_proc THEN
1551: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1552: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1553: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1554: END IF;

Line 1552: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1548: END IF;
1549:
1550: IF po_log.d_proc THEN
1551: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1552: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1553: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1554: END IF;
1555: EXCEPTION
1556: WHEN OTHERS THEN

Line 1553: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

1549:
1550: IF po_log.d_proc THEN
1551: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1552: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1553: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1554: END IF;
1555: EXCEPTION
1556: WHEN OTHERS THEN
1557: IF po_log.d_exc THEN

Line 1557: IF po_log.d_exc THEN

1553: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1554: END IF;
1555: EXCEPTION
1556: WHEN OTHERS THEN
1557: IF po_log.d_exc THEN
1558: po_log.exc(d_mod, 0, NULL);
1559: END IF;
1560: RAISE;
1561:

Line 1558: po_log.exc(d_mod, 0, NULL);

1554: END IF;
1555: EXCEPTION
1556: WHEN OTHERS THEN
1557: IF po_log.d_exc THEN
1558: po_log.exc(d_mod, 0, NULL);
1559: END IF;
1560: RAISE;
1561:
1562: END style_related_info;

Line 1585: IF po_log.d_proc THEN

1581: IF x_result_set_id IS NULL THEN
1582: x_result_set_id := po_validations.next_result_set_id();
1583: END IF;
1584:
1585: IF po_log.d_proc THEN
1586: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1587: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
1588: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
1589: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 1586: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1582: x_result_set_id := po_validations.next_result_set_id();
1583: END IF;
1584:
1585: IF po_log.d_proc THEN
1586: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1587: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
1588: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
1589: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1590: END IF;

Line 1587: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);

1583: END IF;
1584:
1585: IF po_log.d_proc THEN
1586: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1587: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
1588: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
1589: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1590: END IF;
1591:

Line 1588: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);

1584:
1585: IF po_log.d_proc THEN
1586: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1587: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
1588: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
1589: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1590: END IF;
1591:
1592: x_result_type := po_validations.c_result_type_success;

Line 1589: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

1585: IF po_log.d_proc THEN
1586: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1587: po_log.proc_begin(d_mod, 'p_tax_code_id_tbl', p_tax_code_id_tbl);
1588: po_log.proc_begin(d_mod, 'p_tax_name_tbl', p_tax_name_tbl);
1589: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1590: END IF;
1591:
1592: x_result_type := po_validations.c_result_type_success;
1593:

Line 1683: IF po_log.d_proc THEN

1679: IF (SQL%ROWCOUNT > 0) THEN
1680: x_result_type := po_validations.c_result_type_failure;
1681: END IF;
1682:
1683: IF po_log.d_proc THEN
1684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1685: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1687: END IF;

Line 1685: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1681: END IF;
1682:
1683: IF po_log.d_proc THEN
1684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1685: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1687: END IF;
1688: EXCEPTION
1689: WHEN OTHERS THEN

Line 1686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

1682:
1683: IF po_log.d_proc THEN
1684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1685: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1687: END IF;
1688: EXCEPTION
1689: WHEN OTHERS THEN
1690: IF po_log.d_exc THEN

Line 1690: IF po_log.d_exc THEN

1686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1687: END IF;
1688: EXCEPTION
1689: WHEN OTHERS THEN
1690: IF po_log.d_exc THEN
1691: po_log.exc(d_mod, 0, NULL);
1692: END IF;
1693:
1694: RAISE;

Line 1691: po_log.exc(d_mod, 0, NULL);

1687: END IF;
1688: EXCEPTION
1689: WHEN OTHERS THEN
1690: IF po_log.d_exc THEN
1691: po_log.exc(d_mod, 0, NULL);
1692: END IF;
1693:
1694: RAISE;
1695: END tax_name;

Line 1711: IF po_log.d_proc THEN

1707: IF x_result_set_id IS NULL THEN
1708: x_result_set_id := po_validations.next_result_set_id();
1709: END IF;
1710:
1711: IF po_log.d_proc THEN
1712: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1713: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1714: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1715: END IF;

Line 1712: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1708: x_result_set_id := po_validations.next_result_set_id();
1709: END IF;
1710:
1711: IF po_log.d_proc THEN
1712: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1713: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1714: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1715: END IF;
1716:

Line 1713: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);

1709: END IF;
1710:
1711: IF po_log.d_proc THEN
1712: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1713: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1714: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1715: END IF;
1716:
1717: x_result_type := po_validations.c_result_type_success;

Line 1714: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

1710:
1711: IF po_log.d_proc THEN
1712: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1713: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1714: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1715: END IF;
1716:
1717: x_result_type := po_validations.c_result_type_success;
1718:

Line 1754: IF po_log.d_proc THEN

1750: IF (SQL%ROWCOUNT > 0) THEN
1751: x_result_type := po_validations.c_result_type_failure;
1752: END IF;
1753:
1754: IF po_log.d_proc THEN
1755: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1756: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1757: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1758: END IF;

Line 1756: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1752: END IF;
1753:
1754: IF po_log.d_proc THEN
1755: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1756: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1757: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1758: END IF;
1759: EXCEPTION
1760: WHEN OTHERS THEN

Line 1757: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

1753:
1754: IF po_log.d_proc THEN
1755: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1756: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1757: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1758: END IF;
1759: EXCEPTION
1760: WHEN OTHERS THEN
1761: IF po_log.d_exc THEN

Line 1761: IF po_log.d_exc THEN

1757: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1758: END IF;
1759: EXCEPTION
1760: WHEN OTHERS THEN
1761: IF po_log.d_exc THEN
1762: po_log.exc(d_mod, 0, NULL);
1763: END IF;
1764: RAISE;
1765:

Line 1762: po_log.exc(d_mod, 0, NULL);

1758: END IF;
1759: EXCEPTION
1760: WHEN OTHERS THEN
1761: IF po_log.d_exc THEN
1762: po_log.exc(d_mod, 0, NULL);
1763: END IF;
1764: RAISE;
1765:
1766: END fob_lookup_code;

Line 1782: IF po_log.d_proc THEN

1778: IF x_result_set_id IS NULL THEN
1779: x_result_set_id := po_validations.next_result_set_id();
1780: END IF;
1781:
1782: IF po_log.d_proc THEN
1783: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1784: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);
1785: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1786: END IF;

Line 1783: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1779: x_result_set_id := po_validations.next_result_set_id();
1780: END IF;
1781:
1782: IF po_log.d_proc THEN
1783: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1784: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);
1785: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1786: END IF;
1787:

Line 1784: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);

1780: END IF;
1781:
1782: IF po_log.d_proc THEN
1783: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1784: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);
1785: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1786: END IF;
1787:
1788: x_result_type := po_validations.c_result_type_success;

Line 1785: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

1781:
1782: IF po_log.d_proc THEN
1783: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1784: po_log.proc_begin(d_mod, 'p_freight_terms_tbl', p_freight_terms_tbl);
1785: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1786: END IF;
1787:
1788: x_result_type := po_validations.c_result_type_success;
1789:

Line 1825: IF po_log.d_proc THEN

1821: IF (SQL%ROWCOUNT > 0) THEN
1822: x_result_type := po_validations.c_result_type_failure;
1823: END IF;
1824:
1825: IF po_log.d_proc THEN
1826: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1827: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1828: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1829: END IF;

Line 1827: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1823: END IF;
1824:
1825: IF po_log.d_proc THEN
1826: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1827: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1828: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1829: END IF;
1830: EXCEPTION
1831: WHEN OTHERS THEN

Line 1828: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

1824:
1825: IF po_log.d_proc THEN
1826: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1827: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1828: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1829: END IF;
1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: IF po_log.d_exc THEN

Line 1832: IF po_log.d_exc THEN

1828: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1829: END IF;
1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: IF po_log.d_exc THEN
1833: po_log.exc(d_mod, 0, NULL);
1834: END IF;
1835: RAISE;
1836:

Line 1833: po_log.exc(d_mod, 0, NULL);

1829: END IF;
1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: IF po_log.d_exc THEN
1833: po_log.exc(d_mod, 0, NULL);
1834: END IF;
1835: RAISE;
1836:
1837: END freight_terms;

Line 1854: IF po_log.d_proc THEN

1850: IF x_result_set_id IS NULL THEN
1851: x_result_set_id := po_validations.next_result_set_id();
1852: END IF;
1853:
1854: IF po_log.d_proc THEN
1855: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1856: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
1857: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1858: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 1855: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1851: x_result_set_id := po_validations.next_result_set_id();
1852: END IF;
1853:
1854: IF po_log.d_proc THEN
1855: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1856: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
1857: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1858: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1859: END IF;

Line 1856: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);

1852: END IF;
1853:
1854: IF po_log.d_proc THEN
1855: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1856: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
1857: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1858: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1859: END IF;
1860:

Line 1857: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);

1853:
1854: IF po_log.d_proc THEN
1855: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1856: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
1857: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1858: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1859: END IF;
1860:
1861: x_result_type := po_validations.c_result_type_success;

Line 1858: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

1854: IF po_log.d_proc THEN
1855: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1856: po_log.proc_begin(d_mod, 'p_freight_carrier_tbl', p_freight_carrier_tbl);
1857: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1858: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1859: END IF;
1860:
1861: x_result_type := po_validations.c_result_type_success;
1862:

Line 1898: IF po_log.d_proc THEN

1894: IF (SQL%ROWCOUNT > 0) THEN
1895: x_result_type := po_validations.c_result_type_failure;
1896: END IF;
1897:
1898: IF po_log.d_proc THEN
1899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1902: END IF;

Line 1900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1896: END IF;
1897:
1898: IF po_log.d_proc THEN
1899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1902: END IF;
1903: EXCEPTION
1904: WHEN OTHERS THEN

Line 1901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

1897:
1898: IF po_log.d_proc THEN
1899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1902: END IF;
1903: EXCEPTION
1904: WHEN OTHERS THEN
1905: IF po_log.d_exc THEN

Line 1905: IF po_log.d_exc THEN

1901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1902: END IF;
1903: EXCEPTION
1904: WHEN OTHERS THEN
1905: IF po_log.d_exc THEN
1906: po_log.exc(d_mod, 0, NULL);
1907: END IF;
1908: RAISE;
1909:

Line 1906: po_log.exc(d_mod, 0, NULL);

1902: END IF;
1903: EXCEPTION
1904: WHEN OTHERS THEN
1905: IF po_log.d_exc THEN
1906: po_log.exc(d_mod, 0, NULL);
1907: END IF;
1908: RAISE;
1909:
1910: END freight_carrier;

Line 1930: IF po_log.d_proc THEN

1926: END IF;
1927:
1928: 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_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1934: END IF;

Line 1931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

1927:
1928: 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_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1934: END IF;
1935:

Line 1932: po_log.proc_begin(d_mod, 'p_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);

1928: 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_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1934: END IF;
1935:
1936: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 1933: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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_order_type_lookup_code_tbl', p_order_type_lookup_code_tbl);
1933: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1934: END IF;
1935:
1936: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1937: IF (p_order_type_lookup_code_tbl(i) IN ('AMOUNT', 'FIXED PRICE')) THEN

Line 1948: IF po_log.d_proc THEN

1944: x_result_type := po_validations.c_result_type_failure;
1945: END IF;
1946: END LOOP;
1947:
1948: IF po_log.d_proc THEN
1949: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1950: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1951: END IF;
1952: EXCEPTION

Line 1949: po_log.proc_end(d_mod, 'x_result_type', x_result_type);

1945: END IF;
1946: END LOOP;
1947:
1948: IF po_log.d_proc THEN
1949: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1950: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1951: END IF;
1952: EXCEPTION
1953: WHEN OTHERS THEN

Line 1950: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

1946: END LOOP;
1947:
1948: IF po_log.d_proc THEN
1949: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1950: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1951: END IF;
1952: EXCEPTION
1953: WHEN OTHERS THEN
1954: IF po_log.d_exc THEN

Line 1954: IF po_log.d_exc THEN

1950: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1951: END IF;
1952: EXCEPTION
1953: WHEN OTHERS THEN
1954: IF po_log.d_exc THEN
1955: po_log.exc(d_mod, 0, NULL);
1956: END IF;
1957:
1958: RAISE;

Line 1955: po_log.exc(d_mod, 0, NULL);

1951: END IF;
1952: EXCEPTION
1953: WHEN OTHERS THEN
1954: IF po_log.d_exc THEN
1955: po_log.exc(d_mod, 0, NULL);
1956: END IF;
1957:
1958: RAISE;
1959: END price_break;