DBA Data[Home] [Help]

APPS.IEM_CONCURRENT_PVT dependencies on FND_FILE

Line 28: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));

24: INVALID_HOUR EXCEPTION;
25: INVALID_MINUTE EXCEPTION;
26: BEGIN
27:
28: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
29: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
30: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
31: fnd_file.put_line(fnd_file.log, 'p_schedule_retry = ' || p_schedule_retry);
32: fnd_file.put_line(fnd_file.log, 'p_hour = ' || to_char(p_hour));

Line 29: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));

25: INVALID_MINUTE EXCEPTION;
26: BEGIN
27:
28: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
29: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
30: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
31: fnd_file.put_line(fnd_file.log, 'p_schedule_retry = ' || p_schedule_retry);
32: fnd_file.put_line(fnd_file.log, 'p_hour = ' || to_char(p_hour));
33: fnd_file.put_line(fnd_file.log, 'p_minutes = ' || to_char(p_minutes));

Line 30: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));

26: BEGIN
27:
28: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
29: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
30: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
31: fnd_file.put_line(fnd_file.log, 'p_schedule_retry = ' || p_schedule_retry);
32: fnd_file.put_line(fnd_file.log, 'p_hour = ' || to_char(p_hour));
33: fnd_file.put_line(fnd_file.log, 'p_minutes = ' || to_char(p_minutes));
34:

Line 31: fnd_file.put_line(fnd_file.log, 'p_schedule_retry = ' || p_schedule_retry);

27:
28: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
29: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
30: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
31: fnd_file.put_line(fnd_file.log, 'p_schedule_retry = ' || p_schedule_retry);
32: fnd_file.put_line(fnd_file.log, 'p_hour = ' || to_char(p_hour));
33: fnd_file.put_line(fnd_file.log, 'p_minutes = ' || to_char(p_minutes));
34:
35: fnd_file.put_line(fnd_file.log, 'Starting Processing');

Line 32: fnd_file.put_line(fnd_file.log, 'p_hour = ' || to_char(p_hour));

28: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
29: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
30: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
31: fnd_file.put_line(fnd_file.log, 'p_schedule_retry = ' || p_schedule_retry);
32: fnd_file.put_line(fnd_file.log, 'p_hour = ' || to_char(p_hour));
33: fnd_file.put_line(fnd_file.log, 'p_minutes = ' || to_char(p_minutes));
34:
35: fnd_file.put_line(fnd_file.log, 'Starting Processing');
36:

Line 33: fnd_file.put_line(fnd_file.log, 'p_minutes = ' || to_char(p_minutes));

29: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
30: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
31: fnd_file.put_line(fnd_file.log, 'p_schedule_retry = ' || p_schedule_retry);
32: fnd_file.put_line(fnd_file.log, 'p_hour = ' || to_char(p_hour));
33: fnd_file.put_line(fnd_file.log, 'p_minutes = ' || to_char(p_minutes));
34:
35: fnd_file.put_line(fnd_file.log, 'Starting Processing');
36:
37: if p_schedule_retry = 'Y' then

Line 35: fnd_file.put_line(fnd_file.log, 'Starting Processing');

31: fnd_file.put_line(fnd_file.log, 'p_schedule_retry = ' || p_schedule_retry);
32: fnd_file.put_line(fnd_file.log, 'p_hour = ' || to_char(p_hour));
33: fnd_file.put_line(fnd_file.log, 'p_minutes = ' || to_char(p_minutes));
34:
35: fnd_file.put_line(fnd_file.log, 'Starting Processing');
36:
37: if p_schedule_retry = 'Y' then
38: if p_hour not between 0 and 23 then
39: raise INVALID_HOUR;

Line 51: fnd_file.put_line(fnd_file.log, 'Main Worker Request Id ' || to_char(l_request_id));

47: --Submitting the process that remains forever
48: --samir.hans commented out on 8/18/2000
49: /*l_request_id := fnd_request.submit_request('IEM', 'IEMADMWW', '','',FALSE,1,'F','T','MAILPREPROC','IEM_MAIL','FOREVER',p_number_of_msgs);
50:
51: fnd_file.put_line(fnd_file.log, 'Main Worker Request Id ' || to_char(l_request_id));
52:
53: if l_request_id = 0 then
54: rollback;
55: raise MAIN_WORKER_NOT_SUBMITTED;

Line 71: fnd_file.put_line(fnd_file.log, 'Worker number ' || to_char(i) || ' Request Id ' || to_char(l_request_id));

67: end if;
68:
69: l_request_id := fnd_request.submit_request('IEM', 'IEMADMWW', '','',FALSE,1,'F','T','MAILPREPROC','IEM_MAIL','NO_WAIT',p_number_of_msgs);
70:
71: fnd_file.put_line(fnd_file.log, 'Worker number ' || to_char(i) || ' Request Id ' || to_char(l_request_id));
72:
73: if l_request_id = 0 then
74: rollback;
75: raise WORKER_NOT_SUBMITTED;

Line 86: fnd_file.put_line(fnd_file.log, 'Retry process time ' || l_time_to_sch);

82: if (p_schedule_retry = 'Y') then
83:
84: l_time_to_sch := to_char(p_hour) || ':' || to_char(p_minutes);
85:
86: fnd_file.put_line(fnd_file.log, 'Retry process time ' || l_time_to_sch);
87:
88: l_call_status := fnd_request.set_repeat_options(repeat_time => l_time_to_sch);
89:
90: if not l_call_status then

Line 95: fnd_file.put_line(fnd_file.log, 'Retry repeat options set for retry process');

91: rollback;
92: raise REPEAT_OPTIONS_NOT_SET;
93: end if;
94:
95: fnd_file.put_line(fnd_file.log, 'Retry repeat options set for retry process');
96:
97: l_request_id := fnd_request.submit_request('IEM', 'IEMADMWR', '','',FALSE,1,'F','T','MAILPREPROC','IEM_MAIL');
98:
99: if l_request_id = 0 then

Line 106: fnd_file.put_line(fnd_file.log, 'Retry folders scheduled. Request id = ' || to_char(l_request_id));

102: else
103: commit;
104: end if;
105:
106: fnd_file.put_line(fnd_file.log, 'Retry folders scheduled. Request id = ' || to_char(l_request_id));
107:
108: end if;
109:
110:

Line 112: fnd_file.put_line(fnd_file.log, 'Controller Exited');

108: end if;
109:
110:
111: Commit work;
112: fnd_file.put_line(fnd_file.log, 'Controller Exited');
113:
114: EXCEPTION
115: WHEN INVALID_HOUR THEN
116: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_HOUR');

Line 118: fnd_file.put_line(fnd_file.log, l_Error_Message);

114: EXCEPTION
115: WHEN INVALID_HOUR THEN
116: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_HOUR');
117: l_Error_Message := FND_MESSAGE.GET;
118: fnd_file.put_line(fnd_file.log, l_Error_Message);
119: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
120:
121: WHEN INVALID_MINUTE THEN
122: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_MINUTE');

Line 124: fnd_file.put_line(fnd_file.log, l_Error_Message);

120:
121: WHEN INVALID_MINUTE THEN
122: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_MINUTE');
123: l_Error_Message := FND_MESSAGE.GET;
124: fnd_file.put_line(fnd_file.log, l_Error_Message);
125: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
126:
127: WHEN REPEAT_OPTIONS_NOT_SET THEN
128: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_REPEAT_OPTIONS_NOT_SET');

Line 130: fnd_file.put_line(fnd_file.log, l_Error_Message);

126:
127: WHEN REPEAT_OPTIONS_NOT_SET THEN
128: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_REPEAT_OPTIONS_NOT_SET');
129: l_Error_Message := FND_MESSAGE.GET;
130: fnd_file.put_line(fnd_file.log, l_Error_Message);
131: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
132:
133: WHEN MAIN_WORKER_NOT_SUBMITTED THEN
134: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_MAIN_WORKER_NOT_SUBMITTED');

Line 136: fnd_file.put_line(fnd_file.log, l_Error_Message);

132:
133: WHEN MAIN_WORKER_NOT_SUBMITTED THEN
134: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_MAIN_WORKER_NOT_SUBMITTED');
135: l_Error_Message := FND_MESSAGE.GET;
136: fnd_file.put_line(fnd_file.log, l_Error_Message);
137: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
138:
139: WHEN WORKER_NOT_SUBMITTED THEN
140: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_WORKER_NOT_SUBMITTED');

Line 142: fnd_file.put_line(fnd_file.log, l_Error_Message);

138:
139: WHEN WORKER_NOT_SUBMITTED THEN
140: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_WORKER_NOT_SUBMITTED');
141: l_Error_Message := FND_MESSAGE.GET;
142: fnd_file.put_line(fnd_file.log, l_Error_Message);
143: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
144:
145: WHEN RETRY_NOT_SUBMITTED THEN
146: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_RETRY_NOT_SUBMITTED');

Line 148: fnd_file.put_line(fnd_file.log, l_Error_Message);

144:
145: WHEN RETRY_NOT_SUBMITTED THEN
146: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_RETRY_NOT_SUBMITTED');
147: l_Error_Message := FND_MESSAGE.GET;
148: fnd_file.put_line(fnd_file.log, l_Error_Message);
149: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
150:
151: WHEN OTHERS THEN
152: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_UNXP_ERROR');

Line 154: fnd_file.put_line(fnd_file.log, l_Error_Message);

150:
151: WHEN OTHERS THEN
152: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_UNXP_ERROR');
153: l_Error_Message := FND_MESSAGE.GET;
154: fnd_file.put_line(fnd_file.log, l_Error_Message);
155: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
156: END StartProcess;
157:
158: PROCEDURE SyncFolder(ERRBUF OUT NOCOPY VARCHAR2,

Line 265: fnd_file.put_line(fnd_file.log, l_Error_Message);

261:
262: WHEN IM_AUTHENTICATION_FAILED THEN
263: FND_MESSAGE.SET_NAME('IEM','IM_AUTHENTICATION_FAILED');
264: l_Error_Message := FND_MESSAGE.GET;
265: fnd_file.put_line(fnd_file.log, l_Error_Message);
266: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
267:
268:
269: WHEN IM_CREATEFOLDER_FAILED THEN

Line 272: fnd_file.put_line(fnd_file.log, l_Error_Message);

268:
269: WHEN IM_CREATEFOLDER_FAILED THEN
270: FND_MESSAGE.SET_NAME('IEM','IM_CREATEFOLDER_FAILED');
271: l_Error_Message := FND_MESSAGE.GET;
272: fnd_file.put_line(fnd_file.log, l_Error_Message);
273: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
274:
275: end SyncFolder;
276: