DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_PVT dependencies on JTF_PLSQL_API

Line 1484: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1480: Add_Err_Msg;
1481: retcode := 2;
1482: errbuf := X_Msg_Data;
1483:
1484: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1485: P_API_NAME => L_API_NAME
1486: ,P_PKG_NAME => G_PKG_NAME
1487: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1488: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1488: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1484: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1485: P_API_NAME => L_API_NAME
1486: ,P_PKG_NAME => G_PKG_NAME
1487: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1488: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1489: ,P_ROLLBACK_FLAG => l_Rollback
1490: ,X_MSG_COUNT => X_MSG_COUNT
1491: ,X_MSG_DATA => X_MSG_DATA
1492: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1495: Add_Err_Msg;
1496: retcode := 2;
1497: errbuf := X_Msg_Data;
1498:
1499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1500: P_API_NAME => L_API_NAME
1501: ,P_PKG_NAME => G_PKG_NAME
1502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1500: P_API_NAME => L_API_NAME
1501: ,P_PKG_NAME => G_PKG_NAME
1502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1504: ,P_ROLLBACK_FLAG => l_Rollback
1505: ,X_MSG_COUNT => X_MSG_COUNT
1506: ,X_MSG_DATA => X_MSG_DATA
1507: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1525: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1521: fnd_message.set_token('SQLERRM', l_sqlcode || ': ' || l_sqlerrm, TRUE);
1522: fnd_msg_pub.add;
1523: Add_Err_Msg;
1524:
1525: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1526: P_API_NAME => L_API_NAME
1527: ,P_PKG_NAME => G_PKG_NAME
1528: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1529: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1528: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1524:
1525: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1526: P_API_NAME => L_API_NAME
1527: ,P_PKG_NAME => G_PKG_NAME
1528: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1529: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1530: ,P_SQLCODE => l_sqlcode
1531: ,P_SQLERRM => l_sqlerrm
1532: ,P_ROLLBACK_FLAG => l_Rollback

Line 1529: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1525: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1526: P_API_NAME => L_API_NAME
1527: ,P_PKG_NAME => G_PKG_NAME
1528: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1529: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1530: ,P_SQLCODE => l_sqlcode
1531: ,P_SQLERRM => l_sqlerrm
1532: ,P_ROLLBACK_FLAG => l_Rollback
1533: ,X_MSG_COUNT => X_MSG_COUNT

Line 2162: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2158:
2159: WHEN FND_API.G_EXC_ERROR THEN
2160: /** This returns 'E' as status **/
2161:
2162: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2163: P_API_NAME => L_API_NAME
2164: ,P_PKG_NAME => G_PKG_NAME
2165: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2166: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2166: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2162: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2163: P_API_NAME => L_API_NAME
2164: ,P_PKG_NAME => G_PKG_NAME
2165: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2166: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2167: ,P_ROLLBACK_FLAG => l_Rollback
2168: ,X_MSG_COUNT => X_MSG_COUNT
2169: ,X_MSG_DATA => X_MSG_DATA
2170: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

2171:
2172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2173: /** This returns 'U' as status **/
2174:
2175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2176: P_API_NAME => L_API_NAME
2177: ,P_PKG_NAME => G_PKG_NAME
2178: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2179: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 2179: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

2175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2176: P_API_NAME => L_API_NAME
2177: ,P_PKG_NAME => G_PKG_NAME
2178: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2179: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2180: ,P_ROLLBACK_FLAG => l_Rollback
2181: ,X_MSG_COUNT => X_MSG_COUNT
2182: ,X_MSG_DATA => X_MSG_DATA
2183: ,X_RETURN_STATUS => X_RETURN_STATUS);