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.CSP_PICK_UTILS dependencies on JTF_PLSQL_API

Line 761: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

757: , p_data => x_msg_data);
758: x_return_status := FND_API.G_RET_STS_ERROR;
759:
760: WHEN FND_API.G_EXC_ERROR THEN
761: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
762: P_API_NAME => L_API_NAME
763: ,P_PKG_NAME => G_PKG_NAME
764: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
765: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 765: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

761: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
762: P_API_NAME => L_API_NAME
763: ,P_PKG_NAME => G_PKG_NAME
764: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
765: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
766: ,X_MSG_COUNT => X_MSG_COUNT
767: ,X_MSG_DATA => X_MSG_DATA
768: ,X_RETURN_STATUS => X_RETURN_STATUS);
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 770: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

766: ,X_MSG_COUNT => X_MSG_COUNT
767: ,X_MSG_DATA => X_MSG_DATA
768: ,X_RETURN_STATUS => X_RETURN_STATUS);
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
771: P_API_NAME => L_API_NAME
772: ,P_PKG_NAME => G_PKG_NAME
773: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
774: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 774: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

770: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
771: P_API_NAME => L_API_NAME
772: ,P_PKG_NAME => G_PKG_NAME
773: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
774: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
775: ,X_MSG_COUNT => X_MSG_COUNT
776: ,X_MSG_DATA => X_MSG_DATA
777: ,X_RETURN_STATUS => X_RETURN_STATUS);
778: WHEN OTHERS THEN

Line 1283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1279: , p_data => x_msg_data);
1280: x_return_status := FND_API.G_RET_STS_ERROR;
1281:
1282: WHEN FND_API.G_EXC_ERROR THEN
1283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1284: P_API_NAME => L_API_NAME
1285: ,P_PKG_NAME => G_PKG_NAME
1286: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1287: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1287: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1284: P_API_NAME => L_API_NAME
1285: ,P_PKG_NAME => G_PKG_NAME
1286: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1287: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1288: ,X_MSG_COUNT => X_MSG_COUNT
1289: ,X_MSG_DATA => X_MSG_DATA
1290: ,X_RETURN_STATUS => X_RETURN_STATUS);
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1292: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1288: ,X_MSG_COUNT => X_MSG_COUNT
1289: ,X_MSG_DATA => X_MSG_DATA
1290: ,X_RETURN_STATUS => X_RETURN_STATUS);
1291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1292: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1293: P_API_NAME => L_API_NAME
1294: ,P_PKG_NAME => G_PKG_NAME
1295: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1296: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1296: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1292: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1293: P_API_NAME => L_API_NAME
1294: ,P_PKG_NAME => G_PKG_NAME
1295: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1296: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1297: ,X_MSG_COUNT => X_MSG_COUNT
1298: ,X_MSG_DATA => X_MSG_DATA
1299: ,X_RETURN_STATUS => X_RETURN_STATUS);
1300: WHEN OTHERS THEN

Line 1658: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1654: ( p_count => x_msg_count
1655: , p_data => x_msg_data);
1656: x_return_status := FND_API.G_RET_STS_ERROR;
1657: WHEN FND_API.G_EXC_ERROR THEN
1658: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1659: P_API_NAME => L_API_NAME
1660: ,P_PKG_NAME => G_PKG_NAME
1661: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1662: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1662: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1658: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1659: P_API_NAME => L_API_NAME
1660: ,P_PKG_NAME => G_PKG_NAME
1661: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1662: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1663: ,X_MSG_COUNT => X_MSG_COUNT
1664: ,X_MSG_DATA => X_MSG_DATA
1665: ,X_RETURN_STATUS => X_RETURN_STATUS);
1666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1667: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1663: ,X_MSG_COUNT => X_MSG_COUNT
1664: ,X_MSG_DATA => X_MSG_DATA
1665: ,X_RETURN_STATUS => X_RETURN_STATUS);
1666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1667: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1668: P_API_NAME => L_API_NAME
1669: ,P_PKG_NAME => G_PKG_NAME
1670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1671: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1671: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1667: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1668: P_API_NAME => L_API_NAME
1669: ,P_PKG_NAME => G_PKG_NAME
1670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1671: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1672: ,X_MSG_COUNT => X_MSG_COUNT
1673: ,X_MSG_DATA => X_MSG_DATA
1674: ,X_RETURN_STATUS => X_RETURN_STATUS);
1675: WHEN OTHERS THEN

Line 1810: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1806: , p_data => x_msg_data);
1807: x_return_status := FND_API.G_RET_STS_ERROR;
1808:
1809: WHEN FND_API.G_EXC_ERROR THEN
1810: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1811: P_API_NAME => L_API_NAME
1812: ,P_PKG_NAME => G_PKG_NAME
1813: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1814: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1814: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1810: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1811: P_API_NAME => L_API_NAME
1812: ,P_PKG_NAME => G_PKG_NAME
1813: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1814: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1815: ,X_MSG_COUNT => X_MSG_COUNT
1816: ,X_MSG_DATA => X_MSG_DATA
1817: ,X_RETURN_STATUS => X_RETURN_STATUS);
1818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1819: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1815: ,X_MSG_COUNT => X_MSG_COUNT
1816: ,X_MSG_DATA => X_MSG_DATA
1817: ,X_RETURN_STATUS => X_RETURN_STATUS);
1818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1819: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1820: P_API_NAME => L_API_NAME
1821: ,P_PKG_NAME => G_PKG_NAME
1822: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1823: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1823: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1819: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1820: P_API_NAME => L_API_NAME
1821: ,P_PKG_NAME => G_PKG_NAME
1822: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1823: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1824: ,X_MSG_COUNT => X_MSG_COUNT
1825: ,X_MSG_DATA => X_MSG_DATA
1826: ,X_RETURN_STATUS => X_RETURN_STATUS);
1827: WHEN OTHERS THEN