DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on FND_MESSAGE

Line 48: fnd_message.raise_error

44: 07-Sep-99 tguy 115.16 fixed calls to pay_mag_util
45: 14-Oct-99 Gperry 115.17 Changed dependent address
46: error to use the generic
47: exception rather than
48: fnd_message.raise_error
49: exception. Changed error
50: message to explain error
51: more thouroughly.
52: 11-Nov-99 mhoyes 115.18 - Added trace messages.

Line 678: fnd_message.set_name('BEN','BEN_91470_PGM_NOT_FOUND');

674: fetch c_pgm into l_pgm;
675: if c_pgm%notfound then
676: close c_pgm;
677: hr_utility.set_location ('BEN_91470_PGM_NOT_FOUND ',10);
678: fnd_message.set_name('BEN','BEN_91470_PGM_NOT_FOUND');
679: fnd_message.set_token('PROC',l_proc);
680: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
681: fnd_message.raise_error;
682: end if;

Line 679: fnd_message.set_token('PROC',l_proc);

675: if c_pgm%notfound then
676: close c_pgm;
677: hr_utility.set_location ('BEN_91470_PGM_NOT_FOUND ',10);
678: fnd_message.set_name('BEN','BEN_91470_PGM_NOT_FOUND');
679: fnd_message.set_token('PROC',l_proc);
680: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
681: fnd_message.raise_error;
682: end if;
683: close c_pgm;

Line 680: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));

676: close c_pgm;
677: hr_utility.set_location ('BEN_91470_PGM_NOT_FOUND ',10);
678: fnd_message.set_name('BEN','BEN_91470_PGM_NOT_FOUND');
679: fnd_message.set_token('PROC',l_proc);
680: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
681: fnd_message.raise_error;
682: end if;
683: close c_pgm;
684: l_level := l_pgm.dpnt_dsgn_lvl_cd;

Line 681: fnd_message.raise_error;

677: hr_utility.set_location ('BEN_91470_PGM_NOT_FOUND ',10);
678: fnd_message.set_name('BEN','BEN_91470_PGM_NOT_FOUND');
679: fnd_message.set_token('PROC',l_proc);
680: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
681: fnd_message.raise_error;
682: end if;
683: close c_pgm;
684: l_level := l_pgm.dpnt_dsgn_lvl_cd;
685: else

Line 721: fnd_message.set_name('BEN','BEN_91480_MISSING_CONTACT_REL');

717: if c_contact%notfound then
718: --
719: close c_contact;
720: hr_utility.set_location ('BEN_91480_MISSING_CONTACT_REL ',10);
721: fnd_message.set_name('BEN','BEN_91480_MISSING_CONTACT_REL');
722: fnd_message.set_token('PROC',l_proc);
723: fnd_message.set_token('CONT_RLSHP_ID',to_char(p_contact_relationship_id));
724: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
725: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

Line 722: fnd_message.set_token('PROC',l_proc);

718: --
719: close c_contact;
720: hr_utility.set_location ('BEN_91480_MISSING_CONTACT_REL ',10);
721: fnd_message.set_name('BEN','BEN_91480_MISSING_CONTACT_REL');
722: fnd_message.set_token('PROC',l_proc);
723: fnd_message.set_token('CONT_RLSHP_ID',to_char(p_contact_relationship_id));
724: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
725: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
726: fnd_message.raise_error;

Line 723: fnd_message.set_token('CONT_RLSHP_ID',to_char(p_contact_relationship_id));

719: close c_contact;
720: hr_utility.set_location ('BEN_91480_MISSING_CONTACT_REL ',10);
721: fnd_message.set_name('BEN','BEN_91480_MISSING_CONTACT_REL');
722: fnd_message.set_token('PROC',l_proc);
723: fnd_message.set_token('CONT_RLSHP_ID',to_char(p_contact_relationship_id));
724: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
725: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
726: fnd_message.raise_error;
727: --

Line 724: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

720: hr_utility.set_location ('BEN_91480_MISSING_CONTACT_REL ',10);
721: fnd_message.set_name('BEN','BEN_91480_MISSING_CONTACT_REL');
722: fnd_message.set_token('PROC',l_proc);
723: fnd_message.set_token('CONT_RLSHP_ID',to_char(p_contact_relationship_id));
724: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
725: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
726: fnd_message.raise_error;
727: --
728: end if;

Line 725: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

721: fnd_message.set_name('BEN','BEN_91480_MISSING_CONTACT_REL');
722: fnd_message.set_token('PROC',l_proc);
723: fnd_message.set_token('CONT_RLSHP_ID',to_char(p_contact_relationship_id));
724: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
725: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
726: fnd_message.raise_error;
727: --
728: end if;
729: --

Line 726: fnd_message.raise_error;

722: fnd_message.set_token('PROC',l_proc);
723: fnd_message.set_token('CONT_RLSHP_ID',to_char(p_contact_relationship_id));
724: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
725: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
726: fnd_message.raise_error;
727: --
728: end if;
729: --
730: close c_contact;

Line 874: fnd_message.set_name('BEN','BEN_91481_INVALID_PERSON');

870: if c_per%notfound then
871: --
872: close c_per;
873: hr_utility.set_location ('BEN_91481_INVALID_PERSON ',10);
874: fnd_message.set_name('BEN','BEN_91481_INVALID_PERSON');
875: fnd_message.set_token('PROC',l_proc);
876: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
877: fnd_message.raise_error;
878: --

Line 875: fnd_message.set_token('PROC',l_proc);

871: --
872: close c_per;
873: hr_utility.set_location ('BEN_91481_INVALID_PERSON ',10);
874: fnd_message.set_name('BEN','BEN_91481_INVALID_PERSON');
875: fnd_message.set_token('PROC',l_proc);
876: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
877: fnd_message.raise_error;
878: --
879: end if;

Line 876: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));

872: close c_per;
873: hr_utility.set_location ('BEN_91481_INVALID_PERSON ',10);
874: fnd_message.set_name('BEN','BEN_91481_INVALID_PERSON');
875: fnd_message.set_token('PROC',l_proc);
876: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
877: fnd_message.raise_error;
878: --
879: end if;
880: --

Line 877: fnd_message.raise_error;

873: hr_utility.set_location ('BEN_91481_INVALID_PERSON ',10);
874: fnd_message.set_name('BEN','BEN_91481_INVALID_PERSON');
875: fnd_message.set_token('PROC',l_proc);
876: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
877: fnd_message.raise_error;
878: --
879: end if;
880: --
881: close c_per;

Line 896: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');

892: l_contact.rltd_per_rsds_w_dsgntr_flag='N' then
893: --
894: close c_add;
895: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
896: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
897: fnd_message.set_token('PROC',l_proc);
898: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
899: raise ben_manage_life_events.g_record_error;
900: --

Line 897: fnd_message.set_token('PROC',l_proc);

893: --
894: close c_add;
895: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
896: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
897: fnd_message.set_token('PROC',l_proc);
898: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
899: raise ben_manage_life_events.g_record_error;
900: --
901: elsif c_add%notfound and

Line 898: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));

894: close c_add;
895: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
896: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
897: fnd_message.set_token('PROC',l_proc);
898: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
899: raise ben_manage_life_events.g_record_error;
900: --
901: elsif c_add%notfound and
902: l_contact.rltd_per_rsds_w_dsgntr_flag='Y' then

Line 911: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');

907: --
908: fetch c_add2 into l_add;
909: if c_add2%notfound then
910: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
911: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
912: fnd_message.set_token('PROC',l_proc);
913: fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
914: raise ben_manage_life_events.g_record_error;
915: --

Line 912: fnd_message.set_token('PROC',l_proc);

908: fetch c_add2 into l_add;
909: if c_add2%notfound then
910: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
911: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
912: fnd_message.set_token('PROC',l_proc);
913: fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
914: raise ben_manage_life_events.g_record_error;
915: --
916: end if;

Line 913: fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));

909: if c_add2%notfound then
910: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
911: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
912: fnd_message.set_token('PROC',l_proc);
913: fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
914: raise ben_manage_life_events.g_record_error;
915: --
916: end if;
917: --

Line 1304: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');

1300: --
1301: --close c_add;
1302: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
1303: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1304: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1305: --fnd_message.set_token('PROC',l_proc);
1306: --fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
1307: --raise ben_manage_life_events.g_record_error;
1308:

Line 1305: --fnd_message.set_token('PROC',l_proc);

1301: --close c_add;
1302: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
1303: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1304: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1305: --fnd_message.set_token('PROC',l_proc);
1306: --fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
1307: --raise ben_manage_life_events.g_record_error;
1308:
1309: elsif c_add%notfound and l_contact.rltd_per_rsds_w_dsgntr_flag='Y' then

Line 1306: --fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));

1302: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
1303: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1304: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1305: --fnd_message.set_token('PROC',l_proc);
1306: --fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
1307: --raise ben_manage_life_events.g_record_error;
1308:
1309: elsif c_add%notfound and l_contact.rltd_per_rsds_w_dsgntr_flag='Y' then
1310: --

Line 1320: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');

1316: if c_add2%notfound then
1317:
1318: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1319: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
1320: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1321: --fnd_message.set_token('PROC',l_proc);
1322: --fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
1323: --raise ben_manage_life_events.g_record_error;
1324: --

Line 1321: --fnd_message.set_token('PROC',l_proc);

1317:
1318: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1319: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
1320: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1321: --fnd_message.set_token('PROC',l_proc);
1322: --fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
1323: --raise ben_manage_life_events.g_record_error;
1324: --
1325: end if;

Line 1322: --fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));

1318: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1319: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
1320: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1321: --fnd_message.set_token('PROC',l_proc);
1322: --fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
1323: --raise ben_manage_life_events.g_record_error;
1324: --
1325: end if;
1326: --