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

Line 899: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

895: WHEN FND_API.G_EXC_ERROR THEN
896: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 1');
897: retcode := 1;
898: errbuf := X_Msg_Data;
899: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME
901: ,P_PKG_NAME => G_PKG_NAME
902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
903: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 903: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

899: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME
901: ,P_PKG_NAME => G_PKG_NAME
902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
903: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
904: ,X_MSG_COUNT => X_MSG_COUNT
905: ,X_MSG_DATA => X_MSG_DATA
906: ,X_RETURN_STATUS => X_RETURN_STATUS);
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 911: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
908: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 2');
909: retcode := 1;
910: errbuf := X_Msg_Data;
911: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
912: P_API_NAME => L_API_NAME
913: ,P_PKG_NAME => G_PKG_NAME
914: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
915: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 915: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

911: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
912: P_API_NAME => L_API_NAME
913: ,P_PKG_NAME => G_PKG_NAME
914: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
915: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
916: ,X_MSG_COUNT => X_MSG_COUNT
917: ,X_MSG_DATA => X_MSG_DATA
918: ,X_RETURN_STATUS => X_RETURN_STATUS);
919: WHEN OTHERS THEN

Line 925: /* JTF_PLSQL_API.HANDLE_EXCEPTIONS(

921: retcode := 1;
922: errbuf := X_Msg_Data;
923: l_sqlcode := SQLCODE;
924: l_sqlerrm := SQLERRM;
925: /* JTF_PLSQL_API.HANDLE_EXCEPTIONS(
926: P_API_NAME => L_API_NAME
927: ,P_PKG_NAME => G_PKG_NAME
928: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
929: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 928: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

924: l_sqlerrm := SQLERRM;
925: /* JTF_PLSQL_API.HANDLE_EXCEPTIONS(
926: P_API_NAME => L_API_NAME
927: ,P_PKG_NAME => G_PKG_NAME
928: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
929: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
930: ,P_SQLCODE => l_sqlcode
931: ,P_SQLERRM => l_sqlerrm
932: ,X_MSG_COUNT => X_MSG_COUNT

Line 929: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

925: /* JTF_PLSQL_API.HANDLE_EXCEPTIONS(
926: P_API_NAME => L_API_NAME
927: ,P_PKG_NAME => G_PKG_NAME
928: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
929: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
930: ,P_SQLCODE => l_sqlcode
931: ,P_SQLERRM => l_sqlerrm
932: ,X_MSG_COUNT => X_MSG_COUNT
933: ,X_MSG_DATA => X_MSG_DATA

Line 1067: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1063: EXCEPTION
1064: WHEN FND_API.G_EXC_ERROR THEN
1065: retcode := 2;
1066: errbuf := X_Msg_Data;
1067: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1068: P_API_NAME => L_API_NAME
1069: ,P_PKG_NAME => G_PKG_NAME
1070: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1071: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1071: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1067: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1068: P_API_NAME => L_API_NAME
1069: ,P_PKG_NAME => G_PKG_NAME
1070: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1071: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1072: ,X_MSG_COUNT => X_MSG_COUNT
1073: ,X_MSG_DATA => X_MSG_DATA
1074: ,X_RETURN_STATUS => X_RETURN_STATUS);
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1074: ,X_RETURN_STATUS => X_RETURN_STATUS);
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1076: retcode := 2;
1077: errbuf := X_Msg_Data;
1078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1079: P_API_NAME => L_API_NAME
1080: ,P_PKG_NAME => G_PKG_NAME
1081: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1082: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1082: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1079: P_API_NAME => L_API_NAME
1080: ,P_PKG_NAME => G_PKG_NAME
1081: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1082: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1083: ,X_MSG_COUNT => X_MSG_COUNT
1084: ,X_MSG_DATA => X_MSG_DATA
1085: ,X_RETURN_STATUS => X_RETURN_STATUS);
1086: WHEN OTHERS THEN

Line 1091: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1087: retcode := 2;
1088: errbuf := X_Msg_Data;
1089: l_sqlcode := SQLCODE;
1090: l_sqlerrm := SQLERRM;
1091: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1092: P_API_NAME => L_API_NAME
1093: ,P_PKG_NAME => G_PKG_NAME
1094: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1095: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1094: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1090: l_sqlerrm := SQLERRM;
1091: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1092: P_API_NAME => L_API_NAME
1093: ,P_PKG_NAME => G_PKG_NAME
1094: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1095: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1096: ,P_SQLCODE => l_sqlcode
1097: ,P_SQLERRM => l_sqlerrm
1098: ,X_MSG_COUNT => X_MSG_COUNT

Line 1095: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1091: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1092: P_API_NAME => L_API_NAME
1093: ,P_PKG_NAME => G_PKG_NAME
1094: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1095: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1096: ,P_SQLCODE => l_sqlcode
1097: ,P_SQLERRM => l_sqlerrm
1098: ,X_MSG_COUNT => X_MSG_COUNT
1099: ,X_MSG_DATA => X_MSG_DATA

Line 1277: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1273: EXCEPTION
1274: WHEN FND_API.G_EXC_ERROR THEN
1275: retcode := 2;
1276: errbuf := X_Msg_Data;
1277: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1278: P_API_NAME => L_API_NAME
1279: ,P_PKG_NAME => G_PKG_NAME
1280: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1281: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1281: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1277: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1278: P_API_NAME => L_API_NAME
1279: ,P_PKG_NAME => G_PKG_NAME
1280: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1281: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1282: ,X_MSG_COUNT => X_MSG_COUNT
1283: ,X_MSG_DATA => X_MSG_DATA
1284: ,X_RETURN_STATUS => X_RETURN_STATUS);
1285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1288: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1284: ,X_RETURN_STATUS => X_RETURN_STATUS);
1285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1286: retcode := 2;
1287: errbuf := X_Msg_Data;
1288: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1289: P_API_NAME => L_API_NAME
1290: ,P_PKG_NAME => G_PKG_NAME
1291: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1292: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1292: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 1301: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1297: retcode := 2;
1298: errbuf := X_Msg_Data;
1299: l_sqlcode := SQLCODE;
1300: l_sqlerrm := SQLERRM;
1301: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1302: P_API_NAME => L_API_NAME
1303: ,P_PKG_NAME => G_PKG_NAME
1304: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1305: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1304: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1300: l_sqlerrm := SQLERRM;
1301: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1302: P_API_NAME => L_API_NAME
1303: ,P_PKG_NAME => G_PKG_NAME
1304: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1305: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1306: ,P_SQLCODE => l_sqlcode
1307: ,P_SQLERRM => l_sqlerrm
1308: ,X_MSG_COUNT => X_MSG_COUNT

Line 1305: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1301: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1302: P_API_NAME => L_API_NAME
1303: ,P_PKG_NAME => G_PKG_NAME
1304: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1305: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1306: ,P_SQLCODE => l_sqlcode
1307: ,P_SQLERRM => l_sqlerrm
1308: ,X_MSG_COUNT => X_MSG_COUNT
1309: ,X_MSG_DATA => X_MSG_DATA