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

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

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

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

46: PO_LOG.get_package_base('PO_VAL_SHIPMENTS');
47:
48: -- The module base for the subprogram.
49: D_days_early_gte_zero CONSTANT VARCHAR2(100) :=
50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_early_gte_zero');
51:
52: -- The module base for the subprogram.
53: D_days_late_gte_zero CONSTANT VARCHAR2(100) :=
54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_late_gte_zero');

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

50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_early_gte_zero');
51:
52: -- The module base for the subprogram.
53: D_days_late_gte_zero CONSTANT VARCHAR2(100) :=
54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_late_gte_zero');
55:
56: -- The module base for the subprogram.
57: D_rcv_close_tol_within_range CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rcv_close_tol_within_range');

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

54: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'days_late_gte_zero');
55:
56: -- The module base for the subprogram.
57: D_rcv_close_tol_within_range CONSTANT VARCHAR2(100) :=
58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rcv_close_tol_within_range');
59:
60: -- The module base for the subprogram.
61: D_over_rcpt_tol_within_range CONSTANT VARCHAR2(100) :=
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'over_rcpt_tol_within_range');

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

58: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'rcv_close_tol_within_range');
59:
60: -- The module base for the subprogram.
61: D_over_rcpt_tol_within_range CONSTANT VARCHAR2(100) :=
62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'over_rcpt_tol_within_range');
63:
64: -- The module base for the subprogram.
65: D_planned_item_null_date_check CONSTANT VARCHAR2(100) :=
66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'planned_item_null_date_check');

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

62: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'over_rcpt_tol_within_range');
63:
64: -- The module base for the subprogram.
65: D_planned_item_null_date_check CONSTANT VARCHAR2(100) :=
66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'planned_item_null_date_check');
67:
68: -- The module base for the subprogram.
69: D_match_4way_check CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_4way_check');

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

66: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'planned_item_null_date_check');
67:
68: -- The module base for the subprogram.
69: D_match_4way_check CONSTANT VARCHAR2(100) :=
70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_4way_check');
71:
72: -- The module base for the subprogram.
73: D_inv_close_tol_range_check CONSTANT VARCHAR2(100) :=
74: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'inv_close_tol_range_check');

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

70: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'match_4way_check');
71:
72: -- The module base for the subprogram.
73: D_inv_close_tol_range_check CONSTANT VARCHAR2(100) :=
74: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'inv_close_tol_range_check');
75:
76: -- The module base for the subprogram.
77: D_need_by_date_open_per_check CONSTANT VARCHAR2(100) :=
78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'need_by_date_open_period_check');

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

74: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'inv_close_tol_range_check');
75:
76: -- The module base for the subprogram.
77: D_need_by_date_open_per_check CONSTANT VARCHAR2(100) :=
78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'need_by_date_open_period_check');
79:
80: -- The module base for the subprogram.
81: D_promise_date_open_per_check CONSTANT VARCHAR2(100) :=
82: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'promise_date_open_period_check');

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

78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'need_by_date_open_period_check');
79:
80: -- The module base for the subprogram.
81: D_promise_date_open_per_check CONSTANT VARCHAR2(100) :=
82: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'promise_date_open_period_check');
83:
84: -- The module base for the subprogram.
85: D_ship_to_org_null_check CONSTANT VARCHAR2(100) :=
86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_org_null_check');

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

82: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'promise_date_open_period_check');
83:
84: -- The module base for the subprogram.
85: D_ship_to_org_null_check CONSTANT VARCHAR2(100) :=
86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_org_null_check');
87:
88: -- The module base for the subprogram.
89: D_ship_to_loc_null_check CONSTANT VARCHAR2(100) :=
90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_null_check');

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

86: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_org_null_check');
87:
88: -- The module base for the subprogram.
89: D_ship_to_loc_null_check CONSTANT VARCHAR2(100) :=
90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_null_check');
91:
92: D_ship_num_gt_zero CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_gt_zero');
94:

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

89: D_ship_to_loc_null_check CONSTANT VARCHAR2(100) :=
90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_to_loc_null_check');
91:
92: D_ship_num_gt_zero CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_gt_zero');
94:
95: -- The module base for the subprogram.
96: D_ship_num_unique_check CONSTANT VARCHAR2(100) :=
97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_unique_check');

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

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

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

97: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_num_unique_check');
98:
99: -- The module base for the subprogram.
100: D_is_org_in_current_sob_check CONSTANT VARCHAR2(100) :=
101: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'is_org_in_current_sob_check');
102:
103: -- The module base for the subprogram.
104: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');

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

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

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

105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
106:
107: -- The module base for the subprogram.
108: D_ship_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
109: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_sec_quantity_gt_zero');
110:
111: -- The module base for the subprogram.
112: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');

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

109: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_sec_quantity_gt_zero');
110:
111: -- The module base for the subprogram.
112: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
114:
115: -- : Combined billed and rcvd into exec
116: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');

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

113: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
114:
115: -- : Combined billed and rcvd into exec
116: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');
118:
119: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_amount_exec');
121:

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

116: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
117: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_exec');
118:
119: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_amount_exec');
121:
122: --
123:
124: -- The module base for the subprogram.

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

122: --
123:
124: -- The module base for the subprogram.
125: D_ship_qtys_within_deviation CONSTANT VARCHAR2(100) :=
126: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_qtys_within_deviation');
127:
128: -- Bug 5385686 : Module base for the subprogram
129: D_unit_of_meas_not_null CONSTANT VARCHAR2(100) :=
130: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_of_meas_not_null');

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

126: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ship_qtys_within_deviation');
127:
128: -- Bug 5385686 : Module base for the subprogram
129: D_unit_of_meas_not_null CONSTANT VARCHAR2(100) :=
130: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_of_meas_not_null');
131:
132: --Mod Project
133: D_mod_no_cancel_shp_complt CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');

Line 134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');

130: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_of_meas_not_null');
131:
132: --Mod Project
133: D_mod_no_cancel_shp_complt CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');
135:
136: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
138:

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

133: D_mod_no_cancel_shp_complt CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mod_no_cancel_shp_complt');
135:
136: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
138:
139: D_complex_price_or_gt_zero CONSTANT VARCHAR2(100) :=
140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'complex_price_or_gt_zero');
141:

Line 140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'complex_price_or_gt_zero');

136: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
138:
139: D_complex_price_or_gt_zero CONSTANT VARCHAR2(100) :=
140: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'complex_price_or_gt_zero');
141:
142: -------------------------------------------------------------------------
143: -- Check if the days early value is greater than or equal to zero.
144: -------------------------------------------------------------------------

Line 273: IF PO_LOG.d_proc THEN

269: l_count NUMBER;
270:
271: BEGIN
272:
273: IF PO_LOG.d_proc THEN
274: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
275: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
276: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
277: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);

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

270:
271: BEGIN
272:
273: IF PO_LOG.d_proc THEN
274: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
275: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
276: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
277: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
278: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

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

271: BEGIN
272:
273: IF PO_LOG.d_proc THEN
274: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
275: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
276: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
277: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
278: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
279: END IF;

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

272:
273: IF PO_LOG.d_proc THEN
274: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
275: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
276: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
277: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
278: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
279: END IF;
280:

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

273: IF PO_LOG.d_proc THEN
274: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
275: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
276: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
277: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
278: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
279: END IF;
280:
281: IF (x_result_set_id IS NULL) THEN

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

274: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
275: PO_LOG.proc_begin(d_mod,'p_need_by_date_tbl',p_need_by_date_tbl);
276: PO_LOG.proc_begin(d_mod,'p_promised_date_tbl',p_promised_date_tbl);
277: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
278: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
279: END IF;
280:
281: IF (x_result_set_id IS NULL) THEN
282: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 339: IF PO_LOG.d_proc THEN

335: END IF;
336:
337: END IF;
338:
339: IF PO_LOG.d_proc THEN
340: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
341: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
342: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
343: END IF;

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

337: END IF;
338:
339: IF PO_LOG.d_proc THEN
340: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
341: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
342: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
343: END IF;
344:
345: EXCEPTION

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

338:
339: IF PO_LOG.d_proc THEN
340: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
341: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
342: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
343: END IF;
344:
345: EXCEPTION
346: WHEN OTHERS THEN

Line 347: IF PO_LOG.d_exc THEN

343: END IF;
344:
345: EXCEPTION
346: WHEN OTHERS THEN
347: IF PO_LOG.d_exc THEN
348: PO_LOG.exc(d_mod,0,NULL);
349: END IF;
350: RAISE;
351:

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

344:
345: EXCEPTION
346: WHEN OTHERS THEN
347: IF PO_LOG.d_exc THEN
348: PO_LOG.exc(d_mod,0,NULL);
349: END IF;
350: RAISE;
351:
352: END planned_item_null_date_check;

Line 374: IF PO_LOG.d_proc THEN

370:
371: l_results_count NUMBER;
372: BEGIN
373:
374: IF PO_LOG.d_proc THEN
375: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
376: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
377: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
378: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);

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

371: l_results_count NUMBER;
372: BEGIN
373:
374: IF PO_LOG.d_proc THEN
375: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
376: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
377: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
378: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
379: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);

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

372: BEGIN
373:
374: IF PO_LOG.d_proc THEN
375: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
376: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
377: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
378: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
379: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
380: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

373:
374: IF PO_LOG.d_proc THEN
375: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
376: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
377: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
378: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
379: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
380: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
381: END IF;

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

374: IF PO_LOG.d_proc THEN
375: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
376: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
377: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
378: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
379: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
380: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
381: END IF;
382:

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

375: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
376: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
377: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
378: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
379: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
380: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
381: END IF;
382:
383: IF (x_results IS NULL) THEN

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

376: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
377: PO_LOG.proc_begin(d_mod,'p_receipt_required_flag_tbl',p_receipt_required_flag_tbl);
378: PO_LOG.proc_begin(d_mod,'p_inspection_required_flag_tbl',p_inspection_required_flag_tbl);
379: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl', p_payment_type_tbl);
380: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
381: END IF;
382:
383: IF (x_results IS NULL) THEN
384: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 411: IF PO_LOG.d_proc THEN

407: ELSE
408: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
409: END IF;
410:
411: IF PO_LOG.d_proc THEN
412: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
413: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
414: END IF;
415:

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

408: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
409: END IF;
410:
411: IF PO_LOG.d_proc THEN
412: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
413: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
414: END IF;
415:
416: EXCEPTION

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

409: END IF;
410:
411: IF PO_LOG.d_proc THEN
412: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
413: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
414: END IF;
415:
416: EXCEPTION
417: WHEN OTHERS THEN

Line 418: IF PO_LOG.d_exc THEN

414: END IF;
415:
416: EXCEPTION
417: WHEN OTHERS THEN
418: IF PO_LOG.d_exc THEN
419: PO_LOG.exc(d_mod,0,NULL);
420: END IF;
421: RAISE;
422:

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

415:
416: EXCEPTION
417: WHEN OTHERS THEN
418: IF PO_LOG.d_exc THEN
419: PO_LOG.exc(d_mod,0,NULL);
420: END IF;
421: RAISE;
422:
423: END match_4way_check;

Line 541: IF PO_LOG.d_proc THEN

537: l_input_size NUMBER;
538: l_count NUMBER;
539: BEGIN
540:
541: IF PO_LOG.d_proc THEN
542: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
543: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
544: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
545: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

538: l_count NUMBER;
539: BEGIN
540:
541: IF PO_LOG.d_proc THEN
542: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
543: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
544: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
545: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
546: END IF;

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

539: BEGIN
540:
541: IF PO_LOG.d_proc THEN
542: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
543: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
544: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
545: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
546: END IF;
547:

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

540:
541: IF PO_LOG.d_proc THEN
542: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
543: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
544: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
545: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
546: END IF;
547:
548: l_input_size := p_line_loc_id_tbl.COUNT;

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

541: IF PO_LOG.d_proc THEN
542: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
543: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
544: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
545: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
546: END IF;
547:
548: l_input_size := p_line_loc_id_tbl.COUNT;
549:

Line 583: IF PO_LOG.d_exc THEN

579: );
580:
581: EXCEPTION
582: WHEN OTHERS THEN
583: IF PO_LOG.d_exc THEN
584: PO_LOG.exc(d_mod,0,NULL);
585: END IF;
586: RAISE;
587:

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

580:
581: EXCEPTION
582: WHEN OTHERS THEN
583: IF PO_LOG.d_exc THEN
584: PO_LOG.exc(d_mod,0,NULL);
585: END IF;
586: RAISE;
587:
588: END ship_to_org_null_check;

Line 609: IF PO_LOG.d_proc THEN

605: l_input_size NUMBER;
606: l_count NUMBER;
607: BEGIN
608:
609: IF PO_LOG.d_proc THEN
610: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
611: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
612: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
613: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

606: l_count NUMBER;
607: BEGIN
608:
609: IF PO_LOG.d_proc THEN
610: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
611: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
612: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
613: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
614: END IF;

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

607: BEGIN
608:
609: IF PO_LOG.d_proc THEN
610: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
611: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
612: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
613: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
614: END IF;
615:

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

608:
609: IF PO_LOG.d_proc THEN
610: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
611: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
612: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
613: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
614: END IF;
615:
616: l_input_size := p_line_loc_id_tbl.COUNT;

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

609: IF PO_LOG.d_proc THEN
610: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
611: PO_LOG.proc_begin(d_mod,'p_ship_to_loc_id_tbl',p_ship_to_loc_id_tbl);
612: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
613: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
614: END IF;
615:
616: l_input_size := p_line_loc_id_tbl.COUNT;
617:

Line 651: IF PO_LOG.d_exc THEN

647: );
648:
649: EXCEPTION
650: WHEN OTHERS THEN
651: IF PO_LOG.d_exc THEN
652: PO_LOG.exc(d_mod,0,NULL);
653: END IF;
654: RAISE;
655:

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

648:
649: EXCEPTION
650: WHEN OTHERS THEN
651: IF PO_LOG.d_exc THEN
652: PO_LOG.exc(d_mod,0,NULL);
653: END IF;
654: RAISE;
655:
656: END ship_to_loc_null_check;

Line 772: IF PO_LOG.d_proc THEN

768: l_in_sob BOOLEAN;
769: l_return_status VARCHAR(1);
770: BEGIN
771:
772: IF PO_LOG.d_proc THEN
773: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
774: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
775: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
776: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);

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

769: l_return_status VARCHAR(1);
770: BEGIN
771:
772: IF PO_LOG.d_proc THEN
773: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
774: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
775: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
776: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
777: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

770: BEGIN
771:
772: IF PO_LOG.d_proc THEN
773: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
774: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
775: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
776: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
777: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
778: END IF;

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

771:
772: IF PO_LOG.d_proc THEN
773: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
774: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
775: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
776: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
777: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
778: END IF;
779:

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

772: IF PO_LOG.d_proc THEN
773: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
774: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
775: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
776: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
777: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
778: END IF;
779:
780: IF (x_results IS NULL) THEN

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

773: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
774: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
775: PO_LOG.proc_begin(d_mod,'p_ship_to_org_id_tbl',p_ship_to_org_id_tbl);
776: PO_LOG.proc_begin(d_mod,'p_consigned_flag_tbl',p_consigned_flag_tbl);
777: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
778: END IF;
779:
780: IF (x_results IS NULL) THEN
781: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 866: IF PO_LOG.d_proc THEN

862: ELSE
863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
864: END IF;
865:
866: IF PO_LOG.d_proc THEN
867: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
868: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
869: END IF;
870:

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

863: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
864: END IF;
865:
866: IF PO_LOG.d_proc THEN
867: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
868: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
869: END IF;
870:
871: EXCEPTION

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

864: END IF;
865:
866: IF PO_LOG.d_proc THEN
867: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
868: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
869: END IF;
870:
871: EXCEPTION
872: WHEN OTHERS THEN

Line 873: IF PO_LOG.d_exc THEN

869: END IF;
870:
871: EXCEPTION
872: WHEN OTHERS THEN
873: IF PO_LOG.d_exc THEN
874: PO_LOG.exc(d_mod,0,NULL);
875: END IF;
876: RAISE;
877:

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

870:
871: EXCEPTION
872: WHEN OTHERS THEN
873: IF PO_LOG.d_exc THEN
874: PO_LOG.exc(d_mod,0,NULL);
875: END IF;
876: RAISE;
877:
878: END is_org_in_current_sob_check;

Line 906: IF PO_LOG.d_proc THEN

902: l_entity_id NUMBER;
903:
904: BEGIN
905:
906: IF PO_LOG.d_proc THEN
907: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
908: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
909: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
910: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);

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

903:
904: BEGIN
905:
906: IF PO_LOG.d_proc THEN
907: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
908: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
909: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
910: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
911: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

904: BEGIN
905:
906: IF PO_LOG.d_proc THEN
907: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
908: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
909: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
910: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
911: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
912: END IF;

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

905:
906: IF PO_LOG.d_proc THEN
907: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
908: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
909: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
910: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
911: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
912: END IF;
913:

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

906: IF PO_LOG.d_proc THEN
907: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
908: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
909: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
910: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
911: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
912: END IF;
913:
914: l_input_size := p_line_loc_id_tbl.COUNT;

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

907: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
908: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
909: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
910: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
911: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
912: END IF;
913:
914: l_input_size := p_line_loc_id_tbl.COUNT;
915:

Line 948: IF PO_LOG.d_stmt THEN

944: IF (p_header_id_tbl.Count > 0)
945: THEN
946: l_entity_id := p_header_id_tbl(1);
947:
948: IF PO_LOG.d_stmt THEN
949: PO_LOG.stmt(d_mod,0,'l_entity_id ',l_entity_id);
950: END IF;
951:
952: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_header_id => l_entity_id);

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

945: THEN
946: l_entity_id := p_header_id_tbl(1);
947:
948: IF PO_LOG.d_stmt THEN
949: PO_LOG.stmt(d_mod,0,'l_entity_id ',l_entity_id);
950: END IF;
951:
952: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_header_id => l_entity_id);
953: END IF;

Line 955: IF PO_LOG.d_stmt THEN

951:
952: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_header_id => l_entity_id);
953: END IF;
954:
955: IF PO_LOG.d_stmt THEN
956: PO_LOG.stmt(d_mod,10,'l_is_clm_po ',l_is_clm_po);
957: END IF;
958:
959: IF l_is_clm_po = 'Y'

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

952: l_is_clm_po := PO_CLM_INTG_GRP.Is_clm_po(p_po_header_id => l_entity_id);
953: END IF;
954:
955: IF PO_LOG.d_stmt THEN
956: PO_LOG.stmt(d_mod,10,'l_is_clm_po ',l_is_clm_po);
957: END IF;
958:
959: IF l_is_clm_po = 'Y'
960: THEN

Line 992: IF PO_LOG.d_exc THEN

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

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

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

Line 1018: IF PO_LOG.d_proc THEN

1014: IS
1015: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
1016: BEGIN
1017:
1018: IF PO_LOG.d_proc THEN
1019: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1020: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1021: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1022: END IF;

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

1015: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
1016: BEGIN
1017:
1018: IF PO_LOG.d_proc THEN
1019: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1020: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1021: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1022: END IF;
1023:

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

1016: BEGIN
1017:
1018: IF PO_LOG.d_proc THEN
1019: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1020: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1021: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1022: END IF;
1023:
1024: IF (x_result_set_id IS NULL) THEN

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

1017:
1018: IF PO_LOG.d_proc THEN
1019: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1020: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1021: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1022: END IF;
1023:
1024: IF (x_result_set_id IS NULL) THEN
1025: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1090: IF PO_LOG.d_proc THEN

1086: ELSE
1087: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1088: END IF;
1089:
1090: IF PO_LOG.d_proc THEN
1091: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1092: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1093: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1094: END IF;

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

1088: END IF;
1089:
1090: IF PO_LOG.d_proc THEN
1091: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1092: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1093: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1094: END IF;
1095:
1096: EXCEPTION

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

1089:
1090: IF PO_LOG.d_proc THEN
1091: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1092: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1093: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1094: END IF;
1095:
1096: EXCEPTION
1097: WHEN OTHERS THEN

Line 1098: IF PO_LOG.d_exc THEN

1094: END IF;
1095:
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: IF PO_LOG.d_exc THEN
1099: PO_LOG.exc(d_mod,0,NULL);
1100: END IF;
1101: RAISE;
1102:

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

1095:
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: IF PO_LOG.d_exc THEN
1099: PO_LOG.exc(d_mod,0,NULL);
1100: END IF;
1101: RAISE;
1102:
1103: END quantity_ge_quantity_exec;

Line 1134: IF PO_LOG.d_proc THEN

1130: l_entity_id NUMBER;
1131:
1132: BEGIN
1133:
1134: IF PO_LOG.d_proc THEN
1135: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1136: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1137: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1138: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);

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

1131:
1132: BEGIN
1133:
1134: IF PO_LOG.d_proc THEN
1135: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1136: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1137: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1138: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1139: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

1132: BEGIN
1133:
1134: IF PO_LOG.d_proc THEN
1135: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1136: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1137: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1138: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1139: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1140: END IF;

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

1133:
1134: IF PO_LOG.d_proc THEN
1135: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1136: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1137: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1138: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1139: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1140: END IF;
1141:

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

1134: IF PO_LOG.d_proc THEN
1135: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1136: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1137: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1138: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1139: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1140: END IF;
1141:
1142: l_input_size := p_line_loc_id_tbl.COUNT;

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

1135: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1136: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1137: PO_LOG.proc_begin(d_mod,'p_shipment_type_tbl',p_shipment_type_tbl);
1138: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1139: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1140: END IF;
1141:
1142: l_input_size := p_line_loc_id_tbl.COUNT;
1143:

Line 1176: IF PO_LOG.d_stmt THEN

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

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

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

Line 1183: IF PO_LOG.d_stmt THEN

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

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

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

Line 1220: IF PO_LOG.d_exc THEN

1216: --
1217:
1218: EXCEPTION
1219: WHEN OTHERS THEN
1220: IF PO_LOG.d_exc THEN
1221: PO_LOG.exc(d_mod,0,NULL);
1222: END IF;
1223: RAISE;
1224:

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

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

Line 1246: IF PO_LOG.d_proc THEN

1242: IS
1243: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_amount_exec;
1244: BEGIN
1245:
1246: IF PO_LOG.d_proc THEN
1247: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1248: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1249: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1250: END IF;

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

1243: d_mod CONSTANT VARCHAR2(100) := D_amount_ge_amount_exec;
1244: BEGIN
1245:
1246: IF PO_LOG.d_proc THEN
1247: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1248: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1249: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1250: END IF;
1251:

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

1244: BEGIN
1245:
1246: IF PO_LOG.d_proc THEN
1247: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1248: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1249: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1250: END IF;
1251:
1252: IF (x_result_set_id IS NULL) THEN

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

1245:
1246: IF PO_LOG.d_proc THEN
1247: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1248: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
1249: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1250: END IF;
1251:
1252: IF (x_result_set_id IS NULL) THEN
1253: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1315: IF PO_LOG.d_proc THEN

1311: ELSE
1312: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1313: END IF;
1314:
1315: IF PO_LOG.d_proc THEN
1316: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1317: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1318: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1319: END IF;

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

1313: END IF;
1314:
1315: IF PO_LOG.d_proc THEN
1316: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1317: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1318: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1319: END IF;
1320:
1321: EXCEPTION

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

1314:
1315: IF PO_LOG.d_proc THEN
1316: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1317: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1318: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1319: END IF;
1320:
1321: EXCEPTION
1322: WHEN OTHERS THEN

Line 1323: IF PO_LOG.d_exc THEN

1319: END IF;
1320:
1321: EXCEPTION
1322: WHEN OTHERS THEN
1323: IF PO_LOG.d_exc THEN
1324: PO_LOG.exc(d_mod,0,NULL);
1325: END IF;
1326: RAISE;
1327:

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

1320:
1321: EXCEPTION
1322: WHEN OTHERS THEN
1323: IF PO_LOG.d_exc THEN
1324: PO_LOG.exc(d_mod,0,NULL);
1325: END IF;
1326: RAISE;
1327:
1328: END amount_ge_amount_exec;

Line 1349: IF PO_LOG.d_proc THEN

1345: IS
1346: d_mod CONSTANT VARCHAR2(100) := D_ship_sec_quantity_gt_zero;
1347: BEGIN
1348:
1349: IF PO_LOG.d_proc THEN
1350: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1351: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1352: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1353: END IF;

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

1346: d_mod CONSTANT VARCHAR2(100) := D_ship_sec_quantity_gt_zero;
1347: BEGIN
1348:
1349: IF PO_LOG.d_proc THEN
1350: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1351: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1352: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1353: END IF;
1354:

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

1347: BEGIN
1348:
1349: IF PO_LOG.d_proc THEN
1350: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1351: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1352: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1353: END IF;
1354:
1355: PO_VALIDATION_HELPER.gt_zero_opm_filter(

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

1348:
1349: IF PO_LOG.d_proc THEN
1350: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1351: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1352: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1353: END IF;
1354:
1355: PO_VALIDATION_HELPER.gt_zero_opm_filter(
1356: p_calling_module => D_ship_sec_quantity_gt_zero

Line 1369: IF PO_LOG.d_exc THEN

1365: );
1366:
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: IF PO_LOG.d_exc THEN
1370: PO_LOG.exc(d_mod,0,NULL);
1371: END IF;
1372: RAISE;
1373:

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

1366:
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: IF PO_LOG.d_exc THEN
1370: PO_LOG.exc(d_mod,0,NULL);
1371: END IF;
1372: RAISE;
1373:
1374: END ship_sec_quantity_gt_zero;

Line 1398: IF PO_LOG.d_proc THEN

1394: d_mod CONSTANT VARCHAR2(100) := D_ship_qtys_within_deviation;
1395:
1396: BEGIN
1397:
1398: IF PO_LOG.d_proc THEN
1399: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1400: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1401: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1402: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

1395:
1396: BEGIN
1397:
1398: IF PO_LOG.d_proc THEN
1399: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1400: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1401: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1402: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1403: END IF;

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

1396: BEGIN
1397:
1398: IF PO_LOG.d_proc THEN
1399: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1400: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1401: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1402: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1403: END IF;
1404:

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

1397:
1398: IF PO_LOG.d_proc THEN
1399: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1400: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1401: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1402: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1403: END IF;
1404:
1405: PO_VALIDATION_HELPER.qtys_within_deviation (

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

1398: IF PO_LOG.d_proc THEN
1399: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1400: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_sec_quantity_tbl);
1401: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1402: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1403: END IF;
1404:
1405: PO_VALIDATION_HELPER.qtys_within_deviation (
1406: p_calling_module => D_ship_qtys_within_deviation

Line 1421: IF PO_LOG.d_exc THEN

1417: );
1418:
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: IF PO_LOG.d_exc THEN
1422: PO_LOG.exc(d_mod,0,NULL);
1423: END IF;
1424: RAISE;
1425:

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

1418:
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: IF PO_LOG.d_exc THEN
1422: PO_LOG.exc(d_mod,0,NULL);
1423: END IF;
1424: RAISE;
1425:
1426: END ship_qtys_within_deviation;

Line 1448: IF PO_LOG.d_proc THEN

1444:
1445: l_results_count NUMBER;
1446: BEGIN
1447:
1448: IF PO_LOG.d_proc THEN
1449: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1450: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1451: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

1445: l_results_count NUMBER;
1446: BEGIN
1447:
1448: IF PO_LOG.d_proc THEN
1449: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1450: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1451: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1453: END IF;

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

1446: BEGIN
1447:
1448: IF PO_LOG.d_proc THEN
1449: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1450: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1451: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1453: END IF;
1454:

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

1447:
1448: IF PO_LOG.d_proc THEN
1449: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1450: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1451: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1453: END IF;
1454:
1455: IF (x_results IS NULL) THEN

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

1448: IF PO_LOG.d_proc THEN
1449: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1450: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1451: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1452: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1453: END IF;
1454:
1455: IF (x_results IS NULL) THEN
1456: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1482: IF PO_LOG.d_proc THEN

1478: ELSE
1479: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1480: END IF;
1481:
1482: IF PO_LOG.d_proc THEN
1483: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1484: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1485: END IF;
1486: -- Bug 5532560 END

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

1479: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1480: END IF;
1481:
1482: IF PO_LOG.d_proc THEN
1483: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1484: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1485: END IF;
1486: -- Bug 5532560 END
1487: EXCEPTION

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

1480: END IF;
1481:
1482: IF PO_LOG.d_proc THEN
1483: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1484: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1485: END IF;
1486: -- Bug 5532560 END
1487: EXCEPTION
1488: WHEN OTHERS THEN

Line 1489: IF PO_LOG.d_exc THEN

1485: END IF;
1486: -- Bug 5532560 END
1487: EXCEPTION
1488: WHEN OTHERS THEN
1489: IF PO_LOG.d_exc THEN
1490: PO_LOG.exc(d_mod,0,NULL);
1491: END IF;
1492: RAISE;
1493:

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

1486: -- Bug 5532560 END
1487: EXCEPTION
1488: WHEN OTHERS THEN
1489: IF PO_LOG.d_exc THEN
1490: PO_LOG.exc(d_mod,0,NULL);
1491: END IF;
1492: RAISE;
1493:
1494: END unit_of_measure_not_null;

Line 1507: IF PO_LOG.d_proc THEN

1503: IS
1504: d_mod CONSTANT VARCHAR2(100) := D_mod_no_cancel_shp_complt;
1505: BEGIN
1506:
1507: IF PO_LOG.d_proc THEN
1508: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1509: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
1510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1511: END IF;

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

1504: d_mod CONSTANT VARCHAR2(100) := D_mod_no_cancel_shp_complt;
1505: BEGIN
1506:
1507: IF PO_LOG.d_proc THEN
1508: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1509: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
1510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1511: END IF;
1512: IF (x_result_set_id IS NULL) THEN

Line 1509: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);

1505: BEGIN
1506:
1507: IF PO_LOG.d_proc THEN
1508: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1509: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
1510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1511: END IF;
1512: IF (x_result_set_id IS NULL) THEN
1513: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

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

1506:
1507: IF PO_LOG.d_proc THEN
1508: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1509: PO_LOG.proc_begin(d_mod,'p_control_action_tbl',p_control_action_tbl);
1510: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1511: END IF;
1512: IF (x_result_set_id IS NULL) THEN
1513: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1514: END IF;

Line 1545: IF PO_LOG.d_proc THEN

1541: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1542: END IF;
1543:
1544:
1545: IF PO_LOG.d_proc THEN
1546: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1547: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1548: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1549: END IF;

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

1543:
1544:
1545: IF PO_LOG.d_proc THEN
1546: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1547: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1548: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1549: END IF;
1550:
1551: EXCEPTION

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

1544:
1545: IF PO_LOG.d_proc THEN
1546: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1547: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1548: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1549: END IF;
1550:
1551: EXCEPTION
1552: WHEN OTHERS THEN

Line 1553: IF PO_LOG.d_exc THEN

1549: END IF;
1550:
1551: EXCEPTION
1552: WHEN OTHERS THEN
1553: IF PO_LOG.d_exc THEN
1554: PO_LOG.exc(d_mod,0,NULL);
1555: END IF;
1556: RAISE;
1557: END mod_no_cancel_shp_complt;

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

1550:
1551: EXCEPTION
1552: WHEN OTHERS THEN
1553: IF PO_LOG.d_exc THEN
1554: PO_LOG.exc(d_mod,0,NULL);
1555: END IF;
1556: RAISE;
1557: END mod_no_cancel_shp_complt;
1558:

Line 1688: IF PO_LOG.d_proc THEN

1684: l_price_override_tbl PO_TBL_NUMBER;
1685: l_input_size NUMBER;
1686: l_count NUMBER;
1687: BEGIN
1688: IF PO_LOG.d_proc THEN
1689: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1690: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1691: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1692: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);

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

1685: l_input_size NUMBER;
1686: l_count NUMBER;
1687: BEGIN
1688: IF PO_LOG.d_proc THEN
1689: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1690: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1691: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1692: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1693: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

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

1686: l_count NUMBER;
1687: BEGIN
1688: IF PO_LOG.d_proc THEN
1689: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1690: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1691: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1692: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1693: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1694: END IF;

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

1687: BEGIN
1688: IF PO_LOG.d_proc THEN
1689: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1690: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1691: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1692: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1693: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1694: END IF;
1695:

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

1688: IF PO_LOG.d_proc THEN
1689: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1690: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1691: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1692: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1693: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1694: END IF;
1695:
1696:

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

1689: PO_LOG.proc_begin(d_mod,'p_line_loc_id_tbl',p_line_loc_id_tbl);
1690: PO_LOG.proc_begin(d_mod,'p_price_override_tbl',p_price_override_tbl);
1691: PO_LOG.proc_begin(d_mod,'p_value_basis_tbl',p_value_basis_tbl);
1692: PO_LOG.proc_begin(d_mod,'p_payment_type_tbl',p_payment_type_tbl);
1693: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1694: END IF;
1695:
1696:
1697: l_input_size := p_line_loc_id_tbl.COUNT;

Line 1732: IF PO_LOG.d_exc THEN

1728: , x_result_type => x_result_type
1729: );
1730: EXCEPTION
1731: WHEN OTHERS THEN
1732: IF PO_LOG.d_exc THEN
1733: PO_LOG.exc(d_mod,0,NULL);
1734: END IF;
1735: RAISE;
1736: END complex_price_or_gt_zero;

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

1729: );
1730: EXCEPTION
1731: WHEN OTHERS THEN
1732: IF PO_LOG.d_exc THEN
1733: PO_LOG.exc(d_mod,0,NULL);
1734: END IF;
1735: RAISE;
1736: END complex_price_or_gt_zero;
1737: