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_AM_QUOTES_WF dependencies on OKL_API

Line 73: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
70: || sqlcode || ' , SQLERRM : ' || sqlerrm);
71: END IF;
72:
73: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
74: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
75: FND_MSG_PUB.ADD;
76: IF okl_key_csr%ISOPEN THEN
77: CLOSE okl_key_csr;

Line 147: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

143: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
144: || sqlcode || ' , SQLERRM : ' || sqlerrm);
145: END IF;
146:
147: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
149: FND_MSG_PUB.ADD;
150: IF okl_key_csr%ISOPEN THEN
151: CLOSE okl_key_csr;

Line 1462: l_tcnv_rec.id := OKL_API.G_MISS_NUM;

1458: l_term_rec.p_quote_id := l_qte_id;
1459: l_term_rec.p_quote_type := l_qtp_code;
1460: l_term_rec.p_quote_reason := l_qrs_code;
1461:
1462: l_tcnv_rec.id := OKL_API.G_MISS_NUM;
1463:
1464: -- Call the terminate contract api
1465: OKL_AM_LEASE_LOAN_TRMNT_PUB.lease_loan_termination (
1466: p_api_version => l_api_version,

Line 1467: p_init_msg_list => OKL_API.G_TRUE,

1463:
1464: -- Call the terminate contract api
1465: OKL_AM_LEASE_LOAN_TRMNT_PUB.lease_loan_termination (
1466: p_api_version => l_api_version,
1467: p_init_msg_list => OKL_API.G_TRUE,
1468: x_return_status => l_return_status,
1469: x_msg_count => lx_msg_count,
1470: x_msg_data => lx_msg_data,
1471: p_term_rec => l_term_rec,

Line 1474: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1470: x_msg_data => lx_msg_data,
1471: p_term_rec => l_term_rec,
1472: p_tcnv_rec => l_tcnv_rec);
1473:
1474: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1475: resultout := 'COMPLETE:N';
1476: RAISE G_EXCEPTION;
1477: ELSE
1478: resultout := 'COMPLETE:Y';

Line 1560: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1556: AND OKLV.lse_id = OLSV.id
1557: AND OLSV.lty_code = 'SOLD_SERVICE'
1558: AND OKLV.end_date > SYSDATE;
1559:
1560: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1561: l_contract_id NUMBER;
1562: l_no_of_recipients NUMBER := 0;
1563:
1564: -- for debug logging

Line 1669: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1665: actid IN NUMBER,
1666: funcmode IN VARCHAR2,
1667: resultout OUT NOCOPY VARCHAR2) IS
1668:
1669: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1670: l_contract_id NUMBER;
1671: l_no_of_service_lines NUMBER;
1672:
1673: -- for debug logging

Line 1837: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1833: per_people_f ppf
1834: WHERE fu.employee_id = ppf.person_id (+)
1835: AND fu.user_id = c_agent_id;
1836: l_from_email VARCHAR2(100);
1837: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1838: l_to_email VARCHAR2(100);
1839: -- ansethur 26-jul-2007 R12B XMLP start changes
1840: l_agent_id NUMBER;
1841: l_quote_id VARCHAR2(200);

Line 1948: -- OKL_API.init_msg_list('T');

1944: avalue => l_from_email);
1945:
1946: -- ansethur 26-jul-2007 R12B XMLP end changes
1947: -- Initialize the message stack
1948: -- OKL_API.init_msg_list('T');
1949:
1950: -- 12/20/06 rkuttiya added for XMLP Project
1951: --code for inserting bind parameters into table
1952:

Line 2026: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2022: resultout OUT NOCOPY VARCHAR2) IS
2023:
2024:
2025: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2026: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2027: l_rule_found VARCHAR2(1) := 'N';
2028: l_contract_id NUMBER;
2029: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2030:

Line 2093: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

2089: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2090: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);
2091: END IF;
2092:
2093: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
2094: IF NVL (l_rulv_rec.rule_information1, '*') = 'Y' THEN
2095: l_rule_found := 'Y';
2096: END IF;
2097: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 2097: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

2093: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
2094: IF NVL (l_rulv_rec.rule_information1, '*') = 'Y' THEN
2095: l_rule_found := 'Y';
2096: END IF;
2097: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2098: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2099: l_rule_found := 'N';
2100: END IF;
2101:

Line 2098: l_return_status := OKL_API.G_RET_STS_SUCCESS;

2094: IF NVL (l_rulv_rec.rule_information1, '*') = 'Y' THEN
2095: l_rule_found := 'Y';
2096: END IF;
2097: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2098: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2099: l_rule_found := 'N';
2100: END IF;
2101:
2102: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 2102: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2098: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2099: l_rule_found := 'N';
2100: END IF;
2101:
2102: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2103: resultout := 'COMPLETE:N';
2104: RAISE G_EXCEPTION;
2105: END IF;
2106:

Line 2189: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2185: funcmode IN VARCHAR2,
2186: resultout OUT NOCOPY VARCHAR2) IS
2187:
2188:
2189: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2190: l_contract_id NUMBER;
2191: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2192: l_recipient_type VARCHAR2(3);
2193: l_id NUMBER;

Line 2318: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2314: l_party_id NUMBER;
2315: l_email_id VARCHAR2(2000);
2316:
2317: --12/20/06 rkuttiya added for XMLP Project
2318: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2319: x_msg_count NUMBER;
2320: x_msg_data VARCHAR2(2000);
2321: l_api_version NUMBER := 1;
2322: l_init_msg_list VARCHAR2(1) := 'T';

Line 2558: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2554: funcmode IN VARCHAR2,
2555: resultout OUT NOCOPY VARCHAR2) IS
2556:
2557: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2558: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2559: l_rule_found VARCHAR2(1) := 'N';
2560: l_contract_id NUMBER;
2561: -- for debug logging
2562: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'';

Line 2599: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

2595: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2596: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
2597: END IF;
2598:
2599: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
2600: IF l_rulv_rec.jtot_object1_code IS NOT NULL
2601: AND l_rulv_rec.object1_id1 IS NOT NULL THEN
2602: l_rule_found := 'Y';
2603: END IF;

Line 2604: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

2600: IF l_rulv_rec.jtot_object1_code IS NOT NULL
2601: AND l_rulv_rec.object1_id1 IS NOT NULL THEN
2602: l_rule_found := 'Y';
2603: END IF;
2604: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2605: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2606: l_rule_found := 'N';
2607: END IF;
2608:

Line 2605: l_return_status := OKL_API.G_RET_STS_SUCCESS;

2601: AND l_rulv_rec.object1_id1 IS NOT NULL THEN
2602: l_rule_found := 'Y';
2603: END IF;
2604: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
2605: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2606: l_rule_found := 'N';
2607: END IF;
2608:
2609: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 2609: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2605: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2606: l_rule_found := 'N';
2607: END IF;
2608:
2609: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2610: resultout := 'COMPLETE:N';
2611: RAISE G_EXCEPTION;
2612: END IF;
2613:

Line 2685: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2681: actid IN NUMBER,
2682: funcmode IN VARCHAR2,
2683: resultout OUT NOCOPY VARCHAR2) IS
2684:
2685: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2686: l_contract_id NUMBER;
2687: l_no_of_recipients NUMBER;
2688: -- for debug logging
2689: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'pop_pre_proceeds_title_filing';

Line 2800: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2796: ORDER BY OKLV.id ASC;
2797:
2798:
2799: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2800: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2801: l_rule_found VARCHAR2(1) := 'N';
2802: l_contract_id NUMBER;
2803: l_current_rec_id NUMBER;
2804: l_current_rec_no NUMBER;

Line 3291: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

3287: RAISE G_EXCEPTION;
3288: END IF;
3289:
3290: /*IF (l_art_id is null or l_art_id = OKC_API.G_MISS_NUM) THEN
3291: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3292: p_msg_name => g_required_value,
3293: p_token1 => g_col_name_token,
3294: p_token1_value => 'l_art_id');
3295: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3307: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

3303: resultout := 'COMPLETE:N';
3304: RAISE G_EXCEPTION;
3305: END IF;
3306: /*IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
3307: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3308: p_msg_name => g_required_value,
3309: p_token1 => g_col_name_token,
3310: p_token1_value => 'l_legal_entity_id');
3311: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3322: p_init_msg_list => OKL_API.G_TRUE, --**** SHOULD THIS BE SET TO TRUE

3318:
3319: -- call asset dispose retirement
3320: OKL_AM_ASSET_DISPOSE_PUB.dispose_asset(
3321: p_api_version => l_api_version,
3322: p_init_msg_list => OKL_API.G_TRUE, --**** SHOULD THIS BE SET TO TRUE
3323: x_return_status => l_return_status,
3324: x_msg_count => lx_msg_count,
3325: x_msg_data => lx_msg_data,
3326: p_financial_asset_id => l_amt_rec.kle_id,

Line 3337: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

3333: 'after call to OKL_AM_ASSET_DISPOSE_PUB.dispose_asset :'||l_return_status);
3334: END IF;
3335:
3336:
3337: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3338: resultout := 'COMPLETE:N';
3339: RAISE G_EXCEPTION;
3340: END IF;
3341:

Line 3350: p_init_msg_list => OKL_API.G_TRUE, --**** SHOULD THIS BE SET TO TRUE

3346: FOR l_quotelines_rec IN l_quotelines_csr(l_transaction_id) LOOP
3347:
3348: OKL_AM_ASSET_DISPOSE_PUB.dispose_asset(
3349: p_api_version => l_api_version,
3350: p_init_msg_list => OKL_API.G_TRUE, --**** SHOULD THIS BE SET TO TRUE
3351: x_return_status => l_return_status,
3352: x_msg_count => lx_msg_count,
3353: x_msg_data => lx_msg_data,
3354: p_financial_asset_id => l_quotelines_rec.kle_id,

Line 3364: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

3360: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3361: 'after call to OKL_AM_ASSET_DISPOSE_PUB.dispose_asset :'||l_return_status);
3362: END IF;
3363:
3364: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3365: resultout := 'COMPLETE:N';
3366: RAISE G_EXCEPTION;
3367: END IF;
3368:

Line 3494: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3490: l_transaction_id VARCHAR2(2000);
3491: l_api_version NUMBER := 1;
3492: lx_msg_count NUMBER;
3493: lx_msg_data VARCHAR2(32000);
3494: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3495: lp_artv_rec OKL_ASSET_RETURNS_PUB.artv_rec_type;
3496: lx_artv_rec OKL_ASSET_RETURNS_PUB.artv_rec_type;
3497:
3498: -- for debug logging

Line 3530: p_init_msg_list => OKL_API.G_FALSE,

3526:
3527: -- Call the update of the asset return
3528: OKL_ASSET_RETURNS_PUB.update_asset_returns (
3529: p_api_version => l_api_version,
3530: p_init_msg_list => OKL_API.G_FALSE,
3531: x_return_status => l_return_status,
3532: x_msg_count => lx_msg_count,
3533: x_msg_data => lx_msg_data,
3534: p_artv_rec => lp_artv_rec,

Line 3543: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

3539: 'after call to OKL_ASSET_RETURNS_PUB.update_asset_returns :'||l_return_status);
3540: END IF;
3541:
3542:
3543: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3544: resultout := 'COMPLETE:N';
3545: RAISE G_EXCEPTION;
3546: END IF;
3547: END LOOP;

Line 3645: AND qlt.amount NOT IN (OKL_API.G_MISS_NUM, 0)

3641: SELECT qlt.kle_id kle_id
3642: FROM okl_txl_quote_lines_b qlt,
3643: fnd_lookups flo
3644: WHERE qlt.qte_id = p_qte_id
3645: AND qlt.amount NOT IN (OKL_API.G_MISS_NUM, 0)
3646: AND flo.lookup_type = 'OKL_QUOTE_LINE_TYPE'
3647: AND flo.lookup_code = qlt.qlt_code
3648: AND qlt.qlt_code NOT IN (
3649: 'AMCFIA', -- Used to save quote assets, not amounts

Line 3662: AND qlt.amount NOT IN (OKL_API.G_MISS_NUM, 0)

3658: SELECT qlt.kle_id kle_id
3659: FROM okl_txl_quote_lines_b qlt,
3660: fnd_lookups flo
3661: WHERE qlt.qte_id = p_qte_id
3662: AND qlt.amount NOT IN (OKL_API.G_MISS_NUM, 0)
3663: AND flo.lookup_type = 'OKL_QUOTE_LINE_TYPE'
3664: AND flo.lookup_code = qlt.qlt_code
3665: AND qlt.qlt_code NOT IN (
3666: 'AMCFIA', -- Used to save quote assets, not amounts

Line 3683: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3679:
3680: l_api_version NUMBER := 1;
3681: lx_msg_count NUMBER;
3682: lx_msg_data VARCHAR2(2000);
3683: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3684: lx_taiv_tbl OKL_AM_INVOICES_PVT.taiv_tbl_type;
3685: l_transaction_id VARCHAR2(200);
3686: l_invoice_id NUMBER:= -9999;
3687: l_qte_amt NUMBER := -9999;

Line 3691: l_kle_id NUMBER := OKL_API.G_MISS_NUM;

3687: l_qte_amt NUMBER := -9999;
3688:
3689:
3690: -- RMUNJULU 09-MAY-03 2949544
3691: l_kle_id NUMBER := OKL_API.G_MISS_NUM;
3692: l_invoice_needed_yn VARCHAR2(1) := 'N';
3693:
3694: -- rmunjulu EDAT
3695: l_qte_partial_yn VARCHAR2(3);

Line 3781: p_init_msg_list => OKL_API.G_FALSE,

3777:
3778: -- Create invoice
3779: OKL_AM_INVOICES_PVT.Create_Quote_Invoice(
3780: p_api_version => l_api_version,
3781: p_init_msg_list => OKL_API.G_FALSE,
3782: x_return_status => l_return_status,
3783: x_msg_count => lx_msg_count,
3784: x_msg_data => lx_msg_data,
3785: p_quote_id => TO_NUMBER(l_transaction_id),

Line 3798: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

3794: END IF;
3795:
3796: END IF;
3797:
3798: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3799: resultout := 'COMPLETE:N';
3800: RAISE G_EXCEPTION;
3801: ELSE
3802: resultout := 'COMPLETE:Y';

Line 3922: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3918: l_transaction_id VARCHAR2(2000);
3919: l_api_version NUMBER := 1;
3920: lx_msg_count NUMBER;
3921: lx_msg_data VARCHAR2(2000);
3922: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3923: lp_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
3924: lx_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
3925: l_quote_status VARCHAR2(200) := 'COMPLETE';--'OKL_QUOTE_STATUS'
3926: -- Start : PRASJAIN : Bug 6324373

Line 3975: p_init_msg_list => OKL_API.G_FALSE,

3971:
3972: -- Call the update of the quote header api
3973: OKL_TRX_QUOTES_PUB.update_trx_quotes (
3974: p_api_version => l_api_version,
3975: p_init_msg_list => OKL_API.G_FALSE,
3976: x_return_status => l_return_status,
3977: x_msg_count => lx_msg_count,
3978: x_msg_data => lx_msg_data,
3979: p_qtev_rec => lp_qtev_rec,

Line 3987: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

3983: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3984: 'after call to OKL_TRX_QUOTES_PUB.update_trx_quotes :'||l_return_status);
3985: END IF;
3986:
3987: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3988: resultout := 'COMPLETE:N';
3989: RAISE G_EXCEPTION;
3990: ELSE
3991: resultout := 'COMPLETE:Y';

Line 4091: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

4087:
4088: l_recipient_name varchar2(100);
4089: l_recipient_id number;
4090: l_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;
4091: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4092:
4093: --12/18/06 rkuttiya added for XMLP Project
4094: x_msg_count NUMBER;
4095: x_msg_data VARCHAR2(2000);

Line 5377: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

5373: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
5374: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
5375: END IF;
5376:
5377: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
5378:
5379: IF NVL (l_rulv_rec.rule_information1, '*') = 'Y' THEN
5380:
5381: resultout := 'COMPLETE:Y';

Line 5385: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

5381: resultout := 'COMPLETE:Y';
5382: ELSE
5383: resultout := 'COMPLETE:N';
5384: END IF;
5385: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
5386:
5387: resultout := 'COMPLETE:N';
5388: ELSE
5389: RAISE API_ERROR;

Line 5662: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

5658: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
5659: END IF;
5660:
5661:
5662: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
5663: IF NVL (l_rulv_rec.rule_information1, '*') = 'Y' THEN
5664: l_result := CHECK_CALC_OPTIONS(itemtype => itemtype,
5665: itemkey => itemkey,
5666: actid => actid,

Line 5704: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

5700: l_result := 'COMPLETE:NO';
5701: end if;
5702:
5703:
5704: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
5705: resultout := 'COMPLETE:NO';
5706: ELSE
5707: RAISE API_ERROR;
5708: END IF;

Line 5763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

5759: resultout OUT NOCOPY VARCHAR2) IS
5760:
5761: l_quote_id varchar2(100);
5762:
5763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5764: l_api_version CONSTANT NUMBER := 1;
5765: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5766: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5767: l_msg_data VARCHAR2(2000);

Line 5765: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

5761: l_quote_id varchar2(100);
5762:
5763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5764: l_api_version CONSTANT NUMBER := 1;
5765: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5766: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5767: l_msg_data VARCHAR2(2000);
5768: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
5769: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

Line 5766: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

5762:
5763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5764: l_api_version CONSTANT NUMBER := 1;
5765: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5766: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5767: l_msg_data VARCHAR2(2000);
5768: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
5769: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
5770: l_party_count NUMBER;

Line 5795: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

5791: l_q_party_uv_rec.quote_id := l_quote_id;
5792: l_q_party_uv_rec.qp_role_code := 'APPROVER';
5793:
5794:
5795: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5796: RAISE API_ERROR;
5797: END IF;
5798:
5799: okl_am_parties_pvt.get_quote_parties (

Line 5888: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

5884: l_quote_id NUMBER;
5885: l_party_count NUMBER;
5886: l_party_type VARCHAR2(30);
5887:
5888: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5889: l_api_version CONSTANT NUMBER := 1;
5890: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5891: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5892: l_msg_data VARCHAR2(2000);

Line 5890: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

5886: l_party_type VARCHAR2(30);
5887:
5888: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5889: l_api_version CONSTANT NUMBER := 1;
5890: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5891: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5892: l_msg_data VARCHAR2(2000);
5893: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
5894: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

Line 5891: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

5887:
5888: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5889: l_api_version CONSTANT NUMBER := 1;
5890: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
5891: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
5892: l_msg_data VARCHAR2(2000);
5893: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
5894: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
5895: l_total_party_count NUMBER;

Line 6173: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

6169: resultout OUT NOCOPY VARCHAR2) IS
6170:
6171: l_quote_id varchar2(100);
6172:
6173: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6174: l_api_version CONSTANT NUMBER := 1;
6175: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6176: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6177: l_msg_data VARCHAR2(2000);

Line 6175: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

6171: l_quote_id varchar2(100);
6172:
6173: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6174: l_api_version CONSTANT NUMBER := 1;
6175: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6176: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6177: l_msg_data VARCHAR2(2000);
6178: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6179: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

Line 6176: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

6172:
6173: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6174: l_api_version CONSTANT NUMBER := 1;
6175: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6176: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6177: l_msg_data VARCHAR2(2000);
6178: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6179: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6180: l_party_count NUMBER;

Line 6225: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

6221: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6222: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);
6223: END IF;
6224:
6225: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6226: RAISE API_ERROR;
6227: END IF;
6228:
6229: IF l_party_count > 0 THEN

Line 6313: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

6309:
6310:
6311: l_quote_id varchar2(100);
6312:
6313: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6314: l_api_version CONSTANT NUMBER := 1;
6315: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6316: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6317: l_msg_data VARCHAR2(2000);

Line 6315: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

6311: l_quote_id varchar2(100);
6312:
6313: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6314: l_api_version CONSTANT NUMBER := 1;
6315: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6316: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6317: l_msg_data VARCHAR2(2000);
6318: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6319: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

Line 6316: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

6312:
6313: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6314: l_api_version CONSTANT NUMBER := 1;
6315: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6316: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6317: l_msg_data VARCHAR2(2000);
6318: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6319: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6320: l_party_count NUMBER;

Line 6344: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

6340:
6341: l_q_party_uv_rec.quote_id := l_quote_id;
6342: l_q_party_uv_rec.qp_role_code := 'RECIPIENT';
6343:
6344: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6345: RAISE API_ERROR;
6346: END IF;
6347:
6348: okl_am_parties_pvt.get_quote_parties (

Line 6434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

6430:
6431:
6432: l_quote_id varchar2(100);
6433:
6434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6435: l_api_version CONSTANT NUMBER := 1;
6436: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6437: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6438: l_msg_data VARCHAR2(2000);

Line 6436: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

6432: l_quote_id varchar2(100);
6433:
6434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6435: l_api_version CONSTANT NUMBER := 1;
6436: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6437: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6438: l_msg_data VARCHAR2(2000);
6439: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6440: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

Line 6437: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

6433:
6434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6435: l_api_version CONSTANT NUMBER := 1;
6436: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6437: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6438: l_msg_data VARCHAR2(2000);
6439: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6440: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6441: l_party_count NUMBER;

Line 6464: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

6460:
6461: l_q_party_uv_rec.quote_id := l_quote_id;
6462: l_q_party_uv_rec.qp_role_code := 'FYI';
6463:
6464: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6465: RAISE API_ERROR;
6466: END IF;
6467:
6468: okl_am_parties_pvt.get_quote_parties (

Line 6555: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

6551:
6552:
6553: l_quote_id varchar2(100);
6554:
6555: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6556: l_api_version CONSTANT NUMBER := 1;
6557: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6558: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6559: l_msg_data VARCHAR2(2000);

Line 6557: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

6553: l_quote_id varchar2(100);
6554:
6555: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6556: l_api_version CONSTANT NUMBER := 1;
6557: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6558: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6559: l_msg_data VARCHAR2(2000);
6560: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6561: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

Line 6558: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

6554:
6555: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6556: l_api_version CONSTANT NUMBER := 1;
6557: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
6558: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
6559: l_msg_data VARCHAR2(2000);
6560: l_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
6561: l_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
6562: l_party_count NUMBER;

Line 6586: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

6582:
6583: l_q_party_uv_rec.quote_id := l_quote_id;
6584: l_q_party_uv_rec.qp_role_code := 'RECIPIENT_ADDITIONAL';
6585:
6586: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6587: RAISE API_ERROR;
6588: END IF;
6589:
6590: okl_am_parties_pvt.get_quote_parties (

Line 6605: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

6601: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6602: 'after call to okl_am_parties_pvt.get_quote_parties :'||l_return_status);
6603: END IF;
6604:
6605: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6606: RAISE API_ERROR;
6607: END IF;
6608:
6609: IF l_party_count > 0 THEN

Line 6762: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

6758: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);
6759: END IF;
6760:
6761:
6762: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
6763:
6764: --rkuttiya 16-SEP-2003 added following code for bug:2794685
6765: l_calc_option := l_rulv_rec.rule_information7;
6766: l_fixed_value := NVL(TO_NUMBER(l_rulv_rec.rule_information4),0);

Line 6801: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

6797: p_additional_parameters => l_params, -- RMUNJULU 2794685 Added
6798: x_formula_value => l_formula_value,
6799: x_return_status => l_return_status);
6800:
6801: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6802: l_gain_loss_approval := 'COMPLETE:STOP';
6803: G_STOP := 'TFORMULAE'; -- Tolerance Formula has returned error
6804:
6805: RETURN l_gain_loss_approval; -- RMUNJULU 2794685 Added

Line 6833: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

6829: p_additional_parameters => l_params,
6830: x_formula_value => l_formula_value,
6831: x_return_status => l_return_status);
6832:
6833: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6834: l_gain_loss_approval := 'COMPLETE:STOP';
6835: G_STOP := 'AFORMULAE'; -- Approval Processing Formula returned error
6836:
6837: RETURN l_gain_loss_approval; -- RMUNJULU 2794685 Added

Line 6933: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

6929: p_cle_id => l_rec.kle_id,
6930: x_formula_value => l_formula_value,
6931: x_return_status => l_return_status);
6932:
6933: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6934: RAISE API_ERROR;
6935: ELSE
6936: l_quote_net := l_quote_net + l_formula_value;
6937: END IF;

Line 7953: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

7949: resultout OUT NOCOPY VARCHAR2 ) AS
7950:
7951: l_quote_id VARCHAR2(100);
7952:
7953: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7954: l_api_version CONSTANT NUMBER := 1;
7955: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
7956: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
7957: l_msg_data VARCHAR2(2000);

Line 7955: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

7951: l_quote_id VARCHAR2(100);
7952:
7953: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7954: l_api_version CONSTANT NUMBER := 1;
7955: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
7956: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
7957: l_msg_data VARCHAR2(2000);
7958:
7959: API_ERROR EXCEPTION;

Line 7956: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

7952:
7953: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7954: l_api_version CONSTANT NUMBER := 1;
7955: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
7956: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
7957: l_msg_data VARCHAR2(2000);
7958:
7959: API_ERROR EXCEPTION;
7960:

Line 8012: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

8008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
8009: 'after call to OKL_AM_SECURITIZATION_PVT.process_securitized_streams :'||l_return_status);
8010: END IF;
8011:
8012: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
8013: RAISE API_ERROR;
8014: END IF;
8015:
8016: RETURN ;

Line 8094: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

8090: l_transaction_id VARCHAR2(2000);
8091: l_api_version NUMBER := 1;
8092: lx_msg_count NUMBER;
8093: lx_msg_data VARCHAR2(2000);
8094: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8095: lp_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
8096: lx_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
8097: l_quote_status VARCHAR2(200) := 'DRAFTED';--'OKL_QUOTE_STATUS'
8098: -- for debug logging

Line 8126: p_init_msg_list => OKL_API.G_FALSE,

8122:
8123: -- Call the update of the quote header api
8124: OKL_TRX_QUOTES_PUB.update_trx_quotes (
8125: p_api_version => l_api_version,
8126: p_init_msg_list => OKL_API.G_FALSE,
8127: x_return_status => l_return_status,
8128: x_msg_count => lx_msg_count,
8129: x_msg_data => lx_msg_data,
8130: p_qtev_rec => lp_qtev_rec,

Line 8138: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

8134: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
8135: 'after call to OKL_TRX_QUOTES_PUB.update_trx_quotes :'||l_return_status);
8136: END IF;
8137:
8138: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
8139: RAISE G_EXCEPTION;
8140: ELSE
8141: resultout := 'COMPLETE:';
8142: END IF;

Line 8198: -- This set_message is used instead of the standard OKL_API.set_message

8194: --
8195: -- Procedure Name : set_message
8196: -- Desciption : Sets the message with tokens
8197: -- Does NOT put the message on the message stack
8198: -- This set_message is used instead of the standard OKL_API.set_message
8199: -- because the OKL_API.set_message puts the message on message stack after
8200: -- which it cannot be retrieved using FND_MESSAGE.get
8201: -- Business Rules :
8202: -- Parameters :

Line 8199: -- because the OKL_API.set_message puts the message on message stack after

8195: -- Procedure Name : set_message
8196: -- Desciption : Sets the message with tokens
8197: -- Does NOT put the message on the message stack
8198: -- This set_message is used instead of the standard OKL_API.set_message
8199: -- because the OKL_API.set_message puts the message on message stack after
8200: -- which it cannot be retrieved using FND_MESSAGE.get
8201: -- Business Rules :
8202: -- Parameters :
8203: -- Version : 1.0

Line 8326: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

8322: FROM OKL_TXL_QUOTE_LINES_B
8323: WHERE qte_id =c_id
8324: AND qlt_code NOT IN ('AMCFIA','AMYOUB','BILL_ADJST');
8325:
8326: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8327:
8328: l_result VARCHAR2(50) := 'COMPLETE:NO';
8329:
8330: l_last_updated_by NUMBER;

Line 8597: IF lx_return_sts = OKL_API.G_RET_STS_SUCCESS THEN

8593:
8594: l_repo_yn := OKL_AM_CREATE_QUOTE_PVT.check_repo_quote(l_id,
8595: lx_return_sts);
8596:
8597: IF lx_return_sts = OKL_API.G_RET_STS_SUCCESS THEN
8598: IF l_repo_yn = 'Y' THEN
8599: resultout := 'COMPLETE:Y';
8600: ELSIF NVL(l_repo_yn,'N') = 'N' THEN
8601: resultout := 'COMPLETE:N';

Line 8672: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

8668:
8669: l_api_version NUMBER := 1;
8670: lx_msg_count NUMBER;
8671: lx_msg_data VARCHAR2(2000);
8672: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8673: lp_artv_rec OKL_AM_ASSET_RETURN_PUB.artv_rec_type;
8674: lx_artv_rec OKL_AM_ASSET_RETURN_PUB.artv_rec_type;
8675: -- for debug logging
8676: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_repo_asset_return';

Line 8741: l_formula_name <> OKL_API.G_MISS_CHAR) THEN

8737:
8738: /* 6712322 Evaluate ASSET_RETURN_VALUE formula and attach */
8739: -- set the operands for formula engine with quote_id
8740: IF (l_formula_name IS NOT NULL AND
8741: l_formula_name <> OKL_API.G_MISS_CHAR) THEN
8742: l_params(1).name := 'quote_id';
8743: l_params(1).value := to_char(l_id);
8744:
8745: /*OKL_EXECUTE_FORMULA_PUB.execute(

Line 8747: p_init_msg_list => OKL_API.G_FALSE,

8743: l_params(1).value := to_char(l_id);
8744:
8745: /*OKL_EXECUTE_FORMULA_PUB.execute(
8746: p_api_version => l_api_version,
8747: p_init_msg_list => OKL_API.G_FALSE,
8748: x_return_status => l_return_status,
8749: x_msg_count => lx_msg_count,
8750: x_msg_data => lx_msg_data,
8751: p_formula_name => 'ASSET_RETURN_VALUE',

Line 8766: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

8762: x_formula_value => l_asset_return_value,
8763: x_return_status => l_return_status);
8764:
8765:
8766: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8767: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8768: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8769: RAISE Okl_Api.G_EXCEPTION_ERROR;
8770: END IF;

Line 8767: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

8763: x_return_status => l_return_status);
8764:
8765:
8766: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8767: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8768: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8769: RAISE Okl_Api.G_EXCEPTION_ERROR;
8770: END IF;
8771:

Line 8768: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

8764:
8765:
8766: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8767: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8768: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8769: RAISE Okl_Api.G_EXCEPTION_ERROR;
8770: END IF;
8771:
8772: lp_artv_rec.asset_fmv_amount := l_asset_return_value;

Line 8769: RAISE Okl_Api.G_EXCEPTION_ERROR;

8765:
8766: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8767: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8768: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8769: RAISE Okl_Api.G_EXCEPTION_ERROR;
8770: END IF;
8771:
8772: lp_artv_rec.asset_fmv_amount := l_asset_return_value;
8773:

Line 8802: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

8798: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_currency_conversion_date: ' || lx_currency_conversion_date);
8799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
8800: END IF;
8801:
8802: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8803: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8804: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
8805: RAISE OKL_API.G_EXCEPTION_ERROR;
8806: END IF;

Line 8803: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8799: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'lx_converted_amount: ' || lx_converted_amount);
8800: END IF;
8801:
8802: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8803: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8804: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
8805: RAISE OKL_API.G_EXCEPTION_ERROR;
8806: END IF;
8807:

Line 8804: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

8800: END IF;
8801:
8802: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8803: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8804: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
8805: RAISE OKL_API.G_EXCEPTION_ERROR;
8806: END IF;
8807:
8808: lp_artv_rec.asset_fmv_amount := lx_converted_amount;

Line 8805: RAISE OKL_API.G_EXCEPTION_ERROR;

8801:
8802: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8803: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8804: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
8805: RAISE OKL_API.G_EXCEPTION_ERROR;
8806: END IF;
8807:
8808: lp_artv_rec.asset_fmv_amount := lx_converted_amount;
8809:

Line 8817: p_init_msg_list => OKL_API.G_FALSE,

8813: END IF;
8814:
8815: OKL_AM_ASSET_RETURN_PVT.create_asset_return(
8816: p_api_version => l_api_version,
8817: p_init_msg_list => OKL_API.G_FALSE,
8818: x_return_status => l_return_status,
8819: x_msg_count => lx_msg_count,
8820: x_msg_data => lx_msg_data,
8821: p_artv_rec => lp_artv_rec,

Line 8830: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

8826: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
8827: 'after call to OKL_AM_ASSET_RETURN_PVT.create_asset_return :'||l_return_status);
8828: END IF;
8829:
8830: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
8831: RAISE G_EXCEPTION;
8832: ELSE
8833: resultout := 'COMPLETE:';
8834: END IF;