eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_LOAD_HR_DATA dependencies on ERROR_STACK

Line 74: ERROR_STACK.PUSHMESSAGE('*****************','ICX');

70: WHERE employee_number = l_employee_number;
71:
72: EXCEPTION
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

Line 75: ERROR_STACK.PUSHMESSAGE('The employee or assignment information for '||l_last_name||' '||l_first_name||' could not be loaded','ICX');

71:
72: EXCEPTION
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');

Line 79: ERROR_STACK.PUSHMESSAGE(SQLCODE || ' ' ||SQLERRM,'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;
83:

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 97: IF (ERROR_STACK.GETMSGCOUNT > 0) THEN

93:
94: COMMIT;
95:
96: BEGIN
97: IF (ERROR_STACK.GETMSGCOUNT > 0) THEN
98: RAISE validation_error;
99: END IF;
100: END;
101:

Line 193: ERROR_STACK.PUSHMESSAGE('*****************','ICX');

189:
190:
191: EXCEPTION
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

Line 194: ERROR_STACK.PUSHMESSAGE('Location '||l_location_code || ' could not be loaded','ICX');

190:
191: EXCEPTION
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');

Line 198: ERROR_STACK.PUSHMESSAGE(SQLCODE || ' ' ||SQLERRM,'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;
202:

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'

Line 215: IF (ERROR_STACK.GETMSGCOUNT > 0) THEN

211:
212: COMMIT;
213:
214: BEGIN
215: IF (ERROR_STACK.GETMSGCOUNT > 0) THEN
216: RAISE validation_error;
217: END IF;
218: END;
219: