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

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

1: PACKAGE BODY po_val_distributions2 AS
2: -- $Header: PO_VAL_DISTRIBUTIONS2.plb 120.14.12010000.2 2008/12/18 13:27:38 ggandhi ship $
3: c_entity_type_distribution CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_DISTRIBUTION;
4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_DISTRIBUTIONS2');
6:
7: -- The module base for the subprogram.
8: d_amount_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_ORDERED');
9: d_quantity_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_ORDERED');

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

4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_DISTRIBUTIONS2');
6:
7: -- The module base for the subprogram.
8: d_amount_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_ORDERED');
9: d_quantity_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_ORDERED');
10: d_destination_org_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_ORG_ID');
11: d_deliver_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_LOCATION_ID');
12: d_deliver_to_person_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_PERSON_ID');

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

5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_DISTRIBUTIONS2');
6:
7: -- The module base for the subprogram.
8: d_amount_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_ORDERED');
9: d_quantity_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_ORDERED');
10: d_destination_org_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_ORG_ID');
11: d_deliver_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_LOCATION_ID');
12: d_deliver_to_person_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_PERSON_ID');
13: d_destination_type_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_TYPE_CODE');

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

6:
7: -- The module base for the subprogram.
8: d_amount_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_ORDERED');
9: d_quantity_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_ORDERED');
10: d_destination_org_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_ORG_ID');
11: d_deliver_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_LOCATION_ID');
12: d_deliver_to_person_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_PERSON_ID');
13: d_destination_type_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_TYPE_CODE');
14: d_destination_subinv CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_SUBINV');

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

7: -- The module base for the subprogram.
8: d_amount_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_ORDERED');
9: d_quantity_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_ORDERED');
10: d_destination_org_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_ORG_ID');
11: d_deliver_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_LOCATION_ID');
12: d_deliver_to_person_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_PERSON_ID');
13: d_destination_type_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_TYPE_CODE');
14: d_destination_subinv CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_SUBINV');
15: d_wip_entity_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'WIP_ENTITY_ID');

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

8: d_amount_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'AMOUNT_ORDERED');
9: d_quantity_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_ORDERED');
10: d_destination_org_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_ORG_ID');
11: d_deliver_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_LOCATION_ID');
12: d_deliver_to_person_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_PERSON_ID');
13: d_destination_type_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_TYPE_CODE');
14: d_destination_subinv CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_SUBINV');
15: d_wip_entity_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'WIP_ENTITY_ID');
16: d_prevent_encumberance_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PREVENT_ENCUMBERANCE_FLAG');

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

9: d_quantity_ordered CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'QUANTITY_ORDERED');
10: d_destination_org_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_ORG_ID');
11: d_deliver_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_LOCATION_ID');
12: d_deliver_to_person_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_PERSON_ID');
13: d_destination_type_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_TYPE_CODE');
14: d_destination_subinv CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_SUBINV');
15: d_wip_entity_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'WIP_ENTITY_ID');
16: d_prevent_encumberance_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PREVENT_ENCUMBERANCE_FLAG');
17: d_charge_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CHARGE_ACCOUNT_ID');

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

10: d_destination_org_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_ORG_ID');
11: d_deliver_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_LOCATION_ID');
12: d_deliver_to_person_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_PERSON_ID');
13: d_destination_type_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_TYPE_CODE');
14: d_destination_subinv CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_SUBINV');
15: d_wip_entity_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'WIP_ENTITY_ID');
16: d_prevent_encumberance_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PREVENT_ENCUMBERANCE_FLAG');
17: d_charge_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CHARGE_ACCOUNT_ID');
18: d_budget_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BUDGET_ACCOUNT_ID');

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

11: d_deliver_to_location_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_LOCATION_ID');
12: d_deliver_to_person_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_PERSON_ID');
13: d_destination_type_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_TYPE_CODE');
14: d_destination_subinv CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_SUBINV');
15: d_wip_entity_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'WIP_ENTITY_ID');
16: d_prevent_encumberance_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PREVENT_ENCUMBERANCE_FLAG');
17: d_charge_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CHARGE_ACCOUNT_ID');
18: d_budget_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BUDGET_ACCOUNT_ID');
19: d_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCOUNT_ID');

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

12: d_deliver_to_person_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DELIVER_TO_PERSON_ID');
13: d_destination_type_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_TYPE_CODE');
14: d_destination_subinv CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_SUBINV');
15: d_wip_entity_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'WIP_ENTITY_ID');
16: d_prevent_encumberance_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PREVENT_ENCUMBERANCE_FLAG');
17: d_charge_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CHARGE_ACCOUNT_ID');
18: d_budget_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BUDGET_ACCOUNT_ID');
19: d_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCOUNT_ID');
20: d_project_acct_context CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_ACCT_CONTEXT');

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

13: d_destination_type_code CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_TYPE_CODE');
14: d_destination_subinv CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_SUBINV');
15: d_wip_entity_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'WIP_ENTITY_ID');
16: d_prevent_encumberance_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PREVENT_ENCUMBERANCE_FLAG');
17: d_charge_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CHARGE_ACCOUNT_ID');
18: d_budget_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BUDGET_ACCOUNT_ID');
19: d_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCOUNT_ID');
20: d_project_acct_context CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_ACCT_CONTEXT');
21: d_project_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_INFO');

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

14: d_destination_subinv CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'DESTINATION_SUBINV');
15: d_wip_entity_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'WIP_ENTITY_ID');
16: d_prevent_encumberance_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PREVENT_ENCUMBERANCE_FLAG');
17: d_charge_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CHARGE_ACCOUNT_ID');
18: d_budget_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BUDGET_ACCOUNT_ID');
19: d_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCOUNT_ID');
20: d_project_acct_context CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_ACCT_CONTEXT');
21: d_project_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_INFO');
22: d_tax_recovery_override_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_RECOVERY_OVERRIDE_FLAG');

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

15: d_wip_entity_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'WIP_ENTITY_ID');
16: d_prevent_encumberance_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PREVENT_ENCUMBERANCE_FLAG');
17: d_charge_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CHARGE_ACCOUNT_ID');
18: d_budget_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BUDGET_ACCOUNT_ID');
19: d_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCOUNT_ID');
20: d_project_acct_context CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_ACCT_CONTEXT');
21: d_project_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_INFO');
22: d_tax_recovery_override_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_RECOVERY_OVERRIDE_FLAG');
23: -- Indicates that the calling program is PDOI.

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

16: d_prevent_encumberance_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PREVENT_ENCUMBERANCE_FLAG');
17: d_charge_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CHARGE_ACCOUNT_ID');
18: d_budget_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BUDGET_ACCOUNT_ID');
19: d_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCOUNT_ID');
20: d_project_acct_context CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_ACCT_CONTEXT');
21: d_project_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_INFO');
22: d_tax_recovery_override_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_RECOVERY_OVERRIDE_FLAG');
23: -- Indicates that the calling program is PDOI.
24: c_program_pdoi CONSTANT VARCHAR2(10) := 'PDOI';

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

17: d_charge_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'CHARGE_ACCOUNT_ID');
18: d_budget_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BUDGET_ACCOUNT_ID');
19: d_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCOUNT_ID');
20: d_project_acct_context CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_ACCT_CONTEXT');
21: d_project_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_INFO');
22: d_tax_recovery_override_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_RECOVERY_OVERRIDE_FLAG');
23: -- Indicates that the calling program is PDOI.
24: c_program_pdoi CONSTANT VARCHAR2(10) := 'PDOI';
25: -- The application name of PO.

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

18: d_budget_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'BUDGET_ACCOUNT_ID');
19: d_account_id CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACCOUNT_ID');
20: d_project_acct_context CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_ACCT_CONTEXT');
21: d_project_info CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PROJECT_INFO');
22: d_tax_recovery_override_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_RECOVERY_OVERRIDE_FLAG');
23: -- Indicates that the calling program is PDOI.
24: c_program_pdoi CONSTANT VARCHAR2(10) := 'PDOI';
25: -- The application name of PO.
26: c_po CONSTANT VARCHAR2(2) := 'PO';

Line 50: IF po_log.d_proc THEN

46: END IF;
47:
48: x_result_type := po_validations.c_result_type_success;
49:
50: IF po_log.d_proc THEN
51: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
52: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
53: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
54: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

47:
48: x_result_type := po_validations.c_result_type_success;
49:
50: IF po_log.d_proc THEN
51: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
52: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
53: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
54: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
55: END IF;

Line 52: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);

48: x_result_type := po_validations.c_result_type_success;
49:
50: IF po_log.d_proc THEN
51: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
52: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
53: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
54: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
55: END IF;
56:

Line 53: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);

49:
50: IF po_log.d_proc THEN
51: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
52: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
53: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
54: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
55: END IF;
56:
57: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

50: IF po_log.d_proc THEN
51: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
52: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
53: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
54: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
55: END IF;
56:
57: FOR i IN 1 .. p_id_tbl.COUNT LOOP
58: IF (p_order_type_code_tbl(i) IN('RATE', 'FIXED PRICE')) THEN

Line 79: IF po_log.d_proc THEN

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

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

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

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

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

Line 85: IF po_log.d_exc THEN

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

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

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

Line 114: IF po_log.d_proc THEN

110: END IF;
111:
112: x_result_type := po_validations.c_result_type_success;
113:
114: IF po_log.d_proc THEN
115: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
116: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
117: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
118: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

111:
112: x_result_type := po_validations.c_result_type_success;
113:
114: IF po_log.d_proc THEN
115: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
116: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
117: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
118: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
119: END IF;

Line 116: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);

112: x_result_type := po_validations.c_result_type_success;
113:
114: IF po_log.d_proc THEN
115: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
116: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
117: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
118: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
119: END IF;
120:

Line 117: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);

113:
114: IF po_log.d_proc THEN
115: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
116: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
117: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
118: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
119: END IF;
120:
121: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

114: IF po_log.d_proc THEN
115: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
116: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
117: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
118: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
119: END IF;
120:
121: FOR i IN 1 .. p_id_tbl.COUNT LOOP
122: IF (p_order_type_code_tbl(i) IN('RATE', 'FIXED PRICE')) THEN

Line 143: IF po_log.d_proc THEN

139: END IF;
140: END IF;
141: END LOOP;
142:
143: IF po_log.d_proc THEN
144: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
145: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
146: END IF;
147: EXCEPTION

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

140: END IF;
141: END LOOP;
142:
143: IF po_log.d_proc THEN
144: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
145: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
146: END IF;
147: EXCEPTION
148: WHEN OTHERS THEN

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

141: END LOOP;
142:
143: IF po_log.d_proc THEN
144: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
145: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
146: END IF;
147: EXCEPTION
148: WHEN OTHERS THEN
149: IF po_log.d_exc THEN

Line 149: IF po_log.d_exc THEN

145: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
146: END IF;
147: EXCEPTION
148: WHEN OTHERS THEN
149: IF po_log.d_exc THEN
150: po_log.exc(d_mod, 0, NULL);
151: END IF;
152:
153: RAISE;

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

146: END IF;
147: EXCEPTION
148: WHEN OTHERS THEN
149: IF po_log.d_exc THEN
150: po_log.exc(d_mod, 0, NULL);
151: END IF;
152:
153: RAISE;
154: END quantity_ordered;

Line 175: IF po_log.d_proc THEN

171: END IF;
172:
173: x_result_type := po_validations.c_result_type_success;
174:
175: IF po_log.d_proc THEN
176: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
177: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
178: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
179: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

172:
173: x_result_type := po_validations.c_result_type_success;
174:
175: IF po_log.d_proc THEN
176: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
177: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
178: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
179: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
180: END IF;

Line 177: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);

173: x_result_type := po_validations.c_result_type_success;
174:
175: IF po_log.d_proc THEN
176: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
177: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
178: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
179: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
180: END IF;
181:

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

174:
175: IF po_log.d_proc THEN
176: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
177: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
178: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
179: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
180: END IF;
181:
182: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

175: IF po_log.d_proc THEN
176: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
177: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
178: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
179: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
180: END IF;
181:
182: FOR i IN 1 .. p_id_tbl.COUNT LOOP
183: IF (NVL(p_dest_org_id_tbl(i), -11) <> NVL(p_ship_to_org_id_tbl(i), -99)) THEN

Line 195: IF po_log.d_proc THEN

191: x_result_type := po_validations.c_result_type_failure;
192: END IF;
193: END LOOP;
194:
195: IF po_log.d_proc THEN
196: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
197: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
198: END IF;
199: EXCEPTION

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

192: END IF;
193: END LOOP;
194:
195: IF po_log.d_proc THEN
196: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
197: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
198: END IF;
199: EXCEPTION
200: WHEN OTHERS THEN

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

193: END LOOP;
194:
195: IF po_log.d_proc THEN
196: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
197: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
198: END IF;
199: EXCEPTION
200: WHEN OTHERS THEN
201: IF po_log.d_exc THEN

Line 201: IF po_log.d_exc THEN

197: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
198: END IF;
199: EXCEPTION
200: WHEN OTHERS THEN
201: IF po_log.d_exc THEN
202: po_log.exc(d_mod, 0, NULL);
203: END IF;
204:
205: RAISE;

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

198: END IF;
199: EXCEPTION
200: WHEN OTHERS THEN
201: IF po_log.d_exc THEN
202: po_log.exc(d_mod, 0, NULL);
203: END IF;
204:
205: RAISE;
206: END destination_org_id;

Line 228: IF po_log.d_proc THEN

224: END IF;
225:
226: x_result_type := po_validations.c_result_type_success;
227:
228: IF po_log.d_proc THEN
229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
230: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
231: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
232: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

225:
226: x_result_type := po_validations.c_result_type_success;
227:
228: IF po_log.d_proc THEN
229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
230: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
231: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
232: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
233: END IF;

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

226: x_result_type := po_validations.c_result_type_success;
227:
228: IF po_log.d_proc THEN
229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
230: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
231: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
232: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
233: END IF;
234:

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

227:
228: IF po_log.d_proc THEN
229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
230: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
231: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
232: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
233: END IF;
234:
235: FORALL i IN 1 .. p_id_tbl.COUNT

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

228: IF po_log.d_proc THEN
229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
230: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
231: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
232: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
233: END IF;
234:
235: FORALL i IN 1 .. p_id_tbl.COUNT
236: INSERT INTO po_validation_results_gt

Line 273: IF po_log.d_proc THEN

269: IF (SQL%ROWCOUNT > 0) THEN
270: x_result_type := po_validations.c_result_type_failure;
271: END IF;
272:
273: IF po_log.d_proc THEN
274: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
275: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
276: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
277: END IF;

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

271: END IF;
272:
273: IF po_log.d_proc THEN
274: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
275: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
276: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
277: END IF;
278: EXCEPTION
279: WHEN OTHERS THEN

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

272:
273: IF po_log.d_proc THEN
274: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
275: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
276: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
277: END IF;
278: EXCEPTION
279: WHEN OTHERS THEN
280: IF po_log.d_exc THEN

Line 280: IF po_log.d_exc THEN

276: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
277: END IF;
278: EXCEPTION
279: WHEN OTHERS THEN
280: IF po_log.d_exc THEN
281: po_log.exc(d_mod, 0, NULL);
282: END IF;
283:
284: RAISE;

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

277: END IF;
278: EXCEPTION
279: WHEN OTHERS THEN
280: IF po_log.d_exc THEN
281: po_log.exc(d_mod, 0, NULL);
282: END IF;
283:
284: RAISE;
285: END deliver_to_location_id;

Line 314: IF po_log.d_proc THEN

310: END IF;
311:
312: x_result_type := po_validations.c_result_type_success;
313:
314: IF po_log.d_proc THEN
315: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
316: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
317: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
318: END IF;

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

311:
312: x_result_type := po_validations.c_result_type_success;
313:
314: IF po_log.d_proc THEN
315: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
316: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
317: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
318: END IF;
319:

Line 316: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);

312: x_result_type := po_validations.c_result_type_success;
313:
314: IF po_log.d_proc THEN
315: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
316: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
317: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
318: END IF;
319:
320: d_position := 10;

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

313:
314: IF po_log.d_proc THEN
315: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
316: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
317: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
318: END IF;
319:
320: d_position := 10;
321:

Line 341: IF (PO_LOG.d_stmt) THEN

337: ELSE
338: l_assignment_type := 'E';
339: END IF;
340:
341: IF (PO_LOG.d_stmt) THEN
342: PO_LOG.stmt(d_mod, d_position, 'l_fsp_business_group_id', l_fsp_business_group_id);
343: PO_LOG.stmt(d_mod, d_position, 'l_assignment_type', l_assignment_type);
344: END IF;
345:

Line 342: PO_LOG.stmt(d_mod, d_position, 'l_fsp_business_group_id', l_fsp_business_group_id);

338: l_assignment_type := 'E';
339: END IF;
340:
341: IF (PO_LOG.d_stmt) THEN
342: PO_LOG.stmt(d_mod, d_position, 'l_fsp_business_group_id', l_fsp_business_group_id);
343: PO_LOG.stmt(d_mod, d_position, 'l_assignment_type', l_assignment_type);
344: END IF;
345:
346: d_position := 20;

Line 343: PO_LOG.stmt(d_mod, d_position, 'l_assignment_type', l_assignment_type);

339: END IF;
340:
341: IF (PO_LOG.d_stmt) THEN
342: PO_LOG.stmt(d_mod, d_position, 'l_fsp_business_group_id', l_fsp_business_group_id);
343: PO_LOG.stmt(d_mod, d_position, 'l_assignment_type', l_assignment_type);
344: END IF;
345:
346: d_position := 20;
347:

Line 391: IF po_log.d_proc THEN

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

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

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

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

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

Line 398: IF po_log.d_exc THEN

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

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

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

Line 471: IF po_log.d_proc THEN

467: x_result_type := po_validations.c_result_type_success;
468:
469: d_position := 10;
470:
471: IF po_log.d_proc THEN
472: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
473: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
474: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
475: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);

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

468:
469: d_position := 10;
470:
471: IF po_log.d_proc THEN
472: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
473: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
474: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
475: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);

Line 473: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

469: d_position := 10;
470:
471: IF po_log.d_proc THEN
472: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
473: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
474: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
475: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
477: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);

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

470:
471: IF po_log.d_proc THEN
472: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
473: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
474: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
475: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
477: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);

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

471: IF po_log.d_proc THEN
472: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
473: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
474: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
475: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
477: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
479: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);

Line 476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);

472: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
473: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
474: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
475: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
477: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
479: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
480: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);

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

473: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
474: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
475: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
477: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
479: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
480: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
481: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);

474: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
475: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
477: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
479: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
480: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
481: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
482: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 479: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);

475: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
477: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
479: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
480: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
481: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
482: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
483: END IF;

Line 480: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);

476: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
477: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
479: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
480: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
481: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
482: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
483: END IF;
484:

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

477: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
479: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
480: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
481: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
482: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
483: END IF;
484:
485: d_position := 20;

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

478: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
479: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
480: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
481: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
482: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
483: END IF;
484:
485: d_position := 20;
486:

Line 547: IF (PO_LOG.d_stmt) THEN

543: l_item_status_tbl.extend(p_id_tbl.COUNT);
544:
545: FOR i IN 1..l_index_tbl.COUNT
546: LOOP
547: IF (PO_LOG.d_stmt) THEN
548: PO_LOG.stmt(d_mod, d_position, 'index', l_index_tbl(i));
549: PO_LOG.stmt(d_mod, d_position, 'new item_status', l_result_tbl(i));
550: END IF;
551:

Line 548: PO_LOG.stmt(d_mod, d_position, 'index', l_index_tbl(i));

544:
545: FOR i IN 1..l_index_tbl.COUNT
546: LOOP
547: IF (PO_LOG.d_stmt) THEN
548: PO_LOG.stmt(d_mod, d_position, 'index', l_index_tbl(i));
549: PO_LOG.stmt(d_mod, d_position, 'new item_status', l_result_tbl(i));
550: END IF;
551:
552: l_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);

Line 549: PO_LOG.stmt(d_mod, d_position, 'new item_status', l_result_tbl(i));

545: FOR i IN 1..l_index_tbl.COUNT
546: LOOP
547: IF (PO_LOG.d_stmt) THEN
548: PO_LOG.stmt(d_mod, d_position, 'index', l_index_tbl(i));
549: PO_LOG.stmt(d_mod, d_position, 'new item_status', l_result_tbl(i));
550: END IF;
551:
552: l_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);
553: END LOOP;

Line 562: IF po_log.d_proc THEN

558: l_item_status_tbl(i) := 'D';
559: END IF;
560: END LOOP;
561:
562: IF po_log.d_proc THEN
563: po_log.proc_begin(d_mod, 'l_item_status_tbl', l_item_status_tbl);
564: END IF;
565:
566: d_position := 70;

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

559: END IF;
560: END LOOP;
561:
562: IF po_log.d_proc THEN
563: po_log.proc_begin(d_mod, 'l_item_status_tbl', l_item_status_tbl);
564: END IF;
565:
566: d_position := 70;
567:

Line 622: IF po_log.d_proc THEN

618: END IF;
619:
620: d_position := 80;
621:
622: IF po_log.d_proc THEN
623: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
624: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
625: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
626: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

620: d_position := 80;
621:
622: IF po_log.d_proc THEN
623: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
624: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
625: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
626: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
627: END IF;
628: EXCEPTION

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

621:
622: IF po_log.d_proc THEN
623: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
624: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
625: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
626: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
627: END IF;
628: EXCEPTION
629: WHEN OTHERS THEN

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

622: IF po_log.d_proc THEN
623: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
624: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
625: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
626: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
627: END IF;
628: EXCEPTION
629: WHEN OTHERS THEN
630: IF po_log.d_exc THEN

Line 630: IF po_log.d_exc THEN

626: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
627: END IF;
628: EXCEPTION
629: WHEN OTHERS THEN
630: IF po_log.d_exc THEN
631: po_log.exc(d_mod, d_position, NULL);
632: END IF;
633:
634: RAISE;

Line 631: po_log.exc(d_mod, d_position, NULL);

627: END IF;
628: EXCEPTION
629: WHEN OTHERS THEN
630: IF po_log.d_exc THEN
631: po_log.exc(d_mod, d_position, NULL);
632: END IF;
633:
634: RAISE;
635: END destination_type_code;

Line 668: IF po_log.d_proc THEN

664: END IF;
665:
666: x_result_type := po_validations.c_result_type_success;
667:
668: IF po_log.d_proc THEN
669: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
670: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
671: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
672: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);

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

665:
666: x_result_type := po_validations.c_result_type_success;
667:
668: IF po_log.d_proc THEN
669: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
670: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
671: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
672: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
673: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);

Line 670: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);

666: x_result_type := po_validations.c_result_type_success;
667:
668: IF po_log.d_proc THEN
669: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
670: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
671: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
672: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
673: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
674: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);

Line 671: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

667:
668: IF po_log.d_proc THEN
669: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
670: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
671: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
672: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
673: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
674: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
675: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

668: IF po_log.d_proc THEN
669: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
670: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
671: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
672: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
673: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
674: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
675: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
676: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

669: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
670: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
671: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
672: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
673: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
674: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
675: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
676: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
677: END IF;

Line 674: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);

670: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
671: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
672: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
673: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
674: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
675: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
676: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
677: END IF;
678:

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

671: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
672: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
673: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
674: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
675: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
676: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
677: END IF;
678:
679: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

672: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
673: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
674: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
675: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
676: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
677: END IF;
678:
679: FOR i IN 1 .. p_id_tbl.COUNT LOOP
680: IF (p_dest_type_code_tbl(i) IN('SHOP FLOOR', 'EXPENSE') AND p_destination_subinv_tbl(i) IS NOT NULL) THEN

Line 777: IF po_log.d_proc THEN

773: IF (SQL%ROWCOUNT > 0) THEN
774: x_result_type := po_validations.c_result_type_failure;
775: END IF;
776:
777: IF po_log.d_proc THEN
778: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
779: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
780: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
781: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

775: END IF;
776:
777: IF po_log.d_proc THEN
778: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
779: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
780: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
781: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
782: END IF;
783: EXCEPTION

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

776:
777: IF po_log.d_proc THEN
778: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
779: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
780: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
781: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
782: END IF;
783: EXCEPTION
784: WHEN OTHERS THEN

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

777: IF po_log.d_proc THEN
778: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
779: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
780: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
781: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
782: END IF;
783: EXCEPTION
784: WHEN OTHERS THEN
785: IF po_log.d_exc THEN

Line 785: IF po_log.d_exc THEN

781: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
782: END IF;
783: EXCEPTION
784: WHEN OTHERS THEN
785: IF po_log.d_exc THEN
786: po_log.exc(d_mod, 0, NULL);
787: END IF;
788:
789: RAISE;

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

782: END IF;
783: EXCEPTION
784: WHEN OTHERS THEN
785: IF po_log.d_exc THEN
786: po_log.exc(d_mod, 0, NULL);
787: END IF;
788:
789: RAISE;
790: END destination_subinv;

Line 829: IF po_log.d_proc THEN

825: END IF;
826:
827: x_result_type := po_validations.c_result_type_success;
828:
829: IF po_log.d_proc THEN
830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
831: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
832: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
833: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

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

826:
827: x_result_type := po_validations.c_result_type_success;
828:
829: IF po_log.d_proc THEN
830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
831: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
832: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
833: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
834: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);

Line 831: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);

827: x_result_type := po_validations.c_result_type_success;
828:
829: IF po_log.d_proc THEN
830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
831: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
832: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
833: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
834: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
835: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 832: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);

828:
829: IF po_log.d_proc THEN
830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
831: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
832: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
833: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
834: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
835: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
836: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 833: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

829: IF po_log.d_proc THEN
830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
831: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
832: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
833: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
834: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
835: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
836: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
837: END IF;

Line 834: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);

830: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
831: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
832: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
833: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
834: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
835: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
836: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
837: END IF;
838:

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

831: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
832: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
833: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
834: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
835: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
836: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
837: END IF;
838:
839: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

832: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
833: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
834: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
835: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
836: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
837: END IF;
838:
839: FOR i IN 1 .. p_id_tbl.COUNT LOOP
840: IF (p_dest_type_code_tbl(i) = 'SHOP FLOOR' AND p_wip_entity_id_tbl(i) IS NULL) THEN

Line 923: IF po_log.d_proc THEN

919: IF (SQL%ROWCOUNT > 0) THEN
920: x_result_type := po_validations.c_result_type_failure;
921: END IF;
922:
923: IF po_log.d_proc THEN
924: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
925: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
926: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
927: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

921: END IF;
922:
923: IF po_log.d_proc THEN
924: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
925: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
926: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
927: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
928: END IF;
929: EXCEPTION

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

922:
923: IF po_log.d_proc THEN
924: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
925: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
926: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
927: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
928: END IF;
929: EXCEPTION
930: WHEN OTHERS THEN

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

923: IF po_log.d_proc THEN
924: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
925: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
926: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
927: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
928: END IF;
929: EXCEPTION
930: WHEN OTHERS THEN
931: IF po_log.d_exc THEN

Line 931: IF po_log.d_exc THEN

927: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
928: END IF;
929: EXCEPTION
930: WHEN OTHERS THEN
931: IF po_log.d_exc THEN
932: po_log.exc(d_mod, 0, NULL);
933: END IF;
934:
935: RAISE;

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

928: END IF;
929: EXCEPTION
930: WHEN OTHERS THEN
931: IF po_log.d_exc THEN
932: po_log.exc(d_mod, 0, NULL);
933: END IF;
934:
935: RAISE;
936: END wip_entity_id;

Line 958: IF po_log.d_proc THEN

954: END IF;
955:
956: x_result_type := po_validations.c_result_type_success;
957:
958: IF po_log.d_proc THEN
959: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
960: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
961: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
962: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

955:
956: x_result_type := po_validations.c_result_type_success;
957:
958: IF po_log.d_proc THEN
959: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
960: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
961: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
962: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
963: END IF;

Line 960: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);

956: x_result_type := po_validations.c_result_type_success;
957:
958: IF po_log.d_proc THEN
959: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
960: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
961: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
962: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
963: END IF;
964:

Line 961: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

957:
958: IF po_log.d_proc THEN
959: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
960: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
961: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
962: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
963: END IF;
964:
965: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

958: IF po_log.d_proc THEN
959: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
960: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
961: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
962: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
963: END IF;
964:
965: FOR i IN 1 .. p_id_tbl.COUNT LOOP
966: IF ( (p_dest_type_code_tbl(i) = 'SHOP FLOOR' AND p_prevent_encum_flag_tbl(i) = 'N')

Line 977: IF po_log.d_proc THEN

973: x_result_type := po_validations.c_result_type_failure;
974: END IF;
975: END LOOP;
976:
977: IF po_log.d_proc THEN
978: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
979: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
980: END IF;
981: EXCEPTION

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

974: END IF;
975: END LOOP;
976:
977: IF po_log.d_proc THEN
978: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
979: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
980: END IF;
981: EXCEPTION
982: WHEN OTHERS THEN

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

975: END LOOP;
976:
977: IF po_log.d_proc THEN
978: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
979: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
980: END IF;
981: EXCEPTION
982: WHEN OTHERS THEN
983: IF po_log.d_exc THEN

Line 983: IF po_log.d_exc THEN

979: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
980: END IF;
981: EXCEPTION
982: WHEN OTHERS THEN
983: IF po_log.d_exc THEN
984: po_log.exc(d_mod, 0, NULL);
985: END IF;
986:
987: RAISE;

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

980: END IF;
981: EXCEPTION
982: WHEN OTHERS THEN
983: IF po_log.d_exc THEN
984: po_log.exc(d_mod, 0, NULL);
985: END IF;
986:
987: RAISE;
988: END prevent_encumbrance_flag;

Line 1011: IF po_log.d_proc THEN

1007: END IF;
1008:
1009: x_result_type := po_validations.c_result_type_success;
1010:
1011: IF po_log.d_proc THEN
1012: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1013: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1014: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1015: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);

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

1008:
1009: x_result_type := po_validations.c_result_type_success;
1010:
1011: IF po_log.d_proc THEN
1012: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1013: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1014: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1015: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1016: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 1013: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);

1009: x_result_type := po_validations.c_result_type_success;
1010:
1011: IF po_log.d_proc THEN
1012: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1013: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1014: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1015: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1016: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1017: END IF;

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

1010:
1011: IF po_log.d_proc THEN
1012: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1013: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1014: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1015: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1016: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1017: END IF;
1018:

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

1011: IF po_log.d_proc THEN
1012: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1013: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1014: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1015: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1016: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1017: END IF;
1018:
1019: FORALL i IN 1 .. p_id_tbl.COUNT

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

1012: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1013: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1014: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1015: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1016: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1017: END IF;
1018:
1019: FORALL i IN 1 .. p_id_tbl.COUNT
1020: INSERT INTO po_validation_results_gt

Line 1059: IF po_log.d_proc THEN

1055: IF (SQL%ROWCOUNT > 0) THEN
1056: x_result_type := po_validations.c_result_type_failure;
1057: END IF;
1058:
1059: IF po_log.d_proc THEN
1060: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1061: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1062: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1063: END IF;

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

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

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

1058:
1059: IF po_log.d_proc THEN
1060: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1061: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1062: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1063: END IF;
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: IF po_log.d_exc THEN

Line 1066: IF po_log.d_exc THEN

1062: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1063: END IF;
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: IF po_log.d_exc THEN
1067: po_log.exc(d_mod, 0, NULL);
1068: END IF;
1069:
1070: RAISE;

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

1063: END IF;
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: IF po_log.d_exc THEN
1067: po_log.exc(d_mod, 0, NULL);
1068: END IF;
1069:
1070: RAISE;
1071: END charge_account_id;

Line 1097: IF po_log.d_proc THEN

1093: END IF;
1094:
1095: x_result_type := po_validations.c_result_type_success;
1096:
1097: IF po_log.d_proc THEN
1098: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1099: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1100: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1101: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

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

1094:
1095: x_result_type := po_validations.c_result_type_success;
1096:
1097: IF po_log.d_proc THEN
1098: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1099: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1100: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1101: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1102: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);

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

1095: x_result_type := po_validations.c_result_type_success;
1096:
1097: IF po_log.d_proc THEN
1098: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1099: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1100: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1101: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1102: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1103: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);

Line 1100: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);

1096:
1097: IF po_log.d_proc THEN
1098: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1099: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1100: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1101: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1102: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1103: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1104: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 1101: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

1097: IF po_log.d_proc THEN
1098: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1099: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1100: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1101: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1102: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1103: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1104: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1105: END IF;

Line 1102: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);

