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

Line 48: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Rollback CDL parameters :' );

44: cnt NUMBER := 0;
45: BEGIN
46: fnd_msg_pub.initialize;
47:
48: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Rollback CDL parameters :' );
49: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type = ' || p_source_type);
50: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_code = ' || p_source_code);
51: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_payroll_id = ' || p_payroll_id);
52: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_time_period_id = ' || p_time_period_id);

Line 49: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type = ' || p_source_type);

45: BEGIN
46: fnd_msg_pub.initialize;
47:
48: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Rollback CDL parameters :' );
49: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type = ' || p_source_type);
50: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_code = ' || p_source_code);
51: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_payroll_id = ' || p_payroll_id);
52: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_time_period_id = ' || p_time_period_id);
53: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_batch_name = ' || p_batch_name);

Line 50: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_code = ' || p_source_code);

46: fnd_msg_pub.initialize;
47:
48: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Rollback CDL parameters :' );
49: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type = ' || p_source_type);
50: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_code = ' || p_source_code);
51: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_payroll_id = ' || p_payroll_id);
52: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_time_period_id = ' || p_time_period_id);
53: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_batch_name = ' || p_batch_name);
54:

Line 51: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_payroll_id = ' || p_payroll_id);

47:
48: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Rollback CDL parameters :' );
49: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type = ' || p_source_type);
50: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_code = ' || p_source_code);
51: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_payroll_id = ' || p_payroll_id);
52: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_time_period_id = ' || p_time_period_id);
53: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_batch_name = ' || p_batch_name);
54:
55: fnd_file.put_line(fnd_file.log,'');

Line 52: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_time_period_id = ' || p_time_period_id);

48: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Rollback CDL parameters :' );
49: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type = ' || p_source_type);
50: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_code = ' || p_source_code);
51: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_payroll_id = ' || p_payroll_id);
52: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_time_period_id = ' || p_time_period_id);
53: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_batch_name = ' || p_batch_name);
54:
55: fnd_file.put_line(fnd_file.log,'');
56:

Line 53: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_batch_name = ' || p_batch_name);

49: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type = ' || p_source_type);
50: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_code = ' || p_source_code);
51: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_payroll_id = ' || p_payroll_id);
52: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_time_period_id = ' || p_time_period_id);
53: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_batch_name = ' || p_batch_name);
54:
55: fnd_file.put_line(fnd_file.log,'');
56:
57:

Line 55: fnd_file.put_line(fnd_file.log,'');

51: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_payroll_id = ' || p_payroll_id);
52: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_time_period_id = ' || p_time_period_id);
53: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_batch_name = ' || p_batch_name);
54:
55: fnd_file.put_line(fnd_file.log,'');
56:
57:
58: OPEN payroll_control_cur;
59: LOOP

Line 103: fnd_file.put_line(fnd_file.log,'***** Completed Rollback Distribution Lines for ' || l_payroll_name || ' , ' || l_period_name);

99: dist_cr_amount = NULL,
100: cdl_payroll_action_id = NULL --- salary cap 4304623
101: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
102:
103: fnd_file.put_line(fnd_file.log,'***** Completed Rollback Distribution Lines for ' || l_payroll_name || ' , ' || l_period_name);
104:
105: END;
106: ELSE /* count(*) != 0 */
107: /* Though the payroll control record are having status N

Line 120: psp_message_s.print_error(p_mode => FND_FILE.LOG,

116: END;
117: END LOOP;
118: if l_deleted = FALSE
119: THEN
120: psp_message_s.print_error(p_mode => FND_FILE.LOG,
121: p_print_header => FND_API.G_TRUE);
122: END IF;
123: --Introduced For the Bug 2665152
124: retcode:=0;

Line 135: psp_message_s.print_error(p_mode => FND_FILE.LOG,

131: fnd_message.set_name('PSP','PSP_SQL_ERROR');
132: fnd_message.set_token('SQLERROR',sqlerrm);
133: fnd_msg_pub.add;
134: --For Bug 2665152 : Introduced the Error Message and assigned value to retcode
135: psp_message_s.print_error(p_mode => FND_FILE.LOG,
136: p_print_header => FND_API.G_TRUE);
137: retcode:=2;
138:
139: END delete_lines;