DBA Data[Home] [Help]

APPS.WSH_PACKING_SLIPS_PVT dependencies on WSH_DEBUG_SV

Line 48: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

44: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
45: --
46: IF l_debug_on IS NULL
47: THEN
48: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
49: END IF;
50: --
51: IF l_debug_on THEN
52: WSH_DEBUG_SV.push(l_module_name);

Line 52: WSH_DEBUG_SV.push(l_module_name);

48: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
49: END IF;
50: --
51: IF l_debug_on THEN
52: WSH_DEBUG_SV.push(l_module_name);
53: --
54: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
55: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
56: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 54: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

50: --
51: IF l_debug_on THEN
52: WSH_DEBUG_SV.push(l_module_name);
53: --
54: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
55: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
56: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
57: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

Line 55: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

51: IF l_debug_on THEN
52: WSH_DEBUG_SV.push(l_module_name);
53: --
54: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
55: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
56: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
57: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 56: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

52: WSH_DEBUG_SV.push(l_module_name);
53: --
54: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
55: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
56: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
57: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 57: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

53: --
54: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
55: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
56: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
57: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
61: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);

Line 58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

54: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
55: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
56: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
57: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
61: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
62: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);

Line 59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

55: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
56: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
57: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
61: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
62: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
63: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);

Line 60: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

56: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
57: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
61: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
62: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
63: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);
64: END IF;

Line 61: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);

57: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
61: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
62: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
63: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);
64: END IF;
65: -- LE Uptake

Line 62: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);

58: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
61: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
62: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
63: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);
64: END IF;
65: -- LE Uptake
66: SELECT hoi.org_information1

Line 63: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);

59: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
61: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
62: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
63: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);
64: END IF;
65: -- LE Uptake
66: SELECT hoi.org_information1
67: INTO l_ledger_id

Line 97: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PVT.UPDATE_DOCUMENT',WSH_DEBUG_SV.C_PROC_LEVEL);

93: --
94: -- Debug Statements
95: --
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PVT.UPDATE_DOCUMENT',WSH_DEBUG_SV.C_PROC_LEVEL);
98: END IF;
99: --
100: wsh_document_pvt.update_document
101: ( p_api_version

Line 157: WSH_DEBUG_SV.pop(l_module_name);

153: --
154: -- Debug Statements
155: --
156: IF l_debug_on THEN
157: WSH_DEBUG_SV.pop(l_module_name);
158: END IF;
159: --
160: EXCEPTION
161: WHEN wsh_update_document_error THEN

Line 170: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UPDATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

166: --
167: -- Debug Statements
168: --
169: IF l_debug_on THEN
170: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UPDATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
171: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UPDATE_DOCUMENT_ERROR');
172: END IF;
173: --
174: WHEN delivery_id_locked THEN

Line 171: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UPDATE_DOCUMENT_ERROR');

167: -- Debug Statements
168: --
169: IF l_debug_on THEN
170: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UPDATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
171: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UPDATE_DOCUMENT_ERROR');
172: END IF;
173: --
174: WHEN delivery_id_locked THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;

Line 183: WSH_DEBUG_SV.logmsg(l_module_name,'DELIVERY_ID_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

179: --
180: -- Debug Statements
181: --
182: IF l_debug_on THEN
183: WSH_DEBUG_SV.logmsg(l_module_name,'DELIVERY_ID_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIVERY_ID_LOCKED');
185: END IF;
186: --
187: WHEN OTHERS THEN

Line 184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIVERY_ID_LOCKED');

180: -- Debug Statements
181: --
182: IF l_debug_on THEN
183: WSH_DEBUG_SV.logmsg(l_module_name,'DELIVERY_ID_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIVERY_ID_LOCKED');
185: END IF;
186: --
187: WHEN OTHERS THEN
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

192: --
193: -- Debug Statements
194: --
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
198: END IF;
199: --
200: END Update_Row;

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

193: -- Debug Statements
194: --
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
198: END IF;
199: --
200: END Update_Row;
201:

Line 244: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

240: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
241: --
242: IF l_debug_on IS NULL
243: THEN
244: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
245: END IF;
246: --
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.push(l_module_name);

Line 248: WSH_DEBUG_SV.push(l_module_name);

244: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
245: END IF;
246: --
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.push(l_module_name);
249: --
250: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
251: WSH_DEBUG_SV.log(l_module_name,'X_MSG_COUNT',X_MSG_COUNT);
252: WSH_DEBUG_SV.log(l_module_name,'X_MSG_DATA',X_MSG_DATA);

Line 250: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);

246: --
247: IF l_debug_on THEN
248: WSH_DEBUG_SV.push(l_module_name);
249: --
250: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
251: WSH_DEBUG_SV.log(l_module_name,'X_MSG_COUNT',X_MSG_COUNT);
252: WSH_DEBUG_SV.log(l_module_name,'X_MSG_DATA',X_MSG_DATA);
253: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 251: WSH_DEBUG_SV.log(l_module_name,'X_MSG_COUNT',X_MSG_COUNT);

247: IF l_debug_on THEN
248: WSH_DEBUG_SV.push(l_module_name);
249: --
250: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
251: WSH_DEBUG_SV.log(l_module_name,'X_MSG_COUNT',X_MSG_COUNT);
252: WSH_DEBUG_SV.log(l_module_name,'X_MSG_DATA',X_MSG_DATA);
253: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);

Line 252: WSH_DEBUG_SV.log(l_module_name,'X_MSG_DATA',X_MSG_DATA);

248: WSH_DEBUG_SV.push(l_module_name);
249: --
250: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
251: WSH_DEBUG_SV.log(l_module_name,'X_MSG_COUNT',X_MSG_COUNT);
252: WSH_DEBUG_SV.log(l_module_name,'X_MSG_DATA',X_MSG_DATA);
253: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
256: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);

Line 253: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);

249: --
250: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
251: WSH_DEBUG_SV.log(l_module_name,'X_MSG_COUNT',X_MSG_COUNT);
252: WSH_DEBUG_SV.log(l_module_name,'X_MSG_DATA',X_MSG_DATA);
253: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
256: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
257: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

250: WSH_DEBUG_SV.log(l_module_name,'X_RETURN_STATUS',X_RETURN_STATUS);
251: WSH_DEBUG_SV.log(l_module_name,'X_MSG_COUNT',X_MSG_COUNT);
252: WSH_DEBUG_SV.log(l_module_name,'X_MSG_DATA',X_MSG_DATA);
253: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
256: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
257: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
258: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);

Line 255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);

251: WSH_DEBUG_SV.log(l_module_name,'X_MSG_COUNT',X_MSG_COUNT);
252: WSH_DEBUG_SV.log(l_module_name,'X_MSG_DATA',X_MSG_DATA);
253: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
256: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
257: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
258: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
259: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);

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

252: WSH_DEBUG_SV.log(l_module_name,'X_MSG_DATA',X_MSG_DATA);
253: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
256: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
257: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
258: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
259: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
260: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);

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

253: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
256: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
257: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
258: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
259: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
260: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
261: WSH_DEBUG_SV.log(l_module_name,'X_DOCUMENT_NUMBER',X_DOCUMENT_NUMBER);

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

254: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
256: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
257: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
258: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
259: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
260: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
261: WSH_DEBUG_SV.log(l_module_name,'X_DOCUMENT_NUMBER',X_DOCUMENT_NUMBER);
262: END IF;

Line 259: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);

255: WSH_DEBUG_SV.log(l_module_name,'P_APPLICATION_ID',P_APPLICATION_ID);
256: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
257: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
258: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
259: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
260: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
261: WSH_DEBUG_SV.log(l_module_name,'X_DOCUMENT_NUMBER',X_DOCUMENT_NUMBER);
262: END IF;
263: --

Line 260: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);

256: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
257: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
258: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
259: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
260: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
261: WSH_DEBUG_SV.log(l_module_name,'X_DOCUMENT_NUMBER',X_DOCUMENT_NUMBER);
262: END IF;
263: --
264: -- LE Uptake

Line 261: WSH_DEBUG_SV.log(l_module_name,'X_DOCUMENT_NUMBER',X_DOCUMENT_NUMBER);

257: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
258: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_SUB_TYPE',P_DOCUMENT_SUB_TYPE);
259: WSH_DEBUG_SV.log(l_module_name,'P_REASON_OF_TRANSPORT',P_REASON_OF_TRANSPORT);
260: WSH_DEBUG_SV.log(l_module_name,'P_DESCRIPTION',P_DESCRIPTION);
261: WSH_DEBUG_SV.log(l_module_name,'X_DOCUMENT_NUMBER',X_DOCUMENT_NUMBER);
262: END IF;
263: --
264: -- LE Uptake
265: --l_ledger_id := 1;

Line 298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PVT.CREATE_DOCUMENT',WSH_DEBUG_SV.C_PROC_LEVEL);

294: --
295: -- Debug Statements
296: --
297: IF l_debug_on THEN
298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PVT.CREATE_DOCUMENT',WSH_DEBUG_SV.C_PROC_LEVEL);
299: END IF;
300: --
301: wsh_document_pvt.create_document (
302: 1.0,

Line 362: WSH_DEBUG_SV.pop(l_module_name);

358: --
359: -- Debug Statements
360: --
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.pop(l_module_name);
363: END IF;
364: --
365: EXCEPTION
366: WHEN wsh_create_document_error THEN

Line 375: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

371: --
372: -- Debug Statements
373: --
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
377: END IF;
378: --
379: WHEN delivery_id_locked THEN

Line 376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');

372: -- Debug Statements
373: --
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
377: END IF;
378: --
379: WHEN delivery_id_locked THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;

Line 388: WSH_DEBUG_SV.logmsg(l_module_name,'DELIVERY_ID_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

384: --
385: -- Debug Statements
386: --
387: IF l_debug_on THEN
388: WSH_DEBUG_SV.logmsg(l_module_name,'DELIVERY_ID_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIVERY_ID_LOCKED');
390: END IF;
391: --
392: WHEN OTHERS THEN

Line 389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIVERY_ID_LOCKED');

385: -- Debug Statements
386: --
387: IF l_debug_on THEN
388: WSH_DEBUG_SV.logmsg(l_module_name,'DELIVERY_ID_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIVERY_ID_LOCKED');
390: END IF;
391: --
392: WHEN OTHERS THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

397: --
398: -- Debug Statements
399: --
400: IF l_debug_on THEN
401: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
402: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
403: END IF;
404: --
405: END Insert_Row;

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

398: -- Debug Statements
399: --
400: IF l_debug_on THEN
401: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
402: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
403: END IF;
404: --
405: END Insert_Row;
406:

Line 439: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

435: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
436: --
437: IF l_debug_on IS NULL
438: THEN
439: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
440: END IF;
441: --
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.push(l_module_name);

Line 443: WSH_DEBUG_SV.push(l_module_name);

439: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
440: END IF;
441: --
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.push(l_module_name);
444: --
445: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
446: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
447: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 445: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);

441: --
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.push(l_module_name);
444: --
445: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
446: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
447: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
448: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
449: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

Line 446: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

442: IF l_debug_on THEN
443: WSH_DEBUG_SV.push(l_module_name);
444: --
445: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
446: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
447: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
448: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
449: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

Line 447: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

443: WSH_DEBUG_SV.push(l_module_name);
444: --
445: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
446: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
447: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
448: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
449: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
451: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);

Line 448: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);

444: --
445: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
446: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
447: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
448: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
449: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
451: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);
452: END IF;

Line 449: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);

445: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
446: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
447: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
448: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
449: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
451: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);
452: END IF;
453: --

Line 450: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);

446: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
447: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
448: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
449: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
451: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);
452: END IF;
453: --
454: --

