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

Line 8: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_AUTOCREATE_GROUPING_PVT');

4: --=============================================
5: -- GLOBAL VARIABLES
6: --=============================================
7:
8: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_AUTOCREATE_GROUPING_PVT');
9:
10: D_get_line_action_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_action_tbl');
11: D_check_po_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_po_line_numbers');
12: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');

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

6: --=============================================
7:
8: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_AUTOCREATE_GROUPING_PVT');
9:
10: D_get_line_action_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_action_tbl');
11: D_check_po_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_po_line_numbers');
12: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
13: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
14: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');

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

7:
8: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_AUTOCREATE_GROUPING_PVT');
9:
10: D_get_line_action_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_action_tbl');
11: D_check_po_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_po_line_numbers');
12: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
13: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
14: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
15: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');

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

8: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_AUTOCREATE_GROUPING_PVT');
9:
10: D_get_line_action_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_action_tbl');
11: D_check_po_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_po_line_numbers');
12: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
13: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
14: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
15: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
16: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');

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

9:
10: D_get_line_action_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_action_tbl');
11: D_check_po_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_po_line_numbers');
12: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
13: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
14: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
15: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
16: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
17: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');

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

10: D_get_line_action_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_action_tbl');
11: D_check_po_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_po_line_numbers');
12: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
13: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
14: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
15: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
16: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
17: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
18: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');

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

11: D_check_po_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_po_line_numbers');
12: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
13: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
14: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
15: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
16: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
17: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
18: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
19: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');

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

12: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
13: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
14: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
15: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
16: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
17: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
18: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
19: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
20: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');

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

13: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
14: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
15: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
16: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
17: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
18: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
19: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
20: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
21: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');

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

14: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
15: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
16: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
17: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
18: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
19: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
20: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
21: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
22: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');

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

15: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
16: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
17: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
18: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
19: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
20: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
21: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
22: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
23: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');

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

16: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
17: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
18: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
19: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
20: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
21: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
22: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
23: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
24: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');

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

17: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
18: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
19: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
20: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
21: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
22: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
23: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
24: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
25: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');

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

18: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
19: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
20: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
21: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
22: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
23: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
24: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
25: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
26: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');

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

19: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
20: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
21: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
22: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
23: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
24: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
25: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
26: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
27: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');

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

20: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
21: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
22: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
23: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
24: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
25: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
26: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
27: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
28: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');

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

21: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
22: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
23: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
24: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
25: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
26: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
27: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
28: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
29: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');

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

22: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
23: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
24: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
25: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
26: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
27: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
28: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
29: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
30: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');

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

23: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
24: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
25: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
26: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
27: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
28: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
29: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
30: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
31: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');

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

24: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
25: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
26: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
27: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
28: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
29: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
30: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
31: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
32:

Line 29: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');

25: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
26: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
27: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
28: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
29: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
30: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
31: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
32:
33: /*=========================================================================*/

Line 30: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');

26: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
27: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
28: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
29: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
30: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
31: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
32:
33: /*=========================================================================*/
34: /*===================== SPECIFICATIONS (PRIVATE) ==========================*/

Line 31: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');

27: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
28: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
29: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
30: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
31: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
32:
33: /*=========================================================================*/
34: /*===================== SPECIFICATIONS (PRIVATE) ==========================*/
35: /*=========================================================================*/

Line 231: IF (PO_LOG.d_proc) THEN

227:
228: l_num_lines NUMBER;
229: l_line_action_tbl PO_TBL_VARCHAR5;
230: BEGIN
231: IF (PO_LOG.d_proc) THEN
232: PO_LOG.proc_begin(d_mod);
233: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
234: END IF;
235:

Line 232: PO_LOG.proc_begin(d_mod);

228: l_num_lines NUMBER;
229: l_line_action_tbl PO_TBL_VARCHAR5;
230: BEGIN
231: IF (PO_LOG.d_proc) THEN
232: PO_LOG.proc_begin(d_mod);
233: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
234: END IF;
235:
236: -- Get the number of lines being passed in.

Line 233: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);

229: l_line_action_tbl PO_TBL_VARCHAR5;
230: BEGIN
231: IF (PO_LOG.d_proc) THEN
232: PO_LOG.proc_begin(d_mod);
233: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
234: END IF;
235:
236: -- Get the number of lines being passed in.
237: l_num_lines := p_po_line_number_tbl.COUNT;

Line 259: IF (PO_LOG.d_proc) THEN

255: WHEN NO_DATA_FOUND THEN
256: l_line_action_tbl(i) := 'NEW';
257: END;
258: END LOOP;
259: IF (PO_LOG.d_proc) THEN
260: PO_LOG.proc_return(d_mod, l_line_action_tbl);
261: END IF;
262:
263: RETURN l_line_action_tbl;

Line 260: PO_LOG.proc_return(d_mod, l_line_action_tbl);

256: l_line_action_tbl(i) := 'NEW';
257: END;
258: END LOOP;
259: IF (PO_LOG.d_proc) THEN
260: PO_LOG.proc_return(d_mod, l_line_action_tbl);
261: END IF;
262:
263: RETURN l_line_action_tbl;
264:

Line 267: IF (PO_LOG.d_exc) THEN

263: RETURN l_line_action_tbl;
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: IF (PO_LOG.d_exc) THEN
268: PO_LOG.exc(d_mod, d_position, 'An error occured in get_line_action_tbl');
269: END IF;
270:
271: RAISE;

Line 268: PO_LOG.exc(d_mod, d_position, 'An error occured in get_line_action_tbl');

264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: IF (PO_LOG.d_exc) THEN
268: PO_LOG.exc(d_mod, d_position, 'An error occured in get_line_action_tbl');
269: END IF;
270:
271: RAISE;
272: END get_line_action_tbl;

Line 362: IF (PO_LOG.d_proc) THEN

358: WHERE key = c_key
359: AND index_num2 = c_po_line_num
360: AND index_num1 <> c_current_req_line_id;
361: BEGIN
362: IF (PO_LOG.d_proc) THEN
363: PO_LOG.proc_begin(d_mod);
364: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
365: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);

Line 363: PO_LOG.proc_begin(d_mod);

359: AND index_num2 = c_po_line_num
360: AND index_num1 <> c_current_req_line_id;
361: BEGIN
362: IF (PO_LOG.d_proc) THEN
363: PO_LOG.proc_begin(d_mod);
364: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
365: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
367: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);

Line 364: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);

360: AND index_num1 <> c_current_req_line_id;
361: BEGIN
362: IF (PO_LOG.d_proc) THEN
363: PO_LOG.proc_begin(d_mod);
364: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
365: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
367: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
368: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);

Line 365: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);

361: BEGIN
362: IF (PO_LOG.d_proc) THEN
363: PO_LOG.proc_begin(d_mod);
364: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
365: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
367: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
368: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
369: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);

Line 366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);

362: IF (PO_LOG.d_proc) THEN
363: PO_LOG.proc_begin(d_mod);
364: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
365: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
367: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
368: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
369: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
370: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);

Line 367: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);

363: PO_LOG.proc_begin(d_mod);
364: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
365: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
367: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
368: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
369: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
370: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
371: END IF;

Line 368: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);

364: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
365: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
367: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
368: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
369: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
370: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
371: END IF;
372:

Line 369: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);

365: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
367: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
368: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
369: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
370: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
371: END IF;
372:
373: -- Get the number of lines being passed in.

Line 370: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);

