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

Line 36: Purpose : Log a message, either using fnd_file, or hr_utility.trace

32:
33:
34: /******************************************************************************
35: Name : msg
36: Purpose : Log a message, either using fnd_file, or hr_utility.trace
37: ******************************************************************************/
38:
39: PROCEDURE msg(p_text VARCHAR2)
40: IS

Line 50: Purpose : Log a message, either using fnd_file, or hr_utility.trace

46: END msg;
47:
48: /******************************************************************************
49: Name : dbg
50: Purpose : Log a message, either using fnd_file, or hr_utility.trace
51: if debuggging is enabled
52: ******************************************************************************/
53: PROCEDURE dbg(p_text VARCHAR2) IS
54:

Line 63: hr_utility.trace(p_text);

59: -- Write to the concurrent request log
60: fnd_file.put_line(fnd_file.log, p_text);
61: ELSE
62: -- Use HR trace
63: hr_utility.trace(p_text);
64: END IF;
65: END IF;
66:
67: END dbg;

Line 226: hr_utility.set_location(l_procedure_name, 1);

222: c_actions_sql varchar2(10000);
223:
224: begin
225: l_procedure_name := 'action_creation_format37';
226: hr_utility.set_location(l_procedure_name, 1);
227:
228: Begin
229: select report_format
230: into l_report_format

Line 242: hr_utility.set_location(l_procedure_name, 2);

238: When Others Then
239: l_report_format := Null ;
240: End ;
241:
242: hr_utility.set_location(l_procedure_name, 2);
243: l_range_person_on := pay_ac_utility.range_person_on
244: ( p_report_type => p_report_type,
245: p_report_format => l_report_format,
246: p_report_qualifier => p_report_qualifier,

Line 256: hr_utility.set_location(l_procedure_name, 5);

252: (p_per_id is null ) and
253: (p_curp is null ) and
254: (p_asg_set_id is null )) then
255:
256: hr_utility.set_location(l_procedure_name, 5);
257: dbg('Selection criteria is Null') ;
258:
259: if l_range_person_on = TRUE Then
260: hr_utility.set_location(l_procedure_name, 10);

Line 260: hr_utility.set_location(l_procedure_name, 10);

256: hr_utility.set_location(l_procedure_name, 5);
257: dbg('Selection criteria is Null') ;
258:
259: if l_range_person_on = TRUE Then
260: hr_utility.set_location(l_procedure_name, 10);
261: dbg('Range Person ID Functionality is enabled') ;
262: c_actions_sql :=
263: 'SELECT paa_arch.serial_number,
264: pai.effective_date,

Line 302: hr_utility.set_location(l_procedure_name, 20);

298: and palock.locked_action_id = paa_arch.assignment_action_id )
299: order by paa_arch.serial_number ';
300:
301: else
302: hr_utility.set_location(l_procedure_name, 20);
303: dbg('Range Person ID Functionality is NOT enabled') ;
304: c_actions_sql :=
305: 'SELECT paa_arch.serial_number,
306: pai.effective_date,

Line 348: hr_utility.set_location(l_procedure_name, 30);

344: /* when location is entered */
345:
346: if p_loc_id is not null then
347:
348: hr_utility.set_location(l_procedure_name, 30);
349: dbg('Selection criteria is Location') ;
350:
351: if l_range_person_on = TRUE Then
352: hr_utility.set_location(l_procedure_name, 35);

Line 352: hr_utility.set_location(l_procedure_name, 35);

348: hr_utility.set_location(l_procedure_name, 30);
349: dbg('Selection criteria is Location') ;
350:
351: if l_range_person_on = TRUE Then
352: hr_utility.set_location(l_procedure_name, 35);
353: c_actions_sql :=
354: 'SELECT paa_arch.serial_number,
355: pai.effective_date,
356: paa_arch.assignment_action_id,

Line 407: hr_utility.set_location(l_procedure_name, 40);

403: and palock.locked_action_id = paa_arch.assignment_action_id )
404: order by paa_arch.serial_number ';
405:
406: else
407: hr_utility.set_location(l_procedure_name, 40);
408: c_actions_sql :=
409: 'SELECT paa_arch.serial_number,
410: pai.effective_date,
411: paa_arch.assignment_action_id,

Line 466: hr_utility.set_location(l_procedure_name, 50);

462:
463: /* when org is entered */
464: if p_org_id is not null then
465:
466: hr_utility.set_location(l_procedure_name, 50);
467: dbg('Selection criteria is Organization') ;
468:
469: if l_range_person_on = TRUE Then
470: hr_utility.set_location(l_procedure_name, 60);

Line 470: hr_utility.set_location(l_procedure_name, 60);

466: hr_utility.set_location(l_procedure_name, 50);
467: dbg('Selection criteria is Organization') ;
468:
469: if l_range_person_on = TRUE Then
470: hr_utility.set_location(l_procedure_name, 60);
471: dbg('Range Person ID Functionality is enabled') ;
472: c_actions_sql :=
473: 'SELECT paa_arch.serial_number,
474: pai.effective_date,

Line 527: hr_utility.set_location(l_procedure_name, 70);

523: order by paa_arch.serial_number ';
524:
525: else
526:
527: hr_utility.set_location(l_procedure_name, 70);
528: c_actions_sql :=
529: 'SELECT paa_arch.serial_number,
530: pai.effective_date,
531: paa_arch.assignment_action_id,

Line 586: hr_utility.set_location(l_procedure_name, 80);

582:
583: /* when person or CURP is entered */
584: if (p_per_id is not null OR p_curp is not null ) then
585:
586: hr_utility.set_location(l_procedure_name, 80);
587: dbg('Selection criteria is either Employee Name or CURP') ;
588:
589: c_actions_sql := 'SELECT paa_arch.serial_number,
590: pai.effective_date,

Line 639: hr_utility.set_location(l_procedure_name, 90);

635:
636: /* when assignment set is entered */
637: if p_asg_set_id is not null then
638:
639: hr_utility.set_location(l_procedure_name, 90);
640: dbg('Selection criteria is Assignment set') ;
641:
642: if l_range_person_on = TRUE Then
643: hr_utility.set_location(l_procedure_name, 100);

Line 643: hr_utility.set_location(l_procedure_name, 100);

639: hr_utility.set_location(l_procedure_name, 90);
640: dbg('Selection criteria is Assignment set') ;
641:
642: if l_range_person_on = TRUE Then
643: hr_utility.set_location(l_procedure_name, 100);
644: dbg('Range Person ID Functionality is enabled') ;
645: c_actions_sql :=
646: 'SELECT paa_arch.serial_number,
647: pai.effective_date,

Line 698: hr_utility.set_location(l_procedure_name, 110);

694: and upper(hasa.include_or_exclude) = ''I'')
695: order by paa_arch.serial_number ';
696:
697: else
698: hr_utility.set_location(l_procedure_name, 110);
699: c_actions_sql :=
700: 'SELECT paa_arch.serial_number,
701: pai.effective_date,
702: paa_arch.assignment_action_id,

Line 752: hr_utility.set_location(l_procedure_name, 120);

748:
749: end if; /* End of when assignment set is entered */
750:
751:
752: hr_utility.set_location(l_procedure_name, 120);
753: dbg('Opening c_actions cursor');
754: dbg(c_actions_sql);
755:
756: l_serial_number := null ;

Line 771: hr_utility.set_location(l_procedure_name, 125);

767: dbg('In the c_actions%notfound in action cursor');
768: exit;
769: end if;
770:
771: hr_utility.set_location(l_procedure_name, 125);
772:
773: dbg( to_char(l_serial_number)) ;
774: dbg( to_char(l_eff_date,'DD-MON-YYYY') ) ;
775: dbg( to_char(l_person_id)) ;

Line 818: hr_utility.set_location(l_procedure_name, 300);

814:
815: end loop;
816: close c_actions;
817:
818: hr_utility.set_location(l_procedure_name, 300);
819: dbg('End of the action creation format37');
820:
821: end action_creation_format37;
822:

Line 851: -- hr_utility.trace_on(null,'ORACLE');

847:
848: g_debug_flag := 'Y' ;
849: -- g_concurrent_flag := 'Y' ;
850:
851: -- hr_utility.trace_on(null,'ORACLE');
852: hr_utility.set_location('procpyr',1);
853: dbg('In the action cursor');
854: Begin
855: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),

Line 852: hr_utility.set_location('procpyr',1);

848: g_debug_flag := 'Y' ;
849: -- g_concurrent_flag := 'Y' ;
850:
851: -- hr_utility.trace_on(null,'ORACLE');
852: hr_utility.set_location('procpyr',1);
853: dbg('In the action cursor');
854: Begin
855: select to_number(pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters)),
856: to_number(pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters)),