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_AUTOCREATE dependencies on WSH_NEW_DELIVERIES_PVT

Line 595: Procedure Create_Update_Hash(p_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

591: -- This API will create a hash based on the grouping attributes of the delivery
592: -- and update the hash_value and hash string in wsh_new_deliveries.
593: -- p_delivery_id : Delivery that needs hash value and string to be updated.
594:
595: Procedure Create_Update_Hash(p_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
596: x_return_status OUT NOCOPY varchar2) IS
597:
598: l_grp_attr_tab grp_attr_tab_type;
599: l_tmp_grp_attr_tab grp_attr_tab_type;

Line 1651: p_delivery_info IN wsh_new_deliveries_pvt.delivery_rec_type,

1647: --
1648: -----------------------------------------------------------------------------
1649:
1650: PROCEDURE Autonomous_Create_Delivery (
1651: p_delivery_info IN wsh_new_deliveries_pvt.delivery_rec_type,
1652: x_rowid OUT NOCOPY VARCHAR2,
1653: x_delivery_id OUT NOCOPY NUMBER,
1654: x_delivery_name OUT NOCOPY VARCHAR2,
1655: x_return_status OUT NOCOPY VARCHAR2)

Line 1675: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

1671: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1672:
1673: IF l_debug_on THEN
1674: WSH_DEBUG_SV.push(l_module_name);
1675: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1676: END IF;
1677: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1678: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1679: IF l_debug_on THEN

Line 1677: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);

1673: IF l_debug_on THEN
1674: WSH_DEBUG_SV.push(l_module_name);
1675: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1676: END IF;
1677: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1678: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1679: IF l_debug_on THEN
1680: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1681: END IF;

Line 1680: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');

1676: END IF;
1677: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1678: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1679: IF l_debug_on THEN
1680: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1681: END IF;
1682: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1683: IF l_debug_on THEN
1684: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

Line 1684: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

1680: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1681: END IF;
1682: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1683: IF l_debug_on THEN
1684: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');
1685: END IF;
1686: RAISE OTHERS;
1687: ELSE
1688: IF l_debug_on THEN

Line 1689: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');

1685: END IF;
1686: RAISE OTHERS;
1687: ELSE
1688: IF l_debug_on THEN
1689: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');
1690: WSH_DEBUG_SV.pop(l_module_name);
1691: END IF;
1692: ROLLBACK;
1693: RETURN;

Line 1805: l_delivery_info wsh_new_deliveries_pvt.delivery_rec_type;

1801: and NVL(NVL(wnd.mode_of_transport, p_mode_of_transport), -1) = NVL(NVL(p_mode_of_transport, wnd.mode_of_transport), -1)
1802: and wnd.status_code in ('OP', 'SA');
1803:
1804: l_group_info grp_attr_tab_type;
1805: l_delivery_info wsh_new_deliveries_pvt.delivery_rec_type;
1806: l_rowid VARCHAR2(30);
1807: l_delivery_id NUMBER;
1808: l_delivery_name wsh_new_deliveries.name%TYPE;
1809: l_weight_uom_code VARCHAR2(10);

Line 2041: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.get_name(l_attr_tab(i).DELIVERY_ID));

2037: END IF;
2038: --
2039: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_ASSIGNED_DEL');
2040: FND_MESSAGE.SET_TOKEN('DET_NAME', l_attr_tab(i).entity_id);
2041: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.get_name(l_attr_tab(i).DELIVERY_ID));
2042: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
2043:
2044: l_assigned_flag := 'Y';
2045:

Line 2201: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);

2197: --}
2198: ELSE
2199: --{ non-parallel-pick case
2200: IF l_debug_on THEN
2201: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2202: END IF;
2203: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2204: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2205: IF l_debug_on THEN

Line 2203: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);

2199: --{ non-parallel-pick case
2200: IF l_debug_on THEN
2201: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2202: END IF;
2203: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2204: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2205: IF l_debug_on THEN
2206: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2207: END IF;

Line 2206: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );

2202: END IF;
2203: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2204: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2205: IF l_debug_on THEN
2206: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2207: END IF;
2208: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2209: IF l_debug_on THEN
2210: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

Line 2210: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

2206: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2207: END IF;
2208: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2209: IF l_debug_on THEN
2210: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');
2211: END IF;
2212: raise others;
2213: ELSE
2214: IF l_debug_on THEN

Line 2215: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');

2211: END IF;
2212: raise others;
2213: ELSE
2214: IF l_debug_on THEN
2215: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');
2216: END IF;
2217: raise e_return_excp;
2218: END IF;
2219: END IF;

Line 3150: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

3146: --OTM R12, allow delete of 'NS' deliveries
3147: IF (l_gc3_is_installed = 'Y') THEN
3148: DELETE FROM wsh_new_deliveries wnd
3149: WHERE batch_id = p_batch_id
3150: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
3151: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
3152: AND NOT EXISTS (
3153: SELECT 'x'
3154: FROM wsh_delivery_assignments wda

Line 3151: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT

3147: IF (l_gc3_is_installed = 'Y') THEN
3148: DELETE FROM wsh_new_deliveries wnd
3149: WHERE batch_id = p_batch_id
3150: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
3151: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
3152: AND NOT EXISTS (
3153: SELECT 'x'
3154: FROM wsh_delivery_assignments wda
3155: WHERE wda.delivery_id = wnd.delivery_id

Line 3824: p_del_attributes_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

3820: -- x_return_status: status.
3821: **/
3822:
3823: PROCEDURE Autocreate_Consol_Delivery(
3824: p_del_attributes_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
3825: p_caller IN VARCHAR2,
3826: p_trip_prefix IN VARCHAR2,
3827: x_parent_del_id OUT NOCOPY NUMBER,
3828: x_parent_trip_id OUT NOCOPY NUMBER,

Line 3857: l_del_attributes WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

3853: l_trip_id NUMBER;
3854: l_trip_id_temp NUMBER;
3855: -- l_trip_info_rec_tab is table of c_trip_info%rowtype index by binary_integer;
3856:
3857: l_del_attributes WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
3858: l_del_tab WSH_UTIL_CORE.id_tab_type;
3859: l_trip_del_tab WSH_UTIL_CORE.id_tab_type;
3860: l_intermediate_loc_tab WSH_UTIL_CORE.id_tab_type;
3861: l_pickup_stop_id NUMBER;

Line 4167: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_new_deliveries_pvt.create_delivery',WSH_DEBUG_SV.C_PROC_LEVEL);

4163:
4164: -- Create the delivery
4165:
4166: IF l_debug_on THEN
4167: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_new_deliveries_pvt.create_delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
4168: END IF;
4169:
4170: wsh_new_deliveries_pvt.create_delivery(l_del_attributes, l_rowid, l_delivery_id, l_delivery_name, l_return_status);
4171:

Line 4170: wsh_new_deliveries_pvt.create_delivery(l_del_attributes, l_rowid, l_delivery_id, l_delivery_name, l_return_status);

4166: IF l_debug_on THEN
4167: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_new_deliveries_pvt.create_delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
4168: END IF;
4169:
4170: wsh_new_deliveries_pvt.create_delivery(l_del_attributes, l_rowid, l_delivery_id, l_delivery_name, l_return_status);
4171:
4172: wsh_util_core.api_post_call
4173: (
4174: p_return_status => l_return_status,