PCG rule with SQL code is compiled successfully but does not trigger on the specific event

PCG rule with SQL code is compiled successfully but does not trigger on the specific event.

The records are getting saved without throwing the error message which is how it should work.

SQL Code :

------------------------------------------------------------------------------------------------------------------------------

l_period_name Varchar2(10);

extract_period Varchar2(10);

l_period_num number;

l_start_date date;

l_end_date date;

BEGIN

if (name_in('CALENDAR_TYPES.CALENDAR_TYPE') )= 'REP DEPRN CAL' then

l_period_name:= name_in('CALENDAR_PERIODS.PERIOD_NAME');

l_period_num := name_in('CALENDAR_PERIODS.PERIOD_NUM');

l_start_date := name_in('CALENDAR_PERIODS.START_DATE');

l_end_date := name_in('CALENDAR_PERIODS.END_DATE');