DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG3 dependencies on FA_REC_PVT_PKG3

Line 1: PACKAGE BODY FA_REC_PVT_PKG3 AS

1: PACKAGE BODY FA_REC_PVT_PKG3 AS
2: /* $Header: FAXVRC3B.pls 120.4.12010000.1 2008/07/28 13:20:31 appldev ship $ */
3:
4: /*===================================================================================+
5: | FUNCTION Validate_Rule_Changes |

Line 31: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'

27: p_new_ceiling_name => p_new_rules.ceiling_name,
28: p_log_level_rec => p_log_level_rec)
29: THEN
30: FA_SRVR_MSG.Add_Message(
31: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'
32: ,p_log_level_rec => p_log_level_rec);
33: RETURN (FALSE);
34: END IF;
35:

Line 44: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'

40: p_new_rules => p_new_rules,
41: p_log_level_rec => p_log_level_rec)
42: THEN
43: FA_SRVR_MSG.Add_Message(
44: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'
45: ,p_log_level_rec => p_log_level_rec);
46: RETURN (FALSE);
47: END IF;
48: */

Line 62: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'

58: x_prorate_date => x_prorate_date,
59: p_log_level_rec => p_log_level_rec)
60: THEN
61: FA_SRVR_MSG.Add_Message(
62: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'
63: ,p_log_level_rec => p_log_level_rec);
64: RETURN (FALSE);
65: END IF;
66:

Line 81: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'

77: x_deprn_basis_rule => x_deprn_basis_rule,
78: p_log_level_rec => p_log_level_rec)
79: THEN
80: FA_SRVR_MSG.Add_Message(
81: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'
82: ,p_log_level_rec => p_log_level_rec);
83: RETURN (FALSE);
84: END IF;
85:

Line 95: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'

91: p_life_in_months => p_new_rules.life_in_months,
92: p_log_level_rec => p_log_level_rec)
93: THEN
94: FA_SRVR_MSG.Add_Message(
95: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'
96: ,p_log_level_rec => p_log_level_rec);
97: RETURN (FALSE);
98: END IF;
99:

Line 104: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'

100: RETURN (TRUE);
101: EXCEPTION
102: WHEN OTHERS THEN
103: FA_SRVR_MSG.Add_SQL_Error(
104: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Rule_Changes'
105: ,p_log_level_rec => p_log_level_rec);
106: RETURN (FALSE);
107: END Validate_Rule_Changes;
108:

Line 161: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling',

157:
158: IF (l_book_class IN ('BUDGET', 'CORPORATE') OR
159: l_cost <= 0) THEN
160: FA_SRVR_MSG.Add_Message(
161: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling',
162: NAME => 'FA_REC_CANNOT_SET_CEIL'
163: ,p_log_level_rec => p_log_level_rec);
164: /* Message text: 'You cannot set a depreciation ceiling for
165: an asset in a corporate or budget book or an asset with a

Line 173: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling',

169:
170: IF (l_new_ceiling_type = 'RECOVERABLE COST CEILING') THEN
171: IF (l_allow_cost_ceil = 'NO') THEN
172: FA_SRVR_MSG.Add_Message(
173: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling',
174: NAME => 'FA_REC_NO_COST_CEIL'
175: ,p_log_level_rec => p_log_level_rec);
176: /* Message text:
177: 'Cost ceiling is not allowed in this book.' */

Line 183: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling',

179: END IF;
180: ELSIF (l_new_ceiling_type = 'DEPRN EXPENSE CEILING') THEN
181: IF (l_allow_deprn_exp_ceil = 'NO') THEN
182: FA_SRVR_MSG.Add_Message(
183: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling',
184: NAME => 'FA_REC_NO_DEPRN_EXP_CEIL'
185: ,p_log_level_rec => p_log_level_rec);
186: /* Message text:
187: 'Depreciation expense ceiling is not allowed in this book.' */

Line 197: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling',

193: but not both. */
194: IF (l_itc_amount_id IS NOT NULL AND
195: l_new_ceiling_type = 'RECOVERABLE COST CEILING') THEN
196: FA_SRVR_MSG.Add_Message(
197: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling',
198: NAME => 'FA_BOOK_CANT_ITC_AND_COST_CEIL'
199: ,p_log_level_rec => p_log_level_rec);
200: RETURN (FALSE);
201: END IF;

Line 207: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling'

203: RETURN (TRUE);
204: EXCEPTION
205: WHEN OTHERS THEN
206: FA_SRVR_MSG.Add_SQL_Error(
207: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Ceiling'
208: ,p_log_level_rec => p_log_level_rec);
209: RETURN (FALSE);
210: END Validate_Ceiling;
211:

Line 259: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Flag',

255: (nvl(p_old_rules.percent_salvage_value, 99) =
256: nvl(p_new_rules.percent_salvage_value, 99)))
257: THEN
258: FA_SRVR_MSG.Add_Message(
259: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Flag',
260: NAME => 'FA_REC_NO_MULTIPLE_CHANGES'
261: ,p_log_level_rec => p_log_level_rec);
262: /* Message text: 'You cannot make more than one adjustment
263: upon changing the Depreciate flag.' */

Line 275: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Flag',

271: FETCH chk_deprn_flag INTO check_flag;
272: IF (chk_deprn_flag%found) THEN
273: CLOSE chk_deprn_flag;
274: FA_SRVR_MSG.Add_Message(
275: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Flag',
276: NAME => 'FA_BOOK_INVALID_DEPRN_FLAG'
277: ,p_log_level_rec => p_log_level_rec);
278: RETURN (FALSE);
279: END IF;

Line 288: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Flag'

284: RETURN (TRUE);
285: EXCEPTION
286: WHEN OTHERS THEN
287: FA_SRVR_MSG.Add_SQL_Error(
288: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Flag'
289: ,p_log_level_rec => p_log_level_rec);
290: RETURN (FALSE);
291: END Validate_Deprn_Flag;
292:

Line 329: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Convention',

325: FETCH get_prorate_date INTO l_prorate_date;
326: IF (get_prorate_date%notfound) THEN
327: CLOSE get_prorate_date;
328: FA_SRVR_MSG.Add_Message(
329: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Convention',
330: NAME => 'FA_BOOK_CANT_GEN_PRORATE_DATE'
331: ,p_log_level_rec => p_log_level_rec);
332: RETURN (FALSE);
333: END IF;

Line 347: -- CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Convention',

343: /* Cannot amortize a prorate convention adjustment. */
344: -- Bug 1111642
345: -- IF (p_amortize_flag = 'YES') THEN
346: -- FA_SRVR_MSG.Add_Message(
347: -- CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Convention',
348: -- NAME => 'FA_CANNOT_AMORTIZE_PRORATE_CHE');
349: -- RETURN (FALSE);
350: -- END IF;
351:

Line 358: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Convention',

354: FETCH check_prorate_date INTO check_flag;
355: IF (check_prorate_date%notfound) THEN
356: CLOSE check_prorate_date;
357: FA_SRVR_MSG.Add_Message(
358: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Convention',
359: NAME => 'FA_BKS_INVALID_PRORATE_DATE'
360: ,p_log_level_rec => p_log_level_rec);
361: RETURN (FALSE);
362: END IF;

Line 369: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Convention'

365: RETURN (TRUE);
366: EXCEPTION
367: WHEN OTHERS THEN
368: FA_SRVR_MSG.Add_SQL_Error(
369: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Convention'
370: ,p_log_level_rec => p_log_level_rec);
371: RETURN (FALSE);
372: END Validate_Convention;
373:

Line 504: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',

500: IF (l_new_deprn_basis_rule = 'NBV' AND
501: l_new_rate_src_rule = 'FLAT' AND
502: l_itc_amount_id IS NOT NULL) THEN
503: FA_SRVR_MSG.Add_Message(
504: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',
505: NAME => 'FA_BOOK_INVALID_METHOD'
506: ,p_log_level_rec => p_log_level_rec);
507: RETURN (FALSE);
508: END IF;

Line 516: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',

512: FETCH check_method INTO check_flag;
513: IF (check_method%found) THEN
514: CLOSE check_method;
515: FA_SRVR_MSG.Add_Message(
516: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',
517: NAME => 'FA_BOOK_NO_CHANGE_TO_PROD'
518: ,p_log_level_rec => p_log_level_rec);
519: RETURN (FALSE);
520: END IF;

Line 533: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',

529: FETCH check_tax_book_method INTO check_flag;
530: IF (check_tax_book_method%found) THEN
531: CLOSE check_tax_book_method;
532: FA_SRVR_MSG.Add_Message(
533: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',
534: NAME => 'FA_REC_MUST_USE_UOP'
535: ,p_log_level_rec => p_log_level_rec);
536: /* Message text: 'Production method must be used in a
537: corporate book, if a production method will be used in

Line 552: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',

548: FETCH check_corp_book_method INTO check_flag;
549: IF (check_corp_book_method%found) THEN
550: CLOSE check_corp_book_method;
551: FA_SRVR_MSG.Add_Message(
552: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',
553: NAME => 'FA_REC_CORP_NOT_UOP'
554: ,p_log_level_rec => p_log_level_rec);
555: /* Message text: 'Production method cannot be used in
556: a tax book, if production method will not be used in its

Line 581: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',

577: /* Old method was a FORMULA method, and asset has already depreciated,
578: and therefore depreciation method change is disallowed. */
579: CLOSE check_short_tax;
580: FA_SRVR_MSG.Add_Message(
581: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method',
582: NAME => 'FA_SHORT_TAX_METHOD'
583: ,p_log_level_rec => p_log_level_rec);
584: /* New message:
585: 'Depreciation method cannot be changed from a formula-based

Line 597: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method'

593: RETURN (TRUE);
594: EXCEPTION
595: WHEN OTHERS THEN
596: FA_SRVR_MSG.Add_SQL_Error(
597: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Deprn_Method'
598: ,p_log_level_rec => p_log_level_rec);
599: RETURN (FALSE);
600: END Validate_Deprn_Method;
601:

Line 646: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Life_Rates',

642: FETCH check_rate INTO check_flag;
643: IF (check_rate%notfound) THEN
644: CLOSE check_rate;
645: FA_SRVR_MSG.Add_Message(
646: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Life_Rates',
647: NAME => 'FA_SHARED_INVALID_METHOD_RATE'
648: ,p_log_level_rec => p_log_level_rec);
649: RETURN (FALSE);
650: END IF;

Line 659: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Life_Rates',

655: FETCH check_life INTO check_flag;
656: IF (check_life%notfound) THEN
657: CLOSE check_life;
658: FA_SRVR_MSG.Add_Message(
659: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Life_Rates',
660: NAME => 'FA_SHARED_INVALID_METHOD_LIFE'
661: ,p_log_level_rec => p_log_level_rec);
662: RETURN (FALSE);
663: END IF;

Line 672: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Life_Rates'

668: RETURN (TRUE);
669: EXCEPTION
670: WHEN OTHERS THEN
671: FA_SRVR_MSG.Add_SQL_Error(
672: CALLING_FN => 'FA_REC_PVT_PKG3.Validate_Life_Rates'
673: ,p_log_level_rec => p_log_level_rec);
674: RETURN (FALSE);
675: END Validate_Life_Rates;
676:

Line 678: END FA_REC_PVT_PKG3;

674: RETURN (FALSE);
675: END Validate_Life_Rates;
676:
677:
678: END FA_REC_PVT_PKG3;