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

Line 42: App_Exception.Raise_Exception;

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

Line 87: App_Exception.Raise_Exception;

83: new_references.aus_scndry_edu_ass_type,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88:
89:
90:
91:

Line 109: App_Exception.Raise_Exception;

105: new_references.aus_scndry_edu_ass_type,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name('IGS',v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112: -- Validate that the state_cd is the same as the state_cd of
113: -- the secondary_school_cd state_cd.

Line 130: App_Exception.Raise_Exception;

126:
127:
128:
129:
130: App_Exception.Raise_Exception;
131:
132:
133:
134:

Line 149: App_Exception.Raise_Exception;

145: new_references.aus_scndry_edu_ass_type,
146: v_message_name) = FALSE THEN
147: Fnd_Message.Set_Name('IGS',v_message_name);
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151: END IF;
152: END BeforeRowInsertUpdate1;
153:

Line 180: App_Exception.Raise_Exception;

176: IF ((UPPER (column_name) = 'SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
177: IF ((new_references.sequence_number < 1) OR (new_references.sequence_number > 9999999999)) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183: IF ((UPPER (column_name) = 'RESULT_OBTAINED_YR ') OR (column_name IS NULL)) THEN
184: IF ((new_references.result_obtained_yr < 1900) OR (new_references.result_obtained_yr > 2050)) THEN

Line 187: App_Exception.Raise_Exception;

183: IF ((UPPER (column_name) = 'RESULT_OBTAINED_YR ') OR (column_name IS NULL)) THEN
184: IF ((new_references.result_obtained_yr < 1900) OR (new_references.result_obtained_yr > 2050)) THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: END IF;
190: IF ((UPPER (column_name) = 'AUS_SCNDRY_EDU_ASS_TYPE') OR (column_name IS NULL)) THEN
191: IF (new_references.aus_scndry_edu_ass_type <> UPPER (new_references.aus_scndry_edu_ass_type)) THEN

Line 194: App_Exception.Raise_Exception;

190: IF ((UPPER (column_name) = 'AUS_SCNDRY_EDU_ASS_TYPE') OR (column_name IS NULL)) THEN
191: IF (new_references.aus_scndry_edu_ass_type <> UPPER (new_references.aus_scndry_edu_ass_type)) THEN
192: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
197: IF ((UPPER (column_name) = 'SECONDARY_SCHOOL_CD') OR (column_name IS NULL)) THEN
198: IF (new_references.secondary_school_cd <> UPPER (new_references.secondary_school_cd)) THEN

Line 201: App_Exception.Raise_Exception;

197: IF ((UPPER (column_name) = 'SECONDARY_SCHOOL_CD') OR (column_name IS NULL)) THEN
198: IF (new_references.secondary_school_cd <> UPPER (new_references.secondary_school_cd)) THEN
199: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
204: IF ((UPPER (column_name) = 'STATE_CD') OR (column_name IS NULL)) THEN
205: IF (new_references.state_cd <> UPPER (new_references.state_cd)) THEN

Line 208: App_Exception.Raise_Exception;

204: IF ((UPPER (column_name) = 'STATE_CD') OR (column_name IS NULL)) THEN
205: IF (new_references.state_cd <> UPPER (new_references.state_cd)) THEN
206: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210: END IF;
211: IF ((UPPER (column_name) = 'SCORE') OR (column_name IS NULL)) THEN
212: IF ((new_references.score < 0) OR (new_references.score > 999.999)) THEN

Line 215: App_Exception.Raise_Exception;

211: IF ((UPPER (column_name) = 'SCORE') OR (column_name IS NULL)) THEN
212: IF ((new_references.score < 0) OR (new_references.score > 999.999)) THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: END IF;
217: END IF;
218: IF ((UPPER (column_name) = 'CANDIDATE_NUMBER') OR (column_name IS NULL)) THEN
219: IF ((new_references.candidate_number < 1) OR (new_references.candidate_number > 999999999999)) THEN

Line 222: App_Exception.Raise_Exception;

218: IF ((UPPER (column_name) = 'CANDIDATE_NUMBER') OR (column_name IS NULL)) THEN
219: IF ((new_references.candidate_number < 1) OR (new_references.candidate_number > 999999999999)) THEN
220: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: END IF;
225: End Check_Constraints;
226:

Line 241: App_Exception.Raise_Exception;

237: 'N'
238: ) THEN
239: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
240: IGS_GE_MSG_STACK.ADD;
241: App_Exception.Raise_Exception;
242: END IF;
243: END IF;
244: IF (((old_references.secondary_school_cd = new_references.secondary_school_cd)) OR
245: ((new_references.secondary_school_cd IS NULL))) THEN

Line 254: App_Exception.Raise_Exception;

250: 'N'
251: ) THEN
252: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: END IF;
257: IF (((old_references.person_id = new_references.person_id)) OR
258: ((new_references.person_id IS NULL))) THEN

Line 266: App_Exception.Raise_Exception;

262: new_references.person_id
263: ) THEN
264: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
265: IGS_GE_MSG_STACK.ADD;
266: App_Exception.Raise_Exception;
267: END IF;
268: END IF;
269:
270: END Check_Parent_Existance;

Line 498: App_Exception.Raise_Exception;

494: IF (cur_rowid%FOUND) THEN
495: Close cur_rowid;
496: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASE_ASEAT_FK');
497: IGS_GE_MSG_STACK.ADD;
498: App_Exception.Raise_Exception;
499: Return;
500: END IF;
501: Close cur_rowid;
502:

Line 524: App_Exception.Raise_Exception;

520: IF (cur_rowid%FOUND) THEN
521: Close cur_rowid;
522: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASE_ASES_FK');
523: IGS_GE_MSG_STACK.ADD;
524: App_Exception.Raise_Exception;
525: Return;
526: END IF;
527: Close cur_rowid;
528:

Line 550: App_Exception.Raise_Exception;

546: IF (cur_rowid%FOUND) THEN
547: Close cur_rowid;
548: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASE_PE_FK');
549: IGS_GE_MSG_STACK.ADD;
550: App_Exception.Raise_Exception;
551: Return;
552: END IF;
553: Close cur_rowid;
554:

Line 602: App_Exception.Raise_Exception;

598: new_references.sequence_number
599: ) THEN
600: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
601: IGS_GE_MSG_STACK.ADD;
602: App_Exception.Raise_Exception;
603: END IF;
604: Check_Constraints;
605: Check_Parent_Existance;
606: ELSIF (p_action = 'UPDATE') THEN

Line 621: App_Exception.Raise_Exception;

617: new_references.sequence_number
618: ) THEN
619: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
620: IGS_GE_MSG_STACK.ADD;
621: App_Exception.Raise_Exception;
622: END IF;
623: Check_Constraints;
624: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
625: Check_Constraints;

Line 691: app_exception.raise_exception;

687: end if;
688: else
689: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
690: IGS_GE_MSG_STACK.ADD;
691: app_exception.raise_exception;
692: end if;
693:
694: Before_DML(
695: p_action=>'INSERT',

Line 793: app_exception.raise_exception;

789: fetch c1 into tlinfo;
790: if (c1%notfound) then
791: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
792: IGS_GE_MSG_STACK.ADD;
793: app_exception.raise_exception;
794: close c1;
795: return;
796: end if;
797: close c1;

Line 820: app_exception.raise_exception;

816: null;
817: else
818: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
819: IGS_GE_MSG_STACK.ADD;
820: app_exception.raise_exception;
821: end if;
822: return;
823: end LOCK_ROW;
824:

Line 861: app_exception.raise_exception;

857: end if;
858: else
859: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
860: IGS_GE_MSG_STACK.ADD;
861: app_exception.raise_exception;
862: end if;
863: if (X_MODE = 'R') then
864: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
865: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;