DBA Data[Home] [Help]

APPS.FEM_BUSINESS_RULE_PVT dependencies on FND_DATE

Line 20: G_DEFAULT_START_DATE_NULL constant date := FND_DATE.Canonical_To_Date('1900/01/01');

16: G_REVERT_ACTION_TYPE constant number := 3;
17:
18: -- Constants for default effective start and end dates if not specified
19: -- in profile options.
20: G_DEFAULT_START_DATE_NULL constant date := FND_DATE.Canonical_To_Date('1900/01/01');
21: G_DEFAULT_END_DATE_NULL constant date := FND_DATE.Canonical_To_Date('2500/01/01');
22:
23: -- Log Level Constants
24: G_LOG_LEVEL_1 constant number := FND_LOG.Level_Statement;

Line 21: G_DEFAULT_END_DATE_NULL constant date := FND_DATE.Canonical_To_Date('2500/01/01');

17:
18: -- Constants for default effective start and end dates if not specified
19: -- in profile options.
20: G_DEFAULT_START_DATE_NULL constant date := FND_DATE.Canonical_To_Date('1900/01/01');
21: G_DEFAULT_END_DATE_NULL constant date := FND_DATE.Canonical_To_Date('2500/01/01');
22:
23: -- Log Level Constants
24: G_LOG_LEVEL_1 constant number := FND_LOG.Level_Statement;
25: G_LOG_LEVEL_2 constant number := FND_LOG.Level_Procedure;

Line 4450: FND_MESSAGE.set_token('START_DATE',FND_DATE.date_to_chardate(p_effective_start_date));

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:

Line 4451: FND_MESSAGE.set_token('END_DATE',FND_DATE.date_to_chardate(p_effective_end_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:
4455: end if;

Line 4475: FND_MESSAGE.set_token('START_DATE',FND_DATE.date_to_chardate(overlapping_obj_def_rec.effective_start_date));

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;

Line 4476: FND_MESSAGE.set_token('END_DATE',FND_DATE.date_to_chardate(overlapping_obj_def_rec.effective_end_date));

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:

Line 4563: l_date_value := FND_DATE.Canonical_To_Date(l_date_string);

4559: if (l_date_string is not null) then
4560:
4561: -- Bug 5508120 -- NMARTINE -- 01-SEP-2006
4562: -- Effective End Date profile option is now stored in Canonical format
4563: l_date_value := FND_DATE.Canonical_To_Date(l_date_string);
4564:
4565: -- Remove the time component.
4566: l_date_value := trunc(l_date_value);
4567: