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.OZF_OFFER_MARKET_OPTIONS_PVT dependencies on OZF_UTILITY_PVT

Line 96: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_market_options','offer_market_option_id = ''' || p_mo_rec.offer_market_option_id ||'''') = FND_API.g_false THEN

92: OZF_Volume_Offer_disc_PVT.debug_message('Market optionId is : '|| p_mo_rec.offer_market_option_id);
93: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
94: IF p_mo_rec.offer_market_option_id IS NOT NULL AND p_mo_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
95: OZF_Volume_Offer_disc_PVT.debug_message('Checking qunqieness for moid');
96: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_market_options','offer_market_option_id = ''' || p_mo_rec.offer_market_option_id ||'''') = FND_API.g_false THEN
97: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFF_MO_ID_DUP');
98: x_return_status := FND_API.g_ret_sts_error;
99: END IF;
100: END IF;

Line 97: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFF_MO_ID_DUP');

93: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
94: IF p_mo_rec.offer_market_option_id IS NOT NULL AND p_mo_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
95: OZF_Volume_Offer_disc_PVT.debug_message('Checking qunqieness for moid');
96: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_market_options','offer_market_option_id = ''' || p_mo_rec.offer_market_option_id ||'''') = FND_API.g_false THEN
97: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFF_MO_ID_DUP');
98: x_return_status := FND_API.g_ret_sts_error;
99: END IF;
100: END IF;
101: END IF;

Line 116: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_MO_DUP');

112: FETCH c_mo_uk INTO l_dummy;
113: IF ( c_mo_uk%NOTFOUND) THEN
114: NULL;
115: ELSE
116: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_MO_DUP');
117: x_return_status := FND_API.g_ret_sts_error;
118: END IF;
119: END IF;
120:

Line 125: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_MO_DUP');

121: END IF;
122: */
123:
124: IF l_dummy = 1 THEN
125: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFR_MO_DUP');
126: x_return_status := FND_API.g_ret_sts_error;
127: END IF;
128:
129: END check_mo_uk_items;

Line 146: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ID' );

142: x_return_status := FND_API.g_ret_sts_success;
143:
144: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
145: IF p_mo_rec.offer_id = FND_API.G_MISS_NUM OR p_mo_rec.offer_id IS NULL THEN
146: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ID' );
147: x_return_status := FND_API.g_ret_sts_error;
148: END IF;
149:
150: /*IF p_mo_rec.group_number = FND_API.G_MISS_NUM OR p_mo_rec.group_number IS NULL THEN

Line 151: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GROUP_NUMBER' );

147: x_return_status := FND_API.g_ret_sts_error;
148: END IF;
149:
150: /*IF p_mo_rec.group_number = FND_API.G_MISS_NUM OR p_mo_rec.group_number IS NULL THEN
151: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GROUP_NUMBER' );
152: x_return_status := FND_API.g_ret_sts_error;
153: END IF;
154: */
155: IF p_mo_rec.retroactive_flag = FND_API.G_MISS_CHAR OR p_mo_rec.retroactive_flag IS NULL THEN

Line 156: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'RETROACTIVE_FLAG' );

152: x_return_status := FND_API.g_ret_sts_error;
153: END IF;
154: */
155: IF p_mo_rec.retroactive_flag = FND_API.G_MISS_CHAR OR p_mo_rec.retroactive_flag IS NULL THEN
156: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'RETROACTIVE_FLAG' );
157: x_return_status := FND_API.g_ret_sts_error;
158: END IF;
159:
160: IF p_mo_rec.combine_schedule_flag = FND_API.G_MISS_CHAR OR p_mo_rec.combine_schedule_flag IS NULL THEN

Line 161: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','COMBINE_SCHEDULE_FLAG');

157: x_return_status := FND_API.g_ret_sts_error;
158: END IF;
159:
160: IF p_mo_rec.combine_schedule_flag = FND_API.G_MISS_CHAR OR p_mo_rec.combine_schedule_flag IS NULL THEN
161: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','COMBINE_SCHEDULE_FLAG');
162: x_return_status := FND_API.g_ret_sts_error;
163: END IF;
164: IF p_mo_rec.volume_tracking_level_code = FND_API.G_MISS_CHAR OR p_mo_rec.volume_tracking_level_code IS NULL THEN
165: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','VOLUME_TRACKING_LEVEL_CODE');

Line 165: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','VOLUME_TRACKING_LEVEL_CODE');

161: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','COMBINE_SCHEDULE_FLAG');
162: x_return_status := FND_API.g_ret_sts_error;
163: END IF;
164: IF p_mo_rec.volume_tracking_level_code = FND_API.G_MISS_CHAR OR p_mo_rec.volume_tracking_level_code IS NULL THEN
165: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','VOLUME_TRACKING_LEVEL_CODE');
166: x_return_status := FND_API.g_ret_sts_error;
167: END IF;
168: IF p_mo_rec.accrue_to_code = FND_API.G_MISS_CHAR OR p_mo_rec.accrue_to_code IS NULL THEN
169: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','ACCRUE_TO_CODE');

Line 169: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','ACCRUE_TO_CODE');

165: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','VOLUME_TRACKING_LEVEL_CODE');
166: x_return_status := FND_API.g_ret_sts_error;
167: END IF;
168: IF p_mo_rec.accrue_to_code = FND_API.G_MISS_CHAR OR p_mo_rec.accrue_to_code IS NULL THEN
169: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','ACCRUE_TO_CODE');
170: x_return_status := FND_API.g_ret_sts_error;
171: END IF;
172: IF p_mo_rec.precedence = FND_API.G_MISS_NUM OR p_mo_rec.precedence IS NULL THEN
173: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','PRECEDENCE');

Line 173: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','PRECEDENCE');

169: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','ACCRUE_TO_CODE');
170: x_return_status := FND_API.g_ret_sts_error;
171: END IF;
172: IF p_mo_rec.precedence = FND_API.G_MISS_NUM OR p_mo_rec.precedence IS NULL THEN
173: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','PRECEDENCE');
174: END IF;
175:
176:
177: ELSE

Line 179: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_market_option_id' );

175:
176:
177: ELSE
178: IF p_mo_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
179: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_market_option_id' );
180: x_return_status := FND_API.g_ret_sts_error;
181: END IF;
182:
183: IF p_mo_rec.offer_id = FND_API.G_MISS_NUM THEN

Line 184: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ID' );

180: x_return_status := FND_API.g_ret_sts_error;
181: END IF;
182:
183: IF p_mo_rec.offer_id = FND_API.G_MISS_NUM THEN
184: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ID' );
185: x_return_status := FND_API.g_ret_sts_error;
186: END IF;
187:
188: /* IF p_mo_rec.group_number = FND_API.G_MISS_NUM THEN

Line 189: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GROUP_NUMBER' );

185: x_return_status := FND_API.g_ret_sts_error;
186: END IF;
187:
188: /* IF p_mo_rec.group_number = FND_API.G_MISS_NUM THEN
189: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GROUP_NUMBER' );
190: x_return_status := FND_API.g_ret_sts_error;
191: END IF;
192: */
193: IF p_mo_rec.retroactive_flag = FND_API.G_MISS_CHAR THEN

Line 194: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'RETROACTIVE_FLAG' );

190: x_return_status := FND_API.g_ret_sts_error;
191: END IF;
192: */
193: IF p_mo_rec.retroactive_flag = FND_API.G_MISS_CHAR THEN
194: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'RETROACTIVE_FLAG' );
195: x_return_status := FND_API.g_ret_sts_error;
196: END IF;
197:
198: IF p_mo_rec.combine_schedule_flag = FND_API.G_MISS_CHAR THEN

Line 199: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','COMBINE_SCHEDULE_FLAG');

195: x_return_status := FND_API.g_ret_sts_error;
196: END IF;
197:
198: IF p_mo_rec.combine_schedule_flag = FND_API.G_MISS_CHAR THEN
199: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','COMBINE_SCHEDULE_FLAG');
200: x_return_status := FND_API.g_ret_sts_error;
201: END IF;
202: IF p_mo_rec.volume_tracking_level_code = FND_API.G_MISS_CHAR THEN
203: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','VOLUME_TRACKING_LEVEL_CODE');

Line 203: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','VOLUME_TRACKING_LEVEL_CODE');

199: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','COMBINE_SCHEDULE_FLAG');
200: x_return_status := FND_API.g_ret_sts_error;
201: END IF;
202: IF p_mo_rec.volume_tracking_level_code = FND_API.G_MISS_CHAR THEN
203: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','VOLUME_TRACKING_LEVEL_CODE');
204: x_return_status := FND_API.g_ret_sts_error;
205: END IF;
206: IF p_mo_rec.accrue_to_code = FND_API.G_MISS_CHAR THEN
207: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','ACCRUE_TO_CODE');

Line 207: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','ACCRUE_TO_CODE');

