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 299: p_app_name => OKC_API.G_APP_NAME,

295: || sqlcode || ' , SQLERRM : ' || sqlerrm);
296: END IF;
297:
298: OKL_API.set_message(
299: p_app_name => OKC_API.G_APP_NAME,
300: p_msg_name => G_UNEXPECTED_ERROR,
301: p_token1 => G_SQLCODE_TOKEN,
302: p_token1_value => SQLCODE,
303: p_token2 => G_SQLERRM_TOKEN,

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

359: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
360: || sqlcode || ' , SQLERRM : ' || sqlerrm);
361: END IF;
362: -- Set the oracle error message
363: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
364: p_msg_name => g_unexpected_error,
365: p_token1 => g_sqlcode_token,
366: p_token1_value => SQLCODE,
367: p_token2 => g_sqlerrm_token,

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

488: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
489: || sqlcode || ' , SQLERRM : ' || sqlerrm);
490: END IF;
491: -- Set the oracle error message
492: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
493: p_msg_name => g_unexpected_error,
494: p_token1 => g_sqlcode_token,
495: p_token1_value => SQLCODE,
496: p_token2 => g_sqlerrm_token,

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

628: END IF;
629: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
630: p_api_name => l_api_name,
631: p_pkg_name => G_PKG_NAME,
632: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
633: x_msg_count => x_msg_count,
634: x_msg_data => x_msg_data,
635: p_api_type => G_API_TYPE);
636:

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

640: END IF;
641: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
642: p_api_name => l_api_name,
643: p_pkg_name => G_PKG_NAME,
644: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
645: x_msg_count => x_msg_count,
646: x_msg_data => x_msg_data,
647: p_api_type => G_API_TYPE);
648:

Line 784: p_app_name => OKC_API.G_APP_NAME,

780: || sqlcode || ' , SQLERRM : ' || sqlerrm);
781: END IF;
782:
783: OKL_API.set_message(
784: p_app_name => OKC_API.G_APP_NAME,
785: p_msg_name => G_UNEXPECTED_ERROR,
786: p_token1 => G_SQLCODE_TOKEN,
787: p_token1_value => SQLCODE,
788: p_token2 => G_SQLERRM_TOKEN,

Line 900: p_app_name => OKC_API.G_APP_NAME,

896: || sqlcode || ' , SQLERRM : ' || sqlerrm);
897: END IF;
898:
899: OKL_API.set_message(
900: p_app_name => OKC_API.G_APP_NAME,
901: p_msg_name => G_UNEXPECTED_ERROR,
902: p_token1 => G_SQLCODE_TOKEN,
903: p_token1_value => SQLCODE,
904: p_token2 => G_SQLERRM_TOKEN,

Line 1080: p_app_name => OKC_API.G_APP_NAME,

1076: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1077: END IF;
1078:
1079: OKL_API.set_message(
1080: p_app_name => OKC_API.G_APP_NAME,
1081: p_msg_name => G_UNEXPECTED_ERROR,
1082: p_token1 => G_SQLCODE_TOKEN,
1083: p_token1_value => SQLCODE,
1084: p_token2 => G_SQLERRM_TOKEN,

Line 1367: p_app_name => OKC_API.G_APP_NAME,

1363: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1364: END IF;
1365:
1366: OKL_API.set_message(
1367: p_app_name => OKC_API.G_APP_NAME,
1368: p_msg_name => G_UNEXPECTED_ERROR,
1369: p_token1 => G_SQLCODE_TOKEN,
1370: p_token1_value => SQLCODE,
1371: p_token2 => G_SQLERRM_TOKEN,

Line 1605: p_app_name => OKC_API.G_APP_NAME,

1601: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1602: END IF;
1603:
1604: OKL_API.set_message(
1605: p_app_name => OKC_API.G_APP_NAME,
1606: p_msg_name => G_UNEXPECTED_ERROR,
1607: p_token1 => G_SQLCODE_TOKEN,
1608: p_token1_value => SQLCODE,
1609: p_token2 => G_SQLERRM_TOKEN,

Line 1720: p_app_name => OKC_API.G_APP_NAME,

1716: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1717: END IF;
1718:
1719: OKL_API.set_message(
1720: p_app_name => OKC_API.G_APP_NAME,
1721: p_msg_name => G_UNEXPECTED_ERROR,
1722: p_token1 => G_SQLCODE_TOKEN,
1723: p_token1_value => SQLCODE,
1724: p_token2 => G_SQLERRM_TOKEN,

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

1882:
1883: -- Check contract id passed is valid
1884: IF k_header_rec.id IS NULL OR k_header_rec.contract_number IS NULL THEN
1885:
1886: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1887: p_msg_name => OKC_API.G_INVALID_VALUE,
1888: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1889: p_token1_value => 'contract id');
1890:

Line 1887: p_msg_name => OKC_API.G_INVALID_VALUE,

1883: -- Check contract id passed is valid
1884: IF k_header_rec.id IS NULL OR k_header_rec.contract_number IS NULL THEN
1885:
1886: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1887: p_msg_name => OKC_API.G_INVALID_VALUE,
1888: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1889: p_token1_value => 'contract id');
1890:
1891: RAISE l_invalid_contract;

Line 1888: p_token1 => OKC_API.G_COL_NAME_TOKEN,

1884: IF k_header_rec.id IS NULL OR k_header_rec.contract_number IS NULL THEN
1885:
1886: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1887: p_msg_name => OKC_API.G_INVALID_VALUE,
1888: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1889: p_token1_value => 'contract id');
1890:
1891: RAISE l_invalid_contract;
1892: END IF;

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

1941:
1942: -- Check if template
1943: IF k_header_rec.template_yn = OKL_API.G_TRUE THEN
1944: -- Message: This operation is not allowed on contract template-(NUMBER).
1945: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1946: p_msg_name => 'OKC_K_TEMPLATE',
1947: p_token1 => 'NUMBER',
1948: p_token1_value => k_header_rec.contract_number);
1949: RAISE l_invalid_contract;

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

1952: -- Check if locked
1953: IF l_chg_request_in_process = 'x' THEN
1954: -- Message: You cannot modify this contract now because a
1955: -- change request is active. Please try later.
1956: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1957: p_msg_name => 'OKC_K_LOCKED');
1958: RAISE l_invalid_contract;
1959: END IF;
1960:

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

1961: -- Check if service requests found
1962: IF l_service_request = 'x' THEN
1963: -- Message: You cannot terminate this contract/line because a service
1964: --request is pending against this contract/line. Please try again later.
1965: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
1966: p_msg_name => 'OKC_SR_PENDING');
1967: RAISE l_invalid_contract;
1968: END IF;
1969:

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

2260:
2261: -- Check if template
2262: IF k_header_rec.template_yn = OKL_API.G_TRUE THEN
2263: -- Message: This operation is not allowed on contract template-(NUMBER).
2264: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2265: p_msg_name => 'OKC_K_TEMPLATE',
2266: p_token1 => 'NUMBER',
2267: p_token1_value => k_header_rec.contract_number);
2268: RAISE l_invalid_contract;

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

2272: -- Check if locked
2273: IF l_chg_request_in_process = 'x' THEN
2274: -- Message: You cannot modify this contract now because a
2275: -- change request is active. Please try later.
2276: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2277: p_msg_name => 'OKC_K_LOCKED');
2278: RAISE l_invalid_contract;
2279: END IF;
2280:

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

2281: --Check if service requests found
2282: IF l_service_request = 'x' THEN
2283: -- Message: You cannot terminate this contract/line because a service
2284: --request is pending against this contract/line. Please try again later.
2285: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2286: p_msg_name => 'OKC_SR_PENDING');
2287: RAISE l_invalid_contract;
2288: END IF;
2289: */

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

2298:
2299: -- Check if template
2300: IF k_header_rec.template_yn = OKL_API.G_TRUE THEN
2301: -- Message: This operation is not allowed on contract template-(NUMBER).
2302: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2303: p_msg_name => 'OKC_K_TEMPLATE',
2304: p_token1 => 'NUMBER',
2305: p_token1_value => k_header_rec.contract_number);
2306: RAISE l_invalid_contract;

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

2310: -- Check if locked
2311: IF l_chg_request_in_process = 'x' THEN
2312: -- Message: You cannot modify this contract now because a
2313: -- change request is active. Please try later.
2314: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2315: p_msg_name => 'OKC_K_LOCKED');
2316: RAISE l_invalid_contract;
2317: END IF;
2318:

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

2319: --Check if service requests found
2320: IF l_service_request = 'x' THEN
2321: -- Message: You cannot terminate this contract/line because a service
2322: --request is pending against this contract/line. Please try again later.
2323: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2324: p_msg_name => 'OKC_SR_PENDING');
2325: RAISE l_invalid_contract;
2326: END IF;
2327: */

Line 2475: p_app_name => OKC_API.G_APP_NAME

2471: END IF;
2472:
2473: -- store SQL error message on message stack for caller
2474: OKL_API.SET_MESSAGE (
2475: p_app_name => OKC_API.G_APP_NAME
2476: ,p_msg_name => G_UNEXPECTED_ERROR
2477: ,p_token1 => G_SQLCODE_TOKEN
2478: ,p_token1_value => sqlcode
2479: ,p_token2 => G_SQLERRM_TOKEN

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

2544:
2545: OPEN k_header_csr;
2546: FETCH k_header_csr INTO k_header_rec;
2547: IF k_header_csr%NOTFOUND THEN
2548: OKL_API.set_message(p_app_name => OKC_API.G_APP_NAME,
2549: p_msg_name => 'OKC_K_CHANGED',
2550: p_token1 => 'NUMBER',
2551: p_token1_value => p_term_rec.p_contract_number,
2552: p_token2 => 'MODIFIER',

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

2614: IF k_deal_type_csr%ISOPEN THEN
2615: CLOSE k_deal_type_csr;
2616: END IF;
2617: x_lease_loan_type := '$';
2618: OKL_API.set_message(p_app_name => okc_api.g_app_name,
2619: p_msg_name => g_unexpected_error,
2620: p_token1 => g_sqlcode_token,
2621: p_token1_value => sqlcode,
2622: p_token2 => g_sqlerrm_token,

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

3153: CLOSE l_qte_csr;
3154: END IF;
3155:
3156:
3157: OKL_API.set_message(p_app_name => okc_api.g_app_name,
3158: p_msg_name => g_unexpected_error,
3159: p_token1 => g_sqlcode_token,
3160: p_token1_value => sqlcode,
3161: p_token2 => g_sqlerrm_token,

Line 3385: p_app_name => OKC_API.G_APP_NAME,

3381: x_return_status := OKL_API.g_ret_sts_error;
3382:
3383: -- Set the oracle error message
3384: OKL_API.set_message(
3385: p_app_name => OKC_API.G_APP_NAME,
3386: p_msg_name => g_unexpected_error,
3387: p_token1 => g_sqlcode_token,
3388: p_token1_value => SQLCODE,
3389: p_token2 => g_sqlerrm_token,

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

4054: FETCH c_app_info INTO l_app_id;
4055: IF(c_app_info%NOTFOUND)
4056: THEN
4057: -- Change Message
4058: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4059: G_COL_NAME_TOKEN,'Billing');
4060: x_return_status := OKC_API.G_RET_STS_ERROR ;
4061: CLOSE c_app_info ;
4062: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4060: x_return_status := OKC_API.G_RET_STS_ERROR ;

4056: THEN
4057: -- Change Message
4058: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4059: G_COL_NAME_TOKEN,'Billing');
4060: x_return_status := OKC_API.G_RET_STS_ERROR ;
4061: CLOSE c_app_info ;
4062: RAISE OKC_API.G_EXCEPTION_ERROR;
4063: END if ;
4064: CLOSE c_app_info;

Line 4062: RAISE OKC_API.G_EXCEPTION_ERROR;

4058: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4059: G_COL_NAME_TOKEN,'Billing');
4060: x_return_status := OKC_API.G_RET_STS_ERROR ;
4061: CLOSE c_app_info ;
4062: RAISE OKC_API.G_EXCEPTION_ERROR;
4063: END if ;
4064: CLOSE c_app_info;
4065:
4066: -- get Vendor site Id

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

4067: OPEN c_vendor_info (l_sub_rec.subsidy_line_id);
4068: FETCH c_vendor_info INTO l_tapv_rec.vendor_id, l_tapv_rec.IPVS_ID;
4069: IF(c_vendor_info%NOTFOUND) THEN
4070: -- Change Message
4071: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4072: x_return_status := OKC_API.G_RET_STS_ERROR ;
4073: CLOSE c_vendor_info ;
4074: RAISE OKC_API.G_EXCEPTION_ERROR;
4075: END if ;

Line 4072: x_return_status := OKC_API.G_RET_STS_ERROR ;

4068: FETCH c_vendor_info INTO l_tapv_rec.vendor_id, l_tapv_rec.IPVS_ID;
4069: IF(c_vendor_info%NOTFOUND) THEN
4070: -- Change Message
4071: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4072: x_return_status := OKC_API.G_RET_STS_ERROR ;
4073: CLOSE c_vendor_info ;
4074: RAISE OKC_API.G_EXCEPTION_ERROR;
4075: END if ;
4076: CLOSE c_vendor_info;

Line 4074: RAISE OKC_API.G_EXCEPTION_ERROR;

4070: -- Change Message
4071: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4072: x_return_status := OKC_API.G_RET_STS_ERROR ;
4073: CLOSE c_vendor_info ;
4074: RAISE OKC_API.G_EXCEPTION_ERROR;
4075: END if ;
4076: CLOSE c_vendor_info;
4077:
4078: l_tapv_rec.sfwt_flag := 'N' ;

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

4088: OPEN c_trx_type ('Disbursement', 'US');
4089: FETCH c_trx_type INTO l_trx_type_ID;
4090: IF(c_trx_type%NOTFOUND)
4091: THEN
4092: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4093: G_COL_NAME_TOKEN,'Disbursement');
4094: x_return_status := OKC_API.G_RET_STS_ERROR ;
4095: CLOSE c_trx_type ;
4096: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4094: x_return_status := OKC_API.G_RET_STS_ERROR ;

4090: IF(c_trx_type%NOTFOUND)
4091: THEN
4092: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4093: G_COL_NAME_TOKEN,'Disbursement');
4094: x_return_status := OKC_API.G_RET_STS_ERROR ;
4095: CLOSE c_trx_type ;
4096: RAISE OKC_API.G_EXCEPTION_ERROR;
4097: END if ;
4098: CLOSE c_trx_type ;

Line 4096: RAISE OKC_API.G_EXCEPTION_ERROR;

4092: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4093: G_COL_NAME_TOKEN,'Disbursement');
4094: x_return_status := OKC_API.G_RET_STS_ERROR ;
4095: CLOSE c_trx_type ;
4096: RAISE OKC_API.G_EXCEPTION_ERROR;
4097: END if ;
4098: CLOSE c_trx_type ;
4099: l_tapv_rec.TRY_ID := l_trx_type_ID;
4100: l_tapv_rec.AMOUNT := lx_subsidy_amount;

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

4551: OPEN c_app_info ;
4552: FETCH c_app_info INTO l_app_id;
4553: IF(c_app_info%NOTFOUND) THEN
4554: -- Change Message
4555: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4556: G_COL_NAME_TOKEN,'Billing');
4557: x_return_status := OKC_API.G_RET_STS_ERROR ;
4558: CLOSE c_app_info ;
4559: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4557: x_return_status := OKC_API.G_RET_STS_ERROR ;

4553: IF(c_app_info%NOTFOUND) THEN
4554: -- Change Message
4555: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4556: G_COL_NAME_TOKEN,'Billing');
4557: x_return_status := OKC_API.G_RET_STS_ERROR ;
4558: CLOSE c_app_info ;
4559: RAISE OKC_API.G_EXCEPTION_ERROR;
4560: END if ;
4561:

Line 4559: RAISE OKC_API.G_EXCEPTION_ERROR;

4555: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4556: G_COL_NAME_TOKEN,'Billing');
4557: x_return_status := OKC_API.G_RET_STS_ERROR ;
4558: CLOSE c_app_info ;
4559: RAISE OKC_API.G_EXCEPTION_ERROR;
4560: END if ;
4561:
4562: CLOSE c_app_info;
4563:

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

4569: OPEN c_vendor_info (l_sub_rec.subsidy_line_id);
4570: FETCH c_vendor_info INTO l_tapv_rec.vendor_id,l_tapv_rec.IPVS_ID;
4571: IF(c_vendor_info%NOTFOUND) THEN
4572: -- Change Message
4573: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4574: x_return_status := OKC_API.G_RET_STS_ERROR ;
4575: CLOSE c_vendor_info ;
4576: RAISE OKC_API.G_EXCEPTION_ERROR;
4577: END if ;

Line 4574: x_return_status := OKC_API.G_RET_STS_ERROR ;

4570: FETCH c_vendor_info INTO l_tapv_rec.vendor_id,l_tapv_rec.IPVS_ID;
4571: IF(c_vendor_info%NOTFOUND) THEN
4572: -- Change Message
4573: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4574: x_return_status := OKC_API.G_RET_STS_ERROR ;
4575: CLOSE c_vendor_info ;
4576: RAISE OKC_API.G_EXCEPTION_ERROR;
4577: END if ;
4578:

Line 4576: RAISE OKC_API.G_EXCEPTION_ERROR;

4572: -- Change Message
4573: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_VENDOR_SITE');
4574: x_return_status := OKC_API.G_RET_STS_ERROR ;
4575: CLOSE c_vendor_info ;
4576: RAISE OKC_API.G_EXCEPTION_ERROR;
4577: END if ;
4578:
4579: CLOSE c_vendor_info;
4580:

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

4593: -- GET TRANSACTION TYPE
4594: OPEN c_trx_type ('Disbursement', 'US');
4595: FETCH c_trx_type INTO l_trx_type_ID;
4596: IF(c_trx_type%NOTFOUND) THEN
4597: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4598: G_COL_NAME_TOKEN,'Disbursement');
4599: x_return_status := OKC_API.G_RET_STS_ERROR ;
4600: CLOSE c_trx_type ;
4601: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4599: x_return_status := OKC_API.G_RET_STS_ERROR ;

4595: FETCH c_trx_type INTO l_trx_type_ID;
4596: IF(c_trx_type%NOTFOUND) THEN
4597: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4598: G_COL_NAME_TOKEN,'Disbursement');
4599: x_return_status := OKC_API.G_RET_STS_ERROR ;
4600: CLOSE c_trx_type ;
4601: RAISE OKC_API.G_EXCEPTION_ERROR;
4602: END if ;
4603: CLOSE c_trx_type ;

Line 4601: RAISE OKC_API.G_EXCEPTION_ERROR;

4597: Okc_Api.set_message(G_APP_NAME, 'OKL_NO_TRANSACTION',
4598: G_COL_NAME_TOKEN,'Disbursement');
4599: x_return_status := OKC_API.G_RET_STS_ERROR ;
4600: CLOSE c_trx_type ;
4601: RAISE OKC_API.G_EXCEPTION_ERROR;
4602: END if ;
4603: CLOSE c_trx_type ;
4604:
4605: l_tapv_rec.TRY_ID := l_trx_type_ID;

Line 4991: OKC_API.SET_MESSAGE (

4987: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
4988: OR NVL (l_cm_try_id, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM
4989: THEN
4990: l_return_status := OKL_API.G_RET_STS_ERROR;
4991: OKC_API.SET_MESSAGE (
4992: p_app_name => G_APP_NAME,
4993: p_msg_name => G_INVALID_VALUE,
4994: p_token1 => G_COL_NAME_TOKEN,
4995: p_token1_value => 'Transaction Type');

Line 5220: OKC_API.SET_MESSAGE (

5216: OR NVL (l_trmnt_try_id, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM THEN
5217:
5218: l_return_status := OKL_API.G_RET_STS_ERROR;
5219:
5220: OKC_API.SET_MESSAGE (
5221: p_app_name => G_APP_NAME,
5222: p_msg_name => G_INVALID_VALUE,
5223: p_token1 => G_COL_NAME_TOKEN,
5224: p_token1_value => 'Transaction Type');

Line 5582: OKC_API.SET_MESSAGE (

5578: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
5579: OR NVL (l_cm_try_id, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM
5580: THEN
5581:
5582: OKC_API.SET_MESSAGE (
5583: p_app_name => G_APP_NAME,
5584: p_msg_name => G_INVALID_VALUE,
5585: p_token1 => G_COL_NAME_TOKEN,
5586: p_token1_value => 'Transaction Type');