eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_USA_CATEGORIES_PVT dependencies on WSH_USA_CATEGORIES_PVT

Line 1: PACKAGE BODY WSH_USA_CATEGORIES_PVT as

1: PACKAGE BODY WSH_USA_CATEGORIES_PVT as
2: /* $Header: WSHUSACB.pls 120.16 2008/01/08 20:03:52 mvudugul ship $ */
3:
4: -- 2071048
5: CURSOR c_cache_attributes_1(p_source_line_id IN NUMBER,

Line 133: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_CATEGORIES_PVT';

129: -- to be called by the Change Attribute procedures that
130: -- require exceptions to be logged.
131:
132: --
133: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_CATEGORIES_PVT';
134: --
135: PROCEDURE Log_Exception(
136: p_delivery_detail_id IN NUMBER,
137: p_location_id IN NUMBER,

Line 245: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Log_Exception',l_module_name);

241:
242: WHEN OTHERS THEN
243: -- close open cursors as needed
244: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
245: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Log_Exception',l_module_name);
246: --
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
249: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 359: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Cache_Changed_Attributes',l_module_name);

355: CLOSE c_cache_attributes_2;
356: END IF;
357: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
358: --
359: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Cache_Changed_Attributes',l_module_name);
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
362: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
363: END IF;

Line 463: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_WMS',l_module_name);

459: --
460: EXCEPTION
461: WHEN OTHERS THEN
462: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
463: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_WMS',l_module_name);
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
467: END IF;

Line 476: x_changed_detail OUT NOCOPY WSH_USA_CATEGORIES_PVT.ChangedDetailRec,

472:
473: PROCEDURE Check_Attributes(
474: p_source_code IN VARCHAR2,
475: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,
476: x_changed_detail OUT NOCOPY WSH_USA_CATEGORIES_PVT.ChangedDetailRec,
477: x_update_allowed OUT NOCOPY VARCHAR2,
478: x_return_status OUT NOCOPY VARCHAR2)
479: IS
480: update_not_allowed EXCEPTION;

Line 537: WSH_USA_CATEGORIES_PVT.Change_Schedule(

533: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
534: RAISE others;
535: END IF;
536:
537: WSH_USA_CATEGORIES_PVT.Change_Schedule(
538: p_attributes_rec => p_attributes_rec,
539: p_source_code => p_source_code,
540: p_wms_flag => l_wms_flag,
541: x_update_allowed => l_update_allowed,

Line 547: WSH_USA_CATEGORIES_PVT.Change_Scheduled_Date(

543: IF (l_update_allowed = 'N')
544: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
545: RAISE update_not_allowed;
546: END IF;
547: WSH_USA_CATEGORIES_PVT.Change_Scheduled_Date(
548: p_attributes_rec => p_attributes_rec,
549: p_source_code => p_source_code,
550: p_wms_flag => l_wms_flag,
551: x_update_allowed => l_update_allowed,

Line 563: WSH_USA_CATEGORIES_PVT.Change_Sets(

559: END IF;
560:
561: -- HW OPM BUG#:2296620 09/27 Need to remove the branch since OPM is supporting shipsets
562:
563: WSH_USA_CATEGORIES_PVT.Change_Sets(
564: p_attributes_rec => p_attributes_rec,
565: p_source_code => p_source_code,
566: p_wms_flag => l_wms_flag,
567: x_update_allowed => l_update_allowed,

Line 574: WSH_USA_CATEGORIES_PVT.Change_Delivery_Group(

570: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
571: RAISE update_not_allowed;
572: END IF;
573:
574: WSH_USA_CATEGORIES_PVT.Change_Delivery_Group(
575: p_attributes_rec => p_attributes_rec,
576: p_source_code => p_source_code,
577: p_wms_flag => l_wms_flag,
578: x_update_allowed => l_update_allowed,

Line 586: WSH_USA_CATEGORIES_PVT.Change_Ship_Tolerance(

582: RAISE update_not_allowed;
583: END IF;
584:
585: -- Bug 2181132 for overship tolerance
586: WSH_USA_CATEGORIES_PVT.Change_Ship_Tolerance(
587: p_attributes_rec => p_attributes_rec,
588: p_source_code => p_source_code,
589: p_wms_flag => l_wms_flag,
590: x_update_allowed => l_update_allowed,

Line 600: WSH_USA_CATEGORIES_PVT.Change_Quantity( -- Change in Quantity

596: END IF;
597:
598: IF (p_attributes_rec.action_flag <> 'S') THEN
599: -- we check quantity change only if this record is not an action to split.
600: WSH_USA_CATEGORIES_PVT.Change_Quantity( -- Change in Quantity
601: p_attributes_rec => p_attributes_rec,
602: p_source_code => p_source_code,
603: p_wms_flag => l_wms_flag,
604: x_update_allowed => l_update_allowed,

Line 611: WSH_USA_CATEGORIES_PVT.Change_TP_DATES(

607: IF (l_update_allowed = 'N')
608: OR (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
609: RAISE update_not_allowed;
610: END IF;
611: WSH_USA_CATEGORIES_PVT.Change_TP_DATES(
612: p_attributes_rec => p_attributes_rec,
613: p_source_code => p_source_code,
614: x_changed_detail => x_changed_detail,
615: x_update_allowed => l_update_allowed,

Line 643: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_Categories',l_module_name);

639: --
640: RETURN;
641: WHEN OTHERS THEN
642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
643: wsh_util_core.default_handler('WSH_USA_CATEGORIES_PVT.Check_Categories',l_module_name);
644: --
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 658: x_changed_detail OUT NOCOPY WSH_USA_CATEGORIES_PVT.ChangedDetailRec,

654:
655: PROCEDURE Change_TP_Dates(
656: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,
657: p_source_code IN VARCHAR2,
658: x_changed_detail OUT NOCOPY WSH_USA_CATEGORIES_PVT.ChangedDetailRec,
659: x_update_allowed IN OUT NOCOPY VARCHAR2,
660: x_return_status OUT NOCOPY VARCHAR2) IS
661:
662: update_not_allowed EXCEPTION;

Line 783: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_TP_DATES',l_module_name);

779: WHEN OTHERS THEN
780: -- close open cursors as needed
781: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
782: x_update_allowed := 'N';
783: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_TP_DATES',l_module_name);
784: --
785: IF l_debug_on THEN
786: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
787: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 869: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Quantity',l_module_name);

865: WHEN OTHERS THEN
866: -- close open cursors as needed
867: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
868: x_update_allowed := 'N';
869: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Quantity',l_module_name);
870: --
871: IF l_debug_on THEN
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2116: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Schedule',l_module_name);

2112: -- close open cursors as needed
2113: --ROLLBACK TO before_changes;
2114: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2115: x_update_allowed := 'N';
2116: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Schedule',l_module_name);
2117: --
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2259: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Scheduled_Date',l_module_name);

2255: close c_delivery_detail;
2256: END IF;
2257: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2258: x_update_allowed := 'N';
2259: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Scheduled_Date',l_module_name);
2260: --
2261: IF l_debug_on THEN
2262: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2263: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2480: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Sets',l_module_name);

2476: close c_get_released_status;
2477: END IF;
2478: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2479: x_update_allowed := 'N';
2480: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Sets',l_module_name);
2481: --
2482: IF l_debug_on THEN
2483: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2484: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3134: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Delivery_Group',l_module_name);

3130: CLOSE c_get_parent_container;
3131: END IF;
3132: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3133: x_update_allowed := 'N';
3134: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Delivery_Group',l_module_name);
3135: --
3136: IF l_debug_on THEN
3137: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3138: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3272: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Ship_Tolerance',l_module_name);

3268: WHEN OTHERS THEN
3269: -- close open cursors as needed
3270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3271: x_update_allowed := 'N';
3272: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Ship_Tolerance',l_module_name);
3273: --
3274: IF l_debug_on THEN
3275: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3282: END WSH_USA_CATEGORIES_PVT;

3278: --
3279:
3280: END Change_Ship_Tolerance;
3281:
3282: END WSH_USA_CATEGORIES_PVT;