DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_PVT dependencies on OCM_CREDIT_REQUEST_UPDATE_PUB

Line 3653: l_credit_request_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;

3649: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.saved';
3650: -- Bug#4741121 - viselvar - Modified - Start
3651:
3652: --asawanka Bug 4865418 changes start
3653: l_credit_request_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;
3654: --asawanka Bug 4865418 changes end
3655: --Cursor to obtain the details of lease quote line of Lease App
3656: CURSOR l_lsq_dtls_csr(p_lap_id NUMBER)
3657: IS

Line 4012: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');

4008: THEN
4009: OKL_DEBUG_PUB.LOG_DEBUG(
4010: FND_LOG.LEVEL_PROCEDURE
4011: ,L_MODULE
4012: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');
4013: END IF;
4014: --get the existing credit request data
4015: OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(
4016: p_credit_request_id => get_crd_app_data_rec.credit_request_id

Line 4015: OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(

4011: ,L_MODULE
4012: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');
4013: END IF;
4014: --get the existing credit request data
4015: OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(
4016: p_credit_request_id => get_crd_app_data_rec.credit_request_id
4017: ,p_return_status => l_return_status
4018: ,p_error_msg => x_msg_data
4019: ,p_credit_request_rec => l_credit_request_rec);

Line 4026: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');

4022: THEN
4023: OKL_DEBUG_PUB.LOG_DEBUG(
4024: FND_LOG.LEVEL_PROCEDURE
4025: ,L_MODULE
4026: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');
4027: END IF;
4028:
4029: -- write to log
4030: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN

Line 4033: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC'

4029: -- write to log
4030: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
4031: OKL_DEBUG_PUB.LOG_DEBUG(
4032: FND_LOG.LEVEL_STATEMENT
4033: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC'
4034: ,' result status ' || l_return_status);
4035: END IF; -- end of statement level debug
4036:
4037: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

Line 4055: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');

4051: THEN
4052: OKL_DEBUG_PUB.LOG_DEBUG(
4053: FND_LOG.LEVEL_PROCEDURE
4054: ,L_MODULE
4055: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');
4056: END IF;
4057: --update the credit application data
4058: OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(
4059: p_api_version => l_api_version,

Line 4058: OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(

4054: ,L_MODULE
4055: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');
4056: END IF;
4057: --update the credit application data
4058: OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(
4059: p_api_version => l_api_version,
4060: p_init_msg_list => OKL_API.G_FALSE,
4061: p_commit => NULL,
4062: p_validation_level => NULL,

Line 4073: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');

4069: THEN
4070: OKL_DEBUG_PUB.LOG_DEBUG(
4071: FND_LOG.LEVEL_PROCEDURE
4072: ,L_MODULE
4073: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');
4074: END IF;
4075:
4076: -- write to log
4077: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN

Line 4080: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST'

4076: -- write to log
4077: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
4078: OKL_DEBUG_PUB.LOG_DEBUG(
4079: FND_LOG.LEVEL_STATEMENT
4080: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST'
4081: ,' result status ' || l_return_status);
4082: END IF; -- end of statement level debug
4083:
4084: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

Line 6576: l_crd_req_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;

6572: -- Record/Table Type Declarations
6573: l_lapv_rec lapv_rec_type;
6574: l_lsqv_rec lsqv_rec_type;
6575: x_lsqv_rec lsqv_rec_type;
6576: l_crd_req_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;
6577: -- Bug#4741121 - viselvar - Modified - Start
6578: l_parameter_list wf_parameter_list_t;
6579: p_event_name VARCHAR2(240) :='oracle.apps.okl.sales.leaseapplication.submitted_for_credit_evaluation';
6580: -- Bug#4741121 - viselvar - Modified - End

Line 6825: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');

6821: THEN
6822: OKL_DEBUG_PUB.LOG_DEBUG(
6823: FND_LOG.LEVEL_PROCEDURE
6824: ,L_MODULE
6825: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');
6826: END IF;
6827: --get the existing credit request data
6828: OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(
6829: p_credit_request_id => acr_dtls_rec.credit_request_id

Line 6828: OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(

6824: ,L_MODULE
6825: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');
6826: END IF;
6827: --get the existing credit request data
6828: OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(
6829: p_credit_request_id => acr_dtls_rec.credit_request_id
6830: ,p_return_status => l_return_status
6831: ,p_error_msg => x_msg_data
6832: ,p_credit_request_rec => l_crd_req_rec);

Line 6839: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');

6835: THEN
6836: OKL_DEBUG_PUB.LOG_DEBUG(
6837: FND_LOG.LEVEL_PROCEDURE
6838: ,L_MODULE
6839: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC');
6840: END IF;
6841:
6842: -- write to log
6843: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN

Line 6846: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC'

6842: -- write to log
6843: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
6844: OKL_DEBUG_PUB.LOG_DEBUG(
6845: FND_LOG.LEVEL_STATEMENT
6846: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC'
6847: ,' result status ' || l_return_status);
6848: END IF; -- end of statement level debug
6849:
6850: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

Line 6865: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');

6861: THEN
6862: OKL_DEBUG_PUB.LOG_DEBUG(
6863: FND_LOG.LEVEL_PROCEDURE
6864: ,L_MODULE
6865: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');
6866: END IF;
6867: --update the credit application data
6868: OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(
6869: p_api_version => l_api_version,

Line 6868: OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(

6864: ,L_MODULE
6865: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');
6866: END IF;
6867: --update the credit application data
6868: OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(
6869: p_api_version => l_api_version,
6870: p_init_msg_list => OKL_API.G_FALSE,
6871: p_commit => NULL,
6872: p_validation_level => NULL,

Line 6883: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');

6879: THEN
6880: OKL_DEBUG_PUB.LOG_DEBUG(
6881: FND_LOG.LEVEL_PROCEDURE
6882: ,L_MODULE
6883: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST');
6884: END IF;
6885:
6886: -- write to log
6887: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN

Line 6890: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST'

6886: -- write to log
6887: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
6888: OKL_DEBUG_PUB.LOG_DEBUG(
6889: FND_LOG.LEVEL_STATEMENT
6890: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST'
6891: ,' result status ' || l_return_status);
6892: END IF; -- end of statement level debug
6893:
6894: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

Line 6938: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS');

6934: THEN
6935: OKL_DEBUG_PUB.LOG_DEBUG(
6936: FND_LOG.LEVEL_PROCEDURE
6937: ,L_MODULE
6938: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS');
6939: END IF;
6940:
6941: OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS(
6942: p_api_version => l_api_version

Line 6941: OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS(

6937: ,L_MODULE
6938: ,'begin debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS');
6939: END IF;
6940:
6941: OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS(
6942: p_api_version => l_api_version
6943: ,p_init_msg_list => OKL_API.G_FALSE
6944: ,p_commit => OKL_API.G_FALSE
6945: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 6957: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS');

6953: THEN
6954: OKL_DEBUG_PUB.LOG_DEBUG(
6955: FND_LOG.LEVEL_PROCEDURE
6956: ,L_MODULE
6957: ,'end debug call OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS');
6958: END IF;
6959:
6960: -- write to log
6961: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN

Line 6964: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS'

6960: -- write to log
6961: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
6962: OKL_DEBUG_PUB.LOG_DEBUG(
6963: FND_LOG.LEVEL_STATEMENT
6964: ,L_MODULE || ' Result of OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST_STATUS'
6965: ,'l_return_status ' || l_return_status);
6966: END IF; -- end of statement level debug
6967:
6968: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN