DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_PVT dependencies on OZF_SD_UTIL_PVT

Line 1218: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CREATE', l_return_status); -- Raising lifecycle event for create

1214: END IF;
1215:
1216: UPDATE_AMOUNTS(l_batch_id, l_batch_threshold);
1217:
1218: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CREATE', l_return_status); -- Raising lifecycle event for create
1219: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1220: RAISE FND_API.g_exc_error;
1221: END IF;
1222:

Line 1361: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim

1357:
1358: END IF; --BATCH_SUM > 0
1359:
1360:
1361: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
1362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1363: RAISE FND_API.g_exc_error;
1364: END IF;
1365:

Line 3534: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim

3530: last_updated_by = FND_GLOBAL.USER_ID,
3531: object_version_number = object_version_number + 1
3532: WHERE batch_id = l_batch_id;
3533:
3534: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim
3535: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3536: RAISE FND_API.g_exc_error;
3537: END IF;
3538:

Line 3802: WHEN ((BLN.claim_amount_currency_code = l_func_currency) AND (l_func_currency <> batch_rec.currency_code)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(BLN.claim_amount_currency_code,

3798: UPDATE ozf_sd_batch_lines_all BLN
3799: SET batch_curr_claim_amount = (
3800: CASE
3801:
3802: WHEN ((BLN.claim_amount_currency_code = l_func_currency) AND (l_func_currency <> batch_rec.currency_code)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(BLN.claim_amount_currency_code,
3803: batch_rec.currency_code,
3804: l_func_currency,
3805: (SELECT fu.exchange_rate_type
3806: FROM ozf_funds_utilized_all_b fu

Line 3813: WHEN ((BLN.claim_amount_currency_code <> l_func_currency) AND (l_func_currency <> batch_rec.currency_code)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(BLN.claim_amount_currency_code,

3809: NULL,
3810: sysdate,
3811: BLN.CLAIM_AMOUNT)
3812:
3813: WHEN ((BLN.claim_amount_currency_code <> l_func_currency) AND (l_func_currency <> batch_rec.currency_code)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(BLN.claim_amount_currency_code,
3814: batch_rec.currency_code,
3815: l_func_currency,
3816: (SELECT fu.exchange_rate_type
3817: FROM ozf_funds_utilized_all_b fu

Line 3881: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(batch_rec.BATCH_ID, 'F', l_ret_status, l_msg_count, l_msg_data);

3877:
3878: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Claim created for batch.' || batch_rec.BATCH_ID || 'is :' || to_char(l_claim_id));
3879: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Claim created for batch.' || batch_rec.BATCH_ID || 'is :' || to_char(l_claim_id));
3880:
3881: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(batch_rec.BATCH_ID, 'F', l_ret_status, l_msg_count, l_msg_data);
3882:
3883: IF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN -- If adjustment is successful
3884:
3885: UPDATE OZF_SD_BATCH_HEADERS_ALL

Line 3894: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(batch_rec.BATCH_ID, 'CLAIM', l_ret_status); -- Raising lifecycle event for claim

3890: object_version_number = object_version_number + 1
3891: WHERE batch_id = batch_rec.BATCH_ID
3892: AND status_code = 'PENDING_CLAIM';
3893:
3894: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(batch_rec.BATCH_ID, 'CLAIM', l_ret_status); -- Raising lifecycle event for claim
3895:
3896: ELSE -- If adjustment is not successful
3897:
3898: ROLLBACK TO BEFORE_INVOKE_CLAIM;