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

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_LOG

Line 5: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_ATTRIBUTE_VALUES_PVT');

1: PACKAGE BODY PO_ATTRIBUTE_VALUES_PVT AS
2: /* $Header: PO_ATTRIBUTE_VALUES_PVT.plb 120.30.12010000.4 2008/11/24 05:34:03 rohbansa ship $ */
3:
4: -- The module base for this package.
5: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_ATTRIBUTE_VALUES_PVT');
6:
7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');

Line 8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');

4: -- The module base for this package.
5: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_ATTRIBUTE_VALUES_PVT');
6:
7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');

Line 9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');

5: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_ATTRIBUTE_VALUES_PVT');
6:
7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');

Line 10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');

6:
7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');

Line 11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');

7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');

Line 12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');

8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');

Line 13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');

9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');

Line 14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');

10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');

Line 15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');

11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');

Line 16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');

12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');

Line 17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');

13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');

Line 18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');

14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');

Line 19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');

15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');

Line 20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');

16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');

Line 21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');

17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');

Line 22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');

18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');

Line 23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');

19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');

Line 24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');

20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');

Line 25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');

21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');
29:

Line 26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');

22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');
29:
30: TYPE PO_TBL_VARCHAR4 IS TABLE OF VARCHAR2(4) INDEX BY pls_integer;

Line 27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');

23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');
29:
30: TYPE PO_TBL_VARCHAR4 IS TABLE OF VARCHAR2(4) INDEX BY pls_integer;
31: TYPE PO_TBL_VARCHAR480 IS TABLE OF VARCHAR2(480) INDEX BY pls_integer;

Line 28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');

24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');
29:
30: TYPE PO_TBL_VARCHAR4 IS TABLE OF VARCHAR2(4) INDEX BY pls_integer;
31: TYPE PO_TBL_VARCHAR480 IS TABLE OF VARCHAR2(480) INDEX BY pls_integer;
32:

Line 249: IF PO_LOG.d_proc THEN

245:
246: BEGIN
247: l_progress := '010';
248:
249: IF PO_LOG.d_proc THEN
250: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
251: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
252: PO_LOG.proc_begin(d_mod,'p_language',p_language);
253: END IF;

Line 250: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);

246: BEGIN
247: l_progress := '010';
248:
249: IF PO_LOG.d_proc THEN
250: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
251: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
252: PO_LOG.proc_begin(d_mod,'p_language',p_language);
253: END IF;
254:

Line 251: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

247: l_progress := '010';
248:
249: IF PO_LOG.d_proc THEN
250: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
251: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
252: PO_LOG.proc_begin(d_mod,'p_language',p_language);
253: END IF;
254:
255: -- If language is not passed in assume language of user session

Line 252: PO_LOG.proc_begin(d_mod,'p_language',p_language);

248:
249: IF PO_LOG.d_proc THEN
250: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
251: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
252: PO_LOG.proc_begin(d_mod,'p_language',p_language);
253: END IF;
254:
255: -- If language is not passed in assume language of user session
256: IF (p_language IS NULL) THEN

Line 270: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_base_descriptors.COUNT='||l_base_descriptors.COUNT); END IF;

266: FETCH descriptors_csr
267: BULK COLLECT INTO l_base_descriptors;
268: ClOSE descriptors_csr;
269:
270: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_base_descriptors.COUNT='||l_base_descriptors.COUNT); END IF;
271:
272: l_progress := '030';
273: -- fetch all translatable base descriptors information
274: -- base descriptors have rt_category_id as 0. Hence pass in 0

Line 280: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_base_descriptors_tlp.COUNT='||l_base_descriptors_tlp.COUNT); END IF;

276: FETCH descriptors_tlp_csr
277: BULK COLLECT INTO l_base_descriptors_tlp;
278: ClOSE descriptors_tlp_csr;
279:
280: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_base_descriptors_tlp.COUNT='||l_base_descriptors_tlp.COUNT); END IF;
281:
282: l_progress := '040';
283: -- if a specific PO header id is not passed in then
284: -- Sourcing is in the req to negotiation flow

Line 300: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_attr_values.COUNT='||l_attr_values.COUNT); END IF;

296: BULK COLLECT INTO l_attr_values;
297: CLOSE attr_values_csr;
298: END IF;
299:
300: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_attr_values.COUNT='||l_attr_values.COUNT); END IF;
301:
302: l_progress := '070';
303: --for each attribute value record for this header loop through
304: --and fetch base and category descriptor name, value and other

Line 334: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_cat_descriptors.COUNT='||l_cat_descriptors.COUNT); END IF;

330: FETCH descriptors_csr
331: BULK COLLECT INTO l_cat_descriptors;
332: ClOSE descriptors_csr;
333:
334: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_cat_descriptors.COUNT='||l_cat_descriptors.COUNT); END IF;
335:
336: l_progress := '130';
337: FOR j IN 1..l_cat_descriptors.COUNT --category descriptors
338: LOOP

Line 352: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'After set_attribute_values in loop'); END IF;

348: END LOOP; --category descriptors
349: END IF; --for each ip_category
350: END LOOP; --attribute values
351:
352: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'After set_attribute_values in loop'); END IF;
353:
354: l_progress := '160';
355: -- if a specific PO header id is not passed in then
356: -- Sourcing is in the req to negotiation flow

Line 372: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_attr_values_tlp.COUNT='||l_attr_values_tlp.COUNT); END IF;

368: BULK COLLECT INTO l_attr_values_tlp;
369: CLOSE attr_values_tlp_csr;
370: END IF;
371:
372: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_attr_values_tlp.COUNT='||l_attr_values_tlp.COUNT); END IF;
373:
374: l_progress := '190';
375: --for each attribute value tlp record for this header loop through
376: --and fetch base and category descriptor name, tlp value and other

Line 405: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_cat_descriptors_tlp.COUNT='||l_cat_descriptors_tlp.COUNT); END IF;

401: FETCH descriptors_tlp_csr
402: BULK COLLECT INTO l_cat_descriptors_tlp;
403: ClOSE descriptors_tlp_csr;
404:
405: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_cat_descriptors_tlp.COUNT='||l_cat_descriptors_tlp.COUNT); END IF;
406:
407: l_progress := '250';
408: FOR j IN 1..l_cat_descriptors_tlp.COUNT --category descriptors tlp
409: LOOP

Line 422: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'After set_attribute_values_tlp in loop'); END IF;

418: END LOOP; --category descriptors tlp
419: END IF; --for each ip_category
420: END LOOP; --attribute values tlp
421:
422: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'After set_attribute_values_tlp in loop'); END IF;
423:
424: l_progress := '280';
425: --insert data into pon_attributes_interface
426: FORALL i IN 1..l_pon_attributes.COUNT

Line 429: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PON_ATTRIBUTES_INTERFACE='||SQL%rowcount); END IF;

425: --insert data into pon_attributes_interface
426: FORALL i IN 1..l_pon_attributes.COUNT
427: INSERT INTO PON_ATTRIBUTES_INTERFACE VALUES l_pon_attributes(i);
428:
429: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PON_ATTRIBUTES_INTERFACE='||SQL%rowcount); END IF;
430:
431: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
432: EXCEPTION
433: WHEN OTHERS THEN

Line 431: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

427: INSERT INTO PON_ATTRIBUTES_INTERFACE VALUES l_pon_attributes(i);
428:
429: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PON_ATTRIBUTES_INTERFACE='||SQL%rowcount); END IF;
430:
431: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
432: EXCEPTION
433: WHEN OTHERS THEN
434: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
435: RAISE;

Line 434: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;

430:
431: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
432: EXCEPTION
433: WHEN OTHERS THEN
434: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
435: RAISE;
436: END handle_attributes;
437:
438: --------------------------------------------------------------------------------

Line 475: IF PO_LOG.d_proc THEN

471: l_progress VARCHAR2(4);
472: BEGIN
473: l_progress := '010';
474:
475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);

Line 476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);

472: BEGIN
473: l_progress := '010';
474:
475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);

Line 477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);

473: l_progress := '010';
474:
475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);

Line 478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);

474:
475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);

Line 479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);

475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
483: END IF;

Line 480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);

476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
483: END IF;
484:

