DBA Data[Home] [Help]

APPS.LNS_LOAN_PUB dependencies on FND_MSG_PUB

Line 465: FND_MSG_PUB.Add;

461: IF p_token3 is NOT NULL THEN
462: fnd_message.set_token('TOKEN3',p_token3);
463: END IF;
464:
465: FND_MSG_PUB.Add;
466: l_text := substrb(fnd_message.get,1,2000);
467: g_error_count := g_error_count+1;
468: g_errors_rec.extend(1);
469: g_errors_rec(g_error_count).ERROR_NUMBER := g_error_count;

Line 1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1847:
1848: EXCEPTION
1849: WHEN fnd_api.g_exc_error THEN
1850: x_return_status := fnd_api.g_ret_sts_error;
1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1852: WHEN fnd_api.g_exc_unexpected_error THEN
1853: x_return_status := fnd_api.g_ret_sts_unexp_error;
1854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1855: WHEN others THEN

Line 1854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1850: x_return_status := fnd_api.g_ret_sts_error;
1851: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1852: WHEN fnd_api.g_exc_unexpected_error THEN
1853: x_return_status := fnd_api.g_ret_sts_unexp_error;
1854: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1855: WHEN others THEN
1856: x_return_status := fnd_api.g_ret_sts_unexp_error;
1857: logerrors('Exception at '||g_pkg_name || '.' || l_api_name ||' is '||sqlerrm);
1858: x_msg_count := 1;

Line 2127: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2123:
2124: EXCEPTION
2125: WHEN fnd_api.g_exc_error THEN
2126: x_return_status := fnd_api.g_ret_sts_error;
2127: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2128: WHEN fnd_api.g_exc_unexpected_error THEN
2129: x_return_status := fnd_api.g_ret_sts_unexp_error;
2130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2131: WHEN others THEN

Line 2130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2126: x_return_status := fnd_api.g_ret_sts_error;
2127: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2128: WHEN fnd_api.g_exc_unexpected_error THEN
2129: x_return_status := fnd_api.g_ret_sts_unexp_error;
2130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2131: WHEN others THEN
2132: x_return_status := fnd_api.g_ret_sts_unexp_error;
2133: logerrors('Exception at '||g_pkg_name || '.' || l_api_name ||' is '||sqlerrm);
2134: x_msg_count := 1;

Line 2253: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2249:
2250: EXCEPTION
2251: WHEN fnd_api.g_exc_error THEN
2252: x_return_status := fnd_api.g_ret_sts_error;
2253: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2254: WHEN fnd_api.g_exc_unexpected_error THEN
2255: x_return_status := fnd_api.g_ret_sts_unexp_error;
2256: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2257: WHEN others THEN

Line 2256: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2252: x_return_status := fnd_api.g_ret_sts_error;
2253: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2254: WHEN fnd_api.g_exc_unexpected_error THEN
2255: x_return_status := fnd_api.g_ret_sts_unexp_error;
2256: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2257: WHEN others THEN
2258: x_return_status := fnd_api.g_ret_sts_unexp_error;
2259: logerrors('Exception at '||g_pkg_name || '.' || l_api_name ||' is '||sqlerrm);
2260: x_msg_count := 1;

Line 2412: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2408:
2409: EXCEPTION
2410: WHEN fnd_api.g_exc_error THEN
2411: x_return_status := fnd_api.g_ret_sts_error;
2412: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2413: WHEN fnd_api.g_exc_unexpected_error THEN
2414: x_return_status := fnd_api.g_ret_sts_unexp_error;
2415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2416: WHEN others THEN

Line 2415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2411: x_return_status := fnd_api.g_ret_sts_error;
2412: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2413: WHEN fnd_api.g_exc_unexpected_error THEN
2414: x_return_status := fnd_api.g_ret_sts_unexp_error;
2415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2416: WHEN others THEN
2417: x_return_status := fnd_api.g_ret_sts_unexp_error;
2418: logerrors('Exception at '||g_pkg_name || '.' || l_api_name ||' is '||sqlerrm);
2419: x_msg_count := 1;

Line 2709: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2705:
2706: EXCEPTION
2707: WHEN others THEN
2708: x_return_status := fnd_api.g_ret_sts_unexp_error;
2709: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2710: END create_FEE_ASSIGNMENT;
2711:
2712:
2713:

Line 2799: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2795:
2796: EXCEPTION
2797: WHEN fnd_api.g_exc_error THEN
2798: x_return_status := fnd_api.g_ret_sts_error;
2799: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2800: WHEN fnd_api.g_exc_unexpected_error THEN
2801: x_return_status := fnd_api.g_ret_sts_unexp_error;
2802: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2803: WHEN others THEN

Line 2802: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2798: x_return_status := fnd_api.g_ret_sts_error;
2799: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2800: WHEN fnd_api.g_exc_unexpected_error THEN
2801: x_return_status := fnd_api.g_ret_sts_unexp_error;
2802: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2803: WHEN others THEN
2804: x_return_status := fnd_api.g_ret_sts_unexp_error;
2805: logerrors('Exception at '||g_pkg_name || '.' || l_api_name ||' is '||sqlerrm);
2806: x_msg_count := 1;

Line 2886: fnd_msg_pub.initialize;

2882: SAVEPOINT CREATE_LOAN;
2883:
2884: -- Initialize message list if p_init_msg_list is set to TRUE
2885: IF fnd_api.to_boolean(p_init_msg_list) THEN
2886: fnd_msg_pub.initialize;
2887: END IF;
2888:
2889: -- Initialize Collections and Variables
2890: g_errors_rec.delete;

Line 4296: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4292: WHEN product_not_found THEN
4293: ROLLBACK TO CREATE_LOAN;
4294: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
4295: X_RETURN_STATUS := 'E';
4296: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4297: WHEN error_while_insert THEN
4298: ROLLBACK TO CREATE_LOAN;
4299: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
4300: X_RETURN_STATUS := 'E';

Line 4301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4297: WHEN error_while_insert THEN
4298: ROLLBACK TO CREATE_LOAN;
4299: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
4300: X_RETURN_STATUS := 'E';
4301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4302: WHEN OTHERS THEN
4303: ROLLBACK TO CREATE_LOAN;
4304: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
4305: X_RETURN_STATUS := 'E';

Line 4306: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4302: WHEN OTHERS THEN
4303: ROLLBACK TO CREATE_LOAN;
4304: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
4305: X_RETURN_STATUS := 'E';
4306: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4307: END CREATE_LOAN;
4308:
4309:
4310: