DBA Data[Home] [Help]

APPS.PQH_ETM_BUS dependencies on FND_MESSAGE

Line 60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

56: close csr_sec_grp;
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'ENT_MINUTES_ID')
64: );

Line 137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

133: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --

Line 138: fnd_message.raise_error;

134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are

Line 196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

192: IF NOT pqh_etm_shd.api_updating
193: (p_ent_minutes_id => p_rec.ent_minutes_id
194: ,p_object_version_number => p_rec.object_version_number
195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
197: fnd_message.set_token('PROCEDURE ', l_proc);
198: fnd_message.set_token('STEP ', '5');
199: fnd_message.raise_error;
200: END IF;

Line 197: fnd_message.set_token('PROCEDURE ', l_proc);

193: (p_ent_minutes_id => p_rec.ent_minutes_id
194: ,p_object_version_number => p_rec.object_version_number
195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
197: fnd_message.set_token('PROCEDURE ', l_proc);
198: fnd_message.set_token('STEP ', '5');
199: fnd_message.raise_error;
200: END IF;
201:

Line 198: fnd_message.set_token('STEP ', '5');

194: ,p_object_version_number => p_rec.object_version_number
195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
197: fnd_message.set_token('PROCEDURE ', l_proc);
198: fnd_message.set_token('STEP ', '5');
199: fnd_message.raise_error;
200: END IF;
201:
202: IF nvl(p_rec.ENT_MINUTES_CD, hr_api.g_varchar2) <>

Line 199: fnd_message.raise_error;

195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
197: fnd_message.set_token('PROCEDURE ', l_proc);
198: fnd_message.set_token('STEP ', '5');
199: fnd_message.raise_error;
200: END IF;
201:
202: IF nvl(p_rec.ENT_MINUTES_CD, hr_api.g_varchar2) <>
203: nvl(pqh_etm_shd.g_old_rec.ENT_MINUTES_CD, hr_api.g_varchar2) THEN

Line 205: fnd_message.raise_error;

201:
202: IF nvl(p_rec.ENT_MINUTES_CD, hr_api.g_varchar2) <>
203: nvl(pqh_etm_shd.g_old_rec.ENT_MINUTES_CD, hr_api.g_varchar2) THEN
204: hr_utility.set_message(8302, 'DE_PQH_NONUPD_ENT_CD');
205: fnd_message.raise_error;
206: END IF;
207:
208: IF nvl(p_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) <>
209: nvl(pqh_etm_shd.g_old_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) THEN

Line 211: fnd_message.raise_error;

207:
208: IF nvl(p_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) <>
209: nvl(pqh_etm_shd.g_old_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) THEN
210: hr_utility.set_message(8302, 'DE_PQH_NONUPD_TARIFF_CD');
211: fnd_message.raise_error;
212: END IF;
213:
214:
215: --

Line 243: fnd_message.raise_error;

239: Fetch c_TFF_CD_HR_LOOKUP into L_status;
240: If c_TFF_CD_HR_LOOKUP%notfound Then
241: hr_utility.set_message(8302, 'DE_PQH_TARIFF_CODE');
242: Close c_TFF_CD_HR_LOOKUP;
243: fnd_message.raise_error;
244: End If;
245: Close c_TFF_CD_HR_LOOKUP;
246: Exception
247: when app_exception.application_exception then

Line 279: fnd_message.raise_error;

275: Fetch c_unique_ENT_Desc into L_status;
276: If c_unique_ENT_Desc%found Then
277: hr_utility.set_message(8302, 'DE_PQH_unique_ENT_Desc');
278: Close c_unique_ENT_Desc;
279: fnd_message.raise_error;
280: End If;
281: Close c_unique_ENT_Desc;
282: Exception
283: when app_exception.application_exception then

Line 315: fnd_message.raise_error;

311: Fetch c_ENT_MIN_TFF_CD into L_status;
312: If c_ENT_MIN_TFF_CD%found Then
313: hr_utility.set_message(8302, 'PQH_DE_ENT_MINUTES_DUP');
314: Close c_ENT_MIN_TFF_CD;
315: fnd_message.raise_error;
316: End If;
317: Close c_ENT_MIN_TFF_CD;
318: Exception
319: when app_exception.application_exception then