DBA Data[Home] [Help]

APPS.FTP_TP_PKG dependencies on FEM_PL_PKG

Line 1202: FEM_PL_PKG.register_request(

1198: p_value1 => l_condition_id
1199: );*/
1200:
1201: --Do the request registration
1202: FEM_PL_PKG.register_request(
1203: p_api_version => c_api_version,
1204: p_commit => FND_API.G_FALSE,
1205: p_request_id => p_request_id,
1206: p_cal_period_id => p_cal_period_id,

Line 1336: FEM_PL_PKG.register_object_execution(

1332:
1333: END LOOP;
1334:
1335: --Check if object executions exists. If not then register
1336: FEM_PL_PKG.register_object_execution(
1337: p_api_version => c_api_version,
1338: p_request_id => p_request_id,
1339: p_object_id => p_object_id,
1340: p_exec_object_definition_id => process_info.obj_id,

Line 1355: FEM_PL_PKG.register_object_def(

1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:
1354: /*--Register all obj defs read during processing
1355: FEM_PL_PKG.register_object_def(
1356: p_api_version => c_api_version,
1357: p_request_id => p_request_id,
1358: p_object_id => p_object_id,
1359: p_object_definition_Id => process_info.obj_id,

Line 1372: FEM_PL_PKG.register_dependent_objdefs(

1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;*/
1370:
1371: -- Register all dependent object definitions
1372: FEM_PL_PKG.register_dependent_objdefs(
1373: p_api_version => c_api_version,
1374: p_request_id => p_request_id,
1375: p_object_id => p_object_id,
1376: p_exec_object_definition_id => process_info.obj_id,

Line 1397: FEM_PL_PKG.register_table(

1393: l_stmt_type := 'UPDATE';
1394: ELSE
1395: l_stmt_type := c_stmt_type;
1396: END IF;
1397: FEM_PL_PKG.register_table(
1398: p_api_version => c_api_version,
1399: p_request_id => p_request_id,
1400: p_object_id => p_object_id,
1401: p_table_name => l_table_names(i),

Line 1418: FEM_PL_PKG.register_table(

1414: END LOOP;
1415:
1416: -- Register the Node Map Tables as well
1417: -- Register FTP_TP_PP_NODE_HEADER and FTP_TP_PP_NODE_MAP
1418: FEM_PL_PKG.register_table(
1419: p_api_version => c_api_version,
1420: p_request_id => p_request_id,
1421: p_object_id => p_object_id,
1422: p_table_name => 'FTP_TP_PP_NODE_HEADER',

Line 1436: FEM_PL_PKG.register_table(

1432: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1433: RAISE FND_API.G_EXC_ERROR;
1434: END IF;
1435:
1436: FEM_PL_PKG.register_table(
1437: p_api_version => c_api_version,
1438: p_request_id => p_request_id,
1439: p_object_id => p_object_id,
1440: p_table_name => 'FTP_TP_PP_NODE_MAP',

Line 1842: fem_pl_pkg.REGISTER_UPDATED_COLUMN(

1838: );
1839:
1840: IF l_col_names(j) IS NOT NULL THEN
1841: --Register updated columns
1842: fem_pl_pkg.REGISTER_UPDATED_COLUMN(
1843: p_api_version => c_api_version,
1844: p_request_id => p_request_id,
1845: p_object_id => p_object_id,
1846: p_table_name => l_table_names(i),

Line 1866: FEM_PL_PKG.update_num_of_output_rows(

1862: -- Set the statement type
1863: l_stmt_type := c_stmt_type;
1864: END IF;--end of if not fem_balances
1865:
1866: FEM_PL_PKG.update_num_of_output_rows(
1867: p_api_version => c_api_version,
1868: p_request_id => p_request_id,
1869: p_object_id => p_object_id,
1870: p_table_name => l_table_names(i),

Line 1904: FEM_PL_PKG.update_num_of_output_rows(

1900: p_module => g_block || '.debugg error',
1901: p_msg_text => 'Error Mesg 2'
1902: );
1903:
1904: FEM_PL_PKG.update_num_of_output_rows(
1905: p_api_version => c_api_version,
1906: p_request_id => p_request_id,
1907: p_object_id => p_object_id,
1908: p_table_name => 'FTP_TP_PP_NODE_HEADER',

Line 1937: FEM_PL_PKG.update_num_of_output_rows(

1933: p_module => g_block || '.debugg error',
1934: p_msg_text => 'Error Mesg 4'
1935: );
1936:
1937: FEM_PL_PKG.update_num_of_output_rows(
1938: p_api_version => c_api_version,
1939: p_request_id => p_request_id,
1940: p_object_id => p_object_id,
1941: p_table_name => 'FTP_TP_PP_NODE_MAP',

Line 1962: FEM_PL_PKG.update_num_of_input_rows (

1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;
1960:
1961: --Update the number of input rows
1962: FEM_PL_PKG.update_num_of_input_rows (
1963: p_api_version => c_api_version,
1964: p_commit => FND_API.G_FALSE,
1965: p_request_id => p_request_id,
1966: p_object_id => p_object_id,

Line 2044: fem_pl_pkg.UPDATE_OBJ_EXEC_STATUS(

2040: p_module => g_block || '.debugg error',
2041: p_msg_text => 'Error Mesg 9'
2042: );
2043:
2044: fem_pl_pkg.UPDATE_OBJ_EXEC_STATUS(
2045: p_api_version => c_api_version,
2046: p_request_id => p_request_id,
2047: p_object_id => p_object_id,
2048: p_exec_status_code => l_exec_status_code,

Line 2063: FEM_PL_PKG.update_request_status(

2059: p_msg_text => 'Error Mesg 10'
2060: );
2061:
2062: --update status of the request
2063: FEM_PL_PKG.update_request_status(
2064: p_api_version => c_api_version,
2065: p_request_id => p_request_id,
2066: p_exec_status_code => l_exec_status_code,
2067: p_user_id => p_user_id,

Line 2105: fem_pl_pkg.UPDATE_OBJ_EXEC_STATUS(

2101: );
2102:
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2105: fem_pl_pkg.UPDATE_OBJ_EXEC_STATUS(
2106: p_api_version => c_api_version,
2107: p_request_id => p_request_id,
2108: p_object_id => p_object_id,
2109: p_exec_status_code => c_prg_err_undo,

Line 2126: FEM_PL_PKG.update_request_status(

2122: p_msg_text => 'sqlerrm =' || sqlerrm
2123: );
2124:
2125: --update status of the request
2126: FEM_PL_PKG.update_request_status(
2127: p_api_version => c_api_version,
2128: p_request_id => p_request_id,
2129: p_exec_status_code => c_prg_err_undo,
2130: p_user_id => p_user_id,

Line 2150: fem_pl_pkg.UPDATE_OBJ_EXEC_STATUS(

2146: p_module => g_block || 'OTHERS',
2147: p_msg_text => 'sqlerrm =' || sqlerrm
2148: );
2149:
2150: fem_pl_pkg.UPDATE_OBJ_EXEC_STATUS(
2151: p_api_version => c_api_version,
2152: p_request_id => p_request_id,
2153: p_object_id => p_object_id,
2154: p_exec_status_code

Line 2166: FEM_PL_PKG.update_request_status(

2162: );
2163: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
2164:
2165: --update status of the request
2166: FEM_PL_PKG.update_request_status(
2167: p_api_version => c_api_version,
2168: p_request_id => p_request_id,
2169: p_exec_status_code => c_prg_err_undo,
2170: p_user_id => p_user_id,

Line 2359: -- Call the FEM_PL_PKG.Register_Chain API procedure to register

2355: FETCH l_uow_cursor BULK COLLECT INTO l_created_by_obj_tbl,l_created_by_req_tbl;
2356: CLOSE l_uow_cursor;
2357:
2358: FOR i in 1 .. l_created_by_obj_tbl.COUNT LOOP
2359: -- Call the FEM_PL_PKG.Register_Chain API procedure to register
2360: -- the specified chain.
2361: FEM_PL_PKG.Register_Chain (
2362: p_api_version => c_api_version,
2363: p_commit => FND_API.G_FALSE,

Line 2361: FEM_PL_PKG.Register_Chain (

2357:
2358: FOR i in 1 .. l_created_by_obj_tbl.COUNT LOOP
2359: -- Call the FEM_PL_PKG.Register_Chain API procedure to register
2360: -- the specified chain.
2361: FEM_PL_PKG.Register_Chain (
2362: p_api_version => c_api_version,
2363: p_commit => FND_API.G_FALSE,
2364: p_request_id => p_request_id,
2365: p_object_id => p_object_id,