859: EXCEPTION WHEN OTHERS THEN
860: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
861: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_gen.check_lend_relation.exception',SQLERRM);
862: END IF;
863: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
864: fnd_message.set_token('NAME','IGF_SL_GEN.CHECK_LEND_RELATION');
865: igs_ge_msg_stack.conc_exception_hndl;
866: app_exception.raise_exception;
867:
860: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
861: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_gen.check_lend_relation.exception',SQLERRM);
862: END IF;
863: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
864: fnd_message.set_token('NAME','IGF_SL_GEN.CHECK_LEND_RELATION');
865: igs_ge_msg_stack.conc_exception_hndl;
866: app_exception.raise_exception;
867:
868: END check_lend_relation;
1171: EXCEPTION WHEN OTHERS THEN
1172: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1173: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_gen.get_person_details.exception',SQLERRM);
1174: END IF;
1175: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1176: fnd_message.set_token('NAME','IGF_SL_GEN.GET_PERSON_DETAILS');
1177: igs_ge_msg_stack.conc_exception_hndl;
1178: app_exception.raise_exception;
1179:
1172: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1173: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_gen.get_person_details.exception',SQLERRM);
1174: END IF;
1175: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1176: fnd_message.set_token('NAME','IGF_SL_GEN.GET_PERSON_DETAILS');
1177: igs_ge_msg_stack.conc_exception_hndl;
1178: app_exception.raise_exception;
1179:
1180: END get_person_details;
1261: EXCEPTION WHEN OTHERS THEN
1262: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1263: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_gen.check_rel.exception',SQLERRM);
1264: END IF;
1265: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1266: fnd_message.set_token('NAME','IGF_SL_GEN.CHECK_REL');
1267: igs_ge_msg_stack.conc_exception_hndl;
1268: app_exception.raise_exception;
1269:
1262: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1263: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_gen.check_rel.exception',SQLERRM);
1264: END IF;
1265: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1266: fnd_message.set_token('NAME','IGF_SL_GEN.CHECK_REL');
1267: igs_ge_msg_stack.conc_exception_hndl;
1268: app_exception.raise_exception;
1269:
1270: END check_rel;
1480: END IF;
1481:
1482: x_return_status := 'E';
1483: x_msg_data := 'IGF_AP_NO_PERSON_ORG';
1484: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1485: fnd_message.set_token('NAME', 'IGF_GR_GEN.GET_ASSOCIATED_ORG'||' '||SQLERRM);
1486: igs_ge_msg_stack.add;
1487: app_exception.raise_exception;
1488: END get_associated_org;
1481:
1482: x_return_status := 'E';
1483: x_msg_data := 'IGF_AP_NO_PERSON_ORG';
1484: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1485: fnd_message.set_token('NAME', 'IGF_GR_GEN.GET_ASSOCIATED_ORG'||' '||SQLERRM);
1486: igs_ge_msg_stack.add;
1487: app_exception.raise_exception;
1488: END get_associated_org;
1489:
1656: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1657: THEN
1658: fnd_log.string( fnd_log.level_exception, 'igf_sl_gen.get_fed_fund_code exception', SQLERRM);
1659: END IF;
1660: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1661: fnd_message.set_token('NAME','igf_sl_gen.get_fed_fund_code');
1662: igs_ge_msg_stack.add;
1663: app_exception.raise_exception;
1664:
1657: THEN
1658: fnd_log.string( fnd_log.level_exception, 'igf_sl_gen.get_fed_fund_code exception', SQLERRM);
1659: END IF;
1660: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1661: fnd_message.set_token('NAME','igf_sl_gen.get_fed_fund_code');
1662: igs_ge_msg_stack.add;
1663: app_exception.raise_exception;
1664:
1665: END get_fed_fund_code;
1724: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1725: THEN
1726: fnd_log.string( fnd_log.level_exception, 'igf_sl_gen.check_prc_chg exception', SQLERRM);
1727: END IF;
1728: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1729: fnd_message.set_token('NAME','igf_sl_gen.check_prc_chg');
1730: igs_ge_msg_stack.add;
1731: app_exception.raise_exception;
1732: END check_prc_chg;
1725: THEN
1726: fnd_log.string( fnd_log.level_exception, 'igf_sl_gen.check_prc_chg exception', SQLERRM);
1727: END IF;
1728: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1729: fnd_message.set_token('NAME','igf_sl_gen.check_prc_chg');
1730: igs_ge_msg_stack.add;
1731: app_exception.raise_exception;
1732: END check_prc_chg;
1733:
1789: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1790: THEN
1791: fnd_log.string( fnd_log.level_exception, 'igf_sl_gen.check_prc_chgm exception', SQLERRM);
1792: END IF;
1793: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1794: fnd_message.set_token('NAME','igf_sl_gen.check_prc_chgm');
1795: igs_ge_msg_stack.add;
1796: app_exception.raise_exception;
1797: END check_prc_chgm;
1790: THEN
1791: fnd_log.string( fnd_log.level_exception, 'igf_sl_gen.check_prc_chgm exception', SQLERRM);
1792: END IF;
1793: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1794: fnd_message.set_token('NAME','igf_sl_gen.check_prc_chgm');
1795: igs_ge_msg_stack.add;
1796: app_exception.raise_exception;
1797: END check_prc_chgm;
1798: