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_HANDLERS dependencies on FND_API

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: , 'Update_Row'
66: );
67: END IF;
68:
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70:
71: END Update_Row;
72:
73: -- Procedure Insert_Row

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168: , 'Insert_Row'
169: );
170: END IF;
171:
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173:
174: END Insert_Row;
175:
176: -- Procedure Delete_Row

Line 200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 298: ((p_Assignment_rec.Assignment_Id = FND_API.G_MISS_NUM) OR

294: -- Row locked. Compare IN attributes to DB attributes.
295:
296: IF ( (l_Assignment_rec.Assignment_Id =
297: p_Assignment_rec.Assignment_Id) OR
298: ((p_Assignment_rec.Assignment_Id = FND_API.G_MISS_NUM) OR
299: ( (l_Assignment_rec.Assignment_Id IS NULL) AND
300: (p_Assignment_rec.Assignment_Id IS NULL))))
301: AND ( (l_Assignment_rec.Assignment_Set_Id =
302: p_Assignment_rec.Assignment_Set_Id) OR

Line 303: ((p_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM) OR

299: ( (l_Assignment_rec.Assignment_Id IS NULL) AND
300: (p_Assignment_rec.Assignment_Id IS NULL))))
301: AND ( (l_Assignment_rec.Assignment_Set_Id =
302: p_Assignment_rec.Assignment_Set_Id) OR
303: ((p_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM) OR
304: ( (l_Assignment_rec.Assignment_Set_Id IS NULL) AND
305: (p_Assignment_rec.Assignment_Set_Id IS NULL))))
306: AND ( (l_Assignment_rec.Assignment_Type =
307: p_Assignment_rec.Assignment_Type) OR

Line 308: ((p_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM) OR

304: ( (l_Assignment_rec.Assignment_Set_Id IS NULL) AND
305: (p_Assignment_rec.Assignment_Set_Id IS NULL))))
306: AND ( (l_Assignment_rec.Assignment_Type =
307: p_Assignment_rec.Assignment_Type) OR
308: ((p_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM) OR
309: ( (l_Assignment_rec.Assignment_Type IS NULL) AND
310: (p_Assignment_rec.Assignment_Type IS NULL))))
311: AND ( (l_Assignment_rec.Attribute1 =
312: p_Assignment_rec.Attribute1) OR

Line 313: ((p_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR) OR

309: ( (l_Assignment_rec.Assignment_Type IS NULL) AND
310: (p_Assignment_rec.Assignment_Type IS NULL))))
311: AND ( (l_Assignment_rec.Attribute1 =
312: p_Assignment_rec.Attribute1) OR
313: ((p_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR) OR
314: ( (l_Assignment_rec.Attribute1 IS NULL) AND
315: (p_Assignment_rec.Attribute1 IS NULL))))
316: AND ( (l_Assignment_rec.Attribute10 =
317: p_Assignment_rec.Attribute10) OR

Line 318: ((p_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR) OR

314: ( (l_Assignment_rec.Attribute1 IS NULL) AND
315: (p_Assignment_rec.Attribute1 IS NULL))))
316: AND ( (l_Assignment_rec.Attribute10 =
317: p_Assignment_rec.Attribute10) OR
318: ((p_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR) OR
319: ( (l_Assignment_rec.Attribute10 IS NULL) AND
320: (p_Assignment_rec.Attribute10 IS NULL))))
321: AND ( (l_Assignment_rec.Attribute11 =
322: p_Assignment_rec.Attribute11) OR

Line 323: ((p_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR) OR

319: ( (l_Assignment_rec.Attribute10 IS NULL) AND
320: (p_Assignment_rec.Attribute10 IS NULL))))
321: AND ( (l_Assignment_rec.Attribute11 =
322: p_Assignment_rec.Attribute11) OR
323: ((p_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR) OR
324: ( (l_Assignment_rec.Attribute11 IS NULL) AND
325: (p_Assignment_rec.Attribute11 IS NULL))))
326: AND ( (l_Assignment_rec.Attribute12 =
327: p_Assignment_rec.Attribute12) OR

Line 328: ((p_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR) OR

324: ( (l_Assignment_rec.Attribute11 IS NULL) AND
325: (p_Assignment_rec.Attribute11 IS NULL))))
326: AND ( (l_Assignment_rec.Attribute12 =
327: p_Assignment_rec.Attribute12) OR
328: ((p_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR) OR
329: ( (l_Assignment_rec.Attribute12 IS NULL) AND
330: (p_Assignment_rec.Attribute12 IS NULL))))
331: AND ( (l_Assignment_rec.Attribute13 =
332: p_Assignment_rec.Attribute13) OR

Line 333: ((p_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR) OR

329: ( (l_Assignment_rec.Attribute12 IS NULL) AND
330: (p_Assignment_rec.Attribute12 IS NULL))))
331: AND ( (l_Assignment_rec.Attribute13 =
332: p_Assignment_rec.Attribute13) OR
333: ((p_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR) OR
334: ( (l_Assignment_rec.Attribute13 IS NULL) AND
335: (p_Assignment_rec.Attribute13 IS NULL))))
336: AND ( (l_Assignment_rec.Attribute14 =
337: p_Assignment_rec.Attribute14) OR

Line 338: ((p_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR) OR

334: ( (l_Assignment_rec.Attribute13 IS NULL) AND
335: (p_Assignment_rec.Attribute13 IS NULL))))
336: AND ( (l_Assignment_rec.Attribute14 =
337: p_Assignment_rec.Attribute14) OR
338: ((p_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR) OR
339: ( (l_Assignment_rec.Attribute14 IS NULL) AND
340: (p_Assignment_rec.Attribute14 IS NULL))))
341: AND ( (l_Assignment_rec.Attribute15 =
342: p_Assignment_rec.Attribute15) OR

Line 343: ((p_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR) OR

339: ( (l_Assignment_rec.Attribute14 IS NULL) AND
340: (p_Assignment_rec.Attribute14 IS NULL))))
341: AND ( (l_Assignment_rec.Attribute15 =
342: p_Assignment_rec.Attribute15) OR
343: ((p_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR) OR
344: ( (l_Assignment_rec.Attribute15 IS NULL) AND
345: (p_Assignment_rec.Attribute15 IS NULL))))
346: AND ( (l_Assignment_rec.Attribute2 =
347: p_Assignment_rec.Attribute2) OR

Line 348: ((p_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR) OR

344: ( (l_Assignment_rec.Attribute15 IS NULL) AND
345: (p_Assignment_rec.Attribute15 IS NULL))))
346: AND ( (l_Assignment_rec.Attribute2 =
347: p_Assignment_rec.Attribute2) OR
348: ((p_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR) OR
349: ( (l_Assignment_rec.Attribute2 IS NULL) AND
350: (p_Assignment_rec.Attribute2 IS NULL))))
351: AND ( (l_Assignment_rec.Attribute3 =
352: p_Assignment_rec.Attribute3) OR

Line 353: ((p_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR) OR

349: ( (l_Assignment_rec.Attribute2 IS NULL) AND
350: (p_Assignment_rec.Attribute2 IS NULL))))
351: AND ( (l_Assignment_rec.Attribute3 =
352: p_Assignment_rec.Attribute3) OR
353: ((p_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR) OR
354: ( (l_Assignment_rec.Attribute3 IS NULL) AND
355: (p_Assignment_rec.Attribute3 IS NULL))))
356: AND ( (l_Assignment_rec.Attribute4 =
357: p_Assignment_rec.Attribute4) OR

Line 358: ((p_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR) OR

354: ( (l_Assignment_rec.Attribute3 IS NULL) AND
355: (p_Assignment_rec.Attribute3 IS NULL))))
356: AND ( (l_Assignment_rec.Attribute4 =
357: p_Assignment_rec.Attribute4) OR
358: ((p_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR) OR
359: ( (l_Assignment_rec.Attribute4 IS NULL) AND
360: (p_Assignment_rec.Attribute4 IS NULL))))
361: AND ( (l_Assignment_rec.Attribute5 =
362: p_Assignment_rec.Attribute5) OR

Line 363: ((p_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR) OR

359: ( (l_Assignment_rec.Attribute4 IS NULL) AND
360: (p_Assignment_rec.Attribute4 IS NULL))))
361: AND ( (l_Assignment_rec.Attribute5 =
362: p_Assignment_rec.Attribute5) OR
363: ((p_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR) OR
364: ( (l_Assignment_rec.Attribute5 IS NULL) AND
365: (p_Assignment_rec.Attribute5 IS NULL))))
366: AND ( (l_Assignment_rec.Attribute6 =
367: p_Assignment_rec.Attribute6) OR

Line 368: ((p_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR) OR

364: ( (l_Assignment_rec.Attribute5 IS NULL) AND
365: (p_Assignment_rec.Attribute5 IS NULL))))
366: AND ( (l_Assignment_rec.Attribute6 =
367: p_Assignment_rec.Attribute6) OR
368: ((p_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR) OR
369: ( (l_Assignment_rec.Attribute6 IS NULL) AND
370: (p_Assignment_rec.Attribute6 IS NULL))))
371: AND ( (l_Assignment_rec.Attribute7 =
372: p_Assignment_rec.Attribute7) OR

Line 373: ((p_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR) OR

369: ( (l_Assignment_rec.Attribute6 IS NULL) AND
370: (p_Assignment_rec.Attribute6 IS NULL))))
371: AND ( (l_Assignment_rec.Attribute7 =
372: p_Assignment_rec.Attribute7) OR
373: ((p_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR) OR
374: ( (l_Assignment_rec.Attribute7 IS NULL) AND
375: (p_Assignment_rec.Attribute7 IS NULL))))
376: AND ( (l_Assignment_rec.Attribute8 =
377: p_Assignment_rec.Attribute8) OR

Line 378: ((p_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR) OR

374: ( (l_Assignment_rec.Attribute7 IS NULL) AND
375: (p_Assignment_rec.Attribute7 IS NULL))))
376: AND ( (l_Assignment_rec.Attribute8 =
377: p_Assignment_rec.Attribute8) OR
378: ((p_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR) OR
379: ( (l_Assignment_rec.Attribute8 IS NULL) AND
380: (p_Assignment_rec.Attribute8 IS NULL))))
381: AND ( (l_Assignment_rec.Attribute9 =
382: p_Assignment_rec.Attribute9) OR

Line 383: ((p_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR) OR

379: ( (l_Assignment_rec.Attribute8 IS NULL) AND
380: (p_Assignment_rec.Attribute8 IS NULL))))
381: AND ( (l_Assignment_rec.Attribute9 =
382: p_Assignment_rec.Attribute9) OR
383: ((p_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR) OR
384: ( (l_Assignment_rec.Attribute9 IS NULL) AND
385: (p_Assignment_rec.Attribute9 IS NULL))))
386: AND ( (l_Assignment_rec.Attribute_Category =
387: p_Assignment_rec.Attribute_Category) OR

Line 388: ((p_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR) OR

384: ( (l_Assignment_rec.Attribute9 IS NULL) AND
385: (p_Assignment_rec.Attribute9 IS NULL))))
386: AND ( (l_Assignment_rec.Attribute_Category =
387: p_Assignment_rec.Attribute_Category) OR
388: ((p_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR) OR
389: ( (l_Assignment_rec.Attribute_Category IS NULL) AND
390: (p_Assignment_rec.Attribute_Category IS NULL))))
391: AND ( (l_Assignment_rec.Category_Id =
392: p_Assignment_rec.Category_Id) OR

Line 393: ((p_Assignment_rec.Category_Id = FND_API.G_MISS_NUM) OR

389: ( (l_Assignment_rec.Attribute_Category IS NULL) AND
390: (p_Assignment_rec.Attribute_Category IS NULL))))
391: AND ( (l_Assignment_rec.Category_Id =
392: p_Assignment_rec.Category_Id) OR
393: ((p_Assignment_rec.Category_Id = FND_API.G_MISS_NUM) OR
394: ( (l_Assignment_rec.Category_Id IS NULL) AND
395: (p_Assignment_rec.Category_Id IS NULL))))
396: AND ( (l_Assignment_rec.Category_Set_Id =
397: p_Assignment_rec.Category_Set_Id) OR

Line 398: ((p_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM) OR

394: ( (l_Assignment_rec.Category_Id IS NULL) AND
395: (p_Assignment_rec.Category_Id IS NULL))))
396: AND ( (l_Assignment_rec.Category_Set_Id =
397: p_Assignment_rec.Category_Set_Id) OR
398: ((p_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM) OR
399: ( (l_Assignment_rec.Category_Set_Id IS NULL) AND
400: (p_Assignment_rec.Category_Set_Id IS NULL))))
401: AND ( (l_Assignment_rec.Created_By =
402: p_Assignment_rec.Created_By) OR

Line 403: ((p_Assignment_rec.Created_By = FND_API.G_MISS_NUM) OR

399: ( (l_Assignment_rec.Category_Set_Id IS NULL) AND
400: (p_Assignment_rec.Category_Set_Id IS NULL))))
401: AND ( (l_Assignment_rec.Created_By =
402: p_Assignment_rec.Created_By) OR
403: ((p_Assignment_rec.Created_By = FND_API.G_MISS_NUM) OR
404: ( (l_Assignment_rec.Created_By IS NULL) AND
405: (p_Assignment_rec.Created_By IS NULL))))
406: AND ( (l_Assignment_rec.Creation_Date =
407: p_Assignment_rec.Creation_Date) OR

Line 408: ((p_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE) OR

404: ( (l_Assignment_rec.Created_By IS NULL) AND
405: (p_Assignment_rec.Created_By IS NULL))))
406: AND ( (l_Assignment_rec.Creation_Date =
407: p_Assignment_rec.Creation_Date) OR
408: ((p_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE) OR
409: ( (l_Assignment_rec.Creation_Date IS NULL) AND
410: (p_Assignment_rec.Creation_Date IS NULL))))
411: AND ( (l_Assignment_rec.Customer_Id =
412: p_Assignment_rec.Customer_Id) OR

Line 413: ((p_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM) OR

409: ( (l_Assignment_rec.Creation_Date IS NULL) AND
410: (p_Assignment_rec.Creation_Date IS NULL))))
411: AND ( (l_Assignment_rec.Customer_Id =
412: p_Assignment_rec.Customer_Id) OR
413: ((p_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM) OR
414: ( (l_Assignment_rec.Customer_Id IS NULL) AND
415: (p_Assignment_rec.Customer_Id IS NULL))))
416: AND ( (l_Assignment_rec.Inventory_Item_Id =
417: p_Assignment_rec.Inventory_Item_Id) OR

Line 418: ((p_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM) OR

414: ( (l_Assignment_rec.Customer_Id IS NULL) AND
415: (p_Assignment_rec.Customer_Id IS NULL))))
416: AND ( (l_Assignment_rec.Inventory_Item_Id =
417: p_Assignment_rec.Inventory_Item_Id) OR
418: ((p_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM) OR
419: ( (l_Assignment_rec.Inventory_Item_Id IS NULL) AND
420: (p_Assignment_rec.Inventory_Item_Id IS NULL))))
421: AND ( (l_Assignment_rec.Last_Updated_By =
422: p_Assignment_rec.Last_Updated_By) OR

Line 423: ((p_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR

419: ( (l_Assignment_rec.Inventory_Item_Id IS NULL) AND
420: (p_Assignment_rec.Inventory_Item_Id IS NULL))))
421: AND ( (l_Assignment_rec.Last_Updated_By =
422: p_Assignment_rec.Last_Updated_By) OR
423: ((p_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR
424: ( (l_Assignment_rec.Last_Updated_By IS NULL) AND
425: (p_Assignment_rec.Last_Updated_By IS NULL))))
426: AND ( (l_Assignment_rec.Last_Update_Date =
427: p_Assignment_rec.Last_Update_Date) OR

Line 428: ((p_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR

424: ( (l_Assignment_rec.Last_Updated_By IS NULL) AND
425: (p_Assignment_rec.Last_Updated_By IS NULL))))
426: AND ( (l_Assignment_rec.Last_Update_Date =
427: p_Assignment_rec.Last_Update_Date) OR
428: ((p_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR
429: ( (l_Assignment_rec.Last_Update_Date IS NULL) AND
430: (p_Assignment_rec.Last_Update_Date IS NULL))))
431: AND ( (l_Assignment_rec.Last_Update_Login =
432: p_Assignment_rec.Last_Update_Login) OR

Line 433: ((p_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR

429: ( (l_Assignment_rec.Last_Update_Date IS NULL) AND
430: (p_Assignment_rec.Last_Update_Date IS NULL))))
431: AND ( (l_Assignment_rec.Last_Update_Login =
432: p_Assignment_rec.Last_Update_Login) OR
433: ((p_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR
434: ( (l_Assignment_rec.Last_Update_Login IS NULL) AND
435: (p_Assignment_rec.Last_Update_Login IS NULL))))
436: AND ( (l_Assignment_rec.Organization_Id =
437: p_Assignment_rec.Organization_Id) OR

Line 438: ((p_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM) OR

434: ( (l_Assignment_rec.Last_Update_Login IS NULL) AND
435: (p_Assignment_rec.Last_Update_Login IS NULL))))
436: AND ( (l_Assignment_rec.Organization_Id =
437: p_Assignment_rec.Organization_Id) OR
438: ((p_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM) OR
439: ( (l_Assignment_rec.Organization_Id IS NULL) AND
440: (p_Assignment_rec.Organization_Id IS NULL))))
441: AND ( (l_Assignment_rec.Program_Application_Id =
442: p_Assignment_rec.Program_Application_Id) OR

Line 443: ((p_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR

439: ( (l_Assignment_rec.Organization_Id IS NULL) AND
440: (p_Assignment_rec.Organization_Id IS NULL))))
441: AND ( (l_Assignment_rec.Program_Application_Id =
442: p_Assignment_rec.Program_Application_Id) OR
443: ((p_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR
444: ( (l_Assignment_rec.Program_Application_Id IS NULL) AND
445: (p_Assignment_rec.Program_Application_Id IS NULL))))
446: AND ( (l_Assignment_rec.Program_Id =
447: p_Assignment_rec.Program_Id) OR

Line 448: ((p_Assignment_rec.Program_Id = FND_API.G_MISS_NUM) OR

444: ( (l_Assignment_rec.Program_Application_Id IS NULL) AND
445: (p_Assignment_rec.Program_Application_Id IS NULL))))
446: AND ( (l_Assignment_rec.Program_Id =
447: p_Assignment_rec.Program_Id) OR
448: ((p_Assignment_rec.Program_Id = FND_API.G_MISS_NUM) OR
449: ( (l_Assignment_rec.Program_Id IS NULL) AND
450: (p_Assignment_rec.Program_Id IS NULL))))
451: AND ( (l_Assignment_rec.Program_Update_Date =
452: p_Assignment_rec.Program_Update_Date) OR

Line 453: ((p_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR

449: ( (l_Assignment_rec.Program_Id IS NULL) AND
450: (p_Assignment_rec.Program_Id IS NULL))))
451: AND ( (l_Assignment_rec.Program_Update_Date =
452: p_Assignment_rec.Program_Update_Date) OR
453: ((p_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR
454: ( (l_Assignment_rec.Program_Update_Date IS NULL) AND
455: (p_Assignment_rec.Program_Update_Date IS NULL))))
456: AND ( (l_Assignment_rec.Request_Id =
457: p_Assignment_rec.Request_Id) OR

Line 458: ((p_Assignment_rec.Request_Id = FND_API.G_MISS_NUM) OR

454: ( (l_Assignment_rec.Program_Update_Date IS NULL) AND
455: (p_Assignment_rec.Program_Update_Date IS NULL))))
456: AND ( (l_Assignment_rec.Request_Id =
457: p_Assignment_rec.Request_Id) OR
458: ((p_Assignment_rec.Request_Id = FND_API.G_MISS_NUM) OR
459: ( (l_Assignment_rec.Request_Id IS NULL) AND
460: (p_Assignment_rec.Request_Id IS NULL))))
461: AND ( (l_Assignment_rec.Secondary_Inventory =
462: p_Assignment_rec.Secondary_Inventory) OR

Line 463: ((p_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR) OR

459: ( (l_Assignment_rec.Request_Id IS NULL) AND
460: (p_Assignment_rec.Request_Id IS NULL))))
461: AND ( (l_Assignment_rec.Secondary_Inventory =
462: p_Assignment_rec.Secondary_Inventory) OR
463: ((p_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR) OR
464: ( (l_Assignment_rec.Secondary_Inventory IS NULL) AND
465: (p_Assignment_rec.Secondary_Inventory IS NULL))))
466: AND ( (l_Assignment_rec.Ship_To_Site_Id =
467: p_Assignment_rec.Ship_To_Site_Id) OR

Line 468: ((p_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM) OR

464: ( (l_Assignment_rec.Secondary_Inventory IS NULL) AND
465: (p_Assignment_rec.Secondary_Inventory IS NULL))))
466: AND ( (l_Assignment_rec.Ship_To_Site_Id =
467: p_Assignment_rec.Ship_To_Site_Id) OR
468: ((p_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM) OR
469: ( (l_Assignment_rec.Ship_To_Site_Id IS NULL) AND
470: (p_Assignment_rec.Ship_To_Site_Id IS NULL))))
471: AND ( (l_Assignment_rec.Sourcing_Rule_Id =
472: p_Assignment_rec.Sourcing_Rule_Id) OR

Line 473: ((p_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM) OR

469: ( (l_Assignment_rec.Ship_To_Site_Id IS NULL) AND
470: (p_Assignment_rec.Ship_To_Site_Id IS NULL))))
471: AND ( (l_Assignment_rec.Sourcing_Rule_Id =
472: p_Assignment_rec.Sourcing_Rule_Id) OR
473: ((p_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM) OR
474: ( (l_Assignment_rec.Sourcing_Rule_Id IS NULL) AND
475: (p_Assignment_rec.Sourcing_Rule_Id IS NULL))))
476: AND ( (l_Assignment_rec.Sourcing_Rule_Type =
477: p_Assignment_rec.Sourcing_Rule_Type) OR

Line 478: ((p_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM) OR

474: ( (l_Assignment_rec.Sourcing_Rule_Id IS NULL) AND
475: (p_Assignment_rec.Sourcing_Rule_Id IS NULL))))
476: AND ( (l_Assignment_rec.Sourcing_Rule_Type =
477: p_Assignment_rec.Sourcing_Rule_Type) OR
478: ((p_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM) OR
479: ( (l_Assignment_rec.Sourcing_Rule_Type IS NULL) AND
480: (p_Assignment_rec.Sourcing_Rule_Type IS NULL))))
481: THEN
482:

Line 489: x_return_status := FND_API.G_RET_STS_SUCCESS;

485: x_Assignment_rec := l_Assignment_rec;
486:
487: -- Set return status
488:
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490: x_Assignment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: ELSE
493:

Line 490: x_Assignment_rec.return_status := FND_API.G_RET_STS_SUCCESS;

486:
487: -- Set return status
488:
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490: x_Assignment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: ELSE
493:
494: -- Row has changed by another user.

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

492: ELSE
493:
494: -- Row has changed by another user.
495:
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;
498:
499: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
500: THEN

Line 497: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;

493:
494: -- Row has changed by another user.
495:
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;
498:
499: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
500: THEN
501:

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509: EXCEPTION
510:
511: WHEN NO_DATA_FOUND THEN
512:
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;
515:
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
517: THEN

Line 514: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;

510:
511: WHEN NO_DATA_FOUND THEN
512:
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;
515:
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
517: THEN
518:

Line 525: x_return_status := FND_API.G_RET_STS_ERROR;

521:
522: END IF;
523: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
524:
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;
527:
528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
529: THEN

Line 526: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;

522: END IF;
523: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
524:
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;
527:
528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
529: THEN
530:

Line 537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

533:
534: END IF;
535: WHEN OTHERS THEN
536:
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: x_Assignment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539:
540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN

Line 538: x_Assignment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

534: END IF;
535: WHEN OTHERS THEN
536:
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: x_Assignment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539:
540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: FND_MSG_PUB.Add_Exc_Msg

Line 575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

571: , 'Query_Row'
572: );
573: END IF;
574:
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576:
577: END Query_Row;
578:
579: -- Procedure Query_Entity

Line 615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

611: , 'Query_Entity'
612: );
613: END IF;
614:
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616:
617: END Query_Entity;
618:
619: -- Function Query_Rows

Line 625: FND_API.G_MISS_NUM

621: --
622:
623: FUNCTION Query_Rows
624: ( p_Assignment_Id IN NUMBER :=
625: FND_API.G_MISS_NUM
626: , p_Assignment_Set_Id IN NUMBER :=
627: FND_API.G_MISS_NUM
628: ) RETURN MRP_Src_Assignment_PUB.Assignment_Tbl_Type
629: IS

Line 627: FND_API.G_MISS_NUM

623: FUNCTION Query_Rows
624: ( p_Assignment_Id IN NUMBER :=
625: FND_API.G_MISS_NUM
626: , p_Assignment_Set_Id IN NUMBER :=
627: FND_API.G_MISS_NUM
628: ) RETURN MRP_Src_Assignment_PUB.Assignment_Tbl_Type
629: IS
630: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
631: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

Line 682: p_Assignment_Id <> FND_API.G_MISS_NUM)

678:
679: IF
680: (p_Assignment_Id IS NOT NULL
681: AND
682: p_Assignment_Id <> FND_API.G_MISS_NUM)
683: AND
684: (p_Assignment_Set_Id IS NOT NULL
685: AND
686: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)

Line 686: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)

682: p_Assignment_Id <> FND_API.G_MISS_NUM)
683: AND
684: (p_Assignment_Set_Id IS NOT NULL
685: AND
686: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)
687: THEN
688: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
689: THEN
690: FND_MSG_PUB.Add_Exc_Msg

Line 697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

693: , 'Keys are mutually exclusive: Assignment_Id = '|| p_Assignment_Id || ', Assignment_Set_Id = '|| p_Assignment_Set_Id
694: );
695: END IF;
696:
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698:
699: END IF;
700:
701:

Line 754: p_Assignment_Id <> FND_API.G_MISS_NUM)

750:
751: IF
752: (p_Assignment_Id IS NOT NULL
753: AND
754: p_Assignment_Id <> FND_API.G_MISS_NUM)
755: AND
756: (l_Assignment_tbl.COUNT = 0)
757: THEN
758: RAISE NO_DATA_FOUND;

Line 768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

764: RETURN l_Assignment_tbl;
765:
766: EXCEPTION
767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769:
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771:
772: WHEN OTHERS THEN

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

766: EXCEPTION
767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769:
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771:
772: WHEN OTHERS THEN
773:
774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

778: , 'Query_Rows'
779: );
780: END IF;
781:
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783:
784: END Query_Rows;
785:
786: -- Procedure Query_Entities

Line 792: FND_API.G_MISS_NUM

788: --
789:
790: PROCEDURE Query_Entities
791: ( p_Assignment_Id IN NUMBER :=
792: FND_API.G_MISS_NUM
793: , p_Assignment_Set_Id IN NUMBER :=
794: FND_API.G_MISS_NUM
795: , x_Assignment_tbl OUT MRP_Src_Assignment_PUB.Assignment_Tbl_Type
796: , x_Assignment_val_tbl OUT MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type

Line 794: FND_API.G_MISS_NUM

790: PROCEDURE Query_Entities
791: ( p_Assignment_Id IN NUMBER :=
792: FND_API.G_MISS_NUM
793: , p_Assignment_Set_Id IN NUMBER :=
794: FND_API.G_MISS_NUM
795: , x_Assignment_tbl OUT MRP_Src_Assignment_PUB.Assignment_Tbl_Type
796: , x_Assignment_val_tbl OUT MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type
797: )
798: IS

Line 852: p_Assignment_Id <> FND_API.G_MISS_NUM)

848:
849: IF
850: (p_Assignment_Id IS NOT NULL
851: AND
852: p_Assignment_Id <> FND_API.G_MISS_NUM)
853: AND
854: (p_Assignment_Set_Id IS NOT NULL
855: AND
856: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)

Line 856: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)

852: p_Assignment_Id <> FND_API.G_MISS_NUM)
853: AND
854: (p_Assignment_Set_Id IS NOT NULL
855: AND
856: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)
857: THEN
858: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
859: THEN
860: FND_MSG_PUB.Add_Exc_Msg

Line 867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

863: , 'Keys are mutually exclusive: Assignment_Id = '|| p_Assignment_Id || ', Assignment_Set_Id = '|| p_Assignment_Set_Id
864: );
865: END IF;
866:
867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
868:
869: END IF;
870:
871:

Line 928: p_Assignment_Id <> FND_API.G_MISS_NUM)

924:
925: IF
926: (p_Assignment_Id IS NOT NULL
927: AND
928: p_Assignment_Id <> FND_API.G_MISS_NUM)
929: AND
930: (NOT l_rows_fetched)
931: THEN
932: RAISE NO_DATA_FOUND;

Line 937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

933: END IF;
934:
935: EXCEPTION
936:
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938:
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940:
941: WHEN OTHERS THEN

Line 939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

935: EXCEPTION
936:
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938:
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940:
941: WHEN OTHERS THEN
942:
943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

947: , 'Query_Entities'
948: );
949: END IF;
950:
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952:
953: END Query_Entities;
954:
955: END MRP_Assignment_Handlers;