20: PROCEDURE refresh_all (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2)
21: IS
22:
23: BEGIN
24: fnd_file.put_line(fnd_file.log, 'OAM Chart Collection, Refreshing All ...');
25:
26: fnd_file.put_line(fnd_file.log, 'Refreshing concurrent requests status ...');
27: refresh_req_status;
28: fnd_file.new_line(fnd_file.log, 1);
22:
23: BEGIN
24: fnd_file.put_line(fnd_file.log, 'OAM Chart Collection, Refreshing All ...');
25:
26: fnd_file.put_line(fnd_file.log, 'Refreshing concurrent requests status ...');
27: refresh_req_status;
28: fnd_file.new_line(fnd_file.log, 1);
29:
30: fnd_file.put_line(fnd_file.log, 'Refreshing completed requests status ...');
24: fnd_file.put_line(fnd_file.log, 'OAM Chart Collection, Refreshing All ...');
25:
26: fnd_file.put_line(fnd_file.log, 'Refreshing concurrent requests status ...');
27: refresh_req_status;
28: fnd_file.new_line(fnd_file.log, 1);
29:
30: fnd_file.put_line(fnd_file.log, 'Refreshing completed requests status ...');
31: refresh_completed_req_status;
32: fnd_file.new_line(fnd_file.log, 1);
26: fnd_file.put_line(fnd_file.log, 'Refreshing concurrent requests status ...');
27: refresh_req_status;
28: fnd_file.new_line(fnd_file.log, 1);
29:
30: fnd_file.put_line(fnd_file.log, 'Refreshing completed requests status ...');
31: refresh_completed_req_status;
32: fnd_file.new_line(fnd_file.log, 1);
33:
34: fnd_file.put_line(fnd_file.log, 'Refreshing pending requests status ...');
28: fnd_file.new_line(fnd_file.log, 1);
29:
30: fnd_file.put_line(fnd_file.log, 'Refreshing completed requests status ...');
31: refresh_completed_req_status;
32: fnd_file.new_line(fnd_file.log, 1);
33:
34: fnd_file.put_line(fnd_file.log, 'Refreshing pending requests status ...');
35: refresh_pending_req_status;
36: fnd_file.new_line(fnd_file.log, 1);
30: fnd_file.put_line(fnd_file.log, 'Refreshing completed requests status ...');
31: refresh_completed_req_status;
32: fnd_file.new_line(fnd_file.log, 1);
33:
34: fnd_file.put_line(fnd_file.log, 'Refreshing pending requests status ...');
35: refresh_pending_req_status;
36: fnd_file.new_line(fnd_file.log, 1);
37:
38: fnd_file.put_line(fnd_file.log, 'Refreshing running requests duration ...');
32: fnd_file.new_line(fnd_file.log, 1);
33:
34: fnd_file.put_line(fnd_file.log, 'Refreshing pending requests status ...');
35: refresh_pending_req_status;
36: fnd_file.new_line(fnd_file.log, 1);
37:
38: fnd_file.put_line(fnd_file.log, 'Refreshing running requests duration ...');
39: refresh_running_req_duration;
40: fnd_file.new_line(fnd_file.log, 1);
34: fnd_file.put_line(fnd_file.log, 'Refreshing pending requests status ...');
35: refresh_pending_req_status;
36: fnd_file.new_line(fnd_file.log, 1);
37:
38: fnd_file.put_line(fnd_file.log, 'Refreshing running requests duration ...');
39: refresh_running_req_duration;
40: fnd_file.new_line(fnd_file.log, 1);
41:
42: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by user ...');
36: fnd_file.new_line(fnd_file.log, 1);
37:
38: fnd_file.put_line(fnd_file.log, 'Refreshing running requests duration ...');
39: refresh_running_req_duration;
40: fnd_file.new_line(fnd_file.log, 1);
41:
42: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by user ...');
43: refresh_running_req_user;
44: fnd_file.new_line(fnd_file.log, 1);
38: fnd_file.put_line(fnd_file.log, 'Refreshing running requests duration ...');
39: refresh_running_req_duration;
40: fnd_file.new_line(fnd_file.log, 1);
41:
42: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by user ...');
43: refresh_running_req_user;
44: fnd_file.new_line(fnd_file.log, 1);
45:
46: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by application ...');
40: fnd_file.new_line(fnd_file.log, 1);
41:
42: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by user ...');
43: refresh_running_req_user;
44: fnd_file.new_line(fnd_file.log, 1);
45:
46: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by application ...');
47: refresh_running_req_app;
48: fnd_file.new_line(fnd_file.log, 1);
42: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by user ...');
43: refresh_running_req_user;
44: fnd_file.new_line(fnd_file.log, 1);
45:
46: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by application ...');
47: refresh_running_req_app;
48: fnd_file.new_line(fnd_file.log, 1);
49:
50: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by responsibility ...');
44: fnd_file.new_line(fnd_file.log, 1);
45:
46: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by application ...');
47: refresh_running_req_app;
48: fnd_file.new_line(fnd_file.log, 1);
49:
50: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by responsibility ...');
51: refresh_running_req_resp;
52: fnd_file.new_line(fnd_file.log, 1);
46: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by application ...');
47: refresh_running_req_app;
48: fnd_file.new_line(fnd_file.log, 1);
49:
50: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by responsibility ...');
51: refresh_running_req_resp;
52: fnd_file.new_line(fnd_file.log, 1);
53:
54: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by user ...');
48: fnd_file.new_line(fnd_file.log, 1);
49:
50: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by responsibility ...');
51: refresh_running_req_resp;
52: fnd_file.new_line(fnd_file.log, 1);
53:
54: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by user ...');
55: refresh_pending_req_user;
56: fnd_file.new_line(fnd_file.log, 1);
50: fnd_file.put_line(fnd_file.log, 'Refreshing running request counts grouped by responsibility ...');
51: refresh_running_req_resp;
52: fnd_file.new_line(fnd_file.log, 1);
53:
54: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by user ...');
55: refresh_pending_req_user;
56: fnd_file.new_line(fnd_file.log, 1);
57:
58: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by application ...');
52: fnd_file.new_line(fnd_file.log, 1);
53:
54: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by user ...');
55: refresh_pending_req_user;
56: fnd_file.new_line(fnd_file.log, 1);
57:
58: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by application ...');
59: refresh_pending_req_app;
60: fnd_file.new_line(fnd_file.log, 1);
54: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by user ...');
55: refresh_pending_req_user;
56: fnd_file.new_line(fnd_file.log, 1);
57:
58: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by application ...');
59: refresh_pending_req_app;
60: fnd_file.new_line(fnd_file.log, 1);
61:
62: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by responsibility ...');
56: fnd_file.new_line(fnd_file.log, 1);
57:
58: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by application ...');
59: refresh_pending_req_app;
60: fnd_file.new_line(fnd_file.log, 1);
61:
62: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by responsibility ...');
63: refresh_pending_req_resp;
64: fnd_file.new_line(fnd_file.log, 1);
58: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by application ...');
59: refresh_pending_req_app;
60: fnd_file.new_line(fnd_file.log, 1);
61:
62: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by responsibility ...');
63: refresh_pending_req_resp;
64: fnd_file.new_line(fnd_file.log, 1);
65:
66: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by manager ...');
60: fnd_file.new_line(fnd_file.log, 1);
61:
62: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by responsibility ...');
63: refresh_pending_req_resp;
64: fnd_file.new_line(fnd_file.log, 1);
65:
66: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by manager ...');
67: refresh_pend_req_mgr;
68: fnd_file.new_line(fnd_file.log, 1);
62: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by responsibility ...');
63: refresh_pending_req_resp;
64: fnd_file.new_line(fnd_file.log, 1);
65:
66: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by manager ...');
67: refresh_pend_req_mgr;
68: fnd_file.new_line(fnd_file.log, 1);
69:
70: fnd_file.put_line(fnd_file.log, 'Refreshing running request and process counts grouped by responsibility ...');
64: fnd_file.new_line(fnd_file.log, 1);
65:
66: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by manager ...');
67: refresh_pend_req_mgr;
68: fnd_file.new_line(fnd_file.log, 1);
69:
70: fnd_file.put_line(fnd_file.log, 'Refreshing running request and process counts grouped by responsibility ...');
71: refresh_run_req_process_mgr;
72: fnd_file.new_line(fnd_file.log, 1);
66: fnd_file.put_line(fnd_file.log, 'Refreshing pending request counts grouped by manager ...');
67: refresh_pend_req_mgr;
68: fnd_file.new_line(fnd_file.log, 1);
69:
70: fnd_file.put_line(fnd_file.log, 'Refreshing running request and process counts grouped by responsibility ...');
71: refresh_run_req_process_mgr;
72: fnd_file.new_line(fnd_file.log, 1);
73:
74: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by user ...');
68: fnd_file.new_line(fnd_file.log, 1);
69:
70: fnd_file.put_line(fnd_file.log, 'Refreshing running request and process counts grouped by responsibility ...');
71: refresh_run_req_process_mgr;
72: fnd_file.new_line(fnd_file.log, 1);
73:
74: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by user ...');
75: refresh_req_stats_user;
76: fnd_file.new_line(fnd_file.log, 1);
70: fnd_file.put_line(fnd_file.log, 'Refreshing running request and process counts grouped by responsibility ...');
71: refresh_run_req_process_mgr;
72: fnd_file.new_line(fnd_file.log, 1);
73:
74: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by user ...');
75: refresh_req_stats_user;
76: fnd_file.new_line(fnd_file.log, 1);
77:
78: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by program ...');
72: fnd_file.new_line(fnd_file.log, 1);
73:
74: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by user ...');
75: refresh_req_stats_user;
76: fnd_file.new_line(fnd_file.log, 1);
77:
78: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by program ...');
79: refresh_req_stats_program;
80: fnd_file.new_line(fnd_file.log, 1);
74: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by user ...');
75: refresh_req_stats_user;
76: fnd_file.new_line(fnd_file.log, 1);
77:
78: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by program ...');
79: refresh_req_stats_program;
80: fnd_file.new_line(fnd_file.log, 1);
81:
82: fnd_file.put_line(fnd_file.log, 'Done refreshing All ...');
76: fnd_file.new_line(fnd_file.log, 1);
77:
78: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by program ...');
79: refresh_req_stats_program;
80: fnd_file.new_line(fnd_file.log, 1);
81:
82: fnd_file.put_line(fnd_file.log, 'Done refreshing All ...');
83:
84: EXCEPTION
78: fnd_file.put_line(fnd_file.log, 'Refreshing the Concurrent requests statististics by program ...');
79: refresh_req_stats_program;
80: fnd_file.new_line(fnd_file.log, 1);
81:
82: fnd_file.put_line(fnd_file.log, 'Done refreshing All ...');
83:
84: EXCEPTION
85: when others then
86: retcode := '2';