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

Line 52: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND

48: --
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: SAVEPOINT WSH_Rate_Delivery;
51:
52: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
53: ((p_in_param_rec.delivery_id_list.COUNT > 0) AND p_in_param_rec.action is NOT null) THEN
54:
55: --
56: IF l_debug_on THEN

Line 75: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

71: x_return_status => l_return_status,
72: x_msg_count => l_msg_count,
73: x_msg_data => l_msg_data);
74:
75: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
76: x_return_status := l_return_status;
77: END IF;
78: x_msg_count := l_msg_count;
79: x_msg_data := l_msg_data;

Line 91: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

87: --
88: EXCEPTION
89: WHEN others THEN
90: ROLLBACK TO WSH_Rate_Delivery;
91: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
92: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Rate_Delivery',l_module_name);
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 92: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Rate_Delivery',l_module_name);

88: EXCEPTION
89: WHEN others THEN
90: ROLLBACK TO WSH_Rate_Delivery;
91: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
92: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Rate_Delivery',l_module_name);
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
96: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 105: p_delivery_list IN WSH_UTIL_CORE.id_tab_type,

101: -- WSH get_rate_from_FTE demo flow (multiple deliveries)
102: PROCEDURE Cancel_Service (
103: p_api_version IN NUMBER DEFAULT 1.0,
104: p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE,
105: p_delivery_list IN WSH_UTIL_CORE.id_tab_type,
106: p_action IN VARCHAR2 DEFAULT 'CANCEL',
107: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,

Line 146: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND

142: --
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144: SAVEPOINT WSH_Cancel_Service;
145:
146: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
147: (p_delivery_list.COUNT > 0 AND p_action is NOT null) THEN
148:
149: --
150: IF l_debug_on THEN

Line 165: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

161: x_return_status => l_return_status,
162: x_msg_count => l_msg_count,
163: x_msg_data => l_msg_data);
164:
165: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
166: x_return_status := l_return_status;
167: END IF;
168: x_msg_count := l_msg_count;
169: x_msg_data := l_msg_data;

Line 180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

176: --
177: EXCEPTION
178: WHEN others THEN
179: ROLLBACK TO WSH_Cancel_Service;
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
182: --
183: IF l_debug_on THEN
184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 181: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);

177: EXCEPTION
178: WHEN others THEN
179: ROLLBACK TO WSH_Cancel_Service;
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
182: --
183: IF l_debug_on THEN
184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 234: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND

230: --
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: SAVEPOINT WSH_Cancel_Service_2;
233:
234: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
235: (p_delivery_id is NOT null AND p_action is NOT null) THEN
236:
237: --
238: IF l_debug_on THEN

Line 253: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

249: x_return_status => l_return_status,
250: x_msg_count => l_msg_count,
251: x_msg_data => l_msg_data);
252:
253: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
254: x_return_status := l_return_status;
255: END IF;
256: x_msg_count := l_msg_count;
257: x_msg_data := l_msg_data;

Line 268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

264: --
265: EXCEPTION
266: WHEN others THEN
267: ROLLBACK TO WSH_Cancel_Service_2;
268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
269: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
270: --
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 269: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);

265: EXCEPTION
266: WHEN others THEN
267: ROLLBACK TO WSH_Cancel_Service_2;
268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
269: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
270: --
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
273: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 314: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND

310: --
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312: SAVEPOINT before_changes;
313:
314: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
315: (p_delivery_leg_id is NOT null OR p_trip_id is NOT null) THEN
316:
317: l_in_attributes.api_version_number := 1.0;
318: l_in_attributes.delivery_leg_id := p_delivery_leg_id;

Line 331: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

327: p_in_attributes => l_in_attributes,
328: x_return_status => l_return_status,
329: x_msg_count => l_msg_count,
330: x_msg_data => l_msg_data );
331: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
332: x_return_status := l_return_status;
333: END IF;
334: END IF;
335: --

Line 344: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

340: --
341: EXCEPTION
342: WHEN others THEN
343: ROLLBACK TO before_changes;
344: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
345: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Shipment_Price_Consolidate',l_module_name);
346: --
347: IF l_debug_on THEN
348: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 345: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Shipment_Price_Consolidate',l_module_name);

341: EXCEPTION
342: WHEN others THEN
343: ROLLBACK TO before_changes;
344: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
345: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Shipment_Price_Consolidate',l_module_name);
346: --
347: IF l_debug_on THEN
348: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
349: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 391: l_return_status VARCHAR2(30):= WSH_UTIL_CORE.G_RET_STS_SUCCESS;

387:
388:
389: l_msg_count NUMBER;
390: l_msg_data VARCHAR2(4000);
391: l_return_status VARCHAR2(30):= WSH_UTIL_CORE.G_RET_STS_SUCCESS;
392:
393:
394: --
395: l_debug_on BOOLEAN;

Line 425: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN

421: l_trip_rec_old := l_trip_rec_null;
422: l_trip_rec_new := l_trip_rec_null;
423: l_stops_trip_rec := l_trip_rec_null;
424: /* NEW MESSAGE here */
425: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN
426: FND_MESSAGE.SET_NAME('WSH','FTE NOT INSTALLED');
427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
428: --
429: IF l_debug_on THEN

Line 427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

423: l_stops_trip_rec := l_trip_rec_null;
424: /* NEW MESSAGE here */
425: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN
426: FND_MESSAGE.SET_NAME('WSH','FTE NOT INSTALLED');
427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
428: --
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.log(l_module_name,'FTE NOT INSTALLE');
431: WSH_DEBUG_SV.pop(l_module_name);

Line 438: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

434: RETURN;
435: END IF;
436:
437:
438: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
439:
440: --1. Creating Stop
441: IF (p_action = 'ADD'
442: AND (p_stop_rec.stop_location_id <> FND_API.G_MISS_NUM)

Line 651: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);

647:
648: ELSE
649: IF p_action NOT IN ('ADD','UPDATE','DELETE') THEN
650: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CALL_TO_FTE');
651: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
652: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
653: ELSE
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.log(l_module_name,'WSH_INVALID_CALL_TO_FTE');

Line 652: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

648: ELSE
649: IF p_action NOT IN ('ADD','UPDATE','DELETE') THEN
650: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CALL_TO_FTE');
651: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
652: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
653: ELSE
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.log(l_module_name,'WSH_INVALID_CALL_TO_FTE');
656: END IF;

Line 660: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

656: END IF;
657: END IF;
658: END IF;
659:
660: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
661: x_return_status := l_return_status;
662: END IF;
663:
664: --

Line 672: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.trip_stop_validations',l_module_name);

668: END IF;
669: --
670: EXCEPTION
671: WHEN OTHERS THEN
672: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.trip_stop_validations',l_module_name);
673: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
674: --
675: IF l_debug_on THEN
676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 673: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

669: --
670: EXCEPTION
671: WHEN OTHERS THEN
672: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.trip_stop_validations',l_module_name);
673: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
674: --
675: IF l_debug_on THEN
676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 699: l_unexp_char VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

695: --
696: -- Local Variable Declarations
697: --
698: l_result VARCHAR2(2000);
699: l_unexp_char VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
700:
701:
702: --
703: -- Variables used for error handling

Line 752: --WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.get_cc_object_name');

748: EXCEPTION
749: WHEN OTHERS THEN
750: l_error_code := SQLCODE;
751: l_error_text := SQLERRM;
752: --WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.get_cc_object_name');
753: --
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.get_cc_object_name IS ' ||L_ERROR_TEXT );
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 787: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

783: FETCH get_vehicle_type INTO x_vehicle_type_id;
784: CLOSE get_vehicle_type;
785:
786: IF (x_vehicle_type_id IS NOT NULL) THEN
787: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
788: ELSE
789: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
790: END IF;
791:

Line 789: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

785:
786: IF (x_vehicle_type_id IS NOT NULL) THEN
787: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
788: ELSE
789: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
790: END IF;
791:
792: EXCEPTION WHEN OTHERS THEN
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

789: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
790: END IF;
791:
792: EXCEPTION WHEN OTHERS THEN
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
794:
795: END;
796:
797: PROCEDURE GET_VEHICLE_ORG_ID

Line 804: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

800: x_return_status OUT NOCOPY VARCHAR2) IS
801:
802: BEGIN
803:
804: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
805:
806: x_vehicle_org_id:=FTE_VEHICLE_PKG.GET_VEHICLE_ORG_ID
807: (p_inventory_item_id => p_inventory_item_id);
808:

Line 810: x_return_status:= WSH_UTIL_CORE.G_RET_STS_ERROR;

806: x_vehicle_org_id:=FTE_VEHICLE_PKG.GET_VEHICLE_ORG_ID
807: (p_inventory_item_id => p_inventory_item_id);
808:
809: IF (x_vehicle_org_id IS NULL OR x_vehicle_org_id=-1) THEN
810: x_return_status:= WSH_UTIL_CORE.G_RET_STS_ERROR;
811: END IF;
812:
813: EXCEPTION WHEN OTHERS THEN
814: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 814: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

810: x_return_status:= WSH_UTIL_CORE.G_RET_STS_ERROR;
811: END IF;
812:
813: EXCEPTION WHEN OTHERS THEN
814: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
815: END;
816:
817: PROCEDURE Rate_Trip (
818: p_api_version IN NUMBER DEFAULT 1.0,

Line 888: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND

884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885:
886: SAVEPOINT WSH_Rate_Trip;
887:
888: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
889: (p_action_params.event is not null AND p_action_params.caller ='WSH'
890: AND p_action_params.action is not null) THEN
891:
892: --

Line 937: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

933: x_msg_count => l_msg_count,
934: x_msg_data => l_msg_data);
935:
936:
937: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
938: x_return_status := l_return_status;
939: END IF;
940: x_msg_count := l_msg_count;
941: x_msg_data := l_msg_data;

Line 952: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

948: --
949: EXCEPTION
950: WHEN others THEN
951: ROLLBACK TO WSH_Rate_Trip;
952: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
953: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.RATE_TRIP',l_module_name);
954: --
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 953: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.RATE_TRIP',l_module_name);

949: EXCEPTION
950: WHEN others THEN
951: ROLLBACK TO WSH_Rate_Trip;
952: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
953: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.RATE_TRIP',l_module_name);
954: --
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 975: p_trip_id_tab IN WSH_UTIL_CORE.id_tab_type,

971: -- +====================================================+
972: PROCEDURE Trip_Action (
973: p_api_version IN NUMBER DEFAULT 1.0,
974: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
975: p_trip_id_tab IN WSH_UTIL_CORE.id_tab_type,
976: p_action_params IN wsh_trip_action_param_rec,
977: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
978: x_action_out_rec OUT NOCOPY wsh_trip_action_out_rec,
979: x_return_status OUT NOCOPY VARCHAR2,

Line 988: l_wsh_result_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

984: l_fte_trip_action_param_rec FTE_TRIP_ACTION_PARAM_REC;
985: l_fte_action_out_rec FTE_ACTION_OUT_REC;
986: l_fte_trip_id_tab FTE_ID_TAB_TYPE; -- := FTE_ID_TAB_TYPE(41343);
987:
988: l_wsh_result_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
989: l_wsh_valid_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
990:
991: l_return_status VARCHAR2(1);
992: l_msg_count NUMBER := 0;

Line 989: l_wsh_valid_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

985: l_fte_action_out_rec FTE_ACTION_OUT_REC;
986: l_fte_trip_id_tab FTE_ID_TAB_TYPE; -- := FTE_ID_TAB_TYPE(41343);
987:
988: l_wsh_result_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
989: l_wsh_valid_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
990:
991: l_return_status VARCHAR2(1);
992: l_msg_count NUMBER := 0;
993: l_msg_data VARCHAR2(4000);

Line 1031: IF (WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND

1027: SAVEPOINT WSH_Trip_Action;
1028:
1029: -- Check if FTE is installed
1030: -- J+ project for Auto Tender
1031: IF (WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND
1032: p_action_params.action_code = 'TENDER') THEN
1033:
1034: --
1035: IF l_debug_on THEN

Line 1083: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1079: x_msg_count => l_msg_count,
1080: x_msg_data => l_msg_data
1081: );
1082:
1083: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1084: x_return_status := l_return_status;
1085: END IF;
1086:
1087: x_msg_count := l_msg_count;

Line 1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1122: --
1123: EXCEPTION
1124: WHEN others THEN
1125: ROLLBACK TO WSH_Trip_Action;
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1127: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.TRIP_ACTION',l_module_name);
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1127: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.TRIP_ACTION',l_module_name);

1123: EXCEPTION
1124: WHEN others THEN
1125: ROLLBACK TO WSH_Trip_Action;
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1127: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.TRIP_ACTION',l_module_name);
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1189: WSH_DEBUG_SV.push(l_module_name);
1190: END IF;
1191:
1192: --
1193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1194: x_return_message := null;
1195:
1196: IF WSH_UTIL_CORE.FTE_Is_Installed <> 'Y' THEN
1197: return;

Line 1196: IF WSH_UTIL_CORE.FTE_Is_Installed <> 'Y' THEN

1192: --
1193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1194: x_return_message := null;
1195:
1196: IF WSH_UTIL_CORE.FTE_Is_Installed <> 'Y' THEN
1197: return;
1198: END IF;
1199:
1200: --

Line 1327: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.CARRIER_SELECTION');

1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.CARRIER_SELECTION IS ' ||L_ERROR_TEXT );
1325: END IF;
1326: --
1327: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.CARRIER_SELECTION');
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1329: x_return_message := l_error_text;
1330: --
1331: IF l_debug_on THEN

Line 1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1324: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.CARRIER_SELECTION IS ' ||L_ERROR_TEXT );
1325: END IF;
1326: --
1327: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.CARRIER_SELECTION');
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1329: x_return_message := l_error_text;
1330: --
1331: IF l_debug_on THEN
1332: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1387: IF (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN

1383: --
1384:
1385: x_return_status := FND_API.G_RET_STS_SUCCESS;
1386:
1387: IF (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1388:
1389: -- Copy p_ranked_list to FTE_CARRIER_RANK_LIST_PVT.CARRIER_RANK_LIST_TBL_TYPE
1390:
1391: list_cnt := p_ranklist.FIRST;

Line 1449: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1445: END LOOP;
1446: END IF;
1447:
1448:
1449: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1450: x_return_status := l_return_status;
1451: END IF;
1452:
1453: x_msg_count := l_msg_count;

Line 1473: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.RANK_LIST_ACTION');

1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.RANK_LIST_ACTION IS ' ||L_ERROR_TEXT );
1471: END IF;
1472: --
1473: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.RANK_LIST_ACTION');
1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1475: x_msg_data := l_error_text;
1476: --
1477: IF l_debug_on THEN

Line 1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1470: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.RANK_LIST_ACTION IS ' ||L_ERROR_TEXT );
1471: END IF;
1472: --
1473: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.RANK_LIST_ACTION');
1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1475: x_msg_data := l_error_text;
1476: --
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1520: IF (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN

1516: WSH_DEBUG_SV.logmsg(l_module_name, 'trip id : ' ||p_trip_id );
1517: END IF;
1518: --
1519:
1520: IF (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1521:
1522: OPEN c_get_trip_cmove(p_trip_id);
1523: --LOOP
1524: FETCH c_get_trip_cmove INTO l_move_id;

Line 1558: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.GET_TRIP_MOVE');

1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.GET_TRIP_MOVE IS ' ||L_ERROR_TEXT );
1556: END IF;
1557: --
1558: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.GET_TRIP_MOVE');
1559: --
1560: IF l_debug_on THEN
1561: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1613: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1609: IF l_debug_on THEN
1610: WSH_DEBUG_SV.push(l_module_name);
1611: END IF;
1612:
1613: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1614:
1615: FTE_ACS_TRIP_PKG.CARRIER_SEL_CREATE_TRIP(
1616: p_delivery_id => p_delivery_id,
1617: p_carrier_sel_result_rec => p_carrier_sel_result_rec,

Line 1623: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

1619: x_trip_name => x_trip_name,
1620: x_return_message => x_return_message,
1621: x_return_status => x_return_status);
1622:
1623: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1624: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1625: END IF;
1626:
1627: --

Line 1637: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP',l_module_name);

1633:
1634: EXCEPTION
1635:
1636: WHEN OTHERS THEN
1637: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP',l_module_name);
1638:
1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1640:
1641: IF l_debug_on THEN

Line 1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1635:
1636: WHEN OTHERS THEN
1637: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP',l_module_name);
1638:
1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1640:
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.pop(l_module_name,'When Others');
1643: END IF;

Line 1675: -- WSH_UTIL_CORE.FTE_Is_Installed value.

1671: -- This procedure is a wrapper for
1672: -- FTE_WSH_INTEGRATION_PKG.GET_ORG_ORGANIZATION_INFO
1673: --
1674: -- FTE will always be called regardless of
1675: -- WSH_UTIL_CORE.FTE_Is_Installed value.
1676: --
1677: -- ----------------------------------------------------------------------
1678: PROCEDURE GET_ORG_ORGANIZATION_INFO(
1679: p_init_msg_list IN VARCHAR2,

Line 1711: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1707: 'Calling FTE_WSH_INTEGRATION_PKG.GET_ORG_ORGANIZATION_INFO',
1708: WSH_DEBUG_SV.C_PROC_LEVEL);
1709: END IF;
1710:
1711: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1712:
1713: FTE_WSH_INTERFACE_PKG.GET_ORG_ORGANIZATION_INFO(
1714: p_init_msg_list => p_init_msg_list,
1715: x_return_status => x_return_status,

Line 1738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1734: EXCEPTION
1735:
1736: WHEN OTHERS THEN
1737:
1738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1739: wsh_util_core.default_handler(
1740: 'WSH_FTE_INTEGRATION.GET_ORG_ORGANIZATION_INFO',
1741: l_module_name);
1742:

Line 1739: wsh_util_core.default_handler(

1735:
1736: WHEN OTHERS THEN
1737:
1738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1739: wsh_util_core.default_handler(
1740: 'WSH_FTE_INTEGRATION.GET_ORG_ORGANIZATION_INFO',
1741: l_module_name);
1742:
1743: IF l_debug_on THEN

Line 1786: p_trip_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE)

1782: x_return_status OUT NOCOPY VARCHAR2,
1783: x_msg_count OUT NOCOPY NUMBER,
1784: x_msg_data OUT NOCOPY VARCHAR2,
1785: p_source IN VARCHAR2,
1786: p_trip_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE)
1787: IS
1788:
1789: l_debug_on BOOLEAN;
1790: l_module_name CONSTANT VARCHAR2(100) :=

Line 1815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1811: WSH_DEBUG_SV.log(l_module_name, 'p_trip_id_tab.COUNT',
1812: p_trip_id_tab.COUNT);
1813: END IF;
1814:
1815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1816:
1817: IF p_trip_id_tab.COUNT > 0
1818: AND (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1819:

Line 1818: AND (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN

1814:
1815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1816:
1817: IF p_trip_id_tab.COUNT > 0
1818: AND (WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1819:
1820: IF l_debug_on THEN
1821: WSH_DEBUG_SV.logmsg(l_module_name,
1822: 'Selecting WSH_TRIPS into rank list');

Line 1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1933: EXCEPTION
1934:
1935: WHEN OTHERS THEN
1936:
1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1938: wsh_util_core.default_handler(
1939: 'WSH_FTE_INTEGRATION.CREATE_RANK_LIST_BULK',
1940: l_module_name);
1941:

Line 1938: wsh_util_core.default_handler(

1934:
1935: WHEN OTHERS THEN
1936:
1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1938: wsh_util_core.default_handler(
1939: 'WSH_FTE_INTEGRATION.CREATE_RANK_LIST_BULK',
1940: l_module_name);
1941:
1942: IF l_debug_on THEN