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 7100: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies

7096:
7097: -------- Activate Policy
7098: l_ipyv_rec.ISS_CODE := 'ACTIVE' ;
7099: l_ipyv_rec.ACTIVATION_DATE := SYSDATE ;
7100: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7101: IF(IS_DEBUG_PROCEDURE_ON) THEN
7102: BEGIN
7103: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7104: END;

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

7099: l_ipyv_rec.ACTIVATION_DATE := SYSDATE ;
7100: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7101: IF(IS_DEBUG_PROCEDURE_ON) THEN
7102: BEGIN
7103: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7104: END;
7105: END IF;
7106: Okl_Ins_Policies_Pub.update_ins_policies(
7107: p_api_version => p_api_version,

Line 7106: Okl_Ins_Policies_Pub.update_ins_policies(

7102: BEGIN
7103: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7104: END;
7105: END IF;
7106: Okl_Ins_Policies_Pub.update_ins_policies(
7107: p_api_version => p_api_version,
7108: p_init_msg_list => OKC_API.G_FALSE,
7109: x_return_status => l_return_status,
7110: x_msg_count => x_msg_count,

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

7112: p_ipyv_rec => l_ipyv_rec,
7113: x_ipyv_rec => lx_ipyv_rec );
7114: IF(IS_DEBUG_PROCEDURE_ON) THEN
7115: BEGIN
7116: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7117: END;
7118: END IF;
7119: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7120:

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

7115: BEGIN
7116: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7117: END;
7118: END IF;
7119: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7120:
7121: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7123: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

7543: -- Check for Third Party is taken care in deciding policy type
7544: -- Make Policy related changes
7545: l_ipyv_rec := get_optional_policy(l_inqv_rec);
7546: -- Insert Policy
7547: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
7548: IF(L_DEBUG_ENABLED='Y') THEN
7549: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
7550: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7551: END IF;

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

7550: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
7551: END IF;
7552: IF(IS_DEBUG_PROCEDURE_ON) THEN
7553: BEGIN
7554: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7555: END;
7556: END IF;
7557: Okl_Ins_Policies_Pub.insert_ins_policies(
7558: p_api_version => p_api_version,

Line 7557: Okl_Ins_Policies_Pub.insert_ins_policies(

7553: BEGIN
7554: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7555: END;
7556: END IF;
7557: Okl_Ins_Policies_Pub.insert_ins_policies(
7558: p_api_version => p_api_version,
7559: p_init_msg_list => OKC_API.G_FALSE,
7560: x_return_status => l_return_status,
7561: x_msg_count => x_msg_count,

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

7564: x_ipyv_rec => lx_ipyv_rec
7565: );
7566: IF(IS_DEBUG_PROCEDURE_ON) THEN
7567: BEGIN
7568: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7569: END;
7570: END IF;
7571: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
7572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

7567: BEGIN
7568: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.insert_ins_policies ');
7569: END;
7570: END IF;
7571: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.insert_ins_policies
7572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7574: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7575: RAISE OKC_API.G_EXCEPTION_ERROR;

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

7668: -----
7669: -- update quote
7670: -- Put Policy Number in Quote record
7671: l_inqv_rec.IPY_ID := l_ipyv_rec.ID;
7672: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7673: IF(IS_DEBUG_PROCEDURE_ON) THEN
7674: BEGIN
7675: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7676: END;

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

7671: l_inqv_rec.IPY_ID := l_ipyv_rec.ID;
7672: -- Start of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7673: IF(IS_DEBUG_PROCEDURE_ON) THEN
7674: BEGIN
7675: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7676: END;
7677: END IF;
7678: Okl_Ins_Policies_Pub.update_ins_policies(
7679: p_api_version => p_api_version,

Line 7678: Okl_Ins_Policies_Pub.update_ins_policies(

7674: BEGIN
7675: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7676: END;
7677: END IF;
7678: Okl_Ins_Policies_Pub.update_ins_policies(
7679: p_api_version => p_api_version,
7680: p_init_msg_list => OKC_API.G_FALSE,
7681: x_return_status => l_return_status,
7682: x_msg_count => x_msg_count,

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

7685: x_ipyv_rec => lx_inqv_rec
7686: );
7687: IF(IS_DEBUG_PROCEDURE_ON) THEN
7688: BEGIN
7689: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7690: END;
7691: END IF;
7692: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7693: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

7688: BEGIN
7689: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRINQB.pls call Okl_Ins_Policies_Pub.update_ins_policies ');
7690: END;
7691: END IF;
7692: -- End of wraper code generated automatically by Debug code generator for Okl_Ins_Policies_Pub.update_ins_policies
7693: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
7694: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
7695: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
7696: RAISE OKC_API.G_EXCEPTION_ERROR;