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_TERM_DETAILS_PKG dependencies on FND_MESSAGE

Line 39: Fnd_message.Set_Name('IGS', 'IGS_AD_INACTIVE_ACAD_HIST');

35: CLOSE check_status;
36:
37: IF l_temp IS NOT NULL THEN
38:
39: Fnd_message.Set_Name('IGS', 'IGS_AD_INACTIVE_ACAD_HIST');
40: IGS_GE_MSG_STACK.ADD;
41: app_exception.Raise_Exception;
42:
43: END IF;

Line 93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

89: Open cur_old_ref_values;
90: Fetch cur_old_ref_values INTO old_references;
91: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
92: Close cur_old_ref_values;
93: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: Return;
97: END IF;

Line 164: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

160: -- The following code checks for check constraints on the Columns.
161: IF Upper(Column_Name) = 'TOTAL_CP_EARNED' OR
162: Column_Name IS NULL THEN
163: IF NOT (new_references.total_cp_earned >=0) THEN
164: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
165: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_EARNED'));
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;

Line 165: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_EARNED'));

161: IF Upper(Column_Name) = 'TOTAL_CP_EARNED' OR
162: Column_Name IS NULL THEN
163: IF NOT (new_references.total_cp_earned >=0) THEN
164: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
165: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_EARNED'));
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: END IF;

Line 175: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

171: -- The following code checks for check constraints on the Columns.
172: IF Upper(Column_Name) = 'TOTAL_GPA_UNITS' OR
173: Column_Name IS NULL THEN
174: IF NOT (new_references.total_gpa_units >=0) THEN
175: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_GPA_UNITS'));
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;

Line 176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_GPA_UNITS'));

172: IF Upper(Column_Name) = 'TOTAL_GPA_UNITS' OR
173: Column_Name IS NULL THEN
174: IF NOT (new_references.total_gpa_units >=0) THEN
175: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_GPA_UNITS'));
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180: END IF;

Line 186: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

182: -- The following code checks for check constraints on the Columns.
183: IF Upper(Column_Name) = 'TOTAL_UNIT_GP' OR
184: Column_Name IS NULL THEN
185: IF NOT (new_references.total_unit_gp >= 0) THEN
186: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_UNIT_GP'));
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;

Line 187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_UNIT_GP'));

183: IF Upper(Column_Name) = 'TOTAL_UNIT_GP' OR
184: Column_Name IS NULL THEN
185: IF NOT (new_references.total_unit_gp >= 0) THEN
186: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_UNIT_GP'));
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;

Line 197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ST_DT_ED_DT');

193: -- The following code checks for check constraints on the Columns.
194: IF Upper(Column_Name) = 'END_DATE' OR
195: Column_Name IS NULL THEN
196: IF ( NOT (new_references.end_date > new_references.start_date) OR new_references.start_date > SYSDATE ) THEN
197: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ST_DT_ED_DT');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;

Line 207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

203: -- The following code checks for check constraints on the Columns.
204: IF Upper(Column_Name) = 'TOTAL_CP_ATTEMPTED' OR
205: Column_Name IS NULL THEN
206: IF NOT (new_references.total_cp_attempted >=0) THEN
207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
208: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_ATTEMPTED'));
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;

Line 208: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_ATTEMPTED'));

204: IF Upper(Column_Name) = 'TOTAL_CP_ATTEMPTED' OR
205: Column_Name IS NULL THEN
206: IF NOT (new_references.total_cp_attempted >=0) THEN
207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
208: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TOTAL_CP_ATTEMPTED'));
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;

Line 237: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

233: NULL;
234: ELSIF NOT Igs_Ad_Transcript_Pkg.Get_PK_For_Validation (
235: new_references.transcript_id
236: ) THEN
237: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT'));
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;

Line 238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT'));

234: ELSIF NOT Igs_Ad_Transcript_Pkg.Get_PK_For_Validation (
235: new_references.transcript_id
236: ) THEN
237: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TRANSCRIPT'));
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242:

Line 329: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ATD_ATRN_FK');

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

Line 395: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

391: -- Call all the procedures related to Before Insert.
392: Null;
393: IF Get_Pk_For_Validation(
394: new_references.term_details_id) THEN
395: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
396: IGS_GE_MSG_STACK.ADD;
397: App_Exception.Raise_Exception;
398: END IF;
399: Check_Constraints;

Line 416: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

412: ELSIF (p_action = 'VALIDATE_INSERT') THEN
413: -- Call all the procedures related to Before Insert.
414: IF Get_PK_For_Validation (
415: new_references.term_details_id) THEN
416: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: END IF;
420: Check_Constraints;

Line 523: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

519: else
520: X_PROGRAM_UPDATE_DATE := SYSDATE;
521: end if;
522: else
523: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
524: IGS_GE_MSG_STACK.ADD;
525: app_exception.raise_exception;
526: end if;
527:

Line 608: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

604: x_rowid => X_ROWID );
605: EXCEPTION
606: WHEN OTHERS THEN
607: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
608: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
609: fnd_message.set_token ('ERR_CD', SQLCODE);
610: igs_ge_msg_stack.add;
611: igs_sc_gen_001.unset_ctx('R');
612: app_exception.raise_exception;

Line 609: fnd_message.set_token ('ERR_CD', SQLCODE);

605: EXCEPTION
606: WHEN OTHERS THEN
607: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
608: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
609: fnd_message.set_token ('ERR_CD', SQLCODE);
610: igs_ge_msg_stack.add;
611: igs_sc_gen_001.unset_ctx('R');
612: app_exception.raise_exception;
613: ELSE

Line 660: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

656: begin
657: open c1;
658: fetch c1 into tlinfo;
659: if (c1%notfound) then
660: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
661: IGS_GE_MSG_STACK.ADD;
662: close c1;
663: app_exception.raise_exception;
664: return;

Line 689: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

685: AND (X_GPA is null)))
686: ) then
687: null;
688: else
689: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
690: IGS_GE_MSG_STACK.ADD;
691: app_exception.raise_exception;
692: end if;
693: return;

Line 742: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

738: if X_LAST_UPDATE_LOGIN is NULL then
739: X_LAST_UPDATE_LOGIN := -1;
740: end if;
741: else
742: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
743: IGS_GE_MSG_STACK.ADD;
744: app_exception.raise_exception;
745: end if;
746: Before_DML(

Line 801: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

797: PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID,
798: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
799: where ROWID = X_ROWID;
800: if (sql%notfound) then
801: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
802: igs_ge_msg_stack.add;
803: igs_sc_gen_001.unset_ctx('R');
804: app_exception.raise_exception;
805: end if;

Line 818: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

814: );
815: EXCEPTION
816: WHEN OTHERS THEN
817: IF (SQLCODE = (-28115)) THEN
818: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
819: fnd_message.set_token ('ERR_CD', SQLCODE);
820: igs_ge_msg_stack.add;
821: igs_sc_gen_001.unset_ctx('R');
822: app_exception.raise_exception;

Line 819: fnd_message.set_token ('ERR_CD', SQLCODE);

815: EXCEPTION
816: WHEN OTHERS THEN
817: IF (SQLCODE = (-28115)) THEN
818: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
819: fnd_message.set_token ('ERR_CD', SQLCODE);
820: igs_ge_msg_stack.add;
821: igs_sc_gen_001.unset_ctx('R');
822: app_exception.raise_exception;
823: ELSE

Line 918: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

914: END IF;
915: delete from IGS_AD_TERM_DETAILS
916: where ROWID = X_ROWID;
917: if (sql%notfound) then
918: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
919: igs_ge_msg_stack.add;
920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;
922: end if;