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

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: pynoabsa.pkb 120.0.12000000.1 2007/05/22 05:24:58 rajesrin noship $ */
3: TYPE lock_rec IS RECORD (
4: archive_assact_id NUMBER);
5: TYPE lock_table IS TABLE OF lock_rec INDEX BY BINARY_INTEGER;
6: g_debug boolean := hr_utility.debug_enabled;
7: g_lock_table lock_table;
8: g_package VARCHAR2(33) := ' PAY_NO_ARCHIVE_ABSENCE.';
9: g_err_num NUMBER;
10: g_errm VARCHAR2(150);

Line 24: hr_utility.set_location(' Entering Function GET_PARAMETER',10);

20: l_proc VARCHAR2(40):= g_package||' get parameter ';
21: BEGIN
22:
23: IF g_debug THEN
24: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
25: END IF;
26: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
27: --
28: IF l_start_pos = 0 THEN

Line 49: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);

45: END IF;
46: END IF;
47: --
48: IF g_debug THEN
49: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
50: END IF;
51: RETURN l_parameter;
52: END;
53: /* GET ALL PARAMETERS */

Line 90: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

86: ,p_business_group_id;
87: CLOSE csr_parameter_info;
88: --
89: IF g_debug THEN
90: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
91: END IF;
92: END GET_ALL_PARAMETERS;
93:
94: /*Start of sum_no_absence*/

Line 237: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);

233: AND ppa.business_group_id = ppf.business_group_id
234: ORDER BY ppf.person_id';
235:
236: IF g_debug THEN
237: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
238: END IF;
239: EXCEPTION
240: WHEN OTHERS THEN
241: -- Return cursor that selects no rows

Line 254: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);

250: IS
251: BEGIN
252: -- fnd_file.put_line (fnd_file.LOG, 'Entering Assignment Action Code' );
253: IF g_debug THEN
254: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
255: END IF;
256: IF g_debug THEN
257: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
258: END IF;

Line 257: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);

253: IF g_debug THEN
254: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
255: END IF;
256: IF g_debug THEN
257: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
258: END IF;
259: -- fnd_file.put_line (fnd_file.LOG, 'Exiting Assignment Action Code' );
260: END ASSIGNMENT_ACTION_CODE;
261: /* INITIALIZATION CODE */

Line 267: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);

263: IS
264: BEGIN
265: fnd_file.put_line (fnd_file.LOG, 'Entering Initialization Code' );
266: IF g_debug THEN
267: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
268: END IF;
269: IF g_debug THEN
270: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
271: END IF;

Line 270: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

266: IF g_debug THEN
267: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
268: END IF;
269: IF g_debug THEN
270: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
271: END IF;
272: fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
273: EXCEPTION WHEN OTHERS THEN
274: g_err_num := SQLCODE;

Line 276: hr_utility.set_location('ORA_ERR: ' || g_err_num ||

272: fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
273: EXCEPTION WHEN OTHERS THEN
274: g_err_num := SQLCODE;
275: IF g_debug THEN
276: hr_utility.set_location('ORA_ERR: ' || g_err_num ||
277: 'In INITIALIZATION_CODE',180);
278: END IF;
279: fnd_file.put_line (fnd_file.LOG, 'Error in Initialization Code' );
280: END INITIALIZATION_CODE;

Line 405: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);

401:
402: BEGIN
403:
404:
405: hr_utility.set_location(' Entering Procedure RANGE_CODE',10);
406:
407:
408:
409:

Line 447: hr_utility.set_location('****************Inside Archive ',10);

443: WHERE action_information_category = 'EMEA REPORT INFORMATION'
444: AND action_information1= 'PYNOABSA'
445: AND action_context_id= p_payroll_action_id;
446:
447: hr_utility.set_location('****************Inside Archive ',10);
448:
449: IF l_count < 1 then
450:
451: absmale(0).initialized:='N';

Line 497: hr_utility.set_location('*Inside Else Archive**',20);

493: sum_no_absence(csr_abs.sex,l_absence_days,l_quater,csr_abs.certificate_type,1,csr_abs.absence_category);
494:
495:
496: else
497: hr_utility.set_location('*****Inside Else Archive******',20);
498: /* Modified for bug 5388892*/
499: If l_start_date > csr_abs.date_start then
500: l_qtr_start_date := l_start_date;
501: Else

Line 517: hr_utility.set_location('***Inside Else Archive'||l_quater_cnt,20);

513:
514: l_qtr_end_date :=trunc(csr_abs.date_end,'Q')-1;
515: --l_linked_quater := 'Q'||to_char(l_qtr_start_date,'Q');
516:
517: hr_utility.set_location('*****Inside Else Archive**'||l_quater_cnt,20);
518:
519: For qtrs in 0..l_quater_cnt
520: Loop
521:

Line 533: hr_utility.set_location(' ****1111Absence Days : '||l_absence_days||' : '||l_full_time_percentage,5);

529: elsif qtrs <> 0 then
530: l_qtr_end_date :=trunc(add_months(l_qtr_start_date,3),'Q')-1;
531: end if;
532: l_hr_work_schedule:=hr_loc_work_schedule.calc_sch_based_dur(csr_abs.assignment_id,'D','Y',l_qtr_start_date,l_qtr_end_date,'00','23',l_absence_days);
533: hr_utility.set_location(' ****1111Absence Days : '||l_absence_days||' : '||l_full_time_percentage,5);
534: l_absence_days := l_absence_days * l_full_time_percentage/100;
535:
536: /*Added for Bugs 5409100,5409124*/
537: if csr_abs.absence_category in ('PTS') then

Line 565: hr_utility.set_location('Table Populated',50);

561: End Loop;
562:
563: END IF;
564:
565: hr_utility.set_location('***Table Populated***',50);
566:
567: l_quater_start := trunc(l_start_date,'Q');
568: l_quater_end := trunc(add_months(l_quater_start,3),'Q')-1;
569:

Line 593: hr_utility.trace('Entered l_quater_end ******* '||l_quater_end);

589: l_hr_work_schedule:=hr_loc_work_schedule.calc_sch_based_dur(l_pos_assignment_id,'D','Y',l_quater_start,l_quater_end,'00','23',l_possible_working_days);
590: l_total_possible_working_days := nvl(l_total_possible_working_days,0) + (nvl(l_possible_working_days,0)*l_full_time_percentage/100);
591:
592: End loop;
593: hr_utility.trace('Entered l_quater_end ******* '||l_quater_end);
594:
595: If absmale(itr).initialized = 'Y' then
596: pay_action_information_api.create_action_information (
597: p_action_information_id => l_action_info_id

Line 638: hr_utility.set_location('Done with Male '||absmale.LAST,50);

634: /* Added for bug 5381141*/
635: l_total_possible_working_days := 0;
636: End loop;
637:
638: hr_utility.set_location('***Done with Male*** '||absmale.LAST,50);
639:
640: l_quater_start := trunc(l_start_date,'Q');
641: l_quater_end := trunc(add_months(l_quater_start,3),'Q')-1;
642: l_total_possible_working_days:=0;

Line 709: hr_utility.set_location('Done with Female '||absfemale.LAST,50);

705: /* Added for bug 5381141*/
706: l_total_possible_working_days := 0;
707: End loop;
708:
709: hr_utility.set_location('***Done with Female*** '||absfemale.LAST,50);
710:
711: END IF;
712: fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
713: EXCEPTION WHEN OTHERS THEN

Line 716: hr_utility.set_location('ORA_ERR: ' || g_err_num ||

712: fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
713: EXCEPTION WHEN OTHERS THEN
714: g_err_num := SQLCODE;
715: IF g_debug THEN
716: hr_utility.set_location('ORA_ERR: ' || g_err_num ||
717: 'In INITIALIZATION_CODE',180);
718: END IF;
719: fnd_file.put_line (fnd_file.LOG, 'Error in Initialization Code' );
720: END DEINITIALIZE_CODE;

Line 729: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);

725: IS
726: BEGIN
727: fnd_file.put_line (fnd_file.LOG, 'entering archive code' );
728: IF g_debug THEN
729: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
730: END IF;
731: IF g_debug THEN
732: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
733: END IF;

Line 732: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);

728: IF g_debug THEN
729: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',80);
730: END IF;
731: IF g_debug THEN
732: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
733: END IF;
734: fnd_file.put_line (fnd_file.LOG, 'Exiting archive code' );
735: END ARCHIVE_CODE;
736: END PAY_NO_ARCHIVE_ABSENCE;