69: l_wip_entity_id := p_wip_entity_id;
70:
71: ELSE
72:
73: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
74: THEN
75: FND_MESSAGE.SET_NAME('WIP','Invalid Business Object Value');
76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
77: FND_MSG_PUB.Add;
73: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
74: THEN
75: FND_MESSAGE.SET_NAME('WIP','Invalid Business Object Value');
76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
77: FND_MSG_PUB.Add;
78: END IF;
79:
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: -- Get message count and data
111:
112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count
114: , p_data => x_msg_data
115: );
116:
122: x_return_status := FND_API.G_RET_STS_ERROR;
123:
124: -- Get message count and data
125:
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count
128: , p_data => x_msg_data
129: );
130:
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
134:
135: -- Get message count and data
136:
137: FND_MSG_PUB.Count_And_Get
138: ( p_count => x_msg_count
139: , p_data => x_msg_data
140: );
141:
142: WHEN OTHERS THEN
143:
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
145:
146: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
147: THEN
148: FND_MSG_PUB.Add_Exc_Msg
149: ( G_PKG_NAME
150: , 'Get_Work_Order'
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
145:
146: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
147: THEN
148: FND_MSG_PUB.Add_Exc_Msg
149: ( G_PKG_NAME
150: , 'Get_Work_Order'
151: );
152: END IF;
152: END IF;
153:
154: -- Get message count and data
155:
156: FND_MSG_PUB.Count_And_Get
157: ( p_count => x_msg_count
158: , p_data => x_msg_data
159: );
160: