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 2957: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

2953: OPEN c_get_subsidy_name_csr(p_subsidy_id); FETCH c_get_subsidy_name_csr INTO lv_subsidy_name;
2954: CLOSE c_get_subsidy_name_csr;
2955: OPEN c_get_subsidy_pool_name_csr(lx_subsidy_pool_id); FETCH c_get_subsidy_pool_name_csr INTO lv_subsidy_pool_name;
2956: CLOSE c_get_subsidy_pool_name_csr;
2957: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
2958: ,'SUBSIDY', lv_subsidy_name
2959: ,'POOL_NAME',lv_subsidy_pool_name);
2960: RAISE OKL_API.G_EXCEPTION_ERROR;
2961: -- return l_applicable;

Line 3286: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3282: -- this converted amount should be rounded
3283: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr
3284: ,p_currency_code => lx_sub_pool_curr_code);
3285: IF(lx_conversion_round_amt <= 0)THEN
3286: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3287: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3288: -- ,'SUBSIDY', p_subsidy_name
3289: ,'SUBSIDY', l_subsidy_name
3290: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |

Line 3292: x_return_status := OKC_API.G_RET_STS_ERROR;

3288: -- ,'SUBSIDY', p_subsidy_name
3289: ,'SUBSIDY', l_subsidy_name
3290: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3291: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3292: x_return_status := OKC_API.G_RET_STS_ERROR;
3293: RAISE OKL_API.G_EXCEPTION_ERROR;
3294: ELSE
3295: -- the amount of subsidy in pool currency should not be more than the total budget as we reduce this from the pool balance
3296: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);

Line 3300: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3296: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3297: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3298: CLOSE c_get_pool_amount_csr;
3299: IF(cv_pool_amount.total_budgets < lx_conversion_round_amt + cv_pool_amount.total_subsidy_amount)THEN
3300: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3301: 'TRX_AMOUNT', p_subsidy_amount
3302: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3303: -- ,'SUBSIDY', p_subsidy_name
3304: ,'SUBSIDY', l_subsidy_name

Line 3307: x_return_status := OKC_API.G_RET_STS_ERROR;

3303: -- ,'SUBSIDY', p_subsidy_name
3304: ,'SUBSIDY', l_subsidy_name
3305: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3306: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3307: x_return_status := OKC_API.G_RET_STS_ERROR;
3308: RAISE OKL_API.G_EXCEPTION_ERROR;
3309: END IF;
3310: END IF;
3311:

Line 3320: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3316: -- this converted amount should be rounded
3317: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot
3318: ,p_currency_code => lx_sub_pool_curr_code);
3319: IF(lx_conversion_round_amt_tot <= 0)THEN
3320: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3321: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3322: -- ,'SUBSIDY', p_subsidy_name
3323: ,'SUBSIDY', l_subsidy_name
3324: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |

Line 3326: x_return_status := OKC_API.G_RET_STS_ERROR;

3322: -- ,'SUBSIDY', p_subsidy_name
3323: ,'SUBSIDY', l_subsidy_name
3324: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3325: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3326: x_return_status := OKC_API.G_RET_STS_ERROR;
3327: RAISE OKL_API.G_EXCEPTION_ERROR;
3328: ELSE
3329: -- the amount of subsidy in pool currency should not be more than the total budget as we reduce this from the pool balance
3330: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);

Line 3334: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3330: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3331: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3332: CLOSE c_get_pool_amount_csr;
3333: IF(cv_pool_amount.total_budgets < lx_conversion_round_amt_tot + cv_pool_amount.total_subsidy_amount)THEN
3334: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3335: 'TRX_AMOUNT', p_subsidy_amount
3336: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3337: -- ,'SUBSIDY', p_subsidy_name
3338: ,'SUBSIDY', l_subsidy_name

Line 3341: x_return_status := OKC_API.G_RET_STS_ERROR;

3337: -- ,'SUBSIDY', p_subsidy_name
3338: ,'SUBSIDY', l_subsidy_name
3339: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3340: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3341: x_return_status := OKC_API.G_RET_STS_ERROR;
3342: RAISE OKL_API.G_EXCEPTION_ERROR;
3343: END IF;
3344: END IF;
3345: -- END: cklee 09/27/2005: 4634792

Line 3348: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3344: END IF;
3345: -- END: cklee 09/27/2005: 4634792
3346:
3347: ELSE
3348: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3349: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3350: -- ,'SUBSIDY', p_subsidy_name
3351: ,'SUBSIDY', l_subsidy_name
3352: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |

Line 3354: x_return_status := OKC_API.G_RET_STS_ERROR;

3350: -- ,'SUBSIDY', p_subsidy_name
3351: ,'SUBSIDY', l_subsidy_name
3352: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3353: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3354: x_return_status := OKC_API.G_RET_STS_ERROR;
3355: RAISE OKL_API.G_EXCEPTION_ERROR;
3356: END IF; -- end of lv_return_status = 'Y' AND lx_conversion_rate > 0
3357: --START: cklee 09/12/2005
3358: ELSE

Line 3364: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

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

Line 3371: x_return_status := OKC_API.G_RET_STS_ERROR;

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

Line 3382: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3378: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3379: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3380: CLOSE c_get_pool_amount_csr;
3381: IF(cv_pool_amount.total_budgets < l_subsidy_amount_tot + cv_pool_amount.total_subsidy_amount)THEN
3382: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3383: 'TRX_AMOUNT', p_subsidy_amount
3384: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3385: -- ,'SUBSIDY', p_subsidy_name
3386: ,'SUBSIDY', l_subsidy_name

Line 3389: x_return_status := OKC_API.G_RET_STS_ERROR;

3385: -- ,'SUBSIDY', p_subsidy_name
3386: ,'SUBSIDY', l_subsidy_name
3387: --END: 24-Oct-2005 cklee - Fixed bug#4687505 |
3388: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3389: x_return_status := OKC_API.G_RET_STS_ERROR;
3390: RAISE OKL_API.G_EXCEPTION_ERROR;
3391: END IF;
3392: -- END: cklee 09/27/2005: 4634792
3393:

Line 3485: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3481: -- this converted amount should be rounded
3482: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr
3483: ,p_currency_code => lx_sub_pool_curr_code);
3484: IF(lx_conversion_round_amt <= 0)THEN
3485: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3486: ,'SUBSIDY', l_subsidy_name
3487: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3488: x_return_status := OKC_API.G_RET_STS_ERROR;
3489: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3488: x_return_status := OKC_API.G_RET_STS_ERROR;

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

Line 3496: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3492: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3493: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3494: CLOSE c_get_pool_amount_csr;
3495: IF(cv_pool_amount.total_budgets < lx_conversion_round_amt + cv_pool_amount.total_subsidy_amount)THEN
3496: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3497: 'TRX_AMOUNT', p_subsidy_amount
3498: ,'SUBSIDY', l_subsidy_name
3499: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3500: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 3500: x_return_status := OKC_API.G_RET_STS_ERROR;

3496: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3497: 'TRX_AMOUNT', p_subsidy_amount
3498: ,'SUBSIDY', l_subsidy_name
3499: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3500: x_return_status := OKC_API.G_RET_STS_ERROR;
3501: RAISE OKL_API.G_EXCEPTION_ERROR;
3502: END IF;
3503: END IF;
3504:

Line 3512: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3508: -- this converted amount should be rounded
3509: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot
3510: ,p_currency_code => lx_sub_pool_curr_code);
3511: IF(lx_conversion_round_amt_tot <= 0)THEN
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: IF(lx_conversion_round_amt_tot <= 0)THEN
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: ELSE
3518: -- the amount of subsidy in pool currency should not be more than the total budget as we reduce this from the pool balance
3519: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);

Line 3523: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

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

Line 3527: x_return_status := OKC_API.G_RET_STS_ERROR;

3523: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3524: 'TRX_AMOUNT', p_tot_subsidy_amount
3525: ,'SUBSIDY', l_subsidy_name
3526: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3527: x_return_status := OKC_API.G_RET_STS_ERROR;
3528: RAISE OKL_API.G_EXCEPTION_ERROR;
3529: END IF;
3530: END IF;
3531:

Line 3533: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS

3529: END IF;
3530: END IF;
3531:
3532: ELSE
3533: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3534: ,'SUBSIDY', l_subsidy_name
3535: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3536: x_return_status := OKC_API.G_RET_STS_ERROR;
3537: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3536: x_return_status := OKC_API.G_RET_STS_ERROR;

3532: ELSE
3533: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3534: ,'SUBSIDY', l_subsidy_name
3535: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3536: x_return_status := OKC_API.G_RET_STS_ERROR;
3537: RAISE OKL_API.G_EXCEPTION_ERROR;
3538: END IF; -- end of lv_return_status = 'Y' AND lx_conversion_rate > 0
3539:
3540: ELSE

Line 3546: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3542: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3543: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3544: CLOSE c_get_pool_amount_csr;
3545: IF(cv_pool_amount.total_budgets < p_subsidy_amount + cv_pool_amount.total_subsidy_amount)THEN
3546: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3547: 'TRX_AMOUNT', p_subsidy_amount
3548: ,'SUBSIDY', l_subsidy_name
3549: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3550: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 3550: x_return_status := OKC_API.G_RET_STS_ERROR;

3546: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3547: 'TRX_AMOUNT', p_subsidy_amount
3548: ,'SUBSIDY', l_subsidy_name
3549: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3550: x_return_status := OKC_API.G_RET_STS_ERROR;
3551: RAISE OKL_API.G_EXCEPTION_ERROR;
3552: END IF;
3553:
3554: -- Check accumulated subsidy amount up to now for a specific pool

Line 3559: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,

3555: OPEN c_get_pool_amount_csr (p_subsidy_pool_id =>lx_subsidy_pool_id);
3556: FETCH c_get_pool_amount_csr INTO cv_pool_amount;
3557: CLOSE c_get_pool_amount_csr;
3558: IF(cv_pool_amount.total_budgets < p_tot_subsidy_amount + cv_pool_amount.total_subsidy_amount)THEN
3559: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3560: 'TRX_AMOUNT', p_tot_subsidy_amount
3561: ,'SUBSIDY', l_subsidy_name
3562: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3563: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 3563: x_return_status := OKC_API.G_RET_STS_ERROR;

3559: OKC_API.set_message(G_APP_NAME, G_TRX_AMT_GT_TOT_BUDGET,
3560: 'TRX_AMOUNT', p_tot_subsidy_amount
3561: ,'SUBSIDY', l_subsidy_name
3562: ,'POOL_NAME',cv_pool_amount.subsidy_pool_name);
3563: x_return_status := OKC_API.G_RET_STS_ERROR;
3564: RAISE OKL_API.G_EXCEPTION_ERROR;
3565: END IF;
3566:
3567: END IF; -- end of cv_get_asset.currency_code <> lx_sub_pool_curr_code

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

4865:
4866: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
4867: l_api_name CONSTANT varchar2(30) := 'CREATE_ASSET_SUBSIDY';
4868: l_api_version CONSTANT NUMBER := 1.0;
4869: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4870: i NUMBER := 0;
4871:
4872: l_asb_tbl asb_tbl_type;
4873: Begin

Line 4890: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

