89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )
92: THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Initialize API return status to SUCCESS
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
179: END IF;
180: x_ref_key := l_seq_id;
181:
182: -- Standard callto get message count and if count is 1, get message info.
183: FND_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count,
185: p_data => x_msg_data
186: );
187:
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO create_item_tag_PVT;
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: FND_MSG_PUB.Count_And_Get
194:
195: ( p_count => x_msg_count,
196: p_data => x_msg_data
197: );
198:
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: ROLLBACK TO create_item_tag_PVT;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
202: FND_MSG_PUB.Count_And_Get
203: ( p_count => x_msg_count,
204: p_data => x_msg_data
205: );
206:
206:
207: WHEN OTHERS THEN
208: ROLLBACK TO create_item_tag_PVT;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: IF FND_MSG_PUB.Check_Msg_Level
211: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
212: THEN
213: FND_MSG_PUB.Add_Exc_Msg
214: ( G_PKG_NAME ,
207: WHEN OTHERS THEN
208: ROLLBACK TO create_item_tag_PVT;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: IF FND_MSG_PUB.Check_Msg_Level
211: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
212: THEN
213: FND_MSG_PUB.Add_Exc_Msg
214: ( G_PKG_NAME ,
215: l_api_name
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: IF FND_MSG_PUB.Check_Msg_Level
211: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
212: THEN
213: FND_MSG_PUB.Add_Exc_Msg
214: ( G_PKG_NAME ,
215: l_api_name
216: );
217: END IF;
215: l_api_name
216: );
217: END IF;
218:
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count,
221: p_data => x_msg_data
222:
223: );
270:
271: -- Initialize message list if p_init_msg_list is set to TRUE.
272: IF FND_API.to_Boolean( p_init_msg_list )
273: THEN
274: FND_MSG_PUB.initialize;
275: END IF;
276:
277: -- Initialize API return status to SUCCESS
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
319: COMMIT WORK;
320: END IF;
321:
322: -- Standard callto get message count and if count is 1, get message info.
323: FND_MSG_PUB.Count_And_Get
324: ( p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327:
329:
330: WHEN FND_API.G_EXC_ERROR THEN
331: ROLLBACK TO create_sender_recipient_PVT;
332: x_return_status := FND_API.G_RET_STS_ERROR ;
333: FND_MSG_PUB.Count_And_Get
334:
335: ( p_count => x_msg_count,
336: p_data => x_msg_data
337: );
338:
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ROLLBACK TO create_sender_recipient_PVT;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346:
346:
347: WHEN OTHERS THEN
348: ROLLBACK TO create_sender_recipient_PVT;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level
351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: FND_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME ,
347: WHEN OTHERS THEN
348: ROLLBACK TO create_sender_recipient_PVT;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level
351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: FND_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME ,
355: l_api_name
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level
351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: FND_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME ,
355: l_api_name
356: );
357: END IF;
355: l_api_name
356: );
357: END IF;
358:
359: FND_MSG_PUB.Count_And_Get
360: ( p_count => x_msg_count,
361: p_data => x_msg_data
362:
363: );
406:
407: -- Initialize message list if p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean( p_init_msg_list )
409: THEN
410: FND_MSG_PUB.initialize;
411: END IF;
412:
413: -- Initialize API return status to SUCCESS
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
451: COMMIT WORK;
452: END IF;
453:
454: -- Standard callto get message count and if count is 1, get message info.
455: FND_MSG_PUB.Count_And_Get
456: ( p_count => x_msg_count,
457: p_data => x_msg_data
458: );
459:
461:
462: WHEN FND_API.G_EXC_ERROR THEN
463: ROLLBACK TO create_sender_recipient_PVT;
464: x_return_status := FND_API.G_RET_STS_ERROR ;
465: FND_MSG_PUB.Count_And_Get
466:
467: ( p_count => x_msg_count,
468: p_data => x_msg_data
469: );
470:
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472: ROLLBACK TO create_sender_recipient_PVT;
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
474: FND_MSG_PUB.Count_And_Get
475: ( p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478:
478:
479: WHEN OTHERS THEN
480: ROLLBACK TO create_sender_recipient_PVT;
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: IF FND_MSG_PUB.Check_Msg_Level
483: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME ,
479: WHEN OTHERS THEN
480: ROLLBACK TO create_sender_recipient_PVT;
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: IF FND_MSG_PUB.Check_Msg_Level
483: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME ,
487: l_api_name
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: IF FND_MSG_PUB.Check_Msg_Level
483: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME ,
487: l_api_name
488: );
489: END IF;
487: l_api_name
488: );
489: END IF;
490:
491: FND_MSG_PUB.Count_And_Get
492: ( p_count => x_msg_count,
493: p_data => x_msg_data
494:
495: );
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.
536: IF FND_API.to_Boolean( p_init_msg_list )
537: THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: -- Initialize API return status to SUCCESS
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
564: COMMIT WORK;
565: END IF;
566:
567: -- Standard callto get message count and if count is 1, get message info.
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,
570: p_data => x_msg_data
571: );
572:
574:
575: WHEN FND_API.G_EXC_ERROR THEN
576: ROLLBACK TO insert_preproc_wrapper_PVT;
577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: FND_MSG_PUB.Count_And_Get
579:
580: ( p_count => x_msg_count,
581: p_data => x_msg_data
582: );
583:
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585: ROLLBACK TO insert_preproc_wrapper_PVT;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587: FND_MSG_PUB.Count_And_Get
588: ( p_count => x_msg_count,
589: p_data => x_msg_data
590: );
591:
591:
592: WHEN OTHERS THEN
593: ROLLBACK TO insert_preproc_wrapper_PVT;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: IF FND_MSG_PUB.Check_Msg_Level
596: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg
599: ( G_PKG_NAME ,
592: WHEN OTHERS THEN
593: ROLLBACK TO insert_preproc_wrapper_PVT;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: IF FND_MSG_PUB.Check_Msg_Level
596: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg
599: ( G_PKG_NAME ,
600: l_api_name
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: IF FND_MSG_PUB.Check_Msg_Level
596: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg
599: ( G_PKG_NAME ,
600: l_api_name
601: );
602: END IF;
600: l_api_name
601: );
602: END IF;
603:
604: FND_MSG_PUB.Count_And_Get
605: ( p_count => x_msg_count,
606: p_data => x_msg_data
607:
608: );
651:
652: -- Initialize message list if p_init_msg_list is set to TRUE.
653: IF FND_API.to_Boolean( p_init_msg_list )
654: THEN
655: FND_MSG_PUB.initialize;
656: END IF;
657:
658: -- Initialize API return status to SUCCESS
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
683: COMMIT WORK;
684: END IF;
685:
686: -- Standard callto get message count and if count is 1, get message info.
687: FND_MSG_PUB.Count_And_Get
688: ( p_count => x_msg_count,
689: p_data => x_msg_data
690: );
691:
693:
694: WHEN FND_API.G_EXC_ERROR THEN
695: ROLLBACK TO insert_preproc_wrapper_PVT;
696: x_return_status := FND_API.G_RET_STS_ERROR ;
697: FND_MSG_PUB.Count_And_Get
698:
699: ( p_count => x_msg_count,
700: p_data => x_msg_data
701: );
702:
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: ROLLBACK TO insert_preproc_wrapper_PVT;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
706: FND_MSG_PUB.Count_And_Get
707: ( p_count => x_msg_count,
708: p_data => x_msg_data
709: );
710:
710:
711: WHEN OTHERS THEN
712: ROLLBACK TO insert_preproc_wrapper_PVT;
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: IF FND_MSG_PUB.Check_Msg_Level
715: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
716: THEN
717: FND_MSG_PUB.Add_Exc_Msg
718: ( G_PKG_NAME ,
711: WHEN OTHERS THEN
712: ROLLBACK TO insert_preproc_wrapper_PVT;
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: IF FND_MSG_PUB.Check_Msg_Level
715: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
716: THEN
717: FND_MSG_PUB.Add_Exc_Msg
718: ( G_PKG_NAME ,
719: l_api_name
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: IF FND_MSG_PUB.Check_Msg_Level
715: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
716: THEN
717: FND_MSG_PUB.Add_Exc_Msg
718: ( G_PKG_NAME ,
719: l_api_name
720: );
721: END IF;
719: l_api_name
720: );
721: END IF;
722:
723: FND_MSG_PUB.Count_And_Get
724: ( p_count => x_msg_count,
725: p_data => x_msg_data
726:
727: );