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

Line 131: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.activate_lat';

127: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
128: WHERE LAVV.LEASEAPP_TEMPLATE_ID = cp_lat_id
129: AND LAVV.VERSION_STATUS <> G_STATUS_ACTIVE;
130:
131: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.activate_lat';
132: l_debug_enabled VARCHAR2(10);
133: is_debug_procedure_on BOOLEAN;
134: is_debug_statement_on BOOLEAN;
135:

Line 349: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.INSERT_ROW'

345: END IF; */
346: --Bug # 5189655 ssdeshpa end
347:
348: IF(l_debug_enabled='Y') THEN
349: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.INSERT_ROW'
350: ,'begin debug OKLSLATB.pls call insert_row');
351: END IF;
352: -- call the TAPI insert_row to create a lease application template
353: OKL_LAT_PVT.insert_row(p_api_version => p_api_version

Line 361: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.INSERT_ROW'

357: ,x_msg_data => x_msg_data
358: ,p_latv_rec => l_latv_rec
359: ,x_latv_rec => lx_latv_rec);
360: IF(l_debug_enabled='Y') THEN
361: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.INSERT_ROW'
362: ,'end debug OKLSLATB.pls call insert_row');
363: END IF;
364: -- write to log
365: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 366: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAT_PVT.INSERT_ROW',

362: ,'end debug OKLSLATB.pls call insert_row');
363: END IF;
364: -- write to log
365: IF(NVL(l_debug_enabled,'N')='Y') THEN
366: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAT_PVT.INSERT_ROW',
367: ' l_latv_name ' || l_latv_rec.NAME ||
368: ' expiring lease application template with ret status ' || x_return_status ||
369: ' x_msg_data ' || x_msg_data);
370: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 381: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.INSERT_ROW'

377:
378: l_lavv_rec.LEASEAPP_TEMPLATE_ID := lx_latv_rec.ID;
379:
380: IF(l_debug_enabled='Y') THEN
381: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.INSERT_ROW'
382: ,'begin debug OKLSLAVB.pls call insert_row');
383: END IF;
384: -- call the TAPI insert_row to create a lease application template version details
385: OKL_LAV_PVT.insert_row(p_api_version => p_api_version

Line 393: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.INSERT_ROW'

389: ,x_msg_data => x_msg_data
390: ,p_lavv_rec => l_lavv_rec
391: ,x_lavv_rec => lx_lavv_rec);
392: IF(l_debug_enabled='Y') THEN
393: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.INSERT_ROW'
394: ,'end debug OKLSLAVB.pls call insert_row');
395: END IF;
396: -- write to log
397: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 398: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAV_PVT.INSERT_ROW',

394: ,'end debug OKLSLAVB.pls call insert_row');
395: END IF;
396: -- write to log
397: IF(NVL(l_debug_enabled,'N')='Y') THEN
398: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAV_PVT.INSERT_ROW',
399: 'l_lavv_rec.version_number '||to_char(l_lavv_rec.version_number)||
400: 'l_lavv_rec.version_status '||l_lavv_rec.version_status||
401: ' expiring lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
402: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 640: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.UPADTE_ROW'

636: END IF;
637:
638: IF ((l_latv_rec.ID IS NOT NULL OR l_latv_rec.id <> OKL_API.G_MISS_NUM)) THEN
639: IF(l_debug_enabled='Y') THEN
640: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.UPADTE_ROW'
641: ,'begin debug OKLSLATB.pls call upadte_row');
642: END IF;
643: -- call the TAPI update_row to create a lease application template
644: OKL_LAT_PVT.update_row(p_api_version => p_api_version

Line 652: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.UPADTE_ROW'

648: ,x_msg_data => x_msg_data
649: ,p_latv_rec => l_latv_rec
650: ,x_latv_rec => lx_latv_rec);
651: IF(l_debug_enabled='Y') THEN
652: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.UPADTE_ROW'
653: ,'end debug OKLSLATB.pls call upadte_row');
654: END IF;
655: -- write to log
656: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 657: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAT_PVT.UPDATE_ROW',

653: ,'end debug OKLSLATB.pls call upadte_row');
654: END IF;
655: -- write to log
656: IF(NVL(l_debug_enabled,'N')='Y') THEN
657: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAT_PVT.UPDATE_ROW',
658: 'l_latv_name '||l_latv_rec.NAME
659: ||'lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
660: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
661:

Line 671: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.UPADTE_ROW'

667: END IF;
668:
669: IF ((l_lavv_rec.ID IS NOT NULL OR l_lavv_rec.id <> OKL_API.G_MISS_NUM)) THEN
670: IF(l_debug_enabled='Y') THEN
671: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.UPADTE_ROW'
672: ,'begin debug OKLSLAVB.pls call upadte_row');
673: END IF;
674: -- call the TAPI insert_row to create a lease application template
675: OKL_LAV_PVT.update_row(p_api_version => p_api_version

Line 683: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.UPADTE_ROW'

679: ,x_msg_data => x_msg_data
680: ,p_lavv_rec => l_lavv_rec
681: ,x_lavv_rec => lx_lavv_rec);
682: IF(l_debug_enabled='Y') THEN
683: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.UPADTE_ROW'
684: ,'end debug OKLSLAVB.pls call upadte_row');
685: END IF;
686: -- write to log
687: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 688: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAV_PVT.UPDATE_ROW',

684: ,'end debug OKLSLAVB.pls call upadte_row');
685: END IF;
686: -- write to log
687: IF(NVL(l_debug_enabled,'N')='Y') THEN
688: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAV_PVT.UPDATE_ROW',
689: 'l_lavv_rec.version_number '||to_char(l_lavv_rec.version_number) ||'l_lavv_rec.version_status '
690: ||l_lavv_rec.version_status
691: ||'lease application template with ret status '||x_return_status||'x_msg_data '||x_msg_data);
692: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 852: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.create_leaseapp_template'

848: l_latv_rec_new.valid_to := l_lavv_rec_new.valid_to;
849: l_latv_rec_new.template_status := l_lavv_rec_new.version_status;
850:
851: IF(l_debug_enabled='Y') THEN
852: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.create_leaseapp_template'
853: ,'begin debug OKLRLATB.pls call create_leaseapp_template');
854: END IF;
855: -- call the APLI to create a lease application template
856: create_leaseapp_template(p_api_version => p_api_version

Line 866: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.create_leaseapp_template'

862: ,x_latv_rec => x_latv_rec_new
863: ,p_lavv_rec => l_lavv_rec_new
864: ,x_lavv_rec => x_lavv_rec_new);
865: IF(l_debug_enabled='Y') THEN
866: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.create_leaseapp_template'
867: ,'begin debug OKLRLATB.pls call create_leaseapp_template');
868: END IF;
869: -- write to log
870: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 871: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.create_leaseapp_template',

867: ,'begin debug OKLRLATB.pls call create_leaseapp_template');
868: END IF;
869: -- write to log
870: IF(NVL(l_debug_enabled,'N')='Y') THEN
871: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.create_leaseapp_template',
872: ' l_latv_name '||l_latv_rec_new.NAME ||
873: ' expiring lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data );
874: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
875:

Line 918: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.UPADTE_ROW'

914: l_lavv_rec_old.valid_from := r_actver_dates_rec.valid_from;
915: END LOOP;
916: --asawanka bug 4966317 fix ends
917: IF(l_debug_enabled='Y') THEN
918: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAT_PVT.UPADTE_ROW'
919: ,'begin debug OKLSLATB.pls call upadte_row');
920: END IF;
921:
922: IF(l_debug_enabled='Y') THEN

Line 923: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.update_leaseapp_template'

919: ,'begin debug OKLSLATB.pls call upadte_row');
920: END IF;
921:
922: IF(l_debug_enabled='Y') THEN
923: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.update_leaseapp_template'
924: ,'end debug OKLRLATB.pls call update_leaseapp_template');
925: END IF;
926: --Begin- varangan-bug#4684557 - Version From date validation
927: l_lavv_rec_old.valid_from:=TRUNC(l_lavv_rec_old.valid_from);

Line 945: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.update_leaseapp_template'

941: ,p_lavv_rec => l_lavv_rec_old
942: ,x_lavv_rec => x_lavv_rec_old
943: ,p_ident_flag => 'V');
944: IF(l_debug_enabled='Y') THEN
945: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.update_leaseapp_template'
946: ,'end debug OKLRLATB.pls call update_leaseapp_template');
947: END IF;
948: -- write to log
949: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 950: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.update_leaseapp_template',

946: ,'end debug OKLRLATB.pls call update_leaseapp_template');
947: END IF;
948: -- write to log
949: IF(NVL(l_debug_enabled,'N')='Y') THEN
950: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.update_leaseapp_template',
951: 'l_latv_name '||l_latv_rec_old.NAME ||
952: 'lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
953: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
954: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

Line 967: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.INSERT_ROW'

963: l_lavv_rec_new.version_status := G_INIT_TMPLT_STATUS; -- Make the New Template Status to NEW
964: l_lavv_rec_new.leaseapp_template_id := l_latv_rec_old.ID;
965:
966: IF(l_debug_enabled='Y') THEN
967: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.INSERT_ROW'
968: ,'begin debug OKLSLAVB.pls call insert_row');
969: END IF;
970:
971: --Begin- varangan-bug#4684557 - Version From date validation

Line 996: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.INSERT_ROW'

992: ,x_msg_data => x_msg_data
993: ,p_lavv_rec => l_lavv_rec_new
994: ,x_lavv_rec => x_lavv_rec_new);
995: IF(l_debug_enabled='Y') THEN
996: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LAV_PVT.INSERT_ROW'
997: ,'end debug OKLSLAVB.pls call insert_row');
998: END IF;
999: -- write to log
1000: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 1001: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAT_PVT.INSERT_ROW',

997: ,'end debug OKLSLAVB.pls call insert_row');
998: END IF;
999: -- write to log
1000: IF(NVL(l_debug_enabled,'N')='Y') THEN
1001: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,'okl.plsql.OKL_LAT_PVT.INSERT_ROW',
1002: ' l_latv_name '||l_latv_rec_old.NAME ||
1003: ' expiring lease application template with ret status '||x_return_status||' x_msg_data '||x_msg_data);
1004: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1005: