76:
77:
78: -- The module base for this package.
79: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
80: PO_LOG.get_package_base('PO_VAL_LINES');
81:
82: -- The module base for the subprogram.
83: D_amt_agreed_ge_zero CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_agreed_ge_zero');
80: PO_LOG.get_package_base('PO_VAL_LINES');
81:
82: -- The module base for the subprogram.
83: D_amt_agreed_ge_zero CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_agreed_ge_zero');
85:
86: -- The module base for the subprogram.
87: D_min_rel_amt_ge_zero CONSTANT VARCHAR2(100) :=
88: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_rel_amt_ge_zero');
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_agreed_ge_zero');
85:
86: -- The module base for the subprogram.
87: D_min_rel_amt_ge_zero CONSTANT VARCHAR2(100) :=
88: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_rel_amt_ge_zero');
89:
90: -- The module base for the subprogram.
91: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
92: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
88: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_rel_amt_ge_zero');
89:
90: -- The module base for the subprogram.
91: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
92: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
93:
94: -- The module base for the subprogram.
95: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
92: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
93:
94: -- The module base for the subprogram.
95: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
97:
98: -- The module base for the subprogram.
99: D_line_num_gt_zero CONSTANT VARCHAR2(100) :=
100: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_gt_zero');
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
97:
98: -- The module base for the subprogram.
99: D_line_num_gt_zero CONSTANT VARCHAR2(100) :=
100: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_gt_zero');
101:
102: D_otl_inv_start_date_change CONSTANT VARCHAR2(100) :=
103: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_start_date_change');
104:
99: D_line_num_gt_zero CONSTANT VARCHAR2(100) :=
100: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_gt_zero');
101:
102: D_otl_inv_start_date_change CONSTANT VARCHAR2(100) :=
103: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_start_date_change');
104:
105: D_otl_invalid_end_date_change CONSTANT VARCHAR2(100) :=
106: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_end_date_change');
107:
102: D_otl_inv_start_date_change CONSTANT VARCHAR2(100) :=
103: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_start_date_change');
104:
105: D_otl_invalid_end_date_change CONSTANT VARCHAR2(100) :=
106: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_end_date_change');
107:
108: D_quantity_notif_change CONSTANT VARCHAR2(100) :=
109: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_notif_change');
110:
105: D_otl_invalid_end_date_change CONSTANT VARCHAR2(100) :=
106: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_end_date_change');
107:
108: D_quantity_notif_change CONSTANT VARCHAR2(100) :=
109: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_notif_change');
110:
111: D_unit_price_ge_zero CONSTANT VARCHAR2(100) :=
112: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_price_ge_zero');
113:
108: D_quantity_notif_change CONSTANT VARCHAR2(100) :=
109: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_notif_change');
110:
111: D_unit_price_ge_zero CONSTANT VARCHAR2(100) :=
112: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_price_ge_zero');
113:
114: D_list_price_ge_zero CONSTANT VARCHAR2(100) :=
115: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'list_price_ge_zero');
116:
111: D_unit_price_ge_zero CONSTANT VARCHAR2(100) :=
112: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_price_ge_zero');
113:
114: D_list_price_ge_zero CONSTANT VARCHAR2(100) :=
115: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'list_price_ge_zero');
116:
117: D_market_price_ge_zero CONSTANT VARCHAR2(100) :=
118: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'market_price_ge_zero');
119:
114: D_list_price_ge_zero CONSTANT VARCHAR2(100) :=
115: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'list_price_ge_zero');
116:
117: D_market_price_ge_zero CONSTANT VARCHAR2(100) :=
118: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'market_price_ge_zero');
119:
120: D_quantity_ge_quantity_enc CONSTANT VARCHAR2(100) :=
121: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_enc');
122:
117: D_market_price_ge_zero CONSTANT VARCHAR2(100) :=
118: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'market_price_ge_zero');
119:
120: D_quantity_ge_quantity_enc CONSTANT VARCHAR2(100) :=
121: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_enc');
122:
123: D_amount_ge_timecard CONSTANT VARCHAR2(100) :=
124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_timecard');
125:
120: D_quantity_ge_quantity_enc CONSTANT VARCHAR2(100) :=
121: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_enc');
122:
123: D_amount_ge_timecard CONSTANT VARCHAR2(100) :=
124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_timecard');
125:
126: D_line_num_unique CONSTANT VARCHAR2(100) :=
127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_unique');
128:
123: D_amount_ge_timecard CONSTANT VARCHAR2(100) :=
124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_timecard');
125:
126: D_line_num_unique CONSTANT VARCHAR2(100) :=
127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_unique');
128:
129: --
130: D_clin_slin_num_check CONSTANT VARCHAR2(100) :=
131: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clin_slin_num_check');
127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_unique');
128:
129: --
130: D_clin_slin_num_check CONSTANT VARCHAR2(100) :=
131: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clin_slin_num_check');
132:
133: D_vmi_asl_exists CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vmi_asl_exists');
135:
130: D_clin_slin_num_check CONSTANT VARCHAR2(100) :=
131: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clin_slin_num_check');
132:
133: D_vmi_asl_exists CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vmi_asl_exists');
135:
136: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
138:
133: D_vmi_asl_exists CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vmi_asl_exists');
135:
136: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
138:
139: D_validate_unit_price_change CONSTANT VARCHAR2(100) :=
140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');
141:
136: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
138:
139: D_validate_unit_price_change CONSTANT VARCHAR2(100) :=
140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');
141:
142: D_expiration_ge_blanket_start CONSTANT VARCHAR2(100) :=
143: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_ge_blanket_start');
144:
139: D_validate_unit_price_change CONSTANT VARCHAR2(100) :=
140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');
141:
142: D_expiration_ge_blanket_start CONSTANT VARCHAR2(100) :=
143: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_ge_blanket_start');
144:
145: D_expiration_le_blanket_end CONSTANT VARCHAR2(100) :=
146: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_le_blanket_end');
147:
142: D_expiration_ge_blanket_start CONSTANT VARCHAR2(100) :=
143: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_ge_blanket_start');
144:
145: D_expiration_le_blanket_end CONSTANT VARCHAR2(100) :=
146: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_le_blanket_end');
147:
148: --
149: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'quantity_ge_quantity_exec');
146: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_le_blanket_end');
147:
148: --
149: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'quantity_ge_quantity_exec');
151: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_ge_amount_exec');
153: D_price_ge_price_mstone_exec CONSTANT VARCHAR2(100) :=
154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'price_ge_price_milestone_exec');
148: --
149: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'quantity_ge_quantity_exec');
151: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_ge_amount_exec');
153: D_price_ge_price_mstone_exec CONSTANT VARCHAR2(100) :=
154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'price_ge_price_milestone_exec');
155: D_qty_ge_qty_milestone_exec CONSTANT VARCHAR2(100) :=
156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_ge_qty_milestone_exec');
150: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'quantity_ge_quantity_exec');
151: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_ge_amount_exec');
153: D_price_ge_price_mstone_exec CONSTANT VARCHAR2(100) :=
154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'price_ge_price_milestone_exec');
155: D_qty_ge_qty_milestone_exec CONSTANT VARCHAR2(100) :=
156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_ge_qty_milestone_exec');
157: -- Bug 5072189 Start
158: D_recoupment_rate_range_check CONSTANT VARCHAR2(100) :=
152: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_ge_amount_exec');
153: D_price_ge_price_mstone_exec CONSTANT VARCHAR2(100) :=
154: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'price_ge_price_milestone_exec');
155: D_qty_ge_qty_milestone_exec CONSTANT VARCHAR2(100) :=
156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_ge_qty_milestone_exec');
157: -- Bug 5072189 Start
158: D_recoupment_rate_range_check CONSTANT VARCHAR2(100) :=
159: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'recoupment_rate_range_check');
160: D_retainage_rate_range_check CONSTANT VARCHAR2(100) :=
155: D_qty_ge_qty_milestone_exec CONSTANT VARCHAR2(100) :=
156: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_ge_qty_milestone_exec');
157: -- Bug 5072189 Start
158: D_recoupment_rate_range_check CONSTANT VARCHAR2(100) :=
159: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'recoupment_rate_range_check');
160: D_retainage_rate_range_check CONSTANT VARCHAR2(100) :=
161: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'retainage_rate_range_check');
162: D_prog_pay_rate_range_check CONSTANT VARCHAR2(100) :=
163: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'prog_pay_rate_range_check');
157: -- Bug 5072189 Start
158: D_recoupment_rate_range_check CONSTANT VARCHAR2(100) :=
159: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'recoupment_rate_range_check');
160: D_retainage_rate_range_check CONSTANT VARCHAR2(100) :=
161: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'retainage_rate_range_check');
162: D_prog_pay_rate_range_check CONSTANT VARCHAR2(100) :=
163: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'prog_pay_rate_range_check');
164: -- Bug 5072189 End
165: D_max_retain_amt_ge_zero CONSTANT VARCHAR2(100) :=
159: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'recoupment_rate_range_check');
160: D_retainage_rate_range_check CONSTANT VARCHAR2(100) :=
161: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'retainage_rate_range_check');
162: D_prog_pay_rate_range_check CONSTANT VARCHAR2(100) :=
163: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'prog_pay_rate_range_check');
164: -- Bug 5072189 End
165: D_max_retain_amt_ge_zero CONSTANT VARCHAR2(100) :=
166: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_zero'); --Bug 5221843
167: D_max_retain_amt_ge_retained CONSTANT VARCHAR2(100) :=
162: D_prog_pay_rate_range_check CONSTANT VARCHAR2(100) :=
163: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'prog_pay_rate_range_check');
164: -- Bug 5072189 End
165: D_max_retain_amt_ge_zero CONSTANT VARCHAR2(100) :=
166: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_zero'); --Bug 5221843
167: D_max_retain_amt_ge_retained CONSTANT VARCHAR2(100) :=
168: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_retained'); --Bug 5453079
169: -- Bug 5070210 Start
170: D_advance_amt_le_amt CONSTANT VARCHAR2(100) :=
164: -- Bug 5072189 End
165: D_max_retain_amt_ge_zero CONSTANT VARCHAR2(100) :=
166: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_zero'); --Bug 5221843
167: D_max_retain_amt_ge_retained CONSTANT VARCHAR2(100) :=
168: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_retained'); --Bug 5453079
169: -- Bug 5070210 Start
170: D_advance_amt_le_amt CONSTANT VARCHAR2(100) :=
171: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'advance_amt_le_amt');
172: -- Bug 5070210 End
167: D_max_retain_amt_ge_retained CONSTANT VARCHAR2(100) :=
168: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_retained'); --Bug 5453079
169: -- Bug 5070210 Start
170: D_advance_amt_le_amt CONSTANT VARCHAR2(100) :=
171: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'advance_amt_le_amt');
172: -- Bug 5070210 End
173: --
174: D_complex_po_attributes_check CONSTANT VARCHAR2(100) :=
175: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'complex_po_attributes_check');
171: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'advance_amt_le_amt');
172: -- Bug 5070210 End
173: --
174: D_complex_po_attributes_check CONSTANT VARCHAR2(100) :=
175: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'complex_po_attributes_check');
176: --
177: --
178: D_unit_meas_not_null CONSTANT VARCHAR2(100) :=
179: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unit_meas_not_null');
175: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'complex_po_attributes_check');
176: --
177: --
178: D_unit_meas_not_null CONSTANT VARCHAR2(100) :=
179: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unit_meas_not_null');
180: D_item_description_not_null CONSTANT VARCHAR2(100) :=
181: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_description_not_null');
182: --
183: D_validate_comments_not_null CONSTANT VARCHAR2(100) :=
177: --
178: D_unit_meas_not_null CONSTANT VARCHAR2(100) :=
179: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unit_meas_not_null');
180: D_item_description_not_null CONSTANT VARCHAR2(100) :=
181: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_description_not_null');
182: --
183: D_validate_comments_not_null CONSTANT VARCHAR2(100) :=
184: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_comments_not_null');
185: D_line_num_disp_check CONSTANT VARCHAR2(100) :=
180: D_item_description_not_null CONSTANT VARCHAR2(100) :=
181: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_description_not_null');
182: --
183: D_validate_comments_not_null CONSTANT VARCHAR2(100) :=
184: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_comments_not_null');
185: D_line_num_disp_check CONSTANT VARCHAR2(100) :=
186: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'line_num_disp_check');
187:
188: D_category_id_not_null CONSTANT VARCHAR2(100) :=
182: --
183: D_validate_comments_not_null CONSTANT VARCHAR2(100) :=
184: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_comments_not_null');
185: D_line_num_disp_check CONSTANT VARCHAR2(100) :=
186: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'line_num_disp_check');
187:
188: D_category_id_not_null CONSTANT VARCHAR2(100) :=
189: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');
190: D_item_id_not_null CONSTANT VARCHAR2(100) :=
185: D_line_num_disp_check CONSTANT VARCHAR2(100) :=
186: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'line_num_disp_check');
187:
188: D_category_id_not_null CONSTANT VARCHAR2(100) :=
189: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');
190: D_item_id_not_null CONSTANT VARCHAR2(100) :=
191: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');
192: D_temp_labor_job_id_not_null CONSTANT VARCHAR2(100) :=
193: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');
187:
188: D_category_id_not_null CONSTANT VARCHAR2(100) :=
189: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');
190: D_item_id_not_null CONSTANT VARCHAR2(100) :=
191: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');
192: D_temp_labor_job_id_not_null CONSTANT VARCHAR2(100) :=
193: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');
194: D_line_type_id_not_null CONSTANT VARCHAR2(100) :=
195: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');
189: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');
190: D_item_id_not_null CONSTANT VARCHAR2(100) :=
191: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');
192: D_temp_labor_job_id_not_null CONSTANT VARCHAR2(100) :=
193: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');
194: D_line_type_id_not_null CONSTANT VARCHAR2(100) :=
195: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');
196: D_temp_lbr_start_date_not_null CONSTANT VARCHAR2(100) :=
197: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'temp_lbr_start_date_not_null');
191: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');
192: D_temp_labor_job_id_not_null CONSTANT VARCHAR2(100) :=
193: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');
194: D_line_type_id_not_null CONSTANT VARCHAR2(100) :=
195: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');
196: D_temp_lbr_start_date_not_null CONSTANT VARCHAR2(100) :=
197: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'temp_lbr_start_date_not_null');
198: D_src_doc_line_not_null CONSTANT VARCHAR2(100) :=
199: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'src_doc_line_not_null');
193: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');
194: D_line_type_id_not_null CONSTANT VARCHAR2(100) :=
195: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');
196: D_temp_lbr_start_date_not_null CONSTANT VARCHAR2(100) :=
197: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'temp_lbr_start_date_not_null');
198: D_src_doc_line_not_null CONSTANT VARCHAR2(100) :=
199: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'src_doc_line_not_null');
200: -- The module base for the subprogram.
201: D_line_qtys_within_deviation CONSTANT VARCHAR2(100) :=
195: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');
196: D_temp_lbr_start_date_not_null CONSTANT VARCHAR2(100) :=
197: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'temp_lbr_start_date_not_null');
198: D_src_doc_line_not_null CONSTANT VARCHAR2(100) :=
199: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'src_doc_line_not_null');
200: -- The module base for the subprogram.
201: D_line_qtys_within_deviation CONSTANT VARCHAR2(100) :=
202: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_qtys_within_deviation');
203: D_line_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
198: D_src_doc_line_not_null CONSTANT VARCHAR2(100) :=
199: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'src_doc_line_not_null');
200: -- The module base for the subprogram.
201: D_line_qtys_within_deviation CONSTANT VARCHAR2(100) :=
202: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_qtys_within_deviation');
203: D_line_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
204: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_sec_quantity_gt_zero');
205: D_from_line_id_not_null CONSTANT VARCHAR2(100) :=
206: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'from_line_id_not_null');
200: -- The module base for the subprogram.
201: D_line_qtys_within_deviation CONSTANT VARCHAR2(100) :=
202: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_qtys_within_deviation');
203: D_line_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
204: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_sec_quantity_gt_zero');
205: D_from_line_id_not_null CONSTANT VARCHAR2(100) :=
206: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'from_line_id_not_null');
207:
208: D_option_from_date_not_null CONSTANT VARCHAR2(100) :=
202: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_qtys_within_deviation');
203: D_line_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
204: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_sec_quantity_gt_zero');
205: D_from_line_id_not_null CONSTANT VARCHAR2(100) :=
206: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'from_line_id_not_null');
207:
208: D_option_from_date_not_null CONSTANT VARCHAR2(100) :=
209: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_from_date_not_null');
210:
205: D_from_line_id_not_null CONSTANT VARCHAR2(100) :=
206: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'from_line_id_not_null');
207:
208: D_option_from_date_not_null CONSTANT VARCHAR2(100) :=
209: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_from_date_not_null');
210:
211: D_option_to_date_not_null CONSTANT VARCHAR2(100) :=
212: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_to_date_not_null');
213:
208: D_option_from_date_not_null CONSTANT VARCHAR2(100) :=
209: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_from_date_not_null');
210:
211: D_option_to_date_not_null CONSTANT VARCHAR2(100) :=
212: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_to_date_not_null');
213:
214: D_option_to_date_le_from_date CONSTANT VARCHAR2(100) :=
215: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_to_date_le_from_date');
216:
211: D_option_to_date_not_null CONSTANT VARCHAR2(100) :=
212: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_to_date_not_null');
213:
214: D_option_to_date_le_from_date CONSTANT VARCHAR2(100) :=
215: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_to_date_le_from_date');
216:
217: D_option_from_date_le_sysdate CONSTANT VARCHAR2(100) :=
218: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_from_date_le_sysdate');
219:
214: D_option_to_date_le_from_date CONSTANT VARCHAR2(100) :=
215: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_to_date_le_from_date');
216:
217: D_option_from_date_le_sysdate CONSTANT VARCHAR2(100) :=
218: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_from_date_le_sysdate');
219:
220: D_option_fm_date_le_ex_date CONSTANT VARCHAR2(100) :=
221: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_fm_date_le_ex_date');
222:
217: D_option_from_date_le_sysdate CONSTANT VARCHAR2(100) :=
218: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_from_date_le_sysdate');
219:
220: D_option_fm_date_le_ex_date CONSTANT VARCHAR2(100) :=
221: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_fm_date_le_ex_date');
222:
223: -- Mod Project
224: D_mod_no_cancel_shp_complt CONSTANT VARCHAR2(100) :=
225: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');
221: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'option_fm_date_le_ex_date');
222:
223: -- Mod Project
224: D_mod_no_cancel_shp_complt CONSTANT VARCHAR2(100) :=
225: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');
226:
227: -- Fed Fields
228: D_order_start_date_gt_sysdate CONSTANT VARCHAR2(100) :=
229: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'order_start_date_gt_sysdate');
225: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');
226:
227: -- Fed Fields
228: D_order_start_date_gt_sysdate CONSTANT VARCHAR2(100) :=
229: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'order_start_date_gt_sysdate');
230: D_max_tot_amt_le_line_tot_amt CONSTANT VARCHAR2(100) :=
231: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_amt_le_line_tot_amt');
232: D_max_tot_amt_ge_min_tot_amt CONSTANT VARCHAR2(100) :=
233: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_amt_ge_min_tot_amt');
227: -- Fed Fields
228: D_order_start_date_gt_sysdate CONSTANT VARCHAR2(100) :=
229: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'order_start_date_gt_sysdate');
230: D_max_tot_amt_le_line_tot_amt CONSTANT VARCHAR2(100) :=
231: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_amt_le_line_tot_amt');
232: D_max_tot_amt_ge_min_tot_amt CONSTANT VARCHAR2(100) :=
233: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_amt_ge_min_tot_amt');
234: D_max_tot_qty_le_line_tot_qty CONSTANT VARCHAR2(100) :=
235: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_le_line_tot_qty');
229: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'order_start_date_gt_sysdate');
230: D_max_tot_amt_le_line_tot_amt CONSTANT VARCHAR2(100) :=
231: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_amt_le_line_tot_amt');
232: D_max_tot_amt_ge_min_tot_amt CONSTANT VARCHAR2(100) :=
233: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_amt_ge_min_tot_amt');
234: D_max_tot_qty_le_line_tot_qty CONSTANT VARCHAR2(100) :=
235: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_le_line_tot_qty');
236: D_max_tot_qty_ge_min_tot_qty CONSTANT VARCHAR2(100) :=
237: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_ge_min_tot_qty');
231: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_amt_le_line_tot_amt');
232: D_max_tot_amt_ge_min_tot_amt CONSTANT VARCHAR2(100) :=
233: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_amt_ge_min_tot_amt');
234: D_max_tot_qty_le_line_tot_qty CONSTANT VARCHAR2(100) :=
235: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_le_line_tot_qty');
236: D_max_tot_qty_ge_min_tot_qty CONSTANT VARCHAR2(100) :=
237: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_ge_min_tot_qty');
238: D_max_ord_amt_le_max_tot_amt CONSTANT VARCHAR2(100) :=
239: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_le_max_tot_amt');
233: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_amt_ge_min_tot_amt');
234: D_max_tot_qty_le_line_tot_qty CONSTANT VARCHAR2(100) :=
235: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_le_line_tot_qty');
236: D_max_tot_qty_ge_min_tot_qty CONSTANT VARCHAR2(100) :=
237: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_ge_min_tot_qty');
238: D_max_ord_amt_le_max_tot_amt CONSTANT VARCHAR2(100) :=
239: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_le_max_tot_amt');
240: D_max_ord_amt_ge_min_ord_amt CONSTANT VARCHAR2(100) :=
241: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_ge_min_ord_amt');
235: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_le_line_tot_qty');
236: D_max_tot_qty_ge_min_tot_qty CONSTANT VARCHAR2(100) :=
237: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_ge_min_tot_qty');
238: D_max_ord_amt_le_max_tot_amt CONSTANT VARCHAR2(100) :=
239: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_le_max_tot_amt');
240: D_max_ord_amt_ge_min_ord_amt CONSTANT VARCHAR2(100) :=
241: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_ge_min_ord_amt');
242: D_max_ord_qty_le_max_tot_qty CONSTANT VARCHAR2(100) :=
243: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_qty_le_max_tot_qty');
237: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_tot_qty_ge_min_tot_qty');
238: D_max_ord_amt_le_max_tot_amt CONSTANT VARCHAR2(100) :=
239: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_le_max_tot_amt');
240: D_max_ord_amt_ge_min_ord_amt CONSTANT VARCHAR2(100) :=
241: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_ge_min_ord_amt');
242: D_max_ord_qty_le_max_tot_qty CONSTANT VARCHAR2(100) :=
243: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_qty_le_max_tot_qty');
244: D_max_ord_qty_ge_min_ord_qty CONSTANT VARCHAR2(100) :=
245: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_qty_ge_min_ord_qty');
239: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_le_max_tot_amt');
240: D_max_ord_amt_ge_min_ord_amt CONSTANT VARCHAR2(100) :=
241: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_ge_min_ord_amt');
242: D_max_ord_qty_le_max_tot_qty CONSTANT VARCHAR2(100) :=
243: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_qty_le_max_tot_qty');
244: D_max_ord_qty_ge_min_ord_qty CONSTANT VARCHAR2(100) :=
245: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_qty_ge_min_ord_qty');
246: --CLM PDOI Integration
247: D_clin_slin_structure CONSTANT VARCHAR2(100) :=
241: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_amt_ge_min_ord_amt');
242: D_max_ord_qty_le_max_tot_qty CONSTANT VARCHAR2(100) :=
243: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_qty_le_max_tot_qty');
244: D_max_ord_qty_ge_min_ord_qty CONSTANT VARCHAR2(100) :=
245: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_qty_ge_min_ord_qty');
246: --CLM PDOI Integration
247: D_clin_slin_structure CONSTANT VARCHAR2(100) :=
248: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'clin_slin_structure');
249: D_validate_contract_type CONSTANT VARCHAR2(100) :=
244: D_max_ord_qty_ge_min_ord_qty CONSTANT VARCHAR2(100) :=
245: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_ord_qty_ge_min_ord_qty');
246: --CLM PDOI Integration
247: D_clin_slin_structure CONSTANT VARCHAR2(100) :=
248: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'clin_slin_structure');
249: D_validate_contract_type CONSTANT VARCHAR2(100) :=
250: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_type');
251: D_validate_cost_constraint CONSTANT VARCHAR2(100) :=
252: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_cost_constraint');
246: --CLM PDOI Integration
247: D_clin_slin_structure CONSTANT VARCHAR2(100) :=
248: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'clin_slin_structure');
249: D_validate_contract_type CONSTANT VARCHAR2(100) :=
250: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_type');
251: D_validate_cost_constraint CONSTANT VARCHAR2(100) :=
252: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_cost_constraint');
253: D_check_contract_num_and_ver CONSTANT VARCHAR2(100) :=
254: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_contract_num_and_ver');
248: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'clin_slin_structure');
249: D_validate_contract_type CONSTANT VARCHAR2(100) :=
250: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_type');
251: D_validate_cost_constraint CONSTANT VARCHAR2(100) :=
252: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_cost_constraint');
253: D_check_contract_num_and_ver CONSTANT VARCHAR2(100) :=
254: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_contract_num_and_ver');
255: D_validate_option_indicator CONSTANT VARCHAR2(100) :=
256: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_option_indicator');
250: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_contract_type');
251: D_validate_cost_constraint CONSTANT VARCHAR2(100) :=
252: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_cost_constraint');
253: D_check_contract_num_and_ver CONSTANT VARCHAR2(100) :=
254: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_contract_num_and_ver');
255: D_validate_option_indicator CONSTANT VARCHAR2(100) :=
256: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_option_indicator');
257: D_validate_clm_base_line_num CONSTANT VARCHAR2(100) :=
258: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_base_line_num');
252: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_cost_constraint');
253: D_check_contract_num_and_ver CONSTANT VARCHAR2(100) :=
254: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_contract_num_and_ver');
255: D_validate_option_indicator CONSTANT VARCHAR2(100) :=
256: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_option_indicator');
257: D_validate_clm_base_line_num CONSTANT VARCHAR2(100) :=
258: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_base_line_num');
259: D_validate_clm_option_num CONSTANT VARCHAR2(100) :=
260: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_option_num');
254: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_contract_num_and_ver');
255: D_validate_option_indicator CONSTANT VARCHAR2(100) :=
256: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_option_indicator');
257: D_validate_clm_base_line_num CONSTANT VARCHAR2(100) :=
258: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_base_line_num');
259: D_validate_clm_option_num CONSTANT VARCHAR2(100) :=
260: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_option_num');
261: D_validate_clm_idc_type CONSTANT VARCHAR2(100) :=
262: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_idc_type');
256: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_option_indicator');
257: D_validate_clm_base_line_num CONSTANT VARCHAR2(100) :=
258: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_base_line_num');
259: D_validate_clm_option_num CONSTANT VARCHAR2(100) :=
260: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_option_num');
261: D_validate_clm_idc_type CONSTANT VARCHAR2(100) :=
262: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_idc_type');
263: D_validate_clin_line_num_disp CONSTANT VARCHAR2(100) :=
264: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clin_line_num_disp');
258: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_base_line_num');
259: D_validate_clm_option_num CONSTANT VARCHAR2(100) :=
260: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_option_num');
261: D_validate_clm_idc_type CONSTANT VARCHAR2(100) :=
262: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_idc_type');
263: D_validate_clin_line_num_disp CONSTANT VARCHAR2(100) :=
264: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clin_line_num_disp');
265: D_idv_reference_equal_check CONSTANT VARCHAR2(100) :=
266: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'idv_reference_equal_check');
260: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_option_num');
261: D_validate_clm_idc_type CONSTANT VARCHAR2(100) :=
262: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_idc_type');
263: D_validate_clin_line_num_disp CONSTANT VARCHAR2(100) :=
264: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clin_line_num_disp');
265: D_idv_reference_equal_check CONSTANT VARCHAR2(100) :=
266: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'idv_reference_equal_check');
267: D_validate_clm_line_type_id CONSTANT VARCHAR2(100) :=
268: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_line_type_id');
262: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_idc_type');
263: D_validate_clin_line_num_disp CONSTANT VARCHAR2(100) :=
264: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clin_line_num_disp');
265: D_idv_reference_equal_check CONSTANT VARCHAR2(100) :=
266: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'idv_reference_equal_check');
267: D_validate_clm_line_type_id CONSTANT VARCHAR2(100) :=
268: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_line_type_id');
269: -- bug 16461105
270: D_mod_undef_amt_le_line_amt CONSTANT VARCHAR2(100) :=
264: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clin_line_num_disp');
265: D_idv_reference_equal_check CONSTANT VARCHAR2(100) :=
266: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'idv_reference_equal_check');
267: D_validate_clm_line_type_id CONSTANT VARCHAR2(100) :=
268: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_line_type_id');
269: -- bug 16461105
270: D_mod_undef_amt_le_line_amt CONSTANT VARCHAR2(100) :=
271: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'Validate_undef_amt_le_line_amt');
272: -- bug 16461105
267: D_validate_clm_line_type_id CONSTANT VARCHAR2(100) :=
268: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_clm_line_type_id');
269: -- bug 16461105
270: D_mod_undef_amt_le_line_amt CONSTANT VARCHAR2(100) :=
271: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'Validate_undef_amt_le_line_amt');
272: -- bug 16461105
273:
274: -------------------------------------------------------------------------------
275: -- This procedure determines if Amount Agreed on blanket lines is greater
381: IS
382: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
383: BEGIN
384:
385: IF PO_LOG.d_proc THEN
386: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
387: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
388: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
389: END IF;
382: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
383: BEGIN
384:
385: IF PO_LOG.d_proc THEN
386: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
387: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
388: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
389: END IF;
390:
383: BEGIN
384:
385: IF PO_LOG.d_proc THEN
386: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
387: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
388: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
389: END IF;
390:
391: IF (x_result_set_id IS NULL) THEN
384:
385: IF PO_LOG.d_proc THEN
386: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
387: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
388: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
389: END IF;
390:
391: IF (x_result_set_id IS NULL) THEN
392: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
463: ELSE
464: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
465: END IF;
466:
467: IF PO_LOG.d_proc THEN
468: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
469: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
470: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
471: END IF;
465: END IF;
466:
467: IF PO_LOG.d_proc THEN
468: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
469: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
470: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
471: END IF;
472:
473: EXCEPTION
466:
467: IF PO_LOG.d_proc THEN
468: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
469: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
470: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
471: END IF;
472:
473: EXCEPTION
474: WHEN OTHERS THEN
471: END IF;
472:
473: EXCEPTION
474: WHEN OTHERS THEN
475: IF PO_LOG.d_exc THEN
476: PO_LOG.exc(d_mod,0,NULL);
477: END IF;
478: RAISE;
479:
472:
473: EXCEPTION
474: WHEN OTHERS THEN
475: IF PO_LOG.d_exc THEN
476: PO_LOG.exc(d_mod,0,NULL);
477: END IF;
478: RAISE;
479:
480: END quantity_ge_quantity_exec;
496: BEGIN
497:
498: IF p_line_id_tbl IS not null
499: THEN
500: IF PO_LOG.d_proc THEN
501: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
502: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
503: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
504: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl); -- PDOI for Complex PO Project
497:
498: IF p_line_id_tbl IS not null
499: THEN
500: IF PO_LOG.d_proc THEN
501: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
502: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
503: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
504: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl); -- PDOI for Complex PO Project
505: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl); -- PDOI for Complex PO Project
498: IF p_line_id_tbl IS not null
499: THEN
500: IF PO_LOG.d_proc THEN
501: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
502: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
503: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
504: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl); -- PDOI for Complex PO Project
505: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl); -- PDOI for Complex PO Project
506: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
499: THEN
500: IF PO_LOG.d_proc THEN
501: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
502: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
503: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
504: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl); -- PDOI for Complex PO Project
505: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl); -- PDOI for Complex PO Project
506: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
507: END IF;
500: IF PO_LOG.d_proc THEN
501: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
502: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
503: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
504: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl); -- PDOI for Complex PO Project
505: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl); -- PDOI for Complex PO Project
506: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
507: END IF;
508:
501: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
502: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
503: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
504: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl); -- PDOI for Complex PO Project
505: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl); -- PDOI for Complex PO Project
506: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
507: END IF;
508:
509:
502: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
503: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
504: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl); -- PDOI for Complex PO Project
505: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl); -- PDOI for Complex PO Project
506: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
507: END IF;
508:
509:
510: IF (x_results IS NULL) THEN
563: BEGIN
564:
565: IF p_line_id_tbl IS not null
566: THEN
567: IF PO_LOG.d_proc THEN
568: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
569: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
570: PO_LOG.proc_begin(d_mod,'p_retainage_rate_tbl',p_retainage_rate_tbl);
571: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
564:
565: IF p_line_id_tbl IS not null
566: THEN
567: IF PO_LOG.d_proc THEN
568: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
569: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
570: PO_LOG.proc_begin(d_mod,'p_retainage_rate_tbl',p_retainage_rate_tbl);
571: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
572: PO_LOG.proc_begin(d_mod,'p_prog_pay_rate_tbl',p_prog_pay_rate_tbl);
565: IF p_line_id_tbl IS not null
566: THEN
567: IF PO_LOG.d_proc THEN
568: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
569: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
570: PO_LOG.proc_begin(d_mod,'p_retainage_rate_tbl',p_retainage_rate_tbl);
571: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
572: PO_LOG.proc_begin(d_mod,'p_prog_pay_rate_tbl',p_prog_pay_rate_tbl);
573: PO_LOG.proc_begin(d_mod,'p_recoupment_rate_tbl',p_recoupment_rate_tbl);
566: THEN
567: IF PO_LOG.d_proc THEN
568: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
569: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
570: PO_LOG.proc_begin(d_mod,'p_retainage_rate_tbl',p_retainage_rate_tbl);
571: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
572: PO_LOG.proc_begin(d_mod,'p_prog_pay_rate_tbl',p_prog_pay_rate_tbl);
573: PO_LOG.proc_begin(d_mod,'p_recoupment_rate_tbl',p_recoupment_rate_tbl);
574: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
567: IF PO_LOG.d_proc THEN
568: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
569: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
570: PO_LOG.proc_begin(d_mod,'p_retainage_rate_tbl',p_retainage_rate_tbl);
571: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
572: PO_LOG.proc_begin(d_mod,'p_prog_pay_rate_tbl',p_prog_pay_rate_tbl);
573: PO_LOG.proc_begin(d_mod,'p_recoupment_rate_tbl',p_recoupment_rate_tbl);
574: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
575: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
568: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
569: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
570: PO_LOG.proc_begin(d_mod,'p_retainage_rate_tbl',p_retainage_rate_tbl);
571: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
572: PO_LOG.proc_begin(d_mod,'p_prog_pay_rate_tbl',p_prog_pay_rate_tbl);
573: PO_LOG.proc_begin(d_mod,'p_recoupment_rate_tbl',p_recoupment_rate_tbl);
574: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
575: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
576: END IF;
569: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
570: PO_LOG.proc_begin(d_mod,'p_retainage_rate_tbl',p_retainage_rate_tbl);
571: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
572: PO_LOG.proc_begin(d_mod,'p_prog_pay_rate_tbl',p_prog_pay_rate_tbl);
573: PO_LOG.proc_begin(d_mod,'p_recoupment_rate_tbl',p_recoupment_rate_tbl);
574: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
575: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
576: END IF;
577:
570: PO_LOG.proc_begin(d_mod,'p_retainage_rate_tbl',p_retainage_rate_tbl);
571: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
572: PO_LOG.proc_begin(d_mod,'p_prog_pay_rate_tbl',p_prog_pay_rate_tbl);
573: PO_LOG.proc_begin(d_mod,'p_recoupment_rate_tbl',p_recoupment_rate_tbl);
574: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
575: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
576: END IF;
577:
578:
571: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
572: PO_LOG.proc_begin(d_mod,'p_prog_pay_rate_tbl',p_prog_pay_rate_tbl);
573: PO_LOG.proc_begin(d_mod,'p_recoupment_rate_tbl',p_recoupment_rate_tbl);
574: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
575: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
576: END IF;
577:
578:
579: IF (x_results IS NULL) THEN
682: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_enc;
683: l_is_clm_po VARCHAR2(1) := 'N'; -- Bug#11782846
684: BEGIN
685:
686: IF PO_LOG.d_proc THEN
687: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
688: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
689: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
690: END IF;
683: l_is_clm_po VARCHAR2(1) := 'N'; -- Bug#11782846
684: BEGIN
685:
686: IF PO_LOG.d_proc THEN
687: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
688: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
689: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
690: END IF;
691:
684: BEGIN
685:
686: IF PO_LOG.d_proc THEN
687: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
688: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
689: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
690: END IF;
691:
692: IF (x_result_set_id IS NULL) THEN
685:
686: IF PO_LOG.d_proc THEN
687: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
688: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
689: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
690: END IF;
691:
692: IF (x_result_set_id IS NULL) THEN
693: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
744: END IF;
745: END IF;
746: END LOOP;
747:
748: IF PO_LOG.d_proc THEN
749: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
750: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
751: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
752: END IF;
746: END LOOP;
747:
748: IF PO_LOG.d_proc THEN
749: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
750: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
751: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
752: END IF;
753:
754: EXCEPTION
747:
748: IF PO_LOG.d_proc THEN
749: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
750: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
751: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
752: END IF;
753:
754: EXCEPTION
755: WHEN OTHERS THEN
752: END IF;
753:
754: EXCEPTION
755: WHEN OTHERS THEN
756: IF PO_LOG.d_exc THEN
757: PO_LOG.exc(d_mod,0,NULL);
758: END IF;
759: RAISE;
760:
753:
754: EXCEPTION
755: WHEN OTHERS THEN
756: IF PO_LOG.d_exc THEN
757: PO_LOG.exc(d_mod,0,NULL);
758: END IF;
759: RAISE;
760:
761: END quantity_ge_quantity_enc;
849: BEGIN
850:
851: d_progress := 0.0;
852:
853: IF PO_LOG.d_proc THEN
854: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
855: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
857: END IF;
850:
851: d_progress := 0.0;
852:
853: IF PO_LOG.d_proc THEN
854: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
855: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
857: END IF;
858:
851: d_progress := 0.0;
852:
853: IF PO_LOG.d_proc THEN
854: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
855: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
857: END IF;
858:
859: d_progress := 10.0;
852:
853: IF PO_LOG.d_proc THEN
854: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
855: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
856: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
857: END IF;
858:
859: d_progress := 10.0;
860:
1000: END IF;
1001:
1002: d_progress := 60.0;
1003:
1004: IF PO_LOG.d_proc THEN
1005: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1006: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1007: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1008: END IF;
1002: d_progress := 60.0;
1003:
1004: IF PO_LOG.d_proc THEN
1005: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1006: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1007: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1008: END IF;
1009:
1010: d_progress := 70.0;
1003:
1004: IF PO_LOG.d_proc THEN
1005: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1006: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1007: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1008: END IF;
1009:
1010: d_progress := 70.0;
1011:
1010: d_progress := 70.0;
1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: IF PO_LOG.d_exc THEN
1015: PO_LOG.exc(d_mod,d_progress,NULL);
1016: END IF;
1017: RAISE;
1018:
1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: IF PO_LOG.d_exc THEN
1015: PO_LOG.exc(d_mod,d_progress,NULL);
1016: END IF;
1017: RAISE;
1018:
1019: END amount_ge_amount_exec;
1045: l_timecard_amount_sum NUMBER;
1046: l_return_status VARCHAR2(1);
1047: BEGIN
1048:
1049: IF PO_LOG.d_proc THEN
1050: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1051: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1052: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1053: END IF;
1046: l_return_status VARCHAR2(1);
1047: BEGIN
1048:
1049: IF PO_LOG.d_proc THEN
1050: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1051: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1052: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1053: END IF;
1054:
1047: BEGIN
1048:
1049: IF PO_LOG.d_proc THEN
1050: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1051: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1052: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1053: END IF;
1054:
1055: IF (x_results IS NULL) THEN
1048:
1049: IF PO_LOG.d_proc THEN
1050: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1051: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1052: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1053: END IF;
1054:
1055: IF (x_results IS NULL) THEN
1056: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1130: ELSE
1131: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1132: END IF;
1133:
1134: IF PO_LOG.d_proc THEN
1135: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1136: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1137: END IF;
1138:
1131: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1132: END IF;
1133:
1134: IF PO_LOG.d_proc THEN
1135: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1136: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1137: END IF;
1138:
1139: EXCEPTION
1132: END IF;
1133:
1134: IF PO_LOG.d_proc THEN
1135: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1136: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1137: END IF;
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1137: END IF;
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: IF PO_LOG.d_exc THEN
1142: PO_LOG.exc(d_mod,0,NULL);
1143: END IF;
1144: RAISE;
1145:
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: IF PO_LOG.d_exc THEN
1142: PO_LOG.exc(d_mod,0,NULL);
1143: END IF;
1144: RAISE;
1145:
1146: END amount_ge_timecard;
1234: -- Flag indicating if profile PO_VMI_DISPLAY_WARNING is on
1235: l_po_vmi_display_warning VARCHAR2(2000);
1236: BEGIN
1237:
1238: IF PO_LOG.d_proc THEN
1239: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1242: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1235: l_po_vmi_display_warning VARCHAR2(2000);
1236: BEGIN
1237:
1238: IF PO_LOG.d_proc THEN
1239: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1242: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1243: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
1236: BEGIN
1237:
1238: IF PO_LOG.d_proc THEN
1239: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1242: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1243: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
1244: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
1237:
1238: IF PO_LOG.d_proc THEN
1239: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1242: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1243: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
1244: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
1245: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1238: IF PO_LOG.d_proc THEN
1239: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1242: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1243: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
1244: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
1245: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1246: END IF;
1239: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1242: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1243: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
1244: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
1245: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1246: END IF;
1247:
1240: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1242: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1243: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
1244: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
1245: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1246: END IF;
1247:
1248: IF (x_result_set_id IS NULL) THEN
1241: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1242: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1243: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
1244: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
1245: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1246: END IF;
1247:
1248: IF (x_result_set_id IS NULL) THEN
1249: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1305: END IF;
1306:
1307: END IF;
1308:
1309: IF PO_LOG.d_proc THEN
1310: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1311: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1312: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1313: END IF;
1307: END IF;
1308:
1309: IF PO_LOG.d_proc THEN
1310: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1311: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1312: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1313: END IF;
1314:
1315: EXCEPTION
1308:
1309: IF PO_LOG.d_proc THEN
1310: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1311: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1312: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1313: END IF;
1314:
1315: EXCEPTION
1316: WHEN OTHERS THEN
1313: END IF;
1314:
1315: EXCEPTION
1316: WHEN OTHERS THEN
1317: IF PO_LOG.d_exc THEN
1318: PO_LOG.exc(d_mod,0,NULL);
1319: END IF;
1320: RAISE;
1321:
1314:
1315: EXCEPTION
1316: WHEN OTHERS THEN
1317: IF PO_LOG.d_exc THEN
1318: PO_LOG.exc(d_mod,0,NULL);
1319: END IF;
1320: RAISE;
1321:
1322: END vmi_asl_exists;
1448: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1449: RETURN;
1450: END IF;
1451:
1452: IF PO_LOG.d_proc THEN
1453: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1454: PO_LOG.proc_begin(d_mod,'p_order_from_date_tbl',p_order_from_date_tbl);
1455: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1456: END IF;
1449: RETURN;
1450: END IF;
1451:
1452: IF PO_LOG.d_proc THEN
1453: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1454: PO_LOG.proc_begin(d_mod,'p_order_from_date_tbl',p_order_from_date_tbl);
1455: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1456: END IF;
1457:
1450: END IF;
1451:
1452: IF PO_LOG.d_proc THEN
1453: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1454: PO_LOG.proc_begin(d_mod,'p_order_from_date_tbl',p_order_from_date_tbl);
1455: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1456: END IF;
1457:
1458: IF (x_results IS NULL) THEN
1451:
1452: IF PO_LOG.d_proc THEN
1453: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1454: PO_LOG.proc_begin(d_mod,'p_order_from_date_tbl',p_order_from_date_tbl);
1455: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
1456: END IF;
1457:
1458: IF (x_results IS NULL) THEN
1459: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1500: ELSE
1501: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1502: END IF;
1503:
1504: IF PO_LOG.d_proc THEN
1505: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1506: END IF;
1507:
1508: EXCEPTION WHEN OTHERS THEN
1501: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1502: END IF;
1503:
1504: IF PO_LOG.d_proc THEN
1505: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1506: END IF;
1507:
1508: EXCEPTION WHEN OTHERS THEN
1509: IF PO_LOG.d_exc THEN
1505: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1506: END IF;
1507:
1508: EXCEPTION WHEN OTHERS THEN
1509: IF PO_LOG.d_exc THEN
1510: PO_LOG.exc(d_mod,0,NULL);
1511: END IF;
1512: RAISE;
1513: END order_start_date_gt_sysdate;
1506: END IF;
1507:
1508: EXCEPTION WHEN OTHERS THEN
1509: IF PO_LOG.d_exc THEN
1510: PO_LOG.exc(d_mod,0,NULL);
1511: END IF;
1512: RAISE;
1513: END order_start_date_gt_sysdate;
1514:
1532: END IF;
1533:
1534: IF p_line_id_tbl IS not null
1535: THEN
1536: IF PO_LOG.d_proc THEN
1537: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1538: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1539: PO_LOG.proc_begin(d_mod,'p_line_amount_tbl',p_line_amount_tbl);
1540: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1533:
1534: IF p_line_id_tbl IS not null
1535: THEN
1536: IF PO_LOG.d_proc THEN
1537: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1538: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1539: PO_LOG.proc_begin(d_mod,'p_line_amount_tbl',p_line_amount_tbl);
1540: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1541: END IF;
1534: IF p_line_id_tbl IS not null
1535: THEN
1536: IF PO_LOG.d_proc THEN
1537: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1538: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1539: PO_LOG.proc_begin(d_mod,'p_line_amount_tbl',p_line_amount_tbl);
1540: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1541: END IF;
1542:
1535: THEN
1536: IF PO_LOG.d_proc THEN
1537: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1538: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1539: PO_LOG.proc_begin(d_mod,'p_line_amount_tbl',p_line_amount_tbl);
1540: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1541: END IF;
1542:
1543: IF (x_results IS NULL) THEN
1536: IF PO_LOG.d_proc THEN
1537: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1538: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1539: PO_LOG.proc_begin(d_mod,'p_line_amount_tbl',p_line_amount_tbl);
1540: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1541: END IF;
1542:
1543: IF (x_results IS NULL) THEN
1544: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1587: END IF;
1588:
1589: IF p_line_id_tbl IS not null
1590: THEN
1591: IF PO_LOG.d_proc THEN
1592: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1593: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1594: PO_LOG.proc_begin(d_mod,'p_min_total_amt_tbl',p_min_total_amt_tbl);
1595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1588:
1589: IF p_line_id_tbl IS not null
1590: THEN
1591: IF PO_LOG.d_proc THEN
1592: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1593: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1594: PO_LOG.proc_begin(d_mod,'p_min_total_amt_tbl',p_min_total_amt_tbl);
1595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1596: END IF;
1589: IF p_line_id_tbl IS not null
1590: THEN
1591: IF PO_LOG.d_proc THEN
1592: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1593: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1594: PO_LOG.proc_begin(d_mod,'p_min_total_amt_tbl',p_min_total_amt_tbl);
1595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1596: END IF;
1597:
1590: THEN
1591: IF PO_LOG.d_proc THEN
1592: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1593: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1594: PO_LOG.proc_begin(d_mod,'p_min_total_amt_tbl',p_min_total_amt_tbl);
1595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1596: END IF;
1597:
1598: IF (x_results IS NULL) THEN
1591: IF PO_LOG.d_proc THEN
1592: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1593: PO_LOG.proc_begin(d_mod,'p_max_total_amt_tbl',p_max_total_amt_tbl);
1594: PO_LOG.proc_begin(d_mod,'p_min_total_amt_tbl',p_min_total_amt_tbl);
1595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1596: END IF;
1597:
1598: IF (x_results IS NULL) THEN
1599: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1641: END IF;
1642:
1643: IF p_line_id_tbl IS not null
1644: THEN
1645: IF PO_LOG.d_proc THEN
1646: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1647: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1648: PO_LOG.proc_begin(d_mod,'p_line_qty_tbl',p_line_qty_tbl);
1649: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1642:
1643: IF p_line_id_tbl IS not null
1644: THEN
1645: IF PO_LOG.d_proc THEN
1646: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1647: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1648: PO_LOG.proc_begin(d_mod,'p_line_qty_tbl',p_line_qty_tbl);
1649: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1650: END IF;
1643: IF p_line_id_tbl IS not null
1644: THEN
1645: IF PO_LOG.d_proc THEN
1646: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1647: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1648: PO_LOG.proc_begin(d_mod,'p_line_qty_tbl',p_line_qty_tbl);
1649: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1650: END IF;
1651:
1644: THEN
1645: IF PO_LOG.d_proc THEN
1646: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1647: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1648: PO_LOG.proc_begin(d_mod,'p_line_qty_tbl',p_line_qty_tbl);
1649: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1650: END IF;
1651:
1652: IF (x_results IS NULL) THEN
1645: IF PO_LOG.d_proc THEN
1646: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1647: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1648: PO_LOG.proc_begin(d_mod,'p_line_qty_tbl',p_line_qty_tbl);
1649: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1650: END IF;
1651:
1652: IF (x_results IS NULL) THEN
1653: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1696: END IF;
1697:
1698: IF p_line_id_tbl IS not null
1699: THEN
1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1702: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1703: PO_LOG.proc_begin(d_mod,'p_min_total_qty_tbl',p_min_total_qty_tbl);
1704: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1697:
1698: IF p_line_id_tbl IS not null
1699: THEN
1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1702: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1703: PO_LOG.proc_begin(d_mod,'p_min_total_qty_tbl',p_min_total_qty_tbl);
1704: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1705: END IF;
1698: IF p_line_id_tbl IS not null
1699: THEN
1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1702: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1703: PO_LOG.proc_begin(d_mod,'p_min_total_qty_tbl',p_min_total_qty_tbl);
1704: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1705: END IF;
1706:
1699: THEN
1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1702: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1703: PO_LOG.proc_begin(d_mod,'p_min_total_qty_tbl',p_min_total_qty_tbl);
1704: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1705: END IF;
1706:
1707: IF (x_results IS NULL) THEN
1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1702: PO_LOG.proc_begin(d_mod,'p_max_total_qty_tbl',p_max_total_qty_tbl);
1703: PO_LOG.proc_begin(d_mod,'p_min_total_qty_tbl',p_min_total_qty_tbl);
1704: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1705: END IF;
1706:
1707: IF (x_results IS NULL) THEN
1708: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1751: END IF;
1752:
1753: IF p_line_id_tbl IS not null
1754: THEN
1755: IF PO_LOG.d_proc THEN
1756: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1757: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1758: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_amount_tbl);
1759: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1752:
1753: IF p_line_id_tbl IS not null
1754: THEN
1755: IF PO_LOG.d_proc THEN
1756: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1757: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1758: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_amount_tbl);
1759: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1760: END IF;
1753: IF p_line_id_tbl IS not null
1754: THEN
1755: IF PO_LOG.d_proc THEN
1756: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1757: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1758: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_amount_tbl);
1759: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1760: END IF;
1761:
1754: THEN
1755: IF PO_LOG.d_proc THEN
1756: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1757: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1758: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_amount_tbl);
1759: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1760: END IF;
1761:
1762: IF (x_results IS NULL) THEN
1755: IF PO_LOG.d_proc THEN
1756: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1757: PO_LOG.proc_begin(d_mod,'p_max_order_amt_tbl',p_max_order_amt_tbl);
1758: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_amount_tbl);
1759: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1760: END IF;
1761:
1762: IF (x_results IS NULL) THEN
1763: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1806: END IF;
1807:
1808: IF p_line_id_tbl IS not null
1809: THEN
1810: IF PO_LOG.d_proc THEN
1811: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1812: PO_LOG.proc_begin(d_mod,'p_max_ord_amt_tbl',p_max_ord_amt_tbl);
1813: PO_LOG.proc_begin(d_mod,'p_min_ord_amt_tbl',p_min_ord_amt_tbl);
1814: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1807:
1808: IF p_line_id_tbl IS not null
1809: THEN
1810: IF PO_LOG.d_proc THEN
1811: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1812: PO_LOG.proc_begin(d_mod,'p_max_ord_amt_tbl',p_max_ord_amt_tbl);
1813: PO_LOG.proc_begin(d_mod,'p_min_ord_amt_tbl',p_min_ord_amt_tbl);
1814: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1815: END IF;
1808: IF p_line_id_tbl IS not null
1809: THEN
1810: IF PO_LOG.d_proc THEN
1811: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1812: PO_LOG.proc_begin(d_mod,'p_max_ord_amt_tbl',p_max_ord_amt_tbl);
1813: PO_LOG.proc_begin(d_mod,'p_min_ord_amt_tbl',p_min_ord_amt_tbl);
1814: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1815: END IF;
1816:
1809: THEN
1810: IF PO_LOG.d_proc THEN
1811: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1812: PO_LOG.proc_begin(d_mod,'p_max_ord_amt_tbl',p_max_ord_amt_tbl);
1813: PO_LOG.proc_begin(d_mod,'p_min_ord_amt_tbl',p_min_ord_amt_tbl);
1814: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1815: END IF;
1816:
1817: IF (x_results IS NULL) THEN
1810: IF PO_LOG.d_proc THEN
1811: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1812: PO_LOG.proc_begin(d_mod,'p_max_ord_amt_tbl',p_max_ord_amt_tbl);
1813: PO_LOG.proc_begin(d_mod,'p_min_ord_amt_tbl',p_min_ord_amt_tbl);
1814: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1815: END IF;
1816:
1817: IF (x_results IS NULL) THEN
1818: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1860: END IF;
1861:
1862: IF p_line_id_tbl IS not null
1863: THEN
1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_max_order_qty_tbl',p_max_order_qty_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_qty_tbl);
1868: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1861:
1862: IF p_line_id_tbl IS not null
1863: THEN
1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_max_order_qty_tbl',p_max_order_qty_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_qty_tbl);
1868: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1869: END IF;
1862: IF p_line_id_tbl IS not null
1863: THEN
1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_max_order_qty_tbl',p_max_order_qty_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_qty_tbl);
1868: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1869: END IF;
1870:
1863: THEN
1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_max_order_qty_tbl',p_max_order_qty_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_qty_tbl);
1868: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1869: END IF;
1870:
1871: IF (x_results IS NULL) THEN
1864: IF PO_LOG.d_proc THEN
1865: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1866: PO_LOG.proc_begin(d_mod,'p_max_order_qty_tbl',p_max_order_qty_tbl);
1867: PO_LOG.proc_begin(d_mod,'p_max_tot_amount_tbl',p_max_tot_qty_tbl);
1868: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1869: END IF;
1870:
1871: IF (x_results IS NULL) THEN
1872: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1915: END IF;
1916:
1917: IF p_line_id_tbl IS not null
1918: THEN
1919: IF PO_LOG.d_proc THEN
1920: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1921: PO_LOG.proc_begin(d_mod,'p_max_ord_qty_tbl',p_max_ord_qty_tbl);
1922: PO_LOG.proc_begin(d_mod,'p_min_ord_qty_tbl',p_min_ord_qty_tbl);
1923: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1916:
1917: IF p_line_id_tbl IS not null
1918: THEN
1919: IF PO_LOG.d_proc THEN
1920: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1921: PO_LOG.proc_begin(d_mod,'p_max_ord_qty_tbl',p_max_ord_qty_tbl);
1922: PO_LOG.proc_begin(d_mod,'p_min_ord_qty_tbl',p_min_ord_qty_tbl);
1923: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1924: END IF;
1917: IF p_line_id_tbl IS not null
1918: THEN
1919: IF PO_LOG.d_proc THEN
1920: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1921: PO_LOG.proc_begin(d_mod,'p_max_ord_qty_tbl',p_max_ord_qty_tbl);
1922: PO_LOG.proc_begin(d_mod,'p_min_ord_qty_tbl',p_min_ord_qty_tbl);
1923: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1924: END IF;
1925:
1918: THEN
1919: IF PO_LOG.d_proc THEN
1920: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1921: PO_LOG.proc_begin(d_mod,'p_max_ord_qty_tbl',p_max_ord_qty_tbl);
1922: PO_LOG.proc_begin(d_mod,'p_min_ord_qty_tbl',p_min_ord_qty_tbl);
1923: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1924: END IF;
1925:
1926: IF (x_results IS NULL) THEN
1919: IF PO_LOG.d_proc THEN
1920: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1921: PO_LOG.proc_begin(d_mod,'p_max_ord_qty_tbl',p_max_ord_qty_tbl);
1922: PO_LOG.proc_begin(d_mod,'p_min_ord_qty_tbl',p_min_ord_qty_tbl);
1923: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1924: END IF;
1925:
1926: IF (x_results IS NULL) THEN
1927: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2036: l_input_size NUMBER;
2037: l_count NUMBER;
2038: BEGIN
2039:
2040: IF PO_LOG.d_proc THEN
2041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2042: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2043: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2044: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2037: l_count NUMBER;
2038: BEGIN
2039:
2040: IF PO_LOG.d_proc THEN
2041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2042: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2043: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2044: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2045: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2038: BEGIN
2039:
2040: IF PO_LOG.d_proc THEN
2041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2042: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2043: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2044: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2045: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2046: END IF;
2039:
2040: IF PO_LOG.d_proc THEN
2041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2042: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2043: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2044: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2045: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2046: END IF;
2047:
2040: IF PO_LOG.d_proc THEN
2041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2042: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2043: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2044: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2045: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2046: END IF;
2047:
2048: l_input_size := p_line_id_tbl.COUNT;
2041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2042: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2043: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2044: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2045: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2046: END IF;
2047:
2048: l_input_size := p_line_id_tbl.COUNT;
2049:
2080: );
2081:
2082: EXCEPTION
2083: WHEN OTHERS THEN
2084: IF PO_LOG.d_exc THEN
2085: PO_LOG.exc(d_mod,0,NULL);
2086: END IF;
2087: RAISE;
2088:
2081:
2082: EXCEPTION
2083: WHEN OTHERS THEN
2084: IF PO_LOG.d_exc THEN
2085: PO_LOG.exc(d_mod,0,NULL);
2086: END IF;
2087: RAISE;
2088:
2089: END unit_price_ge_zero;
2167: l_amount_changed_flag_tbl PO_TBL_VARCHAR1; --
2168:
2169: BEGIN
2170:
2171: IF PO_LOG.d_proc THEN
2172: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2173: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2174: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
2175: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2168:
2169: BEGIN
2170:
2171: IF PO_LOG.d_proc THEN
2172: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2173: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2174: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
2175: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2169: BEGIN
2170:
2171: IF PO_LOG.d_proc THEN
2172: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2173: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2174: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
2175: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2177: END IF;
2170:
2171: IF PO_LOG.d_proc THEN
2172: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2173: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2174: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
2175: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2177: END IF;
2178:
2171: IF PO_LOG.d_proc THEN
2172: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2173: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2174: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
2175: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2177: END IF;
2178:
2179: l_data_key := PO_CORE_S.get_session_gt_nextval();
2172: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2173: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
2174: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
2175: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2177: END IF;
2178:
2179: l_data_key := PO_CORE_S.get_session_gt_nextval();
2180:
2234:
2235: END IF;
2236:
2237:
2238: IF PO_LOG.d_proc THEN
2239: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2240: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2241: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2242: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2236:
2237:
2238: IF PO_LOG.d_proc THEN
2239: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2240: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2241: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2242: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2243: END IF;
2244:
2237:
2238: IF PO_LOG.d_proc THEN
2239: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2240: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2241: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2242: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2243: END IF;
2244:
2245: EXCEPTION
2238: IF PO_LOG.d_proc THEN
2239: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2240: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2241: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2242: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2243: END IF;
2244:
2245: EXCEPTION
2246: WHEN OTHERS THEN
2243: END IF;
2244:
2245: EXCEPTION
2246: WHEN OTHERS THEN
2247: IF PO_LOG.d_exc THEN
2248: PO_LOG.exc(d_mod,0,NULL);
2249: END IF;
2250: RAISE;
2251:
2244:
2245: EXCEPTION
2246: WHEN OTHERS THEN
2247: IF PO_LOG.d_exc THEN
2248: PO_LOG.exc(d_mod,0,NULL);
2249: END IF;
2250: RAISE;
2251:
2252: END validate_unit_price_change;
2408: IS
2409: d_mod CONSTANT VARCHAR2(100) := D_qty_ge_qty_milestone_exec;
2410: BEGIN
2411:
2412: IF PO_LOG.d_proc THEN
2413: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
2415: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2416: END IF;
2409: d_mod CONSTANT VARCHAR2(100) := D_qty_ge_qty_milestone_exec;
2410: BEGIN
2411:
2412: IF PO_LOG.d_proc THEN
2413: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
2415: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2416: END IF;
2417:
2410: BEGIN
2411:
2412: IF PO_LOG.d_proc THEN
2413: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
2415: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2416: END IF;
2417:
2418: IF (x_result_set_id IS NULL) THEN
2411:
2412: IF PO_LOG.d_proc THEN
2413: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
2415: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2416: END IF;
2417:
2418: IF (x_result_set_id IS NULL) THEN
2419: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2472: ELSE
2473: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2474: END IF;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2478: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2479: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2480: END IF;
2474: END IF;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2478: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2479: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2480: END IF;
2481:
2482: EXCEPTION
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2478: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2479: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2480: END IF;
2481:
2482: EXCEPTION
2483: WHEN OTHERS THEN
2480: END IF;
2481:
2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: IF PO_LOG.d_exc THEN
2485: PO_LOG.exc(d_mod,0,NULL);
2486: END IF;
2487: RAISE;
2488:
2481:
2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: IF PO_LOG.d_exc THEN
2485: PO_LOG.exc(d_mod,0,NULL);
2486: END IF;
2487: RAISE;
2488:
2489: END qty_ge_qty_milestone_exec;
2503: IS
2504: d_mod CONSTANT VARCHAR2(100) := D_price_ge_price_mstone_exec;
2505: BEGIN
2506:
2507: IF PO_LOG.d_proc THEN
2508: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2509: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl);
2510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2511: END IF;
2504: d_mod CONSTANT VARCHAR2(100) := D_price_ge_price_mstone_exec;
2505: BEGIN
2506:
2507: IF PO_LOG.d_proc THEN
2508: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2509: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl);
2510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2511: END IF;
2512:
2505: BEGIN
2506:
2507: IF PO_LOG.d_proc THEN
2508: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2509: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl);
2510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2511: END IF;
2512:
2513: IF (x_result_set_id IS NULL) THEN
2506:
2507: IF PO_LOG.d_proc THEN
2508: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2509: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl);
2510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2511: END IF;
2512:
2513: IF (x_result_set_id IS NULL) THEN
2514: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2560: ELSE
2561: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2562: END IF;
2563:
2564: IF PO_LOG.d_proc THEN
2565: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2566: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2567: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2568: END IF;
2562: END IF;
2563:
2564: IF PO_LOG.d_proc THEN
2565: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2566: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2567: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2568: END IF;
2569:
2570: EXCEPTION
2563:
2564: IF PO_LOG.d_proc THEN
2565: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2566: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2567: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2568: END IF;
2569:
2570: EXCEPTION
2571: WHEN OTHERS THEN
2568: END IF;
2569:
2570: EXCEPTION
2571: WHEN OTHERS THEN
2572: IF PO_LOG.d_exc THEN
2573: PO_LOG.exc(d_mod,0,NULL);
2574: END IF;
2575: RAISE;
2576:
2569:
2570: EXCEPTION
2571: WHEN OTHERS THEN
2572: IF PO_LOG.d_exc THEN
2573: PO_LOG.exc(d_mod,0,NULL);
2574: END IF;
2575: RAISE;
2576:
2577: END price_ge_price_milestone_exec;
2594: d_mod CONSTANT VARCHAR2(100) := D_unit_meas_not_null;
2595: l_results_count NUMBER;
2596: BEGIN
2597:
2598: IF PO_LOG.d_proc THEN
2599: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
2601: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2595: l_results_count NUMBER;
2596: BEGIN
2597:
2598: IF PO_LOG.d_proc THEN
2599: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
2601: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2603: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2596: BEGIN
2597:
2598: IF PO_LOG.d_proc THEN
2599: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
2601: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2603: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2604: END IF;
2597:
2598: IF PO_LOG.d_proc THEN
2599: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
2601: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2603: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2604: END IF;
2605:
2598: IF PO_LOG.d_proc THEN
2599: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
2601: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2603: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2604: END IF;
2605:
2606: IF (x_results IS NULL) THEN
2599: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
2601: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2603: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2604: END IF;
2605:
2606: IF (x_results IS NULL) THEN
2607: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2630: ELSE
2631: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2632: END IF;
2633:
2634: IF PO_LOG.d_proc THEN
2635: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2636: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2637: END IF;
2638:
2631: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2632: END IF;
2633:
2634: IF PO_LOG.d_proc THEN
2635: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2636: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2637: END IF;
2638:
2639: EXCEPTION
2632: END IF;
2633:
2634: IF PO_LOG.d_proc THEN
2635: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2636: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2637: END IF;
2638:
2639: EXCEPTION
2640: WHEN OTHERS THEN
2637: END IF;
2638:
2639: EXCEPTION
2640: WHEN OTHERS THEN
2641: IF PO_LOG.d_exc THEN
2642: PO_LOG.exc(d_mod,0,NULL);
2643: END IF;
2644: RAISE;
2645:
2638:
2639: EXCEPTION
2640: WHEN OTHERS THEN
2641: IF PO_LOG.d_exc THEN
2642: PO_LOG.exc(d_mod,0,NULL);
2643: END IF;
2644: RAISE;
2645:
2646: END unit_meas_not_null;
2748: l_count NUMBER;
2749:
2750: BEGIN
2751:
2752: IF PO_LOG.d_proc THEN
2753: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2754: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2755: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2756: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
2749:
2750: BEGIN
2751:
2752: IF PO_LOG.d_proc THEN
2753: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2754: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2755: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2756: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
2757: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2750: BEGIN
2751:
2752: IF PO_LOG.d_proc THEN
2753: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2754: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2755: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2756: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
2757: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2758: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2751:
2752: IF PO_LOG.d_proc THEN
2753: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2754: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2755: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2756: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
2757: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2758: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2759: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2752: IF PO_LOG.d_proc THEN
2753: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2754: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2755: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2756: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
2757: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2758: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2759: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2760: END IF;
2753: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2754: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2755: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2756: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
2757: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2758: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2759: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2760: END IF;
2761:
2754: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2755: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2756: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
2757: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2758: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2759: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2760: END IF;
2761:
2762: IF (x_result_set_id IS NULL) THEN
2755: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2756: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
2757: PO_LOG.proc_begin(d_mod,'p_clm_info_flag_tbl',p_clm_info_flag_tbl);
2758: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2759: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2760: END IF;
2761:
2762: IF (x_result_set_id IS NULL) THEN
2763: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2821: END IF;
2822:
2823: END IF;
2824:
2825: IF PO_LOG.d_proc THEN
2826: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2827: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2828: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2829: END IF;
2823: END IF;
2824:
2825: IF PO_LOG.d_proc THEN
2826: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2827: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2828: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2829: END IF;
2830:
2831: EXCEPTION
2824:
2825: IF PO_LOG.d_proc THEN
2826: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2827: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2828: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2829: END IF;
2830:
2831: EXCEPTION
2832: WHEN OTHERS THEN
2829: END IF;
2830:
2831: EXCEPTION
2832: WHEN OTHERS THEN
2833: IF PO_LOG.d_exc THEN
2834: PO_LOG.exc(d_mod,0,NULL);
2835: END IF;
2836: RAISE;
2837:
2830:
2831: EXCEPTION
2832: WHEN OTHERS THEN
2833: IF PO_LOG.d_exc THEN
2834: PO_LOG.exc(d_mod,0,NULL);
2835: END IF;
2836: RAISE;
2837:
2838: END item_id_not_null;
2852: d_mod CONSTANT VARCHAR2(100) := D_temp_labor_job_id_not_null;
2853: l_results_count NUMBER;
2854: BEGIN
2855:
2856: IF PO_LOG.d_proc THEN
2857: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2858: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
2859: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2860: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2853: l_results_count NUMBER;
2854: BEGIN
2855:
2856: IF PO_LOG.d_proc THEN
2857: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2858: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
2859: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2860: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2861: END IF;
2854: BEGIN
2855:
2856: IF PO_LOG.d_proc THEN
2857: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2858: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
2859: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2860: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2861: END IF;
2862:
2855:
2856: IF PO_LOG.d_proc THEN
2857: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2858: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
2859: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2860: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2861: END IF;
2862:
2863: IF (x_results IS NULL) THEN
2856: IF PO_LOG.d_proc THEN
2857: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2858: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
2859: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2860: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2861: END IF;
2862:
2863: IF (x_results IS NULL) THEN
2864: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2885: ELSE
2886: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2887: END IF;
2888:
2889: IF PO_LOG.d_proc THEN
2890: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2891: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2892: END IF;
2893:
2886: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2887: END IF;
2888:
2889: IF PO_LOG.d_proc THEN
2890: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2891: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2892: END IF;
2893:
2894: EXCEPTION
2887: END IF;
2888:
2889: IF PO_LOG.d_proc THEN
2890: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2891: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2892: END IF;
2893:
2894: EXCEPTION
2895: WHEN OTHERS THEN
2892: END IF;
2893:
2894: EXCEPTION
2895: WHEN OTHERS THEN
2896: IF PO_LOG.d_exc THEN
2897: PO_LOG.exc(d_mod,0,NULL);
2898: END IF;
2899: RAISE;
2900:
2893:
2894: EXCEPTION
2895: WHEN OTHERS THEN
2896: IF PO_LOG.d_exc THEN
2897: PO_LOG.exc(d_mod,0,NULL);
2898: END IF;
2899: RAISE;
2900:
2901: END temp_labor_job_id_not_null;
2919: IF (x_results IS NULL) THEN
2920: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2921: END IF;
2922:
2923: IF PO_LOG.d_proc THEN
2924: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2925: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2926: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2927: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2920: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2921: END IF;
2922:
2923: IF PO_LOG.d_proc THEN
2924: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2925: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2926: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2927: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2928: END IF;
2921: END IF;
2922:
2923: IF PO_LOG.d_proc THEN
2924: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2925: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2926: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2927: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2928: END IF;
2929:
2922:
2923: IF PO_LOG.d_proc THEN
2924: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2925: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2926: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2927: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2928: END IF;
2929:
2930: l_results_count := x_results.result_type.COUNT;
2923: IF PO_LOG.d_proc THEN
2924: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2925: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2926: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2927: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2928: END IF;
2929:
2930: l_results_count := x_results.result_type.COUNT;
2931:
2956: ELSE
2957: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2958: END IF;
2959:
2960: IF PO_LOG.d_proc THEN
2961: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2962: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2963: END IF;
2964:
2957: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2958: END IF;
2959:
2960: IF PO_LOG.d_proc THEN
2961: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2962: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2963: END IF;
2964:
2965: EXCEPTION
2958: END IF;
2959:
2960: IF PO_LOG.d_proc THEN
2961: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2962: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2963: END IF;
2964:
2965: EXCEPTION
2966: WHEN OTHERS THEN
2963: END IF;
2964:
2965: EXCEPTION
2966: WHEN OTHERS THEN
2967: IF PO_LOG.d_exc THEN
2968: PO_LOG.exc(d_mod,0,NULL);
2969: END IF;
2970: RAISE;
2971: END src_doc_line_not_null;
2964:
2965: EXCEPTION
2966: WHEN OTHERS THEN
2967: IF PO_LOG.d_exc THEN
2968: PO_LOG.exc(d_mod,0,NULL);
2969: END IF;
2970: RAISE;
2971: END src_doc_line_not_null;
2972:
3036: d_mod CONSTANT VARCHAR2(100) := D_temp_lbr_start_date_not_null;
3037: l_results_count NUMBER;
3038: BEGIN
3039:
3040: IF PO_LOG.d_proc THEN
3041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3042: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3043: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
3044: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3037: l_results_count NUMBER;
3038: BEGIN
3039:
3040: IF PO_LOG.d_proc THEN
3041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3042: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3043: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
3044: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3045: END IF;
3038: BEGIN
3039:
3040: IF PO_LOG.d_proc THEN
3041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3042: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3043: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
3044: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3045: END IF;
3046:
3039:
3040: IF PO_LOG.d_proc THEN
3041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3042: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3043: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
3044: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3045: END IF;
3046:
3047: IF (x_results IS NULL) THEN
3040: IF PO_LOG.d_proc THEN
3041: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3042: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3043: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
3044: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3045: END IF;
3046:
3047: IF (x_results IS NULL) THEN
3048: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3069: ELSE
3070: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3071: END IF;
3072:
3073: IF PO_LOG.d_proc THEN
3074: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3075: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3076: END IF;
3077:
3070: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3071: END IF;
3072:
3073: IF PO_LOG.d_proc THEN
3074: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3075: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3076: END IF;
3077:
3078: EXCEPTION
3071: END IF;
3072:
3073: IF PO_LOG.d_proc THEN
3074: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3075: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3076: END IF;
3077:
3078: EXCEPTION
3079: WHEN OTHERS THEN
3076: END IF;
3077:
3078: EXCEPTION
3079: WHEN OTHERS THEN
3080: IF PO_LOG.d_exc THEN
3081: PO_LOG.exc(d_mod,0,NULL);
3082: END IF;
3083: RAISE;
3084:
3077:
3078: EXCEPTION
3079: WHEN OTHERS THEN
3080: IF PO_LOG.d_exc THEN
3081: PO_LOG.exc(d_mod,0,NULL);
3082: END IF;
3083: RAISE;
3084:
3085: END temp_lbr_start_date_not_null;
3103: l_input_size NUMBER;
3104:
3105: BEGIN
3106:
3107: IF PO_LOG.d_proc THEN
3108: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3109: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
3110: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3111: END IF;
3104:
3105: BEGIN
3106:
3107: IF PO_LOG.d_proc THEN
3108: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3109: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
3110: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3111: END IF;
3112:
3105: BEGIN
3106:
3107: IF PO_LOG.d_proc THEN
3108: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3109: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
3110: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3111: END IF;
3112:
3113: -- SQL What : Get the default inv org id
3106:
3107: IF PO_LOG.d_proc THEN
3108: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3109: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
3110: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3111: END IF;
3112:
3113: -- SQL What : Get the default inv org id
3114: -- SQL Why : To pass to the Opm Validations
3138: );
3139:
3140: EXCEPTION
3141: WHEN OTHERS THEN
3142: IF PO_LOG.d_exc THEN
3143: PO_LOG.exc(d_mod,0,NULL);
3144: END IF;
3145: RAISE;
3146:
3139:
3140: EXCEPTION
3141: WHEN OTHERS THEN
3142: IF PO_LOG.d_exc THEN
3143: PO_LOG.exc(d_mod,0,NULL);
3144: END IF;
3145: RAISE;
3146:
3147: END line_sec_quantity_gt_zero;
3169: l_def_inv_org_id NUMBER;
3170:
3171: BEGIN
3172:
3173: IF PO_LOG.d_proc THEN
3174: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3175: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
3176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3177: END IF;
3170:
3171: BEGIN
3172:
3173: IF PO_LOG.d_proc THEN
3174: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3175: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
3176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3177: END IF;
3178:
3171: BEGIN
3172:
3173: IF PO_LOG.d_proc THEN
3174: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3175: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
3176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3177: END IF;
3178:
3179: -- SQL What : Get the default inv org id
3172:
3173: IF PO_LOG.d_proc THEN
3174: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3175: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
3176: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3177: END IF;
3178:
3179: -- SQL What : Get the default inv org id
3180: -- SQL Why : To pass to the Opm Validations
3206: );
3207:
3208: EXCEPTION
3209: WHEN OTHERS THEN
3210: IF PO_LOG.d_exc THEN
3211: PO_LOG.exc(d_mod,0,NULL);
3212: END IF;
3213: RAISE;
3214:
3207:
3208: EXCEPTION
3209: WHEN OTHERS THEN
3210: IF PO_LOG.d_exc THEN
3211: PO_LOG.exc(d_mod,0,NULL);
3212: END IF;
3213: RAISE;
3214:
3215: END line_qtys_within_deviation;
3232: l_src_doc_type_lookup_code VARCHAR2(30) := null;
3233: l_from_header_id NUMBER;
3234: BEGIN
3235:
3236: IF PO_LOG.d_proc THEN
3237: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3238: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
3239: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
3240: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3233: l_from_header_id NUMBER;
3234: BEGIN
3235:
3236: IF PO_LOG.d_proc THEN
3237: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3238: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
3239: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
3240: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3241: END IF;
3234: BEGIN
3235:
3236: IF PO_LOG.d_proc THEN
3237: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3238: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
3239: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
3240: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3241: END IF;
3242:
3235:
3236: IF PO_LOG.d_proc THEN
3237: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3238: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
3239: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
3240: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3241: END IF;
3242:
3243: IF (x_results IS NULL) THEN
3236: IF PO_LOG.d_proc THEN
3237: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3238: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
3239: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
3240: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3241: END IF;
3242:
3243: IF (x_results IS NULL) THEN
3244: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3285: ELSE
3286: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3287: END IF;
3288:
3289: IF PO_LOG.d_proc THEN
3290: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3291: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3292: END IF;
3293:
3286: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3287: END IF;
3288:
3289: IF PO_LOG.d_proc THEN
3290: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3291: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3292: END IF;
3293:
3294: EXCEPTION
3287: END IF;
3288:
3289: IF PO_LOG.d_proc THEN
3290: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3291: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3292: END IF;
3293:
3294: EXCEPTION
3295: WHEN OTHERS THEN
3292: END IF;
3293:
3294: EXCEPTION
3295: WHEN OTHERS THEN
3296: IF PO_LOG.d_exc THEN
3297: PO_LOG.exc(d_mod,0,NULL);
3298: END IF;
3299: RAISE;
3300:
3293:
3294: EXCEPTION
3295: WHEN OTHERS THEN
3296: IF PO_LOG.d_exc THEN
3297: PO_LOG.exc(d_mod,0,NULL);
3298: END IF;
3299: RAISE;
3300:
3301: END from_line_id_not_null;
3346: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_enc;
3347:
3348: BEGIN
3349:
3350: IF PO_LOG.d_proc THEN
3351: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3352: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
3353: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3354: END IF;
3347:
3348: BEGIN
3349:
3350: IF PO_LOG.d_proc THEN
3351: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3352: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
3353: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3354: END IF;
3355:
3348: BEGIN
3349:
3350: IF PO_LOG.d_proc THEN
3351: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3352: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
3353: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3354: END IF;
3355:
3356: IF (x_result_set_id IS NULL) THEN
3349:
3350: IF PO_LOG.d_proc THEN
3351: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3352: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
3353: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3354: END IF;
3355:
3356: IF (x_result_set_id IS NULL) THEN
3357: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
3397: ELSE
3398: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3399: END IF;
3400:
3401: IF PO_LOG.d_proc THEN
3402: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
3403: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3404: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
3405: END IF;
3399: END IF;
3400:
3401: IF PO_LOG.d_proc THEN
3402: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
3403: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3404: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
3405: END IF;
3406:
3407: EXCEPTION
3400:
3401: IF PO_LOG.d_proc THEN
3402: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
3403: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3404: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
3405: END IF;
3406:
3407: EXCEPTION
3408: WHEN OTHERS THEN
3405: END IF;
3406:
3407: EXCEPTION
3408: WHEN OTHERS THEN
3409: IF PO_LOG.d_exc THEN
3410: PO_LOG.exc(d_mod,0,NULL);
3411: END IF;
3412: RAISE;
3413:
3406:
3407: EXCEPTION
3408: WHEN OTHERS THEN
3409: IF PO_LOG.d_exc THEN
3410: PO_LOG.exc(d_mod,0,NULL);
3411: END IF;
3412: RAISE;
3413:
3414: END max_retain_amt_ge_retained;
3425: d_mod CONSTANT VARCHAR2(100) := D_option_from_date_not_null;
3426: l_results_count NUMBER;
3427: BEGIN
3428:
3429: IF PO_LOG.d_proc THEN
3430: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3431: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3432: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3433: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3426: l_results_count NUMBER;
3427: BEGIN
3428:
3429: IF PO_LOG.d_proc THEN
3430: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3431: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3432: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3433: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3434: END IF;
3427: BEGIN
3428:
3429: IF PO_LOG.d_proc THEN
3430: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3431: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3432: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3433: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3434: END IF;
3435:
3428:
3429: IF PO_LOG.d_proc THEN
3430: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3431: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3432: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3433: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3434: END IF;
3435:
3436: IF (x_results IS NULL) THEN
3429: IF PO_LOG.d_proc THEN
3430: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3431: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3432: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3433: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3434: END IF;
3435:
3436: IF (x_results IS NULL) THEN
3437: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3457: ELSE
3458: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3459: END IF;
3460:
3461: IF PO_LOG.d_proc THEN
3462: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3463: END IF;
3464:
3465: EXCEPTION WHEN OTHERS THEN
3458: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3459: END IF;
3460:
3461: IF PO_LOG.d_proc THEN
3462: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3463: END IF;
3464:
3465: EXCEPTION WHEN OTHERS THEN
3466: IF PO_LOG.d_exc THEN
3462: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3463: END IF;
3464:
3465: EXCEPTION WHEN OTHERS THEN
3466: IF PO_LOG.d_exc THEN
3467: PO_LOG.exc(d_mod,0,NULL);
3468: END IF;
3469: RAISE;
3470: END option_from_date_not_null;
3463: END IF;
3464:
3465: EXCEPTION WHEN OTHERS THEN
3466: IF PO_LOG.d_exc THEN
3467: PO_LOG.exc(d_mod,0,NULL);
3468: END IF;
3469: RAISE;
3470: END option_from_date_not_null;
3471:
3480: l_results_count NUMBER;
3481: d_mod CONSTANT VARCHAR2(100) := D_option_to_date_not_null;
3482: BEGIN
3483:
3484: IF PO_LOG.d_proc THEN
3485: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3486: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3487: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3488: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3481: d_mod CONSTANT VARCHAR2(100) := D_option_to_date_not_null;
3482: BEGIN
3483:
3484: IF PO_LOG.d_proc THEN
3485: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3486: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3487: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3488: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3489: END IF;
3482: BEGIN
3483:
3484: IF PO_LOG.d_proc THEN
3485: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3486: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3487: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3488: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3489: END IF;
3490:
3483:
3484: IF PO_LOG.d_proc THEN
3485: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3486: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3487: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3488: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3489: END IF;
3490:
3491: IF (x_results IS NULL) THEN
3484: IF PO_LOG.d_proc THEN
3485: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3486: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3487: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3488: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3489: END IF;
3490:
3491: IF (x_results IS NULL) THEN
3492: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3506: , p_message_name => 'PO_CLM_OPTION_TO_DATE_NOT_NULL'
3507: );
3508: END IF;
3509:
3510: IF PO_LOG.d_proc THEN
3511: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3512: END IF;
3513:
3514: END LOOP;
3507: );
3508: END IF;
3509:
3510: IF PO_LOG.d_proc THEN
3511: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3512: END IF;
3513:
3514: END LOOP;
3515: IF (l_results_count < x_results.result_type.COUNT) THEN
3517: ELSE
3518: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3519: END IF;
3520: EXCEPTION 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 option_to_date_not_null;
3518: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3519: END IF;
3520: EXCEPTION 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 option_to_date_not_null;
3526:
3538:
3539: BEGIN
3540: -- CLM changes
3541:
3542: IF PO_LOG.d_proc THEN
3543: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3544: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3545: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3546: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3539: BEGIN
3540: -- CLM changes
3541:
3542: IF PO_LOG.d_proc THEN
3543: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3544: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3545: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3546: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3547: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3540: -- CLM changes
3541:
3542: IF PO_LOG.d_proc THEN
3543: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3544: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3545: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3546: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3547: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3548: END IF;
3541:
3542: IF PO_LOG.d_proc THEN
3543: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3544: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3545: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3546: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3547: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3548: END IF;
3549:
3542: IF PO_LOG.d_proc THEN
3543: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3544: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3545: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3546: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3547: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3548: END IF;
3549:
3550: IF (x_results IS NULL) THEN
3543: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3544: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3545: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3546: PO_LOG.proc_begin(d_mod,'p_option_to_date_tbl',p_option_to_date_tbl);
3547: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3548: END IF;
3549:
3550: IF (x_results IS NULL) THEN
3551: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3573: ELSE
3574: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3575: END IF;
3576:
3577: IF PO_LOG.d_proc THEN
3578: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3579: END IF;
3580:
3581: EXCEPTION WHEN OTHERS THEN
3574: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3575: END IF;
3576:
3577: IF PO_LOG.d_proc THEN
3578: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3579: END IF;
3580:
3581: EXCEPTION WHEN OTHERS THEN
3582: IF PO_LOG.d_exc THEN
3578: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3579: END IF;
3580:
3581: EXCEPTION WHEN OTHERS THEN
3582: IF PO_LOG.d_exc THEN
3583: PO_LOG.exc(d_mod,0,NULL);
3584: END IF;
3585: RAISE;
3586: END option_to_date_le_from_date;
3579: END IF;
3580:
3581: EXCEPTION WHEN OTHERS THEN
3582: IF PO_LOG.d_exc THEN
3583: PO_LOG.exc(d_mod,0,NULL);
3584: END IF;
3585: RAISE;
3586: END option_to_date_le_from_date;
3587:
3600: mod_document_option_date DATE :=NULL;
3601: changeInOptionDate BOOLEAN := TRUE ;
3602: BEGIN
3603:
3604: IF PO_LOG.d_proc THEN
3605: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3606: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3607: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3608: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3601: changeInOptionDate BOOLEAN := TRUE ;
3602: BEGIN
3603:
3604: IF PO_LOG.d_proc THEN
3605: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3606: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3607: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3608: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3609: END IF;
3602: BEGIN
3603:
3604: IF PO_LOG.d_proc THEN
3605: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3606: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3607: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3608: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3609: END IF;
3610:
3603:
3604: IF PO_LOG.d_proc THEN
3605: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3606: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3607: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3608: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3609: END IF;
3610:
3611: IF (x_results IS NULL) THEN
3604: IF PO_LOG.d_proc THEN
3605: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3606: PO_LOG.proc_begin(d_mod,'p_option_ind_tbl',p_option_ind_tbl);
3607: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3608: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3609: END IF;
3610:
3611: IF (x_results IS NULL) THEN
3612: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3629: OR draft_id IS NULL)
3630: AND po_line_id = p_line_id_tbl(i);
3631: EXCEPTION
3632: WHEN No_Data_Found THEN
3633: PO_LOG.exc(d_mod,0,NULL);
3634: END ;
3635:
3636: mod_document_option_date := p_option_from_date_tbl(i);
3637:
3656: ELSE
3657: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3658: END IF;
3659:
3660: IF PO_LOG.d_proc THEN
3661: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3662: END IF;
3663:
3664: EXCEPTION WHEN OTHERS THEN
3657: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3658: END IF;
3659:
3660: IF PO_LOG.d_proc THEN
3661: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3662: END IF;
3663:
3664: EXCEPTION WHEN OTHERS THEN
3665: IF PO_LOG.d_exc THEN
3661: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3662: END IF;
3663:
3664: EXCEPTION WHEN OTHERS THEN
3665: IF PO_LOG.d_exc THEN
3666: PO_LOG.exc(d_mod,0,NULL);
3667: END IF;
3668: RAISE;
3669:
3662: END IF;
3663:
3664: EXCEPTION WHEN OTHERS THEN
3665: IF PO_LOG.d_exc THEN
3666: PO_LOG.exc(d_mod,0,NULL);
3667: END IF;
3668: RAISE;
3669:
3670: END option_from_date_le_sysdate;
3683:
3684: BEGIN
3685: -- CLM changes
3686:
3687: IF PO_LOG.d_proc THEN
3688: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3689: PO_LOG.proc_begin(d_mod,'p_exer_flag_tbl',p_exer_flag_tbl);
3690: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3691: PO_LOG.proc_begin(d_mod,'p_option_exer_date_tbl',p_option_exer_date_tbl);
3684: BEGIN
3685: -- CLM changes
3686:
3687: IF PO_LOG.d_proc THEN
3688: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3689: PO_LOG.proc_begin(d_mod,'p_exer_flag_tbl',p_exer_flag_tbl);
3690: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3691: PO_LOG.proc_begin(d_mod,'p_option_exer_date_tbl',p_option_exer_date_tbl);
3692: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3685: -- CLM changes
3686:
3687: IF PO_LOG.d_proc THEN
3688: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3689: PO_LOG.proc_begin(d_mod,'p_exer_flag_tbl',p_exer_flag_tbl);
3690: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3691: PO_LOG.proc_begin(d_mod,'p_option_exer_date_tbl',p_option_exer_date_tbl);
3692: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3693: END IF;
3686:
3687: IF PO_LOG.d_proc THEN
3688: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3689: PO_LOG.proc_begin(d_mod,'p_exer_flag_tbl',p_exer_flag_tbl);
3690: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3691: PO_LOG.proc_begin(d_mod,'p_option_exer_date_tbl',p_option_exer_date_tbl);
3692: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3693: END IF;
3694:
3687: IF PO_LOG.d_proc THEN
3688: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3689: PO_LOG.proc_begin(d_mod,'p_exer_flag_tbl',p_exer_flag_tbl);
3690: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3691: PO_LOG.proc_begin(d_mod,'p_option_exer_date_tbl',p_option_exer_date_tbl);
3692: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3693: END IF;
3694:
3695: IF (x_results IS NULL) THEN
3688: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3689: PO_LOG.proc_begin(d_mod,'p_exer_flag_tbl',p_exer_flag_tbl);
3690: PO_LOG.proc_begin(d_mod,'p_option_from_date_tbl',p_option_from_date_tbl);
3691: PO_LOG.proc_begin(d_mod,'p_option_exer_date_tbl',p_option_exer_date_tbl);
3692: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3693: END IF;
3694:
3695: IF (x_results IS NULL) THEN
3696: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3718: ELSE
3719: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3720: END IF;
3721:
3722: IF PO_LOG.d_proc THEN
3723: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3724: END IF;
3725:
3726: EXCEPTION WHEN OTHERS THEN
3719: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3720: END IF;
3721:
3722: IF PO_LOG.d_proc THEN
3723: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3724: END IF;
3725:
3726: EXCEPTION WHEN OTHERS THEN
3727: IF PO_LOG.d_exc THEN
3723: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3724: END IF;
3725:
3726: EXCEPTION WHEN OTHERS THEN
3727: IF PO_LOG.d_exc THEN
3728: PO_LOG.exc(d_mod,0,NULL);
3729: END IF;
3730: RAISE;
3731: END option_fm_date_le_ex_date;
3724: END IF;
3725:
3726: EXCEPTION WHEN OTHERS THEN
3727: IF PO_LOG.d_exc THEN
3728: PO_LOG.exc(d_mod,0,NULL);
3729: END IF;
3730: RAISE;
3731: END option_fm_date_le_ex_date;
3732:
3746: BEGIN
3747:
3748: line_id_tbl_count := p_line_id_tbl.COUNT;
3749:
3750: IF PO_LOG.d_proc THEN
3751: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3752: PO_LOG.proc_begin(d_mod,'p_line_num_disp_tbl',p_line_num_disp_tbl);
3753: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3754: END IF;
3747:
3748: line_id_tbl_count := p_line_id_tbl.COUNT;
3749:
3750: IF PO_LOG.d_proc THEN
3751: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3752: PO_LOG.proc_begin(d_mod,'p_line_num_disp_tbl',p_line_num_disp_tbl);
3753: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3754: END IF;
3755:
3748: line_id_tbl_count := p_line_id_tbl.COUNT;
3749:
3750: IF PO_LOG.d_proc THEN
3751: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3752: PO_LOG.proc_begin(d_mod,'p_line_num_disp_tbl',p_line_num_disp_tbl);
3753: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3754: END IF;
3755:
3756: IF (x_results IS NULL) THEN
3749:
3750: IF PO_LOG.d_proc THEN
3751: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3752: PO_LOG.proc_begin(d_mod,'p_line_num_disp_tbl',p_line_num_disp_tbl);
3753: PO_LOG.proc_begin(d_mod,'x_result_type',x_result_type);
3754: END IF;
3755:
3756: IF (x_results IS NULL) THEN
3757: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
3848: ELSE
3849: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3850: END IF;
3851:
3852: IF PO_LOG.d_proc THEN
3853: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3854: END IF;
3855:
3856: EXCEPTION WHEN OTHERS THEN
3849: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3850: END IF;
3851:
3852: IF PO_LOG.d_proc THEN
3853: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3854: END IF;
3855:
3856: EXCEPTION WHEN OTHERS THEN
3857: IF PO_LOG.d_exc THEN
3853: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3854: END IF;
3855:
3856: EXCEPTION WHEN OTHERS THEN
3857: IF PO_LOG.d_exc THEN
3858: PO_LOG.exc(d_mod,0,NULL);
3859: END IF;
3860: RAISE;
3861:
3854: END IF;
3855:
3856: EXCEPTION WHEN OTHERS THEN
3857: IF PO_LOG.d_exc THEN
3858: PO_LOG.exc(d_mod,0,NULL);
3859: END IF;
3860: RAISE;
3861:
3862: END line_num_disp_check;
3870: IS
3871: d_mod CONSTANT VARCHAR2(100) := D_mod_no_cancel_shp_complt;
3872: BEGIN
3873:
3874: IF PO_LOG.d_proc THEN
3875: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3876: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
3877: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3878: END IF;
3871: d_mod CONSTANT VARCHAR2(100) := D_mod_no_cancel_shp_complt;
3872: BEGIN
3873:
3874: IF PO_LOG.d_proc THEN
3875: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3876: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
3877: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3878: END IF;
3879: IF (x_result_set_id IS NULL) THEN
3872: BEGIN
3873:
3874: IF PO_LOG.d_proc THEN
3875: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3876: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
3877: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3878: END IF;
3879: IF (x_result_set_id IS NULL) THEN
3880: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
3873:
3874: IF PO_LOG.d_proc THEN
3875: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3876: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
3877: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
3878: END IF;
3879: IF (x_result_set_id IS NULL) THEN
3880: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
3881: END IF;
3908: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3909: END IF;
3910:
3911:
3912: IF PO_LOG.d_proc THEN
3913: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
3914: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3915: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
3916: END IF;
3910:
3911:
3912: IF PO_LOG.d_proc THEN
3913: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
3914: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3915: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
3916: END IF;
3917:
3918: EXCEPTION
3911:
3912: IF PO_LOG.d_proc THEN
3913: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
3914: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3915: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
3916: END IF;
3917:
3918: EXCEPTION
3919: WHEN OTHERS THEN
3916: END IF;
3917:
3918: EXCEPTION
3919: WHEN OTHERS THEN
3920: IF PO_LOG.d_exc THEN
3921: PO_LOG.exc(d_mod,0,NULL);
3922: END IF;
3923: RAISE;
3924:
3917:
3918: EXCEPTION
3919: WHEN OTHERS THEN
3920: IF PO_LOG.d_exc THEN
3921: PO_LOG.exc(d_mod,0,NULL);
3922: END IF;
3923: RAISE;
3924:
3925: END mod_no_cancel_shp_complt;
3953: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3954: RETURN;
3955: END IF;
3956:
3957: IF PO_LOG.d_proc THEN
3958: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3959: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
3960: END IF;
3961:
3954: RETURN;
3955: END IF;
3956:
3957: IF PO_LOG.d_proc THEN
3958: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3959: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
3960: END IF;
3961:
3962: IF (x_result_set_id IS NULL) THEN
3955: END IF;
3956:
3957: IF PO_LOG.d_proc THEN
3958: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
3959: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
3960: END IF;
3961:
3962: IF (x_result_set_id IS NULL) THEN
3963: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
4093: ELSE
4094: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4095: END IF;
4096:
4097: IF PO_LOG.d_proc THEN
4098: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4099: END IF;
4100:
4101: END clin_slin_num_check;
4094: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4095: END IF;
4096:
4097: IF PO_LOG.d_proc THEN
4098: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4099: END IF;
4100:
4101: END clin_slin_num_check;
4102:
4127: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4128: RETURN;
4129: END IF;
4130:
4131: IF PO_LOG.d_proc THEN
4132: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4133: PO_LOG.proc_begin(d_mod,'p_group_line_id_tbl',p_group_line_id_tbl);
4134: END IF;
4135:
4128: RETURN;
4129: END IF;
4130:
4131: IF PO_LOG.d_proc THEN
4132: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4133: PO_LOG.proc_begin(d_mod,'p_group_line_id_tbl',p_group_line_id_tbl);
4134: END IF;
4135:
4136: IF (x_results IS NULL) THEN
4129: END IF;
4130:
4131: IF PO_LOG.d_proc THEN
4132: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4133: PO_LOG.proc_begin(d_mod,'p_group_line_id_tbl',p_group_line_id_tbl);
4134: END IF;
4135:
4136: IF (x_results IS NULL) THEN
4137: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4174: ELSE
4175: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4176: END IF;
4177:
4178: IF PO_LOG.d_proc THEN
4179: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4180: END IF;
4181:
4182: EXCEPTION
4175: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4176: END IF;
4177:
4178: IF PO_LOG.d_proc THEN
4179: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4180: END IF;
4181:
4182: EXCEPTION
4183: WHEN OTHERS THEN
4180: END IF;
4181:
4182: EXCEPTION
4183: WHEN OTHERS THEN
4184: IF PO_LOG.d_exc THEN
4185: PO_LOG.exc(d_mod,0,NULL);
4186: END IF;
4187: RAISE;
4188: END clin_slin_structure;
4181:
4182: EXCEPTION
4183: WHEN OTHERS THEN
4184: IF PO_LOG.d_exc THEN
4185: PO_LOG.exc(d_mod,0,NULL);
4186: END IF;
4187: RAISE;
4188: END clin_slin_structure;
4189:
4208: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4209: RETURN;
4210: END IF;
4211:
4212: IF PO_LOG.d_proc THEN
4213: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4214: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
4215: END IF;
4216:
4209: RETURN;
4210: END IF;
4211:
4212: IF PO_LOG.d_proc THEN
4213: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4214: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
4215: END IF;
4216:
4217: IF (x_results IS NULL) THEN
4210: END IF;
4211:
4212: IF PO_LOG.d_proc THEN
4213: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4214: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
4215: END IF;
4216:
4217: IF (x_results IS NULL) THEN
4218: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4261: ELSE
4262: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4263: END IF;
4264:
4265: IF PO_LOG.d_proc THEN
4266: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4267: END IF;
4268:
4269: EXCEPTION
4262: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4263: END IF;
4264:
4265: IF PO_LOG.d_proc THEN
4266: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4267: END IF;
4268:
4269: EXCEPTION
4270: WHEN OTHERS THEN
4267: END IF;
4268:
4269: EXCEPTION
4270: WHEN OTHERS THEN
4271: IF PO_LOG.d_exc THEN
4272: PO_LOG.exc(d_mod,0,NULL);
4273: END IF;
4274:
4275: RAISE;
4268:
4269: EXCEPTION
4270: WHEN OTHERS THEN
4271: IF PO_LOG.d_exc THEN
4272: PO_LOG.exc(d_mod,0,NULL);
4273: END IF;
4274:
4275: RAISE;
4276:
4296: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4297: RETURN;
4298: END IF;
4299:
4300: IF PO_LOG.d_proc THEN
4301: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4302: --PO_LOG.proc_begin(d_mod,'p_cost_constraint_tbl',p_order_type_lookup_code_tbl);
4303: END IF;
4304:
4297: RETURN;
4298: END IF;
4299:
4300: IF PO_LOG.d_proc THEN
4301: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4302: --PO_LOG.proc_begin(d_mod,'p_cost_constraint_tbl',p_order_type_lookup_code_tbl);
4303: END IF;
4304:
4305: IF (x_results IS NULL) THEN
4298: END IF;
4299:
4300: IF PO_LOG.d_proc THEN
4301: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4302: --PO_LOG.proc_begin(d_mod,'p_cost_constraint_tbl',p_order_type_lookup_code_tbl);
4303: END IF;
4304:
4305: IF (x_results IS NULL) THEN
4306: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4335: ELSE
4336: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4337: END IF;
4338:
4339: IF PO_LOG.d_proc THEN
4340: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4341: END IF;
4342:
4343: EXCEPTION
4336: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4337: END IF;
4338:
4339: IF PO_LOG.d_proc THEN
4340: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4341: END IF;
4342:
4343: EXCEPTION
4344: WHEN OTHERS THEN
4341: END IF;
4342:
4343: EXCEPTION
4344: WHEN OTHERS THEN
4345: IF PO_LOG.d_exc THEN
4346: PO_LOG.exc(d_mod,0,NULL);
4347: END IF;
4348: RAISE;
4349:
4342:
4343: EXCEPTION
4344: WHEN OTHERS THEN
4345: IF PO_LOG.d_exc THEN
4346: PO_LOG.exc(d_mod,0,NULL);
4347: END IF;
4348: RAISE;
4349:
4350: END validate_cost_constraint;
4370: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4371: RETURN;
4372: END IF;
4373:
4374: IF PO_LOG.d_proc THEN
4375: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4376: --PO_LOG.proc_begin(d_mod,'p_oke_contract_header_num_tbl',p_oke_contract_header_num_tbl);
4377: END IF;
4378:
4371: RETURN;
4372: END IF;
4373:
4374: IF PO_LOG.d_proc THEN
4375: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4376: --PO_LOG.proc_begin(d_mod,'p_oke_contract_header_num_tbl',p_oke_contract_header_num_tbl);
4377: END IF;
4378:
4379: IF (x_results IS NULL) THEN
4372: END IF;
4373:
4374: IF PO_LOG.d_proc THEN
4375: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4376: --PO_LOG.proc_begin(d_mod,'p_oke_contract_header_num_tbl',p_oke_contract_header_num_tbl);
4377: END IF;
4378:
4379: IF (x_results IS NULL) THEN
4380: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4440: ELSE
4441: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4442: END IF;
4443:
4444: IF PO_LOG.d_proc THEN
4445: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4446: END IF;
4447:
4448: EXCEPTION
4441: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4442: END IF;
4443:
4444: IF PO_LOG.d_proc THEN
4445: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4446: END IF;
4447:
4448: EXCEPTION
4449: WHEN OTHERS THEN
4446: END IF;
4447:
4448: EXCEPTION
4449: WHEN OTHERS THEN
4450: IF PO_LOG.d_exc THEN
4451: PO_LOG.exc(d_mod,0,NULL);
4452: END IF;
4453: RAISE;
4454:
4447:
4448: EXCEPTION
4449: WHEN OTHERS THEN
4450: IF PO_LOG.d_exc THEN
4451: PO_LOG.exc(d_mod,0,NULL);
4452: END IF;
4453: RAISE;
4454:
4455: END check_contract_num_and_ver;
4474: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4475: RETURN;
4476: END IF;
4477:
4478: IF PO_LOG.d_proc THEN
4479: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4480: PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_option_indicator_tbl);
4481: END IF;
4482:
4475: RETURN;
4476: END IF;
4477:
4478: IF PO_LOG.d_proc THEN
4479: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4480: PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_option_indicator_tbl);
4481: END IF;
4482:
4483: IF (x_results IS NULL) THEN
4476: END IF;
4477:
4478: IF PO_LOG.d_proc THEN
4479: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4480: PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_option_indicator_tbl);
4481: END IF;
4482:
4483: IF (x_results IS NULL) THEN
4484: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4506: ELSE
4507: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4508: END IF;
4509:
4510: IF PO_LOG.d_proc THEN
4511: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4512: END IF;
4513:
4514: EXCEPTION
4507: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4508: END IF;
4509:
4510: IF PO_LOG.d_proc THEN
4511: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4512: END IF;
4513:
4514: EXCEPTION
4515: WHEN OTHERS THEN
4512: END IF;
4513:
4514: EXCEPTION
4515: WHEN OTHERS THEN
4516: IF PO_LOG.d_exc THEN
4517: PO_LOG.exc(d_mod,0,NULL);
4518: END IF;
4519: RAISE;
4520:
4513:
4514: EXCEPTION
4515: WHEN OTHERS THEN
4516: IF PO_LOG.d_exc THEN
4517: PO_LOG.exc(d_mod,0,NULL);
4518: END IF;
4519: RAISE;
4520:
4521: END validate_option_indicator;
4542: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4543: RETURN;
4544: END IF;
4545:
4546: IF PO_LOG.d_proc THEN
4547: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4548: --PO_LOG.proc_begin(d_mod,'validate_clm_base_line_num',validate_clm_base_line_num);
4549: END IF;
4550:
4543: RETURN;
4544: END IF;
4545:
4546: IF PO_LOG.d_proc THEN
4547: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4548: --PO_LOG.proc_begin(d_mod,'validate_clm_base_line_num',validate_clm_base_line_num);
4549: END IF;
4550:
4551: IF (x_results IS NULL) THEN
4544: END IF;
4545:
4546: IF PO_LOG.d_proc THEN
4547: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4548: --PO_LOG.proc_begin(d_mod,'validate_clm_base_line_num',validate_clm_base_line_num);
4549: END IF;
4550:
4551: IF (x_results IS NULL) THEN
4552: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4608: ELSE
4609: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4610: END IF;
4611:
4612: IF PO_LOG.d_proc THEN
4613: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4614: END IF;
4615:
4616: EXCEPTION
4609: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4610: END IF;
4611:
4612: IF PO_LOG.d_proc THEN
4613: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4614: END IF;
4615:
4616: EXCEPTION
4617: WHEN OTHERS THEN
4614: END IF;
4615:
4616: EXCEPTION
4617: WHEN OTHERS THEN
4618: IF PO_LOG.d_exc THEN
4619: PO_LOG.exc(d_mod,0,NULL);
4620: END IF;
4621: RAISE;
4622:
4615:
4616: EXCEPTION
4617: WHEN OTHERS THEN
4618: IF PO_LOG.d_exc THEN
4619: PO_LOG.exc(d_mod,0,NULL);
4620: END IF;
4621: RAISE;
4622:
4623: END validate_clm_base_line_num;
4645: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4646: RETURN;
4647: END IF;
4648:
4649: IF PO_LOG.d_proc THEN
4650: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4651: --PO_LOG.proc_begin(d_mod,'validate_clm_base_line_num',validate_clm_base_line_num);
4652: END IF;
4653: IF (x_results IS NULL) THEN
4646: RETURN;
4647: END IF;
4648:
4649: IF PO_LOG.d_proc THEN
4650: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4651: --PO_LOG.proc_begin(d_mod,'validate_clm_base_line_num',validate_clm_base_line_num);
4652: END IF;
4653: IF (x_results IS NULL) THEN
4654: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4647: END IF;
4648:
4649: IF PO_LOG.d_proc THEN
4650: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4651: --PO_LOG.proc_begin(d_mod,'validate_clm_base_line_num',validate_clm_base_line_num);
4652: END IF;
4653: IF (x_results IS NULL) THEN
4654: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4655: END IF;
4704: ELSE
4705: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4706: END IF;
4707:
4708: IF PO_LOG.d_proc THEN
4709: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4710: END IF;
4711:
4712: EXCEPTION
4705: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4706: END IF;
4707:
4708: IF PO_LOG.d_proc THEN
4709: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4710: END IF;
4711:
4712: EXCEPTION
4713: WHEN OTHERS THEN
4710: END IF;
4711:
4712: EXCEPTION
4713: WHEN OTHERS THEN
4714: IF PO_LOG.d_exc THEN
4715: PO_LOG.exc(d_mod,0,NULL);
4716: END IF;
4717: RAISE;
4718:
4711:
4712: EXCEPTION
4713: WHEN OTHERS THEN
4714: IF PO_LOG.d_exc THEN
4715: PO_LOG.exc(d_mod,0,NULL);
4716: END IF;
4717: RAISE;
4718:
4719: END validate_clm_option_num;
4738: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4739: RETURN;
4740: END IF;
4741:
4742: IF PO_LOG.d_proc THEN
4743: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4744: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4745: END IF;
4746:
4739: RETURN;
4740: END IF;
4741:
4742: IF PO_LOG.d_proc THEN
4743: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4744: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4745: END IF;
4746:
4747: IF (x_results IS NULL) THEN
4740: END IF;
4741:
4742: IF PO_LOG.d_proc THEN
4743: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4744: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4745: END IF;
4746:
4747: IF (x_results IS NULL) THEN
4748: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4778: ELSE
4779: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4780: END IF;
4781:
4782: IF PO_LOG.d_proc THEN
4783: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4784: END IF;
4785:
4786: EXCEPTION
4779: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4780: END IF;
4781:
4782: IF PO_LOG.d_proc THEN
4783: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4784: END IF;
4785:
4786: EXCEPTION
4787: WHEN OTHERS THEN
4784: END IF;
4785:
4786: EXCEPTION
4787: WHEN OTHERS THEN
4788: IF PO_LOG.d_exc THEN
4789: PO_LOG.exc(d_mod,0,NULL);
4790: END IF;
4791: RAISE;
4792:
4785:
4786: EXCEPTION
4787: WHEN OTHERS THEN
4788: IF PO_LOG.d_exc THEN
4789: PO_LOG.exc(d_mod,0,NULL);
4790: END IF;
4791: RAISE;
4792:
4793: END validate_clm_idc_type;
4814: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4815: RETURN;
4816: END IF;
4817:
4818: IF PO_LOG.d_proc THEN
4819: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4820: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4821: END IF;
4822:
4815: RETURN;
4816: END IF;
4817:
4818: IF PO_LOG.d_proc THEN
4819: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4820: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4821: END IF;
4822:
4823: IF (x_results IS NULL) THEN
4816: END IF;
4817:
4818: IF PO_LOG.d_proc THEN
4819: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4820: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4821: END IF;
4822:
4823: IF (x_results IS NULL) THEN
4824: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4862: ELSE
4863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4864: END IF;
4865:
4866: IF PO_LOG.d_proc THEN
4867: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4868: END IF;
4869:
4870: EXCEPTION
4863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4864: END IF;
4865:
4866: IF PO_LOG.d_proc THEN
4867: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4868: END IF;
4869:
4870: EXCEPTION
4871: WHEN OTHERS THEN
4868: END IF;
4869:
4870: EXCEPTION
4871: WHEN OTHERS THEN
4872: IF PO_LOG.d_exc THEN
4873: PO_LOG.exc(d_mod,0,NULL);
4874: END IF;
4875: RAISE;
4876:
4869:
4870: EXCEPTION
4871: WHEN OTHERS THEN
4872: IF PO_LOG.d_exc THEN
4873: PO_LOG.exc(d_mod,0,NULL);
4874: END IF;
4875: RAISE;
4876:
4877: END validate_clin_line_num_disp;
4890: l_intf_line_id_tbl PO_TBL_NUMBER;
4891: l_data_key NUMBER;
4892: BEGIN
4893:
4894: IF PO_LOG.d_proc THEN
4895: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4896: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4897: END IF;
4898:
4891: l_data_key NUMBER;
4892: BEGIN
4893:
4894: IF PO_LOG.d_proc THEN
4895: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4896: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4897: END IF;
4898:
4899: IF (x_results IS NULL) THEN
4892: BEGIN
4893:
4894: IF PO_LOG.d_proc THEN
4895: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4896: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4897: END IF;
4898:
4899: IF (x_results IS NULL) THEN
4900: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
4934: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
4935: ELSE
4936: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4937: END IF;
4938: IF PO_LOG.d_proc THEN
4939: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4940: END IF;
4941:
4942: EXCEPTION
4935: ELSE
4936: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
4937: END IF;
4938: IF PO_LOG.d_proc THEN
4939: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
4940: END IF;
4941:
4942: EXCEPTION
4943: WHEN OTHERS THEN
4940: END IF;
4941:
4942: EXCEPTION
4943: WHEN OTHERS THEN
4944: IF PO_LOG.d_exc THEN
4945: PO_LOG.exc(d_mod,0,NULL);
4946: END IF;
4947: RAISE;
4948:
4941:
4942: EXCEPTION
4943: WHEN OTHERS THEN
4944: IF PO_LOG.d_exc THEN
4945: PO_LOG.exc(d_mod,0,NULL);
4946: END IF;
4947: RAISE;
4948:
4949: END idv_reference_equal_check;
4963: l_line_count NUMBER := 0;
4964: l_intf_line_id_tbl PO_TBL_NUMBER;
4965: l_data_key NUMBER;
4966: BEGIN
4967: IF PO_LOG.d_proc THEN
4968: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4969: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4970: END IF;
4971:
4964: l_intf_line_id_tbl PO_TBL_NUMBER;
4965: l_data_key NUMBER;
4966: BEGIN
4967: IF PO_LOG.d_proc THEN
4968: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4969: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4970: END IF;
4971:
4972: IF (x_results IS NULL) THEN
4965: l_data_key NUMBER;
4966: BEGIN
4967: IF PO_LOG.d_proc THEN
4968: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);
4969: --PO_LOG.proc_begin(d_mod,'p_clm_option_indicator_tbl',p_clm_idc_type_tbl);
4970: END IF;
4971:
4972: IF (x_results IS NULL) THEN
4973: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
5006: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
5007: ELSE
5008: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5009: END IF;
5010: IF PO_LOG.d_proc THEN
5011: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5012: END IF;
5013:
5014: EXCEPTION
5007: ELSE
5008: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5009: END IF;
5010: IF PO_LOG.d_proc THEN
5011: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5012: END IF;
5013:
5014: EXCEPTION
5015: WHEN OTHERS THEN
5012: END IF;
5013:
5014: EXCEPTION
5015: WHEN OTHERS THEN
5016: IF PO_LOG.d_exc THEN
5017: PO_LOG.exc(d_mod,0,NULL);
5018: END IF;
5019: RAISE;
5020:
5013:
5014: EXCEPTION
5015: WHEN OTHERS THEN
5016: IF PO_LOG.d_exc THEN
5017: PO_LOG.exc(d_mod,0,NULL);
5018: END IF;
5019: RAISE;
5020:
5021: END validate_clm_line_type_id;
5057: l_draft_type VARCHAR2(10);
5058:
5059: BEGIN
5060:
5061: IF PO_LOG.d_proc THEN
5062: PO_LOG.proc_begin(d_mod);
5063: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5064: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5065: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
5058:
5059: BEGIN
5060:
5061: IF PO_LOG.d_proc THEN
5062: PO_LOG.proc_begin(d_mod);
5063: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5064: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5065: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
5066: PO_LOG.proc_begin(d_mod,'p_comments_tbl',p_comments_tbl);
5059: BEGIN
5060:
5061: IF PO_LOG.d_proc THEN
5062: PO_LOG.proc_begin(d_mod);
5063: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5064: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5065: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
5066: PO_LOG.proc_begin(d_mod,'p_comments_tbl',p_comments_tbl);
5067: END IF;
5060:
5061: IF PO_LOG.d_proc THEN
5062: PO_LOG.proc_begin(d_mod);
5063: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5064: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5065: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
5066: PO_LOG.proc_begin(d_mod,'p_comments_tbl',p_comments_tbl);
5067: END IF;
5068:
5061: IF PO_LOG.d_proc THEN
5062: PO_LOG.proc_begin(d_mod);
5063: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5064: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5065: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
5066: PO_LOG.proc_begin(d_mod,'p_comments_tbl',p_comments_tbl);
5067: END IF;
5068:
5069: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5062: PO_LOG.proc_begin(d_mod);
5063: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5064: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5065: PO_LOG.proc_begin(d_mod,'p_draft_type_tbl',p_draft_type_tbl);
5066: PO_LOG.proc_begin(d_mod,'p_comments_tbl',p_comments_tbl);
5067: END IF;
5068:
5069: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5070:
5094: , x_results => x_results
5095: , x_result_type => x_result_type
5096: );
5097:
5098: IF PO_LOG.d_proc THEN
5099: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5100: END IF;
5101: END validate_comments_not_null;
5102:
5095: , x_result_type => x_result_type
5096: );
5097:
5098: IF PO_LOG.d_proc THEN
5099: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5100: END IF;
5101: END validate_comments_not_null;
5102:
5103:
5126: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5127: RETURN;
5128: END IF;
5129:
5130: IF PO_LOG.d_proc THEN
5131: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5132: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5133: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
5134: END IF;
5127: RETURN;
5128: END IF;
5129:
5130: IF PO_LOG.d_proc THEN
5131: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5132: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5133: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
5134: END IF;
5135:
5128: END IF;
5129:
5130: IF PO_LOG.d_proc THEN
5131: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5132: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5133: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
5134: END IF;
5135:
5136: IF (x_result_set_id IS NULL) THEN
5129:
5130: IF PO_LOG.d_proc THEN
5131: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
5132: PO_LOG.proc_begin(d_mod,'p_draft_id_tbl',p_draft_id_tbl);
5133: PO_LOG.proc_begin(d_mod,'p_header_id_tbl',p_header_id_tbl);
5134: END IF;
5135:
5136: IF (x_result_set_id IS NULL) THEN
5137: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
5179: ELSE
5180: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5181: END IF;
5182:
5183: IF PO_LOG.d_proc THEN
5184: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5185: END IF;
5186:
5187: END validate_exhibit_name;
5180: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5181: END IF;
5182:
5183: IF PO_LOG.d_proc THEN
5184: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5185: END IF;
5186:
5187: END validate_exhibit_name;
5188: -- bug 16461105
5208: l_po_draft_id_tbl po_tbl_number; --bug 16385613
5209: l_results_count NUMBER; -- bug 16759650
5210: BEGIN
5211:
5212: IF PO_LOG.d_proc THEN
5213: PO_LOG.proc_begin(d_mod,'p_po_line_uca_id',p_po_line_uca_id);
5214: END IF;
5215:
5216: IF (x_results IS NULL) THEN
5209: l_results_count NUMBER; -- bug 16759650
5210: BEGIN
5211:
5212: IF PO_LOG.d_proc THEN
5213: PO_LOG.proc_begin(d_mod,'p_po_line_uca_id',p_po_line_uca_id);
5214: END IF;
5215:
5216: IF (x_results IS NULL) THEN
5217: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
5317: ELSE
5318: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5319: END IF;
5320:
5321: IF PO_LOG.d_proc THEN
5322: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5323: END IF;
5324:
5325: EXCEPTION WHEN OTHERS THEN
5318: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
5319: END IF;
5320:
5321: IF PO_LOG.d_proc THEN
5322: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5323: END IF;
5324:
5325: EXCEPTION WHEN OTHERS THEN
5326: IF PO_LOG.d_exc THEN
5322: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
5323: END IF;
5324:
5325: EXCEPTION WHEN OTHERS THEN
5326: IF PO_LOG.d_exc THEN
5327: PO_LOG.exc(d_mod,0,NULL);
5328: END IF;
5329: RAISE;
5330:
5323: END IF;
5324:
5325: EXCEPTION WHEN OTHERS THEN
5326: IF PO_LOG.d_exc THEN
5327: PO_LOG.exc(d_mod,0,NULL);
5328: END IF;
5329: RAISE;
5330:
5331: END validate_undef_amt_le_line_amt;