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 225: IF p_org_id <> FND_API.G_MISS_NUM THEN

221: --
222: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
223: l_failed := FALSE;
224:
225: IF p_org_id <> FND_API.G_MISS_NUM THEN
226: OPEN check_org_id;
227: FETCH check_org_id INTO p_org_id;
228: l_failed := check_org_id%NOTFOUND;
229: CLOSE check_org_id;

Line 230: ELSIF p_org_code <> FND_API.G_MISS_CHAR THEN

226: OPEN check_org_id;
227: FETCH check_org_id INTO p_org_id;
228: l_failed := check_org_id%NOTFOUND;
229: CLOSE check_org_id;
230: ELSIF p_org_code <> FND_API.G_MISS_CHAR THEN
231: OPEN check_org_code;
232: FETCH check_org_code INTO p_org_id;
233: l_failed := check_org_code%NOTFOUND;
234: CLOSE check_org_code;

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

330: ELSE
331: l_source_loc_type := 'HR_HZ';
332: END IF;
333:
334: IF (p_location_id = FND_API.G_MISS_NUM ) THEN
335: p_location_id := NULL;
336: END IF;
337:
338: IF p_location_id IS NOT NULL THEN

Line 361: RAISE FND_API.G_EXC_ERROR;

357: p_return_status => l_return_status,
358: x_num_warnings => l_num_warnings,
359: x_num_errors => l_num_errors);
360: IF l_loc_rec.wsh_location_id IS NULL THEN
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:
364: IF TRUNC(l_sysdate) <= NVL(l_loc_rec.inactive_date,TRUNC(l_sysdate))
365: THEN

Line 368: RAISE FND_API.G_EXC_ERROR;

364: IF TRUNC(l_sysdate) <= NVL(l_loc_rec.inactive_date,TRUNC(l_sysdate))
365: THEN
366: p_location_id := l_loc_rec.wsh_location_id;
367: ELSE
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370:
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_module_name,'inactive_date',

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

375: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
376: WSH_DEBUG_SV.pop(l_module_name);
377: END IF;
378: RETURN;
379: ELSIF NVL(p_location_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
380: AND p_location_id IS NULL
381: THEN
382: BEGIN
383: SELECT wsh_location_id

Line 402: RAISE FND_API.G_EXC_ERROR;

398: RETURN;
399:
400: EXCEPTION
401: WHEN TOO_MANY_ROWS THEN
402: RAISE FND_API.G_EXC_ERROR;
403: WHEN NO_DATA_FOUND THEN
404: OPEN check_location;
405: FETCH check_location
406: INTO l_location_id;

Line 412: RAISE FND_API.G_EXC_ERROR;

408: WSH_DEBUG_SV.log(l_module_name,'cursor l_location_id',
409: l_location_id);
410: END IF;
411: IF check_location%NOTFOUND THEN
412: RAISE FND_API.G_EXC_ERROR;
413: ELSE
414: FETCH check_location
415: INTO l_location_id2;
416: IF l_location_id2 IS NOT NULL THEN

Line 421: RAISE FND_API.G_EXC_ERROR;

417: IF l_debug_on THEN
418: WSH_DEBUG_SV.log(l_module_name,'Too Many ROws',
419: l_location_id2);
420: END IF;
421: RAISE FND_API.G_EXC_ERROR;
422: END IF;
423: END IF;
424: END;
425:

Line 448: RAISE FND_API.G_EXC_ERROR;

444: x_num_warnings => l_num_warnings,
445: x_num_errors => l_num_errors);
446:
447: IF l_loc_rec.wsh_location_id IS NULL THEN
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;
450: p_location_id := l_loc_rec.wsh_location_id;
451:
452: ELSE

Line 468: WHEN FND_API.G_EXC_ERROR THEN

464: END IF;
465: --
466: EXCEPTION
467:
468: WHEN FND_API.G_EXC_ERROR THEN
469: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
471: wsh_util_core.add_message(x_return_status,l_module_name);
472: IF l_debug_on THEN

Line 475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

471: wsh_util_core.add_message(x_return_status,l_module_name);
472: IF l_debug_on THEN
473: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_ERROR');
474: END IF;
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
477: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
478: wsh_util_core.add_message(x_return_status,l_module_name);
479: IF l_debug_on THEN

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

634: SELECT cust_account_id /*customer_id */
635: FROM hz_cust_accounts
636: WHERE cust_account_id = p_customer_id AND
637: status = 'A' AND
638: NVL(p_customer_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
639: UNION
640: SELECT Cust_account_id/*customer_id */
641: FROM hz_cust_accounts
642: WHERE account_number /* customer number */ = p_customer_number AND

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

640: SELECT Cust_account_id/*customer_id */
641: FROM hz_cust_accounts
642: WHERE account_number /* customer number */ = p_customer_number AND
643: status = 'A' AND
644: NVL(p_customer_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM;
645: --Removal of TCA View Ends
646:
647:
648: --

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

668: END IF;
669: --
670: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
671:
672: IF nvl(p_customer_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
673: OR nvl(p_customer_number, fnd_api.g_miss_char) <> fnd_api.g_miss_char
674: THEN
675:
676: OPEN check_customer;

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

669: --
670: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
671:
672: IF nvl(p_customer_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
673: OR nvl(p_customer_number, fnd_api.g_miss_char) <> fnd_api.g_miss_char
674: THEN
675:
676: OPEN check_customer;
677: FETCH check_customer INTO p_customer_id;

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

987: END IF;
988: --
989: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
990:
991: IF nvl(p_currency_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
992: OR nvl(p_currency_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
993: THEN
994: -- OTM R12
995: OPEN currency_cursor(p_currency_code,p_currency_name);

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

988: --
989: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
990:
991: IF nvl(p_currency_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
992: OR nvl(p_currency_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
993: THEN
994: -- OTM R12
995: OPEN currency_cursor(p_currency_code,p_currency_name);
996: -- OTM R12

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

1151: END IF;
1152: --
1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1154:
1155: IF nvl(p_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1156: AND nvl(p_uom_desc, fnd_api.g_miss_char) = fnd_api.g_miss_char
1157: THEN
1158: RETURN;
1159: END IF;

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

1152: --
1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1154:
1155: IF nvl(p_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char
1156: AND nvl(p_uom_desc, fnd_api.g_miss_char) = fnd_api.g_miss_char
1157: THEN
1158: RETURN;
1159: END IF;
1160: IF (p_uom_code IS NOT NULL) OR (p_uom_desc IS NOT NULL) THEN

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

1220: x_flag => l_uom_flag
1221: );
1222: -- flag = U means use this index value to insert record in table
1223: IF l_uom_flag = 'U' AND l_uom_index IS NOT NULL THEN
1224: IF NVL(p_uom_code, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
1225: OPEN check_uom_code (l_input_class);
1226: FETCH check_uom_code INTO l_cache_uom_rec.output_param2;
1227: IF (check_uom_code%NOTFOUND) THEN
1228: l_cache_uom_rec.valid_flag := 'N';

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

1229: ELSE
1230: l_cache_uom_rec.valid_flag := 'Y';
1231: END IF;
1232: CLOSE check_uom_code;
1233: ELSIF NVL(p_uom_code, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
1234: OPEN check_uom_desc (l_input_class);
1235: FETCH check_uom_desc INTO l_cache_uom_rec.output_param2;
1236: IF (check_uom_desc%NOTFOUND) THEN
1237: l_cache_uom_rec.valid_flag := 'N';

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

1402: END IF;
1403: --
1404: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1405: --
1406: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1407: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1408: THEN
1409: --
1410:

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

1403: --
1404: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1405: --
1406: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1407: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1408: THEN
1409: --
1410:
1411: -- Bug 3821688

Line 1427: IF p_ship_method_code <> fnd_api.g_miss_char THEN

1423: );
1424: -- l_flag = U means use this index value to insert record in table
1425: -- l_flag = D means valid record found
1426: IF l_flag = 'U' AND l_index IS NOT NULL THEN
1427: IF p_ship_method_code <> fnd_api.g_miss_char THEN
1428: OPEN check_ship_method_code;
1429: FETCH check_ship_method_code
1430: INTO l_cache_rec.output_param1,l_cache_rec.output_param2;
1431: --

Line 1439: ELSIF p_ship_method_name <> fnd_api.g_miss_char THEN

1435: l_cache_rec.valid_flag := 'Y';
1436: END IF;
1437: --
1438: CLOSE check_ship_method_code;
1439: ELSIF p_ship_method_name <> fnd_api.g_miss_char THEN
1440: OPEN check_ship_method_name;
1441: FETCH check_ship_method_name
1442: INTO l_cache_rec.output_param1,l_cache_rec.output_param2;
1443: --

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

1519: --
1520: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1521:
1522:
1523: IF nvl(p_freight_terms_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1524: OR nvl(p_freight_terms_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1525: THEN
1526: -- OTM R12, glog project changes
1527: validate_lookup_UPPER(

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

1520: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1521:
1522:
1523: IF nvl(p_freight_terms_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1524: OR nvl(p_freight_terms_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1525: THEN
1526: -- OTM R12, glog project changes
1527: validate_lookup_UPPER(
1528: p_lookup_type => 'FREIGHT_TERMS',

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

1579: END IF;
1580: --
1581: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1582:
1583: IF nvl(p_fob_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1584: OR nvl(p_fob_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1585: THEN
1586: validate_lookup(
1587: p_lookup_type => 'FOB',

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

1580: --
1581: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1582:
1583: IF nvl(p_fob_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1584: OR nvl(p_fob_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
1585: THEN
1586: validate_lookup(
1587: p_lookup_type => 'FOB',
1588: p_lookup_code => p_fob_code,

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

1685: WSH_DEBUG_SV.log(l_module_name,'P_WH_CLAUSE',P_WH_CLAUSE);
1686: END IF;
1687: --
1688: --IF p_id IS NOT NULL THEN
1689: IF NVL(p_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1690:
1691: x_flag := fnd_flex_keyval.validate_ccid(
1692: appl_short_name => p_app_short_name,
1693: key_flex_code => p_key_flx_code,

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

1699: IF l_debug_on THEN
1700: WSH_DEBUG_SV.log(l_module_name,'x_flag',x_flag);
1701: WSH_DEBUG_SV.log(l_module_name,'p_id',p_id);
1702: END IF;
1703: ELSIF p_id IS NULL OR p_id = FND_API.G_MISS_NUM THEN
1704: If l_debug_on THEN
1705: wsh_debug_sv.logmsg(l_module_name, 'Calling set session mode');
1706: END IF;
1707:

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

1817: --========================================================================
1818: -- PROCEDURE : Validate_Item
1819: --
1820: -- COMMENT : Validates Inventory_Item_id/Concatenated name/Segment array
1821: -- using FND APIs. Item id takes precedence over the other validations.
1822: --========================================================================
1823:
1824: PROCEDURE Validate_Item(
1825: p_inventory_item_id IN OUT NOCOPY NUMBER,

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

1860: END IF;
1861: --
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1863:
1864: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1865: AND nvl(p_inventory_item, fnd_api.g_miss_char) = fnd_api.g_miss_char
1866: AND p_seg_array.count = 0
1867: THEN
1868:

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

1861: --
1862: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1863:
1864: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1865: AND nvl(p_inventory_item, fnd_api.g_miss_char) = fnd_api.g_miss_char
1866: AND p_seg_array.count = 0
1867: THEN
1868:
1869: IF l_debug_on THEN

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

1902: p_organization_id => p_organization_id,
1903: x_item_type => l_item_type,
1904: x_return_status => l_return_status);
1905:
1906: IF nvl(l_item_type, FND_API.G_MISS_CHAR) <> p_item_type THEN
1907: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');
1908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1909: wsh_util_core.add_message(x_return_status,l_module_name);
1910: END IF;

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

2078:
2079: CURSOR check_delivery_name IS
2080: SELECT delivery_id
2081: FROM wsh_new_deliveries
2082: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2083: delivery_id = p_delivery_id
2084: UNION ALL
2085: SELECT delivery_id
2086: FROM wsh_new_deliveries

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

2083: delivery_id = p_delivery_id
2084: UNION ALL
2085: SELECT delivery_id
2086: FROM wsh_new_deliveries
2087: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2088: name = p_delivery_name;
2089:
2090: --
2091: l_debug_on BOOLEAN;

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

2249: WSH_DEBUG_SV.log(l_module_name,'P_LOADING_ORDER_DESC',P_LOADING_ORDER_DESC);
2250: END IF;
2251: --
2252: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2253: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2254: OR nvl(p_loading_order_desc,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2255: THEN
2256: --
2257: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

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

2250: END IF;
2251: --
2252: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2253: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2254: OR nvl(p_loading_order_desc,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2255: THEN
2256: --
2257: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2258: --

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

2253: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2254: OR nvl(p_loading_order_desc,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
2255: THEN
2256: --
2257: IF nvl(p_loading_order_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2258: --
2259: IF upper(p_loading_order_desc) ='FORWARD' THEN
2260: p_loading_order_flag := 'F';
2261: ELSIF upper(p_loading_order_desc) ='FORWARD INVERTED'THEN

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

2318:
2319: CURSOR check_stop_name IS
2320: SELECT stop_id
2321: FROM wsh_trip_stops
2322: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2323: stop_id = p_stop_id
2324: UNION ALL
2325: SELECT stop_id
2326: FROM wsh_trip_stops

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

2323: stop_id = p_stop_id
2324: UNION ALL
2325: SELECT stop_id
2326: FROM wsh_trip_stops
2327: WHERE NVL(p_stop_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2328: trip_id = p_trip_id AND
2329: stop_location_id = p_stop_location_id AND
2330: planned_departure_date = nvl(p_planned_dep_date, planned_departure_date)
2331: ;

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

2398:
2399: CURSOR check_trip_name IS
2400: SELECT trip_id
2401: FROM wsh_trips
2402: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2403: trip_id = p_trip_id
2404: UNION ALL
2405: SELECT trip_id
2406: FROM wsh_trips

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

2403: trip_id = p_trip_id
2404: UNION ALL
2405: SELECT trip_id
2406: FROM wsh_trips
2407: WHERE NVL(p_trip_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2408: name = p_trip_name;
2409:
2410: --
2411: l_debug_on BOOLEAN;

Line 2598: RAISE FND_API.G_EXC_ERROR;

2594: --
2595: --
2596: IF l_proc_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2597: THEN
2598: RAISE FND_API.G_EXC_ERROR;
2599: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2600: THEN
2601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2602: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 2601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2597: THEN
2598: RAISE FND_API.G_EXC_ERROR;
2599: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2600: THEN
2601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2602: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_WARNING
2603: THEN
2604: --{
2605:

Line 2615: RAISE FND_API.G_EXC_ERROR;

2611:
2612:
2613: IF l_proc_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2614: THEN
2615: RAISE FND_API.G_EXC_ERROR;
2616: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2617: THEN
2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2619: END IF;

Line 2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2614: THEN
2615: RAISE FND_API.G_EXC_ERROR;
2616: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2617: THEN
2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2619: END IF;
2620:
2621: IF l_return_value THEN
2622: l_return_status := 'Y';

Line 2644: RAISE FND_API.G_EXC_ERROR;

2640: --
2641: --
2642: IF l_proc_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2643: THEN
2644: RAISE FND_API.G_EXC_ERROR;
2645: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2646: THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: END IF;

Line 2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2643: THEN
2644: RAISE FND_API.G_EXC_ERROR;
2645: ELSIF l_proc_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
2646: THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: END IF;
2649: --
2650: --}
2651: END IF;

Line 2670: WHEN FND_API.G_EXC_ERROR THEN

2666: --
2667: RETURN l_return_status ;
2668:
2669: EXCEPTION
2670: WHEN FND_API.G_EXC_ERROR THEN
2671: --
2672: IF l_debug_on THEN
2673: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2674: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

2669: EXCEPTION
2670: WHEN FND_API.G_EXC_ERROR THEN
2671: --
2672: IF l_debug_on THEN
2673: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2674: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2675: END IF;
2676: --
2677: -- bug 5161801, return 'N' when it encounters any exception

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

2670: WHEN FND_API.G_EXC_ERROR THEN
2671: --
2672: IF l_debug_on THEN
2673: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2674: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2675: END IF;
2676: --
2677: -- bug 5161801, return 'N' when it encounters any exception
2678: l_return_status := 'N';

Line 2680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2676: --
2677: -- bug 5161801, return 'N' when it encounters any exception
2678: l_return_status := 'N';
2679: RETURN l_return_status ;
2680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2681: --
2682: IF l_debug_on THEN
2683: 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);
2684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2683: 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);

2679: RETURN l_return_status ;
2680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2681: --
2682: IF l_debug_on THEN
2683: 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);
2684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2685: END IF;
2686: --
2687: -- bug 5161801, return 'N' when it encounters any exception

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

2680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2681: --
2682: IF l_debug_on THEN
2683: 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);
2684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2685: END IF;
2686: --
2687: -- bug 5161801, return 'N' when it encounters any exception
2688: l_return_status := 'N';

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

2723: WSH_DEBUG_SV.log(l_module_name,'p_to_date',p_to_date);
2724: END IF;
2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2726:
2727: IF nvl(p_from_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2728: OR nvl(p_to_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2729: THEN
2730: IF (p_from_date > p_to_date) THEN
2731: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

2724: END IF;
2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2726:
2727: IF nvl(p_from_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2728: OR nvl(p_to_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date
2729: THEN
2730: IF (p_from_date > p_to_date) THEN
2731: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2732: FND_MESSAGE.SET_NAME('WSH','WSH_XC_INVALID_DATE_RANGE');

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

2814: FETCH get_trip_status_2 INTO l_valid_trip,l_trip_name;
2815: CLOSE get_trip_status_2;
2816: END IF;
2817:
2818: IF ( nvl(l_valid_trip, FND_API.G_MISS_CHAR) <> 'X' ) THEN
2819: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2820: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_STATUS_NO_ACTION');
2821: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
2822: wsh_util_core.add_message(x_return_status,l_module_name);

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

2856: --
2857: cursor l_carrier_csr is
2858: select carrier_id
2859: from wsh_carriers_v
2860: where nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
2861: and carrier_id = x_carrier_id
2862: and nvl(generic_flag, 'N') = 'N'
2863: and active = 'A'
2864: union all

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

2863: and active = 'A'
2864: union all
2865: select carrier_id
2866: from wsh_carriers_v
2867: where nvl(x_carrier_id,fnd_api.g_miss_num) = fnd_api.g_miss_num
2868: and carrier_name = p_carrier_name
2869: and nvl(generic_flag, 'N') = 'N'
2870: and active = 'A';
2871:

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

2890: END IF;
2891: --
2892: x_return_status := wsh_util_core.g_ret_sts_success;
2893: --
2894: IF nvl(x_carrier_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
2895: OR nvl(p_carrier_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
2896: THEN
2897: --
2898: open l_carrier_csr;

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

2891: --
2892: x_return_status := wsh_util_core.g_ret_sts_success;
2893: --
2894: IF nvl(x_carrier_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
2895: OR nvl(p_carrier_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
2896: THEN
2897: --
2898: open l_carrier_csr;
2899: fetch l_carrier_csr into x_carrier_id;

Line 3175: RAISE FND_API.G_EXC_ERROR;

3171: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_ENTITY_TYPE');
3172: FND_MESSAGE.SET_TOKEN('ENT_TYPE', p_entity_type);
3173: x_return_status := wsh_util_core.g_ret_sts_error;
3174: wsh_util_core.add_message(x_return_status,l_module_name);
3175: RAISE FND_API.G_EXC_ERROR;
3176: --
3177: END IF;
3178: --
3179: --

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

3253: --
3254: -- If the either one of carrier, service level or mode of transport is changed
3255: -- we need to nullify the Ship Method to keep the Pubic API behaviour
3256: -- in SYNC with the STF.
3257: IF nvl(l_carrier_id,fnd_api.g_miss_num) <> nvl(x_carrier_id,fnd_api.g_miss_num)
3258: or nvl(l_service_level,fnd_api.g_miss_char) <> nvl(x_service_level,fnd_api.g_miss_char)
3259: or nvl(l_mode_of_transport,fnd_api.g_miss_char) <> nvl(x_mode_of_transport,fnd_api.g_miss_char)
3260: THEN
3261: IF l_debug_on THEN

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

3254: -- If the either one of carrier, service level or mode of transport is changed
3255: -- we need to nullify the Ship Method to keep the Pubic API behaviour
3256: -- in SYNC with the STF.
3257: IF nvl(l_carrier_id,fnd_api.g_miss_num) <> nvl(x_carrier_id,fnd_api.g_miss_num)
3258: or nvl(l_service_level,fnd_api.g_miss_char) <> nvl(x_service_level,fnd_api.g_miss_char)
3259: or nvl(l_mode_of_transport,fnd_api.g_miss_char) <> nvl(x_mode_of_transport,fnd_api.g_miss_char)
3260: THEN
3261: IF l_debug_on THEN
3262: WSH_DEBUG_SV.logmsg(l_module_name,'Ship Method is being Nullified 1');

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

3255: -- we need to nullify the Ship Method to keep the Pubic API behaviour
3256: -- in SYNC with the STF.
3257: IF nvl(l_carrier_id,fnd_api.g_miss_num) <> nvl(x_carrier_id,fnd_api.g_miss_num)
3258: or nvl(l_service_level,fnd_api.g_miss_char) <> nvl(x_service_level,fnd_api.g_miss_char)
3259: or nvl(l_mode_of_transport,fnd_api.g_miss_char) <> nvl(x_mode_of_transport,fnd_api.g_miss_char)
3260: THEN
3261: IF l_debug_on THEN
3262: WSH_DEBUG_SV.logmsg(l_module_name,'Ship Method is being Nullified 1');
3263: END IF;

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

3264: x_ship_method_code := NULL;
3265: p_ship_method_name := NULL;
3266: END IF;
3267:
3268: IF nvl(x_service_level, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
3269: --
3270: validate_lookup(
3271: p_lookup_type => 'WSH_SERVICE_LEVELS',
3272: p_lookup_code => x_service_level,

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

3285: --
3286: END IF;
3287: --
3288: --
3289: IF nvl(x_mode_of_transport, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
3290: --
3291: validate_lookup(
3292: p_lookup_type => 'WSH_MODE_OF_TRANSPORT',
3293: p_lookup_code => x_mode_of_transport,

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

3316: --
3317: END IF;
3318: --
3319: IF l_sm_is_null = TRUE
3320: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3321: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3322: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3323: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3324: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =

Line 3321: NVL(x_carrier_id,fnd_api.G_MISS_NUM)

3317: END IF;
3318: --
3319: IF l_sm_is_null = TRUE
3320: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3321: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3322: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3323: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3324: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3325: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)

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

3318: --
3319: IF l_sm_is_null = TRUE
3320: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3321: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3322: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3323: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3324: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3325: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3326: THEN

Line 3323: NVL(x_service_level,fnd_api.G_MISS_CHAR)

3319: IF l_sm_is_null = TRUE
3320: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3321: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3322: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3323: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3324: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3325: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3326: THEN
3327: IF l_ship_method_code IS NOT NULL THEN

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

3320: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3321: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3322: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3323: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3324: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3325: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3326: THEN
3327: IF l_ship_method_code IS NOT NULL THEN
3328: p_ship_method_name := NULL;

Line 3325: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)

3321: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3322: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3323: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3324: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3325: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3326: THEN
3327: IF l_ship_method_code IS NOT NULL THEN
3328: p_ship_method_name := NULL;
3329: x_ship_method_code := NULL;

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

3334: -- Following Code is Commented for Bug 4000931
3335: -- Start of Comment for Bug 4000931
3336: /******
3337: ELSIF l_sm_is_null = FALSE
3338: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3339: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3340: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3341: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3342: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =

Line 3339: NVL(x_carrier_id,fnd_api.G_MISS_NUM)

3335: -- Start of Comment for Bug 4000931
3336: /******
3337: ELSIF l_sm_is_null = FALSE
3338: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3339: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3340: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3341: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3342: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3343: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)

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

3336: /******
3337: ELSIF l_sm_is_null = FALSE
3338: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3339: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3340: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3341: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3342: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3343: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3344: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN

Line 3341: NVL(x_service_level,fnd_api.G_MISS_CHAR)

3337: ELSIF l_sm_is_null = FALSE
3338: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3339: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3340: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3341: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3342: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3343: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3344: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN
3345: --

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

3338: AND NVL(l_carrier_id,fnd_api.G_MISS_NUM) =
3339: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3340: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3341: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3342: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3343: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3344: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN
3345: --
3346: x_return_status := wsh_util_core.g_ret_sts_success;

Line 3343: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)

3339: NVL(x_carrier_id,fnd_api.G_MISS_NUM)
3340: AND NVL(l_service_level,fnd_api.G_MISS_CHAR) =
3341: NVL(x_service_level,fnd_api.G_MISS_CHAR)
3342: AND NVL(l_mode_of_transport,fnd_api.G_MISS_CHAR) =
3343: NVL(x_mode_of_transport,fnd_api.G_MISS_CHAR)
3344: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED <> 'Y') THEN
3345: --
3346: x_return_status := wsh_util_core.g_ret_sts_success;
3347: IF l_debug_on THEN

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

3351: END IF;
3352: RETURN;
3353: ******/
3354: -- End of Comment for Bug 4000931
3355: ELSIF nvl(x_ship_method_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3356: AND nvl(l_ship_method_code,fnd_api.g_miss_char) <>
3357: nvl(x_ship_method_code,fnd_api.g_miss_char)
3358: THEN
3359: --

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

3352: RETURN;
3353: ******/
3354: -- End of Comment for Bug 4000931
3355: ELSIF nvl(x_ship_method_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3356: AND nvl(l_ship_method_code,fnd_api.g_miss_char) <>
3357: nvl(x_ship_method_code,fnd_api.g_miss_char)
3358: THEN
3359: --
3360: IF p_entity_type = 'DLVY' THEN

Line 3357: nvl(x_ship_method_code,fnd_api.g_miss_char)

3353: ******/
3354: -- End of Comment for Bug 4000931
3355: ELSIF nvl(x_ship_method_code,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3356: AND nvl(l_ship_method_code,fnd_api.g_miss_char) <>
3357: nvl(x_ship_method_code,fnd_api.g_miss_char)
3358: THEN
3359: --
3360: IF p_entity_type = 'DLVY' THEN
3361: --

Line 3373: RAISE FND_API.G_EXC_ERROR;

3369: close l_dlvy_ship_method_code_csr_tp;
3370: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');
3371: x_return_status := wsh_util_core.g_ret_sts_error;
3372: wsh_util_core.add_message(x_return_status,l_module_name);
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;
3375: --
3376: close l_dlvy_ship_method_code_csr_tp;
3377: ELSE

Line 3388: RAISE FND_API.G_EXC_ERROR;

3384: close l_dlvy_ship_method_code_csr;
3385: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_SHIP_METHOD');
3386: x_return_status := wsh_util_core.g_ret_sts_error;
3387: wsh_util_core.add_message(x_return_status,l_module_name);
3388: RAISE FND_API.G_EXC_ERROR;
3389: END IF;
3390: --
3391: close l_dlvy_ship_method_code_csr;
3392: END IF;

Line 3406: RAISE FND_API.G_EXC_ERROR;

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

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

3409: close l_trip_ship_method_code_csr;
3410: --
3411: END IF;
3412: --
3413: ELSIF nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
3414: AND nvl(x_service_level,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3415: AND nvl(x_mode_of_transport,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3416: THEN
3417: --

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

3410: --
3411: END IF;
3412: --
3413: ELSIF nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
3414: AND nvl(x_service_level,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3415: AND nvl(x_mode_of_transport,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3416: THEN
3417: --
3418: IF p_entity_type = 'DLVY' THEN

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

3411: END IF;
3412: --
3413: ELSIF nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
3414: AND nvl(x_service_level,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3415: AND nvl(x_mode_of_transport,fnd_api.g_miss_char) <> fnd_api.g_miss_char
3416: THEN
3417: --
3418: IF p_entity_type = 'DLVY' THEN
3419: --

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

3472: p_return_status => l_return_status,
3473: x_num_warnings => l_num_warnings,
3474: x_num_errors => l_num_errors);
3475: --
3476: ELSIF nvl(x_carrier_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num
3477: THEN
3478: --
3479: IF p_entity_type = 'DLVY' THEN
3480: --

Line 3527: RAISE FND_API.G_EXC_ERROR;

3523: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_MOT_STOP_COUNT');
3524: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
3525: x_return_status := wsh_util_core.g_ret_sts_error;
3526: wsh_util_core.add_message(x_return_status,l_module_name);
3527: RAISE FND_API.G_EXC_ERROR;
3528:
3529: END IF;
3530: END IF;
3531: --

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

3535: -- Fix for bug 4310011(OTM R12, glog proj)
3536: -- Do not show this warning message for FTE
3537: IF p_caller NOT LIKE 'FTE%' THEN
3538:
3539: IF NVL(l_ship_method_code_backup,fnd_api.G_MISS_CHAR) <>
3540: NVL(x_ship_method_code,fnd_api.G_MISS_CHAR) THEN
3541: --
3542: IF l_debug_on THEN
3543: wsh_debug_sv.logmsg(l_module_name,'Ship method calculated is different');

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

3536: -- Do not show this warning message for FTE
3537: IF p_caller NOT LIKE 'FTE%' THEN
3538:
3539: IF NVL(l_ship_method_code_backup,fnd_api.G_MISS_CHAR) <>
3540: NVL(x_ship_method_code,fnd_api.G_MISS_CHAR) THEN
3541: --
3542: IF l_debug_on THEN
3543: wsh_debug_sv.logmsg(l_module_name,'Ship method calculated is different');
3544: END IF;

Line 3562: WHEN FND_API.G_EXC_ERROR THEN

3558: END IF;
3559: --
3560: EXCEPTION
3561: --
3562: WHEN FND_API.G_EXC_ERROR THEN
3563: --
3564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3565: IF l_debug_on THEN
3566: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

3562: WHEN FND_API.G_EXC_ERROR THEN
3563: --
3564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3565: IF l_debug_on THEN
3566: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3567: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3568: END IF;
3569: --
3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3563: --
3564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3565: IF l_debug_on THEN
3566: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3567: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3568: END IF;
3569: --
3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3571: --

Line 3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3566: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3567: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3568: END IF;
3569: --
3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3571: --
3572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3573: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3574: IF l_debug_on THEN

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

3572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3573: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3574: IF l_debug_on THEN
3575: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3577: END IF;
3578: --
3579: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3580: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3658: RAISE FND_API.G_EXC_ERROR;

3654: l_container_item_flag, l_shippable_flag, l_vehicle_item_flag;
3655: IF veh_cont_item_cur%NOTFOUND THEN
3656: CLOSE veh_cont_item_cur;
3657: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ITEM');
3658: RAISE FND_API.G_EXC_ERROR;
3659: END IF;
3660: CLOSE veh_cont_item_cur;
3661:
3662: l_wms_org := wsh_util_validate.Check_Wms_Org(p_organization_id);

Line 3683: WHEN FND_API.G_EXC_ERROR THEN

3679: END IF;
3680: --
3681:
3682: EXCEPTION
3683: WHEN FND_API.G_EXC_ERROR THEN
3684: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3685: wsh_util_core.add_message(x_return_status,l_module_name);
3686: IF l_debug_on THEN
3687: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

3683: WHEN FND_API.G_EXC_ERROR THEN
3684: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3685: wsh_util_core.add_message(x_return_status,l_module_name);
3686: IF l_debug_on THEN
3687: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3689: END IF;
3690:
3691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3684: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3685: wsh_util_core.add_message(x_return_status,l_module_name);
3686: IF l_debug_on THEN
3687: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3689: END IF;
3690:
3691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3692: --

Line 3691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3687: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3689: END IF;
3690:
3691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3692: --
3693: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3694: IF l_debug_on THEN
3695: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

3692: --
3693: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3694: IF l_debug_on THEN
3695: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3697: END IF;
3698:
3699: WHEN OTHERS THEN
3700: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3753: raise FND_API.G_EXC_ERROR;

3749: p_delivery_detail_id => p_delivery_detail_id,
3750: p_msg_display => p_msg_display);
3751:
3752: IF l_return_status = wsh_util_core.g_ret_sts_error THEN
3753: raise FND_API.G_EXC_ERROR;
3754: ELSIF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
3755: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3756: END IF;
3757:

Line 3755: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3751:
3752: IF l_return_status = wsh_util_core.g_ret_sts_error THEN
3753: raise FND_API.G_EXC_ERROR;
3754: ELSIF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
3755: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3756: END IF;
3757:
3758: l_wms_installed := wsh_util_validate.Check_Wms_Org(p_organization_id);
3759:

Line 3783: WHEN FND_API.G_EXC_ERROR THEN

3779: END IF;
3780:
3781: RETURN l_org_type;
3782: EXCEPTION
3783: WHEN FND_API.G_EXC_ERROR THEN
3784: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3785: --
3786: IF l_debug_on THEN
3787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

3783: WHEN FND_API.G_EXC_ERROR THEN
3784: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3785: --
3786: IF l_debug_on THEN
3787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3789: END IF;
3790: RETURN l_org_type;
3791: --

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

3784: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3785: --
3786: IF l_debug_on THEN
3787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3789: END IF;
3790: RETURN l_org_type;
3791: --
3792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3789: END IF;
3790: RETURN l_org_type;
3791: --
3792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3794: --
3795: IF l_debug_on THEN
3796: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

3793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3794: --
3795: IF l_debug_on THEN
3796: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3797: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3798: END IF;
3799: RETURN l_org_type;
3800: --
3801: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 3888: RAISE FND_API.G_EXC_ERROR;

3884: p_inventory_item_id);
3885: END IF;
3886: --
3887: IF (p_organization_id IS NULL ) OR (p_inventory_item_id IS NULL )THEN
3888: RAISE FND_API.G_EXC_ERROR;
3889: END IF;
3890: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3891:
3892: l_hash_string := p_organization_id || '-'||p_inventory_item_id;

Line 3927: RAISE FND_API.G_EXC_ERROR;

3923: l_Item_info_rec.unit_volume;
3924:
3925: IF c_inventory_item_info%NOTFOUND THEN
3926: CLOSE c_inventory_item_info;
3927: RAISE FND_API.G_EXC_ERROR;
3928: END IF;
3929:
3930: CLOSE c_inventory_item_info;
3931:

Line 3959: WHEN FND_API.G_EXC_ERROR THEN

3955: WSH_DEBUG_SV.pop(l_module_name);
3956: END IF;
3957: EXCEPTION
3958:
3959: WHEN FND_API.G_EXC_ERROR THEN
3960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3961: --
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

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

3959: WHEN FND_API.G_EXC_ERROR THEN
3960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3961: --
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
3964: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3966: END IF;
3967: --

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

3961: --
3962: IF l_debug_on THEN
3963: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
3964: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3966: END IF;
3967: --
3968: WHEN OTHERS THEN
3969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

3972: IF l_debug_on THEN
3973: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
3974: 'Oracle error message is '||
3975: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3976: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3977: END IF;
3978:
3979:
3980: END get_item_info;

Line 4028: RAISE FND_API.G_EXC_ERROR;

4024: WSH_DEBUG_SV.log(l_module_name,'p_item_id',p_item_id);
4025: END IF;
4026: --
4027: IF p_item_id IS NULL THEN
4028: RAISE FND_API.G_EXC_ERROR;
4029: END IF;
4030: --
4031: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4032:

Line 4097: WHEN FND_API.G_EXC_ERROR THEN

4093: WSH_DEBUG_SV.pop(l_module_name);
4094: END IF;
4095:
4096: EXCEPTION
4097: WHEN FND_API.G_EXC_ERROR THEN
4098: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4099: --
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

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

4097: WHEN FND_API.G_EXC_ERROR THEN
4098: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4099: --
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4102: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4103: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4104: END IF;
4105: --

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

4099: --
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4102: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4103: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4104: END IF;
4105: --
4106:
4107: WHEN OTHERS THEN

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

4111: IF l_debug_on THEN
4112: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4113: 'Oracle error message is '||
4114: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4115: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4116: END IF;
4117:
4118: END Default_container;
4119:

Line 4194: Raise FND_API.G_EXC_ERROR;

4190: ,l_shipping_param_info.otm_enabled);
4191: END IF;
4192: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,
4193: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
4194: Raise FND_API.G_EXC_ERROR;
4195: END IF;
4196: IF l_shipping_param_info.otm_enabled = 'Y' THEN
4197: x_ignore_for_planning := 'N';
4198: ELSE

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

4236: IF l_debug_on THEN
4237: WSH_DEBUG_SV.log(l_module_name,'l_wh_type,l_return_status',
4238: l_wh_type||l_return_status);
4239: END IF;
4240: IF (nvl(l_wh_type, FND_API.G_MISS_CHAR) IN ('TPW','CMS')) THEN
4241: x_ignore_for_planning:='Y';
4242: ELSE
4243: x_ignore_for_planning:='N';
4244: END IF;

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

4257: IF l_debug_on THEN
4258: WSH_DEBUG_SV.pop(l_module_name,x_ignore_for_planning);
4259: END IF;
4260: EXCEPTION
4261: WHEN FND_API.G_EXC_ERROR THEN --{ --OTM R12 Start
4262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4263: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4264: IF l_debug_on THEN
4265: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

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

4261: WHEN FND_API.G_EXC_ERROR THEN --{ --OTM R12 Start
4262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4263: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4264: IF l_debug_on THEN
4265: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4266: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4267: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4268: END IF; --} --OTM R12 End
4269: WHEN OTHERS THEN

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

4263: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
4264: IF l_debug_on THEN
4265: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4266: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4267: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4268: END IF; --} --OTM R12 End
4269: WHEN OTHERS THEN
4270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4271: wsh_util_core.default_handler('WSH_UTIL_CORE.DEFAULT_CONTAINER');

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

4273: IF l_debug_on THEN
4274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4275: 'Oracle error message is '||
4276: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4278: END IF;
4279: END Calc_ignore_for_planning;
4280:
4281: -- Added for Inbound Logistics

Line 4414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4410: END IF;
4411: --
4412: EXCEPTION
4413: WHEN OTHERS THEN
4414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4415: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FOB',l_module_name);
4416: --
4417: -- Debug Statements
4418: --

Line 4560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4556: END IF;
4557: --
4558: EXCEPTION
4559: WHEN OTHERS THEN
4560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4561: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_TERMS',l_module_name);
4562: --
4563: -- Debug Statements
4564: --

Line 4663: RAISE FND_API.G_EXC_ERROR;

4659: fnd_message.SET_name('WSH', 'WSH_SUPP_LOCN_ERROR');
4660: FND_MESSAGE.SET_TOKEN('LOCATION_NAME',l_location_name);
4661: --
4662: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
4663: RAISE FND_API.G_EXC_ERROR;
4664: --}
4665: END IF;
4666: --
4667: CLOSE locn_csr;

Line 4678: WHEN FND_API.G_EXC_ERROR THEN

4674: --}
4675: EXCEPTION
4676: --{
4677: --
4678: WHEN FND_API.G_EXC_ERROR THEN
4679:
4680: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4681: --
4682: IF l_debug_on THEN

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

4679:
4680: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4681: --
4682: IF l_debug_on THEN
4683: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4685: END IF;
4686: --
4687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4680: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4681: --
4682: IF l_debug_on THEN
4683: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4685: END IF;
4686: --
4687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4688:

Line 4687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4683: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4685: END IF;
4686: --
4687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4688:
4689: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4690: --
4691: IF l_debug_on THEN

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

4689: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4690: --
4691: IF l_debug_on THEN
4692: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4693: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4694: END IF;
4695: --
4696: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4697: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

5052: select flv.lookup_code ship_method_code,
5053: flv.meaning
5054: from fnd_lookup_values_vl flv, wsh_carrier_services wcs
5055: where flv.lookup_code = wcs.ship_method_code
5056: and NVL(p_ship_method_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR
5057: and flv.lookup_type = 'SHIP_METHOD'
5058: and flv.view_application_id = 3
5059: and flv.meaning = p_ship_method_name
5060: and wcs.enabled_flag='Y' ;

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

5082: END IF;
5083: --
5084: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5085: --
5086: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
5087: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
5088: THEN
5089: --
5090: OPEN check_ship_method;

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

5083: --
5084: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5085: --
5086: IF nvl(p_ship_method_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
5087: OR nvl(p_ship_method_name, fnd_api.g_miss_char) <> fnd_api.g_miss_char
5088: THEN
5089: --
5090: OPEN check_ship_method;
5091: FETCH check_ship_method INTO p_ship_method_code, p_ship_method_name;