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.FEM_DIMENSION_MIGRATION_PKG dependencies on FEM_ENGINES_PKG

Line 457: FEM_ENGINES_PKG.TECH_MESSAGE

453: 'fem.plsql.fem_dim_member_loader_pkg.get_put_messages';
454:
455: BEGIN
456:
457: FEM_ENGINES_PKG.TECH_MESSAGE
458: (p_severity => c_log_level_2,
459: p_module => v_block||'.msg_count',
460: p_msg_text => p_msg_count);
461:

Line 469: FEM_ENGINES_PKG.User_Message(

465: THEN
466: FND_MESSAGE.Set_Encoded(v_msg_data);
467: v_message := FND_MESSAGE.Get;
468:
469: FEM_ENGINES_PKG.User_Message(
470: p_msg_text => v_message);
471:
472: FEM_ENGINES_PKG.TECH_MESSAGE
473: (p_severity => c_log_level_2,

Line 472: FEM_ENGINES_PKG.TECH_MESSAGE

468:
469: FEM_ENGINES_PKG.User_Message(
470: p_msg_text => v_message);
471:
472: FEM_ENGINES_PKG.TECH_MESSAGE
473: (p_severity => c_log_level_2,
474: p_module => v_block||'.msg_data',
475: p_msg_text => v_message);
476:

Line 487: FEM_ENGINES_PKG.User_Message(

483: p_encoded => c_false,
484: p_data => v_message,
485: p_msg_index_out => v_msg_out);
486:
487: FEM_ENGINES_PKG.User_Message(
488: p_msg_text => v_message);
489:
490: FEM_ENGINES_PKG.TECH_MESSAGE
491: (p_severity => c_log_level_2,

Line 490: FEM_ENGINES_PKG.TECH_MESSAGE

486:
487: FEM_ENGINES_PKG.User_Message(
488: p_msg_text => v_message);
489:
490: FEM_ENGINES_PKG.TECH_MESSAGE
491: (p_severity => c_log_level_2,
492: p_module => v_block||'.msg_data',
493: p_msg_text => v_message);
494:

Line 1424: FEM_ENGINES_PKG.TECH_MESSAGE

1420: insert_vs_cur INSERT_VS_CURSOR_TYPE;
1421:
1422: BEGIN
1423:
1424: FEM_ENGINES_PKG.TECH_MESSAGE
1425: (p_severity => c_log_level_2,
1426: p_module => c_block||'.l_vs_sql',
1427: p_msg_text => l_vs_sql);
1428:

Line 1463: FEM_ENGINES_PKG.TECH_MESSAGE

1459: FROM FEM_VALUE_SETS_VL
1460: WHERE VALUE_SET_NAME = l_vs_name(i);
1461:
1462: IF (SQL%FOUND) THEN
1463: FEM_ENGINES_PKG.TECH_MESSAGE
1464: (p_severity => c_log_level_2,
1465: p_module => c_block||'.insert_value_sets',
1466: p_msg_text => 'Duplicate vs name found in db '|| l_dup_vs_name);
1467: END IF;

Line 1537: FEM_ENGINES_PKG.TECH_MESSAGE

1533: insert_cal_cur INSERT_CAL_CURSOR_TYPE;
1534:
1535: BEGIN
1536:
1537: FEM_ENGINES_PKG.TECH_MESSAGE
1538: (p_severity => c_log_level_2,
1539: p_module => c_block||'.l_cal_sql',
1540: p_msg_text => l_cal_sql);
1541:

Line 1629: FEM_ENGINES_PKG.Tech_Message

1625:
1626: BEGIN
1627: --x_completion_status := 'SUCCESS';
1628:
1629: FEM_ENGINES_PKG.Tech_Message
1630: (p_severity => c_log_level_2,
1631: p_module => c_block||'.'||'Register_process_execution',
1632: p_msg_text => 'BEGIN');
1633:

Line 1662: FEM_ENGINES_PKG.Tech_Message

1658: X_MSG_COUNT => v_msg_count,
1659: X_MSG_DATA => v_msg_data,
1660: X_RETURN_STATUS => v_API_return_status);
1661:
1662: FEM_ENGINES_PKG.Tech_Message
1663: (p_severity => c_log_level_1,
1664: p_module => c_block||'.'||'Register_request.v_api_return_status',
1665: p_msg_text => v_API_return_status);
1666:

Line 1724: FEM_ENGINES_PKG.Tech_Message

1720: END IF;
1721:
1722: -- Successful completion
1723:
1724: FEM_ENGINES_PKG.Tech_Message
1725: (p_severity => c_log_level_1,
1726: p_module => c_block||'.'||'Register_process_execution',
1727: p_msg_text => 'END');
1728:

Line 1739: FEM_ENGINES_PKG.USER_MESSAGE

1735: p_msg_count => v_msg_count,
1736: p_msg_data => v_msg_data);
1737:
1738: -- display user message
1739: FEM_ENGINES_PKG.USER_MESSAGE
1740: (P_APP_NAME => c_fem
1741: ,P_MSG_NAME => G_PL_REG_REQUEST_ERR);
1742:
1743: FEM_ENGINES_PKG.USER_MESSAGE

Line 1743: FEM_ENGINES_PKG.USER_MESSAGE

1739: FEM_ENGINES_PKG.USER_MESSAGE
1740: (P_APP_NAME => c_fem
1741: ,P_MSG_NAME => G_PL_REG_REQUEST_ERR);
1742:
1743: FEM_ENGINES_PKG.USER_MESSAGE
1744: (P_APP_NAME => c_fem
1745: ,P_MSG_NAME => G_PL_MIGRATION_ERROR);
1746:
1747: --x_completion_status := 'ERROR';

Line 1757: FEM_ENGINES_PKG.USER_MESSAGE

1753: Get_Put_Messages (
1754: p_msg_count => v_msg_count,
1755: p_msg_data => v_msg_data);
1756:
1757: FEM_ENGINES_PKG.USER_MESSAGE
1758: (P_APP_NAME => c_fem
1759: ,P_MSG_NAME => G_PL_OBJ_EXEC_LOCK_ERR);
1760:
1761:

Line 1762: FEM_ENGINES_PKG.Tech_Message

1758: (P_APP_NAME => c_fem
1759: ,P_MSG_NAME => G_PL_OBJ_EXEC_LOCK_ERR);
1760:
1761:
1762: FEM_ENGINES_PKG.Tech_Message
1763: (p_severity => c_log_level_1,
1764: p_module => c_block||'.'||'Register_process_execution',
1765: p_msg_text => 'raising Exec_Lock_failed');
1766:

Line 1857: FEM_ENGINES_PKG.TECH_MESSAGE

1853: ' WHERE DIMENSION_VARCHAR_LABEL = :dim_varchar_lbl AND CREATED_BY_DIM_MIGRATION_FLAG = ''Y''';
1854:
1855: IF (gv_dim_props_rec.INTF_MEMBER_B_TABLE_NAME IS NOT NULL) THEN
1856:
1857: FEM_ENGINES_PKG.TECH_MESSAGE
1858: (p_severity => c_log_level_2,
1859: p_module => c_block||'.l_delete_b_sql',
1860: p_msg_text => l_delete_b_sql);
1861:

Line 1867: FEM_ENGINES_PKG.TECH_MESSAGE

1863: END IF;
1864:
1865: IF (gv_dim_props_rec.INTF_MEMBER_TL_TABLE_NAME IS NOT NULL) THEN
1866:
1867: FEM_ENGINES_PKG.TECH_MESSAGE
1868: (p_severity => c_log_level_2,
1869: p_module => c_block||'.l_delete_tl_sql',
1870: p_msg_text => l_delete_tl_sql);
1871:

Line 1877: FEM_ENGINES_PKG.TECH_MESSAGE

1873: END IF;
1874:
1875: IF (gv_dim_props_rec.INTF_ATTRIBUTE_TABLE_NAME IS NOT NULL) THEN
1876:
1877: FEM_ENGINES_PKG.TECH_MESSAGE
1878: (p_severity => c_log_level_2,
1879: p_module => c_block||'.l_delete_attr_sql',
1880: p_msg_text => l_delete_attr_sql);
1881:

Line 1886: FEM_ENGINES_PKG.TECH_MESSAGE

1882: EXECUTE IMMEDIATE l_delete_attr_sql;
1883: END IF;
1884:
1885:
1886: FEM_ENGINES_PKG.TECH_MESSAGE
1887: (p_severity => c_log_level_2,
1888: p_module => c_block||'.l_delete_dg_b_sql',
1889: p_msg_text => l_delete_dg_b_sql);
1890:

Line 1894: FEM_ENGINES_PKG.TECH_MESSAGE

1890:
1891: EXECUTE IMMEDIATE l_delete_dg_b_sql USING p_dim_varchar_lbl;
1892:
1893:
1894: FEM_ENGINES_PKG.TECH_MESSAGE
1895: (p_severity => c_log_level_2,
1896: p_module => c_block||'.l_delete_dg_tl_sql',
1897: p_msg_text => l_delete_dg_tl_sql);
1898:

Line 1907: FEM_ENGINES_PKG.TECH_MESSAGE

1903:
1904: EXCEPTION
1905:
1906: WHEN e_dimension_not_supported THEN
1907: FEM_ENGINES_PKG.TECH_MESSAGE
1908: (p_severity => c_log_level_5
1909: ,p_module => c_block||'.'||c_proc_name||'.Exception'
1910: ,p_app_name => c_fem
1911: ,p_msg_name => G_DIM_NOT_SUPPORTED

Line 1915: FEM_ENGINES_PKG.USER_MESSAGE

1911: ,p_msg_name => G_DIM_NOT_SUPPORTED
1912: ,P_TOKEN1 => 'DIM_NAME'
1913: ,P_VALUE1 => p_dim_varchar_lbl);
1914:
1915: FEM_ENGINES_PKG.USER_MESSAGE
1916: (p_app_name => c_fem
1917: ,p_msg_name => G_DIM_NOT_SUPPORTED
1918: ,P_TOKEN1 => 'DIM_NAME'
1919: ,P_VALUE1 => p_dim_varchar_lbl);

Line 1924: FEM_ENGINES_PKG.TECH_MESSAGE

1920:
1921: RAISE e_main_terminate;
1922:
1923: WHEN e_invalid_dimension THEN
1924: FEM_ENGINES_PKG.TECH_MESSAGE
1925: (p_severity => c_log_level_5
1926: ,p_module => c_block||'.'||c_proc_name||'.Exception'
1927: ,p_app_name => c_fem
1928: ,p_msg_name => G_INVALID_DIMENSION

Line 1932: FEM_ENGINES_PKG.USER_MESSAGE

1928: ,p_msg_name => G_INVALID_DIMENSION
1929: ,P_TOKEN1 => 'DIM_LBL'
1930: ,P_VALUE1 => p_dim_varchar_lbl);
1931:
1932: FEM_ENGINES_PKG.USER_MESSAGE
1933: (p_app_name => c_fem
1934: ,p_msg_name => G_INVALID_DIMENSION
1935: ,P_TOKEN1 => 'DIM_LBL'
1936: ,P_VALUE1 => p_dim_varchar_lbl);

Line 1941: FEM_ENGINES_PKG.TECH_MESSAGE

1937:
1938: RAISE e_main_terminate;
1939:
1940: WHEN e_db_link_not_registered THEN
1941: FEM_ENGINES_PKG.TECH_MESSAGE
1942: (p_severity => c_log_level_5
1943: ,p_module => c_block||'.'||c_proc_name||'.Exception'
1944: ,p_app_name => c_fem
1945: ,p_msg_name => G_DB_LINK_NOT_REGISTERED

Line 1949: FEM_ENGINES_PKG.USER_MESSAGE

1945: ,p_msg_name => G_DB_LINK_NOT_REGISTERED
1946: ,P_TOKEN1 => 'DB_LINK'
1947: ,P_VALUE1 => p_source_db_link);
1948:
1949: FEM_ENGINES_PKG.USER_MESSAGE
1950: (p_app_name => c_fem
1951: ,p_msg_name => G_DB_LINK_NOT_REGISTERED
1952: ,P_TOKEN1 => 'DB_LINK'
1953: ,P_VALUE1 => p_source_db_link);

Line 1958: FEM_ENGINES_PKG.TECH_MESSAGE

1954:
1955: RAISE e_main_terminate;
1956:
1957: WHEN e_db_link_not_functional THEN
1958: FEM_ENGINES_PKG.TECH_MESSAGE
1959: (p_severity => c_log_level_5
1960: ,p_module => c_block||'.'||c_proc_name||'.Exception'
1961: ,p_app_name => c_fem
1962: ,p_msg_name => G_DB_LINK_NOT_FUNCTIONAL

Line 1966: FEM_ENGINES_PKG.USER_MESSAGE

1962: ,p_msg_name => G_DB_LINK_NOT_FUNCTIONAL
1963: ,P_TOKEN1 => 'DB_LINK'
1964: ,P_VALUE1 => p_source_db_link);
1965:
1966: FEM_ENGINES_PKG.USER_MESSAGE
1967: (p_app_name => c_fem
1968: ,p_msg_name => G_DB_LINK_NOT_FUNCTIONAL
1969: ,P_TOKEN1 => 'DB_LINK'
1970: ,P_VALUE1 => p_source_db_link);

Line 1975: FEM_ENGINES_PKG.TECH_MESSAGE

1971:
1972: RAISE e_main_terminate;
1973:
1974: WHEN e_invalid_version_param THEN
1975: FEM_ENGINES_PKG.TECH_MESSAGE
1976: (p_severity => c_log_level_5
1977: ,p_module => c_block||'.'||c_proc_name||'.Exception'
1978: ,p_app_name => c_fem
1979: ,p_msg_name => G_INVALID_VERSION_PARAM

Line 1983: FEM_ENGINES_PKG.USER_MESSAGE

1979: ,p_msg_name => G_INVALID_VERSION_PARAM
1980: ,P_TOKEN1 => 'VERSION_NAME'
1981: ,P_VALUE1 => p_version_name);
1982:
1983: FEM_ENGINES_PKG.USER_MESSAGE
1984: (p_app_name => c_fem
1985: ,p_msg_name => G_INVALID_VERSION_PARAM
1986: ,P_TOKEN1 => 'VERSION_NAME'
1987: ,P_VALUE1 => p_version_name);

Line 1993: FEM_ENGINES_PKG.TECH_MESSAGE

1989: RAISE e_main_terminate;
1990:
1991:
1992: WHEN e_dim_not_user_extensible THEN
1993: FEM_ENGINES_PKG.TECH_MESSAGE
1994: (p_severity => c_log_level_5
1995: ,p_module => c_block||'.'||c_proc_name||'.Exception'
1996: ,p_app_name => c_fem
1997: ,p_msg_name => G_USER_DIM_MISMATCH

Line 2003: FEM_ENGINES_PKG.USER_MESSAGE

1999: ,P_VALUE1 => p_source_user_dim_name
2000: ,P_TOKEN2 => 'DIM_NAME'
2001: ,P_VALUE2 => p_dim_varchar_lbl);
2002:
2003: FEM_ENGINES_PKG.USER_MESSAGE
2004: (p_app_name => c_fem
2005: ,p_msg_name => G_USER_DIM_MISMATCH
2006: ,P_TOKEN1 => 'USER_DIM_NAME'
2007: ,P_VALUE1 => p_source_user_dim_name

Line 2015: FEM_ENGINES_PKG.TECH_MESSAGE

2011: RAISE e_main_terminate;
2012:
2013:
2014: WHEN e_src_dim_not_user_extensible THEN
2015: FEM_ENGINES_PKG.TECH_MESSAGE
2016: (p_severity => c_log_level_5
2017: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2018: ,p_app_name => c_fem
2019: ,p_msg_name => G_INVALID_SRC_USER_DIM

Line 2023: FEM_ENGINES_PKG.USER_MESSAGE

2019: ,p_msg_name => G_INVALID_SRC_USER_DIM
2020: ,P_TOKEN1 => 'USER_DIM_NAME'
2021: ,P_VALUE1 => p_source_user_dim_name);
2022:
2023: FEM_ENGINES_PKG.USER_MESSAGE
2024: (p_app_name => c_fem
2025: ,p_msg_name => G_INVALID_SRC_USER_DIM
2026: ,P_TOKEN1 => 'USER_DIM_NAME'
2027: ,P_VALUE1 => p_source_user_dim_name);

Line 2033: FEM_ENGINES_PKG.TECH_MESSAGE

2029: RAISE e_main_terminate;
2030:
2031:
2032: WHEN e_missing_version_params THEN
2033: FEM_ENGINES_PKG.TECH_MESSAGE
2034: (p_severity => c_log_level_5
2035: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2036: ,p_app_name => c_fem
2037: ,p_msg_name => G_MISSING_VERSION_PARAM);

Line 2039: FEM_ENGINES_PKG.USER_MESSAGE

2035: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2036: ,p_app_name => c_fem
2037: ,p_msg_name => G_MISSING_VERSION_PARAM);
2038:
2039: FEM_ENGINES_PKG.USER_MESSAGE
2040: (p_app_name => c_fem
2041: ,p_msg_name => G_MISSING_VERSION_PARAM);
2042:
2043: RAISE e_main_terminate;

Line 2047: FEM_ENGINES_PKG.TECH_MESSAGE

2043: RAISE e_main_terminate;
2044:
2045:
2046: WHEN e_invalid_obj_def THEN
2047: FEM_ENGINES_PKG.TECH_MESSAGE
2048: (p_severity => c_log_level_5
2049: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2050: ,p_app_name => c_fem
2051: ,p_msg_name => G_UNHANDLED_ERROR

Line 2057: FEM_ENGINES_PKG.USER_MESSAGE

2053: ,P_VALUE1 => 'Dimension Member Migration'
2054: ,P_TOKEN2 => 'SQLERRM'
2055: ,P_VALUE2 => SQLERRM);
2056:
2057: FEM_ENGINES_PKG.USER_MESSAGE
2058: (p_app_name => c_fem
2059: ,p_msg_name => G_UNHANDLED_ERROR
2060: ,P_TOKEN1 => 'MIGR_PROG'
2061: ,P_VALUE1 => 'Dimension Member Migration'

Line 2069: FEM_ENGINES_PKG.TECH_MESSAGE

2065: RAISE e_main_terminate;
2066:
2067:
2068: WHEN e_invalid_version_display_code THEN
2069: FEM_ENGINES_PKG.TECH_MESSAGE
2070: (p_severity => c_log_level_5
2071: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2072: ,p_app_name => c_fem
2073: ,p_msg_name => G_INVALID_VERSION_DISP_CD

Line 2078: FEM_ENGINES_PKG.USER_MESSAGE

2074: ,P_TOKEN1 => 'VERSION_CODE'
2075: ,P_VALUE1 => p_version_disp_cd);
2076:
2077:
2078: FEM_ENGINES_PKG.USER_MESSAGE
2079: (p_app_name => c_fem
2080: ,p_msg_name => G_INVALID_VERSION_DISP_CD
2081: ,P_TOKEN1 => 'VERSION_CODE'
2082: ,P_VALUE1 => p_version_disp_cd);

Line 2088: FEM_ENGINES_PKG.TECH_MESSAGE

2084: RAISE e_main_terminate;
2085:
2086:
2087: WHEN e_invalid_version_name THEN
2088: FEM_ENGINES_PKG.TECH_MESSAGE
2089: (p_severity => c_log_level_5
2090: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2091: ,p_app_name => c_fem
2092: ,p_msg_name => G_INVALID_VERSION_NAME

Line 2096: FEM_ENGINES_PKG.USER_MESSAGE

2092: ,p_msg_name => G_INVALID_VERSION_NAME
2093: ,P_TOKEN1 => 'VERSION_NAME'
2094: ,P_VALUE1 => p_version_name);
2095:
2096: FEM_ENGINES_PKG.USER_MESSAGE
2097: (p_app_name => c_fem
2098: ,p_msg_name => G_INVALID_VERSION_NAME
2099: ,P_TOKEN1 => 'VERSION_NAME'
2100: ,P_VALUE1 => p_version_name);

Line 2106: FEM_ENGINES_PKG.TECH_MESSAGE

2102: RAISE e_main_terminate;
2103:
2104:
2105: WHEN OTHERS THEN
2106: FEM_ENGINES_PKG.TECH_MESSAGE
2107: (p_severity => c_log_level_5
2108: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2109: ,p_app_name => c_fem
2110: ,p_msg_name => G_UNHANDLED_ERROR

Line 2116: FEM_ENGINES_PKG.USER_MESSAGE

2112: ,P_VALUE1 => 'Dimension Member Migration'
2113: ,P_TOKEN2 => 'SQLERRM'
2114: ,P_VALUE2 => SQLERRM);
2115:
2116: FEM_ENGINES_PKG.USER_MESSAGE
2117: (p_app_name => c_fem
2118: ,p_msg_name => G_UNHANDLED_ERROR
2119: ,P_TOKEN1 => 'MIGR_PROG'
2120: ,P_VALUE1 => 'Dimension Member Migration'

Line 2165: FEM_ENGINES_PKG.TECH_MESSAGE

2161:
2162:
2163: l_insert_b_sql := get_insert_b_sql(p_source_db_link, p_dim_varchar_lbl);
2164:
2165: FEM_ENGINES_PKG.TECH_MESSAGE
2166: (p_severity => c_log_level_2,
2167: p_module => c_block||'.l_insert_b_sql',
2168: p_msg_text => l_insert_b_sql);
2169:

Line 2173: FEM_ENGINES_PKG.TECH_MESSAGE

2169:
2170:
2171: l_insert_tl_sql := get_insert_tl_sql(p_source_db_link, p_dim_varchar_lbl);
2172:
2173: FEM_ENGINES_PKG.TECH_MESSAGE
2174: (p_severity => c_log_level_2,
2175: p_module => c_block||'.l_insert_tl_sql',
2176: p_msg_text => l_insert_tl_sql);
2177:

Line 2180: FEM_ENGINES_PKG.TECH_MESSAGE

2176: p_msg_text => l_insert_tl_sql);
2177:
2178: l_insert_attr_sql := get_dim_attr_sql(p_version_mode, p_source_db_link, p_dim_varchar_lbl);
2179:
2180: FEM_ENGINES_PKG.TECH_MESSAGE
2181: (p_severity => c_log_level_2,
2182: p_module => c_block||'.l_insert_attr_sql',
2183: p_msg_text => l_insert_attr_sql);
2184:

Line 2187: FEM_ENGINES_PKG.TECH_MESSAGE

2183: p_msg_text => l_insert_attr_sql);
2184:
2185: l_insert_dim_grp_b_sql := get_insert_dim_grp_b_sql(p_source_db_link);
2186:
2187: FEM_ENGINES_PKG.TECH_MESSAGE
2188: (p_severity => c_log_level_2,
2189: p_module => c_block||'.l_insert_dim_grp_b_sql',
2190: p_msg_text => l_insert_dim_grp_b_sql);
2191:

Line 2194: FEM_ENGINES_PKG.TECH_MESSAGE

2190: p_msg_text => l_insert_dim_grp_b_sql);
2191:
2192: l_insert_dim_grp_tl_sql := get_insert_dim_grp_tl_sql(p_source_db_link);
2193:
2194: FEM_ENGINES_PKG.TECH_MESSAGE
2195: (p_severity => c_log_level_2,
2196: p_module => c_block||'.l_insert_dim_grp_tl_sql',
2197: p_msg_text => l_insert_dim_grp_tl_sql);
2198:

Line 2312: FEM_ENGINES_PKG.TECH_MESSAGE

2308:
2309:
2310: EXCEPTION
2311: WHEN e_insert_b_exception THEN
2312: FEM_ENGINES_PKG.TECH_MESSAGE
2313: (p_severity => c_log_level_5
2314: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2315: ,p_app_name => c_fem
2316: ,p_msg_name => G_INSERT_ERROR

Line 2320: FEM_ENGINES_PKG.USER_MESSAGE

2316: ,p_msg_name => G_INSERT_ERROR
2317: ,P_TOKEN1 => 'TABLE_NAME'
2318: ,P_VALUE1 => gv_dim_props_rec.INTF_MEMBER_B_TABLE_NAME);
2319:
2320: FEM_ENGINES_PKG.USER_MESSAGE
2321: (p_app_name => c_fem
2322: ,p_msg_name => G_INSERT_ERROR
2323: ,P_TOKEN1 => 'TABLE_NAME'
2324: ,P_VALUE1 => gv_dim_props_rec.INTF_MEMBER_B_TABLE_NAME);

Line 2329: FEM_ENGINES_PKG.TECH_MESSAGE

2325:
2326: RAISE e_main_terminate;
2327:
2328: WHEN e_insert_tl_exception THEN
2329: FEM_ENGINES_PKG.TECH_MESSAGE
2330: (p_severity => c_log_level_5
2331: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2332: ,p_app_name => c_fem
2333: ,p_msg_name => G_INSERT_ERROR

Line 2337: FEM_ENGINES_PKG.USER_MESSAGE

2333: ,p_msg_name => G_INSERT_ERROR
2334: ,P_TOKEN1 => 'TABLE_NAME'
2335: ,P_VALUE1 => gv_dim_props_rec.INTF_MEMBER_TL_TABLE_NAME);
2336:
2337: FEM_ENGINES_PKG.USER_MESSAGE
2338: (p_app_name => c_fem
2339: ,p_msg_name => G_INSERT_ERROR
2340: ,P_TOKEN1 => 'TABLE_NAME'
2341: ,P_VALUE1 => gv_dim_props_rec.INTF_MEMBER_TL_TABLE_NAME);

Line 2345: FEM_ENGINES_PKG.TECH_MESSAGE

2341: ,P_VALUE1 => gv_dim_props_rec.INTF_MEMBER_TL_TABLE_NAME);
2342: RAISE e_main_terminate;
2343:
2344: WHEN e_insert_attr_exception THEN
2345: FEM_ENGINES_PKG.TECH_MESSAGE
2346: (p_severity => c_log_level_5
2347: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2348: ,p_app_name => c_fem
2349: ,p_msg_name => G_INSERT_ERROR

Line 2353: FEM_ENGINES_PKG.USER_MESSAGE

2349: ,p_msg_name => G_INSERT_ERROR
2350: ,P_TOKEN1 => 'TABLE_NAME'
2351: ,P_VALUE1 => gv_dim_props_rec.INTF_ATTRIBUTE_TABLE_NAME);
2352:
2353: FEM_ENGINES_PKG.USER_MESSAGE
2354: (p_app_name => c_fem
2355: ,p_msg_name => G_INSERT_ERROR
2356: ,P_TOKEN1 => 'TABLE_NAME'
2357: ,P_VALUE1 => gv_dim_props_rec.INTF_ATTRIBUTE_TABLE_NAME);

Line 2477: FEM_ENGINES_PKG.TECH_MESSAGE

2473:
2474: EXCEPTION
2475:
2476: WHEN e_dimension_not_supported THEN
2477: FEM_ENGINES_PKG.TECH_MESSAGE
2478: (p_severity => c_log_level_5
2479: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2480: ,p_app_name => c_fem
2481: ,p_msg_name => G_DIM_NOT_SUPPORTED

Line 2485: FEM_ENGINES_PKG.USER_MESSAGE

2481: ,p_msg_name => G_DIM_NOT_SUPPORTED
2482: ,P_TOKEN1 => 'DIM_NAME'
2483: ,P_VALUE1 => p_dim_varchar_lbl);
2484:
2485: FEM_ENGINES_PKG.USER_MESSAGE
2486: (p_app_name => c_fem
2487: ,p_msg_name => G_DIM_NOT_SUPPORTED
2488: ,P_TOKEN1 => 'DIM_NAME'
2489: ,P_VALUE1 => p_dim_varchar_lbl);

Line 2494: FEM_ENGINES_PKG.TECH_MESSAGE

2490:
2491: RAISE e_main_terminate;
2492:
2493: WHEN e_invalid_dimension THEN
2494: FEM_ENGINES_PKG.TECH_MESSAGE
2495: (p_severity => c_log_level_5
2496: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2497: ,p_app_name => c_fem
2498: ,p_msg_name => G_INVALID_DIMENSION

Line 2502: FEM_ENGINES_PKG.USER_MESSAGE

2498: ,p_msg_name => G_INVALID_DIMENSION
2499: ,P_TOKEN1 => 'DIM_LBL'
2500: ,P_VALUE1 => p_dim_varchar_lbl);
2501:
2502: FEM_ENGINES_PKG.USER_MESSAGE
2503: (p_app_name => c_fem
2504: ,p_msg_name => G_INVALID_DIMENSION
2505: ,P_TOKEN1 => 'DIM_LBL'
2506: ,P_VALUE1 => p_dim_varchar_lbl);

