2159: where people_group_id = P_PG_ID
2160: and P_GROUP_NAME is not null; -- 4103321
2161: --
2162: if sql%rowcount = 0 and P_GROUP_NAME is not null then -- Bug 16394886
2163: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL' );
2164: fnd_message.set_token('PROCEDURE','PER_APPLICANT_PKG.UPDATE_GROUP');
2165: fnd_message.set_token('STEP','1' ) ;
2166: fnd_message.raise_error ;
2167: end if ;
2160: and P_GROUP_NAME is not null; -- 4103321
2161: --
2162: if sql%rowcount = 0 and P_GROUP_NAME is not null then -- Bug 16394886
2163: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL' );
2164: fnd_message.set_token('PROCEDURE','PER_APPLICANT_PKG.UPDATE_GROUP');
2165: fnd_message.set_token('STEP','1' ) ;
2166: fnd_message.raise_error ;
2167: end if ;
2168: end if;
2161: --
2162: if sql%rowcount = 0 and P_GROUP_NAME is not null then -- Bug 16394886
2163: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL' );
2164: fnd_message.set_token('PROCEDURE','PER_APPLICANT_PKG.UPDATE_GROUP');
2165: fnd_message.set_token('STEP','1' ) ;
2166: fnd_message.raise_error ;
2167: end if ;
2168: end if;
2169: end update_group ;
2162: if sql%rowcount = 0 and P_GROUP_NAME is not null then -- Bug 16394886
2163: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL' );
2164: fnd_message.set_token('PROCEDURE','PER_APPLICANT_PKG.UPDATE_GROUP');
2165: fnd_message.set_token('STEP','1' ) ;
2166: fnd_message.raise_error ;
2167: end if ;
2168: end if;
2169: end update_group ;
2170: --