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_ADM_CAT_PKG dependencies on IGS_GE_MSG_STACK

Line 50: IGS_GE_MSG_STACK.ADD;

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

Line 123: IGS_GE_MSG_STACK.ADD;

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

Line 157: IGS_GE_MSG_STACK.ADD;

153: new_references.nominated_course_cd,
154: new_references.sequence_number
155: ) THEN
156: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160:
161: IF (((old_references.spl_adm_cat = new_references.spl_adm_cat)) OR

Line 170: IGS_GE_MSG_STACK.ADD;

166: 'SPECIAL_ADM_CAT',
167: 'N'
168: ) THEN
169: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173:
174: END Check_Parent_Existance;

Line 290: IGS_GE_MSG_STACK.ADD;

286: Fetch cur_rowid INTO lv_rowid;
287: IF (cur_rowid%FOUND) THEN
288: Close cur_rowid;
289: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASAC_ACAI_FK');
290: IGS_GE_MSG_STACK.ADD;
291: App_Exception.Raise_Exception;
292: Return;
293: END IF;
294: Close cur_rowid;

Line 327: IGS_GE_MSG_STACK.ADD;

323: Fetch cur_rowid INTO lv_rowid;
324: IF (cur_rowid%FOUND) THEN
325: Close cur_rowid;
326: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASAC_ACDC_FK');
327: IGS_GE_MSG_STACK.ADD;
328: App_Exception.Raise_Exception;
329: Return;
330: END IF;
331: Close cur_rowid;

Line 392: IGS_GE_MSG_STACK.ADD;

388: Null;
389: IF Get_Pk_For_Validation(
390: new_references.spl_adm_cat_id) THEN
391: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
392: IGS_GE_MSG_STACK.ADD;
393: App_Exception.Raise_Exception;
394: END IF;
395: Check_Uniqueness;
396: Check_Constraints;

Line 412: IGS_GE_MSG_STACK.ADD;

408: -- Call all the procedures related to Before Insert.
409: IF Get_PK_For_Validation (
410: new_references.spl_adm_cat_id) THEN
411: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
412: IGS_GE_MSG_STACK.ADD;
413: App_Exception.Raise_Exception;
414: END IF;
415: Check_Uniqueness;
416: Check_Constraints;

Line 502: IGS_GE_MSG_STACK.ADD;

498: X_LAST_UPDATE_LOGIN := -1;
499: end if;
500: else
501: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
502: IGS_GE_MSG_STACK.ADD;
503: app_exception.raise_exception;
504: end if;
505:
506: X_SPL_ADM_CAT_ID := -1;

Line 576: IGS_GE_MSG_STACK.ADD;

572: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
573: -- that the ownerof policy function does not have privilege to access.
574: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
575: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
576: IGS_GE_MSG_STACK.ADD;
577: app_exception.raise_exception;
578: ELSE
579: RAISE;
580: END IF;

Line 616: IGS_GE_MSG_STACK.ADD;

612: open c1;
613: fetch c1 into tlinfo;
614: if (c1%notfound) then
615: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
616: IGS_GE_MSG_STACK.ADD;
617: close c1;
618: app_exception.raise_exception;
619: return;
620: end if;

Line 631: IGS_GE_MSG_STACK.ADD;

627: ) then
628: null;
629: else
630: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
631: IGS_GE_MSG_STACK.ADD;
632: app_exception.raise_exception;
633: end if;
634: return;
635: end LOCK_ROW;

Line 677: IGS_GE_MSG_STACK.ADD;

673: X_LAST_UPDATE_LOGIN := -1;
674: end if;
675: else
676: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
677: IGS_GE_MSG_STACK.ADD;
678: app_exception.raise_exception;
679: end if;
680: Before_DML(
681: p_action=>'UPDATE',

Line 709: igs_ge_msg_stack.add;

705: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
706: where ROWID = X_ROWID;
707: if (sql%notfound) then
708: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
709: igs_ge_msg_stack.add;
710: IF (x_mode = 'S') THEN
711: igs_sc_gen_001.unset_ctx('R');
712: END IF;
713: app_exception.raise_exception;

Line 737: IGS_GE_MSG_STACK.ADD;

733: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
734: -- that the ownerof policy function does not have privilege to access.
735: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
736: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
737: IGS_GE_MSG_STACK.ADD;
738: app_exception.raise_exception;
739: ELSE
740: RAISE;
741: END IF;

Line 821: igs_ge_msg_stack.add;

817: delete from IGS_AD_SPL_ADM_CAT
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: IF (x_mode = 'S') THEN
823: igs_sc_gen_001.unset_ctx('R');
824: END IF;
825: app_exception.raise_exception;

Line 848: IGS_GE_MSG_STACK.ADD;

844: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
845: -- that the ownerof policy function does not have privilege to access.
846: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
847: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
848: IGS_GE_MSG_STACK.ADD;
849: app_exception.raise_exception;
850: ELSE
851: RAISE;
852: END IF;