Line 2511: FEM_ENGINES_PKG.TECH_MESSAGE

2507:
2508: RAISE e_main_terminate;
2509:
2510: WHEN e_db_link_not_registered THEN
2511: FEM_ENGINES_PKG.TECH_MESSAGE
2512: (p_severity => c_log_level_5
2513: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2514: ,p_app_name => c_fem
2515: ,p_msg_name => G_DB_LINK_NOT_REGISTERED

Line 2519: FEM_ENGINES_PKG.USER_MESSAGE

2515: ,p_msg_name => G_DB_LINK_NOT_REGISTERED
2516: ,P_TOKEN1 => 'DB_LINK'
2517: ,P_VALUE1 => p_source_db_link);
2518:
2519: FEM_ENGINES_PKG.USER_MESSAGE
2520: (p_app_name => c_fem
2521: ,p_msg_name => G_DB_LINK_NOT_REGISTERED
2522: ,P_TOKEN1 => 'DB_LINK'
2523: ,P_VALUE1 => p_source_db_link);

Line 2528: FEM_ENGINES_PKG.TECH_MESSAGE

2524:
2525: RAISE e_main_terminate;
2526:
2527: WHEN e_db_link_not_functional THEN
2528: FEM_ENGINES_PKG.TECH_MESSAGE
2529: (p_severity => c_log_level_5
2530: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2531: ,p_app_name => c_fem
2532: ,p_msg_name => G_DB_LINK_NOT_FUNCTIONAL

Line 2536: FEM_ENGINES_PKG.USER_MESSAGE

2532: ,p_msg_name => G_DB_LINK_NOT_FUNCTIONAL
2533: ,P_TOKEN1 => 'DB_LINK'
2534: ,P_VALUE1 => p_source_db_link);
2535:
2536: FEM_ENGINES_PKG.USER_MESSAGE
2537: (p_app_name => c_fem
2538: ,p_msg_name => G_DB_LINK_NOT_FUNCTIONAL
2539: ,P_TOKEN1 => 'DB_LINK'
2540: ,P_VALUE1 => p_source_db_link);

Line 2546: FEM_ENGINES_PKG.TECH_MESSAGE

2542: RAISE e_main_terminate;
2543:
2544:
2545: WHEN e_dim_not_user_extensible THEN
2546: FEM_ENGINES_PKG.TECH_MESSAGE
2547: (p_severity => c_log_level_5
2548: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2549: ,p_app_name => c_fem
2550: ,p_msg_name => G_USER_DIM_MISMATCH

Line 2554: FEM_ENGINES_PKG.USER_MESSAGE

2550: ,p_msg_name => G_USER_DIM_MISMATCH
2551: ,P_TOKEN1 => 'USER_DIM_NAME'
2552: ,P_VALUE1 => p_source_user_dim_name);
2553:
2554: FEM_ENGINES_PKG.USER_MESSAGE
2555: (p_app_name => c_fem
2556: ,p_msg_name => G_USER_DIM_MISMATCH
2557: ,P_TOKEN1 => 'USER_DIM_NAME'
2558: ,P_VALUE1 => p_source_user_dim_name);

Line 2564: FEM_ENGINES_PKG.TECH_MESSAGE

2560: RAISE e_main_terminate;
2561:
2562:
2563: WHEN e_src_dim_not_user_extensible THEN
2564: FEM_ENGINES_PKG.TECH_MESSAGE
2565: (p_severity => c_log_level_5
2566: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2567: ,p_app_name => c_fem
2568: ,p_msg_name => G_INVALID_SRC_USER_DIM

Line 2572: FEM_ENGINES_PKG.USER_MESSAGE

2568: ,p_msg_name => G_INVALID_SRC_USER_DIM
2569: ,P_TOKEN1 => 'USER_DIM_NAME'
2570: ,P_VALUE1 => p_source_user_dim_name);
2571:
2572: FEM_ENGINES_PKG.USER_MESSAGE
2573: (p_app_name => c_fem
2574: ,p_msg_name => G_INVALID_SRC_USER_DIM
2575: ,P_TOKEN1 => 'USER_DIM_NAME'
2576: ,P_VALUE1 => p_source_user_dim_name);

Line 2582: FEM_ENGINES_PKG.TECH_MESSAGE

2578: RAISE e_main_terminate;
2579:
2580:
2581: WHEN e_invalid_hierarchy THEN
2582: FEM_ENGINES_PKG.TECH_MESSAGE
2583: (p_severity => c_log_level_5
2584: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2585: ,p_app_name => c_fem
2586: ,p_msg_name => G_INVALID_HIERARCHY

Line 2590: FEM_ENGINES_PKG.USER_MESSAGE

2586: ,p_msg_name => G_INVALID_HIERARCHY
2587: ,P_TOKEN1 => 'HIER'
2588: ,P_VALUE1 => p_hier_obj_name);
2589:
2590: FEM_ENGINES_PKG.USER_MESSAGE
2591: (p_app_name => c_fem
2592: ,p_msg_name => G_INVALID_HIERARCHY
2593: ,P_TOKEN1 => 'HIER'
2594: ,P_VALUE1 => p_hier_obj_name);

Line 2600: FEM_ENGINES_PKG.TECH_MESSAGE

2596: RAISE e_main_terminate;
2597:
2598: WHEN e_dim_hier_not_supported THEN
2599:
2600: FEM_ENGINES_PKG.TECH_MESSAGE
2601: (p_severity => c_log_level_5
2602: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2603: ,p_app_name => c_fem
2604: ,p_msg_name => G_DIM_HIER_NOT_SUPPORTED

Line 2609: FEM_ENGINES_PKG.USER_MESSAGE

2605: ,P_TOKEN1 => 'DIM_NAME'
2606: ,P_VALUE1 => p_dim_varchar_lbl);
2607:
2608:
2609: FEM_ENGINES_PKG.USER_MESSAGE
2610: (p_app_name => c_fem
2611: ,p_msg_name => G_DIM_HIER_NOT_SUPPORTED
2612: ,P_TOKEN1 => 'DIM_NAME'
2613: ,P_VALUE1 => p_dim_varchar_lbl);

Line 2618: FEM_ENGINES_PKG.TECH_MESSAGE

2614:
2615: RAISE e_main_terminate;
2616:
2617: WHEN OTHERS THEN
2618: FEM_ENGINES_PKG.TECH_MESSAGE
2619: (p_severity => c_log_level_5
2620: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2621: ,p_app_name => c_fem
2622: ,p_msg_name => G_UNHANDLED_ERROR

Line 2628: FEM_ENGINES_PKG.USER_MESSAGE

2624: ,P_VALUE1 => 'Dimension Hierarchy Migration'
2625: ,P_TOKEN2 => 'SQLERRM'
2626: ,P_VALUE2 => SQLERRM);
2627:
2628: FEM_ENGINES_PKG.USER_MESSAGE
2629: (p_app_name => c_fem
2630: ,p_msg_name => G_UNHANDLED_ERROR
2631: ,P_TOKEN1 => 'MIGR_PROG'
2632: ,P_VALUE1 => 'Dimension Hierarchy Migration'

Line 2713: FEM_ENGINES_PKG.TECH_MESSAGE

2709: BEGIN
2710:
2711: l_hier_version_sql := REPLACE(l_hier_version_sql, '{{version_where}}', l_hier_version_where);
2712:
2713: FEM_ENGINES_PKG.TECH_MESSAGE
2714: (p_severity => c_log_level_2,
2715: p_module => c_block||'.l_hier_version_sql',
2716: p_msg_text => l_hier_version_sql);
2717:

Line 2778: FEM_ENGINES_PKG.TECH_MESSAGE

2774:
2775:
2776:
2777:
2778: FEM_ENGINES_PKG.TECH_MESSAGE
2779: (p_severity => c_log_level_2,
2780: p_module => c_block||'.l_insert_hier_rule_sql',
2781: p_msg_text => l_insert_hier_rule_sql);
2782:

Line 2819: FEM_ENGINES_PKG.TECH_MESSAGE

2815: END IF;
2816:
2817: l_hier_version_sql := REPLACE(l_hier_version_sql, '{{version_where}}', '');
2818:
2819: FEM_ENGINES_PKG.TECH_MESSAGE
2820: (p_severity => c_log_level_2,
2821: p_module => c_block||'.l_hier_version_sql',
2822: p_msg_text => l_hier_version_sql);
2823:

Line 2856: FEM_ENGINES_PKG.TECH_MESSAGE

2852: p_source_db_link);
2853:
2854:
2855:
2856: FEM_ENGINES_PKG.TECH_MESSAGE
2857: (p_severity => c_log_level_2,
2858: p_module => c_block||'.l_insert_hier_rule_sql',
2859: p_msg_text => l_insert_hier_rule_sql);
2860:

Line 2866: FEM_ENGINES_PKG.TECH_MESSAGE

2862: COMMIT;
2863:
2864: --IF DUPLICATE DATA EXISTS THROW ERROR B/C IT CAME FROM SOME OTHER DATA SOURCE--
2865:
2866: FEM_ENGINES_PKG.TECH_MESSAGE
2867: (p_severity => c_log_level_2,
2868: p_module => c_block||'.l_insert_hier_sql',
2869: p_msg_text => l_insert_hier_sql);
2870:

Line 2902: FEM_ENGINES_PKG.TECH_MESSAGE

2898:
2899: --process value sets and dimension groups--
2900: l_insert_hier_vs_sql := get_hier_vs_sql(p_hier_obj_name,
2901: p_source_db_link);
2902: FEM_ENGINES_PKG.TECH_MESSAGE
2903: (p_severity => c_log_level_2,
2904: p_module => c_block||'.l_insert_hier_vs_sql',
2905: p_msg_text => l_insert_hier_vs_sql);
2906:

Line 2910: FEM_ENGINES_PKG.TECH_MESSAGE

2906:
2907: l_insert_hier_dg_sql := get_hier_dg_sql(p_hier_obj_name, p_source_db_link);
2908:
2909:
2910: FEM_ENGINES_PKG.TECH_MESSAGE
2911: (p_severity => c_log_level_2,
2912: p_module => c_block||'.l_insert_hier_dg_sql',
2913: p_msg_text => l_insert_hier_dg_sql);
2914:

Line 2927: FEM_ENGINES_PKG.TECH_MESSAGE

2923: EXCEPTION
2924:
2925: WHEN e_invalid_hierarchy THEN
2926:
2927: FEM_ENGINES_PKG.TECH_MESSAGE
2928: (p_severity => c_log_level_5
2929: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2930: ,p_app_name => c_fem
2931: ,p_msg_name => G_INVALID_HIERARCHY

Line 2935: FEM_ENGINES_PKG.USER_MESSAGE

2931: ,p_msg_name => G_INVALID_HIERARCHY
2932: ,P_TOKEN1 => 'HIER'
2933: ,P_VALUE1 => p_hier_obj_name);
2934:
2935: FEM_ENGINES_PKG.USER_MESSAGE
2936: (p_app_name => c_fem
2937: ,p_msg_name => G_INVALID_HIERARCHY
2938: ,P_TOKEN1 => 'HIER'
2939: ,P_VALUE1 => p_hier_obj_name);

Line 2945: FEM_ENGINES_PKG.TECH_MESSAGE

2941: RAISE e_main_terminate;
2942:
2943: WHEN e_insert_hier_exception THEN
2944:
2945: FEM_ENGINES_PKG.TECH_MESSAGE
2946: (p_severity => c_log_level_5
2947: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2948: ,p_app_name => c_fem
2949: ,p_msg_name => G_INSERT_ERROR

Line 2953: FEM_ENGINES_PKG.USER_MESSAGE

2949: ,p_msg_name => G_INSERT_ERROR
2950: ,P_TOKEN1 => 'TABLE_NAME'
2951: ,P_VALUE1 => gv_dim_props_rec.HIERARCHY_INTF_TABLE_NAME);
2952:
2953: FEM_ENGINES_PKG.USER_MESSAGE
2954: (p_app_name => c_fem
2955: ,p_msg_name => G_INSERT_ERROR
2956: ,P_TOKEN1 => 'TABLE_NAME'
2957: ,P_VALUE1 => gv_dim_props_rec.HIERARCHY_INTF_TABLE_NAME);

Line 2963: FEM_ENGINES_PKG.TECH_MESSAGE

2959: RAISE e_main_terminate;
2960:
2961: WHEN e_invalid_hierarchy_version THEN
2962:
2963: FEM_ENGINES_PKG.TECH_MESSAGE
2964: (p_severity => c_log_level_5
2965: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2966: ,p_app_name => c_fem
2967: ,p_msg_name => G_INVALID_HIER_VERSION

Line 2971: FEM_ENGINES_PKG.USER_MESSAGE

2967: ,p_msg_name => G_INVALID_HIER_VERSION
2968: ,P_TOKEN1 => 'HIER_VERSION'
2969: ,P_VALUE1 => p_hier_obj_def_name);
2970:
2971: FEM_ENGINES_PKG.USER_MESSAGE
2972: (p_app_name => c_fem
2973: ,p_msg_name => G_INVALID_HIER_VERSION
2974: ,P_TOKEN1 => 'HIER_VERSION'
2975: ,P_VALUE1 => p_hier_obj_def_name);

Line 2980: FEM_ENGINES_PKG.TECH_MESSAGE

2976:
2977: RAISE e_main_terminate;
2978:
2979: WHEN e_terminate THEN
2980: FEM_ENGINES_PKG.TECH_MESSAGE
2981: (p_severity => c_log_level_5
2982: ,p_module => c_block||'.'||c_proc_name||'.Exception'
2983: ,p_app_name => c_fem
2984: ,p_msg_name => G_UNHANDLED_ERROR

Line 2990: FEM_ENGINES_PKG.USER_MESSAGE

2986: ,P_VALUE1 => 'Dimension Hierarchy Migration'
2987: ,P_TOKEN2 => 'SQLERRM'
2988: ,P_VALUE2 => SQLERRM);
2989:
2990: FEM_ENGINES_PKG.USER_MESSAGE
2991: (p_app_name => c_fem
2992: ,p_msg_name => G_UNHANDLED_ERROR
2993: ,P_TOKEN1 => 'MIGR_PROG'
2994: ,P_VALUE1 => 'Dimension Hierarchy Migration'

Line 3001: FEM_ENGINES_PKG.TECH_MESSAGE

2997:
2998: RAISE e_main_terminate;
2999:
3000: WHEN e_target_hierarchy_exists THEN
3001: FEM_ENGINES_PKG.TECH_MESSAGE
3002: (p_severity => c_log_level_5
3003: ,p_module => c_block||'.'||c_proc_name||'.Exception'
3004: ,p_app_name => c_fem
3005: ,p_msg_name => G_HIERARCHY_RULE_EXISTS

Line 3010: FEM_ENGINES_PKG.USER_MESSAGE

3006: ,P_TOKEN1 => 'HIER_NAME'
3007: ,P_VALUE1 => p_hier_obj_name);
3008:
3009:
3010: FEM_ENGINES_PKG.USER_MESSAGE
3011: (p_app_name => c_fem
3012: ,p_msg_name => G_HIERARCHY_RULE_EXISTS
3013: ,P_TOKEN1 => 'HIER_NAME'
3014: ,P_VALUE1 => p_hier_obj_name);

Line 3102: FEM_ENGINES_PKG.TECH_MESSAGE

3098: Get_Put_Messages (
3099: p_msg_count => v_msg_count,
3100: p_msg_data => v_msg_data);
3101:
3102: FEM_ENGINES_PKG.TECH_MESSAGE
3103: (p_severity => c_log_level_1,
3104: p_module => c_block||'.'||'Eng_Master_Post_Proc',
3105: p_msg_text => 'Post Process failed');
3106:

Line 3107: FEM_ENGINES_PKG.USER_MESSAGE

3103: (p_severity => c_log_level_1,
3104: p_module => c_block||'.'||'Eng_Master_Post_Proc',
3105: p_msg_text => 'Post Process failed');
3106:
3107: FEM_ENGINES_PKG.USER_MESSAGE
3108: (P_APP_NAME => c_fem
3109: ,P_MSG_NAME => G_PL_MIGRATION_ERROR);
3110:
3111: END POST_PROCESS_HIERARCHY;

Line 3164: FEM_ENGINES_PKG.User_Message(

3160:
3161:
3162: BEGIN
3163:
3164: FEM_ENGINES_PKG.User_Message(
3165: p_msg_text => 'Migrating Hierarchy...');
3166:
3167:
3168: PRE_PROCESS_HIERARCHY(p_source_db_link,

Line 3219: FEM_ENGINES_PKG.User_Message(

3215: l_return_status NUMBER;
3216:
3217: BEGIN
3218:
3219: FEM_ENGINES_PKG.User_Message(
3220: p_msg_text => 'Migrating Members...');
3221:
3222:
3223: PRE_PROCESS_MEMBERS(

Line 3335: FEM_ENGINES_PKG.TECH_MESSAGE

3331: Get_Put_Messages (
3332: p_msg_count => v_msg_count,
3333: p_msg_data => v_msg_data);
3334:
3335: FEM_ENGINES_PKG.TECH_MESSAGE
3336: (p_severity => c_log_level_1,
3337: p_module => c_block||'.'||'Eng_Master_Post_Proc',
3338: p_msg_text => 'Post Process failed');
3339:

Line 3340: FEM_ENGINES_PKG.USER_MESSAGE

3336: (p_severity => c_log_level_1,
3337: p_module => c_block||'.'||'Eng_Master_Post_Proc',
3338: p_msg_text => 'Post Process failed');
3339:
3340: FEM_ENGINES_PKG.USER_MESSAGE
3341: (P_APP_NAME => c_fem
3342: ,P_MSG_NAME => G_PL_MIGRATION_ERROR);
3343:
3344: END POST_PROCESS_MEMBERS;