1153:
1154: -- Check that the approval status is NOT_APPROVED
1155: l_approval_status_code := GetApprovalStatus(p_obj_def_id);
1156: if (l_approval_status_code <> G_NOT_APPROVED_STATUS) then
1157: FND_MESSAGE.set_name('FEM', 'FEM_BR_RVRT_NOT_APPROVED_ERR');
1158: FND_MSG_PUB.Add;
1159: raise FND_API.G_EXC_ERROR;
1160: end if;
1161:
1161:
1162: -- Check that object definitions has an old approved copy
1163: l_old_approved_obj_def_id := GetOldApprovedObjDefId(p_obj_def_id);
1164: if (l_old_approved_obj_def_id is null) then
1165: FND_MESSAGE.set_name('FEM', 'FEM_BR_RVRT_OLD_APPR_CPY_ERR');
1166: FND_MSG_PUB.Add;
1167: raise FND_API.G_EXC_ERROR;
1168: end if;
1169:
1173: ,x_data_edit_lock_exists => l_data_edit_lock_exists
1174: );
1175:
1176: if (FND_API.To_Boolean(l_data_edit_lock_exists)) then
1177: FND_MESSAGE.set_name('FEM', 'FEM_BR_RVRT_DATA_EDIT_LOCK_ERR');
1178: FND_MSG_PUB.Add;
1179: raise FND_API.G_EXC_ERROR;
1180: end if;
1181:
2226: for l_check_obj_name_rec in l_check_obj_name_cur loop
2227:
2228: -- If a record is returned in the l_check_obj_name_cur, then another
2229: -- object exists with the same name.
2230: FND_MESSAGE.set_name('FEM', 'FEM_BR_OBJ_NAME_ERR');
2231: FND_MESSAGE.set_token('OBJECT_TYPE_MEANING', l_check_obj_name_rec.object_type_name);
2232: FND_MESSAGE.set_token('FOLDER_NAME', l_check_obj_name_rec.folder_name);
2233: FND_MESSAGE.set_token('OBJECT_NAME', l_check_obj_name_rec.object_name);
2234: FND_MSG_PUB.Add;
2227:
2228: -- If a record is returned in the l_check_obj_name_cur, then another
2229: -- object exists with the same name.
2230: FND_MESSAGE.set_name('FEM', 'FEM_BR_OBJ_NAME_ERR');
2231: FND_MESSAGE.set_token('OBJECT_TYPE_MEANING', l_check_obj_name_rec.object_type_name);
2232: FND_MESSAGE.set_token('FOLDER_NAME', l_check_obj_name_rec.folder_name);
2233: FND_MESSAGE.set_token('OBJECT_NAME', l_check_obj_name_rec.object_name);
2234: FND_MSG_PUB.Add;
2235:
2228: -- If a record is returned in the l_check_obj_name_cur, then another
2229: -- object exists with the same name.
2230: FND_MESSAGE.set_name('FEM', 'FEM_BR_OBJ_NAME_ERR');
2231: FND_MESSAGE.set_token('OBJECT_TYPE_MEANING', l_check_obj_name_rec.object_type_name);
2232: FND_MESSAGE.set_token('FOLDER_NAME', l_check_obj_name_rec.folder_name);
2233: FND_MESSAGE.set_token('OBJECT_NAME', l_check_obj_name_rec.object_name);
2234: FND_MSG_PUB.Add;
2235:
2236: raise FND_API.G_EXC_ERROR;
2229: -- object exists with the same name.
2230: FND_MESSAGE.set_name('FEM', 'FEM_BR_OBJ_NAME_ERR');
2231: FND_MESSAGE.set_token('OBJECT_TYPE_MEANING', l_check_obj_name_rec.object_type_name);
2232: FND_MESSAGE.set_token('FOLDER_NAME', l_check_obj_name_rec.folder_name);
2233: FND_MESSAGE.set_token('OBJECT_NAME', l_check_obj_name_rec.object_name);
2234: FND_MSG_PUB.Add;
2235:
2236: raise FND_API.G_EXC_ERROR;
2237:
2364: for l_check_obj_def_name_rec in l_check_obj_def_name_cur loop
2365:
2366: -- If a record is returned in the l_check_obj_def_name_cur, then another
2367: -- object definition exists with the same name.
2368: FND_MESSAGE.set_name('FEM', 'FEM_BR_OBJ_DEF_NAME_ERR');
2369: FND_MESSAGE.set_token('OBJECT_DEFINITION_NAME', l_check_obj_def_name_rec.obj_def_name);
2370: FND_MSG_PUB.Add;
2371:
2372: raise FND_API.G_EXC_ERROR;
2365:
2366: -- If a record is returned in the l_check_obj_def_name_cur, then another
2367: -- object definition exists with the same name.
2368: FND_MESSAGE.set_name('FEM', 'FEM_BR_OBJ_DEF_NAME_ERR');
2369: FND_MESSAGE.set_token('OBJECT_DEFINITION_NAME', l_check_obj_def_name_rec.obj_def_name);
2370: FND_MSG_PUB.Add;
2371:
2372: raise FND_API.G_EXC_ERROR;
2373:
4417: -- Checks if the specified effective dates will overlap with existing
4418: -- object definitions under the same parent object. If this check is for
4419: -- updating the effective dates of an existing object definition, this
4420: -- object definition must be excluded from the overlap check.
4421: -- If an overlap exists the appropriate FND message is set and an exception
4422: -- is raised.
4423: --
4424: -- IN
4425: -- p_obj_id - Object ID
4445:
4446: -- First check that the end date is not smaller than the start date.
4447: if (p_effective_end_date < p_effective_start_date) then
4448:
4449: FND_MESSAGE.set_name('FEM', 'FEM_BR_END_LT_START_DATE_ERR');
4450: FND_MESSAGE.set_token('START_DATE',FND_DATE.date_to_chardate(p_effective_start_date));
4451: FND_MESSAGE.set_token('END_DATE',FND_DATE.date_to_chardate(p_effective_end_date));
4452: FND_MSG_PUB.Add;
4453: raise FND_API.G_EXC_ERROR;
4446: -- First check that the end date is not smaller than the start date.
4447: if (p_effective_end_date < p_effective_start_date) then
4448:
4449: FND_MESSAGE.set_name('FEM', 'FEM_BR_END_LT_START_DATE_ERR');
4450: FND_MESSAGE.set_token('START_DATE',FND_DATE.date_to_chardate(p_effective_start_date));
4451: FND_MESSAGE.set_token('END_DATE',FND_DATE.date_to_chardate(p_effective_end_date));
4452: FND_MSG_PUB.Add;
4453: raise FND_API.G_EXC_ERROR;
4454:
4447: if (p_effective_end_date < p_effective_start_date) then
4448:
4449: FND_MESSAGE.set_name('FEM', 'FEM_BR_END_LT_START_DATE_ERR');
4450: FND_MESSAGE.set_token('START_DATE',FND_DATE.date_to_chardate(p_effective_start_date));
4451: FND_MESSAGE.set_token('END_DATE',FND_DATE.date_to_chardate(p_effective_end_date));
4452: FND_MSG_PUB.Add;
4453: raise FND_API.G_EXC_ERROR;
4454:
4455: end if;
4465:
4466: -- If any records are returned in the overlapping_obj_defs_cur, then
4467: -- an overlap exists with at least one object definition.
4468: if (p_action_type = G_REVERT_ACTION_TYPE) then
4469: FND_MESSAGE.set_name('FEM', 'FEM_BR_RVRT_OVRLP_OBJ_DEF_ERR');
4470: else
4471: FND_MESSAGE.set_name('FEM', 'FEM_BR_OVRLP_OBJ_DEF_ERR');
4472: end if;
4473:
4467: -- an overlap exists with at least one object definition.
4468: if (p_action_type = G_REVERT_ACTION_TYPE) then
4469: FND_MESSAGE.set_name('FEM', 'FEM_BR_RVRT_OVRLP_OBJ_DEF_ERR');
4470: else
4471: FND_MESSAGE.set_name('FEM', 'FEM_BR_OVRLP_OBJ_DEF_ERR');
4472: end if;
4473:
4474: FND_MESSAGE.set_token('VERSION_NAME', overlapping_obj_def_rec.object_definition_name);
4475: FND_MESSAGE.set_token('START_DATE',FND_DATE.date_to_chardate(overlapping_obj_def_rec.effective_start_date));
4470: else
4471: FND_MESSAGE.set_name('FEM', 'FEM_BR_OVRLP_OBJ_DEF_ERR');
4472: end if;
4473:
4474: FND_MESSAGE.set_token('VERSION_NAME', overlapping_obj_def_rec.object_definition_name);
4475: FND_MESSAGE.set_token('START_DATE',FND_DATE.date_to_chardate(overlapping_obj_def_rec.effective_start_date));
4476: FND_MESSAGE.set_token('END_DATE',FND_DATE.date_to_chardate(overlapping_obj_def_rec.effective_end_date));
4477: FND_MSG_PUB.Add;
4478:
4471: FND_MESSAGE.set_name('FEM', 'FEM_BR_OVRLP_OBJ_DEF_ERR');
4472: end if;
4473:
4474: FND_MESSAGE.set_token('VERSION_NAME', overlapping_obj_def_rec.object_definition_name);
4475: FND_MESSAGE.set_token('START_DATE',FND_DATE.date_to_chardate(overlapping_obj_def_rec.effective_start_date));
4476: FND_MESSAGE.set_token('END_DATE',FND_DATE.date_to_chardate(overlapping_obj_def_rec.effective_end_date));
4477: FND_MSG_PUB.Add;
4478:
4479: raise FND_API.G_EXC_ERROR;
4472: end if;
4473:
4474: FND_MESSAGE.set_token('VERSION_NAME', overlapping_obj_def_rec.object_definition_name);
4475: FND_MESSAGE.set_token('START_DATE',FND_DATE.date_to_chardate(overlapping_obj_def_rec.effective_start_date));
4476: FND_MESSAGE.set_token('END_DATE',FND_DATE.date_to_chardate(overlapping_obj_def_rec.effective_end_date));
4477: FND_MSG_PUB.Add;
4478:
4479: raise FND_API.G_EXC_ERROR;
4480: