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 1088: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);

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

Line 1103: (p_wsh_id_tab IN WSH_UTIL_CORE.id_tab_type,

1099: --=========================================================
1100: --Commenting the code for Obsoletion of DBI APIs in 12.2
1101: -- 1.Convert WSH Table of ids to DBI Table of ids
1102: /*PROCEDURE WSH_ID_TAB_TO_DBI_ID_TAB
1103: (p_wsh_id_tab IN WSH_UTIL_CORE.id_tab_type,
1104: x_dbi_id_tab OUT NOCOPY ISC_DBI_CHANGE_LOG_PKG.log_tab_type,
1105: x_return_status OUT NOCOPY VARCHAR2
1106: ) IS
1107:

Line 1120: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

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

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

Line 1170: (p_delivery_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,

1166: -- x_return_status - Return Status
1167: --
1168: --===============================================
1169: PROCEDURE DBI_Update_Detail_Log
1170: (p_delivery_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
1171: p_dml_type IN VARCHAR2,
1172: x_return_status OUT NOCOPY VARCHAR2) IS
1173:
1174: --Commenting the code for Obsoletion of DBI APIs in 12.2

Line 1188: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

Line 1215: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

Line 1217: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1213: x_return_status => x_return_status);
1214:
1215: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1216:
1217: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.log(l_module_name,'Count Detail records-',l_dbi_detail_list.count);
1220: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);
1221: END IF;

Line 1232: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

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

Line 1233: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 1235: WSH_UTIL_CORE.Add_Message(x_return_status);

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

Line 1237: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

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

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

Line 1284: (p_stop_id_tab IN WSH_UTIL_CORE.id_tab_type,

1280: -- x_return_status - Return Status
1281: --
1282: --===============================================
1283: PROCEDURE DBI_Update_Trip_Stop_Log
1284: (p_stop_id_tab IN WSH_UTIL_CORE.id_tab_type,
1285: p_dml_type IN VARCHAR2,
1286: x_return_status OUT NOCOPY VARCHAR2) IS
1287:
1288: --Commenting the code for Obsoletion of DBI APIs in 12.2

Line 1302: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1298: IF l_debug_on IS NULL THEN
1299: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1300: END IF;*/
1301: --
1302: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1303: /* IF l_debug_on THEN
1304: WSH_DEBUG_SV.push(l_module_name);
1305: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',p_stop_id_tab.count);
1306: WSH_DEBUG_SV.log(l_module_name,'DML Type-',p_dml_type);

Line 1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1324: (p_wsh_id_tab => p_stop_id_tab,
1325: x_dbi_id_tab => l_dbi_stop_list,
1326: x_return_status => x_return_status);
1327:
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1329:
1330: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1331:
1332: IF l_debug_on THEN

Line 1330: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1326: x_return_status => x_return_status);
1327:
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1329:
1330: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1331:
1332: IF l_debug_on THEN
1333: WSH_DEBUG_SV.log(l_module_name,'Count Stop records-',l_dbi_stop_list.count);
1334: WSH_DEBUG_SV.log(l_module_name,'Before Calling DBI API-',x_return_status);

Line 1346: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

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

Line 1347: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 1349: WSH_UTIL_CORE.Add_Message(x_return_status);

1345: -- will continue and not rollback
1346: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1347: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1348: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1349: WSH_UTIL_CORE.Add_Message(x_return_status);
1350: ELSE -- all other Statuses are equivalent to Success
1351: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1352: END IF;
1353: --

Line 1351: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1347: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1348: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1349: WSH_UTIL_CORE.Add_Message(x_return_status);
1350: ELSE -- all other Statuses are equivalent to Success
1351: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1352: END IF;
1353: --
1354: END IF;
1355:

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

1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: wsh_util_core.add_message(x_return_status,l_module_name);
1366:
1367: IF l_debug_on THEN
1368: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1369: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1403: x_matched_entities OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

1399: (p_attr_tab IN OUT NOCOPY GRP_ATTR_TAB_TYPE,
1400: p_action_rec IN ACTION_REC_TYPE,
1401: p_target_rec IN GRP_ATTR_REC_TYPE,
1402: p_group_tab IN OUT NOCOPY GRP_ATTR_TAB_TYPE,
1403: x_matched_entities OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
1404: x_out_rec OUT NOCOPY OUT_REC_TYPE,
1405: x_return_status OUT NOCOPY VARCHAR2) IS
1406:
1407: -- Local variables to move information from or to the variables

Line 1438: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1434: WSH_DEBUG_SV.log(l_module_name, 'p_group_tab count', p_group_tab.count);
1435: WSH_DEBUG_SV.log(l_module_name, 'p_target_rec.entity_type', p_target_rec.entity_type);
1436: END IF;
1437:
1438: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1439:
1440: --
1441: -- Wrapper on top of WSHDEAUB.find_matching_groups
1442: --

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

1499: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_org_id,
1500: x_param_info => l_param_info,
1501: x_return_status => x_return_status);
1502:
1503: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1504: --{
1505: IF l_debug_on THEN
1506: --{
1507: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);

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

1575: x_matched_entities => x_matched_entities,
1576: x_out_rec => l_out_rec,
1577: x_return_status => x_return_status);
1578:
1579: IF x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
1580: IF l_debug_on THEN
1581: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1582: WSH_DEBUG_SV.pop(l_module_name);
1583: END IF;

Line 1602: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1598: END IF;
1599:
1600: EXCEPTION
1601: WHEN OTHERS THEN
1602: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1603: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1606: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

1599:
1600: EXCEPTION
1601: WHEN OTHERS THEN
1602: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1603: wsh_util_core.default_handler('WSH_INTEGRATION.FIND_MATCHING_GROUPS',l_module_name);
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1606: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1816: l_line_ids wsh_util_core.id_tab_type; --for storing line_ids if only header_id is passed in package.

1812: WHERE source_line_id = l_line_id
1813: AND source_code = 'OE')
1814: CONNECT BY PRIOR wda.parent_delivery_detail_id = wda.DELIVERY_DETAIL_ID ;
1815:
1816: l_line_ids wsh_util_core.id_tab_type; --for storing line_ids if only header_id is passed in package.
1817:
1818: --Get the line_id assoicated to the header_id
1819: CURSOR c_line_id(l_header_id NUMBER ) IS
1820: SELECT DISTINCT source_line_id

Line 1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1858: IF l_debug_on IS NULL THEN
1859: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1860: END IF;
1861:
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1863:
1864: IF l_debug_on THEN
1865: WSH_DEBUG_SV.push(l_module_name);
1866: WSH_DEBUG_SV.log(l_module_name,'header_id ',p_header_id);

Line 1942: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1938: END IF;
1939:
1940: EXCEPTION
1941: WHEN NO_VALUE_PASSED THEN
1942: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1943: wsh_util_core.printMsg('line_id and header_id both are not passed');
1944:
1945: IF c_line_id%ISOPEN THEN
1946: close c_line_id;

Line 1943: wsh_util_core.printMsg('line_id and header_id both are not passed');

1939:
1940: EXCEPTION
1941: WHEN NO_VALUE_PASSED THEN
1942: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1943: wsh_util_core.printMsg('line_id and header_id both are not passed');
1944:
1945: IF c_line_id%ISOPEN THEN
1946: close c_line_id;
1947: END IF;

Line 1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1964: END IF;
1965:
1966:
1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: wsh_util_core.printMsg('API Get_Delivery_Detail_attributes failed with an unexpected error');
1970: WSH_UTIL_CORE.PrintMsg('The unexpected error is '|| sqlerrm);
1971:
1972: IF c_line_id%ISOPEN THEN

Line 1969: wsh_util_core.printMsg('API Get_Delivery_Detail_attributes failed with an unexpected error');

1965:
1966:
1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: wsh_util_core.printMsg('API Get_Delivery_Detail_attributes failed with an unexpected error');
1970: WSH_UTIL_CORE.PrintMsg('The unexpected error is '|| sqlerrm);
1971:
1972: IF c_line_id%ISOPEN THEN
1973: close c_line_id;

Line 1970: WSH_UTIL_CORE.PrintMsg('The unexpected error is '|| sqlerrm);

1966:
1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: wsh_util_core.printMsg('API Get_Delivery_Detail_attributes failed with an unexpected error');
1970: WSH_UTIL_CORE.PrintMsg('The unexpected error is '|| sqlerrm);
1971:
1972: IF c_line_id%ISOPEN THEN
1973: close c_line_id;
1974: END IF;

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

2060: RETURN l_return_status;
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
2064: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
2065: IF l_debug_on THEN
2066: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2067: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2068: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2083: p_detail_rows IN wsh_util_core.id_tab_type,

2079: -- a delivery line to 'Y'
2080: --
2081:
2082: PROCEDURE Update_Delivery_Details(
2083: p_detail_rows IN wsh_util_core.id_tab_type,
2084: x_return_status OUT NOCOPY VARCHAR2) IS
2085:
2086: others EXCEPTION;
2087: l_debug_on BOOLEAN;

Line 2104: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2100: IF l_debug_on THEN
2101: WSH_DEBUG_SV.push(l_module_name);
2102: END IF;
2103: --
2104: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2105:
2106: IF (p_detail_rows.count = 0) THEN
2107: raise others;
2108: END IF;

Line 2137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2133:
2134: EXCEPTION
2135:
2136: WHEN others THEN
2137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2138: wsh_util_core.default_handler('WSH_INTERFACE.UPDATE_DELIVERY_DETAILS',l_module_name);
2139: --
2140: IF l_debug_on THEN
2141: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2138: wsh_util_core.default_handler('WSH_INTERFACE.UPDATE_DELIVERY_DETAILS',l_module_name);

2134: EXCEPTION
2135:
2136: WHEN others THEN
2137: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2138: wsh_util_core.default_handler('WSH_INTERFACE.UPDATE_DELIVERY_DETAILS',l_module_name);
2139: --
2140: IF l_debug_on THEN
2141: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2142: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');