169: --hr_utility.trace_off;
170:
171: EXCEPTION
172: when others then
173: l_error:=fnd_message.get;
174: hr_utility.set_location ('exception is'||l_error , 300);
175:
176: end approve_all_managers;
177:
234: begin
235:
236: -- fetch highest approver
237:
238: fnd_message.set_name('BEN','BEN_92969_CWB_LAST_APPR');
239: l_last_appr:=fnd_message.get;
240:
241: -- First check approval status of manager, if it is null or rejected
242: -- then supervisor is next approver
235:
236: -- fetch highest approver
237:
238: fnd_message.set_name('BEN','BEN_92969_CWB_LAST_APPR');
239: l_last_appr:=fnd_message.get;
240:
241: -- First check approval status of manager, if it is null or rejected
242: -- then supervisor is next approver
243: