89:
90:
91: PROCEDURE set_print_options(req_id NUMBER) IS
92: BEGIN
93: hr_utility.trace ('Entering set_print_options');
94:
95: select number_of_copies,
96: printer,
97: print_style,
102: save_result
103: from fnd_concurrent_requests
104: where request_id = fnd_number.canonical_to_number(req_id);
105:
106: hr_utility.trace ('number_of_copies '||copies_buffer);
107: hr_utility.trace ('printer '||printer_buffer);
108: hr_utility.trace ('print_style '||style_buffer);
109: hr_utility.trace ('save_output_flag '||save_result);
110:
103: from fnd_concurrent_requests
104: where request_id = fnd_number.canonical_to_number(req_id);
105:
106: hr_utility.trace ('number_of_copies '||copies_buffer);
107: hr_utility.trace ('printer '||printer_buffer);
108: hr_utility.trace ('print_style '||style_buffer);
109: hr_utility.trace ('save_output_flag '||save_result);
110:
111: if (save_result='Y') then
104: where request_id = fnd_number.canonical_to_number(req_id);
105:
106: hr_utility.trace ('number_of_copies '||copies_buffer);
107: hr_utility.trace ('printer '||printer_buffer);
108: hr_utility.trace ('print_style '||style_buffer);
109: hr_utility.trace ('save_output_flag '||save_result);
110:
111: if (save_result='Y') then
112: save_buffer:=true;
105:
106: hr_utility.trace ('number_of_copies '||copies_buffer);
107: hr_utility.trace ('printer '||printer_buffer);
108: hr_utility.trace ('print_style '||style_buffer);
109: hr_utility.trace ('save_output_flag '||save_result);
110:
111: if (save_result='Y') then
112: save_buffer:=true;
113: elsif (save_result='N') then
125:
126: -- Bug 3487186 Added by ssmukher
127: set_notification := fnd_Request.USE_CURRENT_NOTIFICATION;
128:
129: hr_utility.trace ('Leaving set_print_options');
130:
131: END;
132:
133: BEGIN
132:
133: BEGIN
134:
135: lv_proc_name := 'PAY_AC_UTILITY.ARCHIVE_DEINIT';
136: hr_utility.trace ('Entering '|| lv_proc_name);
137: hr_utility.trace ('p_payroll_action_id '|| p_payroll_action_id);
138:
139: OPEN c_get_action_parameter('PRINT_FILES');
140: FETCH c_get_action_parameter
133: BEGIN
134:
135: lv_proc_name := 'PAY_AC_UTILITY.ARCHIVE_DEINIT';
136: hr_utility.trace ('Entering '|| lv_proc_name);
137: hr_utility.trace ('p_payroll_action_id '|| p_payroll_action_id);
138:
139: OPEN c_get_action_parameter('PRINT_FILES');
140: FETCH c_get_action_parameter
141: INTO p_print_files;
145: FETCH c_get_action_parameter
146: INTO p_xdo_run;
147: CLOSE c_get_action_parameter;
148:
149: hr_utility.trace ('p_xdo_run '|| p_xdo_run);
150: hr_utility.trace ('p_print_files '|| p_print_files);
151:
152: IF (p_xdo_run = 'N') and (p_print_files = 'N') THEN
153:
146: INTO p_xdo_run;
147: CLOSE c_get_action_parameter;
148:
149: hr_utility.trace ('p_xdo_run '|| p_xdo_run);
150: hr_utility.trace ('p_print_files '|| p_print_files);
151:
152: IF (p_xdo_run = 'N') and (p_print_files = 'N') THEN
153:
154:
177: CLOSE get_template_name;
178:
179: -- pay_archive.remove_report_actions(p_payroll_action_id);
180:
181: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
182: hr_utility.trace ('lv_template_code '|| lv_template_code);
183: hr_utility.trace ('ln_application_id '|| ln_application_id);
184: hr_utility.trace ('lv_template_type '|| lv_template_type);
185:
178:
179: -- pay_archive.remove_report_actions(p_payroll_action_id);
180:
181: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
182: hr_utility.trace ('lv_template_code '|| lv_template_code);
183: hr_utility.trace ('ln_application_id '|| ln_application_id);
184: hr_utility.trace ('lv_template_type '|| lv_template_type);
185:
186: set_print_options(ln_current_request_id);
179: -- pay_archive.remove_report_actions(p_payroll_action_id);
180:
181: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
182: hr_utility.trace ('lv_template_code '|| lv_template_code);
183: hr_utility.trace ('ln_application_id '|| ln_application_id);
184: hr_utility.trace ('lv_template_type '|| lv_template_type);
185:
186: set_print_options(ln_current_request_id);
187:
180:
181: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
182: hr_utility.trace ('lv_template_code '|| lv_template_code);
183: hr_utility.trace ('ln_application_id '|| ln_application_id);
184: hr_utility.trace ('lv_template_type '|| lv_template_type);
185:
186: set_print_options(ln_current_request_id);
187:
188: ln_req_id := fnd_request.submit_request
198: argument8 => lv_report_level, -- report_level
199: argument9 => 'STANDARD' -- report_level
200: );
201:
202: hr_utility.trace ('Submitted PAYGENXDOREP,ln_req_id '|| ln_req_id);
203:
204: request_list(ln_count) := ln_req_id;
205: ln_count := ln_count + 1;
206:
207:
208: END LOOP;
209:
210: END IF; /* print_files & xdo_run*/
211: hr_utility.trace ('Leaving '|| lv_proc_name);
212: end ARCHIVE_DEINIT;
213:
214: /* Procedure to remove data from pay_file_details*/
215: PROCEDURE del_file_details(pactid IN NUMBER) IS
260:
261: BEGIN
262: --
263: l_proc_name := 'PAY_CORE_XDO_UTILS.STANDARD_DEINIT';
264: hr_utility.trace ('Entering '|| l_proc_name);
265: request_list.delete;
266:
267: archive_deinit(pactid);
268: commit;
276: FETCH c_get_action_parameter
277: INTO l_xdo_run;
278: CLOSE c_get_action_parameter;
279:
280: hr_utility.trace ('l_xdo_run '|| l_xdo_run);
281: hr_utility.trace ('l_print_files '|| l_print_files);
282:
283: IF (l_xdo_run = 'N') and (l_print_files = 'N') THEN
284: loop
277: INTO l_xdo_run;
278: CLOSE c_get_action_parameter;
279:
280: hr_utility.trace ('l_xdo_run '|| l_xdo_run);
281: hr_utility.trace ('l_print_files '|| l_print_files);
282:
283: IF (l_xdo_run = 'N') and (l_print_files = 'N') THEN
284: loop
285: exit when not l_flag;
283: IF (l_xdo_run = 'N') and (l_print_files = 'N') THEN
284: loop
285: exit when not l_flag;
286: for i in request_list.first..request_list.last loop
287: hr_utility.trace ('request_list(i)'||request_list(i));
288: l_valid_request := fnd_concurrent.get_request_status(
289: request_id => request_list(i),
290: appl_shortname => 'PAY',
291: program => 'PAYGENXDOREPORT',
294: dev_phase => l_dev_phase,
295: dev_status => l_dev_status,
296: message => l_message);
297:
298: hr_utility.trace ('l_dev_phase '|| l_dev_phase);
299: if (l_valid_request and l_dev_phase not in ('PENDING', 'RUNNING')) then
300: hr_utility.trace ('In l_flag := FALSE');
301: l_flag := FALSE;
302: else
296: message => l_message);
297:
298: hr_utility.trace ('l_dev_phase '|| l_dev_phase);
299: if (l_valid_request and l_dev_phase not in ('PENDING', 'RUNNING')) then
300: hr_utility.trace ('In l_flag := FALSE');
301: l_flag := FALSE;
302: else
303: l_flag := TRUE;
304: hr_utility.trace ('In l_flag := TRUE');
300: hr_utility.trace ('In l_flag := FALSE');
301: l_flag := FALSE;
302: else
303: l_flag := TRUE;
304: hr_utility.trace ('In l_flag := TRUE');
305: exit;
306: end if;
307:
308: dbms_lock.sleep(20);
305: exit;
306: end if;
307:
308: dbms_lock.sleep(20);
309: hr_utility.trace ('Waiting for request completion...');
310:
311: end loop;
312: end loop;
313: hr_utility.trace ('All Requests Completed...');
309: hr_utility.trace ('Waiting for request completion...');
310:
311: end loop;
312: end loop;
313: hr_utility.trace ('All Requests Completed...');
314:
315: END IF; -- run_xdo = N and print_files = N
316: --
317: select pay_core_utils.get_parameter('REMOVE_ACT',
321: where pa1.payroll_action_id = pactid;
322: --
323: if (remove_act is null or remove_act = 'Y') then
324: del_file_details(pactid);
325: hr_utility.trace ('pay_file_details deleted');
326: pay_archive.remove_report_actions(pactid);
327: hr_utility.trace ('Removed Payroll and assignment actions');
328: end if;
329:
323: if (remove_act is null or remove_act = 'Y') then
324: del_file_details(pactid);
325: hr_utility.trace ('pay_file_details deleted');
326: pay_archive.remove_report_actions(pactid);
327: hr_utility.trace ('Removed Payroll and assignment actions');
328: end if;
329:
330: hr_utility.trace ('Leaving '|| l_proc_name);
331:
326: pay_archive.remove_report_actions(pactid);
327: hr_utility.trace ('Removed Payroll and assignment actions');
328: end if;
329:
330: hr_utility.trace ('Leaving '|| l_proc_name);
331:
332: END standard_deinit;
333:
334: