DBA Data[Home] [Help]

APPS.FA_MC_UPG1_PKG dependencies on FA_DEBUG_PKG

Line 53: fa_debug_pkg.add('create_drop_indexes','mode',

49: out_industry, out_oracle_schema);
50:
51: IF (p_mode = 'D') THEN
52: if (g_print_debug) then
53: fa_debug_pkg.add('create_drop_indexes','mode',
54: 'Dropping');
55: end if;
56:
57: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 149: fa_debug_pkg.add('create_drop_indexes','mode',

145: ELSIF (p_mode = 'C') then
146: -- create all the indexes
147:
148: if (g_print_debug) then
149: fa_debug_pkg.add('create_drop_indexes','mode',
150: 'Creating');
151: end if;
152:
153: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 424: fa_debug_pkg.add('validate_setup','reporting sobid',

420: RAISE lock_error;
421: END IF;
422:
423: if (g_print_debug) then
424: fa_debug_pkg.add('validate_setup','reporting sobid',
425: X_rsob_id);
426: fa_debug_pkg.add('validate_setup','primary sobid',
427: X_psob_id);
428: fa_debug_pkg.add('validate_setup','to currency',

Line 426: fa_debug_pkg.add('validate_setup','primary sobid',

422:
423: if (g_print_debug) then
424: fa_debug_pkg.add('validate_setup','reporting sobid',
425: X_rsob_id);
426: fa_debug_pkg.add('validate_setup','primary sobid',
427: X_psob_id);
428: fa_debug_pkg.add('validate_setup','to currency',
429: X_to_currency);
430: fa_debug_pkg.add('validate_setup','from currency',

Line 428: fa_debug_pkg.add('validate_setup','to currency',

424: fa_debug_pkg.add('validate_setup','reporting sobid',
425: X_rsob_id);
426: fa_debug_pkg.add('validate_setup','primary sobid',
427: X_psob_id);
428: fa_debug_pkg.add('validate_setup','to currency',
429: X_to_currency);
430: fa_debug_pkg.add('validate_setup','from currency',
431: X_from_currency);
432: fa_debug_pkg.add('validate_setup','mrc converted',

Line 430: fa_debug_pkg.add('validate_setup','from currency',

426: fa_debug_pkg.add('validate_setup','primary sobid',
427: X_psob_id);
428: fa_debug_pkg.add('validate_setup','to currency',
429: X_to_currency);
430: fa_debug_pkg.add('validate_setup','from currency',
431: X_from_currency);
432: fa_debug_pkg.add('validate_setup','mrc converted',
433: l_mrc_converted_flag);
434: end if;

Line 432: fa_debug_pkg.add('validate_setup','mrc converted',

428: fa_debug_pkg.add('validate_setup','to currency',
429: X_to_currency);
430: fa_debug_pkg.add('validate_setup','from currency',
431: X_from_currency);
432: fa_debug_pkg.add('validate_setup','mrc converted',
433: l_mrc_converted_flag);
434: end if;
435:
436: EXCEPTION

Line 746: fa_debug_pkg.add('get_conversion_info','checking fa gl periods',

742: END IF;
743: CLOSE check_first_mrc_period;
744:
745: if (g_print_debug) then
746: fa_debug_pkg.add('get_conversion_info','checking fa gl periods',
747: 'check_fa_gl_periods');
748: end if;
749:
750: select ct.NUMBER_PER_FISCAL_YEAR

Line 808: fa_debug_pkg.add('get_conversion_info','l_first_mrc_period',

804:
805: end if;
806:
807: if (g_print_debug) then
808: fa_debug_pkg.add('get_conversion_info','l_first_mrc_period',
809: l_first_mrc_period);
810: fa_debug_pkg.add('get_conversion_info','l_prior_fa_period',
811: l_prior_fa_period );
812: fa_debug_pkg.add('get_conversion_info','start_fy', l_start_fy);

Line 810: fa_debug_pkg.add('get_conversion_info','l_prior_fa_period',

806:
807: if (g_print_debug) then
808: fa_debug_pkg.add('get_conversion_info','l_first_mrc_period',
809: l_first_mrc_period);
810: fa_debug_pkg.add('get_conversion_info','l_prior_fa_period',
811: l_prior_fa_period );
812: fa_debug_pkg.add('get_conversion_info','start_fy', l_start_fy);
813: fa_debug_pkg.add('get_conversion_info','X_start_pc',X_start_pc);
814: fa_debug_pkg.add('get_conversion_info','X_end_pc', X_end_pc);

Line 812: fa_debug_pkg.add('get_conversion_info','start_fy', l_start_fy);

808: fa_debug_pkg.add('get_conversion_info','l_first_mrc_period',
809: l_first_mrc_period);
810: fa_debug_pkg.add('get_conversion_info','l_prior_fa_period',
811: l_prior_fa_period );
812: fa_debug_pkg.add('get_conversion_info','start_fy', l_start_fy);
813: fa_debug_pkg.add('get_conversion_info','X_start_pc',X_start_pc);
814: fa_debug_pkg.add('get_conversion_info','X_end_pc', X_end_pc);
815: end if;
816:

Line 813: fa_debug_pkg.add('get_conversion_info','X_start_pc',X_start_pc);

809: l_first_mrc_period);
810: fa_debug_pkg.add('get_conversion_info','l_prior_fa_period',
811: l_prior_fa_period );
812: fa_debug_pkg.add('get_conversion_info','start_fy', l_start_fy);
813: fa_debug_pkg.add('get_conversion_info','X_start_pc',X_start_pc);
814: fa_debug_pkg.add('get_conversion_info','X_end_pc', X_end_pc);
815: end if;
816:
817: EXCEPTION

Line 814: fa_debug_pkg.add('get_conversion_info','X_end_pc', X_end_pc);

810: fa_debug_pkg.add('get_conversion_info','l_prior_fa_period',
811: l_prior_fa_period );
812: fa_debug_pkg.add('get_conversion_info','start_fy', l_start_fy);
813: fa_debug_pkg.add('get_conversion_info','X_start_pc',X_start_pc);
814: fa_debug_pkg.add('get_conversion_info','X_end_pc', X_end_pc);
815: end if;
816:
817: EXCEPTION
818: WHEN conversion_info_error THEN

Line 1289: fa_debug_pkg.add('get_rate_info','fixed relation',

1285: X_numerator_rate,
1286: X_rate);
1287: -- debug messages
1288: if (g_print_debug) then
1289: fa_debug_pkg.add('get_rate_info','fixed relation',
1290: l_fixed_rate);
1291: fa_debug_pkg.add('get_rate_info','relation',
1292: X_relation);
1293: fa_debug_pkg.add('get_rate_info','denominator_rate',

Line 1291: fa_debug_pkg.add('get_rate_info','relation',

1287: -- debug messages
1288: if (g_print_debug) then
1289: fa_debug_pkg.add('get_rate_info','fixed relation',
1290: l_fixed_rate);
1291: fa_debug_pkg.add('get_rate_info','relation',
1292: X_relation);
1293: fa_debug_pkg.add('get_rate_info','denominator_rate',
1294: X_denominator_rate);
1295: fa_debug_pkg.add('get_rate_info','numerator_rate',

Line 1293: fa_debug_pkg.add('get_rate_info','denominator_rate',

1289: fa_debug_pkg.add('get_rate_info','fixed relation',
1290: l_fixed_rate);
1291: fa_debug_pkg.add('get_rate_info','relation',
1292: X_relation);
1293: fa_debug_pkg.add('get_rate_info','denominator_rate',
1294: X_denominator_rate);
1295: fa_debug_pkg.add('get_rate_info','numerator_rate',
1296: X_numerator_rate);
1297: fa_debug_pkg.add('get_rate_info','exchange rate', X_rate);

Line 1295: fa_debug_pkg.add('get_rate_info','numerator_rate',

1291: fa_debug_pkg.add('get_rate_info','relation',
1292: X_relation);
1293: fa_debug_pkg.add('get_rate_info','denominator_rate',
1294: X_denominator_rate);
1295: fa_debug_pkg.add('get_rate_info','numerator_rate',
1296: X_numerator_rate);
1297: fa_debug_pkg.add('get_rate_info','exchange rate', X_rate);
1298: end if;
1299:

Line 1297: fa_debug_pkg.add('get_rate_info','exchange rate', X_rate);

1293: fa_debug_pkg.add('get_rate_info','denominator_rate',
1294: X_denominator_rate);
1295: fa_debug_pkg.add('get_rate_info','numerator_rate',
1296: X_numerator_rate);
1297: fa_debug_pkg.add('get_rate_info','exchange rate', X_rate);
1298: end if;
1299:
1300: EXCEPTION
1301: WHEN OTHERS THEN

Line 1683: fa_debug_pkg.add('convert_assets',

1679: l_assets_processed := 0;
1680: l_commit_size := 0;
1681:
1682: if (g_print_debug) then
1683: fa_debug_pkg.add('convert_assets',
1684: 'Number of assets with DEPRN in current fy',
1685: l_deprn_assets);
1686: fa_debug_pkg.add('convert_assets',
1687: 'Number of assets with no DEPRN in current fy',

Line 1686: fa_debug_pkg.add('convert_assets',

1682: if (g_print_debug) then
1683: fa_debug_pkg.add('convert_assets',
1684: 'Number of assets with DEPRN in current fy',
1685: l_deprn_assets);
1686: fa_debug_pkg.add('convert_assets',
1687: 'Number of assets with no DEPRN in current fy',
1688: l_no_deprn_assets);
1689: fa_debug_pkg.add('convert_assets',
1690: 'Number of assets already converted',

Line 1689: fa_debug_pkg.add('convert_assets',

1685: l_deprn_assets);
1686: fa_debug_pkg.add('convert_assets',
1687: 'Number of assets with no DEPRN in current fy',
1688: l_no_deprn_assets);
1689: fa_debug_pkg.add('convert_assets',
1690: 'Number of assets already converted',
1691: l_converted_assets);
1692: fa_debug_pkg.add('convert_assets',
1693: 'Number of assets to convert in this run',

Line 1692: fa_debug_pkg.add('convert_assets',

1688: l_no_deprn_assets);
1689: fa_debug_pkg.add('convert_assets',
1690: 'Number of assets already converted',
1691: l_converted_assets);
1692: fa_debug_pkg.add('convert_assets',
1693: 'Number of assets to convert in this run',
1694: l_assets_to_convert);
1695: fa_debug_pkg.add('convert_assets',
1696: 'Total number of assets to convert',

Line 1695: fa_debug_pkg.add('convert_assets',

1691: l_converted_assets);
1692: fa_debug_pkg.add('convert_assets',
1693: 'Number of assets to convert in this run',
1694: l_assets_to_convert);
1695: fa_debug_pkg.add('convert_assets',
1696: 'Total number of assets to convert',
1697: l_total_assets);
1698: end if;
1699:

Line 1734: fa_debug_pkg.add('convert_assets',

1730: l_convert_order := 'L';
1731: END IF;
1732:
1733: if (g_print_debug) then
1734: fa_debug_pkg.add('convert_assets',
1735: 'Number of assets selected in this iteration',
1736: l_commit_size);
1737: fa_debug_pkg.add('convert_assets',
1738: 'Converting assets with status',

Line 1737: fa_debug_pkg.add('convert_assets',

1733: if (g_print_debug) then
1734: fa_debug_pkg.add('convert_assets',
1735: 'Number of assets selected in this iteration',
1736: l_commit_size);
1737: fa_debug_pkg.add('convert_assets',
1738: 'Converting assets with status',
1739: l_convert_order);
1740: end if;
1741:

Line 1835: fa_debug_pkg.add('convert_assets',

1831: token1 => 'NUMBER',
1832: value1 => to_char(l_assets_processed));
1833:
1834: if (g_print_debug) then
1835: fa_debug_pkg.add('convert_assets',
1836: 'number of assets processed in this run',
1837: l_assets_processed);
1838: end if;
1839:

Line 1860: fa_debug_pkg.add('convert_assets',

1856: p_fixed_conversion,
1857: 'C');
1858:
1859: if (g_print_debug) then
1860: fa_debug_pkg.add('convert_assets',
1861: 'All assets converted for reporting book',
1862: l_total_assets);
1863: end if;
1864:

Line 1987: FA_DEBUG_PKG.Get_Debug_Messages(

1983: dbms_output.put_line('*************************');
1984: */
1985:
1986: while mesg_more loop
1987: FA_DEBUG_PKG.Get_Debug_Messages(
1988: mesg1,mesg2,mesg3,mesg4,mesg5,mesg6,mesg7,
1989: mesg8,mesg9,mesg10,
1990: mesg_more);
1991: