[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;
1951: COMMIT WORK;
1952: END IF;
1953:
1954: -- Standard call to get message count and if count is 1, get message info.
1955: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1956: EXCEPTION
1957: WHEN fnd_api.g_exc_error
1958: THEN
1959: ROLLBACK TO update_plan_element;
1957: WHEN fnd_api.g_exc_error
1958: THEN
1959: ROLLBACK TO update_plan_element;
1960: x_return_status := fnd_api.g_ret_sts_error;
1961: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1962: WHEN fnd_api.g_exc_unexpected_error
1963: THEN
1964: ROLLBACK TO update_plan_element;
1965: x_return_status := fnd_api.g_ret_sts_unexp_error;
1962: WHEN fnd_api.g_exc_unexpected_error
1963: THEN
1964: ROLLBACK TO update_plan_element;
1965: x_return_status := fnd_api.g_ret_sts_unexp_error;
1966: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1967: WHEN OTHERS
1968: THEN
1969: ROLLBACK TO update_plan_element;
1970: x_return_status := fnd_api.g_ret_sts_unexp_error;
1968: THEN
1969: ROLLBACK TO update_plan_element;
1970: x_return_status := fnd_api.g_ret_sts_unexp_error;
1971:
1972: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1973: THEN
1974: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1975: END IF;
1976:
1970: x_return_status := fnd_api.g_ret_sts_unexp_error;
1971:
1972: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1973: THEN
1974: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1975: END IF;
1976:
1977: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1978: END update_plan_element;
1973: THEN
1974: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1975: END IF;
1976:
1977: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1978: END update_plan_element;
1979:
1980: -- Start of comments
1981: -- API name : Delete_Plan_Element
2024:
2025: -- Initialize message list if p_init_msg_list is set to TRUE.
2026: IF fnd_api.to_boolean (p_init_msg_list)
2027: THEN
2028: fnd_msg_pub.initialize;
2029: END IF;
2030:
2031: -- Initialize API return status to success
2032: x_return_status := fnd_api.g_ret_sts_success;
2074: COMMIT WORK;
2075: END IF;
2076:
2077: -- Standard call to get message count and if count is 1, get message info.
2078: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2079: EXCEPTION
2080: WHEN fnd_api.g_exc_error
2081: THEN
2082: ROLLBACK TO delete_plan_element;
2080: WHEN fnd_api.g_exc_error
2081: THEN
2082: ROLLBACK TO delete_plan_element;
2083: x_return_status := fnd_api.g_ret_sts_error;
2084: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2085: WHEN fnd_api.g_exc_unexpected_error
2086: THEN
2087: ROLLBACK TO delete_plan_element;
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2085: WHEN fnd_api.g_exc_unexpected_error
2086: THEN
2087: ROLLBACK TO delete_plan_element;
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2090: WHEN OTHERS
2091: THEN
2092: ROLLBACK TO delete_plan_element;
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;
2091: THEN
2092: ROLLBACK TO delete_plan_element;
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;
2094:
2095: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2096: THEN
2097: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2098: END IF;
2099:
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;
2094:
2095: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2096: THEN
2097: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2098: END IF;
2099:
2100: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2101: END delete_plan_element;
2096: THEN
2097: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2098: END IF;
2099:
2100: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2101: END delete_plan_element;
2102:
2103: -- Start of comments
2104: -- API name : Validate_Plan_Element
2164:
2165: -- Initialize message list if p_init_msg_list is set to TRUE.
2166: IF fnd_api.to_boolean (p_init_msg_list)
2167: THEN
2168: fnd_msg_pub.initialize;
2169: END IF;
2170:
2171: -- Initialize API return status to success
2172: x_return_status := fnd_api.g_ret_sts_success;
2183: WHERE quota_id = p_plan_element.quota_id;
2184:
2185: IF l_temp_count = 0
2186: THEN
2187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2188: THEN
2189: fnd_message.set_name ('CN', 'CN_INVALID_DEL_REC');
2190: fnd_msg_pub.ADD;
2191: END IF;
2186: THEN
2187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2188: THEN
2189: fnd_message.set_name ('CN', 'CN_INVALID_DEL_REC');
2190: fnd_msg_pub.ADD;
2191: END IF;
2192:
2193: RAISE fnd_api.g_exc_error;
2194: END IF;
2203: WHERE quota_id = p_plan_element.quota_id);
2204: EXCEPTION
2205: WHEN NO_DATA_FOUND
2206: THEN
2207: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2208: THEN
2209: fnd_message.set_name ('CN', 'PLN_QUOTA_DELETE_NA');
2210: fnd_msg_pub.ADD;
2211: END IF;
2206: THEN
2207: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2208: THEN
2209: fnd_message.set_name ('CN', 'PLN_QUOTA_DELETE_NA');
2210: fnd_msg_pub.ADD;
2211: END IF;
2212: RAISE fnd_api.g_exc_error;
2213: END;
2214: ELSE
2223:
2224: -- 1. check object version number
2225: IF p_old_plan_element.object_version_number <> p_plan_element.object_version_number
2226: THEN
2227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2228: THEN
2229: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
2230: fnd_msg_pub.ADD;
2231: END IF;
2226: THEN
2227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2228: THEN
2229: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
2230: fnd_msg_pub.ADD;
2231: END IF;
2232:
2233: RAISE fnd_api.g_exc_error;
2234: END IF;
2240: 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';
2241:
2242: IF l_temp_count <> 0
2243: THEN
2244: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2245: THEN
2246: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
2247: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2248: fnd_msg_pub.ADD;
2244: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2245: THEN
2246: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
2247: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2248: fnd_msg_pub.ADD;
2249: END IF;
2250:
2251: RAISE fnd_api.g_exc_error;
2252: END IF;
2262: CLOSE uplift_curs;
2263:
2264: IF l_uplift_dt_range > 0
2265: THEN
2266: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2267: THEN
2268: fnd_message.set_name ('CN', 'CN_UPLIFT_DT_NOT_WIN_QUOTA');
2269: fnd_msg_pub.ADD;
2270: END IF;
2265: THEN
2266: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2267: THEN
2268: fnd_message.set_name ('CN', 'CN_UPLIFT_DT_NOT_WIN_QUOTA');
2269: fnd_msg_pub.ADD;
2270: END IF;
2271: RAISE fnd_api.g_exc_error;
2272: END IF;
2273:
2286: WHERE NAME = p_plan_element.NAME AND org_id = p_plan_element.org_id AND delete_flag = 'N';
2287:
2288: IF l_temp_count <> 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_INPUT_MUST_UNIQUE');
2293: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2294: fnd_msg_pub.ADD;
2290: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2291: THEN
2292: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
2293: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2294: fnd_msg_pub.ADD;
2295: END IF;
2296:
2297: RAISE fnd_api.g_exc_error;
2298: END IF;
2304:
2305: -- 1. name can not be null
2306: IF (p_plan_element.NAME IS NULL) OR (p_plan_element.NAME = fnd_api.g_miss_char)
2307: THEN
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2309: THEN
2310: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2311: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2312: fnd_msg_pub.ADD;
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2309: THEN
2310: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2311: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2312: fnd_msg_pub.ADD;
2313: END IF;
2314:
2315: RAISE fnd_api.g_exc_error;
2316: END IF;
2317:
2318: -- start date is not null
2319: IF (p_plan_element.start_date IS NULL) OR (p_plan_element.start_date = fnd_api.g_miss_date)
2320: THEN
2321: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2322: THEN
2323: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2324: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
2325: fnd_msg_pub.ADD;
2321: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2322: THEN
2323: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2324: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
2325: fnd_msg_pub.ADD;
2326: END IF;
2327:
2328: RAISE fnd_api.g_exc_error;
2329: END IF;
2330:
2331: -- start date > end date
2332: IF (p_plan_element.end_date IS NOT NULL) AND (p_plan_element.start_date > p_plan_element.end_date)
2333: THEN
2334: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2335: THEN
2336: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
2337: fnd_msg_pub.ADD;
2338: END IF;
2333: THEN
2334: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2335: THEN
2336: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
2337: fnd_msg_pub.ADD;
2338: END IF;
2339:
2340: RAISE fnd_api.g_exc_error;
2341: END IF;
2350:
2351:
2352: IF (p_plan_element.target IS NULL)
2353: THEN
2354: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2355: THEN
2356: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2357: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2358: fnd_msg_pub.ADD;
2354: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2355: THEN
2356: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2357: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2358: fnd_msg_pub.ADD;
2359: END IF;
2360:
2361: RAISE fnd_api.g_exc_error;
2362: END IF;
2362: END IF;
2363:
2364: IF (p_plan_element.payment_amount IS NULL)
2365: THEN
2366: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2367: THEN
2368: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2369: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2370: fnd_msg_pub.ADD;
2366: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2367: THEN
2368: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2369: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2370: fnd_msg_pub.ADD;
2371: END IF;
2372:
2373: RAISE fnd_api.g_exc_error;
2374: END IF;
2374: END IF;
2375:
2376: IF (p_plan_element.performance_goal 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.payee_assign_flag NOT IN ('Y', 'N'))
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_INVALID_DATA');
2393: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYEE_ASSIGN', '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_INVALID_DATA');
2393: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYEE_ASSIGN', '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.addup_from_rev_class_flag NOT IN ('Y', 'N')
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_INVALID_DATA');
2405: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('ADD_FROM_REVCLASS', '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_INVALID_DATA');
2405: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('ADD_FROM_REVCLASS', 'PE_OBJECT_TYPE'));
2406: fnd_msg_pub.ADD;
2407: END IF;
2408:
2409: RAISE fnd_api.g_exc_error;
2410: END IF;
2425:
2426: IF (l_payeechk > 0)
2427: THEN
2428: fnd_message.set_name ('CN', 'CN_PAYEE_ASGN_FLAG_CHECK');
2429: fnd_msg_pub.ADD;
2430: RAISE fnd_api.g_exc_error;
2431: END IF;
2432: END IF;
2433: END IF; -- END OF DELETE VALIDATION
2434:
2435: -- End of API body.
2436: <
2437: -- Standard call to get message count and if count is 1, get message info.
2438: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2439: EXCEPTION
2440: WHEN fnd_api.g_exc_error
2441: THEN
2442: ROLLBACK TO validate_plan_element;
2440: WHEN fnd_api.g_exc_error
2441: THEN
2442: ROLLBACK TO validate_plan_element;
2443: x_return_status := fnd_api.g_ret_sts_error;
2444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2445: WHEN fnd_api.g_exc_unexpected_error
2446: THEN
2447: ROLLBACK TO validate_plan_element;
2448: x_return_status := fnd_api.g_ret_sts_unexp_error;
2445: WHEN fnd_api.g_exc_unexpected_error
2446: THEN
2447: ROLLBACK TO validate_plan_element;
2448: x_return_status := fnd_api.g_ret_sts_unexp_error;
2449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2450: WHEN OTHERS
2451: THEN
2452: ROLLBACK TO validate_plan_element;
2453: x_return_status := fnd_api.g_ret_sts_unexp_error;
2451: THEN
2452: ROLLBACK TO validate_plan_element;
2453: x_return_status := fnd_api.g_ret_sts_unexp_error;
2454:
2455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2456: THEN
2457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2458: END IF;
2459:
2453: x_return_status := fnd_api.g_ret_sts_unexp_error;
2454:
2455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2456: THEN
2457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2458: END IF;
2459:
2460: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2461: END validate_plan_element;
2456: THEN
2457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2458: END IF;
2459:
2460: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2461: END validate_plan_element;
2462:
2463: -- Start of comments
2464: -- API name : Duplicate_Plan_Element
2566: token_name4 => NULL,
2567: token_value4 => NULL,
2568: TRANSLATE => TRUE
2569: );
2570: fnd_msg_pub.ADD;
2571: END IF;
2572: END IF;
2573: END LOOP;
2574: END LOOP;
2646:
2647: -- Initialize message list if p_init_msg_list is set to TRUE.
2648: IF fnd_api.to_boolean (p_init_msg_list)
2649: THEN
2650: fnd_msg_pub.initialize;
2651: END IF;
2652:
2653: -- Initialize API return status to success
2654: x_return_status := fnd_api.g_ret_sts_success;
2824: COMMIT WORK;
2825: END IF;
2826:
2827: -- Standard call to get message count and if count is 1, get message info.
2828: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2829: EXCEPTION
2830: WHEN fnd_api.g_exc_error
2831: THEN
2832: ROLLBACK TO validate_plan_element_2;
2831: THEN
2832: ROLLBACK TO validate_plan_element_2;
2833: x_return_status := fnd_api.g_ret_sts_error;
2834: x_status_code := g_incomplete;
2835: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2836: WHEN fnd_api.g_exc_unexpected_error
2837: THEN
2838: ROLLBACK TO validate_plan_element_2;
2839: x_return_status := fnd_api.g_ret_sts_unexp_error;
2837: THEN
2838: ROLLBACK TO validate_plan_element_2;
2839: x_return_status := fnd_api.g_ret_sts_unexp_error;
2840: x_status_code := g_incomplete;
2841: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2842: WHEN OTHERS
2843: THEN
2844: ROLLBACK TO validate_plan_element_2;
2845: x_return_status := fnd_api.g_ret_sts_unexp_error;
2844: ROLLBACK TO validate_plan_element_2;
2845: x_return_status := fnd_api.g_ret_sts_unexp_error;
2846: x_status_code := g_incomplete;
2847:
2848: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2849: THEN
2850: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2851: END IF;
2852:
2846: x_status_code := g_incomplete;
2847:
2848: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2849: THEN
2850: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2851: END IF;
2852:
2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2854: END validate_plan_element;
2849: THEN
2850: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2851: END IF;
2852:
2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2854: END validate_plan_element;
2855: END cn_plan_element_pvt;