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_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.28.12010000.2 2008/09/15 12:58:13 gbhargav 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.28.12010000.2 2008/09/15 12:58:13 gbhargav 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 609: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');

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

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

667: END IF;
668:
669:
670: IF l_debug_on THEN
671: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY', wsh_debug_sv.c_proc_level);
672: END IF;
673:
674: DETAIL_TO_DELIVERY
675: (

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

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

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

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

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

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

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

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

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

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

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

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

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

3143: l_index := l_id_tab.NEXT(l_index);
3144: END LOOP;
3145: --
3146: IF l_debug_on THEN
3147: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
3148: END IF;
3149: --
3150: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(
3151: p_api_version => l_api_version,

Line 3150: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(

3146: IF l_debug_on THEN
3147: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
3148: END IF;
3149: --
3150: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(
3151: p_api_version => l_api_version,
3152: p_init_msg_list => FND_API.G_FALSE,
3153: p_commit => FND_API.G_FALSE,
3154: p_validation_level => l_validation_level,

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

3277:
3278: -- HW Harmonization project forOPM. Added p_manual_split parameter
3279: -- HW added p_converted_flag
3280: IF l_debug_on THEN
3281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.SPLIT_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
3282: END IF;
3283: WSH_DELIVERY_DETAILS_GRP.split_line(
3284: p_api_version => l_api_version,
3285: p_init_msg_list => FND_API.G_FALSE,

Line 3283: WSH_DELIVERY_DETAILS_GRP.split_line(

3279: -- HW added p_converted_flag
3280: IF l_debug_on THEN
3281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.SPLIT_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
3282: END IF;
3283: WSH_DELIVERY_DETAILS_GRP.split_line(
3284: p_api_version => l_api_version,
3285: p_init_msg_list => FND_API.G_FALSE,
3286: p_commit => FND_API.G_FALSE,
3287: p_validation_level => l_validation_level,

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

3309: --
3310: ELSIF p_action_prms.action_code = 'AUTOCREATE-DEL' THEN
3311: --
3312: IF l_debug_on THEN
3313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
3314: END IF;
3315: --
3316: --Compatibility Changes
3317: IF wsh_util_core.fte_is_installed = 'Y' AND l_cc_line_groups.COUNT>0 THEN

Line 3352: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(

3348: IF l_debug_on THEN
3349: wsh_debug_sv.log(l_module_name,'id_tab_temp count ',l_id_tab_temp.COUNT);
3350: END IF;
3351:
3352: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3353: p_api_version_number => l_api_version,
3354: p_init_msg_list => FND_API.G_FALSE,
3355: p_commit => FND_API.G_FALSE,
3356: p_caller => p_action_prms.caller,

Line 3443: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(

3439: END IF;
3440:
3441: ELSE
3442:
3443: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3444: p_api_version_number => l_api_version,
3445: p_init_msg_list => FND_API.G_FALSE,
3446: p_commit => FND_API.G_FALSE,
3447: p_caller => p_action_prms.caller,

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

3485: --
3486: ELSIF p_action_prms.action_code = 'AUTOCREATE-TRIP' THEN
3487: --
3488: IF l_debug_on THEN
3489: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3490: END IF;
3491: --
3492: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(
3493: p_api_version_number => l_api_version,

Line 3492: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(

3488: IF l_debug_on THEN
3489: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3490: END IF;
3491: --
3492: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(
3493: p_api_version_number => l_api_version,
3494: p_init_msg_list => FND_API.G_FALSE,
3495: p_commit => FND_API.G_FALSE,
3496: x_return_status => l_return_status,

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

4595: IF cycle_count_cur%ISOPEN THEN
4596: Close cycle_count_cur;
4597: END IF;
4598: wsh_util_core.add_message(x_return_status, l_module_name);
4599: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action');
4600: --
4601: -- K LPN CONV. rv
4602: --
4603: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

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

4886: WHEN OTHERS THEN
4887: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4889: wsh_util_core.add_message(x_return_status, l_module_name);
4890: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
4891: FND_MSG_PUB.Count_And_Get
4892: (
4893: p_count => x_msg_count,
4894: p_data => x_msg_data,

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

5691: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5692: rollback to s_create_containers_DDGPB;
5693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5694: wsh_util_core.add_message(x_return_status, l_module_name);
5695: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_containers');
5696: IF l_debug_on THEN
5697: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5698: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5699: END IF;

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

6076:
6077: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6079: wsh_util_core.add_message(x_return_status, l_module_name);
6080: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Delivery_Detail');
6081: FND_MSG_PUB.Count_And_Get
6082: (
6083: p_count => x_msg_count,
6084: p_data => x_msg_data,

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

6846:
6847: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6849: wsh_util_core.add_message(x_return_status, l_module_name);
6850: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Delivery_Detail');
6851:
6852: FND_MSG_PUB.Count_And_Get
6853: (
6854: p_count => x_msg_count,

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

7168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7169: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7170: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7171: wsh_util_core.add_message(x_return_status, l_module_name);
7172: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Delivery_Detail');
7173:
7174: FND_MSG_PUB.Count_And_Get
7175: (
7176: p_count => x_msg_count,

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

7376:
7377: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7379: wsh_util_core.add_message(x_return_status, l_module_name);
7380: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delete_Delivery_Detail');
7381: FND_MSG_PUB.Count_And_Get
7382: (
7383: p_count => x_msg_count,
7384: p_data => x_msg_data,

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

9217: WHEN OTHERS THEN
9218: ROLLBACK TO validate_det_line_grp;
9219: x_return_status := fnd_api.g_ret_sts_unexp_error;
9220: wsh_util_core.add_message(x_return_status, l_module_name);
9221: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');
9222: fnd_msg_pub.count_and_get(
9223: p_count => x_msg_count,
9224: p_data => x_msg_data,
9225: p_encoded => fnd_api.g_false);

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

9424: WHEN OTHERS THEN
9425: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9427: wsh_util_core.add_message(x_return_status, l_module_name);
9428: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Container');
9429: FND_MSG_PUB.Count_And_Get
9430: (
9431: p_count => x_msg_count,
9432: p_data => x_msg_data,

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

9760: WHEN OTHERS THEN
9761: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9763: wsh_util_core.add_message(x_return_status, l_module_name);
9764: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Common');
9765: FND_MSG_PUB.Count_And_Get
9766: (
9767: p_count => x_msg_count,
9768: p_data => x_msg_data,

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

9876:
9877: WHEN OTHERS THEN
9878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9879: wsh_util_core.add_message(x_return_status, l_module_name);
9880: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Serial_Quantity');
9881: --
9882:
9883: IF l_debug_on THEN
9884: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

10699: WHEN OTHERS THEN
10700: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10702: wsh_util_core.add_message(x_return_status, l_module_name);
10703: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
10704: --
10705: -- Start code for Bugfix 4070732
10706: --
10707: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)

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

10871:
10872: WHEN OTHERS THEN
10873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10874: wsh_util_core.add_message(x_return_status, l_module_name);
10875: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping');
10876: --
10877: IF l_debug_on THEN
10878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 10883: END WSH_DELIVERY_DETAILS_GRP;

10879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
10880: END IF;
10881: END Get_Carton_Grouping;
10882:
10883: END WSH_DELIVERY_DETAILS_GRP;