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_EXCEPTIONS_GRP dependencies on WSH_UTIL_CORE

Line 116: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

112: IF FND_API.to_boolean(p_init_msg_list) THEN
113: FND_MSG_PUB.initialize;
114: END IF;
115:
116: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
117:
118: l_count := 0;
119: IF (p_logging_entity_name = 'TRIP') THEN
120: FOR rec in Get_Trip_Exceptions(p_logging_entity_id) LOOP

Line 159: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

155:
156: EXCEPTION
157: WHEN wsh_invalid_exception_name THEN
158: FND_MESSAGE.Set_Name('FND', 'WSH_XC_INVALID_LOGGING_ENTITY');
159: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
160: wsh_util_core.add_message(x_return_status);
161: FND_MSG_PUB.Count_And_Get(
162: p_count => x_msg_count,
163: p_data => x_msg_data,

Line 160: wsh_util_core.add_message(x_return_status);

156: EXCEPTION
157: WHEN wsh_invalid_exception_name THEN
158: FND_MESSAGE.Set_Name('FND', 'WSH_XC_INVALID_LOGGING_ENTITY');
159: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
160: wsh_util_core.add_message(x_return_status);
161: FND_MSG_PUB.Count_And_Get(
162: p_count => x_msg_count,
163: p_data => x_msg_data,
164: p_encoded => FND_API.G_FALSE

Line 193: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.GET_EXCEPTIONS');

189: IF Get_Container_Exceptions%ISOPEN THEN
190: CLOSE Get_Container_Exceptions;
191: END IF;
192:
193: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.GET_EXCEPTIONS');
194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
195:
196: --
197: -- Debug Statements

Line 194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

190: CLOSE Get_Container_Exceptions;
191: END IF;
192:
193: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.GET_EXCEPTIONS');
194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
195:
196: --
197: -- Debug Statements
198: --

Line 310: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

306: FND_MSG_PUB.initialize;
307: END IF;
308:
309: -- initialize parameters
310: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
311: l_new_status := p_new_status;
312:
313: -- Checking p_logging_entity_id, p_logging_entity_name, and p_exception_name
314: -- if any of them is not valid then return

Line 320: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

316: (p_logging_entity_name = FND_API.G_MISS_CHAR) OR
317: (p_exception_name = FND_API.G_MISS_CHAR) OR
318: (p_new_status = FND_API.G_MISS_CHAR) THEN
319: x_updated_rows := 0;
320: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
321: --
322: -- Debug Statements
323: --
324: IF l_debug_on THEN

Line 348: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) OR (l_temp_tab.count = 0) THEN

344: x_msg_data => x_msg_data,
345: p_logging_entity_id => p_logging_entity_id,
346: p_logging_entity_name => p_logging_entity_name,
347: x_exceptions_tab => l_temp_tab);
348: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) OR (l_temp_tab.count = 0) THEN
349: x_updated_rows := 0;
350: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
351: --
352: -- Debug Statements

Line 350: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

346: p_logging_entity_name => p_logging_entity_name,
347: x_exceptions_tab => l_temp_tab);
348: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) OR (l_temp_tab.count = 0) THEN
349: x_updated_rows := 0;
350: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
351: --
352: -- Debug Statements
353: --
354: IF l_debug_on THEN

Line 401: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

397: p_set_default_status => FND_API.G_FALSE,
398: x_new_status => l_new_status
399: );
400:
401: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
402: l_error_count := l_error_count + 1;
403: ELSE
404: l_success_count := l_success_count + 1;
405: END IF;

Line 442: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

438: p_set_default_status => FND_API.G_FALSE,
439: x_new_status => l_new_status
440: );
441:
442: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
443: l_error_count := l_error_count + 1;
444: ELSE
445: l_success_count := l_success_count + 1;
446: END IF;

Line 452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

448: END IF;
449:
450: IF l_error_count > 0 THEN
451: IF l_success_count = 0 THEN
452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
453: ELSE
454: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
455: END IF;
456: ELSE

Line 454: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

450: IF l_error_count > 0 THEN
451: IF l_success_count = 0 THEN
452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
453: ELSE
454: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
455: END IF;
456: ELSE
457: IF l_success_count = 0 THEN
458: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 458: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

454: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
455: END IF;
456: ELSE
457: IF l_success_count = 0 THEN
458: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
459: ELSE
460: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
461: END IF;
462: END IF;

Line 460: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

456: ELSE
457: IF l_success_count = 0 THEN
458: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
459: ELSE
460: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
461: END IF;
462: END IF;
463:
464: x_updated_rows := l_success_count;

Line 466: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING))

462: END IF;
463:
464: x_updated_rows := l_success_count;
465:
466: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING))
467: AND FND_API.TO_BOOLEAN(p_commit) THEN
468: COMMIT WORK;
469: END IF;
470:

Line 486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

482: --
483:
484: EXCEPTION
485: WHEN WSH_INVALID_EXCEPTION_ID THEN
486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
487: wsh_util_core.add_message(x_return_status);
488: FND_MSG_PUB.Count_And_Get(
489: p_count => x_msg_count,
490: p_data => x_msg_data,

Line 487: wsh_util_core.add_message(x_return_status);

483:
484: EXCEPTION
485: WHEN WSH_INVALID_EXCEPTION_ID THEN
486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
487: wsh_util_core.add_message(x_return_status);
488: FND_MSG_PUB.Count_And_Get(
489: p_count => x_msg_count,
490: p_data => x_msg_data,
491: p_encoded => FND_API.G_FALSE

Line 504: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.CHANGE_STATUS');

500: END IF;
501: --
502:
503: WHEN others THEN
504: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.CHANGE_STATUS');
505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level
507: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN

Line 505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

501: --
502:
503: WHEN others THEN
504: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.CHANGE_STATUS');
505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level
507: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg

Line 702: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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;
705: ELSE
706: RAISE WSH_XC_LOOKUP_LOG;

Line 703: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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;
705: ELSE
706: RAISE WSH_XC_LOOKUP_LOG;
707: END IF;

Line 724: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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
725: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
726: x_return_status := l_return_status;
727: ELSE
728: RAISE WSH_INVALID_LOGGED_AT_LOCATION;

Line 725: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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
725: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
726: x_return_status := l_return_status;
727: ELSE
728: RAISE WSH_INVALID_LOGGED_AT_LOCATION;
729: END IF;

Line 746: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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
747: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
748: x_return_status := l_return_status;
749: ELSE
750: RAISE WSH_INVALID_EXCEPTION_LOCATION;

Line 747: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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
747: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
748: x_return_status := l_return_status;
749: ELSE
750: RAISE WSH_INVALID_EXCEPTION_LOCATION;
751: END IF;

Line 768: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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
769: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
770: x_return_status := l_return_status;
771: ELSE
772: RAISE WSH_INVALID_TRIPNAME;

Line 769: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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
769: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
770: x_return_status := l_return_status;
771: ELSE
772: RAISE WSH_INVALID_TRIPNAME;
773: END IF;

Line 800: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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
801: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
802: x_return_status := l_return_status;
803: ELSE
804: RAISE WSH_INVALID_DELIVERY;

Line 801: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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
801: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
802: x_return_status := l_return_status;
803: ELSE
804: RAISE WSH_INVALID_DELIVERY;
805: END IF;

Line 871: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

867: p_revision => p_exception_rec.revision,
868: p_locator_id => p_exception_rec.locator_id,
869: x_return_status => l_return_status,
870: x_result => l_result );
871: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
872: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
873: x_return_status := l_return_status;
874: ELSE
875: RAISE WSH_INVALID_INVENTORY_CONTROL;

Line 872: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

868: p_locator_id => p_exception_rec.locator_id,
869: x_return_status => l_return_status,
870: x_result => l_result );
871: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
872: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
873: x_return_status := l_return_status;
874: ELSE
875: RAISE WSH_INVALID_INVENTORY_CONTROL;
876: END IF;

Line 947: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

943: p_request_id => p_exception_rec.request_id,
944: p_batch_id => p_exception_rec.batch_id
945: );
946:
947: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
948: x_return_status := l_return_status;
949: END IF;
950:
951: FND_MSG_PUB.Count_And_Get(

Line 973: wsh_util_core.add_message(x_return_status,l_module_name);

969: END IF;
970: FND_MESSAGE.SET_NAME('WSH','WSH_MULTIPLE_CONTAINERS');
971: FND_MESSAGE.SET_TOKEN('CONT_NAME',p_exception_rec.container_name);
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: wsh_util_core.add_message(x_return_status,l_module_name);
974: FND_MSG_PUB.Count_And_Get(
975: p_count => x_msg_count,
976: p_data => x_msg_data,
977: p_encoded => FND_API.G_FALSE

Line 989: wsh_util_core.add_message(x_return_status);

985: WHEN WSH_XC_INVALID_OPERATION THEN
986: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_OPERATION');
987: FND_MESSAGE.SET_TOKEN('REASON', l_msg_reason);
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: wsh_util_core.add_message(x_return_status);
990: FND_MSG_PUB.Count_And_Get(
991: p_count => x_msg_count,
992: p_data => x_msg_data,
993: p_encoded => FND_API.G_FALSE

Line 1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1003:
1004: WHEN WSH_XC_LOOKUP_LOG THEN
1005: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1006: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','LOGGING_ENTITY');
1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1008: wsh_util_core.add_message(x_return_status);
1009: FND_MSG_PUB.Count_And_Get(
1010: p_count => x_msg_count,
1011: p_data => x_msg_data,

Line 1008: wsh_util_core.add_message(x_return_status);

1004: WHEN WSH_XC_LOOKUP_LOG THEN
1005: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1006: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','LOGGING_ENTITY');
1007: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1008: wsh_util_core.add_message(x_return_status);
1009: FND_MSG_PUB.Count_And_Get(
1010: p_count => x_msg_count,
1011: p_data => x_msg_data,
1012: p_encoded => FND_API.G_FALSE

Line 1026: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1022:
1023: WHEN WSH_XC_LOOKUP_SEVERITY THEN
1024: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1025: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','SEVERITY');
1026: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1027: wsh_util_core.add_message(x_return_status);
1028: FND_MSG_PUB.Count_And_Get(
1029: p_count => x_msg_count,
1030: p_data => x_msg_data,

Line 1027: wsh_util_core.add_message(x_return_status);

1023: WHEN WSH_XC_LOOKUP_SEVERITY THEN
1024: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1025: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','SEVERITY');
1026: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1027: wsh_util_core.add_message(x_return_status);
1028: FND_MSG_PUB.Count_And_Get(
1029: p_count => x_msg_count,
1030: p_data => x_msg_data,
1031: p_encoded => FND_API.G_FALSE

Line 1046: wsh_util_core.add_message(x_return_status);

1042: WHEN WSH_INVALID_TRIPNAME THEN
1043: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_INVALID_PARAMETER');
1044: FND_MESSAGE.SET_TOKEN('PARAMETER','Trip_Name');
1045: x_return_status := FND_API.G_RET_STS_ERROR;
1046: wsh_util_core.add_message(x_return_status);
1047: FND_MSG_PUB.Count_And_Get(
1048: p_count => x_msg_count,
1049: p_data => x_msg_data,
1050: p_encoded => FND_API.G_FALSE

Line 1065: wsh_util_core.add_message(x_return_status);

1061: WHEN WSH_INVALID_DELIVERY THEN
1062: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_INVALID_PARAMETER');
1063: FND_MESSAGE.SET_TOKEN('PARAMETER','Delivery_Name');
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: wsh_util_core.add_message(x_return_status);
1066: FND_MSG_PUB.Count_And_Get(
1067: p_count => x_msg_count,
1068: p_data => x_msg_data,
1069: p_encoded => FND_API.G_FALSE

Line 1083: wsh_util_core.add_message(x_return_status);

1079: WHEN WSH_INVALID_CONSOL_DELIVERY THEN
1080: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_CONSOL_DEL_EXP');
1081: FND_MESSAGE.SET_TOKEN('PARAMETER',p_exception_rec.delivery_name);
1082: x_return_status := FND_API.G_RET_STS_ERROR;
1083: wsh_util_core.add_message(x_return_status);
1084: FND_MSG_PUB.Count_And_Get(
1085: p_count => x_msg_count,
1086: p_data => x_msg_data,
1087: p_encoded => FND_API.G_FALSE

Line 1101: wsh_util_core.add_message(x_return_status);

1097:
1098: WHEN WSH_INVALID_LOGGED_AT_LOCATION THEN
1099: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_LOGGED_AT_LOCATION');
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: wsh_util_core.add_message(x_return_status);
1102: FND_MSG_PUB.Count_And_Get(
1103: p_count => x_msg_count,
1104: p_data => x_msg_data,
1105: p_encoded => FND_API.G_FALSE

Line 1119: wsh_util_core.add_message(x_return_status);

1115:
1116: WHEN WSH_INVALID_EXCEPTION_LOCATION THEN
1117: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_EXCEPTION_LOCATION');
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: wsh_util_core.add_message(x_return_status);
1120: FND_MSG_PUB.Count_And_Get(
1121: p_count => x_msg_count,
1122: p_data => x_msg_data,
1123: p_encoded => FND_API.G_FALSE

Line 1140: wsh_util_core.add_message(x_return_status);

1136: CLOSE C1;
1137: END IF;
1138: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_LOCATION');
1139: x_return_status := FND_API.G_RET_STS_ERROR;
1140: wsh_util_core.add_message(x_return_status);
1141: FND_MSG_PUB.Count_And_Get(
1142: p_count => x_msg_count,
1143: p_data => x_msg_data,
1144: p_encoded => FND_API.G_FALSE

Line 1162: wsh_util_core.add_message(x_return_status);

1158: END IF;
1159: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_INVALID_PARAMETER');
1160: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Delivery_Detail_Id');
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: wsh_util_core.add_message(x_return_status);
1163: FND_MSG_PUB.Count_And_Get(
1164: p_count => x_msg_count,
1165: p_data => x_msg_data,
1166: p_encoded => FND_API.G_FALSE

Line 1184: wsh_util_core.add_message(x_return_status);

1180: END IF;
1181: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_INVALID_PARAMETER');
1182: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Container_Name');
1183: x_return_status := FND_API.G_RET_STS_ERROR;
1184: wsh_util_core.add_message(x_return_status);
1185: FND_MSG_PUB.Count_And_Get(
1186: p_count => x_msg_count,
1187: p_data => x_msg_data,
1188: p_encoded => FND_API.G_FALSE

Line 1213: wsh_util_core.add_message(x_return_status);

1209:
1210: WHEN WSH_XC_INVALID_DATE THEN
1211: FND_MESSAGE.SET_NAME('WSH', 'WSH_XC_INVALID_DATE');
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: wsh_util_core.add_message(x_return_status);
1214: FND_MSG_PUB.Count_And_Get(
1215: p_count => x_msg_count,
1216: p_data => x_msg_data,
1217: p_encoded => FND_API.G_FALSE

Line 1229: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.LOG_EXCEPTION');

1225: END IF;
1226: --
1227:
1228: WHEN OTHERS THEN
1229: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.LOG_EXCEPTION');
1230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1231: IF FND_MSG_PUB.Check_Msg_Level
1232: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1233: THEN

Line 1230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1226: --
1227:
1228: WHEN OTHERS THEN
1229: wsh_util_core.default_handler('WSH_EXCEPTIONS_GRP.LOG_EXCEPTION');
1230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1231: IF FND_MSG_PUB.Check_Msg_Level
1232: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1233: THEN
1234: FND_MSG_PUB.Add_Exc_Msg

Line 1389: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1385: IF FND_API.to_boolean(p_init_msg_list) THEN
1386: FND_MSG_PUB.initialize;
1387: END IF;
1388:
1389: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1390:
1391: IF ( p_exception_rec.request_id IS NULL AND
1392: p_exception_rec.exception_name IS NULL AND
1393: p_exception_rec.logging_entity IS NULL AND

Line 1443: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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;
1446: ELSE
1447: RAISE WSH_XC_LOOKUP_LOG;

Line 1444: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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;
1446: ELSE
1447: RAISE WSH_XC_LOOKUP_LOG;
1448: END IF;

Line 1463: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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;
1466: ELSE
1467: RAISE WSH_XC_LOOKUP_EXCEPTION;

Line 1464: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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;
1466: ELSE
1467: RAISE WSH_XC_LOOKUP_EXCEPTION;
1468: END IF;

Line 1483: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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;
1486: ELSE
1487: RAISE WSH_XC_LOOKUP_SEVERITY;

Line 1484: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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;
1486: ELSE
1487: RAISE WSH_XC_LOOKUP_SEVERITY;
1488: END IF;

Line 1503: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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;
1506: ELSE
1507: RAISE WSH_INVALID_LOGGED_AT_LOCATION;

Line 1504: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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;
1506: ELSE
1507: RAISE WSH_INVALID_LOGGED_AT_LOCATION;
1508: END IF;

Line 1523: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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;
1526: ELSE
1527: RAISE WSH_INVALID_EXCEPTION_LOCATION;

Line 1524: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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;
1526: ELSE
1527: RAISE WSH_INVALID_EXCEPTION_LOCATION;
1528: END IF;

Line 1543: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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;
1546: ELSE
1547: RAISE WSH_XC_INVALID_DELIVERY;

Line 1544: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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;
1546: ELSE
1547: RAISE WSH_XC_INVALID_DELIVERY;
1548: END IF;

Line 1596: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1592: p_delivery_id => l_delivery_id,
1593: p_action => p_action
1594: );
1595:
1596: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1597: FND_MESSAGE.SET_NAME('WSH','WSH_NO_OF_RECS_PURGED');
1598: FND_MESSAGE.SET_TOKEN('NO_OF_RECS',l_no_of_records);
1599: wsh_util_core.add_message(l_return_status);
1600: END IF;

Line 1599: wsh_util_core.add_message(l_return_status);

1595:
1596: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1597: FND_MESSAGE.SET_NAME('WSH','WSH_NO_OF_RECS_PURGED');
1598: FND_MESSAGE.SET_TOKEN('NO_OF_RECS',l_no_of_records);
1599: wsh_util_core.add_message(l_return_status);
1600: END IF;
1601:
1602: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1603: x_return_status := l_return_status;

Line 1602: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1598: FND_MESSAGE.SET_TOKEN('NO_OF_RECS',l_no_of_records);
1599: wsh_util_core.add_message(l_return_status);
1600: END IF;
1601:
1602: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1603: x_return_status := l_return_status;
1604: END IF;
1605:
1606: FND_MSG_PUB.Count_And_Get(

Line 1625: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1621: IF c_exception_name%ISOPEN THEN
1622: CLOSE c_exception_name;
1623: END IF;
1624: FND_MESSAGE.SET_NAME('WSH','WSH_XC_DEF_NOT_FOUND');
1625: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1626: wsh_util_core.add_message(x_return_status);
1627: FND_MSG_PUB.Count_And_Get(
1628: p_count => x_msg_count,
1629: p_data => x_msg_data,

Line 1626: wsh_util_core.add_message(x_return_status);

1622: CLOSE c_exception_name;
1623: END IF;
1624: FND_MESSAGE.SET_NAME('WSH','WSH_XC_DEF_NOT_FOUND');
1625: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1626: wsh_util_core.add_message(x_return_status);
1627: FND_MSG_PUB.Count_And_Get(
1628: p_count => x_msg_count,
1629: p_data => x_msg_data,
1630: p_encoded => FND_API.G_FALSE

Line 1643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1639: --
1640:
1641: WHEN WSH_XC_INVALID_STATUS THEN
1642: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_STATUS');
1643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1644: wsh_util_core.add_message(x_return_status);
1645: FND_MSG_PUB.Count_And_Get(
1646: p_count => x_msg_count,
1647: p_data => x_msg_data,

Line 1644: wsh_util_core.add_message(x_return_status);

1640:
1641: WHEN WSH_XC_INVALID_STATUS THEN
1642: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_STATUS');
1643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1644: wsh_util_core.add_message(x_return_status);
1645: FND_MSG_PUB.Count_And_Get(
1646: p_count => x_msg_count,
1647: p_data => x_msg_data,
1648: p_encoded => FND_API.G_FALSE

Line 1661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1657: --
1658:
1659: WHEN WSH_PURGE_NOT_ALLOWED THEN
1660: FND_MESSAGE.SET_NAME('WSH','WSH_PURGE_NOT_ALLOWED');
1661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1662: wsh_util_core.add_message(x_return_status);
1663: FND_MSG_PUB.Count_And_Get(
1664: p_count => x_msg_count,
1665: p_data => x_msg_data,

Line 1662: wsh_util_core.add_message(x_return_status);

1658:
1659: WHEN WSH_PURGE_NOT_ALLOWED THEN
1660: FND_MESSAGE.SET_NAME('WSH','WSH_PURGE_NOT_ALLOWED');
1661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1662: wsh_util_core.add_message(x_return_status);
1663: FND_MSG_PUB.Count_And_Get(
1664: p_count => x_msg_count,
1665: p_data => x_msg_data,
1666: p_encoded => FND_API.G_FALSE

Line 1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1675: --
1676:
1677: WHEN WSH_XC_INVALID_DATE_RANGE THEN
1678: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_DATE_RANGE');
1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1680: wsh_util_core.add_message(x_return_status);
1681: FND_MSG_PUB.Count_And_Get(
1682: p_count => x_msg_count,
1683: p_data => x_msg_data,

Line 1680: wsh_util_core.add_message(x_return_status);

1676:
1677: WHEN WSH_XC_INVALID_DATE_RANGE THEN
1678: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_DATE_RANGE');
1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1680: wsh_util_core.add_message(x_return_status);
1681: FND_MSG_PUB.Count_And_Get(
1682: p_count => x_msg_count,
1683: p_data => x_msg_data,
1684: p_encoded => FND_API.G_FALSE

Line 1698: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1694:
1695: WHEN WSH_XC_INVALID_OPERATION THEN
1696: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_OPERATION');
1697: FND_MESSAGE.SET_TOKEN('REASON','Trying to Purge All Records',TRUE);
1698: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1699: wsh_util_core.add_message(x_return_status);
1700: FND_MSG_PUB.Count_And_Get(
1701: p_count => x_msg_count,
1702: p_data => x_msg_data,

Line 1699: wsh_util_core.add_message(x_return_status);

1695: WHEN WSH_XC_INVALID_OPERATION THEN
1696: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_OPERATION');
1697: FND_MESSAGE.SET_TOKEN('REASON','Trying to Purge All Records',TRUE);
1698: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1699: wsh_util_core.add_message(x_return_status);
1700: FND_MSG_PUB.Count_And_Get(
1701: p_count => x_msg_count,
1702: p_data => x_msg_data,
1703: p_encoded => FND_API.G_FALSE

Line 1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1713:
1714: WHEN WSH_XC_LOOKUP_LOG THEN
1715: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1716: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','LOGGING_ENTITY');
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1718: wsh_util_core.add_message(x_return_status);
1719: FND_MSG_PUB.Count_And_Get(
1720: p_count => x_msg_count,
1721: p_data => x_msg_data,

Line 1718: wsh_util_core.add_message(x_return_status);

1714: WHEN WSH_XC_LOOKUP_LOG THEN
1715: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1716: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','LOGGING_ENTITY');
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1718: wsh_util_core.add_message(x_return_status);
1719: FND_MSG_PUB.Count_And_Get(
1720: p_count => x_msg_count,
1721: p_data => x_msg_data,
1722: p_encoded => FND_API.G_FALSE

Line 1736: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1732:
1733: WHEN WSH_XC_LOOKUP_EXCEPTION THEN
1734: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1735: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','EXCEPTION_TYPE');
1736: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1737: wsh_util_core.add_message(x_return_status);
1738: FND_MSG_PUB.Count_And_Get(
1739: p_count => x_msg_count,
1740: p_data => x_msg_data,

Line 1737: wsh_util_core.add_message(x_return_status);

1733: WHEN WSH_XC_LOOKUP_EXCEPTION THEN
1734: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1735: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','EXCEPTION_TYPE');
1736: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1737: wsh_util_core.add_message(x_return_status);
1738: FND_MSG_PUB.Count_And_Get(
1739: p_count => x_msg_count,
1740: p_data => x_msg_data,
1741: p_encoded => FND_API.G_FALSE

Line 1755: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1751:
1752: WHEN WSH_XC_LOOKUP_SEVERITY THEN
1753: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1754: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','EXCEPTION_SEVERITY');
1755: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1756: wsh_util_core.add_message(x_return_status);
1757: FND_MSG_PUB.Count_And_Get(
1758: p_count => x_msg_count,
1759: p_data => x_msg_data,

Line 1756: wsh_util_core.add_message(x_return_status);

1752: WHEN WSH_XC_LOOKUP_SEVERITY THEN
1753: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOOKUP_TYPE');
1754: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE','EXCEPTION_SEVERITY');
1755: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1756: wsh_util_core.add_message(x_return_status);
1757: FND_MSG_PUB.Count_And_Get(
1758: p_count => x_msg_count,
1759: p_data => x_msg_data,
1760: p_encoded => FND_API.G_FALSE

Line 1773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1769: --
1770:
1771: WHEN WSH_INVALID_LOGGED_AT_LOCATION THEN
1772: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOGGED_AT_LOCATION');
1773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1774: wsh_util_core.add_message(x_return_status);
1775: FND_MSG_PUB.Count_And_Get(
1776: p_count => x_msg_count,
1777: p_data => x_msg_data,

Line 1774: wsh_util_core.add_message(x_return_status);

1770:
1771: WHEN WSH_INVALID_LOGGED_AT_LOCATION THEN
1772: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_LOGGED_AT_LOCATION');
1773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1774: wsh_util_core.add_message(x_return_status);
1775: FND_MSG_PUB.Count_And_Get(
1776: p_count => x_msg_count,
1777: p_data => x_msg_data,
1778: p_encoded => FND_API.G_FALSE

Line 1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1787: --
1788:
1789: WHEN WSH_INVALID_EXCEPTION_LOCATION THEN
1790: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_EXCEPTION_LOCATION');
1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1792: wsh_util_core.add_message(x_return_status);
1793: FND_MSG_PUB.Count_And_Get(
1794: p_count => x_msg_count,
1795: p_data => x_msg_data,

Line 1792: wsh_util_core.add_message(x_return_status);

1788:
1789: WHEN WSH_INVALID_EXCEPTION_LOCATION THEN
1790: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_EXCEPTION_LOCATION');
1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1792: wsh_util_core.add_message(x_return_status);
1793: FND_MSG_PUB.Count_And_Get(
1794: p_count => x_msg_count,
1795: p_data => x_msg_data,
1796: p_encoded => FND_API.G_FALSE

Line 1809: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1805: --
1806:
1807: WHEN WSH_XC_INVALID_DELIVERY THEN
1808: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_DEL_NAME');
1809: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1810: wsh_util_core.add_message(x_return_status);
1811: FND_MSG_PUB.Count_And_Get(
1812: p_count => x_msg_count,
1813: p_data => x_msg_data,

Line 1810: wsh_util_core.add_message(x_return_status);

1806:
1807: WHEN WSH_XC_INVALID_DELIVERY THEN
1808: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_DEL_NAME');
1809: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1810: wsh_util_core.add_message(x_return_status);
1811: FND_MSG_PUB.Count_And_Get(
1812: p_count => x_msg_count,
1813: p_data => x_msg_data,
1814: p_encoded => FND_API.G_FALSE

Line 1826: WSH_UTIL_CORE.default_handler('WSH_EXCEPTIONS_GRP.EXCEPTION_ACTION');

1822: END IF;
1823: --
1824:
1825: WHEN OTHERS THEN
1826: WSH_UTIL_CORE.default_handler('WSH_EXCEPTIONS_GRP.EXCEPTION_ACTION');
1827: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1828: IF FND_MSG_PUB.Check_Msg_Level
1829: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1830: THEN

Line 1827: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1823: --
1824:
1825: WHEN OTHERS THEN
1826: WSH_UTIL_CORE.default_handler('WSH_EXCEPTIONS_GRP.EXCEPTION_ACTION');
1827: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1828: IF FND_MSG_PUB.Check_Msg_Level
1829: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1830: THEN
1831: FND_MSG_PUB.Add_Exc_Msg

Line 1930: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1926: IF FND_API.to_boolean(p_init_msg_list) THEN
1927: FND_MSG_PUB.initialize;
1928: END IF;
1929:
1930: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1931:
1932: l_action := UPPER(p_action);
1933: IF (l_action NOT IN ( 'CHANGE_STATUS','PURGE','LOG' )) THEN
1934: RAISE WSH_INVALID_ACTION_CODE;

Line 2017: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

2013: x_updated_rows => l_updated_rows
2014: );
2015: END IF;
2016:
2017: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2018: FND_MESSAGE.SET_NAME('WSH','WSH_NO_OF_RECS_UPDATED');
2019: FND_MESSAGE.SET_TOKEN('NO_OF_RECS',l_updated_rows);
2020: END IF;
2021: END IF;

Line 2023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2019: FND_MESSAGE.SET_TOKEN('NO_OF_RECS',l_updated_rows);
2020: END IF;
2021: END IF;
2022:
2023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2024: x_return_status := l_return_status;
2025: END IF;
2026:
2027: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) AND

Line 2027: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) AND

2023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2024: x_return_status := l_return_status;
2025: END IF;
2026:
2027: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) AND
2028: FND_API.To_Boolean(p_commit) THEN
2029: COMMIT WORK;
2030: END IF;
2031:

Line 2049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2045: EXCEPTION
2046: WHEN WSH_INVALID_ACTION_CODE THEN
2047: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
2048: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action);
2049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2050: wsh_util_core.add_message(x_return_status);
2051: FND_MSG_PUB.Count_And_Get(
2052: p_count => x_msg_count,
2053: p_data => x_msg_data,

Line 2050: wsh_util_core.add_message(x_return_status);

2046: WHEN WSH_INVALID_ACTION_CODE THEN
2047: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
2048: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action);
2049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2050: wsh_util_core.add_message(x_return_status);
2051: FND_MSG_PUB.Count_And_Get(
2052: p_count => x_msg_count,
2053: p_data => x_msg_data,
2054: p_encoded => FND_API.G_FALSE

Line 2066: WSH_UTIL_CORE.default_handler('WSH_EXCEPTIONS_GRP.EXCEPTION_ACTION');

2062: END IF;
2063: --
2064:
2065: WHEN OTHERS THEN
2066: WSH_UTIL_CORE.default_handler('WSH_EXCEPTIONS_GRP.EXCEPTION_ACTION');
2067: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2068: IF FND_MSG_PUB.Check_Msg_Level
2069: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2070: THEN

Line 2067: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2063: --
2064:
2065: WHEN OTHERS THEN
2066: WSH_UTIL_CORE.default_handler('WSH_EXCEPTIONS_GRP.EXCEPTION_ACTION');
2067: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2068: IF FND_MSG_PUB.Check_Msg_Level
2069: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2070: THEN
2071: FND_MSG_PUB.Add_Exc_Msg