DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_INV dependencies on FND_API

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
349: END IF;
350: --
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352:
353: END Inventory_Item;
354:
355: -- bug 5264874

Line 1564: RAISE FND_API.G_EXC_ERROR;

1560: , p_subinventory_name => p_subinventory
1561: , x_mtl_sec_inv_rec => l_mtl_sec_inv_rec
1562: , x_return_status => l_return_status);
1563: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1564: RAISE FND_API.G_EXC_ERROR;
1565: END IF;
1566:
1567: l_sub_loc_ctl := l_mtl_sec_inv_rec.locator_type;
1568:

Line 1575: WHEN FND_API.G_EXC_ERROR THEN

1571: END IF;
1572: --
1573: RETURN l_sub_loc_ctl;
1574: EXCEPTION
1575: WHEN FND_API.G_EXC_ERROR THEN
1576: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1577: WSH_UTIL_CORE.Add_Message(l_return_status);
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1575: WHEN FND_API.G_EXC_ERROR THEN
1576: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1577: WSH_UTIL_CORE.Add_Message(l_return_status);
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1580: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1581: END IF;
1582: END Sub_Loc_Ctl;
1583:

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

1576: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1577: WSH_UTIL_CORE.Add_Message(l_return_status);
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1580: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1581: END IF;
1582: END Sub_Loc_Ctl;
1583:
1584:

Line 1634: RAISE FND_API.G_EXC_ERROR;

1630: , x_mtl_org_param_rec => l_mtl_org_param_rec
1631: , x_return_status => l_return_status);
1632:
1633: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1634: RAISE FND_API.G_EXC_ERROR;
1635: END IF;
1636:
1637: l_org_loc_ctl := l_mtl_org_param_rec.stock_locator_control_code;
1638:

Line 1647: WHEN FND_API.G_EXC_ERROR THEN

1643: --
1644: RETURN l_org_loc_ctl;
1645:
1646: EXCEPTION
1647: WHEN FND_API.G_EXC_ERROR THEN
1648: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1649: WSH_UTIL_CORE.Add_Message(l_return_status);
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1647: WHEN FND_API.G_EXC_ERROR THEN
1648: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1649: WSH_UTIL_CORE.Add_Message(l_return_status);
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1653: END IF;
1654:
1655: END Get_Org_Loc;

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

1648: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1649: WSH_UTIL_CORE.Add_Message(l_return_status);
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1653: END IF;
1654:
1655: END Get_Org_Loc;
1656:

Line 1932: RAISE FND_API.G_EXC_ERROR;

1928: , x_mtl_org_param_rec => l_mtl_org_param_rec
1929: , x_return_status => l_return_status);
1930:
1931: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934:
1935: l_neg_inv_code := l_mtl_org_param_rec.negative_inv_receipt_code;
1936:

Line 2079: WHEN FND_API.G_EXC_ERROR THEN

2075: END IF;
2076:
2077: EXCEPTION
2078:
2079: WHEN FND_API.G_EXC_ERROR THEN
2080: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2081: WSH_UTIL_CORE.Add_Message(l_return_status);
2082: IF l_debug_on THEN
2083: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2079: WHEN FND_API.G_EXC_ERROR THEN
2080: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2081: WSH_UTIL_CORE.Add_Message(l_return_status);
2082: IF l_debug_on THEN
2083: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2084: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2085: END IF;
2086:
2087: WHEN others THEN

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

2080: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2081: WSH_UTIL_CORE.Add_Message(l_return_status);
2082: IF l_debug_on THEN
2083: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2084: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2085: END IF;
2086:
2087: WHEN others THEN
2088: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code');

Line 4152: RAISE FND_API.G_EXC_ERROR;

4148: , x_mtl_system_items_rec => l_item_info
4149: , x_return_status => l_return_status);
4150:
4151: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4152: RAISE FND_API.G_EXC_ERROR;
4153: END IF;
4154:
4155: l_type := l_item_info.reservable_type;
4156: l_trx_flag := l_item_info.mtl_transactions_enabled_flag;

Line 4178: WHEN FND_API.G_EXC_ERROR THEN

4174: return l_flag;
4175:
4176: EXCEPTION
4177:
4178: WHEN FND_API.G_EXC_ERROR THEN
4179: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4180: WSH_UTIL_CORE.Add_Message(l_return_status);
4181: IF l_debug_on THEN
4182: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

4178: WHEN FND_API.G_EXC_ERROR THEN
4179: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4180: WSH_UTIL_CORE.Add_Message(l_return_status);
4181: IF l_debug_on THEN
4182: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4183: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4184: END IF;
4185: --
4186: return 'Y';

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

4179: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4180: WSH_UTIL_CORE.Add_Message(l_return_status);
4181: IF l_debug_on THEN
4182: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4183: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4184: END IF;
4185: --
4186: return 'Y';
4187:

Line 4298: RAISE FND_API.G_EXC_ERROR;

4294: , x_mtl_system_items_rec => l_item_info
4295: , x_return_status => l_return_status);
4296:
4297: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4298: RAISE FND_API.G_EXC_ERROR;
4299: END IF;
4300:
4301: l_reservable_type := l_item_info.reservable_type;
4302:

Line 4324: WHEN FND_API.G_EXC_ERROR THEN

4320: RETURN g_cache_reservable_flag;
4321:
4322: EXCEPTION
4323:
4324: WHEN FND_API.G_EXC_ERROR THEN
4325: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4326: WSH_UTIL_CORE.Add_Message(x_return_status);
4327: IF l_debug_on THEN
4328: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

4324: WHEN FND_API.G_EXC_ERROR THEN
4325: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4326: WSH_UTIL_CORE.Add_Message(x_return_status);
4327: IF l_debug_on THEN
4328: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4329: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4330: END IF;
4331:
4332: WHEN OTHERS THEN

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

4325: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4326: WSH_UTIL_CORE.Add_Message(x_return_status);
4327: IF l_debug_on THEN
4328: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4329: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4330: END IF;
4331:
4332: WHEN OTHERS THEN
4333: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_DETAILS_INV.Line_Reserved');

Line 4430: RAISE FND_API.G_EXC_ERROR;

4426: , x_mtl_org_param_rec => l_mtl_org_param_rec
4427: , x_return_status => l_return_status);
4428:
4429: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4430: RAISE FND_API.G_EXC_ERROR;
4431: END IF;
4432:
4433: serial_number_type := l_mtl_org_param_rec.serial_number_type;
4434: IF serial_number_type = -99 THEN

Line 4544: WHEN FND_API.G_EXC_ERROR THEN

4540: END IF;
4541: --
4542: EXCEPTION
4543:
4544: WHEN FND_API.G_EXC_ERROR THEN
4545: -- RTV Changes
4546: IF c_header_info%ISOPEN THEN
4547: close c_header_info;
4548: END IF;

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

4548: END IF;
4549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4550: WSH_UTIL_CORE.Add_Message(x_return_status);
4551: IF l_debug_on THEN
4552: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4553: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4554: END IF;
4555:
4556: WHEN WSH_INVALID_SER_NUM THEN

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

4549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4550: WSH_UTIL_CORE.Add_Message(x_return_status);
4551: IF l_debug_on THEN
4552: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4553: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4554: END IF;
4555:
4556: WHEN WSH_INVALID_SER_NUM THEN
4557: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4684: raise FND_API.G_EXC_ERROR;

4680:
4681: IF (l_result <> INV_VALIDATE.T) THEN
4682: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4683: FND_MESSAGE.SET_TOKEN('INV_ATTRIBUTE', 'Organization');
4684: raise FND_API.G_EXC_ERROR;
4685: END IF;
4686: g_item.inventory_item_id := p_inventory_item_id;
4687:
4688: IF l_debug_on THEN

Line 4702: raise FND_API.G_EXC_ERROR;

4698:
4699: IF (l_result <> INV_VALIDATE.T) THEN
4700: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4701: FND_MESSAGE.SET_TOKEN('INV_ATTRIBUTE', 'Item');
4702: raise FND_API.G_EXC_ERROR;
4703: END IF;
4704:
4705: g_sub.secondary_inventory_name := p_subinventory;
4706:

Line 4732: raise FND_API.G_EXC_ERROR;

4728:
4729: IF (l_result <> INV_VALIDATE.T) THEN
4730: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4731: FND_MESSAGE.SET_TOKEN('INV_ATTRIBUTE', 'Locator');
4732: raise FND_API.G_EXC_ERROR;
4733: END IF;
4734:
4735: g_loc.inventory_location_id := p_locator_id;
4736: -- Need to check if locator is NULL cause inventory validation API will

Line 4764: raise FND_API.G_EXC_ERROR;

4760:
4761: IF (l_result = INV_VALIDATE.F) THEN
4762: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4763: FND_MESSAGE.SET_TOKEN('INV_ATTRIBUTE', 'Locator');
4764: raise FND_API.G_EXC_ERROR;
4765: END IF;
4766: END IF;
4767:
4768: g_lot.lot_number := p_lot_number;

Line 4799: raise FND_API.G_EXC_ERROR;

4795:
4796: IF (l_result <> INV_VALIDATE.T) THEN
4797: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4798: FND_MESSAGE.SET_TOKEN('INV_ATTRIBUTE', 'Lot');--Material Status Impact
4799: raise FND_API.G_EXC_ERROR;
4800: END IF;
4801: END IF;
4802:
4803: IF l_debug_on THEN

Line 4907: WHEN FND_API.G_EXC_ERROR THEN

4903: WSH_DEBUG_SV.pop(l_module_name);
4904: END IF;
4905:
4906: EXCEPTION
4907: WHEN FND_API.G_EXC_ERROR THEN
4908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4909: WSH_UTIL_CORE.Add_Message(x_return_status);
4910: IF l_debug_on THEN
4911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

4907: WHEN FND_API.G_EXC_ERROR THEN
4908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4909: WSH_UTIL_CORE.Add_Message(x_return_status);
4910: IF l_debug_on THEN
4911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4913: END IF;
4914:
4915: WHEN others THEN

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

4908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4909: WSH_UTIL_CORE.Add_Message(x_return_status);
4910: IF l_debug_on THEN
4911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4913: END IF;
4914:
4915: WHEN others THEN
4916: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4997: RAISE FND_API.G_EXC_ERROR;

4993: , x_mtl_org_param_rec => l_mtl_org_param_rec
4994: , x_return_status => l_return_status);
4995:
4996: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4997: RAISE FND_API.G_EXC_ERROR;
4998: END IF;
4999:
5000: l_serial_number_type := l_mtl_org_param_rec.serial_number_type;
5001: IF l_serial_number_type = -99 THEN

Line 5002: raise FND_API.G_EXC_ERROR;

4998: END IF;
4999:
5000: l_serial_number_type := l_mtl_org_param_rec.serial_number_type;
5001: IF l_serial_number_type = -99 THEN
5002: raise FND_API.G_EXC_ERROR;
5003: END IF;
5004: -- bug 5264874 end
5005:
5006: open c_header_info(p_delivery_detail_id);

Line 5075: RAISE FND_API.G_EXC_ERROR;

5071: p_check_for_grp_mark_id => 'Y' --Bug# 2656316
5072: );
5073:
5074: IF l_return = 1 THEN
5075: RAISE FND_API.G_EXC_ERROR;
5076: END IF;
5077:
5078:
5079:

Line 5086: RAISE FND_API.G_EXC_ERROR;

5082: wsh_debug_sv.log(l_module_name, 'Prefix', l_prefix);
5083: END IF;
5084: IF (l_quantity <> p_quantity) THEN
5085: fnd_message.set_name('WSH', 'WSH_SERIAL_NUM_WRG_RANGE');
5086: RAISE FND_API.G_EXC_ERROR;
5087: END IF;
5088:
5089: x_prefix := l_prefix;
5090:

Line 5096: WHEN FND_API.G_EXC_ERROR THEN

5092: WSH_DEBUG_SV.pop(l_module_name);
5093: END IF;
5094:
5095: EXCEPTION
5096: WHEN FND_API.G_EXC_ERROR THEN
5097: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5098: WSH_UTIL_CORE.Add_Message(x_return_status);
5099: IF l_debug_on THEN
5100: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

5096: WHEN FND_API.G_EXC_ERROR THEN
5097: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5098: WSH_UTIL_CORE.Add_Message(x_return_status);
5099: IF l_debug_on THEN
5100: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5101: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5102: END IF;
5103: --RTV changes
5104: IF c_header_info%ISOPEN THEN

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

5097: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5098: WSH_UTIL_CORE.Add_Message(x_return_status);
5099: IF l_debug_on THEN
5100: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5101: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5102: END IF;
5103: --RTV changes
5104: IF c_header_info%ISOPEN THEN
5105: close c_header_info;

Line 5671: RAISE FND_API.G_EXC_ERROR;

5667: OPEN c_get_rtv_type;
5668: FETCH c_get_rtv_type INTO l_rtv_shipment_line_id;
5669: IF (c_get_rtv_type%NOTFOUND ) then
5670: CLOSE c_get_rtv_type;
5671: RAISE FND_API.G_EXC_ERROR;
5672: ELSE
5673: IF ( l_rtv_shipment_line_id IS NULL) then
5674: x_transaction_type_id := 1005;
5675: ELSE