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.4 2009/12/03 14:24:22 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.4 2009/12/03 14:24:22 anvarshn ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TMS_RELEASE';
5:
6: --
7: -- Forward Declaration of Internal procedures
8: --

Line 1727: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;

1723: -- HANDLE INTERFACE_ACTION_CODE of DELETE HERE...and UNASSIGN THE DELIVERIES in EBS
1724: IF l_trip_info_tab(i).interface_action_code = G_TMS_DELETE_CODE THEN--{
1725:
1726: DECLARE
1727: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
1728: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1729:
1730: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1731: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;

Line 2729: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;

2725: END IF;
2726:
2727: DECLARE
2728:
2729: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
2730: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
2731:
2732: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
2733: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;

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

4154: CLOSE c_get_currency_code;
4155: END IF;
4156: --
4157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4158: FND_MSG_PUB.Add_Exc_Msg( 'WSH_TMS_RELEASE', 'Release_Planned_Shipment' );
4159: END IF;
4160: --
4161: -- Always concurrent request,no online option
4162: l_ret_code := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

Line 4167: 'WSH_TMS_RELEASE.RELEASE_PLANNED_SHIPMENT',

4163: errbuf := 'Exception occurred in Release_Planned_Shipment';
4164: retcode := '2';
4165: --
4166: WSH_UTIL_CORE.DEFAULT_HANDLER(
4167: 'WSH_TMS_RELEASE.RELEASE_PLANNED_SHIPMENT',
4168: l_module_name);
4169: IF l_debug_on THEN
4170: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4171: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4434: 'WSH_TMS_RELEASE.PURGE_INTERFACE_DATA',

4430: END IF;
4431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4432: ROLLBACK to before_purge;
4433: WSH_UTIL_CORE.DEFAULT_HANDLER(
4434: 'WSH_TMS_RELEASE.PURGE_INTERFACE_DATA',
4435: l_module_name);
4436: IF l_debug_on THEN
4437: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4438: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4665: 'WSH_TMS_RELEASE.STAMP_INTERFACE_ERROR',

4661: EXCEPTION
4662: WHEN OTHERS THEN
4663: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4664: WSH_UTIL_CORE.DEFAULT_HANDLER(
4665: 'WSH_TMS_RELEASE.STAMP_INTERFACE_ERROR',
4666: l_module_name);
4667: IF l_debug_on THEN
4668: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4669: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4684: x_delivery_tab OUT NOCOPY WSH_TMS_RELEASE.delivery_tab,

4680: --====================================================
4681: PROCEDURE find_deliveries_for_trip(
4682: p_trip_id IN NUMBER,
4683: p_tp_plan_name IN VARCHAR2,
4684: x_delivery_tab OUT NOCOPY WSH_TMS_RELEASE.delivery_tab,
4685: x_delivery_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4686: x_return_status OUT NOCOPY VARCHAR2) IS
4687:
4688: -- Query deliveries based on p_trip_id

Line 4782: 'WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP',

4778: CLOSE c_get_deliveries2;
4779: END IF;
4780: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4781: WSH_UTIL_CORE.DEFAULT_HANDLER(
4782: 'WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP',
4783: l_module_name);
4784: IF l_debug_on THEN
4785: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4786: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4971: 'WSH_TMS_RELEASE.COMPARE_TRIP_FOR_DELIVERIES',

4967: CLOSE c_get_current_trip;
4968: END IF;
4969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4970: WSH_UTIL_CORE.DEFAULT_HANDLER(
4971: 'WSH_TMS_RELEASE.COMPARE_TRIP_FOR_DELIVERIES',
4972: l_module_name);
4973: IF l_debug_on THEN
4974: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4975: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5032: 'WSH_TMS_RELEASE.LAUNCH_RELEASE_REQUEST',

5028: WHEN OTHERS THEN
5029: x_request_id := 0;
5030: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5031: WSH_UTIL_CORE.DEFAULT_HANDLER(
5032: 'WSH_TMS_RELEASE.LAUNCH_RELEASE_REQUEST',
5033: l_module_name);
5034: IF l_debug_on THEN
5035: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5036: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

5312: WHEN OTHERS THEN
5313: -- Close any open cursors
5314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5315: WSH_UTIL_CORE.DEFAULT_HANDLER(
5316: 'WSH_TMS_RELEASE.PROCESS_INTERNAL_LOCATIONS',l_module_name);
5317: IF l_debug_on THEN
5318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5320: END IF;

Line 5419: END WSH_TMS_RELEASE;

5415: END get_server_time;
5416:
5417: --====================================================
5418:
5419: END WSH_TMS_RELEASE;