DBA Data[Home] [Help]

APPS.PAY_NZ_SOE_PKG dependencies on HR_UTILITY

Line 81: hr_utility.set_location('pay_nz_soe_pkg.get_tax_code', 10) ;

77: and ppa.effective_date between iv1.effective_start_date and iv1.effective_end_date;
78:
79: begin
80:
81: hr_utility.set_location('pay_nz_soe_pkg.get_tax_code', 10) ;
82:
83: open c_tax_code (p_run_assignment_action_id) ;
84: fetch c_tax_code into l_tax_code,l_special_tax_code ;
85: if c_tax_code%notfound

Line 98: hr_utility.set_location('pay_nz_soe_pkg.get_tax_code', 20) ;

94: l_tax_code := 'STC' ;
95: end if;
96: close c_tax_code ;
97:
98: hr_utility.set_location('pay_nz_soe_pkg.get_tax_code', 20) ;
99:
100: return l_tax_code ;
101:
102: exception

Line 104: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

100: return l_tax_code ;
101:
102: exception
103: when others then
104: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
105: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_tax_code') ;
106: hr_utility.set_message_token('STEP','body') ;
107: hr_utility.raise_error ;
108:

Line 105: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_tax_code') ;

101:
102: exception
103: when others then
104: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
105: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_tax_code') ;
106: hr_utility.set_message_token('STEP','body') ;
107: hr_utility.raise_error ;
108:
109: end get_tax_code ;

Line 106: hr_utility.set_message_token('STEP','body') ;

102: exception
103: when others then
104: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
105: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_tax_code') ;
106: hr_utility.set_message_token('STEP','body') ;
107: hr_utility.raise_error ;
108:
109: end get_tax_code ;
110:

Line 107: hr_utility.raise_error ;

103: when others then
104: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
105: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_tax_code') ;
106: hr_utility.set_message_token('STEP','body') ;
107: hr_utility.raise_error ;
108:
109: end get_tax_code ;
110:
111: --

Line 137: hr_utility.set_location('pay_nz_soe_pkg.get_home_address', 10) ;

133: and pad.person_id = cp_person_id
134: and sysdate between nvl(pad.date_from, sysdate) and nvl(pad.date_to, sysdate);
135:
136: Begin
137: hr_utility.set_location('pay_nz_soe_pkg.get_home_address', 10) ;
138: open c_get_home_address(p_person_id);
139: fetch c_get_home_address into p_addr_line1,
140: p_addr_line2,
141: p_addr_line3,

Line 146: hr_utility.set_location('pay_nz_soe_pkg.get_home_address', 20) ;

142: p_town_city,
143: p_postal_code,
144: p_country_name;
145: close c_get_home_address;
146: hr_utility.set_location('pay_nz_soe_pkg.get_home_address', 20) ;
147:
148: Exception
149: when others then
150: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

Line 150: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

146: hr_utility.set_location('pay_nz_soe_pkg.get_home_address', 20) ;
147:
148: Exception
149: when others then
150: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
151: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_home_address') ;
152: hr_utility.set_message_token('STEP','body') ;
153: hr_utility.raise_error ;
154:

Line 151: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_home_address') ;

147:
148: Exception
149: when others then
150: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
151: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_home_address') ;
152: hr_utility.set_message_token('STEP','body') ;
153: hr_utility.raise_error ;
154:
155: End;

Line 152: hr_utility.set_message_token('STEP','body') ;

148: Exception
149: when others then
150: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
151: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_home_address') ;
152: hr_utility.set_message_token('STEP','body') ;
153: hr_utility.raise_error ;
154:
155: End;
156:

Line 153: hr_utility.raise_error ;

149: when others then
150: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
151: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_home_address') ;
152: hr_utility.set_message_token('STEP','body') ;
153: hr_utility.raise_error ;
154:
155: End;
156:
157: --

Line 183: hr_utility.set_location('pay_nz_soe_pkg.get_work_address', 10) ;

179: and ftt.language = USERENV('LANG') -- Bug 3257888
180: and hrl.location_id = cp_location_id;
181:
182: Begin
183: hr_utility.set_location('pay_nz_soe_pkg.get_work_address', 10) ;
184: open c_get_work_address(p_location_id);
185: fetch c_get_work_address into p_addr_line1,
186: p_addr_line2,
187: p_addr_line3,

Line 192: hr_utility.set_location('pay_nz_soe_pkg.get_work_address', 20) ;

188: p_town_city,
189: p_postal_code,
190: p_country_name;
191: close c_get_work_address;
192: hr_utility.set_location('pay_nz_soe_pkg.get_work_address', 20) ;
193:
194: Exception
195: when others then
196: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

Line 196: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;

192: hr_utility.set_location('pay_nz_soe_pkg.get_work_address', 20) ;
193:
194: Exception
195: when others then
196: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
197: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_work_address') ;
198: hr_utility.set_message_token('STEP','body') ;
199: hr_utility.raise_error ;
200:

Line 197: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_work_address') ;

193:
194: Exception
195: when others then
196: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
197: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_work_address') ;
198: hr_utility.set_message_token('STEP','body') ;
199: hr_utility.raise_error ;
200:
201: End;

Line 198: hr_utility.set_message_token('STEP','body') ;

194: Exception
195: when others then
196: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
197: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_work_address') ;
198: hr_utility.set_message_token('STEP','body') ;
199: hr_utility.raise_error ;
200:
201: End;
202:

Line 199: hr_utility.raise_error ;

195: when others then
196: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL') ;
197: hr_utility.set_message_token('PROCEDURE', 'pay_nz_soe_pkg.get_work_address') ;
198: hr_utility.set_message_token('STEP','body') ;
199: hr_utility.raise_error ;
200:
201: End;
202:
203: --