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

Line 42: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

38: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_MIN_MAX_TOLERANCE_QUANTITY';
39: --
40: BEGIN
41: --
42: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
43: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
44: --
45: IF l_debug_on IS NULL
46: THEN

Line 88: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN

84: IF l_debug_on THEN
85: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity',x_return_status);
86: END IF;
87:
88: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
89: IF l_debug_on THEN
90: WSH_DEBUG_SV.pop(l_module_name);
91: END IF;
92: return;

Line 239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

235: WHEN OTHERS THEN
236: l_untrxd_rec_count := null;
237: x_msg_count := 1;
238: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
240:
241: END;
242: BEGIN
243: -- Check for Expense Destination Type Code Receiving Transactions

Line 278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

274: WHEN OTHERS THEN
275: l_rec_exp_count := null;
276: x_msg_count := 1;
277: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
279: END;
280:
281: BEGIN
282: -- Check for Direct Shipment which are not Expense Destination Type Code Related

Line 321: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

317: WHEN OTHERS THEN
318: l_rec_direct_count := null;
319: x_msg_count := 1;
320: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
321: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
322: END;
323:
324: p_out_attributes.untrxd_rec_count := l_untrxd_rec_count;
325: p_out_attributes.receiving_rec_count := NVL(l_rec_exp_count,0) + NVL(l_rec_direct_count,0);

Line 402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

398: WHEN OTHERS THEN
399: l_nonintf_line_qty := null;
400: x_msg_count := 1;
401: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
403:
404: END;
405:
406: p_out_attributes.nonintf_line_qty := l_nonintf_line_qty;

Line 536: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

532:
533: WHEN OTHERS THEN
534:
535: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
536: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
537:
538: -- Get message count and data
539:
540: FND_MSG_PUB.Count_And_Get

Line 1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1006:
1007: WHEN OTHERS THEN
1008:
1009: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1011:
1012: -- Get message count and data
1013:
1014: FND_MSG_PUB.Count_And_Get

Line 1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1034:
1035: WHEN OTHERS THEN
1036:
1037: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1039:
1040: -- Get message count and data
1041:
1042: FND_MSG_PUB.Count_And_Get

Line 1089: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);

1085:
1086: EXCEPTION
1087: WHEN OTHERS THEN
1088: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1089: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1092: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1093: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1104: (p_wsh_id_tab IN WSH_UTIL_CORE.id_tab_type,

1100: --=========================================================
1101:
1102: -- 1.Convert WSH Table of ids to DBI Table of ids
1103: PROCEDURE WSH_ID_TAB_TO_DBI_ID_TAB
1104: (p_wsh_id_tab IN WSH_UTIL_CORE.id_tab_type,
1105: x_dbi_id_tab OUT NOCOPY ISC_DBI_CHANGE_LOG_PKG.log_tab_type,
1106: x_return_status OUT NOCOPY VARCHAR2
1107: ) IS
1108:

Line 1121: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1117: IF l_debug_on IS NULL THEN
1118: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1119: END IF;
1120: --
1121: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1122:
1123: IF l_debug_on THEN
1124: WSH_DEBUG_SV.push(l_module_name);
1125: WSH_DEBUG_SV.log(l_module_name,'Count Input records',p_wsh_id_tab.count);

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

1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147: wsh_util_core.add_message(x_return_status,l_module_name);
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1150: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1151: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1171: (p_delivery_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,

1167: -- x_return_status - Return Status
1168: --
1169: --===============================================
1170: PROCEDURE DBI_Update_Detail_Log
1171: (p_delivery_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
1172: p_dml_type IN VARCHAR2,
1173: x_return_status OUT NOCOPY VARCHAR2) IS
1174:
1175: l_dbi_detail_list ISC_DBI_CHANGE_LOG_PKG.log_tab_type;

Line 1187: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1183: IF l_debug_on IS NULL THEN
1184: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1185: END IF;
1186: --
1187: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.push(l_module_name);
1190: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1191: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',p_delivery_detail_id_tab.count);

Line 1214: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1210: (p_wsh_id_tab => p_delivery_detail_id_tab,
1211: x_dbi_id_tab => l_dbi_detail_list,
1212: x_return_status => x_return_status);
1213:
1214: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',l_dbi_detail_list.count);
1217: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1218: END IF;

Line 1229: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1225: --
1226: -- Only Unexpected error can be raised from DBI API,
1227: -- all others have to be treated as success and code flow
1228: -- will continue and not rollback
1229: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1231: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1232: WSH_UTIL_CORE.Add_Message(x_return_status);
1233: ELSE -- all other Statuses are equivalent to Success

Line 1230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1226: -- Only Unexpected error can be raised from DBI API,
1227: -- all others have to be treated as success and code flow
1228: -- will continue and not rollback
1229: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1231: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1232: WSH_UTIL_CORE.Add_Message(x_return_status);
1233: ELSE -- all other Statuses are equivalent to Success
1234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1232: WSH_UTIL_CORE.Add_Message(x_return_status);

1228: -- will continue and not rollback
1229: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1231: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1232: WSH_UTIL_CORE.Add_Message(x_return_status);
1233: ELSE -- all other Statuses are equivalent to Success
1234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1235: END IF;
1236: --

Line 1234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1230: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1231: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1232: WSH_UTIL_CORE.Add_Message(x_return_status);
1233: ELSE -- all other Statuses are equivalent to Success
1234: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1235: END IF;
1236: --
1237: END IF;
1238:

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

1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248: wsh_util_core.add_message(x_return_status,l_module_name);
1249:
1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1252: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1281: (p_stop_id_tab IN WSH_UTIL_CORE.id_tab_type,

1277: -- x_return_status - Return Status
1278: --
1279: --===============================================
1280: PROCEDURE DBI_Update_Trip_Stop_Log
1281: (p_stop_id_tab IN WSH_UTIL_CORE.id_tab_type,
1282: p_dml_type IN VARCHAR2,
1283: x_return_status OUT NOCOPY VARCHAR2) IS
1284:
1285: l_dbi_stop_list ISC_DBI_CHANGE_LOG_PKG.log_tab_type;

Line 1298: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1294: IF l_debug_on IS NULL THEN
1295: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1296: END IF;
1297: --
1298: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1299: IF l_debug_on THEN
1300: WSH_DEBUG_SV.push(l_module_name);
1301: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',p_stop_id_tab.count);
1302: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);

Line 1324: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1320: (p_wsh_id_tab => p_stop_id_tab,
1321: x_dbi_id_tab => l_dbi_stop_list,
1322: x_return_status => x_return_status);
1323:
1324: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1325:
1326: IF l_debug_on THEN
1327: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',l_dbi_stop_list.count);
1328: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);

Line 1340: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

1336: --
1337: -- Only Unexpected error can be raised from DBI API,
1338: -- all others have to be treated as success and code flow
1339: -- will continue and not rollback
1340: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1342: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1343: WSH_UTIL_CORE.Add_Message(x_return_status);
1344: ELSE -- all other Statuses are equivalent to Success

Line 1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1337: -- Only Unexpected error can be raised from DBI API,
1338: -- all others have to be treated as success and code flow
1339: -- will continue and not rollback
1340: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1342: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1343: WSH_UTIL_CORE.Add_Message(x_return_status);
1344: ELSE -- all other Statuses are equivalent to Success
1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1343: WSH_UTIL_CORE.Add_Message(x_return_status);

1339: -- will continue and not rollback
1340: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1342: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1343: WSH_UTIL_CORE.Add_Message(x_return_status);
1344: ELSE -- all other Statuses are equivalent to Success
1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1346: END IF;
1347: --

Line 1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1342: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1343: WSH_UTIL_CORE.Add_Message(x_return_status);
1344: ELSE -- all other Statuses are equivalent to Success
1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1346: END IF;
1347: --
1348: END IF;
1349:

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

1355: EXCEPTION
1356: WHEN OTHERS THEN
1357: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1359: wsh_util_core.add_message(x_return_status,l_module_name);
1360:
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1363: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1397: x_matched_entities OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

1393: (p_attr_tab IN OUT NOCOPY GRP_ATTR_TAB_TYPE,
1394: p_action_rec IN ACTION_REC_TYPE,
1395: p_target_rec IN GRP_ATTR_REC_TYPE,
1396: p_group_tab IN OUT NOCOPY GRP_ATTR_TAB_TYPE,
1397: x_matched_entities OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
1398: x_out_rec OUT NOCOPY OUT_REC_TYPE,
1399: x_return_status OUT NOCOPY VARCHAR2) IS
1400:
1401: -- Local variables to move information from or to the variables

Line 1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1428: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1429: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1430: END IF;
1431:
1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1433:
1434: --
1435: -- Wrapper on top of WSHDEAUB.find_matching_groups
1436: --

Line 1497: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN

1493: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_org_id,
1494: x_param_info => l_param_info,
1495: x_return_status => x_return_status);
1496:
1497: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1498: --{
1499: IF l_debug_on THEN
1500: --{
1501: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

Line 1573: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN

1569: x_matched_entities => x_matched_entities,
1570: x_out_rec => l_out_rec,
1571: x_return_status => x_return_status);
1572:
1573: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1576: WSH_DEBUG_SV.pop(l_module_name);
1577: END IF;

Line 1596: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1592: END IF;
1593:
1594: EXCEPTION
1595: WHEN OTHERS THEN
1596: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1597: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1600: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1597: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);

1593:
1594: EXCEPTION
1595: WHEN OTHERS THEN
1596: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1597: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1598: IF l_debug_on THEN
1599: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1600: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1601: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');