391: if (g_print_debug) then
392: fa_debug_pkg.Write_Debug_Log;
393: end if;
394: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
395: fa_srvr_msg.Write_Msg_Log(l_msg_count, l_msg_data);
396: end if;
397:
398: EXCEPTION
399:
397:
398: EXCEPTION
399:
400: WHEN ERROR_FOUND1 THEN
401: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
402: p_log_level_rec => p_log_level_rec);
403: if ((g_print_debug) and (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N')) then
404: fa_debug_pkg.Write_Debug_Log;
405: end if;
405: end if;
406: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count,
407: p_data => l_msg_data);
408: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') then
409: fa_srvr_msg.Write_Msg_Log(l_msg_count, l_msg_data);
410: else
411: log (l_calling_fn,'Others: '||l_msg_count||' - '||l_msg_data);
412: end if;
413: retcode := 2;
412: end if;
413: retcode := 2;
414:
415: WHEN OTHERS THEN
416: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn,
417: p_log_level_rec => p_log_level_rec);
418: if ((g_print_debug) and (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N')) then
419: fa_debug_pkg.Write_Debug_Log;
420: end if;
420: end if;
421: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count,
422: p_data => l_msg_data);
423: if (nvl(fa_asset_trace_pkg.g_use_utl_file, 'Y') = 'N') then
424: fa_srvr_msg.Write_Msg_Log(l_msg_count, l_msg_data);
425: else
426: log (l_calling_fn,'Others: '||l_msg_count||' - '||l_msg_data);
427: end if;
428: retcode := 2;
781: END IF;
782:
783: EXCEPTION
784: WHEN OTHERS THEN
785: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn,
786: p_log_level_rec => p_log_level_rec);
787: raise;
788:
789: END load_tbls;
930: END LOOP;
931:
932: EXCEPTION
933: WHEN OTHERS THEN
934: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn,
935: p_log_level_rec => p_log_level_rec);
936: raise;
937:
938: END load_setup_tbls;
1182: END LOOP;
1183:
1184: EXCEPTION
1185: WHEN OTHERS THEN
1186: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn,
1187: p_log_level_rec => p_log_level_rec);
1188: raise;
1189:
1190: END get_dist_info;
1325: END LOOP;
1326:
1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn,
1330: p_log_level_rec => p_log_level_rec);
1331: log(l_calling_fn, 'Exception, tbl: '||l_options_tbl(l_idx).l_tbl);
1332: raise;
1333:
1618: end if; --length(l_event_list)
1619:
1620: EXCEPTION
1621: WHEN OTHERS THEN
1622: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
1623: ,p_log_level_rec => p_log_level_rec);
1624: raise;
1625:
1626: END load_xla_info;
1674: end if;
1675:
1676: EXCEPTION
1677: WHEN OTHERS THEN
1678: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
1679: ,p_log_level_rec => g_log_level_rec);
1680: x_retcode := 2;
1681: raise;
1682: