DBA Data[Home] [Help]

APPS.BEN_PRT_BUS dependencies on FND_MESSAGE

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

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;

Line 138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');

134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;
142: --

Line 139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);

135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;
142: --
143: end if;

Line 140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');

136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;
142: --
143: end if;
144: --

Line 141: fnd_message.raise_error;

137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_poe_nnmntry_uom');
139: fnd_message.set_token('VALUE', p_poe_nnmntry_uom);
140: fnd_message.set_token('TYPE','BEN_RQD_PERD_ENRT_NENRT_TM_UOM');
141: fnd_message.raise_error;
142: --
143: end if;
144: --
145: end if;

Line 223: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');

219: close c1;
220: --
221: -- raise error
222: --
223: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
224: fnd_message.raise_error;
225: --
226: end if;
227: --

Line 224: fnd_message.raise_error;

220: --
221: -- raise error
222: --
223: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
224: fnd_message.raise_error;
225: --
226: end if;
227: --
228: close c1;

Line 294: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

290: p_effective_date => p_effective_date) then
291: --
292: -- raise error as does not exist as lookup
293: --
294: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
295: fnd_message.raise_error;
296: --
297: end if;
298: --

Line 295: fnd_message.raise_error;

291: --
292: -- raise error as does not exist as lookup
293: --
294: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
295: fnd_message.raise_error;
296: --
297: end if;
298: --
299: end if;

Line 363: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

359: p_effective_date => p_effective_date) then
360: --
361: -- raise error as does not exist as lookup
362: --
363: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
364: fnd_message.raise_error;
365: --
366: end if;
367: --

Line 364: fnd_message.raise_error;

360: --
361: -- raise error as does not exist as lookup
362: --
363: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
364: fnd_message.raise_error;
365: --
366: end if;
367: --
368: end if;

Line 432: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

428: p_effective_date => p_effective_date) then
429: --
430: -- raise error as does not exist as lookup
431: --
432: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
433: fnd_message.raise_error;
434: --
435: end if;
436: --

Line 433: fnd_message.raise_error;

429: --
430: -- raise error as does not exist as lookup
431: --
432: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
433: fnd_message.raise_error;
434: --
435: end if;
436: --
437: end if;

Line 501: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

497: p_effective_date => p_effective_date) then
498: --
499: -- raise error as does not exist as lookup
500: --
501: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
502: fnd_message.raise_error;
503: --
504: end if;
505: --

Line 502: fnd_message.raise_error;

498: --
499: -- raise error as does not exist as lookup
500: --
501: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
502: fnd_message.raise_error;
503: --
504: end if;
505: --
506: end if;

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

562: -- raise error if max value not greater than min value
563: --
564: if p_mx_poe_num <= p_mn_poe_num then
565: --
566: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
567: fnd_message.raise_error;
568: --
569: end if;
570: --

Line 567: fnd_message.raise_error;

563: --
564: if p_mx_poe_num <= p_mn_poe_num then
565: --
566: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
567: fnd_message.raise_error;
568: --
569: end if;
570: --
571: end if;

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

575: --
576: if p_no_mn_poe_flag = 'Y' and
577: p_mn_poe_num is not null then
578: --
579: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
580: fnd_message.raise_error;
581: --
582: elsif p_no_mn_poe_flag = 'N' and
583: p_mn_poe_num is null then

Line 580: fnd_message.raise_error;

576: if p_no_mn_poe_flag = 'Y' and
577: p_mn_poe_num is not null then
578: --
579: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
580: fnd_message.raise_error;
581: --
582: elsif p_no_mn_poe_flag = 'N' and
583: p_mn_poe_num is null then
584: --

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

581: --
582: elsif p_no_mn_poe_flag = 'N' and
583: p_mn_poe_num is null then
584: --
585: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
586: fnd_message.raise_error;
587: --
588: end if;
589: --

Line 586: fnd_message.raise_error;

582: elsif p_no_mn_poe_flag = 'N' and
583: p_mn_poe_num is null then
584: --
585: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
586: fnd_message.raise_error;
587: --
588: end if;
589: --
590: -- If No Maximum poe flag set to "on" (Y),

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

592: --
593: if p_no_mx_poe_flag = 'Y' and
594: p_mx_poe_num is not null then
595: --
596: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
597: fnd_message.raise_error;
598: --
599: elsif p_no_mx_poe_flag = 'N' and
600: p_mx_poe_num is null then

Line 597: fnd_message.raise_error;

593: if p_no_mx_poe_flag = 'Y' and
594: p_mx_poe_num is not null then
595: --
596: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
597: fnd_message.raise_error;
598: --
599: elsif p_no_mx_poe_flag = 'N' and
600: p_mx_poe_num is null then
601: --

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

598: --
599: elsif p_no_mx_poe_flag = 'N' and
600: p_mx_poe_num is null then
601: --
602: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
603: fnd_message.raise_error;
604: --
605: end if;
606: --

Line 603: fnd_message.raise_error;

599: elsif p_no_mx_poe_flag = 'N' and
600: p_mx_poe_num is null then
601: --
602: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
603: fnd_message.raise_error;
604: --
605: end if;
606: --
607: hr_utility.set_location('Leaving:'||l_proc,10);

Line 703: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

699: --
700: -- An unhandled or unexpected error has occurred which
701: -- we must report
702: --
703: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
704: fnd_message.set_token('PROCEDURE', l_proc);
705: fnd_message.set_token('STEP','15');
706: fnd_message.raise_error;
707: End dt_update_validate;

Line 704: fnd_message.set_token('PROCEDURE', l_proc);

700: -- An unhandled or unexpected error has occurred which
701: -- we must report
702: --
703: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
704: fnd_message.set_token('PROCEDURE', l_proc);
705: fnd_message.set_token('STEP','15');
706: fnd_message.raise_error;
707: End dt_update_validate;
708: --

Line 705: fnd_message.set_token('STEP','15');

701: -- we must report
702: --
703: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
704: fnd_message.set_token('PROCEDURE', l_proc);
705: fnd_message.set_token('STEP','15');
706: fnd_message.raise_error;
707: End dt_update_validate;
708: --
709: -- ----------------------------------------------------------------------------

Line 706: fnd_message.raise_error;

702: --
703: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
704: fnd_message.set_token('PROCEDURE', l_proc);
705: fnd_message.set_token('STEP','15');
706: fnd_message.raise_error;
707: End dt_update_validate;
708: --
709: -- ----------------------------------------------------------------------------
710: -- |--------------------------< dt_delete_validate >--------------------------|

Line 799: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

795: --
796: -- A referential integrity check was violated therefore
797: -- we must error
798: --
799: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
800: fnd_message.set_token('TABLE_NAME', l_table_name);
801: fnd_message.raise_error;
802: When Others Then
803: --

Line 800: fnd_message.set_token('TABLE_NAME', l_table_name);

796: -- A referential integrity check was violated therefore
797: -- we must error
798: --
799: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
800: fnd_message.set_token('TABLE_NAME', l_table_name);
801: fnd_message.raise_error;
802: When Others Then
803: --
804: -- An unhandled or unexpected error has occurred which

Line 801: fnd_message.raise_error;

797: -- we must error
798: --
799: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
800: fnd_message.set_token('TABLE_NAME', l_table_name);
801: fnd_message.raise_error;
802: When Others Then
803: --
804: -- An unhandled or unexpected error has occurred which
805: -- we must report

Line 807: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

803: --
804: -- An unhandled or unexpected error has occurred which
805: -- we must report
806: --
807: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
808: fnd_message.set_token('PROCEDURE', l_proc);
809: fnd_message.set_token('STEP','15');
810: fnd_message.raise_error;
811: End dt_delete_validate;

Line 808: fnd_message.set_token('PROCEDURE', l_proc);

804: -- An unhandled or unexpected error has occurred which
805: -- we must report
806: --
807: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
808: fnd_message.set_token('PROCEDURE', l_proc);
809: fnd_message.set_token('STEP','15');
810: fnd_message.raise_error;
811: End dt_delete_validate;
812: --

Line 809: fnd_message.set_token('STEP','15');

805: -- we must report
806: --
807: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
808: fnd_message.set_token('PROCEDURE', l_proc);
809: fnd_message.set_token('STEP','15');
810: fnd_message.raise_error;
811: End dt_delete_validate;
812: --
813: -- ----------------------------------------------------------------------------

Line 810: fnd_message.raise_error;

806: --
807: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
808: fnd_message.set_token('PROCEDURE', l_proc);
809: fnd_message.set_token('STEP','15');
810: fnd_message.raise_error;
811: End dt_delete_validate;
812: --
813: -- ----------------------------------------------------------------------------
814: -- |---------------------------< insert_validate >----------------------------|

Line 1031: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1027: close csr_leg_code;
1028: --
1029: -- The primary key is invalid therefore we must error
1030: --
1031: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1032: fnd_message.raise_error;
1033: --
1034: end if;
1035: --

Line 1032: fnd_message.raise_error;

1028: --
1029: -- The primary key is invalid therefore we must error
1030: --
1031: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1032: fnd_message.raise_error;
1033: --
1034: end if;
1035: --
1036: close csr_leg_code;