187: CLOSE check_pgm_exists;
188: End If;
189: hr_utility.set_location('Leaving :'|| g_package||l_proc, 60);
190: hr_utility.trace('Error ' ||sqlerrm(sqlcode));
191: l_err_msg := substr(p_target_business_group_id||':'||nvl(fnd_message.get,sqlerrm),1,1999) ;
192: rollback to create_tspc_plan_design;
193: ghr_wgi_pkg.create_ghr_errorlog
194: (p_program_name => l_proc,
195: p_log_text => l_err_msg,