157: exit;
158: END If;
159: END LOOP;
160: IF l_return IS NULL THEN
161: l_return := hr_api.g_number;
162: END IF;
163: hr_utility.set_location('Leaving:'||l_proc, 30);
164: RETURN l_return;
165:
185: exit;
186: END If;
187: END LOOP;
188: IF l_return IS NULL THEN
189: l_return := hr_api.g_varchar2;
190: END IF;
191: hr_utility.set_location('Leaving: '||l_proc,30);
192: RETURN l_return;
193:
212: exit;
213: END If;
214: END LOOP;
215: IF l_return IS NULL THEN
216: l_return := hr_api.g_date;
217: END IF;
218: hr_utility.set_location('Leaving: '||l_proc,30);
219: RETURN l_return;
220:
1660:
1661: --
1662: -- Ensure that all the mandatory arguments are not null
1663: --
1664: hr_api.mandatory_arg_error(p_api_name => l_proc
1665: ,p_argument => 'process_date'
1666: ,p_argument_value => p_process_date);
1667: hr_api.mandatory_arg_error(p_api_name => l_proc
1668: ,p_argument => 'operation_mode'
1663: --
1664: hr_api.mandatory_arg_error(p_api_name => l_proc
1665: ,p_argument => 'process_date'
1666: ,p_argument_value => p_process_date);
1667: hr_api.mandatory_arg_error(p_api_name => l_proc
1668: ,p_argument => 'operation_mode'
1669: ,p_argument_value => p_operation_mode);
1670:
1671: --