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 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
378: l_debug := true;
379: END IF;
380:
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
384:
385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 394: IF NOT FND_API.Compatible_API_Call (l_api_version,

390:
391: --
392: -- Standard call to check for call compatibility.
393: --
394: IF NOT FND_API.Compatible_API_Call (l_api_version,
395: p_api_version,
396: l_api_name,
397: G_PKG_NAME)
398: THEN

Line 399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

395: p_api_version,
396: l_api_name,
397: G_PKG_NAME)
398: THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401:
402: --
403: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 405: IF FND_API.to_Boolean( p_init_msg_list ) THEN

401:
402: --
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404: --
405: IF FND_API.to_Boolean( p_init_msg_list ) THEN
406: FND_MSG_PUB.initialize;
407: END IF;
408:
409:

Line 1182: WHEN FND_API.G_EXC_ERROR THEN

1178:
1179:
1180: EXCEPTION
1181:
1182: WHEN FND_API.G_EXC_ERROR THEN
1183:
1184: IF c_get_bsa_header_variables%ISOPEN THEN
1185: CLOSE c_get_bsa_header_variables;
1186: END IF;

Line 1212: x_return_status := FND_API.G_RET_STS_ERROR ;

1208: IF c_get_address_info%ISOPEN THEN
1209: CLOSE c_get_address_info;
1210: END IF;
1211:
1212: x_return_status := FND_API.G_RET_STS_ERROR ;
1213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1215: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
1216: END IF;

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

1210: END IF;
1211:
1212: x_return_status := FND_API.G_RET_STS_ERROR ;
1213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'500: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1215: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'510: x_return_status = '||x_return_status);
1216: END IF;
1217:
1218: FND_MSG_PUB.Count_And_Get(

Line 1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1218: FND_MSG_PUB.Count_And_Get(
1219: p_count => x_msg_count,
1220: p_data => x_msg_data );
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223:
1224: IF c_get_bsa_header_variables%ISOPEN THEN
1225: CLOSE c_get_bsa_header_variables;
1226: END IF;

Line 1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1248: IF c_get_address_info%ISOPEN THEN
1249: CLOSE c_get_address_info;
1250: END IF;
1251:
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1253:
1254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1255: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
1256: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);

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

1251:
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1253:
1254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1255: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'520: '||l_package_procedure||' In the FND_API.G_RET_STS_UNEXP_ERROR section');
1256: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'530: x_return_status = '||x_return_status);
1257: END IF;
1258:
1259: FND_MSG_PUB.Count_And_Get(

Line 1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1289: IF c_get_address_info%ISOPEN THEN
1290: CLOSE c_get_address_info;
1291: END IF;
1292:
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1295: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'540: '||l_package_procedure||' In the OTHERS section');
1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'550: x_return_status = '||x_return_status);
1297: END IF;

Line 1429: x_return_status := FND_API.G_RET_STS_SUCCESS;

1425: BEGIN
1426:
1427: l_package_procedure := G_PKG_NAME || '.' || l_api_name || ' - 2';
1428:
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: l_debug := true;
1433: END IF;

Line 1445: IF NOT FND_API.Compatible_API_Call (l_api_version,

1441:
1442: --
1443: -- Standard call to check for call compatibility.
1444: --
1445: IF NOT FND_API.Compatible_API_Call (l_api_version,
1446: p_api_version,
1447: l_api_name,
1448: G_PKG_NAME)
1449: THEN

Line 1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1446: p_api_version,
1447: l_api_name,
1448: G_PKG_NAME)
1449: THEN
1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451: END IF;
1452:
1453: --
1454: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1456: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1452:
1453: --
1454: -- Initialize message list if p_init_msg_list is set to TRUE.
1455: --
1456: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1457: FND_MSG_PUB.initialize;
1458: END IF;
1459:
1460:

Line 1593: WHEN FND_API.G_EXC_ERROR THEN

1589: END IF;
1590:
1591: EXCEPTION
1592:
1593: WHEN FND_API.G_EXC_ERROR THEN
1594:
1595: IF c_get_items%ISOPEN THEN
1596: CLOSE c_get_items;
1597: END IF;

Line 1607: x_return_status := FND_API.G_RET_STS_ERROR ;

1603: IF c_get_derived_item_category%ISOPEN THEN
1604: CLOSE c_get_derived_item_category;
1605: END IF;
1606:
1607: x_return_status := FND_API.G_RET_STS_ERROR ;
1608:
1609: FND_MSG_PUB.Count_And_Get(
1610: p_count => x_msg_count,
1611: p_data => x_msg_data );

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

1610: p_count => x_msg_count,
1611: p_data => x_msg_data );
1612:
1613: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1616: END IF;
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1614: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
1615: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
1616: END IF;
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619:
1620: IF c_get_items%ISOPEN THEN
1621: CLOSE c_get_items;
1622: END IF;

Line 1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1628: IF c_get_derived_item_category%ISOPEN THEN
1629: CLOSE c_get_derived_item_category;
1630: END IF;
1631:
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1633:
1634: FND_MSG_PUB.Count_And_Get(
1635: p_count => x_msg_count,
1636: p_data => x_msg_data );

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

1635: p_count => x_msg_count,
1636: p_data => x_msg_data );
1637:
1638: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1639: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
1640: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
1641: END IF;
1642:
1643: WHEN OTHERS THEN

Line 1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1653: IF c_get_derived_item_category%ISOPEN THEN
1654: CLOSE c_get_derived_item_category;
1655: END IF;
1656:
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1658:
1659: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1660: FND_MSG_PUB.Add_Exc_Msg(
1661: G_PKG_NAME ,

Line 1682: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1678: -- line level system variables
1679: --
1680: PROCEDURE Get_Line_Variable_Values (
1681: p_api_version IN NUMBER,
1682: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1683: p_doc_type IN VARCHAR2,
1684: p_doc_id IN NUMBER,
1685: x_return_status OUT NOCOPY VARCHAR2,
1686: x_msg_count OUT NOCOPY NUMBER,

Line 1813: x_return_status := FND_API.G_RET_STS_SUCCESS;

1809: BEGIN
1810:
1811: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1812:
1813: x_return_status := FND_API.G_RET_STS_SUCCESS;
1814:
1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: l_debug := true;
1817: END IF;

Line 1828: IF NOT FND_API.Compatible_API_Call (l_api_version,

1824:
1825: --
1826: -- Standard call to check for call compatibility.
1827: --
1828: IF NOT FND_API.Compatible_API_Call (l_api_version,
1829: p_api_version,
1830: l_api_name,
1831: G_PKG_NAME)
1832: THEN

Line 1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1829: p_api_version,
1830: l_api_name,
1831: G_PKG_NAME)
1832: THEN
1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1834: END IF;
1835:
1836: --
1837: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1839: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1835:
1836: --
1837: -- Initialize message list if p_init_msg_list is set to TRUE.
1838: --
1839: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1840: FND_MSG_PUB.initialize;
1841: END IF;
1842:
1843: --AK

Line 2163: WHEN FND_API.G_EXC_ERROR THEN

2159: END IF;
2160:
2161: EXCEPTION
2162:
2163: WHEN FND_API.G_EXC_ERROR THEN
2164: IF c_get_bsa_line_variables%ISOPEN THEN
2165: CLOSE c_get_bsa_line_variables;
2166: END IF;
2167:

Line 2173: x_return_status := FND_API.G_RET_STS_ERROR ;

2169: CLOSE c_get_so_line_variables;
2170: END IF;
2171:
2172:
2173: x_return_status := FND_API.G_RET_STS_ERROR ;
2174:
2175: FND_MSG_PUB.Count_And_Get(
2176: p_count => x_msg_count,
2177: p_data => x_msg_data );

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

2176: p_count => x_msg_count,
2177: p_data => x_msg_data );
2178:
2179: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
2181: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
2182: END IF;
2183:
2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2180: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'180: '||l_package_procedure||' In the FND_API.G_EXC_ERROR section');
2181: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'190: x_return_status = '||x_return_status);
2182: END IF;
2183:
2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2185: IF c_get_bsa_line_variables%ISOPEN THEN
2186: CLOSE c_get_bsa_line_variables;
2187: END IF;
2188:

Line 2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2189: IF c_get_so_line_variables%ISOPEN THEN
2190: CLOSE c_get_so_line_variables;
2191: END IF;
2192:
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2194:
2195: FND_MSG_PUB.Count_And_Get(
2196: p_count => x_msg_count,
2197: p_data => x_msg_data );

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

2196: p_count => x_msg_count,
2197: p_data => x_msg_data );
2198:
2199: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2200: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'200: '||l_package_procedure||' In the FND_API.G_EXC_UNEXPECTED_ERROR section');
2201: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'210: x_return_status = '||x_return_status);
2202: END IF;
2203:
2204: WHEN OTHERS THEN

Line 2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2209: IF c_get_so_line_variables%ISOPEN THEN
2210: CLOSE c_get_so_line_variables;
2211: END IF;
2212:
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2214:
2215: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2216: FND_MSG_PUB.Add_Exc_Msg(
2217: G_PKG_NAME ,