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

Line 43: App_Exception.Raise_Exception;

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

Line 88: App_Exception.Raise_Exception;

84: new_references.os_scndry_edu_qualification,
85: v_message_name) = FALSE THEN
86: Fnd_Message.Set_Name('IGS',v_message_name);
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
91: -- Validate Overseas Secondary Education Qualification IGS_PE_COUNTRY_CD.
92: IF p_inserting

Line 103: App_Exception.Raise_Exception;

99: new_references.country_cd,
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name('IGS',v_message_name);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106:
107:

Line 136: App_Exception.Raise_Exception;

132: IF upper(Column_Name) = 'OS_SCNDRY_EDU_QUALIFICATION' OR Column_Name IS NULL THEN
133: IF new_references.os_scndry_edu_qualification <> UPPER(new_references.os_scndry_edu_qualification) 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: IF upper(Column_Name) = 'RESULT' OR Column_Name IS NULL THEN
140: IF new_references.result <> UPPER(new_references.result) THEN

Line 143: App_Exception.Raise_Exception;

139: IF upper(Column_Name) = 'RESULT' OR Column_Name IS NULL THEN
140: IF new_references.result <> UPPER(new_references.result) THEN
141: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146: IF upper(Column_Name) = 'SCHOOL_NAME' OR Column_Name IS NULL THEN
147: IF new_references.school_name <> UPPER(new_references.school_name) THEN

Line 150: App_Exception.Raise_Exception;

146: IF upper(Column_Name) = 'SCHOOL_NAME' OR Column_Name IS NULL THEN
147: IF new_references.school_name <> UPPER(new_references.school_name) THEN
148: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: END IF;
153: IF upper(Column_Name) = 'COUNTRY_CD' OR Column_Name IS NULL THEN
154: IF new_references.country_cd <> UPPER(new_references.country_cd) THEN

Line 157: App_Exception.Raise_Exception;

153: IF upper(Column_Name) = 'COUNTRY_CD' OR Column_Name IS NULL THEN
154: IF new_references.country_cd <> UPPER(new_references.country_cd) THEN
155: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
160: IF upper(Column_Name) = 'SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
161: IF new_references.sequence_number < 1 OR new_references.sequence_number > 999999 THEN

Line 164: App_Exception.Raise_Exception;

160: IF upper(Column_Name) = 'SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
161: IF new_references.sequence_number < 1 OR new_references.sequence_number > 999999 THEN
162: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166: END IF;
167: IF upper(Column_Name) = 'RESULT_OBTAINED_YR' OR Column_Name IS NULL THEN
168: IF new_references.result_obtained_yr < 1900 OR new_references.result_obtained_yr > 2050 THEN

Line 171: App_Exception.Raise_Exception;

167: IF upper(Column_Name) = 'RESULT_OBTAINED_YR' OR Column_Name IS NULL THEN
168: IF new_references.result_obtained_yr < 1900 OR new_references.result_obtained_yr > 2050 THEN
169: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:
175: END Check_Constraints;

Line 189: App_Exception.Raise_Exception;

185: new_references.country_cd
186: ) THEN
187: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192:
193: IF (((old_references.os_scndry_edu_qualification = new_references.os_scndry_edu_qualification)) OR

Line 203: App_Exception.Raise_Exception;

199: 'N'
200: ) THEN
201: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: END IF;
205: END IF;
206:
207: IF (((old_references.person_id = new_references.person_id)) OR

Line 216: App_Exception.Raise_Exception;

212: new_references.person_id
213: ) THEN
214: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: END IF;
219:
220: END Check_Parent_Existance;

Line 279: App_Exception.Raise_Exception;

275: IF (cur_rowid%FOUND) THEN
276: Close cur_rowid;
277: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OSE_CNC_FK');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: Return;
281: END IF;
282: Close cur_rowid;
283:

Line 305: App_Exception.Raise_Exception;

301: IF (cur_rowid%FOUND) THEN
302: Close cur_rowid;
303: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OSE_OSEQ_FK');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: Return;
307: END IF;
308: Close cur_rowid;
309:

Line 331: App_Exception.Raise_Exception;

327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OSE_PE_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;
334: Close cur_rowid;
335:

Line 385: App_Exception.Raise_Exception;

381: new_references.sequence_number
382: ) THEN
383: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: END IF;
387: Check_Constraints;
388: Check_Parent_Existance;
389: ELSIF (p_action = 'UPDATE') THEN

Line 401: App_Exception.Raise_Exception;

397: new_references.sequence_number
398: ) THEN
399: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
400: IGS_GE_MSG_STACK.ADD;
401: App_Exception.Raise_Exception;
402: END IF;
403: Check_Constraints;
404: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
405: Check_Constraints;

Line 459: app_exception.raise_exception;

455: end if;
456: else
457: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
458: IGS_GE_MSG_STACK.ADD;
459: app_exception.raise_exception;
460: end if;
461:
462:
463: Before_DML(

Line 560: app_exception.raise_exception;

556: if (c1%notfound) then
557: close c1;
558: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
559: IGS_GE_MSG_STACK.ADD;
560: app_exception.raise_exception;
561: return;
562: end if;
563: close c1;
564:

Line 589: app_exception.raise_exception;

585: null;
586: else
587: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
588: IGS_GE_MSG_STACK.ADD;
589: app_exception.raise_exception;
590: end if;
591: return;
592: end LOCK_ROW;
593:

Line 627: app_exception.raise_exception;

623: end if;
624: else
625: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
626: IGS_GE_MSG_STACK.ADD;
627: app_exception.raise_exception;
628: end if;
629:
630: Before_DML(
631: p_action=>'UPDATE' ,