DBA Data[Home] [Help]

APPS.FA_MC_UPG3_PKG dependencies on FA_DEBUG_PKG

Line 216: fa_debug_pkg.add('calculate_balances',

212: G_accounting_date := l_accounting_date;
213: -- G_accounting_date := sysdate;
214:
215: if (g_print_debug) then
216: fa_debug_pkg.add('calculate_balances',
217: 'Accounting Date to post to GL',
218: G_accounting_date);
219: end if;
220:

Line 411: fa_debug_pkg.add('calculate_balances',

407: l_found BOOLEAN;
408: l_index NUMBER;
409: BEGIN
410: if (g_print_debug) then
411: fa_debug_pkg.add('calculate_balances',
412: 'Getting Balances from FA_ADJUSTMENTS',
413: 'start');
414: end if;
415:

Line 482: fa_debug_pkg.add('calculate_balances',

478: END LOOP;
479: CLOSE adj_bal;
480:
481: if (g_print_debug) then
482: fa_debug_pkg.add('calculate_balances',
483: 'Getting Balances from FA_ADJUSTMENTS',
484: 'success');
485: end if;
486:

Line 599: fa_debug_pkg.add('calculate_balances',

595: dd.distribution_id = mdd.distribution_id;
596:
597: BEGIN
598: if (g_print_debug) then
599: fa_debug_pkg.add('calculate_balances',
600: 'Getting deprn reserve from balances',
601: 'start');
602: end if;
603:

Line 730: fa_debug_pkg.add('calculate_balances',

726: end LOOP;
727: CLOSE get_periods;
728:
729: if (g_print_debug) then
730: fa_debug_pkg.add('calculate_balances',
731: 'Getting deprn reserve balances',
732: 'success');
733: end if;
734:

Line 759: fa_debug_pkg.add('get_deprn_reserve_balances',

755:
756: EXCEPTION
757: WHEN invalid_ccid THEN
758: if (g_print_debug) then
759: fa_debug_pkg.add('get_deprn_reserve_balances',
760: 'Error Getting reserve ccid ',
761: 'failure');
762: end if;
763:

Line 770: fa_debug_pkg.add('get_deprn_reserve_balances',

766: app_exception.raise_exception;
767:
768: WHEN reserve_error THEN
769: if (g_print_debug) then
770: fa_debug_pkg.add('get_deprn_reserve_balances',
771: 'Error Getting reserve for period ',
772: l_pc);
773: fa_debug_pkg.add('get_deprn_reserve_balances',
774: 'Error Getting reserve for line num ',

Line 773: fa_debug_pkg.add('get_deprn_reserve_balances',

769: if (g_print_debug) then
770: fa_debug_pkg.add('get_deprn_reserve_balances',
771: 'Error Getting reserve for period ',
772: l_pc);
773: fa_debug_pkg.add('get_deprn_reserve_balances',
774: 'Error Getting reserve for line num ',
775: l_line_num);
776: end if;
777: fa_srvr_msg.add_sql_error (

Line 848: fa_debug_pkg.add('calculate_balances',

844: mdd.distribution_id = dd.distribution_id;
845:
846: BEGIN
847: if (g_print_debug) then
848: fa_debug_pkg.add('calculate_balances',
849: 'Getting deprn expense balances',
850: 'start');
851: end if;
852:

Line 912: fa_debug_pkg.add('calculate_balances',

908: CLOSE exp_line_num;
909: END LOOP;
910:
911: if (g_print_debug) then
912: fa_debug_pkg.add('calculate_balances',
913: 'Getting deprn expense balances',
914: 'success');
915: end if;
916:

Line 996: fa_debug_pkg.add('calculate_balances',

992: aj.code_combination_id;
993:
994: BEGIN
995: if (g_print_debug) then
996: fa_debug_pkg.add('calculate_balances',
997: 'Getting reval reserve balances',
998: 'start');
999: end if;
1000:

Line 1049: fa_debug_pkg.add('calculate_balances',

1045: END LOOP;
1046: CLOSE reval_rsv_bal;
1047:
1048: if (g_print_debug) then
1049: fa_debug_pkg.add('calculate_balances',
1050: 'Getting reval reserve balances',
1051: 'success');
1052: end if;
1053:

Line 1127: fa_debug_pkg.add('calculate_balances',

1123: mdd.distribution_id = dd.distribution_id;
1124:
1125: BEGIN
1126: if (g_print_debug) then
1127: fa_debug_pkg.add('calculate_balances',
1128: 'Getting reval amort balances',
1129: 'start');
1130: end if;
1131:

Line 1181: fa_debug_pkg.add('calculate_balances',

1177: CLOSE amort_line_num;
1178: END LOOP;
1179:
1180: if (g_print_debug) then
1181: fa_debug_pkg.add('calculate_balances',
1182: 'Getting reval amort balances',
1183: 'success');
1184: end if;
1185:

Line 1239: fa_debug_pkg.add('calculate_balances',

1235: GROUP BY
1236: dd.deferred_deprn_reserve_ccid;
1237: BEGIN
1238: if (g_print_debug) then
1239: fa_debug_pkg.add('calculate_balances',
1240: 'Getting deferred deprn reserve balances',
1241: 'start');
1242: end if;
1243:

Line 1271: fa_debug_pkg.add('calculate_balances',

1267: END LOOP;
1268: CLOSE def_rsv_balances;
1269:
1270: if (g_print_debug) then
1271: fa_debug_pkg.add('calculate_balances',
1272: 'Getting deferred deprn reserve balances',
1273: 'success');
1274: end if;
1275:

Line 1329: fa_debug_pkg.add('calculate_balances',

1325: GROUP BY
1326: dd.deferred_deprn_expense_ccid;
1327: BEGIN
1328: if (g_print_debug) then
1329: fa_debug_pkg.add('calculate_balances',
1330: 'Getting deferred deprn exp balances',
1331: 'start');
1332: end if;
1333:

Line 1361: fa_debug_pkg.add('calculate_balances',

1357: END LOOP;
1358: CLOSE def_exp_balances;
1359:
1360: if (g_print_debug) then
1361: fa_debug_pkg.add('calculate_balances',
1362: 'Getting deferred deprn exp balances',
1363: 'success');
1364: end if;
1365:

Line 1446: fa_debug_pkg.add('calculate_balances',

1442: coa_exception EXCEPTION;
1443: seginfo_exception EXCEPTION;
1444: BEGIN
1445: if (g_print_debug) then
1446: fa_debug_pkg.add('calculate_balances',
1447: 'Getting chart of accounts info',
1448: 'start');
1449: end if;
1450:

Line 1509: fa_debug_pkg.add('calculate_balances',

1505: G_flex_buf := G_flex_buf || l_appcol_name || ', ';
1506: END LOOP;
1507:
1508: if (g_print_debug) then
1509: fa_debug_pkg.add('calculate_balances',
1510: 'Getting chart of accounts info',
1511: 'success');
1512: end if;
1513:

Line 1690: fa_debug_pkg.add('calculate_balances',

1686: buf10 VARCHAR2(255);
1687:
1688: BEGIN
1689: if (g_print_debug) then
1690: fa_debug_pkg.add('calculate_balances',
1691: 'Inserting retained earnings in GL_INTERFACE',
1692: 'start');
1693: end if;
1694:

Line 1812: fa_debug_pkg.add('insert_ret_earnings',

1808: -- OPEN the insert cursor
1809: insert_cursor := dbms_sql.open_cursor;
1810:
1811: if (g_print_debug) then
1812: fa_debug_pkg.add('insert_ret_earnings',
1813: 'Open cursor',
1814: 'success');
1815: end if;
1816: -- parse the insert smt

Line 1820: fa_debug_pkg.add('insert_ret_earnings',

1816: -- parse the insert smt
1817: dbms_sql.parse(insert_cursor, G_insert_buf, dbms_sql.v7);
1818:
1819: if (g_print_debug) then
1820: fa_debug_pkg.add('insert_ret_earnings',
1821: 'Parse cursor',
1822: 'success');
1823: end if;
1824:

Line 1842: fa_debug_pkg.add('insert_ret_earnings',

1838:
1839: l_row_count := dbms_sql.execute(insert_cursor);
1840:
1841: if (g_print_debug) then
1842: fa_debug_pkg.add('insert_ret_earnings',
1843: 'Number of retained earnings rows inserted',
1844: l_row_count);
1845: end if;
1846: dbms_sql.close_cursor(insert_cursor);

Line 1849: fa_debug_pkg.add('calculate_balances',

1845: end if;
1846: dbms_sql.close_cursor(insert_cursor);
1847:
1848: if (g_print_debug) then
1849: fa_debug_pkg.add('calculate_balances',
1850: 'Inserting retained earnings in GL_INTERFACE',
1851: 'success');
1852: end if;
1853: EXCEPTION

Line 1872: fa_debug_pkg.add('calculate_balances',

1868: ************************************************************************ */
1869:
1870: BEGIN
1871: if (g_print_debug) then
1872: fa_debug_pkg.add('calculate_balances',
1873: 'Inserting account balances in GL_INTERFACE',
1874: 'start');
1875: end if;
1876:

Line 1970: fa_debug_pkg.add('calculate_balances',

1966: def_deprn_exp_ccids(i).ccid);
1967: END LOOP;
1968:
1969: if (g_print_debug) then
1970: fa_debug_pkg.add('calculate_balances',
1971: 'Inserting account balances in GL_INTERFACE',
1972: 'success');
1973: end if;
1974: EXCEPTION