DBA Data[Home] [Help]

APPS.IGI_IAC_RECLASS_PKG dependencies on IGI_IAC_COMMON_UTILS

Line 62: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)

58: l_amount_old number := p_amount;
59: --l_path varchar2(150) := g_path||'do_round';
60: begin
61: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
62: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
63: THEN
64: p_amount := l_amount;
65: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
66: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

Line 65: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');

61: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
62: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
63: THEN
64: p_amount := l_amount;
65: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
66: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
67: ELSE
68: p_amount := round( l_amount, 2);
69: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

Line 69: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

65: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
66: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
67: ELSE
68: p_amount := round( l_amount, 2);
69: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
70: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
71: END IF;
72: exception when others then
73: p_amount := l_amount_old;

Line 695: if not IGI_IAC_COMMON_UTILS.GET_BOOK_GL_INFO

691: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
692: p_full_path => l_path_name,
693: p_string => '+acctg creation get gl information');
694:
695: if not IGI_IAC_COMMON_UTILS.GET_BOOK_GL_INFO
696: ( X_BOOK_TYPE_CODE => fp_det_balances.book_type_code
697: , SET_OF_BOOKS_ID => l_sob_id
698: , CHART_OF_ACCOUNTS_ID => l_coa_id
699: , CURRENCY => l_currency

Line 720: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

716: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
717: p_full_path => l_path_name,
718: p_string => '+distribution id '|| fp_det_balances.distribution_id );
719:
720: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
721: ( X_book_type_code => fp_det_balances.book_type_code
722: , X_asset_id => fp_det_balances.asset_id
723: , X_distribution_id => fp_det_balances.distribution_id
724: ,X_TRANSACTION_HEADER_ID => l_trans_rec.TRANSACTION_HEADER_ID

Line 733: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

729: THEN
730: check_ccid ( 'reval reserve');
731: return false;
732: END IF;
733: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
734: ( X_book_type_code => fp_det_balances.book_type_code
735: , X_asset_id => fp_det_balances.asset_id
736: , X_distribution_id => fp_det_balances.distribution_id
737: ,X_TRANSACTION_HEADER_ID => l_trans_rec.TRANSACTION_HEADER_ID

Line 746: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

742: THEN
743: check_ccid ( 'backlog deprn reserve');
744: return false;
745: END IF;
746: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
747: ( X_book_type_code => fp_det_balances.book_type_code
748: , X_asset_id => fp_det_balances.asset_id
749: , X_distribution_id => fp_det_balances.distribution_id
750: ,X_TRANSACTION_HEADER_ID => l_trans_rec.TRANSACTION_HEADER_ID

Line 759: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

755: THEN
756: check_ccid ( 'operating account');
757: return false;
758: END IF;
759: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
760: ( X_book_type_code => fp_det_balances.book_type_code
761: , X_asset_id => fp_det_balances.asset_id
762: , X_distribution_id => fp_det_balances.distribution_id
763: ,X_TRANSACTION_HEADER_ID => l_trans_rec.TRANSACTION_HEADER_ID

Line 772: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

768: THEN
769: check_ccid ( 'general fund account');
770: return false;
771: END IF;
772: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
773: ( X_book_type_code => fp_det_balances.book_type_code
774: , X_asset_id => fp_det_balances.asset_id
775: , X_distribution_id => fp_det_balances.distribution_id
776: ,X_TRANSACTION_HEADER_ID => l_trans_rec.TRANSACTION_HEADER_ID

Line 785: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

781: THEN
782: check_ccid ( 'asset cost account');
783: return false;
784: END IF;
785: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
786: ( X_book_type_code => fp_det_balances.book_type_code
787: , X_asset_id => fp_det_balances.asset_id
788: , X_distribution_id => fp_det_balances.distribution_id
789: ,X_TRANSACTION_HEADER_ID => l_trans_rec.TRANSACTION_HEADER_ID

Line 798: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid

794: THEN
795: check_ccid ( 'deprn reserve account');
796: return false;
797: END IF;
798: IF NOT IGI_IAC_COMMON_UTILS.get_account_ccid
799: ( X_book_type_code => fp_det_balances.book_type_code
800: , X_asset_id => fp_det_balances.asset_id
801: , X_distribution_id => fp_det_balances.distribution_id
802: ,X_TRANSACTION_HEADER_ID => l_trans_rec.TRANSACTION_HEADER_ID

Line 1630: IF NOT igi_iac_common_utils.Get_Latest_Transaction (

1626:
1627: /* Store the previous transaction adjustment id */
1628:
1629: -- get the latest transaction
1630: IF NOT igi_iac_common_utils.Get_Latest_Transaction (
1631: X_book_type_code => l_asset_hdr_rec.book_type_code,
1632: X_asset_id => l_asset_hdr_rec.asset_id,
1633: X_Transaction_Type_Code => l_transaction_type_code,
1634: X_Transaction_Id => l_transaction_id,

Line 1646: IF igi_iac_common_utils.get_open_period_info(l_asset_hdr_rec.book_type_code,l_prd_rec) THEN

1642: RETURN FALSE;
1643: END IF;
1644:
1645: -- Get the current open period
1646: IF igi_iac_common_utils.get_open_period_info(l_asset_hdr_rec.book_type_code,l_prd_rec) THEN
1647: l_current_period_counter:=l_prd_rec.period_counter;
1648: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1649: p_full_path => l_path_name,
1650: p_string => ' + Current OPen Period counter' ||l_prd_rec.period_counter );

Line 2314: IF NOT igi_iac_common_utils.Get_Latest_Transaction (

2310: END IF;
2311:
2312: close c_prev_data;*/
2313:
2314: IF NOT igi_iac_common_utils.Get_Latest_Transaction (
2315: X_book_type_code => l_asset_hdr_rec.book_type_code,
2316: X_asset_id => l_asset_hdr_rec.asset_id,
2317: X_Transaction_Type_Code => l_transaction_type_code,
2318: X_Transaction_Id => l_transaction_id,

Line 2336: IF igi_iac_common_utils.get_open_period_info(l_asset_hdr_rec.book_type_code,l_prd_rec) THEN

2332: p_string => ' + Fetch the previous transaction adjustment id '||l_prev_adjustment_id);
2333:
2334:
2335: /*Get the open period and create new transaction record in the transaction headers table */
2336: IF igi_iac_common_utils.get_open_period_info(l_asset_hdr_rec.book_type_code,l_prd_rec) THEN
2337: l_current_period_counter:=l_prd_rec.period_counter;
2338: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2339: p_full_path => l_path_name,
2340: p_string => ' + Current OPen Period counter' ||l_prd_rec.period_counter );

Line 3090: IF NOT igi_iac_common_utils.get_dpis_period_counter(p_book_type_code,

3086: IF (l_allow_indexed_reval_flag = 'N') THEN
3087: return TRUE;
3088: END IF;*/
3089:
3090: IF NOT igi_iac_common_utils.get_dpis_period_counter(p_book_type_code,
3091: p_asset_id,
3092: l_dpis_period_counter) THEN
3093: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
3094: p_full_path => l_path_name,

Line 3099: IF NOT igi_iac_common_utils.get_open_period_info(p_book_type_code,

3095: p_string => '*** Error in Fetching DPIS period counter');
3096: return FALSE;
3097: END IF;
3098:
3099: IF NOT igi_iac_common_utils.get_open_period_info(p_book_type_code,
3100: l_open_period) THEN
3101: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
3102: p_full_path => l_path_name,
3103: p_string => '*** Error in Fetching Open period info for book');

Line 3131: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,

3127: /* do revaluations till the first period of revaluations found in the asset rules*/
3128:
3129: FOR l_period_counter IN l_dpis_period_counter..l_open_period.period_counter-1 LOOP
3130:
3131: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
3132: l_period_counter,
3133: l_period_info) THEN
3134: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
3135: p_full_path => l_path_name,

Line 3172: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,

3168:
3169: IF l_idx1 = 0 then
3170: FOR l_period_counter IN l_dpis_period_counter..l_open_period.period_counter-1 LOOP
3171:
3172: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
3173: l_period_counter,
3174: l_period_info) THEN
3175: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
3176: p_full_path => l_path_name,

Line 3899: IF Not (igi_iac_common_utils.is_iac_book(p_asset_hdr_rec.book_type_code)) THEN

3895: p_full_path => l_path_name,
3896: p_string => 'Entry for IAC reclass');
3897:
3898: --validate the IAC book
3899: IF Not (igi_iac_common_utils.is_iac_book(p_asset_hdr_rec.book_type_code)) THEN
3900: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
3901: p_full_path => l_path_name,
3902: p_string => 'Not an IAC book ..'||p_asset_hdr_rec.book_type_code);
3903:

Line 3907: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_asset_hdr_rec.book_type_code,

3903:
3904: Return True;
3905: End if;
3906:
3907: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(p_asset_hdr_rec.book_type_code,
3908: 'RECLASS') THEN
3909: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
3910: p_full_path => l_path_name,
3911: p_string => '*** Error in Synchronizing Depreciation Data ***');

Line 3940: IF NOT igi_iac_common_utils.get_book_gl_info (l_asset_hdr_rec.book_type_code,

3936:
3937: --set the default vlaues missing
3938: -- set of books id
3939: IF l_asset_hdr_rec.set_of_books_id is null then
3940: IF NOT igi_iac_common_utils.get_book_gl_info (l_asset_hdr_rec.book_type_code,
3941: l_set_of_books_id,
3942: l_chart_of_accounts_id,
3943: l_currency,
3944: l_precision ) THEN

Line 4007: IF IGI_IAC_COMMON_UTILS.Is_Asset_Adjustment_Done(l_asset_hdr_rec.book_type_code,

4003: p_string => '+Validate Asset successfully');
4004:
4005: -- Check whether adjustments exist in the open period
4006: -- If Adjustments exists then stop the Reclassification
4007: IF IGI_IAC_COMMON_UTILS.Is_Asset_Adjustment_Done(l_asset_hdr_rec.book_type_code,
4008: l_asset_hdr_rec.asset_id) THEN
4009:
4010: FA_SRVR_MSG.Add_Message(
4011: Calling_FN => l_calling_function ,