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

APPS.PO_VAL_HEADERS dependencies on PO_LOG

Line 56: PO_LOG.get_package_base('PO_VAL_HEADERS');

52: c_MODIFICATION_NUMBER VARCHAR2(30) := 'MODIFICATION_NUMBER';
53:
54: -- The module base for this package.
55: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
56: PO_LOG.get_package_base('PO_VAL_HEADERS');
57:
58: -- The module base for the subprogram.
59: D_price_update_tol_ge_zero CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_update_tol_ge_zero');

Line 60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_update_tol_ge_zero');

56: PO_LOG.get_package_base('PO_VAL_HEADERS');
57:
58: -- The module base for the subprogram.
59: D_price_update_tol_ge_zero CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_update_tol_ge_zero');
61:
62: D_amount_limit_ge_zero CONSTANT VARCHAR2(100) :=
63: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_limit_ge_zero');
64:

Line 63: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_limit_ge_zero');

59: D_price_update_tol_ge_zero CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_update_tol_ge_zero');
61:
62: D_amount_limit_ge_zero CONSTANT VARCHAR2(100) :=
63: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_limit_ge_zero');
64:
65: D_amt_limit_ge_amt_agreed CONSTANT VARCHAR2(100) :=
66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_limit_ge_amt_agreed');
67:

Line 66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_limit_ge_amt_agreed');

62: D_amount_limit_ge_zero CONSTANT VARCHAR2(100) :=
63: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_limit_ge_zero');
64:
65: D_amt_limit_ge_amt_agreed CONSTANT VARCHAR2(100) :=
66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_limit_ge_amt_agreed');
67:
68: D_amount_agreed_ge_zero CONSTANT VARCHAR2(100) :=
69: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_ge_zero');
70:

Line 69: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_ge_zero');

65: D_amt_limit_ge_amt_agreed CONSTANT VARCHAR2(100) :=
66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_limit_ge_amt_agreed');
67:
68: D_amount_agreed_ge_zero CONSTANT VARCHAR2(100) :=
69: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_ge_zero');
70:
71: D_amount_agreed_not_null CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_not_null');
73:

Line 72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_not_null');

68: D_amount_agreed_ge_zero CONSTANT VARCHAR2(100) :=
69: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_ge_zero');
70:
71: D_amount_agreed_not_null CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_not_null');
73:
74: D_warn_supplier_on_hold CONSTANT VARCHAR2(100) :=
75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warn_supplier_on_hold');
76:

Line 75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warn_supplier_on_hold');

71: D_amount_agreed_not_null CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_agreed_not_null');
73:
74: D_warn_supplier_on_hold CONSTANT VARCHAR2(100) :=
75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warn_supplier_on_hold');
76:
77: D_rate_gt_zero CONSTANT VARCHAR2(100) :=
78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_gt_zero');
79:

Line 78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_gt_zero');

74: D_warn_supplier_on_hold CONSTANT VARCHAR2(100) :=
75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warn_supplier_on_hold');
76:
77: D_rate_gt_zero CONSTANT VARCHAR2(100) :=
78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_gt_zero');
79:
80: D_fax_email_address_valid CONSTANT VARCHAR2(100) :=
81: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'fax_email_address_valid');
82:

Line 81: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'fax_email_address_valid');

77: D_rate_gt_zero CONSTANT VARCHAR2(100) :=
78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_gt_zero');
79:
80: D_fax_email_address_valid CONSTANT VARCHAR2(100) :=
81: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'fax_email_address_valid');
82:
83: D_rate_combination_valid CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_combination_valid');
85:

Line 84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_combination_valid');

80: D_fax_email_address_valid CONSTANT VARCHAR2(100) :=
81: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'fax_email_address_valid');
82:
83: D_rate_combination_valid CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_combination_valid');
85:
86: D_effective_le_expiration CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_le_expiration');
88:

Line 87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_le_expiration');

83: D_rate_combination_valid CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rate_combination_valid');
85:
86: D_effective_le_expiration CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_le_expiration');
88:
89: D_effective_from_le_order_date CONSTANT VARCHAR2(100) :=
90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_from_le_order_date');
91:

Line 90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_from_le_order_date');

86: D_effective_le_expiration CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_le_expiration');
88:
89: D_effective_from_le_order_date CONSTANT VARCHAR2(100) :=
90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_from_le_order_date');
91:
92: D_effective_to_ge_order_date CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_to_ge_order_date');
94:

Line 93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_to_ge_order_date');

89: D_effective_from_le_order_date CONSTANT VARCHAR2(100) :=
90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_from_le_order_date');
91:
92: D_effective_to_ge_order_date CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_to_ge_order_date');
94:
95: D_contract_start_le_order_date CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_start_le_order_date');
97:

Line 96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_start_le_order_date');

92: D_effective_to_ge_order_date CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'effective_to_ge_order_date');
94:
95: D_contract_start_le_order_date CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_start_le_order_date');
97:
98: D_contract_end_ge_order_date CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_end_ge_order_date');
100:

Line 99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_end_ge_order_date');

95: D_contract_start_le_order_date CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_start_le_order_date');
97:
98: D_contract_end_ge_order_date CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_end_ge_order_date');
100:
101: D_doc_num_chars_valid CONSTANT VARCHAR2(100) :=
102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_chars_valid');
103:

Line 102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_chars_valid');

98: D_contract_end_ge_order_date CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'contract_end_ge_order_date');
100:
101: D_doc_num_chars_valid CONSTANT VARCHAR2(100) :=
102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_chars_valid');
103:
104: D_doc_num_unique CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_unique');
106:

Line 105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_unique');

101: D_doc_num_chars_valid CONSTANT VARCHAR2(100) :=
102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_chars_valid');
103:
104: D_doc_num_unique CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_unique');
106:
107: D_check_agreement_dates CONSTANT VARCHAR2(100) :=
108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_agreement_dates');
109:

Line 108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_agreement_dates');

104: D_doc_num_unique CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'doc_num_unique');
106:
107: D_check_agreement_dates CONSTANT VARCHAR2(100) :=
108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_agreement_dates');
109:
110: D_agent_id_not_null CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');
112: D_ship_to_loc_not_null CONSTANT VARCHAR2(100) :=

Line 111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');

107: D_check_agreement_dates CONSTANT VARCHAR2(100) :=
108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_agreement_dates');
109:
110: D_agent_id_not_null CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');
112: D_ship_to_loc_not_null CONSTANT VARCHAR2(100) :=
113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');
114: D_vendor_id_not_null CONSTANT VARCHAR2(100) :=
115: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');

Line 113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');

109:
110: D_agent_id_not_null CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');
112: D_ship_to_loc_not_null CONSTANT VARCHAR2(100) :=
113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');
114: D_vendor_id_not_null CONSTANT VARCHAR2(100) :=
115: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');
116: D_vendor_site_id_not_null CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');

Line 115: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');

111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'agent_id_not_null');
112: D_ship_to_loc_not_null CONSTANT VARCHAR2(100) :=
113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');
114: D_vendor_id_not_null CONSTANT VARCHAR2(100) :=
115: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');
116: D_vendor_site_id_not_null CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');
118: D_segment1_not_null CONSTANT VARCHAR2(100) :=
119: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'segment1_not_null');

Line 117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');

113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_not_null');
114: D_vendor_id_not_null CONSTANT VARCHAR2(100) :=
115: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');
116: D_vendor_site_id_not_null CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');
118: D_segment1_not_null CONSTANT VARCHAR2(100) :=
119: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'segment1_not_null');
120:
121: --Mod Project

Line 119: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'segment1_not_null');

115: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_id_not_null');
116: D_vendor_site_id_not_null CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vendor_site_id_not_null');
118: D_segment1_not_null CONSTANT VARCHAR2(100) :=
119: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'segment1_not_null');
120:
121: --Mod Project
122: D_mod_eff_dt_not_null CONSTANT VARCHAR2(100) :=
123: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_eff_dt_not_null');

Line 123: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_eff_dt_not_null');

119: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'segment1_not_null');
120:
121: --Mod Project
122: D_mod_eff_dt_not_null CONSTANT VARCHAR2(100) :=
123: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_eff_dt_not_null');
124: D_mod_eff_dt_lt_need_by_dt CONSTANT VARCHAR2(100) :=
125: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_eff_dt_lt_need_by_dt');
126: D_mod_no_cancel_shp_complt CONSTANT VARCHAR2(100) :=
127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');

Line 125: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_eff_dt_lt_need_by_dt');

121: --Mod Project
122: D_mod_eff_dt_not_null CONSTANT VARCHAR2(100) :=
123: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_eff_dt_not_null');
124: D_mod_eff_dt_lt_need_by_dt CONSTANT VARCHAR2(100) :=
125: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_eff_dt_lt_need_by_dt');
126: D_mod_no_cancel_shp_complt CONSTANT VARCHAR2(100) :=
127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');
128:
129:

Line 127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');

123: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_eff_dt_not_null');
124: D_mod_eff_dt_lt_need_by_dt CONSTANT VARCHAR2(100) :=
125: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_eff_dt_lt_need_by_dt');
126: D_mod_no_cancel_shp_complt CONSTANT VARCHAR2(100) :=
127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');
128:
129:
130: -- For CLM Project
131: D_clm_eff_from_le_order_date CONSTANT VARCHAR2(100) :=

Line 132: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_eff_from_le_order_date');

128:
129:
130: -- For CLM Project
131: D_clm_eff_from_le_order_date CONSTANT VARCHAR2(100) :=
132: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_eff_from_le_order_date');
133: D_max_ceil_awd_amt_gt_min CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_awd_amt_gt_min');
135: D_max_ceil_amt_gt_min_ord CONSTANT VARCHAR2(100) :=
136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_min_ord');

Line 134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_awd_amt_gt_min');

130: -- For CLM Project
131: D_clm_eff_from_le_order_date CONSTANT VARCHAR2(100) :=
132: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_eff_from_le_order_date');
133: D_max_ceil_awd_amt_gt_min CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_awd_amt_gt_min');
135: D_max_ceil_amt_gt_min_ord CONSTANT VARCHAR2(100) :=
136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_min_ord');
137: D_max_ceil_amt_gt_max_ord CONSTANT VARCHAR2(100) :=
138: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_max_ord');

Line 136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_min_ord');

132: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clm_eff_from_le_order_date');
133: D_max_ceil_awd_amt_gt_min CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_awd_amt_gt_min');
135: D_max_ceil_amt_gt_min_ord CONSTANT VARCHAR2(100) :=
136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_min_ord');
137: D_max_ceil_amt_gt_max_ord CONSTANT VARCHAR2(100) :=
138: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_max_ord');
139: D_min_guar_perc_range_check CONSTANT VARCHAR2(100) :=
140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_guar_perc_range_check');

Line 138: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_max_ord');

134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_awd_amt_gt_min');
135: D_max_ceil_amt_gt_min_ord CONSTANT VARCHAR2(100) :=
136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_min_ord');
137: D_max_ceil_amt_gt_max_ord CONSTANT VARCHAR2(100) :=
138: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_max_ord');
139: D_min_guar_perc_range_check CONSTANT VARCHAR2(100) :=
140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_guar_perc_range_check');
141: D_max_ord_amt_gt_min CONSTANT VARCHAR2(100) :=
142: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ord_amt_gt_min');

Line 140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_guar_perc_range_check');

136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_min_ord');
137: D_max_ceil_amt_gt_max_ord CONSTANT VARCHAR2(100) :=
138: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_max_ord');
139: D_min_guar_perc_range_check CONSTANT VARCHAR2(100) :=
140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_guar_perc_range_check');
141: D_max_ord_amt_gt_min CONSTANT VARCHAR2(100) :=
142: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ord_amt_gt_min');
143: D_print_form_format_valid CONSTANT VARCHAR2(100) :=
144: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'print_form_format_valid');

Line 142: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ord_amt_gt_min');

138: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ceil_amt_gt_max_ord');
139: D_min_guar_perc_range_check CONSTANT VARCHAR2(100) :=
140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_guar_perc_range_check');
141: D_max_ord_amt_gt_min CONSTANT VARCHAR2(100) :=
142: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ord_amt_gt_min');
143: D_print_form_format_valid CONSTANT VARCHAR2(100) :=
144: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'print_form_format_valid');
145:
146: --CLM PDOI Integration

Line 144: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'print_form_format_valid');

140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_guar_perc_range_check');
141: D_max_ord_amt_gt_min CONSTANT VARCHAR2(100) :=
142: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_ord_amt_gt_min');
143: D_print_form_format_valid CONSTANT VARCHAR2(100) :=
144: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'print_form_format_valid');
145:
146: --CLM PDOI Integration
147: D_validate_clm_standard_form CONSTANT VARCHAR2(100) :=
148: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_standard_form');

Line 148: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_standard_form');

144: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'print_form_format_valid');
145:
146: --CLM PDOI Integration
147: D_validate_clm_standard_form CONSTANT VARCHAR2(100) :=
148: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_standard_form');
149: D_validate_clm_document_format CONSTANT VARCHAR2(100) :=
150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_document_format');
151: D_validate_source_idv CONSTANT VARCHAR2(100) :=
152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_source_idv');

Line 150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_document_format');

146: --CLM PDOI Integration
147: D_validate_clm_standard_form CONSTANT VARCHAR2(100) :=
148: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_standard_form');
149: D_validate_clm_document_format CONSTANT VARCHAR2(100) :=
150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_document_format');
151: D_validate_source_idv CONSTANT VARCHAR2(100) :=
152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_source_idv');
153: D_validate_award_admin CONSTANT VARCHAR2(100) :=
154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_award_admin');

Line 152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_source_idv');

148: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_standard_form');
149: D_validate_clm_document_format CONSTANT VARCHAR2(100) :=
150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_document_format');
151: D_validate_source_idv CONSTANT VARCHAR2(100) :=
152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_source_idv');
153: D_validate_award_admin CONSTANT VARCHAR2(100) :=
154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_award_admin');
155: D_validate_contract_officer CONSTANT VARCHAR2(100) :=
156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_officer');

Line 154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_award_admin');

150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'valid_clm_document_format');
151: D_validate_source_idv CONSTANT VARCHAR2(100) :=
152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_source_idv');
153: D_validate_award_admin CONSTANT VARCHAR2(100) :=
154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_award_admin');
155: D_validate_contract_officer CONSTANT VARCHAR2(100) :=
156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_officer');
157: D_validate_umbrella_program_id CONSTANT VARCHAR2(100) :=
158: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_umbrella_program_id');

Line 156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_officer');

152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_source_idv');
153: D_validate_award_admin CONSTANT VARCHAR2(100) :=
154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_award_admin');
155: D_validate_contract_officer CONSTANT VARCHAR2(100) :=
156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_officer');
157: D_validate_umbrella_program_id CONSTANT VARCHAR2(100) :=
158: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_umbrella_program_id');
159: D_validate_clm_award_type CONSTANT VARCHAR2(100) :=
160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_award_type');

Line 158: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_umbrella_program_id');

154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_award_admin');
155: D_validate_contract_officer CONSTANT VARCHAR2(100) :=
156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_officer');
157: D_validate_umbrella_program_id CONSTANT VARCHAR2(100) :=
158: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_umbrella_program_id');
159: D_validate_clm_award_type CONSTANT VARCHAR2(100) :=
160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_award_type');
161: D_validate_style_id CONSTANT VARCHAR2(100) :=
162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_style_id');

Line 160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_award_type');

156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_officer');
157: D_validate_umbrella_program_id CONSTANT VARCHAR2(100) :=
158: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_umbrella_program_id');
159: D_validate_clm_award_type CONSTANT VARCHAR2(100) :=
160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_award_type');
161: D_validate_style_id CONSTANT VARCHAR2(100) :=
162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_style_id');
163: D_validate_idv_style_id CONSTANT VARCHAR2(100) :=
164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_idv_style_id');

Line 162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_style_id');

158: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_umbrella_program_id');
159: D_validate_clm_award_type CONSTANT VARCHAR2(100) :=
160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_award_type');
161: D_validate_style_id CONSTANT VARCHAR2(100) :=
162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_style_id');
163: D_validate_idv_style_id CONSTANT VARCHAR2(100) :=
164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_idv_style_id');
165: D_validate_po_idv_vendor_id VARCHAR2(100) :=
166: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_id');

Line 164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_idv_style_id');

160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_award_type');
161: D_validate_style_id CONSTANT VARCHAR2(100) :=
162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_style_id');
163: D_validate_idv_style_id CONSTANT VARCHAR2(100) :=
164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_idv_style_id');
165: D_validate_po_idv_vendor_id VARCHAR2(100) :=
166: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_id');
167: D_val_po_idv_vendor_site_id VARCHAR2(100) :=
168: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_site_id');

Line 166: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_id');

162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_style_id');
163: D_validate_idv_style_id CONSTANT VARCHAR2(100) :=
164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_idv_style_id');
165: D_validate_po_idv_vendor_id VARCHAR2(100) :=
166: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_id');
167: D_val_po_idv_vendor_site_id VARCHAR2(100) :=
168: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_site_id');
169: D_validate_mod_number VARCHAR2(100) :=
170: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_mod_number');

Line 168: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_site_id');

164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_idv_style_id');
165: D_validate_po_idv_vendor_id VARCHAR2(100) :=
166: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_id');
167: D_val_po_idv_vendor_site_id VARCHAR2(100) :=
168: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_site_id');
169: D_validate_mod_number VARCHAR2(100) :=
170: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_mod_number');
171:
172: ---------------------------------------------------------------------------

Line 170: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_mod_number');

166: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_id');
167: D_val_po_idv_vendor_site_id VARCHAR2(100) :=
168: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_po_idv_vendor_site_id');
169: D_validate_mod_number VARCHAR2(100) :=
170: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_mod_number');
171:
172: ---------------------------------------------------------------------------
173: -- Checks that the Price Update Tolerance is greater than or equal to zero.
174: -- Agreements only.

Line 320: IF PO_LOG.d_proc THEN

316: d_mod CONSTANT VARCHAR2(100) := D_amount_agreed_not_null;
317: l_results_count NUMBER;
318: BEGIN
319:
320: IF PO_LOG.d_proc THEN
321: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
322: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
323: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
324: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 321: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

317: l_results_count NUMBER;
318: BEGIN
319:
320: IF PO_LOG.d_proc THEN
321: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
322: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
323: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
324: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
325: END IF;

Line 322: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);

318: BEGIN
319:
320: IF PO_LOG.d_proc THEN
321: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
322: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
323: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
324: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
325: END IF;
326:

Line 323: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);

319:
320: IF PO_LOG.d_proc THEN
321: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
322: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
323: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
324: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
325: END IF;
326:
327: IF (x_results IS NULL) THEN

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

320: IF PO_LOG.d_proc THEN
321: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
322: PO_LOG.proc_begin(d_mod,'p_blanket_total_amount_tbl',p_blanket_total_amount_tbl);
323: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
324: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
325: END IF;
326:
327: IF (x_results IS NULL) THEN
328: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 353: IF PO_LOG.d_proc THEN

349: ELSE
350: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
351: END IF;
352:
353: IF PO_LOG.d_proc THEN
354: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
355: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
356: END IF;
357:

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

350: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
351: END IF;
352:
353: IF PO_LOG.d_proc THEN
354: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
355: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
356: END IF;
357:
358: EXCEPTION

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

351: END IF;
352:
353: IF PO_LOG.d_proc THEN
354: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
355: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
356: END IF;
357:
358: EXCEPTION
359: WHEN OTHERS THEN

Line 360: IF PO_LOG.d_exc THEN

356: END IF;
357:
358: EXCEPTION
359: WHEN OTHERS THEN
360: IF PO_LOG.d_exc THEN
361: PO_LOG.exc(d_mod,0,NULL);
362: END IF;
363: RAISE;
364:

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

357:
358: EXCEPTION
359: WHEN OTHERS THEN
360: IF PO_LOG.d_exc THEN
361: PO_LOG.exc(d_mod,0,NULL);
362: END IF;
363: RAISE;
364:
365: END amount_agreed_not_null;

Line 381: IF PO_LOG.d_proc THEN

377: IS
378: d_mod CONSTANT VARCHAR2(100) := D_warn_supplier_on_hold;
379: BEGIN
380:
381: IF PO_LOG.d_proc THEN
382: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
383: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
384: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
385: END IF;

Line 382: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

378: d_mod CONSTANT VARCHAR2(100) := D_warn_supplier_on_hold;
379: BEGIN
380:
381: IF PO_LOG.d_proc THEN
382: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
383: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
384: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
385: END IF;
386:

Line 383: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);

379: BEGIN
380:
381: IF PO_LOG.d_proc THEN
382: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
383: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
384: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
385: END IF;
386:
387: IF (x_result_set_id IS NULL) THEN

Line 384: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

380:
381: IF PO_LOG.d_proc THEN
382: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
383: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
384: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
385: END IF;
386:
387: IF (x_result_set_id IS NULL) THEN
388: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 422: IF PO_LOG.d_proc THEN

418: ELSE
419: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
420: END IF;
421:
422: IF PO_LOG.d_proc THEN
423: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
424: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
425: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
426: END IF;

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

420: END IF;
421:
422: IF PO_LOG.d_proc THEN
423: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
424: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
425: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
426: END IF;
427:
428: EXCEPTION

Line 425: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

421:
422: IF PO_LOG.d_proc THEN
423: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
424: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
425: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
426: END IF;
427:
428: EXCEPTION
429: WHEN OTHERS THEN

Line 430: IF PO_LOG.d_exc THEN

426: END IF;
427:
428: EXCEPTION
429: WHEN OTHERS THEN
430: IF PO_LOG.d_exc THEN
431: PO_LOG.exc(d_mod,0,NULL);
432: END IF;
433: RAISE;
434:

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

427:
428: EXCEPTION
429: WHEN OTHERS THEN
430: IF PO_LOG.d_exc THEN
431: PO_LOG.exc(d_mod,0,NULL);
432: END IF;
433: RAISE;
434:
435: END warn_supplier_on_hold;

Line 490: IF PO_LOG.d_proc THEN

486: l_results_count NUMBER;
487: l_func_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
488: BEGIN
489:
490: IF PO_LOG.d_proc THEN
491: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
492: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
493: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
494: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);

Line 491: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

487: l_func_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
488: BEGIN
489:
490: IF PO_LOG.d_proc THEN
491: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
492: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
493: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
494: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
495: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);

Line 492: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);

488: BEGIN
489:
490: IF PO_LOG.d_proc THEN
491: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
492: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
493: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
494: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
495: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
496: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);

Line 493: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);

489:
490: IF PO_LOG.d_proc THEN
491: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
492: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
493: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
494: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
495: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
496: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
497: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 494: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);

490: IF PO_LOG.d_proc THEN
491: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
492: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
493: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
494: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
495: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
496: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
497: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
498: END IF;

Line 495: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);

491: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
492: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
493: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
494: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
495: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
496: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
497: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
498: END IF;
499:

Line 496: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);

492: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
493: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
494: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
495: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
496: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
497: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
498: END IF;
499:
500: IF (x_results IS NULL) THEN

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

493: PO_LOG.proc_begin(d_mod,'p_currency_code_tbl',p_currency_code_tbl);
494: PO_LOG.proc_begin(d_mod,'p_rate_type_tbl',p_rate_type_tbl);
495: PO_LOG.proc_begin(d_mod,'p_rate_date_tbl',p_rate_date_tbl);
496: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
497: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
498: END IF;
499:
500: IF (x_results IS NULL) THEN
501: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 566: IF PO_LOG.d_proc THEN

562: ELSE
563: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
564: END IF;
565:
566: IF PO_LOG.d_proc THEN
567: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
568: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
569: END IF;
570:

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

563: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
564: END IF;
565:
566: IF PO_LOG.d_proc THEN
567: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
568: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
569: END IF;
570:
571: EXCEPTION

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

564: END IF;
565:
566: IF PO_LOG.d_proc THEN
567: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
568: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
569: END IF;
570:
571: EXCEPTION
572: WHEN OTHERS THEN

Line 573: IF PO_LOG.d_exc THEN

569: END IF;
570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: IF PO_LOG.d_exc THEN
574: PO_LOG.exc(d_mod,0,NULL);
575: END IF;
576: RAISE;
577:

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

570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: IF PO_LOG.d_exc THEN
574: PO_LOG.exc(d_mod,0,NULL);
575: END IF;
576: RAISE;
577:
578: END rate_combination_valid;

Line 599: IF PO_LOG.d_proc THEN

595: d_mod CONSTANT VARCHAR2(100) := D_fax_email_address_valid;
596: l_results_count NUMBER;
597: BEGIN
598:
599: IF PO_LOG.d_proc THEN
600: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
601: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
602: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
603: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);

Line 600: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

596: l_results_count NUMBER;
597: BEGIN
598:
599: IF PO_LOG.d_proc THEN
600: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
601: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
602: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
603: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 601: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);

597: BEGIN
598:
599: IF PO_LOG.d_proc THEN
600: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
601: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
602: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
603: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
605: END IF;

Line 602: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);

598:
599: IF PO_LOG.d_proc THEN
600: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
601: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
602: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
603: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
605: END IF;
606:

Line 603: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);

599: IF PO_LOG.d_proc THEN
600: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
601: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
602: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
603: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
605: END IF;
606:
607: IF (x_results IS NULL) THEN

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

600: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
601: PO_LOG.proc_begin(d_mod,'p_supplier_notif_method_tbl',p_supplier_notif_method_tbl);
602: PO_LOG.proc_begin(d_mod,'p_email_address_tbl',p_email_address_tbl);
603: PO_LOG.proc_begin(d_mod,'p_fax_tbl',p_fax_tbl);
604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
605: END IF;
606:
607: IF (x_results IS NULL) THEN
608: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 641: IF PO_LOG.d_proc THEN

637: ELSE
638: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
639: END IF;
640:
641: IF PO_LOG.d_proc THEN
642: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
643: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
644: END IF;
645:

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

638: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
639: END IF;
640:
641: IF PO_LOG.d_proc THEN
642: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
643: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
644: END IF;
645:
646: EXCEPTION

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

639: END IF;
640:
641: IF PO_LOG.d_proc THEN
642: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
643: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
644: END IF;
645:
646: EXCEPTION
647: WHEN OTHERS THEN

Line 648: IF PO_LOG.d_exc THEN

644: END IF;
645:
646: EXCEPTION
647: WHEN OTHERS THEN
648: IF PO_LOG.d_exc THEN
649: PO_LOG.exc(d_mod,0,NULL);
650: END IF;
651: RAISE;
652:

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

645:
646: EXCEPTION
647: WHEN OTHERS THEN
648: IF PO_LOG.d_exc THEN
649: PO_LOG.exc(d_mod,0,NULL);
650: END IF;
651: RAISE;
652:
653: END fax_email_address_valid;

Line 710: IF PO_LOG.d_proc THEN

706: IS
707: d_mod CONSTANT VARCHAR2(100) := D_effective_from_le_order_date;
708: BEGIN
709:
710: IF PO_LOG.d_proc THEN
711: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
712: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
713: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
714: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 711: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

707: d_mod CONSTANT VARCHAR2(100) := D_effective_from_le_order_date;
708: BEGIN
709:
710: IF PO_LOG.d_proc THEN
711: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
712: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
713: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
714: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
715: END IF;

Line 712: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

708: BEGIN
709:
710: IF PO_LOG.d_proc THEN
711: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
712: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
713: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
714: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
715: END IF;
716:

Line 713: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);

709:
710: IF PO_LOG.d_proc THEN
711: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
712: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
713: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
714: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
715: END IF;
716:
717: IF (x_result_set_id IS NULL) THEN

Line 714: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

710: IF PO_LOG.d_proc THEN
711: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
712: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
713: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
714: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
715: END IF;
716:
717: IF (x_result_set_id IS NULL) THEN
718: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 754: IF PO_LOG.d_proc THEN

750: ELSE
751: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
752: END IF;
753:
754: IF PO_LOG.d_proc THEN
755: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
756: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
757: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
758: END IF;

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

752: END IF;
753:
754: IF PO_LOG.d_proc THEN
755: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
756: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
757: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
758: END IF;
759:
760: EXCEPTION

Line 757: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

753:
754: IF PO_LOG.d_proc THEN
755: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
756: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
757: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
758: END IF;
759:
760: EXCEPTION
761: WHEN OTHERS THEN

Line 762: IF PO_LOG.d_exc THEN

758: END IF;
759:
760: EXCEPTION
761: WHEN OTHERS THEN
762: IF PO_LOG.d_exc THEN
763: PO_LOG.exc(d_mod,0,NULL);
764: END IF;
765: RAISE;
766:

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

759:
760: EXCEPTION
761: WHEN OTHERS THEN
762: IF PO_LOG.d_exc THEN
763: PO_LOG.exc(d_mod,0,NULL);
764: END IF;
765: RAISE;
766:
767: END effective_from_le_order_date;

Line 786: IF PO_LOG.d_proc THEN

782: IS
783: d_mod CONSTANT VARCHAR2(100) := D_clm_eff_from_le_order_date;
784: BEGIN
785:
786: IF PO_LOG.d_proc THEN
787: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
788: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
789: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
790: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_clm_effective_date_tbl);

Line 787: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

783: d_mod CONSTANT VARCHAR2(100) := D_clm_eff_from_le_order_date;
784: BEGIN
785:
786: IF PO_LOG.d_proc THEN
787: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
788: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
789: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
790: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_clm_effective_date_tbl);
791: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 788: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

784: BEGIN
785:
786: IF PO_LOG.d_proc THEN
787: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
788: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
789: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
790: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_clm_effective_date_tbl);
791: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
792: END IF;

Line 789: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);

785:
786: IF PO_LOG.d_proc THEN
787: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
788: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
789: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
790: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_clm_effective_date_tbl);
791: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
792: END IF;
793:

Line 790: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_clm_effective_date_tbl);

786: IF PO_LOG.d_proc THEN
787: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
788: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
789: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
790: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_clm_effective_date_tbl);
791: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
792: END IF;
793:
794: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 791: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

787: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
788: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
789: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
790: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_clm_effective_date_tbl);
791: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
792: END IF;
793:
794: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
795: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 831: IF PO_LOG.d_proc THEN

827: ELSE
828: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
829: END IF;
830:
831: IF PO_LOG.d_proc THEN
832: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
833: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
834: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
835: END IF;

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

829: END IF;
830:
831: IF PO_LOG.d_proc THEN
832: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
833: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
834: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
835: END IF;
836:
837: EXCEPTION

Line 834: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

830:
831: IF PO_LOG.d_proc THEN
832: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
833: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
834: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
835: END IF;
836:
837: EXCEPTION
838: WHEN OTHERS THEN

Line 839: IF PO_LOG.d_exc THEN

835: END IF;
836:
837: EXCEPTION
838: WHEN OTHERS THEN
839: IF PO_LOG.d_exc THEN
840: PO_LOG.exc(d_mod,0,NULL);
841: END IF;
842: RAISE;
843: END clm_eff_from_le_order_date;

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

836:
837: EXCEPTION
838: WHEN OTHERS THEN
839: IF PO_LOG.d_exc THEN
840: PO_LOG.exc(d_mod,0,NULL);
841: END IF;
842: RAISE;
843: END clm_eff_from_le_order_date;
844:

Line 861: IF PO_LOG.d_proc THEN

857: IS
858: d_mod CONSTANT VARCHAR2(100) := D_max_ceil_awd_amt_gt_min;
859: BEGIN
860:
861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
863: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
864: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_amount_limit_tbl);
865: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_min_grnt_awd_amt_tbl);

Line 862: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

858: d_mod CONSTANT VARCHAR2(100) := D_max_ceil_awd_amt_gt_min;
859: BEGIN
860:
861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
863: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
864: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_amount_limit_tbl);
865: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_min_grnt_awd_amt_tbl);
866: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 863: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

859: BEGIN
860:
861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
863: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
864: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_amount_limit_tbl);
865: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_min_grnt_awd_amt_tbl);
866: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
867: END IF;

Line 864: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_amount_limit_tbl);

860:
861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
863: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
864: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_amount_limit_tbl);
865: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_min_grnt_awd_amt_tbl);
866: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
867: END IF;
868:

Line 865: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_min_grnt_awd_amt_tbl);

861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
863: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
864: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_amount_limit_tbl);
865: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_min_grnt_awd_amt_tbl);
866: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
867: END IF;
868:
869: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 866: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

862: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
863: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
864: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_amount_limit_tbl);
865: PO_LOG.proc_begin(d_mod,'p_clm_effective_date_tbl',p_min_grnt_awd_amt_tbl);
866: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
867: END IF;
868:
869: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
870: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 905: IF PO_LOG.d_proc THEN

901: ELSE
902: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
903: END IF;
904:
905: IF PO_LOG.d_proc THEN
906: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
907: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
908: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
909: END IF;

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

903: END IF;
904:
905: IF PO_LOG.d_proc THEN
906: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
907: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
908: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
909: END IF;
910:
911: EXCEPTION

Line 908: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

904:
905: IF PO_LOG.d_proc THEN
906: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
907: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
908: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
909: END IF;
910:
911: EXCEPTION
912: WHEN OTHERS THEN

Line 913: IF PO_LOG.d_exc THEN

909: END IF;
910:
911: EXCEPTION
912: WHEN OTHERS THEN
913: IF PO_LOG.d_exc THEN
914: PO_LOG.exc(d_mod,0,NULL);
915: END IF;
916: RAISE;
917: END max_ceil_awd_amt_gt_min;

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

910:
911: EXCEPTION
912: WHEN OTHERS THEN
913: IF PO_LOG.d_exc THEN
914: PO_LOG.exc(d_mod,0,NULL);
915: END IF;
916: RAISE;
917: END max_ceil_awd_amt_gt_min;
918:

Line 935: IF PO_LOG.d_proc THEN

931: IS
932: d_mod CONSTANT VARCHAR2(100) := D_max_ceil_amt_gt_min_ord;
933: BEGIN
934:
935: IF PO_LOG.d_proc THEN
936: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
937: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
938: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
939: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);

Line 936: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

932: d_mod CONSTANT VARCHAR2(100) := D_max_ceil_amt_gt_min_ord;
933: BEGIN
934:
935: IF PO_LOG.d_proc THEN
936: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
937: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
938: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
939: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
940: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 937: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

933: BEGIN
934:
935: IF PO_LOG.d_proc THEN
936: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
937: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
938: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
939: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
940: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
941: END IF;

Line 938: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);

934:
935: IF PO_LOG.d_proc THEN
936: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
937: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
938: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
939: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
940: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
941: END IF;
942:

Line 939: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);

935: IF PO_LOG.d_proc THEN
936: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
937: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
938: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
939: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
940: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
941: END IF;
942:
943: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 940: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

936: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
937: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
938: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
939: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
940: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
941: END IF;
942:
943: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
944: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 979: IF PO_LOG.d_proc THEN

975: ELSE
976: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
977: END IF;
978:
979: IF PO_LOG.d_proc THEN
980: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
981: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
982: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
983: END IF;

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

977: END IF;
978:
979: IF PO_LOG.d_proc THEN
980: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
981: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
982: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
983: END IF;
984:
985: EXCEPTION

Line 982: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

978:
979: IF PO_LOG.d_proc THEN
980: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
981: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
982: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
983: END IF;
984:
985: EXCEPTION
986: WHEN OTHERS THEN

Line 987: IF PO_LOG.d_exc THEN

983: END IF;
984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: IF PO_LOG.d_exc THEN
988: PO_LOG.exc(d_mod,0,NULL);
989: END IF;
990: RAISE;
991: END max_ceil_amt_gt_min_ord;

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

984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: IF PO_LOG.d_exc THEN
988: PO_LOG.exc(d_mod,0,NULL);
989: END IF;
990: RAISE;
991: END max_ceil_amt_gt_min_ord;
992:

Line 1008: IF PO_LOG.d_proc THEN

1004: IS
1005: d_mod CONSTANT VARCHAR2(100) := D_max_ceil_amt_gt_max_ord;
1006: BEGIN
1007:
1008: IF PO_LOG.d_proc THEN
1009: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1010: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1011: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
1012: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);

Line 1009: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1005: d_mod CONSTANT VARCHAR2(100) := D_max_ceil_amt_gt_max_ord;
1006: BEGIN
1007:
1008: IF PO_LOG.d_proc THEN
1009: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1010: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1011: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
1012: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1013: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1010: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

1006: BEGIN
1007:
1008: IF PO_LOG.d_proc THEN
1009: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1010: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1011: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
1012: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1013: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1014: END IF;

Line 1011: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);

1007:
1008: IF PO_LOG.d_proc THEN
1009: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1010: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1011: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
1012: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1013: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1014: END IF;
1015:

Line 1012: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);

1008: IF PO_LOG.d_proc THEN
1009: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1010: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1011: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
1012: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1013: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1014: END IF;
1015:
1016: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 1013: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

1009: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1010: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1011: PO_LOG.proc_begin(d_mod,'p_amount_limit_tbl',p_amount_limit_tbl);
1012: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1013: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1014: END IF;
1015:
1016: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1017: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 1052: IF PO_LOG.d_proc THEN

1048: ELSE
1049: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1050: END IF;
1051:
1052: IF PO_LOG.d_proc THEN
1053: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1054: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1055: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1056: END IF;

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

1050: END IF;
1051:
1052: IF PO_LOG.d_proc THEN
1053: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1054: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1055: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1056: END IF;
1057:
1058: EXCEPTION

Line 1055: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

1051:
1052: IF PO_LOG.d_proc THEN
1053: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1054: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1055: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1056: END IF;
1057:
1058: EXCEPTION
1059: WHEN OTHERS THEN

Line 1060: IF PO_LOG.d_exc THEN

1056: END IF;
1057:
1058: EXCEPTION
1059: WHEN OTHERS THEN
1060: IF PO_LOG.d_exc THEN
1061: PO_LOG.exc(d_mod,0,NULL);
1062: END IF;
1063: RAISE;
1064: END max_ceil_amt_gt_max_ord;

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

1057:
1058: EXCEPTION
1059: WHEN OTHERS THEN
1060: IF PO_LOG.d_exc THEN
1061: PO_LOG.exc(d_mod,0,NULL);
1062: END IF;
1063: RAISE;
1064: END max_ceil_amt_gt_max_ord;
1065:

Line 1080: IF PO_LOG.d_proc THEN

1076: IS
1077: d_mod CONSTANT VARCHAR2(100) := D_min_guar_perc_range_check;
1078: BEGIN
1079:
1080: IF PO_LOG.d_proc THEN
1081: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1082: PO_LOG.proc_begin(d_mod,'p_min_guar_perc_tbl',p_min_guar_perc_tbl);
1083: END IF;
1084:

Line 1081: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1077: d_mod CONSTANT VARCHAR2(100) := D_min_guar_perc_range_check;
1078: BEGIN
1079:
1080: IF PO_LOG.d_proc THEN
1081: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1082: PO_LOG.proc_begin(d_mod,'p_min_guar_perc_tbl',p_min_guar_perc_tbl);
1083: END IF;
1084:
1085: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 1082: PO_LOG.proc_begin(d_mod,'p_min_guar_perc_tbl',p_min_guar_perc_tbl);

1078: BEGIN
1079:
1080: IF PO_LOG.d_proc THEN
1081: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1082: PO_LOG.proc_begin(d_mod,'p_min_guar_perc_tbl',p_min_guar_perc_tbl);
1083: END IF;
1084:
1085: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1086: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 1120: IF PO_LOG.d_proc THEN

1116: IS
1117: d_mod CONSTANT VARCHAR2(100) := D_max_ord_amt_gt_min;
1118: BEGIN
1119:
1120: IF PO_LOG.d_proc THEN
1121: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
1124: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);

Line 1121: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1117: d_mod CONSTANT VARCHAR2(100) := D_max_ord_amt_gt_min;
1118: BEGIN
1119:
1120: IF PO_LOG.d_proc THEN
1121: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
1124: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1125: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1122: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

1118: BEGIN
1119:
1120: IF PO_LOG.d_proc THEN
1121: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
1124: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1125: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1126: END IF;

Line 1123: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);

1119:
1120: IF PO_LOG.d_proc THEN
1121: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
1124: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1125: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1126: END IF;
1127:

Line 1124: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);

1120: IF PO_LOG.d_proc THEN
1121: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
1124: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1125: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1126: END IF;
1127:
1128: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 1125: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

1121: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_min_order_amt_tbl',p_min_order_amt_tbl);
1124: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1125: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1126: END IF;
1127:
1128: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
1129: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 1164: IF PO_LOG.d_proc THEN

1160: ELSE
1161: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1162: END IF;
1163:
1164: IF PO_LOG.d_proc THEN
1165: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1166: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1167: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1168: END IF;

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

1162: END IF;
1163:
1164: IF PO_LOG.d_proc THEN
1165: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1166: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1167: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1168: END IF;
1169:
1170: EXCEPTION

Line 1167: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

1163:
1164: IF PO_LOG.d_proc THEN
1165: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1166: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1167: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1168: END IF;
1169:
1170: EXCEPTION
1171: WHEN OTHERS THEN

Line 1172: IF PO_LOG.d_exc THEN

1168: END IF;
1169:
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: IF PO_LOG.d_exc THEN
1173: PO_LOG.exc(d_mod,0,NULL);
1174: END IF;
1175: RAISE;
1176: END max_ord_amt_gt_min;

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

1169:
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: IF PO_LOG.d_exc THEN
1173: PO_LOG.exc(d_mod,0,NULL);
1174: END IF;
1175: RAISE;
1176: END max_ord_amt_gt_min;
1177:

Line 1199: IF PO_LOG.d_proc THEN

1195: IS
1196: d_mod CONSTANT VARCHAR2(100) := D_print_form_format_valid;
1197: BEGIN
1198:
1199: IF PO_LOG.d_proc THEN
1200: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1201: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1202: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
1203: PO_LOG.proc_begin(d_mod,'p_document_format_tbl',p_document_format_tbl);

Line 1200: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1196: d_mod CONSTANT VARCHAR2(100) := D_print_form_format_valid;
1197: BEGIN
1198:
1199: IF PO_LOG.d_proc THEN
1200: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1201: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1202: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
1203: PO_LOG.proc_begin(d_mod,'p_document_format_tbl',p_document_format_tbl);
1204: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

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

1197: BEGIN
1198:
1199: IF PO_LOG.d_proc THEN
1200: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1201: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1202: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
1203: PO_LOG.proc_begin(d_mod,'p_document_format_tbl',p_document_format_tbl);
1204: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1205: END IF;

Line 1202: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);

1198:
1199: IF PO_LOG.d_proc THEN
1200: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1201: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1202: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
1203: PO_LOG.proc_begin(d_mod,'p_document_format_tbl',p_document_format_tbl);
1204: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1205: END IF;
1206:

Line 1203: PO_LOG.proc_begin(d_mod,'p_document_format_tbl',p_document_format_tbl);

1199: IF PO_LOG.d_proc THEN
1200: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1201: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1202: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
1203: PO_LOG.proc_begin(d_mod,'p_document_format_tbl',p_document_format_tbl);
1204: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1205: END IF;
1206:
1207: IF (x_result_set_id IS NULL) THEN

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

1200: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1201: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1202: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
1203: PO_LOG.proc_begin(d_mod,'p_document_format_tbl',p_document_format_tbl);
1204: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1205: END IF;
1206:
1207: IF (x_result_set_id IS NULL) THEN
1208: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1254: IF PO_LOG.d_proc THEN

1250: ELSE
1251: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1252: END IF;
1253:
1254: IF PO_LOG.d_proc THEN
1255: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1256: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1257: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1258: END IF;

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

1252: END IF;
1253:
1254: IF PO_LOG.d_proc THEN
1255: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1256: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1257: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1258: END IF;
1259:
1260: EXCEPTION

Line 1257: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

1253:
1254: IF PO_LOG.d_proc THEN
1255: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1256: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1257: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1258: END IF;
1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN

Line 1262: IF PO_LOG.d_exc THEN

1258: END IF;
1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: IF PO_LOG.d_exc THEN
1263: PO_LOG.exc(d_mod,0,NULL);
1264: END IF;
1265: RAISE;
1266: END print_form_format_valid;

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

1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: IF PO_LOG.d_exc THEN
1263: PO_LOG.exc(d_mod,0,NULL);
1264: END IF;
1265: RAISE;
1266: END print_form_format_valid;
1267:

Line 1284: IF PO_LOG.d_proc THEN

1280: IS
1281: d_mod CONSTANT VARCHAR2(100) := D_effective_to_ge_order_date;
1282: BEGIN
1283:
1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1286: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1288: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1285: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1281: d_mod CONSTANT VARCHAR2(100) := D_effective_to_ge_order_date;
1282: BEGIN
1283:
1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1286: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1288: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1289: END IF;

Line 1286: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

1282: BEGIN
1283:
1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1286: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1288: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1289: END IF;
1290:

Line 1287: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);

1283:
1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1286: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1288: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1289: END IF;
1290:
1291: IF (x_result_set_id IS NULL) THEN

Line 1288: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1286: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1288: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1289: END IF;
1290:
1291: IF (x_result_set_id IS NULL) THEN
1292: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1337: IF PO_LOG.d_proc THEN

1333: ELSE
1334: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1335: END IF;
1336:
1337: IF PO_LOG.d_proc THEN
1338: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1339: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1340: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1341: END IF;

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

1335: END IF;
1336:
1337: IF PO_LOG.d_proc THEN
1338: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1339: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1340: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1341: END IF;
1342:
1343: EXCEPTION

Line 1340: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

1336:
1337: IF PO_LOG.d_proc THEN
1338: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1339: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1340: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1341: END IF;
1342:
1343: EXCEPTION
1344: WHEN OTHERS THEN

Line 1345: IF PO_LOG.d_exc THEN

1341: END IF;
1342:
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: IF PO_LOG.d_exc THEN
1346: PO_LOG.exc(d_mod,0,NULL);
1347: END IF;
1348: RAISE;
1349:

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

1342:
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: IF PO_LOG.d_exc THEN
1346: PO_LOG.exc(d_mod,0,NULL);
1347: END IF;
1348: RAISE;
1349:
1350: END effective_to_ge_order_date;

Line 1368: IF PO_LOG.d_proc THEN

1364: IS
1365: d_mod CONSTANT VARCHAR2(100) := D_contract_start_le_order_date;
1366: BEGIN
1367:
1368: IF PO_LOG.d_proc THEN
1369: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1370: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1371: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1372: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1369: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1365: d_mod CONSTANT VARCHAR2(100) := D_contract_start_le_order_date;
1366: BEGIN
1367:
1368: IF PO_LOG.d_proc THEN
1369: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1370: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1371: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1372: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1373: END IF;

Line 1370: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

1366: BEGIN
1367:
1368: IF PO_LOG.d_proc THEN
1369: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1370: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1371: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1372: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1373: END IF;
1374:

Line 1371: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);

1367:
1368: IF PO_LOG.d_proc THEN
1369: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1370: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1371: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1372: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1373: END IF;
1374:
1375: IF (x_result_set_id IS NULL) THEN

Line 1372: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

1368: IF PO_LOG.d_proc THEN
1369: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1370: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1371: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1372: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1373: END IF;
1374:
1375: IF (x_result_set_id IS NULL) THEN
1376: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1421: IF PO_LOG.d_proc THEN

1417: ELSE
1418: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1419: END IF;
1420:
1421: IF PO_LOG.d_proc THEN
1422: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1423: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1424: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1425: END IF;

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

1419: END IF;
1420:
1421: IF PO_LOG.d_proc THEN
1422: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1423: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1424: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1425: END IF;
1426:
1427: EXCEPTION

Line 1424: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

1420:
1421: IF PO_LOG.d_proc THEN
1422: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1423: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1424: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1425: END IF;
1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN

Line 1429: IF PO_LOG.d_exc THEN

1425: END IF;
1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: IF PO_LOG.d_exc THEN
1430: PO_LOG.exc(d_mod,0,NULL);
1431: END IF;
1432: RAISE;
1433:

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

1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: IF PO_LOG.d_exc THEN
1430: PO_LOG.exc(d_mod,0,NULL);
1431: END IF;
1432: RAISE;
1433:
1434: END contract_start_le_order_date;

Line 1452: IF PO_LOG.d_proc THEN

1448: IS
1449: d_mod CONSTANT VARCHAR2(100) := D_contract_end_ge_order_date;
1450: BEGIN
1451:
1452: IF PO_LOG.d_proc THEN
1453: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1454: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1455: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1456: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1453: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1449: d_mod CONSTANT VARCHAR2(100) := D_contract_end_ge_order_date;
1450: BEGIN
1451:
1452: IF PO_LOG.d_proc THEN
1453: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1454: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1455: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1456: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1457: END IF;

Line 1454: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

1450: BEGIN
1451:
1452: IF PO_LOG.d_proc THEN
1453: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1454: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1455: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1456: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1457: END IF;
1458:

Line 1455: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);

1451:
1452: IF PO_LOG.d_proc THEN
1453: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1454: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1455: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1456: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1457: END IF;
1458:
1459: IF (x_result_set_id IS NULL) THEN

Line 1456: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

1452: IF PO_LOG.d_proc THEN
1453: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1454: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1455: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1456: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1457: END IF;
1458:
1459: IF (x_result_set_id IS NULL) THEN
1460: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1505: IF PO_LOG.d_proc THEN

1501: ELSE
1502: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1503: END IF;
1504:
1505: IF PO_LOG.d_proc THEN
1506: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1507: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1508: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1509: END IF;

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

1503: END IF;
1504:
1505: IF PO_LOG.d_proc THEN
1506: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1507: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1508: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1509: END IF;
1510:
1511: EXCEPTION

Line 1508: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

1504:
1505: IF PO_LOG.d_proc THEN
1506: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1507: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1508: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1509: END IF;
1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN

Line 1513: IF PO_LOG.d_exc THEN

1509: END IF;
1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: IF PO_LOG.d_exc THEN
1514: PO_LOG.exc(d_mod,0,NULL);
1515: END IF;
1516: RAISE;
1517:

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

1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: IF PO_LOG.d_exc THEN
1514: PO_LOG.exc(d_mod,0,NULL);
1515: END IF;
1516: RAISE;
1517:
1518: END contract_end_ge_order_date;

Line 1543: IF PO_LOG.d_proc THEN

1539: l_num_test NUMBER;
1540: L_TEMP_SEGMENT PO_HEADERS_ALL.SEGMENT1%TYPE;
1541: BEGIN
1542:
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1545: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1546: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1547: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1544: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1540: L_TEMP_SEGMENT PO_HEADERS_ALL.SEGMENT1%TYPE;
1541: BEGIN
1542:
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1545: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1546: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1547: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1548: END IF;

Line 1545: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);

1541: BEGIN
1542:
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1545: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1546: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1547: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1548: END IF;
1549:

Line 1546: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);

1542:
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1545: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1546: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1547: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1548: END IF;
1549:
1550: IF (x_results IS NULL) THEN

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

1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1545: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1546: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1547: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1548: END IF;
1549:
1550: IF (x_results IS NULL) THEN
1551: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1640: IF PO_LOG.d_proc THEN

1636: ELSE
1637: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1638: END IF;
1639:
1640: IF PO_LOG.d_proc THEN
1641: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1642: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1643: END IF;
1644:

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

1637: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1638: END IF;
1639:
1640: IF PO_LOG.d_proc THEN
1641: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1642: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1643: END IF;
1644:
1645: EXCEPTION

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

1638: END IF;
1639:
1640: IF PO_LOG.d_proc THEN
1641: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1642: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1643: END IF;
1644:
1645: EXCEPTION
1646: WHEN OTHERS THEN

Line 1647: IF PO_LOG.d_exc THEN

1643: END IF;
1644:
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: IF PO_LOG.d_exc THEN
1648: PO_LOG.exc(d_mod,0,NULL);
1649: END IF;
1650: RAISE;
1651:

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

1644:
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: IF PO_LOG.d_exc THEN
1648: PO_LOG.exc(d_mod,0,NULL);
1649: END IF;
1650: RAISE;
1651:
1652: END doc_num_chars_valid;

Line 1683: IF PO_LOG.d_proc THEN

1679: l_pon_unique_status VARCHAR2(2000);
1680:
1681: BEGIN
1682:
1683: IF PO_LOG.d_proc THEN
1684: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1685: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1686: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1687: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

Line 1684: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

1680:
1681: BEGIN
1682:
1683: IF PO_LOG.d_proc THEN
1684: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1685: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1686: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1687: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1688: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1685: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);

1681: BEGIN
1682:
1683: IF PO_LOG.d_proc THEN
1684: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1685: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1686: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1687: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1688: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1689: END IF;

Line 1686: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);

1682:
1683: IF PO_LOG.d_proc THEN
1684: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1685: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1686: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1687: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1688: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1689: END IF;
1690:

Line 1687: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

1683: IF PO_LOG.d_proc THEN
1684: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1685: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1686: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1687: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1688: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1689: END IF;
1690:
1691: d_position := 1;

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

1684: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
1685: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1686: PO_LOG.proc_begin(d_mod,'p_segment1_tbl',p_segment1_tbl);
1687: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1688: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1689: END IF;
1690:
1691: d_position := 1;
1692:

Line 1798: IF PO_LOG.d_stmt THEN

1794: PO_SETUP_S1.get_sourcing_startup(l_check_sourcing_flag);
1795:
1796: d_position := 210;
1797:
1798: IF PO_LOG.d_stmt THEN
1799: PO_LOG.stmt(d_mod,d_position,'l_check_sourcing_flag',l_check_sourcing_flag);
1800: END IF;
1801:
1802: SELECT

Line 1799: PO_LOG.stmt(d_mod,d_position,'l_check_sourcing_flag',l_check_sourcing_flag);

1795:
1796: d_position := 210;
1797:
1798: IF PO_LOG.d_stmt THEN
1799: PO_LOG.stmt(d_mod,d_position,'l_check_sourcing_flag',l_check_sourcing_flag);
1800: END IF;
1801:
1802: SELECT
1803: SES.num1

Line 1827: IF PO_LOG.d_stmt THEN

1823: )
1824: ;
1825:
1826: d_position := 300;
1827: IF PO_LOG.d_stmt THEN
1828: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1829: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1830: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1831: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);

Line 1828: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);

1824: ;
1825:
1826: d_position := 300;
1827: IF PO_LOG.d_stmt THEN
1828: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1829: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1830: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1831: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);
1832: END IF;

Line 1829: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);

1825:
1826: d_position := 300;
1827: IF PO_LOG.d_stmt THEN
1828: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1829: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1830: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1831: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);
1832: END IF;
1833:

Line 1830: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);

1826: d_position := 300;
1827: IF PO_LOG.d_stmt THEN
1828: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1829: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1830: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1831: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);
1832: END IF;
1833:
1834: IF (l_check_sourcing_flag = 'I') THEN

Line 1831: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);

1827: IF PO_LOG.d_stmt THEN
1828: PO_LOG.stmt(d_mod,d_position,'l_header_id_tbl',l_header_id_tbl);
1829: PO_LOG.stmt(d_mod,d_position,'l_org_id_tbl',l_org_id_tbl);
1830: PO_LOG.stmt(d_mod,d_position,'l_segment1_tbl',l_segment1_tbl);
1831: PO_LOG.stmt(d_mod,d_position,'l_nonunique_tbl',l_nonunique_tbl);
1832: END IF;
1833:
1834: IF (l_check_sourcing_flag = 'I') THEN
1835: FOR i IN 1 .. l_header_id_tbl.COUNT LOOP

Line 1873: IF PO_LOG.d_proc THEN

1869: ELSE
1870: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1871: END IF;
1872:
1873: IF PO_LOG.d_proc THEN
1874: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1875: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1876: END IF;
1877:

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

1870: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1871: END IF;
1872:
1873: IF PO_LOG.d_proc THEN
1874: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1875: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1876: END IF;
1877:
1878: EXCEPTION

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

1871: END IF;
1872:
1873: IF PO_LOG.d_proc THEN
1874: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1875: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1876: END IF;
1877:
1878: EXCEPTION
1879: WHEN OTHERS THEN

Line 1880: IF PO_LOG.d_exc THEN

1876: END IF;
1877:
1878: EXCEPTION
1879: WHEN OTHERS THEN
1880: IF PO_LOG.d_exc THEN
1881: PO_LOG.exc(d_mod,d_position,NULL);
1882: END IF;
1883: RAISE;
1884:

Line 1881: PO_LOG.exc(d_mod,d_position,NULL);

1877:
1878: EXCEPTION
1879: WHEN OTHERS THEN
1880: IF PO_LOG.d_exc THEN
1881: PO_LOG.exc(d_mod,d_position,NULL);
1882: END IF;
1883: RAISE;
1884:
1885: END doc_num_unique;

Line 1915: IF PO_LOG.d_proc THEN

1911: l_message_name VARCHAR2(30);
1912: l_text VARCHAR2(4000);
1913: BEGIN
1914:
1915: IF PO_LOG.d_proc THEN
1916: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1917: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1918: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1919: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);

Line 1916: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);

1912: l_text VARCHAR2(4000);
1913: BEGIN
1914:
1915: IF PO_LOG.d_proc THEN
1916: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1917: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1918: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1919: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
1920: END IF;

Line 1917: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);

1913: BEGIN
1914:
1915: IF PO_LOG.d_proc THEN
1916: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1917: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1918: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1919: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
1920: END IF;
1921:

Line 1918: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);

1914:
1915: IF PO_LOG.d_proc THEN
1916: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1917: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1918: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1919: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
1920: END IF;
1921:
1922:

Line 1919: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);

1915: IF PO_LOG.d_proc THEN
1916: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
1917: PO_LOG.proc_begin(d_mod,'p_login_id',p_login_id);
1918: PO_LOG.proc_begin(d_mod,'p_user_id',p_user_id);
1919: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
1920: END IF;
1921:
1922:
1923: -- Check that the line's Expiration date is within the

Line 2160: IF PO_LOG.d_proc THEN

2156: ;
2157:
2158: x_sequence := x_sequence + SQL%ROWCOUNT;
2159:
2160: IF PO_LOG.d_proc THEN
2161: PO_LOG.proc_end(d_mod,'x_sequence',x_sequence);
2162: END IF;
2163:
2164: EXCEPTION

Line 2161: PO_LOG.proc_end(d_mod,'x_sequence',x_sequence);

2157:
2158: x_sequence := x_sequence + SQL%ROWCOUNT;
2159:
2160: IF PO_LOG.d_proc THEN
2161: PO_LOG.proc_end(d_mod,'x_sequence',x_sequence);
2162: END IF;
2163:
2164: EXCEPTION
2165: WHEN OTHERS THEN

Line 2166: IF PO_LOG.d_exc THEN

2162: END IF;
2163:
2164: EXCEPTION
2165: WHEN OTHERS THEN
2166: IF PO_LOG.d_exc THEN
2167: PO_LOG.exc(d_mod,0,NULL);
2168: END IF;
2169: RAISE;
2170:

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

2163:
2164: EXCEPTION
2165: WHEN OTHERS THEN
2166: IF PO_LOG.d_exc THEN
2167: PO_LOG.exc(d_mod,0,NULL);
2168: END IF;
2169: RAISE;
2170:
2171: END check_agreement_dates;

Line 2342: IF po_log.d_proc THEN

2338: IF x_result_set_id IS NULL THEN
2339: x_result_set_id := po_validations.next_result_set_id();
2340: END IF;
2341:
2342: IF po_log.d_proc THEN
2343: po_log.proc_begin(d_mod, 'p_header_id_tbl', p_header_id_tbl);
2344: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
2345: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2346:

Line 2343: po_log.proc_begin(d_mod, 'p_header_id_tbl', p_header_id_tbl);

2339: x_result_set_id := po_validations.next_result_set_id();
2340: END IF;
2341:
2342: IF po_log.d_proc THEN
2343: po_log.proc_begin(d_mod, 'p_header_id_tbl', p_header_id_tbl);
2344: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
2345: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2346:
2347:

Line 2344: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);

2340: END IF;
2341:
2342: IF po_log.d_proc THEN
2343: po_log.proc_begin(d_mod, 'p_header_id_tbl', p_header_id_tbl);
2344: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
2345: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2346:
2347:
2348: END IF;

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

2341:
2342: IF po_log.d_proc THEN
2343: po_log.proc_begin(d_mod, 'p_header_id_tbl', p_header_id_tbl);
2344: po_log.proc_begin(d_mod, 'p_ship_via_lookup_code_tbl', p_ship_via_lookup_code_tbl);
2345: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
2346:
2347:
2348: END IF;
2349:

Line 2400: IF po_log.d_proc THEN

2396: IF (SQL%ROWCOUNT > 0 ) THEN
2397: x_result_type := po_validations.c_result_type_FAILURE;
2398: END IF;
2399:
2400: IF po_log.d_proc THEN
2401: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2402: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2403: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2404: END IF;

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

2398: END IF;
2399:
2400: IF po_log.d_proc THEN
2401: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2402: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2403: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2404: END IF;
2405:
2406:

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

2399:
2400: IF po_log.d_proc THEN
2401: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
2402: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
2403: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2404: END IF;
2405:
2406:
2407: EXCEPTION

Line 2409: IF po_log.d_exc THEN

2405:
2406:
2407: EXCEPTION
2408: WHEN OTHERS THEN
2409: IF po_log.d_exc THEN
2410: po_log.exc(d_mod, 0, NULL);
2411: END IF;
2412: RAISE;
2413: END ship_via_lookup_code_valid;

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

2406:
2407: EXCEPTION
2408: WHEN OTHERS THEN
2409: IF po_log.d_exc THEN
2410: po_log.exc(d_mod, 0, NULL);
2411: END IF;
2412: RAISE;
2413: END ship_via_lookup_code_valid;
2414: --

Line 2430: IF PO_LOG.d_proc THEN

2426: IS
2427: d_mod CONSTANT VARCHAR2(100) := D_mod_eff_dt_lt_need_by_dt;
2428: BEGIN
2429:
2430: IF PO_LOG.d_proc THEN
2431: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2432: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);
2433: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2434: END IF;

Line 2431: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

2427: d_mod CONSTANT VARCHAR2(100) := D_mod_eff_dt_lt_need_by_dt;
2428: BEGIN
2429:
2430: IF PO_LOG.d_proc THEN
2431: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2432: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);
2433: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2434: END IF;
2435: IF (x_result_set_id IS NULL) THEN

Line 2432: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);

2428: BEGIN
2429:
2430: IF PO_LOG.d_proc THEN
2431: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2432: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);
2433: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2434: END IF;
2435: IF (x_result_set_id IS NULL) THEN
2436: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 2433: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

2429:
2430: IF PO_LOG.d_proc THEN
2431: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2432: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);
2433: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2434: END IF;
2435: IF (x_result_set_id IS NULL) THEN
2436: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2437: END IF;

Line 2467: IF PO_LOG.d_proc THEN

2463: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2464: END IF;
2465:
2466:
2467: IF PO_LOG.d_proc THEN
2468: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2469: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2470: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2471: END IF;

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

2465:
2466:
2467: IF PO_LOG.d_proc THEN
2468: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2469: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2470: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2471: END IF;
2472:
2473: EXCEPTION

Line 2470: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

2466:
2467: IF PO_LOG.d_proc THEN
2468: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2469: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2470: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2471: END IF;
2472:
2473: EXCEPTION
2474: WHEN OTHERS THEN

Line 2475: IF PO_LOG.d_exc THEN

2471: END IF;
2472:
2473: EXCEPTION
2474: WHEN OTHERS THEN
2475: IF PO_LOG.d_exc THEN
2476: PO_LOG.exc(d_mod,0,NULL);
2477: END IF;
2478: RAISE;
2479:

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

2472:
2473: EXCEPTION
2474: WHEN OTHERS THEN
2475: IF PO_LOG.d_exc THEN
2476: PO_LOG.exc(d_mod,0,NULL);
2477: END IF;
2478: RAISE;
2479:
2480: END mod_eff_dt_lt_need_by_dt;

Line 2496: IF PO_LOG.d_proc THEN

2492: IS
2493: d_mod CONSTANT VARCHAR2(100) := D_mod_eff_dt_not_null;
2494: BEGIN
2495:
2496: IF PO_LOG.d_proc THEN
2497: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2498: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
2499: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);
2500: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 2497: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

2493: d_mod CONSTANT VARCHAR2(100) := D_mod_eff_dt_not_null;
2494: BEGIN
2495:
2496: IF PO_LOG.d_proc THEN
2497: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2498: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
2499: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);
2500: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2501: END IF;

Line 2498: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);

2494: BEGIN
2495:
2496: IF PO_LOG.d_proc THEN
2497: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2498: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
2499: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);
2500: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2501: END IF;
2502: IF (x_result_set_id IS NULL) THEN

Line 2499: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);

2495:
2496: IF PO_LOG.d_proc THEN
2497: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2498: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
2499: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);
2500: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2501: END IF;
2502: IF (x_result_set_id IS NULL) THEN
2503: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 2500: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

2496: IF PO_LOG.d_proc THEN
2497: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2498: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
2499: PO_LOG.proc_begin(d_mod,'p_mod_eff_date_tbl',p_mod_eff_date_tbl);
2500: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2501: END IF;
2502: IF (x_result_set_id IS NULL) THEN
2503: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2504: END IF;

Line 2529: IF PO_LOG.d_proc THEN

2525: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2526: END IF;
2527:
2528:
2529: IF PO_LOG.d_proc THEN
2530: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2531: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2532: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2533: END IF;

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

2527:
2528:
2529: IF PO_LOG.d_proc THEN
2530: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2531: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2532: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2533: END IF;
2534:
2535: EXCEPTION

Line 2532: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

2528:
2529: IF PO_LOG.d_proc THEN
2530: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2531: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2532: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2533: END IF;
2534:
2535: EXCEPTION
2536: WHEN OTHERS THEN

Line 2537: IF PO_LOG.d_exc THEN

2533: END IF;
2534:
2535: EXCEPTION
2536: WHEN OTHERS THEN
2537: IF PO_LOG.d_exc THEN
2538: PO_LOG.exc(d_mod,0,NULL);
2539: END IF;
2540: RAISE;
2541:

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

2534:
2535: EXCEPTION
2536: WHEN OTHERS THEN
2537: IF PO_LOG.d_exc THEN
2538: PO_LOG.exc(d_mod,0,NULL);
2539: END IF;
2540: RAISE;
2541:
2542: END mod_eff_dt_not_null;

Line 2554: IF PO_LOG.d_proc THEN

2550: IS
2551: d_mod CONSTANT VARCHAR2(100) := D_mod_no_cancel_shp_complt;
2552: BEGIN
2553:
2554: IF PO_LOG.d_proc THEN
2555: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2556: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
2557: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2558: END IF;

Line 2555: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

2551: d_mod CONSTANT VARCHAR2(100) := D_mod_no_cancel_shp_complt;
2552: BEGIN
2553:
2554: IF PO_LOG.d_proc THEN
2555: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2556: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
2557: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2558: END IF;
2559: IF (x_result_set_id IS NULL) THEN

Line 2556: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);

2552: BEGIN
2553:
2554: IF PO_LOG.d_proc THEN
2555: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2556: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
2557: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2558: END IF;
2559: IF (x_result_set_id IS NULL) THEN
2560: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 2557: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

2553:
2554: IF PO_LOG.d_proc THEN
2555: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
2556: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
2557: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2558: END IF;
2559: IF (x_result_set_id IS NULL) THEN
2560: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2561: END IF;

Line 2592: IF PO_LOG.d_proc THEN

2588: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2589: END IF;
2590:
2591:
2592: IF PO_LOG.d_proc THEN
2593: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2594: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2595: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2596: END IF;

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

2590:
2591:
2592: IF PO_LOG.d_proc THEN
2593: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2594: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2595: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2596: END IF;
2597:
2598: EXCEPTION

Line 2595: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

2591:
2592: IF PO_LOG.d_proc THEN
2593: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2594: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2595: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2596: END IF;
2597:
2598: EXCEPTION
2599: WHEN OTHERS THEN

Line 2600: IF PO_LOG.d_exc THEN

2596: END IF;
2597:
2598: EXCEPTION
2599: WHEN OTHERS THEN
2600: IF PO_LOG.d_exc THEN
2601: PO_LOG.exc(d_mod,0,NULL);
2602: END IF;
2603: RAISE;
2604:

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

2597:
2598: EXCEPTION
2599: WHEN OTHERS THEN
2600: IF PO_LOG.d_exc THEN
2601: PO_LOG.exc(d_mod,0,NULL);
2602: END IF;
2603: RAISE;
2604:
2605: END mod_no_cancel_shp_complt;

Line 2628: IF PO_LOG.d_proc THEN

2624: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2625: RETURN;
2626: END IF;
2627:
2628: IF PO_LOG.d_proc THEN
2629: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2630: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
2631: END IF;
2632:

Line 2629: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

2625: RETURN;
2626: END IF;
2627:
2628: IF PO_LOG.d_proc THEN
2629: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2630: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
2631: END IF;
2632:
2633: FOR i IN 1..p_intf_header_id.Count

Line 2630: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);

2626: END IF;
2627:
2628: IF PO_LOG.d_proc THEN
2629: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2630: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
2631: END IF;
2632:
2633: FOR i IN 1..p_intf_header_id.Count
2634: LOOP

Line 2665: IF PO_LOG.d_proc THEN

2661: ELSE
2662: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2663: END IF;
2664:
2665: IF PO_LOG.d_proc THEN
2666: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2667: END IF;
2668: EXCEPTION
2669: WHEN OTHERS THEN

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

2662: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2663: END IF;
2664:
2665: IF PO_LOG.d_proc THEN
2666: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2667: END IF;
2668: EXCEPTION
2669: WHEN OTHERS THEN
2670: IF PO_LOG.d_exc THEN

Line 2670: IF PO_LOG.d_exc THEN

2666: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2667: END IF;
2668: EXCEPTION
2669: WHEN OTHERS THEN
2670: IF PO_LOG.d_exc THEN
2671: PO_LOG.exc(d_mod,0,NULL);
2672: END IF;
2673: RAISE;
2674:

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

2667: END IF;
2668: EXCEPTION
2669: WHEN OTHERS THEN
2670: IF PO_LOG.d_exc THEN
2671: PO_LOG.exc(d_mod,0,NULL);
2672: END IF;
2673: RAISE;
2674:
2675: END validate_clm_standard_form;

Line 2697: IF PO_LOG.d_proc THEN

2693: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2694: RETURN;
2695: END IF;
2696:
2697: IF PO_LOG.d_proc THEN
2698: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2699: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
2700: END IF;
2701:

Line 2698: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

2694: RETURN;
2695: END IF;
2696:
2697: IF PO_LOG.d_proc THEN
2698: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2699: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
2700: END IF;
2701:
2702: FOR i IN 1..p_intf_header_id.Count

Line 2699: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);

2695: END IF;
2696:
2697: IF PO_LOG.d_proc THEN
2698: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2699: PO_LOG.proc_begin(d_mod,'p_clm_standard_form_tbl',p_clm_standard_form_tbl);
2700: END IF;
2701:
2702: FOR i IN 1..p_intf_header_id.Count
2703: LOOP

Line 2746: IF PO_LOG.d_proc THEN

2742: ELSE
2743: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2744: END IF;
2745:
2746: IF PO_LOG.d_proc THEN
2747: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2748: END IF;
2749: EXCEPTION
2750: WHEN OTHERS THEN

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

2743: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2744: END IF;
2745:
2746: IF PO_LOG.d_proc THEN
2747: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2748: END IF;
2749: EXCEPTION
2750: WHEN OTHERS THEN
2751: IF PO_LOG.d_exc THEN

Line 2751: IF PO_LOG.d_exc THEN

2747: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2748: END IF;
2749: EXCEPTION
2750: WHEN OTHERS THEN
2751: IF PO_LOG.d_exc THEN
2752: PO_LOG.exc(d_mod,0,NULL);
2753: END IF;
2754: RAISE;
2755:

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

2748: END IF;
2749: EXCEPTION
2750: WHEN OTHERS THEN
2751: IF PO_LOG.d_exc THEN
2752: PO_LOG.exc(d_mod,0,NULL);
2753: END IF;
2754: RAISE;
2755:
2756: END validate_clm_document_format;

Line 2779: IF PO_LOG.d_proc THEN

2775: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2776: RETURN;
2777: END IF;
2778:
2779: IF PO_LOG.d_proc THEN
2780: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2781: PO_LOG.proc_begin(d_mod,'p_src_doc_id',p_src_doc_id_tbl);
2782: END IF;
2783:

Line 2780: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

2776: RETURN;
2777: END IF;
2778:
2779: IF PO_LOG.d_proc THEN
2780: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2781: PO_LOG.proc_begin(d_mod,'p_src_doc_id',p_src_doc_id_tbl);
2782: END IF;
2783:
2784: FOR i IN 1..p_intf_header_id.Count

Line 2781: PO_LOG.proc_begin(d_mod,'p_src_doc_id',p_src_doc_id_tbl);

2777: END IF;
2778:
2779: IF PO_LOG.d_proc THEN
2780: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2781: PO_LOG.proc_begin(d_mod,'p_src_doc_id',p_src_doc_id_tbl);
2782: END IF;
2783:
2784: FOR i IN 1..p_intf_header_id.Count
2785: LOOP

Line 2851: IF PO_LOG.d_proc THEN

2847: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2848: ELSE
2849: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2850: END IF;
2851: IF PO_LOG.d_proc THEN
2852: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2853: END IF;
2854: EXCEPTION
2855: WHEN OTHERS THEN

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

2848: ELSE
2849: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2850: END IF;
2851: IF PO_LOG.d_proc THEN
2852: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2853: END IF;
2854: EXCEPTION
2855: WHEN OTHERS THEN
2856: IF PO_LOG.d_exc THEN

Line 2856: IF PO_LOG.d_exc THEN

2852: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2853: END IF;
2854: EXCEPTION
2855: WHEN OTHERS THEN
2856: IF PO_LOG.d_exc THEN
2857: PO_LOG.exc(d_mod,0,NULL);
2858: END IF;
2859: RAISE;
2860:

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

2853: END IF;
2854: EXCEPTION
2855: WHEN OTHERS THEN
2856: IF PO_LOG.d_exc THEN
2857: PO_LOG.exc(d_mod,0,NULL);
2858: END IF;
2859: RAISE;
2860:
2861: END validate_source_idv;

Line 2883: IF PO_LOG.d_proc THEN

2879: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2880: RETURN;
2881: END IF;
2882:
2883: IF PO_LOG.d_proc THEN
2884: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2885: PO_LOG.proc_begin(d_mod,'p_award_admin_tbl',p_award_admin_tbl);
2886: END IF;
2887:

Line 2884: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

2880: RETURN;
2881: END IF;
2882:
2883: IF PO_LOG.d_proc THEN
2884: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2885: PO_LOG.proc_begin(d_mod,'p_award_admin_tbl',p_award_admin_tbl);
2886: END IF;
2887:
2888: FOR i IN 1..p_intf_header_id.Count

Line 2885: PO_LOG.proc_begin(d_mod,'p_award_admin_tbl',p_award_admin_tbl);

2881: END IF;
2882:
2883: IF PO_LOG.d_proc THEN
2884: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2885: PO_LOG.proc_begin(d_mod,'p_award_admin_tbl',p_award_admin_tbl);
2886: END IF;
2887:
2888: FOR i IN 1..p_intf_header_id.Count
2889: LOOP

Line 2919: IF PO_LOG.d_proc THEN

2915: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2916: ELSE
2917: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2918: END IF;
2919: IF PO_LOG.d_proc THEN
2920: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2921: END IF;
2922: EXCEPTION
2923: WHEN OTHERS THEN

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

2916: ELSE
2917: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2918: END IF;
2919: IF PO_LOG.d_proc THEN
2920: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2921: END IF;
2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: IF PO_LOG.d_exc THEN

Line 2924: IF PO_LOG.d_exc THEN

2920: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2921: END IF;
2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: IF PO_LOG.d_exc THEN
2925: PO_LOG.exc(d_mod,0,NULL);
2926: END IF;
2927: RAISE;
2928:

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

2921: END IF;
2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: IF PO_LOG.d_exc THEN
2925: PO_LOG.exc(d_mod,0,NULL);
2926: END IF;
2927: RAISE;
2928:
2929: END validate_award_admin;

Line 2951: IF PO_LOG.d_proc THEN

2947: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2948: RETURN;
2949: END IF;
2950:
2951: IF PO_LOG.d_proc THEN
2952: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2953: PO_LOG.proc_begin(d_mod,'p_contract_officer_tbl',p_contract_officer_tbl);
2954: END IF;
2955:

Line 2952: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

2948: RETURN;
2949: END IF;
2950:
2951: IF PO_LOG.d_proc THEN
2952: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2953: PO_LOG.proc_begin(d_mod,'p_contract_officer_tbl',p_contract_officer_tbl);
2954: END IF;
2955:
2956: FOR i IN 1..p_intf_header_id.Count

Line 2953: PO_LOG.proc_begin(d_mod,'p_contract_officer_tbl',p_contract_officer_tbl);

2949: END IF;
2950:
2951: IF PO_LOG.d_proc THEN
2952: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
2953: PO_LOG.proc_begin(d_mod,'p_contract_officer_tbl',p_contract_officer_tbl);
2954: END IF;
2955:
2956: FOR i IN 1..p_intf_header_id.Count
2957: LOOP

Line 2988: IF PO_LOG.d_proc THEN

2984: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2985: ELSE
2986: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2987: END IF;
2988: IF PO_LOG.d_proc THEN
2989: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2990: END IF;
2991: EXCEPTION
2992: WHEN OTHERS THEN

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

2985: ELSE
2986: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2987: END IF;
2988: IF PO_LOG.d_proc THEN
2989: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2990: END IF;
2991: EXCEPTION
2992: WHEN OTHERS THEN
2993: IF PO_LOG.d_exc THEN

Line 2993: IF PO_LOG.d_exc THEN

2989: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2990: END IF;
2991: EXCEPTION
2992: WHEN OTHERS THEN
2993: IF PO_LOG.d_exc THEN
2994: PO_LOG.exc(d_mod,0,NULL);
2995: END IF;
2996: RAISE;
2997:

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

2990: END IF;
2991: EXCEPTION
2992: WHEN OTHERS THEN
2993: IF PO_LOG.d_exc THEN
2994: PO_LOG.exc(d_mod,0,NULL);
2995: END IF;
2996: RAISE;
2997:
2998: END validate_contract_officer;

Line 3020: IF PO_LOG.d_proc THEN

3016: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3017: RETURN;
3018: END IF;
3019:
3020: IF PO_LOG.d_proc THEN
3021: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3022: PO_LOG.proc_begin(d_mod,'p_umbrella_program_id_tbl',p_umbrella_program_id_tbl);
3023: END IF;
3024:

Line 3021: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

3017: RETURN;
3018: END IF;
3019:
3020: IF PO_LOG.d_proc THEN
3021: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3022: PO_LOG.proc_begin(d_mod,'p_umbrella_program_id_tbl',p_umbrella_program_id_tbl);
3023: END IF;
3024:
3025: FOR i IN 1..p_intf_header_id.Count

Line 3022: PO_LOG.proc_begin(d_mod,'p_umbrella_program_id_tbl',p_umbrella_program_id_tbl);

3018: END IF;
3019:
3020: IF PO_LOG.d_proc THEN
3021: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3022: PO_LOG.proc_begin(d_mod,'p_umbrella_program_id_tbl',p_umbrella_program_id_tbl);
3023: END IF;
3024:
3025: FOR i IN 1..p_intf_header_id.Count
3026: LOOP

Line 3056: IF PO_LOG.d_proc THEN

3052: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3053: ELSE
3054: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3055: END IF;
3056: IF PO_LOG.d_proc THEN
3057: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3058: END IF;
3059: EXCEPTION
3060: WHEN OTHERS THEN

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

3053: ELSE
3054: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3055: END IF;
3056: IF PO_LOG.d_proc THEN
3057: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3058: END IF;
3059: EXCEPTION
3060: WHEN OTHERS THEN
3061: IF PO_LOG.d_exc THEN

Line 3061: IF PO_LOG.d_exc THEN

3057: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3058: END IF;
3059: EXCEPTION
3060: WHEN OTHERS THEN
3061: IF PO_LOG.d_exc THEN
3062: PO_LOG.exc(d_mod,0,NULL);
3063: END IF;
3064: RAISE;
3065:

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

3058: END IF;
3059: EXCEPTION
3060: WHEN OTHERS THEN
3061: IF PO_LOG.d_exc THEN
3062: PO_LOG.exc(d_mod,0,NULL);
3063: END IF;
3064: RAISE;
3065:
3066: END validate_umbrella_program_id;

Line 3089: IF PO_LOG.d_proc THEN

3085: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3086: RETURN;
3087: END IF;
3088:
3089: IF PO_LOG.d_proc THEN
3090: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3091: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
3092: PO_LOG.proc_begin(d_mod,'p_clm_award_type_tbl',p_clm_award_type_tbl);
3093: END IF;

Line 3090: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

3086: RETURN;
3087: END IF;
3088:
3089: IF PO_LOG.d_proc THEN
3090: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3091: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
3092: PO_LOG.proc_begin(d_mod,'p_clm_award_type_tbl',p_clm_award_type_tbl);
3093: END IF;
3094: IF (x_results IS NULL) THEN

Line 3091: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

3087: END IF;
3088:
3089: IF PO_LOG.d_proc THEN
3090: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3091: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
3092: PO_LOG.proc_begin(d_mod,'p_clm_award_type_tbl',p_clm_award_type_tbl);
3093: END IF;
3094: IF (x_results IS NULL) THEN
3095: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 3092: PO_LOG.proc_begin(d_mod,'p_clm_award_type_tbl',p_clm_award_type_tbl);

3088:
3089: IF PO_LOG.d_proc THEN
3090: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3091: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
3092: PO_LOG.proc_begin(d_mod,'p_clm_award_type_tbl',p_clm_award_type_tbl);
3093: END IF;
3094: IF (x_results IS NULL) THEN
3095: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3096: END IF;

Line 3154: IF PO_LOG.d_proc THEN

3150: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3151: ELSE
3152: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3153: END IF;
3154: IF PO_LOG.d_proc THEN
3155: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3156: END IF;
3157: EXCEPTION
3158: WHEN OTHERS THEN

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

3151: ELSE
3152: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3153: END IF;
3154: IF PO_LOG.d_proc THEN
3155: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3156: END IF;
3157: EXCEPTION
3158: WHEN OTHERS THEN
3159: IF PO_LOG.d_exc THEN

Line 3159: IF PO_LOG.d_exc THEN

3155: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3156: END IF;
3157: EXCEPTION
3158: WHEN OTHERS THEN
3159: IF PO_LOG.d_exc THEN
3160: PO_LOG.exc(d_mod,0,NULL);
3161: END IF;
3162: RAISE;
3163:

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

3156: END IF;
3157: EXCEPTION
3158: WHEN OTHERS THEN
3159: IF PO_LOG.d_exc THEN
3160: PO_LOG.exc(d_mod,0,NULL);
3161: END IF;
3162: RAISE;
3163:
3164: END validate_clm_award_type;

Line 3190: IF PO_LOG.d_proc THEN

3186: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3187: RETURN;
3188: END IF;
3189:
3190: IF PO_LOG.d_proc THEN
3191: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3192: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
3193: END IF;
3194: IF (x_results IS NULL) THEN

Line 3191: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

3187: RETURN;
3188: END IF;
3189:
3190: IF PO_LOG.d_proc THEN
3191: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3192: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
3193: END IF;
3194: IF (x_results IS NULL) THEN
3195: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

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

3188: END IF;
3189:
3190: IF PO_LOG.d_proc THEN
3191: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3192: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
3193: END IF;
3194: IF (x_results IS NULL) THEN
3195: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3196: END IF;

Line 3245: IF PO_LOG.d_proc THEN

3241: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3242: ELSE
3243: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3244: END IF;
3245: IF PO_LOG.d_proc THEN
3246: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3247: END IF;
3248: EXCEPTION
3249: WHEN OTHERS THEN

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

3242: ELSE
3243: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3244: END IF;
3245: IF PO_LOG.d_proc THEN
3246: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3247: END IF;
3248: EXCEPTION
3249: WHEN OTHERS THEN
3250: IF PO_LOG.d_exc THEN

Line 3250: IF PO_LOG.d_exc THEN

3246: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3247: END IF;
3248: EXCEPTION
3249: WHEN OTHERS THEN
3250: IF PO_LOG.d_exc THEN
3251: PO_LOG.exc(d_mod,0,NULL);
3252: END IF;
3253: RAISE;
3254:

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

3247: END IF;
3248: EXCEPTION
3249: WHEN OTHERS THEN
3250: IF PO_LOG.d_exc THEN
3251: PO_LOG.exc(d_mod,0,NULL);
3252: END IF;
3253: RAISE;
3254:
3255: END validate_style_id;

Line 3275: IF PO_LOG.d_proc THEN

3271: l_intf_header_id_tbl PO_TBL_NUMBER;
3272: l_style_id_tbl PO_TBL_NUMBER;
3273: BEGIN
3274:
3275: IF PO_LOG.d_proc THEN
3276: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3277: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
3278: END IF;
3279: IF (x_results IS NULL) THEN

Line 3276: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

3272: l_style_id_tbl PO_TBL_NUMBER;
3273: BEGIN
3274:
3275: IF PO_LOG.d_proc THEN
3276: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3277: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
3278: END IF;
3279: IF (x_results IS NULL) THEN
3280: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

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

3273: BEGIN
3274:
3275: IF PO_LOG.d_proc THEN
3276: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3277: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
3278: END IF;
3279: IF (x_results IS NULL) THEN
3280: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3281: END IF;

Line 3316: IF PO_LOG.d_proc THEN

3312: ELSE
3313: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3314: END IF;
3315:
3316: IF PO_LOG.d_proc THEN
3317: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3318: END IF;
3319: EXCEPTION
3320: WHEN OTHERS THEN

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

3313: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3314: END IF;
3315:
3316: IF PO_LOG.d_proc THEN
3317: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3318: END IF;
3319: EXCEPTION
3320: WHEN OTHERS THEN
3321: IF PO_LOG.d_exc THEN

Line 3321: IF PO_LOG.d_exc THEN

3317: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3318: END IF;
3319: EXCEPTION
3320: WHEN OTHERS THEN
3321: IF PO_LOG.d_exc THEN
3322: PO_LOG.exc(d_mod,0,NULL);
3323: END IF;
3324: RAISE;
3325:

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

3318: END IF;
3319: EXCEPTION
3320: WHEN OTHERS THEN
3321: IF PO_LOG.d_exc THEN
3322: PO_LOG.exc(d_mod,0,NULL);
3323: END IF;
3324: RAISE;
3325:
3326: END validate_idv_style_id;

Line 3345: IF PO_LOG.d_proc THEN

3341: l_intf_header_id_tbl PO_TBL_NUMBER;
3342: l_vendor_id_tbl PO_TBL_NUMBER;
3343: BEGIN
3344:
3345: IF PO_LOG.d_proc THEN
3346: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3347: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_vendor_id_tbl);
3348: END IF;
3349: IF (x_results IS NULL) THEN

Line 3346: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

3342: l_vendor_id_tbl PO_TBL_NUMBER;
3343: BEGIN
3344:
3345: IF PO_LOG.d_proc THEN
3346: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3347: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_vendor_id_tbl);
3348: END IF;
3349: IF (x_results IS NULL) THEN
3350: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

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

3343: BEGIN
3344:
3345: IF PO_LOG.d_proc THEN
3346: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3347: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_vendor_id_tbl);
3348: END IF;
3349: IF (x_results IS NULL) THEN
3350: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3351: END IF;

Line 3387: IF PO_LOG.d_proc THEN

3383: ELSE
3384: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3385: END IF;
3386:
3387: IF PO_LOG.d_proc THEN
3388: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3389: END IF;
3390: EXCEPTION
3391: WHEN OTHERS THEN

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

3384: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3385: END IF;
3386:
3387: IF PO_LOG.d_proc THEN
3388: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3389: END IF;
3390: EXCEPTION
3391: WHEN OTHERS THEN
3392: IF PO_LOG.d_exc THEN

Line 3392: IF PO_LOG.d_exc THEN

3388: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3389: END IF;
3390: EXCEPTION
3391: WHEN OTHERS THEN
3392: IF PO_LOG.d_exc THEN
3393: PO_LOG.exc(d_mod,0,NULL);
3394: END IF;
3395: RAISE;
3396:

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

3389: END IF;
3390: EXCEPTION
3391: WHEN OTHERS THEN
3392: IF PO_LOG.d_exc THEN
3393: PO_LOG.exc(d_mod,0,NULL);
3394: END IF;
3395: RAISE;
3396:
3397: END validate_po_idv_vendor_id;

Line 3417: IF PO_LOG.d_proc THEN

3413: l_intf_header_id_tbl PO_TBL_NUMBER;
3414: l_vendor_site_id_tbl PO_TBL_NUMBER;
3415: BEGIN
3416:
3417: IF PO_LOG.d_proc THEN
3418: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3419: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_vendor_site_id_tbl);
3420: END IF;
3421: IF (x_results IS NULL) THEN

Line 3418: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

3414: l_vendor_site_id_tbl PO_TBL_NUMBER;
3415: BEGIN
3416:
3417: IF PO_LOG.d_proc THEN
3418: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3419: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_vendor_site_id_tbl);
3420: END IF;
3421: IF (x_results IS NULL) THEN
3422: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

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

3415: BEGIN
3416:
3417: IF PO_LOG.d_proc THEN
3418: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);
3419: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_vendor_site_id_tbl);
3420: END IF;
3421: IF (x_results IS NULL) THEN
3422: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3423: END IF;

Line 3459: IF PO_LOG.d_proc THEN

3455: ELSE
3456: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3457: END IF;
3458:
3459: IF PO_LOG.d_proc THEN
3460: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3461: END IF;
3462: EXCEPTION
3463: WHEN OTHERS THEN

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

3456: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3457: END IF;
3458:
3459: IF PO_LOG.d_proc THEN
3460: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3461: END IF;
3462: EXCEPTION
3463: WHEN OTHERS THEN
3464: IF PO_LOG.d_exc THEN

Line 3464: IF PO_LOG.d_exc THEN

3460: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3461: END IF;
3462: EXCEPTION
3463: WHEN OTHERS THEN
3464: IF PO_LOG.d_exc THEN
3465: PO_LOG.exc(d_mod,0,NULL);
3466: END IF;
3467: RAISE;
3468:

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

3461: END IF;
3462: EXCEPTION
3463: WHEN OTHERS THEN
3464: IF PO_LOG.d_exc THEN
3465: PO_LOG.exc(d_mod,0,NULL);
3466: END IF;
3467: RAISE;
3468:
3469: END validate_po_idv_vendor_site_id;

Line 3485: IF PO_LOG.d_proc THEN

3481: d_mod CONSTANT VARCHAR2(100) := D_validate_mod_number;
3482: l_results_count NUMBER;
3483: BEGIN
3484:
3485: IF PO_LOG.d_proc THEN
3486: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
3487: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
3488: PO_LOG.proc_begin(d_mod,'p_mod_number_tbl',p_mod_number_tbl);
3489: END IF;

Line 3486: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);

3482: l_results_count NUMBER;
3483: BEGIN
3484:
3485: IF PO_LOG.d_proc THEN
3486: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
3487: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
3488: PO_LOG.proc_begin(d_mod,'p_mod_number_tbl',p_mod_number_tbl);
3489: END IF;
3490:

Line 3487: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);

3483: BEGIN
3484:
3485: IF PO_LOG.d_proc THEN
3486: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
3487: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
3488: PO_LOG.proc_begin(d_mod,'p_mod_number_tbl',p_mod_number_tbl);
3489: END IF;
3490:
3491: IF (x_results IS NULL) THEN

Line 3488: PO_LOG.proc_begin(d_mod,'p_mod_number_tbl',p_mod_number_tbl);

3484:
3485: IF PO_LOG.d_proc THEN
3486: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
3487: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
3488: PO_LOG.proc_begin(d_mod,'p_mod_number_tbl',p_mod_number_tbl);
3489: END IF;
3490:
3491: IF (x_results IS NULL) THEN
3492: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 3516: IF PO_LOG.d_proc THEN

3512: ELSE
3513: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3514: END IF;
3515:
3516: IF PO_LOG.d_proc THEN
3517: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3518: END IF;
3519: EXCEPTION
3520: WHEN OTHERS THEN

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

3513: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3514: END IF;
3515:
3516: IF PO_LOG.d_proc THEN
3517: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3518: END IF;
3519: EXCEPTION
3520: WHEN OTHERS THEN
3521: IF PO_LOG.d_exc THEN

Line 3521: IF PO_LOG.d_exc THEN

3517: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3518: END IF;
3519: EXCEPTION
3520: WHEN OTHERS THEN
3521: IF PO_LOG.d_exc THEN
3522: PO_LOG.exc(d_mod,0,NULL);
3523: END IF;
3524: RAISE;
3525: END validate_mod_number;

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

3518: END IF;
3519: EXCEPTION
3520: WHEN OTHERS THEN
3521: IF PO_LOG.d_exc THEN
3522: PO_LOG.exc(d_mod,0,NULL);
3523: END IF;
3524: RAISE;
3525: END validate_mod_number;
3526: