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 FND_API

Line 1077: RAISE FND_API.G_EXC_ERROR;

1073: END LOOP;
1074:
1075: IF (x_datasets IS NULL)
1076: THEN
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079:
1080: x_datasets := '(' || RTRIM(x_datasets,',') || ')';
1081:

Line 1097: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may

1093: -- Returns 'T' if an execution lock exists, and 'F' if an execution
1094: -- lock does not exist.
1095: -- x_return_status OUT VARCHAR2
1096: -- Possible return status:
1097: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
1098: -- still be present (check x_msg_count)
1099: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
1100: -- be present (check x_msg_count)
1101: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

Line 1099: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should

1095: -- x_return_status OUT VARCHAR2
1096: -- Possible return status:
1097: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
1098: -- still be present (check x_msg_count)
1099: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
1100: -- be present (check x_msg_count)
1101: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
1102: -- unrecoverable (check x_msg_count)
1103: --

Line 1101: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

1097: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
1098: -- still be present (check x_msg_count)
1099: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
1100: -- be present (check x_msg_count)
1101: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
1102: -- unrecoverable (check x_msg_count)
1103: --
1104: -- x_msg_count OUT NUMBER
1105: -- Count of messages returned. If x_msg_count = 1, then the message is returned

Line 1161: x_return_status := FND_API.G_RET_STS_SUCCESS;

1157: p_token2 => 'EFF_DATE',
1158: p_value2 => p_effective_date
1159: );*/
1160: -- initialize our status to 'we are good!'
1161: x_return_status := FND_API.G_RET_STS_SUCCESS;
1162:
1163: -- Initialize FND message queue
1164: FND_MSG_PUB.Initialize;
1165:

Line 1204: p_commit => FND_API.G_FALSE,

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,
1207: p_ledger_id => p_ledger_id,
1208: p_dataset_io_obj_def_id => p_dataset_def_id,

Line 1231: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1227: p_token2 => 'MSG_DATA',
1228: p_value2 => x_msg_data
1229: );*/
1230:
1231: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1232: RAISE FND_API.G_EXC_ERROR;
1233: END IF;
1234:
1235: -- Read the rule to retieve the names of the tables to process

Line 1232: RAISE FND_API.G_EXC_ERROR;

1228: p_value2 => x_msg_data
1229: );*/
1230:
1231: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1232: RAISE FND_API.G_EXC_ERROR;
1233: END IF;
1234:
1235: -- Read the rule to retieve the names of the tables to process
1236: OPEN l_cur_tables;

Line 1350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1346: x_msg_data => x_msg_data,
1347: x_return_status => x_return_status
1348: );
1349:
1350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:
1354: /*--Register all obj defs read during processing

Line 1351: RAISE FND_API.G_EXC_ERROR;

1347: x_return_status => x_return_status
1348: );
1349:
1350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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(

Line 1367: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1363: x_msg_data => x_msg_data,
1364: x_return_status => x_return_status
1365: );
1366:
1367: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;*/
1370:
1371: -- Register all dependent object definitions

Line 1368: RAISE FND_API.G_EXC_ERROR;

1364: x_return_status => x_return_status
1365: );
1366:
1367: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;*/
1370:
1371: -- Register all dependent object definitions
1372: FEM_PL_PKG.register_dependent_objdefs(

Line 1384: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1380: x_msg_count => x_msg_count,
1381: x_msg_data => x_msg_data,
1382: x_return_status => x_return_status
1383: );
1384: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:
1388: --Register all the selected tables that are written to, during processing

Line 1385: RAISE FND_API.G_EXC_ERROR;

1381: x_msg_data => x_msg_data,
1382: x_return_status => x_return_status
1383: );
1384: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:
1388: --Register all the selected tables that are written to, during processing
1389: FOR i IN 1 .. l_table_names.COUNT LOOP

Line 1411: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1407: x_msg_data => x_msg_data,
1408: x_return_status => x_return_status
1409: );
1410:
1411: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1412: RAISE FND_API.G_EXC_ERROR;
1413: END IF;
1414: END LOOP;
1415:

Line 1412: RAISE FND_API.G_EXC_ERROR;

1408: x_return_status => x_return_status
1409: );
1410:
1411: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1412: RAISE FND_API.G_EXC_ERROR;
1413: END IF;
1414: END LOOP;
1415:
1416: -- Register the Node Map Tables as well

Line 1432: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1428: x_msg_data => x_msg_data,
1429: x_return_status => x_return_status
1430: );
1431:
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(

Line 1433: RAISE FND_API.G_EXC_ERROR;

1429: x_return_status => x_return_status
1430: );
1431:
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,

Line 1450: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1446: x_msg_data => x_msg_data,
1447: x_return_status => x_return_status
1448: );
1449:
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(

Line 1451: RAISE FND_API.G_EXC_ERROR;

1447: x_return_status => x_return_status
1448: );
1449:
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',

Line 1470: WHEN FND_API.G_EXC_ERROR THEN

1466: (p_encoded => 'F',
1467: p_count => x_msg_count,
1468: p_data => x_msg_data);
1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: FND_MSG_PUB.Count_And_Get
1472: (p_encoded => 'F',
1473: p_count => x_msg_count,
1474: p_data => x_msg_data);

Line 1475: x_return_status := FND_API.G_RET_STS_ERROR;

1471: FND_MSG_PUB.Count_And_Get
1472: (p_encoded => 'F',
1473: p_count => x_msg_count,
1474: p_data => x_msg_data);
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1476: rollback to register_request_pub;
1477:
1478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1479: l_msg := SUBSTR(SQLERRM, 1, 300);

Line 1478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1474: p_data => x_msg_data);
1475: x_return_status := FND_API.G_RET_STS_ERROR;
1476: rollback to register_request_pub;
1477:
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(

Line 1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1476: rollback to register_request_pub;
1477:
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',

Line 1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1494: WHEN OTHERS THEN
1495: l_msg := SUBSTR(SQLERRM, 1, 300);
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',

Line 1594: x_return_status := FND_API.G_RET_STS_SUCCESS;

1590:
1591: BEGIN
1592:
1593: -- initialize our status to 'we are good!'
1594: x_return_status := FND_API.G_RET_STS_SUCCESS;
1595: FND_MSG_PUB.Delete_Msg();
1596: --Initialize sum variables
1597: l_total_inp := 0;
1598: l_total_out := 0;

Line 1632: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1628: IF l_condition_id = 0 THEN
1629: l_condition_id := NULL;
1630: END IF;
1631:
1632: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
1636: If (valid_table_list IS NOT NULL) THEN

Line 1633: RAISE FND_API.G_EXC_ERROR;

1629: l_condition_id := NULL;
1630: END IF;
1631:
1632: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
1636: If (valid_table_list IS NOT NULL) THEN
1637: modify_valid_table_list := valid_table_list || ',';

Line 1855: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1851: x_msg_count => x_msg_count,
1852: x_msg_data => x_msg_data,
1853: x_return_status => x_return_status
1854: );
1855: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1856: RAISE FND_API.G_EXC_ERROR;
1857: END IF;
1858: END IF;--end of is col name null
1859: END LOOP;--end of column names loop

Line 1856: RAISE FND_API.G_EXC_ERROR;

1852: x_msg_data => x_msg_data,
1853: x_return_status => x_return_status
1854: );
1855: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1856: RAISE FND_API.G_EXC_ERROR;
1857: END IF;
1858: END IF;--end of is col name null
1859: END LOOP;--end of column names loop
1860: ELSE

Line 1886: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1882: p_module => g_block || '.debugg error',
1883: p_msg_text => 'Error Mesg 1'
1884: );
1885:
1886: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1887: RAISE FND_API.G_EXC_ERROR;
1888: END IF;
1889:
1890: l_total_out := l_total_out + l_output_cnt;

Line 1887: RAISE FND_API.G_EXC_ERROR;

1883: p_msg_text => 'Error Mesg 1'
1884: );
1885:
1886: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1887: RAISE FND_API.G_EXC_ERROR;
1888: END IF;
1889:
1890: l_total_out := l_total_out + l_output_cnt;
1891:

Line 1924: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1920: p_module => g_block || '.debugg error',
1921: p_msg_text => 'Error Mesg 3'
1922: );
1923:
1924: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;
1927:
1928: select count(*) into l_output_cnt from FTP_TP_PP_NODE_MAP

Line 1925: RAISE FND_API.G_EXC_ERROR;

1921: p_msg_text => 'Error Mesg 3'
1922: );
1923:
1924: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;
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;

Line 1957: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1953: p_module => g_block || '.debugg error',
1954: p_msg_text => 'Error Mesg 5'
1955: );
1956:
1957: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;
1960:
1961: --Update the number of input rows

Line 1958: RAISE FND_API.G_EXC_ERROR;

1954: p_msg_text => 'Error Mesg 5'
1955: );
1956:
1957: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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 (

Line 1964: p_commit => FND_API.G_FALSE,

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,
1967: p_num_of_input_rows => l_total_inp,
1968: p_user_id => p_user_id,

Line 2019: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2015: );
2016:
2017: END IF;
2018:
2019: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;
2022:
2023: IF l_total_inp = 0 THEN

Line 2020: RAISE FND_API.G_EXC_ERROR;

2016:
2017: END IF;
2018:
2019: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;
2022:
2023: IF l_total_inp = 0 THEN
2024: FEM_ENGINES_PKG.Put_Message(

Line 2080: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2076: p_module => g_block || '.debugg error',
2077: p_msg_text => 'Error Mesg 11'
2078: );
2079:
2080: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2081: RAISE FND_API.G_EXC_ERROR;
2082: END IF;
2083:
2084: l_table_names.DELETE;

Line 2081: RAISE FND_API.G_EXC_ERROR;

2077: p_msg_text => 'Error Mesg 11'
2078: );
2079:
2080: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2081: RAISE FND_API.G_EXC_ERROR;
2082: END IF;
2083:
2084: l_table_names.DELETE;
2085: FND_MSG_PUB.Count_And_Get

Line 2090: WHEN FND_API.G_EXC_ERROR THEN

2086: (p_encoded => 'F',
2087: p_count => x_msg_count,
2088: p_data => x_msg_data);
2089: EXCEPTION
2090: WHEN FND_API.G_EXC_ERROR THEN
2091: FND_MSG_PUB.Count_And_Get
2092: (p_encoded => 'F',
2093: p_count => x_msg_count,
2094: p_data => x_msg_data);

Line 2095: x_return_status := FND_API.G_RET_STS_ERROR;

2091: FND_MSG_PUB.Count_And_Get
2092: (p_encoded => 'F',
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',

Line 2099: p_module => g_block || 'FND_API.G_EXC_ERROR',

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:
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2099: p_module => g_block || 'FND_API.G_EXC_ERROR',
2100: p_msg_text => 'sqlerrm =' || sqlerrm
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,

Line 2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2100: p_msg_text => 'sqlerrm =' || sqlerrm
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,

Line 2121: p_module => g_block || 'FND_API.G_EXC_UNEXPECTED_ERROR',

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:
2125: --update status of the request

Line 2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2138: p_count => x_msg_count,
2139: p_data => x_msg_data);
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',

Line 2238: x_return_status := FND_API.G_RET_STS_SUCCESS;

2234:
2235: BEGIN
2236:
2237: -- initialize our status to 'we are good!'
2238: x_return_status := FND_API.G_RET_STS_SUCCESS;
2239:
2240: -- Get the object definition id of the process
2241: get_obj_def(p_object_id, p_effective_date, process_info);
2242:

Line 2286: p_init_msg_list => FND_API.G_TRUE,

2282: --Chaining exists is now handled by following FEM
2283: --x_exec_lock_exists is no longer required..
2284: FEM_UD_PKG.Delete_Balances (
2285: p_api_version => c_api_version,
2286: p_init_msg_list => FND_API.G_TRUE,
2287: p_commit => FND_API.G_FALSE,
2288: p_encoded => FND_API.G_FALSE,
2289: x_return_status => x_return_status,
2290: x_msg_count => x_msg_count,

Line 2287: p_commit => FND_API.G_FALSE,

2283: --x_exec_lock_exists is no longer required..
2284: FEM_UD_PKG.Delete_Balances (
2285: p_api_version => c_api_version,
2286: p_init_msg_list => FND_API.G_TRUE,
2287: p_commit => FND_API.G_FALSE,
2288: p_encoded => FND_API.G_FALSE,
2289: x_return_status => x_return_status,
2290: x_msg_count => x_msg_count,
2291: x_msg_data => x_msg_data,

Line 2288: p_encoded => FND_API.G_FALSE,

2284: FEM_UD_PKG.Delete_Balances (
2285: p_api_version => c_api_version,
2286: p_init_msg_list => FND_API.G_TRUE,
2287: p_commit => FND_API.G_FALSE,
2288: p_encoded => FND_API.G_FALSE,
2289: x_return_status => x_return_status,
2290: x_msg_count => x_msg_count,
2291: x_msg_data => x_msg_data,
2292: p_current_request_id => p_request_id,

Line 2299: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2295: p_ledger_id => p_ledger_id,
2296: p_dataset_code => l_output_ds
2297: );
2298:
2299: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2300: RAISE FND_API.G_EXC_ERROR;
2301: END IF;
2302:
2303: --- Praveen Attaluri (Bug Fix)

Line 2300: RAISE FND_API.G_EXC_ERROR;

2296: p_dataset_code => l_output_ds
2297: );
2298:
2299: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2300: RAISE FND_API.G_EXC_ERROR;
2301: END IF;
2302:
2303: --- Praveen Attaluri (Bug Fix)
2304: -- Get the tables that should be processed. Chaining must be implemented

Line 2363: p_commit => FND_API.G_FALSE,

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,
2366: p_source_created_by_request_id => l_created_by_req_tbl(i),
2367: p_source_created_by_object_id => l_created_by_obj_tbl(i),

Line 2378: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2374:
2375: END LOOP;
2376:
2377:
2378: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2379: RAISE FND_API.G_EXC_ERROR;
2380: END IF;
2381:
2382: END LOOP;

Line 2379: RAISE FND_API.G_EXC_ERROR;

2375: END LOOP;
2376:
2377:
2378: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2379: RAISE FND_API.G_EXC_ERROR;
2380: END IF;
2381:
2382: END LOOP;
2383:

Line 2395: WHEN FND_API.G_EXC_ERROR THEN

2391: (p_encoded => 'F',
2392: p_count => x_msg_count,
2393: p_data => x_msg_data);
2394: EXCEPTION
2395: WHEN FND_API.G_EXC_ERROR THEN
2396: FND_MSG_PUB.Count_And_Get
2397: (p_encoded => 'F',
2398: p_count => x_msg_count,
2399: p_data => x_msg_data);

Line 2400: x_return_status := FND_API.G_RET_STS_ERROR;

2396: FND_MSG_PUB.Count_And_Get
2397: (p_encoded => 'F',
2398: p_count => x_msg_count,
2399: p_data => x_msg_data);
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2403: FND_MSG_PUB.Count_And_Get
2404: (p_encoded => 'F',

Line 2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2398: p_count => x_msg_count,
2399: p_data => x_msg_data);
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2403: FND_MSG_PUB.Count_And_Get
2404: (p_encoded => 'F',
2405: p_count => x_msg_count,
2406: p_data => x_msg_data);

Line 2407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2403: FND_MSG_PUB.Count_And_Get
2404: (p_encoded => 'F',
2405: p_count => x_msg_count,
2406: p_data => x_msg_data);
2407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2408:
2409: WHEN OTHERS THEN
2410: FND_MSG_PUB.Count_And_Get
2411: (p_encoded => 'F',

Line 2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2411: (p_encoded => 'F',
2412: p_count => x_msg_count,
2413: p_data => x_msg_data);
2414:
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2416:
2417: END LEDGER_PROCESSING;
2418:
2419: /***************************************************************************

Line 2499: x_return_status := FND_API.G_RET_STS_SUCCESS;

2495:
2496: begin
2497:
2498: -- initialize our status to 'we are good!'
2499: x_return_status := FND_API.G_RET_STS_SUCCESS;
2500: FND_MSG_PUB.Delete_Msg();
2501: adj_type_code := '';
2502:
2503: get_obj_def(obj_id, effective_date, process_info);