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_JP_UITE_REPORT_PKG dependencies on HR_UTILITY

Line 99: gb_debug := hr_utility.debug_enabled;

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

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

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

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

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

Line 150: gb_debug := hr_utility.debug_enabled;

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

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

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

Line 220: gb_debug := hr_utility.debug_enabled;

216: lc_action_param_val VARCHAR2(30);
217: --
218: BEGIN
219: --
220: gb_debug := hr_utility.debug_enabled;
221: --
222: IF gb_debug THEN
223: hr_utility.set_location('Entering range_person_on',10);
224: END IF;

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

219: --
220: gb_debug := hr_utility.debug_enabled;
221: --
222: IF gb_debug THEN
223: hr_utility.set_location('Entering range_person_on',10);
224: END IF;
225: --
226: OPEN lcu_action_parameter;
227: FETCH lcu_action_parameter INTO lc_action_param_val;

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

229: --
230: IF lc_action_param_val = 'Y' THEN
231: lb_return := TRUE;
232: IF gb_debug THEN
233: hr_utility.set_location('Range Person = True',10);
234: END IF;
235: ELSE
236: lb_return := FALSE;
237: END IF;

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

236: lb_return := FALSE;
237: END IF;
238: --
239: IF gb_debug THEN
240: hr_utility.set_location('Leaving range_person_on',10);
241: END IF;
242:
243: RETURN lb_return;
244: --

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

243: RETURN lb_return;
244: --
245: EXCEPTION WHEN NO_DATA_FOUND THEN
246: IF gb_debug THEN
247: hr_utility.set_location('No Data Found Exception in range_person_on',10);
248: END IF;
249: lb_return := FALSE;
250: RETURN lb_return;
251: END range_person_on;

Line 290: gb_debug := hr_utility.debug_enabled;

286: lc_output_value VARCHAR2(4000);
287: BEGIN
288: --
289: lc_proc_name := gc_pkg_name ||'GET_NUMBERS';
290: gb_debug := hr_utility.debug_enabled;
291: --
292: IF gb_debug THEN
293: hr_utility.trace ('Entering '||lc_proc_name);
294: END IF;

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

289: lc_proc_name := gc_pkg_name ||'GET_NUMBERS';
290: gb_debug := hr_utility.debug_enabled;
291: --
292: IF gb_debug THEN
293: hr_utility.trace ('Entering '||lc_proc_name);
294: END IF;
295:
296: lc_input_value := p_input1;
297: ln_input_num := p_input;

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

315:
316: p_output := lc_output_value;
317: --
318: IF gb_debug THEN
319: hr_utility.trace ('Leaving '||lc_proc_name);
320: END IF;
321: --
322: END get_numbers;
323: --

Line 367: gb_debug :=hr_utility.debug_enabled ;

363: lc_procedure VARCHAR2(200);
364: --
365: BEGIN
366: --
367: gb_debug :=hr_utility.debug_enabled ;
368: IF gb_debug THEN
369: lc_procedure := gc_pkg_name||'initialize';
370: hr_utility.set_location('Entering '||lc_procedure,1);
371: END IF;

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

366: --
367: gb_debug :=hr_utility.debug_enabled ;
368: IF gb_debug THEN
369: lc_procedure := gc_pkg_name||'initialize';
370: hr_utility.set_location('Entering '||lc_procedure,1);
371: END IF;
372: --
373: -- Fetch the parameters passed by user into global variable.
374: --

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

378:
379: -- ADDED By rdarasi above
380: --
381: IF gb_debug THEN
382: hr_utility.set_location('p_payroll_action_id = ' || p_payroll_action_id,30);
383: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
384: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
385: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);

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

379: -- ADDED By rdarasi above
380: --
381: IF gb_debug THEN
382: hr_utility.set_location('p_payroll_action_id = ' || p_payroll_action_id,30);
383: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
384: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
385: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
387: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);

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

380: --
381: IF gb_debug THEN
382: hr_utility.set_location('p_payroll_action_id = ' || p_payroll_action_id,30);
383: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
384: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
385: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
387: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
388: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);

Line 385: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);

381: IF gb_debug THEN
382: hr_utility.set_location('p_payroll_action_id = ' || p_payroll_action_id,30);
383: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
384: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
385: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
387: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
388: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
389: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);

Line 386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);

382: hr_utility.set_location('p_payroll_action_id = ' || p_payroll_action_id,30);
383: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
384: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
385: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
387: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
388: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
389: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
390: hr_utility.set_location('gr_parameters.payroll_arch = ' || gr_parameters.payroll_arch,30);

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

383: hr_utility.set_location('gr_parameters.payroll_action_id = ' || gr_parameters.payroll_action_id,30);
384: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
385: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
387: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
388: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
389: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
390: hr_utility.set_location('gr_parameters.payroll_arch = ' || gr_parameters.payroll_arch,30);
391: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);

Line 388: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);

384: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
385: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
387: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
388: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
389: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
390: hr_utility.set_location('gr_parameters.payroll_arch = ' || gr_parameters.payroll_arch,30);
391: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
392: END IF;

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

385: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
387: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
388: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
389: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
390: hr_utility.set_location('gr_parameters.payroll_arch = ' || gr_parameters.payroll_arch,30);
391: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
392: END IF;
393: --

Line 390: hr_utility.set_location('gr_parameters.payroll_arch = ' || gr_parameters.payroll_arch,30);

386: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
387: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
388: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
389: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
390: hr_utility.set_location('gr_parameters.payroll_arch = ' || gr_parameters.payroll_arch,30);
391: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
392: END IF;
393: --
394: IF gb_debug THEN

Line 391: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);

387: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
388: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
389: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
390: hr_utility.set_location('gr_parameters.payroll_arch = ' || gr_parameters.payroll_arch,30);
391: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
392: END IF;
393: --
394: IF gb_debug THEN
395: hr_utility.set_location('Leaving '||lc_procedure,1000);

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

391: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
392: END IF;
393: --
394: IF gb_debug THEN
395: hr_utility.set_location('Leaving '||lc_procedure,1000);
396: END IF;
397: --
398: EXCEPTION
399: WHEN gc_exception THEN

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

397: --
398: EXCEPTION
399: WHEN gc_exception THEN
400: IF gb_debug THEN
401: hr_utility.set_location('Error in '||lc_procedure,999999);
402: END IF;
403: RAISE;
404: WHEN OTHERS THEN
405: RAISE gc_exception;

Line 436: gb_debug := hr_utility.debug_enabled;

432: lc_buf VARCHAR2(2000);
433: --
434: BEGIN
435: --
436: gb_debug := hr_utility.debug_enabled;
437: --
438: IF gb_debug THEN
439: lc_proc_name := gc_pkg_name || 'GEN_XML_HEADER';
440: hr_utility.trace ('Entering '||lc_proc_name);

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

436: gb_debug := hr_utility.debug_enabled;
437: --
438: IF gb_debug THEN
439: lc_proc_name := gc_pkg_name || 'GEN_XML_HEADER';
440: hr_utility.trace ('Entering '||lc_proc_name);
441: END IF ;
442: --
443: vxmltable.DELETE;
444: --

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

447: --
448: pay_core_files.write_to_magtape_lob(lc_buf);
449: --
450: IF gb_debug THEN
451: hr_utility.trace ('CLOB contents after appending header information');
452: hr_utility.trace ('Leaving '||lc_proc_name);
453: END IF ;
454: --
455: END gen_xml_header;

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

448: pay_core_files.write_to_magtape_lob(lc_buf);
449: --
450: IF gb_debug THEN
451: hr_utility.trace ('CLOB contents after appending header information');
452: hr_utility.trace ('Leaving '||lc_proc_name);
453: END IF ;
454: --
455: END gen_xml_header;
456: --

Line 485: gb_debug := hr_utility.debug_enabled;

481: lc_proc_name VARCHAR2(100);
482: --
483: BEGIN
484: --
485: gb_debug := hr_utility.debug_enabled;
486: --
487: IF gb_debug THEN
488: lc_proc_name := gc_pkg_name || 'GEN_XML_FOOTER';
489: hr_utility.trace ('Entering '||lc_proc_name);

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

485: gb_debug := hr_utility.debug_enabled;
486: --
487: IF gb_debug THEN
488: lc_proc_name := gc_pkg_name || 'GEN_XML_FOOTER';
489: hr_utility.trace ('Entering '||lc_proc_name);
490: END IF ;
491: lc_buf := '' ;
492: --
493: pay_core_files.write_to_magtape_lob(lc_buf);

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

492: --
493: pay_core_files.write_to_magtape_lob(lc_buf);
494: --
495: IF gb_debug THEN
496: hr_utility.trace ('CLOB contents after appending footer information');
497: hr_utility.trace ('Leaving '||lc_proc_name);
498: END IF ;
499: --
500: END gen_xml_footer;

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

493: pay_core_files.write_to_magtape_lob(lc_buf);
494: --
495: IF gb_debug THEN
496: hr_utility.trace ('CLOB contents after appending footer information');
497: hr_utility.trace ('Leaving '||lc_proc_name);
498: END IF ;
499: --
500: END gen_xml_footer;
501: --

Line 538: gb_debug := hr_utility.debug_enabled;

534: ln_amount NUMBER;
535: --
536: BEGIN
537: --
538: gb_debug := hr_utility.debug_enabled;
539: --
540: IF gb_debug THEN
541: lc_proc_name := gc_pkg_name || 'GENERATE_XML';
542: hr_utility.trace ('Entering '||lc_proc_name);

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

538: gb_debug := hr_utility.debug_enabled;
539: --
540: IF gb_debug THEN
541: lc_proc_name := gc_pkg_name || 'GENERATE_XML';
542: hr_utility.trace ('Entering '||lc_proc_name);
543: END IF ;
544: --
545: ln_cur_assact := pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID' );
546: ln_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );

Line 555: hr_utility.set_location ('ln_cur_assact.. '||ln_cur_assact,20);

551: WHERE payroll_action_id = ln_cur_pact;
552: --
553: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));
554:
555: hr_utility.set_location ('ln_cur_assact.. '||ln_cur_assact,20);
556: hr_utility.set_location ('ln_cur_pact... '||ln_cur_pact,20);
557: hr_utility.set_location ('ln_pact_id .. '||ln_pact_id,20);
558: --
559: SELECT PAA1.assignment_action_id

Line 556: hr_utility.set_location ('ln_cur_pact... '||ln_cur_pact,20);

552: --
553: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));
554:
555: hr_utility.set_location ('ln_cur_assact.. '||ln_cur_assact,20);
556: hr_utility.set_location ('ln_cur_pact... '||ln_cur_pact,20);
557: hr_utility.set_location ('ln_pact_id .. '||ln_pact_id,20);
558: --
559: SELECT PAA1.assignment_action_id
560: INTO ln_old_assact_id

Line 557: hr_utility.set_location ('ln_pact_id .. '||ln_pact_id,20);

553: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));
554:
555: hr_utility.set_location ('ln_cur_assact.. '||ln_cur_assact,20);
556: hr_utility.set_location ('ln_cur_pact... '||ln_cur_pact,20);
557: hr_utility.set_location ('ln_pact_id .. '||ln_pact_id,20);
558: --
559: SELECT PAA1.assignment_action_id
560: INTO ln_old_assact_id
561: FROM pay_assignment_actions PAA,

Line 567: hr_utility.set_location ('ln_old_assact_id ..'||ln_old_assact_id,20);

563: WHERE PAA.assignment_action_id = ln_cur_assact
564: AND PAA.assignment_id = PAA1.assignment_id
565: AND PAA1.payroll_action_id = ln_pact_id;
566: --
567: hr_utility.set_location ('ln_old_assact_id ..'||ln_old_assact_id,20);
568: get_cp_xml(ln_old_assact_id, l_final_xml_string);
569: --
570: ln_offset := 1 ;
571: ln_amount := 500;

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

580: --
581: EXCEPTION
582: WHEN NO_DATA_FOUND THEN
583: IF gb_debug THEN
584: hr_utility.set_location ('Leaving '||lc_proc_name,20);
585: END IF ;
586: WHEN gc_exception THEN
587: IF gb_debug THEN
588: hr_utility.set_location('Error in '||lc_proc_name,999999);

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

584: hr_utility.set_location ('Leaving '||lc_proc_name,20);
585: END IF ;
586: WHEN gc_exception THEN
587: IF gb_debug THEN
588: hr_utility.set_location('Error in '||lc_proc_name,999999);
589: hr_utility.set_location('sqleerm ' || SQLERRM,20);
590: END IF ;
591: hr_utility.raise_error;
592: RAISE;

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

585: END IF ;
586: WHEN gc_exception THEN
587: IF gb_debug THEN
588: hr_utility.set_location('Error in '||lc_proc_name,999999);
589: hr_utility.set_location('sqleerm ' || SQLERRM,20);
590: END IF ;
591: hr_utility.raise_error;
592: RAISE;
593: WHEN OTHERS THEN

Line 591: hr_utility.raise_error;

587: IF gb_debug THEN
588: hr_utility.set_location('Error in '||lc_proc_name,999999);
589: hr_utility.set_location('sqleerm ' || SQLERRM,20);
590: END IF ;
591: hr_utility.raise_error;
592: RAISE;
593: WHEN OTHERS THEN
594: RAISE gc_exception;
595: --

Line 631: gb_debug := hr_utility.debug_enabled;

627: lc_proc_name VARCHAR2(100);
628: BEGIN
629: --
630: lc_proc_name := gc_pkg_name ||'RANGE_CURSOR';
631: gb_debug := hr_utility.debug_enabled;
632: --
633: IF gb_debug THEN
634: hr_utility.trace ('Entering '||lc_proc_name);
635: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);

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

630: lc_proc_name := gc_pkg_name ||'RANGE_CURSOR';
631: gb_debug := hr_utility.debug_enabled;
632: --
633: IF gb_debug THEN
634: hr_utility.trace ('Entering '||lc_proc_name);
635: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
636: END IF;
637: --
638: p_sqlstr := ' select distinct p.person_id'||

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

631: gb_debug := hr_utility.debug_enabled;
632: --
633: IF gb_debug THEN
634: hr_utility.trace ('Entering '||lc_proc_name);
635: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
636: END IF;
637: --
638: p_sqlstr := ' select distinct p.person_id'||
639: ' from per_people_f p,'||

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

644: --
645: g_mag_payroll_action_id := P_PAYROLL_ACTION_ID;
646: --
647: IF gb_debug THEN
648: hr_utility.trace ('Range cursor query : ' || p_sqlstr);
649: hr_utility.trace ('Leaving '||lc_proc_name);
650: END IF;
651: --
652: END range_cursor;

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

645: g_mag_payroll_action_id := P_PAYROLL_ACTION_ID;
646: --
647: IF gb_debug THEN
648: hr_utility.trace ('Range cursor query : ' || p_sqlstr);
649: hr_utility.trace ('Leaving '||lc_proc_name);
650: END IF;
651: --
652: END range_cursor;
653:

Line 756: gb_debug := hr_utility.debug_enabled;

752: ln_ass_set_id NUMBER;
753: lc_include_flag VARCHAR2(1);
754: --
755: BEGIN
756: gb_debug := hr_utility.debug_enabled;
757: --
758: IF gb_debug
759: THEN
760: hr_utility.trace('Entering ACTION_CREATION');

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

756: gb_debug := hr_utility.debug_enabled;
757: --
758: IF gb_debug
759: THEN
760: hr_utility.trace('Entering ACTION_CREATION');
761: END IF;
762: --
763: SELECT legislative_parameters
764: INTO lc_legislative_parameters

Line 772: gb_debug :=hr_utility.debug_enabled ;

768: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));
769: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSETID',lc_legislative_parameters));
770: --
771: g_mag_payroll_action_id:=p_payroll_action_id;
772: gb_debug :=hr_utility.debug_enabled ;
773: --
774:
775: IF gb_debug THEN
776: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';

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

773: --
774:
775: IF gb_debug THEN
776: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
777: hr_utility.trace ('Entering '||lc_proc_name);
778: hr_utility.trace ('Parameters ....');
779: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
780: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
781: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);

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

774:
775: IF gb_debug THEN
776: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
777: hr_utility.trace ('Entering '||lc_proc_name);
778: hr_utility.trace ('Parameters ....');
779: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
780: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
781: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
782: hr_utility.trace ('P_CHUNK = '|| p_chunk);

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

775: IF gb_debug THEN
776: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
777: hr_utility.trace ('Entering '||lc_proc_name);
778: hr_utility.trace ('Parameters ....');
779: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
780: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
781: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
782: hr_utility.trace ('P_CHUNK = '|| p_chunk);
783: END IF;

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

776: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
777: hr_utility.trace ('Entering '||lc_proc_name);
778: hr_utility.trace ('Parameters ....');
779: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
780: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
781: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
782: hr_utility.trace ('P_CHUNK = '|| p_chunk);
783: END IF;
784: --

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

777: hr_utility.trace ('Entering '||lc_proc_name);
778: hr_utility.trace ('Parameters ....');
779: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
780: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
781: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
782: hr_utility.trace ('P_CHUNK = '|| p_chunk);
783: END IF;
784: --
785: initialize(g_mag_payroll_action_id);

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

778: hr_utility.trace ('Parameters ....');
779: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
780: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
781: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
782: hr_utility.trace ('P_CHUNK = '|| p_chunk);
783: END IF;
784: --
785: initialize(g_mag_payroll_action_id);
786: --

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

787: --
788: IF range_person_on THEN
789: -- Range person is enabled
790: IF gb_debug THEN
791: hr_utility.set_location('Inside Range person if condition',20);
792: END IF;
793: -- Assignment Action for Current and Terminated Employees
794: FOR lr_assact IN lcu_assact_r( ln_old_pact_id
795: , gr_parameters.business_group_id

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

798: -- Added NVL to overcome NULL issue.
799: --
800: IF (NVL(ln_ass_set_id ,0) = 0) THEN
801: -- NO assignment set passed as parameter
802: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
803: --
804: SELECT pay_assignment_actions_s.nextval
805: INTO ln_assact
806: FROM dual;

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

834: END LOOP;-- End loop for assignment details cursor
835: ELSE
836: -- Range person is not enabled
837: IF gb_debug THEN
838: hr_utility.set_location('Range person returns false',20);
839: hr_utility.set_location(ln_old_pact_id,20);
840: END IF;
841: -- Assignment Action for Current and Terminated Employe
842: FOR lr_assact IN lcu_assact ( ln_old_pact_id

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

835: ELSE
836: -- Range person is not enabled
837: IF gb_debug THEN
838: hr_utility.set_location('Range person returns false',20);
839: hr_utility.set_location(ln_old_pact_id,20);
840: END IF;
841: -- Assignment Action for Current and Terminated Employe
842: FOR lr_assact IN lcu_assact ( ln_old_pact_id
843: , gr_parameters.business_group_id

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

846: -- Added NVL to overcome NULL issue.
847: --
848: IF (NVL(ln_ass_set_id ,0) = 0) THEN
849: -- NO assignment set passed as parameter
850: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
851: --
852: SELECT pay_assignment_actions_s.nextval
853: INTO ln_assact
854: FROM dual;

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

881: END IF; -- End If for range_person_on
882: --
883: IF gb_debug
884: THEN
885: hr_utility.trace('Leaving ACTION_CREATION');
886: END IF;
887: --
888: END action_creation;
889:

Line 916: gb_debug := hr_utility.debug_enabled;

912: -- None
913: --************************************************************************
914: IS
915: BEGIN
916: gb_debug := hr_utility.debug_enabled;
917: --
918: IF gb_debug THEN
919: hr_utility.trace ('inside INIT_CODE ');
920: END IF;

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

915: BEGIN
916: gb_debug := hr_utility.debug_enabled;
917: --
918: IF gb_debug THEN
919: hr_utility.trace ('inside INIT_CODE ');
920: END IF;
921: --
922: g_mag_payroll_action_id := p_payroll_action_id;
923: --

Line 955: gb_debug := hr_utility.debug_enabled;

951: --************************************************************************
952: IS
953: BEGIN
954: --
955: gb_debug := hr_utility.debug_enabled;
956: --
957: IF gb_debug
958: THEN
959: hr_utility.trace ('Inside ARCHIVE_CODE ');

Line 959: hr_utility.trace ('Inside ARCHIVE_CODE ');

955: gb_debug := hr_utility.debug_enabled;
956: --
957: IF gb_debug
958: THEN
959: hr_utility.trace ('Inside ARCHIVE_CODE ');
960: END IF;
961: --
962: END archive_code;
963: --

Line 1099: gb_debug := hr_utility.debug_enabled;

1095: ln_row_count NUMBER:=0; --bug 9764235
1096: --
1097: BEGIN
1098: --
1099: gb_debug := hr_utility.debug_enabled;
1100: --
1101: IF gb_debug THEN
1102: hr_utility.trace ('Entering assact_xml');
1103: END IF;

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

1098: --
1099: gb_debug := hr_utility.debug_enabled;
1100: --
1101: IF gb_debug THEN
1102: hr_utility.trace ('Entering assact_xml');
1103: END IF;
1104: --
1105: vXMLTable.DELETE;
1106: gn_vctr := 0;

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

1335: CLOSE cur_uite_emp;
1336: --
1337: --
1338: IF gb_debug THEN
1339: hr_utility.trace ('Leaving assact_xml');
1340: END IF;
1341: --
1342: EXCEPTION
1343: WHEN gc_exception THEN

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

1341: --
1342: EXCEPTION
1343: WHEN gc_exception THEN
1344: IF gb_debug THEN
1345: hr_utility.set_location('Error in assact_xml ',999999);
1346: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1347: hr_utility.raise_error;
1348: END IF;
1349: WHEN OTHERS THEN

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

1342: EXCEPTION
1343: WHEN gc_exception THEN
1344: IF gb_debug THEN
1345: hr_utility.set_location('Error in assact_xml ',999999);
1346: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1347: hr_utility.raise_error;
1348: END IF;
1349: WHEN OTHERS THEN
1350: RAISE gc_exception;

Line 1347: hr_utility.raise_error;

1343: WHEN gc_exception THEN
1344: IF gb_debug THEN
1345: hr_utility.set_location('Error in assact_xml ',999999);
1346: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1347: hr_utility.raise_error;
1348: END IF;
1349: WHEN OTHERS THEN
1350: RAISE gc_exception;
1351: END assact_xml;

Line 1383: gb_debug := hr_utility.debug_enabled;

1379: lc_buf VARCHAR2(255);
1380: --
1381: BEGIN
1382: --
1383: gb_debug := hr_utility.debug_enabled;
1384: --
1385: IF gb_debug THEN
1386: hr_utility.trace ('Entering PRINT_CLOB');
1387: END IF;

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

1382: --
1383: gb_debug := hr_utility.debug_enabled;
1384: --
1385: IF gb_debug THEN
1386: hr_utility.trace ('Entering PRINT_CLOB');
1387: END IF;
1388: --
1389: ln_chars := 240;
1390: ln_offset := 1;

Line 1398: hr_utility.trace(lc_buf);

1394: , ln_chars
1395: , ln_offset
1396: , lc_buf
1397: );
1398: hr_utility.trace(lc_buf);
1399: ln_offset := ln_offset + ln_chars;
1400: END LOOP;
1401: --
1402: EXCEPTION

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

1401: --
1402: EXCEPTION
1403: WHEN NO_DATA_FOUND THEN
1404: IF gb_debug THEN
1405: hr_utility.trace ('CLOB contents end.');
1406: END IF;
1407: --
1408: END print_clob;
1409: --

Line 1441: gb_debug := hr_utility.debug_enabled;

1437: l_tempclob CLOB;
1438: ln_ctr_table NUMBER;
1439: BEGIN
1440: --
1441: gb_debug := hr_utility.debug_enabled;
1442: --
1443: IF gb_debug THEN
1444: hr_utility.trace('Entering WRITETOCLOB');
1445: END IF;

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

1440: --
1441: gb_debug := hr_utility.debug_enabled;
1442: --
1443: IF gb_debug THEN
1444: hr_utility.trace('Entering WRITETOCLOB');
1445: END IF;
1446: --
1447: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1448: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);

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

1455: END LOOP;
1456: p_write_xml := g_xfdf_string;
1457: --
1458: IF gb_debug THEN
1459: hr_utility.set_location('Out of loop ', 99);
1460: END IF;
1461: --
1462: dbms_lob.close(g_xfdf_string);
1463: IF gb_debug THEN

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

1460: END IF;
1461: --
1462: dbms_lob.close(g_xfdf_string);
1463: IF gb_debug THEN
1464: hr_utility.trace('Leaving WRITETOCLOB');
1465: END IF;
1466: --
1467: EXCEPTION
1468: WHEN gc_exception THEN

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

1466: --
1467: EXCEPTION
1468: WHEN gc_exception THEN
1469: IF gb_debug THEN
1470: hr_utility.set_location('Error in writetoclob ',999999);
1471: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1472: hr_utility.raise_error;
1473: END IF;
1474: WHEN OTHERS THEN

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

1467: EXCEPTION
1468: WHEN gc_exception THEN
1469: IF gb_debug THEN
1470: hr_utility.set_location('Error in writetoclob ',999999);
1471: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1472: hr_utility.raise_error;
1473: END IF;
1474: WHEN OTHERS THEN
1475: RAISE gc_exception;

Line 1472: hr_utility.raise_error;

1468: WHEN gc_exception THEN
1469: IF gb_debug THEN
1470: hr_utility.set_location('Error in writetoclob ',999999);
1471: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1472: hr_utility.raise_error;
1473: END IF;
1474: WHEN OTHERS THEN
1475: RAISE gc_exception;
1476: --

Line 1510: gb_debug := hr_utility.debug_enabled;

1506: IS
1507: --
1508: BEGIN
1509: --
1510: gb_debug := hr_utility.debug_enabled;
1511: --
1512: IF gb_debug THEN
1513: hr_utility.trace('Entering GET_CP_XML');
1514: END IF;

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

1509: --
1510: gb_debug := hr_utility.debug_enabled;
1511: --
1512: IF gb_debug THEN
1513: hr_utility.trace('Entering GET_CP_XML');
1514: END IF;
1515: --
1516: assact_xml(p_assignment_action_id);
1517: writetoclob (p_xml);

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

1516: assact_xml(p_assignment_action_id);
1517: writetoclob (p_xml);
1518: --
1519: IF gb_debug THEN
1520: hr_utility.trace('Leaving GET_CP_XML');
1521: END IF;
1522: --
1523: END get_cp_xml;
1524: --

Line 1571: gb_debug := hr_utility.debug_enabled;

1567: lc_order_by VARCHAR2(100);
1568:
1569: BEGIN
1570: --
1571: gb_debug := hr_utility.debug_enabled;
1572: --
1573: IF gb_debug THEN
1574: hr_utility.set_location('Entering sort_action procedure',20);
1575: END IF;

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

1570: --
1571: gb_debug := hr_utility.debug_enabled;
1572: --
1573: IF gb_debug THEN
1574: hr_utility.set_location('Entering sort_action procedure',20);
1575: END IF;
1576: --
1577: hr_utility.trace('Beginning of the sort_action cursor');
1578: --

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

1573: IF gb_debug THEN
1574: hr_utility.set_location('Entering sort_action procedure',20);
1575: END IF;
1576: --
1577: hr_utility.trace('Beginning of the sort_action cursor');
1578: --
1579: initialize(p_payroll_action_id);
1580:
1581:

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

1607:
1608: len := length(sqlstr);
1609: IF gb_debug
1610: THEN
1611: hr_utility.trace('End of the sort_Action cursor');
1612: END IF;
1613: --
1614: EXCEPTION WHEN NO_DATA_FOUND THEN
1615: IF gb_debug THEN

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

1612: END IF;
1613: --
1614: EXCEPTION WHEN NO_DATA_FOUND THEN
1615: IF gb_debug THEN
1616: hr_utility.trace('Error in Sort Procedure - getting legislative param');
1617: END IF;
1618: RAISE;
1619: --
1620: END sort_action;