477: l_serial_number VARCHAR2(100);
478:
479:
480: BEGIN
481: -- Standard Start of API savepoint
482: SAVEPOINT INSERT_ASSETATTR_VALUE;
483: -- Standard call to check for call compatibility.
484: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
485: p_api_version ,
479:
480: BEGIN
481: -- Standard Start of API savepoint
482: SAVEPOINT INSERT_ASSETATTR_VALUE;
483: -- Standard call to check for call compatibility.
484: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
485: p_api_version ,
486: l_api_name ,
487: G_PKG_NAME )
887: fnd_global.user_id
888: );
889:
890: -- End of API body.
891: -- Standard check of p_commit.
892: IF FND_API.To_Boolean( p_commit ) THEN
893: COMMIT WORK;
894: END IF;
895: -- Standard call to get message count and if count is 1, get message info.
891: -- Standard check of p_commit.
892: IF FND_API.To_Boolean( p_commit ) THEN
893: COMMIT WORK;
894: END IF;
895: -- Standard call to get message count and if count is 1, get message info.
896: FND_MSG_PUB.get
897: ( p_msg_index_out => x_msg_count ,
898: p_data => x_msg_data
899: );
1012: l_item_id NUMBER;
1013: l_serial_number VARCHAR2(100);
1014:
1015: BEGIN
1016: -- Standard Start of API savepoint
1017: SAVEPOINT update_assetattr_value;
1018: -- Standard call to check for call compatibility.
1019: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1020: p_api_version ,
1014:
1015: BEGIN
1016: -- Standard Start of API savepoint
1017: SAVEPOINT update_assetattr_value;
1018: -- Standard call to check for call compatibility.
1019: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1020: p_api_version ,
1021: l_api_name ,
1022: G_PKG_NAME )
1344:
1345:
1346:
1347: -- End of API body.
1348: -- Standard check of p_commit.
1349: IF FND_API.To_Boolean( p_commit ) THEN
1350: COMMIT WORK;
1351: END IF;
1352: -- Standard call to get message count and if count is 1, get message info.
1348: -- Standard check of p_commit.
1349: IF FND_API.To_Boolean( p_commit ) THEN
1350: COMMIT WORK;
1351: END IF;
1352: -- Standard call to get message count and if count is 1, get message info.
1353: FND_MSG_PUB.get
1354: ( p_msg_index_out => x_msg_count ,
1355: p_data => x_msg_data
1356: );