247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: -- Get message count and data
250:
251: OE_MSG_PUB.Count_And_Get
252: ( p_count => x_msg_count
253: , p_data => x_msg_data
254: );
255:
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259:
260: -- Get message count and data
261:
262: OE_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count
264: , p_data => x_msg_data
265: );
266:
267: WHEN OTHERS THEN
268:
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: OE_MSG_PUB.Add_Exc_Msg
274: ( G_PKG_NAME
275: , 'Process_Attr_Mapping'
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: OE_MSG_PUB.Add_Exc_Msg
274: ( G_PKG_NAME
275: , 'Process_Attr_Mapping'
276: );
277: END IF;
277: END IF;
278:
279: -- Get message count and data
280:
281: OE_MSG_PUB.Count_And_Get
282: ( p_count => x_msg_count
283: , p_data => x_msg_data
284: );
285:
570: x_return_status := FND_API.G_RET_STS_ERROR;
571:
572: -- Get message count and data
573:
574: OE_MSG_PUB.Count_And_Get
575: ( p_count => x_msg_count
576: , p_data => x_msg_data
577: );
578:
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
582:
583: -- Get message count and data
584:
585: OE_MSG_PUB.Count_And_Get
586: ( p_count => x_msg_count
587: , p_data => x_msg_data
588: );
589:
590: WHEN OTHERS THEN
591:
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
593:
594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
595: THEN
596: OE_MSG_PUB.Add_Exc_Msg
597: ( G_PKG_NAME
598: , 'Lock_Attr_Mapping'
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
593:
594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
595: THEN
596: OE_MSG_PUB.Add_Exc_Msg
597: ( G_PKG_NAME
598: , 'Lock_Attr_Mapping'
599: );
600: END IF;
600: END IF;
601:
602: -- Get message count and data
603:
604: OE_MSG_PUB.Count_And_Get
605: ( p_count => x_msg_count
606: , p_data => x_msg_data
607: );
608:
777: ELSIF p_lookup_code <> FND_API.G_MISS_CHAR THEN
778:
779: l_lookup_code := p_lookup_code;
780:
781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
782: THEN
783:
784: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
785: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');
782: THEN
783:
784: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
785: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');
786: OE_MSG_PUB.Add;
787:
788: END IF;
789:
790: ELSE
795: ( p_lookup => p_lookup
796: );
797:
798: IF l_lookup_code = FND_API.G_MISS_CHAR THEN
799: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801:
802: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
803: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');
800: THEN
801:
802: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
803: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');
804: OE_MSG_PUB.Add;
805:
806: END IF;
807: END IF;
808:
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
864:
865: -- Get message count and data
866:
867: OE_MSG_PUB.Count_And_Get
868: ( p_count => x_msg_count
869: , p_data => x_msg_data
870: );
871:
877: x_return_status := FND_API.G_RET_STS_ERROR;
878:
879: -- Get message count and data
880:
881: OE_MSG_PUB.Count_And_Get
882: ( p_count => x_msg_count
883: , p_data => x_msg_data
884: );
885:
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
889:
890: -- Get message count and data
891:
892: OE_MSG_PUB.Count_And_Get
893: ( p_count => x_msg_count
894: , p_data => x_msg_data
895: );
896:
897: WHEN OTHERS THEN
898:
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
900:
901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
902: THEN
903: OE_MSG_PUB.Add_Exc_Msg
904: ( G_PKG_NAME
905: , 'Get_Attr_Mapping'
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
900:
901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
902: THEN
903: OE_MSG_PUB.Add_Exc_Msg
904: ( G_PKG_NAME
905: , 'Get_Attr_Mapping'
906: );
907: END IF;
907: END IF;
908:
909: -- Get message count and data
910:
911: OE_MSG_PUB.Count_And_Get
912: ( p_count => x_msg_count
913: , p_data => x_msg_data
914: );
915:
1042: EXCEPTION
1043:
1044: WHEN OTHERS THEN
1045:
1046: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1047: THEN
1048: OE_MSG_PUB.Add_Exc_Msg
1049: ( G_PKG_NAME
1050: , 'Id_To_Value'
1044: WHEN OTHERS THEN
1045:
1046: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1047: THEN
1048: OE_MSG_PUB.Add_Exc_Msg
1049: ( G_PKG_NAME
1050: , 'Id_To_Value'
1051: );
1052: END IF;
1223: EXCEPTION
1224:
1225: WHEN OTHERS THEN
1226:
1227: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1228: THEN
1229: OE_MSG_PUB.Add_Exc_Msg
1230: ( G_PKG_NAME
1231: , 'Value_To_Id'
1225: WHEN OTHERS THEN
1226:
1227: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1228: THEN
1229: OE_MSG_PUB.Add_Exc_Msg
1230: ( G_PKG_NAME
1231: , 'Value_To_Id'
1232: );
1233: END IF;