30: NOWAIT;
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:
336: END IF;
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:
434: end if;
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:
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,
453: value2 => p_book_type_code);
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,
463: value2 => p_book_type_code);
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,
473: value2 => p_book_type_code);
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
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(
483: calling_fn => 'fa_mc_upg1_pkg.validate_setup');
484: app_exception.raise_exception;
485:
486: END validate_setup;
558:
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:
564: name => 'FA_MRC_NOT_FIXED_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:
570: name => 'FA_MRC_NO_BASIS');
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;
815: end if;
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);
823: value1 => G_rbook_name);
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);
831: value1 => l_first_mrc_period);
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);
839: value1 => l_first_mrc_period);
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:
845: name => 'FA_SHARED_SEL_DEPRN_PERIODS');
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;
970: FND_CONCURRENT.AF_COMMIT;
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;
1176: p_start_pc,
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
1189: p_start_pc,
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;
1228: CLOSE 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;
1298: end if;
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);
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 (
1308: calling_fn => 'fa_mc_upg1_pkg.get_rate_info');
1309: app_exception.raise_exception;
1310:
1311: END get_rate_info;
1367: CLOSE check_preview;
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,
1377: value2 => G_rbook_name);
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,
1387: value2 => G_rbook_name);
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,
1397: value2 => G_rbook_name);
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;
1450:
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;
1472:
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;
1495:
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;
1511:
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;
1528:
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;
1546:
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;
1566:
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;
1588:
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;
1596: end;
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:
1824: l_assets_processed := l_assets_processed + l_commit_size;
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));
1886: p_start_pc,
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));
1892: name => 'FA_SHARED_NUMBER_PROCESSED',
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;
1944: */
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(
2014: */
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: