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.8 2009/04/10 07:35:48 deemitta ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Asset_Id IN OUT NOCOPY NUMBER,

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

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

Line 329: CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);

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

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

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

Line 339: CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);

335: NAME => 'FA_ADD_TAG_NUMBER_EXISTS',
336: TOKEN1 => 'TAG_NUMBER',
337: VALUE1 => X_Tag_Number, p_log_level_rec => p_log_level_rec);
338: FA_SRVR_MSG.ADD_SQL_ERROR (
339: CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);
340: raise;
341:
342: else
343: FA_SRVR_MSG.ADD_SQL_ERROR (

Line 344: CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);

340: raise;
341:
342: else
343: FA_SRVR_MSG.ADD_SQL_ERROR (
344: CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);
345: raise;
346:
347: end if;
348:

Line 351: CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);

347: end if;
348:
349: when others then
350: FA_SRVR_MSG.ADD_SQL_ERROR (
351: CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);
352: raise;
353:
354: END Insert_Row;
355:

Line 1067: CALLING_FN => 'FA_ADDITIONS_PKG.Update_Row', p_log_level_rec => p_log_level_rec);

1063:
1064: exception
1065: when others then
1066: FA_SRVR_MSG.Add_SQL_Error(
1067: CALLING_FN => 'FA_ADDITIONS_PKG.Update_Row', p_log_level_rec => p_log_level_rec);
1068: X_Return_Status := FALSE;
1069: raise;
1070: END Update_Row;
1071:

Line 1102: CALLING_FN => 'fa_additions_pkg.delete_row', p_log_level_rec => p_log_level_rec);

1098:
1099: exception
1100: when others then
1101: FA_SRVR_MSG.ADD_SQL_ERROR (
1102: CALLING_FN => 'fa_additions_pkg.delete_row', p_log_level_rec => p_log_level_rec);
1103: raise;
1104:
1105: END Delete_Row;
1106:

Line 1124: CALLING_FN => 'fa_additions_pkg.update_units', p_log_level_rec => p_log_level_rec);

1120:
1121: exception
1122: when others then
1123: FA_SRVR_MSG.ADD_SQL_ERROR (
1124: CALLING_FN => 'fa_additions_pkg.update_units', p_log_level_rec => p_log_level_rec);
1125: raise;
1126:
1127: END Update_Units;
1128:

Line 1296: fa_additions_pkg.Update_Row(

1292: where asset_id = X_Asset_Id;
1293:
1294: if (h_record_exists > 0) then
1295:
1296: fa_additions_pkg.Update_Row(
1297: X_Asset_Id => h_asset_id,
1298: X_Asset_Number => h_asset_number,
1299: X_Asset_Key_Ccid => X_Asset_Key_Ccid,
1300: X_Current_Units => X_Current_Units,

Line 1378: X_Calling_Fn => 'fa_additions_pkg.load_row'

1374: X_Last_Update_Date => sysdate,
1375: X_Last_Updated_By => user_id,
1376: X_Last_Update_Login => 0,
1377: X_Return_Status => return_status,
1378: X_Calling_Fn => 'fa_additions_pkg.load_row'
1379: , p_log_level_rec => p_log_level_rec);
1380: else
1381: fa_additions_pkg.Insert_Row(
1382: X_Rowid => row_id,

Line 1381: fa_additions_pkg.Insert_Row(

1377: X_Return_Status => return_status,
1378: X_Calling_Fn => 'fa_additions_pkg.load_row'
1379: , p_log_level_rec => p_log_level_rec);
1380: else
1381: fa_additions_pkg.Insert_Row(
1382: X_Rowid => row_id,
1383: X_Asset_Id => h_asset_id,
1384: X_Asset_Number => h_asset_number,
1385: X_Asset_Key_Ccid => X_Asset_Key_Ccid,

Line 1465: X_Calling_Fn => 'fa_additions_pkg.load_row'

1461: X_Last_Updated_By => user_id,
1462: X_Created_By => user_id,
1463: X_Creation_Date => sysdate,
1464: X_Last_Update_Login => 0,
1465: X_Calling_Fn => 'fa_additions_pkg.load_row'
1466: , p_log_level_rec => p_log_level_rec);
1467: end if;
1468:
1469: exception

Line 1472: CALLING_FN => 'fa_additions_pkg.load_row', p_log_level_rec => p_log_level_rec);

1468:
1469: exception
1470: when others then
1471: FA_SRVR_MSG.ADD_SQL_ERROR (
1472: CALLING_FN => 'fa_additions_pkg.load_row', p_log_level_rec => p_log_level_rec);
1473: raise;
1474:
1475: end LOAD_ROW;
1476:

Line 1596: fa_additions_pkg.Update_Row(

1592: db_last_updated_by, db_last_update_date,
1593: X_CUSTOM_MODE
1594: )) then
1595:
1596: fa_additions_pkg.Update_Row(
1597: X_Asset_Id => h_asset_id,
1598: X_Asset_Number => h_asset_number,
1599: X_Asset_Key_Ccid => X_Asset_Key_Ccid,
1600: X_Current_Units => X_Current_Units,

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

1674: X_Last_Update_Date => sysdate,
1675: X_Last_Updated_By => user_id,
1676: X_Last_Update_Login => 0,
1677: X_Return_Status => return_status,
1678: X_Calling_Fn => 'fa_additions_pkg.load_row',
1679: p_log_level_rec => p_log_level_rec);
1680: end if;
1681:
1682: else

Line 1683: fa_additions_pkg.Insert_Row(

1679: p_log_level_rec => p_log_level_rec);
1680: end if;
1681:
1682: else
1683: fa_additions_pkg.Insert_Row(
1684: X_Rowid => row_id,
1685: X_Asset_Id => h_asset_id,
1686: X_Asset_Number => h_asset_number,
1687: X_Asset_Key_Ccid => X_Asset_Key_Ccid,

Line 1767: X_Calling_Fn => 'fa_additions_pkg.load_row'

1763: X_Last_Updated_By => user_id,
1764: X_Created_By => user_id,
1765: X_Creation_Date => sysdate,
1766: X_Last_Update_Login => 0,
1767: X_Calling_Fn => 'fa_additions_pkg.load_row'
1768: ,p_log_level_rec => p_log_level_rec);
1769: end if;
1770:
1771: EXCEPTION

Line 1774: CALLING_FN => 'fa_additions_pkg.load_row'

1770:
1771: EXCEPTION
1772: when others then
1773: FA_SRVR_MSG.ADD_SQL_ERROR (
1774: CALLING_FN => 'fa_additions_pkg.load_row'
1775: ,p_log_level_rec => p_log_level_rec);
1776: raise;
1777:
1778: end LOAD_ROW;

Line 1802: CALLING_FN => 'fa_additions_pkg.translate_row', p_log_level_rec => p_log_level_rec);

1798: when no_data_found then null;
1799:
1800: when others then
1801: FA_SRVR_MSG.ADD_SQL_ERROR (
1802: CALLING_FN => 'fa_additions_pkg.translate_row', p_log_level_rec => p_log_level_rec);
1803: raise;
1804:
1805: end TRANSLATE_ROW;
1806:

Line 1851: CALLING_FN => 'fa_additions_pkg.translate_row'

1847: when no_data_found then null;
1848:
1849: when others then
1850: FA_SRVR_MSG.ADD_SQL_ERROR (
1851: CALLING_FN => 'fa_additions_pkg.translate_row'
1852: ,p_log_level_rec => p_log_level_rec);
1853: raise;
1854:
1855: END TRANSLATE_ROW;

Line 1945: fa_additions_pkg.TRANSLATE_ROW (

1941:
1942: BEGIN
1943:
1944: if (x_upload_mode = 'NLS') then
1945: fa_additions_pkg.TRANSLATE_ROW (
1946: x_custom_mode => x_custom_mode,
1947: x_asset_id => x_asset_id,
1948: x_owner => x_owner,
1949: x_last_update_date => x_last_update_date,

Line 1953: fa_additions_pkg.LOAD_ROW (

1949: x_last_update_date => x_last_update_date,
1950: x_description => x_description
1951: ,p_log_level_rec => p_log_level_rec);
1952: else
1953: fa_additions_pkg.LOAD_ROW (
1954: x_custom_mode => x_custom_mode,
1955: x_asset_id => x_asset_id,
1956: x_owner => x_owner,
1957: x_last_update_date => x_last_update_date,

Line 2038: END FA_ADDITIONS_PKG;

2034: end if;
2035:
2036: END LOAD_SEED_ROW;
2037:
2038: END FA_ADDITIONS_PKG;