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 FND_LOG

Line 851: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

847: OPEN c_chk_overlap_date(p_person_id,p_start_date,p_end_date);
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

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 860: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

856: p_message := 'IGF_SL_PREF_LEND_DATES';
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');

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 1136: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1132: OPEN c_get_emailaddr(p_person_id,'Y','A','EMAIL');
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.

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 1172: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1168:
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');

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 1251: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1247: OPEN c_chk_rel_code3(p_rel_code);
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

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 1262: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1258: p_flag := 'TRUE';
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');

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 1386: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1382:
1383: -- obtain the person_id from the base_id value
1384: l_person_id := igf_gr_gen.get_person_id(p_base_id);
1385:
1386: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1387: g_debug_string := 'Base ID = ' || p_base_id || ' Person ID = ' || l_person_id;
1388: END IF;
1389:
1390: -- determine the key program from the api. the key program is returned if the term has a

Line 1393: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1389:
1390: -- determine the key program from the api. the key program is returned if the term has a
1391: -- key program override at a term level, otherwise the key program at the spa table is returned
1392: igf_ap_gen_001.get_key_program(p_base_id, x_key_program_course_cd, x_version_number);
1393: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1394: g_debug_string := g_debug_string || 'key program = ' || x_key_program_course_cd || ' version number = '||x_version_number ||':: ';
1395: END IF;
1396: IF(x_key_program_course_cd IS NOT NULL AND l_person_id IS NOT NULL)THEN
1397: OPEN c_get_org_enr(x_key_program_course_cd, x_version_number);

Line 1401: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1397: OPEN c_get_org_enr(x_key_program_course_cd, x_version_number);
1398: FETCH c_get_org_enr INTO c_get_org_enr_rec;
1399: CLOSE c_get_org_enr;
1400:
1401: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1402: g_debug_string := g_debug_string || 'Org Unit Code(from key program) = ' || c_get_org_enr_rec.org_unit_cd || ' :: ';
1403: END IF;
1404:
1405: IF (c_get_org_enr_rec.org_unit_cd IS NOT NULL) THEN -- means, student is having key program.

Line 1437: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1433:
1434: x_module := 'AD';
1435: x_org_unit_cd := c_get_org_adm_rec.responsible_org_unit_cd;
1436: x_org_party_id := c_get_org_adm_rec.party_id;
1437: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1438: g_debug_string := g_debug_string || 'Org Unit Code(from no_of_applications) = ' || c_get_org_adm_rec.responsible_org_unit_cd || ' :: ';
1439: END IF;
1440: RETURN;
1441: ELSE -- means more than one instance. Applications may be one or more. So get org from FA Base.

Line 1448: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1444: OPEN c_get_assoc_org;
1445: FETCH c_get_assoc_org INTO c_get_assoc_org_rec;
1446: CLOSE c_get_assoc_org;
1447:
1448: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1449: g_debug_string := g_debug_string || 'Org Unit Code(from FA Base Record form) = ' || c_get_assoc_org_rec.party_number || ' :: ';
1450: END IF;
1451:
1452: IF (c_get_assoc_org_rec.party_number IS NOT NULL) THEN

Line 1457: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1453: x_module := 'FA';
1454: x_org_unit_cd := c_get_assoc_org_rec.party_number;
1455: x_org_party_id := c_get_assoc_org_rec.assoc_org_num;
1456: ELSE -- means more than one instances and FA Base record says nothing about associated org.
1457: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1458: g_debug_string := g_debug_string || 'Org Unit Code is not derived';
1459: END IF;
1460: x_return_status := 'E';
1461: x_msg_data := 'IGF_AP_NO_PERSON_ORG';

Line 1470: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1466: x_msg_data := 'IGF_AP_NO_PERSON_ORG';
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

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 1478: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1474: EXCEPTION
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';

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 1535: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1531: l_org_party_id hz_parties.party_id%TYPE;
1532:
1533: BEGIN
1534:
1535: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1536: g_debug_string := 'Base ID = ' || p_base_id || ' :: Office Type = ' || p_office_type;
1537: END IF;
1538:
1539: IF (p_base_id IS NOT NULL AND p_office_type IS NOT NULL) THEN

Line 1543: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1539: IF (p_base_id IS NOT NULL AND p_office_type IS NOT NULL) THEN
1540:
1541: get_associated_org(p_base_id, l_org_unit_cd, l_org_party_id, l_module, l_ret_status, l_msg_data);
1542:
1543: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1544: g_debug_string := g_debug_string || 'associated org = ' || l_org_unit_cd || ' l_module = '||l_module ||':: ';
1545: END IF;
1546:
1547: IF (l_ret_status = 'E' AND l_msg_data IS NOT NULL) THEN

Line 1555: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1551: OPEN c_get_fa_office(l_org_unit_cd, p_office_type);
1552: FETCH c_get_fa_office INTO c_get_fa_office_rec;
1553: CLOSE c_get_fa_office;
1554:
1555: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1556: g_debug_string := g_debug_string || ' Office ID = ' || c_get_fa_office_rec.office_cd;
1557: END IF;
1558:
1559: IF (c_get_fa_office_rec.office_cd IS NOT NULL) THEN

Line 1588: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1584: ELSE
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

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 1594: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1590: END IF;
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';

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 1656: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1652: p_v_message_name := NULL;
1653: RETURN l_v_fed_fund_code;
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');

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 1724: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1720: CLOSE c_loan_num;
1721: RETURN FALSE;
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');

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 1789: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1785: CLOSE c_loan_num;
1786: RETURN FALSE;
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');

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 1929: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1925: lv_chg_status := 'N';
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);

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 2093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2089: -- Current term has anticipated data
2090: lv_ant_org_unit_cd := lv_ant_data_curr_term_rec.org_unit_cd;
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||

Line 2094: fnd_log.string(fnd_log.level_statement,

2090: lv_ant_org_unit_cd := lv_ant_data_curr_term_rec.org_unit_cd;
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);

Line 2116: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2112: IF (lv_ant_data_all_terms_rec.org_unit_cd IS NOT NULL) THEN
2113: lv_ant_org_unit_cd := lv_ant_data_all_terms_rec.org_unit_cd;
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||

Line 2117: fnd_log.string(fnd_log.level_statement,

2113: lv_ant_org_unit_cd := lv_ant_data_all_terms_rec.org_unit_cd;
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);

Line 2133: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2129: IF (c_get_ant_org_unit%FOUND) THEN
2130: lv_ant_org_unit_cd := l_get_ant_org_unit_rec.responsible_org_unit_cd;
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||

Line 2134: fnd_log.string(fnd_log.level_statement,

2130: lv_ant_org_unit_cd := l_get_ant_org_unit_rec.responsible_org_unit_cd;
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);

Line 2179: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2175: x_msg_data := NULL;
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:

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;