DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_AM_UTIL_PVT

Line 1184: lx_trn_tbl OKL_AM_UTIL_PVT.trn_tbl_type;

1180: -- Added these variables
1181: db_qst_code VARCHAR2(200);
1182: l_qst_code_1 VARCHAR2(200);
1183: l_qst_code_2 VARCHAR2(200);
1184: lx_trn_tbl OKL_AM_UTIL_PVT.trn_tbl_type;
1185: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;
1186: lx_asset_serialized_yn VARCHAR2(3);
1187: lx_clev_tbl clev_tbl_type;
1188: l_ib_lines_count NUMBER;

Line 1185: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;

1181: db_qst_code VARCHAR2(200);
1182: l_qst_code_1 VARCHAR2(200);
1183: l_qst_code_2 VARCHAR2(200);
1184: lx_trn_tbl OKL_AM_UTIL_PVT.trn_tbl_type;
1185: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;
1186: lx_asset_serialized_yn VARCHAR2(3);
1187: lx_clev_tbl clev_tbl_type;
1188: l_ib_lines_count NUMBER;
1189:

Line 1589: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_EFFECTIVE_TO'));

1585: IF (NVL(db_repo_yn,'N') <> 'Y') THEN -- 6674730
1586: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1587: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
1588: p_token1 => 'PROMPT',
1589: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_EFFECTIVE_TO'));
1590:
1591: RAISE OKL_API.G_EXCEPTION_ERROR;
1592: END IF;
1593:

Line 1802: l_qst_code_1 := OKL_AM_UTIL_PVT.get_lookup_meaning(

1798: -- If quote status not APPROVED then error
1799: -- *****************
1800:
1801: -- Get APPROVED meaning
1802: l_qst_code_1 := OKL_AM_UTIL_PVT.get_lookup_meaning(
1803: 'OKL_QUOTE_STATUS',
1804: 'APPROVED',
1805: 'Y');
1806:

Line 1808: l_qst_code_2 := OKL_AM_UTIL_PVT.get_lookup_meaning(

1804: 'APPROVED',
1805: 'Y');
1806:
1807: -- Get ACCEPTED meaning
1808: l_qst_code_2 := OKL_AM_UTIL_PVT.get_lookup_meaning(
1809: 'OKL_QUOTE_STATUS',
1810: 'ACCEPTED',
1811: 'Y');
1812:

Line 1987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');

1983: -- IF unprocessed termination trn exists for the contract then error
1984: -- *****************
1985:
1986: IF (is_debug_statement_on) THEN
1987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');
1988: END IF;
1989: -- Get all the unprocessed transactions for the contract
1990: OKL_AM_UTIL_PVT.get_contract_transactions (
1991: p_khr_id => l_contract_id,

Line 1990: OKL_AM_UTIL_PVT.get_contract_transactions (

1986: IF (is_debug_statement_on) THEN
1987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');
1988: END IF;
1989: -- Get all the unprocessed transactions for the contract
1990: OKL_AM_UTIL_PVT.get_contract_transactions (
1991: p_khr_id => l_contract_id,
1992: x_trn_tbl => lx_trn_tbl,
1993: x_return_status => l_return_status);
1994: IF (is_debug_statement_on) THEN

Line 1995: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_transactions , return status: ' || l_return_status);

1991: p_khr_id => l_contract_id,
1992: x_trn_tbl => lx_trn_tbl,
1993: x_return_status => l_return_status);
1994: IF (is_debug_statement_on) THEN
1995: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_transactions , return status: ' || l_return_status);
1996: END IF;
1997:
1998: -- Check the return status
1999: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 2027: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');

2023: -- IF accepted quote with no trn exists for contract then error
2024: -- *****************
2025:
2026: IF (is_debug_statement_on) THEN
2027: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');
2028: END IF;
2029: -- Get accepted quote for contract with no trn
2030: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (
2031: p_khr_id => l_contract_id,

Line 2030: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (

2026: IF (is_debug_statement_on) THEN
2027: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');
2028: END IF;
2029: -- Get accepted quote for contract with no trn
2030: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (
2031: p_khr_id => l_contract_id,
2032: x_quote_tbl => lx_quote_tbl,
2033: x_return_status => l_return_status);
2034: IF (is_debug_statement_on) THEN

Line 2035: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_non_trn_contract_quotes , return status: ' || l_return_status);

2031: p_khr_id => l_contract_id,
2032: x_quote_tbl => lx_quote_tbl,
2033: x_return_status => l_return_status);
2034: IF (is_debug_statement_on) THEN
2035: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_non_trn_contract_quotes , return status: ' || l_return_status);
2036: END IF;
2037:
2038: -- Check the return status
2039: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 2049: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(

2045:
2046: -- Check if accepted quote exists for the contract
2047: IF lx_quote_tbl.COUNT > 0 THEN
2048:
2049: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(
2050: 'OKL_QUOTE_TYPE',
2051: lx_quote_tbl(lx_quote_tbl.FIRST).qtp_code,
2052: 'Y');
2053:

Line 2320: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');

2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318:
2319: IF (is_debug_statement_on) THEN
2320: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
2321: END IF;
2322: -- rmunjulu LOANS_ENHACEMENTS Termination with purchase not allowed for loans
2323: -- Get the contract product details
2324: OKL_AM_UTIL_PVT.get_contract_product_details(

Line 2324: OKL_AM_UTIL_PVT.get_contract_product_details(

2320: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
2321: END IF;
2322: -- rmunjulu LOANS_ENHACEMENTS Termination with purchase not allowed for loans
2323: -- Get the contract product details
2324: OKL_AM_UTIL_PVT.get_contract_product_details(
2325: p_khr_id => l_contract_id,
2326: x_deal_type => l_deal_type,
2327: x_rev_rec_method => l_rev_rec_method,
2328: x_int_cal_basis => l_int_cal_basis,

Line 2332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_product_details , return status: ' || l_return_status);

2328: x_int_cal_basis => l_int_cal_basis,
2329: x_tax_owner => l_tax_owner,
2330: x_return_status => l_return_status);
2331: IF (is_debug_statement_on) THEN
2332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_product_details , return status: ' || l_return_status);
2333: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_deal_type: ' || l_deal_type);
2334: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rev_rec_method: ' || l_rev_rec_method);
2335: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_int_cal_basis: ' || l_int_cal_basis);
2336: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_tax_owner: ' || l_tax_owner);

Line 2365: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');

2361: IF db_partial_yn = 'Y' THEN -- SECHAWLA 04-JAN-06 4915133 : partial quotes not allowed for loan k with
2362: -- rev rec method 'ESTIMATED_AND_BILLED','ACTUAL'
2363: -- Get the contract product details
2364: IF (is_debug_statement_on) THEN
2365: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
2366: END IF;
2367: OKL_AM_UTIL_PVT.get_contract_product_details(
2368: p_khr_id => l_contract_id,
2369: x_deal_type => l_deal_type,

Line 2367: OKL_AM_UTIL_PVT.get_contract_product_details(

2363: -- Get the contract product details
2364: IF (is_debug_statement_on) THEN
2365: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
2366: END IF;
2367: OKL_AM_UTIL_PVT.get_contract_product_details(
2368: p_khr_id => l_contract_id,
2369: x_deal_type => l_deal_type,
2370: x_rev_rec_method => l_rev_rec_method,
2371: x_int_cal_basis => l_int_cal_basis,

Line 2375: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_product_details , return status: ' || l_return_status);

2371: x_int_cal_basis => l_int_cal_basis,
2372: x_tax_owner => l_tax_owner,
2373: x_return_status => l_return_status);
2374: IF (is_debug_statement_on) THEN
2375: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_product_details , return status: ' || l_return_status);
2376: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_deal_type: ' || l_deal_type);
2377: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rev_rec_method: ' || l_rev_rec_method);
2378: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_int_cal_basis: ' || l_int_cal_basis);
2379: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_tax_owner: ' || l_tax_owner);

Line 2409: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_all_term_quotes_for_line');

2405: -- *****************
2406:
2407:
2408: IF (is_debug_statement_on) THEN
2409: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_all_term_quotes_for_line');
2410: END IF;
2411: -- Get quotes for line
2412: OKL_AM_UTIL_PVT.get_all_term_quotes_for_line (
2413: p_kle_id => get_qte_lines_rec.kle_id,

Line 2412: OKL_AM_UTIL_PVT.get_all_term_quotes_for_line (

2408: IF (is_debug_statement_on) THEN
2409: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_all_term_quotes_for_line');
2410: END IF;
2411: -- Get quotes for line
2412: OKL_AM_UTIL_PVT.get_all_term_quotes_for_line (
2413: p_kle_id => get_qte_lines_rec.kle_id,
2414: x_quote_tbl => lx_quote_tbl,
2415: x_return_status => l_return_status);
2416: IF (is_debug_statement_on) THEN

Line 2417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_all_term_quotes_for_line , return status: ' || l_return_status);

2413: p_kle_id => get_qte_lines_rec.kle_id,
2414: x_quote_tbl => lx_quote_tbl,
2415: x_return_status => l_return_status);
2416: IF (is_debug_statement_on) THEN
2417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_all_term_quotes_for_line , return status: ' || l_return_status);
2418: END IF;
2419:
2420:
2421:

Line 2617: 'calling OKL_AM_UTIL_PVT.get_contract_product_details ');

2613: END IF;
2614:
2615: IF (is_debug_statement_on) THEN
2616: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,
2617: 'calling OKL_AM_UTIL_PVT.get_contract_product_details ');
2618: END IF;
2619:
2620: -- Get the Product Qualities
2621: OKL_AM_UTIL_PVT.get_contract_product_details (

Line 2621: OKL_AM_UTIL_PVT.get_contract_product_details (

2617: 'calling OKL_AM_UTIL_PVT.get_contract_product_details ');
2618: END IF;
2619:
2620: -- Get the Product Qualities
2621: OKL_AM_UTIL_PVT.get_contract_product_details (
2622: p_khr_id => l_contract_id,
2623: x_deal_type => l_deal_type,
2624: x_rev_rec_method => l_rev_rec_method,
2625: x_int_cal_basis => l_int_cal_basis,

Line 2631: 'called OKL_AM_UTIL_PVT.get_contract_product_details ');

2627: x_return_status => l_return_status);
2628:
2629: IF (is_debug_statement_on) THEN
2630: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,
2631: 'called OKL_AM_UTIL_PVT.get_contract_product_details ');
2632:
2633: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,
2634: 'l_return_status: ' || l_return_status);
2635: END IF;

Line 3140: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(

3136: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3137: END IF;
3138:
3139: -- Get the event name
3140: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3141: p_wf_process_type => 'OKLAMPPT',
3142: p_wf_process_name => 'OKL_AM_PRE_PRO_TER',
3143: x_return_status => l_return_status);
3144: IF (is_debug_statement_on) THEN

Line 3169: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(

3165: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3166: END IF;
3167:
3168: -- Get the event name
3169: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3170: p_wf_process_type => 'OKLAMPPT',
3171: p_wf_process_name => 'OKL_AM_POST_PRO_TER',
3172: x_return_status => l_return_status);
3173: IF (is_debug_statement_on) THEN

Line 3196: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');

3192: p_token1_value => l_event_name);
3193:
3194:
3195: IF (is_debug_statement_on) THEN
3196: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3197: END IF;
3198: -- Save message from stack into transaction message table
3199: OKL_AM_UTIL_PVT.process_messages(
3200: p_trx_source_table => 'OKL_TRX_QUOTES_V',

Line 3199: OKL_AM_UTIL_PVT.process_messages(

3195: IF (is_debug_statement_on) THEN
3196: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3197: END IF;
3198: -- Save message from stack into transaction message table
3199: OKL_AM_UTIL_PVT.process_messages(
3200: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3201: p_trx_id => lp_term_rec.id,
3202: x_return_status => l_return_status);
3203: IF (is_debug_statement_on) THEN

Line 3204: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);

3200: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3201: p_trx_id => lp_term_rec.id,
3202: x_return_status => l_return_status);
3203: IF (is_debug_statement_on) THEN
3204: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);
3205: END IF;
3206:
3207: -- raise exception if error
3208: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3473: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(

3469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3470: END IF;
3471:
3472: -- Get the event name
3473: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3474: p_wf_process_type => 'OKLAMPPT',
3475: p_wf_process_name => 'OKL_AM_PRE_PRO_TER',
3476: x_return_status => x_return_status);
3477: IF (is_debug_statement_on) THEN

Line 3513: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(

3509: IF (is_debug_statement_on) THEN
3510: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3511: END IF;
3512: -- Get the event name
3513: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3514: p_wf_process_type => 'OKLAMPPT',
3515: p_wf_process_name => 'OKL_AM_POST_PRO_TER',
3516: x_return_status => x_return_status);
3517: IF (is_debug_statement_on) THEN

Line 3540: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');

3536:
3537: END IF;
3538:
3539: IF (is_debug_statement_on) THEN
3540: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3541: END IF;
3542: -- Save message from stack into transaction message table
3543: OKL_AM_UTIL_PVT.process_messages(
3544: p_trx_source_table => 'OKL_TRX_QUOTES_V',

Line 3543: OKL_AM_UTIL_PVT.process_messages(

3539: IF (is_debug_statement_on) THEN
3540: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3541: END IF;
3542: -- Save message from stack into transaction message table
3543: OKL_AM_UTIL_PVT.process_messages(
3544: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3545: p_trx_id => p_term_tbl(i).id,
3546: x_return_status => x_return_status);
3547: IF (is_debug_statement_on) THEN

Line 3548: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || x_return_status);

3544: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3545: p_trx_id => p_term_tbl(i).id,
3546: x_return_status => x_return_status);
3547: IF (is_debug_statement_on) THEN
3548: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || x_return_status);
3549: END IF;
3550:
3551: -- raise exception if error
3552: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');

3790: p_transaction_id => p_term_rec.id,
3791: p_event_name => 'oracle.apps.okl.am.submitquoteforapproval');
3792: IF (is_debug_statement_on) THEN
3793: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3795: END IF;
3796: -- Save messages in database
3797: OKL_AM_UTIL_PVT.process_messages (
3798: p_trx_source_table => 'OKL_TRX_QUOTES_V',

Line 3797: OKL_AM_UTIL_PVT.process_messages (

3793: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3795: END IF;
3796: -- Save messages in database
3797: OKL_AM_UTIL_PVT.process_messages (
3798: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3799: p_trx_id => p_term_rec.id,
3800: x_return_status => l_return_status);
3801: IF (is_debug_statement_on) THEN

Line 3802: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);

3798: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3799: p_trx_id => p_term_rec.id,
3800: x_return_status => l_return_status);
3801: IF (is_debug_statement_on) THEN
3802: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);
3803: END IF;
3804:
3805: END IF;
3806: -- ELSE

Line 4744: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_TYPE'));

4740: OKL_API.set_message(
4741: p_app_name => OKL_API.G_APP_NAME,
4742: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
4743: p_token1 => 'PROMPT',
4744: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_TYPE'));
4745:
4746: RAISE OKL_API.G_EXCEPTION_ERROR;
4747:
4748: END IF;

Line 4759: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_AMOUNT'));

4755: OKL_API.set_message(
4756: p_app_name => OKL_API.G_APP_NAME,
4757: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
4758: p_token1 => 'PROMPT',
4759: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_AMOUNT'));
4760:
4761: RAISE OKL_API.G_EXCEPTION_ERROR;
4762:
4763: END IF;

Line 4898: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;

4894: END IF;
4895:
4896: -- Get the functional currency from AM_Util
4897: -- RMUNJULU 30-DEC-02 2699412 changed to call right function
4898: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;
4899:
4900:
4901: -- Get the contract id for the quote line
4902: -- RMUNJULU 31-JAN-03 2780539 Changed to send the qte_id to cursor