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

334: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
335: --
336: IF l_debug_on IS NULL
337: THEN
338: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
339: END IF;
340: --
341: SAVEPOINT SPLIT_LINE_PUB;
342:

Line 344: WSH_DEBUG_SV.push(l_module_name);

340: --
341: SAVEPOINT SPLIT_LINE_PUB;
342:
343: IF l_debug_on THEN
344: WSH_DEBUG_SV.push(l_module_name);
345: --
346: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
347: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
348: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

342:
343: IF l_debug_on THEN
344: WSH_DEBUG_SV.push(l_module_name);
345: --
346: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
347: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
348: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
349: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
350: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);

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

343: IF l_debug_on THEN
344: WSH_DEBUG_SV.push(l_module_name);
345: --
346: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
347: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
348: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
349: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
350: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
351: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);

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

344: WSH_DEBUG_SV.push(l_module_name);
345: --
346: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
347: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
348: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
349: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
350: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
351: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
352: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);

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

345: --
346: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
347: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
348: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
349: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
350: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
351: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
352: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
353: END IF;

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

346: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION',P_API_VERSION);
347: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
348: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
349: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
350: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
351: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
352: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
353: END IF;
354: --

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

347: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
348: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
349: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
350: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
351: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
352: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
353: END IF;
354: --
355:

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

348: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
349: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_LEVEL',P_VALIDATION_LEVEL);
350: WSH_DEBUG_SV.log(l_module_name,'P_FROM_DETAIL_ID',P_FROM_DETAIL_ID);
351: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY',X_SPLIT_QUANTITY);
352: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
353: END IF;
354: --
355:
356: IF NOT FND_API.compatible_api_call(l_api_version,

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

412: --MUOM : BUG : 16806520 : End of Changes
413:
414:
415: IF l_debug_on THEN
416: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
417: END IF;
418:
419: wsh_interface_grp.delivery_detail_action(
420: p_api_version_number => p_api_version,

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

427: p_action_prms => l_action_prms ,
428: x_action_out_rec => l_action_out_rec);
429:
430: IF l_debug_on THEN
431: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433: --
434: wsh_util_core.api_post_call(
435: p_return_status => l_return_status,

Line 463: WSH_DEBUG_SV.pop(l_module_name);

459: p_encoded => FND_API.G_FALSE
460: );
461:
462: IF l_debug_on THEN
463: WSH_DEBUG_SV.pop(l_module_name);
464: END IF;
465: --
466: exception
467: WHEN FND_API.G_EXC_ERROR THEN

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

475: p_encoded => FND_API.G_FALSE
476: );
477:
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
480: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
481: END IF;
482: --
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

476: );
477:
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
480: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
481: END IF;
482: --
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO SPLIT_LINE_PUB;

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

492: );
493: --
494:
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
498: END IF;
499: WHEN OTHERS THEN
500: ROLLBACK TO SPLIT_LINE_PUB;

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

493: --
494:
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
498: END IF;
499: WHEN OTHERS THEN
500: ROLLBACK TO SPLIT_LINE_PUB;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

508: p_encoded => FND_API.G_FALSE
509: );
510: --
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
514: END IF;
515: --
516: END split_line;

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

509: );
510: --
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
514: END IF;
515: --
516: END split_line;
517: --===================

Line 542: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

538: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
539: --
540: IF l_debug_on IS NULL
541: THEN
542: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
543: END IF;
544: --
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.push(l_module_name);

Line 546: WSH_DEBUG_SV.push(l_module_name);

542: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
543: END IF;
544: --
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.push(l_module_name);
547: END IF;
548: --
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
550: p_init_rec.source_header_id := FND_API.G_MISS_NUM;

Line 645: WSH_DEBUG_SV.pop(l_module_name);

641: --
642: -- Debug Statements
643: --
644: IF l_debug_on THEN
645: WSH_DEBUG_SV.pop(l_module_name);
646: END IF;
647: --
648: EXCEPTION
649: WHEN Others THEN

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

655: --
656: -- Debug Statements
657: --
658: IF l_debug_on THEN
659: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
660: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
661: END IF;
662: --
663: END Init_Changed_Attribute_Rec;

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

656: -- Debug Statements
657: --
658: IF l_debug_on THEN
659: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
660: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
661: END IF;
662: --
663: END Init_Changed_Attribute_Rec;
664:

Line 751: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

747: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
748: --
749: IF l_debug_on IS NULL
750: THEN
751: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
752: END IF;
753: --
754: SAVEPOINT UPDATE_SHIPPING_ATTR_PUB;
755:

Line 757: WSH_DEBUG_SV.push(l_module_name);

753: --
754: SAVEPOINT UPDATE_SHIPPING_ATTR_PUB;
755:
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.push(l_module_name);
758: --
759: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
760: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
761: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

755:
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.push(l_module_name);
758: --
759: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
760: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
761: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
762: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
763: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);

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

756: IF l_debug_on THEN
757: WSH_DEBUG_SV.push(l_module_name);
758: --
759: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
760: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
761: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
762: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
763: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
764: END IF;

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

757: WSH_DEBUG_SV.push(l_module_name);
758: --
759: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
760: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
761: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
762: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
763: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
764: END IF;
765: --

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

758: --
759: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
760: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
761: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
762: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
763: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
764: END IF;
765: --
766:

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

759: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
760: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
761: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
762: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
763: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
764: END IF;
765: --
766:
767: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 790: WSH_DEBUG_SV.log(l_module_name,'Invalid Source Code', p_source_code);

786: OPEN c_valid_source_code (p_source_code);
787: FETCH c_valid_source_code INTO l_source_code;
788: IF c_valid_source_code%NOTFOUND THEN
789: IF l_debug_on THEN
790: WSH_DEBUG_SV.log(l_module_name,'Invalid Source Code', p_source_code);
791: END IF;
792: CLOSE c_valid_source_code;
793: RAISE invalid_source_code;
794: END IF;

Line 814: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

810: l_index := l_detail_info_tab.NEXT(l_index);
811: END LOOP;
812: IF l_valid_index_tab.count >0 THEN
813: IF l_debug_on THEN
814: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
815: END IF;
816: wsh_delivery_details_pkg.Lock_Delivery_Details(
817: p_rec_attr_tab => l_detail_info_tab,
818: p_caller => l_In_rec.caller,

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

837: EXCEPTION
838: WHEN FND_API.G_EXC_ERROR THEN
839: ROLLBACK TO before_lock;
840: IF l_debug_on THEN
841: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
842: END IF;
843: RAISE FND_API.G_EXC_ERROR ;
844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
845: ROLLBACK TO before_lock;

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

843: RAISE FND_API.G_EXC_ERROR ;
844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
845: ROLLBACK TO before_lock;
846: IF l_debug_on THEN
847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
848: END IF;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: WHEN OTHERS THEN
851: ROLLBACK TO before_lock;

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

849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: WHEN OTHERS THEN
851: ROLLBACK TO before_lock;
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
854: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
855: END IF;
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END;

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

850: WHEN OTHERS THEN
851: ROLLBACK TO before_lock;
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
854: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
855: END IF;
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END;
858:

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

859: /* Patchset I: Harmonization Project. Call group API
860: All validations done by Group API */
861:
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: wsh_interface_grp.create_update_delivery_detail(
866: p_api_version_number => p_api_version_number,
867: p_init_msg_list => FND_API.G_FALSE,

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

873: p_IN_rec => l_in_rec,
874: x_OUT_rec => l_out_rec);
875:
876: IF l_debug_on THEN
877: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
878: END IF;
879: --
880: wsh_util_core.api_post_call(
881: p_return_status => l_return_status,

Line 904: WSH_DEBUG_SV.pop(l_module_name);

900: p_encoded => FND_API.G_FALSE
901: );
902:
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.pop(l_module_name);
905: END IF;
906: --
907: EXCEPTION
908: WHEN FND_API.G_EXC_ERROR THEN

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

916: p_encoded => FND_API.G_FALSE
917: );
918:
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
922: END IF;
923: --
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

917: );
918:
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
922: END IF;
923: --
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

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

933: );
934: --
935:
936: IF l_debug_on THEN
937: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
938: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
939: END IF;
940: --
941: WHEN invalid_source_code THEN

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

934: --
935:
936: IF l_debug_on THEN
937: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
938: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
939: END IF;
940: --
941: WHEN invalid_source_code THEN
942: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

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

956: p_encoded => FND_API.G_FALSE
957: );
958:
959: IF l_debug_on THEN
960: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
961: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
962: END IF;
963: --
964: WHEN Others THEN

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

957: );
958:
959: IF l_debug_on THEN
960: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
961: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
962: END IF;
963: --
964: WHEN Others THEN
965: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

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

975: p_encoded => FND_API.G_FALSE
976: );
977:
978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
981: END IF;
982: --
983: END Update_Shipping_Attributes;

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

976: );
977:
978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
981: END IF;
982: --
983: END Update_Shipping_Attributes;
984:

Line 1073: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1069: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1070: --
1071: IF l_debug_on IS NULL
1072: THEN
1073: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1074: END IF;
1075: --
1076: SAVEPOINT UPDATE_SHIPPING_ATTR_PUB2;
1077:

Line 1079: WSH_DEBUG_SV.push(l_module_name);

1075: --
1076: SAVEPOINT UPDATE_SHIPPING_ATTR_PUB2;
1077:
1078: IF l_debug_on THEN
1079: WSH_DEBUG_SV.push(l_module_name);
1080: --
1081: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1082: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1083: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

1077:
1078: IF l_debug_on THEN
1079: WSH_DEBUG_SV.push(l_module_name);
1080: --
1081: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1082: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1083: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1084: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1085: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);

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

1078: IF l_debug_on THEN
1079: WSH_DEBUG_SV.push(l_module_name);
1080: --
1081: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1082: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1083: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1084: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1085: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
1086: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);

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

1079: WSH_DEBUG_SV.push(l_module_name);
1080: --
1081: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1082: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1083: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1084: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1085: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
1086: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);
1087:

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

1080: --
1081: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1082: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1083: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1084: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1085: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
1086: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);
1087:
1088:

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

1081: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1082: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1083: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1084: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1085: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
1086: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);
1087:
1088:
1089: END IF;

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

1082: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1083: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1084: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1085: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
1086: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_RANGE_TAB.COUNT', P_SERIAL_RANGE_TAB.COUNT);
1087:
1088:
1089: END IF;
1090: --

Line 1115: WSH_DEBUG_SV.log(l_module_name,'Invalid Source Code', p_source_code);

1111: OPEN c_valid_source_code (p_source_code);
1112: FETCH c_valid_source_code INTO l_source_code;
1113: IF c_valid_source_code%NOTFOUND THEN
1114: IF l_debug_on THEN
1115: WSH_DEBUG_SV.log(l_module_name,'Invalid Source Code', p_source_code);
1116: END IF;
1117: CLOSE c_valid_source_code;
1118: RAISE invalid_source_code;
1119: END IF;

Line 1150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

1146: l_index := l_detail_info_tab.NEXT(l_index);
1147: END LOOP;
1148: IF l_valid_index_tab.count >0 THEN
1149: IF l_debug_on THEN
1150: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1151: END IF;
1152: wsh_delivery_details_pkg.Lock_Delivery_Details(
1153: p_rec_attr_tab => l_detail_info_tab,
1154: p_caller => l_In_rec.caller,

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

1173: EXCEPTION
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO before_lock;
1176: IF l_debug_on THEN
1177: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1178: END IF;
1179: RAISE FND_API.G_EXC_ERROR ;
1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1181: ROLLBACK TO before_lock;

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

1179: RAISE FND_API.G_EXC_ERROR ;
1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1181: ROLLBACK TO before_lock;
1182: IF l_debug_on THEN
1183: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1184: END IF;
1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1186: WHEN OTHERS THEN
1187: ROLLBACK TO before_lock;

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

1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1186: WHEN OTHERS THEN
1187: ROLLBACK TO before_lock;
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1191: END IF;
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END;

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

1186: WHEN OTHERS THEN
1187: ROLLBACK TO before_lock;
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1191: END IF;
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END;
1194:

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

1195: /* Patchset I: Harmonization Project. Call group API
1196: All validations done by Group API */
1197:
1198: IF l_debug_on THEN
1199: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1200: END IF;
1201:
1202: wsh_delivery_details_grp.create_update_delivery_detail(
1203: p_api_version_number => p_api_version_number,

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

1212: p_serial_range_tab => l_serial_range_tab
1213: );
1214:
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1217: END IF;
1218: --
1219: wsh_util_core.api_post_call(
1220: p_return_status => l_return_status,

Line 1242: WSH_DEBUG_SV.pop(l_module_name);

1238: p_encoded => FND_API.G_FALSE
1239: );
1240:
1241: IF l_debug_on THEN
1242: WSH_DEBUG_SV.pop(l_module_name);
1243: END IF;
1244: --
1245: EXCEPTION
1246: WHEN FND_API.G_EXC_ERROR THEN

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

1254: p_encoded => FND_API.G_FALSE
1255: );
1256:
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1259: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1260: END IF;
1261: --
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1255: );
1256:
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1259: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1260: END IF;
1261: --
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

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

1271: );
1272: --
1273:
1274: IF l_debug_on THEN
1275: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1277: END IF;
1278: --
1279: WHEN invalid_source_code THEN

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

1272: --
1273:
1274: IF l_debug_on THEN
1275: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1277: END IF;
1278: --
1279: WHEN invalid_source_code THEN
1280: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

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

1295: p_encoded => FND_API.G_FALSE
1296: );
1297:
1298: IF l_debug_on THEN
1299: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1300: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
1301: END IF;
1302: --
1303: WHEN Others THEN

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

1296: );
1297:
1298: IF l_debug_on THEN
1299: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1300: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_SOURCE_CODE');
1301: END IF;
1302: --
1303: WHEN Others THEN
1304: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

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

1313: p_data => x_msg_data,
1314: p_encoded => FND_API.G_FALSE
1315: );
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1318: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1319: END IF;
1320: --
1321: END Update_Shipping_Attributes;

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

1314: p_encoded => FND_API.G_FALSE
1315: );
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1318: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1319: END IF;
1320: --
1321: END Update_Shipping_Attributes;
1322:

Line 1358: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1354: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1355: --
1356: IF l_debug_on IS NULL
1357: THEN
1358: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1359: END IF;
1360: --
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.push(l_module_name);

Line 1362: WSH_DEBUG_SV.push(l_module_name);

1358: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1359: END IF;
1360: --
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.push(l_module_name);
1363: --
1364: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
1365: END IF;
1366: --

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

1360: --
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.push(l_module_name);
1363: --
1364: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
1365: END IF;
1366: --
1367: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1368:

Line 1405: WSH_DEBUG_SV.pop(l_module_name);

1401: --
1402: -- Debug Statements
1403: --
1404: IF l_debug_on THEN
1405: WSH_DEBUG_SV.pop(l_module_name);
1406: END IF;
1407: --
1408: END get_detail_status;
1409:

Line 1452: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1448: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1449: --
1450: IF l_debug_on IS NULL
1451: THEN
1452: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1453: END IF;
1454: --
1455: SAVEPOINT AUTOCREATE_DEL_PUB;
1456: --

Line 1458: WSH_DEBUG_SV.push(l_module_name);

1454: --
1455: SAVEPOINT AUTOCREATE_DEL_PUB;
1456: --
1457: IF l_debug_on THEN
1458: WSH_DEBUG_SV.push(l_module_name);
1459: --
1460: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1461: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1462: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

1456: --
1457: IF l_debug_on THEN
1458: WSH_DEBUG_SV.push(l_module_name);
1459: --
1460: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1461: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1462: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1463: END IF;
1464: --

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

1457: IF l_debug_on THEN
1458: WSH_DEBUG_SV.push(l_module_name);
1459: --
1460: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1461: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1462: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1463: END IF;
1464: --
1465:

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

1458: WSH_DEBUG_SV.push(l_module_name);
1459: --
1460: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1461: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1462: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1463: END IF;
1464: --
1465:
1466:

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

1484: /* Patchset I: Harmonization Project. Call group API
1485: All validations done by Group API */
1486:
1487: IF l_debug_on THEN
1488: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1489: END IF;
1490:
1491: wsh_interface_grp.delivery_detail_action(
1492: p_api_version_number => p_api_version_number,

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

1499: p_action_prms => l_action_prms ,
1500: x_action_out_rec => l_action_out_rec);
1501:
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1504: END IF;
1505: --
1506: wsh_util_core.api_post_call(
1507: p_return_status => l_return_status,

Line 1534: WSH_DEBUG_SV.pop(l_module_name);

1530: END IF;
1531:
1532:
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.pop(l_module_name);
1535: END IF;
1536: --
1537: EXCEPTION
1538: WHEN FND_API.G_EXC_ERROR THEN

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

1546: p_encoded => FND_API.G_FALSE
1547: );
1548:
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1552: END IF;
1553:
1554: WHEN autocreate_delivery_failed THEN

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

1547: );
1548:
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1552: END IF;
1553:
1554: WHEN autocreate_delivery_failed THEN
1555: ROLLBACK TO AUTOCREATE_DEL_PUB;

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

1561: p_encoded => FND_API.G_FALSE
1562: );
1563:
1564: IF l_debug_on THEN
1565: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1566: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');
1567: END IF;
1568:
1569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1562: );
1563:
1564: IF l_debug_on THEN
1565: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1566: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');
1567: END IF;
1568:
1569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1570: ROLLBACK TO AUTOCREATE_DEL_PUB;

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

1578: );
1579: --
1580:
1581: IF l_debug_on THEN
1582: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1584: END IF;
1585: WHEN OTHERS THEN
1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1579: --
1580:
1581: IF l_debug_on THEN
1582: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1584: END IF;
1585: WHEN OTHERS THEN
1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1587: ROLLBACK TO AUTOCREATE_DEL_PUB;

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

1594: p_encoded => FND_API.G_FALSE
1595: );
1596: --
1597: IF l_debug_on THEN
1598: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1600: END IF;
1601: --
1602: END Autocreate_Deliveries;

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

1595: );
1596: --
1597: IF l_debug_on THEN
1598: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1600: END IF;
1601: --
1602: END Autocreate_Deliveries;
1603:

Line 1631: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1627: --
1628: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1629: --
1630: IF l_debug_on IS NULL THEN
1631: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1632: END IF;
1633: --
1634: SAVEPOINT AUTOCREATE_TRIP_PUB;
1635: --

Line 1637: WSH_DEBUG_SV.push(l_module_name);

1633: --
1634: SAVEPOINT AUTOCREATE_TRIP_PUB;
1635: --
1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.push(l_module_name);
1638: END IF;
1639: --
1640:
1641:

Line 1643: 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);

1639: --
1640:
1641:
1642: IF l_debug_on THEN
1643: 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);
1644: END IF;
1645:
1646:
1647: WSH_DELIVERY_DETAILS_PUB.Autocreate_del_trip(

Line 1673: WSH_DEBUG_SV.pop(l_module_name);

1669: x_trip_name := NULL;
1670: END IF;
1671:
1672: IF l_debug_on THEN
1673: WSH_DEBUG_SV.pop(l_module_name);
1674: END IF;
1675:
1676: EXCEPTION
1677:

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

1689: p_encoded => FND_API.G_FALSE
1690: );
1691:
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1695: END IF;
1696:
1697: END Autocreate_del_trip;

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

1690: );
1691:
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1695: END IF;
1696:
1697: END Autocreate_del_trip;
1698:

Line 1743: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1739: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1740: --
1741: IF l_debug_on IS NULL
1742: THEN
1743: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1744: END IF;
1745: --
1746: SAVEPOINT AUTOCREATE_TRIP_PUB;
1747: --

Line 1749: WSH_DEBUG_SV.push(l_module_name);

1745: --
1746: SAVEPOINT AUTOCREATE_TRIP_PUB;
1747: --
1748: IF l_debug_on THEN
1749: WSH_DEBUG_SV.push(l_module_name);
1750: --
1751: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1752: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1753: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

1747: --
1748: IF l_debug_on THEN
1749: WSH_DEBUG_SV.push(l_module_name);
1750: --
1751: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1752: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1753: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1754: END IF;
1755: --

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

1748: IF l_debug_on THEN
1749: WSH_DEBUG_SV.push(l_module_name);
1750: --
1751: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1752: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1753: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1754: END IF;
1755: --
1756:

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

1749: WSH_DEBUG_SV.push(l_module_name);
1750: --
1751: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1752: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1753: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1754: END IF;
1755: --
1756:
1757: IF NOT FND_API.compatible_api_call(

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

1774: /* Patchset I: Harmonization Project. Call group API
1775: All validations done by Group API */
1776:
1777: IF l_debug_on THEN
1778: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1779: END IF;
1780:
1781: wsh_interface_grp.delivery_detail_action(
1782: p_api_version_number => p_api_version_number,

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

1789: p_action_prms => l_action_prms ,
1790: x_action_out_rec => l_action_out_rec);
1791:
1792: IF l_debug_on THEN
1793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1794: END IF;
1795: --
1796: wsh_util_core.api_post_call(
1797: p_return_status => l_return_status,

Line 1823: WSH_DEBUG_SV.pop(l_module_name);

1819: );
1820:
1821:
1822: IF l_debug_on THEN
1823: WSH_DEBUG_SV.pop(l_module_name);
1824: END IF;
1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN

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

1835: p_encoded => FND_API.G_FALSE
1836: );
1837:
1838: IF l_debug_on THEN
1839: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1840: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1841: END IF;
1842:
1843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1836: );
1837:
1838: IF l_debug_on THEN
1839: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1840: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1841: END IF;
1842:
1843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1844: ROLLBACK TO AUTOCREATE_TRIP_PUB;

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

1852: );
1853: --
1854:
1855: IF l_debug_on THEN
1856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1858: END IF;
1859:
1860:

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

1853: --
1854:
1855: IF l_debug_on THEN
1856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1858: END IF;
1859:
1860:
1861: WHEN autocreate_trip_failed THEN

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

1868: p_encoded => FND_API.G_FALSE
1869: );
1870:
1871: IF l_debug_on THEN
1872: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_TRIP_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_TRIP_FAILED');
1874: END IF;
1875:
1876: WHEN OTHERS THEN

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

1869: );
1870:
1871: IF l_debug_on THEN
1872: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_TRIP_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_TRIP_FAILED');
1874: END IF;
1875:
1876: WHEN OTHERS THEN
1877:

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

1886: p_encoded => FND_API.G_FALSE
1887: );
1888: --
1889: IF l_debug_on THEN
1890: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1892: END IF;
1893: --
1894: END Autocreate_del_trip;

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

1887: );
1888: --
1889: IF l_debug_on THEN
1890: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1892: END IF;
1893: --
1894: END Autocreate_del_trip;
1895:

Line 1913: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1909: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1910: --
1911: IF l_debug_on IS NULL
1912: THEN
1913: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1914: END IF;
1915: --
1916: IF l_debug_on THEN
1917:

Line 1918: WSH_DEBUG_SV.push(l_module_name);

1914: END IF;
1915: --
1916: IF l_debug_on THEN
1917:
1918: WSH_DEBUG_SV.push(l_module_name);
1919: WSH_DEBUG_SV.log(l_module_name,'X_CHANGED_ATTRIBUTES.COUNT', X_CHANGED_ATTRIBUTES.COUNT);
1920:
1921: END IF;
1922:

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

1915: --
1916: IF l_debug_on THEN
1917:
1918: WSH_DEBUG_SV.push(l_module_name);
1919: WSH_DEBUG_SV.log(l_module_name,'X_CHANGED_ATTRIBUTES.COUNT', X_CHANGED_ATTRIBUTES.COUNT);
1920:
1921: END IF;
1922:
1923: l_index := x_changed_attributes.FIRST;

Line 2111: WSH_DEBUG_SV.pop(l_module_name);

2107: l_index := x_changed_attributes.NEXT(l_index);
2108: END LOOP;
2109:
2110: IF l_debug_on THEN
2111: WSH_DEBUG_SV.pop(l_module_name);
2112: END IF;
2113:
2114: EXCEPTION
2115:

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

2115:
2116: WHEN FND_API.G_EXC_ERROR THEN
2117:
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2121: END IF;
2122: raise;
2123:

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

2116: WHEN FND_API.G_EXC_ERROR THEN
2117:
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2121: END IF;
2122: raise;
2123:
2124:

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

2125: WHEN OTHERS THEN
2126:
2127: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');
2128: IF l_debug_on THEN
2129: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2130: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2131: END IF;
2132: raise;
2133:

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

2126:
2127: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');
2128: IF l_debug_on THEN
2129: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2130: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2131: END IF;
2132: raise;
2133:
2134: END Copy_Attributes;