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_AP_SS_PKG dependencies on FND_LOG

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

86: FETCH c_isir INTO lv_isir ;
87: IF c_isir%FOUND THEN
88: -- Initialize the package variable with the isir rec values
89: igf_ap_batch_ver_prc_pkg.lp_isir_rec := lv_isir;
90: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetched ISIR Detials for ISIR ID: '||lv_isir.isir_id);
92: END IF;
93:
94: OPEN cur_get_ver_data ( lv_isir.base_id ) ;

Line 91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetched ISIR Detials for ISIR ID: '||lv_isir.isir_id);

87: IF c_isir%FOUND THEN
88: -- Initialize the package variable with the isir rec values
89: igf_ap_batch_ver_prc_pkg.lp_isir_rec := lv_isir;
90: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetched ISIR Detials for ISIR ID: '||lv_isir.isir_id);
92: END IF;
93:
94: OPEN cur_get_ver_data ( lv_isir.base_id ) ;
95: LOOP

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

95: LOOP
96: FETCH cur_get_ver_data INTO l_get_ver_data_rec ;
97: EXIT WHEN cur_get_ver_data%NOTFOUND;
98:
99: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetching verification items Item Name: '||l_get_ver_data_rec.col_name||' value:'||l_get_ver_data_rec.col_val);
101: END IF;
102:
103: EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'

Line 100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetching verification items Item Name: '||l_get_ver_data_rec.col_name||' value:'||l_get_ver_data_rec.col_val);

96: FETCH cur_get_ver_data INTO l_get_ver_data_rec ;
97: EXIT WHEN cur_get_ver_data%NOTFOUND;
98:
99: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetching verification items Item Name: '||l_get_ver_data_rec.col_name||' value:'||l_get_ver_data_rec.col_val);
101: END IF;
102:
103: EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'
104: || l_get_ver_data_rec.col_name || ' := ' || '''' || l_get_ver_data_rec.col_val || '''' || ' ; END;' ;

Line 755: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

751: p_ret_isir_id := -2;
752: ELSE
753: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
754: FND_MESSAGE.SET_TOKEN('NAME','igf_ap_ss_pkg.set_internal_isir');
755: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
756: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_ss_pkg.set_internal_isir.exception','Exception: '||SQLERRM);
757: END IF;
758: IGS_GE_MSG_STACK.ADD;
759: END IF;

Line 756: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_ss_pkg.set_internal_isir.exception','Exception: '||SQLERRM);

752: ELSE
753: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
754: FND_MESSAGE.SET_TOKEN('NAME','igf_ap_ss_pkg.set_internal_isir');
755: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
756: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_ss_pkg.set_internal_isir.exception','Exception: '||SQLERRM);
757: END IF;
758: IGS_GE_MSG_STACK.ADD;
759: END IF;
760: END set_internal_isir;

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

1257: -- Student does not have a Payment ISIR
1258: -- Hence Create Correction Records against the Initial ISIR Being Saved as the Correction Rec.
1259: l_payment_isir_id := p_org_isir_id;
1260:
1261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_ss_pkg.save_as_correction_isir.debug','Corrections generated against Non Payment Original ISIR');
1263: END IF;
1264:
1265: END IF;

Line 1262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_ss_pkg.save_as_correction_isir.debug','Corrections generated against Non Payment Original ISIR');

1258: -- Hence Create Correction Records against the Initial ISIR Being Saved as the Correction Rec.
1259: l_payment_isir_id := p_org_isir_id;
1260:
1261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_ss_pkg.save_as_correction_isir.debug','Corrections generated against Non Payment Original ISIR');
1263: END IF;
1264:
1265: END IF;
1266:

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

1452: x_return_status := FND_API.G_RET_STS_SUCCESS;
1453:
1454: SAVEPOINT SP_ISIR;
1455:
1456: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Starting, Completed initializing the message pub and SAVEPOINT');
1458: END IF;
1459:
1460: OPEN cur_isir_rec ( p_isir_id ) ;

Line 1457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Starting, Completed initializing the message pub and SAVEPOINT');

1453:
1454: SAVEPOINT SP_ISIR;
1455:
1456: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Starting, Completed initializing the message pub and SAVEPOINT');
1458: END IF;
1459:
1460: OPEN cur_isir_rec ( p_isir_id ) ;
1461: FETCH cur_isir_rec INTO isir_rec ;

Line 1467: --IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1463:
1464: -- Bug 4752938: Moved the follwing commented code to set_internal_isir procedure
1465: -- Initialize the package variable with the isir rec values
1466: --igf_ap_batch_ver_prc_pkg.lp_isir_rec := isir_rec;
1467: --IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: -- FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetched ISIR Detials for ISIR ID: '||isir_rec.isir_id);
1469: --END IF;
1470:
1471: --OPEN cur_get_ver_data ( isir_rec.base_id ) ;

Line 1468: -- FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetched ISIR Detials for ISIR ID: '||isir_rec.isir_id);

1464: -- Bug 4752938: Moved the follwing commented code to set_internal_isir procedure
1465: -- Initialize the package variable with the isir rec values
1466: --igf_ap_batch_ver_prc_pkg.lp_isir_rec := isir_rec;
1467: --IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: -- FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetched ISIR Detials for ISIR ID: '||isir_rec.isir_id);
1469: --END IF;
1470:
1471: --OPEN cur_get_ver_data ( isir_rec.base_id ) ;
1472: --LOOP

Line 1476: -- IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1472: --LOOP
1473: -- FETCH cur_get_ver_data INTO l_get_ver_data_rec ;
1474: -- EXIT WHEN cur_get_ver_data%NOTFOUND;
1475:
1476: -- IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1477: -- FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetching verification items Item Name: '||l_get_ver_data_rec.col_name||' value:'||l_get_ver_data_rec.col_val);
1478: -- END IF;
1479:
1480: -- EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'

Line 1477: -- FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetching verification items Item Name: '||l_get_ver_data_rec.col_name||' value:'||l_get_ver_data_rec.col_val);

1473: -- FETCH cur_get_ver_data INTO l_get_ver_data_rec ;
1474: -- EXIT WHEN cur_get_ver_data%NOTFOUND;
1475:
1476: -- IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1477: -- FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','fetching verification items Item Name: '||l_get_ver_data_rec.col_name||' value:'||l_get_ver_data_rec.col_val);
1478: -- END IF;
1479:
1480: -- EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'
1481: -- || l_get_ver_data_rec.col_name || ' := ' || '''' || l_get_ver_data_rec.col_val || '''' || ' ; END;' ;

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

1483: --CLOSE cur_get_ver_data ;
1484:
1485: --isir_rec := igf_ap_batch_ver_prc_pkg.lp_isir_rec;
1486:
1487: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1488: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Before calling main Calculate EFC routine with Ignore Warnings:'||p_ignore_warnings);
1489: END IF;
1490:
1491: igf_ap_efc_calc.calculate_efc(

Line 1488: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Before calling main Calculate EFC routine with Ignore Warnings:'||p_ignore_warnings);

1484:
1485: --isir_rec := igf_ap_batch_ver_prc_pkg.lp_isir_rec;
1486:
1487: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1488: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Before calling main Calculate EFC routine with Ignore Warnings:'||p_ignore_warnings);
1489: END IF;
1490:
1491: igf_ap_efc_calc.calculate_efc(
1492: p_isir_rec => isir_rec,

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

1494: p_sys_batch_yr => p_system_award_year,
1495: p_return_status => x_return_status
1496: );
1497:
1498: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','After calling main Calculate EFC routine Return Status:'||x_return_status);
1500: END IF;
1501:
1502: -- masehgal # 2826603

Line 1499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','After calling main Calculate EFC routine Return Status:'||x_return_status);

1495: p_return_status => x_return_status
1496: );
1497:
1498: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','After calling main Calculate EFC routine Return Status:'||x_return_status);
1500: END IF;
1501:
1502: -- masehgal # 2826603
1503: -- Storing intermediate values for both Success ( "S" ) and Warning ( "W" )

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

1502: -- masehgal # 2826603
1503: -- Storing intermediate values for both Success ( "S" ) and Warning ( "W" )
1504: IF x_return_status IN ('S','W') THEN
1505:
1506: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Updating ISIR Rec since the return status is either W or S');
1508: END IF;
1509:
1510: igf_ap_isir_matched_pkg.update_row(

Line 1507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Updating ISIR Rec since the return status is either W or S');

1503: -- Storing intermediate values for both Success ( "S" ) and Warning ( "W" )
1504: IF x_return_status IN ('S','W') THEN
1505:
1506: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Updating ISIR Rec since the return status is either W or S');
1508: END IF;
1509:
1510: igf_ap_isir_matched_pkg.update_row(
1511: x_rowid => isir_rec.row_id,

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

1824: fnd_message.SET_NAME('IGF','IGF_AP_SUPRESS_REJ_CODE');
1825: l_msg_str := l_msg_str ||' '|| fnd_message.GET;
1826:
1827:
1828: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1829: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Wrapping Warning messages, l_msg_str:'||l_msg_str);
1830: END IF;
1831:
1832: ELSE

Line 1829: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Wrapping Warning messages, l_msg_str:'||l_msg_str);

1825: l_msg_str := l_msg_str ||' '|| fnd_message.GET;
1826:
1827:
1828: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1829: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Wrapping Warning messages, l_msg_str:'||l_msg_str);
1830: END IF;
1831:
1832: ELSE
1833:

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

1835: p_encoded => fnd_api.g_false,
1836: p_count => x_msg_count,
1837: p_data => l_msg_str
1838: );
1839: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1840: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Wrapping Error messages, l_msg_str:'||l_msg_str);
1841: END IF;
1842:
1843: END IF;

Line 1840: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Wrapping Error messages, l_msg_str:'||l_msg_str);

1836: p_count => x_msg_count,
1837: p_data => l_msg_str
1838: );
1839: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1840: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Wrapping Error messages, l_msg_str:'||l_msg_str);
1841: END IF;
1842:
1843: END IF;
1844:

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

1843: END IF;
1844:
1845: x_msg_data := l_msg_str;
1846:
1847: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Returning back to SS page');
1849: END IF;
1850:
1851: EXCEPTION

Line 1848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Returning back to SS page');

1844:
1845: x_msg_data := l_msg_str;
1846:
1847: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc','Returning back to SS page');
1849: END IF;
1850:
1851: EXCEPTION
1852:

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

1851: EXCEPTION
1852:
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO SP_ISIR;
1855: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1856: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc.exception:FND_API.G_EXC_ERROR',SQLERRM);
1857: END IF;
1858: x_return_status := FND_API.G_RET_STS_ERROR;
1859: fnd_msg_pub.count_and_get(

Line 1856: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc.exception:FND_API.G_EXC_ERROR',SQLERRM);

1852:
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO SP_ISIR;
1855: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1856: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc.exception:FND_API.G_EXC_ERROR',SQLERRM);
1857: END IF;
1858: x_return_status := FND_API.G_RET_STS_ERROR;
1859: fnd_msg_pub.count_and_get(
1860: p_count => x_msg_count,

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

1862: );
1863:
1864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1865: ROLLBACK TO SP_ISIR;
1866: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc.exception:FND_API.G_EXC_UNEXPECTED_ERROR',SQLERRM);
1868: END IF;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1870: fnd_msg_pub.count_and_get(

Line 1867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc.exception:FND_API.G_EXC_UNEXPECTED_ERROR',SQLERRM);

1863:
1864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1865: ROLLBACK TO SP_ISIR;
1866: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc.exception:FND_API.G_EXC_UNEXPECTED_ERROR',SQLERRM);
1868: END IF;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1870: fnd_msg_pub.count_and_get(
1871: p_count => x_msg_count,

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

1873: );
1874:
1875: WHEN OTHERS THEN
1876: ROLLBACK TO SP_ISIR;
1877: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1878: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc.exception:OTHERS',SQLERRM);
1879: END IF;
1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1881: fnd_msg_pub.count_and_get(

Line 1878: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc.exception:OTHERS',SQLERRM);

1874:
1875: WHEN OTHERS THEN
1876: ROLLBACK TO SP_ISIR;
1877: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1878: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_ss_pkg.compute_efc.exception:OTHERS',SQLERRM);
1879: END IF;
1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1881: fnd_msg_pub.count_and_get(
1882: p_encoded => fnd_api.g_false,

Line 2332: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2328: p_ret_isir_id := -2;
2329: ELSE
2330: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2331: FND_MESSAGE.SET_TOKEN('NAME','igf_ap_ss_pkg.set_internal_isir');
2332: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2333: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_ss_pkg.set_internal_isir.exception','Exception: '||SQLERRM);
2334: END IF;
2335: IGS_GE_MSG_STACK.ADD;
2336: END IF;

Line 2333: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_ss_pkg.set_internal_isir.exception','Exception: '||SQLERRM);

2329: ELSE
2330: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2331: FND_MESSAGE.SET_TOKEN('NAME','igf_ap_ss_pkg.set_internal_isir');
2332: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2333: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_ss_pkg.set_internal_isir.exception','Exception: '||SQLERRM);
2334: END IF;
2335: IGS_GE_MSG_STACK.ADD;
2336: END IF;
2337: END get_internal_isir_id;