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

Line 80: app_exception.raise_exception;

76: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
77: CLOSE cur_old_ref_values;
78: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
79: igs_ge_msg_stack.add;
80: app_exception.raise_exception;
81: RETURN;
82: END IF;
83: CLOSE cur_old_ref_values;
84:

Line 161: APP_EXCEPTION.RAISE_EXCEPTION;

157: new_references.program_cd
158: ) THEN
159: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
160: IGS_GE_MSG_STACK.ADD;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162: END IF;
163:
164: IF (((old_references.TERM_CAL_TYPE = new_references.TERM_CAL_TYPE) AND
165: (old_references.TERM_SEQUENCE_NUMBER = new_references.TERM_SEQUENCE_NUMBER)) OR

Line 175: App_Exception.Raise_Exception;

171: new_references.TERM_SEQUENCE_NUMBER
172: ) THEN
173: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177:
178: IF (((old_references.coo_id = new_references.coo_id)) OR
179: ((new_references.coo_id IS NULL))) THEN

Line 187: App_Exception.Raise_Exception;

183: new_references.coo_id
184: ) THEN
185: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: END IF;
190:
191: IF (((old_references.fee_cat = new_references.fee_cat)) OR

Line 199: App_Exception.Raise_Exception;

195: new_references.fee_cat
196: ) THEN
197: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201:
202: IF ((old_references.CLASS_STANDING_ID = new_references.CLASS_STANDING_ID)OR
203: (new_references.CLASS_STANDING_ID IS NULL)) THEN

Line 210: App_Exception.Raise_Exception;

206: new_references.CLASS_STANDING_ID
207: ) THEN
208: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212:
213:
214: END Check_Parent_Existance;

Line 246: App_Exception.Raise_Exception;

242: IF (cur_rowid%FOUND) THEN
243: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_CI_FK');
244: Igs_Ge_Msg_Stack.ADD;
245: CLOSE cur_rowid;
246: App_Exception.Raise_Exception;
247: RETURN;
248: END IF;
249: CLOSE cur_rowid;
250: END GET_FK_IGS_CA_INST;

Line 278: APP_EXCEPTION.RAISE_EXCEPTION;

274: IF (cur_rowid%FOUND) THEN
275: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_SPA_FK');
276: IGS_GE_MSG_STACK.ADD;
277: CLOSE cur_rowid;
278: APP_EXCEPTION.RAISE_EXCEPTION;
279: RETURN;
280: END IF;
281: CLOSE cur_rowid;
282: END GET_FK_IGS_EN_STDNT_PS_ATT;

Line 310: App_Exception.Raise_Exception;

306: IF (cur_rowid%FOUND) THEN
307: CLOSE cur_rowid;
308: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_CS_FK');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: RETURN;
312: END IF;
313: CLOSE cur_rowid;
314: END GET_FK_IGS_PR_CLASS_STD;

Line 340: App_Exception.Raise_Exception;

336: IF (cur_rowid%FOUND) THEN
337: CLOSE cur_rowid;
338: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_FC_FK');
339: IGS_GE_MSG_STACK.ADD;
340: App_Exception.Raise_Exception;
341: RETURN;
342: END IF;
343: CLOSE cur_rowid;
344: END GET_FK_IGS_FI_FEE_CAT;

Line 370: App_Exception.Raise_Exception;

366: IF (cur_rowid%FOUND) THEN
367: CLOSE cur_rowid;
368: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_COO_FK');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: RETURN;
372: END IF;
373: CLOSE cur_rowid;
374: END GET_UFK_IGS_PS_OFR_OPT;

Line 641: app_exception.raise_exception;

637: )
638: ) THEN
639: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
640: igs_ge_msg_stack.add;
641: app_exception.raise_exception;
642: END IF;
643:
644: -- Code added by ckasu as a part of
645: -- bug no #3631488 inorder to create TODO record in both Parent

Line 660: app_exception.raise_exception;

656: )
657: ) THEN
658: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
659: igs_ge_msg_stack.add;
660: app_exception.raise_exception;
661: END IF;
662: ELSIF (p_action = 'DELETE') THEN
663: check_child_existence(new_references.person_id,new_references.program_cd);
664:

Line 685: app_exception.raise_exception;

681: IF (cur_rowid%NOTFOUND) THEN
682: CLOSE cur_rowid;
683: fnd_message.set_name('IGS','IGS_AD_NOMINATED_PRG_NOTEXIST');
684: igs_ge_msg_stack.add;
685: app_exception.raise_exception;
686: END IF;
687: CLOSE cur_rowid;
688: END IF;
689:

Line 785: app_exception.raise_exception;

781: ELSE
782: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
783: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.INSERT_ROW');
784: igs_ge_msg_stack.add;
785: app_exception.raise_exception;
786: END IF;
787:
788: x_term_record_id := NULL;
789:

Line 945: app_exception.raise_exception;

941: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
942: fnd_message.set_token ('ERR_CD', SQLCODE);
943: igs_ge_msg_stack.add;
944: igs_sc_gen_001.unset_ctx('R');
945: app_exception.raise_exception;
946: ELSE
947: igs_sc_gen_001.unset_ctx('R');
948: RAISE;
949: END IF;

Line 1052: app_exception.raise_exception;

1048: IF (c1%notfound) THEN
1049: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1050: igs_ge_msg_stack.add;
1051: CLOSE c1;
1052: app_exception.raise_exception;
1053: RETURN;
1054: END IF;
1055: CLOSE c1;
1056:

Line 1098: app_exception.raise_exception;

1094: NULL;
1095: ELSE
1096: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1097: igs_ge_msg_stack.add;
1098: app_exception.raise_exception;
1099: END IF;
1100:
1101: RETURN;
1102:

Line 1182: app_exception.raise_exception;

1178: ELSE
1179: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1180: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.UPDATE_ROW');
1181: igs_ge_msg_stack.add;
1182: app_exception.raise_exception;
1183: END IF;
1184:
1185: before_dml(
1186: p_action => 'UPDATE',

Line 1298: app_exception.raise_exception;

1294: IF (SQL%NOTFOUND) THEN
1295: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1296: igs_ge_msg_stack.add;
1297: igs_sc_gen_001.unset_ctx('R');
1298: app_exception.raise_exception;
1299: END IF;
1300: IF (x_mode = 'S') THEN
1301: igs_sc_gen_001.unset_ctx('R');
1302: END IF;

Line 1313: app_exception.raise_exception;

1309: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1310: fnd_message.set_token ('ERR_CD', SQLCODE);
1311: igs_ge_msg_stack.add;
1312: igs_sc_gen_001.unset_ctx('R');
1313: app_exception.raise_exception;
1314: ELSE
1315: igs_sc_gen_001.unset_ctx('R');
1316: RAISE;
1317: END IF;

Line 1500: app_exception.raise_exception;

1496: IF (SQL%NOTFOUND) THEN
1497: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1498: igs_ge_msg_stack.add;
1499: igs_sc_gen_001.unset_ctx('R');
1500: app_exception.raise_exception;
1501: END IF;
1502: IF (x_mode = 'S') THEN
1503: igs_sc_gen_001.unset_ctx('R');
1504: END IF;