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 5379: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

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

Line 5387: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

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

Line 5664: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

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

Line 5706: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

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

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

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

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

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

Line 5768: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

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

Line 5797: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

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

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

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

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

Line 5893: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

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

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

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

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

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

Line 6178: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

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

Line 6227: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

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

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

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

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

Line 6318: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

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

Line 6346: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

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

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

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

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

Line 6439: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

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

Line 6466: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

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

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

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

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

Line 6560: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

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

Line 6588: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

Line 6607: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

Line 6764: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

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

Line 6803: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

Line 6835: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

Line 6935: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

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

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

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

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

Line 7958: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

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

Line 8014: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 8128: p_init_msg_list => OKL_API.G_FALSE,

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

Line 8140: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

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

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

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

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

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

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

Line 8599: IF lx_return_sts = OKL_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 8743: l_formula_name <> OKL_API.G_MISS_CHAR) THEN

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

Line 8749: p_init_msg_list => OKL_API.G_FALSE,

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

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

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

Line 8769: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 8771: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 8805: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 8807: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 8819: p_init_msg_list => OKL_API.G_FALSE,

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

Line 8832: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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