DBA Data[Home] [Help]

APPS.BEN_AGF_BUS dependencies on FND_MESSAGE

Line 210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

206: p_effective_date => p_effective_date) then
207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD', 'p_age_to_use_cd');
212: fnd_message.set_token('TYPE', 'BEN_AGE_TO_USE_CD');
213: fnd_message.raise_error;
214: --

Line 211: fnd_message.set_token('FIELD', 'p_age_to_use_cd');

207: --
208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD', 'p_age_to_use_cd');
212: fnd_message.set_token('TYPE', 'BEN_AGE_TO_USE_CD');
213: fnd_message.raise_error;
214: --
215: end if;

Line 212: fnd_message.set_token('TYPE', 'BEN_AGE_TO_USE_CD');

208: -- raise error as does not exist as lookup
209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD', 'p_age_to_use_cd');
212: fnd_message.set_token('TYPE', 'BEN_AGE_TO_USE_CD');
213: fnd_message.raise_error;
214: --
215: end if;
216: --

Line 213: fnd_message.raise_error;

209: --
210: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
211: fnd_message.set_token('FIELD', 'p_age_to_use_cd');
212: fnd_message.set_token('TYPE', 'BEN_AGE_TO_USE_CD');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
217: end if;

Line 283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

279: p_effective_date => p_effective_date) then
280: --
281: -- raise error
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rndg_rl);
285: fnd_message.set_token('TYPE_ID',-169);
286: fnd_message.raise_error;
287: --

Line 284: fnd_message.set_token('ID',p_rndg_rl);

280: --
281: -- raise error
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rndg_rl);
285: fnd_message.set_token('TYPE_ID',-169);
286: fnd_message.raise_error;
287: --
288: end if;

Line 285: fnd_message.set_token('TYPE_ID',-169);

281: -- raise error
282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rndg_rl);
285: fnd_message.set_token('TYPE_ID',-169);
286: fnd_message.raise_error;
287: --
288: end if;
289: --

Line 286: fnd_message.raise_error;

282: --
283: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
284: fnd_message.set_token('ID',p_rndg_rl);
285: fnd_message.set_token('TYPE_ID',-169);
286: fnd_message.raise_error;
287: --
288: end if;
289: --
290: end if;

Line 296: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');

292: -- Bug No 4242978
293: -- Unless Rounding Code = Rule, Rounding rule must be blank.
294: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
295: --
296: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
297: fnd_message.raise_error;
298: --
299: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
300: --

Line 297: fnd_message.raise_error;

293: -- Unless Rounding Code = Rule, Rounding rule must be blank.
294: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
295: --
296: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
297: fnd_message.raise_error;
298: --
299: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
300: --
301: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');

Line 301: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');

297: fnd_message.raise_error;
298: --
299: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
300: --
301: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
302: fnd_message.raise_error;
303: --
304: end if;
305: --

Line 302: fnd_message.raise_error;

298: --
299: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
300: --
301: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
302: fnd_message.raise_error;
303: --
304: end if;
305: --
306: hr_utility.set_location('Leaving:'||l_proc,10);

Line 369: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

365: p_effective_date => p_effective_date) then
366: --
367: -- raise error
368: --
369: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
370: fnd_message.set_token('ID',p_age_calc_rl);
371: fnd_message.set_token('TYPE_ID',-169);
372: fnd_message.raise_error;
373: --

Line 370: fnd_message.set_token('ID',p_age_calc_rl);

366: --
367: -- raise error
368: --
369: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
370: fnd_message.set_token('ID',p_age_calc_rl);
371: fnd_message.set_token('TYPE_ID',-169);
372: fnd_message.raise_error;
373: --
374: end if;

Line 371: fnd_message.set_token('TYPE_ID',-169);

367: -- raise error
368: --
369: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
370: fnd_message.set_token('ID',p_age_calc_rl);
371: fnd_message.set_token('TYPE_ID',-169);
372: fnd_message.raise_error;
373: --
374: end if;
375: --

Line 372: fnd_message.raise_error;

368: --
369: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
370: fnd_message.set_token('ID',p_age_calc_rl);
371: fnd_message.set_token('TYPE_ID',-169);
372: fnd_message.raise_error;
373: --
374: end if;
375: --
376: end if;

Line 421: fnd_message.set_name('BEN','BEN_92557_CODE_AGE_RULE');

417: p_age_calc_rl is not null then
418: --
419: -- raise error
420: --
421: fnd_message.set_name('BEN','BEN_92557_CODE_AGE_RULE');
422: fnd_message.raise_error;
423: --
424: end if;
425: --

Line 422: fnd_message.raise_error;

418: --
419: -- raise error
420: --
421: fnd_message.set_name('BEN','BEN_92557_CODE_AGE_RULE');
422: fnd_message.raise_error;
423: --
424: end if;
425: --
426: hr_utility.set_location('Leaving:'||l_proc,10);

Line 486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

482: p_effective_date => p_effective_date) then
483: --
484: -- raise error as does not exist as lookup
485: --
486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
487: fnd_message.set_token('FIELD', 'p_rndg_cd');
488: fnd_message.set_token('TYPE', 'BEN_RNDG');
489: fnd_message.raise_error;
490: --

Line 487: fnd_message.set_token('FIELD', 'p_rndg_cd');

483: --
484: -- raise error as does not exist as lookup
485: --
486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
487: fnd_message.set_token('FIELD', 'p_rndg_cd');
488: fnd_message.set_token('TYPE', 'BEN_RNDG');
489: fnd_message.raise_error;
490: --
491: end if;

Line 488: fnd_message.set_token('TYPE', 'BEN_RNDG');

484: -- raise error as does not exist as lookup
485: --
486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
487: fnd_message.set_token('FIELD', 'p_rndg_cd');
488: fnd_message.set_token('TYPE', 'BEN_RNDG');
489: fnd_message.raise_error;
490: --
491: end if;
492: --

Line 489: fnd_message.raise_error;

485: --
486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
487: fnd_message.set_token('FIELD', 'p_rndg_cd');
488: fnd_message.set_token('TYPE', 'BEN_RNDG');
489: fnd_message.raise_error;
490: --
491: end if;
492: --
493: end if;

Line 560: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

556: p_effective_date => p_effective_date) then
557: --
558: -- raise error
559: --
560: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
561: fnd_message.set_token('ID',p_age_det_rl);
562: fnd_message.set_token('TYPE_ID',-145);
563: fnd_message.raise_error;
564: --

Line 561: fnd_message.set_token('ID',p_age_det_rl);

557: --
558: -- raise error
559: --
560: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
561: fnd_message.set_token('ID',p_age_det_rl);
562: fnd_message.set_token('TYPE_ID',-145);
563: fnd_message.raise_error;
564: --
565: end if;

Line 562: fnd_message.set_token('TYPE_ID',-145);

558: -- raise error
559: --
560: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
561: fnd_message.set_token('ID',p_age_det_rl);
562: fnd_message.set_token('TYPE_ID',-145);
563: fnd_message.raise_error;
564: --
565: end if;
566: --

Line 563: fnd_message.raise_error;

559: --
560: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
561: fnd_message.set_token('ID',p_age_det_rl);
562: fnd_message.set_token('TYPE_ID',-145);
563: fnd_message.raise_error;
564: --
565: end if;
566: --
567: end if;

Line 575: fnd_message.set_name('BEN', 'BEN_91046_AGE_DET_RL_NOT_NULL');

571: --
572: -- Unless AGE determination Code = Rule, AGE determination rule must be blank.
573: if nvl(p_age_det_cd,hr_api.g_varchar2) <> 'RL' and p_age_det_rl is not null then
574: --
575: fnd_message.set_name('BEN', 'BEN_91046_AGE_DET_RL_NOT_NULL');
576: fnd_message.raise_error;
577: --
578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then
579: --

Line 576: fnd_message.raise_error;

572: -- Unless AGE determination Code = Rule, AGE determination rule must be blank.
573: if nvl(p_age_det_cd,hr_api.g_varchar2) <> 'RL' and p_age_det_rl is not null then
574: --
575: fnd_message.set_name('BEN', 'BEN_91046_AGE_DET_RL_NOT_NULL');
576: fnd_message.raise_error;
577: --
578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then
579: --
580: fnd_message.set_name('BEN', 'BEN_91096_AGE_DET_RL_NULL');

Line 580: fnd_message.set_name('BEN', 'BEN_91096_AGE_DET_RL_NULL');

576: fnd_message.raise_error;
577: --
578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then
579: --
580: fnd_message.set_name('BEN', 'BEN_91096_AGE_DET_RL_NULL');
581: fnd_message.raise_error;
582: --
583: end if;
584: --

Line 581: fnd_message.raise_error;

577: --
578: elsif nvl(p_age_det_cd,hr_api.g_varchar2) = 'RL' and p_age_det_rl is null then
579: --
580: fnd_message.set_name('BEN', 'BEN_91096_AGE_DET_RL_NULL');
581: fnd_message.raise_error;
582: --
583: end if;
584: --
585: hr_utility.set_location('Leaving:'||l_proc,10);

Line 646: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

642: p_effective_date => p_effective_date) then
643: --
644: -- raise error as does not exist as lookup
645: --
646: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
647: fnd_message.set_token('FIELD', 'p_age_det_cd');
648: fnd_message.set_token('TYPE', 'AGE_DET');
649: fnd_message.raise_error;
650: --

Line 647: fnd_message.set_token('FIELD', 'p_age_det_cd');

643: --
644: -- raise error as does not exist as lookup
645: --
646: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
647: fnd_message.set_token('FIELD', 'p_age_det_cd');
648: fnd_message.set_token('TYPE', 'AGE_DET');
649: fnd_message.raise_error;
650: --
651: end if;

Line 648: fnd_message.set_token('TYPE', 'AGE_DET');

644: -- raise error as does not exist as lookup
645: --
646: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
647: fnd_message.set_token('FIELD', 'p_age_det_cd');
648: fnd_message.set_token('TYPE', 'AGE_DET');
649: fnd_message.raise_error;
650: --
651: end if;
652: --

Line 649: fnd_message.raise_error;

645: --
646: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
647: fnd_message.set_token('FIELD', 'p_age_det_cd');
648: fnd_message.set_token('TYPE', 'AGE_DET');
649: fnd_message.raise_error;
650: --
651: end if;
652: --
653: end if;

Line 716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

712: p_effective_date => p_effective_date) then
713: --
714: -- raise error as does not exist as lookup
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD', 'p_no_mx_age_flag');
718: fnd_message.set_token('TYPE', 'YES_NO');
719: fnd_message.raise_error;
720: --

Line 717: fnd_message.set_token('FIELD', 'p_no_mx_age_flag');

713: --
714: -- raise error as does not exist as lookup
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD', 'p_no_mx_age_flag');
718: fnd_message.set_token('TYPE', 'YES_NO');
719: fnd_message.raise_error;
720: --
721: end if;

Line 718: fnd_message.set_token('TYPE', 'YES_NO');

714: -- raise error as does not exist as lookup
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD', 'p_no_mx_age_flag');
718: fnd_message.set_token('TYPE', 'YES_NO');
719: fnd_message.raise_error;
720: --
721: end if;
722: --

Line 719: fnd_message.raise_error;

715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD', 'p_no_mx_age_flag');
718: fnd_message.set_token('TYPE', 'YES_NO');
719: fnd_message.raise_error;
720: --
721: end if;
722: --
723: end if;

Line 786: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

782: p_effective_date => p_effective_date) then
783: --
784: -- raise error as does not exist as lookup
785: --
786: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
787: fnd_message.set_token('FIELD', 'p_no_mn_age_flag');
788: fnd_message.set_token('TYPE', 'YES_NO');
789: fnd_message.raise_error;
790: --

Line 787: fnd_message.set_token('FIELD', 'p_no_mn_age_flag');

783: --
784: -- raise error as does not exist as lookup
785: --
786: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
787: fnd_message.set_token('FIELD', 'p_no_mn_age_flag');
788: fnd_message.set_token('TYPE', 'YES_NO');
789: fnd_message.raise_error;
790: --
791: end if;

Line 788: fnd_message.set_token('TYPE', 'YES_NO');

784: -- raise error as does not exist as lookup
785: --
786: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
787: fnd_message.set_token('FIELD', 'p_no_mn_age_flag');
788: fnd_message.set_token('TYPE', 'YES_NO');
789: fnd_message.raise_error;
790: --
791: end if;
792: --

Line 789: fnd_message.raise_error;

785: --
786: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
787: fnd_message.set_token('FIELD', 'p_no_mn_age_flag');
788: fnd_message.set_token('TYPE', 'YES_NO');
789: fnd_message.raise_error;
790: --
791: end if;
792: --
793: end if;

Line 856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

852: p_effective_date => p_effective_date) then
853: --
854: -- raise error as does not exist as lookup
855: --
856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
857: fnd_message.set_token('FIELD', 'p_age_uom');
858: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
859: fnd_message.raise_error;
860: --

Line 857: fnd_message.set_token('FIELD', 'p_age_uom');

853: --
854: -- raise error as does not exist as lookup
855: --
856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
857: fnd_message.set_token('FIELD', 'p_age_uom');
858: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
859: fnd_message.raise_error;
860: --
861: end if;

Line 858: fnd_message.set_token('TYPE', 'BEN_TM_UOM');

854: -- raise error as does not exist as lookup
855: --
856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
857: fnd_message.set_token('FIELD', 'p_age_uom');
858: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
859: fnd_message.raise_error;
860: --
861: end if;
862: --

Line 859: fnd_message.raise_error;

855: --
856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
857: fnd_message.set_token('FIELD', 'p_age_uom');
858: fnd_message.set_token('TYPE', 'BEN_TM_UOM');
859: fnd_message.raise_error;
860: --
861: end if;
862: --
863: end if;

Line 927: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');

923: --
924: -- if (p_mx_age_num <= p_mn_age_num) then
925: if (p_mx_age_num < p_mn_age_num) then
926: -- end of fix 1873685
927: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
928: fnd_message.raise_error;
929: end if;
930: --
931: --

Line 928: fnd_message.raise_error;

924: -- if (p_mx_age_num <= p_mn_age_num) then
925: if (p_mx_age_num < p_mn_age_num) then
926: -- end of fix 1873685
927: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
928: fnd_message.raise_error;
929: end if;
930: --
931: --
932: end if;

Line 940: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');

936: --
937: if nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'Y'
938: and p_mn_age_num is not null
939: then
940: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
941: fnd_message.raise_error;
942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'
943: and p_mn_age_num is null
944: then

Line 941: fnd_message.raise_error;

937: if nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'Y'
938: and p_mn_age_num is not null
939: then
940: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
941: fnd_message.raise_error;
942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'
943: and p_mn_age_num is null
944: then
945: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');

Line 945: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');

941: fnd_message.raise_error;
942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'
943: and p_mn_age_num is null
944: then
945: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
946: fnd_message.raise_error;
947: end if;
948: --
949: -- If No Maximum age flag set to "on" (Y),

Line 946: fnd_message.raise_error;

942: elsif nvl( p_no_mn_age_flag, hr_api.g_varchar2) = 'N'
943: and p_mn_age_num is null
944: then
945: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
946: fnd_message.raise_error;
947: end if;
948: --
949: -- If No Maximum age flag set to "on" (Y),
950: -- then maximum age number must be blank.

Line 955: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');

951: --
952: if nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'Y'
953: and p_mx_age_num is not null
954: then
955: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
956: fnd_message.raise_error;
957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'
958: and p_mx_age_num is null
959: then

Line 956: fnd_message.raise_error;

952: if nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'Y'
953: and p_mx_age_num is not null
954: then
955: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
956: fnd_message.raise_error;
957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'
958: and p_mx_age_num is null
959: then
960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');

Line 960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');

956: fnd_message.raise_error;
957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'
958: and p_mx_age_num is null
959: then
960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
961: fnd_message.raise_error;
962: end if;
963: --
964: hr_utility.set_location('Leaving:'||l_proc,10);

Line 961: fnd_message.raise_error;

957: elsif nvl( p_no_mx_age_flag, hr_api.g_varchar2) = 'N'
958: and p_mx_age_num is null
959: then
960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
961: fnd_message.raise_error;
962: end if;
963: --
964: hr_utility.set_location('Leaving:'||l_proc,10);
965: --

Line 1040: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

1036: close c1;
1037: --
1038: -- raise error
1039: --
1040: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1041: fnd_message.raise_error;
1042: --
1043: end if;
1044: --

Line 1041: fnd_message.raise_error;

1037: --
1038: -- raise error
1039: --
1040: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1041: fnd_message.raise_error;
1042: --
1043: end if;
1044: --
1045: close c1;

Line 1103: fnd_message.set_name('BEN','BEN_91738_AGE_CHLD_RCD_EXISTS');

1099: close chk_cmbn_age_los_fctr;
1100: --
1101: -- raise error
1102: --
1103: fnd_message.set_name('BEN','BEN_91738_AGE_CHLD_RCD_EXISTS');
1104: fnd_message.raise_error;
1105: --
1106: end if;
1107: --

Line 1104: fnd_message.raise_error;

1100: --
1101: -- raise error
1102: --
1103: fnd_message.set_name('BEN','BEN_91738_AGE_CHLD_RCD_EXISTS');
1104: fnd_message.raise_error;
1105: --
1106: end if;
1107: --
1108: close chk_cmbn_age_los_fctr;*/ --Bug 2978945 used the common function rows_exist