DBA Data[Home] [Help]

APPS.PAY_CORE_XDO_UTILS dependencies on HR_UTILITY

Line 95: hr_utility.trace ('Entering set_print_options');

91:
92:
93: PROCEDURE set_print_options(req_id NUMBER) IS
94: BEGIN
95: hr_utility.trace ('Entering set_print_options');
96:
97: select number_of_copies,
98: printer,
99: print_style,

Line 108: hr_utility.trace ('number_of_copies '||copies_buffer);

104: save_result
105: from fnd_concurrent_requests
106: where request_id = fnd_number.canonical_to_number(req_id);
107:
108: hr_utility.trace ('number_of_copies '||copies_buffer);
109: hr_utility.trace ('printer '||printer_buffer);
110: hr_utility.trace ('print_style '||style_buffer);
111: hr_utility.trace ('save_output_flag '||save_result);
112:

Line 109: hr_utility.trace ('printer '||printer_buffer);

105: from fnd_concurrent_requests
106: where request_id = fnd_number.canonical_to_number(req_id);
107:
108: hr_utility.trace ('number_of_copies '||copies_buffer);
109: hr_utility.trace ('printer '||printer_buffer);
110: hr_utility.trace ('print_style '||style_buffer);
111: hr_utility.trace ('save_output_flag '||save_result);
112:
113: if (save_result='Y') then

Line 110: hr_utility.trace ('print_style '||style_buffer);

106: where request_id = fnd_number.canonical_to_number(req_id);
107:
108: hr_utility.trace ('number_of_copies '||copies_buffer);
109: hr_utility.trace ('printer '||printer_buffer);
110: hr_utility.trace ('print_style '||style_buffer);
111: hr_utility.trace ('save_output_flag '||save_result);
112:
113: if (save_result='Y') then
114: save_buffer:=true;

Line 111: hr_utility.trace ('save_output_flag '||save_result);

107:
108: hr_utility.trace ('number_of_copies '||copies_buffer);
109: hr_utility.trace ('printer '||printer_buffer);
110: hr_utility.trace ('print_style '||style_buffer);
111: hr_utility.trace ('save_output_flag '||save_result);
112:
113: if (save_result='Y') then
114: save_buffer:=true;
115: elsif (save_result='N') then

Line 131: hr_utility.trace ('Leaving set_print_options');

127:
128: -- Bug 3487186 Added by ssmukher
129: set_notification := fnd_Request.USE_CURRENT_NOTIFICATION;
130:
131: hr_utility.trace ('Leaving set_print_options');
132:
133: END;
134:
135: BEGIN

Line 138: hr_utility.trace ('Entering '|| lv_proc_name);

134:
135: BEGIN
136:
137: lv_proc_name := 'PAY_AC_UTILITY.ARCHIVE_DEINIT';
138: hr_utility.trace ('Entering '|| lv_proc_name);
139: hr_utility.trace ('p_payroll_action_id '|| p_payroll_action_id);
140:
141: OPEN c_get_action_parameter('PRINT_FILES');
142: FETCH c_get_action_parameter

Line 139: hr_utility.trace ('p_payroll_action_id '|| p_payroll_action_id);

135: BEGIN
136:
137: lv_proc_name := 'PAY_AC_UTILITY.ARCHIVE_DEINIT';
138: hr_utility.trace ('Entering '|| lv_proc_name);
139: hr_utility.trace ('p_payroll_action_id '|| p_payroll_action_id);
140:
141: OPEN c_get_action_parameter('PRINT_FILES');
142: FETCH c_get_action_parameter
143: INTO p_print_files;

Line 157: hr_utility.trace ('p_xdo_run '|| p_xdo_run);

153: FETCH c_get_action_parameter
154: INTO p_logging;
155: CLOSE c_get_action_parameter;
156:
157: hr_utility.trace ('p_xdo_run '|| p_xdo_run);
158: hr_utility.trace ('p_print_files '|| p_print_files);
159: hr_utility.trace ('p_logging '|| p_logging);
160:
161: /*Added for bug 13794925*/

Line 158: hr_utility.trace ('p_print_files '|| p_print_files);

154: INTO p_logging;
155: CLOSE c_get_action_parameter;
156:
157: hr_utility.trace ('p_xdo_run '|| p_xdo_run);
158: hr_utility.trace ('p_print_files '|| p_print_files);
159: hr_utility.trace ('p_logging '|| p_logging);
160:
161: /*Added for bug 13794925*/
162: IF (nvl(instr(p_logging,'G'),0) > 0) THEN

Line 159: hr_utility.trace ('p_logging '|| p_logging);

155: CLOSE c_get_action_parameter;
156:
157: hr_utility.trace ('p_xdo_run '|| p_xdo_run);
158: hr_utility.trace ('p_print_files '|| p_print_files);
159: hr_utility.trace ('p_logging '|| p_logging);
160:
161: /*Added for bug 13794925*/
162: IF (nvl(instr(p_logging,'G'),0) > 0) THEN
163: debug_flag:='Y';

Line 195: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);

191: CLOSE get_template_name;
192:
193: -- pay_archive.remove_report_actions(p_payroll_action_id);
194:
195: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
196: hr_utility.trace ('lv_template_code '|| lv_template_code);
197: hr_utility.trace ('ln_application_id '|| ln_application_id);
198: hr_utility.trace ('lv_template_type '|| lv_template_type);
199:

Line 196: hr_utility.trace ('lv_template_code '|| lv_template_code);

192:
193: -- pay_archive.remove_report_actions(p_payroll_action_id);
194:
195: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
196: hr_utility.trace ('lv_template_code '|| lv_template_code);
197: hr_utility.trace ('ln_application_id '|| ln_application_id);
198: hr_utility.trace ('lv_template_type '|| lv_template_type);
199:
200: set_print_options(ln_current_request_id);

Line 197: hr_utility.trace ('ln_application_id '|| ln_application_id);

193: -- pay_archive.remove_report_actions(p_payroll_action_id);
194:
195: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
196: hr_utility.trace ('lv_template_code '|| lv_template_code);
197: hr_utility.trace ('ln_application_id '|| ln_application_id);
198: hr_utility.trace ('lv_template_type '|| lv_template_type);
199:
200: set_print_options(ln_current_request_id);
201:

Line 198: hr_utility.trace ('lv_template_type '|| lv_template_type);

194:
195: hr_utility.trace ('ln_current_request_id '|| ln_current_request_id);
196: hr_utility.trace ('lv_template_code '|| lv_template_code);
197: hr_utility.trace ('ln_application_id '|| ln_application_id);
198: hr_utility.trace ('lv_template_type '|| lv_template_type);
199:
200: set_print_options(ln_current_request_id);
201:
202: ln_req_id := fnd_request.submit_request

Line 216: hr_utility.trace ('Submitted PAYGENXDOREP,ln_req_id '|| ln_req_id);

212: argument8 => lv_report_level, -- report_level
213: argument9 => 'STANDARD' -- report_level
214: );
215:
216: hr_utility.trace ('Submitted PAYGENXDOREP,ln_req_id '|| ln_req_id);
217:
218: request_list(ln_count) := ln_req_id;
219: ln_count := ln_count + 1;
220:

Line 225: hr_utility.trace ('Leaving '|| lv_proc_name);

221:
222: END LOOP;
223:
224: END IF; /* print_files & xdo_run*/
225: hr_utility.trace ('Leaving '|| lv_proc_name);
226: end ARCHIVE_DEINIT;
227:
228: /* Procedure to remove data from pay_file_details*/
229: PROCEDURE del_file_details(pactid IN NUMBER) IS

Line 278: hr_utility.trace ('Entering '|| l_proc_name);

274:
275: BEGIN
276: --
277: l_proc_name := 'PAY_CORE_XDO_UTILS.STANDARD_DEINIT';
278: hr_utility.trace ('Entering '|| l_proc_name);
279: request_list.delete;
280:
281: archive_deinit(pactid);
282: commit;

Line 294: hr_utility.trace ('l_xdo_run '|| l_xdo_run);

290: FETCH c_get_action_parameter
291: INTO l_xdo_run;
292: CLOSE c_get_action_parameter;
293:
294: hr_utility.trace ('l_xdo_run '|| l_xdo_run);
295: hr_utility.trace ('l_print_files '|| l_print_files);
296:
297: IF (l_xdo_run = 'N') and (l_print_files = 'N') THEN
298: loop

Line 295: hr_utility.trace ('l_print_files '|| l_print_files);

291: INTO l_xdo_run;
292: CLOSE c_get_action_parameter;
293:
294: hr_utility.trace ('l_xdo_run '|| l_xdo_run);
295: hr_utility.trace ('l_print_files '|| l_print_files);
296:
297: IF (l_xdo_run = 'N') and (l_print_files = 'N') THEN
298: loop
299: exit when not l_flag;

Line 301: hr_utility.trace ('request_list(i)'||request_list(i));

297: IF (l_xdo_run = 'N') and (l_print_files = 'N') THEN
298: loop
299: exit when not l_flag;
300: for i in request_list.first..request_list.last loop
301: hr_utility.trace ('request_list(i)'||request_list(i));
302: l_valid_request := fnd_concurrent.get_request_status(
303: request_id => request_list(i),
304: appl_shortname => 'PAY',
305: program => 'PAYGENXDOREPORT',

Line 312: hr_utility.trace ('l_dev_phase '|| l_dev_phase);

308: dev_phase => l_dev_phase,
309: dev_status => l_dev_status,
310: message => l_message);
311:
312: hr_utility.trace ('l_dev_phase '|| l_dev_phase);
313: if (l_valid_request and l_dev_phase not in ('PENDING', 'RUNNING')) then
314: hr_utility.trace ('In l_flag := FALSE');
315: l_flag := FALSE;
316: else

Line 314: hr_utility.trace ('In l_flag := FALSE');

310: message => l_message);
311:
312: hr_utility.trace ('l_dev_phase '|| l_dev_phase);
313: if (l_valid_request and l_dev_phase not in ('PENDING', 'RUNNING')) then
314: hr_utility.trace ('In l_flag := FALSE');
315: l_flag := FALSE;
316: else
317: l_flag := TRUE;
318: hr_utility.trace ('In l_flag := TRUE');

Line 318: hr_utility.trace ('In l_flag := TRUE');

314: hr_utility.trace ('In l_flag := FALSE');
315: l_flag := FALSE;
316: else
317: l_flag := TRUE;
318: hr_utility.trace ('In l_flag := TRUE');
319: exit;
320: end if;
321:
322: dbms_lock.sleep(20);

Line 323: hr_utility.trace ('Waiting for request completion...');

319: exit;
320: end if;
321:
322: dbms_lock.sleep(20);
323: hr_utility.trace ('Waiting for request completion...');
324:
325: end loop;
326: end loop;
327: hr_utility.trace ('All Requests Completed...');

Line 327: hr_utility.trace ('All Requests Completed...');

323: hr_utility.trace ('Waiting for request completion...');
324:
325: end loop;
326: end loop;
327: hr_utility.trace ('All Requests Completed...');
328:
329: END IF; -- run_xdo = N and print_files = N
330: --
331: select pay_core_utils.get_parameter('REMOVE_ACT',

Line 339: hr_utility.trace ('pay_file_details deleted');

335: where pa1.payroll_action_id = pactid;
336: --
337: if (remove_act is null or remove_act = 'Y') then
338: del_file_details(pactid);
339: hr_utility.trace ('pay_file_details deleted');
340: pay_archive.remove_report_actions(pactid);
341: hr_utility.trace ('Removed Payroll and assignment actions');
342: end if;
343:

Line 341: hr_utility.trace ('Removed Payroll and assignment actions');

337: if (remove_act is null or remove_act = 'Y') then
338: del_file_details(pactid);
339: hr_utility.trace ('pay_file_details deleted');
340: pay_archive.remove_report_actions(pactid);
341: hr_utility.trace ('Removed Payroll and assignment actions');
342: end if;
343:
344: hr_utility.trace ('Leaving '|| l_proc_name);
345:

Line 344: hr_utility.trace ('Leaving '|| l_proc_name);

340: pay_archive.remove_report_actions(pactid);
341: hr_utility.trace ('Removed Payroll and assignment actions');
342: end if;
343:
344: hr_utility.trace ('Leaving '|| l_proc_name);
345:
346: END standard_deinit;
347:
348: