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_CONS_BILL dependencies on OKL_API

Line 332: p_init_msg_list VARCHAR2(1) := Okl_Api.g_false;

328: x_imav_rec Okl_ima_pvt.imav_rec_type;
329:
330:
331: p_api_version NUMBER := 1.0;
332: p_init_msg_list VARCHAR2(1) := Okl_Api.g_false;
333: x_return_status VARCHAR2(1);
334: x_msg_count NUMBER;
335: x_msg_data VARCHAR2(2000);
336: -- For automatic generation of sequence numbers from

Line 555: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,

551: WHEN OTHERS THEN
552: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
553: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(H1): '||SQLERRM);
554: END IF;
555: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
556: p_msg_name => G_OTHERS);
557: END create_new_invoice;
558:
559: --This function checks for the existence of an consolidated invoice line

Line 721: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,

717: WHEN NO_DATA_FOUND THEN
718: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
719: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(L1): '||SQLERRM);
720: END IF;
721: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
722: p_msg_name => G_NO_DATA_FOUND);
723:
724: exists_flag := 'N';
725: WHEN TOO_MANY_ROWS THEN

Line 729: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,

725: WHEN TOO_MANY_ROWS THEN
726: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
727: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(L2): '||SQLERRM);
728: END IF;
729: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
730: p_msg_name => G_TOO_MANY_ROWS);
731:
732: exists_flag := NULL;
733: WHEN OTHERS THEN

Line 737: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,

733: WHEN OTHERS THEN
734: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
735: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(L3): '||SQLERRM);
736: END IF;
737: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
738: p_msg_name => G_OTHERS);
739: exists_flag := NULL;
740:
741: END line_exist;

Line 769: p_init_msg_list VARCHAR2(1) := Okl_Api.g_false;

765: p_llnv_tbl Okl_Lln_Pvt.llnv_tbl_type;
766:
767:
768: p_api_version NUMBER := 1.0;
769: p_init_msg_list VARCHAR2(1) := Okl_Api.g_false;
770: x_return_status VARCHAR2(1);
771: x_msg_count NUMBER;
772: x_msg_data VARCHAR2(2000);
773:

Line 857: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,

853: WHEN OTHERS THEN
854: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
855: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(L1): '||SQLERRM);
856: END IF;
857: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
858: p_msg_name => G_OTHERS);
859: END create_new_line;
860:
861:

Line 885: p_init_msg_list VARCHAR2(1) := Okl_Api.g_false;

881: p_lsmv_tbl Okl_Lsm_Pvt.lsmv_tbl_type;
882:
883:
884: p_api_version NUMBER := 1.0;
885: p_init_msg_list VARCHAR2(1) := Okl_Api.g_false;
886: x_msg_count NUMBER;
887: x_msg_data VARCHAR2(2000);
888:
889:

Line 955: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,

951: WHEN OTHERS THEN
952: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
953: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(D1): '||SQLERRM);
954: END IF;
955: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
956: p_msg_name => G_OTHERS);
957: END create_new_streams;
958:
959:

Line 1120: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1116: IF (G_DEBUG_ENABLED = 'Y') THEN
1117: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1118: END IF;
1119:
1120: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1121:
1122: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1123: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Total rec count is : '||p_cons_bill_tbl.count);
1124: END IF;

Line 1257: IF (p_cons_bill_tbl(k).legal_entity_id IS NULL OR (p_cons_bill_tbl(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN

1253: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, '*** CREATE CONSOLIDATED INVOICE HEADER ***');
1254: END IF;
1255: l_cons_inv_num := NULL;
1256: -- for LE Uptake project 08-11-2006
1257: IF (p_cons_bill_tbl(k).legal_entity_id IS NULL OR (p_cons_bill_tbl(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
1258: l_legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_cons_bill_tbl(k).contract_id);
1259: ELSE
1260: l_legal_entity_id := p_cons_bill_tbl(k).legal_entity_id;
1261: END IF;

Line 1374: IF (p_cons_bill_tbl(k).legal_entity_id IS NULL OR (p_cons_bill_tbl(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN

1370: -- Null out current value in local variable.
1371: l_cnr_id := NULL;
1372: l_cons_inv_num := NULL;
1373: -- for LE Uptake project 08-11-2006
1374: IF (p_cons_bill_tbl(k).legal_entity_id IS NULL OR (p_cons_bill_tbl(k).legal_entity_id = Okl_Api.G_MISS_NUM)) THEN
1375: l_legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_cons_bill_tbl(k).contract_id);
1376: ELSE
1377: l_legal_entity_id := p_cons_bill_tbl(k).legal_entity_id;
1378: END IF;

Line 2018: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2014: ------------------------------------------------------------
2015:
2016: l_api_version CONSTANT NUMBER := 1;
2017: l_api_name CONSTANT VARCHAR2(30) := 'CONSOLIDATED BILLING';
2018: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2019:
2020: CURSOR cntrct_csr ( p_id NUMBER ) IS
2021: SELECT contract_number
2022: FROM okc_k_headers_b

Line 2140: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2136: ------------------------------------------------------------
2137: -- Start processing
2138: ------------------------------------------------------------
2139:
2140: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2141:
2142: l_return_status := Okl_Api.START_ACTIVITY(
2143: p_api_name => l_api_name,
2144: p_pkg_name => G_PKG_NAME,

Line 2142: l_return_status := Okl_Api.START_ACTIVITY(

2138: ------------------------------------------------------------
2139:
2140: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2141:
2142: l_return_status := Okl_Api.START_ACTIVITY(
2143: p_api_name => l_api_name,
2144: p_pkg_name => G_PKG_NAME,
2145: p_init_msg_list => p_init_msg_list,
2146: l_api_version => l_api_version,

Line 2151: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2147: p_api_version => p_api_version,
2148: p_api_type => '_PVT',
2149: x_return_status => l_return_status);
2150:
2151: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2154: RAISE Okl_Api.G_EXCEPTION_ERROR;
2155: END IF;

Line 2152: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2148: p_api_type => '_PVT',
2149: x_return_status => l_return_status);
2150:
2151: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2154: RAISE Okl_Api.G_EXCEPTION_ERROR;
2155: END IF;
2156:

Line 2153: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2149: x_return_status => l_return_status);
2150:
2151: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2154: RAISE Okl_Api.G_EXCEPTION_ERROR;
2155: END IF;
2156:
2157: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2154: RAISE Okl_Api.G_EXCEPTION_ERROR;

2150:
2151: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2154: RAISE Okl_Api.G_EXCEPTION_ERROR;
2155: END IF;
2156:
2157: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2158: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, '========== **** BEGIN PROGRAM EXECUTION **** ============');

Line 2231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2227: x_return_status => l_return_status,
2228: x_msg_count => x_msg_count,
2229: x_msg_data => x_msg_data);
2230:
2231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2234: RAISE Okl_Api.G_EXCEPTION_ERROR;
2235: END IF;

Line 2232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2228: x_msg_count => x_msg_count,
2229: x_msg_data => x_msg_data);
2230:
2231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2234: RAISE Okl_Api.G_EXCEPTION_ERROR;
2235: END IF;
2236:

Line 2233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2229: x_msg_data => x_msg_data);
2230:
2231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2234: RAISE Okl_Api.G_EXCEPTION_ERROR;
2235: END IF;
2236:
2237: /*

Line 2234: RAISE Okl_Api.G_EXCEPTION_ERROR;

2230:
2231: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2232: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2233: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2234: RAISE Okl_Api.G_EXCEPTION_ERROR;
2235: END IF;
2236:
2237: /*
2238: OPEN C1;

Line 3231: Okl_Api.END_ACTIVITY (

3227: ------------------------------------------------------------
3228: -- End processing
3229: ------------------------------------------------------------
3230:
3231: Okl_Api.END_ACTIVITY (
3232: x_msg_count => x_msg_count,
3233: x_msg_data => x_msg_data);
3234:
3235:

Line 3241: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3237: ------------------------------------------------------------
3238: -- Exception handling
3239: ------------------------------------------------------------
3240:
3241: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3242:
3243: -- -------------------------------------------
3244: -- Purge data from the Parallel process Table
3245: -- -------------------------------------------

Line 3254: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_ERROR');

3250: END IF;
3251:
3252: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3253: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
3254: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_ERROR');
3255: END IF;
3256:
3257: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3258: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(O1): '||SQLERRM);

Line 3260: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3256:
3257: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3258: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(O1): '||SQLERRM);
3259: END IF;
3260: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3261: p_api_name => l_api_name,
3262: p_pkg_name => G_PKG_NAME,
3263: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3264: x_msg_count => x_msg_count,

Line 3263: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

3259: END IF;
3260: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3261: p_api_name => l_api_name,
3262: p_pkg_name => G_PKG_NAME,
3263: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
3264: x_msg_count => x_msg_count,
3265: x_msg_data => x_msg_data,
3266: p_api_type => '_PVT');
3267:

Line 3268: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3264: x_msg_count => x_msg_count,
3265: x_msg_data => x_msg_data,
3266: p_api_type => '_PVT');
3267:
3268: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3269:
3270: -- -------------------------------------------
3271: -- Purge data from the Parallel process Table
3272: -- -------------------------------------------

Line 3281: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR');

3277: END IF;
3278:
3279: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3280: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
3281: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR');
3282: END IF;
3283:
3284: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3285: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(O2): '||SQLERRM);

Line 3287: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3283:
3284: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3285: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(O2): '||SQLERRM);
3286: END IF;
3287: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3288: p_api_name => l_api_name,
3289: p_pkg_name => G_PKG_NAME,
3290: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3291: x_msg_count => x_msg_count,

Line 3290: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

3286: END IF;
3287: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3288: p_api_name => l_api_name,
3289: p_pkg_name => G_PKG_NAME,
3290: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
3291: x_msg_count => x_msg_count,
3292: x_msg_data => x_msg_data,
3293: p_api_type => '_PVT');
3294:

Line 3314: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

3310:
3311: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3312: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> Error Message(O3): '||SQLERRM);
3313: END IF;
3314: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3315: p_api_name => l_api_name,
3316: p_pkg_name => G_PKG_NAME,
3317: p_exc_name => 'OTHERS',
3318: x_msg_count => x_msg_count,