eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_MC_UPG1_PKG dependencies on FA_MC_UPG1_PKG

Line 1: PACKAGE BODY FA_MC_UPG1_PKG AS

1: PACKAGE BODY FA_MC_UPG1_PKG AS
2: /* $Header: faxmcu1b.pls 120.7 2009/03/27 21:20:25 bridgway ship $ */
3:
4: -- commit size to control number assets to process in loop
5: G_Max_Commit_Size CONSTANT NUMBER := 1000;

Line 35: calling_fn => 'fa_mc_upg1_pkg.lock_book');

31: return(TRUE);
32: EXCEPTION
33: WHEN OTHERS THEN
34: fa_srvr_msg.add_sql_error (
35: calling_fn => 'fa_mc_upg1_pkg.lock_book');
36: return(FALSE);
37: END lock_book;
38:
39:

Line 341: calling_fn => 'fa_mc_upg1_pkg.create_drop_indexes');

337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: fa_srvr_msg.add_sql_error (
341: calling_fn => 'fa_mc_upg1_pkg.create_drop_indexes');
342: END create_drop_indexes;
343:
344:
345: PROCEDURE validate_setup(

Line 439: calling_fn => 'fa_mc_upg1_pkg.validate_setup',

435:
436: EXCEPTION
437: WHEN mc_source_error THEN
438: fa_srvr_msg.add_message (
439: calling_fn => 'fa_mc_upg1_pkg.validate_setup',
440: name => 'FA_MRC_NOT_SOURCE',
441: token1 => 'BOOK',
442: value1 => p_book_type_code);
443:

Line 448: calling_fn => 'fa_mc_upg1_pkg.validate_setup',

444: app_exception.raise_exception;
445:
446: WHEN rbook_setup_error THEN
447: fa_srvr_msg.add_message (
448: calling_fn => 'fa_mc_upg1_pkg.validate_setup',
449: name => 'FA_MRC_BOOK_NOT_ASSOCIATED',
450: token1 => 'REPORTING_BOOK',
451: value1 => G_rbook_name,
452: token2 => 'BOOK',

Line 458: calling_fn => 'fa_mc_upg1_pkg.validate_setup',

454: app_exception.raise_exception;
455:
456: WHEN rbook_converted_error THEN
457: fa_srvr_msg.add_message (
458: calling_fn => 'fa_mc_upg1_pkg.validate_setup',
459: name => 'FA_MRC_BOOK_CONVERTED',
460: token1 => 'REPORTING_BOOK',
461: value1 => G_rbook_name,
462: token2 => 'BOOK',

Line 468: calling_fn => 'fa_mc_upg1_pkg.validate_setup',

464: app_exception.raise_exception;
465:
466: WHEN rbook_disabled_error THEN
467: fa_srvr_msg.add_message (
468: calling_fn => 'fa_mc_upg1_pkg.validate_setup',
469: name => 'FA_MRC_BOOK_DISABLED',
470: token1 => 'REPORTING_BOOK',
471: value1 => G_rbook_name,
472: token2 => 'BOOK',

Line 478: calling_fn => 'fa_mc_upg1_pkg.lock_book');

474: app_exception.raise_exception;
475:
476: WHEN lock_error THEN
477: fa_srvr_msg.add_sql_error (
478: calling_fn => 'fa_mc_upg1_pkg.lock_book');
479: app_exception.raise_exception;
480:
481: WHEN OTHERS THEN
482: fa_srvr_msg.add_sql_error(

Line 483: calling_fn => 'fa_mc_upg1_pkg.validate_setup');

479: app_exception.raise_exception;
480:
481: WHEN OTHERS THEN
482: fa_srvr_msg.add_sql_error(
483: calling_fn => 'fa_mc_upg1_pkg.validate_setup');
484: app_exception.raise_exception;
485:
486: END validate_setup;
487:

Line 563: calling_fn => 'fa_mc_upg1_pkg.validate_rate',

559: EXCEPTION
560:
561: WHEN fixed_rate_error THEN
562: fa_srvr_msg.add_message (
563: calling_fn => 'fa_mc_upg1_pkg.validate_rate',
564: name => 'FA_MRC_NOT_FIXED_RATE');
565: app_exception.raise_exception;
566:
567: WHEN conversion_basis_error THEN

Line 569: calling_fn => 'fa_mc_upg1_pkg.validate_rate',

565: app_exception.raise_exception;
566:
567: WHEN conversion_basis_error THEN
568: fa_srvr_msg.add_message (
569: calling_fn => 'fa_mc_upg1_pkg.validate_rate',
570: name => 'FA_MRC_NO_BASIS');
571: app_exception.raise_exception;
572:
573: WHEN OTHERS THEN

Line 575: calling_fn => 'fa_mc_upg1_pkg.validate_rate');

571: app_exception.raise_exception;
572:
573: WHEN OTHERS THEN
574: fa_srvr_msg.add_sql_error(
575: calling_fn => 'fa_mc_upg1_pkg.validate_rate');
576: app_exception.raise_exception;
577:
578: END validate_rate;
579:

Line 820: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info',

816:
817: EXCEPTION
818: WHEN conversion_info_error THEN
819: fa_srvr_msg.add_message (
820: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info',
821: name => 'FA_MRC_CONV_INFO_ERROR',
822: token1 => 'REPORTING_BOOK',
823: value1 => G_rbook_name);
824: app_exception.raise_exception;

Line 828: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info',

824: app_exception.raise_exception;
825:
826: WHEN first_mrc_period_error THEN
827: fa_srvr_msg.add_message (
828: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info',
829: name => 'FA_MRC_NOT_FIRST_FUTURE',
830: token1 => 'FIRST_MRC_PERIOD',
831: value1 => l_first_mrc_period);
832: app_exception.raise_exception;

Line 836: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info',

832: app_exception.raise_exception;
833:
834: WHEN prev_period_error THEN
835: fa_srvr_msg.add_message (
836: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info',
837: name => 'FA_MRC_PREV_PERIOD_ERR',
838: token1 => 'FIRST_MRC_PERIOD',
839: value1 => l_first_mrc_period);
840: app_exception.raise_exception;

Line 844: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info',

840: app_exception.raise_exception;
841:
842: WHEN period_info_error THEN
843: fa_srvr_msg.add_message (
844: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info',
845: name => 'FA_SHARED_SEL_DEPRN_PERIODS');
846: app_exception.raise_exception;
847:
848: WHEN OTHERS THEN

Line 850: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info');

846: app_exception.raise_exception;
847:
848: WHEN OTHERS THEN
849: fa_srvr_msg.add_sql_error (
850: calling_fn => 'fa_mc_upg1_pkg.get_conversion_info');
851: app_exception.raise_exception;
852:
853: END get_conversion_info;
854:

Line 975: calling_fn => 'fa_mc_upg1_pkg.set_conversion_status');

971:
972: EXCEPTION
973: WHEN OTHERS THEN
974: fa_srvr_msg.add_sql_error (
975: calling_fn => 'fa_mc_upg1_pkg.set_conversion_status');
976: app_exception.raise_exception;
977:
978: END set_conversion_status;
979:

Line 1181: calling_fn => 'fa_mc_upg1_pkg.get_candidate_assets');

1177: p_end_pc,
1178: NULL,
1179: 'SE');
1180: fa_srvr_msg.add_sql_error (
1181: calling_fn => 'fa_mc_upg1_pkg.get_candidate_assets');
1182: app_exception.raise_exception;
1183:
1184: WHEN OTHERS THEN
1185: FND_CONCURRENT.AF_ROLLBACK ;

Line 1194: calling_fn => 'fa_mc_upg1_pkg.get_candidate_assets');

1190: p_end_pc,
1191: NULL,
1192: 'SE');
1193: fa_srvr_msg.add_sql_error (
1194: calling_fn => 'fa_mc_upg1_pkg.get_candidate_assets');
1195: app_exception.raise_exception;
1196:
1197: END get_candidate_assets;
1198:

Line 1233: calling_fn => 'fa_mc_upg1_pkg.get_currency_precision');

1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: fa_srvr_msg.add_sql_error (
1233: calling_fn => 'fa_mc_upg1_pkg.get_currency_precision');
1234: app_exception.raise_exception;
1235:
1236: END get_currency_precision;
1237:

Line 1303: calling_fn => 'fa_mc_upg1_pkg.get_rate_info',

1299:
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: fa_srvr_msg.add_message (
1303: calling_fn => 'fa_mc_upg1_pkg.get_rate_info',
1304: name => 'FA_MRC_CONV_RATE_ERR',
1305: token1 => 'REPORTING_BOOK',
1306: value1 => G_rbook_name);
1307: fa_srvr_msg.add_sql_error (

Line 1308: calling_fn => 'fa_mc_upg1_pkg.get_rate_info');

1304: name => 'FA_MRC_CONV_RATE_ERR',
1305: token1 => 'REPORTING_BOOK',
1306: value1 => G_rbook_name);
1307: fa_srvr_msg.add_sql_error (
1308: calling_fn => 'fa_mc_upg1_pkg.get_rate_info');
1309: app_exception.raise_exception;
1310:
1311: END get_rate_info;
1312:

Line 1372: calling_fn => 'fa_mc_upg1_pkg.check_preview_status',

1368:
1369: EXCEPTION
1370: WHEN invalid_select THEN
1371: fa_srvr_msg.add_message (
1372: calling_fn => 'fa_mc_upg1_pkg.check_preview_status',
1373: name => 'FA_MRC_INVALID_SELECT',
1374: token1 => 'BOOK',
1375: value1 => p_book_type_code,
1376: token2 => 'REPORTING_BOOK',

Line 1382: calling_fn => 'fa_mc_upg1_pkg.check_preview_status',

1378: app_exception.raise_exception;
1379:
1380: WHEN in_process THEN
1381: fa_srvr_msg.add_message (
1382: calling_fn => 'fa_mc_upg1_pkg.check_preview_status',
1383: name => 'FA_MRC_CONV_RUNNING',
1384: token1 => 'BOOK',
1385: value1 => p_book_type_code,
1386: token2 => 'REPORTING_BOOK',

Line 1392: calling_fn => 'fa_mc_upg1_pkg.check_preview_status',

1388: app_exception.raise_exception;
1389:
1390: WHEN no_select THEN
1391: fa_srvr_msg.add_message (
1392: calling_fn => 'fa_mc_upg1_pkg.check_preview_status',
1393: name => 'FA_MRC_NO_SELECT',
1394: token1 => 'BOOK',
1395: value1 => p_book_type_code,
1396: token2 => 'REPORTING_BOOK',

Line 1402: calling_fn => 'fa_mc_upg1_pkg.check_preview_status');

1398: app_exception.raise_exception;
1399:
1400: WHEN OTHERS THEN
1401: fa_srvr_msg.add_sql_error (
1402: calling_fn => 'fa_mc_upg1_pkg.check_preview_status');
1403: app_exception.raise_exception;
1404:
1405: END check_preview_status;
1406:

Line 1455: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>validate_setup');

1451: exception
1452:
1453: when others then
1454: fa_srvr_msg.add_sql_error (
1455: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>validate_setup');
1456: app_exception.raise_exception;
1457:
1458: end;
1459:

Line 1477: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>get_conversion_info');

1473: exception
1474:
1475: when others then
1476: fa_srvr_msg.add_sql_error (
1477: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>get_conversion_info');
1478: app_exception.raise_exception;
1479:
1480: end;
1481:

Line 1500: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>get_rate_info');

1496: exception
1497:
1498: when others then
1499: fa_srvr_msg.add_sql_error (
1500: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>get_rate_info');
1501: app_exception.raise_exception;
1502:
1503: end;
1504:

Line 1516: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>get_currency_precision');

1512: exception
1513:
1514: when others then
1515: fa_srvr_msg.add_sql_error (
1516: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>get_currency_precision');
1517: app_exception.raise_exception;
1518:
1519: end;
1520:

Line 1533: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>check_preview_status');

1529: exception
1530:
1531: when others then
1532: fa_srvr_msg.add_sql_error (
1533: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>check_preview_status');
1534: app_exception.raise_exception;
1535:
1536: end;
1537:

Line 1551: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>validate_rate');

1547: exception
1548:
1549: when others then
1550: fa_srvr_msg.add_sql_error (
1551: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>validate_rate');
1552: app_exception.raise_exception;
1553:
1554: end;
1555:

Line 1571: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>set_conversion_status');

1567: exception
1568:
1569: when others then
1570: fa_srvr_msg.add_sql_error (
1571: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>set_conversion_status');
1572: app_exception.raise_exception;
1573:
1574: end;
1575:

Line 1593: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>convert_assets');

1589: exception
1590:
1591: when others then
1592: fa_srvr_msg.add_sql_error (
1593: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book=>convert_assets');
1594: app_exception.raise_exception;
1595:
1596: end;
1597:

Line 1601: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book');

1597:
1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: fa_srvr_msg.add_sql_error (
1601: calling_fn => 'fa_mc_upg1_pkg.convert_reporting_book');
1602: app_exception.raise_exception;
1603: END convert_reporting_book;
1604:
1605:

Line 1829: calling_fn => 'fa_mc_upg1_pkg.convert_assets',

1825:
1826: END LOOP; -- while LOOP
1827:
1828: fa_srvr_msg.add_message(
1829: calling_fn => 'fa_mc_upg1_pkg.convert_assets',
1830: name => 'FA_SHARED_NUMBER_PROCESSED',
1831: token1 => 'NUMBER',
1832: value1 => to_char(l_assets_processed));
1833:

Line 1891: calling_fn => 'fa_mc_upg1_pkg.convert_assets',

1887: p_end_pc,
1888: p_fixed_conversion,
1889: 'RE');
1890: fa_srvr_msg.add_message(
1891: calling_fn => 'fa_mc_upg1_pkg.convert_assets',
1892: name => 'FA_SHARED_NUMBER_PROCESSED',
1893: token1 => 'NUMBER',
1894: value1 => to_char(l_assets_processed));
1895:

Line 1897: calling_fn => 'fa_mc_upg1_pkg.convert_assets');

1893: token1 => 'NUMBER',
1894: value1 => to_char(l_assets_processed));
1895:
1896: fa_srvr_msg.add_sql_error (
1897: calling_fn => 'fa_mc_upg1_pkg.convert_assets');
1898: app_exception.raise_exception;
1899:
1900: END convert_assets;
1901:

Line 1949: calling_fn => 'fa_mc_upg1_pkg.Write_Msg_Log');

1945:
1946: EXCEPTION
1947: WHEN OTHERS THEN
1948: fa_srvr_msg.add_sql_error (
1949: calling_fn => 'fa_mc_upg1_pkg.Write_Msg_Log');
1950: END Write_ErrMsg_Log;
1951:
1952: PROCEDURE Write_DebugMsg_Log(
1953: p_msg_count IN NUMBER) IS

Line 2019: calling_fn => 'fa_mc_upg1_pkg.Write_DebugMsg_Log');

2015: end loop;
2016: EXCEPTION
2017: WHEN OTHERS THEN
2018: fa_srvr_msg.add_sql_error (
2019: calling_fn => 'fa_mc_upg1_pkg.Write_DebugMsg_Log');
2020: RAISE;
2021: END Write_DebugMsg_Log;
2022:
2023: END FA_MC_UPG1_PKG;

Line 2023: END FA_MC_UPG1_PKG;

2019: calling_fn => 'fa_mc_upg1_pkg.Write_DebugMsg_Log');
2020: RAISE;
2021: END Write_DebugMsg_Log;
2022:
2023: END FA_MC_UPG1_PKG;