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.4 2005/07/25 09:59:26 yyoon ship $ */
3:
4: -- syoung: added x_return_status.
5: procedure gen_deprn_start_date(

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

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

Line 53: CALLING_FN => 'FA_FIN_ADD_PKG.gen_deprn_start_date'

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

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

73: h_status boolean; -- syoung: dummy boolean.
74: validation_error exception;
75: BEGIN
76:
77: h_status := FA_FIN_ADD_PKG.CAT_VAL(X_Book_Type_Code => X_Book_Type_Code,
78: X_Asset_Type => X_Asset_Type,
79: X_Category_Id => X_Category_Id,
80: X_Stack_Mesg => 'NO',
81: X_Calling_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL',

Line 81: X_Calling_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL',

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

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

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

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

182: p_log_level_rec => p_log_level_rec);
183:
184: when others then
185: FA_STANDARD_PKG.RAISE_ERROR
186: (Called_Fn => 'FA_FIN_ADD_PKG.BOOK_VAL',
187: Calling_Fn => X_CALLING_FN,
188: Name => lv_mesg,
189: p_log_level_rec => p_log_level_rec);
190: END BOOK_VAL;

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

251: --
252: EXCEPTION
253: when validation_error then
254: FA_STANDARD_PKG.RAISE_ERROR
255: (Called_Fn => 'FA_FIN_ADD_PKG.DPIS_VAL',
256: Calling_Fn => X_CALLING_FN,
257: Name => lv_mesg,
258: p_log_level_rec => p_log_level_rec);
259: when others then

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

257: Name => lv_mesg,
258: p_log_level_rec => p_log_level_rec);
259: when others then
260: FA_STANDARD_PKG.RAISE_ERROR
261: (Called_Fn => 'FA_FIN_ADD_PKG.DPIS_VAL',
262: Calling_Fn => X_CALLING_FN,
263: p_log_level_rec => p_log_level_rec);
264: END DPIS_VAL;
265: --

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

319: when validation_error then
320: if (X_Stack_Mesg = 'NO') then
321: -- invoke client-side mesg.
322: FA_STANDARD_PKG.RAISE_ERROR
323: (Called_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',
324: Calling_Fn => X_CALLING_FN,
325: Name => lv_mesg,
326: p_log_level_rec => p_log_level_rec);
327: else

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

325: Name => lv_mesg,
326: p_log_level_rec => p_log_level_rec);
327: else
328: FA_SRVR_MSG.Add_Message(
329: Calling_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',
330: Name => lv_mesg,
331: p_log_level_rec => p_log_level_rec);
332: end if;
333: return (false);

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

334: when others then
335: if (X_Stack_Mesg = 'NO') then
336: -- invoke client-side mesg.
337: FA_STANDARD_PKG.RAISE_ERROR
338: (Called_Fn => 'FA_FIN_ADD_PKG.CAT_VAL',
339: Calling_Fn => X_CALLING_FN,
340: p_log_level_rec => p_log_level_rec);
341: else
342: FA_SRVR_MSG.Add_SQL_Error(

Line 343: Calling_Fn => 'FA_FIN_ADD_PKG.CAT_VAL'

339: Calling_Fn => X_CALLING_FN,
340: p_log_level_rec => p_log_level_rec);
341: else
342: FA_SRVR_MSG.Add_SQL_Error(
343: Calling_Fn => 'FA_FIN_ADD_PKG.CAT_VAL'
344: ,p_log_level_rec => p_log_level_rec);
345: end if;
346: return (false);
347: END Cat_Val;

Line 349: END FA_FIN_ADD_PKG;

345: end if;
346: return (false);
347: END Cat_Val;
348: --
349: END FA_FIN_ADD_PKG;