APPS.CSP_PORTAL_EXCESS_PARTS_PVT dependencies on FND_API

Line 18: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

14:
15: l_api_version_number CONSTANT NUMBER := 1.0;
16: p_api_version CONSTANT NUMBER := 1.0;
17: l_api_name CONSTANT VARCHAR2(30) := 'Portal_Excess_Parts';
18: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: l_msg_count NUMBER;
20: l_msg_data VARCHAR2(2000);
21: l_sqlcode Number;
22: l_sqlerrm Varchar2(2000);

Line 45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

41:
42: SAVEPOINT Portal_Excess_Parts_PVT;
43: FND_MSG_PUB.initialize;
44:
45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
46: p_api_version,
47: l_api_name,
48: G_PKG_NAME)
49: THEN

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46: p_api_version,
47: l_api_name,
48: G_PKG_NAME)
49: THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: FOR SUBINVREC in subinv(p_resource_id, p_resource_type, p_condition_type)
54: Loop

Line 105: RAISE FND_API.G_EXC_ERROR;

101: ,2
102: );
103:
104: IF nvl(retcode,0) <> 0 THEN
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107:
108: End Loop;
109:

Line 113: l_return_status := FND_API.G_RET_STS_SUCCESS;

109:
110: End Loop;
111:
112: COMMIT WORK;
113: l_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: FND_MSG_PUB.Count_And_Get
116: (p_count => l_msg_count,
117: p_data => l_msg_data

Line 123: WHEN FND_API.G_EXC_ERROR THEN

119:
120: retcode := 0;
121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: retcode := 2;
125: errbuf := l_Msg_Data;
126: l_return_status := FND_API.G_RET_STS_ERROR;
127: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 126: l_return_status := FND_API.G_RET_STS_ERROR;

122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: retcode := 2;
125: errbuf := l_Msg_Data;
126: l_return_status := FND_API.G_RET_STS_ERROR;
127: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
128: P_API_NAME => L_API_NAME
129: ,P_PKG_NAME => G_PKG_NAME
130: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

132: ,X_MSG_COUNT => l_MSG_COUNT
133: ,X_MSG_DATA => l_MSG_DATA
134: ,X_RETURN_STATUS => l_RETURN_STATUS);
135:
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: retcode := 2;
138: errbuf := l_Msg_Data;
139: l_return_status := FND_API.G_RET_STS_ERROR;
140: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 139: l_return_status := FND_API.G_RET_STS_ERROR;

135:
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: retcode := 2;
138: errbuf := l_Msg_Data;
139: l_return_status := FND_API.G_RET_STS_ERROR;
140: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
141: P_API_NAME => L_API_NAME
142: ,P_PKG_NAME => G_PKG_NAME
143: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 155: l_return_status := FND_API.G_RET_STS_ERROR;

151: retcode := 2;
152: errbuf := l_Msg_Data;
153: l_sqlcode := SQLCODE;
154: l_sqlerrm := SQLERRM;
155: l_return_status := FND_API.G_RET_STS_ERROR;
156:
157: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
158: P_API_NAME => L_API_NAME
159: ,P_PKG_NAME => G_PKG_NAME