58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )
61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: -- Debug Message
66: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
172: -- Debug Message
173: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
174:
175: -- Standard call to get message count and if count is 1, get message info.
176: FND_MSG_PUB.Count_And_Get
177: (p_count => x_msg_count,
178: p_data => x_msg_data
179: );
180:
181: EXCEPTION
182:
183: WHEN AMS_Utility_PVT.resource_locked THEN
184: x_return_status := FND_API.g_ret_sts_error;
185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
186: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
187: FND_MSG_PUB.add;
188: END IF;
189:
183: WHEN AMS_Utility_PVT.resource_locked THEN
184: x_return_status := FND_API.g_ret_sts_error;
185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
186: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
187: FND_MSG_PUB.add;
188: END IF;
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO CREATE_DelivKitItem_PUB;
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO CREATE_DelivKitItem_PUB;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: -- Standard call to get message count and if count=1, get the message
194: FND_MSG_PUB.Count_And_Get (
195: p_encoded => FND_API.G_FALSE,
196: p_count => x_msg_count,
197: p_data => x_msg_data
198: );
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO CREATE_DelivKitItem_PUB;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );
209:
210: WHEN OTHERS THEN
211: ROLLBACK TO CREATE_DelivKitItem_PUB;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
214: THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
216: END IF;
217: -- Standard call to get message count and if count=1, get the message
211: ROLLBACK TO CREATE_DelivKitItem_PUB;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
214: THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
216: END IF;
217: -- Standard call to get message count and if count=1, get the message
218: FND_MSG_PUB.Count_And_Get (
219: p_encoded => FND_API.G_FALSE,
214: THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
216: END IF;
217: -- Standard call to get message count and if count=1, get the message
218: FND_MSG_PUB.Count_And_Get (
219: p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data
222: );
258:
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF FND_API.to_Boolean( p_init_msg_list )
261: THEN
262: FND_MSG_PUB.initialize;
263: END IF;
264:
265: -- Debug Message
266: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
360: -- Debug Message
361: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
362:
363: -- Standard call to get message count and if count is 1, get message info.
364: FND_MSG_PUB.Count_And_Get
365: (p_count => x_msg_count,
366: p_data => x_msg_data
367: );
368: EXCEPTION
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO UPDATE_DelivKitItem_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_DelivKitItem_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_DelivKitItem_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_DelivKitItem_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: );
446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.
448: IF FND_API.to_Boolean( p_init_msg_list )
449: THEN
450: FND_MSG_PUB.initialize;
451: END IF;
452:
453: -- Debug Message
454: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
559: -- Debug Message
560: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
561:
562: -- Standard call to get message count and if count is 1, get message info.
563: FND_MSG_PUB.Count_And_Get
564: (p_count => x_msg_count,
565: p_data => x_msg_data
566: );
567: EXCEPTION
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO DELETE_DelivKitItem_PUB;
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,
580: p_data => x_msg_data
581: );
583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
584: ROLLBACK TO DELETE_DelivKitItem_PUB;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: -- Standard call to get message count and if count=1, get the message
587: FND_MSG_PUB.Count_And_Get (
588: p_encoded => FND_API.G_FALSE,
589: p_count => x_msg_count,
590: p_data => x_msg_data
591: );
592:
593: WHEN OTHERS THEN
594: ROLLBACK TO DELETE_DelivKitItem_PUB;
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
594: ROLLBACK TO DELETE_DelivKitItem_PUB;
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,
603: p_count => x_msg_count,
604: p_data => x_msg_data
605: );
632:
633: -- initialize the message list;
634: -- won't do it again when calling private API
635: IF FND_API.to_boolean(p_init_msg_list) THEN
636: FND_MSG_PUB.initialize;
637: END IF;
638:
639: -- customer pre-processing
640: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
722: -- Debug Message
723: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
724:
725: -- Standard call to get message count and if count is 1, get message info.
726: FND_MSG_PUB.Count_And_Get
727: (p_count => x_msg_count,
728: p_data => x_msg_data
729: );
730:
732:
733: WHEN FND_API.g_exc_error THEN
734: ROLLBACK TO validate_DelivKitItem_pub;
735: x_return_status := FND_API.g_ret_sts_error;
736: FND_MSG_PUB.count_and_get(
737: p_encoded => FND_API.g_false,
738: p_count => x_msg_count,
739: p_data => x_msg_data
740: );
741:
742: WHEN FND_API.g_exc_unexpected_error THEN
743: ROLLBACK TO validate_DelivKitItem_pub;
744: x_return_status := FND_API.g_ret_sts_unexp_error ;
745: FND_MSG_PUB.count_and_get(
746: p_encoded => FND_API.g_false,
747: p_count => x_msg_count,
748: p_data => x_msg_data
749: );
752: WHEN OTHERS THEN
753: ROLLBACK TO validate_DelivKitItem_pub;
754: x_return_status := FND_API.g_ret_sts_unexp_error ;
755:
756: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
757: THEN
758: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
759: END IF;
760:
754: x_return_status := FND_API.g_ret_sts_unexp_error ;
755:
756: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
757: THEN
758: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
759: END IF;
760:
761: FND_MSG_PUB.count_and_get(
762: p_encoded => FND_API.g_false,
757: THEN
758: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
759: END IF;
760:
761: FND_MSG_PUB.count_and_get(
762: p_encoded => FND_API.g_false,
763: p_count => x_msg_count,
764: p_data => x_msg_data
765: );
801:
802: -- Initialize message list if p_init_msg_list is set to TRUE.
803: IF FND_API.to_Boolean( p_init_msg_list )
804: THEN
805: FND_MSG_PUB.initialize;
806: END IF;
807:
808: -- Debug Message
809: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
913: WHEN FND_API.G_EXC_ERROR THEN
914: ROLLBACK TO LOCK_DelivKitItem_PUB;
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: -- Standard call to get message count and if count=1, get the message
917: FND_MSG_PUB.Count_And_Get (
918: p_encoded => FND_API.G_FALSE,
919: p_count => x_msg_count,
920: p_data => x_msg_data
921: );
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: ROLLBACK TO LOCK_DelivKitItem_PUB;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: -- Standard call to get message count and if count=1, get the message
927: FND_MSG_PUB.Count_And_Get (
928: p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count,
930: p_data => x_msg_data
931: );
932:
933: WHEN OTHERS THEN
934: ROLLBACK TO LOCK_DelivKitItem_PUB;
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
937: THEN
938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
939: END IF;
940: -- Standard call to get message count and if count=1, get the message
934: ROLLBACK TO LOCK_DelivKitItem_PUB;
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
937: THEN
938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
939: END IF;
940: -- Standard call to get message count and if count=1, get the message
941: FND_MSG_PUB.Count_And_Get (
942: p_encoded => FND_API.G_FALSE,
937: THEN
938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
939: END IF;
940: -- Standard call to get message count and if count=1, get the message
941: FND_MSG_PUB.Count_And_Get (
942: p_encoded => FND_API.G_FALSE,
943: p_count => x_msg_count,
944: p_data => x_msg_data
945: );