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_FUND_UTILIZED_PUB dependencies on FND_MSG_PUB

Line 5: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

1: PACKAGE BODY OZF_FUND_UTILIZED_PUB AS
2: /* $Header: OZFPFUTB.pls 120.6 2008/03/18 05:19:54 psomyaju ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'OZF_FUND_UTILIZED_PUB';
5: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
6:
7: ---------------------------------------------------------------------
8: -- PROCEDURE
9: -- Validate_Items

Line 173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

169: FETCH c_fund_exists INTO l_fund_exists;
170: CLOSE c_fund_exists;
171:
172: IF l_fund_exists IS NULL THEN
173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
174: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_ID');
175: fnd_msg_pub.add;
176: END IF;
177: x_return_status := fnd_api.g_ret_sts_error;

Line 175: fnd_msg_pub.add;

171:
172: IF l_fund_exists IS NULL THEN
173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
174: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_ID');
175: fnd_msg_pub.add;
176: END IF;
177: x_return_status := fnd_api.g_ret_sts_error;
178: RETURN;
179: END IF;

Line 189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

185:
186: IF l_fund_id IS NOT NULL THEN
187: p_adj_rec.fund_id := l_fund_id;
188: ELSE
189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
190: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_NUM');
191: fnd_msg_pub.add;
192: END IF;
193: x_return_status := fnd_api.g_ret_sts_error;

Line 191: fnd_msg_pub.add;

187: p_adj_rec.fund_id := l_fund_id;
188: ELSE
189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
190: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_NUM');
191: fnd_msg_pub.add;
192: END IF;
193: x_return_status := fnd_api.g_ret_sts_error;
194: RETURN;
195: END IF;

Line 199: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

195: END IF;
196: END IF;
197:
198: IF p_adj_rec.adjustment_type = fnd_api.g_miss_char OR p_adj_rec.adjustment_type IS NULL THEN
199: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
200: fnd_message.set_name('OZF', 'OZF_FUND_NO_ADJ_TYPE');
201: fnd_msg_pub.add;
202: END IF;
203: x_return_status := fnd_api.g_ret_sts_error;

Line 201: fnd_msg_pub.add;

197:
198: IF p_adj_rec.adjustment_type = fnd_api.g_miss_char OR p_adj_rec.adjustment_type IS NULL THEN
199: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
200: fnd_message.set_name('OZF', 'OZF_FUND_NO_ADJ_TYPE');
201: fnd_msg_pub.add;
202: END IF;
203: x_return_status := fnd_api.g_ret_sts_error;
204: RETURN;
205: END IF;

Line 209: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

205: END IF;
206:
207: IF p_adj_rec.adjustment_type NOT IN ('DECREASE_COMM_EARNED', 'DECREASE_COMMITTED', 'DECREASE_EARNED',
208: 'STANDARD', 'DECREASE_PAID', 'INCREASE_PAID') THEN
209: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
210: fnd_message.set_name('OZF', 'OZF_INVALID_ADJ_TYPE');
211: fnd_msg_pub.add;
212: END IF;
213: x_return_status := fnd_api.g_ret_sts_error;

Line 211: fnd_msg_pub.add;

207: IF p_adj_rec.adjustment_type NOT IN ('DECREASE_COMM_EARNED', 'DECREASE_COMMITTED', 'DECREASE_EARNED',
208: 'STANDARD', 'DECREASE_PAID', 'INCREASE_PAID') THEN
209: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
210: fnd_message.set_name('OZF', 'OZF_INVALID_ADJ_TYPE');
211: fnd_msg_pub.add;
212: END IF;
213: x_return_status := fnd_api.g_ret_sts_error;
214: RETURN;
215: END IF;

Line 224: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

220: FETCH c_adj_type_id INTO p_adj_rec.adjustment_type_id;
221: CLOSE c_adj_type_id;
222:
223: IF p_adj_rec.amount = fnd_api.g_miss_num OR p_adj_rec.amount IS NULL THEN
224: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
225: fnd_message.set_name('OZF', 'OZF_FUND_NO_ADJ_AMT');
226: fnd_msg_pub.add;
227: END IF;
228: x_return_status := fnd_api.g_ret_sts_error;

Line 226: fnd_msg_pub.add;

222:
223: IF p_adj_rec.amount = fnd_api.g_miss_num OR p_adj_rec.amount IS NULL THEN
224: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
225: fnd_message.set_name('OZF', 'OZF_FUND_NO_ADJ_AMT');
226: fnd_msg_pub.add;
227: END IF;
228: x_return_status := fnd_api.g_ret_sts_error;
229: RETURN;
230: END IF;

Line 239: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

235: CLOSE c_curr_code;
236: END IF;
237:
238: IF p_adj_rec.activity_type NOT IN ('CAMP', 'DELV', 'EVEH', 'OFFR') THEN
239: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
240: fnd_message.set_name('OZF', 'OZF_INVALID_ACTIVITY_TYPE');
241: fnd_msg_pub.add;
242: END IF;
243: x_return_status := fnd_api.g_ret_sts_error;

Line 241: fnd_msg_pub.add;

237:
238: IF p_adj_rec.activity_type NOT IN ('CAMP', 'DELV', 'EVEH', 'OFFR') THEN
239: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
240: fnd_message.set_name('OZF', 'OZF_INVALID_ACTIVITY_TYPE');
241: fnd_msg_pub.add;
242: END IF;
243: x_return_status := fnd_api.g_ret_sts_error;
244: RETURN;
245: END IF;

Line 266: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

262: CLOSE c_valid_offer;
263: END IF;
264:
265: IF l_activity_id IS NULL THEN
266: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
267: fnd_message.set_name('OZF', 'OZF_INVALID_ACTIVITY_ID');
268: fnd_msg_pub.add;
269: END IF;
270: x_return_status := fnd_api.g_ret_sts_error;

Line 268: fnd_msg_pub.add;

264:
265: IF l_activity_id IS NULL THEN
266: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
267: fnd_message.set_name('OZF', 'OZF_INVALID_ACTIVITY_ID');
268: fnd_msg_pub.add;
269: END IF;
270: x_return_status := fnd_api.g_ret_sts_error;
271: RETURN;
272: END IF;

Line 283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

279: FETCH c_valid_csch INTO l_valid_csch;
280: CLOSE c_valid_csch;
281:
282: IF l_valid_csch IS NULL THEN
283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
284: fnd_message.set_name('OZF', 'OZF_INVALID_CSCH_ID');
285: fnd_msg_pub.add;
286: END IF;
287: x_return_status := fnd_api.g_ret_sts_error;

Line 285: fnd_msg_pub.add;

281:
282: IF l_valid_csch IS NULL THEN
283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
284: fnd_message.set_name('OZF', 'OZF_INVALID_CSCH_ID');
285: fnd_msg_pub.add;
286: END IF;
287: x_return_status := fnd_api.g_ret_sts_error;
288: RETURN;
289: END IF;

Line 299: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

295: FETCH c_valid_cust_type INTO l_cust_type;
296: CLOSE c_valid_cust_type;
297:
298: IF l_cust_type IS NULL THEN
299: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
300: fnd_message.set_name('OZF', 'OZF_INVALID_CUST_TYPE');
301: fnd_msg_pub.add;
302: END IF;
303: x_return_status := fnd_api.g_ret_sts_error;

Line 301: fnd_msg_pub.add;

297:
298: IF l_cust_type IS NULL THEN
299: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
300: fnd_message.set_name('OZF', 'OZF_INVALID_CUST_TYPE');
301: fnd_msg_pub.add;
302: END IF;
303: x_return_status := fnd_api.g_ret_sts_error;
304: RETURN;
305: END IF;

Line 338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

334: END IF;
335:
336: IF p_adj_rec.cust_account_id = fnd_api.g_miss_num OR p_adj_rec.cust_account_id IS NULL THEN
337:
338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
339: fnd_message.set_name('OZF', 'OZF_INVALID_CUST_ID');
340: fnd_msg_pub.add;
341: END IF;
342: x_return_status := fnd_api.g_ret_sts_error;

Line 340: fnd_msg_pub.add;

336: IF p_adj_rec.cust_account_id = fnd_api.g_miss_num OR p_adj_rec.cust_account_id IS NULL THEN
337:
338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
339: fnd_message.set_name('OZF', 'OZF_INVALID_CUST_ID');
340: fnd_msg_pub.add;
341: END IF;
342: x_return_status := fnd_api.g_ret_sts_error;
343: RETURN;
344: END IF;

Line 351: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

347:
348: IF p_adj_rec.document_type <> fnd_api.g_miss_char AND p_adj_rec.document_type IS NOT NULL THEN
349: IF p_adj_rec.document_type NOT IN ('INVOICE', 'ORDER', 'PCHO', 'TP_ORDER') THEN
350:
351: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
352: fnd_message.set_name('OZF', 'OZF_INVALID_DOCUMENT_TYPE');
353: fnd_msg_pub.add;
354: END IF;
355: x_return_status := fnd_api.g_ret_sts_error;

Line 353: fnd_msg_pub.add;

349: IF p_adj_rec.document_type NOT IN ('INVOICE', 'ORDER', 'PCHO', 'TP_ORDER') THEN
350:
351: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
352: fnd_message.set_name('OZF', 'OZF_INVALID_DOCUMENT_TYPE');
353: fnd_msg_pub.add;
354: END IF;
355: x_return_status := fnd_api.g_ret_sts_error;
356: RETURN;
357: END IF;

Line 361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

357: END IF;
358:
359: IF p_adj_rec.document_number = fnd_api.g_miss_num OR p_adj_rec.document_number IS NULL THEN
360:
361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
362: fnd_message.set_name('OZF', 'OZF_NO_DOCUMENT_NUM');
363: fnd_msg_pub.add;
364: END IF;
365: x_return_status := fnd_api.g_ret_sts_error;

Line 363: fnd_msg_pub.add;

359: IF p_adj_rec.document_number = fnd_api.g_miss_num OR p_adj_rec.document_number IS NULL THEN
360:
361: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
362: fnd_message.set_name('OZF', 'OZF_NO_DOCUMENT_NUM');
363: fnd_msg_pub.add;
364: END IF;
365: x_return_status := fnd_api.g_ret_sts_error;
366: RETURN;
367: END IF;

Line 378: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

374: FETCH c_valid_scantype_id INTO l_valid_scantype_id;
375: CLOSE c_valid_scantype_id;
376:
377: IF l_valid_scantype_id IS NULL THEN
378: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
379: fnd_message.set_name('OZF', 'OZF_INVALID_SCANTYPE_ID');
380: fnd_msg_pub.add;
381: END IF;
382: x_return_status := fnd_api.g_ret_sts_error;

Line 380: fnd_msg_pub.add;

376:
377: IF l_valid_scantype_id IS NULL THEN
378: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
379: fnd_message.set_name('OZF', 'OZF_INVALID_SCANTYPE_ID');
380: fnd_msg_pub.add;
381: END IF;
382: x_return_status := fnd_api.g_ret_sts_error;
383: RETURN;
384: END IF;

Line 391: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

387: IF p_adj_rec.activity_type = 'OFFR' THEN
388: IF p_adj_rec.product_level_type <> fnd_api.g_miss_char AND p_adj_rec.product_level_type IS NOT NULL THEN
389:
390: IF p_adj_rec.product_level_type NOT IN ('FAMILY', 'PRODUCT') THEN
391: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
392: fnd_message.set_name('OZF', 'OZF_INVALID_PROD_LEVEL');
393: fnd_msg_pub.add;
394: END IF;
395: x_return_status := fnd_api.g_ret_sts_error;

Line 393: fnd_msg_pub.add;

389:
390: IF p_adj_rec.product_level_type NOT IN ('FAMILY', 'PRODUCT') THEN
391: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
392: fnd_message.set_name('OZF', 'OZF_INVALID_PROD_LEVEL');
393: fnd_msg_pub.add;
394: END IF;
395: x_return_status := fnd_api.g_ret_sts_error;
396: RETURN;
397: END IF;

Line 406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

402: ozf_utility_pvt.debug_message('p_adj_rec.org_id: ' || p_adj_rec.org_id);
403: END IF;
404:
405: IF p_adj_rec.product_name = fnd_api.g_miss_char OR p_adj_rec.product_name IS NULL THEN
406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
407: fnd_message.set_name('OZF', 'OZF_NO_PROD_NAME');
408: fnd_msg_pub.add;
409: END IF;
410: x_return_status := fnd_api.g_ret_sts_error;

Line 408: fnd_msg_pub.add;

404:
405: IF p_adj_rec.product_name = fnd_api.g_miss_char OR p_adj_rec.product_name IS NULL THEN
406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
407: fnd_message.set_name('OZF', 'OZF_NO_PROD_NAME');
408: fnd_msg_pub.add;
409: END IF;
410: x_return_status := fnd_api.g_ret_sts_error;
411: RETURN;
412: ELSE

Line 424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

420: CLOSE c_valid_product;
421: END IF;
422:
423: IF p_adj_rec.product_id IS NULL THEN
424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
425: fnd_message.set_name('OZF', 'OZF_INVALID_PROD');
426: fnd_msg_pub.add;
427: END IF;
428: x_return_status := fnd_api.g_ret_sts_error;

Line 426: fnd_msg_pub.add;

422:
423: IF p_adj_rec.product_id IS NULL THEN
424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
425: fnd_message.set_name('OZF', 'OZF_INVALID_PROD');
426: fnd_msg_pub.add;
427: END IF;
428: x_return_status := fnd_api.g_ret_sts_error;
429: RETURN;
430: END IF;

Line 440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

436: END IF;
437:
438: IF p_adj_rec.adjustment_type IN ('INCREASE_PAID', 'DECREASE_PAID') THEN
439: IF p_adj_rec.gl_account_credit = fnd_api.g_miss_num OR p_adj_rec.gl_account_credit IS NULL THEN
440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
441: fnd_message.set_name('OZF', 'OZF_NO_GL_CREDIT_ACCT');
442: fnd_msg_pub.add;
443: END IF;
444: x_return_status := fnd_api.g_ret_sts_error;

Line 442: fnd_msg_pub.add;

438: IF p_adj_rec.adjustment_type IN ('INCREASE_PAID', 'DECREASE_PAID') THEN
439: IF p_adj_rec.gl_account_credit = fnd_api.g_miss_num OR p_adj_rec.gl_account_credit IS NULL THEN
440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
441: fnd_message.set_name('OZF', 'OZF_NO_GL_CREDIT_ACCT');
442: fnd_msg_pub.add;
443: END IF;
444: x_return_status := fnd_api.g_ret_sts_error;
445: RETURN;
446: END IF;

Line 449: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

445: RETURN;
446: END IF;
447:
448: IF p_adj_rec.gl_account_debit = fnd_api.g_miss_num OR p_adj_rec.gl_account_debit IS NULL THEN
449: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
450: fnd_message.set_name('OZF', 'OZF_NO_GL_DEBIT_ACCT');
451: fnd_msg_pub.add;
452: END IF;
453: x_return_status := fnd_api.g_ret_sts_error;

Line 451: fnd_msg_pub.add;

447:
448: IF p_adj_rec.gl_account_debit = fnd_api.g_miss_num OR p_adj_rec.gl_account_debit IS NULL THEN
449: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
450: fnd_message.set_name('OZF', 'OZF_NO_GL_DEBIT_ACCT');
451: fnd_msg_pub.add;
452: END IF;
453: x_return_status := fnd_api.g_ret_sts_error;
454: RETURN;
455: END IF;

Line 465: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

461:
462: IF p_adj_rec.skip_acct_gen_flag <> fnd_api.g_miss_char AND p_adj_rec.skip_acct_gen_flag IS NOT NULL THEN
463:
464: IF p_adj_rec.skip_acct_gen_flag NOT IN ('F', 'T') THEN
465: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
466: fnd_message.set_name('OZF', 'OZF_INVALID_ACCT_GEN_FLAG');
467: fnd_msg_pub.add;
468: END IF;
469: x_return_status := fnd_api.g_ret_sts_error;

Line 467: fnd_msg_pub.add;

463:
464: IF p_adj_rec.skip_acct_gen_flag NOT IN ('F', 'T') THEN
465: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
466: fnd_message.set_name('OZF', 'OZF_INVALID_ACCT_GEN_FLAG');
467: fnd_msg_pub.add;
468: END IF;
469: x_return_status := fnd_api.g_ret_sts_error;
470: RETURN;
471: END IF;

Line 479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

475: IF p_adj_rec.order_line_id <> fnd_api.g_miss_num AND p_adj_rec.order_line_id IS NOT NULL THEN
476: OPEN c_order_line(p_adj_rec.order_line_id);
477: FETCH c_order_line INTO l_dummy;
478: IF c_order_line%NOTFOUND THEN
479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
480: fnd_message.set_name('OZF', 'OZF_INVALID_ORDER_LINE');
481: fnd_msg_pub.add;
482: END IF;
483: x_return_status := fnd_api.g_ret_sts_error;

Line 481: fnd_msg_pub.add;

477: FETCH c_order_line INTO l_dummy;
478: IF c_order_line%NOTFOUND THEN
479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
480: fnd_message.set_name('OZF', 'OZF_INVALID_ORDER_LINE');
481: fnd_msg_pub.add;
482: END IF;
483: x_return_status := fnd_api.g_ret_sts_error;
484: RETURN;
485: END IF;

Line 566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

562:
563: IF l_adj_rec.fund_id IS NULL THEN
564:
565: IF l_adj_rec.currency_code = fnd_api.g_miss_char OR l_adj_rec.currency_code IS NULL THEN
566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
567: fnd_message.set_name('OZF', 'OZF_FUND_NO_CURR_CODE');
568: fnd_msg_pub.add;
569: END IF;
570: RAISE fnd_api.g_exc_error;

Line 568: fnd_msg_pub.add;

564:
565: IF l_adj_rec.currency_code = fnd_api.g_miss_char OR l_adj_rec.currency_code IS NULL THEN
566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
567: fnd_message.set_name('OZF', 'OZF_FUND_NO_CURR_CODE');
568: fnd_msg_pub.add;
569: END IF;
570: RAISE fnd_api.g_exc_error;
571: END IF;
572:

Line 596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

592: --check the number of records returned by l_parent_src_tbl. if no records returned, raise exception
593: IF l_parent_src_tbl.count > 0 THEN
594: l_fund_id := l_parent_src_tbl (1).fund_id;
595: ELSE
596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
597: fnd_message.set_name('OZF', 'OZF_NO_SRC_BUDGETS');
598: fnd_msg_pub.add;
599: END IF;
600: RAISE fnd_api.g_exc_error;

Line 598: fnd_msg_pub.add;

594: l_fund_id := l_parent_src_tbl (1).fund_id;
595: ELSE
596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
597: fnd_message.set_name('OZF', 'OZF_NO_SRC_BUDGETS');
598: fnd_msg_pub.add;
599: END IF;
600: RAISE fnd_api.g_exc_error;
601: END IF;
602:

Line 798: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

794: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
795: END IF;
796:
797: IF l_act_util_rec.orig_utilization_id IS NULL THEN
798: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
799: fnd_message.set_name('OZF', 'OZF_NO_ORIG_UTIL_ID');
800: fnd_msg_pub.add;
801: END IF;
802: RAISE fnd_api.g_exc_error;

Line 800: fnd_msg_pub.add;

796:
797: IF l_act_util_rec.orig_utilization_id IS NULL THEN
798: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
799: fnd_message.set_name('OZF', 'OZF_NO_ORIG_UTIL_ID');
800: fnd_msg_pub.add;
801: END IF;
802: RAISE fnd_api.g_exc_error;
803: END IF;
804:

Line 808: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

804:
805: --if the original utilization is not posted to GL(e.g. marketing cost, or off invoice offer
806: --where gl posting is not required), then paid adjustment should not be allowed.
807: IF l_gl_posted_flag <> 'Y' THEN
808: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
809: fnd_message.set_name('OZF', 'OZF_ADJ_PAID_NOT_ALLOWED');
810: fnd_msg_pub.add;
811: END IF;
812: RAISE fnd_api.g_exc_error;

Line 810: fnd_msg_pub.add;

806: --where gl posting is not required), then paid adjustment should not be allowed.
807: IF l_gl_posted_flag <> 'Y' THEN
808: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
809: fnd_message.set_name('OZF', 'OZF_ADJ_PAID_NOT_ALLOWED');
810: fnd_msg_pub.add;
811: END IF;
812: RAISE fnd_api.g_exc_error;
813: END IF;
814:

Line 873: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

869: ozf_utility_pvt.debug_message('cust_account_id: ' || l_adj_rec.cust_account_id);
870: END IF;
871:
872: IF l_act_util_rec.orig_utilization_id IS NULL THEN
873: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
874: fnd_message.set_name('OZF', 'OZF_NO_ORIG_UTIL_ID');
875: fnd_msg_pub.add;
876: END IF;
877: RAISE fnd_api.g_exc_error;

Line 875: fnd_msg_pub.add;

871:
872: IF l_act_util_rec.orig_utilization_id IS NULL THEN
873: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
874: fnd_message.set_name('OZF', 'OZF_NO_ORIG_UTIL_ID');
875: fnd_msg_pub.add;
876: END IF;
877: RAISE fnd_api.g_exc_error;
878: END IF;
879:

Line 883: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

879:
880: --if the original utilization is not posted to GL(e.g. marketing cost, or off invoice offer
881: --where gl posting is not required), then paid adjustment should not be allowed.
882: IF l_gl_posted_flag <> 'Y' THEN
883: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
884: fnd_message.set_name('OZF', 'OZF_ADJ_PAID_NOT_ALLOWED');
885: fnd_msg_pub.add;
886: END IF;
887: RAISE fnd_api.g_exc_error;

Line 885: fnd_msg_pub.add;

881: --where gl posting is not required), then paid adjustment should not be allowed.
882: IF l_gl_posted_flag <> 'Y' THEN
883: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
884: fnd_message.set_name('OZF', 'OZF_ADJ_PAID_NOT_ALLOWED');
885: fnd_msg_pub.add;
886: END IF;
887: RAISE fnd_api.g_exc_error;
888: END IF;
889:

Line 914: FND_MSG_PUB.Count_And_Get (

910: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
911: RAISE fnd_api.g_exc_error;
912: END IF;
913:
914: FND_MSG_PUB.Count_And_Get (
915: p_encoded => FND_API.G_FALSE,
916: p_count => x_msg_count,
917: p_data => x_msg_data
918: );

Line 925: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

921: WHEN FND_API.G_EXC_ERROR THEN
922: ROLLBACK TO Create_Fund_Adjustment;
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
926: ,p_count => x_msg_count
927: ,p_data => x_msg_data
928: );
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 933: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: ROLLBACK TO Create_Fund_Adjustment;
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
934: ,p_count => x_msg_count
935: ,p_data => x_msg_data
936: );
937: WHEN OTHERS THEN

Line 940: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

936: );
937: WHEN OTHERS THEN
938: ROLLBACK TO Create_Fund_Adjustment;
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
940: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
941: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
942: END IF;
943: -- Standard call to get message count and if count=1, get the message
944: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 941: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

937: WHEN OTHERS THEN
938: ROLLBACK TO Create_Fund_Adjustment;
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
940: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
941: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
942: END IF;
943: -- Standard call to get message count and if count=1, get the message
944: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
945: ,p_count => x_msg_count

Line 944: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

940: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
941: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
942: END IF;
943: -- Standard call to get message count and if count=1, get the message
944: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
945: ,p_count => x_msg_count
946: ,p_data => x_msg_data
947: );
948: END Create_Fund_Adjustment;