DBA Data[Home] [Help]

APPS.IGF_AP_SS_PKG dependencies on FND_API

Line 1192: x_return_status := FND_API.G_RET_STS_SUCCESS;

1188:
1189: SAVEPOINT SP_ISIR;
1190:
1191: FND_MSG_PUB.initialize;
1192: x_return_status := FND_API.G_RET_STS_SUCCESS;
1193:
1194: -- Fetch the modified ISIR details (Internal ISIR Record)
1195: OPEN c_isir_detials( p_mod_isir_id);
1196: FETCH c_isir_detials INTO isir_detials_rec;

Line 1272: p_encoded => fnd_api.g_false,

1268: --Compare the Correction ISIR Created now with the Payment ISIR
1269: igf_aw_gen_002.compare_isirs(l_payment_isir_id, p_mod_isir_id, p_cal_type, p_sequence_number,p_corr_status);
1270:
1271: fnd_msg_pub.count_and_get(
1272: p_encoded => fnd_api.g_false,
1273: p_count => x_msg_count,
1274: p_data => x_msg_data
1275: );
1276:

Line 1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1292: EXCEPTION
1293: WHEN OTHERS THEN
1294:
1295: ROLLBACK TO SP_ISIR;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: fnd_msg_pub.count_and_get(
1298: p_encoded => fnd_api.g_false,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data

Line 1298: p_encoded => fnd_api.g_false,

1294:
1295: ROLLBACK TO SP_ISIR;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: fnd_msg_pub.count_and_get(
1298: p_encoded => fnd_api.g_false,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );
1302:

Line 1348: x_return_status := FND_API.G_RET_STS_SUCCESS;

1344:
1345: SAVEPOINT SP_ISIR;
1346:
1347: FND_MSG_PUB.initialize;
1348: x_return_status := FND_API.G_RET_STS_SUCCESS;
1349:
1350: -- Fetch the modified ISIR details
1351: OPEN c_isir_detials( p_mod_isir_id);
1352: FETCH c_isir_detials INTO isir_detials_rec;

Line 1364: x_return_status := fnd_api.g_ret_sts_error;

1360: --Do not proceed further if transaction number >99
1361: IF l_trans > 99 THEN
1362: fnd_message.set_name('IGF','IGF_AP_SIM_ISIR_MAX');
1363: fnd_msg_pub.add;
1364: x_return_status := fnd_api.g_ret_sts_error;
1365:
1366: ELSE
1367:
1368: isir_detials_rec.transaction_num:=LPAD(l_trans,2,'0');

Line 1379: p_encoded => fnd_api.g_false,

1375:
1376: END IF;
1377:
1378: fnd_msg_pub.count_and_get(
1379: p_encoded => fnd_api.g_false,
1380: p_count => x_msg_count,
1381: p_data => x_msg_data
1382: );
1383:

Line 1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1384: EXCEPTION
1385: WHEN OTHERS THEN
1386:
1387: ROLLBACK TO SP_ISIR;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389: fnd_msg_pub.count_and_get(
1390: p_encoded => fnd_api.g_false,
1391: p_count => x_msg_count,
1392: p_data => x_msg_data

Line 1390: p_encoded => fnd_api.g_false,

1386:
1387: ROLLBACK TO SP_ISIR;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389: fnd_msg_pub.count_and_get(
1390: p_encoded => fnd_api.g_false,
1391: p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );
1394:

Line 1452: x_return_status := FND_API.G_RET_STS_SUCCESS;

1448:
1449: BEGIN
1450:
1451: FND_MSG_PUB.initialize;
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

Line 1835: p_encoded => fnd_api.g_false,

1831:
1832: ELSE
1833:
1834: fnd_msg_pub.count_and_get(
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

Line 1853: WHEN FND_API.G_EXC_ERROR THEN

1849: END IF;
1850:
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;

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 1858: x_return_status := FND_API.G_RET_STS_ERROR;

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,
1861: p_data => x_msg_data
1862: );

Line 1864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1860: p_count => x_msg_count,
1861: p_data => x_msg_data
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;

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 1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
1872: p_data => x_msg_data
1873: );

Line 1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data

Line 1882: p_encoded => fnd_api.g_false,

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,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data
1885: );
1886: