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_CONTRACT_BALANCES_PVT dependencies on FND_LOG

Line 24: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.CREATE_CONTRACT_BALANCE';

20: , x_cblv_rec OUT NOCOPY okl_cblv_rec) AS
21: l_api_version CONSTANT NUMBER DEFAULT 1.0;
22: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_CONTRACT_BAL_REC';
23:
24: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.CREATE_CONTRACT_BALANCE';
25: l_debug_enabled VARCHAR2(10);
26:
27:
28: BEGIN

Line 34: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call create_contract_balance(REC)');

30:
31: l_debug_enabled := okl_debug_pub.check_log_enabled;
32:
33: IF(NVL(l_debug_enabled,'N')='Y') THEN
34: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call create_contract_balance(REC)');
35: END IF;
36:
37: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
38: x_return_status := OKL_API.START_ACTIVITY(

Line 63: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

59: x_cblv_rec => x_cblv_rec);
60:
61: -- write to log
62: IF(NVL(l_debug_enabled,'N')='Y') THEN
63: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
64: l_module,
65: 'okl_cbl_pvt.insert_row(rec) returned with status '||x_return_status||' id '||x_cblv_rec.id
66: );
67: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 79: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call create_contract_balance(REC)');

75: -- commit the savepoint
76: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
77:
78: IF(NVL(l_debug_enabled,'N')='Y') THEN
79: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call create_contract_balance(REC)');
80: END IF;
81: EXCEPTION
82: WHEN OKL_API.G_EXCEPTION_ERROR THEN
83: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 130: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.CREATE_CONTRACT_BALANCE';

126: , x_cblv_tbl OUT NOCOPY okl_cblv_tbl) AS
127: l_api_version CONSTANT NUMBER DEFAULT 1.0;
128: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_CONTRACT_BAL_TBL';
129:
130: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.CREATE_CONTRACT_BALANCE';
131: l_debug_enabled VARCHAR2(10);
132:
133: BEGIN
134: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 139: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call create_contract_balance(TBL)');

135:
136: l_debug_enabled := okl_debug_pub.check_log_enabled;
137:
138: IF(NVL(l_debug_enabled,'N')='Y') THEN
139: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call create_contract_balance(TBL)');
140: END IF;
141:
142: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
143: x_return_status := OKL_API.START_ACTIVITY(

Line 168: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

164: x_cblv_tbl => x_cblv_tbl);
165:
166: -- write to log
167: IF(NVL(l_debug_enabled,'N')='Y') THEN
168: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
169: l_module,
170: 'okl_cbl_pvt.insert_row (tbl) returned with status '||x_return_status
171: );
172: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 184: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call create_contract_balance(TBL)');

180: -- commit the savepoint
181: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
182:
183: IF(NVL(l_debug_enabled,'N')='Y') THEN
184: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call create_contract_balance(TBL)');
185: END IF;
186: EXCEPTION
187: WHEN OKL_API.G_EXCEPTION_ERROR THEN
188: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 235: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.UPDATE_CONTRACT_BALANCE';

231: , x_cblv_rec OUT NOCOPY okl_cblv_rec) AS
232: l_api_version CONSTANT NUMBER DEFAULT 1.0;
233: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CONTRACT_BAL_REC';
234:
235: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.UPDATE_CONTRACT_BALANCE';
236: l_debug_enabled VARCHAR2(10);
237:
238: BEGIN
239: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 244: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call update_contract_balance(REC)');

240:
241: l_debug_enabled := okl_debug_pub.check_log_enabled;
242:
243: IF(NVL(l_debug_enabled,'N')='Y') THEN
244: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call update_contract_balance(REC)');
245: END IF;
246:
247: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
248: x_return_status := OKL_API.START_ACTIVITY(

Line 273: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

269: x_cblv_rec => x_cblv_rec);
270:
271: -- write to log
272: IF(NVL(l_debug_enabled,'N')='Y') THEN
273: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
274: l_module,
275: 'okl_cbl_pvt.update_row(rec) returned with status '||x_return_status||'id '||x_cblv_rec.id
276: );
277: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 289: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call update_contract_balance(REC)');

285: -- commit the savepoint
286: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
287:
288: IF(NVL(l_debug_enabled,'N')='Y') THEN
289: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call update_contract_balance(REC)');
290: END IF;
291: EXCEPTION
292: WHEN OKL_API.G_EXCEPTION_ERROR THEN
293: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 340: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.UPATE_CONTRACT_BALANCE';

336: , x_cblv_tbl OUT NOCOPY okl_cblv_tbl) AS
337: l_api_version CONSTANT NUMBER DEFAULT 1.0;
338: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CONTRACT_BAL_TBL';
339:
340: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.UPATE_CONTRACT_BALANCE';
341: l_debug_enabled VARCHAR2(10);
342:
343: BEGIN
344: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 349: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call update_contract_balance(TBL)');

