APPS.OKL_LEASEAPP_TEMPLATE_PVT dependencies on OKL_LEASEAPP_TEMPLATE_PVT

Line 1: PACKAGE BODY OKL_LEASEAPP_TEMPLATE_PVT AS

1: PACKAGE BODY OKL_LEASEAPP_TEMPLATE_PVT AS
2: /* $Header: OKLRLATB.pls 120.21.12010000.2 2008/12/20 01:37:21 smereddy ship $ */
3:
4: -- bug 4741121 - smadhava - Modified - Start
5: G_PROF_FE_APPROVAL_PROCESS CONSTANT VARCHAR2(30) := 'OKL_SO_APPROVAL_PROCESS';

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 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 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 1524: END OKL_LEASEAPP_TEMPLATE_PVT;

1520: x_msg_data => x_msg_data,
1521: p_api_type => g_api_type);
1522: END max_valid_from_date;
1523:
1524: END OKL_LEASEAPP_TEMPLATE_PVT;