DBA Data[Home] [Help]

APPS.FTE_WORKFLOW_UTIL dependencies on FTE_WORKFLOW_UTIL

Line 1: PACKAGE BODY FTE_WORKFLOW_UTIL AS

1: PACKAGE BODY FTE_WORKFLOW_UTIL AS
2: /* $Header: FTEWKFUB.pls 120.3 2005/08/12 13:52:02 schennal noship $ */
3:
4: --===================
5: -- PUBLIC VARIABLES

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_WORKFLOW_UTIL';

3:
4: --===================
5: -- PUBLIC VARIABLES
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_WORKFLOW_UTIL';
8:
9: --========================================================================
10: -- CURSOR : Get_Trip_Deliveries
11: --

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

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;
343:
344: Single_Trip_Sel_Ser_Init(
345: p_trip_id => p_trip_id,

Line 354: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');

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');
356: END IF;
357: RAISE FND_API.G_EXC_ERROR;
358: END IF;

Line 377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);

373:
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);
377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
378: END IF;
379:
380: Single_Del_Sel_Ser(
381: p_del_id => l_del_id,

Line 391: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');

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');
393: END IF;
394: END IF;
395:

Line 479: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);

475:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);
478: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Cancellation for the delivery '||l_del_id);
479: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
480: END IF;
481:
482: Single_Del_Can_Ser(
483: p_del_id => l_del_id,

Line 493: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');

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');
495: END IF;
496: END IF;
497:

Line 582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);

578: CLOSE Get_Delivery_Org;
579:
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);
582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
583: END IF;
584:
585: Single_Del_Sel_Ser(
586: p_del_id => l_del_id,

Line 596: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');

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');
598: END IF;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF;

Line 616: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);

612:
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.logmsg(l_module_name,'Found trip '||l_trip_id);
615: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||l_trip_id);
616: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);
617: END IF;
618:
619: Single_Trip_Sel_Ser_Init(
620: p_trip_id => l_trip_id,

Line 629: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');

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');
631: END IF;
632: END IF;
633: ELSE

Line 718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);

714: CLOSE Get_Delivery_Org;
715:
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Cancel Service for the delivery '||l_del_id);
718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
719: END IF;
720:
721: Single_Del_Can_Ser(
722: p_del_id => l_del_id,

Line 732: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');

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');
734: END IF;
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;

Line 764: END FTE_WORKFLOW_UTIL;

760:
761: END Dleg_Cancel_Service;
762:
763:
764: END FTE_WORKFLOW_UTIL;