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.OKL_ASSET_SUBSIDY_PVT dependencies on OKC_API

Line 2936: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

2932: OPEN c_get_subsidy_name_csr(p_subsidy_id); FETCH c_get_subsidy_name_csr INTO lv_subsidy_name;
2933: CLOSE c_get_subsidy_name_csr;
2934: OPEN c_get_subsidy_pool_name_csr(lx_subsidy_pool_id); FETCH c_get_subsidy_pool_name_csr INTO lv_subsidy_pool_name;
2935: CLOSE c_get_subsidy_pool_name_csr;
2936: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
2937: ,'SUBSIDY', lv_subsidy_name
2938: ,'POOL_NAME',lv_subsidy_pool_name);
2939: RAISE OKL_API.G_EXCEPTION_ERROR;
2940: -- return l_applicable;

Line 3265: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3261: -- this converted amount should be rounded
3262: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr
3263: ,p_currency_code => lx_sub_pool_curr_code);
3264: IF(lx_conversion_round_amt <= 0)THEN
3265: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3266: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3267: -- ,'SUBSIDY', p_subsidy_name
3268: ,'SUBSIDY', l_subsidy_name
3269: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |

Line 3271: x_return_status := OKC_API.G_RET_STS_ERROR;

3267: -- ,'SUBSIDY', p_subsidy_name
3268: ,'SUBSIDY', l_subsidy_name
3269: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3270: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3271: x_return_status := OKC_API.G_RET_STS_ERROR;
3272: RAISE OKL_API.G_EXCEPTION_ERROR;
3273: ELSE
3274: -- the amount of subsidy in pool currency should not be more than the total budget as we reduce this from the pool balance
3275: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);

Line 3279: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3275: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3276: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3277: CLOSE c_get_pool_amount_csr;
3278: IF(cv_pool_amount.total_budgets < lx_conversion_round_amt + cv_pool_amount.total_subsidy_amount)THEN
3279: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3280: 'TRX_AMOUNT', p_subsidy_amount
3281: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3282: -- ,'SUBSIDY', p_subsidy_name
3283: ,'SUBSIDY', l_subsidy_name

Line 3286: x_return_status := OKC_API.G_RET_STS_ERROR;

3282: -- ,'SUBSIDY', p_subsidy_name
3283: ,'SUBSIDY', l_subsidy_name
3284: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3285: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3286: x_return_status := OKC_API.G_RET_STS_ERROR;
3287: RAISE OKL_API.G_EXCEPTION_ERROR;
3288: END IF;
3289: END IF;
3290:

Line 3299: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3295: -- this converted amount should be rounded
3296: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot
3297: ,p_currency_code => lx_sub_pool_curr_code);
3298: IF(lx_conversion_round_amt_tot <= 0)THEN
3299: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3300: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3301: -- ,'SUBSIDY', p_subsidy_name
3302: ,'SUBSIDY', l_subsidy_name
3303: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |

Line 3305: x_return_status := OKC_API.G_RET_STS_ERROR;

3301: -- ,'SUBSIDY', p_subsidy_name
3302: ,'SUBSIDY', l_subsidy_name
3303: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3304: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3305: x_return_status := OKC_API.G_RET_STS_ERROR;
3306: RAISE OKL_API.G_EXCEPTION_ERROR;
3307: ELSE
3308: -- the amount of subsidy in pool currency should not be more than the total budget as we reduce this from the pool balance
3309: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);

Line 3313: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3309: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3310: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3311: CLOSE c_get_pool_amount_csr;
3312: IF(cv_pool_amount.total_budgets < lx_conversion_round_amt_tot + cv_pool_amount.total_subsidy_amount)THEN
3313: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3314: 'TRX_AMOUNT', p_subsidy_amount
3315: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3316: -- ,'SUBSIDY', p_subsidy_name
3317: ,'SUBSIDY', l_subsidy_name

Line 3320: x_return_status := OKC_API.G_RET_STS_ERROR;

3316: -- ,'SUBSIDY', p_subsidy_name
3317: ,'SUBSIDY', l_subsidy_name
3318: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3319: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3320: x_return_status := OKC_API.G_RET_STS_ERROR;
3321: RAISE OKL_API.G_EXCEPTION_ERROR;
3322: END IF;
3323: END IF;
3324: -- END: cklee 09/27/2005: 4634792

Line 3327: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3323: END IF;
3324: -- END: cklee 09/27/2005: 4634792
3325:
3326: ELSE
3327: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3328: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3329: -- ,'SUBSIDY', p_subsidy_name
3330: ,'SUBSIDY', l_subsidy_name
3331: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |

Line 3333: x_return_status := OKC_API.G_RET_STS_ERROR;

3329: -- ,'SUBSIDY', p_subsidy_name
3330: ,'SUBSIDY', l_subsidy_name
3331: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3332: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3333: x_return_status := OKC_API.G_RET_STS_ERROR;
3334: RAISE OKL_API.G_EXCEPTION_ERROR;
3335: END IF; -- end of lv_return_status = 'Y' AND lx_conversion_rate > 0
3336: --START: cklee 09/12/2005
3337: ELSE

Line 3343: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3339: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3340: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3341: CLOSE c_get_pool_amount_csr;
3342: IF(cv_pool_amount.total_budgets < p_subsidy_amount + cv_pool_amount.total_subsidy_amount)THEN
3343: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3344: 'TRX_AMOUNT', p_subsidy_amount
3345: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3346: -- ,'SUBSIDY', p_subsidy_name
3347: ,'SUBSIDY', l_subsidy_name

Line 3350: x_return_status := OKC_API.G_RET_STS_ERROR;

3346: -- ,'SUBSIDY', p_subsidy_name
3347: ,'SUBSIDY', l_subsidy_name
3348: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3349: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3350: x_return_status := OKC_API.G_RET_STS_ERROR;
3351: RAISE OKL_API.G_EXCEPTION_ERROR;
3352: END IF;
3353: --END: cklee 09/12/2005
3354:

Line 3361: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3357: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3358: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3359: CLOSE c_get_pool_amount_csr;
3360: IF(cv_pool_amount.total_budgets < l_subsidy_amount_tot + cv_pool_amount.total_subsidy_amount)THEN
3361: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3362: 'TRX_AMOUNT', p_subsidy_amount
3363: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3364: -- ,'SUBSIDY', p_subsidy_name
3365: ,'SUBSIDY', l_subsidy_name

Line 3368: x_return_status := OKC_API.G_RET_STS_ERROR;

3364: -- ,'SUBSIDY', p_subsidy_name
3365: ,'SUBSIDY', l_subsidy_name
3366: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3367: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3368: x_return_status := OKC_API.G_RET_STS_ERROR;
3369: RAISE OKL_API.G_EXCEPTION_ERROR;
3370: END IF;
3371: -- END: cklee 09/27/2005: 4634792
3372:

Line 3464: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3460: -- this converted amount should be rounded
3461: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr
3462: ,p_currency_code => lx_sub_pool_curr_code);
3463: IF(lx_conversion_round_amt <= 0)THEN
3464: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3465: ,'SUBSIDY', l_subsidy_name
3466: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3467: x_return_status := OKC_API.G_RET_STS_ERROR;
3468: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3467: x_return_status := OKC_API.G_RET_STS_ERROR;

3463: IF(lx_conversion_round_amt <= 0)THEN
3464: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3465: ,'SUBSIDY', l_subsidy_name
3466: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3467: x_return_status := OKC_API.G_RET_STS_ERROR;
3468: RAISE OKL_API.G_EXCEPTION_ERROR;
3469: ELSE
3470: -- the amount of subsidy in pool currency should not be more than the total budget as we reduce this from the pool balance
3471: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);

Line 3475: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3471: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3472: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3473: CLOSE c_get_pool_amount_csr;
3474: IF(cv_pool_amount.total_budgets < lx_conversion_round_amt + cv_pool_amount.total_subsidy_amount)THEN
3475: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3476: 'TRX_AMOUNT', p_subsidy_amount
3477: ,'SUBSIDY', l_subsidy_name
3478: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3479: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 3479: x_return_status := OKC_API.G_RET_STS_ERROR;

3475: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3476: 'TRX_AMOUNT', p_subsidy_amount
3477: ,'SUBSIDY', l_subsidy_name
3478: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3479: x_return_status := OKC_API.G_RET_STS_ERROR;
3480: RAISE OKL_API.G_EXCEPTION_ERROR;
3481: END IF;
3482: END IF;
3483:

Line 3491: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3487: -- this converted amount should be rounded
3488: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot
3489: ,p_currency_code => lx_sub_pool_curr_code);
3490: IF(lx_conversion_round_amt_tot <= 0)THEN
3491: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3492: ,'SUBSIDY', l_subsidy_name
3493: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3494: x_return_status := OKC_API.G_RET_STS_ERROR;
3495: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3494: x_return_status := OKC_API.G_RET_STS_ERROR;

3490: IF(lx_conversion_round_amt_tot <= 0)THEN
3491: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3492: ,'SUBSIDY', l_subsidy_name
3493: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3494: x_return_status := OKC_API.G_RET_STS_ERROR;
3495: RAISE OKL_API.G_EXCEPTION_ERROR;
3496: ELSE
3497: -- the amount of subsidy in pool currency should not be more than the total budget as we reduce this from the pool balance
3498: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);

Line 3502: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3498: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3499: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3500: CLOSE c_get_pool_amount_csr;
3501: IF(cv_pool_amount.total_budgets < lx_conversion_round_amt_tot + cv_pool_amount.total_subsidy_amount)THEN
3502: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3503: 'TRX_AMOUNT', p_tot_subsidy_amount
3504: ,'SUBSIDY', l_subsidy_name
3505: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3506: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 3506: x_return_status := OKC_API.G_RET_STS_ERROR;

3502: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3503: 'TRX_AMOUNT', p_tot_subsidy_amount
3504: ,'SUBSIDY', l_subsidy_name
3505: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3506: x_return_status := OKC_API.G_RET_STS_ERROR;
3507: RAISE OKL_API.G_EXCEPTION_ERROR;
3508: END IF;
3509: END IF;
3510:

Line 3512: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3508: END IF;
3509: END IF;
3510:
3511: ELSE
3512: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3513: ,'SUBSIDY', l_subsidy_name
3514: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3515: x_return_status := OKC_API.G_RET_STS_ERROR;
3516: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3515: x_return_status := OKC_API.G_RET_STS_ERROR;

3511: ELSE
3512: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3513: ,'SUBSIDY', l_subsidy_name
3514: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3515: x_return_status := OKC_API.G_RET_STS_ERROR;
3516: RAISE OKL_API.G_EXCEPTION_ERROR;
3517: END IF; -- end of lv_return_status = 'Y' AND lx_conversion_rate > 0
3518:
3519: ELSE

Line 3525: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3521: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3522: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3523: CLOSE c_get_pool_amount_csr;
3524: IF(cv_pool_amount.total_budgets < p_subsidy_amount + cv_pool_amount.total_subsidy_amount)THEN
3525: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3526: 'TRX_AMOUNT', p_subsidy_amount
3527: ,'SUBSIDY', l_subsidy_name
3528: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3529: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 3529: x_return_status := OKC_API.G_RET_STS_ERROR;

3525: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3526: 'TRX_AMOUNT', p_subsidy_amount
3527: ,'SUBSIDY', l_subsidy_name
3528: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3529: x_return_status := OKC_API.G_RET_STS_ERROR;
3530: RAISE OKL_API.G_EXCEPTION_ERROR;
3531: END IF;
3532:
3533: -- Check accumulated subsidy amount up to now for a specific pool

Line 3538: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3534: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3535: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3536: CLOSE c_get_pool_amount_csr;
3537: IF(cv_pool_amount.total_budgets < p_tot_subsidy_amount + cv_pool_amount.total_subsidy_amount)THEN
3538: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3539: 'TRX_AMOUNT', p_tot_subsidy_amount
3540: ,'SUBSIDY', l_subsidy_name
3541: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3542: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 3542: x_return_status := OKC_API.G_RET_STS_ERROR;

3538: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3539: 'TRX_AMOUNT', p_tot_subsidy_amount
3540: ,'SUBSIDY', l_subsidy_name
3541: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3542: x_return_status := OKC_API.G_RET_STS_ERROR;
3543: RAISE OKL_API.G_EXCEPTION_ERROR;
3544: END IF;
3545:
3546: END IF; -- end of cv_get_asset.currency_code <> lx_sub_pool_curr_code

Line 4848: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

4844:
4845: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
4846: l_api_name CONSTANT varchar2(30) := 'CREATE_ASSET_SUBSIDY';
4847: l_api_version CONSTANT NUMBER := 1.0;
4848: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4849: i NUMBER := 0;
4850:
4851: l_asb_tbl asb_tbl_type;
4852: Begin

Line 4869: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

4865: p_asb_rec => l_asb_tbl(i),
4866: x_asb_rec => x_asb_tbl(i));
4867: /***-- start cklee 11/15/04
4868: -- store the highest degree of error
4869: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4870: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
4871: l_overall_status := x_return_status;
4872: End If;
4873: End If;

Line 4870: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

4866: x_asb_rec => x_asb_tbl(i));
4867: /***-- start cklee 11/15/04
4868: -- store the highest degree of error
4869: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4870: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
4871: l_overall_status := x_return_status;
4872: End If;
4873: End If;
4874: -- end cklee 11/15/04

Line 5036: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5032: l_asb_rec := p_asb_rec;
5033: l_db_asb_rec := get_rec(l_asb_rec,l_row_notfound);
5034:
5035: IF (l_row_notfound) THEN
5036: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5037: END IF;
5038:
5039: -------------------------------------------------------------------
5040: --Begin delete the party payment details if vendor changes

Line 5392: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5388:
5389: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5390: l_api_name CONSTANT varchar2(30) := 'UPDATE_ASSET_SUBSIDY';
5391: l_api_version CONSTANT NUMBER := 1.0;
5392: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5393: i NUMBER := 0;
5394:
5395: l_asb_tbl asb_tbl_type;
5396: Begin

Line 5415: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

5411:
5412: /*-- start cklee 11/15/04
5413:
5414: -- store the highest degree of error
5415: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5416: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5417: l_overall_status := x_return_status;
5418: End If;
5419: End If;

Line 5416: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

5412: /*-- start cklee 11/15/04
5413:
5414: -- store the highest degree of error
5415: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5416: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5417: l_overall_status := x_return_status;
5418: End If;
5419: End If;
5420: -- end cklee 11/15/04

Line 5542: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5538: l_asb_rec := p_asb_rec;
5539: l_db_asb_rec := get_rec(l_asb_rec,l_row_notfound);
5540:
5541: IF (l_row_notfound) THEN
5542: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5543: END IF;
5544:
5545: --Bug# 4959361
5546: OKL_LLA_UTIL_PVT.check_line_update_allowed

Line 5755: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5751:
5752: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5753: l_api_name CONSTANT varchar2(30) := 'DELETE_ASSET_SUBSIDY';
5754: l_api_version CONSTANT NUMBER := 1.0;
5755: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5756: i NUMBER := 0;
5757:
5758: l_asb_tbl asb_tbl_type;
5759: Begin

Line 5776: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

5772: p_asb_rec => l_asb_tbl(i));
5773: /*-- start cklee 11/15/04
5774:
5775: -- store the highest degree of error
5776: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5777: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5778: l_overall_status := x_return_status;
5779: End If;
5780: End If;

Line 5777: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

5773: /*-- start cklee 11/15/04
5774:
5775: -- store the highest degree of error
5776: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5777: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5778: l_overall_status := x_return_status;
5779: End If;
5780: End If;
5781: -- end cklee 11/15/04

Line 5843: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5839:
5840: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5841: l_api_name CONSTANT varchar2(30) := 'VALIDATE_ASSET_SUBSIDY';
5842: l_api_version CONSTANT NUMBER := 1.0;
5843: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5844: i NUMBER := 0;
5845:
5846: l_asb_tbl asb_tbl_type;
5847: Begin

Line 5864: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

5860: p_asb_rec => l_asb_tbl(i));
5861:
5862: /*-- start cklee 11/15/04
5863: -- store the highest degree of error
5864: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5865: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5866: l_overall_status := x_return_status;
5867: End If;
5868: End If;

Line 5865: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

5861:
5862: /*-- start cklee 11/15/04
5863: -- store the highest degree of error
5864: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5865: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5866: l_overall_status := x_return_status;
5867: End If;
5868: End If;
5869: -- end cklee 11/15/04

Line 5932: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

5928:
5929: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5930: l_api_name CONSTANT varchar2(30) := 'CALCULATE_ASSET_SUBSIDY';
5931: l_api_version CONSTANT NUMBER := 1.0;
5932: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5933: i NUMBER := 0;
5934:
5935: l_asb_tbl asb_tbl_type;
5936: Begin

Line 5954: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

5950: x_asb_rec => x_asb_tbl(i));
5951:
5952: /*-- start cklee 11/15/04
5953: -- store the highest degree of error
5954: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5955: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5956: l_overall_status := x_return_status;
5957: End If;
5958: End If;

Line 5955: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

5951:
5952: /*-- start cklee 11/15/04
5953: -- store the highest degree of error
5954: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5955: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5956: l_overall_status := x_return_status;
5957: End If;
5958: End If;
5959: -- end cklee 11/15/04