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.OKC_XPRT_OM_INT_PVT dependencies on FND_API

Line 8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

4: ------------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS
6: ------------------------------------------------------------------------------
7:
8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

5: -- GLOBAL CONSTANTS
6: ------------------------------------------------------------------------------
7:
8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

7:
8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_XPRT_OM_INT_PVT';

Line 12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

8: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_XPRT_OM_INT_PVT';
16: G_MODULE_NAME CONSTANT VARCHAR2(250) := 'OKC.PLSQL.'||G_PKG_NAME||'.';

Line 13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

9: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
10:
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_XPRT_OM_INT_PVT';
16: G_MODULE_NAME CONSTANT VARCHAR2(250) := 'OKC.PLSQL.'||G_PKG_NAME||'.';
17: G_STMT_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 306: x_return_status := FND_API.G_RET_STS_SUCCESS;

302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: l_debug := true;
304: END IF;
305:
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
309:
310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 319: IF NOT FND_API.Compatible_API_Call (l_api_version,

315:
316: --
317: -- Standard call to check for call compatibility.
318: --
319: IF NOT FND_API.Compatible_API_Call (l_api_version,
320: p_api_version,
321: l_api_name,
322: G_PKG_NAME)
323: THEN

Line 324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

320: p_api_version,
321: l_api_name,
322: G_PKG_NAME)
323: THEN
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:
327: --
328: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 330: IF FND_API.to_Boolean( p_init_msg_list ) THEN

326:
327: --
328: -- Initialize message list if p_init_msg_list is set to TRUE.
329: --
330: IF FND_API.to_Boolean( p_init_msg_list ) THEN
331: FND_MSG_PUB.initialize;
332: END IF;
333:
334:

Line 931: WHEN FND_API.G_EXC_ERROR THEN

927:
928:
929: EXCEPTION
930:
931: WHEN FND_API.G_EXC_ERROR THEN
932:
933: IF c_get_bsa_header_variables%ISOPEN THEN
934: CLOSE c_get_bsa_header_variables;
935: END IF;

Line 957: x_return_status := FND_API.G_RET_STS_ERROR ;

953: IF c_get_expert_yes_no%ISOPEN THEN
954: CLOSE c_get_expert_yes_no;
955: END IF;
956:
957: x_return_status := FND_API.G_RET_STS_ERROR ;
958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
960: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
961: END IF;

Line 959: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');

955: END IF;
956:
957: x_return_status := FND_API.G_RET_STS_ERROR ;
958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
960: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
961: END IF;
962:
963: FND_MSG_PUB.Count_And_Get(

Line 967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

963: FND_MSG_PUB.Count_And_Get(
964: p_count => x_msg_count,
965: p_data => x_msg_data );
966:
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968:
969: IF c_get_bsa_header_variables%ISOPEN THEN
970: CLOSE c_get_bsa_header_variables;
971: END IF;

Line 993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

989: IF c_get_expert_yes_no%ISOPEN THEN
990: CLOSE c_get_expert_yes_no;
991: END IF;
992:
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994:
995: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
996: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
997: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);

Line 996: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');

992:
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994:
995: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
996: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
997: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);
998: END IF;
999:
1000: FND_MSG_PUB.Count_And_Get(

Line 1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1026: IF c_get_expert_yes_no%ISOPEN THEN
1027: CLOSE c_get_expert_yes_no;
1028: END IF;
1029:
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');
1033: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);
1034: END IF;

Line 1166: x_return_status := FND_API.G_RET_STS_SUCCESS;

1162: BEGIN
1163:
1164: l_package_procedure := G_PKG_NAME || '.' || l_api_name || ' - 2';
1165:
1166: x_return_status := FND_API.G_RET_STS_SUCCESS;
1167:
1168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: l_debug := true;
1170: END IF;

Line 1182: IF NOT FND_API.Compatible_API_Call (l_api_version,

1178:
1179: --
1180: -- Standard call to check for call compatibility.
1181: --
1182: IF NOT FND_API.Compatible_API_Call (l_api_version,
1183: p_api_version,
1184: l_api_name,
1185: G_PKG_NAME)
1186: THEN

Line 1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1183: p_api_version,
1184: l_api_name,
1185: G_PKG_NAME)
1186: THEN
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1188: END IF;
1189:
1190: --
1191: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1193: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1189:
1190: --
1191: -- Initialize message list if p_init_msg_list is set to TRUE.
1192: --
1193: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1194: FND_MSG_PUB.initialize;
1195: END IF;
1196:
1197:

Line 1330: WHEN FND_API.G_EXC_ERROR THEN

1326: END IF;
1327:
1328: EXCEPTION
1329:
1330: WHEN FND_API.G_EXC_ERROR THEN
1331:
1332: IF c_get_items%ISOPEN THEN
1333: CLOSE c_get_items;
1334: END IF;

Line 1344: x_return_status := FND_API.G_RET_STS_ERROR ;

1340: IF c_get_derived_item_category%ISOPEN THEN
1341: CLOSE c_get_derived_item_category;
1342: END IF;
1343:
1344: x_return_status := FND_API.G_RET_STS_ERROR ;
1345:
1346: FND_MSG_PUB.Count_And_Get(
1347: p_count => x_msg_count,
1348: p_data => x_msg_data );

Line 1351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');

1347: p_count => x_msg_count,
1348: p_data => x_msg_data );
1349:
1350: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1353: END IF;
1354:
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1351: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1353: END IF;
1354:
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1356:
1357: IF c_get_items%ISOPEN THEN
1358: CLOSE c_get_items;
1359: END IF;

Line 1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1365: IF c_get_derived_item_category%ISOPEN THEN
1366: CLOSE c_get_derived_item_category;
1367: END IF;
1368:
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370:
1371: FND_MSG_PUB.Count_And_Get(
1372: p_count => x_msg_count,
1373: p_data => x_msg_data );

Line 1376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');

1372: p_count => x_msg_count,
1373: p_data => x_msg_data );
1374:
1375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1376: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1377: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1378: END IF;
1379:
1380: WHEN OTHERS THEN

Line 1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1390: IF c_get_derived_item_category%ISOPEN THEN
1391: CLOSE c_get_derived_item_category;
1392: END IF;
1393:
1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1395:
1396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1397: FND_MSG_PUB.Add_Exc_Msg(
1398: G_PKG_NAME ,

Line 1419: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1415: -- line level system variables
1416: --
1417: PROCEDURE Get_Line_Variable_Values (
1418: p_api_version IN NUMBER,
1419: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1420: p_doc_type IN VARCHAR2,
1421: p_doc_id IN NUMBER,
1422: x_return_status OUT NOCOPY VARCHAR2,
1423: x_msg_count OUT NOCOPY NUMBER,

Line 1550: x_return_status := FND_API.G_RET_STS_SUCCESS;

1546: BEGIN
1547:
1548: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1549:
1550: x_return_status := FND_API.G_RET_STS_SUCCESS;
1551:
1552: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1553: l_debug := true;
1554: END IF;

Line 1565: IF NOT FND_API.Compatible_API_Call (l_api_version,

1561:
1562: --
1563: -- Standard call to check for call compatibility.
1564: --
1565: IF NOT FND_API.Compatible_API_Call (l_api_version,
1566: p_api_version,
1567: l_api_name,
1568: G_PKG_NAME)
1569: THEN

Line 1570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1566: p_api_version,
1567: l_api_name,
1568: G_PKG_NAME)
1569: THEN
1570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1571: END IF;
1572:
1573: --
1574: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1576: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1572:
1573: --
1574: -- Initialize message list if p_init_msg_list is set to TRUE.
1575: --
1576: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1577: FND_MSG_PUB.initialize;
1578: END IF;
1579:
1580: --AK

Line 1900: WHEN FND_API.G_EXC_ERROR THEN

1896: END IF;
1897:
1898: EXCEPTION
1899:
1900: WHEN FND_API.G_EXC_ERROR THEN
1901: IF c_get_bsa_line_variables%ISOPEN THEN
1902: CLOSE c_get_bsa_line_variables;
1903: END IF;
1904:

Line 1910: x_return_status := FND_API.G_RET_STS_ERROR ;

1906: CLOSE c_get_so_line_variables;
1907: END IF;
1908:
1909:
1910: x_return_status := FND_API.G_RET_STS_ERROR ;
1911:
1912: FND_MSG_PUB.Count_And_Get(
1913: p_count => x_msg_count,
1914: p_data => x_msg_data );

Line 1917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');

1913: p_count => x_msg_count,
1914: p_data => x_msg_data );
1915:
1916: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1918: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1919: END IF;
1920:
1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1917: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1918: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1919: END IF;
1920:
1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1922: IF c_get_bsa_line_variables%ISOPEN THEN
1923: CLOSE c_get_bsa_line_variables;
1924: END IF;
1925:

Line 1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1926: IF c_get_so_line_variables%ISOPEN THEN
1927: CLOSE c_get_so_line_variables;
1928: END IF;
1929:
1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1931:
1932: FND_MSG_PUB.Count_And_Get(
1933: p_count => x_msg_count,
1934: p_data => x_msg_data );

Line 1937: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');

1933: p_count => x_msg_count,
1934: p_data => x_msg_data );
1935:
1936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1937: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1938: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1939: END IF;
1940:
1941: WHEN OTHERS THEN

Line 1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1946: IF c_get_so_line_variables%ISOPEN THEN
1947: CLOSE c_get_so_line_variables;
1948: END IF;
1949:
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951:
1952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1953: FND_MSG_PUB.Add_Exc_Msg(
1954: G_PKG_NAME ,