345:
346: l_debug_enabled := okl_debug_pub.check_log_enabled;
347:
348: IF(NVL(l_debug_enabled,'N')='Y') THEN
349: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call update_contract_balance(TBL)');
350: END IF;
351:
352: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
353: x_return_status := OKL_API.START_ACTIVITY(

Line 378: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

374: x_cblv_tbl => x_cblv_tbl);
375:
376: -- write to log
377: IF(NVL(l_debug_enabled,'N')='Y') THEN
378: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
379: l_module,
380: 'okl_cbl_pvt.update_row (tbl) returned with status '||x_return_status
381: );
382: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 394: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call update_contract_balance(TBL)');

390: -- commit the savepoint
391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
392:
393: IF(NVL(l_debug_enabled,'N')='Y') THEN
394: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call update_contract_balance(TBL)');
395: END IF;
396: EXCEPTION
397: WHEN OKL_API.G_EXCEPTION_ERROR THEN
398: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 444: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.DELETE_CONTRACT_BALANCE';

440: , p_cblv_tbl IN okl_cblv_tbl) AS
441: l_api_version CONSTANT NUMBER DEFAULT 1.0;
442: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'DELETE_CONTRACT_BAL_TBL';
443:
444: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.DELETE_CONTRACT_BALANCE';
445: l_debug_enabled VARCHAR2(10);
446:
447: BEGIN
448: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 453: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call delete_contract_balance(TBL)');

449:
450: l_debug_enabled := okl_debug_pub.check_log_enabled;
451:
452: IF(NVL(l_debug_enabled,'N')='Y') THEN
453: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call delete_contract_balance(TBL)');
454: END IF;
455:
456: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
457: x_return_status := OKL_API.START_ACTIVITY(

Line 481: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

477: p_cblv_tbl => p_cblv_tbl);
478:
479: -- write to log
480: IF(NVL(l_debug_enabled,'N')='Y') THEN
481: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
482: l_module,
483: 'okl_cbl_pvt.delete_row (tbl) returned with status '||x_return_status
484: );
485: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 497: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call delete_contract_balance(TBL)');

493: -- commit the savepoint
494: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
495:
496: IF(NVL(l_debug_enabled,'N')='Y') THEN
497: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call delete_contract_balance(TBL)');
498: END IF;
499: EXCEPTION
500: WHEN OKL_API.G_EXCEPTION_ERROR THEN
501: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 547: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.VALIDATE_CONTRACT_BALANCE';

543: , p_cblv_rec IN okl_cblv_rec) AS
544: l_api_version CONSTANT NUMBER DEFAULT 1.0;
545: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'VALID_CONTRACT_BAL_REC';
546:
547: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.VALIDATE_CONTRACT_BALANCE';
548: l_debug_enabled VARCHAR2(10);
549:
550: BEGIN
551: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 556: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call validate_contract_balance(REC)');

552:
553: l_debug_enabled := okl_debug_pub.check_log_enabled;
554:
555: IF(NVL(l_debug_enabled,'N')='Y') THEN
556: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call validate_contract_balance(REC)');
557: END IF;
558:
559: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
560: x_return_status := OKL_API.START_ACTIVITY(

Line 584: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

580: p_cblv_rec => p_cblv_rec);
581:
582: -- write to log
583: IF(NVL(l_debug_enabled,'N')='Y') THEN
584: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
585: l_module,
586: 'okl_cbl_pvt.validate_row(rec) returned with status '||x_return_status
587: );
588: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 600: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call validate_contract_balance(REC)');

596: -- commit the savepoint
597: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
598:
599: IF(NVL(l_debug_enabled,'N')='Y') THEN
600: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call validate_contract_balance(REC)');
601: END IF;
602: EXCEPTION
603: WHEN OKL_API.G_EXCEPTION_ERROR THEN
604: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 650: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.VALIDATE_CONTRACT_BALANCE';

646: , p_cblv_tbl IN okl_cblv_tbl) AS
647: l_api_version CONSTANT NUMBER DEFAULT 1.0;
648: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'VALID_CONTRACT_BAL_TBL';
649:
650: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.VALIDATE_CONTRACT_BALANCE';
651: l_debug_enabled VARCHAR2(10);
652:
653: BEGIN
654: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 659: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call validate_contract_balance(TBL)');

655:
656: l_debug_enabled := okl_debug_pub.check_log_enabled;
657:
658: IF(NVL(l_debug_enabled,'N')='Y') THEN
659: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call validate_contract_balance(TBL)');
660: END IF;
661:
662: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
663: x_return_status := OKL_API.START_ACTIVITY(

Line 687: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

683: p_cblv_tbl => p_cblv_tbl);
684:
685: -- write to log
686: IF(NVL(l_debug_enabled,'N')='Y') THEN
687: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
688: l_module,
689: 'okl_cbl_pvt.validate_row(tbl) returned with status '||x_return_status
690: );
691: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 703: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call validate_contract_balance(TBL)');

699: -- commit the savepoint
700: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
701:
702: IF(NVL(l_debug_enabled,'N')='Y') THEN
703: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call validate_contract_balance(TBL)');
704: END IF;
705: EXCEPTION
706: WHEN OKL_API.G_EXCEPTION_ERROR THEN
707: x_return_status := OKL_API.HANDLE_EXCEPTIONS(