DBA Data[Home] [Help]

APPS.IGS_PR_STDNT_PR_AWD_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 93: igs_ge_msg_stack.add;

89: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation (
90: new_references.award_cd
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
97: IF (((old_references.person_id = new_references.person_id) AND

Line 110: igs_ge_msg_stack.add;

106: new_references.course_cd,
107: new_references.spo_sequence_number
108: ) THEN
109: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_parent_existance;

Line 188: igs_ge_msg_stack.add;

184: FETCH cur_rowid INTO lv_rowid;
185: IF (cur_rowid%FOUND) THEN
186: CLOSE cur_rowid;
187: fnd_message.set_name ('IGS', 'IGS_PR_SPOA_SPO_FK');
188: igs_ge_msg_stack.add;
189: app_exception.raise_exception;
190: RETURN;
191: END IF;
192: CLOSE cur_rowid;

Line 246: igs_ge_msg_stack.add;

242: new_references.award_cd
243: )
244: ) THEN
245: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
246: igs_ge_msg_stack.add;
247: app_exception.raise_exception;
248: END IF;
249: check_parent_existance;
250: ELSIF (p_action = 'UPDATE') THEN

Line 263: igs_ge_msg_stack.add;

259: new_references.award_cd
260: )
261: ) THEN
262: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: END IF;
266: END IF;
267:

Line 317: igs_ge_msg_stack.add;

313: x_last_update_login := -1;
314: END IF;
315: ELSE
316: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: END IF;
320:
321: before_dml(

Line 378: igs_ge_msg_stack.add;

374: WHEN OTHERS THEN
375: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
376: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
377: fnd_message.set_token ('ERR_CD', SQLCODE);
378: igs_ge_msg_stack.add;
379: igs_sc_gen_001.unset_ctx('R');
380: app_exception.raise_exception;
381: ELSE
382: igs_sc_gen_001.unset_ctx('R');

Line 419: igs_ge_msg_stack.add;

415: OPEN c1;
416: FETCH c1 INTO tlinfo;
417: IF (c1%notfound) THEN
418: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
419: igs_ge_msg_stack.add;
420: CLOSE c1;
421: app_exception.raise_exception;
422: RETURN;
423: END IF;

Line 460: igs_ge_msg_stack.add;

456: WHERE rowid = x_rowid;
457:
458: IF (SQL%NOTFOUND) THEN
459: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
460: igs_ge_msg_stack.add;
461: igs_sc_gen_001.unset_ctx('R');
462: app_exception.raise_exception;
463: END IF;
464: IF (x_mode = 'S') THEN