296: x_return_status := FND_API.G_RET_STS_SUCCESS;
297:
298: *//* Get message count and data *//*
299:
300: FND_MSG_PUB.Count_And_Get
301: ( p_count => x_msg_count
302: , p_data => x_msg_data
303: );
304:
310: x_return_status := FND_API.G_RET_STS_ERROR;
311:
312: *//* Get message count and data *//*
313:
314: FND_MSG_PUB.Count_And_Get
315: ( p_count => x_msg_count
316: , p_data => x_msg_data
317: );
318:
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322:
323: *//* Get message count and data *//*
324:
325: FND_MSG_PUB.Count_And_Get
326: ( p_count => x_msg_count
327: , p_data => x_msg_data
328: );
329:
330: WHEN OTHERS THEN
331:
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333:
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg
337: ( G_PKG_NAME
338: , 'Default_Attributes'
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333:
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.Add_Exc_Msg
337: ( G_PKG_NAME
338: , 'Default_Attributes'
339: );
340: END IF;
340: END IF;
341:
342: *//* Get message count and data *//*
343:
344: FND_MSG_PUB.Count_And_Get
345: ( p_count => x_msg_count
346: , p_data => x_msg_data
347: );
348:
565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566:
567: *//* Get message count and data *//*
568:
569: FND_MSG_PUB.Count_And_Get
570: ( p_count => x_msg_count
571: , p_data => x_msg_data
572: );
573:
579: x_return_status := FND_API.G_RET_STS_ERROR;
580:
581: *//* Get message count and data *//*
582:
583: FND_MSG_PUB.Count_And_Get
584: ( p_count => x_msg_count
585: , p_data => x_msg_data
586: );
587:
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
591:
592: *//* Get message count and data *//*
593:
594: FND_MSG_PUB.Count_And_Get
595: ( p_count => x_msg_count
596: , p_data => x_msg_data
597: );
598:
599: WHEN OTHERS THEN
600:
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
602:
603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: FND_MSG_PUB.Add_Exc_Msg
606: ( G_PKG_NAME
607: , 'Change_Attribute'
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
602:
603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: FND_MSG_PUB.Add_Exc_Msg
606: ( G_PKG_NAME
607: , 'Change_Attribute'
608: );
609: END IF;
609: END IF;
610:
611: *//* Get message count and data *//*
612:
613: FND_MSG_PUB.Count_And_Get
614: ( p_count => x_msg_count
615: , p_data => x_msg_data
616: );
617:
650: x_return_status := FND_API.G_RET_STS_SUCCESS;
651:
652: /* Get message count and data */
653:
654: FND_MSG_PUB.Count_And_Get
655: ( p_count => x_msg_count
656: , p_data => x_msg_data
657: );
658:
664: x_return_status := FND_API.G_RET_STS_ERROR;
665:
666: /* Get message count and data */
667:
668: FND_MSG_PUB.Count_And_Get
669: ( p_count => x_msg_count
670: , p_data => x_msg_data
671: );
672:
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
676:
677: /* Get message count and data */
678:
679: FND_MSG_PUB.Count_And_Get
680: ( p_count => x_msg_count
681: , p_data => x_msg_data
682: );
683:
684: WHEN OTHERS THEN
685:
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
687:
688: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
689: THEN
690: FND_MSG_PUB.Add_Exc_Msg
691: ( G_PKG_NAME
692: , 'Validate_And_Write'
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
687:
688: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
689: THEN
690: FND_MSG_PUB.Add_Exc_Msg
691: ( G_PKG_NAME
692: , 'Validate_And_Write'
693: );
694: END IF;
694: END IF;
695:
696: /* Get message count and data */
697:
698: FND_MSG_PUB.Count_And_Get
699: ( p_count => x_msg_count
700: , p_data => x_msg_data
701: );
702:
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: *//* Get message count and data *//*
784:
785: FND_MSG_PUB.Count_And_Get
786: ( p_count => x_msg_count
787: , p_data => x_msg_data
788: );
789:
795: x_return_status := FND_API.G_RET_STS_ERROR;
796:
797: *//* Get message count and data *//*
798:
799: FND_MSG_PUB.Count_And_Get
800: ( p_count => x_msg_count
801: , p_data => x_msg_data
802: );
803:
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
807:
808: *//* Get message count and data *//*
809:
810: FND_MSG_PUB.Count_And_Get
811: ( p_count => x_msg_count
812: , p_data => x_msg_data
813: );
814:
815: WHEN OTHERS THEN
816:
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
818:
819: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg
822: ( G_PKG_NAME
823: , 'Delete_Row'
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
818:
819: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg
822: ( G_PKG_NAME
823: , 'Delete_Row'
824: );
825: END IF;
825: END IF;
826:
827: *//* Get message count and data *//*
828:
829: FND_MSG_PUB.Count_And_Get
830: ( p_count => x_msg_count
831: , p_data => x_msg_data
832: );
833:
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:
891: *//* Get message count and data *//*
892:
893: FND_MSG_PUB.Count_And_Get
894: ( p_count => x_msg_count
895: , p_data => x_msg_data
896: );
897:
903: x_return_status := FND_API.G_RET_STS_ERROR;
904:
905: *//* Get message count and data *//*
906:
907: FND_MSG_PUB.Count_And_Get
908: ( p_count => x_msg_count
909: , p_data => x_msg_data
910: );
911:
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
915:
916: *//* Get message count and data *//*
917:
918: FND_MSG_PUB.Count_And_Get
919: ( p_count => x_msg_count
920: , p_data => x_msg_data
921: );
922:
923: WHEN OTHERS THEN
924:
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
926:
927: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
928: THEN
929: FND_MSG_PUB.Add_Exc_Msg
930: ( G_PKG_NAME
931: , 'Process_Entity'
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
926:
927: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
928: THEN
929: FND_MSG_PUB.Add_Exc_Msg
930: ( G_PKG_NAME
931: , 'Process_Entity'
932: );
933: END IF;
933: END IF;
934:
935: *//* Get message count and data *//*
936:
937: FND_MSG_PUB.Count_And_Get
938: ( p_count => x_msg_count
939: , p_data => x_msg_data
940: );
941:
956: BEGIN
957:
958: IF (p_init_msg_list = 1)
959: THEN
960: FND_MSG_PUB.Initialize;
961: END IF;
962:
963: savepoint Lock_Row_SP;
964:
987: x_return_status := l_return_status;
988:
989: /* Get message count and data */
990:
991: FND_MSG_PUB.Count_And_Get
992: ( p_count => x_msg_count
993: , p_data => x_msg_data
994: );
995:
1002:
1003: WHEN OTHERS THEN
1004: ROLLBACK TO SAVEPOINT Lock_Row_SP;
1005:
1006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1007: THEN
1008: FND_MSG_PUB.Add_Exc_Msg
1009: ( G_PKG_NAME
1010: , 'Lock_Row'
1004: ROLLBACK TO SAVEPOINT Lock_Row_SP;
1005:
1006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1007: THEN
1008: FND_MSG_PUB.Add_Exc_Msg
1009: ( G_PKG_NAME
1010: , 'Lock_Row'
1011: );
1012: END IF;
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015:
1016: /* Get message count and data */
1017:
1018: FND_MSG_PUB.Count_And_Get
1019: ( p_count => x_msg_count
1020: , p_data => x_msg_data
1021: );
1022: