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

Line 52: PO_LOG.get_package_base('PO_VAL_LINES');

48: c_MAX_RETAINAGE_AMOUNT VARCHAR(30) := 'MAX_RETAINAGE_AMOUNT'; -- Bug 5221843
49:
50: -- The module base for this package.
51: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
52: PO_LOG.get_package_base('PO_VAL_LINES');
53:
54: -- The module base for the subprogram.
55: D_amt_agreed_ge_zero CONSTANT VARCHAR2(100) :=
56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_agreed_ge_zero');

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

52: PO_LOG.get_package_base('PO_VAL_LINES');
53:
54: -- The module base for the subprogram.
55: D_amt_agreed_ge_zero CONSTANT VARCHAR2(100) :=
56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_agreed_ge_zero');
57:
58: -- The module base for the subprogram.
59: D_min_rel_amt_ge_zero CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_rel_amt_ge_zero');

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

56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amt_agreed_ge_zero');
57:
58: -- The module base for the subprogram.
59: D_min_rel_amt_ge_zero CONSTANT VARCHAR2(100) :=
60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_rel_amt_ge_zero');
61:
62: -- The module base for the subprogram.
63: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');

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

60: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_rel_amt_ge_zero');
61:
62: -- The module base for the subprogram.
63: D_quantity_gt_zero CONSTANT VARCHAR2(100) :=
64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
65:
66: -- The module base for the subprogram.
67: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
68: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');

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

64: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_gt_zero');
65:
66: -- The module base for the subprogram.
67: D_amount_gt_zero CONSTANT VARCHAR2(100) :=
68: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
69:
70: -- The module base for the subprogram.
71: D_line_num_gt_zero CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_gt_zero');

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

68: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_gt_zero');
69:
70: -- The module base for the subprogram.
71: D_line_num_gt_zero CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_gt_zero');
73:
74: D_otl_inv_start_date_change CONSTANT VARCHAR2(100) :=
75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_start_date_change');
76:

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

71: D_line_num_gt_zero CONSTANT VARCHAR2(100) :=
72: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_gt_zero');
73:
74: D_otl_inv_start_date_change CONSTANT VARCHAR2(100) :=
75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_start_date_change');
76:
77: D_otl_invalid_end_date_change CONSTANT VARCHAR2(100) :=
78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_end_date_change');
79:

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

74: D_otl_inv_start_date_change CONSTANT VARCHAR2(100) :=
75: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_start_date_change');
76:
77: D_otl_invalid_end_date_change CONSTANT VARCHAR2(100) :=
78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_end_date_change');
79:
80: D_quantity_notif_change CONSTANT VARCHAR2(100) :=
81: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_notif_change');
82:

Line 81: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_notif_change');

77: D_otl_invalid_end_date_change CONSTANT VARCHAR2(100) :=
78: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'otl_invalid_end_date_change');
79:
80: D_quantity_notif_change CONSTANT VARCHAR2(100) :=
81: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_notif_change');
82:
83: D_unit_price_ge_zero CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_price_ge_zero');
85:

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

80: D_quantity_notif_change CONSTANT VARCHAR2(100) :=
81: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_notif_change');
82:
83: D_unit_price_ge_zero CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_price_ge_zero');
85:
86: D_list_price_ge_zero CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'list_price_ge_zero');
88:

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

83: D_unit_price_ge_zero CONSTANT VARCHAR2(100) :=
84: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unit_price_ge_zero');
85:
86: D_list_price_ge_zero CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'list_price_ge_zero');
88:
89: D_market_price_ge_zero CONSTANT VARCHAR2(100) :=
90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'market_price_ge_zero');
91:

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

86: D_list_price_ge_zero CONSTANT VARCHAR2(100) :=
87: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'list_price_ge_zero');
88:
89: D_market_price_ge_zero CONSTANT VARCHAR2(100) :=
90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'market_price_ge_zero');
91:
92: D_quantity_ge_quantity_enc CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_enc');
94:

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

89: D_market_price_ge_zero CONSTANT VARCHAR2(100) :=
90: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'market_price_ge_zero');
91:
92: D_quantity_ge_quantity_enc CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_enc');
94:
95: D_amount_ge_timecard CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_timecard');
97:

Line 96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_timecard');

92: D_quantity_ge_quantity_enc CONSTANT VARCHAR2(100) :=
93: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'quantity_ge_quantity_enc');
94:
95: D_amount_ge_timecard CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_timecard');
97:
98: D_line_num_unique CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_unique');
100:

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

95: D_amount_ge_timecard CONSTANT VARCHAR2(100) :=
96: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'amount_ge_timecard');
97:
98: D_line_num_unique CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_unique');
100:
101: D_vmi_asl_exists CONSTANT VARCHAR2(100) :=
102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vmi_asl_exists');
103:

Line 102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vmi_asl_exists');

98: D_line_num_unique CONSTANT VARCHAR2(100) :=
99: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_num_unique');
100:
101: D_vmi_asl_exists CONSTANT VARCHAR2(100) :=
102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vmi_asl_exists');
103:
104: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
106:

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

101: D_vmi_asl_exists CONSTANT VARCHAR2(100) :=
102: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'vmi_asl_exists');
103:
104: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
106:
107: D_validate_unit_price_change CONSTANT VARCHAR2(100) :=
108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');
109:

Line 108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');

104: D_start_date_le_end_date CONSTANT VARCHAR2(100) :=
105: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'start_date_le_end_date');
106:
107: D_validate_unit_price_change CONSTANT VARCHAR2(100) :=
108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');
109:
110: D_expiration_ge_blanket_start CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_ge_blanket_start');
112:

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

107: D_validate_unit_price_change CONSTANT VARCHAR2(100) :=
108: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'validate_unit_price_change');
109:
110: D_expiration_ge_blanket_start CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_ge_blanket_start');
112:
113: D_expiration_le_blanket_end CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_le_blanket_end');
115:

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

110: D_expiration_ge_blanket_start CONSTANT VARCHAR2(100) :=
111: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_ge_blanket_start');
112:
113: D_expiration_le_blanket_end CONSTANT VARCHAR2(100) :=
114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_le_blanket_end');
115:
116: -- : Removed/added debug variables
117: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
118: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'quantity_ge_quantity_exec');

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

114: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'expiration_le_blanket_end');
115:
116: -- : Removed/added debug variables
117: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
118: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'quantity_ge_quantity_exec');
119: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_ge_amount_exec');
121: D_price_ge_price_mstone_exec CONSTANT VARCHAR2(100) :=
122: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'price_ge_price_milestone_exec');

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

116: -- : Removed/added debug variables
117: D_quantity_ge_quantity_exec CONSTANT VARCHAR2(100) :=
118: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'quantity_ge_quantity_exec');
119: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_ge_amount_exec');
121: D_price_ge_price_mstone_exec CONSTANT VARCHAR2(100) :=
122: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'price_ge_price_milestone_exec');
123: D_qty_ge_qty_milestone_exec CONSTANT VARCHAR2(100) :=
124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_ge_qty_milestone_exec');

Line 122: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'price_ge_price_milestone_exec');

118: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'quantity_ge_quantity_exec');
119: D_amount_ge_amount_exec CONSTANT VARCHAR2(100) :=
120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_ge_amount_exec');
121: D_price_ge_price_mstone_exec CONSTANT VARCHAR2(100) :=
122: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'price_ge_price_milestone_exec');
123: D_qty_ge_qty_milestone_exec CONSTANT VARCHAR2(100) :=
124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_ge_qty_milestone_exec');
125: -- Bug 5072189 Start
126: D_recoupment_rate_range_check CONSTANT VARCHAR2(100) :=

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

120: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'amount_ge_amount_exec');
121: D_price_ge_price_mstone_exec CONSTANT VARCHAR2(100) :=
122: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'price_ge_price_milestone_exec');
123: D_qty_ge_qty_milestone_exec CONSTANT VARCHAR2(100) :=
124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_ge_qty_milestone_exec');
125: -- Bug 5072189 Start
126: D_recoupment_rate_range_check CONSTANT VARCHAR2(100) :=
127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'recoupment_rate_range_check');
128: D_retainage_rate_range_check CONSTANT VARCHAR2(100) :=

Line 127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'recoupment_rate_range_check');

123: D_qty_ge_qty_milestone_exec CONSTANT VARCHAR2(100) :=
124: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'qty_ge_qty_milestone_exec');
125: -- Bug 5072189 Start
126: D_recoupment_rate_range_check CONSTANT VARCHAR2(100) :=
127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'recoupment_rate_range_check');
128: D_retainage_rate_range_check CONSTANT VARCHAR2(100) :=
129: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'retainage_rate_range_check');
130: D_prog_pay_rate_range_check CONSTANT VARCHAR2(100) :=
131: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'prog_pay_rate_range_check');

Line 129: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'retainage_rate_range_check');

125: -- Bug 5072189 Start
126: D_recoupment_rate_range_check CONSTANT VARCHAR2(100) :=
127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'recoupment_rate_range_check');
128: D_retainage_rate_range_check CONSTANT VARCHAR2(100) :=
129: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'retainage_rate_range_check');
130: D_prog_pay_rate_range_check CONSTANT VARCHAR2(100) :=
131: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'prog_pay_rate_range_check');
132: -- Bug 5072189 End
133: D_max_retain_amt_ge_zero CONSTANT VARCHAR2(100) :=

Line 131: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'prog_pay_rate_range_check');

127: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'recoupment_rate_range_check');
128: D_retainage_rate_range_check CONSTANT VARCHAR2(100) :=
129: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'retainage_rate_range_check');
130: D_prog_pay_rate_range_check CONSTANT VARCHAR2(100) :=
131: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'prog_pay_rate_range_check');
132: -- Bug 5072189 End
133: D_max_retain_amt_ge_zero CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_zero'); --Bug 5221843
135: D_max_retain_amt_ge_retained CONSTANT VARCHAR2(100) :=

Line 134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_zero'); --Bug 5221843

130: D_prog_pay_rate_range_check CONSTANT VARCHAR2(100) :=
131: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'prog_pay_rate_range_check');
132: -- Bug 5072189 End
133: D_max_retain_amt_ge_zero CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_zero'); --Bug 5221843
135: D_max_retain_amt_ge_retained CONSTANT VARCHAR2(100) :=
136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_retained'); --Bug 5453079
137: -- Bug 5070210 Start
138: D_advance_amt_le_amt CONSTANT VARCHAR2(100) :=

Line 136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_retained'); --Bug 5453079

132: -- Bug 5072189 End
133: D_max_retain_amt_ge_zero CONSTANT VARCHAR2(100) :=
134: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_zero'); --Bug 5221843
135: D_max_retain_amt_ge_retained CONSTANT VARCHAR2(100) :=
136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_retained'); --Bug 5453079
137: -- Bug 5070210 Start
138: D_advance_amt_le_amt CONSTANT VARCHAR2(100) :=
139: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'advance_amt_le_amt');
140: -- Bug 5070210 End

Line 139: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'advance_amt_le_amt');

135: D_max_retain_amt_ge_retained CONSTANT VARCHAR2(100) :=
136: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'max_retain_amt_ge_retained'); --Bug 5453079
137: -- Bug 5070210 Start
138: D_advance_amt_le_amt CONSTANT VARCHAR2(100) :=
139: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'advance_amt_le_amt');
140: -- Bug 5070210 End
141: --
142: D_unit_meas_not_null CONSTANT VARCHAR2(100) :=
143: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unit_meas_not_null');

Line 143: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unit_meas_not_null');

139: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'advance_amt_le_amt');
140: -- Bug 5070210 End
141: --
142: D_unit_meas_not_null CONSTANT VARCHAR2(100) :=
143: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unit_meas_not_null');
144: D_item_description_not_null CONSTANT VARCHAR2(100) :=
145: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_description_not_null');
146: D_category_id_not_null CONSTANT VARCHAR2(100) :=
147: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');

Line 145: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_description_not_null');

141: --
142: D_unit_meas_not_null CONSTANT VARCHAR2(100) :=
143: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unit_meas_not_null');
144: D_item_description_not_null CONSTANT VARCHAR2(100) :=
145: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_description_not_null');
146: D_category_id_not_null CONSTANT VARCHAR2(100) :=
147: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');
148: D_item_id_not_null CONSTANT VARCHAR2(100) :=
149: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');

Line 147: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');

143: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'unit_meas_not_null');
144: D_item_description_not_null CONSTANT VARCHAR2(100) :=
145: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_description_not_null');
146: D_category_id_not_null CONSTANT VARCHAR2(100) :=
147: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');
148: D_item_id_not_null CONSTANT VARCHAR2(100) :=
149: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');
150: D_temp_labor_job_id_not_null CONSTANT VARCHAR2(100) :=
151: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');

Line 149: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');

145: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_description_not_null');
146: D_category_id_not_null CONSTANT VARCHAR2(100) :=
147: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');
148: D_item_id_not_null CONSTANT VARCHAR2(100) :=
149: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');
150: D_temp_labor_job_id_not_null CONSTANT VARCHAR2(100) :=
151: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');
152: D_line_type_id_not_null CONSTANT VARCHAR2(100) :=
153: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');

Line 151: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');

147: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'category_id_not_null');
148: D_item_id_not_null CONSTANT VARCHAR2(100) :=
149: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');
150: D_temp_labor_job_id_not_null CONSTANT VARCHAR2(100) :=
151: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');
152: D_line_type_id_not_null CONSTANT VARCHAR2(100) :=
153: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');
154: D_temp_lbr_start_date_not_null CONSTANT VARCHAR2(100) :=
155: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'temp_lbr_start_date_not_null');

Line 153: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');

149: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'item_id_not_null');
150: D_temp_labor_job_id_not_null CONSTANT VARCHAR2(100) :=
151: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');
152: D_line_type_id_not_null CONSTANT VARCHAR2(100) :=
153: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');
154: D_temp_lbr_start_date_not_null CONSTANT VARCHAR2(100) :=
155: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'temp_lbr_start_date_not_null');
156: D_src_doc_line_not_null CONSTANT VARCHAR2(100) :=
157: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'src_doc_line_not_null');

Line 155: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'temp_lbr_start_date_not_null');

151: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, 'temp_labor_job_id_not_null');
152: D_line_type_id_not_null CONSTANT VARCHAR2(100) :=
153: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');
154: D_temp_lbr_start_date_not_null CONSTANT VARCHAR2(100) :=
155: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'temp_lbr_start_date_not_null');
156: D_src_doc_line_not_null CONSTANT VARCHAR2(100) :=
157: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'src_doc_line_not_null');
158: -- The module base for the subprogram.
159: D_line_qtys_within_deviation CONSTANT VARCHAR2(100) :=

Line 157: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'src_doc_line_not_null');

153: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_type_id_not_null');
154: D_temp_lbr_start_date_not_null CONSTANT VARCHAR2(100) :=
155: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'temp_lbr_start_date_not_null');
156: D_src_doc_line_not_null CONSTANT VARCHAR2(100) :=
157: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'src_doc_line_not_null');
158: -- The module base for the subprogram.
159: D_line_qtys_within_deviation CONSTANT VARCHAR2(100) :=
160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_qtys_within_deviation');
161: D_line_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=

Line 160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_qtys_within_deviation');

156: D_src_doc_line_not_null CONSTANT VARCHAR2(100) :=
157: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'src_doc_line_not_null');
158: -- The module base for the subprogram.
159: D_line_qtys_within_deviation CONSTANT VARCHAR2(100) :=
160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_qtys_within_deviation');
161: D_line_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_sec_quantity_gt_zero');
163: D_from_line_id_not_null CONSTANT VARCHAR2(100) :=
164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'from_line_id_not_null');

Line 162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_sec_quantity_gt_zero');

158: -- The module base for the subprogram.
159: D_line_qtys_within_deviation CONSTANT VARCHAR2(100) :=
160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_qtys_within_deviation');
161: D_line_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_sec_quantity_gt_zero');
163: D_from_line_id_not_null CONSTANT VARCHAR2(100) :=
164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'from_line_id_not_null');
165:
166: -------------------------------------------------------------------------------

Line 164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'from_line_id_not_null');

160: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_qtys_within_deviation');
161: D_line_sec_quantity_gt_zero CONSTANT VARCHAR2(100) :=
162: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'line_sec_quantity_gt_zero');
163: D_from_line_id_not_null CONSTANT VARCHAR2(100) :=
164: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'from_line_id_not_null');
165:
166: -------------------------------------------------------------------------------
167: -- This procedure determines if Amount Agreed on blanket lines is greater
168: -- than or equal to zero. If not, return a failure.

Line 271: IF PO_LOG.d_proc THEN

267: IS
268: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
269: BEGIN
270:
271: IF PO_LOG.d_proc THEN
272: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
273: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
274: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
275: END IF;

Line 272: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

268: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_exec;
269: BEGIN
270:
271: IF PO_LOG.d_proc THEN
272: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
273: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
274: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
275: END IF;
276:

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

269: BEGIN
270:
271: IF PO_LOG.d_proc THEN
272: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
273: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
274: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
275: END IF;
276:
277: IF (x_result_set_id IS NULL) THEN

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

270:
271: IF PO_LOG.d_proc THEN
272: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
273: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
274: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
275: END IF;
276:
277: IF (x_result_set_id IS NULL) THEN
278: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 353: IF PO_LOG.d_proc THEN

349: ELSE
350: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
351: END IF;
352:
353: IF PO_LOG.d_proc THEN
354: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
355: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
356: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
357: END IF;

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

351: END IF;
352:
353: IF PO_LOG.d_proc THEN
354: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
355: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
356: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
357: END IF;
358:
359: EXCEPTION

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

352:
353: IF PO_LOG.d_proc THEN
354: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
355: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
356: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
357: END IF;
358:
359: EXCEPTION
360: WHEN OTHERS THEN

Line 361: IF PO_LOG.d_exc THEN

357: END IF;
358:
359: EXCEPTION
360: WHEN OTHERS THEN
361: IF PO_LOG.d_exc THEN
362: PO_LOG.exc(d_mod,0,NULL);
363: END IF;
364: RAISE;
365:

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

358:
359: EXCEPTION
360: WHEN OTHERS THEN
361: IF PO_LOG.d_exc THEN
362: PO_LOG.exc(d_mod,0,NULL);
363: END IF;
364: RAISE;
365:
366: END quantity_ge_quantity_exec;

Line 386: IF PO_LOG.d_proc THEN

382: BEGIN
383:
384: IF p_line_id_tbl IS not null
385: THEN
386: IF PO_LOG.d_proc THEN
387: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
388: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
389: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
390: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 387: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

383:
384: IF p_line_id_tbl IS not null
385: THEN
386: IF PO_LOG.d_proc THEN
387: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
388: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
389: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
390: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
391: END IF;

Line 388: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);

384: IF p_line_id_tbl IS not null
385: THEN
386: IF PO_LOG.d_proc THEN
387: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
388: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
389: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
390: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
391: END IF;
392:

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

385: THEN
386: IF PO_LOG.d_proc THEN
387: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
388: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
389: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
390: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
391: END IF;
392:
393:

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

386: IF PO_LOG.d_proc THEN
387: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
388: PO_LOG.proc_begin(d_mod,'p_advance_tbl',p_advance_tbl);
389: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
390: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
391: END IF;
392:
393:
394: IF (x_results IS NULL) THEN

Line 438: IF PO_LOG.d_proc THEN

434: IS
435: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_enc;
436: BEGIN
437:
438: IF PO_LOG.d_proc THEN
439: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
440: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
441: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
442: END IF;

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

435: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_enc;
436: BEGIN
437:
438: IF PO_LOG.d_proc THEN
439: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
440: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
441: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
442: END IF;
443:

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

436: BEGIN
437:
438: IF PO_LOG.d_proc THEN
439: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
440: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
441: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
442: END IF;
443:
444: IF (x_result_set_id IS NULL) THEN

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

437:
438: IF PO_LOG.d_proc THEN
439: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
440: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
441: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
442: END IF;
443:
444: IF (x_result_set_id IS NULL) THEN
445: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 494: IF PO_LOG.d_proc THEN

490: ELSE
491: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
492: END IF;
493:
494: IF PO_LOG.d_proc THEN
495: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
496: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
497: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
498: END IF;

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

492: END IF;
493:
494: IF PO_LOG.d_proc THEN
495: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
496: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
497: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
498: END IF;
499:
500: EXCEPTION

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

493:
494: IF PO_LOG.d_proc THEN
495: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
496: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
497: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
498: END IF;
499:
500: EXCEPTION
501: WHEN OTHERS THEN

Line 502: IF PO_LOG.d_exc THEN

498: END IF;
499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: IF PO_LOG.d_exc THEN
503: PO_LOG.exc(d_mod,0,NULL);
504: END IF;
505: RAISE;
506:

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

499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: IF PO_LOG.d_exc THEN
503: PO_LOG.exc(d_mod,0,NULL);
504: END IF;
505: RAISE;
506:
507: END quantity_ge_quantity_enc;

Line 593: IF PO_LOG.d_proc THEN

589: BEGIN
590:
591: d_progress := 0.0;
592:
593: IF PO_LOG.d_proc THEN
594: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
595: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
596: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
597: END IF;

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

590:
591: d_progress := 0.0;
592:
593: IF PO_LOG.d_proc THEN
594: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
595: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
596: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
597: END IF;
598:

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

591: d_progress := 0.0;
592:
593: IF PO_LOG.d_proc THEN
594: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
595: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
596: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
597: END IF;
598:
599: d_progress := 10.0;

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

592:
593: IF PO_LOG.d_proc THEN
594: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
595: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
596: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
597: END IF;
598:
599: d_progress := 10.0;
600:

Line 744: IF PO_LOG.d_proc THEN

740: END IF;
741:
742: d_progress := 60.0;
743:
744: IF PO_LOG.d_proc THEN
745: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
746: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
747: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
748: END IF;

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

742: d_progress := 60.0;
743:
744: IF PO_LOG.d_proc THEN
745: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
746: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
747: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
748: END IF;
749:
750: d_progress := 70.0;

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

743:
744: IF PO_LOG.d_proc THEN
745: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
746: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
747: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
748: END IF;
749:
750: d_progress := 70.0;
751:

Line 754: IF PO_LOG.d_exc THEN

750: d_progress := 70.0;
751:
752: EXCEPTION
753: WHEN OTHERS THEN
754: IF PO_LOG.d_exc THEN
755: PO_LOG.exc(d_mod,d_progress,NULL);
756: END IF;
757: RAISE;
758:

Line 755: PO_LOG.exc(d_mod,d_progress,NULL);

751:
752: EXCEPTION
753: WHEN OTHERS THEN
754: IF PO_LOG.d_exc THEN
755: PO_LOG.exc(d_mod,d_progress,NULL);
756: END IF;
757: RAISE;
758:
759: END amount_ge_amount_exec;

Line 789: IF PO_LOG.d_proc THEN

785: l_timecard_amount_sum NUMBER;
786: l_return_status VARCHAR2(1);
787: BEGIN
788:
789: IF PO_LOG.d_proc THEN
790: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
791: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
792: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
793: END IF;

Line 790: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

786: l_return_status VARCHAR2(1);
787: BEGIN
788:
789: IF PO_LOG.d_proc THEN
790: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
791: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
792: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
793: END IF;
794:

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

787: BEGIN
788:
789: IF PO_LOG.d_proc THEN
790: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
791: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
792: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
793: END IF;
794:
795: IF (x_results IS NULL) THEN

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

788:
789: IF PO_LOG.d_proc THEN
790: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
791: PO_LOG.proc_begin(d_mod,'p_amount_tbl',p_amount_tbl);
792: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
793: END IF;
794:
795: IF (x_results IS NULL) THEN
796: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 874: IF PO_LOG.d_proc THEN

870: ELSE
871: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
872: END IF;
873:
874: IF PO_LOG.d_proc THEN
875: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
876: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
877: END IF;
878:

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

871: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
872: END IF;
873:
874: IF PO_LOG.d_proc THEN
875: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
876: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
877: END IF;
878:
879: EXCEPTION

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

872: END IF;
873:
874: IF PO_LOG.d_proc THEN
875: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
876: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
877: END IF;
878:
879: EXCEPTION
880: WHEN OTHERS THEN

Line 881: IF PO_LOG.d_exc THEN

877: END IF;
878:
879: EXCEPTION
880: WHEN OTHERS THEN
881: IF PO_LOG.d_exc THEN
882: PO_LOG.exc(d_mod,0,NULL);
883: END IF;
884: RAISE;
885:

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

878:
879: EXCEPTION
880: WHEN OTHERS THEN
881: IF PO_LOG.d_exc THEN
882: PO_LOG.exc(d_mod,0,NULL);
883: END IF;
884: RAISE;
885:
886: END amount_ge_timecard;

Line 974: IF PO_LOG.d_proc THEN

970: -- Flag indicating if profile PO_VMI_DISPLAY_WARNING is on
971: l_po_vmi_display_warning VARCHAR2(2000);
972: BEGIN
973:
974: IF PO_LOG.d_proc THEN
975: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
976: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
977: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
978: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);

Line 975: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

971: l_po_vmi_display_warning VARCHAR2(2000);
972: BEGIN
973:
974: IF PO_LOG.d_proc THEN
975: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
976: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
977: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
978: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
979: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);

Line 976: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);

972: BEGIN
973:
974: IF PO_LOG.d_proc THEN
975: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
976: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
977: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
978: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
979: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
980: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);

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

973:
974: IF PO_LOG.d_proc THEN
975: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
976: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
977: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
978: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
979: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
980: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
981: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

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

974: IF PO_LOG.d_proc THEN
975: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
976: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
977: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
978: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
979: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
980: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
981: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
982: END IF;

Line 979: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);

975: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
976: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
977: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
978: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
979: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
980: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
981: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
982: END IF;
983:

Line 980: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);

976: PO_LOG.proc_begin(d_mod,'p_type_lookup_code_tbl',p_type_lookup_code_tbl);
977: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
978: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
979: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
980: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
981: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
982: END IF;
983:
984: IF (x_result_set_id IS NULL) THEN

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

977: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
978: PO_LOG.proc_begin(d_mod,'p_org_id_tbl',p_org_id_tbl);
979: PO_LOG.proc_begin(d_mod,'p_vendor_id_tbl',p_vendor_id_tbl);
980: PO_LOG.proc_begin(d_mod,'p_vendor_site_id_tbl',p_vendor_site_id_tbl);
981: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
982: END IF;
983:
984: IF (x_result_set_id IS NULL) THEN
985: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1045: IF PO_LOG.d_proc THEN

1041: END IF;
1042:
1043: END IF;
1044:
1045: IF PO_LOG.d_proc THEN
1046: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1047: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1048: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1049: END IF;

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

1043: END IF;
1044:
1045: IF PO_LOG.d_proc THEN
1046: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1047: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1048: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1049: END IF;
1050:
1051: EXCEPTION

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

1044:
1045: IF PO_LOG.d_proc THEN
1046: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1047: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1048: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1049: END IF;
1050:
1051: EXCEPTION
1052: WHEN OTHERS THEN

Line 1053: IF PO_LOG.d_exc THEN

1049: END IF;
1050:
1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: IF PO_LOG.d_exc THEN
1054: PO_LOG.exc(d_mod,0,NULL);
1055: END IF;
1056: RAISE;
1057:

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

1050:
1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: IF PO_LOG.d_exc THEN
1054: PO_LOG.exc(d_mod,0,NULL);
1055: END IF;
1056: RAISE;
1057:
1058: END vmi_asl_exists;

Line 1176: IF PO_LOG.d_proc THEN

1172: l_input_size NUMBER;
1173: l_count NUMBER;
1174: BEGIN
1175:
1176: IF PO_LOG.d_proc THEN
1177: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1178: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1179: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1180: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1177: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

1173: l_count NUMBER;
1174: BEGIN
1175:
1176: IF PO_LOG.d_proc THEN
1177: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1178: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1179: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1180: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1181: END IF;

Line 1178: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);

1174: BEGIN
1175:
1176: IF PO_LOG.d_proc THEN
1177: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1178: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1179: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1180: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1181: END IF;
1182:

Line 1179: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);

1175:
1176: IF PO_LOG.d_proc THEN
1177: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1178: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1179: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1180: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1181: END IF;
1182:
1183: l_input_size := p_line_id_tbl.COUNT;

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

1176: IF PO_LOG.d_proc THEN
1177: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1178: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1179: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1180: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1181: END IF;
1182:
1183: l_input_size := p_line_id_tbl.COUNT;
1184:

Line 1217: IF PO_LOG.d_exc THEN

1213: );
1214:
1215: EXCEPTION
1216: WHEN OTHERS THEN
1217: IF PO_LOG.d_exc THEN
1218: PO_LOG.exc(d_mod,0,NULL);
1219: END IF;
1220: RAISE;
1221:

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

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

Line 1301: IF PO_LOG.d_proc THEN

1297: l_line_id_tbl PO_TBL_NUMBER;
1298: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
1299: BEGIN
1300:
1301: IF PO_LOG.d_proc THEN
1302: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1303: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1304: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
1305: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1302: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

1298: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
1299: BEGIN
1300:
1301: IF PO_LOG.d_proc THEN
1302: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1303: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1304: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
1305: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1306: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1303: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);

1299: BEGIN
1300:
1301: IF PO_LOG.d_proc THEN
1302: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1303: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1304: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
1305: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1306: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1307: END IF;

Line 1304: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);

1300:
1301: IF PO_LOG.d_proc THEN
1302: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1303: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1304: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
1305: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1306: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1307: END IF;
1308:

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

1301: IF PO_LOG.d_proc THEN
1302: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1303: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1304: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
1305: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1306: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1307: END IF;
1308:
1309: l_data_key := PO_CORE_S.get_session_gt_nextval();

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

1302: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1303: PO_LOG.proc_begin(d_mod,'p_unit_price_tbl',p_unit_price_tbl);
1304: PO_LOG.proc_begin(d_mod,'p_price_break_lookup_code_tbl',p_price_break_lookup_code_tbl);
1305: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1306: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1307: END IF;
1308:
1309: l_data_key := PO_CORE_S.get_session_gt_nextval();
1310:

Line 1363: IF PO_LOG.d_proc THEN

1359:
1360: END IF;
1361:
1362:
1363: IF PO_LOG.d_proc THEN
1364: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1365: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1366: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1367: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);

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

1361:
1362:
1363: IF PO_LOG.d_proc THEN
1364: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1365: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1366: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1367: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1368: END IF;
1369:

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

1362:
1363: IF PO_LOG.d_proc THEN
1364: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1365: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1366: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1367: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1368: END IF;
1369:
1370: EXCEPTION

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

1363: IF PO_LOG.d_proc THEN
1364: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1365: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1366: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1367: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1368: END IF;
1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN

Line 1372: IF PO_LOG.d_exc THEN

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

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

1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN
1372: IF PO_LOG.d_exc THEN
1373: PO_LOG.exc(d_mod,0,NULL);
1374: END IF;
1375: RAISE;
1376:
1377: END validate_unit_price_change;

Line 1537: IF PO_LOG.d_proc THEN

1533: IS
1534: d_mod CONSTANT VARCHAR2(100) := D_qty_ge_qty_milestone_exec;
1535: BEGIN
1536:
1537: IF PO_LOG.d_proc THEN
1538: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1539: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1540: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1541: END IF;

Line 1538: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

1534: d_mod CONSTANT VARCHAR2(100) := D_qty_ge_qty_milestone_exec;
1535: BEGIN
1536:
1537: IF PO_LOG.d_proc THEN
1538: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1539: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1540: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1541: END IF;
1542:

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

1535: BEGIN
1536:
1537: IF PO_LOG.d_proc THEN
1538: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1539: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1540: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1541: END IF;
1542:
1543: IF (x_result_set_id IS NULL) THEN

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

1536:
1537: IF PO_LOG.d_proc THEN
1538: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1539: PO_LOG.proc_begin(d_mod,'p_quantity_tbl',p_quantity_tbl);
1540: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1541: END IF;
1542:
1543: IF (x_result_set_id IS NULL) THEN
1544: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1601: IF PO_LOG.d_proc THEN

1597: ELSE
1598: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1599: END IF;
1600:
1601: IF PO_LOG.d_proc THEN
1602: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1603: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1604: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1605: END IF;

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

1599: END IF;
1600:
1601: IF PO_LOG.d_proc THEN
1602: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1603: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1604: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1605: END IF;
1606:
1607: EXCEPTION

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

1600:
1601: IF PO_LOG.d_proc THEN
1602: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1603: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1604: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1605: END IF;
1606:
1607: EXCEPTION
1608: WHEN OTHERS THEN

Line 1609: IF PO_LOG.d_exc THEN

1605: END IF;
1606:
1607: EXCEPTION
1608: WHEN OTHERS THEN
1609: IF PO_LOG.d_exc THEN
1610: PO_LOG.exc(d_mod,0,NULL);
1611: END IF;
1612: RAISE;
1613:

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

1606:
1607: EXCEPTION
1608: WHEN OTHERS THEN
1609: IF PO_LOG.d_exc THEN
1610: PO_LOG.exc(d_mod,0,NULL);
1611: END IF;
1612: RAISE;
1613:
1614: END qty_ge_qty_milestone_exec;

Line 1632: IF PO_LOG.d_proc THEN

1628: IS
1629: d_mod CONSTANT VARCHAR2(100) := D_price_ge_price_mstone_exec;
1630: BEGIN
1631:
1632: IF PO_LOG.d_proc THEN
1633: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1634: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl);
1635: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1636: END IF;

Line 1633: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

1629: d_mod CONSTANT VARCHAR2(100) := D_price_ge_price_mstone_exec;
1630: BEGIN
1631:
1632: IF PO_LOG.d_proc THEN
1633: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1634: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl);
1635: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1636: END IF;
1637:

Line 1634: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl);

1630: BEGIN
1631:
1632: IF PO_LOG.d_proc THEN
1633: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1634: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl);
1635: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1636: END IF;
1637:
1638: IF (x_result_set_id IS NULL) THEN

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

1631:
1632: IF PO_LOG.d_proc THEN
1633: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1634: PO_LOG.proc_begin(d_mod,'p_price_tbl',p_price_tbl);
1635: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1636: END IF;
1637:
1638: IF (x_result_set_id IS NULL) THEN
1639: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1689: IF PO_LOG.d_proc THEN

1685: ELSE
1686: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1687: END IF;
1688:
1689: IF PO_LOG.d_proc THEN
1690: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1691: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1692: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1693: END IF;

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

1687: END IF;
1688:
1689: IF PO_LOG.d_proc THEN
1690: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1691: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1692: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1693: END IF;
1694:
1695: EXCEPTION

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

1688:
1689: IF PO_LOG.d_proc THEN
1690: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1691: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1692: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1693: END IF;
1694:
1695: EXCEPTION
1696: WHEN OTHERS THEN

Line 1697: IF PO_LOG.d_exc THEN

1693: END IF;
1694:
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: IF PO_LOG.d_exc THEN
1698: PO_LOG.exc(d_mod,0,NULL);
1699: END IF;
1700: RAISE;
1701:

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

1694:
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: IF PO_LOG.d_exc THEN
1698: PO_LOG.exc(d_mod,0,NULL);
1699: END IF;
1700: RAISE;
1701:
1702: END price_ge_price_milestone_exec;

Line 1722: IF PO_LOG.d_proc THEN

1718: d_mod CONSTANT VARCHAR2(100) := D_unit_meas_not_null;
1719: l_results_count NUMBER;
1720: BEGIN
1721:
1722: IF PO_LOG.d_proc THEN
1723: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1724: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1725: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1726: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1723: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

1719: l_results_count NUMBER;
1720: BEGIN
1721:
1722: IF PO_LOG.d_proc THEN
1723: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1724: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1725: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1726: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1727: END IF;

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

1720: BEGIN
1721:
1722: IF PO_LOG.d_proc THEN
1723: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1724: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1725: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1726: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1727: END IF;
1728:

Line 1725: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);

1721:
1722: IF PO_LOG.d_proc THEN
1723: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1724: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1725: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1726: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1727: END IF;
1728:
1729: IF (x_results IS NULL) THEN

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

1722: IF PO_LOG.d_proc THEN
1723: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1724: PO_LOG.proc_begin(d_mod,'p_unit_meas_lookup_code_tbl',p_unit_meas_lookup_code_tbl);
1725: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1726: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1727: END IF;
1728:
1729: IF (x_results IS NULL) THEN
1730: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1755: IF PO_LOG.d_proc THEN

1751: ELSE
1752: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1753: END IF;
1754:
1755: IF PO_LOG.d_proc THEN
1756: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1757: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1758: END IF;
1759:

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

1752: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1753: END IF;
1754:
1755: IF PO_LOG.d_proc THEN
1756: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1757: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1758: END IF;
1759:
1760: EXCEPTION

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

1753: END IF;
1754:
1755: IF PO_LOG.d_proc THEN
1756: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1757: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1758: END IF;
1759:
1760: EXCEPTION
1761: WHEN OTHERS THEN

Line 1762: IF PO_LOG.d_exc THEN

1758: END IF;
1759:
1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: IF PO_LOG.d_exc THEN
1763: PO_LOG.exc(d_mod,0,NULL);
1764: END IF;
1765: RAISE;
1766:

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

1759:
1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: IF PO_LOG.d_exc THEN
1763: PO_LOG.exc(d_mod,0,NULL);
1764: END IF;
1765: RAISE;
1766:
1767: END unit_meas_not_null;

Line 1845: IF PO_LOG.d_proc THEN

1841: l_count NUMBER;
1842:
1843: BEGIN
1844:
1845: IF PO_LOG.d_proc THEN
1846: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
1847: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1848: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1849: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);

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

1842:
1843: BEGIN
1844:
1845: IF PO_LOG.d_proc THEN
1846: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
1847: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1848: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1849: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
1850: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

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

1843: BEGIN
1844:
1845: IF PO_LOG.d_proc THEN
1846: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
1847: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1848: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1849: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
1850: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1851: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 1848: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);

1844:
1845: IF PO_LOG.d_proc THEN
1846: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
1847: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1848: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1849: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
1850: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1851: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1852: END IF;

Line 1849: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);

1845: IF PO_LOG.d_proc THEN
1846: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
1847: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1848: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1849: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
1850: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1851: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1852: END IF;
1853:

Line 1850: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);

1846: PO_LOG.proc_begin(d_mod,'p_id_tbl',p_id_tbl);
1847: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1848: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1849: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
1850: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1851: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1852: END IF;
1853:
1854: IF (x_result_set_id IS NULL) THEN

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

1847: PO_LOG.proc_begin(d_mod,'p_item_id_tbl',p_item_id_tbl);
1848: PO_LOG.proc_begin(d_mod,'p_order_type_lookup_code_tbl',p_order_type_lookup_code_tbl);
1849: PO_LOG.proc_begin(d_mod,'p_line_type_id_tbl',p_line_type_id_tbl);
1850: PO_LOG.proc_begin(d_mod,'p_message_name',p_message_name);
1851: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1852: END IF;
1853:
1854: IF (x_result_set_id IS NULL) THEN
1855: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 1913: IF PO_LOG.d_proc THEN

1909: END IF;
1910:
1911: END IF;
1912:
1913: IF PO_LOG.d_proc THEN
1914: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1915: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1916: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1917: END IF;

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

1911: END IF;
1912:
1913: IF PO_LOG.d_proc THEN
1914: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1915: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1916: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1917: END IF;
1918:
1919: EXCEPTION

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

1912:
1913: IF PO_LOG.d_proc THEN
1914: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1915: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1916: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1917: END IF;
1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN

Line 1921: IF PO_LOG.d_exc THEN

1917: END IF;
1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: IF PO_LOG.d_exc THEN
1922: PO_LOG.exc(d_mod,0,NULL);
1923: END IF;
1924: RAISE;
1925:

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

1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: IF PO_LOG.d_exc THEN
1922: PO_LOG.exc(d_mod,0,NULL);
1923: END IF;
1924: RAISE;
1925:
1926: END item_id_not_null;

Line 1944: IF PO_LOG.d_proc THEN

1940: d_mod CONSTANT VARCHAR2(100) := D_temp_labor_job_id_not_null;
1941: l_results_count NUMBER;
1942: BEGIN
1943:
1944: IF PO_LOG.d_proc THEN
1945: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1946: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
1947: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
1948: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 1945: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

1941: l_results_count NUMBER;
1942: BEGIN
1943:
1944: IF PO_LOG.d_proc THEN
1945: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1946: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
1947: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
1948: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1949: END IF;

Line 1946: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);

1942: BEGIN
1943:
1944: IF PO_LOG.d_proc THEN
1945: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1946: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
1947: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
1948: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1949: END IF;
1950:

Line 1947: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);

1943:
1944: IF PO_LOG.d_proc THEN
1945: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1946: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
1947: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
1948: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1949: END IF;
1950:
1951: IF (x_results IS NULL) THEN

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

1944: IF PO_LOG.d_proc THEN
1945: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
1946: PO_LOG.proc_begin(d_mod,'p_job_id_tbl',p_job_id_tbl);
1947: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
1948: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1949: END IF;
1950:
1951: IF (x_results IS NULL) THEN
1952: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 1977: IF PO_LOG.d_proc THEN

1973: ELSE
1974: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1975: END IF;
1976:
1977: IF PO_LOG.d_proc THEN
1978: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1979: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1980: END IF;
1981:

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

1974: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1975: END IF;
1976:
1977: IF PO_LOG.d_proc THEN
1978: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1979: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1980: END IF;
1981:
1982: EXCEPTION

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

1975: END IF;
1976:
1977: IF PO_LOG.d_proc THEN
1978: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1979: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
1980: END IF;
1981:
1982: EXCEPTION
1983: WHEN OTHERS THEN

Line 1984: IF PO_LOG.d_exc THEN

1980: END IF;
1981:
1982: EXCEPTION
1983: WHEN OTHERS THEN
1984: IF PO_LOG.d_exc THEN
1985: PO_LOG.exc(d_mod,0,NULL);
1986: END IF;
1987: RAISE;
1988:

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

1981:
1982: EXCEPTION
1983: WHEN OTHERS THEN
1984: IF PO_LOG.d_exc THEN
1985: PO_LOG.exc(d_mod,0,NULL);
1986: END IF;
1987: RAISE;
1988:
1989: END temp_labor_job_id_not_null;

Line 2011: IF PO_LOG.d_proc THEN

2007: IF (x_results IS NULL) THEN
2008: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2009: END IF;
2010:
2011: IF PO_LOG.d_proc THEN
2012: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2013: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2014: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2015: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 2012: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

2008: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
2009: END IF;
2010:
2011: IF PO_LOG.d_proc THEN
2012: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2013: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2014: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2015: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2016: END IF;

Line 2013: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);

2009: END IF;
2010:
2011: IF PO_LOG.d_proc THEN
2012: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2013: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2014: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2015: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2016: END IF;
2017:

Line 2014: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);

2010:
2011: IF PO_LOG.d_proc THEN
2012: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2013: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2014: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2015: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2016: END IF;
2017:
2018: l_results_count := x_results.result_type.COUNT;

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

2011: IF PO_LOG.d_proc THEN
2012: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2013: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2014: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2015: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2016: END IF;
2017:
2018: l_results_count := x_results.result_type.COUNT;
2019:

Line 2040: IF PO_LOG.d_proc THEN

2036: ELSE
2037: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2038: END IF;
2039:
2040: IF PO_LOG.d_proc THEN
2041: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2042: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2043: END IF;
2044:

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

2037: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2038: END IF;
2039:
2040: IF PO_LOG.d_proc THEN
2041: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2042: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2043: END IF;
2044:
2045: EXCEPTION

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

2038: END IF;
2039:
2040: IF PO_LOG.d_proc THEN
2041: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2042: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2043: END IF;
2044:
2045: EXCEPTION
2046: WHEN OTHERS THEN

Line 2047: IF PO_LOG.d_exc THEN

2043: END IF;
2044:
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: IF PO_LOG.d_exc THEN
2048: PO_LOG.exc(d_mod,0,NULL);
2049: END IF;
2050: RAISE;
2051: END src_doc_line_not_null;

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

2044:
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: IF PO_LOG.d_exc THEN
2048: PO_LOG.exc(d_mod,0,NULL);
2049: END IF;
2050: RAISE;
2051: END src_doc_line_not_null;
2052:

Line 2093: IF PO_LOG.d_proc THEN

2089: d_mod CONSTANT VARCHAR2(100) := D_temp_lbr_start_date_not_null;
2090: l_results_count NUMBER;
2091: BEGIN
2092:
2093: IF PO_LOG.d_proc THEN
2094: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2095: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
2096: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2097: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 2094: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

2090: l_results_count NUMBER;
2091: BEGIN
2092:
2093: IF PO_LOG.d_proc THEN
2094: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2095: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
2096: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2097: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2098: END IF;

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

2091: BEGIN
2092:
2093: IF PO_LOG.d_proc THEN
2094: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2095: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
2096: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2097: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2098: END IF;
2099:

Line 2096: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);

2092:
2093: IF PO_LOG.d_proc THEN
2094: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2095: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
2096: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2097: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2098: END IF;
2099:
2100: IF (x_results IS NULL) THEN

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

2093: IF PO_LOG.d_proc THEN
2094: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2095: PO_LOG.proc_begin(d_mod,'p_start_date_tbl',p_start_date_tbl);
2096: PO_LOG.proc_begin(d_mod,'p_purchase_basis_tbl',p_purchase_basis_tbl);
2097: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2098: END IF;
2099:
2100: IF (x_results IS NULL) THEN
2101: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 2126: IF PO_LOG.d_proc THEN

2122: ELSE
2123: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2124: END IF;
2125:
2126: IF PO_LOG.d_proc THEN
2127: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2128: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2129: END IF;
2130:

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

2123: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2124: END IF;
2125:
2126: IF PO_LOG.d_proc THEN
2127: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2128: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2129: END IF;
2130:
2131: EXCEPTION

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

2124: END IF;
2125:
2126: IF PO_LOG.d_proc THEN
2127: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2128: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2129: END IF;
2130:
2131: EXCEPTION
2132: WHEN OTHERS THEN

Line 2133: IF PO_LOG.d_exc THEN

2129: END IF;
2130:
2131: EXCEPTION
2132: WHEN OTHERS THEN
2133: IF PO_LOG.d_exc THEN
2134: PO_LOG.exc(d_mod,0,NULL);
2135: END IF;
2136: RAISE;
2137:

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

2130:
2131: EXCEPTION
2132: WHEN OTHERS THEN
2133: IF PO_LOG.d_exc THEN
2134: PO_LOG.exc(d_mod,0,NULL);
2135: END IF;
2136: RAISE;
2137:
2138: END temp_lbr_start_date_not_null;

Line 2160: IF PO_LOG.d_proc THEN

2156: l_input_size NUMBER;
2157:
2158: BEGIN
2159:
2160: IF PO_LOG.d_proc THEN
2161: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2162: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
2163: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2164: END IF;

Line 2161: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

2157:
2158: BEGIN
2159:
2160: IF PO_LOG.d_proc THEN
2161: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2162: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
2163: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2164: END IF;
2165:

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

2158: BEGIN
2159:
2160: IF PO_LOG.d_proc THEN
2161: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2162: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
2163: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2164: END IF;
2165:
2166: -- SQL What : Get the default inv org id

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

2159:
2160: IF PO_LOG.d_proc THEN
2161: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2162: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
2163: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2164: END IF;
2165:
2166: -- SQL What : Get the default inv org id
2167: -- SQL Why : To pass to the Opm Validations

Line 2195: IF PO_LOG.d_exc THEN

2191: );
2192:
2193: EXCEPTION
2194: WHEN OTHERS THEN
2195: IF PO_LOG.d_exc THEN
2196: PO_LOG.exc(d_mod,0,NULL);
2197: END IF;
2198: RAISE;
2199:

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

2192:
2193: EXCEPTION
2194: WHEN OTHERS THEN
2195: IF PO_LOG.d_exc THEN
2196: PO_LOG.exc(d_mod,0,NULL);
2197: END IF;
2198: RAISE;
2199:
2200: END line_sec_quantity_gt_zero;

Line 2226: IF PO_LOG.d_proc THEN

2222: l_def_inv_org_id NUMBER;
2223:
2224: BEGIN
2225:
2226: IF PO_LOG.d_proc THEN
2227: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2228: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
2229: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2230: END IF;

Line 2227: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

2223:
2224: BEGIN
2225:
2226: IF PO_LOG.d_proc THEN
2227: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2228: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
2229: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2230: END IF;
2231:

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

2224: BEGIN
2225:
2226: IF PO_LOG.d_proc THEN
2227: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2228: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
2229: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2230: END IF;
2231:
2232: -- SQL What : Get the default inv org id

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

2225:
2226: IF PO_LOG.d_proc THEN
2227: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2228: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
2229: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2230: END IF;
2231:
2232: -- SQL What : Get the default inv org id
2233: -- SQL Why : To pass to the Opm Validations

Line 2263: IF PO_LOG.d_exc THEN

2259: );
2260:
2261: EXCEPTION
2262: WHEN OTHERS THEN
2263: IF PO_LOG.d_exc THEN
2264: PO_LOG.exc(d_mod,0,NULL);
2265: END IF;
2266: RAISE;
2267:

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

2260:
2261: EXCEPTION
2262: WHEN OTHERS THEN
2263: IF PO_LOG.d_exc THEN
2264: PO_LOG.exc(d_mod,0,NULL);
2265: END IF;
2266: RAISE;
2267:
2268: END line_qtys_within_deviation;

Line 2289: IF PO_LOG.d_proc THEN

2285: l_src_doc_type_lookup_code VARCHAR2(30) := null;
2286: l_from_header_id NUMBER;
2287: BEGIN
2288:
2289: IF PO_LOG.d_proc THEN
2290: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2291: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2292: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 2290: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

2286: l_from_header_id NUMBER;
2287: BEGIN
2288:
2289: IF PO_LOG.d_proc THEN
2290: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2291: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2292: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2294: END IF;

Line 2291: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);

2287: BEGIN
2288:
2289: IF PO_LOG.d_proc THEN
2290: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2291: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2292: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2294: END IF;
2295:

Line 2292: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);

2288:
2289: IF PO_LOG.d_proc THEN
2290: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2291: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2292: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2294: END IF;
2295:
2296: IF (x_results IS NULL) THEN

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

2289: IF PO_LOG.d_proc THEN
2290: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2291: PO_LOG.proc_begin(d_mod,'p_from_header_id_tbl',p_from_header_id_tbl);
2292: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
2293: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
2294: END IF;
2295:
2296: IF (x_results IS NULL) THEN
2297: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();

Line 2342: IF PO_LOG.d_proc THEN

2338: ELSE
2339: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2340: END IF;
2341:
2342: IF PO_LOG.d_proc THEN
2343: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2344: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2345: END IF;
2346:

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

2339: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2340: END IF;
2341:
2342: IF PO_LOG.d_proc THEN
2343: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2344: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2345: END IF;
2346:
2347: EXCEPTION

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

2340: END IF;
2341:
2342: IF PO_LOG.d_proc THEN
2343: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2344: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
2345: END IF;
2346:
2347: EXCEPTION
2348: WHEN OTHERS THEN

Line 2349: IF PO_LOG.d_exc THEN

2345: END IF;
2346:
2347: EXCEPTION
2348: WHEN OTHERS THEN
2349: IF PO_LOG.d_exc THEN
2350: PO_LOG.exc(d_mod,0,NULL);
2351: END IF;
2352: RAISE;
2353:

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

2346:
2347: EXCEPTION
2348: WHEN OTHERS THEN
2349: IF PO_LOG.d_exc THEN
2350: PO_LOG.exc(d_mod,0,NULL);
2351: END IF;
2352: RAISE;
2353:
2354: END from_line_id_not_null;

Line 2403: IF PO_LOG.d_proc THEN

2399: d_mod CONSTANT VARCHAR2(100) := D_quantity_ge_quantity_enc;
2400:
2401: BEGIN
2402:
2403: IF PO_LOG.d_proc THEN
2404: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2405: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
2406: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2407: END IF;

Line 2404: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

2400:
2401: BEGIN
2402:
2403: IF PO_LOG.d_proc THEN
2404: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2405: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
2406: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2407: END IF;
2408:

Line 2405: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);

2401: BEGIN
2402:
2403: IF PO_LOG.d_proc THEN
2404: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2405: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
2406: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2407: END IF;
2408:
2409: IF (x_result_set_id IS NULL) THEN

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

2402:
2403: IF PO_LOG.d_proc THEN
2404: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);
2405: PO_LOG.proc_begin(d_mod,'p_max_retain_amt_tbl',p_max_retain_amt_tbl);
2406: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
2407: END IF;
2408:
2409: IF (x_result_set_id IS NULL) THEN
2410: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 2454: IF PO_LOG.d_proc THEN

2450: ELSE
2451: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2452: END IF;
2453:
2454: IF PO_LOG.d_proc THEN
2455: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2456: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2457: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2458: END IF;

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

2452: END IF;
2453:
2454: IF PO_LOG.d_proc THEN
2455: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2456: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2457: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2458: END IF;
2459:
2460: EXCEPTION

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

2453:
2454: IF PO_LOG.d_proc THEN
2455: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
2456: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
2457: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
2458: END IF;
2459:
2460: EXCEPTION
2461: WHEN OTHERS THEN

Line 2462: IF PO_LOG.d_exc THEN

2458: END IF;
2459:
2460: EXCEPTION
2461: WHEN OTHERS THEN
2462: IF PO_LOG.d_exc THEN
2463: PO_LOG.exc(d_mod,0,NULL);
2464: END IF;
2465: RAISE;
2466:

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

2459:
2460: EXCEPTION
2461: WHEN OTHERS THEN
2462: IF PO_LOG.d_exc THEN
2463: PO_LOG.exc(d_mod,0,NULL);
2464: END IF;
2465: RAISE;
2466:
2467: END max_retain_amt_ge_retained;