DBA Data[Home] [Help]

APPS.WSH_EXCEPTIONS_GRP dependencies on WSH_UTIL_VALIDATE

Line 697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the logging entity',WSH_DEBUG_SV.C_PROC_LEVEL);

693: --
694: -- Debug Statements
695: --
696: IF l_debug_on THEN
697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the logging entity',WSH_DEBUG_SV.C_PROC_LEVEL);
698: END IF;
699: --
700: WSH_UTIL_VALIDATE.Validate_Lookup('LOGGING_ENTITY',l_logging_entity,
701: p_exception_rec.logging_entity,l_return_status);

Line 700: WSH_UTIL_VALIDATE.Validate_Lookup('LOGGING_ENTITY',l_logging_entity,

696: IF l_debug_on THEN
697: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the logging entity',WSH_DEBUG_SV.C_PROC_LEVEL);
698: END IF;
699: --
700: WSH_UTIL_VALIDATE.Validate_Lookup('LOGGING_ENTITY',l_logging_entity,
701: p_exception_rec.logging_entity,l_return_status);
702: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
703: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
704: x_return_status := l_return_status;

Line 717: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);

713: --
714: -- Debug Statements
715: --
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);
718: END IF;
719: --
720: WSH_UTIL_VALIDATE.Validate_Location(
721: p_location_id => l_logged_at_location_id,

Line 720: WSH_UTIL_VALIDATE.Validate_Location(

716: IF l_debug_on THEN
717: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);
718: END IF;
719: --
720: WSH_UTIL_VALIDATE.Validate_Location(
721: p_location_id => l_logged_at_location_id,
722: p_location_code => p_exception_rec.logged_at_location_code,
723: x_return_status => l_return_status);
724: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 739: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);

735: --
736: -- Debug Statements
737: --
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);
740: END IF;
741: --
742: WSH_UTIL_VALIDATE.Validate_Location (
743: p_location_id => l_exception_location_id,

Line 742: WSH_UTIL_VALIDATE.Validate_Location (

738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);
740: END IF;
741: --
742: WSH_UTIL_VALIDATE.Validate_Location (
743: p_location_id => l_exception_location_id,
744: p_location_code => p_exception_rec.exception_location_code,
745: x_return_status => l_return_status);
746: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

757: --
758: -- Debug Statements
759: --
760: IF l_debug_on THEN
761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
762: END IF;
763: --
764: WSH_UTIL_VALIDATE.Validate_Trip_Name(
765: p_trip_id => l_trip_id,

Line 764: WSH_UTIL_VALIDATE.Validate_Trip_Name(

760: IF l_debug_on THEN
761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
762: END IF;
763: --
764: WSH_UTIL_VALIDATE.Validate_Trip_Name(
765: p_trip_id => l_trip_id,
766: p_trip_name => p_exception_rec.trip_name,
767: x_return_status => l_return_status);
768: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

789: --
790: -- Debug Statements
791: --
792: IF l_debug_on THEN
793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
794: END IF;
795: --
796: WSH_UTIL_VALIDATE.Validate_Delivery_Name(
797: p_delivery_id => l_delivery_id,

Line 796: WSH_UTIL_VALIDATE.Validate_Delivery_Name(

792: IF l_debug_on THEN
793: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
794: END IF;
795: --
796: WSH_UTIL_VALIDATE.Validate_Delivery_Name(
797: p_delivery_id => l_delivery_id,
798: p_delivery_name => p_exception_rec.delivery_name,
799: x_return_status => l_return_status);
800: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1438: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the loggint entity',WSH_DEBUG_SV.C_PROC_LEVEL);

1434: --
1435: -- Debug Statements
1436: --
1437: IF l_debug_on THEN
1438: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the loggint entity',WSH_DEBUG_SV.C_PROC_LEVEL);
1439: END IF;
1440: --
1441: WSH_UTIL_VALIDATE.Validate_Lookup('LOGGING_ENTITY',l_logging_entity,
1442: p_exception_rec.logging_entity,l_return_status);

Line 1441: WSH_UTIL_VALIDATE.Validate_Lookup('LOGGING_ENTITY',l_logging_entity,

1437: IF l_debug_on THEN
1438: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUP to Validate the loggint entity',WSH_DEBUG_SV.C_PROC_LEVEL);
1439: END IF;
1440: --
1441: WSH_UTIL_VALIDATE.Validate_Lookup('LOGGING_ENTITY',l_logging_entity,
1442: p_exception_rec.logging_entity,l_return_status);
1443: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1444: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1445: x_return_status := l_return_status;

Line 1458: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Exception Type',WSH_DEBUG_SV.C_PROC_LEVEL);

1454: --
1455: -- Debug Statements
1456: --
1457: IF l_debug_on THEN
1458: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Exception Type',WSH_DEBUG_SV.C_PROC_LEVEL);
1459: END IF;
1460: --
1461: WSH_UTIL_VALIDATE.Validate_Lookup('EXCEPTION_TYPE',l_exception_type,
1462: p_exception_rec.exception_type,l_return_status);

Line 1461: WSH_UTIL_VALIDATE.Validate_Lookup('EXCEPTION_TYPE',l_exception_type,

1457: IF l_debug_on THEN
1458: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Exception Type',WSH_DEBUG_SV.C_PROC_LEVEL);
1459: END IF;
1460: --
1461: WSH_UTIL_VALIDATE.Validate_Lookup('EXCEPTION_TYPE',l_exception_type,
1462: p_exception_rec.exception_type,l_return_status);
1463: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1464: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1465: x_return_status := l_return_status;

Line 1478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Severity',WSH_DEBUG_SV.C_PROC_LEVEL);

1474: --
1475: -- Debug Statements
1476: --
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Severity',WSH_DEBUG_SV.C_PROC_LEVEL);
1479: END IF;
1480: --
1481: WSH_UTIL_VALIDATE.Validate_Lookup('EXCEPTION_BEHAVIOR',l_severity,
1482: p_exception_rec.severity,l_return_status);

Line 1481: WSH_UTIL_VALIDATE.Validate_Lookup('EXCEPTION_BEHAVIOR',l_severity,

1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOOKUPto Validate the Severity',WSH_DEBUG_SV.C_PROC_LEVEL);
1479: END IF;
1480: --
1481: WSH_UTIL_VALIDATE.Validate_Lookup('EXCEPTION_BEHAVIOR',l_severity,
1482: p_exception_rec.severity,l_return_status);
1483: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1484: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1485: x_return_status := l_return_status;

Line 1498: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);

1494: --
1495: -- Debug Statements
1496: --
1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);
1499: END IF;
1500: --
1501: WSH_UTIL_VALIDATE.Validate_Location(l_logged_at_location_id,
1502: p_exception_rec.logged_at_location_code,l_return_status);

Line 1501: WSH_UTIL_VALIDATE.Validate_Location(l_logged_at_location_id,

1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate the Logged at Location',WSH_DEBUG_SV.C_PROC_LEVEL);
1499: END IF;
1500: --
1501: WSH_UTIL_VALIDATE.Validate_Location(l_logged_at_location_id,
1502: p_exception_rec.logged_at_location_code,l_return_status);
1503: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1504: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1505: x_return_status := l_return_status;

Line 1518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);

1514: --
1515: -- Debug Statements
1516: --
1517: IF l_debug_on THEN
1518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);
1519: END IF;
1520: --
1521: WSH_UTIL_VALIDATE.Validate_Location(l_exception_location_id,
1522: p_exception_rec.exception_location_code,l_return_status);

Line 1521: WSH_UTIL_VALIDATE.Validate_Location(l_exception_location_id,

1517: IF l_debug_on THEN
1518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION to Validate Exception Location',WSH_DEBUG_SV.C_PROC_LEVEL);
1519: END IF;
1520: --
1521: WSH_UTIL_VALIDATE.Validate_Location(l_exception_location_id,
1522: p_exception_rec.exception_location_code,l_return_status);
1523: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1524: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1525: x_return_status := l_return_status;

Line 1538: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1534: --
1535: -- Debug Statements
1536: --
1537: IF l_debug_on THEN
1538: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1539: END IF;
1540: --
1541: WSH_UTIL_VALIDATE.Validate_Delivery_Name(l_delivery_id,
1542: p_exception_rec.delivery_name,l_return_status);

Line 1541: WSH_UTIL_VALIDATE.Validate_Delivery_Name(l_delivery_id,

1537: IF l_debug_on THEN
1538: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1539: END IF;
1540: --
1541: WSH_UTIL_VALIDATE.Validate_Delivery_Name(l_delivery_id,
1542: p_exception_rec.delivery_name,l_return_status);
1543: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1544: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1545: x_return_status := l_return_status;