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.21.12020000.3 2012/08/17 13:23:36 skanduku 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 613: WSH_USA_CATEGORIES_PVT.Change_TP_DATES(

609: RAISE update_not_allowed;
610: END IF;
611: -- Standalone Project - Do no call Change_TP_Dates API if instance is running in Standalone mode
612: IF NVL(WMS_DEPLOY.Wms_Deployment_Mode,'I') <> 'D' THEN --{
613: WSH_USA_CATEGORIES_PVT.Change_TP_DATES(
614: p_attributes_rec => p_attributes_rec,
615: p_source_code => p_source_code,
616: x_changed_detail => x_changed_detail,
617: x_update_allowed => l_update_allowed,

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

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

Line 662: x_changed_detail OUT NOCOPY WSH_USA_CATEGORIES_PVT.ChangedDetailRec,

658:
659: PROCEDURE Change_TP_Dates(
660: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,
661: p_source_code IN VARCHAR2,
662: x_changed_detail OUT NOCOPY WSH_USA_CATEGORIES_PVT.ChangedDetailRec,
663: x_update_allowed IN OUT NOCOPY VARCHAR2,
664: x_return_status OUT NOCOPY VARCHAR2) IS
665:
666: update_not_allowed EXCEPTION;

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

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

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

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

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

2218: -- close open cursors as needed
2219: --ROLLBACK TO before_changes;
2220: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2221: x_update_allowed := 'N';
2222: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Schedule',l_module_name);
2223: --
2224: IF l_debug_on THEN
2225: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

2413: close c_delivery_detail;
2414: END IF;
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2416: x_update_allowed := 'N';
2417: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Scheduled_Date',l_module_name);
2418: --
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

2634: close c_get_released_status;
2635: END IF;
2636: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2637: x_update_allowed := 'N';
2638: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Sets',l_module_name);
2639: --
2640: IF l_debug_on THEN
2641: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2642: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

3288: CLOSE c_get_parent_container;
3289: END IF;
3290: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3291: x_update_allowed := 'N';
3292: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Delivery_Group',l_module_name);
3293: --
3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3296: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

3426: WHEN OTHERS THEN
3427: -- close open cursors as needed
3428: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3429: x_update_allowed := 'N';
3430: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_CATEGORIES_PVT.Change_Ship_Tolerance',l_module_name);
3431: --
3432: IF l_debug_on THEN
3433: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3434: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3440: END WSH_USA_CATEGORIES_PVT;

3436: --
3437:
3438: END Change_Ship_Tolerance;
3439:
3440: END WSH_USA_CATEGORIES_PVT;