DBA Data[Home] [Help]

APPS.IGS_AS_ANON_ID_US_PKG dependencies on IGS_GE_MSG_STACK

Line 53: igs_ge_msg_stack.add;

49: FETCH cur_old_ref_values INTO old_references;
50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;

Line 143: igs_ge_msg_stack.add;

139: new_references.load_cal_type,
140: new_references.load_ci_sequence_number
141: )) THEN
142: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: END check_uniqueness;

Line 173: igs_ge_msg_stack.add;

169: new_references.load_cal_type,
170: new_references.load_ci_sequence_number
171: ) THEN
172: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: END IF;
176:
177: IF (((old_references.person_id = new_references.person_id) AND

Line 190: igs_ge_msg_stack.add;

186: new_references.course_cd,
187: new_references.uoo_id
188: ) THEN
189: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193:
194: IF (((old_references.person_id = new_references.person_id) AND

Line 204: igs_ge_msg_stack.add;

200: new_references.person_id,
201: new_references.course_cd
202: ) THEN
203: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:
208: IF (((old_references.uoo_id = new_references.uoo_id)) OR

Line 215: igs_ge_msg_stack.add;

211: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
212: new_references.uoo_id
213: ) THEN
214: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218:
219: END check_parent_existance;

Line 290: igs_ge_msg_stack.add;

286: FETCH cur_rowid INTO lv_rowid;
287: IF (cur_rowid%FOUND) THEN
288: CLOSE cur_rowid;
289: fnd_message.set_name ('IGS', 'IGS_AS_ASEC_CI_FK');
290: igs_ge_msg_stack.add;
291: app_exception.raise_exception;
292: RETURN;
293: END IF;
294: CLOSE cur_rowid;

Line 330: igs_ge_msg_stack.add;

326: FETCH cur_rowid INTO lv_rowid;
327: IF (cur_rowid%FOUND) THEN
328: CLOSE cur_rowid;
329: fnd_message.set_name ('IGS', 'IGS_AS_ASEC_SUA_FK');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: RETURN;
333: END IF;
334: CLOSE cur_rowid;

Line 367: igs_ge_msg_stack.add;

363: FETCH cur_rowid INTO lv_rowid;
364: IF (cur_rowid%FOUND) THEN
365: CLOSE cur_rowid;
366: fnd_message.set_name ('IGS', 'IGS_AS_ASEC_SCA_FK');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: RETURN;
370: END IF;
371: CLOSE cur_rowid;

Line 402: igs_ge_msg_stack.add;

398: FETCH cur_rowid INTO lv_rowid;
399: IF (cur_rowid%FOUND) THEN
400: CLOSE cur_rowid;
401: fnd_message.set_name ('IGS', 'IGS_AS_ASEC_UOO_FK');
402: igs_ge_msg_stack.add;
403: app_exception.raise_exception;
404: RETURN;
405: END IF;
406: CLOSE cur_rowid;

Line 470: igs_ge_msg_stack.add;

466: new_references.course_cd,
467: new_references.uoo_id
468: )) THEN
469: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472: END IF;
473: check_uniqueness;
474: check_parent_existance;

Line 487: igs_ge_msg_stack.add;

483: new_references.course_cd,
484: new_references.uoo_id
485: ) ) THEN
486: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490: check_uniqueness;
491: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 566: igs_ge_msg_stack.add;

562: x_program_update_date := SYSDATE;
563: END IF;
564: ELSE
565: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
566: igs_ge_msg_stack.add;
567: app_exception.raise_exception;
568: END IF;
569:
570: before_dml(

Line 684: igs_ge_msg_stack.add;

680: OPEN c1;
681: FETCH c1 INTO tlinfo;
682: IF (c1%notfound) THEN
683: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
684: igs_ge_msg_stack.add;
685: CLOSE c1;
686: app_exception.raise_exception;
687: RETURN;
688: END IF;

Line 701: igs_ge_msg_stack.add;

697: ) THEN
698: NULL;
699: ELSE
700: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
701: igs_ge_msg_stack.add;
702: app_exception.raise_exception;
703: END IF;
704:
705: RETURN;

Line 758: igs_ge_msg_stack.add;

754: x_last_update_login := -1;
755: END IF;
756: ELSE
757: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
758: igs_ge_msg_stack.add;
759: app_exception.raise_exception;
760: END IF;
761:
762: before_dml(