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.26.12020000.2 2013/02/10 17:42:21 vegajula 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 247: IF po_log.d_proc THEN

243: END;
244: END IF;
245: END LOOP;
246:
247: IF po_log.d_proc THEN
248: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
249: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
250: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
251: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

245: END LOOP;
246:
247: IF po_log.d_proc THEN
248: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
249: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
250: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
251: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
252: END IF;
253: EXCEPTION

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

246:
247: IF po_log.d_proc THEN
248: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
249: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
250: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
251: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN

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

247: IF po_log.d_proc THEN
248: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
249: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
250: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
251: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN
255: IF po_log.d_exc THEN

Line 255: IF po_log.d_exc THEN

251: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN
255: IF po_log.d_exc THEN
256: po_log.exc(d_mod, 0, NULL);
257: END IF;
258:
259: RAISE;

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

252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN
255: IF po_log.d_exc THEN
256: po_log.exc(d_mod, 0, NULL);
257: END IF;
258:
259: RAISE;
260:

Line 279: IF po_log.d_proc THEN

275: IF (x_results IS NULL) THEN
276: x_results := po_validation_results_type.new_instance();
277: END IF;
278:
279: IF po_log.d_proc THEN
280: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
281: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
282: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
283: END IF;

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

276: x_results := po_validation_results_type.new_instance();
277: END IF;
278:
279: IF po_log.d_proc THEN
280: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
281: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
282: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
283: END IF;
284:

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

277: END IF;
278:
279: IF po_log.d_proc THEN
280: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
281: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
282: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
283: END IF;
284:
285: x_result_type := po_validations.c_result_type_success;

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

278:
279: IF po_log.d_proc THEN
280: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
281: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
282: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
283: END IF;
284:
285: x_result_type := po_validations.c_result_type_success;
286:

Line 313: IF po_log.d_proc THEN

309: x_result_type := po_validations.c_result_type_failure;
310: END IF;
311: END LOOP;
312:
313: IF po_log.d_proc THEN
314: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
315: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
316: END IF;
317: EXCEPTION

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

310: END IF;
311: END LOOP;
312:
313: IF po_log.d_proc THEN
314: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
315: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
316: END IF;
317: EXCEPTION
318: WHEN OTHERS THEN

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

311: END LOOP;
312:
313: IF po_log.d_proc THEN
314: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
315: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
316: END IF;
317: EXCEPTION
318: WHEN OTHERS THEN
319: IF po_log.d_exc THEN

Line 319: IF po_log.d_exc THEN

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

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

316: END IF;
317: EXCEPTION
318: WHEN OTHERS THEN
319: IF po_log.d_exc THEN
320: po_log.exc(d_mod, 0, NULL);
321: END IF;
322:
323: RAISE;
324: END type_lookup_code;

Line 341: IF po_log.d_proc THEN

337: IF x_result_set_id IS NULL THEN
338: x_result_set_id := po_validations.next_result_set_id();
339: END IF;
340:
341: IF po_log.d_proc THEN
342: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
343: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
344: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
345: END IF;

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

338: x_result_set_id := po_validations.next_result_set_id();
339: END IF;
340:
341: IF po_log.d_proc THEN
342: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
343: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
344: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
345: END IF;
346:

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

339: END IF;
340:
341: IF po_log.d_proc THEN
342: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
343: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
344: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
345: END IF;
346:
347: x_result_type := po_validations.c_result_type_success;

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

340:
341: IF po_log.d_proc THEN
342: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
343: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
344: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
345: END IF;
346:
347: x_result_type := po_validations.c_result_type_success;
348: -- Bulk validate currency_code not null and against FND_CURRENCIES

Line 390: IF po_log.d_proc THEN

386: IF (SQL%ROWCOUNT > 0) THEN
387: x_result_type := po_validations.c_result_type_failure;
388: END IF;
389:
390: IF po_log.d_proc THEN
391: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
392: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
393: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
394: END IF;

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

388: END IF;
389:
390: IF po_log.d_proc THEN
391: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
392: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
393: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
394: END IF;
395: EXCEPTION
396: WHEN OTHERS THEN

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

389:
390: IF po_log.d_proc THEN
391: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
392: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
393: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
394: END IF;
395: EXCEPTION
396: WHEN OTHERS THEN
397: IF po_log.d_exc THEN

Line 397: IF po_log.d_exc THEN

393: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
394: END IF;
395: EXCEPTION
396: WHEN OTHERS THEN
397: IF po_log.d_exc THEN
398: po_log.exc(d_mod, 0, NULL);
399: END IF;
400:
401: RAISE;

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

394: END IF;
395: EXCEPTION
396: WHEN OTHERS THEN
397: IF po_log.d_exc THEN
398: po_log.exc(d_mod, 0, NULL);
399: END IF;
400:
401: RAISE;
402: END currency_code;

Line 433: IF po_log.d_proc THEN

429: IF (x_results IS NULL) THEN
430: x_results := po_validation_results_type.new_instance();
431: END IF;
432:
433: IF po_log.d_proc THEN
434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
435: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
436: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
437: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);

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

430: x_results := po_validation_results_type.new_instance();
431: END IF;
432:
433: IF po_log.d_proc THEN
434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
435: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
436: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
437: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
438: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);

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

431: END IF;
432:
433: IF po_log.d_proc THEN
434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
435: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
436: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
437: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
438: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
439: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);

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

432:
433: IF po_log.d_proc THEN
434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
435: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
436: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
437: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
438: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
439: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
440: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);

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

433: IF po_log.d_proc THEN
434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
435: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
436: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
437: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
438: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
439: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
440: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
441: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

434: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
435: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
436: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
437: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
438: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
439: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
440: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
441: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
442: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

435: po_log.proc_begin(d_mod, 'p_currency_code_tbl', p_currency_code_tbl);
436: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
437: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
438: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
439: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
440: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
441: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
442: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
443: END IF;

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

436: po_log.proc_begin(d_mod, 'p_rate_tbl', p_rate_tbl);
437: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
438: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
439: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
440: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
441: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
442: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
443: END IF;
444:

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

437: po_log.proc_begin(d_mod, 'p_rate_type_tbl', p_rate_type_tbl);
438: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
439: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
440: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
441: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
442: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
443: END IF;
444:
445: x_result_type := po_validations.c_result_type_success;

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

438: po_log.proc_begin(d_mod, 'p_rate_date_tbl', p_rate_date_tbl);
439: po_log.proc_begin(d_mod, 'p_func_currency_code', p_func_currency_code);
440: po_log.proc_begin(d_mod, 'p_set_of_books_id', p_set_of_books_id);
441: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
442: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
443: END IF;
444:
445: x_result_type := po_validations.c_result_type_success;
446:

Line 605: IF po_log.d_proc THEN

601: IF (SQL%ROWCOUNT > 0) THEN
602: x_result_type := po_validations.c_result_type_failure;
603: END IF;
604:
605: IF po_log.d_proc THEN
606: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
607: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
608: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
609: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

603: END IF;
604:
605: IF po_log.d_proc THEN
606: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
607: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
608: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
609: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
610: END IF;
611: EXCEPTION

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

604:
605: IF po_log.d_proc THEN
606: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
607: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
608: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
609: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
610: END IF;
611: EXCEPTION
612: WHEN OTHERS THEN

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

605: IF po_log.d_proc THEN
606: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
607: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
608: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
609: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
610: END IF;
611: EXCEPTION
612: WHEN OTHERS THEN
613: IF po_log.d_exc THEN

Line 613: IF po_log.d_exc THEN

609: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
610: END IF;
611: EXCEPTION
612: WHEN OTHERS THEN
613: IF po_log.d_exc THEN
614: po_log.exc(d_mod, 0, NULL);
615: END IF;
616:
617: RAISE;

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

610: END IF;
611: EXCEPTION
612: WHEN OTHERS THEN
613: IF po_log.d_exc THEN
614: po_log.exc(d_mod, 0, NULL);
615: END IF;
616:
617: RAISE;
618: END rate_info;

Line 635: IF po_log.d_proc THEN

631: IF x_result_set_id IS NULL THEN
632: x_result_set_id := po_validations.next_result_set_id();
633: END IF;
634:
635: IF po_log.d_proc THEN
636: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
637: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
638: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
639: END IF;

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

632: x_result_set_id := po_validations.next_result_set_id();
633: END IF;
634:
635: IF po_log.d_proc THEN
636: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
637: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
638: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
639: END IF;
640:

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

633: END IF;
634:
635: IF po_log.d_proc THEN
636: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
637: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
638: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
639: END IF;
640:
641: x_result_type := po_validations.c_result_type_success;

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

634:
635: IF po_log.d_proc THEN
636: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
637: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
638: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
639: END IF;
640:
641: x_result_type := po_validations.c_result_type_success;
642: -- validate agent_id against PO_AGENTS

Line 683: IF po_log.d_proc THEN

679: IF (SQL%ROWCOUNT > 0) THEN
680: x_result_type := po_validations.c_result_type_failure;
681: END IF;
682:
683: IF po_log.d_proc THEN
684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
685: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
687: END IF;

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

681: END IF;
682:
683: IF po_log.d_proc THEN
684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
685: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
687: END IF;
688: EXCEPTION
689: WHEN OTHERS THEN

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

682:
683: IF po_log.d_proc THEN
684: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
685: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
687: END IF;
688: EXCEPTION
689: WHEN OTHERS THEN
690: IF po_log.d_exc THEN

Line 690: IF po_log.d_exc THEN

686: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
687: END IF;
688: EXCEPTION
689: WHEN OTHERS THEN
690: IF po_log.d_exc THEN
691: po_log.exc(d_mod, 0, NULL);
692: END IF;
693:
694: RAISE;

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

687: END IF;
688: EXCEPTION
689: WHEN OTHERS THEN
690: IF po_log.d_exc THEN
691: po_log.exc(d_mod, 0, NULL);
692: END IF;
693:
694: RAISE;
695: END agent_id;

Line 739: IF po_log.d_proc THEN

735: IF (x_results IS NULL) THEN
736: x_results := po_validation_results_type.new_instance();
737: END IF;
738:
739: IF po_log.d_proc THEN
740: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
741: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
742: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
743: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);

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

736: x_results := po_validation_results_type.new_instance();
737: END IF;
738:
739: IF po_log.d_proc THEN
740: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
741: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
742: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
743: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
744: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl); -- 8913559 bug

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

737: END IF;
738:
739: IF po_log.d_proc THEN
740: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
741: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
742: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
743: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
744: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl); -- 8913559 bug
745: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);

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

738:
739: IF po_log.d_proc THEN
740: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
741: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
742: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
743: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
744: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl); -- 8913559 bug
745: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
746: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

739: IF po_log.d_proc THEN
740: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
741: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
742: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
743: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
744: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl); -- 8913559 bug
745: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
746: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
747: END IF;

Line 744: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl); -- 8913559 bug

740: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
741: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
742: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
743: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
744: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl); -- 8913559 bug
745: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
746: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
747: END IF;
748:

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

741: po_log.proc_begin(d_mod, 'p_vendor_id_tbl', p_vendor_id_tbl);
742: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
743: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
744: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl); -- 8913559 bug
745: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
746: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
747: END IF;
748:
749: x_result_type := po_validations.c_result_type_success;

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

742: po_log.proc_begin(d_mod, 'p_vendor_site_id_tbl', p_vendor_site_id_tbl);
743: po_log.proc_begin(d_mod, 'p_vendor_contact_id_tbl', p_vendor_contact_id_tbl);
744: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl); -- 8913559 bug
745: po_log.proc_begin(d_mod, 'p_federal_instance', p_federal_instance);
746: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
747: END IF;
748:
749: x_result_type := po_validations.c_result_type_success;
750: FORALL i IN 1 .. p_id_tbl.COUNT

Line 898: IF po_log.d_proc THEN

894: END;
895: END LOOP;
896: END IF;
897:
898: IF po_log.d_proc THEN
899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
902: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

896: END IF;
897:
898: IF po_log.d_proc THEN
899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
902: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
903: END IF;
904: EXCEPTION

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

897:
898: IF po_log.d_proc THEN
899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
902: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
903: END IF;
904: EXCEPTION
905: WHEN OTHERS THEN

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

898: IF po_log.d_proc THEN
899: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
900: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
901: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
902: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
903: END IF;
904: EXCEPTION
905: WHEN OTHERS THEN
906: IF po_log.d_exc THEN

Line 906: IF po_log.d_exc THEN

902: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
903: END IF;
904: EXCEPTION
905: WHEN OTHERS THEN
906: IF po_log.d_exc THEN
907: po_log.exc(d_mod, 0, NULL);
908: END IF;
909:
910: RAISE;

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

903: END IF;
904: EXCEPTION
905: WHEN OTHERS THEN
906: IF po_log.d_exc THEN
907: po_log.exc(d_mod, 0, NULL);
908: END IF;
909:
910: RAISE;
911: END vendor_info;

Line 930: IF po_log.d_proc THEN

926: IF x_result_set_id IS NULL THEN
927: x_result_set_id := po_validations.next_result_set_id();
928: END IF;
929:
930: IF po_log.d_proc THEN
931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
932: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
933: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
934: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

927: x_result_set_id := po_validations.next_result_set_id();
928: END IF;
929:
930: IF po_log.d_proc THEN
931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
932: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
933: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
934: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
935: END IF;

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

928: END IF;
929:
930: IF po_log.d_proc THEN
931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
932: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
933: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
934: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
935: END IF;
936:

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

929:
930: IF po_log.d_proc THEN
931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
932: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
933: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
934: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
935: END IF;
936:
937: x_result_type := po_validations.c_result_type_success;

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

930: IF po_log.d_proc THEN
931: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
932: po_log.proc_begin(d_mod, 'p_ship_to_location_id_tbl', p_ship_to_location_id_tbl);
933: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
934: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
935: END IF;
936:
937: x_result_type := po_validations.c_result_type_success;
938: -- validate ship_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS

Line 982: IF po_log.d_proc THEN

978: IF (SQL%ROWCOUNT > 0) THEN
979: x_result_type := po_validations.c_result_type_failure;
980: END IF;
981:
982: IF po_log.d_proc THEN
983: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
984: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
985: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
986: END IF;

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

980: END IF;
981:
982: IF po_log.d_proc THEN
983: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
984: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
985: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
986: END IF;
987: EXCEPTION
988: WHEN OTHERS THEN

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

981:
982: IF po_log.d_proc THEN
983: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
984: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
985: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
986: END IF;
987: EXCEPTION
988: WHEN OTHERS THEN
989: IF po_log.d_exc THEN

Line 989: IF po_log.d_exc THEN

985: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
986: END IF;
987: EXCEPTION
988: WHEN OTHERS THEN
989: IF po_log.d_exc THEN
990: po_log.exc(d_mod, 0, NULL);
991: END IF;
992:
993: RAISE;

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

986: END IF;
987: EXCEPTION
988: WHEN OTHERS THEN
989: IF po_log.d_exc THEN
990: po_log.exc(d_mod, 0, NULL);
991: END IF;
992:
993: RAISE;
994: END ship_to_location_id;

Line 1013: IF po_log.d_proc THEN

1009: IF x_result_set_id IS NULL THEN
1010: x_result_set_id := po_validations.next_result_set_id();
1011: END IF;
1012:
1013: IF po_log.d_proc THEN
1014: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1015: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1016: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1017: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

1010: x_result_set_id := po_validations.next_result_set_id();
1011: END IF;
1012:
1013: IF po_log.d_proc THEN
1014: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1015: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1016: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1017: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1018: END IF;

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

1011: END IF;
1012:
1013: IF po_log.d_proc THEN
1014: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1015: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1016: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1017: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1018: END IF;
1019:

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

1012:
1013: IF po_log.d_proc THEN
1014: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1015: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1016: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1017: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1018: END IF;
1019:
1020: x_result_type := po_validations.c_result_type_success;

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

1013: IF po_log.d_proc THEN
1014: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1015: po_log.proc_begin(d_mod, 'p_bill_to_location_id_tbl', p_bill_to_location_id_tbl);
1016: po_log.proc_begin(d_mod, 'p_type_lookup_code_tbl', p_type_lookup_code_tbl);
1017: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1018: END IF;
1019:
1020: x_result_type := po_validations.c_result_type_success;
1021: -- validate bill_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS

Line 1065: IF po_log.d_proc THEN

1061: IF (SQL%ROWCOUNT > 0) THEN
1062: x_result_type := po_validations.c_result_type_failure;
1063: END IF;
1064:
1065: IF po_log.d_proc THEN
1066: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1067: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1068: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1069: END IF;

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

1063: END IF;
1064:
1065: IF po_log.d_proc THEN
1066: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1067: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1068: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1069: END IF;
1070: EXCEPTION
1071: WHEN OTHERS THEN

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

1064:
1065: IF po_log.d_proc THEN
1066: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1067: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1068: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1069: END IF;
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: IF po_log.d_exc THEN

Line 1072: IF po_log.d_exc THEN

1068: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1069: END IF;
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: IF po_log.d_exc THEN
1073: po_log.exc(d_mod, 0, NULL);
1074: END IF;
1075:
1076: RAISE;

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

1069: END IF;
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: IF po_log.d_exc THEN
1073: po_log.exc(d_mod, 0, NULL);
1074: END IF;
1075:
1076: RAISE;
1077: END bill_to_location_id;

Line 1095: IF po_log.d_proc THEN

1091: IF x_result_set_id IS NULL THEN
1092: x_result_set_id := po_validations.next_result_set_id();
1093: END IF;
1094:
1095: IF po_log.d_proc THEN
1096: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1097: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1098: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1099: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

1092: x_result_set_id := po_validations.next_result_set_id();
1093: END IF;
1094:
1095: IF po_log.d_proc THEN
1096: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1097: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1098: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1099: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1100: END IF;

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

1093: END IF;
1094:
1095: IF po_log.d_proc THEN
1096: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1097: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1098: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1099: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1100: END IF;
1101:

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

1094:
1095: IF po_log.d_proc THEN
1096: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1097: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1098: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1099: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1100: END IF;
1101:
1102: x_result_type := po_validations.c_result_type_success;

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

1095: IF po_log.d_proc THEN
1096: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1097: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
1098: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1099: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1100: END IF;
1101:
1102: x_result_type := po_validations.c_result_type_success;
1103: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1138: IF po_log.d_proc THEN

1134: IF (SQL%ROWCOUNT > 0) THEN
1135: x_result_type := po_validations.c_result_type_failure;
1136: END IF;
1137:
1138: IF po_log.d_proc THEN
1139: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1140: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1141: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1142: END IF;

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

1136: END IF;
1137:
1138: IF po_log.d_proc THEN
1139: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1140: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1141: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1142: END IF;
1143: EXCEPTION
1144: WHEN OTHERS THEN

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

1137:
1138: IF po_log.d_proc THEN
1139: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1140: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1141: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1142: END IF;
1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: IF po_log.d_exc THEN

Line 1145: IF po_log.d_exc THEN

1141: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1142: END IF;
1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: IF po_log.d_exc THEN
1146: po_log.exc(d_mod, 0, NULL);
1147: END IF;
1148:
1149: RAISE;

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

1142: END IF;
1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: IF po_log.d_exc THEN
1146: po_log.exc(d_mod, 0, NULL);
1147: END IF;
1148:
1149: RAISE;
1150: END ship_via_lookup_code;

Line 1167: IF po_log.d_proc THEN

1163: IF (x_result_set_id IS NULL) THEN
1164: x_result_set_id := po_validations.next_result_set_id();
1165: END IF;
1166:
1167: IF po_log.d_proc THEN
1168: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1169: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1170: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1171: END IF;

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

1164: x_result_set_id := po_validations.next_result_set_id();
1165: END IF;
1166:
1167: IF po_log.d_proc THEN
1168: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1169: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1170: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1171: END IF;
1172:

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

1165: END IF;
1166:
1167: IF po_log.d_proc THEN
1168: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1169: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1170: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1171: END IF;
1172:
1173: x_result_type := po_validations.c_result_type_success;

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

1166:
1167: IF po_log.d_proc THEN
1168: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1169: po_log.proc_begin(d_mod, 'p_fob_lookup_code_tbl', p_fob_lookup_code_tbl);
1170: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1171: END IF;
1172:
1173: x_result_type := po_validations.c_result_type_success;
1174: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1209: IF po_log.d_proc THEN

1205: IF (SQL%ROWCOUNT > 0) THEN
1206: x_result_type := po_validations.c_result_type_failure;
1207: END IF;
1208:
1209: IF po_log.d_proc THEN
1210: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1211: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1212: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1213: END IF;

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

1207: END IF;
1208:
1209: IF po_log.d_proc THEN
1210: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1211: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1212: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1213: END IF;
1214: EXCEPTION
1215: WHEN OTHERS THEN

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

1208:
1209: IF po_log.d_proc THEN
1210: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1211: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1212: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1213: END IF;
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: IF po_log.d_exc THEN

Line 1216: IF po_log.d_exc THEN

1212: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1213: END IF;
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: IF po_log.d_exc THEN
1217: po_log.exc(d_mod, 0, NULL);
1218: END IF;
1219:
1220: RAISE;

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

1213: END IF;
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: IF po_log.d_exc THEN
1217: po_log.exc(d_mod, 0, NULL);
1218: END IF;
1219:
1220: RAISE;
1221: END fob_lookup_code;

Line 1238: IF po_log.d_proc THEN

1234: IF (x_result_set_id IS NULL) THEN
1235: x_result_set_id := po_validations.next_result_set_id();
1236: END IF;
1237:
1238: IF po_log.d_proc THEN
1239: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1240: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1241: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1242: END IF;

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

1235: x_result_set_id := po_validations.next_result_set_id();
1236: END IF;
1237:
1238: IF po_log.d_proc THEN
1239: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1240: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1241: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1242: END IF;
1243:

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

1236: END IF;
1237:
1238: IF po_log.d_proc THEN
1239: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1240: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1241: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1242: END IF;
1243:
1244: x_result_type := po_validations.c_result_type_success;

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

1237:
1238: IF po_log.d_proc THEN
1239: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1240: po_log.proc_begin(d_mod, 'p_freight_terms_lookup_tbl', p_freight_terms_lookup_tbl);
1241: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1242: END IF;
1243:
1244: x_result_type := po_validations.c_result_type_success;
1245: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1280: IF po_log.d_proc THEN

1276: IF (SQL%ROWCOUNT > 0) THEN
1277: x_result_type := po_validations.c_result_type_failure;
1278: END IF;
1279:
1280: IF po_log.d_proc THEN
1281: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1282: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1283: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1284: END IF;

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

1278: END IF;
1279:
1280: IF po_log.d_proc THEN
1281: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1282: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1283: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1284: END IF;
1285: EXCEPTION
1286: WHEN OTHERS THEN

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

1279:
1280: IF po_log.d_proc THEN
1281: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1282: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1283: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1284: END IF;
1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: IF po_log.d_exc THEN

Line 1287: IF po_log.d_exc THEN

1283: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1284: END IF;
1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: IF po_log.d_exc THEN
1288: po_log.exc(d_mod, 0, NULL);
1289: END IF;
1290:
1291: RAISE;

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

1284: END IF;
1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: IF po_log.d_exc THEN
1288: po_log.exc(d_mod, 0, NULL);
1289: END IF;
1290:
1291: RAISE;
1292: END freight_terms_lookup_code;

Line 1309: IF po_log.d_proc THEN

1305: IF (x_result_set_id IS NULL) THEN
1306: x_result_set_id := po_validations.next_result_set_id();
1307: END IF;
1308:
1309: IF po_log.d_proc THEN
1310: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1311: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1312: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1313: END IF;

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

1306: x_result_set_id := po_validations.next_result_set_id();
1307: END IF;
1308:
1309: IF po_log.d_proc THEN
1310: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1311: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1312: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1313: END IF;
1314:

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

1307: END IF;
1308:
1309: IF po_log.d_proc THEN
1310: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1311: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1312: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1313: END IF;
1314:
1315: x_result_type := po_validations.c_result_type_success;

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

1308:
1309: IF po_log.d_proc THEN
1310: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1311: po_log.proc_begin(d_mod, 'p_shipping_control_tbl', p_shipping_control_tbl);
1312: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1313: END IF;
1314:
1315: x_result_type := po_validations.c_result_type_success;
1316: FORALL i IN 1 .. p_id_tbl.COUNT

Line 1351: IF po_log.d_proc THEN

1347: IF (SQL%ROWCOUNT > 0) THEN
1348: x_result_type := po_validations.c_result_type_failure;
1349: END IF;
1350:
1351: IF po_log.d_proc THEN
1352: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1353: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1354: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1355: END IF;

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

1349: END IF;
1350:
1351: IF po_log.d_proc THEN
1352: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1353: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1354: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1355: END IF;
1356: EXCEPTION
1357: WHEN OTHERS THEN

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

1350:
1351: IF po_log.d_proc THEN
1352: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1353: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1354: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1355: END IF;
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: IF po_log.d_exc THEN

Line 1358: IF po_log.d_exc THEN

1354: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1355: END IF;
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: IF po_log.d_exc THEN
1359: po_log.exc(d_mod, 0, NULL);
1360: END IF;
1361:
1362: RAISE;

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

1355: END IF;
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: IF po_log.d_exc THEN
1359: po_log.exc(d_mod, 0, NULL);
1360: END IF;
1361:
1362: RAISE;
1363: END shipping_control;

Line 1382: IF po_log.d_proc THEN

1378: IF (x_results IS NULL) THEN
1379: x_results := po_validation_results_type.new_instance();
1380: END IF;
1381:
1382: IF po_log.d_proc THEN
1383: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1384: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1385: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1379: x_results := po_validation_results_type.new_instance();
1380: END IF;
1381:
1382: IF po_log.d_proc THEN
1383: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1384: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1385: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1387: END IF;

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

