[Home] [Help]
402: close c_mass_change_info;
403:
404:
405: if(l_masschg_status <> 'RUNNING') then
406: fa_srvr_msg.add_message
407: (calling_fn => l_calling_fn,
408: name => 'FA_MASSCHG_WRONG_STATUS'
409: ,p_log_level_rec => g_log_level_rec); -- NOTE! not placing tokens yet
410: raise masschg_err;
464: end if;
465:
466: -- initial book control validation
467: if (fa_cache_pkg.fazcbc_record.allow_mass_changes <> 'YES') then
468: fa_srvr_msg.add_message
469: (calling_fn => l_calling_fn,
470: name => 'FA_MASSCHG_WRONG_STATUS'
471: ,p_log_level_rec => g_log_level_rec);
472: raise masschg_err;
470: name => 'FA_MASSCHG_WRONG_STATUS'
471: ,p_log_level_rec => g_log_level_rec);
472: raise masschg_err;
473: elsif (fa_cache_pkg.fazcbc_record.date_ineffective is not null) then
474: fa_srvr_msg.add_message
475: (calling_fn => l_calling_fn,
476: name => 'FA_MASSCHG_WRONG_STATUS'
477: ,p_log_level_rec => g_log_level_rec);
478: raise masschg_err;
496:
497: for l_loop_count in 1..l_asset_id.count loop
498:
499: -- reset the message level to prevent bogus errors
500: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
501: l_mesg_name := null;
502:
503: fa_srvr_msg.add_message(
504: calling_fn => NULL,
499: -- reset the message level to prevent bogus errors
500: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
501: l_mesg_name := null;
502:
503: fa_srvr_msg.add_message(
504: calling_fn => NULL,
505: name => 'FA_SHARED_ASSET_NUMBER',
506: token1 => 'NUMBER',
507: value1 => l_asset_number(l_loop_count));
539: x_failure_count := x_failure_count + 1;
540:
541: write_message(l_asset_number(l_loop_count),
542: null);
543: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
544: ,p_log_level_rec => g_log_level_rec);
545:
546: -- Commented for bugfix 4672237
547: -- if (g_log_level_rec.statement_level) then
575:
576: -- clear the debug stack for each asset
577: FA_DEBUG_PKG.Initialize;
578: -- reset the message level to prevent bogus errors
579: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
580:
581: l_mesg_name := null;
582:
583: BEGIN
942:
943: write_message(l_asset_number(l_loop_count),
944: null);
945:
946: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
947: ,p_log_level_rec => g_log_level_rec);
948:
949: -- Commented for bugfix 4672237
950: -- if (g_log_level_rec.statement_level) then
969: x_return_status := 0;
970:
971: when masschg_err then
972: ROLLBACK;
973: fa_srvr_msg.add_message(calling_fn => l_calling_fn
974: ,p_log_level_rec => g_log_level_rec);
975:
976: -- Commented for bugfix 4672237
977: -- if (g_log_level_rec.statement_level) then
980: x_return_status := 2;
981:
982: when others then
983: ROLLBACK;
984: fa_srvr_msg.add_message(calling_fn => l_calling_fn
985: ,p_log_level_rec => g_log_level_rec);
986:
987: -- Commented for bugfix 4672237
988: -- if (g_log_level_rec.statement_level) then
1023: FND_FILE.put(FND_FILE.output,l_string);
1024: FND_FILE.new_line(FND_FILE.output,1);
1025:
1026: -- now process the messages for the log file
1027: fa_srvr_msg.add_message
1028: (calling_fn => l_calling_fn,
1029: name => l_message
1030: ,p_log_level_rec => p_log_level_rec);
1031: