48: --
49: hr_utility.set_location('Entering:'||l_proc, 5);
50: --
51: if p_constraint_name = 'startdate_must_be_populated' then
52: fnd_message.set_name('OTA','OTA_13457_GEN_MAND_START_DATE');
53: elsif p_constraint_name = 'enddate_must_be_greater_than_startdate' then
54: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
55: elsif p_constraint_name = 'minimum_attendees_should_be_positive' then
56: fnd_message.set_name('OTA','OTA_13296_GEN_MINMAX_POS');
50: --
51: if p_constraint_name = 'startdate_must_be_populated' then
52: fnd_message.set_name('OTA','OTA_13457_GEN_MAND_START_DATE');
53: elsif p_constraint_name = 'enddate_must_be_greater_than_startdate' then
54: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
55: elsif p_constraint_name = 'minimum_attendees_should_be_positive' then
56: fnd_message.set_name('OTA','OTA_13296_GEN_MINMAX_POS');
57: elsif p_constraint_name = 'maximum_should_be_greater_than_minimum' then
58: fnd_message.set_name('OTA','OTA_13298_GEN_MINMAX_ORDER');
52: fnd_message.set_name('OTA','OTA_13457_GEN_MAND_START_DATE');
53: elsif p_constraint_name = 'enddate_must_be_greater_than_startdate' then
54: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
55: elsif p_constraint_name = 'minimum_attendees_should_be_positive' then
56: fnd_message.set_name('OTA','OTA_13296_GEN_MINMAX_POS');
57: elsif p_constraint_name = 'maximum_should_be_greater_than_minimum' then
58: fnd_message.set_name('OTA','OTA_13298_GEN_MINMAX_ORDER');
59: elsif p_constraint_name = 'price_list_must_be_polulated' then
60: fnd_message.set_name('OTA','OTA_13573_PLE_PRICE_LIST_MAND');
54: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');
55: elsif p_constraint_name = 'minimum_attendees_should_be_positive' then
56: fnd_message.set_name('OTA','OTA_13296_GEN_MINMAX_POS');
57: elsif p_constraint_name = 'maximum_should_be_greater_than_minimum' then
58: fnd_message.set_name('OTA','OTA_13298_GEN_MINMAX_ORDER');
59: elsif p_constraint_name = 'price_list_must_be_polulated' then
60: fnd_message.set_name('OTA','OTA_13573_PLE_PRICE_LIST_MAND');
61: elsif p_constraint_name = 'activityversion_or_vendorsupply_should_be_null' then
62: fnd_message.set_name('OTA','OTA_13201_PLE_TAV_VSP_EXCL');
56: fnd_message.set_name('OTA','OTA_13296_GEN_MINMAX_POS');
57: elsif p_constraint_name = 'maximum_should_be_greater_than_minimum' then
58: fnd_message.set_name('OTA','OTA_13298_GEN_MINMAX_ORDER');
59: elsif p_constraint_name = 'price_list_must_be_polulated' then
60: fnd_message.set_name('OTA','OTA_13573_PLE_PRICE_LIST_MAND');
61: elsif p_constraint_name = 'activityversion_or_vendorsupply_should_be_null' then
62: fnd_message.set_name('OTA','OTA_13201_PLE_TAV_VSP_EXCL');
63: elsif p_constraint_name = 'price_list_doesnt_exist' Then
64: fnd_message.set_name('OTA','OTA_13574_PLE_NO_PRICE_LIST');
58: fnd_message.set_name('OTA','OTA_13298_GEN_MINMAX_ORDER');
59: elsif p_constraint_name = 'price_list_must_be_polulated' then
60: fnd_message.set_name('OTA','OTA_13573_PLE_PRICE_LIST_MAND');
61: elsif p_constraint_name = 'activityversion_or_vendorsupply_should_be_null' then
62: fnd_message.set_name('OTA','OTA_13201_PLE_TAV_VSP_EXCL');
63: elsif p_constraint_name = 'price_list_doesnt_exist' Then
64: fnd_message.set_name('OTA','OTA_13574_PLE_NO_PRICE_LIST');
65: elsif p_constraint_name = 'activity_version_doesnt_exist' Then
66: fnd_message.set_name('OTA','OTA_13575_PLE_NO_ACTIVITY');
60: fnd_message.set_name('OTA','OTA_13573_PLE_PRICE_LIST_MAND');
61: elsif p_constraint_name = 'activityversion_or_vendorsupply_should_be_null' then
62: fnd_message.set_name('OTA','OTA_13201_PLE_TAV_VSP_EXCL');
63: elsif p_constraint_name = 'price_list_doesnt_exist' Then
64: fnd_message.set_name('OTA','OTA_13574_PLE_NO_PRICE_LIST');
65: elsif p_constraint_name = 'activity_version_doesnt_exist' Then
66: fnd_message.set_name('OTA','OTA_13575_PLE_NO_ACTIVITY');
67: elsif p_constraint_name = 'minimum_attendees_should_be_null' then
68: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
62: fnd_message.set_name('OTA','OTA_13201_PLE_TAV_VSP_EXCL');
63: elsif p_constraint_name = 'price_list_doesnt_exist' Then
64: fnd_message.set_name('OTA','OTA_13574_PLE_NO_PRICE_LIST');
65: elsif p_constraint_name = 'activity_version_doesnt_exist' Then
66: fnd_message.set_name('OTA','OTA_13575_PLE_NO_ACTIVITY');
67: elsif p_constraint_name = 'minimum_attendees_should_be_null' then
68: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
69: elsif p_constraint_name = 'maximum_attendees_should_be_null' then
70: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
64: fnd_message.set_name('OTA','OTA_13574_PLE_NO_PRICE_LIST');
65: elsif p_constraint_name = 'activity_version_doesnt_exist' Then
66: fnd_message.set_name('OTA','OTA_13575_PLE_NO_ACTIVITY');
67: elsif p_constraint_name = 'minimum_attendees_should_be_null' then
68: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
69: elsif p_constraint_name = 'maximum_attendees_should_be_null' then
70: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
71: elsif p_constraint_name = 'minimum_attendees_should_be_populated' then
72: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
66: fnd_message.set_name('OTA','OTA_13575_PLE_NO_ACTIVITY');
67: elsif p_constraint_name = 'minimum_attendees_should_be_null' then
68: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
69: elsif p_constraint_name = 'maximum_attendees_should_be_null' then
70: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
71: elsif p_constraint_name = 'minimum_attendees_should_be_populated' then
72: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
73: elsif p_constraint_name = 'maximum_attendees_should_be_populated' then
74: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
68: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
69: elsif p_constraint_name = 'maximum_attendees_should_be_null' then
70: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
71: elsif p_constraint_name = 'minimum_attendees_should_be_populated' then
72: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
73: elsif p_constraint_name = 'maximum_attendees_should_be_populated' then
74: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
75: elsif p_constraint_name = 'wrong_copy_entries_dates' then
76: fnd_message.set_name('OTA','OTA_13577_PLE_COPY_ENTRY_DATES');
70: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
71: elsif p_constraint_name = 'minimum_attendees_should_be_populated' then
72: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
73: elsif p_constraint_name = 'maximum_attendees_should_be_populated' then
74: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
75: elsif p_constraint_name = 'wrong_copy_entries_dates' then
76: fnd_message.set_name('OTA','OTA_13577_PLE_COPY_ENTRY_DATES');
77: elsif p_constraint_name = 'activity_and_vendor_cant_be_both_null' then
78: fnd_message.set_name('OTA','OTA_13238_PLE_TAV_OR_VSP_NOTNU');
72: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
73: elsif p_constraint_name = 'maximum_attendees_should_be_populated' then
74: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
75: elsif p_constraint_name = 'wrong_copy_entries_dates' then
76: fnd_message.set_name('OTA','OTA_13577_PLE_COPY_ENTRY_DATES');
77: elsif p_constraint_name = 'activity_and_vendor_cant_be_both_null' then
78: fnd_message.set_name('OTA','OTA_13238_PLE_TAV_OR_VSP_NOTNU');
79: elsif p_constraint_name = 'price_basis_must_be_C_or_S' then
80: fnd_message.set_name('OTA','OTA_13240_PLE_PRICE_BAS_DOMAIN');
74: fnd_message.set_name('OTA','OTA_13576_PLE_MIN_MAX_ATTS');
75: elsif p_constraint_name = 'wrong_copy_entries_dates' then
76: fnd_message.set_name('OTA','OTA_13577_PLE_COPY_ENTRY_DATES');
77: elsif p_constraint_name = 'activity_and_vendor_cant_be_both_null' then
78: fnd_message.set_name('OTA','OTA_13238_PLE_TAV_OR_VSP_NOTNU');
79: elsif p_constraint_name = 'price_basis_must_be_C_or_S' then
80: fnd_message.set_name('OTA','OTA_13240_PLE_PRICE_BAS_DOMAIN');
81: elsif p_constraint_name = 'cple_overlapping' Then
82: fnd_message.set_name('OTA','OTA_13208_PLE_C_OVERLAP');
76: fnd_message.set_name('OTA','OTA_13577_PLE_COPY_ENTRY_DATES');
77: elsif p_constraint_name = 'activity_and_vendor_cant_be_both_null' then
78: fnd_message.set_name('OTA','OTA_13238_PLE_TAV_OR_VSP_NOTNU');
79: elsif p_constraint_name = 'price_basis_must_be_C_or_S' then
80: fnd_message.set_name('OTA','OTA_13240_PLE_PRICE_BAS_DOMAIN');
81: elsif p_constraint_name = 'cple_overlapping' Then
82: fnd_message.set_name('OTA','OTA_13208_PLE_C_OVERLAP');
83: elsif p_constraint_name = 'dple_overlapping' Then
84: fnd_message.set_name('OTA','OTA_13210_PLE_D_OVERLAP');
78: fnd_message.set_name('OTA','OTA_13238_PLE_TAV_OR_VSP_NOTNU');
79: elsif p_constraint_name = 'price_basis_must_be_C_or_S' then
80: fnd_message.set_name('OTA','OTA_13240_PLE_PRICE_BAS_DOMAIN');
81: elsif p_constraint_name = 'cple_overlapping' Then
82: fnd_message.set_name('OTA','OTA_13208_PLE_C_OVERLAP');
83: elsif p_constraint_name = 'dple_overlapping' Then
84: fnd_message.set_name('OTA','OTA_13210_PLE_D_OVERLAP');
85: elsif p_constraint_name = 'startdate_must_succeed_tpl_startdate' Then
86: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
80: fnd_message.set_name('OTA','OTA_13240_PLE_PRICE_BAS_DOMAIN');
81: elsif p_constraint_name = 'cple_overlapping' Then
82: fnd_message.set_name('OTA','OTA_13208_PLE_C_OVERLAP');
83: elsif p_constraint_name = 'dple_overlapping' Then
84: fnd_message.set_name('OTA','OTA_13210_PLE_D_OVERLAP');
85: elsif p_constraint_name = 'startdate_must_succeed_tpl_startdate' Then
86: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
87: elsif p_constraint_name = 'enddate_must_precede_tpl_enddate' Then
88: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
82: fnd_message.set_name('OTA','OTA_13208_PLE_C_OVERLAP');
83: elsif p_constraint_name = 'dple_overlapping' Then
84: fnd_message.set_name('OTA','OTA_13210_PLE_D_OVERLAP');
85: elsif p_constraint_name = 'startdate_must_succeed_tpl_startdate' Then
86: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
87: elsif p_constraint_name = 'enddate_must_precede_tpl_enddate' Then
88: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
89: elsif p_constraint_name = 'startdate_must_succeed_tav_startdate' Then
90: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
84: fnd_message.set_name('OTA','OTA_13210_PLE_D_OVERLAP');
85: elsif p_constraint_name = 'startdate_must_succeed_tpl_startdate' Then
86: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
87: elsif p_constraint_name = 'enddate_must_precede_tpl_enddate' Then
88: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
89: elsif p_constraint_name = 'startdate_must_succeed_tav_startdate' Then
90: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
91: elsif p_constraint_name = 'enddate_must_precede_tav_enddate' Then
92: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
86: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
87: elsif p_constraint_name = 'enddate_must_precede_tpl_enddate' Then
88: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
89: elsif p_constraint_name = 'startdate_must_succeed_tav_startdate' Then
90: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
91: elsif p_constraint_name = 'enddate_must_precede_tav_enddate' Then
92: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
93: elsif p_constraint_name = 'increase_is_a_percent' then
94: fnd_message.set_name('OTA','OTA_13399_PLE_INCREASE_RANGE');
88: fnd_message.set_name('OTA','OTA_13374_PLE_DATES_TPL');
89: elsif p_constraint_name = 'startdate_must_succeed_tav_startdate' Then
90: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
91: elsif p_constraint_name = 'enddate_must_precede_tav_enddate' Then
92: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
93: elsif p_constraint_name = 'increase_is_a_percent' then
94: fnd_message.set_name('OTA','OTA_13399_PLE_INCREASE_RANGE');
95: elsif p_constraint_name = 'wrong_rounding_factor' then
96: fnd_message.set_name('OTA','OTA_13427_PLE_ROUNDING_FACTOR');
90: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
91: elsif p_constraint_name = 'enddate_must_precede_tav_enddate' Then
92: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
93: elsif p_constraint_name = 'increase_is_a_percent' then
94: fnd_message.set_name('OTA','OTA_13399_PLE_INCREASE_RANGE');
95: elsif p_constraint_name = 'wrong_rounding_factor' then
96: fnd_message.set_name('OTA','OTA_13427_PLE_ROUNDING_FACTOR');
97: else
98: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
92: fnd_message.set_name('OTA','OTA_13375_PLE_DATES_TAV');
93: elsif p_constraint_name = 'increase_is_a_percent' then
94: fnd_message.set_name('OTA','OTA_13399_PLE_INCREASE_RANGE');
95: elsif p_constraint_name = 'wrong_rounding_factor' then
96: fnd_message.set_name('OTA','OTA_13427_PLE_ROUNDING_FACTOR');
97: else
98: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
99: hr_utility.set_message_token('PROCEDURE', l_proc);
100: hr_utility.set_message_token('STEP',p_constraint_name);
100: hr_utility.set_message_token('STEP',p_constraint_name);
101: hr_utility.raise_error;
102: End If;
103: --
104: fnd_message.raise_error;
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: --
108: End constraint_error2;