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_DISTRIBUTIONS dependencies on PO_LOG

Line 31: PO_LOG.get_package_base('PO_VAL_DISTRIBUTIONS');

27: c_AWARD_ID CONSTANT VARCHAR2(30) := 'AWARD_ID';
28:
29: -- The module base for this package.
30: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
31: PO_LOG.get_package_base('PO_VAL_DISTRIBUTIONS');
32:
33: -- The module base for the subprogram.
34: D_dist_num_unique CONSTANT VARCHAR2(100) :=
35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_unique');

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

31: PO_LOG.get_package_base('PO_VAL_DISTRIBUTIONS');
32:
33: -- The module base for the subprogram.
34: D_dist_num_unique CONSTANT VARCHAR2(100) :=
35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_unique');
36:
37: -- The module base for the subprogram.
38: D_dist_num_gt_zero CONSTANT VARCHAR2(100) :=
39: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_gt_zero');

Line 39: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_gt_zero');

35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_unique');
36:
37: -- The module base for the subprogram.
38: D_dist_num_gt_zero CONSTANT VARCHAR2(100) :=
39: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_gt_zero');
40:
41: -- The module base for the subprogram.
42: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
43: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');

Line 43: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');

39: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_gt_zero');
40:
41: -- The module base for the subprogram.
42: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
43: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
44:
45: -- The module base for the subprogram.
46: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
47: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');

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

43: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
44:
45: -- The module base for the subprogram.
46: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
47: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
48:
49: -- The module base for the subprogram.
50: D_check_fv_validations CONSTANT VARCHAR2(100) :=
51: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_fv_validations');

Line 51: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_fv_validations');

47: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
48:
49: -- The module base for the subprogram.
50: D_check_fv_validations CONSTANT VARCHAR2(100) :=
51: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_fv_validations');
52:
53: D_check_proj_rel_validations CONSTANT VARCHAR2(100) :=
54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_proj_related_validations');
55:

Line 54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_proj_related_validations');

50: D_check_fv_validations CONSTANT VARCHAR2(100) :=
51: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_fv_validations');
52:
53: D_check_proj_rel_validations CONSTANT VARCHAR2(100) :=
54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_proj_related_validations');
55:
56: -- : Combine billed/del checks into exec checks
57: -- The module base for the subprogram.
58: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=

Line 59: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');

55:
56: -- : Combine billed/del checks into exec checks
57: -- The module base for the subprogram.
58: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
59: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');
60:
61: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_amount_exec');
63:

Line 62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_amount_exec');

58: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
59: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');
60:
61: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_amount_exec');
63:
64: --
65:
66: D_pjm_unit_number_effective CONSTANT VARCHAR2(100) :=

Line 67: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'pjm_unit_number_effective');

63:
64: --
65:
66: D_pjm_unit_number_effective CONSTANT VARCHAR2(100) :=
67: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'pjm_unit_number_effective');
68:
69: D_oop_enter_all_fields CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'oop_enter_all_fields');
71:

Line 70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'oop_enter_all_fields');

66: D_pjm_unit_number_effective CONSTANT VARCHAR2(100) :=
67: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'pjm_unit_number_effective');
68:
69: D_oop_enter_all_fields CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'oop_enter_all_fields');
71:
72: D_amount_to_encumber_ge_zero CONSTANT VARCHAR2(100) :=
73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_to_encumber_ge_zero');
74: D_budget_account_id_not_null CONSTANT VARCHAR2(100) :=

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

69: D_oop_enter_all_fields CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'oop_enter_all_fields');
71:
72: D_amount_to_encumber_ge_zero CONSTANT VARCHAR2(100) :=
73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_to_encumber_ge_zero');
74: D_budget_account_id_not_null CONSTANT VARCHAR2(100) :=
75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'budget_account_id_not_null');
76: D_gl_encumbered_date_not_null CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'gl_encumbered_date_not_null');

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

71:
72: D_amount_to_encumber_ge_zero CONSTANT VARCHAR2(100) :=
73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_to_encumber_ge_zero');
74: D_budget_account_id_not_null CONSTANT VARCHAR2(100) :=
75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'budget_account_id_not_null');
76: D_gl_encumbered_date_not_null CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'gl_encumbered_date_not_null');
78: D_unencum_amt_le_amt_to_encum CONSTANT VARCHAR2(100) :=
79: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unencum_amt_le_amt_to_encum');

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

73: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_to_encumber_ge_zero');
74: D_budget_account_id_not_null CONSTANT VARCHAR2(100) :=
75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'budget_account_id_not_null');
76: D_gl_encumbered_date_not_null CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'gl_encumbered_date_not_null');
78: D_unencum_amt_le_amt_to_encum CONSTANT VARCHAR2(100) :=
79: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unencum_amt_le_amt_to_encum');
80:
81: -----------------------------------------------------------------------------

Line 79: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unencum_amt_le_amt_to_encum');

75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'budget_account_id_not_null');
76: D_gl_encumbered_date_not_null CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'gl_encumbered_date_not_null');
78: D_unencum_amt_le_amt_to_encum CONSTANT VARCHAR2(100) :=
79: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unencum_amt_le_amt_to_encum');
80:
81: -----------------------------------------------------------------------------
82: -- Validates that all the distribution numbers for a given shipment are
83: -- unique.

Line 187: IF PO_LOG.d_proc THEN

183: IS
184: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
185: BEGIN
186:
187: IF PO_LOG.d_proc THEN
188: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
189: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
190: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
191: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

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

184: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
185: BEGIN
186:
187: IF PO_LOG.d_proc THEN
188: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
189: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
190: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
191: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
192: END IF;

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

185: BEGIN
186:
187: IF PO_LOG.d_proc THEN
188: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
189: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
190: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
191: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
192: END IF;
193:

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

186:
187: IF PO_LOG.d_proc THEN
188: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
189: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
190: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
191: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
192: END IF;
193:
194: IF (x_result_set_id IS NULL) THEN

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

187: IF PO_LOG.d_proc THEN
188: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
189: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
190: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
191: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
192: END IF;
193:
194: IF (x_result_set_id IS NULL) THEN
195: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 257: IF PO_LOG.d_proc THEN

253: ELSE
254: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
255: END IF;
256:
257: IF PO_LOG.d_proc THEN
258: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
259: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
260: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
261: END IF;

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

255: END IF;
256:
257: IF PO_LOG.d_proc THEN
258: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
259: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
260: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
261: END IF;
262:
263: EXCEPTION

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

256:
257: IF PO_LOG.d_proc THEN
258: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
259: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
260: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
261: END IF;
262:
263: EXCEPTION
264: WHEN OTHERS THEN

Line 265: IF PO_LOG.d_exc THEN

261: END IF;
262:
263: EXCEPTION
264: WHEN OTHERS THEN
265: IF PO_LOG.d_exc THEN
266: PO_LOG.exc(d_mod,0,NULL);
267: END IF;
268: RAISE;
269:

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

262:
263: EXCEPTION
264: WHEN OTHERS THEN
265: IF PO_LOG.d_exc THEN
266: PO_LOG.exc(d_mod,0,NULL);
267: END IF;
268: RAISE;
269:
270: END quantity_ge_quantity_exec;

Line 323: IF PO_LOG.d_proc THEN

319: IS
320: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_amount_exec;
321: BEGIN
322:
323: IF PO_LOG.d_proc THEN
324: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
325: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
326: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
327: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 324: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);

320: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_amount_exec;
321: BEGIN
322:
323: IF PO_LOG.d_proc THEN
324: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
325: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
326: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
327: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
328: END IF;

Line 325: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);

321: BEGIN
322:
323: IF PO_LOG.d_proc THEN
324: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
325: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
326: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
327: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
328: END IF;
329:

Line 326: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);

322:
323: IF PO_LOG.d_proc THEN
324: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
325: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
326: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
327: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
328: END IF;
329:
330: IF (x_result_set_id IS NULL) THEN

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

323: IF PO_LOG.d_proc THEN
324: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
325: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
326: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
327: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
328: END IF;
329:
330: IF (x_result_set_id IS NULL) THEN
331: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 391: IF PO_LOG.d_proc THEN

387: ELSE
388: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
389: END IF;
390:
391: IF PO_LOG.d_proc THEN
392: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
393: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
394: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
395: END IF;

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

389: END IF;
390:
391: IF PO_LOG.d_proc THEN
392: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
393: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
394: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
395: END IF;
396:
397: EXCEPTION

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

390:
391: IF PO_LOG.d_proc THEN
392: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
393: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
394: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
395: END IF;
396:
397: EXCEPTION
398: WHEN OTHERS THEN

Line 399: IF PO_LOG.d_exc THEN

395: END IF;
396:
397: EXCEPTION
398: WHEN OTHERS THEN
399: IF PO_LOG.d_exc THEN
400: PO_LOG.exc(d_mod,0,NULL);
401: END IF;
402: RAISE;
403:

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

396:
397: EXCEPTION
398: WHEN OTHERS THEN
399: IF PO_LOG.d_exc THEN
400: PO_LOG.exc(d_mod,0,NULL);
401: END IF;
402: RAISE;
403:
404: END amount_ge_amount_exec;

Line 435: IF PO_LOG.d_proc THEN

431: l_unit_number_effective VARCHAR2(1);
432: l_results_count NUMBER;
433: BEGIN
434:
435: IF PO_LOG.d_proc THEN
436: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
437: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
438: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
439: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);

Line 436: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);

432: l_results_count NUMBER;
433: BEGIN
434:
435: IF PO_LOG.d_proc THEN
436: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
437: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
438: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
439: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
440: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 437: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);

433: BEGIN
434:
435: IF PO_LOG.d_proc THEN
436: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
437: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
438: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
439: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
440: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
441: END IF;

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

434:
435: IF PO_LOG.d_proc THEN
436: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
437: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
438: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
439: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
440: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
441: END IF;
442:

Line 439: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);

435: IF PO_LOG.d_proc THEN
436: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
437: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
438: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
439: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
440: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
441: END IF;
442:
443: IF (x_results IS NULL) THEN

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

436: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
437: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
438: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
439: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
440: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
441: END IF;
442:
443: IF (x_results IS NULL) THEN
444: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 488: IF PO_LOG.d_proc THEN

484: ELSE
485: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
486: END IF;
487:
488: IF PO_LOG.d_proc THEN
489: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
490: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
491: END IF;
492:

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

485: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
486: END IF;
487:
488: IF PO_LOG.d_proc THEN
489: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
490: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
491: END IF;
492:
493: EXCEPTION

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

486: END IF;
487:
488: IF PO_LOG.d_proc THEN
489: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
490: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
491: END IF;
492:
493: EXCEPTION
494: WHEN OTHERS THEN

Line 495: IF PO_LOG.d_exc THEN

491: END IF;
492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: IF PO_LOG.d_exc THEN
496: PO_LOG.exc(d_mod,0,NULL);
497: END IF;
498: RAISE;
499:

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

492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: IF PO_LOG.d_exc THEN
496: PO_LOG.exc(d_mod,0,NULL);
497: END IF;
498: RAISE;
499:
500: END pjm_unit_number_effective;

Line 520: IF PO_LOG.d_proc THEN

516: l_results_count NUMBER;
517: l_outside_operation_flag VARCHAR2(1);
518: BEGIN
519:
520: IF PO_LOG.d_proc THEN
521: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
522: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
523: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);

Line 521: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);

517: l_outside_operation_flag VARCHAR2(1);
518: BEGIN
519:
520: IF PO_LOG.d_proc THEN
521: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
522: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
523: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
525: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);

Line 522: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);

518: BEGIN
519:
520: IF PO_LOG.d_proc THEN
521: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
522: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
523: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
525: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
526: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);

Line 523: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);

519:
520: IF PO_LOG.d_proc THEN
521: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
522: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
523: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
525: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
526: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
527: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);

Line 524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);

520: IF PO_LOG.d_proc THEN
521: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
522: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
523: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
525: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
526: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
527: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 525: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);

521: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
522: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
523: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
525: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
526: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
527: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
529: END IF;

Line 526: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);

522: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
523: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
525: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
526: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
527: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
529: END IF;
530:

Line 527: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);

523: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
525: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
526: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
527: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
529: END IF;
530:
531: IF (x_results IS NULL) THEN

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

524: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
525: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
526: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
527: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
529: END IF;
530:
531: IF (x_results IS NULL) THEN
532: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 606: IF PO_LOG.d_proc THEN

602: ELSE
603: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
604: END IF;
605:
606: IF PO_LOG.d_proc THEN
607: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
608: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
609: END IF;
610:

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

603: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
604: END IF;
605:
606: IF PO_LOG.d_proc THEN
607: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
608: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
609: END IF;
610:
611: EXCEPTION

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

604: END IF;
605:
606: IF PO_LOG.d_proc THEN
607: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
608: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
609: END IF;
610:
611: EXCEPTION
612: WHEN OTHERS THEN

Line 613: IF PO_LOG.d_exc THEN

609: END IF;
610:
611: EXCEPTION
612: WHEN OTHERS THEN
613: IF PO_LOG.d_exc THEN
614: PO_LOG.exc(d_mod,0,NULL);
615: END IF;
616: RAISE;
617:

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

610:
611: EXCEPTION
612: WHEN OTHERS THEN
613: IF PO_LOG.d_exc THEN
614: PO_LOG.exc(d_mod,0,NULL);
615: END IF;
616: RAISE;
617:
618: END oop_enter_all_fields;

Line 903: IF PO_LOG.d_proc THEN

899: l_results_count NUMBER;
900: l_result_type VARCHAR2(30);
901: BEGIN
902:
903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
905: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
906: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
907: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 904: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);

900: l_result_type VARCHAR2(30);
901: BEGIN
902:
903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
905: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
906: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
907: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
908: END IF;

Line 905: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);

901: BEGIN
902:
903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
905: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
906: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
907: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
908: END IF;
909:

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

902:
903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
905: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
906: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
907: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
908: END IF;
909:
910: IF (x_results IS NULL) THEN

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

903: IF PO_LOG.d_proc THEN
904: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
905: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
906: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
907: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
908: END IF;
909:
910: IF (x_results IS NULL) THEN
911: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 985: IF PO_LOG.d_proc THEN

981: ELSE
982: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
983: END IF;
984:
985: IF PO_LOG.d_proc THEN
986: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
987: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
988: END IF;
989:

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

982: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
983: END IF;
984:
985: IF PO_LOG.d_proc THEN
986: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
987: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
988: END IF;
989:
990: EXCEPTION

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

983: END IF;
984:
985: IF PO_LOG.d_proc THEN
986: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
987: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
988: END IF;
989:
990: EXCEPTION
991: WHEN OTHERS THEN

Line 992: IF PO_LOG.d_exc THEN

988: END IF;
989:
990: EXCEPTION
991: WHEN OTHERS THEN
992: IF PO_LOG.d_exc THEN
993: PO_LOG.exc(d_mod,0,NULL);
994: END IF;
995: RAISE;
996:

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

989:
990: EXCEPTION
991: WHEN OTHERS THEN
992: IF PO_LOG.d_exc THEN
993: PO_LOG.exc(d_mod,0,NULL);
994: END IF;
995: RAISE;
996:
997: END check_fv_validations;

Line 1033: IF PO_LOG.d_proc THEN

1029: l_results_count NUMBER;
1030: x_project_reference_enabled NUMBER;
1031: x_project_control_level NUMBER;
1032: BEGIN
1033: IF PO_LOG.d_proc THEN
1034: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1035: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1036: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);

Line 1034: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);

1030: x_project_reference_enabled NUMBER;
1031: x_project_control_level NUMBER;
1032: BEGIN
1033: IF PO_LOG.d_proc THEN
1034: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1035: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1036: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);

Line 1035: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);

1031: x_project_control_level NUMBER;
1032: BEGIN
1033: IF PO_LOG.d_proc THEN
1034: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1035: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1036: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);

Line 1036: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);

1032: BEGIN
1033: IF PO_LOG.d_proc THEN
1034: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1035: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1036: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1040: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);

Line 1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);

1033: IF PO_LOG.d_proc THEN
1034: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1035: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1036: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1040: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1041: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);

Line 1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);

1034: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1035: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1036: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1040: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1041: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1042: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);

Line 1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);

1035: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1036: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1040: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1041: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1042: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1043: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1040: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);

1036: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1040: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1041: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1042: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1043: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1044: END IF;

Line 1041: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);

1037: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1040: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1041: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1042: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1043: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1044: END IF;
1045:

Line 1042: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);

1038: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1040: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1041: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1042: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1043: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1044: END IF;
1045:
1046: IF (x_results IS NULL) THEN

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

1039: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1040: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1041: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1042: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1043: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1044: END IF;
1045:
1046: IF (x_results IS NULL) THEN
1047: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1060: PO_LOG.proc_begin(d_mod,'x_project_reference_enabled',x_project_reference_enabled);

1056: NULL,
1057: x_project_reference_enabled,
1058: x_project_control_level);
1059:
1060: PO_LOG.proc_begin(d_mod,'x_project_reference_enabled',x_project_reference_enabled);
1061: PO_LOG.proc_begin(d_mod,'x_project_control_level',x_project_control_level);
1062: -- Bug 7558385
1063: -- Need to check for PJM Parameters before making Task as mandatory.
1064: IF (p_project_id_tbl(i) IS NOT NULL) AND

Line 1061: PO_LOG.proc_begin(d_mod,'x_project_control_level',x_project_control_level);

1057: x_project_reference_enabled,
1058: x_project_control_level);
1059:
1060: PO_LOG.proc_begin(d_mod,'x_project_reference_enabled',x_project_reference_enabled);
1061: PO_LOG.proc_begin(d_mod,'x_project_control_level',x_project_control_level);
1062: -- Bug 7558385
1063: -- Need to check for PJM Parameters before making Task as mandatory.
1064: IF (p_project_id_tbl(i) IS NOT NULL) AND
1065: (NOT((x_project_reference_enabled = 1 ) and

Line 1144: IF po_log.d_proc THEN

1140: ELSE
1141: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1142: END IF;
1143:
1144: IF po_log.d_proc THEN
1145: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1146: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1147: END IF;
1148:

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

1141: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1142: END IF;
1143:
1144: IF po_log.d_proc THEN
1145: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1146: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1147: END IF;
1148:
1149: EXCEPTION

Line 1146: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);

1142: END IF;
1143:
1144: IF po_log.d_proc THEN
1145: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1146: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1147: END IF;
1148:
1149: EXCEPTION
1150: WHEN OTHERS THEN

Line 1151: IF po_log.d_exc THEN

1147: END IF;
1148:
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: IF po_log.d_exc THEN
1152: po_log.exc(d_mod, 0, NULL);
1153: END IF;
1154:
1155: RAISE;

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

1148:
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: IF po_log.d_exc THEN
1152: po_log.exc(d_mod, 0, NULL);
1153: END IF;
1154:
1155: RAISE;
1156: