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.OZF_SD_BATCH_FEED_PVT dependencies on FND_API

Line 992: x_return_status := fnd_api.g_ret_sts_success;

988: BEGIN
989:
990: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'Procedure Starts');
991:
992: x_return_status := fnd_api.g_ret_sts_success;
993:
994: --Retreive batch id
995: BEGIN
996: SELECT batch_id, status_code, claim_minor_version, org_id, currency_code,NVL(imd_claim_flag,'N')

Line 1009: x_return_status := fnd_api.g_ret_sts_error;

1005: last_updated_by = fnd_global.user_id
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;

Line 1013: x_return_status := fnd_api.g_ret_sts_error;

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');
1015: RETURN;
1016: END;
1017:

Line 1033: x_return_status := fnd_api.g_ret_sts_error;

1029: last_updated_by = fnd_global.user_id
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:

Line 1053: x_return_status := fnd_api.g_ret_sts_error;

1049: last_updated_by = fnd_global.user_id
1050: WHERE ship_frm_sd_claim_request_id = p_batch_number
1051: AND processed_flag = 'N';
1052: COMMIT;
1053: x_return_status := fnd_api.g_ret_sts_error;
1054: x_msg_data := 'There are no Lines for this Batch ID';
1055: RETURN;
1056: END IF;
1057:

Line 2354: IF x_return_status = fnd_api.g_ret_sts_error THEN

2350: END IF; -- Not all lines Approved and atleast there is one APPROVED line
2351: END IF; -- Partial approval is not allowed
2352:
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);

Line 2359: RAISE fnd_api.g_exc_error;

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');
2363: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

Line 2360: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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');
2363: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
2364: fnd_message.set_token('MESSAGE', x_msg_data);

Line 2365: RAISE fnd_api.g_exc_unexpected_error;

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

Line 2371: WHEN fnd_api.g_exc_error THEN

2367:
2368: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT:update_data', 'Procedure Ends');
2369:
2370: EXCEPTION
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');

Line 2374: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2380: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 2383: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 2391: x_return_status := fnd_api.g_ret_sts_error;

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

Line 3271: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If claim is successful

3267: IF (l_tot_app_claim_amt) <> 0 THEN
3268:
3269: PROCESS_CLAIM(l_new_batch_id, x_return_status, x_msg_data, l_claim_id);
3270:
3271: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If claim is successful
3272:
3273: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(l_new_batch_id, 'F', x_return_status, l_msg_count, x_msg_data);
3274:
3275: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If adjustment is successful

Line 3275: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If adjustment is successful

3271: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If claim is successful
3272:
3273: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(l_new_batch_id, 'F', x_return_status, l_msg_count, x_msg_data);
3274:
3275: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If adjustment is successful
3276: --raising business event
3277: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CLAIM', x_return_status);
3278: UPDATE ozf_sd_batch_headers_all
3279: SET status_code = 'CLOSED',

Line 3398: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3394:
3395:
3396: PROCESS_CLAIM(p_batch_id, x_return_status, x_msg_data, l_claim_id);
3397:
3398: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3399:
3400: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(p_batch_id, 'F', x_return_status, l_msg_count, x_msg_data); -- to pass p_comp_wrt_off
3401:
3402: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 3402: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3398: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3399:
3400: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(p_batch_id, 'F', x_return_status, l_msg_count, x_msg_data); -- to pass p_comp_wrt_off
3401:
3402: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3403: --raising business event
3404: ozf_sd_util_pvt.sd_raise_event (p_batch_id, 'CLAIM', x_return_status);
3405: UPDATE ozf_sd_batch_headers_all
3406: SET status_code = 'CLOSED',

Line 3590: fnd_api.g_false,

3586: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::process_claim',
3587: 'Procedure Starts: Batch Id -> '||p_batch_id);
3588: --call claim API
3589: ozf_claim_accrual_pvt.initiate_sd_payment(1,
3590: fnd_api.g_false,
3591: fnd_api.g_true,
3592: fnd_api.g_valid_level_full,
3593: l_claim_ret_status,
3594: l_claim_msg_count,

Line 3591: fnd_api.g_true,

3587: 'Procedure Starts: Batch Id -> '||p_batch_id);
3588: --call claim API
3589: ozf_claim_accrual_pvt.initiate_sd_payment(1,
3590: fnd_api.g_false,
3591: fnd_api.g_true,
3592: fnd_api.g_valid_level_full,
3593: l_claim_ret_status,
3594: l_claim_msg_count,
3595: l_claim_msg_data,

Line 3592: fnd_api.g_valid_level_full,

3588: --call claim API
3589: ozf_claim_accrual_pvt.initiate_sd_payment(1,
3590: fnd_api.g_false,
3591: fnd_api.g_true,
3592: fnd_api.g_valid_level_full,
3593: l_claim_ret_status,
3594: l_claim_msg_count,
3595: l_claim_msg_data,
3596: p_batch_id,