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_INS_QUOTE_PVT dependencies on OKL_INS_POLICIES_PUB

Line 125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

121: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
122: END IF;
123: IF(IS_DEBUG_PROCEDURE_ON) THEN
124: BEGIN
125: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
126: END;
127: END IF;
128: -- Payment Call Temp
129:

Line 130: Okl_Ins_Policies_Pub.insert_ins_policies(

126: END;
127: END IF;
128: -- Payment Call Temp
129:
130: Okl_Ins_Policies_Pub.insert_ins_policies(
131: p_api_version => l_api_version,
132: p_init_msg_list => OKC_API.G_FALSE,
133: x_return_status => l_return_status,
134: x_msg_count => x_msg_count,

Line 143: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

139:
140:
141: IF(IS_DEBUG_PROCEDURE_ON) THEN
142: BEGIN
143: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
144: END;
145: END IF;
146:
147:

Line 263: ,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies');

259: BEGIN
260: OKL_DEBUG_PUB.LOG_DEBUG(
261: L_LEVEL_PROCEDURE
262: ,L_MODULE
263: ,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies');
264: END;
265: END IF;
266: Okl_Ins_Policies_Pub.insert_ins_policies(
267: p_api_version => l_api_version,

Line 266: Okl_Ins_Policies_Pub.insert_ins_policies(

262: ,L_MODULE
263: ,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies');
264: END;
265: END IF;
266: Okl_Ins_Policies_Pub.insert_ins_policies(
267: p_api_version => l_api_version,
268: p_init_msg_list => OKL_API.G_FALSE,
269: x_return_status => l_return_status,
270: x_msg_count => x_msg_count,

Line 280: ,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies');

276: BEGIN
277: OKL_DEBUG_PUB.LOG_DEBUG(
278: L_LEVEL_PROCEDURE
279: ,L_MODULE
280: ,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies');
281: END;
282: END IF;
283: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
284: THEN

Line 491: ,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies');

487: BEGIN
488: OKL_DEBUG_PUB.LOG_DEBUG(
489: L_LEVEL_PROCEDURE
490: ,L_MODULE
491: ,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies');
492: END;
493: END IF;
494: IF l_ipyv_rec.id IS NOT NULL THEN
495: Okl_Ins_Policies_Pub.update_ins_policies(

Line 495: Okl_Ins_Policies_Pub.update_ins_policies(

491: ,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies');
492: END;
493: END IF;
494: IF l_ipyv_rec.id IS NOT NULL THEN
495: Okl_Ins_Policies_Pub.update_ins_policies(
496: p_api_version => l_api_version,
497: p_init_msg_list => OKL_API.G_FALSE,
498: x_return_status => l_return_status,
499: x_msg_count => x_msg_count,

Line 509: ,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies');

505: BEGIN
506: OKL_DEBUG_PUB.LOG_DEBUG(
507: L_LEVEL_PROCEDURE
508: ,L_MODULE
509: ,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies');
510: END;
511: END IF;
512: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
513: THEN

Line 3639: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies

3635: -- Make Policy related changes
3636: l_ipyv_rec := get_lease_policy(l_inqv_rec);
3637:
3638: -- Insert Policy
3639: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3640: IF(IS_DEBUG_PROCEDURE_ON) THEN
3641: BEGIN
3642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3643: END;

Line 3642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

3638: -- Insert Policy
3639: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3640: IF(IS_DEBUG_PROCEDURE_ON) THEN
3641: BEGIN
3642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3643: END;
3644: END IF;
3645: Okl_Ins_Policies_Pub.insert_ins_policies(
3646: p_api_version => p_api_version,

Line 3645: Okl_Ins_Policies_Pub.insert_ins_policies(

3641: BEGIN
3642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3643: END;
3644: END IF;
3645: Okl_Ins_Policies_Pub.insert_ins_policies(
3646: p_api_version => p_api_version,
3647: p_init_msg_list => OKC_API.G_FALSE,
3648: x_return_status => l_return_status,
3649: x_msg_count => x_msg_count,

Line 3656: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

3652: x_ipyv_rec => lx_ipyv_rec
3653: );
3654: IF(IS_DEBUG_PROCEDURE_ON) THEN
3655: BEGIN
3656: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3657: END;
3658: END IF;
3659: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3660:

Line 3659: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies

3655: BEGIN
3656: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3657: END;
3658: END IF;
3659: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3660:
3661: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3662: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3663: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3723: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

3719: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3720: RAISE OKC_API.G_EXCEPTION_ERROR;
3721: END IF;
3722:
3723: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3724: IF(IS_DEBUG_PROCEDURE_ON) THEN
3725: BEGIN
3726: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3727: END;

Line 3726: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

3722:
3723: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3724: IF(IS_DEBUG_PROCEDURE_ON) THEN
3725: BEGIN
3726: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3727: END;
3728: END IF;
3729: Okl_Ins_Policies_Pub.update_ins_policies(
3730: p_api_version => p_api_version,

Line 3729: Okl_Ins_Policies_Pub.update_ins_policies(

3725: BEGIN
3726: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3727: END;
3728: END IF;
3729: Okl_Ins_Policies_Pub.update_ins_policies(
3730: p_api_version => p_api_version,
3731: p_init_msg_list => OKC_API.G_FALSE,
3732: x_return_status => l_return_status,
3733: x_msg_count => x_msg_count,

Line 3740: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

3736: x_ipyv_rec => lx_ipyv_rec
3737: );
3738: IF(IS_DEBUG_PROCEDURE_ON) THEN
3739: BEGIN
3740: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3741: END;
3742: END IF;
3743: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3744: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3743: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

3739: BEGIN
3740: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3741: END;
3742: END IF;
3743: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3744: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3745:
3746: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3747: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3778: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

3774:
3775: -- update quote
3776: -- Put Policy Number in Quote record
3777: l_inqv_rec.IPY_ID := lx_ipyv_rec.ID;
3778: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3779: IF(IS_DEBUG_PROCEDURE_ON) THEN
3780: BEGIN
3781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3782: END;

Line 3781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

3777: l_inqv_rec.IPY_ID := lx_ipyv_rec.ID;
3778: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3779: IF(IS_DEBUG_PROCEDURE_ON) THEN
3780: BEGIN
3781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3782: END;
3783: END IF;
3784: Okl_Ins_Policies_Pub.update_ins_policies(
3785: p_api_version => p_api_version,

Line 3784: Okl_Ins_Policies_Pub.update_ins_policies(

3780: BEGIN
3781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3782: END;
3783: END IF;
3784: Okl_Ins_Policies_Pub.update_ins_policies(
3785: p_api_version => p_api_version,
3786: p_init_msg_list => OKC_API.G_FALSE,
3787: x_return_status => l_return_status,
3788: x_msg_count => x_msg_count,

Line 3794: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

3790: p_ipyv_rec => l_inqv_rec,
3791: x_ipyv_rec => lx_inqv_rec );
3792: IF(IS_DEBUG_PROCEDURE_ON) THEN
3793: BEGIN
3794: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3795: END;
3796: END IF;
3797: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3798:

Line 3797: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

3793: BEGIN
3794: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
3795: END;
3796: END IF;
3797: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
3798:
3799: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3800:
3801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3857: l_ipyv_rec Okl_Ins_Policies_Pub.ipyv_rec_type ;

3853: l_api_version CONSTANT NUMBER := 1;
3854: l_api_name CONSTANT VARCHAR2(30) := 'save_quote';
3855: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3856: p_contract_id NUMBER ;
3857: l_ipyv_rec Okl_Ins_Policies_Pub.ipyv_rec_type ;
3858: lx_ipyv_rec Okl_Ins_Policies_Pub.ipyv_rec_type ;
3859: l_iasset_tbl iasset_tbl_type ;
3860: l_message VARCHAR2(200);
3861: l_inav_tbl Okl_Ina_Pvt.inav_tbl_type;

Line 3858: lx_ipyv_rec Okl_Ins_Policies_Pub.ipyv_rec_type ;

3854: l_api_name CONSTANT VARCHAR2(30) := 'save_quote';
3855: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3856: p_contract_id NUMBER ;
3857: l_ipyv_rec Okl_Ins_Policies_Pub.ipyv_rec_type ;
3858: lx_ipyv_rec Okl_Ins_Policies_Pub.ipyv_rec_type ;
3859: l_iasset_tbl iasset_tbl_type ;
3860: l_message VARCHAR2(200);
3861: l_inav_tbl Okl_Ina_Pvt.inav_tbl_type;
3862: lx_inav_tbl Okl_Ina_Pvt.inav_tbl_type;

Line 3923: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies

3919: l_ipyv_rec.ADJUSTMENT := 0 ;
3920: END IF;
3921: l_ipyv_rec.PREMIUM := l_ipyv_rec.CALCULATED_PREMIUM + l_ipyv_rec.ADJUSTMENT ;
3922: x_message := px_ipyv_rec.ADJUSTMENT;
3923: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3924: IF(L_DEBUG_ENABLED='Y') THEN
3925: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3926: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3927: END IF;

Line 3930: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

3926: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3927: END IF;
3928: IF(IS_DEBUG_PROCEDURE_ON) THEN
3929: BEGIN
3930: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3931: END;
3932: END IF;
3933: Okl_Ins_Policies_Pub.insert_ins_policies(
3934: p_api_version => l_api_version,

Line 3933: Okl_Ins_Policies_Pub.insert_ins_policies(

3929: BEGIN
3930: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3931: END;
3932: END IF;
3933: Okl_Ins_Policies_Pub.insert_ins_policies(
3934: p_api_version => l_api_version,
3935: p_init_msg_list => OKC_API.G_FALSE,
3936: x_return_status => l_return_status,
3937: x_msg_count => x_msg_count,

Line 3944: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

3940: x_ipyv_rec => lx_ipyv_rec
3941: );
3942: IF(IS_DEBUG_PROCEDURE_ON) THEN
3943: BEGIN
3944: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3945: END;
3946: END IF;
3947: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3948:

Line 3947: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies

3943: BEGIN
3944: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
3945: END;
3946: END IF;
3947: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
3948:
3949: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3950: x_return_status := l_return_status ;
3951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4011: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies

4007: END IF;
4008: l_ipyv_rec.PREMIUM := l_ipyv_rec.CALCULATED_PREMIUM + l_ipyv_rec.ADJUSTMENT ;
4009:
4010: x_message := px_ipyv_rec.ADJUSTMENT;
4011: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
4012: IF(IS_DEBUG_PROCEDURE_ON) THEN
4013: BEGIN
4014: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
4015: END;

Line 4014: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

4010: x_message := px_ipyv_rec.ADJUSTMENT;
4011: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
4012: IF(IS_DEBUG_PROCEDURE_ON) THEN
4013: BEGIN
4014: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
4015: END;
4016: END IF;
4017: Okl_Ins_Policies_Pub.insert_ins_policies(
4018: p_api_version => l_api_version,

Line 4017: Okl_Ins_Policies_Pub.insert_ins_policies(

4013: BEGIN
4014: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
4015: END;
4016: END IF;
4017: Okl_Ins_Policies_Pub.insert_ins_policies(
4018: p_api_version => l_api_version,
4019: p_init_msg_list => OKC_API.G_FALSE,
4020: x_return_status => l_return_status,
4021: x_msg_count => x_msg_count,

Line 4028: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

4024: x_ipyv_rec => lx_ipyv_rec
4025: );
4026: IF(IS_DEBUG_PROCEDURE_ON) THEN
4027: BEGIN
4028: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
4029: END;
4030: END IF;
4031: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
4032:

Line 4031: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies

4027: BEGIN
4028: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
4029: END;
4030: END IF;
4031: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
4032:
4033: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4034: x_return_status := l_return_status ;
4035: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5947: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

5943: RAISE OKC_API.G_EXCEPTION_ERROR;
5944: END IF;
5945: l_ipyv_rec.ISS_CODE := 'PENDING' ;
5946:
5947: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
5948: IF(IS_DEBUG_PROCEDURE_ON) THEN
5949: BEGIN
5950: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
5951: END;

Line 5950: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

5946:
5947: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
5948: IF(IS_DEBUG_PROCEDURE_ON) THEN
5949: BEGIN
5950: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
5951: END;
5952: END IF;
5953: Okl_Ins_Policies_Pub.update_ins_policies(
5954: p_api_version => p_api_version,

Line 5953: Okl_Ins_Policies_Pub.update_ins_policies(

5949: BEGIN
5950: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
5951: END;
5952: END IF;
5953: Okl_Ins_Policies_Pub.update_ins_policies(
5954: p_api_version => p_api_version,
5955: p_init_msg_list => OKC_API.G_FALSE,
5956: x_return_status => l_return_status,
5957: x_msg_count => x_msg_count,

Line 5964: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

5960: x_ipyv_rec => lx_ipyv_rec
5961: );
5962: IF(IS_DEBUG_PROCEDURE_ON) THEN
5963: BEGIN
5964: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
5965: END;
5966: END IF;
5967: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
5968:

Line 5967: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

5963: BEGIN
5964: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
5965: END;
5966: END IF;
5967: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
5968:
5969: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5970: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5971: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 6372: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

6368: END IF;
6369: l_ipyv_rec := p_ipyv_rec ;
6370: l_ipyv_rec.ISS_CODE := 'PENDING' ;
6371:
6372: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
6373: IF(IS_DEBUG_PROCEDURE_ON) THEN
6374: BEGIN
6375: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
6376: END;

Line 6375: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

6371:
6372: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
6373: IF(IS_DEBUG_PROCEDURE_ON) THEN
6374: BEGIN
6375: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
6376: END;
6377: END IF;
6378: Okl_Ins_Policies_Pub.update_ins_policies(
6379: p_api_version => p_api_version,

Line 6378: Okl_Ins_Policies_Pub.update_ins_policies(

6374: BEGIN
6375: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
6376: END;
6377: END IF;
6378: Okl_Ins_Policies_Pub.update_ins_policies(
6379: p_api_version => p_api_version,
6380: p_init_msg_list => OKC_API.G_FALSE,
6381: x_return_status => l_return_status,
6382: x_msg_count => x_msg_count,

Line 6389: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

6385: x_ipyv_rec => lx_ipyv_rec
6386: );
6387: IF(IS_DEBUG_PROCEDURE_ON) THEN
6388: BEGIN
6389: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
6390: END;
6391: END IF;
6392: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
6393:

Line 6392: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

6388: BEGIN
6389: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
6390: END;
6391: END IF;
6392: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
6393:
6394: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6395: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6396: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 7093: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

7089:
7090: -------- Activate Policy
7091: l_ipyv_rec.ISS_CODE := 'ACTIVE' ;
7092: l_ipyv_rec.ACTIVATION_DATE := SYSDATE ;
7093: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7094: IF(IS_DEBUG_PROCEDURE_ON) THEN
7095: BEGIN
7096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7097: END;

Line 7096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

7092: l_ipyv_rec.ACTIVATION_DATE := SYSDATE ;
7093: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7094: IF(IS_DEBUG_PROCEDURE_ON) THEN
7095: BEGIN
7096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7097: END;
7098: END IF;
7099: Okl_Ins_Policies_Pub.update_ins_policies(
7100: p_api_version => p_api_version,

Line 7099: Okl_Ins_Policies_Pub.update_ins_policies(

7095: BEGIN
7096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7097: END;
7098: END IF;
7099: Okl_Ins_Policies_Pub.update_ins_policies(
7100: p_api_version => p_api_version,
7101: p_init_msg_list => OKC_API.G_FALSE,
7102: x_return_status => l_return_status,
7103: x_msg_count => x_msg_count,

Line 7109: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

7105: p_ipyv_rec => l_ipyv_rec,
7106: x_ipyv_rec => lx_ipyv_rec );
7107: IF(IS_DEBUG_PROCEDURE_ON) THEN
7108: BEGIN
7109: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7110: END;
7111: END IF;
7112: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7113:

Line 7112: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

7108: BEGIN
7109: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7110: END;
7111: END IF;
7112: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7113:
7114: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7116: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 7540: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies

7536: -- Check for Third Party is taken care in deciding policy type
7537: -- Make Policy related changes
7538: l_ipyv_rec := get_optional_policy(l_inqv_rec);
7539: -- Insert Policy
7540: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
7541: IF(L_DEBUG_ENABLED='Y') THEN
7542: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
7543: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7544: END IF;

Line 7547: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

7543: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7544: END IF;
7545: IF(IS_DEBUG_PROCEDURE_ON) THEN
7546: BEGIN
7547: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7548: END;
7549: END IF;
7550: Okl_Ins_Policies_Pub.insert_ins_policies(
7551: p_api_version => p_api_version,

Line 7550: Okl_Ins_Policies_Pub.insert_ins_policies(

7546: BEGIN
7547: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7548: END;
7549: END IF;
7550: Okl_Ins_Policies_Pub.insert_ins_policies(
7551: p_api_version => p_api_version,
7552: p_init_msg_list => OKC_API.G_FALSE,
7553: x_return_status => l_return_status,
7554: x_msg_count => x_msg_count,

Line 7561: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');

7557: x_ipyv_rec => lx_ipyv_rec
7558: );
7559: IF(IS_DEBUG_PROCEDURE_ON) THEN
7560: BEGIN
7561: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7562: END;
7563: END IF;
7564: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
7565: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 7564: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies

7560: BEGIN
7561: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7562: END;
7563: END IF;
7564: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
7565: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7567: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7568: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 7665: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

7661: -----
7662: -- update quote
7663: -- Put Policy Number in Quote record
7664: l_inqv_rec.IPY_ID := l_ipyv_rec.ID;
7665: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7666: IF(IS_DEBUG_PROCEDURE_ON) THEN
7667: BEGIN
7668: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7669: END;

Line 7668: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

7664: l_inqv_rec.IPY_ID := l_ipyv_rec.ID;
7665: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7666: IF(IS_DEBUG_PROCEDURE_ON) THEN
7667: BEGIN
7668: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7669: END;
7670: END IF;
7671: Okl_Ins_Policies_Pub.update_ins_policies(
7672: p_api_version => p_api_version,

Line 7671: Okl_Ins_Policies_Pub.update_ins_policies(

7667: BEGIN
7668: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7669: END;
7670: END IF;
7671: Okl_Ins_Policies_Pub.update_ins_policies(
7672: p_api_version => p_api_version,
7673: p_init_msg_list => OKC_API.G_FALSE,
7674: x_return_status => l_return_status,
7675: x_msg_count => x_msg_count,

Line 7682: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');

7678: x_ipyv_rec => lx_inqv_rec
7679: );
7680: IF(IS_DEBUG_PROCEDURE_ON) THEN
7681: BEGIN
7682: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7683: END;
7684: END IF;
7685: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7686: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 7685: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

7681: BEGIN
7682: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7683: END;
7684: END IF;
7685: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7686: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7687: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7688: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7689: RAISE OKC_API.G_EXCEPTION_ERROR;