139:
140: /* validating the local flag */
141: if nvl(p_local_flag, 'N') = 'Y' then
142: if p_organization_id is null then
143: FND_MESSAGE.SET_NAME('EAM','EAM_PM_ORGID_REQUIRED');
144: FND_MSG_PUB.Add;
145: RAISE FND_API.G_EXC_ERROR;
146: end if;
147: end if;
170: p_ATTRIBUTE15 => p_attribute15 ,
171: x_error_segments => x_error_segments ,
172: x_error_message => x_error_message);
173: IF (not l_validated) THEN
174: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
175: FND_MESSAGE.SET_TOKEN('ERROR_MSG', x_error_message);
176: FND_MSG_PUB.Add;
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
171: x_error_segments => x_error_segments ,
172: x_error_message => x_error_message);
173: IF (not l_validated) THEN
174: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
175: FND_MESSAGE.SET_TOKEN('ERROR_MSG', x_error_message);
176: FND_MSG_PUB.Add;
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
445: x_error_message => x_error_message);
446:
447: IF (not l_validated) THEN
448: --raise_error(x_error_message);
449: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
450: FND_MESSAGE.SET_TOKEN('ERROR_MSG', x_error_message);
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453:
446:
447: IF (not l_validated) THEN
448: --raise_error(x_error_message);
449: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
450: FND_MESSAGE.SET_TOKEN('ERROR_MSG', x_error_message);
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453:
454: END IF;
473: OR (p_end_date <> l_end_date)
474: )
475: )
476: THEN
477: FND_MESSAGE.SET_NAME('EAM','EAM_SETNAME_SEED_DATE_NOUPD');
478: FND_MSG_PUB.Add;
479: RAISE FND_API.G_EXC_ERROR;
480: END IF;
481:
484: --validation for local flag
485: if nvl(p_local_flag, 'N') = 'Y' then
486:
487: if l_set_name_id = 1 then
488: FND_MESSAGE.SET_NAME('EAM','EAM_MAIN_GLOBAL');
489: FND_MSG_PUB.Add;
490: RAISE FND_API.G_EXC_ERROR;
491: end if;
492:
490: RAISE FND_API.G_EXC_ERROR;
491: end if;
492:
493: if p_organization_id is null then
494: FND_MESSAGE.SET_NAME('EAM','EAM_PM_ORGID_REQUIRED');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_ERROR;
497: end if;
498:
514: l_exists := 'N';
515: end;
516:
517: if l_exists = 'Y' then
518: FND_MESSAGE.SET_NAME('EAM','EAM_PM_SCHEDULE_EXISTS');
519: FND_MESSAGE.SET_TOKEN('ENTITY1', p_set_name);
520: FND_MSG_PUB.Add;
521: RAISE FND_API.G_EXC_ERROR;
522: end if;
515: end;
516:
517: if l_exists = 'Y' then
518: FND_MESSAGE.SET_NAME('EAM','EAM_PM_SCHEDULE_EXISTS');
519: FND_MESSAGE.SET_TOKEN('ENTITY1', p_set_name);
520: FND_MSG_PUB.Add;
521: RAISE FND_API.G_EXC_ERROR;
522: end if;
523: end if;
693:
694: PROCEDURE RAISE_ERROR (ERROR VARCHAR2)
695: IS
696: BEGIN
697: FND_MESSAGE.SET_NAME ('EAM', ERROR);
698: FND_MSG_PUB.ADD;
699: RAISE FND_API.G_EXC_ERROR;
700: END;
701: