103: END IF;
104:
105: Exception
106: When Others Then
107: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
108: fnd_message.set_token('ERRNO' ,SQLCODE);
109: fnd_message.set_token('REASON' ,SQLERRM);
110: fnd_message.set_token('ROUTINE' , l_proc);
111: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
104:
105: Exception
106: When Others Then
107: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
108: fnd_message.set_token('ERRNO' ,SQLCODE);
109: fnd_message.set_token('REASON' ,SQLERRM);
110: fnd_message.set_token('ROUTINE' , l_proc);
111: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
112: p_module => g_pkg || l_proc || ' proc_error',
105: Exception
106: When Others Then
107: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
108: fnd_message.set_token('ERRNO' ,SQLCODE);
109: fnd_message.set_token('REASON' ,SQLERRM);
110: fnd_message.set_token('ROUTINE' , l_proc);
111: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
112: p_module => g_pkg || l_proc || ' proc_error',
113: p_msg => fnd_message.get,
106: When Others Then
107: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
108: fnd_message.set_token('ERRNO' ,SQLCODE);
109: fnd_message.set_token('REASON' ,SQLERRM);
110: fnd_message.set_token('ROUTINE' , l_proc);
111: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
112: p_module => g_pkg || l_proc || ' proc_error',
113: p_msg => fnd_message.get,
114: p_force_log => TRUE);
109: fnd_message.set_token('REASON' ,SQLERRM);
110: fnd_message.set_token('ROUTINE' , l_proc);
111: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
112: p_module => g_pkg || l_proc || ' proc_error',
113: p_msg => fnd_message.get,
114: p_force_log => TRUE);
115:
116: RAISE;
117: