DBA Data[Home] [Help]

APPS.IEM_REROUTING_HISTS_PVT dependencies on FND_API

Line 41: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

37: l_grp_cnt number;
38:
39: BEGIN
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
42: p_api_version_number,
43: l_api_name,
44: G_PKG_NAME)
45: THEN

Line 46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

42: p_api_version_number,
43: l_api_name,
44: G_PKG_NAME)
45: THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF p_init_msg_list ='T'

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44: G_PKG_NAME)
45: THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF p_init_msg_list ='T'
51: THEN
52: FND_MSG_PUB.initialize;

Line 116: WHEN FND_API.G_EXC_ERROR THEN

112: ( p_count => x_msg_count,
113: p_data => x_msg_data
114: );
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_ERROR ;
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data

Line 117: x_return_status := FND_API.G_RET_STS_ERROR ;

113: p_data => x_msg_data
114: );
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_ERROR ;
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );

Line 122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,
126: p_data => x_msg_data

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,
126: p_data => x_msg_data
127: );

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: ( p_count => x_msg_count,
126: p_data => x_msg_data
127: );
128: WHEN OTHERS THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level
131: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.Add_Exc_Msg

Line 158: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

154: l_api_version_number NUMBER:=1.0;
155:
156: BEGIN
157: -- Standard call to check for call compatibility.
158: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
159: p_api_version_number,
160: l_api_name,
161: G_PKG_NAME)
162: THEN

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: p_api_version_number,
160: l_api_name,
161: G_PKG_NAME)
162: THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166: -- Initialize message list if p_init_msg_list is set to TRUE.
167: IF p_init_msg_list ='T'

Line 165: x_return_status := FND_API.G_RET_STS_SUCCESS;

161: G_PKG_NAME)
162: THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166: -- Initialize message list if p_init_msg_list is set to TRUE.
167: IF p_init_msg_list ='T'
168: THEN
169: FND_MSG_PUB.initialize;

Line 184: WHEN FND_API.G_EXC_ERROR THEN

180: ( p_count => x_msg_count,
181: p_data => x_msg_data
182: );
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: ROLLBACK TO delete_item_PVT;
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: FND_MSG_PUB.Count_And_Get
188: ( p_count => x_msg_count,

Line 186: x_return_status := FND_API.G_RET_STS_ERROR ;

182: );
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: ROLLBACK TO delete_item_PVT;
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: FND_MSG_PUB.Count_And_Get
188: ( p_count => x_msg_count,
189: p_data => x_msg_data
190: );

Line 191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

187: FND_MSG_PUB.Count_And_Get
188: ( p_count => x_msg_count,
189: p_data => x_msg_data
190: );
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192: ROLLBACK TO delete_item_PVT;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: FND_MSG_PUB.Count_And_Get
195: ( p_count => x_msg_count,

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

189: p_data => x_msg_data
190: );
191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192: ROLLBACK TO delete_item_PVT;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: FND_MSG_PUB.Count_And_Get
195: ( p_count => x_msg_count,
196: p_data => x_msg_data
197: );

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: p_data => x_msg_data
197: );
198: WHEN OTHERS THEN
199: ROLLBACK TO delete_item_PVT;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg