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.

[Home] [Help]

APPS.HR_AUBAL dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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