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_DELIVERY_DETAILS_PUB dependencies on WSH_DEBUG_SV

Line 89: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

85: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
86: --
87: IF l_debug_on IS NULL
88: THEN
89: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
90: END IF;
91: --
92: SAVEPOINT DETAIL_TO_DELIVERY_PUB;
93: IF l_debug_on THEN

Line 94: WSH_DEBUG_SV.push(l_module_name);

90: END IF;
91: --
92: SAVEPOINT DETAIL_TO_DELIVERY_PUB;
93: IF l_debug_on THEN
94: WSH_DEBUG_SV.push(l_module_name);
95: --
96: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
97: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
98: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

92: SAVEPOINT DETAIL_TO_DELIVERY_PUB;
93: IF l_debug_on THEN
94: WSH_DEBUG_SV.push(l_module_name);
95: --
96: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
97: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
98: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
99: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
100: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);

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

93: IF l_debug_on THEN
94: WSH_DEBUG_SV.push(l_module_name);
95: --
96: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
97: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
98: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
99: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
100: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
101: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);

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

94: WSH_DEBUG_SV.push(l_module_name);
95: --
96: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
97: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
98: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
99: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
100: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
101: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
102: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);

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

95: --
96: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
97: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
98: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
99: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
100: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
101: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
102: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
103: END IF;

Line 100: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);

96: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
97: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
98: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
99: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
100: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
101: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
102: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
103: END IF;
104: --

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

97: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
98: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
99: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
100: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
101: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
102: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
103: END IF;
104: --
105:

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

98: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
99: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
100: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
101: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
102: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
103: END IF;
104: --
105:
106: IF NOT FND_API.compatible_api_call( l_api_version,

Line 140: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

136: /* Patchset I: Harmonization Project. Call group API
137: All validations done by Group API */
138:
139: IF l_debug_on THEN
140: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
141: END IF;
142: --
143:
144: wsh_interface_grp.delivery_detail_action(

Line 156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

152: p_action_prms => l_action_prms ,
153: x_action_out_rec => l_action_out_rec);
154:
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
157: END IF;
158: --
159: wsh_util_core.api_post_call(
160: p_return_status => l_return_status,

Line 184: WSH_DEBUG_SV.pop(l_module_name);

180: p_encoded => FND_API.G_FALSE
181: );
182:
183: IF l_debug_on THEN
184: WSH_DEBUG_SV.pop(l_module_name);
185: END IF;
186: --
187: exception
188: WHEN FND_API.G_EXC_ERROR THEN

Line 200: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

196: p_encoded => FND_API.G_FALSE
197: );
198:
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
202: END IF;
203: --
204: WHEN WSH_NO_DEL_DET_TBL then

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

197: );
198:
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
202: END IF;
203: --
204: WHEN WSH_NO_DEL_DET_TBL then
205: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;

Line 217: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_DEL_DET_TBL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

213: p_encoded => FND_API.G_FALSE
214: );
215:
216: IF l_debug_on THEN
217: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_DEL_DET_TBL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
218: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_DEL_DET_TBL');
219: END IF;
220: --
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 218: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_DEL_DET_TBL');

214: );
215:
216: IF l_debug_on THEN
217: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_DEL_DET_TBL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
218: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_DEL_DET_TBL');
219: END IF;
220: --
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;

Line 234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

230: );
231: --
232:
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
236: END IF;
237: WHEN others then
238: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;

Line 235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

231: --
232:
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
236: END IF;
237: WHEN others then
238: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
239: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY');

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

245: p_encoded => FND_API.G_FALSE
246: );
247:
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
250: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
251: END IF;
252: --
253: END detail_to_delivery;

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

246: );
247:
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
250: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
251: END IF;
252: --
253: END detail_to_delivery;
254:

Line 317: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

313: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
314: --
315: IF l_debug_on IS NULL
316: THEN
317: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
318: END IF;
319: --
320: SAVEPOINT SPLIT_LINE_PUB;
321:

Line 323: WSH_DEBUG_SV.push(l_module_name);

319: --
320: SAVEPOINT SPLIT_LINE_PUB;
321:
322: IF l_debug_on THEN
323: WSH_DEBUG_SV.push(l_module_name);
324: --
325: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
326: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
327: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

321:
322: IF l_debug_on THEN
323: WSH_DEBUG_SV.push(l_module_name);
324: --
325: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
326: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
327: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
328: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
329: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);

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

322: IF l_debug_on THEN
323: WSH_DEBUG_SV.push(l_module_name);
324: --
325: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
326: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
327: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
328: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
329: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
330: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);

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

323: WSH_DEBUG_SV.push(l_module_name);
324: --
325: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
326: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
327: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
328: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
329: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
330: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
331: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);

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

324: --
325: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
326: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
327: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
328: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
329: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
330: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
331: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
332: END IF;

Line 329: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);

325: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
326: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
327: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
328: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
329: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
330: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
331: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
332: END IF;
333: --

Line 330: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);

326: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
327: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
328: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
329: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
330: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
331: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
332: END IF;
333: --
334:

Line 331: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);

327: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
328: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
329: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
330: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
331: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
332: END IF;
333: --
334:
335: IF NOT FND_API.compatible_api_call(l_api_version,

Line 358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

354: /* Patchset I: Harmonization Project. Call group API
355: All validations done by Group API */
356:
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
359: END IF;
360:
361: wsh_interface_grp.delivery_detail_action(
362: p_api_version_number => p_api_version,

Line 373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

369: p_action_prms => l_action_prms ,
370: x_action_out_rec => l_action_out_rec);
371:
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
374: END IF;
375: --
376: wsh_util_core.api_post_call(
377: p_return_status => l_return_status,

Line 405: WSH_DEBUG_SV.pop(l_module_name);

401: p_encoded => FND_API.G_FALSE
402: );
403:
404: IF l_debug_on THEN
405: WSH_DEBUG_SV.pop(l_module_name);
406: END IF;
407: --
408: exception
409: WHEN FND_API.G_EXC_ERROR THEN

Line 421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

417: p_encoded => FND_API.G_FALSE
418: );
419:
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
423: END IF;
424: --
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

418: );
419:
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
423: END IF;
424: --
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: ROLLBACK TO SPLIT_LINE_PUB;

Line 438: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

434: );
435: --
436:
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
440: END IF;
441: WHEN OTHERS THEN
442: ROLLBACK TO SPLIT_LINE_PUB;

Line 439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

435: --
436:
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
440: END IF;
441: WHEN OTHERS THEN
442: ROLLBACK TO SPLIT_LINE_PUB;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

450: p_encoded => FND_API.G_FALSE
451: );
452: --
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
455: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
456: END IF;
457: --
458: END split_line;

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

451: );
452: --
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
455: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
456: END IF;
457: --
458: END split_line;
459: --===================

Line 484: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

480: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
481: --
482: IF l_debug_on IS NULL
483: THEN
484: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
485: END IF;
486: --
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.push(l_module_name);

Line 488: WSH_DEBUG_SV.push(l_module_name);

484: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
485: END IF;
486: --
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.push(l_module_name);
489: END IF;
490: --
491: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
492: p_init_rec.source_header_id := FND_API.G_MISS_NUM;

Line 587: WSH_DEBUG_SV.pop(l_module_name);

583: --
584: -- Debug Statements
585: --
586: IF l_debug_on THEN
587: WSH_DEBUG_SV.pop(l_module_name);
588: END IF;
589: --
590: EXCEPTION
591: WHEN Others THEN

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

597: --
598: -- Debug Statements
599: --
600: IF l_debug_on THEN
601: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
602: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
603: END IF;
604: --
605: END Init_Changed_Attribute_Rec;

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

598: -- Debug Statements
599: --
600: IF l_debug_on THEN
601: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
602: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
603: END IF;
604: --
605: END Init_Changed_Attribute_Rec;
606:

Line 679: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

675: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
676: --
677: IF l_debug_on IS NULL
678: THEN
679: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
680: END IF;
681: --
682: SAVEPOINT UPDATE_SHIPPING_ATTR_PUB;
683:

Line 685: WSH_DEBUG_SV.push(l_module_name);

681: --
682: SAVEPOINT UPDATE_SHIPPING_ATTR_PUB;
683:
684: IF l_debug_on THEN
685: WSH_DEBUG_SV.push(l_module_name);
686: --
687: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
688: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
689: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 687: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

683:
684: IF l_debug_on THEN
685: WSH_DEBUG_SV.push(l_module_name);
686: --
687: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
688: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
689: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
690: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
691: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);

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

684: IF l_debug_on THEN
685: WSH_DEBUG_SV.push(l_module_name);
686: --
687: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
688: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
689: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
690: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
691: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
692: END IF;

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

685: WSH_DEBUG_SV.push(l_module_name);
686: --
687: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
688: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
689: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
690: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
691: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
692: END IF;
693: --

Line 690: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);

686: --
687: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
688: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
689: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
690: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
691: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
692: END IF;
693: --
694:

Line 691: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);

687: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
688: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
689: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
690: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
691: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
692: END IF;
693: --
694:
695: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 730: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

726: /* Patchset I: Harmonization Project. Call group API
727: All validations done by Group API */
728:
729: IF l_debug_on THEN
730: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
731: END IF;
732: wsh_interface_grp.create_update_delivery_detail(
733: p_api_version_number => p_api_version_number,
734: p_init_msg_list => FND_API.G_FALSE,

Line 744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

740: p_IN_rec => l_in_rec,
741: x_OUT_rec => l_out_rec);
742:
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
745: END IF;
746: --
747: wsh_util_core.api_post_call(
748: p_return_status => l_return_status,

Line 771: WSH_DEBUG_SV.pop(l_module_name);

767: p_encoded => FND_API.G_FALSE
768: );
769:
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.pop(l_module_name);
772: END IF;
773: --
774: EXCEPTION
775: WHEN FND_API.G_EXC_ERROR THEN

Line 787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

783: p_encoded => FND_API.G_FALSE
784: );
785:
786: IF l_debug_on THEN
787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
789: END IF;
790: --
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

784: );
785:
786: IF l_debug_on THEN
787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
789: END IF;
790: --
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line 804: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

800: );
801: --
802:
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
805: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
806: END IF;
807: --
808: WHEN invalid_source_code THEN

Line 805: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

801: --
802:
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
805: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
806: END IF;
807: --
808: WHEN invalid_source_code THEN
809: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line 823: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

819: p_encoded => FND_API.G_FALSE
820: );
821:
822: IF l_debug_on THEN
823: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
824: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
825: END IF;
826: --
827: WHEN Others THEN

Line 824: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');

820: );
821:
822: IF l_debug_on THEN
823: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
824: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
825: END IF;
826: --
827: WHEN Others THEN
828: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

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

838: p_encoded => FND_API.G_FALSE
839: );
840:
841: IF l_debug_on THEN
842: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
843: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
844: END IF;
845: --
846: END Update_Shipping_Attributes;

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

839: );
840:
841: IF l_debug_on THEN
842: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
843: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
844: END IF;
845: --
846: END Update_Shipping_Attributes;
847:

Line 922: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

918: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
919: --
920: IF l_debug_on IS NULL
921: THEN
922: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
923: END IF;
924: --
925: SAVEPOINT UPDATE_SHIPPING_ATTR_PUB2;
926:

Line 928: WSH_DEBUG_SV.push(l_module_name);

924: --
925: SAVEPOINT UPDATE_SHIPPING_ATTR_PUB2;
926:
927: IF l_debug_on THEN
928: WSH_DEBUG_SV.push(l_module_name);
929: --
930: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
931: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
932: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 930: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

926:
927: IF l_debug_on THEN
928: WSH_DEBUG_SV.push(l_module_name);
929: --
930: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
931: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
932: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
933: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
934: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);

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

927: IF l_debug_on THEN
928: WSH_DEBUG_SV.push(l_module_name);
929: --
930: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
931: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
932: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
933: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
934: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
935: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);

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

928: WSH_DEBUG_SV.push(l_module_name);
929: --
930: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
931: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
932: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
933: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
934: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
935: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);
936:

Line 933: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);

929: --
930: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
931: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
932: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
933: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
934: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
935: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);
936:
937:

Line 934: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);

930: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
931: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
932: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
933: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
934: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
935: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);
936:
937:
938: END IF;

Line 935: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);

931: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
932: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
933: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
934: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
935: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);
936:
937:
938: END IF;
939: --

Line 986: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

982: /* Patchset I: Harmonization Project. Call group API
983: All validations done by Group API */
984:
985: IF l_debug_on THEN
986: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
987: END IF;
988:
989: wsh_delivery_details_grp.create_update_delivery_detail(
990: p_api_version_number => p_api_version_number,

Line 1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

999: p_serial_range_tab => l_serial_range_tab
1000: );
1001:
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005: --
1006: wsh_util_core.api_post_call(
1007: p_return_status => l_return_status,

Line 1029: WSH_DEBUG_SV.pop(l_module_name);

1025: p_encoded => FND_API.G_FALSE
1026: );
1027:
1028: IF l_debug_on THEN
1029: WSH_DEBUG_SV.pop(l_module_name);
1030: END IF;
1031: --
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN

Line 1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1041: p_encoded => FND_API.G_FALSE
1042: );
1043:
1044: IF l_debug_on THEN
1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1047: END IF;
1048: --
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1042: );
1043:
1044: IF l_debug_on THEN
1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1047: END IF;
1048: --
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line 1062: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1058: );
1059: --
1060:
1061: IF l_debug_on THEN
1062: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1063: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1064: END IF;
1065: --
1066: WHEN invalid_source_code THEN

Line 1063: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1059: --
1060:
1061: IF l_debug_on THEN
1062: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1063: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1064: END IF;
1065: --
1066: WHEN invalid_source_code THEN
1067: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line 1081: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1077: p_encoded => FND_API.G_FALSE
1078: );
1079:
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1082: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
1083: END IF;
1084: --
1085: WHEN Others THEN

Line 1082: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');

1078: );
1079:
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1082: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
1083: END IF;
1084: --
1085: WHEN Others THEN
1086: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

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

1095: p_data => x_msg_data,
1096: p_encoded => FND_API.G_FALSE
1097: );
1098: IF l_debug_on THEN
1099: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1100: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1101: END IF;
1102: --
1103: END Update_Shipping_Attributes;

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

1096: p_encoded => FND_API.G_FALSE
1097: );
1098: IF l_debug_on THEN
1099: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1100: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1101: END IF;
1102: --
1103: END Update_Shipping_Attributes;
1104:

Line 1140: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1136: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1137: --
1138: IF l_debug_on IS NULL
1139: THEN
1140: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1141: END IF;
1142: --
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.push(l_module_name);

Line 1144: WSH_DEBUG_SV.push(l_module_name);

1140: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1141: END IF;
1142: --
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.push(l_module_name);
1145: --
1146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
1147: END IF;
1148: --

Line 1146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);

1142: --
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.push(l_module_name);
1145: --
1146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
1147: END IF;
1148: --
1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1150:

Line 1187: WSH_DEBUG_SV.pop(l_module_name);

1183: --
1184: -- Debug Statements
1185: --
1186: IF l_debug_on THEN
1187: WSH_DEBUG_SV.pop(l_module_name);
1188: END IF;
1189: --
1190: END get_detail_status;
1191:

Line 1234: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1230: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1231: --
1232: IF l_debug_on IS NULL
1233: THEN
1234: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1235: END IF;
1236: --
1237: SAVEPOINT AUTOCREATE_DEL_PUB;
1238: --

Line 1240: WSH_DEBUG_SV.push(l_module_name);

1236: --
1237: SAVEPOINT AUTOCREATE_DEL_PUB;
1238: --
1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.push(l_module_name);
1241: --
1242: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1243: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1244: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 1242: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

1238: --
1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.push(l_module_name);
1241: --
1242: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1243: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1244: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1245: END IF;
1246: --

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

1239: IF l_debug_on THEN
1240: WSH_DEBUG_SV.push(l_module_name);
1241: --
1242: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1243: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1244: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1245: END IF;
1246: --
1247:

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

1240: WSH_DEBUG_SV.push(l_module_name);
1241: --
1242: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1243: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1244: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1245: END IF;
1246: --
1247:
1248:

Line 1270: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1266: /* Patchset I: Harmonization Project. Call group API
1267: All validations done by Group API */
1268:
1269: IF l_debug_on THEN
1270: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1271: END IF;
1272:
1273: wsh_interface_grp.delivery_detail_action(
1274: p_api_version_number => p_api_version_number,

Line 1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1281: p_action_prms => l_action_prms ,
1282: x_action_out_rec => l_action_out_rec);
1283:
1284: IF l_debug_on THEN
1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1286: END IF;
1287: --
1288: wsh_util_core.api_post_call(
1289: p_return_status => l_return_status,

Line 1316: WSH_DEBUG_SV.pop(l_module_name);

1312: END IF;
1313:
1314:
1315: IF l_debug_on THEN
1316: WSH_DEBUG_SV.pop(l_module_name);
1317: END IF;
1318: --
1319: EXCEPTION
1320: WHEN FND_API.G_EXC_ERROR THEN

Line 1332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1328: p_encoded => FND_API.G_FALSE
1329: );
1330:
1331: IF l_debug_on THEN
1332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1334: END IF;
1335:
1336: WHEN autocreate_delivery_failed THEN

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

1329: );
1330:
1331: IF l_debug_on THEN
1332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1334: END IF;
1335:
1336: WHEN autocreate_delivery_failed THEN
1337: ROLLBACK TO AUTOCREATE_DEL_PUB;

Line 1347: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1343: p_encoded => FND_API.G_FALSE
1344: );
1345:
1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');
1349: END IF;
1350:
1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');

1344: );
1345:
1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');
1349: END IF;
1350:
1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1352: ROLLBACK TO AUTOCREATE_DEL_PUB;

Line 1364: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1360: );
1361: --
1362:
1363: IF l_debug_on THEN
1364: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1365: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1366: END IF;
1367: WHEN OTHERS THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1365: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1361: --
1362:
1363: IF l_debug_on THEN
1364: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1365: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1366: END IF;
1367: WHEN OTHERS THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: ROLLBACK TO AUTOCREATE_DEL_PUB;

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

1376: p_encoded => FND_API.G_FALSE
1377: );
1378: --
1379: IF l_debug_on THEN
1380: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1381: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1382: END IF;
1383: --
1384: END Autocreate_Deliveries;

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

1377: );
1378: --
1379: IF l_debug_on THEN
1380: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1381: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1382: END IF;
1383: --
1384: END Autocreate_Deliveries;
1385:

Line 1413: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1409: --
1410: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1411: --
1412: IF l_debug_on IS NULL THEN
1413: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1414: END IF;
1415: --
1416: SAVEPOINT AUTOCREATE_TRIP_PUB;
1417: --

Line 1419: WSH_DEBUG_SV.push(l_module_name);

1415: --
1416: SAVEPOINT AUTOCREATE_TRIP_PUB;
1417: --
1418: IF l_debug_on THEN
1419: WSH_DEBUG_SV.push(l_module_name);
1420: END IF;
1421: --
1422:
1423:

Line 1425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip - multiple trips',WSH_DEBUG_SV.C_PROC_LEVEL);

1421: --
1422:
1423:
1424: IF l_debug_on THEN
1425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip - multiple trips',WSH_DEBUG_SV.C_PROC_LEVEL);
1426: END IF;
1427:
1428:
1429: WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip(

Line 1455: WSH_DEBUG_SV.pop(l_module_name);

1451: x_trip_name := NULL;
1452: END IF;
1453:
1454: IF l_debug_on THEN
1455: WSH_DEBUG_SV.pop(l_module_name);
1456: END IF;
1457:
1458: EXCEPTION
1459:

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

1471: p_encoded => FND_API.G_FALSE
1472: );
1473:
1474: IF l_debug_on THEN
1475: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1476: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1477: END IF;
1478:
1479: END Autocreate_del_trip;

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

1472: );
1473:
1474: IF l_debug_on THEN
1475: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1476: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1477: END IF;
1478:
1479: END Autocreate_del_trip;
1480:

Line 1525: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1521: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1522: --
1523: IF l_debug_on IS NULL
1524: THEN
1525: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1526: END IF;
1527: --
1528: SAVEPOINT AUTOCREATE_TRIP_PUB;
1529: --

Line 1531: WSH_DEBUG_SV.push(l_module_name);

1527: --
1528: SAVEPOINT AUTOCREATE_TRIP_PUB;
1529: --
1530: IF l_debug_on THEN
1531: WSH_DEBUG_SV.push(l_module_name);
1532: --
1533: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1534: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1535: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 1533: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

1529: --
1530: IF l_debug_on THEN
1531: WSH_DEBUG_SV.push(l_module_name);
1532: --
1533: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1534: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1535: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1536: END IF;
1537: --

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

1530: IF l_debug_on THEN
1531: WSH_DEBUG_SV.push(l_module_name);
1532: --
1533: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1534: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1535: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1536: END IF;
1537: --
1538:

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

1531: WSH_DEBUG_SV.push(l_module_name);
1532: --
1533: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1534: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1535: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1536: END IF;
1537: --
1538:
1539: IF NOT FND_API.compatible_api_call(

Line 1560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1556: /* Patchset I: Harmonization Project. Call group API
1557: All validations done by Group API */
1558:
1559: IF l_debug_on THEN
1560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1561: END IF;
1562:
1563: wsh_interface_grp.delivery_detail_action(
1564: p_api_version_number => p_api_version_number,

Line 1575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1571: p_action_prms => l_action_prms ,
1572: x_action_out_rec => l_action_out_rec);
1573:
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1576: END IF;
1577: --
1578: wsh_util_core.api_post_call(
1579: p_return_status => l_return_status,

Line 1605: WSH_DEBUG_SV.pop(l_module_name);

1601: );
1602:
1603:
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.pop(l_module_name);
1606: END IF;
1607:
1608: EXCEPTION
1609: WHEN FND_API.G_EXC_ERROR THEN

Line 1621: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1617: p_encoded => FND_API.G_FALSE
1618: );
1619:
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1623: END IF;
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1618: );
1619:
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1623: END IF;
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: ROLLBACK TO AUTOCREATE_TRIP_PUB;

Line 1638: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1634: );
1635: --
1636:
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1640: END IF;
1641:
1642:

Line 1639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1635: --
1636:
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1640: END IF;
1641:
1642:
1643: WHEN autocreate_trip_failed THEN

Line 1654: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_TRIP_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1650: p_encoded => FND_API.G_FALSE
1651: );
1652:
1653: IF l_debug_on THEN
1654: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_TRIP_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1655: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_TRIP_FAILED');
1656: END IF;
1657:
1658: WHEN OTHERS THEN

Line 1655: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_TRIP_FAILED');

1651: );
1652:
1653: IF l_debug_on THEN
1654: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_TRIP_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1655: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_TRIP_FAILED');
1656: END IF;
1657:
1658: WHEN OTHERS THEN
1659:

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

1668: p_encoded => FND_API.G_FALSE
1669: );
1670: --
1671: IF l_debug_on THEN
1672: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1673: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1674: END IF;
1675: --
1676: END Autocreate_del_trip;

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

1669: );
1670: --
1671: IF l_debug_on THEN
1672: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1673: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1674: END IF;
1675: --
1676: END Autocreate_del_trip;
1677:

Line 1695: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1691: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1692: --
1693: IF l_debug_on IS NULL
1694: THEN
1695: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1696: END IF;
1697: --
1698: IF l_debug_on THEN
1699:

Line 1700: WSH_DEBUG_SV.push(l_module_name);

1696: END IF;
1697: --
1698: IF l_debug_on THEN
1699:
1700: WSH_DEBUG_SV.push(l_module_name);
1701: WSH_DEBUG_SV.log(l_module_name,'X_CHANGED_ATTRIBUTES.COUNT', X_CHANGED_ATTRIBUTES.COUNT);
1702:
1703: END IF;
1704:

Line 1701: WSH_DEBUG_SV.log(l_module_name,'X_CHANGED_ATTRIBUTES.COUNT', X_CHANGED_ATTRIBUTES.COUNT);

1697: --
1698: IF l_debug_on THEN
1699:
1700: WSH_DEBUG_SV.push(l_module_name);
1701: WSH_DEBUG_SV.log(l_module_name,'X_CHANGED_ATTRIBUTES.COUNT', X_CHANGED_ATTRIBUTES.COUNT);
1702:
1703: END IF;
1704:
1705: l_index := x_changed_attributes.FIRST;

Line 1893: WSH_DEBUG_SV.pop(l_module_name);

1889: l_index := x_changed_attributes.NEXT(l_index);
1890: END LOOP;
1891:
1892: IF l_debug_on THEN
1893: WSH_DEBUG_SV.pop(l_module_name);
1894: END IF;
1895:
1896: EXCEPTION
1897:

Line 1901: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1897:
1898: WHEN FND_API.G_EXC_ERROR THEN
1899:
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1902: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1903: END IF;
1904: raise;
1905:

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

1898: WHEN FND_API.G_EXC_ERROR THEN
1899:
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1902: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1903: END IF;
1904: raise;
1905:
1906:

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

1907: WHEN OTHERS THEN
1908:
1909: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1913: END IF;
1914: raise;
1915:

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

1908:
1909: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1913: END IF;
1914: raise;
1915:
1916: END Copy_Attributes;