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

APPS.PO_VALIDATION_HELPER dependencies on PO_LOG

Line 29: PO_LOG.get_package_base('PO_VALIDATION_HELPER');

25: ---------------------------------------------------------------------------
26:
27: -- The module base for this package.
28: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
29: PO_LOG.get_package_base('PO_VALIDATION_HELPER');
30:
31: -- The module base for the subprogram.
32: D_greater_than_zero CONSTANT VARCHAR2(100) :=
33: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_than_zero');

Line 33: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_than_zero');

29: PO_LOG.get_package_base('PO_VALIDATION_HELPER');
30:
31: -- The module base for the subprogram.
32: D_greater_than_zero CONSTANT VARCHAR2(100) :=
33: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_than_zero');
34:
35: -- The module base for the subprogram.
36: D_greater_or_equal_zero CONSTANT VARCHAR2(100) :=
37: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_or_equal_zero');

Line 37: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_or_equal_zero');

33: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_than_zero');
34:
35: -- The module base for the subprogram.
36: D_greater_or_equal_zero CONSTANT VARCHAR2(100) :=
37: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_or_equal_zero');
38:
39: -- The module base for the subprogram.
40: D_within_percentage_range CONSTANT VARCHAR2(100) :=
41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'within_percentage_range');

Line 41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'within_percentage_range');

37: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'greater_or_equal_zero');
38:
39: -- The module base for the subprogram.
40: D_within_percentage_range CONSTANT VARCHAR2(100) :=
41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'within_percentage_range');
42:
43: -- The module base for the subprogram.
44: D_not_null CONSTANT VARCHAR2(100) :=
45: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'not_null');

Line 45: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'not_null');

41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'within_percentage_range');
42:
43: -- The module base for the subprogram.
44: D_not_null CONSTANT VARCHAR2(100) :=
45: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'not_null');
46:
47: -- The module base for the subprogram.
48: D_ensure_null CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'ensure_null');
49:

Line 48: D_ensure_null CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'ensure_null');

44: D_not_null CONSTANT VARCHAR2(100) :=
45: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'not_null');
46:
47: -- The module base for the subprogram.
48: D_ensure_null CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'ensure_null');
49:
50: -- The module base for the subprogram.
51: D_flag_value_Y_N CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'flag_value_Y_N');
52:

Line 51: D_flag_value_Y_N CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'flag_value_Y_N');

47: -- The module base for the subprogram.
48: D_ensure_null CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'ensure_null');
49:
50: -- The module base for the subprogram.
51: D_flag_value_Y_N CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'flag_value_Y_N');
52:
53: -- The module base for the subprogram.
54: D_zero CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'zero');
55:

Line 54: D_zero CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'zero');

50: -- The module base for the subprogram.
51: D_flag_value_Y_N CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'flag_value_Y_N');
52:
53: -- The module base for the subprogram.
54: D_zero CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'zero');
55:
56: -- The module base for the subprogram.
57: D_terms_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'terms_id');
58:

Line 57: D_terms_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'terms_id');

53: -- The module base for the subprogram.
54: D_zero CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'zero');
55:
56: -- The module base for the subprogram.
57: D_terms_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'terms_id');
58:
59: -- The module base for the subprogram.
60: D_open_period CONSTANT VARCHAR2(100) :=
61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'open_period');

Line 61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'open_period');

57: D_terms_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'terms_id');
58:
59: -- The module base for the subprogram.
60: D_open_period CONSTANT VARCHAR2(100) :=
61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'open_period');
62:
63: -- The module base for the subprogram.
64: D_gt_zero_order_type_filter CONSTANT VARCHAR2(100) :=
65: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_order_type_filter');

Line 65: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_order_type_filter');

61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'open_period');
62:
63: -- The module base for the subprogram.
64: D_gt_zero_order_type_filter CONSTANT VARCHAR2(100) :=
65: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_order_type_filter');
66:
67: -- The module base for the subprogram.
68: D_no_timecards_exist CONSTANT VARCHAR2(100) :=
69: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'no_timecards_exist');

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

65: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_order_type_filter');
66:
67: -- The module base for the subprogram.
68: D_no_timecards_exist CONSTANT VARCHAR2(100) :=
69: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'no_timecards_exist');
70:
71: -- The module base for the subprogram.
72: D_amount_notif_ctrl_warning CONSTANT VARCHAR2(100) :=
73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_notif_ctrl_warning');

Line 73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_notif_ctrl_warning');

69: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'no_timecards_exist');
70:
71: -- The module base for the subprogram.
72: D_amount_notif_ctrl_warning CONSTANT VARCHAR2(100) :=
73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_notif_ctrl_warning');
74:
75: -- The module base for the subprogram.
76: D_child_num_unique CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'child_num_unique');

Line 77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'child_num_unique');

73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_notif_ctrl_warning');
74:
75: -- The module base for the subprogram.
76: D_child_num_unique CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'child_num_unique');
78:
79: D_price_diff_value_unique CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_value_unique');
81:

Line 80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_value_unique');

76: D_child_num_unique CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'child_num_unique');
78:
79: D_price_diff_value_unique CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_value_unique');
81:
82: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
84: --UCA Project - CLMR4 Changes Begin

Line 83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');

79: D_price_diff_value_unique CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_value_unique');
81:
82: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
84: --UCA Project - CLMR4 Changes Begin
85: D_start_date_le_sys_date CONSTANT VARCHAR2(100) :=
86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_sys_date');
87:

Line 86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_sys_date');

82: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
84: --UCA Project - CLMR4 Changes Begin
85: D_start_date_le_sys_date CONSTANT VARCHAR2(100) :=
86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_sys_date');
87:
88: D_extract_par_draft_id_tbl CONSTANT VARCHAR2(100) :=
89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'extract_par_draft_id_tbl');
90:

Line 89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'extract_par_draft_id_tbl');

85: D_start_date_le_sys_date CONSTANT VARCHAR2(100) :=
86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_sys_date');
87:
88: D_extract_par_draft_id_tbl CONSTANT VARCHAR2(100) :=
89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'extract_par_draft_id_tbl');
90:
91: --UCA Project - CLMR4 Changes End
92: D_num1_less_or_equal_num2 CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'num1_less_or_equal_num2');

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

89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'extract_par_draft_id_tbl');
90:
91: --UCA Project - CLMR4 Changes End
92: D_num1_less_or_equal_num2 CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'num1_less_or_equal_num2');
94:
95: D_gt_zero_opm_filter CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_opm_filter');
97:

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

92: D_num1_less_or_equal_num2 CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'num1_less_or_equal_num2');
94:
95: D_gt_zero_opm_filter CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_opm_filter');
97:
98: D_qtys_within_deviation CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'qtys_within_deviation');
100:

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

95: D_gt_zero_opm_filter CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gt_zero_opm_filter');
97:
98: D_qtys_within_deviation CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'qtys_within_deviation');
100:
101: D_secondary_unit_of_measure CONSTANT VARCHAR2(100) :=
102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_unit_of_measure');
103:

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

98: D_qtys_within_deviation CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'qtys_within_deviation');
100:
101: D_secondary_unit_of_measure CONSTANT VARCHAR2(100) :=
102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_unit_of_measure');
103:
104: D_secondary_quantity CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_quantity');
106:

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

101: D_secondary_unit_of_measure CONSTANT VARCHAR2(100) :=
102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_unit_of_measure');
103:
104: D_secondary_quantity CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_quantity');
106:
107: D_preferred_grade CONSTANT VARCHAR2(100) :=
108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'preferred_grade');
109:

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

104: D_secondary_quantity CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_quantity');
106:
107: D_preferred_grade CONSTANT VARCHAR2(100) :=
108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'preferred_grade');
109:
110: D_secondary_uom_update CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_uom_update');
112:

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

107: D_preferred_grade CONSTANT VARCHAR2(100) :=
108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'preferred_grade');
109:
110: D_secondary_uom_update CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_uom_update');
112:
113: D_process_enabled CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'process_enabled');
115:

Line 114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'process_enabled');

110: D_secondary_uom_update CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'secondary_uom_update');
112:
113: D_process_enabled CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'process_enabled');
115:
116: D_get_converted_unit_of_meas CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_converted_unit_of_meas');
118:

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

113: D_process_enabled CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'process_enabled');
115:
116: D_get_converted_unit_of_meas CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_converted_unit_of_meas');
118:
119: D_get_item_secondary_uom CONSTANT VARCHAR2(100) :=
120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'get_item_secondary_uom');
121:

Line 120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'get_item_secondary_uom');

116: D_get_converted_unit_of_meas CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_converted_unit_of_meas');
118:
119: D_get_item_secondary_uom CONSTANT VARCHAR2(100) :=
120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'get_item_secondary_uom');
121:
122: D_validate_desc_flex CONSTANT VARCHAR2(100) :=
123: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_desc_flex');
124:

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

119: D_get_item_secondary_uom CONSTANT VARCHAR2(100) :=
120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'get_item_secondary_uom');
121:
122: D_validate_desc_flex CONSTANT VARCHAR2(100) :=
123: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_desc_flex');
124:
125: -------------------------------------------------------------------------------
126: -- Private Functions/Procedures
127: -------------------------------------------------------------------------------

Line 185: IF PO_LOG.d_proc THEN

181: l_null_not_allowed BOOLEAN;
182: l_message_name VARCHAR2(30);
183: BEGIN
184:
185: IF PO_LOG.d_proc THEN
186: PO_LOG.proc_begin(p_calling_module);
187: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
188: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

Line 186: PO_LOG.proc_begin(p_calling_module);

182: l_message_name VARCHAR2(30);
183: BEGIN
184:
185: IF PO_LOG.d_proc THEN
186: PO_LOG.proc_begin(p_calling_module);
187: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
188: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
190: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

Line 187: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);

183: BEGIN
184:
185: IF PO_LOG.d_proc THEN
186: PO_LOG.proc_begin(p_calling_module);
187: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
188: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
190: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
191: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 188: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);

184:
185: IF PO_LOG.d_proc THEN
186: PO_LOG.proc_begin(p_calling_module);
187: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
188: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
190: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
191: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
192: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

Line 189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

185: IF PO_LOG.d_proc THEN
186: PO_LOG.proc_begin(p_calling_module);
187: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
188: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
190: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
191: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
192: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
193: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 190: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

186: PO_LOG.proc_begin(p_calling_module);
187: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
188: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
190: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
191: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
192: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
193: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
194: END IF;

Line 191: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

187: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
188: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
190: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
191: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
192: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
193: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
194: END IF;
195:

Line 192: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

188: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
190: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
191: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
192: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
193: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
194: END IF;
195:
196: IF (x_results IS NULL) THEN

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

189: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
190: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
191: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
192: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
193: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
194: END IF;
195:
196: IF (x_results IS NULL) THEN
197: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 210: IF PO_LOG.d_stmt THEN

206: END IF;
207:
208: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO);
209:
210: IF PO_LOG.d_stmt THEN
211: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
212: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
213: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
214: END IF;

Line 211: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);

207:
208: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO);
209:
210: IF PO_LOG.d_stmt THEN
211: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
212: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
213: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
214: END IF;
215:

Line 212: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);

208: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO);
209:
210: IF PO_LOG.d_stmt THEN
211: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
212: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
213: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
214: END IF;
215:
216: FOR i IN 1 .. p_value_tbl.COUNT LOOP

Line 213: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);

209:
210: IF PO_LOG.d_stmt THEN
211: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
212: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
213: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
214: END IF;
215:
216: FOR i IN 1 .. p_value_tbl.COUNT LOOP
217: IF (p_value_tbl(i) <= 0 OR (l_null_not_allowed AND p_value_tbl(i) IS NULL)) THEN

Line 234: IF PO_LOG.d_proc THEN

230: ELSE
231: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
232: END IF;
233:
234: IF PO_LOG.d_proc THEN
235: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
236: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
237: PO_LOG.proc_end(p_calling_module);
238: END IF;

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

231: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
232: END IF;
233:
234: IF PO_LOG.d_proc THEN
235: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
236: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
237: PO_LOG.proc_end(p_calling_module);
238: END IF;
239:

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

232: END IF;
233:
234: IF PO_LOG.d_proc THEN
235: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
236: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
237: PO_LOG.proc_end(p_calling_module);
238: END IF;
239:
240: EXCEPTION

Line 237: PO_LOG.proc_end(p_calling_module);

233:
234: IF PO_LOG.d_proc THEN
235: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
236: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
237: PO_LOG.proc_end(p_calling_module);
238: END IF;
239:
240: EXCEPTION
241: WHEN OTHERS THEN

Line 242: IF PO_LOG.d_exc THEN

238: END IF;
239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF PO_LOG.d_exc THEN
243: PO_LOG.exc(d_mod,0,NULL);
244: PO_LOG.exc(p_calling_module,0,NULL);
245: END IF;
246: RAISE;

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

239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF PO_LOG.d_exc THEN
243: PO_LOG.exc(d_mod,0,NULL);
244: PO_LOG.exc(p_calling_module,0,NULL);
245: END IF;
246: RAISE;
247:

Line 244: PO_LOG.exc(p_calling_module,0,NULL);

240: EXCEPTION
241: WHEN OTHERS THEN
242: IF PO_LOG.d_exc THEN
243: PO_LOG.exc(d_mod,0,NULL);
244: PO_LOG.exc(p_calling_module,0,NULL);
245: END IF;
246: RAISE;
247:
248: END greater_than_zero;

Line 311: IF PO_LOG.d_proc THEN

307: l_token2_value_tbl PO_TBL_VARCHAR4000;
308:
309: BEGIN
310:
311: IF PO_LOG.d_proc THEN
312: PO_LOG.proc_begin(p_calling_module);
313: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
314: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

Line 312: PO_LOG.proc_begin(p_calling_module);

308:
309: BEGIN
310:
311: IF PO_LOG.d_proc THEN
312: PO_LOG.proc_begin(p_calling_module);
313: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
314: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

Line 313: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);

309: BEGIN
310:
311: IF PO_LOG.d_proc THEN
312: PO_LOG.proc_begin(p_calling_module);
313: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
314: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 314: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);

310:
311: IF PO_LOG.d_proc THEN
312: PO_LOG.proc_begin(p_calling_module);
313: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
314: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

Line 315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

311: IF PO_LOG.d_proc THEN
312: PO_LOG.proc_begin(p_calling_module);
313: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
314: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

Line 316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

312: PO_LOG.proc_begin(p_calling_module);
313: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
314: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
320: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

Line 317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

313: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
314: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
320: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
321: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);

Line 318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

314: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
320: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
321: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
322: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);

Line 319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

315: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
320: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
321: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
322: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
323: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 320: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

316: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
320: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
321: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
322: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
323: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
324: END IF;

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

317: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
320: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
321: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
322: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
323: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
324: END IF;
325:

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

318: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
320: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
321: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
322: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
323: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
324: END IF;
325:
326: IF (x_results IS NULL) THEN

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

319: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
320: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
321: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
322: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
323: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
324: END IF;
325:
326: IF (x_results IS NULL) THEN
327: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 347: IF PO_LOG.d_stmt THEN

343: END IF;
344:
345: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO);
346:
347: IF PO_LOG.d_stmt THEN
348: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
349: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
350: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
351: END IF;

Line 348: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);

344:
345: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO);
346:
347: IF PO_LOG.d_stmt THEN
348: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
349: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
350: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
351: END IF;
352:

Line 349: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);

345: l_message_name := NVL(p_message_name,PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO);
346:
347: IF PO_LOG.d_stmt THEN
348: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
349: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
350: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
351: END IF;
352:
353: FOR i IN 1 .. p_value_tbl.COUNT LOOP

Line 350: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);

346:
347: IF PO_LOG.d_stmt THEN
348: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
349: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
350: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
351: END IF;
352:
353: FOR i IN 1 .. p_value_tbl.COUNT LOOP
354: IF (p_value_tbl(i) < 0 OR (l_null_not_allowed AND p_value_tbl(i) IS NULL)) THEN

Line 375: IF PO_LOG.d_proc THEN

371: ELSE
372: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
373: END IF;
374:
375: IF PO_LOG.d_proc THEN
376: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
377: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
378: PO_LOG.proc_end(p_calling_module);
379: END IF;

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

372: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
373: END IF;
374:
375: IF PO_LOG.d_proc THEN
376: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
377: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
378: PO_LOG.proc_end(p_calling_module);
379: END IF;
380:

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

373: END IF;
374:
375: IF PO_LOG.d_proc THEN
376: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
377: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
378: PO_LOG.proc_end(p_calling_module);
379: END IF;
380:
381: EXCEPTION

Line 378: PO_LOG.proc_end(p_calling_module);

374:
375: IF PO_LOG.d_proc THEN
376: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
377: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
378: PO_LOG.proc_end(p_calling_module);
379: END IF;
380:
381: EXCEPTION
382: WHEN OTHERS THEN

Line 383: IF PO_LOG.d_exc THEN

379: END IF;
380:
381: EXCEPTION
382: WHEN OTHERS THEN
383: IF PO_LOG.d_exc THEN
384: PO_LOG.exc(d_mod,0,NULL);
385: PO_LOG.exc(p_calling_module,0,NULL);
386: END IF;
387: RAISE;

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

380:
381: EXCEPTION
382: WHEN OTHERS THEN
383: IF PO_LOG.d_exc THEN
384: PO_LOG.exc(d_mod,0,NULL);
385: PO_LOG.exc(p_calling_module,0,NULL);
386: END IF;
387: RAISE;
388:

Line 385: PO_LOG.exc(p_calling_module,0,NULL);

381: EXCEPTION
382: WHEN OTHERS THEN
383: IF PO_LOG.d_exc THEN
384: PO_LOG.exc(d_mod,0,NULL);
385: PO_LOG.exc(p_calling_module,0,NULL);
386: END IF;
387: RAISE;
388:
389: END greater_or_equal_zero;

Line 452: IF PO_LOG.d_proc THEN

448: l_message_name VARCHAR2(30);
449: l_token1_value_tbl PO_TBL_VARCHAR4000;
450: BEGIN
451:
452: IF PO_LOG.d_proc THEN
453: PO_LOG.proc_begin(p_calling_module);
454: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
455: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

Line 453: PO_LOG.proc_begin(p_calling_module);

449: l_token1_value_tbl PO_TBL_VARCHAR4000;
450: BEGIN
451:
452: IF PO_LOG.d_proc THEN
453: PO_LOG.proc_begin(p_calling_module);
454: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
455: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

Line 454: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);

450: BEGIN
451:
452: IF PO_LOG.d_proc THEN
453: PO_LOG.proc_begin(p_calling_module);
454: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
455: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 455: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);

451:
452: IF PO_LOG.d_proc THEN
453: PO_LOG.proc_begin(p_calling_module);
454: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
455: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
459: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

Line 456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

452: IF PO_LOG.d_proc THEN
453: PO_LOG.proc_begin(p_calling_module);
454: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
455: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
459: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
460: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);

Line 457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

453: PO_LOG.proc_begin(p_calling_module);
454: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
455: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
459: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
460: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
461: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);

Line 458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

454: PO_LOG.proc_begin(d_mod,'p_null_allowed_flag',p_null_allowed_flag);
455: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
459: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
460: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
461: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
462: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 459: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

455: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
459: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
460: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
461: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
462: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
463: END IF;

Line 460: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);

456: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
459: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
460: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
461: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
462: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
463: END IF;
464:

Line 461: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);

457: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
459: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
460: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
461: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
462: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
463: END IF;
464:
465: IF (x_results IS NULL) THEN

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

458: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
459: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
460: PO_LOG.proc_begin(d_mod,'p_token1_name',p_token1_name);
461: PO_LOG.proc_begin(d_mod,'p_token1_value_tbl',p_token1_value_tbl);
462: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
463: END IF;
464:
465: IF (x_results IS NULL) THEN
466: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 486: IF PO_LOG.d_stmt THEN

482: ELSE
483: l_token1_value_tbl := p_token1_value_tbl;
484: END IF;
485:
486: IF PO_LOG.d_stmt THEN
487: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
488: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
489: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
490: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);

Line 487: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);

483: l_token1_value_tbl := p_token1_value_tbl;
484: END IF;
485:
486: IF PO_LOG.d_stmt THEN
487: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
488: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
489: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
490: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);
491: END IF;

Line 488: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);

484: END IF;
485:
486: IF PO_LOG.d_stmt THEN
487: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
488: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
489: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
490: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);
491: END IF;
492:

Line 489: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);

485:
486: IF PO_LOG.d_stmt THEN
487: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
488: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
489: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
490: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);
491: END IF;
492:
493: FOR i IN 1 .. p_value_tbl.COUNT LOOP

Line 490: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);

486: IF PO_LOG.d_stmt THEN
487: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
488: PO_LOG.stmt(d_mod,0,'l_null_not_allowed',l_null_not_allowed);
489: PO_LOG.stmt(d_mod,0,'l_message_name',l_message_name);
490: PO_LOG.stmt(d_mod,0,'l_token1_value_tbl',l_token1_value_tbl);
491: END IF;
492:
493: FOR i IN 1 .. p_value_tbl.COUNT LOOP
494: IF (p_value_tbl(i) < 0 OR p_value_tbl(i) > 100

Line 515: IF PO_LOG.d_proc THEN

511: ELSE
512: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
513: END IF;
514:
515: IF PO_LOG.d_proc THEN
516: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
517: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
518: PO_LOG.proc_end(p_calling_module);
519: END IF;

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

512: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
513: END IF;
514:
515: IF PO_LOG.d_proc THEN
516: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
517: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
518: PO_LOG.proc_end(p_calling_module);
519: END IF;
520:

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

513: END IF;
514:
515: IF PO_LOG.d_proc THEN
516: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
517: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
518: PO_LOG.proc_end(p_calling_module);
519: END IF;
520:
521: EXCEPTION

Line 518: PO_LOG.proc_end(p_calling_module);

514:
515: IF PO_LOG.d_proc THEN
516: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
517: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
518: PO_LOG.proc_end(p_calling_module);
519: END IF;
520:
521: EXCEPTION
522: WHEN OTHERS THEN

Line 523: IF PO_LOG.d_exc THEN

519: END IF;
520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: IF PO_LOG.d_exc THEN
524: PO_LOG.exc(d_mod,0,NULL);
525: PO_LOG.exc(p_calling_module,0,NULL);
526: END IF;
527: RAISE;

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

520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: IF PO_LOG.d_exc THEN
524: PO_LOG.exc(d_mod,0,NULL);
525: PO_LOG.exc(p_calling_module,0,NULL);
526: END IF;
527: RAISE;
528:

Line 525: PO_LOG.exc(p_calling_module,0,NULL);

521: EXCEPTION
522: WHEN OTHERS THEN
523: IF PO_LOG.d_exc THEN
524: PO_LOG.exc(d_mod,0,NULL);
525: PO_LOG.exc(p_calling_module,0,NULL);
526: END IF;
527: RAISE;
528:
529: END within_percentage_range;

Line 587: IF PO_LOG.d_proc THEN

583: d_mod CONSTANT VARCHAR2(100) := D_open_period;
584: l_profile_value VARCHAR2(2000);
585: BEGIN
586:
587: IF PO_LOG.d_proc THEN
588: PO_LOG.proc_begin(p_calling_module);
589: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
590: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

Line 588: PO_LOG.proc_begin(p_calling_module);

584: l_profile_value VARCHAR2(2000);
585: BEGIN
586:
587: IF PO_LOG.d_proc THEN
588: PO_LOG.proc_begin(p_calling_module);
589: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
590: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

Line 589: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);

585: BEGIN
586:
587: IF PO_LOG.d_proc THEN
588: PO_LOG.proc_begin(p_calling_module);
589: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
590: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

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

586:
587: IF PO_LOG.d_proc THEN
588: PO_LOG.proc_begin(p_calling_module);
589: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
590: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

Line 591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

587: IF PO_LOG.d_proc THEN
588: PO_LOG.proc_begin(p_calling_module);
589: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
590: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
595: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

588: PO_LOG.proc_begin(p_calling_module);
589: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
590: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
595: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
596: END IF;

Line 593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

589: PO_LOG.proc_begin(d_mod,'p_date_tbl',p_date_tbl);
590: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
595: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
596: END IF;
597:

Line 594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

590: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
595: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
596: END IF;
597:
598: IF (x_result_set_id IS NULL) THEN

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

591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
595: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
596: END IF;
597:
598: IF (x_result_set_id IS NULL) THEN
599: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 606: IF PO_LOG.d_stmt THEN

602: FND_PROFILE.get(PO_PROFILES.PO_CHECK_OPEN_PERIODS,l_profile_value);
603:
604: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
605:
606: IF PO_LOG.d_stmt THEN
607: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
608: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
609: PO_LOG.stmt(d_mod,0,'x_result_type',x_result_type);
610: END IF;

Line 607: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);

603:
604: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
605:
606: IF PO_LOG.d_stmt THEN
607: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
608: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
609: PO_LOG.stmt(d_mod,0,'x_result_type',x_result_type);
610: END IF;
611:

Line 608: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);

604: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
605:
606: IF PO_LOG.d_stmt THEN
607: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
608: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
609: PO_LOG.stmt(d_mod,0,'x_result_type',x_result_type);
610: END IF;
611:
612: IF (l_profile_value = 'Y') THEN

Line 609: PO_LOG.stmt(d_mod,0,'x_result_type',x_result_type);

605:
606: IF PO_LOG.d_stmt THEN
607: PO_LOG.stmt(d_mod,0,'l_profile_value',l_profile_value);
608: PO_LOG.stmt(d_mod,0,'x_result_set_id',x_result_set_id);
609: PO_LOG.stmt(d_mod,0,'x_result_type',x_result_type);
610: END IF;
611:
612: IF (l_profile_value = 'Y') THEN
613:

Line 664: IF PO_LOG.d_proc THEN

660: IF(SQL%ROWCOUNT > 0) THEN
661: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
662: END IF;
663:
664: IF PO_LOG.d_proc THEN
665: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
666: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
667: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
668: PO_LOG.proc_end(p_calling_module);

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

662: END IF;
663:
664: IF PO_LOG.d_proc THEN
665: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
666: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
667: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
668: PO_LOG.proc_end(p_calling_module);
669: END IF;
670:

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

663:
664: IF PO_LOG.d_proc THEN
665: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
666: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
667: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
668: PO_LOG.proc_end(p_calling_module);
669: END IF;
670:
671: END IF;

Line 668: PO_LOG.proc_end(p_calling_module);

664: IF PO_LOG.d_proc THEN
665: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
666: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
667: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
668: PO_LOG.proc_end(p_calling_module);
669: END IF;
670:
671: END IF;
672: END LOOP;

Line 678: IF PO_LOG.d_exc THEN

674: END IF;
675:
676: EXCEPTION
677: WHEN OTHERS THEN
678: IF PO_LOG.d_exc THEN
679: PO_LOG.exc(d_mod,0,NULL);
680: PO_LOG.exc(p_calling_module,0,NULL);
681: END IF;
682: RAISE;

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

675:
676: EXCEPTION
677: WHEN OTHERS THEN
678: IF PO_LOG.d_exc THEN
679: PO_LOG.exc(d_mod,0,NULL);
680: PO_LOG.exc(p_calling_module,0,NULL);
681: END IF;
682: RAISE;
683:

Line 680: PO_LOG.exc(p_calling_module,0,NULL);

676: EXCEPTION
677: WHEN OTHERS THEN
678: IF PO_LOG.d_exc THEN
679: PO_LOG.exc(d_mod,0,NULL);
680: PO_LOG.exc(p_calling_module,0,NULL);
681: END IF;
682: RAISE;
683:
684: END open_period;

Line 741: IF PO_LOG.d_proc THEN

737: l_token2_value_tbl PO_TBL_VARCHAR4000;
738:
739: BEGIN
740:
741: IF PO_LOG.d_proc THEN
742: PO_LOG.proc_begin(p_calling_module);
743: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
744: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);

Line 742: PO_LOG.proc_begin(p_calling_module);

738:
739: BEGIN
740:
741: IF PO_LOG.d_proc THEN
742: PO_LOG.proc_begin(p_calling_module);
743: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
744: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);

Line 743: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);

739: BEGIN
740:
741: IF PO_LOG.d_proc THEN
742: PO_LOG.proc_begin(p_calling_module);
743: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
744: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);

Line 744: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);

740:
741: IF PO_LOG.d_proc THEN
742: PO_LOG.proc_begin(p_calling_module);
743: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
744: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

Line 745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);

741: IF PO_LOG.d_proc THEN
742: PO_LOG.proc_begin(p_calling_module);
743: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
744: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
749: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

Line 746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);

742: PO_LOG.proc_begin(p_calling_module);
743: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
744: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
749: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
750: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);

Line 747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);

743: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
744: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
749: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
750: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
751: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);

Line 748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

744: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl', p_entity_id_tbl);
745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
749: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
750: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
751: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
752: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 749: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

745: PO_LOG.proc_begin(d_mod,'p_entity_type', p_entity_type);
746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
749: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
750: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
751: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
752: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
753: END IF;

Line 750: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);

746: PO_LOG.proc_begin(d_mod,'p_column_name', p_column_name);
747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
749: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
750: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
751: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
752: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
753: END IF;
754:

Line 751: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);

747: PO_LOG.proc_begin(d_mod,'p_message_name', p_message_name);
748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
749: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
750: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
751: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
752: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
753: END IF;
754:
755: IF (x_results IS NULL) THEN

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

748: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
749: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
750: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
751: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
752: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
753: END IF;
754:
755: IF (x_results IS NULL) THEN
756: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 768: IF PO_LOG.d_stmt THEN

764: END IF;
765:
766: l_results_count := x_results.result_type.COUNT;
767:
768: IF PO_LOG.d_stmt THEN
769: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
770: END IF;
771:
772: FOR i IN 1 .. p_value_tbl.COUNT LOOP

Line 769: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);

765:
766: l_results_count := x_results.result_type.COUNT;
767:
768: IF PO_LOG.d_stmt THEN
769: PO_LOG.stmt(d_mod,0,'l_results_count',l_results_count);
770: END IF;
771:
772: FOR i IN 1 .. p_value_tbl.COUNT LOOP
773: IF (p_value_tbl(i) IS NULL) THEN

Line 794: IF PO_LOG.d_proc THEN

790: ELSE
791: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
792: END IF;
793:
794: IF PO_LOG.d_proc THEN
795: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
796: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
797: PO_LOG.proc_end(p_calling_module);
798: END IF;

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

791: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
792: END IF;
793:
794: IF PO_LOG.d_proc THEN
795: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
796: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
797: PO_LOG.proc_end(p_calling_module);
798: END IF;
799:

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

792: END IF;
793:
794: IF PO_LOG.d_proc THEN
795: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
796: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
797: PO_LOG.proc_end(p_calling_module);
798: END IF;
799:
800: EXCEPTION

Line 797: PO_LOG.proc_end(p_calling_module);

793:
794: IF PO_LOG.d_proc THEN
795: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
796: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
797: PO_LOG.proc_end(p_calling_module);
798: END IF;
799:
800: EXCEPTION
801: WHEN OTHERS THEN

Line 802: IF PO_LOG.d_exc THEN

798: END IF;
799:
800: EXCEPTION
801: WHEN OTHERS THEN
802: IF PO_LOG.d_exc THEN
803: PO_LOG.exc(d_mod,0,NULL);
804: PO_LOG.exc(p_calling_module,0,NULL);
805: END IF;
806: RAISE;

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

799:
800: EXCEPTION
801: WHEN OTHERS THEN
802: IF PO_LOG.d_exc THEN
803: PO_LOG.exc(d_mod,0,NULL);
804: PO_LOG.exc(p_calling_module,0,NULL);
805: END IF;
806: RAISE;
807:

Line 804: PO_LOG.exc(p_calling_module,0,NULL);

800: EXCEPTION
801: WHEN OTHERS THEN
802: IF PO_LOG.d_exc THEN
803: PO_LOG.exc(d_mod,0,NULL);
804: PO_LOG.exc(p_calling_module,0,NULL);
805: END IF;
806: RAISE;
807:
808: END not_null;

Line 861: IF PO_LOG.d_proc THEN

857: l_token2_value_tbl PO_TBL_VARCHAR4000;
858:
859: BEGIN
860:
861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(p_calling_module);
863: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
864: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
865: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);

Line 862: PO_LOG.proc_begin(p_calling_module);

858:
859: BEGIN
860:
861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(p_calling_module);
863: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
864: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
865: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
866: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);

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

859: BEGIN
860:
861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(p_calling_module);
863: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
864: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
865: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
866: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);

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

860:
861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(p_calling_module);
863: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
864: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
865: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
866: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

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

861: IF PO_LOG.d_proc THEN
862: PO_LOG.proc_begin(p_calling_module);
863: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
864: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
865: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
866: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
869: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

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

862: PO_LOG.proc_begin(p_calling_module);
863: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
864: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
865: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
866: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
869: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
870: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);

Line 867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);

863: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
864: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
865: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
866: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
869: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
870: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
871: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);

Line 868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

864: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
865: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
866: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
869: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
870: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
871: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
872: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);

Line 869: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

865: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
866: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
869: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
870: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
871: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
872: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
873: END IF;

Line 870: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);

866: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
869: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
870: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
871: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
872: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
873: END IF;
874:

Line 871: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);

867: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
869: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
870: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
871: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
872: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
873: END IF;
874:
875: IF (x_results IS NULL) THEN

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

868: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
869: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
870: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
871: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
872: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
873: END IF;
874:
875: IF (x_results IS NULL) THEN
876: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 888: IF PO_LOG.d_stmt THEN

884: END IF;
885:
886: l_results_count := x_results.result_type.COUNT;
887:
888: IF PO_LOG.d_stmt THEN
889: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
890: END IF;
891:
892: FOR i IN 1 .. p_value_tbl.COUNT LOOP

Line 889: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);

885:
886: l_results_count := x_results.result_type.COUNT;
887:
888: IF PO_LOG.d_stmt THEN
889: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
890: END IF;
891:
892: FOR i IN 1 .. p_value_tbl.COUNT LOOP
893: IF (p_value_tbl(i) IS NOT NULL) THEN

Line 913: IF PO_LOG.d_proc THEN

909: ELSE
910: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
911: END IF;
912:
913: IF PO_LOG.d_proc THEN
914: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
915: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
916: PO_LOG.proc_end(p_calling_module);
917: END IF;

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

910: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
911: END IF;
912:
913: IF PO_LOG.d_proc THEN
914: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
915: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
916: PO_LOG.proc_end(p_calling_module);
917: END IF;
918:

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

911: END IF;
912:
913: IF PO_LOG.d_proc THEN
914: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
915: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
916: PO_LOG.proc_end(p_calling_module);
917: END IF;
918:
919: EXCEPTION

Line 916: PO_LOG.proc_end(p_calling_module);

912:
913: IF PO_LOG.d_proc THEN
914: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
915: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
916: PO_LOG.proc_end(p_calling_module);
917: END IF;
918:
919: EXCEPTION
920: WHEN OTHERS THEN

Line 921: IF PO_LOG.d_exc THEN

917: END IF;
918:
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF PO_LOG.d_exc THEN
922: PO_LOG.exc(d_mod, 0, NULL);
923: PO_LOG.exc(p_calling_module, 0, NULL);
924: END IF;
925: RAISE;

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

918:
919: EXCEPTION
920: WHEN OTHERS THEN
921: IF PO_LOG.d_exc THEN
922: PO_LOG.exc(d_mod, 0, NULL);
923: PO_LOG.exc(p_calling_module, 0, NULL);
924: END IF;
925: RAISE;
926:

Line 923: PO_LOG.exc(p_calling_module, 0, NULL);

919: EXCEPTION
920: WHEN OTHERS THEN
921: IF PO_LOG.d_exc THEN
922: PO_LOG.exc(d_mod, 0, NULL);
923: PO_LOG.exc(p_calling_module, 0, NULL);
924: END IF;
925: RAISE;
926:
927: END ensure_null;

Line 980: IF PO_LOG.d_proc THEN

976: l_token2_value_tbl PO_TBL_VARCHAR4000;
977:
978: BEGIN
979:
980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(p_calling_module);
982: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
983: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);

Line 981: PO_LOG.proc_begin(p_calling_module);

977:
978: BEGIN
979:
980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(p_calling_module);
982: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
983: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);

Line 982: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);

978: BEGIN
979:
980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(p_calling_module);
982: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
983: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);

Line 983: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);

979:
980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(p_calling_module);
982: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
983: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

Line 984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);

980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(p_calling_module);
982: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
983: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
988: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

Line 985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);

981: PO_LOG.proc_begin(p_calling_module);
982: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
983: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
988: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
989: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);

Line 986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);

982: PO_LOG.proc_begin(d_mod, 'p_flag_value_tbl', p_flag_value_tbl);
983: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
988: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
989: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
990: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);

Line 987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

983: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
988: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
989: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
990: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
991: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);

Line 988: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

984: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
988: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
989: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
990: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
991: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
992: END IF;

Line 989: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);

985: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
988: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
989: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
990: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
991: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
992: END IF;
993:

Line 990: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);

986: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
988: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
989: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
990: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
991: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
992: END IF;
993:
994: IF (x_results IS NULL) THEN

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

987: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
988: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
989: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
990: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
991: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
992: END IF;
993:
994: IF (x_results IS NULL) THEN
995: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1007: IF PO_LOG.d_stmt THEN

1003: END IF;
1004:
1005: l_results_count := x_results.result_type.COUNT;
1006:
1007: IF PO_LOG.d_stmt THEN
1008: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
1009: END IF;
1010:
1011: FOR i IN 1 .. p_flag_value_tbl.COUNT LOOP

Line 1008: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);

1004:
1005: l_results_count := x_results.result_type.COUNT;
1006:
1007: IF PO_LOG.d_stmt THEN
1008: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
1009: END IF;
1010:
1011: FOR i IN 1 .. p_flag_value_tbl.COUNT LOOP
1012: IF (p_flag_value_tbl(i) NOT IN ('Y', 'N')) THEN

Line 1032: IF PO_LOG.d_proc THEN

1028: ELSE
1029: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1030: END IF;
1031:
1032: IF PO_LOG.d_proc THEN
1033: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
1034: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
1035: PO_LOG.proc_end(p_calling_module);
1036: END IF;

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

1029: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1030: END IF;
1031:
1032: IF PO_LOG.d_proc THEN
1033: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
1034: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
1035: PO_LOG.proc_end(p_calling_module);
1036: END IF;
1037:

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

1030: END IF;
1031:
1032: IF PO_LOG.d_proc THEN
1033: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
1034: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
1035: PO_LOG.proc_end(p_calling_module);
1036: END IF;
1037:
1038: EXCEPTION

Line 1035: PO_LOG.proc_end(p_calling_module);

1031:
1032: IF PO_LOG.d_proc THEN
1033: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
1034: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
1035: PO_LOG.proc_end(p_calling_module);
1036: END IF;
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN

Line 1040: IF PO_LOG.d_exc THEN

1036: END IF;
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: IF PO_LOG.d_exc THEN
1041: PO_LOG.exc(d_mod, 0, NULL);
1042: PO_LOG.exc(p_calling_module, 0, NULL);
1043: END IF;
1044: RAISE;

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

1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: IF PO_LOG.d_exc THEN
1041: PO_LOG.exc(d_mod, 0, NULL);
1042: PO_LOG.exc(p_calling_module, 0, NULL);
1043: END IF;
1044: RAISE;
1045:

Line 1042: PO_LOG.exc(p_calling_module, 0, NULL);

1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: IF PO_LOG.d_exc THEN
1041: PO_LOG.exc(d_mod, 0, NULL);
1042: PO_LOG.exc(p_calling_module, 0, NULL);
1043: END IF;
1044: RAISE;
1045:
1046: END flag_value_Y_N;

Line 1118: IF PO_LOG.d_proc THEN

1114: l_entity_id NUMBER;
1115:
1116: BEGIN
1117:
1118: IF PO_LOG.d_proc THEN
1119: PO_LOG.proc_begin(p_calling_module);
1120: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1121: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);

Line 1119: PO_LOG.proc_begin(p_calling_module);

1115:
1116: BEGIN
1117:
1118: IF PO_LOG.d_proc THEN
1119: PO_LOG.proc_begin(p_calling_module);
1120: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1121: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);

Line 1120: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);

1116: BEGIN
1117:
1118: IF PO_LOG.d_proc THEN
1119: PO_LOG.proc_begin(p_calling_module);
1120: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1121: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1124: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

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

1117:
1118: IF PO_LOG.d_proc THEN
1119: PO_LOG.proc_begin(p_calling_module);
1120: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1121: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1124: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1125: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

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

1118: IF PO_LOG.d_proc THEN
1119: PO_LOG.proc_begin(p_calling_module);
1120: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1121: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1124: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1125: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1126: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

1119: PO_LOG.proc_begin(p_calling_module);
1120: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1121: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1124: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1125: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1126: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1127: END IF;

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

1120: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1121: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1124: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1125: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1126: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1127: END IF;
1128:

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

1121: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1122: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1124: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1125: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1126: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1127: END IF;
1128:
1129: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN

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

1122: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1123: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1124: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1125: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1126: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1127: END IF;
1128:
1129: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN
1130: l_keep_quantity := TRUE;

Line 1173: IF PO_LOG.d_stmt THEN

1169: IF (p_header_id_tbl.Count > 0)
1170: THEN
1171: l_entity_id := p_header_id_tbl(1);
1172:
1173: IF PO_LOG.d_stmt THEN
1174: PO_LOG.stmt(d_mod,0,'l_entity_id ',l_entity_id);
1175: END IF;
1176:
1177: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_header_id => l_entity_id);

Line 1174: PO_LOG.stmt(d_mod,0,'l_entity_id ',l_entity_id);

1170: THEN
1171: l_entity_id := p_header_id_tbl(1);
1172:
1173: IF PO_LOG.d_stmt THEN
1174: PO_LOG.stmt(d_mod,0,'l_entity_id ',l_entity_id);
1175: END IF;
1176:
1177: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_header_id => l_entity_id);
1178: END IF;

Line 1180: IF PO_LOG.d_stmt THEN

1176:
1177: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_header_id => l_entity_id);
1178: END IF;
1179:
1180: IF PO_LOG.d_stmt THEN
1181: PO_LOG.stmt(d_mod,10,'l_is_clm_po ',l_is_clm_po);
1182: END IF;
1183:
1184: IF l_is_clm_po = 'Y'

Line 1181: PO_LOG.stmt(d_mod,10,'l_is_clm_po ',l_is_clm_po);

1177: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_header_id => l_entity_id);
1178: END IF;
1179:
1180: IF PO_LOG.d_stmt THEN
1181: PO_LOG.stmt(d_mod,10,'l_is_clm_po ',l_is_clm_po);
1182: END IF;
1183:
1184: IF l_is_clm_po = 'Y'
1185: THEN

Line 1216: IF PO_LOG.d_proc THEN

1212:
1213: END IF;
1214: --
1215:
1216: IF PO_LOG.d_proc THEN
1217: PO_LOG.proc_end(d_mod);
1218: PO_LOG.proc_end(p_calling_module);
1219: END IF;
1220:

Line 1217: PO_LOG.proc_end(d_mod);

1213: END IF;
1214: --
1215:
1216: IF PO_LOG.d_proc THEN
1217: PO_LOG.proc_end(d_mod);
1218: PO_LOG.proc_end(p_calling_module);
1219: END IF;
1220:
1221: EXCEPTION

Line 1218: PO_LOG.proc_end(p_calling_module);

1214: --
1215:
1216: IF PO_LOG.d_proc THEN
1217: PO_LOG.proc_end(d_mod);
1218: PO_LOG.proc_end(p_calling_module);
1219: END IF;
1220:
1221: EXCEPTION
1222: WHEN OTHERS THEN

Line 1223: IF PO_LOG.d_exc THEN

1219: END IF;
1220:
1221: EXCEPTION
1222: WHEN OTHERS THEN
1223: IF PO_LOG.d_exc THEN
1224: PO_LOG.exc(d_mod,0,NULL);
1225: PO_LOG.exc(p_calling_module,0,NULL);
1226: END IF;
1227: RAISE;

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

1220:
1221: EXCEPTION
1222: WHEN OTHERS THEN
1223: IF PO_LOG.d_exc THEN
1224: PO_LOG.exc(d_mod,0,NULL);
1225: PO_LOG.exc(p_calling_module,0,NULL);
1226: END IF;
1227: RAISE;
1228:

Line 1225: PO_LOG.exc(p_calling_module,0,NULL);

1221: EXCEPTION
1222: WHEN OTHERS THEN
1223: IF PO_LOG.d_exc THEN
1224: PO_LOG.exc(d_mod,0,NULL);
1225: PO_LOG.exc(p_calling_module,0,NULL);
1226: END IF;
1227: RAISE;
1228:
1229: END gt_zero_order_type_filter;

Line 1255: IF PO_LOG.d_proc THEN

1251: l_value_tbl PO_TBL_NUMBER;
1252:
1253: BEGIN
1254:
1255: IF PO_LOG.d_proc THEN
1256: PO_LOG.proc_begin(p_calling_module);
1257: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1258: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);

Line 1256: PO_LOG.proc_begin(p_calling_module);

1252:
1253: BEGIN
1254:
1255: IF PO_LOG.d_proc THEN
1256: PO_LOG.proc_begin(p_calling_module);
1257: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1258: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1260: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);

Line 1257: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);

1253: BEGIN
1254:
1255: IF PO_LOG.d_proc THEN
1256: PO_LOG.proc_begin(p_calling_module);
1257: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1258: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1260: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1261: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

Line 1258: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

1254:
1255: IF PO_LOG.d_proc THEN
1256: PO_LOG.proc_begin(p_calling_module);
1257: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1258: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1260: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1261: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1262: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);

1255: IF PO_LOG.d_proc THEN
1256: PO_LOG.proc_begin(p_calling_module);
1257: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1258: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1260: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1261: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1262: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1263: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1260: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);

1256: PO_LOG.proc_begin(p_calling_module);
1257: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1258: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1260: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1261: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1262: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1263: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1264: END IF;

Line 1261: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

1257: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
1258: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1260: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1261: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1262: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1263: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1264: END IF;
1265:

Line 1262: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

1258: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1260: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1261: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1262: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1263: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1264: END IF;
1265:
1266: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN

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

1259: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1260: PO_LOG.proc_begin(d_mod,'p_check_quantity_types_flag',p_check_quantity_types_flag);
1261: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1262: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1263: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1264: END IF;
1265:
1266: IF (p_check_quantity_types_flag = PO_CORE_S.g_parameter_YES) THEN
1267: l_keep_quantity := TRUE;

Line 1308: IF PO_LOG.d_proc THEN

1304: , x_results => x_results
1305: , x_result_type => x_result_type
1306: );
1307:
1308: IF PO_LOG.d_proc THEN
1309: PO_LOG.proc_end(d_mod);
1310: PO_LOG.proc_end(p_calling_module);
1311: END IF;
1312:

Line 1309: PO_LOG.proc_end(d_mod);

1305: , x_result_type => x_result_type
1306: );
1307:
1308: IF PO_LOG.d_proc THEN
1309: PO_LOG.proc_end(d_mod);
1310: PO_LOG.proc_end(p_calling_module);
1311: END IF;
1312:
1313: EXCEPTION

Line 1310: PO_LOG.proc_end(p_calling_module);

1306: );
1307:
1308: IF PO_LOG.d_proc THEN
1309: PO_LOG.proc_end(d_mod);
1310: PO_LOG.proc_end(p_calling_module);
1311: END IF;
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN

Line 1315: IF PO_LOG.d_exc THEN

1311: END IF;
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: IF PO_LOG.d_exc THEN
1316: PO_LOG.exc(d_mod,0,NULL);
1317: PO_LOG.exc(p_calling_module,0,NULL);
1318: END IF;
1319: RAISE;

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

1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: IF PO_LOG.d_exc THEN
1316: PO_LOG.exc(d_mod,0,NULL);
1317: PO_LOG.exc(p_calling_module,0,NULL);
1318: END IF;
1319: RAISE;
1320:

Line 1317: PO_LOG.exc(p_calling_module,0,NULL);

1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: IF PO_LOG.d_exc THEN
1316: PO_LOG.exc(d_mod,0,NULL);
1317: PO_LOG.exc(p_calling_module,0,NULL);
1318: END IF;
1319: RAISE;
1320:
1321: END gt_zero_order_type_filter;

Line 1390: IF PO_LOG.d_proc THEN

1386: l_return_status VARCHAR2(10);
1387:
1388: BEGIN
1389:
1390: IF PO_LOG.d_proc THEN
1391: PO_LOG.proc_begin(p_calling_module);
1392: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1393: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1394: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);

Line 1391: PO_LOG.proc_begin(p_calling_module);

1387:
1388: BEGIN
1389:
1390: IF PO_LOG.d_proc THEN
1391: PO_LOG.proc_begin(p_calling_module);
1392: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1393: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1394: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1395: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 1392: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

1388: BEGIN
1389:
1390: IF PO_LOG.d_proc THEN
1391: PO_LOG.proc_begin(p_calling_module);
1392: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1393: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1394: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1395: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1396: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

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

1389:
1390: IF PO_LOG.d_proc THEN
1391: PO_LOG.proc_begin(p_calling_module);
1392: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1393: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1394: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1395: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1396: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1397: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1394: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);

1390: IF PO_LOG.d_proc THEN
1391: PO_LOG.proc_begin(p_calling_module);
1392: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1393: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1394: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1395: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1396: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1397: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1398: END IF;

Line 1395: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

1391: PO_LOG.proc_begin(p_calling_module);
1392: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1393: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1394: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1395: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1396: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1397: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1398: END IF;
1399:

Line 1396: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

1392: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1393: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1394: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1395: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1396: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1397: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1398: END IF;
1399:
1400: IF (x_results IS NULL) THEN

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

1393: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
1394: PO_LOG.proc_begin(d_mod,'p_expiration_date_tbl',p_expiration_date_tbl);
1395: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1396: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1397: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1398: END IF;
1399:
1400: IF (x_results IS NULL) THEN
1401: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1469: IF PO_LOG.d_stmt THEN

1465: AND HEADER.type_lookup_code = c_STANDARD
1466: AND LINE.order_type_lookup_code = c_RATE
1467: ;
1468:
1469: IF PO_LOG.d_stmt THEN
1470: PO_LOG.stmt(d_mod,50,'l_line_id_tbl',l_line_id_tbl);
1471: END IF;
1472:
1473: FOR i IN 1 .. l_line_id_tbl.COUNT LOOP

Line 1470: PO_LOG.stmt(d_mod,50,'l_line_id_tbl',l_line_id_tbl);

1466: AND LINE.order_type_lookup_code = c_RATE
1467: ;
1468:
1469: IF PO_LOG.d_stmt THEN
1470: PO_LOG.stmt(d_mod,50,'l_line_id_tbl',l_line_id_tbl);
1471: END IF;
1472:
1473: FOR i IN 1 .. l_line_id_tbl.COUNT LOOP
1474:

Line 1509: IF PO_LOG.d_proc THEN

1505: ELSE
1506: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1507: END IF;
1508:
1509: IF PO_LOG.d_proc THEN
1510: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1511: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1512: PO_LOG.proc_end(p_calling_module);
1513: END IF;

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

1506: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1507: END IF;
1508:
1509: IF PO_LOG.d_proc THEN
1510: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1511: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1512: PO_LOG.proc_end(p_calling_module);
1513: END IF;
1514:

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

1507: END IF;
1508:
1509: IF PO_LOG.d_proc THEN
1510: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1511: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1512: PO_LOG.proc_end(p_calling_module);
1513: END IF;
1514:
1515: EXCEPTION

Line 1512: PO_LOG.proc_end(p_calling_module);

1508:
1509: IF PO_LOG.d_proc THEN
1510: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1511: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1512: PO_LOG.proc_end(p_calling_module);
1513: END IF;
1514:
1515: EXCEPTION
1516: WHEN OTHERS THEN

Line 1517: IF PO_LOG.d_exc THEN

1513: END IF;
1514:
1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: IF PO_LOG.d_exc THEN
1518: PO_LOG.exc(d_mod,0,NULL);
1519: PO_LOG.exc(p_calling_module,0,NULL);
1520: END IF;
1521: RAISE;

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

1514:
1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: IF PO_LOG.d_exc THEN
1518: PO_LOG.exc(d_mod,0,NULL);
1519: PO_LOG.exc(p_calling_module,0,NULL);
1520: END IF;
1521: RAISE;
1522:

Line 1519: PO_LOG.exc(p_calling_module,0,NULL);

1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: IF PO_LOG.d_exc THEN
1518: PO_LOG.exc(d_mod,0,NULL);
1519: PO_LOG.exc(p_calling_module,0,NULL);
1520: END IF;
1521: RAISE;
1522:
1523: END no_timecards_exist;

Line 1574: IF PO_LOG.d_proc THEN

1570: l_quantity_flag VARCHAR2(1);
1571: l_quantity_tbl PO_TBL_NUMBER;
1572: BEGIN
1573:
1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_begin(p_calling_module);
1576: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1577: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1578: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 1575: PO_LOG.proc_begin(p_calling_module);

1571: l_quantity_tbl PO_TBL_NUMBER;
1572: BEGIN
1573:
1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_begin(p_calling_module);
1576: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1577: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1578: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1579: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

Line 1576: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

1572: BEGIN
1573:
1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_begin(p_calling_module);
1576: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1577: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1578: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1579: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1580: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1577: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);

1573:
1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_begin(p_calling_module);
1576: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1577: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1578: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1579: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1580: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1581: END IF;

Line 1578: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_begin(p_calling_module);
1576: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1577: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1578: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1579: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1580: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1581: END IF;
1582:

Line 1579: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

1575: PO_LOG.proc_begin(p_calling_module);
1576: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1577: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1578: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1579: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1580: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1581: END IF;
1582:
1583: IF (x_result_set_id IS NULL) THEN

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

