DBA Data[Home] [Help]

APPS.IGI_IMP_IAC_EXCEP_INER_PKG dependencies on FND_MESSAGE

Line 402: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_DPIS_REVAL_EXCEPTION');

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 (

Line 404: l_message := Fnd_message.get;

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,

Line 458: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_FULLY_RETRIED');

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 (

Line 460: l_message := Fnd_message.get;

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,

Line 513: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NEGATIVE_COST');

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 (

Line 515: l_message := Fnd_message.get;

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,

Line 568: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_LIFE');

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 (

Line 570: l_message := Fnd_message.get;

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,

Line 623: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_DPIS');

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 (

Line 625: l_message := Fnd_message.get;

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,

Line 678: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_SALVAGE');

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 (

Line 680: l_message := Fnd_message.get;

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,

Line 743: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NONDEPRN_ASSET');

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 (

Line 745: l_message := Fnd_message.get;

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,

Line 805: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_COST');

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 (

Line 807: l_message := Fnd_message.get;

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,

Line 878: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_DPIS_REVAL_EXCEPTION');

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 (

Line 880: l_message := Fnd_message.get;

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,

Line 938: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_FULLY_RETRIED');

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 (

Line 940: l_message := Fnd_message.get;

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,

Line 995: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NEGATIVE_COST');

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:

Line 997: l_message := Fnd_message.get;

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,

Line 1058: FND_MESSAGE.SET_NAME ('IGI', 'IGI_IMP_NONDEPRN_ASSET');

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:

Line 1060: l_message := Fnd_message.get;

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,