DBA Data[Home] [Help]

APPS.WSH_TMS_RELEASE dependencies on WSH_TMS_RELEASE

Line 1: PACKAGE BODY WSH_TMS_RELEASE as

1: PACKAGE BODY WSH_TMS_RELEASE as
2: /* $Header: WSHTMRLB.pls 120.12.12010000.3 2009/01/22 07:24:46 anvarshn ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TMS_RELEASE';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TMS_RELEASE';

1: PACKAGE BODY WSH_TMS_RELEASE as
2: /* $Header: WSHTMRLB.pls 120.12.12010000.3 2009/01/22 07:24:46 anvarshn ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TMS_RELEASE';
5:
6: --
7: -- Forward Declaration of Internal procedures
8: --

Line 1719: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;

1715: -- HANDLE INTERFACE_ACTION_CODE of DELETE HERE...and UNASSIGN THE DELIVERIES in EBS
1716: IF l_trip_info_tab(i).interface_action_code = G_TMS_DELETE_CODE THEN--{
1717:
1718: DECLARE
1719: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
1720: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1721:
1722: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1723: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;

Line 2721: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;

2717: END IF;
2718:
2719: DECLARE
2720:
2721: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
2722: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
2723:
2724: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
2725: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;

Line 4150: FND_MSG_PUB.Add_Exc_Msg( 'WSH_TMS_RELEASE', 'Release_Planned_Shipment' );

4146: CLOSE c_get_currency_code;
4147: END IF;
4148: --
4149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4150: FND_MSG_PUB.Add_Exc_Msg( 'WSH_TMS_RELEASE', 'Release_Planned_Shipment' );
4151: END IF;
4152: --
4153: -- Always concurrent request,no online option
4154: l_ret_code := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

Line 4159: 'WSH_TMS_RELEASE.RELEASE_PLANNED_SHIPMENT',

4155: errbuf := 'Exception occurred in Release_Planned_Shipment';
4156: retcode := '2';
4157: --
4158: WSH_UTIL_CORE.DEFAULT_HANDLER(
4159: 'WSH_TMS_RELEASE.RELEASE_PLANNED_SHIPMENT',
4160: l_module_name);
4161: IF l_debug_on THEN
4162: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4163: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4426: 'WSH_TMS_RELEASE.PURGE_INTERFACE_DATA',

4422: END IF;
4423: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4424: ROLLBACK to before_purge;
4425: WSH_UTIL_CORE.DEFAULT_HANDLER(
4426: 'WSH_TMS_RELEASE.PURGE_INTERFACE_DATA',
4427: l_module_name);
4428: IF l_debug_on THEN
4429: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4657: 'WSH_TMS_RELEASE.STAMP_INTERFACE_ERROR',

4653: EXCEPTION
4654: WHEN OTHERS THEN
4655: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4656: WSH_UTIL_CORE.DEFAULT_HANDLER(
4657: 'WSH_TMS_RELEASE.STAMP_INTERFACE_ERROR',
4658: l_module_name);
4659: IF l_debug_on THEN
4660: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4661: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4676: x_delivery_tab OUT NOCOPY WSH_TMS_RELEASE.delivery_tab,

4672: --====================================================
4673: PROCEDURE find_deliveries_for_trip(
4674: p_trip_id IN NUMBER,
4675: p_tp_plan_name IN VARCHAR2,
4676: x_delivery_tab OUT NOCOPY WSH_TMS_RELEASE.delivery_tab,
4677: x_delivery_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4678: x_return_status OUT NOCOPY VARCHAR2) IS
4679:
4680: -- Query deliveries based on p_trip_id

Line 4774: 'WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP',

4770: CLOSE c_get_deliveries2;
4771: END IF;
4772: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4773: WSH_UTIL_CORE.DEFAULT_HANDLER(
4774: 'WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP',
4775: l_module_name);
4776: IF l_debug_on THEN
4777: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4963: 'WSH_TMS_RELEASE.COMPARE_TRIP_FOR_DELIVERIES',

4959: CLOSE c_get_current_trip;
4960: END IF;
4961: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4962: WSH_UTIL_CORE.DEFAULT_HANDLER(
4963: 'WSH_TMS_RELEASE.COMPARE_TRIP_FOR_DELIVERIES',
4964: l_module_name);
4965: IF l_debug_on THEN
4966: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5024: 'WSH_TMS_RELEASE.LAUNCH_RELEASE_REQUEST',

5020: WHEN OTHERS THEN
5021: x_request_id := 0;
5022: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5023: WSH_UTIL_CORE.DEFAULT_HANDLER(
5024: 'WSH_TMS_RELEASE.LAUNCH_RELEASE_REQUEST',
5025: l_module_name);
5026: IF l_debug_on THEN
5027: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5028: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5308: 'WSH_TMS_RELEASE.PROCESS_INTERNAL_LOCATIONS',l_module_name);

5304: WHEN OTHERS THEN
5305: -- Close any open cursors
5306: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5307: WSH_UTIL_CORE.DEFAULT_HANDLER(
5308: 'WSH_TMS_RELEASE.PROCESS_INTERNAL_LOCATIONS',l_module_name);
5309: IF l_debug_on THEN
5310: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5312: END IF;

Line 5411: END WSH_TMS_RELEASE;

5407: END get_server_time;
5408:
5409: --====================================================
5410:
5411: END WSH_TMS_RELEASE;