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.

[Home] [Help]

APPS.PO_VAL_SHIPMENTS dependencies on PO_LOG

Line 40: PO_LOG.get_package_base('PO_VAL_SHIPMENTS');

36: ---------------------------------------------------------------------------
37:
38: -- The module base for this package.
39: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
40: PO_LOG.get_package_base('PO_VAL_SHIPMENTS');
41:
42: -- The module base for the subprogram.
43: D_days_early_gte_zero CONSTANT VARCHAR2(100) :=
44: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_early_gte_zero');

Line 44: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_early_gte_zero');

40: PO_LOG.get_package_base('PO_VAL_SHIPMENTS');
41:
42: -- The module base for the subprogram.
43: D_days_early_gte_zero CONSTANT VARCHAR2(100) :=
44: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_early_gte_zero');
45:
46: -- The module base for the subprogram.
47: D_days_late_gte_zero CONSTANT VARCHAR2(100) :=
48: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_late_gte_zero');

Line 48: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_late_gte_zero');

44: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_early_gte_zero');
45:
46: -- The module base for the subprogram.
47: D_days_late_gte_zero CONSTANT VARCHAR2(100) :=
48: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_late_gte_zero');
49:
50: -- The module base for the subprogram.
51: D_rcv_close_tol_within_range CONSTANT VARCHAR2(100) :=
52: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rcv_close_tol_within_range');

Line 52: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rcv_close_tol_within_range');

48: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_late_gte_zero');
49:
50: -- The module base for the subprogram.
51: D_rcv_close_tol_within_range CONSTANT VARCHAR2(100) :=
52: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rcv_close_tol_within_range');
53:
54: -- The module base for the subprogram.
55: D_over_rcpt_tol_within_range CONSTANT VARCHAR2(100) :=
56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'over_rcpt_tol_within_range');

Line 56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'over_rcpt_tol_within_range');

52: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rcv_close_tol_within_range');
53:
54: -- The module base for the subprogram.
55: D_over_rcpt_tol_within_range CONSTANT VARCHAR2(100) :=
56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'over_rcpt_tol_within_range');
57:
58: -- The module base for the subprogram.
59: D_planned_item_null_date_check CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'planned_item_null_date_check');

Line 60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'planned_item_null_date_check');

56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'over_rcpt_tol_within_range');
57:
58: -- The module base for the subprogram.
59: D_planned_item_null_date_check CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'planned_item_null_date_check');
61:
62: -- The module base for the subprogram.
63: D_match_4way_check CONSTANT VARCHAR2(100) :=
64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_4way_check');

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

60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'planned_item_null_date_check');
61:
62: -- The module base for the subprogram.
63: D_match_4way_check CONSTANT VARCHAR2(100) :=
64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_4way_check');
65:
66: -- The module base for the subprogram.
67: D_inv_close_tol_range_check CONSTANT VARCHAR2(100) :=
68: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'inv_close_tol_range_check');

Line 68: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'inv_close_tol_range_check');

64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_4way_check');
65:
66: -- The module base for the subprogram.
67: D_inv_close_tol_range_check CONSTANT VARCHAR2(100) :=
68: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'inv_close_tol_range_check');
69:
70: -- The module base for the subprogram.
71: D_need_by_date_open_per_check CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'need_by_date_open_period_check');

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

68: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'inv_close_tol_range_check');
69:
70: -- The module base for the subprogram.
71: D_need_by_date_open_per_check CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'need_by_date_open_period_check');
73:
74: -- The module base for the subprogram.
75: D_promise_date_open_per_check CONSTANT VARCHAR2(100) :=
76: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'promise_date_open_period_check');

Line 76: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'promise_date_open_period_check');

72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'need_by_date_open_period_check');
73:
74: -- The module base for the subprogram.
75: D_promise_date_open_per_check CONSTANT VARCHAR2(100) :=
76: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'promise_date_open_period_check');
77:
78: -- The module base for the subprogram.
79: D_ship_to_org_null_check CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_org_null_check');

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

