21: */
22: --
23: --Globals
24: --
25: g_debug boolean := hr_utility.debug_enabled;
26: --
27: --
28: procedure check_slaves_status
29: (p_request_id in number
49: l_slaves c_slaves%rowtype;
50: --
51: begin
52: --
53: hr_utility.set_location ('Entering '||l_package,10);
54: --
55: --
56: l_no_slaves := true;
57: --
92: end loop;
93: --
94: p_slave_errored := l_slave_errored ;
95: --
96: hr_utility.set_location ('Leaving '||l_package,10);
97: --
98: commit;
99: --
100: end check_slaves_status;
125: --Find out the HRDPP information from batch_id
126: --Now call the appropriate procedure.
127: --once the call is completed, successfully, submit DATAPUMP request
128: --
129: hr_utility.set_location ('Entering '||l_package,10);
130: savepoint pre_datapump_process;
131: --
132: --
133: fnd_file.put_line
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');
184: ,sub_request => FALSE
185: ,argument1 => p_batch_id
186: ,argument2 => p_validate );
187: --
188: hr_utility.set_location ('After Submit Request '||l_package,30);
189: --
190: commit;
191: --
192: fnd_file.put_line
212: buff => 'Datapump Request '||l_request_id||' completed successfully.');
213: --
214: end if;
215: --
216: hr_utility.set_location ('Leaving '||l_package,40);
217: --
218: exception when others then
219: raise ;
220: end pre_datapump_process ;