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_LEASE_LOAN_TRMNT_PVT dependencies on OKC_API

Line 321: p_app_name => OKC_API.G_APP_NAME,

317: || sqlcode || ' , SQLERRM : ' || sqlerrm);
318: END IF;
319:
320: OKL_API.set_message(
321: p_app_name => OKC_API.G_APP_NAME,
322: p_msg_name => G_UNEXPECTED_ERROR,
323: p_token1 => G_SQLCODE_TOKEN,
324: p_token1_value => SQLCODE,
325: p_token2 => G_SQLERRM_TOKEN,

Line 385: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

381: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
382: || sqlcode || ' , SQLERRM : ' || sqlerrm);
383: END IF;
384: -- Set the oracle error message
385: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
386: p_msg_name => g_unexpected_error,
387: p_token1 => g_sqlcode_token,
388: p_token1_value => SQLCODE,
389: p_token2 => g_sqlerrm_token,

Line 514: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

510: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
511: || sqlcode || ' , SQLERRM : ' || sqlerrm);
512: END IF;
513: -- Set the oracle error message
514: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
515: p_msg_name => g_unexpected_error,
516: p_token1 => g_sqlcode_token,
517: p_token1_value => SQLCODE,
518: p_token2 => g_sqlerrm_token,

Line 654: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

650: END IF;
651: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
652: p_api_name => l_api_name,
653: p_pkg_name => G_PKG_NAME,
654: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
655: x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data,
657: p_api_type => G_API_TYPE);
658:

Line 666: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

662: END IF;
663: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
664: p_api_name => l_api_name,
665: p_pkg_name => G_PKG_NAME,
666: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
667: x_msg_count => x_msg_count,
668: x_msg_data => x_msg_data,
669: p_api_type => G_API_TYPE);
670:

Line 806: p_app_name => OKC_API.G_APP_NAME,

802: || sqlcode || ' , SQLERRM : ' || sqlerrm);
803: END IF;
804:
805: OKL_API.set_message(
806: p_app_name => OKC_API.G_APP_NAME,
807: p_msg_name => G_UNEXPECTED_ERROR,
808: p_token1 => G_SQLCODE_TOKEN,
809: p_token1_value => SQLCODE,
810: p_token2 => G_SQLERRM_TOKEN,

Line 922: p_app_name => OKC_API.G_APP_NAME,

918: || sqlcode || ' , SQLERRM : ' || sqlerrm);
919: END IF;
920:
921: OKL_API.set_message(
922: p_app_name => OKC_API.G_APP_NAME,
923: p_msg_name => G_UNEXPECTED_ERROR,
924: p_token1 => G_SQLCODE_TOKEN,
925: p_token1_value => SQLCODE,
926: p_token2 => G_SQLERRM_TOKEN,

Line 1102: p_app_name => OKC_API.G_APP_NAME,

1098: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1099: END IF;
1100:
1101: OKL_API.set_message(
1102: p_app_name => OKC_API.G_APP_NAME,
1103: p_msg_name => G_UNEXPECTED_ERROR,
1104: p_token1 => G_SQLCODE_TOKEN,
1105: p_token1_value => SQLCODE,
1106: p_token2 => G_SQLERRM_TOKEN,

Line 1389: p_app_name => OKC_API.G_APP_NAME,

1385: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1386: END IF;
1387:
1388: OKL_API.set_message(
1389: p_app_name => OKC_API.G_APP_NAME,
1390: p_msg_name => G_UNEXPECTED_ERROR,
1391: p_token1 => G_SQLCODE_TOKEN,
1392: p_token1_value => SQLCODE,
1393: p_token2 => G_SQLERRM_TOKEN,

Line 1627: p_app_name => OKC_API.G_APP_NAME,

1623: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1624: END IF;
1625:
1626: OKL_API.set_message(
1627: p_app_name => OKC_API.G_APP_NAME,
1628: p_msg_name => G_UNEXPECTED_ERROR,
1629: p_token1 => G_SQLCODE_TOKEN,
1630: p_token1_value => SQLCODE,
1631: p_token2 => G_SQLERRM_TOKEN,

Line 1742: p_app_name => OKC_API.G_APP_NAME,

1738: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1739: END IF;
1740:
1741: OKL_API.set_message(
1742: p_app_name => OKC_API.G_APP_NAME,
1743: p_msg_name => G_UNEXPECTED_ERROR,
1744: p_token1 => G_SQLCODE_TOKEN,
1745: p_token1_value => SQLCODE,
1746: p_token2 => G_SQLERRM_TOKEN,

Line 1908: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,

1904:
1905: -- Check contract id passed is valid
1906: IF k_header_rec.id IS NULL OR k_header_rec.contract_number IS NULL THEN
1907:
1908: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1909: p_msg_name => OKC_API.G_INVALID_VALUE,
1910: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1911: p_token1_value => 'contract id');
1912:

Line 1909: p_msg_name => OKC_API.G_INVALID_VALUE,

1905: -- Check contract id passed is valid
1906: IF k_header_rec.id IS NULL OR k_header_rec.contract_number IS NULL THEN
1907:
1908: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1909: p_msg_name => OKC_API.G_INVALID_VALUE,
1910: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1911: p_token1_value => 'contract id');
1912:
1913: RAISE l_invalid_contract;

Line 1910: p_token1 => OKC_API.G_COL_NAME_TOKEN,

1906: IF k_header_rec.id IS NULL OR k_header_rec.contract_number IS NULL THEN
1907:
1908: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1909: p_msg_name => OKC_API.G_INVALID_VALUE,
1910: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1911: p_token1_value => 'contract id');
1912:
1913: RAISE l_invalid_contract;
1914: END IF;

Line 1967: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

1963:
1964: -- Check if template
1965: IF k_header_rec.template_yn = OKL_API.G_TRUE THEN
1966: -- Message: This operation is not allowed on contract template-(NUMBER).
1967: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1968: p_msg_name => 'OKC_K_TEMPLATE',
1969: p_token1 => 'NUMBER',
1970: p_token1_value => k_header_rec.contract_number);
1971: RAISE l_invalid_contract;

Line 1978: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

1974: -- Check if locked
1975: IF l_chg_request_in_process = 'x' THEN
1976: -- Message: You cannot modify this contract now because a
1977: -- change request is active. Please try later.
1978: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1979: p_msg_name => 'OKC_K_LOCKED');
1980: RAISE l_invalid_contract;
1981: END IF;
1982:

Line 1987: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

1983: -- Check if service requests found
1984: IF l_service_request = 'x' THEN
1985: -- Message: You cannot terminate this contract/line because a service
1986: --request is pending against this contract/line. Please try again later.
1987: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1988: p_msg_name => 'OKC_SR_PENDING');
1989: RAISE l_invalid_contract;
1990: END IF;
1991:

Line 2286: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

2282:
2283: -- Check if template
2284: IF k_header_rec.template_yn = OKL_API.G_TRUE THEN
2285: -- Message: This operation is not allowed on contract template-(NUMBER).
2286: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2287: p_msg_name => 'OKC_K_TEMPLATE',
2288: p_token1 => 'NUMBER',
2289: p_token1_value => k_header_rec.contract_number);
2290: RAISE l_invalid_contract;

Line 2298: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

2294: -- Check if locked
2295: IF l_chg_request_in_process = 'x' THEN
2296: -- Message: You cannot modify this contract now because a
2297: -- change request is active. Please try later.
2298: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2299: p_msg_name => 'OKC_K_LOCKED');
2300: RAISE l_invalid_contract;
2301: END IF;
2302:

Line 2307: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

2303: --Check if service requests found
2304: IF l_service_request = 'x' THEN
2305: -- Message: You cannot terminate this contract/line because a service
2306: --request is pending against this contract/line. Please try again later.
2307: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2308: p_msg_name => 'OKC_SR_PENDING');
2309: RAISE l_invalid_contract;
2310: END IF;
2311: */

Line 2324: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

2320:
2321: -- Check if template
2322: IF k_header_rec.template_yn = OKL_API.G_TRUE THEN
2323: -- Message: This operation is not allowed on contract template-(NUMBER).
2324: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2325: p_msg_name => 'OKC_K_TEMPLATE',
2326: p_token1 => 'NUMBER',
2327: p_token1_value => k_header_rec.contract_number);
2328: RAISE l_invalid_contract;

Line 2336: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

2332: -- Check if locked
2333: IF l_chg_request_in_process = 'x' THEN
2334: -- Message: You cannot modify this contract now because a
2335: -- change request is active. Please try later.
2336: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2337: p_msg_name => 'OKC_K_LOCKED');
2338: RAISE l_invalid_contract;
2339: END IF;
2340:

Line 2345: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

2341: --Check if service requests found
2342: IF l_service_request = 'x' THEN
2343: -- Message: You cannot terminate this contract/line because a service
2344: --request is pending against this contract/line. Please try again later.
2345: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2346: p_msg_name => 'OKC_SR_PENDING');
2347: RAISE l_invalid_contract;
2348: END IF;
2349: */

Line 2497: p_app_name => OKC_API.G_APP_NAME

2493: END IF;
2494:
2495: -- store SQL error message on message stack for caller
2496: OKL_API.SET_MESSAGE (
2497: p_app_name => OKC_API.G_APP_NAME
2498: ,p_msg_name => G_UNEXPECTED_ERROR
2499: ,p_token1 => G_SQLCODE_TOKEN
2500: ,p_token1_value => sqlcode
2501: ,p_token2 => G_SQLERRM_TOKEN

Line 2570: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,

2566:
2567: OPEN k_header_csr;
2568: FETCH k_header_csr INTO k_header_rec;
2569: IF k_header_csr%NOTFOUND THEN
2570: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2571: p_msg_name => 'OKC_K_CHANGED',
2572: p_token1 => 'NUMBER',
2573: p_token1_value => p_term_rec.p_contract_number,
2574: p_token2 => 'MODIFIER',

Line 2640: OKL_API.set_message(p_app_name => okc_api.g_app_name,

2636: IF k_deal_type_csr%ISOPEN THEN
2637: CLOSE k_deal_type_csr;
2638: END IF;
2639: x_lease_loan_type := '$';
2640: OKL_API.set_message(p_app_name => okc_api.g_app_name,
2641: p_msg_name => g_unexpected_error,
2642: p_token1 => g_sqlcode_token,
2643: p_token1_value => sqlcode,
2644: p_token2 => g_sqlerrm_token,

Line 3179: OKL_API.set_message(p_app_name => okc_api.g_app_name,

3175: CLOSE l_qte_csr;
3176: END IF;
3177:
3178:
3179: OKL_API.set_message(p_app_name => okc_api.g_app_name,
3180: p_msg_name => g_unexpected_error,
3181: p_token1 => g_sqlcode_token,
3182: p_token1_value => sqlcode,
3183: p_token2 => g_sqlerrm_token,

Line 3407: p_app_name => OKC_API.G_APP_NAME,

3403: x_return_status := OKL_API.g_ret_sts_error;
3404:
3405: -- Set the oracle error message
3406: OKL_API.set_message(
3407: p_app_name => OKC_API.G_APP_NAME,
3408: p_msg_name => g_unexpected_error,
3409: p_token1 => g_sqlcode_token,
3410: p_token1_value => SQLCODE,
3411: p_token2 => g_sqlerrm_token,

Line 4080: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',

4076: FETCH c_app_info INTO l_app_id;
4077: IF(c_app_info%NOTFOUND)
4078: THEN
4079: -- Change Message
4080: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4081: G_COL_NAME_TOKEN,'Billing');
4082: x_return_status := OKC_API.G_RET_STS_ERROR ;
4083: CLOSE c_app_info ;
4084: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4082: x_return_status := OKC_API.G_RET_STS_ERROR ;

4078: THEN
4079: -- Change Message
4080: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4081: G_COL_NAME_TOKEN,'Billing');
4082: x_return_status := OKC_API.G_RET_STS_ERROR ;
4083: CLOSE c_app_info ;
4084: RAISE OKC_API.G_EXCEPTION_ERROR;
4085: END if ;
4086: CLOSE c_app_info;

Line 4084: RAISE OKC_API.G_EXCEPTION_ERROR;

4080: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4081: G_COL_NAME_TOKEN,'Billing');
4082: x_return_status := OKC_API.G_RET_STS_ERROR ;
4083: CLOSE c_app_info ;
4084: RAISE OKC_API.G_EXCEPTION_ERROR;
4085: END if ;
4086: CLOSE c_app_info;
4087:
4088: -- get Vendor site Id

Line 4093: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');

4089: OPEN c_vendor_info (l_sub_rec.subsidy_line_id);
4090: FETCH c_vendor_info INTO l_tapv_rec.vendor_id, l_tapv_rec.IPVS_ID;
4091: IF(c_vendor_info%NOTFOUND) THEN
4092: -- Change Message
4093: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4094: x_return_status := OKC_API.G_RET_STS_ERROR ;
4095: CLOSE c_vendor_info ;
4096: RAISE OKC_API.G_EXCEPTION_ERROR;
4097: END if ;

Line 4094: x_return_status := OKC_API.G_RET_STS_ERROR ;

4090: FETCH c_vendor_info INTO l_tapv_rec.vendor_id, l_tapv_rec.IPVS_ID;
4091: IF(c_vendor_info%NOTFOUND) THEN
4092: -- Change Message
4093: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4094: x_return_status := OKC_API.G_RET_STS_ERROR ;
4095: CLOSE c_vendor_info ;
4096: RAISE OKC_API.G_EXCEPTION_ERROR;
4097: END if ;
4098: CLOSE c_vendor_info;

Line 4096: RAISE OKC_API.G_EXCEPTION_ERROR;

4092: -- Change Message
4093: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4094: x_return_status := OKC_API.G_RET_STS_ERROR ;
4095: CLOSE c_vendor_info ;
4096: RAISE OKC_API.G_EXCEPTION_ERROR;
4097: END if ;
4098: CLOSE c_vendor_info;
4099:
4100: l_tapv_rec.sfwt_flag := 'N' ;

Line 4114: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',

4110: OPEN c_trx_type ('Disbursement', 'US');
4111: FETCH c_trx_type INTO l_trx_type_ID;
4112: IF(c_trx_type%NOTFOUND)
4113: THEN
4114: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4115: G_COL_NAME_TOKEN,'Disbursement');
4116: x_return_status := OKC_API.G_RET_STS_ERROR ;
4117: CLOSE c_trx_type ;
4118: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4116: x_return_status := OKC_API.G_RET_STS_ERROR ;

4112: IF(c_trx_type%NOTFOUND)
4113: THEN
4114: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4115: G_COL_NAME_TOKEN,'Disbursement');
4116: x_return_status := OKC_API.G_RET_STS_ERROR ;
4117: CLOSE c_trx_type ;
4118: RAISE OKC_API.G_EXCEPTION_ERROR;
4119: END if ;
4120: CLOSE c_trx_type ;

Line 4118: RAISE OKC_API.G_EXCEPTION_ERROR;

4114: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4115: G_COL_NAME_TOKEN,'Disbursement');
4116: x_return_status := OKC_API.G_RET_STS_ERROR ;
4117: CLOSE c_trx_type ;
4118: RAISE OKC_API.G_EXCEPTION_ERROR;
4119: END if ;
4120: CLOSE c_trx_type ;
4121: l_tapv_rec.TRY_ID := l_trx_type_ID;
4122: l_tapv_rec.AMOUNT := lx_subsidy_amount;

