183: END LOOP;
184: CLOSE c_element_set;
185: END LOOP;
186: CLOSE c_assignments;
187: l_message_count := per_accrual_message_pkg.count_messages;
188:
189: for i in 1..l_message_count loop
190: l_message := per_accrual_message_pkg.get_message(i);
191: if (l_message is not null and (l_message = 'HR_52797_PTO_FML_ACT_ACCRUAL' or l_message = 'HR_52793_PTO_FML_ASG_INELIG') or l_message ='HR_52795_PTO_FML_CALC_DATE') Then
186: CLOSE c_assignments;
187: l_message_count := per_accrual_message_pkg.count_messages;
188:
189: for i in 1..l_message_count loop
190: l_message := per_accrual_message_pkg.get_message(i);
191: if (l_message is not null and (l_message = 'HR_52797_PTO_FML_ACT_ACCRUAL' or l_message = 'HR_52793_PTO_FML_ASG_INELIG') or l_message ='HR_52795_PTO_FML_CALC_DATE') Then
192: p_error_message := l_message;
193: end if;
194: end loop;
191: if (l_message is not null and (l_message = 'HR_52797_PTO_FML_ACT_ACCRUAL' or l_message = 'HR_52793_PTO_FML_ASG_INELIG') or l_message ='HR_52795_PTO_FML_CALC_DATE') Then
192: p_error_message := l_message;
193: end if;
194: end loop;
195: per_accrual_message_pkg.clear_table;
196:
197: END GET_ACCRUAL_BALANCES;
198: function IsTerminatedEmployee(p_resource_id IN NUMBER,
199: p_evaluation_date IN DATE)