366: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
367: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
368: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
369: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
370: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
371: END IF;
372:
373: -- Get the number of lines being passed in.
374: l_num_lines := p_req_line_id_tbl.COUNT;

Line 550: IF (PO_LOG.d_proc) THEN

546: -- Clean up temp table
547: DELETE FROM po_session_gt
548: WHERE key = l_key;
549:
550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
552: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
553: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
554: END IF;

Line 551: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);

547: DELETE FROM po_session_gt
548: WHERE key = l_key;
549:
550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
552: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
553: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
554: END IF;
555:

Line 552: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);

548: WHERE key = l_key;
549:
550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
552: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
553: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
554: END IF;
555:
556: EXCEPTION

Line 553: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);

549:
550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
552: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
553: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
554: END IF;
555:
556: EXCEPTION
557: WHEN OTHERS THEN

Line 568: IF (PO_LOG.d_exc) THEN

564: THEN
565: CLOSE req_line_ids_csr;
566: END IF;
567:
568: IF (PO_LOG.d_exc) THEN
569: PO_LOG.exc(d_mod, d_position, 'An error occured in check_po_line_numbers');
570: END IF;
571:
572: RAISE;

Line 569: PO_LOG.exc(d_mod, d_position, 'An error occured in check_po_line_numbers');

565: CLOSE req_line_ids_csr;
566: END IF;
567:
568: IF (PO_LOG.d_exc) THEN
569: PO_LOG.exc(d_mod, d_position, 'An error occured in check_po_line_numbers');
570: END IF;
571:
572: RAISE;
573: END check_po_line_numbers;

Line 639: IF (PO_LOG.d_proc) THEN

635: d_position NUMBER := 0;
636:
637: l_token_value VARCHAR2(2000);
638: BEGIN
639: IF (PO_LOG.d_proc) THEN
640: PO_LOG.proc_begin(d_mod);
641: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
642: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
643: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);

Line 640: PO_LOG.proc_begin(d_mod);

636:
637: l_token_value VARCHAR2(2000);
638: BEGIN
639: IF (PO_LOG.d_proc) THEN
640: PO_LOG.proc_begin(d_mod);
641: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
642: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
643: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
644: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);

Line 641: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);

637: l_token_value VARCHAR2(2000);
638: BEGIN
639: IF (PO_LOG.d_proc) THEN
640: PO_LOG.proc_begin(d_mod);
641: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
642: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
643: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
644: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
645: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);

Line 642: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);

638: BEGIN
639: IF (PO_LOG.d_proc) THEN
640: PO_LOG.proc_begin(d_mod);
641: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
642: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
643: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
644: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
645: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
646: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);

Line 643: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);

639: IF (PO_LOG.d_proc) THEN
640: PO_LOG.proc_begin(d_mod);
641: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
642: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
643: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
644: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
645: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
646: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
647: END IF;

Line 644: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);

640: PO_LOG.proc_begin(d_mod);
641: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
642: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
643: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
644: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
645: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
646: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
647: END IF;
648:

Line 645: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);

641: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
642: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
643: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
644: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
645: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
646: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
647: END IF;
648:
649: lines_info_match(

Line 646: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);

642: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
643: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
644: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
645: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
646: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
647: END IF;
648:
649: lines_info_match(
650: p_agreement_id,

Line 675: IF (PO_LOG.d_proc) THEN

671: x_token_name,
672: x_token_value
673: );
674:
675: IF (PO_LOG.d_proc) THEN
676: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
677: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
678: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
679: END IF;

Line 676: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

672: x_token_value
673: );
674:
675: IF (PO_LOG.d_proc) THEN
676: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
677: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
678: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
679: END IF;
680: EXCEPTION

Line 677: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

673: );
674:
675: IF (PO_LOG.d_proc) THEN
676: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
677: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
678: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
679: END IF;
680: EXCEPTION
681: WHEN OTHERS THEN

Line 678: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

674:
675: IF (PO_LOG.d_proc) THEN
676: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
677: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
678: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
679: END IF;
680: EXCEPTION
681: WHEN OTHERS THEN
682: IF (PO_LOG.d_exc) THEN

Line 682: IF (PO_LOG.d_exc) THEN

678: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
679: END IF;
680: EXCEPTION
681: WHEN OTHERS THEN
682: IF (PO_LOG.d_exc) THEN
683: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_match');
684: END IF;
685:
686: RAISE;

Line 683: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_match');

679: END IF;
680: EXCEPTION
681: WHEN OTHERS THEN
682: IF (PO_LOG.d_exc) THEN
683: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_match');
684: END IF;
685:
686: RAISE;
687: END lines_match;

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

763: d_position NUMBER := 0;
764:
765: BEGIN
766:
767: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
768:
769: -- Initialize start and end indices to be first and last
770: -- indices in the input req line table (if they were not
771: -- specified in the input parameters).

Line 778: IF PO_LOG.d_stmt THEN

774: l_end_index := nvl(p_end_index, p_req_line_id_tbl.COUNT);
775:
776: d_position := 5;
777:
778: IF PO_LOG.d_stmt THEN
779: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
780: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
781: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
782: END IF;

Line 779: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);

775:
776: d_position := 5;
777:
778: IF PO_LOG.d_stmt THEN
779: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
780: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
781: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
782: END IF;
783:

Line 780: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);

776: d_position := 5;
777:
778: IF PO_LOG.d_stmt THEN
779: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
780: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
781: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
782: END IF;
783:
784: -- Clear PO line numbers from input table for those indices

Line 781: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);

777:
778: IF PO_LOG.d_stmt THEN
779: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
780: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
781: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
782: END IF;
783:
784: -- Clear PO line numbers from input table for those indices
785: -- which will be defaulted.

Line 856: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;

852: END IF;
853:
854: d_position := 60;
855:
856: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;
857:
858: return (x_po_line_num_tbl);
859:
860: EXCEPTION

Line 863: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

859:
860: EXCEPTION
861:
862: WHEN OTHERS THEN
863: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
864: RAISE;
865:
866: END group_req_lines;
867:

Line 942: IF (PO_LOG.d_proc) THEN

938: delivery_one PO_DELIVERY_INFO_CSR%ROWTYPE;
939: delivery_two PO_DELIVERY_INFO_CSR%ROWTYPE;
940:
941: BEGIN
942: IF (PO_LOG.d_proc) THEN
943: PO_LOG.proc_begin(d_mod);
944: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
945: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
946: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);

Line 943: PO_LOG.proc_begin(d_mod);

939: delivery_two PO_DELIVERY_INFO_CSR%ROWTYPE;
940:
941: BEGIN
942: IF (PO_LOG.d_proc) THEN
943: PO_LOG.proc_begin(d_mod);
944: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
945: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
946: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
947: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);

Line 944: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);

940:
941: BEGIN
942: IF (PO_LOG.d_proc) THEN
943: PO_LOG.proc_begin(d_mod);
944: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
945: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
946: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
947: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
948: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);

Line 945: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);

941: BEGIN
942: IF (PO_LOG.d_proc) THEN
943: PO_LOG.proc_begin(d_mod);
944: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
945: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
946: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
947: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
948: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
949: END IF;

Line 946: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);

942: IF (PO_LOG.d_proc) THEN
943: PO_LOG.proc_begin(d_mod);
944: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
945: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
946: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
947: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
948: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
949: END IF;
950:

Line 947: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);

943: PO_LOG.proc_begin(d_mod);
944: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
945: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
946: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
947: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
948: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
949: END IF;
950:
951: -- Get shipment-level profiles

Line 948: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);

944: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
945: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
946: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
947: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
948: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
949: END IF;
950:
951: -- Get shipment-level profiles
952: l_need_by_grouping_profile := fnd_profile.value('PO_NEED_BY_GROUPING');

Line 1009: IF (PO_LOG.d_proc) THEN

1005: END LOOP;
1006: CLOSE po_delivery_info_csr;
1007: END IF; -- if second line is a PO line
1008:
1009: IF (PO_LOG.d_proc) THEN
1010: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1011: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1012: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1013: END IF;

Line 1010: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1006: CLOSE po_delivery_info_csr;
1007: END IF; -- if second line is a PO line
1008:
1009: IF (PO_LOG.d_proc) THEN
1010: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1011: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1012: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1013: END IF;
1014:

Line 1011: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1007: END IF; -- if second line is a PO line
1008:
1009: IF (PO_LOG.d_proc) THEN
1010: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1011: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1012: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1013: END IF;
1014:
1015: EXCEPTION

Line 1012: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1008:
1009: IF (PO_LOG.d_proc) THEN
1010: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1011: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1012: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1013: END IF;
1014:
1015: EXCEPTION
1016: WHEN OTHERS THEN

Line 1023: IF (PO_LOG.d_exc) THEN

1019: THEN
1020: CLOSE po_delivery_info_csr;
1021: END IF;
1022:
1023: IF (PO_LOG.d_exc) THEN
1024: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_delivery_info_match');
1025: END IF;
1026:
1027: RAISE;

Line 1024: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_delivery_info_match');

1020: CLOSE po_delivery_info_csr;
1021: END IF;
1022:
1023: IF (PO_LOG.d_exc) THEN
1024: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_delivery_info_match');
1025: END IF;
1026:
1027: RAISE;
1028: END lines_delivery_info_match;

Line 1083: IF (PO_LOG.d_proc) THEN

1079: IS
1080: d_mod CONSTANT VARCHAR2(100) := D_check_delivery_info;
1081: d_position NUMBER := 0;
1082: BEGIN
1083: IF (PO_LOG.d_proc) THEN
1084: PO_LOG.proc_begin(d_mod);
1085: PO_LOG.proc_begin(d_mod,'p_need_by_grouping_profile',p_need_by_grouping_profile);
1086: PO_LOG.proc_begin(d_mod,'p_ship_to_grouping_profile',p_ship_to_grouping_profile);
1087: END IF;

Line 1084: PO_LOG.proc_begin(d_mod);

1080: d_mod CONSTANT VARCHAR2(100) := D_check_delivery_info;
1081: d_position NUMBER := 0;
1082: BEGIN
1083: IF (PO_LOG.d_proc) THEN
1084: PO_LOG.proc_begin(d_mod);
1085: PO_LOG.proc_begin(d_mod,'p_need_by_grouping_profile',p_need_by_grouping_profile);
1086: PO_LOG.proc_begin(d_mod,'p_ship_to_grouping_profile',p_ship_to_grouping_profile);
1087: END IF;
1088:

Line 1085: PO_LOG.proc_begin(d_mod,'p_need_by_grouping_profile',p_need_by_grouping_profile);

1081: d_position NUMBER := 0;
1082: BEGIN
1083: IF (PO_LOG.d_proc) THEN
1084: PO_LOG.proc_begin(d_mod);
1085: PO_LOG.proc_begin(d_mod,'p_need_by_grouping_profile',p_need_by_grouping_profile);
1086: PO_LOG.proc_begin(d_mod,'p_ship_to_grouping_profile',p_ship_to_grouping_profile);
1087: END IF;
1088:
1089: -- Initialize message code, token name, and token value to NULL

Line 1086: PO_LOG.proc_begin(d_mod,'p_ship_to_grouping_profile',p_ship_to_grouping_profile);

1082: BEGIN
1083: IF (PO_LOG.d_proc) THEN
1084: PO_LOG.proc_begin(d_mod);
1085: PO_LOG.proc_begin(d_mod,'p_need_by_grouping_profile',p_need_by_grouping_profile);
1086: PO_LOG.proc_begin(d_mod,'p_ship_to_grouping_profile',p_ship_to_grouping_profile);
1087: END IF;
1088:
1089: -- Initialize message code, token name, and token value to NULL
1090: x_message_code := NULL;

Line 1104: IF (PO_LOG.d_proc) THEN

1100: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1101: x_token_name := 'REASON_FOR_DIFF';
1102: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_NEED_BY');
1103:
1104: IF (PO_LOG.d_proc) THEN
1105: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1106: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1107: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1108: END IF;

Line 1105: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1101: x_token_name := 'REASON_FOR_DIFF';
1102: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_NEED_BY');
1103:
1104: IF (PO_LOG.d_proc) THEN
1105: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1106: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1107: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1108: END IF;
1109:

Line 1106: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1102: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_NEED_BY');
1103:
1104: IF (PO_LOG.d_proc) THEN
1105: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1106: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1107: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1108: END IF;
1109:
1110: RETURN;

Line 1107: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1103:
1104: IF (PO_LOG.d_proc) THEN
1105: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1106: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1107: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1108: END IF;
1109:
1110: RETURN;
1111: END IF;

Line 1125: IF (PO_LOG.d_proc) THEN

1121: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1122: x_token_name := 'REASON_FOR_DIFF';
1123: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_ORG');
1124:
1125: IF (PO_LOG.d_proc) THEN
1126: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1127: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1128: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1129: END IF;

Line 1126: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1122: x_token_name := 'REASON_FOR_DIFF';
1123: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_ORG');
1124:
1125: IF (PO_LOG.d_proc) THEN
1126: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1127: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1128: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1129: END IF;
1130:

Line 1127: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1123: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_ORG');
1124:
1125: IF (PO_LOG.d_proc) THEN
1126: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1127: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1128: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1129: END IF;
1130:
1131: RETURN;

Line 1128: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1124:
1125: IF (PO_LOG.d_proc) THEN
1126: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1127: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1128: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1129: END IF;
1130:
1131: RETURN;
1132: END IF;

Line 1143: IF (PO_LOG.d_proc) THEN

1139: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1140: x_token_name := 'REASON_FOR_DIFF';
1141: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_LOC');
1142:
1143: IF (PO_LOG.d_proc) THEN
1144: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1145: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1146: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1147: END IF;

Line 1144: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1140: x_token_name := 'REASON_FOR_DIFF';
1141: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_LOC');
1142:
1143: IF (PO_LOG.d_proc) THEN
1144: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1145: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1146: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1147: END IF;
1148:

Line 1145: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1141: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_LOC');
1142:
1143: IF (PO_LOG.d_proc) THEN
1144: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1145: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1146: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1147: END IF;
1148:
1149: RETURN;

Line 1146: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1142:
1143: IF (PO_LOG.d_proc) THEN
1144: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1145: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1146: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1147: END IF;
1148:
1149: RETURN;
1150: END IF;

Line 1162: IF (PO_LOG.d_proc) THEN

1158: x_message_code := 'PO_ALL_CANT_COMB_CONSIGNED';
1159: x_token_name := NULL;
1160: x_token_value := NULL;
1161:
1162: IF (PO_LOG.d_proc) THEN
1163: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1164: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1165: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1166: END IF;

Line 1163: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1159: x_token_name := NULL;
1160: x_token_value := NULL;
1161:
1162: IF (PO_LOG.d_proc) THEN
1163: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1164: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1165: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1166: END IF;
1167:

