DBA Data[Home] [Help]

APPS.FA_ASSET_DESC_PUB dependencies on FA_ASSET_DESC_PUB

Line 1: PACKAGE BODY FA_ASSET_DESC_PUB AS

1: PACKAGE BODY FA_ASSET_DESC_PUB AS
2: /* $Header: FAPADSCB.pls 120.20.12020000.2 2012/07/23 09:34:46 rmandali ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FA_ASSET_DESC_PUB';
5: G_API_NAME CONSTANT VARCHAR2(30) := 'Update Asset Description API';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FA_ASSET_DESC_PUB';

1: PACKAGE BODY FA_ASSET_DESC_PUB AS
2: /* $Header: FAPADSCB.pls 120.20.12020000.2 2012/07/23 09:34:46 rmandali ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FA_ASSET_DESC_PUB';
5: G_API_NAME CONSTANT VARCHAR2(30) := 'Update Asset Description API';
6: G_API_VERSION CONSTANT NUMBER := 1.0;
7:
8: g_log_level_rec fa_api_types.log_level_rec_type;

Line 47: l_calling_fn varchar2(50) := 'FA_ASSET_DESC_PUB.update_desc';

43:
44: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
45: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
46: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
47: l_calling_fn varchar2(50) := 'FA_ASSET_DESC_PUB.update_desc';
48: pub_error exception;
49:
50: l_err_stage varchar2(640);
51: l_crl_enabled boolean := FALSE;

Line 1087: (calling_fn => 'fa_asset_desc_pub.update_desc', p_log_level_rec => g_log_level_rec);

1083:
1084: ROLLBACK TO do_desc_update;
1085:
1086: fa_srvr_msg.add_message
1087: (calling_fn => 'fa_asset_desc_pub.update_desc', p_log_level_rec => g_log_level_rec);
1088:
1089: FND_MSG_PUB.count_and_get (
1090: p_count => x_msg_count,
1091: p_data => x_msg_data

Line 1101: (calling_fn => 'fa_asset_desc_pub.update_desc', p_log_level_rec => g_log_level_rec);

1097:
1098: ROLLBACK TO do_desc_update;
1099:
1100: fa_srvr_msg.add_sql_error
1101: (calling_fn => 'fa_asset_desc_pub.update_desc', p_log_level_rec => g_log_level_rec);
1102:
1103: FND_MSG_PUB.count_and_get (
1104: p_count => x_msg_count,
1105: p_data => x_msg_data

Line 1127: l_calling_fn := 'FA_ASSET_DESC_PUB.update_row';

1123: update_error EXCEPTION;
1124: l_rowid varchar2(10):= null;
1125: BEGIN
1126:
1127: l_calling_fn := 'FA_ASSET_DESC_PUB.update_row';
1128:
1129: -- update fa_additions.
1130: -- for bug no. 3643781. made the serial number case sensitive.
1131: fa_additions_pkg.update_row (

Line 1311: WR_calling_fn => 'fa_asset_desc_pub.update_row'

1307: WR_creation_date => NULL,
1308: WR_last_update_login => p_trans_rec.who_info.last_update_login,
1309: WR_Update_Row => 'YES',
1310: WR_Insert_Row => 'NO',
1311: WR_calling_fn => 'fa_asset_desc_pub.update_row'
1312: , p_log_level_rec => p_log_level_rec);
1313: elsif (p_old_warranty_id is NULL) then
1314: -- Add a warranty to an asset that doesn't have one
1315: FA_ADD_WARRANTY_PKG.Update_table(

Line 1328: WR_calling_fn => 'fa_asset_desc_pub.update_row'

1324: WR_creation_date => p_trans_rec.who_info.last_update_date,
1325: WR_last_update_login => p_trans_rec.who_info.last_update_login,
1326: WR_Update_Row => 'NO',
1327: WR_Insert_Row => 'YES',
1328: WR_calling_fn => 'fa_asset_desc_pub.update_row'
1329: , p_log_level_rec => p_log_level_rec);
1330: elsif (p_asset_desc_rec_new.warranty_id <> p_old_warranty_id) then
1331: -- Change an asset's existing warranty
1332: FA_ADD_WARRANTY_PKG.Update_table(

Line 1345: WR_calling_fn => 'fa_asset_desc_pub.update_row'

1341: WR_creation_date => p_trans_rec.who_info.last_update_date,
1342: WR_last_update_login => p_trans_rec.who_info.last_update_login,
1343: WR_Update_Row => 'YES',
1344: WR_Insert_Row => 'YES',
1345: WR_calling_fn => 'fa_asset_desc_pub.update_row'
1346: , p_log_level_rec => p_log_level_rec);
1347: end if;
1348: end if;
1349:

Line 1387: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_invoice_desc';

1383: l_rowid ROWID;
1384: l_period_rec fa_api_types.period_rec_type;
1385: l_inv_rec fa_api_types.inv_rec_type;
1386:
1387: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_invoice_desc';
1388:
1389: -- Bug 8252607/5475276 Cursor to get the book_type_code
1390: CURSOR c_corp_book( p_asset_id number ) IS
1391: SELECT bc.book_type_code

Line 2001: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_retirement_desc';

1997: l_rowid ROWID;
1998: l_period_rec fa_api_types.period_rec_type;
1999: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2000:
2001: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_retirement_desc';
2002:
2003: -- For primary and reporting books
2004: l_reporting_flag varchar2(1) := 'P';
2005: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;

Line 2702: calling_fn => 'fa_asset_desc_pub.initialize_category_df', p_log_level_rec => p_log_level_rec);

2698: if not fa_cache_pkg.fazcat(
2699: X_cat_id => px_asset_cat_rec.category_id
2700: , p_log_level_rec => p_log_level_rec) then
2701: fa_srvr_msg.add_message(
2702: calling_fn => 'fa_asset_desc_pub.initialize_category_df', p_log_level_rec => p_log_level_rec);
2703: return FALSE;
2704: end if;
2705: */
2706: if not fa_cache_pkg.fazsys(g_log_level_rec) then

Line 2708: calling_fn => 'fa_asset_desc_pub.initialize_category_df', p_log_level_rec => p_log_level_rec);

2704: end if;
2705: */
2706: if not fa_cache_pkg.fazsys(g_log_level_rec) then
2707: fa_srvr_msg.add_message(
2708: calling_fn => 'fa_asset_desc_pub.initialize_category_df', p_log_level_rec => p_log_level_rec);
2709: return FALSE;
2710: end if;
2711:
2712: l_category_chart_id :=

Line 2726: calling_fn => 'fa_asset_desc_pub.initialize_category_df', p_log_level_rec => p_log_level_rec);

2722: p_segment_array => l_segment_array,
2723: p_concat_string => l_concat_string
2724: , p_log_level_rec => p_log_level_rec) then
2725: fa_srvr_msg.add_message(
2726: calling_fn => 'fa_asset_desc_pub.initialize_category_df', p_log_level_rec => p_log_level_rec);
2727: return FALSE;
2728: end if;
2729:
2730: px_asset_cat_rec.desc_flex.attribute_category_code := l_concat_string;

Line 2830: fa_srvr_msg.add_sql_error(calling_fn => 'fa_asset_desc_pub.initialize_category_df', p_log_level_rec => p_log_level_rec);

2826: return (TRUE);
2827: EXCEPTION
2828:
2829: WHEN OTHERS THEN
2830: fa_srvr_msg.add_sql_error(calling_fn => 'fa_asset_desc_pub.initialize_category_df', p_log_level_rec => p_log_level_rec);
2831: return FALSE;
2832:
2833: END;
2834:

Line 2835: END FA_ASSET_DESC_PUB;

2831: return FALSE;
2832:
2833: END;
2834:
2835: END FA_ASSET_DESC_PUB;