Line 481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);

477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
483: END IF;
484:
485: --move data from descriptors and attribute values into x_pon_attributes

Line 482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);

478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
483: END IF;
484:
485: --move data from descriptors and attribute values into x_pon_attributes
486: x_pon_attributes.interface_line_number := x_attr_values.interface_line_number;

Line 502: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.datatype='||x_pon_attributes.datatype); END IF;

498: ELSIF (x_descriptors.type = 1) THEN
499: x_pon_attributes.datatype := 'NUM';
500: END IF;
501:
502: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.datatype='||x_pon_attributes.datatype); END IF;
503:
504: l_progress := '030';
505: IF (x_descriptors.stored_in_column = 'ATTACHMENT_URL') THEN
506: x_pon_attributes.value := x_attr_values.ATTACHMENT_URL;

Line 1157: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;

1153: ELSIF (x_descriptors.stored_in_column = 'UNSPSC') THEN
1154: x_pon_attributes.value := x_attr_values.UNSPSC;
1155: END IF;
1156:
1157: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;
1158:
1159: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1160: EXCEPTION
1161: WHEN OTHERS THEN

Line 1159: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

1155: END IF;
1156:
1157: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;
1158:
1159: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
1163: RAISE;

Line 1162: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;

1158:
1159: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
1163: RAISE;
1164: END set_attribute_values;
1165:
1166: --------------------------------------------------------------------------------

Line 1203: IF PO_LOG.d_proc THEN

1199: l_progress VARCHAR2(4);
1200: BEGIN
1201: l_progress := '010';
1202:
1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);

Line 1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);

1200: BEGIN
1201: l_progress := '010';
1202:
1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);

Line 1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);

1201: l_progress := '010';
1202:
1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);

Line 1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);

1202:
1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);

Line 1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);

1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1211: END IF;

Line 1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);

1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1211: END IF;
1212:

Line 1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);

1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1211: END IF;
1212:
1213: --move data from descriptors and attribute values into x_pon_attributes

Line 1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);

1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1211: END IF;
1212:
1213: --move data from descriptors and attribute values into x_pon_attributes
1214: x_pon_attributes.interface_line_number := x_attr_values_tlp.interface_line_number;

Line 1229: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.datatype='||x_pon_attributes.datatype); END IF;

1225: ELSIF (x_descriptors_tlp.type = 1) THEN
1226: x_pon_attributes.datatype := 'NUM';
1227: END IF;
1228:
1229: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.datatype='||x_pon_attributes.datatype); END IF;
1230:
1231: l_progress := '030';
1232: IF (x_descriptors_tlp.stored_in_column = 'ALIAS') THEN
1233: x_pon_attributes.value := x_attr_values_tlp.ALIAS;

Line 1578: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;

1574: ELSIF (x_descriptors_tlp.stored_in_column = 'TL_TEXT_CAT_ATTRIBUTE9') THEN
1575: x_pon_attributes.value := x_attr_values_tlp.TL_TEXT_CAT_ATTRIBUTE9;
1576: END IF;
1577:
1578: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;
1579:
1580: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN

Line 1580: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

1576: END IF;
1577:
1578: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;
1579:
1580: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
1584: RAISE;

Line 1583: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;

1579:
1580: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
1584: RAISE;
1585: END set_attribute_values_tlp;
1586:
1587: --------------------------------------------------------------------------------

Line 1619: IF PO_LOG.d_proc THEN

1615: l_progress VARCHAR2(4);
1616: BEGIN
1617: l_progress := '010';
1618:
1619: IF PO_LOG.d_proc THEN
1620: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
1621: END IF;
1622:
1623: l_progress := '020';

Line 1620: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);

1616: BEGIN
1617: l_progress := '010';
1618:
1619: IF PO_LOG.d_proc THEN
1620: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
1621: END IF;
1622:
1623: l_progress := '020';
1624: INSERT INTO PO_ATTRIBUTE_VALUES (

Line 2281: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PO_ATTRIBUTE_VALUES table='||SQL%rowcount); END IF;

2277: 'AUTOCREATE_BACKEND_FOR_SOURCING'
2278: FROM PO_ATTR_VALUES_INTERFACE
2279: WHERE interface_header_id = p_interface_header_id;
2280:
2281: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PO_ATTRIBUTE_VALUES table='||SQL%rowcount); END IF;
2282:
2283: l_progress := '030';
2284: --insert tlp records from interface table
2285: INSERT INTO PO_ATTRIBUTE_VALUES_TLP (

Line 2636: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PO_ATTRIBUTE_VALUES_TLP table='||SQL%rowcount); END IF;

2632: 'AUTOCREATE_BACKEND_FOR_SOURCING'
2633: FROM PO_ATTR_VALUES_TLP_INTERFACE
2634: WHERE interface_header_id = p_interface_header_id;
2635:
2636: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PO_ATTRIBUTE_VALUES_TLP table='||SQL%rowcount); END IF;
2637:
2638: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2639: EXCEPTION
2640: WHEN OTHERS THEN

Line 2638: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

2634: WHERE interface_header_id = p_interface_header_id;
2635:
2636: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PO_ATTRIBUTE_VALUES_TLP table='||SQL%rowcount); END IF;
2637:
2638: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2639: EXCEPTION
2640: WHEN OTHERS THEN
2641: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
2642: RAISE;

Line 2641: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;

2637:
2638: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2639: EXCEPTION
2640: WHEN OTHERS THEN
2641: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
2642: RAISE;
2643: END transfer_intf_item_attribs;
2644:
2645: --------------------------------------------------------------------------------

Line 2692: IF PO_LOG.d_proc THEN

2688: l_onetime_item_all_languages FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
2689: BEGIN
2690: l_progress := '010';
2691:
2692: IF PO_LOG.d_proc THEN
2693: PO_LOG.proc_begin(d_mod,'p_attr_values_tlp_id_list',p_attr_values_tlp_id_list);
2694: END IF;
2695:
2696: -- Get the profile value for "POR: Load One-Time Items in All Languages"

Line 2693: PO_LOG.proc_begin(d_mod,'p_attr_values_tlp_id_list',p_attr_values_tlp_id_list);

2689: BEGIN
2690: l_progress := '010';
2691:
2692: IF PO_LOG.d_proc THEN
2693: PO_LOG.proc_begin(d_mod,'p_attr_values_tlp_id_list',p_attr_values_tlp_id_list);
2694: END IF;
2695:
2696: -- Get the profile value for "POR: Load One-Time Items in All Languages"
2697: l_onetime_item_all_languages := NVL(FND_PROFILE.value('POR_LOAD_ONETIME_ITEM_ALL_LANG'), 'N');

Line 2698: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Profile POR_LOAD_ONETIME_ITEM_ALL_LANG='||l_onetime_item_all_languages); END IF;

2694: END IF;
2695:
2696: -- Get the profile value for "POR: Load One-Time Items in All Languages"
2697: l_onetime_item_all_languages := NVL(FND_PROFILE.value('POR_LOAD_ONETIME_ITEM_ALL_LANG'), 'N');
2698: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Profile POR_LOAD_ONETIME_ITEM_ALL_LANG='||l_onetime_item_all_languages); END IF;
2699:
2700: -- SQL What: Pick a new key from session GT sequence .
2701: -- SQL Why : To get tlp_id's
2702: -- SQL Join: none

Line 2767: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;

2763: x_tlp_new_descriptions_list,
2764: x_tlp_language_list,
2765: x_tlp_long_descriptions_list; -- Bug7039409: Get tlp_long_description
2766:
2767: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;
2768:
2769: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2770: EXCEPTION
2771: WHEN OTHERS THEN

Line 2769: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

2765: x_tlp_long_descriptions_list; -- Bug7039409: Get tlp_long_description
2766:
2767: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;
2768:
2769: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2770: EXCEPTION
2771: WHEN OTHERS THEN
2772: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
2773: RAISE;

Line 2772: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

2768:
2769: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2770: EXCEPTION
2771: WHEN OTHERS THEN
2772: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
2773: RAISE;
2774: END get_translations;
2775:
2776: --------------------------------------------------------------------------------

Line 2813: IF PO_LOG.d_proc THEN

2809: l_key PO_SESSION_GT.key%TYPE;
2810: BEGIN
2811: l_progress := '010';
2812:
2813: IF PO_LOG.d_proc THEN
2814: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2815: END IF;
2816:
2817: -- SQL What: Pick a new key from session GT sequence .

Line 2814: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);

2810: BEGIN
2811: l_progress := '010';
2812:
2813: IF PO_LOG.d_proc THEN
2814: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2815: END IF;
2816:
2817: -- SQL What: Pick a new key from session GT sequence .
2818: -- SQL Why : To get tlp_id's

Line 2852: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;

2848: WHERE key = l_key
2849: RETURNING num1
2850: BULK COLLECT INTO x_tlp_id_list; -- OUT parameter
2851:
2852: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;
2853:
2854: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2855: EXCEPTION
2856: WHEN OTHERS THEN

Line 2854: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

2850: BULK COLLECT INTO x_tlp_id_list; -- OUT parameter
2851:
2852: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;
2853:
2854: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2855: EXCEPTION
2856: WHEN OTHERS THEN
2857: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
2858: RAISE;

Line 2857: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

2853:
2854: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2855: EXCEPTION
2856: WHEN OTHERS THEN
2857: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
2858: RAISE;
2859: END get_tlp_ids_for_lines;
2860:
2861: --------------------------------------------------------------------------------

Line 2922: IF PO_LOG.d_proc THEN

2918: l_default_lang_tlp_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2919: BEGIN
2920: l_progress := '010';
2921:
2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);

Line 2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

2919: BEGIN
2920: l_progress := '010';
2921:
2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);

Line 2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);

2920: l_progress := '010';
2921:
2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);

Line 2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);

2921:
2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

Line 2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);

2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

Line 2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);

2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
2931: END IF;

Line 2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);

2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
2931: END IF;
2932:

Line 2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
2931: END IF;
2932:
2933: -- Wrap single po_line_id into the list collection

Line 2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
2931: END IF;
2932:
2933: -- Wrap single po_line_id into the list collection
2934: IF (p_po_line_id IS NOT NULL) THEN

Line 2971: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Getting TLP IDs from the document(s)...'); END IF;

2967: -- transfer program). In those cases, query up the record here
2968: IF (l_default_lang_tlp_id_list IS NULL OR
2969: (l_default_lang_tlp_id_list.COUNT = 0)) THEN
2970:
2971: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Getting TLP IDs from the document(s)...'); END IF;
2972:
2973: IF (p_doc_type IN ('BLANKET', 'QUOTATION') ) THEN
2974: l_progress := '040';
2975: get_tlp_ids_for_lines

Line 2994: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP IDs fetched for ReqTemplate='||l_attr_values_tlp_id_list.COUNT); END IF;

2990: AND org_id = p_org_id
2991: AND p_req_template_line_num <> g_NOT_REQUIRED_ID
2992: AND language = g_base_language;
2993:
2994: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP IDs fetched for ReqTemplate='||l_attr_values_tlp_id_list.COUNT); END IF;
2995: END IF;
2996: ELSE -- l_default_lang_tlp_id_list IS NOT NULL
2997: l_progress := '060';
2998: -- Copy the list into a local array

Line 3393: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted into TLP table='||SQL%rowcount); END IF;

3389: AND TLP2.org_id = TLP1.org_id
3390: AND TLP2.language = l_tlp_language_list(i));
3391:
3392: l_progress := '090';
3393: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted into TLP table='||SQL%rowcount); END IF;
3394:
3395: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3396: EXCEPTION
3397: WHEN OTHERS THEN

Line 3395: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

3391:
3392: l_progress := '090';
3393: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted into TLP table='||SQL%rowcount); END IF;
3394:
3395: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3396: EXCEPTION
3397: WHEN OTHERS THEN
3398: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3399: RAISE;

Line 3398: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

3394:
3395: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3396: EXCEPTION
3397: WHEN OTHERS THEN
3398: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3399: RAISE;
3400: END create_translations;
3401:
3402: --------------------------------------------------------------------------------

Line 3451: IF PO_LOG.d_proc THEN

3447: l_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;
3448: BEGIN
3449: l_progress := '010';
3450:
3451: IF PO_LOG.d_proc THEN
3452: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3453: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3454: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

Line 3452: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

3448: BEGIN
3449: l_progress := '010';
3450:
3451: IF PO_LOG.d_proc THEN
3452: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3453: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3454: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

Line 3453: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);

3449: l_progress := '010';
3450:
3451: IF PO_LOG.d_proc THEN
3452: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3453: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3454: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3457: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

Line 3454: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);

3450:
3451: IF PO_LOG.d_proc THEN
3452: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3453: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3454: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3457: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3458: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

Line 3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

3451: IF PO_LOG.d_proc THEN
3452: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3453: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3454: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3457: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3458: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3459: PO_LOG.proc_begin(d_mod,'p_description',p_description);

Line 3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

3452: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3453: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3454: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3457: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3458: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3459: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3460: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);

Line 3457: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

3453: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3454: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3457: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3458: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3459: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3460: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);
3461: END IF;

Line 3458: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

3454: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3457: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3458: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3459: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3460: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);
3461: END IF;
3462:

Line 3459: PO_LOG.proc_begin(d_mod,'p_description',p_description);

3455: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3457: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3458: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3459: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3460: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);
3461: END IF;
3462:
3463: IF (p_po_line_id IS NOT NULL) THEN

Line 3460: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);

3456: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3457: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3458: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3459: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3460: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);
3461: END IF;
3462:
3463: IF (p_po_line_id IS NOT NULL) THEN
3464: l_progress := '020';

Line 3552: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in TLP table='||SQL%rowcount); END IF;

3548: AND TLP2.org_id = p_org_id
3549: AND TLP2.language = l_default_lang);
3550:
3551: l_progress := '060';
3552: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in TLP table='||SQL%rowcount); END IF;
3553:
3554: create_translations
3555: (
3556: p_doc_type => p_doc_type,

Line 3563: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

3559: p_req_template_line_num => p_req_template_line_num,
3560: p_org_id => p_org_id
3561: );
3562:
3563: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3564: EXCEPTION
3565: WHEN OTHERS THEN
3566: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3567: RAISE;

Line 3566: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

3562:
3563: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3564: EXCEPTION
3565: WHEN OTHERS THEN
3566: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3567: RAISE;
3568: END create_default_attr_tlp;
3569:
3570: --------------------------------------------------------------------------------

Line 3617: IF PO_LOG.d_proc THEN

3613: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
3614: BEGIN
3615: l_progress := '010';
3616:
3617: IF PO_LOG.d_proc THEN
3618: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3619: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3620: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

Line 3618: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

3614: BEGIN
3615: l_progress := '010';
3616:
3617: IF PO_LOG.d_proc THEN
3618: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3619: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3620: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3622: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

Line 3619: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);

3615: l_progress := '010';
3616:
3617: IF PO_LOG.d_proc THEN
3618: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3619: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3620: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3622: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3623: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

Line 3620: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);

3616:
3617: IF PO_LOG.d_proc THEN
3618: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3619: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3620: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3622: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3623: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3624: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

Line 3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

3617: IF PO_LOG.d_proc THEN
3618: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3619: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3620: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3622: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3623: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3624: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3625: PO_LOG.proc_begin(d_mod,'p_description',p_description);

Line 3622: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

3618: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3619: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3620: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3622: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3623: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3624: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3625: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3626: END IF;

Line 3623: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

3619: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3620: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3622: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3623: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3624: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3625: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3626: END IF;
3627:

Line 3624: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

3620: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3622: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3623: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3624: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3625: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3626: END IF;
3627:
3628: l_progress := '020';

Line 3625: PO_LOG.proc_begin(d_mod,'p_description',p_description);

3621: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3622: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3623: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3624: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3625: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3626: END IF;
3627:
3628: l_progress := '020';
3629: IF (p_po_line_id IS NOT NULL) THEN

Line 3647: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Returning without creating Attr/TLP. Doc type='||l_type_lookup_code); END IF;

3643: END IF;
3644:
3645: -- Do not create Attr/TLP if the doc type is not BLANKET or QUOTATION
3646: IF (l_type_lookup_code NOT IN ('BLANKET', 'QUOTATION')) THEN
3647: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Returning without creating Attr/TLP. Doc type='||l_type_lookup_code); END IF;
3648: RETURN;
3649: END IF;
3650: END IF;
3651:

Line 3718: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in ATR table='||SQL%rowcount); END IF;

3714: AND POATR.req_template_line_num = p_req_template_line_num
3715: AND POATR.org_id = p_org_id);
3716:
3717: l_progress := '050';
3718: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in ATR table='||SQL%rowcount); END IF;
3719:
3720: create_default_attr_tlp
3721: (
3722: p_doc_type => p_doc_type,

Line 3733: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

3729: p_description => p_description,
3730: p_manufacturer => l_manufacturer -- Bug7039409: Added new param
3731: );
3732:
3733: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3734: EXCEPTION
3735: WHEN OTHERS THEN
3736: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3737: RAISE;

Line 3736: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

3732:
3733: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3734: EXCEPTION
3735: WHEN OTHERS THEN
3736: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3737: RAISE;
3738: END create_default_attributes;
3739:
3740: PROCEDURE create_default_attributes_MI

Line 3758: IF PO_LOG.d_proc THEN

3754: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3755: BEGIN
3756: l_progress := '010';
3757:
3758: IF PO_LOG.d_proc THEN
3759: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3760: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3761: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3762: PO_LOG.proc_begin(d_mod,'p_description',p_description);

Line 3759: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

3755: BEGIN
3756: l_progress := '010';
3757:
3758: IF PO_LOG.d_proc THEN
3759: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3760: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3761: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3762: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3763: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);

Line 3760: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

3756: l_progress := '010';
3757:
3758: IF PO_LOG.d_proc THEN
3759: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3760: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3761: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3762: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3763: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3764: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);

Line 3761: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

3757:
3758: IF PO_LOG.d_proc THEN
3759: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3760: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3761: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3762: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3763: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3764: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
3765: END IF;

Line 3762: PO_LOG.proc_begin(d_mod,'p_description',p_description);

3758: IF PO_LOG.d_proc THEN
3759: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3760: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3761: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3762: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3763: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3764: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
3765: END IF;
3766:

Line 3763: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);

3759: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3760: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3761: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3762: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3763: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3764: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
3765: END IF;
3766:
3767: l_progress := '020';

Line 3764: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);

3760: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3761: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3762: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3763: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3764: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
3765: END IF;
3766:
3767: l_progress := '020';
3768:

Line 3799: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' MANUFACTURER_PART_NUM='||l_manufacturer_part_num||' Lead_Time ='||l_proc_lead_time); END IF;

3795: AND ORGANIZATION_ID = p_organization_id;
3796:
3797:
3798:
3799: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' MANUFACTURER_PART_NUM='||l_manufacturer_part_num||' Lead_Time ='||l_proc_lead_time); END IF;
3800:
3801:
3802: l_progress := '030';
3803: -- SQL What: Insert a new row for Attribute values

Line 3860: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in ATR table='||SQL%rowcount); END IF;

3856: AND POATR.req_template_name = '-2'
3857: AND POATR.req_template_line_num = -2);
3858:
3859: l_progress := '040';
3860: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in ATR table='||SQL%rowcount); END IF;
3861:
3862: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3863: EXCEPTION
3864: WHEN OTHERS THEN

Line 3862: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

3858:
3859: l_progress := '040';
3860: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in ATR table='||SQL%rowcount); END IF;
3861:
3862: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3863: EXCEPTION
3864: WHEN OTHERS THEN
3865: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3866: RAISE;

Line 3865: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

3861:
3862: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3863: EXCEPTION
3864: WHEN OTHERS THEN
3865: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3866: RAISE;
3867: END create_default_attributes_MI;
3868:
3869: -- this is for master items

Line 3886: IF PO_LOG.d_proc THEN

3882:
3883: BEGIN
3884: l_progress := '010';
3885:
3886: IF PO_LOG.d_proc THEN
3887: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3888: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3889: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3890: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

Line 3887: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

3883: BEGIN
3884: l_progress := '010';
3885:
3886: IF PO_LOG.d_proc THEN
3887: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3888: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3889: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3890: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3891: END IF;

Line 3888: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

3884: l_progress := '010';
3885:
3886: IF PO_LOG.d_proc THEN
3887: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3888: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3889: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3890: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3891: END IF;
3892:

Line 3889: PO_LOG.proc_begin(d_mod,'p_language',p_language);

3885:
3886: IF PO_LOG.d_proc THEN
3887: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3888: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3889: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3890: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3891: END IF;
3892:
3893: l_progress := '020';

Line 3890: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

3886: IF PO_LOG.d_proc THEN
3887: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3888: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3889: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3890: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3891: END IF;
3892:
3893: l_progress := '020';
3894: -- SQL What: Wipeout category based attributes from AttributeValues table

Line 4016: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows wiped out='||SQL%rowcount); END IF;

4012: AND req_template_line_num = -2
4013: AND inventory_item_id = p_inventory_item_id
4014: AND org_id = p_org_id;
4015:
4016: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows wiped out='||SQL%rowcount); END IF;
4017:
4018: l_progress := '030';
4019: -- SQL What: Wipeout category based attributes from TLP table for all Langs
4020: -- SQL Why : Because the category was changed

Line 4092: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;

4088: AND inventory_item_id = p_inventory_item_id
4089: AND org_id = p_org_id;
4090:
4091:
4092: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;
4093:
4094: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4095: EXCEPTION
4096: WHEN OTHERS THEN

Line 4094: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

4090:
4091:
4092: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;
4093:
4094: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4095: EXCEPTION
4096: WHEN OTHERS THEN
4097: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4098: RAISE;

Line 4097: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

4093:
4094: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4095: EXCEPTION
4096: WHEN OTHERS THEN
4097: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4098: RAISE;
4099: END wipeout_category_attributes_MI;
4100:
4101: -- update attributes for master items

Line 4133: IF PO_LOG.d_proc THEN

4129: BEGIN
4130: l_progress := '010';
4131:
4132:
4133: IF PO_LOG.d_proc THEN
4134: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4135: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4136: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);

Line 4134: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

4130: l_progress := '010';
4131:
4132:
4133: IF PO_LOG.d_proc THEN
4134: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4135: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4136: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4138: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);

Line 4135: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

4131:
4132:
4133: IF PO_LOG.d_proc THEN
4134: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4135: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4136: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4138: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4139: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);

Line 4136: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

4132:
4133: IF PO_LOG.d_proc THEN
4134: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4135: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4136: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4138: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4139: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4140: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);

Line 4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);

4133: IF PO_LOG.d_proc THEN
4134: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4135: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4136: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4138: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4139: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4140: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4141: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);

Line 4138: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);

4134: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4135: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4136: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4138: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4139: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4140: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4141: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
4142: END IF;

Line 4139: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);

4135: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4136: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4138: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4139: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4140: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4141: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
4142: END IF;
4143:

Line 4140: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);

4136: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4138: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4139: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4140: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4141: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
4142: END IF;
4143:
4144: l_progress := '020';

Line 4141: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);

4137: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4138: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4139: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4140: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4141: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
4142: END IF;
4143:
4144: l_progress := '020';
4145: -- SQL What: Check if ip_category_id has changed

Line 4195: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' MANUFACTURER_PART_NUM='||l_manufacturer_part_num||' LEAD_TIME= '||l_proc_lead_time); END IF;

4191:
4192:
4193:
4194:
4195: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' MANUFACTURER_PART_NUM='||l_manufacturer_part_num||' LEAD_TIME= '||l_proc_lead_time); END IF;
4196: l_progress := '070';
4197:
4198:
4199:

Line 4202: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IPF_CATEGORY_ID has changed: p_ip_category_id='||p_ip_category_id||', l_orig_ip_category_id='||l_orig_ip_category_id); END IF;

4198:
4199:
4200: IF (p_ip_category_id <> l_orig_ip_category_id) THEN
4201: l_progress := '060';
4202: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IPF_CATEGORY_ID has changed: p_ip_category_id='||p_ip_category_id||', l_orig_ip_category_id='||l_orig_ip_category_id); END IF;
4203:
4204: wipeout_category_attributes_MI
4205: (
4206: p_org_id => p_org_id,

Line 4214: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has not changed.'); END IF;

4210: p_item_description => p_item_description
4211: );
4212:
4213: ELSE
4214: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has not changed.'); END IF;
4215: END IF;
4216:
4217: l_progress := '070';
4218:

Line 4244: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;

4240: AND inventory_item_id = p_inventory_item_id
4241: AND org_id = p_org_id;
4242:
4243:
4244: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;
4245:
4246:
4247:
4248: l_progress := '085';

Line 4278: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'no records hence insert into PO_ATTRIBUTE_VALUES_TLP ' ); END IF;

4274: l_rec_tlp_for_lang:='';
4275: END;
4276:
4277: IF (l_rec_tlp_for_lang IS NULL OR l_rec_tlp_for_lang = '' ) THEN
4278: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'no records hence insert into PO_ATTRIBUTE_VALUES_TLP ' ); END IF;
4279: l_progress := '090';
4280:
4281: INSERT INTO PO_ATTRIBUTE_VALUES_TLP TLP
4282: (

Line 4330: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' records present hence update PO_ATTRIBUTE_VALUES_TLP ' || l_rec_tlp_for_lang); END IF;

4326: d_mod -- last_updated_program
4327: FROM dual;
4328:
4329: ELSE
4330: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' records present hence update PO_ATTRIBUTE_VALUES_TLP ' || l_rec_tlp_for_lang); END IF;
4331: l_progress := '095';
4332: SELECT description,Nvl(LONG_DESCRIPTION,''),Nvl(MANUFACTURER,'')
4333: INTO l_orig_item_description,l_orig_long_desc,l_orig_manufacturer
4334: FROM PO_ATTRIBUTE_VALUES_TLP

Line 4380: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows updated='||SQL%rowcount); END IF;

4376: AND inventory_item_id = p_inventory_item_id
4377: AND org_id = p_org_id
4378: AND language = p_language;
4379:
4380: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows updated='||SQL%rowcount); END IF;
4381: END IF;
4382:
4383: END IF;
4384:

Line 4388: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

4384:
4385:
4386: l_progress := '100';
4387:
4388: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4389: EXCEPTION
4390: WHEN OTHERS THEN
4391: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4392: RAISE;

Line 4391: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

4387:
4388: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4389: EXCEPTION
4390: WHEN OTHERS THEN
4391: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4392: RAISE;
4393: END update_attributes_MI;
4394:
4395:

Line 4443: IF PO_LOG.d_proc THEN

4439: l_tlp_id_list PO_TBL_NUMBER;
4440: BEGIN
4441: l_progress := '010';
4442:
4443: IF PO_LOG.d_proc THEN
4444: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
4445: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
4446: END IF;
4447:

Line 4444: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);

4440: BEGIN
4441: l_progress := '010';
4442:
4443: IF PO_LOG.d_proc THEN
4444: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
4445: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
4446: END IF;
4447:
4448: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN

Line 4445: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

4441: l_progress := '010';
4442:
4443: IF PO_LOG.d_proc THEN
4444: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
4445: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
4446: END IF;
4447:
4448: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN
4449:

Line 4475: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc type='||p_doc_type||'. No translations created.'); END IF;

4471: p_default_lang_tlp_id_list => l_tlp_id_list,
4472: p_po_line_id_list => l_po_line_id_list
4473: );
4474: ELSE
4475: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc type='||p_doc_type||'. No translations created.'); END IF;
4476: END IF; -- IF (p_doc_type IN ('BLANKET', 'QUOTATION'))
4477:
4478: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4479: EXCEPTION

Line 4478: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

4474: ELSE
4475: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc type='||p_doc_type||'. No translations created.'); END IF;
4476: END IF; -- IF (p_doc_type IN ('BLANKET', 'QUOTATION'))
4477:
4478: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4479: EXCEPTION
4480: WHEN OTHERS THEN
4481: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4482: RAISE;

Line 4481: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

4477:
4478: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4479: EXCEPTION
4480: WHEN OTHERS THEN
4481: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4482: RAISE;
4483: END gen_draft_line_translations;
4484:
4485: --------------------------------------------------------------------------------

Line 4525: IF PO_LOG.d_proc THEN

4521:
4522: BEGIN
4523: l_progress := '010';
4524:
4525: IF PO_LOG.d_proc THEN
4526: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4527: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4528: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4529: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

Line 4526: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);

4522: BEGIN
4523: l_progress := '010';
4524:
4525: IF PO_LOG.d_proc THEN
4526: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4527: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4528: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4529: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4530: END IF;

Line 4527: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);

4523: l_progress := '010';
4524:
4525: IF PO_LOG.d_proc THEN
4526: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4527: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4528: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4529: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4530: END IF;
4531:

Line 4528: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

4524:
4525: IF PO_LOG.d_proc THEN
4526: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4527: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4528: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4529: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4530: END IF;
4531:
4532: l_progress := '020';

Line 4529: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

4525: IF PO_LOG.d_proc THEN
4526: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4527: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4528: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4529: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4530: END IF;
4531:
4532: l_progress := '020';
4533: -- SQL What: Wipeout category based attributes from AttributeValues table

Line 4654: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows wiped out='||SQL%rowcount); END IF;

4650: AND req_template_name = NVL(p_req_template_name, '-2')
4651: AND req_template_line_num = NVL(p_req_template_line_num, -2)
4652: AND org_id = p_org_id;
4653:
4654: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows wiped out='||SQL%rowcount); END IF;
4655:
4656: l_progress := '030';
4657: -- SQL What: Wipeout category based attributes from TLP table for all Langs
4658: -- SQL Why : Because the category was changed

Line 4728: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;

4724: AND req_template_name = NVL(p_req_template_name, '-2')
4725: AND req_template_line_num = NVL(p_req_template_line_num, -2)
4726: AND org_id = p_org_id;
4727:
4728: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;
4729:
4730: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4731: EXCEPTION
4732: WHEN OTHERS THEN

Line 4730: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

4726: AND org_id = p_org_id;
4727:
4728: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;
4729:
4730: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4731: EXCEPTION
4732: WHEN OTHERS THEN
4733: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4734: RAISE;

Line 4733: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

4729:
4730: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4731: EXCEPTION
4732: WHEN OTHERS THEN
4733: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4734: RAISE;
4735: END wipeout_category_attributes;
4736:
4737:

Line 4785: IF PO_LOG.d_proc THEN

4781: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4782: BEGIN
4783: l_progress := '010';
4784:
4785: IF PO_LOG.d_proc THEN
4786: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4787: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4788: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4789: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

Line 4786: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);

4782: BEGIN
4783: l_progress := '010';
4784:
4785: IF PO_LOG.d_proc THEN
4786: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4787: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4788: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4789: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4790: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

Line 4787: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);

4783: l_progress := '010';
4784:
4785: IF PO_LOG.d_proc THEN
4786: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4787: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4788: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4789: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4790: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4791: PO_LOG.proc_begin(d_mod,'p_language',p_language);

Line 4788: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

4784:
4785: IF PO_LOG.d_proc THEN
4786: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4787: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4788: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4789: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4790: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4791: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4792: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);

Line 4789: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

4785: IF PO_LOG.d_proc THEN
4786: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4787: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4788: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4789: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4790: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4791: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4792: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4793: END IF;

Line 4790: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

4786: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4787: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4788: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4789: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4790: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4791: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4792: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4793: END IF;
4794:

Line 4791: PO_LOG.proc_begin(d_mod,'p_language',p_language);

4787: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4788: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4789: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4790: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4791: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4792: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4793: END IF;
4794:
4795: l_progress := '020';

Line 4792: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);

4788: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4789: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4790: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4791: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4792: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4793: END IF;
4794:
4795: l_progress := '020';
4796: IF (p_po_line_id IS NOT NULL) THEN

Line 4814: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Returning without creating Attr/TLP. Doc type='||l_type_lookup_code); END IF;

4810: END IF;
4811:
4812: -- Do not create Attr/TLP if the doc type is not BLANKET or QUOTATION
4813: IF (l_type_lookup_code NOT IN ('BLANKET', 'QUOTATION')) THEN
4814: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Returning without creating Attr/TLP. Doc type='||l_type_lookup_code); END IF;
4815: RETURN;
4816: END IF;
4817: END IF;
4818:

Line 4839: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has changed: p_ip_category_id='||p_ip_category_id||', l_orig_ip_category_id='||l_orig_ip_category_id); END IF;

4835: -- i.e. all attribute columns that have 'CAT' in the name.
4836: IF (p_ip_category_id <> l_orig_ip_category_id) THEN
4837: l_progress := '060';
4838:
4839: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has changed: p_ip_category_id='||p_ip_category_id||', l_orig_ip_category_id='||l_orig_ip_category_id); END IF;
4840:
4841: wipeout_category_attributes
4842: (
4843: p_po_line_id => p_po_line_id

Line 4871: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;

4867: AND req_template_name = NVL(p_req_template_name, '-2')
4868: AND req_template_line_num = NVL(p_req_template_line_num, -2)
4869: AND org_id = p_org_id;
4870:
4871: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;
4872:
4873: ELSE
4874: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has not changed.'); END IF;
4875: END IF;

Line 4874: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has not changed.'); END IF;

4870:
4871: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;
4872:
4873: ELSE
4874: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has not changed.'); END IF;
4875: END IF;
4876:
4877: l_progress := '080';
4878: -- SQL What: Check if item_description has changed

Line 4892: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has not changed.'); END IF;

4888: AND org_id = p_org_id
4889: AND language = p_language;
4890:
4891: IF (p_item_description = l_orig_item_description) THEN
4892: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has not changed.'); END IF;
4893: ELSE
4894: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has changed.'); END IF;
4895: END IF;
4896:

Line 4894: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has changed.'); END IF;

4890:
4891: IF (p_item_description = l_orig_item_description) THEN
4892: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has not changed.'); END IF;
4893: ELSE
4894: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has changed.'); END IF;
4895: END IF;
4896:
4897: l_progress := '090';
4898: IF ( (p_ip_category_id <> l_orig_ip_category_id) OR

Line 4923: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows updated='||SQL%rowcount); END IF;

4919: AND req_template_line_num = NVL(p_req_template_line_num, -2)
4920: AND org_id = p_org_id
4921: AND language = p_language;
4922:
4923: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows updated='||SQL%rowcount); END IF;
4924: END IF;
4925:
4926: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4927: EXCEPTION

Line 4926: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

4922:
4923: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows updated='||SQL%rowcount); END IF;
4924: END IF;
4925:
4926: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4927: EXCEPTION
4928: WHEN OTHERS THEN
4929: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4930: RAISE;

Line 4929: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

4925:
4926: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4927: EXCEPTION
4928: WHEN OTHERS THEN
4929: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4930: RAISE;
4931: END update_attributes;
4932:
4933: --------------------------------------------------------------------------------

Line 4968: IF PO_LOG.d_proc THEN

4964:
4965: BEGIN
4966: l_progress := '010';
4967:
4968: IF PO_LOG.d_proc THEN
4969: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
4970: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
4971: END IF;
4972:

Line 4969: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);

4965: BEGIN
4966: l_progress := '010';
4967:
4968: IF PO_LOG.d_proc THEN
4969: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
4970: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
4971: END IF;
4972:
4973: --Bug# 5520701: PICTURE column needed to be inserted.

Line 4970: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);

4966: l_progress := '010';
4967:
4968: IF PO_LOG.d_proc THEN
4969: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
4970: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
4971: END IF;
4972:
4973: --Bug# 5520701: PICTURE column needed to be inserted.
4974:

Line 5645: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows copied='||SQL%rowcount); END IF;

5641: AND ATR2.req_template_line_num = POATR.req_template_line_num
5642: AND ATR2.org_id = POATR.org_id);
5643:
5644: l_progress := '020';
5645: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows copied='||SQL%rowcount); END IF;
5646:
5647: -- SQL What: Insert new rows for Attribute values TLP.
5648: -- This SQL will enter multiple rows, one for each installed lang.
5649: -- SQL Why : To copy the TLP from old doc to new doc

Line 6012: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows copied='||SQL%rowcount); END IF;

6008: AND TLP2.org_id = POTLP.org_id
6009: AND TLP2.language = POTLP.language);
6010:
6011: l_progress := '030';
6012: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows copied='||SQL%rowcount); END IF;
6013:
6014: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6015: EXCEPTION
6016: WHEN OTHERS THEN

Line 6014: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

6010:
6011: l_progress := '030';
6012: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows copied='||SQL%rowcount); END IF;
6013:
6014: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6015: EXCEPTION
6016: WHEN OTHERS THEN
6017: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6018: RAISE;

Line 6017: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

6013:
6014: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6015: EXCEPTION
6016: WHEN OTHERS THEN
6017: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6018: RAISE;
6019: END copy_attributes;
6020:
6021: --------------------------------------------------------------------------------

Line 6055: IF PO_LOG.d_proc THEN

6051:
6052: BEGIN
6053: l_progress := '010';
6054:
6055: IF PO_LOG.d_proc THEN
6056: PO_LOG.proc_begin(d_mod,'p_po_category_id',p_po_category_id);
6057: END IF;
6058:
6059: -- SQL What: Default the IP_CATEGORY_ID

Line 6056: PO_LOG.proc_begin(d_mod,'p_po_category_id',p_po_category_id);

6052: BEGIN
6053: l_progress := '010';
6054:
6055: IF PO_LOG.d_proc THEN
6056: PO_LOG.proc_begin(d_mod,'p_po_category_id',p_po_category_id);
6057: END IF;
6058:
6059: -- SQL What: Default the IP_CATEGORY_ID
6060: -- SQL Why : To insert the correct default value of IP_CATEGORY ID

Line 6067: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_ip_category_id='||x_ip_category_id); END IF;

6063: INTO x_ip_category_id
6064: FROM ICX_CAT_PURCHASING_CAT_MAP_V
6065: WHERE po_category_id = p_po_category_id;
6066:
6067: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_ip_category_id='||x_ip_category_id); END IF;
6068:
6069: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6070: EXCEPTION
6071: WHEN NO_DATA_FOUND THEN

Line 6069: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

6065: WHERE po_category_id = p_po_category_id;
6066:
6067: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_ip_category_id='||x_ip_category_id); END IF;
6068:
6069: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6070: EXCEPTION
6071: WHEN NO_DATA_FOUND THEN
6072: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'NO_DATA_FOUND exception: Ignoring and setting ip_category_id=-2'); END IF;
6073: x_ip_category_id := -2;

Line 6072: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'NO_DATA_FOUND exception: Ignoring and setting ip_category_id=-2'); END IF;

6068:
6069: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6070: EXCEPTION
6071: WHEN NO_DATA_FOUND THEN
6072: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'NO_DATA_FOUND exception: Ignoring and setting ip_category_id=-2'); END IF;
6073: x_ip_category_id := -2;
6074: WHEN TOO_MANY_ROWS THEN
6075: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'TOO_MANY_ROWS exception'); END IF;
6076: x_ip_category_id := -2; -- TODO: This is a temp fix. Resolve with iProc why this exceptions?

Line 6075: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'TOO_MANY_ROWS exception'); END IF;

6071: WHEN NO_DATA_FOUND THEN
6072: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'NO_DATA_FOUND exception: Ignoring and setting ip_category_id=-2'); END IF;
6073: x_ip_category_id := -2;
6074: WHEN TOO_MANY_ROWS THEN
6075: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'TOO_MANY_ROWS exception'); END IF;
6076: x_ip_category_id := -2; -- TODO: This is a temp fix. Resolve with iProc why this exceptions?
6077: WHEN OTHERS THEN
6078: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6079: RAISE;

Line 6078: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

6074: WHEN TOO_MANY_ROWS THEN
6075: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'TOO_MANY_ROWS exception'); END IF;
6076: x_ip_category_id := -2; -- TODO: This is a temp fix. Resolve with iProc why this exceptions?
6077: WHEN OTHERS THEN
6078: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6079: RAISE;
6080: END get_ip_category_id;
6081:
6082: --------------------------------------------------------------------------------

Line 6121: IF PO_LOG.d_proc THEN

6117:
6118: BEGIN
6119: l_progress := '010';
6120:
6121: IF PO_LOG.d_proc THEN
6122: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6123: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6124: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6125: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

Line 6122: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

6118: BEGIN
6119: l_progress := '010';
6120:
6121: IF PO_LOG.d_proc THEN
6122: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6123: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6124: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6125: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6126: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

Line 6123: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);

6119: l_progress := '010';
6120:
6121: IF PO_LOG.d_proc THEN
6122: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6123: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6124: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6125: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6126: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6127: END IF;

Line 6124: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);

6120:
6121: IF PO_LOG.d_proc THEN
6122: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6123: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6124: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6125: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6126: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6127: END IF;
6128:

Line 6125: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);

6121: IF PO_LOG.d_proc THEN
6122: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6123: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6124: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6125: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6126: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6127: END IF;
6128:
6129: -- SQL What: Delete Attribute Values

Line 6126: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

6122: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6123: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6124: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6125: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6126: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6127: END IF;
6128:
6129: -- SQL What: Delete Attribute Values
6130: -- SQL Why : as required by this procedure

Line 6139: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows deleted='||SQL%rowcount); END IF;

6135: AND req_template_line_num = NVL(p_req_template_line_num, -2)
6136: AND org_id = NVL(p_org_id, PO_MOAC_UTILS_PVT.get_current_org_id);
6137:
6138: l_progress := '020';
6139: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows deleted='||SQL%rowcount); END IF;
6140:
6141: -- SQL What: Delete Attribute Values TLP
6142: -- SQL Why : as required by this procedure
6143: -- SQL Join: po_line_id, req_template_name, req_template_line_num, org_id

Line 6151: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;

6147: AND req_template_line_num = NVL(p_req_template_line_num, -2)
6148: AND org_id = NVL(p_org_id, PO_MOAC_UTILS_PVT.get_current_org_id);
6149:
6150: l_progress := '030';
6151: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;
6152:
6153: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6154: EXCEPTION
6155: WHEN OTHERS THEN

Line 6153: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

6149:
6150: l_progress := '030';
6151: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;
6152:
6153: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6154: EXCEPTION
6155: WHEN OTHERS THEN
6156: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6157: RAISE;

Line 6156: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

6152:
6153: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6154: EXCEPTION
6155: WHEN OTHERS THEN
6156: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6157: RAISE;
6158: END delete_attributes;
6159:
6160: --------------------------------------------------------------------------------

Line 6194: IF PO_LOG.d_proc THEN

6190:
6191: BEGIN
6192: l_progress := '010';
6193:
6194: IF PO_LOG.d_proc THEN
6195: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6196: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
6197: END IF;
6198:

Line 6195: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

6191: BEGIN
6192: l_progress := '010';
6193:
6194: IF PO_LOG.d_proc THEN
6195: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6196: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
6197: END IF;
6198:
6199: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN

Line 6196: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

6192: l_progress := '010';
6193:
6194: IF PO_LOG.d_proc THEN
6195: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6196: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
6197: END IF;
6198:
6199: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN
6200: -- SQL What: Delete Attribute Values for all lines in a PO Header

Line 6212: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows deleted='||SQL%rowcount); END IF;

6208: AND POATR.po_line_id = POL.po_line_id);
6209:
6210:
6211: l_progress := '020';
6212: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows deleted='||SQL%rowcount); END IF;
6213:
6214: -- SQL What: Delete Attribute Values TLP for all lines in a PO Header
6215: -- SQL Why : as required by this procedure
6216: -- SQL Join: po_line_id, po_header_id

Line 6225: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;

6221: WHERE POL.po_header_id = p_po_header_id
6222: AND POTLP.po_line_id = POL.po_line_id);
6223:
6224: l_progress := '030';
6225: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;
6226: ELSE
6227: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc_type='||p_doc_type); END IF;
6228: END IF;
6229:

Line 6227: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc_type='||p_doc_type); END IF;

6223:
6224: l_progress := '030';
6225: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;
6226: ELSE
6227: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc_type='||p_doc_type); END IF;
6228: END IF;
6229:
6230: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6231: EXCEPTION

Line 6230: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

6226: ELSE
6227: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc_type='||p_doc_type); END IF;
6228: END IF;
6229:
6230: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6231: EXCEPTION
6232: WHEN OTHERS THEN
6233: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6234: RAISE;

Line 6233: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

6229:
6230: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6231: EXCEPTION
6232: WHEN OTHERS THEN
6233: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6234: RAISE;
6235: END delete_attributes_for_header;
6236:
6237: --------------------------------------------------------------------------------

Line 6262: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;

6258: d_mod CONSTANT VARCHAR2(100) := D_get_base_lang;
6259: l_progress VARCHAR2(4);
6260: BEGIN
6261: l_progress := '010';
6262: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
6263:
6264: l_progress := '020';
6265: IF (g_base_language IS NULL) THEN
6266: -- SQL What: Get the base language of the system installation.

Line 6276: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'base_lang=<'||g_base_language||'>'); END IF;

6272: WHERE installed_flag='B';
6273: END IF;
6274:
6275: l_progress := '030';
6276: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'base_lang=<'||g_base_language||'>'); END IF;
6277:
6278: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6279: RETURN g_base_language;
6280: EXCEPTION

Line 6278: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

6274:
6275: l_progress := '030';
6276: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'base_lang=<'||g_base_language||'>'); END IF;
6277:
6278: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6279: RETURN g_base_language;
6280: EXCEPTION
6281: WHEN OTHERS THEN
6282: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

Line 6282: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

6278: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6279: RETURN g_base_language;
6280: EXCEPTION
6281: WHEN OTHERS THEN
6282: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6283: RAISE;
6284: END get_base_lang;
6285:
6286: PROCEDURE create_attributes_tlp_MI

Line 6308: IF PO_LOG.d_proc THEN

6304: BEGIN
6305: l_progress := '010';
6306:
6307:
6308: IF PO_LOG.d_proc THEN
6309: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6310: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6311: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);

Line 6309: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

6305: l_progress := '010';
6306:
6307:
6308: IF PO_LOG.d_proc THEN
6309: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6310: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6311: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6313: PO_LOG.proc_begin(d_mod,'p_description',p_description);

Line 6310: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

6306:
6307:
6308: IF PO_LOG.d_proc THEN
6309: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6310: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6311: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6313: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6314: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);

Line 6311: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);

6307:
6308: IF PO_LOG.d_proc THEN
6309: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6310: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6311: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6313: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6314: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6315: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);

Line 6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);

6308: IF PO_LOG.d_proc THEN
6309: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6310: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6311: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6313: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6314: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6315: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6316: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);

Line 6313: PO_LOG.proc_begin(d_mod,'p_description',p_description);

6309: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6310: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6311: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6313: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6314: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6315: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6316: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
6317:

Line 6314: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);

6310: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6311: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6313: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6314: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6315: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6316: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
6317:
6318: END IF;

Line 6315: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);

6311: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6313: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6314: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6315: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6316: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
6317:
6318: END IF;
6319:

Line 6316: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);

6312: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6313: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6314: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6315: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6316: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
6317:
6318: END IF;
6319:
6320: l_progress := '030';

Line 6404: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in TLP table='||SQL%rowcount); END IF;

6400: AND TLP2.req_template_line_num = -2
6401: );
6402:
6403: l_progress := '060';
6404: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in TLP table='||SQL%rowcount); END IF;
6405:
6406: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6407: EXCEPTION
6408: WHEN OTHERS THEN

Line 6406: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

6402:
6403: l_progress := '060';
6404: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in TLP table='||SQL%rowcount); END IF;
6405:
6406: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6407: EXCEPTION
6408: WHEN OTHERS THEN
6409: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6410: RAISE;

Line 6409: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

6405:
6406: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6407: EXCEPTION
6408: WHEN OTHERS THEN
6409: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6410: RAISE;
6411: END create_attributes_tlp_MI;
6412:
6413: --------------------------------------------------------------------------------

Line 6488: IF PO_LOG.d_proc THEN

6484: l_inv_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6485:
6486: BEGIN
6487: l_progress := '010';
6488: IF PO_LOG.d_proc THEN
6489: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6490: END IF;
6491:
6492: -- Get MASTER_ORGANIZATION_ID and INVENTORY_ORGANIZATION_ID

Line 6489: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

6485:
6486: BEGIN
6487: l_progress := '010';
6488: IF PO_LOG.d_proc THEN
6489: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6490: END IF;
6491:
6492: -- Get MASTER_ORGANIZATION_ID and INVENTORY_ORGANIZATION_ID
6493: -- Use master org to get mfg_part_num, manufacturer_name and long_description

Line 6504: IF PO_LOG.d_stmt THEN

6500: FROM mtl_parameters mtl,
6501: financials_system_parameters fsp
6502: WHERE fsp.inventory_organization_id = mtl.organization_id;
6503:
6504: IF PO_LOG.d_stmt THEN
6505: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6506: PO_LOG.stmt(d_mod,l_progress,'l_inv_organization_id='||l_inv_organization_id);
6507: END IF;
6508: l_progress := '020';

Line 6505: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);

6501: financials_system_parameters fsp
6502: WHERE fsp.inventory_organization_id = mtl.organization_id;
6503:
6504: IF PO_LOG.d_stmt THEN
6505: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6506: PO_LOG.stmt(d_mod,l_progress,'l_inv_organization_id='||l_inv_organization_id);
6507: END IF;
6508: l_progress := '020';
6509:

Line 6506: PO_LOG.stmt(d_mod,l_progress,'l_inv_organization_id='||l_inv_organization_id);

6502: WHERE fsp.inventory_organization_id = mtl.organization_id;
6503:
6504: IF PO_LOG.d_stmt THEN
6505: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6506: PO_LOG.stmt(d_mod,l_progress,'l_inv_organization_id='||l_inv_organization_id);
6507: END IF;
6508: l_progress := '020';
6509:
6510: -- Get MANUFACTURER Related info

Line 6525: IF PO_LOG.d_stmt THEN

6521: WHERE inventory_item_id = p_inventory_item_id
6522: AND organization_id = l_master_organization_id);
6523:
6524:
6525: IF PO_LOG.d_stmt THEN
6526: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer_part_num='||p_manufacturer_part_num);
6527: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer='||p_manufacturer);
6528: END IF;
6529: l_progress := '030';

Line 6526: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer_part_num='||p_manufacturer_part_num);

6522: AND organization_id = l_master_organization_id);
6523:
6524:
6525: IF PO_LOG.d_stmt THEN
6526: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer_part_num='||p_manufacturer_part_num);
6527: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer='||p_manufacturer);
6528: END IF;
6529: l_progress := '030';
6530:

Line 6527: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer='||p_manufacturer);

6523:
6524:
6525: IF PO_LOG.d_stmt THEN
6526: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer_part_num='||p_manufacturer_part_num);
6527: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer='||p_manufacturer);
6528: END IF;
6529: l_progress := '030';
6530:
6531: EXCEPTION

Line 6544: IF PO_LOG.d_stmt THEN

6540: FROM mtl_system_items_b
6541: WHERE inventory_item_id = p_inventory_item_id
6542: AND organization_id = l_inv_organization_id;
6543:
6544: IF PO_LOG.d_stmt THEN
6545: PO_LOG.stmt(d_mod,l_progress,'p_lead_time='||p_lead_time);
6546: END IF;
6547: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6548: END get_item_attributes_values;

Line 6545: PO_LOG.stmt(d_mod,l_progress,'p_lead_time='||p_lead_time);

6541: WHERE inventory_item_id = p_inventory_item_id
6542: AND organization_id = l_inv_organization_id;
6543:
6544: IF PO_LOG.d_stmt THEN
6545: PO_LOG.stmt(d_mod,l_progress,'p_lead_time='||p_lead_time);
6546: END IF;
6547: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6548: END get_item_attributes_values;
6549: --------------------------------------------------------------------------------

Line 6547: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

6543:
6544: IF PO_LOG.d_stmt THEN
6545: PO_LOG.stmt(d_mod,l_progress,'p_lead_time='||p_lead_time);
6546: END IF;
6547: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6548: END get_item_attributes_values;
6549: --------------------------------------------------------------------------------
6550: --Start of Comments
6551: --Bug 7039409: Added new procedure

Line 6582: IF PO_LOG.d_proc THEN

6578: l_progress VARCHAR2(4);
6579: l_master_organization_id PO_LINES_ALL.org_id%TYPE;
6580: BEGIN
6581: l_progress := '010';
6582: IF PO_LOG.d_proc THEN
6583: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6584: PO_LOG.proc_begin(d_mod,'p_lang',p_lang);
6585: END IF;
6586:

Line 6583: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);

6579: l_master_organization_id PO_LINES_ALL.org_id%TYPE;
6580: BEGIN
6581: l_progress := '010';
6582: IF PO_LOG.d_proc THEN
6583: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6584: PO_LOG.proc_begin(d_mod,'p_lang',p_lang);
6585: END IF;
6586:
6587: -- Get MASTER_ORGANIZATION_ID

Line 6584: PO_LOG.proc_begin(d_mod,'p_lang',p_lang);

6580: BEGIN
6581: l_progress := '010';
6582: IF PO_LOG.d_proc THEN
6583: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6584: PO_LOG.proc_begin(d_mod,'p_lang',p_lang);
6585: END IF;
6586:
6587: -- Get MASTER_ORGANIZATION_ID
6588: SELECT mtl.master_organization_id

Line 6594: IF PO_LOG.d_stmt THEN

6590: FROM mtl_parameters mtl,
6591: financials_system_parameters fsp
6592: WHERE fsp.inventory_organization_id = mtl.organization_id;
6593:
6594: IF PO_LOG.d_stmt THEN
6595: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6596: END IF;
6597: l_progress := '020';
6598:

Line 6595: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);

6591: financials_system_parameters fsp
6592: WHERE fsp.inventory_organization_id = mtl.organization_id;
6593:
6594: IF PO_LOG.d_stmt THEN
6595: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6596: END IF;
6597: l_progress := '020';
6598:
6599: -- Get LONG_DESCRIPTION

Line 6608: IF PO_LOG.d_stmt THEN

6604: WHERE inventory_item_id = p_inventory_item_id
6605: AND organization_id = l_master_organization_id
6606: AND language = p_lang;
6607:
6608: IF PO_LOG.d_stmt THEN
6609: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6610: END IF;
6611: EXCEPTION
6612: -- If not found, get it for the base lang

Line 6609: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);

6605: AND organization_id = l_master_organization_id
6606: AND language = p_lang;
6607:
6608: IF PO_LOG.d_stmt THEN
6609: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6610: END IF;
6611: EXCEPTION
6612: -- If not found, get it for the base lang
6613: WHEN NO_DATA_FOUND THEN

Line 6620: IF PO_LOG.d_stmt THEN

6616: FROM mtl_system_items_tl
6617: WHERE inventory_item_id = p_inventory_item_id
6618: AND organization_id = l_master_organization_id
6619: AND language = g_base_language;
6620: IF PO_LOG.d_stmt THEN
6621: PO_LOG.stmt(d_mod,l_progress,'NO_DATA_FOUND');
6622: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6623: END IF;
6624: END;

Line 6621: PO_LOG.stmt(d_mod,l_progress,'NO_DATA_FOUND');

6617: WHERE inventory_item_id = p_inventory_item_id
6618: AND organization_id = l_master_organization_id
6619: AND language = g_base_language;
6620: IF PO_LOG.d_stmt THEN
6621: PO_LOG.stmt(d_mod,l_progress,'NO_DATA_FOUND');
6622: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6623: END IF;
6624: END;
6625:

Line 6622: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);

6618: AND organization_id = l_master_organization_id
6619: AND language = g_base_language;
6620: IF PO_LOG.d_stmt THEN
6621: PO_LOG.stmt(d_mod,l_progress,'NO_DATA_FOUND');
6622: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6623: END IF;
6624: END;
6625:
6626: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

Line 6626: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

6622: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6623: END IF;
6624: END;
6625:
6626: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6627: END get_item_attributes_tlp_values;
6628:
6629: END;