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

APPS.PO_VAL_NOTIFICATION_CONTROLS dependencies on PO_LOG

Line 19: PO_LOG.get_package_base('PO_VAL_NOTIFICATION_CTRL');

15: ---------------------------------------------------------------------------
16:
17: -- The module base for this package.
18: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
19: PO_LOG.get_package_base('PO_VAL_NOTIFICATION_CTRL');
20:
21: -- The module base for the subprogram.
22: D_warning_delay_gt_zero CONSTANT VARCHAR2(100) :=
23: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warning_delay_gt_zero');

Line 23: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warning_delay_gt_zero');

19: PO_LOG.get_package_base('PO_VAL_NOTIFICATION_CTRL');
20:
21: -- The module base for the subprogram.
22: D_warning_delay_gt_zero CONSTANT VARCHAR2(100) :=
23: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warning_delay_gt_zero');
24:
25: -- The module base for the subprogram.
26: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
27: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');

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

23: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'warning_delay_gt_zero');
24:
25: -- The module base for the subprogram.
26: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
27: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
28:
29: -- The module base for the subprogram.
30: D_percent_le_one_hundred CONSTANT VARCHAR2(100) :=
31: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'percent_le_one_hundred');

Line 31: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'percent_le_one_hundred');

27: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
28:
29: -- The module base for the subprogram.
30: D_percent_le_one_hundred CONSTANT VARCHAR2(100) :=
31: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'percent_le_one_hundred');
32:
33: -- The module base for the subprogram.
34: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');

Line 35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');

31: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'percent_le_one_hundred');
32:
33: -- The module base for the subprogram.
34: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
36:
37: D_amount_not_null CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_not_null');
39:

Line 38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_not_null');

34: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
36:
37: D_amount_not_null CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_not_null');
39:
40: D_start_date_active_not_null CONSTANT VARCHAR2(100) :=
41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_active_not_null');
42:

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

37: D_amount_not_null CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_not_null');
39:
40: D_start_date_active_not_null CONSTANT VARCHAR2(100) :=
41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_active_not_null');
42:
43:
44: -------------------------------------------------------------------------
45: -- Check if the start date is less than the end date.

Line 88: IF PO_LOG.d_proc THEN

84: BEGIN
85:
86: -- TODO: change to PO_VALIDATION_HELPER.within_percentage_range
87:
88: IF PO_LOG.d_proc THEN
89: PO_LOG.proc_begin(d_mod,'p_notification_id_tbl',p_notification_id_tbl);
90: PO_LOG.proc_begin(d_mod,'p_notif_qty_percentage_tbl',p_notif_qty_percentage_tbl);
91: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
92: END IF;

Line 89: PO_LOG.proc_begin(d_mod,'p_notification_id_tbl',p_notification_id_tbl);

85:
86: -- TODO: change to PO_VALIDATION_HELPER.within_percentage_range
87:
88: IF PO_LOG.d_proc THEN
89: PO_LOG.proc_begin(d_mod,'p_notification_id_tbl',p_notification_id_tbl);
90: PO_LOG.proc_begin(d_mod,'p_notif_qty_percentage_tbl',p_notif_qty_percentage_tbl);
91: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
92: END IF;
93:

Line 90: PO_LOG.proc_begin(d_mod,'p_notif_qty_percentage_tbl',p_notif_qty_percentage_tbl);

86: -- TODO: change to PO_VALIDATION_HELPER.within_percentage_range
87:
88: IF PO_LOG.d_proc THEN
89: PO_LOG.proc_begin(d_mod,'p_notification_id_tbl',p_notification_id_tbl);
90: PO_LOG.proc_begin(d_mod,'p_notif_qty_percentage_tbl',p_notif_qty_percentage_tbl);
91: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
92: END IF;
93:
94: IF (x_results IS NULL) THEN

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

87:
88: IF PO_LOG.d_proc THEN
89: PO_LOG.proc_begin(d_mod,'p_notification_id_tbl',p_notification_id_tbl);
90: PO_LOG.proc_begin(d_mod,'p_notif_qty_percentage_tbl',p_notif_qty_percentage_tbl);
91: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
92: END IF;
93:
94: IF (x_results IS NULL) THEN
95: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 118: IF PO_LOG.d_proc THEN

114: ELSE
115: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
116: END IF;
117:
118: IF PO_LOG.d_proc THEN
119: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
120: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
121: END IF;
122:

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

115: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
116: END IF;
117:
118: IF PO_LOG.d_proc THEN
119: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
120: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
121: END IF;
122:
123: EXCEPTION

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

116: END IF;
117:
118: IF PO_LOG.d_proc THEN
119: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
120: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
121: END IF;
122:
123: EXCEPTION
124: WHEN OTHERS THEN

Line 125: IF PO_LOG.d_exc THEN

121: END IF;
122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: IF PO_LOG.d_exc THEN
126: PO_LOG.exc(d_mod,0,NULL);
127: END IF;
128: RAISE;
129:

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

122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: IF PO_LOG.d_exc THEN
126: PO_LOG.exc(d_mod,0,NULL);
127: END IF;
128: RAISE;
129:
130: END percent_le_one_hundred;

Line 174: IF PO_LOG.d_proc THEN

170: d_mod CONSTANT VARCHAR2(100) := D_amount_not_null;
171: l_results_count NUMBER;
172: BEGIN
173:
174: IF PO_LOG.d_proc THEN
175: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
176: PO_LOG.proc_begin(d_mod,'p_notif_amount_tbl',p_notif_amount_tbl);
177: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
178: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 175: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);

171: l_results_count NUMBER;
172: BEGIN
173:
174: IF PO_LOG.d_proc THEN
175: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
176: PO_LOG.proc_begin(d_mod,'p_notif_amount_tbl',p_notif_amount_tbl);
177: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
178: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
179: END IF;

Line 176: PO_LOG.proc_begin(d_mod,'p_notif_amount_tbl',p_notif_amount_tbl);

172: BEGIN
173:
174: IF PO_LOG.d_proc THEN
175: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
176: PO_LOG.proc_begin(d_mod,'p_notif_amount_tbl',p_notif_amount_tbl);
177: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
178: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
179: END IF;
180:

Line 177: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);

173:
174: IF PO_LOG.d_proc THEN
175: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
176: PO_LOG.proc_begin(d_mod,'p_notif_amount_tbl',p_notif_amount_tbl);
177: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
178: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
179: END IF;
180:
181: IF (x_results IS NULL) THEN

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

174: IF PO_LOG.d_proc THEN
175: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
176: PO_LOG.proc_begin(d_mod,'p_notif_amount_tbl',p_notif_amount_tbl);
177: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
178: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
179: END IF;
180:
181: IF (x_results IS NULL) THEN
182: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 207: IF PO_LOG.d_proc THEN

203: ELSE
204: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
205: END IF;
206:
207: IF PO_LOG.d_proc THEN
208: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
209: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
210: END IF;
211:

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

204: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
205: END IF;
206:
207: IF PO_LOG.d_proc THEN
208: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
209: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
210: END IF;
211:
212: EXCEPTION

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

205: END IF;
206:
207: IF PO_LOG.d_proc THEN
208: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
209: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
210: END IF;
211:
212: EXCEPTION
213: WHEN OTHERS THEN

Line 214: IF PO_LOG.d_exc THEN

210: END IF;
211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: IF PO_LOG.d_exc THEN
215: PO_LOG.exc(d_mod,0,NULL);
216: END IF;
217: RAISE;
218:

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

211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: IF PO_LOG.d_exc THEN
215: PO_LOG.exc(d_mod,0,NULL);
216: END IF;
217: RAISE;
218:
219: END amount_not_null;

Line 237: IF PO_LOG.d_proc THEN

233: d_mod CONSTANT VARCHAR2(100) := D_start_date_active_not_null;
234: l_results_count NUMBER;
235: BEGIN
236:
237: IF PO_LOG.d_proc THEN
238: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
239: PO_LOG.proc_begin(d_mod,'p_start_date_active_tbl',p_start_date_active_tbl);
240: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
241: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 238: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);

234: l_results_count NUMBER;
235: BEGIN
236:
237: IF PO_LOG.d_proc THEN
238: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
239: PO_LOG.proc_begin(d_mod,'p_start_date_active_tbl',p_start_date_active_tbl);
240: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
241: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
242: END IF;

Line 239: PO_LOG.proc_begin(d_mod,'p_start_date_active_tbl',p_start_date_active_tbl);

235: BEGIN
236:
237: IF PO_LOG.d_proc THEN
238: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
239: PO_LOG.proc_begin(d_mod,'p_start_date_active_tbl',p_start_date_active_tbl);
240: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
241: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
242: END IF;
243:

Line 240: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);

236:
237: IF PO_LOG.d_proc THEN
238: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
239: PO_LOG.proc_begin(d_mod,'p_start_date_active_tbl',p_start_date_active_tbl);
240: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
241: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
242: END IF;
243:
244: IF (x_results IS NULL) THEN

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

237: IF PO_LOG.d_proc THEN
238: PO_LOG.proc_begin(d_mod,'p_notif_id_tbl',p_notif_id_tbl);
239: PO_LOG.proc_begin(d_mod,'p_start_date_active_tbl',p_start_date_active_tbl);
240: PO_LOG.proc_begin(d_mod,'p_notif_condition_code_tbl',p_notif_condition_code_tbl);
241: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
242: END IF;
243:
244: IF (x_results IS NULL) THEN
245: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 270: IF PO_LOG.d_proc THEN

266: ELSE
267: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
268: END IF;
269:
270: IF PO_LOG.d_proc THEN
271: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
272: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
273: END IF;
274:

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

267: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
268: END IF;
269:
270: IF PO_LOG.d_proc THEN
271: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
272: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
273: END IF;
274:
275: EXCEPTION

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

268: END IF;
269:
270: IF PO_LOG.d_proc THEN
271: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
272: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
273: END IF;
274:
275: EXCEPTION
276: WHEN OTHERS THEN

Line 277: IF PO_LOG.d_exc THEN

273: END IF;
274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: IF PO_LOG.d_exc THEN
278: PO_LOG.exc(d_mod,0,NULL);
279: END IF;
280: RAISE;
281:

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

274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: IF PO_LOG.d_exc THEN
278: PO_LOG.exc(d_mod,0,NULL);
279: END IF;
280: RAISE;
281:
282: END start_date_active_not_null;