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;
159: FETCH check_overlap_curs INTO x_rev_class_total, x_rev_class_total_unique;
160: CLOSE check_overlap_curs;
161:
162: IF x_rev_class_total <> x_rev_class_total_unique THEN
163: fnd_message.set_name('CN', 'PLN_PLAN_DUP_REV_CLASS');
164: fnd_message.set_token('PLAN_NAME',
165: get_plan_name(x_comp_plan_id));
166: fnd_msg_pub.add;
167: return false;
160: CLOSE check_overlap_curs;
161:
162: IF x_rev_class_total <> x_rev_class_total_unique THEN
163: fnd_message.set_name('CN', 'PLN_PLAN_DUP_REV_CLASS');
164: fnd_message.set_token('PLAN_NAME',
165: get_plan_name(x_comp_plan_id));
166: fnd_msg_pub.add;
167: return false;
168: END IF;
191: FROM cn_srp_plan_assigns
192: WHERE comp_plan_id = x_comp_plan_id;
193:
194: if x_dummy > 0 then
195: fnd_message.set_name('CN', 'PLN_PLAN_DELETE_NA');
196: fnd_msg_pub.add;
197: return false;
198: end if;
199:
202: FROM cn_role_plans
203: WHERE comp_plan_id = x_comp_plan_id;
204:
205: if x_dummy > 0 then
206: fnd_message.set_name('CN', 'CN_ROLE_PLAN_ASSIGNED');
207: fnd_msg_pub.add;
208: return false;
209: end if;
210: return true;
672: OPEN C;
673: FETCH C INTO Recinfo;
674: IF C%NOTFOUND THEN
675: CLOSE C;
676: fnd_message.set_name('FND','FORM_RECORD_DELETED');
677: app_exception.raise_exception;
678: END IF;
679: CLOSE C;
680: IF (
693: )
694: ) ) THEN
695: RETURN;
696: ELSE
697: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
698: app_exception.raise_exception;
699: END IF;
700:
701: END Lock_Record;
759: AND (X_Comp_Plan_Id IS NULL
760: OR X_Comp_Plan_Id <> comp_plan_id);
761:
762: if x_dummy > 0 then
763: fnd_message.set_name('CN', 'PLN_PLAN_EXISTS');
764: fnd_msg_pub.add;
765: return false;
766: end if;
767: return true;
973: FETCH quotas into quota_rec;
974:
975: IF quotas%rowcount = 0 THEN
976: l_temp_status_code := 'INCOMPLETE';
977: fnd_message.set_name('CN', 'PLN_PLAN_NO_QUOTAS');
978: fnd_message.set_token('PLAN_NAME', get_plan_name(x_comp_plan_id));
979: fnd_msg_pub.add;
980: exit;
981: ELSIF quotas%notfound THEN
974:
975: IF quotas%rowcount = 0 THEN
976: l_temp_status_code := 'INCOMPLETE';
977: fnd_message.set_name('CN', 'PLN_PLAN_NO_QUOTAS');
978: fnd_message.set_token('PLAN_NAME', get_plan_name(x_comp_plan_id));
979: fnd_msg_pub.add;
980: exit;
981: ELSIF quotas%notfound THEN
982: -- at the end of the loop