4886: p_asb_rec => l_asb_tbl(i),
4887: x_asb_rec => x_asb_tbl(i));
4888: /***-- start cklee 11/15/04
4889: -- store the highest degree of error
4890: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4891: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
4892: l_overall_status := x_return_status;
4893: End If;
4894: End If;

Line 4891: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

4887: x_asb_rec => x_asb_tbl(i));
4888: /***-- start cklee 11/15/04
4889: -- store the highest degree of error
4890: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
4891: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
4892: l_overall_status := x_return_status;
4893: End If;
4894: End If;
4895: -- end cklee 11/15/04

Line 5057: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5053: l_asb_rec := p_asb_rec;
5054: l_db_asb_rec := get_rec(l_asb_rec,l_row_notfound);
5055:
5056: IF (l_row_notfound) THEN
5057: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5058: END IF;
5059:
5060: -------------------------------------------------------------------
5061: --Begin delete the party payment details if vendor changes

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

5409:
5410: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5411: l_api_name CONSTANT varchar2(30) := 'UPDATE_ASSET_SUBSIDY';
5412: l_api_version CONSTANT NUMBER := 1.0;
5413: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5414: i NUMBER := 0;
5415:
5416: l_asb_tbl asb_tbl_type;
5417: Begin

Line 5436: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

5432:
5433: /*-- start cklee 11/15/04
5434:
5435: -- store the highest degree of error
5436: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5437: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5438: l_overall_status := x_return_status;
5439: End If;
5440: End If;

Line 5437: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

5433: /*-- start cklee 11/15/04
5434:
5435: -- store the highest degree of error
5436: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5437: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5438: l_overall_status := x_return_status;
5439: End If;
5440: End If;
5441: -- end cklee 11/15/04

Line 5563: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5559: l_asb_rec := p_asb_rec;
5560: l_db_asb_rec := get_rec(l_asb_rec,l_row_notfound);
5561:
5562: IF (l_row_notfound) THEN
5563: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5564: END IF;
5565:
5566: --Bug# 4959361
5567: OKL_LLA_UTIL_PVT.check_line_update_allowed

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

5772:
5773: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5774: l_api_name CONSTANT varchar2(30) := 'DELETE_ASSET_SUBSIDY';
5775: l_api_version CONSTANT NUMBER := 1.0;
5776: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5777: i NUMBER := 0;
5778:
5779: l_asb_tbl asb_tbl_type;
5780: Begin

Line 5797: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

5793: p_asb_rec => l_asb_tbl(i));
5794: /*-- start cklee 11/15/04
5795:
5796: -- store the highest degree of error
5797: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5798: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5799: l_overall_status := x_return_status;
5800: End If;
5801: End If;

Line 5798: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

5794: /*-- start cklee 11/15/04
5795:
5796: -- store the highest degree of error
5797: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5798: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5799: l_overall_status := x_return_status;
5800: End If;
5801: End If;
5802: -- end cklee 11/15/04

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

5860:
5861: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5862: l_api_name CONSTANT varchar2(30) := 'VALIDATE_ASSET_SUBSIDY';
5863: l_api_version CONSTANT NUMBER := 1.0;
5864: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5865: i NUMBER := 0;
5866:
5867: l_asb_tbl asb_tbl_type;
5868: Begin

Line 5885: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

5881: p_asb_rec => l_asb_tbl(i));
5882:
5883: /*-- start cklee 11/15/04
5884: -- store the highest degree of error
5885: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5886: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5887: l_overall_status := x_return_status;
5888: End If;
5889: End If;

Line 5886: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

5882:
5883: /*-- start cklee 11/15/04
5884: -- store the highest degree of error
5885: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5886: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5887: l_overall_status := x_return_status;
5888: End If;
5889: End If;
5890: -- end cklee 11/15/04

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

5949:
5950: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5951: l_api_name CONSTANT varchar2(30) := 'CALCULATE_ASSET_SUBSIDY';
5952: l_api_version CONSTANT NUMBER := 1.0;
5953: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5954: i NUMBER := 0;
5955:
5956: l_asb_tbl asb_tbl_type;
5957: Begin

Line 5975: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then

5971: x_asb_rec => x_asb_tbl(i));
5972:
5973: /*-- start cklee 11/15/04
5974: -- store the highest degree of error
5975: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5976: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5977: l_overall_status := x_return_status;
5978: End If;
5979: End If;

Line 5976: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then

5972:
5973: /*-- start cklee 11/15/04
5974: -- store the highest degree of error
5975: If x_return_status <> OKC_API.G_RET_STS_SUCCESS Then
5976: If l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR Then
5977: l_overall_status := x_return_status;
5978: End If;
5979: End If;
5980: -- end cklee 11/15/04