DBA Data[Home] [Help]

APPS.OKL_AM_INVOICES_PVT dependencies on OKL_AM_UTIL_PVT

Line 288: l_party_name := okl_am_util_pvt.get_jtf_object_name (

284: p_token1_value => 'Contract Party Id');
285: /* -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
286: ELSIF l_rgd_id IS NULL THEN
287: l_return_status := OKL_API.G_RET_STS_ERROR;
288: l_party_name := okl_am_util_pvt.get_jtf_object_name (
289: l_k_party_rg_rec.object1_code,
290: l_k_party_rg_rec.object1_id1,
291: l_k_party_rg_rec.object1_id2);
292: OKC_API.SET_MESSAGE (

Line 301: l_party_name := okl_am_util_pvt.get_jtf_object_name (

297: */
298: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
299: ELSIF l_k_party_rg_rec.bill_to_site_use_id IS NULL THEN
300: l_return_status := OKL_API.G_RET_STS_ERROR;
301: l_party_name := okl_am_util_pvt.get_jtf_object_name (
302: l_k_party_rg_rec.object1_code,
303: l_k_party_rg_rec.object1_id1,
304: l_k_party_rg_rec.object1_id2);
305: -- Billing information is not found for party PARTY having role PARTY_ROLE.

Line 332: okl_am_util_pvt.set_message(

328: p_token1 => G_COL_NAME_TOKEN,
329: p_token1_value => 'Contract Id');
330: ELSIF l_par_id IS NULL THEN
331: l_return_status := OKL_API.G_RET_STS_ERROR;
332: okl_am_util_pvt.set_message(
333: p_app_name => G_APP_NAME
334: -- PAGARG Bug 3559535 Use proper message for no vendor program found
335: ,p_msg_name => 'OKL_AM_NO_VENDOR_PROG');
336:

Line 340: l_party_name := okl_am_util_pvt.get_program_partner (l_khr_id);

336:
337: /* -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
338: ELSIF l_rgd_id IS NULL THEN
339: l_return_status := OKL_API.G_RET_STS_ERROR;
340: l_party_name := okl_am_util_pvt.get_program_partner (l_khr_id);
341: OKC_API.SET_MESSAGE (
342: p_app_name => G_APP_NAME,
343: p_msg_name => 'OKL_AM_NO_BILLING_INFO',
344: p_token1 => 'PARTY',

Line 351: l_party_name := okl_am_util_pvt.get_program_partner (l_khr_id);

347:
348: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
349: ELSIF l_bill_to_site_use_id IS NULL THEN
350: l_return_status := OKL_API.G_RET_STS_ERROR;
351: l_party_name := okl_am_util_pvt.get_program_partner (l_khr_id);
352: IF (is_debug_statement_on) THEN
353: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_program_partner and got l_party_name : ' || l_party_name);
354: END IF;
355: -- Billing information is not found for party PARTY having role PARTY_ROLE.

Line 353: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_program_partner and got l_party_name : ' || l_party_name);

349: ELSIF l_bill_to_site_use_id IS NULL THEN
350: l_return_status := OKL_API.G_RET_STS_ERROR;
351: l_party_name := okl_am_util_pvt.get_program_partner (l_khr_id);
352: IF (is_debug_statement_on) THEN
353: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_program_partner and got l_party_name : ' || l_party_name);
354: END IF;
355: -- Billing information is not found for party PARTY having role PARTY_ROLE.
356: OKC_API.SET_MESSAGE (
357: p_app_name => G_APP_NAME,

Line 386: okl_am_util_pvt.get_rule_record (

382:
383: IF l_overall_status = OKL_API.G_RET_STS_SUCCESS THEN
384:
385:
386: okl_am_util_pvt.get_rule_record (
387: p_rgd_id => l_rgd_id,
388: p_rgd_code => 'LAVENB',
389: p_rdf_code => 'BTO',
390: p_chr_id => l_contract_id,

Line 408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

404: */
405:
406: IF l_overall_status = OKL_API.G_RET_STS_SUCCESS THEN
407: IF (is_debug_statement_on) THEN
408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
409: END IF;
410:
411: okl_am_util_pvt.get_rule_record (
412: p_rgd_id => l_rgd_id,

Line 411: okl_am_util_pvt.get_rule_record (

407: IF (is_debug_statement_on) THEN
408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
409: END IF;
410:
411: okl_am_util_pvt.get_rule_record (
412: p_rgd_id => l_rgd_id,
413: p_rgd_code => 'LAVENB',
414: p_rdf_code => 'LAPMTH',
415: p_chr_id => l_contract_id,

Line 421: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

417: p_message_yn => FALSE, -- Rule is optional - bug 2533080
418: x_rulv_rec => l_mth_rulv_rec,
419: x_return_status => l_return_status);
420: IF (is_debug_statement_on) THEN
421: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
422: END IF;
423:
424: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
425: -- ADDED SINCE 2533080 not fixed properly

Line 736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');

732: -- Validate parameters
733: -- *******************
734:
735: IF (is_debug_statement_on) THEN
736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
737: END IF;
738: okl_am_util_pvt.get_transaction_id (
739: p_try_name => G_AR_INV_TRX_TYPE,
740: x_return_status => l_return_status,

Line 738: okl_am_util_pvt.get_transaction_id (

734:
735: IF (is_debug_statement_on) THEN
736: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
737: END IF;
738: okl_am_util_pvt.get_transaction_id (
739: p_try_name => G_AR_INV_TRX_TYPE,
740: x_return_status => l_return_status,
741: x_try_id => l_pos_try_id);
742: IF (is_debug_statement_on) THEN

Line 743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);

739: p_try_name => G_AR_INV_TRX_TYPE,
740: x_return_status => l_return_status,
741: x_try_id => l_pos_try_id);
742: IF (is_debug_statement_on) THEN
743: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);
744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_pos_try_id : ' || l_pos_try_id);
745: END IF;
746:
747: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS

Line 758: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');

754: P_TOKEN1_VALUE => 'TRANSACTION TYPE');
755: END IF;
756:
757: IF (is_debug_statement_on) THEN
758: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
759: END IF;
760: okl_am_util_pvt.get_transaction_id (
761: p_try_name => G_AR_CM_TRX_TYPE,
762: x_return_status => l_return_status,

Line 760: okl_am_util_pvt.get_transaction_id (

756:
757: IF (is_debug_statement_on) THEN
758: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
759: END IF;
760: okl_am_util_pvt.get_transaction_id (
761: p_try_name => G_AR_CM_TRX_TYPE,
762: x_return_status => l_return_status,
763: x_try_id => l_neg_try_id);
764: IF (is_debug_statement_on) THEN

Line 765: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);

761: p_try_name => G_AR_CM_TRX_TYPE,
762: x_return_status => l_return_status,
763: x_try_id => l_neg_try_id);
764: IF (is_debug_statement_on) THEN
765: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);
766: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_neg_try_id : ' || l_neg_try_id);
767: END IF;
768:
769: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS

Line 787: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');

783: --id inside appropriate condition
784: IF p_quote_type LIKE 'TER_ROLL%'
785: AND p_trans_type = 'REVERSE' THEN
786: IF (is_debug_statement_on) THEN
787: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
788: END IF;
789: okl_am_util_pvt.get_transaction_id (
790: p_try_name => 'ROLLOVER BILLING',
791: x_return_status => l_return_status,

Line 789: okl_am_util_pvt.get_transaction_id (

785: AND p_trans_type = 'REVERSE' THEN
786: IF (is_debug_statement_on) THEN
787: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
788: END IF;
789: okl_am_util_pvt.get_transaction_id (
790: p_try_name => 'ROLLOVER BILLING',
791: x_return_status => l_return_status,
792: x_try_id => l_roll_bill_try_id);
793: IF (is_debug_statement_on) THEN

Line 794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);

790: p_try_name => 'ROLLOVER BILLING',
791: x_return_status => l_return_status,
792: x_try_id => l_roll_bill_try_id);
793: IF (is_debug_statement_on) THEN
794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);
795: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_roll_bill_try_id : ' || l_roll_bill_try_id);
796: END IF;
797:
798: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS

Line 809: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');

805: p_token1_value => 'Transaction Type');
806: END IF;
807:
808: IF (is_debug_statement_on) THEN
809: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
810: END IF;
811: okl_am_util_pvt.get_transaction_id (
812: p_try_name => 'ROLLOVER CREDIT MEMO',
813: x_return_status => l_return_status,

Line 811: okl_am_util_pvt.get_transaction_id (

807:
808: IF (is_debug_statement_on) THEN
809: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
810: END IF;
811: okl_am_util_pvt.get_transaction_id (
812: p_try_name => 'ROLLOVER CREDIT MEMO',
813: x_return_status => l_return_status,
814: x_try_id => l_roll_cm_try_id);
815: IF (is_debug_statement_on) THEN

Line 816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);

812: p_try_name => 'ROLLOVER CREDIT MEMO',
813: x_return_status => l_return_status,
814: x_try_id => l_roll_cm_try_id);
815: IF (is_debug_statement_on) THEN
816: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);
817: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_roll_cm_try_id : ' || l_roll_cm_try_id);
818: END IF;
819:
820: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS

Line 839: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');

835: --id inside appropriate condition
836: IF p_quote_type = 'TER_RELEASE_WO_PURCHASE'
837: AND p_trans_type = 'REVERSE' THEN
838: IF (is_debug_statement_on) THEN
839: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
840: END IF;
841: okl_am_util_pvt.get_transaction_id (
842: p_try_name => 'RELEASE BILLING',
843: x_return_status => l_return_status,

Line 841: okl_am_util_pvt.get_transaction_id (

837: AND p_trans_type = 'REVERSE' THEN
838: IF (is_debug_statement_on) THEN
839: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
840: END IF;
841: okl_am_util_pvt.get_transaction_id (
842: p_try_name => 'RELEASE BILLING',
843: x_return_status => l_return_status,
844: x_try_id => l_release_bill_try_id);
845: IF (is_debug_statement_on) THEN

Line 846: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);

842: p_try_name => 'RELEASE BILLING',
843: x_return_status => l_return_status,
844: x_try_id => l_release_bill_try_id);
845: IF (is_debug_statement_on) THEN
846: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);
847: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_release_bill_try_id : ' || l_release_bill_try_id);
848: END IF;
849:
850: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value

Line 861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');

857: p_token1 => G_COL_NAME_TOKEN,
858: p_token1_value => 'Transaction Type');
859: END IF;
860: IF (is_debug_statement_on) THEN
861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
862: END IF;
863:
864: okl_am_util_pvt.get_transaction_id (
865: p_try_name => 'RELEASE CREDIT MEMO',

Line 864: okl_am_util_pvt.get_transaction_id (

860: IF (is_debug_statement_on) THEN
861: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_transaction_id');
862: END IF;
863:
864: okl_am_util_pvt.get_transaction_id (
865: p_try_name => 'RELEASE CREDIT MEMO',
866: x_return_status => l_return_status,
867: x_try_id => l_release_cm_try_id);
868: IF (is_debug_statement_on) THEN

Line 869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);

865: p_try_name => 'RELEASE CREDIT MEMO',
866: x_return_status => l_return_status,
867: x_try_id => l_release_cm_try_id);
868: IF (is_debug_statement_on) THEN
869: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_transaction_id , return status: ' || l_return_status);
870: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_release_cm_try_id : ' || l_release_cm_try_id);
871: END IF;
872:
873: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value

Line 1217: okl_am_util_pvt.get_transaction_id (

1213: -- *******************
1214: -- Validate parameters
1215: -- *******************
1216:
1217: okl_am_util_pvt.get_transaction_id (
1218: p_try_name => G_AR_INV_TRX_TYPE,
1219: x_return_status => l_return_status,
1220: x_try_id => l_pos_try_id);
1221:

Line 1232: okl_am_util_pvt.get_transaction_id (

1228: p_token1 => G_COL_NAME_TOKEN,
1229: p_token1_value => 'Transaction Type');
1230: END IF;
1231:
1232: okl_am_util_pvt.get_transaction_id (
1233: p_try_name => G_AR_CM_TRX_TYPE,
1234: x_return_status => l_return_status,
1235: x_try_id => l_neg_try_id);
1236:

Line 1255: okl_am_util_pvt.get_transaction_id (

1251: --09-Nov-04 PAGARG Bug #4002033 moved the logic to obtain transaction type
1252: --id inside appropriate condition
1253: IF p_quote_type LIKE 'TER_ROLL%'
1254: AND p_trans_type = 'REVERSE' THEN
1255: okl_am_util_pvt.get_transaction_id (
1256: p_try_name => 'ROLLOVER BILLING',
1257: x_return_status => l_return_status,
1258: x_try_id => l_roll_bill_try_id);
1259:

Line 1270: okl_am_util_pvt.get_transaction_id (

1266: p_token1 => G_COL_NAME_TOKEN,
1267: p_token1_value => 'Transaction Type');
1268: END IF;
1269:
1270: okl_am_util_pvt.get_transaction_id (
1271: p_try_name => 'ROLLOVER CREDIT MEMO',
1272: x_return_status => l_return_status,
1273: x_try_id => l_roll_cm_try_id);
1274:

Line 1295: okl_am_util_pvt.get_transaction_id (

1291: --09-Nov-04 PAGARG Bug #4002033 moved the logic to obtain transaction type
1292: --id inside appropriate condition
1293: IF p_quote_type = 'TER_RELEASE_WO_PURCHASE'
1294: AND p_trans_type = 'REVERSE' THEN
1295: okl_am_util_pvt.get_transaction_id (
1296: p_try_name => 'RELEASE BILLING',
1297: x_return_status => l_return_status,
1298: x_try_id => l_release_bill_try_id);
1299:

Line 1311: okl_am_util_pvt.get_transaction_id (

1307: p_token1 => G_COL_NAME_TOKEN,
1308: p_token1_value => 'Transaction Type');
1309: END IF;
1310:
1311: okl_am_util_pvt.get_transaction_id (
1312: p_try_name => 'RELEASE CREDIT MEMO',
1313: x_return_status => l_return_status,
1314: x_try_id => l_release_cm_try_id);
1315:

Line 1847: okl_am_util_pvt.get_stream_type_id (

1843: -- ***************
1844: -- Get stream type
1845: -- ***************
1846: /* bug 4631541
1847: okl_am_util_pvt.get_stream_type_id (
1848: p_sty_code => G_REPAIR_STREAM,
1849: x_return_status => l_stream_status,
1850: x_sty_id => l_sty_id);
1851: */

Line 1973: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_ACTUAL_REPAIR_COST'));

1969: OKL_API.set_message (
1970: p_app_name => G_APP_NAME,
1971: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
1972: p_token1 => 'PROMPT',
1973: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_ACTUAL_REPAIR_COST'));
1974:
1975: END IF;
1976:
1977: x_pos_amount := l_pos_amount;

Line 2566: okl_am_util_pvt.set_message (

2562: l_return_status := OKL_API.G_RET_STS_ERROR;
2563:
2564: /* -- rmunjulu bug 4056364 No need to set this message
2565: -- Stream Purpose is not setup
2566: okl_am_util_pvt.set_message (
2567: p_app_name => G_APP_NAME
2568: ,p_msg_name => 'OKL_AM_NO_STREAM_TO_QUOTE'
2569: ,p_token1 => 'QLT_CODE'
2570: ,p_token1_value => G_REMARKET_QUOTE_LINE);

Line 3008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

3004: -- Get Security Deposit Rule
3005: -- *************************
3006:
3007: IF (is_debug_statement_on) THEN
3008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
3009: END IF;
3010: okl_am_util_pvt.get_rule_record (
3011: p_rgd_code => 'LASDEP',
3012: p_rdf_code => 'LASDEP',

Line 3010: okl_am_util_pvt.get_rule_record (

3006:
3007: IF (is_debug_statement_on) THEN
3008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
3009: END IF;
3010: okl_am_util_pvt.get_rule_record (
3011: p_rgd_code => 'LASDEP',
3012: p_rdf_code => 'LASDEP',
3013: p_chr_id => p_contract_id,
3014: p_cle_id => NULL,

Line 3019: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);

3015: x_rulv_rec => l_rulv_rec,
3016: x_return_status => l_return_status,
3017: p_message_yn => FALSE);
3018: IF (is_debug_statement_on) THEN
3019: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
3020: END IF;
3021:
3022: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
3023:

Line 3319: l_description := okl_am_util_pvt.get_lookup_meaning

3315: -- ******************
3316: -- Create Credit Memo
3317: -- ******************
3318:
3319: l_description := okl_am_util_pvt.get_lookup_meaning
3320: ('OKL_QUOTE_LINE_TYPE','AMCSDD');
3321:
3322: FOR i IN l_sdd_tbl.FIRST..l_sdd_tbl.LAST LOOP
3323:

Line 4042: okl_am_util_pvt.set_message (

4038: l_stream_status := OKL_API.G_RET_STS_ERROR;
4039:
4040: /* -- rmunjulu Bug 4056364 Do not set this message, message will be set by OKL_STREAMS_UTIL
4041: -- Stream Type is not setup in Quote Line Allocation Screen for QLT_CODE
4042: okl_am_util_pvt.set_message (
4043: p_app_name => G_APP_NAME
4044: ,p_msg_name => 'OKL_AM_NO_STREAM_TO_QUOTE'
4045: ,p_token1 => 'QLT_CODE'
4046: ,p_token1_value => l_qlt_rec.qlt_code);

Line 4299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_excess_loan_payment');

4295: -- create credit memos for loans refund only on full termination
4296: IF nvl(l_partial_yn,'N') = 'N' THEN
4297:
4298: IF (is_debug_statement_on) THEN
4299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_excess_loan_payment');
4300: END IF;
4301: l_loan_refund_amount := OKL_AM_UTIL_PVT.get_excess_loan_payment(
4302: x_return_status => l_return_status,
4303: p_khr_id => l_khr_id);

Line 4301: l_loan_refund_amount := OKL_AM_UTIL_PVT.get_excess_loan_payment(

4297:
4298: IF (is_debug_statement_on) THEN
4299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.get_excess_loan_payment');
4300: END IF;
4301: l_loan_refund_amount := OKL_AM_UTIL_PVT.get_excess_loan_payment(
4302: x_return_status => l_return_status,
4303: p_khr_id => l_khr_id);
4304: IF (is_debug_statement_on) THEN
4305: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_excess_loan_payment , return status: ' || l_return_status);

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

4301: l_loan_refund_amount := OKL_AM_UTIL_PVT.get_excess_loan_payment(
4302: x_return_status => l_return_status,
4303: p_khr_id => l_khr_id);
4304: IF (is_debug_statement_on) THEN
4305: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.get_excess_loan_payment , return status: ' || l_return_status);
4306: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_loan_refund_amount: ' || l_loan_refund_amount);
4307: END IF;
4308:
4309: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 4459: OKL_AM_UTIL_PVT.process_messages(

4455: --amount remaining for the contract' in termination quote messages screen as per the update
4456: --by PM *** MCORNEL 01/09/08 11:07 am *** in the bug#6508911 .
4457: -- This message is already set in Create_Scrt_Dpst_Dsps_Inv.
4458:
4459: OKL_AM_UTIL_PVT.process_messages(
4460: p_trx_source_table => 'OKL_TRX_QUOTES_V',
4461: p_trx_id => p_quote_id,
4462: x_return_status => l_return_status
4463: );