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_ADJ_PRODUCTS_PVT dependencies on OZF_UTILITY_PVT

Line 24: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_adjustment_id');

20: BEGIN
21: x_return_status := FND_API.G_RET_STS_SUCCESS;
22: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
23: IF p_adj_prod.offer_adjustment_id IS NULL OR p_adj_prod.offer_adjustment_id = FND_API.G_MISS_NUM THEN
24: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_adjustment_id');
25: x_return_status := FND_API.g_ret_sts_error;
26: return;
27: END IF;
28: /*

Line 30: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_context');

26: return;
27: END IF;
28: /*
29: IF p_adj_prod.product_context IS NULL OR p_adj_prod.product_context = FND_API.G_MISS_CHAR THEN
30: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_context');
31: x_return_status := FND_API.g_ret_sts_error;
32: return;
33: END IF;
34:

Line 36: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_attribute');

32: return;
33: END IF;
34:
35: IF p_adj_prod.product_attribute IS NULL OR p_adj_prod.product_attribute = FND_API.G_MISS_CHAR THEN
36: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_attribute');
37: x_return_status := FND_API.g_ret_sts_error;
38: return;
39: END IF;
40: IF p_adj_prod.product_attr_value IS NULL OR p_adj_prod.product_attr_value = FND_API.G_MISS_CHAR THEN

Line 41: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_attr_value');

37: x_return_status := FND_API.g_ret_sts_error;
38: return;
39: END IF;
40: IF p_adj_prod.product_attr_value IS NULL OR p_adj_prod.product_attr_value = FND_API.G_MISS_CHAR THEN
41: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_attr_value');
42: x_return_status := FND_API.g_ret_sts_error;
43: return;
44: END IF;*/
45: ELSE

Line 47: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_adjustment_id');

43: return;
44: END IF;*/
45: ELSE
46: IF p_adj_prod.offer_adjustment_id = FND_API.G_MISS_NUM THEN
47: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_adjustment_id');
48: x_return_status := FND_API.g_ret_sts_error;
49: return;
50: END IF;
51: IF p_adj_prod.offer_adjustment_product_id = FND_API.G_MISS_NUM THEN

Line 52: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFFER_ADJUSTMENT_PRODUCT_ID');

48: x_return_status := FND_API.g_ret_sts_error;
49: return;
50: END IF;
51: IF p_adj_prod.offer_adjustment_product_id = FND_API.G_MISS_NUM THEN
52: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFFER_ADJUSTMENT_PRODUCT_ID');
53: x_return_status := FND_API.g_ret_sts_error;
54: return;
55: END IF;
56: IF p_adj_prod.object_version_number = FND_API.G_MISS_NUM THEN

Line 57: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');

53: x_return_status := FND_API.g_ret_sts_error;
54: return;
55: END IF;
56: IF p_adj_prod.object_version_number = FND_API.G_MISS_NUM THEN
57: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');
58: x_return_status := FND_API.g_ret_sts_error;
59: return;
60: END IF;
61: END IF;

Line 119: IF OZF_UTILITY_PVT.CHECK_UNIQUENESS('ozf_offer_adjustment_products','offer_adjustment_product_id = '|| p_adj_prod.offer_adjustment_product_id) = FND_API.G_FALSE THEN

115: BEGIN
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
118: IF p_adj_prod.offer_adjustment_product_id IS NOT NULL AND p_adj_prod.offer_adjustment_product_id <> FND_API.G_MISS_NUM THEN
119: IF OZF_UTILITY_PVT.CHECK_UNIQUENESS('ozf_offer_adjustment_products','offer_adjustment_product_id = '|| p_adj_prod.offer_adjustment_product_id) = FND_API.G_FALSE THEN
120: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_ID_DUP');
121: x_return_status := FND_API.g_ret_sts_error;
122: return;
123: END IF;

Line 120: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_ID_DUP');

116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
118: IF p_adj_prod.offer_adjustment_product_id IS NOT NULL AND p_adj_prod.offer_adjustment_product_id <> FND_API.G_MISS_NUM THEN
119: IF OZF_UTILITY_PVT.CHECK_UNIQUENESS('ozf_offer_adjustment_products','offer_adjustment_product_id = '|| p_adj_prod.offer_adjustment_product_id) = FND_API.G_FALSE THEN
120: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_ID_DUP');
121: x_return_status := FND_API.g_ret_sts_error;
122: return;
123: END IF;
124: END IF;

Line 145: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

141: FETCH c_offerId INTO l_offerId;
142: CLOSE c_offerId;
143:
144: IF (p_adj_prod.product_attr_value IS NOT NULL AND p_adj_prod.product_attr_value <> FND_API.g_miss_char) THEN
145: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
146: 'ozf_offer_discount_products',
147: l_attr || l_attr2 || l_offerId
148: );
149: IF l_valid_flag = FND_API.g_false THEN

Line 150: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_PROD_DUP');

146: 'ozf_offer_discount_products',
147: l_attr || l_attr2 || l_offerId
148: );
149: IF l_valid_flag = FND_API.g_false THEN
150: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_PROD_DUP');
151: x_return_status := FND_API.g_ret_sts_error;
152: return;
153: END IF;
154:

Line 171: IF OZF_UTILITY_PVT.check_fk_exists('ozf_offer_adjustments_b','offer_adjustment_id',to_char(p_adj_prod.offer_adjustment_id)) = FND_API.G_FALSE THEN

167: l_vo_prod_rec OZF_Volume_Offer_disc_PVT.vo_prod_rec_type;
168: BEGIN
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170: IF p_adj_prod.offer_adjustment_id IS NOT NULL AND p_adj_prod.offer_adjustment_id <> FND_API.G_MISS_NUM THEN
171: IF OZF_UTILITY_PVT.check_fk_exists('ozf_offer_adjustments_b','offer_adjustment_id',to_char(p_adj_prod.offer_adjustment_id)) = FND_API.G_FALSE THEN
172: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_ADJ_ID');
173: x_return_status := FND_API.g_ret_sts_error;
174: return;
175: END IF;

Line 172: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_ADJ_ID');

168: BEGIN
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170: IF p_adj_prod.offer_adjustment_id IS NOT NULL AND p_adj_prod.offer_adjustment_id <> FND_API.G_MISS_NUM THEN
171: IF OZF_UTILITY_PVT.check_fk_exists('ozf_offer_adjustments_b','offer_adjustment_id',to_char(p_adj_prod.offer_adjustment_id)) = FND_API.G_FALSE THEN
172: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_ADJ_ID');
173: x_return_status := FND_API.g_ret_sts_error;
174: return;
175: END IF;
176: END IF;

Line 179: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'offer_discount_line_id', to_char(p_adj_prod.offer_discount_line_id)) = FND_API.G_FALSE THEN

175: END IF;
176: END IF;
177: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountLineid is: '||p_adj_prod.offer_discount_line_id);
178: IF p_adj_prod.offer_discount_line_id IS NOT NULL AND p_adj_prod.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
179: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'offer_discount_line_id', to_char(p_adj_prod.offer_discount_line_id)) = FND_API.G_FALSE THEN
180: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_DISC_LINE');
181: x_return_status := FND_API.g_ret_sts_error;
182: return;
183: END IF;

Line 180: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_DISC_LINE');

176: END IF;
177: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountLineid is: '||p_adj_prod.offer_discount_line_id);
178: IF p_adj_prod.offer_discount_line_id IS NOT NULL AND p_adj_prod.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
179: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'offer_discount_line_id', to_char(p_adj_prod.offer_discount_line_id)) = FND_API.G_FALSE THEN
180: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_DISC_LINE');
181: x_return_status := FND_API.g_ret_sts_error;
182: return;
183: END IF;
184: END IF;

Line 187: IF ozf_utility_pvt.CHECK_FK_EXISTS('ozf_offer_discount_products','off_discount_product_id',to_char(p_adj_prod.off_discount_product_id)) = FND_API.G_FALSE THEN

183: END IF;
184: END IF;
185: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountProductId is : '||p_adj_prod.off_discount_product_id);
186: IF p_adj_prod.off_discount_product_id IS NOT NULL AND p_adj_prod.off_discount_product_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.CHECK_FK_EXISTS('ozf_offer_discount_products','off_discount_product_id',to_char(p_adj_prod.off_discount_product_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_INV_PROD_LINE');
189: x_return_status := FND_API.g_ret_sts_error;
190: return;
191: END IF;

Line 188: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_INV_PROD_LINE');

184: END IF;
185: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountProductId is : '||p_adj_prod.off_discount_product_id);
186: IF p_adj_prod.off_discount_product_id IS NOT NULL AND p_adj_prod.off_discount_product_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.CHECK_FK_EXISTS('ozf_offer_discount_products','off_discount_product_id',to_char(p_adj_prod.off_discount_product_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_INV_PROD_LINE');
189: x_return_status := FND_API.g_ret_sts_error;
190: return;
191: END IF;
192: END IF;

Line 241: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_EXCL');

237: BEGIN
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239: IF p_adj_prod.excluder_flag IS NOT NULL AND p_adj_prod.excluder_flag <> fnd_api.g_miss_char THEN
240: IF p_adj_prod.excluder_flag <> 'Y' AND p_adj_prod.excluder_flag <> 'N' THEN
241: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_EXCL');
242: x_return_status := FND_API.g_ret_sts_error;
243: return;
244: END IF;
245: END IF;

Line 248: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_APP_DISC');

244: END IF;
245: END IF;
246: IF p_adj_prod.apply_discount_flag IS NOT NULL AND p_adj_prod.apply_discount_flag <> FND_API.G_MISS_CHAR THEN
247: IF p_adj_prod.apply_discount_flag <> 'Y' and p_adj_prod.apply_discount_flag <> 'N' THEN
248: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_APP_DISC');
249: x_return_status := FND_API.g_ret_sts_error;
250: return;
251:
252: END IF;

Line 258: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_INCL_VOL');

254:
255:
256: IF p_adj_prod.include_volume_flag IS NOT NULL AND p_adj_prod.include_volume_flag <> FND_API.G_MISS_CHAR THEN
257: IF p_adj_prod.include_volume_flag <> 'Y' and p_adj_prod.include_volume_flag <> 'N' THEN
258: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_INCL_VOL');
259: x_return_status := FND_API.g_ret_sts_error;
260: return;
261:
262: END IF;

Line 268: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRODUCT_CONTEXT');

264: -- if new product is added then product_context, product_attribute, product_attr_value, apply_discount_flag , include_volume_flag are required
265: IF p_adj_prod.off_discount_product_id IS NULL OR p_adj_prod.off_discount_product_id = FND_API.G_MISS_NUM THEN -- if this is a new product
266: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
267: IF p_adj_prod.product_context IS NULL OR p_adj_prod.product_context = FND_API.G_MISS_CHAR THEN
268: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRODUCT_CONTEXT');
269: x_return_status := FND_API.g_ret_sts_error;
270: return;
271: END IF;
272: IF p_adj_prod.product_attribute IS NULL OR p_adj_prod.product_attribute = FND_API.G_MISS_CHAR THEN

Line 273: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRODUCT_ATTRIBUTE');

269: x_return_status := FND_API.g_ret_sts_error;
270: return;
271: END IF;
272: IF p_adj_prod.product_attribute IS NULL OR p_adj_prod.product_attribute = FND_API.G_MISS_CHAR THEN
273: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRODUCT_ATTRIBUTE');
274: x_return_status := FND_API.g_ret_sts_error;
275: return;
276: END IF;
277: IF p_adj_prod.product_attr_value IS NULL OR p_adj_prod.product_attr_value = FND_API.G_MISS_CHAR THEN

Line 278: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRODUCT_ATTR_VALUE');

274: x_return_status := FND_API.g_ret_sts_error;
275: return;
276: END IF;
277: IF p_adj_prod.product_attr_value IS NULL OR p_adj_prod.product_attr_value = FND_API.G_MISS_CHAR THEN
278: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRODUCT_ATTR_VALUE');
279: x_return_status := FND_API.g_ret_sts_error;
280: return;
281: END IF;
282: IF p_adj_prod.apply_discount_flag IS NULL OR p_adj_prod.apply_discount_flag = FND_API.G_MISS_CHAR THEN

Line 283: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','APPLY_DISCOUNT_FLAG');

279: x_return_status := FND_API.g_ret_sts_error;
280: return;
281: END IF;
282: IF p_adj_prod.apply_discount_flag IS NULL OR p_adj_prod.apply_discount_flag = FND_API.G_MISS_CHAR THEN
283: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','APPLY_DISCOUNT_FLAG');
284: x_return_status := FND_API.g_ret_sts_error;
285: return;
286: END IF;
287: IF p_adj_prod.include_volume_flag IS NULL OR p_adj_prod.include_volume_flag = FND_API.G_MISS_CHAR THEN

Line 288: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','INCLUDE_VOLUME_FLAG');

284: x_return_status := FND_API.g_ret_sts_error;
285: return;
286: END IF;
287: IF p_adj_prod.include_volume_flag IS NULL OR p_adj_prod.include_volume_flag = FND_API.G_MISS_CHAR THEN
288: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','INCLUDE_VOLUME_FLAG');
289: x_return_status := FND_API.g_ret_sts_error;
290: return;
291: END IF;
292: ELSE

Line 294: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_context');

290: return;
291: END IF;
292: ELSE
293: IF p_adj_prod.product_context = FND_API.G_MISS_CHAR THEN
294: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_context');
295: x_return_status := FND_API.g_ret_sts_error;
296: return;
297: END IF;
298: IF p_adj_prod.product_attribute = FND_API.G_MISS_CHAR THEN

Line 299: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_attribute');

295: x_return_status := FND_API.g_ret_sts_error;
296: return;
297: END IF;
298: IF p_adj_prod.product_attribute = FND_API.G_MISS_CHAR THEN
299: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_attribute');
300: x_return_status := FND_API.g_ret_sts_error;
301: return;
302: END IF;
303: IF p_adj_prod.product_attr_value = FND_API.G_MISS_CHAR THEN

Line 304: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_attr_value');

300: x_return_status := FND_API.g_ret_sts_error;
301: return;
302: END IF;
303: IF p_adj_prod.product_attr_value = FND_API.G_MISS_CHAR THEN
304: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','product_attr_value');
305: x_return_status := FND_API.g_ret_sts_error;
306: return;
307: END IF;
308: IF p_adj_prod.apply_discount_flag = FND_API.G_MISS_CHAR THEN

Line 309: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','apply_discount_flag');

305: x_return_status := FND_API.g_ret_sts_error;
306: return;
307: END IF;
308: IF p_adj_prod.apply_discount_flag = FND_API.G_MISS_CHAR THEN
309: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','apply_discount_flag');
310: x_return_status := FND_API.g_ret_sts_error;
311: return;
312: END IF;
313: IF p_adj_prod.include_volume_flag = FND_API.G_MISS_CHAR THEN

Line 314: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','include_volume_flag');

310: x_return_status := FND_API.g_ret_sts_error;
311: return;
312: END IF;
313: IF p_adj_prod.include_volume_flag = FND_API.G_MISS_CHAR THEN
314: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','include_volume_flag');
315: x_return_status := FND_API.g_ret_sts_error;
316: return;
317: END IF;
318: END IF;

Line 356: OZF_Utility_PVT.Error_Message('OZF_ADJ_PROD_INV_DISC_PROD');

352: OPEN c(P_ADJ_prod.offer_discount_line_id, p_adj_prod.off_discount_product_id);
353: FETCH c INTO l_dummy;
354: IF (C%NOTFOUND) THEN
355: CLOSE C;
356: OZF_Utility_PVT.Error_Message('OZF_ADJ_PROD_INV_DISC_PROD');
357: x_return_status := FND_API.g_ret_sts_error;
358: return;
359: END IF;
360: END IF;

Line 363: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES'

359: END IF;
360: END IF;
361: -- a user can associate a product only to a pbh line
362: IF p_adj_prod.offer_discount_line_id IS NOT NULL AND p_adj_prod.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
363: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES'
364: ,'OFFER_DISCOUNT_LINE_ID'
365: , to_char(p_adj_prod.offer_discount_line_id)
366: , OZF_UTILITY_PVT.g_number
367: , ' TIER_TYPE = ''PBH'''

Line 366: , OZF_UTILITY_PVT.g_number

362: IF p_adj_prod.offer_discount_line_id IS NOT NULL AND p_adj_prod.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
363: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES'
364: ,'OFFER_DISCOUNT_LINE_ID'
365: , to_char(p_adj_prod.offer_discount_line_id)
366: , OZF_UTILITY_PVT.g_number
367: , ' TIER_TYPE = ''PBH'''
368: ) = FND_API.G_FALSE THEN
369: OZF_Utility_PVT.Error_Message('OZF_INV_DISC_LINE_TYPE');
370: x_return_status := FND_API.g_ret_sts_error;

Line 369: OZF_Utility_PVT.Error_Message('OZF_INV_DISC_LINE_TYPE');

365: , to_char(p_adj_prod.offer_discount_line_id)
366: , OZF_UTILITY_PVT.g_number
367: , ' TIER_TYPE = ''PBH'''
368: ) = FND_API.G_FALSE THEN
369: OZF_Utility_PVT.Error_Message('OZF_INV_DISC_LINE_TYPE');
370: x_return_status := FND_API.g_ret_sts_error;
371: return;
372: END IF;
373: END IF;

Line 402: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_ADJ_BACKDATE_NO_PROD');

398: OZF_Offer_Adj_Line_PVT.debug_message('Not backdated');
399: null;
400: ELSE
401: OZF_Offer_Adj_Line_PVT.debug_message('backdated');
402: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_ADJ_BACKDATE_NO_PROD');
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: return;
405: END IF;
406: END check_adj_prod_entity;

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

582:
583:
584: IF FND_GLOBAL.USER_ID IS NULL
585: THEN
586: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;
589:
590: l_adj_prod := p_adj_prod;

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

742: OZF_Offer_Adj_Line_PVT.debug_message('Private API: '|| l_api_name || ' Start');
743: OPEN c_get_adj_prod(l_tar_rec.offer_adjustment_product_id , l_tar_rec.object_version_number);
744: FETCH c_get_adj_prod INTO l_ref_rec;
745: IF (c_get_adj_prod%NOTFOUND) THEN
746: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
747: , p_token_name => 'INFO'
748: , p_token_value => 'OZF_OFFR_ADJ_PRODUCTS') ;
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;

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

750: END IF;
751: CLOSE c_get_adj_prod;
752:
753: IF l_tar_rec.object_version_number IS NULL OR l_tar_rec.object_version_number = FND_API.G_MISS_NUM THEN
754: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
755: , p_token_name => 'COLUMN'
756: , p_token_value => 'object_version_number') ;
757: RAISE FND_API.G_EXC_ERROR;
758: END IF;

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

757: RAISE FND_API.G_EXC_ERROR;
758: END IF;
759:
760: IF l_tar_rec.object_version_number <> l_ref_rec.object_version_number THEN
761: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
762: , p_token_name => 'INFO'
763: , p_token_value => 'Ozf_Market_Options') ;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;