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

Line 190: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

186: WSH_DEBUG_SV.log(l_module_name, 'UPDATE_MOT_SL',
187: p_Carrier_Service_Info.UPDATE_MOT_SL);
188: END IF;
189: --
190: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
191: IF (l_Carrier_service_id is NULL) THEN
192: OPEN C_Next_id;
193: FETCH C_Next_id INTO l_Carrier_Service_Id;
194: CLOSE C_Next_id;

Line 411: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

407: END IF;
408: --
409: EXCEPTION
410: WHEN others THEN
411: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
412: X_position := l_position;
413: X_procedure := l_procedure;
414: X_SQLERR := SQLERRM;
415: X_sql_code := SQLCODE;

Line 684: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

680: -- R12 Code changes
681:
682: END IF;
683: --
684: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
685:
686: OPEN C_lock_row;
687: FETCH C_lock_row INTO Recinfo;
688:

Line 692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

688:
689: IF (C_lock_row%NOTFOUND) THEN
690: CLOSE C_lock_row;
691: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
693: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
694: --
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');

Line 693: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

689: IF (C_lock_row%NOTFOUND) THEN
690: CLOSE C_lock_row;
691: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
693: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
694: --
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
697: WSH_DEBUG_SV.pop(l_module_name);

Line 992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

988:
989: IF (C_lookup_row%NOTFOUND) THEN
990: CLOSE C_lookup_row;
991: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
993: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
994: --
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');

Line 993: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

989: IF (C_lookup_row%NOTFOUND) THEN
990: CLOSE C_lookup_row;
991: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
992: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
993: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
994: --
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');
997: WSH_DEBUG_SV.pop(l_module_name);

Line 1065: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1061: IF (C_lookup_row%ISOPEN) THEN
1062: CLOSE C_lookup_row;
1063: END IF;
1064:
1065: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1066: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SERVICES_PKG.Lock_Carrier_Service',l_module_name);
1067: --
1068: IF l_debug_on THEN
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1066: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SERVICES_PKG.Lock_Carrier_Service',l_module_name);

1062: CLOSE C_lookup_row;
1063: END IF;
1064:
1065: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1066: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SERVICES_PKG.Lock_Carrier_Service',l_module_name);
1067: --
1068: IF l_debug_on THEN
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1070: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1149: --
1150: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1151: END IF;
1152: --
1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1154:
1155: l_position := 10;
1156: l_procedure := 'Updating WSH_CARRIER_SERVICES';
1157:

Line 1225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1221: IF (SQL%NOTFOUND) THEN
1222: IF l_debug_on THEN
1223: WSH_DEBUG_SV.log(l_module_name,'SQL%NOTFOUND');
1224: END IF;
1225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1226: RAISE NO_DATA_FOUND;
1227: END IF;
1228:
1229: l_position := 20;

Line 1239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1235:
1236: IF (C_lookup_row%NOTFOUND) THEN
1237: CLOSE C_lookup_row;
1238: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1240: IF l_debug_on THEN
1241: WSH_DEBUG_SV.log(l_module_name,'C_lookup_row%NOTFOUND');
1242: WSH_DEBUG_SV.log(l_module_name, 'Cursor opened successfully called from update_carrier_service procedure'); --Bug3330869
1243: END IF;

Line 1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1337: x_position := l_position;
1338: x_procedure := l_procedure;
1339: x_sqlerr := sqlerrm;
1340: x_sql_code := sqlcode;
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1342: --
1343: IF l_debug_on THEN
1344: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1345: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 1354: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1350: x_position := l_position;
1351: x_procedure := l_procedure;
1352: x_sqlerr := sqlerrm;
1353: x_sql_code := sqlcode;
1354: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1355: IF l_debug_on THEN
1356: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1357: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1358: END IF;

Line 1389: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1385: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_METHOD_CODE',p_ship_method_code);
1386: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CODE',p_freight_code);
1387: END IF;
1388: --
1389: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1390:
1391: l_position := 10;
1392: l_procedure := 'Updating WSH_CARRIER_SHIP_METHODS';
1393:

Line 1418: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1414: x_position := l_position;
1415: x_procedure := l_procedure;
1416: x_sqlerr := sqlerrm;
1417: x_sql_code := sqlcode;
1418: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1419: --
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');