eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_IRAS_ARCHIVE_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 151: hr_utility.trace(l_package_name||'assignment_action_code - Start');

147: );
148: ----------------------------------------------------------------------
149: begin
150: if g_debug then
151: hr_utility.trace(l_package_name||'assignment_action_code - Start');
152: end if;
153: --
154: open get_params(p_payroll_action_id);
155: fetch get_params

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

174: fetch next_action_id into v_next_action_id;
175: close next_action_id;
176: --
177: if g_debug then
178: hr_utility.trace(l_package_name||'assignment_action_code - Before hr_nonrun_asact.insact');
179: end if;
180: --
181: hr_nonrun_asact.insact( v_next_action_id
182: , asglist(i)

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

185: , null
186: );
187: --
188: if g_debug then
189: hr_utility.trace(l_package_name||'assignment_action_code - After hr_nonrun_asact.insact');
190: end if;
191: end if;
192: end loop;
193: --

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

191: end if;
192: end loop;
193: --
194: if g_debug then
195: hr_utility.trace(l_package_name||'assignment_action_code - End');
196: end if;
197: end assignment_action_code;
198: ------------------------------------------------------------------------
199: -- Archives Person details for the processing Assignment

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

226: and paa.person_id = pap.person_id;
227: --
228: begin
229: if g_debug then
230: hr_utility.trace(l_package_name||'Archive_Code - Start');
231: end if;
232: -------------------------------------------------------------------
233: -- Get setup action id
234: -------------------------------------------------------------------

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

245: if get_details%found then
246: close get_details;
247: --
248: if g_debug then
249: hr_utility.trace(l_package_name||'Archive_Code - Before pai insert');
250: end if;
251: --------------------------------------------------------------
252: --
253: --

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

271: v_start_date,
272: v_assignment_id );
273: --
274: if g_debug then
275: hr_utility.trace(l_package_name||'Archive_Code - After pai insert');
276: end if;
277: else
278: if g_debug then
279: hr_utility.trace(l_package_name||'Archive_Code - Person record not found');

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

275: hr_utility.trace(l_package_name||'Archive_Code - After pai insert');
276: end if;
277: else
278: if g_debug then
279: hr_utility.trace(l_package_name||'Archive_Code - Person record not found');
280: end if;
281: --
282: close get_details;
283: end if;

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

282: close get_details;
283: end if;
284: --
285: if g_debug then
286: hr_utility.trace(l_package_name||'Archive_Code - End');
287: end if;
288: end archive_code;
289: --------------------------------------------------------------
290: -- Initiates IRAS Line Archive Processor

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

308: from pay_payroll_actions
309: where payroll_action_id = p_payroll_action_id;
310: begin
311: if g_debug then
312: hr_utility.trace(l_package_name||'Deinit_Code - Start');
313: end if;
314: --
315: open csr_iras_action_details;
316: fetch csr_iras_action_details into

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

321: v_action_parameter_group;
322: close csr_iras_action_details;
323: --
324: if g_debug then
325: hr_utility.trace(l_package_name||'Deinit_Code - Before initiating archive');
326: end if;
327: --
328: l_rep_req_id := FND_REQUEST.SUBMIT_REQUEST (
329: APPLICATION => 'PAY',

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

346: ARGUMENT16 => 'BUSINESS_GROUP_ID='||v_business_group_id||' LEGAL_ENTITY_ID='||v_legal_entity||
347: ' SETUP_ACTION_ID='||p_payroll_action_id||' BASIS_YEAR='||v_basis_year||' '||
348: 'END_DATE='||to_char(v_basis_year)||'/12/31 00:00:00' );
349: if g_debug then
350: hr_utility.trace(l_package_name||'Deinit_Code - After initiating archive');
351: end if;
352: --
353: if g_debug then
354: hr_utility.trace(l_package_name||'Deinit_Code - End');

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

350: hr_utility.trace(l_package_name||'Deinit_Code - After initiating archive');
351: end if;
352: --
353: if g_debug then
354: hr_utility.trace(l_package_name||'Deinit_Code - End');
355: end if;
356: end deinit_code;
357: begin
358: l_package_name := 'pay_sg_iras_archive_setup.';

Line 359: g_debug := hr_utility.debug_enabled;

355: end if;
356: end deinit_code;
357: begin
358: l_package_name := 'pay_sg_iras_archive_setup.';
359: g_debug := hr_utility.debug_enabled;
360: end pay_sg_iras_archive_setup;