DBA Data[Home] [Help]

APPS.FA_MC_UPG1_PKG dependencies on FA_SRVR_MSG

Line 34: fa_srvr_msg.add_sql_error (

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:

Line 340: fa_srvr_msg.add_sql_error (

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:

Line 438: fa_srvr_msg.add_message (

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);

Line 447: fa_srvr_msg.add_message (

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,

Line 457: fa_srvr_msg.add_message (

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,

Line 467: fa_srvr_msg.add_message (

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,

Line 477: fa_srvr_msg.add_sql_error (

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

Line 482: 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(
483: calling_fn => 'fa_mc_upg1_pkg.validate_setup');
484: app_exception.raise_exception;
485:
486: END validate_setup;

Line 562: fa_srvr_msg.add_message (

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:

Line 568: fa_srvr_msg.add_message (

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:

Line 574: fa_srvr_msg.add_sql_error(

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;

Line 819: fa_srvr_msg.add_message (

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);

Line 827: fa_srvr_msg.add_message (

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);

Line 835: fa_srvr_msg.add_message (

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);

Line 843: fa_srvr_msg.add_message (

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:

Line 849: fa_srvr_msg.add_sql_error (

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;

Line 974: fa_srvr_msg.add_sql_error (

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;

Line 1180: fa_srvr_msg.add_sql_error (

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

Line 1193: fa_srvr_msg.add_sql_error (

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;

Line 1232: fa_srvr_msg.add_sql_error (

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;

Line 1302: fa_srvr_msg.add_message (

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);

Line 1307: fa_srvr_msg.add_sql_error (

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;

Line 1371: fa_srvr_msg.add_message (

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,

Line 1381: fa_srvr_msg.add_message (

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,

Line 1391: fa_srvr_msg.add_message (

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,

Line 1401: fa_srvr_msg.add_sql_error (

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;

Line 1454: fa_srvr_msg.add_sql_error (

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;

Line 1476: fa_srvr_msg.add_sql_error (

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;

Line 1499: fa_srvr_msg.add_sql_error (

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;

Line 1515: fa_srvr_msg.add_sql_error (

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;

Line 1532: fa_srvr_msg.add_sql_error (

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;

Line 1550: fa_srvr_msg.add_sql_error (

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;

Line 1570: fa_srvr_msg.add_sql_error (

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;

Line 1592: fa_srvr_msg.add_sql_error (

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;

Line 1600: fa_srvr_msg.add_sql_error (

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:

Line 1828: fa_srvr_msg.add_message(

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));

Line 1890: fa_srvr_msg.add_message(

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));

Line 1896: fa_srvr_msg.add_sql_error (

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;

Line 1948: fa_srvr_msg.add_sql_error (

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(

Line 2018: fa_srvr_msg.add_sql_error (

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: