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

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162: , 'Insert_Row'
163: );
164: END IF;
165:
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167:
168: END Insert_Row;
169:
170: -- Procedure Delete_Row

Line 194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

190: , 'Delete_Row'
191: );
192: END IF;
193:
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195:
196: END Delete_Row;
197:
198: -- Procedure lock_Row

Line 288: ((p_Shipping_Org_rec.Sr_Source_Id = FND_API.G_MISS_NUM) OR

284: -- Row locked. Compare IN attributes to DB attributes.
285:
286: IF ( (l_Shipping_Org_rec.Sr_Source_Id =
287: p_Shipping_Org_rec.Sr_Source_Id) OR
288: ((p_Shipping_Org_rec.Sr_Source_Id = FND_API.G_MISS_NUM) OR
289: ( (l_Shipping_Org_rec.Sr_Source_Id IS NULL) AND
290: (p_Shipping_Org_rec.Sr_Source_Id IS NULL))))
291: AND ( (l_Shipping_Org_rec.Allocation_Percent =
292: p_Shipping_Org_rec.Allocation_Percent) OR

Line 293: ((p_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM) OR

289: ( (l_Shipping_Org_rec.Sr_Source_Id IS NULL) AND
290: (p_Shipping_Org_rec.Sr_Source_Id IS NULL))))
291: AND ( (l_Shipping_Org_rec.Allocation_Percent =
292: p_Shipping_Org_rec.Allocation_Percent) OR
293: ((p_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM) OR
294: ( (l_Shipping_Org_rec.Allocation_Percent IS NULL) AND
295: (p_Shipping_Org_rec.Allocation_Percent IS NULL))))
296: AND ( (l_Shipping_Org_rec.Attribute1 =
297: p_Shipping_Org_rec.Attribute1) OR

Line 298: ((p_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR) OR

294: ( (l_Shipping_Org_rec.Allocation_Percent IS NULL) AND
295: (p_Shipping_Org_rec.Allocation_Percent IS NULL))))
296: AND ( (l_Shipping_Org_rec.Attribute1 =
297: p_Shipping_Org_rec.Attribute1) OR
298: ((p_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR) OR
299: ( (l_Shipping_Org_rec.Attribute1 IS NULL) AND
300: (p_Shipping_Org_rec.Attribute1 IS NULL))))
301: AND ( (l_Shipping_Org_rec.Attribute10 =
302: p_Shipping_Org_rec.Attribute10) OR

Line 303: ((p_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR) OR

299: ( (l_Shipping_Org_rec.Attribute1 IS NULL) AND
300: (p_Shipping_Org_rec.Attribute1 IS NULL))))
301: AND ( (l_Shipping_Org_rec.Attribute10 =
302: p_Shipping_Org_rec.Attribute10) OR
303: ((p_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR) OR
304: ( (l_Shipping_Org_rec.Attribute10 IS NULL) AND
305: (p_Shipping_Org_rec.Attribute10 IS NULL))))
306: AND ( (l_Shipping_Org_rec.Attribute11 =
307: p_Shipping_Org_rec.Attribute11) OR

Line 308: ((p_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR) OR

304: ( (l_Shipping_Org_rec.Attribute10 IS NULL) AND
305: (p_Shipping_Org_rec.Attribute10 IS NULL))))
306: AND ( (l_Shipping_Org_rec.Attribute11 =
307: p_Shipping_Org_rec.Attribute11) OR
308: ((p_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR) OR
309: ( (l_Shipping_Org_rec.Attribute11 IS NULL) AND
310: (p_Shipping_Org_rec.Attribute11 IS NULL))))
311: AND ( (l_Shipping_Org_rec.Attribute12 =
312: p_Shipping_Org_rec.Attribute12) OR

Line 313: ((p_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR) OR

309: ( (l_Shipping_Org_rec.Attribute11 IS NULL) AND
310: (p_Shipping_Org_rec.Attribute11 IS NULL))))
311: AND ( (l_Shipping_Org_rec.Attribute12 =
312: p_Shipping_Org_rec.Attribute12) OR
313: ((p_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR) OR
314: ( (l_Shipping_Org_rec.Attribute12 IS NULL) AND
315: (p_Shipping_Org_rec.Attribute12 IS NULL))))
316: AND ( (l_Shipping_Org_rec.Attribute13 =
317: p_Shipping_Org_rec.Attribute13) OR

Line 318: ((p_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR) OR

314: ( (l_Shipping_Org_rec.Attribute12 IS NULL) AND
315: (p_Shipping_Org_rec.Attribute12 IS NULL))))
316: AND ( (l_Shipping_Org_rec.Attribute13 =
317: p_Shipping_Org_rec.Attribute13) OR
318: ((p_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR) OR
319: ( (l_Shipping_Org_rec.Attribute13 IS NULL) AND
320: (p_Shipping_Org_rec.Attribute13 IS NULL))))
321: AND ( (l_Shipping_Org_rec.Attribute14 =
322: p_Shipping_Org_rec.Attribute14) OR

Line 323: ((p_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR) OR

319: ( (l_Shipping_Org_rec.Attribute13 IS NULL) AND
320: (p_Shipping_Org_rec.Attribute13 IS NULL))))
321: AND ( (l_Shipping_Org_rec.Attribute14 =
322: p_Shipping_Org_rec.Attribute14) OR
323: ((p_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR) OR
324: ( (l_Shipping_Org_rec.Attribute14 IS NULL) AND
325: (p_Shipping_Org_rec.Attribute14 IS NULL))))
326: AND ( (l_Shipping_Org_rec.Attribute15 =
327: p_Shipping_Org_rec.Attribute15) OR

Line 328: ((p_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR) OR

324: ( (l_Shipping_Org_rec.Attribute14 IS NULL) AND
325: (p_Shipping_Org_rec.Attribute14 IS NULL))))
326: AND ( (l_Shipping_Org_rec.Attribute15 =
327: p_Shipping_Org_rec.Attribute15) OR
328: ((p_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR) OR
329: ( (l_Shipping_Org_rec.Attribute15 IS NULL) AND
330: (p_Shipping_Org_rec.Attribute15 IS NULL))))
331: AND ( (l_Shipping_Org_rec.Attribute2 =
332: p_Shipping_Org_rec.Attribute2) OR

Line 333: ((p_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR) OR

329: ( (l_Shipping_Org_rec.Attribute15 IS NULL) AND
330: (p_Shipping_Org_rec.Attribute15 IS NULL))))
331: AND ( (l_Shipping_Org_rec.Attribute2 =
332: p_Shipping_Org_rec.Attribute2) OR
333: ((p_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR) OR
334: ( (l_Shipping_Org_rec.Attribute2 IS NULL) AND
335: (p_Shipping_Org_rec.Attribute2 IS NULL))))
336: AND ( (l_Shipping_Org_rec.Attribute3 =
337: p_Shipping_Org_rec.Attribute3) OR

Line 338: ((p_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR) OR

334: ( (l_Shipping_Org_rec.Attribute2 IS NULL) AND
335: (p_Shipping_Org_rec.Attribute2 IS NULL))))
336: AND ( (l_Shipping_Org_rec.Attribute3 =
337: p_Shipping_Org_rec.Attribute3) OR
338: ((p_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR) OR
339: ( (l_Shipping_Org_rec.Attribute3 IS NULL) AND
340: (p_Shipping_Org_rec.Attribute3 IS NULL))))
341: AND ( (l_Shipping_Org_rec.Attribute4 =
342: p_Shipping_Org_rec.Attribute4) OR

Line 343: ((p_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR) OR

339: ( (l_Shipping_Org_rec.Attribute3 IS NULL) AND
340: (p_Shipping_Org_rec.Attribute3 IS NULL))))
341: AND ( (l_Shipping_Org_rec.Attribute4 =
342: p_Shipping_Org_rec.Attribute4) OR
343: ((p_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR) OR
344: ( (l_Shipping_Org_rec.Attribute4 IS NULL) AND
345: (p_Shipping_Org_rec.Attribute4 IS NULL))))
346: AND ( (l_Shipping_Org_rec.Attribute5 =
347: p_Shipping_Org_rec.Attribute5) OR

Line 348: ((p_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR) OR

344: ( (l_Shipping_Org_rec.Attribute4 IS NULL) AND
345: (p_Shipping_Org_rec.Attribute4 IS NULL))))
346: AND ( (l_Shipping_Org_rec.Attribute5 =
347: p_Shipping_Org_rec.Attribute5) OR
348: ((p_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR) OR
349: ( (l_Shipping_Org_rec.Attribute5 IS NULL) AND
350: (p_Shipping_Org_rec.Attribute5 IS NULL))))
351: AND ( (l_Shipping_Org_rec.Attribute6 =
352: p_Shipping_Org_rec.Attribute6) OR

Line 353: ((p_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR) OR

349: ( (l_Shipping_Org_rec.Attribute5 IS NULL) AND
350: (p_Shipping_Org_rec.Attribute5 IS NULL))))
351: AND ( (l_Shipping_Org_rec.Attribute6 =
352: p_Shipping_Org_rec.Attribute6) OR
353: ((p_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR) OR
354: ( (l_Shipping_Org_rec.Attribute6 IS NULL) AND
355: (p_Shipping_Org_rec.Attribute6 IS NULL))))
356: AND ( (l_Shipping_Org_rec.Attribute7 =
357: p_Shipping_Org_rec.Attribute7) OR

Line 358: ((p_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR) OR

354: ( (l_Shipping_Org_rec.Attribute6 IS NULL) AND
355: (p_Shipping_Org_rec.Attribute6 IS NULL))))
356: AND ( (l_Shipping_Org_rec.Attribute7 =
357: p_Shipping_Org_rec.Attribute7) OR
358: ((p_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR) OR
359: ( (l_Shipping_Org_rec.Attribute7 IS NULL) AND
360: (p_Shipping_Org_rec.Attribute7 IS NULL))))
361: AND ( (l_Shipping_Org_rec.Attribute8 =
362: p_Shipping_Org_rec.Attribute8) OR

Line 363: ((p_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR) OR

359: ( (l_Shipping_Org_rec.Attribute7 IS NULL) AND
360: (p_Shipping_Org_rec.Attribute7 IS NULL))))
361: AND ( (l_Shipping_Org_rec.Attribute8 =
362: p_Shipping_Org_rec.Attribute8) OR
363: ((p_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR) OR
364: ( (l_Shipping_Org_rec.Attribute8 IS NULL) AND
365: (p_Shipping_Org_rec.Attribute8 IS NULL))))
366: AND ( (l_Shipping_Org_rec.Attribute9 =
367: p_Shipping_Org_rec.Attribute9) OR

Line 368: ((p_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR) OR

364: ( (l_Shipping_Org_rec.Attribute8 IS NULL) AND
365: (p_Shipping_Org_rec.Attribute8 IS NULL))))
366: AND ( (l_Shipping_Org_rec.Attribute9 =
367: p_Shipping_Org_rec.Attribute9) OR
368: ((p_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR) OR
369: ( (l_Shipping_Org_rec.Attribute9 IS NULL) AND
370: (p_Shipping_Org_rec.Attribute9 IS NULL))))
371: AND ( (l_Shipping_Org_rec.Attribute_Category =
372: p_Shipping_Org_rec.Attribute_Category) OR

Line 373: ((p_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR) OR

369: ( (l_Shipping_Org_rec.Attribute9 IS NULL) AND
370: (p_Shipping_Org_rec.Attribute9 IS NULL))))
371: AND ( (l_Shipping_Org_rec.Attribute_Category =
372: p_Shipping_Org_rec.Attribute_Category) OR
373: ((p_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR) OR
374: ( (l_Shipping_Org_rec.Attribute_Category IS NULL) AND
375: (p_Shipping_Org_rec.Attribute_Category IS NULL))))
376: AND ( (l_Shipping_Org_rec.Created_By =
377: p_Shipping_Org_rec.Created_By) OR

Line 378: ((p_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM) OR

374: ( (l_Shipping_Org_rec.Attribute_Category IS NULL) AND
375: (p_Shipping_Org_rec.Attribute_Category IS NULL))))
376: AND ( (l_Shipping_Org_rec.Created_By =
377: p_Shipping_Org_rec.Created_By) OR
378: ((p_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM) OR
379: ( (l_Shipping_Org_rec.Created_By IS NULL) AND
380: (p_Shipping_Org_rec.Created_By IS NULL))))
381: AND ( (l_Shipping_Org_rec.Creation_Date =
382: p_Shipping_Org_rec.Creation_Date) OR

Line 383: ((p_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE) OR

379: ( (l_Shipping_Org_rec.Created_By IS NULL) AND
380: (p_Shipping_Org_rec.Created_By IS NULL))))
381: AND ( (l_Shipping_Org_rec.Creation_Date =
382: p_Shipping_Org_rec.Creation_Date) OR
383: ((p_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE) OR
384: ( (l_Shipping_Org_rec.Creation_Date IS NULL) AND
385: (p_Shipping_Org_rec.Creation_Date IS NULL))))
386: AND ( (l_Shipping_Org_rec.Last_Updated_By =
387: p_Shipping_Org_rec.Last_Updated_By) OR

Line 388: ((p_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR

384: ( (l_Shipping_Org_rec.Creation_Date IS NULL) AND
385: (p_Shipping_Org_rec.Creation_Date IS NULL))))
386: AND ( (l_Shipping_Org_rec.Last_Updated_By =
387: p_Shipping_Org_rec.Last_Updated_By) OR
388: ((p_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR
389: ( (l_Shipping_Org_rec.Last_Updated_By IS NULL) AND
390: (p_Shipping_Org_rec.Last_Updated_By IS NULL))))
391: AND ( (l_Shipping_Org_rec.Last_Update_Date =
392: p_Shipping_Org_rec.Last_Update_Date) OR

Line 393: ((p_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR

389: ( (l_Shipping_Org_rec.Last_Updated_By IS NULL) AND
390: (p_Shipping_Org_rec.Last_Updated_By IS NULL))))
391: AND ( (l_Shipping_Org_rec.Last_Update_Date =
392: p_Shipping_Org_rec.Last_Update_Date) OR
393: ((p_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR
394: ( (l_Shipping_Org_rec.Last_Update_Date IS NULL) AND
395: (p_Shipping_Org_rec.Last_Update_Date IS NULL))))
396: AND ( (l_Shipping_Org_rec.Last_Update_Login =
397: p_Shipping_Org_rec.Last_Update_Login) OR

Line 398: ((p_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR

394: ( (l_Shipping_Org_rec.Last_Update_Date IS NULL) AND
395: (p_Shipping_Org_rec.Last_Update_Date IS NULL))))
396: AND ( (l_Shipping_Org_rec.Last_Update_Login =
397: p_Shipping_Org_rec.Last_Update_Login) OR
398: ((p_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR
399: ( (l_Shipping_Org_rec.Last_Update_Login IS NULL) AND
400: (p_Shipping_Org_rec.Last_Update_Login IS NULL))))
401: AND ( (l_Shipping_Org_rec.Program_Application_Id =
402: p_Shipping_Org_rec.Program_Application_Id) OR

Line 403: ((p_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR

399: ( (l_Shipping_Org_rec.Last_Update_Login IS NULL) AND
400: (p_Shipping_Org_rec.Last_Update_Login IS NULL))))
401: AND ( (l_Shipping_Org_rec.Program_Application_Id =
402: p_Shipping_Org_rec.Program_Application_Id) OR
403: ((p_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR
404: ( (l_Shipping_Org_rec.Program_Application_Id IS NULL) AND
405: (p_Shipping_Org_rec.Program_Application_Id IS NULL))))
406: AND ( (l_Shipping_Org_rec.Program_Id =
407: p_Shipping_Org_rec.Program_Id) OR

Line 408: ((p_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM) OR

404: ( (l_Shipping_Org_rec.Program_Application_Id IS NULL) AND
405: (p_Shipping_Org_rec.Program_Application_Id IS NULL))))
406: AND ( (l_Shipping_Org_rec.Program_Id =
407: p_Shipping_Org_rec.Program_Id) OR
408: ((p_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM) OR
409: ( (l_Shipping_Org_rec.Program_Id IS NULL) AND
410: (p_Shipping_Org_rec.Program_Id IS NULL))))
411: AND ( (l_Shipping_Org_rec.Program_Update_Date =
412: p_Shipping_Org_rec.Program_Update_Date) OR

Line 413: ((p_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR

409: ( (l_Shipping_Org_rec.Program_Id IS NULL) AND
410: (p_Shipping_Org_rec.Program_Id IS NULL))))
411: AND ( (l_Shipping_Org_rec.Program_Update_Date =
412: p_Shipping_Org_rec.Program_Update_Date) OR
413: ((p_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR
414: ( (l_Shipping_Org_rec.Program_Update_Date IS NULL) AND
415: (p_Shipping_Org_rec.Program_Update_Date IS NULL))))
416: AND ( (l_Shipping_Org_rec.Rank =
417: p_Shipping_Org_rec.Rank) OR

Line 418: ((p_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM) OR

414: ( (l_Shipping_Org_rec.Program_Update_Date IS NULL) AND
415: (p_Shipping_Org_rec.Program_Update_Date IS NULL))))
416: AND ( (l_Shipping_Org_rec.Rank =
417: p_Shipping_Org_rec.Rank) OR
418: ((p_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM) OR
419: ( (l_Shipping_Org_rec.Rank IS NULL) AND
420: (p_Shipping_Org_rec.Rank IS NULL))))
421: AND ( (l_Shipping_Org_rec.Request_Id =
422: p_Shipping_Org_rec.Request_Id) OR

Line 423: ((p_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM) OR

419: ( (l_Shipping_Org_rec.Rank IS NULL) AND
420: (p_Shipping_Org_rec.Rank IS NULL))))
421: AND ( (l_Shipping_Org_rec.Request_Id =
422: p_Shipping_Org_rec.Request_Id) OR
423: ((p_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM) OR
424: ( (l_Shipping_Org_rec.Request_Id IS NULL) AND
425: (p_Shipping_Org_rec.Request_Id IS NULL))))
426: AND ( (l_Shipping_Org_rec.Secondary_Inventory =
427: p_Shipping_Org_rec.Secondary_Inventory) OR

Line 428: ((p_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR) OR

424: ( (l_Shipping_Org_rec.Request_Id IS NULL) AND
425: (p_Shipping_Org_rec.Request_Id IS NULL))))
426: AND ( (l_Shipping_Org_rec.Secondary_Inventory =
427: p_Shipping_Org_rec.Secondary_Inventory) OR
428: ((p_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR) OR
429: ( (l_Shipping_Org_rec.Secondary_Inventory IS NULL) AND
430: (p_Shipping_Org_rec.Secondary_Inventory IS NULL))))
431: AND ( (l_Shipping_Org_rec.Ship_Method =
432: p_Shipping_Org_rec.Ship_Method) OR

Line 433: ((p_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR) OR

429: ( (l_Shipping_Org_rec.Secondary_Inventory IS NULL) AND
430: (p_Shipping_Org_rec.Secondary_Inventory IS NULL))))
431: AND ( (l_Shipping_Org_rec.Ship_Method =
432: p_Shipping_Org_rec.Ship_Method) OR
433: ((p_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR) OR
434: ( (l_Shipping_Org_rec.Ship_Method IS NULL) AND
435: (p_Shipping_Org_rec.Ship_Method IS NULL))))
436: AND ( (l_Shipping_Org_rec.Source_Organization_Id =
437: p_Shipping_Org_rec.Source_Organization_Id) OR

Line 438: ((p_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM) OR

434: ( (l_Shipping_Org_rec.Ship_Method IS NULL) AND
435: (p_Shipping_Org_rec.Ship_Method IS NULL))))
436: AND ( (l_Shipping_Org_rec.Source_Organization_Id =
437: p_Shipping_Org_rec.Source_Organization_Id) OR
438: ((p_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM) OR
439: ( (l_Shipping_Org_rec.Source_Organization_Id IS NULL) AND
440: (p_Shipping_Org_rec.Source_Organization_Id IS NULL))))
441: AND ( (l_Shipping_Org_rec.Source_Type =
442: p_Shipping_Org_rec.Source_Type) OR

Line 443: ((p_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM) OR

439: ( (l_Shipping_Org_rec.Source_Organization_Id IS NULL) AND
440: (p_Shipping_Org_rec.Source_Organization_Id IS NULL))))
441: AND ( (l_Shipping_Org_rec.Source_Type =
442: p_Shipping_Org_rec.Source_Type) OR
443: ((p_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM) OR
444: ( (l_Shipping_Org_rec.Source_Type IS NULL) AND
445: (p_Shipping_Org_rec.Source_Type IS NULL))))
446: AND ( (l_Shipping_Org_rec.Sr_Receipt_Id =
447: p_Shipping_Org_rec.Sr_Receipt_Id) OR

Line 448: ((p_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM) OR

444: ( (l_Shipping_Org_rec.Source_Type IS NULL) AND
445: (p_Shipping_Org_rec.Source_Type IS NULL))))
446: AND ( (l_Shipping_Org_rec.Sr_Receipt_Id =
447: p_Shipping_Org_rec.Sr_Receipt_Id) OR
448: ((p_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM) OR
449: ( (l_Shipping_Org_rec.Sr_Receipt_Id IS NULL) AND
450: (p_Shipping_Org_rec.Sr_Receipt_Id IS NULL))))
451: AND ( (l_Shipping_Org_rec.Vendor_Id =
452: p_Shipping_Org_rec.Vendor_Id) OR

Line 453: ((p_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM) OR

449: ( (l_Shipping_Org_rec.Sr_Receipt_Id IS NULL) AND
450: (p_Shipping_Org_rec.Sr_Receipt_Id IS NULL))))
451: AND ( (l_Shipping_Org_rec.Vendor_Id =
452: p_Shipping_Org_rec.Vendor_Id) OR
453: ((p_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM) OR
454: ( (l_Shipping_Org_rec.Vendor_Id IS NULL) AND
455: (p_Shipping_Org_rec.Vendor_Id IS NULL))))
456: AND ( (l_Shipping_Org_rec.Vendor_Site_Id =
457: p_Shipping_Org_rec.Vendor_Site_Id) OR

Line 458: ((p_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM) OR

454: ( (l_Shipping_Org_rec.Vendor_Id IS NULL) AND
455: (p_Shipping_Org_rec.Vendor_Id IS NULL))))
456: AND ( (l_Shipping_Org_rec.Vendor_Site_Id =
457: p_Shipping_Org_rec.Vendor_Site_Id) OR
458: ((p_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM) OR
459: ( (l_Shipping_Org_rec.Vendor_Site_Id IS NULL) AND
460: (p_Shipping_Org_rec.Vendor_Site_Id IS NULL))))
461: THEN
462:

Line 469: x_return_status := FND_API.G_RET_STS_SUCCESS;

465: x_Shipping_Org_rec := l_Shipping_Org_rec;
466:
467: -- Set return status
468:
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
470: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_SUCCESS;
471:
472: ELSE
473:

Line 470: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_SUCCESS;

466:
467: -- Set return status
468:
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
470: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_SUCCESS;
471:
472: ELSE
473:
474: -- Row has changed by another user.

Line 476: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 477: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;

473:
474: -- Row has changed by another user.
475:
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
478:
479: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
480: THEN
481:

Line 493: x_return_status := FND_API.G_RET_STS_ERROR;

489: EXCEPTION
490:
491: WHEN NO_DATA_FOUND THEN
492:
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
495:
496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
497: THEN

Line 494: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;

490:
491: WHEN NO_DATA_FOUND THEN
492:
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
495:
496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
497: THEN
498:

Line 505: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 506: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;

502: END IF;
503: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
504:
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
507:
508: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
509: THEN
510:

Line 517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

513:
514: END IF;
515: WHEN OTHERS THEN
516:
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519:
520: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
521: THEN

Line 518: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

514: END IF;
515: WHEN OTHERS THEN
516:
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519:
520: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
521: THEN
522: FND_MSG_PUB.Add_Exc_Msg

Line 555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

551: , 'Query_Row'
552: );
553: END IF;
554:
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556:
557: END Query_Row;
558:
559: -- Procedure Query_Entity

Line 595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

591: , 'Query_Entity'
592: );
593: END IF;
594:
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596:
597: END Query_Entity;
598:
599: -- Function Query_Rows

Line 605: FND_API.G_MISS_NUM

601: --
602:
603: FUNCTION Query_Rows
604: ( p_Sr_Source_Id IN NUMBER :=
605: FND_API.G_MISS_NUM
606: , p_Sr_Receipt_Id IN NUMBER :=
607: FND_API.G_MISS_NUM
608: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
609: IS

Line 607: FND_API.G_MISS_NUM

603: FUNCTION Query_Rows
604: ( p_Sr_Source_Id IN NUMBER :=
605: FND_API.G_MISS_NUM
606: , p_Sr_Receipt_Id IN NUMBER :=
607: FND_API.G_MISS_NUM
608: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
609: IS
610: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
611: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;

Line 660: p_Sr_Source_Id <> FND_API.G_MISS_NUM)

656:
657: IF
658: (p_Sr_Source_Id IS NOT NULL
659: AND
660: p_Sr_Source_Id <> FND_API.G_MISS_NUM)
661: AND
662: (p_Sr_Receipt_Id IS NOT NULL
663: AND
664: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)

Line 664: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)

660: p_Sr_Source_Id <> FND_API.G_MISS_NUM)
661: AND
662: (p_Sr_Receipt_Id IS NOT NULL
663: AND
664: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)
665: THEN
666: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
667: THEN
668: FND_MSG_PUB.Add_Exc_Msg

Line 675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

671: , 'Keys are mutually exclusive: Sr_Source_Id = '|| p_Sr_Source_Id || ', Sr_Receipt_Id = '|| p_Sr_Receipt_Id
672: );
673: END IF;
674:
675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
676:
677: END IF;
678:
679:

Line 730: p_Sr_Source_Id <> FND_API.G_MISS_NUM)

726:
727: IF
728: (p_Sr_Source_Id IS NOT NULL
729: AND
730: p_Sr_Source_Id <> FND_API.G_MISS_NUM)
731: AND
732: (l_Shipping_Org_tbl.COUNT = 0)
733: THEN
734: RAISE NO_DATA_FOUND;

Line 744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

740: RETURN l_Shipping_Org_tbl;
741:
742: EXCEPTION
743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745:
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747:
748: WHEN OTHERS THEN

Line 746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

742: EXCEPTION
743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745:
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747:
748: WHEN OTHERS THEN
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

754: , 'Query_Rows'
755: );
756: END IF;
757:
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759:
760: END Query_Rows;
761:
762: -- Procedure Query_Entities

Line 768: FND_API.G_MISS_NUM

764: --
765:
766: PROCEDURE Query_Entities
767: ( p_Sr_Source_Id IN NUMBER :=
768: FND_API.G_MISS_NUM
769: , p_Sr_Receipt_Id IN NUMBER :=
770: FND_API.G_MISS_NUM
771: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
772: , x_Shipping_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type

Line 770: FND_API.G_MISS_NUM

766: PROCEDURE Query_Entities
767: ( p_Sr_Source_Id IN NUMBER :=
768: FND_API.G_MISS_NUM
769: , p_Sr_Receipt_Id IN NUMBER :=
770: FND_API.G_MISS_NUM
771: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
772: , x_Shipping_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type
773: )
774: IS

Line 826: p_Sr_Source_Id <> FND_API.G_MISS_NUM)

822:
823: IF
824: (p_Sr_Source_Id IS NOT NULL
825: AND
826: p_Sr_Source_Id <> FND_API.G_MISS_NUM)
827: AND
828: (p_Sr_Receipt_Id IS NOT NULL
829: AND
830: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)

Line 830: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)

826: p_Sr_Source_Id <> FND_API.G_MISS_NUM)
827: AND
828: (p_Sr_Receipt_Id IS NOT NULL
829: AND
830: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)
831: THEN
832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: FND_MSG_PUB.Add_Exc_Msg

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

837: , 'Keys are mutually exclusive: Sr_Source_Id = '|| p_Sr_Source_Id || ', Sr_Receipt_Id = '|| p_Sr_Receipt_Id
838: );
839: END IF;
840:
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842:
843: END IF;
844:
845:

Line 900: p_Sr_Source_Id <> FND_API.G_MISS_NUM)

896:
897: IF
898: (p_Sr_Source_Id IS NOT NULL
899: AND
900: p_Sr_Source_Id <> FND_API.G_MISS_NUM)
901: AND
902: (NOT l_rows_fetched)
903: THEN
904: RAISE NO_DATA_FOUND;

Line 909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

905: END IF;
906:
907: EXCEPTION
908:
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910:
911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
912:
913: WHEN OTHERS THEN

Line 911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

907: EXCEPTION
908:
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910:
911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
912:
913: WHEN OTHERS THEN
914:
915: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

919: , 'Query_Entities'
920: );
921: END IF;
922:
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924:
925: END Query_Entities;
926:
927: END MRP_Shipping_Org_Handlers;