[Home] [Help]
22: ---------------------------------------------------------------------------
23:
24: -- The module base for this package.
25: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
26: PO_LOG.get_package_base('PO_VALIDATION_HELPER');
27:
28: -- The module base for the subprogram.
29: D_greater_than_zero CONSTANT VARCHAR2(100) :=
30: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_than_zero');
26: PO_LOG.get_package_base('PO_VALIDATION_HELPER');
27:
28: -- The module base for the subprogram.
29: D_greater_than_zero CONSTANT VARCHAR2(100) :=
30: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_than_zero');
31:
32: -- The module base for the subprogram.
33: D_greater_or_equal_zero CONSTANT VARCHAR2(100) :=
34: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_or_equal_zero');
30: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_than_zero');
31:
32: -- The module base for the subprogram.
33: D_greater_or_equal_zero CONSTANT VARCHAR2(100) :=
34: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_or_equal_zero');
35:
36: -- The module base for the subprogram.
37: D_within_percentage_range CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'within_percentage_range');
34: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_or_equal_zero');
35:
36: -- The module base for the subprogram.
37: D_within_percentage_range CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'within_percentage_range');
39:
40: -- The module base for the subprogram.
41: D_not_null CONSTANT VARCHAR2(100) :=
42: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'not_null');
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'within_percentage_range');
39:
40: -- The module base for the subprogram.
41: D_not_null CONSTANT VARCHAR2(100) :=
42: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'not_null');
43:
44: -- The module base for the subprogram.
45: D_ensure_null CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'ensure_null');
46:
41: D_not_null CONSTANT VARCHAR2(100) :=
42: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'not_null');
43:
44: -- The module base for the subprogram.
45: D_ensure_null CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'ensure_null');
46:
47: -- The module base for the subprogram.
48: D_flag_value_Y_N CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'flag_value_Y_N');
49:
44: -- The module base for the subprogram.
45: D_ensure_null CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'ensure_null');
46:
47: -- The module base for the subprogram.
48: D_flag_value_Y_N CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'flag_value_Y_N');
49:
50: -- The module base for the subprogram.
51: D_zero CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'zero');
52:
47: -- The module base for the subprogram.
48: D_flag_value_Y_N CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'flag_value_Y_N');
49:
50: -- The module base for the subprogram.
51: D_zero CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'zero');
52:
53: -- The module base for the subprogram.
54: D_terms_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'terms_id');
55:
50: -- The module base for the subprogram.
51: D_zero CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'zero');
52:
53: -- The module base for the subprogram.
54: D_terms_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'terms_id');
55:
56: -- The module base for the subprogram.
57: D_open_period CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'open_period');
54: D_terms_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'terms_id');
55:
56: -- The module base for the subprogram.
57: D_open_period CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'open_period');
59:
60: -- The module base for the subprogram.
61: D_gt_zero_order_type_filter CONSTANT VARCHAR2(100) :=
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_order_type_filter');
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'open_period');
59:
60: -- The module base for the subprogram.
61: D_gt_zero_order_type_filter CONSTANT VARCHAR2(100) :=
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_order_type_filter');
63:
64: -- The module base for the subprogram.
65: D_no_timecards_exist CONSTANT VARCHAR2(100) :=
66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'no_timecards_exist');
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_order_type_filter');
63:
64: -- The module base for the subprogram.
65: D_no_timecards_exist CONSTANT VARCHAR2(100) :=
66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'no_timecards_exist');
67:
68: -- The module base for the subprogram.
69: D_amount_notif_ctrl_warning CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_notif_ctrl_warning');
66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'no_timecards_exist');
67:
68: -- The module base for the subprogram.
69: D_amount_notif_ctrl_warning CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_notif_ctrl_warning');
71:
72: -- The module base for the subprogram.
73: D_child_num_unique CONSTANT VARCHAR2(100) :=
74: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'child_num_unique');
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_notif_ctrl_warning');
71:
72: -- The module base for the subprogram.
73: D_child_num_unique CONSTANT VARCHAR2(100) :=
74: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'child_num_unique');
75:
76: D_price_diff_value_unique CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_value_unique');
78:
73: D_child_num_unique CONSTANT VARCHAR2(100) :=
74: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'child_num_unique');
75:
76: D_price_diff_value_unique CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_value_unique');
78:
79: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
81:
76: D_price_diff_value_unique CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_value_unique');
78:
79: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
81:
82: D_num1_less_or_equal_num2 CONSTANT VARCHAR2(100) :=
83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'num1_less_or_equal_num2');
84:
79: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
81:
82: D_num1_less_or_equal_num2 CONSTANT VARCHAR2(100) :=
83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'num1_less_or_equal_num2');
84:
85: D_gt_zero_opm_filter CONSTANT VARCHAR2(100) :=
86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_opm_filter');
87:
82: D_num1_less_or_equal_num2 CONSTANT VARCHAR2(100) :=
83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'num1_less_or_equal_num2');
84:
85: D_gt_zero_opm_filter CONSTANT VARCHAR2(100) :=
86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_opm_filter');
87:
88: D_qtys_within_deviation CONSTANT VARCHAR2(100) :=
89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'qtys_within_deviation');
90:
85: D_gt_zero_opm_filter CONSTANT VARCHAR2(100) :=
86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_opm_filter');
87:
88: D_qtys_within_deviation CONSTANT VARCHAR2(100) :=
89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'qtys_within_deviation');
90:
91: D_secondary_unit_of_measure CONSTANT VARCHAR2(100) :=
92: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_unit_of_measure');
93:
88: D_qtys_within_deviation CONSTANT VARCHAR2(100) :=
89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'qtys_within_deviation');
90:
91: D_secondary_unit_of_measure CONSTANT VARCHAR2(100) :=
92: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_unit_of_measure');
93:
94: D_secondary_quantity CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_quantity');
96:
91: D_secondary_unit_of_measure CONSTANT VARCHAR2(100) :=
92: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_unit_of_measure');
93:
94: D_secondary_quantity CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_quantity');
96:
97: D_preferred_grade CONSTANT VARCHAR2(100) :=
98: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'preferred_grade');
99:
94: D_secondary_quantity CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_quantity');
96:
97: D_preferred_grade CONSTANT VARCHAR2(100) :=
98: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'preferred_grade');
99:
100: D_secondary_uom_update CONSTANT VARCHAR2(100) :=
101: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_uom_update');
102:
97: D_preferred_grade CONSTANT VARCHAR2(100) :=
98: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'preferred_grade');
99:
100: D_secondary_uom_update CONSTANT VARCHAR2(100) :=
101: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_uom_update');
102:
103: D_process_enabled CONSTANT VARCHAR2(100) :=
104: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'process_enabled');
105:
100: D_secondary_uom_update CONSTANT VARCHAR2(100) :=
101: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_uom_update');
102:
103: D_process_enabled CONSTANT VARCHAR2(100) :=
104: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'process_enabled');
105:
106: D_get_converted_unit_of_meas CONSTANT VARCHAR2(100) :=
107: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_converted_unit_of_meas');
108:
103: D_process_enabled CONSTANT VARCHAR2(100) :=
104: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'process_enabled');
105:
106: D_get_converted_unit_of_meas CONSTANT VARCHAR2(100) :=
107: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_converted_unit_of_meas');
108:
109: D_get_item_secondary_uom CONSTANT VARCHAR2(100) :=
110: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'get_item_secondary_uom');
111:
106: D_get_converted_unit_of_meas CONSTANT VARCHAR2(100) :=
107: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_converted_unit_of_meas');
108:
109: D_get_item_secondary_uom CONSTANT VARCHAR2(100) :=
110: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'get_item_secondary_uom');
111:
112: D_validate_desc_flex CONSTANT VARCHAR2(100) :=
113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_desc_flex');
114:
109: D_get_item_secondary_uom CONSTANT VARCHAR2(100) :=
110: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'get_item_secondary_uom');
111:
112: D_validate_desc_flex CONSTANT VARCHAR2(100) :=
113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_desc_flex');
114:
115: -------------------------------------------------------------------------------
116: -- Private Functions/Procedures
117: -------------------------------------------------------------------------------
171: l_null_not_allowed BOOLEAN;
172: l_message_name VARCHAR2(30);
173: BEGIN
174:
175: IF PO_LOG.d_proc THEN
176: PO_LOG.proc_begin(p_calling_module);
177: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
178: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
179: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
172: l_message_name VARCHAR2(30);
173: BEGIN
174:
175: IF PO_LOG.d_proc THEN
176: PO_LOG.proc_begin(p_calling_module);
177: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
178: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
179: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
180: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
173: BEGIN
174:
175: IF PO_LOG.d_proc THEN
176: PO_LOG.proc_begin(p_calling_module);
177: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
178: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
179: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
180: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
181: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
174:
175: IF PO_LOG.d_proc THEN
176: PO_LOG.proc_begin(p_calling_module);
177: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
178: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
179: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
180: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
181: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
182: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
175: IF PO_LOG.d_proc THEN
176: PO_LOG.proc_begin(p_calling_module);
177: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
178: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
179: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
180: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
181: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
182: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
183: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
176: PO_LOG.proc_begin(p_calling_module);
177: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
178: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
179: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
180: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
181: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
182: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
183: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
184: END IF;
177: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
178: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
179: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
180: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
181: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
182: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
183: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
184: END IF;
185:
178: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
179: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
180: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
181: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
182: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
183: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
184: END IF;
185:
186: IF (x_results IS NULL) THEN
179: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
180: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
181: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
182: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
183: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
184: END IF;
185:
186: IF (x_results IS NULL) THEN
187: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
196: END IF;
197:
198: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO);
199:
200: IF PO_LOG.d_stmt THEN
201: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
202: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
203: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
204: END IF;
197:
198: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO);
199:
200: IF PO_LOG.d_stmt THEN
201: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
202: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
203: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
204: END IF;
205:
198: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO);
199:
200: IF PO_LOG.d_stmt THEN
201: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
202: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
203: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
204: END IF;
205:
206: FOR i IN 1 .. p_value_tbl.COUNT LOOP
199:
200: IF PO_LOG.d_stmt THEN
201: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
202: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
203: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
204: END IF;
205:
206: FOR i IN 1 .. p_value_tbl.COUNT LOOP
207: IF (p_value_tbl(i) <= 0 OR (l_null_not_allowed AND p_value_tbl(i) IS NULL)) THEN
220: ELSE
221: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
222: END IF;
223:
224: IF PO_LOG.d_proc THEN
225: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
226: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
227: PO_LOG.proc_end(p_calling_module);
228: END IF;
221: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
222: END IF;
223:
224: IF PO_LOG.d_proc THEN
225: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
226: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
227: PO_LOG.proc_end(p_calling_module);
228: END IF;
229:
222: END IF;
223:
224: IF PO_LOG.d_proc THEN
225: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
226: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
227: PO_LOG.proc_end(p_calling_module);
228: END IF;
229:
230: EXCEPTION
223:
224: IF PO_LOG.d_proc THEN
225: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
226: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
227: PO_LOG.proc_end(p_calling_module);
228: END IF;
229:
230: EXCEPTION
231: WHEN OTHERS THEN
228: END IF;
229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF PO_LOG.d_exc THEN
233: PO_LOG.exc(d_mod,0,NULL);
234: PO_LOG.exc(p_calling_module,0,NULL);
235: END IF;
236: RAISE;
229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF PO_LOG.d_exc THEN
233: PO_LOG.exc(d_mod,0,NULL);
234: PO_LOG.exc(p_calling_module,0,NULL);
235: END IF;
236: RAISE;
237:
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF PO_LOG.d_exc THEN
233: PO_LOG.exc(d_mod,0,NULL);
234: PO_LOG.exc(p_calling_module,0,NULL);
235: END IF;
236: RAISE;
237:
238: END greater_than_zero;
297: l_token2_value_tbl PO_TBL_VARCHAR4000;
298:
299: BEGIN
300:
301: IF PO_LOG.d_proc THEN
302: PO_LOG.proc_begin(p_calling_module);
303: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
304: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
305: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
298:
299: BEGIN
300:
301: IF PO_LOG.d_proc THEN
302: PO_LOG.proc_begin(p_calling_module);
303: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
304: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
305: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
306: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
299: BEGIN
300:
301: IF PO_LOG.d_proc THEN
302: PO_LOG.proc_begin(p_calling_module);
303: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
304: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
305: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
306: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
307: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
300:
301: IF PO_LOG.d_proc THEN
302: PO_LOG.proc_begin(p_calling_module);
303: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
304: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
305: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
306: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
307: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
308: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
301: IF PO_LOG.d_proc THEN
302: PO_LOG.proc_begin(p_calling_module);
303: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
304: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
305: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
306: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
307: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
308: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
309: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
302: PO_LOG.proc_begin(p_calling_module);
303: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
304: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
305: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
306: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
307: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
308: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
309: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
310: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
303: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
304: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
305: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
306: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
307: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
308: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
309: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
310: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
311: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
304: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
305: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
306: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
307: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
308: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
309: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
310: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
311: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
312: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
305: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
306: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
307: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
308: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
309: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
310: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
311: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
312: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
313: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
306: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
307: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
308: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
309: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
310: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
311: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
312: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
313: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
314: END IF;
307: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
308: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
309: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
310: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
311: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
312: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
313: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
314: END IF;
315:
308: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
309: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
310: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
311: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
312: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
313: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
314: END IF;
315:
316: IF (x_results IS NULL) THEN
309: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
310: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
311: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
312: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
313: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
314: END IF;
315:
316: IF (x_results IS NULL) THEN
317: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
333: END IF;
334:
335: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO);
336:
337: IF PO_LOG.d_stmt THEN
338: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
339: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
340: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
341: END IF;
334:
335: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO);
336:
337: IF PO_LOG.d_stmt THEN
338: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
339: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
340: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
341: END IF;
342:
335: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO);
336:
337: IF PO_LOG.d_stmt THEN
338: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
339: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
340: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
341: END IF;
342:
343: FOR i IN 1 .. p_value_tbl.COUNT LOOP
336:
337: IF PO_LOG.d_stmt THEN
338: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
339: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
340: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
341: END IF;
342:
343: FOR i IN 1 .. p_value_tbl.COUNT LOOP
344: IF (p_value_tbl(i) < 0 OR (l_null_not_allowed AND p_value_tbl(i) IS NULL)) THEN
361: ELSE
362: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
363: END IF;
364:
365: IF PO_LOG.d_proc THEN
366: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
367: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
368: PO_LOG.proc_end(p_calling_module);
369: END IF;
362: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
363: END IF;
364:
365: IF PO_LOG.d_proc THEN
366: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
367: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
368: PO_LOG.proc_end(p_calling_module);
369: END IF;
370:
363: END IF;
364:
365: IF PO_LOG.d_proc THEN
366: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
367: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
368: PO_LOG.proc_end(p_calling_module);
369: END IF;
370:
371: EXCEPTION
364:
365: IF PO_LOG.d_proc THEN
366: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
367: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
368: PO_LOG.proc_end(p_calling_module);
369: END IF;
370:
371: EXCEPTION
372: WHEN OTHERS THEN
369: END IF;
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: IF PO_LOG.d_exc THEN
374: PO_LOG.exc(d_mod,0,NULL);
375: PO_LOG.exc(p_calling_module,0,NULL);
376: END IF;
377: RAISE;
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: IF PO_LOG.d_exc THEN
374: PO_LOG.exc(d_mod,0,NULL);
375: PO_LOG.exc(p_calling_module,0,NULL);
376: END IF;
377: RAISE;
378:
371: EXCEPTION
372: WHEN OTHERS THEN
373: IF PO_LOG.d_exc THEN
374: PO_LOG.exc(d_mod,0,NULL);
375: PO_LOG.exc(p_calling_module,0,NULL);
376: END IF;
377: RAISE;
378:
379: END greater_or_equal_zero;
438: l_message_name VARCHAR2(30);
439: l_token1_value_tbl PO_TBL_VARCHAR4000;
440: BEGIN
441:
442: IF PO_LOG.d_proc THEN
443: PO_LOG.proc_begin(p_calling_module);
444: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
445: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
446: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
439: l_token1_value_tbl PO_TBL_VARCHAR4000;
440: BEGIN
441:
442: IF PO_LOG.d_proc THEN
443: PO_LOG.proc_begin(p_calling_module);
444: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
445: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
446: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
447: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
440: BEGIN
441:
442: IF PO_LOG.d_proc THEN
443: PO_LOG.proc_begin(p_calling_module);
444: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
445: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
446: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
447: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
448: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
441:
442: IF PO_LOG.d_proc THEN
443: PO_LOG.proc_begin(p_calling_module);
444: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
445: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
446: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
447: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
448: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
449: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
442: IF PO_LOG.d_proc THEN
443: PO_LOG.proc_begin(p_calling_module);
444: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
445: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
446: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
447: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
448: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
449: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
450: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
443: PO_LOG.proc_begin(p_calling_module);
444: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
445: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
446: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
447: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
448: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
449: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
450: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
451: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
444: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
445: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
446: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
447: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
448: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
449: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
450: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
451: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
445: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
446: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
447: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
448: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
449: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
450: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
451: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
453: END IF;
446: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
447: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
448: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
449: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
450: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
451: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
453: END IF;
454:
447: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
448: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
449: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
450: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
451: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
453: END IF;
454:
455: IF (x_results IS NULL) THEN
448: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
449: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
450: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
451: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
453: END IF;
454:
455: IF (x_results IS NULL) THEN
456: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
472: ELSE
473: l_token1_value_tbl := p_token1_value_tbl;
474: END IF;
475:
476: IF PO_LOG.d_stmt THEN
477: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
478: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
479: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
480: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);
473: l_token1_value_tbl := p_token1_value_tbl;
474: END IF;
475:
476: IF PO_LOG.d_stmt THEN
477: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
478: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
479: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
480: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);
481: END IF;
474: END IF;
475:
476: IF PO_LOG.d_stmt THEN
477: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
478: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
479: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
480: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);
481: END IF;
482:
475:
476: IF PO_LOG.d_stmt THEN
477: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
478: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
479: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
480: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);
481: END IF;
482:
483: FOR i IN 1 .. p_value_tbl.COUNT LOOP
476: IF PO_LOG.d_stmt THEN
477: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
478: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
479: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
480: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);
481: END IF;
482:
483: FOR i IN 1 .. p_value_tbl.COUNT LOOP
484: IF (p_value_tbl(i) < 0 OR p_value_tbl(i) > 100
501: ELSE
502: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
503: END IF;
504:
505: IF PO_LOG.d_proc THEN
506: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
507: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
508: PO_LOG.proc_end(p_calling_module);
509: END IF;
502: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
503: END IF;
504:
505: IF PO_LOG.d_proc THEN
506: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
507: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
508: PO_LOG.proc_end(p_calling_module);
509: END IF;
510:
503: END IF;
504:
505: IF PO_LOG.d_proc THEN
506: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
507: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
508: PO_LOG.proc_end(p_calling_module);
509: END IF;
510:
511: EXCEPTION
504:
505: IF PO_LOG.d_proc THEN
506: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
507: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
508: PO_LOG.proc_end(p_calling_module);
509: END IF;
510:
511: EXCEPTION
512: WHEN OTHERS THEN
509: END IF;
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: IF PO_LOG.d_exc THEN
514: PO_LOG.exc(d_mod,0,NULL);
515: PO_LOG.exc(p_calling_module,0,NULL);
516: END IF;
517: RAISE;
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: IF PO_LOG.d_exc THEN
514: PO_LOG.exc(d_mod,0,NULL);
515: PO_LOG.exc(p_calling_module,0,NULL);
516: END IF;
517: RAISE;
518:
511: EXCEPTION
512: WHEN OTHERS THEN
513: IF PO_LOG.d_exc THEN
514: PO_LOG.exc(d_mod,0,NULL);
515: PO_LOG.exc(p_calling_module,0,NULL);
516: END IF;
517: RAISE;
518:
519: END within_percentage_range;
573: d_mod CONSTANT VARCHAR2(100) := D_open_period;
574: l_profile_value VARCHAR2(2000);
575: BEGIN
576:
577: IF PO_LOG.d_proc THEN
578: PO_LOG.proc_begin(p_calling_module);
579: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
580: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
581: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
574: l_profile_value VARCHAR2(2000);
575: BEGIN
576:
577: IF PO_LOG.d_proc THEN
578: PO_LOG.proc_begin(p_calling_module);
579: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
580: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
581: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
582: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
575: BEGIN
576:
577: IF PO_LOG.d_proc THEN
578: PO_LOG.proc_begin(p_calling_module);
579: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
580: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
581: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
582: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
583: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
576:
577: IF PO_LOG.d_proc THEN
578: PO_LOG.proc_begin(p_calling_module);
579: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
580: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
581: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
582: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
583: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
584: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
577: IF PO_LOG.d_proc THEN
578: PO_LOG.proc_begin(p_calling_module);
579: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
580: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
581: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
582: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
583: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
584: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
585: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
578: PO_LOG.proc_begin(p_calling_module);
579: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
580: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
581: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
582: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
583: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
584: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
585: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
586: END IF;
579: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
580: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
581: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
582: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
583: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
584: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
585: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
586: END IF;
587:
580: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
581: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
582: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
583: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
584: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
585: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
586: END IF;
587:
588: IF (x_result_set_id IS NULL) THEN
581: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
582: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
583: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
584: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
585: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
586: END IF;
587:
588: IF (x_result_set_id IS NULL) THEN
589: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
592: FND_PROFILE.get(PO_PROFILES.PO_CHECK_OPEN_PERIODS,l_profile_value);
593:
594: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
595:
596: IF PO_LOG.d_stmt THEN
597: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
598: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
599: PO_LOG.stmt(d_mod,0,'x_result_type',x_result_type);
600: END IF;
593:
594: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
595:
596: IF PO_LOG.d_stmt THEN
597: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
598: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
599: PO_LOG.stmt(d_mod,0,'x_result_type',x_result_type);
600: END IF;
601:
594: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
595:
596: IF PO_LOG.d_stmt THEN
597: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
598: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
599: PO_LOG.stmt(d_mod,0,'x_result_type',x_result_type);
600: END IF;
601:
602: IF (l_profile_value = 'Y') THEN
595:
596: IF PO_LOG.d_stmt THEN
597: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
598: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
599: PO_LOG.stmt(d_mod,0,'x_result_type',x_result_type);
600: END IF;
601:
602: IF (l_profile_value = 'Y') THEN
603:
650: IF(SQL%ROWCOUNT > 0) THEN
651: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
652: END IF;
653:
654: IF PO_LOG.d_proc THEN
655: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
656: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
657: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
658: PO_LOG.proc_end(p_calling_module);
652: END IF;
653:
654: IF PO_LOG.d_proc THEN
655: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
656: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
657: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
658: PO_LOG.proc_end(p_calling_module);
659: END IF;
660:
653:
654: IF PO_LOG.d_proc THEN
655: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
656: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
657: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
658: PO_LOG.proc_end(p_calling_module);
659: END IF;
660:
661: END IF;
654: IF PO_LOG.d_proc THEN
655: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
656: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
657: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
658: PO_LOG.proc_end(p_calling_module);
659: END IF;
660:
661: END IF;
662: END LOOP;
664: END IF;
665:
666: EXCEPTION
667: WHEN OTHERS THEN
668: IF PO_LOG.d_exc THEN
669: PO_LOG.exc(d_mod,0,NULL);
670: PO_LOG.exc(p_calling_module,0,NULL);
671: END IF;
672: RAISE;
665:
666: EXCEPTION
667: WHEN OTHERS THEN
668: IF PO_LOG.d_exc THEN
669: PO_LOG.exc(d_mod,0,NULL);
670: PO_LOG.exc(p_calling_module,0,NULL);
671: END IF;
672: RAISE;
673:
666: EXCEPTION
667: WHEN OTHERS THEN
668: IF PO_LOG.d_exc THEN
669: PO_LOG.exc(d_mod,0,NULL);
670: PO_LOG.exc(p_calling_module,0,NULL);
671: END IF;
672: RAISE;
673:
674: END open_period;
727: l_token2_value_tbl PO_TBL_VARCHAR4000;
728:
729: BEGIN
730:
731: IF PO_LOG.d_proc THEN
732: PO_LOG.proc_begin(p_calling_module);
733: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
734: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
735: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
728:
729: BEGIN
730:
731: IF PO_LOG.d_proc THEN
732: PO_LOG.proc_begin(p_calling_module);
733: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
734: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
735: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
736: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
729: BEGIN
730:
731: IF PO_LOG.d_proc THEN
732: PO_LOG.proc_begin(p_calling_module);
733: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
734: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
735: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
736: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
737: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
730:
731: IF PO_LOG.d_proc THEN
732: PO_LOG.proc_begin(p_calling_module);
733: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
734: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
735: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
736: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
737: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
738: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
731: IF PO_LOG.d_proc THEN
732: PO_LOG.proc_begin(p_calling_module);
733: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
734: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
735: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
736: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
737: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
738: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
739: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
732: PO_LOG.proc_begin(p_calling_module);
733: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
734: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
735: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
736: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
737: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
738: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
739: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
740: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
733: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
734: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
735: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
736: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
737: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
738: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
739: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
740: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
741: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
734: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
735: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
736: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
737: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
738: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
739: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
740: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
741: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
742: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
735: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
736: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
737: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
738: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
739: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
740: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
741: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
742: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
743: END IF;
736: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
737: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
738: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
739: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
740: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
741: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
742: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
743: END IF;
744:
737: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
738: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
739: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
740: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
741: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
742: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
743: END IF;
744:
745: IF (x_results IS NULL) THEN
738: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
739: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
740: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
741: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
742: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
743: END IF;
744:
745: IF (x_results IS NULL) THEN
746: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
754: END IF;
755:
756: l_results_count := x_results.result_type.COUNT;
757:
758: IF PO_LOG.d_stmt THEN
759: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
760: END IF;
761:
762: FOR i IN 1 .. p_value_tbl.COUNT LOOP
755:
756: l_results_count := x_results.result_type.COUNT;
757:
758: IF PO_LOG.d_stmt THEN
759: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
760: END IF;
761:
762: FOR i IN 1 .. p_value_tbl.COUNT LOOP
763: IF (p_value_tbl(i) IS NULL) THEN
780: ELSE
781: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
782: END IF;
783:
784: IF PO_LOG.d_proc THEN
785: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
786: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
787: PO_LOG.proc_end(p_calling_module);
788: END IF;
781: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
782: END IF;
783:
784: IF PO_LOG.d_proc THEN
785: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
786: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
787: PO_LOG.proc_end(p_calling_module);
788: END IF;
789:
782: END IF;
783:
784: IF PO_LOG.d_proc THEN
785: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
786: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
787: PO_LOG.proc_end(p_calling_module);
788: END IF;
789:
790: EXCEPTION
783:
784: IF PO_LOG.d_proc THEN
785: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
786: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
787: PO_LOG.proc_end(p_calling_module);
788: END IF;
789:
790: EXCEPTION
791: WHEN OTHERS THEN
788: END IF;
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: IF PO_LOG.d_exc THEN
793: PO_LOG.exc(d_mod,0,NULL);
794: PO_LOG.exc(p_calling_module,0,NULL);
795: END IF;
796: RAISE;
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: IF PO_LOG.d_exc THEN
793: PO_LOG.exc(d_mod,0,NULL);
794: PO_LOG.exc(p_calling_module,0,NULL);
795: END IF;
796: RAISE;
797:
790: EXCEPTION
791: WHEN OTHERS THEN
792: IF PO_LOG.d_exc THEN
793: PO_LOG.exc(d_mod,0,NULL);
794: PO_LOG.exc(p_calling_module,0,NULL);
795: END IF;
796: RAISE;
797:
798: END not_null;
847: l_token2_value_tbl PO_TBL_VARCHAR4000;
848:
849: BEGIN
850:
851: IF PO_LOG.d_proc THEN
852: PO_LOG.proc_begin(p_calling_module);
853: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
854: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
855: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
848:
849: BEGIN
850:
851: IF PO_LOG.d_proc THEN
852: PO_LOG.proc_begin(p_calling_module);
853: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
854: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
855: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
856: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
849: BEGIN
850:
851: IF PO_LOG.d_proc THEN
852: PO_LOG.proc_begin(p_calling_module);
853: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
854: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
855: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
856: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
857: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
850:
851: IF PO_LOG.d_proc THEN
852: PO_LOG.proc_begin(p_calling_module);
853: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
854: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
855: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
856: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
857: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
858: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
851: IF PO_LOG.d_proc THEN
852: PO_LOG.proc_begin(p_calling_module);
853: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
854: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
855: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
856: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
857: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
858: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
859: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
852: PO_LOG.proc_begin(p_calling_module);
853: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
854: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
855: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
856: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
857: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
858: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
859: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
860: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
853: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
854: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
855: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
856: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
857: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
858: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
859: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
860: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
861: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
854: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
855: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
856: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
857: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
858: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
859: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
860: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
861: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
862: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
855: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
856: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
857: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
858: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
859: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
860: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
861: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
862: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
863: END IF;
856: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
857: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
858: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
859: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
860: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
861: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
862: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
863: END IF;
864:
857: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
858: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
859: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
860: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
861: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
862: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
863: END IF;
864:
865: IF (x_results IS NULL) THEN
858: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
859: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
860: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
861: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
862: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
863: END IF;
864:
865: IF (x_results IS NULL) THEN
866: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
874: END IF;
875:
876: l_results_count := x_results.result_type.COUNT;
877:
878: IF PO_LOG.d_stmt THEN
879: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
880: END IF;
881:
882: FOR i IN 1 .. p_value_tbl.COUNT LOOP
875:
876: l_results_count := x_results.result_type.COUNT;
877:
878: IF PO_LOG.d_stmt THEN
879: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
880: END IF;
881:
882: FOR i IN 1 .. p_value_tbl.COUNT LOOP
883: IF (p_value_tbl(i) IS NOT NULL) THEN
899: ELSE
900: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
901: END IF;
902:
903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
905: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
906: PO_LOG.proc_end(p_calling_module);
907: END IF;
900: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
901: END IF;
902:
903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
905: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
906: PO_LOG.proc_end(p_calling_module);
907: END IF;
908:
901: END IF;
902:
903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
905: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
906: PO_LOG.proc_end(p_calling_module);
907: END IF;
908:
909: EXCEPTION
902:
903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
905: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
906: PO_LOG.proc_end(p_calling_module);
907: END IF;
908:
909: EXCEPTION
910: WHEN OTHERS THEN
907: END IF;
908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: IF PO_LOG.d_exc THEN
912: PO_LOG.exc(d_mod, 0, NULL);
913: PO_LOG.exc(p_calling_module, 0, NULL);
914: END IF;
915: RAISE;
908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: IF PO_LOG.d_exc THEN
912: PO_LOG.exc(d_mod, 0, NULL);
913: PO_LOG.exc(p_calling_module, 0, NULL);
914: END IF;
915: RAISE;
916:
909: EXCEPTION
910: WHEN OTHERS THEN
911: IF PO_LOG.d_exc THEN
912: PO_LOG.exc(d_mod, 0, NULL);
913: PO_LOG.exc(p_calling_module, 0, NULL);
914: END IF;
915: RAISE;
916:
917: END ensure_null;
966: l_token2_value_tbl PO_TBL_VARCHAR4000;
967:
968: BEGIN
969:
970: IF PO_LOG.d_proc THEN
971: PO_LOG.proc_begin(p_calling_module);
972: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
973: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
974: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
967:
968: BEGIN
969:
970: IF PO_LOG.d_proc THEN
971: PO_LOG.proc_begin(p_calling_module);
972: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
973: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
974: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
975: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
968: BEGIN
969:
970: IF PO_LOG.d_proc THEN
971: PO_LOG.proc_begin(p_calling_module);
972: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
973: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
974: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
975: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
976: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
969:
970: IF PO_LOG.d_proc THEN
971: PO_LOG.proc_begin(p_calling_module);
972: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
973: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
974: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
975: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
976: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
977: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
970: IF PO_LOG.d_proc THEN
971: PO_LOG.proc_begin(p_calling_module);
972: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
973: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
974: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
975: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
976: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
977: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
978: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
971: PO_LOG.proc_begin(p_calling_module);
972: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
973: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
974: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
975: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
976: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
977: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
978: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
979: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
972: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
973: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
974: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
975: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
976: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
977: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
978: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
979: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
980: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
973: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
974: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
975: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
976: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
977: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
978: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
979: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
980: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
981: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
974: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
975: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
976: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
977: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
978: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
979: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
980: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
981: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
982: END IF;
975: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
976: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
977: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
978: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
979: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
980: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
981: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
982: END IF;
983:
976: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
977: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
978: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
979: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
980: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
981: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
982: END IF;
983:
984: IF (x_results IS NULL) THEN
977: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
978: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
979: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
980: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
981: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
982: END IF;
983:
984: IF (x_results IS NULL) THEN
985: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
993: END IF;
994:
995: l_results_count := x_results.result_type.COUNT;
996:
997: IF PO_LOG.d_stmt THEN
998: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
999: END IF;
1000:
1001: FOR i IN 1 .. p_flag_value_tbl.COUNT LOOP
994:
995: l_results_count := x_results.result_type.COUNT;
996:
997: IF PO_LOG.d_stmt THEN
998: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
999: END IF;
1000:
1001: FOR i IN 1 .. p_flag_value_tbl.COUNT LOOP
1002: IF (p_flag_value_tbl(i) NOT IN ('Y', 'N')) THEN
1018: ELSE
1019: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1020: END IF;
1021:
1022: IF PO_LOG.d_proc THEN
1023: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
1024: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
1025: PO_LOG.proc_end(p_calling_module);
1026: END IF;
1019: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1020: END IF;
1021:
1022: IF PO_LOG.d_proc THEN
1023: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
1024: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
1025: PO_LOG.proc_end(p_calling_module);
1026: END IF;
1027:
1020: END IF;
1021:
1022: IF PO_LOG.d_proc THEN
1023: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
1024: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
1025: PO_LOG.proc_end(p_calling_module);
1026: END IF;
1027:
1028: EXCEPTION
1021:
1022: IF PO_LOG.d_proc THEN
1023: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
1024: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
1025: PO_LOG.proc_end(p_calling_module);
1026: END IF;
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1026: END IF;
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: IF PO_LOG.d_exc THEN
1031: PO_LOG.exc(d_mod, 0, NULL);
1032: PO_LOG.exc(p_calling_module, 0, NULL);
1033: END IF;
1034: RAISE;
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: IF PO_LOG.d_exc THEN
1031: PO_LOG.exc(d_mod, 0, NULL);
1032: PO_LOG.exc(p_calling_module, 0, NULL);
1033: END IF;
1034: RAISE;
1035:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: IF PO_LOG.d_exc THEN
1031: PO_LOG.exc(d_mod, 0, NULL);
1032: PO_LOG.exc(p_calling_module, 0, NULL);
1033: END IF;
1034: RAISE;
1035:
1036: END flag_value_Y_N;
1097: l_value_tbl PO_TBL_NUMBER;
1098:
1099: BEGIN
1100:
1101: IF PO_LOG.d_proc THEN
1102: PO_LOG.proc_begin(p_calling_module);
1103: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1104: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1105: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1098:
1099: BEGIN
1100:
1101: IF PO_LOG.d_proc THEN
1102: PO_LOG.proc_begin(p_calling_module);
1103: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1104: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1105: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1106: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1099: BEGIN
1100:
1101: IF PO_LOG.d_proc THEN
1102: PO_LOG.proc_begin(p_calling_module);
1103: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1104: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1105: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1106: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1107: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1100:
1101: IF PO_LOG.d_proc THEN
1102: PO_LOG.proc_begin(p_calling_module);
1103: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1104: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1105: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1106: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1107: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1108: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1101: IF PO_LOG.d_proc THEN
1102: PO_LOG.proc_begin(p_calling_module);
1103: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1104: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1105: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1106: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1107: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1108: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1109: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1102: PO_LOG.proc_begin(p_calling_module);
1103: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1104: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1105: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1106: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1107: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1108: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1109: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1110: END IF;
1103: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1104: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1105: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1106: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1107: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1108: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1109: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1110: END IF;
1111:
1104: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1105: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1106: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1107: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1108: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1109: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1110: END IF;
1111:
1112: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN
1105: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1106: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1107: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1108: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1109: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1110: END IF;
1111:
1112: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN
1113: l_keep_quantity := TRUE;
1150: , x_results => x_results
1151: , x_result_type => x_result_type
1152: );
1153:
1154: IF PO_LOG.d_proc THEN
1155: PO_LOG.proc_end(d_mod);
1156: PO_LOG.proc_end(p_calling_module);
1157: END IF;
1158:
1151: , x_result_type => x_result_type
1152: );
1153:
1154: IF PO_LOG.d_proc THEN
1155: PO_LOG.proc_end(d_mod);
1156: PO_LOG.proc_end(p_calling_module);
1157: END IF;
1158:
1159: EXCEPTION
1152: );
1153:
1154: IF PO_LOG.d_proc THEN
1155: PO_LOG.proc_end(d_mod);
1156: PO_LOG.proc_end(p_calling_module);
1157: END IF;
1158:
1159: EXCEPTION
1160: WHEN OTHERS THEN
1157: END IF;
1158:
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: IF PO_LOG.d_exc THEN
1162: PO_LOG.exc(d_mod,0,NULL);
1163: PO_LOG.exc(p_calling_module,0,NULL);
1164: END IF;
1165: RAISE;
1158:
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: IF PO_LOG.d_exc THEN
1162: PO_LOG.exc(d_mod,0,NULL);
1163: PO_LOG.exc(p_calling_module,0,NULL);
1164: END IF;
1165: RAISE;
1166:
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: IF PO_LOG.d_exc THEN
1162: PO_LOG.exc(d_mod,0,NULL);
1163: PO_LOG.exc(p_calling_module,0,NULL);
1164: END IF;
1165: RAISE;
1166:
1167: END gt_zero_order_type_filter;
1232: l_return_status VARCHAR2(10);
1233:
1234: BEGIN
1235:
1236: IF PO_LOG.d_proc THEN
1237: PO_LOG.proc_begin(p_calling_module);
1238: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1239: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1233:
1234: BEGIN
1235:
1236: IF PO_LOG.d_proc THEN
1237: PO_LOG.proc_begin(p_calling_module);
1238: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1239: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1234: BEGIN
1235:
1236: IF PO_LOG.d_proc THEN
1237: PO_LOG.proc_begin(p_calling_module);
1238: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1239: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1242: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1235:
1236: IF PO_LOG.d_proc THEN
1237: PO_LOG.proc_begin(p_calling_module);
1238: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1239: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1242: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1243: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1236: IF PO_LOG.d_proc THEN
1237: PO_LOG.proc_begin(p_calling_module);
1238: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1239: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1242: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1243: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1244: END IF;
1237: PO_LOG.proc_begin(p_calling_module);
1238: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1239: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1242: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1243: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1244: END IF;
1245:
1238: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1239: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1242: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1243: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1244: END IF;
1245:
1246: IF (x_results IS NULL) THEN
1239: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1240: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1241: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1242: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1243: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1244: END IF;
1245:
1246: IF (x_results IS NULL) THEN
1247: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1311: AND HEADER.type_lookup_code = c_STANDARD
1312: AND LINE.order_type_lookup_code = c_RATE
1313: ;
1314:
1315: IF PO_LOG.d_stmt THEN
1316: PO_LOG.stmt(d_mod,50,'l_line_id_tbl',l_line_id_tbl);
1317: END IF;
1318:
1319: FOR i IN 1 .. l_line_id_tbl.COUNT LOOP
1312: AND LINE.order_type_lookup_code = c_RATE
1313: ;
1314:
1315: IF PO_LOG.d_stmt THEN
1316: PO_LOG.stmt(d_mod,50,'l_line_id_tbl',l_line_id_tbl);
1317: END IF;
1318:
1319: FOR i IN 1 .. l_line_id_tbl.COUNT LOOP
1320:
1351: ELSE
1352: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1353: END IF;
1354:
1355: IF PO_LOG.d_proc THEN
1356: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1357: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1358: PO_LOG.proc_end(p_calling_module);
1359: END IF;
1352: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1353: END IF;
1354:
1355: IF PO_LOG.d_proc THEN
1356: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1357: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1358: PO_LOG.proc_end(p_calling_module);
1359: END IF;
1360:
1353: END IF;
1354:
1355: IF PO_LOG.d_proc THEN
1356: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1357: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1358: PO_LOG.proc_end(p_calling_module);
1359: END IF;
1360:
1361: EXCEPTION
1354:
1355: IF PO_LOG.d_proc THEN
1356: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1357: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1358: PO_LOG.proc_end(p_calling_module);
1359: END IF;
1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1359: END IF;
1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: IF PO_LOG.d_exc THEN
1364: PO_LOG.exc(d_mod,0,NULL);
1365: PO_LOG.exc(p_calling_module,0,NULL);
1366: END IF;
1367: RAISE;
1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: IF PO_LOG.d_exc THEN
1364: PO_LOG.exc(d_mod,0,NULL);
1365: PO_LOG.exc(p_calling_module,0,NULL);
1366: END IF;
1367: RAISE;
1368:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: IF PO_LOG.d_exc THEN
1364: PO_LOG.exc(d_mod,0,NULL);
1365: PO_LOG.exc(p_calling_module,0,NULL);
1366: END IF;
1367: RAISE;
1368:
1369: END no_timecards_exist;
1416: l_quantity_flag VARCHAR2(1);
1417: l_quantity_tbl PO_TBL_NUMBER;
1418: BEGIN
1419:
1420: IF PO_LOG.d_proc THEN
1421: PO_LOG.proc_begin(p_calling_module);
1422: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1423: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1424: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1417: l_quantity_tbl PO_TBL_NUMBER;
1418: BEGIN
1419:
1420: IF PO_LOG.d_proc THEN
1421: PO_LOG.proc_begin(p_calling_module);
1422: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1423: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1424: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1425: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1418: BEGIN
1419:
1420: IF PO_LOG.d_proc THEN
1421: PO_LOG.proc_begin(p_calling_module);
1422: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1423: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1424: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1425: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1426: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1419:
1420: IF PO_LOG.d_proc THEN
1421: PO_LOG.proc_begin(p_calling_module);
1422: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1423: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1424: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1425: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1426: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1427: END IF;
1420: IF PO_LOG.d_proc THEN
1421: PO_LOG.proc_begin(p_calling_module);
1422: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1423: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1424: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1425: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1426: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1427: END IF;
1428:
1421: PO_LOG.proc_begin(p_calling_module);
1422: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1423: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1424: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1425: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1426: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1427: END IF;
1428:
1429: IF (x_result_set_id IS NULL) THEN
1422: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1423: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1424: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1425: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1426: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1427: END IF;
1428:
1429: IF (x_result_set_id IS NULL) THEN
1430: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1481: ELSE
1482: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1483: END IF;
1484:
1485: IF PO_LOG.d_proc THEN
1486: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1487: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1488: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1489: PO_LOG.proc_end(p_calling_module);
1483: END IF;
1484:
1485: IF PO_LOG.d_proc THEN
1486: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1487: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1488: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1489: PO_LOG.proc_end(p_calling_module);
1490: END IF;
1491:
1484:
1485: IF PO_LOG.d_proc THEN
1486: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1487: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1488: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1489: PO_LOG.proc_end(p_calling_module);
1490: END IF;
1491:
1492: EXCEPTION
1485: IF PO_LOG.d_proc THEN
1486: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1487: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1488: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1489: PO_LOG.proc_end(p_calling_module);
1490: END IF;
1491:
1492: EXCEPTION
1493: WHEN OTHERS THEN
1490: END IF;
1491:
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: IF PO_LOG.d_exc THEN
1495: PO_LOG.exc(d_mod,0,NULL);
1496: PO_LOG.exc(p_calling_module,0,NULL);
1497: END IF;
1498: RAISE;
1491:
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: IF PO_LOG.d_exc THEN
1495: PO_LOG.exc(d_mod,0,NULL);
1496: PO_LOG.exc(p_calling_module,0,NULL);
1497: END IF;
1498: RAISE;
1499:
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: IF PO_LOG.d_exc THEN
1495: PO_LOG.exc(d_mod,0,NULL);
1496: PO_LOG.exc(p_calling_module,0,NULL);
1497: END IF;
1498: RAISE;
1499:
1500: END amount_notif_ctrl_warning;
1539: l_message_name VARCHAR2(30);
1540:
1541: BEGIN
1542:
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(p_calling_module);
1545: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1546: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1547: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1540:
1541: BEGIN
1542:
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(p_calling_module);
1545: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1546: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1547: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1548: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1541: BEGIN
1542:
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(p_calling_module);
1545: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1546: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1547: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1548: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1549: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1542:
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(p_calling_module);
1545: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1546: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1547: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1548: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1549: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1550: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1543: IF PO_LOG.d_proc THEN
1544: PO_LOG.proc_begin(p_calling_module);
1545: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1546: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1547: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1548: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1549: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1550: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1551: END IF;
1544: PO_LOG.proc_begin(p_calling_module);
1545: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1546: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1547: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1548: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1549: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1550: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1551: END IF;
1552:
1545: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1546: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1547: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1548: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1549: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1550: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1551: END IF;
1552:
1553: IF (x_result_set_id IS NULL) THEN
1546: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1547: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1548: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1549: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1550: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1551: END IF;
1552:
1553: IF (x_result_set_id IS NULL) THEN
1554: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1761: ELSE
1762: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1763: END IF;
1764:
1765: IF PO_LOG.d_proc THEN
1766: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1767: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1768: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1769: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1762: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1763: END IF;
1764:
1765: IF PO_LOG.d_proc THEN
1766: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1767: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1768: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1769: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1770: PO_LOG.proc_end(p_calling_module);
1764:
1765: IF PO_LOG.d_proc THEN
1766: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1767: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1768: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1769: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1770: PO_LOG.proc_end(p_calling_module);
1771: END IF;
1772:
1765: IF PO_LOG.d_proc THEN
1766: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1767: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1768: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1769: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1770: PO_LOG.proc_end(p_calling_module);
1771: END IF;
1772:
1773: EXCEPTION
1766: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1767: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1768: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1769: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1770: PO_LOG.proc_end(p_calling_module);
1771: END IF;
1772:
1773: EXCEPTION
1774: WHEN OTHERS THEN
1771: END IF;
1772:
1773: EXCEPTION
1774: WHEN OTHERS THEN
1775: IF PO_LOG.d_exc THEN
1776: PO_LOG.exc(d_mod,0,NULL);
1777: PO_LOG.exc(p_calling_module,0,NULL);
1778: END IF;
1779: RAISE;
1772:
1773: EXCEPTION
1774: WHEN OTHERS THEN
1775: IF PO_LOG.d_exc THEN
1776: PO_LOG.exc(d_mod,0,NULL);
1777: PO_LOG.exc(p_calling_module,0,NULL);
1778: END IF;
1779: RAISE;
1780:
1773: EXCEPTION
1774: WHEN OTHERS THEN
1775: IF PO_LOG.d_exc THEN
1776: PO_LOG.exc(d_mod,0,NULL);
1777: PO_LOG.exc(p_calling_module,0,NULL);
1778: END IF;
1779: RAISE;
1780:
1781: END child_num_unique;
1807: l_parent_id_tbl PO_TBL_NUMBER;
1808:
1809: BEGIN
1810:
1811: IF PO_LOG.d_proc THEN
1812: PO_LOG.proc_begin(p_calling_module);
1813: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_tbl);
1814: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1815: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1808:
1809: BEGIN
1810:
1811: IF PO_LOG.d_proc THEN
1812: PO_LOG.proc_begin(p_calling_module);
1813: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_tbl);
1814: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1815: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1816: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
1809: BEGIN
1810:
1811: IF PO_LOG.d_proc THEN
1812: PO_LOG.proc_begin(p_calling_module);
1813: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_tbl);
1814: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1815: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1816: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
1817: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1810:
1811: IF PO_LOG.d_proc THEN
1812: PO_LOG.proc_begin(p_calling_module);
1813: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_tbl);
1814: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1815: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1816: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
1817: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1818: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1811: IF PO_LOG.d_proc THEN
1812: PO_LOG.proc_begin(p_calling_module);
1813: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_tbl);
1814: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1815: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1816: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
1817: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1818: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1819: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1812: PO_LOG.proc_begin(p_calling_module);
1813: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_tbl);
1814: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1815: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1816: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
1817: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1818: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1819: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1820: END IF;
1813: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_tbl);
1814: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1815: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1816: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
1817: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1818: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1819: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1820: END IF;
1821:
1814: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1815: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1816: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
1817: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1818: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1819: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1820: END IF;
1821:
1822: IF (x_result_set_id IS NULL) THEN
1815: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1816: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
1817: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1818: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1819: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1820: END IF;
1821:
1822: IF (x_result_set_id IS NULL) THEN
1823: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1942: ELSE
1943: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1944: END IF;
1945:
1946: IF PO_LOG.d_proc THEN
1947: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1948: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1949: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1950: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1943: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1944: END IF;
1945:
1946: IF PO_LOG.d_proc THEN
1947: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1948: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1949: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1950: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1951: PO_LOG.proc_end(p_calling_module);
1945:
1946: IF PO_LOG.d_proc THEN
1947: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1948: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1949: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1950: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1951: PO_LOG.proc_end(p_calling_module);
1952: END IF;
1953:
1946: IF PO_LOG.d_proc THEN
1947: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1948: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1949: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1950: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1951: PO_LOG.proc_end(p_calling_module);
1952: END IF;
1953:
1954: EXCEPTION
1947: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1948: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1949: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1950: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1951: PO_LOG.proc_end(p_calling_module);
1952: END IF;
1953:
1954: EXCEPTION
1955: WHEN OTHERS THEN
1952: END IF;
1953:
1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: IF PO_LOG.d_exc THEN
1957: PO_LOG.exc(d_mod,0,NULL);
1958: PO_LOG.exc(p_calling_module,0,NULL);
1959: END IF;
1960: RAISE;
1953:
1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: IF PO_LOG.d_exc THEN
1957: PO_LOG.exc(d_mod,0,NULL);
1958: PO_LOG.exc(p_calling_module,0,NULL);
1959: END IF;
1960: RAISE;
1961:
1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: IF PO_LOG.d_exc THEN
1957: PO_LOG.exc(d_mod,0,NULL);
1958: PO_LOG.exc(p_calling_module,0,NULL);
1959: END IF;
1960: RAISE;
1961:
1962: END price_diff_value_unique;
1991: l_results_count NUMBER;
1992: l_column_val DATE;
1993: BEGIN
1994:
1995: IF PO_LOG.d_proc THEN
1996: PO_LOG.proc_begin(p_calling_module);
1997: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1998: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1992: l_column_val DATE;
1993: BEGIN
1994:
1995: IF PO_LOG.d_proc THEN
1996: PO_LOG.proc_begin(p_calling_module);
1997: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1998: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1993: BEGIN
1994:
1995: IF PO_LOG.d_proc THEN
1996: PO_LOG.proc_begin(p_calling_module);
1997: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1998: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2001: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1994:
1995: IF PO_LOG.d_proc THEN
1996: PO_LOG.proc_begin(p_calling_module);
1997: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1998: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2001: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2002: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
1995: IF PO_LOG.d_proc THEN
1996: PO_LOG.proc_begin(p_calling_module);
1997: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1998: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2001: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2002: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1996: PO_LOG.proc_begin(p_calling_module);
1997: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1998: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2001: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2002: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1997: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1998: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2001: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2002: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2005: END IF;
1998: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2001: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2002: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2005: END IF;
2006:
1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2001: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2002: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2005: END IF;
2006:
2007: IF (x_results IS NULL) THEN
2000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2001: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2002: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2005: END IF;
2006:
2007: IF (x_results IS NULL) THEN
2008: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2038: ELSE
2039: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2040: END IF;
2041:
2042: IF PO_LOG.d_proc THEN
2043: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2044: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2045: PO_LOG.proc_end(p_calling_module);
2046: END IF;
2039: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2040: END IF;
2041:
2042: IF PO_LOG.d_proc THEN
2043: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2044: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2045: PO_LOG.proc_end(p_calling_module);
2046: END IF;
2047:
2040: END IF;
2041:
2042: IF PO_LOG.d_proc THEN
2043: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2044: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2045: PO_LOG.proc_end(p_calling_module);
2046: END IF;
2047:
2048: EXCEPTION
2041:
2042: IF PO_LOG.d_proc THEN
2043: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2044: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2045: PO_LOG.proc_end(p_calling_module);
2046: END IF;
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2046: END IF;
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: IF PO_LOG.d_exc THEN
2051: PO_LOG.exc(d_mod,0,NULL);
2052: PO_LOG.exc(p_calling_module,0,NULL);
2053: END IF;
2054: RAISE;
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: IF PO_LOG.d_exc THEN
2051: PO_LOG.exc(d_mod,0,NULL);
2052: PO_LOG.exc(p_calling_module,0,NULL);
2053: END IF;
2054: RAISE;
2055:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: IF PO_LOG.d_exc THEN
2051: PO_LOG.exc(d_mod,0,NULL);
2052: PO_LOG.exc(p_calling_module,0,NULL);
2053: END IF;
2054: RAISE;
2055:
2056: END start_date_le_end_date;
2074: d_mod CONSTANT VARCHAR2(100) := D_num1_less_or_equal_num2;
2075: l_results_count NUMBER;
2076: BEGIN
2077:
2078: IF PO_LOG.d_proc THEN
2079: PO_LOG.proc_begin(p_calling_module);
2080: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2081: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2082: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2075: l_results_count NUMBER;
2076: BEGIN
2077:
2078: IF PO_LOG.d_proc THEN
2079: PO_LOG.proc_begin(p_calling_module);
2080: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2081: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2082: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2083: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2076: BEGIN
2077:
2078: IF PO_LOG.d_proc THEN
2079: PO_LOG.proc_begin(p_calling_module);
2080: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2081: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2082: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2083: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2084: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2077:
2078: IF PO_LOG.d_proc THEN
2079: PO_LOG.proc_begin(p_calling_module);
2080: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2081: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2082: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2083: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2084: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2085: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2078: IF PO_LOG.d_proc THEN
2079: PO_LOG.proc_begin(p_calling_module);
2080: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2081: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2082: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2083: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2084: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2085: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2086: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2079: PO_LOG.proc_begin(p_calling_module);
2080: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2081: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2082: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2083: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2084: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2085: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2086: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2087: END IF;
2080: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2081: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2082: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2083: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2084: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2085: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2086: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2087: END IF;
2088:
2081: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2082: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2083: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2084: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2085: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2086: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2087: END IF;
2088:
2089: IF (x_results IS NULL) THEN
2082: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2083: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2084: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2085: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2086: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2087: END IF;
2088:
2089: IF (x_results IS NULL) THEN
2090: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2108: ELSE
2109: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2110: END IF;
2111:
2112: IF PO_LOG.d_proc THEN
2113: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2114: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2115: PO_LOG.proc_end(p_calling_module);
2116: END IF;
2109: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2110: END IF;
2111:
2112: IF PO_LOG.d_proc THEN
2113: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2114: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2115: PO_LOG.proc_end(p_calling_module);
2116: END IF;
2117:
2110: END IF;
2111:
2112: IF PO_LOG.d_proc THEN
2113: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2114: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2115: PO_LOG.proc_end(p_calling_module);
2116: END IF;
2117:
2118: EXCEPTION
2111:
2112: IF PO_LOG.d_proc THEN
2113: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2114: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2115: PO_LOG.proc_end(p_calling_module);
2116: END IF;
2117:
2118: EXCEPTION
2119: WHEN OTHERS THEN
2116: END IF;
2117:
2118: EXCEPTION
2119: WHEN OTHERS THEN
2120: IF PO_LOG.d_exc THEN
2121: PO_LOG.exc(d_mod,0,NULL);
2122: PO_LOG.exc(p_calling_module,0,NULL);
2123: END IF;
2124: RAISE;
2117:
2118: EXCEPTION
2119: WHEN OTHERS THEN
2120: IF PO_LOG.d_exc THEN
2121: PO_LOG.exc(d_mod,0,NULL);
2122: PO_LOG.exc(p_calling_module,0,NULL);
2123: END IF;
2124: RAISE;
2125:
2118: EXCEPTION
2119: WHEN OTHERS THEN
2120: IF PO_LOG.d_exc THEN
2121: PO_LOG.exc(d_mod,0,NULL);
2122: PO_LOG.exc(p_calling_module,0,NULL);
2123: END IF;
2124: RAISE;
2125:
2126: END num1_less_or_equal_num2;
2176: l_token2_value_tbl PO_TBL_VARCHAR4000;
2177:
2178: BEGIN
2179:
2180: IF PO_LOG.d_proc THEN
2181: PO_LOG.proc_begin(p_calling_module);
2182: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2183: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2184: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2177:
2178: BEGIN
2179:
2180: IF PO_LOG.d_proc THEN
2181: PO_LOG.proc_begin(p_calling_module);
2182: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2183: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2184: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2185: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2178: BEGIN
2179:
2180: IF PO_LOG.d_proc THEN
2181: PO_LOG.proc_begin(p_calling_module);
2182: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2183: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2184: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2185: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2186: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2179:
2180: IF PO_LOG.d_proc THEN
2181: PO_LOG.proc_begin(p_calling_module);
2182: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2183: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2184: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2185: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2186: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2187: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2180: IF PO_LOG.d_proc THEN
2181: PO_LOG.proc_begin(p_calling_module);
2182: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2183: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2184: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2185: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2186: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2187: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2188: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2181: PO_LOG.proc_begin(p_calling_module);
2182: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2183: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2184: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2185: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2186: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2187: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2188: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2189: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2182: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2183: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2184: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2185: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2186: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2187: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2188: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2189: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2190: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2183: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2184: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2185: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2186: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2187: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2188: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2189: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2190: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2191: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2184: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2185: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2186: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2187: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2188: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2189: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2190: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2191: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2192: END IF;
2185: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2186: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2187: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2188: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2189: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2190: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2191: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2192: END IF;
2193:
2186: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2187: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2188: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2189: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2190: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2191: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2192: END IF;
2193:
2194: IF (x_results IS NULL) THEN
2187: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2188: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2189: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2190: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2191: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2192: END IF;
2193:
2194: IF (x_results IS NULL) THEN
2195: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2203: END IF;
2204:
2205: l_results_count := x_results.result_type.COUNT;
2206:
2207: IF PO_LOG.d_stmt THEN
2208: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
2209: END IF;
2210:
2211: FOR i IN 1 .. p_value_tbl.COUNT LOOP
2204:
2205: l_results_count := x_results.result_type.COUNT;
2206:
2207: IF PO_LOG.d_stmt THEN
2208: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
2209: END IF;
2210:
2211: FOR i IN 1 .. p_value_tbl.COUNT LOOP
2212: IF (p_value_tbl(i) <> 0) THEN
2228: ELSE
2229: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2230: END IF;
2231:
2232: IF PO_LOG.d_proc THEN
2233: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2234: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
2235: PO_LOG.proc_end(p_calling_module);
2236: END IF;
2229: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2230: END IF;
2231:
2232: IF PO_LOG.d_proc THEN
2233: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2234: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
2235: PO_LOG.proc_end(p_calling_module);
2236: END IF;
2237:
2230: END IF;
2231:
2232: IF PO_LOG.d_proc THEN
2233: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2234: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
2235: PO_LOG.proc_end(p_calling_module);
2236: END IF;
2237:
2238: EXCEPTION
2231:
2232: IF PO_LOG.d_proc THEN
2233: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2234: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
2235: PO_LOG.proc_end(p_calling_module);
2236: END IF;
2237:
2238: EXCEPTION
2239: WHEN OTHERS THEN
2236: END IF;
2237:
2238: EXCEPTION
2239: WHEN OTHERS THEN
2240: IF PO_LOG.d_exc THEN
2241: PO_LOG.exc(d_mod, 0, NULL);
2242: PO_LOG.exc(p_calling_module, 0, NULL);
2243: END IF;
2244: RAISE;
2237:
2238: EXCEPTION
2239: WHEN OTHERS THEN
2240: IF PO_LOG.d_exc THEN
2241: PO_LOG.exc(d_mod, 0, NULL);
2242: PO_LOG.exc(p_calling_module, 0, NULL);
2243: END IF;
2244: RAISE;
2245:
2238: EXCEPTION
2239: WHEN OTHERS THEN
2240: IF PO_LOG.d_exc THEN
2241: PO_LOG.exc(d_mod, 0, NULL);
2242: PO_LOG.exc(p_calling_module, 0, NULL);
2243: END IF;
2244: RAISE;
2245:
2246: END zero;
2287: IF x_result_set_id IS NULL THEN
2288: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2289: END IF;
2290:
2291: IF PO_LOG.d_proc THEN
2292: PO_LOG.proc_begin(p_calling_module);
2293: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2294: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2295: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2288: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2289: END IF;
2290:
2291: IF PO_LOG.d_proc THEN
2292: PO_LOG.proc_begin(p_calling_module);
2293: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2294: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2295: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2296: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2289: END IF;
2290:
2291: IF PO_LOG.d_proc THEN
2292: PO_LOG.proc_begin(p_calling_module);
2293: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2294: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2295: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2296: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2297: END IF;
2290:
2291: IF PO_LOG.d_proc THEN
2292: PO_LOG.proc_begin(p_calling_module);
2293: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2294: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2295: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2296: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2297: END IF;
2298:
2291: IF PO_LOG.d_proc THEN
2292: PO_LOG.proc_begin(p_calling_module);
2293: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2294: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2295: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2296: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2297: END IF;
2298:
2299: FORALL i IN 1 .. p_entity_id_tbl.COUNT
2292: PO_LOG.proc_begin(p_calling_module);
2293: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2294: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2295: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2296: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2297: END IF;
2298:
2299: FORALL i IN 1 .. p_entity_id_tbl.COUNT
2300: INSERT INTO PO_VALIDATION_RESULTS_GT
2333: ELSE
2334: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2335: END IF;
2336:
2337: IF PO_LOG.d_proc THEN
2338: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2339: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2340: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2341: PO_LOG.proc_end(p_calling_module);
2335: END IF;
2336:
2337: IF PO_LOG.d_proc THEN
2338: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2339: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2340: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2341: PO_LOG.proc_end(p_calling_module);
2342: END IF;
2343:
2336:
2337: IF PO_LOG.d_proc THEN
2338: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2339: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2340: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2341: PO_LOG.proc_end(p_calling_module);
2342: END IF;
2343:
2344: EXCEPTION
2337: IF PO_LOG.d_proc THEN
2338: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2339: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2340: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2341: PO_LOG.proc_end(p_calling_module);
2342: END IF;
2343:
2344: EXCEPTION
2345: WHEN OTHERS THEN
2342: END IF;
2343:
2344: EXCEPTION
2345: WHEN OTHERS THEN
2346: IF PO_LOG.d_exc THEN
2347: PO_LOG.exc(d_mod, 0, NULL);
2348: PO_LOG.exc(p_calling_module, 0, NULL);
2349: END IF;
2350: RAISE;
2343:
2344: EXCEPTION
2345: WHEN OTHERS THEN
2346: IF PO_LOG.d_exc THEN
2347: PO_LOG.exc(d_mod, 0, NULL);
2348: PO_LOG.exc(p_calling_module, 0, NULL);
2349: END IF;
2350: RAISE;
2351:
2344: EXCEPTION
2345: WHEN OTHERS THEN
2346: IF PO_LOG.d_exc THEN
2347: PO_LOG.exc(d_mod, 0, NULL);
2348: PO_LOG.exc(p_calling_module, 0, NULL);
2349: END IF;
2350: RAISE;
2351:
2352: END terms_id;
2407: l_sec_default_ind VARCHAR2(1);
2408:
2409: BEGIN
2410:
2411: IF PO_LOG.d_proc THEN
2412: PO_LOG.proc_begin(p_calling_module);
2413: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2408:
2409: BEGIN
2410:
2411: IF PO_LOG.d_proc THEN
2412: PO_LOG.proc_begin(p_calling_module);
2413: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2416: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2409: BEGIN
2410:
2411: IF PO_LOG.d_proc THEN
2412: PO_LOG.proc_begin(p_calling_module);
2413: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2416: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2417: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2410:
2411: IF PO_LOG.d_proc THEN
2412: PO_LOG.proc_begin(p_calling_module);
2413: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2416: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2417: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2418: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2411: IF PO_LOG.d_proc THEN
2412: PO_LOG.proc_begin(p_calling_module);
2413: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2416: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2417: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2418: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2419: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2412: PO_LOG.proc_begin(p_calling_module);
2413: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2416: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2417: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2418: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2419: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2420: END IF;
2413: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2414: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2416: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2417: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2418: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2419: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2420: END IF;
2421:
2414: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2416: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2417: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2418: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2419: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2420: END IF;
2421:
2422: l_input_size := p_entity_id_tbl.COUNT;
2415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2416: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2417: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2418: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2419: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2420: END IF;
2421:
2422: l_input_size := p_entity_id_tbl.COUNT;
2423:
2471: , x_results => x_results
2472: , x_result_type => x_result_type
2473: );
2474:
2475: IF PO_LOG.d_proc THEN
2476: PO_LOG.proc_end(d_mod);
2477: PO_LOG.proc_end(p_calling_module);
2478: END IF;
2479:
2472: , x_result_type => x_result_type
2473: );
2474:
2475: IF PO_LOG.d_proc THEN
2476: PO_LOG.proc_end(d_mod);
2477: PO_LOG.proc_end(p_calling_module);
2478: END IF;
2479:
2480: EXCEPTION
2473: );
2474:
2475: IF PO_LOG.d_proc THEN
2476: PO_LOG.proc_end(d_mod);
2477: PO_LOG.proc_end(p_calling_module);
2478: END IF;
2479:
2480: EXCEPTION
2481: WHEN OTHERS THEN
2478: END IF;
2479:
2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: IF PO_LOG.d_exc THEN
2483: PO_LOG.exc(d_mod,0,NULL);
2484: PO_LOG.exc(p_calling_module,0,NULL);
2485: END IF;
2486: RAISE;
2479:
2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: IF PO_LOG.d_exc THEN
2483: PO_LOG.exc(d_mod,0,NULL);
2484: PO_LOG.exc(p_calling_module,0,NULL);
2485: END IF;
2486: RAISE;
2487:
2480: EXCEPTION
2481: WHEN OTHERS THEN
2482: IF PO_LOG.d_exc THEN
2483: PO_LOG.exc(d_mod,0,NULL);
2484: PO_LOG.exc(p_calling_module,0,NULL);
2485: END IF;
2486: RAISE;
2487:
2488: END gt_zero_opm_filter;
2555: l_sec_default_ind VARCHAR2(1);
2556:
2557: BEGIN
2558:
2559: IF PO_LOG.d_proc THEN
2560: PO_LOG.proc_begin(p_calling_module);
2561: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2562: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2563: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2556:
2557: BEGIN
2558:
2559: IF PO_LOG.d_proc THEN
2560: PO_LOG.proc_begin(p_calling_module);
2561: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2562: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2563: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2564: END IF;
2557: BEGIN
2558:
2559: IF PO_LOG.d_proc THEN
2560: PO_LOG.proc_begin(p_calling_module);
2561: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2562: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2563: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2564: END IF;
2565:
2558:
2559: IF PO_LOG.d_proc THEN
2560: PO_LOG.proc_begin(p_calling_module);
2561: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2562: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2563: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2564: END IF;
2565:
2566: IF (x_results IS NULL) THEN
2559: IF PO_LOG.d_proc THEN
2560: PO_LOG.proc_begin(p_calling_module);
2561: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2562: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2563: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2564: END IF;
2565:
2566: IF (x_results IS NULL) THEN
2567: 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: PO_LOG.proc_end(p_calling_module);
2638: END IF;
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: PO_LOG.proc_end(p_calling_module);
2638: END IF;
2639:
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: PO_LOG.proc_end(p_calling_module);
2638: END IF;
2639:
2640: EXCEPTION
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: PO_LOG.proc_end(p_calling_module);
2638: END IF;
2639:
2640: EXCEPTION
2641: WHEN OTHERS THEN
2638: END IF;
2639:
2640: EXCEPTION
2641: WHEN OTHERS THEN
2642: IF PO_LOG.d_exc THEN
2643: PO_LOG.exc(d_mod,0,NULL);
2644: PO_LOG.exc(p_calling_module,0,NULL);
2645: END IF;
2646: RAISE;
2639:
2640: EXCEPTION
2641: WHEN OTHERS THEN
2642: IF PO_LOG.d_exc THEN
2643: PO_LOG.exc(d_mod,0,NULL);
2644: PO_LOG.exc(p_calling_module,0,NULL);
2645: END IF;
2646: RAISE;
2647:
2640: EXCEPTION
2641: WHEN OTHERS THEN
2642: IF PO_LOG.d_exc THEN
2643: PO_LOG.exc(d_mod,0,NULL);
2644: PO_LOG.exc(p_calling_module,0,NULL);
2645: END IF;
2646: RAISE;
2647:
2648: END qtys_within_deviation;
2670: l_validation_id NUMBER;
2671:
2672: BEGIN
2673:
2674: IF PO_LOG.d_proc THEN
2675: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2676: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2677: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2678: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2671:
2672: BEGIN
2673:
2674: IF PO_LOG.d_proc THEN
2675: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2676: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2677: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2678: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2679: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2672: BEGIN
2673:
2674: IF PO_LOG.d_proc THEN
2675: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2676: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2677: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2678: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2679: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2680: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2673:
2674: IF PO_LOG.d_proc THEN
2675: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2676: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2677: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2678: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2679: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2680: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2681: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2674: IF PO_LOG.d_proc THEN
2675: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2676: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2677: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2678: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2679: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2680: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2681: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2682: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2675: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2676: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2677: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2678: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2679: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2680: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2681: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2682: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2683: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2676: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2677: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2678: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2679: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2680: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2681: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2682: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2683: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2684: END IF;
2677: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2678: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2679: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2680: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2681: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2682: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2683: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2684: END IF;
2685:
2678: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2679: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2680: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2681: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2682: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2683: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2684: END IF;
2685:
2686: IF (x_results IS NULL) THEN
2679: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2680: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2681: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2682: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2683: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2684: END IF;
2685:
2686: IF (x_results IS NULL) THEN
2687: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2768: IF (SQL%ROWCOUNT > 0) THEN
2769: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2770: END IF;
2771:
2772: IF PO_LOG.d_proc THEN
2773: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2774: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2775: END IF;
2776:
2769: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2770: END IF;
2771:
2772: IF PO_LOG.d_proc THEN
2773: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2774: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2775: END IF;
2776:
2777: EXCEPTION
2770: END IF;
2771:
2772: IF PO_LOG.d_proc THEN
2773: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2774: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2775: END IF;
2776:
2777: EXCEPTION
2778: WHEN OTHERS THEN
2775: END IF;
2776:
2777: EXCEPTION
2778: WHEN OTHERS THEN
2779: IF PO_LOG.d_exc THEN
2780: PO_LOG.exc(d_mod,0,NULL);
2781: END IF;
2782: RAISE;
2783:
2776:
2777: EXCEPTION
2778: WHEN OTHERS THEN
2779: IF PO_LOG.d_exc THEN
2780: PO_LOG.exc(d_mod,0,NULL);
2781: END IF;
2782: RAISE;
2783:
2784: END secondary_unit_of_measure;
2807: d_position NUMBER := 0;
2808:
2809: BEGIN
2810:
2811: IF PO_LOG.d_proc THEN
2812: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2813: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2814: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
2815: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2808:
2809: BEGIN
2810:
2811: IF PO_LOG.d_proc THEN
2812: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2813: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2814: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
2815: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2816: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2809: BEGIN
2810:
2811: IF PO_LOG.d_proc THEN
2812: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2813: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2814: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
2815: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2816: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2817: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2810:
2811: IF PO_LOG.d_proc THEN
2812: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2813: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2814: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
2815: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2816: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2817: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2818: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2811: IF PO_LOG.d_proc THEN
2812: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2813: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2814: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
2815: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2816: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2817: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2818: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2819: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2812: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2813: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2814: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
2815: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2816: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2817: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2818: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2819: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2820: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2813: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2814: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
2815: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2816: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2817: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2818: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2819: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2820: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2821: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2814: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
2815: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2816: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2817: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2818: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2819: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2820: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2821: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2822: END IF;
2815: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
2816: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2817: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2818: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2819: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2820: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2821: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2822: END IF;
2823:
2816: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2817: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2818: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2819: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2820: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2821: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2822: END IF;
2823:
2824: IF (x_results IS NULL) THEN
2817: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2818: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2819: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2820: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2821: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2822: END IF;
2823:
2824: IF (x_results IS NULL) THEN
2825: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2960: IF (SQL%ROWCOUNT > 0) THEN
2961: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2962: END IF;
2963:
2964: IF PO_LOG.d_proc THEN
2965: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2966: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,d_position,'x_results',x_results);
2967: END IF;
2968:
2961: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2962: END IF;
2963:
2964: IF PO_LOG.d_proc THEN
2965: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2966: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,d_position,'x_results',x_results);
2967: END IF;
2968:
2969: EXCEPTION
2962: END IF;
2963:
2964: IF PO_LOG.d_proc THEN
2965: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2966: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,d_position,'x_results',x_results);
2967: END IF;
2968:
2969: EXCEPTION
2970: WHEN OTHERS THEN
2967: END IF;
2968:
2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: IF PO_LOG.d_exc THEN
2972: PO_LOG.exc(d_mod,d_position,'Exception in secondary_quantity');
2973: END IF;
2974: RAISE;
2975:
2968:
2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: IF PO_LOG.d_exc THEN
2972: PO_LOG.exc(d_mod,d_position,'Exception in secondary_quantity');
2973: END IF;
2974: RAISE;
2975:
2976: END secondary_quantity;
2991: IS
2992: d_mod CONSTANT VARCHAR2(100) := d_secondary_uom_update;
2993: BEGIN
2994:
2995: IF PO_LOG.d_proc THEN
2996: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2997: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2998: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2999: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2992: d_mod CONSTANT VARCHAR2(100) := d_secondary_uom_update;
2993: BEGIN
2994:
2995: IF PO_LOG.d_proc THEN
2996: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2997: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2998: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2999: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2993: BEGIN
2994:
2995: IF PO_LOG.d_proc THEN
2996: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2997: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2998: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2999: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3001: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2994:
2995: IF PO_LOG.d_proc THEN
2996: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2997: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2998: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2999: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3001: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3002: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2995: IF PO_LOG.d_proc THEN
2996: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2997: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2998: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2999: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3001: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3002: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3003: END IF;
2996: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2997: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2998: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2999: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3001: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3002: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3003: END IF;
3004:
2997: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2998: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2999: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3001: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3002: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3003: END IF;
3004:
3005: IF x_result_set_id IS NULL THEN
2998: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2999: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3001: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3002: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3003: END IF;
3004:
3005: IF x_result_set_id IS NULL THEN
3006: x_result_set_id := po_validations.next_result_set_id();
3048: IF (SQL%ROWCOUNT > 0) THEN
3049: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3050: END IF;
3051:
3052: IF PO_LOG.d_proc THEN
3053: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3054: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3055: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3056: END IF;
3050: END IF;
3051:
3052: IF PO_LOG.d_proc THEN
3053: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3054: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3055: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3056: END IF;
3057:
3058: EXCEPTION
3051:
3052: IF PO_LOG.d_proc THEN
3053: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3054: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3055: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3056: END IF;
3057:
3058: EXCEPTION
3059: WHEN OTHERS THEN
3056: END IF;
3057:
3058: EXCEPTION
3059: WHEN OTHERS THEN
3060: IF PO_LOG.d_exc THEN
3061: PO_LOG.exc(d_mod, 0, NULL);
3062: END IF;
3063: RAISE;
3064:
3057:
3058: EXCEPTION
3059: WHEN OTHERS THEN
3060: IF PO_LOG.d_exc THEN
3061: PO_LOG.exc(d_mod, 0, NULL);
3062: END IF;
3063: RAISE;
3064:
3065: END secondary_uom_update;
3087: d_mod CONSTANT VARCHAR2(100) := d_preferred_grade;
3088: l_validation_id NUMBER;
3089: BEGIN
3090:
3091: IF PO_LOG.d_proc THEN
3092: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3093: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3094: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3095: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3088: l_validation_id NUMBER;
3089: BEGIN
3090:
3091: IF PO_LOG.d_proc THEN
3092: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3093: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3094: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3095: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3096: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3089: BEGIN
3090:
3091: IF PO_LOG.d_proc THEN
3092: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3093: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3094: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3095: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3096: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3097: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3090:
3091: IF PO_LOG.d_proc THEN
3092: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3093: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3094: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3095: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3096: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3097: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3098: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3091: IF PO_LOG.d_proc THEN
3092: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3093: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3094: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3095: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3096: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3097: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3098: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3099: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3092: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3093: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3094: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3095: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3096: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3097: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3098: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3099: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3093: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3094: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3095: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3096: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3097: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3098: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3099: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3101: END IF;
3094: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3095: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3096: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3097: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3098: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3099: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3101: END IF;
3102:
3095: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3096: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3097: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3098: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3099: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3101: END IF;
3102:
3103: IF x_result_set_id IS NULL THEN
3096: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3097: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3098: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3099: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3100: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3101: END IF;
3102:
3103: IF x_result_set_id IS NULL THEN
3104: x_result_set_id := po_validations.next_result_set_id();
3195: IF (SQL%ROWCOUNT > 0) THEN
3196: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3197: END IF;
3198:
3199: IF PO_LOG.d_proc THEN
3200: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3201: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3202: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3203: END IF;
3197: END IF;
3198:
3199: IF PO_LOG.d_proc THEN
3200: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3201: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3202: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3203: END IF;
3204:
3205: EXCEPTION
3198:
3199: IF PO_LOG.d_proc THEN
3200: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3201: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3202: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3203: END IF;
3204:
3205: EXCEPTION
3206: WHEN OTHERS THEN
3203: END IF;
3204:
3205: EXCEPTION
3206: WHEN OTHERS THEN
3207: IF PO_LOG.d_exc THEN
3208: PO_LOG.exc(d_mod, 0, NULL);
3209: END IF;
3210: RAISE;
3211:
3204:
3205: EXCEPTION
3206: WHEN OTHERS THEN
3207: IF PO_LOG.d_exc THEN
3208: PO_LOG.exc(d_mod, 0, NULL);
3209: END IF;
3210: RAISE;
3211:
3212: END preferred_grade;
3222: IS
3223: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;
3224: BEGIN
3225:
3226: IF PO_LOG.d_proc THEN
3227: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3228: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3229: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3230: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3223: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;
3224: BEGIN
3225:
3226: IF PO_LOG.d_proc THEN
3227: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3228: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3229: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3230: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3231: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3224: BEGIN
3225:
3226: IF PO_LOG.d_proc THEN
3227: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3228: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3229: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3230: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3231: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3232: END IF;
3225:
3226: IF PO_LOG.d_proc THEN
3227: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3228: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3229: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3230: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3231: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3232: END IF;
3233:
3226: IF PO_LOG.d_proc THEN
3227: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3228: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3229: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3230: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3231: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3232: END IF;
3233:
3234: IF x_result_set_id IS NULL THEN
3227: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3228: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3229: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3230: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3231: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3232: END IF;
3233:
3234: IF x_result_set_id IS NULL THEN
3235: x_result_set_id := po_validations.next_result_set_id();
3270: IF (SQL%ROWCOUNT > 0) THEN
3271: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3272: END IF;
3273:
3274: IF PO_LOG.d_proc THEN
3275: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3276: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3277: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3278: END IF;
3272: END IF;
3273:
3274: IF PO_LOG.d_proc THEN
3275: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3276: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3277: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3278: END IF;
3279:
3280: EXCEPTION
3273:
3274: IF PO_LOG.d_proc THEN
3275: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3276: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3277: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3278: END IF;
3279:
3280: EXCEPTION
3281: WHEN OTHERS THEN
3278: END IF;
3279:
3280: EXCEPTION
3281: WHEN OTHERS THEN
3282: IF PO_LOG.d_exc THEN
3283: PO_LOG.exc(d_mod, 0, NULL);
3284: END IF;
3285: RAISE;
3286:
3279:
3280: EXCEPTION
3281: WHEN OTHERS THEN
3282: IF PO_LOG.d_exc THEN
3283: PO_LOG.exc(d_mod, 0, NULL);
3284: END IF;
3285: RAISE;
3286:
3287: END process_enabled;
3305: l_result1_tbl PO_TBL_VARCHAR30;
3306:
3307: BEGIN
3308:
3309: IF PO_LOG.d_proc THEN
3310: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3311: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3312: END IF;
3313:
3306:
3307: BEGIN
3308:
3309: IF PO_LOG.d_proc THEN
3310: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3311: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3312: END IF;
3313:
3314: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);
3307: BEGIN
3308:
3309: IF PO_LOG.d_proc THEN
3310: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3311: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3312: END IF;
3313:
3314: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);
3315:
3336: FOR i IN 1..l_index1_tbl.COUNT LOOP
3337: l_secondary_unit_of_meas_tbl(l_index1_tbl(i)) := l_result1_tbl(i);
3338: END LOOP;
3339:
3340: IF PO_LOG.d_proc THEN
3341: PO_LOG.proc_end(d_mod, 'l_secondary_unit_of_meas_tbl', l_secondary_unit_of_meas_tbl);
3342: END IF;
3343:
3344: RETURN l_secondary_unit_of_meas_tbl;
3337: l_secondary_unit_of_meas_tbl(l_index1_tbl(i)) := l_result1_tbl(i);
3338: END LOOP;
3339:
3340: IF PO_LOG.d_proc THEN
3341: PO_LOG.proc_end(d_mod, 'l_secondary_unit_of_meas_tbl', l_secondary_unit_of_meas_tbl);
3342: END IF;
3343:
3344: RETURN l_secondary_unit_of_meas_tbl;
3345:
3344: RETURN l_secondary_unit_of_meas_tbl;
3345:
3346: EXCEPTION
3347: WHEN OTHERS THEN
3348: IF PO_LOG.d_exc THEN
3349: PO_LOG.exc(d_mod, 0, NULL);
3350: END IF;
3351: RAISE;
3352:
3345:
3346: EXCEPTION
3347: WHEN OTHERS THEN
3348: IF PO_LOG.d_exc THEN
3349: PO_LOG.exc(d_mod, 0, NULL);
3350: END IF;
3351: RAISE;
3352:
3353: END get_item_secondary_uom;
3417: c_attribute CONSTANT VARCHAR2(30) := 'ATTRIBUTE';
3418: c_po_appl CONSTANT VARCHAR2(30) := 'PO';
3419: BEGIN
3420:
3421: IF PO_LOG.d_proc THEN
3422: PO_LOG.proc_begin(p_calling_module);
3423: PO_LOG.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3424: PO_LOG.proc_begin(d_mod, 'p_desc_flex_name', p_desc_flex_name);
3425: PO_LOG.proc_begin(d_mod, 'p_attribute_category_tbl', p_attribute_category_tbl);
3418: c_po_appl CONSTANT VARCHAR2(30) := 'PO';
3419: BEGIN
3420:
3421: IF PO_LOG.d_proc THEN
3422: PO_LOG.proc_begin(p_calling_module);
3423: PO_LOG.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3424: PO_LOG.proc_begin(d_mod, 'p_desc_flex_name', p_desc_flex_name);
3425: PO_LOG.proc_begin(d_mod, 'p_attribute_category_tbl', p_attribute_category_tbl);
3426: PO_LOG.proc_begin(d_mod, 'p_attribute1_tbl', p_attribute1_tbl);
3419: BEGIN
3420:
3421: IF PO_LOG.d_proc THEN
3422: PO_LOG.proc_begin(p_calling_module);
3423: PO_LOG.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3424: PO_LOG.proc_begin(d_mod, 'p_desc_flex_name', p_desc_flex_name);
3425: PO_LOG.proc_begin(d_mod, 'p_attribute_category_tbl', p_attribute_category_tbl);
3426: PO_LOG.proc_begin(d_mod, 'p_attribute1_tbl', p_attribute1_tbl);
3427: PO_LOG.proc_begin(d_mod, 'p_attribute2_tbl', p_attribute2_tbl);
3420:
3421: IF PO_LOG.d_proc THEN
3422: PO_LOG.proc_begin(p_calling_module);
3423: PO_LOG.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3424: PO_LOG.proc_begin(d_mod, 'p_desc_flex_name', p_desc_flex_name);
3425: PO_LOG.proc_begin(d_mod, 'p_attribute_category_tbl', p_attribute_category_tbl);
3426: PO_LOG.proc_begin(d_mod, 'p_attribute1_tbl', p_attribute1_tbl);
3427: PO_LOG.proc_begin(d_mod, 'p_attribute2_tbl', p_attribute2_tbl);
3428: PO_LOG.proc_begin(d_mod, 'p_attribute3_tbl', p_attribute3_tbl);
3421: IF PO_LOG.d_proc THEN
3422: PO_LOG.proc_begin(p_calling_module);
3423: PO_LOG.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3424: PO_LOG.proc_begin(d_mod, 'p_desc_flex_name', p_desc_flex_name);
3425: PO_LOG.proc_begin(d_mod, 'p_attribute_category_tbl', p_attribute_category_tbl);
3426: PO_LOG.proc_begin(d_mod, 'p_attribute1_tbl', p_attribute1_tbl);
3427: PO_LOG.proc_begin(d_mod, 'p_attribute2_tbl', p_attribute2_tbl);
3428: PO_LOG.proc_begin(d_mod, 'p_attribute3_tbl', p_attribute3_tbl);
3429: PO_LOG.proc_begin(d_mod, 'p_attribute4_tbl', p_attribute4_tbl);
3422: PO_LOG.proc_begin(p_calling_module);
3423: PO_LOG.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3424: PO_LOG.proc_begin(d_mod, 'p_desc_flex_name', p_desc_flex_name);
3425: PO_LOG.proc_begin(d_mod, 'p_attribute_category_tbl', p_attribute_category_tbl);
3426: PO_LOG.proc_begin(d_mod, 'p_attribute1_tbl', p_attribute1_tbl);
3427: PO_LOG.proc_begin(d_mod, 'p_attribute2_tbl', p_attribute2_tbl);
3428: PO_LOG.proc_begin(d_mod, 'p_attribute3_tbl', p_attribute3_tbl);
3429: PO_LOG.proc_begin(d_mod, 'p_attribute4_tbl', p_attribute4_tbl);
3430: PO_LOG.proc_begin(d_mod, 'p_attribute5_tbl', p_attribute5_tbl);
3423: PO_LOG.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
3424: PO_LOG.proc_begin(d_mod, 'p_desc_flex_name', p_desc_flex_name);
3425: PO_LOG.proc_begin(d_mod, 'p_attribute_category_tbl', p_attribute_category_tbl);
3426: PO_LOG.proc_begin(d_mod, 'p_attribute1_tbl', p_attribute1_tbl);
3427: PO_LOG.proc_begin(d_mod, 'p_attribute2_tbl', p_attribute2_tbl);
3428: PO_LOG.proc_begin(d_mod, 'p_attribute3_tbl', p_attribute3_tbl);
3429: PO_LOG.proc_begin(d_mod, 'p_attribute4_tbl', p_attribute4_tbl);
3430: PO_LOG.proc_begin(d_mod, 'p_attribute5_tbl', p_attribute5_tbl);
3431: PO_LOG.proc_begin(d_mod, 'p_attribute6_tbl', p_attribute6_tbl);
3424: PO_LOG.proc_begin(d_mod, 'p_desc_flex_name', p_desc_flex_name);
3425: PO_LOG.proc_begin(d_mod, 'p_attribute_category_tbl', p_attribute_category_tbl);
3426: PO_LOG.proc_begin(d_mod, 'p_attribute1_tbl', p_attribute1_tbl);
3427: PO_LOG.proc_begin(d_mod, 'p_attribute2_tbl', p_attribute2_tbl);
3428: PO_LOG.proc_begin(d_mod, 'p_attribute3_tbl', p_attribute3_tbl);
3429: PO_LOG.proc_begin(d_mod, 'p_attribute4_tbl', p_attribute4_tbl);
3430: PO_LOG.proc_begin(d_mod, 'p_attribute5_tbl', p_attribute5_tbl);
3431: PO_LOG.proc_begin(d_mod, 'p_attribute6_tbl', p_attribute6_tbl);
3432: PO_LOG.proc_begin(d_mod, 'p_attribute7_tbl', p_attribute7_tbl);
3425: PO_LOG.proc_begin(d_mod, 'p_attribute_category_tbl', p_attribute_category_tbl);
3426: PO_LOG.proc_begin(d_mod, 'p_attribute1_tbl', p_attribute1_tbl);
3427: PO_LOG.proc_begin(d_mod, 'p_attribute2_tbl', p_attribute2_tbl);
3428: PO_LOG.proc_begin(d_mod, 'p_attribute3_tbl', p_attribute3_tbl);
3429: PO_LOG.proc_begin(d_mod, 'p_attribute4_tbl', p_attribute4_tbl);
3430: PO_LOG.proc_begin(d_mod, 'p_attribute5_tbl', p_attribute5_tbl);
3431: PO_LOG.proc_begin(d_mod, 'p_attribute6_tbl', p_attribute6_tbl);
3432: PO_LOG.proc_begin(d_mod, 'p_attribute7_tbl', p_attribute7_tbl);
3433: PO_LOG.proc_begin(d_mod, 'p_attribute8_tbl', p_attribute8_tbl);
3426: PO_LOG.proc_begin(d_mod, 'p_attribute1_tbl', p_attribute1_tbl);
3427: PO_LOG.proc_begin(d_mod, 'p_attribute2_tbl', p_attribute2_tbl);
3428: PO_LOG.proc_begin(d_mod, 'p_attribute3_tbl', p_attribute3_tbl);
3429: PO_LOG.proc_begin(d_mod, 'p_attribute4_tbl', p_attribute4_tbl);
3430: PO_LOG.proc_begin(d_mod, 'p_attribute5_tbl', p_attribute5_tbl);
3431: PO_LOG.proc_begin(d_mod, 'p_attribute6_tbl', p_attribute6_tbl);
3432: PO_LOG.proc_begin(d_mod, 'p_attribute7_tbl', p_attribute7_tbl);
3433: PO_LOG.proc_begin(d_mod, 'p_attribute8_tbl', p_attribute8_tbl);
3434: PO_LOG.proc_begin(d_mod, 'p_attribute9_tbl', p_attribute9_tbl);
3427: PO_LOG.proc_begin(d_mod, 'p_attribute2_tbl', p_attribute2_tbl);
3428: PO_LOG.proc_begin(d_mod, 'p_attribute3_tbl', p_attribute3_tbl);
3429: PO_LOG.proc_begin(d_mod, 'p_attribute4_tbl', p_attribute4_tbl);
3430: PO_LOG.proc_begin(d_mod, 'p_attribute5_tbl', p_attribute5_tbl);
3431: PO_LOG.proc_begin(d_mod, 'p_attribute6_tbl', p_attribute6_tbl);
3432: PO_LOG.proc_begin(d_mod, 'p_attribute7_tbl', p_attribute7_tbl);
3433: PO_LOG.proc_begin(d_mod, 'p_attribute8_tbl', p_attribute8_tbl);
3434: PO_LOG.proc_begin(d_mod, 'p_attribute9_tbl', p_attribute9_tbl);
3435: PO_LOG.proc_begin(d_mod, 'p_attribute10_tbl', p_attribute10_tbl);
3428: PO_LOG.proc_begin(d_mod, 'p_attribute3_tbl', p_attribute3_tbl);
3429: PO_LOG.proc_begin(d_mod, 'p_attribute4_tbl', p_attribute4_tbl);
3430: PO_LOG.proc_begin(d_mod, 'p_attribute5_tbl', p_attribute5_tbl);
3431: PO_LOG.proc_begin(d_mod, 'p_attribute6_tbl', p_attribute6_tbl);
3432: PO_LOG.proc_begin(d_mod, 'p_attribute7_tbl', p_attribute7_tbl);
3433: PO_LOG.proc_begin(d_mod, 'p_attribute8_tbl', p_attribute8_tbl);
3434: PO_LOG.proc_begin(d_mod, 'p_attribute9_tbl', p_attribute9_tbl);
3435: PO_LOG.proc_begin(d_mod, 'p_attribute10_tbl', p_attribute10_tbl);
3436: PO_LOG.proc_begin(d_mod, 'p_attribute11_tbl', p_attribute11_tbl);
3429: PO_LOG.proc_begin(d_mod, 'p_attribute4_tbl', p_attribute4_tbl);
3430: PO_LOG.proc_begin(d_mod, 'p_attribute5_tbl', p_attribute5_tbl);
3431: PO_LOG.proc_begin(d_mod, 'p_attribute6_tbl', p_attribute6_tbl);
3432: PO_LOG.proc_begin(d_mod, 'p_attribute7_tbl', p_attribute7_tbl);
3433: PO_LOG.proc_begin(d_mod, 'p_attribute8_tbl', p_attribute8_tbl);
3434: PO_LOG.proc_begin(d_mod, 'p_attribute9_tbl', p_attribute9_tbl);
3435: PO_LOG.proc_begin(d_mod, 'p_attribute10_tbl', p_attribute10_tbl);
3436: PO_LOG.proc_begin(d_mod, 'p_attribute11_tbl', p_attribute11_tbl);
3437: PO_LOG.proc_begin(d_mod, 'p_attribute12_tbl', p_attribute12_tbl);
3430: PO_LOG.proc_begin(d_mod, 'p_attribute5_tbl', p_attribute5_tbl);
3431: PO_LOG.proc_begin(d_mod, 'p_attribute6_tbl', p_attribute6_tbl);
3432: PO_LOG.proc_begin(d_mod, 'p_attribute7_tbl', p_attribute7_tbl);
3433: PO_LOG.proc_begin(d_mod, 'p_attribute8_tbl', p_attribute8_tbl);
3434: PO_LOG.proc_begin(d_mod, 'p_attribute9_tbl', p_attribute9_tbl);
3435: PO_LOG.proc_begin(d_mod, 'p_attribute10_tbl', p_attribute10_tbl);
3436: PO_LOG.proc_begin(d_mod, 'p_attribute11_tbl', p_attribute11_tbl);
3437: PO_LOG.proc_begin(d_mod, 'p_attribute12_tbl', p_attribute12_tbl);
3438: PO_LOG.proc_begin(d_mod, 'p_attribute13_tbl', p_attribute13_tbl);
3431: PO_LOG.proc_begin(d_mod, 'p_attribute6_tbl', p_attribute6_tbl);
3432: PO_LOG.proc_begin(d_mod, 'p_attribute7_tbl', p_attribute7_tbl);
3433: PO_LOG.proc_begin(d_mod, 'p_attribute8_tbl', p_attribute8_tbl);
3434: PO_LOG.proc_begin(d_mod, 'p_attribute9_tbl', p_attribute9_tbl);
3435: PO_LOG.proc_begin(d_mod, 'p_attribute10_tbl', p_attribute10_tbl);
3436: PO_LOG.proc_begin(d_mod, 'p_attribute11_tbl', p_attribute11_tbl);
3437: PO_LOG.proc_begin(d_mod, 'p_attribute12_tbl', p_attribute12_tbl);
3438: PO_LOG.proc_begin(d_mod, 'p_attribute13_tbl', p_attribute13_tbl);
3439: PO_LOG.proc_begin(d_mod, 'p_attribute14_tbl', p_attribute14_tbl);
3432: PO_LOG.proc_begin(d_mod, 'p_attribute7_tbl', p_attribute7_tbl);
3433: PO_LOG.proc_begin(d_mod, 'p_attribute8_tbl', p_attribute8_tbl);
3434: PO_LOG.proc_begin(d_mod, 'p_attribute9_tbl', p_attribute9_tbl);
3435: PO_LOG.proc_begin(d_mod, 'p_attribute10_tbl', p_attribute10_tbl);
3436: PO_LOG.proc_begin(d_mod, 'p_attribute11_tbl', p_attribute11_tbl);
3437: PO_LOG.proc_begin(d_mod, 'p_attribute12_tbl', p_attribute12_tbl);
3438: PO_LOG.proc_begin(d_mod, 'p_attribute13_tbl', p_attribute13_tbl);
3439: PO_LOG.proc_begin(d_mod, 'p_attribute14_tbl', p_attribute14_tbl);
3440: PO_LOG.proc_begin(d_mod, 'p_attribute15_tbl', p_attribute15_tbl);
3433: PO_LOG.proc_begin(d_mod, 'p_attribute8_tbl', p_attribute8_tbl);
3434: PO_LOG.proc_begin(d_mod, 'p_attribute9_tbl', p_attribute9_tbl);
3435: PO_LOG.proc_begin(d_mod, 'p_attribute10_tbl', p_attribute10_tbl);
3436: PO_LOG.proc_begin(d_mod, 'p_attribute11_tbl', p_attribute11_tbl);
3437: PO_LOG.proc_begin(d_mod, 'p_attribute12_tbl', p_attribute12_tbl);
3438: PO_LOG.proc_begin(d_mod, 'p_attribute13_tbl', p_attribute13_tbl);
3439: PO_LOG.proc_begin(d_mod, 'p_attribute14_tbl', p_attribute14_tbl);
3440: PO_LOG.proc_begin(d_mod, 'p_attribute15_tbl', p_attribute15_tbl);
3441: END IF;
3434: PO_LOG.proc_begin(d_mod, 'p_attribute9_tbl', p_attribute9_tbl);
3435: PO_LOG.proc_begin(d_mod, 'p_attribute10_tbl', p_attribute10_tbl);
3436: PO_LOG.proc_begin(d_mod, 'p_attribute11_tbl', p_attribute11_tbl);
3437: PO_LOG.proc_begin(d_mod, 'p_attribute12_tbl', p_attribute12_tbl);
3438: PO_LOG.proc_begin(d_mod, 'p_attribute13_tbl', p_attribute13_tbl);
3439: PO_LOG.proc_begin(d_mod, 'p_attribute14_tbl', p_attribute14_tbl);
3440: PO_LOG.proc_begin(d_mod, 'p_attribute15_tbl', p_attribute15_tbl);
3441: END IF;
3442:
3435: PO_LOG.proc_begin(d_mod, 'p_attribute10_tbl', p_attribute10_tbl);
3436: PO_LOG.proc_begin(d_mod, 'p_attribute11_tbl', p_attribute11_tbl);
3437: PO_LOG.proc_begin(d_mod, 'p_attribute12_tbl', p_attribute12_tbl);
3438: PO_LOG.proc_begin(d_mod, 'p_attribute13_tbl', p_attribute13_tbl);
3439: PO_LOG.proc_begin(d_mod, 'p_attribute14_tbl', p_attribute14_tbl);
3440: PO_LOG.proc_begin(d_mod, 'p_attribute15_tbl', p_attribute15_tbl);
3441: END IF;
3442:
3443: IF (x_results IS NULL) THEN
3436: PO_LOG.proc_begin(d_mod, 'p_attribute11_tbl', p_attribute11_tbl);
3437: PO_LOG.proc_begin(d_mod, 'p_attribute12_tbl', p_attribute12_tbl);
3438: PO_LOG.proc_begin(d_mod, 'p_attribute13_tbl', p_attribute13_tbl);
3439: PO_LOG.proc_begin(d_mod, 'p_attribute14_tbl', p_attribute14_tbl);
3440: PO_LOG.proc_begin(d_mod, 'p_attribute15_tbl', p_attribute15_tbl);
3441: END IF;
3442:
3443: IF (x_results IS NULL) THEN
3444: x_results := po_validation_results_type.new_instance();
3482: END IF;
3483:
3484: END LOOP;
3485:
3486: IF PO_LOG.d_proc THEN
3487: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3488: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
3489: PO_LOG.proc_end(p_calling_module);
3490: END IF;
3483:
3484: END LOOP;
3485:
3486: IF PO_LOG.d_proc THEN
3487: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3488: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
3489: PO_LOG.proc_end(p_calling_module);
3490: END IF;
3491:
3484: END LOOP;
3485:
3486: IF PO_LOG.d_proc THEN
3487: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3488: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
3489: PO_LOG.proc_end(p_calling_module);
3490: END IF;
3491:
3492: EXCEPTION
3485:
3486: IF PO_LOG.d_proc THEN
3487: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3488: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
3489: PO_LOG.proc_end(p_calling_module);
3490: END IF;
3491:
3492: EXCEPTION
3493: WHEN OTHERS THEN
3490: END IF;
3491:
3492: EXCEPTION
3493: WHEN OTHERS THEN
3494: IF PO_LOG.d_exc THEN
3495: PO_LOG.exc(d_mod,0,NULL);
3496: PO_LOG.exc(p_calling_module, 0, NULL);
3497: END IF;
3498: RAISE;
3491:
3492: EXCEPTION
3493: WHEN OTHERS THEN
3494: IF PO_LOG.d_exc THEN
3495: PO_LOG.exc(d_mod,0,NULL);
3496: PO_LOG.exc(p_calling_module, 0, NULL);
3497: END IF;
3498: RAISE;
3499: END validate_desc_flex;
3492: EXCEPTION
3493: WHEN OTHERS THEN
3494: IF PO_LOG.d_exc THEN
3495: PO_LOG.exc(d_mod,0,NULL);
3496: PO_LOG.exc(p_calling_module, 0, NULL);
3497: END IF;
3498: RAISE;
3499: END validate_desc_flex;
3500: