DBA Data[Home] [Help]

APPS.IGI_IAC_REINSTATE_PKG dependencies on FA_SRVR_MSG

Line 1128: FA_SRVR_MSG.add_message(

1124: CLOSE c_get_ytd;
1125: END IF;
1126: g_message := 'No corresponding reinstatement found for the retirement distribution';
1127: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
1128: FA_SRVR_MSG.add_message(
1129: Calling_Fn => g_calling_fn,
1130: Name => 'IGI_IAC_NO_CORR_REIN_DIST_ID'
1131: );
1132: RETURN FALSE;

Line 1140: FA_SRVR_MSG.add_message(

1136: CLOSE c_get_ytd;
1137: END IF;
1138:
1139: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
1140: FA_SRVR_MSG.add_message(
1141: Calling_Fn => g_calling_fn,
1142: Name => 'IGI_IAC_WF_FAILED_CCID'
1143: );
1144: RETURN FALSE;

Line 1153: FA_SRVR_MSG.add_sql_error(

1149: END IF;
1150: g_message := 'Error:'||SQLERRM;
1151: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1152: g_calling_fn1 := g_calling_fn||' : Full';
1153: FA_SRVR_MSG.add_sql_error(
1154: Calling_Fn => g_calling_fn1
1155: );
1156: RETURN FALSE;
1157: END Full_Reinstatement;

Line 1832: FA_SRVR_MSG.add_message(

1828: EXCEPTION
1829: WHEN e_no_cost_prorate THEN
1830: g_message := 'Could not get a cost prorate factor';
1831: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
1832: FA_SRVR_MSG.add_message(
1833: Calling_Fn => g_calling_fn,
1834: Name => 'IGI_IAC_NO_REINS_PRORATE'
1835: );
1836: RETURN FALSE;

Line 1844: FA_SRVR_MSG.add_message(

1840: CLOSE c_get_ytd;
1841: END IF;
1842:
1843: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
1844: FA_SRVR_MSG.add_message(
1845: Calling_Fn => g_calling_fn,
1846: Name => 'IGI_IAC_WF_FAILED_CCID'
1847: );
1848: RETURN FALSE;

Line 1858: FA_SRVR_MSG.add_sql_error(

1854: g_message := 'Error:'||SQLERRM;
1855: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1856:
1857: g_calling_fn1 := g_calling_fn||' : Cost';
1858: FA_SRVR_MSG.add_sql_error(
1859: Calling_Fn => g_calling_fn1
1860: );
1861: RETURN FALSE;
1862: END Cost_Reinstatement;

Line 2870: FA_SRVR_MSG.add_message(

2866: CLOSE c_dist_det_bal;
2867: END IF;
2868: g_message := 'No corresponding reinstatement found for the retirement distribution';
2869: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
2870: FA_SRVR_MSG.add_message(
2871: Calling_Fn => g_calling_fn,
2872: Name => 'IGI_IAC_NO_CORR_REIN_DIST_ID'
2873: );
2874: RETURN FALSE;

Line 2882: FA_SRVR_MSG.add_message(

2878: CLOSE c_dist_det_bal;
2879: END IF;
2880: g_message := 'Prorate factor for unit reinstatement not found';
2881: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
2882: FA_SRVR_MSG.add_message(
2883: Calling_Fn => g_calling_fn,
2884: Name => 'IGI_IAC_NO_REINS_PRORATE'
2885: );
2886: RETURN FALSE;

Line 2893: FA_SRVR_MSG.add_message(

2889: IF c_dist_det_bal%ISOPEN THEN
2890: CLOSE c_dist_det_bal;
2891: END IF;
2892: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
2893: FA_SRVR_MSG.add_message(
2894: Calling_Fn => g_calling_fn,
2895: Name => 'IGI_IAC_WF_FAILED_CCID'
2896: );
2897: RETURN FALSE;

Line 2906: FA_SRVR_MSG.add_sql_error(

2902: END IF;
2903: g_message := 'Error:'||SQLERRM;
2904: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
2905: g_calling_fn1 := g_calling_fn||' : Unit';
2906: FA_SRVR_MSG.add_sql_error(
2907: Calling_Fn => g_calling_fn1
2908: );
2909: RETURN FALSE;
2910: END Unit_Reinstatement;

Line 3134: FA_SRVR_MSG.add_message(

3130: CLOSE c_reverse_je;
3131: END IF;
3132: g_message := 'Latest transaction could not be retrieved for the asset';
3133: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3134: FA_SRVR_MSG.add_message(
3135: Calling_Fn => g_calling_fn,
3136: Name => 'IGI_IAC_NO_LATEST_TRX'
3137: );
3138: RETURN FALSE;

Line 3147: FA_SRVR_MSG.add_message(

3143: CLOSE c_reverse_je;
3144: END IF;
3145: g_message := 'Could not get corresponding reinstatement distribution id';
3146: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3147: FA_SRVR_MSG.add_message(
3148: Calling_Fn => g_calling_fn,
3149: Name => 'IGI_IAC_NO_CORR_REIN_DIST_ID'
3150: );
3151: RETURN FALSE;

Line 3159: FA_SRVR_MSG.add_message(

3155: IF c_reverse_je%ISOPEN THEN
3156: CLOSE c_reverse_je;
3157: END IF;
3158: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3159: FA_SRVR_MSG.add_message(
3160: Calling_Fn => g_calling_fn,
3161: Name => 'IGI_IAC_REINSTATE_FAILED'
3162: );
3163: RETURN FALSE;

Line 3173: FA_SRVR_MSG.add_sql_error(

3169: END IF;
3170: g_message := 'Error: '||SQLERRM;
3171: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
3172: g_calling_fn1 := g_calling_fn||' : First_Transaction';
3173: FA_SRVR_MSG.add_sql_error(
3174: Calling_Fn => g_calling_fn1
3175: );
3176: RETURN FALSE;
3177: END First_Transaction;

Line 3316: FA_SRVR_MSG.add_message(

3312: EXCEPTION
3313: WHEN e_latest_trx_not_avail THEN
3314: g_message := 'Latest transaction could not be retrieved for the asset';
3315: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3316: FA_SRVR_MSG.add_message(
3317: Calling_Fn => g_calling_fn,
3318: Name => 'IGI_IAC_NO_LATEST_TRX'
3319: );
3320: RETURN FALSE;

Line 3323: FA_SRVR_MSG.add_message(

3319: );
3320: RETURN FALSE;
3321: WHEN e_reinstate_failed THEN
3322: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3323: FA_SRVR_MSG.add_message(
3324: Calling_Fn => g_calling_fn,
3325: Name => 'IGI_IAC_REINSTATE_FAILED'
3326: );
3327: RETURN FALSE;

Line 3332: FA_SRVR_MSG.add_sql_error(

3328: WHEN others THEN
3329: g_message := 'Error: '||SQLERRM;
3330: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
3331: g_calling_fn1 := g_calling_fn||' : Second_Transaction';
3332: FA_SRVR_MSG.add_sql_error(
3333: Calling_Fn => g_calling_fn1
3334: );
3335: RETURN FALSE;
3336: END Second_Transaction;

Line 3535: FA_SRVR_MSG.Add_Message(

3531: P_Asset_Id,
3532: l_eff_ret_rec.period_counter ) THEN
3533:
3534:
3535: FA_SRVR_MSG.Add_Message(
3536: Calling_FN => p_calling_function ,
3537: Name => 'IGI_IAC_NO_REINST_REVAL',
3538: TOKEN1 => 'NUMBER',
3539: VALUE1 => l_asset_num,

Line 3629: FA_SRVR_MSG.add_message(

3625: END IF;
3626:
3627: g_message := 'IAC is not enabled in IGI options.';
3628: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3629: FA_SRVR_MSG.add_message(
3630: Calling_Fn => g_calling_fn,
3631: Name => 'IGI_IAC_NOT_INSTALLED'
3632: );
3633:

Line 3644: FA_SRVR_MSG.add_message(

3640: END IF;
3641:
3642: g_message := 'The book is not an IAC book';
3643: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3644: FA_SRVR_MSG.add_message(
3645: Calling_Fn => g_calling_fn,
3646: Name => 'IGI_IAC_NOT_IAC_BOOK'
3647: );
3648:

Line 3659: FA_SRVR_MSG.add_message(

3655: END IF;
3656:
3657: g_message := 'This asset has not been revalued with IAC.';
3658: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3659: FA_SRVR_MSG.add_message(
3660: Calling_Fn => g_calling_fn,
3661: Name => 'IGI_IAC_NO_IAC_EFFECT'
3662: );
3663:

Line 3674: FA_SRVR_MSG.add_message(

3670: END IF;
3671:
3672: g_message := 'Could not create the ytd rows in igi_iac_fa_deprn';
3673: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3674: FA_SRVR_MSG.add_message(
3675: Calling_Fn => g_calling_fn,
3676: Name => 'IGI_IAC_FA_DEPR_CREATE_PROB',
3677: Token1 => 'BOOK',
3678: Value1 => g_book_type_code

Line 3691: FA_SRVR_MSG.add_message(

3687: CLOSE c_fa_trx_headers;
3688: END IF;
3689: g_message := 'This asset has been revalued atleast once after retirement. Cannot be reinstated.';
3690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3691: FA_SRVR_MSG.add_message(
3692: Calling_Fn => g_calling_fn,
3693: Name => 'IGI_IAC_REVAL_POST_RETIRE'
3694: );
3695: ROLLBACK;

Line 3707: FA_SRVR_MSG.add_message(

3703: END IF;
3704:
3705: g_message := 'Retirement information not available for asset';
3706: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3707: FA_SRVR_MSG.add_message(
3708: Calling_Fn => g_calling_fn,
3709: Name => 'IGI_IAC_NO_RETIRE_EFFECT'
3710: );
3711: --ROLLBACK;

Line 3722: FA_SRVR_MSG.add_message(

3718: END IF;
3719:
3720: g_message := 'Period Info Error: '||SQLERRM;
3721: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3722: FA_SRVR_MSG.add_message(
3723: Calling_Fn => g_calling_fn,
3724: Name => 'IGI_IAC_NO_PERIOD_INFO'
3725: );
3726: --ROLLBACK;

Line 3737: FA_SRVR_MSG.add_message(

3733: END IF;
3734:
3735: g_message := 'Cannot define retirement type';
3736: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3737: FA_SRVR_MSG.add_message(
3738: Calling_Fn => g_calling_fn,
3739: Name => 'IGI_IAC_INDEF_RETIRE_TYPE'
3740: );
3741: --ROLLBACK;

Line 3751: FA_SRVR_MSG.add_message(

3747: CLOSE c_fa_trx_headers;
3748: END IF;
3749:
3750: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3751: FA_SRVR_MSG.add_message(
3752: Calling_Fn => g_calling_fn,
3753: Name => 'IGI_IAC_REINSTATE_FAILED'
3754: );
3755: --ROLLBACK;

Line 3765: FA_SRVR_MSG.add_message(

3761: CLOSE c_fa_trx_headers;
3762: END IF;
3763:
3764: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3765: FA_SRVR_MSG.add_message(
3766: Calling_Fn => g_calling_fn,
3767: Name => 'IGI_IAC_REINSTATE_FAILED'
3768: );
3769: --ROLLBACK;

Line 3781: FA_SRVR_MSG.add_sql_error(

3777:
3778: g_message := 'Error: '||SQLERRM;
3779: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
3780: g_calling_fn1 := g_calling_fn||' : Main';
3781: FA_SRVR_MSG.add_sql_error(
3782: Calling_Fn => g_calling_fn1
3783: );
3784: --ROLLBACK;
3785: RETURN FALSE;