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

Line 961: hr_utility.trace('In: ' || l_fn_name) ;

957: l_action_eff_date date;
958:
959: begin
960:
961: hr_utility.trace('In: ' || l_fn_name) ;
962: hr_utility.trace(' p_balance_type_id:' || to_char(p_balance_type_id)) ;
963: hr_utility.trace(' p_effective_date:' || to_char(p_effective_date,'dd Mon yyyy')) ;
964: hr_utility.trace(' p_assignment_id:' || to_char(p_assignment_id)) ;
965:

Line 962: hr_utility.trace(' p_balance_type_id:' || to_char(p_balance_type_id)) ;

958:
959: begin
960:
961: hr_utility.trace('In: ' || l_fn_name) ;
962: hr_utility.trace(' p_balance_type_id:' || to_char(p_balance_type_id)) ;
963: hr_utility.trace(' p_effective_date:' || to_char(p_effective_date,'dd Mon yyyy')) ;
964: hr_utility.trace(' p_assignment_id:' || to_char(p_assignment_id)) ;
965:
966: hr_utility.set_location(l_fn_name, 10) ;

Line 963: hr_utility.trace(' p_effective_date:' || to_char(p_effective_date,'dd Mon yyyy')) ;

959: begin
960:
961: hr_utility.trace('In: ' || l_fn_name) ;
962: hr_utility.trace(' p_balance_type_id:' || to_char(p_balance_type_id)) ;
963: hr_utility.trace(' p_effective_date:' || to_char(p_effective_date,'dd Mon yyyy')) ;
964: hr_utility.trace(' p_assignment_id:' || to_char(p_assignment_id)) ;
965:
966: hr_utility.set_location(l_fn_name, 10) ;
967: l_assignment_action_id := get_latest_action_id

Line 964: hr_utility.trace(' p_assignment_id:' || to_char(p_assignment_id)) ;

960:
961: hr_utility.trace('In: ' || l_fn_name) ;
962: hr_utility.trace(' p_balance_type_id:' || to_char(p_balance_type_id)) ;
963: hr_utility.trace(' p_effective_date:' || to_char(p_effective_date,'dd Mon yyyy')) ;
964: hr_utility.trace(' p_assignment_id:' || to_char(p_assignment_id)) ;
965:
966: hr_utility.set_location(l_fn_name, 10) ;
967: l_assignment_action_id := get_latest_action_id
968: (p_assignment_id

Line 966: hr_utility.set_location(l_fn_name, 10) ;

962: hr_utility.trace(' p_balance_type_id:' || to_char(p_balance_type_id)) ;
963: hr_utility.trace(' p_effective_date:' || to_char(p_effective_date,'dd Mon yyyy')) ;
964: hr_utility.trace(' p_assignment_id:' || to_char(p_assignment_id)) ;
965:
966: hr_utility.set_location(l_fn_name, 10) ;
967: l_assignment_action_id := get_latest_action_id
968: (p_assignment_id
969: ,p_effective_date);
970: hr_utility.trace(' l_assignment_action_id:' || to_char(l_assignment_action_id)) ;

Line 970: hr_utility.trace(' l_assignment_action_id:' || to_char(l_assignment_action_id)) ;

966: hr_utility.set_location(l_fn_name, 10) ;
967: l_assignment_action_id := get_latest_action_id
968: (p_assignment_id
969: ,p_effective_date);
970: hr_utility.trace(' l_assignment_action_id:' || to_char(l_assignment_action_id)) ;
971:
972: if l_assignment_action_id is null
973: then
974: hr_utility.set_location(l_fn_name, 20) ;

Line 974: hr_utility.set_location(l_fn_name, 20) ;

970: hr_utility.trace(' l_assignment_action_id:' || to_char(l_assignment_action_id)) ;
971:
972: if l_assignment_action_id is null
973: then
974: hr_utility.set_location(l_fn_name, 20) ;
975: l_balance := 0;
976: else
977: hr_utility.set_location(l_fn_name, 30) ;
978: -- start expiry chk now

Line 977: hr_utility.set_location(l_fn_name, 30) ;

973: then
974: hr_utility.set_location(l_fn_name, 20) ;
975: l_balance := 0;
976: else
977: hr_utility.set_location(l_fn_name, 30) ;
978: -- start expiry chk now
979: l_action_eff_date := get_latest_date(l_assignment_action_id);
980: hr_utility.trace(' l_action_eff_date:' || to_char(l_action_eff_date, 'dd Mon yyyy')) ;
981:

Line 980: hr_utility.trace(' l_action_eff_date:' || to_char(l_action_eff_date, 'dd Mon yyyy')) ;

976: else
977: hr_utility.set_location(l_fn_name, 30) ;
978: -- start expiry chk now
979: l_action_eff_date := get_latest_date(l_assignment_action_id);
980: hr_utility.trace(' l_action_eff_date:' || to_char(l_action_eff_date, 'dd Mon yyyy')) ;
981:
982: -- is effective date (sess) later than the expiry of the FBT year of the
983: -- effective date.
984:

Line 987: hr_utility.set_location(l_fn_name, 40) ;

983: -- effective date.
984:
985: if p_effective_date >= get_expired_year_date(l_action_eff_date, g_fbt_year_start)
986: then
987: hr_utility.set_location(l_fn_name, 40) ;
988: l_balance := 0;
989: else
990: hr_utility.set_location(l_fn_name, 50) ;
991: l_balance := calc_asg_fbt_ytd

Line 990: hr_utility.set_location(l_fn_name, 50) ;

986: then
987: hr_utility.set_location(l_fn_name, 40) ;
988: l_balance := 0;
989: else
990: hr_utility.set_location(l_fn_name, 50) ;
991: l_balance := calc_asg_fbt_ytd
992: (p_assignment_action_id => l_assignment_action_id
993: ,p_balance_type_id => p_balance_type_id
994: ,p_effective_date => p_effective_date

Line 999: hr_utility.trace(l_fn_name || ' return:' || to_char(l_balance)) ;

995: ,p_assignment_id => p_assignment_id);
996: end if;
997: end if;
998:
999: hr_utility.trace(l_fn_name || ' return:' || to_char(l_balance)) ;
1000: hr_utility.trace('Out: ' || l_fn_name) ;
1001: return l_balance;
1002:
1003: end calc_asg_fbt_ytd_date;

Line 1000: hr_utility.trace('Out: ' || l_fn_name) ;

996: end if;
997: end if;
998:
999: hr_utility.trace(l_fn_name || ' return:' || to_char(l_balance)) ;
1000: hr_utility.trace('Out: ' || l_fn_name) ;
1001: return l_balance;
1002:
1003: end calc_asg_fbt_ytd_date;
1004: --