DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_AMEND_SETUP dependencies on HR_UTILITY

Line 17: hr_utility.trace(l_package_name||'range_code - Start');

13: , p_sql out nocopy varchar2 )
14: is
15: begin
16: if g_debug then
17: hr_utility.trace(l_package_name||'range_code - Start');
18: end if;
19: --
20: p_sql := 'select distinct person_id ' ||
21: 'from per_people_f ppf, ' ||

Line 28: hr_utility.trace(l_package_name||'range_code - End');

24: 'and ppa.business_group_id = ppf.business_group_id ' ||
25: 'order by ppf.person_id';
26: --
27: if g_debug then
28: hr_utility.trace(l_package_name||'range_code - End');
29: end if;
30: end range_code;
31: ----------------------------------------------------------------------------
32: -- This procedure is used to restrict the Assignment Action Creation.

Line 158: hr_utility.trace(l_package_name||'assignment_action_code - Start');

154: );
155: ----------------------------------------------------------------------
156: begin
157: if g_debug then
158: hr_utility.trace(l_package_name||'assignment_action_code - Start');
159: end if;
160: --
161: open get_params(p_payroll_action_id);
162: fetch get_params

Line 187: hr_utility.trace(l_package_name||'assignment_action_code - Before hr_nonrun_asact.insact');

183: fetch next_action_id into v_next_action_id;
184: close next_action_id;
185: --
186: if g_debug then
187: hr_utility.trace(l_package_name||'assignment_action_code - Before hr_nonrun_asact.insact');
188: end if;
189: --
190: hr_nonrun_asact.insact( v_next_action_id
191: , asglist(i)

Line 198: hr_utility.trace(l_package_name||'assignment_action_code - After hr_nonrun_asact.insact');

194: , null
195: );
196: --
197: if g_debug then
198: hr_utility.trace(l_package_name||'assignment_action_code - After hr_nonrun_asact.insact');
199: end if;
200: end if;
201: end loop;
202: --

Line 204: hr_utility.trace(l_package_name||'assignment_action_code - End');

200: end if;
201: end loop;
202: --
203: if g_debug then
204: hr_utility.trace(l_package_name||'assignment_action_code - End');
205: end if;
206: end assignment_action_code;
207: ------------------------------------------------------------------------
208: -- Archives Person details for the processing Assignment

Line 239: hr_utility.trace(l_package_name||'Archive_Code - Start');

235: and paa.person_id = pap.person_id;
236: --
237: begin
238: if g_debug then
239: hr_utility.trace(l_package_name||'Archive_Code - Start');
240: end if;
241: -------------------------------------------------------------------
242: -- Get setup action id
243: -------------------------------------------------------------------

Line 258: hr_utility.trace(l_package_name||'Archive_Code - Before pai insert');

254: if get_details%found then
255: close get_details;
256: --
257: if g_debug then
258: hr_utility.trace(l_package_name||'Archive_Code - Before pai insert');
259: end if;
260: --------------------------------------------------------------
261: --
262: --

Line 284: hr_utility.trace(l_package_name||'Archive_Code - After pai insert');

280: v_start_date,
281: v_assignment_id );
282: --
283: if g_debug then
284: hr_utility.trace(l_package_name||'Archive_Code - After pai insert');
285: end if;
286: else
287: if g_debug then
288: hr_utility.trace(l_package_name||'Archive_Code - Person record not found');

Line 288: hr_utility.trace(l_package_name||'Archive_Code - Person record not found');

284: hr_utility.trace(l_package_name||'Archive_Code - After pai insert');
285: end if;
286: else
287: if g_debug then
288: hr_utility.trace(l_package_name||'Archive_Code - Person record not found');
289: end if;
290: --
291: close get_details;
292: end if;

Line 295: hr_utility.trace(l_package_name||'Archive_Code - End');

291: close get_details;
292: end if;
293: --
294: if g_debug then
295: hr_utility.trace(l_package_name||'Archive_Code - End');
296: end if;
297: end archive_code;
298: --------------------------------------------------------------
299: -- Initiates IRAS Line Archive Processor

Line 326: hr_utility.trace(l_package_name||'Deinit_Code - Start');

322: from pay_payroll_actions
323: where payroll_action_id = p_payroll_action_id;
324: begin
325: if g_debug then
326: hr_utility.trace(l_package_name||'Deinit_Code - Start');
327: end if;
328: --
329: open csr_iras_action_details;
330: fetch csr_iras_action_details into

Line 342: hr_utility.trace(l_package_name||'Deinit_Code - Before initiating archive');

338:
339: close csr_iras_action_details;
340: --
341: if g_debug then
342: hr_utility.trace(l_package_name||'Deinit_Code - Before initiating archive');
343: end if;
344: --
345:
346: l_rep_req_id := FND_REQUEST.SUBMIT_REQUEST (

Line 368: hr_utility.trace(l_package_name||'Deinit_Code - After initiating archive');

364: ARGUMENT16 => 'END_DATE='||to_char(v_basis)||'/12/31 00:00:00',
365: ARGUMENT17=>'BUSINESS_GROUP_ID='||v_bg_id||' LEGAL_ENTITY_ID='||v_le||' SETUP_ACTION_ID='||p_payroll_action_id||' ASSIGNMENT_SET_ID='||v_ass_id||' PERSON_ID='||v_per_id||' BASIS_YEAR='||v_basis||' '||'END_DATE='||to_char(v_basis)||'/12/31 00:00:00');
366:
367: if g_debug then
368: hr_utility.trace(l_package_name||'Deinit_Code - After initiating archive');
369: hr_utility.trace(l_package_name||'Deinit_Code - End');
370: end if;
371: end deinit_code;
372: begin

Line 369: hr_utility.trace(l_package_name||'Deinit_Code - End');

365: ARGUMENT17=>'BUSINESS_GROUP_ID='||v_bg_id||' LEGAL_ENTITY_ID='||v_le||' SETUP_ACTION_ID='||p_payroll_action_id||' ASSIGNMENT_SET_ID='||v_ass_id||' PERSON_ID='||v_per_id||' BASIS_YEAR='||v_basis||' '||'END_DATE='||to_char(v_basis)||'/12/31 00:00:00');
366:
367: if g_debug then
368: hr_utility.trace(l_package_name||'Deinit_Code - After initiating archive');
369: hr_utility.trace(l_package_name||'Deinit_Code - End');
370: end if;
371: end deinit_code;
372: begin
373: l_package_name := 'pay_sg_iras_amend_setup.';

Line 374: g_debug := hr_utility.debug_enabled;

370: end if;
371: end deinit_code;
372: begin
373: l_package_name := 'pay_sg_iras_amend_setup.';
374: g_debug := hr_utility.debug_enabled;
375: end pay_sg_iras_amend_setup;