154: end if;
155:
156: EXCEPTION when others then
157: x_retVal := fnd_api.G_RET_STS_ERROR;
158: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
159: fnd_message.set_token('ERROR_TEXT', 'wip_rebuild.update_genealogy');
160: x_errMsg := fnd_message.get;
161: end update_genealogy;
162:
155:
156: EXCEPTION when others then
157: x_retVal := fnd_api.G_RET_STS_ERROR;
158: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
159: fnd_message.set_token('ERROR_TEXT', 'wip_rebuild.update_genealogy');
160: x_errMsg := fnd_message.get;
161: end update_genealogy;
162:
163: procedure create_rebuild_job(p_tempId IN NUMBER,
156: EXCEPTION when others then
157: x_retVal := fnd_api.G_RET_STS_ERROR;
158: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
159: fnd_message.set_token('ERROR_TEXT', 'wip_rebuild.update_genealogy');
160: x_errMsg := fnd_message.get;
161: end update_genealogy;
162:
163: procedure create_rebuild_job(p_tempId IN NUMBER,
164: x_retVal OUT NOCOPY VARCHAR2,