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

Line 66: app_exception.raise_exception;

62: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
63: CLOSE cur_old_ref_values;
64: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
65: igs_ge_msg_stack.add;
66: app_exception.raise_exception;
67: RETURN;
68: END IF;
69: CLOSE cur_old_ref_values;
70:

Line 131: app_exception.raise_exception;

127: )
128: ) THEN
129: fnd_message.set_name ('IGS','IGS_FI_ACCT_DUP_SEQ');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133:
134: IF ( get_uk2_for_validation (
135: new_references.fee_type,

Line 156: app_exception.raise_exception;

152: )
153: ) THEN
154: fnd_message.set_name ('IGS', 'IGS_FI_ACCT_ATTR_COMB_EXISTS');
155: igs_ge_msg_stack.add;
156: app_exception.raise_exception;
157: END IF;
158:
159:
160: END check_uniqueness;

Line 191: app_exception.raise_exception;

187: new_references.fee_ci_sequence_number
188: ) THEN
189: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193:
194: IF (((old_references.rev_account_cd = new_references.rev_account_cd)) OR
195: ((new_references.rev_account_cd IS NULL))) THEN

Line 202: app_exception.raise_exception;

198: new_references.rev_account_cd
199: ) THEN
200: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: END IF;
204:
205: IF (((old_references.location_cd = new_references.location_cd)) OR
206: ((new_references.location_cd IS NULL))) THEN

Line 214: app_exception.raise_exception;

210: 'N'
211: ) THEN
212: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
213: igs_ge_msg_stack.add;
214: app_exception.raise_exception;
215: END IF;
216:
217: IF (((old_references.attendance_type = new_references.attendance_type)) OR
218: ((new_references.attendance_type IS NULL))) THEN

Line 225: app_exception.raise_exception;

221: new_references.attendance_type
222: ) THEN
223: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
224: igs_ge_msg_stack.add;
225: app_exception.raise_exception;
226: END IF;
227:
228: IF (((old_references.attendance_mode = new_references.attendance_mode)) OR
229: ((new_references.attendance_mode IS NULL))) THEN

Line 236: app_exception.raise_exception;

232: new_references.attendance_mode
233: ) THEN
234: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238:
239: IF (((old_references.course_cd = new_references.course_cd) AND
240: (old_references.crs_version_number = new_references.crs_version_number)) OR

Line 250: app_exception.raise_exception;

246: new_references.crs_version_number
247: ) THEN
248: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
249: igs_ge_msg_stack.add;
250: app_exception.raise_exception;
251: END IF;
252:
253: IF (((old_references.unit_cd = new_references.unit_cd) AND
254: (old_references.unit_version_number = new_references.unit_version_number)) OR

Line 264: app_exception.raise_exception;

260: new_references.unit_version_number
261: ) THEN
262: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: END IF;
266:
267: IF (((old_references.uoo_id = new_references.uoo_id)) OR
268: ((new_references.uoo_id IS NULL))) THEN

Line 275: app_exception.raise_exception;

271: new_references.uoo_id
272: ) THEN
273: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
274: igs_ge_msg_stack.add;
275: app_exception.raise_exception;
276: END IF;
277:
278: IF (((old_references.unit_level = new_references.unit_level)) OR
279: ((new_references.unit_level IS NULL))) THEN

Line 286: app_exception.raise_exception;

282: new_references.unit_level
283: ) THEN
284: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
288:
289: IF (((old_references.unit_type_id = new_references.unit_type_id)) OR
290: ((new_references.unit_type_id IS NULL))) THEN

Line 297: app_exception.raise_exception;

293: new_references.unit_type_id
294: ) THEN
295: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: END IF;
299:
300: IF (((old_references.unit_mode = new_references.unit_mode)) OR
301: ((new_references.unit_mode IS NULL))) THEN

Line 308: app_exception.raise_exception;

304: new_references.unit_mode
305: ) THEN
306: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310:
311: IF (((old_references.unit_class = new_references.unit_class)) OR
312: ((new_references.unit_class IS NULL))) THEN

Line 319: app_exception.raise_exception;

315: new_references.unit_class
316: ) THEN
317: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: END IF;
321:
322: END check_parent_existance;
323:

Line 497: app_exception.raise_exception;

493: IF (cur_rowid%FOUND) THEN
494: CLOSE cur_rowid;
495: fnd_message.set_name ('IGS', 'IGS_FI_FICA_FTCI_FK');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: RETURN;
499: END IF;
500: CLOSE cur_rowid;
501:

Line 532: app_exception.raise_exception;

528: IF (cur_rowid%FOUND) THEN
529: CLOSE cur_rowid;
530: fnd_message.set_name ('IGS', 'IGS_FI_FICA_ACC_FK');
531: igs_ge_msg_stack.add;
532: app_exception.raise_exception;
533: RETURN;
534: END IF;
535: CLOSE cur_rowid;
536:

Line 567: app_exception.raise_exception;

563: IF (cur_rowid%FOUND) THEN
564: CLOSE cur_rowid;
565: fnd_message.set_name ('IGS', 'IGS_FI_FICA_LOC_FK');
566: igs_ge_msg_stack.add;
567: app_exception.raise_exception;
568: RETURN;
569: END IF;
570: CLOSE cur_rowid;
571:

Line 602: app_exception.raise_exception;

598: IF (cur_rowid%FOUND) THEN
599: CLOSE cur_rowid;
600: fnd_message.set_name ('IGS', 'IGS_FI_FICA_ATT_FK');
601: igs_ge_msg_stack.add;
602: app_exception.raise_exception;
603: RETURN;
604: END IF;
605: CLOSE cur_rowid;
606:

Line 637: app_exception.raise_exception;

633: IF (cur_rowid%FOUND) THEN
634: CLOSE cur_rowid;
635: fnd_message.set_name ('IGS', 'IGS_FI_FICA_AM_FK');
636: igs_ge_msg_stack.add;
637: app_exception.raise_exception;
638: RETURN;
639: END IF;
640: CLOSE cur_rowid;
641:

Line 674: app_exception.raise_exception;

670: IF (cur_rowid%FOUND) THEN
671: CLOSE cur_rowid;
672: fnd_message.set_name ('IGS', 'IGS_FI_FICA_SCA_FK');
673: igs_ge_msg_stack.add;
674: app_exception.raise_exception;
675: RETURN;
676: END IF;
677: CLOSE cur_rowid;
678:

Line 710: app_exception.raise_exception;

706: IF (cur_rowid%FOUND) THEN
707: CLOSE cur_rowid;
708: fnd_message.set_name ('IGS', 'IGS_FI_FICA_UN_FK');
709: igs_ge_msg_stack.add;
710: app_exception.raise_exception;
711: RETURN;
712: END IF;
713: CLOSE cur_rowid;
714:

Line 747: app_exception.raise_exception;

743: IF (cur_rowid%FOUND) THEN
744: CLOSE cur_rowid;
745: fnd_message.set_name ('IGS', 'IGS_FI_FICA_UOO_FK');
746: igs_ge_msg_stack.add;
747: app_exception.raise_exception;
748: RETURN;
749: END IF;
750: CLOSE cur_rowid;
751:

Line 781: app_exception.raise_exception;

777: IF (cur_rowid%FOUND) THEN
778: CLOSE cur_rowid;
779: fnd_message.set_name ('IGS', 'IGS_FI_ACCTS_UM_FK');
780: igs_ge_msg_stack.add;
781: app_exception.raise_exception;
782: RETURN;
783: END IF;
784: CLOSE cur_rowid;
785:

Line 872: app_exception.raise_exception;

868: )
869: ) THEN
870: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
871: igs_ge_msg_stack.add;
872: app_exception.raise_exception;
873: END IF;
874: check_uniqueness;
875: check_parent_existance;
876: ELSIF (p_action = 'UPDATE') THEN

Line 888: app_exception.raise_exception;

884: )
885: ) THEN
886: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
887: igs_ge_msg_stack.add;
888: app_exception.raise_exception;
889: END IF;
890: check_uniqueness;
891: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
892: check_uniqueness;

Line 975: app_exception.raise_exception;

971: ELSE
972: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
973: fnd_message.set_token ('ROUTINE', 'IGS_FI_FTCI_ACCTS_PKG.INSERT_ROW');
974: igs_ge_msg_stack.add;
975: app_exception.raise_exception;
976: END IF;
977:
978: SELECT igs_fi_ftci_accts_s.NEXTVAL INTO x_acct_id FROM dual;
979:

Line 1148: app_exception.raise_exception;

1144: IF (c1%notfound) THEN
1145: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1146: igs_ge_msg_stack.add;
1147: CLOSE c1;
1148: app_exception.raise_exception;
1149: RETURN;
1150: END IF;
1151: CLOSE c1;
1152:

Line 1179: app_exception.raise_exception;

1175: NULL;
1176: ELSE
1177: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1178: igs_ge_msg_stack.add;
1179: app_exception.raise_exception;
1180: END IF;
1181:
1182: RETURN;
1183:

Line 1249: app_exception.raise_exception;

1245: ELSE
1246: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1247: fnd_message.set_token ('ROUTINE', 'IGS_FI_FTCI_ACCTS_PKG.UPDATE_ROW');
1248: igs_ge_msg_stack.add;
1249: app_exception.raise_exception;
1250: END IF;
1251:
1252: before_dml(
1253: p_action => 'UPDATE',