53: --
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: --
56: if p_constraint_name = 'flag_must_be_populated' then
57: fnd_message.set_name('OTA','OTA_13567_TPL_DEFAULT_FLAG');
58: elsif p_constraint_name = 'tpl_name_and_date_is_mandatory' then
59: fnd_message.set_name('OTA','OTA_13566_TPL_COPY_PRICE_LIST');
60: elsif p_constraint_name = 'tpl_name_is_mandatory' then
61: fnd_message.set_name('OTA','OTA_13568_TPL_PRICE_LIST_NAME');
55: --
56: if p_constraint_name = 'flag_must_be_populated' then
57: fnd_message.set_name('OTA','OTA_13567_TPL_DEFAULT_FLAG');
58: elsif p_constraint_name = 'tpl_name_and_date_is_mandatory' then
59: fnd_message.set_name('OTA','OTA_13566_TPL_COPY_PRICE_LIST');
60: elsif p_constraint_name = 'tpl_name_is_mandatory' then
61: fnd_message.set_name('OTA','OTA_13568_TPL_PRICE_LIST_NAME');
62: elsif p_constraint_name = 'single_unit_price_should_be_populated' then
63: fnd_message.set_name('OTA','OTA_13569_TPL_SINGLE_UNIT');
57: fnd_message.set_name('OTA','OTA_13567_TPL_DEFAULT_FLAG');
58: elsif p_constraint_name = 'tpl_name_and_date_is_mandatory' then
59: fnd_message.set_name('OTA','OTA_13566_TPL_COPY_PRICE_LIST');
60: elsif p_constraint_name = 'tpl_name_is_mandatory' then
61: fnd_message.set_name('OTA','OTA_13568_TPL_PRICE_LIST_NAME');
62: elsif p_constraint_name = 'single_unit_price_should_be_populated' then
63: fnd_message.set_name('OTA','OTA_13569_TPL_SINGLE_UNIT');
64: elsif p_constraint_name = 'training_unit_type_should_be_populated' then
65: fnd_message.set_name('OTA','OTA_13569_TPL_SINGLE_UNIT');
59: fnd_message.set_name('OTA','OTA_13566_TPL_COPY_PRICE_LIST');
60: elsif p_constraint_name = 'tpl_name_is_mandatory' then
61: fnd_message.set_name('OTA','OTA_13568_TPL_PRICE_LIST_NAME');
62: elsif p_constraint_name = 'single_unit_price_should_be_populated' then
63: fnd_message.set_name('OTA','OTA_13569_TPL_SINGLE_UNIT');
64: elsif p_constraint_name = 'training_unit_type_should_be_populated' then
65: fnd_message.set_name('OTA','OTA_13569_TPL_SINGLE_UNIT');
66: --
67: elsif p_constraint_name = 'price_list_doesnt_exist' then
61: fnd_message.set_name('OTA','OTA_13568_TPL_PRICE_LIST_NAME');
62: elsif p_constraint_name = 'single_unit_price_should_be_populated' then
63: fnd_message.set_name('OTA','OTA_13569_TPL_SINGLE_UNIT');
64: elsif p_constraint_name = 'training_unit_type_should_be_populated' then
65: fnd_message.set_name('OTA','OTA_13569_TPL_SINGLE_UNIT');
66: --
67: elsif p_constraint_name = 'price_list_doesnt_exist' then
68: fnd_message.set_name('OTA','OTA_13570_TPL_PRICE_LIST_NAME');
69: elsif p_constraint_name = 'price_list_type_must_be_populated' then
64: elsif p_constraint_name = 'training_unit_type_should_be_populated' then
65: fnd_message.set_name('OTA','OTA_13569_TPL_SINGLE_UNIT');
66: --
67: elsif p_constraint_name = 'price_list_doesnt_exist' then
68: fnd_message.set_name('OTA','OTA_13570_TPL_PRICE_LIST_NAME');
69: elsif p_constraint_name = 'price_list_type_must_be_populated' then
70: fnd_message.set_name('OTA','OTA_13571_TPL_LIST_TYPE');
71: elsif p_constraint_name = 'single_unit_price_should_be_null' then
72: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');
66: --
67: elsif p_constraint_name = 'price_list_doesnt_exist' then
68: fnd_message.set_name('OTA','OTA_13570_TPL_PRICE_LIST_NAME');
69: elsif p_constraint_name = 'price_list_type_must_be_populated' then
70: fnd_message.set_name('OTA','OTA_13571_TPL_LIST_TYPE');
71: elsif p_constraint_name = 'single_unit_price_should_be_null' then
72: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');
73: elsif p_constraint_name = 'training_unit_type_should_be_null' then
74: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');
68: fnd_message.set_name('OTA','OTA_13570_TPL_PRICE_LIST_NAME');
69: elsif p_constraint_name = 'price_list_type_must_be_populated' then
70: fnd_message.set_name('OTA','OTA_13571_TPL_LIST_TYPE');
71: elsif p_constraint_name = 'single_unit_price_should_be_null' then
72: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');
73: elsif p_constraint_name = 'training_unit_type_should_be_null' then
74: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');
75: elsif p_constraint_name = 'undeletable_child_tbd_exists' then
76: fnd_message.set_name('OTA','OTA_13228_TPL_TBD_EXISTS');
70: fnd_message.set_name('OTA','OTA_13571_TPL_LIST_TYPE');
71: elsif p_constraint_name = 'single_unit_price_should_be_null' then
72: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');
73: elsif p_constraint_name = 'training_unit_type_should_be_null' then
74: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');
75: elsif p_constraint_name = 'undeletable_child_tbd_exists' then
76: fnd_message.set_name('OTA','OTA_13228_TPL_TBD_EXISTS');
77: --
78: elsif p_constraint_name = 'tpl_name_already_exists' then
72: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');
73: elsif p_constraint_name = 'training_unit_type_should_be_null' then
74: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');
75: elsif p_constraint_name = 'undeletable_child_tbd_exists' then
76: fnd_message.set_name('OTA','OTA_13228_TPL_TBD_EXISTS');
77: --
78: elsif p_constraint_name = 'tpl_name_already_exists' then
79: fnd_message.set_name('OTA','OTA_13258_TPL_WRONG_NAME');
80: elsif (p_constraint_name = 'default_price_list_already_exists') Then
75: elsif p_constraint_name = 'undeletable_child_tbd_exists' then
76: fnd_message.set_name('OTA','OTA_13228_TPL_TBD_EXISTS');
77: --
78: elsif p_constraint_name = 'tpl_name_already_exists' then
79: fnd_message.set_name('OTA','OTA_13258_TPL_WRONG_NAME');
80: elsif (p_constraint_name = 'default_price_list_already_exists') Then
81: fnd_message.set_name('OTA','OTA_13221_TPL_WRONG_FLAG');
82: elsif (p_constraint_name = 'tpl_dates_ple') Then
83: fnd_message.set_name('OTA','OTA_13233_TPL_DATES_PLE');
77: --
78: elsif p_constraint_name = 'tpl_name_already_exists' then
79: fnd_message.set_name('OTA','OTA_13258_TPL_WRONG_NAME');
80: elsif (p_constraint_name = 'default_price_list_already_exists') Then
81: fnd_message.set_name('OTA','OTA_13221_TPL_WRONG_FLAG');
82: elsif (p_constraint_name = 'tpl_dates_ple') Then
83: fnd_message.set_name('OTA','OTA_13233_TPL_DATES_PLE');
84: elsif (p_constraint_name = 'tpl_dates_tbd') Then
85: fnd_message.set_name('OTA','OTA_13234_TPL_DATES_TBD');
79: fnd_message.set_name('OTA','OTA_13258_TPL_WRONG_NAME');
80: elsif (p_constraint_name = 'default_price_list_already_exists') Then
81: fnd_message.set_name('OTA','OTA_13221_TPL_WRONG_FLAG');
82: elsif (p_constraint_name = 'tpl_dates_ple') Then
83: fnd_message.set_name('OTA','OTA_13233_TPL_DATES_PLE');
84: elsif (p_constraint_name = 'tpl_dates_tbd') Then
85: fnd_message.set_name('OTA','OTA_13234_TPL_DATES_TBD');
86: elsif p_constraint_name = 'startdate_must_be_populated' then
87: fnd_message.set_name('OTA','OTA_13230_GEN_MAND_START_DATE');
81: fnd_message.set_name('OTA','OTA_13221_TPL_WRONG_FLAG');
82: elsif (p_constraint_name = 'tpl_dates_ple') Then
83: fnd_message.set_name('OTA','OTA_13233_TPL_DATES_PLE');
84: elsif (p_constraint_name = 'tpl_dates_tbd') Then
85: fnd_message.set_name('OTA','OTA_13234_TPL_DATES_TBD');
86: elsif p_constraint_name = 'startdate_must_be_populated' then
87: fnd_message.set_name('OTA','OTA_13230_GEN_MAND_START_DATE');
88: elsif p_constraint_name = 'enddate_must_be_greater_than_startdate' then
89: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
83: fnd_message.set_name('OTA','OTA_13233_TPL_DATES_PLE');
84: elsif (p_constraint_name = 'tpl_dates_tbd') Then
85: fnd_message.set_name('OTA','OTA_13234_TPL_DATES_TBD');
86: elsif p_constraint_name = 'startdate_must_be_populated' then
87: fnd_message.set_name('OTA','OTA_13230_GEN_MAND_START_DATE');
88: elsif p_constraint_name = 'enddate_must_be_greater_than_startdate' then
89: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
90: elsif p_constraint_name = 'tpl_entries_exist' then
91: fnd_message.set_name('OTA','OTA_13639_TPL_ENTRIES_EXIST');
85: fnd_message.set_name('OTA','OTA_13234_TPL_DATES_TBD');
86: elsif p_constraint_name = 'startdate_must_be_populated' then
87: fnd_message.set_name('OTA','OTA_13230_GEN_MAND_START_DATE');
88: elsif p_constraint_name = 'enddate_must_be_greater_than_startdate' then
89: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
90: elsif p_constraint_name = 'tpl_entries_exist' then
91: fnd_message.set_name('OTA','OTA_13639_TPL_ENTRIES_EXIST');
92: --
93: else
87: fnd_message.set_name('OTA','OTA_13230_GEN_MAND_START_DATE');
88: elsif p_constraint_name = 'enddate_must_be_greater_than_startdate' then
89: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
90: elsif p_constraint_name = 'tpl_entries_exist' then
91: fnd_message.set_name('OTA','OTA_13639_TPL_ENTRIES_EXIST');
92: --
93: else
94: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');
95: fnd_message.set_token('CONSTRAINT',p_constraint_name);
90: elsif p_constraint_name = 'tpl_entries_exist' then
91: fnd_message.set_name('OTA','OTA_13639_TPL_ENTRIES_EXIST');
92: --
93: else
94: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');
95: fnd_message.set_token('CONSTRAINT',p_constraint_name);
96: End If;
97: --
98: fnd_message.raise_error;
91: fnd_message.set_name('OTA','OTA_13639_TPL_ENTRIES_EXIST');
92: --
93: else
94: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');
95: fnd_message.set_token('CONSTRAINT',p_constraint_name);
96: End If;
97: --
98: fnd_message.raise_error;
99: --
94: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');
95: fnd_message.set_token('CONSTRAINT',p_constraint_name);
96: End If;
97: --
98: fnd_message.raise_error;
99: --
100: hr_utility.set_location(' Leaving:'||l_proc, 10);
101:
102: End constraint_error2;