1141: BEGIN
1142: hr_utility.set_location(' Leaving:'||l_proc, 10);
1143:
1144: if p_mass_update_flag = 'N' then
1145: hr_multi_message.enable_message_list;
1146: end if;
1147:
1148: OPEN csr_cert_enrl;
1149: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
1177:
1178: hr_utility.set_location(' Leaving:'||l_proc, 20);
1179:
1180: if p_mass_update_flag = 'N' then
1181: l_return_status := hr_multi_message.get_return_status_disable;
1182: end if;
1183:
1184: return l_return_status;
1185:
1188: WHEN app_exception.application_exception THEN
1189: hr_utility.set_location(' Leaving:'||l_proc, 25);
1190:
1191: if p_mass_update_flag = 'N' then
1192: if hr_multi_message.exception_add(p_associated_column1 => 'OTA_CERT_PRD_ENROLLMENTS.CERT_PERIOD_END_DATE') then
1193: return hr_multi_message.get_return_status_disable;
1194: end if;
1195: l_return_status := hr_multi_message.get_return_status_disable;
1196: else
1189: hr_utility.set_location(' Leaving:'||l_proc, 25);
1190:
1191: if p_mass_update_flag = 'N' then
1192: if hr_multi_message.exception_add(p_associated_column1 => 'OTA_CERT_PRD_ENROLLMENTS.CERT_PERIOD_END_DATE') then
1193: return hr_multi_message.get_return_status_disable;
1194: end if;
1195: l_return_status := hr_multi_message.get_return_status_disable;
1196: else
1197: l_return_status := 'E';
1191: if p_mass_update_flag = 'N' then
1192: if hr_multi_message.exception_add(p_associated_column1 => 'OTA_CERT_PRD_ENROLLMENTS.CERT_PERIOD_END_DATE') then
1193: return hr_multi_message.get_return_status_disable;
1194: end if;
1195: l_return_status := hr_multi_message.get_return_status_disable;
1196: else
1197: l_return_status := 'E';
1198: end if;
1199:
1201:
1202: WHEN others THEN
1203: hr_utility.set_location('Leaving :'||l_proc,30);
1204: if p_mass_update_flag = 'N' then
1205: l_return_status := hr_multi_message.get_return_status_disable;
1206: else
1207: l_return_status := 'E';
1208: end if;
1209: