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 IGS_GE_MSG_STACK

Line 48: IGS_GE_MSG_STACK.ADD;

44: Fetch cur_old_ref_values INTO old_references;
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;

Line 117: IGS_GE_MSG_STACK.ADD;

113: ,new_references.admission_appl_number
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

Line 145: IGS_GE_MSG_STACK.ADD;

141: 'N'
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

Line 160: IGS_GE_MSG_STACK.ADD;

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

Line 270: IGS_GE_MSG_STACK.ADD;

266: Fetch cur_rowid INTO lv_rowid;
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;

Line 309: IGS_GE_MSG_STACK.ADD;

305: Fetch cur_rowid INTO lv_rowid;
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;

Line 371: IGS_GE_MSG_STACK.ADD;

367: Null;
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;

Line 391: IGS_GE_MSG_STACK.ADD;

387: -- Call all the procedures related to Before Insert.
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;

Line 496: IGS_GE_MSG_STACK.ADD;

492: X_PROGRAM_UPDATE_DATE := SYSDATE;
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;

Line 572: IGS_GE_MSG_STACK.ADD;

568: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;

Line 608: IGS_GE_MSG_STACK.ADD;

604: open c1;
605: fetch c1 into tlinfo;
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;

Line 621: IGS_GE_MSG_STACK.ADD;

617: ) then
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;

Line 669: IGS_GE_MSG_STACK.ADD;

665: X_LAST_UPDATE_LOGIN := -1;
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',

Line 716: igs_ge_msg_stack.add;

712: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
713: where ROWID = X_ROWID;
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

Line 742: IGS_GE_MSG_STACK.ADD;

738: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;

Line 821: igs_ge_msg_stack.add;

817: delete from IGS_AD_SPL_TALENTS
818: where ROWID = X_ROWID;
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

Line 846: IGS_GE_MSG_STACK.ADD;

842: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;