348: l_item_id NUMBER;
349: l_count number;
350:
351: BEGIN
352: -- Standard Start of API savepoint
353: SAVEPOINT insert_asset_routes;
354: -- Standard call to check for call compatibility.
355: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
356: p_api_version ,
350:
351: BEGIN
352: -- Standard Start of API savepoint
353: SAVEPOINT insert_asset_routes;
354: -- Standard call to check for call compatibility.
355: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
356: p_api_version ,
357: l_api_name ,
358: G_PKG_NAME )
677:
678:
679:
680: -- End of API body.
681: -- Standard check of p_commit.
682: IF FND_API.To_Boolean( p_commit ) THEN
683: COMMIT WORK;
684: END IF;
685: -- Standard call to get message count and if count is 1, get message info.
681: -- Standard check of p_commit.
682: IF FND_API.To_Boolean( p_commit ) THEN
683: COMMIT WORK;
684: END IF;
685: -- Standard call to get message count and if count is 1, get message info.
686: FND_MSG_PUB.get
687: ( p_msg_index_out => x_msg_count ,
688: p_data => x_msg_data
689: );
786: l_item_id NUMBER;
787: l_serial_number VARCHAR2(100);
788: l_count number;
789: BEGIN
790: -- Standard Start of API savepoint
791: SAVEPOINT update_asset_routes;
792: -- Standard call to check for call compatibility.
793: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
794: p_api_version ,
788: l_count number;
789: BEGIN
790: -- Standard Start of API savepoint
791: SAVEPOINT update_asset_routes;
792: -- Standard call to check for call compatibility.
793: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
794: p_api_version ,
795: l_api_name ,
796: G_PKG_NAME )
1066: WHERE NETWORK_ASSOCIATION_ID = P_NETWORK_ASSOCIATION_ID;
1067:
1068:
1069: -- End of API body.
1070: -- Standard check of p_commit.
1071: IF FND_API.To_Boolean( p_commit ) THEN
1072: COMMIT WORK;
1073: END IF;
1074: -- Standard call to get message count and if count is 1, get message info.
1070: -- Standard check of p_commit.
1071: IF FND_API.To_Boolean( p_commit ) THEN
1072: COMMIT WORK;
1073: END IF;
1074: -- Standard call to get message count and if count is 1, get message info.
1075: FND_MSG_PUB.get
1076: ( p_msg_index_out => x_msg_count ,
1077: p_data => x_msg_data
1078: );