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

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

2075: x_imav_rec Okl_ima_pvt.imav_rec_type;
2076:
2077:
2078: p_api_version NUMBER := 1.0;
2079: p_init_msg_list VARCHAR2(1) := Okl_Api.g_false;
2080: x_return_status VARCHAR2(1);
2081: x_msg_count NUMBER;
2082: x_msg_data VARCHAR2(2000);
2083: -- For automatic generation of sequence numbers from

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

2173: EXCEPTION
2174: --Seed FND_MESSAGE like 'Could NOT CREATE Header RECORD'
2175: WHEN OTHERS THEN
2176: PRINT_TO_LOG('*=> Error Message(H1): '||SQLERRM);
2177: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
2178: p_msg_name => G_OTHERS);
2179: END create_new_invoice;
2180:
2181: --This function checks for the existence of an consolidated invoice line

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

2298: */
2299: EXCEPTION
2300: WHEN NO_DATA_FOUND THEN
2301: PRINT_TO_LOG('*=> Error Message(L1): '||SQLERRM);
2302: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
2303: p_msg_name => G_NO_DATA_FOUND);
2304:
2305: exists_flag := 'N';
2306: WHEN TOO_MANY_ROWS THEN

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

2304:
2305: exists_flag := 'N';
2306: WHEN TOO_MANY_ROWS THEN
2307: PRINT_TO_LOG('*=> Error Message(L2): '||SQLERRM);
2308: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
2309: p_msg_name => G_TOO_MANY_ROWS);
2310:
2311: exists_flag := NULL;
2312: WHEN OTHERS THEN

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

2310:
2311: exists_flag := NULL;
2312: WHEN OTHERS THEN
2313: PRINT_TO_LOG('*=> Error Message(L3): '||SQLERRM);
2314: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
2315: p_msg_name => G_OTHERS);
2316: exists_flag := NULL;
2317:
2318: END line_exist;

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

2342: p_llnv_tbl Okl_Lln_Pvt.llnv_tbl_type;
2343:
2344:
2345: p_api_version NUMBER := 1.0;
2346: p_init_msg_list VARCHAR2(1) := Okl_Api.g_false;
2347: x_return_status VARCHAR2(1) := 'S';
2348: x_msg_count NUMBER;
2349: x_msg_data VARCHAR2(2000);
2350:

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

2426: EXCEPTION
2427: --Seed FND_MESSAGE like 'Could NOT CREATE Line RECORD'
2428: WHEN OTHERS THEN
2429: PRINT_TO_LOG('*=> Error Message(L1): '||SQLERRM);
2430: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
2431: p_msg_name => G_OTHERS);
2432: END create_new_line;
2433:
2434:

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

2477: l_bind_proc VARCHAR2(3000);
2478: l_msg_return VARCHAR2(1);
2479:
2480: p_api_version NUMBER := 1.0;
2481: p_init_msg_list VARCHAR2(1) := Okl_Api.g_false;
2482: x_msg_count NUMBER;
2483: x_msg_data VARCHAR2(2000);
2484: l_cnr_rec cnr_rec_type;
2485: l_lln_rec lln_rec_type;

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

3080: EXCEPTION
3081: --Seed FND_MESSAGE like 'Could NOT CREATE Stream RECORD'
3082: WHEN OTHERS THEN
3083: PRINT_TO_LOG('*=> Error Message(D1): '||SQLERRM);
3084: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME,
3085: p_msg_name => G_OTHERS);
3086: END create_new_streams;
3087:
3088:

Line 3321: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

3317:
3318: -- rmunjulu R12 Fixes -- comment out entire code and put NULL
3319: NULL;
3320: /*
3321: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
3322: PRINT_TO_LOG( 'Total rec count is : '||p_cons_bill_tbl.count);
3323:
3324: g_cons_bill_tbl := p_cons_bill_tbl.count;
3325:

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

4105: ------------------------------------------------------------
4106:
4107: l_api_version CONSTANT NUMBER := 1;
4108: l_api_name CONSTANT VARCHAR2(30) := 'CONSOLIDATED BILLING';
4109: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4110:
4111: CURSOR cntrct_csr ( p_id NUMBER ) IS
4112: SELECT contract_number
4113: FROM okc_k_headers_b

Line 4217: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

4213: ------------------------------------------------------------
4214: -- Start processing
4215: ------------------------------------------------------------
4216:
4217: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
4218: */
4219: /*
4220: l_return_status := Okl_Api.START_ACTIVITY(
4221: p_api_name => l_api_name,

Line 4220: l_return_status := Okl_Api.START_ACTIVITY(

4216:
4217: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
4218: */
4219: /*
4220: l_return_status := Okl_Api.START_ACTIVITY(
4221: p_api_name => l_api_name,
4222: p_pkg_name => G_PKG_NAME,
4223: p_init_msg_list => p_init_msg_list,
4224: l_api_version => l_api_version,

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

4225: p_api_version => p_api_version,
4226: p_api_type => '_PVT',
4227: x_return_status => l_return_status);
4228:
4229: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4231: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4232: RAISE Okl_Api.G_EXCEPTION_ERROR;
4233: END IF;

Line 4230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

4226: p_api_type => '_PVT',
4227: x_return_status => l_return_status);
4228:
4229: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4231: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4232: RAISE Okl_Api.G_EXCEPTION_ERROR;
4233: END IF;
4234: */

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

4227: x_return_status => l_return_status);
4228:
4229: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4231: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4232: RAISE Okl_Api.G_EXCEPTION_ERROR;
4233: END IF;
4234: */
4235: /*

Line 4232: RAISE Okl_Api.G_EXCEPTION_ERROR;

4228:
4229: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4231: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4232: RAISE Okl_Api.G_EXCEPTION_ERROR;
4233: END IF;
4234: */
4235: /*
4236: PRINT_TO_LOG( '========== **** BEGIN PROGRAM EXECUTION **** ============');

Line 5225: Okl_Api.END_ACTIVITY (

5221: ------------------------------------------------------------
5222: -- End processing
5223: ------------------------------------------------------------
5224: /*
5225: Okl_Api.END_ACTIVITY (
5226: x_msg_count => x_msg_count,
5227: x_msg_data => x_msg_data);
5228: */
5229:

Line 5235: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

5231: ------------------------------------------------------------
5232: -- Exception handling
5233: ------------------------------------------------------------
5234:
5235: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
5236: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5237: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
5238: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_ERROR');
5239: END IF;

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

5234:
5235: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
5236: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5237: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
5238: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_ERROR');
5239: END IF;
5240:
5241: PRINT_TO_LOG('*=> Error Message(O1): '||SQLERRM);
5242: -- -------------------------------------------

Line 5251: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

5247: where assigned_process = p_assigned_process;
5248: commit;
5249: end if;
5250:
5251: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
5252: p_api_name => l_api_name,
5253: p_pkg_name => G_PKG_NAME,
5254: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
5255: x_msg_count => x_msg_count,

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

5250:
5251: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
5252: p_api_name => l_api_name,
5253: p_pkg_name => G_PKG_NAME,
5254: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
5255: x_msg_count => x_msg_count,
5256: x_msg_data => x_msg_data,
5257: p_api_type => '_PVT');
5258:

Line 5259: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

5255: x_msg_count => x_msg_count,
5256: x_msg_data => x_msg_data,
5257: p_api_type => '_PVT');
5258:
5259: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
5260:
5261: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5262: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
5263: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR');

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

5259: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
5260:
5261: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5262: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
5263: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR');
5264: END IF;
5265:
5266: PRINT_TO_LOG('*=> Error Message(O2): '||SQLERRM);
5267: -- -------------------------------------------

Line 5276: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

5272: where assigned_process = p_assigned_process;
5273: commit;
5274: end if;
5275:
5276: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
5277: p_api_name => l_api_name,
5278: p_pkg_name => G_PKG_NAME,
5279: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
5280: x_msg_count => x_msg_count,

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

5275:
5276: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
5277: p_api_name => l_api_name,
5278: p_pkg_name => G_PKG_NAME,
5279: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
5280: x_msg_count => x_msg_count,
5281: x_msg_data => x_msg_data,
5282: p_api_type => '_PVT');
5283:

Line 5300: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

5296: where assigned_process = p_assigned_process;
5297: commit;
5298: end if;
5299:
5300: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
5301: p_api_name => l_api_name,
5302: p_pkg_name => G_PKG_NAME,
5303: p_exc_name => 'OTHERS',
5304: x_msg_count => x_msg_count,