DBA Data[Home] [Help]

APPS.CSP_NOTIFICATIONS_PVT dependencies on FND_API

Line 133: IF NOT FND_API.Compatible_API_Call (l_api_version ,

129:
130: -- Standard Start of API savepoint
131: SAVEPOINT calculate_loop_pvt;
132: -- Standard call to check for call compatibility.
133: IF NOT FND_API.Compatible_API_Call (l_api_version ,
134: p_api_version ,
135: l_api_name ,
136: G_PKG_NAME )
137: THEN

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: p_api_version ,
135: l_api_name ,
136: G_PKG_NAME )
137: THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:

Line 141: x_return_status := FND_API.G_RET_STS_SUCCESS;

137: THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:
143: IF p_include_move_orders is null THEN
144: OPEN c_calculation_rule;
145: FETCH c_calculation_rule into

Line 191: WHEN FND_API.G_EXC_ERROR THEN

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

Line 193: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

194: FND_MSG_PUB.Count_And_Get
195: (p_count => x_msg_count ,
196: p_data => x_msg_data
197: );
198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
199: ROLLBACK TO calculate_loop_pvt;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201: FND_MSG_PUB.Count_And_Get
202: (p_count => x_msg_count ,

Line 200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

196: p_data => x_msg_data
197: );
198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
199: ROLLBACK TO calculate_loop_pvt;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201: FND_MSG_PUB.Count_And_Get
202: (p_count => x_msg_count ,
203: p_data => x_msg_data
204: );

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

203: p_data => x_msg_data
204: );
205: WHEN OTHERS THEN
206: ROLLBACK TO calculate_loop_pvt;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
208: IF FND_MSG_PUB.Check_Msg_Level
209: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
210: THEN
211: FND_MSG_PUB.Add_Exc_Msg

Line 297: IF NOT FND_API.Compatible_API_Call (l_api_version ,

293:
294: -- Standard Start of API savepoint
295: SAVEPOINT create_notifications_pvt;
296: -- Standard call to check for call compatibility.
297: IF NOT FND_API.Compatible_API_Call (l_api_version ,
298: p_api_version ,
299: l_api_name ,
300: G_PKG_NAME )
301: THEN

Line 302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

298: p_api_version ,
299: l_api_name ,
300: G_PKG_NAME )
301: THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304: -- Initialize API return status to success
305: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
306:

Line 305: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

301: THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304: -- Initialize API return status to success
305: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: FOR cr IN c_parts_loops LOOP
308: FOR curs IN c_items(cr.parts_loop_id) LOOP
309:

Line 451: WHEN FND_API.G_EXC_ERROR THEN

447: -- (p_count => x_msg_count ,
448: -- p_data => x_msg_data
449: -- );
450: EXCEPTION
451: WHEN FND_API.G_EXC_ERROR THEN
452: ROLLBACK TO create_notifications_pvt;
453: -- x_return_status := FND_API.G_RET_STS_ERROR ;
454: -- FND_MSG_PUB.Count_And_Get
455: -- (p_count => x_msg_count ,

Line 453: -- x_return_status := FND_API.G_RET_STS_ERROR ;

449: -- );
450: EXCEPTION
451: WHEN FND_API.G_EXC_ERROR THEN
452: ROLLBACK TO create_notifications_pvt;
453: -- x_return_status := FND_API.G_RET_STS_ERROR ;
454: -- FND_MSG_PUB.Count_And_Get
455: -- (p_count => x_msg_count ,
456: -- p_data => x_msg_data
457: -- );

Line 458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

454: -- FND_MSG_PUB.Count_And_Get
455: -- (p_count => x_msg_count ,
456: -- p_data => x_msg_data
457: -- );
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
459: ROLLBACK TO create_notifications_pvt;
460: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
461: -- FND_MSG_PUB.Count_And_Get
462: -- (p_count => x_msg_count ,

Line 460: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

456: -- p_data => x_msg_data
457: -- );
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
459: ROLLBACK TO create_notifications_pvt;
460: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
461: -- FND_MSG_PUB.Count_And_Get
462: -- (p_count => x_msg_count ,
463: -- p_data => x_msg_data
464: -- );

Line 467: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

463: -- p_data => x_msg_data
464: -- );
465: WHEN OTHERS THEN
466: ROLLBACK TO create_notifications_pvt;
467: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
468: IF FND_MSG_PUB.Check_Msg_Level
469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
470: THEN
471: FND_MSG_PUB.Add_Exc_Msg