129: hr_utility.set_location ('Entering '||l_package,10);
130: savepoint pre_datapump_process;
131: --
132: --
133: fnd_file.put_line
134: (which => fnd_file.log,
135: buff => 'Before Pre Process call ');
136: --
137: FOR l_rec in c_api LOOP
130: savepoint pre_datapump_process;
131: --
132: --
133: fnd_file.put_line
134: (which => fnd_file.log,
135: buff => 'Before Pre Process call ');
136: --
137: FOR l_rec in c_api LOOP
138: --
135: buff => 'Before Pre Process call ');
136: --
137: FOR l_rec in c_api LOOP
138: --
139: fnd_file.put_line
140: (which => fnd_file.log,
141: buff => 'module_name :'||l_rec.module_name );
142: --
143: IF l_rec.module_name = 'CREATE_ENROLLMENT' THEN
136: --
137: FOR l_rec in c_api LOOP
138: --
139: fnd_file.put_line
140: (which => fnd_file.log,
141: buff => 'module_name :'||l_rec.module_name );
142: --
143: IF l_rec.module_name = 'CREATE_ENROLLMENT' THEN
144: --
162: );
163: --
164: END IF;
165: --
166: fnd_file.put_line
167: (which => fnd_file.log,
168: buff => 'After Call - module_name :'||l_rec.module_name );
169: --
170: END LOOP;
163: --
164: END IF;
165: --
166: fnd_file.put_line
167: (which => fnd_file.log,
168: buff => 'After Call - module_name :'||l_rec.module_name );
169: --
170: END LOOP;
171: --
172: -- Now lets call Data pump Process
173: --
174: hr_utility.set_location ('Before Submit Request '||l_package,20);
175: --
176: fnd_file.put_line
177: (which => fnd_file.log,
178: buff => 'Before Datapump Call');
179: --
180: l_request_id := fnd_request.submit_request
173: --
174: hr_utility.set_location ('Before Submit Request '||l_package,20);
175: --
176: fnd_file.put_line
177: (which => fnd_file.log,
178: buff => 'Before Datapump Call');
179: --
180: l_request_id := fnd_request.submit_request
181: (application => 'PER'
188: hr_utility.set_location ('After Submit Request '||l_package,30);
189: --
190: commit;
191: --
192: fnd_file.put_line
193: (which => fnd_file.log,
194: buff => 'After Datapump Call');
195: --
196: check_slaves_status(p_request_id => l_request_id
189: --
190: commit;
191: --
192: fnd_file.put_line
193: (which => fnd_file.log,
194: buff => 'After Datapump Call');
195: --
196: check_slaves_status(p_request_id => l_request_id
197: ,p_slave_errored => l_slave_errored);
197: ,p_slave_errored => l_slave_errored);
198: --
199: if l_slave_errored then
200: --
201: fnd_file.put_line
202: (which => fnd_file.log,
203: buff => 'Datapump Request '||l_request_id||' completed with error.');
204: fnd_file.put_line
205: (which => fnd_file.log,
198: --
199: if l_slave_errored then
200: --
201: fnd_file.put_line
202: (which => fnd_file.log,
203: buff => 'Datapump Request '||l_request_id||' completed with error.');
204: fnd_file.put_line
205: (which => fnd_file.log,
206: buff => 'Check the request log for error details.');
200: --
201: fnd_file.put_line
202: (which => fnd_file.log,
203: buff => 'Datapump Request '||l_request_id||' completed with error.');
204: fnd_file.put_line
205: (which => fnd_file.log,
206: buff => 'Check the request log for error details.');
207: --
208: else
201: fnd_file.put_line
202: (which => fnd_file.log,
203: buff => 'Datapump Request '||l_request_id||' completed with error.');
204: fnd_file.put_line
205: (which => fnd_file.log,
206: buff => 'Check the request log for error details.');
207: --
208: else
209: --
206: buff => 'Check the request log for error details.');
207: --
208: else
209: --
210: fnd_file.put_line
211: (which => fnd_file.log,
212: buff => 'Datapump Request '||l_request_id||' completed successfully.');
213: --
214: end if;
207: --
208: else
209: --
210: fnd_file.put_line
211: (which => fnd_file.log,
212: buff => 'Datapump Request '||l_request_id||' completed successfully.');
213: --
214: end if;
215: --