APPS.IGS_HE_ST_SPA_UT_ALL_PKG dependencies on IGS_GE_MSG_STACK

Line 51: igs_ge_msg_stack.add;

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

Line 101: igs_ge_msg_stack.add;

97: new_references.qualification_level
98: )
99: ) THEN
100: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104:
105: END check_uniqueness;

Line 145: igs_ge_msg_stack.add;

141: FETCH c_check_parent INTO l_rowid ;
142: IF c_check_parent%NOTFOUND THEN
143: CLOSE c_check_parent ;
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: ELSE
148: CLOSE c_check_parent ;
149: END IF ;

Line 257: igs_ge_msg_stack.add;

253: FETCH cur_rowid INTO lv_rowid;
254: IF (cur_rowid%FOUND) THEN
255: CLOSE cur_rowid;
256: fnd_message.set_name ('IGS', 'IGS_HE_HSPAU_HSPA_FK');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: RETURN;
260: END IF;
261: CLOSE cur_rowid;

Line 320: igs_ge_msg_stack.add;

316: new_references.hesa_st_spau_id
317: )
318: ) THEN
319: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: END IF;
323: check_uniqueness;
324: check_parent_existance;

Line 336: igs_ge_msg_stack.add;

332: new_references.hesa_st_spau_id
333: )
334: ) THEN
335: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339: check_uniqueness;
340: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 396: igs_ge_msg_stack.add;

392: x_last_update_login := -1;
393: END IF;
394: ELSE
395: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399:
400: SELECT igs_he_st_spa_ut_all_s.NEXTVAL

Line 505: igs_ge_msg_stack.add;

501: OPEN c1;
502: FETCH c1 INTO tlinfo;
503: IF (c1%notfound) THEN
504: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
505: igs_ge_msg_stack.add;
506: CLOSE c1;
507: app_exception.raise_exception;
508: RETURN;
509: END IF;

Line 523: igs_ge_msg_stack.add;

519: ) THEN
520: NULL;
521: ELSE
522: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
526:
527: RETURN;

Line 576: igs_ge_msg_stack.add;

572: x_last_update_login := -1;
573: END IF;
574: ELSE
575: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
576: igs_ge_msg_stack.add;
577: app_exception.raise_exception;
578: END IF;
579:
580: before_dml(