DBA Data[Home] [Help]

APPS.IGI_IAC_REINSTATE_PKG dependencies on FA_SRVR_MSG

Line 1102: FA_SRVR_MSG.add_message(

1098: CLOSE c_get_ytd;
1099: END IF;
1100: g_message := 'No corresponding reinstatement found for the retirement distribution';
1101: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
1102: FA_SRVR_MSG.add_message(
1103: Calling_Fn => g_calling_fn,
1104: Name => 'IGI_IAC_NO_CORR_REIN_DIST_ID'
1105: );
1106: RETURN FALSE;

Line 1114: FA_SRVR_MSG.add_message(

1110: CLOSE c_get_ytd;
1111: END IF;
1112:
1113: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
1114: FA_SRVR_MSG.add_message(
1115: Calling_Fn => g_calling_fn,
1116: Name => 'IGI_IAC_WF_FAILED_CCID'
1117: );
1118: RETURN FALSE;

Line 1127: FA_SRVR_MSG.add_sql_error(

1123: END IF;
1124: g_message := 'Error:'||SQLERRM;
1125: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1126: g_calling_fn1 := g_calling_fn||' : Full';
1127: FA_SRVR_MSG.add_sql_error(
1128: Calling_Fn => g_calling_fn1
1129: );
1130: RETURN FALSE;
1131: END Full_Reinstatement;

Line 1800: FA_SRVR_MSG.add_message(

1796: EXCEPTION
1797: WHEN e_no_cost_prorate THEN
1798: g_message := 'Could not get a cost prorate factor';
1799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
1800: FA_SRVR_MSG.add_message(
1801: Calling_Fn => g_calling_fn,
1802: Name => 'IGI_IAC_NO_REINS_PRORATE'
1803: );
1804: RETURN FALSE;

Line 1812: FA_SRVR_MSG.add_message(

1808: CLOSE c_get_ytd;
1809: END IF;
1810:
1811: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
1812: FA_SRVR_MSG.add_message(
1813: Calling_Fn => g_calling_fn,
1814: Name => 'IGI_IAC_WF_FAILED_CCID'
1815: );
1816: RETURN FALSE;

Line 1826: FA_SRVR_MSG.add_sql_error(

1822: g_message := 'Error:'||SQLERRM;
1823: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
1824:
1825: g_calling_fn1 := g_calling_fn||' : Cost';
1826: FA_SRVR_MSG.add_sql_error(
1827: Calling_Fn => g_calling_fn1
1828: );
1829: RETURN FALSE;
1830: END Cost_Reinstatement;

Line 2833: FA_SRVR_MSG.add_message(

2829: CLOSE c_dist_det_bal;
2830: END IF;
2831: g_message := 'No corresponding reinstatement found for the retirement distribution';
2832: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
2833: FA_SRVR_MSG.add_message(
2834: Calling_Fn => g_calling_fn,
2835: Name => 'IGI_IAC_NO_CORR_REIN_DIST_ID'
2836: );
2837: RETURN FALSE;

Line 2845: FA_SRVR_MSG.add_message(

2841: CLOSE c_dist_det_bal;
2842: END IF;
2843: g_message := 'Prorate factor for unit reinstatement not found';
2844: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
2845: FA_SRVR_MSG.add_message(
2846: Calling_Fn => g_calling_fn,
2847: Name => 'IGI_IAC_NO_REINS_PRORATE'
2848: );
2849: RETURN FALSE;

Line 2856: FA_SRVR_MSG.add_message(

2852: IF c_dist_det_bal%ISOPEN THEN
2853: CLOSE c_dist_det_bal;
2854: END IF;
2855: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
2856: FA_SRVR_MSG.add_message(
2857: Calling_Fn => g_calling_fn,
2858: Name => 'IGI_IAC_WF_FAILED_CCID'
2859: );
2860: RETURN FALSE;

Line 2869: FA_SRVR_MSG.add_sql_error(

2865: END IF;
2866: g_message := 'Error:'||SQLERRM;
2867: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
2868: g_calling_fn1 := g_calling_fn||' : Unit';
2869: FA_SRVR_MSG.add_sql_error(
2870: Calling_Fn => g_calling_fn1
2871: );
2872: RETURN FALSE;
2873: END Unit_Reinstatement;

Line 3097: FA_SRVR_MSG.add_message(

3093: CLOSE c_reverse_je;
3094: END IF;
3095: g_message := 'Latest transaction could not be retrieved for the asset';
3096: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3097: FA_SRVR_MSG.add_message(
3098: Calling_Fn => g_calling_fn,
3099: Name => 'IGI_IAC_NO_LATEST_TRX'
3100: );
3101: RETURN FALSE;

Line 3110: FA_SRVR_MSG.add_message(

3106: CLOSE c_reverse_je;
3107: END IF;
3108: g_message := 'Could not get corresponding reinstatement distribution id';
3109: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3110: FA_SRVR_MSG.add_message(
3111: Calling_Fn => g_calling_fn,
3112: Name => 'IGI_IAC_NO_CORR_REIN_DIST_ID'
3113: );
3114: RETURN FALSE;

Line 3122: FA_SRVR_MSG.add_message(

3118: IF c_reverse_je%ISOPEN THEN
3119: CLOSE c_reverse_je;
3120: END IF;
3121: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3122: FA_SRVR_MSG.add_message(
3123: Calling_Fn => g_calling_fn,
3124: Name => 'IGI_IAC_REINSTATE_FAILED'
3125: );
3126: RETURN FALSE;

Line 3136: FA_SRVR_MSG.add_sql_error(

3132: END IF;
3133: g_message := 'Error: '||SQLERRM;
3134: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
3135: g_calling_fn1 := g_calling_fn||' : First_Transaction';
3136: FA_SRVR_MSG.add_sql_error(
3137: Calling_Fn => g_calling_fn1
3138: );
3139: RETURN FALSE;
3140: END First_Transaction;

Line 3279: FA_SRVR_MSG.add_message(

3275: EXCEPTION
3276: WHEN e_latest_trx_not_avail THEN
3277: g_message := 'Latest transaction could not be retrieved for the asset';
3278: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3279: FA_SRVR_MSG.add_message(
3280: Calling_Fn => g_calling_fn,
3281: Name => 'IGI_IAC_NO_LATEST_TRX'
3282: );
3283: RETURN FALSE;

Line 3286: FA_SRVR_MSG.add_message(

3282: );
3283: RETURN FALSE;
3284: WHEN e_reinstate_failed THEN
3285: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3286: FA_SRVR_MSG.add_message(
3287: Calling_Fn => g_calling_fn,
3288: Name => 'IGI_IAC_REINSTATE_FAILED'
3289: );
3290: RETURN FALSE;

Line 3295: FA_SRVR_MSG.add_sql_error(

3291: WHEN others THEN
3292: g_message := 'Error: '||SQLERRM;
3293: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
3294: g_calling_fn1 := g_calling_fn||' : Second_Transaction';
3295: FA_SRVR_MSG.add_sql_error(
3296: Calling_Fn => g_calling_fn1
3297: );
3298: RETURN FALSE;
3299: END Second_Transaction;

Line 3496: FA_SRVR_MSG.Add_Message(

3492: P_Asset_Id,
3493: l_eff_ret_rec.period_counter ) THEN
3494:
3495:
3496: FA_SRVR_MSG.Add_Message(
3497: Calling_FN => p_calling_function ,
3498: Name => 'IGI_IAC_NO_REINST_REVAL',
3499: TOKEN1 => 'NUMBER',
3500: VALUE1 => l_asset_num,

Line 3590: FA_SRVR_MSG.add_message(

3586: END IF;
3587:
3588: g_message := 'IAC is not enabled in IGI options.';
3589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3590: FA_SRVR_MSG.add_message(
3591: Calling_Fn => g_calling_fn,
3592: Name => 'IGI_IAC_NOT_INSTALLED'
3593: );
3594:

Line 3605: FA_SRVR_MSG.add_message(

3601: END IF;
3602:
3603: g_message := 'The book is not an IAC book';
3604: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3605: FA_SRVR_MSG.add_message(
3606: Calling_Fn => g_calling_fn,
3607: Name => 'IGI_IAC_NOT_IAC_BOOK'
3608: );
3609:

Line 3620: FA_SRVR_MSG.add_message(

3616: END IF;
3617:
3618: g_message := 'This asset has not been revalued with IAC.';
3619: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3620: FA_SRVR_MSG.add_message(
3621: Calling_Fn => g_calling_fn,
3622: Name => 'IGI_IAC_NO_IAC_EFFECT'
3623: );
3624:

Line 3635: FA_SRVR_MSG.add_message(

3631: END IF;
3632:
3633: g_message := 'Could not create the ytd rows in igi_iac_fa_deprn';
3634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3635: FA_SRVR_MSG.add_message(
3636: Calling_Fn => g_calling_fn,
3637: Name => 'IGI_IAC_FA_DEPR_CREATE_PROB',
3638: Token1 => 'BOOK',
3639: Value1 => g_book_type_code

Line 3652: FA_SRVR_MSG.add_message(

3648: CLOSE c_fa_trx_headers;
3649: END IF;
3650: g_message := 'This asset has been revalued atleast once after retirement. Cannot be reinstated.';
3651: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,g_message);
3652: FA_SRVR_MSG.add_message(
3653: Calling_Fn => g_calling_fn,
3654: Name => 'IGI_IAC_REVAL_POST_RETIRE'
3655: );
3656: ROLLBACK;

Line 3668: FA_SRVR_MSG.add_message(

3664: END IF;
3665:
3666: g_message := 'Retirement information not available for asset';
3667: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3668: FA_SRVR_MSG.add_message(
3669: Calling_Fn => g_calling_fn,
3670: Name => 'IGI_IAC_NO_RETIRE_EFFECT'
3671: );
3672: --ROLLBACK;

Line 3683: FA_SRVR_MSG.add_message(

3679: END IF;
3680:
3681: g_message := 'Period Info Error: '||SQLERRM;
3682: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3683: FA_SRVR_MSG.add_message(
3684: Calling_Fn => g_calling_fn,
3685: Name => 'IGI_IAC_NO_PERIOD_INFO'
3686: );
3687: --ROLLBACK;

Line 3698: FA_SRVR_MSG.add_message(

3694: END IF;
3695:
3696: g_message := 'Cannot define retirement type';
3697: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3698: FA_SRVR_MSG.add_message(
3699: Calling_Fn => g_calling_fn,
3700: Name => 'IGI_IAC_INDEF_RETIRE_TYPE'
3701: );
3702: --ROLLBACK;

Line 3712: FA_SRVR_MSG.add_message(

3708: CLOSE c_fa_trx_headers;
3709: END IF;
3710:
3711: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3712: FA_SRVR_MSG.add_message(
3713: Calling_Fn => g_calling_fn,
3714: Name => 'IGI_IAC_REINSTATE_FAILED'
3715: );
3716: --ROLLBACK;

Line 3726: FA_SRVR_MSG.add_message(

3722: CLOSE c_fa_trx_headers;
3723: END IF;
3724:
3725: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,g_message);
3726: FA_SRVR_MSG.add_message(
3727: Calling_Fn => g_calling_fn,
3728: Name => 'IGI_IAC_REINSTATE_FAILED'
3729: );
3730: --ROLLBACK;

Line 3742: FA_SRVR_MSG.add_sql_error(

3738:
3739: g_message := 'Error: '||SQLERRM;
3740: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
3741: g_calling_fn1 := g_calling_fn||' : Main';
3742: FA_SRVR_MSG.add_sql_error(
3743: Calling_Fn => g_calling_fn1
3744: );
3745: --ROLLBACK;
3746: RETURN FALSE;