DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_PVT dependencies on JTF_PLSQL_API

Line 1226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1222: Add_Err_Msg;
1223: retcode := 2;
1224: errbuf := X_Msg_Data;
1225:
1226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1227: P_API_NAME => L_API_NAME
1228: ,P_PKG_NAME => G_PKG_NAME
1229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1227: P_API_NAME => L_API_NAME
1228: ,P_PKG_NAME => G_PKG_NAME
1229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1231: ,P_ROLLBACK_FLAG => l_Rollback
1232: ,X_MSG_COUNT => X_MSG_COUNT
1233: ,X_MSG_DATA => X_MSG_DATA
1234: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1237: Add_Err_Msg;
1238: retcode := 2;
1239: errbuf := X_Msg_Data;
1240:
1241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1242: P_API_NAME => L_API_NAME
1243: ,P_PKG_NAME => G_PKG_NAME
1244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1242: P_API_NAME => L_API_NAME
1243: ,P_PKG_NAME => G_PKG_NAME
1244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1246: ,P_ROLLBACK_FLAG => l_Rollback
1247: ,X_MSG_COUNT => X_MSG_COUNT
1248: ,X_MSG_DATA => X_MSG_DATA
1249: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1263: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1264: fnd_msg_pub.add;
1265: Add_Err_Msg;
1266:
1267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1268: P_API_NAME => L_API_NAME
1269: ,P_PKG_NAME => G_PKG_NAME
1270: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1270: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1266:
1267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1268: P_API_NAME => L_API_NAME
1269: ,P_PKG_NAME => G_PKG_NAME
1270: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1272: ,P_SQLCODE => l_sqlcode
1273: ,P_SQLERRM => l_sqlerrm
1274: ,P_ROLLBACK_FLAG => l_Rollback

Line 1271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1268: P_API_NAME => L_API_NAME
1269: ,P_PKG_NAME => G_PKG_NAME
1270: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1272: ,P_SQLCODE => l_sqlcode
1273: ,P_SQLERRM => l_sqlerrm
1274: ,P_ROLLBACK_FLAG => l_Rollback
1275: ,X_MSG_COUNT => X_MSG_COUNT

Line 1736: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1732:
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: /** This returns 'E' as status **/
1735:
1736: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1737: P_API_NAME => L_API_NAME
1738: ,P_PKG_NAME => G_PKG_NAME
1739: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1740: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1740: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1736: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1737: P_API_NAME => L_API_NAME
1738: ,P_PKG_NAME => G_PKG_NAME
1739: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1740: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1741: ,P_ROLLBACK_FLAG => l_Rollback
1742: ,X_MSG_COUNT => X_MSG_COUNT
1743: ,X_MSG_DATA => X_MSG_DATA
1744: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1749: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1745:
1746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1747: /** This returns 'U' as status **/
1748:
1749: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1750: P_API_NAME => L_API_NAME
1751: ,P_PKG_NAME => G_PKG_NAME
1752: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1753: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1753: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1749: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1750: P_API_NAME => L_API_NAME
1751: ,P_PKG_NAME => G_PKG_NAME
1752: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1753: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1754: ,P_ROLLBACK_FLAG => l_Rollback
1755: ,X_MSG_COUNT => X_MSG_COUNT
1756: ,X_MSG_DATA => X_MSG_DATA
1757: ,X_RETURN_STATUS => X_RETURN_STATUS);