DBA Data[Home] [Help]

APPS.WSH_SHIPPING_INFO dependencies on WSH_DEBUG_SV

Line 80: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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);

Line 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);

Line 86: WSH_DEBUG_SV.log(l_module_name,'P_RECORD_NUMBER',P_RECORD_NUMBER);

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);

Line 87: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_STATUS',P_DELIVERY_STATUS);

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);

Line 88: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);

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);

Line 89: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_NAME',P_LOCATION_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);
93: WSH_DEBUG_SV.log(l_module_name,'P_BILL_OF_LADING',P_BILL_OF_LADING);

Line 90: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_ARRIVAL_DATE',P_ACTUAL_ARRIVAL_DATE);

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);

Line 91: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DEPARTURE_DATE',P_ACTUAL_DEPARTURE_DATE);

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;

Line 92: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',P_SHIP_METHOD_CODE);

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: --

Line 93: WSH_DEBUG_SV.log(l_module_name,'P_BILL_OF_LADING',P_BILL_OF_LADING);

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

Line 94: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_NAME',P_CARRIER_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
98: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');

Line 128: WSH_DEBUG_SV.pop(l_module_name);

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:

Line 250: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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);

Line 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;

Line 256: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);

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

Line 257: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);

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);

Line 349: WSH_DEBUG_SV.pop(l_module_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

Line 367: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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;

Line 368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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:

Line 424: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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);

Line 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);

Line 430: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);

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: --

Line 431: WSH_DEBUG_SV.log(l_module_name,'P_TRACKING_NUMBER_DD',P_TRACKING_NUMBER_DD);

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;

Line 432: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);

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;

Line 458: WSH_DEBUG_SV.pop(l_module_name);

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:

Line 470: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRACKING_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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:

Line 471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_TRACKING_EXCEPTION');

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

Line 482: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

Line 483: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UNEXPECTED_ERROR');

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:

Line 495: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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;

Line 496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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;