DBA Data[Home] [Help]

APPS.PAY_CORE_XDO_UTILS dependencies on HR_UTILITY

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

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,

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

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:

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

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

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

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;

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

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

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

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

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

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

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

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;

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

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:

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

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:

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

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:

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

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);

Line 183: hr_utility.trace ('ln_application_id '|| ln_application_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:

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

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

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

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:

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

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

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

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;

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

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

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

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;

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

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',

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

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

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

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');

Line 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);

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

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...');

Line 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',

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

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:

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

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:

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

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: