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