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

Line 838: l_interface_flag_tab(l_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

834: raise FND_API.G_EXC_ERROR;
835: ELSIF (l_is_delivery_empty = 'Y') THEN
836: l_count := l_count + 1;
837: l_delivery_id_tab(l_count) := l_deliveryIdTab(l_index);
838: l_interface_flag_tab(l_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
839: IF (l_debug_on) THEN
840: arp_message.set_line('l_count-'||l_count||' l_delivery_id_tab-'||l_delivery_id_tab(l_count)||' l_interface_flag_tab-'||l_interface_flag_tab(l_count));
841: END IF;
842: ELSIF (l_is_delivery_empty = 'N') THEN

Line 859: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

855: l_index := l_deliveryIdTab.NEXT(l_index);
856: END LOOP;
857:
858: IF l_count > 0 THEN
859: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
860: p_delivery_id_tab => l_delivery_id_tab,
861: p_tms_interface_flag_tab => l_interface_flag_tab,
862: x_return_status => l_return_status);
863:

Line 867: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

863:
864: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
865: --
866: IF l_debug_on THEN
867: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
868: END IF;
869: RAISE Unassign_Del_Exp;
870: END IF;
871: END IF;

Line 1266: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED

1262: WHERE wdl.pick_up_stop_id = wts.stop_id
1263: AND wts.trip_id = p_trip_id
1264: AND wdl.delivery_id = wnd.delivery_id
1265: AND wnd.status_code = 'OP'
1266: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED
1267: AND wnd.delivery_id <> p_exclude_dlvy;
1268:
1269: -- getting empty deliveries that belongs to the customer and matches the drop
1270: -- off location id

Line 1305: l_tms_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1301: l_dlvy_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1302: l_gc3_is_installed VARCHAR2(1);
1303:
1304: frcost_not_found EXCEPTION;
1305: l_tms_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1306: l_tms_trip_tab WSH_DELIVERY_VALIDATIONS.trip_info_tab_type;
1307: l_new_delivery_leg_tab g_rowid_tbl_type;
1308: l_delivery_leg_count NUMBER;
1309: l_ignoreTab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 1316: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1312:
1313: -- End of OTM R12 : customer merge
1314:
1315: -- OTM R12 : update delivery
1316: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1317: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1318: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1319: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1320: l_trip_not_found VARCHAR2(1);

Line 1317: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

1313: -- End of OTM R12 : customer merge
1314:
1315: -- OTM R12 : update delivery
1316: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1317: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1318: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1319: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1320: l_trip_not_found VARCHAR2(1);
1321: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 1553: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

1549: = nvl(G_FROM_LOCATION_ID, -1) AND
1550: nvl(l_delivery_info.ultimate_dropoff_location_id, -1)
1551: <> nvl(G_TO_LOCATION_ID, -1)) THEN
1552: IF (l_delivery_info.tms_interface_flag NOT IN
1553: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1554: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1555: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1556: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 1554: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

1550: nvl(l_delivery_info.ultimate_dropoff_location_id, -1)
1551: <> nvl(G_TO_LOCATION_ID, -1)) THEN
1552: IF (l_delivery_info.tms_interface_flag NOT IN
1553: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1554: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1555: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1556: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1558: l_tms_update(l_index) := 'Y';

Line 1555: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

1551: <> nvl(G_TO_LOCATION_ID, -1)) THEN
1552: IF (l_delivery_info.tms_interface_flag NOT IN
1553: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1554: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1555: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1556: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1558: l_tms_update(l_index) := 'Y';
1559: l_delivery_count := l_delivery_count + 1;

Line 1556: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

1552: IF (l_delivery_info.tms_interface_flag NOT IN
1553: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1554: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1555: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1556: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1558: l_tms_update(l_index) := 'Y';
1559: l_delivery_count := l_delivery_count + 1;
1560: l_delivery_info_tab(l_delivery_count) := l_delivery_info;

Line 1557: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

1553: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
1554: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
1555: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1556: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
1557: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1558: l_tms_update(l_index) := 'Y';
1559: l_delivery_count := l_delivery_count + 1;
1560: l_delivery_info_tab(l_delivery_count) := l_delivery_info;
1561: l_new_interface_flag_tab(l_delivery_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 1561: l_new_interface_flag_tab(l_delivery_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

1557: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
1558: l_tms_update(l_index) := 'Y';
1559: l_delivery_count := l_delivery_count + 1;
1560: l_delivery_info_tab(l_delivery_count) := l_delivery_info;
1561: l_new_interface_flag_tab(l_delivery_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
1562: l_tms_version_number(l_index) := nvl(l_delivery_info.tms_version_number, 1) + 1;
1563: l_tms_interface_flag(l_index) := l_new_interface_flag_tab(l_delivery_count);
1564: END IF;
1565: END IF; -- checking the value differences

Line 1603: nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

1599: program_update_date = SYSDATE,
1600: -- OTM R12 : update delivery
1601: TMS_INTERFACE_FLAG = decode(l_tms_update(updCnt), 'Y',
1602: l_tms_interface_flag(updCnt),
1603: nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
1604: TMS_VERSION_NUMBER = decode(l_tms_update(updCnt), 'Y',
1605: l_tms_version_number(updCnt),
1606: nvl(TMS_VERSION_NUMBER, 1))
1607: -- End of OTM R12 : update delivery

Line 1876: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

1872: -- Include DR to count empty deliveries that are assigned
1873: -- to trip, they should be unassigned + the drop off location should be updated
1874: IF (l_tms_delivery_info_tab(l_index).ignore_for_planning = 'N' AND
1875: l_tms_delivery_info_tab(l_index).tms_interface_flag IN
1876: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1877: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1878: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1879: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

Line 1877: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

1873: -- to trip, they should be unassigned + the drop off location should be updated
1874: IF (l_tms_delivery_info_tab(l_index).ignore_for_planning = 'N' AND
1875: l_tms_delivery_info_tab(l_index).tms_interface_flag IN
1876: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1877: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1878: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1879: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND

Line 1878: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

1874: IF (l_tms_delivery_info_tab(l_index).ignore_for_planning = 'N' AND
1875: l_tms_delivery_info_tab(l_index).tms_interface_flag IN
1876: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1877: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1878: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1879: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND
1882: l_tms_delivery_info_tab(l_index).status_code = 'OP' AND

Line 1879: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

1875: l_tms_delivery_info_tab(l_index).tms_interface_flag IN
1876: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1877: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1878: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1879: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND
1882: l_tms_delivery_info_tab(l_index).status_code = 'OP' AND
1883: l_tms_trip_tab(l_index).status_code = 'OP') THEN

Line 1880: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

1876: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
1877: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1878: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1879: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND
1882: l_tms_delivery_info_tab(l_index).status_code = 'OP' AND
1883: l_tms_trip_tab(l_index).status_code = 'OP') THEN
1884:

Line 1881: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND

1877: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
1878: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,
1879: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
1880: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
1881: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND
1882: l_tms_delivery_info_tab(l_index).status_code = 'OP' AND
1883: l_tms_trip_tab(l_index).status_code = 'OP') THEN
1884:
1885: -- it is already assigned to a trip,

Line 1900: l_aw_interface_flag_tab(l_aw_interface_flag_tab.count + 1) := WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER;

1896: -- with the trip
1897:
1898: FOR rec in c_get_deliveries(l_tms_trip_tab(l_index).trip_id, l_tms_delivery_info_tab(l_index).delivery_id) LOOP
1899: l_aw_dlvy_tab(l_aw_dlvy_tab.count + 1) := rec.delivery_id;
1900: l_aw_interface_flag_tab(l_aw_interface_flag_tab.count + 1) := WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER;
1901: END LOOP;
1902:
1903: IF l_debug_on THEN
1904: WSH_DEBUG_SV.LOG('my module', 'unassign delivery count-'||l_dlvy_id_tab.COUNT||' aw delivery count-'||l_aw_dlvy_tab.COUNT);

Line 1922: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

1918: -- Log appropriate exceptions(within the API)
1919: -- Need to update the version number also
1920: IF l_aw_dlvy_tab.count > 0 THEN
1921: -- Call Update after the above LOOP
1922: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
1923: p_delivery_id_tab => l_aw_dlvy_tab,
1924: p_tms_interface_flag_tab => l_aw_interface_flag_tab,
1925: x_return_status => l_return_status);
1926: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 1928: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

1924: p_tms_interface_flag_tab => l_aw_interface_flag_tab,
1925: x_return_status => l_return_status);
1926: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1927: IF l_debug_on THEN
1928: ARP_MESSAGE.Set_Error('Error returned from API WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
1929: END IF;
1930: RAISE Update_Del_Exp;
1931: END IF;
1932: END IF;