76: AND ( start_date < x_start_date
77: OR end_date > x_end_date);
78:
79: if x_dummy > 0 then
80: fnd_message.set_name('CN','PLN_PLAN_PRD_LT_SRP_PRD');
81: fnd_msg_pub.add;
82: return false;
83: end if;
84: return true;
158: FETCH check_overlap_curs INTO x_rev_class_total, x_rev_class_total_unique;
159: CLOSE check_overlap_curs;
160:
161: IF x_rev_class_total <> x_rev_class_total_unique THEN
162: fnd_message.set_name('CN', 'PLN_PLAN_DUP_REV_CLASS');
163: fnd_message.set_token('PLAN_NAME',
164: get_plan_name(x_comp_plan_id));
165: fnd_msg_pub.add;
166: return false;
159: CLOSE check_overlap_curs;
160:
161: IF x_rev_class_total <> x_rev_class_total_unique THEN
162: fnd_message.set_name('CN', 'PLN_PLAN_DUP_REV_CLASS');
163: fnd_message.set_token('PLAN_NAME',
164: get_plan_name(x_comp_plan_id));
165: fnd_msg_pub.add;
166: return false;
167: END IF;
190: FROM cn_srp_plan_assigns
191: WHERE comp_plan_id = x_comp_plan_id;
192:
193: if x_dummy > 0 then
194: fnd_message.set_name('CN', 'PLN_PLAN_DELETE_NA');
195: fnd_msg_pub.add;
196: return false;
197: end if;
198:
201: FROM cn_role_plans
202: WHERE comp_plan_id = x_comp_plan_id;
203:
204: if x_dummy > 0 then
205: fnd_message.set_name('CN', 'CN_ROLE_PLAN_ASSIGNED');
206: fnd_msg_pub.add;
207: return false;
208: end if;
209: return true;
654: OPEN C;
655: FETCH C INTO Recinfo;
656: IF C%NOTFOUND THEN
657: CLOSE C;
658: fnd_message.set_name('FND','FORM_RECORD_DELETED');
659: app_exception.raise_exception;
660: END IF;
661: CLOSE C;
662: IF (
675: )
676: ) ) THEN
677: RETURN;
678: ELSE
679: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
680: app_exception.raise_exception;
681: END IF;
682:
683: END Lock_Record;
741: AND (X_Comp_Plan_Id IS NULL
742: OR X_Comp_Plan_Id <> comp_plan_id);
743:
744: if x_dummy > 0 then
745: fnd_message.set_name('CN', 'PLN_PLAN_EXISTS');
746: fnd_msg_pub.add;
747: return false;
748: end if;
749: return true;
947: FETCH quotas into quota_rec;
948:
949: IF quotas%rowcount = 0 THEN
950: l_temp_status_code := 'INCOMPLETE';
951: fnd_message.set_name('CN', 'PLN_PLAN_NO_QUOTAS');
952: fnd_message.set_token('PLAN_NAME', get_plan_name(x_comp_plan_id));
953: fnd_msg_pub.add;
954: exit;
955: ELSIF quotas%notfound THEN
948:
949: IF quotas%rowcount = 0 THEN
950: l_temp_status_code := 'INCOMPLETE';
951: fnd_message.set_name('CN', 'PLN_PLAN_NO_QUOTAS');
952: fnd_message.set_token('PLAN_NAME', get_plan_name(x_comp_plan_id));
953: fnd_msg_pub.add;
954: exit;
955: ELSIF quotas%notfound THEN
956: -- at the end of the loop