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 862: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

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

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

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

Line 1269: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED

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

Line 1308: l_tms_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

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

Line 1319: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

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

Line 1320: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

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

Line 1556: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

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

Line 1557: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

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

Line 1558: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

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

Line 1559: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

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

Line 1560: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

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

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

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

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

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

Line 1879: (WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

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

Line 1880: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

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

Line 1881: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED,

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

Line 1882: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

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

Line 1883: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

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

Line 1884: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS) AND

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

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

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

Line 1925: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

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

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

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