116: l_revalue_cip_assets_flag v30_tbl;
117:
118: -- variables and structs used for api call
119: l_api_version NUMBER := 1.0;
120: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
121: l_commit VARCHAR2(1) := FND_API.G_FALSE;
122: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
123: l_return_status VARCHAR2(1);
124: l_mesg_count number;
117:
118: -- variables and structs used for api call
119: l_api_version NUMBER := 1.0;
120: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
121: l_commit VARCHAR2(1) := FND_API.G_FALSE;
122: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
123: l_return_status VARCHAR2(1);
124: l_mesg_count number;
125: l_mesg VARCHAR2(4000);
118: -- variables and structs used for api call
119: l_api_version NUMBER := 1.0;
120: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
121: l_commit VARCHAR2(1) := FND_API.G_FALSE;
122: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
123: l_return_status VARCHAR2(1);
124: l_mesg_count number;
125: l_mesg VARCHAR2(4000);
126: l_calling_fn VARCHAR2(30) := 'fa_mass_reval_pkg.do_reval';
489: px_asset_hdr_rec => l_asset_hdr_rec,
490: p_reval_options_rec => l_reval_options_rec
491: );
492:
493: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
494: l_mesg_name := null;
495: raise reval_err;
496: end if;
497:
659:
660: if (l_msg_count > 0) then
661:
662: fa_rx_conc_mesg_pkg.log(
663: fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_FALSE));
664:
665: for i in 1..(l_msg_count-1) loop
666: fa_rx_conc_mesg_pkg.log(
667: fnd_msg_pub.get(fnd_msg_pub.G_NEXT, fnd_api.G_FALSE));
663: fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_FALSE));
664:
665: for i in 1..(l_msg_count-1) loop
666: fa_rx_conc_mesg_pkg.log(
667: fnd_msg_pub.get(fnd_msg_pub.G_NEXT, fnd_api.G_FALSE));
668: end loop;
669:
670: end if;
671: