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.

[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_DELIVERY_DETAILS_GRP

Line 1: PACKAGE BODY WSH_DELIVERY_DETAILS_GRP as

1: PACKAGE BODY WSH_DELIVERY_DETAILS_GRP as
2: /* $Header: WSHDDGPB.pls 120.37.12020000.2 2012/11/21 12:32:20 ravmamid ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS_GRP';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS_GRP';

1: PACKAGE BODY WSH_DELIVERY_DETAILS_GRP as
2: /* $Header: WSHDDGPB.pls 120.37.12020000.2 2012/11/21 12:32:20 ravmamid ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS_GRP';
6: p_message_type CONSTANT VARCHAR2(1) := 'E';
7: c_wms_code_present VARCHAR2(1) := 'Y';
8:
9: -- anxsharm for Load Tender

Line 613: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');

609:
610: WHEN OTHERS THEN
611: ROLLBACK TO detail_to_delivery_grp;
612: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
613: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
614: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
615: p_encoded => fnd_api.g_false);
616:
617: IF l_debug_on THEN

Line 675: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY', wsh_debug_sv.c_proc_level);

671: END IF;
672:
673:
674: IF l_debug_on THEN
675: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY', wsh_debug_sv.c_proc_level);
676: END IF;
677:
678: DETAIL_TO_DELIVERY
679: (

Line 701: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');

697: EXCEPTION
698:
699: WHEN OTHERS THEN
700: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
701: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
702: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
703: p_encoded => fnd_api.g_false);
704:
705: IF l_debug_on THEN

Line 1055: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Split_Line');

1051: WHEN OTHERS THEN
1052: ROLLBACK TO split_line_grp;
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: wsh_util_core.add_message(x_return_status, l_module_name);
1055: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Split_Line');
1056:
1057: fnd_msg_pub.count_and_get(
1058: p_count => x_msg_count,
1059: p_data => x_msg_data,

Line 1499: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Shipping_Attributes');

1495: END IF;
1496: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1497: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1498: WSH_UTIL_CORE.add_message (x_return_status);
1499: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Shipping_Attributes');
1500: FND_MSG_PUB.Count_And_Get
1501: ( p_count => x_msg_count,
1502: p_data => x_msg_data,
1503: p_encoded => FND_API.G_FALSE

Line 1580: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Detail_Status');

1576:
1577: /*
1578: EXCEPTION
1579: WHEN others then
1580: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Detail_Status');
1581: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1582: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1583: if x_msg_count > 1 then
1584: x_msg_data := l_msg_summary || l_msg_details;

Line 1987: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries');

1983: WHEN OTHERS THEN
1984: ROLLBACK TO AUTOCREATE_DEL_GRP;
1985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1986: wsh_util_core.add_message(x_return_status, l_module_name);
1987: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries');
1988: --
1989: -- Start of code for Bugfix 4070732
1990: --
1991: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 2197: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Del_Trip');

2193: WHEN OTHERS THEN
2194: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2196: wsh_util_core.add_message(x_return_status, l_module_name);
2197: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Del_Trip');
2198: FND_MSG_PUB.Count_And_Get
2199: (
2200: p_count => x_msg_count,
2201: p_data => x_msg_data,

Line 3154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

3150: l_index := l_id_tab.NEXT(l_index);
3151: END LOOP;
3152: --
3153: IF l_debug_on THEN
3154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
3155: END IF;
3156: --
3157: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(
3158: p_api_version => l_api_version,

Line 3157: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(

3153: IF l_debug_on THEN
3154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
3155: END IF;
3156: --
3157: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(
3158: p_api_version => l_api_version,
3159: p_init_msg_list => FND_API.G_FALSE,
3160: p_commit => FND_API.G_FALSE,
3161: p_validation_level => l_validation_level,

Line 3288: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.SPLIT_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);

3284:
3285: -- HW Harmonization project forOPM. Added p_manual_split parameter
3286: -- HW added p_converted_flag
3287: IF l_debug_on THEN
3288: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.SPLIT_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
3289: END IF;
3290: WSH_DELIVERY_DETAILS_GRP.split_line(
3291: p_api_version => l_api_version,
3292: p_init_msg_list => FND_API.G_FALSE,

Line 3290: WSH_DELIVERY_DETAILS_GRP.split_line(

3286: -- HW added p_converted_flag
3287: IF l_debug_on THEN
3288: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.SPLIT_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
3289: END IF;
3290: WSH_DELIVERY_DETAILS_GRP.split_line(
3291: p_api_version => l_api_version,
3292: p_init_msg_list => FND_API.G_FALSE,
3293: p_commit => FND_API.G_FALSE,
3294: p_validation_level => l_validation_level,

Line 3320: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

3316: --
3317: ELSIF p_action_prms.action_code = 'AUTOCREATE-DEL' THEN
3318: --
3319: IF l_debug_on THEN
3320: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
3321: END IF;
3322: --
3323: --Compatibility Changes
3324: IF wsh_util_core.fte_is_installed = 'Y' AND l_cc_line_groups.COUNT>0 THEN

Line 3359: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(

3355: IF l_debug_on THEN
3356: wsh_debug_sv.log(l_module_name,'id_tab_temp count ',l_id_tab_temp.COUNT);
3357: END IF;
3358:
3359: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3360: p_api_version_number => l_api_version,
3361: p_init_msg_list => FND_API.G_FALSE,
3362: p_commit => FND_API.G_FALSE,
3363: p_caller => p_action_prms.caller,

Line 3450: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(

3446: END IF;
3447:
3448: ELSE
3449:
3450: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3451: p_api_version_number => l_api_version,
3452: p_init_msg_list => FND_API.G_FALSE,
3453: p_commit => FND_API.G_FALSE,
3454: p_caller => p_action_prms.caller,

Line 3496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

3492: --
3493: ELSIF p_action_prms.action_code = 'AUTOCREATE-TRIP' THEN
3494: --
3495: IF l_debug_on THEN
3496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3497: END IF;
3498: --
3499: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(
3500: p_api_version_number => l_api_version,

Line 3499: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(

3495: IF l_debug_on THEN
3496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3497: END IF;
3498: --
3499: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(
3500: p_api_version_number => l_api_version,
3501: p_init_msg_list => FND_API.G_FALSE,
3502: p_commit => FND_API.G_FALSE,
3503: x_return_status => l_return_status,

Line 4609: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action');

4605: IF cycle_count_cur%ISOPEN THEN
4606: Close cycle_count_cur;
4607: END IF;
4608: wsh_util_core.add_message(x_return_status, l_module_name);
4609: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action');
4610: --
4611: -- K LPN CONV. rv
4612: --
4613: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

Line 4900: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');

4896: WHEN OTHERS THEN
4897: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4899: wsh_util_core.add_message(x_return_status, l_module_name);
4900: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
4901: FND_MSG_PUB.Count_And_Get
4902: (
4903: p_count => x_msg_count,
4904: p_data => x_msg_data,

Line 5705: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_containers');

5701: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5702: rollback to s_create_containers_DDGPB;
5703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5704: wsh_util_core.add_message(x_return_status, l_module_name);
5705: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_containers');
5706: IF l_debug_on THEN
5707: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5708: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5709: END IF;

Line 6090: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Delivery_Detail');

6086:
6087: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6089: wsh_util_core.add_message(x_return_status, l_module_name);
6090: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Delivery_Detail');
6091: FND_MSG_PUB.Count_And_Get
6092: (
6093: p_count => x_msg_count,
6094: p_data => x_msg_data,

Line 6937: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Delivery_Detail');

6933:
6934: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6936: wsh_util_core.add_message(x_return_status, l_module_name);
6937: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Delivery_Detail');
6938:
6939: FND_MSG_PUB.Count_And_Get
6940: (
6941: p_count => x_msg_count,

Line 7259: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Delivery_Detail');

7255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7256: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7257: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7258: wsh_util_core.add_message(x_return_status, l_module_name);
7259: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Delivery_Detail');
7260:
7261: FND_MSG_PUB.Count_And_Get
7262: (
7263: p_count => x_msg_count,

Line 7467: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delete_Delivery_Detail');

7463:
7464: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7466: wsh_util_core.add_message(x_return_status, l_module_name);
7467: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delete_Delivery_Detail');
7468: FND_MSG_PUB.Count_And_Get
7469: (
7470: p_count => x_msg_count,
7471: p_data => x_msg_data,

Line 9341: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');

9337: WHEN OTHERS THEN
9338: ROLLBACK TO validate_det_line_grp;
9339: x_return_status := fnd_api.g_ret_sts_unexp_error;
9340: wsh_util_core.add_message(x_return_status, l_module_name);
9341: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');
9342: fnd_msg_pub.count_and_get(
9343: p_count => x_msg_count,
9344: p_data => x_msg_data,
9345: p_encoded => fnd_api.g_false);

Line 9548: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Container');

9544: WHEN OTHERS THEN
9545: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9547: wsh_util_core.add_message(x_return_status, l_module_name);
9548: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Container');
9549: FND_MSG_PUB.Count_And_Get
9550: (
9551: p_count => x_msg_count,
9552: p_data => x_msg_data,

Line 9884: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Common');

9880: WHEN OTHERS THEN
9881: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9883: wsh_util_core.add_message(x_return_status, l_module_name);
9884: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Common');
9885: FND_MSG_PUB.Count_And_Get
9886: (
9887: p_count => x_msg_count,
9888: p_data => x_msg_data,

Line 10000: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Serial_Quantity');

9996:
9997: WHEN OTHERS THEN
9998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9999: wsh_util_core.add_message(x_return_status, l_module_name);
10000: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Serial_Quantity');
10001: --
10002:
10003: IF l_debug_on THEN
10004: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 10823: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');

10819: WHEN OTHERS THEN
10820: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10822: wsh_util_core.add_message(x_return_status, l_module_name);
10823: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
10824: --
10825: -- Start code for Bugfix 4070732
10826: --
10827: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)

Line 10995: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping');

10991:
10992: WHEN OTHERS THEN
10993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10994: wsh_util_core.add_message(x_return_status, l_module_name);
10995: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping');
10996: --
10997: IF l_debug_on THEN
10998: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10999: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 11003: END WSH_DELIVERY_DETAILS_GRP;

10999: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
11000: END IF;
11001: END Get_Carton_Grouping;
11002:
11003: END WSH_DELIVERY_DETAILS_GRP;