Line 4577: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',

4573: OPEN c_app_info ;
4574: FETCH c_app_info INTO l_app_id;
4575: IF(c_app_info%NOTFOUND) THEN
4576: -- Change Message
4577: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4578: G_COL_NAME_TOKEN,'Billing');
4579: x_return_status := OKC_API.G_RET_STS_ERROR ;
4580: CLOSE c_app_info ;
4581: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4579: x_return_status := OKC_API.G_RET_STS_ERROR ;

4575: IF(c_app_info%NOTFOUND) THEN
4576: -- Change Message
4577: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4578: G_COL_NAME_TOKEN,'Billing');
4579: x_return_status := OKC_API.G_RET_STS_ERROR ;
4580: CLOSE c_app_info ;
4581: RAISE OKC_API.G_EXCEPTION_ERROR;
4582: END if ;
4583:

Line 4581: RAISE OKC_API.G_EXCEPTION_ERROR;

4577: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4578: G_COL_NAME_TOKEN,'Billing');
4579: x_return_status := OKC_API.G_RET_STS_ERROR ;
4580: CLOSE c_app_info ;
4581: RAISE OKC_API.G_EXCEPTION_ERROR;
4582: END if ;
4583:
4584: CLOSE c_app_info;
4585:

Line 4595: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');

4591: OPEN c_vendor_info (l_sub_rec.subsidy_line_id);
4592: FETCH c_vendor_info INTO l_tapv_rec.vendor_id,l_tapv_rec.IPVS_ID;
4593: IF(c_vendor_info%NOTFOUND) THEN
4594: -- Change Message
4595: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4596: x_return_status := OKC_API.G_RET_STS_ERROR ;
4597: CLOSE c_vendor_info ;
4598: RAISE OKC_API.G_EXCEPTION_ERROR;
4599: END if ;

Line 4596: x_return_status := OKC_API.G_RET_STS_ERROR ;

4592: FETCH c_vendor_info INTO l_tapv_rec.vendor_id,l_tapv_rec.IPVS_ID;
4593: IF(c_vendor_info%NOTFOUND) THEN
4594: -- Change Message
4595: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4596: x_return_status := OKC_API.G_RET_STS_ERROR ;
4597: CLOSE c_vendor_info ;
4598: RAISE OKC_API.G_EXCEPTION_ERROR;
4599: END if ;
4600:

Line 4598: RAISE OKC_API.G_EXCEPTION_ERROR;

4594: -- Change Message
4595: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4596: x_return_status := OKC_API.G_RET_STS_ERROR ;
4597: CLOSE c_vendor_info ;
4598: RAISE OKC_API.G_EXCEPTION_ERROR;
4599: END if ;
4600:
4601: CLOSE c_vendor_info;
4602:

Line 4619: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',

4615: -- GET TRANSACTION TYPE
4616: OPEN c_trx_type ('Disbursement', 'US');
4617: FETCH c_trx_type INTO l_trx_type_ID;
4618: IF(c_trx_type%NOTFOUND) THEN
4619: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4620: G_COL_NAME_TOKEN,'Disbursement');
4621: x_return_status := OKC_API.G_RET_STS_ERROR ;
4622: CLOSE c_trx_type ;
4623: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4621: x_return_status := OKC_API.G_RET_STS_ERROR ;

4617: FETCH c_trx_type INTO l_trx_type_ID;
4618: IF(c_trx_type%NOTFOUND) THEN
4619: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4620: G_COL_NAME_TOKEN,'Disbursement');
4621: x_return_status := OKC_API.G_RET_STS_ERROR ;
4622: CLOSE c_trx_type ;
4623: RAISE OKC_API.G_EXCEPTION_ERROR;
4624: END if ;
4625: CLOSE c_trx_type ;

Line 4623: RAISE OKC_API.G_EXCEPTION_ERROR;

4619: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4620: G_COL_NAME_TOKEN,'Disbursement');
4621: x_return_status := OKC_API.G_RET_STS_ERROR ;
4622: CLOSE c_trx_type ;
4623: RAISE OKC_API.G_EXCEPTION_ERROR;
4624: END if ;
4625: CLOSE c_trx_type ;
4626:
4627: l_tapv_rec.TRY_ID := l_trx_type_ID;

Line 5032: OKC_API.SET_MESSAGE (

5028: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
5029: OR NVL (l_cm_try_id, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM
5030: THEN
5031: l_return_status := OKL_API.G_RET_STS_ERROR;
5032: OKC_API.SET_MESSAGE (
5033: p_app_name => G_APP_NAME,
5034: p_msg_name => G_INVALID_VALUE,
5035: p_token1 => G_COL_NAME_TOKEN,
5036: p_token1_value => 'Transaction Type');

Line 5261: OKC_API.SET_MESSAGE (

5257: OR NVL (l_trmnt_try_id, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM THEN
5258:
5259: l_return_status := OKL_API.G_RET_STS_ERROR;
5260:
5261: OKC_API.SET_MESSAGE (
5262: p_app_name => G_APP_NAME,
5263: p_msg_name => G_INVALID_VALUE,
5264: p_token1 => G_COL_NAME_TOKEN,
5265: p_token1_value => 'Transaction Type');

Line 5626: OKC_API.SET_MESSAGE (

5622: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
5623: OR NVL (l_cm_try_id, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM
5624: THEN
5625:
5626: OKC_API.SET_MESSAGE (
5627: p_app_name => G_APP_NAME,
5628: p_msg_name => G_INVALID_VALUE,
5629: p_token1 => G_COL_NAME_TOKEN,
5630: p_token1_value => 'Transaction Type');