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_SPL_TALENTS_PKG dependencies on APP_EXCEPTION

Line 49: App_Exception.Raise_Exception;

45: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
46: Close cur_old_ref_values;
47: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
48: IGS_GE_MSG_STACK.ADD;
49: App_Exception.Raise_Exception;
50: Return;
51: END IF;
52: Close cur_old_ref_values;
53:

Line 118: app_exception.raise_exception;

114: ,new_references.person_id
115: ) THEN
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
117: IGS_GE_MSG_STACK.ADD;
118: app_exception.raise_exception;
119: END IF;
120: END Check_Uniqueness ;
121: PROCEDURE Check_Parent_Existance AS
122: /*************************************************************

Line 146: App_Exception.Raise_Exception;

142: ) THEN
143: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
144: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_TALENT_TYPE'));
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148:
149: IF (((old_references.person_id = new_references.person_id) AND
150: (old_references.admission_appl_number = new_references.admission_appl_number)) OR

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_APPL'));
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163:
164: END Check_Parent_Existance;
165:

Line 271: App_Exception.Raise_Exception;

267: IF (cur_rowid%FOUND) THEN
268: Close cur_rowid;
269: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASPLT_ACDC_FK');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: Return;
273: END IF;
274: Close cur_rowid;
275:

Line 310: App_Exception.Raise_Exception;

306: IF (cur_rowid%FOUND) THEN
307: Close cur_rowid;
308: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASPLT_ACAI_FK');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: Return;
312: END IF;
313: Close cur_rowid;
314:

Line 372: App_Exception.Raise_Exception;

368: IF Get_Pk_For_Validation(
369: new_references.spl_talent_id) THEN
370: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373: END IF;
374: Check_Uniqueness;
375: Check_Constraints;
376: Check_Parent_Existance;

Line 392: App_Exception.Raise_Exception;

388: IF Get_PK_For_Validation (
389: new_references.spl_talent_id) THEN
390: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
391: IGS_GE_MSG_STACK.ADD;
392: App_Exception.Raise_Exception;
393: END IF;
394: Check_Uniqueness;
395: Check_Constraints;
396: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 497: app_exception.raise_exception;

493: end if;
494: else
495: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
496: IGS_GE_MSG_STACK.ADD;
497: app_exception.raise_exception;
498: end if;
499:
500: X_SPL_TALENT_ID := -1;
501: Before_DML(

Line 573: app_exception.raise_exception;

569: -- that the ownerof policy function does not have privilege to access.
570: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
571: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
572: IGS_GE_MSG_STACK.ADD;
573: app_exception.raise_exception;
574: ELSE
575: RAISE;
576: END IF;
577: END INSERT_ROW;

Line 610: app_exception.raise_exception;

606: if (c1%notfound) then
607: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
608: IGS_GE_MSG_STACK.ADD;
609: close c1;
610: app_exception.raise_exception;
611: return;
612: end if;
613: close c1;
614: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 622: app_exception.raise_exception;

618: null;
619: else
620: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
621: IGS_GE_MSG_STACK.ADD;
622: app_exception.raise_exception;
623: end if;
624: return;
625: end LOCK_ROW;
626: Procedure UPDATE_ROW (

Line 670: app_exception.raise_exception;

666: end if;
667: else
668: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
669: IGS_GE_MSG_STACK.ADD;
670: app_exception.raise_exception;
671: end if;
672: Before_DML(
673: p_action=>'UPDATE',
674: x_rowid=>X_ROWID,

Line 718: app_exception.raise_exception;

714: if (sql%notfound) then
715: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
716: igs_ge_msg_stack.add;
717: igs_sc_gen_001.unset_ctx('R');
718: app_exception.raise_exception;
719: end if;
720: IF (x_mode = 'S') THEN
721: igs_sc_gen_001.unset_ctx('R');
722: END IF;

Line 743: app_exception.raise_exception;

739: -- that the ownerof policy function does not have privilege to access.
740: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
741: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
742: IGS_GE_MSG_STACK.ADD;
743: app_exception.raise_exception;
744: ELSE
745: RAISE;
746: END IF;
747: END UPDATE_ROW;

Line 823: app_exception.raise_exception;

819: IF (sql%notfound) THEN
820: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
821: igs_ge_msg_stack.add;
822: igs_sc_gen_001.unset_ctx('R');
823: app_exception.raise_exception;
824: END IF;
825: IF (x_mode = 'S') THEN
826: igs_sc_gen_001.unset_ctx('R');
827: END IF;

Line 847: app_exception.raise_exception;

843: -- that the ownerof policy function does not have privilege to access.
844: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
845: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
846: IGS_GE_MSG_STACK.ADD;
847: app_exception.raise_exception;
848: ELSE
849: RAISE;
850: END IF;
851: END DELETE_ROW;