DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on APP_EXCEPTION

Line 4338: APP_EXCEPTION.Raise_Exception;

4334: USING IN l_Inventory_Item_ID, IN l_Organization_ID, OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
4335:
4336: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
4337: FND_MESSAGE.Set_Encoded (l_msg_data);
4338: APP_EXCEPTION.Raise_Exception;
4339: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4340: FND_MESSAGE.Set_Encoded (l_msg_data);
4341: APP_EXCEPTION.Raise_Exception;
4342: END IF;

Line 4341: APP_EXCEPTION.Raise_Exception;

4337: FND_MESSAGE.Set_Encoded (l_msg_data);
4338: APP_EXCEPTION.Raise_Exception;
4339: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4340: FND_MESSAGE.Set_Encoded (l_msg_data);
4341: APP_EXCEPTION.Raise_Exception;
4342: END IF;
4343:
4344: END IF;
4345:

Line 4683: app_exception.raise_exception;

4679: END IF;
4680: IF c_get_item_count%ISOPEN THEN
4681: CLOSE c_get_item_count;
4682: END IF;
4683: app_exception.raise_exception;
4684:
4685: WHEN OTHERS THEN
4686: x_row_Id := NULL;
4687: IF c_get_uom_class%ISOPEN THEN

Line 4693: app_exception.raise_exception;

4689: END IF;
4690: IF c_get_item_count%ISOPEN THEN
4691: CLOSE c_get_item_count;
4692: END IF;
4693: app_exception.raise_exception;
4694:
4695: END Create_Item;
4696:
4697:

Line 5120: app_exception.raise_exception;

5116: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
5117: IF c_get_uom_class%ISOPEN THEN
5118: CLOSE c_get_uom_class;
5119: END IF;
5120: app_exception.raise_exception;
5121:
5122: WHEN OTHERS THEN
5123: IF c_get_uom_class%ISOPEN THEN
5124: CLOSE c_get_uom_class;

Line 5126: app_exception.raise_exception;

5122: WHEN OTHERS THEN
5123: IF c_get_uom_class%ISOPEN THEN
5124: CLOSE c_get_uom_class;
5125: END IF;
5126: app_exception.raise_exception;
5127: END Update_Item;
5128:
5129: -- ------------------ LOCK_ITEM -------------------
5130: PROCEDURE Lock_Item( P_Item_Rec IN INV_ITEM_API.Item_rec_type) IS

Line 6234: app_exception.raise_exception;

6230: END IF;
6231: IF ( c_get_item_description%ISOPEN ) THEN
6232: CLOSE c_get_item_description ;
6233: END IF;
6234: app_exception.raise_exception;
6235:
6236: END Lock_Item;
6237:
6238: -- ------------------ DELETE_ROW -------------------

Line 6507: app_exception.raise_exception;

6503: end;
6504:
6505: if ((length(x_description)) <> length(rtrim(x_description))) then
6506: fnd_message.Set_Name( 'INV', 'INV_DESCR_TRAILING_SPACES' );
6507: app_exception.raise_exception;
6508: end if;
6509:
6510: if ((length(x_long_description)) <> length(rtrim(x_long_description))) then
6511: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_TRAILING_SPACES' );

Line 6512: app_exception.raise_exception;

6508: end if;
6509:
6510: if ((length(x_long_description)) <> length(rtrim(x_long_description))) then
6511: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_TRAILING_SPACES' );
6512: app_exception.raise_exception;
6513: return ;
6514: end if;
6515:
6516: --- bug 8717482 vggarg added validations for leaing spaces also.

Line 6519: app_exception.raise_exception;

6515:
6516: --- bug 8717482 vggarg added validations for leaing spaces also.
6517: if ((length(x_description)) <> length(ltrim(x_description))) then
6518: fnd_message.Set_Name( 'INV', 'INV_DESCR_LEADING_SPACES' );
6519: app_exception.raise_exception;
6520: end if;
6521:
6522: if ((length(x_long_description)) <> length(ltrim(x_long_description))) then
6523: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_LEADING_SPACES' );

Line 6524: app_exception.raise_exception;

6520: end if;
6521:
6522: if ((length(x_long_description)) <> length(ltrim(x_long_description))) then
6523: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_LEADING_SPACES' );
6524: app_exception.raise_exception;
6525: return ;
6526: end if;
6527: --- bug 8717482 vggarg end changes
6528:

Line 6642: app_exception.raise_exception;

6638: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
6639: IF ( c_item_name%ISOPEN ) THEN
6640: CLOSE c_item_name;
6641: END IF;
6642: app_exception.raise_exception;
6643:
6644: END Check_Master_Record_Locked;
6645:
6646: /*Bug 6407303 Adding new functions to se and get the value of the attribute G_IS_MASTER_ATTR_MODIFIED */