50:
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF FND_API.to_Boolean( p_init_msg_list )
53: THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57: -- Debug Message
58: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
92: EXCEPTION
93:
94: WHEN AMS_Utility_PVT.resource_locked THEN
95: x_return_status := FND_API.g_ret_sts_error;
96: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
97: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
98: FND_MSG_PUB.add;
99: END IF;
100:
94: WHEN AMS_Utility_PVT.resource_locked THEN
95: x_return_status := FND_API.g_ret_sts_error;
96: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
97: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
98: FND_MSG_PUB.add;
99: END IF;
100:
101: WHEN FND_API.G_EXC_ERROR THEN
102: ROLLBACK TO LOCK_Dmlift_PUB;
101: WHEN FND_API.G_EXC_ERROR THEN
102: ROLLBACK TO LOCK_Dmlift_PUB;
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: -- Standard call to get message count and if count=1, get the message
105: FND_MSG_PUB.Count_And_Get (
106: p_encoded => FND_API.G_FALSE,
107: p_count => x_msg_count,
108: p_data => x_msg_data
109: );
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: ROLLBACK TO LOCK_Dmlift_PUB;
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: -- Standard call to get message count and if count=1, get the message
115: FND_MSG_PUB.Count_And_Get (
116: p_encoded => FND_API.G_FALSE,
117: p_count => x_msg_count,
118: p_data => x_msg_data
119: );
120:
121: WHEN OTHERS THEN
122: ROLLBACK TO LOCK_Dmlift_PUB;
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
127: END IF;
128: -- Standard call to get message count and if count=1, get the message
122: ROLLBACK TO LOCK_Dmlift_PUB;
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
127: END IF;
128: -- Standard call to get message count and if count=1, get the message
129: FND_MSG_PUB.Count_And_Get (
130: p_encoded => FND_API.G_FALSE,
125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
127: END IF;
128: -- Standard call to get message count and if count=1, get the message
129: FND_MSG_PUB.Count_And_Get (
130: p_encoded => FND_API.G_FALSE,
131: p_count => x_msg_count,
132: p_data => x_msg_data
133: );
166:
167: -- Initialize message list if p_init_msg_list is set to TRUE.
168: IF FND_API.to_Boolean( p_init_msg_list )
169: THEN
170: FND_MSG_PUB.initialize;
171: END IF;
172:
173: -- Debug Message
174: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
228: -- Debug Message
229: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
230:
231: -- Standard call to get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get
233: (p_count => x_msg_count,
234: p_data => x_msg_data
235: );
236: EXCEPTION
236: EXCEPTION
237:
238: WHEN AMS_Utility_PVT.resource_locked THEN
239: x_return_status := FND_API.g_ret_sts_error;
240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
241: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
242: FND_MSG_PUB.add;
243: END IF;
244:
238: WHEN AMS_Utility_PVT.resource_locked THEN
239: x_return_status := FND_API.g_ret_sts_error;
240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
241: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
242: FND_MSG_PUB.add;
243: END IF;
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK TO Create_Lift_PUB;
245: WHEN FND_API.G_EXC_ERROR THEN
246: ROLLBACK TO Create_Lift_PUB;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: -- Standard call to get message count and if count=1, get the message
249: FND_MSG_PUB.Count_And_Get (
250: p_encoded => FND_API.G_FALSE,
251: p_count => x_msg_count,
252: p_data => x_msg_data
253: );
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK TO Create_Lift_PUB;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: -- Standard call to get message count and if count=1, get the message
259: FND_MSG_PUB.Count_And_Get (
260: p_encoded => FND_API.G_FALSE,
261: p_count => x_msg_count,
262: p_data => x_msg_data
263: );
264:
265: WHEN OTHERS THEN
266: ROLLBACK TO Create_Lift_PUB;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
269: THEN
270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
271: END IF;
272: -- Standard call to get message count and if count=1, get the message
266: ROLLBACK TO Create_Lift_PUB;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
269: THEN
270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
271: END IF;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (
274: p_encoded => FND_API.G_FALSE,
269: THEN
270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
271: END IF;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data
277: );
311:
312: -- Initialize message list if p_init_msg_list is set to TRUE.
313: IF FND_API.to_Boolean( p_init_msg_list )
314: THEN
315: FND_MSG_PUB.initialize;
316: END IF;
317:
318: -- Debug Message
319: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
357: -- Debug Message
358: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
359:
360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get
362: (p_count => x_msg_count,
363: p_data => x_msg_data
364: );
365: EXCEPTION
365: EXCEPTION
366:
367: WHEN AMS_Utility_PVT.resource_locked THEN
368: x_return_status := FND_API.g_ret_sts_error;
369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
370: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
371: FND_MSG_PUB.add;
372: END IF;
373:
367: WHEN AMS_Utility_PVT.resource_locked THEN
368: x_return_status := FND_API.g_ret_sts_error;
369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
370: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
371: FND_MSG_PUB.add;
372: END IF;
373:
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO Update_Lift_PUB;
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO Update_Lift_PUB;
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: -- Standard call to get message count and if count=1, get the message
378: FND_MSG_PUB.Count_And_Get (
379: p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,
381: p_data => x_msg_data
382: );
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO Update_Lift_PUB;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: -- Standard call to get message count and if count=1, get the message
388: FND_MSG_PUB.Count_And_Get (
389: p_encoded => FND_API.G_FALSE,
390: p_count => x_msg_count,
391: p_data => x_msg_data
392: );
393:
394: WHEN OTHERS THEN
395: ROLLBACK TO Update_Lift_PUB;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
400: END IF;
401: -- Standard call to get message count and if count=1, get the message
395: ROLLBACK TO Update_Lift_PUB;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
400: END IF;
401: -- Standard call to get message count and if count=1, get the message
402: FND_MSG_PUB.Count_And_Get (
403: p_encoded => FND_API.G_FALSE,
398: THEN
399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
400: END IF;
401: -- Standard call to get message count and if count=1, get the message
402: FND_MSG_PUB.Count_And_Get (
403: p_encoded => FND_API.G_FALSE,
404: p_count => x_msg_count,
405: p_data => x_msg_data
406: );
439:
440: -- Initialize message list if p_init_msg_list is set to TRUE.
441: IF FND_API.to_Boolean( p_init_msg_list )
442: THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:
446: -- Debug Message
447: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
485: -- Debug Message
486: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
487:
488: -- Standard call to get message count and if count is 1, get message info.
489: FND_MSG_PUB.Count_And_Get
490: (p_count => x_msg_count,
491: p_data => x_msg_data
492: );
493: EXCEPTION
493: EXCEPTION
494:
495: WHEN AMS_Utility_PVT.resource_locked THEN
496: x_return_status := FND_API.g_ret_sts_error;
497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
498: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
499: FND_MSG_PUB.add;
500: END IF;
501:
495: WHEN AMS_Utility_PVT.resource_locked THEN
496: x_return_status := FND_API.g_ret_sts_error;
497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
498: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
499: FND_MSG_PUB.add;
500: END IF;
501:
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO Delete_Lift_PUB;
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO Delete_Lift_PUB;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: -- Standard call to get message count and if count=1, get the message
506: FND_MSG_PUB.Count_And_Get (
507: p_encoded => FND_API.G_FALSE,
508: p_count => x_msg_count,
509: p_data => x_msg_data
510: );
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO Delete_Lift_PUB;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );
521:
522: WHEN OTHERS THEN
523: ROLLBACK TO Delete_Lift_PUB;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
523: ROLLBACK TO Delete_Lift_PUB;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
530: FND_MSG_PUB.Count_And_Get (
531: p_encoded => FND_API.G_FALSE,
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
530: FND_MSG_PUB.Count_And_Get (
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => x_msg_data
534: );
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: WHEN OTHERS THEN
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
658: END IF;
659: END;
660:
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: WHEN OTHERS THEN
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
658: END IF;
659: END;
660:
661: