eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_ADDITIONS_PKG dependencies on FA_ADDITIONS_PKG

Line 1: PACKAGE BODY FA_ADDITIONS_PKG as

1: PACKAGE BODY FA_ADDITIONS_PKG as
2: /* $Header: faxiadb.pls 120.6 2005/07/25 10:02:26 yyoon ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Asset_Id IN OUT NOCOPY NUMBER,

Line 325: CALLING_FN => 'fa_additions_pkg.insert_row',

321: h_error_message := SQLERRM;
322:
323: if instr (h_error_message, 'FA_ADDITIONS_B_U2') <> 0 then
324: FA_SRVR_MSG.add_message(
325: CALLING_FN => 'fa_additions_pkg.insert_row',
326: NAME => 'FA_ADD_ASSET_NUMBER_EXISTS',
327: TOKEN1 => 'ASSET_NUMBER',
328: VALUE1 => X_Asset_Number
329: ,p_log_level_rec => p_log_level_rec);

Line 331: CALLING_FN => 'fa_additions_pkg.insert_row'

327: TOKEN1 => 'ASSET_NUMBER',
328: VALUE1 => X_Asset_Number
329: ,p_log_level_rec => p_log_level_rec);
330: FA_SRVR_MSG.ADD_SQL_ERROR (
331: CALLING_FN => 'fa_additions_pkg.insert_row'
332: ,p_log_level_rec => p_log_level_rec);
333: raise;
334:
335: elsif instr (h_error_message, 'FA_ADDITIONS_B_U3') <> 0 then

Line 337: CALLING_FN => 'fa_additions_pkg.insert_row',

333: raise;
334:
335: elsif instr (h_error_message, 'FA_ADDITIONS_B_U3') <> 0 then
336: FA_SRVR_MSG.add_message(
337: CALLING_FN => 'fa_additions_pkg.insert_row',
338: NAME => 'FA_ADD_TAG_NUMBER_EXISTS',
339: TOKEN1 => 'TAG_NUMBER',
340: VALUE1 => X_Tag_Number
341: ,p_log_level_rec => p_log_level_rec);

Line 343: CALLING_FN => 'fa_additions_pkg.insert_row'

339: TOKEN1 => 'TAG_NUMBER',
340: VALUE1 => X_Tag_Number
341: ,p_log_level_rec => p_log_level_rec);
342: FA_SRVR_MSG.ADD_SQL_ERROR (
343: CALLING_FN => 'fa_additions_pkg.insert_row'
344: ,p_log_level_rec => p_log_level_rec);
345: raise;
346:
347: else

Line 349: CALLING_FN => 'fa_additions_pkg.insert_row'

345: raise;
346:
347: else
348: FA_SRVR_MSG.ADD_SQL_ERROR (
349: CALLING_FN => 'fa_additions_pkg.insert_row'
350: ,p_log_level_rec => p_log_level_rec);
351: raise;
352:
353: end if;

Line 357: CALLING_FN => 'fa_additions_pkg.insert_row'

353: end if;
354:
355: when others then
356: FA_SRVR_MSG.ADD_SQL_ERROR (
357: CALLING_FN => 'fa_additions_pkg.insert_row'
358: ,p_log_level_rec => p_log_level_rec);
359: raise;
360:
361: END Insert_Row;

Line 1072: CALLING_FN => 'FA_ADDITIONS_PKG.Update_Row'

1068:
1069: exception
1070: when others then
1071: FA_SRVR_MSG.Add_SQL_Error(
1072: CALLING_FN => 'FA_ADDITIONS_PKG.Update_Row'
1073: ,p_log_level_rec => p_log_level_rec);
1074: X_Return_Status := FALSE;
1075: raise;
1076: END Update_Row;

Line 1109: CALLING_FN => 'fa_additions_pkg.delete_row'

1105:
1106: exception
1107: when others then
1108: FA_SRVR_MSG.ADD_SQL_ERROR (
1109: CALLING_FN => 'fa_additions_pkg.delete_row'
1110: ,p_log_level_rec => p_log_level_rec);
1111: raise;
1112:
1113: END Delete_Row;

Line 1133: CALLING_FN => 'fa_additions_pkg.update_units'

1129:
1130: exception
1131: when others then
1132: FA_SRVR_MSG.ADD_SQL_ERROR (
1133: CALLING_FN => 'fa_additions_pkg.update_units'
1134: ,p_log_level_rec => p_log_level_rec);
1135: raise;
1136:
1137: END Update_Units;

Line 1321: fa_additions_pkg.Update_Row(

1317: db_last_updated_by, db_last_update_date,
1318: X_CUSTOM_MODE
1319: )) then
1320:
1321: fa_additions_pkg.Update_Row(
1322: X_Asset_Id => h_asset_id,
1323: X_Asset_Number => h_asset_number,
1324: X_Asset_Key_Ccid => X_Asset_Key_Ccid,
1325: X_Current_Units => X_Current_Units,

Line 1403: X_Calling_Fn => 'fa_additions_pkg.load_row',

1399: X_Last_Update_Date => sysdate,
1400: X_Last_Updated_By => user_id,
1401: X_Last_Update_Login => 0,
1402: X_Return_Status => return_status,
1403: X_Calling_Fn => 'fa_additions_pkg.load_row',
1404: p_log_level_rec => p_log_level_rec);
1405: end if;
1406:
1407: else

Line 1408: fa_additions_pkg.Insert_Row(

1404: p_log_level_rec => p_log_level_rec);
1405: end if;
1406:
1407: else
1408: fa_additions_pkg.Insert_Row(
1409: X_Rowid => row_id,
1410: X_Asset_Id => h_asset_id,
1411: X_Asset_Number => h_asset_number,
1412: X_Asset_Key_Ccid => X_Asset_Key_Ccid,

Line 1492: X_Calling_Fn => 'fa_additions_pkg.load_row'

1488: X_Last_Updated_By => user_id,
1489: X_Created_By => user_id,
1490: X_Creation_Date => sysdate,
1491: X_Last_Update_Login => 0,
1492: X_Calling_Fn => 'fa_additions_pkg.load_row'
1493: ,p_log_level_rec => p_log_level_rec);
1494: end if;
1495:
1496: EXCEPTION

Line 1499: CALLING_FN => 'fa_additions_pkg.load_row'

1495:
1496: EXCEPTION
1497: when others then
1498: FA_SRVR_MSG.ADD_SQL_ERROR (
1499: CALLING_FN => 'fa_additions_pkg.load_row'
1500: ,p_log_level_rec => p_log_level_rec);
1501: raise;
1502:
1503: end LOAD_ROW;

Line 1548: CALLING_FN => 'fa_additions_pkg.translate_row'

1544: when no_data_found then null;
1545:
1546: when others then
1547: FA_SRVR_MSG.ADD_SQL_ERROR (
1548: CALLING_FN => 'fa_additions_pkg.translate_row'
1549: ,p_log_level_rec => p_log_level_rec);
1550: raise;
1551:
1552: END TRANSLATE_ROW;

Line 1640: fa_additions_pkg.TRANSLATE_ROW (

1636:
1637: BEGIN
1638:
1639: if (x_upload_mode = 'NLS') then
1640: fa_additions_pkg.TRANSLATE_ROW (
1641: x_custom_mode => x_custom_mode,
1642: x_asset_id => x_asset_id,
1643: x_owner => x_owner,
1644: x_last_update_date => x_last_update_date,

Line 1648: fa_additions_pkg.LOAD_ROW (

1644: x_last_update_date => x_last_update_date,
1645: x_description => x_description
1646: ,p_log_level_rec => p_log_level_rec);
1647: else
1648: fa_additions_pkg.LOAD_ROW (
1649: x_custom_mode => x_custom_mode,
1650: x_asset_id => x_asset_id,
1651: x_owner => x_owner,
1652: x_last_update_date => x_last_update_date,

Line 1733: END FA_ADDITIONS_PKG;

1729: end if;
1730:
1731: END LOAD_SEED_ROW;
1732:
1733: END FA_ADDITIONS_PKG;