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_HEADERS2 dependencies on PO_LOG

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

1: PACKAGE BODY PO_VAL_HEADERS2 AS
2: -- $Header: PO_VAL_HEADERS2.plb 120.19.12010000.2 2008/08/04 08:41:02 rramasam ship $
3: c_entity_type_header CONSTANT VARCHAR2(30) := po_validations.c_entity_type_header;
4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_HEADERS2');
6:
7: -- The module base for the subprogram.
8: d_po_header_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_HEADER_ID');
9: d_document_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DOCUMENT_NUM');

Line 8: d_po_header_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_HEADER_ID');

4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_HEADERS2');
6:
7: -- The module base for the subprogram.
8: d_po_header_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_HEADER_ID');
9: d_document_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DOCUMENT_NUM');
10: d_type_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TYPE_LOOKUP_CODE');
11: d_currency_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CURRENCY_CODE');
12: d_rate_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_INFO');

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

5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_HEADERS2');
6:
7: -- The module base for the subprogram.
8: d_po_header_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_HEADER_ID');
9: d_document_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DOCUMENT_NUM');
10: d_type_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TYPE_LOOKUP_CODE');
11: d_currency_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CURRENCY_CODE');
12: d_rate_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_INFO');
13: d_agent_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AGENT_ID');

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

6:
7: -- The module base for the subprogram.
8: d_po_header_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_HEADER_ID');
9: d_document_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DOCUMENT_NUM');
10: d_type_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TYPE_LOOKUP_CODE');
11: d_currency_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CURRENCY_CODE');
12: d_rate_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_INFO');
13: d_agent_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AGENT_ID');
14: d_vendor_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'VENDOR_INFO');

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

7: -- The module base for the subprogram.
8: d_po_header_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_HEADER_ID');
9: d_document_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DOCUMENT_NUM');
10: d_type_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TYPE_LOOKUP_CODE');
11: d_currency_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CURRENCY_CODE');
12: d_rate_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_INFO');
13: d_agent_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AGENT_ID');
14: d_vendor_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'VENDOR_INFO');
15: d_ship_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_LOCATION_ID');

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

8: d_po_header_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PO_HEADER_ID');
9: d_document_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DOCUMENT_NUM');
10: d_type_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TYPE_LOOKUP_CODE');
11: d_currency_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CURRENCY_CODE');
12: d_rate_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_INFO');
13: d_agent_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AGENT_ID');
14: d_vendor_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'VENDOR_INFO');
15: d_ship_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_LOCATION_ID');
16: d_bill_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BILL_TO_LOCATION_ID');

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

9: d_document_num CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DOCUMENT_NUM');
10: d_type_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TYPE_LOOKUP_CODE');
11: d_currency_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CURRENCY_CODE');
12: d_rate_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_INFO');
13: d_agent_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AGENT_ID');
14: d_vendor_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'VENDOR_INFO');
15: d_ship_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_LOCATION_ID');
16: d_bill_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BILL_TO_LOCATION_ID');
17: d_last_updated_by CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LAST_UPDATED_BY');

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

10: d_type_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TYPE_LOOKUP_CODE');
11: d_currency_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CURRENCY_CODE');
12: d_rate_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_INFO');
13: d_agent_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AGENT_ID');
14: d_vendor_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'VENDOR_INFO');
15: d_ship_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_LOCATION_ID');
16: d_bill_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BILL_TO_LOCATION_ID');
17: d_last_updated_by CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LAST_UPDATED_BY');
18: d_ship_via_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_VIA_LOOKUP_CODE');

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

11: d_currency_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CURRENCY_CODE');
12: d_rate_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_INFO');
13: d_agent_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AGENT_ID');
14: d_vendor_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'VENDOR_INFO');
15: d_ship_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_LOCATION_ID');
16: d_bill_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BILL_TO_LOCATION_ID');
17: d_last_updated_by CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LAST_UPDATED_BY');
18: d_ship_via_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_VIA_LOOKUP_CODE');
19: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');

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

12: d_rate_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'RATE_INFO');
13: d_agent_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AGENT_ID');
14: d_vendor_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'VENDOR_INFO');
15: d_ship_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_LOCATION_ID');
16: d_bill_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BILL_TO_LOCATION_ID');
17: d_last_updated_by CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LAST_UPDATED_BY');
18: d_ship_via_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_VIA_LOOKUP_CODE');
19: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
20: d_freight_terms_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS_LOOKUP_CODE');

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

13: d_agent_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AGENT_ID');
14: d_vendor_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'VENDOR_INFO');
15: d_ship_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_LOCATION_ID');
16: d_bill_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BILL_TO_LOCATION_ID');
17: d_last_updated_by CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LAST_UPDATED_BY');
18: d_ship_via_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_VIA_LOOKUP_CODE');
19: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
20: d_freight_terms_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS_LOOKUP_CODE');
21: d_shipping_control CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPPING_CONTROL');

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

14: d_vendor_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'VENDOR_INFO');
15: d_ship_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_LOCATION_ID');
16: d_bill_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BILL_TO_LOCATION_ID');
17: d_last_updated_by CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LAST_UPDATED_BY');
18: d_ship_via_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_VIA_LOOKUP_CODE');
19: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
20: d_freight_terms_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS_LOOKUP_CODE');
21: d_shipping_control CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPPING_CONTROL');
22: d_approval_status CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'APPROVAL_STATUS');

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

15: d_ship_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_TO_LOCATION_ID');
16: d_bill_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BILL_TO_LOCATION_ID');
17: d_last_updated_by CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LAST_UPDATED_BY');
18: d_ship_via_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_VIA_LOOKUP_CODE');
19: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
20: d_freight_terms_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS_LOOKUP_CODE');
21: d_shipping_control CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPPING_CONTROL');
22: d_approval_status CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'APPROVAL_STATUS');
23: d_acceptance_required_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_REQUIRED_FLAG');

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

16: d_bill_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BILL_TO_LOCATION_ID');
17: d_last_updated_by CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LAST_UPDATED_BY');
18: d_ship_via_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_VIA_LOOKUP_CODE');
19: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
20: d_freight_terms_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS_LOOKUP_CODE');
21: d_shipping_control CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPPING_CONTROL');
22: d_approval_status CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'APPROVAL_STATUS');
23: d_acceptance_required_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_REQUIRED_FLAG');
24: d_acceptance_due_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_DUE_DATE');

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

17: d_last_updated_by CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'LAST_UPDATED_BY');
18: d_ship_via_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_VIA_LOOKUP_CODE');
19: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
20: d_freight_terms_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS_LOOKUP_CODE');
21: d_shipping_control CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPPING_CONTROL');
22: d_approval_status CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'APPROVAL_STATUS');
23: d_acceptance_required_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_REQUIRED_FLAG');
24: d_acceptance_due_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_DUE_DATE');
25: d_cancel_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CANCEL_FLAG');

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

18: d_ship_via_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIP_VIA_LOOKUP_CODE');
19: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
20: d_freight_terms_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS_LOOKUP_CODE');
21: d_shipping_control CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPPING_CONTROL');
22: d_approval_status CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'APPROVAL_STATUS');
23: d_acceptance_required_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_REQUIRED_FLAG');
24: d_acceptance_due_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_DUE_DATE');
25: d_cancel_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CANCEL_FLAG');
26: d_closed_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CLOSED_CODE');

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

19: d_fob_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FOB_LOOKUP_CODE');
20: d_freight_terms_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS_LOOKUP_CODE');
21: d_shipping_control CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPPING_CONTROL');
22: d_approval_status CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'APPROVAL_STATUS');
23: d_acceptance_required_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_REQUIRED_FLAG');
24: d_acceptance_due_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_DUE_DATE');
25: d_cancel_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CANCEL_FLAG');
26: d_closed_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CLOSED_CODE');
27: d_print_count CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRINT_COUNT');

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

20: d_freight_terms_lookup_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'FREIGHT_TERMS_LOOKUP_CODE');
21: d_shipping_control CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPPING_CONTROL');
22: d_approval_status CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'APPROVAL_STATUS');
23: d_acceptance_required_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_REQUIRED_FLAG');
24: d_acceptance_due_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_DUE_DATE');
25: d_cancel_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CANCEL_FLAG');
26: d_closed_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CLOSED_CODE');
27: d_print_count CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRINT_COUNT');
28: d_amount_to_encumber CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_TO_ENCUMBER');

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

21: d_shipping_control CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'SHIPPING_CONTROL');
22: d_approval_status CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'APPROVAL_STATUS');
23: d_acceptance_required_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_REQUIRED_FLAG');
24: d_acceptance_due_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_DUE_DATE');
25: d_cancel_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CANCEL_FLAG');
26: d_closed_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CLOSED_CODE');
27: d_print_count CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRINT_COUNT');
28: d_amount_to_encumber CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_TO_ENCUMBER');
29: d_style_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_ID');

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

22: d_approval_status CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'APPROVAL_STATUS');
23: d_acceptance_required_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_REQUIRED_FLAG');
24: d_acceptance_due_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_DUE_DATE');
25: d_cancel_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CANCEL_FLAG');
26: d_closed_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CLOSED_CODE');
27: d_print_count CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRINT_COUNT');
28: d_amount_to_encumber CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_TO_ENCUMBER');
29: d_style_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_ID');
30: d_amount_limit CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_LIMIT');

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

23: d_acceptance_required_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_REQUIRED_FLAG');
24: d_acceptance_due_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_DUE_DATE');
25: d_cancel_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CANCEL_FLAG');
26: d_closed_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CLOSED_CODE');
27: d_print_count CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRINT_COUNT');
28: d_amount_to_encumber CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_TO_ENCUMBER');
29: d_style_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_ID');
30: d_amount_limit CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_LIMIT');
31:

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

24: d_acceptance_due_date CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCEPTANCE_DUE_DATE');
25: d_cancel_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CANCEL_FLAG');
26: d_closed_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CLOSED_CODE');
27: d_print_count CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRINT_COUNT');
28: d_amount_to_encumber CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_TO_ENCUMBER');
29: d_style_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_ID');
30: d_amount_limit CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_LIMIT');
31:
32: -------------------------------------------------------------------------

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

25: d_cancel_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CANCEL_FLAG');
26: d_closed_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CLOSED_CODE');
27: d_print_count CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRINT_COUNT');
28: d_amount_to_encumber CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_TO_ENCUMBER');
29: d_style_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_ID');
30: d_amount_limit CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_LIMIT');
31:
32: -------------------------------------------------------------------------
33: -- po_header_id cannot be null and must not exist in Transaction header table.

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

26: d_closed_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CLOSED_CODE');
27: d_print_count CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PRINT_COUNT');
28: d_amount_to_encumber CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_TO_ENCUMBER');
29: d_style_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'STYLE_ID');
30: d_amount_limit CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_LIMIT');
31:
32: -------------------------------------------------------------------------
33: -- po_header_id cannot be null and must not exist in Transaction header table.
34: -- Called for the create case.

Line 48: IF po_log.d_proc THEN

44: IF x_result_set_id IS NULL THEN
45: x_result_set_id := po_validations.next_result_set_id();
46: END IF;
47:
48: IF po_log.d_proc THEN
49: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
50: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
51: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
52: END IF;

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

45: x_result_set_id := po_validations.next_result_set_id();
46: END IF;
47:
48: IF po_log.d_proc THEN
49: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
50: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
51: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
52: END IF;
53:

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

46: END IF;
47:
48: IF po_log.d_proc THEN
49: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
50: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
51: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
52: END IF;
53:
54: x_result_type := po_validations.c_result_type_success;

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

47:
48: IF po_log.d_proc THEN
49: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
50: po_log.proc_begin(d_mod, 'p_po_header_id_tbl', p_po_header_id_tbl);
51: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
52: END IF;
53:
54: x_result_type := po_validations.c_result_type_success;
55: FORALL i IN 1 .. p_id_tbl.COUNT

Line 91: IF po_log.d_proc THEN

87: IF (SQL%ROWCOUNT > 0) THEN
88: x_result_type := po_validations.c_result_type_failure;
89: END IF;
90:
91: IF po_log.d_proc THEN
92: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
93: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
94: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
95: END IF;

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

89: END IF;
90:
91: IF po_log.d_proc THEN
92: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
93: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
94: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
95: END IF;
96: EXCEPTION
97: WHEN OTHERS THEN

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

90:
91: IF po_log.d_proc THEN
92: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
93: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
94: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
95: END IF;
96: EXCEPTION
97: WHEN OTHERS THEN
98: IF po_log.d_exc THEN

Line 98: IF po_log.d_exc THEN

94: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
95: END IF;
96: EXCEPTION
97: WHEN OTHERS THEN
98: IF po_log.d_exc THEN
99: po_log.exc(d_mod, 0, NULL);
100: END IF;
101:
102: RAISE;

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

95: END IF;
96: EXCEPTION
97: WHEN OTHERS THEN
98: IF po_log.d_exc THEN
99: po_log.exc(d_mod, 0, NULL);
100: END IF;
101:
102: RAISE;
103: END po_header_id;

Line 130: IF po_log.d_proc THEN

126: IF (x_results IS NULL) THEN
127: x_results := po_validation_results_type.new_instance();
128: END IF;
129:
130: IF po_log.d_proc THEN
131: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
132: po_log.proc_begin(d_mod, 'p_document_num_tbl', p_document_num_tbl);
133: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
134: po_log.proc_begin(d_mod, 'p_manual_po_num_type', p_manual_po_num_type);

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

127: x_results := po_validation_results_type.new_instance();
128: END IF;
129:
130: IF po_log.d_proc THEN
131: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
132: po_log.proc_begin(d_mod, 'p_document_num_tbl', p_document_num_tbl);
133: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
134: po_log.proc_begin(d_mod, 'p_manual_po_num_type', p_manual_po_num_type);
135: po_log.proc_begin(d_mod, 'p_manual_quote_num_type', p_manual_quote_num_type);

Line 132: po_log.proc_begin(d_mod, 'p_document_num_tbl', p_document_num_tbl);

128: END IF;
129:
130: IF po_log.d_proc THEN
131: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
132: po_log.proc_begin(d_mod, 'p_document_num_tbl', p_document_num_tbl);
133: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
134: po_log.proc_begin(d_mod, 'p_manual_po_num_type', p_manual_po_num_type);
135: po_log.proc_begin(d_mod, 'p_manual_quote_num_type', p_manual_quote_num_type);
136: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 133: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);

129:
130: IF po_log.d_proc THEN
131: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
132: po_log.proc_begin(d_mod, 'p_document_num_tbl', p_document_num_tbl);
133: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
134: po_log.proc_begin(d_mod, 'p_manual_po_num_type', p_manual_po_num_type);
135: po_log.proc_begin(d_mod, 'p_manual_quote_num_type', p_manual_quote_num_type);
136: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 134: po_log.proc_begin(d_mod, 'p_manual_po_num_type', p_manual_po_num_type);

130: IF po_log.d_proc THEN
131: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
132: po_log.proc_begin(d_mod, 'p_document_num_tbl', p_document_num_tbl);
133: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
134: po_log.proc_begin(d_mod, 'p_manual_po_num_type', p_manual_po_num_type);
135: po_log.proc_begin(d_mod, 'p_manual_quote_num_type', p_manual_quote_num_type);
136: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
138: END IF;

Line 135: po_log.proc_begin(d_mod, 'p_manual_quote_num_type', p_manual_quote_num_type);

131: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
132: po_log.proc_begin(d_mod, 'p_document_num_tbl', p_document_num_tbl);
133: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
134: po_log.proc_begin(d_mod, 'p_manual_po_num_type', p_manual_po_num_type);
135: po_log.proc_begin(d_mod, 'p_manual_quote_num_type', p_manual_quote_num_type);
136: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
138: END IF;
139:

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

132: po_log.proc_begin(d_mod, 'p_document_num_tbl', p_document_num_tbl);
133: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
134: po_log.proc_begin(d_mod, 'p_manual_po_num_type', p_manual_po_num_type);
135: po_log.proc_begin(d_mod, 'p_manual_quote_num_type', p_manual_quote_num_type);
136: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
138: END IF;
139:
140: x_result_type := po_validations.c_result_type_success;

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

133: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
134: po_log.proc_begin(d_mod, 'p_manual_po_num_type', p_manual_po_num_type);
135: po_log.proc_begin(d_mod, 'p_manual_quote_num_type', p_manual_quote_num_type);
136: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
137: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
138: END IF;
139:
140: x_result_type := po_validations.c_result_type_success;
141: -- Bulk validate document_num uniqueness

Line 240: IF po_log.d_proc THEN

236: END;
237: END IF;
238: END LOOP;
239:
240: IF po_log.d_proc THEN
241: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
242: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
243: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
244: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

238: END LOOP;
239:
240: IF po_log.d_proc THEN
241: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
242: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
243: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
244: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
245: END IF;
246: EXCEPTION

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

239:
240: IF po_log.d_proc THEN
241: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
242: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
243: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
244: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
245: END IF;
246: EXCEPTION
247: WHEN OTHERS THEN

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

240: IF po_log.d_proc THEN
241: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
242: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
243: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
244: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
245: END IF;
246: EXCEPTION
247: WHEN OTHERS THEN
248: IF po_log.d_exc THEN

Line 248: IF po_log.d_exc THEN

244: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
245: END IF;
246: EXCEPTION
247: WHEN OTHERS THEN
248: IF po_log.d_exc THEN
249: po_log.exc(d_mod, 0, NULL);
250: END IF;
251:
252: RAISE;

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

245: END IF;
246: EXCEPTION
247: WHEN OTHERS THEN
248: IF po_log.d_exc THEN
249: po_log.exc(d_mod, 0, NULL);
250: END IF;
251:
252: RAISE;
253:

Line 272: IF po_log.d_proc THEN

268: IF (x_results IS NULL) THEN
269: x_results := po_validation_results_type.new_instance();
270: END IF;
271:
272: IF po_log.d_proc THEN
273: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
274: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
275: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
276: END IF;

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

269: x_results := po_validation_results_type.new_instance();
270: END IF;
271:
272: IF po_log.d_proc THEN
273: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
274: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
275: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
276: END IF;
277:

Line 274: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);

270: END IF;
271:
272: IF po_log.d_proc THEN
273: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
274: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
275: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
276: END IF;
277:
278: x_result_type := po_validations.c_result_type_success;

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

271:
272: IF po_log.d_proc THEN
273: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
274: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
275: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
276: END IF;
277:
278: x_result_type := po_validations.c_result_type_success;
279:

Line 306: IF po_log.d_proc THEN

302: x_result_type := po_validations.c_result_type_failure;
303: END IF;
304: END LOOP;
305:
306: IF po_log.d_proc THEN
307: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
308: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
309: END IF;
310: EXCEPTION

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

303: END IF;
304: END LOOP;
305:
306: IF po_log.d_proc THEN
307: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
308: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
309: END IF;
310: EXCEPTION
311: WHEN OTHERS THEN

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

304: END LOOP;
305:
306: IF po_log.d_proc THEN
307: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
308: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
309: END IF;
310: EXCEPTION
311: WHEN OTHERS THEN
312: IF po_log.d_exc THEN

Line 312: IF po_log.d_exc THEN

308: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
309: END IF;
310: EXCEPTION
311: WHEN OTHERS THEN
312: IF po_log.d_exc THEN
313: po_log.exc(d_mod, 0, NULL);
314: END IF;
315:
316: RAISE;

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

309: END IF;
310: EXCEPTION
311: WHEN OTHERS THEN
312: IF po_log.d_exc THEN
313: po_log.exc(d_mod, 0, NULL);
314: END IF;
315:
316: RAISE;
317: END type_lookup_code;

Line 334: IF po_log.d_proc THEN

330: IF x_result_set_id IS NULL THEN
331: x_result_set_id := po_validations.next_result_set_id();
332: END IF;
333:
334: IF po_log.d_proc THEN
335: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
336: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
337: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
338: END IF;

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

331: x_result_set_id := po_validations.next_result_set_id();
332: END IF;
333:
334: IF po_log.d_proc THEN
335: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
336: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
337: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
338: END IF;
339:

Line 336: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);

332: END IF;
333:
334: IF po_log.d_proc THEN
335: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
336: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
337: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
338: END IF;
339:
340: x_result_type := po_validations.c_result_type_success;

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

333:
334: IF po_log.d_proc THEN
335: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
336: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
337: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
338: END IF;
339:
340: x_result_type := po_validations.c_result_type_success;
341: -- Bulk validate currency_code not null and against FND_CURRENCIES

Line 383: IF po_log.d_proc THEN

379: IF (SQL%ROWCOUNT > 0) THEN
380: x_result_type := po_validations.c_result_type_failure;
381: END IF;
382:
383: IF po_log.d_proc THEN
384: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
385: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
386: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
387: END IF;

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

381: END IF;
382:
383: IF po_log.d_proc THEN
384: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
385: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
386: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
387: END IF;
388: EXCEPTION
389: WHEN OTHERS THEN

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

382:
383: IF po_log.d_proc THEN
384: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
385: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
386: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
387: END IF;
388: EXCEPTION
389: WHEN OTHERS THEN
390: IF po_log.d_exc THEN

Line 390: IF po_log.d_exc THEN

386: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
387: END IF;
388: EXCEPTION
389: WHEN OTHERS THEN
390: IF po_log.d_exc THEN
391: po_log.exc(d_mod, 0, NULL);
392: END IF;
393:
394: RAISE;

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

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

Line 426: IF po_log.d_proc THEN

422: IF (x_results IS NULL) THEN
423: x_results := po_validation_results_type.new_instance();
424: END IF;
425:
426: IF po_log.d_proc THEN
427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
428: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
429: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);

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

423: x_results := po_validation_results_type.new_instance();
424: END IF;
425:
426: IF po_log.d_proc THEN
427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
428: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
429: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);

Line 428: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);

424: END IF;
425:
426: IF po_log.d_proc THEN
427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
428: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
429: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
432: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);

Line 429: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);

425:
426: IF po_log.d_proc THEN
427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
428: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
429: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
432: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
433: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);

Line 430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);

426: IF po_log.d_proc THEN
427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
428: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
429: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
432: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
433: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
434: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);

427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
428: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
429: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
432: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
433: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
434: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
435: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 432: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);

428: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
429: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
432: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
433: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
434: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
435: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
436: END IF;

Line 433: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);

429: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
432: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
433: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
434: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
435: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
436: END IF;
437:

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

430: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
432: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
433: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
434: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
435: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
436: END IF;
437:
438: x_result_type := po_validations.c_result_type_success;

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

431: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
432: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
433: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
434: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
435: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
436: END IF;
437:
438: x_result_type := po_validations.c_result_type_success;
439:

Line 598: IF po_log.d_proc THEN

594: IF (SQL%ROWCOUNT > 0) THEN
595: x_result_type := po_validations.c_result_type_failure;
596: END IF;
597:
598: IF po_log.d_proc THEN
599: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
600: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
601: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
602: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

596: END IF;
597:
598: IF po_log.d_proc THEN
599: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
600: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
601: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
602: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
603: END IF;
604: EXCEPTION

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

597:
598: IF po_log.d_proc THEN
599: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
600: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
601: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
602: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
603: END IF;
604: EXCEPTION
605: WHEN OTHERS THEN

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

598: IF po_log.d_proc THEN
599: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
600: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
601: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
602: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
603: END IF;
604: EXCEPTION
605: WHEN OTHERS THEN
606: IF po_log.d_exc THEN

Line 606: IF po_log.d_exc THEN

602: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
603: END IF;
604: EXCEPTION
605: WHEN OTHERS THEN
606: IF po_log.d_exc THEN
607: po_log.exc(d_mod, 0, NULL);
608: END IF;
609:
610: RAISE;

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

603: END IF;
604: EXCEPTION
605: WHEN OTHERS THEN
606: IF po_log.d_exc THEN
607: po_log.exc(d_mod, 0, NULL);
608: END IF;
609:
610: RAISE;
611: END rate_info;

Line 628: IF po_log.d_proc THEN

624: IF x_result_set_id IS NULL THEN
625: x_result_set_id := po_validations.next_result_set_id();
626: END IF;
627:
628: IF po_log.d_proc THEN
629: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
630: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
631: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
632: END IF;

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

625: x_result_set_id := po_validations.next_result_set_id();
626: END IF;
627:
628: IF po_log.d_proc THEN
629: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
630: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
631: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
632: END IF;
633:

Line 630: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);

626: END IF;
627:
628: IF po_log.d_proc THEN
629: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
630: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
631: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
632: END IF;
633:
634: x_result_type := po_validations.c_result_type_success;

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

627:
628: IF po_log.d_proc THEN
629: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
630: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
631: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
632: END IF;
633:
634: x_result_type := po_validations.c_result_type_success;
635: -- validate agent_id against PO_AGENTS

Line 676: IF po_log.d_proc THEN

672: IF (SQL%ROWCOUNT > 0) THEN
673: x_result_type := po_validations.c_result_type_failure;
674: END IF;
675:
676: IF po_log.d_proc THEN
677: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
678: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
679: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
680: END IF;

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

674: END IF;
675:
676: IF po_log.d_proc THEN
677: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
678: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
679: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN

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

675:
676: IF po_log.d_proc THEN
677: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
678: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
679: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: IF po_log.d_exc THEN

Line 683: IF po_log.d_exc THEN

679: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: IF po_log.d_exc THEN
684: po_log.exc(d_mod, 0, NULL);
685: END IF;
686:
687: RAISE;

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

680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: IF po_log.d_exc THEN
684: po_log.exc(d_mod, 0, NULL);
685: END IF;
686:
687: RAISE;
688: END agent_id;

Line 731: IF po_log.d_proc THEN

727: IF (x_results IS NULL) THEN
728: x_results := po_validation_results_type.new_instance();
729: END IF;
730:
731: IF po_log.d_proc THEN
732: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
733: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
734: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
735: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);

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

728: x_results := po_validation_results_type.new_instance();
729: END IF;
730:
731: IF po_log.d_proc THEN
732: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
733: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
734: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
735: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
736: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);

Line 733: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);

729: END IF;
730:
731: IF po_log.d_proc THEN
732: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
733: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
734: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
735: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
736: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
737: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 734: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);

730:
731: IF po_log.d_proc THEN
732: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
733: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
734: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
735: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
736: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
737: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
738: END IF;

Line 735: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);

731: IF po_log.d_proc THEN
732: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
733: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
734: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
735: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
736: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
737: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
738: END IF;
739:

Line 736: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);

732: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
733: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
734: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
735: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
736: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
737: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
738: END IF;
739:
740: x_result_type := po_validations.c_result_type_success;

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

733: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
734: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
735: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
736: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
737: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
738: END IF;
739:
740: x_result_type := po_validations.c_result_type_success;
741: FORALL i IN 1 .. p_id_tbl.COUNT

Line 888: IF po_log.d_proc THEN

884: END;
885: END LOOP;
886: END IF;
887:
888: IF po_log.d_proc THEN
889: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
890: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
891: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
892: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

886: END IF;
887:
888: IF po_log.d_proc THEN
889: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
890: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
891: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
892: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
893: END IF;
894: EXCEPTION

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

887:
888: IF po_log.d_proc THEN
889: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
890: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
891: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
892: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
893: END IF;
894: EXCEPTION
895: WHEN OTHERS THEN

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

888: IF po_log.d_proc THEN
889: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
890: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
891: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
892: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
893: END IF;
894: EXCEPTION
895: WHEN OTHERS THEN
896: IF po_log.d_exc THEN

Line 896: IF po_log.d_exc THEN

892: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
893: END IF;
894: EXCEPTION
895: WHEN OTHERS THEN
896: IF po_log.d_exc THEN
897: po_log.exc(d_mod, 0, NULL);
898: END IF;
899:
900: RAISE;

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

893: END IF;
894: EXCEPTION
895: WHEN OTHERS THEN
896: IF po_log.d_exc THEN
897: po_log.exc(d_mod, 0, NULL);
898: END IF;
899:
900: RAISE;
901: END vendor_info;

Line 920: IF po_log.d_proc THEN

916: IF x_result_set_id IS NULL THEN
917: x_result_set_id := po_validations.next_result_set_id();
918: END IF;
919:
920: IF po_log.d_proc THEN
921: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
922: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
923: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
924: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

917: x_result_set_id := po_validations.next_result_set_id();
918: END IF;
919:
920: IF po_log.d_proc THEN
921: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
922: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
923: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
924: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
925: END IF;

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

918: END IF;
919:
920: IF po_log.d_proc THEN
921: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
922: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
923: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
924: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
925: END IF;
926:

Line 923: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);

919:
920: IF po_log.d_proc THEN
921: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
922: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
923: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
924: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
925: END IF;
926:
927: x_result_type := po_validations.c_result_type_success;

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

920: IF po_log.d_proc THEN
921: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
922: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
923: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
924: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
925: END IF;
926:
927: x_result_type := po_validations.c_result_type_success;
928: -- validate ship_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS

Line 972: IF po_log.d_proc THEN

968: IF (SQL%ROWCOUNT > 0) THEN
969: x_result_type := po_validations.c_result_type_failure;
970: END IF;
971:
972: IF po_log.d_proc THEN
973: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
974: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
975: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
976: END IF;

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

970: END IF;
971:
972: IF po_log.d_proc THEN
973: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
974: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
975: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
976: END IF;
977: EXCEPTION
978: WHEN OTHERS THEN

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

971:
972: IF po_log.d_proc THEN
973: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
974: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
975: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
976: END IF;
977: EXCEPTION
978: WHEN OTHERS THEN
979: IF po_log.d_exc THEN

Line 979: IF po_log.d_exc THEN

975: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
976: END IF;
977: EXCEPTION
978: WHEN OTHERS THEN
979: IF po_log.d_exc THEN
980: po_log.exc(d_mod, 0, NULL);
981: END IF;
982:
983: RAISE;

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

976: END IF;
977: EXCEPTION
978: WHEN OTHERS THEN
979: IF po_log.d_exc THEN
980: po_log.exc(d_mod, 0, NULL);
981: END IF;
982:
983: RAISE;
984: END ship_to_location_id;

Line 1003: IF po_log.d_proc THEN

999: IF x_result_set_id IS NULL THEN
1000: x_result_set_id := po_validations.next_result_set_id();
1001: END IF;
1002:
1003: IF po_log.d_proc THEN
1004: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1005: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1006: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1007: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

1000: x_result_set_id := po_validations.next_result_set_id();
1001: END IF;
1002:
1003: IF po_log.d_proc THEN
1004: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1005: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1006: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1007: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1008: END IF;

Line 1005: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);

1001: END IF;
1002:
1003: IF po_log.d_proc THEN
1004: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1005: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1006: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1007: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1008: END IF;
1009:

Line 1006: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);

1002:
1003: IF po_log.d_proc THEN
1004: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1005: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1006: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1007: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1008: END IF;
1009:
1010: x_result_type := po_validations.c_result_type_success;

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

1003: IF po_log.d_proc THEN
1004: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1005: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1006: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1007: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1008: END IF;
1009:
1010: x_result_type := po_validations.c_result_type_success;
1011: -- validate bill_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS

Line 1055: IF po_log.d_proc THEN

1051: IF (SQL%ROWCOUNT > 0) THEN
1052: x_result_type := po_validations.c_result_type_failure;
1053: END IF;
1054:
1055: IF po_log.d_proc THEN
1056: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1057: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1058: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1059: END IF;

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

1053: END IF;
1054:
1055: IF po_log.d_proc THEN
1056: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1057: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1058: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1059: END IF;
1060: EXCEPTION
1061: WHEN OTHERS THEN

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

1054:
1055: IF po_log.d_proc THEN
1056: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1057: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1058: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1059: END IF;
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: IF po_log.d_exc THEN

Line 1062: IF po_log.d_exc THEN

1058: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1059: END IF;
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: IF po_log.d_exc THEN
1063: po_log.exc(d_mod, 0, NULL);
1064: END IF;
1065:
1066: RAISE;

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

1059: END IF;
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: IF po_log.d_exc THEN
1063: po_log.exc(d_mod, 0, NULL);
1064: END IF;
1065:
1066: RAISE;
1067: END bill_to_location_id;

Line 1085: IF po_log.d_proc THEN

1081: IF x_result_set_id IS NULL THEN
1082: x_result_set_id := po_validations.next_result_set_id();
1083: END IF;
1084:
1085: IF po_log.d_proc THEN
1086: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1087: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1088: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1089: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

1082: x_result_set_id := po_validations.next_result_set_id();
1083: END IF;
1084:
1085: IF po_log.d_proc THEN
1086: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1087: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1088: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1089: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1090: END IF;

Line 1087: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);

1083: END IF;
1084:
1085: IF po_log.d_proc THEN
1086: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1087: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1088: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1089: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1090: END IF;
1091:

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

1084:
1085: IF po_log.d_proc THEN
1086: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1087: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1088: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1089: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1090: END IF;
1091:
1092: x_result_type := po_validations.c_result_type_success;

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

1085: IF po_log.d_proc THEN
1086: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1087: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1088: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1089: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1090: END IF;
1091:
1092: x_result_type := po_validations.c_result_type_success;
1093: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1128: IF po_log.d_proc THEN

1124: IF (SQL%ROWCOUNT > 0) THEN
1125: x_result_type := po_validations.c_result_type_failure;
1126: END IF;
1127:
1128: IF po_log.d_proc THEN
1129: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1130: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1131: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1132: END IF;

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

1126: END IF;
1127:
1128: IF po_log.d_proc THEN
1129: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1130: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1131: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1132: END IF;
1133: EXCEPTION
1134: WHEN OTHERS THEN

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

1127:
1128: IF po_log.d_proc THEN
1129: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1130: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1131: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1132: END IF;
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: IF po_log.d_exc THEN

Line 1135: IF po_log.d_exc THEN

1131: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1132: END IF;
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: IF po_log.d_exc THEN
1136: po_log.exc(d_mod, 0, NULL);
1137: END IF;
1138:
1139: RAISE;

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

1132: END IF;
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: IF po_log.d_exc THEN
1136: po_log.exc(d_mod, 0, NULL);
1137: END IF;
1138:
1139: RAISE;
1140: END ship_via_lookup_code;

Line 1157: IF po_log.d_proc THEN

1153: IF (x_result_set_id IS NULL) THEN
1154: x_result_set_id := po_validations.next_result_set_id();
1155: END IF;
1156:
1157: IF po_log.d_proc THEN
1158: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1159: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1160: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1161: END IF;

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

1154: x_result_set_id := po_validations.next_result_set_id();
1155: END IF;
1156:
1157: IF po_log.d_proc THEN
1158: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1159: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1160: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1161: END IF;
1162:

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

1155: END IF;
1156:
1157: IF po_log.d_proc THEN
1158: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1159: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1160: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1161: END IF;
1162:
1163: x_result_type := po_validations.c_result_type_success;

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

1156:
1157: IF po_log.d_proc THEN
1158: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1159: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1160: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1161: END IF;
1162:
1163: x_result_type := po_validations.c_result_type_success;
1164: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1199: IF po_log.d_proc THEN

1195: IF (SQL%ROWCOUNT > 0) THEN
1196: x_result_type := po_validations.c_result_type_failure;
1197: END IF;
1198:
1199: IF po_log.d_proc THEN
1200: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1201: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1202: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1203: END IF;

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

1197: END IF;
1198:
1199: IF po_log.d_proc THEN
1200: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1201: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1202: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1203: END IF;
1204: EXCEPTION
1205: WHEN OTHERS THEN

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

1198:
1199: IF po_log.d_proc THEN
1200: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1201: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1202: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1203: END IF;
1204: EXCEPTION
1205: WHEN OTHERS THEN
1206: IF po_log.d_exc THEN

Line 1206: IF po_log.d_exc THEN

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

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

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

Line 1228: IF po_log.d_proc THEN

1224: IF (x_result_set_id IS NULL) THEN
1225: x_result_set_id := po_validations.next_result_set_id();
1226: END IF;
1227:
1228: IF po_log.d_proc THEN
1229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1230: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1231: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1232: END IF;

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

1225: x_result_set_id := po_validations.next_result_set_id();
1226: END IF;
1227:
1228: IF po_log.d_proc THEN
1229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1230: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1231: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1232: END IF;
1233:

Line 1230: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);

1226: END IF;
1227:
1228: IF po_log.d_proc THEN
1229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1230: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1231: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1232: END IF;
1233:
1234: x_result_type := po_validations.c_result_type_success;

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

1227:
1228: IF po_log.d_proc THEN
1229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1230: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1231: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1232: END IF;
1233:
1234: x_result_type := po_validations.c_result_type_success;
1235: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1270: IF po_log.d_proc THEN

1266: IF (SQL%ROWCOUNT > 0) THEN
1267: x_result_type := po_validations.c_result_type_failure;
1268: END IF;
1269:
1270: IF po_log.d_proc THEN
1271: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1272: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1273: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1274: END IF;

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

1268: END IF;
1269:
1270: IF po_log.d_proc THEN
1271: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1272: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1273: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1274: END IF;
1275: EXCEPTION
1276: WHEN OTHERS THEN

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

1269:
1270: IF po_log.d_proc THEN
1271: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1272: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1273: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1274: END IF;
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: IF po_log.d_exc THEN

Line 1277: IF po_log.d_exc THEN

1273: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1274: END IF;
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: IF po_log.d_exc THEN
1278: po_log.exc(d_mod, 0, NULL);
1279: END IF;
1280:
1281: RAISE;

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

1274: END IF;
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: IF po_log.d_exc THEN
1278: po_log.exc(d_mod, 0, NULL);
1279: END IF;
1280:
1281: RAISE;
1282: END freight_terms_lookup_code;

Line 1299: IF po_log.d_proc THEN

1295: IF (x_result_set_id IS NULL) THEN
1296: x_result_set_id := po_validations.next_result_set_id();
1297: END IF;
1298:
1299: IF po_log.d_proc THEN
1300: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1301: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1302: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1303: END IF;

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

1296: x_result_set_id := po_validations.next_result_set_id();
1297: END IF;
1298:
1299: IF po_log.d_proc THEN
1300: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1301: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1302: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1303: END IF;
1304:

Line 1301: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);

1297: END IF;
1298:
1299: IF po_log.d_proc THEN
1300: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1301: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1302: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1303: END IF;
1304:
1305: x_result_type := po_validations.c_result_type_success;

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

1298:
1299: IF po_log.d_proc THEN
1300: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1301: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1302: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1303: END IF;
1304:
1305: x_result_type := po_validations.c_result_type_success;
1306: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1341: IF po_log.d_proc THEN

1337: IF (SQL%ROWCOUNT > 0) THEN
1338: x_result_type := po_validations.c_result_type_failure;
1339: END IF;
1340:
1341: IF po_log.d_proc THEN
1342: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1343: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1344: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1345: END IF;

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

1339: END IF;
1340:
1341: IF po_log.d_proc THEN
1342: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1343: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1344: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1345: END IF;
1346: EXCEPTION
1347: WHEN OTHERS THEN

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

1340:
1341: IF po_log.d_proc THEN
1342: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1343: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1344: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1345: END IF;
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: IF po_log.d_exc THEN

Line 1348: IF po_log.d_exc THEN

1344: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1345: END IF;
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: IF po_log.d_exc THEN
1349: po_log.exc(d_mod, 0, NULL);
1350: END IF;
1351:
1352: RAISE;

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

1345: END IF;
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: IF po_log.d_exc THEN
1349: po_log.exc(d_mod, 0, NULL);
1350: END IF;
1351:
1352: RAISE;
1353: END shipping_control;

Line 1372: IF po_log.d_proc THEN

1368: IF (x_results IS NULL) THEN
1369: x_results := po_validation_results_type.new_instance();
1370: END IF;
1371:
1372: IF po_log.d_proc THEN
1373: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1375: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1376: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1369: x_results := po_validation_results_type.new_instance();
1370: END IF;
1371:
1372: IF po_log.d_proc THEN
1373: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1375: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1376: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1377: END IF;

Line 1374: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);

1370: END IF;
1371:
1372: IF po_log.d_proc THEN
1373: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1375: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1376: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1377: END IF;
1378:

Line 1375: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);

1371:
1372: IF po_log.d_proc THEN
1373: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1375: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1376: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1377: END IF;
1378:
1379: x_result_type := po_validations.c_result_type_success;

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

1372: IF po_log.d_proc THEN
1373: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1375: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1376: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1377: END IF;
1378:
1379: x_result_type := po_validations.c_result_type_success;
1380:

Line 1398: IF po_log.d_proc THEN

1394: x_result_type := po_validations.c_result_type_failure;
1395: END IF;
1396: END LOOP;*/
1397:
1398: IF po_log.d_proc THEN
1399: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1400: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1401: END IF;
1402: EXCEPTION

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

1395: END IF;
1396: END LOOP;*/
1397:
1398: IF po_log.d_proc THEN
1399: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1400: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1401: END IF;
1402: EXCEPTION
1403: WHEN OTHERS THEN

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

1396: END LOOP;*/
1397:
1398: IF po_log.d_proc THEN
1399: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1400: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1401: END IF;
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: IF po_log.d_exc THEN

Line 1404: IF po_log.d_exc THEN

1400: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1401: END IF;
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: IF po_log.d_exc THEN
1405: po_log.exc(d_mod, 0, NULL);
1406: END IF;
1407:
1408: RAISE;

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

1401: END IF;
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: IF po_log.d_exc THEN
1405: po_log.exc(d_mod, 0, NULL);
1406: END IF;
1407:
1408: RAISE;
1409: END acceptance_due_date;

Line 1426: IF po_log.d_proc THEN

1422: IF (x_results IS NULL) THEN
1423: x_results := po_validation_results_type.new_instance();
1424: END IF;
1425:
1426: IF po_log.d_proc THEN
1427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1428: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1429: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1430: END IF;

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

1423: x_results := po_validation_results_type.new_instance();
1424: END IF;
1425:
1426: IF po_log.d_proc THEN
1427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1428: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1429: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1430: END IF;
1431:

Line 1428: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);

1424: END IF;
1425:
1426: IF po_log.d_proc THEN
1427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1428: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1429: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1430: END IF;
1431:
1432: x_result_type := po_validations.c_result_type_success;

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

1425:
1426: IF po_log.d_proc THEN
1427: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1428: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1429: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1430: END IF;
1431:
1432: x_result_type := po_validations.c_result_type_success;
1433:

Line 1451: IF po_log.d_proc THEN

1447: x_result_type := po_validations.c_result_type_failure;
1448: END IF;
1449: END LOOP;
1450:
1451: IF po_log.d_proc THEN
1452: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1453: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1454: END IF;
1455: EXCEPTION

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

1448: END IF;
1449: END LOOP;
1450:
1451: IF po_log.d_proc THEN
1452: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1453: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1454: END IF;
1455: EXCEPTION
1456: WHEN OTHERS THEN

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

1449: END LOOP;
1450:
1451: IF po_log.d_proc THEN
1452: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1453: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1454: END IF;
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: IF po_log.d_exc THEN

Line 1457: IF po_log.d_exc THEN

1453: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1454: END IF;
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: IF po_log.d_exc THEN
1458: po_log.exc(d_mod, 0, NULL);
1459: END IF;
1460:
1461: RAISE;

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

1454: END IF;
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: IF po_log.d_exc THEN
1458: po_log.exc(d_mod, 0, NULL);
1459: END IF;
1460:
1461: RAISE;
1462: END cancel_flag;

Line 1480: IF po_log.d_proc THEN

1476: IF (x_results IS NULL) THEN
1477: x_results := po_validation_results_type.new_instance();
1478: END IF;
1479:
1480: IF po_log.d_proc THEN
1481: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1482: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1483: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1484: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1477: x_results := po_validation_results_type.new_instance();
1478: END IF;
1479:
1480: IF po_log.d_proc THEN
1481: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1482: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1483: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1484: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1485: END IF;

Line 1482: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);

1478: END IF;
1479:
1480: IF po_log.d_proc THEN
1481: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1482: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1483: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1484: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1485: END IF;
1486:

Line 1483: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);

1479:
1480: IF po_log.d_proc THEN
1481: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1482: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1483: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1484: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1485: END IF;
1486:
1487: x_result_type := po_validations.c_result_type_success;

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

1480: IF po_log.d_proc THEN
1481: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1482: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1483: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1484: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1485: END IF;
1486:
1487: x_result_type := po_validations.c_result_type_success;
1488:

Line 1506: IF po_log.d_proc THEN

1502: x_result_type := po_validations.c_result_type_failure;
1503: END IF;
1504: END LOOP;
1505:
1506: IF po_log.d_proc THEN
1507: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1508: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1509: END IF;
1510: EXCEPTION

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

1503: END IF;
1504: END LOOP;
1505:
1506: IF po_log.d_proc THEN
1507: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1508: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1509: END IF;
1510: EXCEPTION
1511: WHEN OTHERS THEN

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

1504: END LOOP;
1505:
1506: IF po_log.d_proc THEN
1507: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1508: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1509: END IF;
1510: EXCEPTION
1511: WHEN OTHERS THEN
1512: IF po_log.d_exc THEN

Line 1512: IF po_log.d_exc THEN

1508: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1509: END IF;
1510: EXCEPTION
1511: WHEN OTHERS THEN
1512: IF po_log.d_exc THEN
1513: po_log.exc(d_mod, 0, NULL);
1514: END IF;
1515:
1516: RAISE;

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

1509: END IF;
1510: EXCEPTION
1511: WHEN OTHERS THEN
1512: IF po_log.d_exc THEN
1513: po_log.exc(d_mod, 0, NULL);
1514: END IF;
1515:
1516: RAISE;
1517: END closed_code;

Line 1535: IF po_log.d_proc THEN

1531: IF (x_results IS NULL) THEN
1532: x_results := po_validation_results_type.new_instance();
1533: END IF;
1534:
1535: IF po_log.d_proc THEN
1536: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1537: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1538: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1539: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1532: x_results := po_validation_results_type.new_instance();
1533: END IF;
1534:
1535: IF po_log.d_proc THEN
1536: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1537: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1538: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1539: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1540: END IF;

Line 1537: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);

1533: END IF;
1534:
1535: IF po_log.d_proc THEN
1536: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1537: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1538: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1539: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1540: END IF;
1541:

Line 1538: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);

1534:
1535: IF po_log.d_proc THEN
1536: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1537: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1538: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1539: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1540: END IF;
1541:
1542: x_result_type := po_validations.c_result_type_success;

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

1535: IF po_log.d_proc THEN
1536: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1537: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1538: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1539: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1540: END IF;
1541:
1542: x_result_type := po_validations.c_result_type_success;
1543:

Line 1560: IF po_log.d_proc THEN

1556: x_result_type := po_validations.c_result_type_failure;
1557: END IF;
1558: END LOOP;
1559:
1560: IF po_log.d_proc THEN
1561: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1562: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1563: END IF;
1564: EXCEPTION

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

1557: END IF;
1558: END LOOP;
1559:
1560: IF po_log.d_proc THEN
1561: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1562: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1563: END IF;
1564: EXCEPTION
1565: WHEN OTHERS THEN

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

1558: END LOOP;
1559:
1560: IF po_log.d_proc THEN
1561: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1562: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1563: END IF;
1564: EXCEPTION
1565: WHEN OTHERS THEN
1566: IF po_log.d_exc THEN

Line 1566: IF po_log.d_exc THEN

1562: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1563: END IF;
1564: EXCEPTION
1565: WHEN OTHERS THEN
1566: IF po_log.d_exc THEN
1567: po_log.exc(d_mod, 0, NULL);
1568: END IF;
1569:
1570: RAISE;

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

1563: END IF;
1564: EXCEPTION
1565: WHEN OTHERS THEN
1566: IF po_log.d_exc THEN
1567: po_log.exc(d_mod, 0, NULL);
1568: END IF;
1569:
1570: RAISE;
1571: END print_count;

Line 1589: IF po_log.d_proc THEN

1585: IF (x_results IS NULL) THEN
1586: x_results := po_validation_results_type.new_instance();
1587: END IF;
1588:
1589: IF po_log.d_proc THEN
1590: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1591: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1592: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1593: END IF;

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

1586: x_results := po_validation_results_type.new_instance();
1587: END IF;
1588:
1589: IF po_log.d_proc THEN
1590: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1591: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1592: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1593: END IF;
1594:

Line 1591: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);

1587: END IF;
1588:
1589: IF po_log.d_proc THEN
1590: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1591: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1592: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1593: END IF;
1594:
1595: x_result_type := po_validations.c_result_type_success;

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

1588:
1589: IF po_log.d_proc THEN
1590: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1591: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1592: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1593: END IF;
1594:
1595: x_result_type := po_validations.c_result_type_success;
1596:

Line 1609: IF po_log.d_proc THEN

1605: x_result_type := po_validations.c_result_type_failure;
1606: END IF;
1607: END LOOP;
1608:
1609: IF po_log.d_proc THEN
1610: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1611: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1612: END IF;
1613: EXCEPTION

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

1606: END IF;
1607: END LOOP;
1608:
1609: IF po_log.d_proc THEN
1610: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1611: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1612: END IF;
1613: EXCEPTION
1614: WHEN OTHERS THEN

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

1607: END LOOP;
1608:
1609: IF po_log.d_proc THEN
1610: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1611: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1612: END IF;
1613: EXCEPTION
1614: WHEN OTHERS THEN
1615: IF po_log.d_exc THEN

Line 1615: IF po_log.d_exc THEN

1611: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1612: END IF;
1613: EXCEPTION
1614: WHEN OTHERS THEN
1615: IF po_log.d_exc THEN
1616: po_log.exc(d_mod, 0, NULL);
1617: END IF;
1618:
1619: RAISE;

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

1612: END IF;
1613: EXCEPTION
1614: WHEN OTHERS THEN
1615: IF po_log.d_exc THEN
1616: po_log.exc(d_mod, 0, NULL);
1617: END IF;
1618:
1619: RAISE;
1620: END approval_status;

Line 1637: IF po_log.d_proc THEN

1633: IF (x_results IS NULL) THEN
1634: x_results := po_validation_results_type.new_instance();
1635: END IF;
1636:
1637: IF po_log.d_proc THEN
1638: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1639: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1640: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1641: END IF;

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

1634: x_results := po_validation_results_type.new_instance();
1635: END IF;
1636:
1637: IF po_log.d_proc THEN
1638: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1639: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1640: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1641: END IF;
1642:

Line 1639: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);

1635: END IF;
1636:
1637: IF po_log.d_proc THEN
1638: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1639: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1640: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1641: END IF;
1642:
1643: x_result_type := po_validations.c_result_type_success;

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

1636:
1637: IF po_log.d_proc THEN
1638: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1639: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1640: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1641: END IF;
1642:
1643: x_result_type := po_validations.c_result_type_success;
1644:

Line 1661: IF po_log.d_proc THEN

1657: x_result_type := po_validations.c_result_type_failure;
1658: END IF;
1659: END LOOP;
1660:
1661: IF po_log.d_proc THEN
1662: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1663: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1664: END IF;
1665: EXCEPTION

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

1658: END IF;
1659: END LOOP;
1660:
1661: IF po_log.d_proc THEN
1662: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1663: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1664: END IF;
1665: EXCEPTION
1666: WHEN OTHERS THEN

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

1659: END LOOP;
1660:
1661: IF po_log.d_proc THEN
1662: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1663: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1664: END IF;
1665: EXCEPTION
1666: WHEN OTHERS THEN
1667: IF po_log.d_exc THEN

Line 1667: IF po_log.d_exc THEN

1663: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1664: END IF;
1665: EXCEPTION
1666: WHEN OTHERS THEN
1667: IF po_log.d_exc THEN
1668: po_log.exc(d_mod, 0, NULL);
1669: END IF;
1670:
1671: RAISE;

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

1664: END IF;
1665: EXCEPTION
1666: WHEN OTHERS THEN
1667: IF po_log.d_exc THEN
1668: po_log.exc(d_mod, 0, NULL);
1669: END IF;
1670:
1671: RAISE;
1672: END amount_to_encumber;

Line 1689: IF po_log.d_proc THEN

1685: IF x_result_set_id IS NULL THEN
1686: x_result_set_id := po_validations.next_result_set_id();
1687: END IF;
1688:
1689: IF po_log.d_proc THEN
1690: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1692: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1693: END IF;

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

1686: x_result_set_id := po_validations.next_result_set_id();
1687: END IF;
1688:
1689: IF po_log.d_proc THEN
1690: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1692: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1693: END IF;
1694:

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

1687: END IF;
1688:
1689: IF po_log.d_proc THEN
1690: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1692: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1693: END IF;
1694:
1695: x_result_type := po_validations.c_result_type_success;

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

1688:
1689: IF po_log.d_proc THEN
1690: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1691: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1692: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1693: END IF;
1694:
1695: x_result_type := po_validations.c_result_type_success;
1696:

Line 1763: IF po_log.d_proc THEN

1759: IF (SQL%ROWCOUNT > 0) THEN
1760: x_result_type := po_validations.c_result_type_failure;
1761: END IF;
1762:
1763: IF po_log.d_proc THEN
1764: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1765: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1766: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1767: END IF;

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

1761: END IF;
1762:
1763: IF po_log.d_proc THEN
1764: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1765: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1766: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1767: END IF;
1768:
1769: EXCEPTION

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

1762:
1763: IF po_log.d_proc THEN
1764: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1765: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1766: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1767: END IF;
1768:
1769: EXCEPTION
1770: WHEN OTHERS THEN

Line 1771: IF po_log.d_exc THEN

1767: END IF;
1768:
1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: IF po_log.d_exc THEN
1772: po_log.exc(d_mod, 0, NULL);
1773: END IF;
1774:
1775: RAISE;

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

1768:
1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: IF po_log.d_exc THEN
1772: po_log.exc(d_mod, 0, NULL);
1773: END IF;
1774:
1775: RAISE;
1776:

Line 1842: IF po_log.d_proc THEN

1838:
1839: END LOOP;
1840:
1841:
1842: IF po_log.d_proc THEN
1843: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1844: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1845: END IF;
1846:

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

1839: END LOOP;
1840:
1841:
1842: IF po_log.d_proc THEN
1843: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1844: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1845: END IF;
1846:
1847: EXCEPTION

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

1840:
1841:
1842: IF po_log.d_proc THEN
1843: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1844: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1845: END IF;
1846:
1847: EXCEPTION
1848: WHEN OTHERS THEN

Line 1849: IF po_log.d_exc THEN

1845: END IF;
1846:
1847: EXCEPTION
1848: WHEN OTHERS THEN
1849: IF po_log.d_exc THEN
1850: po_log.exc(d_mod, 0, NULL);
1851: END IF;
1852:
1853: RAISE;

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

1846:
1847: EXCEPTION
1848: WHEN OTHERS THEN
1849: IF po_log.d_exc THEN
1850: po_log.exc(d_mod, 0, NULL);
1851: END IF;
1852:
1853: RAISE;
1854: END acceptance_required_flag;

Line 1936: IF po_log.d_proc THEN

1932:
1933: END LOOP;
1934:
1935:
1936: IF po_log.d_proc THEN
1937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1938: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1939: END IF;
1940:

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

1933: END LOOP;
1934:
1935:
1936: IF po_log.d_proc THEN
1937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1938: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1939: END IF;
1940:
1941: EXCEPTION

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

1934:
1935:
1936: IF po_log.d_proc THEN
1937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1938: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1939: END IF;
1940:
1941: EXCEPTION
1942: WHEN OTHERS THEN

Line 1943: IF po_log.d_exc THEN

1939: END IF;
1940:
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: IF po_log.d_exc THEN
1944: po_log.exc(d_mod, 0, NULL);
1945: END IF;
1946:
1947: RAISE;

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

1940:
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: IF po_log.d_exc THEN
1944: po_log.exc(d_mod, 0, NULL);
1945: END IF;
1946:
1947: RAISE;
1948: END amount_limit;