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

Line 45: App_Exception.Raise_Exception;

41: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
42: Close cur_old_ref_values;
43: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
44: IGS_GE_MSG_STACK.ADD;
45: App_Exception.Raise_Exception;
46: Return;
47: END IF;
48: Close cur_old_ref_values;
49: -- Populate New Values.

Line 101: App_Exception.Raise_Exception ;

97: IF upper(column_name) = 'ACAI_NOMINATED_COURSE_CD' OR COLUMN_NAME IS NULL THEN
98: IF new_references.ACAI_NOMINATED_COURSE_CD <> upper(NEW_REFERENCES.ACAI_NOMINATED_COURSE_CD) then
99: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception ;
102: END IF;
103: END IF;
104: IF upper(column_name) = 'GOVT_TYPE_OF_ACTIVITY_CD' OR COLUMN_NAME IS NULL THEN
105: IF new_references.GOVT_TYPE_OF_ACTIVITY_CD <> upper(NEW_REFERENCES.GOVT_TYPE_OF_ACTIVITY_CD) then

Line 108: App_Exception.Raise_Exception ;

104: IF upper(column_name) = 'GOVT_TYPE_OF_ACTIVITY_CD' OR COLUMN_NAME IS NULL THEN
105: IF new_references.GOVT_TYPE_OF_ACTIVITY_CD <> upper(NEW_REFERENCES.GOVT_TYPE_OF_ACTIVITY_CD) then
106: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception ;
109: END IF;
110: END IF;
111: IF upper(column_name) = 'SCA_COURSE_CD' OR COLUMN_NAME IS NULL THEN
112: IF new_references.SCA_COURSE_CD <> upper(NEW_REFERENCES.SCA_COURSE_CD) then

Line 115: App_Exception.Raise_Exception ;

111: IF upper(column_name) = 'SCA_COURSE_CD' OR COLUMN_NAME IS NULL THEN
112: IF new_references.SCA_COURSE_CD <> upper(NEW_REFERENCES.SCA_COURSE_CD) then
113: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception ;
116: END IF;
117: END IF;
118: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
119: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then

Line 122: App_Exception.Raise_Exception ;

118: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
119: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then
120: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception ;
123: END IF;
124: END IF;
125: IF upper(column_name) = 'ACAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
126: IF new_references.ACAI_SEQUENCE_NUMBER < 1 OR new_references.ACAI_SEQUENCE_NUMBER > 999999 then

Line 129: App_Exception.Raise_Exception ;

125: IF upper(column_name) = 'ACAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
126: IF new_references.ACAI_SEQUENCE_NUMBER < 1 OR new_references.ACAI_SEQUENCE_NUMBER > 999999 then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131: END IF;
132: IF upper(column_name) = 'ATTENDANCE_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
133: IF new_references.ATTENDANCE_PERCENTAGE < 1 OR new_references.ATTENDANCE_PERCENTAGE > 100 then

Line 136: App_Exception.Raise_Exception ;

132: IF upper(column_name) = 'ATTENDANCE_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
133: IF new_references.ATTENDANCE_PERCENTAGE < 1 OR new_references.ATTENDANCE_PERCENTAGE > 100 then
134: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception ;
137: END IF;
138: END IF;
139: END Check_Constraints ;
140: FUNCTION Get_PK_For_Validation (

Line 226: App_Exception.Raise_Exception;

222: new_references.hist_start_dt
223: ) THEN
224: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: Check_Constraints;
229: ELSIF (p_action = 'UPDATE') THEN
230: -- Call all the procedures related to Before Update.

Line 240: App_Exception.Raise_Exception;

236: new_references.hist_start_dt
237: ) THEN
238: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242: Check_Constraints;
243: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
244: Check_Constraints;

Line 291: app_exception.raise_exception;

287: end if;
288: else
289: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
290: IGS_GE_MSG_STACK.ADD;
291: app_exception.raise_exception;
292: end if;
293: Before_DML (
294: p_action => 'INSERT',
295: x_rowid => X_ROWID,

Line 412: app_exception.raise_exception;

408: fetch c1 into tlinfo;
409: if (c1%notfound) then
410: close c1;
411: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
412: app_exception.raise_exception;
413: return;
414: end if;
415: close c1;
416: if ( (tlinfo.HIST_END_DT = X_HIST_END_DT)

Line 452: app_exception.raise_exception;

448: ) then
449: null;
450: else
451: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
452: app_exception.raise_exception;
453: end if;
454: return;
455: end LOCK_ROW;
456: procedure UPDATE_ROW (

Line 495: app_exception.raise_exception;

491: end if;
492: else
493: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497: Before_DML (
498: p_action => 'UPDATE',
499: x_rowid => X_ROWID,