125: l_revalue_cip_assets_flag v30_tbl;
126:
127: -- variables and structs used for api call
128: l_api_version NUMBER := 1.0;
129: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
130: l_commit VARCHAR2(1) := FND_API.G_FALSE;
131: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
132: l_return_status VARCHAR2(1);
133: l_mesg_count number;
126:
127: -- variables and structs used for api call
128: l_api_version NUMBER := 1.0;
129: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
130: l_commit VARCHAR2(1) := FND_API.G_FALSE;
131: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
132: l_return_status VARCHAR2(1);
133: l_mesg_count number;
134: l_mesg VARCHAR2(4000);
127: -- variables and structs used for api call
128: l_api_version NUMBER := 1.0;
129: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
130: l_commit VARCHAR2(1) := FND_API.G_FALSE;
131: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
132: l_return_status VARCHAR2(1);
133: l_mesg_count number;
134: l_mesg VARCHAR2(4000);
135: l_calling_fn VARCHAR2(30) := 'fa_mass_reval_pkg.do_reval';
543: px_asset_hdr_rec => l_asset_hdr_rec,
544: p_reval_options_rec => l_reval_options_rec
545: );
546:
547: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
548: l_mesg_name := null;
549: raise reval_err;
550: end if;
551:
739:
740: if (l_msg_count > 0) then
741:
742: fa_rx_conc_mesg_pkg.log(
743: fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_FALSE));
744:
745: for i in 1..(l_msg_count-1) loop
746: fa_rx_conc_mesg_pkg.log(
747: fnd_msg_pub.get(fnd_msg_pub.G_NEXT, fnd_api.G_FALSE));
743: fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_FALSE));
744:
745: for i in 1..(l_msg_count-1) loop
746: fa_rx_conc_mesg_pkg.log(
747: fnd_msg_pub.get(fnd_msg_pub.G_NEXT, fnd_api.G_FALSE));
748: end loop;
749:
750: end if;
751: