[Home] [Help]
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_check_neg_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_neg_line_numbers');
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_check_neg_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_neg_line_numbers');
13: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
14: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
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_check_neg_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_neg_line_numbers');
13: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
14: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
15: D_group_neg_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_neg_req_lines');
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_check_neg_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_neg_line_numbers');
13: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
14: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
15: D_group_neg_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_neg_req_lines');
16: D_group_clm_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_clm_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_check_neg_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_neg_line_numbers');
13: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
14: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
15: D_group_neg_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_neg_req_lines');
16: D_group_clm_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_clm_req_lines');
17: D_group_by_clm_req_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_seq_num');
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_check_neg_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_neg_line_numbers');
13: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
14: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
15: D_group_neg_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_neg_req_lines');
16: D_group_clm_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_clm_req_lines');
17: D_group_by_clm_req_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_seq_num');
18: D_group_by_clm_req_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_line_num');
11: D_check_po_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_po_line_numbers');
12: D_check_neg_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_neg_line_numbers');
13: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
14: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
15: D_group_neg_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_neg_req_lines');
16: D_group_clm_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_clm_req_lines');
17: D_group_by_clm_req_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_seq_num');
18: D_group_by_clm_req_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_line_num');
19: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
12: D_check_neg_line_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_neg_line_numbers');
13: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
14: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
15: D_group_neg_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_neg_req_lines');
16: D_group_clm_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_clm_req_lines');
17: D_group_by_clm_req_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_seq_num');
18: D_group_by_clm_req_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_line_num');
19: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
20: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
13: D_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_match');
14: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
15: D_group_neg_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_neg_req_lines');
16: D_group_clm_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_clm_req_lines');
17: D_group_by_clm_req_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_seq_num');
18: D_group_by_clm_req_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_line_num');
19: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
20: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
21: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
14: D_group_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_req_lines');
15: D_group_neg_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_neg_req_lines');
16: D_group_clm_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_clm_req_lines');
17: D_group_by_clm_req_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_seq_num');
18: D_group_by_clm_req_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_line_num');
19: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
20: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
21: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
22: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
15: D_group_neg_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_neg_req_lines');
16: D_group_clm_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_clm_req_lines');
17: D_group_by_clm_req_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_seq_num');
18: D_group_by_clm_req_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_line_num');
19: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
20: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
21: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
22: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
23: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
16: D_group_clm_req_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_clm_req_lines');
17: D_group_by_clm_req_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_seq_num');
18: D_group_by_clm_req_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_line_num');
19: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
20: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
21: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
22: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
23: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
24: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
17: D_group_by_clm_req_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_seq_num');
18: D_group_by_clm_req_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_line_num');
19: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
20: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
21: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
22: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
23: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
24: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
25: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
18: D_group_by_clm_req_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_clm_req_line_num');
19: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
20: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
21: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
22: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
23: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
24: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
25: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
26: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
19: D_get_req_line_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_delivery_info');
20: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
21: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
22: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
23: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
24: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
25: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
26: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
27: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
20: D_check_delivery_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_delivery_info');
21: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
22: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
23: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
24: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
25: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
26: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
27: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
28: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
21: D_lines_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_info_match');
22: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
23: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
24: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
25: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
26: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
27: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
28: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
29: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
22: D_get_req_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_req_line_info');
23: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
24: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
25: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
26: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
27: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
28: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
29: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
30: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
23: D_get_po_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_line_info');
24: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
25: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
26: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
27: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
28: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
29: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
30: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
31: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
24: D_check_line_info CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_line_info');
25: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
26: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
27: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
28: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
29: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
30: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
31: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
32: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
25: D_lines_delivery_info_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'lines_delivery_info_match');
26: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
27: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
28: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
29: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
30: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
31: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
32: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
33: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
26: D_group_by_requisition_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_line_num');
27: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
28: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
29: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
30: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
31: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
32: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
33: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
34: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
27: D_group_by_requisition_seq_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_requisition_seq_num');
28: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
29: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
30: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
31: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
32: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
33: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
34: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
35: D_get_max_clm_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_clm_po_line_num');
28: D_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'group_by_default');
29: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
30: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
31: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
32: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
33: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
34: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
35: D_get_max_clm_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_clm_po_line_num');
36: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
29: D_has_same_req_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'has_same_req_header');
30: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
31: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
32: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
33: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
34: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
35: D_get_max_clm_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_clm_po_line_num');
36: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
37: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
30: D_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_add_to_po_lines');
31: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
32: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
33: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
34: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
35: D_get_max_clm_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_clm_po_line_num');
36: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
37: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
38: D_default_info_slin_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'default_info_slin_numbers');
31: D_find_matching_builder_index CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_index');
32: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
33: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
34: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
35: D_get_max_clm_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_clm_po_line_num');
36: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
37: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
38: D_default_info_slin_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'default_info_slin_numbers');
39: D_check_mod_lock_availability CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_mod_lock_availability');
32: D_find_matching_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_builder_line_num');
33: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
34: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
35: D_get_max_clm_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_clm_po_line_num');
36: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
37: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
38: D_default_info_slin_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'default_info_slin_numbers');
39: D_check_mod_lock_availability CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_mod_lock_availability');
40: D_clm_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_group_by_default');
33: D_req_lines_match CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'req_lines_match');
34: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
35: D_get_max_clm_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_clm_po_line_num');
36: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
37: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
38: D_default_info_slin_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'default_info_slin_numbers');
39: D_check_mod_lock_availability CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_mod_lock_availability');
40: D_clm_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_group_by_default');
41: D_clm_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_match_add_to_po_lines');
34: D_get_max_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_po_line_num');
35: D_get_max_clm_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_clm_po_line_num');
36: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
37: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
38: D_default_info_slin_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'default_info_slin_numbers');
39: D_check_mod_lock_availability CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_mod_lock_availability');
40: D_clm_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_group_by_default');
41: D_clm_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_match_add_to_po_lines');
42: D_clm_find_match_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_find_match_builder_linenum');
35: D_get_max_clm_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_max_clm_po_line_num');
36: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
37: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
38: D_default_info_slin_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'default_info_slin_numbers');
39: D_check_mod_lock_availability CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_mod_lock_availability');
40: D_clm_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_group_by_default');
41: D_clm_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_match_add_to_po_lines');
42: D_clm_find_match_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_find_match_builder_linenum');
43: D_get_line_num_disp_for_clin CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_num_disp_for_clin');
36: D_get_consigned_flag_tbl CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag_tbl');
37: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
38: D_default_info_slin_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'default_info_slin_numbers');
39: D_check_mod_lock_availability CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_mod_lock_availability');
40: D_clm_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_group_by_default');
41: D_clm_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_match_add_to_po_lines');
42: D_clm_find_match_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_find_match_builder_linenum');
43: D_get_line_num_disp_for_clin CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_num_disp_for_clin');
44: D_RenumberSlins CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'RenumberSlins');
37: D_find_matching_po_line_num CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'find_matching_po_line_num');
38: D_default_info_slin_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'default_info_slin_numbers');
39: D_check_mod_lock_availability CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_mod_lock_availability');
40: D_clm_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_group_by_default');
41: D_clm_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_match_add_to_po_lines');
42: D_clm_find_match_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_find_match_builder_linenum');
43: D_get_line_num_disp_for_clin CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_num_disp_for_clin');
44: D_RenumberSlins CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'RenumberSlins');
45: --bug 13622501
38: D_default_info_slin_numbers CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'default_info_slin_numbers');
39: D_check_mod_lock_availability CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_mod_lock_availability');
40: D_clm_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_group_by_default');
41: D_clm_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_match_add_to_po_lines');
42: D_clm_find_match_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_find_match_builder_linenum');
43: D_get_line_num_disp_for_clin CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_num_disp_for_clin');
44: D_RenumberSlins CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'RenumberSlins');
45: --bug 13622501
46: D_get_po_linenum_for_shipment CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_linenum_for_shipment');
39: D_check_mod_lock_availability CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_mod_lock_availability');
40: D_clm_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_group_by_default');
41: D_clm_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_match_add_to_po_lines');
42: D_clm_find_match_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_find_match_builder_linenum');
43: D_get_line_num_disp_for_clin CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_num_disp_for_clin');
44: D_RenumberSlins CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'RenumberSlins');
45: --bug 13622501
46: D_get_po_linenum_for_shipment CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_linenum_for_shipment');
47: -- bug#16097884
40: D_clm_group_by_default CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_group_by_default');
41: D_clm_match_add_to_po_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_match_add_to_po_lines');
42: D_clm_find_match_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_find_match_builder_linenum');
43: D_get_line_num_disp_for_clin CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_num_disp_for_clin');
44: D_RenumberSlins CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'RenumberSlins');
45: --bug 13622501
46: D_get_po_linenum_for_shipment CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_linenum_for_shipment');
47: -- bug#16097884
48: D_check_item_description CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_item_description');
42: D_clm_find_match_builder_line CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_find_match_builder_linenum');
43: D_get_line_num_disp_for_clin CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_line_num_disp_for_clin');
44: D_RenumberSlins CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'RenumberSlins');
45: --bug 13622501
46: D_get_po_linenum_for_shipment CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_linenum_for_shipment');
47: -- bug#16097884
48: D_check_item_description CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_item_description');
49:
50:
44: D_RenumberSlins CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'RenumberSlins');
45: --bug 13622501
46: D_get_po_linenum_for_shipment CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_po_linenum_for_shipment');
47: -- bug#16097884
48: D_check_item_description CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_item_description');
49:
50:
51: /*=========================================================================*/
52: /*===================== SPECIFICATIONS (PRIVATE) ==========================*/
345:
346: l_num_lines NUMBER;
347: l_line_action_tbl PO_TBL_VARCHAR5;
348: BEGIN
349: IF (PO_LOG.d_proc) THEN
350: PO_LOG.proc_begin(d_mod);
351: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
352: END IF;
353:
346: l_num_lines NUMBER;
347: l_line_action_tbl PO_TBL_VARCHAR5;
348: BEGIN
349: IF (PO_LOG.d_proc) THEN
350: PO_LOG.proc_begin(d_mod);
351: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
352: END IF;
353:
354: -- Get the number of lines being passed in.
347: l_line_action_tbl PO_TBL_VARCHAR5;
348: BEGIN
349: IF (PO_LOG.d_proc) THEN
350: PO_LOG.proc_begin(d_mod);
351: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
352: END IF;
353:
354: -- Get the number of lines being passed in.
355: l_num_lines := p_po_line_number_tbl.COUNT;
374: WHEN NO_DATA_FOUND THEN
375: l_line_action_tbl(i) := 'NEW';
376: END;
377: END LOOP;
378: IF (PO_LOG.d_proc) THEN
379: PO_LOG.proc_return(d_mod, l_line_action_tbl);
380: END IF;
381:
382: RETURN l_line_action_tbl;
375: l_line_action_tbl(i) := 'NEW';
376: END;
377: END LOOP;
378: IF (PO_LOG.d_proc) THEN
379: PO_LOG.proc_return(d_mod, l_line_action_tbl);
380: END IF;
381:
382: RETURN l_line_action_tbl;
383:
382: RETURN l_line_action_tbl;
383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: IF (PO_LOG.d_exc) THEN
387: PO_LOG.exc(d_mod, d_position, 'An error occured in get_line_action_tbl');
388: END IF;
389:
390: RAISE;
383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: IF (PO_LOG.d_exc) THEN
387: PO_LOG.exc(d_mod, d_position, 'An error occured in get_line_action_tbl');
388: END IF;
389:
390: RAISE;
391: END get_line_action_tbl;
478: WHERE key = c_key
479: AND index_num2 = c_po_line_num
480: AND index_num1 <> c_current_req_line_id;
481: BEGIN
482: IF (PO_LOG.d_proc) THEN
483: PO_LOG.proc_begin(d_mod);
484: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
485: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
486: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
479: AND index_num2 = c_po_line_num
480: AND index_num1 <> c_current_req_line_id;
481: BEGIN
482: IF (PO_LOG.d_proc) THEN
483: PO_LOG.proc_begin(d_mod);
484: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
485: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
486: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
487: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
480: AND index_num1 <> c_current_req_line_id;
481: BEGIN
482: IF (PO_LOG.d_proc) THEN
483: PO_LOG.proc_begin(d_mod);
484: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
485: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
486: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
487: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
488: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
481: BEGIN
482: IF (PO_LOG.d_proc) THEN
483: PO_LOG.proc_begin(d_mod);
484: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
485: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
486: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
487: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
488: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
489: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
482: IF (PO_LOG.d_proc) THEN
483: PO_LOG.proc_begin(d_mod);
484: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
485: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
486: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
487: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
488: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
489: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
490: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
483: PO_LOG.proc_begin(d_mod);
484: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
485: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
486: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
487: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
488: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
489: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
490: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
491: END IF;
484: PO_LOG.proc_begin(d_mod,'p_style_id',p_style_id);
485: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
486: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
487: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
488: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
489: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
490: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
491: END IF;
492:
485: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
486: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
487: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
488: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
489: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
490: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
491: END IF;
492:
493: -- Get the number of lines being passed in.
486: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
487: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
488: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
489: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
490: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
491: END IF;
492:
493: -- Get the number of lines being passed in.
494: l_num_lines := p_req_line_id_tbl.COUNT;
672: -- Clean up temp table
673: DELETE FROM po_session_gt
674: WHERE key = l_key;
675:
676: IF (PO_LOG.d_proc) THEN
677: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
678: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
679: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
680: END IF;
673: DELETE FROM po_session_gt
674: WHERE key = l_key;
675:
676: IF (PO_LOG.d_proc) THEN
677: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
678: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
679: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
680: END IF;
681:
674: WHERE key = l_key;
675:
676: IF (PO_LOG.d_proc) THEN
677: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
678: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
679: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
680: END IF;
681:
682: EXCEPTION
675:
676: IF (PO_LOG.d_proc) THEN
677: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
678: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
679: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
680: END IF;
681:
682: EXCEPTION
683: WHEN OTHERS THEN
690: THEN
691: CLOSE req_line_ids_csr;
692: END IF;
693:
694: IF (PO_LOG.d_exc) THEN
695: PO_LOG.exc(d_mod, d_position, 'An error occured in check_po_line_numbers');
696: END IF;
697:
698: RAISE;
691: CLOSE req_line_ids_csr;
692: END IF;
693:
694: IF (PO_LOG.d_exc) THEN
695: PO_LOG.exc(d_mod, d_position, 'An error occured in check_po_line_numbers');
696: END IF;
697:
698: RAISE;
699: END check_po_line_numbers;
740: message_suffix VARCHAR2(2);
741: sol_ship_to_location_id PON_AUCTION_ITEM_PRICES_ALL.ship_to_location_id%TYPE;
742: sol_line_orig_code PON_AUCTION_ITEM_PRICES_ALL.LINE_ORIGINATION_CODE%TYPE;
743: BEGIN
744: IF (PO_LOG.d_proc) THEN
745: PO_LOG.proc_begin(d_mod);
746: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
747: PO_LOG.proc_begin(d_mod,'p_sol_line_number_tbl',p_sol_line_number_tbl);
748: END IF;
741: sol_ship_to_location_id PON_AUCTION_ITEM_PRICES_ALL.ship_to_location_id%TYPE;
742: sol_line_orig_code PON_AUCTION_ITEM_PRICES_ALL.LINE_ORIGINATION_CODE%TYPE;
743: BEGIN
744: IF (PO_LOG.d_proc) THEN
745: PO_LOG.proc_begin(d_mod);
746: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
747: PO_LOG.proc_begin(d_mod,'p_sol_line_number_tbl',p_sol_line_number_tbl);
748: END IF;
749:
742: sol_line_orig_code PON_AUCTION_ITEM_PRICES_ALL.LINE_ORIGINATION_CODE%TYPE;
743: BEGIN
744: IF (PO_LOG.d_proc) THEN
745: PO_LOG.proc_begin(d_mod);
746: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
747: PO_LOG.proc_begin(d_mod,'p_sol_line_number_tbl',p_sol_line_number_tbl);
748: END IF;
749:
750: -- Get the number of lines being passed in.
743: BEGIN
744: IF (PO_LOG.d_proc) THEN
745: PO_LOG.proc_begin(d_mod);
746: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
747: PO_LOG.proc_begin(d_mod,'p_sol_line_number_tbl',p_sol_line_number_tbl);
748: END IF;
749:
750: -- Get the number of lines being passed in.
751: l_num_lines := p_req_line_id_tbl.COUNT;
978:
979: EXCEPTION
980: WHEN OTHERS THEN
981:
982: IF (PO_LOG.d_exc) THEN
983: PO_LOG.exc(d_mod, d_position, 'An error occured in check_neg_line_numbers');
984: END IF;
985:
986: RAISE;
979: EXCEPTION
980: WHEN OTHERS THEN
981:
982: IF (PO_LOG.d_exc) THEN
983: PO_LOG.exc(d_mod, d_position, 'An error occured in check_neg_line_numbers');
984: END IF;
985:
986: RAISE;
987: END check_neg_line_numbers;
1052: d_position NUMBER := 0;
1053:
1054: l_token_value VARCHAR2(2000);
1055: BEGIN
1056: IF (PO_LOG.d_proc) THEN
1057: PO_LOG.proc_begin(d_mod);
1058: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1059: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1060: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1053:
1054: l_token_value VARCHAR2(2000);
1055: BEGIN
1056: IF (PO_LOG.d_proc) THEN
1057: PO_LOG.proc_begin(d_mod);
1058: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1059: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1060: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1061: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1054: l_token_value VARCHAR2(2000);
1055: BEGIN
1056: IF (PO_LOG.d_proc) THEN
1057: PO_LOG.proc_begin(d_mod);
1058: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1059: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1060: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1061: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1062: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1055: BEGIN
1056: IF (PO_LOG.d_proc) THEN
1057: PO_LOG.proc_begin(d_mod);
1058: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1059: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1060: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1061: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1062: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1063: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
1056: IF (PO_LOG.d_proc) THEN
1057: PO_LOG.proc_begin(d_mod);
1058: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1059: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1060: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1061: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1062: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1063: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
1064: END IF;
1057: PO_LOG.proc_begin(d_mod);
1058: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1059: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1060: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1061: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1062: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1063: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
1064: END IF;
1065:
1058: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
1059: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1060: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1061: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1062: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1063: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
1064: END IF;
1065:
1066: lines_info_match(
1059: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1060: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1061: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
1062: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
1063: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
1064: END IF;
1065:
1066: lines_info_match(
1067: p_agreement_id,
1091: x_token_name,
1092: x_token_value
1093: );
1094:
1095: IF (PO_LOG.d_proc) THEN
1096: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1097: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1098: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1099: END IF;
1092: x_token_value
1093: );
1094:
1095: IF (PO_LOG.d_proc) THEN
1096: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1097: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1098: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1099: END IF;
1100: EXCEPTION
1093: );
1094:
1095: IF (PO_LOG.d_proc) THEN
1096: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1097: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1098: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1099: END IF;
1100: EXCEPTION
1101: WHEN OTHERS THEN
1094:
1095: IF (PO_LOG.d_proc) THEN
1096: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
1097: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
1098: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1099: END IF;
1100: EXCEPTION
1101: WHEN OTHERS THEN
1102: IF (PO_LOG.d_exc) THEN
1098: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
1099: END IF;
1100: EXCEPTION
1101: WHEN OTHERS THEN
1102: IF (PO_LOG.d_exc) THEN
1103: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_match');
1104: END IF;
1105:
1106: RAISE;
1099: END IF;
1100: EXCEPTION
1101: WHEN OTHERS THEN
1102: IF (PO_LOG.d_exc) THEN
1103: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_match');
1104: END IF;
1105:
1106: RAISE;
1107: END lines_match;
1187: BEGIN
1188:
1189: l_grouping_method := p_grouping_method;
1190:
1191: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
1192:
1193: -- Initialize start and end indices to be first and last
1194: -- indices in the input req line table (if they were not
1195: -- specified in the input parameters).
1198: l_end_index := nvl(p_end_index, p_req_line_id_tbl.COUNT);
1199:
1200: d_position := 5;
1201:
1202: IF PO_LOG.d_stmt THEN
1203: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1204: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1205: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1206: END IF;
1199:
1200: d_position := 5;
1201:
1202: IF PO_LOG.d_stmt THEN
1203: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1204: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1205: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1206: END IF;
1207:
1200: d_position := 5;
1201:
1202: IF PO_LOG.d_stmt THEN
1203: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1204: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1205: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1206: END IF;
1207:
1208: -- Clear PO line numbers from input table for those indices
1201:
1202: IF PO_LOG.d_stmt THEN
1203: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1204: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1205: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1206: END IF;
1207:
1208: -- Clear PO line numbers from input table for those indices
1209: -- which will be defaulted.
1276: END IF;
1277:
1278: d_position := 60;
1279:
1280: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;
1281:
1282: return (x_po_line_num_tbl);
1283:
1284: EXCEPTION
1283:
1284: EXCEPTION
1285:
1286: WHEN OTHERS THEN
1287: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
1288: RAISE;
1289:
1290: END group_req_lines;
1291:
1380:
1381: l_grouping_method := p_grouping_method;
1382:
1383:
1384: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
1385:
1386: -- Initialize start and end indices to be first and last
1387: -- indices in the input req line table (if they were not
1388: -- specified in the input parameters).
1392: l_renumber_flag.extend(p_req_line_id_tbl.Count);
1393:
1394: d_position := 5;
1395:
1396: IF PO_LOG.d_stmt THEN
1397: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1398: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1399: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1400: END IF;
1393:
1394: d_position := 5;
1395:
1396: IF PO_LOG.d_stmt THEN
1397: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1398: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1399: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1400: END IF;
1401:
1394: d_position := 5;
1395:
1396: IF PO_LOG.d_stmt THEN
1397: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1398: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1399: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1400: END IF;
1401:
1402: d_position := 10;
1395:
1396: IF PO_LOG.d_stmt THEN
1397: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1398: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1399: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1400: END IF;
1401:
1402: d_position := 10;
1403: -- Clear PO line numbers from input table for those indices
1503: , l_end_index
1504: , p_po_line_num_tbl --IN OUT
1505: );
1506:
1507: IF PO_LOG.d_stmt THEN
1508: PO_LOG.stmt(d_mod,d_position,'p_po_line_num_tbl',p_po_line_num_tbl);
1509: END IF;
1510:
1511: -- In case of default po line number flow,renumber flag is passed as Y
1504: , p_po_line_num_tbl --IN OUT
1505: );
1506:
1507: IF PO_LOG.d_stmt THEN
1508: PO_LOG.stmt(d_mod,d_position,'p_po_line_num_tbl',p_po_line_num_tbl);
1509: END IF;
1510:
1511: -- In case of default po line number flow,renumber flag is passed as Y
1512: -- for all the lines in the range ( between p_start_index and p_end_index )
1528: );
1529:
1530: d_position := 55;
1531:
1532: IF PO_LOG.d_stmt THEN
1533: PO_LOG.stmt(d_mod,d_position,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
1534: END IF;
1535:
1536: --Renumber all Slins based on the po_line_num and
1529:
1530: d_position := 55;
1531:
1532: IF PO_LOG.d_stmt THEN
1533: PO_LOG.stmt(d_mod,d_position,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
1534: END IF;
1535:
1536: --Renumber all Slins based on the po_line_num and
1537: --po_line_num_disp(for clins) derived above
1549: );
1550:
1551: d_position := 58;
1552:
1553: IF PO_LOG.d_stmt THEN
1554: PO_LOG.stmt(d_mod,d_position,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
1555: END IF;
1556:
1557: /* Autocreate grouping end */
1550:
1551: d_position := 58;
1552:
1553: IF PO_LOG.d_stmt THEN
1554: PO_LOG.stmt(d_mod,d_position,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
1555: END IF;
1556:
1557: /* Autocreate grouping end */
1558: END IF;
1559:
1560:
1561: d_position := 60;
1562:
1563: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,p_po_line_num_tbl); END IF;
1564:
1565:
1566: EXCEPTION
1567:
1565:
1566: EXCEPTION
1567:
1568: WHEN OTHERS THEN
1569: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
1570: RAISE;
1571:
1572: END group_clm_req_lines;
1573:
1662:
1663: l_grouping_method := p_grouping_method;
1664:
1665:
1666: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
1667:
1668: -- Initialize start and end indices to be first and last
1669: -- indices in the input req line table (if they were not
1670: -- specified in the input parameters).
1674: l_renumber_flag.extend(p_req_line_id_tbl.Count);
1675:
1676: d_position := 5;
1677:
1678: IF PO_LOG.d_stmt THEN
1679: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1680: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1681: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1682: END IF;
1675:
1676: d_position := 5;
1677:
1678: IF PO_LOG.d_stmt THEN
1679: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1680: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1681: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1682: END IF;
1683:
1676: d_position := 5;
1677:
1678: IF PO_LOG.d_stmt THEN
1679: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1680: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1681: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1682: END IF;
1683:
1684: d_position := 10;
1677:
1678: IF PO_LOG.d_stmt THEN
1679: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1680: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1681: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1682: END IF;
1683:
1684: d_position := 10;
1685: -- Clear PO line numbers from input table for those indices
1715: , l_end_index
1716: , p_neg_line_num_tbl --IN OUT
1717: );
1718:
1719: IF PO_LOG.d_stmt THEN
1720: PO_LOG.stmt(d_mod,d_position,'p_neg_line_num_tbl',p_neg_line_num_tbl);
1721: END IF;
1722:
1723: -- In case of default po line number flow,renumber flag is passed as Y
1716: , p_neg_line_num_tbl --IN OUT
1717: );
1718:
1719: IF PO_LOG.d_stmt THEN
1720: PO_LOG.stmt(d_mod,d_position,'p_neg_line_num_tbl',p_neg_line_num_tbl);
1721: END IF;
1722:
1723: -- In case of default po line number flow,renumber flag is passed as Y
1724: -- for all the lines in the range ( between p_start_index and p_end_index )
1740: );
1741:
1742: d_position := 25;
1743:
1744: IF PO_LOG.d_stmt THEN
1745: PO_LOG.stmt(d_mod,d_position,'p_neg_line_num_disp_tbl',p_neg_line_num_disp_tbl);
1746: END IF;
1747:
1748: --Renumber all Slins based on the po_line_num and
1741:
1742: d_position := 25;
1743:
1744: IF PO_LOG.d_stmt THEN
1745: PO_LOG.stmt(d_mod,d_position,'p_neg_line_num_disp_tbl',p_neg_line_num_disp_tbl);
1746: END IF;
1747:
1748: --Renumber all Slins based on the po_line_num and
1749: --po_line_num_disp(for clins) derived above
1761: );
1762:
1763: d_position := 28;
1764:
1765: IF PO_LOG.d_stmt THEN
1766: PO_LOG.stmt(d_mod,d_position,'p_neg_line_num_disp_tbl',p_neg_line_num_disp_tbl);
1767: END IF;
1768:
1769: d_position := 30;
1762:
1763: d_position := 28;
1764:
1765: IF PO_LOG.d_stmt THEN
1766: PO_LOG.stmt(d_mod,d_position,'p_neg_line_num_disp_tbl',p_neg_line_num_disp_tbl);
1767: END IF;
1768:
1769: d_position := 30;
1770:
1767: END IF;
1768:
1769: d_position := 30;
1770:
1771: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,p_neg_line_num_tbl); END IF;
1772:
1773:
1774: EXCEPTION
1775:
1773:
1774: EXCEPTION
1775:
1776: WHEN OTHERS THEN
1777: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
1778: RAISE;
1779:
1780: END group_clm_sol_req_lines;
1781:
1869:
1870: l_grouping_method := p_grouping_method;
1871:
1872:
1873: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
1874:
1875: -- Initialize start and end indices to be first and last
1876: -- indices in the input req line table (if they were not
1877: -- specified in the input parameters).
1881: l_renumber_flag.extend(p_req_line_id_tbl.Count);
1882:
1883: d_position := 5;
1884:
1885: IF PO_LOG.d_stmt THEN
1886: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1887: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1888: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1889: END IF;
1882:
1883: d_position := 5;
1884:
1885: IF PO_LOG.d_stmt THEN
1886: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1887: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1888: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1889: END IF;
1890:
1883: d_position := 5;
1884:
1885: IF PO_LOG.d_stmt THEN
1886: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1887: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1888: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1889: END IF;
1890:
1891: d_position := 10;
1884:
1885: IF PO_LOG.d_stmt THEN
1886: PO_LOG.stmt(d_mod,d_position,'l_start_index',l_start_index);
1887: PO_LOG.stmt(d_mod,d_position,'l_end_index',l_end_index);
1888: PO_LOG.stmt(d_mod,d_position,'p_grouping_method',p_grouping_method);
1889: END IF;
1890:
1891: d_position := 10;
1892: -- Clear PO line numbers from input table for those indices
1922: , l_end_index
1923: , p_neg_line_num_tbl --IN OUT
1924: );
1925:
1926: IF PO_LOG.d_stmt THEN
1927: PO_LOG.stmt(d_mod,d_position,'p_neg_line_num_tbl',p_neg_line_num_tbl);
1928: END IF;
1929:
1930: -- In case of default po line number flow,renumber flag is passed as Y
1923: , p_neg_line_num_tbl --IN OUT
1924: );
1925:
1926: IF PO_LOG.d_stmt THEN
1927: PO_LOG.stmt(d_mod,d_position,'p_neg_line_num_tbl',p_neg_line_num_tbl);
1928: END IF;
1929:
1930: -- In case of default po line number flow,renumber flag is passed as Y
1931: -- for all the lines in the range ( between p_start_index and p_end_index )
1935:
1936:
1937: d_position := 30;
1938:
1939: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,p_neg_line_num_tbl); END IF;
1940:
1941:
1942: EXCEPTION
1943:
1941:
1942: EXCEPTION
1943:
1944: WHEN OTHERS THEN
1945: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
1946: RAISE;
1947:
1948: END group_neg_req_lines;
1949:
2009:
2010: BEGIN
2011:
2012: --x_po_line_num_disp_tbl.extend(p_po_line_num_tbl.Count);
2013: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
2014:
2015: -- Initialize the max PO line number.
2016:
2017: l_max_line_num := get_max_po_line_num ( p_po_line_num_tbl
2019: , p_draft_id
2020: );
2021:
2022:
2023: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_max_line_num',l_max_line_num); END IF;
2024:
2025: d_position := 10;
2026:
2027: -- Get nested tables of requisition lines and their corresponding
2080: l_index := l_index + 1;
2081: END IF;
2082:
2083:
2084: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Add To PO Line Num',l_po_line_num); END IF;
2085: END IF;
2086: END IF;
2087:
2088: d_position := 40;
2108: , p_builder_agreement_id => p_builder_agreement_id
2109: );
2110: /* Autocreate grouping end */
2111:
2112: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Builder Line Num',l_po_line_num); END IF;
2113: END IF;
2114: END IF;
2115:
2116: d_position := 50;
2123: THEN
2124: l_max_line_num := l_max_line_num + 1;
2125: l_po_line_num := l_max_line_num;
2126:
2127: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Max Line Num',l_po_line_num); END IF;
2128: END IF;
2129:
2130:
2131: d_position := 60;
2135:
2136: d_position := 70;
2137:
2138:
2139: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;
2140: p_po_line_num_tbl := x_po_line_num_tbl;
2141:
2142: EXCEPTION
2143:
2141:
2142: EXCEPTION
2143:
2144: WHEN OTHERS THEN
2145: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2146: RAISE;
2147:
2148: END clm_group_by_default;
2149:
2207:
2208: BEGIN
2209:
2210: --x_po_line_num_disp_tbl.extend(p_po_line_num_tbl.Count);
2211: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
2212:
2213: -- Initialize the max PO line number.
2214:
2215: SELECT Max(LINE_NUMBER) INTO l_max_line_num FROM pon_auction_item_prices_all WHERE AUCTION_HEADER_ID = p_draft_id;
2215: SELECT Max(LINE_NUMBER) INTO l_max_line_num FROM pon_auction_item_prices_all WHERE AUCTION_HEADER_ID = p_draft_id;
2216:
2217:
2218:
2219: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_max_line_num',l_max_line_num); END IF;
2220:
2221: d_position := 10;
2222:
2223:
2246: , p_builder_agreement_id => p_builder_agreement_id
2247: );
2248: /* Autocreate grouping end */
2249:
2250: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Builder Line Num',l_neg_line_num); END IF;
2251: END IF;
2252:
2253:
2254: d_position := 50;
2261: THEN
2262: l_max_line_num := l_max_line_num + 1;
2263: l_neg_line_num := l_max_line_num;
2264:
2265: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Max Line Num',l_neg_line_num); END IF;
2266: END IF;
2267:
2268:
2269: d_position := 60;
2273:
2274: d_position := 70;
2275:
2276:
2277: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_neg_line_num_tbl); END IF;
2278: p_neg_line_num_tbl := x_neg_line_num_tbl;
2279:
2280: EXCEPTION
2281:
2279:
2280: EXCEPTION
2281:
2282: WHEN OTHERS THEN
2283: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2284: RAISE;
2285:
2286: END clm_group_sol_by_default;
2287:
2336:
2337: EXCEPTION
2338:
2339: WHEN OTHERS THEN
2340: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
2341: RAISE;
2342:
2343: END clm_find_match_builder_linenum;
2344:
2416: delivery_one PO_DELIVERY_INFO_CSR%ROWTYPE;
2417: delivery_two PO_DELIVERY_INFO_CSR%ROWTYPE;
2418:
2419: BEGIN
2420: IF (PO_LOG.d_proc) THEN
2421: PO_LOG.proc_begin(d_mod);
2422: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2423: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2424: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2417: delivery_two PO_DELIVERY_INFO_CSR%ROWTYPE;
2418:
2419: BEGIN
2420: IF (PO_LOG.d_proc) THEN
2421: PO_LOG.proc_begin(d_mod);
2422: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2423: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2424: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2425: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2418:
2419: BEGIN
2420: IF (PO_LOG.d_proc) THEN
2421: PO_LOG.proc_begin(d_mod);
2422: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2423: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2424: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2425: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2426: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2419: BEGIN
2420: IF (PO_LOG.d_proc) THEN
2421: PO_LOG.proc_begin(d_mod);
2422: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2423: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2424: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2425: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2426: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2427: END IF;
2420: IF (PO_LOG.d_proc) THEN
2421: PO_LOG.proc_begin(d_mod);
2422: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2423: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2424: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2425: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2426: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2427: END IF;
2428:
2421: PO_LOG.proc_begin(d_mod);
2422: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2423: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2424: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2425: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2426: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2427: END IF;
2428:
2429: -- Get shipment-level profiles
2422: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2423: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2424: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2425: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2426: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2427: END IF;
2428:
2429: -- Get shipment-level profiles
2430: l_need_by_grouping_profile := fnd_profile.value('PO_NEED_BY_GROUPING');
2483: END LOOP;
2484: CLOSE po_delivery_info_csr;
2485: END IF; -- if second line is a PO line
2486:
2487: IF (PO_LOG.d_proc) THEN
2488: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2489: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2490: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2491: END IF;
2484: CLOSE po_delivery_info_csr;
2485: END IF; -- if second line is a PO line
2486:
2487: IF (PO_LOG.d_proc) THEN
2488: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2489: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2490: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2491: END IF;
2492:
2485: END IF; -- if second line is a PO line
2486:
2487: IF (PO_LOG.d_proc) THEN
2488: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2489: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2490: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2491: END IF;
2492:
2493: EXCEPTION
2486:
2487: IF (PO_LOG.d_proc) THEN
2488: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2489: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2490: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2491: END IF;
2492:
2493: EXCEPTION
2494: WHEN OTHERS THEN
2497: THEN
2498: CLOSE po_delivery_info_csr;
2499: END IF;
2500:
2501: IF (PO_LOG.d_exc) THEN
2502: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_delivery_info_match');
2503: END IF;
2504:
2505: RAISE;
2498: CLOSE po_delivery_info_csr;
2499: END IF;
2500:
2501: IF (PO_LOG.d_exc) THEN
2502: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_delivery_info_match');
2503: END IF;
2504:
2505: RAISE;
2506: END lines_delivery_info_match;
2557: IS
2558: d_mod CONSTANT VARCHAR2(100) := D_check_delivery_info;
2559: d_position NUMBER := 0;
2560: BEGIN
2561: IF (PO_LOG.d_proc) THEN
2562: PO_LOG.proc_begin(d_mod);
2563: PO_LOG.proc_begin(d_mod,'p_need_by_grouping_profile',p_need_by_grouping_profile);
2564: PO_LOG.proc_begin(d_mod,'p_ship_to_grouping_profile',p_ship_to_grouping_profile);
2565: END IF;
2558: d_mod CONSTANT VARCHAR2(100) := D_check_delivery_info;
2559: d_position NUMBER := 0;
2560: BEGIN
2561: IF (PO_LOG.d_proc) THEN
2562: PO_LOG.proc_begin(d_mod);
2563: PO_LOG.proc_begin(d_mod,'p_need_by_grouping_profile',p_need_by_grouping_profile);
2564: PO_LOG.proc_begin(d_mod,'p_ship_to_grouping_profile',p_ship_to_grouping_profile);
2565: END IF;
2566:
2559: d_position NUMBER := 0;
2560: BEGIN
2561: IF (PO_LOG.d_proc) THEN
2562: PO_LOG.proc_begin(d_mod);
2563: PO_LOG.proc_begin(d_mod,'p_need_by_grouping_profile',p_need_by_grouping_profile);
2564: PO_LOG.proc_begin(d_mod,'p_ship_to_grouping_profile',p_ship_to_grouping_profile);
2565: END IF;
2566:
2567: -- Initialize message code, token name, and token value to NULL
2560: BEGIN
2561: IF (PO_LOG.d_proc) THEN
2562: PO_LOG.proc_begin(d_mod);
2563: PO_LOG.proc_begin(d_mod,'p_need_by_grouping_profile',p_need_by_grouping_profile);
2564: PO_LOG.proc_begin(d_mod,'p_ship_to_grouping_profile',p_ship_to_grouping_profile);
2565: END IF;
2566:
2567: -- Initialize message code, token name, and token value to NULL
2568: x_message_code := NULL;
2578: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
2579: x_token_name := 'REASON_FOR_DIFF';
2580: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_NEED_BY');
2581:
2582: IF (PO_LOG.d_proc) THEN
2583: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2584: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2585: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2586: END IF;
2579: x_token_name := 'REASON_FOR_DIFF';
2580: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_NEED_BY');
2581:
2582: IF (PO_LOG.d_proc) THEN
2583: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2584: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2585: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2586: END IF;
2587:
2580: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_NEED_BY');
2581:
2582: IF (PO_LOG.d_proc) THEN
2583: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2584: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2585: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2586: END IF;
2587:
2588: RETURN;
2581:
2582: IF (PO_LOG.d_proc) THEN
2583: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2584: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2585: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2586: END IF;
2587:
2588: RETURN;
2589: END IF;
2599: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
2600: x_token_name := 'REASON_FOR_DIFF';
2601: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_ORG');
2602:
2603: IF (PO_LOG.d_proc) THEN
2604: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2605: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2606: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2607: END IF;
2600: x_token_name := 'REASON_FOR_DIFF';
2601: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_ORG');
2602:
2603: IF (PO_LOG.d_proc) THEN
2604: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2605: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2606: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2607: END IF;
2608:
2601: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_ORG');
2602:
2603: IF (PO_LOG.d_proc) THEN
2604: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2605: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2606: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2607: END IF;
2608:
2609: RETURN;
2602:
2603: IF (PO_LOG.d_proc) THEN
2604: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2605: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2606: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2607: END IF;
2608:
2609: RETURN;
2610: END IF;
2617: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
2618: x_token_name := 'REASON_FOR_DIFF';
2619: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_LOC');
2620:
2621: IF (PO_LOG.d_proc) THEN
2622: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2623: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2624: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2625: END IF;
2618: x_token_name := 'REASON_FOR_DIFF';
2619: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_LOC');
2620:
2621: IF (PO_LOG.d_proc) THEN
2622: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2623: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2624: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2625: END IF;
2626:
2619: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_DEL_LOC');
2620:
2621: IF (PO_LOG.d_proc) THEN
2622: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2623: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2624: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2625: END IF;
2626:
2627: RETURN;
2620:
2621: IF (PO_LOG.d_proc) THEN
2622: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2623: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2624: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2625: END IF;
2626:
2627: RETURN;
2628: END IF;
2636: x_message_code := 'PO_ALL_CANT_COMB_CONSIGNED';
2637: x_token_name := NULL;
2638: x_token_value := NULL;
2639:
2640: IF (PO_LOG.d_proc) THEN
2641: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2642: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2643: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2644: END IF;
2637: x_token_name := NULL;
2638: x_token_value := NULL;
2639:
2640: IF (PO_LOG.d_proc) THEN
2641: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2642: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2643: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2644: END IF;
2645:
2638: x_token_value := NULL;
2639:
2640: IF (PO_LOG.d_proc) THEN
2641: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2642: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2643: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2644: END IF;
2645:
2646: RETURN;
2639:
2640: IF (PO_LOG.d_proc) THEN
2641: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2642: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2643: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2644: END IF;
2645:
2646: RETURN;
2647: END IF;
2645:
2646: RETURN;
2647: END IF;
2648:
2649: IF (PO_LOG.d_proc) THEN
2650: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2651: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2652: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2653: END IF;
2646: RETURN;
2647: END IF;
2648:
2649: IF (PO_LOG.d_proc) THEN
2650: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2651: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2652: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2653: END IF;
2654:
2647: END IF;
2648:
2649: IF (PO_LOG.d_proc) THEN
2650: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2651: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2652: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2653: END IF;
2654:
2655: EXCEPTION
2648:
2649: IF (PO_LOG.d_proc) THEN
2650: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2651: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2652: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2653: END IF;
2654:
2655: EXCEPTION
2656: WHEN OTHERS THEN
2653: END IF;
2654:
2655: EXCEPTION
2656: WHEN OTHERS THEN
2657: IF (PO_LOG.d_exc) THEN
2658: PO_LOG.exc(d_mod, d_position, 'An error occured in check_delivery_info');
2659: END IF;
2660:
2661: RAISE;
2654:
2655: EXCEPTION
2656: WHEN OTHERS THEN
2657: IF (PO_LOG.d_exc) THEN
2658: PO_LOG.exc(d_mod, d_position, 'An error occured in check_delivery_info');
2659: END IF;
2660:
2661: RAISE;
2662: END check_delivery_info;
2699:
2700: l_req_line_delivery_info PO_DELIVERY_INFO_CSR%ROWTYPE;
2701: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
2702: BEGIN
2703: IF (PO_LOG.d_proc) THEN
2704: PO_LOG.proc_begin(d_mod);
2705: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2706: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2707: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2700: l_req_line_delivery_info PO_DELIVERY_INFO_CSR%ROWTYPE;
2701: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
2702: BEGIN
2703: IF (PO_LOG.d_proc) THEN
2704: PO_LOG.proc_begin(d_mod);
2705: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2706: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2707: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2708: END IF;
2701: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
2702: BEGIN
2703: IF (PO_LOG.d_proc) THEN
2704: PO_LOG.proc_begin(d_mod);
2705: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2706: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2707: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2708: END IF;
2709:
2702: BEGIN
2703: IF (PO_LOG.d_proc) THEN
2704: PO_LOG.proc_begin(d_mod);
2705: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2706: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2707: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2708: END IF;
2709:
2710: SELECT PRL.item_id,
2703: IF (PO_LOG.d_proc) THEN
2704: PO_LOG.proc_begin(d_mod);
2705: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2706: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
2707: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
2708: END IF;
2709:
2710: SELECT PRL.item_id,
2711: PRL.need_by_date,
2731: Added the 'NULL' parameter in the beginning in the place of org id.
2732: Moved the l_req_line_delivery_info.ship_to_organization_id parameter to end. This is inventory org id.
2733: These changes are driven by the changes done to the function PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag. */
2734:
2735: IF (PO_LOG.d_proc) THEN
2736: PO_LOG.proc_end(d_mod);
2737: END IF;
2738:
2739: RETURN l_req_line_delivery_info;
2732: Moved the l_req_line_delivery_info.ship_to_organization_id parameter to end. This is inventory org id.
2733: These changes are driven by the changes done to the function PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag. */
2734:
2735: IF (PO_LOG.d_proc) THEN
2736: PO_LOG.proc_end(d_mod);
2737: END IF;
2738:
2739: RETURN l_req_line_delivery_info;
2740:
2739: RETURN l_req_line_delivery_info;
2740:
2741: EXCEPTION
2742: WHEN OTHERS THEN
2743: IF (PO_LOG.d_exc) THEN
2744: PO_LOG.exc(d_mod, d_position, 'An error occured in get_req_line_delivery_info');
2745: END IF;
2746:
2747: RAISE;
2740:
2741: EXCEPTION
2742: WHEN OTHERS THEN
2743: IF (PO_LOG.d_exc) THEN
2744: PO_LOG.exc(d_mod, d_position, 'An error occured in get_req_line_delivery_info');
2745: END IF;
2746:
2747: RAISE;
2748: END get_req_line_delivery_info;
2810:
2811: l_line_one LINE_INFO;
2812: l_line_two LINE_INFO;
2813: BEGIN
2814: IF (PO_LOG.d_proc) THEN
2815: PO_LOG.proc_begin(d_mod);
2816: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2817: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2818: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2811: l_line_one LINE_INFO;
2812: l_line_two LINE_INFO;
2813: BEGIN
2814: IF (PO_LOG.d_proc) THEN
2815: PO_LOG.proc_begin(d_mod);
2816: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2817: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2818: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2819: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2812: l_line_two LINE_INFO;
2813: BEGIN
2814: IF (PO_LOG.d_proc) THEN
2815: PO_LOG.proc_begin(d_mod);
2816: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2817: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2818: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2819: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2820: END IF;
2813: BEGIN
2814: IF (PO_LOG.d_proc) THEN
2815: PO_LOG.proc_begin(d_mod);
2816: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2817: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2818: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2819: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2820: END IF;
2821:
2814: IF (PO_LOG.d_proc) THEN
2815: PO_LOG.proc_begin(d_mod);
2816: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2817: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2818: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2819: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2820: END IF;
2821:
2822: -- Retrieve all lines matching attributes for p_req_line_id
2815: PO_LOG.proc_begin(d_mod);
2816: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
2817: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2818: PO_LOG.proc_begin(d_mod,'p_req_line_id_to_compare',p_req_line_id_to_compare);
2819: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2820: END IF;
2821:
2822: -- Retrieve all lines matching attributes for p_req_line_id
2823: l_line_one := get_req_line_info(p_req_line_id);
2842: x_token_name,
2843: x_token_value
2844: );
2845:
2846: IF (PO_LOG.d_proc) THEN
2847: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2848: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2849: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2850: END IF;
2843: x_token_value
2844: );
2845:
2846: IF (PO_LOG.d_proc) THEN
2847: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2848: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2849: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2850: END IF;
2851:
2844: );
2845:
2846: IF (PO_LOG.d_proc) THEN
2847: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2848: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2849: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2850: END IF;
2851:
2852: EXCEPTION
2845:
2846: IF (PO_LOG.d_proc) THEN
2847: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
2848: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
2849: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
2850: END IF;
2851:
2852: EXCEPTION
2853: WHEN OTHERS THEN
2850: END IF;
2851:
2852: EXCEPTION
2853: WHEN OTHERS THEN
2854: IF (PO_LOG.d_exc) THEN
2855: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
2856: END IF;
2857:
2858: RAISE;
2851:
2852: EXCEPTION
2853: WHEN OTHERS THEN
2854: IF (PO_LOG.d_exc) THEN
2855: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
2856: END IF;
2857:
2858: RAISE;
2859: END lines_info_match;
2887: d_position NUMBER := 0;
2888:
2889: l_req_line_info LINE_INFO;
2890: BEGIN
2891: IF (PO_LOG.d_proc) THEN
2892: PO_LOG.proc_begin(d_mod);
2893: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2894: END IF;
2895:
2888:
2889: l_req_line_info LINE_INFO;
2890: BEGIN
2891: IF (PO_LOG.d_proc) THEN
2892: PO_LOG.proc_begin(d_mod);
2893: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2894: END IF;
2895:
2896: SELECT PRL.item_id,
2889: l_req_line_info LINE_INFO;
2890: BEGIN
2891: IF (PO_LOG.d_proc) THEN
2892: PO_LOG.proc_begin(d_mod);
2893: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
2894: END IF;
2895:
2896: SELECT PRL.item_id,
2897: PRL.item_description,
2933: WHERE PRL.requisition_line_id = p_req_line_id
2934: AND SRC_DOC_LINE.po_header_id(+) = PRL.blanket_po_header_id
2935: AND SRC_DOC_LINE.line_num(+) = PRL.blanket_po_line_num;
2936:
2937: IF (PO_LOG.d_proc) THEN
2938: PO_LOG.proc_end(d_mod);
2939: END IF;
2940:
2941: RETURN l_req_line_info;
2934: AND SRC_DOC_LINE.po_header_id(+) = PRL.blanket_po_header_id
2935: AND SRC_DOC_LINE.line_num(+) = PRL.blanket_po_line_num;
2936:
2937: IF (PO_LOG.d_proc) THEN
2938: PO_LOG.proc_end(d_mod);
2939: END IF;
2940:
2941: RETURN l_req_line_info;
2942:
2941: RETURN l_req_line_info;
2942:
2943: EXCEPTION
2944: WHEN OTHERS THEN
2945: IF (PO_LOG.d_exc) THEN
2946: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
2947: END IF;
2948:
2949: RAISE;
2942:
2943: EXCEPTION
2944: WHEN OTHERS THEN
2945: IF (PO_LOG.d_exc) THEN
2946: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
2947: END IF;
2948:
2949: RAISE;
2950: END get_req_line_info;
2978: d_position NUMBER := 0;
2979:
2980: l_po_line_info LINE_INFO;
2981: BEGIN
2982: IF (PO_LOG.d_proc) THEN
2983: PO_LOG.proc_begin(d_mod);
2984: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2985: END IF;
2986:
2979:
2980: l_po_line_info LINE_INFO;
2981: BEGIN
2982: IF (PO_LOG.d_proc) THEN
2983: PO_LOG.proc_begin(d_mod);
2984: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2985: END IF;
2986:
2987: SELECT item_id,
2980: l_po_line_info LINE_INFO;
2981: BEGIN
2982: IF (PO_LOG.d_proc) THEN
2983: PO_LOG.proc_begin(d_mod);
2984: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2985: END IF;
2986:
2987: SELECT item_id,
2988: item_description,
3007: FROM po_lines_merge_v /* changing to po_lines_merge_v and passing in the draft_id, for the 'add to mods' flow*/
3008: WHERE po_line_id = p_po_line_id
3009: AND draft_id = p_draft_id;
3010:
3011: IF (PO_LOG.d_proc) THEN
3012: PO_LOG.proc_end(d_mod);
3013: END IF;
3014:
3015: RETURN l_po_line_info;
3008: WHERE po_line_id = p_po_line_id
3009: AND draft_id = p_draft_id;
3010:
3011: IF (PO_LOG.d_proc) THEN
3012: PO_LOG.proc_end(d_mod);
3013: END IF;
3014:
3015: RETURN l_po_line_info;
3016:
3015: RETURN l_po_line_info;
3016:
3017: EXCEPTION
3018: WHEN OTHERS THEN
3019: IF (PO_LOG.d_exc) THEN
3020: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
3021: END IF;
3022:
3023: RAISE;
3016:
3017: EXCEPTION
3018: WHEN OTHERS THEN
3019: IF (PO_LOG.d_exc) THEN
3020: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
3021: END IF;
3022:
3023: RAISE;
3024: END get_po_line_info;
3071: IS
3072: d_mod CONSTANT VARCHAR2(100) := D_check_line_info;
3073: d_position NUMBER := 0;
3074: BEGIN
3075: IF (PO_LOG.d_proc) THEN
3076: PO_LOG.proc_begin(d_mod);
3077: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
3078: END IF;
3079:
3072: d_mod CONSTANT VARCHAR2(100) := D_check_line_info;
3073: d_position NUMBER := 0;
3074: BEGIN
3075: IF (PO_LOG.d_proc) THEN
3076: PO_LOG.proc_begin(d_mod);
3077: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
3078: END IF;
3079:
3080: -- Initialize message code, token name, and token value to NULL
3073: d_position NUMBER := 0;
3074: BEGIN
3075: IF (PO_LOG.d_proc) THEN
3076: PO_LOG.proc_begin(d_mod);
3077: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
3078: END IF;
3079:
3080: -- Initialize message code, token name, and token value to NULL
3081: x_message_code := NULL;
3091: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3092: x_token_name := 'REASON_FOR_DIFF';
3093: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEMS');
3094:
3095: IF (PO_LOG.d_proc) THEN
3096: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3097: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3098: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3099: END IF;
3092: x_token_name := 'REASON_FOR_DIFF';
3093: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEMS');
3094:
3095: IF (PO_LOG.d_proc) THEN
3096: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3097: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3098: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3099: END IF;
3100:
3093: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEMS');
3094:
3095: IF (PO_LOG.d_proc) THEN
3096: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3097: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3098: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3099: END IF;
3100:
3101: RETURN;
3094:
3095: IF (PO_LOG.d_proc) THEN
3096: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3097: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3098: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3099: END IF;
3100:
3101: RETURN;
3102: END IF;
3114: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3115: x_token_name := 'REASON_FOR_DIFF';
3116: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEMS');
3117:
3118: IF (PO_LOG.d_proc) THEN
3119: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3120: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3121: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3122: END IF;
3115: x_token_name := 'REASON_FOR_DIFF';
3116: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEMS');
3117:
3118: IF (PO_LOG.d_proc) THEN
3119: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3120: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3121: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3122: END IF;
3123:
3116: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEMS');
3117:
3118: IF (PO_LOG.d_proc) THEN
3119: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3120: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3121: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3122: END IF;
3123:
3124: RETURN;
3117:
3118: IF (PO_LOG.d_proc) THEN
3119: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3120: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3121: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3122: END IF;
3123:
3124: RETURN;
3125: END IF; --One time items with different description
3138: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3139: x_token_name := 'REASON_FOR_DIFF';
3140: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CATEGORY_ID');
3141:
3142: IF (PO_LOG.d_proc) THEN
3143: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3144: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3145: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3146: END IF;
3139: x_token_name := 'REASON_FOR_DIFF';
3140: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CATEGORY_ID');
3141:
3142: IF (PO_LOG.d_proc) THEN
3143: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3144: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3145: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3146: END IF;
3147:
3140: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CATEGORY_ID');
3141:
3142: IF (PO_LOG.d_proc) THEN
3143: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3144: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3145: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3146: END IF;
3147:
3148: RETURN;
3141:
3142: IF (PO_LOG.d_proc) THEN
3143: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3144: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3145: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3146: END IF;
3147:
3148: RETURN;
3149: END IF;
3155: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3156: x_token_name := 'REASON_FOR_DIFF';
3157: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEM_REVISION');
3158:
3159: IF (PO_LOG.d_proc) THEN
3160: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3161: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3162: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3163: END IF;
3156: x_token_name := 'REASON_FOR_DIFF';
3157: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEM_REVISION');
3158:
3159: IF (PO_LOG.d_proc) THEN
3160: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3161: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3162: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3163: END IF;
3164:
3157: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_ITEM_REVISION');
3158:
3159: IF (PO_LOG.d_proc) THEN
3160: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3161: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3162: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3163: END IF;
3164:
3165: RETURN;
3158:
3159: IF (PO_LOG.d_proc) THEN
3160: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3161: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3162: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3163: END IF;
3164:
3165: RETURN;
3166: END IF;
3183: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3184: x_token_name := 'REASON_FOR_DIFF';
3185: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_LINE_TYPE');
3186:
3187: IF (PO_LOG.d_proc) THEN
3188: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3189: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3190: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3191: END IF;
3184: x_token_name := 'REASON_FOR_DIFF';
3185: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_LINE_TYPE');
3186:
3187: IF (PO_LOG.d_proc) THEN
3188: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3189: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3190: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3191: END IF;
3192:
3185: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_LINE_TYPE');
3186:
3187: IF (PO_LOG.d_proc) THEN
3188: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3189: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3190: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3191: END IF;
3192:
3193: RETURN;
3186:
3187: IF (PO_LOG.d_proc) THEN
3188: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3189: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3190: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3191: END IF;
3192:
3193: RETURN;
3194: END IF;
3200: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3201: x_token_name := 'REASON_FOR_DIFF';
3202: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PREF_GRADE');
3203:
3204: IF (PO_LOG.d_proc) THEN
3205: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3206: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3207: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3208: END IF;
3201: x_token_name := 'REASON_FOR_DIFF';
3202: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PREF_GRADE');
3203:
3204: IF (PO_LOG.d_proc) THEN
3205: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3206: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3207: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3208: END IF;
3209:
3202: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PREF_GRADE');
3203:
3204: IF (PO_LOG.d_proc) THEN
3205: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3206: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3207: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3208: END IF;
3209:
3210: RETURN;
3203:
3204: IF (PO_LOG.d_proc) THEN
3205: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3206: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3207: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3208: END IF;
3209:
3210: RETURN;
3211: END IF;
3217: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3218: x_token_name := 'REASON_FOR_DIFF';
3219: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PRI_UOM');
3220:
3221: IF (PO_LOG.d_proc) THEN
3222: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3223: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3224: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3225: END IF;
3218: x_token_name := 'REASON_FOR_DIFF';
3219: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PRI_UOM');
3220:
3221: IF (PO_LOG.d_proc) THEN
3222: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3223: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3224: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3225: END IF;
3226:
3219: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_PRI_UOM');
3220:
3221: IF (PO_LOG.d_proc) THEN
3222: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3223: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3224: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3225: END IF;
3226:
3227: RETURN;
3220:
3221: IF (PO_LOG.d_proc) THEN
3222: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3223: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3224: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3225: END IF;
3226:
3227: RETURN;
3228: END IF;
3234: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3235: x_token_name := 'REASON_FOR_DIFF';
3236: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_TRANS_REASON');
3237:
3238: IF (PO_LOG.d_proc) THEN
3239: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3240: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3241: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3242: END IF;
3235: x_token_name := 'REASON_FOR_DIFF';
3236: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_TRANS_REASON');
3237:
3238: IF (PO_LOG.d_proc) THEN
3239: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3240: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3241: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3242: END IF;
3243:
3236: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_TRANS_REASON');
3237:
3238: IF (PO_LOG.d_proc) THEN
3239: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3240: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3241: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3242: END IF;
3243:
3244: RETURN;
3237:
3238: IF (PO_LOG.d_proc) THEN
3239: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3240: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3241: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3242: END IF;
3243:
3244: RETURN;
3245: END IF;
3251: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3252: x_token_name := 'REASON_FOR_DIFF';
3253: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CONTRACT');
3254:
3255: IF (PO_LOG.d_proc) THEN
3256: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3257: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3258: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3259: END IF;
3252: x_token_name := 'REASON_FOR_DIFF';
3253: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CONTRACT');
3254:
3255: IF (PO_LOG.d_proc) THEN
3256: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3257: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3258: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3259: END IF;
3260:
3253: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_CONTRACT');
3254:
3255: IF (PO_LOG.d_proc) THEN
3256: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3257: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3258: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3259: END IF;
3260:
3261: RETURN;
3254:
3255: IF (PO_LOG.d_proc) THEN
3256: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3257: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3258: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3259: END IF;
3260:
3261: RETURN;
3262: END IF;
3276: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3277: x_token_name := 'REASON_FOR_DIFF';
3278: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SRC_NUM');
3279:
3280: IF (PO_LOG.d_proc) THEN
3281: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3282: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3283: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3284: END IF;
3277: x_token_name := 'REASON_FOR_DIFF';
3278: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SRC_NUM');
3279:
3280: IF (PO_LOG.d_proc) THEN
3281: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3282: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3283: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3284: END IF;
3285:
3278: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SRC_NUM');
3279:
3280: IF (PO_LOG.d_proc) THEN
3281: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3282: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3283: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3284: END IF;
3285:
3286: RETURN;
3279:
3280: IF (PO_LOG.d_proc) THEN
3281: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3282: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3283: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3284: END IF;
3285:
3286: RETURN;
3287: END IF;
3291: x_message_code := 'PO_ALL_CANT_COMB_CANCLD_LINE';
3292: x_token_name := NULL;
3293: x_token_value := NULL;
3294:
3295: IF (PO_LOG.d_proc) THEN
3296: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3297: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3298: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3299: END IF;
3292: x_token_name := NULL;
3293: x_token_value := NULL;
3294:
3295: IF (PO_LOG.d_proc) THEN
3296: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3297: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3298: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3299: END IF;
3300:
3293: x_token_value := NULL;
3294:
3295: IF (PO_LOG.d_proc) THEN
3296: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3297: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3298: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3299: END IF;
3300:
3301: RETURN;
3294:
3295: IF (PO_LOG.d_proc) THEN
3296: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3297: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3298: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3299: END IF;
3300:
3301: RETURN;
3302: END IF;
3306: x_message_code := 'PO_ALL_CANT_COMB_FCLOSED_LINE';
3307: x_token_name := NULL;
3308: x_token_value := NULL;
3309:
3310: IF (PO_LOG.d_proc) THEN
3311: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3312: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3313: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3314: END IF;
3307: x_token_name := NULL;
3308: x_token_value := NULL;
3309:
3310: IF (PO_LOG.d_proc) THEN
3311: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3312: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3313: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3314: END IF;
3315:
3308: x_token_value := NULL;
3309:
3310: IF (PO_LOG.d_proc) THEN
3311: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3312: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3313: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3314: END IF;
3315:
3316: RETURN;
3309:
3310: IF (PO_LOG.d_proc) THEN
3311: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3312: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3313: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3314: END IF;
3315:
3316: RETURN;
3317: END IF;
3323: x_message_code := 'PO_ALL_LINE_CANNOT_BE_COMB_STP';
3324: x_token_name := 'REASON_FOR_DIFF';
3325: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SUPPLIER_REF_NUMBER');
3326:
3327: IF (PO_LOG.d_proc) THEN
3328: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3329: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3330: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3331: END IF;
3324: x_token_name := 'REASON_FOR_DIFF';
3325: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SUPPLIER_REF_NUMBER');
3326:
3327: IF (PO_LOG.d_proc) THEN
3328: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3329: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3330: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3331: END IF;
3332:
3325: x_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_BW_SUPPLIER_REF_NUMBER');
3326:
3327: IF (PO_LOG.d_proc) THEN
3328: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3329: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3330: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3331: END IF;
3332:
3333: RETURN;
3326:
3327: IF (PO_LOG.d_proc) THEN
3328: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3329: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3330: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3331: END IF;
3332:
3333: RETURN;
3334: END IF;
3344: x_token_name := NULL;
3345: x_token_value := NULL;
3346:
3347:
3348: IF (PO_LOG.d_proc) THEN
3349: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3350: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3351: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3352: END IF;
3345: x_token_value := NULL;
3346:
3347:
3348: IF (PO_LOG.d_proc) THEN
3349: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3350: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3351: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3352: END IF;
3353:
3346:
3347:
3348: IF (PO_LOG.d_proc) THEN
3349: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3350: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3351: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3352: END IF;
3353:
3354: RETURN;
3347:
3348: IF (PO_LOG.d_proc) THEN
3349: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3350: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3351: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3352: END IF;
3353:
3354: RETURN;
3355: END IF;
3353:
3354: RETURN;
3355: END IF;
3356:
3357: IF (PO_LOG.d_proc) THEN
3358: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3359: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3360: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3361: END IF;
3354: RETURN;
3355: END IF;
3356:
3357: IF (PO_LOG.d_proc) THEN
3358: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3359: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3360: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3361: END IF;
3362:
3355: END IF;
3356:
3357: IF (PO_LOG.d_proc) THEN
3358: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3359: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3360: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3361: END IF;
3362:
3363: -- Only PRICED Lines can be grouped
3356:
3357: IF (PO_LOG.d_proc) THEN
3358: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3359: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3360: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3361: END IF;
3362:
3363: -- Only PRICED Lines can be grouped
3364: IF Nvl(p_line_one.clm_info_flag,'N') = 'Y'
3369: x_token_name := NULL;
3370: x_token_value := NULL;
3371:
3372:
3373: IF (PO_LOG.d_proc) THEN
3374: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3375: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3376: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3377: END IF;
3370: x_token_value := NULL;
3371:
3372:
3373: IF (PO_LOG.d_proc) THEN
3374: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3375: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3376: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3377: END IF;
3378:
3371:
3372:
3373: IF (PO_LOG.d_proc) THEN
3374: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3375: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3376: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3377: END IF;
3378:
3379: RETURN;
3372:
3373: IF (PO_LOG.d_proc) THEN
3374: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3375: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3376: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3377: END IF;
3378:
3379: RETURN;
3380: END IF;
3388: x_token_name := NULL;
3389: x_token_value := NULL;
3390:
3391:
3392: IF (PO_LOG.d_proc) THEN
3393: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3394: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3395: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3396: END IF;
3389: x_token_value := NULL;
3390:
3391:
3392: IF (PO_LOG.d_proc) THEN
3393: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3394: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3395: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3396: END IF;
3397:
3390:
3391:
3392: IF (PO_LOG.d_proc) THEN
3393: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3394: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3395: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3396: END IF;
3397:
3398: RETURN;
3391:
3392: IF (PO_LOG.d_proc) THEN
3393: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3394: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3395: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3396: END IF;
3397:
3398: RETURN;
3399: END IF;
3398: RETURN;
3399: END IF;
3400: -- CLM changes END
3401:
3402: IF (PO_LOG.d_proc) THEN
3403: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3404: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3405: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3406: END IF;
3399: END IF;
3400: -- CLM changes END
3401:
3402: IF (PO_LOG.d_proc) THEN
3403: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3404: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3405: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3406: END IF;
3407:
3400: -- CLM changes END
3401:
3402: IF (PO_LOG.d_proc) THEN
3403: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3404: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3405: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3406: END IF;
3407:
3408:
3401:
3402: IF (PO_LOG.d_proc) THEN
3403: PO_LOG.proc_end(d_mod, 'x_message_code', x_message_code);
3404: PO_LOG.proc_end(d_mod, 'x_token_name', x_token_name);
3405: PO_LOG.proc_end(d_mod, 'x_token_value', x_token_value);
3406: END IF;
3407:
3408:
3409:
3409:
3410:
3411: EXCEPTION
3412: WHEN OTHERS THEN
3413: IF (PO_LOG.d_exc) THEN
3414: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
3415: END IF;
3416:
3417: RAISE;
3410:
3411: EXCEPTION
3412: WHEN OTHERS THEN
3413: IF (PO_LOG.d_exc) THEN
3414: PO_LOG.exc(d_mod, d_position, 'An error occured in lines_info_match');
3415: END IF;
3416:
3417: RAISE;
3418: END check_line_info;
3474: d_position NUMBER := 0;
3475:
3476: BEGIN
3477:
3478: IF PO_LOG.d_proc THEN
3479: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3480: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3481: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3482: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3475:
3476: BEGIN
3477:
3478: IF PO_LOG.d_proc THEN
3479: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3480: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3481: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3482: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3483: END IF;
3476: BEGIN
3477:
3478: IF PO_LOG.d_proc THEN
3479: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3480: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3481: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3482: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3483: END IF;
3484:
3477:
3478: IF PO_LOG.d_proc THEN
3479: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3480: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3481: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3482: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3483: END IF;
3484:
3485: -- Initialize the l_line_num_used_tbl to indicate which line
3478: IF PO_LOG.d_proc THEN
3479: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3480: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3481: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3482: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3483: END IF;
3484:
3485: -- Initialize the l_line_num_used_tbl to indicate which line
3486: -- numbers are already assigned. We will mark a 'Y' in the associative
3514: END IF;
3515: END LOOP;
3516:
3517: d_position := 50;
3518: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;
3519:
3520: return (x_po_line_num_tbl);
3521:
3522: EXCEPTION
3521:
3522: EXCEPTION
3523:
3524: WHEN OTHERS THEN
3525: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
3526: RAISE;
3527:
3528: END group_by_requisition_line_num;
3529:
3580: d_position NUMBER := 0;
3581:
3582: BEGIN
3583:
3584: IF PO_LOG.d_proc THEN
3585: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3586: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3587: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3588: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3581:
3582: BEGIN
3583:
3584: IF PO_LOG.d_proc THEN
3585: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3586: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3587: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3588: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3589: END IF;
3582: BEGIN
3583:
3584: IF PO_LOG.d_proc THEN
3585: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3586: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3587: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3588: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3589: END IF;
3590:
3583:
3584: IF PO_LOG.d_proc THEN
3585: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3586: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3587: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3588: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3589: END IF;
3590:
3591: -- Initialize the l_line_num_used_tbl to indicate which line
3584: IF PO_LOG.d_proc THEN
3585: PO_LOG.proc_begin(d_mod,'p_req_line_num_tbl',p_req_line_num_tbl);
3586: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
3587: PO_LOG.proc_begin(d_mod,'p_start_index',p_start_index);
3588: PO_LOG.proc_begin(d_mod,'p_end_index',p_end_index);
3589: END IF;
3590:
3591: -- Initialize the l_line_num_used_tbl to indicate which line
3592: -- numbers are already assigned. We will mark a 'Y' in the associative
3617: END IF;
3618: END LOOP;
3619:
3620: d_position := 50;
3621: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;
3622:
3623: return (x_po_line_num_tbl);
3624:
3625: EXCEPTION
3624:
3625: EXCEPTION
3626:
3627: WHEN OTHERS THEN
3628: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
3629: RAISE;
3630:
3631: END group_by_clm_req_line_num;
3632:
3707:
3708: EXCEPTION
3709:
3710: WHEN OTHERS THEN
3711: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
3712: RAISE;
3713:
3714: END group_by_requisition_seq_num;
3715:
3831:
3832: EXCEPTION
3833:
3834: WHEN OTHERS THEN
3835: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
3836: RAISE;
3837:
3838: END group_by_clm_req_seq_num;
3839:
3905: d_position NUMBER := 0;
3906:
3907: BEGIN
3908:
3909: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
3910:
3911: -- Initialize the max PO line number.
3912: --
3913: l_max_line_num := get_max_po_line_num ( p_po_line_num_tbl
3912: --
3913: l_max_line_num := get_max_po_line_num ( p_po_line_num_tbl
3914: , p_add_to_po_header_id );
3915:
3916: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_max_line_num',l_max_line_num); END IF;
3917:
3918: d_position := 10;
3919:
3920: -- Get nested tables of requisition lines and their corresponding
3948: ( p_req_line_id => p_req_line_id_tbl(i)
3949: , p_comparison_tbl => l_add_to_po_req_line_id_tbl
3950: , p_po_line_num_tbl => l_add_to_po_line_num_tbl
3951: );
3952: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Add To PO Line Num',l_po_line_num); END IF;
3953: END IF;
3954:
3955: d_position := 40;
3956:
3964: , p_req_line_id_tbl => p_req_line_id_tbl
3965: , p_po_line_num_tbl => x_po_line_num_tbl
3966: , p_builder_agreement_id => p_builder_agreement_id
3967: );
3968: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Builder Line Num',l_po_line_num); END IF;
3969: END IF;
3970:
3971: d_position := 50;
3972:
3978: THEN
3979: l_max_line_num := l_max_line_num + 1;
3980: l_po_line_num := l_max_line_num;
3981:
3982: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'Max Line Num',l_po_line_num); END IF;
3983: END IF;
3984:
3985: d_position := 60;
3986:
3989: END LOOP;
3990:
3991: d_position := 70;
3992:
3993: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_po_line_num_tbl); END IF;
3994:
3995: return (x_po_line_num_tbl);
3996:
3997: EXCEPTION
3996:
3997: EXCEPTION
3998:
3999: WHEN OTHERS THEN
4000: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4001: RAISE;
4002:
4003: END group_by_default;
4004:
4062: l_first_req_header_id := l_req_header_id;
4063:
4064: ELSIF ( l_req_header_id <> l_first_req_header_id ) THEN
4065:
4066: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,FALSE); END IF;
4067: return (FALSE); -- return false if header does not match
4068:
4069: END IF;
4070:
4069: END IF;
4070:
4071: END LOOP;
4072:
4073: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,TRUE); END IF;
4074: return (TRUE);
4075:
4076: EXCEPTION
4077:
4075:
4076: EXCEPTION
4077:
4078: WHEN OTHERS THEN
4079: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4080: RAISE;
4081:
4082: END has_same_req_header;
4083:
4149: d_position NUMBER := 0;
4150:
4151: BEGIN
4152:
4153: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
4154:
4155: -- Return immediately if there is no Add To PO.
4156: --
4157: IF ( p_add_to_po_header_id IS NULL )
4172: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');
4173: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
4174:
4175: d_position := 20;
4176: IF PO_LOG.d_stmt THEN
4177: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
4178: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
4179: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
4180: END IF;
4173: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
4174:
4175: d_position := 20;
4176: IF PO_LOG.d_stmt THEN
4177: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
4178: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
4179: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
4180: END IF;
4181:
4174:
4175: d_position := 20;
4176: IF PO_LOG.d_stmt THEN
4177: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
4178: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
4179: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
4180: END IF;
4181:
4182: -- Bulk insert matching lines into GT table.
4175: d_position := 20;
4176: IF PO_LOG.d_stmt THEN
4177: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
4178: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
4179: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
4180: END IF;
4181:
4182: -- Bulk insert matching lines into GT table.
4183: --
4253: WHERE key = l_key
4254: RETURNING num1, num2
4255: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl;
4256:
4257: IF PO_LOG.d_proc THEN
4258: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
4259: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
4260: END IF;
4261:
4254: RETURNING num1, num2
4255: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl;
4256:
4257: IF PO_LOG.d_proc THEN
4258: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
4259: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
4260: END IF;
4261:
4262: EXCEPTION
4255: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl;
4256:
4257: IF PO_LOG.d_proc THEN
4258: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
4259: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
4260: END IF;
4261:
4262: EXCEPTION
4263:
4261:
4262: EXCEPTION
4263:
4264: WHEN OTHERS THEN
4265: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4266: RAISE;
4267:
4268: END match_add_to_po_lines;
4269:
4296: d_position NUMBER := 0;
4297:
4298: BEGIN
4299:
4300: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
4301:
4302: -- Return immediately if there is no Add To PO.
4303:
4304:
4323:
4324:
4325:
4326: d_position := 20;
4327: IF PO_LOG.d_stmt THEN
4328: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
4329: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
4330: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
4331: END IF;
4324:
4325:
4326: d_position := 20;
4327: IF PO_LOG.d_stmt THEN
4328: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
4329: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
4330: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
4331: END IF;
4332:
4325:
4326: d_position := 20;
4327: IF PO_LOG.d_stmt THEN
4328: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
4329: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
4330: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
4331: END IF;
4332:
4333: -- Bulk insert matching lines into GT table.
4326: d_position := 20;
4327: IF PO_LOG.d_stmt THEN
4328: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);
4329: PO_LOG.stmt(d_mod,d_position,'l_need_by_grouping_profile',l_need_by_grouping_profile);
4330: PO_LOG.stmt(d_mod,d_position,'l_ship_to_grouping_profile',l_ship_to_grouping_profile);
4331: END IF;
4332:
4333: -- Bulk insert matching lines into GT table.
4334: --
4407: WHERE key = l_key
4408: RETURNING num1, num2, char1
4409: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl, x_po_line_num_disp_tbl;
4410:
4411: IF PO_LOG.d_proc THEN
4412: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
4413: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
4414: PO_LOG.proc_end(d_mod,'x_po_line_num_disp_tbl',x_po_line_num_disp_tbl);
4415: END IF;
4408: RETURNING num1, num2, char1
4409: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl, x_po_line_num_disp_tbl;
4410:
4411: IF PO_LOG.d_proc THEN
4412: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
4413: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
4414: PO_LOG.proc_end(d_mod,'x_po_line_num_disp_tbl',x_po_line_num_disp_tbl);
4415: END IF;
4416:
4409: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl, x_po_line_num_disp_tbl;
4410:
4411: IF PO_LOG.d_proc THEN
4412: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
4413: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
4414: PO_LOG.proc_end(d_mod,'x_po_line_num_disp_tbl',x_po_line_num_disp_tbl);
4415: END IF;
4416:
4417: EXCEPTION
4410:
4411: IF PO_LOG.d_proc THEN
4412: PO_LOG.proc_end(d_mod,'x_req_line_id_tbl',x_req_line_id_tbl);
4413: PO_LOG.proc_end(d_mod,'x_po_line_num_tbl',x_po_line_num_tbl);
4414: PO_LOG.proc_end(d_mod,'x_po_line_num_disp_tbl',x_po_line_num_disp_tbl);
4415: END IF;
4416:
4417: EXCEPTION
4418:
4416:
4417: EXCEPTION
4418:
4419: WHEN OTHERS THEN
4420: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4421: RAISE;
4422:
4423: END clm_match_add_to_po_lines;
4424:
4486:
4487: EXCEPTION
4488:
4489: WHEN OTHERS THEN
4490: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4491: RAISE;
4492:
4493: END find_matching_builder_line_num;
4494:
4535: d_position NUMBER := 0;
4536:
4537: BEGIN
4538:
4539: IF PO_LOG.d_proc THEN
4540: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
4541: PO_LOG.proc_begin(d_mod,'p_req_line_id_1',p_req_line_id_1);
4542: PO_LOG.proc_begin(d_mod,'p_req_line_id_2',p_req_line_id_2);
4543: END IF;
4536:
4537: BEGIN
4538:
4539: IF PO_LOG.d_proc THEN
4540: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
4541: PO_LOG.proc_begin(d_mod,'p_req_line_id_1',p_req_line_id_1);
4542: PO_LOG.proc_begin(d_mod,'p_req_line_id_2',p_req_line_id_2);
4543: END IF;
4544:
4537: BEGIN
4538:
4539: IF PO_LOG.d_proc THEN
4540: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
4541: PO_LOG.proc_begin(d_mod,'p_req_line_id_1',p_req_line_id_1);
4542: PO_LOG.proc_begin(d_mod,'p_req_line_id_2',p_req_line_id_2);
4543: END IF;
4544:
4545: -- Make a call to lines_match to determine if all relevant attributes
4538:
4539: IF PO_LOG.d_proc THEN
4540: PO_LOG.proc_begin(d_mod,'p_agreement_id',p_agreement_id);
4541: PO_LOG.proc_begin(d_mod,'p_req_line_id_1',p_req_line_id_1);
4542: PO_LOG.proc_begin(d_mod,'p_req_line_id_2',p_req_line_id_2);
4543: END IF;
4544:
4545: -- Make a call to lines_match to determine if all relevant attributes
4546: -- match. Note that we do not need Supplier/Site since we do not need
4557: , x_message_code => l_message_code
4558: , x_token_name => l_token_name
4559: , x_token_value => l_token_value
4560: );
4561: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_message_code',l_message_code); END IF;
4562:
4563: IF ( l_message_code IS NULL )
4564: THEN
4565: l_result := TRUE;
4566: ELSE
4567: l_result := FALSE;
4568: END IF;
4569:
4570: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,l_result); END IF;
4571:
4572: return (l_result);
4573:
4574: EXCEPTION
4573:
4574: EXCEPTION
4575:
4576: WHEN OTHERS THEN
4577: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4578: RAISE;
4579:
4580: END req_lines_match;
4581:
4620: l_draft_id NUMBER := p_draft_id;
4621:
4622: BEGIN
4623:
4624: IF PO_LOG.d_proc THEN
4625: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
4626: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4627: END IF;
4628:
4621:
4622: BEGIN
4623:
4624: IF PO_LOG.d_proc THEN
4625: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
4626: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4627: END IF;
4628:
4629: -- Find max line number for the input PO.
4622: BEGIN
4623:
4624: IF PO_LOG.d_proc THEN
4625: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
4626: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4627: END IF;
4628:
4629: -- Find max line number for the input PO.
4630: --
4655:
4656: EXCEPTION
4657:
4658: WHEN OTHERS THEN
4659: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4660: RAISE;
4661:
4662: END get_max_po_line_num;
4663:
4700: d_position NUMBER := 0;
4701:
4702: BEGIN
4703:
4704: IF PO_LOG.d_proc THEN
4705: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
4706: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4707: END IF;
4708:
4701:
4702: BEGIN
4703:
4704: IF PO_LOG.d_proc THEN
4705: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
4706: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4707: END IF;
4708:
4709: -- Find max CLIN number for the input PO.
4702: BEGIN
4703:
4704: IF PO_LOG.d_proc THEN
4705: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
4706: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4707: END IF;
4708:
4709: -- Find max CLIN number for the input PO.
4710: --
4743:
4744: EXCEPTION
4745:
4746: WHEN OTHERS THEN
4747: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4748: RAISE;
4749:
4750: END get_max_clm_po_line_num;
4751:
4787: d_position NUMBER := 0;
4788:
4789: BEGIN
4790:
4791: IF PO_LOG.d_proc THEN
4792: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_neg_line_num_tbl);
4793: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_draft_id);
4794: END IF;
4795:
4788:
4789: BEGIN
4790:
4791: IF PO_LOG.d_proc THEN
4792: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_neg_line_num_tbl);
4793: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_draft_id);
4794: END IF;
4795:
4796: -- Find max CLIN number for the input PO.
4789: BEGIN
4790:
4791: IF PO_LOG.d_proc THEN
4792: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_neg_line_num_tbl);
4793: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_draft_id);
4794: END IF;
4795:
4796: -- Find max CLIN number for the input PO.
4797: --
4821:
4822: EXCEPTION
4823:
4824: WHEN OTHERS THEN
4825: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4826: RAISE;
4827:
4828: END get_max_clm_sol_line_num ;
4829:
4872: d_position NUMBER := 0;
4873:
4874: BEGIN
4875:
4876: IF PO_LOG.d_proc THEN
4877: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
4878: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
4879: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
4880: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);
4873:
4874: BEGIN
4875:
4876: IF PO_LOG.d_proc THEN
4877: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
4878: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
4879: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
4880: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);
4881: END IF;
4874: BEGIN
4875:
4876: IF PO_LOG.d_proc THEN
4877: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
4878: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
4879: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
4880: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);
4881: END IF;
4882:
4875:
4876: IF PO_LOG.d_proc THEN
4877: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
4878: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
4879: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
4880: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);
4881: END IF;
4882:
4883: x_consigned_flag_tbl.EXTEND(p_req_line_id_tbl.COUNT);
4876: IF PO_LOG.d_proc THEN
4877: PO_LOG.proc_begin(d_mod,'p_req_line_id_tbl',p_req_line_id_tbl);
4878: PO_LOG.proc_begin(d_mod,'p_builder_org_id',p_builder_org_id);
4879: PO_LOG.proc_begin(d_mod,'p_builder_supplier_id',p_builder_supplier_id);
4880: PO_LOG.proc_begin(d_mod,'p_builder_site_id',p_builder_site_id);
4881: END IF;
4882:
4883: x_consigned_flag_tbl.EXTEND(p_req_line_id_tbl.COUNT);
4884:
4888: INTO l_item_id
4889: FROM po_requisition_lines_all
4890: WHERE requisition_line_id = p_req_line_id_tbl(i);
4891:
4892: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_item_id',l_item_id); END IF;
4893:
4894: x_consigned_flag_tbl(i) := PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag
4895: ( p_builder_org_id
4896: , l_item_id
4903: These changes are driven by the changes done to the function PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag. */
4904:
4905: END LOOP;
4906:
4907: IF PO_LOG.d_proc THEN PO_LOG.proc_return(d_mod,x_consigned_flag_tbl); END IF;
4908:
4909: return (x_consigned_flag_tbl);
4910:
4911: EXCEPTION
4910:
4911: EXCEPTION
4912:
4913: WHEN OTHERS THEN
4914: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4915: RAISE;
4916:
4917: END get_consigned_flag_tbl;
4918:
4970:
4971: EXCEPTION
4972:
4973: WHEN OTHERS THEN
4974: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
4975: RAISE;
4976:
4977: END find_matching_po_line_num;
4978:
5080: RETURN l_po_line_num_tbl;
5081: EXCEPTION
5082:
5083: WHEN OTHERS THEN
5084: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,d_position); END IF;
5085: RAISE;
5086: END default_info_slin_numbers;
5087:
5088: -------------------------------------------------------------------------------
5127: l_num_lines NUMBER;
5128:
5129: BEGIN
5130:
5131: IF (PO_LOG.d_proc) THEN
5132: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
5133: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
5134: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
5135: END IF;
5128:
5129: BEGIN
5130:
5131: IF (PO_LOG.d_proc) THEN
5132: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
5133: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
5134: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
5135: END IF;
5136:
5129: BEGIN
5130:
5131: IF (PO_LOG.d_proc) THEN
5132: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
5133: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
5134: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
5135: END IF;
5136:
5137: -- Get the number of lines being passed in.
5130:
5131: IF (PO_LOG.d_proc) THEN
5132: PO_LOG.proc_begin(d_mod,'p_po_line_number_tbl',p_po_line_number_tbl);
5133: PO_LOG.proc_begin(d_mod,'p_add_to_po_header_id',p_add_to_po_header_id);
5134: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
5135: END IF;
5136:
5137: -- Get the number of lines being passed in.
5138: l_num_lines := p_po_line_number_tbl.COUNT;
5179: END LOOP; --FOR i IN 1..p_po_line_number_tbl.COUNT
5180: END IF; --IF p_add_to_po_header_id IS NOT NULL AND p_draft_id <> -1
5181:
5182:
5183: IF (PO_LOG.d_proc) THEN
5184: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
5185: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
5186: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
5187: END IF;
5180: END IF; --IF p_add_to_po_header_id IS NOT NULL AND p_draft_id <> -1
5181:
5182:
5183: IF (PO_LOG.d_proc) THEN
5184: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
5185: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
5186: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
5187: END IF;
5188:
5181:
5182:
5183: IF (PO_LOG.d_proc) THEN
5184: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
5185: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
5186: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
5187: END IF;
5188:
5189: EXCEPTION
5182:
5183: IF (PO_LOG.d_proc) THEN
5184: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);
5185: PO_LOG.proc_end(d_mod, 'x_token_name_tbl', x_token_name_tbl);
5186: PO_LOG.proc_end(d_mod, 'x_token_value_tbl', x_token_value_tbl);
5187: END IF;
5188:
5189: EXCEPTION
5190: WHEN OTHERS THEN
5188:
5189: EXCEPTION
5190: WHEN OTHERS THEN
5191:
5192: IF (PO_LOG.d_exc) THEN
5193: PO_LOG.exc(d_mod, d_position, 'An error occured in check_mod_lock_availability');
5194: END IF;
5195:
5196: RAISE;
5189: EXCEPTION
5190: WHEN OTHERS THEN
5191:
5192: IF (PO_LOG.d_exc) THEN
5193: PO_LOG.exc(d_mod, d_position, 'An error occured in check_mod_lock_availability');
5194: END IF;
5195:
5196: RAISE;
5197: END check_mod_lock_availability;
5221: BEGIN
5222:
5223: -- Get the max line number from either the PO or the other
5224: -- lines in the Document Builder.
5225: IF (PO_LOG.d_proc) THEN
5226: PO_LOG.proc_begin(d_mod,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
5227: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
5228: END IF;
5229:
5222:
5223: -- Get the max line number from either the PO or the other
5224: -- lines in the Document Builder.
5225: IF (PO_LOG.d_proc) THEN
5226: PO_LOG.proc_begin(d_mod,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
5227: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
5228: END IF;
5229:
5230: l_max_line_num_disp := get_max_clm_po_line_num ( p_po_line_num_disp_tbl
5223: -- Get the max line number from either the PO or the other
5224: -- lines in the Document Builder.
5225: IF (PO_LOG.d_proc) THEN
5226: PO_LOG.proc_begin(d_mod,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
5227: PO_LOG.proc_begin(d_mod,'p_po_line_num_tbl',p_po_line_num_tbl);
5228: END IF;
5229:
5230: l_max_line_num_disp := get_max_clm_po_line_num ( p_po_line_num_disp_tbl
5231: , p_add_to_po_header_id
5231: , p_add_to_po_header_id
5232: , p_draft_id --Autocreate grouping
5233: ,p_req_group_line_id_tbl);
5234:
5235: IF PO_LOG.d_stmt THEN
5236: PO_LOG.stmt(d_mod,d_position,'l_max_line_num_disp',l_max_line_num_disp);
5237:
5238: END IF;
5239:
5232: , p_draft_id --Autocreate grouping
5233: ,p_req_group_line_id_tbl);
5234:
5235: IF PO_LOG.d_stmt THEN
5236: PO_LOG.stmt(d_mod,d_position,'l_max_line_num_disp',l_max_line_num_disp);
5237:
5238: END IF;
5239:
5240: -- Get the next line num display for a CLIN
5245: p_draft_id);
5246:
5247: d_position := 10;
5248:
5249: IF (PO_LOG.d_proc) THEN
5250: PO_LOG.proc_begin(d_mod,'l_next_clin_num_disp',l_action_tbl);
5251: PO_LOG.proc_begin(d_mod,'l_action_tbl',l_action_tbl);
5252: END IF;
5253:
5246:
5247: d_position := 10;
5248:
5249: IF (PO_LOG.d_proc) THEN
5250: PO_LOG.proc_begin(d_mod,'l_next_clin_num_disp',l_action_tbl);
5251: PO_LOG.proc_begin(d_mod,'l_action_tbl',l_action_tbl);
5252: END IF;
5253:
5254:
5247: d_position := 10;
5248:
5249: IF (PO_LOG.d_proc) THEN
5250: PO_LOG.proc_begin(d_mod,'l_next_clin_num_disp',l_action_tbl);
5251: PO_LOG.proc_begin(d_mod,'l_action_tbl',l_action_tbl);
5252: END IF;
5253:
5254:
5255: --Loop through every clin
5292: END IF;
5293: END IF;
5294: END LOOP;
5295:
5296: IF PO_LOG.d_proc THEN
5297: PO_LOG.proc_end(d_mod,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
5298: END IF;
5299:
5300:
5293: END IF;
5294: END LOOP;
5295:
5296: IF PO_LOG.d_proc THEN
5297: PO_LOG.proc_end(d_mod,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
5298: END IF;
5299:
5300:
5301: END get_line_num_disp_for_clin;
5324: BEGIN
5325:
5326: -- Get the max line number from either the PO or the other
5327: -- lines in the Document Builder.
5328: IF (PO_LOG.d_proc) THEN
5329: PO_LOG.proc_begin(d_mod,'p_neg_line_num_disp_tbl',p_neg_line_num_disp_tbl);
5330: PO_LOG.proc_begin(d_mod,'p_neg_line_num_tbl',p_neg_line_num_tbl);
5331: END IF;
5332:
5325:
5326: -- Get the max line number from either the PO or the other
5327: -- lines in the Document Builder.
5328: IF (PO_LOG.d_proc) THEN
5329: PO_LOG.proc_begin(d_mod,'p_neg_line_num_disp_tbl',p_neg_line_num_disp_tbl);
5330: PO_LOG.proc_begin(d_mod,'p_neg_line_num_tbl',p_neg_line_num_tbl);
5331: END IF;
5332:
5333: l_max_line_num_disp := get_max_clm_sol_line_num ( p_neg_line_num_disp_tbl
5326: -- Get the max line number from either the PO or the other
5327: -- lines in the Document Builder.
5328: IF (PO_LOG.d_proc) THEN
5329: PO_LOG.proc_begin(d_mod,'p_neg_line_num_disp_tbl',p_neg_line_num_disp_tbl);
5330: PO_LOG.proc_begin(d_mod,'p_neg_line_num_tbl',p_neg_line_num_tbl);
5331: END IF;
5332:
5333: l_max_line_num_disp := get_max_clm_sol_line_num ( p_neg_line_num_disp_tbl
5334: , p_draft_id
5333: l_max_line_num_disp := get_max_clm_sol_line_num ( p_neg_line_num_disp_tbl
5334: , p_draft_id
5335: ,p_req_group_line_id_tbl);
5336:
5337: IF PO_LOG.d_stmt THEN
5338: PO_LOG.stmt(d_mod,d_position,'l_max_line_num_disp',l_max_line_num_disp);
5339:
5340: END IF;
5341:
5334: , p_draft_id
5335: ,p_req_group_line_id_tbl);
5336:
5337: IF PO_LOG.d_stmt THEN
5338: PO_LOG.stmt(d_mod,d_position,'l_max_line_num_disp',l_max_line_num_disp);
5339:
5340: END IF;
5341:
5342: -- Get the next line num display for a CLIN
5347: p_draft_id);
5348:
5349: d_position := 10;
5350:
5351: IF (PO_LOG.d_proc) THEN
5352: PO_LOG.proc_begin(d_mod,'l_next_clin_num_disp',l_action_tbl);
5353: PO_LOG.proc_begin(d_mod,'l_action_tbl',l_action_tbl);
5354: END IF;
5355:
5348:
5349: d_position := 10;
5350:
5351: IF (PO_LOG.d_proc) THEN
5352: PO_LOG.proc_begin(d_mod,'l_next_clin_num_disp',l_action_tbl);
5353: PO_LOG.proc_begin(d_mod,'l_action_tbl',l_action_tbl);
5354: END IF;
5355:
5356:
5349: d_position := 10;
5350:
5351: IF (PO_LOG.d_proc) THEN
5352: PO_LOG.proc_begin(d_mod,'l_next_clin_num_disp',l_action_tbl);
5353: PO_LOG.proc_begin(d_mod,'l_action_tbl',l_action_tbl);
5354: END IF;
5355:
5356:
5357: --Loop through every clin
5394: END IF;
5395: END IF;
5396: END LOOP;
5397:
5398: IF PO_LOG.d_proc THEN
5399: PO_LOG.proc_end(d_mod,'p_po_line_num_disp_tbl',p_neg_line_num_disp_tbl);
5400: END IF;
5401:
5402:
5395: END IF;
5396: END LOOP;
5397:
5398: IF PO_LOG.d_proc THEN
5399: PO_LOG.proc_end(d_mod,'p_po_line_num_disp_tbl',p_neg_line_num_disp_tbl);
5400: END IF;
5401:
5402:
5403: END get_sol_line_num_disp_for_clin;
5445: if l_end_index is null or l_end_index = 0 or l_end_index < l_start_index THEN
5446: return;
5447: end if;
5448:
5449: IF (PO_LOG.d_proc) THEN
5450: PO_LOG.proc_begin(d_mod,'l_start_index',l_start_index);
5451: PO_LOG.proc_begin(d_mod,'l_end_index',l_end_index);
5452: PO_LOG.proc_begin(d_mod,'p_orig_line_num',p_orig_line_num);
5453: PO_LOG.proc_begin(d_mod,'p_edit_line_num',p_edit_line_num);
5446: return;
5447: end if;
5448:
5449: IF (PO_LOG.d_proc) THEN
5450: PO_LOG.proc_begin(d_mod,'l_start_index',l_start_index);
5451: PO_LOG.proc_begin(d_mod,'l_end_index',l_end_index);
5452: PO_LOG.proc_begin(d_mod,'p_orig_line_num',p_orig_line_num);
5453: PO_LOG.proc_begin(d_mod,'p_edit_line_num',p_edit_line_num);
5454: END IF;
5447: end if;
5448:
5449: IF (PO_LOG.d_proc) THEN
5450: PO_LOG.proc_begin(d_mod,'l_start_index',l_start_index);
5451: PO_LOG.proc_begin(d_mod,'l_end_index',l_end_index);
5452: PO_LOG.proc_begin(d_mod,'p_orig_line_num',p_orig_line_num);
5453: PO_LOG.proc_begin(d_mod,'p_edit_line_num',p_edit_line_num);
5454: END IF;
5455:
5448:
5449: IF (PO_LOG.d_proc) THEN
5450: PO_LOG.proc_begin(d_mod,'l_start_index',l_start_index);
5451: PO_LOG.proc_begin(d_mod,'l_end_index',l_end_index);
5452: PO_LOG.proc_begin(d_mod,'p_orig_line_num',p_orig_line_num);
5453: PO_LOG.proc_begin(d_mod,'p_edit_line_num',p_edit_line_num);
5454: END IF;
5455:
5456:
5449: IF (PO_LOG.d_proc) THEN
5450: PO_LOG.proc_begin(d_mod,'l_start_index',l_start_index);
5451: PO_LOG.proc_begin(d_mod,'l_end_index',l_end_index);
5452: PO_LOG.proc_begin(d_mod,'p_orig_line_num',p_orig_line_num);
5453: PO_LOG.proc_begin(d_mod,'p_edit_line_num',p_edit_line_num);
5454: END IF;
5455:
5456:
5457: p_po_line_num_disp_tbl.extend(l_end_index - l_start_index + 1);
5462: l_action_tbl := PO_AUTOCREATE_GROUPING_PVT.get_line_action_tbl(p_po_line_num_tbl,
5463: p_add_to_po_header_id,
5464: p_draft_id);
5465:
5466: IF PO_LOG.d_stmt THEN
5467: PO_LOG.stmt(d_mod,d_position,'l_session_key',l_session_key);
5468: PO_LOG.stmt(d_mod,d_position,'l_action_tbl',l_action_tbl);
5469: END IF;
5470:
5463: p_add_to_po_header_id,
5464: p_draft_id);
5465:
5466: IF PO_LOG.d_stmt THEN
5467: PO_LOG.stmt(d_mod,d_position,'l_session_key',l_session_key);
5468: PO_LOG.stmt(d_mod,d_position,'l_action_tbl',l_action_tbl);
5469: END IF;
5470:
5471: /* Mapping for gt table
5464: p_draft_id);
5465:
5466: IF PO_LOG.d_stmt THEN
5467: PO_LOG.stmt(d_mod,d_position,'l_session_key',l_session_key);
5468: PO_LOG.stmt(d_mod,d_position,'l_action_tbl',l_action_tbl);
5469: END IF;
5470:
5471: /* Mapping for gt table
5472: num1 - source line id ( req line id or interface line id)
5624: from po_session_gt
5625: where key = l_session_key
5626: order by index_num1; -- order is important
5627:
5628: IF PO_LOG.d_proc THEN
5629: PO_LOG.proc_end(d_mod,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
5630: END IF;
5631:
5632: end RenumberSlins;
5625: where key = l_session_key
5626: order by index_num1; -- order is important
5627:
5628: IF PO_LOG.d_proc THEN
5629: PO_LOG.proc_end(d_mod,'p_po_line_num_disp_tbl',p_po_line_num_disp_tbl);
5630: END IF;
5631:
5632: end RenumberSlins;
5633:
5698: d_position NUMBER := 0;
5699:
5700: BEGIN
5701:
5702: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
5703:
5704: d_position := 10;
5705: BEGIN
5706: SELECT line_num, line_num_display
5716: x_po_line_num := null;
5717: x_po_line_num_disp := null;
5718: END;
5719:
5720: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
5721: IF PO_LOG.d_stmt THEN
5722: PO_LOG.stmt(d_mod,d_position,'x_po_line_num',x_po_line_num);
5723: PO_LOG.stmt(d_mod,d_position,'x_po_line_num_disp',x_po_line_num_disp);
5724: END IF;
5717: x_po_line_num_disp := null;
5718: END;
5719:
5720: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
5721: IF PO_LOG.d_stmt THEN
5722: PO_LOG.stmt(d_mod,d_position,'x_po_line_num',x_po_line_num);
5723: PO_LOG.stmt(d_mod,d_position,'x_po_line_num_disp',x_po_line_num_disp);
5724: END IF;
5725: END get_po_linenum_for_shipment;
5718: END;
5719:
5720: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
5721: IF PO_LOG.d_stmt THEN
5722: PO_LOG.stmt(d_mod,d_position,'x_po_line_num',x_po_line_num);
5723: PO_LOG.stmt(d_mod,d_position,'x_po_line_num_disp',x_po_line_num_disp);
5724: END IF;
5725: END get_po_linenum_for_shipment;
5726: /*bug 13622501 end */
5719:
5720: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
5721: IF PO_LOG.d_stmt THEN
5722: PO_LOG.stmt(d_mod,d_position,'x_po_line_num',x_po_line_num);
5723: PO_LOG.stmt(d_mod,d_position,'x_po_line_num_disp',x_po_line_num_disp);
5724: END IF;
5725: END get_po_linenum_for_shipment;
5726: /*bug 13622501 end */
5727:
5772: l_po_item_desc PO_LINES_ALL.ITEM_DESCRIPTION%TYPE;
5773:
5774: BEGIN
5775:
5776: IF (PO_LOG.d_proc) THEN
5777: PO_LOG.proc_begin(d_mod);
5778: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5779: PO_LOG.proc_begin(d_mod,'p_po_line_num',p_po_line_num);
5780: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
5773:
5774: BEGIN
5775:
5776: IF (PO_LOG.d_proc) THEN
5777: PO_LOG.proc_begin(d_mod);
5778: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5779: PO_LOG.proc_begin(d_mod,'p_po_line_num',p_po_line_num);
5780: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
5781: END IF;
5774: BEGIN
5775:
5776: IF (PO_LOG.d_proc) THEN
5777: PO_LOG.proc_begin(d_mod);
5778: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5779: PO_LOG.proc_begin(d_mod,'p_po_line_num',p_po_line_num);
5780: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
5781: END IF;
5782:
5775:
5776: IF (PO_LOG.d_proc) THEN
5777: PO_LOG.proc_begin(d_mod);
5778: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5779: PO_LOG.proc_begin(d_mod,'p_po_line_num',p_po_line_num);
5780: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
5781: END IF;
5782:
5783: x_same_item_desc := 'N';
5776: IF (PO_LOG.d_proc) THEN
5777: PO_LOG.proc_begin(d_mod);
5778: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5779: PO_LOG.proc_begin(d_mod,'p_po_line_num',p_po_line_num);
5780: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);
5781: END IF;
5782:
5783: x_same_item_desc := 'N';
5784:
5812: END IF;
5813:
5814: EXCEPTION
5815: WHEN OTHERS THEN
5816: IF (PO_LOG.d_exc) THEN
5817: PO_LOG.exc(d_mod, d_position, 'An error occured in check_item_description');
5818: END IF;
5819: RAISE;
5820:
5813:
5814: EXCEPTION
5815: WHEN OTHERS THEN
5816: IF (PO_LOG.d_exc) THEN
5817: PO_LOG.exc(d_mod, d_position, 'An error occured in check_item_description');
5818: END IF;
5819: RAISE;
5820:
5821: END check_item_description;