DBA Data[Home] [Help]

APPS.OKL_VAR_INT_PARAMS_PVT dependencies on OKL_DEBUG_PUB

Line 44: l_debug_enabled := okl_debug_pub.check_log_enabled;

40: BEGIN
41: x_return_status := OKL_API.G_RET_STS_SUCCESS;
42:
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;

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 170: l_debug_enabled := okl_debug_pub.check_log_enabled;

166: BEGIN
167: x_return_status := OKL_API.G_RET_STS_SUCCESS;
168:
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;

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 294: l_debug_enabled := okl_debug_pub.check_log_enabled;

290: BEGIN
291: x_return_status := OKL_API.G_RET_STS_SUCCESS;
292:
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;

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 414: l_debug_enabled := okl_debug_pub.check_log_enabled;

410: BEGIN
411: x_return_status := OKL_API.G_RET_STS_SUCCESS;
412:
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;

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 532: l_debug_enabled := okl_debug_pub.check_log_enabled;

528: BEGIN
529: x_return_status := OKL_API.G_RET_STS_SUCCESS;
530:
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;

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 651: l_debug_enabled := okl_debug_pub.check_log_enabled;

647:
648: x_return_status := OKL_API.G_RET_STS_SUCCESS;
649:
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;

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 775: l_debug_enabled := okl_debug_pub.check_log_enabled;

771:
772: x_return_status := OKL_API.G_RET_STS_SUCCESS;
773:
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;

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