[Home] [Help]
230: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
231: --
232: IF l_debug_on IS NULL
233: THEN
234: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
235: END IF;
236: --
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.push(l_module_name);
234: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
235: END IF;
236: --
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.push(l_module_name);
239: --
240: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
241: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CODE',P_ORG_CODE);
242: END IF;
236: --
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.push(l_module_name);
239: --
240: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
241: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CODE',P_ORG_CODE);
242: END IF;
243: --
244: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.push(l_module_name);
239: --
240: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
241: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CODE',P_ORG_CODE);
242: END IF;
243: --
244: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
245: l_failed := FALSE;
262: wsh_util_core.add_message(x_return_status,l_module_name);
263: END IF;
264: --
265: IF l_debug_on THEN
266: WSH_DEBUG_SV.log(l_module_name,'p_org_id',p_org_id);
267: WSH_DEBUG_SV.pop(l_module_name);
268: END IF;
269: --
270: EXCEPTION
263: END IF;
264: --
265: IF l_debug_on THEN
266: WSH_DEBUG_SV.log(l_module_name,'p_org_id',p_org_id);
267: WSH_DEBUG_SV.pop(l_module_name);
268: END IF;
269: --
270: EXCEPTION
271: WHEN OTHERS THEN
278: CLOSE check_org_code;
279: END IF;
280: --
281: IF l_debug_on THEN
282: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
284: END IF;
285:
286: END Validate_Org;
279: END IF;
280: --
281: IF l_debug_on THEN
282: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
284: END IF;
285:
286: END Validate_Org;
287:
333: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
334: --
335: IF l_debug_on IS NULL
336: THEN
337: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
338: END IF;
339: --
340: IF l_debug_on THEN
341: WSH_DEBUG_SV.push(l_module_name);
337: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
338: END IF;
339: --
340: IF l_debug_on THEN
341: WSH_DEBUG_SV.push(l_module_name);
342: --
343: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
344: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
345: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
339: --
340: IF l_debug_on THEN
341: WSH_DEBUG_SV.push(l_module_name);
342: --
343: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
344: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
345: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
346: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
347: END IF;
340: IF l_debug_on THEN
341: WSH_DEBUG_SV.push(l_module_name);
342: --
343: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
344: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
345: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
346: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
347: END IF;
348: --
341: WSH_DEBUG_SV.push(l_module_name);
342: --
343: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
344: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
345: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
346: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
347: END IF;
348: --
349: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
342: --
343: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
344: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
345: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
346: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
347: END IF;
348: --
349: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
350: IF p_isWshLocation THEN
358: END IF;
359:
360: IF p_location_id IS NOT NULL THEN
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.log(l_module_name,'Calling Transfer_Location');
363: END IF;
364:
365: WSH_MAP_LOCATION_REGION_PKG.Transfer_Location (
366: p_source_type => l_source_loc_type,
371: x_loc_rec => l_loc_rec,
372: x_return_status => l_return_status);
373:
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
376: END IF;
377:
378: wsh_util_core.api_post_call(
379: p_return_status => l_return_status,
390: RAISE FND_API.G_EXC_ERROR;
391: END IF;
392:
393: IF l_debug_on THEN
394: WSH_DEBUG_SV.log(l_module_name,'inactive_date',
395: l_loc_rec.inactive_date);
396: WSH_DEBUG_SV.log(l_module_name,'l_sysdate',l_sysdate);
397: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
398: WSH_DEBUG_SV.pop(l_module_name);
392:
393: IF l_debug_on THEN
394: WSH_DEBUG_SV.log(l_module_name,'inactive_date',
395: l_loc_rec.inactive_date);
396: WSH_DEBUG_SV.log(l_module_name,'l_sysdate',l_sysdate);
397: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
398: WSH_DEBUG_SV.pop(l_module_name);
399: END IF;
400: RETURN;
393: IF l_debug_on THEN
394: WSH_DEBUG_SV.log(l_module_name,'inactive_date',
395: l_loc_rec.inactive_date);
396: WSH_DEBUG_SV.log(l_module_name,'l_sysdate',l_sysdate);
397: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
398: WSH_DEBUG_SV.pop(l_module_name);
399: END IF;
400: RETURN;
401: ELSIF NVL(p_location_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
394: WSH_DEBUG_SV.log(l_module_name,'inactive_date',
395: l_loc_rec.inactive_date);
396: WSH_DEBUG_SV.log(l_module_name,'l_sysdate',l_sysdate);
397: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
398: WSH_DEBUG_SV.pop(l_module_name);
399: END IF;
400: RETURN;
401: ELSIF NVL(p_location_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
402: AND p_location_id IS NULL
408: WHERE location_code = p_location_code
409: AND TRUNC(l_sysdate)
410: <= NVL(inactive_date ,TRUNC(l_sysdate));
411: IF l_debug_on THEN
412: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
413: END IF;
414: --
415: p_location_id := l_location_id;
416: IF l_debug_on THEN
413: END IF;
414: --
415: p_location_id := l_location_id;
416: IF l_debug_on THEN
417: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
418: WSH_DEBUG_SV.pop(l_module_name);
419: END IF;
420: RETURN;
421:
414: --
415: p_location_id := l_location_id;
416: IF l_debug_on THEN
417: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
418: WSH_DEBUG_SV.pop(l_module_name);
419: END IF;
420: RETURN;
421:
422: EXCEPTION
426: OPEN check_location;
427: FETCH check_location
428: INTO l_location_id;
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.log(l_module_name,'cursor l_location_id',
431: l_location_id);
432: END IF;
433: IF check_location%NOTFOUND THEN
434: RAISE FND_API.G_EXC_ERROR;
436: FETCH check_location
437: INTO l_location_id2;
438: IF l_location_id2 IS NOT NULL THEN
439: IF l_debug_on THEN
440: WSH_DEBUG_SV.log(l_module_name,'Too Many ROws',
441: l_location_id2);
442: END IF;
443: RAISE FND_API.G_EXC_ERROR;
444: END IF;
445: END IF;
446: END;
447:
448: IF l_debug_on THEN
449: WSH_DEBUG_SV.log(l_module_name,'Calling Transfer_Location');
450: END IF;
451:
452: WSH_MAP_LOCATION_REGION_PKG.Transfer_Location (
453: p_source_type => 'HR',
457: p_online_region_mapping => FALSE,
458: x_loc_rec => l_loc_rec,
459: x_return_status => l_return_status);
460: IF l_debug_on THEN
461: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
462: END IF;
463:
464: wsh_util_core.api_post_call(
465: p_return_status => l_return_status,
472: p_location_id := l_loc_rec.wsh_location_id;
473:
474: ELSE
475: IF l_debug_on THEN
476: WSH_DEBUG_SV.log(l_module_name,'Both parameters are null');
477: END IF;
478: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
479: --bug 2648157
480: END IF;
480: END IF;
481:
482: --
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
485: WSH_DEBUG_SV.pop(l_module_name);
486: END IF;
487: --
488: EXCEPTION
481:
482: --
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
485: WSH_DEBUG_SV.pop(l_module_name);
486: END IF;
487: --
488: EXCEPTION
489:
491: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
493: wsh_util_core.add_message(x_return_status,l_module_name);
494: IF l_debug_on THEN
495: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_ERROR');
496: END IF;
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
499: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
498: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
499: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
500: wsh_util_core.add_message(x_return_status,l_module_name);
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_UNEXPECTED_ERROR');
503: END IF;
504: WHEN OTHERS THEN
505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
506: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOCATION');
505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
506: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOCATION');
507: --
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
510: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
511: END IF;
512:
513: END Validate_Location;
506: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOCATION');
507: --
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
510: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
511: END IF;
512:
513: END Validate_Location;
514:
560: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
561: --
562: IF l_debug_on IS NULL
563: THEN
564: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
565: END IF;
566: --
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.push(l_module_name);
564: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
565: END IF;
566: --
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.push(l_module_name);
569: --
570: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
571: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
572: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
566: --
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.push(l_module_name);
569: --
570: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
571: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
572: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
573: END IF;
574: --
567: IF l_debug_on THEN
568: WSH_DEBUG_SV.push(l_module_name);
569: --
570: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
571: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
572: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
573: END IF;
574: --
575: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
568: WSH_DEBUG_SV.push(l_module_name);
569: --
570: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
571: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
572: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
573: END IF;
574: --
575: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
576:
632:
633: END IF;
634: --
635: IF l_debug_on THEN
636: WSH_DEBUG_SV.log(l_module_name,'p_lookup_code',p_lookup_code);
637: WSH_DEBUG_SV.pop(l_module_name);
638: END IF;
639: --
640: END Validate_Lookup;
633: END IF;
634: --
635: IF l_debug_on THEN
636: WSH_DEBUG_SV.log(l_module_name,'p_lookup_code',p_lookup_code);
637: WSH_DEBUG_SV.pop(l_module_name);
638: END IF;
639: --
640: END Validate_Lookup;
641:
678: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
679: --
680: IF l_debug_on IS NULL
681: THEN
682: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
683: END IF;
684: --
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.push(l_module_name);
682: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
683: END IF;
684: --
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.push(l_module_name);
687: --
688: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
689: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_NUMBER',P_CUSTOMER_NUMBER);
690: END IF;
684: --
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.push(l_module_name);
687: --
688: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
689: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_NUMBER',P_CUSTOMER_NUMBER);
690: END IF;
691: --
692: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.push(l_module_name);
687: --
688: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
689: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_NUMBER',P_CUSTOMER_NUMBER);
690: END IF;
691: --
692: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
693:
710:
711: END IF;
712: --
713: IF l_debug_on THEN
714: WSH_DEBUG_SV.log(l_module_name,'p_customer_id',p_customer_id);
715: WSH_DEBUG_SV.pop(l_module_name);
716: END IF;
717: --
718: END Validate_Customer;
711: END IF;
712: --
713: IF l_debug_on THEN
714: WSH_DEBUG_SV.log(l_module_name,'p_customer_id',p_customer_id);
715: WSH_DEBUG_SV.pop(l_module_name);
716: END IF;
717: --
718: END Validate_Customer;
719:
746: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
747: --
748: IF l_debug_on IS NULL
749: THEN
750: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
751: END IF;
752: --
753: IF l_debug_on THEN
754: WSH_DEBUG_SV.push(l_module_name);
750: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
751: END IF;
752: --
753: IF l_debug_on THEN
754: WSH_DEBUG_SV.push(l_module_name);
755: --
756: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
757: END IF;
758: --
752: --
753: IF l_debug_on THEN
754: WSH_DEBUG_SV.push(l_module_name);
755: --
756: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
757: END IF;
758: --
759: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
760:
775:
776: END IF;
777: --
778: IF l_debug_on THEN
779: WSH_DEBUG_SV.log(l_module_name,'p_contact_id',p_contact_id);
780: WSH_DEBUG_SV.pop(l_module_name);
781: END IF;
782: --
783: END Validate_Contact;
776: END IF;
777: --
778: IF l_debug_on THEN
779: WSH_DEBUG_SV.log(l_module_name,'p_contact_id',p_contact_id);
780: WSH_DEBUG_SV.pop(l_module_name);
781: END IF;
782: --
783: END Validate_Contact;
784:
805: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
806: --
807: IF l_debug_on IS NULL
808: THEN
809: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
810: END IF;
811: --
812: IF l_debug_on THEN
813: WSH_DEBUG_SV.push(l_module_name);
809: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
810: END IF;
811: --
812: IF l_debug_on THEN
813: WSH_DEBUG_SV.push(l_module_name);
814: --
815: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
816: END IF;
817: --
811: --
812: IF l_debug_on THEN
813: WSH_DEBUG_SV.push(l_module_name);
814: --
815: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
816: END IF;
817: --
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
819:
830:
831: END IF;
832: --
833: IF l_debug_on THEN
834: WSH_DEBUG_SV.pop(l_module_name);
835: END IF;
836: --
837: END Validate_Quantity;
838:
858: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
859: --
860: IF l_debug_on IS NULL
861: THEN
862: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
863: END IF;
864: --
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.push(l_module_name);
862: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
863: END IF;
864: --
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.push(l_module_name);
867: --
868: WSH_DEBUG_SV.log(l_module_name,'P_VALUE',P_VALUE);
869: END IF;
870: --
864: --
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.push(l_module_name);
867: --
868: WSH_DEBUG_SV.log(l_module_name,'P_VALUE',P_VALUE);
869: END IF;
870: --
871: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
872:
882:
883: END IF;
884: --
885: IF l_debug_on THEN
886: WSH_DEBUG_SV.pop(l_module_name);
887: END IF;
888: --
889: END Validate_Negative;
890: */
913: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
914: --
915: IF l_debug_on IS NULL
916: THEN
917: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
918: END IF;
919: --
920: IF l_debug_on THEN
921: WSH_DEBUG_SV.push(l_module_name);
917: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
918: END IF;
919: --
920: IF l_debug_on THEN
921: WSH_DEBUG_SV.push(l_module_name);
922: --
923: WSH_DEBUG_SV.log(l_module_name,'P_VALUE',P_VALUE);
924: END IF;
925: --
919: --
920: IF l_debug_on THEN
921: WSH_DEBUG_SV.push(l_module_name);
922: --
923: WSH_DEBUG_SV.log(l_module_name,'P_VALUE',P_VALUE);
924: END IF;
925: --
926: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
927:
938:
939: END IF;
940: --
941: IF l_debug_on THEN
942: WSH_DEBUG_SV.pop(l_module_name);
943: END IF;
944: --
945: END Validate_Negative;
946:
995: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
996: --
997: IF l_debug_on IS NULL
998: THEN
999: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1000: END IF;
1001: --
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.push(l_module_name);
999: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1000: END IF;
1001: --
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.push(l_module_name);
1004: --
1005: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
1006: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
1007: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
1001: --
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.push(l_module_name);
1004: --
1005: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
1006: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
1007: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
1008: WSH_DEBUG_SV.log(l_module_name,'P_OTM_ENABLED',P_OTM_ENABLED); -- OTM R12
1009: END IF;
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.push(l_module_name);
1004: --
1005: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
1006: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
1007: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
1008: WSH_DEBUG_SV.log(l_module_name,'P_OTM_ENABLED',P_OTM_ENABLED); -- OTM R12
1009: END IF;
1010: --
1003: WSH_DEBUG_SV.push(l_module_name);
1004: --
1005: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
1006: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
1007: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
1008: WSH_DEBUG_SV.log(l_module_name,'P_OTM_ENABLED',P_OTM_ENABLED); -- OTM R12
1009: END IF;
1010: --
1011: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1004: --
1005: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
1006: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
1007: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
1008: WSH_DEBUG_SV.log(l_module_name,'P_OTM_ENABLED',P_OTM_ENABLED); -- OTM R12
1009: END IF;
1010: --
1011: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1012:
1037:
1038: CLOSE currency_cursor;
1039:
1040: IF l_debug_on THEN
1041: WSH_DEBUG_SV.log(l_module_name,'l_in_precision',l_in_precision);
1042: WSH_DEBUG_SV.log(l_module_name,'l_precision',l_precision);
1043: END IF;
1044:
1045: x_adjusted_amount := p_amount;
1038: CLOSE currency_cursor;
1039:
1040: IF l_debug_on THEN
1041: WSH_DEBUG_SV.log(l_module_name,'l_in_precision',l_in_precision);
1042: WSH_DEBUG_SV.log(l_module_name,'l_precision',l_precision);
1043: END IF;
1044:
1045: x_adjusted_amount := p_amount;
1046:
1050: IF p_otm_enabled = 'Y' THEN
1051: -- truncate the amount to the precision specified in setup
1052: x_adjusted_amount := ROUND(p_amount,l_precision);
1053: IF l_debug_on THEN
1054: WSH_DEBUG_SV.log(l_module_name,'Adjusted amount:',x_adjusted_amount);
1055: END IF;
1056: ELSE
1057: -- existing code
1058: error_code := 'CURR-Precision';
1069: END IF;
1070: --
1071: IF l_debug_on THEN
1072: -- OTM R12
1073: WSH_DEBUG_SV.log(l_module_name,'x_adjusted_amount ',x_adjusted_amount);
1074: WSH_DEBUG_SV.pop(l_module_name);
1075: END IF;
1076: --
1077: EXCEPTION
1070: --
1071: IF l_debug_on THEN
1072: -- OTM R12
1073: WSH_DEBUG_SV.log(l_module_name,'x_adjusted_amount ',x_adjusted_amount);
1074: WSH_DEBUG_SV.pop(l_module_name);
1075: END IF;
1076: --
1077: EXCEPTION
1078: -- OTM R12
1079: WHEN l_invalid_currency THEN
1080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1081: WSH_UTIL_CORE.add_message(x_return_status,l_module_name);
1082: IF l_debug_on THEN
1083: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid or NULL currency exception ');
1084: WSH_DEBUG_SV.pop(l_module_name);
1085: END IF;
1086: WHEN OTHERS THEN
1087: IF currency_cursor%ISOPEN THEN
1080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1081: WSH_UTIL_CORE.add_message(x_return_status,l_module_name);
1082: IF l_debug_on THEN
1083: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid or NULL currency exception ');
1084: WSH_DEBUG_SV.pop(l_module_name);
1085: END IF;
1086: WHEN OTHERS THEN
1087: IF currency_cursor%ISOPEN THEN
1088: CLOSE currency_cursor;
1089: END IF;
1090: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1091: WSH_UTIL_CORE.default_handler('WSH_UTIL_VALIDATE.Validate_Currency');
1092: IF l_debug_on THEN
1093: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1095: END IF;
1096:
1097: END Validate_Currency;
1090: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1091: WSH_UTIL_CORE.default_handler('WSH_UTIL_VALIDATE.Validate_Currency');
1092: IF l_debug_on THEN
1093: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1095: END IF;
1096:
1097: END Validate_Currency;
1098:
1159: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1160: --
1161: IF l_debug_on IS NULL
1162: THEN
1163: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1164: END IF;
1165: --
1166: IF l_debug_on THEN
1167: WSH_DEBUG_SV.push(l_module_name);
1163: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1164: END IF;
1165: --
1166: IF l_debug_on THEN
1167: WSH_DEBUG_SV.push(l_module_name);
1168: --
1169: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1170: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1171: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1165: --
1166: IF l_debug_on THEN
1167: WSH_DEBUG_SV.push(l_module_name);
1168: --
1169: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1170: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1171: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1172: WSH_DEBUG_SV.log(l_module_name,'P_UOM_DESC',P_UOM_DESC);
1173: END IF;
1166: IF l_debug_on THEN
1167: WSH_DEBUG_SV.push(l_module_name);
1168: --
1169: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1170: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1171: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1172: WSH_DEBUG_SV.log(l_module_name,'P_UOM_DESC',P_UOM_DESC);
1173: END IF;
1174: --
1167: WSH_DEBUG_SV.push(l_module_name);
1168: --
1169: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1170: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1171: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1172: WSH_DEBUG_SV.log(l_module_name,'P_UOM_DESC',P_UOM_DESC);
1173: END IF;
1174: --
1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1168: --
1169: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1170: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1171: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1172: WSH_DEBUG_SV.log(l_module_name,'P_UOM_DESC',P_UOM_DESC);
1173: END IF;
1174: --
1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1176:
1277: ELSE
1278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1279: --
1280: IF l_debug_on THEN
1281: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
1282: END IF;
1283: --
1284: RETURN;
1285: END IF;
1286: -- End of Bug 3821688 for 2nd Cursor
1287: END IF;
1288: --
1289: IF l_debug_on THEN
1290: WSH_DEBUG_SV.log(l_module_name,'p_uom_code',p_uom_code);
1291: WSH_DEBUG_SV.pop(l_module_name);
1292: END IF;
1293: --
1294: END Validate_Uom;
1287: END IF;
1288: --
1289: IF l_debug_on THEN
1290: WSH_DEBUG_SV.log(l_module_name,'p_uom_code',p_uom_code);
1291: WSH_DEBUG_SV.pop(l_module_name);
1292: END IF;
1293: --
1294: END Validate_Uom;
1295:
1331: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1332: --
1333: IF l_debug_on IS NULL
1334: THEN
1335: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1336: END IF;
1337: --
1338: IF l_debug_on THEN
1339: WSH_DEBUG_SV.push(l_module_name);
1335: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1336: END IF;
1337: --
1338: IF l_debug_on THEN
1339: WSH_DEBUG_SV.push(l_module_name);
1340: --
1341: WSH_DEBUG_SV.log(l_module_name,'P_USER_ID',P_USER_ID);
1342: WSH_DEBUG_SV.log(l_module_name,'P_USER_NAME',P_USER_NAME);
1343: END IF;
1337: --
1338: IF l_debug_on THEN
1339: WSH_DEBUG_SV.push(l_module_name);
1340: --
1341: WSH_DEBUG_SV.log(l_module_name,'P_USER_ID',P_USER_ID);
1342: WSH_DEBUG_SV.log(l_module_name,'P_USER_NAME',P_USER_NAME);
1343: END IF;
1344: --
1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1338: IF l_debug_on THEN
1339: WSH_DEBUG_SV.push(l_module_name);
1340: --
1341: WSH_DEBUG_SV.log(l_module_name,'P_USER_ID',P_USER_ID);
1342: WSH_DEBUG_SV.log(l_module_name,'P_USER_NAME',P_USER_NAME);
1343: END IF;
1344: --
1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1346:
1361:
1362: END IF;
1363: --
1364: IF l_debug_on THEN
1365: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
1366: WSH_DEBUG_SV.pop(l_module_name);
1367: END IF;
1368: --
1369: END Validate_User;
1362: END IF;
1363: --
1364: IF l_debug_on THEN
1365: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
1366: WSH_DEBUG_SV.pop(l_module_name);
1367: END IF;
1368: --
1369: END Validate_User;
1370:
1412: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1413: --
1414: IF l_debug_on IS NULL
1415: THEN
1416: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1417: END IF;
1418: --
1419: IF l_debug_on THEN
1420: WSH_DEBUG_SV.push(l_module_name);
1416: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1417: END IF;
1418: --
1419: IF l_debug_on THEN
1420: WSH_DEBUG_SV.push(l_module_name);
1421: --
1422: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
1423: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
1424: END IF;
1418: --
1419: IF l_debug_on THEN
1420: WSH_DEBUG_SV.push(l_module_name);
1421: --
1422: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
1423: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
1424: END IF;
1425: --
1426: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1419: IF l_debug_on THEN
1420: WSH_DEBUG_SV.push(l_module_name);
1421: --
1422: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
1423: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
1424: END IF;
1425: --
1426: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1427: --
1489: --
1490: END IF;
1491: --
1492: IF l_debug_on THEN
1493: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
1494: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
1495: WSH_DEBUG_SV.pop(l_module_name);
1496: END IF;
1497: --
1490: END IF;
1491: --
1492: IF l_debug_on THEN
1493: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
1494: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
1495: WSH_DEBUG_SV.pop(l_module_name);
1496: END IF;
1497: --
1498: EXCEPTION
1491: --
1492: IF l_debug_on THEN
1493: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
1494: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
1495: WSH_DEBUG_SV.pop(l_module_name);
1496: END IF;
1497: --
1498: EXCEPTION
1499: WHEN OTHERS THEN
1499: WHEN OTHERS THEN
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1501: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1504: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1505: END IF;
1506: END Validate_Ship_Method;
1507:
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1501: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1504: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1505: END IF;
1506: END Validate_Ship_Method;
1507:
1508: --========================================================================
1528: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1529: --
1530: IF l_debug_on IS NULL
1531: THEN
1532: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1533: END IF;
1534: --
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.push(l_module_name);
1532: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1533: END IF;
1534: --
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.push(l_module_name);
1537: --
1538: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
1539: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_NAME',P_FREIGHT_TERMS_NAME);
1540: END IF;
1534: --
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.push(l_module_name);
1537: --
1538: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
1539: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_NAME',P_FREIGHT_TERMS_NAME);
1540: END IF;
1541: --
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.push(l_module_name);
1537: --
1538: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
1539: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_NAME',P_FREIGHT_TERMS_NAME);
1540: END IF;
1541: --
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1543:
1561:
1562: END IF;
1563: --
1564: IF l_debug_on THEN
1565: WSH_DEBUG_SV.pop(l_module_name);
1566: END IF;
1567: --
1568: END Validate_Freight_Terms;
1569:
1589: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1590: --
1591: IF l_debug_on IS NULL
1592: THEN
1593: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1594: END IF;
1595: --
1596: IF l_debug_on THEN
1597: WSH_DEBUG_SV.push(l_module_name);
1593: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1594: END IF;
1595: --
1596: IF l_debug_on THEN
1597: WSH_DEBUG_SV.push(l_module_name);
1598: --
1599: WSH_DEBUG_SV.log(l_module_name,'P_FOB_CODE',P_FOB_CODE);
1600: WSH_DEBUG_SV.log(l_module_name,'P_FOB_NAME',P_FOB_NAME);
1601: END IF;
1595: --
1596: IF l_debug_on THEN
1597: WSH_DEBUG_SV.push(l_module_name);
1598: --
1599: WSH_DEBUG_SV.log(l_module_name,'P_FOB_CODE',P_FOB_CODE);
1600: WSH_DEBUG_SV.log(l_module_name,'P_FOB_NAME',P_FOB_NAME);
1601: END IF;
1602: --
1603: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1596: IF l_debug_on THEN
1597: WSH_DEBUG_SV.push(l_module_name);
1598: --
1599: WSH_DEBUG_SV.log(l_module_name,'P_FOB_CODE',P_FOB_CODE);
1600: WSH_DEBUG_SV.log(l_module_name,'P_FOB_NAME',P_FOB_NAME);
1601: END IF;
1602: --
1603: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1604:
1620:
1621: END IF;
1622: --
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.pop(l_module_name);
1625: END IF;
1626: --
1627: END Validate_FOB;
1628:
1690: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1691: --
1692: IF l_debug_on IS NULL
1693: THEN
1694: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1695: END IF;
1696: --
1697: IF l_debug_on THEN
1698: WSH_DEBUG_SV.push(l_module_name);
1694: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1695: END IF;
1696: --
1697: IF l_debug_on THEN
1698: WSH_DEBUG_SV.push(l_module_name);
1699: --
1700: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1701: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1702: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1696: --
1697: IF l_debug_on THEN
1698: WSH_DEBUG_SV.push(l_module_name);
1699: --
1700: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1701: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1702: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1703: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1704: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1697: IF l_debug_on THEN
1698: WSH_DEBUG_SV.push(l_module_name);
1699: --
1700: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1701: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1702: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1703: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1704: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1705: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1698: WSH_DEBUG_SV.push(l_module_name);
1699: --
1700: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1701: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1702: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1703: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1704: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1705: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1706: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1699: --
1700: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1701: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1702: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1703: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1704: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1705: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1706: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1707: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1700: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1701: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1702: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1703: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1704: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1705: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1706: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1707: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1708: END IF;
1701: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1702: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1703: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1704: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1705: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1706: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1707: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1708: END IF;
1709: --
1702: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1703: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1704: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1705: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1706: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1707: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1708: END IF;
1709: --
1710: --IF p_id IS NOT NULL THEN
1703: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1704: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1705: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1706: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1707: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1708: END IF;
1709: --
1710: --IF p_id IS NOT NULL THEN
1711: IF NVL(p_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1718: data_set => p_org_id);
1719:
1720: p_id := fnd_flex_keyval.combination_id;
1721: IF l_debug_on THEN
1722: WSH_DEBUG_SV.log(l_module_name,'x_flag',x_flag);
1723: WSH_DEBUG_SV.log(l_module_name,'p_id',p_id);
1724: END IF;
1725: ELSIF p_id IS NULL OR p_id = FND_API.G_MISS_NUM THEN
1726: If l_debug_on THEN
1719:
1720: p_id := fnd_flex_keyval.combination_id;
1721: IF l_debug_on THEN
1722: WSH_DEBUG_SV.log(l_module_name,'x_flag',x_flag);
1723: WSH_DEBUG_SV.log(l_module_name,'p_id',p_id);
1724: END IF;
1725: ELSIF p_id IS NULL OR p_id = FND_API.G_MISS_NUM THEN
1726: If l_debug_on THEN
1727: wsh_debug_sv.logmsg(l_module_name, 'Calling set session mode');
1723: WSH_DEBUG_SV.log(l_module_name,'p_id',p_id);
1724: END IF;
1725: ELSIF p_id IS NULL OR p_id = FND_API.G_MISS_NUM THEN
1726: If l_debug_on THEN
1727: wsh_debug_sv.logmsg(l_module_name, 'Calling set session mode');
1728: END IF;
1729:
1730: fnd_flex_key_api.set_session_mode(session_mode =>'seed_data');
1731:
1729:
1730: fnd_flex_key_api.set_session_mode(session_mode =>'seed_data');
1731:
1732: If l_debug_on THEN
1733: wsh_debug_sv.logmsg(l_module_name, 'Calling find flexfield');
1734: END IF;
1735:
1736:
1737: ffield := fnd_flex_key_api.find_flexfield(p_app_short_name, p_key_flx_code);
1743: key_flex_code => p_key_flx_code,
1744: structure_number => p_struct_number);
1745:
1746: If l_debug_on THEN
1747: wsh_debug_sv.log(l_module_name, 'delimiter', delimiter);
1748: wsh_debug_sv.log(l_module_name, 'nsegs', nsegs);
1749: END IF;
1750:
1751: IF (delimiter IS NOT NULL) THEN
1744: structure_number => p_struct_number);
1745:
1746: If l_debug_on THEN
1747: wsh_debug_sv.log(l_module_name, 'delimiter', delimiter);
1748: wsh_debug_sv.log(l_module_name, 'nsegs', nsegs);
1749: END IF;
1750:
1751: IF (delimiter IS NOT NULL) THEN
1752: concat_string := '';
1754: FOR i IN 1..nsegs LOOP
1755: fsegment := fnd_flex_key_api.find_segment(ffield, fstruct, slist(i));
1756: charcol := fsegment.column_name;
1757: if l_debug_on then
1758: wsh_debug_sv.log(l_module_name, 'charcol', charcol);
1759: end if;
1760: charcol := substr(charcol, 8, length(fsegment.column_name));
1761: numbcol := to_number(charcol);
1762: if l_debug_on then
1759: end if;
1760: charcol := substr(charcol, 8, length(fsegment.column_name));
1761: numbcol := to_number(charcol);
1762: if l_debug_on then
1763: wsh_debug_sv.log(l_module_name, 'numcol', numbcol);
1764: end if;
1765: concat_string := concat_string||p_seg_array(numbcol);
1766: END LOOP;
1767:
1765: concat_string := concat_string||p_seg_array(numbcol);
1766: END LOOP;
1767:
1768: If l_debug_on THEN
1769: wsh_debug_sv.logmsg(l_module_name, 'Calling validate_segs');
1770: END IF;
1771:
1772: x_flag := fnd_flex_keyval.validate_segs(
1773: operation =>'CHECK_COMBINATION',
1779: values_or_ids => p_val_or_ids,
1780: where_clause => p_wh_clause );
1781:
1782: If l_debug_on THEN
1783: wsh_debug_sv.log(l_module_name, 'x_flag', x_flag);
1784: END IF;
1785:
1786: p_id := fnd_flex_keyval.combination_id;
1787:
1805:
1806: END IF; -- id is null
1807: --
1808: IF l_debug_on THEN
1809: WSH_DEBUG_SV.pop(l_module_name);
1810: END IF;
1811: --
1812: EXCEPTION
1813: WHEN delimiter_null THEN
1814: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_DELIMITER_NULL');
1815: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1816: --
1817: IF l_debug_on THEN
1818: WSH_DEBUG_SV.logmsg(l_module_name,'DELIMITER_NULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIMITER_NULL');
1820: END IF;
1821: --
1822: WHEN wrong_combination THEN
1815: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1816: --
1817: IF l_debug_on THEN
1818: WSH_DEBUG_SV.logmsg(l_module_name,'DELIMITER_NULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIMITER_NULL');
1820: END IF;
1821: --
1822: WHEN wrong_combination THEN
1823: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_INV_COMB_ERROR');
1823: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_INV_COMB_ERROR');
1824: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1825: --
1826: IF l_debug_on THEN
1827: WSH_DEBUG_SV.logmsg(l_module_name,'WRONG_COMBINATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1828: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_COMBINATION');
1829: END IF;
1830: --
1831: WHEN others THEN
1824: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1825: --
1826: IF l_debug_on THEN
1827: WSH_DEBUG_SV.logmsg(l_module_name,'WRONG_COMBINATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1828: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_COMBINATION');
1829: END IF;
1830: --
1831: WHEN others THEN
1832: IF l_debug_on THEN
1829: END IF;
1830: --
1831: WHEN others THEN
1832: IF l_debug_on THEN
1833: WSH_DEBUG_SV.log(l_module_name, 'Exception:', fnd_flex_key_api.message);
1834: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1836: END IF;
1837: END Validate_Flexfields;
1830: --
1831: WHEN others THEN
1832: IF l_debug_on THEN
1833: WSH_DEBUG_SV.log(l_module_name, 'Exception:', fnd_flex_key_api.message);
1834: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1836: END IF;
1837: END Validate_Flexfields;
1838:
1831: WHEN others THEN
1832: IF l_debug_on THEN
1833: WSH_DEBUG_SV.log(l_module_name, 'Exception:', fnd_flex_key_api.message);
1834: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1836: END IF;
1837: END Validate_Flexfields;
1838:
1839: --========================================================================
1869: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1870: --
1871: IF l_debug_on IS NULL
1872: THEN
1873: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1874: END IF;
1875: --
1876: IF l_debug_on THEN
1877: WSH_DEBUG_SV.push(l_module_name);
1873: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1874: END IF;
1875: --
1876: IF l_debug_on THEN
1877: WSH_DEBUG_SV.push(l_module_name);
1878: --
1879: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1880: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
1881: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1875: --
1876: IF l_debug_on THEN
1877: WSH_DEBUG_SV.push(l_module_name);
1878: --
1879: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1880: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
1881: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1882: END IF;
1883: --
1876: IF l_debug_on THEN
1877: WSH_DEBUG_SV.push(l_module_name);
1878: --
1879: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1880: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
1881: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1882: END IF;
1883: --
1884: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1877: WSH_DEBUG_SV.push(l_module_name);
1878: --
1879: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1880: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
1881: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1882: END IF;
1883: --
1884: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1885:
1888: AND p_seg_array.count = 0
1889: THEN
1890:
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.pop(l_module_name);
1893: END IF;
1894: RETURN;
1895: END IF;
1896: --
1910: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');
1911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1912: wsh_util_core.add_message(x_return_status,l_module_name);
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.pop(l_module_name);
1915: END IF;
1916: RETURN;
1917:
1918: END IF;
1932: END IF;
1933: END IF;
1934: -- harmonization project end KVENKATE
1935: IF l_debug_on THEN
1936: WSH_DEBUG_SV.pop(l_module_name);
1937: END IF;
1938: --
1939: END Validate_Item;
1940:
1954: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1955: --
1956: IF l_debug_on IS NULL
1957: THEN
1958: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1959: END IF;
1960: --
1961: IF l_debug_on THEN
1962: WSH_DEBUG_SV.push(l_module_name);
1958: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1959: END IF;
1960: --
1961: IF l_debug_on THEN
1962: WSH_DEBUG_SV.push(l_module_name);
1963: --
1964: WSH_DEBUG_SV.log(l_module_name,'P_FLAG',P_FLAG);
1965: END IF;
1966: --
1960: --
1961: IF l_debug_on THEN
1962: WSH_DEBUG_SV.push(l_module_name);
1963: --
1964: WSH_DEBUG_SV.log(l_module_name,'P_FLAG',P_FLAG);
1965: END IF;
1966: --
1967: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1968:
1970: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1971: END IF;
1972: --
1973: IF l_debug_on THEN
1974: WSH_DEBUG_SV.pop(l_module_name);
1975: END IF;
1976: --
1977: END;
1978:
1991: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1992: --
1993: IF l_debug_on IS NULL
1994: THEN
1995: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1996: END IF;
1997: --
1998: IF l_debug_on THEN
1999: WSH_DEBUG_SV.push(l_module_name);
1995: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1996: END IF;
1997: --
1998: IF l_debug_on THEN
1999: WSH_DEBUG_SV.push(l_module_name);
2000: --
2001: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
2002: END IF;
2003: --
1997: --
1998: IF l_debug_on THEN
1999: WSH_DEBUG_SV.push(l_module_name);
2000: --
2001: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
2002: END IF;
2003: --
2004: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2005:
2007: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2008: END IF;
2009: --
2010: IF l_debug_on THEN
2011: WSH_DEBUG_SV.pop(l_module_name);
2012: END IF;
2013: --
2014: END;
2015:
2043: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2044: --
2045: IF l_debug_on IS NULL
2046: THEN
2047: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2048: END IF;
2049: --
2050: IF l_debug_on THEN
2051: WSH_DEBUG_SV.push(l_module_name);
2047: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2048: END IF;
2049: --
2050: IF l_debug_on THEN
2051: WSH_DEBUG_SV.push(l_module_name);
2052: --
2053: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2054: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2055: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2049: --
2050: IF l_debug_on THEN
2051: WSH_DEBUG_SV.push(l_module_name);
2052: --
2053: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2054: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2055: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2056: WSH_DEBUG_SV.log(l_module_name,'X_UOM_CODE',X_UOM_CODE);
2057: END IF;
2050: IF l_debug_on THEN
2051: WSH_DEBUG_SV.push(l_module_name);
2052: --
2053: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2054: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2055: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2056: WSH_DEBUG_SV.log(l_module_name,'X_UOM_CODE',X_UOM_CODE);
2057: END IF;
2058: --
2051: WSH_DEBUG_SV.push(l_module_name);
2052: --
2053: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2054: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2055: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2056: WSH_DEBUG_SV.log(l_module_name,'X_UOM_CODE',X_UOM_CODE);
2057: END IF;
2058: --
2059: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2052: --
2053: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2054: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2055: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2056: WSH_DEBUG_SV.log(l_module_name,'X_UOM_CODE',X_UOM_CODE);
2057: END IF;
2058: --
2059: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2060:
2074:
2075: END IF;
2076: --
2077: IF l_debug_on THEN
2078: WSH_DEBUG_SV.log(l_module_name,'x_uom_code',x_uom_code);
2079: WSH_DEBUG_SV.pop(l_module_name);
2080: END IF;
2081: --
2082: END;
2075: END IF;
2076: --
2077: IF l_debug_on THEN
2078: WSH_DEBUG_SV.log(l_module_name,'x_uom_code',x_uom_code);
2079: WSH_DEBUG_SV.pop(l_module_name);
2080: END IF;
2081: --
2082: END;
2083:
2120: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2121: --
2122: IF l_debug_on IS NULL
2123: THEN
2124: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2125: END IF;
2126: --
2127: IF l_debug_on THEN
2128: WSH_DEBUG_SV.push(l_module_name);
2124: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2125: END IF;
2126: --
2127: IF l_debug_on THEN
2128: WSH_DEBUG_SV.push(l_module_name);
2129: --
2130: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2131: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2132: END IF;
2126: --
2127: IF l_debug_on THEN
2128: WSH_DEBUG_SV.push(l_module_name);
2129: --
2130: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2131: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2132: END IF;
2133: --
2134: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2127: IF l_debug_on THEN
2128: WSH_DEBUG_SV.push(l_module_name);
2129: --
2130: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2131: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2132: END IF;
2133: --
2134: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2135:
2150:
2151: END IF;
2152: --
2153: IF l_debug_on THEN
2154: WSH_DEBUG_SV.log(l_module_name,'p_delivery_name',p_delivery_name);
2155: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2156: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2157: WSH_DEBUG_SV.pop(l_module_name);
2158: END IF;
2151: END IF;
2152: --
2153: IF l_debug_on THEN
2154: WSH_DEBUG_SV.log(l_module_name,'p_delivery_name',p_delivery_name);
2155: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2156: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2157: WSH_DEBUG_SV.pop(l_module_name);
2158: END IF;
2159: --
2152: --
2153: IF l_debug_on THEN
2154: WSH_DEBUG_SV.log(l_module_name,'p_delivery_name',p_delivery_name);
2155: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2156: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2157: WSH_DEBUG_SV.pop(l_module_name);
2158: END IF;
2159: --
2160: END Validate_Delivery_Name;
2153: IF l_debug_on THEN
2154: WSH_DEBUG_SV.log(l_module_name,'p_delivery_name',p_delivery_name);
2155: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2156: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2157: WSH_DEBUG_SV.pop(l_module_name);
2158: END IF;
2159: --
2160: END Validate_Delivery_Name;
2161:
2199: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2200: --
2201: IF l_debug_on IS NULL
2202: THEN
2203: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2204: END IF;
2205: --
2206: IF l_debug_on THEN
2207: WSH_DEBUG_SV.push(l_module_name);
2203: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2204: END IF;
2205: --
2206: IF l_debug_on THEN
2207: WSH_DEBUG_SV.push(l_module_name);
2208: --
2209: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
2210: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_NAME',P_REPORT_SET_NAME);
2211: END IF;
2205: --
2206: IF l_debug_on THEN
2207: WSH_DEBUG_SV.push(l_module_name);
2208: --
2209: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
2210: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_NAME',P_REPORT_SET_NAME);
2211: END IF;
2212: --
2213: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2206: IF l_debug_on THEN
2207: WSH_DEBUG_SV.push(l_module_name);
2208: --
2209: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
2210: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_NAME',P_REPORT_SET_NAME);
2211: END IF;
2212: --
2213: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2214:
2229:
2230: END IF;
2231: --
2232: IF l_debug_on THEN
2233: WSH_DEBUG_SV.log(l_module_name,'p_report_set_id',p_report_set_id);
2234: WSH_DEBUG_SV.pop(l_module_name);
2235: END IF;
2236: --
2237: END Validate_Report_Set;
2230: END IF;
2231: --
2232: IF l_debug_on THEN
2233: WSH_DEBUG_SV.log(l_module_name,'p_report_set_id',p_report_set_id);
2234: WSH_DEBUG_SV.pop(l_module_name);
2235: END IF;
2236: --
2237: END Validate_Report_Set;
2238:
2260: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2261: --
2262: IF l_debug_on IS NULL
2263: THEN
2264: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2265: END IF;
2266: --
2267: IF l_debug_on THEN
2268: WSH_DEBUG_SV.push(l_module_name);
2264: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2265: END IF;
2266: --
2267: IF l_debug_on THEN
2268: WSH_DEBUG_SV.push(l_module_name);
2269: --
2270: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_FLAG',P_LOADING_ORDER_FLAG);
2271: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_DESC',P_LOADING_ORDER_DESC);
2272: END IF;
2266: --
2267: IF l_debug_on THEN
2268: WSH_DEBUG_SV.push(l_module_name);
2269: --
2270: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_FLAG',P_LOADING_ORDER_FLAG);
2271: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_DESC',P_LOADING_ORDER_DESC);
2272: END IF;
2273: --
2274: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2267: IF l_debug_on THEN
2268: WSH_DEBUG_SV.push(l_module_name);
2269: --
2270: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_FLAG',P_LOADING_ORDER_FLAG);
2271: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_DESC',P_LOADING_ORDER_DESC);
2272: END IF;
2273: --
2274: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2275: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2304: --
2305: END IF;
2306: --
2307: IF l_debug_on THEN
2308: WSH_DEBUG_SV.pop(l_module_name);
2309: END IF;
2310: --
2311: EXCEPTION
2312: WHEN OTHERS THEN
2313: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2314: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOADING_ORDER');
2315: --
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2318: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2319: END IF;
2320: --
2321: END Validate_Loading_Order;
2314: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOADING_ORDER');
2315: --
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2318: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2319: END IF;
2320: --
2321: END Validate_Loading_Order;
2322:
2363: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2364: --
2365: IF l_debug_on IS NULL
2366: THEN
2367: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2368: END IF;
2369: --
2370: IF l_debug_on THEN
2371: WSH_DEBUG_SV.push(l_module_name);
2367: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2368: END IF;
2369: --
2370: IF l_debug_on THEN
2371: WSH_DEBUG_SV.push(l_module_name);
2372: --
2373: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2374: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2375: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2369: --
2370: IF l_debug_on THEN
2371: WSH_DEBUG_SV.push(l_module_name);
2372: --
2373: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2374: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2375: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2376: WSH_DEBUG_SV.log(l_module_name,'P_PLANNED_DEP_DATE',P_PLANNED_DEP_DATE);
2377: END IF;
2370: IF l_debug_on THEN
2371: WSH_DEBUG_SV.push(l_module_name);
2372: --
2373: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2374: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2375: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2376: WSH_DEBUG_SV.log(l_module_name,'P_PLANNED_DEP_DATE',P_PLANNED_DEP_DATE);
2377: END IF;
2378: --
2371: WSH_DEBUG_SV.push(l_module_name);
2372: --
2373: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2374: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2375: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2376: WSH_DEBUG_SV.log(l_module_name,'P_PLANNED_DEP_DATE',P_PLANNED_DEP_DATE);
2377: END IF;
2378: --
2379: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2372: --
2373: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2374: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2375: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2376: WSH_DEBUG_SV.log(l_module_name,'P_PLANNED_DEP_DATE',P_PLANNED_DEP_DATE);
2377: END IF;
2378: --
2379: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2380:
2395:
2396: END IF;
2397: --
2398: IF l_debug_on THEN
2399: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2400: WSH_DEBUG_SV.pop(l_module_name);
2401: END IF;
2402: --
2403: END Validate_Stop_Name;
2396: END IF;
2397: --
2398: IF l_debug_on THEN
2399: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2400: WSH_DEBUG_SV.pop(l_module_name);
2401: END IF;
2402: --
2403: END Validate_Stop_Name;
2404:
2440: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2441: --
2442: IF l_debug_on IS NULL
2443: THEN
2444: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2445: END IF;
2446: --
2447: IF l_debug_on THEN
2448: WSH_DEBUG_SV.push(l_module_name);
2444: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2445: END IF;
2446: --
2447: IF l_debug_on THEN
2448: WSH_DEBUG_SV.push(l_module_name);
2449: --
2450: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2451: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
2452: END IF;
2446: --
2447: IF l_debug_on THEN
2448: WSH_DEBUG_SV.push(l_module_name);
2449: --
2450: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2451: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
2452: END IF;
2453: --
2454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2447: IF l_debug_on THEN
2448: WSH_DEBUG_SV.push(l_module_name);
2449: --
2450: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2451: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
2452: END IF;
2453: --
2454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2455:
2470:
2471: END IF;
2472: --
2473: IF l_debug_on THEN
2474: WSH_DEBUG_SV.pop(l_module_name);
2475: END IF;
2476: --
2477: END Validate_Trip_Name;
2478:
2509: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2510: --
2511: IF l_debug_on IS NULL
2512: THEN
2513: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2514: END IF;
2515: --
2516: IF l_debug_on THEN
2517: WSH_DEBUG_SV.push(l_module_name);
2513: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2514: END IF;
2515: --
2516: IF l_debug_on THEN
2517: WSH_DEBUG_SV.push(l_module_name);
2518: --
2519: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2520: END IF;
2521: --
2515: --
2516: IF l_debug_on THEN
2517: WSH_DEBUG_SV.push(l_module_name);
2518: --
2519: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2520: END IF;
2521: --
2522: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2523:
2540:
2541: END IF;
2542: --
2543: IF l_debug_on THEN
2544: WSH_DEBUG_SV.pop(l_module_name);
2545: END IF;
2546: --
2547: END Validate_Trip_MultiStops;
2548:
2576: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2577: --
2578: IF l_debug_on IS NULL
2579: THEN
2580: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2581: END IF;
2582: --
2583: IF l_debug_on THEN
2584: WSH_DEBUG_SV.push(l_module_name);
2580: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2581: END IF;
2582: --
2583: IF l_debug_on THEN
2584: WSH_DEBUG_SV.push(l_module_name);
2585: --
2586: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2587: END IF;
2588:
2582: --
2583: IF l_debug_on THEN
2584: WSH_DEBUG_SV.push(l_module_name);
2585: --
2586: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2587: END IF;
2588:
2589: -- bug 5161801, if p_organization_id is NULL return 'N';
2590: IF (p_organization_id is NULL) THEN
2600: --{
2601: --
2602: --
2603: IF l_debug_on THEN
2604: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_dlvyTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
2605: END IF;
2606: --
2607: wsh_util_core.get_cached_value
2608: (
2646: l_return_status := 'N';
2647: END IF;
2648:
2649: IF l_debug_on THEN
2650: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_dlvyTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
2651: END IF;
2652: --
2653: wsh_util_core.get_cached_value
2654: (
2681:
2682:
2683:
2684: IF l_debug_on THEN
2685: WSH_DEBUG_SV.log(l_module_name,'Returns ',l_return_status);
2686: WSH_DEBUG_SV.pop(l_module_name);
2687: END IF;
2688: --
2689: RETURN l_return_status ;
2682:
2683:
2684: IF l_debug_on THEN
2685: WSH_DEBUG_SV.log(l_module_name,'Returns ',l_return_status);
2686: WSH_DEBUG_SV.pop(l_module_name);
2687: END IF;
2688: --
2689: RETURN l_return_status ;
2690:
2691: EXCEPTION
2692: WHEN FND_API.G_EXC_ERROR THEN
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2697: END IF;
2698: --
2699: -- bug 5161801, return 'N' when it encounters any exception
2692: WHEN FND_API.G_EXC_ERROR THEN
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2697: END IF;
2698: --
2699: -- bug 5161801, return 'N' when it encounters any exception
2700: l_return_status := 'N';
2701: RETURN l_return_status ;
2702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2703: --
2704: IF l_debug_on THEN
2705: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2707: END IF;
2708: --
2709: -- bug 5161801, return 'N' when it encounters any exception
2702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2703: --
2704: IF l_debug_on THEN
2705: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2707: END IF;
2708: --
2709: -- bug 5161801, return 'N' when it encounters any exception
2710: l_return_status := 'N';
2711: RETURN l_return_status ;
2712: WHEN OTHERS THEN
2713: --
2714: IF l_debug_on THEN
2715: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2716: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2717: END IF;
2718: --
2719: -- bug 5161801, return 'N' when it encounters any exception
2712: WHEN OTHERS THEN
2713: --
2714: IF l_debug_on THEN
2715: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2716: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2717: END IF;
2718: --
2719: -- bug 5161801, return 'N' when it encounters any exception
2720: l_return_status := 'N';
2735: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2736: --
2737: IF l_debug_on IS NULL
2738: THEN
2739: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2740: END IF;
2741: --
2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.push(l_module_name);
2739: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2740: END IF;
2741: --
2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.push(l_module_name);
2744: WSH_DEBUG_SV.log(l_module_name,'p_from_date',p_from_date);
2745: WSH_DEBUG_SV.log(l_module_name,'p_to_date',p_to_date);
2746: END IF;
2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2740: END IF;
2741: --
2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.push(l_module_name);
2744: WSH_DEBUG_SV.log(l_module_name,'p_from_date',p_from_date);
2745: WSH_DEBUG_SV.log(l_module_name,'p_to_date',p_to_date);
2746: END IF;
2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2748:
2741: --
2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.push(l_module_name);
2744: WSH_DEBUG_SV.log(l_module_name,'p_from_date',p_from_date);
2745: WSH_DEBUG_SV.log(l_module_name,'p_to_date',p_to_date);
2746: END IF;
2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2748:
2749: IF nvl(p_from_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2757: END IF;
2758:
2759:
2760: IF l_debug_on THEN
2761: WSH_DEBUG_SV.pop(l_module_name);
2762: END IF;
2763:
2764: EXCEPTION
2765: WHEN OTHERS THEN
2765: WHEN OTHERS THEN
2766: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2767: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_from_to_dates');
2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2771: END IF;
2772: END validate_from_to_dates;
2773:
2766: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2767: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_from_to_dates');
2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2771: END IF;
2772: END validate_from_to_dates;
2773:
2774:
2814: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2815: --
2816: IF l_debug_on IS NULL
2817: THEN
2818: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2819: END IF;
2820: --
2821: IF l_debug_on THEN
2822: WSH_DEBUG_SV.push(l_module_name);
2818: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2819: END IF;
2820: --
2821: IF l_debug_on THEN
2822: WSH_DEBUG_SV.push(l_module_name);
2823: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2824: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2825: END IF;
2826:
2819: END IF;
2820: --
2821: IF l_debug_on THEN
2822: WSH_DEBUG_SV.push(l_module_name);
2823: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2824: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2825: END IF;
2826:
2827: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2820: --
2821: IF l_debug_on THEN
2822: WSH_DEBUG_SV.push(l_module_name);
2823: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2824: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2825: END IF;
2826:
2827: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2828:
2845: END IF;
2846: END IF;
2847:
2848: IF l_debug_on THEN
2849: WSH_DEBUG_SV.pop(l_module_name);
2850: END IF;
2851:
2852: EXCEPTION
2853: WHEN OTHERS THEN
2853: WHEN OTHERS THEN
2854: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2855: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_trip_status');
2856: IF l_debug_on THEN
2857: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2858: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2859: END IF;
2860: END validate_trip_status;
2861:
2854: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2855: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_trip_status');
2856: IF l_debug_on THEN
2857: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2858: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2859: END IF;
2860: END validate_trip_status;
2861:
2862: -- I Harmonization: rvishnuv *******
2898: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2899: --
2900: IF l_debug_on IS NULL
2901: THEN
2902: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2903: END IF;
2904: --
2905: IF l_debug_on THEN
2906: --
2903: END IF;
2904: --
2905: IF l_debug_on THEN
2906: --
2907: WSH_DEBUG_SV.push(l_module_name);
2908: --
2909: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
2910: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
2911: --
2905: IF l_debug_on THEN
2906: --
2907: WSH_DEBUG_SV.push(l_module_name);
2908: --
2909: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
2910: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
2911: --
2912: END IF;
2913: --
2906: --
2907: WSH_DEBUG_SV.push(l_module_name);
2908: --
2909: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
2910: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
2911: --
2912: END IF;
2913: --
2914: x_return_status := wsh_util_core.g_ret_sts_success;
2929: --
2930: END IF;
2931: --
2932: IF l_debug_on THEN
2933: WSH_DEBUG_SV.pop(l_module_name);
2934: END IF;
2935: --
2936: EXCEPTION
2937: --
2940: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2941: --
2942: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_CARRIER');
2943: IF l_debug_on THEN
2944: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2945: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2946: END IF;
2947: --
2948: END Validate_Carrier;
2941: --
2942: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_CARRIER');
2943: IF l_debug_on THEN
2944: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2945: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2946: END IF;
2947: --
2948: END Validate_Carrier;
2949:
3165: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3166: --
3167: IF l_debug_on IS NULL
3168: THEN
3169: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3170: END IF;
3171: --
3172: IF l_debug_on THEN
3173: --
3170: END IF;
3171: --
3172: IF l_debug_on THEN
3173: --
3174: WSH_DEBUG_SV.push(l_module_name);
3175: --
3176: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3177: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3178: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3172: IF l_debug_on THEN
3173: --
3174: WSH_DEBUG_SV.push(l_module_name);
3175: --
3176: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3177: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3178: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3179: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3180: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3173: --
3174: WSH_DEBUG_SV.push(l_module_name);
3175: --
3176: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3177: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3178: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3179: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3180: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3181: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3174: WSH_DEBUG_SV.push(l_module_name);
3175: --
3176: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3177: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3178: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3179: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3180: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3181: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3182: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3175: --
3176: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3177: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3178: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3179: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3180: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3181: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3182: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3183: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3176: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3177: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3178: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3179: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3180: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3181: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3182: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3183: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3184: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3177: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3178: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3179: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3180: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3181: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3182: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3183: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3184: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3185: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3178: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3179: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3180: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3181: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3182: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3183: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3184: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3185: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3186: --
3179: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3180: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3181: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3182: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3183: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3184: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3185: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3186: --
3187: END IF;
3180: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3181: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3182: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3183: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3184: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3185: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3186: --
3187: END IF;
3188: --
3181: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3182: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3183: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3184: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3185: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3186: --
3187: END IF;
3188: --
3189: IF p_entity_type IS NULL
3235: END IF;
3236: --
3237: IF l_debug_on THEN
3238: --
3239: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id', l_carrier_id);
3240: WSH_DEBUG_SV.log(l_module_name,'l_service_level', l_service_level);
3241: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport', l_mode_of_transport);
3242: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code', l_ship_method_code);
3243: --
3236: --
3237: IF l_debug_on THEN
3238: --
3239: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id', l_carrier_id);
3240: WSH_DEBUG_SV.log(l_module_name,'l_service_level', l_service_level);
3241: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport', l_mode_of_transport);
3242: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code', l_ship_method_code);
3243: --
3244: END IF;
3237: IF l_debug_on THEN
3238: --
3239: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id', l_carrier_id);
3240: WSH_DEBUG_SV.log(l_module_name,'l_service_level', l_service_level);
3241: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport', l_mode_of_transport);
3242: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code', l_ship_method_code);
3243: --
3244: END IF;
3245: --
3238: --
3239: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id', l_carrier_id);
3240: WSH_DEBUG_SV.log(l_module_name,'l_service_level', l_service_level);
3241: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport', l_mode_of_transport);
3242: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code', l_ship_method_code);
3243: --
3244: END IF;
3245: --
3246: validate_ship_method(
3253: END IF;
3254: l_ship_method_code_backup := x_ship_method_code;
3255: --
3256: IF l_debug_on THEN
3257: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_ship_method',l_return_status);
3258: END IF;
3259: --
3260: WSH_UTIL_CORE.api_post_call(
3261: p_return_status => l_return_status,
3267: x_carrier_id => x_carrier_id,
3268: x_return_status => l_return_status);
3269: --
3270: IF l_debug_on THEN
3271: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_carrier',l_return_status);
3272: END IF;
3273: --
3274: WSH_UTIL_CORE.api_post_call(
3275: p_return_status => l_return_status,
3287: -- 10374068
3288: IF ( p_caller = 'WSH_FSTRX' and (x_service_level is NULL or x_mode_of_transport is NULL))
3289: THEN
3290: IF l_debug_on THEN
3291: WSH_DEBUG_SV.logmsg(l_module_name,'Ship Method is not getting Nullified since Call From WSH_FSTRX ');
3292: END IF;
3293: ELSE
3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.logmsg(l_module_name,'Ship Method is being Nullified 1');
3291: WSH_DEBUG_SV.logmsg(l_module_name,'Ship Method is not getting Nullified since Call From WSH_FSTRX ');
3292: END IF;
3293: ELSE
3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.logmsg(l_module_name,'Ship Method is being Nullified 1');
3296: END IF;
3297: x_ship_method_code := NULL;
3298: p_ship_method_name := NULL;
3299: END IF;
3307: p_meaning => l_dummy_meaning,
3308: x_return_status => l_return_status);
3309: --
3310: IF l_debug_on THEN
3311: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_lookup for service_level',l_return_status);
3312: END IF;
3313: --
3314: WSH_UTIL_CORE.api_post_call(
3315: p_return_status => l_return_status,
3328: p_meaning => l_dummy_meaning,
3329: x_return_status => l_return_status);
3330: --
3331: IF l_debug_on THEN
3332: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_lookup for mode_of_transport',l_return_status);
3333: END IF;
3334: --
3335: WSH_UTIL_CORE.api_post_call(
3336: p_return_status => l_return_status,
3342: --
3343: --
3344: IF l_debug_on THEN
3345: --
3346: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3347: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3348: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3349: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3350: --
3343: --
3344: IF l_debug_on THEN
3345: --
3346: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3347: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3348: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3349: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3350: --
3351: END IF;
3344: IF l_debug_on THEN
3345: --
3346: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3347: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3348: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3349: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3350: --
3351: END IF;
3352: --
3345: --
3346: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3347: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3348: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3349: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3350: --
3351: END IF;
3352: --
3353: IF l_sm_is_null = TRUE
3379: --
3380: x_return_status := wsh_util_core.g_ret_sts_success;
3381: IF l_debug_on THEN
3382: --
3383: WSH_DEBUG_SV.logmsg(l_module_name,'FTE not installed' );
3384: WSH_DEBUG_SV.pop(l_module_name);
3385: END IF;
3386: RETURN;
3387: ******/
3380: x_return_status := wsh_util_core.g_ret_sts_success;
3381: IF l_debug_on THEN
3382: --
3383: WSH_DEBUG_SV.logmsg(l_module_name,'FTE not installed' );
3384: WSH_DEBUG_SV.pop(l_module_name);
3385: END IF;
3386: RETURN;
3387: ******/
3388: -- End of Comment for Bug 4000931
3498: p_ship_method_name => p_ship_method_name,
3499: x_return_status => l_return_status);
3500: --
3501: IF l_debug_on THEN
3502: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_ship_method Name',l_return_status);
3503: END IF;
3504: --
3505: WSH_UTIL_CORE.api_post_call(
3506: p_return_status => l_return_status,
3533: p_ship_method_name => p_ship_method_name,
3534: x_return_status => l_return_status);
3535: --
3536: IF l_debug_on THEN
3537: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_ship_method Name',l_return_status);
3538: END IF;
3539: --
3540: WSH_UTIL_CORE.api_post_call(
3541: p_return_status => l_return_status,
3577: IF NVL(l_ship_method_code_backup,fnd_api.G_MISS_CHAR) <>
3578: NVL(x_ship_method_code,fnd_api.G_MISS_CHAR) THEN
3579: --
3580: IF l_debug_on THEN
3581: wsh_debug_sv.logmsg(l_module_name,'Ship method calculated is different');
3582: END IF;
3583: FND_MESSAGE.SET_NAME('WSH','WSH_SHIP_METHOD_CHANGE');
3584: FND_MESSAGE.SET_TOKEN('ORIG_SM', l_ship_method_code_backup);
3585: FND_MESSAGE.SET_TOKEN('CALC_SM', x_ship_method_code);
3591:
3592: x_return_status := wsh_util_core.g_ret_sts_success;
3593: --
3594: IF l_debug_on THEN
3595: WSH_DEBUG_SV.pop(l_module_name);
3596: END IF;
3597: --
3598: EXCEPTION
3599: --
3600: WHEN FND_API.G_EXC_ERROR THEN
3601: --
3602: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3603: IF l_debug_on THEN
3604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3606: END IF;
3607: --
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3601: --
3602: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3603: IF l_debug_on THEN
3604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3606: END IF;
3607: --
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: --
3609: --
3610: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3611: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3612: IF l_debug_on THEN
3613: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3614: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3615: END IF;
3616: --
3617: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3610: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3611: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3612: IF l_debug_on THEN
3613: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3614: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3615: END IF;
3616: --
3617: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3618: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3617: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3618: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3619: --
3620: IF l_debug_on THEN
3621: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNIN
3623: G');
3624: END IF;
3625: --
3618: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3619: --
3620: IF l_debug_on THEN
3621: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNIN
3623: G');
3624: END IF;
3625: --
3626: WHEN OTHERS THEN
3627: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3628: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3629: --
3630: IF l_debug_on THEN
3631: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3633: END IF;
3634: END Validate_Freight_Carrier;
3635: -- I Harmonization: rvishnuv *******
3628: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3629: --
3630: IF l_debug_on THEN
3631: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3633: END IF;
3634: END Validate_Freight_Carrier;
3635: -- I Harmonization: rvishnuv *******
3636:
3674: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3675: --
3676: IF l_debug_on IS NULL
3677: THEN
3678: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3679: END IF;
3680: --
3681: IF l_debug_on THEN
3682: WSH_DEBUG_SV.push(l_module_name);
3678: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3679: END IF;
3680: --
3681: IF l_debug_on THEN
3682: WSH_DEBUG_SV.push(l_module_name);
3683: --
3684: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3685: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3686: END IF;
3680: --
3681: IF l_debug_on THEN
3682: WSH_DEBUG_SV.push(l_module_name);
3683: --
3684: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3685: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3686: END IF;
3687: --
3688: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3681: IF l_debug_on THEN
3682: WSH_DEBUG_SV.push(l_module_name);
3683: --
3684: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3685: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3686: END IF;
3687: --
3688: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3689:
3699:
3700: l_wms_org := wsh_util_validate.Check_Wms_Org(p_organization_id);
3701:
3702: IF l_debug_on THEN
3703: WSH_DEBUG_SV.log(l_module_name,'l_wms_org',l_wms_org);
3704: END IF;
3705:
3706: IF(nvl(l_vehicle_item_flag, 'N') = 'Y') THEN
3707: x_item_type := 'VEH_ITEM';
3712: x_item_type := 'CONT_ITEM';
3713: END IF;
3714:
3715: IF l_debug_on THEN
3716: WSH_DEBUG_SV.pop(l_module_name);
3717: END IF;
3718: --
3719:
3720: EXCEPTION
3721: WHEN FND_API.G_EXC_ERROR THEN
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: wsh_util_core.add_message(x_return_status,l_module_name);
3724: IF l_debug_on THEN
3725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3727: END IF;
3728:
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: wsh_util_core.add_message(x_return_status,l_module_name);
3724: IF l_debug_on THEN
3725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3727: END IF;
3728:
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: --
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: --
3731: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3735: END IF;
3736:
3737: WHEN OTHERS THEN
3730: --
3731: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3735: END IF;
3736:
3737: WHEN OTHERS THEN
3738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3739: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.FIND_ITEM_TYPE');
3740: --
3741: IF l_debug_on THEN
3742: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3744: END IF;
3745:
3746: END Find_Item_Type;
3739: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.FIND_ITEM_TYPE');
3740: --
3741: IF l_debug_on THEN
3742: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3744: END IF;
3745:
3746: END Find_Item_Type;
3747: -- I Harmonization: KVENKATE
3770: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3771: --
3772: IF l_debug_on IS NULL
3773: THEN
3774: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3775: END IF;
3776: --
3777: IF l_debug_on THEN
3778: wsh_debug_sv.push(l_module_name, 'Get_Org_Type');
3774: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3775: END IF;
3776: --
3777: IF l_debug_on THEN
3778: wsh_debug_sv.push(l_module_name, 'Get_Org_Type');
3779: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);
3780: END IF;
3781:
3782: l_org_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type (
3775: END IF;
3776: --
3777: IF l_debug_on THEN
3778: wsh_debug_sv.push(l_module_name, 'Get_Org_Type');
3779: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);
3780: END IF;
3781:
3782: l_org_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type (
3783: p_organization_id => p_organization_id,
3799: l_org_type_wms := 'WMS';
3800: END IF;
3801:
3802: IF l_debug_on THEN
3803: wsh_debug_sv.log (l_module_name,'l_org_type', l_org_type);
3804: wsh_debug_sv.log (l_module_name,'l_org_type_wms', l_org_type_wms);
3805: END IF;
3806:
3807: IF l_org_type IS NULL THEN
3800: END IF;
3801:
3802: IF l_debug_on THEN
3803: wsh_debug_sv.log (l_module_name,'l_org_type', l_org_type);
3804: wsh_debug_sv.log (l_module_name,'l_org_type_wms', l_org_type_wms);
3805: END IF;
3806:
3807: IF l_org_type IS NULL THEN
3808: l_org_type := l_org_type_wms;
3812:
3813: x_return_status := wsh_util_core.g_ret_sts_success;
3814:
3815: IF l_debug_on THEN
3816: wsh_debug_sv.pop(l_module_name, 'Get_Org_Type');
3817: END IF;
3818:
3819: RETURN l_org_type;
3820: EXCEPTION
3821: WHEN FND_API.G_EXC_ERROR THEN
3822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3823: --
3824: IF l_debug_on THEN
3825: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3827: END IF;
3828: RETURN l_org_type;
3829: --
3822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3823: --
3824: IF l_debug_on THEN
3825: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3827: END IF;
3828: RETURN l_org_type;
3829: --
3830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3831: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3832: --
3833: IF l_debug_on THEN
3834: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3836: END IF;
3837: RETURN l_org_type;
3838: --
3831: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3832: --
3833: IF l_debug_on THEN
3834: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3836: END IF;
3837: RETURN l_org_type;
3838: --
3839: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3839: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3840: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3841: --
3842: IF l_debug_on THEN
3843: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3844: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3845: END IF;
3846: RETURN l_org_type;
3847: --
3840: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3841: --
3842: IF l_debug_on THEN
3843: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3844: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3845: END IF;
3846: RETURN l_org_type;
3847: --
3848: WHEN OTHERS THEN
3849: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3850: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.GET_ORG_TYPE');
3851: --
3852: IF l_debug_on THEN
3853: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3854: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3855: END IF;
3856: RETURN l_org_type;
3857: --
3850: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.GET_ORG_TYPE');
3851: --
3852: IF l_debug_on THEN
3853: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3854: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3855: END IF;
3856: RETURN l_org_type;
3857: --
3858: END Get_Org_Type;
3910: --
3911: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3912: --
3913: IF l_debug_on IS NULL THEN
3914: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3915: END IF;
3916: --
3917: IF l_debug_on THEN
3918: WSH_DEBUG_SV.push(l_module_name);
3914: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3915: END IF;
3916: --
3917: IF l_debug_on THEN
3918: WSH_DEBUG_SV.push(l_module_name);
3919: --
3920: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
3921: WSH_DEBUG_SV.log(l_module_name,'p_inventory_item_id',
3922: p_inventory_item_id);
3916: --
3917: IF l_debug_on THEN
3918: WSH_DEBUG_SV.push(l_module_name);
3919: --
3920: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
3921: WSH_DEBUG_SV.log(l_module_name,'p_inventory_item_id',
3922: p_inventory_item_id);
3923: END IF;
3924: --
3917: IF l_debug_on THEN
3918: WSH_DEBUG_SV.push(l_module_name);
3919: --
3920: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
3921: WSH_DEBUG_SV.log(l_module_name,'p_inventory_item_id',
3922: p_inventory_item_id);
3923: END IF;
3924: --
3925: IF (p_organization_id IS NULL ) OR (p_inventory_item_id IS NULL )THEN
3941: x_Item_info_rec := G_ITEM_INFO_TAB(l_hash_value);
3942: l_cache_hit := TRUE;
3943:
3944: IF l_debug_on THEN
3945: WSH_DEBUG_SV.logmsg(l_module_name,'hit ');
3946: END IF;
3947:
3948: END IF; --}
3949:
3975:
3976: END IF; --}
3977:
3978: IF l_debug_on THEN
3979: WSH_DEBUG_SV.log(l_module_name, 'primary_uom_code',
3980: x_Item_info_rec.primary_uom_code);
3981: WSH_DEBUG_SV.log(l_module_name, 'description',
3982: x_Item_info_rec.description);
3983: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3977:
3978: IF l_debug_on THEN
3979: WSH_DEBUG_SV.log(l_module_name, 'primary_uom_code',
3980: x_Item_info_rec.primary_uom_code);
3981: WSH_DEBUG_SV.log(l_module_name, 'description',
3982: x_Item_info_rec.description);
3983: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3984: x_Item_info_rec.hazard_class_id);
3985: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3979: WSH_DEBUG_SV.log(l_module_name, 'primary_uom_code',
3980: x_Item_info_rec.primary_uom_code);
3981: WSH_DEBUG_SV.log(l_module_name, 'description',
3982: x_Item_info_rec.description);
3983: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3984: x_Item_info_rec.hazard_class_id);
3985: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3986: x_Item_info_rec.weight_uom_code);
3987: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3981: WSH_DEBUG_SV.log(l_module_name, 'description',
3982: x_Item_info_rec.description);
3983: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3984: x_Item_info_rec.hazard_class_id);
3985: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3986: x_Item_info_rec.weight_uom_code);
3987: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3988: x_Item_info_rec.unit_weight);
3989: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3983: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3984: x_Item_info_rec.hazard_class_id);
3985: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3986: x_Item_info_rec.weight_uom_code);
3987: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3988: x_Item_info_rec.unit_weight);
3989: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3990: x_Item_info_rec.volume_uom_code);
3991: WSH_DEBUG_SV.log(l_module_name, 'unit_volume',
3985: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3986: x_Item_info_rec.weight_uom_code);
3987: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3988: x_Item_info_rec.unit_weight);
3989: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3990: x_Item_info_rec.volume_uom_code);
3991: WSH_DEBUG_SV.log(l_module_name, 'unit_volume',
3992: x_Item_info_rec.unit_volume);
3993: WSH_DEBUG_SV.pop(l_module_name);
3987: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3988: x_Item_info_rec.unit_weight);
3989: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3990: x_Item_info_rec.volume_uom_code);
3991: WSH_DEBUG_SV.log(l_module_name, 'unit_volume',
3992: x_Item_info_rec.unit_volume);
3993: WSH_DEBUG_SV.pop(l_module_name);
3994: END IF;
3995: EXCEPTION
3989: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3990: x_Item_info_rec.volume_uom_code);
3991: WSH_DEBUG_SV.log(l_module_name, 'unit_volume',
3992: x_Item_info_rec.unit_volume);
3993: WSH_DEBUG_SV.pop(l_module_name);
3994: END IF;
3995: EXCEPTION
3996:
3997: WHEN FND_API.G_EXC_ERROR THEN
3997: WHEN FND_API.G_EXC_ERROR THEN
3998: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3999: --
4000: IF l_debug_on THEN
4001: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4002: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4003: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4004: END IF;
4005: --
3998: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3999: --
4000: IF l_debug_on THEN
4001: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4002: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4003: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4004: END IF;
4005: --
4006: WHEN OTHERS THEN
3999: --
4000: IF l_debug_on THEN
4001: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4002: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4003: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4004: END IF;
4005: --
4006: WHEN OTHERS THEN
4007: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4007: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4008: wsh_util_core.default_handler('WSH_UTIL_CORE.GET_ITEM_INFO');
4009: --
4010: IF l_debug_on THEN
4011: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4012: 'Oracle error message is '||
4013: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4014: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4015: END IF;
4009: --
4010: IF l_debug_on THEN
4011: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4012: 'Oracle error message is '||
4013: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4014: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4015: END IF;
4016:
4017:
4010: IF l_debug_on THEN
4011: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4012: 'Oracle error message is '||
4013: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4014: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4015: END IF;
4016:
4017:
4018: END get_item_info;
4052: BEGIN
4053: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4054: --
4055: IF l_debug_on IS NULL THEN
4056: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4057: END IF;
4058: --
4059: IF l_debug_on THEN
4060: WSH_DEBUG_SV.push(l_module_name);
4056: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4057: END IF;
4058: --
4059: IF l_debug_on THEN
4060: WSH_DEBUG_SV.push(l_module_name);
4061: --
4062: WSH_DEBUG_SV.log(l_module_name,'p_item_id',p_item_id);
4063: END IF;
4064: --
4058: --
4059: IF l_debug_on THEN
4060: WSH_DEBUG_SV.push(l_module_name);
4061: --
4062: WSH_DEBUG_SV.log(l_module_name,'p_item_id',p_item_id);
4063: END IF;
4064: --
4065: IF p_item_id IS NULL THEN
4066: RAISE FND_API.G_EXC_ERROR;
4116: END IF;
4117: ELSE --}{
4118: IF l_debug_on THEN
4119: --
4120: WSH_DEBUG_SV.logmsg(l_module_name,'hit ');
4121: --
4122: END IF;
4123: END IF; --}
4124:
4123: END IF; --}
4124:
4125:
4126: IF l_debug_on THEN
4127: WSH_DEBUG_SV.log(l_module_name, 'x_master_container_item_id',
4128: x_master_container_item_id);
4129: WSH_DEBUG_SV.log(l_module_name, 'x_detail_container_item_id',
4130: x_detail_container_item_id);
4131: WSH_DEBUG_SV.pop(l_module_name);
4125:
4126: IF l_debug_on THEN
4127: WSH_DEBUG_SV.log(l_module_name, 'x_master_container_item_id',
4128: x_master_container_item_id);
4129: WSH_DEBUG_SV.log(l_module_name, 'x_detail_container_item_id',
4130: x_detail_container_item_id);
4131: WSH_DEBUG_SV.pop(l_module_name);
4132: END IF;
4133:
4127: WSH_DEBUG_SV.log(l_module_name, 'x_master_container_item_id',
4128: x_master_container_item_id);
4129: WSH_DEBUG_SV.log(l_module_name, 'x_detail_container_item_id',
4130: x_detail_container_item_id);
4131: WSH_DEBUG_SV.pop(l_module_name);
4132: END IF;
4133:
4134: EXCEPTION
4135: WHEN FND_API.G_EXC_ERROR THEN
4135: WHEN FND_API.G_EXC_ERROR THEN
4136: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4137: --
4138: IF l_debug_on THEN
4139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4140: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4142: END IF;
4143: --
4136: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4137: --
4138: IF l_debug_on THEN
4139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4140: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4142: END IF;
4143: --
4144:
4137: --
4138: IF l_debug_on THEN
4139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4140: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4142: END IF;
4143: --
4144:
4145: WHEN OTHERS THEN
4146: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4147: wsh_util_core.default_handler('WSH_UTIL_CORE.DEFAULT_CONTAINER');
4148: --
4149: IF l_debug_on THEN
4150: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4151: 'Oracle error message is '||
4152: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4153: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4154: END IF;
4148: --
4149: IF l_debug_on THEN
4150: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4151: 'Oracle error message is '||
4152: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4153: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4154: END IF;
4155:
4156: END Default_container;
4149: IF l_debug_on THEN
4150: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4151: 'Oracle error message is '||
4152: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4153: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4154: END IF;
4155:
4156: END Default_container;
4157:
4200:
4201: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4202: IF l_debug_on IS NULL
4203: THEN
4204: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4205: END IF;
4206: --
4207: IF l_debug_on THEN
4208: wsh_debug_sv.push (l_module_name);
4204: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4205: END IF;
4206: --
4207: IF l_debug_on THEN
4208: wsh_debug_sv.push (l_module_name);
4209: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4210: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4211: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4212: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4205: END IF;
4206: --
4207: IF l_debug_on THEN
4208: wsh_debug_sv.push (l_module_name);
4209: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4210: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4211: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4212: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4213: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4206: --
4207: IF l_debug_on THEN
4208: wsh_debug_sv.push (l_module_name);
4209: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4210: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4211: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4212: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4213: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4214: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4207: IF l_debug_on THEN
4208: wsh_debug_sv.push (l_module_name);
4209: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4210: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4211: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4212: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4213: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4214: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4215: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4208: wsh_debug_sv.push (l_module_name);
4209: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4210: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4211: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4212: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4213: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4214: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4215: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4216: WSH_DEBUG_SV.log(l_module_name, 'p_client_id',p_client_id); -- LSP PROJECT
4209: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4210: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4211: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4212: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4213: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4214: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4215: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4216: WSH_DEBUG_SV.log(l_module_name, 'p_client_id',p_client_id); -- LSP PROJECT
4217: END IF;
4210: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4211: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4212: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4213: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4214: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4215: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4216: WSH_DEBUG_SV.log(l_module_name, 'p_client_id',p_client_id); -- LSP PROJECT
4217: END IF;
4218: --
4211: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4212: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4213: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4214: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4215: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4216: WSH_DEBUG_SV.log(l_module_name, 'p_client_id',p_client_id); -- LSP PROJECT
4217: END IF;
4218: --
4219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4212: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4213: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4214: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4215: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4216: WSH_DEBUG_SV.log(l_module_name, 'p_client_id',p_client_id); -- LSP PROJECT
4217: END IF;
4218: --
4219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4220: IF p_caller = 'PO' THEN --{
4226: p_client_id => p_client_id, -- LSP PROJECT
4227: x_param_info => l_shipping_param_info,
4228: x_return_status => l_return_status);
4229: IF l_debug_on THEN
4230: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_SHIPPING_PARAMS_PVT.Get l_return_status '
4231: ,l_return_status);
4232: WSH_DEBUG_SV.log(l_module_name,'l_shipping_param_info.otm_enabled '
4233: ,l_shipping_param_info.otm_enabled);
4234: END IF;
4228: x_return_status => l_return_status);
4229: IF l_debug_on THEN
4230: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_SHIPPING_PARAMS_PVT.Get l_return_status '
4231: ,l_return_status);
4232: WSH_DEBUG_SV.log(l_module_name,'l_shipping_param_info.otm_enabled '
4233: ,l_shipping_param_info.otm_enabled);
4234: END IF;
4235: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,
4236: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4251: base => c_hash_base,
4252: hash_size =>c_hash_size );
4253:
4254: IF l_debug_on THEN
4255: WSH_DEBUG_SV.log(l_module_name,'l_hash_value ',l_hash_value);
4256: END IF;
4257: IF G_IGNORE_PLAN_TAB.EXISTS(l_hash_value) THEN --{
4258: IF G_IGNORE_PLAN_TAB(l_hash_value).organization_id = p_organization_id
4259: AND NVL(G_IGNORE_PLAN_TAB(l_hash_value).carrier_id,-22) =
4264: x_ignore_for_planning :=
4265: G_IGNORE_PLAN_TAB(l_hash_value).ignore_for_planning;
4266: l_hit := TRUE;
4267: IF l_debug_on THEN
4268: WSH_DEBUG_SV.log(l_module_name,'hit ',x_ignore_for_planning);
4269: END IF;
4270: END IF; --}
4271: END IF; --}
4272: IF (NOT l_hit) THEN --{
4277: p_ship_method_code => p_ship_method_code,
4278: p_msg_display => 'N'
4279: );
4280: IF l_debug_on THEN
4281: WSH_DEBUG_SV.log(l_module_name,'l_wh_type,l_return_status',
4282: l_wh_type||l_return_status);
4283: END IF;
4284: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN
4285: x_ignore_for_planning:='Y';
4298: ELSE --}{
4299: x_ignore_for_planning := 'N';
4300: END IF; --}
4301: IF l_debug_on THEN
4302: WSH_DEBUG_SV.pop(l_module_name,x_ignore_for_planning);
4303: END IF;
4304: EXCEPTION
4305: WHEN FND_API.G_EXC_ERROR THEN --{ --OTM R12 Start
4306: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4305: WHEN FND_API.G_EXC_ERROR THEN --{ --OTM R12 Start
4306: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4307: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4308: IF l_debug_on THEN
4309: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4310: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4312: END IF; --} --OTM R12 End
4313: WHEN OTHERS THEN
4306: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4307: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4308: IF l_debug_on THEN
4309: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4310: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4312: END IF; --} --OTM R12 End
4313: WHEN OTHERS THEN
4314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4307: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4308: IF l_debug_on THEN
4309: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4310: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4312: END IF; --} --OTM R12 End
4313: WHEN OTHERS THEN
4314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4315: wsh_util_core.default_handler('WSH_UTIL_CORE.DEFAULT_CONTAINER');
4314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4315: wsh_util_core.default_handler('WSH_UTIL_CORE.DEFAULT_CONTAINER');
4316: --
4317: IF l_debug_on THEN
4318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4319: 'Oracle error message is '||
4320: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4322: END IF;
4316: --
4317: IF l_debug_on THEN
4318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4319: 'Oracle error message is '||
4320: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4322: END IF;
4323: END Calc_ignore_for_planning;
4324:
4317: IF l_debug_on THEN
4318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4319: 'Oracle error message is '||
4320: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4322: END IF;
4323: END Calc_ignore_for_planning;
4324:
4325: -- Added for Inbound Logistics
4384: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4385: --
4386: IF l_debug_on IS NULL
4387: THEN
4388: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4389: END IF;
4390: --
4391: --
4392: -- Debug Statements
4391: --
4392: -- Debug Statements
4393: --
4394: IF l_debug_on THEN
4395: WSH_DEBUG_SV.push(l_module_name);
4396: --
4397: WSH_DEBUG_SV.log(l_module_name,'P_FOB',P_FOB);
4398: END IF;
4399: --
4393: --
4394: IF l_debug_on THEN
4395: WSH_DEBUG_SV.push(l_module_name);
4396: --
4397: WSH_DEBUG_SV.log(l_module_name,'P_FOB',P_FOB);
4398: END IF;
4399: --
4400: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4401:
4449: --
4450: -- Debug Statements
4451: --
4452: IF l_debug_on THEN
4453: WSH_DEBUG_SV.pop(l_module_name);
4454: END IF;
4455: --
4456: EXCEPTION
4457: WHEN OTHERS THEN
4460: --
4461: -- Debug Statements
4462: --
4463: IF l_debug_on THEN
4464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4466: END IF;
4467: --
4468: END validate_fob;
4461: -- Debug Statements
4462: --
4463: IF l_debug_on THEN
4464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4466: END IF;
4467: --
4468: END validate_fob;
4469:
4530: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4531: --
4532: IF l_debug_on IS NULL
4533: THEN
4534: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4535: END IF;
4536: --
4537: --
4538: -- Debug Statements
4537: --
4538: -- Debug Statements
4539: --
4540: IF l_debug_on THEN
4541: WSH_DEBUG_SV.push(l_module_name);
4542: --
4543: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
4544: END IF;
4545: --
4539: --
4540: IF l_debug_on THEN
4541: WSH_DEBUG_SV.push(l_module_name);
4542: --
4543: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
4544: END IF;
4545: --
4546: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4547:
4595: --
4596: -- Debug Statements
4597: --
4598: IF l_debug_on THEN
4599: WSH_DEBUG_SV.pop(l_module_name);
4600: END IF;
4601: --
4602: EXCEPTION
4603: WHEN OTHERS THEN
4606: --
4607: -- Debug Statements
4608: --
4609: IF l_debug_on THEN
4610: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4611: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4612: END IF;
4613: --
4614: END Validate_freight_terms;
4607: -- Debug Statements
4608: --
4609: IF l_debug_on THEN
4610: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4611: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4612: END IF;
4613: --
4614: END Validate_freight_terms;
4615:
4662: --
4663: l_debug_on := wsh_debug_interface.g_debug;
4664: --
4665: IF l_debug_on IS NULL THEN
4666: l_debug_on := wsh_debug_sv.is_debug_enabled;
4667: END IF;
4668: --
4669: IF l_debug_on THEN
4670: wsh_debug_sv.push(l_module_name);
4666: l_debug_on := wsh_debug_sv.is_debug_enabled;
4667: END IF;
4668: --
4669: IF l_debug_on THEN
4670: wsh_debug_sv.push(l_module_name);
4671: --
4672: wsh_debug_sv.LOG(l_module_name, 'p_vendor_id', p_vendor_id);
4673: wsh_debug_sv.LOG(l_module_name, 'p_party_id', p_party_id);
4674: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
4668: --
4669: IF l_debug_on THEN
4670: wsh_debug_sv.push(l_module_name);
4671: --
4672: wsh_debug_sv.LOG(l_module_name, 'p_vendor_id', p_vendor_id);
4673: wsh_debug_sv.LOG(l_module_name, 'p_party_id', p_party_id);
4674: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
4675: END IF;
4676: --
4669: IF l_debug_on THEN
4670: wsh_debug_sv.push(l_module_name);
4671: --
4672: wsh_debug_sv.LOG(l_module_name, 'p_vendor_id', p_vendor_id);
4673: wsh_debug_sv.LOG(l_module_name, 'p_party_id', p_party_id);
4674: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
4675: END IF;
4676: --
4677: x_return_status := wsh_util_core.g_ret_sts_success;
4670: wsh_debug_sv.push(l_module_name);
4671: --
4672: wsh_debug_sv.LOG(l_module_name, 'p_vendor_id', p_vendor_id);
4673: wsh_debug_sv.LOG(l_module_name, 'p_party_id', p_party_id);
4674: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
4675: END IF;
4676: --
4677: x_return_status := wsh_util_core.g_ret_sts_success;
4678: --
4686: THEN
4687: --{
4688:
4689: IF l_debug_on THEN
4690: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.get_location_description',WSH_DEBUG_SV.C_PROC_LEVEL);
4691: END IF;
4692: --
4693: l_location_name := SUBSTRB(
4694: WSH_UTIL_CORE.get_location_description
4711: CLOSE locn_csr;
4712: --
4713: --
4714: IF l_debug_on THEN
4715: wsh_debug_sv.pop(l_module_name);
4716: END IF;
4717: --
4718: --}
4719: EXCEPTION
4723:
4724: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4725: --
4726: IF l_debug_on THEN
4727: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4728: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4729: END IF;
4730: --
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4724: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4725: --
4726: IF l_debug_on THEN
4727: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4728: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4729: END IF;
4730: --
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732:
4732:
4733: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4734: --
4735: IF l_debug_on THEN
4736: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4738: END IF;
4739: --
4740: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4733: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4734: --
4735: IF l_debug_on THEN
4736: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4738: END IF;
4739: --
4740: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4741: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4740: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4741: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4742: --
4743: IF l_debug_on THEN
4744: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4745: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4746: END IF;
4747: --
4748: WHEN OTHERS THEN
4741: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4742: --
4743: IF l_debug_on THEN
4744: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4745: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4746: END IF;
4747: --
4748: WHEN OTHERS THEN
4749:
4749:
4750: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4751: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_supplier_location', l_module_name);
4752: IF l_debug_on THEN
4753: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4754: END IF;
4755: --
4756: --}
4757: END validate_supplier_location;
4799: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4800: --
4801: IF l_debug_on IS NULL THEN
4802: --{
4803: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4804: --}
4805: END IF;
4806: --
4807: IF l_debug_on THEN
4805: END IF;
4806: --
4807: IF l_debug_on THEN
4808: --{
4809: WSH_DEBUG_SV.push(l_module_name);
4810: --
4811: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_ID',p_pick_grouping_rule_id);
4812: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_NAME',p_pick_grouping_rule_name);
4813: --}
4807: IF l_debug_on THEN
4808: --{
4809: WSH_DEBUG_SV.push(l_module_name);
4810: --
4811: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_ID',p_pick_grouping_rule_id);
4812: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_NAME',p_pick_grouping_rule_name);
4813: --}
4814: END IF;
4815: --
4808: --{
4809: WSH_DEBUG_SV.push(l_module_name);
4810: --
4811: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_ID',p_pick_grouping_rule_id);
4812: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_NAME',p_pick_grouping_rule_name);
4813: --}
4814: END IF;
4815: --
4816: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4832: END IF;
4833: --
4834: IF l_debug_on THEN
4835: --{
4836: WSH_DEBUG_SV.pop(l_module_name);
4837: --}
4838: END IF;
4839: --
4840: END Validate_Pick_Group_Rule_Name;
4876: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4877: --
4878: IF l_debug_on IS NULL THEN
4879: --{
4880: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4881: --}
4882: END IF;
4883: --
4884: IF l_debug_on THEN
4882: END IF;
4883: --
4884: IF l_debug_on THEN
4885: --{
4886: WSH_DEBUG_SV.push(l_module_name);
4887: --
4888: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_ID',p_pick_sequence_rule_id);
4889: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_NAME',p_pick_sequence_rule_NAME);
4890: --}
4884: IF l_debug_on THEN
4885: --{
4886: WSH_DEBUG_SV.push(l_module_name);
4887: --
4888: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_ID',p_pick_sequence_rule_id);
4889: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_NAME',p_pick_sequence_rule_NAME);
4890: --}
4891: END IF;
4892: --
4885: --{
4886: WSH_DEBUG_SV.push(l_module_name);
4887: --
4888: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_ID',p_pick_sequence_rule_id);
4889: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_NAME',p_pick_sequence_rule_NAME);
4890: --}
4891: END IF;
4892: --
4893: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4909: END IF;
4910: --
4911: IF l_debug_on THEN
4912: --{
4913: WSH_DEBUG_SV.pop(l_module_name);
4914: --}
4915: END IF;
4916: --
4917: END Validate_Pick_Seq_Rule_Name;
4953: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4954: --
4955: IF l_debug_on IS NULL THEN
4956: --{
4957: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4958: --}
4959: END IF;
4960: --
4961: IF l_debug_on THEN
4959: END IF;
4960: --
4961: IF l_debug_on THEN
4962: --{
4963: WSH_DEBUG_SV.push(l_module_name);
4964: --
4965: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_ID',p_ship_confirm_rule_id);
4966: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_NAME',p_ship_confirm_rule_name);
4967: --}
4961: IF l_debug_on THEN
4962: --{
4963: WSH_DEBUG_SV.push(l_module_name);
4964: --
4965: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_ID',p_ship_confirm_rule_id);
4966: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_NAME',p_ship_confirm_rule_name);
4967: --}
4968: END IF;
4969: --
4962: --{
4963: WSH_DEBUG_SV.push(l_module_name);
4964: --
4965: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_ID',p_ship_confirm_rule_id);
4966: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_NAME',p_ship_confirm_rule_name);
4967: --}
4968: END IF;
4969: --
4970: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4986: END IF;
4987: --
4988: IF l_debug_on THEN
4989: --{
4990: WSH_DEBUG_SV.pop(l_module_name);
4991: --}
4992: END IF;
4993: --
4994: END Validate_Ship_Con_Rule_Name;
5029: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5030: --
5031: IF l_debug_on IS NULL THEN
5032: --{
5033: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5034: --}
5035: END IF;
5036: --
5037: IF l_debug_on THEN
5035: END IF;
5036: --
5037: IF l_debug_on THEN
5038: --{
5039: WSH_DEBUG_SV.push(l_module_name);
5040: --
5041: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_ID',p_Picking_Batch_id);
5042: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_NAME',p_Picking_Batch_name);
5043: --}
5037: IF l_debug_on THEN
5038: --{
5039: WSH_DEBUG_SV.push(l_module_name);
5040: --
5041: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_ID',p_Picking_Batch_id);
5042: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_NAME',p_Picking_Batch_name);
5043: --}
5044: END IF;
5045: --
5038: --{
5039: WSH_DEBUG_SV.push(l_module_name);
5040: --
5041: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_ID',p_Picking_Batch_id);
5042: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_NAME',p_Picking_Batch_name);
5043: --}
5044: END IF;
5045: --
5046: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5062: END IF;
5063: --
5064: IF l_debug_on THEN
5065: --{
5066: WSH_DEBUG_SV.pop(l_module_name);
5067: --}
5068: END IF;
5069: --
5070: END Validate_Picking_Batch_Name;
5114: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5115: --
5116: IF l_debug_on IS NULL
5117: THEN
5118: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5119: END IF;
5120: --
5121: IF l_debug_on THEN
5122: WSH_DEBUG_SV.push(l_module_name);
5118: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5119: END IF;
5120: --
5121: IF l_debug_on THEN
5122: WSH_DEBUG_SV.push(l_module_name);
5123: --
5124: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
5125: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
5126: END IF;
5120: --
5121: IF l_debug_on THEN
5122: WSH_DEBUG_SV.push(l_module_name);
5123: --
5124: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
5125: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
5126: END IF;
5127: --
5128: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5121: IF l_debug_on THEN
5122: WSH_DEBUG_SV.push(l_module_name);
5123: --
5124: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
5125: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
5126: END IF;
5127: --
5128: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5129: --
5144: --
5145: END IF;
5146: --
5147: IF l_debug_on THEN
5148: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
5149: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
5150: WSH_DEBUG_SV.pop(l_module_name);
5151: END IF;
5152: --
5145: END IF;
5146: --
5147: IF l_debug_on THEN
5148: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
5149: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
5150: WSH_DEBUG_SV.pop(l_module_name);
5151: END IF;
5152: --
5153: EXCEPTION
5146: --
5147: IF l_debug_on THEN
5148: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
5149: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
5150: WSH_DEBUG_SV.pop(l_module_name);
5151: END IF;
5152: --
5153: EXCEPTION
5154: WHEN OTHERS THEN
5154: WHEN OTHERS THEN
5155: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5156: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Active_SM');
5157: IF l_debug_on THEN
5158: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5159: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5160: END IF;
5161: END Validate_Active_SM;
5162:
5155: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5156: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Active_SM');
5157: IF l_debug_on THEN
5158: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5159: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5160: END IF;
5161: END Validate_Active_SM;
5162:
5163: -- Added new internal procedure for OTM R12, glog project
5218: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5219: --
5220: IF l_debug_on IS NULL
5221: THEN
5222: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5223: END IF;
5224: --
5225: IF l_debug_on THEN
5226: WSH_DEBUG_SV.push(l_module_name);
5222: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5223: END IF;
5224: --
5225: IF l_debug_on THEN
5226: WSH_DEBUG_SV.push(l_module_name);
5227: --
5228: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
5229: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
5230: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
5224: --
5225: IF l_debug_on THEN
5226: WSH_DEBUG_SV.push(l_module_name);
5227: --
5228: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
5229: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
5230: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
5231: END IF;
5232: --
5225: IF l_debug_on THEN
5226: WSH_DEBUG_SV.push(l_module_name);
5227: --
5228: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
5229: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
5230: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
5231: END IF;
5232: --
5233: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5226: WSH_DEBUG_SV.push(l_module_name);
5227: --
5228: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
5229: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
5230: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
5231: END IF;
5232: --
5233: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5234:
5292:
5293: END IF;
5294: --
5295: IF l_debug_on THEN
5296: WSH_DEBUG_SV.log(l_module_name,'p_lookup_code',p_lookup_code);
5297: WSH_DEBUG_SV.pop(l_module_name);
5298: END IF;
5299:
5300: --
5293: END IF;
5294: --
5295: IF l_debug_on THEN
5296: WSH_DEBUG_SV.log(l_module_name,'p_lookup_code',p_lookup_code);
5297: WSH_DEBUG_SV.pop(l_module_name);
5298: END IF;
5299:
5300: --
5301: EXCEPTION
5305: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5306: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Lookup_Upper');
5307: --
5308: IF l_debug_on THEN
5309: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5310: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5311: END IF;
5312: --
5313: END Validate_Lookup_Upper;
5306: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Lookup_Upper');
5307: --
5308: IF l_debug_on THEN
5309: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5310: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5311: END IF;
5312: --
5313: END Validate_Lookup_Upper;
5314:
5342: --
5343: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5344: --
5345: IF l_debug_on IS NULL THEN
5346: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5347: END IF;
5348: --
5349: IF l_debug_on THEN
5350: WSH_DEBUG_SV.push(l_module_name);
5346: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5347: END IF;
5348: --
5349: IF l_debug_on THEN
5350: WSH_DEBUG_SV.push(l_module_name);
5351: WSH_DEBUG_SV.log(l_module_name,'p_ship_confirm_rule_id',
5352: p_ship_confirm_rule_id);
5353: WSH_DEBUG_SV.log(l_module_name,'p_actual_departure_date',
5354: p_actual_departure_date);
5347: END IF;
5348: --
5349: IF l_debug_on THEN
5350: WSH_DEBUG_SV.push(l_module_name);
5351: WSH_DEBUG_SV.log(l_module_name,'p_ship_confirm_rule_id',
5352: p_ship_confirm_rule_id);
5353: WSH_DEBUG_SV.log(l_module_name,'p_actual_departure_date',
5354: p_actual_departure_date);
5355: END IF;
5349: IF l_debug_on THEN
5350: WSH_DEBUG_SV.push(l_module_name);
5351: WSH_DEBUG_SV.log(l_module_name,'p_ship_confirm_rule_id',
5352: p_ship_confirm_rule_id);
5353: WSH_DEBUG_SV.log(l_module_name,'p_actual_departure_date',
5354: p_actual_departure_date);
5355: END IF;
5356: --
5357: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5362: --
5363: IF NOT v_ValidDate THEN
5364: --
5365: IF l_debug_on THEN
5366: wsh_debug_sv.logmsg(l_module_name, 'Future ship date is not allowed');
5367: END IF;
5368: --
5369: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_FUTURE_SHIP_DATE');
5370: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5372: --
5373: END IF;
5374: --
5375: IF l_debug_on THEN
5376: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5377: WSH_DEBUG_SV.pop(l_module_name);
5378: END IF;
5379: --
5380: EXCEPTION
5373: END IF;
5374: --
5375: IF l_debug_on THEN
5376: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5377: WSH_DEBUG_SV.pop(l_module_name);
5378: END IF;
5379: --
5380: EXCEPTION
5381: --
5384: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5385: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.ValidateActualDepartureDate');
5386: --
5387: IF l_debug_on THEN
5388: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
5389: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5390: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5391: END IF;
5392: --
5385: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.ValidateActualDepartureDate');
5386: --
5387: IF l_debug_on THEN
5388: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
5389: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5390: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5391: END IF;
5392: --
5393: END ValidateActualDepartureDate;
5386: --
5387: IF l_debug_on THEN
5388: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
5389: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5390: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5391: END IF;
5392: --
5393: END ValidateActualDepartureDate;
5394: --
5426: --
5427: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5428: --
5429: IF l_debug_on IS NULL THEN
5430: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5431: END IF;
5432: --
5433: IF l_debug_on THEN
5434: WSH_DEBUG_SV.push(l_module_name);
5430: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5431: END IF;
5432: --
5433: IF l_debug_on THEN
5434: WSH_DEBUG_SV.push(l_module_name);
5435: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5436: END IF;
5437: --
5438:
5431: END IF;
5432: --
5433: IF l_debug_on THEN
5434: WSH_DEBUG_SV.push(l_module_name);
5435: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5436: END IF;
5437: --
5438:
5439: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5473: --WMS Enabled Check
5474: IF g_sr_org_tab(l_index).output_param1 = 'N' THEN
5475: --
5476: IF l_debug_on THEN
5477: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization is NOT WMS Enabled');
5478: END IF;
5479: --
5480: FND_MESSAGE.SET_NAME('WSH','WSH_STND_WMS_NOT_INSTALLED');
5481: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
5484: --OPM Enabled Check
5485: IF g_sr_org_tab(l_index).output_param2 = 'Y' THEN
5486: --
5487: IF l_debug_on THEN
5488: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization is OPM Enabled');
5489: END IF;
5490: --
5491: FND_MESSAGE.SET_NAME('WSH','WSH_STND_OPM_INSTALLED');
5492: WSH_UTIL_CORE.Add_Message(x_return_status, l_module_name );
5495: END IF;
5496:
5497: --
5498: IF l_debug_on THEN
5499: WSH_DEBUG_SV.pop(l_module_name);
5500: END IF;
5501: --
5502: EXCEPTION
5503: WHEN OTHERS THEN
5504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5505: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_SR_Organization');
5506: --
5507: IF l_debug_on THEN
5508: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5510: END IF;
5511: --
5512: END Validate_SR_Organization;
5505: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_SR_Organization');
5506: --
5507: IF l_debug_on THEN
5508: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5510: END IF;
5511: --
5512: END Validate_SR_Organization;
5513: --
5546: --
5547: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5548: --
5549: IF l_debug_on IS NULL THEN
5550: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5551: END IF;
5552: --
5553: IF l_debug_on THEN
5554: WSH_DEBUG_SV.push(l_module_name);
5550: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5551: END IF;
5552: --
5553: IF l_debug_on THEN
5554: WSH_DEBUG_SV.push(l_module_name);
5555: WSH_DEBUG_SV.log(l_module_name, 'p_locator_code', p_locator_code);
5556: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5557: END IF;
5558: --
5551: END IF;
5552: --
5553: IF l_debug_on THEN
5554: WSH_DEBUG_SV.push(l_module_name);
5555: WSH_DEBUG_SV.log(l_module_name, 'p_locator_code', p_locator_code);
5556: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5557: END IF;
5558: --
5559:
5552: --
5553: IF l_debug_on THEN
5554: WSH_DEBUG_SV.push(l_module_name);
5555: WSH_DEBUG_SV.log(l_module_name, 'p_locator_code', p_locator_code);
5556: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5557: END IF;
5558: --
5559:
5560: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5571: IF l_index is not null THEN
5572: IF l_flag = 'U' THEN --Not Found in Cache, so use this index to add in Cache
5573: --
5574: IF l_debug_on THEN
5575: WSH_DEBUG_SV.logmsg(l_module_name, 'Locator not found in cache');
5576: END IF;
5577: --
5578: g_locator_code_tab(l_index).input_param1 := p_locator_code;
5579: g_locator_code_tab(l_index).input_param2 := p_organization_id;
5596:
5597: IF g_locator_code_tab(l_index).valid_flag = 'N' THEN
5598: --
5599: IF l_debug_on THEN
5600: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Locator Code');
5601: END IF;
5602: --
5603: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5604: FND_MESSAGE.SET_NAME('WSH','WSH_STND_INVALID_LOCATOR');
5610: END IF;
5611:
5612: --
5613: IF l_debug_on THEN
5614: WSH_DEBUG_SV.log(l_module_name, 'x_locator_id', x_locator_id);
5615: WSH_DEBUG_SV.pop(l_module_name);
5616: END IF;
5617: --
5618: EXCEPTION
5611:
5612: --
5613: IF l_debug_on THEN
5614: WSH_DEBUG_SV.log(l_module_name, 'x_locator_id', x_locator_id);
5615: WSH_DEBUG_SV.pop(l_module_name);
5616: END IF;
5617: --
5618: EXCEPTION
5619: WHEN OTHERS THEN
5620: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5621: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Locator_Code');
5622: --
5623: IF l_debug_on THEN
5624: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5625: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5626: END IF;
5627: --
5628: END Validate_Locator_Code;
5621: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Locator_Code');
5622: --
5623: IF l_debug_on THEN
5624: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5625: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5626: END IF;
5627: --
5628: END Validate_Locator_Code;
5629: --
5663: --
5664: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5665: --
5666: IF l_debug_on IS NULL THEN
5667: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5668: END IF;
5669: --
5670: IF l_debug_on THEN
5671: WSH_DEBUG_SV.push(l_module_name);
5667: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5668: END IF;
5669: --
5670: IF l_debug_on THEN
5671: WSH_DEBUG_SV.push(l_module_name);
5672: WSH_DEBUG_SV.log(l_module_name, 'p_item_number', p_item_number);
5673: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5674: END IF;
5675: --
5668: END IF;
5669: --
5670: IF l_debug_on THEN
5671: WSH_DEBUG_SV.push(l_module_name);
5672: WSH_DEBUG_SV.log(l_module_name, 'p_item_number', p_item_number);
5673: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5674: END IF;
5675: --
5676:
5669: --
5670: IF l_debug_on THEN
5671: WSH_DEBUG_SV.push(l_module_name);
5672: WSH_DEBUG_SV.log(l_module_name, 'p_item_number', p_item_number);
5673: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5674: END IF;
5675: --
5676:
5677: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5689: IF l_index is not null THEN
5690: IF l_flag = 'U' THEN --Not Found in Cache, so use this index to add in Cache
5691: --
5692: IF l_debug_on THEN
5693: WSH_DEBUG_SV.logmsg(l_module_name, 'Inventory item not found in cache');
5694: END IF;
5695: --
5696: g_inventory_item_tab(l_index).input_param1 := p_item_number;
5697: g_inventory_item_tab(l_index).input_param2 := p_organization_id;
5697: g_inventory_item_tab(l_index).input_param2 := p_organization_id;
5698:
5699: --
5700: IF l_debug_on THEN
5701: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_EXTERNAL_INTERFACE_SV.Validate_Item', WSH_DEBUG_SV.C_PROC_LEVEL);
5702: END IF;
5703: --
5704: WSH_EXTERNAL_INTERFACE_SV.Validate_Item(
5705: p_concatenated_segments => p_item_number,
5719:
5720: IF g_inventory_item_tab(l_index).valid_flag = 'N' THEN
5721: --
5722: IF l_debug_on THEN
5723: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Inventory Item');
5724: END IF;
5725: --
5726: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5727: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_INV_ITEM');
5733: END IF;
5734:
5735: --
5736: IF l_debug_on THEN
5737: WSH_DEBUG_SV.log(l_module_name, 'x_inventory_item_id', x_inventory_item_id);
5738: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5739: WSH_DEBUG_SV.pop(l_module_name);
5740: END IF;
5741: --
5734:
5735: --
5736: IF l_debug_on THEN
5737: WSH_DEBUG_SV.log(l_module_name, 'x_inventory_item_id', x_inventory_item_id);
5738: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5739: WSH_DEBUG_SV.pop(l_module_name);
5740: END IF;
5741: --
5742: EXCEPTION
5735: --
5736: IF l_debug_on THEN
5737: WSH_DEBUG_SV.log(l_module_name, 'x_inventory_item_id', x_inventory_item_id);
5738: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5739: WSH_DEBUG_SV.pop(l_module_name);
5740: END IF;
5741: --
5742: EXCEPTION
5743: WHEN OTHERS THEN
5744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5745: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Item');
5746: --
5747: IF l_debug_on THEN
5748: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5749: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5750: END IF;
5751: --
5752: END Validate_Item;
5745: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Item');
5746: --
5747: IF l_debug_on THEN
5748: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5749: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5750: END IF;
5751: --
5752: END Validate_Item;
5753: --
5789: --
5790: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5791: --
5792: IF l_debug_on IS NULL THEN
5793: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5794: END IF;
5795: --
5796: IF l_debug_on THEN
5797: WSH_DEBUG_SV.push(l_module_name);
5793: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5794: END IF;
5795: --
5796: IF l_debug_on THEN
5797: WSH_DEBUG_SV.push(l_module_name);
5798: WSH_DEBUG_SV.log(l_module_name, 'p_item_number', p_item_number);
5799: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
5800: WSH_DEBUG_SV.log(l_module_name, 'p_address_id', p_address_id);
5801: END IF;
5794: END IF;
5795: --
5796: IF l_debug_on THEN
5797: WSH_DEBUG_SV.push(l_module_name);
5798: WSH_DEBUG_SV.log(l_module_name, 'p_item_number', p_item_number);
5799: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
5800: WSH_DEBUG_SV.log(l_module_name, 'p_address_id', p_address_id);
5801: END IF;
5802: --
5795: --
5796: IF l_debug_on THEN
5797: WSH_DEBUG_SV.push(l_module_name);
5798: WSH_DEBUG_SV.log(l_module_name, 'p_item_number', p_item_number);
5799: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
5800: WSH_DEBUG_SV.log(l_module_name, 'p_address_id', p_address_id);
5801: END IF;
5802: --
5803:
5796: IF l_debug_on THEN
5797: WSH_DEBUG_SV.push(l_module_name);
5798: WSH_DEBUG_SV.log(l_module_name, 'p_item_number', p_item_number);
5799: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
5800: WSH_DEBUG_SV.log(l_module_name, 'p_address_id', p_address_id);
5801: END IF;
5802: --
5803:
5804: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5817: IF l_index is not null THEN
5818: IF l_flag = 'U' THEN --Not Found in Cache, so use this index to add in Cache
5819: --
5820: IF l_debug_on THEN
5821: WSH_DEBUG_SV.logmsg(l_module_name, 'Customer item not found in cache');
5822: END IF;
5823: --
5824: g_customer_item_tab(l_index).input_param1 := p_item_number;
5825: g_customer_item_tab(l_index).input_param2 := p_customer_id;
5850: EXCEPTION
5851: WHEN NO_DATA_FOUND THEN
5852: --
5853: IF l_debug_on THEN
5854: WSH_DEBUG_SV.logmsg(l_module_name, 'Inside No-Data-Found Exception');
5855: END IF;
5856: --
5857: g_customer_item_tab(l_index).valid_flag := 'N';
5858: END;
5860:
5861: IF g_customer_item_tab(l_index).valid_flag = 'N' THEN
5862: --
5863: IF l_debug_on THEN
5864: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Customer Item');
5865: END IF;
5866: --
5867: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5868: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CUST_ITEM');
5874: END IF;
5875:
5876: --
5877: IF l_debug_on THEN
5878: WSH_DEBUG_SV.log(l_module_name, 'x_customer_item_id', x_customer_item_id);
5879: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5880: WSH_DEBUG_SV.pop(l_module_name);
5881: END IF;
5882: --
5875:
5876: --
5877: IF l_debug_on THEN
5878: WSH_DEBUG_SV.log(l_module_name, 'x_customer_item_id', x_customer_item_id);
5879: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5880: WSH_DEBUG_SV.pop(l_module_name);
5881: END IF;
5882: --
5883: EXCEPTION
5876: --
5877: IF l_debug_on THEN
5878: WSH_DEBUG_SV.log(l_module_name, 'x_customer_item_id', x_customer_item_id);
5879: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5880: WSH_DEBUG_SV.pop(l_module_name);
5881: END IF;
5882: --
5883: EXCEPTION
5884: WHEN OTHERS THEN
5885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5886: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Customer_Item');
5887: --
5888: IF l_debug_on THEN
5889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5890: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5891: END IF;
5892: --
5893: END Validate_Customer_Item;
5886: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Customer_Item');
5887: --
5888: IF l_debug_on THEN
5889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5890: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5891: END IF;
5892: --
5893: END Validate_Customer_Item;
5894: --
5934: --
5935: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5936: --
5937: IF l_debug_on IS NULL THEN
5938: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5939: END IF;
5940: --
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.push(l_module_name);
5938: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5939: END IF;
5940: --
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.push(l_module_name);
5943: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5944: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_code', p_carrier_code);
5945: WSH_DEBUG_SV.log(l_module_name, 'p_service_level', p_service_level);
5946: WSH_DEBUG_SV.log(l_module_name, 'p_mode_of_transport', p_mode_of_transport);
5939: END IF;
5940: --
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.push(l_module_name);
5943: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5944: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_code', p_carrier_code);
5945: WSH_DEBUG_SV.log(l_module_name, 'p_service_level', p_service_level);
5946: WSH_DEBUG_SV.log(l_module_name, 'p_mode_of_transport', p_mode_of_transport);
5947: END IF;
5940: --
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.push(l_module_name);
5943: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5944: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_code', p_carrier_code);
5945: WSH_DEBUG_SV.log(l_module_name, 'p_service_level', p_service_level);
5946: WSH_DEBUG_SV.log(l_module_name, 'p_mode_of_transport', p_mode_of_transport);
5947: END IF;
5948: --
5941: IF l_debug_on THEN
5942: WSH_DEBUG_SV.push(l_module_name);
5943: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5944: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_code', p_carrier_code);
5945: WSH_DEBUG_SV.log(l_module_name, 'p_service_level', p_service_level);
5946: WSH_DEBUG_SV.log(l_module_name, 'p_mode_of_transport', p_mode_of_transport);
5947: END IF;
5948: --
5949:
5942: WSH_DEBUG_SV.push(l_module_name);
5943: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id', p_organization_id);
5944: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_code', p_carrier_code);
5945: WSH_DEBUG_SV.log(l_module_name, 'p_service_level', p_service_level);
5946: WSH_DEBUG_SV.log(l_module_name, 'p_mode_of_transport', p_mode_of_transport);
5947: END IF;
5948: --
5949:
5950: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5964: IF l_index is not null THEN
5965: IF l_flag = 'U' THEN --Not Found in Cache, so use this index to add in Cache
5966: --
5967: IF l_debug_on THEN
5968: WSH_DEBUG_SV.logmsg(l_module_name, 'Ship Method Code not found in cache');
5969: END IF;
5970: --
5971: g_shipping_method_tab(l_index).input_param1 := p_organization_id;
5972: g_shipping_method_tab(l_index).input_param2 := p_carrier_code;
5975:
5976: BEGIN
5977: --
5978: IF l_debug_on THEN
5979: WSH_DEBUG_SV.logmsg(l_module_name, 'Querying Ship Method Code from table');
5980: END IF;
5981: --
5982: select ship_method_code
5983: into x_ship_method_code
5996: EXCEPTION
5997: WHEN NO_DATA_FOUND THEN
5998: --
5999: IF l_debug_on THEN
6000: WSH_DEBUG_SV.logmsg(l_module_name, 'Inside No-Data-Found Exception');
6001: END IF;
6002: --
6003: g_shipping_method_tab(l_index).valid_flag := 'N';
6004: END;
6005: END IF;
6006:
6007: --
6008: IF l_debug_on THEN
6009: WSH_DEBUG_SV.logmsg(l_module_name, 'Valid Flag => ' || g_shipping_method_tab(l_index).valid_flag);
6010: END IF;
6011: --
6012:
6013: IF g_shipping_method_tab(l_index).valid_flag = 'N' THEN
6013: IF g_shipping_method_tab(l_index).valid_flag = 'N' THEN
6014: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6015: --
6016: IF l_debug_on THEN
6017: WSH_DEBUG_SV.logmsg(l_module_name, 'Ship Method does not exists');
6018: END IF;
6019: --
6020: FND_MESSAGE.SET_NAME('WSH','WSH_STND_INVALID_SM');
6021: FND_MESSAGE.SET_TOKEN('CARRIER', p_carrier_code);
6029: END IF;
6030:
6031: --
6032: IF l_debug_on THEN
6033: WSH_DEBUG_SV.log(l_module_name, 'x_ship_method_code', x_ship_method_code);
6034: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
6035: WSH_DEBUG_SV.pop(l_module_name);
6036: END IF;
6037: --
6030:
6031: --
6032: IF l_debug_on THEN
6033: WSH_DEBUG_SV.log(l_module_name, 'x_ship_method_code', x_ship_method_code);
6034: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
6035: WSH_DEBUG_SV.pop(l_module_name);
6036: END IF;
6037: --
6038: EXCEPTION
6031: --
6032: IF l_debug_on THEN
6033: WSH_DEBUG_SV.log(l_module_name, 'x_ship_method_code', x_ship_method_code);
6034: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
6035: WSH_DEBUG_SV.pop(l_module_name);
6036: END IF;
6037: --
6038: EXCEPTION
6039: WHEN OTHERS THEN
6040: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6041: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');
6042: --
6043: IF l_debug_on THEN
6044: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6045: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6046: END IF;
6047: --
6048: END Validate_Ship_Method;
6041: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');
6042: --
6043: IF l_debug_on THEN
6044: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6045: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6046: END IF;
6047: --
6048: END Validate_Ship_Method;
6049: --
6091: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
6092: --
6093: IF l_debug_on IS NULL
6094: THEN
6095: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
6096: END IF;
6097: --
6098: IF l_debug_on THEN
6099: WSH_DEBUG_SV.push(l_module_name);
6095: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
6096: END IF;
6097: --
6098: IF l_debug_on THEN
6099: WSH_DEBUG_SV.push(l_module_name);
6100: WSH_DEBUG_SV.log(l_module_name,'p_freight_code', p_freight_code);
6101: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
6102: END IF;
6103:
6096: END IF;
6097: --
6098: IF l_debug_on THEN
6099: WSH_DEBUG_SV.push(l_module_name);
6100: WSH_DEBUG_SV.log(l_module_name,'p_freight_code', p_freight_code);
6101: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
6102: END IF;
6103:
6104: x_return_status := wsh_util_core.g_ret_sts_success;
6097: --
6098: IF l_debug_on THEN
6099: WSH_DEBUG_SV.push(l_module_name);
6100: WSH_DEBUG_SV.log(l_module_name,'p_freight_code', p_freight_code);
6101: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
6102: END IF;
6103:
6104: x_return_status := wsh_util_core.g_ret_sts_success;
6105:
6116: --}
6117: END IF;
6118:
6119: IF l_debug_on THEN
6120: WSH_DEBUG_SV.pop(l_module_name);
6121: END IF;
6122:
6123: EXCEPTION
6124:
6130: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6131:
6132: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Freight_Code');
6133: IF l_debug_on THEN
6134: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6135: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6136: END IF;
6137: --}
6138: END Validate_Freight_Code;
6131:
6132: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Freight_Code');
6133: IF l_debug_on THEN
6134: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6135: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6136: END IF;
6137: --}
6138: END Validate_Freight_Code;
6139: