152: x_return_status := FND_API.G_RET_STS_ERROR;
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:
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
165:
166: -- Get message count and data
167:
168: FND_MSG_PUB.Count_And_Get
169: ( p_count => x_msg_count
170: , p_data => x_msg_data
171: );
172:
174:
175:
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177:
178: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
179: THEN
180: FND_MSG_PUB.Add_Exc_Msg
181: ( G_PKG_NAME
182: , 'Process_Assignment'
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177:
178: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
179: THEN
180: FND_MSG_PUB.Add_Exc_Msg
181: ( G_PKG_NAME
182: , 'Process_Assignment'
183: );
184: END IF;
184: END IF;
185:
186: -- Get message count and data
187:
188: FND_MSG_PUB.Count_And_Get
189: ( p_count => x_msg_count
190: , p_data => x_msg_data
191: );
192:
312: x_return_status := FND_API.G_RET_STS_ERROR;
313:
314: -- Get message count and data
315:
316: FND_MSG_PUB.Count_And_Get
317: ( p_count => x_msg_count
318: , p_data => x_msg_data
319: );
320:
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325:
326: -- Get message count and data
327:
328: FND_MSG_PUB.Count_And_Get
329: ( p_count => x_msg_count
330: , p_data => x_msg_data
331: );
332:
334:
335:
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337:
338: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
339: THEN
340: FND_MSG_PUB.Add_Exc_Msg
341: ( G_PKG_NAME
342: , 'Lock_Assignment'
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337:
338: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
339: THEN
340: FND_MSG_PUB.Add_Exc_Msg
341: ( G_PKG_NAME
342: , 'Lock_Assignment'
343: );
344: END IF;
344: END IF;
345:
346: -- Get message count and data
347:
348: FND_MSG_PUB.Count_And_Get
349: ( p_count => x_msg_count
350: , p_data => x_msg_data
351: );
352:
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Get message count and data
466:
467: FND_MSG_PUB.Count_And_Get
468: ( p_count => x_msg_count
469: , p_data => x_msg_data
470: );
471:
478: x_return_status := FND_API.G_RET_STS_ERROR;
479:
480: -- Get message count and data
481:
482: FND_MSG_PUB.Count_And_Get
483: ( p_count => x_msg_count
484: , p_data => x_msg_data
485: );
486:
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491:
492: -- Get message count and data
493:
494: FND_MSG_PUB.Count_And_Get
495: ( p_count => x_msg_count
496: , p_data => x_msg_data
497: );
498:
500:
501:
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
503:
504: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
505: THEN
506: FND_MSG_PUB.Add_Exc_Msg
507: ( G_PKG_NAME
508: , 'Get_Assignment'
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
503:
504: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
505: THEN
506: FND_MSG_PUB.Add_Exc_Msg
507: ( G_PKG_NAME
508: , 'Get_Assignment'
509: );
510: END IF;
510: END IF;
511:
512: -- Get message count and data
513:
514: FND_MSG_PUB.Count_And_Get
515: ( p_count => x_msg_count
516: , p_data => x_msg_data
517: );
518:
545:
546: WHEN OTHERS THEN
547:
548:
549: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
550: THEN
551: FND_MSG_PUB.Add_Exc_Msg
552: ( G_PKG_NAME
553: , 'Id_To_Value'
547:
548:
549: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
550: THEN
551: FND_MSG_PUB.Add_Exc_Msg
552: ( G_PKG_NAME
553: , 'Id_To_Value'
554: );
555: END IF;
620:
621: WHEN OTHERS THEN
622:
623:
624: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
625: THEN
626: FND_MSG_PUB.Add_Exc_Msg
627: ( G_PKG_NAME
628: , 'Value_To_Id'
622:
623:
624: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
625: THEN
626: FND_MSG_PUB.Add_Exc_Msg
627: ( G_PKG_NAME
628: , 'Value_To_Id'
629: );
630: END IF;