DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on APP_EXCEPTION

Line 4073: APP_EXCEPTION.Raise_Exception;

4069: USING IN l_Inventory_Item_ID, IN l_Organization_ID, OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
4070:
4071: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
4072: FND_MESSAGE.Set_Encoded (l_msg_data);
4073: APP_EXCEPTION.Raise_Exception;
4074: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4075: FND_MESSAGE.Set_Encoded (l_msg_data);
4076: APP_EXCEPTION.Raise_Exception;
4077: END IF;

Line 4076: APP_EXCEPTION.Raise_Exception;

4072: FND_MESSAGE.Set_Encoded (l_msg_data);
4073: APP_EXCEPTION.Raise_Exception;
4074: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
4075: FND_MESSAGE.Set_Encoded (l_msg_data);
4076: APP_EXCEPTION.Raise_Exception;
4077: END IF;
4078:
4079: END IF;
4080:

Line 4418: app_exception.raise_exception;

4414: END IF;
4415: IF c_get_item_count%ISOPEN THEN
4416: CLOSE c_get_item_count;
4417: END IF;
4418: app_exception.raise_exception;
4419:
4420: WHEN OTHERS THEN
4421: x_row_Id := NULL;
4422: IF c_get_uom_class%ISOPEN THEN

Line 4428: app_exception.raise_exception;

4424: END IF;
4425: IF c_get_item_count%ISOPEN THEN
4426: CLOSE c_get_item_count;
4427: END IF;
4428: app_exception.raise_exception;
4429:
4430: END Create_Item;
4431:
4432:

Line 4768: app_exception.raise_exception;

4764: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
4765: IF c_get_uom_class%ISOPEN THEN
4766: CLOSE c_get_uom_class;
4767: END IF;
4768: app_exception.raise_exception;
4769:
4770: WHEN OTHERS THEN
4771: IF c_get_uom_class%ISOPEN THEN
4772: CLOSE c_get_uom_class;

Line 4774: app_exception.raise_exception;

4770: WHEN OTHERS THEN
4771: IF c_get_uom_class%ISOPEN THEN
4772: CLOSE c_get_uom_class;
4773: END IF;
4774: app_exception.raise_exception;
4775: END Update_Item;
4776:
4777: -- ------------------ LOCK_ITEM -------------------
4778: PROCEDURE Lock_Item( P_Item_Rec IN INV_ITEM_API.Item_rec_type) IS

Line 5877: app_exception.raise_exception;

5873: END IF;
5874: IF ( c_get_item_description%ISOPEN ) THEN
5875: CLOSE c_get_item_description ;
5876: END IF;
5877: app_exception.raise_exception;
5878:
5879: END Lock_Item;
5880:
5881: -- ------------------ DELETE_ROW -------------------

Line 6018: app_exception.raise_exception;

6014: end;
6015:
6016: if ((length(x_description)) <> length(rtrim(x_description))) then
6017: fnd_message.Set_Name( 'INV', 'INV_DESCR_TRAILING_SPACES' );
6018: app_exception.raise_exception;
6019: end if;
6020:
6021: if ((length(x_long_description)) <> length(rtrim(x_long_description))) then
6022: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_TRAILING_SPACES' );

Line 6023: app_exception.raise_exception;

6019: end if;
6020:
6021: if ((length(x_long_description)) <> length(rtrim(x_long_description))) then
6022: fnd_message.Set_Name( 'INV', 'INV_LONGDESCR_TRAILING_SPACES' );
6023: app_exception.raise_exception;
6024: return ;
6025: end if;
6026: /*
6027: update mtl_system_items_tl

Line 6139: app_exception.raise_exception;

6135: WHEN FND_API.g_EXC_UNEXPECTED_ERROR THEN
6136: IF ( c_item_name%ISOPEN ) THEN
6137: CLOSE c_item_name;
6138: END IF;
6139: app_exception.raise_exception;
6140:
6141: END Check_Master_Record_Locked;
6142:
6143: /*Bug 6407303 Adding new functions to se and get the value of the attribute G_IS_MASTER_ATTR_MODIFIED */