DBA Data[Home] [Help]

APPS.FA_MASS_RECLASS_PKG dependencies on FA_MASS_RECLASS

Line 1: PACKAGE BODY FA_MASS_RECLASS_PKG AS

1: PACKAGE BODY FA_MASS_RECLASS_PKG AS
2: /* $Header: FAXMRCLB.pls 120.13 2005/11/11 08:04:56 tdewanga ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:

Line 6: -- Mass reclass record from fa_mass_reclass table.

2: /* $Header: FAXMRCLB.pls 120.13 2005/11/11 08:04:56 tdewanga ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: -- Mass reclass record from fa_mass_reclass table.
7: mr_rec FA_MASS_REC_UTILS_PKG.mass_reclass_rec;
8:
9: /*====================================================================================+
10: | PROCEDURE Do_Mass_Reclass |

Line 25: -- cursor to fetch mass reclass record from fa_mass_reclass

21: x_success_count OUT NOCOPY number,
22: x_failure_count OUT NOCOPY number,
23: x_return_status OUT NOCOPY number) IS
24:
25: -- cursor to fetch mass reclass record from fa_mass_reclass
26: CURSOR mass_reclass IS
27: SELECT mr.mass_reclass_id,
28: mr.book_type_code,
29: mr.transaction_date_entered,

Line 69: FROM fa_mass_reclass mr

65: mr.creation_date,
66: mr.last_updated_by,
67: mr.last_update_login,
68: mr.last_update_date
69: FROM fa_mass_reclass mr
70: WHERE mass_reclass_id = p_mass_reclass_Id;
71:
72: -- assets that meet the user's selection criteria.
73: -- some assets selected by this cursor are discarded in the validation engine.

Line 259: l_calling_fn VARCHAR2(50) := 'FA_MASS_RECLASS_PKG.DO_RECLASS';

255: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
256: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
257: l_recl_opt_rec FA_API_TYPES.reclass_options_rec_type;
258:
259: l_calling_fn VARCHAR2(50) := 'FA_MASS_RECLASS_PKG.DO_RECLASS';
260: l_string varchar2(250);
261:
262: mrcl_failure EXCEPTION; -- mass reclass failure
263: done_exc EXCEPTION;

Line 590: CALLING_FN => 'FA_MASS_RECLASS_PKG.Check_Trans_Date',

586:
587: IF (X_Trans_Date < l_cp_open_date OR
588: X_Trans_date > l_cp_close_date) THEN
589: FA_SRVR_MSG.Add_Message(
590: CALLING_FN => 'FA_MASS_RECLASS_PKG.Check_Trans_Date',
591: NAME => 'FA_REC_INVALID_TRANS_DATE',
592: p_log_level_rec => p_log_level_rec);
593: RETURN (FALSE);
594: END IF;

Line 601: CALLING_FN => 'FA_MASS_RECLASS_PKG.Check_Trans_Date'

597:
598: EXCEPTION
599: WHEN OTHERS THEN
600: FA_SRVR_MSG.Add_SQL_Error(
601: CALLING_FN => 'FA_MASS_RECLASS_PKG.Check_Trans_Date'
602: ,p_log_level_rec => p_log_level_rec);
603: RETURN (FALSE);
604: END Check_Trans_Date;
605:

Line 685: CALLING_FN => 'FA_MASS_RECLASS_PKG.Check_Criteria'

681:
682: EXCEPTION
683: WHEN OTHERS THEN
684: FA_SRVR_MSG.Add_SQL_Error(
685: CALLING_FN => 'FA_MASS_RECLASS_PKG.Check_Criteria'
686: ,p_log_level_rec => p_log_level_rec);
687: RETURN (FALSE);
688:
689: END Check_Criteria;

Line 712: l_calling_fn := 'fa_mass_reclass_pkg.do_reclass';

708: l_message := nvl(p_message, 'FA_MASSRCL_FAIL_TRX');
709:
710: if (l_message <> 'FA_MCP_RECLASS_SUCCESS' and
711: l_message <> 'FA_REC_NOT_PROCESSED') then
712: l_calling_fn := 'fa_mass_reclass_pkg.do_reclass';
713: end if;
714:
715: fnd_message.set_name('OFA', l_message);
716: l_mesg := substrb(fnd_message.get, 1, 100);

Line 735: END FA_MASS_RECLASS_PKG;

731: raise;
732:
733: END write_message;
734:
735: END FA_MASS_RECLASS_PKG;