229: WHEN le_fatal_error THEN
230:
231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Fatal Exception remove all element from PLSQL table');
233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');
234: END IF;
235: --Remove all the elements from the PLSQL table
236: reset_online_interface;
237: --If there is a no token message to log
292: END IF;
293: WHEN OTHERS THEN
294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'When Other Exception remove all element from PLSQL table');
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');
297: END IF;
298: --Remove all the elements from the PLSQL table
299: reset_online_interface;
300: --Add the standard unexpected error message
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_xla_tab_pkg.run', 'reset online interface and add standard unexpected error message');
297: END IF;
298: --Remove all the elements from the PLSQL table
299: reset_online_interface;
300: --Add the standard unexpected error message
301: fnd_msg_pub.Add_Exc_Msg
302: ( p_pkg_name => C_PACKAGE_NAME
303: ,p_procedure_name => 'run'
304: );
428: ELSE
429: x_return_status := C_RET_STS_UNEXP_ERROR;
430: END IF;
431: WHEN OTHERS THEN
432: --Add the standard unexpected error message
433: fnd_msg_pub.Add_Exc_Msg
434: ( p_pkg_name => C_PACKAGE_NAME
435: ,p_procedure_name => 'reset_online_interface'
436: );
795: END IF;
796: WHEN OTHERS THEN
797: --Remove all the elements from the PLSQL table
798: g_array_xla_tab .DELETE;
799: --Add the standard unexpected error message
800: fnd_msg_pub.Add_Exc_Msg
801: ( p_pkg_name => C_PACKAGE_NAME
802: ,p_procedure_name => 'write_online_tab '
803: );
1099: END IF;
1100: WHEN OTHERS THEN
1101: --Remove all the elements from the PLSQL table
1102: g_array_xla_tab .DELETE;
1103: --Add the standard unexpected error message
1104: fnd_msg_pub.Add_Exc_Msg
1105: ( p_pkg_name => C_PACKAGE_NAME
1106: ,p_procedure_name => 'read_online_tab '
1107: );