326: VALUES (eam_failuresets_s.nextval ,
327: p_failureset_rec.set_name ,
328: p_failureset_rec.description ,
329: p_failureset_rec.effective_end_date,
330: fnd_global.user_id,
331: SYSDATE,
332: SYSDATE,
333: fnd_global.user_id,
334: NULL)
329: p_failureset_rec.effective_end_date,
330: fnd_global.user_id,
331: SYSDATE,
332: SYSDATE,
333: fnd_global.user_id,
334: NULL)
335: RETURNING set_id INTO l_failureset_id ;
336:
337: ELSIF (p_mode = 'U') THEN
347: NULL, effective_end_date,
348: FND_API.G_MISS_DATE, NULL,
349: p_failureset_rec.effective_end_date),
350: last_update_date = SYSDATE,
351: last_updated_by = fnd_global.user_id,
352: last_update_login = NULL
353: WHERE set_id = l_failureset_id;
354: CLOSE lock_set;
355: EXCEPTION
456: -- Validate Failure Set Association Info passed
457: Validate_SetAssociation(p_mode, p_validation_level, p_association_rec, l_set_id);
458:
459: IF (p_association_rec.last_update_date is null) THEN
460: l_created_by := fnd_global.user_id;
461: l_creation_date := SYSDATE;
462: l_last_update_date := SYSDATE;
463: l_last_updated_by := fnd_global.user_id;
464: l_last_update_login := NULL;
459: IF (p_association_rec.last_update_date is null) THEN
460: l_created_by := fnd_global.user_id;
461: l_creation_date := SYSDATE;
462: l_last_update_date := SYSDATE;
463: l_last_updated_by := fnd_global.user_id;
464: l_last_update_login := NULL;
465: ELSE
466: l_created_by := p_association_rec.created_by;
467: l_creation_date := p_association_rec.creation_date;