APPS.IGS_HE_AD_DTL_ALL_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 115: igs_ge_msg_stack.add;

111: new_references.nominated_course_cd,
112: new_references.sequence_number
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117:
118: END IF;
119:

Line 190: igs_ge_msg_stack.add;

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

Line 257: igs_ge_msg_stack.add;

253: new_references.hesa_ad_dtl_id
254: )
255: ) THEN
256: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: END IF;
260: check_parent_existance;
261: ELSIF (p_action = 'UPDATE') THEN

Line 271: igs_ge_msg_stack.add;

267: new_references.hesa_ad_dtl_id
268: )
269: ) THEN
270: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
271: igs_ge_msg_stack.add;
272: app_exception.raise_exception;
273: END IF;
274: END IF;
275:

Line 328: igs_ge_msg_stack.add;

324: x_last_update_login := -1;
325: END IF;
326: ELSE
327: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: END IF;
331:
332: SELECT igs_he_ad_dtl_all_s.NEXTVAL

Line 411: igs_ge_msg_stack.add;

407: WHEN OTHERS THEN
408: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
409: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
410: fnd_message.set_token ('ERR_CD', SQLCODE);
411: igs_ge_msg_stack.add;
412: igs_sc_gen_001.unset_ctx('R');
413: app_exception.raise_exception;
414: ELSE
415: igs_sc_gen_001.unset_ctx('R');

Line 468: igs_ge_msg_stack.add;

464: OPEN c1;
465: FETCH c1 INTO tlinfo;
466: IF (c1%notfound) THEN
467: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
468: igs_ge_msg_stack.add;
469: CLOSE c1;
470: app_exception.raise_exception;
471: RETURN;
472: END IF;

Line 488: igs_ge_msg_stack.add;

484: ) THEN
485: NULL;
486: ELSE
487: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END IF;
491:
492: RETURN;

Line 541: igs_ge_msg_stack.add;

537: x_last_update_login := -1;
538: END IF;
539: ELSE
540: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544:
545: before_dml(

Line 585: igs_ge_msg_stack.add;

581: WHERE rowid = x_rowid;
582:
583: IF (SQL%NOTFOUND) THEN
584: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
585: igs_ge_msg_stack.add;
586: igs_sc_gen_001.unset_ctx('R');
587: app_exception.raise_exception;
588: END IF;
589: IF (x_mode = 'S') THEN

Line 598: igs_ge_msg_stack.add;

594: WHEN OTHERS THEN
595: IF (SQLCODE = (-28115)) THEN
596: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
597: fnd_message.set_token ('ERR_CD', SQLCODE);
598: igs_ge_msg_stack.add;
599: igs_sc_gen_001.unset_ctx('R');
600: app_exception.raise_exception;
601: ELSE
602: igs_sc_gen_001.unset_ctx('R');

Line 708: igs_ge_msg_stack.add;

704: WHERE rowid = x_rowid;
705:
706: IF (SQL%NOTFOUND) THEN
707: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
708: igs_ge_msg_stack.add;
709: igs_sc_gen_001.unset_ctx('R');
710: app_exception.raise_exception;
711: END IF;
712: IF (x_mode = 'S') THEN