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 41: PO_LOG.get_package_base('PO_VAL_DISTRIBUTIONS');

37: c_GROUP_LINE_ID VARCHAR2(30) := 'GROUP_LINE_ID';
38: c_CLM_DEFENCE_FUNDING VARCHAR2(30) := 'CLM_DEFENCE_FUNDING';
39: -- The module base for this package.
40: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
41: PO_LOG.get_package_base('PO_VAL_DISTRIBUTIONS');
42:
43: -- The module base for the subprogram.
44: D_dist_num_unique CONSTANT VARCHAR2(100) :=
45: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_unique');

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

41: PO_LOG.get_package_base('PO_VAL_DISTRIBUTIONS');
42:
43: -- The module base for the subprogram.
44: D_dist_num_unique CONSTANT VARCHAR2(100) :=
45: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_unique');
46:
47: -- The module base for the subprogram.
48: D_dist_num_gt_zero CONSTANT VARCHAR2(100) :=
49: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_gt_zero');

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

45: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_unique');
46:
47: -- The module base for the subprogram.
48: D_dist_num_gt_zero CONSTANT VARCHAR2(100) :=
49: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_gt_zero');
50:
51: -- The module base for the subprogram.
52: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
53: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');

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

49: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'dist_num_gt_zero');
50:
51: -- The module base for the subprogram.
52: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
53: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
54:
55: -- The module base for the subprogram.
56: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
57: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');

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

53: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
54:
55: -- The module base for the subprogram.
56: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
57: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
58:
59: -- The module base for the subprogram.
60: D_check_fv_validations CONSTANT VARCHAR2(100) :=
61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_fv_validations');

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

57: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
58:
59: -- The module base for the subprogram.
60: D_check_fv_validations CONSTANT VARCHAR2(100) :=
61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_fv_validations');
62:
63: D_check_proj_rel_validations CONSTANT VARCHAR2(100) :=
64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_proj_related_validations');
65:

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

60: D_check_fv_validations CONSTANT VARCHAR2(100) :=
61: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_fv_validations');
62:
63: D_check_proj_rel_validations CONSTANT VARCHAR2(100) :=
64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'check_proj_related_validations');
65:
66: -- : Combine billed/del checks into exec checks
67: -- The module base for the subprogram.
68: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=

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

65:
66: -- : Combine billed/del checks into exec checks
67: -- The module base for the subprogram.
68: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
69: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');
70:
71: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_amount_exec');
73:

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

68: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
69: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');
70:
71: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_amount_exec');
73:
74: --
75:
76: D_pjm_unit_number_effective CONSTANT VARCHAR2(100) :=

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

73:
74: --
75:
76: D_pjm_unit_number_effective CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'pjm_unit_number_effective');
78:
79: D_oop_enter_all_fields CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'oop_enter_all_fields');
81:

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

76: D_pjm_unit_number_effective CONSTANT VARCHAR2(100) :=
77: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'pjm_unit_number_effective');
78:
79: D_oop_enter_all_fields CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'oop_enter_all_fields');
81:
82: D_amount_to_encumber_ge_zero CONSTANT VARCHAR2(100) :=
83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_to_encumber_ge_zero');
84: D_budget_account_id_not_null CONSTANT VARCHAR2(100) :=

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

79: D_oop_enter_all_fields CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'oop_enter_all_fields');
81:
82: D_amount_to_encumber_ge_zero CONSTANT VARCHAR2(100) :=
83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_to_encumber_ge_zero');
84: D_budget_account_id_not_null CONSTANT VARCHAR2(100) :=
85: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'budget_account_id_not_null');
86: D_gl_encumbered_date_not_null CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'gl_encumbered_date_not_null');

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

81:
82: D_amount_to_encumber_ge_zero CONSTANT VARCHAR2(100) :=
83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_to_encumber_ge_zero');
84: D_budget_account_id_not_null CONSTANT VARCHAR2(100) :=
85: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'budget_account_id_not_null');
86: D_gl_encumbered_date_not_null CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'gl_encumbered_date_not_null');
88: D_unencum_amt_le_amt_to_encum CONSTANT VARCHAR2(100) :=
89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unencum_amt_le_amt_to_encum');

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

83: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_to_encumber_ge_zero');
84: D_budget_account_id_not_null CONSTANT VARCHAR2(100) :=
85: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'budget_account_id_not_null');
86: D_gl_encumbered_date_not_null CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'gl_encumbered_date_not_null');
88: D_unencum_amt_le_amt_to_encum CONSTANT VARCHAR2(100) :=
89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unencum_amt_le_amt_to_encum');
90:
91: /* CLM Partial Funding Changes -- START */

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

85: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'budget_account_id_not_null');
86: D_gl_encumbered_date_not_null CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'gl_encumbered_date_not_null');
88: D_unencum_amt_le_amt_to_encum CONSTANT VARCHAR2(100) :=
89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unencum_amt_le_amt_to_encum');
90:
91: /* CLM Partial Funding Changes -- START */
92: D_funded_value_ge_zero CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_value_ge_zero');

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

89: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unencum_amt_le_amt_to_encum');
90:
91: /* CLM Partial Funding Changes -- START */
92: D_funded_value_ge_zero CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_value_ge_zero');
94: D_funded_val_le_tot_order_val CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_val_le_tot_order_val');
96: D_qty_funded_ge_exc_qty CONSTANT VARCHAR2(100) :=
97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_funded_ge_exc_qty');

Line 95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_val_le_tot_order_val');

91: /* CLM Partial Funding Changes -- START */
92: D_funded_value_ge_zero CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_value_ge_zero');
94: D_funded_val_le_tot_order_val CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_val_le_tot_order_val');
96: D_qty_funded_ge_exc_qty CONSTANT VARCHAR2(100) :=
97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_funded_ge_exc_qty');
98: D_amount_funded_ge_exc_amount CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_funded_ge_exc_amount');

Line 97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_funded_ge_exc_qty');

93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_value_ge_zero');
94: D_funded_val_le_tot_order_val CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_val_le_tot_order_val');
96: D_qty_funded_ge_exc_qty CONSTANT VARCHAR2(100) :=
97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_funded_ge_exc_qty');
98: D_amount_funded_ge_exc_amount CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_funded_ge_exc_amount');
100: D_funded_value_gt_backing_req CONSTANT VARCHAR2(100) :=
101: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_value_gt_backing_req');

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

95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_val_le_tot_order_val');
96: D_qty_funded_ge_exc_qty CONSTANT VARCHAR2(100) :=
97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_funded_ge_exc_qty');
98: D_amount_funded_ge_exc_amount CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_funded_ge_exc_amount');
100: D_funded_value_gt_backing_req CONSTANT VARCHAR2(100) :=
101: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_value_gt_backing_req');
102: /* CLM Partial Funding Changes -- END */
103:

Line 101: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_value_gt_backing_req');

97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_funded_ge_exc_qty');
98: D_amount_funded_ge_exc_amount CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_funded_ge_exc_amount');
100: D_funded_value_gt_backing_req CONSTANT VARCHAR2(100) :=
101: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_value_gt_backing_req');
102: /* CLM Partial Funding Changes -- END */
103:
104: -- CLM-LnSc
105: D_funded_val_gt_req_funds_rmn CONSTANT VARCHAR2(100) :=

Line 106: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_val_gt_req_funds_rmn');

102: /* CLM Partial Funding Changes -- END */
103:
104: -- CLM-LnSc
105: D_funded_val_gt_req_funds_rmn CONSTANT VARCHAR2(100) :=
106: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_val_gt_req_funds_rmn');
107:
108: --CLM PDOI Integration
109: D_check_clin_slin_funding CONSTANT VARCHAR2(100) :=
110: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_clin_slin_funding');

Line 110: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_clin_slin_funding');

106: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'funded_val_gt_req_funds_rmn');
107:
108: --CLM PDOI Integration
109: D_check_clin_slin_funding CONSTANT VARCHAR2(100) :=
110: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_clin_slin_funding');
111: D_validate_defence_funding CONSTANT VARCHAR2(100) :=
112: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_defence_funding');
113: D_validate_option_distribution CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_option_distribution');

Line 112: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_defence_funding');

108: --CLM PDOI Integration
109: D_check_clin_slin_funding CONSTANT VARCHAR2(100) :=
110: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_clin_slin_funding');
111: D_validate_defence_funding CONSTANT VARCHAR2(100) :=
112: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_defence_funding');
113: D_validate_option_distribution CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_option_distribution');
115: D_check_dist_val_inc_for_par CONSTANT VARCHAR2(100) :=
116: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_dist_val_inc_for_par');

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

110: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_clin_slin_funding');
111: D_validate_defence_funding CONSTANT VARCHAR2(100) :=
112: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_defence_funding');
113: D_validate_option_distribution CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_option_distribution');
115: D_check_dist_val_inc_for_par CONSTANT VARCHAR2(100) :=
116: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_dist_val_inc_for_par');
117:
118: -----------------------------------------------------------------------------

Line 116: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_dist_val_inc_for_par');

112: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_defence_funding');
113: D_validate_option_distribution CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'validate_option_distribution');
115: D_check_dist_val_inc_for_par CONSTANT VARCHAR2(100) :=
116: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'check_dist_val_inc_for_par');
117:
118: -----------------------------------------------------------------------------
119: -- Validates that all the distribution numbers for a given shipment are
120: -- unique.

Line 244: IF PO_LOG.d_proc THEN

240: IS
241: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
242: BEGIN
243:
244: IF PO_LOG.d_proc THEN
245: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
246: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
247: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
248: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

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

241: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
242: BEGIN
243:
244: IF PO_LOG.d_proc THEN
245: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
246: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
247: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
248: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
249: END IF;

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

242: BEGIN
243:
244: IF PO_LOG.d_proc THEN
245: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
246: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
247: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
248: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
249: END IF;
250:

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

243:
244: IF PO_LOG.d_proc THEN
245: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
246: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
247: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
248: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
249: END IF;
250:
251: IF (x_result_set_id IS NULL) THEN

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

244: IF PO_LOG.d_proc THEN
245: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
246: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
247: PO_LOG.proc_begin(d_mod,'p_qty_ordered_tbl',p_qty_ordered_tbl);
248: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
249: END IF;
250:
251: IF (x_result_set_id IS NULL) THEN
252: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 314: IF PO_LOG.d_proc THEN

310: ELSE
311: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
312: END IF;
313:
314: IF PO_LOG.d_proc THEN
315: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
316: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
317: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
318: END IF;

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

312: END IF;
313:
314: IF PO_LOG.d_proc THEN
315: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
316: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
317: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
318: END IF;
319:
320: EXCEPTION

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

313:
314: IF PO_LOG.d_proc THEN
315: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
316: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
317: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
318: END IF;
319:
320: EXCEPTION
321: WHEN OTHERS THEN

Line 322: IF PO_LOG.d_exc THEN

318: END IF;
319:
320: EXCEPTION
321: WHEN OTHERS THEN
322: IF PO_LOG.d_exc THEN
323: PO_LOG.exc(d_mod,0,NULL);
324: END IF;
325: RAISE;
326:

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

319:
320: EXCEPTION
321: WHEN OTHERS THEN
322: IF PO_LOG.d_exc THEN
323: PO_LOG.exc(d_mod,0,NULL);
324: END IF;
325: RAISE;
326:
327: END quantity_ge_quantity_exec;

Line 396: IF PO_LOG.d_proc THEN

392: IS
393: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_amount_exec;
394: BEGIN
395:
396: IF PO_LOG.d_proc THEN
397: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
398: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
399: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
400: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

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

393: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_amount_exec;
394: BEGIN
395:
396: IF PO_LOG.d_proc THEN
397: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
398: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
399: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
400: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
401: END IF;

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

394: BEGIN
395:
396: IF PO_LOG.d_proc THEN
397: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
398: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
399: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
400: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
401: END IF;
402:

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

395:
396: IF PO_LOG.d_proc THEN
397: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
398: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
399: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
400: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
401: END IF;
402:
403: IF (x_result_set_id IS NULL) THEN

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

396: IF PO_LOG.d_proc THEN
397: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
398: PO_LOG.proc_begin(d_mod,'p_dist_type_tbl',p_dist_type_tbl);
399: PO_LOG.proc_begin(d_mod,'p_amt_ordered_tbl',p_amt_ordered_tbl);
400: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
401: END IF;
402:
403: IF (x_result_set_id IS NULL) THEN
404: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 464: IF PO_LOG.d_proc THEN

460: ELSE
461: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
462: END IF;
463:
464: IF PO_LOG.d_proc THEN
465: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
466: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
467: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
468: END IF;

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

462: END IF;
463:
464: IF PO_LOG.d_proc THEN
465: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
466: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
467: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
468: END IF;
469:
470: EXCEPTION

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

463:
464: IF PO_LOG.d_proc THEN
465: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
466: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
467: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
468: END IF;
469:
470: EXCEPTION
471: WHEN OTHERS THEN

Line 472: IF PO_LOG.d_exc THEN

468: END IF;
469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: IF PO_LOG.d_exc THEN
473: PO_LOG.exc(d_mod,0,NULL);
474: END IF;
475: RAISE;
476:

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

469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: IF PO_LOG.d_exc THEN
473: PO_LOG.exc(d_mod,0,NULL);
474: END IF;
475: RAISE;
476:
477: END amount_ge_amount_exec;

Line 509: IF PO_LOG.d_proc THEN

505: l_unit_number_effective VARCHAR2(1);
506: l_results_count NUMBER;
507: BEGIN
508:
509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
512: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
513: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);

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

506: l_results_count NUMBER;
507: BEGIN
508:
509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
512: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
513: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

507: BEGIN
508:
509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
512: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
513: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;

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

508:
509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
512: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
513: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;
516:

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

