eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_APPL_NOTES_PKG dependencies on APP_EXCEPTION

Line 52: App_Exception.Raise_Exception;

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;
56:

Line 126: app_exception.raise_exception;

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
130: /*************************************************************

Line 161: App_Exception.Raise_Exception;

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
165: ((new_references.note_type_id IS NULL))) THEN

Line 175: App_Exception.Raise_Exception;

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;
179:

Line 294: App_Exception.Raise_Exception;

290: Fetch cur_rowid INTO lv_rowid;
291: IF (cur_rowid%FOUND) THEN
292: Close cur_rowid;
293: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAN_ACAI_FK');
294: App_Exception.Raise_Exception;
295: Return;
296: END IF;
297: Close cur_rowid;
298:

Line 331: App_Exception.Raise_Exception;

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;
335:

Line 427: App_Exception.Raise_Exception;

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:
431: IF (p_action = 'INSERT') THEN

Line 438: App_Exception.Raise_Exception;

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;
442: Check_Parent_Existance;

Line 458: App_Exception.Raise_Exception;

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;
462: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 577: app_exception.raise_exception;

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;
581: X_REF_NOTES_ID := -1;

Line 663: app_exception.raise_exception;

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;
667: END INSERT_ROW;

Line 706: app_exception.raise_exception;

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;
709: close c1;
710: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 721: app_exception.raise_exception;

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;
725: Procedure UPDATE_ROW (

Line 774: app_exception.raise_exception;

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',
778: x_rowid=>X_ROWID,

Line 830: app_exception.raise_exception;

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;
831: END IF;
832: IF (x_mode = 'S') THEN
833: igs_sc_gen_001.unset_ctx('R');
834: END IF;

Line 855: app_exception.raise_exception;

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;
859: END UPDATE_ROW;

Line 946: app_exception.raise_exception;

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
949: igs_sc_gen_001.unset_ctx('R');
950: END IF;

Line 970: app_exception.raise_exception;

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;
974: end DELETE_ROW;