DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PVT dependencies on FA_SRVR_MSG

Line 411: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

407: l_adj.mrc_sob_type_code := p_mrc_sob_type_code;
408:
409: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
410: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
411: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
412: raise ret_err;
413: end if;
414:
415: l_adj.account := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;

Line 677: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

673: if (p_log_level_rec.statement_level) then
674: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed', p_log_level_rec => p_log_level_rec);
675: end if;
676:
677: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
678: return false;
679:
680: when OTHERS then
681: if (p_log_level_rec.statement_level) then

Line 685: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

681: if (p_log_level_rec.statement_level) then
682: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed'||':'||sqlerrm, p_log_level_rec => p_log_level_rec);
683: end if;
684:
685: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
686: return false;
687:
688: END DO_RETIREMENT;
689:

Line 785: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

781: return true;
782:
783: EXCEPTION
784: when OTHERS then
785: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
786:
787: if c_get_thid%ISOPEN then
788: CLOSE c_get_thid;
789: end if;

Line 1491: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

1487: if (p_log_level_rec.statement_level) then
1488: fa_debug_pkg.add(l_calling_fn, '(rein_err)Processing reinstatement', 'Failed');
1489: end if;
1490:
1491: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1492:
1493: return false;
1494:
1495: when OTHERS then

Line 1500: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

1496: if (p_log_level_rec.statement_level) then
1497: fa_debug_pkg.add(l_calling_fn, '(others)Processing reinstatement', 'Failed');
1498: end if;
1499:
1500: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1501:
1502: return false;
1503:
1504: END DO_REINSTATEMENT;

Line 1583: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

1579: -- BUG# 3641747
1580: -- call cache as it was not yet initialized
1581: if not fa_cache_pkg.fazccb(p_asset_hdr_rec.book_type_code,
1582: p_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
1583: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1584: raise calc_err;
1585: end if;
1586:
1587: l_adj.transaction_header_id := p_trans_rec.transaction_header_id;

Line 1915: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

1911: If (not (nvl(p_asset_fin_rec.tracking_method,'NULL') = 'CALCULATE' and
1912: nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'Y' ) ) then
1913: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
1914: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
1915: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1916: raise calc_err;
1917: end if;
1918:
1919: l_adj.asset_id := p_asset_fin_rec.group_asset_id;

Line 1925: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

1921: end if;
1922: /*bug#15897249 ends */
1923: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
1924: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
1925: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1926: raise calc_err;
1927: end if;
1928:
1929: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

Line 2297: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2293: return true;
2294:
2295: EXCEPTION
2296: when calc_err then
2297: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2298:
2299: return false;
2300:
2301: when OTHERS then

Line 2302: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2298:
2299: return false;
2300:
2301: when OTHERS then
2302: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2303:
2304: return false;
2305:
2306: END CALC_GAIN_LOSS_FOR_RET;

Line 2461: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2457: -- BUG# 3641747
2458: -- call cache as it was not yet initialized
2459: if not fa_cache_pkg.fazccb(p_asset_hdr_rec.book_type_code,
2460: p_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2461: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2462: raise calc_err;
2463: end if;
2464: /* bug#15897249 start */
2465: If ((nvl(p_asset_fin_rec.tracking_method,'NULL') = 'CALCULATE' and

Line 2654: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2650: -- Set category book cache w/ group information.
2651: --
2652: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
2653: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2654: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2655: raise calc_err;
2656: end if;
2657:
2658: /* bug#15897249 added if condition */

Line 2664: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2660: nvl(p_asset_fin_rec.member_rollup_flag, 'N') = 'Y' ) ) then
2661:
2662: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
2663: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2664: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2665: raise calc_err;
2666: end if;
2667:
2668: l_adj.asset_id := p_asset_fin_rec.group_asset_id;

Line 2742: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2738: --
2739: if (l_asset_cat_rec.category_id is null) then
2740: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
2741: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2742: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2743: raise calc_err;
2744: end if;
2745: end if;
2746:

Line 2756: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2752: --
2753: if (l_asset_cat_rec.category_id is null) then
2754: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
2755: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2756: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2757: raise calc_err;
2758: end if;
2759: end if;
2760:

Line 2815: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2811: --
2812: if (l_asset_cat_rec.category_id is null) then
2813: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
2814: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2815: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2816: raise calc_err;
2817: end if;
2818: end if;
2819:

Line 2829: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2825: --
2826: if (l_asset_cat_rec.category_id is null) then
2827: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
2828: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
2829: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2830: raise calc_err;
2831: end if;
2832: end if;
2833:

Line 3116: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3112: return true;
3113:
3114: EXCEPTION
3115: when calc_err then
3116: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3117:
3118: return false;
3119:
3120: when OTHERS then

Line 3121: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3117:
3118: return false;
3119:
3120: when OTHERS then
3121: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3122:
3123: return false;
3124:
3125: END CALC_GAIN_LOSS_FOR_REI;

Line 3329: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3325: l_asset_deprn_rec_adj.deprn_reserve := -1 * p_asset_deprn_rec_old.deprn_reserve * (p_ret.cost_retired/l_asset_fin_rec_old.cost);
3326:
3327: if not FA_UTILS_PKG.faxrnd(l_asset_deprn_rec_adj.deprn_reserve, p_ret.book,
3328: p_ret.set_of_books_id, p_log_level_rec => p_log_level_rec) then
3329: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3330: raise calc_err;
3331: end if;
3332:
3333: if (p_log_level_rec.statement_level) then

Line 3520: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3516: end if;
3517:
3518: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
3519: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
3520: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3521: raise calc_err;
3522: end if;
3523:
3524: l_adj.account := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;

Line 3586: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3582: return TRUE;
3583:
3584: EXCEPTION
3585: WHEN calc_err THEN
3586: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3587:
3588: return false;
3589:
3590: WHEN OTHERS THEN

Line 3591: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3587:
3588: return false;
3589:
3590: WHEN OTHERS THEN
3591: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3592:
3593: return false;
3594:
3595:

Line 3870: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3866: l_adj.source_type_code := 'RETIREMENT';
3867:
3868: if not fa_cache_pkg.fazccb(l_asset_hdr_rec.book_type_code,
3869: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
3870: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3871: raise calc_err;
3872: end if;
3873:
3874: l_adj.account := fa_cache_pkg.fazccb_record.DEPRN_EXPENSE_ACCT;

Line 3985: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3981: return true;
3982:
3983: EXCEPTION
3984: WHEN calc_err THEN
3985: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3986:
3987: return false;
3988:
3989: WHEN OTHERS THEN

Line 4009: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

4005: if c_get_thx%ISOPEN then
4006: close c_get_thx;
4007: end if;
4008:
4009: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4010:
4011: return false;
4012:
4013: END Do_Reinstatement_in_CGL;

Line 4203: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

4199: end if;
4200:
4201: if not fa_cache_pkg.fazccb(p_book_type_code,
4202: l_asset_cat_rec.category_id, p_log_level_rec => p_log_level_rec) then
4203: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4204: raise gl_err;
4205: end if;
4206:
4207: l_adj.account := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;

Line 4274: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

4270: return true;
4271:
4272: EXCEPTION
4273: WHEN gl_err THEN
4274: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4275:
4276: return false;
4277:
4278: WHEN OTHERS THEN

Line 4279: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

4275:
4276: return false;
4277:
4278: WHEN OTHERS THEN
4279: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4280:
4281: return false;
4282:
4283: END Do_Terminal_Gain_Loss_All_Bk;

Line 4439: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

4435: return true;
4436:
4437: EXCEPTION
4438: WHEN gl_err THEN
4439: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4440:
4441: return false;
4442:
4443: WHEN OTHERS THEN

Line 4444: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

4440:
4441: return false;
4442:
4443: WHEN OTHERS THEN
4444: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4445:
4446: return false;
4447:
4448: END Do_Terminal_Gain_Loss;

Line 4670: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

4666: if (p_log_level_rec.statement_level) then
4667: fa_debug_pkg.add(l_calling_fn, 'End', FALSE, p_log_level_rec => p_log_level_rec);
4668: end if;
4669:
4670: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4671: return FALSE;
4672:
4673: WHEN OTHERS THEN
4674: if (p_log_level_rec.statement_level) then

Line 4678: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

4674: if (p_log_level_rec.statement_level) then
4675: fa_debug_pkg.add(l_calling_fn, 'End', FALSE, p_log_level_rec => p_log_level_rec);
4676: end if;
4677:
4678: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4679: return FALSE;
4680:
4681: END Check_Terminal_Gain_Loss;
4682:

Line 5572: fa_srvr_msg.add_message(

5568: end if;
5569:
5570: if (t_adjusted_recoverable_cost(i) >= 0) then
5571: if (t_adjusted_recoverable_cost(i) - l_rein_mem_deprn_resv - t_adjustment_amount(i) < 0) then
5572: fa_srvr_msg.add_message(
5573: calling_fn => l_calling_fn,
5574: name => 'FA_EGY_REINS_NOT_POSSIBLE',
5575: p_log_level_rec => p_log_level_rec);
5576: raise allocate_err;

Line 5580: fa_srvr_msg.add_message(

5576: raise allocate_err;
5577: end if;
5578: else
5579: if (t_adjusted_recoverable_cost(i) - l_rein_mem_deprn_resv - t_adjustment_amount(i) > 0) then
5580: fa_srvr_msg.add_message(
5581: calling_fn => l_calling_fn,
5582: name => 'FA_EGY_REINS_NOT_POSSIBLE',
5583: p_log_level_rec => p_log_level_rec);
5584: raise allocate_err;

Line 5761: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

5757:
5758: if not fa_cache_pkg.fazccb(p_asset_hdr_rec.book_type_code,
5759: t_asset_category_id(i),
5760: p_log_level_rec) then
5761: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5762: raise allocate_err;
5763: end if;
5764:
5765: l_adj.account := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;

Line 6725: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

6721: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec);
6722: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed'||':'||sqlerrm, p_log_level_rec => p_log_level_rec);
6723: end if;
6724:
6725: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
6726: return false;
6727:
6728: END Do_Allocation;
6729:

Line 6857: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

6853: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec);
6854: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed'||':'||sqlerrm, p_log_level_rec => p_log_level_rec);
6855: end if;
6856:
6857: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
6858: return false;
6859:
6860: END MOVE_RESERVE_TO_ACT_DIST;
6861: /*bug#15897249 end */