DBA Data[Home] [Help]

APPS.OKL_LEASEAPP_TEMPLATE_PVT dependencies on OKL_LAT_PVT

Line 188: OKL_LAT_PVT.update_row(p_api_version => p_api_version

184:
185: IF l_chk_vers_sts IS NULL THEN
186:
187: -- call the TAPI update_row to update lease application template
188: OKL_LAT_PVT.update_row(p_api_version => p_api_version
189: ,p_init_msg_list => p_init_msg_list
190: ,x_return_status => l_return_status
191: ,x_msg_count => x_msg_count
192: ,x_msg_data => x_msg_data

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 353: OKL_LAT_PVT.insert_row(p_api_version => p_api_version

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
354: ,p_init_msg_list => p_init_msg_list
355: ,x_return_status => x_return_status
356: ,x_msg_count => x_msg_count
357: ,x_msg_data => x_msg_data

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 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 644: OKL_LAT_PVT.update_row(p_api_version => p_api_version

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
645: ,p_init_msg_list => p_init_msg_list
646: ,x_return_status => x_return_status
647: ,x_msg_count => x_msg_count
648: ,x_msg_data => x_msg_data

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 884: l_latv_rec_old := okl_lat_pvt.get_rec(p_latv_rec.id, l_return_status);

880: END IF;
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

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