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.

[Home] [Help]

APPS.FND_SOA_UTIL dependencies on FND_FILE

Line 20: FND_FILE.put_line(FND_FILE.log, 'Start Date: '||start_date);

16: deleted_error_count NUMBER;
17: deleted_log_count NUMBER;
18: v_direction varchar2(15);
19: begin
20: FND_FILE.put_line(FND_FILE.log, 'Start Date: '||start_date);
21: FND_FILE.put_line(FND_FILE.log, 'End Date: '||end_date);
22: FND_FILE.put_line(FND_FILE.log, 'Module: '||module);
23:
24: v_strt_date := trunc(FND_CONC_DATE.STRING_TO_DATE(start_date),'DD');

Line 21: FND_FILE.put_line(FND_FILE.log, 'End Date: '||end_date);

17: deleted_log_count NUMBER;
18: v_direction varchar2(15);
19: begin
20: FND_FILE.put_line(FND_FILE.log, 'Start Date: '||start_date);
21: FND_FILE.put_line(FND_FILE.log, 'End Date: '||end_date);
22: FND_FILE.put_line(FND_FILE.log, 'Module: '||module);
23:
24: v_strt_date := trunc(FND_CONC_DATE.STRING_TO_DATE(start_date),'DD');
25: v_end_date :=trunc( FND_CONC_DATE.STRING_TO_DATE(end_date),'DD');

Line 22: FND_FILE.put_line(FND_FILE.log, 'Module: '||module);

18: v_direction varchar2(15);
19: begin
20: FND_FILE.put_line(FND_FILE.log, 'Start Date: '||start_date);
21: FND_FILE.put_line(FND_FILE.log, 'End Date: '||end_date);
22: FND_FILE.put_line(FND_FILE.log, 'Module: '||module);
23:
24: v_strt_date := trunc(FND_CONC_DATE.STRING_TO_DATE(start_date),'DD');
25: v_end_date :=trunc( FND_CONC_DATE.STRING_TO_DATE(end_date),'DD');
26: v_end_date := v_end_date +1;

Line 31: FND_FILE.put_line(FND_FILE.log,errbuf);

27: IF(v_strt_date is NULL) then
28: errbuf := 'Unexpected error converting character string to date:'
29: ||start_date;
30: retcode := '2';
31: FND_FILE.put_line(FND_FILE.log,errbuf);
32: RETURN;
33: END IF;
34: IF(v_end_date is NULL) then
35: errbuf := 'Unexpected error converting character string to date:'

Line 38: FND_FILE.put_line(FND_FILE.log,errbuf);

34: IF(v_end_date is NULL) then
35: errbuf := 'Unexpected error converting character string to date:'
36: ||end_date;
37: retcode := '2';
38: FND_FILE.put_line(FND_FILE.log,errbuf);
39: RETURN;
40: END IF;
41:
42: if (module = 'INVOKER') then

Line 50: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_LOG_MESSAGES - '||deleted_log_count);

46: end if;
47:
48: /* Purge Function to delete obsoleted Log Data */
49: deleted_log_count := delete_log_by_date_range(v_strt_date,v_end_date, v_direction);
50: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_LOG_MESSAGES - '||deleted_log_count);
51:
52: /* Purge Function to delete all requests Data */
53: deleted_requests_count := delete_requests_by_date_range(v_direction,v_strt_date,v_end_date);
54: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_REQUEST - '||deleted_requests_count);

Line 54: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_REQUEST - '||deleted_requests_count);

50: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_LOG_MESSAGES - '||deleted_log_count);
51:
52: /* Purge Function to delete all requests Data */
53: deleted_requests_count := delete_requests_by_date_range(v_direction,v_strt_date,v_end_date);
54: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_REQUEST - '||deleted_requests_count);
55:
56: /* Purge Function to delete all method Data */
57: deleted_method_count := delete_method_by_date_range(v_strt_date,v_end_date);
58: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RESPONSE_METHOD - '||deleted_method_count);

Line 58: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RESPONSE_METHOD - '||deleted_method_count);

