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.20.12020000.2 2013/02/10 14:17:09 vegajula 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: -- ACRN proj

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: -- ACRN proj
24: d_ACRN_value_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACRN_VALUE_VALID');

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: -- ACRN proj
24: d_ACRN_value_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACRN_VALUE_VALID');
25: -- CLM Partial Funding Changes

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: -- ACRN proj
24: d_ACRN_value_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACRN_VALUE_VALID');
25: -- CLM Partial Funding Changes
26: d_partial_funded_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PARTIAL_FUNDED_FLAG');

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

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: -- ACRN proj
24: d_ACRN_value_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACRN_VALUE_VALID');
25: -- CLM Partial Funding Changes
26: d_partial_funded_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PARTIAL_FUNDED_FLAG');
27: -- Indicates that the calling program is PDOI.
28: c_program_pdoi CONSTANT VARCHAR2(10) := 'PDOI';

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

22: d_tax_recovery_override_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'TAX_RECOVERY_OVERRIDE_FLAG');
23: -- ACRN proj
24: d_ACRN_value_valid CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'ACRN_VALUE_VALID');
25: -- CLM Partial Funding Changes
26: d_partial_funded_flag CONSTANT VARCHAR2(100) := po_log.get_subprogram_base(d_package_base, 'PARTIAL_FUNDED_FLAG');
27: -- Indicates that the calling program is PDOI.
28: c_program_pdoi CONSTANT VARCHAR2(10) := 'PDOI';
29: -- The application name of PO.
30: c_po CONSTANT VARCHAR2(2) := 'PO';

Line 55: IF po_log.d_proc THEN

51: END IF;
52:
53: x_result_type := po_validations.c_result_type_success;
54:
55: IF po_log.d_proc THEN
56: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
57: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
58: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
59: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project

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

52:
53: x_result_type := po_validations.c_result_type_success;
54:
55: IF po_log.d_proc THEN
56: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
57: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
58: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
59: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
60: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

53: x_result_type := po_validations.c_result_type_success;
54:
55: IF po_log.d_proc THEN
56: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
57: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
58: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
59: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
60: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
61: END IF;

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

54:
55: IF po_log.d_proc THEN
56: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
57: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
58: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
59: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
60: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
61: END IF;
62:

Line 59: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project

55: IF po_log.d_proc THEN
56: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
57: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
58: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
59: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
60: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
61: END IF;
62:
63: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

56: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
57: po_log.proc_begin(d_mod, 'p_amount_ordered_tbl', p_amount_ordered_tbl);
58: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
59: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
60: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
61: END IF;
62:
63: FOR i IN 1 .. p_id_tbl.COUNT LOOP
64: IF Nvl(p_distribution_type_tbl(i),'STANDARD') <> 'PREPAYMENT' THEN -- PDOI for Complex PO Project

Line 87: IF po_log.d_proc THEN

83: END IF;
84: END IF;
85: END LOOP;
86:
87: IF po_log.d_proc THEN
88: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
89: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
90: END IF;
91: EXCEPTION

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

84: END IF;
85: END LOOP;
86:
87: IF po_log.d_proc THEN
88: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
89: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
90: END IF;
91: EXCEPTION
92: WHEN OTHERS THEN

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

85: END LOOP;
86:
87: IF po_log.d_proc THEN
88: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
89: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
90: END IF;
91: EXCEPTION
92: WHEN OTHERS THEN
93: IF po_log.d_exc THEN

Line 93: IF po_log.d_exc THEN

89: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
90: END IF;
91: EXCEPTION
92: WHEN OTHERS THEN
93: IF po_log.d_exc THEN
94: po_log.exc(d_mod, 0, NULL);
95: END IF;
96:
97: RAISE;

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

90: END IF;
91: EXCEPTION
92: WHEN OTHERS THEN
93: IF po_log.d_exc THEN
94: po_log.exc(d_mod, 0, NULL);
95: END IF;
96:
97: RAISE;
98: END amount_ordered;

Line 123: IF po_log.d_proc THEN

119: END IF;
120:
121: x_result_type := po_validations.c_result_type_success;
122:
123: IF po_log.d_proc THEN
124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
125: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
126: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
127: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project

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

120:
121: x_result_type := po_validations.c_result_type_success;
122:
123: IF po_log.d_proc THEN
124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
125: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
126: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
127: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

121: x_result_type := po_validations.c_result_type_success;
122:
123: IF po_log.d_proc THEN
124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
125: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
126: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
127: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
129: END IF;

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

122:
123: IF po_log.d_proc THEN
124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
125: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
126: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
127: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
129: END IF;
130:

Line 127: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project

123: IF po_log.d_proc THEN
124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
125: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
126: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
127: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
129: END IF;
130:
131: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

124: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
125: po_log.proc_begin(d_mod, 'p_quantity_ordered_tbl', p_quantity_ordered_tbl);
126: po_log.proc_begin(d_mod, 'p_order_type_code_tbl', p_order_type_code_tbl);
127: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
129: END IF;
130:
131: FOR i IN 1 .. p_id_tbl.COUNT LOOP
132: IF Nvl(p_distribution_type_tbl(i),'STANDARD') <> 'PREPAYMENT' THEN -- PDOI for Complex PO Project

Line 155: IF po_log.d_proc THEN

151: END IF;
152: END IF;
153: END LOOP;
154:
155: IF po_log.d_proc THEN
156: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
157: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
158: END IF;
159: EXCEPTION

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

152: END IF;
153: END LOOP;
154:
155: IF po_log.d_proc THEN
156: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
157: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
158: END IF;
159: EXCEPTION
160: WHEN OTHERS THEN

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

153: END LOOP;
154:
155: IF po_log.d_proc THEN
156: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
157: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
158: END IF;
159: EXCEPTION
160: WHEN OTHERS THEN
161: IF po_log.d_exc THEN

Line 161: IF po_log.d_exc THEN

157: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
158: END IF;
159: EXCEPTION
160: WHEN OTHERS THEN
161: IF po_log.d_exc THEN
162: po_log.exc(d_mod, 0, NULL);
163: END IF;
164:
165: RAISE;

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

158: END IF;
159: EXCEPTION
160: WHEN OTHERS THEN
161: IF po_log.d_exc THEN
162: po_log.exc(d_mod, 0, NULL);
163: END IF;
164:
165: RAISE;
166: END quantity_ordered;

Line 187: IF po_log.d_proc THEN

183: END IF;
184:
185: x_result_type := po_validations.c_result_type_success;
186:
187: IF po_log.d_proc THEN
188: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
189: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
190: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
191: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

184:
185: x_result_type := po_validations.c_result_type_success;
186:
187: IF po_log.d_proc THEN
188: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
189: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
190: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
191: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
192: END IF;

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

185: x_result_type := po_validations.c_result_type_success;
186:
187: IF po_log.d_proc THEN
188: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
189: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
190: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
191: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
192: END IF;
193:

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

186:
187: IF po_log.d_proc THEN
188: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
189: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
190: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
191: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
192: END IF;
193:
194: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

187: IF po_log.d_proc THEN
188: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
189: po_log.proc_begin(d_mod, 'p_dest_org_id_tbl', p_dest_org_id_tbl);
190: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
191: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
192: END IF;
193:
194: FOR i IN 1 .. p_id_tbl.COUNT LOOP
195: IF (NVL(p_dest_org_id_tbl(i), -11) <> NVL(p_ship_to_org_id_tbl(i), -99)) THEN

Line 207: IF po_log.d_proc THEN

203: x_result_type := po_validations.c_result_type_failure;
204: END IF;
205: END LOOP;
206:
207: IF po_log.d_proc THEN
208: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
209: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
210: END IF;
211: EXCEPTION

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

204: END IF;
205: END LOOP;
206:
207: IF po_log.d_proc THEN
208: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
209: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
210: END IF;
211: EXCEPTION
212: WHEN OTHERS THEN

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

205: END LOOP;
206:
207: IF po_log.d_proc THEN
208: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
209: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
210: END IF;
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF po_log.d_exc THEN

Line 213: IF po_log.d_exc THEN

209: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
210: END IF;
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF po_log.d_exc THEN
214: po_log.exc(d_mod, 0, NULL);
215: END IF;
216:
217: RAISE;

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

210: END IF;
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF po_log.d_exc THEN
214: po_log.exc(d_mod, 0, NULL);
215: END IF;
216:
217: RAISE;
218: END destination_org_id;

Line 240: IF po_log.d_proc THEN

236: END IF;
237:
238: x_result_type := po_validations.c_result_type_success;
239:
240: IF po_log.d_proc THEN
241: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
242: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
243: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
244: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

237:
238: x_result_type := po_validations.c_result_type_success;
239:
240: IF po_log.d_proc THEN
241: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
242: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
243: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
244: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
245: END IF;

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

238: x_result_type := po_validations.c_result_type_success;
239:
240: IF po_log.d_proc THEN
241: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
242: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
243: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
244: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
245: END IF;
246:

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

239:
240: IF po_log.d_proc THEN
241: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
242: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
243: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
244: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
245: END IF;
246:
247: FORALL i IN 1 .. p_id_tbl.COUNT

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

240: IF po_log.d_proc THEN
241: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
242: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
243: po_log.proc_begin(d_mod, 'p_deliver_to_location_id_tbl', p_deliver_to_location_id_tbl);
244: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
245: END IF;
246:
247: FORALL i IN 1 .. p_id_tbl.COUNT
248: INSERT INTO po_validation_results_gt

Line 285: IF po_log.d_proc THEN

281: IF (SQL%ROWCOUNT > 0) THEN
282: x_result_type := po_validations.c_result_type_failure;
283: END IF;
284:
285: IF po_log.d_proc THEN
286: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
287: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
288: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
289: END IF;

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

283: END IF;
284:
285: IF po_log.d_proc THEN
286: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
287: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
288: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
289: END IF;
290: EXCEPTION
291: WHEN OTHERS THEN

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

284:
285: IF po_log.d_proc THEN
286: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
287: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
288: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
289: END IF;
290: EXCEPTION
291: WHEN OTHERS THEN
292: IF po_log.d_exc THEN

Line 292: IF po_log.d_exc THEN

288: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
289: END IF;
290: EXCEPTION
291: WHEN OTHERS THEN
292: IF po_log.d_exc THEN
293: po_log.exc(d_mod, 0, NULL);
294: END IF;
295:
296: RAISE;

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

289: END IF;
290: EXCEPTION
291: WHEN OTHERS THEN
292: IF po_log.d_exc THEN
293: po_log.exc(d_mod, 0, NULL);
294: END IF;
295:
296: RAISE;
297: END deliver_to_location_id;

Line 326: IF po_log.d_proc THEN

322: END IF;
323:
324: x_result_type := po_validations.c_result_type_success;
325:
326: IF po_log.d_proc THEN
327: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
328: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
329: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
330: END IF;

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

323:
324: x_result_type := po_validations.c_result_type_success;
325:
326: IF po_log.d_proc THEN
327: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
328: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
329: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
330: END IF;
331:

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

324: x_result_type := po_validations.c_result_type_success;
325:
326: IF po_log.d_proc THEN
327: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
328: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
329: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
330: END IF;
331:
332: d_position := 10;

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

325:
326: IF po_log.d_proc THEN
327: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
328: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
329: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
330: END IF;
331:
332: d_position := 10;
333:

Line 353: IF (PO_LOG.d_stmt) THEN

349: ELSE
350: l_assignment_type := 'E';
351: END IF;
352:
353: IF (PO_LOG.d_stmt) THEN
354: PO_LOG.stmt(d_mod, d_position, 'l_fsp_business_group_id', l_fsp_business_group_id);
355: PO_LOG.stmt(d_mod, d_position, 'l_assignment_type', l_assignment_type);
356: END IF;
357:

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

350: l_assignment_type := 'E';
351: END IF;
352:
353: IF (PO_LOG.d_stmt) THEN
354: PO_LOG.stmt(d_mod, d_position, 'l_fsp_business_group_id', l_fsp_business_group_id);
355: PO_LOG.stmt(d_mod, d_position, 'l_assignment_type', l_assignment_type);
356: END IF;
357:
358: d_position := 20;

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

351: END IF;
352:
353: IF (PO_LOG.d_stmt) THEN
354: PO_LOG.stmt(d_mod, d_position, 'l_fsp_business_group_id', l_fsp_business_group_id);
355: PO_LOG.stmt(d_mod, d_position, 'l_assignment_type', l_assignment_type);
356: END IF;
357:
358: d_position := 20;
359:

Line 403: IF po_log.d_proc THEN

399: IF (SQL%ROWCOUNT > 0) THEN
400: x_result_type := po_validations.c_result_type_failure;
401: END IF;
402:
403: IF po_log.d_proc THEN
404: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
405: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
406: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
407: END IF;

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

401: END IF;
402:
403: IF po_log.d_proc THEN
404: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
405: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
406: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
407: END IF;
408: EXCEPTION
409: WHEN OTHERS THEN

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

402:
403: IF po_log.d_proc THEN
404: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
405: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
406: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
407: END IF;
408: EXCEPTION
409: WHEN OTHERS THEN
410: IF po_log.d_exc THEN

Line 410: IF po_log.d_exc THEN

406: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
407: END IF;
408: EXCEPTION
409: WHEN OTHERS THEN
410: IF po_log.d_exc THEN
411: po_log.exc(d_mod, 0, NULL);
412: END IF;
413:
414: RAISE;

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

407: END IF;
408: EXCEPTION
409: WHEN OTHERS THEN
410: IF po_log.d_exc THEN
411: po_log.exc(d_mod, 0, NULL);
412: END IF;
413:
414: RAISE;
415: END deliver_to_person_id;

Line 483: IF po_log.d_proc THEN

479: x_result_type := po_validations.c_result_type_success;
480:
481: d_position := 10;
482:
483: IF po_log.d_proc THEN
484: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
485: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
486: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
487: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);

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

480:
481: d_position := 10;
482:
483: IF po_log.d_proc THEN
484: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
485: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
486: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
487: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
488: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);

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

481: d_position := 10;
482:
483: IF po_log.d_proc THEN
484: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
485: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
486: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
487: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
488: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
489: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);

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

482:
483: IF po_log.d_proc THEN
484: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
485: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
486: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
487: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
488: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
489: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
490: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);

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

483: IF po_log.d_proc THEN
484: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
485: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
486: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
487: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
488: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
489: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
490: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
491: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);

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

484: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
485: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
486: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
487: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
488: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
489: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
490: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
491: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
492: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);

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

485: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
486: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
487: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
488: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
489: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
490: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
491: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
492: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
493: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

486: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
487: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
488: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
489: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
490: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
491: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
492: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
493: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
494: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

487: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
488: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
489: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
490: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
491: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
492: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
493: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
494: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
495: END IF;

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

488: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
489: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
490: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
491: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
492: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
493: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
494: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
495: END IF;
496:

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

489: po_log.proc_begin(d_mod, 'p_accrue_on_receipt_flag_tbl', p_accrue_on_receipt_flag_tbl);
490: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
491: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
492: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
493: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
494: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
495: END IF;
496:
497: d_position := 20;

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

490: po_log.proc_begin(d_mod, 'p_expense_accrual_code', p_expense_accrual_code);
491: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly_tbl', p_loc_outsourced_assembly_tbl);
492: po_log.proc_begin(d_mod, 'p_value_basis_tbl', p_value_basis_tbl);
493: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
494: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
495: END IF;
496:
497: d_position := 20;
498:

Line 559: IF (PO_LOG.d_stmt) THEN

555: l_item_status_tbl.extend(p_id_tbl.COUNT);
556:
557: FOR i IN 1..l_index_tbl.COUNT
558: LOOP
559: IF (PO_LOG.d_stmt) THEN
560: PO_LOG.stmt(d_mod, d_position, 'index', l_index_tbl(i));
561: PO_LOG.stmt(d_mod, d_position, 'new item_status', l_result_tbl(i));
562: END IF;
563:

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

556:
557: FOR i IN 1..l_index_tbl.COUNT
558: LOOP
559: IF (PO_LOG.d_stmt) THEN
560: PO_LOG.stmt(d_mod, d_position, 'index', l_index_tbl(i));
561: PO_LOG.stmt(d_mod, d_position, 'new item_status', l_result_tbl(i));
562: END IF;
563:
564: l_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);

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

557: FOR i IN 1..l_index_tbl.COUNT
558: LOOP
559: IF (PO_LOG.d_stmt) THEN
560: PO_LOG.stmt(d_mod, d_position, 'index', l_index_tbl(i));
561: PO_LOG.stmt(d_mod, d_position, 'new item_status', l_result_tbl(i));
562: END IF;
563:
564: l_item_status_tbl(l_index_tbl(i)) := l_result_tbl(i);
565: END LOOP;

Line 574: IF po_log.d_proc THEN

570: l_item_status_tbl(i) := 'D';
571: END IF;
572: END LOOP;
573:
574: IF po_log.d_proc THEN
575: po_log.proc_begin(d_mod, 'l_item_status_tbl', l_item_status_tbl);
576: END IF;
577:
578: d_position := 70;

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

571: END IF;
572: END LOOP;
573:
574: IF po_log.d_proc THEN
575: po_log.proc_begin(d_mod, 'l_item_status_tbl', l_item_status_tbl);
576: END IF;
577:
578: d_position := 70;
579:

Line 634: IF po_log.d_proc THEN

630: END IF;
631:
632: d_position := 80;
633:
634: IF po_log.d_proc THEN
635: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
636: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
637: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
638: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

632: d_position := 80;
633:
634: IF po_log.d_proc THEN
635: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
636: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
637: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
638: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
639: END IF;
640: EXCEPTION

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

633:
634: IF po_log.d_proc THEN
635: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
636: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
637: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
638: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
639: END IF;
640: EXCEPTION
641: WHEN OTHERS THEN

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

634: IF po_log.d_proc THEN
635: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
636: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
637: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
638: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
639: END IF;
640: EXCEPTION
641: WHEN OTHERS THEN
642: IF po_log.d_exc THEN

Line 642: IF po_log.d_exc THEN

638: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
639: END IF;
640: EXCEPTION
641: WHEN OTHERS THEN
642: IF po_log.d_exc THEN
643: po_log.exc(d_mod, d_position, NULL);
644: END IF;
645:
646: RAISE;

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

639: END IF;
640: EXCEPTION
641: WHEN OTHERS THEN
642: IF po_log.d_exc THEN
643: po_log.exc(d_mod, d_position, NULL);
644: END IF;
645:
646: RAISE;
647: END destination_type_code;

Line 680: IF po_log.d_proc THEN

676: END IF;
677:
678: x_result_type := po_validations.c_result_type_success;
679:
680: IF po_log.d_proc THEN
681: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
682: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
683: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
684: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);

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

677:
678: x_result_type := po_validations.c_result_type_success;
679:
680: IF po_log.d_proc THEN
681: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
682: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
683: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
684: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
685: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);

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

678: x_result_type := po_validations.c_result_type_success;
679:
680: IF po_log.d_proc THEN
681: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
682: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
683: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
684: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
685: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
686: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);

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

679:
680: IF po_log.d_proc THEN
681: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
682: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
683: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
684: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
685: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
686: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
687: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

680: IF po_log.d_proc THEN
681: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
682: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
683: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
684: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
685: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
686: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
687: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
688: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

681: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
682: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
683: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
684: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
685: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
686: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
687: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
688: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
689: END IF;

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

682: po_log.proc_begin(d_mod, 'p_destination_subinv_tbl', p_destination_subinv_tbl);
683: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
684: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
685: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
686: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
687: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
688: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
689: END IF;
690:

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

683: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
684: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
685: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
686: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
687: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
688: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
689: END IF;
690:
691: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

684: po_log.proc_begin(d_mod, 'p_item_id_tbl', p_item_id_tbl);
685: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
686: po_log.proc_begin(d_mod, 'p_loc_outsourced_assembly', p_loc_outsourced_assembly_tbl);
687: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
688: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
689: END IF;
690:
691: FOR i IN 1 .. p_id_tbl.COUNT LOOP
692: IF (p_dest_type_code_tbl(i) IN('SHOP FLOOR', 'EXPENSE') AND p_destination_subinv_tbl(i) IS NOT NULL) THEN

Line 789: IF po_log.d_proc THEN

785: IF (SQL%ROWCOUNT > 0) THEN
786: x_result_type := po_validations.c_result_type_failure;
787: END IF;
788:
789: IF po_log.d_proc THEN
790: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
791: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
792: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
793: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

787: END IF;
788:
789: IF po_log.d_proc THEN
790: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
791: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
792: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
793: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
794: END IF;
795: EXCEPTION

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

788:
789: IF po_log.d_proc THEN
790: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
791: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
792: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
793: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
794: END IF;
795: EXCEPTION
796: WHEN OTHERS THEN

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

789: IF po_log.d_proc THEN
790: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
791: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
792: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
793: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
794: END IF;
795: EXCEPTION
796: WHEN OTHERS THEN
797: IF po_log.d_exc THEN

Line 797: IF po_log.d_exc THEN

793: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
794: END IF;
795: EXCEPTION
796: WHEN OTHERS THEN
797: IF po_log.d_exc THEN
798: po_log.exc(d_mod, 0, NULL);
799: END IF;
800:
801: RAISE;

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

794: END IF;
795: EXCEPTION
796: WHEN OTHERS THEN
797: IF po_log.d_exc THEN
798: po_log.exc(d_mod, 0, NULL);
799: END IF;
800:
801: RAISE;
802: END destination_subinv;

Line 841: IF po_log.d_proc THEN

837: END IF;
838:
839: x_result_type := po_validations.c_result_type_success;
840:
841: IF po_log.d_proc THEN
842: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
843: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
844: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
845: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

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

838:
839: x_result_type := po_validations.c_result_type_success;
840:
841: IF po_log.d_proc THEN
842: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
843: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
844: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
845: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
846: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);

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

839: x_result_type := po_validations.c_result_type_success;
840:
841: IF po_log.d_proc THEN
842: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
843: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
844: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
845: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
846: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
847: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

840:
841: IF po_log.d_proc THEN
842: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
843: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
844: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
845: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
846: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
847: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
848: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

841: IF po_log.d_proc THEN
842: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
843: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
844: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
845: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
846: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
847: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
848: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
849: END IF;

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

842: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
843: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
844: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
845: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
846: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
847: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
848: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
849: END IF;
850:

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

843: po_log.proc_begin(d_mod, 'p_wip_entity_id_tbl', p_wip_entity_id_tbl);
844: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
845: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
846: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
847: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
848: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
849: END IF;
850:
851: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

844: po_log.proc_begin(d_mod, 'p_wip_rep_schedule_id_tbl', p_wip_rep_schedule_id_tbl);
845: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
846: po_log.proc_begin(d_mod, 'p_destination_org_id_tbl', p_destination_org_id_tbl);
847: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
848: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
849: END IF;
850:
851: FOR i IN 1 .. p_id_tbl.COUNT LOOP
852: IF (p_dest_type_code_tbl(i) = 'SHOP FLOOR' AND p_wip_entity_id_tbl(i) IS NULL) THEN

Line 935: IF po_log.d_proc THEN

931: IF (SQL%ROWCOUNT > 0) THEN
932: x_result_type := po_validations.c_result_type_failure;
933: END IF;
934:
935: IF po_log.d_proc THEN
936: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
938: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
939: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

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

933: END IF;
934:
935: IF po_log.d_proc THEN
936: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
938: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
939: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
940: END IF;
941: EXCEPTION

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

934:
935: IF po_log.d_proc THEN
936: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
938: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
939: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
940: END IF;
941: EXCEPTION
942: WHEN OTHERS THEN

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

935: IF po_log.d_proc THEN
936: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
937: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
938: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
939: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
940: END IF;
941: EXCEPTION
942: WHEN OTHERS THEN
943: IF po_log.d_exc THEN

Line 943: IF po_log.d_exc THEN

939: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
940: END IF;
941: EXCEPTION
942: WHEN OTHERS THEN
943: IF po_log.d_exc THEN
944: po_log.exc(d_mod, 0, NULL);
945: END IF;
946:
947: RAISE;

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

940: END IF;
941: EXCEPTION
942: WHEN OTHERS THEN
943: IF po_log.d_exc THEN
944: po_log.exc(d_mod, 0, NULL);
945: END IF;
946:
947: RAISE;
948: END wip_entity_id;

Line 973: IF po_log.d_proc THEN

969: END IF;
970:
971: x_result_type := po_validations.c_result_type_success;
972:
973: IF po_log.d_proc THEN
974: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
975: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
976: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
977: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project

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

970:
971: x_result_type := po_validations.c_result_type_success;
972:
973: IF po_log.d_proc THEN
974: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
975: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
976: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
977: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
978: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

971: x_result_type := po_validations.c_result_type_success;
972:
973: IF po_log.d_proc THEN
974: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
975: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
976: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
977: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
978: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
979: END IF;

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

972:
973: IF po_log.d_proc THEN
974: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
975: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
976: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
977: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
978: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
979: END IF;
980:

Line 977: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project

973: IF po_log.d_proc THEN
974: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
975: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
976: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
977: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
978: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
979: END IF;
980:
981: /* For Encumbrance Project - To enable Encumbrance for Destination type - Shop Floor and WIP entity type - EAM

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

974: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
975: po_log.proc_begin(d_mod, 'p_prevent_encum_flag_tbl', p_prevent_encum_flag_tbl);
976: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
977: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
978: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
979: END IF;
980:
981: /* For Encumbrance Project - To enable Encumbrance for Destination type - Shop Floor and WIP entity type - EAM
982: Retriving entity_type and Setting the prevent_encumbrance_flag to 'Y' if destination type = shop floor

Line 1011: IF po_log.d_proc THEN

1007: x_result_type := po_validations.c_result_type_failure;
1008: END IF;
1009: END LOOP;
1010:
1011: IF po_log.d_proc THEN
1012: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1013: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1014: END IF;
1015: EXCEPTION

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

1008: END IF;
1009: END LOOP;
1010:
1011: IF po_log.d_proc THEN
1012: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1013: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1014: END IF;
1015: EXCEPTION
1016: WHEN OTHERS THEN

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

1009: END LOOP;
1010:
1011: IF po_log.d_proc THEN
1012: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1013: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1014: END IF;
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: IF po_log.d_exc THEN

Line 1017: IF po_log.d_exc THEN

1013: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1014: END IF;
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: IF po_log.d_exc THEN
1018: po_log.exc(d_mod, 0, NULL);
1019: END IF;
1020:
1021: RAISE;

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

1014: END IF;
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: IF po_log.d_exc THEN
1018: po_log.exc(d_mod, 0, NULL);
1019: END IF;
1020:
1021: RAISE;
1022: END prevent_encumbrance_flag;

Line 1045: IF po_log.d_proc THEN

1041: END IF;
1042:
1043: x_result_type := po_validations.c_result_type_success;
1044:
1045: IF po_log.d_proc THEN
1046: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1048: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1049: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);

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

1042:
1043: x_result_type := po_validations.c_result_type_success;
1044:
1045: IF po_log.d_proc THEN
1046: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1048: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1049: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1050: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

1043: x_result_type := po_validations.c_result_type_success;
1044:
1045: IF po_log.d_proc THEN
1046: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1048: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1049: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1050: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1051: END IF;

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

1044:
1045: IF po_log.d_proc THEN
1046: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1048: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1049: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1050: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1051: END IF;
1052:

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

1045: IF po_log.d_proc THEN
1046: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1048: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1049: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1050: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1051: END IF;
1052:
1053: FORALL i IN 1 .. p_id_tbl.COUNT

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

1046: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1047: po_log.proc_begin(d_mod, 'p_charge_account_id_tbl', p_charge_account_id_tbl);
1048: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1049: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1050: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1051: END IF;
1052:
1053: FORALL i IN 1 .. p_id_tbl.COUNT
1054: INSERT INTO po_validation_results_gt

Line 1093: IF po_log.d_proc THEN

1089: IF (SQL%ROWCOUNT > 0) THEN
1090: x_result_type := po_validations.c_result_type_failure;
1091: END IF;
1092:
1093: IF po_log.d_proc THEN
1094: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1095: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1096: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1097: END IF;

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

1091: END IF;
1092:
1093: IF po_log.d_proc THEN
1094: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1095: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1096: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1097: END IF;
1098: EXCEPTION
1099: WHEN OTHERS THEN

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

1092:
1093: IF po_log.d_proc THEN
1094: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1095: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1096: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1097: END IF;
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: IF po_log.d_exc THEN

Line 1100: IF po_log.d_exc THEN

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

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

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

Line 1134: IF po_log.d_proc THEN

1130: END IF;
1131:
1132: x_result_type := po_validations.c_result_type_success;
1133:
1134: IF po_log.d_proc THEN
1135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1136: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1137: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1138: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);

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

1131:
1132: x_result_type := po_validations.c_result_type_success;
1133:
1134: IF po_log.d_proc THEN
1135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1136: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1137: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1138: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1139: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project

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

1132: x_result_type := po_validations.c_result_type_success;
1133:
1134: IF po_log.d_proc THEN
1135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1136: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1137: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1138: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1139: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
1140: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);

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

1133:
1134: IF po_log.d_proc THEN
1135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1136: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1137: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1138: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1139: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
1140: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1141: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);

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

1134: IF po_log.d_proc THEN
1135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1136: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1137: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1138: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1139: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
1140: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1141: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1142: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

Line 1139: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project

1135: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1136: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1137: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1138: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1139: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
1140: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1141: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1142: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1143: END IF;

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

1136: po_log.proc_begin(d_mod, 'p_budget_account_id_tbl', p_budget_account_id_tbl);
1137: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1138: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1139: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
1140: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1141: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1142: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1143: END IF;
1144:

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

1137: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1138: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1139: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
1140: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1141: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1142: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1143: END IF;
1144:
1145: -- bug 4899825: add checking on destination_type_code when

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

1138: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1139: po_log.proc_begin(d_mod, 'p_distribution_type_tbl', p_distribution_type_tbl); -- PDOI for Complex PO Project
1140: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1141: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1142: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1143: END IF;
1144:
1145: -- bug 4899825: add checking on destination_type_code when
1146: -- budget_account_id is empty; If destination_

Line 1194: IF po_log.d_proc THEN

1190: IF (SQL%ROWCOUNT > 0) THEN
1191: x_result_type := po_validations.c_result_type_failure;
1192: END IF;
1193:
1194: IF po_log.d_proc THEN
1195: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1196: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1197: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1198: END IF;

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

1192: END IF;
1193:
1194: IF po_log.d_proc THEN
1195: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1196: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1197: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1198: END IF;
1199: EXCEPTION
1200: WHEN OTHERS THEN

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

1193:
1194: IF po_log.d_proc THEN
1195: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
1196: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1197: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1198: END IF;
1199: EXCEPTION
1200: WHEN OTHERS THEN
1201: IF po_log.d_exc THEN

Line 1201: IF po_log.d_exc THEN

1197: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
1198: END IF;
1199: EXCEPTION
1200: WHEN OTHERS THEN
1201: IF po_log.d_exc THEN
1202: po_log.exc(d_mod, 0, NULL);
1203: END IF;
1204:
1205: RAISE;

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

1198: END IF;
1199: EXCEPTION
1200: WHEN OTHERS THEN
1201: IF po_log.d_exc THEN
1202: po_log.exc(d_mod, 0, NULL);
1203: END IF;
1204:
1205: RAISE;
1206: END budget_account_id;

Line 1232: IF po_log.d_proc THEN

1228: END IF;
1229:
1230: x_result_type := po_validations.c_result_type_success;
1231:
1232: IF po_log.d_proc THEN
1233: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1234: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1235: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1236: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);

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

1229:
1230: x_result_type := po_validations.c_result_type_success;
1231:
1232: IF po_log.d_proc THEN
1233: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1234: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1235: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1236: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1237: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);

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

1230: x_result_type := po_validations.c_result_type_success;
1231:
1232: IF po_log.d_proc THEN
1233: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1234: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1235: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1236: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1237: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1238: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);

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

1231:
1232: IF po_log.d_proc THEN
1233: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1234: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1235: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1236: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1237: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1238: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1239: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);

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

1232: IF po_log.d_proc THEN
1233: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1234: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1235: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1236: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1237: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1238: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1239: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1240: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);

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

1233: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1234: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1235: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1236: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1237: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1238: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1239: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1240: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1241: END IF;

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

1234: po_log.proc_begin(d_mod, 'p_account_id_tbl', p_account_id_tbl);
1235: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1236: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1237: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1238: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1239: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1240: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1241: END IF;
1242:

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

1235: po_log.proc_begin(d_mod, 'p_gl_date_tbl', p_gl_date_tbl);
1236: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1237: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1238: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1239: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1240: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1241: END IF;
1242:
1243: FORALL i IN 1 .. p_id_tbl.COUNT

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

1236: po_log.proc_begin(d_mod, 'p_chart_of_account_id', p_chart_of_account_id);
1237: po_log.proc_begin(d_mod, 'p_message_name', p_message_name);
1238: po_log.proc_begin(d_mod, 'p_column_name', p_column_name);
1239: po_log.proc_begin(d_mod, 'p_token_name', p_token_name);
1240: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1241: END IF;
1242:
1243: FORALL i IN 1 .. p_id_tbl.COUNT
1244: INSERT INTO po_validation_results_gt

Line 1282: IF po_log.d_proc THEN

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

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

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

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

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

Line 1289: IF po_log.d_exc THEN

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

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

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

Line 1319: IF po_log.d_proc THEN

1315: END IF;
1316:
1317: x_result_type := po_validations.c_result_type_success;
1318:
1319: IF po_log.d_proc THEN
1320: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1321: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1322: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1323: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);

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

1316:
1317: x_result_type := po_validations.c_result_type_success;
1318:
1319: IF po_log.d_proc THEN
1320: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1321: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1322: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1323: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1324: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);

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

1317: x_result_type := po_validations.c_result_type_success;
1318:
1319: IF po_log.d_proc THEN
1320: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1321: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1322: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1323: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1324: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1325: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);

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

1318:
1319: IF po_log.d_proc THEN
1320: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1321: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1322: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1323: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1324: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1325: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1326: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1319: IF po_log.d_proc THEN
1320: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1321: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1322: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1323: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1324: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1325: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1326: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1327: END IF;

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

1320: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1321: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1322: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1323: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1324: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1325: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1326: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1327: END IF;
1328:

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

1321: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1322: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1323: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1324: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1325: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1326: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1327: END IF;
1328:
1329: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

1322: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1323: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1324: po_log.proc_begin(d_mod, 'p_exp_type_tbl', p_exp_type_tbl);
1325: po_log.proc_begin(d_mod, 'p_exp_org_id_tbl', p_exp_org_id_tbl);
1326: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1327: END IF;
1328:
1329: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1330: IF ( (p_project_acct_ctx_tbl(i) IS NULL OR p_project_acct_ctx_tbl(i) = 'N')

Line 1344: IF po_log.d_proc THEN

1340: x_result_type := po_validations.c_result_type_failure;
1341: END IF;
1342: END LOOP;
1343:
1344: IF po_log.d_proc THEN
1345: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1346: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1347: END IF;
1348: EXCEPTION

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

1341: END IF;
1342: END LOOP;
1343:
1344: IF po_log.d_proc THEN
1345: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1346: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1347: END IF;
1348: EXCEPTION
1349: WHEN OTHERS THEN

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

1342: END LOOP;
1343:
1344: IF po_log.d_proc THEN
1345: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1346: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1347: END IF;
1348: EXCEPTION
1349: WHEN OTHERS THEN
1350: IF po_log.d_exc THEN

Line 1350: IF po_log.d_exc THEN

1346: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1347: END IF;
1348: EXCEPTION
1349: WHEN OTHERS THEN
1350: IF po_log.d_exc THEN
1351: po_log.exc(d_mod, 0, NULL);
1352: END IF;
1353:
1354: RAISE;

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

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

Line 1401: IF po_log.d_proc THEN

1397: END IF;
1398:
1399: x_result_type := po_validations.c_result_type_success;
1400:
1401: IF po_log.d_proc THEN
1402: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1403: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1404: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1405: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);

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

1398:
1399: x_result_type := po_validations.c_result_type_success;
1400:
1401: IF po_log.d_proc THEN
1402: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1403: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1404: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1405: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1406: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);

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

1399: x_result_type := po_validations.c_result_type_success;
1400:
1401: IF po_log.d_proc THEN
1402: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1403: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1404: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1405: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1406: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1407: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);

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

1400:
1401: IF po_log.d_proc THEN
1402: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1403: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1404: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1405: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1406: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1407: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1408: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);

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

1401: IF po_log.d_proc THEN
1402: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1403: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1404: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1405: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1406: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1407: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1408: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1409: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);

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

1402: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1403: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1404: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1405: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1406: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1407: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1408: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1409: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1410: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);

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

1403: po_log.proc_begin(d_mod, 'p_project_acct_ctx_tbl', p_project_acct_ctx_tbl);
1404: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1405: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1406: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1407: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1408: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1409: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1410: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1411: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);

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

1404: po_log.proc_begin(d_mod, 'p_dest_type_code_tbl', p_dest_type_code_tbl);
1405: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1406: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1407: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1408: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1409: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1410: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1411: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1412: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);

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

1405: po_log.proc_begin(d_mod, 'p_project_id_tbl', p_project_id_tbl);
1406: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1407: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1408: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1409: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1410: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1411: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1412: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1413: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);

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

1406: po_log.proc_begin(d_mod, 'p_task_id_tbl', p_task_id_tbl);
1407: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1408: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1409: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1410: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1411: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1412: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1413: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1414: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);

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

1407: po_log.proc_begin(d_mod, 'p_expenditure_type_tbl', p_expenditure_type_tbl);
1408: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1409: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1410: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1411: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1412: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1413: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1414: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1415: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);

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

1408: po_log.proc_begin(d_mod, 'p_expenditure_org_id_tbl', p_expenditure_org_id_tbl);
1409: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1410: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1411: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1412: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1413: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1414: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1415: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1416: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);

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

1409: po_log.proc_begin(d_mod, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
1410: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1411: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1412: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1413: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1414: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1415: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1416: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1417: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1410: po_log.proc_begin(d_mod, 'p_need_by_date_tbl', p_need_by_date_tbl);
1411: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1412: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1413: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1414: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1415: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1416: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1417: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1418: END IF;

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

1411: po_log.proc_begin(d_mod, 'p_promised_date_tbl', p_promised_date_tbl);
1412: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1413: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1414: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1415: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1416: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1417: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1418: END IF;
1419:

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

1412: po_log.proc_begin(d_mod, 'p_expenditure_item_date_tbl', p_expenditure_item_date_tbl);
1413: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1414: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1415: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1416: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1417: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1418: END IF;
1419:
1420: FOR i IN 1 .. p_id_tbl.COUNT LOOP

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

1413: po_log.proc_begin(d_mod, 'p_ship_to_ou_id', p_ship_to_ou_id);
1414: po_log.proc_begin(d_mod, 'p_deliver_to_person_id_tbl', p_deliver_to_person_id_tbl);
1415: po_log.proc_begin(d_mod, 'p_agent_id_tbl', p_agent_id_tbl);
1416: po_log.proc_begin(d_mod, 'p_txn_flow_header_id_tbl', p_txn_flow_header_id_tbl);
1417: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1418: END IF;
1419:
1420: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1421: IF (p_project_acct_ctx_tbl(i) = 'Y') THEN

Line 1472: IF po_log.d_proc THEN

1468: x_result_type := po_validations.c_result_type_failure;
1469: END IF;
1470: END LOOP;
1471:
1472: IF po_log.d_proc THEN
1473: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1474: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1475: END IF;
1476: EXCEPTION

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

1469: END IF;
1470: END LOOP;
1471:
1472: IF po_log.d_proc THEN
1473: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1474: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1475: END IF;
1476: EXCEPTION
1477: WHEN OTHERS THEN

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

1470: END LOOP;
1471:
1472: IF po_log.d_proc THEN
1473: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1474: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1475: END IF;
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: IF po_log.d_exc THEN

Line 1478: IF po_log.d_exc THEN

1474: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1475: END IF;
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: IF po_log.d_exc THEN
1479: po_log.exc(d_mod, 0, NULL);
1480: END IF;
1481:
1482: RAISE;

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

1475: END IF;
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: IF po_log.d_exc THEN
1479: po_log.exc(d_mod, 0, NULL);
1480: END IF;
1481:
1482: RAISE;
1483: END project_info;

Line 1504: IF po_log.d_proc THEN

1500: END IF;
1501:
1502: x_result_type := po_validations.c_result_type_success;
1503:
1504: IF po_log.d_proc THEN
1505: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1506: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1507: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1508: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

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

1501:
1502: x_result_type := po_validations.c_result_type_success;
1503:
1504: IF po_log.d_proc THEN
1505: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1506: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1507: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1508: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1509: END IF;

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

1502: x_result_type := po_validations.c_result_type_success;
1503:
1504: IF po_log.d_proc THEN
1505: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1506: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1507: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1508: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1509: END IF;
1510:

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

1503:
1504: IF po_log.d_proc THEN
1505: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1506: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1507: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1508: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1509: END IF;
1510:
1511: IF (p_allow_tax_rate_override <> 'Y') THEN

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

1504: IF po_log.d_proc THEN
1505: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1506: po_log.proc_begin(d_mod, 'p_recovery_override_flag_tbl', p_recovery_override_flag_tbl);
1507: po_log.proc_begin(d_mod, 'p_allow_tax_rate_override', p_allow_tax_rate_override);
1508: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1509: END IF;
1510:
1511: IF (p_allow_tax_rate_override <> 'Y') THEN
1512: FOR i IN 1 .. p_id_tbl.COUNT LOOP

Line 1524: IF po_log.d_proc THEN

1520: END IF;
1521: END LOOP;
1522: END IF;
1523:
1524: IF po_log.d_proc THEN
1525: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1526: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1527: END IF;
1528: EXCEPTION

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

1521: END LOOP;
1522: END IF;
1523:
1524: IF po_log.d_proc THEN
1525: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1526: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1527: END IF;
1528: EXCEPTION
1529: WHEN OTHERS THEN

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

1522: END IF;
1523:
1524: IF po_log.d_proc THEN
1525: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1526: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1527: END IF;
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF po_log.d_exc THEN

Line 1530: IF po_log.d_exc THEN

1526: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1527: END IF;
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF po_log.d_exc THEN
1531: po_log.exc(d_mod, 0, NULL);
1532: END IF;
1533:
1534: RAISE;

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

1527: END IF;
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF po_log.d_exc THEN
1531: po_log.exc(d_mod, 0, NULL);
1532: END IF;
1533:
1534: RAISE;
1535: END tax_recovery_override_flag;

Line 1556: IF PO_LOG.d_proc THEN

1552: d_mod CONSTANT VARCHAR2(100) := d_ACRN_value_valid;
1553: l_is_ACRN_enabled VARCHAR2(1);
1554: l_org_id NUMBER;
1555: BEGIN
1556: IF PO_LOG.d_proc THEN
1557: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1558: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1559: PO_LOG.proc_begin(d_mod,'p_ACRN_tbl',p_ACRN_tbl);
1560: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1557: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);

1553: l_is_ACRN_enabled VARCHAR2(1);
1554: l_org_id NUMBER;
1555: BEGIN
1556: IF PO_LOG.d_proc THEN
1557: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1558: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1559: PO_LOG.proc_begin(d_mod,'p_ACRN_tbl',p_ACRN_tbl);
1560: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1561: END IF;

Line 1558: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);

1554: l_org_id NUMBER;
1555: BEGIN
1556: IF PO_LOG.d_proc THEN
1557: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1558: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1559: PO_LOG.proc_begin(d_mod,'p_ACRN_tbl',p_ACRN_tbl);
1560: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1561: END IF;
1562:

Line 1559: PO_LOG.proc_begin(d_mod,'p_ACRN_tbl',p_ACRN_tbl);

1555: BEGIN
1556: IF PO_LOG.d_proc THEN
1557: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1558: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1559: PO_LOG.proc_begin(d_mod,'p_ACRN_tbl',p_ACRN_tbl);
1560: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1561: END IF;
1562:
1563: IF (x_results IS NULL) THEN

Line 1560: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

1556: IF PO_LOG.d_proc THEN
1557: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1558: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1559: PO_LOG.proc_begin(d_mod,'p_ACRN_tbl',p_ACRN_tbl);
1560: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1561: END IF;
1562:
1563: IF (x_results IS NULL) THEN
1564: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1610: IF PO_LOG.d_proc THEN

1606:
1607: END LOOP;
1608:
1609:
1610: IF PO_LOG.d_proc THEN
1611: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1612: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1613: END IF;
1614:

Line 1611: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

1607: END LOOP;
1608:
1609:
1610: IF PO_LOG.d_proc THEN
1611: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1612: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1613: END IF;
1614:
1615: EXCEPTION

Line 1612: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);

1608:
1609:
1610: IF PO_LOG.d_proc THEN
1611: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1612: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1613: END IF;
1614:
1615: EXCEPTION
1616: WHEN OTHERS THEN

Line 1617: IF PO_LOG.d_exc THEN

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

Line 1618: PO_LOG.exc(d_mod,0,NULL);

1614:
1615: EXCEPTION
1616: WHEN OTHERS THEN
1617: IF PO_LOG.d_exc THEN
1618: PO_LOG.exc(d_mod,0,NULL);
1619: END IF;
1620: RAISE;
1621:
1622: END ACRN_value_valid;

Line 1657: IF po_log.d_proc THEN

1653: END IF;
1654:
1655: x_result_type := po_validations.c_result_type_success;
1656:
1657: IF po_log.d_proc THEN
1658: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1659: po_log.proc_begin(d_mod, 'p_partial_funded_flag_tbl', p_partial_funded_flag_tbl);
1660: po_log.proc_begin(d_mod, 'p_funded_value_tbl', p_funded_value_tbl);
1661: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);

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

1654:
1655: x_result_type := po_validations.c_result_type_success;
1656:
1657: IF po_log.d_proc THEN
1658: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1659: po_log.proc_begin(d_mod, 'p_partial_funded_flag_tbl', p_partial_funded_flag_tbl);
1660: po_log.proc_begin(d_mod, 'p_funded_value_tbl', p_funded_value_tbl);
1661: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1662: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);

Line 1659: po_log.proc_begin(d_mod, 'p_partial_funded_flag_tbl', p_partial_funded_flag_tbl);

1655: x_result_type := po_validations.c_result_type_success;
1656:
1657: IF po_log.d_proc THEN
1658: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1659: po_log.proc_begin(d_mod, 'p_partial_funded_flag_tbl', p_partial_funded_flag_tbl);
1660: po_log.proc_begin(d_mod, 'p_funded_value_tbl', p_funded_value_tbl);
1661: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1662: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1663: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);

Line 1660: po_log.proc_begin(d_mod, 'p_funded_value_tbl', p_funded_value_tbl);

1656:
1657: IF po_log.d_proc THEN
1658: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1659: po_log.proc_begin(d_mod, 'p_partial_funded_flag_tbl', p_partial_funded_flag_tbl);
1660: po_log.proc_begin(d_mod, 'p_funded_value_tbl', p_funded_value_tbl);
1661: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1662: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1663: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1664: END IF;

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

1657: IF po_log.d_proc THEN
1658: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1659: po_log.proc_begin(d_mod, 'p_partial_funded_flag_tbl', p_partial_funded_flag_tbl);
1660: po_log.proc_begin(d_mod, 'p_funded_value_tbl', p_funded_value_tbl);
1661: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1662: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1663: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1664: END IF;
1665:

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

1658: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
1659: po_log.proc_begin(d_mod, 'p_partial_funded_flag_tbl', p_partial_funded_flag_tbl);
1660: po_log.proc_begin(d_mod, 'p_funded_value_tbl', p_funded_value_tbl);
1661: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1662: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1663: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1664: END IF;
1665:
1666: d_position := 10;

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

1659: po_log.proc_begin(d_mod, 'p_partial_funded_flag_tbl', p_partial_funded_flag_tbl);
1660: po_log.proc_begin(d_mod, 'p_funded_value_tbl', p_funded_value_tbl);
1661: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
1662: po_log.proc_begin(d_mod, 'p_po_encumberance_flag', p_po_encumberance_flag);
1663: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1664: END IF;
1665:
1666: d_position := 10;
1667:

Line 1673: IF (PO_LOG.d_stmt) THEN

1669: IF (p_partial_funded_flag_tbl(i) = 'Y' AND p_po_encumberance_flag = 'N') THEN
1670:
1671: d_position := 20;
1672:
1673: IF (PO_LOG.d_stmt) THEN
1674: PO_LOG.stmt(d_mod, d_position, 'Purchase order Encumbrance for this Organization is not enabled');
1675: END IF;
1676: x_results.add_result(p_entity_type => c_entity_type_distribution,
1677: p_entity_id => p_id_tbl(i),

Line 1674: PO_LOG.stmt(d_mod, d_position, 'Purchase order Encumbrance for this Organization is not enabled');

1670:
1671: d_position := 20;
1672:
1673: IF (PO_LOG.d_stmt) THEN
1674: PO_LOG.stmt(d_mod, d_position, 'Purchase order Encumbrance for this Organization is not enabled');
1675: END IF;
1676: x_results.add_result(p_entity_type => c_entity_type_distribution,
1677: p_entity_id => p_id_tbl(i),
1678: p_column_name => 'PARTIAL_FUNDED_FLAG',

Line 1686: IF (PO_LOG.d_stmt) THEN

1682: ELSIF (p_partial_funded_flag_tbl(i) = 'Y' AND p_po_encumberance_flag = 'Y') THEN
1683:
1684: d_position := 30;
1685:
1686: IF (PO_LOG.d_stmt) THEN
1687: PO_LOG.stmt(d_mod, d_position, 'Check for CLM enabled Flag of Style Id');
1688: END IF;
1689:
1690: BEGIN

Line 1687: PO_LOG.stmt(d_mod, d_position, 'Check for CLM enabled Flag of Style Id');

1683:
1684: d_position := 30;
1685:
1686: IF (PO_LOG.d_stmt) THEN
1687: PO_LOG.stmt(d_mod, d_position, 'Check for CLM enabled Flag of Style Id');
1688: END IF;
1689:
1690: BEGIN
1691: SELECT Count(1) INTO style_id_exists

Line 1697: IF po_log.d_proc THEN

1693: WHERE style_id = Nvl(p_style_id_tbl(i),-1)
1694: AND Nvl(clm_flag,'N') = 'Y';
1695: EXCEPTION
1696: WHEN NO_DATA_FOUND THEN
1697: IF po_log.d_proc THEN
1698: po_log.proc_begin(d_mod, 'CLM Flag is not enabled for the Style ID ', p_style_id_tbl(i));
1699: END IF;
1700: END;
1701:

Line 1698: po_log.proc_begin(d_mod, 'CLM Flag is not enabled for the Style ID ', p_style_id_tbl(i));

1694: AND Nvl(clm_flag,'N') = 'Y';
1695: EXCEPTION
1696: WHEN NO_DATA_FOUND THEN
1697: IF po_log.d_proc THEN
1698: po_log.proc_begin(d_mod, 'CLM Flag is not enabled for the Style ID ', p_style_id_tbl(i));
1699: END IF;
1700: END;
1701:
1702: IF (style_id_exists = 0) THEN

Line 1712: IF po_log.d_proc THEN

1708: p_message_name => 'PO_PDOI_PF_FLAG_CLM');
1709: x_result_type := po_validations.c_result_type_failure;
1710: ELSIF (p_funded_value_tbl(i) < 0) THEN
1711: d_position := 50;
1712: IF po_log.d_proc THEN
1713: po_log.proc_begin(d_mod, 'Negative Funded Value ', p_funded_value_tbl(i));
1714: END IF;
1715: x_results.add_result(p_entity_type => c_entity_type_distribution,
1716: p_entity_id => p_id_tbl(i),

Line 1713: po_log.proc_begin(d_mod, 'Negative Funded Value ', p_funded_value_tbl(i));

1709: x_result_type := po_validations.c_result_type_failure;
1710: ELSIF (p_funded_value_tbl(i) < 0) THEN
1711: d_position := 50;
1712: IF po_log.d_proc THEN
1713: po_log.proc_begin(d_mod, 'Negative Funded Value ', p_funded_value_tbl(i));
1714: END IF;
1715: x_results.add_result(p_entity_type => c_entity_type_distribution,
1716: p_entity_id => p_id_tbl(i),
1717: p_column_name => 'PARTIAL_FUNDED_FLAG',

Line 1724: IF po_log.d_proc THEN

1720: x_result_type := po_validations.c_result_type_failure;
1721: END IF;
1722: END IF;
1723: END LOOP;
1724: IF po_log.d_proc THEN
1725: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1726: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1727: END IF;
1728: EXCEPTION

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

1721: END IF;
1722: END IF;
1723: END LOOP;
1724: IF po_log.d_proc THEN
1725: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1726: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1727: END IF;
1728: EXCEPTION
1729: WHEN OTHERS THEN

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

1722: END IF;
1723: END LOOP;
1724: IF po_log.d_proc THEN
1725: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1726: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1727: END IF;
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: IF po_log.d_exc THEN

Line 1730: IF po_log.d_exc THEN

1726: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1727: END IF;
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: IF po_log.d_exc THEN
1731: po_log.exc(d_mod, 0, NULL);
1732: END IF;
1733:
1734: RAISE;

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

1727: END IF;
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: IF po_log.d_exc THEN
1731: po_log.exc(d_mod, 0, NULL);
1732: END IF;
1733:
1734: RAISE;
1735: END partial_funded_flag;