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.FTE_WORKFLOW_UTIL dependencies on WSH_UTIL_CORE

Line 100: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

96: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.fte.trip.svc.serviceselectioninitiated for trip '||p_trip_id);
97: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
98: END IF;
99:
100: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
101: WSH_WF_STD.Raise_Event(
102: p_entity_type => 'TRIP',
103: p_entity_id => p_trip_id,
104: p_event => 'oracle.apps.fte.trip.svc.serviceselectioninitiated' ,

Line 107: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

103: p_entity_id => p_trip_id,
104: p_event => 'oracle.apps.fte.trip.svc.serviceselectioninitiated' ,
105: x_return_status => l_return_status);
106:
107: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
108: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
109: THEN
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
111: IF l_debug_on

Line 108: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

104: p_event => 'oracle.apps.fte.trip.svc.serviceselectioninitiated' ,
105: x_return_status => l_return_status);
106:
107: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
108: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
109: THEN
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
111: IF l_debug_on
112: THEN

Line 110: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

106:
107: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
108: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
109: THEN
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
111: IF l_debug_on
112: THEN
113: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');
114: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service Init for trip '||p_trip_id);

Line 131: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

127: IF l_debug_on
128: THEN
129: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
130: END IF;
131: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
132: WHEN OTHERS
133: THEN
134: IF l_debug_on
135: THEN

Line 139: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

135: THEN
136: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
137: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
138: END IF;
139: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
140: END Single_Trip_Sel_Ser_Init;
141:
142:
143: --========================================================================

Line 178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

174: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.serviceselected for delivery '||p_del_id||', org '||p_org_id);
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;
177:
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
179: WSH_WF_STD.Raise_Event(
180: p_entity_type => 'DELIVERY',
181: p_entity_id => p_del_id,
182: p_event => 'oracle.apps.fte.delivery.svc.serviceselected',

Line 186: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

182: p_event => 'oracle.apps.fte.delivery.svc.serviceselected',
183: p_organization_id => p_org_id,
184: x_return_status => l_return_status);
185:
186: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
187: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
188: THEN
189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
190: IF l_debug_on

Line 187: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

183: p_organization_id => p_org_id,
184: x_return_status => l_return_status);
185:
186: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
187: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
188: THEN
189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
190: IF l_debug_on
191: THEN

Line 189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

185:
186: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
187: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
188: THEN
189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
190: IF l_debug_on
191: THEN
192: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');
193: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service for delivery '||p_del_id||', org '||p_org_id);

Line 210: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

206: IF l_debug_on
207: THEN
208: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
209: END IF;
210: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
211: WHEN OTHERS
212: THEN
213: IF l_debug_on
214: THEN

Line 218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

214: THEN
215: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
216: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
217: END IF;
218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
219:
220: END Single_Del_Sel_Ser;
221:
222:

Line 259: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

255: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.servicecancelled for delivery '||p_del_id||', org '||p_org_id);
256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
257: END IF;
258:
259: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
260: WSH_WF_STD.Raise_Event(
261: p_entity_type => 'DELIVERY',
262: p_entity_id => p_del_id,
263: p_event => 'oracle.apps.fte.delivery.svc.servicecancelled',

Line 267: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

263: p_event => 'oracle.apps.fte.delivery.svc.servicecancelled',
264: p_organization_id => p_org_id,
265: x_return_status => l_return_status);
266:
267: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
268: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
269: THEN
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: IF l_debug_on

Line 268: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

264: p_organization_id => p_org_id,
265: x_return_status => l_return_status);
266:
267: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
268: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
269: THEN
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: IF l_debug_on
272: THEN

Line 270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

266:
267: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
268: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
269: THEN
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: IF l_debug_on
272: THEN
273: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');
274: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Cancel Service for delivery '||p_del_id||', org '||p_org_id);

Line 291: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

287: IF l_debug_on
288: THEN
289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
290: END IF;
291: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
292: WHEN OTHERS
293: THEN
294: IF l_debug_on
295: THEN

Line 299: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

295: THEN
296: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
297: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
298: END IF;
299: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
300:
301: END Single_Del_Can_Ser;
302:
303:

Line 338: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

334: WSH_DEBUG_SV.push(l_module_name);
335: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
336: END IF;
337:
338: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
339: IF l_debug_on THEN
340: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||p_trip_id);
341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);
342: END IF;

Line 348: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

344: Single_Trip_Sel_Ser_Init(
345: p_trip_id => p_trip_id,
346: x_return_status => l_return_status);
347:
348: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
349: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
350: THEN
351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
352: IF l_debug_on

Line 349: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

345: p_trip_id => p_trip_id,
346: x_return_status => l_return_status);
347:
348: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
349: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
350: THEN
351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
352: IF l_debug_on
353: THEN

Line 351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

347:
348: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
349: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
350: THEN
351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
352: IF l_debug_on
353: THEN
354: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');
355: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service Initiated for the trip '||p_trip_id||' failed');

Line 385: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

381: p_del_id => l_del_id,
382: p_org_id => l_org_id,
383: x_return_status => l_return_status);
384:
385: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
386: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
387: THEN
388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
389: IF l_debug_on

Line 386: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

382: p_org_id => l_org_id,
383: x_return_status => l_return_status);
384:
385: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
386: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
387: THEN
388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
389: IF l_debug_on
390: THEN

Line 388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

384:
385: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
386: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
387: THEN
388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
389: IF l_debug_on
390: THEN
391: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');
392: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');

Line 412: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

408: IF l_debug_on
409: THEN
410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
411: END IF;
412: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
413: WHEN OTHERS
414: THEN
415: IF l_debug_on
416: THEN

Line 420: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

416: THEN
417: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
419: END IF;
420: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
421:
422: END Trip_Select_Service_Init;
423:
424:

Line 460: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

456: WSH_DEBUG_SV.push(l_module_name);
457: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
458: END IF;
459:
460: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
461:
462: IF l_debug_on
463: THEN
464: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching the deliveries assigned to the trip');

Line 487: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

483: p_del_id => l_del_id,
484: p_org_id => l_org_id,
485: x_return_status => l_return_status);
486:
487: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
488: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
489: THEN
490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
491: IF l_debug_on

Line 488: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

484: p_org_id => l_org_id,
485: x_return_status => l_return_status);
486:
487: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
488: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
489: THEN
490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
491: IF l_debug_on
492: THEN

Line 490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

486:
487: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
488: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
489: THEN
490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
491: IF l_debug_on
492: THEN
493: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');
494: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Cancel Service for the delivery '||l_del_id||' failed');

Line 514: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

510: IF l_debug_on
511: THEN
512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
513: END IF;
514: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
515: WHEN OTHERS
516: THEN
517: IF l_debug_on
518: THEN

Line 522: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

518: THEN
519: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
521: END IF;
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
523:
524: END Trip_Cancel_Service;
525:
526:

Line 561: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

557: WSH_DEBUG_SV.push(l_module_name);
558: WSH_DEBUG_SV.log(l_module_name,'P_DLEG_ID',p_dleg_id);
559: END IF;
560:
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
562:
563: OPEN Get_Dleg_Delivery(p_dleg_id);
564: FETCH Get_Dleg_Delivery INTO l_del_id;
565: CLOSE Get_Dleg_Delivery;

Line 569: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

565: CLOSE Get_Dleg_Delivery;
566:
567: IF l_del_id IS NULL
568: THEN
569: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to fetch the delivery associated with the delivery leg');
572: END IF;
573: RAISE FND_API.G_EXC_ERROR;

Line 590: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

586: p_del_id => l_del_id,
587: p_org_id => l_org_id,
588: x_return_status => l_return_status);
589:
590: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
591: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
592: THEN
593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
594: IF l_debug_on

Line 591: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

587: p_org_id => l_org_id,
588: x_return_status => l_return_status);
589:
590: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
591: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
592: THEN
593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
594: IF l_debug_on
595: THEN

Line 593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

589:
590: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
591: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
592: THEN
593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
594: IF l_debug_on
595: THEN
596: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');
597: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');

Line 623: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

619: Single_Trip_Sel_Ser_Init(
620: p_trip_id => l_trip_id,
621: x_return_status => l_return_status);
622:
623: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
624: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
625: THEN
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
627: IF l_debug_on

Line 624: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

620: p_trip_id => l_trip_id,
621: x_return_status => l_return_status);
622:
623: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
624: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
625: THEN
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
627: IF l_debug_on
628: THEN

Line 626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

622:
623: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
624: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
625: THEN
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
627: IF l_debug_on
628: THEN
629: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');
630: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the trip '||l_trip_id||' failed');

Line 652: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

648: IF l_debug_on
649: THEN
650: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
651: END IF;
652: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
653: WHEN OTHERS
654: THEN
655: IF l_debug_on
656: THEN

Line 660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

656: THEN
657: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
659: END IF;
660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
661:
662: END Dleg_Select_Service;
663:
664:

Line 697: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

693: WSH_DEBUG_SV.push(l_module_name);
694: WSH_DEBUG_SV.log(l_module_name,'P_DLEG_ID',p_dleg_id);
695: END IF;
696:
697: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
698:
699: OPEN Get_Dleg_Delivery(p_dleg_id);
700: FETCH Get_Dleg_Delivery INTO l_del_id;
701: CLOSE Get_Dleg_Delivery;

Line 705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

701: CLOSE Get_Dleg_Delivery;
702:
703: IF l_del_id IS NULL
704: THEN
705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to fetch the delivery associated with the delivery leg');
708: END IF;
709: RAISE FND_API.G_EXC_ERROR;

Line 726: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

722: p_del_id => l_del_id,
723: p_org_id => l_org_id,
724: x_return_status => l_return_status);
725:
726: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
727: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
728: THEN
729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
730: IF l_debug_on

Line 727: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

723: p_org_id => l_org_id,
724: x_return_status => l_return_status);
725:
726: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
727: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
728: THEN
729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
730: IF l_debug_on
731: THEN

Line 729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

725:
726: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
727: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
728: THEN
729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
730: IF l_debug_on
731: THEN
732: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');
733: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Cancel Service for the delivery '||l_del_id||' failed');

Line 751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

747: IF l_debug_on
748: THEN
749: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
750: END IF;
751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
752: WHEN OTHERS
753: THEN
754: IF l_debug_on
755: THEN

Line 759: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

755: THEN
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
758: END IF;
759: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
760:
761: END Dleg_Cancel_Service;
762:
763: