APPS.POR_LOAD_HR_DATA dependencies on HR_UTILITY

Line 77: IF (hr_utility.get_message() IS NULL OR

73: WHEN OTHERS THEN
74: ERROR_STACK.PUSHMESSAGE('*****************','ICX');
75: ERROR_STACK.PUSHMESSAGE('The employee or assignment information for '||l_last_name||' '||l_first_name||' could not be loaded','ICX');
76:
77: IF (hr_utility.get_message() IS NULL OR
78: hr_utility.get_message() = '') THEN
79: ERROR_STACK.PUSHMESSAGE(SQLCODE || ' ' ||SQLERRM,'ICX');
80: ELSE
81: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');

Line 78: hr_utility.get_message() = '') THEN

74: ERROR_STACK.PUSHMESSAGE('*****************','ICX');
75: ERROR_STACK.PUSHMESSAGE('The employee or assignment information for '||l_last_name||' '||l_first_name||' could not be loaded','ICX');
76:
77: IF (hr_utility.get_message() IS NULL OR
78: hr_utility.get_message() = '') THEN
79: ERROR_STACK.PUSHMESSAGE(SQLCODE || ' ' ||SQLERRM,'ICX');
80: ELSE
81: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');
82: END IF;

Line 81: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');

77: IF (hr_utility.get_message() IS NULL OR
78: hr_utility.get_message() = '') THEN
79: ERROR_STACK.PUSHMESSAGE(SQLCODE || ' ' ||SQLERRM,'ICX');
80: ELSE
81: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');
82: END IF;
83:
84: UPDATE por_employee_loader_values
85: SET loader_status = 'failure'

Line 196: IF (hr_utility.get_message() IS NULL OR

192: WHEN OTHERS THEN
193: ERROR_STACK.PUSHMESSAGE('*****************','ICX');
194: ERROR_STACK.PUSHMESSAGE('Location '||l_location_code || ' could not be loaded','ICX');
195:
196: IF (hr_utility.get_message() IS NULL OR
197: hr_utility.get_message() = '') THEN
198: ERROR_STACK.PUSHMESSAGE(SQLCODE || ' ' ||SQLERRM,'ICX');
199: ELSE
200: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');

Line 197: hr_utility.get_message() = '') THEN

193: ERROR_STACK.PUSHMESSAGE('*****************','ICX');
194: ERROR_STACK.PUSHMESSAGE('Location '||l_location_code || ' could not be loaded','ICX');
195:
196: IF (hr_utility.get_message() IS NULL OR
197: hr_utility.get_message() = '') THEN
198: ERROR_STACK.PUSHMESSAGE(SQLCODE || ' ' ||SQLERRM,'ICX');
199: ELSE
200: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');
201: END IF;

Line 200: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');

196: IF (hr_utility.get_message() IS NULL OR
197: hr_utility.get_message() = '') THEN
198: ERROR_STACK.PUSHMESSAGE(SQLCODE || ' ' ||SQLERRM,'ICX');
199: ELSE
200: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');
201: END IF;
202:
203: UPDATE por_location_loader_values
204: SET loader_status = 'failure'