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 939: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

935: WHEN FND_API.G_EXC_ERROR THEN
936: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 1');
937: retcode := 1;
938: errbuf := X_Msg_Data;
939: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
940: P_API_NAME => L_API_NAME
941: ,P_PKG_NAME => G_PKG_NAME
942: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
943: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 943: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

939: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
940: P_API_NAME => L_API_NAME
941: ,P_PKG_NAME => G_PKG_NAME
942: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
943: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
944: ,X_MSG_COUNT => X_MSG_COUNT
945: ,X_MSG_DATA => X_MSG_DATA
946: ,X_RETURN_STATUS => X_RETURN_STATUS);
947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 951: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
948: FND_FILE.put_line(FND_FILE.log,'MESSAGE: Inside exception 2');
949: retcode := 1;
950: errbuf := X_Msg_Data;
951: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME
953: ,P_PKG_NAME => G_PKG_NAME
954: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
955: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 955: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

951: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME
953: ,P_PKG_NAME => G_PKG_NAME
954: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
955: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
956: ,X_MSG_COUNT => X_MSG_COUNT
957: ,X_MSG_DATA => X_MSG_DATA
958: ,X_RETURN_STATUS => X_RETURN_STATUS);
959: WHEN OTHERS THEN

Line 965: /* JTF_PLSQL_API.HANDLE_EXCEPTIONS(

961: retcode := 1;
962: errbuf := X_Msg_Data;
963: l_sqlcode := SQLCODE;
964: l_sqlerrm := SQLERRM;
965: /* JTF_PLSQL_API.HANDLE_EXCEPTIONS(
966: P_API_NAME => L_API_NAME
967: ,P_PKG_NAME => G_PKG_NAME
968: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
969: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 968: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

964: l_sqlerrm := SQLERRM;
965: /* JTF_PLSQL_API.HANDLE_EXCEPTIONS(
966: P_API_NAME => L_API_NAME
967: ,P_PKG_NAME => G_PKG_NAME
968: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
969: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
970: ,P_SQLCODE => l_sqlcode
971: ,P_SQLERRM => l_sqlerrm
972: ,X_MSG_COUNT => X_MSG_COUNT

Line 969: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

965: /* JTF_PLSQL_API.HANDLE_EXCEPTIONS(
966: P_API_NAME => L_API_NAME
967: ,P_PKG_NAME => G_PKG_NAME
968: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
969: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
970: ,P_SQLCODE => l_sqlcode
971: ,P_SQLERRM => l_sqlerrm
972: ,X_MSG_COUNT => X_MSG_COUNT
973: ,X_MSG_DATA => X_MSG_DATA

Line 1114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1110: EXCEPTION
1111: WHEN FND_API.G_EXC_ERROR THEN
1112: retcode := 2;
1113: errbuf := X_Msg_Data;
1114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1115: P_API_NAME => L_API_NAME
1116: ,P_PKG_NAME => G_PKG_NAME
1117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1118: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1118: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1115: P_API_NAME => L_API_NAME
1116: ,P_PKG_NAME => G_PKG_NAME
1117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1118: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1119: ,X_MSG_COUNT => X_MSG_COUNT
1120: ,X_MSG_DATA => X_MSG_DATA
1121: ,X_RETURN_STATUS => X_RETURN_STATUS);
1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1125: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1121: ,X_RETURN_STATUS => X_RETURN_STATUS);
1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1123: retcode := 2;
1124: errbuf := X_Msg_Data;
1125: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1126: P_API_NAME => L_API_NAME
1127: ,P_PKG_NAME => G_PKG_NAME
1128: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1129: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1129: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1125: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1126: P_API_NAME => L_API_NAME
1127: ,P_PKG_NAME => G_PKG_NAME
1128: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1129: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1130: ,X_MSG_COUNT => X_MSG_COUNT
1131: ,X_MSG_DATA => X_MSG_DATA
1132: ,X_RETURN_STATUS => X_RETURN_STATUS);
1133: WHEN OTHERS THEN

Line 1138: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1134: retcode := 2;
1135: errbuf := X_Msg_Data;
1136: l_sqlcode := SQLCODE;
1137: l_sqlerrm := SQLERRM;
1138: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1139: P_API_NAME => L_API_NAME
1140: ,P_PKG_NAME => G_PKG_NAME
1141: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1142: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1141: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1137: l_sqlerrm := SQLERRM;
1138: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1139: P_API_NAME => L_API_NAME
1140: ,P_PKG_NAME => G_PKG_NAME
1141: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1142: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1143: ,P_SQLCODE => l_sqlcode
1144: ,P_SQLERRM => l_sqlerrm
1145: ,X_MSG_COUNT => X_MSG_COUNT

Line 1142: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1138: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1139: P_API_NAME => L_API_NAME
1140: ,P_PKG_NAME => G_PKG_NAME
1141: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1142: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1143: ,P_SQLCODE => l_sqlcode
1144: ,P_SQLERRM => l_sqlerrm
1145: ,X_MSG_COUNT => X_MSG_COUNT
1146: ,X_MSG_DATA => X_MSG_DATA

Line 1324: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: retcode := 2;
1323: errbuf := X_Msg_Data;
1324: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1325: P_API_NAME => L_API_NAME
1326: ,P_PKG_NAME => G_PKG_NAME
1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1328: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1328: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1324: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1325: P_API_NAME => L_API_NAME
1326: ,P_PKG_NAME => G_PKG_NAME
1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1328: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1329: ,X_MSG_COUNT => X_MSG_COUNT
1330: ,X_MSG_DATA => X_MSG_DATA
1331: ,X_RETURN_STATUS => X_RETURN_STATUS);
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1335: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1331: ,X_RETURN_STATUS => X_RETURN_STATUS);
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1333: retcode := 2;
1334: errbuf := X_Msg_Data;
1335: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1336: P_API_NAME => L_API_NAME
1337: ,P_PKG_NAME => G_PKG_NAME
1338: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1339: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1339: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1335: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1336: P_API_NAME => L_API_NAME
1337: ,P_PKG_NAME => G_PKG_NAME
1338: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1339: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1340: ,X_MSG_COUNT => X_MSG_COUNT
1341: ,X_MSG_DATA => X_MSG_DATA
1342: ,X_RETURN_STATUS => X_RETURN_STATUS);
1343: WHEN OTHERS THEN

Line 1348: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1344: retcode := 2;
1345: errbuf := X_Msg_Data;
1346: l_sqlcode := SQLCODE;
1347: l_sqlerrm := SQLERRM;
1348: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1349: P_API_NAME => L_API_NAME
1350: ,P_PKG_NAME => G_PKG_NAME
1351: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1352: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1351: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1347: l_sqlerrm := SQLERRM;
1348: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1349: P_API_NAME => L_API_NAME
1350: ,P_PKG_NAME => G_PKG_NAME
1351: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1352: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1353: ,P_SQLCODE => l_sqlcode
1354: ,P_SQLERRM => l_sqlerrm
1355: ,X_MSG_COUNT => X_MSG_COUNT

Line 1352: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1348: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1349: P_API_NAME => L_API_NAME
1350: ,P_PKG_NAME => G_PKG_NAME
1351: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1352: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1353: ,P_SQLCODE => l_sqlcode
1354: ,P_SQLERRM => l_sqlerrm
1355: ,X_MSG_COUNT => X_MSG_COUNT
1356: ,X_MSG_DATA => X_MSG_DATA