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

Line 93: gb_debug := hr_utility.debug_enabled;

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

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

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

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

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

Line 144: gb_debug := hr_utility.debug_enabled;

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

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

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

Line 214: gb_debug := hr_utility.debug_enabled;

210: lc_action_param_val VARCHAR2(30);
211: --
212: BEGIN
213: --
214: gb_debug := hr_utility.debug_enabled;
215: --
216: IF gb_debug THEN
217: hr_utility.set_location('Entering range_person_on',10);
218: END IF;

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

213: --
214: gb_debug := hr_utility.debug_enabled;
215: --
216: IF gb_debug THEN
217: hr_utility.set_location('Entering range_person_on',10);
218: END IF;
219: --
220: OPEN lcu_action_parameter;
221: FETCH lcu_action_parameter INTO lc_action_param_val;

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

223: --
224: IF lc_action_param_val = 'Y' THEN
225: lb_return := TRUE;
226: IF gb_debug THEN
227: hr_utility.set_location('Range Person = True',10);
228: END IF;
229: ELSE
230: lb_return := FALSE;
231: END IF;

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

230: lb_return := FALSE;
231: END IF;
232: --
233: IF gb_debug THEN
234: hr_utility.set_location('Leaving range_person_on',10);
235: END IF;
236:
237: RETURN lb_return;
238: --

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

237: RETURN lb_return;
238: --
239: EXCEPTION WHEN NO_DATA_FOUND THEN
240: IF gb_debug THEN
241: hr_utility.set_location('No Data Found Exception in range_person_on',10);
242: END IF;
243: lb_return := FALSE;
244: RETURN lb_return;
245: END range_person_on;

Line 287: gb_debug := hr_utility.debug_enabled;

283: ln_output3 NUMBER;
284: BEGIN
285: --
286: lc_proc_name := gc_pkg_name ||'GET_VALUES';
287: gb_debug := hr_utility.debug_enabled;
288: --
289: IF gb_debug THEN
290: hr_utility.trace ('Entering '||lc_proc_name);
291: END IF;

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

286: lc_proc_name := gc_pkg_name ||'GET_VALUES';
287: gb_debug := hr_utility.debug_enabled;
288: --
289: IF gb_debug THEN
290: hr_utility.trace ('Entering '||lc_proc_name);
291: END IF;
292: ln_input := TO_NUMBER(p_input,'999999999');
293: lc_input := TO_CHAR(ln_input);
294:

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

340: -- p_output1 := TO_CHAR(ln_output3);
341:
342: --
343: IF gb_debug THEN
344: hr_utility.trace ('Leaving '||lc_proc_name);
345: END IF;
346: --
347: END get_values;
348:

Line 395: gb_debug :=hr_utility.debug_enabled ;

391: lc_procedure VARCHAR2(200);
392: --
393: BEGIN
394: --
395: gb_debug :=hr_utility.debug_enabled ;
396: IF gb_debug THEN
397: lc_procedure := gc_pkg_name||'initialize';
398: hr_utility.set_location('Entering '||lc_procedure,1);
399: END IF;

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

394: --
395: gb_debug :=hr_utility.debug_enabled ;
396: IF gb_debug THEN
397: lc_procedure := gc_pkg_name||'initialize';
398: hr_utility.set_location('Entering '||lc_procedure,1);
399: END IF;
400: --
401: -- Fetch the parameters passed by user into global variable.
402: --

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

404: FETCH lcr_params into gr_parameters;
405: CLOSE lcr_params;
406:
407: IF gb_debug THEN
408: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
409: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
410: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
411: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
412: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);

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

405: CLOSE lcr_params;
406:
407: IF gb_debug THEN
408: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
409: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
410: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
411: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
412: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);

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

406:
407: IF gb_debug THEN
408: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
409: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
410: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
411: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
412: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);
414: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);

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

407: IF gb_debug THEN
408: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
409: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
410: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
411: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
412: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);
414: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
415: hr_utility.set_location('gr_parameters.termination_date_from = ' || gr_parameters.termination_date_from,30);

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

408: hr_utility.set_location('gr_parameters.rep_group = ' || gr_parameters.rep_group,30);
409: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
410: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
411: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
412: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);
414: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
415: hr_utility.set_location('gr_parameters.termination_date_from = ' || gr_parameters.termination_date_from,30);
416: hr_utility.set_location('gr_parameters.termination_date_to = ' || gr_parameters.termination_date_to,30);

Line 413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);

409: hr_utility.set_location('gr_parameters.rep_cat = ' || gr_parameters.rep_cat,30);
410: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
411: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
412: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);
414: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
415: hr_utility.set_location('gr_parameters.termination_date_from = ' || gr_parameters.termination_date_from,30);
416: hr_utility.set_location('gr_parameters.termination_date_to = ' || gr_parameters.termination_date_to,30);
417: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);

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

410: hr_utility.set_location('gr_parameters.business_group_id = ' || gr_parameters.business_group_id,30);
411: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
412: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);
414: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
415: hr_utility.set_location('gr_parameters.termination_date_from = ' || gr_parameters.termination_date_from,30);
416: hr_utility.set_location('gr_parameters.termination_date_to = ' || gr_parameters.termination_date_to,30);
417: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
418: END IF;

Line 415: hr_utility.set_location('gr_parameters.termination_date_from = ' || gr_parameters.termination_date_from,30);

411: hr_utility.set_location('gr_parameters.effective_date = ' || gr_parameters.effective_date,30);
412: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);
414: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
415: hr_utility.set_location('gr_parameters.termination_date_from = ' || gr_parameters.termination_date_from,30);
416: hr_utility.set_location('gr_parameters.termination_date_to = ' || gr_parameters.termination_date_to,30);
417: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
418: END IF;
419: --

Line 416: hr_utility.set_location('gr_parameters.termination_date_to = ' || gr_parameters.termination_date_to,30);

412: hr_utility.set_location('gr_parameters.subject_year = ' || gr_parameters.subject_year,30);
413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);
414: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
415: hr_utility.set_location('gr_parameters.termination_date_from = ' || gr_parameters.termination_date_from,30);
416: hr_utility.set_location('gr_parameters.termination_date_to = ' || gr_parameters.termination_date_to,30);
417: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
418: END IF;
419: --
420: IF gb_debug THEN

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

413: hr_utility.set_location('gr_parameters.withholding_agent = ' || gr_parameters.withholding_agent,30);
414: hr_utility.set_location('gr_parameters.sort_order = ' || gr_parameters.sort_order,30);
415: hr_utility.set_location('gr_parameters.termination_date_from = ' || gr_parameters.termination_date_from,30);
416: hr_utility.set_location('gr_parameters.termination_date_to = ' || gr_parameters.termination_date_to,30);
417: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
418: END IF;
419: --
420: IF gb_debug THEN
421: hr_utility.set_location('Leaving '||lc_procedure,1000);

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

417: hr_utility.set_location('gr_parameters.ass_setid = ' || gr_parameters.ass_setid,30);
418: END IF;
419: --
420: IF gb_debug THEN
421: hr_utility.set_location('Leaving '||lc_procedure,1000);
422: END IF;
423: --
424: EXCEPTION
425: WHEN gc_exception THEN

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

423: --
424: EXCEPTION
425: WHEN gc_exception THEN
426: IF gb_debug THEN
427: hr_utility.set_location('Error in '||lc_procedure,999999);
428: END IF;
429: RAISE;
430: WHEN OTHERS THEN
431: RAISE gc_exception;

Line 462: gb_debug := hr_utility.debug_enabled;

458: lc_buf VARCHAR2(2000);
459: --
460: BEGIN
461: --
462: gb_debug := hr_utility.debug_enabled;
463: --
464: IF gb_debug THEN
465: lc_proc_name := gc_pkg_name || 'GEN_XML_HEADER';
466: hr_utility.trace ('Entering '||lc_proc_name);

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

462: gb_debug := hr_utility.debug_enabled;
463: --
464: IF gb_debug THEN
465: lc_proc_name := gc_pkg_name || 'GEN_XML_HEADER';
466: hr_utility.trace ('Entering '||lc_proc_name);
467: END IF ;
468: --
469: vxmltable.DELETE;
470: --

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

473: --
474: pay_core_files.write_to_magtape_lob(lc_buf);
475: --
476: IF gb_debug THEN
477: hr_utility.trace ('CLOB contents after appending header information');
478: hr_utility.trace ('Leaving '||lc_proc_name);
479: END IF ;
480: --
481: END gen_xml_header;

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

474: pay_core_files.write_to_magtape_lob(lc_buf);
475: --
476: IF gb_debug THEN
477: hr_utility.trace ('CLOB contents after appending header information');
478: hr_utility.trace ('Leaving '||lc_proc_name);
479: END IF ;
480: --
481: END gen_xml_header;
482: --

Line 511: gb_debug := hr_utility.debug_enabled;

507: lc_proc_name VARCHAR2(100);
508: --
509: BEGIN
510: --
511: gb_debug := hr_utility.debug_enabled;
512: --
513: IF gb_debug THEN
514: lc_proc_name := gc_pkg_name || 'GEN_XML_FOOTER';
515: hr_utility.trace ('Entering '||lc_proc_name);

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

511: gb_debug := hr_utility.debug_enabled;
512: --
513: IF gb_debug THEN
514: lc_proc_name := gc_pkg_name || 'GEN_XML_FOOTER';
515: hr_utility.trace ('Entering '||lc_proc_name);
516: END IF ;
517: lc_buf := '' ;
518: --
519: pay_core_files.write_to_magtape_lob(lc_buf);

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

518: --
519: pay_core_files.write_to_magtape_lob(lc_buf);
520: --
521: IF gb_debug THEN
522: hr_utility.trace ('CLOB contents after appending footer information');
523: hr_utility.trace ('Leaving '||lc_proc_name);
524: END IF ;
525: --
526: END gen_xml_footer;

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

519: pay_core_files.write_to_magtape_lob(lc_buf);
520: --
521: IF gb_debug THEN
522: hr_utility.trace ('CLOB contents after appending footer information');
523: hr_utility.trace ('Leaving '||lc_proc_name);
524: END IF ;
525: --
526: END gen_xml_footer;
527: --

Line 568: gb_debug := hr_utility.debug_enabled;

564:
565: --
566: BEGIN
567: --
568: gb_debug := hr_utility.debug_enabled;
569: --
570: IF gb_debug THEN
571: lc_proc_name := gc_pkg_name || 'GENERATE_XML';
572: hr_utility.trace ('Entering '||lc_proc_name);

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

568: gb_debug := hr_utility.debug_enabled;
569: --
570: IF gb_debug THEN
571: lc_proc_name := gc_pkg_name || 'GENERATE_XML';
572: hr_utility.trace ('Entering '||lc_proc_name);
573: END IF ;
574: --
575: ln_cur_assact := pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID' );
576: ln_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );

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

581: WHERE payroll_action_id = ln_cur_pact;
582: --
583:
584:
585: hr_utility.set_location ('ln_cur_assact.. '||ln_cur_assact,20);
586: hr_utility.set_location ('ln_cur_pact... '||ln_cur_pact,20);
587: --
588:
589: SELECT assignment_id

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

582: --
583:
584:
585: hr_utility.set_location ('ln_cur_assact.. '||ln_cur_assact,20);
586: hr_utility.set_location ('ln_cur_pact... '||ln_cur_pact,20);
587: --
588:
589: SELECT assignment_id
590: INTO ln_assignment_id

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

606: --
607: EXCEPTION
608: WHEN NO_DATA_FOUND THEN
609: IF gb_debug THEN
610: hr_utility.set_location ('Leaving '||lc_proc_name,20);
611: END IF ;
612: WHEN gc_exception THEN
613: IF gb_debug THEN
614: hr_utility.set_location('Error in '||lc_proc_name,999999);

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

610: hr_utility.set_location ('Leaving '||lc_proc_name,20);
611: END IF ;
612: WHEN gc_exception THEN
613: IF gb_debug THEN
614: hr_utility.set_location('Error in '||lc_proc_name,999999);
615: hr_utility.set_location('sqleerm ' || SQLERRM,20);
616: END IF ;
617: hr_utility.raise_error;
618: RAISE;

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

611: END IF ;
612: WHEN gc_exception THEN
613: IF gb_debug THEN
614: hr_utility.set_location('Error in '||lc_proc_name,999999);
615: hr_utility.set_location('sqleerm ' || SQLERRM,20);
616: END IF ;
617: hr_utility.raise_error;
618: RAISE;
619: WHEN OTHERS THEN

Line 617: hr_utility.raise_error;

613: IF gb_debug THEN
614: hr_utility.set_location('Error in '||lc_proc_name,999999);
615: hr_utility.set_location('sqleerm ' || SQLERRM,20);
616: END IF ;
617: hr_utility.raise_error;
618: RAISE;
619: WHEN OTHERS THEN
620: RAISE gc_exception;
621: --

Line 657: gb_debug := hr_utility.debug_enabled;

653: lc_proc_name VARCHAR2(100);
654: BEGIN
655: --
656: lc_proc_name := gc_pkg_name ||'RANGE_CURSOR';
657: gb_debug := hr_utility.debug_enabled;
658: --
659: IF gb_debug THEN
660: hr_utility.trace ('Entering '||lc_proc_name);
661: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);

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

656: lc_proc_name := gc_pkg_name ||'RANGE_CURSOR';
657: gb_debug := hr_utility.debug_enabled;
658: --
659: IF gb_debug THEN
660: hr_utility.trace ('Entering '||lc_proc_name);
661: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
662: END IF;
663: --
664: p_sqlstr := ' select distinct p.person_id'||

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

657: gb_debug := hr_utility.debug_enabled;
658: --
659: IF gb_debug THEN
660: hr_utility.trace ('Entering '||lc_proc_name);
661: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
662: END IF;
663: --
664: p_sqlstr := ' select distinct p.person_id'||
665: ' from per_people_f p,'||

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

670: --
671: g_mag_payroll_action_id := P_PAYROLL_ACTION_ID;
672: --
673: IF gb_debug THEN
674: hr_utility.trace ('Range cursor query : ' || p_sqlstr);
675: hr_utility.trace ('Leaving '||lc_proc_name);
676: END IF;
677: --
678: END range_cursor;

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

671: g_mag_payroll_action_id := P_PAYROLL_ACTION_ID;
672: --
673: IF gb_debug THEN
674: hr_utility.trace ('Range cursor query : ' || p_sqlstr);
675: hr_utility.trace ('Leaving '||lc_proc_name);
676: END IF;
677: --
678: END range_cursor;
679:

Line 795: gb_debug := hr_utility.debug_enabled;

791: ln_ass_set_id NUMBER;
792: lc_include_flag VARCHAR2(1);
793: --
794: BEGIN
795: gb_debug := hr_utility.debug_enabled;
796: --
797: IF gb_debug
798: THEN
799: hr_utility.trace('Entering ACTION_CREATION');

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

795: gb_debug := hr_utility.debug_enabled;
796: --
797: IF gb_debug
798: THEN
799: hr_utility.trace('Entering ACTION_CREATION');
800: END IF;
801: --
802: SELECT legislative_parameters
803: INTO lc_legislative_parameters

Line 810: gb_debug := hr_utility.debug_enabled ;

806: --
807: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));
808: --
809: g_mag_payroll_action_id := p_payroll_action_id;
810: gb_debug := hr_utility.debug_enabled ;
811: --
812:
813: IF gb_debug THEN
814: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';

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

811: --
812:
813: IF gb_debug THEN
814: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
815: hr_utility.trace ('Entering '||lc_proc_name);
816: hr_utility.trace ('Parameters ....');
817: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
818: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
819: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);

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

812:
813: IF gb_debug THEN
814: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
815: hr_utility.trace ('Entering '||lc_proc_name);
816: hr_utility.trace ('Parameters ....');
817: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
818: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
819: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
820: hr_utility.trace ('P_CHUNK = '|| p_chunk);

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

813: IF gb_debug THEN
814: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
815: hr_utility.trace ('Entering '||lc_proc_name);
816: hr_utility.trace ('Parameters ....');
817: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
818: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
819: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
820: hr_utility.trace ('P_CHUNK = '|| p_chunk);
821: END IF;

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

814: lc_proc_name := gc_pkg_name ||'ACTION_CREATION';
815: hr_utility.trace ('Entering '||lc_proc_name);
816: hr_utility.trace ('Parameters ....');
817: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
818: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
819: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
820: hr_utility.trace ('P_CHUNK = '|| p_chunk);
821: END IF;
822: --

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

815: hr_utility.trace ('Entering '||lc_proc_name);
816: hr_utility.trace ('Parameters ....');
817: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
818: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
819: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
820: hr_utility.trace ('P_CHUNK = '|| p_chunk);
821: END IF;
822: --
823: initialize(g_mag_payroll_action_id);

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

816: hr_utility.trace ('Parameters ....');
817: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
818: hr_utility.trace ('P_START_PERSON_ID = '|| p_start_person_id);
819: hr_utility.trace ('P_END_PERSON_ID = '|| p_end_person_id);
820: hr_utility.trace ('P_CHUNK = '|| p_chunk);
821: END IF;
822: --
823: initialize(g_mag_payroll_action_id);
824: --

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

825: --
826: IF range_person_on THEN
827: -- Range person is enabled
828: IF gb_debug THEN
829: hr_utility.set_location('Inside Range person if condition',20);
830: END IF;
831: -- Assignment Action for Current and Terminated Employees
832: FOR lr_assact IN lcu_assact_r( gr_parameters.business_group_id
833: , gr_parameters.subject_year

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

839: -- Added NVL to overcome NULL issue.
840: --
841: IF (NVL(ln_ass_set_id ,0) = 0) THEN
842: -- NO assignment set passed as parameter
843: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
844: --
845: SELECT pay_assignment_actions_s.nextval
846: INTO ln_assact
847: FROM dual;

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

875: END LOOP;-- End loop for assignment details cursor
876: ELSE
877: -- Range person is not enabled
878: IF gb_debug THEN
879: hr_utility.set_location('Range person returns false',20);
880: END IF;
881: -- Assignment Action for Current and Terminated Employe
882: FOR lr_assact IN lcu_assact ( gr_parameters.business_group_id
883: , gr_parameters.subject_year

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

889: -- Added NVL to overcome NULL issue.
890: --
891: IF (NVL(ln_ass_set_id ,0) = 0) THEN
892: -- NO assignment set passed as parameter
893: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
894: --
895: SELECT pay_assignment_actions_s.nextval
896: INTO ln_assact
897: FROM dual;

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

925: END IF; -- End If for range_person_on
926: --
927: IF gb_debug
928: THEN
929: hr_utility.trace('Leaving ACTION_CREATION');
930: END IF;
931: --
932: END action_creation;
933:

Line 960: gb_debug := hr_utility.debug_enabled;

956: -- None
957: --************************************************************************
958: IS
959: BEGIN
960: gb_debug := hr_utility.debug_enabled;
961: --
962: IF gb_debug THEN
963: hr_utility.trace ('inside INIT_CODE ');
964: END IF;

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

959: BEGIN
960: gb_debug := hr_utility.debug_enabled;
961: --
962: IF gb_debug THEN
963: hr_utility.trace ('inside INIT_CODE ');
964: END IF;
965: --
966: g_mag_payroll_action_id := p_payroll_action_id;
967: --

Line 999: gb_debug := hr_utility.debug_enabled;

995: --************************************************************************
996: IS
997: BEGIN
998: --
999: gb_debug := hr_utility.debug_enabled;
1000: --
1001: IF gb_debug
1002: THEN
1003: hr_utility.trace ('inside ARCHIVE_CODE ');

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

999: gb_debug := hr_utility.debug_enabled;
1000: --
1001: IF gb_debug
1002: THEN
1003: hr_utility.trace ('inside ARCHIVE_CODE ');
1004: END IF;
1005: --
1006: END archive_code;
1007: --

Line 1108: gb_debug := hr_utility.debug_enabled;

1104:
1105: --
1106: BEGIN
1107: --
1108: gb_debug := hr_utility.debug_enabled;
1109: --
1110: IF gb_debug THEN
1111: hr_utility.trace ('Entering assact_xml');
1112: END IF;

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

1107: --
1108: gb_debug := hr_utility.debug_enabled;
1109: --
1110: IF gb_debug THEN
1111: hr_utility.trace ('Entering assact_xml');
1112: END IF;
1113: --
1114: vXMLTable.DELETE;
1115: gn_vctr := 0;

Line 1137: hr_utility.trace ('lr_iwht_emp.assignment_action_id '||lr_iwht_emp.assignment_action_id);

1133: --
1134: FOR seq in 1 .. 4
1135: LOOP
1136:
1137: hr_utility.trace ('lr_iwht_emp.assignment_action_id '||lr_iwht_emp.assignment_action_id);
1138:
1139: OPEN cur_iwht_tax(p_assignment_id);
1140: FETCH cur_iwht_tax INTO lr_iwht_tax;
1141: CLOSE cur_iwht_tax;

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

1263: CLOSE cur_iwht_emp;
1264: --
1265: --
1266: IF gb_debug THEN
1267: hr_utility.trace ('Leaving assact_xml');
1268: END IF;
1269: --
1270: EXCEPTION
1271: WHEN gc_exception THEN

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

1269: --
1270: EXCEPTION
1271: WHEN gc_exception THEN
1272: IF gb_debug THEN
1273: hr_utility.set_location('Error in assact_xml ',999999);
1274: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1275: hr_utility.raise_error;
1276: END IF;
1277: WHEN OTHERS THEN

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

1270: EXCEPTION
1271: WHEN gc_exception THEN
1272: IF gb_debug THEN
1273: hr_utility.set_location('Error in assact_xml ',999999);
1274: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1275: hr_utility.raise_error;
1276: END IF;
1277: WHEN OTHERS THEN
1278: RAISE gc_exception;

Line 1275: hr_utility.raise_error;

1271: WHEN gc_exception THEN
1272: IF gb_debug THEN
1273: hr_utility.set_location('Error in assact_xml ',999999);
1274: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1275: hr_utility.raise_error;
1276: END IF;
1277: WHEN OTHERS THEN
1278: RAISE gc_exception;
1279: END assact_xml;

Line 1311: gb_debug := hr_utility.debug_enabled;

1307: lc_buf VARCHAR2(255);
1308: --
1309: BEGIN
1310: --
1311: gb_debug := hr_utility.debug_enabled;
1312: --
1313: IF gb_debug THEN
1314: hr_utility.trace ('Entering PRINT_CLOB');
1315: END IF;

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

1310: --
1311: gb_debug := hr_utility.debug_enabled;
1312: --
1313: IF gb_debug THEN
1314: hr_utility.trace ('Entering PRINT_CLOB');
1315: END IF;
1316: --
1317: ln_chars := 240;
1318: ln_offset := 1;

Line 1326: hr_utility.trace(lc_buf);

1322: , ln_chars
1323: , ln_offset
1324: , lc_buf
1325: );
1326: hr_utility.trace(lc_buf);
1327: ln_offset := ln_offset + ln_chars;
1328: END LOOP;
1329: --
1330: EXCEPTION

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

1329: --
1330: EXCEPTION
1331: WHEN NO_DATA_FOUND THEN
1332: IF gb_debug THEN
1333: hr_utility.trace ('CLOB contents end.');
1334: END IF;
1335: --
1336: END print_clob;
1337: --

Line 1369: gb_debug := hr_utility.debug_enabled;

1365: l_tempclob CLOB;
1366: ln_ctr_table NUMBER;
1367: BEGIN
1368: --
1369: gb_debug := hr_utility.debug_enabled;
1370: --
1371: IF gb_debug THEN
1372: hr_utility.trace('Entering WRITETOCLOB');
1373: END IF;

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

1368: --
1369: gb_debug := hr_utility.debug_enabled;
1370: --
1371: IF gb_debug THEN
1372: hr_utility.trace('Entering WRITETOCLOB');
1373: END IF;
1374: --
1375: dbms_lob.createtemporary(g_xfdf_string,FALSE,DBMS_LOB.CALL);
1376: dbms_lob.open(g_xfdf_string,dbms_lob.lob_readwrite);

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

1382: END LOOP;
1383: p_write_xml := g_xfdf_string;
1384: --
1385: IF gb_debug THEN
1386: hr_utility.set_location('Out of loop ', 99);
1387: END IF;
1388: --
1389: dbms_lob.close(g_xfdf_string);
1390: IF gb_debug THEN

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

1387: END IF;
1388: --
1389: dbms_lob.close(g_xfdf_string);
1390: IF gb_debug THEN
1391: hr_utility.trace('Leaving WRITETOCLOB');
1392: END IF;
1393: --
1394: EXCEPTION
1395: WHEN gc_exception THEN

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

1393: --
1394: EXCEPTION
1395: WHEN gc_exception THEN
1396: IF gb_debug THEN
1397: hr_utility.set_location('Error in writetoclob ',999999);
1398: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1399: hr_utility.raise_error;
1400: END IF;
1401: WHEN OTHERS THEN

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

1394: EXCEPTION
1395: WHEN gc_exception THEN
1396: IF gb_debug THEN
1397: hr_utility.set_location('Error in writetoclob ',999999);
1398: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1399: hr_utility.raise_error;
1400: END IF;
1401: WHEN OTHERS THEN
1402: RAISE gc_exception;

Line 1399: hr_utility.raise_error;

1395: WHEN gc_exception THEN
1396: IF gb_debug THEN
1397: hr_utility.set_location('Error in writetoclob ',999999);
1398: hr_utility.set_location('sqleerm ' || SQLERRM,20);
1399: hr_utility.raise_error;
1400: END IF;
1401: WHEN OTHERS THEN
1402: RAISE gc_exception;
1403: --

Line 1437: gb_debug := hr_utility.debug_enabled;

1433: IS
1434: --
1435: BEGIN
1436: --
1437: gb_debug := hr_utility.debug_enabled;
1438: --
1439: IF gb_debug THEN
1440: hr_utility.trace('Entering GET_CP_XML');
1441: END IF;

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

1436: --
1437: gb_debug := hr_utility.debug_enabled;
1438: --
1439: IF gb_debug THEN
1440: hr_utility.trace('Entering GET_CP_XML');
1441: END IF;
1442: --
1443: -- assact_xml(p_assignment_action_id);
1444: assact_xml(p_assignment_id);

Line 1445: hr_utility.trace ('Phase of error1...');

1441: END IF;
1442: --
1443: -- assact_xml(p_assignment_action_id);
1444: assact_xml(p_assignment_id);
1445: hr_utility.trace ('Phase of error1...');
1446: writetoclob (p_xml);
1447: --
1448: IF gb_debug THEN
1449: hr_utility.trace('Leaving GET_CP_XML');

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

1445: hr_utility.trace ('Phase of error1...');
1446: writetoclob (p_xml);
1447: --
1448: IF gb_debug THEN
1449: hr_utility.trace('Leaving GET_CP_XML');
1450: END IF;
1451: --
1452: END get_cp_xml;
1453: --

Line 1500: gb_debug := hr_utility.debug_enabled;

1496: lc_order_by VARCHAR2(100);
1497:
1498: BEGIN
1499: --
1500: gb_debug := hr_utility.debug_enabled;
1501: --
1502: IF gb_debug THEN
1503: hr_utility.set_location('Entering sort_action procedure',20);
1504: END IF;

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

1499: --
1500: gb_debug := hr_utility.debug_enabled;
1501: --
1502: IF gb_debug THEN
1503: hr_utility.set_location('Entering sort_action procedure',20);
1504: END IF;
1505: --
1506: hr_utility.trace('Beginning of the sort_action cursor');
1507: --

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

1502: IF gb_debug THEN
1503: hr_utility.set_location('Entering sort_action procedure',20);
1504: END IF;
1505: --
1506: hr_utility.trace('Beginning of the sort_action cursor');
1507: --
1508: initialize(p_payroll_action_id);
1509: -- Added below for the Bug # 9569078
1510: IF (gr_parameters.sort_order = 'EMPLOYEE_NUMBER') THEN

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

1541: len := length(sqlstr);
1542:
1543: IF gb_debug
1544: THEN
1545: hr_utility.trace('End of the sort_Action cursor');
1546: END IF;
1547: --
1548: EXCEPTION WHEN NO_DATA_FOUND THEN
1549: IF gb_debug THEN

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

1546: END IF;
1547: --
1548: EXCEPTION WHEN NO_DATA_FOUND THEN
1549: IF gb_debug THEN
1550: hr_utility.trace('Error in Sort Procedure - getting legislative param');
1551: END IF;
1552: RAISE;
1553: --
1554: END sort_action;