54: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_REQUEST - '||deleted_requests_count);
55:
56: /* Purge Function to delete all method Data */
57: deleted_method_count := delete_method_by_date_range(v_strt_date,v_end_date);
58: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RESPONSE_METHOD - '||deleted_method_count);
59:
60: /* Purge Function to delete all attachment Data */
61: deleted_att_count := delete_att_by_date_range(v_strt_date,v_end_date);
62: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_ATTACHMENT - '||deleted_att_count);

Line 62: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_ATTACHMENT - '||deleted_att_count);

58: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RESPONSE_METHOD - '||deleted_method_count);
59:
60: /* Purge Function to delete all attachment Data */
61: deleted_att_count := delete_att_by_date_range(v_strt_date,v_end_date);
62: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_ATTACHMENT - '||deleted_att_count);
63:
64: /* Purge Function to delete all attachment body Data */
65: deleted_att_count := delete_body_by_date_range(v_strt_date,v_end_date);
66: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_BODY_PIECE - '||deleted_att_count);

Line 66: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_BODY_PIECE - '||deleted_att_count);

62: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_ATTACHMENT - '||deleted_att_count);
63:
64: /* Purge Function to delete all attachment body Data */
65: deleted_att_count := delete_body_by_date_range(v_strt_date,v_end_date);
66: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_BODY_PIECE - '||deleted_att_count);
67:
68: /* Purge Function to delete all Error Data */
69: deleted_error_count := delete_error_by_date_range(v_strt_date,v_end_date);
70: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RUNTIME_ERROR - '||deleted_error_count);

Line 70: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RUNTIME_ERROR - '||deleted_error_count);

66: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_BODY_PIECE - '||deleted_att_count);
67:
68: /* Purge Function to delete all Error Data */
69: deleted_error_count := delete_error_by_date_range(v_strt_date,v_end_date);
70: FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RUNTIME_ERROR - '||deleted_error_count);
71:
72: errbuf := '';
73: retcode := '0';
74:

Line 116: fnd_file.put_line(fnd_file.output,'Deleted '|| rowcount ||' rows from FND_SOA_REQUEST ');

112: RAISE;
113: END IF;
114: END;
115: END LOOP;
116: fnd_file.put_line(fnd_file.output,'Deleted '|| rowcount ||' rows from FND_SOA_REQUEST ');
117: RETURN rowcount;
118:
119: END;
120:

Line 152: fnd_file.put_line(fnd_file.output,

148: RAISE;
149: END IF;
150: END;
151: END LOOP;
152: fnd_file.put_line(fnd_file.output,
153: 'Deleted '|| rowcount ||' rows from FND_SOA_RESPONSE_METHOD ');
154: RETURN rowcount;
155: END;
156:

Line 188: fnd_file.put_line(fnd_file.output,

184: RAISE;
185: END IF;
186: END;
187: END LOOP;
188: fnd_file.put_line(fnd_file.output,
189: 'Deleted '|| rowcount ||' rows from FND_SOA_ATTACHMENT');
190: RETURN rowcount;
191: END;
192:

Line 227: fnd_file.put_line(fnd_file.output,

223: RAISE;
224: END IF;
225: END;
226: END LOOP;
227: fnd_file.put_line(fnd_file.output,
228: 'Deleted '|| rowcount ||' rows from FND_SOA_BODY_PIECE');
229: RETURN rowcount;
230: END;
231:

Line 263: fnd_file.put_line(fnd_file.output,

259: RAISE;
260: END IF;
261: END;
262: END LOOP;
263: fnd_file.put_line(fnd_file.output,
264: 'Deleted '|| rowcount ||' rows from FND_SOA_RUNTIME_ERROR');
265: RETURN rowcount;
266: END;
267:

Line 308: fnd_file.put_line(fnd_file.output,

304: RAISE;
305: END IF;
306: END;
307: END LOOP;
308: fnd_file.put_line(fnd_file.output,
309: 'Deleted '|| rowcount ||' rows from FND_LOG_MESSAGES');
310: RETURN rowcount;
311: END;
312: