DBA Data[Home] [Help]

APPS.FA_TRANSFER_PUB dependencies on FA_TRANSFER_PUB

Line 1: PACKAGE BODY FA_TRANSFER_PUB AS

1: PACKAGE BODY FA_TRANSFER_PUB AS
2: /* $Header: FAPTFRB.pls 120.16.12020000.3 2012/11/30 13:59:33 spooyath ship $ */
3:
4: --*********************** Global constants *******************************--
5: G_PKG_NAME CONSTANT varchar2(30) := 'FA_TRANSFER_PUB';

Line 5: G_PKG_NAME CONSTANT varchar2(30) := 'FA_TRANSFER_PUB';

1: PACKAGE BODY FA_TRANSFER_PUB AS
2: /* $Header: FAPTFRB.pls 120.16.12020000.3 2012/11/30 13:59:33 spooyath ship $ */
3:
4: --*********************** Global constants *******************************--
5: G_PKG_NAME CONSTANT varchar2(30) := 'FA_TRANSFER_PUB';
6: G_API_NAME CONSTANT varchar2(30) := 'Transfer API';
7: G_API_VERSION CONSTANT number := 1.0;
8: g_release number := fa_cache_pkg.fazarel_release; --Bug 8477066
9:

Line 75: calling_fn => 'FA_TRANSFER_PUB.do_transfer',

71: end if;
72:
73: if (px_asset_hdr_rec.asset_id is null) then
74: fa_srvr_msg.add_message(
75: calling_fn => 'FA_TRANSFER_PUB.do_transfer',
76: name => 'FA_SHARED_ITEM_NULL',
77: token1 => 'ITEM',
78: value1 => 'Asset Id', p_log_level_rec => g_log_level_rec);
79: raise FND_API.G_EXC_ERROR;

Line 90: (calling_fn => 'FA_TRANSFER_PUB.do_transfer',

86: close c_corp_book;
87:
88: if px_asset_hdr_rec.book_type_code is null then
89: fa_srvr_msg.add_message
90: (calling_fn => 'FA_TRANSFER_PUB.do_transfer',
91: name => 'FA_EXP_GET_ASSET_INFO', p_log_level_rec => g_log_level_rec);
92: raise FND_API.G_EXC_ERROR;
93: end if;
94: end if;

Line 106: p_calling_fn => 'FA_TRANSFER_PUB.do_transfer', p_log_level_rec => g_log_level_rec) then

102: if not fa_asset_val_pvt.validate_asset_book
103: (p_transaction_type_code => 'TRANSFER',
104: p_book_type_code => px_asset_hdr_rec.book_type_code,
105: p_asset_id => px_asset_hdr_rec.asset_id,
106: p_calling_fn => 'FA_TRANSFER_PUB.do_transfer', p_log_level_rec => g_log_level_rec) then
107: raise FND_API.G_EXC_ERROR;
108: end if;
109:
110: --Verify if impairment has happened in same period

Line 209: p_calling_function =>'FA_TRANSFER_PUB.Do_Transfer') then

205: if not FA_IGI_EXT_PKG.Do_Transfer(
206: p_trans_rec => px_trans_rec,
207: p_asset_hdr_rec => px_asset_hdr_rec,
208: p_asset_cat_rec => l_asset_cat_rec,
209: p_calling_function =>'FA_TRANSFER_PUB.Do_Transfer') then
210: raise FND_API.G_EXC_ERROR;
211: end if;
212: end if; -- (FA_IGI_EXT_PKG.IAC_Enabled)
213:

Line 242: calling_fn => 'FA_TRANSFER_PUB.do_transfer',

238: end if;
239: /*
240: -- Return the status.
241: FA_SRVR_MSG.Add_Message(
242: calling_fn => 'FA_TRANSFER_PUB.do_transfer',
243: name => 'FA_SHARED_END_SUCCESS',
244: token1 => 'PROGRAM',
245: value1 => 'FA_TRANSFER_PUB.do_transfer', p_log_level_rec => g_log_level_rec); */
246:

Line 245: value1 => 'FA_TRANSFER_PUB.do_transfer', p_log_level_rec => g_log_level_rec); */

241: FA_SRVR_MSG.Add_Message(
242: calling_fn => 'FA_TRANSFER_PUB.do_transfer',
243: name => 'FA_SHARED_END_SUCCESS',
244: token1 => 'PROGRAM',
245: value1 => 'FA_TRANSFER_PUB.do_transfer', p_log_level_rec => g_log_level_rec); */
246:
247: FND_MSG_PUB.Count_And_Get(
248: p_count => x_msg_count,
249: p_data => x_msg_data

Line 258: calling_fn => 'FA_TRANSFER_PUB.do_transfer', p_log_level_rec => g_log_level_rec);

254:
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: FA_SRVR_MSG.Add_Message(
258: calling_fn => 'FA_TRANSFER_PUB.do_transfer', p_log_level_rec => g_log_level_rec);
259:
260: FND_MSG_PUB.Count_And_Get(
261: p_count => x_msg_count,
262: p_data => x_msg_data

Line 269: calling_fn => 'FA_TRANSFER_PUB.do_transfer', p_log_level_rec => g_log_level_rec);

265: x_return_status := FND_API.G_RET_STS_ERROR;
266:
267: WHEN OTHERS THEN
268: FA_SRVR_MSG.add_sql_error(
269: calling_fn => 'FA_TRANSFER_PUB.do_transfer', p_log_level_rec => g_log_level_rec);
270:
271: FND_MSG_PUB.Count_And_Get(
272: p_count => x_msg_count,
273: p_data => x_msg_data

Line 306: calling_fn => 'FA_TRANSFER_PUB.valid_input', p_log_level_rec => p_log_level_rec);

302: p_asset_id => p_asset_hdr_rec.asset_id,
303: x_override_flag => l_override_flag,
304: p_log_level_rec => p_log_level_rec)) then
305: fa_srvr_msg.add_message(
306: calling_fn => 'FA_TRANSFER_PUB.valid_input', p_log_level_rec => p_log_level_rec);
307: return FALSE;
308: end if;
309: -- if override flag is set to No, do not allow the transfer
310: if (l_override_flag = 'N') then

Line 312: calling_fn => 'FA_TRANSFER_PUB.valid_input',

308: end if;
309: -- if override flag is set to No, do not allow the transfer
310: if (l_override_flag = 'N') then
311: fa_srvr_msg.add_message(
312: calling_fn => 'FA_TRANSFER_PUB.valid_input',
313: name => 'CUA_NO_DIST_CHANGE_ALLOWED', p_log_level_rec => p_log_level_rec);
314: return FALSE;
315: end if;
316: end if;

Line 322: calling_fn => 'FA_TRANSFER_PUB.valid_input',

318: -- check if asset is fully retired
319: if FA_ASSET_VAL_PVT.validate_fully_retired(p_asset_hdr_rec.asset_id,
320: p_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then
321: fa_srvr_msg.add_message(
322: calling_fn => 'FA_TRANSFER_PUB.valid_input',
323: Name => 'FA_REC_RETIRED', p_log_level_rec => p_log_level_rec);
324: return FALSE;
325: end if;
326:

Line 337: p_calling_fn => 'FA_TRANSFER_PUB.do_transfer',

333: /*Bug 8601485 - Verify if transfer date of the asset is before DPIS*/
334: if not fa_asset_val_pvt.validate_asset_transfer_date
335: (p_asset_hdr_rec => p_asset_hdr_rec,
336: p_trans_rec => px_trans_rec,
337: p_calling_fn => 'FA_TRANSFER_PUB.do_transfer',
338: p_log_level_rec => NULL) then
339: fa_srvr_msg.add_message( calling_fn => 'FA_TRANSFER_PUB.valid_input',
340: name => 'FA_MASSTFR_VALID_TFR_DPIS', p_log_level_rec => p_log_level_rec);
341: return FALSE;

Line 339: fa_srvr_msg.add_message( calling_fn => 'FA_TRANSFER_PUB.valid_input',

335: (p_asset_hdr_rec => p_asset_hdr_rec,
336: p_trans_rec => px_trans_rec,
337: p_calling_fn => 'FA_TRANSFER_PUB.do_transfer',
338: p_log_level_rec => NULL) then
339: fa_srvr_msg.add_message( calling_fn => 'FA_TRANSFER_PUB.valid_input',
340: name => 'FA_MASSTFR_VALID_TFR_DPIS', p_log_level_rec => p_log_level_rec);
341: return FALSE;
342: end if;
343:

Line 353: fa_srvr_msg.add_message( calling_fn => 'FA_TRANSFER_PUB.valid_input', p_log_level_rec => p_log_level_rec);

349: px_trans_rec.transaction_date_entered :=
350: to_date(to_char(l_transaction_date,'DD/MM/YYYY'),'DD/MM/YYYY');
351: else
352: if not fa_cache_pkg.fazcbc (X_book => p_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then
353: fa_srvr_msg.add_message( calling_fn => 'FA_TRANSFER_PUB.valid_input', p_log_level_rec => p_log_level_rec);
354: return FALSE;
355: else
356: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
357: l_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;

Line 366: if not FA_UTIL_PVT.get_latest_trans_date('FA_TRANSFER_PUB.valid_input',

362: from fa_fiscal_year
363: where fiscal_year = l_fiscal_year
364: and fiscal_year_name = l_fiscal_year_name;
365:
366: if not FA_UTIL_PVT.get_latest_trans_date('FA_TRANSFER_PUB.valid_input',
367: p_asset_hdr_rec.asset_id,
368: p_asset_hdr_rec.book_type_code,
369: l_max_transaction_date, p_log_level_rec => p_log_level_rec) then
370: return FALSE;

Line 376: calling_fn => 'FA_TRANSFER_PUB.valid_input',

372:
373: if (px_trans_rec.transaction_date_entered 374: px_trans_rec.transaction_date_entered > l_fy_end_date) then
375: fa_srvr_msg.add_message(
376: calling_fn => 'FA_TRANSFER_PUB.valid_input',
377: name => 'FA_RET_DATE_MUSTBE_IN_CUR_FY', p_log_level_rec => p_log_level_rec);
378: return FALSE;
379: end if;
380:

Line 383: calling_fn => 'FA_TRANSFER_PUB.valid_input',

379: end if;
380:
381: if (px_trans_rec.transaction_date_entered > l_period_rec.calendar_period_close_date) then
382: fa_srvr_msg.add_message(
383: calling_fn => 'FA_TRANSFER_PUB.valid_input',
384: name => 'FA_SHARED_CANNOT_FUTURE', p_log_level_rec => p_log_level_rec);
385: return FALSE;
386: end if;
387:

Line 390: calling_fn => 'FA_TRANSFER_PUB.valid_input',

386: end if;
387:
388: if (px_trans_rec.transaction_date_entered < l_max_transaction_date) then
389: fa_srvr_msg.add_message(
390: calling_fn => 'FA_TRANSFER_PUB.valid_input',
391: name => 'FA_SHARED_OTHER_TRX_FOLLOW', p_log_level_rec => p_log_level_rec);
392: return FALSE;
393: end if;
394:

Line 397: calling_fn => 'FA_TRANSFER_PUB.valid_input',

393: end if;
394:
395: if (px_trans_rec.transaction_date_entered 396: fa_srvr_msg.add_message(
397: calling_fn => 'FA_TRANSFER_PUB.valid_input',
398: name => 'FA_YEAR_GREATER_THAN', p_log_level_rec => p_log_level_rec);
399: return FALSE;
400: end if;
401:

Line 420: calling_fn => 'FA_TRANSFER_PUB.valid_input',

416: AND dp.period_close_date IS NULL;
417:
418: IF (l_count > 0) THEN
419: fa_srvr_msg.add_message(
420: calling_fn => 'FA_TRANSFER_PUB.valid_input',
421: name => 'FA_SHARED_ONE_PRIOR_PERIOD_TRX', p_log_level_rec => p_log_level_rec);
422: return FALSE;
423: end if;
424:

Line 442: calling_fn => 'FA_TRANSFER_PUB.valid_input',

438: AND dp.period_close_date IS NULL;
439:
440: if (l_count > 0) THEN
441: fa_srvr_msg.add_message(
442: calling_fn => 'FA_TRANSFER_PUB.valid_input',
443: name => 'FA_NO_TRX_WHEN_LIFE_COMPLETE', p_log_level_rec => p_log_level_rec);
444: return FALSE;
445: end if;
446:

Line 467: calling_fn => 'FA_TRANSFER_PUB.valid_input',

463: AND bc.DISTRIBUTION_SOURCE_BOOK = nvl(p_asset_hdr_rec.book_type_code,'XX') ;
464:
465: if (l_count > 0) THEN
466: fa_srvr_msg.add_message(
467: calling_fn => 'FA_TRANSFER_PUB.valid_input',
468: name => 'FA_TAX_PRIOR_PER_TFR', p_log_level_rec => p_log_level_rec);
469: return FALSE;
470: end if;
471: end if;

Line 479: calling_fn => 'FA_TRANSFER_PUB.valid_input', p_log_level_rec => p_log_level_rec);

475:
476: EXCEPTION
477: when others then
478: fa_srvr_msg.add_sql_error(
479: calling_fn => 'FA_TRANSFER_PUB.valid_input', p_log_level_rec => p_log_level_rec);
480: return FALSE;
481:
482: END;
483:

Line 486: END FA_TRANSFER_PUB;

482: END;
483:
484:
485:
486: END FA_TRANSFER_PUB;