30: G_Recapture_Reserve_Flag fa_retirements.recapture_reserve_flag%Type;
31: G_Limit_Proceeds_Flag fa_retirements.limit_proceeds_flag%Type;
32: G_Terminal_Gain_Loss fa_retirements.terminal_gain_loss%Type;
33: /* Bug 8483118(R12) and 8206076(11i) - End */
34: G_Last_Update_Login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
35: G_Precision NUMBER;
36: G_Ext_Precision NUMBER;
37: G_Min_Acct_Unit NUMBER;
38: G_Today_Datetime DATE := SYSDATE;
44: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
45: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;
46: G_Assigned_To fa_mass_Ext_retirements.Assigned_To%TYPE;
47: G_Recursion_Level VARCHAR2(1);
48: G_Created_By NUMBER(15) := FND_GLOBAL.USER_ID;
49: G_Creation_Date DATE := SYSDATE;
50: G_Varchar2_Dummy VARCHAR2(80);
51: G_Number_Dummy NUMBER(15);
52: G_Date_Dummy Date;
1292: SET review_status = 'POSTED',
1293: -- bugfix 2442439 retirement_id = lv_ret_id
1294: retirement_id = l_asset_retire_rec.retirement_id,
1295: last_update_date = sysdate,
1296: last_updated_by = fnd_global.user_id,
1297: last_update_login = fnd_global.login_id
1298: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1299:
1300: Commit;
1293: -- bugfix 2442439 retirement_id = lv_ret_id
1294: retirement_id = l_asset_retire_rec.retirement_id,
1295: last_update_date = sysdate,
1296: last_updated_by = fnd_global.user_id,
1297: last_update_login = fnd_global.login_id
1298: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1299:
1300: Commit;
1301:
1319:
1320: UPDATE fa_mass_Ext_retirements
1321: SET review_status = 'ERROR',
1322: last_update_date = sysdate,
1323: last_updated_by = fnd_global.user_id,
1324: last_update_login = fnd_global.login_id
1325: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1326:
1327: -- non-fatal
1320: UPDATE fa_mass_Ext_retirements
1321: SET review_status = 'ERROR',
1322: last_update_date = sysdate,
1323: last_updated_by = fnd_global.user_id,
1324: last_update_login = fnd_global.login_id
1325: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1326:
1327: -- non-fatal
1328: write_message(
1351:
1352: UPDATE fa_mass_Ext_retirements
1353: SET review_status = 'ERROR',
1354: last_update_date = sysdate,
1355: last_updated_by = fnd_global.user_id,
1356: last_update_login = fnd_global.login_id
1357: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1358:
1359:
1352: UPDATE fa_mass_Ext_retirements
1353: SET review_status = 'ERROR',
1354: last_update_date = sysdate,
1355: last_updated_by = fnd_global.user_id,
1356: last_update_login = fnd_global.login_id
1357: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1358:
1359:
1360: if lv_message = '' then
1394:
1395: UPDATE fa_mass_Ext_retirements
1396: SET review_status = 'ERROR',
1397: last_update_date = sysdate,
1398: last_updated_by = fnd_global.user_id,
1399: last_update_login = fnd_global.login_id
1400: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1401:
1402: write_message(
1395: UPDATE fa_mass_Ext_retirements
1396: SET review_status = 'ERROR',
1397: last_update_date = sysdate,
1398: last_updated_by = fnd_global.user_id,
1399: last_update_login = fnd_global.login_id
1400: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1401:
1402: write_message(
1403: p_asset_number => g_asset_number,
1424:
1425: UPDATE fa_mass_Ext_retirements
1426: SET review_status = 'ERROR',
1427: last_update_date = sysdate,
1428: last_updated_by = fnd_global.user_id,
1429: last_update_login = fnd_global.login_id
1430: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1431:
1432: write_message(
1425: UPDATE fa_mass_Ext_retirements
1426: SET review_status = 'ERROR',
1427: last_update_date = sysdate,
1428: last_updated_by = fnd_global.user_id,
1429: last_update_login = fnd_global.login_id
1430: WHERE mass_external_retire_id = G_Mass_External_Retire_Id;
1431:
1432: write_message(
1433: p_asset_number => g_asset_number,
1490:
1491: UPDATE fa_mass_Ext_retirements
1492: SET review_status = 'ERROR',
1493: last_update_date = sysdate,
1494: last_updated_by = fnd_global.user_id,
1495: last_update_login = fnd_global.login_id
1496: WHERE batch_name = nvl(px_batch_name,batch_name)
1497: AND book_type_code = p_book_type_code;
1498:
1491: UPDATE fa_mass_Ext_retirements
1492: SET review_status = 'ERROR',
1493: last_update_date = sysdate,
1494: last_updated_by = fnd_global.user_id,
1495: last_update_login = fnd_global.login_id
1496: WHERE batch_name = nvl(px_batch_name,batch_name)
1497: AND book_type_code = p_book_type_code;
1498:
1499: write_message(