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_WEBADI_TABLES_UTILS_PVT dependencies on FND_MESSAGE

Line 329: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_MISSING_MAPPING');

325: l_no_map_columns := substr(l_no_map_columns,1,length(l_no_map_columns)-2);
326:
327: if (l_no_intf_col_map_flag = 'Y') then
328: if(p_mode <> 'N')then
329: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_MISSING_MAPPING');
330: FND_MESSAGE.SET_TOKEN('COLUMNS',l_no_map_columns);
331: l_log_string := FND_MESSAGE.GET;
332: fnd_file.put_line(fnd_file.log,l_log_string);
333: else

Line 330: FND_MESSAGE.SET_TOKEN('COLUMNS',l_no_map_columns);

326:
327: if (l_no_intf_col_map_flag = 'Y') then
328: if(p_mode <> 'N')then
329: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_MISSING_MAPPING');
330: FND_MESSAGE.SET_TOKEN('COLUMNS',l_no_map_columns);
331: l_log_string := FND_MESSAGE.GET;
332: fnd_file.put_line(fnd_file.log,l_log_string);
333: else
334: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_MISSING_MAPPING');

Line 331: l_log_string := FND_MESSAGE.GET;

327: if (l_no_intf_col_map_flag = 'Y') then
328: if(p_mode <> 'N')then
329: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_MISSING_MAPPING');
330: FND_MESSAGE.SET_TOKEN('COLUMNS',l_no_map_columns);
331: l_log_string := FND_MESSAGE.GET;
332: fnd_file.put_line(fnd_file.log,l_log_string);
333: else
334: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_MISSING_MAPPING');
335: FND_MESSAGE.SET_TOKEN('COLUMNS',l_no_map_columns);

Line 334: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_MISSING_MAPPING');

330: FND_MESSAGE.SET_TOKEN('COLUMNS',l_no_map_columns);
331: l_log_string := FND_MESSAGE.GET;
332: fnd_file.put_line(fnd_file.log,l_log_string);
333: else
334: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_MISSING_MAPPING');
335: FND_MESSAGE.SET_TOKEN('COLUMNS',l_no_map_columns);
336: FND_MSG_PUB.add;
337: end if;
338: raise e_no_intf_col_map;

Line 335: FND_MESSAGE.SET_TOKEN('COLUMNS',l_no_map_columns);

331: l_log_string := FND_MESSAGE.GET;
332: fnd_file.put_line(fnd_file.log,l_log_string);
333: else
334: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_MISSING_MAPPING');
335: FND_MESSAGE.SET_TOKEN('COLUMNS',l_no_map_columns);
336: FND_MSG_PUB.add;
337: end if;
338: raise e_no_intf_col_map;
339: end if;

Line 1627: FND_MESSAGE_NAME VARCHAR2(30) ,

1623: UPLOAD_PARAM_LIST_ITEM_NUM NUMBER(15) ,
1624: SEQUENCE_NUM NUMBER(15) ,
1625: LOV_TYPE VARCHAR2(30) ,
1626: OFFLINE_LOV_ENABLED_FLAG VARCHAR2(1) ,
1627: FND_MESSAGE_NAME VARCHAR2(30) ,
1628: USER_HINT_FND_MESSAGE_NAME VARCHAR2(30)
1629: );
1630:
1631: TYPE l_interface_cols_typ IS TABLE OF l_interface_col_rec

Line 1628: USER_HINT_FND_MESSAGE_NAME VARCHAR2(30)

1624: SEQUENCE_NUM NUMBER(15) ,
1625: LOV_TYPE VARCHAR2(30) ,
1626: OFFLINE_LOV_ENABLED_FLAG VARCHAR2(1) ,
1627: FND_MESSAGE_NAME VARCHAR2(30) ,
1628: USER_HINT_FND_MESSAGE_NAME VARCHAR2(30)
1629: );
1630:
1631: TYPE l_interface_cols_typ IS TABLE OF l_interface_col_rec
1632: INDEX BY BINARY_INTEGER;

Line 1681: l_interface_cols_tbl(1).FND_MESSAGE_NAME := 'FEM_ADI_TABLE_NAME';

1677: l_interface_cols_tbl(1).UPLOAD_PARAM_LIST_ITEM_NUM := 1;
1678: l_interface_cols_tbl(1).SEQUENCE_NUM := 1;
1679: l_interface_cols_tbl(1).LOV_TYPE := NULL;
1680: l_interface_cols_tbl(1).OFFLINE_LOV_ENABLED_FLAG := NULL;
1681: l_interface_cols_tbl(1).FND_MESSAGE_NAME := 'FEM_ADI_TABLE_NAME';
1682: l_interface_cols_tbl(1).USER_HINT_FND_MESSAGE_NAME := NULL;
1683:
1684: -----------------------------------------------------------------------------
1685: -- Set up for column TABLE_GROUP_VALIDATOR

Line 1682: l_interface_cols_tbl(1).USER_HINT_FND_MESSAGE_NAME := NULL;

1678: l_interface_cols_tbl(1).SEQUENCE_NUM := 1;
1679: l_interface_cols_tbl(1).LOV_TYPE := NULL;
1680: l_interface_cols_tbl(1).OFFLINE_LOV_ENABLED_FLAG := NULL;
1681: l_interface_cols_tbl(1).FND_MESSAGE_NAME := 'FEM_ADI_TABLE_NAME';
1682: l_interface_cols_tbl(1).USER_HINT_FND_MESSAGE_NAME := NULL;
1683:
1684: -----------------------------------------------------------------------------
1685: -- Set up for column TABLE_GROUP_VALIDATOR
1686: -----------------------------------------------------------------------------

Line 1711: l_interface_cols_tbl(2).FND_MESSAGE_NAME := NULL;

1707: l_interface_cols_tbl(2).UPLOAD_PARAM_LIST_ITEM_NUM := NULL;
1708: l_interface_cols_tbl(2).SEQUENCE_NUM := 2;
1709: l_interface_cols_tbl(2).LOV_TYPE := 'NONE';
1710: l_interface_cols_tbl(2).OFFLINE_LOV_ENABLED_FLAG := 'N';
1711: l_interface_cols_tbl(2).FND_MESSAGE_NAME := NULL;
1712: l_interface_cols_tbl(2).USER_HINT_FND_MESSAGE_NAME := NULL;
1713:
1714: -----------------------------------------------------------------------------
1715: -- Set up for column P_LEDGER_DISPLAY_CODE

Line 1712: l_interface_cols_tbl(2).USER_HINT_FND_MESSAGE_NAME := NULL;

1708: l_interface_cols_tbl(2).SEQUENCE_NUM := 2;
1709: l_interface_cols_tbl(2).LOV_TYPE := 'NONE';
1710: l_interface_cols_tbl(2).OFFLINE_LOV_ENABLED_FLAG := 'N';
1711: l_interface_cols_tbl(2).FND_MESSAGE_NAME := NULL;
1712: l_interface_cols_tbl(2).USER_HINT_FND_MESSAGE_NAME := NULL;
1713:
1714: -----------------------------------------------------------------------------
1715: -- Set up for column P_LEDGER_DISPLAY_CODE
1716: -----------------------------------------------------------------------------

Line 1741: l_interface_cols_tbl(3).FND_MESSAGE_NAME := 'FEM_ADI_LEDGER_NAME';

1737: l_interface_cols_tbl(3).UPLOAD_PARAM_LIST_ITEM_NUM := 2;
1738: l_interface_cols_tbl(3).SEQUENCE_NUM := 3;
1739: l_interface_cols_tbl(3).LOV_TYPE := 'STANDARD';
1740: l_interface_cols_tbl(3).OFFLINE_LOV_ENABLED_FLAG := 'Y';
1741: l_interface_cols_tbl(3).FND_MESSAGE_NAME := 'FEM_ADI_LEDGER_NAME';
1742: l_interface_cols_tbl(3).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';
1743:
1744: -----------------------------------------------------------------------------
1745: -- Set up for column P_CAL_PERIOD

Line 1742: l_interface_cols_tbl(3).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';

1738: l_interface_cols_tbl(3).SEQUENCE_NUM := 3;
1739: l_interface_cols_tbl(3).LOV_TYPE := 'STANDARD';
1740: l_interface_cols_tbl(3).OFFLINE_LOV_ENABLED_FLAG := 'Y';
1741: l_interface_cols_tbl(3).FND_MESSAGE_NAME := 'FEM_ADI_LEDGER_NAME';
1742: l_interface_cols_tbl(3).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';
1743:
1744: -----------------------------------------------------------------------------
1745: -- Set up for column P_CAL_PERIOD
1746: -----------------------------------------------------------------------------

Line 1771: l_interface_cols_tbl(4).FND_MESSAGE_NAME := 'FEM_ADI_CAL_PERIOD_NAME';

1767: l_interface_cols_tbl(4).UPLOAD_PARAM_LIST_ITEM_NUM := 3;
1768: l_interface_cols_tbl(4).SEQUENCE_NUM := 4;
1769: l_interface_cols_tbl(4).LOV_TYPE := 'STANDARD';
1770: l_interface_cols_tbl(4).OFFLINE_LOV_ENABLED_FLAG := 'Y';
1771: l_interface_cols_tbl(4).FND_MESSAGE_NAME := 'FEM_ADI_CAL_PERIOD_NAME';
1772: l_interface_cols_tbl(4).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';
1773:
1774: -----------------------------------------------------------------------------
1775: -- Set up for column P_DATASET_DISPLAY_CODE

Line 1772: l_interface_cols_tbl(4).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';

1768: l_interface_cols_tbl(4).SEQUENCE_NUM := 4;
1769: l_interface_cols_tbl(4).LOV_TYPE := 'STANDARD';
1770: l_interface_cols_tbl(4).OFFLINE_LOV_ENABLED_FLAG := 'Y';
1771: l_interface_cols_tbl(4).FND_MESSAGE_NAME := 'FEM_ADI_CAL_PERIOD_NAME';
1772: l_interface_cols_tbl(4).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';
1773:
1774: -----------------------------------------------------------------------------
1775: -- Set up for column P_DATASET_DISPLAY_CODE
1776: -----------------------------------------------------------------------------

Line 1801: l_interface_cols_tbl(5).FND_MESSAGE_NAME := 'FEM_ADI_DATASET_NAME';

1797: l_interface_cols_tbl(5).UPLOAD_PARAM_LIST_ITEM_NUM := 4;
1798: l_interface_cols_tbl(5).SEQUENCE_NUM := 5;
1799: l_interface_cols_tbl(5).LOV_TYPE := 'STANDARD';
1800: l_interface_cols_tbl(5).OFFLINE_LOV_ENABLED_FLAG := 'Y';
1801: l_interface_cols_tbl(5).FND_MESSAGE_NAME := 'FEM_ADI_DATASET_NAME';
1802: l_interface_cols_tbl(5).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';
1803:
1804: -----------------------------------------------------------------------------
1805: -- Set up for column P_SOURCE_SYSTEM_DISPLAY_CODE

Line 1802: l_interface_cols_tbl(5).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';

1798: l_interface_cols_tbl(5).SEQUENCE_NUM := 5;
1799: l_interface_cols_tbl(5).LOV_TYPE := 'STANDARD';
1800: l_interface_cols_tbl(5).OFFLINE_LOV_ENABLED_FLAG := 'Y';
1801: l_interface_cols_tbl(5).FND_MESSAGE_NAME := 'FEM_ADI_DATASET_NAME';
1802: l_interface_cols_tbl(5).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';
1803:
1804: -----------------------------------------------------------------------------
1805: -- Set up for column P_SOURCE_SYSTEM_DISPLAY_CODE
1806: -----------------------------------------------------------------------------

Line 1831: l_interface_cols_tbl(6).FND_MESSAGE_NAME := 'FEM_ADI_SOURCE_SYSTEM_NAME';

1827: l_interface_cols_tbl(6).UPLOAD_PARAM_LIST_ITEM_NUM := 5;
1828: l_interface_cols_tbl(6).SEQUENCE_NUM := 6;
1829: l_interface_cols_tbl(6).LOV_TYPE := 'STANDARD';
1830: l_interface_cols_tbl(6).OFFLINE_LOV_ENABLED_FLAG := 'Y';
1831: l_interface_cols_tbl(6).FND_MESSAGE_NAME := 'FEM_ADI_SOURCE_SYSTEM_NAME';
1832: l_interface_cols_tbl(6).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';
1833:
1834: -----------------------------------------------------------------------------
1835: -- Inserting into BNE_INTERFACE_COLS and BNE_INTERFACE_COLS_TL

Line 1832: l_interface_cols_tbl(6).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';

1828: l_interface_cols_tbl(6).SEQUENCE_NUM := 6;
1829: l_interface_cols_tbl(6).LOV_TYPE := 'STANDARD';
1830: l_interface_cols_tbl(6).OFFLINE_LOV_ENABLED_FLAG := 'Y';
1831: l_interface_cols_tbl(6).FND_MESSAGE_NAME := 'FEM_ADI_SOURCE_SYSTEM_NAME';
1832: l_interface_cols_tbl(6).USER_HINT_FND_MESSAGE_NAME := 'FEM_ADI_USER_HINT_LOV_REQ';
1833:
1834: -----------------------------------------------------------------------------
1835: -- Inserting into BNE_INTERFACE_COLS and BNE_INTERFACE_COLS_TL
1836: -----------------------------------------------------------------------------

Line 1962: AND M1.MESSAGE_NAME (+)= l_interface_cols_tbl(i).FND_MESSAGE_NAME

1958: FROM FND_NEW_MESSAGES M1,
1959: FND_NEW_MESSAGES M2,
1960: FND_LANGUAGES L
1961: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1962: AND M1.MESSAGE_NAME (+)= l_interface_cols_tbl(i).FND_MESSAGE_NAME
1963: AND M1.LANGUAGE_CODE (+)= L.LANGUAGE_CODE
1964: AND M2.MESSAGE_NAME (+)= l_interface_cols_tbl(i).USER_HINT_FND_MESSAGE_NAME
1965: AND M2.LANGUAGE_CODE (+)= L.LANGUAGE_CODE;
1966:

Line 1964: AND M2.MESSAGE_NAME (+)= l_interface_cols_tbl(i).USER_HINT_FND_MESSAGE_NAME

1960: FND_LANGUAGES L
1961: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1962: AND M1.MESSAGE_NAME (+)= l_interface_cols_tbl(i).FND_MESSAGE_NAME
1963: AND M1.LANGUAGE_CODE (+)= L.LANGUAGE_CODE
1964: AND M2.MESSAGE_NAME (+)= l_interface_cols_tbl(i).USER_HINT_FND_MESSAGE_NAME
1965: AND M2.LANGUAGE_CODE (+)= L.LANGUAGE_CODE;
1966:
1967: END LOOP;
1968:

Line 2770: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DUPLICATE_ROWS');

2766:
2767: EXCEPTION
2768: --
2769: WHEN DUP_VAL_ON_INDEX THEN
2770: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DUPLICATE_ROWS');
2771: APP_EXCEPTION.Raise_Exception ;
2772:
2773: WHEN INVALID_NUMBER THEN
2774:

Line 2778: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_INVALID_NUMBER');

2774:
2775: select PROMPT_ABOVE into l_column_name from bne_interface_cols_vl where
2776: interface_code = l_interface_code and interface_col_name = l_column_name;
2777:
2778: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_INVALID_NUMBER');
2779: FND_MESSAGE.SET_TOKEN('COLUMN_NAME',l_column_name);
2780: APP_EXCEPTION.Raise_Exception ;
2781:
2782:

Line 2779: FND_MESSAGE.SET_TOKEN('COLUMN_NAME',l_column_name);

2775: select PROMPT_ABOVE into l_column_name from bne_interface_cols_vl where
2776: interface_code = l_interface_code and interface_col_name = l_column_name;
2777:
2778: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_INVALID_NUMBER');
2779: FND_MESSAGE.SET_TOKEN('COLUMN_NAME',l_column_name);
2780: APP_EXCEPTION.Raise_Exception ;
2781:
2782:
2783: WHEN E_NO_TABLE THEN