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.IGF_AW_AWARD_PKG dependencies on APP_EXCEPTION

Line 154: app_exception.raise_exception;

150: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
151: CLOSE cur_old_ref_values;
152: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
153: igs_ge_msg_stack.add;
154: app_exception.raise_exception;
155: RETURN;
156: END IF;
157: CLOSE cur_old_ref_values;
158:

Line 261: app_exception.raise_exception;

257: );
258: IF l_v_message_name IS NOT NULL THEN
259: fnd_message.set_name ('IGS',l_v_message_name);
260: igs_ge_msg_stack.add;
261: app_exception.raise_exception;
262: END IF;
263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
264: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'fund code = '||l_v_fed_fund_code );
265: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'g_v_called_from = '||g_v_called_from );

Line 329: app_exception.raise_exception;

325: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
326: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_awd_chg_rec returned error '|| l_v_message_name);
327: END IF;
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: END IF;
331: END IF;
332: -- invoke the procedure to create reinstatement change record in igf_sl_clchsn_dtls table
333: IF ((old_references.accepted_amt <> new_references.accepted_amt) AND

Line 360: app_exception.raise_exception;

356: igs_ge_msg_stack.add;
357: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
358: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_awd_chg_rec returned error '|| l_v_message_name);
359: END IF;
360: app_exception.raise_exception;
361: END IF;
362: END IF;
363: END IF;
364: END AfterRowInsertUpdateDelete1;

Line 430: app_exception.raise_exception;

426: new_references.rvsn_id
427: ) THEN
428: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
429: igs_ge_msg_stack.add;
430: app_exception.raise_exception;
431: END IF;
432:
433: IF (((old_references.fund_id = new_references.fund_id)) OR ((new_references.fund_id IS NULL))) THEN
434: FOR i IN 1..200 LOOP

Line 452: app_exception.raise_exception;

448:
449: IF NOT x_lock THEN
450: fnd_message.set_name ('IGF', 'IGF_AW_FUND_LOCK_ERR');
451: igs_ge_msg_stack.add;
452: app_exception.raise_exception;
453: END IF;
454: ELSE
455:
456: FOR i IN 1..200 LOOP

Line 474: app_exception.raise_exception;

470:
471: IF NOT x_lock THEN
472: fnd_message.set_name ('IGF', 'IGF_AW_FUND_LOCK_ERR');
473: igs_ge_msg_stack.add;
474: app_exception.raise_exception;
475: END IF;
476: END IF;
477:
478: IF (((old_references.base_id = new_references.base_id)) OR

Line 486: app_exception.raise_exception;

482: new_references.base_id
483: ) THEN
484: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
485: igs_ge_msg_stack.add;
486: app_exception.raise_exception;
487: END IF;
488:
489: IF (((old_references.adplans_id = new_references.adplans_id)) OR
490: ((new_references.adplans_id IS NULL))) THEN

Line 497: app_exception.raise_exception;

493: new_references.adplans_id
494: ) THEN
495: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: END IF;
499:
500: END check_parent_existance;
501:

Line 619: app_exception.raise_exception;

615: IF (cur_rowid%FOUND) THEN
616: CLOSE cur_rowid;
617: fnd_message.set_name ('IGF', 'IGF_AW_RVSN_AWD_FK');
618: igs_ge_msg_stack.add;
619: app_exception.raise_exception;
620: RETURN;
621: END IF;
622: CLOSE cur_rowid;
623:

Line 654: app_exception.raise_exception;

650: IF (cur_rowid%FOUND) THEN
651: CLOSE cur_rowid;
652: fnd_message.set_name ('IGF', 'IGF_AW_AWD_FMAST_FK');
653: igs_ge_msg_stack.add;
654: app_exception.raise_exception;
655: RETURN;
656: END IF;
657: CLOSE cur_rowid;
658:

Line 689: app_exception.raise_exception;

685: IF (cur_rowid%FOUND) THEN
686: CLOSE cur_rowid;
687: fnd_message.set_name ('IGF', 'IGF_AW_AWD_FA_DETAIL_FK');
688: igs_ge_msg_stack.add;
689: app_exception.raise_exception;
690: RETURN;
691: END IF;
692: CLOSE cur_rowid;
693:

Line 726: app_exception.raise_exception;

722: IF (cur_rowid%FOUND) THEN
723: CLOSE cur_rowid;
724: fnd_message.set_name ('IGF', 'IGF_AW_AWD_ADPLANS_FK');
725: igs_ge_msg_stack.add;
726: app_exception.raise_exception;
727: RETURN;
728: END IF;
729: CLOSE cur_rowid;
730: END get_fk_igf_aw_awd_dist_plans;

Line 860: app_exception.raise_exception;

856: )
857: ) THEN
858: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
859: igs_ge_msg_stack.add;
860: app_exception.raise_exception;
861: END IF;
862: check_parent_existance;
863: ELSIF (p_action = 'UPDATE') THEN
864: -- Call all the procedures related to Before Update.

Line 877: app_exception.raise_exception;

873: )
874: ) THEN
875: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
876: igs_ge_msg_stack.add;
877: app_exception.raise_exception;
878: END IF;
879: ELSIF (p_action = 'VALIDATE_DELETE') THEN
880: check_child_existance;
881: END IF;

Line 1006: App_Exception.Raise_Exception;

1002: WHEN OTHERS THEN
1003: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1004: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_award_pkg.update_award_history' || SQLERRM);
1005: IGS_GE_MSG_STACK.ADD;
1006: App_Exception.Raise_Exception;
1007: END update_award_history;
1008:
1009:
1010: PROCEDURE after_dml (

Line 1156: app_exception.raise_exception;

1152: END IF;
1153: ELSE
1154: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1155: igs_ge_msg_stack.add;
1156: app_exception.raise_exception;
1157: END IF;
1158:
1159: SELECT igf_aw_award_s.nextval INTO x_award_id FROM dual;
1160:

Line 1354: App_Exception.Raise_Exception;

1350: WHEN OTHERS THEN
1351: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1352: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_award_pkg.insert_row' || SQLERRM);
1353: IGS_GE_MSG_STACK.ADD;
1354: App_Exception.Raise_Exception;
1355: END insert_row;
1356:
1357:
1358: PROCEDURE lock_row (

Line 1474: app_exception.raise_exception;

1470: IF (c1%notfound) THEN
1471: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1472: igs_ge_msg_stack.add;
1473: CLOSE c1;
1474: app_exception.raise_exception;
1475: RETURN;
1476: END IF;
1477: CLOSE c1;
1478:

Line 1528: app_exception.raise_exception;

1524: NULL;
1525: ELSE
1526: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1527: igs_ge_msg_stack.add;
1528: app_exception.raise_exception;
1529: END IF;
1530:
1531: RETURN;
1532:

Line 1651: app_exception.raise_exception;

1647: END IF;
1648: ELSE
1649: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1650: igs_ge_msg_stack.add;
1651: app_exception.raise_exception;
1652: END IF;
1653:
1654: before_dml(
1655: p_action => 'UPDATE',