DBA Data[Home] [Help]

APPS.OTA_TPL_BUS dependencies on FND_MESSAGE

Line 57: fnd_message.set_name('OTA','OTA_13567_TPL_DEFAULT_FLAG');

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');

Line 59: fnd_message.set_name('OTA','OTA_13566_TPL_COPY_PRICE_LIST');

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');

Line 61: fnd_message.set_name('OTA','OTA_13568_TPL_PRICE_LIST_NAME');

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');

Line 63: 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

Line 65: fnd_message.set_name('OTA','OTA_13569_TPL_SINGLE_UNIT');

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

Line 68: fnd_message.set_name('OTA','OTA_13570_TPL_PRICE_LIST_NAME');

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');

Line 70: fnd_message.set_name('OTA','OTA_13571_TPL_LIST_TYPE');

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');

Line 72: 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');

Line 74: fnd_message.set_name('OTA','OTA_13572_TPL_SINGLE_UNIT_NULL');

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

Line 76: fnd_message.set_name('OTA','OTA_13228_TPL_TBD_EXISTS');

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

Line 79: fnd_message.set_name('OTA','OTA_13258_TPL_WRONG_NAME');

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');

Line 81: fnd_message.set_name('OTA','OTA_13221_TPL_WRONG_FLAG');

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');

Line 83: fnd_message.set_name('OTA','OTA_13233_TPL_DATES_PLE');

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');

Line 85: fnd_message.set_name('OTA','OTA_13234_TPL_DATES_TBD');

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');

Line 87: fnd_message.set_name('OTA','OTA_13230_GEN_MAND_START_DATE');

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');

Line 89: fnd_message.set_name('OTA','OTA_13312_GEN_DATE_ORDER');

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

Line 91: fnd_message.set_name('OTA','OTA_13639_TPL_ENTRIES_EXIST');

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);

Line 94: fnd_message.set_name('OTA','OTA_13259_GEN_UNKN_CONSTRAINT');

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;

Line 95: fnd_message.set_token('CONSTRAINT',p_constraint_name);

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: --

Line 98: fnd_message.raise_error;

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;