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_BI_DIMENSION_UTILS_PKG dependencies on FEM_ENGINES_PKG

Line 204: FEM_ENGINES_PKG.Tech_Message (

200:
201: -------------------------------------------
202: -- Start Procedure Logging and Messaging --
203: -------------------------------------------
204: FEM_ENGINES_PKG.Tech_Message (
205: p_severity => G_LOG_LEVEL_PROCEDURE
206: ,p_module => l_module_name || '.begin'
207: ,p_app_name => G_FEM
208: ,p_msg_name => G_GL_POST_201

Line 215: FEM_ENGINES_PKG.User_Message (

211: ,p_token2 => 'TIME'
212: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
213: );
214:
215: FEM_ENGINES_PKG.User_Message (
216: p_app_name => G_FEM
217: ,p_msg_name => G_GL_POST_201
218: ,p_token1 => 'FUNC_NAME'
219: ,p_value1 => l_function_name

Line 333: FEM_ENGINES_PKG.User_Message (

329: raise l_attr_trans_child_sub_failed;
330:
331: else
332:
333: FEM_ENGINES_PKG.User_Message (
334: p_app_name => G_FEM
335: ,p_msg_name => G_BI_ATTR_REQ_SUB_SUCCESS
336: ,p_token1 => 'DIMENSION'
337: ,p_value1 => l_bi_attr_dims_tbl(i).dimension_name

Line 342: FEM_ENGINES_PKG.Tech_Message (

338: ,p_token2 => 'REQ_ID'
339: ,p_value2 => to_char(l_child_request_id)
340: );
341:
342: FEM_ENGINES_PKG.Tech_Message (
343: p_severity => G_LOG_LEVEL_STATEMENT
344: ,p_module => l_module_name||'.child_req_submission'
345: ,p_app_name => G_FEM
346: ,p_msg_name => G_BI_ATTR_REQ_SUB_SUCCESS

Line 399: FEM_ENGINES_PKG.Tech_Message (

395: elsif l_dev_status <> 'NORMAL' then
396: l_errors := l_errors + 1;
397: end if;
398:
399: FEM_ENGINES_PKG.Tech_Message (
400: p_severity => G_LOG_LEVEL_STATEMENT
401: ,p_module => l_module_name||'.child_req_status'
402: ,p_app_name => G_FEM
403: ,p_msg_name => G_BI_ATTR_REQ_STATUS

Line 412: FEM_ENGINES_PKG.User_Message (

408: ,p_token3 => 'STATUS'
409: ,p_value3 => l_status
410: );
411:
412: FEM_ENGINES_PKG.User_Message (
413: p_app_name => G_FEM
414: ,p_msg_name => G_BI_ATTR_REQ_STATUS
415: ,p_token1 => 'DIMENSION'
416: ,p_value1 => l_child_requests_tbl(i).description

Line 453: FEM_ENGINES_PKG.Tech_Message (

449: if l_completion_status = 'NORMAL' then
450:
451: x_retcode := '0';
452:
453: FEM_ENGINES_PKG.Tech_Message (
454: p_severity => G_LOG_LEVEL_PROCEDURE
455: ,p_module => l_module_name||'.end'
456: ,p_app_name => G_FEM
457: ,p_msg_name => G_GL_POST_202

Line 464: FEM_ENGINES_PKG.User_Message (

460: ,p_token2 => 'TIME'
461: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
462: );
463:
464: FEM_ENGINES_PKG.User_Message (
465: p_app_name => G_FEM
466: ,p_msg_name => G_GL_POST_202
467: ,p_token1 => 'FUNC_NAME'
468: ,p_value1 => l_function_name

Line 477: FEM_ENGINES_PKG.Tech_Message (

473: elsif l_completion_status = 'WARNING' then
474:
475: x_retcode := '1';
476:
477: FEM_ENGINES_PKG.Tech_Message (
478: p_severity => G_LOG_LEVEL_PROCEDURE
479: ,p_module => l_module_name||'.end'
480: ,p_app_name => G_FEM
481: ,p_msg_name => G_GL_POST_206

Line 484: FEM_ENGINES_PKG.User_Message (

480: ,p_app_name => G_FEM
481: ,p_msg_name => G_GL_POST_206
482: );
483:
484: FEM_ENGINES_PKG.User_Message (
485: p_app_name => G_FEM
486: ,p_msg_name => G_GL_POST_206
487: );
488:

Line 493: FEM_ENGINES_PKG.Tech_Message (

489: else
490:
491: x_retcode := '2';
492:
493: FEM_ENGINES_PKG.Tech_Message (
494: p_severity => G_LOG_LEVEL_PROCEDURE
495: ,p_module => l_module_name||'.end'
496: ,p_app_name => G_FEM
497: ,p_msg_name => G_GL_POST_203

Line 504: FEM_ENGINES_PKG.User_Message (

500: ,p_token2 => 'TIME'
501: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
502: );
503:
504: FEM_ENGINES_PKG.User_Message (
505: p_app_name => G_FEM
506: ,p_msg_name => G_GL_POST_203
507: ,p_token1 => 'FUNC_NAME'
508: ,p_value1 => l_function_name

Line 523: FEM_ENGINES_PKG.Tech_Message (

519: rollback;
520:
521: x_retcode := '2';
522:
523: FEM_ENGINES_PKG.Tech_Message (
524: p_severity => G_LOG_LEVEL_EXCEPTION
525: ,p_module => l_module_name||'.invalid_dimension'
526: ,p_app_name => G_FEM
527: ,p_msg_name => G_BI_ATTR_INVALID_DIMENSION

Line 532: FEM_ENGINES_PKG.User_Message (

528: ,p_token1 => 'DIMENSION'
529: ,p_value1 => p_dimension_varchar_label
530: );
531:
532: FEM_ENGINES_PKG.User_Message (
533: p_app_name => G_FEM
534: ,p_msg_name => G_BI_ATTR_INVALID_DIMENSION
535: ,p_token1 => 'DIMENSION'
536: ,p_value1 => p_dimension_varchar_label

Line 539: FEM_ENGINES_PKG.Tech_Message (

535: ,p_token1 => 'DIMENSION'
536: ,p_value1 => p_dimension_varchar_label
537: );
538:
539: FEM_ENGINES_PKG.Tech_Message (
540: p_severity => G_LOG_LEVEL_EXCEPTION
541: ,p_module => l_module_name||'.invalid_dimension'
542: ,p_app_name => G_FEM
543: ,p_msg_name => G_GL_POST_203

Line 550: FEM_ENGINES_PKG.User_Message (

546: ,p_token2 => 'TIME'
547: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
548: );
549:
550: FEM_ENGINES_PKG.User_Message (
551: p_app_name => G_FEM
552: ,p_msg_name => G_GL_POST_203
553: ,p_token1 => 'FUNC_NAME'
554: ,p_value1 => l_function_name

Line 565: FEM_ENGINES_PKG.Tech_Message (

561: rollback;
562:
563: x_retcode := '2';
564:
565: FEM_ENGINES_PKG.Tech_Message (
566: p_severity => G_LOG_LEVEL_EXCEPTION
567: ,p_module => l_module_name||'.sub_failed'
568: ,p_app_name => G_FEM
569: ,p_msg_name => G_BI_ATTR_REQ_SUB_FAILURE

Line 574: FEM_ENGINES_PKG.User_Message (

570: ,p_token1 => 'DIMENSION'
571: ,p_value1 => l_dimension_name
572: );
573:
574: FEM_ENGINES_PKG.User_Message (
575: p_app_name => G_FEM
576: ,p_msg_name => G_BI_ATTR_REQ_SUB_FAILURE
577: ,p_token1 => 'DIMENSION'
578: ,p_value1 => l_dimension_name

Line 581: FEM_ENGINES_PKG.Tech_Message (

577: ,p_token1 => 'DIMENSION'
578: ,p_value1 => l_dimension_name
579: );
580:
581: FEM_ENGINES_PKG.Tech_Message (
582: p_severity => G_LOG_LEVEL_EXCEPTION
583: ,p_module => l_module_name||'.sub_failed'
584: ,p_app_name => G_FEM
585: ,p_msg_name => G_GL_POST_203

Line 592: FEM_ENGINES_PKG.User_Message (

588: ,p_token2 => 'TIME'
589: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
590: );
591:
592: FEM_ENGINES_PKG.User_Message (
593: p_app_name => G_FEM
594: ,p_msg_name => G_GL_POST_203
595: ,p_token1 => 'FUNC_NAME'
596: ,p_value1 => l_function_name

Line 607: FEM_ENGINES_PKG.Tech_Message (

603: rollback;
604:
605: x_retcode := '2';
606:
607: FEM_ENGINES_PKG.Tech_Message (
608: p_severity => G_LOG_LEVEL_EXCEPTION
609: ,p_module => l_module_name||'.others'
610: ,p_app_name => G_FEM
611: ,p_msg_name => G_GL_POST_215

Line 616: FEM_ENGINES_PKG.User_Message (

612: ,p_token1 => 'ERR_MSG'
613: ,p_value1 => SQLERRM
614: );
615:
616: FEM_ENGINES_PKG.User_Message (
617: p_app_name => G_FEM
618: ,p_msg_name => G_GL_POST_215
619: ,p_token1 => 'ERR_MSG'
620: ,p_value1 => SQLERRM

Line 623: FEM_ENGINES_PKG.Tech_Message (

619: ,p_token1 => 'ERR_MSG'
620: ,p_value1 => SQLERRM
621: );
622:
623: FEM_ENGINES_PKG.Tech_Message (
624: p_severity => G_LOG_LEVEL_EXCEPTION
625: ,p_module => l_module_name||'.others'
626: ,p_app_name => G_FEM
627: ,p_msg_name => G_GL_POST_203

Line 634: FEM_ENGINES_PKG.User_Message (

630: ,p_token2 => 'TIME'
631: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
632: );
633:
634: FEM_ENGINES_PKG.User_Message (
635: p_app_name => G_FEM
636: ,p_msg_name => G_GL_POST_203
637: ,p_token1 => 'FUNC_NAME'
638: ,p_value1 => l_function_name

Line 879: FEM_ENGINES_PKG.Tech_Message (

875:
876: -------------------------------------------
877: -- Start Procedure Logging and Messaging --
878: -------------------------------------------
879: FEM_ENGINES_PKG.Tech_Message (
880: p_severity => G_LOG_LEVEL_PROCEDURE
881: ,p_module => l_module_name || '.begin'
882: ,p_app_name => G_FEM
883: ,p_msg_name => G_GL_POST_201

Line 962: FEM_ENGINES_PKG.Tech_Message (

958: -- End Procedure Logging and Messaging --
959: -----------------------------------------
960: if x_completion_status = 'NORMAL' then
961:
962: FEM_ENGINES_PKG.Tech_Message (
963: p_severity => G_LOG_LEVEL_PROCEDURE
964: ,p_module => l_module_name||'.end'
965: ,p_app_name => G_FEM
966: ,p_msg_name => G_GL_POST_202

Line 975: FEM_ENGINES_PKG.Tech_Message (

971: );
972:
973: elsif x_completion_status = 'WARNING' then
974:
975: FEM_ENGINES_PKG.Tech_Message (
976: p_severity => G_LOG_LEVEL_PROCEDURE
977: ,p_module => l_module_name||'.end'
978: ,p_app_name => G_FEM
979: ,p_msg_name => G_GL_POST_206

Line 986: FEM_ENGINES_PKG.Tech_Message (

982: x_completion_status := x_completion_status||': '||l_warnings;
983:
984: else
985:
986: FEM_ENGINES_PKG.Tech_Message (
987: p_severity => G_LOG_LEVEL_PROCEDURE
988: ,p_module => l_module_name||'.end'
989: ,p_app_name => G_FEM
990: ,p_msg_name => G_GL_POST_203

Line 1007: FEM_ENGINES_PKG.Tech_Message (

1003: when l_attr_trans_invalid_dim_err then
1004:
1005: rollback;
1006:
1007: FEM_ENGINES_PKG.Tech_Message (
1008: p_severity => G_LOG_LEVEL_EXCEPTION
1009: ,p_module => l_module_name||'.invalid_dimension'
1010: ,p_app_name => G_FEM
1011: ,p_msg_name => G_BI_ATTR_INVALID_DIMENSION

Line 1022: FEM_ENGINES_PKG.Tech_Message (

1018: when others then
1019:
1020: rollback;
1021:
1022: FEM_ENGINES_PKG.Tech_Message (
1023: p_severity => G_LOG_LEVEL_EXCEPTION
1024: ,p_module => l_module_name||'.others'
1025: ,p_app_name => G_FEM
1026: ,p_msg_name => G_GL_POST_215

Line 1124: FEM_ENGINES_PKG.Tech_Message (

1120:
1121: -------------------------------------------
1122: -- Start Procedure Logging and Messaging --
1123: -------------------------------------------
1124: FEM_ENGINES_PKG.Tech_Message (
1125: p_severity => G_LOG_LEVEL_PROCEDURE
1126: ,p_module => l_module_name || '.begin'
1127: ,p_app_name => G_FEM
1128: ,p_msg_name => G_GL_POST_201

Line 1135: FEM_ENGINES_PKG.User_Message (

1131: ,p_token2 => 'TIME'
1132: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
1133: );
1134:
1135: FEM_ENGINES_PKG.User_Message (
1136: p_app_name => G_FEM
1137: ,p_msg_name => G_GL_POST_201
1138: ,p_token1 => 'FUNC_NAME'
1139: ,p_value1 => l_function_name

Line 1397: FEM_ENGINES_PKG.User_Message (

1393: end if;
1394:
1395: if (l_attrd_attr_select is null) then
1396:
1397: FEM_ENGINES_PKG.User_Message (
1398: p_app_name => G_FEM
1399: ,p_msg_name => G_BI_ATTR_NO_ATTRIBUTES_WRN
1400: ,p_token1 => 'DIMENSION'
1401: ,p_value1 => l_function_name

Line 1496: FEM_ENGINES_PKG.Tech_Message (

1492:
1493: -----------------------------------------
1494: -- End Procedure Logging and Messaging --
1495: -----------------------------------------
1496: FEM_ENGINES_PKG.Tech_Message (
1497: p_severity => G_LOG_LEVEL_PROCEDURE
1498: ,p_module => l_module_name || '.end'
1499: ,p_app_name => G_FEM
1500: ,p_msg_name => G_GL_POST_202

Line 1507: FEM_ENGINES_PKG.User_Message (

1503: ,p_token2 => 'TIME'
1504: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
1505: );
1506:
1507: FEM_ENGINES_PKG.User_Message (
1508: p_app_name => G_FEM
1509: ,p_msg_name => G_GL_POST_202
1510: ,p_token1 => 'FUNC_NAME'
1511: ,p_value1 => l_function_name

Line 1524: FEM_ENGINES_PKG.Tech_Message (

1520: when g_mv_create_exception then
1521:
1522: rollback;
1523:
1524: FEM_ENGINES_PKG.Tech_Message (
1525: p_severity => G_LOG_LEVEL_EXCEPTION
1526: ,p_module => l_module_name||'.mv_create_exception'
1527: ,p_app_name => G_FEM
1528: ,p_msg_name => G_GL_POST_203

Line 1535: FEM_ENGINES_PKG.User_Message (

1531: ,p_token2 => 'TIME'
1532: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
1533: );
1534:
1535: FEM_ENGINES_PKG.User_Message (
1536: p_app_name => G_FEM
1537: ,p_msg_name => G_GL_POST_203
1538: ,p_token1 => 'FUNC_NAME'
1539: ,p_value1 => l_function_name

Line 1550: FEM_ENGINES_PKG.Tech_Message (

1546: when others then
1547:
1548: rollback;
1549:
1550: FEM_ENGINES_PKG.Tech_Message (
1551: p_severity => G_LOG_LEVEL_EXCEPTION
1552: ,p_module => l_module_name||'.others'
1553: ,p_app_name => G_FEM
1554: ,p_msg_name => G_GL_POST_215

Line 1559: FEM_ENGINES_PKG.User_Message (

1555: ,p_token1 => 'ERR_MSG'
1556: ,p_value1 => SQLERRM
1557: );
1558:
1559: FEM_ENGINES_PKG.User_Message (
1560: p_app_name => G_FEM
1561: ,p_msg_name => G_GL_POST_215
1562: ,p_token1 => 'ERR_MSG'
1563: ,p_value1 => SQLERRM

Line 1566: FEM_ENGINES_PKG.Tech_Message (

1562: ,p_token1 => 'ERR_MSG'
1563: ,p_value1 => SQLERRM
1564: );
1565:
1566: FEM_ENGINES_PKG.Tech_Message (
1567: p_severity => G_LOG_LEVEL_EXCEPTION
1568: ,p_module => l_module_name||'.others'
1569: ,p_app_name => G_FEM
1570: ,p_msg_name => G_GL_POST_203

Line 1577: FEM_ENGINES_PKG.User_Message (

1573: ,p_token2 => 'TIME'
1574: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
1575: );
1576:
1577: FEM_ENGINES_PKG.User_Message (
1578: p_app_name => G_FEM
1579: ,p_msg_name => G_GL_POST_203
1580: ,p_token1 => 'FUNC_NAME'
1581: ,p_value1 => l_function_name

Line 1664: FEM_ENGINES_PKG.Tech_Message (

1660:
1661: -------------------------------------------
1662: -- Start Procedure Logging and Messaging --
1663: -------------------------------------------
1664: FEM_ENGINES_PKG.Tech_Message (
1665: p_severity => G_LOG_LEVEL_PROCEDURE
1666: ,p_module => l_module_name || '.begin'
1667: ,p_app_name => G_FEM
1668: ,p_msg_name => G_GL_POST_201

Line 1675: FEM_ENGINES_PKG.User_Message (

1671: ,p_token2 => 'TIME'
1672: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
1673: );
1674:
1675: FEM_ENGINES_PKG.User_Message (
1676: p_app_name => G_FEM
1677: ,p_msg_name => G_GL_POST_201
1678: ,p_token1 => 'FUNC_NAME'
1679: ,p_value1 => l_function_name

Line 1701: FEM_ENGINES_PKG.Tech_Message (

1697:
1698: l_dynamic_sql :=
1699: ' DROP MATERIALIZED VIEW '||l_attr_mv_name;
1700:
1701: FEM_ENGINES_PKG.Tech_Message (
1702: p_severity => G_LOG_LEVEL_STATEMENT
1703: ,p_module => l_module_name||'.drop_mv'
1704: ,p_msg_text => l_dynamic_sql
1705: );

Line 1720: FEM_ENGINES_PKG.Tech_Message (

1716: if (G_LOG_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1717:
1718: for i in 0..(round((length(p_attr_query)/4000),0)) loop
1719:
1720: FEM_ENGINES_PKG.Tech_Message (
1721: p_severity => G_LOG_LEVEL_STATEMENT
1722: ,p_module => l_module_name||'.create_v.'||lower(l_attr_v_name)||'.'||i
1723: ,p_msg_text => substr(p_attr_query,4000*i+1,4000)
1724: );

Line 1751: FEM_ENGINES_PKG.Tech_Message (

1747: ' AS '||
1748: ' SELECT *'||
1749: ' FROM '||l_attr_v_name;
1750:
1751: FEM_ENGINES_PKG.Tech_Message (
1752: p_severity => G_LOG_LEVEL_STATEMENT
1753: ,p_module => l_module_name||'.create_mv'
1754: ,p_msg_text => l_dynamic_sql
1755: );

Line 1771: FEM_ENGINES_PKG.Tech_Message (

1767: p_attr_vl_query_select||
1768: ' FROM '||l_attr_mv_name||
1769: ' WHERE LANGUAGE = USERENV(''LANG'')';
1770:
1771: FEM_ENGINES_PKG.Tech_Message (
1772: p_severity => G_LOG_LEVEL_STATEMENT
1773: ,p_module => l_module_name||'.create_vl'
1774: ,p_msg_text => l_dynamic_sql
1775: );

Line 1820: FEM_ENGINES_PKG.Tech_Message (

1816: ' TABLESPACE '||p_index_tablespace||
1817: ' INITRANS 4 MAXTRANS 255 '||
1818: p_storage;
1819:
1820: FEM_ENGINES_PKG.Tech_Message (
1821: p_severity => G_LOG_LEVEL_STATEMENT
1822: ,p_module => l_module_name||'.create_mv_pk'
1823: ,p_msg_text => l_dynamic_sql
1824: );

Line 1842: FEM_ENGINES_PKG.Tech_Message (

1838: ' TABLESPACE '||p_index_tablespace||
1839: ' INITRANS 4 MAXTRANS 255 '||
1840: p_storage;
1841:
1842: FEM_ENGINES_PKG.Tech_Message (
1843: p_severity => G_LOG_LEVEL_STATEMENT
1844: ,p_module => l_module_name||'.create_mv_u1'
1845: ,p_msg_text => l_dynamic_sql
1846: );

Line 1855: FEM_ENGINES_PKG.Tech_Message (

1851:
1852: -----------------------------------
1853: -- Refresh The Materialized View --
1854: -----------------------------------
1855: FEM_ENGINES_PKG.Tech_Message (
1856: p_severity => G_LOG_LEVEL_STATEMENT
1857: ,p_module => l_module_name||'.refresh_mv'
1858: ,p_msg_text => l_attr_mv_name
1859: );

Line 1866: FEM_ENGINES_PKG.Tech_Message (

1862:
1863: -----------------------------------------
1864: -- End Procedure Logging and Messaging --
1865: -----------------------------------------
1866: FEM_ENGINES_PKG.Tech_Message (
1867: p_severity => G_LOG_LEVEL_PROCEDURE
1868: ,p_module => l_module_name || '.end'
1869: ,p_app_name => G_FEM
1870: ,p_msg_name => G_GL_POST_202

Line 1877: FEM_ENGINES_PKG.User_Message (

1873: ,p_token2 => 'TIME'
1874: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
1875: );
1876:
1877: FEM_ENGINES_PKG.User_Message (
1878: p_app_name => G_FEM
1879: ,p_msg_name => G_GL_POST_202
1880: ,p_token1 => 'FUNC_NAME'
1881: ,p_value1 => l_function_name

Line 1892: FEM_ENGINES_PKG.Tech_Message (

1888: when others then
1889:
1890: rollback;
1891:
1892: FEM_ENGINES_PKG.Tech_Message (
1893: p_severity => G_LOG_LEVEL_EXCEPTION
1894: ,p_module => l_module_name||'.others'
1895: ,p_app_name => G_FEM
1896: ,p_msg_name => G_GL_POST_215

Line 1901: FEM_ENGINES_PKG.User_Message (

1897: ,p_token1 => 'ERR_MSG'
1898: ,p_value1 => SQLERRM
1899: );
1900:
1901: FEM_ENGINES_PKG.User_Message (
1902: p_app_name => G_FEM
1903: ,p_msg_name => G_GL_POST_215
1904: ,p_token1 => 'ERR_MSG'
1905: ,p_value1 => SQLERRM

Line 1908: FEM_ENGINES_PKG.Tech_Message (

1904: ,p_token1 => 'ERR_MSG'
1905: ,p_value1 => SQLERRM
1906: );
1907:
1908: FEM_ENGINES_PKG.Tech_Message (
1909: p_severity => G_LOG_LEVEL_EXCEPTION
1910: ,p_module => l_module_name||'.others'
1911: ,p_app_name => G_FEM
1912: ,p_msg_name => G_GL_POST_203

Line 1919: FEM_ENGINES_PKG.User_Message (

1915: ,p_token2 => 'TIME'
1916: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
1917: );
1918:
1919: FEM_ENGINES_PKG.User_Message (
1920: p_app_name => G_FEM
1921: ,p_msg_name => G_GL_POST_203
1922: ,p_token1 => 'FUNC_NAME'
1923: ,p_value1 => l_function_name

Line 2005: FEM_ENGINES_PKG.Tech_Message (

2001:
2002: -------------------------------------------
2003: -- Start Procedure Logging and Messaging --
2004: -------------------------------------------
2005: FEM_ENGINES_PKG.Tech_Message (
2006: p_severity => G_LOG_LEVEL_PROCEDURE
2007: ,p_module => l_module_name || '.begin'
2008: ,p_app_name => G_FEM
2009: ,p_msg_name => G_GL_POST_201

Line 2016: FEM_ENGINES_PKG.User_Message (

2012: ,p_token2 => 'TIME'
2013: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
2014: );
2015:
2016: FEM_ENGINES_PKG.User_Message (
2017: p_app_name => G_FEM
2018: ,p_msg_name => G_GL_POST_201
2019: ,p_token1 => 'FUNC_NAME'
2020: ,p_value1 => l_function_name

Line 2209: FEM_ENGINES_PKG.Tech_Message (

2205: ));
2206:
2207: if (G_LOG_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2208:
2209: FEM_ENGINES_PKG.Tech_Message (
2210: p_severity => G_LOG_LEVEL_STATEMENT
2211: ,p_module => l_module_name||'.'||l_attr_col||'.attrn'
2212: ,p_msg_text => l_attrn_sql_stmt
2213: );

Line 2215: FEM_ENGINES_PKG.Tech_Message (

2211: ,p_module => l_module_name||'.'||l_attr_col||'.attrn'
2212: ,p_msg_text => l_attrn_sql_stmt
2213: );
2214:
2215: FEM_ENGINES_PKG.Tech_Message (
2216: p_severity => G_LOG_LEVEL_STATEMENT
2217: ,p_module => l_module_name||'.'||l_attr_col||'.attrd'
2218: ,p_msg_text => l_attrd_sql_stmt
2219: );

Line 2263: FEM_ENGINES_PKG.Tech_Message (

2259:
2260: -----------------------------------------
2261: -- End Procedure Logging and Messaging --
2262: -----------------------------------------
2263: FEM_ENGINES_PKG.Tech_Message (
2264: p_severity => G_LOG_LEVEL_PROCEDURE
2265: ,p_module => l_module_name || '.end'
2266: ,p_app_name => G_FEM
2267: ,p_msg_name => G_GL_POST_202

Line 2274: FEM_ENGINES_PKG.User_Message (

2270: ,p_token2 => 'TIME'
2271: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
2272: );
2273:
2274: FEM_ENGINES_PKG.User_Message (
2275: p_app_name => G_FEM
2276: ,p_msg_name => G_GL_POST_202
2277: ,p_token1 => 'FUNC_NAME'
2278: ,p_value1 => l_function_name

Line 2289: FEM_ENGINES_PKG.Tech_Message (

2285: when others then
2286:
2287: rollback;
2288:
2289: FEM_ENGINES_PKG.Tech_Message (
2290: p_severity => G_LOG_LEVEL_EXCEPTION
2291: ,p_module => l_module_name||'.others'
2292: ,p_app_name => G_FEM
2293: ,p_msg_name => G_GL_POST_215

Line 2298: FEM_ENGINES_PKG.User_Message (

2294: ,p_token1 => 'ERR_MSG'
2295: ,p_value1 => SQLERRM
2296: );
2297:
2298: FEM_ENGINES_PKG.User_Message (
2299: p_app_name => G_FEM
2300: ,p_msg_name => G_GL_POST_215
2301: ,p_token1 => 'ERR_MSG'
2302: ,p_value1 => SQLERRM

Line 2305: FEM_ENGINES_PKG.Tech_Message (

2301: ,p_token1 => 'ERR_MSG'
2302: ,p_value1 => SQLERRM
2303: );
2304:
2305: FEM_ENGINES_PKG.Tech_Message (
2306: p_severity => G_LOG_LEVEL_EXCEPTION
2307: ,p_module => l_module_name||'.others'
2308: ,p_app_name => G_FEM
2309: ,p_msg_name => G_GL_POST_203

Line 2316: FEM_ENGINES_PKG.User_Message (

2312: ,p_token2 => 'TIME'
2313: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
2314: );
2315:
2316: FEM_ENGINES_PKG.User_Message (
2317: p_app_name => G_FEM
2318: ,p_msg_name => G_GL_POST_203
2319: ,p_token1 => 'FUNC_NAME'
2320: ,p_value1 => l_function_name

Line 2411: FEM_ENGINES_PKG.Tech_Message (

2407:
2408: -------------------------------------------
2409: -- Start Procedure Logging and Messaging --
2410: -------------------------------------------
2411: FEM_ENGINES_PKG.Tech_Message (
2412: p_severity => G_LOG_LEVEL_PROCEDURE
2413: ,p_module => l_module_name || '.begin'
2414: ,p_app_name => G_FEM
2415: ,p_msg_name => G_GL_POST_201

Line 2422: FEM_ENGINES_PKG.User_Message (

2418: ,p_token2 => 'TIME'
2419: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
2420: );
2421:
2422: FEM_ENGINES_PKG.User_Message (
2423: p_app_name => G_FEM
2424: ,p_msg_name => G_GL_POST_201
2425: ,p_token1 => 'FUNC_NAME'
2426: ,p_value1 => l_function_name

Line 2657: FEM_ENGINES_PKG.Tech_Message (

2653: ));
2654:
2655: if (G_LOG_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2656:
2657: FEM_ENGINES_PKG.Tech_Message (
2658: p_severity => G_LOG_LEVEL_STATEMENT
2659: ,p_module => l_module_name||'.'||l_attr_col||'.attrd'
2660: ,p_msg_text => l_attrd_sql_stmt
2661: );

Line 2663: FEM_ENGINES_PKG.Tech_Message (

2659: ,p_module => l_module_name||'.'||l_attr_col||'.attrd'
2660: ,p_msg_text => l_attrd_sql_stmt
2661: );
2662:
2663: FEM_ENGINES_PKG.Tech_Message (
2664: p_severity => G_LOG_LEVEL_STATEMENT
2665: ,p_module => l_module_name||'.'||l_attr_col||'.attrn'
2666: ,p_msg_text => l_attrn_sql_stmt
2667: );

Line 2713: FEM_ENGINES_PKG.Tech_Message (

2709:
2710: -----------------------------------------
2711: -- End Procedure Logging and Messaging --
2712: -----------------------------------------
2713: FEM_ENGINES_PKG.Tech_Message (
2714: p_severity => G_LOG_LEVEL_PROCEDURE
2715: ,p_module => l_module_name || '.end'
2716: ,p_app_name => G_FEM
2717: ,p_msg_name => G_GL_POST_202

Line 2724: FEM_ENGINES_PKG.User_Message (

2720: ,p_token2 => 'TIME'
2721: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
2722: );
2723:
2724: FEM_ENGINES_PKG.User_Message (
2725: p_app_name => G_FEM
2726: ,p_msg_name => G_GL_POST_202
2727: ,p_token1 => 'FUNC_NAME'
2728: ,p_value1 => l_function_name

Line 2739: FEM_ENGINES_PKG.Tech_Message (

2735: when others then
2736:
2737: rollback;
2738:
2739: FEM_ENGINES_PKG.Tech_Message (
2740: p_severity => G_LOG_LEVEL_EXCEPTION
2741: ,p_module => l_module_name||'.others'
2742: ,p_app_name => G_FEM
2743: ,p_msg_name => G_GL_POST_215

Line 2748: FEM_ENGINES_PKG.User_Message (

2744: ,p_token1 => 'ERR_MSG'
2745: ,p_value1 => SQLERRM
2746: );
2747:
2748: FEM_ENGINES_PKG.User_Message (
2749: p_app_name => G_FEM
2750: ,p_msg_name => G_GL_POST_215
2751: ,p_token1 => 'ERR_MSG'
2752: ,p_value1 => SQLERRM

Line 2755: FEM_ENGINES_PKG.Tech_Message (

2751: ,p_token1 => 'ERR_MSG'
2752: ,p_value1 => SQLERRM
2753: );
2754:
2755: FEM_ENGINES_PKG.Tech_Message (
2756: p_severity => G_LOG_LEVEL_EXCEPTION
2757: ,p_module => l_module_name||'.others'
2758: ,p_app_name => G_FEM
2759: ,p_msg_name => G_GL_POST_203

Line 2766: FEM_ENGINES_PKG.User_Message (

2762: ,p_token2 => 'TIME'
2763: ,p_value2 => to_char(sysdate)||' '||to_char(sysdate,'HH24:MI:SS')
2764: );
2765:
2766: FEM_ENGINES_PKG.User_Message (
2767: p_app_name => G_FEM
2768: ,p_msg_name => G_GL_POST_203
2769: ,p_token1 => 'FUNC_NAME'
2770: ,p_value1 => l_function_name