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.PER_JP_WRKREG_REPORT_PKG dependencies on HR_UTILITY

Line 96: gb_debug := hr_utility.debug_enabled;

92: IS
93: lc_text VARCHAR2(4000);
94: BEGIN
95: --
96: gb_debug := hr_utility.debug_enabled;
97: --
98: IF gb_debug
99: THEN
100: hr_utility.trace ('Entering CNV_STR');

Line 100: hr_utility.trace ('Entering CNV_STR');

96: gb_debug := hr_utility.debug_enabled;
97: --
98: IF gb_debug
99: THEN
100: hr_utility.trace ('Entering CNV_STR');
101: END IF;
102: --
103: lc_text := LTRIM(RTRIM(REPLACE(p_text,TO_MULTI_BYTE(' '),' ')));
104: --

Line 111: hr_utility.trace ('Leaving CNV_STR');

107: lc_text := SUBSTR(lc_text,p_start,p_end);
108: END IF;
109: --
110: IF gb_debug THEN
111: hr_utility.trace ('Leaving CNV_STR');
112: END IF;
113: --
114: RETURN lc_text;
115: --

Line 147: gb_debug := hr_utility.debug_enabled;

143: IS
144: lc_htmlspchar VARCHAR2(1) := 'N';
145: BEGIN
146: --
147: gb_debug := hr_utility.debug_enabled;
148: --
149: IF gb_debug THEN
150: hr_utility.trace ('Entering htmlspchar');
151: END IF;

Line 150: hr_utility.trace ('Entering htmlspchar');

146: --
147: gb_debug := hr_utility.debug_enabled;
148: --
149: IF gb_debug THEN
150: hr_utility.trace ('Entering htmlspchar');
151: END IF;
152: --
153: IF NVL(INSTR(p_text,'<'),0) > 0 THEN
154: lc_htmlspchar := 'Y';

Line 215: gb_debug := hr_utility.debug_enabled;

211: lc_buf VARCHAR2(255);
212: --
213: BEGIN
214: --
215: gb_debug := hr_utility.debug_enabled;
216: --
217: IF gb_debug THEN
218: hr_utility.trace ('Entering PRINT_CLOB');
219: END IF;

Line 218: hr_utility.trace ('Entering PRINT_CLOB');

214: --
215: gb_debug := hr_utility.debug_enabled;
216: --
217: IF gb_debug THEN
218: hr_utility.trace ('Entering PRINT_CLOB');
219: END IF;
220: --
221: ln_chars := 240;
222: ln_offset := 1;

Line 230: hr_utility.trace(lc_buf);

226: , ln_chars
227: , ln_offset
228: , lc_buf
229: );
230: hr_utility.trace(lc_buf);
231: ln_offset := ln_offset + ln_chars;
232: END LOOP;
233: --
234: EXCEPTION

Line 237: hr_utility.trace ('CLOB contents end.');

233: --
234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN
236: IF gb_debug THEN
237: hr_utility.trace ('CLOB contents end.');
238: END IF;
239: --
240: END print_clob;
241: --

Line 289: gb_debug :=hr_utility.debug_enabled ;

285: lc_procedure VARCHAR2(200);
286: --
287: BEGIN
288: --
289: gb_debug :=hr_utility.debug_enabled ;
290: IF gb_debug THEN
291: lc_procedure := gc_pkg_name||'initialize';
292: hr_utility.set_location('Entering '||lc_procedure,1);
293: END IF;

Line 292: hr_utility.set_location('Entering '||lc_procedure,1);

288: --
289: gb_debug :=hr_utility.debug_enabled ;
290: IF gb_debug THEN
291: lc_procedure := gc_pkg_name||'initialize';
292: hr_utility.set_location('Entering '||lc_procedure,1);
293: END IF;
294: --
295: -- Fetch the parameters passed by user into global variable.
296: --

Line 307: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);

303: FROM pay_payroll_actions PPA
304: WHERE PPA.payroll_action_id = gr_parameters.payroll_action_id;
305: --
306: IF gb_debug THEN
307: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
308: hr_utility.set_location('gr_parameters.payroll_action_id . . = ' || gr_parameters.payroll_action_id,30);
309: hr_utility.set_location('gr_parameters. ass_setid............... . = ' || gr_parameters. ass_setid,30);
310: hr_utility.set_location('gr_parameters.include_org_hierarchy . . = ' || gr_parameters.include_org_hierarchy,30);
311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);

Line 308: hr_utility.set_location('gr_parameters.payroll_action_id . . = ' || gr_parameters.payroll_action_id,30);

304: WHERE PPA.payroll_action_id = gr_parameters.payroll_action_id;
305: --
306: IF gb_debug THEN
307: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
308: hr_utility.set_location('gr_parameters.payroll_action_id . . = ' || gr_parameters.payroll_action_id,30);
309: hr_utility.set_location('gr_parameters. ass_setid............... . = ' || gr_parameters. ass_setid,30);
310: hr_utility.set_location('gr_parameters.include_org_hierarchy . . = ' || gr_parameters.include_org_hierarchy,30);
311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);
312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);

Line 309: hr_utility.set_location('gr_parameters. ass_setid............... . = ' || gr_parameters. ass_setid,30);

305: --
306: IF gb_debug THEN
307: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
308: hr_utility.set_location('gr_parameters.payroll_action_id . . = ' || gr_parameters.payroll_action_id,30);
309: hr_utility.set_location('gr_parameters. ass_setid............... . = ' || gr_parameters. ass_setid,30);
310: hr_utility.set_location('gr_parameters.include_org_hierarchy . . = ' || gr_parameters.include_org_hierarchy,30);
311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);
312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);
313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);

Line 310: hr_utility.set_location('gr_parameters.include_org_hierarchy . . = ' || gr_parameters.include_org_hierarchy,30);

306: IF gb_debug THEN
307: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
308: hr_utility.set_location('gr_parameters.payroll_action_id . . = ' || gr_parameters.payroll_action_id,30);
309: hr_utility.set_location('gr_parameters. ass_setid............... . = ' || gr_parameters. ass_setid,30);
310: hr_utility.set_location('gr_parameters.include_org_hierarchy . . = ' || gr_parameters.include_org_hierarchy,30);
311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);
312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);
313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);

Line 311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);

307: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);
308: hr_utility.set_location('gr_parameters.payroll_action_id . . = ' || gr_parameters.payroll_action_id,30);
309: hr_utility.set_location('gr_parameters. ass_setid............... . = ' || gr_parameters. ass_setid,30);
310: hr_utility.set_location('gr_parameters.include_org_hierarchy . . = ' || gr_parameters.include_org_hierarchy,30);
311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);
312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);
313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);
315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);

Line 312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);

308: hr_utility.set_location('gr_parameters.payroll_action_id . . = ' || gr_parameters.payroll_action_id,30);
309: hr_utility.set_location('gr_parameters. ass_setid............... . = ' || gr_parameters. ass_setid,30);
310: hr_utility.set_location('gr_parameters.include_org_hierarchy . . = ' || gr_parameters.include_org_hierarchy,30);
311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);
312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);
313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);
315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);
316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);

Line 313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);

309: hr_utility.set_location('gr_parameters. ass_setid............... . = ' || gr_parameters. ass_setid,30);
310: hr_utility.set_location('gr_parameters.include_org_hierarchy . . = ' || gr_parameters.include_org_hierarchy,30);
311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);
312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);
313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);
315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);
316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);
317: hr_utility.set_location('gr_parameters.term_eff_date_to...... = ' || gr_parameters.term_eff_date_to,30);

Line 314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);

310: hr_utility.set_location('gr_parameters.include_org_hierarchy . . = ' || gr_parameters.include_org_hierarchy,30);
311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);
312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);
313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);
315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);
316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);
317: hr_utility.set_location('gr_parameters.term_eff_date_to...... = ' || gr_parameters.term_eff_date_to,30);
318: hr_utility.set_location('gr_parameters.sort_order_1...... = ' || gr_parameters.sort_order_1,30);

Line 315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);

311: hr_utility.set_location('gr_parameters.organization_id............... .= ' || gr_parameters.organization_id,30);
312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);
313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);
315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);
316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);
317: hr_utility.set_location('gr_parameters.term_eff_date_to...... = ' || gr_parameters.term_eff_date_to,30);
318: hr_utility.set_location('gr_parameters.sort_order_1...... = ' || gr_parameters.sort_order_1,30);
319: hr_utility.set_location('gr_parameters.sort_order_2...... = ' || gr_parameters.sort_order_2,30);

Line 316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);

312: hr_utility.set_location('gr_parameters.business_group_id....... = ' || gr_parameters.business_group_id,30);
313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);
315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);
316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);
317: hr_utility.set_location('gr_parameters.term_eff_date_to...... = ' || gr_parameters.term_eff_date_to,30);
318: hr_utility.set_location('gr_parameters.sort_order_1...... = ' || gr_parameters.sort_order_1,30);
319: hr_utility.set_location('gr_parameters.sort_order_2...... = ' || gr_parameters.sort_order_2,30);
320: hr_utility.set_location('gr_parameters.sort_order_3...... = ' || gr_parameters.sort_order_3,30);

Line 317: hr_utility.set_location('gr_parameters.term_eff_date_to...... = ' || gr_parameters.term_eff_date_to,30);

313: hr_utility.set_location('gr_parameters.location_id....... = ' || gr_parameters.location_id,30);
314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);
315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);
316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);
317: hr_utility.set_location('gr_parameters.term_eff_date_to...... = ' || gr_parameters.term_eff_date_to,30);
318: hr_utility.set_location('gr_parameters.sort_order_1...... = ' || gr_parameters.sort_order_1,30);
319: hr_utility.set_location('gr_parameters.sort_order_2...... = ' || gr_parameters.sort_order_2,30);
320: hr_utility.set_location('gr_parameters.sort_order_3...... = ' || gr_parameters.sort_order_3,30);
321:

Line 318: hr_utility.set_location('gr_parameters.sort_order_1...... = ' || gr_parameters.sort_order_1,30);

314: hr_utility.set_location('gr_parameters.effective_date.......... = ' || gr_parameters.effective_date,30);
315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);
316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);
317: hr_utility.set_location('gr_parameters.term_eff_date_to...... = ' || gr_parameters.term_eff_date_to,30);
318: hr_utility.set_location('gr_parameters.sort_order_1...... = ' || gr_parameters.sort_order_1,30);
319: hr_utility.set_location('gr_parameters.sort_order_2...... = ' || gr_parameters.sort_order_2,30);
320: hr_utility.set_location('gr_parameters.sort_order_3...... = ' || gr_parameters.sort_order_3,30);
321:
322: END IF;

Line 319: hr_utility.set_location('gr_parameters.sort_order_2...... = ' || gr_parameters.sort_order_2,30);

315: hr_utility.set_location('gr_parameters.incl_term_emp...... = ' || gr_parameters.incl_term_emp,30);
316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);
317: hr_utility.set_location('gr_parameters.term_eff_date_to...... = ' || gr_parameters.term_eff_date_to,30);
318: hr_utility.set_location('gr_parameters.sort_order_1...... = ' || gr_parameters.sort_order_1,30);
319: hr_utility.set_location('gr_parameters.sort_order_2...... = ' || gr_parameters.sort_order_2,30);
320: hr_utility.set_location('gr_parameters.sort_order_3...... = ' || gr_parameters.sort_order_3,30);
321:
322: END IF;
323: --

Line 320: hr_utility.set_location('gr_parameters.sort_order_3...... = ' || gr_parameters.sort_order_3,30);

316: hr_utility.set_location('gr_parameters.term_eff_date_from...... = ' || gr_parameters.term_eff_date_from,30);
317: hr_utility.set_location('gr_parameters.term_eff_date_to...... = ' || gr_parameters.term_eff_date_to,30);
318: hr_utility.set_location('gr_parameters.sort_order_1...... = ' || gr_parameters.sort_order_1,30);
319: hr_utility.set_location('gr_parameters.sort_order_2...... = ' || gr_parameters.sort_order_2,30);
320: hr_utility.set_location('gr_parameters.sort_order_3...... = ' || gr_parameters.sort_order_3,30);
321:
322: END IF;
323: --
324: IF gb_debug THEN

Line 325: hr_utility.set_location('Leaving '||lc_procedure,1000);

321:
322: END IF;
323: --
324: IF gb_debug THEN
325: hr_utility.set_location('Leaving '||lc_procedure,1000);
326: END IF;
327: --
328: EXCEPTION
329: WHEN gc_exception THEN

Line 331: hr_utility.set_location('Error in '||lc_procedure,999999);

327: --
328: EXCEPTION
329: WHEN gc_exception THEN
330: IF gb_debug THEN
331: hr_utility.set_location('Error in '||lc_procedure,999999);
332: END IF;
333: RAISE;
334: WHEN OTHERS THEN
335: RAISE gc_exception;

Line 371: gb_debug := hr_utility.debug_enabled;

367: lc_proc_name VARCHAR2(100);
368: BEGIN
369: --
370: lc_proc_name := gc_pkg_name ||'RANGE_CURSOR';
371: gb_debug := hr_utility.debug_enabled;
372: --
373: IF gb_debug THEN
374: hr_utility.trace ('Entering '||lc_proc_name);
375: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);

Line 374: hr_utility.trace ('Entering '||lc_proc_name);

370: lc_proc_name := gc_pkg_name ||'RANGE_CURSOR';
371: gb_debug := hr_utility.debug_enabled;
372: --
373: IF gb_debug THEN
374: hr_utility.trace ('Entering '||lc_proc_name);
375: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
376: END IF;
377: --
378: initialize(p_payroll_action_id);

Line 375: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);

371: gb_debug := hr_utility.debug_enabled;
372: --
373: IF gb_debug THEN
374: hr_utility.trace ('Entering '||lc_proc_name);
375: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
376: END IF;
377: --
378: initialize(p_payroll_action_id);
379: --

Line 389: hr_utility.trace ('Range cursor query : ' || p_sqlstr);

385: ' order by p.person_id ';
386: g_mag_payroll_action_id:=P_PAYROLL_ACTION_ID;
387: --
388: IF gb_debug THEN
389: hr_utility.trace ('Range cursor query : ' || p_sqlstr);
390: hr_utility.trace ('Leaving '||lc_proc_name);
391: END IF;
392: --
393: END range_cursor;

Line 390: hr_utility.trace ('Leaving '||lc_proc_name);

386: g_mag_payroll_action_id:=P_PAYROLL_ACTION_ID;
387: --
388: IF gb_debug THEN
389: hr_utility.trace ('Range cursor query : ' || p_sqlstr);
390: hr_utility.trace ('Leaving '||lc_proc_name);
391: END IF;
392: --
393: END range_cursor;
394: --

Line 427: gb_debug := hr_utility.debug_enabled;

423: AS
424:
425: BEGIN
426: --
427: gb_debug := hr_utility.debug_enabled;
428: --
429: IF gb_debug THEN
430: hr_utility.set_location('Entering sort_action procedure',20);
431: END IF;

Line 430: hr_utility.set_location('Entering sort_action procedure',20);

426: --
427: gb_debug := hr_utility.debug_enabled;
428: --
429: IF gb_debug THEN
430: hr_utility.set_location('Entering sort_action procedure',20);
431: END IF;
432: --
433: hr_utility.trace('Beginning of the sort_action cursor');
434: --

Line 433: hr_utility.trace('Beginning of the sort_action cursor');

429: IF gb_debug THEN
430: hr_utility.set_location('Entering sort_action procedure',20);
431: END IF;
432: --
433: hr_utility.trace('Beginning of the sort_action cursor');
434: --
435: initialize(p_payroll_action_id);
436: -- Bug 8691511
437: sqlstr := ' SELECT PAA.rowid

Line 482: hr_utility.trace('End of the sort_Action cursor');

478: --Bug 8691511
479: len := length(sqlstr); -- return the length of the string.
480: IF gb_debug
481: THEN
482: hr_utility.trace('End of the sort_Action cursor');
483: END IF;
484: --
485: EXCEPTION WHEN NO_DATA_FOUND THEN
486: IF gb_debug THEN

Line 487: hr_utility.trace('Error in Sort Procedure - getting legislative param');

483: END IF;
484: --
485: EXCEPTION WHEN NO_DATA_FOUND THEN
486: IF gb_debug THEN
487: hr_utility.trace('Error in Sort Procedure - getting legislative param');
488: END IF;
489: RAISE;
490: --
491: END sort_action;

Line 525: gb_debug := hr_utility.debug_enabled;

521: lc_action_param_val VARCHAR2(30);
522: --
523: BEGIN
524: --
525: gb_debug := hr_utility.debug_enabled;
526: --
527: IF gb_debug THEN
528: hr_utility.set_location('Entering range_person_on',10);
529: END IF;

Line 528: hr_utility.set_location('Entering range_person_on',10);

524: --
525: gb_debug := hr_utility.debug_enabled;
526: --
527: IF gb_debug THEN
528: hr_utility.set_location('Entering range_person_on',10);
529: END IF;
530: --
531: OPEN lcu_action_parameter;
532: FETCH lcu_action_parameter INTO lc_action_param_val;

Line 538: hr_utility.set_location('Range Person = True',10);

534: --
535: IF lc_action_param_val = 'Y' THEN
536: lb_return := TRUE;
537: IF gb_debug THEN
538: hr_utility.set_location('Range Person = True',10);
539: END IF;
540: ELSE
541: lb_return := FALSE;
542: END IF;

Line 545: hr_utility.set_location('Leaving range_person_on',10);

541: lb_return := FALSE;
542: END IF;
543: --
544: IF gb_debug THEN
545: hr_utility.set_location('Leaving range_person_on',10);
546: END IF;
547: RETURN lb_return;
548: --
549: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 551: hr_utility.set_location('No Data Found Exception in range_person_on',10);

547: RETURN lb_return;
548: --
549: EXCEPTION WHEN NO_DATA_FOUND THEN
550: IF gb_debug THEN
551: hr_utility.set_location('No Data Found Exception in range_person_on',10);
552: END IF;
553: lb_return := FALSE;
554: RETURN lb_return;
555: END range_person_on;

Line 713: gb_debug := hr_utility.debug_enabled;

709: lt_org_id per_jp_report_common_pkg.gt_org_tbl;
710: --
711: BEGIN
712: --
713: gb_debug := hr_utility.debug_enabled;
714: --
715: IF gb_debug
716: THEN
717: hr_utility.trace('Entering ACTION_CREATION');

Line 717: hr_utility.trace('Entering ACTION_CREATION');

713: gb_debug := hr_utility.debug_enabled;
714: --
715: IF gb_debug
716: THEN
717: hr_utility.trace('Entering ACTION_CREATION');
718: END IF;
719: --
720: SELECT legislative_parameters
721: INTO lc_legislative_parameters

Line 729: gb_debug :=hr_utility.debug_enabled ;

725: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
726: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));
727: --
728: g_mag_payroll_action_id:=p_payroll_action_id;
729: gb_debug :=hr_utility.debug_enabled ;
730: --
731:
732: IF gb_debug THEN
733: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';

Line 734: hr_utility.trace ('Entering '||lc_proc_name);

730: --
731:
732: IF gb_debug THEN
733: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
734: hr_utility.trace ('Entering '||lc_proc_name);
735: hr_utility.trace ('Parameters ....');
736: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
737: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
738: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);

Line 735: hr_utility.trace ('Parameters ....');

731:
732: IF gb_debug THEN
733: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
734: hr_utility.trace ('Entering '||lc_proc_name);
735: hr_utility.trace ('Parameters ....');
736: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
737: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
738: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
739: hr_utility.trace ('P_CHUNK = '|| p_chunk);

Line 736: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);

732: IF gb_debug THEN
733: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
734: hr_utility.trace ('Entering '||lc_proc_name);
735: hr_utility.trace ('Parameters ....');
736: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
737: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
738: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
739: hr_utility.trace ('P_CHUNK = '|| p_chunk);
740: END IF;

Line 737: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);

733: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
734: hr_utility.trace ('Entering '||lc_proc_name);
735: hr_utility.trace ('Parameters ....');
736: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
737: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
738: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
739: hr_utility.trace ('P_CHUNK = '|| p_chunk);
740: END IF;
741: --

Line 738: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);

734: hr_utility.trace ('Entering '||lc_proc_name);
735: hr_utility.trace ('Parameters ....');
736: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
737: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
738: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
739: hr_utility.trace ('P_CHUNK = '|| p_chunk);
740: END IF;
741: --
742: initialize(g_mag_payroll_action_id);

Line 739: hr_utility.trace ('P_CHUNK = '|| p_chunk);

735: hr_utility.trace ('Parameters ....');
736: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
737: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
738: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
739: hr_utility.trace ('P_CHUNK = '|| p_chunk);
740: END IF;
741: --
742: initialize(g_mag_payroll_action_id);
743: --

Line 756: hr_utility.set_location('Inside Range person if condition',20);

752: --
753: IF range_person_on THEN
754: -- Range person is enabled
755: IF gb_debug THEN
756: hr_utility.set_location('Inside Range person if condition',20);
757: END IF;
758: -- Assignment Action for Current and Terminated Employees
759: FOR lr_assact IN lcu_assact_r(ln_old_pact_id
760: ,gr_parameters.business_group_id

Line 773: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);

769: -- Added NVL to overcome NULL issue.
770: --
771: IF (NVL(ln_ass_set_id ,0) = 0) THEN
772: -- NO assignment set passed as parameter
773: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
774: --
775: SELECT pay_assignment_actions_s.nextval
776: INTO ln_assact
777: FROM dual;

Line 808: hr_utility.set_location('Range person returns false',20);

804: END LOOP;-- End loop for assignment details cursor
805: ELSE
806: -- Range person is not enabled
807: IF gb_debug THEN
808: hr_utility.set_location('Range person returns false',20);
809: hr_utility.set_location(ln_old_pact_id,20);
810: hr_utility.set_location(lt_org_id(i),20);
811: END IF;
812: -- Assignment Action for Current and Terminated Employe

Line 809: hr_utility.set_location(ln_old_pact_id,20);

805: ELSE
806: -- Range person is not enabled
807: IF gb_debug THEN
808: hr_utility.set_location('Range person returns false',20);
809: hr_utility.set_location(ln_old_pact_id,20);
810: hr_utility.set_location(lt_org_id(i),20);
811: END IF;
812: -- Assignment Action for Current and Terminated Employe
813: FOR lr_assact IN lcu_assact(ln_old_pact_id

Line 810: hr_utility.set_location(lt_org_id(i),20);

806: -- Range person is not enabled
807: IF gb_debug THEN
808: hr_utility.set_location('Range person returns false',20);
809: hr_utility.set_location(ln_old_pact_id,20);
810: hr_utility.set_location(lt_org_id(i),20);
811: END IF;
812: -- Assignment Action for Current and Terminated Employe
813: FOR lr_assact IN lcu_assact(ln_old_pact_id
814: ,gr_parameters.business_group_id

Line 827: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);

823: -- Added NVL to overcome NULL issue.
824: --
825: IF (NVL(ln_ass_set_id ,0) = 0) THEN
826: -- NO assignment set passed as parameter
827: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
828: --
829: SELECT pay_assignment_actions_s.nextval
830: INTO ln_assact
831: FROM dual;

Line 866: hr_utility.set_location('Inside Range person if condition',20);

862: ELSE--Org id is null
863: IF range_person_on THEN
864: -- Assignment Action for Current and Terminated Employees
865: IF gb_debug THEN
866: hr_utility.set_location('Inside Range person if condition',20);
867: END IF;
868: -- Assignment Action for Current and Terminated Employees
869: --
870: FOR lr_assact IN lcu_assact_r(ln_old_pact_id

Line 883: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);

879: LOOP
880: -- Added NVL to overcome NULL issue.
881: IF (NVL(ln_ass_set_id ,0) = 0) THEN
882: -- NO assignment set passed as parameter
883: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
884: --
885: SELECT pay_assignment_actions_s.nextval
886: INTO ln_assact
887: FROM dual;

Line 918: hr_utility.set_location('Range person returns false',20);

914: END LOOP;-- End loop for assignment details cursor
915: --
916: ELSE
917: IF gb_debug THEN
918: hr_utility.set_location('Range person returns false',20);
919: END IF;
920: -- Assignment Action for Current and Terminated Employe
921: --
922: FOR lr_assact IN lcu_assact(ln_old_pact_id

Line 935: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);

931: LOOP
932: -- Added NVL to overcome NULL issue.
933: IF (NVL(ln_ass_set_id ,0) = 0) THEN
934: -- NO assignment set passed as parameter
935: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
936: --
937: SELECT pay_assignment_actions_s.nextval
938: INTO ln_assact
939: FROM dual;

Line 973: hr_utility.trace('Leaving ACTION_CREATION');

969: END IF;
970: --
971: IF gb_debug
972: THEN
973: hr_utility.trace('Leaving ACTION_CREATION');
974: END IF;
975: --
976: END action_creation;
977: --

Line 1003: gb_debug := hr_utility.debug_enabled;

999: -- None
1000: --************************************************************************
1001: IS
1002: BEGIN
1003: gb_debug := hr_utility.debug_enabled;
1004: --
1005: IF gb_debug
1006: THEN
1007: hr_utility.trace ('inside INIT_CODE ');

Line 1007: hr_utility.trace ('inside INIT_CODE ');

1003: gb_debug := hr_utility.debug_enabled;
1004: --
1005: IF gb_debug
1006: THEN
1007: hr_utility.trace ('inside INIT_CODE ');
1008: END IF;
1009: --
1010: g_mag_payroll_action_id:=p_payroll_action_id;
1011: --

Line 1043: gb_debug := hr_utility.debug_enabled;

1039: --************************************************************************
1040: IS
1041: BEGIN
1042: --
1043: gb_debug := hr_utility.debug_enabled;
1044: --
1045: IF gb_debug
1046: THEN
1047: hr_utility.trace ('inside ARCHIVE_CODE ');

Line 1047: hr_utility.trace ('inside ARCHIVE_CODE ');

1043: gb_debug := hr_utility.debug_enabled;
1044: --
1045: IF gb_debug
1046: THEN
1047: hr_utility.trace ('inside ARCHIVE_CODE ');
1048: END IF;
1049: --
1050: END archive_code;
1051: --

Line 1220: gb_debug := hr_utility.debug_enabled;

1216: --End for bug 8608463
1217: --
1218: BEGIN
1219: --
1220: gb_debug := hr_utility.debug_enabled;
1221: --
1222: IF gb_debug THEN
1223: hr_utility.trace ('Entering assact_xml');
1224: END IF;

Line 1223: hr_utility.trace ('Entering assact_xml');

1219: --
1220: gb_debug := hr_utility.debug_enabled;
1221: --
1222: IF gb_debug THEN
1223: hr_utility.trace ('Entering assact_xml');
1224: END IF;
1225: --
1226: vXMLTable.DELETE;
1227: gn_vctr := 0;

Line 1232: hr_utility.trace('wrkreg_xml');

1228: l_job_hist_xml:=null;
1229: l_index:=0;
1230: --
1231: IF gb_debug THEN
1232: hr_utility.trace('wrkreg_xml');
1233: END IF;
1234: --
1235: l_mag_asg_action_id :=p_assignment_action_id;
1236: --

Line 1486: hr_utility.trace ('Leaving assact_xml');

1482: CLOSE cur_wrk_reg_emp;
1483: --
1484: IF gb_debug
1485: THEN
1486: hr_utility.trace ('Leaving assact_xml');
1487: END IF;
1488: --
1489: EXCEPTION
1490: WHEN gc_exception THEN

Line 1492: hr_utility.set_location('Error in assact_xml ',999999);

1488: --
1489: EXCEPTION
1490: WHEN gc_exception THEN
1491: IF gb_debug THEN
1492: hr_utility.set_location('Error in assact_xml ',999999);
1493: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1494: hr_utility.raise_error;
1495: END IF;
1496: WHEN OTHERS THEN

Line 1493: hr_utility.set_location('sqleerm ' || SQLERRM,20);

1489: EXCEPTION
1490: WHEN gc_exception THEN
1491: IF gb_debug THEN
1492: hr_utility.set_location('Error in assact_xml ',999999);
1493: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1494: hr_utility.raise_error;
1495: END IF;
1496: WHEN OTHERS THEN
1497: RAISE gc_exception;

Line 1494: hr_utility.raise_error;

1490: WHEN gc_exception THEN
1491: IF gb_debug THEN
1492: hr_utility.set_location('Error in assact_xml ',999999);
1493: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1494: hr_utility.raise_error;
1495: END IF;
1496: WHEN OTHERS THEN
1497: RAISE gc_exception;
1498: END assact_xml;

Line 1530: gb_debug := hr_utility.debug_enabled;

1526: l_tempclob CLOB;
1527: ln_ctr_table NUMBER;
1528: BEGIN
1529: --
1530: gb_debug := hr_utility.debug_enabled;
1531: --
1532: IF gb_debug
1533: THEN
1534: hr_utility.trace('Entering WRITETOCLOB');

Line 1534: hr_utility.trace('Entering WRITETOCLOB');

1530: gb_debug := hr_utility.debug_enabled;
1531: --
1532: IF gb_debug
1533: THEN
1534: hr_utility.trace('Entering WRITETOCLOB');
1535: END IF;
1536: --
1537: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1538: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);

Line 1549: hr_utility.set_location('Out of loop ', 99);

1545: p_write_xml := g_xfdf_string;
1546: --
1547: IF gb_debug
1548: THEN
1549: hr_utility.set_location('Out of loop ', 99);
1550: END IF;
1551: --
1552: dbms_lob.close(g_xfdf_string);
1553: IF gb_debug

Line 1555: hr_utility.trace('Leaving WRITETOCLOB');

1551: --
1552: dbms_lob.close(g_xfdf_string);
1553: IF gb_debug
1554: THEN
1555: hr_utility.trace('Leaving WRITETOCLOB');
1556: END IF;
1557: --
1558: EXCEPTION
1559: WHEN gc_exception THEN

Line 1562: hr_utility.set_location('Error in writetoclob ',999999);

1558: EXCEPTION
1559: WHEN gc_exception THEN
1560: IF gb_debug
1561: THEN
1562: hr_utility.set_location('Error in writetoclob ',999999);
1563: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1564: hr_utility.raise_error;
1565: END IF;
1566: WHEN OTHERS THEN

Line 1563: hr_utility.set_location('sqleerm ' || SQLERRM,20);

1559: WHEN gc_exception THEN
1560: IF gb_debug
1561: THEN
1562: hr_utility.set_location('Error in writetoclob ',999999);
1563: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1564: hr_utility.raise_error;
1565: END IF;
1566: WHEN OTHERS THEN
1567: RAISE gc_exception;

Line 1564: hr_utility.raise_error;

1560: IF gb_debug
1561: THEN
1562: hr_utility.set_location('Error in writetoclob ',999999);
1563: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1564: hr_utility.raise_error;
1565: END IF;
1566: WHEN OTHERS THEN
1567: RAISE gc_exception;
1568: --

Line 1602: gb_debug := hr_utility.debug_enabled;

1598: IS
1599: --
1600: BEGIN
1601: --
1602: gb_debug := hr_utility.debug_enabled;
1603: --
1604: IF gb_debug
1605: THEN
1606: hr_utility.trace('Entering GET_CP_XML');

Line 1606: hr_utility.trace('Entering GET_CP_XML');

1602: gb_debug := hr_utility.debug_enabled;
1603: --
1604: IF gb_debug
1605: THEN
1606: hr_utility.trace('Entering GET_CP_XML');
1607: END IF;
1608: --
1609: assact_xml(p_assignment_action_id);
1610: writetoclob (p_xml);

Line 1614: hr_utility.trace('Leaving GET_CP_XML');

1610: writetoclob (p_xml);
1611: --
1612: IF gb_debug
1613: THEN
1614: hr_utility.trace('Leaving GET_CP_XML');
1615: END IF;
1616: --
1617: END get_cp_xml;
1618: --

Line 1655: gb_debug := hr_utility.debug_enabled;

1651: ln_amount NUMBER;
1652: --
1653: BEGIN
1654: --
1655: gb_debug := hr_utility.debug_enabled;
1656: --
1657: IF gb_debug THEN
1658: lc_proc_name := gc_pkg_name || 'GENERATE_XML';
1659: hr_utility.trace ('Entering '||lc_proc_name);

Line 1659: hr_utility.trace ('Entering '||lc_proc_name);

1655: gb_debug := hr_utility.debug_enabled;
1656: --
1657: IF gb_debug THEN
1658: lc_proc_name := gc_pkg_name || 'GENERATE_XML';
1659: hr_utility.trace ('Entering '||lc_proc_name);
1660: END IF ;
1661: --
1662: ln_cur_assact := pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID' );
1663: ln_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );

Line 1695: hr_utility.set_location ('Leaving '||lc_proc_name,20);

1691: --
1692: EXCEPTION
1693: WHEN NO_DATA_FOUND THEN
1694: IF gb_debug THEN
1695: hr_utility.set_location ('Leaving '||lc_proc_name,20);
1696: END IF ;
1697: WHEN gc_exception THEN
1698: IF gb_debug THEN
1699: hr_utility.set_location('Error in '||lc_proc_name,999999);

Line 1699: hr_utility.set_location('Error in '||lc_proc_name,999999);

1695: hr_utility.set_location ('Leaving '||lc_proc_name,20);
1696: END IF ;
1697: WHEN gc_exception THEN
1698: IF gb_debug THEN
1699: hr_utility.set_location('Error in '||lc_proc_name,999999);
1700: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1701: END IF ;
1702: hr_utility.raise_error;
1703: RAISE;

Line 1700: hr_utility.set_location('sqleerm ' || SQLERRM,20);

1696: END IF ;
1697: WHEN gc_exception THEN
1698: IF gb_debug THEN
1699: hr_utility.set_location('Error in '||lc_proc_name,999999);
1700: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1701: END IF ;
1702: hr_utility.raise_error;
1703: RAISE;
1704: WHEN OTHERS THEN

Line 1702: hr_utility.raise_error;

1698: IF gb_debug THEN
1699: hr_utility.set_location('Error in '||lc_proc_name,999999);
1700: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1701: END IF ;
1702: hr_utility.raise_error;
1703: RAISE;
1704: WHEN OTHERS THEN
1705: RAISE gc_exception;
1706: --

Line 1737: gb_debug := hr_utility.debug_enabled;

1733: lc_buf VARCHAR2(2000);
1734: --
1735: BEGIN
1736: --
1737: gb_debug := hr_utility.debug_enabled;
1738: --
1739: IF gb_debug THEN
1740: lc_proc_name := gc_pkg_name || 'GEN_XML_HEADER';
1741: hr_utility.trace ('Entering '||lc_proc_name);

Line 1741: hr_utility.trace ('Entering '||lc_proc_name);

1737: gb_debug := hr_utility.debug_enabled;
1738: --
1739: IF gb_debug THEN
1740: lc_proc_name := gc_pkg_name || 'GEN_XML_HEADER';
1741: hr_utility.trace ('Entering '||lc_proc_name);
1742: END IF ;
1743: --
1744: vxmltable.DELETE; -- delete the pl/sql table
1745: --

Line 1752: hr_utility.trace ('CLOB contents after appending header information');

1748: --
1749: pay_core_files.write_to_magtape_lob(lc_buf);
1750: --
1751: IF gb_debug THEN
1752: hr_utility.trace ('CLOB contents after appending header information');
1753: hr_utility.trace ('Leaving '||lc_proc_name);
1754: END IF ;
1755: --
1756: END gen_xml_header;

Line 1753: hr_utility.trace ('Leaving '||lc_proc_name);

1749: pay_core_files.write_to_magtape_lob(lc_buf);
1750: --
1751: IF gb_debug THEN
1752: hr_utility.trace ('CLOB contents after appending header information');
1753: hr_utility.trace ('Leaving '||lc_proc_name);
1754: END IF ;
1755: --
1756: END gen_xml_header;
1757: --

Line 1786: gb_debug := hr_utility.debug_enabled;

1782: lc_proc_name VARCHAR2(100);
1783: --
1784: BEGIN
1785: --
1786: gb_debug := hr_utility.debug_enabled;
1787: --
1788: IF gb_debug THEN
1789: lc_proc_name := gc_pkg_name || 'GEN_XML_FOOTER';
1790: hr_utility.trace ('Entering '||lc_proc_name);

Line 1790: hr_utility.trace ('Entering '||lc_proc_name);

1786: gb_debug := hr_utility.debug_enabled;
1787: --
1788: IF gb_debug THEN
1789: lc_proc_name := gc_pkg_name || 'GEN_XML_FOOTER';
1790: hr_utility.trace ('Entering '||lc_proc_name);
1791: END IF ;
1792: lc_buf := '' ;
1793: --
1794: pay_core_files.write_to_magtape_lob(lc_buf);

Line 1797: hr_utility.trace ('CLOB contents after appending footer information');

1793: --
1794: pay_core_files.write_to_magtape_lob(lc_buf);
1795: --
1796: IF gb_debug THEN
1797: hr_utility.trace ('CLOB contents after appending footer information');
1798: hr_utility.trace ('Leaving '||lc_proc_name);
1799: END IF ;
1800: --
1801: END gen_xml_footer;

Line 1798: hr_utility.trace ('Leaving '||lc_proc_name);

1794: pay_core_files.write_to_magtape_lob(lc_buf);
1795: --
1796: IF gb_debug THEN
1797: hr_utility.trace ('CLOB contents after appending footer information');
1798: hr_utility.trace ('Leaving '||lc_proc_name);
1799: END IF ;
1800: --
1801: END gen_xml_footer;
1802: --