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 420: fa_debug_pkg.add('calculate_balances',

416: l_found BOOLEAN;
417: l_index NUMBER;
418: BEGIN
419: if (g_print_debug) then
420: fa_debug_pkg.add('calculate_balances',
421: 'Getting Balances from FA_ADJUSTMENTS',
422: 'start');
423: end if;
424:

Line 491: fa_debug_pkg.add('calculate_balances',

487: END LOOP;
488: CLOSE adj_bal;
489:
490: if (g_print_debug) then
491: fa_debug_pkg.add('calculate_balances',
492: 'Getting Balances from FA_ADJUSTMENTS',
493: 'success');
494: end if;
495:

Line 608: fa_debug_pkg.add('calculate_balances',

604: dd.distribution_id = mdd.distribution_id;
605:
606: BEGIN
607: if (g_print_debug) then
608: fa_debug_pkg.add('calculate_balances',
609: 'Getting deprn reserve from balances',
610: 'start');
611: end if;
612:

Line 739: fa_debug_pkg.add('calculate_balances',

735: end LOOP;
736: CLOSE get_periods;
737:
738: if (g_print_debug) then
739: fa_debug_pkg.add('calculate_balances',
740: 'Getting deprn reserve balances',
741: 'success');
742: end if;
743:

Line 768: fa_debug_pkg.add('get_deprn_reserve_balances',

764:
765: EXCEPTION
766: WHEN invalid_ccid THEN
767: if (g_print_debug) then
768: fa_debug_pkg.add('get_deprn_reserve_balances',
769: 'Error Getting reserve ccid ',
770: 'failure');
771: end if;
772:

Line 779: fa_debug_pkg.add('get_deprn_reserve_balances',

775: app_exception.raise_exception;
776:
777: WHEN reserve_error THEN
778: if (g_print_debug) then
779: fa_debug_pkg.add('get_deprn_reserve_balances',
780: 'Error Getting reserve for period ',
781: l_pc);
782: fa_debug_pkg.add('get_deprn_reserve_balances',
783: 'Error Getting reserve for line num ',

Line 782: fa_debug_pkg.add('get_deprn_reserve_balances',

778: if (g_print_debug) then
779: fa_debug_pkg.add('get_deprn_reserve_balances',
780: 'Error Getting reserve for period ',
781: l_pc);
782: fa_debug_pkg.add('get_deprn_reserve_balances',
783: 'Error Getting reserve for line num ',
784: l_line_num);
785: end if;
786: fa_srvr_msg.add_sql_error (

Line 857: fa_debug_pkg.add('calculate_balances',

853: mdd.distribution_id = dd.distribution_id;
854:
855: BEGIN
856: if (g_print_debug) then
857: fa_debug_pkg.add('calculate_balances',
858: 'Getting deprn expense balances',
859: 'start');
860: end if;
861:

Line 921: fa_debug_pkg.add('calculate_balances',

917: CLOSE exp_line_num;
918: END LOOP;
919:
920: if (g_print_debug) then
921: fa_debug_pkg.add('calculate_balances',
922: 'Getting deprn expense balances',
923: 'success');
924: end if;
925:

Line 1005: fa_debug_pkg.add('calculate_balances',

1001: aj.code_combination_id;
1002:
1003: BEGIN
1004: if (g_print_debug) then
1005: fa_debug_pkg.add('calculate_balances',
1006: 'Getting reval reserve balances',
1007: 'start');
1008: end if;
1009:

Line 1058: fa_debug_pkg.add('calculate_balances',

1054: END LOOP;
1055: CLOSE reval_rsv_bal;
1056:
1057: if (g_print_debug) then
1058: fa_debug_pkg.add('calculate_balances',
1059: 'Getting reval reserve balances',
1060: 'success');
1061: end if;
1062:

Line 1136: fa_debug_pkg.add('calculate_balances',

1132: mdd.distribution_id = dd.distribution_id;
1133:
1134: BEGIN
1135: if (g_print_debug) then
1136: fa_debug_pkg.add('calculate_balances',
1137: 'Getting reval amort balances',
1138: 'start');
1139: end if;
1140:

Line 1190: fa_debug_pkg.add('calculate_balances',

1186: CLOSE amort_line_num;
1187: END LOOP;
1188:
1189: if (g_print_debug) then
1190: fa_debug_pkg.add('calculate_balances',
1191: 'Getting reval amort balances',
1192: 'success');
1193: end if;
1194:

Line 1248: fa_debug_pkg.add('calculate_balances',

1244: GROUP BY
1245: dd.deferred_deprn_reserve_ccid;
1246: BEGIN
1247: if (g_print_debug) then
1248: fa_debug_pkg.add('calculate_balances',
1249: 'Getting deferred deprn reserve balances',
1250: 'start');
1251: end if;
1252:

Line 1280: fa_debug_pkg.add('calculate_balances',

1276: END LOOP;
1277: CLOSE def_rsv_balances;
1278:
1279: if (g_print_debug) then
1280: fa_debug_pkg.add('calculate_balances',
1281: 'Getting deferred deprn reserve balances',
1282: 'success');
1283: end if;
1284:

Line 1338: fa_debug_pkg.add('calculate_balances',

1334: GROUP BY
1335: dd.deferred_deprn_expense_ccid;
1336: BEGIN
1337: if (g_print_debug) then
1338: fa_debug_pkg.add('calculate_balances',
1339: 'Getting deferred deprn exp balances',
1340: 'start');
1341: end if;
1342:

Line 1370: fa_debug_pkg.add('calculate_balances',

1366: END LOOP;
1367: CLOSE def_exp_balances;
1368:
1369: if (g_print_debug) then
1370: fa_debug_pkg.add('calculate_balances',
1371: 'Getting deferred deprn exp balances',
1372: 'success');
1373: end if;
1374:

Line 1455: fa_debug_pkg.add('calculate_balances',

1451: coa_exception EXCEPTION;
1452: seginfo_exception EXCEPTION;
1453: BEGIN
1454: if (g_print_debug) then
1455: fa_debug_pkg.add('calculate_balances',
1456: 'Getting chart of accounts info',
1457: 'start');
1458: end if;
1459:

Line 1518: fa_debug_pkg.add('calculate_balances',

1514: G_flex_buf := G_flex_buf || l_appcol_name || ', ';
1515: END LOOP;
1516:
1517: if (g_print_debug) then
1518: fa_debug_pkg.add('calculate_balances',
1519: 'Getting chart of accounts info',
1520: 'success');
1521: end if;
1522:

Line 1699: fa_debug_pkg.add('calculate_balances',

1695: buf10 VARCHAR2(255);
1696:
1697: BEGIN
1698: if (g_print_debug) then
1699: fa_debug_pkg.add('calculate_balances',
1700: 'Inserting retained earnings in GL_INTERFACE',
1701: 'start');
1702: end if;
1703:

Line 1821: fa_debug_pkg.add('insert_ret_earnings',

1817: -- OPEN the insert cursor
1818: insert_cursor := dbms_sql.open_cursor;
1819:
1820: if (g_print_debug) then
1821: fa_debug_pkg.add('insert_ret_earnings',
1822: 'Open cursor',
1823: 'success');
1824: end if;
1825: -- parse the insert smt

Line 1829: fa_debug_pkg.add('insert_ret_earnings',

1825: -- parse the insert smt
1826: dbms_sql.parse(insert_cursor, G_insert_buf, dbms_sql.v7);
1827:
1828: if (g_print_debug) then
1829: fa_debug_pkg.add('insert_ret_earnings',
1830: 'Parse cursor',
1831: 'success');
1832: end if;
1833:

Line 1851: fa_debug_pkg.add('insert_ret_earnings',

1847:
1848: l_row_count := dbms_sql.execute(insert_cursor);
1849:
1850: if (g_print_debug) then
1851: fa_debug_pkg.add('insert_ret_earnings',
1852: 'Number of retained earnings rows inserted',
1853: l_row_count);
1854: end if;
1855: dbms_sql.close_cursor(insert_cursor);

Line 1858: fa_debug_pkg.add('calculate_balances',

1854: end if;
1855: dbms_sql.close_cursor(insert_cursor);
1856:
1857: if (g_print_debug) then
1858: fa_debug_pkg.add('calculate_balances',
1859: 'Inserting retained earnings in GL_INTERFACE',
1860: 'success');
1861: end if;
1862: EXCEPTION

Line 1881: fa_debug_pkg.add('calculate_balances',

1877: ************************************************************************ */
1878:
1879: BEGIN
1880: if (g_print_debug) then
1881: fa_debug_pkg.add('calculate_balances',
1882: 'Inserting account balances in GL_INTERFACE',
1883: 'start');
1884: end if;
1885:

Line 1979: fa_debug_pkg.add('calculate_balances',

1975: def_deprn_exp_ccids(i).ccid);
1976: END LOOP;
1977:
1978: if (g_print_debug) then
1979: fa_debug_pkg.add('calculate_balances',
1980: 'Inserting account balances in GL_INTERFACE',
1981: 'success');
1982: end if;
1983: EXCEPTION