1380: END IF;
1381:
1382: IF po_log.d_proc THEN
1383: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1384: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1385: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1387: END IF;
1388:

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

1381:
1382: IF po_log.d_proc THEN
1383: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1384: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1385: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1387: END IF;
1388:
1389: x_result_type := po_validations.c_result_type_success;

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

1382: IF po_log.d_proc THEN
1383: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1384: po_log.proc_begin(d_mod, 'p_acceptance_due_date_tbl', p_acceptance_due_date_tbl);
1385: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1386: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1387: END IF;
1388:
1389: x_result_type := po_validations.c_result_type_success;
1390:

Line 1408: IF po_log.d_proc THEN

1404: x_result_type := po_validations.c_result_type_failure;
1405: END IF;
1406: END LOOP;*/
1407:
1408: IF po_log.d_proc THEN
1409: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1410: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1411: END IF;
1412: EXCEPTION

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

1405: END IF;
1406: END LOOP;*/
1407:
1408: IF po_log.d_proc THEN
1409: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1410: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1411: END IF;
1412: EXCEPTION
1413: WHEN OTHERS THEN

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

1406: END LOOP;*/
1407:
1408: IF po_log.d_proc THEN
1409: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1410: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1411: END IF;
1412: EXCEPTION
1413: WHEN OTHERS THEN
1414: IF po_log.d_exc THEN

Line 1414: IF po_log.d_exc THEN

1410: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1411: END IF;
1412: EXCEPTION
1413: WHEN OTHERS THEN
1414: IF po_log.d_exc THEN
1415: po_log.exc(d_mod, 0, NULL);
1416: END IF;
1417:
1418: RAISE;

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

1411: END IF;
1412: EXCEPTION
1413: WHEN OTHERS THEN
1414: IF po_log.d_exc THEN
1415: po_log.exc(d_mod, 0, NULL);
1416: END IF;
1417:
1418: RAISE;
1419: END acceptance_due_date;

Line 1436: IF po_log.d_proc THEN

1432: IF (x_results IS NULL) THEN
1433: x_results := po_validation_results_type.new_instance();
1434: END IF;
1435:
1436: IF po_log.d_proc THEN
1437: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1438: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1439: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1440: END IF;

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

1433: x_results := po_validation_results_type.new_instance();
1434: END IF;
1435:
1436: IF po_log.d_proc THEN
1437: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1438: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1439: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1440: END IF;
1441:

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

1434: END IF;
1435:
1436: IF po_log.d_proc THEN
1437: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1438: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1439: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1440: END IF;
1441:
1442: x_result_type := po_validations.c_result_type_success;

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

1435:
1436: IF po_log.d_proc THEN
1437: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1438: po_log.proc_begin(d_mod, 'p_cancel_flag_tbl', p_cancel_flag_tbl);
1439: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1440: END IF;
1441:
1442: x_result_type := po_validations.c_result_type_success;
1443:

Line 1461: IF po_log.d_proc THEN

1457: x_result_type := po_validations.c_result_type_failure;
1458: END IF;
1459: END LOOP;
1460:
1461: IF po_log.d_proc THEN
1462: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1463: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1464: END IF;
1465: EXCEPTION

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

1458: END IF;
1459: END LOOP;
1460:
1461: IF po_log.d_proc THEN
1462: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1463: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1464: END IF;
1465: EXCEPTION
1466: WHEN OTHERS THEN

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

1459: END LOOP;
1460:
1461: IF po_log.d_proc THEN
1462: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1463: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1464: END IF;
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: IF po_log.d_exc THEN

Line 1467: IF po_log.d_exc THEN

1463: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1464: END IF;
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: IF po_log.d_exc THEN
1468: po_log.exc(d_mod, 0, NULL);
1469: END IF;
1470:
1471: RAISE;

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

1464: END IF;
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: IF po_log.d_exc THEN
1468: po_log.exc(d_mod, 0, NULL);
1469: END IF;
1470:
1471: RAISE;
1472: END cancel_flag;

Line 1490: IF po_log.d_proc THEN

1486: IF (x_results IS NULL) THEN
1487: x_results := po_validation_results_type.new_instance();
1488: END IF;
1489:
1490: IF po_log.d_proc THEN
1491: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1492: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1493: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1494: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1487: x_results := po_validation_results_type.new_instance();
1488: END IF;
1489:
1490: IF po_log.d_proc THEN
1491: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1492: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1493: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1494: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1495: END IF;

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

1488: END IF;
1489:
1490: IF po_log.d_proc THEN
1491: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1492: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1493: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1494: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1495: END IF;
1496:

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

1489:
1490: IF po_log.d_proc THEN
1491: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1492: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1493: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1494: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1495: END IF;
1496:
1497: x_result_type := po_validations.c_result_type_success;

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

1490: IF po_log.d_proc THEN
1491: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1492: po_log.proc_begin(d_mod, 'p_closed_code_tbl', p_closed_code_tbl);
1493: po_log.proc_begin(d_mod, 'p_acceptance_reqd_flag_tbl', p_acceptance_reqd_flag_tbl);
1494: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1495: END IF;
1496:
1497: x_result_type := po_validations.c_result_type_success;
1498:

Line 1516: IF po_log.d_proc THEN

1512: x_result_type := po_validations.c_result_type_failure;
1513: END IF;
1514: END LOOP;
1515:
1516: IF po_log.d_proc THEN
1517: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1518: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1519: END IF;
1520: EXCEPTION

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

1513: END IF;
1514: END LOOP;
1515:
1516: IF po_log.d_proc THEN
1517: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1518: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1519: END IF;
1520: EXCEPTION
1521: WHEN OTHERS THEN

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

1514: END LOOP;
1515:
1516: IF po_log.d_proc THEN
1517: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1518: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1519: END IF;
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: IF po_log.d_exc THEN

Line 1522: IF po_log.d_exc THEN

1518: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1519: END IF;
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: IF po_log.d_exc THEN
1523: po_log.exc(d_mod, 0, NULL);
1524: END IF;
1525:
1526: RAISE;

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

1519: END IF;
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: IF po_log.d_exc THEN
1523: po_log.exc(d_mod, 0, NULL);
1524: END IF;
1525:
1526: RAISE;
1527: END closed_code;

Line 1545: IF po_log.d_proc THEN

1541: IF (x_results IS NULL) THEN
1542: x_results := po_validation_results_type.new_instance();
1543: END IF;
1544:
1545: IF po_log.d_proc THEN
1546: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1547: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1548: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1549: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1542: x_results := po_validation_results_type.new_instance();
1543: END IF;
1544:
1545: IF po_log.d_proc THEN
1546: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1547: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1548: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1549: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1550: END IF;

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

1543: END IF;
1544:
1545: IF po_log.d_proc THEN
1546: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1547: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1548: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1549: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1550: END IF;
1551:

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

1544:
1545: IF po_log.d_proc THEN
1546: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1547: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1548: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1549: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1550: END IF;
1551:
1552: x_result_type := po_validations.c_result_type_success;

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

1545: IF po_log.d_proc THEN
1546: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1547: po_log.proc_begin(d_mod, 'p_print_count_tbl', p_print_count_tbl);
1548: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1549: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1550: END IF;
1551:
1552: x_result_type := po_validations.c_result_type_success;
1553:

Line 1570: IF po_log.d_proc THEN

1566: x_result_type := po_validations.c_result_type_failure;
1567: END IF;
1568: END LOOP;
1569:
1570: IF po_log.d_proc THEN
1571: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1572: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1573: END IF;
1574: EXCEPTION

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

1567: END IF;
1568: END LOOP;
1569:
1570: IF po_log.d_proc THEN
1571: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1572: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1573: END IF;
1574: EXCEPTION
1575: WHEN OTHERS THEN

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

1568: END LOOP;
1569:
1570: IF po_log.d_proc THEN
1571: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1572: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1573: END IF;
1574: EXCEPTION
1575: WHEN OTHERS THEN
1576: IF po_log.d_exc THEN

Line 1576: IF po_log.d_exc THEN

1572: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1573: END IF;
1574: EXCEPTION
1575: WHEN OTHERS THEN
1576: IF po_log.d_exc THEN
1577: po_log.exc(d_mod, 0, NULL);
1578: END IF;
1579:
1580: RAISE;

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

1573: END IF;
1574: EXCEPTION
1575: WHEN OTHERS THEN
1576: IF po_log.d_exc THEN
1577: po_log.exc(d_mod, 0, NULL);
1578: END IF;
1579:
1580: RAISE;
1581: END print_count;

Line 1599: IF po_log.d_proc THEN

1595: IF (x_results IS NULL) THEN
1596: x_results := po_validation_results_type.new_instance();
1597: END IF;
1598:
1599: IF po_log.d_proc THEN
1600: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1601: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1602: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1603: END IF;

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

1596: x_results := po_validation_results_type.new_instance();
1597: END IF;
1598:
1599: IF po_log.d_proc THEN
1600: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1601: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1602: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1603: END IF;
1604:

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

1597: END IF;
1598:
1599: IF po_log.d_proc THEN
1600: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1601: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1602: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1603: END IF;
1604:
1605: x_result_type := po_validations.c_result_type_success;

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

1598:
1599: IF po_log.d_proc THEN
1600: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1601: po_log.proc_begin(d_mod, 'p_approval_status_tbl', p_approval_status_tbl);
1602: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1603: END IF;
1604:
1605: x_result_type := po_validations.c_result_type_success;
1606:

Line 1619: IF po_log.d_proc THEN

1615: x_result_type := po_validations.c_result_type_failure;
1616: END IF;
1617: END LOOP;
1618:
1619: IF po_log.d_proc THEN
1620: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1621: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1622: END IF;
1623: EXCEPTION

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

1616: END IF;
1617: END LOOP;
1618:
1619: IF po_log.d_proc THEN
1620: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1621: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1622: END IF;
1623: EXCEPTION
1624: WHEN OTHERS THEN

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

1617: END LOOP;
1618:
1619: IF po_log.d_proc THEN
1620: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1621: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1622: END IF;
1623: EXCEPTION
1624: WHEN OTHERS THEN
1625: IF po_log.d_exc THEN

Line 1625: IF po_log.d_exc THEN

1621: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1622: END IF;
1623: EXCEPTION
1624: WHEN OTHERS THEN
1625: IF po_log.d_exc THEN
1626: po_log.exc(d_mod, 0, NULL);
1627: END IF;
1628:
1629: RAISE;

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

1622: END IF;
1623: EXCEPTION
1624: WHEN OTHERS THEN
1625: IF po_log.d_exc THEN
1626: po_log.exc(d_mod, 0, NULL);
1627: END IF;
1628:
1629: RAISE;
1630: END approval_status;

Line 1647: IF po_log.d_proc THEN

1643: IF (x_results IS NULL) THEN
1644: x_results := po_validation_results_type.new_instance();
1645: END IF;
1646:
1647: IF po_log.d_proc THEN
1648: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1649: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1651: END IF;

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

1644: x_results := po_validation_results_type.new_instance();
1645: END IF;
1646:
1647: IF po_log.d_proc THEN
1648: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1649: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1651: END IF;
1652:

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

1645: END IF;
1646:
1647: IF po_log.d_proc THEN
1648: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1649: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1651: END IF;
1652:
1653: x_result_type := po_validations.c_result_type_success;

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

1646:
1647: IF po_log.d_proc THEN
1648: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1649: po_log.proc_begin(d_mod, 'p_amount_to_encumber_tbl', p_amount_to_encumber_tbl);
1650: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1651: END IF;
1652:
1653: x_result_type := po_validations.c_result_type_success;
1654:

Line 1671: IF po_log.d_proc THEN

1667: x_result_type := po_validations.c_result_type_failure;
1668: END IF;
1669: END LOOP;
1670:
1671: IF po_log.d_proc THEN
1672: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1673: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1674: END IF;
1675: EXCEPTION

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

1668: END IF;
1669: END LOOP;
1670:
1671: IF po_log.d_proc THEN
1672: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1673: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS THEN

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

1669: END LOOP;
1670:
1671: IF po_log.d_proc THEN
1672: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1673: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF po_log.d_exc THEN

Line 1677: IF po_log.d_exc THEN

1673: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF po_log.d_exc THEN
1678: po_log.exc(d_mod, 0, NULL);
1679: END IF;
1680:
1681: RAISE;

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

1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF po_log.d_exc THEN
1678: po_log.exc(d_mod, 0, NULL);
1679: END IF;
1680:
1681: RAISE;
1682: END amount_to_encumber;

Line 1699: IF po_log.d_proc THEN

1695: IF x_result_set_id IS NULL THEN
1696: x_result_set_id := po_validations.next_result_set_id();
1697: END IF;
1698:
1699: IF po_log.d_proc THEN
1700: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1701: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1702: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1703: END IF;

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

1696: x_result_set_id := po_validations.next_result_set_id();
1697: END IF;
1698:
1699: IF po_log.d_proc THEN
1700: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1701: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1702: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1703: END IF;
1704:

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

1697: END IF;
1698:
1699: IF po_log.d_proc THEN
1700: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1701: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1702: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1703: END IF;
1704:
1705: x_result_type := po_validations.c_result_type_success;

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

1698:
1699: IF po_log.d_proc THEN
1700: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1701: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1702: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1703: END IF;
1704:
1705: x_result_type := po_validations.c_result_type_success;
1706:

Line 1775: IF po_log.d_proc THEN

1771: IF (SQL%ROWCOUNT > 0) THEN
1772: x_result_type := po_validations.c_result_type_failure;
1773: END IF; */
1774:
1775: IF po_log.d_proc THEN
1776: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1777: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1778: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1779: END IF;

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

1773: END IF; */
1774:
1775: IF po_log.d_proc THEN
1776: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1777: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1778: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1779: END IF;
1780:
1781: EXCEPTION

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

1774:
1775: IF po_log.d_proc THEN
1776: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1777: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1778: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1779: END IF;
1780:
1781: EXCEPTION
1782: WHEN OTHERS THEN

Line 1783: IF po_log.d_exc THEN

1779: END IF;
1780:
1781: EXCEPTION
1782: WHEN OTHERS THEN
1783: IF po_log.d_exc THEN
1784: po_log.exc(d_mod, 0, NULL);
1785: END IF;
1786:
1787: RAISE;

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

1780:
1781: EXCEPTION
1782: WHEN OTHERS THEN
1783: IF po_log.d_exc THEN
1784: po_log.exc(d_mod, 0, NULL);
1785: END IF;
1786:
1787: RAISE;
1788:

Line 1854: IF po_log.d_proc THEN

1850:
1851: END LOOP;
1852:
1853:
1854: IF po_log.d_proc THEN
1855: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1856: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1857: END IF;
1858:

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

1851: END LOOP;
1852:
1853:
1854: IF po_log.d_proc THEN
1855: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1856: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1857: END IF;
1858:
1859: EXCEPTION

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

1852:
1853:
1854: IF po_log.d_proc THEN
1855: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1856: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1857: END IF;
1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN

Line 1861: IF po_log.d_exc THEN

1857: END IF;
1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: IF po_log.d_exc THEN
1862: po_log.exc(d_mod, 0, NULL);
1863: END IF;
1864:
1865: RAISE;

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

1858:
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: IF po_log.d_exc THEN
1862: po_log.exc(d_mod, 0, NULL);
1863: END IF;
1864:
1865: RAISE;
1866: END acceptance_required_flag;

Line 1948: IF po_log.d_proc THEN

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

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

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

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

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

Line 1955: IF po_log.d_exc THEN

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

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

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