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_SL_GEN dependencies on IGF_SL_GEN

Line 1: PACKAGE BODY igf_sl_gen AS

1: PACKAGE BODY igf_sl_gen AS
2: /* $Header: IGFSL12B.pls 120.4 2006/08/07 13:21:12 azmohamm ship $ */
3:
4:
5: ------------------------------------------------------------------------

Line 498: igf_sl_gen.get_associated_org(p_base_id, l_v_party_number, l_v_org_party_id, l_v_module, l_v_return_status, l_v_msg_data);

494: l_v_msg_data VARCHAR2(1024);
495:
496: BEGIN
497: -- Get Associated Org Id
498: igf_sl_gen.get_associated_org(p_base_id, l_v_party_number, l_v_org_party_id, l_v_module, l_v_return_status, l_v_msg_data);
499:
500: OPEN cur_cl_version( p_ci_cal_type, p_ci_seq_num, p_relationship_cd, l_v_org_party_id);
501: FETCH cur_cl_version INTO lv_cl_version;
502: CLOSE cur_cl_version;

Line 852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.check_lend_relation.debug','After the cursor to check overlapping dates');

848: FETCH c_chk_overlap_date INTO l_chk_overlap_date;
849: CLOSE c_chk_overlap_date;
850: -- add a message to the logging framework
851: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.check_lend_relation.debug','After the cursor to check overlapping dates');
853: END IF;
854:
855: IF l_chk_overlap_date.cnt IS NOT NULL AND l_chk_overlap_date.cnt > 1 THEN
856: p_message := 'IGF_SL_PREF_LEND_DATES';

Line 861: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_gen.check_lend_relation.exception',SQLERRM);

857: END IF;
858:
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;

Line 864: fnd_message.set_token('NAME','IGF_SL_GEN.CHECK_LEND_RELATION');

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;

Line 1137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_person_details.debug','Before opening the ref cursor');

1133: FETCH c_get_emailaddr INTO l_get_emailaddr;
1134: CLOSE c_get_emailaddr;
1135: -- add a message to the logging framework
1136: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_person_details.debug','Before opening the ref cursor');
1138: END IF;
1139:
1140: -- open the ref cursor with the values obtained from the above cursors.
1141: OPEN p_person_dtl_rec FOR

Line 1173: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_gen.get_person_details.exception',SQLERRM);

1169: FROM DUAL;
1170:
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;

Line 1176: fnd_message.set_token('NAME','IGF_SL_GEN.GET_PERSON_DETAILS');

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;

Line 1252: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.check_rel.debug','After the check of three cursors');

1248: FETCH c_chk_rel_code3 INTO l_chk_rel_code3;
1249: CLOSE c_chk_rel_code3;
1250:
1251: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1252: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.check_rel.debug','After the check of three cursors');
1253: END IF;
1254:
1255: IF l_chk_rel_code1.relationship_cd IS NULL AND l_chk_rel_code2.relationship_cd IS NULL AND l_chk_rel_code3.alt_rel_code IS NULL THEN
1256: p_flag := 'FALSE';

Line 1263: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_gen.check_rel.exception',SQLERRM);

1259: END IF;
1260:
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;

Line 1266: fnd_message.set_token('NAME','IGF_SL_GEN.CHECK_REL');

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;

Line 1471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_associated_org.debug', g_debug_string);

1467: END IF;
1468: END IF;
1469:
1470: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_associated_org.debug', g_debug_string);
1472: END IF;
1473:
1474: EXCEPTION
1475:

Line 1479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_associated_org.debug', SQLERRM);

1475:
1476: WHEN OTHERS THEN
1477:
1478: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_associated_org.debug', SQLERRM);
1480: END IF;
1481:
1482: x_return_status := 'E';
1483: x_msg_data := 'IGF_AP_NO_PERSON_ORG';

Line 1589: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_stu_fao_code.debug', g_debug_string);

1585: x_return_status := 'E';
1586: END IF;
1587:
1588: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1589: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_stu_fao_code.debug', g_debug_string);
1590: END IF;
1591:
1592: EXCEPTION
1593: WHEN OTHERS THEN

Line 1595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_stu_fao_code.debug', SQLERRM);

1591:
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.get_stu_fao_code.debug', SQLERRM);
1596: END IF;
1597:
1598: x_return_status := 'E';
1599: END get_stu_fao_code;

Line 1658: fnd_log.string( fnd_log.level_exception, 'igf_sl_gen.get_fed_fund_code exception', SQLERRM);

1654: EXCEPTION
1655: WHEN OTHERS THEN
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;

Line 1661: fnd_message.set_token('NAME','igf_sl_gen.get_fed_fund_code');

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;

Line 1726: fnd_log.string( fnd_log.level_exception, 'igf_sl_gen.check_prc_chg exception', SQLERRM);

1722: EXCEPTION
1723: WHEN OTHERS THEN
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;

Line 1729: fnd_message.set_token('NAME','igf_sl_gen.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:

Line 1791: fnd_log.string( fnd_log.level_exception, 'igf_sl_gen.check_prc_chgm exception', SQLERRM);

1787: EXCEPTION
1788: WHEN OTHERS THEN
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;

Line 1794: fnd_message.set_token('NAME','igf_sl_gen.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:

Line 1930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.update_cl_chg_status.debug','Loan Change Status = ' || lv_chg_status);

1926: END IF;
1927: CLOSE c_clchsn4;
1928: END IF;
1929: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1930: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_gen.update_cl_chg_status.debug','Loan Change Status = ' || lv_chg_status);
1931: END IF;
1932: IF lv_chg_status <> '*' THEN
1933: OPEN c_sl_loans(p_v_loan_number);
1934: FETCH c_sl_loans INTO rec_c_sl_loans;

Line 2095: 'igf.plsql.igf_sl_gen.get_stu_ant_fao_code',

2091:
2092: -- Log values
2093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2094: fnd_log.string(fnd_log.level_statement,
2095: 'igf.plsql.igf_sl_gen.get_stu_ant_fao_code',
2096: 'Found anticipated Org Unit for the current term. Org Unit: ' ||lv_ant_org_unit_cd||
2097: ', ld_cal_type: ' ||lv_ant_data_curr_term_rec.ld_cal_type||
2098: ', ld_sequence_number: ' ||lv_ant_data_curr_term_rec.ld_sequence_number);
2099: END IF;

Line 2118: 'igf.plsql.igf_sl_gen.get_stu_ant_fao_code',

2114:
2115: -- Log values
2116: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2117: fnd_log.string(fnd_log.level_statement,
2118: 'igf.plsql.igf_sl_gen.get_stu_ant_fao_code',
2119: 'Found anticipated Org Unit in one of the terms in the award year. Org Unit: ' ||lv_ant_org_unit_cd||
2120: ', ld_cal_type: ' ||lv_ant_data_all_terms_rec.ld_cal_type||
2121: ', ld_sequence_number: ' ||lv_ant_data_all_terms_rec.ld_sequence_number);
2122: END IF;

Line 2135: 'igf.plsql.igf_sl_gen.get_stu_ant_fao_code',

2131:
2132: -- Log values
2133: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2134: fnd_log.string(fnd_log.level_statement,
2135: 'igf.plsql.igf_sl_gen.get_stu_ant_fao_code',
2136: 'Found Org Unit for the anticipated key program. Org Unit: ' ||lv_ant_org_unit_cd||
2137: ', Key prog: ' ||l_get_ant_org_unit_rec.course_cd||
2138: ', Version: ' ||l_get_ant_org_unit_rec.version_number);
2139: END IF;

Line 2180: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_gen.get_stu_ant_fao_code', 'Anticipated Org Unit not defined');

2176: END IF;
2177:
2178: -- Log values
2179: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2180: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_gen.get_stu_ant_fao_code', 'Anticipated Org Unit not defined');
2181: END IF;
2182: END IF;
2183:
2184: END get_stu_ant_fao_code;

Line 2186: END igf_sl_gen;

2182: END IF;
2183:
2184: END get_stu_ant_fao_code;
2185:
2186: END igf_sl_gen;