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

Line 44: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

40: --
41: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
42: --
43: IF l_debug_on IS NULL THEN
44: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
45: END IF;
46: --
47: IF l_debug_on THEN
48: wsh_debug_sv.push(l_module_name);

Line 48: wsh_debug_sv.push(l_module_name);

44: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
45: END IF;
46: --
47: IF l_debug_on THEN
48: wsh_debug_sv.push(l_module_name);
49: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
50: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
51: wsh_debug_sv.log(l_module_name, 'actid',actid);
52: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 49: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

45: END IF;
46: --
47: IF l_debug_on THEN
48: wsh_debug_sv.push(l_module_name);
49: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
50: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
51: wsh_debug_sv.log(l_module_name, 'actid',actid);
52: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
53: END IF;

Line 50: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

46: --
47: IF l_debug_on THEN
48: wsh_debug_sv.push(l_module_name);
49: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
50: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
51: wsh_debug_sv.log(l_module_name, 'actid',actid);
52: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
53: END IF;
54:

Line 51: wsh_debug_sv.log(l_module_name, 'actid',actid);

47: IF l_debug_on THEN
48: wsh_debug_sv.push(l_module_name);
49: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
50: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
51: wsh_debug_sv.log(l_module_name, 'actid',actid);
52: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
53: END IF;
54:
55: -- RUN mode - normal process execution

Line 52: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

48: wsh_debug_sv.push(l_module_name);
49: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
50: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
51: wsh_debug_sv.log(l_module_name, 'actid',actid);
52: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
53: END IF;
54:
55: -- RUN mode - normal process execution
56: IF (funcmode = 'RUN') THEN

Line 77: WSH_DEBUG_SV.pop(l_module_name);

73: aname => 'NOTIFICATION_TO_ROLE',
74: avalue => FND_GLOBAL.USER_NAME);
75:
76: IF l_debug_on THEN
77: WSH_DEBUG_SV.pop(l_module_name);
78: END IF;
79: RETURN;
80: END IF;
81:

Line 86: WSH_DEBUG_SV.pop(l_module_name);

82: IF (funcmode = 'CANCEL') THEN
83: NULL;
84: resultout := 'COMPLETE';
85: IF l_debug_on THEN
86: WSH_DEBUG_SV.pop(l_module_name);
87: END IF;
88: RETURN;
89: END IF;
90:

Line 94: WSH_DEBUG_SV.pop(l_module_name);

90:
91: -- Other execution modes
92: resultout := '';
93: IF l_debug_on THEN
94: WSH_DEBUG_SV.pop(l_module_name);
95: END IF;
96: RETURN;
97: EXCEPTION
98:

Line 102: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||

98:
99: WHEN NO_DATA_FOUND THEN
100: resultout := 'COMPLETE';
101: IF l_debug_on THEN
102: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
103: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
104: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
105: END IF;
106: wf_core.context('WSH_WF_INTERFACE',

Line 103: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

99: WHEN NO_DATA_FOUND THEN
100: resultout := 'COMPLETE';
101: IF l_debug_on THEN
102: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
103: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
104: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
105: END IF;
106: wf_core.context('WSH_WF_INTERFACE',
107: 'SCPOD_SHIPPING_STATUS',

Line 104: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

100: resultout := 'COMPLETE';
101: IF l_debug_on THEN
102: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
103: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
104: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
105: END IF;
106: wf_core.context('WSH_WF_INTERFACE',
107: 'SCPOD_SHIPPING_STATUS',
108: itemtype,

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

112: RAISE;
113: WHEN OTHERS THEN
114: resultout := 'COMPLETE';
115: IF l_debug_on THEN
116: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
117: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
118: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
119: END IF;
120: wf_core.context('WSH_WF_INTERFACE',

Line 117: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

113: WHEN OTHERS THEN
114: resultout := 'COMPLETE';
115: IF l_debug_on THEN
116: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
117: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
118: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
119: END IF;
120: wf_core.context('WSH_WF_INTERFACE',
121: 'SCPOD_SHIPPING_STATUS',

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

114: resultout := 'COMPLETE';
115: IF l_debug_on THEN
116: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
117: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
118: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
119: END IF;
120: wf_core.context('WSH_WF_INTERFACE',
121: 'SCPOD_SHIPPING_STATUS',
122: itemtype,

Line 180: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

176: --
177: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
178: --
179: IF l_debug_on IS NULL THEN
180: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
181: END IF;
182: --
183: IF l_debug_on THEN
184: wsh_debug_sv.push(l_module_name);

Line 184: wsh_debug_sv.push(l_module_name);

180: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
181: END IF;
182: --
183: IF l_debug_on THEN
184: wsh_debug_sv.push(l_module_name);
185: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
186: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
187: wsh_debug_sv.log(l_module_name, 'actid',actid);
188: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 185: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

181: END IF;
182: --
183: IF l_debug_on THEN
184: wsh_debug_sv.push(l_module_name);
185: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
186: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
187: wsh_debug_sv.log(l_module_name, 'actid',actid);
188: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
189: END IF;

Line 186: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

182: --
183: IF l_debug_on THEN
184: wsh_debug_sv.push(l_module_name);
185: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
186: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
187: wsh_debug_sv.log(l_module_name, 'actid',actid);
188: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
189: END IF;
190:

Line 187: wsh_debug_sv.log(l_module_name, 'actid',actid);

183: IF l_debug_on THEN
184: wsh_debug_sv.push(l_module_name);
185: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
186: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
187: wsh_debug_sv.log(l_module_name, 'actid',actid);
188: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
189: END IF;
190:
191: IF (funcmode = 'RUN') THEN

Line 188: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

184: wsh_debug_sv.push(l_module_name);
185: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
186: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
187: wsh_debug_sv.log(l_module_name, 'actid',actid);
188: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
189: END IF;
190:
191: IF (funcmode = 'RUN') THEN
192:

Line 219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.STOP_ACTION ',

215: SET del_wf_intransit_attr = 'P'
216: WHERE delivery_id = l_delivery_id;
217:
218: IF l_debug_on THEN
219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.STOP_ACTION ',
220: WSH_DEBUG_SV.C_PROC_LEVEL);
221: END IF;
222:
223: WSH_TRIP_STOPS_GRP.Stop_Action (

Line 220: WSH_DEBUG_SV.C_PROC_LEVEL);

216: WHERE delivery_id = l_delivery_id;
217:
218: IF l_debug_on THEN
219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.STOP_ACTION ',
220: WSH_DEBUG_SV.C_PROC_LEVEL);
221: END IF;
222:
223: WSH_TRIP_STOPS_GRP.Stop_Action (
224: p_api_version_number => 1.0,

Line 237: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

233: x_msg_data => l_msg_data
234: );
235:
236: IF l_debug_on THEN
237: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
238: END IF;
239:
240: IF (l_return_status <> wsh_util_core.g_ret_sts_error
241: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN

Line 262: WSH_DEBUG_SV.pop(l_module_name);

258: aname => 'SCPOD_INTRANSIT_MSG',
259: avalue => l_msg_data);
260:
261: IF l_debug_on THEN
262: WSH_DEBUG_SV.pop(l_module_name);
263: END IF;
264: RETURN;
265: END IF;
266:

Line 271: WSH_DEBUG_SV.pop(l_module_name);

267: IF (funcmode = 'CANCEL') THEN
268: NULL;
269: resultout := 'COMPLETE';
270: IF l_debug_on THEN
271: WSH_DEBUG_SV.pop(l_module_name);
272: END IF;
273: RETURN;
274: END IF;
275:

Line 278: WSH_DEBUG_SV.pop(l_module_name);

274: END IF;
275:
276: -- Other execution modes
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.pop(l_module_name);
279: END IF;
280: resultout := '';
281: RETURN;
282: EXCEPTION

Line 287: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||

283:
284: WHEN NO_DATA_FOUND THEN
285: resultout := 'COMPLETE:FAILURE';
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
288: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
290: END IF;
291: wf_core.context('WSH_WF_INTERFACE',

Line 288: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

284: WHEN NO_DATA_FOUND THEN
285: resultout := 'COMPLETE:FAILURE';
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
288: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
290: END IF;
291: wf_core.context('WSH_WF_INTERFACE',
292: 'SCPOD_C_MARK_INTRANSIT',

Line 289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

285: resultout := 'COMPLETE:FAILURE';
286: IF l_debug_on THEN
287: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
288: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
290: END IF;
291: wf_core.context('WSH_WF_INTERFACE',
292: 'SCPOD_C_MARK_INTRANSIT',
293: itemtype,

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

297: RAISE;
298: WHEN OTHERS THEN
299: resultout := 'COMPLETE:FAILURE';
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
302: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
303: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
304: END IF;
305: wf_core.context('WSH_WF_INTERFACE',

Line 302: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

298: WHEN OTHERS THEN
299: resultout := 'COMPLETE:FAILURE';
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
302: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
303: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
304: END IF;
305: wf_core.context('WSH_WF_INTERFACE',
306: 'SCPOD_C_MARK_INTRANSIT',

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

299: resultout := 'COMPLETE:FAILURE';
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
302: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
303: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
304: END IF;
305: wf_core.context('WSH_WF_INTERFACE',
306: 'SCPOD_C_MARK_INTRANSIT',
307: itemtype,

Line 358: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

354: --
355: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
356: --
357: IF l_debug_on IS NULL THEN
358: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
359: END IF;
360: --
361: IF l_debug_on THEN
362: wsh_debug_sv.push(l_module_name);

Line 362: wsh_debug_sv.push(l_module_name);

358: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
359: END IF;
360: --
361: IF l_debug_on THEN
362: wsh_debug_sv.push(l_module_name);
363: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
364: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
365: wsh_debug_sv.log(l_module_name, 'actid',actid);
366: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 363: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

359: END IF;
360: --
361: IF l_debug_on THEN
362: wsh_debug_sv.push(l_module_name);
363: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
364: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
365: wsh_debug_sv.log(l_module_name, 'actid',actid);
366: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
367: END IF;

Line 364: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

360: --
361: IF l_debug_on THEN
362: wsh_debug_sv.push(l_module_name);
363: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
364: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
365: wsh_debug_sv.log(l_module_name, 'actid',actid);
366: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
367: END IF;
368:

Line 365: wsh_debug_sv.log(l_module_name, 'actid',actid);

361: IF l_debug_on THEN
362: wsh_debug_sv.push(l_module_name);
363: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
364: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
365: wsh_debug_sv.log(l_module_name, 'actid',actid);
366: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
367: END IF;
368:
369: -- RUN mode - normal process execution

Line 366: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

362: wsh_debug_sv.push(l_module_name);
363: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
364: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
365: wsh_debug_sv.log(l_module_name, 'actid',actid);
366: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
367: END IF;
368:
369: -- RUN mode - normal process execution
370: IF (funcmode = 'RUN') THEN

Line 444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.DELIVERY_ACTION',

440: SET del_wf_close_attr = 'P'
441: WHERE delivery_id = l_delivery_id;
442:
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.DELIVERY_ACTION',
445: WSH_DEBUG_SV.C_PROC_LEVEL);
446: END IF;
447:
448: wsh_deliveries_grp.delivery_action(

Line 445: WSH_DEBUG_SV.C_PROC_LEVEL);

441: WHERE delivery_id = l_delivery_id;
442:
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.DELIVERY_ACTION',
445: WSH_DEBUG_SV.C_PROC_LEVEL);
446: END IF;
447:
448: wsh_deliveries_grp.delivery_action(
449: p_api_version_number => 1.0,

Line 461: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

457: x_msg_count => l_msg_count,
458: x_msg_data => l_msg_data);
459:
460: IF l_debug_on THEN
461: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
462: END IF;
463:
464:
465:

Line 488: WSH_DEBUG_SV.pop(l_module_name);

484: aname => 'SCPOD_DEL_CLOSE_MSG',
485: avalue => l_msg_data);
486:
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.pop(l_module_name);
489: END IF;
490: RETURN;
491: END IF;
492:

Line 496: WSH_DEBUG_SV.pop(l_module_name);

492:
493: IF (funcmode = 'CANCEL') THEN
494: resultout := 'COMPLETE';
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.pop(l_module_name);
497: END IF;
498: RETURN;
499: END IF;
500:

Line 503: WSH_DEBUG_SV.pop(l_module_name);

499: END IF;
500:
501: -- Other execution modes
502: IF l_debug_on THEN
503: WSH_DEBUG_SV.pop(l_module_name);
504: END IF;
505: resultout := '';
506: RETURN;
507:

Line 512: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||

508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN
510: resultout := 'COMPLETE:FAILURE';
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
513: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
514: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
515: END IF;
516: wf_core.context('WSH_WF_INTERFACE',

Line 513: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

509: WHEN NO_DATA_FOUND THEN
510: resultout := 'COMPLETE:FAILURE';
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
513: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
514: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
515: END IF;
516: wf_core.context('WSH_WF_INTERFACE',
517: 'SCPOD_C_CLOSE_TRIP',

Line 514: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

510: resultout := 'COMPLETE:FAILURE';
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
513: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
514: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
515: END IF;
516: wf_core.context('WSH_WF_INTERFACE',
517: 'SCPOD_C_CLOSE_TRIP',
518: itemtype,

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

522: RAISE;
523: WHEN OTHERS THEN
524: resultout := 'COMPLETE:FAILURE';
525: IF l_debug_on THEN
526: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
527: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
529: END IF;
530: wf_core.context('WSH_WF_INTERFACE',

Line 527: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

523: WHEN OTHERS THEN
524: resultout := 'COMPLETE:FAILURE';
525: IF l_debug_on THEN
526: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
527: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
529: END IF;
530: wf_core.context('WSH_WF_INTERFACE',
531: 'SCPOD_C_CLOSE_TRIP',

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

524: resultout := 'COMPLETE:FAILURE';
525: IF l_debug_on THEN
526: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
527: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
528: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
529: END IF;
530: wf_core.context('WSH_WF_INTERFACE',
531: 'SCPOD_C_CLOSE_TRIP',
532: itemtype,

Line 564: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

560: --
561: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
562: --
563: IF l_debug_on IS NULL THEN
564: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
565: END IF;
566: --
567: IF l_debug_on THEN
568: wsh_debug_sv.push(l_module_name);

Line 568: wsh_debug_sv.push(l_module_name);

564: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
565: END IF;
566: --
567: IF l_debug_on THEN
568: wsh_debug_sv.push(l_module_name);
569: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
570: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
571: wsh_debug_sv.log(l_module_name, 'actid',actid);
572: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 569: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

565: END IF;
566: --
567: IF l_debug_on THEN
568: wsh_debug_sv.push(l_module_name);
569: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
570: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
571: wsh_debug_sv.log(l_module_name, 'actid',actid);
572: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
573: END IF;

Line 570: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

566: --
567: IF l_debug_on THEN
568: wsh_debug_sv.push(l_module_name);
569: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
570: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
571: wsh_debug_sv.log(l_module_name, 'actid',actid);
572: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
573: END IF;
574:

Line 571: wsh_debug_sv.log(l_module_name, 'actid',actid);

567: IF l_debug_on THEN
568: wsh_debug_sv.push(l_module_name);
569: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
570: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
571: wsh_debug_sv.log(l_module_name, 'actid',actid);
572: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
573: END IF;
574:
575: -- RUN mode - normal process execution

Line 572: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

568: wsh_debug_sv.push(l_module_name);
569: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
570: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
571: wsh_debug_sv.log(l_module_name, 'actid',actid);
572: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
573: END IF;
574:
575: -- RUN mode - normal process execution
576: IF (funcmode = 'RUN') THEN

Line 589: WSH_DEBUG_SV.log(l_module_name,'Request Id L_REQUEST_ID',l_request_id);

585: '', -- stop
586: l_delivery_id, -- delivery
587: l_log_level); -- log level
588: IF l_debug_on THEN
589: WSH_DEBUG_SV.log(l_module_name,'Request Id L_REQUEST_ID',l_request_id);
590: END IF;
591:
592: IF (l_request_id = 0) THEN
593: UPDATE WSH_NEW_DELIVERIES

Line 618: WSH_DEBUG_SV.pop(l_module_name);

614: aname => 'SCPOD_INTERFACE_MSG',
615: avalue => l_msg_buffer);
616:
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.pop(l_module_name);
619: END IF;
620: RETURN;
621:
622: END IF;

Line 628: WSH_DEBUG_SV.pop(l_module_name);

624: IF (funcmode = 'CANCEL') THEN
625: NULL;
626: resultout := 'COMPLETE';
627: IF l_debug_on THEN
628: WSH_DEBUG_SV.pop(l_module_name);
629: END IF;
630: RETURN;
631: END IF;
632:

Line 635: WSH_DEBUG_SV.pop(l_module_name);

631: END IF;
632:
633: -- Other execution modes
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.pop(l_module_name);
636: END IF;
637: resultout := '';
638: RETURN;
639: EXCEPTION

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

639: EXCEPTION
640: WHEN OTHERS THEN
641: resultout := 'COMPLETE:FAILURE';
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
644: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
646: END IF;
647: wf_core.context('WSH_WF_INTERFACE',

Line 644: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

640: WHEN OTHERS THEN
641: resultout := 'COMPLETE:FAILURE';
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
644: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
646: END IF;
647: wf_core.context('WSH_WF_INTERFACE',
648: 'SCPOD_C_RUN_INTERFACE',

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

641: resultout := 'COMPLETE:FAILURE';
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
644: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
646: END IF;
647: wf_core.context('WSH_WF_INTERFACE',
648: 'SCPOD_C_RUN_INTERFACE',
649: itemtype,

Line 683: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

679: --
680: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
681: --
682: IF l_debug_on IS NULL THEN
683: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
684: END IF;
685: --
686: IF l_debug_on THEN
687: wsh_debug_sv.push(l_module_name);

Line 687: wsh_debug_sv.push(l_module_name);

683: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
684: END IF;
685: --
686: IF l_debug_on THEN
687: wsh_debug_sv.push(l_module_name);
688: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
689: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
690: wsh_debug_sv.log(l_module_name, 'actid',actid);
691: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 688: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

684: END IF;
685: --
686: IF l_debug_on THEN
687: wsh_debug_sv.push(l_module_name);
688: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
689: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
690: wsh_debug_sv.log(l_module_name, 'actid',actid);
691: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
692: END IF;

Line 689: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

685: --
686: IF l_debug_on THEN
687: wsh_debug_sv.push(l_module_name);
688: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
689: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
690: wsh_debug_sv.log(l_module_name, 'actid',actid);
691: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
692: END IF;
693:

Line 690: wsh_debug_sv.log(l_module_name, 'actid',actid);

686: IF l_debug_on THEN
687: wsh_debug_sv.push(l_module_name);
688: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
689: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
690: wsh_debug_sv.log(l_module_name, 'actid',actid);
691: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
692: END IF;
693:
694: -- RUN mode - normal process execution

Line 691: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

687: wsh_debug_sv.push(l_module_name);
688: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
689: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
690: wsh_debug_sv.log(l_module_name, 'actid',actid);
691: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
692: END IF;
693:
694: -- RUN mode - normal process execution
695: IF (funcmode = 'RUN') THEN

Line 703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_SETS.PRINT_DOCUMENT_SETS',

699: l_report_set_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,'REPORT_SET_ID',FALSE);
700:
701: IF (l_report_set_id is not null) THEN
702: IF l_debug_on THEN
703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_SETS.PRINT_DOCUMENT_SETS',
704: WSH_DEBUG_SV.C_PROC_LEVEL);
705: END IF;
706:
707: wsh_document_sets.print_document_sets(

Line 704: WSH_DEBUG_SV.C_PROC_LEVEL);

700:
701: IF (l_report_set_id is not null) THEN
702: IF l_debug_on THEN
703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DOCUMENT_SETS.PRINT_DOCUMENT_SETS',
704: WSH_DEBUG_SV.C_PROC_LEVEL);
705: END IF;
706:
707: wsh_document_sets.print_document_sets(
708: p_report_set_id => l_report_set_id ,

Line 717: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

713: p_document_param_info=> l_dummy_doc_set,
714: x_return_status => l_return_status);
715:
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
718: END IF;
719:
720: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
721: raise e_print_doc_failed;

Line 727: WSH_DEBUG_SV.pop(l_module_name);

723: resultout := 'COMPLETE';
724: END IF;
725: END IF;
726: IF l_debug_on THEN
727: WSH_DEBUG_SV.pop(l_module_name);
728: END IF;
729: RETURN;
730:
731: END IF;

Line 737: WSH_DEBUG_SV.pop(l_module_name);

733: IF (funcmode = 'CANCEL') THEN
734: NULL;
735: resultout := 'COMPLETE';
736: IF l_debug_on THEN
737: WSH_DEBUG_SV.pop(l_module_name);
738: END IF;
739: RETURN;
740: END IF;
741:

Line 744: WSH_DEBUG_SV.pop(l_module_name);

740: END IF;
741:
742: -- Other execution modes
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.pop(l_module_name);
745: END IF;
746: resultout := '';
747: RETURN;
748: EXCEPTION

Line 752: WSH_DEBUG_SV.logmsg(l_module_name,'Print Document Sets failed.Oracle error message is '||

748: EXCEPTION
749: WHEN e_print_doc_failed THEN
750: resultout := 'COMPLETE';
751: IF l_debug_on THEN
752: WSH_DEBUG_SV.logmsg(l_module_name,'Print Document Sets failed.Oracle error message is '||
753: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
754: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PRINT_DOC_FAILED');
755: END IF;
756: wf_core.context('WSH_WF_INTERFACE',

Line 753: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

749: WHEN e_print_doc_failed THEN
750: resultout := 'COMPLETE';
751: IF l_debug_on THEN
752: WSH_DEBUG_SV.logmsg(l_module_name,'Print Document Sets failed.Oracle error message is '||
753: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
754: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PRINT_DOC_FAILED');
755: END IF;
756: wf_core.context('WSH_WF_INTERFACE',
757: 'SCPOD_C_PRINT_DOCSET',

Line 754: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PRINT_DOC_FAILED');

750: resultout := 'COMPLETE';
751: IF l_debug_on THEN
752: WSH_DEBUG_SV.logmsg(l_module_name,'Print Document Sets failed.Oracle error message is '||
753: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
754: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PRINT_DOC_FAILED');
755: END IF;
756: wf_core.context('WSH_WF_INTERFACE',
757: 'SCPOD_C_PRINT_DOCSET',
758: itemtype,

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

762: RAISE;
763: WHEN OTHERS THEN
764: resultout := 'COMPLETE';
765: IF l_debug_on THEN
766: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
767: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
768: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
769: END IF;
770: wf_core.context('WSH_WF_INTERFACE',

Line 767: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

763: WHEN OTHERS THEN
764: resultout := 'COMPLETE';
765: IF l_debug_on THEN
766: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
767: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
768: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
769: END IF;
770: wf_core.context('WSH_WF_INTERFACE',
771: 'SCPOD_C_PRINT_DOCSET',

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

764: resultout := 'COMPLETE';
765: IF l_debug_on THEN
766: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
767: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
768: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
769: END IF;
770: wf_core.context('WSH_WF_INTERFACE',
771: 'SCPOD_C_PRINT_DOCSET',
772: itemtype,

Line 799: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

795: --
796: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
797: --
798: IF l_debug_on IS NULL THEN
799: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
800: END IF;
801: --
802: IF l_debug_on THEN
803: wsh_debug_sv.push(l_module_name);

Line 803: wsh_debug_sv.push(l_module_name);

799: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
800: END IF;
801: --
802: IF l_debug_on THEN
803: wsh_debug_sv.push(l_module_name);
804: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
805: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
806: wsh_debug_sv.log(l_module_name, 'actid',actid);
807: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 804: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

800: END IF;
801: --
802: IF l_debug_on THEN
803: wsh_debug_sv.push(l_module_name);
804: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
805: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
806: wsh_debug_sv.log(l_module_name, 'actid',actid);
807: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
808: END IF;

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

801: --
802: IF l_debug_on THEN
803: wsh_debug_sv.push(l_module_name);
804: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
805: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
806: wsh_debug_sv.log(l_module_name, 'actid',actid);
807: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
808: END IF;
809:

Line 806: wsh_debug_sv.log(l_module_name, 'actid',actid);

802: IF l_debug_on THEN
803: wsh_debug_sv.push(l_module_name);
804: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
805: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
806: wsh_debug_sv.log(l_module_name, 'actid',actid);
807: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
808: END IF;
809:
810: -- RUN mode - normal process execution

Line 807: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

803: wsh_debug_sv.push(l_module_name);
804: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
805: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
806: wsh_debug_sv.log(l_module_name, 'actid',actid);
807: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
808: END IF;
809:
810: -- RUN mode - normal process execution
811: IF (funcmode = 'RUN') THEN

Line 819: WSH_DEBUG_SV.pop(l_module_name);

815: ELSE
816: resultout := 'COMPLETE:N';
817: END IF;
818: IF l_debug_on THEN
819: WSH_DEBUG_SV.pop(l_module_name);
820: END IF;
821: RETURN;
822: END IF;
823:

Line 828: WSH_DEBUG_SV.pop(l_module_name);

824: IF (funcmode = 'CANCEL') THEN
825: NULL;
826: resultout := 'COMPLETE';
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.pop(l_module_name);
829: END IF;
830: RETURN;
831: END IF;
832:

Line 835: WSH_DEBUG_SV.pop(l_module_name);

831: END IF;
832:
833: -- Other execution modes
834: IF l_debug_on THEN
835: WSH_DEBUG_SV.pop(l_module_name);
836: END IF;
837: resultout := '';
838: RETURN;
839: EXCEPTION

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

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

Line 844: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

840: WHEN OTHERS THEN
841: resultout := 'COMPLETE';
842: IF l_debug_on THEN
843: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
844: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
845: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
846: END IF;
847: wf_core.context('WSH_WF_INTERFACE',
848: 'SCPOD_C_INTRANSIT_CK',

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

841: resultout := 'COMPLETE';
842: IF l_debug_on THEN
843: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
844: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
845: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
846: END IF;
847: wf_core.context('WSH_WF_INTERFACE',
848: 'SCPOD_C_INTRANSIT_CK',
849: itemtype,

Line 875: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

871: --
872: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
873: --
874: IF l_debug_on IS NULL THEN
875: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
876: END IF;
877: --
878: IF l_debug_on THEN
879: wsh_debug_sv.push(l_module_name);

Line 879: wsh_debug_sv.push(l_module_name);

875: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
876: END IF;
877: --
878: IF l_debug_on THEN
879: wsh_debug_sv.push(l_module_name);
880: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
881: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
882: wsh_debug_sv.log(l_module_name, 'actid',actid);
883: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 880: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

876: END IF;
877: --
878: IF l_debug_on THEN
879: wsh_debug_sv.push(l_module_name);
880: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
881: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
882: wsh_debug_sv.log(l_module_name, 'actid',actid);
883: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
884: END IF;

Line 881: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

877: --
878: IF l_debug_on THEN
879: wsh_debug_sv.push(l_module_name);
880: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
881: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
882: wsh_debug_sv.log(l_module_name, 'actid',actid);
883: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
884: END IF;
885:

Line 882: wsh_debug_sv.log(l_module_name, 'actid',actid);

878: IF l_debug_on THEN
879: wsh_debug_sv.push(l_module_name);
880: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
881: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
882: wsh_debug_sv.log(l_module_name, 'actid',actid);
883: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
884: END IF;
885:
886: -- RUN mode - normal process execution

Line 883: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

879: wsh_debug_sv.push(l_module_name);
880: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
881: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
882: wsh_debug_sv.log(l_module_name, 'actid',actid);
883: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
884: END IF;
885:
886: -- RUN mode - normal process execution
887: IF (funcmode = 'RUN') THEN

Line 895: WSH_DEBUG_SV.pop(l_module_name);

891: ELSE
892: resultout := 'COMPLETE:N';
893: END IF;
894: IF l_debug_on THEN
895: WSH_DEBUG_SV.pop(l_module_name);
896: END IF;
897: RETURN;
898: END IF;
899:

Line 904: WSH_DEBUG_SV.pop(l_module_name);

900: IF (funcmode = 'CANCEL') THEN
901: NULL;
902: resultout := 'COMPLETE';
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.pop(l_module_name);
905: END IF;
906: RETURN;
907: END IF;
908:

Line 911: WSH_DEBUG_SV.pop(l_module_name);

907: END IF;
908:
909: -- Other execution modes
910: IF l_debug_on THEN
911: WSH_DEBUG_SV.pop(l_module_name);
912: END IF;
913: resultout := '';
914: RETURN;
915:

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

916: EXCEPTION
917: WHEN OTHERS THEN
918: resultout := 'COMPLETE';
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
921: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
923: END IF;
924: wf_core.context('WSH_WF_INTERFACE',

Line 921: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

917: WHEN OTHERS THEN
918: resultout := 'COMPLETE';
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
921: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
923: END IF;
924: wf_core.context('WSH_WF_INTERFACE',
925: 'SCPOD_C_INTERFACE_CK',

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

918: resultout := 'COMPLETE';
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
921: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
923: END IF;
924: wf_core.context('WSH_WF_INTERFACE',
925: 'SCPOD_C_INTERFACE_CK',
926: itemtype,

Line 952: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

948: --
949: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
950: --
951: IF l_debug_on IS NULL THEN
952: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
953: END IF;
954: --
955: IF l_debug_on THEN
956: wsh_debug_sv.push(l_module_name);

Line 956: wsh_debug_sv.push(l_module_name);

952: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
953: END IF;
954: --
955: IF l_debug_on THEN
956: wsh_debug_sv.push(l_module_name);
957: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
958: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
959: wsh_debug_sv.log(l_module_name, 'actid',actid);
960: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 957: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

953: END IF;
954: --
955: IF l_debug_on THEN
956: wsh_debug_sv.push(l_module_name);
957: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
958: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
959: wsh_debug_sv.log(l_module_name, 'actid',actid);
960: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
961: END IF;

Line 958: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

954: --
955: IF l_debug_on THEN
956: wsh_debug_sv.push(l_module_name);
957: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
958: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
959: wsh_debug_sv.log(l_module_name, 'actid',actid);
960: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
961: END IF;
962:

Line 959: wsh_debug_sv.log(l_module_name, 'actid',actid);

955: IF l_debug_on THEN
956: wsh_debug_sv.push(l_module_name);
957: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
958: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
959: wsh_debug_sv.log(l_module_name, 'actid',actid);
960: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
961: END IF;
962:
963: -- RUN mode - normal process execution

Line 960: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

956: wsh_debug_sv.push(l_module_name);
957: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
958: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
959: wsh_debug_sv.log(l_module_name, 'actid',actid);
960: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
961: END IF;
962:
963: -- RUN mode - normal process execution
964: IF (funcmode = 'RUN') THEN

Line 972: WSH_DEBUG_SV.pop(l_module_name);

968: ELSE
969: resultout := 'COMPLETE:N';
970: END IF;
971: IF l_debug_on THEN
972: WSH_DEBUG_SV.pop(l_module_name);
973: END IF;
974: RETURN;
975: END IF;
976:

Line 981: WSH_DEBUG_SV.pop(l_module_name);

977: IF (funcmode = 'CANCEL') THEN
978: NULL;
979: resultout := 'COMPLETE';
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.pop(l_module_name);
982: END IF;
983: RETURN;
984: END IF;
985:

Line 988: WSH_DEBUG_SV.pop(l_module_name);

984: END IF;
985:
986: -- Other execution modes
987: IF l_debug_on THEN
988: WSH_DEBUG_SV.pop(l_module_name);
989: END IF;
990: resultout := '';
991: RETURN;
992: EXCEPTION

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

992: EXCEPTION
993: WHEN OTHERS THEN
994: resultout := 'COMPLETE';
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
997: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
998: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
999: END IF;
1000: wf_core.context('WSH_WF_INTERFACE',

Line 997: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

993: WHEN OTHERS THEN
994: resultout := 'COMPLETE';
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
997: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
998: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
999: END IF;
1000: wf_core.context('WSH_WF_INTERFACE',
1001: 'SCPOD_C_CLOSE_TRIP_CK',

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

994: resultout := 'COMPLETE';
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
997: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
998: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
999: END IF;
1000: wf_core.context('WSH_WF_INTERFACE',
1001: 'SCPOD_C_CLOSE_TRIP_CK',
1002: itemtype,

Line 1033: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1029: --
1030: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1031: --
1032: IF l_debug_on IS NULL THEN
1033: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1034: END IF;
1035: --
1036: IF l_debug_on THEN
1037: wsh_debug_sv.push(l_module_name);

Line 1037: wsh_debug_sv.push(l_module_name);

1033: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1034: END IF;
1035: --
1036: IF l_debug_on THEN
1037: wsh_debug_sv.push(l_module_name);
1038: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1039: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1040: wsh_debug_sv.log(l_module_name, 'actid',actid);
1041: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 1038: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

1034: END IF;
1035: --
1036: IF l_debug_on THEN
1037: wsh_debug_sv.push(l_module_name);
1038: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1039: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1040: wsh_debug_sv.log(l_module_name, 'actid',actid);
1041: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1042: END IF;

Line 1039: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

1035: --
1036: IF l_debug_on THEN
1037: wsh_debug_sv.push(l_module_name);
1038: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1039: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1040: wsh_debug_sv.log(l_module_name, 'actid',actid);
1041: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1042: END IF;
1043:

Line 1040: wsh_debug_sv.log(l_module_name, 'actid',actid);

1036: IF l_debug_on THEN
1037: wsh_debug_sv.push(l_module_name);
1038: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1039: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1040: wsh_debug_sv.log(l_module_name, 'actid',actid);
1041: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1042: END IF;
1043:
1044: -- RUN mode - normal process execution

Line 1041: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

1037: wsh_debug_sv.push(l_module_name);
1038: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1039: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1040: wsh_debug_sv.log(l_module_name, 'actid',actid);
1041: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1042: END IF;
1043:
1044: -- RUN mode - normal process execution
1045: IF (funcmode = 'RUN') THEN

Line 1049: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',

1045: IF (funcmode = 'RUN') THEN
1046:
1047: l_screening_flag := 'N';
1048: IF l_debug_on THEN
1049: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1050: WSH_DEBUG_SV.C_PROC_LEVEL);
1051: END IF;
1052:
1053: l_organization_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'ORG_ID',FALSE);

Line 1050: WSH_DEBUG_SV.C_PROC_LEVEL);

1046:
1047: l_screening_flag := 'N';
1048: IF l_debug_on THEN
1049: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1050: WSH_DEBUG_SV.C_PROC_LEVEL);
1051: END IF;
1052:
1053: l_organization_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'ORG_ID',FALSE);
1054: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => l_organization_id,

Line 1058: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1054: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => l_organization_id,
1055: x_param_info => l_param_info,
1056: x_return_status => l_return_status);
1057: IF l_debug_on THEN
1058: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1059: END IF;
1060:
1061: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1062: raise e_param_not_defined;

Line 1073: WSH_DEBUG_SV.pop(l_module_name);

1069: ELSE
1070: resultout := 'COMPLETE:NO';
1071: END IF;
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.pop(l_module_name);
1074: END IF;
1075: RETURN;
1076: END IF;
1077:

Line 1082: WSH_DEBUG_SV.pop(l_module_name);

1078: IF (funcmode = 'CANCEL') THEN
1079: NULL;
1080: resultout := 'COMPLETE';
1081: IF l_debug_on THEN
1082: WSH_DEBUG_SV.pop(l_module_name);
1083: END IF;
1084: RETURN;
1085: END IF;
1086:

Line 1089: WSH_DEBUG_SV.pop(l_module_name);

1085: END IF;
1086:
1087: -- Other execution modes
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.pop(l_module_name);
1090: END IF;
1091: resultout := '';
1092: RETURN;
1093: EXCEPTION

Line 1097: WSH_DEBUG_SV.logmsg(l_module_name,'No shipping parameters found for this organization'||

1093: EXCEPTION
1094: WHEN E_PARAM_NOT_DEFINED THEN
1095: resultout := 'COMPLETE:';
1096: IF l_debug_on THEN
1097: WSH_DEBUG_SV.logmsg(l_module_name,'No shipping parameters found for this organization'||
1098: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PARAM_NOT_DEFINED');
1100: END IF;
1101: wf_core.context('WSH_WF_INTERFACE',

Line 1098: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

1094: WHEN E_PARAM_NOT_DEFINED THEN
1095: resultout := 'COMPLETE:';
1096: IF l_debug_on THEN
1097: WSH_DEBUG_SV.logmsg(l_module_name,'No shipping parameters found for this organization'||
1098: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PARAM_NOT_DEFINED');
1100: END IF;
1101: wf_core.context('WSH_WF_INTERFACE',
1102: 'ITM_AT_SHIP_CONFIRM',

Line 1099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PARAM_NOT_DEFINED');

1095: resultout := 'COMPLETE:';
1096: IF l_debug_on THEN
1097: WSH_DEBUG_SV.logmsg(l_module_name,'No shipping parameters found for this organization'||
1098: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1099: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PARAM_NOT_DEFINED');
1100: END IF;
1101: wf_core.context('WSH_WF_INTERFACE',
1102: 'ITM_AT_SHIP_CONFIRM',
1103: itemtype,

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

1107: RAISE;
1108: WHEN OTHERS THEN
1109: resultout := 'COMPLETE:';
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1112: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1114: END IF;
1115: wf_core.context('WSH_WF_INTERFACE',

Line 1112: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1108: WHEN OTHERS THEN
1109: resultout := 'COMPLETE:';
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1112: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1114: END IF;
1115: wf_core.context('WSH_WF_INTERFACE',
1116: 'ITM_AT_SHIP_CONFIRM',

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

1109: resultout := 'COMPLETE:';
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1112: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1114: END IF;
1115: wf_core.context('WSH_WF_INTERFACE',
1116: 'ITM_AT_SHIP_CONFIRM',
1117: itemtype,

Line 1148: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1144: --
1145: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1146: --
1147: IF l_debug_on IS NULL THEN
1148: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1149: END IF;
1150: --
1151: IF l_debug_on THEN
1152: wsh_debug_sv.push(l_module_name);

Line 1152: wsh_debug_sv.push(l_module_name);

1148: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1149: END IF;
1150: --
1151: IF l_debug_on THEN
1152: wsh_debug_sv.push(l_module_name);
1153: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1154: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1155: wsh_debug_sv.log(l_module_name, 'actid',actid);
1156: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 1153: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

1149: END IF;
1150: --
1151: IF l_debug_on THEN
1152: wsh_debug_sv.push(l_module_name);
1153: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1154: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1155: wsh_debug_sv.log(l_module_name, 'actid',actid);
1156: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1157: END IF;

Line 1154: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

1150: --
1151: IF l_debug_on THEN
1152: wsh_debug_sv.push(l_module_name);
1153: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1154: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1155: wsh_debug_sv.log(l_module_name, 'actid',actid);
1156: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1157: END IF;
1158:

Line 1155: wsh_debug_sv.log(l_module_name, 'actid',actid);

1151: IF l_debug_on THEN
1152: wsh_debug_sv.push(l_module_name);
1153: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1154: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1155: wsh_debug_sv.log(l_module_name, 'actid',actid);
1156: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1157: END IF;
1158:
1159: -- RUN mode - normal process execution

Line 1156: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

1152: wsh_debug_sv.push(l_module_name);
1153: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1154: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1155: wsh_debug_sv.log(l_module_name, 'actid',actid);
1156: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1157: END IF;
1158:
1159: -- RUN mode - normal process execution
1160: IF (funcmode = 'RUN') THEN

Line 1164: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',

1160: IF (funcmode = 'RUN') THEN
1161:
1162: l_screening_flag := 'N';
1163: IF l_debug_on THEN
1164: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1165: WSH_DEBUG_SV.C_PROC_LEVEL);
1166: END IF;
1167:
1168: l_organization_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'ORG_ID',FALSE);

Line 1165: WSH_DEBUG_SV.C_PROC_LEVEL);

1161:
1162: l_screening_flag := 'N';
1163: IF l_debug_on THEN
1164: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1165: WSH_DEBUG_SV.C_PROC_LEVEL);
1166: END IF;
1167:
1168: l_organization_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'ORG_ID',FALSE);
1169: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => l_organization_id,

Line 1173: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1169: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => l_organization_id,
1170: x_param_info => l_param_info,
1171: x_return_status => l_return_status);
1172: IF l_debug_on THEN
1173: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1174: END IF;
1175:
1176: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1177: raise e_param_not_defined;

Line 1188: WSH_DEBUG_SV.pop(l_module_name);

1184: ELSE
1185: resultout := 'COMPLETE:NO';
1186: END IF;
1187: IF l_debug_on THEN
1188: WSH_DEBUG_SV.pop(l_module_name);
1189: END IF;
1190: RETURN;
1191: END IF;
1192:

Line 1197: WSH_DEBUG_SV.pop(l_module_name);

1193: IF (funcmode = 'CANCEL') THEN
1194: NULL;
1195: resultout := 'COMPLETE';
1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.pop(l_module_name);
1198: END IF;
1199: RETURN;
1200: END IF;
1201:

Line 1204: WSH_DEBUG_SV.pop(l_module_name);

1200: END IF;
1201:
1202: -- Other execution modes
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.pop(l_module_name);
1205: END IF;
1206: resultout := '';
1207: RETURN;
1208: EXCEPTION

Line 1212: WSH_DEBUG_SV.logmsg(l_module_name,'No shipping parameters found for this organization'||

1208: EXCEPTION
1209: WHEN E_PARAM_NOT_DEFINED THEN
1210: resultout := 'COMPLETE:NO';
1211: IF l_debug_on THEN
1212: WSH_DEBUG_SV.logmsg(l_module_name,'No shipping parameters found for this organization'||
1213: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PARAM_NOT_DEFINED');
1215: END IF;
1216: wf_core.context('WSH_WF_INTERFACE',

Line 1213: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

1209: WHEN E_PARAM_NOT_DEFINED THEN
1210: resultout := 'COMPLETE:NO';
1211: IF l_debug_on THEN
1212: WSH_DEBUG_SV.logmsg(l_module_name,'No shipping parameters found for this organization'||
1213: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PARAM_NOT_DEFINED');
1215: END IF;
1216: wf_core.context('WSH_WF_INTERFACE',
1217: 'ITM_AT_DEL_CR',

Line 1214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PARAM_NOT_DEFINED');

1210: resultout := 'COMPLETE:NO';
1211: IF l_debug_on THEN
1212: WSH_DEBUG_SV.logmsg(l_module_name,'No shipping parameters found for this organization'||
1213: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_PARAM_NOT_DEFINED');
1215: END IF;
1216: wf_core.context('WSH_WF_INTERFACE',
1217: 'ITM_AT_DEL_CR',
1218: itemtype,

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

1222: RAISE;
1223: WHEN OTHERS THEN
1224: resultout := 'COMPLETE:NO';
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1227: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1229: END IF;
1230: wf_core.context('WSH_WF_INTERFACE',

Line 1227: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1223: WHEN OTHERS THEN
1224: resultout := 'COMPLETE:NO';
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1227: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1229: END IF;
1230: wf_core.context('WSH_WF_INTERFACE',
1231: 'ITM_AT_DEL_CR',

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

1224: resultout := 'COMPLETE:NO';
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1227: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1229: END IF;
1230: wf_core.context('WSH_WF_INTERFACE',
1231: 'ITM_AT_DEL_CR',
1232: itemtype,

Line 1263: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1259: --
1260: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1261: --
1262: IF l_debug_on IS NULL THEN
1263: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1264: END IF;
1265: --
1266: IF l_debug_on THEN
1267: wsh_debug_sv.push(l_module_name);

Line 1267: wsh_debug_sv.push(l_module_name);

1263: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1264: END IF;
1265: --
1266: IF l_debug_on THEN
1267: wsh_debug_sv.push(l_module_name);
1268: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1269: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1270: wsh_debug_sv.log(l_module_name, 'actid',actid);
1271: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 1268: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

1264: END IF;
1265: --
1266: IF l_debug_on THEN
1267: wsh_debug_sv.push(l_module_name);
1268: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1269: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1270: wsh_debug_sv.log(l_module_name, 'actid',actid);
1271: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1272: END IF;

Line 1269: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

1265: --
1266: IF l_debug_on THEN
1267: wsh_debug_sv.push(l_module_name);
1268: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1269: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1270: wsh_debug_sv.log(l_module_name, 'actid',actid);
1271: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1272: END IF;
1273:

Line 1270: wsh_debug_sv.log(l_module_name, 'actid',actid);

1266: IF l_debug_on THEN
1267: wsh_debug_sv.push(l_module_name);
1268: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1269: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1270: wsh_debug_sv.log(l_module_name, 'actid',actid);
1271: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1272: END IF;
1273:
1274: -- RUN mode - normal process execution

Line 1271: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

1267: wsh_debug_sv.push(l_module_name);
1268: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1269: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1270: wsh_debug_sv.log(l_module_name, 'actid',actid);
1271: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1272: END IF;
1273:
1274: -- RUN mode - normal process execution
1275: IF (funcmode = 'RUN') THEN

Line 1281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES',

1277: l_organization_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'ORG_ID',FALSE);
1278:
1279:
1280: IF l_debug_on THEN
1281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES',
1282: WSH_DEBUG_SV.C_PROC_LEVEL);
1283: END IF;
1284:
1285: WSH_ITM_EXPORT_SCREENING.Screen_Event_Deliveries (

Line 1282: WSH_DEBUG_SV.C_PROC_LEVEL);

1278:
1279:
1280: IF l_debug_on THEN
1281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES',
1282: WSH_DEBUG_SV.C_PROC_LEVEL);
1283: END IF;
1284:
1285: WSH_ITM_EXPORT_SCREENING.Screen_Event_Deliveries (
1286: x_return_status => l_return_status,

Line 1295: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

1291: p_ship_method_code => null,
1292: p_pickup_date_from => null,
1293: p_pickup_date_to => null);
1294: IF l_debug_on THEN
1295: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1296: END IF;
1297:
1298: IF (l_return_status <> wsh_util_core.g_ret_sts_error
1299: AND l_return_status <> wsh_util_core.G_RET_STS_UNEXP_ERROR) THEN

Line 1310: WSH_DEBUG_SV.pop(l_module_name);

1306:
1307: IF (funcmode = 'CANCEL') THEN
1308: resultout := 'COMPLETE';
1309: IF l_debug_on THEN
1310: WSH_DEBUG_SV.pop(l_module_name);
1311: END IF;
1312: RETURN;
1313: END IF;
1314: -- Other execution modes

Line 1316: WSH_DEBUG_SV.pop(l_module_name);

1312: RETURN;
1313: END IF;
1314: -- Other execution modes
1315: IF l_debug_on THEN
1316: WSH_DEBUG_SV.pop(l_module_name);
1317: END IF;
1318: resultout := '';
1319: RETURN;
1320: EXCEPTION

Line 1372: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1368: --
1369: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1370: --
1371: IF l_debug_on IS NULL THEN
1372: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1373: END IF;
1374: --
1375: IF l_debug_on THEN
1376: wsh_debug_sv.push(l_module_name);

Line 1376: wsh_debug_sv.push(l_module_name);

1372: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1373: END IF;
1374: --
1375: IF l_debug_on THEN
1376: wsh_debug_sv.push(l_module_name);
1377: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1378: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1379: wsh_debug_sv.log(l_module_name, 'actid',actid);
1380: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 1377: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

1373: END IF;
1374: --
1375: IF l_debug_on THEN
1376: wsh_debug_sv.push(l_module_name);
1377: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1378: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1379: wsh_debug_sv.log(l_module_name, 'actid',actid);
1380: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1381: END IF;

Line 1378: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

1374: --
1375: IF l_debug_on THEN
1376: wsh_debug_sv.push(l_module_name);
1377: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1378: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1379: wsh_debug_sv.log(l_module_name, 'actid',actid);
1380: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1381: END IF;
1382:

Line 1379: wsh_debug_sv.log(l_module_name, 'actid',actid);

1375: IF l_debug_on THEN
1376: wsh_debug_sv.push(l_module_name);
1377: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1378: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1379: wsh_debug_sv.log(l_module_name, 'actid',actid);
1380: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1381: END IF;
1382:
1383: -- RUN mode - normal process execution

Line 1380: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

1376: wsh_debug_sv.push(l_module_name);
1377: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1378: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1379: wsh_debug_sv.log(l_module_name, 'actid',actid);
1380: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1381: END IF;
1382:
1383: -- RUN mode - normal process execution
1384: IF (funcmode = 'RUN') THEN

Line 1405: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_CUSTOM_WF_PROCESS', WSH_DEBUG_SV.C_PROC_LEVEL);

1401: FETCH get_org_code into l_organization_code;
1402: CLOSE get_org_code ;
1403:
1404: IF l_debug_on THEN
1405: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.GET_CUSTOM_WF_PROCESS', WSH_DEBUG_SV.C_PROC_LEVEL);
1406: END IF;
1407: WSH_WF_STD.Get_Custom_Wf_Process(p_wf_process => 'R_SCPOD_C',
1408: p_org_code => l_organization_code,
1409: x_wf_process => l_custom_process_name,

Line 1412: WSH_DEBUG_SV.log(l_module_name,'L_SCPOD_WF_PROCESS_EXISTS',l_scpod_wf_process_exists);

1408: p_org_code => l_organization_code,
1409: x_wf_process => l_custom_process_name,
1410: x_return_status => l_return_status);
1411: IF l_debug_on THEN
1412: WSH_DEBUG_SV.log(l_module_name,'L_SCPOD_WF_PROCESS_EXISTS',l_scpod_wf_process_exists);
1413: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
1414: END IF;
1415:
1416: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_custom_process_name is null) THEN

Line 1413: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);

1409: x_wf_process => l_custom_process_name,
1410: x_return_status => l_return_status);
1411: IF l_debug_on THEN
1412: WSH_DEBUG_SV.log(l_module_name,'L_SCPOD_WF_PROCESS_EXISTS',l_scpod_wf_process_exists);
1413: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
1414: END IF;
1415:
1416: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_custom_process_name is null) THEN
1417: l_custom_process_name := 'R_SCPOD_C';

Line 1428: WSH_DEBUG_SV.pop(l_module_name);

1424: ELSE
1425: resultout := 'COMPLETE:DISABLED';
1426: END IF;
1427: IF l_debug_on THEN
1428: WSH_DEBUG_SV.pop(l_module_name);
1429: END IF;
1430: RETURN;
1431: END IF;
1432: IF (funcmode = 'CANCEL') THEN

Line 1436: WSH_DEBUG_SV.pop(l_module_name);

1432: IF (funcmode = 'CANCEL') THEN
1433: NULL;
1434: resultout := 'COMPLETE';
1435: IF l_debug_on THEN
1436: WSH_DEBUG_SV.pop(l_module_name);
1437: END IF;
1438: RETURN;
1439: END IF;
1440:

Line 1443: WSH_DEBUG_SV.pop(l_module_name);

1439: END IF;
1440:
1441: -- Other execution modes
1442: IF l_debug_on THEN
1443: WSH_DEBUG_SV.pop(l_module_name);
1444: END IF;
1445: resultout := '';
1446: RETURN;
1447:

Line 1452: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||

1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN
1450: resultout := 'COMPLETE';
1451: IF l_debug_on THEN
1452: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
1453: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1455: END IF;
1456: wf_core.context('WSH_WF_INTERFACE',

Line 1453: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

1449: WHEN NO_DATA_FOUND THEN
1450: resultout := 'COMPLETE';
1451: IF l_debug_on THEN
1452: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
1453: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1455: END IF;
1456: wf_core.context('WSH_WF_INTERFACE',
1457: 'SCPOD_SCWF_STATUS',

Line 1454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

1450: resultout := 'COMPLETE';
1451: IF l_debug_on THEN
1452: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
1453: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1455: END IF;
1456: wf_core.context('WSH_WF_INTERFACE',
1457: 'SCPOD_SCWF_STATUS',
1458: itemtype,

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

1462: RAISE;
1463: WHEN OTHERS THEN
1464: resultout := 'COMPLETE';
1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1467: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1469: END IF;
1470: wf_core.context('WSH_WF_INTERFACE',

Line 1467: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1463: WHEN OTHERS THEN
1464: resultout := 'COMPLETE';
1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1467: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1469: END IF;
1470: wf_core.context('WSH_WF_INTERFACE',
1471: 'SCPOD_SCWF_STATUS',

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

1464: resultout := 'COMPLETE';
1465: IF l_debug_on THEN
1466: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1467: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1469: END IF;
1470: wf_core.context('WSH_WF_INTERFACE',
1471: 'SCPOD_SCWF_STATUS',
1472: itemtype,

Line 1511: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1507: --
1508: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1509: --
1510: IF l_debug_on IS NULL THEN
1511: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1512: END IF;
1513: --
1514: IF l_debug_on THEN
1515: wsh_debug_sv.push(l_module_name);

Line 1515: wsh_debug_sv.push(l_module_name);

1511: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1512: END IF;
1513: --
1514: IF l_debug_on THEN
1515: wsh_debug_sv.push(l_module_name);
1516: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1517: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1518: wsh_debug_sv.log(l_module_name, 'actid',actid);
1519: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 1516: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

1512: END IF;
1513: --
1514: IF l_debug_on THEN
1515: wsh_debug_sv.push(l_module_name);
1516: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1517: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1518: wsh_debug_sv.log(l_module_name, 'actid',actid);
1519: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1520: END IF;

Line 1517: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

1513: --
1514: IF l_debug_on THEN
1515: wsh_debug_sv.push(l_module_name);
1516: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1517: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1518: wsh_debug_sv.log(l_module_name, 'actid',actid);
1519: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1520: END IF;
1521:

Line 1518: wsh_debug_sv.log(l_module_name, 'actid',actid);

1514: IF l_debug_on THEN
1515: wsh_debug_sv.push(l_module_name);
1516: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1517: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1518: wsh_debug_sv.log(l_module_name, 'actid',actid);
1519: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1520: END IF;
1521:
1522: -- RUN mode - normal process execution

Line 1519: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

1515: wsh_debug_sv.push(l_module_name);
1516: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1517: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1518: wsh_debug_sv.log(l_module_name, 'actid',actid);
1519: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1520: END IF;
1521:
1522: -- RUN mode - normal process execution
1523: IF (funcmode = 'RUN') THEN

Line 1536: WSH_DEBUG_SV.pop(l_module_name);

1532: ELSE
1533: resultout := 'COMPLETE:DISABLED';
1534: END IF;
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.pop(l_module_name);
1537: END IF;
1538: RETURN;
1539: END IF;
1540: IF (funcmode = 'CANCEL') THEN

Line 1544: WSH_DEBUG_SV.pop(l_module_name);

1540: IF (funcmode = 'CANCEL') THEN
1541: NULL;
1542: resultout := 'COMPLETE';
1543: IF l_debug_on THEN
1544: WSH_DEBUG_SV.pop(l_module_name);
1545: END IF;
1546: RETURN;
1547: END IF;
1548:

Line 1551: WSH_DEBUG_SV.pop(l_module_name);

1547: END IF;
1548:
1549: -- Other execution modes
1550: IF l_debug_on THEN
1551: WSH_DEBUG_SV.pop(l_module_name);
1552: END IF;
1553: resultout := '';
1554: RETURN;
1555:

Line 1560: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||

1556: EXCEPTION
1557: WHEN NO_DATA_FOUND THEN
1558: resultout := 'COMPLETE';
1559: IF l_debug_on THEN
1560: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
1561: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1563: END IF;
1564: wf_core.context('WSH_WF_INTERFACE',

Line 1561: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);

1557: WHEN NO_DATA_FOUND THEN
1558: resultout := 'COMPLETE';
1559: IF l_debug_on THEN
1560: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
1561: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1563: END IF;
1564: wf_core.context('WSH_WF_INTERFACE',
1565: 'MANIFESTING_STATUS',

Line 1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

1558: resultout := 'COMPLETE';
1559: IF l_debug_on THEN
1560: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for the entity.Oracle error message is '||
1561: SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1563: END IF;
1564: wf_core.context('WSH_WF_INTERFACE',
1565: 'MANIFESTING_STATUS',
1566: itemtype,

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

1570: RAISE;
1571: WHEN OTHERS THEN
1572: resultout := 'COMPLETE';
1573: IF l_debug_on THEN
1574: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1575: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1577: END IF;
1578: wf_core.context('WSH_WF_INTERFACE',

Line 1575: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1571: WHEN OTHERS THEN
1572: resultout := 'COMPLETE';
1573: IF l_debug_on THEN
1574: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1575: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1577: END IF;
1578: wf_core.context('WSH_WF_INTERFACE',
1579: 'MANIFESTING_STATUS',

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

1572: resultout := 'COMPLETE';
1573: IF l_debug_on THEN
1574: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1575: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1577: END IF;
1578: wf_core.context('WSH_WF_INTERFACE',
1579: 'MANIFESTING_STATUS',
1580: itemtype,

Line 1616: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1612: --
1613: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1614: --
1615: IF l_debug_on IS NULL THEN
1616: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1617: END IF;
1618: --
1619: IF l_debug_on THEN
1620: wsh_debug_sv.push(l_module_name);

Line 1620: wsh_debug_sv.push(l_module_name);

1616: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1617: END IF;
1618: --
1619: IF l_debug_on THEN
1620: wsh_debug_sv.push(l_module_name);
1621: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1622: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1623: wsh_debug_sv.log(l_module_name, 'actid',actid);
1624: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

Line 1621: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);

1617: END IF;
1618: --
1619: IF l_debug_on THEN
1620: wsh_debug_sv.push(l_module_name);
1621: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1622: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1623: wsh_debug_sv.log(l_module_name, 'actid',actid);
1624: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1625: END IF;

Line 1622: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);

1618: --
1619: IF l_debug_on THEN
1620: wsh_debug_sv.push(l_module_name);
1621: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1622: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1623: wsh_debug_sv.log(l_module_name, 'actid',actid);
1624: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1625: END IF;
1626:

Line 1623: wsh_debug_sv.log(l_module_name, 'actid',actid);

1619: IF l_debug_on THEN
1620: wsh_debug_sv.push(l_module_name);
1621: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1622: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1623: wsh_debug_sv.log(l_module_name, 'actid',actid);
1624: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1625: END IF;
1626:
1627: -- Currently RUN mode is not being used. We are using the WSH_WF_STD pkg functions

Line 1624: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);

1620: wsh_debug_sv.push(l_module_name);
1621: wsh_debug_sv.log(l_module_name, 'itemtype',itemtype);
1622: wsh_debug_sv.log(l_module_name, 'itemkey',itemkey);
1623: wsh_debug_sv.log(l_module_name, 'actid',actid);
1624: wsh_debug_sv.log(l_module_name, 'funcmode',funcmode);
1625: END IF;
1626:
1627: -- Currently RUN mode is not being used. We are using the WSH_WF_STD pkg functions
1628: -- to find out the process that needs to be launched and are passing that

Line 1633: WSH_DEBUG_SV.pop(l_module_name);

1629: -- process name in the createprocess call.
1630: IF (funcmode='RUN') THEN
1631: resultout:='COMPLETE';
1632: IF l_debug_on THEN
1633: WSH_DEBUG_SV.pop(l_module_name);
1634: END IF;
1635: RETURN;
1636: END IF;
1637:

Line 1660: WSH_DEBUG_SV.pop(l_module_name);

1656: END IF;
1657: END IF;
1658: resultout:='COMPLETE';
1659: IF l_debug_on THEN
1660: WSH_DEBUG_SV.pop(l_module_name);
1661: END IF;
1662: RETURN;
1663: END IF;
1664: IF (funcmode = 'TEST_CTX') THEN

Line 1668: wsh_debug_sv.log (l_module_name, 'l_wf_org_id', l_org_id);

1664: IF (funcmode = 'TEST_CTX') THEN
1665: IF WSH_WF_STD.G_RESET_APPS_CONTEXT THEN
1666: l_org_id := to_number(wf_engine.GetItemAttrText( itemtype,itemkey,'ORG_ID'));
1667: IF l_debug_on THEN
1668: wsh_debug_sv.log (l_module_name, 'l_wf_org_id', l_org_id);
1669: END IF;
1670: IF l_org_id IS NULL THEN
1671: resultout := 'TRUE'; -- No Org to match against .. Single Org Env..
1672: ELSE -- Org Id is not null

Line 1675: wsh_debug_sv.log (l_module_name, 'l_current_org_id', MO_GLOBAL.get_current_org_id);

1671: resultout := 'TRUE'; -- No Org to match against .. Single Org Env..
1672: ELSE -- Org Id is not null
1673: -- Fetch Current Env Org.
1674: IF l_debug_on THEN
1675: wsh_debug_sv.log (l_module_name, 'l_current_org_id', MO_GLOBAL.get_current_org_id);
1676: END IF;
1677: IF NVL(MO_GLOBAL.get_current_org_id, -99) <> l_org_id THEN
1678: resultout := 'FALSE';
1679: ELSE

Line 1688: WSH_DEBUG_SV.pop(l_module_name);

1684: resultout := 'TRUE';
1685: END IF;
1686:
1687: IF l_debug_on THEN
1688: WSH_DEBUG_SV.pop(l_module_name);
1689: END IF;
1690: RETURN;
1691: END IF;
1692: