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

247: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
248: --
249: IF l_debug_on IS NULL
250: THEN
251: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
252: END IF;
253: --
254: IF l_debug_on THEN
255: WSH_DEBUG_SV.push(l_module_name);

Line 255: WSH_DEBUG_SV.push(l_module_name);

251: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
252: END IF;
253: --
254: IF l_debug_on THEN
255: WSH_DEBUG_SV.push(l_module_name);
256: --
257: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
258: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
259: END IF;

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

253: --
254: IF l_debug_on THEN
255: WSH_DEBUG_SV.push(l_module_name);
256: --
257: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
258: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
259: END IF;
260: --
261: --Get Delivery With Trip Details

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

254: IF l_debug_on THEN
255: WSH_DEBUG_SV.push(l_module_name);
256: --
257: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
258: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
259: END IF;
260: --
261: --Get Delivery With Trip Details
262: OPEN get_trip_delivery_info(p_delivery_name);

Line 350: WSH_DEBUG_SV.pop(l_module_name);

346: --
347: -- Debug Statements
348: --
349: IF l_debug_on THEN
350: WSH_DEBUG_SV.pop(l_module_name);
351: END IF;
352: --
353: EXCEPTION
354: WHEN OTHERS THEN

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

364: --
365: -- Debug Statements
366: --
367: IF l_debug_on THEN
368: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
369: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
370: END IF;
371: --
372: RAISE;

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

365: -- Debug Statements
366: --
367: IF l_debug_on THEN
368: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
369: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
370: END IF;
371: --
372: RAISE;
373:

Line 425: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

421: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
422: --
423: IF l_debug_on IS NULL
424: THEN
425: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
426: END IF;
427: --
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.push(l_module_name);

Line 429: WSH_DEBUG_SV.push(l_module_name);

425: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
426: END IF;
427: --
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.push(l_module_name);
430: --
431: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
432: WSH_DEBUG_SV.log(l_module_name,'P_TRACKING_NUMBER_DD',P_TRACKING_NUMBER_DD);
433: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);

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

427: --
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.push(l_module_name);
430: --
431: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
432: WSH_DEBUG_SV.log(l_module_name,'P_TRACKING_NUMBER_DD',P_TRACKING_NUMBER_DD);
433: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
434: END IF;
435: --

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

428: IF l_debug_on THEN
429: WSH_DEBUG_SV.push(l_module_name);
430: --
431: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
432: WSH_DEBUG_SV.log(l_module_name,'P_TRACKING_NUMBER_DD',P_TRACKING_NUMBER_DD);
433: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
434: END IF;
435: --
436: x_tracking_details.delete;

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

429: WSH_DEBUG_SV.push(l_module_name);
430: --
431: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
432: WSH_DEBUG_SV.log(l_module_name,'P_TRACKING_NUMBER_DD',P_TRACKING_NUMBER_DD);
433: WSH_DEBUG_SV.log(l_module_name,'P_MODE',P_MODE);
434: END IF;
435: --
436: x_tracking_details.delete;
437: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 459: WSH_DEBUG_SV.pop(l_module_name);

455: --
456: -- Debug Statements
457: --
458: IF l_debug_on THEN
459: WSH_DEBUG_SV.pop(l_module_name);
460: END IF;
461: --
462: EXCEPTION
463:

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

467: --
468: -- Debug Statements
469: --
470: IF l_debug_on THEN
471: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRACKING_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_TRACKING_EXCEPTION');
473: END IF;
474: --
475:

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

468: -- Debug Statements
469: --
470: IF l_debug_on THEN
471: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRACKING_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_TRACKING_EXCEPTION');
473: END IF;
474: --
475:
476: WHEN wsh_unexpected_error THEN

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

479: --
480: -- Debug Statements
481: --
482: IF l_debug_on THEN
483: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
484: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UNEXPECTED_ERROR');
485: END IF;
486: --
487: WHEN OTHERS THEN

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

480: -- Debug Statements
481: --
482: IF l_debug_on THEN
483: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
484: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UNEXPECTED_ERROR');
485: END IF;
486: --
487: WHEN OTHERS THEN
488:

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

492: -- Debug Statements
493: --
494:
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
498: END IF;
499: --
500: END;

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

493: --
494:
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
498: END IF;
499: --
500: END;
501: END WSH_SHIPPING_INFO;