DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_FEED_PVT dependencies on FND_MESSAGE

Line 1010: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');

1006: WHERE ship_frm_sd_claim_request_id = p_batch_number
1007: AND processed_flag = 'N';
1008: COMMIT;
1009: x_return_status := fnd_api.g_ret_sts_error;
1010: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');
1011: RETURN;
1012: WHEN OTHERS THEN
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');

Line 1014: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');

1010: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');
1011: RETURN;
1012: WHEN OTHERS THEN
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');
1015: RETURN;
1016: END;
1017:
1018: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

Line 1034: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_STATUS_INVALID');

1030: WHERE ship_frm_sd_claim_request_id = p_batch_number
1031: AND processed_flag = 'N';
1032: COMMIT;
1033: x_return_status := fnd_api.g_ret_sts_error;
1034: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_STATUS_INVALID');
1035: RETURN;
1036: END IF;
1037:
1038: --check whether lines exist for given batch id

Line 2357: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

2353:
2354: IF x_return_status = fnd_api.g_ret_sts_error THEN
2355: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
2356: 'Entered throwing exception' || x_msg_data);
2357: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2358: fnd_message.set_token('MESSAGE', x_msg_data);
2359: RAISE fnd_api.g_exc_error;
2360: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2361: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',

Line 2358: fnd_message.set_token('MESSAGE', x_msg_data);

2354: IF x_return_status = fnd_api.g_ret_sts_error THEN
2355: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
2356: 'Entered throwing exception' || x_msg_data);
2357: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2358: fnd_message.set_token('MESSAGE', x_msg_data);
2359: RAISE fnd_api.g_exc_error;
2360: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2361: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2362: 'Entered throwing unexpected exception');

Line 2363: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

2359: RAISE fnd_api.g_exc_error;
2360: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2361: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2362: 'Entered throwing unexpected exception');
2363: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2364: fnd_message.set_token('MESSAGE', x_msg_data);
2365: RAISE fnd_api.g_exc_unexpected_error;
2366: END IF;
2367:

Line 2364: fnd_message.set_token('MESSAGE', x_msg_data);

2360: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2361: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2362: 'Entered throwing unexpected exception');
2363: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2364: fnd_message.set_token('MESSAGE', x_msg_data);
2365: RAISE fnd_api.g_exc_unexpected_error;
2366: END IF;
2367:
2368: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data', 'Procedure Ends');

Line 2375: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

2371: WHEN fnd_api.g_exc_error THEN
2372: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2373: 'OZF EXCEPTION G_EXC_ERROR: '||x_msg_data);
2374: x_return_status := fnd_api.g_ret_sts_error;
2375: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2376: fnd_message.set_token('MESSAGE', x_msg_data);
2377: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2378: 'OZF done:' || x_msg_data || '::::');
2379:

Line 2376: fnd_message.set_token('MESSAGE', x_msg_data);

2372: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2373: 'OZF EXCEPTION G_EXC_ERROR: '||x_msg_data);
2374: x_return_status := fnd_api.g_ret_sts_error;
2375: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2376: fnd_message.set_token('MESSAGE', x_msg_data);
2377: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2378: 'OZF done:' || x_msg_data || '::::');
2379:
2380: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2384: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

2380: WHEN fnd_api.g_exc_unexpected_error THEN
2381: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2382: 'OZF EXCEPTION G_EXC_UNEXPECTED_ERROR');
2383: x_return_status := fnd_api.g_ret_sts_unexp_error;
2384: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2385: fnd_message.set_token('MESSAGE', x_msg_data);
2386: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2387: 'OZF done G_EXC_UNEXPECTED_ERROR:' || x_msg_data || '::::');
2388: WHEN others THEN

Line 2385: fnd_message.set_token('MESSAGE', x_msg_data);

2381: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2382: 'OZF EXCEPTION G_EXC_UNEXPECTED_ERROR');
2383: x_return_status := fnd_api.g_ret_sts_unexp_error;
2384: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2385: fnd_message.set_token('MESSAGE', x_msg_data);
2386: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2387: 'OZF done G_EXC_UNEXPECTED_ERROR:' || x_msg_data || '::::');
2388: WHEN others THEN
2389: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',

Line 2392: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

2388: WHEN others THEN
2389: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2390: 'OZF EXCEPTION OTHERS' || sqlerrm);
2391: x_return_status := fnd_api.g_ret_sts_error;
2392: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2393: fnd_message.set_token('MESSAGE', x_msg_data);
2394: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2395: 'OZF done OTHERS:' || x_msg_data ||'::::');
2396: END update_data;

Line 2393: fnd_message.set_token('MESSAGE', x_msg_data);

2389: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2390: 'OZF EXCEPTION OTHERS' || sqlerrm);
2391: x_return_status := fnd_api.g_ret_sts_error;
2392: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2393: fnd_message.set_token('MESSAGE', x_msg_data);
2394: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data',
2395: 'OZF done OTHERS:' || x_msg_data ||'::::');
2396: END update_data;
2397: