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_UTIL_VALIDATE dependencies on FND_API

Line 247: IF p_org_id <> FND_API.G_MISS_NUM THEN

243: --
244: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
245: l_failed := FALSE;
246:
247: IF p_org_id <> FND_API.G_MISS_NUM THEN
248: OPEN check_org_id;
249: FETCH check_org_id INTO p_org_id;
250: l_failed := check_org_id%NOTFOUND;
251: CLOSE check_org_id;

Line 252: ELSIF p_org_code <> FND_API.G_MISS_CHAR THEN

248: OPEN check_org_id;
249: FETCH check_org_id INTO p_org_id;
250: l_failed := check_org_id%NOTFOUND;
251: CLOSE check_org_id;
252: ELSIF p_org_code <> FND_API.G_MISS_CHAR THEN
253: OPEN check_org_code;
254: FETCH check_org_code INTO p_org_id;
255: l_failed := check_org_code%NOTFOUND;
256: CLOSE check_org_code;

Line 356: IF (p_location_id = FND_API.G_MISS_NUM ) THEN

352: ELSE
353: l_source_loc_type := 'HR_HZ';
354: END IF;
355:
356: IF (p_location_id = FND_API.G_MISS_NUM ) THEN
357: p_location_id := NULL;
358: END IF;
359:
360: IF p_location_id IS NOT NULL THEN

Line 383: RAISE FND_API.G_EXC_ERROR;

379: p_return_status => l_return_status,
380: x_num_warnings => l_num_warnings,
381: x_num_errors => l_num_errors);
382: IF l_loc_rec.wsh_location_id IS NULL THEN
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;
385:
386: IF TRUNC(l_sysdate) <= NVL(l_loc_rec.inactive_date,TRUNC(l_sysdate))
387: THEN

Line 390: RAISE FND_API.G_EXC_ERROR;

386: IF TRUNC(l_sysdate) <= NVL(l_loc_rec.inactive_date,TRUNC(l_sysdate))
387: THEN
388: p_location_id := l_loc_rec.wsh_location_id;
389: ELSE
390: RAISE FND_API.G_EXC_ERROR;
391: END IF;
392:
393: IF l_debug_on THEN
394: WSH_DEBUG_SV.log(l_module_name,'inactive_date',

Line 401: ELSIF NVL(p_location_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR

397: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
398: WSH_DEBUG_SV.pop(l_module_name);
399: END IF;
400: RETURN;
401: ELSIF NVL(p_location_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
402: AND p_location_id IS NULL
403: THEN
404: BEGIN
405: SELECT wsh_location_id

Line 424: RAISE FND_API.G_EXC_ERROR;

420: RETURN;
421:
422: EXCEPTION
423: WHEN TOO_MANY_ROWS THEN
424: RAISE FND_API.G_EXC_ERROR;
425: WHEN NO_DATA_FOUND THEN
426: OPEN check_location;
427: FETCH check_location
428: INTO l_location_id;

Line 434: RAISE FND_API.G_EXC_ERROR;

430: WSH_DEBUG_SV.log(l_module_name,'cursor l_location_id',
431: l_location_id);
432: END IF;
433: IF check_location%NOTFOUND THEN
434: RAISE FND_API.G_EXC_ERROR;
435: ELSE
436: FETCH check_location
437: INTO l_location_id2;
438: IF l_location_id2 IS NOT NULL THEN

Line 443: RAISE FND_API.G_EXC_ERROR;

439: IF l_debug_on THEN
440: WSH_DEBUG_SV.log(l_module_name,'Too Many ROws',
441: l_location_id2);
442: END IF;
443: RAISE FND_API.G_EXC_ERROR;
444: END IF;
445: END IF;
446: END;
447:

Line 470: RAISE FND_API.G_EXC_ERROR;

466: x_num_warnings => l_num_warnings,
467: x_num_errors => l_num_errors);
468:
469: IF l_loc_rec.wsh_location_id IS NULL THEN
470: RAISE FND_API.G_EXC_ERROR;
471: END IF;
472: p_location_id := l_loc_rec.wsh_location_id;
473:
474: ELSE

Line 490: WHEN FND_API.G_EXC_ERROR THEN

486: END IF;
487: --
488: EXCEPTION
489:
490: WHEN FND_API.G_EXC_ERROR THEN
491: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
493: wsh_util_core.add_message(x_return_status,l_module_name);
494: IF l_debug_on THEN

Line 497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

493: wsh_util_core.add_message(x_return_status,l_module_name);
494: IF l_debug_on THEN
495: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_ERROR');
496: END IF;
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
499: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
500: wsh_util_core.add_message(x_return_status,l_module_name);
501: IF l_debug_on THEN

Line 660: NVL(p_customer_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM

656: SELECT cust_account_id /*customer_id */
657: FROM hz_cust_accounts
658: WHERE cust_account_id = p_customer_id AND
659: status = 'A' AND
660: NVL(p_customer_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
661: UNION
662: SELECT Cust_account_id/*customer_id */
663: FROM hz_cust_accounts
664: WHERE account_number /* customer number */ = p_customer_number AND

Line 666: NVL(p_customer_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM;

662: SELECT Cust_account_id/*customer_id */
663: FROM hz_cust_accounts
664: WHERE account_number /* customer number */ = p_customer_number AND
665: status = 'A' AND
666: NVL(p_customer_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM;
667: --Removal of TCA View Ends
668:
669:
670: --

Line 694: IF nvl(p_customer_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

690: END IF;
691: --
692: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
693:
694: IF nvl(p_customer_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
695: OR nvl(p_customer_number, fnd_api.g_miss_char) <> fnd_api.g_miss_char
696: THEN
697:
698: OPEN check_customer;

Line 695: OR nvl(p_customer_number, fnd_api.g_miss_char) <> fnd_api.g_miss_char

691: --
692: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
693:
694: IF nvl(p_customer_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
695: OR nvl(p_customer_number, fnd_api.g_miss_char) <> fnd_api.g_miss_char
696: THEN
697:
698: OPEN check_customer;
699: FETCH check_customer INTO p_customer_id;

Line 1013: IF nvl(p_currency_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char

1009: END IF;
1010: --
1011: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1012:
1013: IF nvl(p_currency_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1014: OR nvl(p_currency_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1015: THEN
1016: -- OTM R12
1017: OPEN currency_cursor(p_currency_code,p_currency_name);

Line 1014: OR nvl(p_currency_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char

1010: --
1011: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1012:
1013: IF nvl(p_currency_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1014: OR nvl(p_currency_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1015: THEN
1016: -- OTM R12
1017: OPEN currency_cursor(p_currency_code,p_currency_name);
1018: -- OTM R12

Line 1177: IF nvl(p_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char

1173: END IF;
1174: --
1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1176:
1177: IF nvl(p_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1178: AND nvl(p_uom_desc, fnd_api.g_miss_char) = fnd_api.g_miss_char
1179: THEN
1180: RETURN;
1181: END IF;

Line 1178: AND nvl(p_uom_desc, fnd_api.g_miss_char) = fnd_api.g_miss_char

1174: --
1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1176:
1177: IF nvl(p_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1178: AND nvl(p_uom_desc, fnd_api.g_miss_char) = fnd_api.g_miss_char
1179: THEN
1180: RETURN;
1181: END IF;
1182: IF (p_uom_code IS NOT NULL) OR (p_uom_desc IS NOT NULL) THEN

Line 1246: IF NVL(p_uom_code, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

1242: x_flag => l_uom_flag
1243: );
1244: -- flag = U means use this index value to insert record in table
1245: IF l_uom_flag = 'U' AND l_uom_index IS NOT NULL THEN
1246: IF NVL(p_uom_code, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1247: OPEN check_uom_code (l_input_class);
1248: FETCH check_uom_code INTO l_cache_uom_rec.output_param2;
1249: IF (check_uom_code%NOTFOUND) THEN
1250: l_cache_uom_rec.valid_flag := 'N';

Line 1255: ELSIF NVL(p_uom_code, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

1251: ELSE
1252: l_cache_uom_rec.valid_flag := 'Y';
1253: END IF;
1254: CLOSE check_uom_code;
1255: ELSIF NVL(p_uom_code, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
1256: OPEN check_uom_desc (l_input_class);
1257: FETCH check_uom_desc INTO l_cache_uom_rec.output_param2;
1258: IF (check_uom_desc%NOTFOUND) THEN
1259: l_cache_uom_rec.valid_flag := 'N';

Line 1428: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char

1424: END IF;
1425: --
1426: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1427: --
1428: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1429: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1430: THEN
1431: --
1432:

Line 1429: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char

1425: --
1426: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1427: --
1428: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1429: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1430: THEN
1431: --
1432:
1433: -- Bug 3821688

Line 1449: IF p_ship_method_code <> fnd_api.g_miss_char THEN

1445: );
1446: -- l_flag = U means use this index value to insert record in table
1447: -- l_flag = D means valid record found
1448: IF l_flag = 'U' AND l_index IS NOT NULL THEN
1449: IF p_ship_method_code <> fnd_api.g_miss_char THEN
1450: OPEN check_ship_method_code;
1451: FETCH check_ship_method_code
1452: INTO l_cache_rec.output_param1,l_cache_rec.output_param2;
1453: --

Line 1461: ELSIF p_ship_method_name <> fnd_api.g_miss_char THEN

1457: l_cache_rec.valid_flag := 'Y';
1458: END IF;
1459: --
1460: CLOSE check_ship_method_code;
1461: ELSIF p_ship_method_name <> fnd_api.g_miss_char THEN
1462: OPEN check_ship_method_name;
1463: FETCH check_ship_method_name
1464: INTO l_cache_rec.output_param1,l_cache_rec.output_param2;
1465: --

Line 1545: IF nvl(p_freight_terms_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char

1541: --
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1543:
1544:
1545: IF nvl(p_freight_terms_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1546: OR nvl(p_freight_terms_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1547: THEN
1548: -- OTM R12, glog project changes
1549: validate_lookup_UPPER(

Line 1546: OR nvl(p_freight_terms_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char

1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1543:
1544:
1545: IF nvl(p_freight_terms_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1546: OR nvl(p_freight_terms_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1547: THEN
1548: -- OTM R12, glog project changes
1549: validate_lookup_UPPER(
1550: p_lookup_type => 'FREIGHT_TERMS',

Line 1605: IF nvl(p_fob_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char

1601: END IF;
1602: --
1603: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1604:
1605: IF nvl(p_fob_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1606: OR nvl(p_fob_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1607: THEN
1608: validate_lookup(
1609: p_lookup_type => 'FOB',

Line 1606: OR nvl(p_fob_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char

1602: --
1603: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1604:
1605: IF nvl(p_fob_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1606: OR nvl(p_fob_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1607: THEN
1608: validate_lookup(
1609: p_lookup_type => 'FOB',
1610: p_lookup_code => p_fob_code,

Line 1711: IF NVL(p_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1707: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1708: END IF;
1709: --
1710: --IF p_id IS NOT NULL THEN
1711: IF NVL(p_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1712:
1713: x_flag := fnd_flex_keyval.validate_ccid(
1714: appl_short_name => p_app_short_name,
1715: key_flex_code => p_key_flx_code,

Line 1725: ELSIF p_id IS NULL OR p_id = FND_API.G_MISS_NUM THEN

1721: IF l_debug_on THEN
1722: WSH_DEBUG_SV.log(l_module_name,'x_flag',x_flag);
1723: WSH_DEBUG_SV.log(l_module_name,'p_id',p_id);
1724: END IF;
1725: ELSIF p_id IS NULL OR p_id = FND_API.G_MISS_NUM THEN
1726: If l_debug_on THEN
1727: wsh_debug_sv.logmsg(l_module_name, 'Calling set session mode');
1728: END IF;
1729:

Line 1843: -- using FND APIs. Item id takes precedence over the other validations.

1839: --========================================================================
1840: -- PROCEDURE : Validate_Item
1841: --
1842: -- COMMENT : Validates Inventory_Item_id/Concatenated name/Segment array
1843: -- using FND APIs. Item id takes precedence over the other validations.
1844: --========================================================================
1845:
1846: PROCEDURE Validate_Item(
1847: p_inventory_item_id IN OUT NOCOPY NUMBER,

Line 1886: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) = fnd_api.g_miss_num

1882: END IF;
1883: --
1884: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1885:
1886: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1887: AND nvl(p_inventory_item, fnd_api.g_miss_char) = fnd_api.g_miss_char
1888: AND p_seg_array.count = 0
1889: THEN
1890:

Line 1887: AND nvl(p_inventory_item, fnd_api.g_miss_char) = fnd_api.g_miss_char

1883: --
1884: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1885:
1886: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1887: AND nvl(p_inventory_item, fnd_api.g_miss_char) = fnd_api.g_miss_char
1888: AND p_seg_array.count = 0
1889: THEN
1890:
1891: IF l_debug_on THEN

Line 1928: IF nvl(l_item_type, FND_API.G_MISS_CHAR) <> p_item_type THEN

1924: p_organization_id => p_organization_id,
1925: x_item_type => l_item_type,
1926: x_return_status => l_return_status);
1927:
1928: IF nvl(l_item_type, FND_API.G_MISS_CHAR) <> p_item_type THEN
1929: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');
1930: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1931: wsh_util_core.add_message(x_return_status,l_module_name);
1932: END IF;

Line 2104: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND

2100:
2101: CURSOR check_delivery_name IS
2102: SELECT delivery_id
2103: FROM wsh_new_deliveries
2104: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2105: delivery_id = p_delivery_id
2106: UNION ALL
2107: SELECT delivery_id
2108: FROM wsh_new_deliveries

Line 2109: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND

2105: delivery_id = p_delivery_id
2106: UNION ALL
2107: SELECT delivery_id
2108: FROM wsh_new_deliveries
2109: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2110: name = p_delivery_name;
2111:
2112: --
2113: l_debug_on BOOLEAN;

Line 2275: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR

2271: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_DESC',P_LOADING_ORDER_DESC);
2272: END IF;
2273: --
2274: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2275: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2276: OR nvl(p_loading_order_desc,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2277: THEN
2278: --
2279: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 2276: OR nvl(p_loading_order_desc,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR

2272: END IF;
2273: --
2274: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2275: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2276: OR nvl(p_loading_order_desc,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2277: THEN
2278: --
2279: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2280: --

Line 2279: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

2275: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2276: OR nvl(p_loading_order_desc,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2277: THEN
2278: --
2279: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2280: --
2281: IF upper(p_loading_order_desc) ='FORWARD' THEN
2282: p_loading_order_flag := 'F';
2283: ELSIF upper(p_loading_order_desc) ='FORWARD INVERTED'THEN

Line 2344: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND

2340:
2341: CURSOR check_stop_name IS
2342: SELECT stop_id
2343: FROM wsh_trip_stops
2344: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2345: stop_id = p_stop_id
2346: UNION ALL
2347: SELECT stop_id
2348: FROM wsh_trip_stops

Line 2349: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND

2345: stop_id = p_stop_id
2346: UNION ALL
2347: SELECT stop_id
2348: FROM wsh_trip_stops
2349: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2350: trip_id = p_trip_id AND
2351: stop_location_id = p_stop_location_id AND
2352: planned_departure_date = nvl(p_planned_dep_date, planned_departure_date)
2353: ;

Line 2424: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND

2420:
2421: CURSOR check_trip_name IS
2422: SELECT trip_id
2423: FROM wsh_trips
2424: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2425: trip_id = p_trip_id
2426: UNION ALL
2427: SELECT trip_id
2428: FROM wsh_trips

Line 2429: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND

2425: trip_id = p_trip_id
2426: UNION ALL
2427: SELECT trip_id
2428: FROM wsh_trips
2429: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2430: name = p_trip_name;
2431:
2432: --
2433: l_debug_on BOOLEAN;

Line 2620: RAISE FND_API.G_EXC_ERROR;

2616: --
2617: --
2618: IF l_proc_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2619: THEN
2620: RAISE FND_API.G_EXC_ERROR;
2621: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2622: THEN
2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2624: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2619: THEN
2620: RAISE FND_API.G_EXC_ERROR;
2621: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2622: THEN
2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2624: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_WARNING
2625: THEN
2626: --{
2627:

Line 2637: RAISE FND_API.G_EXC_ERROR;

2633:
2634:
2635: IF l_proc_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2636: THEN
2637: RAISE FND_API.G_EXC_ERROR;
2638: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2639: THEN
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: END IF;

Line 2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2636: THEN
2637: RAISE FND_API.G_EXC_ERROR;
2638: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2639: THEN
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: END IF;
2642:
2643: IF l_return_value THEN
2644: l_return_status := 'Y';

Line 2666: RAISE FND_API.G_EXC_ERROR;

2662: --
2663: --
2664: IF l_proc_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2665: THEN
2666: RAISE FND_API.G_EXC_ERROR;
2667: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2668: THEN
2669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2670: END IF;

Line 2669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2665: THEN
2666: RAISE FND_API.G_EXC_ERROR;
2667: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2668: THEN
2669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2670: END IF;
2671: --
2672: --}
2673: END IF;

Line 2692: WHEN FND_API.G_EXC_ERROR THEN

2688: --
2689: RETURN l_return_status ;
2690:
2691: EXCEPTION
2692: WHEN FND_API.G_EXC_ERROR THEN
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 2695: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2691: EXCEPTION
2692: WHEN FND_API.G_EXC_ERROR THEN
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2697: END IF;
2698: --
2699: -- bug 5161801, return 'N' when it encounters any exception

Line 2696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2692: WHEN FND_API.G_EXC_ERROR THEN
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2697: END IF;
2698: --
2699: -- bug 5161801, return 'N' when it encounters any exception
2700: l_return_status := 'N';

Line 2702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2698: --
2699: -- bug 5161801, return 'N' when it encounters any exception
2700: l_return_status := 'N';
2701: RETURN l_return_status ;
2702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2703: --
2704: IF l_debug_on THEN
2705: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2705: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2701: RETURN l_return_status ;
2702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2703: --
2704: IF l_debug_on THEN
2705: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2707: END IF;
2708: --
2709: -- bug 5161801, return 'N' when it encounters any exception

Line 2706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2703: --
2704: IF l_debug_on THEN
2705: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2707: END IF;
2708: --
2709: -- bug 5161801, return 'N' when it encounters any exception
2710: l_return_status := 'N';

Line 2749: IF nvl(p_from_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date

2745: WSH_DEBUG_SV.log(l_module_name,'p_to_date',p_to_date);
2746: END IF;
2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2748:
2749: IF nvl(p_from_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2750: OR nvl(p_to_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2751: THEN
2752: IF (p_from_date > p_to_date) THEN
2753: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2750: OR nvl(p_to_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date

2746: END IF;
2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2748:
2749: IF nvl(p_from_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2750: OR nvl(p_to_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2751: THEN
2752: IF (p_from_date > p_to_date) THEN
2753: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2754: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_DATE_RANGE');

Line 2840: IF ( nvl(l_valid_trip, FND_API.G_MISS_CHAR) <> 'X' ) THEN

2836: FETCH get_trip_status_2 INTO l_valid_trip,l_trip_name;
2837: CLOSE get_trip_status_2;
2838: END IF;
2839:
2840: IF ( nvl(l_valid_trip, FND_API.G_MISS_CHAR) <> 'X' ) THEN
2841: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2842: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_STATUS_NO_ACTION');
2843: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
2844: wsh_util_core.add_message(x_return_status,l_module_name);

Line 2882: where nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num

2878: --
2879: cursor l_carrier_csr is
2880: select carrier_id
2881: from wsh_carriers_v
2882: where nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
2883: and carrier_id = x_carrier_id
2884: and nvl(generic_flag, 'N') = 'N'
2885: and active = 'A'
2886: union all

Line 2889: where nvl(x_carrier_id,fnd_api.g_miss_num) = fnd_api.g_miss_num

2885: and active = 'A'
2886: union all
2887: select carrier_id
2888: from wsh_carriers_v
2889: where nvl(x_carrier_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2890: and carrier_name = p_carrier_name
2891: and nvl(generic_flag, 'N') = 'N'
2892: and active = 'A';
2893:

Line 2916: IF nvl(x_carrier_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

2912: END IF;
2913: --
2914: x_return_status := wsh_util_core.g_ret_sts_success;
2915: --
2916: IF nvl(x_carrier_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
2917: OR nvl(p_carrier_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
2918: THEN
2919: --
2920: open l_carrier_csr;

Line 2917: OR nvl(p_carrier_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char

2913: --
2914: x_return_status := wsh_util_core.g_ret_sts_success;
2915: --
2916: IF nvl(x_carrier_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
2917: OR nvl(p_carrier_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
2918: THEN
2919: --
2920: open l_carrier_csr;
2921: fetch l_carrier_csr into x_carrier_id;

Line 3197: RAISE FND_API.G_EXC_ERROR;

3193: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_ENTITY_TYPE');
3194: FND_MESSAGE.SET_TOKEN('ENT_TYPE', p_entity_type);
3195: x_return_status := wsh_util_core.g_ret_sts_error;
3196: wsh_util_core.add_message(x_return_status,l_module_name);
3197: RAISE FND_API.G_EXC_ERROR;
3198: --
3199: END IF;
3200: --
3201: --

Line 3283: IF nvl(l_carrier_id,fnd_api.g_miss_num) <> nvl(x_carrier_id,fnd_api.g_miss_num)

3279: -- If the either one of carrier, service level or mode of transport is changed
3280: -- we need to nullify the Ship Method to keep the Pubic API behaviour
3281: -- in SYNC with the STF.
3282: -- 10374068 : do not Nullify if these are New Values for entered ShipMethod attributes
3283: IF nvl(l_carrier_id,fnd_api.g_miss_num) <> nvl(x_carrier_id,fnd_api.g_miss_num)
3284: or nvl(l_service_level,fnd_api.g_miss_char) <> nvl(x_service_level,fnd_api.g_miss_char)
3285: or nvl(l_mode_of_transport,fnd_api.g_miss_char) <> nvl(x_mode_of_transport,fnd_api.g_miss_char)
3286: THEN
3287: -- 10374068

Line 3284: or nvl(l_service_level,fnd_api.g_miss_char) <> nvl(x_service_level,fnd_api.g_miss_char)

3280: -- we need to nullify the Ship Method to keep the Pubic API behaviour
3281: -- in SYNC with the STF.
3282: -- 10374068 : do not Nullify if these are New Values for entered ShipMethod attributes
3283: IF nvl(l_carrier_id,fnd_api.g_miss_num) <> nvl(x_carrier_id,fnd_api.g_miss_num)
3284: or nvl(l_service_level,fnd_api.g_miss_char) <> nvl(x_service_level,fnd_api.g_miss_char)
3285: or nvl(l_mode_of_transport,fnd_api.g_miss_char) <> nvl(x_mode_of_transport,fnd_api.g_miss_char)
3286: THEN
3287: -- 10374068
3288: IF ( p_caller = 'WSH_FSTRX' and (x_service_level is NULL or x_mode_of_transport is NULL))

Line 3285: or nvl(l_mode_of_transport,fnd_api.g_miss_char) <> nvl(x_mode_of_transport,fnd_api.g_miss_char)

3281: -- in SYNC with the STF.
3282: -- 10374068 : do not Nullify if these are New Values for entered ShipMethod attributes
3283: IF nvl(l_carrier_id,fnd_api.g_miss_num) <> nvl(x_carrier_id,fnd_api.g_miss_num)
3284: or nvl(l_service_level,fnd_api.g_miss_char) <> nvl(x_service_level,fnd_api.g_miss_char)
3285: or nvl(l_mode_of_transport,fnd_api.g_miss_char) <> nvl(x_mode_of_transport,fnd_api.g_miss_char)
3286: THEN
3287: -- 10374068
3288: IF ( p_caller = 'WSH_FSTRX' and (x_service_level is NULL or x_mode_of_transport is NULL))
3289: THEN

Line 3302: IF nvl(x_service_level, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

3298: p_ship_method_name := NULL;
3299: END IF;
3300: END IF;
3301:
3302: IF nvl(x_service_level, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
3303: --
3304: validate_lookup(
3305: p_lookup_type => 'WSH_SERVICE_LEVELS',
3306: p_lookup_code => x_service_level,

Line 3323: IF nvl(x_mode_of_transport, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

3319: --
3320: END IF;
3321: --
3322: --
3323: IF nvl(x_mode_of_transport, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
3324: --
3325: validate_lookup(
3326: p_lookup_type => 'WSH_MODE_OF_TRANSPORT',
3327: p_lookup_code => x_mode_of_transport,

Line 3354: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =

3350: --
3351: END IF;
3352: --
3353: IF l_sm_is_null = TRUE
3354: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3355: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3356: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3357: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3358: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =

Line 3355: NVL(x_carrier_id,fnd_api.G_MISS_NUM)

3351: END IF;
3352: --
3353: IF l_sm_is_null = TRUE
3354: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3355: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3356: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3357: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3358: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3359: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)

Line 3356: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =

3352: --
3353: IF l_sm_is_null = TRUE
3354: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3355: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3356: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3357: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3358: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3359: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3360: THEN

Line 3357: NVL(x_service_level,fnd_api.G_MISS_CHAR)

3353: IF l_sm_is_null = TRUE
3354: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3355: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3356: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3357: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3358: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3359: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3360: THEN
3361: IF l_ship_method_code IS NOT NULL THEN

Line 3358: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =

3354: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3355: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3356: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3357: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3358: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3359: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3360: THEN
3361: IF l_ship_method_code IS NOT NULL THEN
3362: p_ship_method_name := NULL;

Line 3359: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)

3355: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3356: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3357: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3358: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3359: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3360: THEN
3361: IF l_ship_method_code IS NOT NULL THEN
3362: p_ship_method_name := NULL;
3363: x_ship_method_code := NULL;

Line 3372: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =

3368: -- Following Code is Commented for Bug 4000931
3369: -- Start of Comment for Bug 4000931
3370: /******
3371: ELSIF l_sm_is_null = FALSE
3372: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3373: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3374: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3375: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3376: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =

Line 3373: NVL(x_carrier_id,fnd_api.G_MISS_NUM)

3369: -- Start of Comment for Bug 4000931
3370: /******
3371: ELSIF l_sm_is_null = FALSE
3372: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3373: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3374: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3375: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3376: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3377: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)

Line 3374: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =

3370: /******
3371: ELSIF l_sm_is_null = FALSE
3372: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3373: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3374: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3375: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3376: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3377: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3378: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN

Line 3375: NVL(x_service_level,fnd_api.G_MISS_CHAR)

3371: ELSIF l_sm_is_null = FALSE
3372: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3373: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3374: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3375: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3376: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3377: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3378: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN
3379: --

Line 3376: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =

3372: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3373: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3374: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3375: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3376: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3377: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3378: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN
3379: --
3380: x_return_status := wsh_util_core.g_ret_sts_success;

Line 3377: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)

3373: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3374: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3375: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3376: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3377: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3378: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN
3379: --
3380: x_return_status := wsh_util_core.g_ret_sts_success;
3381: IF l_debug_on THEN

Line 3389: ELSIF nvl(x_ship_method_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char

3385: END IF;
3386: RETURN;
3387: ******/
3388: -- End of Comment for Bug 4000931
3389: ELSIF nvl(x_ship_method_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3390: AND nvl(l_ship_method_code,fnd_api.g_miss_char) <>
3391: nvl(x_ship_method_code,fnd_api.g_miss_char)
3392: THEN
3393: --

Line 3390: AND nvl(l_ship_method_code,fnd_api.g_miss_char) <>

3386: RETURN;
3387: ******/
3388: -- End of Comment for Bug 4000931
3389: ELSIF nvl(x_ship_method_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3390: AND nvl(l_ship_method_code,fnd_api.g_miss_char) <>
3391: nvl(x_ship_method_code,fnd_api.g_miss_char)
3392: THEN
3393: --
3394: IF p_entity_type = 'DLVY' THEN

Line 3391: nvl(x_ship_method_code,fnd_api.g_miss_char)

3387: ******/
3388: -- End of Comment for Bug 4000931
3389: ELSIF nvl(x_ship_method_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3390: AND nvl(l_ship_method_code,fnd_api.g_miss_char) <>
3391: nvl(x_ship_method_code,fnd_api.g_miss_char)
3392: THEN
3393: --
3394: IF p_entity_type = 'DLVY' THEN
3395: --

Line 3407: RAISE FND_API.G_EXC_ERROR;

3403: close l_dlvy_ship_method_code_csr_tp;
3404: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');
3405: x_return_status := wsh_util_core.g_ret_sts_error;
3406: wsh_util_core.add_message(x_return_status,l_module_name);
3407: RAISE FND_API.G_EXC_ERROR;
3408: END IF;
3409: --
3410: close l_dlvy_ship_method_code_csr_tp;
3411: ELSE

Line 3422: RAISE FND_API.G_EXC_ERROR;

3418: close l_dlvy_ship_method_code_csr;
3419: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');
3420: x_return_status := wsh_util_core.g_ret_sts_error;
3421: wsh_util_core.add_message(x_return_status,l_module_name);
3422: RAISE FND_API.G_EXC_ERROR;
3423: END IF;
3424: --
3425: close l_dlvy_ship_method_code_csr;
3426: END IF;

Line 3440: RAISE FND_API.G_EXC_ERROR;

3436: close l_trip_ship_method_code_csr;
3437: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');
3438: x_return_status := wsh_util_core.g_ret_sts_error;
3439: wsh_util_core.add_message(x_return_status,l_module_name);
3440: RAISE FND_API.G_EXC_ERROR;
3441: END IF;
3442: --
3443: close l_trip_ship_method_code_csr;
3444: --

Line 3447: ELSIF nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num

3443: close l_trip_ship_method_code_csr;
3444: --
3445: END IF;
3446: --
3447: ELSIF nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
3448: AND nvl(x_service_level,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3449: AND nvl(x_mode_of_transport,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3450: THEN
3451: --

Line 3448: AND nvl(x_service_level,fnd_api.g_miss_char) <> fnd_api.g_miss_char

3444: --
3445: END IF;
3446: --
3447: ELSIF nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
3448: AND nvl(x_service_level,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3449: AND nvl(x_mode_of_transport,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3450: THEN
3451: --
3452: IF p_entity_type = 'DLVY' THEN

Line 3449: AND nvl(x_mode_of_transport,fnd_api.g_miss_char) <> fnd_api.g_miss_char

3445: END IF;
3446: --
3447: ELSIF nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
3448: AND nvl(x_service_level,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3449: AND nvl(x_mode_of_transport,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3450: THEN
3451: --
3452: IF p_entity_type = 'DLVY' THEN
3453: --

Line 3513: ELSIF ( nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num )

3509: --
3510: -- 10374068 : do not invoke the following condition as incoming Svc. Level or
3511: -- Mode of Tpt. could be Null or in Database there could be more than 1 Carrier
3512: -- Service Recs. with Null in these two attributes.
3513: ELSIF ( nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num )
3514: AND (x_service_level is NOT null and x_mode_of_transport is not null)
3515: THEN
3516: --
3517: IF p_entity_type = 'DLVY' THEN

Line 3565: RAISE FND_API.G_EXC_ERROR;

3561: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
3562: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
3563: x_return_status := wsh_util_core.g_ret_sts_error;
3564: wsh_util_core.add_message(x_return_status,l_module_name);
3565: RAISE FND_API.G_EXC_ERROR;
3566:
3567: END IF;
3568: END IF;
3569: --

Line 3577: IF NVL(l_ship_method_code_backup,fnd_api.G_MISS_CHAR) <>

3573: -- Fix for bug 4310011(OTM R12, glog proj)
3574: -- Do not show this warning message for FTE
3575: IF p_caller NOT LIKE 'FTE%' THEN
3576:
3577: IF NVL(l_ship_method_code_backup,fnd_api.G_MISS_CHAR) <>
3578: NVL(x_ship_method_code,fnd_api.G_MISS_CHAR) THEN
3579: --
3580: IF l_debug_on THEN
3581: wsh_debug_sv.logmsg(l_module_name,'Ship method calculated is different');

Line 3578: NVL(x_ship_method_code,fnd_api.G_MISS_CHAR) THEN

3574: -- Do not show this warning message for FTE
3575: IF p_caller NOT LIKE 'FTE%' THEN
3576:
3577: IF NVL(l_ship_method_code_backup,fnd_api.G_MISS_CHAR) <>
3578: NVL(x_ship_method_code,fnd_api.G_MISS_CHAR) THEN
3579: --
3580: IF l_debug_on THEN
3581: wsh_debug_sv.logmsg(l_module_name,'Ship method calculated is different');
3582: END IF;

Line 3600: WHEN FND_API.G_EXC_ERROR THEN

3596: END IF;
3597: --
3598: EXCEPTION
3599: --
3600: WHEN FND_API.G_EXC_ERROR THEN
3601: --
3602: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3603: IF l_debug_on THEN
3604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3600: WHEN FND_API.G_EXC_ERROR THEN
3601: --
3602: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3603: IF l_debug_on THEN
3604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3606: END IF;
3607: --
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3601: --
3602: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3603: IF l_debug_on THEN
3604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3606: END IF;
3607: --
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: --

Line 3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3604: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3605: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3606: END IF;
3607: --
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: --
3610: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3611: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3612: IF l_debug_on THEN

Line 3614: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3610: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3611: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3612: IF l_debug_on THEN
3613: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3614: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3615: END IF;
3616: --
3617: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3618: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3696: RAISE FND_API.G_EXC_ERROR;

3692: l_container_item_flag, l_shippable_flag, l_vehicle_item_flag;
3693: IF veh_cont_item_cur%NOTFOUND THEN
3694: CLOSE veh_cont_item_cur;
3695: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');
3696: RAISE FND_API.G_EXC_ERROR;
3697: END IF;
3698: CLOSE veh_cont_item_cur;
3699:
3700: l_wms_org := wsh_util_validate.Check_Wms_Org(p_organization_id);

Line 3721: WHEN FND_API.G_EXC_ERROR THEN

3717: END IF;
3718: --
3719:
3720: EXCEPTION
3721: WHEN FND_API.G_EXC_ERROR THEN
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: wsh_util_core.add_message(x_return_status,l_module_name);
3724: IF l_debug_on THEN
3725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3721: WHEN FND_API.G_EXC_ERROR THEN
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: wsh_util_core.add_message(x_return_status,l_module_name);
3724: IF l_debug_on THEN
3725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3727: END IF;
3728:
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: wsh_util_core.add_message(x_return_status,l_module_name);
3724: IF l_debug_on THEN
3725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3727: END IF;
3728:
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: --

Line 3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3725: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3727: END IF;
3728:
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: --
3731: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3730: --
3731: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3735: END IF;
3736:
3737: WHEN OTHERS THEN
3738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3791: raise FND_API.G_EXC_ERROR;

3787: p_delivery_detail_id => p_delivery_detail_id,
3788: p_msg_display => p_msg_display);
3789:
3790: IF l_return_status = wsh_util_core.g_ret_sts_error THEN
3791: raise FND_API.G_EXC_ERROR;
3792: ELSIF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
3793: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3794: END IF;
3795:

Line 3793: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3789:
3790: IF l_return_status = wsh_util_core.g_ret_sts_error THEN
3791: raise FND_API.G_EXC_ERROR;
3792: ELSIF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
3793: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3794: END IF;
3795:
3796: l_wms_installed := wsh_util_validate.Check_Wms_Org(p_organization_id);
3797:

Line 3821: WHEN FND_API.G_EXC_ERROR THEN

3817: END IF;
3818:
3819: RETURN l_org_type;
3820: EXCEPTION
3821: WHEN FND_API.G_EXC_ERROR THEN
3822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3823: --
3824: IF l_debug_on THEN
3825: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3825: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3821: WHEN FND_API.G_EXC_ERROR THEN
3822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3823: --
3824: IF l_debug_on THEN
3825: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3827: END IF;
3828: RETURN l_org_type;
3829: --

Line 3826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3822: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3823: --
3824: IF l_debug_on THEN
3825: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3827: END IF;
3828: RETURN l_org_type;
3829: --
3830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3827: END IF;
3828: RETURN l_org_type;
3829: --
3830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3831: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3832: --
3833: IF l_debug_on THEN
3834: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3831: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3832: --
3833: IF l_debug_on THEN
3834: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3836: END IF;
3837: RETURN l_org_type;
3838: --
3839: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 3926: RAISE FND_API.G_EXC_ERROR;

3922: p_inventory_item_id);
3923: END IF;
3924: --
3925: IF (p_organization_id IS NULL ) OR (p_inventory_item_id IS NULL )THEN
3926: RAISE FND_API.G_EXC_ERROR;
3927: END IF;
3928: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3929:
3930: l_hash_string := p_organization_id || '-'||p_inventory_item_id;

Line 3965: RAISE FND_API.G_EXC_ERROR;

3961: l_Item_info_rec.unit_volume;
3962:
3963: IF c_inventory_item_info%NOTFOUND THEN
3964: CLOSE c_inventory_item_info;
3965: RAISE FND_API.G_EXC_ERROR;
3966: END IF;
3967:
3968: CLOSE c_inventory_item_info;
3969:

Line 3997: WHEN FND_API.G_EXC_ERROR THEN

3993: WSH_DEBUG_SV.pop(l_module_name);
3994: END IF;
3995: EXCEPTION
3996:
3997: WHEN FND_API.G_EXC_ERROR THEN
3998: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3999: --
4000: IF l_debug_on THEN
4001: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

Line 4001: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

3997: WHEN FND_API.G_EXC_ERROR THEN
3998: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3999: --
4000: IF l_debug_on THEN
4001: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4002: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4003: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4004: END IF;
4005: --

Line 4003: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3999: --
4000: IF l_debug_on THEN
4001: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4002: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4003: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4004: END IF;
4005: --
4006: WHEN OTHERS THEN
4007: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 4014: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4010: IF l_debug_on THEN
4011: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4012: 'Oracle error message is '||
4013: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4014: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4015: END IF;
4016:
4017:
4018: END get_item_info;

Line 4066: RAISE FND_API.G_EXC_ERROR;

4062: WSH_DEBUG_SV.log(l_module_name,'p_item_id',p_item_id);
4063: END IF;
4064: --
4065: IF p_item_id IS NULL THEN
4066: RAISE FND_API.G_EXC_ERROR;
4067: END IF;
4068: --
4069: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4070:

Line 4135: WHEN FND_API.G_EXC_ERROR THEN

4131: WSH_DEBUG_SV.pop(l_module_name);
4132: END IF;
4133:
4134: EXCEPTION
4135: WHEN FND_API.G_EXC_ERROR THEN
4136: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4137: --
4138: IF l_debug_on THEN
4139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

Line 4139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

4135: WHEN FND_API.G_EXC_ERROR THEN
4136: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4137: --
4138: IF l_debug_on THEN
4139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4140: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4142: END IF;
4143: --

Line 4141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

4137: --
4138: IF l_debug_on THEN
4139: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4140: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4141: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4142: END IF;
4143: --
4144:
4145: WHEN OTHERS THEN

Line 4153: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4149: IF l_debug_on THEN
4150: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4151: 'Oracle error message is '||
4152: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4153: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4154: END IF;
4155:
4156: END Default_container;
4157:

Line 4237: Raise FND_API.G_EXC_ERROR;

4233: ,l_shipping_param_info.otm_enabled);
4234: END IF;
4235: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,
4236: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4237: Raise FND_API.G_EXC_ERROR;
4238: END IF;
4239: IF l_shipping_param_info.otm_enabled = 'Y' THEN
4240: x_ignore_for_planning := 'N';
4241: ELSE

Line 4284: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN

4280: IF l_debug_on THEN
4281: WSH_DEBUG_SV.log(l_module_name,'l_wh_type,l_return_status',
4282: l_wh_type||l_return_status);
4283: END IF;
4284: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN
4285: x_ignore_for_planning:='Y';
4286: ELSE
4287: x_ignore_for_planning:='N';
4288: END IF;

Line 4305: WHEN FND_API.G_EXC_ERROR THEN --{ --OTM R12 Start

4301: IF l_debug_on THEN
4302: WSH_DEBUG_SV.pop(l_module_name,x_ignore_for_planning);
4303: END IF;
4304: EXCEPTION
4305: WHEN FND_API.G_EXC_ERROR THEN --{ --OTM R12 Start
4306: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4307: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4308: IF l_debug_on THEN
4309: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

Line 4309: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

4305: WHEN FND_API.G_EXC_ERROR THEN --{ --OTM R12 Start
4306: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4307: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4308: IF l_debug_on THEN
4309: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4310: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4312: END IF; --} --OTM R12 End
4313: WHEN OTHERS THEN

Line 4311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

4307: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4308: IF l_debug_on THEN
4309: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4310: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4312: END IF; --} --OTM R12 End
4313: WHEN OTHERS THEN
4314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4315: wsh_util_core.default_handler('WSH_UTIL_CORE.DEFAULT_CONTAINER');

Line 4321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4317: IF l_debug_on THEN
4318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4319: 'Oracle error message is '||
4320: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4322: END IF;
4323: END Calc_ignore_for_planning;
4324:
4325: -- Added for Inbound Logistics

Line 4458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4454: END IF;
4455: --
4456: EXCEPTION
4457: WHEN OTHERS THEN
4458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4459: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FOB',l_module_name);
4460: --
4461: -- Debug Statements
4462: --

Line 4604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4600: END IF;
4601: --
4602: EXCEPTION
4603: WHEN OTHERS THEN
4604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4605: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_TERMS',l_module_name);
4606: --
4607: -- Debug Statements
4608: --

Line 4707: RAISE FND_API.G_EXC_ERROR;

4703: fnd_message.SET_name('WSH', 'WSH_SUPP_LOCN_ERROR');
4704: FND_MESSAGE.SET_TOKEN('LOCATION_NAME',l_location_name);
4705: --
4706: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
4707: RAISE FND_API.G_EXC_ERROR;
4708: --}
4709: END IF;
4710: --
4711: CLOSE locn_csr;

Line 4722: WHEN FND_API.G_EXC_ERROR THEN

4718: --}
4719: EXCEPTION
4720: --{
4721: --
4722: WHEN FND_API.G_EXC_ERROR THEN
4723:
4724: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4725: --
4726: IF l_debug_on THEN

Line 4727: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4723:
4724: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4725: --
4726: IF l_debug_on THEN
4727: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4728: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4729: END IF;
4730: --
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4728: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

4724: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4725: --
4726: IF l_debug_on THEN
4727: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4728: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4729: END IF;
4730: --
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732:

Line 4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4727: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4728: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4729: END IF;
4730: --
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732:
4733: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4734: --
4735: IF l_debug_on THEN

Line 4737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4733: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4734: --
4735: IF l_debug_on THEN
4736: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4738: END IF;
4739: --
4740: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4741: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 5100: and NVL(p_ship_method_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR

5096: select flv.lookup_code ship_method_code,
5097: flv.meaning
5098: from fnd_lookup_values_vl flv, wsh_carrier_services wcs
5099: where flv.lookup_code = wcs.ship_method_code
5100: and NVL(p_ship_method_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR
5101: and flv.lookup_type = 'SHIP_METHOD'
5102: and flv.view_application_id = 3
5103: and flv.meaning = p_ship_method_name
5104: and wcs.enabled_flag='Y' ;

Line 5130: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char

5126: END IF;
5127: --
5128: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5129: --
5130: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
5131: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
5132: THEN
5133: --
5134: OPEN check_ship_method;

Line 5131: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char

5127: --
5128: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5129: --
5130: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
5131: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
5132: THEN
5133: --
5134: OPEN check_ship_method;
5135: FETCH check_ship_method INTO p_ship_method_code, p_ship_method_name;

Line 6076: WHERE nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num

6072: --
6073: CURSOR l_carrier_csr is
6074: SELECT carrier_id
6075: FROM wsh_carriers_v
6076: WHERE nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
6077: AND carrier_id = x_carrier_id
6078: AND nvl(generic_flag, 'N') = 'N'
6079: AND active = 'A'
6080: UNION ALL

Line 6083: WHERE nvl(x_carrier_id,fnd_api.g_miss_num) = fnd_api.g_miss_num

6079: AND active = 'A'
6080: UNION ALL
6081: SELECT carrier_id
6082: FROM wsh_carriers_v
6083: WHERE nvl(x_carrier_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
6084: AND freight_code = p_freight_code
6085: AND nvl(generic_flag, 'N') = 'N'
6086: AND active = 'A';
6087:

Line 6106: IF (nvl(x_carrier_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num OR NVL(p_freight_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char) THEN

6102: END IF;
6103:
6104: x_return_status := wsh_util_core.g_ret_sts_success;
6105:
6106: IF (nvl(x_carrier_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num OR NVL(p_freight_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char) THEN
6107: --{
6108: OPEN l_carrier_csr;
6109: FETCH l_carrier_csr INTO x_carrier_id;
6110: IF l_carrier_csr%NOTFOUND THEN