APPS.IGS_AD_APL_RVPF_RSL_PKG dependencies on IGS_GE_MSG_STACK

Line 47: igs_ge_msg_stack.add;

43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;

Line 92: igs_ge_msg_stack.add;

88: new_references.rating_scale_id
89: )
90: ) THEN
91: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
92: igs_ge_msg_stack.add;
93: app_exception.raise_exception;
94: END IF;
95:
96: END check_uniqueness;

Line 118: igs_ge_msg_stack.add;

114: new_references.appl_rev_profile_id ,
115: 'N'
116: ) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:
122: IF (((old_references.rating_type_id = new_references.rating_type_id)) OR

Line 131: igs_ge_msg_stack.add;

127: 'RATING_TYPE',
128: 'N'
129: ) THEN
130: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
131: igs_ge_msg_stack.add;
132: app_exception.raise_exception;
133: END IF;
134:
135: IF (((old_references.rating_scale_id = new_references.rating_scale_id)) OR

Line 143: igs_ge_msg_stack.add;

139: new_references.rating_scale_id ,
140: 'N'
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: END check_parent_existance;

Line 177: igs_ge_msg_stack.add;

173: null;
174: ELSE
175: IF lv_end_date IS NULL OR lv_end_date >= SYSDATE THEN
176: fnd_message.set_name ('IGS', 'IGS_AD_RAT_SCALE_NOT_END');
177: igs_ge_msg_stack.add;
178: app_exception.raise_exception;
179: RETURN;
180: ELSE
181: null;

Line 287: igs_ge_msg_stack.add;

283: FETCH cur_rowid INTO lv_rowid;
284: IF (cur_rowid%FOUND) THEN
285: CLOSE cur_rowid;
286: fnd_message.set_name ('IGS', 'IGS_AD_APRSCL_ADAPR_FK');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: RETURN;
290: END IF;
291: CLOSE cur_rowid;

Line 322: igs_ge_msg_stack.add;

318: FETCH cur_rowid INTO lv_rowid;
319: IF (cur_rowid%FOUND) THEN
320: CLOSE cur_rowid;
321: fnd_message.set_name ('IGS', 'IGS_AD_APRSCL_ADCC_FK');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: RETURN;
325: END IF;
326: CLOSE cur_rowid;

Line 357: igs_ge_msg_stack.add;

353: FETCH cur_rowid INTO lv_rowid;
354: IF (cur_rowid%FOUND) THEN
355: CLOSE cur_rowid;
356: fnd_message.set_name ('IGS', 'IGS_AD_APRSCL_ARS_FK');
357: igs_ge_msg_stack.add;
358: app_exception.raise_exception;
359: RETURN;
360: END IF;
361: CLOSE cur_rowid;

Line 413: igs_ge_msg_stack.add;

409: new_references.appl_revprof_rtscale_id
410: )
411: ) THEN
412: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416: check_uniqueness;
417: check_parent_existance;

Line 435: igs_ge_msg_stack.add;

431: new_references.appl_revprof_rtscale_id
432: )
433: ) THEN
434: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438: check_uniqueness;
439: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 490: igs_ge_msg_stack.add;

486: x_last_update_login := -1;
487: END IF;
488: ELSE
489: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
490: igs_ge_msg_stack.add;
491: app_exception.raise_exception;
492: END IF;
493:
494: x_appl_revprof_rtscale_id := -1;

Line 575: igs_ge_msg_stack.add;

571: OPEN c1;
572: FETCH c1 INTO tlinfo;
573: IF (c1%notfound) THEN
574: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
575: igs_ge_msg_stack.add;
576: CLOSE c1;
577: app_exception.raise_exception;
578: RETURN;
579: END IF;

Line 590: igs_ge_msg_stack.add;

586: ) THEN
587: NULL;
588: ELSE
589: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:
594: RETURN;

Line 637: igs_ge_msg_stack.add;

633: x_last_update_login := -1;
634: END IF;
635: ELSE
636: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
637: igs_ge_msg_stack.add;
638: app_exception.raise_exception;
639: END IF;
640:
641: before_dml(