1098: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1099: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1100: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1101: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1102: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1103: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1104: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1105: END IF;
1106:

Line 1103: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);

1099: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1100: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1101: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1102: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1103: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1104: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1105: END IF;
1106:
1107: -- bug 4899825: add checking on destination_type_code when

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

1100: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1101: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1102: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1103: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1104: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1105: END IF;
1106:
1107: -- bug 4899825: add checking on destination_type_code when
1108: -- budget_account_id is empty; If destination_

Line 1153: IF po_log.d_proc THEN

1149: IF (SQL%ROWCOUNT > 0) THEN
1150: x_result_type := po_validations.c_result_type_failure;
1151: END IF;
1152:
1153: IF po_log.d_proc THEN
1154: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1155: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1156: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1157: END IF;

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

1151: END IF;
1152:
1153: IF po_log.d_proc THEN
1154: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1155: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1156: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1157: END IF;
1158: EXCEPTION
1159: WHEN OTHERS THEN

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

1152:
1153: IF po_log.d_proc THEN
1154: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1155: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1156: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1157: END IF;
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: IF po_log.d_exc THEN

Line 1160: IF po_log.d_exc THEN

1156: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1157: END IF;
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: IF po_log.d_exc THEN
1161: po_log.exc(d_mod, 0, NULL);
1162: END IF;
1163:
1164: RAISE;

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

1157: END IF;
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: IF po_log.d_exc THEN
1161: po_log.exc(d_mod, 0, NULL);
1162: END IF;
1163:
1164: RAISE;
1165: END budget_account_id;

Line 1191: IF po_log.d_proc THEN

1187: END IF;
1188:
1189: x_result_type := po_validations.c_result_type_success;
1190:
1191: IF po_log.d_proc THEN
1192: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1193: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1194: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);

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

1188:
1189: x_result_type := po_validations.c_result_type_success;
1190:
1191: IF po_log.d_proc THEN
1192: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1193: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1194: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1196: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);

Line 1193: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);

1189: x_result_type := po_validations.c_result_type_success;
1190:
1191: IF po_log.d_proc THEN
1192: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1193: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1194: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1196: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1197: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);

Line 1194: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);

1190:
1191: IF po_log.d_proc THEN
1192: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1193: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1194: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1196: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1197: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1198: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);

Line 1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);

1191: IF po_log.d_proc THEN
1192: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1193: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1194: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1196: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1197: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1198: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1199: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 1196: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);

1192: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1193: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1194: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1196: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1197: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1198: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1199: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1200: END IF;

Line 1197: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);

1193: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1194: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1196: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1197: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1198: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1199: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1200: END IF;
1201:

Line 1198: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);

1194: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1196: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1197: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1198: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1199: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1200: END IF;
1201:
1202: FORALL i IN 1 .. p_id_tbl.COUNT

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

1195: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1196: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1197: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1198: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1199: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1200: END IF;
1201:
1202: FORALL i IN 1 .. p_id_tbl.COUNT
1203: INSERT INTO po_validation_results_gt

Line 1241: IF po_log.d_proc THEN

1237: IF (SQL%ROWCOUNT > 0) THEN
1238: x_result_type := po_validations.c_result_type_failure;
1239: END IF;
1240:
1241: IF po_log.d_proc THEN
1242: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1243: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1244: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1245: END IF;

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

1239: END IF;
1240:
1241: IF po_log.d_proc THEN
1242: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1243: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1244: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1245: END IF;
1246: EXCEPTION
1247: WHEN OTHERS THEN

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

1240:
1241: IF po_log.d_proc THEN
1242: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1243: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1244: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1245: END IF;
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: IF po_log.d_exc THEN

Line 1248: IF po_log.d_exc THEN

1244: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1245: END IF;
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: IF po_log.d_exc THEN
1249: po_log.exc(d_mod, 0, NULL);
1250: END IF;
1251:
1252: RAISE;

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

1245: END IF;
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: IF po_log.d_exc THEN
1249: po_log.exc(d_mod, 0, NULL);
1250: END IF;
1251:
1252: RAISE;
1253: END account_id;

Line 1278: IF po_log.d_proc THEN

1274: END IF;
1275:
1276: x_result_type := po_validations.c_result_type_success;
1277:
1278: IF po_log.d_proc THEN
1279: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1280: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1281: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1282: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);

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

1275:
1276: x_result_type := po_validations.c_result_type_success;
1277:
1278: IF po_log.d_proc THEN
1279: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1280: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1281: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1282: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1283: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);

Line 1280: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);

1276: x_result_type := po_validations.c_result_type_success;
1277:
1278: IF po_log.d_proc THEN
1279: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1280: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1281: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1282: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1283: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1284: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);

Line 1281: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);

1277:
1278: IF po_log.d_proc THEN
1279: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1280: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1281: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1282: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1283: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1284: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1285: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 1282: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);

1278: IF po_log.d_proc THEN
1279: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1280: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1281: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1282: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1283: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1284: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1285: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1286: END IF;

Line 1283: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);

1279: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1280: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1281: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1282: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1283: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1284: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1285: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1286: END IF;
1287:

Line 1284: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);

1280: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1281: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1282: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1283: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1284: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1285: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1286: END IF;
1287:
1288: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

1281: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1282: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1283: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1284: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1285: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1286: END IF;
1287:
1288: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1289: IF ( (p_project_acct_ctx_tbl(i) IS NULL OR p_project_acct_ctx_tbl(i) = 'N')

Line 1303: IF po_log.d_proc THEN

1299: x_result_type := po_validations.c_result_type_failure;
1300: END IF;
1301: END LOOP;
1302:
1303: IF po_log.d_proc THEN
1304: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1305: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1306: END IF;
1307: EXCEPTION

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

1300: END IF;
1301: END LOOP;
1302:
1303: IF po_log.d_proc THEN
1304: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1305: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1306: END IF;
1307: EXCEPTION
1308: WHEN OTHERS THEN

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

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

Line 1309: IF po_log.d_exc THEN

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

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

1306: END IF;
1307: EXCEPTION
1308: WHEN OTHERS THEN
1309: IF po_log.d_exc THEN
1310: po_log.exc(d_mod, 0, NULL);
1311: END IF;
1312:
1313: RAISE;
1314: END project_acct_context;

Line 1359: IF po_log.d_proc THEN

1355: END IF;
1356:
1357: x_result_type := po_validations.c_result_type_success;
1358:
1359: IF po_log.d_proc THEN
1360: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1361: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1362: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);

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

1356:
1357: x_result_type := po_validations.c_result_type_success;
1358:
1359: IF po_log.d_proc THEN
1360: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1361: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1362: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);

Line 1361: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);

1357: x_result_type := po_validations.c_result_type_success;
1358:
1359: IF po_log.d_proc THEN
1360: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1361: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1362: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);

Line 1362: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

1358:
1359: IF po_log.d_proc THEN
1360: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1361: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1362: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);

Line 1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);

1359: IF po_log.d_proc THEN
1360: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1361: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1362: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1367: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);

Line 1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);

1360: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1361: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1362: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1367: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1368: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);

Line 1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);

1361: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1362: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1367: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1368: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1369: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);

Line 1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);

1362: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1367: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1368: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1369: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);

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

1363: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1367: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1368: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1369: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);

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

1364: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1367: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1368: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1369: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1372: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);

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

1365: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1367: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1368: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1369: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1372: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1373: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);

Line 1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);

1366: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1367: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1368: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1369: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1372: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1373: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);

Line 1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);

1367: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1368: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1369: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1372: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1373: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1375: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 1372: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);

1368: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1369: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1372: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1373: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1375: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1376: END IF;

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

1369: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1372: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1373: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1375: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1376: END IF;
1377:

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

1370: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1372: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1373: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1375: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1376: END IF;
1377:
1378: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

1371: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1372: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1373: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1374: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1375: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1376: END IF;
1377:
1378: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1379: IF (p_project_acct_ctx_tbl(i) = 'Y') THEN

Line 1415: IF po_log.d_proc THEN

1411: x_result_type := po_validations.c_result_type_failure;
1412: END IF;
1413: END LOOP;
1414:
1415: IF po_log.d_proc THEN
1416: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1417: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1418: END IF;
1419: EXCEPTION

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

1412: END IF;
1413: END LOOP;
1414:
1415: IF po_log.d_proc THEN
1416: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1417: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1418: END IF;
1419: EXCEPTION
1420: WHEN OTHERS THEN

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

1413: END LOOP;
1414:
1415: IF po_log.d_proc THEN
1416: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1417: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1418: END IF;
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: IF po_log.d_exc THEN

Line 1421: IF po_log.d_exc THEN

1417: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1418: END IF;
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: IF po_log.d_exc THEN
1422: po_log.exc(d_mod, 0, NULL);
1423: END IF;
1424:
1425: RAISE;

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

1418: END IF;
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: IF po_log.d_exc THEN
1422: po_log.exc(d_mod, 0, NULL);
1423: END IF;
1424:
1425: RAISE;
1426: END project_info;

Line 1447: IF po_log.d_proc THEN

1443: END IF;
1444:
1445: x_result_type := po_validations.c_result_type_success;
1446:
1447: IF po_log.d_proc THEN
1448: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1449: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1450: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1451: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1444:
1445: x_result_type := po_validations.c_result_type_success;
1446:
1447: IF po_log.d_proc THEN
1448: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1449: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1450: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1451: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1452: END IF;

Line 1449: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);

1445: x_result_type := po_validations.c_result_type_success;
1446:
1447: IF po_log.d_proc THEN
1448: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1449: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1450: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1451: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1452: END IF;
1453:

Line 1450: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);

1446:
1447: IF po_log.d_proc THEN
1448: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1449: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1450: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1451: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1452: END IF;
1453:
1454: IF (p_allow_tax_rate_override <> 'Y') THEN

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

1447: IF po_log.d_proc THEN
1448: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1449: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1450: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1451: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1452: END IF;
1453:
1454: IF (p_allow_tax_rate_override <> 'Y') THEN
1455: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 1467: IF po_log.d_proc THEN

1463: END IF;
1464: END LOOP;
1465: END IF;
1466:
1467: IF po_log.d_proc THEN
1468: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1469: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1470: END IF;
1471: EXCEPTION

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

1464: END LOOP;
1465: END IF;
1466:
1467: IF po_log.d_proc THEN
1468: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1469: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1470: END IF;
1471: EXCEPTION
1472: WHEN OTHERS THEN

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

1465: END IF;
1466:
1467: IF po_log.d_proc THEN
1468: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1469: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1470: END IF;
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: IF po_log.d_exc THEN

Line 1473: IF po_log.d_exc THEN

1469: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1470: END IF;
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: IF po_log.d_exc THEN
1474: po_log.exc(d_mod, 0, NULL);
1475: END IF;
1476:
1477: RAISE;

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

1470: END IF;
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: IF po_log.d_exc THEN
1474: po_log.exc(d_mod, 0, NULL);
1475: END IF;
1476:
1477: RAISE;
1478: END tax_recovery_override_flag;