398: IF (l_dpis_prd_counter > l_reval_prd_counter AND
399: l_dpis_prd_counter <= l_curr_prd_counter) THEN
400:
401: -- list the asset as an exception
402: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_DPIS_REVAL_EXCEPTION');
403: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
404: l_message := Fnd_message.get;
405:
406: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
400:
401: -- list the asset as an exception
402: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_DPIS_REVAL_EXCEPTION');
403: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
404: l_message := Fnd_message.get;
405:
406: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
407: request_id,
408: sob_book,
454: -- bug 3442275, 3nd 3
455:
456: IF l_initial_flag ='N' then
457: If C_Mhca_Book_Info_Rec.period_counter_fully_retired is not null then
458: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_FULLY_RETRIED');
459: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
460: l_message := Fnd_message.get;
461:
462: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
456: IF l_initial_flag ='N' then
457: If C_Mhca_Book_Info_Rec.period_counter_fully_retired is not null then
458: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_FULLY_RETRIED');
459: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
460: l_message := Fnd_message.get;
461:
462: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
463: request_id,
464: sob_book,
509: END IF;
510:
511: IF l_initial_flag ='N' then
512: If sign(C_Mhca_Book_Info_Rec.cost) = -1 then
513: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NEGATIVE_COST');
514: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
515: l_message := Fnd_message.get;
516:
517: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
511: IF l_initial_flag ='N' then
512: If sign(C_Mhca_Book_Info_Rec.cost) = -1 then
513: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NEGATIVE_COST');
514: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
515: l_message := Fnd_message.get;
516:
517: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
518: request_id,
519: sob_book,
564: End if;
565:
566: IF l_initial_flag ='N' then
567: If (C_Corp_Book_Info_Rec.life_in_months - C_Mhca_Book_Info_Rec.life_in_months )<> 0 then
568: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_LIFE');
569: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
570: l_message := Fnd_message.get;
571:
572: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
566: IF l_initial_flag ='N' then
567: If (C_Corp_Book_Info_Rec.life_in_months - C_Mhca_Book_Info_Rec.life_in_months )<> 0 then
568: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_LIFE');
569: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
570: l_message := Fnd_message.get;
571:
572: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
573: request_id,
574: sob_book,
619: End if;
620:
621: IF l_initial_flag ='N' then
622: If trunc(C_Mhca_Book_Info_Rec.date_placed_in_service) <> trunc(C_Corp_Book_Info_Rec.date_placed_in_service)then
623: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_DPIS');
624: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
625: l_message := Fnd_message.get;
626:
627: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
621: IF l_initial_flag ='N' then
622: If trunc(C_Mhca_Book_Info_Rec.date_placed_in_service) <> trunc(C_Corp_Book_Info_Rec.date_placed_in_service)then
623: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_DPIS');
624: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
625: l_message := Fnd_message.get;
626:
627: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
628: request_id,
629: sob_book,
674: End if;
675:
676: IF l_initial_flag ='N' then
677: If (C_Mhca_Book_Info_Rec.salvage_value - C_Corp_Book_Info_Rec.salvage_value) <> 0 then
678: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_SALVAGE');
679: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
680: l_message := Fnd_message.get;
681:
682: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
676: IF l_initial_flag ='N' then
677: If (C_Mhca_Book_Info_Rec.salvage_value - C_Corp_Book_Info_Rec.salvage_value) <> 0 then
678: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_SALVAGE');
679: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
680: l_message := Fnd_message.get;
681:
682: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
683: request_id,
684: sob_book,
739: OR nvl(c_corp_book_info_rec.deprn_reserve,0) <> 0
740: OR nvl(c_corp_book_info_rec.ytd_deprn,0) <> 0) THEN
741: -- bug 3464589, end 1
742:
743: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NONDEPRN_ASSET');
744: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
745: l_message := Fnd_message.get;
746:
747: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
741: -- bug 3464589, end 1
742:
743: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NONDEPRN_ASSET');
744: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
745: l_message := Fnd_message.get;
746:
747: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
748: request_id,
749: sob_book,
801: IF l_initial_flag ='N' then
802: If (abs((nvl(C_Mhca_Reval_Summary_Info_Rec.new_asset_cost,0) - nvl(C_Mhca_Reval_Summary_Info_Rec.new_reval_reserve,0))
803: - C_Corp_Book_Info_Rec.cost ) > 0.05 ) then
804:
805: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_COST');
806: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
807: l_message := Fnd_message.get;
808:
809: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
803: - C_Corp_Book_Info_Rec.cost ) > 0.05 ) then
804:
805: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_COST');
806: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
807: l_message := Fnd_message.get;
808:
809: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
810: request_id,
811: sob_book,
874: IF (l_dpis_prd_counter > l_reval_prd_counter AND
875: l_dpis_prd_counter <= l_curr_prd_counter) THEN
876:
877: -- list the asset as an exception
878: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_DPIS_REVAL_EXCEPTION');
879: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,TRUE);
880: l_message := Fnd_message.get;
881:
882: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
876:
877: -- list the asset as an exception
878: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_DPIS_REVAL_EXCEPTION');
879: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,TRUE);
880: l_message := Fnd_message.get;
881:
882: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
883: request_id,
884: sob_book,
934: -- bug 3476361, start 1
935: IF l_initial_flag ='N' THEN
936: -- bug 3476361, end 1
937: If C_Corp_Book_Info_Rec.period_counter_fully_retired is not null then
938: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_FULLY_RETRIED');
939: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
940: l_message := Fnd_message.get;
941:
942: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
936: -- bug 3476361, end 1
937: If C_Corp_Book_Info_Rec.period_counter_fully_retired is not null then
938: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_FULLY_RETRIED');
939: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
940: l_message := Fnd_message.get;
941:
942: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
943: request_id,
944: sob_book,
991: -- bug 3476361, end 2
992:
993: IF l_initial_flag ='N' then
994: If sign(C_Corp_Book_Info_Rec.cost) = -1 then
995: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NEGATIVE_COST');
996: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
997: l_message := Fnd_message.get;
998:
999:
993: IF l_initial_flag ='N' then
994: If sign(C_Corp_Book_Info_Rec.cost) = -1 then
995: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NEGATIVE_COST');
996: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
997: l_message := Fnd_message.get;
998:
999:
1000: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
1001: request_id,
1054: IF (nvl(c_corp_book_info_rec.deprn_reserve,0) <> 0
1055: OR nvl(c_corp_book_info_rec.ytd_deprn,0) <> 0) THEN
1056:
1057:
1058: FND_MESSAGE.SET_NAME ('IGI', 'IGI_IMP_NONDEPRN_ASSET');
1059: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
1060: l_message := Fnd_message.get;
1061:
1062:
1056:
1057:
1058: FND_MESSAGE.SET_NAME ('IGI', 'IGI_IMP_NONDEPRN_ASSET');
1059: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
1060: l_message := Fnd_message.get;
1061:
1062:
1063: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
1064: request_id,