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 1138: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 1364: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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);
1905: END IF;
1906:
1907: END IF;
1908: l_index := l_tms_delivery_info_tab.NEXT(l_index);

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

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

Line 2272: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2558: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 2992: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 3345: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 3637: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 3778: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 3868: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3864: --
3865: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3866: --
3867: IF l_debug_on IS NULL THEN
3868: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3869: END IF;
3870: --
3871: IF l_debug_on THEN
3872: arp_message.set_line('WSH_CUST_MERGE.Check_LSP_Install()+' || getTimeStamp );