72: EXCEPTION
73:
74: WHEN NO_DATA_FOUND THEN
75:
76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
77: THEN
78:
79: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
80: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','completion_locator');
77: THEN
78:
79: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
80: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','completion_locator');
81: FND_MSG_PUB.Add;
82:
83: END IF;
84:
85: RETURN NULL;
85: RETURN NULL;
86:
87: WHEN OTHERS THEN
88:
89: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
90: THEN
91: FND_MSG_PUB.Add_Exc_Msg
92: ( G_PKG_NAME
93: , 'Completion_Locator'
87: WHEN OTHERS THEN
88:
89: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
90: THEN
91: FND_MSG_PUB.Add_Exc_Msg
92: ( G_PKG_NAME
93: , 'Completion_Locator'
94: );
95: END IF;
119: EXCEPTION
120:
121: WHEN NO_DATA_FOUND THEN
122:
123: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
124: THEN
125:
126: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');
124: THEN
125:
126: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');
128: FND_MSG_PUB.Add;
129:
130: END IF;
131:
132: RETURN NULL;
132: RETURN NULL;
133:
134: WHEN OTHERS THEN
135:
136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
137: THEN
138: FND_MSG_PUB.Add_Exc_Msg
139: ( G_PKG_NAME
140: , 'Line'
134: WHEN OTHERS THEN
135:
136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
137: THEN
138: FND_MSG_PUB.Add_Exc_Msg
139: ( G_PKG_NAME
140: , 'Line'
141: );
142: END IF;
166: EXCEPTION
167:
168: WHEN NO_DATA_FOUND THEN
169:
170: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
171: THEN
172:
173: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
171: THEN
172:
173: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
175: FND_MSG_PUB.Add;
176:
177: END IF;
178:
179: RETURN NULL;
179: RETURN NULL;
180:
181: WHEN OTHERS THEN
182:
183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
184: THEN
185: FND_MSG_PUB.Add_Exc_Msg
186: ( G_PKG_NAME
187: , 'Organization'
181: WHEN OTHERS THEN
182:
183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
184: THEN
185: FND_MSG_PUB.Add_Exc_Msg
186: ( G_PKG_NAME
187: , 'Organization'
188: );
189: END IF;
215: EXCEPTION
216:
217: WHEN NO_DATA_FOUND THEN
218:
219: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
220: THEN
221:
222: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_item');
220: THEN
221:
222: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_item');
224: FND_MSG_PUB.Add;
225:
226: END IF;
227:
228: RETURN NULL;
228: RETURN NULL;
229:
230: WHEN OTHERS THEN
231:
232: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg
235: ( G_PKG_NAME
236: , 'Primary_Item'
230: WHEN OTHERS THEN
231:
232: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg
235: ( G_PKG_NAME
236: , 'Primary_Item'
237: );
238: END IF;
262: EXCEPTION
263:
264: WHEN NO_DATA_FOUND THEN
265:
266: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
267: THEN
268:
269: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
267: THEN
268:
269: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
271: FND_MSG_PUB.Add;
272:
273: END IF;
274:
275: RETURN NULL;
275: RETURN NULL;
276:
277: WHEN OTHERS THEN
278:
279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg
282: ( G_PKG_NAME
283: , 'Project'
277: WHEN OTHERS THEN
278:
279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg
282: ( G_PKG_NAME
283: , 'Project'
284: );
285: END IF;
311: EXCEPTION
312:
313: WHEN NO_DATA_FOUND THEN
314:
315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
316: THEN
317:
318: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
319: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','schedule_group');
316: THEN
317:
318: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
319: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','schedule_group');
320: FND_MSG_PUB.Add;
321:
322: END IF;
323:
324: RETURN NULL;
324: RETURN NULL;
325:
326: WHEN OTHERS THEN
327:
328: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
329: THEN
330: FND_MSG_PUB.Add_Exc_Msg
331: ( G_PKG_NAME
332: , 'Schedule_Group'
326: WHEN OTHERS THEN
327:
328: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
329: THEN
330: FND_MSG_PUB.Add_Exc_Msg
331: ( G_PKG_NAME
332: , 'Schedule_Group'
333: );
334: END IF;
360: EXCEPTION
361:
362: WHEN NO_DATA_FOUND THEN
363:
364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
365: THEN
366:
367: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
368: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
365: THEN
366:
367: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
368: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
369: FND_MSG_PUB.Add;
370:
371: END IF;
372:
373: RETURN NULL;
373: RETURN NULL;
374:
375: WHEN OTHERS THEN
376:
377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
378: THEN
379: FND_MSG_PUB.Add_Exc_Msg
380: ( G_PKG_NAME
381: , 'Task'
375: WHEN OTHERS THEN
376:
377: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
378: THEN
379: FND_MSG_PUB.Add_Exc_Msg
380: ( G_PKG_NAME
381: , 'Task'
382: );
383: END IF;
409: EXCEPTION
410:
411: WHEN NO_DATA_FOUND THEN
412:
413: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
414: THEN
415:
416: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
417: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
414: THEN
415:
416: FND_MESSAGE.SET_NAME('MRP','MRP_ID_TO_VALUE_ERROR');
417: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
418: FND_MSG_PUB.Add;
419:
420: END IF;
421:
422: RETURN NULL;
422: RETURN NULL;
423:
424: WHEN OTHERS THEN
425:
426: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg
429: ( G_PKG_NAME
430: , 'Wip_Entity'
424: WHEN OTHERS THEN
425:
426: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg
429: ( G_PKG_NAME
430: , 'Wip_Entity'
431: );
432: END IF;