DBA Data[Home] [Help]

APPS.HR_LOOKUPS_UTIL_PKG dependencies on HR_UTILITY

Line 61: hr_utility.set_location('Entering get_legisative_lookup_code', 10);

57: return varchar2 is
58: l_localized_lookup_code varchar2(30);
59: BEGIN
60: --
61: hr_utility.set_location('Entering get_legisative_lookup_code', 10);
62: --
63: select field_name into l_localized_lookup_code
64: from pay_legislative_field_info
65: where rule_type = 'LOCAL_LOOKUP'

Line 70: hr_utility.set_location('Get_leg_lk_code Returning: '||l_localized_lookup_code, 20);

66: and legislation_code = p_legislation_code
67: and validation_name = p_lookup_code
68: and validation_type = p_lookup_type;
69: --
70: hr_utility.set_location('Get_leg_lk_code Returning: '||l_localized_lookup_code, 20);
71: --
72: RETURN l_localized_lookup_code;
73:
74: EXCEPTION

Line 78: hr_utility.set_location('Get_leg_lk_code Returning: '||l_localized_lookup_code, 30);

74: EXCEPTION
75: --
76: WHEN OTHERS THEN
77: l_localized_lookup_code := p_lookup_code;
78: hr_utility.set_location('Get_leg_lk_code Returning: '||l_localized_lookup_code, 30);
79: return l_localized_lookup_code;
80: --
81: END get_legislative_lookup_code;
82: --

Line 105: hr_utility.set_location('Entering get_global_lookup_code', 10);

101: return varchar2 is
102: l_global_lookup_code varchar2(30);
103: BEGIN
104: --
105: hr_utility.set_location('Entering get_global_lookup_code', 10);
106: --
107: select validation_name into l_global_lookup_code
108: from pay_legislative_field_info
109: where rule_type = 'LOCAL_LOOKUP'

Line 114: hr_utility.set_location('Get_global_lk_code Returning: '||l_global_lookup_code, 20);

110: and legislation_code = p_legislation_code
111: and field_name = p_lookup_code
112: and validation_type = p_lookup_type;
113: --
114: hr_utility.set_location('Get_global_lk_code Returning: '||l_global_lookup_code, 20);
115: --
116: RETURN l_global_lookup_code;
117: --
118: EXCEPTION

Line 123: hr_utility.set_location('Get_global_lk_code Returning: '||l_global_lookup_code, 30);

119: --
120: WHEN OTHERS THEN
121: begin
122: l_global_lookup_code := p_lookup_code;
123: hr_utility.set_location('Get_global_lk_code Returning: '||l_global_lookup_code, 30);
124: RETURN l_global_lookup_code;
125: end;
126: --
127: END get_global_lookup_code;

Line 155: hr_utility.set_location('Entering swap_legislative_lookup_code', 10);

151: l_swapped_lookup_code varchar2(30);
152: l_global_lookup_code varchar2(30);
153: BEGIN
154: --
155: hr_utility.set_location('Entering swap_legislative_lookup_code', 10);
156: --
157: l_global_lookup_code :=
158: get_global_lookup_code(p_lookup_type,
159: p_lookup_code,

Line 162: hr_utility.set_location('Got global code: '||l_global_lookup_code, 20);

158: get_global_lookup_code(p_lookup_type,
159: p_lookup_code,
160: p_source_leg_code);
161: --
162: hr_utility.set_location('Got global code: '||l_global_lookup_code, 20);
163: --
164: l_swapped_lookup_code :=
165: get_legislative_lookup_code(p_lookup_type,
166: l_global_lookup_code,

Line 170: hr_utility.set_location('Swap_leg_lk_code Returning: '||l_swapped_lookup_code, 30);

166: l_global_lookup_code,
167: p_target_leg_code);
168: --
169: --
170: hr_utility.set_location('Swap_leg_lk_code Returning: '||l_swapped_lookup_code, 30);
171: --
172: RETURN l_swapped_lookup_code;
173:
174: END swap_legislative_lookup_code;