DBA Data[Home] [Help]

APPS.FA_FIN_ADD_PKG dependencies on FA_FIN_ADD_PKG

Line 1: PACKAGE BODY FA_FIN_ADD_PKG as

1: PACKAGE BODY FA_FIN_ADD_PKG as
2: /* $Header: faxfaddb.pls 120.5 2009/03/27 01:52:44 bridgway ship $ */
3:
4: -- syoung: added x_return_status.
5: procedure gen_deprn_start_date(

Line 47: CALLED_FN => 'fa_fin_add_pkg.get_deprn_start_date',

43: if (bks_calling_fn = 'fa_books_val.dpis_val' or
44: bks_calling_fn = 'fa_books_val3.conv_code_val') then
45: -- called from forms validation module
46: FA_STANDARD_PKG.RAISE_ERROR(
47: CALLED_FN => 'fa_fin_add_pkg.get_deprn_start_date',
48: CALLING_FN => Bks_Calling_Fn, p_log_level_rec => p_log_level_rec);
49: else
50: FA_SRVR_MSG.Add_SQL_Error(
51: CALLING_FN => 'FA_FIN_ADD_PKG.gen_deprn_start_date', p_log_level_rec => p_log_level_rec);

Line 51: CALLING_FN => 'FA_FIN_ADD_PKG.gen_deprn_start_date', p_log_level_rec => p_log_level_rec);

47: CALLED_FN => 'fa_fin_add_pkg.get_deprn_start_date',
48: CALLING_FN => Bks_Calling_Fn, p_log_level_rec => p_log_level_rec);
49: else
50: FA_SRVR_MSG.Add_SQL_Error(
51: CALLING_FN => 'FA_FIN_ADD_PKG.gen_deprn_start_date', p_log_level_rec => p_log_level_rec);
52: end if;
53: x_return_status := false;
54:
55: end gen_deprn_start_date;

Line 73: h_status := FA_FIN_ADD_PKG.CAT_VAL(X_Book_Type_Code => X_Book_Type_Code,

69: h_status boolean; -- syoung: dummy boolean.
70: validation_error exception;
71: BEGIN
72:
73: h_status := FA_FIN_ADD_PKG.CAT_VAL(X_Book_Type_Code => X_Book_Type_Code,
74: X_Asset_Type => X_Asset_Type,
75: X_Category_Id => X_Category_Id,
76: X_Stack_Mesg => 'NO',
77: X_Calling_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL', p_log_level_rec => p_log_level_rec);

Line 77: X_Calling_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL', p_log_level_rec => p_log_level_rec);

73: h_status := FA_FIN_ADD_PKG.CAT_VAL(X_Book_Type_Code => X_Book_Type_Code,
74: X_Asset_Type => X_Asset_Type,
75: X_Category_Id => X_Category_Id,
76: X_Stack_Mesg => 'NO',
77: X_Calling_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL', p_log_level_rec => p_log_level_rec);
78: -- check that book is valid
79: -- syoung: performance tuning: count(*) to count(1)
80: -- and inserted rownum condition.
81:

Line 174: (Called_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL',

170: --
171: EXCEPTION
172: when validation_error then
173: FA_STANDARD_PKG.RAISE_ERROR
174: (Called_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL',
175: Calling_Fn => X_CALLING_FN,
176: Name => lv_mesg, p_log_level_rec => p_log_level_rec);
177:
178: when others then

Line 180: (Called_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL',

176: Name => lv_mesg, p_log_level_rec => p_log_level_rec);
177:
178: when others then
179: FA_STANDARD_PKG.RAISE_ERROR
180: (Called_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL',
181: Calling_Fn => X_CALLING_FN,
182: Name => lv_mesg, p_log_level_rec => p_log_level_rec);
183: END BOOK_VAL;
184: --

Line 247: (Called_Fn => 'FA_FIN_ADD_PKG.DPIS_VAL',

243: --
244: EXCEPTION
245: when validation_error then
246: FA_STANDARD_PKG.RAISE_ERROR
247: (Called_Fn => 'FA_FIN_ADD_PKG.DPIS_VAL',
248: Calling_Fn => X_CALLING_FN,
249: Name => lv_mesg, p_log_level_rec => p_log_level_rec);
250: when others then
251: FA_STANDARD_PKG.RAISE_ERROR

Line 252: (Called_Fn => 'FA_FIN_ADD_PKG.DPIS_VAL',

248: Calling_Fn => X_CALLING_FN,
249: Name => lv_mesg, p_log_level_rec => p_log_level_rec);
250: when others then
251: FA_STANDARD_PKG.RAISE_ERROR
252: (Called_Fn => 'FA_FIN_ADD_PKG.DPIS_VAL',
253: Calling_Fn => X_CALLING_FN, p_log_level_rec => p_log_level_rec);
254: END DPIS_VAL;
255: --
256: -- syoung: changed procedure to function.

Line 313: (Called_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',

309: when validation_error then
310: if (X_Stack_Mesg = 'NO') then
311: -- invoke client-side mesg.
312: FA_STANDARD_PKG.RAISE_ERROR
313: (Called_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',
314: Calling_Fn => X_CALLING_FN,
315: Name => lv_mesg, p_log_level_rec => p_log_level_rec);
316: else
317: FA_SRVR_MSG.Add_Message(

Line 318: Calling_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',

314: Calling_Fn => X_CALLING_FN,
315: Name => lv_mesg, p_log_level_rec => p_log_level_rec);
316: else
317: FA_SRVR_MSG.Add_Message(
318: Calling_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',
319: Name => lv_mesg, p_log_level_rec => p_log_level_rec);
320: end if;
321: return (false);
322: when others then

Line 326: (Called_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',

322: when others then
323: if (X_Stack_Mesg = 'NO') then
324: -- invoke client-side mesg.
325: FA_STANDARD_PKG.RAISE_ERROR
326: (Called_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',
327: Calling_Fn => X_CALLING_FN, p_log_level_rec => p_log_level_rec);
328: else
329: FA_SRVR_MSG.Add_SQL_Error(
330: Calling_Fn => 'FA_FIN_ADD_PKG.CAT_VAL', p_log_level_rec => p_log_level_rec);

Line 330: Calling_Fn => 'FA_FIN_ADD_PKG.CAT_VAL', p_log_level_rec => p_log_level_rec);

326: (Called_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',
327: Calling_Fn => X_CALLING_FN, p_log_level_rec => p_log_level_rec);
328: else
329: FA_SRVR_MSG.Add_SQL_Error(
330: Calling_Fn => 'FA_FIN_ADD_PKG.CAT_VAL', p_log_level_rec => p_log_level_rec);
331: end if;
332: return (false);
333: END Cat_Val;
334: --

Line 335: END FA_FIN_ADD_PKG;

331: end if;
332: return (false);
333: END Cat_Val;
334: --
335: END FA_FIN_ADD_PKG;