132: --
133: close c1;
134: --
135: -- raise error
136: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');
137: fnd_message.raise_error;
138: --
139: end if;
140: --
133: close c1;
134: --
135: -- raise error
136: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');
137: fnd_message.raise_error;
138: --
139: end if;
140: --
141: close c1;
302: close c1;
303: --
304: -- raise error
305: --
306: fnd_message.set_name('BEN','BEN_91064_INVLD_HG_COMP_DET_RL');
307: fnd_message.raise_error;
308: --
309: end if;
310: --
303: --
304: -- raise error
305: --
306: fnd_message.set_name('BEN','BEN_91064_INVLD_HG_COMP_DET_RL');
307: fnd_message.raise_error;
308: --
309: end if;
310: --
311: close c1;
394: close c1;
395: --
396: -- raise error
397: --
398: fnd_message.set_name('BEN','BEN_91089_INVLD_KEY_EE_DET_RL');
399: fnd_message.raise_error;
400: --
401: end if;
402: --
395: --
396: -- raise error
397: --
398: fnd_message.set_name('BEN','BEN_91089_INVLD_KEY_EE_DET_RL');
399: fnd_message.raise_error;
400: --
401: end if;
402: --
403: close c1;
486: close c1;
487: --
488: -- raise error
489: --
490: fnd_message.set_name('BEN','BEN_91090_INVLD_CNTR_NDSCRN_RL');
491: fnd_message.raise_error;
492: --
493: end if;
494: --
487: --
488: -- raise error
489: --
490: fnd_message.set_name('BEN','BEN_91090_INVLD_CNTR_NDSCRN_RL');
491: fnd_message.raise_error;
492: --
493: end if;
494: --
495: close c1;
578: close c1;
579: --
580: -- raise error
581: --
582: fnd_message.set_name('BEN','BEN_91091_INVLD_CVG_NDSCRN_RL');
583: fnd_message.raise_error;
584: --
585: end if;
586: --
579: --
580: -- raise error
581: --
582: fnd_message.set_name('BEN','BEN_91091_INVLD_CVG_NDSCRN_RL');
583: fnd_message.raise_error;
584: --
585: end if;
586: --
587: close c1;
670: close c1;
671: --
672: -- raise error
673: --
674: fnd_message.set_name('BEN','BEN_91092_INVLD_5_PCT_OWNR_RL');
675: fnd_message.raise_error;
676: --
677: end if;
678: --
671: --
672: -- raise error
673: --
674: fnd_message.set_name('BEN','BEN_91092_INVLD_5_PCT_OWNR_RL');
675: fnd_message.raise_error;
676: --
677: end if;
678: --
679: close c1;
740: p_effective_date => p_effective_date) then
741: --
742: -- raise error as does not exist as lookup
743: --
744: fnd_message.set_name('BEN','BEN_91093_INVLD_REGY_PL_TYP_CD');
745: fnd_message.raise_error;
746: --
747: end if;
748: --
741: --
742: -- raise error as does not exist as lookup
743: --
744: fnd_message.set_name('BEN','BEN_91093_INVLD_REGY_PL_TYP_CD');
745: fnd_message.raise_error;
746: --
747: end if;
748: --
749: end if;
903: --
904: -- A referential integrity check was violated therefore
905: -- we must error
906: --
907: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
908: fnd_message.set_token('TABLE_NAME', l_table_name);
909: fnd_message.raise_error;
910: When Others Then
911: --
904: -- A referential integrity check was violated therefore
905: -- we must error
906: --
907: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
908: fnd_message.set_token('TABLE_NAME', l_table_name);
909: fnd_message.raise_error;
910: When Others Then
911: --
912: -- An unhandled or unexpected error has occurred which
905: -- we must error
906: --
907: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
908: fnd_message.set_token('TABLE_NAME', l_table_name);
909: fnd_message.raise_error;
910: When Others Then
911: --
912: -- An unhandled or unexpected error has occurred which
913: -- we must report
911: --
912: -- An unhandled or unexpected error has occurred which
913: -- we must report
914: --
915: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
916: fnd_message.set_token('PROCEDURE', l_proc);
917: fnd_message.set_token('STEP','15');
918: fnd_message.raise_error;
919: End dt_update_validate;
912: -- An unhandled or unexpected error has occurred which
913: -- we must report
914: --
915: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
916: fnd_message.set_token('PROCEDURE', l_proc);
917: fnd_message.set_token('STEP','15');
918: fnd_message.raise_error;
919: End dt_update_validate;
920: --
913: -- we must report
914: --
915: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
916: fnd_message.set_token('PROCEDURE', l_proc);
917: fnd_message.set_token('STEP','15');
918: fnd_message.raise_error;
919: End dt_update_validate;
920: --
921: -- ----------------------------------------------------------------------------
914: --
915: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
916: fnd_message.set_token('PROCEDURE', l_proc);
917: fnd_message.set_token('STEP','15');
918: fnd_message.raise_error;
919: End dt_update_validate;
920: --
921: -- ----------------------------------------------------------------------------
922: -- |--------------------------< dt_delete_validate >--------------------------|
1007: --
1008: -- A referential integrity check was violated therefore
1009: -- we must error
1010: --
1011: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1012: fnd_message.set_token('TABLE_NAME', l_table_name);
1013: fnd_message.raise_error;
1014: When Others Then
1015: --
1008: -- A referential integrity check was violated therefore
1009: -- we must error
1010: --
1011: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1012: fnd_message.set_token('TABLE_NAME', l_table_name);
1013: fnd_message.raise_error;
1014: When Others Then
1015: --
1016: -- An unhandled or unexpected error has occurred which
1009: -- we must error
1010: --
1011: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1012: fnd_message.set_token('TABLE_NAME', l_table_name);
1013: fnd_message.raise_error;
1014: When Others Then
1015: --
1016: -- An unhandled or unexpected error has occurred which
1017: -- we must report
1015: --
1016: -- An unhandled or unexpected error has occurred which
1017: -- we must report
1018: --
1019: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1020: fnd_message.set_token('PROCEDURE', l_proc);
1021: fnd_message.set_token('STEP','15');
1022: fnd_message.raise_error;
1023: End dt_delete_validate;
1016: -- An unhandled or unexpected error has occurred which
1017: -- we must report
1018: --
1019: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1020: fnd_message.set_token('PROCEDURE', l_proc);
1021: fnd_message.set_token('STEP','15');
1022: fnd_message.raise_error;
1023: End dt_delete_validate;
1024: --
1017: -- we must report
1018: --
1019: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1020: fnd_message.set_token('PROCEDURE', l_proc);
1021: fnd_message.set_token('STEP','15');
1022: fnd_message.raise_error;
1023: End dt_delete_validate;
1024: --
1025: -- ----------------------------------------------------------------------------
1018: --
1019: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1020: fnd_message.set_token('PROCEDURE', l_proc);
1021: fnd_message.set_token('STEP','15');
1022: fnd_message.raise_error;
1023: End dt_delete_validate;
1024: --
1025: -- ----------------------------------------------------------------------------
1026: -- |---------------------------< insert_validate >----------------------------|
1285: close csr_leg_code;
1286: --
1287: -- The primary key is invalid therefore we must error
1288: --
1289: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1290: fnd_message.raise_error;
1291: --
1292: end if;
1293: --
1286: --
1287: -- The primary key is invalid therefore we must error
1288: --
1289: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1290: fnd_message.raise_error;
1291: --
1292: end if;
1293: --
1294: */