DBA Data[Home] [Help]

APPS.WSH_CUST_MERGE dependencies on WSH_DEBUG_SV

Line 113: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

109: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
110: --
111: IF l_debug_on IS NULL
112: THEN
113: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
114: END IF;
115: --
116: --
117: IF l_debug_on THEN

Line 238: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

234: --
235: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
236: --
237: IF l_debug_on IS NULL THEN
238: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
239: END IF;
240:
241: --
242: IF l_debug_on THEN

Line 428: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

424: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
425: --
426: IF l_debug_on IS NULL
427: THEN
428: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
429: END IF;
430: --
431: --
432: IF l_debug_on THEN

Line 686: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

682: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
683: --
684: IF l_debug_on IS NULL
685: THEN
686: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
687: END IF;
688: --
689: IF l_debug_on THEN
690: arp_message.set_line('WSH_CUST_MERGE.Unassign_Details_From_Delivery()+' || getTimeStamp );

Line 1141: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1137: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1138: --
1139: IF l_debug_on IS NULL
1140: THEN
1141: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1142: END IF;
1143: --
1144: IF l_debug_on THEN
1145: arp_message.set_line('WSH_CUST_MERGE.Get_Delivery_Hash()+' || getTimeStamp );

Line 1367: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1363: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1364: --
1365: IF l_debug_on IS NULL
1366: THEN
1367: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1368: END IF;
1369: --
1370: IF l_debug_on THEN
1371: arp_message.set_line('WSH_CUST_MERGE.Process_Deliveries()+' || getTimeStamp );

Line 1518: WSH_DEBUG_SV.log('my_module','l_delivery_id-'||l_delivery_info.delivery_id

1514: RETURN;
1515: END IF;
1516:
1517: IF l_debug_on THEN
1518: WSH_DEBUG_SV.log('my_module','l_delivery_id-'||l_delivery_info.delivery_id
1519: ||' l_dropoff_location-'||l_delivery_info.ultimate_dropoff_location_id
1520: ||' l_tms_interface_flag-'||l_delivery_info.tms_interface_flag
1521: ||' l_tms_version_number-'||l_delivery_info.tms_version_number
1522: ||' g_from_location-'||G_FROM_LOCATION_ID

Line 1536: WSH_DEBUG_SV.log('my_module','tms_count', l_tms_count);

1532: l_tms_trip_tab(l_tms_count) := l_trip_info_rec;
1533: END IF;
1534:
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.log('my_module','tms_count', l_tms_count);
1537: END IF;
1538:
1539: IF (l_trip_info_rec.trip_id IS NULL) THEN
1540: l_trip_not_found := 'Y';

Line 1573: WSH_DEBUG_SV.log('my_module','l_delivery_id-'||l_delivery_info.delivery_id

1569: END IF; -- IF ((l_trip_not_found = 'N' AND
1570: END IF; -- if ignore_for_planning
1571:
1572: IF l_debug_on THEN
1573: WSH_DEBUG_SV.log('my_module','l_delivery_id-'||l_delivery_info.delivery_id
1574: ||' l_tms_update-'||l_tms_update(l_index)
1575: ||' l_tms_interface_flag-'||l_tms_interface_flag(l_index)
1576: ||' l_tms_version_number-'||l_tms_version_number(l_index));
1577: arp_message.set_line('l_tms_update-'||l_tms_update(l_index)

Line 1632: WSH_DEBUG_SV.log('my module', 'rows updated', l_deliveryIdTab.COUNT);

1628: --
1629: setARMessageRowCount( 'WSH_NEW_DELIVERIES', SQL%ROWCOUNT );
1630:
1631: IF l_debug_on THEN
1632: WSH_DEBUG_SV.log('my module', 'rows updated', l_deliveryIdTab.COUNT);
1633: WSH_DEBUG_SV.log('my module', 'rows suppose to update', l_hash_value_tab.COUNT);
1634: END IF;
1635:
1636: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )

Line 1633: WSH_DEBUG_SV.log('my module', 'rows suppose to update', l_hash_value_tab.COUNT);

1629: setARMessageRowCount( 'WSH_NEW_DELIVERIES', SQL%ROWCOUNT );
1630:
1631: IF l_debug_on THEN
1632: WSH_DEBUG_SV.log('my module', 'rows updated', l_deliveryIdTab.COUNT);
1633: WSH_DEBUG_SV.log('my module', 'rows suppose to update', l_hash_value_tab.COUNT);
1634: END IF;
1635:
1636: IF ( G_PROFILE_VAL IS NOT NULL AND G_PROFILE_VAL = 'Y' )
1637: THEN

Line 1795: WSH_DEBUG_SV.log('my_module','tms_delivery_id_count', l_tms_delivery_id_tab.count);

1791: --initilization.
1792: l_tms_count := l_tms_delivery_info_tab.COUNT;
1793:
1794: IF l_debug_on THEN
1795: WSH_DEBUG_SV.log('my_module','tms_delivery_id_count', l_tms_delivery_id_tab.count);
1796: END IF;
1797:
1798: -- for loop to populate
1799: l_index := l_tms_delivery_id_tab.FIRST;

Line 1826: WSH_DEBUG_SV.log('my_module','l_delivery_id-'||l_delivery_info.delivery_id

1822: RETURN;
1823: END IF;
1824:
1825: IF l_debug_on THEN
1826: WSH_DEBUG_SV.log('my_module','l_delivery_id-'||l_delivery_info.delivery_id
1827: ||' l_dropoff_location-'||l_delivery_info.ultimate_dropoff_location_id
1828: ||' l_tms_interface_flag-'||l_delivery_info.tms_interface_flag
1829: ||' l_tms_version_number-'||l_delivery_info.tms_version_number
1830: ||' g_from_location-'||G_FROM_LOCATION_ID||' g_to_location-'||G_TO_LOCATION_ID);

Line 1832: WSH_DEBUG_SV.log('my_module','tms_count', l_tms_count);

1828: ||' l_tms_interface_flag-'||l_delivery_info.tms_interface_flag
1829: ||' l_tms_version_number-'||l_delivery_info.tms_version_number
1830: ||' g_from_location-'||G_FROM_LOCATION_ID||' g_to_location-'||G_TO_LOCATION_ID);
1831:
1832: WSH_DEBUG_SV.log('my_module','tms_count', l_tms_count);
1833: END IF;
1834:
1835: --if trip exist, save the information for later delivery unassign
1836: IF (l_trip_info_rec.trip_id IS NOT NULL

Line 1845: WSH_DEBUG_SV.log('my_module','tms_count', l_tms_count);

1841: l_tms_trip_tab(l_tms_count) := l_trip_info_rec;
1842: END IF;
1843:
1844: IF l_debug_on THEN
1845: WSH_DEBUG_SV.log('my_module','tms_count', l_tms_count);
1846: END IF;
1847:
1848: END IF;
1849: l_index := l_tms_delivery_id_tab.NEXT(l_index);

Line 1853: WSH_DEBUG_SV.log('my_module','AFTER LOOP tms_count', l_tms_count);

1849: l_index := l_tms_delivery_id_tab.NEXT(l_index);
1850: END LOOP;
1851:
1852: IF l_debug_on THEN
1853: WSH_DEBUG_SV.log('my_module','AFTER LOOP tms_count', l_tms_count);
1854: END IF;
1855:
1856: --for all the deliveries saved, need to unassign from trip and delete the freight cost
1857: IF (l_tms_count > 0) THEN

Line 1862: WSH_DEBUG_SV.log('my_module', l_index || 'delivery id-'||l_tms_delivery_info_tab(l_index).delivery_id

1858: l_index := l_tms_delivery_info_tab.FIRST;
1859: WHILE (l_index IS NOT NULL) LOOP
1860:
1861: IF l_debug_on THEN
1862: WSH_DEBUG_SV.log('my_module', l_index || 'delivery id-'||l_tms_delivery_info_tab(l_index).delivery_id
1863: ||' ignore for planning-'||l_tms_delivery_info_tab(l_index).ignore_for_planning
1864: ||' tms flag-'||l_tms_delivery_info_tab(l_index).tms_interface_flag
1865: ||' delivery status-'||l_tms_delivery_info_tab(l_index).status_code
1866: ||' trip_status-'||l_tms_trip_tab(l_index).status_code);

Line 1907: WSH_DEBUG_SV.LOG('my module', 'unassign delivery count-'||l_dlvy_id_tab.COUNT||' aw delivery count-'||l_aw_dlvy_tab.COUNT);

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);
1908: END IF;
1909:
1910: END IF;
1911: l_index := l_tms_delivery_info_tab.NEXT(l_index);

Line 1916: WSH_DEBUG_SV.LOG('my module', 'unassign delivery count-'||l_dlvy_id_tab.COUNT||' aw delivery count-'||l_aw_dlvy_tab.COUNT);

1912: END LOOP; --end of finding include for planning deliveries
1913: END IF;
1914:
1915: IF l_debug_on THEN
1916: WSH_DEBUG_SV.LOG('my module', 'unassign delivery count-'||l_dlvy_id_tab.COUNT||' aw delivery count-'||l_aw_dlvy_tab.COUNT);
1917: arp_message.set_line('unassign delivery count-'||l_dlvy_id_tab.COUNT||' aw delivery count-'||l_aw_dlvy_tab.COUNT);
1918: END IF;
1919:
1920: -- Update the Interface Flag to AW for selected deliveries

Line 2275: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2271: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2272: --
2273: IF l_debug_on IS NULL
2274: THEN
2275: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2276: END IF;
2277: --
2278: IF l_debug_on THEN
2279: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Deliveries()+' || getTimeStamp );

Line 2561: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2557: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2558: --
2559: IF l_debug_on IS NULL
2560: THEN
2561: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2562: END IF;
2563: --
2564: IF l_debug_on THEN
2565: arp_message.set_line('WSH_CUST_MERGE.Process_Open_Lines()+' || getTimeStamp );

Line 2995: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2991: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2992: --
2993: IF l_debug_on IS NULL
2994: THEN
2995: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2996: END IF;
2997: --
2998: IF l_debug_on THEN
2999: arp_message.set_line('WSH_CUST_MERGE.Delivery_Details()+' || getTimeStamp );

Line 3348: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3344: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3345: --
3346: IF l_debug_on IS NULL
3347: THEN
3348: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3349: END IF;
3350: --
3351: IF l_debug_on THEN
3352: arp_message.set_line('WSH_CUST_MERGE.PICKING_BATCHES()+' || getTimeStamp);

Line 3640: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3636: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3637: --
3638: IF l_debug_on IS NULL
3639: THEN
3640: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3641: END IF;
3642: --
3643: IF l_debug_on THEN
3644: arp_message.set_line('WSH_CUST_MERGE.PICKING_RULES()+' || getTimeStamp);

Line 3781: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3777: --
3778: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3779: --
3780: IF l_debug_on IS NULL THEN
3781: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3782: END IF;
3783: --
3784: IF l_debug_on THEN
3785: arp_message.set_line('WSH_CUST_MERGE.Check_WMS_Details()+' || getTimeStamp );