[Home] [Help]
884: IS
885: --l_api_name CONSTANT VARCHAR2 (30) := 'Valid_Lookup_Code';
886: l_tmp_exist NUMBER := 0;
887: l_temp VARCHAR2 (1000) := NULL;
888: l_plan_element CN_CHK_PLAN_ELEMENT_PKG.pe_rec_type;
889: l_lookup_type CN_LOOKUPS.lookup_type%TYPE;
890: BEGIN
891: -- set the Status
892: x_return_status := fnd_api.g_ret_sts_success;
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;
902: END IF;
903:
904: RAISE fnd_api.g_exc_error;
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;
922: END IF;
923:
924: RAISE fnd_api.g_exc_error;
1029: l_plan_element.addup_from_rev_class_flag := p_plan_element.addup_from_rev_class_flag;
1030: l_plan_element.payee_assign_flag := p_plan_element.payee_assign_flag;
1031: l_plan_element.package_name := p_plan_element.package_name;
1032:
1033: cn_chk_plan_element_pkg.validate_formula (l_plan_element);
1034: END IF;
1035:
1036: --- the following are not validated on a new row
1037: IF (p_plan_element.credit_type_id IS NOT NULL)
1716: IF p_plan_element.calc_formula_id IS NOT NULL
1717: THEN
1718: IF p_plan_element.calc_formula_id = l_old_plan_element.calc_formula_id
1719: THEN
1720: cn_chk_plan_element_pkg.chk_rate_quota_date (x_return_status => x_return_status,
1721: p_start_date => p_plan_element.start_date,
1722: p_end_date => p_plan_element.end_date,
1723: p_quota_name => p_plan_element.NAME,
1724: p_quota_id => p_plan_element.quota_id,