76: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
77: --
78: IF l_debug_on IS NULL
79: THEN
80: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
81: END IF;
82: --
83: IF l_debug_on THEN
84: WSH_DEBUG_SV.push(l_module_name);
80: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
81: END IF;
82: --
83: IF l_debug_on THEN
84: WSH_DEBUG_SV.push(l_module_name);
85: --
86: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_NUMBER',P_RECORD_NUMBER);
87: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_STATUS',P_DELIVERY_STATUS);
88: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
82: --
83: IF l_debug_on THEN
84: WSH_DEBUG_SV.push(l_module_name);
85: --
86: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_NUMBER',P_RECORD_NUMBER);
87: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_STATUS',P_DELIVERY_STATUS);
88: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
89: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_NAME',P_LOCATION_NAME);
90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);
83: IF l_debug_on THEN
84: WSH_DEBUG_SV.push(l_module_name);
85: --
86: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_NUMBER',P_RECORD_NUMBER);
87: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_STATUS',P_DELIVERY_STATUS);
88: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
89: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_NAME',P_LOCATION_NAME);
90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);
91: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DEPARTURE_DATE',P_ACTUAL_DEPARTURE_DATE);
84: WSH_DEBUG_SV.push(l_module_name);
85: --
86: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_NUMBER',P_RECORD_NUMBER);
87: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_STATUS',P_DELIVERY_STATUS);
88: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
89: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_NAME',P_LOCATION_NAME);
90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);
91: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DEPARTURE_DATE',P_ACTUAL_DEPARTURE_DATE);
92: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
85: --
86: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_NUMBER',P_RECORD_NUMBER);
87: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_STATUS',P_DELIVERY_STATUS);
88: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
89: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_NAME',P_LOCATION_NAME);
90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);
91: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DEPARTURE_DATE',P_ACTUAL_DEPARTURE_DATE);
92: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
93: WSH_DEBUG_SV.log(l_module_name,'P_BILL_OF_LADING',P_BILL_OF_LADING);
86: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_NUMBER',P_RECORD_NUMBER);
87: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_STATUS',P_DELIVERY_STATUS);
88: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
89: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_NAME',P_LOCATION_NAME);
90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);
91: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DEPARTURE_DATE',P_ACTUAL_DEPARTURE_DATE);
92: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
93: WSH_DEBUG_SV.log(l_module_name,'P_BILL_OF_LADING',P_BILL_OF_LADING);
94: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_NAME',P_CARRIER_NAME);
87: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_STATUS',P_DELIVERY_STATUS);
88: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
89: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_NAME',P_LOCATION_NAME);
90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);
91: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DEPARTURE_DATE',P_ACTUAL_DEPARTURE_DATE);
92: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
93: WSH_DEBUG_SV.log(l_module_name,'P_BILL_OF_LADING',P_BILL_OF_LADING);
94: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_NAME',P_CARRIER_NAME);
95: END IF;
88: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
89: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_NAME',P_LOCATION_NAME);
90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);
91: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DEPARTURE_DATE',P_ACTUAL_DEPARTURE_DATE);
92: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
93: WSH_DEBUG_SV.log(l_module_name,'P_BILL_OF_LADING',P_BILL_OF_LADING);
94: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_NAME',P_CARRIER_NAME);
95: END IF;
96: --
89: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_NAME',P_LOCATION_NAME);
90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);
91: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DEPARTURE_DATE',P_ACTUAL_DEPARTURE_DATE);
92: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
93: WSH_DEBUG_SV.log(l_module_name,'P_BILL_OF_LADING',P_BILL_OF_LADING);
94: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_NAME',P_CARRIER_NAME);
95: END IF;
96: --
97: IF p_record_number IS NULL THEN
90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);
91: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DEPARTURE_DATE',P_ACTUAL_DEPARTURE_DATE);
92: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);
93: WSH_DEBUG_SV.log(l_module_name,'P_BILL_OF_LADING',P_BILL_OF_LADING);
94: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_NAME',P_CARRIER_NAME);
95: END IF;
96: --
97: IF p_record_number IS NULL THEN
98: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
124: --
125: -- Debug Statements
126: --
127: IF l_debug_on THEN
128: WSH_DEBUG_SV.pop(l_module_name);
129: END IF;
130: --
131: END Fill_Track_Record;
132:
246: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
247: --
248: IF l_debug_on IS NULL
249: THEN
250: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
251: END IF;
252: --
253: IF l_debug_on THEN
254: WSH_DEBUG_SV.push(l_module_name);
250: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
251: END IF;
252: --
253: IF l_debug_on THEN
254: WSH_DEBUG_SV.push(l_module_name);
255: --
256: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
257: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
258: END IF;
252: --
253: IF l_debug_on THEN
254: WSH_DEBUG_SV.push(l_module_name);
255: --
256: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
257: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
258: END IF;
259: --
260: --Get Delivery With Trip Details
253: IF l_debug_on THEN
254: WSH_DEBUG_SV.push(l_module_name);
255: --
256: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
257: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
258: END IF;
259: --
260: --Get Delivery With Trip Details
261: OPEN get_trip_delivery_info(p_delivery_name);
345: --
346: -- Debug Statements
347: --
348: IF l_debug_on THEN
349: WSH_DEBUG_SV.pop(l_module_name);
350: END IF;
351: --
352: EXCEPTION
353: WHEN OTHERS THEN
363: --
364: -- Debug Statements
365: --
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
369: END IF;
370: --
371: RAISE;
364: -- Debug Statements
365: --
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
369: END IF;
370: --
371: RAISE;
372:
420: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
421: --
422: IF l_debug_on IS NULL
423: THEN
424: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
425: END IF;
426: --
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.push(l_module_name);
424: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
425: END IF;
426: --
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.push(l_module_name);
429: --
430: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
431: WSH_DEBUG_SV.log(l_module_name,'P_TRACKING_NUMBER_DD',P_TRACKING_NUMBER_DD);
432: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
426: --
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.push(l_module_name);
429: --
430: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
431: WSH_DEBUG_SV.log(l_module_name,'P_TRACKING_NUMBER_DD',P_TRACKING_NUMBER_DD);
432: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
433: END IF;
434: --
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.push(l_module_name);
429: --
430: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
431: WSH_DEBUG_SV.log(l_module_name,'P_TRACKING_NUMBER_DD',P_TRACKING_NUMBER_DD);
432: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
433: END IF;
434: --
435: x_tracking_details.delete;
428: WSH_DEBUG_SV.push(l_module_name);
429: --
430: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
431: WSH_DEBUG_SV.log(l_module_name,'P_TRACKING_NUMBER_DD',P_TRACKING_NUMBER_DD);
432: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
433: END IF;
434: --
435: x_tracking_details.delete;
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
454: --
455: -- Debug Statements
456: --
457: IF l_debug_on THEN
458: WSH_DEBUG_SV.pop(l_module_name);
459: END IF;
460: --
461: EXCEPTION
462:
466: --
467: -- Debug Statements
468: --
469: IF l_debug_on THEN
470: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRACKING_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_TRACKING_EXCEPTION');
472: END IF;
473: --
474:
467: -- Debug Statements
468: --
469: IF l_debug_on THEN
470: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRACKING_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_TRACKING_EXCEPTION');
472: END IF;
473: --
474:
475: WHEN wsh_unexpected_error THEN
478: --
479: -- Debug Statements
480: --
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
483: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UNEXPECTED_ERROR');
484: END IF;
485: --
486: WHEN OTHERS THEN
479: -- Debug Statements
480: --
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
483: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UNEXPECTED_ERROR');
484: END IF;
485: --
486: WHEN OTHERS THEN
487:
491: -- Debug Statements
492: --
493:
494: IF l_debug_on THEN
495: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
497: END IF;
498: --
499: END;
492: --
493:
494: IF l_debug_on THEN
495: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
497: END IF;
498: --
499: END;
500: END WSH_SHIPPING_INFO;