[Home] [Help]
68:
69: IF c_plan_element_csr%NOTFOUND
70: THEN
71: fnd_message.set_name ('CN', 'CN_INVALID_UPDATE_REC');
72: fnd_msg_pub.ADD;
73:
74: CLOSE c_plan_element_csr;
75:
76: RAISE fnd_api.g_exc_error;
112: WHERE quota_id = p_quota_id AND org_id = p_org_id);
113: EXCEPTION
114: WHEN NO_DATA_FOUND
115: THEN
116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
117: THEN
118: fnd_message.set_name ('FND', 'MO_ORG_INVALID');
119: fnd_msg_pub.ADD;
120: END IF;
115: THEN
116: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
117: THEN
118: fnd_message.set_name ('FND', 'MO_ORG_INVALID');
119: fnd_msg_pub.ADD;
120: END IF;
121:
122: RETURN FALSE;
123: END;
625: EXCEPTION
626: WHEN fnd_api.g_exc_error
627: THEN
628: x_return_status := fnd_api.g_ret_sts_error;
629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
630: WHEN fnd_api.g_exc_unexpected_error
631: THEN
632: x_return_status := fnd_api.g_ret_sts_unexp_error;
633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
630: WHEN fnd_api.g_exc_unexpected_error
631: THEN
632: x_return_status := fnd_api.g_ret_sts_unexp_error;
633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
634: WHEN OTHERS
635: THEN
636: x_return_status := fnd_api.g_ret_sts_unexp_error;
637: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
634: WHEN OTHERS
635: THEN
636: x_return_status := fnd_api.g_ret_sts_unexp_error;
637: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
638: THEN
639: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
640: END IF;
641: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
635: THEN
636: x_return_status := fnd_api.g_ret_sts_unexp_error;
637: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
638: THEN
639: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
640: END IF;
641: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
642:
643: END add_system_note;
637: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
638: THEN
639: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
640: END IF;
641: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
642:
643: END add_system_note;
644:
645: -------------------------------------------------------------------------+-+
665: token_name4 => NULL,
666: token_value4 => NULL,
667: TRANSLATE => TRUE
668: );
669: fnd_msg_pub.ADD;
670: END set_message;
671:
672: -- -------------------------------------------------------------------------+-+
673: --| Procedure: Insert_rate_quotas
768: ELSIF p_rt_quota_asgns_rec_tbl.COUNT > 0
769: THEN
770: -- if table count is > 0 but the quota type code is NONE
771: -- then raise an error
772: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
773: THEN
774: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
775: fnd_message.set_token ('PLAN_NAME', p_quota_name);
776: fnd_msg_pub.ADD;
772: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
773: THEN
774: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
775: fnd_message.set_token ('PLAN_NAME', p_quota_name);
776: fnd_msg_pub.ADD;
777: END IF;
778:
779: x_loading_status := 'QUOTA_CANNOT_HAVE_RATES';
780: RAISE fnd_api.g_exc_error;
792: THEN
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794: x_loading_status := 'UNEXPECTED_ERR';
795:
796: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
797: THEN
798: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
799: END IF;
800: END update_rate_quotas;
794: x_loading_status := 'UNEXPECTED_ERR';
795:
796: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
797: THEN
798: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
799: END IF;
800: END update_rate_quotas;
801:
802: -- -------------------------------------------------------------------------+-+
893: l_lookup_type := '';
894: -- Check/Valid quota_type_code
895: IF p_plan_element.quota_type_code NOT IN ('EXTERNAL', 'FORMULA')
896: THEN
897: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
898: THEN
899: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
900: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
901: fnd_msg_pub.ADD;
897: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
898: THEN
899: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
900: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
901: fnd_msg_pub.ADD;
902: END IF;
903:
904: RAISE fnd_api.g_exc_error;
905: END IF;
913: AND lookup_code = p_plan_element.incentive_type_code;
914:
915: IF (l_tmp_exist = 0)
916: THEN
917: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
918: THEN
919: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
920: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_incentive_type_code);
921: fnd_msg_pub.ADD;
917: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
918: THEN
919: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
920: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_incentive_type_code);
921: fnd_msg_pub.ADD;
922: END IF;
923:
924: RAISE fnd_api.g_exc_error;
925: END IF;
932: AND lookup_code = p_plan_element.payment_group_code;
933:
934: IF (l_tmp_exist = 0)
935: THEN
936: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
937: THEN
938: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
939: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYMENT_GROUP', 'PE_OBJECT_TYPE'));
940: fnd_msg_pub.ADD;
936: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
937: THEN
938: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
939: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYMENT_GROUP', 'PE_OBJECT_TYPE'));
940: fnd_msg_pub.ADD;
941: END IF;
942:
943: RAISE fnd_api.g_exc_error;
944: END IF;
950: WHERE lookup_type = 'QUOTA_GROUP_CODE' AND lookup_code = p_plan_element.quota_group_code;
951: EXCEPTION
952: WHEN NO_DATA_FOUND
953: THEN
954: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
955: THEN
956: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
957: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('QUOTA_GROUP', 'PE_OBJECT_TYPE'));
958: fnd_msg_pub.ADD;
954: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
955: THEN
956: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
957: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('QUOTA_GROUP', 'PE_OBJECT_TYPE'));
958: fnd_msg_pub.ADD;
959: END IF;
960:
961: RAISE fnd_api.g_exc_error;
962: WHEN OTHERS
971: WHERE lookup_type = 'PLAN_ELEMENT_STATUS_TYPE' AND lookup_code = p_plan_element.quota_status;
972: EXCEPTION
973: WHEN NO_DATA_FOUND
974: THEN
975: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
976: THEN
977: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
978: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('STATUS', 'PE_OBJECT_TYPE'));
979: fnd_msg_pub.ADD;
975: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
976: THEN
977: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
978: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('STATUS', 'PE_OBJECT_TYPE'));
979: fnd_msg_pub.ADD;
980: END IF;
981:
982: RAISE fnd_api.g_exc_error;
983: WHEN OTHERS
994: AND lookup_code = p_plan_element.indirect_credit_code;
995:
996: IF (l_tmp_exist = 0)
997: THEN
998: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
999: THEN
1000: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1001: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('INDIRECT_CREDIT_TYPE', 'PE_OBJECT_TYPE'));
1002: fnd_msg_pub.ADD;
998: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
999: THEN
1000: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1001: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('INDIRECT_CREDIT_TYPE', 'PE_OBJECT_TYPE'));
1002: fnd_msg_pub.ADD;
1003: END IF;
1004:
1005: RAISE fnd_api.g_exc_error;
1006: END IF;
1042: WHERE credit_type_id = p_plan_element.credit_type_id AND org_id = p_plan_element.org_id;
1043:
1044: IF (l_tmp_exist = 0)
1045: THEN
1046: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1047: THEN
1048: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1049: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('CREDIT_TYPE', 'PE_OBJECT_TYPE'));
1050: fnd_msg_pub.ADD;
1046: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1047: THEN
1048: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1049: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('CREDIT_TYPE', 'PE_OBJECT_TYPE'));
1050: fnd_msg_pub.ADD;
1051: END IF;
1052:
1053: RAISE fnd_api.g_exc_error;
1054: END IF;
1063:
1064: -- FROM:chk_pe_required Check interval_type_id can not be missing or NULL
1065: IF (l_tmp_exist = 0)
1066: THEN
1067: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1068: THEN
1069: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1070: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PERIOD_TYPE', 'PE_OBJECT_TYPE'));
1071: fnd_msg_pub.ADD;
1067: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1068: THEN
1069: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1070: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PERIOD_TYPE', 'PE_OBJECT_TYPE'));
1071: fnd_msg_pub.ADD;
1072: END IF;
1073:
1074: RAISE fnd_api.g_exc_error;
1075: END IF;
1082: END IF;
1083:
1084: IF (p_plan_element.credit_type_id IS NULL)
1085: THEN
1086: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1087: THEN
1088: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1089: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('CREDIT_TYPE', 'PE_OBJECT_TYPE'));
1090: fnd_msg_pub.ADD;
1086: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1087: THEN
1088: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1089: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('CREDIT_TYPE', 'PE_OBJECT_TYPE'));
1090: fnd_msg_pub.ADD;
1091: END IF;
1092:
1093: RAISE fnd_api.g_exc_error;
1094: END IF;
1095:
1096: -- FROM:chk_pe_required Check interval_type_id can not be missing or NULL
1097: IF (p_plan_element.interval_type_id IS NULL)
1098: THEN
1099: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1100: THEN
1101: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1102: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PERIOD_TYPE', 'PE_OBJECT_TYPE'));
1103: fnd_msg_pub.ADD;
1099: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1100: THEN
1101: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1102: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PERIOD_TYPE', 'PE_OBJECT_TYPE'));
1103: fnd_msg_pub.ADD;
1104: END IF;
1105:
1106: RAISE fnd_api.g_exc_error;
1107: END IF;
1107: END IF;
1108:
1109: IF (p_plan_element.calc_formula_id IS NULL AND p_plan_element.quota_type_code = 'FORMULA')
1110: THEN
1111: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1112: THEN
1113: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1114: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('FORMULA', 'QUOTA_TYPE'));
1115: fnd_msg_pub.ADD;
1111: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1112: THEN
1113: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1114: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('FORMULA', 'QUOTA_TYPE'));
1115: fnd_msg_pub.ADD;
1116: END IF;
1117:
1118: RAISE fnd_api.g_exc_error;
1119: END IF;
1205: CLOSE ccid_cur;
1206:
1207: IF (l_count = 0 AND p_account_type = 'L')
1208: THEN
1209: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1210: THEN
1211: -- Need to define message 'CN_E_CANNOT_REF_ITSEF' in SEED115
1212: fnd_message.set_name ('CN', 'CN_INV_ACC_NO');
1213: fnd_msg_pub.ADD;
1209: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1210: THEN
1211: -- Need to define message 'CN_E_CANNOT_REF_ITSEF' in SEED115
1212: fnd_message.set_name ('CN', 'CN_INV_ACC_NO');
1213: fnd_msg_pub.ADD;
1214: END IF;
1215:
1216: RAISE fnd_api.g_exc_error;
1217: END IF;
1217: END IF;
1218:
1219: IF (l_count = 0 AND p_account_type = 'E')
1220: THEN
1221: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1222: THEN
1223: -- Need to define message 'CN_E_CANNOT_REF_ITSEF' in SEED115
1224: fnd_message.set_name ('CN', 'CN_INV_ACC_NO');
1225: fnd_msg_pub.ADD;
1221: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1222: THEN
1223: -- Need to define message 'CN_E_CANNOT_REF_ITSEF' in SEED115
1224: fnd_message.set_name ('CN', 'CN_INV_ACC_NO');
1225: fnd_msg_pub.ADD;
1226: END IF;
1227:
1228: RAISE fnd_api.g_exc_error;
1229: END IF;
1298: WHERE code_combination_id = p_plan_element.liability_account_id AND account_type = 'L';
1299: EXCEPTION
1300: WHEN NO_DATA_FOUND
1301: THEN
1302: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1303: THEN
1304: fnd_message.set_name ('CN', 'CN_IMP_INVLD_LIABLTY_CODE');
1305: fnd_msg_pub.ADD;
1306: END IF;
1301: THEN
1302: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1303: THEN
1304: fnd_message.set_name ('CN', 'CN_IMP_INVLD_LIABLTY_CODE');
1305: fnd_msg_pub.ADD;
1306: END IF;
1307:
1308: RAISE fnd_api.g_exc_error;
1309: END;
1326: WHERE code_combination_id = p_plan_element.expense_account_id AND account_type = 'E';
1327: EXCEPTION
1328: WHEN NO_DATA_FOUND
1329: THEN
1330: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1331: THEN
1332: fnd_message.set_name ('CN', 'CN_IMP_INVLD_EXPENS_CODE');
1333: fnd_msg_pub.ADD;
1334: END IF;
1329: THEN
1330: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1331: THEN
1332: fnd_message.set_name ('CN', 'CN_IMP_INVLD_EXPENS_CODE');
1333: fnd_msg_pub.ADD;
1334: END IF;
1335:
1336: RAISE fnd_api.g_exc_error;
1337: END;
1397:
1398: -- Initialize message list if p_init_msg_list is set to TRUE.
1399: IF fnd_api.to_boolean (p_init_msg_list)
1400: THEN
1401: fnd_msg_pub.initialize;
1402: END IF;
1403:
1404: -- Initialize API return status to success
1405: x_return_status := fnd_api.g_ret_sts_success;
1525: COMMIT WORK;
1526: END IF;
1527:
1528: -- Standard call to get message count and if count is 1, get message info.
1529: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1530: EXCEPTION
1531: WHEN fnd_api.g_exc_error
1532: THEN
1533: ROLLBACK TO create_plan_element;
1531: WHEN fnd_api.g_exc_error
1532: THEN
1533: ROLLBACK TO create_plan_element;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1536: WHEN fnd_api.g_exc_unexpected_error
1537: THEN
1538: ROLLBACK TO create_plan_element;
1539: x_return_status := fnd_api.g_ret_sts_unexp_error;
1536: WHEN fnd_api.g_exc_unexpected_error
1537: THEN
1538: ROLLBACK TO create_plan_element;
1539: x_return_status := fnd_api.g_ret_sts_unexp_error;
1540: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1541: WHEN OTHERS
1542: THEN
1543: ROLLBACK TO create_plan_element;
1544: x_return_status := fnd_api.g_ret_sts_unexp_error;
1542: THEN
1543: ROLLBACK TO create_plan_element;
1544: x_return_status := fnd_api.g_ret_sts_unexp_error;
1545:
1546: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1547: THEN
1548: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1549: END IF;
1550:
1544: x_return_status := fnd_api.g_ret_sts_unexp_error;
1545:
1546: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1547: THEN
1548: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1549: END IF;
1550:
1551: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1552: END create_plan_element;
1547: THEN
1548: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1549: END IF;
1550:
1551: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1552: END create_plan_element;
1553:
1554: -- Start of comments
1555: -- API name : Update_Plan_Element
1689:
1690: -- Initialize message list if p_init_msg_list is set to TRUE.
1691: IF fnd_api.to_boolean (p_init_msg_list)
1692: THEN
1693: fnd_msg_pub.initialize;
1694: END IF;
1695:
1696: -- Initialize API return status to success
1697: x_return_status := fnd_api.g_ret_sts_success;
1975: COMMIT WORK;
1976: END IF;
1977:
1978: -- Standard call to get message count and if count is 1, get message info.
1979: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1980: EXCEPTION
1981: WHEN fnd_api.g_exc_error
1982: THEN
1983: ROLLBACK TO update_plan_element;
1981: WHEN fnd_api.g_exc_error
1982: THEN
1983: ROLLBACK TO update_plan_element;
1984: x_return_status := fnd_api.g_ret_sts_error;
1985: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1986: WHEN fnd_api.g_exc_unexpected_error
1987: THEN
1988: ROLLBACK TO update_plan_element;
1989: x_return_status := fnd_api.g_ret_sts_unexp_error;
1986: WHEN fnd_api.g_exc_unexpected_error
1987: THEN
1988: ROLLBACK TO update_plan_element;
1989: x_return_status := fnd_api.g_ret_sts_unexp_error;
1990: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1991: WHEN OTHERS
1992: THEN
1993: ROLLBACK TO update_plan_element;
1994: x_return_status := fnd_api.g_ret_sts_unexp_error;
1992: THEN
1993: ROLLBACK TO update_plan_element;
1994: x_return_status := fnd_api.g_ret_sts_unexp_error;
1995:
1996: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1997: THEN
1998: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1999: END IF;
2000:
1994: x_return_status := fnd_api.g_ret_sts_unexp_error;
1995:
1996: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1997: THEN
1998: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1999: END IF;
2000:
2001: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2002: END update_plan_element;
1997: THEN
1998: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1999: END IF;
2000:
2001: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2002: END update_plan_element;
2003:
2004: -- Start of comments
2005: -- API name : Delete_Plan_Element
2048:
2049: -- Initialize message list if p_init_msg_list is set to TRUE.
2050: IF fnd_api.to_boolean (p_init_msg_list)
2051: THEN
2052: fnd_msg_pub.initialize;
2053: END IF;
2054:
2055: -- Initialize API return status to success
2056: x_return_status := fnd_api.g_ret_sts_success;
2098: COMMIT WORK;
2099: END IF;
2100:
2101: -- Standard call to get message count and if count is 1, get message info.
2102: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2103: EXCEPTION
2104: WHEN fnd_api.g_exc_error
2105: THEN
2106: ROLLBACK TO delete_plan_element;
2104: WHEN fnd_api.g_exc_error
2105: THEN
2106: ROLLBACK TO delete_plan_element;
2107: x_return_status := fnd_api.g_ret_sts_error;
2108: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2109: WHEN fnd_api.g_exc_unexpected_error
2110: THEN
2111: ROLLBACK TO delete_plan_element;
2112: x_return_status := fnd_api.g_ret_sts_unexp_error;
2109: WHEN fnd_api.g_exc_unexpected_error
2110: THEN
2111: ROLLBACK TO delete_plan_element;
2112: x_return_status := fnd_api.g_ret_sts_unexp_error;
2113: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2114: WHEN OTHERS
2115: THEN
2116: ROLLBACK TO delete_plan_element;
2117: x_return_status := fnd_api.g_ret_sts_unexp_error;
2115: THEN
2116: ROLLBACK TO delete_plan_element;
2117: x_return_status := fnd_api.g_ret_sts_unexp_error;
2118:
2119: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2120: THEN
2121: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2122: END IF;
2123:
2117: x_return_status := fnd_api.g_ret_sts_unexp_error;
2118:
2119: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2120: THEN
2121: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2122: END IF;
2123:
2124: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2125: END delete_plan_element;
2120: THEN
2121: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2122: END IF;
2123:
2124: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2125: END delete_plan_element;
2126:
2127: -- Start of comments
2128: -- API name : Validate_Plan_Element
2188:
2189: -- Initialize message list if p_init_msg_list is set to TRUE.
2190: IF fnd_api.to_boolean (p_init_msg_list)
2191: THEN
2192: fnd_msg_pub.initialize;
2193: END IF;
2194:
2195: -- Initialize API return status to success
2196: x_return_status := fnd_api.g_ret_sts_success;
2207: WHERE quota_id = p_plan_element.quota_id;
2208:
2209: IF l_temp_count = 0
2210: THEN
2211: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2212: THEN
2213: fnd_message.set_name ('CN', 'CN_INVALID_DEL_REC');
2214: fnd_msg_pub.ADD;
2215: END IF;
2210: THEN
2211: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2212: THEN
2213: fnd_message.set_name ('CN', 'CN_INVALID_DEL_REC');
2214: fnd_msg_pub.ADD;
2215: END IF;
2216:
2217: RAISE fnd_api.g_exc_error;
2218: END IF;
2227: WHERE quota_id = p_plan_element.quota_id);
2228: EXCEPTION
2229: WHEN NO_DATA_FOUND
2230: THEN
2231: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2232: THEN
2233: fnd_message.set_name ('CN', 'PLN_QUOTA_DELETE_NA');
2234: fnd_msg_pub.ADD;
2235: END IF;
2230: THEN
2231: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2232: THEN
2233: fnd_message.set_name ('CN', 'PLN_QUOTA_DELETE_NA');
2234: fnd_msg_pub.ADD;
2235: END IF;
2236: RAISE fnd_api.g_exc_error;
2237: END;
2238: ELSE
2247:
2248: -- 1. check object version number
2249: IF p_old_plan_element.object_version_number <> p_plan_element.object_version_number
2250: THEN
2251: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2252: THEN
2253: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
2254: fnd_msg_pub.ADD;
2255: END IF;
2250: THEN
2251: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2252: THEN
2253: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
2254: fnd_msg_pub.ADD;
2255: END IF;
2256:
2257: RAISE fnd_api.g_exc_error;
2258: END IF;
2264: WHERE NAME = p_plan_element.NAME AND p_plan_element.quota_id <> pe.quota_id AND p_plan_element.org_id = pe.org_id AND delete_flag = 'N';
2265:
2266: IF l_temp_count <> 0
2267: THEN
2268: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2269: THEN
2270: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
2271: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2272: fnd_msg_pub.ADD;
2268: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2269: THEN
2270: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
2271: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2272: fnd_msg_pub.ADD;
2273: END IF;
2274:
2275: RAISE fnd_api.g_exc_error;
2276: END IF;
2286: CLOSE uplift_curs;
2287:
2288: IF l_uplift_dt_range > 0
2289: THEN
2290: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2291: THEN
2292: fnd_message.set_name ('CN', 'CN_UPLIFT_DT_NOT_WIN_QUOTA');
2293: fnd_msg_pub.ADD;
2294: END IF;
2289: THEN
2290: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2291: THEN
2292: fnd_message.set_name ('CN', 'CN_UPLIFT_DT_NOT_WIN_QUOTA');
2293: fnd_msg_pub.ADD;
2294: END IF;
2295: RAISE fnd_api.g_exc_error;
2296: END IF;
2297:
2310: WHERE NAME = p_plan_element.NAME AND org_id = p_plan_element.org_id AND delete_flag = 'N';
2311:
2312: IF l_temp_count <> 0
2313: THEN
2314: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2315: THEN
2316: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
2317: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2318: fnd_msg_pub.ADD;
2314: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2315: THEN
2316: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
2317: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2318: fnd_msg_pub.ADD;
2319: END IF;
2320:
2321: RAISE fnd_api.g_exc_error;
2322: END IF;
2328:
2329: -- 1. name can not be null
2330: IF (p_plan_element.NAME IS NULL) OR (p_plan_element.NAME = fnd_api.g_miss_char)
2331: THEN
2332: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2333: THEN
2334: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2335: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2336: fnd_msg_pub.ADD;
2332: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2333: THEN
2334: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2335: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2336: fnd_msg_pub.ADD;
2337: END IF;
2338:
2339: RAISE fnd_api.g_exc_error;
2340: END IF;
2341:
2342: -- start date is not null
2343: IF (p_plan_element.start_date IS NULL) OR (p_plan_element.start_date = fnd_api.g_miss_date)
2344: THEN
2345: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2346: THEN
2347: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2348: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
2349: fnd_msg_pub.ADD;
2345: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2346: THEN
2347: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2348: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
2349: fnd_msg_pub.ADD;
2350: END IF;
2351:
2352: RAISE fnd_api.g_exc_error;
2353: END IF;
2354:
2355: -- start date > end date
2356: IF (p_plan_element.end_date IS NOT NULL) AND (p_plan_element.start_date > p_plan_element.end_date)
2357: THEN
2358: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2359: THEN
2360: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
2361: fnd_msg_pub.ADD;
2362: END IF;
2357: THEN
2358: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2359: THEN
2360: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
2361: fnd_msg_pub.ADD;
2362: END IF;
2363:
2364: RAISE fnd_api.g_exc_error;
2365: END IF;
2374:
2375:
2376: IF (p_plan_element.target IS NULL)
2377: THEN
2378: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2379: THEN
2380: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2381: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2382: fnd_msg_pub.ADD;
2378: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2379: THEN
2380: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2381: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2382: fnd_msg_pub.ADD;
2383: END IF;
2384:
2385: RAISE fnd_api.g_exc_error;
2386: END IF;
2386: END IF;
2387:
2388: IF (p_plan_element.payment_amount IS NULL)
2389: THEN
2390: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2391: THEN
2392: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2393: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2394: fnd_msg_pub.ADD;
2390: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2391: THEN
2392: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2393: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2394: fnd_msg_pub.ADD;
2395: END IF;
2396:
2397: RAISE fnd_api.g_exc_error;
2398: END IF;
2398: END IF;
2399:
2400: IF (p_plan_element.performance_goal IS NULL)
2401: THEN
2402: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2403: THEN
2404: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2405: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2406: fnd_msg_pub.ADD;
2402: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2403: THEN
2404: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2405: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2406: fnd_msg_pub.ADD;
2407: END IF;
2408:
2409: RAISE fnd_api.g_exc_error;
2410: END IF;
2410: END IF;
2411:
2412: IF (p_plan_element.payee_assign_flag NOT IN ('Y', 'N'))
2413: THEN
2414: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2415: THEN
2416: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
2417: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYEE_ASSIGN', 'PE_OBJECT_TYPE'));
2418: fnd_msg_pub.ADD;
2414: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2415: THEN
2416: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
2417: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYEE_ASSIGN', 'PE_OBJECT_TYPE'));
2418: fnd_msg_pub.ADD;
2419: END IF;
2420:
2421: RAISE fnd_api.g_exc_error;
2422: END IF;
2422: END IF;
2423:
2424: IF p_plan_element.addup_from_rev_class_flag NOT IN ('Y', 'N')
2425: THEN
2426: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2427: THEN
2428: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
2429: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('ADD_FROM_REVCLASS', 'PE_OBJECT_TYPE'));
2430: fnd_msg_pub.ADD;
2426: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2427: THEN
2428: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
2429: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('ADD_FROM_REVCLASS', 'PE_OBJECT_TYPE'));
2430: fnd_msg_pub.ADD;
2431: END IF;
2432:
2433: RAISE fnd_api.g_exc_error;
2434: END IF;
2449:
2450: IF (l_payeechk > 0)
2451: THEN
2452: fnd_message.set_name ('CN', 'CN_PAYEE_ASGN_FLAG_CHECK');
2453: fnd_msg_pub.ADD;
2454: RAISE fnd_api.g_exc_error;
2455: END IF;
2456: END IF;
2457: END IF; -- END OF DELETE VALIDATION
2458:
2459: -- End of API body.
2460: <
2461: -- Standard call to get message count and if count is 1, get message info.
2462: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2463: EXCEPTION
2464: WHEN fnd_api.g_exc_error
2465: THEN
2466: ROLLBACK TO validate_plan_element;
2464: WHEN fnd_api.g_exc_error
2465: THEN
2466: ROLLBACK TO validate_plan_element;
2467: x_return_status := fnd_api.g_ret_sts_error;
2468: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2469: WHEN fnd_api.g_exc_unexpected_error
2470: THEN
2471: ROLLBACK TO validate_plan_element;
2472: x_return_status := fnd_api.g_ret_sts_unexp_error;
2469: WHEN fnd_api.g_exc_unexpected_error
2470: THEN
2471: ROLLBACK TO validate_plan_element;
2472: x_return_status := fnd_api.g_ret_sts_unexp_error;
2473: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2474: WHEN OTHERS
2475: THEN
2476: ROLLBACK TO validate_plan_element;
2477: x_return_status := fnd_api.g_ret_sts_unexp_error;
2475: THEN
2476: ROLLBACK TO validate_plan_element;
2477: x_return_status := fnd_api.g_ret_sts_unexp_error;
2478:
2479: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2480: THEN
2481: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2482: END IF;
2483:
2477: x_return_status := fnd_api.g_ret_sts_unexp_error;
2478:
2479: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2480: THEN
2481: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2482: END IF;
2483:
2484: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2485: END validate_plan_element;
2480: THEN
2481: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2482: END IF;
2483:
2484: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2485: END validate_plan_element;
2486:
2487: -- Start of comments
2488: -- API name : Duplicate_Plan_Element
2590: token_name4 => NULL,
2591: token_value4 => NULL,
2592: TRANSLATE => TRUE
2593: );
2594: fnd_msg_pub.ADD;
2595: END IF;
2596: END IF;
2597: END LOOP;
2598: END LOOP;
2670:
2671: -- Initialize message list if p_init_msg_list is set to TRUE.
2672: IF fnd_api.to_boolean (p_init_msg_list)
2673: THEN
2674: fnd_msg_pub.initialize;
2675: END IF;
2676:
2677: -- Initialize API return status to success
2678: x_return_status := fnd_api.g_ret_sts_success;
2848: COMMIT WORK;
2849: END IF;
2850:
2851: -- Standard call to get message count and if count is 1, get message info.
2852: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2853: EXCEPTION
2854: WHEN fnd_api.g_exc_error
2855: THEN
2856: ROLLBACK TO validate_plan_element_2;
2855: THEN
2856: ROLLBACK TO validate_plan_element_2;
2857: x_return_status := fnd_api.g_ret_sts_error;
2858: x_status_code := g_incomplete;
2859: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2860: WHEN fnd_api.g_exc_unexpected_error
2861: THEN
2862: ROLLBACK TO validate_plan_element_2;
2863: x_return_status := fnd_api.g_ret_sts_unexp_error;
2861: THEN
2862: ROLLBACK TO validate_plan_element_2;
2863: x_return_status := fnd_api.g_ret_sts_unexp_error;
2864: x_status_code := g_incomplete;
2865: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2866: WHEN OTHERS
2867: THEN
2868: ROLLBACK TO validate_plan_element_2;
2869: x_return_status := fnd_api.g_ret_sts_unexp_error;
2868: ROLLBACK TO validate_plan_element_2;
2869: x_return_status := fnd_api.g_ret_sts_unexp_error;
2870: x_status_code := g_incomplete;
2871:
2872: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2873: THEN
2874: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2875: END IF;
2876:
2870: x_status_code := g_incomplete;
2871:
2872: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2873: THEN
2874: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2875: END IF;
2876:
2877: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2878: END validate_plan_element;
2873: THEN
2874: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2875: END IF;
2876:
2877: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2878: END validate_plan_element;
2879: END cn_plan_element_pvt;