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

Line 37: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.create_var_int_params';

33:
34: -- Record/Table Type Declarations
35: l_virv_rec virv_rec_type;
36:
37: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.create_var_int_params';
38: l_debug_enabled VARCHAR2(10);
39:
40: BEGIN
41: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 47: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVISB.pls call create_var_int_params for record');

43: -- check for logging on PROCEDURE level
44: l_debug_enabled := okl_debug_pub.check_log_enabled;
45:
46: IF(NVL(l_debug_enabled,'N')='Y') THEN
47: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVISB.pls call create_var_int_params for record');
48: END IF;
49:
50: -- call START_ACTIVITY to create savepoint, check compatibility
51: -- and initialize message list

Line 79: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

75: ,x_virv_rec => x_virv_rec);
76:
77: -- write to log
78: IF(NVL(l_debug_enabled,'N')='Y') THEN
79: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
80: l_module,
81: 'okl_vir_pvt.insert_row returned with status '||x_return_status||' id '||x_virv_rec.id
82: );
83: END IF;

Line 96: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVISB.pls call create_var_int_params for record');

92: ,x_msg_data => x_msg_data
93: );
94:
95: IF(NVL(l_debug_enabled,'N')='Y') THEN
96: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVISB.pls call create_var_int_params for record');
97: END IF;
98:
99: EXCEPTION
100: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 162: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.create_var_int_params';

158:
159: -- Record/Table Type Declarations
160: l_virv_tbl virv_tbl_type;
161:
162: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.create_var_int_params';
163: l_debug_enabled VARCHAR2(10);
164: is_debug_procedure_on BOOLEAN;
165:
166: BEGIN

Line 173: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVISB.pls call create_var_int_params for table');

169: -- check for logging on PROCEDURE level
170: l_debug_enabled := okl_debug_pub.check_log_enabled;
171:
172: IF(NVL(l_debug_enabled,'N')='Y') THEN
173: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVISB.pls call create_var_int_params for table');
174: END IF;
175:
176: -- call START_ACTIVITY to create savepoint, check compatibility
177: -- and initialize message list

Line 205: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

201: ,x_virv_tbl => x_virv_tbl);
202:
203: -- write to log
204: IF(NVL(l_debug_enabled,'N')='Y') THEN
205: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
206: l_module,
207: 'okl_vir_pvt.insert_row returned with status '||x_return_status
208: );
209: END IF;

Line 222: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVISB.pls call create_var_int_params for table');

218: ,x_msg_data => x_msg_data
219: );
220:
221: IF(NVL(l_debug_enabled,'N')='Y') THEN
222: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVISB.pls call create_var_int_params for table');
223: END IF;
224:
225: EXCEPTION
226: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 287: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';

283:
284: -- Record/Table Type Declarations
285: l_virv_rec virv_rec_type;
286:
287: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';
288: l_debug_enabled VARCHAR2(10);
289:
290: BEGIN
291: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 297: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call update_var_int_params for record');

293: -- check for logging on PROCEDURE level
294: l_debug_enabled := okl_debug_pub.check_log_enabled;
295:
296: IF(NVL(l_debug_enabled,'N')='Y') THEN
297: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call update_var_int_params for record');
298: END IF;
299:
300: -- call START_ACTIVITY to create savepoint, check compatibility
301: -- and initialize message list

Line 327: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

323: ,x_msg_data => x_msg_data
324: ,p_virv_rec => l_virv_rec
325: ,x_virv_rec => x_virv_rec);
326: IF(NVL(l_debug_enabled,'N')='Y') THEN
327: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
328: l_module,'okl_vir_pvt.update_row returned with status '||x_return_status||' id '||x_virv_rec.id
329: );
330: END IF;
331: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

Line 343: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for record');

339: ,x_msg_data => x_msg_data
340: );
341:
342: IF(NVL(l_debug_enabled,'N')='Y') THEN
343: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for record');
344: END IF;
345:
346: EXCEPTION
347: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 407: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';

403:
404: -- Record/Table Type Declarations
405: l_virv_tbl virv_tbl_type;
406:
407: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.update_var_int_params';
408: l_debug_enabled VARCHAR2(10);
409:
410: BEGIN
411: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 417: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call update_var_int_params for table');

413: -- check for logging on PROCEDURE level
414: l_debug_enabled := okl_debug_pub.check_log_enabled;
415:
416: IF(NVL(l_debug_enabled,'N')='Y') THEN
417: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call update_var_int_params for table');
418: END IF;
419:
420: -- call START_ACTIVITY to create savepoint, check compatibility
421: -- and initialize message list

Line 447: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

443: ,x_msg_data => x_msg_data
444: ,p_virv_tbl => l_virv_tbl
445: ,x_virv_tbl => x_virv_tbl);
446: IF(NVL(l_debug_enabled,'N')='Y') THEN
447: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
448: l_module,'okl_vir_pvt.update_row returned with status '||x_return_status
449: );
450: END IF;
451: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

Line 461: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for table');

457: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
458: ,x_msg_data => x_msg_data
459: );
460: IF(NVL(l_debug_enabled,'N')='Y') THEN
461: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call update_var_int_params for table');
462: END IF;
463:
464: EXCEPTION
465: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 525: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.delete_var_int_params';

521:
522: -- Record/Table Type Declarations
523: l_virv_tbl virv_tbl_type;
524:
525: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.delete_var_int_params';
526: l_debug_enabled VARCHAR2(10);
527:
528: BEGIN
529: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 535: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call delete_var_int_params for table');

531: -- check for logging on PROCEDURE level
532: l_debug_enabled := okl_debug_pub.check_log_enabled;
533:
534: IF(NVL(l_debug_enabled,'N')='Y') THEN
535: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call delete_var_int_params for table');
536: END IF;
537:
538: -- call START_ACTIVITY to create savepoint, check compatibility
539: -- and initialize message list

Line 565: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

561: ,x_msg_data => x_msg_data
562: ,p_virv_tbl => l_virv_tbl
563: );
564: IF(NVL(l_debug_enabled,'N')='Y') THEN
565: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
566: l_module,'okl_vir_pvt.delete_row returned with status '||x_return_status
567: );
568: END IF;
569: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

Line 579: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call delete_var_int_params for a table');

575: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
576: ,x_msg_data => x_msg_data
577: );
578: IF(NVL(l_debug_enabled,'N')='Y') THEN
579: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call delete_var_int_params for a table');
580: END IF;
581:
582: EXCEPTION
583: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 643: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.validate_var_int_params';

639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
640:
641: l_virv_rec virv_rec_type;
642:
643: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.validate_var_int_params';
644: l_debug_enabled VARCHAR2(10);
645:
646: Begin
647:

Line 654: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call validate_var_int_params for record');

650: -- check for logging on PROCEDURE level
651: l_debug_enabled := okl_debug_pub.check_log_enabled;
652:
653: IF(NVL(l_debug_enabled,'N')='Y') THEN
654: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call validate_var_int_params for record');
655: END IF;
656:
657: -- call START_ACTIVITY to create savepoint, check compatibility
658: -- and initialize message list

Line 687: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

683: x_msg_data => x_msg_data,
684: p_virv_rec => l_virv_rec);
685:
686: IF(NVL(l_debug_enabled,'N')='Y') THEN
687: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
688: l_module,'okl_vir_pvt.validate_row returned with status '||x_return_status
689: );
690: END IF;
691:

Line 703: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call validate_var_int_params for a record');

699: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
700: 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,'ends debug OKLRVISB.pls call validate_var_int_params for a record');
704: END IF;
705:
706: EXCEPTION
707: when OKL_API.G_EXCEPTION_ERROR then

Line 767: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.validate_var_int_params';

763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
764:
765: l_virv_tbl virv_tbl_type;
766:
767: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VAR_INT_PARAMS_PVT.validate_var_int_params';
768: l_debug_enabled VARCHAR2(10);
769:
770: Begin
771:

Line 778: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call validate_var_int_params for table');

774: -- check for logging on PROCEDURE level
775: l_debug_enabled := okl_debug_pub.check_log_enabled;
776:
777: IF(NVL(l_debug_enabled,'N')='Y') THEN
778: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'start debug OKLRVISB.pls call validate_var_int_params for table');
779: END IF;
780:
781: -- call START_ACTIVITY to create savepoint, check compatibility
782: -- and initialize message list

Line 811: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

807: x_msg_data => x_msg_data,
808: p_virv_tbl => l_virv_tbl);
809:
810: IF(NVL(l_debug_enabled,'N')='Y') THEN
811: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
812: l_module,'okl_vir_pvt.validate_row returned with status '||x_return_status
813: );
814: END IF;
815:

Line 827: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call validate_var_int_params for a table');

823: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
824: x_msg_data => x_msg_data
825: );
826: IF(NVL(l_debug_enabled,'N')='Y') THEN
827: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'ends debug OKLRVISB.pls call validate_var_int_params for a table');
828: END IF;
829:
830: EXCEPTION
831: when OKL_API.G_EXCEPTION_ERROR then