APPS.OKL_SUBSIDY_POOL_PVT dependencies on OKC_API

Line 395: x_return_status := OKC_API.G_RET_STS_ERROR;

391: OPEN c_get_subsidy_date(l_effective_to_date,l_sub_pool_rec.id);
392: FETCH c_get_subsidy_date INTO l_dummy;
393: IF (c_get_subsidy_date%FOUND) THEN
394: CLOSE c_get_subsidy_date;
395: x_return_status := OKC_API.G_RET_STS_ERROR;
396: OKC_API.set_message( p_app_name => G_APP_NAME,
397: p_msg_name => 'OKL_SUB_POOL_NO_DATE_OVERLAP',
398: p_token1 => 'POOL_NAME',
399: p_token1_value => l_pool_name);

Line 396: OKC_API.set_message( p_app_name => G_APP_NAME,

392: FETCH c_get_subsidy_date INTO l_dummy;
393: IF (c_get_subsidy_date%FOUND) THEN
394: CLOSE c_get_subsidy_date;
395: x_return_status := OKC_API.G_RET_STS_ERROR;
396: OKC_API.set_message( p_app_name => G_APP_NAME,
397: p_msg_name => 'OKL_SUB_POOL_NO_DATE_OVERLAP',
398: p_token1 => 'POOL_NAME',
399: p_token1_value => l_pool_name);
400: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 414: x_return_status := OKC_API.G_RET_STS_ERROR;

410: OPEN c_get_trx_date(l_sub_pool_rec.id);
411: FETCH c_get_trx_date INTO l_trx_date;
412: IF (c_get_trx_date%FOUND AND l_effective_to_date < l_trx_date) THEN
413: CLOSE c_get_trx_date;
414: x_return_status := OKC_API.G_RET_STS_ERROR;
415: OKC_API.set_message( p_app_name => G_APP_NAME,
416: p_msg_name => 'OKL_SUB_POOL_TRX_DATE',
417: p_token1 => 'POOL_NAME',
418: p_token1_value => l_sub_pool_rec.subsidy_pool_name,

Line 415: OKC_API.set_message( p_app_name => G_APP_NAME,

411: FETCH c_get_trx_date INTO l_trx_date;
412: IF (c_get_trx_date%FOUND AND l_effective_to_date < l_trx_date) THEN
413: CLOSE c_get_trx_date;
414: x_return_status := OKC_API.G_RET_STS_ERROR;
415: OKC_API.set_message( p_app_name => G_APP_NAME,
416: p_msg_name => 'OKL_SUB_POOL_TRX_DATE',
417: p_token1 => 'POOL_NAME',
418: p_token1_value => l_sub_pool_rec.subsidy_pool_name,
419: p_token2 => 'TRX_DATE',