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

Line 1152: /*FEM_ENGINES_PKG.Put_Message(

1148: CURSOR l_cur_tables IS select table_name from ftp_tp_proc_tabls_params
1149: where object_definition_id = process_info.obj_id and job_id = p_job_id;
1150:
1151: BEGIN
1152: /*FEM_ENGINES_PKG.Put_Message(
1153: p_app_name => 'FTP',
1154: p_msg_name => 'START_PROCESS_LOCKS.BEGIN',
1155: p_token1 => 'OBJ_ID',
1156: p_value1 => p_object_id,

Line 1175: /*FEM_ENGINES_PKG.Put_Message(

1171: --Get the output dataset code for the given IODD
1172: select output_dataset_code into l_output_ds from fem_ds_input_output_defs
1173: where dataset_io_obj_def_id = p_dataset_def_id;
1174:
1175: /*FEM_ENGINES_PKG.Put_Message(
1176: p_app_name => 'FTP',
1177: p_msg_name => 'START_PROCESS_LOCKS',
1178: p_token1 => 'OUT_DS',
1179: p_value1 => l_output_ds

Line 1194: /*FEM_ENGINES_PKG.Put_Message(

1190: IF l_condition_id = 0 THEN
1191: l_condition_id := NULL;
1192: END IF;
1193:
1194: /*FEM_ENGINES_PKG.Put_Message(
1195: p_app_name => 'FTP',
1196: p_msg_name => 'START_PROCESS_LOCKS',
1197: p_token1 => 'COND_ID',
1198: p_value1 => l_condition_id

Line 1222: /*FEM_ENGINES_PKG.Put_Message(

1218: x_msg_data => x_msg_data,
1219: x_return_status => x_return_status
1220: );
1221:
1222: /*FEM_ENGINES_PKG.Put_Message(
1223: p_app_name => 'FTP',
1224: p_msg_name => 'AFTER REGISTER REQUEST',
1225: p_token1 => 'MSG_COUNT',
1226: p_value1 => x_msg_count,

Line 1242: /*FEM_ENGINES_PKG.Put_Message(

1238: CLOSE l_cur_tables;
1239:
1240: l_date_str := FND_DATE.date_to_canonical(p_effective_date);
1241:
1242: /*FEM_ENGINES_PKG.Put_Message(
1243: p_app_name => 'FTP',
1244: p_msg_name => 'IN START PROCESS LOCK',
1245: p_token1 => 'DATE_STR',
1246: p_value1 => l_date_str

Line 1256: /*FEM_ENGINES_PKG.Put_Message(

1252: l_data_table := l_table_names(i);
1253: IF (l_condition_id IS NOT NULL)
1254: THEN
1255: l_condition_sql := NULL;
1256: /*FEM_ENGINES_PKG.Put_Message(
1257: p_app_name => 'FTP',
1258: p_msg_name => 'IN START PROCESS LOCK',
1259: p_token1 => 'TABLE_NAME',
1260: p_value1 => l_data_table,

Line 1285: FEM_ENGINES_PKG.Put_Message(

1281: l_tbl_alias, 'N', 'BOTH', 'Y',
1282: l_condition_sql );
1283: EXCEPTION
1284: when others then
1285: FEM_ENGINES_PKG.Put_Message(
1286: p_app_name => 'FTP',
1287: p_msg_name => 'WCLAUSE EXCEPTION',
1288: p_token1 => 'TABLE_NAME',
1289: p_value1 => l_data_table,

Line 1296: /*FEM_ENGINES_PKG.Put_Message(

1292: );
1293: END;
1294:
1295: END IF;
1296: /*FEM_ENGINES_PKG.Put_Message(
1297: p_app_name => 'FTP',
1298: p_msg_name => 'AFTER CALL TO CONDITIONS API',
1299: p_token1 => 'OBJ_ID',
1300: p_value1 => p_object_id,

Line 1321: /*FEM_ENGINES_PKG.Put_Message(

1317: );
1318:
1319:
1320: IF x_exec_lock_exists = 'T' THEN
1321: /*FEM_ENGINES_PKG.Put_Message(
1322: p_app_name => 'FTP',
1323: p_msg_name => 'AFTER CHAINING EXISTS',
1324: p_token1 => 'CAL_ID',
1325: p_value1 => p_cal_period_id

Line 1454: /*FEM_ENGINES_PKG.Put_Message(

1450: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453:
1454: /*FEM_ENGINES_PKG.Put_Message(
1455: p_app_name => 'FTP',
1456: p_msg_name => 'AFTER register_table END',
1457: p_token1 => 'MSG_COUNT',
1458: p_value1 => x_msg_count,

Line 1482: FEM_ENGINES_PKG.Put_Message(

1478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1479: l_msg := SUBSTR(SQLERRM, 1, 300);
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481:
1482: FEM_ENGINES_PKG.Put_Message(
1483: p_app_name => 'FTP',
1484: p_msg_name => 'UNEXP EXCEPTION',
1485: p_token1 => 'SQLERRM',
1486: p_value1 => l_msg

Line 1500: FEM_ENGINES_PKG.Put_Message(

1496:
1497: --DBMS_OUTPUT.PUT_LINE(l_msg);
1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1499:
1500: FEM_ENGINES_PKG.Put_Message(
1501: p_app_name => 'FTP',
1502: p_msg_name => 'UNEXP EXCEPTION',
1503: p_token1 => 'DATE',
1504: p_value1 => trunc(p_effective_date),

Line 1604: FEM_ENGINES_PKG.TECH_MESSAGE(

1600: l_output_cnt := 0;
1601: l_b_data_location := FALSE;
1602:
1603:
1604: FEM_ENGINES_PKG.TECH_MESSAGE(
1605: p_severity => fnd_log.level_error,
1606: p_module => g_block || '.STOP_PROCESS_LOCKS',
1607: p_msg_text => 'valid_table_list= '|| valid_table_list ||' g_alt_rate_obj.COUNT=' || g_alt_rate_obj.COUNT
1608: );

Line 1645: FEM_ENGINES_PKG.TECH_MESSAGE(

1641: select length(modify_valid_table_list) into len from dual;
1642: select substr(modify_valid_table_list,0,pos-1) into token from dual;
1643: select LTRIM(RTRIM(token,''''),'''') into token from dual;
1644:
1645: FEM_ENGINES_PKG.TECH_MESSAGE(
1646: p_severity => fnd_log.level_error,
1647: p_module => g_block || '.tokens_generation',
1648: p_msg_text => 'token =' || token
1649: );

Line 1653: FEM_ENGINES_PKG.TECH_MESSAGE(

1649: );
1650:
1651: l_table_names(i) := token;
1652:
1653: FEM_ENGINES_PKG.TECH_MESSAGE(
1654: p_severity => fnd_log.level_error,
1655: p_module => g_block || '.tokens_generation',
1656: p_msg_text => 'Before substr modify_valid_table_list= '|| modify_valid_table_list
1657: );

Line 1661: FEM_ENGINES_PKG.TECH_MESSAGE(

1657: );
1658:
1659: select substr(modify_valid_table_list,pos+1,len) into modify_valid_table_list from dual;
1660:
1661: FEM_ENGINES_PKG.TECH_MESSAGE(
1662: p_severity => fnd_log.level_error,
1663: p_module => g_block || '.tokens_generation',
1664: p_msg_text => 'After substr modify_valid_table_list= '|| modify_valid_table_list
1665: );

Line 1678: FEM_ENGINES_PKG.TECH_MESSAGE(

1674: END IF;
1675:
1676: l_date_str := FND_DATE.date_to_canonical(p_effective_date);
1677:
1678: FEM_ENGINES_PKG.TECH_MESSAGE(
1679: p_severity => fnd_log.level_error,
1680: p_module => g_block || '.l_table_names preparation ready',
1681: p_msg_text => 'l_table_names.COUNT = '|| l_table_names.COUNT || 'l_table_names(1) =' || l_table_names(1)
1682: );

Line 1687: FEM_ENGINES_PKG.TECH_MESSAGE(

1683:
1684: FOR i IN 1..l_table_names.COUNT
1685: LOOP
1686:
1687: FEM_ENGINES_PKG.TECH_MESSAGE(
1688: p_severity => fnd_log.level_error,
1689: p_module => g_block || '.after tokenizing iterating in l_table_names',
1690: p_msg_text => 'l_table_names(i) =' || l_table_names(i)
1691: );

Line 1716: FEM_ENGINES_PKG.Put_Message(

1712: l_tbl_alias, 'N', 'BOTH', 'Y',
1713: l_condition_sql );
1714: EXCEPTION
1715: when others then
1716: FEM_ENGINES_PKG.Put_Message(
1717: p_app_name => 'FTP',
1718: p_msg_name => 'WCLAUSE EXCEPTION',
1719: p_token1 => 'TABLE_NAME',
1720: p_value1 => l_table_names(i),

Line 1777: FEM_ENGINES_PKG.TECH_MESSAGE(

1773: where object_definition_id = process_info.obj_id and job_id = p_job_id;
1774:
1775: FOR j IN 1..g_alt_rate_obj.COUNT
1776: LOOP
1777: FEM_ENGINES_PKG.TECH_MESSAGE(
1778: p_severity => fnd_log.level_error,
1779: p_module => g_block || '.accessing g_alt_rate_obj',
1780: p_msg_text => 'g_alt_rate_obj(j).Account_Table_Name = ' || g_alt_rate_obj(j).Account_Table_Name
1781: );

Line 1834: FEM_ENGINES_PKG.TECH_MESSAGE(

1830: -- Set the statement type
1831: l_stmt_type := 'UPDATE';
1832: FOR j IN 1..9 LOOP
1833:
1834: FEM_ENGINES_PKG.TECH_MESSAGE(
1835: p_severity => fnd_log.level_error,
1836: p_module => g_block || '.REGISTER_UPDATED_COLUMN',
1837: p_msg_text => 'before REGISTER_UPDATED_COLUMN j = ' || j ||' l_col_names(j)=' ||l_col_names(j)
1838: );

Line 1880: FEM_ENGINES_PKG.TECH_MESSAGE(

1876: x_msg_data => x_msg_data,
1877: x_return_status => x_return_status
1878: );
1879:
1880: FEM_ENGINES_PKG.TECH_MESSAGE(
1881: p_severity => fnd_log.level_error,
1882: p_module => g_block || '.debugg error',
1883: p_msg_text => 'Error Mesg 1'
1884: );

Line 1898: FEM_ENGINES_PKG.TECH_MESSAGE(

1894: -- Register teh FTP_TP_PP_NODE_MAP and FTP_TP_PP_NODE_HEADER info
1895: select count(*) into l_output_cnt from FTP_TP_PP_NODE_HEADER
1896: where created_by_object_id = OBJECT_ID and created_by_request_id = REQUEST_ID;
1897:
1898: FEM_ENGINES_PKG.TECH_MESSAGE(
1899: p_severity => fnd_log.level_error,
1900: p_module => g_block || '.debugg error',
1901: p_msg_text => 'Error Mesg 2'
1902: );

Line 1918: FEM_ENGINES_PKG.TECH_MESSAGE(

1914: x_msg_data => x_msg_data,
1915: x_return_status => x_return_status
1916: );
1917:
1918: FEM_ENGINES_PKG.TECH_MESSAGE(
1919: p_severity => fnd_log.level_error,
1920: p_module => g_block || '.debugg error',
1921: p_msg_text => 'Error Mesg 3'
1922: );

Line 1931: FEM_ENGINES_PKG.TECH_MESSAGE(

1927:
1928: select count(*) into l_output_cnt from FTP_TP_PP_NODE_MAP
1929: where created_by_object_id = OBJECT_ID and created_by_request_id = REQUEST_ID;
1930:
1931: FEM_ENGINES_PKG.TECH_MESSAGE(
1932: p_severity => fnd_log.level_error,
1933: p_module => g_block || '.debugg error',
1934: p_msg_text => 'Error Mesg 4'
1935: );

Line 1951: FEM_ENGINES_PKG.TECH_MESSAGE(

1947: x_msg_data => x_msg_data,
1948: x_return_status => x_return_status
1949: );
1950:
1951: FEM_ENGINES_PKG.TECH_MESSAGE(
1952: p_severity => fnd_log.level_error,
1953: p_module => g_block || '.debugg error',
1954: p_msg_text => 'Error Mesg 5'
1955: );

Line 1975: FEM_ENGINES_PKG.TECH_MESSAGE(

1971: x_msg_data => x_msg_data,
1972: x_return_status => x_return_status
1973: );
1974:
1975: FEM_ENGINES_PKG.TECH_MESSAGE(
1976: p_severity => fnd_log.level_error,
1977: p_module => g_block || '.debugg error',
1978: p_msg_text => 'Error Mesg 6'
1979: );

Line 1991: FEM_ENGINES_PKG.TECH_MESSAGE(

1987: -- Get Output dataset code
1988: select output_dataset_code into l_output_ds from fem_ds_input_output_defs
1989: where dataset_io_obj_def_id = p_dataset_def_id;
1990:
1991: FEM_ENGINES_PKG.TECH_MESSAGE(
1992: p_severity => fnd_log.level_error,
1993: p_module => g_block || '.debugg error',
1994: p_msg_text => 'Error Mesg 7'
1995: );

Line 2011: FEM_ENGINES_PKG.TECH_MESSAGE(

2007: p_avg_bal_flag => NULL,
2008: p_trans_curr => NULL
2009: );
2010:
2011: FEM_ENGINES_PKG.TECH_MESSAGE(
2012: p_severity => fnd_log.level_error,
2013: p_module => g_block || '.debugg error',
2014: p_msg_text => 'Error Mesg 8'
2015: );

Line 2024: FEM_ENGINES_PKG.Put_Message(

2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;
2022:
2023: IF l_total_inp = 0 THEN
2024: FEM_ENGINES_PKG.Put_Message(
2025: p_app_name => 'FTP',
2026: p_msg_name => 'FTP_ZERO_REC_ERR'
2027: );
2028: END IF;

Line 2038: FEM_ENGINES_PKG.TECH_MESSAGE(

2034: l_exec_status_code := c_prg_success;
2035: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS',null);
2036: END IF;
2037:
2038: FEM_ENGINES_PKG.TECH_MESSAGE(
2039: p_severity => fnd_log.level_error,
2040: p_module => g_block || '.debugg error',
2041: p_msg_text => 'Error Mesg 9'
2042: );

Line 2056: FEM_ENGINES_PKG.TECH_MESSAGE(

2052: x_msg_data => x_msg_data,
2053: x_return_status => x_return_status
2054: );
2055:
2056: FEM_ENGINES_PKG.TECH_MESSAGE(
2057: p_severity => fnd_log.level_error,
2058: p_module => g_block || '.debugg error',
2059: p_msg_text => 'Error Mesg 10'
2060: );

Line 2074: FEM_ENGINES_PKG.TECH_MESSAGE(

2070: x_msg_data => x_msg_data,
2071: x_return_status => x_return_status
2072: );
2073:
2074: FEM_ENGINES_PKG.TECH_MESSAGE(
2075: p_severity => fnd_log.level_error,
2076: p_module => g_block || '.debugg error',
2077: p_msg_text => 'Error Mesg 11'
2078: );

Line 2097: FEM_ENGINES_PKG.TECH_MESSAGE(

2093: p_count => x_msg_count,
2094: p_data => x_msg_data);
2095: x_return_status := FND_API.G_RET_STS_ERROR;
2096:
2097: FEM_ENGINES_PKG.TECH_MESSAGE(
2098: p_severity => fnd_log.level_error,
2099: p_module => g_block || 'FND_API.G_EXC_ERROR',
2100: p_msg_text => 'sqlerrm =' || sqlerrm
2101: );

Line 2119: FEM_ENGINES_PKG.TECH_MESSAGE(

2115:
2116: );
2117: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
2118:
2119: FEM_ENGINES_PKG.TECH_MESSAGE(
2120: p_severity => fnd_log.level_error,
2121: p_module => g_block || 'FND_API.G_EXC_UNEXPECTED_ERROR',
2122: p_msg_text => 'sqlerrm =' || sqlerrm
2123: );

Line 2144: FEM_ENGINES_PKG.TECH_MESSAGE(

2140:
2141: WHEN OTHERS THEN
2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2143:
2144: FEM_ENGINES_PKG.TECH_MESSAGE(
2145: p_severity => fnd_log.level_error,
2146: p_module => g_block || 'OTHERS',
2147: p_msg_text => 'sqlerrm =' || sqlerrm
2148: );

Line 2327: FEM_ENGINES_PKG.Put_Message(

2323: l_tbl_alias, 'N', 'BOTH', 'Y',
2324: l_condition_sql );
2325: EXCEPTION
2326: when others then
2327: FEM_ENGINES_PKG.Put_Message(
2328: p_app_name => 'FTP',
2329: p_msg_name => 'WCLAUSE EXCEPTION',
2330: p_token1 => 'TABLE_NAME',
2331: p_value1 => l_table_names(i),

Line 2607: FEM_ENGINES_PKG.Put_Message(

2603: -- For rate_output_rule get detail info
2604: get_obj_def(rate_output_rule_obj_id, effective_date, rate_map_info);
2605: exception
2606: when NO_DATA_FOUND then
2607: FEM_ENGINES_PKG.Put_Message(
2608: p_app_name => 'FTP',
2609: p_msg_name => 'RATE_MAP_VERSN_EXCEPTION',
2610: p_token1 => 'OBJ_ID',
2611: p_value1 => rate_output_rule_obj_id,

Line 2726: FEM_ENGINES_PKG.Put_Message(

2722: if ( cnt <> 0 ) OR (( cnt = 0 ) and NOT(p_col_name = 'HIST_OAS_COL_NAME' or p_col_name = 'HIST_STAT_SPREAD_COL_NAME' or
2723: p_col_name = 'CUR_STAT_SPREAD_COL_NAME' or p_col_name = 'CUR_OAS_COL_NAME')) THEN
2724: if ( p_col_value IS NULL ) THEN
2725: valid_flg := false;
2726: FEM_ENGINES_PKG.Put_Message(
2727: p_app_name => 'FTP',
2728: p_msg_name => 'FTP_ALL_COLS_NOT_MAPPED',
2729: p_token1 => 'OBJ_ID',
2730: p_value1 => rate_output_rule_obj_id,

Line 2741: FEM_ENGINES_PKG.Put_Message(

2737: if ( cnt <> 0 ) OR (( cnt = 0 ) and NOT(p_col_name = 'HIST_OAS_COL_NAME' or p_col_name = 'HIST_STAT_SPREAD_COL_NAME' or
2738: p_col_name = 'CUR_STAT_SPREAD_COL_NAME' or p_col_name = 'CUR_OAS_COL_NAME')) THEN
2739: if ( p_col_value = '-1') THEN
2740: valid_flg := false;
2741: FEM_ENGINES_PKG.Put_Message(
2742: p_app_name => 'FTP',
2743: p_msg_name => 'FTP_INVALID_COL',
2744: p_token1 => 'OBJ_ID',
2745: p_value1 => rate_output_rule_obj_id,