eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_ASSIGNMENT_SET_HANDLERS dependencies on FND_API

Line 60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

56: , 'Update_Row'
57: );
58: END IF;
59:
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
61:
62: END Update_Row;
63:
64: -- Procedure Insert_Row

Line 145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

141: , 'Insert_Row'
142: );
143: END IF;
144:
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146:
147: END Insert_Row;
148:
149: -- Procedure Delete_Row

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194: , 'Delete_Row'
195: );
196: END IF;
197:
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199:
200: END Delete_Row;
201:
202: -- Procedure lock_Row

Line 278: ((p_Assignment_Set_rec.Assignment_Set_Id = FND_API.G_MISS_NUM) OR

274: -- Row locked. Compare IN attributes to DB attributes.
275:
276: IF ( (l_Assignment_Set_rec.Assignment_Set_Id =
277: p_Assignment_Set_rec.Assignment_Set_Id) OR
278: ((p_Assignment_Set_rec.Assignment_Set_Id = FND_API.G_MISS_NUM) OR
279: ( (l_Assignment_Set_rec.Assignment_Set_Id IS NULL) AND
280: (p_Assignment_Set_rec.Assignment_Set_Id IS NULL))))
281: AND ( (l_Assignment_Set_rec.Assignment_Set_Name =
282: p_Assignment_Set_rec.Assignment_Set_Name) OR

Line 283: ((p_Assignment_Set_rec.Assignment_Set_Name = FND_API.G_MISS_CHAR) OR

279: ( (l_Assignment_Set_rec.Assignment_Set_Id IS NULL) AND
280: (p_Assignment_Set_rec.Assignment_Set_Id IS NULL))))
281: AND ( (l_Assignment_Set_rec.Assignment_Set_Name =
282: p_Assignment_Set_rec.Assignment_Set_Name) OR
283: ((p_Assignment_Set_rec.Assignment_Set_Name = FND_API.G_MISS_CHAR) OR
284: ( (l_Assignment_Set_rec.Assignment_Set_Name IS NULL) AND
285: (p_Assignment_Set_rec.Assignment_Set_Name IS NULL))))
286: AND ( (l_Assignment_Set_rec.Attribute1 =
287: p_Assignment_Set_rec.Attribute1) OR

Line 288: ((p_Assignment_Set_rec.Attribute1 = FND_API.G_MISS_CHAR) OR

284: ( (l_Assignment_Set_rec.Assignment_Set_Name IS NULL) AND
285: (p_Assignment_Set_rec.Assignment_Set_Name IS NULL))))
286: AND ( (l_Assignment_Set_rec.Attribute1 =
287: p_Assignment_Set_rec.Attribute1) OR
288: ((p_Assignment_Set_rec.Attribute1 = FND_API.G_MISS_CHAR) OR
289: ( (l_Assignment_Set_rec.Attribute1 IS NULL) AND
290: (p_Assignment_Set_rec.Attribute1 IS NULL))))
291: AND ( (l_Assignment_Set_rec.Attribute10 =
292: p_Assignment_Set_rec.Attribute10) OR

Line 293: ((p_Assignment_Set_rec.Attribute10 = FND_API.G_MISS_CHAR) OR

289: ( (l_Assignment_Set_rec.Attribute1 IS NULL) AND
290: (p_Assignment_Set_rec.Attribute1 IS NULL))))
291: AND ( (l_Assignment_Set_rec.Attribute10 =
292: p_Assignment_Set_rec.Attribute10) OR
293: ((p_Assignment_Set_rec.Attribute10 = FND_API.G_MISS_CHAR) OR
294: ( (l_Assignment_Set_rec.Attribute10 IS NULL) AND
295: (p_Assignment_Set_rec.Attribute10 IS NULL))))
296: AND ( (l_Assignment_Set_rec.Attribute11 =
297: p_Assignment_Set_rec.Attribute11) OR

Line 298: ((p_Assignment_Set_rec.Attribute11 = FND_API.G_MISS_CHAR) OR

294: ( (l_Assignment_Set_rec.Attribute10 IS NULL) AND
295: (p_Assignment_Set_rec.Attribute10 IS NULL))))
296: AND ( (l_Assignment_Set_rec.Attribute11 =
297: p_Assignment_Set_rec.Attribute11) OR
298: ((p_Assignment_Set_rec.Attribute11 = FND_API.G_MISS_CHAR) OR
299: ( (l_Assignment_Set_rec.Attribute11 IS NULL) AND
300: (p_Assignment_Set_rec.Attribute11 IS NULL))))
301: AND ( (l_Assignment_Set_rec.Attribute12 =
302: p_Assignment_Set_rec.Attribute12) OR

Line 303: ((p_Assignment_Set_rec.Attribute12 = FND_API.G_MISS_CHAR) OR

299: ( (l_Assignment_Set_rec.Attribute11 IS NULL) AND
300: (p_Assignment_Set_rec.Attribute11 IS NULL))))
301: AND ( (l_Assignment_Set_rec.Attribute12 =
302: p_Assignment_Set_rec.Attribute12) OR
303: ((p_Assignment_Set_rec.Attribute12 = FND_API.G_MISS_CHAR) OR
304: ( (l_Assignment_Set_rec.Attribute12 IS NULL) AND
305: (p_Assignment_Set_rec.Attribute12 IS NULL))))
306: AND ( (l_Assignment_Set_rec.Attribute13 =
307: p_Assignment_Set_rec.Attribute13) OR

Line 308: ((p_Assignment_Set_rec.Attribute13 = FND_API.G_MISS_CHAR) OR

304: ( (l_Assignment_Set_rec.Attribute12 IS NULL) AND
305: (p_Assignment_Set_rec.Attribute12 IS NULL))))
306: AND ( (l_Assignment_Set_rec.Attribute13 =
307: p_Assignment_Set_rec.Attribute13) OR
308: ((p_Assignment_Set_rec.Attribute13 = FND_API.G_MISS_CHAR) OR
309: ( (l_Assignment_Set_rec.Attribute13 IS NULL) AND
310: (p_Assignment_Set_rec.Attribute13 IS NULL))))
311: AND ( (l_Assignment_Set_rec.Attribute14 =
312: p_Assignment_Set_rec.Attribute14) OR

Line 313: ((p_Assignment_Set_rec.Attribute14 = FND_API.G_MISS_CHAR) OR

309: ( (l_Assignment_Set_rec.Attribute13 IS NULL) AND
310: (p_Assignment_Set_rec.Attribute13 IS NULL))))
311: AND ( (l_Assignment_Set_rec.Attribute14 =
312: p_Assignment_Set_rec.Attribute14) OR
313: ((p_Assignment_Set_rec.Attribute14 = FND_API.G_MISS_CHAR) OR
314: ( (l_Assignment_Set_rec.Attribute14 IS NULL) AND
315: (p_Assignment_Set_rec.Attribute14 IS NULL))))
316: AND ( (l_Assignment_Set_rec.Attribute15 =
317: p_Assignment_Set_rec.Attribute15) OR

Line 318: ((p_Assignment_Set_rec.Attribute15 = FND_API.G_MISS_CHAR) OR

314: ( (l_Assignment_Set_rec.Attribute14 IS NULL) AND
315: (p_Assignment_Set_rec.Attribute14 IS NULL))))
316: AND ( (l_Assignment_Set_rec.Attribute15 =
317: p_Assignment_Set_rec.Attribute15) OR
318: ((p_Assignment_Set_rec.Attribute15 = FND_API.G_MISS_CHAR) OR
319: ( (l_Assignment_Set_rec.Attribute15 IS NULL) AND
320: (p_Assignment_Set_rec.Attribute15 IS NULL))))
321: AND ( (l_Assignment_Set_rec.Attribute2 =
322: p_Assignment_Set_rec.Attribute2) OR

Line 323: ((p_Assignment_Set_rec.Attribute2 = FND_API.G_MISS_CHAR) OR

319: ( (l_Assignment_Set_rec.Attribute15 IS NULL) AND
320: (p_Assignment_Set_rec.Attribute15 IS NULL))))
321: AND ( (l_Assignment_Set_rec.Attribute2 =
322: p_Assignment_Set_rec.Attribute2) OR
323: ((p_Assignment_Set_rec.Attribute2 = FND_API.G_MISS_CHAR) OR
324: ( (l_Assignment_Set_rec.Attribute2 IS NULL) AND
325: (p_Assignment_Set_rec.Attribute2 IS NULL))))
326: AND ( (l_Assignment_Set_rec.Attribute3 =
327: p_Assignment_Set_rec.Attribute3) OR

Line 328: ((p_Assignment_Set_rec.Attribute3 = FND_API.G_MISS_CHAR) OR

324: ( (l_Assignment_Set_rec.Attribute2 IS NULL) AND
325: (p_Assignment_Set_rec.Attribute2 IS NULL))))
326: AND ( (l_Assignment_Set_rec.Attribute3 =
327: p_Assignment_Set_rec.Attribute3) OR
328: ((p_Assignment_Set_rec.Attribute3 = FND_API.G_MISS_CHAR) OR
329: ( (l_Assignment_Set_rec.Attribute3 IS NULL) AND
330: (p_Assignment_Set_rec.Attribute3 IS NULL))))
331: AND ( (l_Assignment_Set_rec.Attribute4 =
332: p_Assignment_Set_rec.Attribute4) OR

Line 333: ((p_Assignment_Set_rec.Attribute4 = FND_API.G_MISS_CHAR) OR

329: ( (l_Assignment_Set_rec.Attribute3 IS NULL) AND
330: (p_Assignment_Set_rec.Attribute3 IS NULL))))
331: AND ( (l_Assignment_Set_rec.Attribute4 =
332: p_Assignment_Set_rec.Attribute4) OR
333: ((p_Assignment_Set_rec.Attribute4 = FND_API.G_MISS_CHAR) OR
334: ( (l_Assignment_Set_rec.Attribute4 IS NULL) AND
335: (p_Assignment_Set_rec.Attribute4 IS NULL))))
336: AND ( (l_Assignment_Set_rec.Attribute5 =
337: p_Assignment_Set_rec.Attribute5) OR

Line 338: ((p_Assignment_Set_rec.Attribute5 = FND_API.G_MISS_CHAR) OR

334: ( (l_Assignment_Set_rec.Attribute4 IS NULL) AND
335: (p_Assignment_Set_rec.Attribute4 IS NULL))))
336: AND ( (l_Assignment_Set_rec.Attribute5 =
337: p_Assignment_Set_rec.Attribute5) OR
338: ((p_Assignment_Set_rec.Attribute5 = FND_API.G_MISS_CHAR) OR
339: ( (l_Assignment_Set_rec.Attribute5 IS NULL) AND
340: (p_Assignment_Set_rec.Attribute5 IS NULL))))
341: AND ( (l_Assignment_Set_rec.Attribute6 =
342: p_Assignment_Set_rec.Attribute6) OR

Line 343: ((p_Assignment_Set_rec.Attribute6 = FND_API.G_MISS_CHAR) OR

339: ( (l_Assignment_Set_rec.Attribute5 IS NULL) AND
340: (p_Assignment_Set_rec.Attribute5 IS NULL))))
341: AND ( (l_Assignment_Set_rec.Attribute6 =
342: p_Assignment_Set_rec.Attribute6) OR
343: ((p_Assignment_Set_rec.Attribute6 = FND_API.G_MISS_CHAR) OR
344: ( (l_Assignment_Set_rec.Attribute6 IS NULL) AND
345: (p_Assignment_Set_rec.Attribute6 IS NULL))))
346: AND ( (l_Assignment_Set_rec.Attribute7 =
347: p_Assignment_Set_rec.Attribute7) OR

Line 348: ((p_Assignment_Set_rec.Attribute7 = FND_API.G_MISS_CHAR) OR

344: ( (l_Assignment_Set_rec.Attribute6 IS NULL) AND
345: (p_Assignment_Set_rec.Attribute6 IS NULL))))
346: AND ( (l_Assignment_Set_rec.Attribute7 =
347: p_Assignment_Set_rec.Attribute7) OR
348: ((p_Assignment_Set_rec.Attribute7 = FND_API.G_MISS_CHAR) OR
349: ( (l_Assignment_Set_rec.Attribute7 IS NULL) AND
350: (p_Assignment_Set_rec.Attribute7 IS NULL))))
351: AND ( (l_Assignment_Set_rec.Attribute8 =
352: p_Assignment_Set_rec.Attribute8) OR

Line 353: ((p_Assignment_Set_rec.Attribute8 = FND_API.G_MISS_CHAR) OR

349: ( (l_Assignment_Set_rec.Attribute7 IS NULL) AND
350: (p_Assignment_Set_rec.Attribute7 IS NULL))))
351: AND ( (l_Assignment_Set_rec.Attribute8 =
352: p_Assignment_Set_rec.Attribute8) OR
353: ((p_Assignment_Set_rec.Attribute8 = FND_API.G_MISS_CHAR) OR
354: ( (l_Assignment_Set_rec.Attribute8 IS NULL) AND
355: (p_Assignment_Set_rec.Attribute8 IS NULL))))
356: AND ( (l_Assignment_Set_rec.Attribute9 =
357: p_Assignment_Set_rec.Attribute9) OR

Line 358: ((p_Assignment_Set_rec.Attribute9 = FND_API.G_MISS_CHAR) OR

354: ( (l_Assignment_Set_rec.Attribute8 IS NULL) AND
355: (p_Assignment_Set_rec.Attribute8 IS NULL))))
356: AND ( (l_Assignment_Set_rec.Attribute9 =
357: p_Assignment_Set_rec.Attribute9) OR
358: ((p_Assignment_Set_rec.Attribute9 = FND_API.G_MISS_CHAR) OR
359: ( (l_Assignment_Set_rec.Attribute9 IS NULL) AND
360: (p_Assignment_Set_rec.Attribute9 IS NULL))))
361: AND ( (l_Assignment_Set_rec.Attribute_Category =
362: p_Assignment_Set_rec.Attribute_Category) OR

Line 363: ((p_Assignment_Set_rec.Attribute_Category = FND_API.G_MISS_CHAR) OR

359: ( (l_Assignment_Set_rec.Attribute9 IS NULL) AND
360: (p_Assignment_Set_rec.Attribute9 IS NULL))))
361: AND ( (l_Assignment_Set_rec.Attribute_Category =
362: p_Assignment_Set_rec.Attribute_Category) OR
363: ((p_Assignment_Set_rec.Attribute_Category = FND_API.G_MISS_CHAR) OR
364: ( (l_Assignment_Set_rec.Attribute_Category IS NULL) AND
365: (p_Assignment_Set_rec.Attribute_Category IS NULL))))
366: AND ( (l_Assignment_Set_rec.Created_By =
367: p_Assignment_Set_rec.Created_By) OR

Line 368: ((p_Assignment_Set_rec.Created_By = FND_API.G_MISS_NUM) OR

364: ( (l_Assignment_Set_rec.Attribute_Category IS NULL) AND
365: (p_Assignment_Set_rec.Attribute_Category IS NULL))))
366: AND ( (l_Assignment_Set_rec.Created_By =
367: p_Assignment_Set_rec.Created_By) OR
368: ((p_Assignment_Set_rec.Created_By = FND_API.G_MISS_NUM) OR
369: ( (l_Assignment_Set_rec.Created_By IS NULL) AND
370: (p_Assignment_Set_rec.Created_By IS NULL))))
371: AND ( (l_Assignment_Set_rec.Creation_Date =
372: p_Assignment_Set_rec.Creation_Date) OR

Line 373: ((p_Assignment_Set_rec.Creation_Date = FND_API.G_MISS_DATE) OR

369: ( (l_Assignment_Set_rec.Created_By IS NULL) AND
370: (p_Assignment_Set_rec.Created_By IS NULL))))
371: AND ( (l_Assignment_Set_rec.Creation_Date =
372: p_Assignment_Set_rec.Creation_Date) OR
373: ((p_Assignment_Set_rec.Creation_Date = FND_API.G_MISS_DATE) OR
374: ( (l_Assignment_Set_rec.Creation_Date IS NULL) AND
375: (p_Assignment_Set_rec.Creation_Date IS NULL))))
376: AND ( (l_Assignment_Set_rec.Description =
377: p_Assignment_Set_rec.Description) OR

Line 378: ((p_Assignment_Set_rec.Description = FND_API.G_MISS_CHAR) OR

374: ( (l_Assignment_Set_rec.Creation_Date IS NULL) AND
375: (p_Assignment_Set_rec.Creation_Date IS NULL))))
376: AND ( (l_Assignment_Set_rec.Description =
377: p_Assignment_Set_rec.Description) OR
378: ((p_Assignment_Set_rec.Description = FND_API.G_MISS_CHAR) OR
379: ( (l_Assignment_Set_rec.Description IS NULL) AND
380: (p_Assignment_Set_rec.Description IS NULL))))
381: AND ( (l_Assignment_Set_rec.Last_Updated_By =
382: p_Assignment_Set_rec.Last_Updated_By) OR

Line 383: ((p_Assignment_Set_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR

379: ( (l_Assignment_Set_rec.Description IS NULL) AND
380: (p_Assignment_Set_rec.Description IS NULL))))
381: AND ( (l_Assignment_Set_rec.Last_Updated_By =
382: p_Assignment_Set_rec.Last_Updated_By) OR
383: ((p_Assignment_Set_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR
384: ( (l_Assignment_Set_rec.Last_Updated_By IS NULL) AND
385: (p_Assignment_Set_rec.Last_Updated_By IS NULL))))
386: AND ( (l_Assignment_Set_rec.Last_Update_Date =
387: p_Assignment_Set_rec.Last_Update_Date) OR

Line 388: ((p_Assignment_Set_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR

384: ( (l_Assignment_Set_rec.Last_Updated_By IS NULL) AND
385: (p_Assignment_Set_rec.Last_Updated_By IS NULL))))
386: AND ( (l_Assignment_Set_rec.Last_Update_Date =
387: p_Assignment_Set_rec.Last_Update_Date) OR
388: ((p_Assignment_Set_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR
389: ( (l_Assignment_Set_rec.Last_Update_Date IS NULL) AND
390: (p_Assignment_Set_rec.Last_Update_Date IS NULL))))
391: AND ( (l_Assignment_Set_rec.Last_Update_Login =
392: p_Assignment_Set_rec.Last_Update_Login) OR

Line 393: ((p_Assignment_Set_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR

389: ( (l_Assignment_Set_rec.Last_Update_Date IS NULL) AND
390: (p_Assignment_Set_rec.Last_Update_Date IS NULL))))
391: AND ( (l_Assignment_Set_rec.Last_Update_Login =
392: p_Assignment_Set_rec.Last_Update_Login) OR
393: ((p_Assignment_Set_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR
394: ( (l_Assignment_Set_rec.Last_Update_Login IS NULL) AND
395: (p_Assignment_Set_rec.Last_Update_Login IS NULL))))
396: AND ( (l_Assignment_Set_rec.Program_Application_Id =
397: p_Assignment_Set_rec.Program_Application_Id) OR

Line 398: ((p_Assignment_Set_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR

394: ( (l_Assignment_Set_rec.Last_Update_Login IS NULL) AND
395: (p_Assignment_Set_rec.Last_Update_Login IS NULL))))
396: AND ( (l_Assignment_Set_rec.Program_Application_Id =
397: p_Assignment_Set_rec.Program_Application_Id) OR
398: ((p_Assignment_Set_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR
399: ( (l_Assignment_Set_rec.Program_Application_Id IS NULL) AND
400: (p_Assignment_Set_rec.Program_Application_Id IS NULL))))
401: AND ( (l_Assignment_Set_rec.Program_Id =
402: p_Assignment_Set_rec.Program_Id) OR

Line 403: ((p_Assignment_Set_rec.Program_Id = FND_API.G_MISS_NUM) OR

399: ( (l_Assignment_Set_rec.Program_Application_Id IS NULL) AND
400: (p_Assignment_Set_rec.Program_Application_Id IS NULL))))
401: AND ( (l_Assignment_Set_rec.Program_Id =
402: p_Assignment_Set_rec.Program_Id) OR
403: ((p_Assignment_Set_rec.Program_Id = FND_API.G_MISS_NUM) OR
404: ( (l_Assignment_Set_rec.Program_Id IS NULL) AND
405: (p_Assignment_Set_rec.Program_Id IS NULL))))
406: AND ( (l_Assignment_Set_rec.Program_Update_Date =
407: p_Assignment_Set_rec.Program_Update_Date) OR

Line 408: ((p_Assignment_Set_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR

404: ( (l_Assignment_Set_rec.Program_Id IS NULL) AND
405: (p_Assignment_Set_rec.Program_Id IS NULL))))
406: AND ( (l_Assignment_Set_rec.Program_Update_Date =
407: p_Assignment_Set_rec.Program_Update_Date) OR
408: ((p_Assignment_Set_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR
409: ( (l_Assignment_Set_rec.Program_Update_Date IS NULL) AND
410: (p_Assignment_Set_rec.Program_Update_Date IS NULL))))
411: AND ( (l_Assignment_Set_rec.Request_Id =
412: p_Assignment_Set_rec.Request_Id) OR

Line 413: ((p_Assignment_Set_rec.Request_Id = FND_API.G_MISS_NUM) OR

409: ( (l_Assignment_Set_rec.Program_Update_Date IS NULL) AND
410: (p_Assignment_Set_rec.Program_Update_Date IS NULL))))
411: AND ( (l_Assignment_Set_rec.Request_Id =
412: p_Assignment_Set_rec.Request_Id) OR
413: ((p_Assignment_Set_rec.Request_Id = FND_API.G_MISS_NUM) OR
414: ( (l_Assignment_Set_rec.Request_Id IS NULL) AND
415: (p_Assignment_Set_rec.Request_Id IS NULL))))
416: THEN
417:

Line 424: x_return_status := FND_API.G_RET_STS_SUCCESS;

420: x_Assignment_Set_rec := l_Assignment_Set_rec;
421:
422: -- Set return status
423:
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: ELSE
428:

Line 425: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_SUCCESS;

421:
422: -- Set return status
423:
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: ELSE
428:
429: -- Row has changed by another user.

Line 431: x_return_status := FND_API.G_RET_STS_ERROR;

427: ELSE
428:
429: -- Row has changed by another user.
430:
431: x_return_status := FND_API.G_RET_STS_ERROR;
432: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;
433:
434: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
435: THEN

Line 432: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;

428:
429: -- Row has changed by another user.
430:
431: x_return_status := FND_API.G_RET_STS_ERROR;
432: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;
433:
434: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
435: THEN
436:

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: EXCEPTION
445:
446: WHEN NO_DATA_FOUND THEN
447:
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;
450:
451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
452: THEN

Line 449: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;

445:
446: WHEN NO_DATA_FOUND THEN
447:
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;
450:
451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
452: THEN
453:

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456:
457: END IF;
458: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
459:
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;
462:
463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
464: THEN

Line 461: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;

457: END IF;
458: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
459:
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;
462:
463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
464: THEN
465:

Line 472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

468:
469: END IF;
470: WHEN OTHERS THEN
471:
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474:
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
476: THEN

Line 473: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

469: END IF;
470: WHEN OTHERS THEN
471:
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474:
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
476: THEN
477: FND_MSG_PUB.Add_Exc_Msg

Line 568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

564: , 'Query_Row'
565: );
566: END IF;
567:
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569:
570: END Query_Row;
571:
572: -- Procedure Query_Entity

Line 655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

651: , 'Query_Entity'
652: );
653: END IF;
654:
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656:
657: END Query_Entity;
658:
659: END MRP_Assignment_Set_Handlers;