486: l_serial_number VARCHAR2(100);
487:
488:
489: BEGIN
490: -- Standard Start of API savepoint
491: SAVEPOINT INSERT_ASSETATTR_VALUE;
492: -- Standard call to check for call compatibility.
493: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
494: p_api_version ,
488:
489: BEGIN
490: -- Standard Start of API savepoint
491: SAVEPOINT INSERT_ASSETATTR_VALUE;
492: -- Standard call to check for call compatibility.
493: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
494: p_api_version ,
495: l_api_name ,
496: G_PKG_NAME )
896: fnd_global.user_id
897: );
898:
899: -- End of API body.
900: -- Standard check of p_commit.
901: IF FND_API.To_Boolean( p_commit ) THEN
902: COMMIT WORK;
903: END IF;
904: -- Standard call to get message count and if count is 1, get message info.
900: -- Standard check of p_commit.
901: IF FND_API.To_Boolean( p_commit ) THEN
902: COMMIT WORK;
903: END IF;
904: -- Standard call to get message count and if count is 1, get message info.
905: FND_MSG_PUB.get
906: ( p_msg_index_out => x_msg_count ,
907: p_data => x_msg_data
908: );
1021: l_item_id NUMBER;
1022: l_serial_number VARCHAR2(100);
1023:
1024: BEGIN
1025: -- Standard Start of API savepoint
1026: SAVEPOINT update_assetattr_value;
1027: -- Standard call to check for call compatibility.
1028: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1029: p_api_version ,
1023:
1024: BEGIN
1025: -- Standard Start of API savepoint
1026: SAVEPOINT update_assetattr_value;
1027: -- Standard call to check for call compatibility.
1028: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1029: p_api_version ,
1030: l_api_name ,
1031: G_PKG_NAME )
1353:
1354:
1355:
1356: -- End of API body.
1357: -- Standard check of p_commit.
1358: IF FND_API.To_Boolean( p_commit ) THEN
1359: COMMIT WORK;
1360: END IF;
1361: -- Standard call to get message count and if count is 1, get message info.
1357: -- Standard check of p_commit.
1358: IF FND_API.To_Boolean( p_commit ) THEN
1359: COMMIT WORK;
1360: END IF;
1361: -- Standard call to get message count and if count is 1, get message info.
1362: FND_MSG_PUB.get
1363: ( p_msg_index_out => x_msg_count ,
1364: p_data => x_msg_data
1365: );