Line 1164: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1160: x_token_value := NULL;
1161:
1162: IF (PO_LOG.d_proc) THEN
1163: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1164: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1165: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1166: END IF;
1167:
1168: RETURN;

Line 1165: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1161:
1162: IF (PO_LOG.d_proc) THEN
1163: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1164: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1165: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1166: END IF;
1167:
1168: RETURN;
1169: END IF;

Line 1171: IF (PO_LOG.d_proc) THEN

1167:
1168: RETURN;
1169: END IF;
1170:
1171: IF (PO_LOG.d_proc) THEN
1172: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1173: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1174: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1175: END IF;

Line 1172: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1168: RETURN;
1169: END IF;
1170:
1171: IF (PO_LOG.d_proc) THEN
1172: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1173: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1174: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1175: END IF;
1176:

Line 1173: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1169: END IF;
1170:
1171: IF (PO_LOG.d_proc) THEN
1172: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1173: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1174: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1175: END IF;
1176:
1177: EXCEPTION

Line 1174: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1170:
1171: IF (PO_LOG.d_proc) THEN
1172: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1173: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1174: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1175: END IF;
1176:
1177: EXCEPTION
1178: WHEN OTHERS THEN

Line 1179: IF (PO_LOG.d_exc) THEN

1175: END IF;
1176:
1177: EXCEPTION
1178: WHEN OTHERS THEN
1179: IF (PO_LOG.d_exc) THEN
1180: PO_LOG.exc(d_mod, d_position, 'An error occured in check_delivery_info');
1181: END IF;
1182:
1183: RAISE;

Line 1180: PO_LOG.exc(d_mod, d_position, 'An error occured in check_delivery_info');

1176:
1177: EXCEPTION
1178: WHEN OTHERS THEN
1179: IF (PO_LOG.d_exc) THEN
1180: PO_LOG.exc(d_mod, d_position, 'An error occured in check_delivery_info');
1181: END IF;
1182:
1183: RAISE;
1184: END check_delivery_info;

Line 1225: IF (PO_LOG.d_proc) THEN

1221:
1222: l_req_line_delivery_info PO_DELIVERY_INFO_CSR%ROWTYPE;
1223: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
1224: BEGIN
1225: IF (PO_LOG.d_proc) THEN
1226: PO_LOG.proc_begin(d_mod);
1227: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1228: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1229: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);

Line 1226: PO_LOG.proc_begin(d_mod);

1222: l_req_line_delivery_info PO_DELIVERY_INFO_CSR%ROWTYPE;
1223: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
1224: BEGIN
1225: IF (PO_LOG.d_proc) THEN
1226: PO_LOG.proc_begin(d_mod);
1227: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1228: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1229: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1230: END IF;

Line 1227: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);

1223: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
1224: BEGIN
1225: IF (PO_LOG.d_proc) THEN
1226: PO_LOG.proc_begin(d_mod);
1227: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1228: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1229: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1230: END IF;
1231:

Line 1228: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);

1224: BEGIN
1225: IF (PO_LOG.d_proc) THEN
1226: PO_LOG.proc_begin(d_mod);
1227: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1228: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1229: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1230: END IF;
1231:
1232: SELECT PRL.item_id,

Line 1229: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);

1225: IF (PO_LOG.d_proc) THEN
1226: PO_LOG.proc_begin(d_mod);
1227: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1228: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1229: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1230: END IF;
1231:
1232: SELECT PRL.item_id,
1233: PRL.need_by_date,

Line 1257: IF (PO_LOG.d_proc) THEN

1253: Added the 'NULL' parameter in the beginning in the place of org id.
1254: Moved the l_req_line_delivery_info.ship_to_organization_id parameter to end. This is inventory org id.
1255: These changes are driven by the changes done to the function PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag. */
1256:
1257: IF (PO_LOG.d_proc) THEN
1258: PO_LOG.proc_end(d_mod);
1259: END IF;
1260:
1261: RETURN l_req_line_delivery_info;

Line 1258: PO_LOG.proc_end(d_mod);

1254: Moved the l_req_line_delivery_info.ship_to_organization_id parameter to end. This is inventory org id.
1255: These changes are driven by the changes done to the function PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag. */
1256:
1257: IF (PO_LOG.d_proc) THEN
1258: PO_LOG.proc_end(d_mod);
1259: END IF;
1260:
1261: RETURN l_req_line_delivery_info;
1262:

Line 1265: IF (PO_LOG.d_exc) THEN

1261: RETURN l_req_line_delivery_info;
1262:
1263: EXCEPTION
1264: WHEN OTHERS THEN
1265: IF (PO_LOG.d_exc) THEN
1266: PO_LOG.exc(d_mod, d_position, 'An error occured in get_req_line_delivery_info');
1267: END IF;
1268:
1269: RAISE;

Line 1266: PO_LOG.exc(d_mod, d_position, 'An error occured in get_req_line_delivery_info');

1262:
1263: EXCEPTION
1264: WHEN OTHERS THEN
1265: IF (PO_LOG.d_exc) THEN
1266: PO_LOG.exc(d_mod, d_position, 'An error occured in get_req_line_delivery_info');
1267: END IF;
1268:
1269: RAISE;
1270: END get_req_line_delivery_info;

Line 1334: IF (PO_LOG.d_proc) THEN

1330:
1331: l_line_one LINE_INFO;
1332: l_line_two LINE_INFO;
1333: BEGIN
1334: IF (PO_LOG.d_proc) THEN
1335: PO_LOG.proc_begin(d_mod);
1336: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1337: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1338: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);

Line 1335: PO_LOG.proc_begin(d_mod);

1331: l_line_one LINE_INFO;
1332: l_line_two LINE_INFO;
1333: BEGIN
1334: IF (PO_LOG.d_proc) THEN
1335: PO_LOG.proc_begin(d_mod);
1336: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1337: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1338: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1339: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);

Line 1336: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);

1332: l_line_two LINE_INFO;
1333: BEGIN
1334: IF (PO_LOG.d_proc) THEN
1335: PO_LOG.proc_begin(d_mod);
1336: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1337: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1338: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1339: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
1340: END IF;

Line 1337: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);

1333: BEGIN
1334: IF (PO_LOG.d_proc) THEN
1335: PO_LOG.proc_begin(d_mod);
1336: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1337: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1338: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1339: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
1340: END IF;
1341:

Line 1338: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);

1334: IF (PO_LOG.d_proc) THEN
1335: PO_LOG.proc_begin(d_mod);
1336: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1337: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1338: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1339: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
1340: END IF;
1341:
1342: -- Retrieve all lines matching attributes for p_req_line_id

Line 1339: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);

1335: PO_LOG.proc_begin(d_mod);
1336: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1337: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1338: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1339: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
1340: END IF;
1341:
1342: -- Retrieve all lines matching attributes for p_req_line_id
1343: l_line_one := get_req_line_info(p_req_line_id);

Line 1365: IF (PO_LOG.d_proc) THEN

1361: x_token_name,
1362: x_token_value
1363: );
1364:
1365: IF (PO_LOG.d_proc) THEN
1366: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1367: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1368: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1369: END IF;

Line 1366: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1362: x_token_value
1363: );
1364:
1365: IF (PO_LOG.d_proc) THEN
1366: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1367: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1368: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1369: END IF;
1370:

Line 1367: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1363: );
1364:
1365: IF (PO_LOG.d_proc) THEN
1366: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1367: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1368: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1369: END IF;
1370:
1371: EXCEPTION

Line 1368: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1364:
1365: IF (PO_LOG.d_proc) THEN
1366: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1367: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1368: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1369: END IF;
1370:
1371: EXCEPTION
1372: WHEN OTHERS THEN

Line 1373: IF (PO_LOG.d_exc) THEN

1369: END IF;
1370:
1371: EXCEPTION
1372: WHEN OTHERS THEN
1373: IF (PO_LOG.d_exc) THEN
1374: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
1375: END IF;
1376:
1377: RAISE;

Line 1374: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');

1370:
1371: EXCEPTION
1372: WHEN OTHERS THEN
1373: IF (PO_LOG.d_exc) THEN
1374: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
1375: END IF;
1376:
1377: RAISE;
1378: END lines_info_match;

Line 1410: IF (PO_LOG.d_proc) THEN

1406: d_position NUMBER := 0;
1407:
1408: l_req_line_info LINE_INFO;
1409: BEGIN
1410: IF (PO_LOG.d_proc) THEN
1411: PO_LOG.proc_begin(d_mod);
1412: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1413: END IF;
1414:

Line 1411: PO_LOG.proc_begin(d_mod);

1407:
1408: l_req_line_info LINE_INFO;
1409: BEGIN
1410: IF (PO_LOG.d_proc) THEN
1411: PO_LOG.proc_begin(d_mod);
1412: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1413: END IF;
1414:
1415: SELECT PRL.item_id,

Line 1412: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);

1408: l_req_line_info LINE_INFO;
1409: BEGIN
1410: IF (PO_LOG.d_proc) THEN
1411: PO_LOG.proc_begin(d_mod);
1412: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1413: END IF;
1414:
1415: SELECT PRL.item_id,
1416: PRL.item_description,

Line 1452: IF (PO_LOG.d_proc) THEN

1448: WHERE PRL.requisition_line_id = p_req_line_id
1449: AND SRC_DOC_LINE.po_header_id(+) = PRL.blanket_po_header_id
1450: AND SRC_DOC_LINE.line_num(+) = PRL.blanket_po_line_num;
1451:
1452: IF (PO_LOG.d_proc) THEN
1453: PO_LOG.proc_end(d_mod);
1454: END IF;
1455:
1456: RETURN l_req_line_info;

Line 1453: PO_LOG.proc_end(d_mod);

1449: AND SRC_DOC_LINE.po_header_id(+) = PRL.blanket_po_header_id
1450: AND SRC_DOC_LINE.line_num(+) = PRL.blanket_po_line_num;
1451:
1452: IF (PO_LOG.d_proc) THEN
1453: PO_LOG.proc_end(d_mod);
1454: END IF;
1455:
1456: RETURN l_req_line_info;
1457:

Line 1460: IF (PO_LOG.d_exc) THEN

1456: RETURN l_req_line_info;
1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: IF (PO_LOG.d_exc) THEN
1461: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
1462: END IF;
1463:
1464: RAISE;

Line 1461: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');

1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: IF (PO_LOG.d_exc) THEN
1461: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
1462: END IF;
1463:
1464: RAISE;
1465: END get_req_line_info;

Line 1497: IF (PO_LOG.d_proc) THEN

1493: d_position NUMBER := 0;
1494:
1495: l_po_line_info LINE_INFO;
1496: BEGIN
1497: IF (PO_LOG.d_proc) THEN
1498: PO_LOG.proc_begin(d_mod);
1499: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
1500: END IF;
1501:

Line 1498: PO_LOG.proc_begin(d_mod);

1494:
1495: l_po_line_info LINE_INFO;
1496: BEGIN
1497: IF (PO_LOG.d_proc) THEN
1498: PO_LOG.proc_begin(d_mod);
1499: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
1500: END IF;
1501:
1502: SELECT item_id,

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

1495: l_po_line_info LINE_INFO;
1496: BEGIN
1497: IF (PO_LOG.d_proc) THEN
1498: PO_LOG.proc_begin(d_mod);
1499: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
1500: END IF;
1501:
1502: SELECT item_id,
1503: item_description,

Line 1521: IF (PO_LOG.d_proc) THEN

1517: INTO l_po_line_info
1518: FROM po_lines_all
1519: WHERE po_line_id = p_po_line_id;
1520:
1521: IF (PO_LOG.d_proc) THEN
1522: PO_LOG.proc_end(d_mod);
1523: END IF;
1524:
1525: RETURN l_po_line_info;

Line 1522: PO_LOG.proc_end(d_mod);

1518: FROM po_lines_all
1519: WHERE po_line_id = p_po_line_id;
1520:
1521: IF (PO_LOG.d_proc) THEN
1522: PO_LOG.proc_end(d_mod);
1523: END IF;
1524:
1525: RETURN l_po_line_info;
1526:

Line 1529: IF (PO_LOG.d_exc) THEN

1525: RETURN l_po_line_info;
1526:
1527: EXCEPTION
1528: WHEN OTHERS THEN
1529: IF (PO_LOG.d_exc) THEN
1530: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
1531: END IF;
1532:
1533: RAISE;

Line 1530: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');

1526:
1527: EXCEPTION
1528: WHEN OTHERS THEN
1529: IF (PO_LOG.d_exc) THEN
1530: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
1531: END IF;
1532:
1533: RAISE;
1534: END get_po_line_info;

Line 1584: IF (PO_LOG.d_proc) THEN

1580: IS
1581: d_mod CONSTANT VARCHAR2(100) := D_check_line_info;
1582: d_position NUMBER := 0;
1583: BEGIN
1584: IF (PO_LOG.d_proc) THEN
1585: PO_LOG.proc_begin(d_mod);
1586: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1587: END IF;
1588:

Line 1585: PO_LOG.proc_begin(d_mod);

1581: d_mod CONSTANT VARCHAR2(100) := D_check_line_info;
1582: d_position NUMBER := 0;
1583: BEGIN
1584: IF (PO_LOG.d_proc) THEN
1585: PO_LOG.proc_begin(d_mod);
1586: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1587: END IF;
1588:
1589: -- Initialize message code, token name, and token value to NULL

Line 1586: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);

1582: d_position NUMBER := 0;
1583: BEGIN
1584: IF (PO_LOG.d_proc) THEN
1585: PO_LOG.proc_begin(d_mod);
1586: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1587: END IF;
1588:
1589: -- Initialize message code, token name, and token value to NULL
1590: x_message_code := NULL;

Line 1606: IF (PO_LOG.d_proc) THEN

1602: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1603: x_token_name := 'REASON_FOR_DIFF';
1604: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEMS');
1605:
1606: IF (PO_LOG.d_proc) THEN
1607: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1608: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1609: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1610: END IF;

Line 1607: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1603: x_token_name := 'REASON_FOR_DIFF';
1604: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEMS');
1605:
1606: IF (PO_LOG.d_proc) THEN
1607: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1608: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1609: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1610: END IF;
1611:

Line 1608: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1604: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEMS');
1605:
1606: IF (PO_LOG.d_proc) THEN
1607: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1608: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1609: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1610: END IF;
1611:
1612: RETURN;

Line 1609: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1605:
1606: IF (PO_LOG.d_proc) THEN
1607: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1608: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1609: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1610: END IF;
1611:
1612: RETURN;
1613: END IF;

Line 1623: IF (PO_LOG.d_proc) THEN

1619: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1620: x_token_name := 'REASON_FOR_DIFF';
1621: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEM_REVISION');
1622:
1623: IF (PO_LOG.d_proc) THEN
1624: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1625: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1626: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1627: END IF;

Line 1624: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1620: x_token_name := 'REASON_FOR_DIFF';
1621: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEM_REVISION');
1622:
1623: IF (PO_LOG.d_proc) THEN
1624: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1625: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1626: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1627: END IF;
1628:

Line 1625: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1621: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEM_REVISION');
1622:
1623: IF (PO_LOG.d_proc) THEN
1624: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1625: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1626: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1627: END IF;
1628:
1629: RETURN;

Line 1626: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1622:
1623: IF (PO_LOG.d_proc) THEN
1624: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1625: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1626: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1627: END IF;
1628:
1629: RETURN;
1630: END IF;

Line 1651: IF (PO_LOG.d_proc) THEN

1647: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1648: x_token_name := 'REASON_FOR_DIFF';
1649: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_LINE_TYPE');
1650:
1651: IF (PO_LOG.d_proc) THEN
1652: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1653: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1654: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1655: END IF;

Line 1652: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1648: x_token_name := 'REASON_FOR_DIFF';
1649: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_LINE_TYPE');
1650:
1651: IF (PO_LOG.d_proc) THEN
1652: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1653: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1654: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1655: END IF;
1656:

Line 1653: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1649: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_LINE_TYPE');
1650:
1651: IF (PO_LOG.d_proc) THEN
1652: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1653: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1654: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1655: END IF;
1656:
1657: RETURN;

Line 1654: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1650:
1651: IF (PO_LOG.d_proc) THEN
1652: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1653: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1654: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1655: END IF;
1656:
1657: RETURN;
1658: END IF;

Line 1668: IF (PO_LOG.d_proc) THEN

1664: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1665: x_token_name := 'REASON_FOR_DIFF';
1666: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PREF_GRADE');
1667:
1668: IF (PO_LOG.d_proc) THEN
1669: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1670: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1671: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1672: END IF;

Line 1669: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1665: x_token_name := 'REASON_FOR_DIFF';
1666: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PREF_GRADE');
1667:
1668: IF (PO_LOG.d_proc) THEN
1669: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1670: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1671: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1672: END IF;
1673:

Line 1670: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1666: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PREF_GRADE');
1667:
1668: IF (PO_LOG.d_proc) THEN
1669: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1670: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1671: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1672: END IF;
1673:
1674: RETURN;

Line 1671: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1667:
1668: IF (PO_LOG.d_proc) THEN
1669: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1670: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1671: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1672: END IF;
1673:
1674: RETURN;
1675: END IF;

Line 1685: IF (PO_LOG.d_proc) THEN

1681: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1682: x_token_name := 'REASON_FOR_DIFF';
1683: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PRI_UOM');
1684:
1685: IF (PO_LOG.d_proc) THEN
1686: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1687: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1688: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1689: END IF;

Line 1686: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1682: x_token_name := 'REASON_FOR_DIFF';
1683: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PRI_UOM');
1684:
1685: IF (PO_LOG.d_proc) THEN
1686: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1687: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1688: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1689: END IF;
1690:

Line 1687: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1683: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PRI_UOM');
1684:
1685: IF (PO_LOG.d_proc) THEN
1686: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1687: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1688: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1689: END IF;
1690:
1691: RETURN;

Line 1688: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1684:
1685: IF (PO_LOG.d_proc) THEN
1686: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1687: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1688: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1689: END IF;
1690:
1691: RETURN;
1692: END IF;

Line 1702: IF (PO_LOG.d_proc) THEN

1698: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1699: x_token_name := 'REASON_FOR_DIFF';
1700: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_TRANS_REASON');
1701:
1702: IF (PO_LOG.d_proc) THEN
1703: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1704: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1705: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1706: END IF;

Line 1703: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1699: x_token_name := 'REASON_FOR_DIFF';
1700: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_TRANS_REASON');
1701:
1702: IF (PO_LOG.d_proc) THEN
1703: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1704: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1705: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1706: END IF;
1707:

Line 1704: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1700: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_TRANS_REASON');
1701:
1702: IF (PO_LOG.d_proc) THEN
1703: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1704: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1705: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1706: END IF;
1707:
1708: RETURN;

Line 1705: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1701:
1702: IF (PO_LOG.d_proc) THEN
1703: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1704: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1705: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1706: END IF;
1707:
1708: RETURN;
1709: END IF;

Line 1717: IF (PO_LOG.d_proc) THEN

1713: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1714: x_token_name := 'REASON_FOR_DIFF';
1715: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CONTRACT');
1716:
1717: IF (PO_LOG.d_proc) THEN
1718: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1719: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1720: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1721: END IF;

Line 1718: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1714: x_token_name := 'REASON_FOR_DIFF';
1715: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CONTRACT');
1716:
1717: IF (PO_LOG.d_proc) THEN
1718: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1719: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1720: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1721: END IF;
1722:

Line 1719: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1715: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CONTRACT');
1716:
1717: IF (PO_LOG.d_proc) THEN
1718: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1719: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1720: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1721: END IF;
1722:
1723: RETURN;

Line 1720: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1716:
1717: IF (PO_LOG.d_proc) THEN
1718: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1719: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1720: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1721: END IF;
1722:
1723: RETURN;
1724: END IF;

Line 1739: IF (PO_LOG.d_proc) THEN

1735: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1736: x_token_name := 'REASON_FOR_DIFF';
1737: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SRC_NUM');
1738:
1739: IF (PO_LOG.d_proc) THEN
1740: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1741: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1742: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1743: END IF;

Line 1740: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1736: x_token_name := 'REASON_FOR_DIFF';
1737: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SRC_NUM');
1738:
1739: IF (PO_LOG.d_proc) THEN
1740: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1741: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1742: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1743: END IF;
1744:

Line 1741: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1737: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SRC_NUM');
1738:
1739: IF (PO_LOG.d_proc) THEN
1740: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1741: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1742: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1743: END IF;
1744:
1745: RETURN;

Line 1742: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1738:
1739: IF (PO_LOG.d_proc) THEN
1740: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1741: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1742: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1743: END IF;
1744:
1745: RETURN;
1746: END IF;

Line 1754: IF (PO_LOG.d_proc) THEN

1750: x_message_code := 'PO_ALL_CANT_COMB_CANCLD_LINE';
1751: x_token_name := NULL;
1752: x_token_value := NULL;
1753:
1754: IF (PO_LOG.d_proc) THEN
1755: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1756: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1757: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1758: END IF;

Line 1755: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1751: x_token_name := NULL;
1752: x_token_value := NULL;
1753:
1754: IF (PO_LOG.d_proc) THEN
1755: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1756: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1757: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1758: END IF;
1759:

Line 1756: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1752: x_token_value := NULL;
1753:
1754: IF (PO_LOG.d_proc) THEN
1755: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1756: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1757: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1758: END IF;
1759:
1760: RETURN;

Line 1757: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1753:
1754: IF (PO_LOG.d_proc) THEN
1755: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1756: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1757: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1758: END IF;
1759:
1760: RETURN;
1761: END IF;

Line 1769: IF (PO_LOG.d_proc) THEN

1765: x_message_code := 'PO_ALL_CANT_COMB_FCLOSED_LINE';
1766: x_token_name := NULL;
1767: x_token_value := NULL;
1768:
1769: IF (PO_LOG.d_proc) THEN
1770: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1771: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1772: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1773: END IF;

Line 1770: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1766: x_token_name := NULL;
1767: x_token_value := NULL;
1768:
1769: IF (PO_LOG.d_proc) THEN
1770: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1771: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1772: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1773: END IF;
1774:

Line 1771: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1767: x_token_value := NULL;
1768:
1769: IF (PO_LOG.d_proc) THEN
1770: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1771: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1772: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1773: END IF;
1774:
1775: RETURN;

Line 1772: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1768:
1769: IF (PO_LOG.d_proc) THEN
1770: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1771: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1772: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1773: END IF;
1774:
1775: RETURN;
1776: END IF;

Line 1786: IF (PO_LOG.d_proc) THEN

1782: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
1783: x_token_name := 'REASON_FOR_DIFF';
1784: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SUPPLIER_REF_NUMBER');
1785:
1786: IF (PO_LOG.d_proc) THEN
1787: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1788: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1789: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1790: END IF;

Line 1787: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1783: x_token_name := 'REASON_FOR_DIFF';
1784: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SUPPLIER_REF_NUMBER');
1785:
1786: IF (PO_LOG.d_proc) THEN
1787: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1788: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1789: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1790: END IF;
1791:

Line 1788: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1784: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SUPPLIER_REF_NUMBER');
1785:
1786: IF (PO_LOG.d_proc) THEN
1787: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1788: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1789: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1790: END IF;
1791:
1792: RETURN;

Line 1789: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1785:
1786: IF (PO_LOG.d_proc) THEN
1787: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1788: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1789: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1790: END IF;
1791:
1792: RETURN;
1793: END IF;

Line 1795: IF (PO_LOG.d_proc) THEN

1791:
1792: RETURN;
1793: END IF;
1794:
1795: IF (PO_LOG.d_proc) THEN
1796: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1797: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1798: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1799: END IF;

Line 1796: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);

1792: RETURN;
1793: END IF;
1794:
1795: IF (PO_LOG.d_proc) THEN
1796: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1797: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1798: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1799: END IF;
1800:

Line 1797: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);

1793: END IF;
1794:
1795: IF (PO_LOG.d_proc) THEN
1796: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1797: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1798: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1799: END IF;
1800:
1801: EXCEPTION

Line 1798: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);

1794:
1795: IF (PO_LOG.d_proc) THEN
1796: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1797: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1798: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1799: END IF;
1800:
1801: EXCEPTION
1802: WHEN OTHERS THEN

Line 1803: IF (PO_LOG.d_exc) THEN

1799: END IF;
1800:
1801: EXCEPTION
1802: WHEN OTHERS THEN
1803: IF (PO_LOG.d_exc) THEN
1804: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
1805: END IF;
1806:
1807: RAISE;

Line 1804: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');

1800:
1801: EXCEPTION
1802: WHEN OTHERS THEN
1803: IF (PO_LOG.d_exc) THEN
1804: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
1805: END IF;
1806:
1807: RAISE;
1808: END check_line_info;

Line 1864: IF PO_LOG.d_proc THEN

1860: d_position NUMBER := 0;
1861:
1862: BEGIN
1863:
1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
1868: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);

Line 1865: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);

1861:
1862: BEGIN
1863:
1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
1868: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
1869: END IF;

Line 1866: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);

1862: BEGIN
1863:
1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
1868: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
1869: END IF;
1870:

Line 1867: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);

1863:
1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
1868: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
1869: END IF;
1870:
1871: -- Initialize the l_line_num_used_tbl to indicate which line

Line 1868: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);

1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
1868: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
1869: END IF;
1870:
1871: -- Initialize the l_line_num_used_tbl to indicate which line
1872: -- numbers are already assigned. We will mark a 'Y' in the associative

Line 1901: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;

1897: END IF;
1898: END LOOP;
1899:
1900: d_position := 50;
1901: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;
1902:
1903: return (x_po_line_num_tbl);
1904:
1905: EXCEPTION

Line 1908: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

1904:
1905: EXCEPTION
1906:
1907: WHEN OTHERS THEN
1908: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
1909: RAISE;
1910:
1911: END group_by_requisition_line_num;
1912:

Line 1990: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

1986:
1987: EXCEPTION
1988:
1989: WHEN OTHERS THEN
1990: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
1991: RAISE;
1992:
1993: END group_by_requisition_seq_num;
1994:

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

2060: d_position NUMBER := 0;
2061:
2062: BEGIN
2063:
2064: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
2065:
2066: -- Initialize the max PO line number.
2067: --
2068: l_max_line_num := get_max_po_line_num ( p_po_line_num_tbl

Line 2071: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_max_line_num',l_max_line_num); END IF;

2067: --
2068: l_max_line_num := get_max_po_line_num ( p_po_line_num_tbl
2069: , p_add_to_po_header_id );
2070:
2071: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_max_line_num',l_max_line_num); END IF;
2072:
2073: d_position := 10;
2074:
2075: -- Get nested tables of requisition lines and their corresponding

Line 2106: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Add To PO Line Num',l_po_line_num); END IF;

2102: ( p_req_line_id => p_req_line_id_tbl(i)
2103: , p_comparison_tbl => l_add_to_po_req_line_id_tbl
2104: , p_po_line_num_tbl => l_add_to_po_line_num_tbl
2105: );
2106: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Add To PO Line Num',l_po_line_num); END IF;
2107: END IF;
2108:
2109: d_position := 40;
2110:

Line 2122: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Builder Line Num',l_po_line_num); END IF;

2118: , p_req_line_id_tbl => p_req_line_id_tbl
2119: , p_po_line_num_tbl => x_po_line_num_tbl
2120: , p_builder_agreement_id => p_builder_agreement_id
2121: );
2122: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Builder Line Num',l_po_line_num); END IF;
2123: END IF;
2124:
2125: d_position := 50;
2126:

Line 2136: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Max Line Num',l_po_line_num); END IF;

2132: THEN
2133: l_max_line_num := l_max_line_num + 1;
2134: l_po_line_num := l_max_line_num;
2135:
2136: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Max Line Num',l_po_line_num); END IF;
2137: END IF;
2138:
2139: d_position := 60;
2140:

Line 2147: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;

2143: END LOOP;
2144:
2145: d_position := 70;
2146:
2147: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;
2148:
2149: return (x_po_line_num_tbl);
2150:
2151: EXCEPTION

Line 2154: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

2150:
2151: EXCEPTION
2152:
2153: WHEN OTHERS THEN
2154: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2155: RAISE;
2156:
2157: END group_by_default;
2158:

Line 2220: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,FALSE); END IF;

2216: l_first_req_header_id := l_req_header_id;
2217:
2218: ELSIF ( l_req_header_id <> l_first_req_header_id ) THEN
2219:
2220: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,FALSE); END IF;
2221: return (FALSE); -- return false if header does not match
2222:
2223: END IF;
2224:

Line 2227: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,TRUE); END IF;

2223: END IF;
2224:
2225: END LOOP;
2226:
2227: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,TRUE); END IF;
2228: return (TRUE);
2229:
2230: EXCEPTION
2231:

Line 2233: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

2229:
2230: EXCEPTION
2231:
2232: WHEN OTHERS THEN
2233: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2234: RAISE;
2235:
2236: END has_same_req_header;
2237:

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

2302: d_position NUMBER := 0;
2303:
2304: BEGIN
2305:
2306: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
2307:
2308: -- Return immediately if there is no Add To PO.
2309: --
2310: IF ( p_add_to_po_header_id IS NULL )

Line 2329: IF PO_LOG.d_stmt THEN

2325: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');
2326: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
2327:
2328: d_position := 20;
2329: IF PO_LOG.d_stmt THEN
2330: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
2331: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
2332: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
2333: END IF;

Line 2330: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);

2326: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
2327:
2328: d_position := 20;
2329: IF PO_LOG.d_stmt THEN
2330: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
2331: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
2332: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
2333: END IF;
2334:

Line 2331: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);

2327:
2328: d_position := 20;
2329: IF PO_LOG.d_stmt THEN
2330: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
2331: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
2332: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
2333: END IF;
2334:
2335: -- Bulk insert matching lines into GT table.

Line 2332: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);

2328: d_position := 20;
2329: IF PO_LOG.d_stmt THEN
2330: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
2331: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
2332: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
2333: END IF;
2334:
2335: -- Bulk insert matching lines into GT table.
2336: --

Line 2402: IF PO_LOG.d_proc THEN

2398: WHERE key = l_key
2399: RETURNING num1, num2
2400: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl;
2401:
2402: IF PO_LOG.d_proc THEN
2403: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
2404: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
2405: END IF;
2406:

Line 2403: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);

2399: RETURNING num1, num2
2400: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl;
2401:
2402: IF PO_LOG.d_proc THEN
2403: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
2404: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
2405: END IF;
2406:
2407: EXCEPTION

Line 2404: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);

2400: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl;
2401:
2402: IF PO_LOG.d_proc THEN
2403: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
2404: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
2405: END IF;
2406:
2407: EXCEPTION
2408:

Line 2410: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

2406:
2407: EXCEPTION
2408:
2409: WHEN OTHERS THEN
2410: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2411: RAISE;
2412:
2413: END match_add_to_po_lines;
2414:

Line 2480: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

2476:
2477: EXCEPTION
2478:
2479: WHEN OTHERS THEN
2480: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2481: RAISE;
2482:
2483: END find_matching_builder_line_num;
2484:

Line 2529: IF PO_LOG.d_proc THEN

2525: d_position NUMBER := 0;
2526:
2527: BEGIN
2528:
2529: IF PO_LOG.d_proc THEN
2530: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2531: PO_LOG.proc_begin(d_mod,'p_req_line_id_1',p_req_line_id_1);
2532: PO_LOG.proc_begin(d_mod,'p_req_line_id_2',p_req_line_id_2);
2533: END IF;

Line 2530: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);

2526:
2527: BEGIN
2528:
2529: IF PO_LOG.d_proc THEN
2530: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2531: PO_LOG.proc_begin(d_mod,'p_req_line_id_1',p_req_line_id_1);
2532: PO_LOG.proc_begin(d_mod,'p_req_line_id_2',p_req_line_id_2);
2533: END IF;
2534:

Line 2531: PO_LOG.proc_begin(d_mod,'p_req_line_id_1',p_req_line_id_1);

2527: BEGIN
2528:
2529: IF PO_LOG.d_proc THEN
2530: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2531: PO_LOG.proc_begin(d_mod,'p_req_line_id_1',p_req_line_id_1);
2532: PO_LOG.proc_begin(d_mod,'p_req_line_id_2',p_req_line_id_2);
2533: END IF;
2534:
2535: -- Make a call to lines_match to determine if all relevant attributes

Line 2532: PO_LOG.proc_begin(d_mod,'p_req_line_id_2',p_req_line_id_2);

2528:
2529: IF PO_LOG.d_proc THEN
2530: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2531: PO_LOG.proc_begin(d_mod,'p_req_line_id_1',p_req_line_id_1);
2532: PO_LOG.proc_begin(d_mod,'p_req_line_id_2',p_req_line_id_2);
2533: END IF;
2534:
2535: -- Make a call to lines_match to determine if all relevant attributes
2536: -- match. Note that we do not need Supplier/Site since we do not need

Line 2549: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_message_code',l_message_code); END IF;

2545: , x_message_code => l_message_code
2546: , x_token_name => l_token_name
2547: , x_token_value => l_token_value
2548: );
2549: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_message_code',l_message_code); END IF;
2550:
2551: IF ( l_message_code IS NULL )
2552: THEN
2553: l_result := TRUE;

Line 2558: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,l_result); END IF;

2554: ELSE
2555: l_result := FALSE;
2556: END IF;
2557:
2558: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,l_result); END IF;
2559:
2560: return (l_result);
2561:
2562: EXCEPTION

Line 2565: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

2561:
2562: EXCEPTION
2563:
2564: WHEN OTHERS THEN
2565: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2566: RAISE;
2567:
2568: END req_lines_match;
2569:

Line 2608: IF PO_LOG.d_proc THEN

2604: d_position NUMBER := 0;
2605:
2606: BEGIN
2607:
2608: IF PO_LOG.d_proc THEN
2609: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
2610: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
2611: END IF;
2612:

Line 2609: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);

2605:
2606: BEGIN
2607:
2608: IF PO_LOG.d_proc THEN
2609: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
2610: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
2611: END IF;
2612:
2613: -- Find max line number for the input PO.

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

2606: BEGIN
2607:
2608: IF PO_LOG.d_proc THEN
2609: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
2610: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
2611: END IF;
2612:
2613: -- Find max line number for the input PO.
2614: --

Line 2640: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

2636:
2637: EXCEPTION
2638:
2639: WHEN OTHERS THEN
2640: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2641: RAISE;
2642:
2643: END get_max_po_line_num;
2644:

Line 2691: IF PO_LOG.d_proc THEN

2687: d_position NUMBER := 0;
2688:
2689: BEGIN
2690:
2691: IF PO_LOG.d_proc THEN
2692: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
2693: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
2694: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
2695: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);

Line 2692: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);

2688:
2689: BEGIN
2690:
2691: IF PO_LOG.d_proc THEN
2692: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
2693: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
2694: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
2695: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);
2696: END IF;

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

2689: BEGIN
2690:
2691: IF PO_LOG.d_proc THEN
2692: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
2693: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
2694: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
2695: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);
2696: END IF;
2697:

Line 2694: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);

2690:
2691: IF PO_LOG.d_proc THEN
2692: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
2693: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
2694: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
2695: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);
2696: END IF;
2697:
2698: x_consigned_flag_tbl.EXTEND(p_req_line_id_tbl.COUNT);

Line 2695: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);

2691: IF PO_LOG.d_proc THEN
2692: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
2693: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
2694: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
2695: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);
2696: END IF;
2697:
2698: x_consigned_flag_tbl.EXTEND(p_req_line_id_tbl.COUNT);
2699:

Line 2707: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_item_id',l_item_id); END IF;

2703: INTO l_item_id
2704: FROM po_requisition_lines_all
2705: WHERE requisition_line_id = p_req_line_id_tbl(i);
2706:
2707: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_item_id',l_item_id); END IF;
2708:
2709: x_consigned_flag_tbl(i) := PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag
2710: ( p_builder_org_id
2711: , l_item_id

Line 2722: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_consigned_flag_tbl); END IF;

2718: These changes are driven by the changes done to the function PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag. */
2719:
2720: END LOOP;
2721:
2722: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_consigned_flag_tbl); END IF;
2723:
2724: return (x_consigned_flag_tbl);
2725:
2726: EXCEPTION

Line 2729: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

2725:
2726: EXCEPTION
2727:
2728: WHEN OTHERS THEN
2729: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2730: RAISE;
2731:
2732: END get_consigned_flag_tbl;
2733:

Line 2789: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;

2785:
2786: EXCEPTION
2787:
2788: WHEN OTHERS THEN
2789: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2790: RAISE;
2791:
2792: END find_matching_po_line_num;
2793: