[Home] [Help]
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;
230: RETURN;
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;
247: RETURN;
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;
263: RETURN;
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;
276: RETURN;
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;
286: RETURN;
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;
294: RETURN;
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;
318: RETURN;
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;
335: RETURN;
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;
353: RETURN;
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;
369: RETURN;
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;
385: RETURN;
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;
397: RETURN;
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;
413: RETURN;
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;
429: RETURN;
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;
445: RETURN;
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;
458: END IF;
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;
474: RETURN;
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;
490: RETURN;
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;
506: RETURN;
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;
528: RETURN;
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;
539: RETURN;
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;
547: RETURN;
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;
557: RETURN;
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;
565: RETURN;
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;
575: RETURN;
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;
583: RETURN;
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;
599: RETURN;
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;
618: RETURN;
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;
634: RETURN;
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;
650: RETURN;
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;
668: RETURN;
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;
684: RETURN;
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;
700: RETURN;
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;
718: RETURN;
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;
734: RETURN;
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;
750: RETURN;
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;
1474: RETURN;
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;
1488: RETURN;
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;
1499: RETURN;
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;
1512: RETURN;
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;
1524: RETURN;
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;
1537: RETURN;
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;
1547: RETURN;
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;
1586: RETURN;
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;
1599: RETURN;
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;
1909: END IF;
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;
1922: END IF;
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;
2058: RETURN;
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;
2072: RETURN;
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;
2083: RETURN;
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;
2096: RETURN;
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;
2111: RETURN;
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;
2134: RETURN;
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;
2150: RETURN;
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;
2173: RETURN;
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;
2189: RETURN;
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;
2207: RETURN;
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;
2218: RETURN;
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;
2529: END IF;
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;
2542: END IF;