76: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'promise_date_open_period_check');
77:
78: -- The module base for the subprogram.
79: D_ship_to_org_null_check CONSTANT VARCHAR2(100) :=
80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_org_null_check');
81:
82: -- The module base for the subprogram.
83: D_ship_to_loc_null_check CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_null_check');

Line 84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_null_check');

80: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_org_null_check');
81:
82: -- The module base for the subprogram.
83: D_ship_to_loc_null_check CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_null_check');
85:
86: D_ship_num_gt_zero CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_gt_zero');
88:

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

83: D_ship_to_loc_null_check CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_null_check');
85:
86: D_ship_num_gt_zero CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_gt_zero');
88:
89: -- The module base for the subprogram.
90: D_ship_num_unique_check CONSTANT VARCHAR2(100) :=
91: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_unique_check');

Line 91: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_unique_check');

87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_gt_zero');
88:
89: -- The module base for the subprogram.
90: D_ship_num_unique_check CONSTANT VARCHAR2(100) :=
91: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_unique_check');
92:
93: -- The module base for the subprogram.
94: D_is_org_in_current_sob_check CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'is_org_in_current_sob_check');

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

91: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_unique_check');
92:
93: -- The module base for the subprogram.
94: D_is_org_in_current_sob_check CONSTANT VARCHAR2(100) :=
95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'is_org_in_current_sob_check');
96:
97: -- The module base for the subprogram.
98: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');

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

95: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'is_org_in_current_sob_check');
96:
97: -- The module base for the subprogram.
98: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
100:
101: -- The module base for the subprogram.
102: D_ship_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
103: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_sec_quantity_gt_zero');

Line 103: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_sec_quantity_gt_zero');

99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
100:
101: -- The module base for the subprogram.
102: D_ship_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
103: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_sec_quantity_gt_zero');
104:
105: -- The module base for the subprogram.
106: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
107: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');

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

103: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_sec_quantity_gt_zero');
104:
105: -- The module base for the subprogram.
106: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
107: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
108:
109: -- : Combined billed and rcvd into exec
110: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');

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

107: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
108:
109: -- : Combined billed and rcvd into exec
110: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');
112:
113: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_amount_exec');
115:

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

110: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');
112:
113: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_amount_exec');
115:
116: --
117:
118: -- The module base for the subprogram.

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

116: --
117:
118: -- The module base for the subprogram.
119: D_ship_qtys_within_deviation CONSTANT VARCHAR2(100) :=
120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_qtys_within_deviation');
121:
122: -- Bug 5385686 : Module base for the subprogram
123: D_unit_of_meas_not_null CONSTANT VARCHAR2(100) :=
124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_of_meas_not_null');

Line 124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_of_meas_not_null');

120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_qtys_within_deviation');
121:
122: -- Bug 5385686 : Module base for the subprogram
123: D_unit_of_meas_not_null CONSTANT VARCHAR2(100) :=
124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_of_meas_not_null');
125: -------------------------------------------------------------------------
126: -- Check if the days early value is greater than or equal to zero.
127: -------------------------------------------------------------------------
128:

Line 256: IF PO_LOG.d_proc THEN

252: l_count NUMBER;
253:
254: BEGIN
255:
256: IF PO_LOG.d_proc THEN
257: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
258: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
259: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
260: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

Line 257: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);

253:
254: BEGIN
255:
256: IF PO_LOG.d_proc THEN
257: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
258: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
259: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
260: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
261: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 258: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);

254: BEGIN
255:
256: IF PO_LOG.d_proc THEN
257: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
258: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
259: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
260: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
261: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
262: END IF;

Line 259: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);

255:
256: IF PO_LOG.d_proc THEN
257: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
258: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
259: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
260: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
261: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
262: END IF;
263:

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

256: IF PO_LOG.d_proc THEN
257: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
258: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
259: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
260: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
261: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
262: END IF;
263:
264: IF (x_result_set_id IS NULL) THEN

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

257: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
258: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
259: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
260: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
261: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
262: END IF;
263:
264: IF (x_result_set_id IS NULL) THEN
265: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 322: IF PO_LOG.d_proc THEN

318: END IF;
319:
320: END IF;
321:
322: IF PO_LOG.d_proc THEN
323: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
324: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
325: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
326: END IF;

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

320: END IF;
321:
322: IF PO_LOG.d_proc THEN
323: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
324: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
325: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
326: END IF;
327:
328: EXCEPTION

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

321:
322: IF PO_LOG.d_proc THEN
323: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
324: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
325: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
326: END IF;
327:
328: EXCEPTION
329: WHEN OTHERS THEN

Line 330: IF PO_LOG.d_exc THEN

326: END IF;
327:
328: EXCEPTION
329: WHEN OTHERS THEN
330: IF PO_LOG.d_exc THEN
331: PO_LOG.exc(d_mod,0,NULL);
332: END IF;
333: RAISE;
334:

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

327:
328: EXCEPTION
329: WHEN OTHERS THEN
330: IF PO_LOG.d_exc THEN
331: PO_LOG.exc(d_mod,0,NULL);
332: END IF;
333: RAISE;
334:
335: END planned_item_null_date_check;

Line 357: IF PO_LOG.d_proc THEN

353:
354: l_results_count NUMBER;
355: BEGIN
356:
357: IF PO_LOG.d_proc THEN
358: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
359: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
360: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
361: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);

Line 358: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);

354: l_results_count NUMBER;
355: BEGIN
356:
357: IF PO_LOG.d_proc THEN
358: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
359: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
360: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
361: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
362: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);

Line 359: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);

355: BEGIN
356:
357: IF PO_LOG.d_proc THEN
358: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
359: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
360: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
361: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
362: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
363: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 360: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);

356:
357: IF PO_LOG.d_proc THEN
358: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
359: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
360: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
361: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
362: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
363: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
364: END IF;

Line 361: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);

357: IF PO_LOG.d_proc THEN
358: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
359: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
360: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
361: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
362: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
363: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
364: END IF;
365:

Line 362: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);

358: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
359: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
360: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
361: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
362: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
363: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
364: END IF;
365:
366: IF (x_results IS NULL) THEN

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

359: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
360: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
361: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
362: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
363: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
364: END IF;
365:
366: IF (x_results IS NULL) THEN
367: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 394: IF PO_LOG.d_proc THEN

390: ELSE
391: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
392: END IF;
393:
394: IF PO_LOG.d_proc THEN
395: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
396: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
397: END IF;
398:

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

391: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
392: END IF;
393:
394: IF PO_LOG.d_proc THEN
395: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
396: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
397: END IF;
398:
399: EXCEPTION

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

392: END IF;
393:
394: IF PO_LOG.d_proc THEN
395: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
396: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
397: END IF;
398:
399: EXCEPTION
400: WHEN OTHERS THEN

Line 401: IF PO_LOG.d_exc THEN

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

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

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

Line 524: IF PO_LOG.d_proc THEN

520: l_input_size NUMBER;
521: l_count NUMBER;
522: BEGIN
523:
524: IF PO_LOG.d_proc THEN
525: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
526: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
527: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_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_line_loc_id_tbl',p_line_loc_id_tbl);

521: l_count NUMBER;
522: BEGIN
523:
524: IF PO_LOG.d_proc THEN
525: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
526: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
527: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_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_ship_to_org_id_tbl',p_ship_to_org_id_tbl);

522: BEGIN
523:
524: IF PO_LOG.d_proc THEN
525: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
526: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
527: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_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_shipment_type_tbl',p_shipment_type_tbl);

523:
524: IF PO_LOG.d_proc THEN
525: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
526: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
527: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
529: END IF;
530:
531: l_input_size := p_line_loc_id_tbl.COUNT;

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

524: IF PO_LOG.d_proc THEN
525: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
526: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
527: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
528: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
529: END IF;
530:
531: l_input_size := p_line_loc_id_tbl.COUNT;
532:

Line 566: IF PO_LOG.d_exc THEN

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

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

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

Line 592: IF PO_LOG.d_proc THEN

588: l_input_size NUMBER;
589: l_count NUMBER;
590: BEGIN
591:
592: IF PO_LOG.d_proc THEN
593: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
594: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
595: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
596: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

589: l_count NUMBER;
590: BEGIN
591:
592: IF PO_LOG.d_proc THEN
593: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
594: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
595: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
596: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
597: END IF;

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

590: BEGIN
591:
592: IF PO_LOG.d_proc THEN
593: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
594: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
595: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
596: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
597: END IF;
598:

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

591:
592: IF PO_LOG.d_proc THEN
593: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
594: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
595: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
596: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
597: END IF;
598:
599: l_input_size := p_line_loc_id_tbl.COUNT;

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

592: IF PO_LOG.d_proc THEN
593: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
594: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
595: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
596: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
597: END IF;
598:
599: l_input_size := p_line_loc_id_tbl.COUNT;
600:

Line 634: IF PO_LOG.d_exc THEN

630: );
631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: IF PO_LOG.d_exc THEN
635: PO_LOG.exc(d_mod,0,NULL);
636: END IF;
637: RAISE;
638:

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

631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: IF PO_LOG.d_exc THEN
635: PO_LOG.exc(d_mod,0,NULL);
636: END IF;
637: RAISE;
638:
639: END ship_to_loc_null_check;

Line 751: IF PO_LOG.d_proc THEN

747: l_in_sob BOOLEAN;
748: l_return_status VARCHAR(1);
749: BEGIN
750:
751: IF PO_LOG.d_proc THEN
752: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
753: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
754: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
755: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);

Line 752: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);

748: l_return_status VARCHAR(1);
749: BEGIN
750:
751: IF PO_LOG.d_proc THEN
752: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
753: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
754: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
755: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
756: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

749: BEGIN
750:
751: IF PO_LOG.d_proc THEN
752: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
753: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
754: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
755: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
756: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
757: END IF;

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

750:
751: IF PO_LOG.d_proc THEN
752: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
753: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
754: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
755: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
756: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
757: END IF;
758:

Line 755: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);

751: IF PO_LOG.d_proc THEN
752: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
753: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
754: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
755: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
756: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
757: END IF;
758:
759: IF (x_results IS NULL) THEN

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

752: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
753: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
754: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
755: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
756: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
757: END IF;
758:
759: IF (x_results IS NULL) THEN
760: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 845: IF PO_LOG.d_proc THEN

841: ELSE
842: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
843: END IF;
844:
845: IF PO_LOG.d_proc THEN
846: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
847: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
848: END IF;
849:

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

842: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
843: END IF;
844:
845: IF PO_LOG.d_proc THEN
846: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
847: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
848: END IF;
849:
850: EXCEPTION

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

843: END IF;
844:
845: IF PO_LOG.d_proc THEN
846: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
847: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
848: END IF;
849:
850: EXCEPTION
851: WHEN OTHERS THEN

Line 852: IF PO_LOG.d_exc THEN

848: END IF;
849:
850: EXCEPTION
851: WHEN OTHERS THEN
852: IF PO_LOG.d_exc THEN
853: PO_LOG.exc(d_mod,0,NULL);
854: END IF;
855: RAISE;
856:

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

849:
850: EXCEPTION
851: WHEN OTHERS THEN
852: IF PO_LOG.d_exc THEN
853: PO_LOG.exc(d_mod,0,NULL);
854: END IF;
855: RAISE;
856:
857: END is_org_in_current_sob_check;

Line 879: IF PO_LOG.d_proc THEN

875: l_input_size NUMBER;
876: l_count NUMBER;
877: BEGIN
878:
879: IF PO_LOG.d_proc THEN
880: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
881: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
882: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
883: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);

Line 880: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);

876: l_count NUMBER;
877: BEGIN
878:
879: IF PO_LOG.d_proc THEN
880: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
881: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
882: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
883: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
884: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

877: BEGIN
878:
879: IF PO_LOG.d_proc THEN
880: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
881: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
882: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
883: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
884: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
885: END IF;

Line 882: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);

878:
879: IF PO_LOG.d_proc THEN
880: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
881: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
882: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
883: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
884: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
885: END IF;
886:

Line 883: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);

879: IF PO_LOG.d_proc THEN
880: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
881: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
882: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
883: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
884: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
885: END IF;
886:
887: l_input_size := p_line_loc_id_tbl.COUNT;

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

880: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
881: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
882: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
883: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
884: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
885: END IF;
886:
887: l_input_size := p_line_loc_id_tbl.COUNT;
888:

Line 925: IF PO_LOG.d_exc THEN

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

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

922:
923: EXCEPTION
924: WHEN OTHERS THEN
925: IF PO_LOG.d_exc THEN
926: PO_LOG.exc(d_mod,0,NULL);
927: END IF;
928: RAISE;
929:
930: END quantity_gt_zero;

Line 951: IF PO_LOG.d_proc THEN

947: IS
948: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
949: BEGIN
950:
951: IF PO_LOG.d_proc THEN
952: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
953: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
954: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
955: END IF;

Line 952: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);

948: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
949: BEGIN
950:
951: IF PO_LOG.d_proc THEN
952: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
953: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
954: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
955: END IF;
956:

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

949: BEGIN
950:
951: IF PO_LOG.d_proc THEN
952: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
953: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
954: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
955: END IF;
956:
957: IF (x_result_set_id IS NULL) THEN

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

950:
951: IF PO_LOG.d_proc THEN
952: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
953: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
954: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
955: END IF;
956:
957: IF (x_result_set_id IS NULL) THEN
958: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1023: IF PO_LOG.d_proc THEN

1019: ELSE
1020: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1021: END IF;
1022:
1023: IF PO_LOG.d_proc THEN
1024: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1025: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1026: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1027: END IF;

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

1021: END IF;
1022:
1023: IF PO_LOG.d_proc THEN
1024: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1025: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1026: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1027: END IF;
1028:
1029: EXCEPTION

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

1022:
1023: IF PO_LOG.d_proc THEN
1024: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1025: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1026: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1027: END IF;
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN

Line 1031: IF PO_LOG.d_exc THEN

1027: END IF;
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: IF PO_LOG.d_exc THEN
1032: PO_LOG.exc(d_mod,0,NULL);
1033: END IF;
1034: RAISE;
1035:

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

1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: IF PO_LOG.d_exc THEN
1032: PO_LOG.exc(d_mod,0,NULL);
1033: END IF;
1034: RAISE;
1035:
1036: END quantity_ge_quantity_exec;

Line 1061: IF PO_LOG.d_proc THEN

1057: l_input_size NUMBER;
1058: l_count NUMBER;
1059: BEGIN
1060:
1061: IF PO_LOG.d_proc THEN
1062: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1063: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1064: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1065: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);

Line 1062: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);

1058: l_count NUMBER;
1059: BEGIN
1060:
1061: IF PO_LOG.d_proc THEN
1062: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1063: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1064: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1065: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1066: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1063: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);

1059: BEGIN
1060:
1061: IF PO_LOG.d_proc THEN
1062: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1063: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1064: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1065: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1066: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1067: END IF;

Line 1064: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);

1060:
1061: IF PO_LOG.d_proc THEN
1062: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1063: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1064: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1065: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1066: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1067: END IF;
1068:

Line 1065: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);

1061: IF PO_LOG.d_proc THEN
1062: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1063: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1064: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1065: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1066: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1067: END IF;
1068:
1069: l_input_size := p_line_loc_id_tbl.COUNT;

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

1062: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1063: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1064: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1065: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1066: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1067: END IF;
1068:
1069: l_input_size := p_line_loc_id_tbl.COUNT;
1070:

Line 1107: IF PO_LOG.d_exc THEN

1103: );
1104:
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: IF PO_LOG.d_exc THEN
1108: PO_LOG.exc(d_mod,0,NULL);
1109: END IF;
1110: RAISE;
1111:

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

1104:
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: IF PO_LOG.d_exc THEN
1108: PO_LOG.exc(d_mod,0,NULL);
1109: END IF;
1110: RAISE;
1111:
1112: END amount_gt_zero;

Line 1133: IF PO_LOG.d_proc THEN

1129: IS
1130: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_amount_exec;
1131: BEGIN
1132:
1133: IF PO_LOG.d_proc THEN
1134: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1135: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1136: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1137: END IF;

Line 1134: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);

1130: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_amount_exec;
1131: BEGIN
1132:
1133: IF PO_LOG.d_proc THEN
1134: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1135: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1136: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1137: END IF;
1138:

Line 1135: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);

1131: BEGIN
1132:
1133: IF PO_LOG.d_proc THEN
1134: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1135: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1136: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1137: END IF;
1138:
1139: IF (x_result_set_id IS NULL) THEN

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

1132:
1133: IF PO_LOG.d_proc THEN
1134: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1135: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1136: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1137: END IF;
1138:
1139: IF (x_result_set_id IS NULL) THEN
1140: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1202: IF PO_LOG.d_proc THEN

1198: ELSE
1199: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1200: END IF;
1201:
1202: IF PO_LOG.d_proc THEN
1203: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1204: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1205: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1206: END IF;

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

1200: END IF;
1201:
1202: IF PO_LOG.d_proc THEN
1203: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1204: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1205: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1206: END IF;
1207:
1208: EXCEPTION

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

1201:
1202: IF PO_LOG.d_proc THEN
1203: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1204: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1205: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1206: END IF;
1207:
1208: EXCEPTION
1209: WHEN OTHERS THEN

Line 1210: IF PO_LOG.d_exc THEN

1206: END IF;
1207:
1208: EXCEPTION
1209: WHEN OTHERS THEN
1210: IF PO_LOG.d_exc THEN
1211: PO_LOG.exc(d_mod,0,NULL);
1212: END IF;
1213: RAISE;
1214:

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

1207:
1208: EXCEPTION
1209: WHEN OTHERS THEN
1210: IF PO_LOG.d_exc THEN
1211: PO_LOG.exc(d_mod,0,NULL);
1212: END IF;
1213: RAISE;
1214:
1215: END amount_ge_amount_exec;

Line 1236: IF PO_LOG.d_proc THEN

1232: IS
1233: d_mod CONSTANT VARCHAR2(100) := D_ship_sec_quantity_gt_zero;
1234: BEGIN
1235:
1236: IF PO_LOG.d_proc THEN
1237: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1238: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1239: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1240: END IF;

Line 1237: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);

1233: d_mod CONSTANT VARCHAR2(100) := D_ship_sec_quantity_gt_zero;
1234: BEGIN
1235:
1236: IF PO_LOG.d_proc THEN
1237: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1238: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1239: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1240: END IF;
1241:

Line 1238: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);

1234: BEGIN
1235:
1236: IF PO_LOG.d_proc THEN
1237: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1238: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1239: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1240: END IF;
1241:
1242: PO_VALIDATION_HELPER.gt_zero_opm_filter(

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

1235:
1236: IF PO_LOG.d_proc THEN
1237: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1238: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1239: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1240: END IF;
1241:
1242: PO_VALIDATION_HELPER.gt_zero_opm_filter(
1243: p_calling_module => D_ship_sec_quantity_gt_zero

Line 1256: IF PO_LOG.d_exc THEN

1252: );
1253:
1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: IF PO_LOG.d_exc THEN
1257: PO_LOG.exc(d_mod,0,NULL);
1258: END IF;
1259: RAISE;
1260:

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

1253:
1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: IF PO_LOG.d_exc THEN
1257: PO_LOG.exc(d_mod,0,NULL);
1258: END IF;
1259: RAISE;
1260:
1261: END ship_sec_quantity_gt_zero;

Line 1285: IF PO_LOG.d_proc THEN

1281: d_mod CONSTANT VARCHAR2(100) := D_ship_qtys_within_deviation;
1282:
1283: BEGIN
1284:
1285: IF PO_LOG.d_proc THEN
1286: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1288: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1289: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1286: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);

1282:
1283: BEGIN
1284:
1285: IF PO_LOG.d_proc THEN
1286: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1288: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1289: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1290: END IF;

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

1283: BEGIN
1284:
1285: IF PO_LOG.d_proc THEN
1286: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1288: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1289: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1290: END IF;
1291:

Line 1288: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);

1284:
1285: IF PO_LOG.d_proc THEN
1286: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1288: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1289: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1290: END IF;
1291:
1292: PO_VALIDATION_HELPER.qtys_within_deviation (

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

1285: IF PO_LOG.d_proc THEN
1286: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1287: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1288: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1289: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1290: END IF;
1291:
1292: PO_VALIDATION_HELPER.qtys_within_deviation (
1293: p_calling_module => D_ship_qtys_within_deviation

Line 1308: IF PO_LOG.d_exc THEN

1304: );
1305:
1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: IF PO_LOG.d_exc THEN
1309: PO_LOG.exc(d_mod,0,NULL);
1310: END IF;
1311: RAISE;
1312:

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

1305:
1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: IF PO_LOG.d_exc THEN
1309: PO_LOG.exc(d_mod,0,NULL);
1310: END IF;
1311: RAISE;
1312:
1313: END ship_qtys_within_deviation;

Line 1335: IF PO_LOG.d_proc THEN

1331:
1332: l_results_count NUMBER;
1333: BEGIN
1334:
1335: IF PO_LOG.d_proc THEN
1336: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1338: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1339: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

1332: l_results_count NUMBER;
1333: BEGIN
1334:
1335: IF PO_LOG.d_proc THEN
1336: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1338: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1339: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1340: END IF;

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

1333: BEGIN
1334:
1335: IF PO_LOG.d_proc THEN
1336: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1338: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1339: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1340: END IF;
1341:

Line 1338: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);

1334:
1335: IF PO_LOG.d_proc THEN
1336: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1338: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1339: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1340: END IF;
1341:
1342: IF (x_results IS NULL) THEN

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

1335: IF PO_LOG.d_proc THEN
1336: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1337: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1338: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1339: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1340: END IF;
1341:
1342: IF (x_results IS NULL) THEN
1343: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1369: IF PO_LOG.d_proc THEN

1365: ELSE
1366: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1367: END IF;
1368:
1369: IF PO_LOG.d_proc THEN
1370: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1371: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1372: END IF;
1373: -- Bug 5532560 END

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

1366: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1367: END IF;
1368:
1369: IF PO_LOG.d_proc THEN
1370: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1371: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1372: END IF;
1373: -- Bug 5532560 END
1374: EXCEPTION

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

1367: END IF;
1368:
1369: IF PO_LOG.d_proc THEN
1370: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1371: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1372: END IF;
1373: -- Bug 5532560 END
1374: EXCEPTION
1375: WHEN OTHERS THEN

Line 1376: IF PO_LOG.d_exc THEN

1372: END IF;
1373: -- Bug 5532560 END
1374: EXCEPTION
1375: WHEN OTHERS THEN
1376: IF PO_LOG.d_exc THEN
1377: PO_LOG.exc(d_mod,0,NULL);
1378: END IF;
1379: RAISE;
1380:

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

1373: -- Bug 5532560 END
1374: EXCEPTION
1375: WHEN OTHERS THEN
1376: IF PO_LOG.d_exc THEN
1377: PO_LOG.exc(d_mod,0,NULL);
1378: END IF;
1379: RAISE;
1380:
1381: END unit_of_measure_not_null;