DBA Data[Home] [Help]

APPS.OKL_LEASEAPP_TEMPLATE_PVT dependencies on OKL_LAV_PVT

Line 168: OKL_LAV_PVT.update_row(p_api_version => p_api_version

164: l_latv_rec.template_status := G_STATUS_ACTIVE;
165:
166: l_lavv_rec.id := p_lat_version_id;
167: -- call the TAPI insert_row to update lease application template version
168: OKL_LAV_PVT.update_row(p_api_version => p_api_version
169: ,p_init_msg_list => p_init_msg_list
170: ,x_return_status => l_return_status
171: ,x_msg_count => x_msg_count
172: ,x_msg_data => x_msg_data

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 385: OKL_LAV_PVT.insert_row(p_api_version => p_api_version

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
386: ,p_init_msg_list => p_init_msg_list
387: ,x_return_status => x_return_status
388: ,x_msg_count => x_msg_count
389: ,x_msg_data => x_msg_data

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 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 675: OKL_LAV_PVT.update_row(p_api_version => p_api_version

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
676: ,p_init_msg_list => p_init_msg_list
677: ,x_return_status => x_return_status
678: ,x_msg_count => x_msg_count
679: ,x_msg_data => x_msg_data

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 885: l_lavv_rec_old := okl_lav_pvt.get_rec(p_lavv_rec.id, l_return_status);

881: x_latv_rec := x_latv_rec_new;
882: x_lavv_rec := x_lavv_rec_new;
883: ELSE
884: l_latv_rec_old := okl_lat_pvt.get_rec(p_latv_rec.id, l_return_status);
885: l_lavv_rec_old := okl_lav_pvt.get_rec(p_lavv_rec.id, l_return_status);
886: -- Fetch the Maximum of Start Date of the contracts using this template
887: max_valid_from_date(p_api_version => p_api_version
888: ,p_init_msg_list => p_init_msg_list
889: ,x_return_status => x_return_status

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 988: OKL_LAV_PVT.insert_row(p_api_version => p_api_version

984: RAISE OKL_API.G_EXCEPTION_ERROR;
985: END IF; */
986: --Bug # 5189655 ssdeshpa end
987: -- call the TAPI insert_row to create a lease application template version
988: OKL_LAV_PVT.insert_row(p_api_version => p_api_version
989: ,p_init_msg_list => p_init_msg_list
990: ,x_return_status => x_return_status
991: ,x_msg_count => x_msg_count
992: ,x_msg_data => x_msg_data

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