1576: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1577: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1578: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
1579: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1580: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1581: END IF;
1582:
1583: IF (x_result_set_id IS NULL) THEN
1584: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1639: IF PO_LOG.d_proc THEN

1635: ELSE
1636: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1637: END IF;
1638:
1639: IF PO_LOG.d_proc THEN
1640: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1641: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1642: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1643: PO_LOG.proc_end(p_calling_module);

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

1637: END IF;
1638:
1639: IF PO_LOG.d_proc THEN
1640: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1641: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1642: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1643: PO_LOG.proc_end(p_calling_module);
1644: END IF;
1645:

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

1638:
1639: IF PO_LOG.d_proc THEN
1640: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1641: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1642: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1643: PO_LOG.proc_end(p_calling_module);
1644: END IF;
1645:
1646: EXCEPTION

Line 1643: PO_LOG.proc_end(p_calling_module);

1639: IF PO_LOG.d_proc THEN
1640: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1641: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1642: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1643: PO_LOG.proc_end(p_calling_module);
1644: END IF;
1645:
1646: EXCEPTION
1647: WHEN OTHERS THEN

Line 1648: IF PO_LOG.d_exc THEN

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

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

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

Line 1650: PO_LOG.exc(p_calling_module,0,NULL);

1646: EXCEPTION
1647: WHEN OTHERS THEN
1648: IF PO_LOG.d_exc THEN
1649: PO_LOG.exc(d_mod,0,NULL);
1650: PO_LOG.exc(p_calling_module,0,NULL);
1651: END IF;
1652: RAISE;
1653:
1654: END amount_notif_ctrl_warning;

Line 1700: IF PO_LOG.d_proc THEN

1696: l_message_name VARCHAR2(30);
1697:
1698: BEGIN
1699:
1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(p_calling_module);
1702: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1703: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1704: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);

Line 1701: PO_LOG.proc_begin(p_calling_module);

1697:
1698: BEGIN
1699:
1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(p_calling_module);
1702: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1703: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1704: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1705: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);

Line 1702: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

1698: BEGIN
1699:
1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(p_calling_module);
1702: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1703: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1704: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1705: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1706: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1703: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

1699:
1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(p_calling_module);
1702: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1703: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1704: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1705: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1706: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1707: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);

Line 1704: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);

1700: IF PO_LOG.d_proc THEN
1701: PO_LOG.proc_begin(p_calling_module);
1702: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1703: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1704: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1705: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1706: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1707: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1708: END IF;

Line 1705: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);

1701: PO_LOG.proc_begin(p_calling_module);
1702: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1703: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1704: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1705: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1706: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1707: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1708: END IF;
1709:

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

1702: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
1703: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1704: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1705: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1706: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1707: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1708: END IF;
1709:
1710: IF (x_result_set_id IS NULL) THEN

Line 1707: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);

1703: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
1704: PO_LOG.proc_begin(d_mod,'p_parent_id_tbl',p_parent_id_tbl);
1705: PO_LOG.proc_begin(d_mod,'p_entity_num_tbl',p_entity_num_tbl);
1706: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1707: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
1708: END IF;
1709:
1710: IF (x_result_set_id IS NULL) THEN
1711: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1950: IF PO_LOG.d_proc THEN

1946: ELSE
1947: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1948: END IF;
1949:
1950: IF PO_LOG.d_proc THEN
1951: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1952: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1953: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1954: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

Line 1951: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);

1947: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1948: END IF;
1949:
1950: IF PO_LOG.d_proc THEN
1951: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1952: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1953: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1954: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1955: PO_LOG.proc_end(p_calling_module);

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

1949:
1950: IF PO_LOG.d_proc THEN
1951: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1952: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1953: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1954: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1955: PO_LOG.proc_end(p_calling_module);
1956: END IF;
1957:

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

1950: IF PO_LOG.d_proc THEN
1951: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1952: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1953: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1954: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1955: PO_LOG.proc_end(p_calling_module);
1956: END IF;
1957:
1958: EXCEPTION

Line 1955: PO_LOG.proc_end(p_calling_module);

1951: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
1952: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1953: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1954: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1955: PO_LOG.proc_end(p_calling_module);
1956: END IF;
1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN

Line 1960: IF PO_LOG.d_exc THEN

1956: END IF;
1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960: IF PO_LOG.d_exc THEN
1961: PO_LOG.exc(d_mod,0,NULL);
1962: PO_LOG.exc(p_calling_module,0,NULL);
1963: END IF;
1964: RAISE;

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

1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960: IF PO_LOG.d_exc THEN
1961: PO_LOG.exc(d_mod,0,NULL);
1962: PO_LOG.exc(p_calling_module,0,NULL);
1963: END IF;
1964: RAISE;
1965:

Line 1962: PO_LOG.exc(p_calling_module,0,NULL);

1958: EXCEPTION
1959: WHEN OTHERS THEN
1960: IF PO_LOG.d_exc THEN
1961: PO_LOG.exc(d_mod,0,NULL);
1962: PO_LOG.exc(p_calling_module,0,NULL);
1963: END IF;
1964: RAISE;
1965:
1966: END child_num_unique;

Line 1996: IF PO_LOG.d_proc THEN

1992: l_parent_id_tbl PO_TBL_NUMBER;
1993:
1994: BEGIN
1995:
1996: IF PO_LOG.d_proc THEN
1997: PO_LOG.proc_begin(p_calling_module);
1998: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_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_tbl',p_entity_type_tbl);

Line 1997: PO_LOG.proc_begin(p_calling_module);

1993:
1994: BEGIN
1995:
1996: IF PO_LOG.d_proc THEN
1997: PO_LOG.proc_begin(p_calling_module);
1998: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_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_tbl',p_entity_type_tbl);
2001: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);

Line 1998: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_tbl);

1994: BEGIN
1995:
1996: IF PO_LOG.d_proc THEN
1997: PO_LOG.proc_begin(p_calling_module);
1998: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_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_tbl',p_entity_type_tbl);
2001: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
2002: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 1999: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

1995:
1996: IF PO_LOG.d_proc THEN
1997: PO_LOG.proc_begin(p_calling_module);
1998: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_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_tbl',p_entity_type_tbl);
2001: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
2002: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

Line 2000: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);

1996: IF PO_LOG.d_proc THEN
1997: PO_LOG.proc_begin(p_calling_module);
1998: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_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_tbl',p_entity_type_tbl);
2001: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
2002: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 2001: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);

1997: PO_LOG.proc_begin(p_calling_module);
1998: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_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_tbl',p_entity_type_tbl);
2001: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
2002: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2005: END IF;

Line 2002: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

1998: PO_LOG.proc_begin(d_mod,'p_price_diff_id_tbl',p_price_diff_id_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_tbl',p_entity_type_tbl);
2001: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
2002: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2005: END IF;
2006:

Line 2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

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_tbl',p_entity_type_tbl);
2001: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
2002: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2005: END IF;
2006:
2007: IF (x_result_set_id IS NULL) THEN

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

2000: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
2001: PO_LOG.proc_begin(d_mod,'p_unique_value_tbl',p_unique_value_tbl);
2002: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2003: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2004: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2005: END IF;
2006:
2007: IF (x_result_set_id IS NULL) THEN
2008: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 2131: IF PO_LOG.d_proc THEN

2127: ELSE
2128: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2129: END IF;
2130:
2131: IF PO_LOG.d_proc THEN
2132: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
2133: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2134: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2135: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

Line 2132: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);

2128: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2129: END IF;
2130:
2131: IF PO_LOG.d_proc THEN
2132: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
2133: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2134: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2135: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2136: PO_LOG.proc_end(p_calling_module);

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

2130:
2131: IF PO_LOG.d_proc THEN
2132: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
2133: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2134: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2135: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2136: PO_LOG.proc_end(p_calling_module);
2137: END IF;
2138:

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

2131: IF PO_LOG.d_proc THEN
2132: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
2133: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2134: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2135: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2136: PO_LOG.proc_end(p_calling_module);
2137: END IF;
2138:
2139: EXCEPTION

Line 2136: PO_LOG.proc_end(p_calling_module);

2132: PO_LOG.stmt_session_gt(d_mod,9,l_data_key);
2133: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2134: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2135: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2136: PO_LOG.proc_end(p_calling_module);
2137: END IF;
2138:
2139: EXCEPTION
2140: WHEN OTHERS THEN

Line 2141: IF PO_LOG.d_exc THEN

2137: END IF;
2138:
2139: EXCEPTION
2140: WHEN OTHERS THEN
2141: IF PO_LOG.d_exc THEN
2142: PO_LOG.exc(d_mod,0,NULL);
2143: PO_LOG.exc(p_calling_module,0,NULL);
2144: END IF;
2145: RAISE;

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

2138:
2139: EXCEPTION
2140: WHEN OTHERS THEN
2141: IF PO_LOG.d_exc THEN
2142: PO_LOG.exc(d_mod,0,NULL);
2143: PO_LOG.exc(p_calling_module,0,NULL);
2144: END IF;
2145: RAISE;
2146:

Line 2143: PO_LOG.exc(p_calling_module,0,NULL);

2139: EXCEPTION
2140: WHEN OTHERS THEN
2141: IF PO_LOG.d_exc THEN
2142: PO_LOG.exc(d_mod,0,NULL);
2143: PO_LOG.exc(p_calling_module,0,NULL);
2144: END IF;
2145: RAISE;
2146:
2147: END price_diff_value_unique;

Line 2180: IF PO_LOG.d_proc THEN

2176: l_results_count NUMBER;
2177: l_column_val DATE;
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_start_date_tbl',p_start_date_tbl);
2183: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

Line 2181: PO_LOG.proc_begin(p_calling_module);

2177: l_column_val DATE;
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_start_date_tbl',p_start_date_tbl);
2183: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

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

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_start_date_tbl',p_start_date_tbl);
2183: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2186: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

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

2179:
2180: IF PO_LOG.d_proc THEN
2181: PO_LOG.proc_begin(p_calling_module);
2182: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
2183: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2186: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2187: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);

Line 2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

2180: IF PO_LOG.d_proc THEN
2181: PO_LOG.proc_begin(p_calling_module);
2182: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
2183: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2186: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2187: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2188: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

Line 2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

2181: PO_LOG.proc_begin(p_calling_module);
2182: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
2183: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2186: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2187: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2188: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2189: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 2186: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

2182: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
2183: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2186: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2187: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2188: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2189: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2190: END IF;

Line 2187: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);

2183: PO_LOG.proc_begin(d_mod,'p_end_date_tbl',p_end_date_tbl);
2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2186: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2187: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2188: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2189: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2190: END IF;
2191:

Line 2188: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

2184: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2186: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2187: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2188: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2189: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2190: END IF;
2191:
2192: IF (x_results IS NULL) THEN

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

2185: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2186: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2187: PO_LOG.proc_begin(d_mod,'p_column_val_selector',p_column_val_selector);
2188: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2189: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2190: END IF;
2191:
2192: IF (x_results IS NULL) THEN
2193: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 2227: IF PO_LOG.d_proc THEN

2223: ELSE
2224: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2225: END IF;
2226:
2227: IF PO_LOG.d_proc THEN
2228: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2229: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2230: PO_LOG.proc_end(p_calling_module);
2231: END IF;

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

2224: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2225: END IF;
2226:
2227: IF PO_LOG.d_proc THEN
2228: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2229: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2230: PO_LOG.proc_end(p_calling_module);
2231: END IF;
2232:

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

2225: END IF;
2226:
2227: IF PO_LOG.d_proc THEN
2228: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2229: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2230: PO_LOG.proc_end(p_calling_module);
2231: END IF;
2232:
2233: EXCEPTION

Line 2230: PO_LOG.proc_end(p_calling_module);

2226:
2227: IF PO_LOG.d_proc THEN
2228: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2229: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2230: PO_LOG.proc_end(p_calling_module);
2231: END IF;
2232:
2233: EXCEPTION
2234: WHEN OTHERS THEN

Line 2235: IF PO_LOG.d_exc THEN

2231: END IF;
2232:
2233: EXCEPTION
2234: WHEN OTHERS THEN
2235: IF PO_LOG.d_exc THEN
2236: PO_LOG.exc(d_mod,0,NULL);
2237: PO_LOG.exc(p_calling_module,0,NULL);
2238: END IF;
2239: RAISE;

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

2232:
2233: EXCEPTION
2234: WHEN OTHERS THEN
2235: IF PO_LOG.d_exc THEN
2236: PO_LOG.exc(d_mod,0,NULL);
2237: PO_LOG.exc(p_calling_module,0,NULL);
2238: END IF;
2239: RAISE;
2240:

Line 2237: PO_LOG.exc(p_calling_module,0,NULL);

2233: EXCEPTION
2234: WHEN OTHERS THEN
2235: IF PO_LOG.d_exc THEN
2236: PO_LOG.exc(d_mod,0,NULL);
2237: PO_LOG.exc(p_calling_module,0,NULL);
2238: END IF;
2239: RAISE;
2240:
2241: END start_date_le_end_date;

Line 2263: IF PO_LOG.d_proc THEN

2259: d_mod CONSTANT VARCHAR2(100) := D_num1_less_or_equal_num2;
2260: l_results_count NUMBER;
2261: BEGIN
2262:
2263: IF PO_LOG.d_proc THEN
2264: PO_LOG.proc_begin(p_calling_module);
2265: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2266: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

Line 2264: PO_LOG.proc_begin(p_calling_module);

2260: l_results_count NUMBER;
2261: BEGIN
2262:
2263: IF PO_LOG.d_proc THEN
2264: PO_LOG.proc_begin(p_calling_module);
2265: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2266: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2268: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

Line 2265: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);

2261: BEGIN
2262:
2263: IF PO_LOG.d_proc THEN
2264: PO_LOG.proc_begin(p_calling_module);
2265: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2266: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2268: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2269: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 2266: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);

2262:
2263: IF PO_LOG.d_proc THEN
2264: PO_LOG.proc_begin(p_calling_module);
2265: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2266: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2268: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2269: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2270: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

Line 2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

2263: IF PO_LOG.d_proc THEN
2264: PO_LOG.proc_begin(p_calling_module);
2265: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2266: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2268: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2269: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2270: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2271: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 2268: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

2264: PO_LOG.proc_begin(p_calling_module);
2265: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2266: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2268: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2269: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2270: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2271: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2272: END IF;

Line 2269: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

2265: PO_LOG.proc_begin(d_mod,'p_num1_tbl',p_num1_tbl);
2266: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2268: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2269: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2270: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2271: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2272: END IF;
2273:

Line 2270: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

2266: PO_LOG.proc_begin(d_mod,'p_num2_tbl',p_num2_tbl);
2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2268: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2269: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2270: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2271: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2272: END IF;
2273:
2274: IF (x_results IS NULL) THEN

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

2267: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2268: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2269: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2270: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
2271: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2272: END IF;
2273:
2274: IF (x_results IS NULL) THEN
2275: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 2297: IF PO_LOG.d_proc THEN

2293: ELSE
2294: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2295: END IF;
2296:
2297: IF PO_LOG.d_proc THEN
2298: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2299: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2300: PO_LOG.proc_end(p_calling_module);
2301: END IF;

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

2294: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2295: END IF;
2296:
2297: IF PO_LOG.d_proc THEN
2298: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2299: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2300: PO_LOG.proc_end(p_calling_module);
2301: END IF;
2302:

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

2295: END IF;
2296:
2297: IF PO_LOG.d_proc THEN
2298: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2299: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2300: PO_LOG.proc_end(p_calling_module);
2301: END IF;
2302:
2303: EXCEPTION

Line 2300: PO_LOG.proc_end(p_calling_module);

2296:
2297: IF PO_LOG.d_proc THEN
2298: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2299: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2300: PO_LOG.proc_end(p_calling_module);
2301: END IF;
2302:
2303: EXCEPTION
2304: WHEN OTHERS THEN

Line 2305: IF PO_LOG.d_exc THEN

2301: END IF;
2302:
2303: EXCEPTION
2304: WHEN OTHERS THEN
2305: IF PO_LOG.d_exc THEN
2306: PO_LOG.exc(d_mod,0,NULL);
2307: PO_LOG.exc(p_calling_module,0,NULL);
2308: END IF;
2309: RAISE;

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

2302:
2303: EXCEPTION
2304: WHEN OTHERS THEN
2305: IF PO_LOG.d_exc THEN
2306: PO_LOG.exc(d_mod,0,NULL);
2307: PO_LOG.exc(p_calling_module,0,NULL);
2308: END IF;
2309: RAISE;
2310:

Line 2307: PO_LOG.exc(p_calling_module,0,NULL);

2303: EXCEPTION
2304: WHEN OTHERS THEN
2305: IF PO_LOG.d_exc THEN
2306: PO_LOG.exc(d_mod,0,NULL);
2307: PO_LOG.exc(p_calling_module,0,NULL);
2308: END IF;
2309: RAISE;
2310:
2311: END num1_less_or_equal_num2;

Line 2365: IF PO_LOG.d_proc THEN

2361: l_token2_value_tbl PO_TBL_VARCHAR4000;
2362:
2363: BEGIN
2364:
2365: IF PO_LOG.d_proc THEN
2366: PO_LOG.proc_begin(p_calling_module);
2367: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2368: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);

Line 2366: PO_LOG.proc_begin(p_calling_module);

2362:
2363: BEGIN
2364:
2365: IF PO_LOG.d_proc THEN
2366: PO_LOG.proc_begin(p_calling_module);
2367: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2368: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);

Line 2367: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);

2363: BEGIN
2364:
2365: IF PO_LOG.d_proc THEN
2366: PO_LOG.proc_begin(p_calling_module);
2367: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2368: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);

Line 2368: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);

2364:
2365: IF PO_LOG.d_proc THEN
2366: PO_LOG.proc_begin(p_calling_module);
2367: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2368: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

Line 2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);

2365: IF PO_LOG.d_proc THEN
2366: PO_LOG.proc_begin(p_calling_module);
2367: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2368: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2373: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

Line 2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);

2366: PO_LOG.proc_begin(p_calling_module);
2367: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2368: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2373: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2374: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);

Line 2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);

2367: PO_LOG.proc_begin(d_mod, 'p_value_tbl', p_value_tbl);
2368: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2373: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2374: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2375: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);

Line 2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);

2368: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2373: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2374: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2375: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2376: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);

Line 2373: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);

2369: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2373: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2374: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2375: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2376: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2377: END IF;

Line 2374: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);

2370: PO_LOG.proc_begin(d_mod, 'p_column_name', p_column_name);
2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2373: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2374: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2375: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2376: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2377: END IF;
2378:

Line 2375: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);

2371: PO_LOG.proc_begin(d_mod, 'p_message_name', p_message_name);
2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2373: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2374: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2375: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2376: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2377: END IF;
2378:
2379: IF (x_results IS NULL) THEN

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

2372: PO_LOG.proc_begin(d_mod, 'p_token1_name', p_token1_name);
2373: PO_LOG.proc_begin(d_mod, 'p_token1_value', p_token1_value);
2374: PO_LOG.proc_begin(d_mod, 'p_token2_name', p_token2_name);
2375: PO_LOG.proc_begin(d_mod, 'p_token2_value_tbl', p_token2_value_tbl);
2376: PO_LOG.log(PO_LOG.c_PROC_BEGIN, d_mod, NULL, 'x_results', x_results);
2377: END IF;
2378:
2379: IF (x_results IS NULL) THEN
2380: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 2392: IF PO_LOG.d_stmt THEN

2388: END IF;
2389:
2390: l_results_count := x_results.result_type.COUNT;
2391:
2392: IF PO_LOG.d_stmt THEN
2393: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
2394: END IF;
2395:
2396: FOR i IN 1 .. p_value_tbl.COUNT LOOP

Line 2393: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);

2389:
2390: l_results_count := x_results.result_type.COUNT;
2391:
2392: IF PO_LOG.d_stmt THEN
2393: PO_LOG.stmt(d_mod, 0, 'l_results_count', l_results_count);
2394: END IF;
2395:
2396: FOR i IN 1 .. p_value_tbl.COUNT LOOP
2397: IF (p_value_tbl(i) <> 0) THEN

Line 2417: IF PO_LOG.d_proc THEN

2413: ELSE
2414: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2415: END IF;
2416:
2417: IF PO_LOG.d_proc THEN
2418: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2419: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
2420: PO_LOG.proc_end(p_calling_module);
2421: END IF;

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

2414: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2415: END IF;
2416:
2417: IF PO_LOG.d_proc THEN
2418: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2419: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
2420: PO_LOG.proc_end(p_calling_module);
2421: END IF;
2422:

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

2415: END IF;
2416:
2417: IF PO_LOG.d_proc THEN
2418: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2419: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
2420: PO_LOG.proc_end(p_calling_module);
2421: END IF;
2422:
2423: EXCEPTION

Line 2420: PO_LOG.proc_end(p_calling_module);

2416:
2417: IF PO_LOG.d_proc THEN
2418: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2419: PO_LOG.log(PO_LOG.c_PROC_END, d_mod, NULL, 'x_results', x_results);
2420: PO_LOG.proc_end(p_calling_module);
2421: END IF;
2422:
2423: EXCEPTION
2424: WHEN OTHERS THEN

Line 2425: IF PO_LOG.d_exc THEN

2421: END IF;
2422:
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: IF PO_LOG.d_exc THEN
2426: PO_LOG.exc(d_mod, 0, NULL);
2427: PO_LOG.exc(p_calling_module, 0, NULL);
2428: END IF;
2429: RAISE;

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

2422:
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: IF PO_LOG.d_exc THEN
2426: PO_LOG.exc(d_mod, 0, NULL);
2427: PO_LOG.exc(p_calling_module, 0, NULL);
2428: END IF;
2429: RAISE;
2430:

Line 2427: PO_LOG.exc(p_calling_module, 0, NULL);

2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: IF PO_LOG.d_exc THEN
2426: PO_LOG.exc(d_mod, 0, NULL);
2427: PO_LOG.exc(p_calling_module, 0, NULL);
2428: END IF;
2429: RAISE;
2430:
2431: END zero;

Line 2476: IF PO_LOG.d_proc THEN

2472: IF x_result_set_id IS NULL THEN
2473: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2474: END IF;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_LOG.proc_begin(p_calling_module);
2478: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2479: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2480: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);

Line 2477: PO_LOG.proc_begin(p_calling_module);

2473: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2474: END IF;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_LOG.proc_begin(p_calling_module);
2478: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2479: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2480: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2481: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

Line 2478: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);

2474: END IF;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_LOG.proc_begin(p_calling_module);
2478: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2479: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2480: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2481: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2482: END IF;

Line 2479: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);

2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_LOG.proc_begin(p_calling_module);
2478: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2479: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2480: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2481: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2482: END IF;
2483:

Line 2480: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);

2476: IF PO_LOG.d_proc THEN
2477: PO_LOG.proc_begin(p_calling_module);
2478: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2479: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2480: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2481: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2482: END IF;
2483:
2484: FORALL i IN 1 .. p_entity_id_tbl.COUNT

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

2477: PO_LOG.proc_begin(p_calling_module);
2478: PO_LOG.proc_begin(d_mod, 'p_terms_id_tbl', p_terms_id_tbl);
2479: PO_LOG.proc_begin(d_mod, 'p_entity_id_tbl', p_entity_id_tbl);
2480: PO_LOG.proc_begin(d_mod, 'p_entity_type', p_entity_type);
2481: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2482: END IF;
2483:
2484: FORALL i IN 1 .. p_entity_id_tbl.COUNT
2485: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 2522: IF PO_LOG.d_proc THEN

2518: ELSE
2519: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2520: END IF;
2521:
2522: IF PO_LOG.d_proc THEN
2523: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2524: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2525: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2526: PO_LOG.proc_end(p_calling_module);

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

2520: END IF;
2521:
2522: IF PO_LOG.d_proc THEN
2523: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2524: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2525: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2526: PO_LOG.proc_end(p_calling_module);
2527: END IF;
2528:

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

2521:
2522: IF PO_LOG.d_proc THEN
2523: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2524: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2525: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2526: PO_LOG.proc_end(p_calling_module);
2527: END IF;
2528:
2529: EXCEPTION

Line 2526: PO_LOG.proc_end(p_calling_module);

2522: IF PO_LOG.d_proc THEN
2523: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
2524: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
2525: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
2526: PO_LOG.proc_end(p_calling_module);
2527: END IF;
2528:
2529: EXCEPTION
2530: WHEN OTHERS THEN

Line 2531: IF PO_LOG.d_exc THEN

2527: END IF;
2528:
2529: EXCEPTION
2530: WHEN OTHERS THEN
2531: IF PO_LOG.d_exc THEN
2532: PO_LOG.exc(d_mod, 0, NULL);
2533: PO_LOG.exc(p_calling_module, 0, NULL);
2534: END IF;
2535: RAISE;

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

2528:
2529: EXCEPTION
2530: WHEN OTHERS THEN
2531: IF PO_LOG.d_exc THEN
2532: PO_LOG.exc(d_mod, 0, NULL);
2533: PO_LOG.exc(p_calling_module, 0, NULL);
2534: END IF;
2535: RAISE;
2536:

Line 2533: PO_LOG.exc(p_calling_module, 0, NULL);

2529: EXCEPTION
2530: WHEN OTHERS THEN
2531: IF PO_LOG.d_exc THEN
2532: PO_LOG.exc(d_mod, 0, NULL);
2533: PO_LOG.exc(p_calling_module, 0, NULL);
2534: END IF;
2535: RAISE;
2536:
2537: END terms_id;

Line 2596: IF PO_LOG.d_proc THEN

2592: l_sec_default_ind VARCHAR2(1);
2593:
2594: BEGIN
2595:
2596: IF PO_LOG.d_proc THEN
2597: PO_LOG.proc_begin(p_calling_module);
2598: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2599: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

Line 2597: PO_LOG.proc_begin(p_calling_module);

2593:
2594: BEGIN
2595:
2596: IF PO_LOG.d_proc THEN
2597: PO_LOG.proc_begin(p_calling_module);
2598: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2599: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2601: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

Line 2598: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);

2594: BEGIN
2595:
2596: IF PO_LOG.d_proc THEN
2597: PO_LOG.proc_begin(p_calling_module);
2598: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2599: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2601: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);

Line 2599: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

2595:
2596: IF PO_LOG.d_proc THEN
2597: PO_LOG.proc_begin(p_calling_module);
2598: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2599: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2601: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2603: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

2596: IF PO_LOG.d_proc THEN
2597: PO_LOG.proc_begin(p_calling_module);
2598: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2599: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2601: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2603: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 2601: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

2597: PO_LOG.proc_begin(p_calling_module);
2598: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2599: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2601: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2603: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2605: END IF;

Line 2602: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);

2598: PO_LOG.proc_begin(d_mod,'p_value_tbl',p_value_tbl);
2599: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2601: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2603: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2605: END IF;
2606:

Line 2603: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

2599: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2601: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2603: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2605: END IF;
2606:
2607: l_input_size := p_entity_id_tbl.COUNT;

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

2600: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2601: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2602: PO_LOG.proc_begin(d_mod,'p_inv_org_id_tbl',p_inv_org_id_tbl);
2603: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2604: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2605: END IF;
2606:
2607: l_input_size := p_entity_id_tbl.COUNT;
2608:

Line 2660: IF PO_LOG.d_proc THEN

2656: , x_results => x_results
2657: , x_result_type => x_result_type
2658: );
2659:
2660: IF PO_LOG.d_proc THEN
2661: PO_LOG.proc_end(d_mod);
2662: PO_LOG.proc_end(p_calling_module);
2663: END IF;
2664:

Line 2661: PO_LOG.proc_end(d_mod);

2657: , x_result_type => x_result_type
2658: );
2659:
2660: IF PO_LOG.d_proc THEN
2661: PO_LOG.proc_end(d_mod);
2662: PO_LOG.proc_end(p_calling_module);
2663: END IF;
2664:
2665: EXCEPTION

Line 2662: PO_LOG.proc_end(p_calling_module);

2658: );
2659:
2660: IF PO_LOG.d_proc THEN
2661: PO_LOG.proc_end(d_mod);
2662: PO_LOG.proc_end(p_calling_module);
2663: END IF;
2664:
2665: EXCEPTION
2666: WHEN OTHERS THEN

Line 2667: IF PO_LOG.d_exc THEN

2663: END IF;
2664:
2665: EXCEPTION
2666: WHEN OTHERS THEN
2667: IF PO_LOG.d_exc THEN
2668: PO_LOG.exc(d_mod,0,NULL);
2669: PO_LOG.exc(p_calling_module,0,NULL);
2670: END IF;
2671: RAISE;

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

2664:
2665: EXCEPTION
2666: WHEN OTHERS THEN
2667: IF PO_LOG.d_exc THEN
2668: PO_LOG.exc(d_mod,0,NULL);
2669: PO_LOG.exc(p_calling_module,0,NULL);
2670: END IF;
2671: RAISE;
2672:

Line 2669: PO_LOG.exc(p_calling_module,0,NULL);

2665: EXCEPTION
2666: WHEN OTHERS THEN
2667: IF PO_LOG.d_exc THEN
2668: PO_LOG.exc(d_mod,0,NULL);
2669: PO_LOG.exc(p_calling_module,0,NULL);
2670: END IF;
2671: RAISE;
2672:
2673: END gt_zero_opm_filter;

Line 2744: IF PO_LOG.d_proc THEN

2740: l_sec_default_ind VARCHAR2(1);
2741:
2742: BEGIN
2743:
2744: IF PO_LOG.d_proc THEN
2745: PO_LOG.proc_begin(p_calling_module);
2746: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2747: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2748: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 2745: PO_LOG.proc_begin(p_calling_module);

2741:
2742: BEGIN
2743:
2744: IF PO_LOG.d_proc THEN
2745: PO_LOG.proc_begin(p_calling_module);
2746: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2747: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2748: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2749: END IF;

Line 2746: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

2742: BEGIN
2743:
2744: IF PO_LOG.d_proc THEN
2745: PO_LOG.proc_begin(p_calling_module);
2746: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2747: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2748: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2749: END IF;
2750:

Line 2747: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

2743:
2744: IF PO_LOG.d_proc THEN
2745: PO_LOG.proc_begin(p_calling_module);
2746: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2747: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2748: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2749: END IF;
2750:
2751: IF (x_results IS NULL) THEN

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

2744: IF PO_LOG.d_proc THEN
2745: PO_LOG.proc_begin(p_calling_module);
2746: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
2747: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
2748: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2749: END IF;
2750:
2751: IF (x_results IS NULL) THEN
2752: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 2821: IF PO_LOG.d_proc THEN

2817: ELSE
2818: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2819: END IF;
2820:
2821: IF PO_LOG.d_proc THEN
2822: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2823: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2824: PO_LOG.proc_end(p_calling_module);
2825: END IF;

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

2818: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2819: END IF;
2820:
2821: IF PO_LOG.d_proc THEN
2822: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2823: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2824: PO_LOG.proc_end(p_calling_module);
2825: END IF;
2826:

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

2819: END IF;
2820:
2821: IF PO_LOG.d_proc THEN
2822: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2823: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2824: PO_LOG.proc_end(p_calling_module);
2825: END IF;
2826:
2827: EXCEPTION

Line 2824: PO_LOG.proc_end(p_calling_module);

2820:
2821: IF PO_LOG.d_proc THEN
2822: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2823: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2824: PO_LOG.proc_end(p_calling_module);
2825: END IF;
2826:
2827: EXCEPTION
2828: WHEN OTHERS THEN

Line 2829: IF PO_LOG.d_exc THEN

2825: END IF;
2826:
2827: EXCEPTION
2828: WHEN OTHERS THEN
2829: IF PO_LOG.d_exc THEN
2830: PO_LOG.exc(d_mod,0,NULL);
2831: PO_LOG.exc(p_calling_module,0,NULL);
2832: END IF;
2833: RAISE;

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

2826:
2827: EXCEPTION
2828: WHEN OTHERS THEN
2829: IF PO_LOG.d_exc THEN
2830: PO_LOG.exc(d_mod,0,NULL);
2831: PO_LOG.exc(p_calling_module,0,NULL);
2832: END IF;
2833: RAISE;
2834:

Line 2831: PO_LOG.exc(p_calling_module,0,NULL);

2827: EXCEPTION
2828: WHEN OTHERS THEN
2829: IF PO_LOG.d_exc THEN
2830: PO_LOG.exc(d_mod,0,NULL);
2831: PO_LOG.exc(p_calling_module,0,NULL);
2832: END IF;
2833: RAISE;
2834:
2835: END qtys_within_deviation;

Line 2861: IF PO_LOG.d_proc THEN

2857: l_validation_id NUMBER;
2858:
2859: BEGIN
2860:
2861: IF PO_LOG.d_proc THEN
2862: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2863: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2864: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

Line 2862: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);

2858:
2859: BEGIN
2860:
2861: IF PO_LOG.d_proc THEN
2862: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2863: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2864: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);

Line 2863: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

2859: BEGIN
2860:
2861: IF PO_LOG.d_proc THEN
2862: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2863: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2864: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2867: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);

Line 2864: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);

2860:
2861: IF PO_LOG.d_proc THEN
2862: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2863: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2864: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2867: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2868: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

Line 2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

2861: IF PO_LOG.d_proc THEN
2862: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2863: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2864: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2867: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2868: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2869: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);

Line 2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);

2862: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
2863: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2864: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2867: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2868: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2869: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2870: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 2867: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);

2863: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
2864: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2867: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2868: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2869: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2870: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2871: END IF;

Line 2868: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

2864: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2867: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2868: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2869: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2870: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2871: END IF;
2872:

Line 2869: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);

2865: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2867: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2868: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2869: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2870: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2871: END IF;
2872:
2873: IF (x_results IS NULL) THEN

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

2866: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
2867: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
2868: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2869: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
2870: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2871: END IF;
2872:
2873: IF (x_results IS NULL) THEN
2874: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 2959: IF PO_LOG.d_proc THEN

2955: IF (SQL%ROWCOUNT > 0) THEN
2956: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2957: END IF;
2958:
2959: IF PO_LOG.d_proc THEN
2960: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2961: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2962: END IF;
2963:

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

2956: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2957: END IF;
2958:
2959: IF PO_LOG.d_proc THEN
2960: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2961: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2962: END IF;
2963:
2964: EXCEPTION

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

2957: END IF;
2958:
2959: IF PO_LOG.d_proc THEN
2960: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2961: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2962: END IF;
2963:
2964: EXCEPTION
2965: WHEN OTHERS THEN

Line 2966: IF PO_LOG.d_exc THEN

2962: END IF;
2963:
2964: EXCEPTION
2965: WHEN OTHERS THEN
2966: IF PO_LOG.d_exc THEN
2967: PO_LOG.exc(d_mod,0,NULL);
2968: END IF;
2969: RAISE;
2970:

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

2963:
2964: EXCEPTION
2965: WHEN OTHERS THEN
2966: IF PO_LOG.d_exc THEN
2967: PO_LOG.exc(d_mod,0,NULL);
2968: END IF;
2969: RAISE;
2970:
2971: END secondary_unit_of_measure;

Line 2998: IF PO_LOG.d_proc THEN

2994: d_position NUMBER := 0;
2995:
2996: BEGIN
2997:
2998: IF PO_LOG.d_proc THEN
2999: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3001: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);

Line 2999: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);

2995:
2996: BEGIN
2997:
2998: IF PO_LOG.d_proc THEN
2999: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3001: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

Line 3000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

2996: BEGIN
2997:
2998: IF PO_LOG.d_proc THEN
2999: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3001: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);

Line 3001: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);

2997:
2998: IF PO_LOG.d_proc THEN
2999: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3001: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3005: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);

Line 3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);

2998: IF PO_LOG.d_proc THEN
2999: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3001: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3005: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3006: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

Line 3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

2999: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3001: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3005: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3006: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3007: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);

Line 3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);

3000: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3001: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3005: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3006: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3007: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3008: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 3005: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);

3001: PO_LOG.proc_begin(d_mod,'p_secondary_quantity_tbl',p_secondary_quantity_tbl);
3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3005: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3006: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3007: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3008: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3009: END IF;

Line 3006: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

3002: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3005: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3006: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3007: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3008: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3009: END IF;
3010:

Line 3007: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);

3003: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3005: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3006: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3007: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3008: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3009: END IF;
3010:
3011: IF (x_results IS NULL) THEN

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

3004: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3005: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3006: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3007: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3008: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3009: END IF;
3010:
3011: IF (x_results IS NULL) THEN
3012: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 3151: IF PO_LOG.d_proc THEN

3147: IF (SQL%ROWCOUNT > 0) THEN
3148: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3149: END IF;
3150:
3151: IF PO_LOG.d_proc THEN
3152: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3153: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,d_position,'x_results',x_results);
3154: END IF;
3155:

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

3148: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3149: END IF;
3150:
3151: IF PO_LOG.d_proc THEN
3152: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3153: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,d_position,'x_results',x_results);
3154: END IF;
3155:
3156: EXCEPTION

Line 3153: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,d_position,'x_results',x_results);

3149: END IF;
3150:
3151: IF PO_LOG.d_proc THEN
3152: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3153: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,d_position,'x_results',x_results);
3154: END IF;
3155:
3156: EXCEPTION
3157: WHEN OTHERS THEN

Line 3158: IF PO_LOG.d_exc THEN

3154: END IF;
3155:
3156: EXCEPTION
3157: WHEN OTHERS THEN
3158: IF PO_LOG.d_exc THEN
3159: PO_LOG.exc(d_mod,d_position,'Exception in secondary_quantity');
3160: END IF;
3161: RAISE;
3162:

Line 3159: PO_LOG.exc(d_mod,d_position,'Exception in secondary_quantity');

3155:
3156: EXCEPTION
3157: WHEN OTHERS THEN
3158: IF PO_LOG.d_exc THEN
3159: PO_LOG.exc(d_mod,d_position,'Exception in secondary_quantity');
3160: END IF;
3161: RAISE;
3162:
3163: END secondary_quantity;

Line 3182: IF PO_LOG.d_proc THEN

3178: IS
3179: d_mod CONSTANT VARCHAR2(100) := d_secondary_uom_update;
3180: BEGIN
3181:
3182: IF PO_LOG.d_proc THEN
3183: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3184: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3185: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
3186: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

Line 3183: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);

3179: d_mod CONSTANT VARCHAR2(100) := d_secondary_uom_update;
3180: BEGIN
3181:
3182: IF PO_LOG.d_proc THEN
3183: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3184: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3185: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
3186: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3187: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);

Line 3184: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

3180: BEGIN
3181:
3182: IF PO_LOG.d_proc THEN
3183: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3184: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3185: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
3186: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3187: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3188: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);

Line 3185: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);

3181:
3182: IF PO_LOG.d_proc THEN
3183: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3184: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3185: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
3186: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3187: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3188: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3189: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

Line 3186: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

3182: IF PO_LOG.d_proc THEN
3183: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3184: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3185: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
3186: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3187: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3188: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3189: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3190: END IF;

Line 3187: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);

3183: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3184: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3185: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
3186: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3187: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3188: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3189: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3190: END IF;
3191:

Line 3188: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);

3184: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3185: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
3186: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3187: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3188: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3189: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3190: END IF;
3191:
3192: IF x_result_set_id IS NULL THEN

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

3185: PO_LOG.proc_begin(d_mod,'p_secondary_unit_of_meas_tbl',p_secondary_unit_of_meas_tbl);
3186: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3187: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3188: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3189: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3190: END IF;
3191:
3192: IF x_result_set_id IS NULL THEN
3193: x_result_set_id := po_validations.next_result_set_id();

Line 3239: IF PO_LOG.d_proc THEN

3235: IF (SQL%ROWCOUNT > 0) THEN
3236: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3237: END IF;
3238:
3239: IF PO_LOG.d_proc THEN
3240: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3241: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3242: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3243: END IF;

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

3237: END IF;
3238:
3239: IF PO_LOG.d_proc THEN
3240: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3241: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3242: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3243: END IF;
3244:
3245: EXCEPTION

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

3238:
3239: IF PO_LOG.d_proc THEN
3240: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3241: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3242: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3243: END IF;
3244:
3245: EXCEPTION
3246: WHEN OTHERS THEN

Line 3247: IF PO_LOG.d_exc THEN

3243: END IF;
3244:
3245: EXCEPTION
3246: WHEN OTHERS THEN
3247: IF PO_LOG.d_exc THEN
3248: PO_LOG.exc(d_mod, 0, NULL);
3249: END IF;
3250: RAISE;
3251:

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

3244:
3245: EXCEPTION
3246: WHEN OTHERS THEN
3247: IF PO_LOG.d_exc THEN
3248: PO_LOG.exc(d_mod, 0, NULL);
3249: END IF;
3250: RAISE;
3251:
3252: END secondary_uom_update;

Line 3278: IF PO_LOG.d_proc THEN

3274: d_mod CONSTANT VARCHAR2(100) := d_preferred_grade;
3275: l_validation_id NUMBER;
3276: BEGIN
3277:
3278: IF PO_LOG.d_proc THEN
3279: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3280: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3281: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

Line 3279: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);

3275: l_validation_id NUMBER;
3276: BEGIN
3277:
3278: IF PO_LOG.d_proc THEN
3279: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3280: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3281: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);

Line 3280: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

3276: BEGIN
3277:
3278: IF PO_LOG.d_proc THEN
3279: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3280: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3281: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3284: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);

Line 3281: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);

3277:
3278: IF PO_LOG.d_proc THEN
3279: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3280: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3281: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3284: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3285: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);

Line 3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

3278: IF PO_LOG.d_proc THEN
3279: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3280: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3281: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3284: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3285: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3286: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

Line 3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);

3279: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3280: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3281: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3284: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3285: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3286: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3287: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 3284: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);

3280: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3281: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3284: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3285: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3286: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3287: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3288: END IF;

Line 3285: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);

3281: PO_LOG.proc_begin(d_mod,'p_preferred_grade_tbl',p_preferred_grade_tbl);
3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3284: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3285: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3286: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3287: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3288: END IF;
3289:

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

3282: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3284: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3285: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3286: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3287: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3288: END IF;
3289:
3290: IF x_result_set_id IS NULL THEN

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

3283: PO_LOG.proc_begin(d_mod,'p_item_tbl',p_item_tbl);
3284: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3285: PO_LOG.proc_begin(d_mod,'p_create_or_update_item_flag',p_create_or_update_item_flag);
3286: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3287: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3288: END IF;
3289:
3290: IF x_result_set_id IS NULL THEN
3291: x_result_set_id := po_validations.next_result_set_id();

Line 3386: IF PO_LOG.d_proc THEN

3382: IF (SQL%ROWCOUNT > 0) THEN
3383: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3384: END IF;
3385:
3386: IF PO_LOG.d_proc THEN
3387: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3388: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3389: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3390: END IF;

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

3384: END IF;
3385:
3386: IF PO_LOG.d_proc THEN
3387: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3388: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3389: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3390: END IF;
3391:
3392: EXCEPTION

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

3385:
3386: IF PO_LOG.d_proc THEN
3387: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3388: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3389: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3390: END IF;
3391:
3392: EXCEPTION
3393: WHEN OTHERS THEN

Line 3394: IF PO_LOG.d_exc THEN

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

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

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

Line 3413: IF PO_LOG.d_proc THEN

3409: IS
3410: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;
3411: BEGIN
3412:
3413: IF PO_LOG.d_proc THEN
3414: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3416: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3417: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

Line 3414: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);

3410: d_mod CONSTANT VARCHAR2(100) := d_secondary_unit_of_measure;
3411: BEGIN
3412:
3413: IF PO_LOG.d_proc THEN
3414: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3416: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3417: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3418: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);

Line 3415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

3411: BEGIN
3412:
3413: IF PO_LOG.d_proc THEN
3414: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3416: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3417: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3418: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3419: END IF;

Line 3416: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);

3412:
3413: IF PO_LOG.d_proc THEN
3414: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3416: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3417: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3418: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3419: END IF;
3420:

Line 3417: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

3413: IF PO_LOG.d_proc THEN
3414: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3416: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3417: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3418: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3419: END IF;
3420:
3421: IF x_result_set_id IS NULL THEN

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

3414: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
3415: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3416: PO_LOG.proc_begin(d_mod,'p_ship_to_organization_id_tbl',p_ship_to_organization_id_tbl);
3417: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3418: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3419: END IF;
3420:
3421: IF x_result_set_id IS NULL THEN
3422: x_result_set_id := po_validations.next_result_set_id();

Line 3461: IF PO_LOG.d_proc THEN

3457: IF (SQL%ROWCOUNT > 0) THEN
3458: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
3459: END IF;
3460:
3461: IF PO_LOG.d_proc THEN
3462: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3463: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3464: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3465: END IF;

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

3459: END IF;
3460:
3461: IF PO_LOG.d_proc THEN
3462: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3463: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3464: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3465: END IF;
3466:
3467: EXCEPTION

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

3460:
3461: IF PO_LOG.d_proc THEN
3462: PO_VALIDATIONS.log_validation_results_gt(d_mod, 9, x_result_set_id);
3463: PO_LOG.proc_end(d_mod, 'x_result_type', x_result_type);
3464: PO_LOG.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
3465: END IF;
3466:
3467: EXCEPTION
3468: WHEN OTHERS THEN

Line 3469: IF PO_LOG.d_exc THEN

3465: END IF;
3466:
3467: EXCEPTION
3468: WHEN OTHERS THEN
3469: IF PO_LOG.d_exc THEN
3470: PO_LOG.exc(d_mod, 0, NULL);
3471: END IF;
3472: RAISE;
3473:

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

3466:
3467: EXCEPTION
3468: WHEN OTHERS THEN
3469: IF PO_LOG.d_exc THEN
3470: PO_LOG.exc(d_mod, 0, NULL);
3471: END IF;
3472: RAISE;
3473:
3474: END process_enabled;

Line 3496: IF PO_LOG.d_proc THEN

3492: l_result1_tbl PO_TBL_VARCHAR30;
3493:
3494: BEGIN
3495:
3496: IF PO_LOG.d_proc THEN
3497: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3498: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3499: END IF;
3500:

Line 3497: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

3493:
3494: BEGIN
3495:
3496: IF PO_LOG.d_proc THEN
3497: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3498: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3499: END IF;
3500:
3501: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);

Line 3498: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);

3494: BEGIN
3495:
3496: IF PO_LOG.d_proc THEN
3497: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
3498: PO_LOG.proc_begin(d_mod,'p_organization_id_tbl',p_organization_id_tbl);
3499: END IF;
3500:
3501: l_secondary_unit_of_meas_tbl.extend(p_item_id_tbl.COUNT);
3502:

Line 3527: IF PO_LOG.d_proc THEN

3523: FOR i IN 1..l_index1_tbl.COUNT LOOP
3524: l_secondary_unit_of_meas_tbl(l_index1_tbl(i)) := l_result1_tbl(i);
3525: END LOOP;
3526:
3527: IF PO_LOG.d_proc THEN
3528: PO_LOG.proc_end(d_mod, 'l_secondary_unit_of_meas_tbl', l_secondary_unit_of_meas_tbl);
3529: END IF;
3530:
3531: RETURN l_secondary_unit_of_meas_tbl;

Line 3528: PO_LOG.proc_end(d_mod, 'l_secondary_unit_of_meas_tbl', l_secondary_unit_of_meas_tbl);

3524: l_secondary_unit_of_meas_tbl(l_index1_tbl(i)) := l_result1_tbl(i);
3525: END LOOP;
3526:
3527: IF PO_LOG.d_proc THEN
3528: PO_LOG.proc_end(d_mod, 'l_secondary_unit_of_meas_tbl', l_secondary_unit_of_meas_tbl);
3529: END IF;
3530:
3531: RETURN l_secondary_unit_of_meas_tbl;
3532:

Line 3535: IF PO_LOG.d_exc THEN

3531: RETURN l_secondary_unit_of_meas_tbl;
3532:
3533: EXCEPTION
3534: WHEN OTHERS THEN
3535: IF PO_LOG.d_exc THEN
3536: PO_LOG.exc(d_mod, 0, NULL);
3537: END IF;
3538: RAISE;
3539:

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

3532:
3533: EXCEPTION
3534: WHEN OTHERS THEN
3535: IF PO_LOG.d_exc THEN
3536: PO_LOG.exc(d_mod, 0, NULL);
3537: END IF;
3538: RAISE;
3539:
3540: END get_item_secondary_uom;

Line 3587: IF PO_LOG.d_proc THEN

3583: l_results_count NUMBER;
3584: l_column_val DATE;
3585: BEGIN
3586: currDate := SYSDATE;
3587: IF PO_LOG.d_proc THEN
3588: PO_LOG.proc_begin(p_calling_module);
3589: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3590: PO_LOG.proc_begin(d_mod,'currDate',currDate);
3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

Line 3588: PO_LOG.proc_begin(p_calling_module);

3584: l_column_val DATE;
3585: BEGIN
3586: currDate := SYSDATE;
3587: IF PO_LOG.d_proc THEN
3588: PO_LOG.proc_begin(p_calling_module);
3589: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3590: PO_LOG.proc_begin(d_mod,'currDate',currDate);
3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
3592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

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

3585: BEGIN
3586: currDate := SYSDATE;
3587: IF PO_LOG.d_proc THEN
3588: PO_LOG.proc_begin(p_calling_module);
3589: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3590: PO_LOG.proc_begin(d_mod,'currDate',currDate);
3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
3592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

Line 3590: PO_LOG.proc_begin(d_mod,'currDate',currDate);

3586: currDate := SYSDATE;
3587: IF PO_LOG.d_proc THEN
3588: PO_LOG.proc_begin(p_calling_module);
3589: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3590: PO_LOG.proc_begin(d_mod,'currDate',currDate);
3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
3592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
3594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

Line 3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);

3587: IF PO_LOG.d_proc THEN
3588: PO_LOG.proc_begin(p_calling_module);
3589: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3590: PO_LOG.proc_begin(d_mod,'currDate',currDate);
3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
3592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
3594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
3595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 3592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);

3588: PO_LOG.proc_begin(p_calling_module);
3589: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3590: PO_LOG.proc_begin(d_mod,'currDate',currDate);
3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
3592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
3594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
3595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3596: END IF;

Line 3593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);

3589: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
3590: PO_LOG.proc_begin(d_mod,'currDate',currDate);
3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
3592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
3594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
3595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3596: END IF;
3597:

Line 3594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

3590: PO_LOG.proc_begin(d_mod,'currDate',currDate);
3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
3592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
3594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
3595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3596: END IF;
3597:
3598: IF (x_results IS NULL) THEN

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

3591: PO_LOG.proc_begin(d_mod,'p_entity_id_tbl',p_entity_id_tbl);
3592: PO_LOG.proc_begin(d_mod,'p_entity_type',p_entity_type);
3593: PO_LOG.proc_begin(d_mod,'p_column_name',p_column_name);
3594: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
3595: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
3596: END IF;
3597:
3598: IF (x_results IS NULL) THEN
3599: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 3625: IF PO_LOG.d_proc THEN

3621: ELSE
3622: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3623: END IF;
3624:
3625: IF PO_LOG.d_proc THEN
3626: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3627: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3628: PO_LOG.proc_end(p_calling_module);
3629: END IF;

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

3622: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
3623: END IF;
3624:
3625: IF PO_LOG.d_proc THEN
3626: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3627: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3628: PO_LOG.proc_end(p_calling_module);
3629: END IF;
3630:

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

3623: END IF;
3624:
3625: IF PO_LOG.d_proc THEN
3626: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3627: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3628: PO_LOG.proc_end(p_calling_module);
3629: END IF;
3630:
3631: EXCEPTION

Line 3628: PO_LOG.proc_end(p_calling_module);

3624:
3625: IF PO_LOG.d_proc THEN
3626: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
3627: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
3628: PO_LOG.proc_end(p_calling_module);
3629: END IF;
3630:
3631: EXCEPTION
3632: WHEN OTHERS THEN

Line 3633: IF PO_LOG.d_exc THEN

3629: END IF;
3630:
3631: EXCEPTION
3632: WHEN OTHERS THEN
3633: IF PO_LOG.d_exc THEN
3634: PO_LOG.exc(d_mod,0,NULL);
3635: PO_LOG.exc(p_calling_module,0,NULL);
3636: END IF;
3637: RAISE;

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

3630:
3631: EXCEPTION
3632: WHEN OTHERS THEN
3633: IF PO_LOG.d_exc THEN
3634: PO_LOG.exc(d_mod,0,NULL);
3635: PO_LOG.exc(p_calling_module,0,NULL);
3636: END IF;
3637: RAISE;
3638:

Line 3635: PO_LOG.exc(p_calling_module,0,NULL);

3631: EXCEPTION
3632: WHEN OTHERS THEN
3633: IF PO_LOG.d_exc THEN
3634: PO_LOG.exc(d_mod,0,NULL);
3635: PO_LOG.exc(p_calling_module,0,NULL);
3636: END IF;
3637: RAISE;
3638:
3639: END start_date_ge_sys_date;

Line 3667: IF PO_LOG.d_proc THEN

3663:
3664: d_mod CONSTANT VARCHAR2(100) := D_extract_par_draft_id_tbl;
3665:
3666: BEGIN
3667: IF PO_LOG.d_proc THEN
3668: PO_LOG.proc_begin(d_mod,'p_par_draft_id ',p_par_draft_id);
3669: END IF;
3670:
3671: l_par_draft_id_tbl := po_tbl_number();

Line 3668: PO_LOG.proc_begin(d_mod,'p_par_draft_id ',p_par_draft_id);

3664: d_mod CONSTANT VARCHAR2(100) := D_extract_par_draft_id_tbl;
3665:
3666: BEGIN
3667: IF PO_LOG.d_proc THEN
3668: PO_LOG.proc_begin(d_mod,'p_par_draft_id ',p_par_draft_id);
3669: END IF;
3670:
3671: l_par_draft_id_tbl := po_tbl_number();
3672: FOR context_cur IN