DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_AM_UTIL_PVT

Line 1196: lx_trn_tbl OKL_AM_UTIL_PVT.trn_tbl_type;

1192: -- Added these variables
1193: db_qst_code VARCHAR2(200);
1194: l_qst_code_1 VARCHAR2(200);
1195: l_qst_code_2 VARCHAR2(200);
1196: lx_trn_tbl OKL_AM_UTIL_PVT.trn_tbl_type;
1197: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;
1198: lx_asset_serialized_yn VARCHAR2(3);
1199: lx_clev_tbl clev_tbl_type;
1200: l_ib_lines_count NUMBER;

Line 1197: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;

1193: db_qst_code VARCHAR2(200);
1194: l_qst_code_1 VARCHAR2(200);
1195: l_qst_code_2 VARCHAR2(200);
1196: lx_trn_tbl OKL_AM_UTIL_PVT.trn_tbl_type;
1197: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;
1198: lx_asset_serialized_yn VARCHAR2(3);
1199: lx_clev_tbl clev_tbl_type;
1200: l_ib_lines_count NUMBER;
1201:

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

1637: IF (NVL(db_repo_yn,'N') <> 'Y') THEN -- 6674730
1638: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1639: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
1640: p_token1 => 'PROMPT',
1641: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_EFFECTIVE_TO'));
1642:
1643: RAISE OKL_API.G_EXCEPTION_ERROR;
1644: END IF;
1645:

Line 1854: l_qst_code_1 := OKL_AM_UTIL_PVT.get_lookup_meaning(

1850: -- If quote status not APPROVED then error
1851: -- *****************
1852:
1853: -- Get APPROVED meaning
1854: l_qst_code_1 := OKL_AM_UTIL_PVT.get_lookup_meaning(
1855: 'OKL_QUOTE_STATUS',
1856: 'APPROVED',
1857: 'Y');
1858:

Line 1860: l_qst_code_2 := OKL_AM_UTIL_PVT.get_lookup_meaning(

1856: 'APPROVED',
1857: 'Y');
1858:
1859: -- Get ACCEPTED meaning
1860: l_qst_code_2 := OKL_AM_UTIL_PVT.get_lookup_meaning(
1861: 'OKL_QUOTE_STATUS',
1862: 'ACCEPTED',
1863: 'Y');
1864:

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

2035: -- IF unprocessed termination trn exists for the contract then error
2036: -- *****************
2037:
2038: IF (is_debug_statement_on) THEN
2039: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');
2040: END IF;
2041: -- Get all the unprocessed transactions for the contract
2042: OKL_AM_UTIL_PVT.get_contract_transactions (
2043: p_khr_id => l_contract_id,

Line 2042: OKL_AM_UTIL_PVT.get_contract_transactions (

2038: IF (is_debug_statement_on) THEN
2039: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_transactions');
2040: END IF;
2041: -- Get all the unprocessed transactions for the contract
2042: OKL_AM_UTIL_PVT.get_contract_transactions (
2043: p_khr_id => l_contract_id,
2044: x_trn_tbl => lx_trn_tbl,
2045: x_return_status => l_return_status);
2046: IF (is_debug_statement_on) THEN

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

2043: p_khr_id => l_contract_id,
2044: x_trn_tbl => lx_trn_tbl,
2045: x_return_status => l_return_status);
2046: IF (is_debug_statement_on) THEN
2047: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_contract_transactions , return status: ' || l_return_status);
2048: END IF;
2049:
2050: -- Check the return status
2051: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

2075: -- IF accepted quote with no trn exists for contract then error
2076: -- *****************
2077:
2078: IF (is_debug_statement_on) THEN
2079: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');
2080: END IF;
2081: -- Get accepted quote for contract with no trn
2082: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (
2083: p_khr_id => l_contract_id,

Line 2082: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (

2078: IF (is_debug_statement_on) THEN
2079: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_non_trn_contract_quotes');
2080: END IF;
2081: -- Get accepted quote for contract with no trn
2082: OKL_AM_UTIL_PVT.get_non_trn_contract_quotes (
2083: p_khr_id => l_contract_id,
2084: x_quote_tbl => lx_quote_tbl,
2085: x_return_status => l_return_status);
2086: IF (is_debug_statement_on) THEN

Line 2087: 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);

2083: p_khr_id => l_contract_id,
2084: x_quote_tbl => lx_quote_tbl,
2085: x_return_status => l_return_status);
2086: IF (is_debug_statement_on) THEN
2087: 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);
2088: END IF;
2089:
2090: -- Check the return status
2091: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 2101: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(

2097:
2098: -- Check if accepted quote exists for the contract
2099: IF lx_quote_tbl.COUNT > 0 THEN
2100:
2101: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(
2102: 'OKL_QUOTE_TYPE',
2103: lx_quote_tbl(lx_quote_tbl.FIRST).qtp_code,
2104: 'Y');
2105:

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

2368: RAISE OKL_API.G_EXCEPTION_ERROR;
2369: END IF;
2370:
2371: IF (is_debug_statement_on) THEN
2372: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
2373: END IF;
2374: -- rmunjulu LOANS_ENHACEMENTS Termination with purchase not allowed for loans
2375: -- Get the contract product details
2376: OKL_AM_UTIL_PVT.get_contract_product_details(

Line 2376: OKL_AM_UTIL_PVT.get_contract_product_details(

2372: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
2373: END IF;
2374: -- rmunjulu LOANS_ENHACEMENTS Termination with purchase not allowed for loans
2375: -- Get the contract product details
2376: OKL_AM_UTIL_PVT.get_contract_product_details(
2377: p_khr_id => l_contract_id,
2378: x_deal_type => l_deal_type,
2379: x_rev_rec_method => l_rev_rec_method,
2380: x_int_cal_basis => l_int_cal_basis,

Line 2384: 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);

2380: x_int_cal_basis => l_int_cal_basis,
2381: x_tax_owner => l_tax_owner,
2382: x_return_status => l_return_status);
2383: IF (is_debug_statement_on) THEN
2384: 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);
2385: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_deal_type: ' || l_deal_type);
2386: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rev_rec_method: ' || l_rev_rec_method);
2387: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_int_cal_basis: ' || l_int_cal_basis);
2388: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_tax_owner: ' || l_tax_owner);

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

2413: IF db_partial_yn = 'Y' THEN -- SECHAWLA 04-JAN-06 4915133 : partial quotes not allowed for loan k with
2414: -- rev rec method 'ESTIMATED_AND_BILLED','ACTUAL'
2415: -- Get the contract product details
2416: IF (is_debug_statement_on) THEN
2417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
2418: END IF;
2419: OKL_AM_UTIL_PVT.get_contract_product_details(
2420: p_khr_id => l_contract_id,
2421: x_deal_type => l_deal_type,

Line 2419: OKL_AM_UTIL_PVT.get_contract_product_details(

2415: -- Get the contract product details
2416: IF (is_debug_statement_on) THEN
2417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_contract_product_details');
2418: END IF;
2419: OKL_AM_UTIL_PVT.get_contract_product_details(
2420: p_khr_id => l_contract_id,
2421: x_deal_type => l_deal_type,
2422: x_rev_rec_method => l_rev_rec_method,
2423: x_int_cal_basis => l_int_cal_basis,

Line 2427: 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);

2423: x_int_cal_basis => l_int_cal_basis,
2424: x_tax_owner => l_tax_owner,
2425: x_return_status => l_return_status);
2426: IF (is_debug_statement_on) THEN
2427: 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);
2428: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_deal_type: ' || l_deal_type);
2429: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rev_rec_method: ' || l_rev_rec_method);
2430: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_int_cal_basis: ' || l_int_cal_basis);
2431: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_tax_owner: ' || l_tax_owner);

Line 2485: l_icb_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(

2481: --Bug# 13447258: Partial Line Termination is not allowed for Float and Catchup-Cleanup Loan contracts
2482: IF get_qte_lines_rec.quote_quantity < get_qte_lines_rec.asset_quantity THEN
2483: IF l_int_cal_basis IN ('FLOAT','CATCHUP/CLEANUP') THEN
2484:
2485: l_icb_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(
2486: 'OKL_INTEREST_CALCULATION_BASIS',
2487: l_int_cal_basis,
2488: 'Y');
2489:

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

2507: -- *****************
2508:
2509:
2510: IF (is_debug_statement_on) THEN
2511: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_all_term_quotes_for_line');
2512: END IF;
2513: -- Get quotes for line
2514: OKL_AM_UTIL_PVT.get_all_term_quotes_for_line (
2515: p_kle_id => get_qte_lines_rec.kle_id,

Line 2514: OKL_AM_UTIL_PVT.get_all_term_quotes_for_line (

2510: IF (is_debug_statement_on) THEN
2511: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_all_term_quotes_for_line');
2512: END IF;
2513: -- Get quotes for line
2514: OKL_AM_UTIL_PVT.get_all_term_quotes_for_line (
2515: p_kle_id => get_qte_lines_rec.kle_id,
2516: x_quote_tbl => lx_quote_tbl,
2517: x_return_status => l_return_status);
2518: IF (is_debug_statement_on) THEN

Line 2519: 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);

2515: p_kle_id => get_qte_lines_rec.kle_id,
2516: x_quote_tbl => lx_quote_tbl,
2517: x_return_status => l_return_status);
2518: IF (is_debug_statement_on) THEN
2519: 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);
2520: END IF;
2521:
2522:
2523:

Line 2823: 'calling OKL_AM_UTIL_PVT.get_contract_product_details ');

2819: END IF;
2820:
2821: IF (is_debug_statement_on) THEN
2822: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,
2823: 'calling OKL_AM_UTIL_PVT.get_contract_product_details ');
2824: END IF;
2825:
2826: -- Get the Product Qualities
2827: OKL_AM_UTIL_PVT.get_contract_product_details (

Line 2827: OKL_AM_UTIL_PVT.get_contract_product_details (

2823: 'calling OKL_AM_UTIL_PVT.get_contract_product_details ');
2824: END IF;
2825:
2826: -- Get the Product Qualities
2827: OKL_AM_UTIL_PVT.get_contract_product_details (
2828: p_khr_id => l_contract_id,
2829: x_deal_type => l_deal_type,
2830: x_rev_rec_method => l_rev_rec_method,
2831: x_int_cal_basis => l_int_cal_basis,

Line 2837: 'called OKL_AM_UTIL_PVT.get_contract_product_details ');

2833: x_return_status => l_return_status);
2834:
2835: IF (is_debug_statement_on) THEN
2836: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,
2837: 'called OKL_AM_UTIL_PVT.get_contract_product_details ');
2838:
2839: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,
2840: 'l_return_status: ' || l_return_status);
2841: END IF;

Line 3350: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(

3346: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3347: END IF;
3348:
3349: -- Get the event name
3350: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3351: p_wf_process_type => 'OKLAMPPT',
3352: p_wf_process_name => 'OKL_AM_PRE_PRO_TER',
3353: x_return_status => l_return_status);
3354: IF (is_debug_statement_on) THEN

Line 3379: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(

3375: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3376: END IF;
3377:
3378: -- Get the event name
3379: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3380: p_wf_process_type => 'OKLAMPPT',
3381: p_wf_process_name => 'OKL_AM_POST_PRO_TER',
3382: x_return_status => l_return_status);
3383: IF (is_debug_statement_on) THEN

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

3402: p_token1_value => l_event_name);
3403:
3404:
3405: IF (is_debug_statement_on) THEN
3406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3407: END IF;
3408: -- Save message from stack into transaction message table
3409: OKL_AM_UTIL_PVT.process_messages(
3410: p_trx_source_table => 'OKL_TRX_QUOTES_V',

Line 3409: OKL_AM_UTIL_PVT.process_messages(

3405: IF (is_debug_statement_on) THEN
3406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3407: END IF;
3408: -- Save message from stack into transaction message table
3409: OKL_AM_UTIL_PVT.process_messages(
3410: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3411: p_trx_id => lp_term_rec.id,
3412: x_return_status => l_return_status);
3413: IF (is_debug_statement_on) THEN

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

3410: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3411: p_trx_id => lp_term_rec.id,
3412: x_return_status => l_return_status);
3413: IF (is_debug_statement_on) THEN
3414: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);
3415: END IF;
3416:
3417: -- raise exception if error
3418: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3683: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(

3679: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3680: END IF;
3681:
3682: -- Get the event name
3683: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3684: p_wf_process_type => 'OKLAMPPT',
3685: p_wf_process_name => 'OKL_AM_PRE_PRO_TER',
3686: x_return_status => x_return_status);
3687: IF (is_debug_statement_on) THEN

Line 3723: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(

3719: IF (is_debug_statement_on) THEN
3720: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
3721: END IF;
3722: -- Get the event name
3723: l_event_name := OKL_AM_UTIL_PVT.get_wf_event_name(
3724: p_wf_process_type => 'OKLAMPPT',
3725: p_wf_process_name => 'OKL_AM_POST_PRO_TER',
3726: x_return_status => x_return_status);
3727: IF (is_debug_statement_on) THEN

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

3746:
3747: END IF;
3748:
3749: IF (is_debug_statement_on) THEN
3750: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3751: END IF;
3752: -- Save message from stack into transaction message table
3753: OKL_AM_UTIL_PVT.process_messages(
3754: p_trx_source_table => 'OKL_TRX_QUOTES_V',

Line 3753: OKL_AM_UTIL_PVT.process_messages(

3749: IF (is_debug_statement_on) THEN
3750: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3751: END IF;
3752: -- Save message from stack into transaction message table
3753: OKL_AM_UTIL_PVT.process_messages(
3754: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3755: p_trx_id => p_term_tbl(i).id,
3756: x_return_status => x_return_status);
3757: IF (is_debug_statement_on) THEN

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

3754: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3755: p_trx_id => p_term_tbl(i).id,
3756: x_return_status => x_return_status);
3757: IF (is_debug_statement_on) THEN
3758: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || x_return_status);
3759: END IF;
3760:
3761: -- raise exception if error
3762: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

4000: p_transaction_id => p_term_rec.id,
4001: p_event_name => 'oracle.apps.okl.am.submitquoteforapproval');
4002: IF (is_debug_statement_on) THEN
4003: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
4004: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
4005: END IF;
4006: -- Save messages in database
4007: OKL_AM_UTIL_PVT.process_messages (
4008: p_trx_source_table => 'OKL_TRX_QUOTES_V',

Line 4007: OKL_AM_UTIL_PVT.process_messages (

4003: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_WF.raise_business_event');
4004: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
4005: END IF;
4006: -- Save messages in database
4007: OKL_AM_UTIL_PVT.process_messages (
4008: p_trx_source_table => 'OKL_TRX_QUOTES_V',
4009: p_trx_id => p_term_rec.id,
4010: x_return_status => l_return_status);
4011: IF (is_debug_statement_on) THEN

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

4008: p_trx_source_table => 'OKL_TRX_QUOTES_V',
4009: p_trx_id => p_term_rec.id,
4010: x_return_status => l_return_status);
4011: IF (is_debug_statement_on) THEN
4012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);
4013: END IF;
4014:
4015: END IF;
4016: -- ELSE

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

4950: OKL_API.set_message(
4951: p_app_name => OKL_API.G_APP_NAME,
4952: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
4953: p_token1 => 'PROMPT',
4954: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_TYPE'));
4955:
4956: RAISE OKL_API.G_EXCEPTION_ERROR;
4957:
4958: END IF;

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

4965: OKL_API.set_message(
4966: p_app_name => OKL_API.G_APP_NAME,
4967: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
4968: p_token1 => 'PROMPT',
4969: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_AMOUNT'));
4970:
4971: RAISE OKL_API.G_EXCEPTION_ERROR;
4972:
4973: END IF;

Line 5108: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;

5104: END IF;
5105:
5106: -- Get the functional currency from AM_Util
5107: -- RMUNJULU 30-DEC-02 2699412 changed to call right function
5108: l_functional_currency_code := OKL_AM_UTIL_PVT.get_functional_currency;
5109:
5110:
5111: -- Get the contract id for the quote line
5112: -- RMUNJULU 31-JAN-03 2780539 Changed to send the qte_id to cursor