DBA Data[Home] [Help]

APPS.PQH_FR_ASSIGNMENT_CHK dependencies on FND_MESSAGE

Line 33: fnd_message.set_name('PQH','PQH_FR_IDENTIFIER_EXIST');

29: Open csr_identifier;
30: Fetch csr_identifier into l_temp;
31: If csr_identifier%FOUND Then
32: --
33: fnd_message.set_name('PQH','PQH_FR_IDENTIFIER_EXIST');
34: hr_multi_message.add();
35: --
36: End If;
37: Close csr_identifier;

Line 60: fnd_message.set_name('PQH','PQH_FR_INVALID_PERCENTAGE');

56: l_percent_affected := fnd_number.canonical_to_number(p_percent_effected);
57:
58: If (l_percent_affected <=0 Or l_percent_affected >100 ) Then
59: ---
60: fnd_message.set_name('PQH','PQH_FR_INVALID_PERCENTAGE');
61: hr_multi_message.add();
62: --
63: End If;
64: g_fut_chk := 0;

Line 128: fnd_message.set_name('PQH','PQH_FR_TOT_PERCENTAGE');

124: l_tot_percent_affected := l_tot_percent_affected + l_percent_affected - l_asg_percent_affected;
125: If (l_tot_percent_affected >100 ) Then
126: --
127: if nvl(g_fut_chk,0) = 0 then
128: fnd_message.set_name('PQH','PQH_FR_TOT_PERCENTAGE');
129: else
130: fnd_message.set_name('PQH','PQH_FR_FUT_TOT_PERCENT');
131: fnd_message.set_token('FUTDATE',to_char(p_effective_date));
132: end if;

Line 130: fnd_message.set_name('PQH','PQH_FR_FUT_TOT_PERCENT');

126: --
127: if nvl(g_fut_chk,0) = 0 then
128: fnd_message.set_name('PQH','PQH_FR_TOT_PERCENTAGE');
129: else
130: fnd_message.set_name('PQH','PQH_FR_FUT_TOT_PERCENT');
131: fnd_message.set_token('FUTDATE',to_char(p_effective_date));
132: end if;
133: hr_multi_message.add();
134: --

Line 131: fnd_message.set_token('FUTDATE',to_char(p_effective_date));

127: if nvl(g_fut_chk,0) = 0 then
128: fnd_message.set_name('PQH','PQH_FR_TOT_PERCENTAGE');
129: else
130: fnd_message.set_name('PQH','PQH_FR_FUT_TOT_PERCENT');
131: fnd_message.set_token('FUTDATE',to_char(p_effective_date));
132: end if;
133: hr_multi_message.add();
134: --
135: End If;

Line 176: fnd_message.set_name('PQH','PQH_FR_NOFONC_ON_NONTIT_POS');

172: If (l_agent_type = '01' ) then -- Functionnaire
173: --
174: If (l_titulaire_pos ='N') Then
175: --
176: fnd_message.set_name('PQH','PQH_FR_NOFONC_ON_NONTIT_POS');
177: hr_multi_message.add();
178:
179: --
180: End If;

Line 219: fnd_message.set_name('PQH','PQH_FR_NOPERM_FOR_NONTIT');

215: If (l_agent_type = '02' ) then -- Non Titulaire
216:
217: If (p_type = 'P') And (l_titulaire_pos = 'Y') Then
218: --
219: fnd_message.set_name('PQH','PQH_FR_NOPERM_FOR_NONTIT');
220: hr_multi_message.add();
221: --
222: End If;
223: --

Line 260: fnd_message.set_name('PQH', 'PQH_FR_TURN_OFF_EXISTING_PRI');

256: Open is_primary_eff_exist_csr;
257: Fetch is_primary_eff_exist_csr into l_temp;
258: If is_primary_eff_exist_csr%found then
259: Close is_primary_eff_exist_csr;
260: fnd_message.set_name('PQH', 'PQH_FR_TURN_OFF_EXISTING_PRI');
261: hr_multi_message.add();
262: End if;
263:
264: Open is_fut_primary_eff_exist_csr;

Line 268: fnd_message.set_name('PQH','PQH_FR_FUT_PRIMARY_AFF');

264: Open is_fut_primary_eff_exist_csr;
265: loop
266: Fetch is_fut_primary_eff_exist_csr into l_fut_start_date;
267: Exit when is_fut_primary_eff_exist_csr%notfound;
268: fnd_message.set_name('PQH','PQH_FR_FUT_PRIMARY_AFF');
269: fnd_message.set_token('FUTUREDATE',to_char(l_fut_start_date));
270: hr_multi_message.add();
271: end loop;
272:

Line 269: fnd_message.set_token('FUTUREDATE',to_char(l_fut_start_date));

265: loop
266: Fetch is_fut_primary_eff_exist_csr into l_fut_start_date;
267: Exit when is_fut_primary_eff_exist_csr%notfound;
268: fnd_message.set_name('PQH','PQH_FR_FUT_PRIMARY_AFF');
269: fnd_message.set_token('FUTUREDATE',to_char(l_fut_start_date));
270: hr_multi_message.add();
271: end loop;
272:
273: End chk_Primary_affectation;

Line 309: fnd_message.set_name('PQH', 'PQH_FR_NOT_ACT_SIT');

305: Close csr_situation_info;
306:
307: if l_situation_type <> 'IA' then
308: if l_situation_type <> 'SC' then
309: fnd_message.set_name('PQH', 'PQH_FR_NOT_ACT_SIT');
310: hr_multi_message.add();
311: end if;
312: end if;
313: end if;