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

Line 44: l_dummy_exception_list WSH_UTIL_CORE.column_tab_type;

40: l_api_name CONSTANT VARCHAR2(30):= 'validate_constraint';
41:
42: l_validate_result VARCHAR2(1) := 'S'; -- Constraint Validation result : S / F
43: l_action_code VARCHAR2(30) := NULL;
44: l_dummy_exception_list WSH_UTIL_CORE.column_tab_type;
45:
46: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type; -- Either of the next two
47: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
48: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;

Line 46: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type; -- Either of the next two

42: l_validate_result VARCHAR2(1) := 'S'; -- Constraint Validation result : S / F
43: l_action_code VARCHAR2(30) := NULL;
44: l_dummy_exception_list WSH_UTIL_CORE.column_tab_type;
45:
46: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type; -- Either of the next two
47: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
48: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
49: l_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;

Line 64: l_fail_trips WSH_UTIL_CORE.id_tab_type;

60: l_trip_rec WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
61: l_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
62: l_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
63: l_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
64: l_fail_trips WSH_UTIL_CORE.id_tab_type;
65:
66: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
67: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_package_name || '.' || 'validate_constraint';
68:

Line 71: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

67: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_package_name || '.' || 'validate_constraint';
68:
69: BEGIN
70:
71: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
72:
73: IF l_debug_on THEN
74: wsh_debug_sv.push (l_module_name);
75: END IF;

Line 177: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

173: x_msg_data => x_msg_data,
174: x_return_status => l_return_status);
175:
176:
177: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSE
180: x_return_status := l_return_status;
181: IF l_debug_on THEN

Line 185: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

181: IF l_debug_on THEN
182: wsh_debug_sv.logmsg(l_module_name,'failed line count : '||l_fail_trips.COUNT);
183: END IF;
184:
185: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
186:
187: l:=p_entity_tab.FIRST;
188: IF l IS NOT NULL THEN
189: LOOP

Line 243: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

239: x_msg_data => x_msg_data,
240: x_return_status => l_return_status);
241:
242:
243: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: ELSE
246: x_return_status := l_return_status;
247:

Line 248: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: ELSE
246: x_return_status := l_return_status;
247:
248: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
249:
250: IF l_debug_on THEN
251: wsh_debug_sv.logmsg(l_module_name,'failed line count : '||l_failed_lines.COUNT);
252: END IF;

Line 294: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

290: END IF;
291: --
292: EXCEPTION
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
295: --
296: IF l_debug_on THEN
297: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
298: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 302: WSH_UTIL_CORE.default_handler('WSH_FTE_COMP_CONSTRAINT_GRP.validate_constraint');

298: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
299: END IF;
300: --
301: WHEN others THEN
302: WSH_UTIL_CORE.default_handler('WSH_FTE_COMP_CONSTRAINT_GRP.validate_constraint');
303: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
304: --
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 303: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

299: END IF;
300: --
301: WHEN others THEN
302: WSH_UTIL_CORE.default_handler('WSH_FTE_COMP_CONSTRAINT_GRP.validate_constraint');
303: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
304: --
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 330: p_input_delivery_id_tab IN WSH_UTIL_CORE.id_tab_type,

326: -- This procedure is called from WMS.
327: --
328: --========================================================================
329: PROCEDURE is_valid_consol( p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
330: p_input_delivery_id_tab IN WSH_UTIL_CORE.id_tab_type,
331: p_target_consol_delivery_id IN NUMBER,
332: p_caller IN VARCHAR2 DEFAULT NULL,
333: x_deconsolidation_location OUT NOCOPY NUMBER,
334: x_return_status OUT NOCOPY VARCHAR2,

Line 348: l_in_ids WSH_UTIL_CORE.id_tab_type;

344: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
345: l_msg_count NUMBER;
346: l_msg_data VARCHAR2(2000) := NULL;
347: l_return_status VARCHAR2(1);
348: l_in_ids WSH_UTIL_CORE.id_tab_type;
349: l_deconsol_location NUMBER;
350: l_prev_deconsol_location NUMBER;
351: l_consol_drop_off_loc NUMBER;
352: l_consol_trip_id NUMBER;

Line 358: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;

354: l_pre_consolidation_del NUMBER;
355: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
356: l_target_trip_stop WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
357: d_itr NUMBER;
358: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
359: x_output_id_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;
360:
361: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
362: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

Line 397: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

393:
394:
395: BEGIN
396: --{
397: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
398:
399: IF l_debug_on THEN
400: wsh_debug_sv.push (l_module_name);
401: END IF;

Line 445: --IF l_line_groups.COUNT > 1 OR l_failed_lines.COUNT > 0 OR (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

441: --
442: -- If more than one group formed, error out
443: --
444: -- AG number of groups is record structure l_group_info not l_line_groups
445: --IF l_line_groups.COUNT > 1 OR l_failed_lines.COUNT > 0 OR (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
446: IF l_group_info.COUNT > 1 OR l_failed_lines.COUNT > 0 OR (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
447: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
448: -- AG
449: -- Treat l_return_status = WARNING as success

Line 446: IF l_group_info.COUNT > 1 OR l_failed_lines.COUNT > 0 OR (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

442: -- If more than one group formed, error out
443: --
444: -- AG number of groups is record structure l_group_info not l_line_groups
445: --IF l_line_groups.COUNT > 1 OR l_failed_lines.COUNT > 0 OR (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
446: IF l_group_info.COUNT > 1 OR l_failed_lines.COUNT > 0 OR (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
447: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
448: -- AG
449: -- Treat l_return_status = WARNING as success
450:

Line 447: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

443: --
444: -- AG number of groups is record structure l_group_info not l_line_groups
445: --IF l_line_groups.COUNT > 1 OR l_failed_lines.COUNT > 0 OR (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
446: IF l_group_info.COUNT > 1 OR l_failed_lines.COUNT > 0 OR (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
447: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
448: -- AG
449: -- Treat l_return_status = WARNING as success
450:
451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

447: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
448: -- AG
449: -- Treat l_return_status = WARNING as success
450:
451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
452: FND_MESSAGE.SET_NAME('WSH','WSH_CONSOL_VALIDATION_ERROR');
453: FND_MSG_PUB.ADD;
454: IF l_debug_on THEN
455: wsh_debug_sv.pop (l_module_name);

Line 491: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

487: IF l_pre_consolidation_del IS NOT NULL THEN
488: IF l_prev_consolidation_del IS NULL THEN
489: l_prev_consolidation_del := l_pre_consolidation_del;
490: ELSIF l_prev_consolidation_del <> l_pre_consolidation_del OR l_pre_consolidation_del <> p_target_consol_delivery_id THEN
491: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
492: FND_MESSAGE.SET_NAME('WSH','WSH_MULTICONSOL_ERROR');
493: FND_MSG_PUB.ADD;
494: IF l_debug_on THEN
495: wsh_debug_sv.pop (l_module_name);

Line 517: IF x_output_id_tab(1).validation_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

513: -- If deconsolidation location found for any of the
514: -- delivery is different, error out
515: --
516:
517: IF x_output_id_tab(1).validation_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
518:
519: IF l_delivery_info.COUNT > 0 THEN
520: l_delivery_info.DELETE;
521: END IF;

Line 530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

526: l_prev_deconsol_location := l_deconsol_location;
527: END IF;
528:
529: IF l_deconsol_location <> l_prev_deconsol_location THEN
530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
531: FND_MESSAGE.SET_NAME('WSH','WSH_CONSOL_VALIDATION_ERROR');
532: FND_MSG_PUB.ADD;
533: IF l_debug_on THEN
534: wsh_debug_sv.pop (l_module_name);

Line 539: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

535: END IF;
536: RETURN;
537: END IF;
538: ELSE
539: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
540: FND_MESSAGE.SET_NAME('WSH','WSH_CONSOL_VALIDATION_ERROR');
541: FND_MSG_PUB.ADD;
542: IF l_debug_on THEN
543: wsh_debug_sv.pop (l_module_name);

Line 611: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

607:
608: -- AG
609: -- Treat warning as Success
610:
611: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
612: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
613: x_deconsolidation_location := l_deconsol_location;
614: ELSE
615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 612: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

608: -- AG
609: -- Treat warning as Success
610:
611: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
612: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
613: x_deconsolidation_location := l_deconsol_location;
614: ELSE
615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
616: FND_MESSAGE.SET_NAME('WSH','WSH_CONSOL_VALIDATION_ERROR');

Line 615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

611: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
612: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
613: x_deconsolidation_location := l_deconsol_location;
614: ELSE
615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
616: FND_MESSAGE.SET_NAME('WSH','WSH_CONSOL_VALIDATION_ERROR');
617: FND_MSG_PUB.ADD;
618: IF l_debug_on THEN
619: wsh_debug_sv.pop (l_module_name);

Line 624: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

620: END IF;
621: RETURN;
622: END IF;
623: ELSE -- Bug 5194370
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
625: x_deconsolidation_location := l_deconsol_location;
626: END IF;
627:
628: --}

Line 630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

626: END IF;
627:
628: --}
629: ELSE
630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
631: FND_MESSAGE.SET_NAME('WSH','WSH_CONSOL_VALIDATION_ERROR');
632: FND_MSG_PUB.ADD;
633: IF l_debug_on THEN
634: wsh_debug_sv.pop (l_module_name);

Line 644: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

640: -- AG
641: -- If input deliveries do not get back any deconsol_location above
642: -- should they rather be allowed to be assigned to p_target_consol_delivery_id
643: ELSIF p_target_consol_delivery_id IS NOT NULL THEN
644: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
645: FND_MESSAGE.SET_NAME('WSH','WSH_CONSOL_VALIDATION_ERROR');
646: FND_MSG_PUB.ADD;
647: IF l_debug_on THEN
648: wsh_debug_sv.pop (l_module_name);

Line 668: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

664:
665: EXCEPTION
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
669: --
670: IF l_debug_on THEN
671: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
672: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 682: WSH_UTIL_CORE.default_handler('WSH_FTE_COMP_CONSTRAINT_GRP.is_valid_consol');

678: END IF;
679: IF c_get_dlvy_trip_id%ISOPEN THEN
680: CLOSE c_get_dlvy_trip_id;
681: END IF;
682: WSH_UTIL_CORE.default_handler('WSH_FTE_COMP_CONSTRAINT_GRP.is_valid_consol');
683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
684: --
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

679: IF c_get_dlvy_trip_id%ISOPEN THEN
680: CLOSE c_get_dlvy_trip_id;
681: END IF;
682: WSH_UTIL_CORE.default_handler('WSH_FTE_COMP_CONSTRAINT_GRP.is_valid_consol');
683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
684: --
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
687: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');