[Home] [Help]
45: OPEN cur_old_ref_values;
46: FETCH cur_old_ref_values INTO old_references;
47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
93: new_references.rsv_org_unit_pri_id,
94: new_references.preference_code
95: )
96: ) THEN
97: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
105: p_message_name VARCHAR2(30);
106: BEGIN
107: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.group_id <> old_references.group_id ) ) THEN
108: IF NOT IGS_PE_PERSID_GROUP_PKG.val_persid_group(new_references.group_id,p_message_name) THEN
109: Fnd_Message.Set_Name('IGS', p_message_name);
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
146: NULL;
147: ELSIF NOT igs_ps_rsv_ogpri_pkg.get_pk_for_validation (
148: new_references.rsv_org_unit_pri_id
149: ) THEN
150: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
151: igs_ge_msg_stack.add;
152: app_exception.raise_exception;
153: ELSE
154: OPEN c_priority;
158: IF NOT igs_ps_ver_pkg.get_pk_for_validation(
159: new_references.preference_code,
160: new_references.preference_version ) THEN
161: CLOSE c_priority;
162: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: ELSE
166: CLOSE c_priority;
168: ELSIF (priority_value1 = 'PROGRAM_STAGE') THEN
169: IF NOT igs_ps_stage_type_pkg.get_pk_for_validation(
170: new_references.preference_code ) THEN
171: CLOSE c_priority;
172: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: ELSE
176: CLOSE c_priority;
179: IF NOT igs_en_unit_set_pkg.get_pk_for_validation(
180: new_references.preference_code,
181: new_references.preference_version ) THEN
182: CLOSE c_priority;
183: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
184: igs_ge_msg_stack.add;
185: app_exception.raise_exception;
186: ELSE
187: CLOSE c_priority;
189: ELSIF (priority_value1 = 'PERSON_GRP') THEN
190: IF NOT igs_pe_persid_group_pkg.get_pk_for_validation(
191: new_references.group_id ) THEN
192: CLOSE c_priority;
193: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
194: igs_ge_msg_stack.add;
195: app_exception.raise_exception;
196: ELSE
197: CLOSE c_priority;
201: FETCH c_check_hz_exists into cur_rec_hz_exists;
202: IF c_check_hz_exists%NotFound THEN
203: CLOSE c_check_hz_exists;
204: CLOSE c_priority;
205: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: ELSE
209: CLOSE c_check_hz_exists;
313: OPEN cur_rowid;
314: FETCH cur_rowid INTO lv_rowid;
315: IF (cur_rowid%FOUND) THEN
316: CLOSE cur_rowid;
317: fnd_message.set_name ('IGS', 'IGS_PS_USPF_USPR_FK');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: RETURN;
321: END IF;
347: OPEN cur_rowid;
348: FETCH cur_rowid INTO lv_rowid;
349: IF (cur_rowid%FOUND) THEN
350: CLOSE cur_rowid;
351: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_CRV_FK');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: RETURN;
355: END IF;
381: OPEN cur_rowid;
382: FETCH cur_rowid INTO lv_rowid;
383: IF (cur_rowid%FOUND) THEN
384: CLOSE cur_rowid;
385: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_CSTT_FK');
386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: RETURN;
389: END IF;
416: OPEN cur_rowid;
417: FETCH cur_rowid INTO lv_rowid;
418: IF (cur_rowid%FOUND) THEN
419: CLOSE cur_rowid;
420: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_US_FK');
421: igs_ge_msg_stack.add;
422: app_exception.raise_exception;
423: RETURN;
424: END IF;
450: OPEN cur_rowid;
451: FETCH cur_rowid INTO lv_rowid;
452: IF (cur_rowid%FOUND) THEN
453: CLOSE cur_rowid;
454: fnd_message.set_name ('IGS', 'IGS_PS_ROPF_HZ_PARTIES_FK');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: RETURN;
458: END IF;
513: IF ( get_pk_for_validation(
514: new_references.rsv_org_unit_prf_id
515: )
516: ) THEN
517: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
518: igs_ge_msg_stack.add;
519: app_exception.raise_exception;
520: END IF;
521: check_uniqueness;
530: IF ( get_pk_for_validation (
531: new_references.rsv_org_unit_prf_id
532: )
533: ) THEN
534: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
535: igs_ge_msg_stack.add;
536: app_exception.raise_exception;
537: END IF;
538: check_uniqueness;
589: IF (x_last_update_login IS NULL) THEN
590: x_last_update_login := -1;
591: END IF;
592: ELSE
593: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
594: igs_ge_msg_stack.add;
595: app_exception.raise_exception;
596: END IF;
597:
692:
693: OPEN c1;
694: FETCH c1 INTO tlinfo;
695: IF (c1%notfound) THEN
696: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
697: igs_ge_msg_stack.add;
698: CLOSE c1;
699: app_exception.raise_exception;
700: RETURN;
710: AND ((tlinfo.group_id = x_group_id) OR ((tlinfo.group_id IS NULL) AND (X_group_id IS NULL)))
711: ) THEN
712: NULL;
713: ELSE
714: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
715: igs_ge_msg_stack.add;
716: app_exception.raise_exception;
717: END IF;
718:
760: IF (x_last_update_login IS NULL) THEN
761: x_last_update_login := -1;
762: END IF;
763: ELSE
764: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
765: igs_ge_msg_stack.add;
766: app_exception.raise_exception;
767: END IF;
768: