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;
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
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;
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
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;
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
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;
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
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;
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
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
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
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;
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
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
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
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;
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
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
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
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;
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
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:
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
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;
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
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:
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