APPS.IGS_AD_APPL_NOTES_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 125: IGS_GE_MSG_STACK.ADD;

121: ,new_references.person_id
122: ,new_references.sequence_number
123: ) THEN
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
125: IGS_GE_MSG_STACK.ADD;
126: app_exception.raise_exception;
127: END IF;
128: END Check_Uniqueness ;
129: PROCEDURE Check_Parent_Existance AS

Line 160: IGS_GE_MSG_STACK.ADD;

156: new_references.sequence_number
157: ) THEN
158: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
159: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163:
164: IF (((old_references.note_type_id = new_references.note_type_id)) OR

Line 174: IGS_GE_MSG_STACK.ADD;

170: 'N'
171: ) THEN
172: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_NOTE_TYPE'));
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177:
178: END Check_Parent_Existance;

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_AD_AAN_ANT_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;
334: Close cur_rowid;

Line 426: IGS_GE_MSG_STACK.ADD;

422:
423: -- applicaiton would have got withdrawn.
424: IF NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(lv_appl_inst_status),'-1') = 'WITHDRAWN' THEN
425: Fnd_Message.Set_name('IGS','IGS_AD_APPL_INST_WITHD');
426: IGS_GE_MSG_STACK.ADD;
427: App_Exception.Raise_Exception;
428: END IF;
429: -- end apadegal adtd001 igs.m
430:

Line 437: IGS_GE_MSG_STACK.ADD;

433: Null;
434: IF Get_Pk_For_Validation(
435: new_references.appl_notes_id) THEN
436: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
437: IGS_GE_MSG_STACK.ADD;
438: App_Exception.Raise_Exception;
439: END IF;
440: Check_Uniqueness;
441: Check_Constraints;

Line 457: IGS_GE_MSG_STACK.ADD;

453: -- Call all the procedures related to Before Insert.
454: IF Get_PK_For_Validation (
455: new_references.appl_notes_id) THEN
456: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
457: IGS_GE_MSG_STACK.ADD;
458: App_Exception.Raise_Exception;
459: END IF;
460: Check_Uniqueness;
461: Check_Constraints;

Line 576: IGS_GE_MSG_STACK.ADD;

572: X_PROGRAM_UPDATE_DATE := SYSDATE;
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: X_APPL_NOTES_ID := -1;

Line 662: IGS_GE_MSG_STACK.ADD;

658: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
659: -- that the ownerof policy function does not have privilege to access.
660: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
661: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
662: IGS_GE_MSG_STACK.ADD;
663: app_exception.raise_exception;
664: ELSE
665: RAISE;
666: END IF;

Line 704: IGS_GE_MSG_STACK.ADD;

700: open c1;
701: fetch c1 into tlinfo;
702: if (c1%notfound) then
703: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
704: IGS_GE_MSG_STACK.ADD;
705: close c1;
706: app_exception.raise_exception;
707: return;
708: end if;

Line 720: IGS_GE_MSG_STACK.ADD;

716: ) then
717: null;
718: else
719: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
720: IGS_GE_MSG_STACK.ADD;
721: app_exception.raise_exception;
722: end if;
723: return;
724: end LOCK_ROW;

Line 773: IGS_GE_MSG_STACK.ADD;

769: X_LAST_UPDATE_LOGIN := -1;
770: end if;
771: else
772: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
773: IGS_GE_MSG_STACK.ADD;
774: app_exception.raise_exception;
775: end if;
776: Before_DML(
777: p_action=>'UPDATE',

Line 826: igs_ge_msg_stack.add;

822: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
823: where ROWID = X_ROWID;
824: IF (sql%notfound) THEN
825: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
826: igs_ge_msg_stack.add;
827: IF (x_mode = 'S') THEN
828: igs_sc_gen_001.set_ctx('R');
829: END IF;
830: app_exception.raise_exception;

Line 854: IGS_GE_MSG_STACK.ADD;

850: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
851: -- that the ownerof policy function does not have privilege to access.
852: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
853: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
854: IGS_GE_MSG_STACK.ADD;
855: app_exception.raise_exception;
856: ELSE
857: RAISE;
858: END IF;

Line 944: igs_ge_msg_stack.add;

940: DELETE FROM IGS_AD_APPL_NOTES
941: WHERE ROWID = X_ROWID;
942: IF (sql%notfound) THEN
943: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
944: igs_ge_msg_stack.add;
945: igs_sc_gen_001.unset_ctx('R');
946: app_exception.raise_exception;
947: END IF;
948: IF (x_mode = 'S') THEN

Line 969: IGS_GE_MSG_STACK.ADD;

965: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
966: -- that the ownerof policy function does not have privilege to access.
967: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
968: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
969: IGS_GE_MSG_STACK.ADD;
970: app_exception.raise_exception;
971: ELSE
972: RAISE;
973: END IF;