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

Line 64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

60: , 'Update_Row'
61: );
62: END IF;
63:
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65:
66: END Update_Row;
67:
68: -- Procedure Insert_Row

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

153: , 'Insert_Row'
154: );
155: END IF;
156:
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158:
159: END Insert_Row;
160:
161: -- Procedure Delete_Row

Line 168: l_sr_receipt_id NUMBER := FND_API.G_MISS_NUM;

164: ( p_Sourcing_Rule_Id IN NUMBER
165: )
166: IS
167:
168: l_sr_receipt_id NUMBER := FND_API.G_MISS_NUM;
169:
170: CURSOR cur_Receiving_Org IS
171: SELECT SR_RECEIPT_ID
172: FROM MRP_SR_RECEIPT_ORG

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: , 'Delete_Row'
209: );
210: END IF;
211:
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213:
214: END Delete_Row;
215:
216: -- Procedure lock_Row

Line 300: ((p_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM) OR

296: -- Row locked. Compare IN attributes to DB attributes.
297:
298: IF ( (l_Sourcing_Rule_rec.Sourcing_Rule_Id =
299: p_Sourcing_Rule_rec.Sourcing_Rule_Id) OR
300: ((p_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM) OR
301: ( (l_Sourcing_Rule_rec.Sourcing_Rule_Id IS NULL) AND
302: (p_Sourcing_Rule_rec.Sourcing_Rule_Id IS NULL))))
303: AND ( (l_Sourcing_Rule_rec.Attribute1 =
304: p_Sourcing_Rule_rec.Attribute1) OR

Line 305: ((p_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR) OR

301: ( (l_Sourcing_Rule_rec.Sourcing_Rule_Id IS NULL) AND
302: (p_Sourcing_Rule_rec.Sourcing_Rule_Id IS NULL))))
303: AND ( (l_Sourcing_Rule_rec.Attribute1 =
304: p_Sourcing_Rule_rec.Attribute1) OR
305: ((p_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR) OR
306: ( (l_Sourcing_Rule_rec.Attribute1 IS NULL) AND
307: (p_Sourcing_Rule_rec.Attribute1 IS NULL))))
308: AND ( (l_Sourcing_Rule_rec.Attribute10 =
309: p_Sourcing_Rule_rec.Attribute10) OR

Line 310: ((p_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR) OR

306: ( (l_Sourcing_Rule_rec.Attribute1 IS NULL) AND
307: (p_Sourcing_Rule_rec.Attribute1 IS NULL))))
308: AND ( (l_Sourcing_Rule_rec.Attribute10 =
309: p_Sourcing_Rule_rec.Attribute10) OR
310: ((p_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR) OR
311: ( (l_Sourcing_Rule_rec.Attribute10 IS NULL) AND
312: (p_Sourcing_Rule_rec.Attribute10 IS NULL))))
313: AND ( (l_Sourcing_Rule_rec.Attribute11 =
314: p_Sourcing_Rule_rec.Attribute11) OR

Line 315: ((p_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR) OR

311: ( (l_Sourcing_Rule_rec.Attribute10 IS NULL) AND
312: (p_Sourcing_Rule_rec.Attribute10 IS NULL))))
313: AND ( (l_Sourcing_Rule_rec.Attribute11 =
314: p_Sourcing_Rule_rec.Attribute11) OR
315: ((p_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR) OR
316: ( (l_Sourcing_Rule_rec.Attribute11 IS NULL) AND
317: (p_Sourcing_Rule_rec.Attribute11 IS NULL))))
318: AND ( (l_Sourcing_Rule_rec.Attribute12 =
319: p_Sourcing_Rule_rec.Attribute12) OR

Line 320: ((p_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR) OR

316: ( (l_Sourcing_Rule_rec.Attribute11 IS NULL) AND
317: (p_Sourcing_Rule_rec.Attribute11 IS NULL))))
318: AND ( (l_Sourcing_Rule_rec.Attribute12 =
319: p_Sourcing_Rule_rec.Attribute12) OR
320: ((p_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR) OR
321: ( (l_Sourcing_Rule_rec.Attribute12 IS NULL) AND
322: (p_Sourcing_Rule_rec.Attribute12 IS NULL))))
323: AND ( (l_Sourcing_Rule_rec.Attribute13 =
324: p_Sourcing_Rule_rec.Attribute13) OR

Line 325: ((p_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR) OR

321: ( (l_Sourcing_Rule_rec.Attribute12 IS NULL) AND
322: (p_Sourcing_Rule_rec.Attribute12 IS NULL))))
323: AND ( (l_Sourcing_Rule_rec.Attribute13 =
324: p_Sourcing_Rule_rec.Attribute13) OR
325: ((p_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR) OR
326: ( (l_Sourcing_Rule_rec.Attribute13 IS NULL) AND
327: (p_Sourcing_Rule_rec.Attribute13 IS NULL))))
328: AND ( (l_Sourcing_Rule_rec.Attribute14 =
329: p_Sourcing_Rule_rec.Attribute14) OR

Line 330: ((p_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR) OR

326: ( (l_Sourcing_Rule_rec.Attribute13 IS NULL) AND
327: (p_Sourcing_Rule_rec.Attribute13 IS NULL))))
328: AND ( (l_Sourcing_Rule_rec.Attribute14 =
329: p_Sourcing_Rule_rec.Attribute14) OR
330: ((p_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR) OR
331: ( (l_Sourcing_Rule_rec.Attribute14 IS NULL) AND
332: (p_Sourcing_Rule_rec.Attribute14 IS NULL))))
333: AND ( (l_Sourcing_Rule_rec.Attribute15 =
334: p_Sourcing_Rule_rec.Attribute15) OR

Line 335: ((p_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR) OR

331: ( (l_Sourcing_Rule_rec.Attribute14 IS NULL) AND
332: (p_Sourcing_Rule_rec.Attribute14 IS NULL))))
333: AND ( (l_Sourcing_Rule_rec.Attribute15 =
334: p_Sourcing_Rule_rec.Attribute15) OR
335: ((p_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR) OR
336: ( (l_Sourcing_Rule_rec.Attribute15 IS NULL) AND
337: (p_Sourcing_Rule_rec.Attribute15 IS NULL))))
338: AND ( (l_Sourcing_Rule_rec.Attribute2 =
339: p_Sourcing_Rule_rec.Attribute2) OR

Line 340: ((p_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR) OR

336: ( (l_Sourcing_Rule_rec.Attribute15 IS NULL) AND
337: (p_Sourcing_Rule_rec.Attribute15 IS NULL))))
338: AND ( (l_Sourcing_Rule_rec.Attribute2 =
339: p_Sourcing_Rule_rec.Attribute2) OR
340: ((p_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR) OR
341: ( (l_Sourcing_Rule_rec.Attribute2 IS NULL) AND
342: (p_Sourcing_Rule_rec.Attribute2 IS NULL))))
343: AND ( (l_Sourcing_Rule_rec.Attribute3 =
344: p_Sourcing_Rule_rec.Attribute3) OR

Line 345: ((p_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR) OR

341: ( (l_Sourcing_Rule_rec.Attribute2 IS NULL) AND
342: (p_Sourcing_Rule_rec.Attribute2 IS NULL))))
343: AND ( (l_Sourcing_Rule_rec.Attribute3 =
344: p_Sourcing_Rule_rec.Attribute3) OR
345: ((p_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR) OR
346: ( (l_Sourcing_Rule_rec.Attribute3 IS NULL) AND
347: (p_Sourcing_Rule_rec.Attribute3 IS NULL))))
348: AND ( (l_Sourcing_Rule_rec.Attribute4 =
349: p_Sourcing_Rule_rec.Attribute4) OR

Line 350: ((p_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR) OR

346: ( (l_Sourcing_Rule_rec.Attribute3 IS NULL) AND
347: (p_Sourcing_Rule_rec.Attribute3 IS NULL))))
348: AND ( (l_Sourcing_Rule_rec.Attribute4 =
349: p_Sourcing_Rule_rec.Attribute4) OR
350: ((p_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR) OR
351: ( (l_Sourcing_Rule_rec.Attribute4 IS NULL) AND
352: (p_Sourcing_Rule_rec.Attribute4 IS NULL))))
353: AND ( (l_Sourcing_Rule_rec.Attribute5 =
354: p_Sourcing_Rule_rec.Attribute5) OR

Line 355: ((p_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR) OR

351: ( (l_Sourcing_Rule_rec.Attribute4 IS NULL) AND
352: (p_Sourcing_Rule_rec.Attribute4 IS NULL))))
353: AND ( (l_Sourcing_Rule_rec.Attribute5 =
354: p_Sourcing_Rule_rec.Attribute5) OR
355: ((p_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR) OR
356: ( (l_Sourcing_Rule_rec.Attribute5 IS NULL) AND
357: (p_Sourcing_Rule_rec.Attribute5 IS NULL))))
358: AND ( (l_Sourcing_Rule_rec.Attribute6 =
359: p_Sourcing_Rule_rec.Attribute6) OR

Line 360: ((p_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR) OR

356: ( (l_Sourcing_Rule_rec.Attribute5 IS NULL) AND
357: (p_Sourcing_Rule_rec.Attribute5 IS NULL))))
358: AND ( (l_Sourcing_Rule_rec.Attribute6 =
359: p_Sourcing_Rule_rec.Attribute6) OR
360: ((p_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR) OR
361: ( (l_Sourcing_Rule_rec.Attribute6 IS NULL) AND
362: (p_Sourcing_Rule_rec.Attribute6 IS NULL))))
363: AND ( (l_Sourcing_Rule_rec.Attribute7 =
364: p_Sourcing_Rule_rec.Attribute7) OR

Line 365: ((p_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR) OR

361: ( (l_Sourcing_Rule_rec.Attribute6 IS NULL) AND
362: (p_Sourcing_Rule_rec.Attribute6 IS NULL))))
363: AND ( (l_Sourcing_Rule_rec.Attribute7 =
364: p_Sourcing_Rule_rec.Attribute7) OR
365: ((p_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR) OR
366: ( (l_Sourcing_Rule_rec.Attribute7 IS NULL) AND
367: (p_Sourcing_Rule_rec.Attribute7 IS NULL))))
368: AND ( (l_Sourcing_Rule_rec.Attribute8 =
369: p_Sourcing_Rule_rec.Attribute8) OR

Line 370: ((p_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR) OR

366: ( (l_Sourcing_Rule_rec.Attribute7 IS NULL) AND
367: (p_Sourcing_Rule_rec.Attribute7 IS NULL))))
368: AND ( (l_Sourcing_Rule_rec.Attribute8 =
369: p_Sourcing_Rule_rec.Attribute8) OR
370: ((p_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR) OR
371: ( (l_Sourcing_Rule_rec.Attribute8 IS NULL) AND
372: (p_Sourcing_Rule_rec.Attribute8 IS NULL))))
373: AND ( (l_Sourcing_Rule_rec.Attribute9 =
374: p_Sourcing_Rule_rec.Attribute9) OR

Line 375: ((p_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR) OR

371: ( (l_Sourcing_Rule_rec.Attribute8 IS NULL) AND
372: (p_Sourcing_Rule_rec.Attribute8 IS NULL))))
373: AND ( (l_Sourcing_Rule_rec.Attribute9 =
374: p_Sourcing_Rule_rec.Attribute9) OR
375: ((p_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR) OR
376: ( (l_Sourcing_Rule_rec.Attribute9 IS NULL) AND
377: (p_Sourcing_Rule_rec.Attribute9 IS NULL))))
378: AND ( (l_Sourcing_Rule_rec.Attribute_Category =
379: p_Sourcing_Rule_rec.Attribute_Category) OR

Line 380: ((p_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR) OR

376: ( (l_Sourcing_Rule_rec.Attribute9 IS NULL) AND
377: (p_Sourcing_Rule_rec.Attribute9 IS NULL))))
378: AND ( (l_Sourcing_Rule_rec.Attribute_Category =
379: p_Sourcing_Rule_rec.Attribute_Category) OR
380: ((p_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR) OR
381: ( (l_Sourcing_Rule_rec.Attribute_Category IS NULL) AND
382: (p_Sourcing_Rule_rec.Attribute_Category IS NULL))))
383: AND ( (l_Sourcing_Rule_rec.Created_By =
384: p_Sourcing_Rule_rec.Created_By) OR

Line 385: ((p_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM) OR

381: ( (l_Sourcing_Rule_rec.Attribute_Category IS NULL) AND
382: (p_Sourcing_Rule_rec.Attribute_Category IS NULL))))
383: AND ( (l_Sourcing_Rule_rec.Created_By =
384: p_Sourcing_Rule_rec.Created_By) OR
385: ((p_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM) OR
386: ( (l_Sourcing_Rule_rec.Created_By IS NULL) AND
387: (p_Sourcing_Rule_rec.Created_By IS NULL))))
388: AND ( (l_Sourcing_Rule_rec.Creation_Date =
389: p_Sourcing_Rule_rec.Creation_Date) OR

Line 390: ((p_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE) OR

386: ( (l_Sourcing_Rule_rec.Created_By IS NULL) AND
387: (p_Sourcing_Rule_rec.Created_By IS NULL))))
388: AND ( (l_Sourcing_Rule_rec.Creation_Date =
389: p_Sourcing_Rule_rec.Creation_Date) OR
390: ((p_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE) OR
391: ( (l_Sourcing_Rule_rec.Creation_Date IS NULL) AND
392: (p_Sourcing_Rule_rec.Creation_Date IS NULL))))
393: AND ( (l_Sourcing_Rule_rec.Description =
394: p_Sourcing_Rule_rec.Description) OR

Line 395: ((p_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR) OR

391: ( (l_Sourcing_Rule_rec.Creation_Date IS NULL) AND
392: (p_Sourcing_Rule_rec.Creation_Date IS NULL))))
393: AND ( (l_Sourcing_Rule_rec.Description =
394: p_Sourcing_Rule_rec.Description) OR
395: ((p_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR) OR
396: ( (l_Sourcing_Rule_rec.Description IS NULL) AND
397: (p_Sourcing_Rule_rec.Description IS NULL))))
398: AND ( (l_Sourcing_Rule_rec.Last_Updated_By =
399: p_Sourcing_Rule_rec.Last_Updated_By) OR

Line 400: ((p_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR

396: ( (l_Sourcing_Rule_rec.Description IS NULL) AND
397: (p_Sourcing_Rule_rec.Description IS NULL))))
398: AND ( (l_Sourcing_Rule_rec.Last_Updated_By =
399: p_Sourcing_Rule_rec.Last_Updated_By) OR
400: ((p_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR
401: ( (l_Sourcing_Rule_rec.Last_Updated_By IS NULL) AND
402: (p_Sourcing_Rule_rec.Last_Updated_By IS NULL))))
403: AND ( (l_Sourcing_Rule_rec.Last_Update_Date =
404: p_Sourcing_Rule_rec.Last_Update_Date) OR

Line 405: ((p_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR

401: ( (l_Sourcing_Rule_rec.Last_Updated_By IS NULL) AND
402: (p_Sourcing_Rule_rec.Last_Updated_By IS NULL))))
403: AND ( (l_Sourcing_Rule_rec.Last_Update_Date =
404: p_Sourcing_Rule_rec.Last_Update_Date) OR
405: ((p_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR
406: ( (l_Sourcing_Rule_rec.Last_Update_Date IS NULL) AND
407: (p_Sourcing_Rule_rec.Last_Update_Date IS NULL))))
408: AND ( (l_Sourcing_Rule_rec.Last_Update_Login =
409: p_Sourcing_Rule_rec.Last_Update_Login) OR

Line 410: ((p_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR

406: ( (l_Sourcing_Rule_rec.Last_Update_Date IS NULL) AND
407: (p_Sourcing_Rule_rec.Last_Update_Date IS NULL))))
408: AND ( (l_Sourcing_Rule_rec.Last_Update_Login =
409: p_Sourcing_Rule_rec.Last_Update_Login) OR
410: ((p_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR
411: ( (l_Sourcing_Rule_rec.Last_Update_Login IS NULL) AND
412: (p_Sourcing_Rule_rec.Last_Update_Login IS NULL))))
413: AND ( (l_Sourcing_Rule_rec.Organization_Id =
414: p_Sourcing_Rule_rec.Organization_Id) OR

Line 415: ((p_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM) OR

411: ( (l_Sourcing_Rule_rec.Last_Update_Login IS NULL) AND
412: (p_Sourcing_Rule_rec.Last_Update_Login IS NULL))))
413: AND ( (l_Sourcing_Rule_rec.Organization_Id =
414: p_Sourcing_Rule_rec.Organization_Id) OR
415: ((p_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM) OR
416: ( (l_Sourcing_Rule_rec.Organization_Id IS NULL) AND
417: (p_Sourcing_Rule_rec.Organization_Id IS NULL))))
418: AND ( (l_Sourcing_Rule_rec.Planning_Active =
419: p_Sourcing_Rule_rec.Planning_Active) OR

Line 420: ((p_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM) OR

416: ( (l_Sourcing_Rule_rec.Organization_Id IS NULL) AND
417: (p_Sourcing_Rule_rec.Organization_Id IS NULL))))
418: AND ( (l_Sourcing_Rule_rec.Planning_Active =
419: p_Sourcing_Rule_rec.Planning_Active) OR
420: ((p_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM) OR
421: ( (l_Sourcing_Rule_rec.Planning_Active IS NULL) AND
422: (p_Sourcing_Rule_rec.Planning_Active IS NULL))))
423: AND ( (l_Sourcing_Rule_rec.Program_Application_Id =
424: p_Sourcing_Rule_rec.Program_Application_Id) OR

Line 425: ((p_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR

421: ( (l_Sourcing_Rule_rec.Planning_Active IS NULL) AND
422: (p_Sourcing_Rule_rec.Planning_Active IS NULL))))
423: AND ( (l_Sourcing_Rule_rec.Program_Application_Id =
424: p_Sourcing_Rule_rec.Program_Application_Id) OR
425: ((p_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR
426: ( (l_Sourcing_Rule_rec.Program_Application_Id IS NULL) AND
427: (p_Sourcing_Rule_rec.Program_Application_Id IS NULL))))
428: AND ( (l_Sourcing_Rule_rec.Program_Id =
429: p_Sourcing_Rule_rec.Program_Id) OR

Line 430: ((p_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM) OR

426: ( (l_Sourcing_Rule_rec.Program_Application_Id IS NULL) AND
427: (p_Sourcing_Rule_rec.Program_Application_Id IS NULL))))
428: AND ( (l_Sourcing_Rule_rec.Program_Id =
429: p_Sourcing_Rule_rec.Program_Id) OR
430: ((p_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM) OR
431: ( (l_Sourcing_Rule_rec.Program_Id IS NULL) AND
432: (p_Sourcing_Rule_rec.Program_Id IS NULL))))
433: AND ( (l_Sourcing_Rule_rec.Program_Update_Date =
434: p_Sourcing_Rule_rec.Program_Update_Date) OR

Line 435: ((p_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR

431: ( (l_Sourcing_Rule_rec.Program_Id IS NULL) AND
432: (p_Sourcing_Rule_rec.Program_Id IS NULL))))
433: AND ( (l_Sourcing_Rule_rec.Program_Update_Date =
434: p_Sourcing_Rule_rec.Program_Update_Date) OR
435: ((p_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR
436: ( (l_Sourcing_Rule_rec.Program_Update_Date IS NULL) AND
437: (p_Sourcing_Rule_rec.Program_Update_Date IS NULL))))
438: AND ( (l_Sourcing_Rule_rec.Request_Id =
439: p_Sourcing_Rule_rec.Request_Id) OR

Line 440: ((p_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM) OR

436: ( (l_Sourcing_Rule_rec.Program_Update_Date IS NULL) AND
437: (p_Sourcing_Rule_rec.Program_Update_Date IS NULL))))
438: AND ( (l_Sourcing_Rule_rec.Request_Id =
439: p_Sourcing_Rule_rec.Request_Id) OR
440: ((p_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM) OR
441: ( (l_Sourcing_Rule_rec.Request_Id IS NULL) AND
442: (p_Sourcing_Rule_rec.Request_Id IS NULL))))
443: AND ( (l_Sourcing_Rule_rec.Sourcing_Rule_Name =
444: p_Sourcing_Rule_rec.Sourcing_Rule_Name) OR

Line 445: ((p_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR) OR

441: ( (l_Sourcing_Rule_rec.Request_Id IS NULL) AND
442: (p_Sourcing_Rule_rec.Request_Id IS NULL))))
443: AND ( (l_Sourcing_Rule_rec.Sourcing_Rule_Name =
444: p_Sourcing_Rule_rec.Sourcing_Rule_Name) OR
445: ((p_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR) OR
446: ( (l_Sourcing_Rule_rec.Sourcing_Rule_Name IS NULL) AND
447: (p_Sourcing_Rule_rec.Sourcing_Rule_Name IS NULL))))
448: AND ( (l_Sourcing_Rule_rec.Sourcing_Rule_Type =
449: p_Sourcing_Rule_rec.Sourcing_Rule_Type) OR

Line 450: ((p_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM) OR

446: ( (l_Sourcing_Rule_rec.Sourcing_Rule_Name IS NULL) AND
447: (p_Sourcing_Rule_rec.Sourcing_Rule_Name IS NULL))))
448: AND ( (l_Sourcing_Rule_rec.Sourcing_Rule_Type =
449: p_Sourcing_Rule_rec.Sourcing_Rule_Type) OR
450: ((p_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM) OR
451: ( (l_Sourcing_Rule_rec.Sourcing_Rule_Type IS NULL) AND
452: (p_Sourcing_Rule_rec.Sourcing_Rule_Type IS NULL))))
453: AND ( (l_Sourcing_Rule_rec.Status =
454: p_Sourcing_Rule_rec.Status) OR

Line 455: ((p_Sourcing_Rule_rec.Status = FND_API.G_MISS_NUM) OR

451: ( (l_Sourcing_Rule_rec.Sourcing_Rule_Type IS NULL) AND
452: (p_Sourcing_Rule_rec.Sourcing_Rule_Type IS NULL))))
453: AND ( (l_Sourcing_Rule_rec.Status =
454: p_Sourcing_Rule_rec.Status) OR
455: ((p_Sourcing_Rule_rec.Status = FND_API.G_MISS_NUM) OR
456: ( (l_Sourcing_Rule_rec.Status IS NULL) AND
457: (p_Sourcing_Rule_rec.Status IS NULL))))
458: THEN
459:

Line 466: x_return_status := FND_API.G_RET_STS_SUCCESS;

462: x_Sourcing_Rule_rec := l_Sourcing_Rule_rec;
463:
464: -- Set return status
465:
466: x_return_status := FND_API.G_RET_STS_SUCCESS;
467: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
468:
469: ELSE
470:

Line 467: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_SUCCESS;

463:
464: -- Set return status
465:
466: x_return_status := FND_API.G_RET_STS_SUCCESS;
467: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
468:
469: ELSE
470:
471: -- Row has changed by another user.

Line 473: x_return_status := FND_API.G_RET_STS_ERROR;

469: ELSE
470:
471: -- Row has changed by another user.
472:
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_ERROR;
475:
476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
477: THEN

Line 474: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_ERROR;

470:
471: -- Row has changed by another user.
472:
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_ERROR;
475:
476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
477: THEN
478:

Line 490: x_return_status := FND_API.G_RET_STS_ERROR;

486: EXCEPTION
487:
488: WHEN NO_DATA_FOUND THEN
489:
490: x_return_status := FND_API.G_RET_STS_ERROR;
491: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_ERROR;
492:
493: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
494: THEN

Line 491: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_ERROR;

487:
488: WHEN NO_DATA_FOUND THEN
489:
490: x_return_status := FND_API.G_RET_STS_ERROR;
491: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_ERROR;
492:
493: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
494: THEN
495:

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498:
499: END IF;
500: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
501:
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_ERROR;
504:
505: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
506: THEN

Line 503: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_ERROR;

499: END IF;
500: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
501:
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_ERROR;
504:
505: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
506: THEN
507:

Line 514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

510:
511: END IF;
512: WHEN OTHERS THEN
513:
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516:
517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN

Line 515: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

511: END IF;
512: WHEN OTHERS THEN
513:
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: x_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516:
517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: FND_MSG_PUB.Add_Exc_Msg

Line 618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

614: , 'Query_Row'
615: );
616: END IF;
617:
618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619:
620: END Query_Row;
621:
622: -- Procedure Query_Entity

Line 713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

709: , 'Query_Entity'
710: );
711: END IF;
712:
713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714:
715: END Query_Entity;
716:
717: END MRP_Sourcing_Rule_Handlers;