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.18 2006/08/25 15:01:33 spooyath noship $ */
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.18 2006/08/25 15:01:33 spooyath noship $ */
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 56: l_calling_fn := 'FA_ASSET_DESC_PUB.update_desc';

52: l_old_warranty_id number(15);
53:
54: BEGIN
55:
56: l_calling_fn := 'FA_ASSET_DESC_PUB.update_desc';
57:
58: SAVEPOINT do_desc_update;
59: if (not g_log_level_rec.initialized) then
60: if (NOT fa_util_pub.get_log_level_rec (

Line 1121: (calling_fn => 'fa_asset_desc_pub.update_desc',

1117:
1118: ROLLBACK TO do_desc_update;
1119:
1120: fa_srvr_msg.add_message
1121: (calling_fn => 'fa_asset_desc_pub.update_desc',
1122: p_log_level_rec => g_log_level_rec);
1123:
1124: FND_MSG_PUB.count_and_get (
1125: p_count => x_msg_count,

Line 1136: (calling_fn => 'fa_asset_desc_pub.update_desc'

1132:
1133: ROLLBACK TO do_desc_update;
1134:
1135: fa_srvr_msg.add_sql_error
1136: (calling_fn => 'fa_asset_desc_pub.update_desc'
1137: ,p_log_level_rec => g_log_level_rec);
1138:
1139: FND_MSG_PUB.count_and_get (
1140: p_count => x_msg_count,

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

1159: update_error EXCEPTION;
1160: l_rowid varchar2(10):= null;
1161: BEGIN
1162:
1163: l_calling_fn := 'FA_ASSET_DESC_PUB.update_row';
1164:
1165: -- update fa_additions.
1166: -- for bug no. 3643781. made the serial number case sensitive.
1167: fa_additions_pkg.update_row (

Line 1348: WR_calling_fn => 'fa_asset_desc_pub.update_row' ,

1344: WR_creation_date => NULL,
1345: WR_last_update_login => p_trans_rec.who_info.last_update_login,
1346: WR_Update_Row => 'YES',
1347: WR_Insert_Row => 'NO',
1348: WR_calling_fn => 'fa_asset_desc_pub.update_row' ,
1349: p_log_level_rec => p_log_level_rec);
1350: elsif (p_old_warranty_id is NULL) then
1351: -- Add a warranty to an asset that doesn't have one
1352: FA_ADD_WARRANTY_PKG.Update_table(

Line 1365: WR_calling_fn => 'fa_asset_desc_pub.update_row' ,

1361: WR_creation_date => p_trans_rec.who_info.last_update_date,
1362: WR_last_update_login => p_trans_rec.who_info.last_update_login,
1363: WR_Update_Row => 'NO',
1364: WR_Insert_Row => 'YES',
1365: WR_calling_fn => 'fa_asset_desc_pub.update_row' ,
1366: p_log_level_rec => p_log_level_rec);
1367: elsif (p_asset_desc_rec_new.warranty_id <> p_old_warranty_id) then
1368: -- Change an asset's existing warranty
1369: FA_ADD_WARRANTY_PKG.Update_table(

Line 1382: WR_calling_fn => 'fa_asset_desc_pub.update_row' ,

1378: WR_creation_date => p_trans_rec.who_info.last_update_date,
1379: WR_last_update_login => p_trans_rec.who_info.last_update_login,
1380: WR_Update_Row => 'YES',
1381: WR_Insert_Row => 'YES',
1382: WR_calling_fn => 'fa_asset_desc_pub.update_row' ,
1383: p_log_level_rec => p_log_level_rec);
1384: end if;
1385: end if;
1386:

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

1422: l_rowid ROWID;
1423: l_period_rec fa_api_types.period_rec_type;
1424: l_inv_rec fa_api_types.inv_rec_type;
1425:
1426: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_invoice_desc';
1427:
1428: -- Bug 5475276 Cursor to get the book_type_code
1429: CURSOR c_corp_book( p_asset_id number ) IS
1430: SELECT bc.book_type_code

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

2058: l_rowid ROWID;
2059: l_period_rec fa_api_types.period_rec_type;
2060: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2061:
2062: l_calling_fn varchar2(40) := 'FA_ASSET_DESC_PUB.update_retirement_desc';
2063:
2064: -- For primary and reporting books
2065: l_reporting_flag varchar2(1) := 'P';
2066: l_rsob_tbl fa_cache_pkg.fazcrsob_sob_tbl_type;

Line 2788: calling_fn => 'fa_asset_desc_pub.initialize_category_df',

2784: if not fa_cache_pkg.fazcat(
2785: X_cat_id => px_asset_cat_rec.category_id
2786: ,p_log_level_rec => p_log_level_rec) then
2787: fa_srvr_msg.add_message(
2788: calling_fn => 'fa_asset_desc_pub.initialize_category_df',
2789: p_log_level_rec => p_log_level_rec);
2790: return FALSE;
2791: end if;
2792: */

Line 2795: calling_fn => 'fa_asset_desc_pub.initialize_category_df',

2791: end if;
2792: */
2793: if not fa_cache_pkg.fazsys then
2794: fa_srvr_msg.add_message(
2795: calling_fn => 'fa_asset_desc_pub.initialize_category_df',
2796: p_log_level_rec => p_log_level_rec);
2797: return FALSE;
2798: end if;
2799:

Line 2814: calling_fn => 'fa_asset_desc_pub.initialize_category_df',

2810: p_segment_array => l_segment_array,
2811: p_concat_string => l_concat_string
2812: ,p_log_level_rec => p_log_level_rec) then
2813: fa_srvr_msg.add_message(
2814: calling_fn => 'fa_asset_desc_pub.initialize_category_df',
2815: p_log_level_rec => p_log_level_rec);
2816: return FALSE;
2817: end if;
2818:

Line 2919: fa_srvr_msg.add_sql_error(calling_fn => 'fa_asset_desc_pub.initialize_category_df'

2915: return (TRUE);
2916: EXCEPTION
2917:
2918: WHEN OTHERS THEN
2919: fa_srvr_msg.add_sql_error(calling_fn => 'fa_asset_desc_pub.initialize_category_df'
2920: ,p_log_level_rec => p_log_level_rec);
2921: return FALSE;
2922:
2923: END;

Line 2925: END FA_ASSET_DESC_PUB;

2921: return FALSE;
2922:
2923: END;
2924:
2925: END FA_ASSET_DESC_PUB;