APPS.IEM_GETCUST_PVT dependencies on FND_API

Line 96: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

92: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
93: order by 2,1 DESC;
94: BEGIN
95: -- Standard call to check for call compatibility.
96: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
97: p_api_version_number,
98: l_api_name,
99: G_PKG_NAME)
100: THEN

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

97: p_api_version_number,
98: l_api_name,
99: G_PKG_NAME)
100: THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: l_rec_tbl.delete;
105: l_rec_tbl1.delete;

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

99: G_PKG_NAME)
100: THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: l_rec_tbl.delete;
105: l_rec_tbl1.delete;
106: l_rec_tbl2.delete;
107: for v1 in c1 LOOP

Line 151: WHEN FND_API.G_EXC_ERROR THEN

147: ( p_count => x_msg_count,
148: p_data => x_msg_data
149: );
150: EXCEPTION
151: WHEN FND_API.G_EXC_ERROR THEN
152: x_return_status := FND_API.G_RET_STS_ERROR ;
153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data

Line 152: x_return_status := FND_API.G_RET_STS_ERROR ;

148: p_data => x_msg_data
149: );
150: EXCEPTION
151: WHEN FND_API.G_EXC_ERROR THEN
152: x_return_status := FND_API.G_RET_STS_ERROR ;
153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data
156: );

Line 157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data
156: );
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,
161: p_data => x_msg_data

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

154: ( p_count => x_msg_count,
155: p_data => x_msg_data
156: );
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,
161: p_data => x_msg_data
162: );

Line 164: x_return_status := FND_API.G_RET_STS_ERROR;

160: ( p_count => x_msg_count,
161: p_data => x_msg_data
162: );
163: WHEN OTHERS THEN
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: IF FND_MSG_PUB.Check_Msg_Level
166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
167: THEN
168: FND_MSG_PUB.Add_Exc_Msg