203: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','VOLUME_TRACKING_LEVEL_CODE');
204: x_return_status := FND_API.g_ret_sts_error;
205: END IF;
206: IF p_mo_rec.accrue_to_code = FND_API.G_MISS_CHAR THEN
207: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','ACCRUE_TO_CODE');
208: x_return_status := FND_API.g_ret_sts_error;
209: END IF;
210: IF p_mo_rec.precedence = FND_API.G_MISS_NUM THEN
211: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','PRECEDENCE');

Line 211: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','PRECEDENCE');

207: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','ACCRUE_TO_CODE');
208: x_return_status := FND_API.g_ret_sts_error;
209: END IF;
210: IF p_mo_rec.precedence = FND_API.G_MISS_NUM THEN
211: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','PRECEDENCE');
212: x_return_status := FND_API.g_ret_sts_error;
213: END IF;
214: IF p_mo_rec.object_version_number = FND_API.G_MISS_NUM OR p_mo_rec.object_version_number IS NULL THEN
215: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');

Line 215: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');

211: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','PRECEDENCE');
212: x_return_status := FND_API.g_ret_sts_error;
213: END IF;
214: IF p_mo_rec.object_version_number = FND_API.G_MISS_NUM OR p_mo_rec.object_version_number IS NULL THEN
215: OZF_UTILITY_PVT.Error_message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');
216: x_return_status := FND_API.g_ret_sts_error;
217: END IF;
218:
219: END IF;

Line 237: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_mo_rec.offer_id)) = FND_API.g_false THEN

233: BEGIN
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235: IF p_mo_rec.offer_id IS NOT NULL AND p_mo_rec.offer_id <> FND_API.G_MISS_NUM
236: THEN
237: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_mo_rec.offer_id)) = FND_API.g_false THEN
238: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ID' );
239: x_return_status := FND_API.g_ret_sts_error;
240: END IF;
241: END IF;

Line 238: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ID' );

234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235: IF p_mo_rec.offer_id IS NOT NULL AND p_mo_rec.offer_id <> FND_API.G_MISS_NUM
236: THEN
237: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_mo_rec.offer_id)) = FND_API.g_false THEN
238: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ID' );
239: x_return_status := FND_API.g_ret_sts_error;
240: END IF;
241: END IF;
242:

Line 246: IF ozf_utility_pvt.check_fk_exists('QP_LIST_HEADERS_ALL_B','list_header_id',to_char(p_mo_rec.qp_list_header_id)) = FND_API.g_false THEN

242:
243: -- Fix for bug # 14724414
244: IF p_mo_rec.qp_list_header_id IS NOT NULL AND p_mo_rec.qp_list_header_id <> FND_API.G_MISS_NUM
245: THEN
246: IF ozf_utility_pvt.check_fk_exists('QP_LIST_HEADERS_ALL_B','list_header_id',to_char(p_mo_rec.qp_list_header_id)) = FND_API.g_false THEN
247: OZF_Utility_PVT.Error_Message('OZF_INVALID_QP_LIST_HEADER' );
248: x_return_status := FND_API.g_ret_sts_error;
249: END IF;
250: END IF;

Line 247: OZF_Utility_PVT.Error_Message('OZF_INVALID_QP_LIST_HEADER' );

243: -- Fix for bug # 14724414
244: IF p_mo_rec.qp_list_header_id IS NOT NULL AND p_mo_rec.qp_list_header_id <> FND_API.G_MISS_NUM
245: THEN
246: IF ozf_utility_pvt.check_fk_exists('QP_LIST_HEADERS_ALL_B','list_header_id',to_char(p_mo_rec.qp_list_header_id)) = FND_API.g_false THEN
247: OZF_Utility_PVT.Error_Message('OZF_INVALID_QP_LIST_HEADER' );
248: x_return_status := FND_API.g_ret_sts_error;
249: END IF;
250: END IF;
251:

Line 253: IF ozf_utility_pvt.check_fk_exists('QP_CUSTOMERS_V','CUSTOMER_ID',to_char(p_mo_rec.beneficiary_party_id)) = FND_API.g_false THEN

249: END IF;
250: END IF;
251:
252: IF p_mo_rec.beneficiary_party_id IS NOT NULL AND p_mo_rec.beneficiary_party_id <> FND_API.G_MISS_NUM THEN
253: IF ozf_utility_pvt.check_fk_exists('QP_CUSTOMERS_V','CUSTOMER_ID',to_char(p_mo_rec.beneficiary_party_id)) = FND_API.g_false THEN
254: OZF_Utility_PVT.Error_Message('OZF_INVALID_BENEFICIARY' );
255: x_return_status := FND_API.g_ret_sts_error;
256: END IF;
257: END IF;

Line 254: OZF_Utility_PVT.Error_Message('OZF_INVALID_BENEFICIARY' );

250: END IF;
251:
252: IF p_mo_rec.beneficiary_party_id IS NOT NULL AND p_mo_rec.beneficiary_party_id <> FND_API.G_MISS_NUM THEN
253: IF ozf_utility_pvt.check_fk_exists('QP_CUSTOMERS_V','CUSTOMER_ID',to_char(p_mo_rec.beneficiary_party_id)) = FND_API.g_false THEN
254: OZF_Utility_PVT.Error_Message('OZF_INVALID_BENEFICIARY' );
255: x_return_status := FND_API.g_ret_sts_error;
256: END IF;
257: END IF;
258:

Line 265: OZF_Utility_PVT.Error_Message('OZF_OFFR_INV_LH_GRP' );

261: THEN
262: OPEN c_mo_grp(p_mo_rec.qp_list_header_id,p_mo_rec.group_number);
263: FETCH c_mo_grp INTO l_dummy;
264: IF (c_mo_grp%NOTFOUND) THEN
265: OZF_Utility_PVT.Error_Message('OZF_OFFR_INV_LH_GRP' );
266: x_return_status := FND_API.g_ret_sts_error;
267: END IF;
268: END IF;
269: */

Line 281: IF OZF_UTILITY_PVT.check_lookup_exists('OZF_LOOKUPS', 'OZF_VO_TRACKING_LEVEL', p_mo_rec.volume_tracking_level_code) = FND_API.g_false THEN

277: IS
278: BEGIN
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280: IF p_mo_rec.volume_tracking_level_code <> FND_API.G_MISS_CHAR AND p_mo_rec.volume_tracking_level_code IS NOT NULL THEN
281: IF OZF_UTILITY_PVT.check_lookup_exists('OZF_LOOKUPS', 'OZF_VO_TRACKING_LEVEL', p_mo_rec.volume_tracking_level_code) = FND_API.g_false THEN
282: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_VOL_TRK' );
283: x_return_status := FND_API.g_ret_sts_error;
284: END IF;
285: END IF;

Line 282: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_VOL_TRK' );

278: BEGIN
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280: IF p_mo_rec.volume_tracking_level_code <> FND_API.G_MISS_CHAR AND p_mo_rec.volume_tracking_level_code IS NOT NULL THEN
281: IF OZF_UTILITY_PVT.check_lookup_exists('OZF_LOOKUPS', 'OZF_VO_TRACKING_LEVEL', p_mo_rec.volume_tracking_level_code) = FND_API.g_false THEN
282: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_VOL_TRK' );
283: x_return_status := FND_API.g_ret_sts_error;
284: END IF;
285: END IF;
286:

Line 288: IF OZF_UTILITY_PVT.check_lookup_exists('OZF_LOOKUPS', 'OZF_VO_ACCRUE_TO', p_mo_rec.accrue_to_code) = FND_API.g_false THEN

284: END IF;
285: END IF;
286:
287: IF p_mo_rec.accrue_to_code <> FND_API.G_MISS_CHAR AND p_mo_rec.accrue_to_code IS NOT NULL THEN
288: IF OZF_UTILITY_PVT.check_lookup_exists('OZF_LOOKUPS', 'OZF_VO_ACCRUE_TO', p_mo_rec.accrue_to_code) = FND_API.g_false THEN
289: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_ACCR_TO' );
290: x_return_status := FND_API.g_ret_sts_error;
291: END IF;
292: END IF;

Line 289: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_ACCR_TO' );

285: END IF;
286:
287: IF p_mo_rec.accrue_to_code <> FND_API.G_MISS_CHAR AND p_mo_rec.accrue_to_code IS NOT NULL THEN
288: IF OZF_UTILITY_PVT.check_lookup_exists('OZF_LOOKUPS', 'OZF_VO_ACCRUE_TO', p_mo_rec.accrue_to_code) = FND_API.g_false THEN
289: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_ACCR_TO' );
290: x_return_status := FND_API.g_ret_sts_error;
291: END IF;
292: END IF;
293: END check_mo_lkup_items;

Line 306: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_RETROACT_FLAG' );

302: BEGIN
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304: IF p_mo_rec.retroactive_flag IS NOT NULL AND p_mo_rec.retroactive_flag <> FND_API.G_MISS_CHAR THEN
305: IF upper(p_mo_rec.retroactive_flag) <> 'Y' AND upper(p_mo_rec.retroactive_flag) <> 'N' THEN
306: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_RETROACT_FLAG' );
307: x_return_status := FND_API.g_ret_sts_error;
308: END IF;
309: END IF;
310:

Line 313: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_COMB_TIERS' );

309: END IF;
310:
311: IF p_mo_rec.combine_schedule_flag IS NOT NULL AND p_mo_rec.combine_schedule_flag <> FND_API.G_MISS_CHAR THEN
312: IF upper(p_mo_rec.combine_schedule_flag) <> 'Y' AND upper(p_mo_rec.combine_schedule_flag) <> 'N' THEN
313: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INV_COMB_TIERS' );
314: x_return_status := FND_API.g_ret_sts_error;
315: END IF;
316: END IF;
317:

Line 535: WHEN OZF_Utility_PVT.resource_locked THEN

531: p_data => x_msg_data
532: );
533: EXCEPTION
534:
535: WHEN OZF_Utility_PVT.resource_locked THEN
536: x_return_status := FND_API.g_ret_sts_error;
537: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
538:
539: WHEN FND_API.G_EXC_ERROR THEN

Line 537: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

533: EXCEPTION
534:
535: WHEN OZF_Utility_PVT.resource_locked THEN
536: x_return_status := FND_API.g_ret_sts_error;
537: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540: ROLLBACK TO validate_market_options_pvt;
541: x_return_status := FND_API.G_RET_STS_ERROR;

Line 666: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

662: -- =========================================================================
663:
664: IF FND_GLOBAL.USER_ID IS NULL
665: THEN
666: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
667: RAISE FND_API.G_EXC_ERROR;
668: END IF;
669:
670: l_mo_rec := p_mo_rec;

Line 874: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'

870:
871: OPEN c_get_mo( l_tar_mo_rec.offer_market_option_id,l_tar_mo_rec.object_version_number);
872: FETCH c_get_mo INTO l_ref_mo_rec ;
873: If ( c_get_mo%NOTFOUND) THEN
874: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
875: , p_token_name => 'INFO'
876: , p_token_value => 'OZF_MARKET_OPTIONS') ;
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;

Line 883: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'

879: CLOSE c_get_mo;
880:
881: If (l_tar_mo_rec.object_version_number is NULL or
882: l_tar_mo_rec.object_version_number = FND_API.G_MISS_NUM ) Then
883: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
884: , p_token_name => 'COLUMN'
885: , p_token_value => 'Last_Update_Date') ;
886: RAISE FND_API.G_EXC_ERROR;
887: End if;

Line 890: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'

886: RAISE FND_API.G_EXC_ERROR;
887: End if;
888: -- Check Whether record has been changed by someone else
889: If (l_tar_mo_rec.object_version_number <> l_ref_mo_rec.object_version_number) Then
890: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
891: , p_token_name => 'INFO'
892: , p_token_value => 'Ozf_Market_Options') ;
893: RAISE FND_API.G_EXC_ERROR;
894: End if;

Line 950: WHEN OZF_Utility_PVT.resource_locked THEN

946:
947: -- exception
948: EXCEPTION
949:
950: WHEN OZF_Utility_PVT.resource_locked THEN
951: x_return_status := FND_API.g_ret_sts_error;
952: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
953:
954: WHEN FND_API.G_EXC_ERROR THEN

Line 952: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

948: EXCEPTION
949:
950: WHEN OZF_Utility_PVT.resource_locked THEN
951: x_return_status := FND_API.g_ret_sts_error;
952: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
953:
954: WHEN FND_API.G_EXC_ERROR THEN
955: ROLLBACK TO Update_market_options_pvt;
956: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1087: WHEN OZF_Utility_PVT.resource_locked THEN

1083: p_data => x_msg_data
1084: );
1085: EXCEPTION
1086:
1087: WHEN OZF_Utility_PVT.resource_locked THEN
1088: x_return_status := FND_API.g_ret_sts_error;
1089: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1090:
1091: WHEN FND_API.G_EXC_ERROR THEN

Line 1089: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1085: EXCEPTION
1086:
1087: WHEN OZF_Utility_PVT.resource_locked THEN
1088: x_return_status := FND_API.g_ret_sts_error;
1089: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1090:
1091: WHEN FND_API.G_EXC_ERROR THEN
1092: ROLLBACK TO Delete_market_options_PVT;
1093: x_return_status := FND_API.G_RET_STS_ERROR;