eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_DEBUG_SV

Line 56: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

52: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
53: --
54: IF l_debug_on IS NULL
55: THEN
56: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
57: END IF;
58: --
59: IF l_debug_on THEN
60: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');

Line 60: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');

56: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
57: END IF;
58: --
59: IF l_debug_on THEN
60: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');
61: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
62: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
63: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
64: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);

Line 61: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);

57: END IF;
58: --
59: IF l_debug_on THEN
60: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');
61: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
62: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
63: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
64: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
65: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);

Line 62: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);

58: --
59: IF l_debug_on THEN
60: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');
61: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
62: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
63: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
64: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
65: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
66: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);

Line 63: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);

59: IF l_debug_on THEN
60: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');
61: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
62: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
63: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
64: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
65: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
66: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);
67: END IF;

Line 64: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);

60: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');
61: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
62: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
63: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
64: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
65: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
66: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);
67: END IF;
68:

Line 65: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);

61: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
62: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
63: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
64: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
65: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
66: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);
67: END IF;
68:
69: -- Check if the values passed are Not Null and valid

Line 66: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);

62: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
63: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
64: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
65: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
66: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);
67: END IF;
68:
69: -- Check if the values passed are Not Null and valid
70:

Line 99: wsh_debug_sv.logmsg(l_module_name, 'Valid parameters for Validate Document');

95: RAISE invalid_Doc_direction;
96: END IF;
97:
98: IF l_debug_on THEN
99: wsh_debug_sv.logmsg(l_module_name, 'Valid parameters for Validate Document');
100: END IF;
101: /* Derive Trading_Partner_Id based on Trading_Partner_code */
102:
103: BEGIN

Line 120: wsh_debug_sv.logmsg(l_module_name, 'Inside No Data Found Exception to Derive TP ID');

116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: --
119: IF l_debug_on THEN
120: wsh_debug_sv.logmsg(l_module_name, 'Inside No Data Found Exception to Derive TP ID');
121: END IF;
122: --
123: RAISE FND_API.G_EXC_ERROR;
124: --

Line 128: wsh_debug_sv.logmsg (l_module_name, 'Inside Too many rows Exception to derive TP ID');

124: --
125: WHEN TOO_MANY_ROWS THEN
126: --
127: IF l_debug_on THEN
128: wsh_debug_sv.logmsg (l_module_name, 'Inside Too many rows Exception to derive TP ID');
129: END IF;
130: --
131: RAISE FND_API.G_EXC_ERROR;
132: END;

Line 135: wsh_debug_sv.log(l_module_name, 'Derived TP ID successfully', x_trading_partner_ID);

131: RAISE FND_API.G_EXC_ERROR;
132: END;
133:
134: IF l_debug_on THEN
135: wsh_debug_sv.log(l_module_name, 'Derived TP ID successfully', x_trading_partner_ID);
136: END IF;
137:
138: /* Check if the current record is a duplicate */
139: BEGIN

Line 153: wsh_debug_sv.log(l_module_name, 'EXCEPTION: Found duplicate', p_duplicate);

149: IF (p_duplicate = 'X')
150: THEN
151: --
152: IF l_debug_on THEN
153: wsh_debug_sv.log(l_module_name, 'EXCEPTION: Found duplicate', p_duplicate);
154: END IF;
155: RAISE FND_API.G_EXC_ERROR;
156: --
157: END IF;

Line 168: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: Too many rows when checking for duplicates');

164: --
165: WHEN TOO_MANY_ROWS THEN
166: --
167: IF l_debug_on THEN
168: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: Too many rows when checking for duplicates');
169: END IF;
170: --
171: RAISE FND_API.G_EXC_ERROR;
172: --

Line 176: wsh_debug_sv.log(l_module_name, 'After checking for duplicates, x_return_status', X_Return_Status);

172: --
173: END;
174:
175: IF l_debug_on THEN
176: wsh_debug_sv.log(l_module_name, 'After checking for duplicates, x_return_status', X_Return_Status);
177: END IF;
178:
179: IF (p_doc_type = 'SR') THEN
180:

Line 199: wsh_debug_sv.log(l_module_name, '940 Add Exists for the 940 Cancellation sent, Return Status',X_Return_Status );

195: THEN
196: x_return_status := wsh_util_core.g_ret_sts_success;
197: x_valid_doc := fnd_api.g_true;
198: IF l_debug_on THEN
199: wsh_debug_sv.log(l_module_name, '940 Add Exists for the 940 Cancellation sent, Return Status',X_Return_Status );
200: END IF;
201: END IF;
202: EXCEPTION
203: WHEN NO_DATA_FOUND

Line 206: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: No corresponding 940-Add exists');

202: EXCEPTION
203: WHEN NO_DATA_FOUND
204: THEN
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: No corresponding 940-Add exists');
207: END IF;
208: --
209: RAISE FND_API.G_EXC_ERROR;
210: END;

Line 214: wsh_debug_sv.log(l_module_name, 'Return Status after checking for 940 Add Exists when 940 Cancellation. Return Status', X_Return_Status );

210: END;
211: END IF; -- End of If (P_ACTION_TYPE = 'D') Then
212:
213: IF l_debug_on THEN
214: wsh_debug_sv.log(l_module_name, 'Return Status after checking for 940 Add Exists when 940 Cancellation. Return Status', X_Return_Status );
215: END IF;
216:
217: ELSIF (p_doc_type = 'SA') THEN
218:

Line 220: wsh_debug_sv.log(l_module_name, 'Before checking for 940 out when 945 comes in, x_return_status ',x_return_status );

216:
217: ELSIF (p_doc_type = 'SA') THEN
218:
219: IF l_debug_on THEN
220: wsh_debug_sv.log(l_module_name, 'Before checking for 940 out when 945 comes in, x_return_status ',x_return_status );
221: END IF;
222:
223: /* Check if the Corresponding 940 Out exists when a 945 Comes in */
224: BEGIN

Line 243: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: No data found when checking for 940-O when

239: WHEN NO_DATA_FOUND
240: THEN
241: --
242: IF l_debug_on THEN
243: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: No data found when checking for 940-O when
244: 945-IN comes in');
245: END IF;
246: --
247: RAISE FND_API.G_EXC_ERROR;

Line 253: wsh_debug_sv.log (l_module_name, 'Return Status from Validate Document', X_Return_Status );

249: END;
250: END IF; -- End of If (P_DOC_TYPE = 'SR') Then
251:
252: IF l_debug_on THEN
253: wsh_debug_sv.log (l_module_name, 'Return Status from Validate Document', X_Return_Status );
254: wsh_debug_sv.pop (l_module_name);
255: END IF;
256:
257: EXCEPTION

Line 254: wsh_debug_sv.pop (l_module_name);

250: END IF; -- End of If (P_DOC_TYPE = 'SR') Then
251:
252: IF l_debug_on THEN
253: wsh_debug_sv.log (l_module_name, 'Return Status from Validate Document', X_Return_Status );
254: wsh_debug_sv.pop (l_module_name);
255: END IF;
256:
257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN

Line 265: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );

261: x_Valid_Doc := FND_API.G_FALSE;
262: --
263: IF l_debug_on THEN
264: --
265: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
266: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
267: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
268: WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

Line 266: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);

262: --
263: IF l_debug_on THEN
264: --
265: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
266: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
267: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
268: WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
270: --

Line 267: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',

263: IF l_debug_on THEN
264: --
265: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
266: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
267: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
268: WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
270: --
271: END IF;

Line 268: WSH_DEBUG_SV.C_EXCEP_LEVEL);

264: --
265: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
266: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
267: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
268: WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
270: --
271: END IF;
272: --

Line 269: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

265: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
266: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
267: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
268: WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
270: --
271: END IF;
272: --
273: WHEN invalid_doc_number

Line 278: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_number exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

274: THEN
275: x_return_status := wsh_util_core.g_ret_sts_error;
276: x_valid_doc := fnd_api.g_false;
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_number exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
279: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_number');
280: END IF;
281: WHEN invalid_tp
282: THEN

Line 279: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_number');

275: x_return_status := wsh_util_core.g_ret_sts_error;
276: x_valid_doc := fnd_api.g_false;
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_number exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
279: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_number');
280: END IF;
281: WHEN invalid_tp
282: THEN
283: x_return_status := wsh_util_core.g_ret_sts_error;

Line 286: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_tp exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

282: THEN
283: x_return_status := wsh_util_core.g_ret_sts_error;
284: x_valid_doc := fnd_api.g_false;
285: IF l_debug_on THEN
286: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_tp exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
287: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_tp');
288: END IF;
289: WHEN invalid_doc_direction
290: THEN

Line 287: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_tp');

283: x_return_status := wsh_util_core.g_ret_sts_error;
284: x_valid_doc := fnd_api.g_false;
285: IF l_debug_on THEN
286: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_tp exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
287: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_tp');
288: END IF;
289: WHEN invalid_doc_direction
290: THEN
291: x_return_status := wsh_util_core.g_ret_sts_error;

Line 294: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

290: THEN
291: x_return_status := wsh_util_core.g_ret_sts_error;
292: x_valid_doc := fnd_api.g_false;
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
296: END IF;
297: WHEN invalid_doc_type
298: THEN

Line 295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');

291: x_return_status := wsh_util_core.g_ret_sts_error;
292: x_valid_doc := fnd_api.g_false;
293: IF l_debug_on THEN
294: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
296: END IF;
297: WHEN invalid_doc_type
298: THEN
299: x_return_status := wsh_util_core.g_ret_sts_error;

Line 302: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

298: THEN
299: x_return_status := wsh_util_core.g_ret_sts_error;
300: x_valid_doc := fnd_api.g_false;
301: IF l_debug_on THEN
302: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
303: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
304: END IF;
305: WHEN invalid_action_type
306: THEN

Line 303: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');

299: x_return_status := wsh_util_core.g_ret_sts_error;
300: x_valid_doc := fnd_api.g_false;
301: IF l_debug_on THEN
302: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
303: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
304: END IF;
305: WHEN invalid_action_type
306: THEN
307: x_return_status := wsh_util_core.g_ret_sts_error;

Line 310: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

306: THEN
307: x_return_status := wsh_util_core.g_ret_sts_error;
308: x_valid_doc := fnd_api.g_false;
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
312: END IF;
313: WHEN OTHERS
314: THEN

Line 311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');

307: x_return_status := wsh_util_core.g_ret_sts_error;
308: x_valid_doc := fnd_api.g_false;
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
312: END IF;
313: WHEN OTHERS
314: THEN
315: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

Line 318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

314: THEN
315: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
316: x_valid_doc := fnd_api.g_false;
317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
319: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
320: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
321: END IF;
322: END validate_document;

Line 319: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

315: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
316: x_valid_doc := fnd_api.g_false;
317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
319: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
320: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
321: END IF;
322: END validate_document;
323:

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

316: x_valid_doc := fnd_api.g_false;
317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
319: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
320: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
321: END IF;
322: END validate_document;
323:
324:

Line 368: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

364: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
365: --
366: IF l_debug_on IS NULL
367: THEN
368: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
369: END IF;
370: --
371: IF l_debug_on THEN
372: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERIES');

Line 372: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERIES');

368: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
369: END IF;
370: --
371: IF l_debug_on THEN
372: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERIES');
373: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
374: END IF;
375:
376: /* Check if the Delivery ID from Interface table exists in WSH_NEW_DELIVERIES Table */

Line 373: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);

369: END IF;
370: --
371: IF l_debug_on THEN
372: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERIES');
373: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
374: END IF;
375:
376: /* Check if the Delivery ID from Interface table exists in WSH_NEW_DELIVERIES Table */
377:

Line 392: wsh_debug_sv.log (l_module_name, 'Valid parameters for Validate Deliveries. Return Status : ',X_Return_Status );

388: RAISE invalid_delivery_id;
389: END;
390:
391: IF l_debug_on THEN
392: wsh_debug_sv.log (l_module_name, 'Valid parameters for Validate Deliveries. Return Status : ',X_Return_Status );
393: END IF;
394:
395: /* If the Delivery exists in WSH_New_Deliveries, Get the corresponding Delivery_Detail_IDs
396: from the interface tables and check if they exist in the base tables, and if they are assigned

Line 427: wsh_debug_sv.log (l_module_name,'940 Add Exists for the 940 Cancellation sent. Return Status',X_Return_Status );

423: x_return_status := wsh_util_core.g_ret_sts_error;
424: END IF; -- if p_delivery_id is null
425:
426: IF l_debug_on THEN
427: wsh_debug_sv.log (l_module_name,'940 Add Exists for the 940 Cancellation sent. Return Status',X_Return_Status );
428: wsh_debug_sv.pop (l_module_name);
429: END IF;
430: EXCEPTION
431: WHEN invalid_delivery_id

Line 428: wsh_debug_sv.pop (l_module_name);

424: END IF; -- if p_delivery_id is null
425:
426: IF l_debug_on THEN
427: wsh_debug_sv.log (l_module_name,'940 Add Exists for the 940 Cancellation sent. Return Status',X_Return_Status );
428: wsh_debug_sv.pop (l_module_name);
429: END IF;
430: EXCEPTION
431: WHEN invalid_delivery_id
432: THEN

Line 435: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

431: WHEN invalid_delivery_id
432: THEN
433: x_return_status := wsh_util_core.g_ret_sts_error;
434: IF l_debug_on THEN
435: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_id');
437: END IF;
438: WHEN invalid_delivery_detail_id
439: THEN

Line 436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_id');

432: THEN
433: x_return_status := wsh_util_core.g_ret_sts_error;
434: IF l_debug_on THEN
435: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_id');
437: END IF;
438: WHEN invalid_delivery_detail_id
439: THEN
440: x_return_status := wsh_util_core.g_ret_sts_error;

Line 442: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_detail_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

438: WHEN invalid_delivery_detail_id
439: THEN
440: x_return_status := wsh_util_core.g_ret_sts_error;
441: IF l_debug_on THEN
442: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_detail_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
443: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
444: END IF;
445: WHEN OTHERS
446: THEN

Line 443: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');

439: THEN
440: x_return_status := wsh_util_core.g_ret_sts_error;
441: IF l_debug_on THEN
442: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_detail_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
443: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
444: END IF;
445: WHEN OTHERS
446: THEN
447: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

Line 449: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

445: WHEN OTHERS
446: THEN
447: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
448: IF l_debug_on THEN
449: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
450: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
452: END IF;
453: END validate_deliveries;

Line 450: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

446: THEN
447: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
448: IF l_debug_on THEN
449: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
450: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
452: END IF;
453: END validate_deliveries;
454:

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

447: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
448: IF l_debug_on THEN
449: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
450: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
452: END IF;
453: END validate_deliveries;
454:
455:

Line 528: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

524: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
525: --
526: IF l_debug_on IS NULL
527: THEN
528: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
529: END IF;
530: --
531: IF l_debug_on THEN
532: wsh_debug_sv.push (l_module_name, 'Compare Ship Request Advice');

Line 532: wsh_debug_sv.push (l_module_name, 'Compare Ship Request Advice');

528: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
529: END IF;
530: --
531: IF l_debug_on THEN
532: wsh_debug_sv.push (l_module_name, 'Compare Ship Request Advice');
533: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
534: END IF;
535:
536: BEGIN

Line 533: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);

529: END IF;
530: --
531: IF l_debug_on THEN
532: wsh_debug_sv.push (l_module_name, 'Compare Ship Request Advice');
533: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
534: END IF;
535:
536: BEGIN
537: IF (p_delivery_id IS NOT NULL) THEN

Line 554: wsh_debug_sv.log (l_module_name, 'Valid values for Compare Ship Request Advice');

550: RAISE invalid_delivery;
551: END IF;
552:
553: IF l_debug_on THEN
554: wsh_debug_sv.log (l_module_name, 'Valid values for Compare Ship Request Advice');
555: END IF;
556:
557: /* Compare values of the Delivery */
558:

Line 569: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Data Did Not Change for Delivery');

565: RAISE data_changed;
566: ELSE
567:
568: IF l_debug_on THEN
569: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Data Did Not Change for Delivery');
570: END IF;
571:
572: /* Compare values of the Delivery Details */
573:

Line 577: wsh_debug_sv.log (l_module_name, 'Delivery Detail Interface ID ',delivery_detail_int.delivery_detail_id);

573:
574: FOR delivery_detail_int IN delivery_detail_int_cur (p_delivery_id)
575: LOOP
576: IF l_debug_on THEN
577: wsh_debug_sv.log (l_module_name, 'Delivery Detail Interface ID ',delivery_detail_int.delivery_detail_id);
578: END IF;
579: FOR delivery_detail IN delivery_detail_cur (delivery_detail_int.delivery_detail_id)
580: LOOP
581: IF l_debug_on THEN

Line 582: wsh_debug_sv.log (l_module_name, 'Delivery Detail ID ',delivery_detail.delivery_detail_id);

578: END IF;
579: FOR delivery_detail IN delivery_detail_cur (delivery_detail_int.delivery_detail_id)
580: LOOP
581: IF l_debug_on THEN
582: wsh_debug_sv.log (l_module_name, 'Delivery Detail ID ',delivery_detail.delivery_detail_id);
583: END IF;
584:
585: IF (NVL (delivery_detail.customer_id, 0) <> NVL (delivery_detail_int.customer_id, 0))
586: OR (NVL (delivery_detail.customer_item_id, 0) <> NVL (delivery_detail_int.customer_item_id, 0))

Line 597: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Data Did Not Change for Delivery Details');

593: THEN
594: RAISE data_changed;
595: ELSE
596: IF l_debug_on THEN
597: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Data Did Not Change for Delivery Details');
598: END IF;
599:
600: x_return_status := wsh_util_core.g_ret_sts_success;
601: END IF; -- if delivery_detail checks

Line 626: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Return Status :'||X_Return_Status);

622: RAISE invalid_delivery;
623: END IF; -- if p_delivery_id is not null
624:
625: IF l_debug_on THEN
626: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Return Status :'||X_Return_Status);
627: wsh_debug_sv.pop (l_module_name);
628: END IF;
629:
630: EXCEPTION

Line 627: wsh_debug_sv.pop (l_module_name);

623: END IF; -- if p_delivery_id is not null
624:
625: IF l_debug_on THEN
626: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Return Status :'||X_Return_Status);
627: wsh_debug_sv.pop (l_module_name);
628: END IF;
629:
630: EXCEPTION
631: WHEN invalid_delivery

Line 635: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

631: WHEN invalid_delivery
632: THEN
633: x_return_status := wsh_util_core.g_ret_sts_error;
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
637: END IF;
638: WHEN data_changed
639: THEN

Line 636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');

632: THEN
633: x_return_status := wsh_util_core.g_ret_sts_error;
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
637: END IF;
638: WHEN data_changed
639: THEN
640: x_return_status := wsh_util_core.g_ret_sts_error;

Line 642: WSH_DEBUG_SV.logmsg(l_module_name,'data_changed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

638: WHEN data_changed
639: THEN
640: x_return_status := wsh_util_core.g_ret_sts_error;
641: IF l_debug_on THEN
642: WSH_DEBUG_SV.logmsg(l_module_name,'data_changed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:data_changed');
644: END IF;
645: WHEN OTHERS
646: THEN

Line 643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:data_changed');

639: THEN
640: x_return_status := wsh_util_core.g_ret_sts_error;
641: IF l_debug_on THEN
642: WSH_DEBUG_SV.logmsg(l_module_name,'data_changed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:data_changed');
644: END IF;
645: WHEN OTHERS
646: THEN
647: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

Line 649: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

645: WHEN OTHERS
646: THEN
647: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
648: IF l_debug_on THEN
649: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
650: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
651: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
652: END IF;
653: END;

Line 650: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

646: THEN
647: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
648: IF l_debug_on THEN
649: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
650: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
651: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
652: END IF;
653: END;
654:

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

647: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
648: IF l_debug_on THEN
649: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
650: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
651: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
652: END IF;
653: END;
654:
655: END compare_ship_request_advice;

Line 694: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

690: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
691: --
692: IF l_debug_on IS NULL
693: THEN
694: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
695: END IF;
696: --
697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');

Line 698: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');

694: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
695: END IF;
696: --
697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
699: wsh_debug_sv.log (l_module_name, 'Interface table name', p_interface_errors_rec.p_interface_table_name);
700: wsh_debug_sv.log (l_module_name, 'Interface Id', p_interface_errors_rec.p_interface_id);
701: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);
702: END IF;

Line 699: wsh_debug_sv.log (l_module_name, 'Interface table name', p_interface_errors_rec.p_interface_table_name);

695: END IF;
696: --
697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
699: wsh_debug_sv.log (l_module_name, 'Interface table name', p_interface_errors_rec.p_interface_table_name);
700: wsh_debug_sv.log (l_module_name, 'Interface Id', p_interface_errors_rec.p_interface_id);
701: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);
702: END IF;
703:

Line 700: wsh_debug_sv.log (l_module_name, 'Interface Id', p_interface_errors_rec.p_interface_id);

696: --
697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
699: wsh_debug_sv.log (l_module_name, 'Interface table name', p_interface_errors_rec.p_interface_table_name);
700: wsh_debug_sv.log (l_module_name, 'Interface Id', p_interface_errors_rec.p_interface_id);
701: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);
702: END IF;
703:
704: IF (p_msg_data IS NULL) THEN

Line 701: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);

697: IF l_debug_on THEN
698: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
699: wsh_debug_sv.log (l_module_name, 'Interface table name', p_interface_errors_rec.p_interface_table_name);
700: wsh_debug_sv.log (l_module_name, 'Interface Id', p_interface_errors_rec.p_interface_id);
701: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);
702: END IF;
703:
704: IF (p_msg_data IS NULL) THEN
705: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);

Line 728: wsh_debug_sv.log (l_module_name, 'Log Interface Errors. Valid Parameters');

724: IF (p_interface_errors_rec.p_interface_table_name IS NOT NULL)
725: AND (p_interface_errors_rec.p_interface_id IS NOT NULL) THEN
726:
727: IF l_debug_on THEN
728: wsh_debug_sv.log (l_module_name, 'Log Interface Errors. Valid Parameters');
729: END IF;
730:
731: IF (p_interface_errors_rec.p_message_name IS NOT NULL) THEN
732: -- Build the Error message string.

Line 805: wsh_debug_sv.log (l_module_name, 'Text: ', l_text);

801: END IF;
802:
803:
804: IF l_debug_on THEN
805: wsh_debug_sv.log (l_module_name, 'Text: ', l_text);
806: END IF;
807: -- Insert error record in WSH_Interface_errors table.
808: -- We need the check for l_text because the column error_message
809: -- is a Not_Null column.

Line 813: wsh_debug_sv.log (l_module_name, 'Error Message', l_text);

809: -- is a Not_Null column.
810:
811: IF (l_text IS NOT NULL) THEN
812: IF l_debug_on THEN
813: wsh_debug_sv.log (l_module_name, 'Error Message', l_text);
814: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');
815: END IF;
816:
817: INSERT INTO wsh_interface_errors

Line 814: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');

810:
811: IF (l_text IS NOT NULL) THEN
812: IF l_debug_on THEN
813: wsh_debug_sv.log (l_module_name, 'Error Message', l_text);
814: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');
815: END IF;
816:
817: INSERT INTO wsh_interface_errors
818: (interface_error_id,

Line 833: wsh_debug_sv.log (l_module_name, 'Text for error_message is null');

829: COMMIT;
830:
831: ELSE
832: IF l_debug_on THEN
833: wsh_debug_sv.log (l_module_name, 'Text for error_message is null');
834: END IF;
835: END IF; -- if l_text is not null
836: x_return_status := wsh_util_core.g_ret_sts_success;
837: ELSE

Line 842: wsh_debug_sv.log (l_module_name, 'Log Interface Errors. Return Status. :'||X_Return_Status);

838: RAISE invalid_parameters;
839: END IF;
840:
841: IF l_debug_on THEN
842: wsh_debug_sv.log (l_module_name, 'Log Interface Errors. Return Status. :'||X_Return_Status);
843: wsh_debug_sv.pop (l_module_name);
844: END IF;
845: EXCEPTION
846: WHEN invalid_parameters

Line 843: wsh_debug_sv.pop (l_module_name);

839: END IF;
840:
841: IF l_debug_on THEN
842: wsh_debug_sv.log (l_module_name, 'Log Interface Errors. Return Status. :'||X_Return_Status);
843: wsh_debug_sv.pop (l_module_name);
844: END IF;
845: EXCEPTION
846: WHEN invalid_parameters
847: THEN

Line 850: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

846: WHEN invalid_parameters
847: THEN
848: x_return_status := wsh_util_core.g_ret_sts_error;
849: IF l_debug_on THEN
850: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
852: END IF;
853: WHEN OTHERS
854: THEN

Line 851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

847: THEN
848: x_return_status := wsh_util_core.g_ret_sts_error;
849: IF l_debug_on THEN
850: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
852: END IF;
853: WHEN OTHERS
854: THEN
855: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

Line 857: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

853: WHEN OTHERS
854: THEN
855: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
856: IF l_debug_on THEN
857: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
858: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
859: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
860: END IF;
861:

Line 858: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

854: THEN
855: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
856: IF l_debug_on THEN
857: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
858: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
859: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
860: END IF;
861:
862: END log_interface_errors;

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

855: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
856: IF l_debug_on THEN
857: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
858: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
859: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
860: END IF;
861:
862: END log_interface_errors;
863: END wsh_interface_validations_pkg;