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_FUNDS_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_FUNDS_PUB AS
2: /* $Header: OZFPFUNB.pls 120.7.12010000.2 2008/08/28 07:15:47 kdass ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'OZF_FUNDS_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_fund_items

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

221: --if both fund id and fund number are null, then raise exception
222: IF (p_fund_rec.fund_id = fnd_api.g_miss_num OR p_fund_rec.fund_id IS NULL) AND
223: (p_fund_rec.fund_number = fnd_api.g_miss_char OR p_fund_rec.fund_number IS NULL) THEN
224:
225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
226: fnd_message.set_name('OZF', 'OZF_NO_FUND_ID_NUM');
227: fnd_msg_pub.add;
228: END IF;
229: x_return_status := fnd_api.g_ret_sts_error;

Line 227: fnd_msg_pub.add;

223: (p_fund_rec.fund_number = fnd_api.g_miss_char OR p_fund_rec.fund_number IS NULL) THEN
224:
225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
226: fnd_message.set_name('OZF', 'OZF_NO_FUND_ID_NUM');
227: fnd_msg_pub.add;
228: END IF;
229: x_return_status := fnd_api.g_ret_sts_error;
230: RETURN;
231:

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

238: FETCH c_fund_exists INTO l_fund_exists;
239: CLOSE c_fund_exists;
240:
241: IF l_fund_exists IS NULL THEN
242: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
243: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_ID');
244: fnd_msg_pub.add;
245: END IF;
246: x_return_status := fnd_api.g_ret_sts_error;

Line 244: fnd_msg_pub.add;

240:
241: IF l_fund_exists IS NULL THEN
242: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
243: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_ID');
244: fnd_msg_pub.add;
245: END IF;
246: x_return_status := fnd_api.g_ret_sts_error;
247: RETURN;
248: END IF;

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

254: FETCH c_fund_num_exists INTO p_fund_rec.fund_id;
255: CLOSE c_fund_num_exists;
256:
257: IF p_fund_rec.fund_id IS NULL THEN
258: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
259: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_NUM');
260: fnd_msg_pub.add;
261: END IF;
262: x_return_status := fnd_api.g_ret_sts_error;

Line 260: fnd_msg_pub.add;

256:
257: IF p_fund_rec.fund_id IS NULL THEN
258: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
259: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_NUM');
260: fnd_msg_pub.add;
261: END IF;
262: x_return_status := fnd_api.g_ret_sts_error;
263: RETURN;
264: END IF;

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

267: END IF;
268:
269: --if fund name is null, then raise exception
270: IF p_fund_rec.short_name = fnd_api.g_miss_char OR p_fund_rec.short_name IS NULL THEN
271: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
272: fnd_message.set_name('OZF', 'OZF_NO_FUND_NAME');
273: fnd_msg_pub.add;
274: END IF;
275: x_return_status := fnd_api.g_ret_sts_error;

Line 273: fnd_msg_pub.add;

269: --if fund name is null, then raise exception
270: IF p_fund_rec.short_name = fnd_api.g_miss_char OR p_fund_rec.short_name IS NULL THEN
271: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
272: fnd_message.set_name('OZF', 'OZF_NO_FUND_NAME');
273: fnd_msg_pub.add;
274: END IF;
275: x_return_status := fnd_api.g_ret_sts_error;
276: RETURN;
277: END IF;

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

277: END IF;
278:
279: --if fund type is null, then raise exception
280: IF p_fund_rec.fund_type = fnd_api.g_miss_char OR p_fund_rec.fund_type IS NULL THEN
281: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
282: fnd_message.set_name('OZF', 'OZF_NO_FUND_TYPE');
283: fnd_msg_pub.add;
284: END IF;
285: x_return_status := fnd_api.g_ret_sts_error;

Line 283: fnd_msg_pub.add;

279: --if fund type is null, then raise exception
280: IF p_fund_rec.fund_type = fnd_api.g_miss_char OR p_fund_rec.fund_type IS NULL THEN
281: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
282: fnd_message.set_name('OZF', 'OZF_NO_FUND_TYPE');
283: fnd_msg_pub.add;
284: END IF;
285: x_return_status := fnd_api.g_ret_sts_error;
286: RETURN;
287: ELSE

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

285: x_return_status := fnd_api.g_ret_sts_error;
286: RETURN;
287: ELSE
288: IF p_fund_rec.fund_type NOT IN ('FIXED', 'FULLY_ACCRUED') THEN
289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
290: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_TYPE');
291: fnd_msg_pub.add;
292: END IF;
293: x_return_status := fnd_api.g_ret_sts_error;

Line 291: fnd_msg_pub.add;

287: ELSE
288: IF p_fund_rec.fund_type NOT IN ('FIXED', 'FULLY_ACCRUED') THEN
289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
290: fnd_message.set_name('OZF', 'OZF_INVALID_FUND_TYPE');
291: fnd_msg_pub.add;
292: END IF;
293: x_return_status := fnd_api.g_ret_sts_error;
294: RETURN;
295: END IF;

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

309: FETCH c_cust_setup_exists INTO l_cust_setup_exists;
310: CLOSE c_cust_setup_exists;
311:
312: IF l_cust_setup_exists IS NULL THEN
313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
314: fnd_message.set_name('OZF', 'OZF_INVALID_SETUP_ID');
315: fnd_msg_pub.add;
316: END IF;
317: x_return_status := fnd_api.g_ret_sts_error;

Line 315: fnd_msg_pub.add;

311:
312: IF l_cust_setup_exists IS NULL THEN
313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
314: fnd_message.set_name('OZF', 'OZF_INVALID_SETUP_ID');
315: fnd_msg_pub.add;
316: END IF;
317: x_return_status := fnd_api.g_ret_sts_error;
318: RETURN;
319: END IF;

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

326: FETCH c_par_fund_exists INTO l_par_fund_exists;
327: CLOSE c_par_fund_exists;
328:
329: IF l_fund_exists IS NULL THEN
330: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
331: fnd_message.set_name('OZF', 'OZF_INVALID_PAR_FUND_ID');
332: fnd_msg_pub.add;
333: END IF;
334: x_return_status := fnd_api.g_ret_sts_error;

Line 332: fnd_msg_pub.add;

328:
329: IF l_fund_exists IS NULL THEN
330: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
331: fnd_message.set_name('OZF', 'OZF_INVALID_PAR_FUND_ID');
332: fnd_msg_pub.add;
333: END IF;
334: x_return_status := fnd_api.g_ret_sts_error;
335: RETURN;
336: END IF;

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

344: FETCH c_par_fund_id_exists INTO l_par_fund_exists;
345: CLOSE c_par_fund_id_exists;
346:
347: IF l_par_fund_exists IS NULL THEN
348: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
349: fnd_message.set_name('OZF', 'OZF_INVALID_PAR_FUND_ID_NAME');
350: fnd_msg_pub.add;
351: END IF;
352: x_return_status := fnd_api.g_ret_sts_error;

Line 350: fnd_msg_pub.add;

346:
347: IF l_par_fund_exists IS NULL THEN
348: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
349: fnd_message.set_name('OZF', 'OZF_INVALID_PAR_FUND_ID_NAME');
350: fnd_msg_pub.add;
351: END IF;
352: x_return_status := fnd_api.g_ret_sts_error;
353: RETURN;
354: END IF;

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

360: FETCH c_par_fund_exists INTO l_par_fund_exists;
361: CLOSE c_par_fund_exists;
362:
363: IF l_par_fund_exists IS NULL THEN
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
365: fnd_message.set_name('OZF', 'OZF_INVALID_PAR_FUND_ID');
366: fnd_msg_pub.add;
367: END IF;
368: x_return_status := fnd_api.g_ret_sts_error;

Line 366: fnd_msg_pub.add;

362:
363: IF l_par_fund_exists IS NULL THEN
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
365: fnd_message.set_name('OZF', 'OZF_INVALID_PAR_FUND_ID');
366: fnd_msg_pub.add;
367: END IF;
368: x_return_status := fnd_api.g_ret_sts_error;
369: RETURN;
370: END IF;

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

376: FETCH c_par_fund_name_exists INTO p_fund_rec.parent_fund_id;
377: CLOSE c_par_fund_name_exists;
378:
379: IF p_fund_rec.parent_fund_id IS NULL THEN
380: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
381: fnd_message.set_name('OZF', 'OZF_INVALID_PAR_FUND_NAME');
382: fnd_msg_pub.add;
383: END IF;
384: x_return_status := fnd_api.g_ret_sts_error;

Line 382: fnd_msg_pub.add;

378:
379: IF p_fund_rec.parent_fund_id IS NULL THEN
380: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
381: fnd_message.set_name('OZF', 'OZF_INVALID_PAR_FUND_NAME');
382: fnd_msg_pub.add;
383: END IF;
384: x_return_status := fnd_api.g_ret_sts_error;
385: RETURN;
386: END IF;

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

388:
389: IF (p_fund_rec.category_name = fnd_api.g_miss_char OR p_fund_rec.category_name IS NULL) AND
390: (p_fund_rec.category_id = fnd_api.g_miss_num OR p_fund_rec.category_id IS NULL) THEN
391:
392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
393: fnd_message.set_name('OZF', 'OZF_NO_CAT_ID_NAME');
394: fnd_msg_pub.add;
395: END IF;
396: x_return_status := fnd_api.g_ret_sts_error;

Line 394: fnd_msg_pub.add;

390: (p_fund_rec.category_id = fnd_api.g_miss_num OR p_fund_rec.category_id IS NULL) THEN
391:
392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
393: fnd_message.set_name('OZF', 'OZF_NO_CAT_ID_NAME');
394: fnd_msg_pub.add;
395: END IF;
396: x_return_status := fnd_api.g_ret_sts_error;
397: RETURN;
398:

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

404: FETCH c_cat_exists INTO l_cat_exists;
405: CLOSE c_cat_exists;
406:
407: IF l_cat_exists IS NULL THEN
408: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
409: fnd_message.set_name('OZF', 'OZF_INVALID_CAT_ID_NAME');
410: fnd_msg_pub.add;
411: END IF;
412: x_return_status := fnd_api.g_ret_sts_error;

Line 410: fnd_msg_pub.add;

406:
407: IF l_cat_exists IS NULL THEN
408: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
409: fnd_message.set_name('OZF', 'OZF_INVALID_CAT_ID_NAME');
410: fnd_msg_pub.add;
411: END IF;
412: x_return_status := fnd_api.g_ret_sts_error;
413: RETURN;
414: END IF;

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

420: FETCH c_cat_id_exists INTO l_cat_exists;
421: CLOSE c_cat_id_exists;
422:
423: IF l_cat_exists 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_CAT_ID');
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 l_cat_exists 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_CAT_ID');
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: FETCH c_cat_name_exists INTO p_fund_rec.category_id;
437: CLOSE c_cat_name_exists;
438:
439: IF p_fund_rec.category_id 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_INVALID_CAT_NAME');
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:
439: IF p_fund_rec.category_id 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_INVALID_CAT_NAME');
442: fnd_msg_pub.add;
443: END IF;
444: x_return_status := fnd_api.g_ret_sts_error;
445: RETURN;
446: END IF;

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

449: IF p_mode = 'CREATE' THEN
450: p_fund_rec.org_id := MO_UTILS.get_default_org_id;
451:
452: IF p_fund_rec.org_id = fnd_api.g_miss_num OR p_fund_rec.org_id IS NULL THEN
453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
454: fnd_message.set_name('OZF', 'OZF_NO_DEFAULT_ORG_ID');
455: fnd_msg_pub.add;
456: END IF;
457: END IF;

Line 455: fnd_msg_pub.add;

451:
452: IF p_fund_rec.org_id = fnd_api.g_miss_num OR p_fund_rec.org_id IS NULL THEN
453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
454: fnd_message.set_name('OZF', 'OZF_NO_DEFAULT_ORG_ID');
455: fnd_msg_pub.add;
456: END IF;
457: END IF;
458: END IF;
459:

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

465: FETCH c_bus_unit_exists INTO l_bus_unit_exists;
466: CLOSE c_bus_unit_exists;
467:
468: IF l_bus_unit_exists IS NULL THEN
469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
470: fnd_message.set_name('OZF', 'OZF_INVALID_BUS_UNIT_ID_NAME');
471: fnd_msg_pub.add;
472: END IF;
473: x_return_status := fnd_api.g_ret_sts_error;

Line 471: fnd_msg_pub.add;

467:
468: IF l_bus_unit_exists IS NULL THEN
469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
470: fnd_message.set_name('OZF', 'OZF_INVALID_BUS_UNIT_ID_NAME');
471: fnd_msg_pub.add;
472: END IF;
473: x_return_status := fnd_api.g_ret_sts_error;
474: RETURN;
475: END IF;

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

481: FETCH c_bus_id_exists INTO l_bus_unit_exists;
482: CLOSE c_bus_id_exists;
483:
484: IF l_bus_unit_exists IS NULL THEN
485: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
486: fnd_message.set_name('OZF', 'OZF_INVALID_BUS_UNIT_ID');
487: fnd_msg_pub.add;
488: END IF;
489: x_return_status := fnd_api.g_ret_sts_error;

Line 487: fnd_msg_pub.add;

483:
484: IF l_bus_unit_exists IS NULL THEN
485: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
486: fnd_message.set_name('OZF', 'OZF_INVALID_BUS_UNIT_ID');
487: fnd_msg_pub.add;
488: END IF;
489: x_return_status := fnd_api.g_ret_sts_error;
490: RETURN;
491: END IF;

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

497: FETCH c_bus_name_exists INTO p_fund_rec.business_unit_id;
498: CLOSE c_bus_name_exists;
499:
500: IF p_fund_rec.business_unit_id IS NULL THEN
501: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
502: fnd_message.set_name('OZF', 'OZF_INVALID_BUS_UNIT');
503: fnd_msg_pub.add;
504: END IF;
505: x_return_status := fnd_api.g_ret_sts_error;

Line 503: fnd_msg_pub.add;

499:
500: IF p_fund_rec.business_unit_id IS NULL THEN
501: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
502: fnd_message.set_name('OZF', 'OZF_INVALID_BUS_UNIT');
503: fnd_msg_pub.add;
504: END IF;
505: x_return_status := fnd_api.g_ret_sts_error;
506: RETURN;
507: END IF;

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

519: END IF;
520:
521: --if currency code is null, then raise exception
522: IF p_fund_rec.currency_code_tc = fnd_api.g_miss_char OR p_fund_rec.currency_code_tc IS NULL THEN
523: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
524: fnd_message.set_name('OZF', 'OZF_NO_CURR_CODE');
525: fnd_msg_pub.add;
526: END IF;
527: x_return_status := fnd_api.g_ret_sts_error;

Line 525: fnd_msg_pub.add;

521: --if currency code is null, then raise exception
522: IF p_fund_rec.currency_code_tc = fnd_api.g_miss_char OR p_fund_rec.currency_code_tc IS NULL THEN
523: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
524: fnd_message.set_name('OZF', 'OZF_NO_CURR_CODE');
525: fnd_msg_pub.add;
526: END IF;
527: x_return_status := fnd_api.g_ret_sts_error;
528: RETURN;
529: END IF;

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

530:
531: IF p_fund_rec.fund_type = 'FULLY_ACCRUED' THEN
532:
533: IF p_fund_rec.accrual_basis = fnd_api.g_miss_char OR p_fund_rec.accrual_basis IS NULL THEN
534: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
535: fnd_message.set_name('OZF', 'OZF_NO_ACCR_BASIS');
536: fnd_msg_pub.add;
537: END IF;
538: x_return_status := fnd_api.g_ret_sts_error;

Line 536: fnd_msg_pub.add;

532:
533: IF p_fund_rec.accrual_basis = fnd_api.g_miss_char OR p_fund_rec.accrual_basis IS NULL THEN
534: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
535: fnd_message.set_name('OZF', 'OZF_NO_ACCR_BASIS');
536: fnd_msg_pub.add;
537: END IF;
538: x_return_status := fnd_api.g_ret_sts_error;
539: RETURN;
540: ELSE

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

538: x_return_status := fnd_api.g_ret_sts_error;
539: RETURN;
540: ELSE
541: IF p_fund_rec.accrual_basis NOT IN ('CUSTOMER', 'SALES') THEN
542: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
543: fnd_message.set_name('OZF', 'OZF_INVALID_ACCR_BASIS');
544: fnd_msg_pub.add;
545: END IF;
546: x_return_status := fnd_api.g_ret_sts_error;

Line 544: fnd_msg_pub.add;

540: ELSE
541: IF p_fund_rec.accrual_basis NOT IN ('CUSTOMER', 'SALES') THEN
542: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
543: fnd_message.set_name('OZF', 'OZF_INVALID_ACCR_BASIS');
544: fnd_msg_pub.add;
545: END IF;
546: x_return_status := fnd_api.g_ret_sts_error;
547: RETURN;
548: END IF;

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

548: END IF;
549: END IF;
550:
551: IF p_fund_rec.accrual_phase = fnd_api.g_miss_char OR p_fund_rec.accrual_phase IS NULL THEN
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
553: fnd_message.set_name('OZF', 'OZF_NO_ACCR_PHASE');
554: fnd_msg_pub.add;
555: END IF;
556: x_return_status := fnd_api.g_ret_sts_error;

Line 554: fnd_msg_pub.add;

550:
551: IF p_fund_rec.accrual_phase = fnd_api.g_miss_char OR p_fund_rec.accrual_phase IS NULL THEN
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
553: fnd_message.set_name('OZF', 'OZF_NO_ACCR_PHASE');
554: fnd_msg_pub.add;
555: END IF;
556: x_return_status := fnd_api.g_ret_sts_error;
557: RETURN;
558: ELSE

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

556: x_return_status := fnd_api.g_ret_sts_error;
557: RETURN;
558: ELSE
559: IF p_fund_rec.accrual_phase NOT IN ('ACCRUAL', 'VOLUME') THEN
560: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
561: fnd_message.set_name('OZF', 'OZF_INVALID_ACCR_PHASE');
562: fnd_msg_pub.add;
563: END IF;
564: x_return_status := fnd_api.g_ret_sts_error;

Line 562: fnd_msg_pub.add;

558: ELSE
559: IF p_fund_rec.accrual_phase NOT IN ('ACCRUAL', 'VOLUME') THEN
560: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
561: fnd_message.set_name('OZF', 'OZF_INVALID_ACCR_PHASE');
562: fnd_msg_pub.add;
563: END IF;
564: x_return_status := fnd_api.g_ret_sts_error;
565: RETURN;
566: END IF;

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

566: END IF;
567: END IF;
568:
569: IF p_fund_rec.accrual_discount_level = fnd_api.g_miss_char OR p_fund_rec.accrual_discount_level IS NULL THEN
570: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
571: fnd_message.set_name('OZF', 'OZF_NO_DISC_LEVEL');
572: fnd_msg_pub.add;
573: END IF;
574: x_return_status := fnd_api.g_ret_sts_error;

Line 572: fnd_msg_pub.add;

568:
569: IF p_fund_rec.accrual_discount_level = fnd_api.g_miss_char OR p_fund_rec.accrual_discount_level IS NULL THEN
570: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
571: fnd_message.set_name('OZF', 'OZF_NO_DISC_LEVEL');
572: fnd_msg_pub.add;
573: END IF;
574: x_return_status := fnd_api.g_ret_sts_error;
575: RETURN;
576: ELSE

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

574: x_return_status := fnd_api.g_ret_sts_error;
575: RETURN;
576: ELSE
577: IF p_fund_rec.accrual_discount_level NOT IN ('LINE', 'LINEGROUP') THEN
578: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
579: fnd_message.set_name('OZF', 'OZF_INVALID_DISC_LEVEL');
580: fnd_msg_pub.add;
581: END IF;
582: x_return_status := fnd_api.g_ret_sts_error;

Line 580: fnd_msg_pub.add;

576: ELSE
577: IF p_fund_rec.accrual_discount_level NOT IN ('LINE', 'LINEGROUP') THEN
578: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
579: fnd_message.set_name('OZF', 'OZF_INVALID_DISC_LEVEL');
580: fnd_msg_pub.add;
581: END IF;
582: x_return_status := fnd_api.g_ret_sts_error;
583: RETURN;
584: END IF;

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

590: p_fund_rec.liability_flag := NVL(p_fund_rec.liability_flag, 'N');
591: END IF;
592:
593: IF p_fund_rec.liability_flag NOT IN ('Y', 'N') THEN
594: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
595: fnd_message.set_name('OZF', 'OZF_INVALID_LIAB_FLAG');
596: fnd_msg_pub.add;
597: END IF;
598: x_return_status := fnd_api.g_ret_sts_error;

Line 596: fnd_msg_pub.add;

592:
593: IF p_fund_rec.liability_flag NOT IN ('Y', 'N') THEN
594: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
595: fnd_message.set_name('OZF', 'OZF_INVALID_LIAB_FLAG');
596: fnd_msg_pub.add;
597: END IF;
598: x_return_status := fnd_api.g_ret_sts_error;
599: RETURN;
600: END IF;

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

609: FETCH c_thrh_exists INTO l_thrh_exists;
610: CLOSE c_thrh_exists;
611:
612: IF l_thrh_exists IS NULL THEN
613: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
614: fnd_message.set_name('OZF', 'OZF_INVALID_BUS_UNIT_ID_NAME');
615: fnd_msg_pub.add;
616: END IF;
617: x_return_status := fnd_api.g_ret_sts_error;

Line 615: fnd_msg_pub.add;

611:
612: IF l_thrh_exists IS NULL THEN
613: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
614: fnd_message.set_name('OZF', 'OZF_INVALID_BUS_UNIT_ID_NAME');
615: fnd_msg_pub.add;
616: END IF;
617: x_return_status := fnd_api.g_ret_sts_error;
618: RETURN;
619: END IF;

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

625: FETCH c_thrh_id_exists INTO l_thrh_exists;
626: CLOSE c_thrh_id_exists;
627:
628: IF l_thrh_exists IS NULL THEN
629: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
630: fnd_message.set_name('OZF', 'OZF_INVALID_THRH_ID');
631: fnd_msg_pub.add;
632: END IF;
633: x_return_status := fnd_api.g_ret_sts_error;

Line 631: fnd_msg_pub.add;

627:
628: IF l_thrh_exists IS NULL THEN
629: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
630: fnd_message.set_name('OZF', 'OZF_INVALID_THRH_ID');
631: fnd_msg_pub.add;
632: END IF;
633: x_return_status := fnd_api.g_ret_sts_error;
634: RETURN;
635: END IF;

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

641: FETCH c_thrh_name_exists INTO p_fund_rec.threshold_id;
642: CLOSE c_thrh_name_exists;
643:
644: IF p_fund_rec.threshold_id IS NULL THEN
645: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
646: fnd_message.set_name('OZF', 'OZF_INVALID_THRH_NAME');
647: fnd_msg_pub.add;
648: END IF;
649: x_return_status := fnd_api.g_ret_sts_error;

Line 647: fnd_msg_pub.add;

643:
644: IF p_fund_rec.threshold_id IS NULL THEN
645: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
646: fnd_message.set_name('OZF', 'OZF_INVALID_THRH_NAME');
647: fnd_msg_pub.add;
648: END IF;
649: x_return_status := fnd_api.g_ret_sts_error;
650: RETURN;
651: END IF;

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

659: FETCH c_task_exists INTO l_task_exists;
660: CLOSE c_task_exists;
661:
662: IF l_task_exists IS NULL THEN
663: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
664: fnd_message.set_name('OZF', 'OZF_INVALID_TASK_ID_NAME');
665: fnd_msg_pub.add;
666: END IF;
667: x_return_status := fnd_api.g_ret_sts_error;

Line 665: fnd_msg_pub.add;

661:
662: IF l_task_exists IS NULL THEN
663: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
664: fnd_message.set_name('OZF', 'OZF_INVALID_TASK_ID_NAME');
665: fnd_msg_pub.add;
666: END IF;
667: x_return_status := fnd_api.g_ret_sts_error;
668: RETURN;
669: END IF;

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

675: FETCH c_task_id_exists INTO l_task_exists;
676: CLOSE c_task_id_exists;
677:
678: IF l_task_exists IS NULL THEN
679: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
680: fnd_message.set_name('OZF', 'OZF_INVALID_TASK_ID');
681: fnd_msg_pub.add;
682: END IF;
683: x_return_status := fnd_api.g_ret_sts_error;

Line 681: fnd_msg_pub.add;

677:
678: IF l_task_exists IS NULL THEN
679: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
680: fnd_message.set_name('OZF', 'OZF_INVALID_TASK_ID');
681: fnd_msg_pub.add;
682: END IF;
683: x_return_status := fnd_api.g_ret_sts_error;
684: RETURN;
685: END IF;

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

691: FETCH c_task_name_exists INTO p_fund_rec.task_id;
692: CLOSE c_task_name_exists;
693:
694: IF p_fund_rec.task_id IS NULL THEN
695: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
696: fnd_message.set_name('OZF', 'OZF_INVALID_TASK_NAME');
697: fnd_msg_pub.add;
698: END IF;
699: x_return_status := fnd_api.g_ret_sts_error;

Line 697: fnd_msg_pub.add;

693:
694: IF p_fund_rec.task_id IS NULL THEN
695: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
696: fnd_message.set_name('OZF', 'OZF_INVALID_TASK_NAME');
697: fnd_msg_pub.add;
698: END IF;
699: x_return_status := fnd_api.g_ret_sts_error;
700: RETURN;
701: END IF;

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

709: FETCH c_ledger_exists INTO l_ledger_exists;
710: CLOSE c_ledger_exists;
711:
712: IF l_ledger_exists IS NULL THEN
713: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
714: fnd_message.set_name('OZF', 'OZF_INVALID_LEDGER_ID_NAME');
715: fnd_msg_pub.add;
716: END IF;
717: x_return_status := fnd_api.g_ret_sts_error;

Line 715: fnd_msg_pub.add;

711:
712: IF l_ledger_exists IS NULL THEN
713: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
714: fnd_message.set_name('OZF', 'OZF_INVALID_LEDGER_ID_NAME');
715: fnd_msg_pub.add;
716: END IF;
717: x_return_status := fnd_api.g_ret_sts_error;
718: RETURN;
719: END IF;

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

725: FETCH c_ledger_id_exists INTO l_ledger_exists;
726: CLOSE c_ledger_id_exists;
727:
728: IF l_ledger_exists IS NULL THEN
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
730: fnd_message.set_name('OZF', 'OZF_INVALID_LEDGER_ID');
731: fnd_msg_pub.add;
732: END IF;
733: x_return_status := fnd_api.g_ret_sts_error;

Line 731: fnd_msg_pub.add;

727:
728: IF l_ledger_exists IS NULL THEN
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
730: fnd_message.set_name('OZF', 'OZF_INVALID_LEDGER_ID');
731: fnd_msg_pub.add;
732: END IF;
733: x_return_status := fnd_api.g_ret_sts_error;
734: RETURN;
735: END IF;

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

741: FETCH c_ledger_name_exists INTO p_fund_rec.ledger_id;
742: CLOSE c_ledger_name_exists;
743:
744: IF p_fund_rec.ledger_id IS NULL THEN
745: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
746: fnd_message.set_name('OZF', 'OZF_INVALID_LEDGER_NAME');
747: fnd_msg_pub.add;
748: END IF;
749: x_return_status := fnd_api.g_ret_sts_error;

Line 747: fnd_msg_pub.add;

743:
744: IF p_fund_rec.ledger_id IS NULL THEN
745: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
746: fnd_message.set_name('OZF', 'OZF_INVALID_LEDGER_NAME');
747: fnd_msg_pub.add;
748: END IF;
749: x_return_status := fnd_api.g_ret_sts_error;
750: RETURN;
751: END IF;

Line 985: FND_MSG_PUB.Count_And_Get (

981: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
982: RAISE fnd_api.g_exc_error;
983: END IF;
984:
985: FND_MSG_PUB.Count_And_Get (
986: p_encoded => FND_API.G_FALSE,
987: p_count => x_msg_count,
988: p_data => x_msg_data
989: );

Line 996: FND_MSG_PUB.Count_And_Get (

992: WHEN FND_API.G_EXC_ERROR THEN
993: ROLLBACK TO Create_Fund_PUB;
994: x_return_status := FND_API.G_RET_STS_ERROR;
995: -- Standard call to get message count and if count=1, get the message
996: FND_MSG_PUB.Count_And_Get (
997: p_encoded => FND_API.G_FALSE,
998: p_count => x_msg_count,
999: p_data => x_msg_data
1000: );

Line 1005: FND_MSG_PUB.Count_And_Get (

1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: ROLLBACK TO Create_Fund_PUB;
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004: -- Standard call to get message count and if count=1, get the message
1005: FND_MSG_PUB.Count_And_Get (
1006: p_encoded => FND_API.G_FALSE,
1007: p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );

Line 1013: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1009: );
1010: WHEN OTHERS THEN
1011: ROLLBACK TO Create_Fund_PUB;
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1016: END IF;
1017: -- Standard call to get message count and if count=1, get the message

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

1011: ROLLBACK TO Create_Fund_PUB;
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1016: END IF;
1017: -- Standard call to get message count and if count=1, get the message
1018: FND_MSG_PUB.Count_And_Get (
1019: p_encoded => FND_API.G_FALSE,

Line 1018: FND_MSG_PUB.Count_And_Get (

1014: THEN
1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1016: END IF;
1017: -- Standard call to get message count and if count=1, get the message
1018: FND_MSG_PUB.Count_And_Get (
1019: p_encoded => FND_API.G_FALSE,
1020: p_count => x_msg_count,
1021: p_data => x_msg_data
1022: );

Line 1077: FND_MSG_PUB.Count_And_Get(

1073: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1074: RAISE fnd_api.g_exc_error;
1075: END IF;
1076:
1077: FND_MSG_PUB.Count_And_Get(
1078: p_encoded => FND_API.G_FALSE,
1079: p_count => x_msg_count,
1080: p_data => x_msg_data
1081: );

Line 1088: FND_MSG_PUB.Count_And_Get (

1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO Delete_Fund_PUB;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: -- Standard call to get message count and if count=1, get the message
1088: FND_MSG_PUB.Count_And_Get (
1089: p_encoded => FND_API.G_FALSE,
1090: p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );

Line 1097: FND_MSG_PUB.Count_And_Get (

1093: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1094: ROLLBACK TO Delete_Fund_PUB;
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1096: -- Standard call to get message count and if count=1, get the message
1097: FND_MSG_PUB.Count_And_Get (
1098: p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );

Line 1105: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1101: );
1102: WHEN OTHERS THEN
1103: ROLLBACK TO Delete_Fund_PUB;
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1106: THEN
1107: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1108: END IF;
1109: -- Standard call to get message count and if count=1, get the message

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

1103: ROLLBACK TO Delete_Fund_PUB;
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1106: THEN
1107: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1108: END IF;
1109: -- Standard call to get message count and if count=1, get the message
1110: FND_MSG_PUB.Count_And_Get (
1111: p_encoded => FND_API.G_FALSE,

Line 1110: FND_MSG_PUB.Count_And_Get (

1106: THEN
1107: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1108: END IF;
1109: -- Standard call to get message count and if count=1, get the message
1110: FND_MSG_PUB.Count_And_Get (
1111: p_encoded => FND_API.G_FALSE,
1112: p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );

Line 1320: FND_MSG_PUB.Count_And_Get (

1316: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1317: RAISE fnd_api.g_exc_error;
1318: END IF;
1319:
1320: FND_MSG_PUB.Count_And_Get (
1321: p_encoded => FND_API.G_FALSE,
1322: p_count => x_msg_count,
1323: p_data => x_msg_data
1324: );

Line 1331: FND_MSG_PUB.Count_And_Get (

1327: WHEN FND_API.G_EXC_ERROR THEN
1328: ROLLBACK TO Update_Fund_PUB;
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330: -- Standard call to get message count and if count=1, get the message
1331: FND_MSG_PUB.Count_And_Get (
1332: p_encoded => FND_API.G_FALSE,
1333: p_count => x_msg_count,
1334: p_data => x_msg_data
1335: );

Line 1340: FND_MSG_PUB.Count_And_Get (

1336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1337: ROLLBACK TO Update_Fund_PUB;
1338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1339: -- Standard call to get message count and if count=1, get the message
1340: FND_MSG_PUB.Count_And_Get (
1341: p_encoded => FND_API.G_FALSE,
1342: p_count => x_msg_count,
1343: p_data => x_msg_data
1344: );

Line 1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1344: );
1345: WHEN OTHERS THEN
1346: ROLLBACK TO Update_Fund_PUB;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message

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

1346: ROLLBACK TO Update_Fund_PUB;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,

Line 1353: FND_MSG_PUB.Count_And_Get (

1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1355: p_count => x_msg_count,
1356: p_data => x_msg_data
1357: );

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

1465: ELSE
1466: --if activity market segment id is null, then raise exception
1467: IF (p_mks_rec.activity_market_segment_id = fnd_api.g_miss_num OR p_mks_rec.activity_market_segment_id IS NULL) THEN
1468:
1469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1470: fnd_message.set_name('OZF', 'OZF_NO_ACT_SEG_ID');
1471: fnd_msg_pub.add;
1472: END IF;
1473: x_return_status := fnd_api.g_ret_sts_error;

Line 1471: fnd_msg_pub.add;

1467: IF (p_mks_rec.activity_market_segment_id = fnd_api.g_miss_num OR p_mks_rec.activity_market_segment_id IS NULL) THEN
1468:
1469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1470: fnd_message.set_name('OZF', 'OZF_NO_ACT_SEG_ID');
1471: fnd_msg_pub.add;
1472: END IF;
1473: x_return_status := fnd_api.g_ret_sts_error;
1474: RETURN;
1475: ELSE

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

1479: FETCH c_act_mkt_exists INTO l_act_mkt_exists;
1480: CLOSE c_act_mkt_exists;
1481:
1482: IF l_act_mkt_exists IS NULL THEN
1483: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1484: fnd_message.set_name('OZF', 'OZF_INVALID_ACT_SEG_ID');
1485: fnd_msg_pub.add;
1486: END IF;
1487: x_return_status := fnd_api.g_ret_sts_error;

Line 1485: fnd_msg_pub.add;

1481:
1482: IF l_act_mkt_exists IS NULL THEN
1483: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1484: fnd_message.set_name('OZF', 'OZF_INVALID_ACT_SEG_ID');
1485: fnd_msg_pub.add;
1486: END IF;
1487: x_return_status := fnd_api.g_ret_sts_error;
1488: RETURN;
1489: END IF;

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

1490: END IF;
1491: END IF;
1492:
1493: IF p_mks_rec.act_market_segment_used_by_id = fnd_api.g_miss_num OR p_mks_rec.act_market_segment_used_by_id IS NULL THEN
1494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1495: fnd_message.set_name('OZF', 'OZF_NO_MKT_SEG_USED_BY_ID');
1496: fnd_msg_pub.add;
1497: END IF;
1498: x_return_status := fnd_api.g_ret_sts_error;

Line 1496: fnd_msg_pub.add;

1492:
1493: IF p_mks_rec.act_market_segment_used_by_id = fnd_api.g_miss_num OR p_mks_rec.act_market_segment_used_by_id IS NULL THEN
1494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1495: fnd_message.set_name('OZF', 'OZF_NO_MKT_SEG_USED_BY_ID');
1496: fnd_msg_pub.add;
1497: END IF;
1498: x_return_status := fnd_api.g_ret_sts_error;
1499: RETURN;
1500: ELSE

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

1503: FETCH c_segment_used_by_exists INTO l_segment_used_by_exists;
1504: CLOSE c_segment_used_by_exists;
1505:
1506: IF l_segment_used_by_exists IS NULL THEN
1507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1508: fnd_message.set_name('OZF', 'OZF_INVALID_MKT_SEG_USED_BY_ID');
1509: fnd_msg_pub.add;
1510: END IF;
1511: x_return_status := fnd_api.g_ret_sts_error;

Line 1509: fnd_msg_pub.add;

1505:
1506: IF l_segment_used_by_exists IS NULL THEN
1507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1508: fnd_message.set_name('OZF', 'OZF_INVALID_MKT_SEG_USED_BY_ID');
1509: fnd_msg_pub.add;
1510: END IF;
1511: x_return_status := fnd_api.g_ret_sts_error;
1512: RETURN;
1513: END IF;

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

1515:
1516: p_mks_rec.arc_act_market_segment_used_by := 'FUND';
1517:
1518: IF p_mks_rec.segment_type = fnd_api.g_miss_char OR p_mks_rec.segment_type IS NULL THEN
1519: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1520: fnd_message.set_name('OZF', 'OZF_NO_SEGMENT_TYPE');
1521: fnd_msg_pub.add;
1522: END IF;
1523: x_return_status := fnd_api.g_ret_sts_error;

Line 1521: fnd_msg_pub.add;

1517:
1518: IF p_mks_rec.segment_type = fnd_api.g_miss_char OR p_mks_rec.segment_type IS NULL THEN
1519: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1520: fnd_message.set_name('OZF', 'OZF_NO_SEGMENT_TYPE');
1521: fnd_msg_pub.add;
1522: END IF;
1523: x_return_status := fnd_api.g_ret_sts_error;
1524: RETURN;
1525: ELSE

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

1528: FETCH c_segment_exists INTO l_segment_exists;
1529: CLOSE c_segment_exists;
1530:
1531: IF l_segment_exists IS NULL THEN
1532: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1533: fnd_message.set_name('OZF', 'OZF_INVALID_SEGMENT_TYPE');
1534: fnd_msg_pub.add;
1535: END IF;
1536: x_return_status := fnd_api.g_ret_sts_error;

Line 1534: fnd_msg_pub.add;

1530:
1531: IF l_segment_exists IS NULL THEN
1532: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1533: fnd_message.set_name('OZF', 'OZF_INVALID_SEGMENT_TYPE');
1534: fnd_msg_pub.add;
1535: END IF;
1536: x_return_status := fnd_api.g_ret_sts_error;
1537: RETURN;
1538: END IF;

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

1538: END IF;
1539: END IF;
1540:
1541: IF p_mks_rec.market_segment_id = fnd_api.g_miss_num OR p_mks_rec.market_segment_id IS NULL THEN
1542: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1543: fnd_message.set_name('OZF', 'OZF_NO_MKT_SEG_ID');
1544: fnd_msg_pub.add;
1545: END IF;
1546: x_return_status := fnd_api.g_ret_sts_error;

Line 1544: fnd_msg_pub.add;

1540:
1541: IF p_mks_rec.market_segment_id = fnd_api.g_miss_num OR p_mks_rec.market_segment_id IS NULL THEN
1542: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1543: fnd_message.set_name('OZF', 'OZF_NO_MKT_SEG_ID');
1544: fnd_msg_pub.add;
1545: END IF;
1546: x_return_status := fnd_api.g_ret_sts_error;
1547: RETURN;
1548: ELSE

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

1577: CLOSE c_segment_terr;
1578: END IF;
1579:
1580: IF l_segment_id_exists IS NULL THEN
1581: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1582: fnd_message.set_name('OZF', 'OZF_INVALID_MKT_SEG_ID');
1583: fnd_msg_pub.add;
1584: END IF;
1585: x_return_status := fnd_api.g_ret_sts_error;

Line 1583: fnd_msg_pub.add;

1579:
1580: IF l_segment_id_exists IS NULL THEN
1581: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1582: fnd_message.set_name('OZF', 'OZF_INVALID_MKT_SEG_ID');
1583: fnd_msg_pub.add;
1584: END IF;
1585: x_return_status := fnd_api.g_ret_sts_error;
1586: RETURN;
1587: END IF;

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

1590:
1591: p_mks_rec.exclude_flag := NVL(p_mks_rec.exclude_flag, 'N');
1592:
1593: IF p_mks_rec.exclude_flag NOT IN ('Y', 'N') THEN
1594: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1595: fnd_message.set_name('OZF', 'OZF_INVALID_EXCLUDE_FLAG');
1596: fnd_msg_pub.add;
1597: END IF;
1598: x_return_status := fnd_api.g_ret_sts_error;

Line 1596: fnd_msg_pub.add;

1592:
1593: IF p_mks_rec.exclude_flag NOT IN ('Y', 'N') THEN
1594: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1595: fnd_message.set_name('OZF', 'OZF_INVALID_EXCLUDE_FLAG');
1596: fnd_msg_pub.add;
1597: END IF;
1598: x_return_status := fnd_api.g_ret_sts_error;
1599: RETURN;
1600: END IF;

Line 1676: FND_MSG_PUB.Count_And_Get (

1672: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1673: RAISE fnd_api.g_exc_error;
1674: END IF;
1675:
1676: FND_MSG_PUB.Count_And_Get (
1677: p_encoded => FND_API.G_FALSE,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data
1680: );

Line 1687: FND_MSG_PUB.Count_And_Get (

1683: WHEN FND_API.G_EXC_ERROR THEN
1684: ROLLBACK TO create_market_pub;
1685: x_return_status := FND_API.G_RET_STS_ERROR;
1686: -- Standard call to get message count and if count=1, get the message
1687: FND_MSG_PUB.Count_And_Get (
1688: p_encoded => FND_API.G_FALSE,
1689: p_count => x_msg_count,
1690: p_data => x_msg_data
1691: );

Line 1696: FND_MSG_PUB.Count_And_Get (

1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693: ROLLBACK TO create_market_pub;
1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1695: -- Standard call to get message count and if count=1, get the message
1696: FND_MSG_PUB.Count_And_Get (
1697: p_encoded => FND_API.G_FALSE,
1698: p_count => x_msg_count,
1699: p_data => x_msg_data
1700: );

Line 1704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1700: );
1701: WHEN OTHERS THEN
1702: ROLLBACK TO create_market_pub;
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1705: THEN
1706: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1707: END IF;
1708: -- Standard call to get message count and if count=1, get the message

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

1702: ROLLBACK TO create_market_pub;
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1705: THEN
1706: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1707: END IF;
1708: -- Standard call to get message count and if count=1, get the message
1709: FND_MSG_PUB.Count_And_Get (
1710: p_encoded => FND_API.G_FALSE,

Line 1709: FND_MSG_PUB.Count_And_Get (

1705: THEN
1706: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1707: END IF;
1708: -- Standard call to get message count and if count=1, get the message
1709: FND_MSG_PUB.Count_And_Get (
1710: p_encoded => FND_API.G_FALSE,
1711: p_count => x_msg_count,
1712: p_data => x_msg_data
1713: );

Line 1809: FND_MSG_PUB.Count_And_Get (

1805: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1806: RAISE fnd_api.g_exc_error;
1807: END IF;
1808:
1809: FND_MSG_PUB.Count_And_Get (
1810: p_encoded => FND_API.G_FALSE,
1811: p_count => x_msg_count,
1812: p_data => x_msg_data
1813: );

Line 1820: FND_MSG_PUB.Count_And_Get (

1816: WHEN FND_API.G_EXC_ERROR THEN
1817: ROLLBACK TO update_market_pub;
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: -- Standard call to get message count and if count=1, get the message
1820: FND_MSG_PUB.Count_And_Get (
1821: p_encoded => FND_API.G_FALSE,
1822: p_count => x_msg_count,
1823: p_data => x_msg_data
1824: );

Line 1829: FND_MSG_PUB.Count_And_Get (

1825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1826: ROLLBACK TO update_market_pub;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: -- Standard call to get message count and if count=1, get the message
1829: FND_MSG_PUB.Count_And_Get (
1830: p_encoded => FND_API.G_FALSE,
1831: p_count => x_msg_count,
1832: p_data => x_msg_data
1833: );

Line 1837: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1833: );
1834: WHEN OTHERS THEN
1835: ROLLBACK TO update_market_pub;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1838: THEN
1839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1840: END IF;
1841: -- Standard call to get message count and if count=1, get the message

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

1835: ROLLBACK TO update_market_pub;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1838: THEN
1839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1840: END IF;
1841: -- Standard call to get message count and if count=1, get the message
1842: FND_MSG_PUB.Count_And_Get (
1843: p_encoded => FND_API.G_FALSE,

Line 1842: FND_MSG_PUB.Count_And_Get (

1838: THEN
1839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1840: END IF;
1841: -- Standard call to get message count and if count=1, get the message
1842: FND_MSG_PUB.Count_And_Get (
1843: p_encoded => FND_API.G_FALSE,
1844: p_count => x_msg_count,
1845: p_data => x_msg_data
1846: );

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

1900:
1901: --if activity market segment id is null, then raise exception
1902: IF (p_act_mks_id = fnd_api.g_miss_num OR p_act_mks_id IS NULL) THEN
1903:
1904: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1905: fnd_message.set_name('OZF', 'OZF_NO_ACT_SEG_ID');
1906: fnd_msg_pub.add;
1907: END IF;
1908: RAISE fnd_api.g_exc_error;

Line 1906: fnd_msg_pub.add;

1902: IF (p_act_mks_id = fnd_api.g_miss_num OR p_act_mks_id IS NULL) THEN
1903:
1904: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1905: fnd_message.set_name('OZF', 'OZF_NO_ACT_SEG_ID');
1906: fnd_msg_pub.add;
1907: END IF;
1908: RAISE fnd_api.g_exc_error;
1909: END IF;
1910:

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

1913: FETCH c_valid_act_mks_id INTO l_object_version;
1914: CLOSE c_valid_act_mks_id;
1915:
1916: IF l_object_version IS NULL THEN
1917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1918: fnd_message.set_name('OZF', 'OZF_INVALID_ACT_SEG_ID');
1919: fnd_msg_pub.add;
1920: END IF;
1921: RAISE fnd_api.g_exc_error;

Line 1919: fnd_msg_pub.add;

1915:
1916: IF l_object_version IS NULL THEN
1917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1918: fnd_message.set_name('OZF', 'OZF_INVALID_ACT_SEG_ID');
1919: fnd_msg_pub.add;
1920: END IF;
1921: RAISE fnd_api.g_exc_error;
1922: END IF;
1923:

Line 1941: FND_MSG_PUB.Count_And_Get (

1937: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1938: RAISE fnd_api.g_exc_error;
1939: END IF;
1940:
1941: FND_MSG_PUB.Count_And_Get (
1942: p_encoded => FND_API.G_FALSE,
1943: p_count => x_msg_count,
1944: p_data => x_msg_data
1945: );

Line 1952: FND_MSG_PUB.Count_And_Get (

1948: WHEN FND_API.G_EXC_ERROR THEN
1949: ROLLBACK TO delete_market_pub;
1950: x_return_status := FND_API.G_RET_STS_ERROR;
1951: -- Standard call to get message count and if count=1, get the message
1952: FND_MSG_PUB.Count_And_Get (
1953: p_encoded => FND_API.G_FALSE,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data
1956: );

Line 1961: FND_MSG_PUB.Count_And_Get (

1957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1958: ROLLBACK TO delete_market_pub;
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: -- Standard call to get message count and if count=1, get the message
1961: FND_MSG_PUB.Count_And_Get (
1962: p_encoded => FND_API.G_FALSE,
1963: p_count => x_msg_count,
1964: p_data => x_msg_data
1965: );

Line 1969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1965: );
1966: WHEN OTHERS THEN
1967: ROLLBACK TO delete_market_pub;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1970: THEN
1971: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1972: END IF;
1973: -- Standard call to get message count and if count=1, get the message

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

1967: ROLLBACK TO delete_market_pub;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1970: THEN
1971: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1972: END IF;
1973: -- Standard call to get message count and if count=1, get the message
1974: FND_MSG_PUB.Count_And_Get (
1975: p_encoded => FND_API.G_FALSE,

Line 1974: FND_MSG_PUB.Count_And_Get (

1970: THEN
1971: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1972: END IF;
1973: -- Standard call to get message count and if count=1, get the message
1974: FND_MSG_PUB.Count_And_Get (
1975: p_encoded => FND_API.G_FALSE,
1976: p_count => x_msg_count,
1977: p_data => x_msg_data
1978: );

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

2049: ELSE
2050: --if activity product id is null, then raise exception
2051: IF (p_act_product_rec.activity_product_id = fnd_api.g_miss_num OR p_act_product_rec.activity_product_id IS NULL) THEN
2052:
2053: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2054: fnd_message.set_name('OZF', 'OZF_NO_ACT_PROD_ID');
2055: fnd_msg_pub.add;
2056: END IF;
2057: x_return_status := fnd_api.g_ret_sts_error;

Line 2055: fnd_msg_pub.add;

2051: IF (p_act_product_rec.activity_product_id = fnd_api.g_miss_num OR p_act_product_rec.activity_product_id IS NULL) THEN
2052:
2053: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2054: fnd_message.set_name('OZF', 'OZF_NO_ACT_PROD_ID');
2055: fnd_msg_pub.add;
2056: END IF;
2057: x_return_status := fnd_api.g_ret_sts_error;
2058: RETURN;
2059: ELSE

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

2063: FETCH c_act_prod_exists INTO l_act_prod_exists;
2064: CLOSE c_act_prod_exists;
2065:
2066: IF l_act_prod_exists IS NULL THEN
2067: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2068: fnd_message.set_name('OZF', 'OZF_INVALID_ACT_PROD_ID');
2069: fnd_msg_pub.add;
2070: END IF;
2071: x_return_status := fnd_api.g_ret_sts_error;

Line 2069: fnd_msg_pub.add;

2065:
2066: IF l_act_prod_exists IS NULL THEN
2067: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2068: fnd_message.set_name('OZF', 'OZF_INVALID_ACT_PROD_ID');
2069: fnd_msg_pub.add;
2070: END IF;
2071: x_return_status := fnd_api.g_ret_sts_error;
2072: RETURN;
2073: END IF;

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

2074: END IF;
2075: END IF;
2076:
2077: IF p_act_product_rec.act_product_used_by_id = fnd_api.g_miss_num OR p_act_product_rec.act_product_used_by_id IS NULL THEN
2078: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2079: fnd_message.set_name('OZF', 'OZF_NO_PROD_USED_BY');
2080: fnd_msg_pub.add;
2081: END IF;
2082: x_return_status := fnd_api.g_ret_sts_error;

Line 2080: fnd_msg_pub.add;

2076:
2077: IF p_act_product_rec.act_product_used_by_id = fnd_api.g_miss_num OR p_act_product_rec.act_product_used_by_id IS NULL THEN
2078: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2079: fnd_message.set_name('OZF', 'OZF_NO_PROD_USED_BY');
2080: fnd_msg_pub.add;
2081: END IF;
2082: x_return_status := fnd_api.g_ret_sts_error;
2083: RETURN;
2084: ELSE

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

2087: FETCH c_act_prod_used_by_exists INTO l_act_prod_used_by_exists;
2088: CLOSE c_act_prod_used_by_exists;
2089:
2090: IF l_act_prod_used_by_exists IS NULL THEN
2091: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2092: fnd_message.set_name('OZF', 'OZF_INVALID_PROD_USED_BY');
2093: fnd_msg_pub.add;
2094: END IF;
2095: x_return_status := fnd_api.g_ret_sts_error;

Line 2093: fnd_msg_pub.add;

2089:
2090: IF l_act_prod_used_by_exists IS NULL THEN
2091: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2092: fnd_message.set_name('OZF', 'OZF_INVALID_PROD_USED_BY');
2093: fnd_msg_pub.add;
2094: END IF;
2095: x_return_status := fnd_api.g_ret_sts_error;
2096: RETURN;
2097: END IF;

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

2102: (p_act_product_rec.inventory_item_name = fnd_api.g_miss_char OR p_act_product_rec.inventory_item_name IS NULL) AND
2103: (p_act_product_rec.category_id = fnd_api.g_miss_num OR p_act_product_rec.category_id IS NULL) AND
2104: (p_act_product_rec.category_name = fnd_api.g_miss_char OR p_act_product_rec.category_name IS NULL) THEN
2105:
2106: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2107: fnd_message.set_name('OZF', 'OZF_NO_INV_ITEM_CAT');
2108: fnd_msg_pub.add;
2109: END IF;
2110: x_return_status := fnd_api.g_ret_sts_error;

Line 2108: fnd_msg_pub.add;

2104: (p_act_product_rec.category_name = fnd_api.g_miss_char OR p_act_product_rec.category_name IS NULL) THEN
2105:
2106: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2107: fnd_message.set_name('OZF', 'OZF_NO_INV_ITEM_CAT');
2108: fnd_msg_pub.add;
2109: END IF;
2110: x_return_status := fnd_api.g_ret_sts_error;
2111: RETURN;
2112:

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

2125: FETCH c_inv_id_exists INTO l_inv_id_exists;
2126: CLOSE c_inv_id_exists;
2127:
2128: IF l_inv_id_exists IS NULL THEN
2129: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2130: fnd_message.set_name('OZF', 'OZF_INVALID_INV_ITEM_ID');
2131: fnd_msg_pub.add;
2132: END IF;
2133: x_return_status := fnd_api.g_ret_sts_error;

Line 2131: fnd_msg_pub.add;

2127:
2128: IF l_inv_id_exists IS NULL THEN
2129: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2130: fnd_message.set_name('OZF', 'OZF_INVALID_INV_ITEM_ID');
2131: fnd_msg_pub.add;
2132: END IF;
2133: x_return_status := fnd_api.g_ret_sts_error;
2134: RETURN;
2135: END IF;

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

2141: FETCH c_inv_name_exists INTO p_act_product_rec.inventory_item_id;
2142: CLOSE c_inv_name_exists;
2143:
2144: IF p_act_product_rec.inventory_item_id IS NULL THEN
2145: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2146: fnd_message.set_name('OZF', 'OZF_INVALID_INV_ITEM_NAME');
2147: fnd_msg_pub.add;
2148: END IF;
2149: x_return_status := fnd_api.g_ret_sts_error;

Line 2147: fnd_msg_pub.add;

2143:
2144: IF p_act_product_rec.inventory_item_id IS NULL THEN
2145: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2146: fnd_message.set_name('OZF', 'OZF_INVALID_INV_ITEM_NAME');
2147: fnd_msg_pub.add;
2148: END IF;
2149: x_return_status := fnd_api.g_ret_sts_error;
2150: RETURN;
2151: END IF;

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

2164: FETCH c_cat_id_exists INTO p_act_product_rec.category_set_id;
2165: CLOSE c_cat_id_exists;
2166:
2167: IF p_act_product_rec.category_set_id IS NULL THEN
2168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2169: fnd_message.set_name('OZF', 'OZF_INVALID_CATEGORY_ID');
2170: fnd_msg_pub.add;
2171: END IF;
2172: x_return_status := fnd_api.g_ret_sts_error;

Line 2170: fnd_msg_pub.add;

2166:
2167: IF p_act_product_rec.category_set_id IS NULL THEN
2168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2169: fnd_message.set_name('OZF', 'OZF_INVALID_CATEGORY_ID');
2170: fnd_msg_pub.add;
2171: END IF;
2172: x_return_status := fnd_api.g_ret_sts_error;
2173: RETURN;
2174: END IF;

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

2180: FETCH c_cat_name_exists INTO p_act_product_rec.category_id, p_act_product_rec.category_set_id;
2181: CLOSE c_cat_name_exists;
2182:
2183: IF p_act_product_rec.category_id IS NULL THEN
2184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2185: fnd_message.set_name('OZF', 'OZF_INVALID_CATEGORY_NAME');
2186: fnd_msg_pub.add;
2187: END IF;
2188: x_return_status := fnd_api.g_ret_sts_error;

Line 2186: fnd_msg_pub.add;

2182:
2183: IF p_act_product_rec.category_id IS NULL THEN
2184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2185: fnd_message.set_name('OZF', 'OZF_INVALID_CATEGORY_NAME');
2186: fnd_msg_pub.add;
2187: END IF;
2188: x_return_status := fnd_api.g_ret_sts_error;
2189: RETURN;
2190: END IF;

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

2198:
2199: p_act_product_rec.primary_product_flag := NVL(p_act_product_rec.primary_product_flag, 'N');
2200:
2201: IF p_act_product_rec.primary_product_flag NOT IN ('Y', 'N') THEN
2202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2203: fnd_message.set_name('OZF', 'OZF_INVALID_PRIMARY_FLAG');
2204: fnd_msg_pub.add;
2205: END IF;
2206: x_return_status := fnd_api.g_ret_sts_error;

Line 2204: fnd_msg_pub.add;

2200:
2201: IF p_act_product_rec.primary_product_flag NOT IN ('Y', 'N') THEN
2202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2203: fnd_message.set_name('OZF', 'OZF_INVALID_PRIMARY_FLAG');
2204: fnd_msg_pub.add;
2205: END IF;
2206: x_return_status := fnd_api.g_ret_sts_error;
2207: RETURN;
2208: END IF;

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

2209:
2210: p_act_product_rec.excluded_flag := NVL(p_act_product_rec.excluded_flag, 'N');
2211:
2212: IF p_act_product_rec.excluded_flag NOT IN ('Y', 'N') THEN
2213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2214: fnd_message.set_name('OZF', 'OZF_INVALID_EXCLUDED_FLAG');
2215: fnd_msg_pub.add;
2216: END IF;
2217: x_return_status := fnd_api.g_ret_sts_error;

Line 2215: fnd_msg_pub.add;

2211:
2212: IF p_act_product_rec.excluded_flag NOT IN ('Y', 'N') THEN
2213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2214: fnd_message.set_name('OZF', 'OZF_INVALID_EXCLUDED_FLAG');
2215: fnd_msg_pub.add;
2216: END IF;
2217: x_return_status := fnd_api.g_ret_sts_error;
2218: RETURN;
2219: END IF;

Line 2299: FND_MSG_PUB.Count_And_Get (

2295: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2296: RAISE fnd_api.g_exc_error;
2297: END IF;
2298:
2299: FND_MSG_PUB.Count_And_Get (
2300: p_encoded => FND_API.G_FALSE,
2301: p_count => x_msg_count,
2302: p_data => x_msg_data
2303: );

Line 2310: FND_MSG_PUB.Count_And_Get (

2306: WHEN FND_API.G_EXC_ERROR THEN
2307: ROLLBACK TO create_product_pub;
2308: x_return_status := FND_API.G_RET_STS_ERROR;
2309: -- Standard call to get message count and if count=1, get the message
2310: FND_MSG_PUB.Count_And_Get (
2311: p_encoded => FND_API.G_FALSE,
2312: p_count => x_msg_count,
2313: p_data => x_msg_data
2314: );

Line 2319: FND_MSG_PUB.Count_And_Get (

2315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2316: ROLLBACK TO create_product_pub;
2317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2318: -- Standard call to get message count and if count=1, get the message
2319: FND_MSG_PUB.Count_And_Get (
2320: p_encoded => FND_API.G_FALSE,
2321: p_count => x_msg_count,
2322: p_data => x_msg_data
2323: );

Line 2327: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2323: );
2324: WHEN OTHERS THEN
2325: ROLLBACK TO create_product_pub;
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2328: THEN
2329: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2330: END IF;
2331: -- Standard call to get message count and if count=1, get the message

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

2325: ROLLBACK TO create_product_pub;
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2328: THEN
2329: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2330: END IF;
2331: -- Standard call to get message count and if count=1, get the message
2332: FND_MSG_PUB.Count_And_Get (
2333: p_encoded => FND_API.G_FALSE,

Line 2332: FND_MSG_PUB.Count_And_Get (

2328: THEN
2329: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2330: END IF;
2331: -- Standard call to get message count and if count=1, get the message
2332: FND_MSG_PUB.Count_And_Get (
2333: p_encoded => FND_API.G_FALSE,
2334: p_count => x_msg_count,
2335: p_data => x_msg_data
2336: );

Line 2443: FND_MSG_PUB.Count_And_Get (

2439: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2440: RAISE fnd_api.g_exc_error;
2441: END IF;
2442:
2443: FND_MSG_PUB.Count_And_Get (
2444: p_encoded => FND_API.G_FALSE,
2445: p_count => x_msg_count,
2446: p_data => x_msg_data
2447: );

Line 2454: FND_MSG_PUB.Count_And_Get (

2450: WHEN FND_API.G_EXC_ERROR THEN
2451: ROLLBACK TO update_product_pub;
2452: x_return_status := FND_API.G_RET_STS_ERROR;
2453: -- Standard call to get message count and if count=1, get the message
2454: FND_MSG_PUB.Count_And_Get (
2455: p_encoded => FND_API.G_FALSE,
2456: p_count => x_msg_count,
2457: p_data => x_msg_data
2458: );

Line 2463: FND_MSG_PUB.Count_And_Get (

2459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2460: ROLLBACK TO update_product_pub;
2461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2462: -- Standard call to get message count and if count=1, get the message
2463: FND_MSG_PUB.Count_And_Get (
2464: p_encoded => FND_API.G_FALSE,
2465: p_count => x_msg_count,
2466: p_data => x_msg_data
2467: );

Line 2471: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2467: );
2468: WHEN OTHERS THEN
2469: ROLLBACK TO update_product_pub;
2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2471: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2472: THEN
2473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2474: END IF;
2475: -- Standard call to get message count and if count=1, get the message

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

2469: ROLLBACK TO update_product_pub;
2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2471: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2472: THEN
2473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2474: END IF;
2475: -- Standard call to get message count and if count=1, get the message
2476: FND_MSG_PUB.Count_And_Get (
2477: p_encoded => FND_API.G_FALSE,

Line 2476: FND_MSG_PUB.Count_And_Get (

2472: THEN
2473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2474: END IF;
2475: -- Standard call to get message count and if count=1, get the message
2476: FND_MSG_PUB.Count_And_Get (
2477: p_encoded => FND_API.G_FALSE,
2478: p_count => x_msg_count,
2479: p_data => x_msg_data
2480: );

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

2520:
2521: --if activity market segment id is null, then raise exception
2522: IF (p_act_product_id = fnd_api.g_miss_num OR p_act_product_id IS NULL) THEN
2523:
2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2525: fnd_message.set_name('OZF', 'OZF_NO_ACT_PROD_ID');
2526: fnd_msg_pub.add;
2527: END IF;
2528: RAISE fnd_api.g_exc_error;

Line 2526: fnd_msg_pub.add;

2522: IF (p_act_product_id = fnd_api.g_miss_num OR p_act_product_id IS NULL) THEN
2523:
2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2525: fnd_message.set_name('OZF', 'OZF_NO_ACT_PROD_ID');
2526: fnd_msg_pub.add;
2527: END IF;
2528: RAISE fnd_api.g_exc_error;
2529: END IF;
2530:

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

2533: FETCH c_valid_act_prod_id INTO l_object_version;
2534: CLOSE c_valid_act_prod_id;
2535:
2536: IF l_object_version IS NULL THEN
2537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2538: fnd_message.set_name('OZF', 'OZF_INVALID_ACT_PROD_ID');
2539: fnd_msg_pub.add;
2540: END IF;
2541: RAISE fnd_api.g_exc_error;

Line 2539: fnd_msg_pub.add;

2535:
2536: IF l_object_version IS NULL THEN
2537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2538: fnd_message.set_name('OZF', 'OZF_INVALID_ACT_PROD_ID');
2539: fnd_msg_pub.add;
2540: END IF;
2541: RAISE fnd_api.g_exc_error;
2542: END IF;
2543:

Line 2561: FND_MSG_PUB.Count_And_Get (

2557: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2558: RAISE fnd_api.g_exc_error;
2559: END IF;
2560:
2561: FND_MSG_PUB.Count_And_Get (
2562: p_encoded => FND_API.G_FALSE,
2563: p_count => x_msg_count,
2564: p_data => x_msg_data
2565: );

Line 2572: FND_MSG_PUB.Count_And_Get (

2568: WHEN FND_API.G_EXC_ERROR THEN
2569: ROLLBACK TO delete_product_pub;
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: -- Standard call to get message count and if count=1, get the message
2572: FND_MSG_PUB.Count_And_Get (
2573: p_encoded => FND_API.G_FALSE,
2574: p_count => x_msg_count,
2575: p_data => x_msg_data
2576: );

Line 2581: FND_MSG_PUB.Count_And_Get (

2577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2578: ROLLBACK TO delete_product_pub;
2579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2580: -- Standard call to get message count and if count=1, get the message
2581: FND_MSG_PUB.Count_And_Get (
2582: p_encoded => FND_API.G_FALSE,
2583: p_count => x_msg_count,
2584: p_data => x_msg_data
2585: );

Line 2589: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2585: );
2586: WHEN OTHERS THEN
2587: ROLLBACK TO delete_product_pub;
2588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2589: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2590: THEN
2591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2592: END IF;
2593: -- Standard call to get message count and if count=1, get the message

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

2587: ROLLBACK TO delete_product_pub;
2588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2589: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2590: THEN
2591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2592: END IF;
2593: -- Standard call to get message count and if count=1, get the message
2594: FND_MSG_PUB.Count_And_Get (
2595: p_encoded => FND_API.G_FALSE,

Line 2594: FND_MSG_PUB.Count_And_Get (

2590: THEN
2591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2592: END IF;
2593: -- Standard call to get message count and if count=1, get the message
2594: FND_MSG_PUB.Count_And_Get (
2595: p_encoded => FND_API.G_FALSE,
2596: p_count => x_msg_count,
2597: p_data => x_msg_data
2598: );