41: WHEN NO_DATA_FOUND THEN
42:
43: return null;
44:
45: WHEN FND_API.G_EXC_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
43: return null;
44:
45: WHEN FND_API.G_EXC_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
50:
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: WHEN FND_API.G_EXC_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
50:
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52:
53: WHEN OTHERS THEN
47: RAISE FND_API.G_EXC_ERROR;
48:
49: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
50:
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52:
53: WHEN OTHERS THEN
54:
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52:
53: WHEN OTHERS THEN
54:
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56:
57: END Under_Ship_Tol_From_Item ;
58:
59: FUNCTION Under_Ship_Tol_From_Customer
86: WHEN NO_DATA_FOUND THEN
87:
88: return null;
89:
90: WHEN FND_API.G_EXC_ERROR THEN
91:
92: RAISE FND_API.G_EXC_ERROR;
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
88: return null;
89:
90: WHEN FND_API.G_EXC_ERROR THEN
91:
92: RAISE FND_API.G_EXC_ERROR;
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95:
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: WHEN FND_API.G_EXC_ERROR THEN
91:
92: RAISE FND_API.G_EXC_ERROR;
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95:
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97:
98: WHEN OTHERS THEN
92: RAISE FND_API.G_EXC_ERROR;
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95:
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97:
98: WHEN OTHERS THEN
99:
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97:
98: WHEN OTHERS THEN
99:
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101:
102: END Under_Ship_Tol_From_Customer ;
103:
104: FUNCTION Under_Ship_Tol_From_Site
138: WHEN NO_DATA_FOUND THEN
139:
140: return null;
141:
142: WHEN FND_API.G_EXC_ERROR THEN
143:
144: RAISE FND_API.G_EXC_ERROR;
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: return null;
141:
142: WHEN FND_API.G_EXC_ERROR THEN
143:
144: RAISE FND_API.G_EXC_ERROR;
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147:
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: WHEN FND_API.G_EXC_ERROR THEN
143:
144: RAISE FND_API.G_EXC_ERROR;
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147:
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149:
150: WHEN OTHERS THEN
144: RAISE FND_API.G_EXC_ERROR;
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147:
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149:
150: WHEN OTHERS THEN
151:
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149:
150: WHEN OTHERS THEN
151:
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153:
154: END Under_Ship_Tol_From_Site;
155:
156: FUNCTION Under_Ship_Tol_From_Cust_Item
185: WHEN NO_DATA_FOUND THEN
186:
187: return null;
188:
189: WHEN FND_API.G_EXC_ERROR THEN
190:
191: RAISE FND_API.G_EXC_ERROR;
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: return null;
188:
189: WHEN FND_API.G_EXC_ERROR THEN
190:
191: RAISE FND_API.G_EXC_ERROR;
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194:
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: WHEN FND_API.G_EXC_ERROR THEN
190:
191: RAISE FND_API.G_EXC_ERROR;
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194:
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196:
197: WHEN OTHERS THEN
191: RAISE FND_API.G_EXC_ERROR;
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194:
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196:
197: WHEN OTHERS THEN
198:
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196:
197: WHEN OTHERS THEN
198:
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200:
201: END Under_Ship_Tol_From_Cust_Item ;
202:
203: FUNCTION Under_Ship_Tol_From_Site_Item
237: WHEN NO_DATA_FOUND THEN
238:
239: return null;
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242:
243: RAISE FND_API.G_EXC_ERROR;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: return null;
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242:
243: RAISE FND_API.G_EXC_ERROR;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246:
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: WHEN FND_API.G_EXC_ERROR THEN
242:
243: RAISE FND_API.G_EXC_ERROR;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246:
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248:
249: WHEN OTHERS THEN
243: RAISE FND_API.G_EXC_ERROR;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246:
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248:
249: WHEN OTHERS THEN
250:
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248:
249: WHEN OTHERS THEN
250:
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252:
253: END Under_Ship_Tol_From_Site_Item ;
254:
255: FUNCTION Over_Ship_Tol_From_Item
282: WHEN NO_DATA_FOUND THEN
283:
284: return null;
285:
286: WHEN FND_API.G_EXC_ERROR THEN
287:
288: RAISE FND_API.G_EXC_ERROR;
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: return null;
285:
286: WHEN FND_API.G_EXC_ERROR THEN
287:
288: RAISE FND_API.G_EXC_ERROR;
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291:
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: WHEN FND_API.G_EXC_ERROR THEN
287:
288: RAISE FND_API.G_EXC_ERROR;
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291:
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293:
294: WHEN OTHERS THEN
288: RAISE FND_API.G_EXC_ERROR;
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291:
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293:
294: WHEN OTHERS THEN
295:
296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293:
294: WHEN OTHERS THEN
295:
296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297:
298: END Over_Ship_Tol_From_Item ;
299:
300: FUNCTION Over_Ship_Tol_From_Customer
327: WHEN NO_DATA_FOUND THEN
328:
329: return null;
330:
331: WHEN FND_API.G_EXC_ERROR THEN
332:
333: RAISE FND_API.G_EXC_ERROR;
334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329: return null;
330:
331: WHEN FND_API.G_EXC_ERROR THEN
332:
333: RAISE FND_API.G_EXC_ERROR;
334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336:
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: WHEN FND_API.G_EXC_ERROR THEN
332:
333: RAISE FND_API.G_EXC_ERROR;
334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336:
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338:
339: WHEN OTHERS THEN
333: RAISE FND_API.G_EXC_ERROR;
334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336:
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338:
339: WHEN OTHERS THEN
340:
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338:
339: WHEN OTHERS THEN
340:
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342:
343: END Over_Ship_Tol_From_Customer ;
344:
345: FUNCTION Over_Ship_Tol_From_Site
379: WHEN NO_DATA_FOUND THEN
380:
381: return null;
382:
383: WHEN FND_API.G_EXC_ERROR THEN
384:
385: RAISE FND_API.G_EXC_ERROR;
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: return null;
382:
383: WHEN FND_API.G_EXC_ERROR THEN
384:
385: RAISE FND_API.G_EXC_ERROR;
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388:
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: WHEN FND_API.G_EXC_ERROR THEN
384:
385: RAISE FND_API.G_EXC_ERROR;
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388:
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390:
391: WHEN OTHERS THEN
385: RAISE FND_API.G_EXC_ERROR;
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388:
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390:
391: WHEN OTHERS THEN
392:
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390:
391: WHEN OTHERS THEN
392:
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394:
395: END Over_Ship_Tol_From_Site;
396:
397: FUNCTION Over_Ship_Tol_From_Cust_Item
426: WHEN NO_DATA_FOUND THEN
427:
428: return null;
429:
430: WHEN FND_API.G_EXC_ERROR THEN
431:
432: RAISE FND_API.G_EXC_ERROR;
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
428: return null;
429:
430: WHEN FND_API.G_EXC_ERROR THEN
431:
432: RAISE FND_API.G_EXC_ERROR;
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435:
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: WHEN FND_API.G_EXC_ERROR THEN
431:
432: RAISE FND_API.G_EXC_ERROR;
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435:
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437:
438: WHEN OTHERS THEN
432: RAISE FND_API.G_EXC_ERROR;
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435:
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437:
438: WHEN OTHERS THEN
439:
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437:
438: WHEN OTHERS THEN
439:
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441:
442: END Over_Ship_Tol_From_Cust_Item ;
443:
444: FUNCTION Over_Ship_Tol_From_Site_Item
478: WHEN NO_DATA_FOUND THEN
479:
480: return null;
481:
482: WHEN FND_API.G_EXC_ERROR THEN
483:
484: RAISE FND_API.G_EXC_ERROR;
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: return null;
481:
482: WHEN FND_API.G_EXC_ERROR THEN
483:
484: RAISE FND_API.G_EXC_ERROR;
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487:
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: WHEN FND_API.G_EXC_ERROR THEN
483:
484: RAISE FND_API.G_EXC_ERROR;
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487:
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489:
490: WHEN OTHERS THEN
484: RAISE FND_API.G_EXC_ERROR;
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487:
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489:
490: WHEN OTHERS THEN
491:
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489:
490: WHEN OTHERS THEN
491:
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493:
494: END Over_Ship_Tol_From_Site_Item ;
495:
496: END OE_Default_Tolerance;