[Home] [Help]
208: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
209: --
210: IF l_debug_on IS NULL
211: THEN
212: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
213: END IF;
214: --
215: IF l_debug_on THEN
216: WSH_DEBUG_SV.push(l_module_name);
212: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
213: END IF;
214: --
215: IF l_debug_on THEN
216: WSH_DEBUG_SV.push(l_module_name);
217: --
218: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
219: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CODE',P_ORG_CODE);
220: END IF;
214: --
215: IF l_debug_on THEN
216: WSH_DEBUG_SV.push(l_module_name);
217: --
218: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
219: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CODE',P_ORG_CODE);
220: END IF;
221: --
222: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
215: IF l_debug_on THEN
216: WSH_DEBUG_SV.push(l_module_name);
217: --
218: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
219: WSH_DEBUG_SV.log(l_module_name,'P_ORG_CODE',P_ORG_CODE);
220: END IF;
221: --
222: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
223: l_failed := FALSE;
240: wsh_util_core.add_message(x_return_status,l_module_name);
241: END IF;
242: --
243: IF l_debug_on THEN
244: WSH_DEBUG_SV.log(l_module_name,'p_org_id',p_org_id);
245: WSH_DEBUG_SV.pop(l_module_name);
246: END IF;
247: --
248: EXCEPTION
241: END IF;
242: --
243: IF l_debug_on THEN
244: WSH_DEBUG_SV.log(l_module_name,'p_org_id',p_org_id);
245: WSH_DEBUG_SV.pop(l_module_name);
246: END IF;
247: --
248: EXCEPTION
249: WHEN OTHERS THEN
256: CLOSE check_org_code;
257: END IF;
258: --
259: IF l_debug_on THEN
260: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
262: END IF;
263:
264: END Validate_Org;
257: END IF;
258: --
259: IF l_debug_on THEN
260: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
262: END IF;
263:
264: END Validate_Org;
265:
311: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
312: --
313: IF l_debug_on IS NULL
314: THEN
315: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
316: END IF;
317: --
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.push(l_module_name);
315: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
316: END IF;
317: --
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.push(l_module_name);
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
322: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
323: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
317: --
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.push(l_module_name);
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
322: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
323: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
324: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
325: END IF;
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.push(l_module_name);
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
322: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
323: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
324: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
325: END IF;
326: --
319: WSH_DEBUG_SV.push(l_module_name);
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
322: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
323: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
324: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
325: END IF;
326: --
327: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
320: --
321: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
322: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_CODE',P_LOCATION_CODE);
323: WSH_DEBUG_SV.log(l_module_name,'p_isWshLocation',p_isWshLocation);
324: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
325: END IF;
326: --
327: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
328: IF p_isWshLocation THEN
336: END IF;
337:
338: IF p_location_id IS NOT NULL THEN
339: IF l_debug_on THEN
340: WSH_DEBUG_SV.log(l_module_name,'Calling Transfer_Location');
341: END IF;
342:
343: WSH_MAP_LOCATION_REGION_PKG.Transfer_Location (
344: p_source_type => l_source_loc_type,
349: x_loc_rec => l_loc_rec,
350: x_return_status => l_return_status);
351:
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
354: END IF;
355:
356: wsh_util_core.api_post_call(
357: p_return_status => l_return_status,
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370:
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_module_name,'inactive_date',
373: l_loc_rec.inactive_date);
374: WSH_DEBUG_SV.log(l_module_name,'l_sysdate',l_sysdate);
375: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
376: WSH_DEBUG_SV.pop(l_module_name);
370:
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_module_name,'inactive_date',
373: l_loc_rec.inactive_date);
374: WSH_DEBUG_SV.log(l_module_name,'l_sysdate',l_sysdate);
375: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
376: WSH_DEBUG_SV.pop(l_module_name);
377: END IF;
378: RETURN;
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_module_name,'inactive_date',
373: l_loc_rec.inactive_date);
374: WSH_DEBUG_SV.log(l_module_name,'l_sysdate',l_sysdate);
375: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
376: WSH_DEBUG_SV.pop(l_module_name);
377: END IF;
378: RETURN;
379: ELSIF NVL(p_location_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
372: WSH_DEBUG_SV.log(l_module_name,'inactive_date',
373: l_loc_rec.inactive_date);
374: WSH_DEBUG_SV.log(l_module_name,'l_sysdate',l_sysdate);
375: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
376: WSH_DEBUG_SV.pop(l_module_name);
377: END IF;
378: RETURN;
379: ELSIF NVL(p_location_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
380: AND p_location_id IS NULL
386: WHERE location_code = p_location_code
387: AND TRUNC(l_sysdate)
388: <= NVL(inactive_date ,TRUNC(l_sysdate));
389: IF l_debug_on THEN
390: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
391: END IF;
392: --
393: p_location_id := l_location_id;
394: IF l_debug_on THEN
391: END IF;
392: --
393: p_location_id := l_location_id;
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
396: WSH_DEBUG_SV.pop(l_module_name);
397: END IF;
398: RETURN;
399:
392: --
393: p_location_id := l_location_id;
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
396: WSH_DEBUG_SV.pop(l_module_name);
397: END IF;
398: RETURN;
399:
400: EXCEPTION
404: OPEN check_location;
405: FETCH check_location
406: INTO l_location_id;
407: IF l_debug_on THEN
408: WSH_DEBUG_SV.log(l_module_name,'cursor l_location_id',
409: l_location_id);
410: END IF;
411: IF check_location%NOTFOUND THEN
412: RAISE FND_API.G_EXC_ERROR;
414: FETCH check_location
415: INTO l_location_id2;
416: IF l_location_id2 IS NOT NULL THEN
417: IF l_debug_on THEN
418: WSH_DEBUG_SV.log(l_module_name,'Too Many ROws',
419: l_location_id2);
420: END IF;
421: RAISE FND_API.G_EXC_ERROR;
422: END IF;
423: END IF;
424: END;
425:
426: IF l_debug_on THEN
427: WSH_DEBUG_SV.log(l_module_name,'Calling Transfer_Location');
428: END IF;
429:
430: WSH_MAP_LOCATION_REGION_PKG.Transfer_Location (
431: p_source_type => 'HR',
435: p_online_region_mapping => FALSE,
436: x_loc_rec => l_loc_rec,
437: x_return_status => l_return_status);
438: IF l_debug_on THEN
439: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
440: END IF;
441:
442: wsh_util_core.api_post_call(
443: p_return_status => l_return_status,
450: p_location_id := l_loc_rec.wsh_location_id;
451:
452: ELSE
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.log(l_module_name,'Both parameters are null');
455: END IF;
456: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
457: --bug 2648157
458: END IF;
458: END IF;
459:
460: --
461: IF l_debug_on THEN
462: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
463: WSH_DEBUG_SV.pop(l_module_name);
464: END IF;
465: --
466: EXCEPTION
459:
460: --
461: IF l_debug_on THEN
462: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
463: WSH_DEBUG_SV.pop(l_module_name);
464: END IF;
465: --
466: EXCEPTION
467:
469: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
471: wsh_util_core.add_message(x_return_status,l_module_name);
472: IF l_debug_on THEN
473: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_ERROR');
474: END IF;
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
477: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
476: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
477: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
478: wsh_util_core.add_message(x_return_status,l_module_name);
479: IF l_debug_on THEN
480: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_UNEXPECTED_ERROR');
481: END IF;
482: WHEN OTHERS THEN
483: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
484: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOCATION');
483: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
484: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOCATION');
485: --
486: IF l_debug_on THEN
487: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
488: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
489: END IF;
490:
491: END Validate_Location;
484: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOCATION');
485: --
486: IF l_debug_on THEN
487: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
488: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
489: END IF;
490:
491: END Validate_Location;
492:
538: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
539: --
540: IF l_debug_on IS NULL
541: THEN
542: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
543: END IF;
544: --
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.push(l_module_name);
542: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
543: END IF;
544: --
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.push(l_module_name);
547: --
548: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
549: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
550: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
544: --
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.push(l_module_name);
547: --
548: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
549: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
550: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
551: END IF;
552: --
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.push(l_module_name);
547: --
548: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
549: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
550: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
551: END IF;
552: --
553: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
546: WSH_DEBUG_SV.push(l_module_name);
547: --
548: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
549: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
550: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
551: END IF;
552: --
553: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
554:
610:
611: END IF;
612: --
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.log(l_module_name,'p_lookup_code',p_lookup_code);
615: WSH_DEBUG_SV.pop(l_module_name);
616: END IF;
617: --
618: END Validate_Lookup;
611: END IF;
612: --
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.log(l_module_name,'p_lookup_code',p_lookup_code);
615: WSH_DEBUG_SV.pop(l_module_name);
616: END IF;
617: --
618: END Validate_Lookup;
619:
656: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
657: --
658: IF l_debug_on IS NULL
659: THEN
660: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
661: END IF;
662: --
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.push(l_module_name);
660: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
661: END IF;
662: --
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.push(l_module_name);
665: --
666: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
667: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_NUMBER',P_CUSTOMER_NUMBER);
668: END IF;
662: --
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.push(l_module_name);
665: --
666: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
667: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_NUMBER',P_CUSTOMER_NUMBER);
668: END IF;
669: --
670: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.push(l_module_name);
665: --
666: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
667: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_NUMBER',P_CUSTOMER_NUMBER);
668: END IF;
669: --
670: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
671:
688:
689: END IF;
690: --
691: IF l_debug_on THEN
692: WSH_DEBUG_SV.log(l_module_name,'p_customer_id',p_customer_id);
693: WSH_DEBUG_SV.pop(l_module_name);
694: END IF;
695: --
696: END Validate_Customer;
689: END IF;
690: --
691: IF l_debug_on THEN
692: WSH_DEBUG_SV.log(l_module_name,'p_customer_id',p_customer_id);
693: WSH_DEBUG_SV.pop(l_module_name);
694: END IF;
695: --
696: END Validate_Customer;
697:
724: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
725: --
726: IF l_debug_on IS NULL
727: THEN
728: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
729: END IF;
730: --
731: IF l_debug_on THEN
732: WSH_DEBUG_SV.push(l_module_name);
728: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
729: END IF;
730: --
731: IF l_debug_on THEN
732: WSH_DEBUG_SV.push(l_module_name);
733: --
734: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
735: END IF;
736: --
730: --
731: IF l_debug_on THEN
732: WSH_DEBUG_SV.push(l_module_name);
733: --
734: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
735: END IF;
736: --
737: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
738:
753:
754: END IF;
755: --
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.log(l_module_name,'p_contact_id',p_contact_id);
758: WSH_DEBUG_SV.pop(l_module_name);
759: END IF;
760: --
761: END Validate_Contact;
754: END IF;
755: --
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.log(l_module_name,'p_contact_id',p_contact_id);
758: WSH_DEBUG_SV.pop(l_module_name);
759: END IF;
760: --
761: END Validate_Contact;
762:
783: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
784: --
785: IF l_debug_on IS NULL
786: THEN
787: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
788: END IF;
789: --
790: IF l_debug_on THEN
791: WSH_DEBUG_SV.push(l_module_name);
787: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
788: END IF;
789: --
790: IF l_debug_on THEN
791: WSH_DEBUG_SV.push(l_module_name);
792: --
793: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
794: END IF;
795: --
789: --
790: IF l_debug_on THEN
791: WSH_DEBUG_SV.push(l_module_name);
792: --
793: WSH_DEBUG_SV.log(l_module_name,'P_QUANTITY',P_QUANTITY);
794: END IF;
795: --
796: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
797:
808:
809: END IF;
810: --
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.pop(l_module_name);
813: END IF;
814: --
815: END Validate_Quantity;
816:
836: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
837: --
838: IF l_debug_on IS NULL
839: THEN
840: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
841: END IF;
842: --
843: IF l_debug_on THEN
844: WSH_DEBUG_SV.push(l_module_name);
840: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
841: END IF;
842: --
843: IF l_debug_on THEN
844: WSH_DEBUG_SV.push(l_module_name);
845: --
846: WSH_DEBUG_SV.log(l_module_name,'P_VALUE',P_VALUE);
847: END IF;
848: --
842: --
843: IF l_debug_on THEN
844: WSH_DEBUG_SV.push(l_module_name);
845: --
846: WSH_DEBUG_SV.log(l_module_name,'P_VALUE',P_VALUE);
847: END IF;
848: --
849: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
850:
860:
861: END IF;
862: --
863: IF l_debug_on THEN
864: WSH_DEBUG_SV.pop(l_module_name);
865: END IF;
866: --
867: END Validate_Negative;
868: */
891: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
892: --
893: IF l_debug_on IS NULL
894: THEN
895: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
896: END IF;
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.push(l_module_name);
895: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
896: END IF;
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.push(l_module_name);
900: --
901: WSH_DEBUG_SV.log(l_module_name,'P_VALUE',P_VALUE);
902: END IF;
903: --
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.push(l_module_name);
900: --
901: WSH_DEBUG_SV.log(l_module_name,'P_VALUE',P_VALUE);
902: END IF;
903: --
904: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
905:
916:
917: END IF;
918: --
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.pop(l_module_name);
921: END IF;
922: --
923: END Validate_Negative;
924:
973: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
974: --
975: IF l_debug_on IS NULL
976: THEN
977: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
978: END IF;
979: --
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.push(l_module_name);
977: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
978: END IF;
979: --
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.push(l_module_name);
982: --
983: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
984: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
985: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
979: --
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.push(l_module_name);
982: --
983: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
984: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
985: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
986: WSH_DEBUG_SV.log(l_module_name,'P_OTM_ENABLED',P_OTM_ENABLED); -- OTM R12
987: END IF;
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.push(l_module_name);
982: --
983: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
984: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
985: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
986: WSH_DEBUG_SV.log(l_module_name,'P_OTM_ENABLED',P_OTM_ENABLED); -- OTM R12
987: END IF;
988: --
981: WSH_DEBUG_SV.push(l_module_name);
982: --
983: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
984: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
985: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
986: WSH_DEBUG_SV.log(l_module_name,'P_OTM_ENABLED',P_OTM_ENABLED); -- OTM R12
987: END IF;
988: --
989: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
982: --
983: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
984: WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_NAME',P_CURRENCY_NAME);
985: WSH_DEBUG_SV.log(l_module_name,'P_AMOUNT',P_AMOUNT);
986: WSH_DEBUG_SV.log(l_module_name,'P_OTM_ENABLED',P_OTM_ENABLED); -- OTM R12
987: END IF;
988: --
989: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
990:
1015:
1016: CLOSE currency_cursor;
1017:
1018: IF l_debug_on THEN
1019: WSH_DEBUG_SV.log(l_module_name,'l_in_precision',l_in_precision);
1020: WSH_DEBUG_SV.log(l_module_name,'l_precision',l_precision);
1021: END IF;
1022:
1023: x_adjusted_amount := p_amount;
1016: CLOSE currency_cursor;
1017:
1018: IF l_debug_on THEN
1019: WSH_DEBUG_SV.log(l_module_name,'l_in_precision',l_in_precision);
1020: WSH_DEBUG_SV.log(l_module_name,'l_precision',l_precision);
1021: END IF;
1022:
1023: x_adjusted_amount := p_amount;
1024:
1028: IF p_otm_enabled = 'Y' THEN
1029: -- truncate the amount to the precision specified in setup
1030: x_adjusted_amount := ROUND(p_amount,l_precision);
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.log(l_module_name,'Adjusted amount:',x_adjusted_amount);
1033: END IF;
1034: ELSE
1035: -- existing code
1036: error_code := 'CURR-Precision';
1047: END IF;
1048: --
1049: IF l_debug_on THEN
1050: -- OTM R12
1051: WSH_DEBUG_SV.log(l_module_name,'x_adjusted_amount ',x_adjusted_amount);
1052: WSH_DEBUG_SV.pop(l_module_name);
1053: END IF;
1054: --
1055: EXCEPTION
1048: --
1049: IF l_debug_on THEN
1050: -- OTM R12
1051: WSH_DEBUG_SV.log(l_module_name,'x_adjusted_amount ',x_adjusted_amount);
1052: WSH_DEBUG_SV.pop(l_module_name);
1053: END IF;
1054: --
1055: EXCEPTION
1056: -- OTM R12
1057: WHEN l_invalid_currency THEN
1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1059: WSH_UTIL_CORE.add_message(x_return_status,l_module_name);
1060: IF l_debug_on THEN
1061: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid or NULL currency exception ');
1062: WSH_DEBUG_SV.pop(l_module_name);
1063: END IF;
1064: WHEN OTHERS THEN
1065: IF currency_cursor%ISOPEN THEN
1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1059: WSH_UTIL_CORE.add_message(x_return_status,l_module_name);
1060: IF l_debug_on THEN
1061: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid or NULL currency exception ');
1062: WSH_DEBUG_SV.pop(l_module_name);
1063: END IF;
1064: WHEN OTHERS THEN
1065: IF currency_cursor%ISOPEN THEN
1066: CLOSE currency_cursor;
1067: END IF;
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1069: WSH_UTIL_CORE.default_handler('WSH_UTIL_VALIDATE.Validate_Currency');
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1072: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1073: END IF;
1074:
1075: END Validate_Currency;
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1069: WSH_UTIL_CORE.default_handler('WSH_UTIL_VALIDATE.Validate_Currency');
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1072: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1073: END IF;
1074:
1075: END Validate_Currency;
1076:
1137: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1138: --
1139: IF l_debug_on IS NULL
1140: THEN
1141: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1142: END IF;
1143: --
1144: IF l_debug_on THEN
1145: WSH_DEBUG_SV.push(l_module_name);
1141: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1142: END IF;
1143: --
1144: IF l_debug_on THEN
1145: WSH_DEBUG_SV.push(l_module_name);
1146: --
1147: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1148: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1149: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1143: --
1144: IF l_debug_on THEN
1145: WSH_DEBUG_SV.push(l_module_name);
1146: --
1147: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1148: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1149: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1150: WSH_DEBUG_SV.log(l_module_name,'P_UOM_DESC',P_UOM_DESC);
1151: END IF;
1144: IF l_debug_on THEN
1145: WSH_DEBUG_SV.push(l_module_name);
1146: --
1147: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1148: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1149: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1150: WSH_DEBUG_SV.log(l_module_name,'P_UOM_DESC',P_UOM_DESC);
1151: END IF;
1152: --
1145: WSH_DEBUG_SV.push(l_module_name);
1146: --
1147: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1148: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1149: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1150: WSH_DEBUG_SV.log(l_module_name,'P_UOM_DESC',P_UOM_DESC);
1151: END IF;
1152: --
1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1146: --
1147: WSH_DEBUG_SV.log(l_module_name,'P_TYPE',P_TYPE);
1148: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1149: WSH_DEBUG_SV.log(l_module_name,'P_UOM_CODE',P_UOM_CODE);
1150: WSH_DEBUG_SV.log(l_module_name,'P_UOM_DESC',P_UOM_DESC);
1151: END IF;
1152: --
1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1154:
1255: ELSE
1256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1257: --
1258: IF l_debug_on THEN
1259: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
1260: END IF;
1261: --
1262: RETURN;
1263: END IF;
1264: -- End of Bug 3821688 for 2nd Cursor
1265: END IF;
1266: --
1267: IF l_debug_on THEN
1268: WSH_DEBUG_SV.log(l_module_name,'p_uom_code',p_uom_code);
1269: WSH_DEBUG_SV.pop(l_module_name);
1270: END IF;
1271: --
1272: END Validate_Uom;
1265: END IF;
1266: --
1267: IF l_debug_on THEN
1268: WSH_DEBUG_SV.log(l_module_name,'p_uom_code',p_uom_code);
1269: WSH_DEBUG_SV.pop(l_module_name);
1270: END IF;
1271: --
1272: END Validate_Uom;
1273:
1309: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1310: --
1311: IF l_debug_on IS NULL
1312: THEN
1313: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1314: END IF;
1315: --
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.push(l_module_name);
1313: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1314: END IF;
1315: --
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.push(l_module_name);
1318: --
1319: WSH_DEBUG_SV.log(l_module_name,'P_USER_ID',P_USER_ID);
1320: WSH_DEBUG_SV.log(l_module_name,'P_USER_NAME',P_USER_NAME);
1321: END IF;
1315: --
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.push(l_module_name);
1318: --
1319: WSH_DEBUG_SV.log(l_module_name,'P_USER_ID',P_USER_ID);
1320: WSH_DEBUG_SV.log(l_module_name,'P_USER_NAME',P_USER_NAME);
1321: END IF;
1322: --
1323: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.push(l_module_name);
1318: --
1319: WSH_DEBUG_SV.log(l_module_name,'P_USER_ID',P_USER_ID);
1320: WSH_DEBUG_SV.log(l_module_name,'P_USER_NAME',P_USER_NAME);
1321: END IF;
1322: --
1323: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1324:
1339:
1340: END IF;
1341: --
1342: IF l_debug_on THEN
1343: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
1344: WSH_DEBUG_SV.pop(l_module_name);
1345: END IF;
1346: --
1347: END Validate_User;
1340: END IF;
1341: --
1342: IF l_debug_on THEN
1343: WSH_DEBUG_SV.log(l_module_name,'p_user_id',p_user_id);
1344: WSH_DEBUG_SV.pop(l_module_name);
1345: END IF;
1346: --
1347: END Validate_User;
1348:
1390: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1391: --
1392: IF l_debug_on IS NULL
1393: THEN
1394: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1395: END IF;
1396: --
1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.push(l_module_name);
1394: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1395: END IF;
1396: --
1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.push(l_module_name);
1399: --
1400: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
1401: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
1402: END IF;
1396: --
1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.push(l_module_name);
1399: --
1400: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
1401: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
1402: END IF;
1403: --
1404: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.push(l_module_name);
1399: --
1400: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
1401: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
1402: END IF;
1403: --
1404: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1405: --
1467: --
1468: END IF;
1469: --
1470: IF l_debug_on THEN
1471: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
1472: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
1473: WSH_DEBUG_SV.pop(l_module_name);
1474: END IF;
1475: --
1468: END IF;
1469: --
1470: IF l_debug_on THEN
1471: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
1472: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
1473: WSH_DEBUG_SV.pop(l_module_name);
1474: END IF;
1475: --
1476: EXCEPTION
1469: --
1470: IF l_debug_on THEN
1471: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
1472: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
1473: WSH_DEBUG_SV.pop(l_module_name);
1474: END IF;
1475: --
1476: EXCEPTION
1477: WHEN OTHERS THEN
1477: WHEN OTHERS THEN
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1479: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1482: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1483: END IF;
1484: END Validate_Ship_Method;
1485:
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1479: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1482: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1483: END IF;
1484: END Validate_Ship_Method;
1485:
1486: --========================================================================
1506: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1507: --
1508: IF l_debug_on IS NULL
1509: THEN
1510: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1511: END IF;
1512: --
1513: IF l_debug_on THEN
1514: WSH_DEBUG_SV.push(l_module_name);
1510: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1511: END IF;
1512: --
1513: IF l_debug_on THEN
1514: WSH_DEBUG_SV.push(l_module_name);
1515: --
1516: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
1517: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_NAME',P_FREIGHT_TERMS_NAME);
1518: END IF;
1512: --
1513: IF l_debug_on THEN
1514: WSH_DEBUG_SV.push(l_module_name);
1515: --
1516: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
1517: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_NAME',P_FREIGHT_TERMS_NAME);
1518: END IF;
1519: --
1520: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1513: IF l_debug_on THEN
1514: WSH_DEBUG_SV.push(l_module_name);
1515: --
1516: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
1517: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_NAME',P_FREIGHT_TERMS_NAME);
1518: END IF;
1519: --
1520: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1521:
1539:
1540: END IF;
1541: --
1542: IF l_debug_on THEN
1543: WSH_DEBUG_SV.pop(l_module_name);
1544: END IF;
1545: --
1546: END Validate_Freight_Terms;
1547:
1567: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1568: --
1569: IF l_debug_on IS NULL
1570: THEN
1571: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1572: END IF;
1573: --
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.push(l_module_name);
1571: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1572: END IF;
1573: --
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.push(l_module_name);
1576: --
1577: WSH_DEBUG_SV.log(l_module_name,'P_FOB_CODE',P_FOB_CODE);
1578: WSH_DEBUG_SV.log(l_module_name,'P_FOB_NAME',P_FOB_NAME);
1579: END IF;
1573: --
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.push(l_module_name);
1576: --
1577: WSH_DEBUG_SV.log(l_module_name,'P_FOB_CODE',P_FOB_CODE);
1578: WSH_DEBUG_SV.log(l_module_name,'P_FOB_NAME',P_FOB_NAME);
1579: END IF;
1580: --
1581: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.push(l_module_name);
1576: --
1577: WSH_DEBUG_SV.log(l_module_name,'P_FOB_CODE',P_FOB_CODE);
1578: WSH_DEBUG_SV.log(l_module_name,'P_FOB_NAME',P_FOB_NAME);
1579: END IF;
1580: --
1581: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1582:
1598:
1599: END IF;
1600: --
1601: IF l_debug_on THEN
1602: WSH_DEBUG_SV.pop(l_module_name);
1603: END IF;
1604: --
1605: END Validate_FOB;
1606:
1668: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1669: --
1670: IF l_debug_on IS NULL
1671: THEN
1672: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1673: END IF;
1674: --
1675: IF l_debug_on THEN
1676: WSH_DEBUG_SV.push(l_module_name);
1672: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1673: END IF;
1674: --
1675: IF l_debug_on THEN
1676: WSH_DEBUG_SV.push(l_module_name);
1677: --
1678: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1679: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1680: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1674: --
1675: IF l_debug_on THEN
1676: WSH_DEBUG_SV.push(l_module_name);
1677: --
1678: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1679: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1680: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1681: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1682: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1675: IF l_debug_on THEN
1676: WSH_DEBUG_SV.push(l_module_name);
1677: --
1678: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1679: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1680: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1681: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1682: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1683: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1676: WSH_DEBUG_SV.push(l_module_name);
1677: --
1678: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1679: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1680: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1681: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1682: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1683: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1684: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1677: --
1678: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1679: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1680: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1681: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1682: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1683: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1684: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1685: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1678: WSH_DEBUG_SV.log(l_module_name,'P_ID',P_ID);
1679: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1680: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1681: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1682: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1683: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1684: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1685: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1686: END IF;
1679: WSH_DEBUG_SV.log(l_module_name,'P_CONCAT_SEGS',P_CONCAT_SEGS);
1680: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1681: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1682: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1683: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1684: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1685: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1686: END IF;
1687: --
1680: WSH_DEBUG_SV.log(l_module_name,'P_APP_SHORT_NAME',P_APP_SHORT_NAME);
1681: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1682: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1683: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1684: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1685: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1686: END IF;
1687: --
1688: --IF p_id IS NOT NULL THEN
1681: WSH_DEBUG_SV.log(l_module_name,'P_KEY_FLX_CODE',P_KEY_FLX_CODE);
1682: WSH_DEBUG_SV.log(l_module_name,'P_STRUCT_NUMBER',P_STRUCT_NUMBER);
1683: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1684: WSH_DEBUG_SV.log(l_module_name,'P_VAL_OR_IDS',P_VAL_OR_IDS);
1685: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1686: END IF;
1687: --
1688: --IF p_id IS NOT NULL THEN
1689: IF NVL(p_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1696: data_set => p_org_id);
1697:
1698: p_id := fnd_flex_keyval.combination_id;
1699: IF l_debug_on THEN
1700: WSH_DEBUG_SV.log(l_module_name,'x_flag',x_flag);
1701: WSH_DEBUG_SV.log(l_module_name,'p_id',p_id);
1702: END IF;
1703: ELSIF p_id IS NULL OR p_id = FND_API.G_MISS_NUM THEN
1704: If l_debug_on THEN
1697:
1698: p_id := fnd_flex_keyval.combination_id;
1699: IF l_debug_on THEN
1700: WSH_DEBUG_SV.log(l_module_name,'x_flag',x_flag);
1701: WSH_DEBUG_SV.log(l_module_name,'p_id',p_id);
1702: END IF;
1703: ELSIF p_id IS NULL OR p_id = FND_API.G_MISS_NUM THEN
1704: If l_debug_on THEN
1705: wsh_debug_sv.logmsg(l_module_name, 'Calling set session mode');
1701: WSH_DEBUG_SV.log(l_module_name,'p_id',p_id);
1702: END IF;
1703: ELSIF p_id IS NULL OR p_id = FND_API.G_MISS_NUM THEN
1704: If l_debug_on THEN
1705: wsh_debug_sv.logmsg(l_module_name, 'Calling set session mode');
1706: END IF;
1707:
1708: fnd_flex_key_api.set_session_mode(session_mode =>'seed_data');
1709:
1707:
1708: fnd_flex_key_api.set_session_mode(session_mode =>'seed_data');
1709:
1710: If l_debug_on THEN
1711: wsh_debug_sv.logmsg(l_module_name, 'Calling find flexfield');
1712: END IF;
1713:
1714:
1715: ffield := fnd_flex_key_api.find_flexfield(p_app_short_name, p_key_flx_code);
1721: key_flex_code => p_key_flx_code,
1722: structure_number => p_struct_number);
1723:
1724: If l_debug_on THEN
1725: wsh_debug_sv.log(l_module_name, 'delimiter', delimiter);
1726: wsh_debug_sv.log(l_module_name, 'nsegs', nsegs);
1727: END IF;
1728:
1729: IF (delimiter IS NOT NULL) THEN
1722: structure_number => p_struct_number);
1723:
1724: If l_debug_on THEN
1725: wsh_debug_sv.log(l_module_name, 'delimiter', delimiter);
1726: wsh_debug_sv.log(l_module_name, 'nsegs', nsegs);
1727: END IF;
1728:
1729: IF (delimiter IS NOT NULL) THEN
1730: concat_string := '';
1732: FOR i IN 1..nsegs LOOP
1733: fsegment := fnd_flex_key_api.find_segment(ffield, fstruct, slist(i));
1734: charcol := fsegment.column_name;
1735: if l_debug_on then
1736: wsh_debug_sv.log(l_module_name, 'charcol', charcol);
1737: end if;
1738: charcol := substr(charcol, 8, length(fsegment.column_name));
1739: numbcol := to_number(charcol);
1740: if l_debug_on then
1737: end if;
1738: charcol := substr(charcol, 8, length(fsegment.column_name));
1739: numbcol := to_number(charcol);
1740: if l_debug_on then
1741: wsh_debug_sv.log(l_module_name, 'numcol', numbcol);
1742: end if;
1743: concat_string := concat_string||p_seg_array(numbcol);
1744: END LOOP;
1745:
1743: concat_string := concat_string||p_seg_array(numbcol);
1744: END LOOP;
1745:
1746: If l_debug_on THEN
1747: wsh_debug_sv.logmsg(l_module_name, 'Calling validate_segs');
1748: END IF;
1749:
1750: x_flag := fnd_flex_keyval.validate_segs(
1751: operation =>'CHECK_COMBINATION',
1757: values_or_ids => p_val_or_ids,
1758: where_clause => p_wh_clause );
1759:
1760: If l_debug_on THEN
1761: wsh_debug_sv.log(l_module_name, 'x_flag', x_flag);
1762: END IF;
1763:
1764: p_id := fnd_flex_keyval.combination_id;
1765:
1783:
1784: END IF; -- id is null
1785: --
1786: IF l_debug_on THEN
1787: WSH_DEBUG_SV.pop(l_module_name);
1788: END IF;
1789: --
1790: EXCEPTION
1791: WHEN delimiter_null THEN
1792: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_DELIMITER_NULL');
1793: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1794: --
1795: IF l_debug_on THEN
1796: WSH_DEBUG_SV.logmsg(l_module_name,'DELIMITER_NULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1797: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIMITER_NULL');
1798: END IF;
1799: --
1800: WHEN wrong_combination THEN
1793: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1794: --
1795: IF l_debug_on THEN
1796: WSH_DEBUG_SV.logmsg(l_module_name,'DELIMITER_NULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1797: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIMITER_NULL');
1798: END IF;
1799: --
1800: WHEN wrong_combination THEN
1801: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_INV_COMB_ERROR');
1801: FND_MESSAGE.SET_NAME('WSH','WSH_OI_FLEX_INV_COMB_ERROR');
1802: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1803: --
1804: IF l_debug_on THEN
1805: WSH_DEBUG_SV.logmsg(l_module_name,'WRONG_COMBINATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1806: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_COMBINATION');
1807: END IF;
1808: --
1809: WHEN others THEN
1802: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1803: --
1804: IF l_debug_on THEN
1805: WSH_DEBUG_SV.logmsg(l_module_name,'WRONG_COMBINATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1806: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WRONG_COMBINATION');
1807: END IF;
1808: --
1809: WHEN others THEN
1810: IF l_debug_on THEN
1807: END IF;
1808: --
1809: WHEN others THEN
1810: IF l_debug_on THEN
1811: WSH_DEBUG_SV.log(l_module_name, 'Exception:', fnd_flex_key_api.message);
1812: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1813: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1814: END IF;
1815: END Validate_Flexfields;
1808: --
1809: WHEN others THEN
1810: IF l_debug_on THEN
1811: WSH_DEBUG_SV.log(l_module_name, 'Exception:', fnd_flex_key_api.message);
1812: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1813: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1814: END IF;
1815: END Validate_Flexfields;
1816:
1809: WHEN others THEN
1810: IF l_debug_on THEN
1811: WSH_DEBUG_SV.log(l_module_name, 'Exception:', fnd_flex_key_api.message);
1812: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1813: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1814: END IF;
1815: END Validate_Flexfields;
1816:
1817: --========================================================================
1847: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1848: --
1849: IF l_debug_on IS NULL
1850: THEN
1851: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1852: END IF;
1853: --
1854: IF l_debug_on THEN
1855: WSH_DEBUG_SV.push(l_module_name);
1851: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1852: END IF;
1853: --
1854: IF l_debug_on THEN
1855: WSH_DEBUG_SV.push(l_module_name);
1856: --
1857: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1858: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
1859: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1853: --
1854: IF l_debug_on THEN
1855: WSH_DEBUG_SV.push(l_module_name);
1856: --
1857: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1858: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
1859: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1860: END IF;
1861: --
1854: IF l_debug_on THEN
1855: WSH_DEBUG_SV.push(l_module_name);
1856: --
1857: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1858: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
1859: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1860: END IF;
1861: --
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1855: WSH_DEBUG_SV.push(l_module_name);
1856: --
1857: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1858: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
1859: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1860: END IF;
1861: --
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1863:
1866: AND p_seg_array.count = 0
1867: THEN
1868:
1869: IF l_debug_on THEN
1870: WSH_DEBUG_SV.pop(l_module_name);
1871: END IF;
1872: RETURN;
1873: END IF;
1874: --
1888: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');
1889: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1890: wsh_util_core.add_message(x_return_status,l_module_name);
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.pop(l_module_name);
1893: END IF;
1894: RETURN;
1895:
1896: END IF;
1910: END IF;
1911: END IF;
1912: -- harmonization project end KVENKATE
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.pop(l_module_name);
1915: END IF;
1916: --
1917: END Validate_Item;
1918:
1932: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1933: --
1934: IF l_debug_on IS NULL
1935: THEN
1936: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1937: END IF;
1938: --
1939: IF l_debug_on THEN
1940: WSH_DEBUG_SV.push(l_module_name);
1936: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1937: END IF;
1938: --
1939: IF l_debug_on THEN
1940: WSH_DEBUG_SV.push(l_module_name);
1941: --
1942: WSH_DEBUG_SV.log(l_module_name,'P_FLAG',P_FLAG);
1943: END IF;
1944: --
1938: --
1939: IF l_debug_on THEN
1940: WSH_DEBUG_SV.push(l_module_name);
1941: --
1942: WSH_DEBUG_SV.log(l_module_name,'P_FLAG',P_FLAG);
1943: END IF;
1944: --
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1946:
1948: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1949: END IF;
1950: --
1951: IF l_debug_on THEN
1952: WSH_DEBUG_SV.pop(l_module_name);
1953: END IF;
1954: --
1955: END;
1956:
1969: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1970: --
1971: IF l_debug_on IS NULL
1972: THEN
1973: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1974: END IF;
1975: --
1976: IF l_debug_on THEN
1977: WSH_DEBUG_SV.push(l_module_name);
1973: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1974: END IF;
1975: --
1976: IF l_debug_on THEN
1977: WSH_DEBUG_SV.push(l_module_name);
1978: --
1979: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
1980: END IF;
1981: --
1975: --
1976: IF l_debug_on THEN
1977: WSH_DEBUG_SV.push(l_module_name);
1978: --
1979: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
1980: END IF;
1981: --
1982: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1983:
1985: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1986: END IF;
1987: --
1988: IF l_debug_on THEN
1989: WSH_DEBUG_SV.pop(l_module_name);
1990: END IF;
1991: --
1992: END;
1993:
2021: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2022: --
2023: IF l_debug_on IS NULL
2024: THEN
2025: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2026: END IF;
2027: --
2028: IF l_debug_on THEN
2029: WSH_DEBUG_SV.push(l_module_name);
2025: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2026: END IF;
2027: --
2028: IF l_debug_on THEN
2029: WSH_DEBUG_SV.push(l_module_name);
2030: --
2031: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2032: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2033: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2027: --
2028: IF l_debug_on THEN
2029: WSH_DEBUG_SV.push(l_module_name);
2030: --
2031: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2032: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2033: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2034: WSH_DEBUG_SV.log(l_module_name,'X_UOM_CODE',X_UOM_CODE);
2035: END IF;
2028: IF l_debug_on THEN
2029: WSH_DEBUG_SV.push(l_module_name);
2030: --
2031: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2032: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2033: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2034: WSH_DEBUG_SV.log(l_module_name,'X_UOM_CODE',X_UOM_CODE);
2035: END IF;
2036: --
2029: WSH_DEBUG_SV.push(l_module_name);
2030: --
2031: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2032: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2033: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2034: WSH_DEBUG_SV.log(l_module_name,'X_UOM_CODE',X_UOM_CODE);
2035: END IF;
2036: --
2037: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2030: --
2031: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2032: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2033: WSH_DEBUG_SV.log(l_module_name,'P_UNIT_OF_MEASURE',P_UNIT_OF_MEASURE);
2034: WSH_DEBUG_SV.log(l_module_name,'X_UOM_CODE',X_UOM_CODE);
2035: END IF;
2036: --
2037: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2038:
2052:
2053: END IF;
2054: --
2055: IF l_debug_on THEN
2056: WSH_DEBUG_SV.log(l_module_name,'x_uom_code',x_uom_code);
2057: WSH_DEBUG_SV.pop(l_module_name);
2058: END IF;
2059: --
2060: END;
2053: END IF;
2054: --
2055: IF l_debug_on THEN
2056: WSH_DEBUG_SV.log(l_module_name,'x_uom_code',x_uom_code);
2057: WSH_DEBUG_SV.pop(l_module_name);
2058: END IF;
2059: --
2060: END;
2061:
2098: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2099: --
2100: IF l_debug_on IS NULL
2101: THEN
2102: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2103: END IF;
2104: --
2105: IF l_debug_on THEN
2106: WSH_DEBUG_SV.push(l_module_name);
2102: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2103: END IF;
2104: --
2105: IF l_debug_on THEN
2106: WSH_DEBUG_SV.push(l_module_name);
2107: --
2108: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2109: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2110: END IF;
2104: --
2105: IF l_debug_on THEN
2106: WSH_DEBUG_SV.push(l_module_name);
2107: --
2108: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2109: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2110: END IF;
2111: --
2112: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2105: IF l_debug_on THEN
2106: WSH_DEBUG_SV.push(l_module_name);
2107: --
2108: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
2109: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
2110: END IF;
2111: --
2112: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2113:
2128:
2129: END IF;
2130: --
2131: IF l_debug_on THEN
2132: WSH_DEBUG_SV.log(l_module_name,'p_delivery_name',p_delivery_name);
2133: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2134: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2135: WSH_DEBUG_SV.pop(l_module_name);
2136: END IF;
2129: END IF;
2130: --
2131: IF l_debug_on THEN
2132: WSH_DEBUG_SV.log(l_module_name,'p_delivery_name',p_delivery_name);
2133: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2134: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2135: WSH_DEBUG_SV.pop(l_module_name);
2136: END IF;
2137: --
2130: --
2131: IF l_debug_on THEN
2132: WSH_DEBUG_SV.log(l_module_name,'p_delivery_name',p_delivery_name);
2133: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2134: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2135: WSH_DEBUG_SV.pop(l_module_name);
2136: END IF;
2137: --
2138: END Validate_Delivery_Name;
2131: IF l_debug_on THEN
2132: WSH_DEBUG_SV.log(l_module_name,'p_delivery_name',p_delivery_name);
2133: WSH_DEBUG_SV.log(l_module_name,'p_delivery_id',p_delivery_id);
2134: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2135: WSH_DEBUG_SV.pop(l_module_name);
2136: END IF;
2137: --
2138: END Validate_Delivery_Name;
2139:
2177: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2178: --
2179: IF l_debug_on IS NULL
2180: THEN
2181: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2182: END IF;
2183: --
2184: IF l_debug_on THEN
2185: WSH_DEBUG_SV.push(l_module_name);
2181: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2182: END IF;
2183: --
2184: IF l_debug_on THEN
2185: WSH_DEBUG_SV.push(l_module_name);
2186: --
2187: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
2188: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_NAME',P_REPORT_SET_NAME);
2189: END IF;
2183: --
2184: IF l_debug_on THEN
2185: WSH_DEBUG_SV.push(l_module_name);
2186: --
2187: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
2188: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_NAME',P_REPORT_SET_NAME);
2189: END IF;
2190: --
2191: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2184: IF l_debug_on THEN
2185: WSH_DEBUG_SV.push(l_module_name);
2186: --
2187: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_ID',P_REPORT_SET_ID);
2188: WSH_DEBUG_SV.log(l_module_name,'P_REPORT_SET_NAME',P_REPORT_SET_NAME);
2189: END IF;
2190: --
2191: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2192:
2207:
2208: END IF;
2209: --
2210: IF l_debug_on THEN
2211: WSH_DEBUG_SV.log(l_module_name,'p_report_set_id',p_report_set_id);
2212: WSH_DEBUG_SV.pop(l_module_name);
2213: END IF;
2214: --
2215: END Validate_Report_Set;
2208: END IF;
2209: --
2210: IF l_debug_on THEN
2211: WSH_DEBUG_SV.log(l_module_name,'p_report_set_id',p_report_set_id);
2212: WSH_DEBUG_SV.pop(l_module_name);
2213: END IF;
2214: --
2215: END Validate_Report_Set;
2216:
2238: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2239: --
2240: IF l_debug_on IS NULL
2241: THEN
2242: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2243: END IF;
2244: --
2245: IF l_debug_on THEN
2246: WSH_DEBUG_SV.push(l_module_name);
2242: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2243: END IF;
2244: --
2245: IF l_debug_on THEN
2246: WSH_DEBUG_SV.push(l_module_name);
2247: --
2248: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_FLAG',P_LOADING_ORDER_FLAG);
2249: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_DESC',P_LOADING_ORDER_DESC);
2250: END IF;
2244: --
2245: IF l_debug_on THEN
2246: WSH_DEBUG_SV.push(l_module_name);
2247: --
2248: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_FLAG',P_LOADING_ORDER_FLAG);
2249: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_DESC',P_LOADING_ORDER_DESC);
2250: END IF;
2251: --
2252: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2245: IF l_debug_on THEN
2246: WSH_DEBUG_SV.push(l_module_name);
2247: --
2248: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_FLAG',P_LOADING_ORDER_FLAG);
2249: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_DESC',P_LOADING_ORDER_DESC);
2250: END IF;
2251: --
2252: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2253: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2282: --
2283: END IF;
2284: --
2285: IF l_debug_on THEN
2286: WSH_DEBUG_SV.pop(l_module_name);
2287: END IF;
2288: --
2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2292: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOADING_ORDER');
2293: --
2294: IF l_debug_on THEN
2295: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2296: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2297: END IF;
2298: --
2299: END Validate_Loading_Order;
2292: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOADING_ORDER');
2293: --
2294: IF l_debug_on THEN
2295: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2296: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2297: END IF;
2298: --
2299: END Validate_Loading_Order;
2300:
2341: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2342: --
2343: IF l_debug_on IS NULL
2344: THEN
2345: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2346: END IF;
2347: --
2348: IF l_debug_on THEN
2349: WSH_DEBUG_SV.push(l_module_name);
2345: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2346: END IF;
2347: --
2348: IF l_debug_on THEN
2349: WSH_DEBUG_SV.push(l_module_name);
2350: --
2351: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2352: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2353: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2347: --
2348: IF l_debug_on THEN
2349: WSH_DEBUG_SV.push(l_module_name);
2350: --
2351: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2352: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2353: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2354: WSH_DEBUG_SV.log(l_module_name,'P_PLANNED_DEP_DATE',P_PLANNED_DEP_DATE);
2355: END IF;
2348: IF l_debug_on THEN
2349: WSH_DEBUG_SV.push(l_module_name);
2350: --
2351: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2352: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2353: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2354: WSH_DEBUG_SV.log(l_module_name,'P_PLANNED_DEP_DATE',P_PLANNED_DEP_DATE);
2355: END IF;
2356: --
2349: WSH_DEBUG_SV.push(l_module_name);
2350: --
2351: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2352: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2353: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2354: WSH_DEBUG_SV.log(l_module_name,'P_PLANNED_DEP_DATE',P_PLANNED_DEP_DATE);
2355: END IF;
2356: --
2357: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2350: --
2351: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2352: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2353: WSH_DEBUG_SV.log(l_module_name,'P_STOP_LOCATION_ID',P_STOP_LOCATION_ID);
2354: WSH_DEBUG_SV.log(l_module_name,'P_PLANNED_DEP_DATE',P_PLANNED_DEP_DATE);
2355: END IF;
2356: --
2357: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2358:
2373:
2374: END IF;
2375: --
2376: IF l_debug_on THEN
2377: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2378: WSH_DEBUG_SV.pop(l_module_name);
2379: END IF;
2380: --
2381: END Validate_Stop_Name;
2374: END IF;
2375: --
2376: IF l_debug_on THEN
2377: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2378: WSH_DEBUG_SV.pop(l_module_name);
2379: END IF;
2380: --
2381: END Validate_Stop_Name;
2382:
2418: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2419: --
2420: IF l_debug_on IS NULL
2421: THEN
2422: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2423: END IF;
2424: --
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.push(l_module_name);
2422: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2423: END IF;
2424: --
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.push(l_module_name);
2427: --
2428: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2429: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
2430: END IF;
2424: --
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.push(l_module_name);
2427: --
2428: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2429: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
2430: END IF;
2431: --
2432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.push(l_module_name);
2427: --
2428: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2429: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
2430: END IF;
2431: --
2432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2433:
2448:
2449: END IF;
2450: --
2451: IF l_debug_on THEN
2452: WSH_DEBUG_SV.pop(l_module_name);
2453: END IF;
2454: --
2455: END Validate_Trip_Name;
2456:
2487: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2488: --
2489: IF l_debug_on IS NULL
2490: THEN
2491: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2492: END IF;
2493: --
2494: IF l_debug_on THEN
2495: WSH_DEBUG_SV.push(l_module_name);
2491: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2492: END IF;
2493: --
2494: IF l_debug_on THEN
2495: WSH_DEBUG_SV.push(l_module_name);
2496: --
2497: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2498: END IF;
2499: --
2493: --
2494: IF l_debug_on THEN
2495: WSH_DEBUG_SV.push(l_module_name);
2496: --
2497: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2498: END IF;
2499: --
2500: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2501:
2518:
2519: END IF;
2520: --
2521: IF l_debug_on THEN
2522: WSH_DEBUG_SV.pop(l_module_name);
2523: END IF;
2524: --
2525: END Validate_Trip_MultiStops;
2526:
2554: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2555: --
2556: IF l_debug_on IS NULL
2557: THEN
2558: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2559: END IF;
2560: --
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2558: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2559: END IF;
2560: --
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: --
2564: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2565: END IF;
2566:
2560: --
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: --
2564: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2565: END IF;
2566:
2567: -- bug 5161801, if p_organization_id is NULL return 'N';
2568: IF (p_organization_id is NULL) THEN
2578: --{
2579: --
2580: --
2581: IF l_debug_on THEN
2582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_dlvyTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
2583: END IF;
2584: --
2585: wsh_util_core.get_cached_value
2586: (
2624: l_return_status := 'N';
2625: END IF;
2626:
2627: IF l_debug_on THEN
2628: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_CACHED_VALUE-x_dlvyTbl',WSH_DEBUG_SV.C_PROC_LEVEL);
2629: END IF;
2630: --
2631: wsh_util_core.get_cached_value
2632: (
2659:
2660:
2661:
2662: IF l_debug_on THEN
2663: WSH_DEBUG_SV.log(l_module_name,'Returns ',l_return_status);
2664: WSH_DEBUG_SV.pop(l_module_name);
2665: END IF;
2666: --
2667: RETURN l_return_status ;
2660:
2661:
2662: IF l_debug_on THEN
2663: WSH_DEBUG_SV.log(l_module_name,'Returns ',l_return_status);
2664: WSH_DEBUG_SV.pop(l_module_name);
2665: END IF;
2666: --
2667: RETURN l_return_status ;
2668:
2669: EXCEPTION
2670: WHEN FND_API.G_EXC_ERROR THEN
2671: --
2672: IF l_debug_on THEN
2673: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2674: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2675: END IF;
2676: --
2677: -- bug 5161801, return 'N' when it encounters any exception
2670: WHEN FND_API.G_EXC_ERROR THEN
2671: --
2672: IF l_debug_on THEN
2673: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2674: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2675: END IF;
2676: --
2677: -- bug 5161801, return 'N' when it encounters any exception
2678: l_return_status := 'N';
2679: RETURN l_return_status ;
2680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2681: --
2682: IF l_debug_on THEN
2683: 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);
2684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2685: END IF;
2686: --
2687: -- bug 5161801, return 'N' when it encounters any exception
2680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2681: --
2682: IF l_debug_on THEN
2683: 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);
2684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2685: END IF;
2686: --
2687: -- bug 5161801, return 'N' when it encounters any exception
2688: l_return_status := 'N';
2689: RETURN l_return_status ;
2690: WHEN OTHERS THEN
2691: --
2692: IF l_debug_on THEN
2693: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2695: END IF;
2696: --
2697: -- bug 5161801, return 'N' when it encounters any exception
2690: WHEN OTHERS THEN
2691: --
2692: IF l_debug_on THEN
2693: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2695: END IF;
2696: --
2697: -- bug 5161801, return 'N' when it encounters any exception
2698: l_return_status := 'N';
2713: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2714: --
2715: IF l_debug_on IS NULL
2716: THEN
2717: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2718: END IF;
2719: --
2720: IF l_debug_on THEN
2721: WSH_DEBUG_SV.push(l_module_name);
2717: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2718: END IF;
2719: --
2720: IF l_debug_on THEN
2721: WSH_DEBUG_SV.push(l_module_name);
2722: WSH_DEBUG_SV.log(l_module_name,'p_from_date',p_from_date);
2723: WSH_DEBUG_SV.log(l_module_name,'p_to_date',p_to_date);
2724: END IF;
2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2718: END IF;
2719: --
2720: IF l_debug_on THEN
2721: WSH_DEBUG_SV.push(l_module_name);
2722: WSH_DEBUG_SV.log(l_module_name,'p_from_date',p_from_date);
2723: WSH_DEBUG_SV.log(l_module_name,'p_to_date',p_to_date);
2724: END IF;
2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2726:
2719: --
2720: IF l_debug_on THEN
2721: WSH_DEBUG_SV.push(l_module_name);
2722: WSH_DEBUG_SV.log(l_module_name,'p_from_date',p_from_date);
2723: WSH_DEBUG_SV.log(l_module_name,'p_to_date',p_to_date);
2724: END IF;
2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2726:
2727: IF nvl(p_from_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2735: END IF;
2736:
2737:
2738: IF l_debug_on THEN
2739: WSH_DEBUG_SV.pop(l_module_name);
2740: END IF;
2741:
2742: EXCEPTION
2743: WHEN OTHERS THEN
2743: WHEN OTHERS THEN
2744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2745: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_from_to_dates');
2746: IF l_debug_on THEN
2747: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2749: END IF;
2750: END validate_from_to_dates;
2751:
2744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2745: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_from_to_dates');
2746: IF l_debug_on THEN
2747: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2749: END IF;
2750: END validate_from_to_dates;
2751:
2752:
2792: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2793: --
2794: IF l_debug_on IS NULL
2795: THEN
2796: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2797: END IF;
2798: --
2799: IF l_debug_on THEN
2800: WSH_DEBUG_SV.push(l_module_name);
2796: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2797: END IF;
2798: --
2799: IF l_debug_on THEN
2800: WSH_DEBUG_SV.push(l_module_name);
2801: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2802: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2803: END IF;
2804:
2797: END IF;
2798: --
2799: IF l_debug_on THEN
2800: WSH_DEBUG_SV.push(l_module_name);
2801: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2802: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2803: END IF;
2804:
2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2798: --
2799: IF l_debug_on THEN
2800: WSH_DEBUG_SV.push(l_module_name);
2801: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2802: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2803: END IF;
2804:
2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2806:
2823: END IF;
2824: END IF;
2825:
2826: IF l_debug_on THEN
2827: WSH_DEBUG_SV.pop(l_module_name);
2828: END IF;
2829:
2830: EXCEPTION
2831: WHEN OTHERS THEN
2831: WHEN OTHERS THEN
2832: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2833: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_trip_status');
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2836: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2837: END IF;
2838: END validate_trip_status;
2839:
2832: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2833: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_trip_status');
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2836: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2837: END IF;
2838: END validate_trip_status;
2839:
2840: -- I Harmonization: rvishnuv *******
2876: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2877: --
2878: IF l_debug_on IS NULL
2879: THEN
2880: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2881: END IF;
2882: --
2883: IF l_debug_on THEN
2884: --
2881: END IF;
2882: --
2883: IF l_debug_on THEN
2884: --
2885: WSH_DEBUG_SV.push(l_module_name);
2886: --
2887: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
2888: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
2889: --
2883: IF l_debug_on THEN
2884: --
2885: WSH_DEBUG_SV.push(l_module_name);
2886: --
2887: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
2888: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
2889: --
2890: END IF;
2891: --
2884: --
2885: WSH_DEBUG_SV.push(l_module_name);
2886: --
2887: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
2888: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
2889: --
2890: END IF;
2891: --
2892: x_return_status := wsh_util_core.g_ret_sts_success;
2907: --
2908: END IF;
2909: --
2910: IF l_debug_on THEN
2911: WSH_DEBUG_SV.pop(l_module_name);
2912: END IF;
2913: --
2914: EXCEPTION
2915: --
2918: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2919: --
2920: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_CARRIER');
2921: IF l_debug_on THEN
2922: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2923: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2924: END IF;
2925: --
2926: END Validate_Carrier;
2919: --
2920: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_CARRIER');
2921: IF l_debug_on THEN
2922: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2923: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2924: END IF;
2925: --
2926: END Validate_Carrier;
2927:
3143: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3144: --
3145: IF l_debug_on IS NULL
3146: THEN
3147: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3148: END IF;
3149: --
3150: IF l_debug_on THEN
3151: --
3148: END IF;
3149: --
3150: IF l_debug_on THEN
3151: --
3152: WSH_DEBUG_SV.push(l_module_name);
3153: --
3154: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3155: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3156: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3150: IF l_debug_on THEN
3151: --
3152: WSH_DEBUG_SV.push(l_module_name);
3153: --
3154: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3155: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3156: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3157: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3158: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3151: --
3152: WSH_DEBUG_SV.push(l_module_name);
3153: --
3154: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3155: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3156: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3157: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3158: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3159: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3152: WSH_DEBUG_SV.push(l_module_name);
3153: --
3154: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3155: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3156: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3157: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3158: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3159: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3160: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3153: --
3154: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3155: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3156: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3157: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3158: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3159: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3160: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3161: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3154: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller);
3155: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3156: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3157: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3158: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3159: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3160: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3161: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3162: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3155: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name', p_ship_method_name);
3156: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3157: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3158: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3159: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3160: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3161: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3162: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3163: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3156: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3157: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3158: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3159: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3160: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3161: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3162: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3163: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3164: --
3157: WSH_DEBUG_SV.log(l_module_name,'p_carrier_name', p_carrier_name);
3158: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3159: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3160: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3161: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3162: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3163: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3164: --
3165: END IF;
3158: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3159: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3160: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3161: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3162: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3163: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3164: --
3165: END IF;
3166: --
3159: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3160: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3161: WSH_DEBUG_SV.log(l_module_name,'p_organization_id', p_organization_id);
3162: WSH_DEBUG_SV.log(l_module_name,'p_entity_id', p_entity_id);
3163: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
3164: --
3165: END IF;
3166: --
3167: IF p_entity_type IS NULL
3211: END IF;
3212: --
3213: IF l_debug_on THEN
3214: --
3215: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id', l_carrier_id);
3216: WSH_DEBUG_SV.log(l_module_name,'l_service_level', l_service_level);
3217: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport', l_mode_of_transport);
3218: --
3219: END IF;
3212: --
3213: IF l_debug_on THEN
3214: --
3215: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id', l_carrier_id);
3216: WSH_DEBUG_SV.log(l_module_name,'l_service_level', l_service_level);
3217: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport', l_mode_of_transport);
3218: --
3219: END IF;
3220: --
3213: IF l_debug_on THEN
3214: --
3215: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id', l_carrier_id);
3216: WSH_DEBUG_SV.log(l_module_name,'l_service_level', l_service_level);
3217: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport', l_mode_of_transport);
3218: --
3219: END IF;
3220: --
3221: validate_ship_method(
3228: END IF;
3229: l_ship_method_code_backup := x_ship_method_code;
3230: --
3231: IF l_debug_on THEN
3232: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_ship_method',l_return_status);
3233: END IF;
3234: --
3235: WSH_UTIL_CORE.api_post_call(
3236: p_return_status => l_return_status,
3242: x_carrier_id => x_carrier_id,
3243: x_return_status => l_return_status);
3244: --
3245: IF l_debug_on THEN
3246: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_carrier',l_return_status);
3247: END IF;
3248: --
3249: WSH_UTIL_CORE.api_post_call(
3250: p_return_status => l_return_status,
3258: or nvl(l_service_level,fnd_api.g_miss_char) <> nvl(x_service_level,fnd_api.g_miss_char)
3259: or nvl(l_mode_of_transport,fnd_api.g_miss_char) <> nvl(x_mode_of_transport,fnd_api.g_miss_char)
3260: THEN
3261: IF l_debug_on THEN
3262: WSH_DEBUG_SV.logmsg(l_module_name,'Ship Method is being Nullified 1');
3263: END IF;
3264: x_ship_method_code := NULL;
3265: p_ship_method_name := NULL;
3266: END IF;
3273: p_meaning => l_dummy_meaning,
3274: x_return_status => l_return_status);
3275: --
3276: IF l_debug_on THEN
3277: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_lookup for service_level',l_return_status);
3278: END IF;
3279: --
3280: WSH_UTIL_CORE.api_post_call(
3281: p_return_status => l_return_status,
3294: p_meaning => l_dummy_meaning,
3295: x_return_status => l_return_status);
3296: --
3297: IF l_debug_on THEN
3298: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_lookup for mode_of_transport',l_return_status);
3299: END IF;
3300: --
3301: WSH_UTIL_CORE.api_post_call(
3302: p_return_status => l_return_status,
3308: --
3309: --
3310: IF l_debug_on THEN
3311: --
3312: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3313: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3314: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3315: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3316: --
3309: --
3310: IF l_debug_on THEN
3311: --
3312: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3313: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3314: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3315: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3316: --
3317: END IF;
3310: IF l_debug_on THEN
3311: --
3312: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3313: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3314: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3315: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3316: --
3317: END IF;
3318: --
3311: --
3312: WSH_DEBUG_SV.log(l_module_name,'x_ship_method_code', x_ship_method_code);
3313: WSH_DEBUG_SV.log(l_module_name,'x_carrier_id', x_carrier_id);
3314: WSH_DEBUG_SV.log(l_module_name,'x_service_level', x_service_level);
3315: WSH_DEBUG_SV.log(l_module_name,'x_mode_of_transport', x_mode_of_transport);
3316: --
3317: END IF;
3318: --
3319: IF l_sm_is_null = TRUE
3345: --
3346: x_return_status := wsh_util_core.g_ret_sts_success;
3347: IF l_debug_on THEN
3348: --
3349: WSH_DEBUG_SV.logmsg(l_module_name,'FTE not installed' );
3350: WSH_DEBUG_SV.pop(l_module_name);
3351: END IF;
3352: RETURN;
3353: ******/
3346: x_return_status := wsh_util_core.g_ret_sts_success;
3347: IF l_debug_on THEN
3348: --
3349: WSH_DEBUG_SV.logmsg(l_module_name,'FTE not installed' );
3350: WSH_DEBUG_SV.pop(l_module_name);
3351: END IF;
3352: RETURN;
3353: ******/
3354: -- End of Comment for Bug 4000931
3464: p_ship_method_name => p_ship_method_name,
3465: x_return_status => l_return_status);
3466: --
3467: IF l_debug_on THEN
3468: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_ship_method Name',l_return_status);
3469: END IF;
3470: --
3471: WSH_UTIL_CORE.api_post_call(
3472: p_return_status => l_return_status,
3495: p_ship_method_name => p_ship_method_name,
3496: x_return_status => l_return_status);
3497: --
3498: IF l_debug_on THEN
3499: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_ship_method Name',l_return_status);
3500: END IF;
3501: --
3502: WSH_UTIL_CORE.api_post_call(
3503: p_return_status => l_return_status,
3539: IF NVL(l_ship_method_code_backup,fnd_api.G_MISS_CHAR) <>
3540: NVL(x_ship_method_code,fnd_api.G_MISS_CHAR) THEN
3541: --
3542: IF l_debug_on THEN
3543: wsh_debug_sv.logmsg(l_module_name,'Ship method calculated is different');
3544: END IF;
3545: FND_MESSAGE.SET_NAME('WSH','WSH_SHIP_METHOD_CHANGE');
3546: FND_MESSAGE.SET_TOKEN('ORIG_SM', l_ship_method_code_backup);
3547: FND_MESSAGE.SET_TOKEN('CALC_SM', x_ship_method_code);
3553:
3554: x_return_status := wsh_util_core.g_ret_sts_success;
3555: --
3556: IF l_debug_on THEN
3557: WSH_DEBUG_SV.pop(l_module_name);
3558: END IF;
3559: --
3560: EXCEPTION
3561: --
3562: WHEN FND_API.G_EXC_ERROR THEN
3563: --
3564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3565: IF l_debug_on THEN
3566: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3567: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3568: END IF;
3569: --
3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3563: --
3564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3565: IF l_debug_on THEN
3566: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3567: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3568: END IF;
3569: --
3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3571: --
3571: --
3572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3573: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3574: IF l_debug_on THEN
3575: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3577: END IF;
3578: --
3579: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3573: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3574: IF l_debug_on THEN
3575: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3577: END IF;
3578: --
3579: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3580: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3579: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3580: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3581: --
3582: IF l_debug_on THEN
3583: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3584: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNIN
3585: G');
3586: END IF;
3587: --
3580: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3581: --
3582: IF l_debug_on THEN
3583: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3584: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNIN
3585: G');
3586: END IF;
3587: --
3588: WHEN OTHERS THEN
3589: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3590: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3591: --
3592: IF l_debug_on THEN
3593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3595: END IF;
3596: END Validate_Freight_Carrier;
3597: -- I Harmonization: rvishnuv *******
3590: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3591: --
3592: IF l_debug_on THEN
3593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3595: END IF;
3596: END Validate_Freight_Carrier;
3597: -- I Harmonization: rvishnuv *******
3598:
3636: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3637: --
3638: IF l_debug_on IS NULL
3639: THEN
3640: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3641: END IF;
3642: --
3643: IF l_debug_on THEN
3644: WSH_DEBUG_SV.push(l_module_name);
3640: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3641: END IF;
3642: --
3643: IF l_debug_on THEN
3644: WSH_DEBUG_SV.push(l_module_name);
3645: --
3646: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3647: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3648: END IF;
3642: --
3643: IF l_debug_on THEN
3644: WSH_DEBUG_SV.push(l_module_name);
3645: --
3646: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3647: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3648: END IF;
3649: --
3650: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3643: IF l_debug_on THEN
3644: WSH_DEBUG_SV.push(l_module_name);
3645: --
3646: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3647: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3648: END IF;
3649: --
3650: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3651:
3661:
3662: l_wms_org := wsh_util_validate.Check_Wms_Org(p_organization_id);
3663:
3664: IF l_debug_on THEN
3665: WSH_DEBUG_SV.log(l_module_name,'l_wms_org',l_wms_org);
3666: END IF;
3667:
3668: IF(nvl(l_vehicle_item_flag, 'N') = 'Y') THEN
3669: x_item_type := 'VEH_ITEM';
3674: x_item_type := 'CONT_ITEM';
3675: END IF;
3676:
3677: IF l_debug_on THEN
3678: WSH_DEBUG_SV.pop(l_module_name);
3679: END IF;
3680: --
3681:
3682: EXCEPTION
3683: WHEN FND_API.G_EXC_ERROR THEN
3684: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3685: wsh_util_core.add_message(x_return_status,l_module_name);
3686: IF l_debug_on THEN
3687: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3689: END IF;
3690:
3691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3684: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3685: wsh_util_core.add_message(x_return_status,l_module_name);
3686: IF l_debug_on THEN
3687: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3689: END IF;
3690:
3691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3692: --
3691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3692: --
3693: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3694: IF l_debug_on THEN
3695: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3697: END IF;
3698:
3699: WHEN OTHERS THEN
3692: --
3693: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3694: IF l_debug_on THEN
3695: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3697: END IF;
3698:
3699: WHEN OTHERS THEN
3700: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3700: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3701: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.FIND_ITEM_TYPE');
3702: --
3703: IF l_debug_on THEN
3704: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3705: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3706: END IF;
3707:
3708: END Find_Item_Type;
3701: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.FIND_ITEM_TYPE');
3702: --
3703: IF l_debug_on THEN
3704: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3705: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3706: END IF;
3707:
3708: END Find_Item_Type;
3709: -- I Harmonization: KVENKATE
3732: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3733: --
3734: IF l_debug_on IS NULL
3735: THEN
3736: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3737: END IF;
3738: --
3739: IF l_debug_on THEN
3740: wsh_debug_sv.push(l_module_name, 'Get_Org_Type');
3736: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3737: END IF;
3738: --
3739: IF l_debug_on THEN
3740: wsh_debug_sv.push(l_module_name, 'Get_Org_Type');
3741: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);
3742: END IF;
3743:
3744: l_org_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type (
3737: END IF;
3738: --
3739: IF l_debug_on THEN
3740: wsh_debug_sv.push(l_module_name, 'Get_Org_Type');
3741: wsh_debug_sv.log (l_module_name,'Organization id', p_organization_id);
3742: END IF;
3743:
3744: l_org_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type (
3745: p_organization_id => p_organization_id,
3761: l_org_type_wms := 'WMS';
3762: END IF;
3763:
3764: IF l_debug_on THEN
3765: wsh_debug_sv.log (l_module_name,'l_org_type', l_org_type);
3766: wsh_debug_sv.log (l_module_name,'l_org_type_wms', l_org_type_wms);
3767: END IF;
3768:
3769: IF l_org_type IS NULL THEN
3762: END IF;
3763:
3764: IF l_debug_on THEN
3765: wsh_debug_sv.log (l_module_name,'l_org_type', l_org_type);
3766: wsh_debug_sv.log (l_module_name,'l_org_type_wms', l_org_type_wms);
3767: END IF;
3768:
3769: IF l_org_type IS NULL THEN
3770: l_org_type := l_org_type_wms;
3774:
3775: x_return_status := wsh_util_core.g_ret_sts_success;
3776:
3777: IF l_debug_on THEN
3778: wsh_debug_sv.pop(l_module_name, 'Get_Org_Type');
3779: END IF;
3780:
3781: RETURN l_org_type;
3782: EXCEPTION
3783: WHEN FND_API.G_EXC_ERROR THEN
3784: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3785: --
3786: IF l_debug_on THEN
3787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3789: END IF;
3790: RETURN l_org_type;
3791: --
3784: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3785: --
3786: IF l_debug_on THEN
3787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3789: END IF;
3790: RETURN l_org_type;
3791: --
3792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3794: --
3795: IF l_debug_on THEN
3796: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3797: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3798: END IF;
3799: RETURN l_org_type;
3800: --
3793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3794: --
3795: IF l_debug_on THEN
3796: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3797: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3798: END IF;
3799: RETURN l_org_type;
3800: --
3801: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3801: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3802: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3803: --
3804: IF l_debug_on THEN
3805: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3806: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3807: END IF;
3808: RETURN l_org_type;
3809: --
3802: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3803: --
3804: IF l_debug_on THEN
3805: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3806: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3807: END IF;
3808: RETURN l_org_type;
3809: --
3810: WHEN OTHERS THEN
3811: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3812: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.GET_ORG_TYPE');
3813: --
3814: IF l_debug_on THEN
3815: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3816: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3817: END IF;
3818: RETURN l_org_type;
3819: --
3812: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.GET_ORG_TYPE');
3813: --
3814: IF l_debug_on THEN
3815: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3816: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3817: END IF;
3818: RETURN l_org_type;
3819: --
3820: END Get_Org_Type;
3872: --
3873: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3874: --
3875: IF l_debug_on IS NULL THEN
3876: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3877: END IF;
3878: --
3879: IF l_debug_on THEN
3880: WSH_DEBUG_SV.push(l_module_name);
3876: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3877: END IF;
3878: --
3879: IF l_debug_on THEN
3880: WSH_DEBUG_SV.push(l_module_name);
3881: --
3882: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
3883: WSH_DEBUG_SV.log(l_module_name,'p_inventory_item_id',
3884: p_inventory_item_id);
3878: --
3879: IF l_debug_on THEN
3880: WSH_DEBUG_SV.push(l_module_name);
3881: --
3882: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
3883: WSH_DEBUG_SV.log(l_module_name,'p_inventory_item_id',
3884: p_inventory_item_id);
3885: END IF;
3886: --
3879: IF l_debug_on THEN
3880: WSH_DEBUG_SV.push(l_module_name);
3881: --
3882: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
3883: WSH_DEBUG_SV.log(l_module_name,'p_inventory_item_id',
3884: p_inventory_item_id);
3885: END IF;
3886: --
3887: IF (p_organization_id IS NULL ) OR (p_inventory_item_id IS NULL )THEN
3903: x_Item_info_rec := G_ITEM_INFO_TAB(l_hash_value);
3904: l_cache_hit := TRUE;
3905:
3906: IF l_debug_on THEN
3907: WSH_DEBUG_SV.logmsg(l_module_name,'hit ');
3908: END IF;
3909:
3910: END IF; --}
3911:
3937:
3938: END IF; --}
3939:
3940: IF l_debug_on THEN
3941: WSH_DEBUG_SV.log(l_module_name, 'primary_uom_code',
3942: x_Item_info_rec.primary_uom_code);
3943: WSH_DEBUG_SV.log(l_module_name, 'description',
3944: x_Item_info_rec.description);
3945: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3939:
3940: IF l_debug_on THEN
3941: WSH_DEBUG_SV.log(l_module_name, 'primary_uom_code',
3942: x_Item_info_rec.primary_uom_code);
3943: WSH_DEBUG_SV.log(l_module_name, 'description',
3944: x_Item_info_rec.description);
3945: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3946: x_Item_info_rec.hazard_class_id);
3947: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3941: WSH_DEBUG_SV.log(l_module_name, 'primary_uom_code',
3942: x_Item_info_rec.primary_uom_code);
3943: WSH_DEBUG_SV.log(l_module_name, 'description',
3944: x_Item_info_rec.description);
3945: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3946: x_Item_info_rec.hazard_class_id);
3947: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3948: x_Item_info_rec.weight_uom_code);
3949: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3943: WSH_DEBUG_SV.log(l_module_name, 'description',
3944: x_Item_info_rec.description);
3945: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3946: x_Item_info_rec.hazard_class_id);
3947: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3948: x_Item_info_rec.weight_uom_code);
3949: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3950: x_Item_info_rec.unit_weight);
3951: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3945: WSH_DEBUG_SV.log(l_module_name, 'hazard_class_id',
3946: x_Item_info_rec.hazard_class_id);
3947: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3948: x_Item_info_rec.weight_uom_code);
3949: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3950: x_Item_info_rec.unit_weight);
3951: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3952: x_Item_info_rec.volume_uom_code);
3953: WSH_DEBUG_SV.log(l_module_name, 'unit_volume',
3947: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code',
3948: x_Item_info_rec.weight_uom_code);
3949: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3950: x_Item_info_rec.unit_weight);
3951: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3952: x_Item_info_rec.volume_uom_code);
3953: WSH_DEBUG_SV.log(l_module_name, 'unit_volume',
3954: x_Item_info_rec.unit_volume);
3955: WSH_DEBUG_SV.pop(l_module_name);
3949: WSH_DEBUG_SV.log(l_module_name, 'unit_weight',
3950: x_Item_info_rec.unit_weight);
3951: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3952: x_Item_info_rec.volume_uom_code);
3953: WSH_DEBUG_SV.log(l_module_name, 'unit_volume',
3954: x_Item_info_rec.unit_volume);
3955: WSH_DEBUG_SV.pop(l_module_name);
3956: END IF;
3957: EXCEPTION
3951: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code',
3952: x_Item_info_rec.volume_uom_code);
3953: WSH_DEBUG_SV.log(l_module_name, 'unit_volume',
3954: x_Item_info_rec.unit_volume);
3955: WSH_DEBUG_SV.pop(l_module_name);
3956: END IF;
3957: EXCEPTION
3958:
3959: WHEN FND_API.G_EXC_ERROR THEN
3959: WHEN FND_API.G_EXC_ERROR THEN
3960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3961: --
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
3964: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3966: END IF;
3967: --
3960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3961: --
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
3964: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3966: END IF;
3967: --
3968: WHEN OTHERS THEN
3961: --
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
3964: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3966: END IF;
3967: --
3968: WHEN OTHERS THEN
3969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3970: wsh_util_core.default_handler('WSH_UTIL_CORE.GET_ITEM_INFO');
3971: --
3972: IF l_debug_on THEN
3973: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
3974: 'Oracle error message is '||
3975: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3976: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3977: END IF;
3971: --
3972: IF l_debug_on THEN
3973: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
3974: 'Oracle error message is '||
3975: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3976: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3977: END IF;
3978:
3979:
3972: IF l_debug_on THEN
3973: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
3974: 'Oracle error message is '||
3975: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3976: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3977: END IF;
3978:
3979:
3980: END get_item_info;
4014: BEGIN
4015: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4016: --
4017: IF l_debug_on IS NULL THEN
4018: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4019: END IF;
4020: --
4021: IF l_debug_on THEN
4022: WSH_DEBUG_SV.push(l_module_name);
4018: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4019: END IF;
4020: --
4021: IF l_debug_on THEN
4022: WSH_DEBUG_SV.push(l_module_name);
4023: --
4024: WSH_DEBUG_SV.log(l_module_name,'p_item_id',p_item_id);
4025: END IF;
4026: --
4020: --
4021: IF l_debug_on THEN
4022: WSH_DEBUG_SV.push(l_module_name);
4023: --
4024: WSH_DEBUG_SV.log(l_module_name,'p_item_id',p_item_id);
4025: END IF;
4026: --
4027: IF p_item_id IS NULL THEN
4028: RAISE FND_API.G_EXC_ERROR;
4078: END IF;
4079: ELSE --}{
4080: IF l_debug_on THEN
4081: --
4082: WSH_DEBUG_SV.logmsg(l_module_name,'hit ');
4083: --
4084: END IF;
4085: END IF; --}
4086:
4085: END IF; --}
4086:
4087:
4088: IF l_debug_on THEN
4089: WSH_DEBUG_SV.log(l_module_name, 'x_master_container_item_id',
4090: x_master_container_item_id);
4091: WSH_DEBUG_SV.log(l_module_name, 'x_detail_container_item_id',
4092: x_detail_container_item_id);
4093: WSH_DEBUG_SV.pop(l_module_name);
4087:
4088: IF l_debug_on THEN
4089: WSH_DEBUG_SV.log(l_module_name, 'x_master_container_item_id',
4090: x_master_container_item_id);
4091: WSH_DEBUG_SV.log(l_module_name, 'x_detail_container_item_id',
4092: x_detail_container_item_id);
4093: WSH_DEBUG_SV.pop(l_module_name);
4094: END IF;
4095:
4089: WSH_DEBUG_SV.log(l_module_name, 'x_master_container_item_id',
4090: x_master_container_item_id);
4091: WSH_DEBUG_SV.log(l_module_name, 'x_detail_container_item_id',
4092: x_detail_container_item_id);
4093: WSH_DEBUG_SV.pop(l_module_name);
4094: END IF;
4095:
4096: EXCEPTION
4097: WHEN FND_API.G_EXC_ERROR THEN
4097: WHEN FND_API.G_EXC_ERROR THEN
4098: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4099: --
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4102: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4103: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4104: END IF;
4105: --
4098: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4099: --
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4102: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4103: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4104: END IF;
4105: --
4106:
4099: --
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4102: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4103: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4104: END IF;
4105: --
4106:
4107: WHEN OTHERS THEN
4108: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4109: wsh_util_core.default_handler('WSH_UTIL_CORE.DEFAULT_CONTAINER');
4110: --
4111: IF l_debug_on THEN
4112: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4113: 'Oracle error message is '||
4114: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4115: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4116: END IF;
4110: --
4111: IF l_debug_on THEN
4112: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4113: 'Oracle error message is '||
4114: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4115: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4116: END IF;
4117:
4118: END Default_container;
4111: IF l_debug_on THEN
4112: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4113: 'Oracle error message is '||
4114: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4115: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4116: END IF;
4117:
4118: END Default_container;
4119:
4160:
4161: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4162: IF l_debug_on IS NULL
4163: THEN
4164: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4165: END IF;
4166: --
4167: IF l_debug_on THEN
4168: wsh_debug_sv.push (l_module_name);
4164: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4165: END IF;
4166: --
4167: IF l_debug_on THEN
4168: wsh_debug_sv.push (l_module_name);
4169: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4170: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4171: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4172: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4165: END IF;
4166: --
4167: IF l_debug_on THEN
4168: wsh_debug_sv.push (l_module_name);
4169: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4170: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4171: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4172: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4173: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4166: --
4167: IF l_debug_on THEN
4168: wsh_debug_sv.push (l_module_name);
4169: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4170: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4171: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4172: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4173: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4174: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4167: IF l_debug_on THEN
4168: wsh_debug_sv.push (l_module_name);
4169: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4170: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4171: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4172: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4173: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4174: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4175: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4168: wsh_debug_sv.push (l_module_name);
4169: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4170: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4171: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4172: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4173: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4174: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4175: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4176: END IF;
4169: WSH_DEBUG_SV.log(l_module_name, 'p_organization_id',p_organization_id);
4170: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4171: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4172: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4173: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4174: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4175: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4176: END IF;
4177: --
4170: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id',p_carrier_id);
4171: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4172: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4173: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4174: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4175: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4176: END IF;
4177: --
4178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4171: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4172: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code',p_ship_method_code);
4173: WSH_DEBUG_SV.log(l_module_name, 'p_caller',p_caller);
4174: WSH_DEBUG_SV.log(l_module_name, 'p_tp_installed',p_tp_installed);
4175: WSH_DEBUG_SV.log(l_module_name, 'p_otm_installed',p_otm_installed); --OTM R12 Org-Specific
4176: END IF;
4177: --
4178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4179: IF p_caller = 'PO' THEN --{
4183: p_organization_id => p_organization_id,
4184: x_param_info => l_shipping_param_info,
4185: x_return_status => l_return_status);
4186: IF l_debug_on THEN
4187: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_SHIPPING_PARAMS_PVT.Get l_return_status '
4188: ,l_return_status);
4189: WSH_DEBUG_SV.log(l_module_name,'l_shipping_param_info.otm_enabled '
4190: ,l_shipping_param_info.otm_enabled);
4191: END IF;
4185: x_return_status => l_return_status);
4186: IF l_debug_on THEN
4187: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_SHIPPING_PARAMS_PVT.Get l_return_status '
4188: ,l_return_status);
4189: WSH_DEBUG_SV.log(l_module_name,'l_shipping_param_info.otm_enabled '
4190: ,l_shipping_param_info.otm_enabled);
4191: END IF;
4192: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,
4193: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4207: base => c_hash_base,
4208: hash_size =>c_hash_size );
4209:
4210: IF l_debug_on THEN
4211: WSH_DEBUG_SV.log(l_module_name,'l_hash_value ',l_hash_value);
4212: END IF;
4213: IF G_IGNORE_PLAN_TAB.EXISTS(l_hash_value) THEN --{
4214: IF G_IGNORE_PLAN_TAB(l_hash_value).organization_id = p_organization_id
4215: AND NVL(G_IGNORE_PLAN_TAB(l_hash_value).carrier_id,-22) =
4220: x_ignore_for_planning :=
4221: G_IGNORE_PLAN_TAB(l_hash_value).ignore_for_planning;
4222: l_hit := TRUE;
4223: IF l_debug_on THEN
4224: WSH_DEBUG_SV.log(l_module_name,'hit ',x_ignore_for_planning);
4225: END IF;
4226: END IF; --}
4227: END IF; --}
4228: IF (NOT l_hit) THEN --{
4233: p_ship_method_code => p_ship_method_code,
4234: p_msg_display => 'N'
4235: );
4236: IF l_debug_on THEN
4237: WSH_DEBUG_SV.log(l_module_name,'l_wh_type,l_return_status',
4238: l_wh_type||l_return_status);
4239: END IF;
4240: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN
4241: x_ignore_for_planning:='Y';
4254: ELSE --}{
4255: x_ignore_for_planning := 'N';
4256: END IF; --}
4257: IF l_debug_on THEN
4258: WSH_DEBUG_SV.pop(l_module_name,x_ignore_for_planning);
4259: END IF;
4260: EXCEPTION
4261: WHEN FND_API.G_EXC_ERROR THEN --{ --OTM R12 Start
4262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4261: WHEN FND_API.G_EXC_ERROR THEN --{ --OTM R12 Start
4262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4263: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4264: IF l_debug_on THEN
4265: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4266: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4267: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4268: END IF; --} --OTM R12 End
4269: WHEN OTHERS THEN
4262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4263: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4264: IF l_debug_on THEN
4265: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4266: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4267: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4268: END IF; --} --OTM R12 End
4269: WHEN OTHERS THEN
4270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4263: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4264: IF l_debug_on THEN
4265: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4266: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4267: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4268: END IF; --} --OTM R12 End
4269: WHEN OTHERS THEN
4270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4271: wsh_util_core.default_handler('WSH_UTIL_CORE.DEFAULT_CONTAINER');
4270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4271: wsh_util_core.default_handler('WSH_UTIL_CORE.DEFAULT_CONTAINER');
4272: --
4273: IF l_debug_on THEN
4274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4275: 'Oracle error message is '||
4276: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4278: END IF;
4272: --
4273: IF l_debug_on THEN
4274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4275: 'Oracle error message is '||
4276: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4278: END IF;
4279: END Calc_ignore_for_planning;
4280:
4273: IF l_debug_on THEN
4274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4275: 'Oracle error message is '||
4276: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4278: END IF;
4279: END Calc_ignore_for_planning;
4280:
4281: -- Added for Inbound Logistics
4340: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4341: --
4342: IF l_debug_on IS NULL
4343: THEN
4344: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4345: END IF;
4346: --
4347: --
4348: -- Debug Statements
4347: --
4348: -- Debug Statements
4349: --
4350: IF l_debug_on THEN
4351: WSH_DEBUG_SV.push(l_module_name);
4352: --
4353: WSH_DEBUG_SV.log(l_module_name,'P_FOB',P_FOB);
4354: END IF;
4355: --
4349: --
4350: IF l_debug_on THEN
4351: WSH_DEBUG_SV.push(l_module_name);
4352: --
4353: WSH_DEBUG_SV.log(l_module_name,'P_FOB',P_FOB);
4354: END IF;
4355: --
4356: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4357:
4405: --
4406: -- Debug Statements
4407: --
4408: IF l_debug_on THEN
4409: WSH_DEBUG_SV.pop(l_module_name);
4410: END IF;
4411: --
4412: EXCEPTION
4413: WHEN OTHERS THEN
4416: --
4417: -- Debug Statements
4418: --
4419: IF l_debug_on THEN
4420: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4422: END IF;
4423: --
4424: END validate_fob;
4417: -- Debug Statements
4418: --
4419: IF l_debug_on THEN
4420: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4422: END IF;
4423: --
4424: END validate_fob;
4425:
4486: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4487: --
4488: IF l_debug_on IS NULL
4489: THEN
4490: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4491: END IF;
4492: --
4493: --
4494: -- Debug Statements
4493: --
4494: -- Debug Statements
4495: --
4496: IF l_debug_on THEN
4497: WSH_DEBUG_SV.push(l_module_name);
4498: --
4499: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
4500: END IF;
4501: --
4495: --
4496: IF l_debug_on THEN
4497: WSH_DEBUG_SV.push(l_module_name);
4498: --
4499: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_TERMS_CODE',P_FREIGHT_TERMS_CODE);
4500: END IF;
4501: --
4502: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4503:
4551: --
4552: -- Debug Statements
4553: --
4554: IF l_debug_on THEN
4555: WSH_DEBUG_SV.pop(l_module_name);
4556: END IF;
4557: --
4558: EXCEPTION
4559: WHEN OTHERS THEN
4562: --
4563: -- Debug Statements
4564: --
4565: IF l_debug_on THEN
4566: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4567: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4568: END IF;
4569: --
4570: END Validate_freight_terms;
4563: -- Debug Statements
4564: --
4565: IF l_debug_on THEN
4566: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4567: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4568: END IF;
4569: --
4570: END Validate_freight_terms;
4571:
4618: --
4619: l_debug_on := wsh_debug_interface.g_debug;
4620: --
4621: IF l_debug_on IS NULL THEN
4622: l_debug_on := wsh_debug_sv.is_debug_enabled;
4623: END IF;
4624: --
4625: IF l_debug_on THEN
4626: wsh_debug_sv.push(l_module_name);
4622: l_debug_on := wsh_debug_sv.is_debug_enabled;
4623: END IF;
4624: --
4625: IF l_debug_on THEN
4626: wsh_debug_sv.push(l_module_name);
4627: --
4628: wsh_debug_sv.LOG(l_module_name, 'p_vendor_id', p_vendor_id);
4629: wsh_debug_sv.LOG(l_module_name, 'p_party_id', p_party_id);
4630: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
4624: --
4625: IF l_debug_on THEN
4626: wsh_debug_sv.push(l_module_name);
4627: --
4628: wsh_debug_sv.LOG(l_module_name, 'p_vendor_id', p_vendor_id);
4629: wsh_debug_sv.LOG(l_module_name, 'p_party_id', p_party_id);
4630: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
4631: END IF;
4632: --
4625: IF l_debug_on THEN
4626: wsh_debug_sv.push(l_module_name);
4627: --
4628: wsh_debug_sv.LOG(l_module_name, 'p_vendor_id', p_vendor_id);
4629: wsh_debug_sv.LOG(l_module_name, 'p_party_id', p_party_id);
4630: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
4631: END IF;
4632: --
4633: x_return_status := wsh_util_core.g_ret_sts_success;
4626: wsh_debug_sv.push(l_module_name);
4627: --
4628: wsh_debug_sv.LOG(l_module_name, 'p_vendor_id', p_vendor_id);
4629: wsh_debug_sv.LOG(l_module_name, 'p_party_id', p_party_id);
4630: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
4631: END IF;
4632: --
4633: x_return_status := wsh_util_core.g_ret_sts_success;
4634: --
4642: THEN
4643: --{
4644:
4645: IF l_debug_on THEN
4646: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.get_location_description',WSH_DEBUG_SV.C_PROC_LEVEL);
4647: END IF;
4648: --
4649: l_location_name := SUBSTRB(
4650: WSH_UTIL_CORE.get_location_description
4667: CLOSE locn_csr;
4668: --
4669: --
4670: IF l_debug_on THEN
4671: wsh_debug_sv.pop(l_module_name);
4672: END IF;
4673: --
4674: --}
4675: EXCEPTION
4679:
4680: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4681: --
4682: IF l_debug_on THEN
4683: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4685: END IF;
4686: --
4687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4680: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4681: --
4682: IF l_debug_on THEN
4683: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4685: END IF;
4686: --
4687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4688:
4688:
4689: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4690: --
4691: IF l_debug_on THEN
4692: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4693: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4694: END IF;
4695: --
4696: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4689: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4690: --
4691: IF l_debug_on THEN
4692: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4693: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4694: END IF;
4695: --
4696: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4697: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4696: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4697: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4698: --
4699: IF l_debug_on THEN
4700: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4701: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4702: END IF;
4703: --
4704: WHEN OTHERS THEN
4697: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4698: --
4699: IF l_debug_on THEN
4700: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4701: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4702: END IF;
4703: --
4704: WHEN OTHERS THEN
4705:
4705:
4706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4707: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_supplier_location', l_module_name);
4708: IF l_debug_on THEN
4709: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4710: END IF;
4711: --
4712: --}
4713: END validate_supplier_location;
4755: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4756: --
4757: IF l_debug_on IS NULL THEN
4758: --{
4759: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4760: --}
4761: END IF;
4762: --
4763: IF l_debug_on THEN
4761: END IF;
4762: --
4763: IF l_debug_on THEN
4764: --{
4765: WSH_DEBUG_SV.push(l_module_name);
4766: --
4767: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_ID',p_pick_grouping_rule_id);
4768: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_NAME',p_pick_grouping_rule_name);
4769: --}
4763: IF l_debug_on THEN
4764: --{
4765: WSH_DEBUG_SV.push(l_module_name);
4766: --
4767: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_ID',p_pick_grouping_rule_id);
4768: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_NAME',p_pick_grouping_rule_name);
4769: --}
4770: END IF;
4771: --
4764: --{
4765: WSH_DEBUG_SV.push(l_module_name);
4766: --
4767: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_ID',p_pick_grouping_rule_id);
4768: WSH_DEBUG_SV.log(l_module_name,'P_PICK_GROUPING_RULE_NAME',p_pick_grouping_rule_name);
4769: --}
4770: END IF;
4771: --
4772: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4788: END IF;
4789: --
4790: IF l_debug_on THEN
4791: --{
4792: WSH_DEBUG_SV.pop(l_module_name);
4793: --}
4794: END IF;
4795: --
4796: END Validate_Pick_Group_Rule_Name;
4832: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4833: --
4834: IF l_debug_on IS NULL THEN
4835: --{
4836: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4837: --}
4838: END IF;
4839: --
4840: IF l_debug_on THEN
4838: END IF;
4839: --
4840: IF l_debug_on THEN
4841: --{
4842: WSH_DEBUG_SV.push(l_module_name);
4843: --
4844: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_ID',p_pick_sequence_rule_id);
4845: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_NAME',p_pick_sequence_rule_NAME);
4846: --}
4840: IF l_debug_on THEN
4841: --{
4842: WSH_DEBUG_SV.push(l_module_name);
4843: --
4844: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_ID',p_pick_sequence_rule_id);
4845: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_NAME',p_pick_sequence_rule_NAME);
4846: --}
4847: END IF;
4848: --
4841: --{
4842: WSH_DEBUG_SV.push(l_module_name);
4843: --
4844: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_ID',p_pick_sequence_rule_id);
4845: WSH_DEBUG_SV.log(l_module_name,'P_PICK_SEQUENCE_RULE_NAME',p_pick_sequence_rule_NAME);
4846: --}
4847: END IF;
4848: --
4849: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4865: END IF;
4866: --
4867: IF l_debug_on THEN
4868: --{
4869: WSH_DEBUG_SV.pop(l_module_name);
4870: --}
4871: END IF;
4872: --
4873: END Validate_Pick_Seq_Rule_Name;
4909: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4910: --
4911: IF l_debug_on IS NULL THEN
4912: --{
4913: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4914: --}
4915: END IF;
4916: --
4917: IF l_debug_on THEN
4915: END IF;
4916: --
4917: IF l_debug_on THEN
4918: --{
4919: WSH_DEBUG_SV.push(l_module_name);
4920: --
4921: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_ID',p_ship_confirm_rule_id);
4922: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_NAME',p_ship_confirm_rule_name);
4923: --}
4917: IF l_debug_on THEN
4918: --{
4919: WSH_DEBUG_SV.push(l_module_name);
4920: --
4921: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_ID',p_ship_confirm_rule_id);
4922: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_NAME',p_ship_confirm_rule_name);
4923: --}
4924: END IF;
4925: --
4918: --{
4919: WSH_DEBUG_SV.push(l_module_name);
4920: --
4921: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_ID',p_ship_confirm_rule_id);
4922: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_CONFIRM_RULE_NAME',p_ship_confirm_rule_name);
4923: --}
4924: END IF;
4925: --
4926: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4942: END IF;
4943: --
4944: IF l_debug_on THEN
4945: --{
4946: WSH_DEBUG_SV.pop(l_module_name);
4947: --}
4948: END IF;
4949: --
4950: END Validate_Ship_Con_Rule_Name;
4985: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4986: --
4987: IF l_debug_on IS NULL THEN
4988: --{
4989: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4990: --}
4991: END IF;
4992: --
4993: IF l_debug_on THEN
4991: END IF;
4992: --
4993: IF l_debug_on THEN
4994: --{
4995: WSH_DEBUG_SV.push(l_module_name);
4996: --
4997: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_ID',p_Picking_Batch_id);
4998: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_NAME',p_Picking_Batch_name);
4999: --}
4993: IF l_debug_on THEN
4994: --{
4995: WSH_DEBUG_SV.push(l_module_name);
4996: --
4997: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_ID',p_Picking_Batch_id);
4998: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_NAME',p_Picking_Batch_name);
4999: --}
5000: END IF;
5001: --
4994: --{
4995: WSH_DEBUG_SV.push(l_module_name);
4996: --
4997: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_ID',p_Picking_Batch_id);
4998: WSH_DEBUG_SV.log(l_module_name,'P_PICKING_BATCH_NAME',p_Picking_Batch_name);
4999: --}
5000: END IF;
5001: --
5002: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5018: END IF;
5019: --
5020: IF l_debug_on THEN
5021: --{
5022: WSH_DEBUG_SV.pop(l_module_name);
5023: --}
5024: END IF;
5025: --
5026: END Validate_Picking_Batch_Name;
5070: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5071: --
5072: IF l_debug_on IS NULL
5073: THEN
5074: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5075: END IF;
5076: --
5077: IF l_debug_on THEN
5078: WSH_DEBUG_SV.push(l_module_name);
5074: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5075: END IF;
5076: --
5077: IF l_debug_on THEN
5078: WSH_DEBUG_SV.push(l_module_name);
5079: --
5080: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
5081: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
5082: END IF;
5076: --
5077: IF l_debug_on THEN
5078: WSH_DEBUG_SV.push(l_module_name);
5079: --
5080: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
5081: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
5082: END IF;
5083: --
5084: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5077: IF l_debug_on THEN
5078: WSH_DEBUG_SV.push(l_module_name);
5079: --
5080: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
5081: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_NAME',P_SHIP_METHOD_NAME);
5082: END IF;
5083: --
5084: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5085: --
5100: --
5101: END IF;
5102: --
5103: IF l_debug_on THEN
5104: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
5105: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
5106: WSH_DEBUG_SV.pop(l_module_name);
5107: END IF;
5108: --
5101: END IF;
5102: --
5103: IF l_debug_on THEN
5104: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
5105: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
5106: WSH_DEBUG_SV.pop(l_module_name);
5107: END IF;
5108: --
5109: EXCEPTION
5102: --
5103: IF l_debug_on THEN
5104: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_ship_method_code);
5105: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_name',p_ship_method_name);
5106: WSH_DEBUG_SV.pop(l_module_name);
5107: END IF;
5108: --
5109: EXCEPTION
5110: WHEN OTHERS THEN
5110: WHEN OTHERS THEN
5111: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5112: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Active_SM');
5113: IF l_debug_on THEN
5114: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5115: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5116: END IF;
5117: END Validate_Active_SM;
5118:
5111: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5112: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Active_SM');
5113: IF l_debug_on THEN
5114: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5115: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5116: END IF;
5117: END Validate_Active_SM;
5118:
5119: -- Added new internal procedure for OTM R12, glog project
5174: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5175: --
5176: IF l_debug_on IS NULL
5177: THEN
5178: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5179: END IF;
5180: --
5181: IF l_debug_on THEN
5182: WSH_DEBUG_SV.push(l_module_name);
5178: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5179: END IF;
5180: --
5181: IF l_debug_on THEN
5182: WSH_DEBUG_SV.push(l_module_name);
5183: --
5184: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
5185: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
5186: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
5180: --
5181: IF l_debug_on THEN
5182: WSH_DEBUG_SV.push(l_module_name);
5183: --
5184: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
5185: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
5186: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
5187: END IF;
5188: --
5181: IF l_debug_on THEN
5182: WSH_DEBUG_SV.push(l_module_name);
5183: --
5184: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
5185: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
5186: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
5187: END IF;
5188: --
5189: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5182: WSH_DEBUG_SV.push(l_module_name);
5183: --
5184: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_TYPE',P_LOOKUP_TYPE);
5185: WSH_DEBUG_SV.log(l_module_name,'P_LOOKUP_CODE',P_LOOKUP_CODE);
5186: WSH_DEBUG_SV.log(l_module_name,'P_MEANING',P_MEANING);
5187: END IF;
5188: --
5189: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5190:
5248:
5249: END IF;
5250: --
5251: IF l_debug_on THEN
5252: WSH_DEBUG_SV.log(l_module_name,'p_lookup_code',p_lookup_code);
5253: WSH_DEBUG_SV.pop(l_module_name);
5254: END IF;
5255:
5256: --
5249: END IF;
5250: --
5251: IF l_debug_on THEN
5252: WSH_DEBUG_SV.log(l_module_name,'p_lookup_code',p_lookup_code);
5253: WSH_DEBUG_SV.pop(l_module_name);
5254: END IF;
5255:
5256: --
5257: EXCEPTION
5261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5262: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Lookup_Upper');
5263: --
5264: IF l_debug_on THEN
5265: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5267: END IF;
5268: --
5269: END Validate_Lookup_Upper;
5262: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Lookup_Upper');
5263: --
5264: IF l_debug_on THEN
5265: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5267: END IF;
5268: --
5269: END Validate_Lookup_Upper;
5270:
5298: --
5299: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5300: --
5301: IF l_debug_on IS NULL THEN
5302: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5303: END IF;
5304: --
5305: IF l_debug_on THEN
5306: WSH_DEBUG_SV.push(l_module_name);
5302: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5303: END IF;
5304: --
5305: IF l_debug_on THEN
5306: WSH_DEBUG_SV.push(l_module_name);
5307: WSH_DEBUG_SV.log(l_module_name,'p_ship_confirm_rule_id',
5308: p_ship_confirm_rule_id);
5309: WSH_DEBUG_SV.log(l_module_name,'p_actual_departure_date',
5310: p_actual_departure_date);
5303: END IF;
5304: --
5305: IF l_debug_on THEN
5306: WSH_DEBUG_SV.push(l_module_name);
5307: WSH_DEBUG_SV.log(l_module_name,'p_ship_confirm_rule_id',
5308: p_ship_confirm_rule_id);
5309: WSH_DEBUG_SV.log(l_module_name,'p_actual_departure_date',
5310: p_actual_departure_date);
5311: END IF;
5305: IF l_debug_on THEN
5306: WSH_DEBUG_SV.push(l_module_name);
5307: WSH_DEBUG_SV.log(l_module_name,'p_ship_confirm_rule_id',
5308: p_ship_confirm_rule_id);
5309: WSH_DEBUG_SV.log(l_module_name,'p_actual_departure_date',
5310: p_actual_departure_date);
5311: END IF;
5312: --
5313: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5318: --
5319: IF NOT v_ValidDate THEN
5320: --
5321: IF l_debug_on THEN
5322: wsh_debug_sv.logmsg(l_module_name, 'Future ship date is not allowed');
5323: END IF;
5324: --
5325: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_FUTURE_SHIP_DATE');
5326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5328: --
5329: END IF;
5330: --
5331: IF l_debug_on THEN
5332: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5333: WSH_DEBUG_SV.pop(l_module_name);
5334: END IF;
5335: --
5336: EXCEPTION
5329: END IF;
5330: --
5331: IF l_debug_on THEN
5332: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
5333: WSH_DEBUG_SV.pop(l_module_name);
5334: END IF;
5335: --
5336: EXCEPTION
5337: --
5340: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5341: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.ValidateActualDepartureDate');
5342: --
5343: IF l_debug_on THEN
5344: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
5345: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5346: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5347: END IF;
5348: --
5341: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.ValidateActualDepartureDate');
5342: --
5343: IF l_debug_on THEN
5344: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
5345: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5346: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5347: END IF;
5348: --
5349: END ValidateActualDepartureDate;
5342: --
5343: IF l_debug_on THEN
5344: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
5345: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5346: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5347: END IF;
5348: --
5349: END ValidateActualDepartureDate;
5350: