DBA Data[Home] [Help]

APPS.PQH_CGN_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,'CASE_GROUP_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_cgn_shd.api_updating
193: (p_case_group_id => p_rec.case_group_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_case_group_id => p_rec.case_group_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: -- EDIT_HERE: Add checks to ensure non-updateable args have

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: -- EDIT_HERE: Add checks to ensure non-updateable args have
203: -- not been updated.

Line 210: fnd_message.raise_error;

206:
207: IF nvl(p_rec.CASE_GROUP_NUMBER, hr_api.g_varchar2) <>
208: nvl(pqh_cgn_shd.g_old_rec.CASE_GROUP_NUMBER, hr_api.g_varchar2) THEN
209: hr_utility.set_message(8302, 'PQH_DE_CSGRP_NUMBER');
210: fnd_message.raise_error;
211: END IF;
212:
213:
214: --

Line 238: fnd_message.raise_error;

234: Fetch c_case_group_NUMBER into l_case_group_NUMBER;
235: If c_case_group_NUMBER%ROWCOUNT = 0 Then
236: hr_utility.set_message(8302, 'PQH_DE_NO_EXIST_CASE_GROUP');
237: Close c_case_group_NUMBER;
238: fnd_message.raise_error;
239: End If;
240: Close c_case_group_NUMBER;
241: Exception
242: when app_exception.application_exception then

Line 307: fnd_message.raise_error;

303: Fetch c_case_group_NUMBER into L_status;
304: If c_case_group_NUMBER%found Then
305: hr_utility.set_message(8302, 'PQH_DE_CASE_GROUP_DUP');
306: Close c_case_group_NUMBER;
307: fnd_message.raise_error;
308: End If;
309: Close c_case_group_NUMBER;
310: Exception
311: when app_exception.application_exception then