Line 451: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);

447: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
448: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
449: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
451: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_NUMBER',P_DOCUMENT_NUMBER);
452: END IF;
453: --
454: --
455: -- Debug Statements

Line 458: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PVT.CANCEL_DOCUMENT',WSH_DEBUG_SV.C_PROC_LEVEL);

454: --
455: -- Debug Statements
456: --
457: IF l_debug_on THEN
458: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_PVT.CANCEL_DOCUMENT',WSH_DEBUG_SV.C_PROC_LEVEL);
459: END IF;
460: --
461: wsh_document_pvt.cancel_document
462: (P_API_VERSION

Line 479: WSH_DEBUG_SV.pop(l_module_name);

475: --
476: -- Debug Statements
477: --
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.pop(l_module_name);
480: END IF;
481: --
482: EXCEPTION
483: WHEN wsh_cancel_document_error THEN

Line 491: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CANCEL_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

487: --
488: -- Debug Statements
489: --
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CANCEL_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
492: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_DOCUMENT_ERROR');
493: END IF;
494: --
495: WHEN OTHERS THEN

Line 492: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_DOCUMENT_ERROR');

488: -- Debug Statements
489: --
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CANCEL_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
492: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_DOCUMENT_ERROR');
493: END IF;
494: --
495: WHEN OTHERS THEN
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

500: --
501: -- Debug Statements
502: --
503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
506: END IF;
507: --
508: END delete_row;

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

501: -- Debug Statements
502: --
503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
506: END IF;
507: --
508: END delete_row;
509: -- Procedure: Get_Disabled_List

Line 555: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

551: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
552: --
553: IF l_debug_on IS NULL
554: THEN
555: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
556: END IF;
557: --
558: IF l_debug_on THEN
559: WSH_DEBUG_SV.push(l_module_name);

Line 559: WSH_DEBUG_SV.push(l_module_name);

555: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
556: END IF;
557: --
558: IF l_debug_on THEN
559: WSH_DEBUG_SV.push(l_module_name);
560: --
561: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
562: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
563: END IF;

Line 561: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);

557: --
558: IF l_debug_on THEN
559: WSH_DEBUG_SV.push(l_module_name);
560: --
561: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
562: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
563: END IF;
564: --
565: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 562: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);

558: IF l_debug_on THEN
559: WSH_DEBUG_SV.push(l_module_name);
560: --
561: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
562: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
563: END IF;
564: --
565: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
566:

Line 592: WSH_DEBUG_SV.pop(l_module_name);

588: --
589: -- Debug Statements
590: --
591: IF l_debug_on THEN
592: WSH_DEBUG_SV.pop(l_module_name);
593: END IF;
594: --
595: EXCEPTION
596: WHEN wsh_dp_no_entity THEN

Line 611: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DP_NO_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

607: --
608: -- Debug Statements
609: --
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DP_NO_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
613: END IF;
614: --
615: WHEN wsh_inv_list_type THEN

Line 612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');

608: -- Debug Statements
609: --
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DP_NO_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
612: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
613: END IF;
614: --
615: WHEN wsh_inv_list_type THEN
616: x_return_status := FND_API.G_RET_STS_ERROR;

Line 630: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INV_LIST_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

626: --
627: -- Debug Statements
628: --
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INV_LIST_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
631: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INV_LIST_TYPE');
632: END IF;
633: --
634: WHEN others THEN

Line 631: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INV_LIST_TYPE');

627: -- Debug Statements
628: --
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INV_LIST_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
631: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INV_LIST_TYPE');
632: END IF;
633: --
634: WHEN others THEN
635: IF (get_delivery_status%ISOPEN) THEN

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

641: --
642: -- Debug Statements
643: --
644: IF l_debug_on THEN
645: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
647: END IF;
648: --
649: END Get_Disabled_List;

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

642: -- Debug Statements
643: --
644: IF l_debug_on THEN
645: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
647: END IF;
648: --
649: END Get_Disabled_List;
650: