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 665: Procedure Create_Update_Hash(p_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,

661: -- This API will create a hash based on the grouping attributes of the delivery
662: -- and update the hash_value and hash string in wsh_new_deliveries.
663: -- p_delivery_id : Delivery that needs hash value and string to be updated.
664:
665: Procedure Create_Update_Hash(p_delivery_rec IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
666: x_return_status OUT NOCOPY varchar2) IS
667:
668: l_grp_attr_tab grp_attr_tab_type;
669: l_tmp_grp_attr_tab grp_attr_tab_type;

Line 1881: p_delivery_info IN wsh_new_deliveries_pvt.delivery_rec_type,

1877: --
1878: -----------------------------------------------------------------------------
1879:
1880: PROCEDURE Autonomous_Create_Delivery (
1881: p_delivery_info IN wsh_new_deliveries_pvt.delivery_rec_type,
1882: x_rowid OUT NOCOPY VARCHAR2,
1883: x_delivery_id OUT NOCOPY NUMBER,
1884: x_delivery_name OUT NOCOPY VARCHAR2,
1885: x_return_status OUT NOCOPY VARCHAR2)

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

1901: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1902:
1903: IF l_debug_on THEN
1904: WSH_DEBUG_SV.push(l_module_name);
1905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1906: END IF;
1907: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1908: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1909: IF l_debug_on THEN

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

1903: IF l_debug_on THEN
1904: WSH_DEBUG_SV.push(l_module_name);
1905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1906: END IF;
1907: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1908: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1911: END IF;

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

1906: END IF;
1907: WSH_NEW_DELIVERIES_PVT.Create_Delivery(p_delivery_info, x_rowid, x_delivery_id, x_delivery_name, x_return_status);
1908: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1911: END IF;
1912: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

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

1910: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY ');
1911: END IF;
1912: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');
1915: END IF;
1916: RAISE OTHERS;
1917: ELSE
1918: IF l_debug_on THEN

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

1915: END IF;
1916: RAISE OTHERS;
1917: ELSE
1918: IF l_debug_on THEN
1919: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');
1920: WSH_DEBUG_SV.pop(l_module_name);
1921: END IF;
1922: ROLLBACK;
1923: RETURN;

Line 2035: l_delivery_info wsh_new_deliveries_pvt.delivery_rec_type;

2031: and NVL(NVL(wnd.mode_of_transport, p_mode_of_transport), -1) = NVL(NVL(p_mode_of_transport, wnd.mode_of_transport), -1)
2032: and wnd.status_code in ('OP', 'SA');
2033:
2034: l_group_info grp_attr_tab_type;
2035: l_delivery_info wsh_new_deliveries_pvt.delivery_rec_type;
2036: l_rowid VARCHAR2(30);
2037: l_delivery_id NUMBER;
2038: l_delivery_name wsh_new_deliveries.name%TYPE;
2039: l_weight_uom_code VARCHAR2(10);

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

2272: END IF;
2273: --
2274: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_ASSIGNED_DEL');
2275: FND_MESSAGE.SET_TOKEN('DET_NAME', l_attr_tab(i).entity_id);
2276: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.get_name(l_attr_tab(i).DELIVERY_ID));
2277: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
2278:
2279: l_assigned_flag := 'Y';
2280:

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

2447: --}
2448: ELSE
2449: --{ non-parallel-pick case
2450: IF l_debug_on THEN
2451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2452: END IF;
2453: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2454: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2455: IF l_debug_on THEN

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

2449: --{ non-parallel-pick case
2450: IF l_debug_on THEN
2451: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
2452: END IF;
2453: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2454: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2457: END IF;

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

2452: END IF;
2453: wsh_new_deliveries_pvt.create_delivery(l_delivery_info, l_rowid, l_delivery_id, l_delivery_name, x_return_status);
2454: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2457: END IF;
2458: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2459: IF l_debug_on THEN
2460: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');

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

2456: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY FOR '||P_LINE_ROWS ( I ) );
2457: END IF;
2458: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2459: IF l_debug_on THEN
2460: WSH_DEBUG_SV.logmsg(l_module_name,'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED UNEXPECTED ERROR');
2461: END IF;
2462: raise others;
2463: ELSE
2464: IF l_debug_on THEN

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

2461: END IF;
2462: raise others;
2463: ELSE
2464: IF l_debug_on THEN
2465: WSH_DEBUG_SV.logmsg(l_module_name, 'PROC WSH_NEW_DELIVERIES_PVT.CREATE_DELIVERY RETURNED ERROR');
2466: END IF;
2467: raise e_return_excp;
2468: END IF;
2469: END IF;

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

3404: --OTM R12, allow delete of 'NS' deliveries
3405: IF (l_gc3_is_installed = 'Y') THEN
3406: DELETE FROM wsh_new_deliveries wnd
3407: WHERE batch_id = p_batch_id
3408: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
3409: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
3410: AND NOT EXISTS (
3411: SELECT 'x'
3412: FROM wsh_delivery_assignments wda

Line 3409: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT

3405: IF (l_gc3_is_installed = 'Y') THEN
3406: DELETE FROM wsh_new_deliveries wnd
3407: WHERE batch_id = p_batch_id
3408: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
3409: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
3410: AND NOT EXISTS (
3411: SELECT 'x'
3412: FROM wsh_delivery_assignments wda
3413: WHERE wda.delivery_id = wnd.delivery_id

Line 4083: p_del_attributes_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

4079: -- x_return_status: status.
4080: **/
4081:
4082: PROCEDURE Autocreate_Consol_Delivery(
4083: p_del_attributes_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
4084: p_caller IN VARCHAR2,
4085: p_trip_prefix IN VARCHAR2,
4086: x_parent_del_id OUT NOCOPY NUMBER,
4087: x_parent_trip_id OUT NOCOPY NUMBER,

Line 4116: l_del_attributes WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

4112: l_trip_id NUMBER;
4113: l_trip_id_temp NUMBER;
4114: -- l_trip_info_rec_tab is table of c_trip_info%rowtype index by binary_integer;
4115:
4116: l_del_attributes WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4117: l_del_tab WSH_UTIL_CORE.id_tab_type;
4118: l_trip_del_tab WSH_UTIL_CORE.id_tab_type;
4119: l_intermediate_loc_tab WSH_UTIL_CORE.id_tab_type;
4120: l_pickup_stop_id NUMBER;

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

4422:
4423: -- Create the delivery
4424:
4425: IF l_debug_on THEN
4426: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_new_deliveries_pvt.create_delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
4427: END IF;
4428:
4429: wsh_new_deliveries_pvt.create_delivery(l_del_attributes, l_rowid, l_delivery_id, l_delivery_name, l_return_status);
4430:

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

4425: IF l_debug_on THEN
4426: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_new_deliveries_pvt.create_delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
4427: END IF;
4428:
4429: wsh_new_deliveries_pvt.create_delivery(l_del_attributes, l_rowid, l_delivery_id, l_delivery_name, l_return_status);
4430:
4431: wsh_util_core.api_post_call
4432: (
4433: p_return_status => l_return_status,