32: IF (l_tmp_exist = 0)
33: THEN
34: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
35: THEN
36: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
37: fnd_message.set_token ('OBJ_NAME', p_payment_group_code);
38: fnd_msg_pub.ADD;
39: END IF;
40:
33: THEN
34: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
35: THEN
36: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
37: fnd_message.set_token ('OBJ_NAME', p_payment_group_code);
38: fnd_msg_pub.ADD;
39: END IF;
40:
41: RAISE fnd_api.g_exc_error;
85: IS
86: BEGIN
87: IF p_org_id IS NULL
88: THEN
89: fnd_message.set_name ('FND', 'MO_OU_REQUIRED');
90: fnd_msg_pub.ADD;
91: RAISE fnd_api.g_exc_error;
92: END IF;
93: END;
485: IF (p_pe_rec.credit_type IS NOT NULL AND p_pe_rec.credit_type_id IS NULL)
486: THEN
487: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
488: THEN
489: fnd_message.set_name ('CN', 'CN_CREDIT_TYPE_NOT_EXIST');
490: fnd_message.set_token ('CREDIT_TYPE', p_pe_rec.credit_type);
491: fnd_msg_pub.ADD;
492: END IF;
493:
486: THEN
487: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
488: THEN
489: fnd_message.set_name ('CN', 'CN_CREDIT_TYPE_NOT_EXIST');
490: fnd_message.set_token ('CREDIT_TYPE', p_pe_rec.credit_type);
491: fnd_msg_pub.ADD;
492: END IF;
493:
494: x_loading_status := 'CREDIT_TYPE_NOT_EXIST';
499: IF (p_pe_rec.interval_name IS NOT NULL AND p_pe_rec.interval_type_id IS NULL)
500: THEN
501: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
502: THEN
503: fnd_message.set_name ('CN', 'CN_INTERVAL_TYPE_NOT_EXIST');
504: fnd_message.set_token ('INTERVAL_NAME', p_pe_rec.interval_name);
505: fnd_msg_pub.ADD;
506: END IF;
507:
500: THEN
501: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
502: THEN
503: fnd_message.set_name ('CN', 'CN_INTERVAL_TYPE_NOT_EXIST');
504: fnd_message.set_token ('INTERVAL_NAME', p_pe_rec.interval_name);
505: fnd_msg_pub.ADD;
506: END IF;
507:
508: x_loading_status := 'INTERVAL_TYPE_NOT_EXIST';
636: -- Error, check the msg level and add an error message to the
637: -- API message list
638: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
639: THEN
640: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
641: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
642: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_desc);
643: fnd_msg_pub.ADD;
644: END IF;
637: -- API message list
638: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
639: THEN
640: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
641: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
642: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_desc);
643: fnd_msg_pub.ADD;
644: END IF;
645:
638: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
639: THEN
640: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
641: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
642: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_desc);
643: fnd_msg_pub.ADD;
644: END IF;
645:
646: x_loading_status := 'CN_PLN_NOT_CONSISTENT';
653: -- Error, check the msg level and add an error message to the
654: -- API message list
655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
656: THEN
657: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
658: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
659: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
660: fnd_msg_pub.ADD;
661: END IF;
654: -- API message list
655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
656: THEN
657: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
658: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
659: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
660: fnd_msg_pub.ADD;
661: END IF;
662:
655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
656: THEN
657: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
658: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
659: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
660: fnd_msg_pub.ADD;
661: END IF;
662:
663: x_loading_status := 'CN_PLN_NOT_CONSISTENT';
670: -- Error, check the msg level and add an error message to the
671: -- API message list
672: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
673: THEN
674: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
675: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
676: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_target);
677: fnd_msg_pub.ADD;
678: END IF;
671: -- API message list
672: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
673: THEN
674: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
675: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
676: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_target);
677: fnd_msg_pub.ADD;
678: END IF;
679:
672: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
673: THEN
674: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
675: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
676: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_target);
677: fnd_msg_pub.ADD;
678: END IF;
679:
680: x_loading_status := 'CN_PLN_NOT_CONSISTENT';
805: IF (l_tmp_exist = 0)
806: THEN
807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
808: THEN
809: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
810: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
811: fnd_msg_pub.ADD;
812: END IF;
813:
806: THEN
807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
808: THEN
809: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
810: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
811: fnd_msg_pub.ADD;
812: END IF;
813:
814: x_loading_status := 'CN_INVALID_DATA';
824: IF (l_tmp_exist = 0)
825: THEN
826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
827: THEN
828: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
829: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_incentive_type_code);
830: fnd_msg_pub.ADD;
831: END IF;
832:
825: THEN
826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
827: THEN
828: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
829: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_incentive_type_code);
830: fnd_msg_pub.ADD;
831: END IF;
832:
833: x_loading_status := 'CN_INVALID_DATA';
971: THEN
972: -- Error you cannot have rates for quota type is NONE
973: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
974: THEN
975: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
976: fnd_message.set_token ('PLAN_NAME', p_quota_name);
977: fnd_msg_pub.ADD;
978: END IF;
979:
972: -- Error you cannot have rates for quota type is NONE
973: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
974: THEN
975: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
976: fnd_message.set_token ('PLAN_NAME', p_quota_name);
977: fnd_msg_pub.ADD;
978: END IF;
979:
980: x_loading_status := 'QUOTA_CANNOT_HAVE_RATES';
1094: THEN
1095: -- Error you cannot have rates for quota type is NONE
1096: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1097: THEN
1098: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
1099: fnd_message.set_token ('PLAN_NAME', p_quota_name);
1100: fnd_msg_pub.ADD;
1101: END IF;
1102:
1095: -- Error you cannot have rates for quota type is NONE
1096: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1097: THEN
1098: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
1099: fnd_message.set_token ('PLAN_NAME', p_quota_name);
1100: fnd_msg_pub.ADD;
1101: END IF;
1102:
1103: x_loading_status := 'QUOTA_CANNOT_HAVE_RATES';
1310: AND p_period_quotas_rec_tbl.COUNT > 0 THEN
1311:
1312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1313: THEN
1314: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_CANNOT_HAVE_PERIODS');
1315: FND_MSG_PUB.Add;
1316: END IF;
1317: x_loading_status := 'QUOTA_CANNOT_HAVE_PERIODS';
1318: RAISE FND_API.G_EXC_ERROR ;
1405: IF l_trx_factor_rec_tbl (OUTER).rev_class_name IS NULL
1406: THEN
1407: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1408: THEN
1409: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
1410: fnd_msg_pub.ADD;
1411: END IF;
1412:
1413: x_loading_status := 'REV_CLASS_NOT_ASSIGNED';
1418: IF l_rev_class_id IS NULL AND l_trx_factor_rec_tbl (OUTER).rev_class_name IS NOT NULL
1419: THEN
1420: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1421: THEN
1422: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
1423: fnd_msg_pub.ADD;
1424: END IF;
1425:
1426: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
1434: IF l_quota_rule_id IS NULL
1435: THEN
1436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1437: THEN
1438: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
1439: fnd_message.set_token ('PLAN_NAME', p_quota_name);
1440: fnd_message.set_token ('REVENUE_CLASS_NAME', l_trx_factor_rec_tbl (OUTER).rev_class_name);
1441: fnd_msg_pub.ADD;
1442: END IF;
1435: THEN
1436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1437: THEN
1438: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
1439: fnd_message.set_token ('PLAN_NAME', p_quota_name);
1440: fnd_message.set_token ('REVENUE_CLASS_NAME', l_trx_factor_rec_tbl (OUTER).rev_class_name);
1441: fnd_msg_pub.ADD;
1442: END IF;
1443:
1436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1437: THEN
1438: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
1439: fnd_message.set_token ('PLAN_NAME', p_quota_name);
1440: fnd_message.set_token ('REVENUE_CLASS_NAME', l_trx_factor_rec_tbl (OUTER).rev_class_name);
1441: fnd_msg_pub.ADD;
1442: END IF;
1443:
1444: x_loading_status := 'QUOTA_RULE_NOT_EXIST';
1455: IF l_meaning IS NULL
1456: THEN
1457: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1458: THEN
1459: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXIST');
1460: fnd_message.set_token ('TRANSACTION_TYPE', p_trx_factor_rec_tbl (INNER).trx_type);
1461: fnd_msg_pub.ADD;
1462: END IF;
1463:
1456: THEN
1457: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1458: THEN
1459: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXIST');
1460: fnd_message.set_token ('TRANSACTION_TYPE', p_trx_factor_rec_tbl (INNER).trx_type);
1461: fnd_msg_pub.ADD;
1462: END IF;
1463:
1464: x_loading_status := 'CN_TRX_TYPE_NOT_EXISTS';
1577: IF p_quota_name_old IS NOT NULL
1578: THEN
1579: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1580: THEN
1581: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
1582: fnd_message.set_token ('PE_NAME', p_quota_name_old);
1583: fnd_msg_pub.ADD;
1584: END IF;
1585:
1578: THEN
1579: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1580: THEN
1581: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
1582: fnd_message.set_token ('PE_NAME', p_quota_name_old);
1583: fnd_msg_pub.ADD;
1584: END IF;
1585:
1586: x_loading_status := 'CN_PLN_NOT_EXIST';
1675: IF (p_pe_rec.end_date IS NOT NULL AND TRUNC (p_pe_rec.end_date) < TRUNC (p_pe_rec.start_date))
1676: THEN
1677: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1678: THEN
1679: fnd_message.set_name ('CN', 'CN_INVALID_DATE_RANGE');
1680: fnd_msg_pub.ADD;
1681: END IF;
1682:
1683: x_loading_status := 'INVALID_END_DATE';
1689: IF (p_pe_rec.calc_formula_name IS NOT NULL AND p_pe_rec.calc_formula_id IS NULL)
1690: THEN
1691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1692: THEN
1693: fnd_message.set_name ('CN', 'CN_FORMULA_NOT_EXIST');
1694: fnd_message.set_token ('FORMULA_NAME', p_pe_rec.calc_formula_name);
1695: fnd_msg_pub.ADD;
1696: END IF;
1697:
1690: THEN
1691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1692: THEN
1693: fnd_message.set_name ('CN', 'CN_FORMULA_NOT_EXIST');
1694: fnd_message.set_token ('FORMULA_NAME', p_pe_rec.calc_formula_name);
1695: fnd_msg_pub.ADD;
1696: END IF;
1697:
1698: x_loading_status := 'FORMULA_NOT_EXIST';
1861: IF p_quota_name_old IS NOT NULL
1862: THEN
1863: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1864: THEN
1865: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
1866: fnd_message.set_token ('PE_NAME', p_quota_name_old);
1867: fnd_msg_pub.ADD;
1868: END IF;
1869:
1862: THEN
1863: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1864: THEN
1865: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
1866: fnd_message.set_token ('PE_NAME', p_quota_name_old);
1867: fnd_msg_pub.ADD;
1868: END IF;
1869:
1870: x_loading_status := 'CN_PLN_NOT_EXIST';
1881: IF p_new_pe_rec.quota_id IS NOT NULL AND p_new_pe_rec.quota_id <> x_old_pe_rec.quota_id
1882: THEN
1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1884: THEN
1885: fnd_message.set_name ('CN', 'PLN_QUOTA_EXISTS');
1886: fnd_msg_pub.ADD;
1887: END IF;
1888:
1889: x_loading_status := 'CN_PLN_EXISTS';
2404: )
2405: THEN
2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2407: THEN
2408: fnd_message.set_name ('CN', 'PLN_QUOTA_EXISTS');
2409: fnd_msg_pub.ADD;
2410: END IF;
2411:
2412: GOTO end_api_body;
3676: IF l_quota_id IS NULL AND l_p_quota_name IS NOT NULL
3677: THEN
3678: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3679: THEN
3680: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
3681: fnd_message.set_token ('PE_NAME', l_p_quota_name);
3682: fnd_msg_pub.ADD;
3683: END IF;
3684:
3677: THEN
3678: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3679: THEN
3680: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
3681: fnd_message.set_token ('PE_NAME', l_p_quota_name);
3682: fnd_msg_pub.ADD;
3683: END IF;
3684:
3685: x_loading_status := 'CN_PLN_NOT_EXIST';
4417: IF l_quota_id IS NULL
4418: THEN
4419: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4420: THEN
4421: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
4422: fnd_message.set_token ('PE_NAME', l_pe_name);
4423: fnd_msg_pub.ADD;
4424: END IF;
4425:
4418: THEN
4419: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4420: THEN
4421: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
4422: fnd_message.set_token ('PE_NAME', l_pe_name);
4423: fnd_msg_pub.ADD;
4424: END IF;
4425:
4426: x_loading_status := 'CN_PLN_NOT_EXIST';
4768:
4769: -- Add CN_DUP_PLN_NAME_TOO_LONG message
4770: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4771: THEN
4772: fnd_message.set_name ('CN', 'CN_DUP_PLN_NAME_TOO_LONG');
4773: fnd_message.set_token ('FROM_PE', l_p_plan_element_name);
4774: fnd_message.set_token ('TO_PE', l_x_plan_element_name);
4775: fnd_msg_pub.ADD;
4776: END IF;
4769: -- Add CN_DUP_PLN_NAME_TOO_LONG message
4770: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4771: THEN
4772: fnd_message.set_name ('CN', 'CN_DUP_PLN_NAME_TOO_LONG');
4773: fnd_message.set_token ('FROM_PE', l_p_plan_element_name);
4774: fnd_message.set_token ('TO_PE', l_x_plan_element_name);
4775: fnd_msg_pub.ADD;
4776: END IF;
4777:
4770: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4771: THEN
4772: fnd_message.set_name ('CN', 'CN_DUP_PLN_NAME_TOO_LONG');
4773: fnd_message.set_token ('FROM_PE', l_p_plan_element_name);
4774: fnd_message.set_token ('TO_PE', l_x_plan_element_name);
4775: fnd_msg_pub.ADD;
4776: END IF;
4777:
4778: l_warning_flag := 'Y';
4811: THEN
4812: -- IF Plan Element Exists Raise an Error
4813: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4814: THEN
4815: fnd_message.set_name ('CN', 'PLN_QUOTA_EXISTS');
4816: fnd_msg_pub.ADD;
4817: END IF;
4818:
4819: x_loading_status := 'CN_PLN_EXISTS';