218: UPDATE itg_org_effectivity
219: SET start_date = p_start_date,
220: end_date = p_end_date,
221: effectivity_enabled = NVL(l_flag, effectivity_enabled),
222: last_updated_by = FND_GLOBAL.user_id,
223: last_update_date = SYSDATE,
224: last_update_login = FND_GLOBAL.login_id
225: WHERE effectivity_id = l_eff_id;
226: EXCEPTION
220: end_date = p_end_date,
221: effectivity_enabled = NVL(l_flag, effectivity_enabled),
222: last_updated_by = FND_GLOBAL.user_id,
223: last_update_date = SYSDATE,
224: last_update_login = FND_GLOBAL.login_id
225: WHERE effectivity_id = l_eff_id;
226: EXCEPTION
227: WHEN NO_DATA_FOUND THEN
228: ITG_MSG.effectivity_update_fail(
252: p_doc_direction,
253: p_start_date,
254: p_end_date,
255: NVL(l_flag, FND_API.G_TRUE),
256: FND_GLOBAL.user_id,
257: SYSDATE,
258: FND_GLOBAL.user_id,
259: SYSDATE,
260: FND_GLOBAL.login_id
254: p_end_date,
255: NVL(l_flag, FND_API.G_TRUE),
256: FND_GLOBAL.user_id,
257: SYSDATE,
258: FND_GLOBAL.user_id,
259: SYSDATE,
260: FND_GLOBAL.login_id
261: );
262: EXCEPTION
256: FND_GLOBAL.user_id,
257: SYSDATE,
258: FND_GLOBAL.user_id,
259: SYSDATE,
260: FND_GLOBAL.login_id
261: );
262: EXCEPTION
263: WHEN NO_DATA_FOUND THEN
264: ITG_MSG.effectivity_insert_fail(