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

61: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
62: --
63: IF l_debug_on IS NULL
64: THEN
65: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
66: END IF;
67: --
68: IF l_debug_on THEN
69: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');

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

65: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
66: END IF;
67: --
68: IF l_debug_on THEN
69: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');
70: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
71: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
72: --R12.1.1 STANDALONE PROJECT
73: wsh_debug_sv.log (l_module_name, 'DOCUMENT REVISION', p_doc_revision);

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

66: END IF;
67: --
68: IF l_debug_on THEN
69: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');
70: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
71: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
72: --R12.1.1 STANDALONE PROJECT
73: wsh_debug_sv.log (l_module_name, 'DOCUMENT REVISION', p_doc_revision);
74: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);

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

67: --
68: IF l_debug_on THEN
69: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');
70: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
71: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
72: --R12.1.1 STANDALONE PROJECT
73: wsh_debug_sv.log (l_module_name, 'DOCUMENT REVISION', p_doc_revision);
74: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
75: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);

Line 73: wsh_debug_sv.log (l_module_name, 'DOCUMENT REVISION', p_doc_revision);

69: wsh_debug_sv.push (l_module_name, 'VALIDATE_DOCUMENT');
70: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
71: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
72: --R12.1.1 STANDALONE PROJECT
73: wsh_debug_sv.log (l_module_name, 'DOCUMENT REVISION', p_doc_revision);
74: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
75: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
76: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
77: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);

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

70: wsh_debug_sv.log (l_module_name, 'DOCUMENT TYPE', p_doc_type);
71: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
72: --R12.1.1 STANDALONE PROJECT
73: wsh_debug_sv.log (l_module_name, 'DOCUMENT REVISION', p_doc_revision);
74: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
75: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
76: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
77: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);
78: wsh_debug_sv.log (l_module_name, 'CLIENT CODE', p_client_code); -- LSP PROJECT

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

71: wsh_debug_sv.log (l_module_name, 'DOCUMENT NUMBER', p_doc_number);
72: --R12.1.1 STANDALONE PROJECT
73: wsh_debug_sv.log (l_module_name, 'DOCUMENT REVISION', p_doc_revision);
74: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
75: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
76: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
77: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);
78: wsh_debug_sv.log (l_module_name, 'CLIENT CODE', p_client_code); -- LSP PROJECT
79: END IF;

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

72: --R12.1.1 STANDALONE PROJECT
73: wsh_debug_sv.log (l_module_name, 'DOCUMENT REVISION', p_doc_revision);
74: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
75: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
76: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
77: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);
78: wsh_debug_sv.log (l_module_name, 'CLIENT CODE', p_client_code); -- LSP PROJECT
79: END IF;
80:

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

73: wsh_debug_sv.log (l_module_name, 'DOCUMENT REVISION', p_doc_revision);
74: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
75: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
76: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
77: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);
78: wsh_debug_sv.log (l_module_name, 'CLIENT CODE', p_client_code); -- LSP PROJECT
79: END IF;
80:
81: -- Check if the values passed are Not Null and valid

Line 78: wsh_debug_sv.log (l_module_name, 'CLIENT CODE', p_client_code); -- LSP PROJECT

74: wsh_debug_sv.log (l_module_name, 'TRADING PARTNER', p_trading_partner_Code);
75: wsh_debug_sv.log (l_module_name, 'ACTION TYPE', p_action_type);
76: wsh_debug_sv.log (l_module_name, 'DOCUMENT DIRECTION', p_doc_direction);
77: wsh_debug_sv.log (l_module_name, 'ORIGINAL DOC NUMBER', p_orig_document_number);
78: wsh_debug_sv.log (l_module_name, 'CLIENT CODE', p_client_code); -- LSP PROJECT
79: END IF;
80:
81: -- Check if the values passed are Not Null and valid
82: IF (p_doc_number IS NULL)

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

129:
130: END IF; --}
131:
132: IF l_debug_on THEN
133: wsh_debug_sv.logmsg(l_module_name, 'Valid parameters for Validate Document');
134: END IF;
135: /* Derive Trading_Partner_Id based on Trading_Partner_code */
136:
137: BEGIN

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

155: EXCEPTION
156: WHEN NO_DATA_FOUND THEN
157: --
158: IF l_debug_on THEN
159: wsh_debug_sv.logmsg(l_module_name, 'Inside No Data Found Exception to Derive TP ID');
160: END IF;
161: --
162: RAISE FND_API.G_EXC_ERROR;
163: --

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

163: --
164: WHEN TOO_MANY_ROWS THEN
165: --
166: IF l_debug_on THEN
167: wsh_debug_sv.logmsg (l_module_name, 'Inside Too many rows Exception to derive TP ID');
168: END IF;
169: --
170: RAISE FND_API.G_EXC_ERROR;
171: END;

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

170: RAISE FND_API.G_EXC_ERROR;
171: END;
172:
173: IF l_debug_on THEN
174: wsh_debug_sv.log(l_module_name, 'Derived TP ID successfully', x_trading_partner_ID);
175: END IF;
176:
177: /* Check if the current record is a duplicate */
178: BEGIN

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

192: IF (p_duplicate = 'X')
193: THEN
194: --
195: IF l_debug_on THEN
196: wsh_debug_sv.log(l_module_name, 'EXCEPTION: Found duplicate', p_duplicate);
197: END IF;
198: RAISE FND_API.G_EXC_ERROR;
199: --
200: END IF;

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

207: --
208: WHEN TOO_MANY_ROWS THEN
209: --
210: IF l_debug_on THEN
211: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: Too many rows when checking for duplicates');
212: END IF;
213: --
214: RAISE FND_API.G_EXC_ERROR;
215: --

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

215: --
216: END;
217:
218: IF l_debug_on THEN
219: wsh_debug_sv.log(l_module_name, 'After checking for duplicates, x_return_status', X_Return_Status);
220: END IF;
221:
222: IF (p_doc_type = 'SR') THEN --{
223:

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

251: THEN
252: x_return_status := wsh_util_core.g_ret_sts_success;
253: x_valid_doc := fnd_api.g_true;
254: IF l_debug_on THEN
255: wsh_debug_sv.log(l_module_name, '940 Add Exists for the 940 Cancellation sent, Return Status',X_Return_Status );
256: END IF;
257: END IF;
258: EXCEPTION
259: WHEN NO_DATA_FOUND

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

258: EXCEPTION
259: WHEN NO_DATA_FOUND
260: THEN
261: IF l_debug_on THEN
262: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: No corresponding 940-Add exists');
263: END IF;
264: --
265: RAISE FND_API.G_EXC_ERROR;
266: END;

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

266: END;
267: END IF; -- End of If (P_ACTION_TYPE = 'D') Then
268:
269: IF l_debug_on THEN
270: wsh_debug_sv.log(l_module_name, 'Return Status after checking for 940 Add Exists when 940 Cancellation. Return Status', X_Return_Status );
271: END IF;
272:
273: ELSIF (p_doc_type = 'SA' and nvl(fnd_profile.Value('WSH_SR_SOURCE'),'D') <> 'B') THEN --} {--Fulfillment Batch XML Project
274:

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

272:
273: ELSIF (p_doc_type = 'SA' and nvl(fnd_profile.Value('WSH_SR_SOURCE'),'D') <> 'B') THEN --} {--Fulfillment Batch XML Project
274:
275: IF l_debug_on THEN
276: wsh_debug_sv.log(l_module_name, 'Before checking for 940 out when 945 comes in, x_return_status ',x_return_status );
277: END IF;
278:
279: /* Check if the Corresponding 940 Out exists when a 945 Comes in */
280: BEGIN

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

295: WHEN NO_DATA_FOUND
296: THEN
297: --
298: IF l_debug_on THEN
299: wsh_debug_sv.logmsg(l_module_name, 'EXCEPTION: No data found when checking for 940-O when
300: 945-IN comes in');
301: END IF;
302: --
303: RAISE FND_API.G_EXC_ERROR;

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

305: END;
306: END IF; -- }
307:
308: IF l_debug_on THEN
309: wsh_debug_sv.log (l_module_name, 'Return Status from Validate Document', X_Return_Status );
310: wsh_debug_sv.pop (l_module_name);
311: END IF;
312:
313: EXCEPTION

Line 310: wsh_debug_sv.pop (l_module_name);

306: END IF; -- }
307:
308: IF l_debug_on THEN
309: wsh_debug_sv.log (l_module_name, 'Return Status from Validate Document', X_Return_Status );
310: wsh_debug_sv.pop (l_module_name);
311: END IF;
312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN

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

317: x_Valid_Doc := FND_API.G_FALSE;
318: --
319: IF l_debug_on THEN
320: --
321: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
322: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
324: WSH_DEBUG_SV.C_EXCEP_LEVEL);
325: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

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

318: --
319: IF l_debug_on THEN
320: --
321: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
322: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
324: WSH_DEBUG_SV.C_EXCEP_LEVEL);
325: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
326: --

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

319: IF l_debug_on THEN
320: --
321: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
322: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
324: WSH_DEBUG_SV.C_EXCEP_LEVEL);
325: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
326: --
327: END IF;

Line 324: WSH_DEBUG_SV.C_EXCEP_LEVEL);

320: --
321: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
322: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
324: WSH_DEBUG_SV.C_EXCEP_LEVEL);
325: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
326: --
327: END IF;
328: --

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

321: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Validate Document',X_Return_Status );
322: WSH_DEBUG_SV.log(l_module_name, 'x_valid_doc', x_Valid_Doc);
323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
324: WSH_DEBUG_SV.C_EXCEP_LEVEL);
325: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
326: --
327: END IF;
328: --
329: WHEN invalid_doc_number

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

330: THEN
331: x_return_status := wsh_util_core.g_ret_sts_error;
332: x_valid_doc := fnd_api.g_false;
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_number exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_number');
336: END IF;
337: --R12.1.1 STANDALONE PROJECT
338: WHEN invalid_doc_revision

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

331: x_return_status := wsh_util_core.g_ret_sts_error;
332: x_valid_doc := fnd_api.g_false;
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_number exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_number');
336: END IF;
337: --R12.1.1 STANDALONE PROJECT
338: WHEN invalid_doc_revision
339: THEN

Line 343: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_revision exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

339: THEN
340: x_return_status := wsh_util_core.g_ret_sts_error;
341: x_valid_doc := fnd_api.g_false;
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_revision exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_revision');
345: END IF;
346: WHEN invalid_tp
347: THEN

Line 344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_revision');

340: x_return_status := wsh_util_core.g_ret_sts_error;
341: x_valid_doc := fnd_api.g_false;
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_revision exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_revision');
345: END IF;
346: WHEN invalid_tp
347: THEN
348: x_return_status := wsh_util_core.g_ret_sts_error;

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

347: THEN
348: x_return_status := wsh_util_core.g_ret_sts_error;
349: x_valid_doc := fnd_api.g_false;
350: IF l_debug_on THEN
351: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_tp exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
352: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_tp');
353: END IF;
354: WHEN invalid_doc_direction
355: THEN

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

348: x_return_status := wsh_util_core.g_ret_sts_error;
349: x_valid_doc := fnd_api.g_false;
350: IF l_debug_on THEN
351: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_tp exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
352: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_tp');
353: END IF;
354: WHEN invalid_doc_direction
355: THEN
356: x_return_status := wsh_util_core.g_ret_sts_error;

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

355: THEN
356: x_return_status := wsh_util_core.g_ret_sts_error;
357: x_valid_doc := fnd_api.g_false;
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
361: END IF;
362: WHEN invalid_doc_type
363: THEN

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

356: x_return_status := wsh_util_core.g_ret_sts_error;
357: x_valid_doc := fnd_api.g_false;
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
361: END IF;
362: WHEN invalid_doc_type
363: THEN
364: x_return_status := wsh_util_core.g_ret_sts_error;

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

363: THEN
364: x_return_status := wsh_util_core.g_ret_sts_error;
365: x_valid_doc := fnd_api.g_false;
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
369: END IF;
370: WHEN invalid_action_type
371: THEN

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

364: x_return_status := wsh_util_core.g_ret_sts_error;
365: x_valid_doc := fnd_api.g_false;
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
369: END IF;
370: WHEN invalid_action_type
371: THEN
372: x_return_status := wsh_util_core.g_ret_sts_error;

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

371: THEN
372: x_return_status := wsh_util_core.g_ret_sts_error;
373: x_valid_doc := fnd_api.g_false;
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
377: END IF;
378: WHEN OTHERS
379: THEN

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

372: x_return_status := wsh_util_core.g_ret_sts_error;
373: x_valid_doc := fnd_api.g_false;
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
377: END IF;
378: WHEN OTHERS
379: THEN
380: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

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

379: THEN
380: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
381: x_valid_doc := fnd_api.g_false;
382: IF l_debug_on THEN
383: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
384: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
386: END IF;
387: END validate_document;

Line 384: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

380: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
381: x_valid_doc := fnd_api.g_false;
382: IF l_debug_on THEN
383: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
384: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
386: END IF;
387: END validate_document;
388:

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

381: x_valid_doc := fnd_api.g_false;
382: IF l_debug_on THEN
383: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
384: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
386: END IF;
387: END validate_document;
388:
389: -- LSP PROJECT : API returns client Code associated to the given

Line 412: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

408: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
409: --
410: IF l_debug_on IS NULL
411: THEN
412: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
413: END IF;
414: --
415: IF l_debug_on THEN
416: wsh_debug_sv.push (l_module_name, 'GET_CLIENT_DETAILS');

Line 416: wsh_debug_sv.push (l_module_name, 'GET_CLIENT_DETAILS');

412: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
413: END IF;
414: --
415: IF l_debug_on THEN
416: wsh_debug_sv.push (l_module_name, 'GET_CLIENT_DETAILS');
417: wsh_debug_sv.log (l_module_name, 'P_trading_partner_id', P_trading_partner_id);
418: wsh_debug_sv.log (l_module_name, 'P_trading_partner_site_id', P_trading_partner_site_id);
419: --
420: END IF;

Line 417: wsh_debug_sv.log (l_module_name, 'P_trading_partner_id', P_trading_partner_id);

413: END IF;
414: --
415: IF l_debug_on THEN
416: wsh_debug_sv.push (l_module_name, 'GET_CLIENT_DETAILS');
417: wsh_debug_sv.log (l_module_name, 'P_trading_partner_id', P_trading_partner_id);
418: wsh_debug_sv.log (l_module_name, 'P_trading_partner_site_id', P_trading_partner_site_id);
419: --
420: END IF;
421: --

Line 418: wsh_debug_sv.log (l_module_name, 'P_trading_partner_site_id', P_trading_partner_site_id);

414: --
415: IF l_debug_on THEN
416: wsh_debug_sv.push (l_module_name, 'GET_CLIENT_DETAILS');
417: wsh_debug_sv.log (l_module_name, 'P_trading_partner_id', P_trading_partner_id);
418: wsh_debug_sv.log (l_module_name, 'P_trading_partner_site_id', P_trading_partner_site_id);
419: --
420: END IF;
421: --
422: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 426: wsh_debug_sv.log (l_module_name, 'Distributed Mode');

422: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
423: --
424: IF WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' THEN --Bugfix 13427327
425: IF l_debug_on THEN
426: wsh_debug_sv.log (l_module_name, 'Distributed Mode');
427: wsh_debug_sv.pop (l_module_name);
428: END IF;
429: return;
430: END IF;

Line 427: wsh_debug_sv.pop (l_module_name);

423: --
424: IF WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' THEN --Bugfix 13427327
425: IF l_debug_on THEN
426: wsh_debug_sv.log (l_module_name, 'Distributed Mode');
427: wsh_debug_sv.pop (l_module_name);
428: END IF;
429: return;
430: END IF;
431:

Line 451: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: No corresponding client exists');

447: END IF;
448: EXCEPTION
449: WHEN NO_DATA_FOUND THEN
450: IF l_debug_on THEN
451: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: No corresponding client exists');
452: END IF;
453: --
454: RAISE FND_API.G_EXC_ERROR;
455: END;

Line 460: wsh_debug_sv.logmsg(l_module_name, 'Calling api WMS_DEPLOY.GET_ITEM_FLEX_DELIMITER', WSH_DEBUG_SV.C_PROC_LEVEL);

456: --
457: -- Call inventory API to get the item delimiter..
458: IF p_client_code IS NOT NULL THEN
459: IF l_debug_on THEN
460: wsh_debug_sv.logmsg(l_module_name, 'Calling api WMS_DEPLOY.GET_ITEM_FLEX_DELIMITER', WSH_DEBUG_SV.C_PROC_LEVEL);
461: END IF;
462: P_item_delimiter := wms_deploy.get_item_flex_delimiter;
463: END IF;
464: --

Line 467: wsh_debug_sv.log (l_module_name, 'P_trading_partner_type', P_trading_partner_type);

463: END IF;
464: --
465: --
466: IF l_debug_on THEN
467: wsh_debug_sv.log (l_module_name, 'P_trading_partner_type', P_trading_partner_type);
468: wsh_debug_sv.log (l_module_name, 'p_client_code', p_client_code);
469: wsh_debug_sv.log (l_module_name, 'P_item_delimiter', P_item_delimiter);
470: wsh_debug_sv.log (l_module_name, 'Return Status', x_return_Status );
471: wsh_debug_sv.pop (l_module_name);

Line 468: wsh_debug_sv.log (l_module_name, 'p_client_code', p_client_code);

464: --
465: --
466: IF l_debug_on THEN
467: wsh_debug_sv.log (l_module_name, 'P_trading_partner_type', P_trading_partner_type);
468: wsh_debug_sv.log (l_module_name, 'p_client_code', p_client_code);
469: wsh_debug_sv.log (l_module_name, 'P_item_delimiter', P_item_delimiter);
470: wsh_debug_sv.log (l_module_name, 'Return Status', x_return_Status );
471: wsh_debug_sv.pop (l_module_name);
472: END IF;

Line 469: wsh_debug_sv.log (l_module_name, 'P_item_delimiter', P_item_delimiter);

465: --
466: IF l_debug_on THEN
467: wsh_debug_sv.log (l_module_name, 'P_trading_partner_type', P_trading_partner_type);
468: wsh_debug_sv.log (l_module_name, 'p_client_code', p_client_code);
469: wsh_debug_sv.log (l_module_name, 'P_item_delimiter', P_item_delimiter);
470: wsh_debug_sv.log (l_module_name, 'Return Status', x_return_Status );
471: wsh_debug_sv.pop (l_module_name);
472: END IF;
473: --

Line 470: wsh_debug_sv.log (l_module_name, 'Return Status', x_return_Status );

466: IF l_debug_on THEN
467: wsh_debug_sv.log (l_module_name, 'P_trading_partner_type', P_trading_partner_type);
468: wsh_debug_sv.log (l_module_name, 'p_client_code', p_client_code);
469: wsh_debug_sv.log (l_module_name, 'P_item_delimiter', P_item_delimiter);
470: wsh_debug_sv.log (l_module_name, 'Return Status', x_return_Status );
471: wsh_debug_sv.pop (l_module_name);
472: END IF;
473: --
474: EXCEPTION

Line 471: wsh_debug_sv.pop (l_module_name);

467: wsh_debug_sv.log (l_module_name, 'P_trading_partner_type', P_trading_partner_type);
468: wsh_debug_sv.log (l_module_name, 'p_client_code', p_client_code);
469: wsh_debug_sv.log (l_module_name, 'P_item_delimiter', P_item_delimiter);
470: wsh_debug_sv.log (l_module_name, 'Return Status', x_return_Status );
471: wsh_debug_sv.pop (l_module_name);
472: END IF;
473: --
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN

Line 481: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Get_Client_details',X_Return_Status );

477: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
478: --
479: IF l_debug_on THEN
480: --
481: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Get_Client_details',X_Return_Status );
482: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
483: WSH_DEBUG_SV.C_EXCEP_LEVEL);
484: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
485: --

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

478: --
479: IF l_debug_on THEN
480: --
481: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Get_Client_details',X_Return_Status );
482: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
483: WSH_DEBUG_SV.C_EXCEP_LEVEL);
484: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
485: --
486: END IF;

Line 483: WSH_DEBUG_SV.C_EXCEP_LEVEL);

479: IF l_debug_on THEN
480: --
481: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Get_Client_details',X_Return_Status );
482: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
483: WSH_DEBUG_SV.C_EXCEP_LEVEL);
484: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
485: --
486: END IF;
487: --

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

480: --
481: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Get_Client_details',X_Return_Status );
482: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured',
483: WSH_DEBUG_SV.C_EXCEP_LEVEL);
484: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
485: --
486: END IF;
487: --
488: WHEN OTHERS THEN

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

487: --
488: WHEN OTHERS THEN
489: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
492: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
494: END IF;
495: END Get_Client_details;

Line 492: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

488: WHEN OTHERS THEN
489: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
492: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
494: END IF;
495: END Get_Client_details;
496:

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

489: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
492: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
494: END IF;
495: END Get_Client_details;
496:
497: /*==============================================================================

Line 540: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

536: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
537: --
538: IF l_debug_on IS NULL
539: THEN
540: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
541: END IF;
542: --
543: IF l_debug_on THEN
544: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERIES');

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

540: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
541: END IF;
542: --
543: IF l_debug_on THEN
544: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERIES');
545: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
546: END IF;
547:
548: /* Check if the Delivery ID from Interface table exists in WSH_NEW_DELIVERIES Table */

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

541: END IF;
542: --
543: IF l_debug_on THEN
544: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERIES');
545: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
546: END IF;
547:
548: /* Check if the Delivery ID from Interface table exists in WSH_NEW_DELIVERIES Table */
549:

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

560: RAISE invalid_delivery_id;
561: END;
562:
563: IF l_debug_on THEN
564: wsh_debug_sv.log (l_module_name, 'Valid parameters for Validate Deliveries. Return Status : ',X_Return_Status );
565: END IF;
566:
567: /* If the Delivery exists in WSH_New_Deliveries, Get the corresponding Delivery_Detail_IDs
568: from the interface tables and check if they exist in the base tables, and if they are assigned

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

595: x_return_status := wsh_util_core.g_ret_sts_error;
596: END IF; -- if p_delivery_id is null
597:
598: IF l_debug_on THEN
599: wsh_debug_sv.log (l_module_name,'940 Add Exists for the 940 Cancellation sent. Return Status',X_Return_Status );
600: wsh_debug_sv.pop (l_module_name);
601: END IF;
602: EXCEPTION
603: WHEN invalid_delivery_id

Line 600: wsh_debug_sv.pop (l_module_name);

596: END IF; -- if p_delivery_id is null
597:
598: IF l_debug_on THEN
599: wsh_debug_sv.log (l_module_name,'940 Add Exists for the 940 Cancellation sent. Return Status',X_Return_Status );
600: wsh_debug_sv.pop (l_module_name);
601: END IF;
602: EXCEPTION
603: WHEN invalid_delivery_id
604: THEN

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

603: WHEN invalid_delivery_id
604: THEN
605: x_return_status := wsh_util_core.g_ret_sts_error;
606: IF l_debug_on THEN
607: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_id');
609: END IF;
610: WHEN invalid_delivery_detail_id
611: THEN

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

604: THEN
605: x_return_status := wsh_util_core.g_ret_sts_error;
606: IF l_debug_on THEN
607: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_id');
609: END IF;
610: WHEN invalid_delivery_detail_id
611: THEN
612: x_return_status := wsh_util_core.g_ret_sts_error;

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

610: WHEN invalid_delivery_detail_id
611: THEN
612: x_return_status := wsh_util_core.g_ret_sts_error;
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_detail_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
615: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
616: END IF;
617: WHEN OTHERS
618: THEN

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

611: THEN
612: x_return_status := wsh_util_core.g_ret_sts_error;
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_detail_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
615: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
616: END IF;
617: WHEN OTHERS
618: THEN
619: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

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

617: WHEN OTHERS
618: THEN
619: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
622: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
624: END IF;
625: END validate_deliveries;

Line 622: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

618: THEN
619: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
622: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
624: END IF;
625: END validate_deliveries;
626:

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

619: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
622: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
624: END IF;
625: END validate_deliveries;
626:
627: -- TPW - Distributed Organization Changes

Line 669: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

665: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
666: --
667: IF l_debug_on IS NULL
668: THEN
669: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
670: END IF;
671: --
672: IF l_debug_on THEN
673: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERY_DETAILS');

Line 673: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERY_DETAILS');

669: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
670: END IF;
671: --
672: IF l_debug_on THEN
673: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERY_DETAILS');
674: wsh_debug_sv.log (l_module_name, 'DELIVERY INTERFACE ID', p_delivery_interface_id);
675: END IF;
676:
677:

Line 674: wsh_debug_sv.log (l_module_name, 'DELIVERY INTERFACE ID', p_delivery_interface_id);

670: END IF;
671: --
672: IF l_debug_on THEN
673: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERY_DETAILS');
674: wsh_debug_sv.log (l_module_name, 'DELIVERY INTERFACE ID', p_delivery_interface_id);
675: END IF;
676:
677:
678: IF (p_delivery_interface_id IS NOT NULL)

Line 731: wsh_debug_sv.log (l_module_name,'Return Status',X_Return_Status );

727: x_return_status := wsh_util_core.g_ret_sts_error;
728: END IF; -- if p_delivery_interface_id is null
729:
730: IF l_debug_on THEN
731: wsh_debug_sv.log (l_module_name,'Return Status',X_Return_Status );
732: wsh_debug_sv.pop (l_module_name);
733: END IF;
734: EXCEPTION
735: WHEN invalid_delivery_detail_id

Line 732: wsh_debug_sv.pop (l_module_name);

728: END IF; -- if p_delivery_interface_id is null
729:
730: IF l_debug_on THEN
731: wsh_debug_sv.log (l_module_name,'Return Status',X_Return_Status );
732: wsh_debug_sv.pop (l_module_name);
733: END IF;
734: EXCEPTION
735: WHEN invalid_delivery_detail_id
736: THEN

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

735: WHEN invalid_delivery_detail_id
736: THEN
737: x_return_status := wsh_util_core.g_ret_sts_error;
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_detail_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
740: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
741: END IF;
742: WHEN OTHERS
743: THEN

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

736: THEN
737: x_return_status := wsh_util_core.g_ret_sts_error;
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_detail_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
740: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
741: END IF;
742: WHEN OTHERS
743: THEN
744: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

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

742: WHEN OTHERS
743: THEN
744: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
745: IF l_debug_on THEN
746: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
749: END IF;
750: END validate_delivery_details;

Line 747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

743: THEN
744: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
745: IF l_debug_on THEN
746: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
749: END IF;
750: END validate_delivery_details;
751:

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

744: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
745: IF l_debug_on THEN
746: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
749: END IF;
750: END validate_delivery_details;
751:
752: /*==============================================================================

Line 824: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

820: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
821: --
822: IF l_debug_on IS NULL
823: THEN
824: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
825: END IF;
826: --
827: IF l_debug_on THEN
828: wsh_debug_sv.push (l_module_name, 'Compare Ship Request Advice');

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

824: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
825: END IF;
826: --
827: IF l_debug_on THEN
828: wsh_debug_sv.push (l_module_name, 'Compare Ship Request Advice');
829: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
830: END IF;
831:
832: BEGIN

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

825: END IF;
826: --
827: IF l_debug_on THEN
828: wsh_debug_sv.push (l_module_name, 'Compare Ship Request Advice');
829: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
830: END IF;
831:
832: BEGIN
833: IF (p_delivery_id IS NOT NULL) THEN

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

846: RAISE invalid_delivery;
847: END IF;
848:
849: IF l_debug_on THEN
850: wsh_debug_sv.log (l_module_name, 'Valid values for Compare Ship Request Advice');
851: END IF;
852:
853: /* Compare values of the Delivery */
854:

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

861: RAISE data_changed;
862: ELSE
863:
864: IF l_debug_on THEN
865: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Data Did Not Change for Delivery');
866: END IF;
867:
868: /* Compare values of the Delivery Details */
869:

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

869:
870: FOR delivery_detail_int IN delivery_detail_int_cur (p_delivery_id)
871: LOOP
872: IF l_debug_on THEN
873: wsh_debug_sv.log (l_module_name, 'Delivery Detail Interface ID ',delivery_detail_int.delivery_detail_id);
874: END IF;
875: FOR delivery_detail IN delivery_detail_cur (delivery_detail_int.delivery_detail_id)
876: LOOP
877: IF l_debug_on THEN

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

874: END IF;
875: FOR delivery_detail IN delivery_detail_cur (delivery_detail_int.delivery_detail_id)
876: LOOP
877: IF l_debug_on THEN
878: wsh_debug_sv.log (l_module_name, 'Delivery Detail ID ',delivery_detail.delivery_detail_id);
879: END IF;
880:
881: IF (NVL (delivery_detail.customer_id, 0) <> NVL (delivery_detail_int.customer_id, 0))
882: OR (NVL (delivery_detail.customer_item_id, 0) <> NVL (delivery_detail_int.customer_item_id, 0))

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

889: THEN
890: RAISE data_changed;
891: ELSE
892: IF l_debug_on THEN
893: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Data Did Not Change for Delivery Details');
894: END IF;
895:
896: x_return_status := wsh_util_core.g_ret_sts_success;
897: END IF; -- if delivery_detail checks

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

918: RAISE invalid_delivery;
919: END IF; -- if p_delivery_id is not null
920:
921: IF l_debug_on THEN
922: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Return Status :'||X_Return_Status);
923: wsh_debug_sv.pop (l_module_name);
924: END IF;
925:
926: EXCEPTION

Line 923: wsh_debug_sv.pop (l_module_name);

919: END IF; -- if p_delivery_id is not null
920:
921: IF l_debug_on THEN
922: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Return Status :'||X_Return_Status);
923: wsh_debug_sv.pop (l_module_name);
924: END IF;
925:
926: EXCEPTION
927: WHEN invalid_delivery

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

927: WHEN invalid_delivery
928: THEN
929: x_return_status := wsh_util_core.g_ret_sts_error;
930: IF l_debug_on THEN
931: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
932: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
933: END IF;
934: WHEN data_changed
935: THEN

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

928: THEN
929: x_return_status := wsh_util_core.g_ret_sts_error;
930: IF l_debug_on THEN
931: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
932: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
933: END IF;
934: WHEN data_changed
935: THEN
936: x_return_status := wsh_util_core.g_ret_sts_error;

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

934: WHEN data_changed
935: THEN
936: x_return_status := wsh_util_core.g_ret_sts_error;
937: IF l_debug_on THEN
938: WSH_DEBUG_SV.logmsg(l_module_name,'data_changed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:data_changed');
940: END IF;
941: WHEN OTHERS
942: THEN

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

935: THEN
936: x_return_status := wsh_util_core.g_ret_sts_error;
937: IF l_debug_on THEN
938: WSH_DEBUG_SV.logmsg(l_module_name,'data_changed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:data_changed');
940: END IF;
941: WHEN OTHERS
942: THEN
943: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

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

941: WHEN OTHERS
942: THEN
943: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
946: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
948: END IF;
949: END;

Line 946: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

942: THEN
943: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
946: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
948: END IF;
949: END;
950:

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

943: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
946: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
948: END IF;
949: END;
950:
951: END compare_ship_request_advice;

Line 990: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

986: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
987: --
988: IF l_debug_on IS NULL
989: THEN
990: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
991: END IF;
992: --
993: IF l_debug_on THEN
994: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');

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

990: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
991: END IF;
992: --
993: IF l_debug_on THEN
994: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
995: wsh_debug_sv.log (l_module_name, 'Interface table name', p_interface_errors_rec.p_interface_table_name);
996: wsh_debug_sv.log (l_module_name, 'Interface Id', p_interface_errors_rec.p_interface_id);
997: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);
998: END IF;

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

991: END IF;
992: --
993: IF l_debug_on THEN
994: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
995: wsh_debug_sv.log (l_module_name, 'Interface table name', p_interface_errors_rec.p_interface_table_name);
996: wsh_debug_sv.log (l_module_name, 'Interface Id', p_interface_errors_rec.p_interface_id);
997: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);
998: END IF;
999:

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

992: --
993: IF l_debug_on THEN
994: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
995: wsh_debug_sv.log (l_module_name, 'Interface table name', p_interface_errors_rec.p_interface_table_name);
996: wsh_debug_sv.log (l_module_name, 'Interface Id', p_interface_errors_rec.p_interface_id);
997: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);
998: END IF;
999:
1000: IF (p_msg_data IS NULL) THEN

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

993: IF l_debug_on THEN
994: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
995: wsh_debug_sv.log (l_module_name, 'Interface table name', p_interface_errors_rec.p_interface_table_name);
996: wsh_debug_sv.log (l_module_name, 'Interface Id', p_interface_errors_rec.p_interface_id);
997: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);
998: END IF;
999:
1000: IF (p_msg_data IS NULL) THEN
1001: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);

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

1020: IF (p_interface_errors_rec.p_interface_table_name IS NOT NULL)
1021: AND (p_interface_errors_rec.p_interface_id IS NOT NULL) THEN
1022:
1023: IF l_debug_on THEN
1024: wsh_debug_sv.log (l_module_name, 'Log Interface Errors. Valid Parameters');
1025: END IF;
1026:
1027: IF (p_interface_errors_rec.p_message_name IS NOT NULL) THEN
1028: -- Build the Error message string.

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

1097: END IF;
1098:
1099:
1100: IF l_debug_on THEN
1101: wsh_debug_sv.log (l_module_name, 'Text: ', l_text);
1102: END IF;
1103: -- Insert error record in WSH_Interface_errors table.
1104: -- We need the check for l_text because the column error_message
1105: -- is a Not_Null column.

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

1105: -- is a Not_Null column.
1106:
1107: IF (l_text IS NOT NULL) THEN
1108: IF l_debug_on THEN
1109: wsh_debug_sv.log (l_module_name, 'Error Message', l_text);
1110: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');
1111: END IF;
1112:
1113: INSERT INTO wsh_interface_errors

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

1106:
1107: IF (l_text IS NOT NULL) THEN
1108: IF l_debug_on THEN
1109: wsh_debug_sv.log (l_module_name, 'Error Message', l_text);
1110: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');
1111: END IF;
1112:
1113: INSERT INTO wsh_interface_errors
1114: (interface_error_id,

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

1125: COMMIT;
1126:
1127: ELSE
1128: IF l_debug_on THEN
1129: wsh_debug_sv.log (l_module_name, 'Text for error_message is null');
1130: END IF;
1131: END IF; -- if l_text is not null
1132: x_return_status := wsh_util_core.g_ret_sts_success;
1133: ELSE

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

1134: RAISE invalid_parameters;
1135: END IF;
1136:
1137: IF l_debug_on THEN
1138: wsh_debug_sv.log (l_module_name, 'Log Interface Errors. Return Status. :'||X_Return_Status);
1139: wsh_debug_sv.pop (l_module_name);
1140: END IF;
1141: EXCEPTION
1142: WHEN invalid_parameters

Line 1139: wsh_debug_sv.pop (l_module_name);

1135: END IF;
1136:
1137: IF l_debug_on THEN
1138: wsh_debug_sv.log (l_module_name, 'Log Interface Errors. Return Status. :'||X_Return_Status);
1139: wsh_debug_sv.pop (l_module_name);
1140: END IF;
1141: EXCEPTION
1142: WHEN invalid_parameters
1143: THEN

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

1142: WHEN invalid_parameters
1143: THEN
1144: x_return_status := wsh_util_core.g_ret_sts_error;
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1147: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1148: END IF;
1149: WHEN OTHERS
1150: THEN

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

1143: THEN
1144: x_return_status := wsh_util_core.g_ret_sts_error;
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1147: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1148: END IF;
1149: WHEN OTHERS
1150: THEN
1151: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

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

1149: WHEN OTHERS
1150: THEN
1151: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1154: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1155: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1156: END IF;
1157:

Line 1154: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1150: THEN
1151: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1154: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1155: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1156: END IF;
1157:
1158: END log_interface_errors;

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

1151: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1154: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1155: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1156: END IF;
1157:
1158: END log_interface_errors;
1159:

Line 1196: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1192: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1193: --
1194: IF l_debug_on IS NULL
1195: THEN
1196: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1197: END IF;
1198: --
1199: IF l_debug_on THEN
1200: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');

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

1196: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1197: END IF;
1198: --
1199: IF l_debug_on THEN
1200: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
1201: wsh_debug_sv.log (l_module_name, 'Message Count', p_interface_errors_rec_tab.COUNT);
1202: wsh_debug_sv.log (l_module_name, 'Interface Action Code', p_interface_action_code);
1203: END IF;
1204:

Line 1201: wsh_debug_sv.log (l_module_name, 'Message Count', p_interface_errors_rec_tab.COUNT);

1197: END IF;
1198: --
1199: IF l_debug_on THEN
1200: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
1201: wsh_debug_sv.log (l_module_name, 'Message Count', p_interface_errors_rec_tab.COUNT);
1202: wsh_debug_sv.log (l_module_name, 'Interface Action Code', p_interface_action_code);
1203: END IF;
1204:
1205: x_return_status := wsh_util_core.g_ret_sts_success;

Line 1202: wsh_debug_sv.log (l_module_name, 'Interface Action Code', p_interface_action_code);

1198: --
1199: IF l_debug_on THEN
1200: wsh_debug_sv.push(l_module_name, 'Log_Interface_Errors');
1201: wsh_debug_sv.log (l_module_name, 'Message Count', p_interface_errors_rec_tab.COUNT);
1202: wsh_debug_sv.log (l_module_name, 'Interface Action Code', p_interface_action_code);
1203: END IF;
1204:
1205: x_return_status := wsh_util_core.g_ret_sts_success;
1206:

Line 1289: wsh_debug_sv.logmsg(l_module_name, 'Index '||i||' : Message Name or Text is Mandatory');

1285: END IF;
1286:
1287: ELSE
1288: IF l_debug_on THEN
1289: wsh_debug_sv.logmsg(l_module_name, 'Index '||i||' : Message Name or Text is Mandatory');
1290: END IF;
1291: raise invalid_parameters;
1292: END IF; -- }
1293: ELSE

Line 1295: wsh_debug_sv.logmsg(l_module_name, 'Index '||i||' : Interface Table Name AND Interface Error Id are Mandatory');

1291: raise invalid_parameters;
1292: END IF; -- }
1293: ELSE
1294: IF l_debug_on THEN
1295: wsh_debug_sv.logmsg(l_module_name, 'Index '||i||' : Interface Table Name AND Interface Error Id are Mandatory');
1296: END IF;
1297: raise invalid_parameters;
1298: END IF;
1299:

Line 1375: wsh_debug_sv.logmsg (l_module_name, 'Inserted '||l_text_tab.COUNT||' Interface Error Records');

1371:
1372: END IF; --}
1373:
1374: IF l_debug_on THEN
1375: wsh_debug_sv.logmsg (l_module_name, 'Inserted '||l_text_tab.COUNT||' Interface Error Records');
1376: wsh_debug_sv.log(l_module_name, 'Return Status',x_return_status);
1377: wsh_debug_sv.pop (l_module_name);
1378: END IF;
1379: EXCEPTION

Line 1376: wsh_debug_sv.log(l_module_name, 'Return Status',x_return_status);

1372: END IF; --}
1373:
1374: IF l_debug_on THEN
1375: wsh_debug_sv.logmsg (l_module_name, 'Inserted '||l_text_tab.COUNT||' Interface Error Records');
1376: wsh_debug_sv.log(l_module_name, 'Return Status',x_return_status);
1377: wsh_debug_sv.pop (l_module_name);
1378: END IF;
1379: EXCEPTION
1380: WHEN invalid_parameters

Line 1377: wsh_debug_sv.pop (l_module_name);

1373:
1374: IF l_debug_on THEN
1375: wsh_debug_sv.logmsg (l_module_name, 'Inserted '||l_text_tab.COUNT||' Interface Error Records');
1376: wsh_debug_sv.log(l_module_name, 'Return Status',x_return_status);
1377: wsh_debug_sv.pop (l_module_name);
1378: END IF;
1379: EXCEPTION
1380: WHEN invalid_parameters
1381: THEN

Line 1384: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_PARAMETERS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1380: WHEN invalid_parameters
1381: THEN
1382: x_return_status := wsh_util_core.g_ret_sts_error;
1383: IF l_debug_on THEN
1384: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_PARAMETERS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_PARAMETERS');
1386: END IF;
1387: WHEN OTHERS
1388: THEN

Line 1385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_PARAMETERS');

1381: THEN
1382: x_return_status := wsh_util_core.g_ret_sts_error;
1383: IF l_debug_on THEN
1384: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_PARAMETERS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_PARAMETERS');
1386: END IF;
1387: WHEN OTHERS
1388: THEN
1389: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

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

1387: WHEN OTHERS
1388: THEN
1389: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1392: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1394: END IF;
1395: END log_interface_errors;

Line 1392: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1388: THEN
1389: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1392: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1394: END IF;
1395: END log_interface_errors;
1396:

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

1389: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1392: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1394: END IF;
1395: END log_interface_errors;
1396:
1397: END wsh_interface_validations_pkg;