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: );
1609:
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: );
1650:
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: );
1658:
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: );
1666:
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: );
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: );
1692:
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: );
1782:
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: );
1839:
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: );
1885:
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: );
1903:
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: );
1923:
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: );
1936:
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: );
1956:
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: );
1980:
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: );
1996:
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: );
2016:
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: );
2043:
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: );
2061:
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: );
2079:
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: );
2102:
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: );
2124:
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: );
2149: