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.HR_H2PI_ERROR dependencies on FND_FILE

Line 25: fnd_file.put_line(FND_FILE.LOG, l_mesg);

21: --
22: BEGIN
23: IF p_table_name IS NULL THEN
24: l_mesg := 'The Parameter value for TABLE_NAME cannot be null';
25: fnd_file.put_line(FND_FILE.LOG, l_mesg);
26: RAISE INVALID_PARAM;
27: ELSIF p_message_level IS NULL THEN
28: l_mesg := 'The Parameter value for Message Level cannot be null';
29: fnd_file.put_line(FND_FILE.LOG, l_mesg);

Line 29: fnd_file.put_line(FND_FILE.LOG, l_mesg);

25: fnd_file.put_line(FND_FILE.LOG, l_mesg);
26: RAISE INVALID_PARAM;
27: ELSIF p_message_level IS NULL THEN
28: l_mesg := 'The Parameter value for Message Level cannot be null';
29: fnd_file.put_line(FND_FILE.LOG, l_mesg);
30: RAISE INVALID_PARAM;
31: ELSIF p_message_name IS NULL AND p_message_text IS NULL THEN
32: l_mesg := 'The Parameter value for Message Name and Message Text '||
33: 'cannot be null';

Line 34: fnd_file.put_line(FND_FILE.LOG, l_mesg);

30: RAISE INVALID_PARAM;
31: ELSIF p_message_name IS NULL AND p_message_text IS NULL THEN
32: l_mesg := 'The Parameter value for Message Name and Message Text '||
33: 'cannot be null';
34: fnd_file.put_line(FND_FILE.LOG, l_mesg);
35: RAISE INVALID_PARAM;
36: END IF;
37:
38: IF UPPER(p_message_level) = 'FATAL' OR

Line 76: fnd_file.put_line(FND_FILE.LOG, l_mesg);

72: END IF;
73:
74: EXCEPTION
75: WHEN INVALID_PARAM THEN
76: fnd_file.put_line(FND_FILE.LOG, l_mesg);
77: RAISE;
78: WHEN OTHERS THEN
79: fnd_file.put_line(FND_FILE.LOG, SQLERRM );
80: RAISE;

Line 79: fnd_file.put_line(FND_FILE.LOG, SQLERRM );

75: WHEN INVALID_PARAM THEN
76: fnd_file.put_line(FND_FILE.LOG, l_mesg);
77: RAISE;
78: WHEN OTHERS THEN
79: fnd_file.put_line(FND_FILE.LOG, SQLERRM );
80: RAISE;
81: END data_error;
82: --
83: --

Line 167: fnd_file.put_line(FND_FILE.LOG,

163: FROM per_business_groups
164: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN
167: fnd_file.put_line(FND_FILE.LOG,
168: 'FATAL - HR_H2PI_ERROR.GENERATE_ERROR_REPORT: ' ||
169: 'Invalid Business Group Id');
170: RAISE;
171: END;

Line 173: fnd_file.new_line(FND_FILE.LOG);

169: 'Invalid Business Group Id');
170: RAISE;
171: END;
172:
173: fnd_file.new_line(FND_FILE.LOG);
174: fnd_file.put_line(FND_FILE.LOG, 'Business Group: ' || l_to_business_group_name);
175: fnd_file.new_line(FND_FILE.LOG);
176: fnd_file.put_line(FND_FILE.LOG, 'Request Id: ' || hr_h2pi_upload.g_request_id);
177: --

Line 174: fnd_file.put_line(FND_FILE.LOG, 'Business Group: ' || l_to_business_group_name);

170: RAISE;
171: END;
172:
173: fnd_file.new_line(FND_FILE.LOG);
174: fnd_file.put_line(FND_FILE.LOG, 'Business Group: ' || l_to_business_group_name);
175: fnd_file.new_line(FND_FILE.LOG);
176: fnd_file.put_line(FND_FILE.LOG, 'Request Id: ' || hr_h2pi_upload.g_request_id);
177: --
178: l_from_client_id := hr_h2pi_upload.get_from_client_id;

Line 175: fnd_file.new_line(FND_FILE.LOG);

171: END;
172:
173: fnd_file.new_line(FND_FILE.LOG);
174: fnd_file.put_line(FND_FILE.LOG, 'Business Group: ' || l_to_business_group_name);
175: fnd_file.new_line(FND_FILE.LOG);
176: fnd_file.put_line(FND_FILE.LOG, 'Request Id: ' || hr_h2pi_upload.g_request_id);
177: --
178: l_from_client_id := hr_h2pi_upload.get_from_client_id;
179: FOR csr_rec IN csr_err_mesg LOOP

Line 176: fnd_file.put_line(FND_FILE.LOG, 'Request Id: ' || hr_h2pi_upload.g_request_id);

172:
173: fnd_file.new_line(FND_FILE.LOG);
174: fnd_file.put_line(FND_FILE.LOG, 'Business Group: ' || l_to_business_group_name);
175: fnd_file.new_line(FND_FILE.LOG);
176: fnd_file.put_line(FND_FILE.LOG, 'Request Id: ' || hr_h2pi_upload.g_request_id);
177: --
178: l_from_client_id := hr_h2pi_upload.get_from_client_id;
179: FOR csr_rec IN csr_err_mesg LOOP
180: IF csr_rec.table_name <> l_table_name then

Line 182: fnd_file.new_line(FND_FILE.LOG);

178: l_from_client_id := hr_h2pi_upload.get_from_client_id;
179: FOR csr_rec IN csr_err_mesg LOOP
180: IF csr_rec.table_name <> l_table_name then
181: l_table_name := csr_rec.table_name;
182: fnd_file.new_line(FND_FILE.LOG);
183: fnd_file.put_line(FND_FILE.LOG, 'Table_name: ' || csr_rec.table_name);
184: fnd_file.new_line(FND_FILE.LOG);
185: END IF;
186: -- Included the IF clause to check for encoded characters as set_encoded

Line 183: fnd_file.put_line(FND_FILE.LOG, 'Table_name: ' || csr_rec.table_name);

179: FOR csr_rec IN csr_err_mesg LOOP
180: IF csr_rec.table_name <> l_table_name then
181: l_table_name := csr_rec.table_name;
182: fnd_file.new_line(FND_FILE.LOG);
183: fnd_file.put_line(FND_FILE.LOG, 'Table_name: ' || csr_rec.table_name);
184: fnd_file.new_line(FND_FILE.LOG);
185: END IF;
186: -- Included the IF clause to check for encoded characters as set_encoded
187: -- returns null if the data is not encoded.

Line 184: fnd_file.new_line(FND_FILE.LOG);

180: IF csr_rec.table_name <> l_table_name then
181: l_table_name := csr_rec.table_name;
182: fnd_file.new_line(FND_FILE.LOG);
183: fnd_file.put_line(FND_FILE.LOG, 'Table_name: ' || csr_rec.table_name);
184: fnd_file.new_line(FND_FILE.LOG);
185: END IF;
186: -- Included the IF clause to check for encoded characters as set_encoded
187: -- returns null if the data is not encoded.
188: IF INSTR(csr_rec.message_name_encoded,fnd_global.local_chr(0)) > 0 THEN

Line 214: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN
212: null;
213: WHEN OTHERS THEN
214: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
215: END;
216: elsif upper(csr_rec.table_name) = 'HR_H2PI_LOCATIONS' then
217: BEGIN
218: SELECT location_code

Line 229: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: null;
228: WHEN OTHERS THEN
229: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
230: END;
231: elsif upper(csr_rec.table_name) = 'HR_H2PI_HR_ORGANIZATIONS' then
232: BEGIN
233: SELECT name

Line 245: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

241: EXCEPTION
242: WHEN NO_DATA_FOUND THEN
243: null;
244: WHEN OTHERS THEN
245: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
246: END;
247: elsif upper(csr_rec.table_name) = 'HR_H2PI_ASSIGNMENTS' then
248: BEGIN
249: SELECT assignment_number

Line 262: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

258: EXCEPTION
259: WHEN NO_DATA_FOUND THEN
260: null;
261: WHEN OTHERS THEN
262: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
263: END;
264: elsif upper(csr_rec.table_name) = 'HR_H2PI_ELEMENT_ENTRIES' then
265: BEGIN
266: SELECT asg.assignment_number,

Line 301: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: null;
300: WHEN OTHERS THEN
301: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
302: END;
303: elsif upper(csr_rec.table_name) = 'HR_H2PI_SALARIES' then
304: BEGIN
305: SELECT assignment_number

Line 327: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

323: EXCEPTION
324: WHEN NO_DATA_FOUND THEN
325: null;
326: WHEN OTHERS THEN
327: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
328: END;
329: elsif upper(csr_rec.table_name) = 'HR_H2PI_PAYMENT_METHODS' then
330: BEGIN
331: SELECT asg.assignment_number,

Line 361: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

357: EXCEPTION
358: WHEN NO_DATA_FOUND THEN
359: null;
360: WHEN OTHERS THEN
361: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
362: END;
363: elsif upper(csr_rec.table_name) = 'HR_H2PI_ORGANIZATION_CLASS' then
364: BEGIN
365: SELECT ogs.name,

Line 388: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

384: EXCEPTION
385: WHEN NO_DATA_FOUND THEN
386: null;
387: WHEN OTHERS THEN
388: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
389: END;
390: elsif upper(csr_rec.table_name) = 'HR_H2PI_ORGANIZATION_INFO' then
391: BEGIN
392: SELECT name,

Line 434: fnd_file.put_line(FND_FILE.LOG, SQLERRM );

430: EXCEPTION
431: WHEN NO_DATA_FOUND THEN
432: null;
433: WHEN OTHERS THEN
434: fnd_file.put_line(FND_FILE.LOG, SQLERRM );
435: END;
436: WHEN OTHERS THEN
437: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
438: END;

Line 437: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

433: WHEN OTHERS THEN
434: fnd_file.put_line(FND_FILE.LOG, SQLERRM );
435: END;
436: WHEN OTHERS THEN
437: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
438: END;
439: elsif upper(csr_rec.table_name) = 'HR_H2PI_ADDRESSES' then
440: BEGIN
441: SELECT em.last_name || ', ' || em.first_name

Line 460: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

456: EXCEPTION
457: WHEN NO_DATA_FOUND THEN
458: null;
459: WHEN OTHERS THEN
460: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
461: END;
462: elsif upper(csr_rec.table_name) = 'HR_H2PI_FEDERAL_TAX_RULES' then
463: BEGIN
464: SELECT asg.assignment_number

Line 483: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

479: EXCEPTION
480: WHEN NO_DATA_FOUND THEN
481: null;
482: WHEN OTHERS THEN
483: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
484: END;
485: elsif upper(csr_rec.table_name) = 'HR_H2PI_STATE_TAX_RULES' then
486: BEGIN
487: SELECT asg.assignment_number

Line 506: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

502: EXCEPTION
503: WHEN NO_DATA_FOUND THEN
504: null;
505: WHEN OTHERS THEN
506: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
507: END;
508: --
509: elsif upper(csr_rec.table_name) = 'HR_H2PI_COUNTY_TAX_RULES' then
510: BEGIN

Line 530: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

526: EXCEPTION
527: WHEN NO_DATA_FOUND THEN
528: null;
529: WHEN OTHERS THEN
530: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
531: END;
532: --
533: elsif upper(csr_rec.table_name) = 'HR_H2PI_CITY_TAX_RULES' then
534: BEGIN

Line 554: fnd_file.put_line(FND_FILE.LOG, SQLERRM);

550: EXCEPTION
551: WHEN NO_DATA_FOUND THEN
552: null;
553: WHEN OTHERS THEN
554: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
555: END;
556: --
557: end if;
558: -- code ends

Line 559: fnd_file.put_line(FND_FILE.LOG, l_text);

555: END;
556: --
557: end if;
558: -- code ends
559: fnd_file.put_line(FND_FILE.LOG, l_text);
560: fnd_message.clear;
561: END LOOP;
562: EXCEPTION
563: WHEN OTHERS THEN

Line 565: fnd_file.put_line(FND_FILE.LOG, SQLERRM );

561: END LOOP;
562: EXCEPTION
563: WHEN OTHERS THEN
564: fnd_message.clear;
565: fnd_file.put_line(FND_FILE.LOG, SQLERRM );
566: RAISE;
567: END generate_error_report;
568: END hr_h2pi_error;