509: IF PO_LOG.d_proc THEN
510: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
512: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
513: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;
516:
517: IF (x_results IS NULL) THEN

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

510: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
511: PO_LOG.proc_begin(d_mod,'p_end_item_unit_number_tbl',p_end_item_unit_number_tbl);
512: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
513: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
514: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
515: END IF;
516:
517: IF (x_results IS NULL) THEN
518: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 562: IF PO_LOG.d_proc THEN

558: ELSE
559: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
560: END IF;
561:
562: IF PO_LOG.d_proc THEN
563: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
564: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
565: END IF;
566:

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

559: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
560: END IF;
561:
562: IF PO_LOG.d_proc THEN
563: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
564: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
565: END IF;
566:
567: EXCEPTION

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

560: END IF;
561:
562: IF PO_LOG.d_proc THEN
563: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
564: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
565: END IF;
566:
567: EXCEPTION
568: WHEN OTHERS THEN

Line 569: IF PO_LOG.d_exc THEN

565: END IF;
566:
567: EXCEPTION
568: WHEN OTHERS THEN
569: IF PO_LOG.d_exc THEN
570: PO_LOG.exc(d_mod,0,NULL);
571: END IF;
572: RAISE;
573:

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

566:
567: EXCEPTION
568: WHEN OTHERS THEN
569: IF PO_LOG.d_exc THEN
570: PO_LOG.exc(d_mod,0,NULL);
571: END IF;
572: RAISE;
573:
574: END pjm_unit_number_effective;

Line 594: IF PO_LOG.d_proc THEN

590: l_results_count NUMBER;
591: l_outside_operation_flag VARCHAR2(1);
592: BEGIN
593:
594: IF PO_LOG.d_proc THEN
595: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
596: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
597: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
598: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);

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

591: l_outside_operation_flag VARCHAR2(1);
592: BEGIN
593:
594: IF PO_LOG.d_proc THEN
595: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
596: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
597: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
598: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
599: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);

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

592: BEGIN
593:
594: IF PO_LOG.d_proc THEN
595: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
596: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
597: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
598: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
599: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
600: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);

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

593:
594: IF PO_LOG.d_proc THEN
595: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
596: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
597: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
598: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
599: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
600: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
601: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);

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

594: IF PO_LOG.d_proc THEN
595: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
596: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
597: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
598: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
599: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
600: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
601: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
602: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

595: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
596: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
597: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
598: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
599: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
600: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
601: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
602: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
603: END IF;

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

596: PO_LOG.proc_begin(d_mod,'p_line_line_type_id_tbl',p_line_line_type_id_tbl);
597: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
598: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
599: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
600: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
601: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
602: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
603: END IF;
604:

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

597: PO_LOG.proc_begin(d_mod,'p_wip_entity_id_tbl',p_wip_entity_id_tbl);
598: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
599: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
600: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
601: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
602: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
603: END IF;
604:
605: IF (x_results IS NULL) THEN

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

598: PO_LOG.proc_begin(d_mod,'p_wip_line_id_tbl',p_wip_line_id_tbl);
599: PO_LOG.proc_begin(d_mod,'p_wip_operation_seq_num_tbl',p_wip_operation_seq_num_tbl);
600: PO_LOG.proc_begin(d_mod,'p_destination_type_code_tbl',p_destination_type_code_tbl);
601: PO_LOG.proc_begin(d_mod,'p_wip_resource_seq_num_tbl',p_wip_resource_seq_num_tbl);
602: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
603: END IF;
604:
605: IF (x_results IS NULL) THEN
606: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 680: IF PO_LOG.d_proc THEN

676: ELSE
677: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
678: END IF;
679:
680: IF PO_LOG.d_proc THEN
681: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
682: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
683: END IF;
684:

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

677: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
678: END IF;
679:
680: IF PO_LOG.d_proc THEN
681: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
682: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
683: END IF;
684:
685: EXCEPTION

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

678: END IF;
679:
680: IF PO_LOG.d_proc THEN
681: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
682: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
683: END IF;
684:
685: EXCEPTION
686: WHEN OTHERS THEN

Line 687: IF PO_LOG.d_exc THEN

683: END IF;
684:
685: EXCEPTION
686: WHEN OTHERS THEN
687: IF PO_LOG.d_exc THEN
688: PO_LOG.exc(d_mod,0,NULL);
689: END IF;
690: RAISE;
691:

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

684:
685: EXCEPTION
686: WHEN OTHERS THEN
687: IF PO_LOG.d_exc THEN
688: PO_LOG.exc(d_mod,0,NULL);
689: END IF;
690: RAISE;
691:
692: END oop_enter_all_fields;

Line 996: IF PO_LOG.d_proc THEN

992: l_results_count NUMBER;
993: l_result_type VARCHAR2(30);
994: BEGIN
995:
996: IF PO_LOG.d_proc THEN
997: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
998: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
999: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1000: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

993: l_result_type VARCHAR2(30);
994: BEGIN
995:
996: IF PO_LOG.d_proc THEN
997: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
998: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
999: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1000: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1001: END IF;

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

994: BEGIN
995:
996: IF PO_LOG.d_proc THEN
997: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
998: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
999: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1000: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1001: END IF;
1002:

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

995:
996: IF PO_LOG.d_proc THEN
997: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
998: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
999: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1000: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1001: END IF;
1002:
1003: IF (x_results IS NULL) THEN

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

996: IF PO_LOG.d_proc THEN
997: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
998: PO_LOG.proc_begin(d_mod,'p_ccid_tbl',p_ccid_tbl);
999: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1000: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1001: END IF;
1002:
1003: IF (x_results IS NULL) THEN
1004: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1078: IF PO_LOG.d_proc THEN

1074: ELSE
1075: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1076: END IF;
1077:
1078: IF PO_LOG.d_proc THEN
1079: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1080: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1081: END IF;
1082:

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

1075: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1076: END IF;
1077:
1078: IF PO_LOG.d_proc THEN
1079: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1080: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1081: END IF;
1082:
1083: EXCEPTION

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

1076: END IF;
1077:
1078: IF PO_LOG.d_proc THEN
1079: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1080: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1081: END IF;
1082:
1083: EXCEPTION
1084: WHEN OTHERS THEN

Line 1085: IF PO_LOG.d_exc THEN

1081: END IF;
1082:
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: IF PO_LOG.d_exc THEN
1086: PO_LOG.exc(d_mod,0,NULL);
1087: END IF;
1088: RAISE;
1089:

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

1082:
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: IF PO_LOG.d_exc THEN
1086: PO_LOG.exc(d_mod,0,NULL);
1087: END IF;
1088: RAISE;
1089:
1090: END check_fv_validations;

Line 1114: IF PO_LOG.d_proc THEN

1110: l_results_count NUMBER;
1111: l_is_clm_enabled VARCHAR2(1);
1112: BEGIN
1113:
1114: IF PO_LOG.d_proc THEN
1115: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1116: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1117: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1118: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);

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

1111: l_is_clm_enabled VARCHAR2(1);
1112: BEGIN
1113:
1114: IF PO_LOG.d_proc THEN
1115: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1116: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1117: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1118: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1119: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);

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

1112: BEGIN
1113:
1114: IF PO_LOG.d_proc THEN
1115: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1116: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1117: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1118: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1119: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1120: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1117: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);

1113:
1114: IF PO_LOG.d_proc THEN
1115: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1116: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1117: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1118: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1119: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1120: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1121: END IF;

Line 1118: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);

1114: IF PO_LOG.d_proc THEN
1115: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1116: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1117: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1118: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1119: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1120: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1121: END IF;
1122:

Line 1119: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);

1115: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1116: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1117: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1118: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1119: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1120: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1121: END IF;
1122:
1123: IF (x_results IS NULL) THEN

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

1116: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1117: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1118: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1119: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1120: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1121: END IF;
1122:
1123: IF (x_results IS NULL) THEN
1124: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1156: IF PO_LOG.d_proc THEN

1152: ELSE
1153: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1154: END IF;
1155:
1156: IF PO_LOG.d_proc THEN
1157: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1158: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1159: END IF;
1160:

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

1153: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1154: END IF;
1155:
1156: IF PO_LOG.d_proc THEN
1157: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1158: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1159: END IF;
1160:
1161: EXCEPTION

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

1154: END IF;
1155:
1156: IF PO_LOG.d_proc THEN
1157: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1158: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1159: END IF;
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN

Line 1163: IF PO_LOG.d_exc THEN

1159: END IF;
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: IF PO_LOG.d_exc THEN
1164: PO_LOG.exc(d_mod,0,NULL);
1165: END IF;
1166: RAISE;
1167:

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

1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: IF PO_LOG.d_exc THEN
1164: PO_LOG.exc(d_mod,0,NULL);
1165: END IF;
1166: RAISE;
1167:
1168: END funded_value_ge_zero;

Line 1206: IF PO_LOG.d_proc THEN

1202:
1203:
1204: BEGIN
1205:
1206: IF PO_LOG.d_proc THEN
1207: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1208: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1209: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);

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

1203:
1204: BEGIN
1205:
1206: IF PO_LOG.d_proc THEN
1207: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1208: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1209: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);

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

1204: BEGIN
1205:
1206: IF PO_LOG.d_proc THEN
1207: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1208: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1209: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);

Line 1209: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);

1205:
1206: IF PO_LOG.d_proc THEN
1207: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1208: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1209: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);
1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);

Line 1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);

1206: IF PO_LOG.d_proc THEN
1207: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1208: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1209: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);
1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);
1214: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);

Line 1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);

1207: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1208: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1209: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);
1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);
1214: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1215: PO_LOG.proc_begin(d_mod,'p_nonrecoverable_tax_tbl',p_nonrecoverable_tax_tbl);

Line 1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);

1208: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1209: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);
1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);
1214: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1215: PO_LOG.proc_begin(d_mod,'p_nonrecoverable_tax_tbl',p_nonrecoverable_tax_tbl);
1216: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);

Line 1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);

1209: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);
1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);
1214: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1215: PO_LOG.proc_begin(d_mod,'p_nonrecoverable_tax_tbl',p_nonrecoverable_tax_tbl);
1216: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
1217: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1214: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);

1210: PO_LOG.proc_begin(d_mod,'p_partial_funded_flag_tbl',p_partial_funded_flag_tbl);
1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);
1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);
1214: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1215: PO_LOG.proc_begin(d_mod,'p_nonrecoverable_tax_tbl',p_nonrecoverable_tax_tbl);
1216: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
1217: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1218: END IF;

Line 1215: PO_LOG.proc_begin(d_mod,'p_nonrecoverable_tax_tbl',p_nonrecoverable_tax_tbl);

1211: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);
1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);
1214: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1215: PO_LOG.proc_begin(d_mod,'p_nonrecoverable_tax_tbl',p_nonrecoverable_tax_tbl);
1216: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
1217: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1218: END IF;
1219:

Line 1216: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);

1212: PO_LOG.proc_begin(d_mod,'p_quantity_ordered_tbl',p_quantity_ordered_tbl);
1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);
1214: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1215: PO_LOG.proc_begin(d_mod,'p_nonrecoverable_tax_tbl',p_nonrecoverable_tax_tbl);
1216: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
1217: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1218: END IF;
1219:
1220: IF (x_results IS NULL) THEN

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

1213: PO_LOG.proc_begin(d_mod,'p_amount_ordered_tbl',p_amount_ordered_tbl);
1214: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1215: PO_LOG.proc_begin(d_mod,'p_nonrecoverable_tax_tbl',p_nonrecoverable_tax_tbl);
1216: PO_LOG.proc_begin(d_mod,'p_rate_tbl',p_rate_tbl);
1217: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1218: END IF;
1219:
1220: IF (x_results IS NULL) THEN
1221: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1294: IF PO_LOG.d_proc THEN

1290: ELSE
1291: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1292: END IF;
1293:
1294: IF PO_LOG.d_proc THEN
1295: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1296: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1297: END IF;
1298:

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

1291: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1292: END IF;
1293:
1294: IF PO_LOG.d_proc THEN
1295: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1296: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1297: END IF;
1298:
1299: EXCEPTION

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

1292: END IF;
1293:
1294: IF PO_LOG.d_proc THEN
1295: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1296: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1297: END IF;
1298:
1299: EXCEPTION
1300: WHEN OTHERS THEN

Line 1301: IF PO_LOG.d_exc THEN

1297: END IF;
1298:
1299: EXCEPTION
1300: WHEN OTHERS THEN
1301: IF PO_LOG.d_exc THEN
1302: PO_LOG.exc(d_mod,0,NULL);
1303: END IF;
1304: RAISE;
1305:

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

1298:
1299: EXCEPTION
1300: WHEN OTHERS THEN
1301: IF PO_LOG.d_exc THEN
1302: PO_LOG.exc(d_mod,0,NULL);
1303: END IF;
1304: RAISE;
1305:
1306: END funded_val_le_tot_order_val;

Line 1331: IF PO_LOG.d_proc THEN

1327: l_results_count NUMBER;
1328: l_is_clm_enabled VARCHAR2(1);
1329: BEGIN
1330:
1331: IF PO_LOG.d_proc THEN
1332: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1333: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1334: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1335: PO_LOG.proc_begin(d_mod,'p_quantity_funded_tbl',p_quantity_funded_tbl);

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

1328: l_is_clm_enabled VARCHAR2(1);
1329: BEGIN
1330:
1331: IF PO_LOG.d_proc THEN
1332: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1333: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1334: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1335: PO_LOG.proc_begin(d_mod,'p_quantity_funded_tbl',p_quantity_funded_tbl);
1336: PO_LOG.proc_begin(d_mod,'p_quantity_billed_tbl',p_quantity_billed_tbl);

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

1329: BEGIN
1330:
1331: IF PO_LOG.d_proc THEN
1332: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1333: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1334: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1335: PO_LOG.proc_begin(d_mod,'p_quantity_funded_tbl',p_quantity_funded_tbl);
1336: PO_LOG.proc_begin(d_mod,'p_quantity_billed_tbl',p_quantity_billed_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_quantity_delivered_tbl',p_quantity_delivered_tbl);

Line 1334: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);

1330:
1331: IF PO_LOG.d_proc THEN
1332: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1333: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1334: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1335: PO_LOG.proc_begin(d_mod,'p_quantity_funded_tbl',p_quantity_funded_tbl);
1336: PO_LOG.proc_begin(d_mod,'p_quantity_billed_tbl',p_quantity_billed_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_quantity_delivered_tbl',p_quantity_delivered_tbl);
1338: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1335: PO_LOG.proc_begin(d_mod,'p_quantity_funded_tbl',p_quantity_funded_tbl);

1331: IF PO_LOG.d_proc THEN
1332: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1333: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1334: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1335: PO_LOG.proc_begin(d_mod,'p_quantity_funded_tbl',p_quantity_funded_tbl);
1336: PO_LOG.proc_begin(d_mod,'p_quantity_billed_tbl',p_quantity_billed_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_quantity_delivered_tbl',p_quantity_delivered_tbl);
1338: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1339: END IF;

Line 1336: PO_LOG.proc_begin(d_mod,'p_quantity_billed_tbl',p_quantity_billed_tbl);

1332: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1333: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1334: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1335: PO_LOG.proc_begin(d_mod,'p_quantity_funded_tbl',p_quantity_funded_tbl);
1336: PO_LOG.proc_begin(d_mod,'p_quantity_billed_tbl',p_quantity_billed_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_quantity_delivered_tbl',p_quantity_delivered_tbl);
1338: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1339: END IF;
1340:

Line 1337: PO_LOG.proc_begin(d_mod,'p_quantity_delivered_tbl',p_quantity_delivered_tbl);

1333: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1334: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1335: PO_LOG.proc_begin(d_mod,'p_quantity_funded_tbl',p_quantity_funded_tbl);
1336: PO_LOG.proc_begin(d_mod,'p_quantity_billed_tbl',p_quantity_billed_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_quantity_delivered_tbl',p_quantity_delivered_tbl);
1338: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1339: END IF;
1340:
1341: IF (x_results IS NULL) THEN

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

1334: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1335: PO_LOG.proc_begin(d_mod,'p_quantity_funded_tbl',p_quantity_funded_tbl);
1336: PO_LOG.proc_begin(d_mod,'p_quantity_billed_tbl',p_quantity_billed_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_quantity_delivered_tbl',p_quantity_delivered_tbl);
1338: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1339: END IF;
1340:
1341: IF (x_results IS NULL) THEN
1342: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1388: IF PO_LOG.d_proc THEN

1384: ELSE
1385: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1386: END IF;
1387:
1388: IF PO_LOG.d_proc THEN
1389: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1390: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1391: END IF;
1392:

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

1385: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1386: END IF;
1387:
1388: IF PO_LOG.d_proc THEN
1389: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1390: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1391: END IF;
1392:
1393: EXCEPTION

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

1386: END IF;
1387:
1388: IF PO_LOG.d_proc THEN
1389: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1390: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1391: END IF;
1392:
1393: EXCEPTION
1394: WHEN OTHERS THEN

Line 1395: IF PO_LOG.d_exc THEN

1391: END IF;
1392:
1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: IF PO_LOG.d_exc THEN
1396: PO_LOG.exc(d_mod,0,NULL);
1397: END IF;
1398: RAISE;
1399:

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

1392:
1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: IF PO_LOG.d_exc THEN
1396: PO_LOG.exc(d_mod,0,NULL);
1397: END IF;
1398: RAISE;
1399:
1400: END qty_funded_ge_exc_qty;

Line 1426: IF PO_LOG.d_proc THEN

1422: l_results_count NUMBER;
1423: l_is_clm_enabled VARCHAR2(1);
1424: BEGIN
1425:
1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1428: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1429: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1430: PO_LOG.proc_begin(d_mod,'p_amount_funded_tbl',p_amount_funded_tbl);

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

1423: l_is_clm_enabled VARCHAR2(1);
1424: BEGIN
1425:
1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1428: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1429: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1430: PO_LOG.proc_begin(d_mod,'p_amount_funded_tbl',p_amount_funded_tbl);
1431: PO_LOG.proc_begin(d_mod,'p_amount_billed_tbl',p_amount_billed_tbl);

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

1424: BEGIN
1425:
1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1428: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1429: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1430: PO_LOG.proc_begin(d_mod,'p_amount_funded_tbl',p_amount_funded_tbl);
1431: PO_LOG.proc_begin(d_mod,'p_amount_billed_tbl',p_amount_billed_tbl);
1432: PO_LOG.proc_begin(d_mod,'p_amount_delivered_tbl',p_amount_delivered_tbl);

Line 1429: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);

1425:
1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1428: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1429: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1430: PO_LOG.proc_begin(d_mod,'p_amount_funded_tbl',p_amount_funded_tbl);
1431: PO_LOG.proc_begin(d_mod,'p_amount_billed_tbl',p_amount_billed_tbl);
1432: PO_LOG.proc_begin(d_mod,'p_amount_delivered_tbl',p_amount_delivered_tbl);
1433: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1430: PO_LOG.proc_begin(d_mod,'p_amount_funded_tbl',p_amount_funded_tbl);

1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1428: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1429: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1430: PO_LOG.proc_begin(d_mod,'p_amount_funded_tbl',p_amount_funded_tbl);
1431: PO_LOG.proc_begin(d_mod,'p_amount_billed_tbl',p_amount_billed_tbl);
1432: PO_LOG.proc_begin(d_mod,'p_amount_delivered_tbl',p_amount_delivered_tbl);
1433: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1434: END IF;

Line 1431: PO_LOG.proc_begin(d_mod,'p_amount_billed_tbl',p_amount_billed_tbl);

1427: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1428: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1429: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1430: PO_LOG.proc_begin(d_mod,'p_amount_funded_tbl',p_amount_funded_tbl);
1431: PO_LOG.proc_begin(d_mod,'p_amount_billed_tbl',p_amount_billed_tbl);
1432: PO_LOG.proc_begin(d_mod,'p_amount_delivered_tbl',p_amount_delivered_tbl);
1433: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1434: END IF;
1435:

Line 1432: PO_LOG.proc_begin(d_mod,'p_amount_delivered_tbl',p_amount_delivered_tbl);

1428: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1429: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1430: PO_LOG.proc_begin(d_mod,'p_amount_funded_tbl',p_amount_funded_tbl);
1431: PO_LOG.proc_begin(d_mod,'p_amount_billed_tbl',p_amount_billed_tbl);
1432: PO_LOG.proc_begin(d_mod,'p_amount_delivered_tbl',p_amount_delivered_tbl);
1433: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1434: END IF;
1435:
1436: IF (x_results IS NULL) THEN

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

1429: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1430: PO_LOG.proc_begin(d_mod,'p_amount_funded_tbl',p_amount_funded_tbl);
1431: PO_LOG.proc_begin(d_mod,'p_amount_billed_tbl',p_amount_billed_tbl);
1432: PO_LOG.proc_begin(d_mod,'p_amount_delivered_tbl',p_amount_delivered_tbl);
1433: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1434: END IF;
1435:
1436: IF (x_results IS NULL) THEN
1437: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1485: IF PO_LOG.d_proc THEN

1481: ELSE
1482: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1483: END IF;
1484:
1485: IF PO_LOG.d_proc THEN
1486: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1487: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1488: END IF;
1489:

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

1482: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1483: END IF;
1484:
1485: IF PO_LOG.d_proc THEN
1486: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1487: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1488: END IF;
1489:
1490: EXCEPTION

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

1483: END IF;
1484:
1485: IF PO_LOG.d_proc THEN
1486: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1487: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1488: END IF;
1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN

Line 1492: IF PO_LOG.d_exc THEN

1488: END IF;
1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: IF PO_LOG.d_exc THEN
1493: PO_LOG.exc(d_mod,0,NULL);
1494: END IF;
1495: RAISE;
1496:

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

1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: IF PO_LOG.d_exc THEN
1493: PO_LOG.exc(d_mod,0,NULL);
1494: END IF;
1495: RAISE;
1496:
1497: END amount_funded_ge_exc_amount;

Line 1522: IF PO_LOG.d_proc THEN

1518: l_is_clm_enabled VARCHAR2(1);
1519: l_backing_req_fund_value NUMBER;
1520: BEGIN
1521:
1522: IF PO_LOG.d_proc THEN
1523: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1524: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1525: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1526: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);

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

1519: l_backing_req_fund_value NUMBER;
1520: BEGIN
1521:
1522: IF PO_LOG.d_proc THEN
1523: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1524: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1525: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1526: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1527: PO_LOG.proc_begin(d_mod,'p_req_distribution_id_tbl',p_req_distribution_id_tbl);

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

1520: BEGIN
1521:
1522: IF PO_LOG.d_proc THEN
1523: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1524: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1525: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1526: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1527: PO_LOG.proc_begin(d_mod,'p_req_distribution_id_tbl',p_req_distribution_id_tbl);
1528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1525: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);

1521:
1522: IF PO_LOG.d_proc THEN
1523: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1524: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1525: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1526: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1527: PO_LOG.proc_begin(d_mod,'p_req_distribution_id_tbl',p_req_distribution_id_tbl);
1528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1529: END IF;

Line 1526: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);

1522: IF PO_LOG.d_proc THEN
1523: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1524: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1525: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1526: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1527: PO_LOG.proc_begin(d_mod,'p_req_distribution_id_tbl',p_req_distribution_id_tbl);
1528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1529: END IF;
1530:

Line 1527: PO_LOG.proc_begin(d_mod,'p_req_distribution_id_tbl',p_req_distribution_id_tbl);

1523: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1524: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1525: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1526: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1527: PO_LOG.proc_begin(d_mod,'p_req_distribution_id_tbl',p_req_distribution_id_tbl);
1528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1529: END IF;
1530:
1531: IF (x_results IS NULL) THEN

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

1524: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
1525: PO_LOG.proc_begin(d_mod,'p_style_id_tbl',p_style_id_tbl);
1526: PO_LOG.proc_begin(d_mod,'p_funded_value_tbl',p_funded_value_tbl);
1527: PO_LOG.proc_begin(d_mod,'p_req_distribution_id_tbl',p_req_distribution_id_tbl);
1528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1529: END IF;
1530:
1531: IF (x_results IS NULL) THEN
1532: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1574: IF PO_LOG.d_proc THEN

1570: ELSE
1571: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1572: END IF;
1573:
1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1576: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1577: END IF;
1578:

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

1571: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1572: END IF;
1573:
1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1576: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1577: END IF;
1578:
1579: EXCEPTION

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

1572: END IF;
1573:
1574: IF PO_LOG.d_proc THEN
1575: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1576: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1577: END IF;
1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN

Line 1581: IF PO_LOG.d_exc THEN

1577: END IF;
1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: IF PO_LOG.d_exc THEN
1582: PO_LOG.exc(d_mod,0,NULL);
1583: END IF;
1584: RAISE;
1585:

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

1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: IF PO_LOG.d_exc THEN
1582: PO_LOG.exc(d_mod,0,NULL);
1583: END IF;
1584: RAISE;
1585:
1586: END funded_value_gt_backing_req;

Line 1623: IF PO_LOG.d_proc THEN

1619: l_results_count NUMBER;
1620: x_project_reference_enabled NUMBER;
1621: x_project_control_level NUMBER;
1622: BEGIN
1623: IF PO_LOG.d_proc THEN
1624: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1625: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1626: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1627: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);

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

1620: x_project_reference_enabled NUMBER;
1621: x_project_control_level NUMBER;
1622: BEGIN
1623: IF PO_LOG.d_proc THEN
1624: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1625: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1626: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1627: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1628: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);

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

1621: x_project_control_level NUMBER;
1622: BEGIN
1623: IF PO_LOG.d_proc THEN
1624: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1625: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1626: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1627: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1628: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1629: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);

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

1622: BEGIN
1623: IF PO_LOG.d_proc THEN
1624: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1625: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1626: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1627: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1628: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1629: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1630: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);

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

1623: IF PO_LOG.d_proc THEN
1624: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1625: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1626: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1627: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1628: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1629: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1630: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1631: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);

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

1624: PO_LOG.proc_begin(d_mod,'p_dist_id_tbl',p_dist_id_tbl);
1625: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1626: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1627: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1628: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1629: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1630: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1631: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1632: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);

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

1625: PO_LOG.proc_begin(d_mod,'p_dest_type_code_tbl',p_dest_type_code_tbl);
1626: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1627: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1628: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1629: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1630: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1631: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1632: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1633: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

1626: PO_LOG.proc_begin(d_mod,'p_project_id_tbl',p_project_id_tbl);
1627: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1628: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1629: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1630: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1631: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1632: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1633: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1634: END IF;

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

1627: PO_LOG.proc_begin(d_mod,'p_task_id_tbl',p_task_id_tbl);
1628: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1629: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1630: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1631: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1632: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1633: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1634: END IF;
1635:

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

1628: PO_LOG.proc_begin(d_mod,'p_award_id_tbl',p_award_id_tbl);
1629: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1630: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1631: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1632: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1633: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1634: END IF;
1635:
1636: IF (x_results IS NULL) THEN

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

1629: PO_LOG.proc_begin(d_mod,'p_expenditure_type_tbl',p_expenditure_type_tbl);
1630: PO_LOG.proc_begin(d_mod,'p_expenditure_org_id_tbl',p_expenditure_org_id_tbl);
1631: PO_LOG.proc_begin(d_mod,'p_expenditure_item_date_tbl',p_expenditure_item_date_tbl);
1632: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
1633: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1634: END IF;
1635:
1636: IF (x_results IS NULL) THEN
1637: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

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

1646: NULL,
1647: x_project_reference_enabled,
1648: x_project_control_level);
1649:
1650: PO_LOG.proc_begin(d_mod,'x_project_reference_enabled',x_project_reference_enabled);
1651: PO_LOG.proc_begin(d_mod,'x_project_control_level',x_project_control_level);
1652: -- Bug 7558385
1653: -- Need to check for PJM Parameters before making Task as mandatory.
1654: IF (p_project_id_tbl(i) IS NOT NULL) AND

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

1647: x_project_reference_enabled,
1648: x_project_control_level);
1649:
1650: PO_LOG.proc_begin(d_mod,'x_project_reference_enabled',x_project_reference_enabled);
1651: PO_LOG.proc_begin(d_mod,'x_project_control_level',x_project_control_level);
1652: -- Bug 7558385
1653: -- Need to check for PJM Parameters before making Task as mandatory.
1654: IF (p_project_id_tbl(i) IS NOT NULL) AND
1655: (NOT((x_project_reference_enabled = 1 ) and

Line 1734: IF po_log.d_proc THEN

1730: ELSE
1731: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1732: END IF;
1733:
1734: IF po_log.d_proc THEN
1735: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1736: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1737: END IF;
1738:

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

1731: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1732: END IF;
1733:
1734: IF po_log.d_proc THEN
1735: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1736: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1737: END IF;
1738:
1739: EXCEPTION

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

1732: END IF;
1733:
1734: IF po_log.d_proc THEN
1735: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
1736: po_log.LOG(po_log.c_proc_end, d_mod, NULL, 'x_results', x_results);
1737: END IF;
1738:
1739: EXCEPTION
1740: WHEN OTHERS THEN

Line 1741: IF po_log.d_exc THEN

1737: END IF;
1738:
1739: EXCEPTION
1740: WHEN OTHERS THEN
1741: IF po_log.d_exc THEN
1742: po_log.exc(d_mod, 0, NULL);
1743: END IF;
1744:
1745: RAISE;

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

1738:
1739: EXCEPTION
1740: WHEN OTHERS THEN
1741: IF po_log.d_exc THEN
1742: po_log.exc(d_mod, 0, NULL);
1743: END IF;
1744:
1745: RAISE;
1746:

Line 1772: IF PO_LOG.d_proc THEN

1768: l_data_key NUMBER;
1769:
1770: BEGIN
1771:
1772: IF PO_LOG.d_proc THEN
1773: PO_LOG.proc_begin(d_mod);
1774: END IF;
1775:
1776: IF (x_result_set_id IS NULL) THEN

Line 1773: PO_LOG.proc_begin(d_mod);

1769:
1770: BEGIN
1771:
1772: IF PO_LOG.d_proc THEN
1773: PO_LOG.proc_begin(d_mod);
1774: END IF;
1775:
1776: IF (x_result_set_id IS NULL) THEN
1777: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1879: IF PO_LOG.d_proc THEN

1875: ELSE
1876: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1877: END IF;
1878:
1879: IF PO_LOG.d_proc THEN
1880: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1881: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1882: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1883: END IF;

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

1877: END IF;
1878:
1879: IF PO_LOG.d_proc THEN
1880: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1881: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1882: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1883: END IF;
1884:
1885: EXCEPTION

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

1878:
1879: IF PO_LOG.d_proc THEN
1880: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1881: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1882: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1883: END IF;
1884:
1885: EXCEPTION
1886: WHEN OTHERS THEN

Line 1887: IF PO_LOG.d_exc THEN

1883: END IF;
1884:
1885: EXCEPTION
1886: WHEN OTHERS THEN
1887: IF PO_LOG.d_exc THEN
1888: PO_LOG.exc(d_mod,0,NULL);
1889: END IF;
1890: RAISE;
1891:

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

1884:
1885: EXCEPTION
1886: WHEN OTHERS THEN
1887: IF PO_LOG.d_exc THEN
1888: PO_LOG.exc(d_mod,0,NULL);
1889: END IF;
1890: RAISE;
1891:
1892: END funded_val_gt_req_funds_rmn;

Line 1939: IF PO_LOG.d_proc THEN

1935:
1936:
1937: BEGIN
1938:
1939: IF PO_LOG.d_proc THEN
1940: PO_LOG.proc_begin(d_mod);
1941: END IF;
1942:
1943: IF (x_results IS NULL) THEN

Line 1940: PO_LOG.proc_begin(d_mod);

1936:
1937: BEGIN
1938:
1939: IF PO_LOG.d_proc THEN
1940: PO_LOG.proc_begin(d_mod);
1941: END IF;
1942:
1943: IF (x_results IS NULL) THEN
1944: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1951: IF PO_LOG.d_proc THEN

1947: l_results_count := x_results.result_type.COUNT;
1948:
1949: FOR i IN 1..p_dist_id_tbl.Count() LOOP
1950:
1951: IF PO_LOG.d_proc THEN
1952: PO_LOG.stmt(d_mod,10,'p_dist_id_tbl(i) is ',p_dist_id_tbl(i));
1953: PO_LOG.stmt(d_mod,20,'p_draft_type_tbl(i) is ',p_draft_type_tbl(i));
1954: END IF;
1955:

Line 1952: PO_LOG.stmt(d_mod,10,'p_dist_id_tbl(i) is ',p_dist_id_tbl(i));

1948:
1949: FOR i IN 1..p_dist_id_tbl.Count() LOOP
1950:
1951: IF PO_LOG.d_proc THEN
1952: PO_LOG.stmt(d_mod,10,'p_dist_id_tbl(i) is ',p_dist_id_tbl(i));
1953: PO_LOG.stmt(d_mod,20,'p_draft_type_tbl(i) is ',p_draft_type_tbl(i));
1954: END IF;
1955:
1956: --Validation has to skipped for new lines in PAR

Line 1953: PO_LOG.stmt(d_mod,20,'p_draft_type_tbl(i) is ',p_draft_type_tbl(i));

1949: FOR i IN 1..p_dist_id_tbl.Count() LOOP
1950:
1951: IF PO_LOG.d_proc THEN
1952: PO_LOG.stmt(d_mod,10,'p_dist_id_tbl(i) is ',p_dist_id_tbl(i));
1953: PO_LOG.stmt(d_mod,20,'p_draft_type_tbl(i) is ',p_draft_type_tbl(i));
1954: END IF;
1955:
1956: --Validation has to skipped for new lines in PAR
1957: IF ((p_draft_type_tbl(i) = 'PAR' AND p_change_status_tbl(i)='NEW') OR

Line 1964: IF PO_LOG.d_proc THEN

1960: RETURN;
1961: END IF;
1962:
1963:
1964: IF PO_LOG.d_proc THEN
1965: PO_LOG.stmt(d_mod,30,'p_quantity_ordered_tbl(i) ',p_quantity_ordered_tbl(i));
1966: PO_LOG.stmt(d_mod,40,'p_old_qty_ordered_tbl(i) ',p_old_qty_ordered_tbl(i));
1967: END IF;
1968:

Line 1965: PO_LOG.stmt(d_mod,30,'p_quantity_ordered_tbl(i) ',p_quantity_ordered_tbl(i));

1961: END IF;
1962:
1963:
1964: IF PO_LOG.d_proc THEN
1965: PO_LOG.stmt(d_mod,30,'p_quantity_ordered_tbl(i) ',p_quantity_ordered_tbl(i));
1966: PO_LOG.stmt(d_mod,40,'p_old_qty_ordered_tbl(i) ',p_old_qty_ordered_tbl(i));
1967: END IF;
1968:
1969: --Compare the old and new qauntities and thorw an error if there is an increase

Line 1966: PO_LOG.stmt(d_mod,40,'p_old_qty_ordered_tbl(i) ',p_old_qty_ordered_tbl(i));

1962:
1963:
1964: IF PO_LOG.d_proc THEN
1965: PO_LOG.stmt(d_mod,30,'p_quantity_ordered_tbl(i) ',p_quantity_ordered_tbl(i));
1966: PO_LOG.stmt(d_mod,40,'p_old_qty_ordered_tbl(i) ',p_old_qty_ordered_tbl(i));
1967: END IF;
1968:
1969: --Compare the old and new qauntities and thorw an error if there is an increase
1970: IF p_quantity_ordered_tbl(i) > p_old_qty_ordered_tbl(i) THEN

Line 1972: IF PO_LOG.d_proc THEN

1968:
1969: --Compare the old and new qauntities and thorw an error if there is an increase
1970: IF p_quantity_ordered_tbl(i) > p_old_qty_ordered_tbl(i) THEN
1971:
1972: IF PO_LOG.d_proc THEN
1973: PO_LOG.stmt(d_mod,50,'Qty/Amount is increased at distributions on a PAR ');
1974: END IF;
1975:
1976: x_results.add_result(

Line 1973: PO_LOG.stmt(d_mod,50,'Qty/Amount is increased at distributions on a PAR ');

1969: --Compare the old and new qauntities and thorw an error if there is an increase
1970: IF p_quantity_ordered_tbl(i) > p_old_qty_ordered_tbl(i) THEN
1971:
1972: IF PO_LOG.d_proc THEN
1973: PO_LOG.stmt(d_mod,50,'Qty/Amount is increased at distributions on a PAR ');
1974: END IF;
1975:
1976: x_results.add_result(
1977: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION

Line 2023: IF PO_LOG.d_proc THEN

2019: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2020: RETURN;
2021: END IF;
2022:
2023: IF PO_LOG.d_proc THEN
2024: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_intf_dist_id_tbl);
2025: END IF;
2026:
2027: --loop through each distribution that corresponds to a slin

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

2020: RETURN;
2021: END IF;
2022:
2023: IF PO_LOG.d_proc THEN
2024: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_intf_dist_id_tbl);
2025: END IF;
2026:
2027: --loop through each distribution that corresponds to a slin
2028: FOR i IN 1..p_intf_dist_id_tbl.COUNT LOOP

Line 2060: IF PO_LOG.d_proc THEN

2056: ELSE
2057: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2058: END IF;
2059:
2060: IF PO_LOG.d_proc THEN
2061: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2062: END IF;
2063: EXCEPTION
2064: WHEN OTHERS THEN

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

2057: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2058: END IF;
2059:
2060: IF PO_LOG.d_proc THEN
2061: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2062: END IF;
2063: EXCEPTION
2064: WHEN OTHERS THEN
2065: IF PO_LOG.d_exc THEN

Line 2065: IF PO_LOG.d_exc THEN

2061: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2062: END IF;
2063: EXCEPTION
2064: WHEN OTHERS THEN
2065: IF PO_LOG.d_exc THEN
2066: PO_LOG.exc(d_mod,0,NULL);
2067: END IF;
2068: RAISE;
2069:

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

2062: END IF;
2063: EXCEPTION
2064: WHEN OTHERS THEN
2065: IF PO_LOG.d_exc THEN
2066: PO_LOG.exc(d_mod,0,NULL);
2067: END IF;
2068: RAISE;
2069:
2070: END check_clin_slin_funding;

Line 2094: IF PO_LOG.d_proc THEN

2090: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2091: RETURN;
2092: END IF;
2093:
2094: IF PO_LOG.d_proc THEN
2095: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_intf_dist_id_tbl);
2096: END IF;
2097:
2098: IF (x_results IS NULL) THEN

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

2091: RETURN;
2092: END IF;
2093:
2094: IF PO_LOG.d_proc THEN
2095: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_intf_dist_id_tbl);
2096: END IF;
2097:
2098: IF (x_results IS NULL) THEN
2099: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 2138: IF PO_LOG.d_proc THEN

2134: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2135: ELSE
2136: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2137: END IF;
2138: IF PO_LOG.d_proc THEN
2139: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2140: END IF;
2141: EXCEPTION
2142: WHEN OTHERS THEN

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

2135: ELSE
2136: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2137: END IF;
2138: IF PO_LOG.d_proc THEN
2139: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2140: END IF;
2141: EXCEPTION
2142: WHEN OTHERS THEN
2143: IF PO_LOG.d_exc THEN

Line 2143: IF PO_LOG.d_exc THEN

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

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

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

Line 2170: IF PO_LOG.d_proc THEN

2166: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2167: RETURN;
2168: END IF;
2169:
2170: IF PO_LOG.d_proc THEN
2171: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_intf_dist_id_tbl);
2172: END IF;
2173:
2174: IF (x_results IS NULL) THEN

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

2167: RETURN;
2168: END IF;
2169:
2170: IF PO_LOG.d_proc THEN
2171: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_intf_dist_id_tbl);
2172: END IF;
2173:
2174: IF (x_results IS NULL) THEN
2175: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 2214: IF PO_LOG.d_proc THEN

2210: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
2211: ELSE
2212: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2213: END IF;
2214: IF PO_LOG.d_proc THEN
2215: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2216: END IF;
2217: EXCEPTION
2218: WHEN OTHERS THEN

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

2211: ELSE
2212: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2213: END IF;
2214: IF PO_LOG.d_proc THEN
2215: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2216: END IF;
2217: EXCEPTION
2218: WHEN OTHERS THEN
2219: IF PO_LOG.d_exc THEN

Line 2219: IF PO_LOG.d_exc THEN

2215: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2216: END IF;
2217: EXCEPTION
2218: WHEN OTHERS THEN
2219: IF PO_LOG.d_exc THEN
2220: PO_LOG.exc(d_mod,0,NULL);
2221: END IF;
2222: RAISE;
2223:

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

2216: END IF;
2217: EXCEPTION
2218: WHEN OTHERS THEN
2219: IF PO_LOG.d_exc THEN
2220: PO_LOG.exc(d_mod,0,NULL);
2221: END IF;
2222: RAISE;
2223:
2224: END validate_option_distribution;