DBA Data[Home] [Help]

APPS.PQH_STR_BUS dependencies on FND_MESSAGE

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

69: close csr_sec_grp;
70: --
71: -- The primary key is invalid therefore we must error
72: --
73: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
74: hr_multi_message.add
75: (p_associated_column1
76: => nvl(p_associated_column1,'STAT_SITUATION_RULE_ID')
77: );

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

167: --
168: -- The primary key is invalid therefore we must error
169: --
170: close csr_leg_code;
171: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
172: fnd_message.raise_error;
173: end if;
174: if g_debug then
175: --

Line 172: fnd_message.raise_error;

168: -- The primary key is invalid therefore we must error
169: --
170: close csr_leg_code;
171: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
172: fnd_message.raise_error;
173: end if;
174: if g_debug then
175: --
176: hr_utility.set_location(l_proc,30);

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

234: IF NOT pqh_str_shd.api_updating
235: (p_stat_situation_rule_id => p_rec.stat_situation_rule_id
236: ,p_object_version_number => p_rec.object_version_number
237: ) THEN
238: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE ', l_proc);
240: fnd_message.set_token('STEP ', '5');
241: fnd_message.raise_error;
242: END IF;

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

235: (p_stat_situation_rule_id => p_rec.stat_situation_rule_id
236: ,p_object_version_number => p_rec.object_version_number
237: ) THEN
238: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE ', l_proc);
240: fnd_message.set_token('STEP ', '5');
241: fnd_message.raise_error;
242: END IF;
243: --

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

236: ,p_object_version_number => p_rec.object_version_number
237: ) THEN
238: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE ', l_proc);
240: fnd_message.set_token('STEP ', '5');
241: fnd_message.raise_error;
242: END IF;
243: --
244: -- No non-updateable args have

Line 241: fnd_message.raise_error;

237: ) THEN
238: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE ', l_proc);
240: fnd_message.set_token('STEP ', '5');
241: fnd_message.raise_error;
242: END IF;
243: --
244: -- No non-updateable args have
245: --

Line 301: fnd_message.set_name('PQH','PQH_FR_INVALID_CRITERIA');

297: Fetch csr_validate_criteria into l_value;
298:
299: IF csr_validate_criteria%NOTFOUND THEN
300: --
301: fnd_message.set_name('PQH','PQH_FR_INVALID_CRITERIA');
302:
303: hr_multi_message.add(p_associated_column1=> 'TXN_CATEGORY_ATTRIBUTE_ID');
304: --
305: END If;

Line 342: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUESET');

338: Fetch chk_value_set_existence into l_value;
339:
340: IF chk_value_set_existence%NOTFOUND THEN
341: --
342: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUESET');
343: fnd_message.set_token('FIELD','FROM_VALUE');
344:
345: hr_multi_message.add(p_associated_column1=> 'FROM_VALUE');
346: --

Line 343: fnd_message.set_token('FIELD','FROM_VALUE');

339:
340: IF chk_value_set_existence%NOTFOUND THEN
341: --
342: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUESET');
343: fnd_message.set_token('FIELD','FROM_VALUE');
344:
345: hr_multi_message.add(p_associated_column1=> 'FROM_VALUE');
346: --
347: END If;

Line 377: fnd_message.set_name('PQH','PQH_FR_INVALID_TO_VALUE');

373:
374: if (l_value_style_cd = 'EXACT') then
375:
376: --
377: fnd_message.set_name('PQH','PQH_FR_INVALID_TO_VALUE');
378: hr_multi_message.add
379: (p_associated_column1 => 'TO_VALUE');
380: --
381: end if;

Line 415: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');

411:
412: if pqh_fr_stat_sit_util.Is_input_is_valid
413: (p_txn_category_attribute_id, p_from_value) = 'N' then
414: --
415: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
416: fnd_message.set_token('ATTRIBUTE',p_from_value);
417: hr_multi_message.add
418: (p_associated_column1 => 'FROM_VALUE');
419: --

Line 416: fnd_message.set_token('ATTRIBUTE',p_from_value);

412: if pqh_fr_stat_sit_util.Is_input_is_valid
413: (p_txn_category_attribute_id, p_from_value) = 'N' then
414: --
415: fnd_message.set_name('PQH','PQH_FR_INVALID_VALUE');
416: fnd_message.set_token('ATTRIBUTE',p_from_value);
417: hr_multi_message.add
418: (p_associated_column1 => 'FROM_VALUE');
419: --
420: else

Line 425: fnd_message.set_name('PQH','PQH_FR_STAT_SIT_VALGRT_ZERO');

421: If (l_value_style_cd = 'RANGE') Then
422: --
423: if (to_number(p_from_value) <=0 ) then
424: --
425: fnd_message.set_name('PQH','PQH_FR_STAT_SIT_VALGRT_ZERO');
426: hr_multi_message.add(p_associated_column1=>'FROM_VALUE_MEANING');
427: --
428: end if;
429: --

Line 460: fnd_message.set_name('PQH','PQH_FR_STAT_CRIT_FROM_TO_ERR');

456:
457: if ( to_number(p_from_value) > to_number(p_to_value) )
458: then
459: --
460: fnd_message.set_name('PQH','PQH_FR_STAT_CRIT_FROM_TO_ERR');
461: hr_multi_message.add (p_associated_column1 => 'TO_VALUE');
462: --
463: end if;
464: Exception

Line 466: fnd_message.set_name('PQH','PQH_FR_STAT_CRIT_INVALID_FRMTO');

462: --
463: end if;
464: Exception
465: when others then
466: fnd_message.set_name('PQH','PQH_FR_STAT_CRIT_INVALID_FRMTO');
467: fnd_message.set_token('FIELD_NAME',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS',l_field_name));
468: hr_multi_message.add (p_associated_column1 => 'TO_VALUE');
469: End;
470:

Line 467: fnd_message.set_token('FIELD_NAME',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS',l_field_name));

463: end if;
464: Exception
465: when others then
466: fnd_message.set_name('PQH','PQH_FR_STAT_CRIT_INVALID_FRMTO');
467: fnd_message.set_token('FIELD_NAME',hr_general.decode_lookup('FR_PQH_FORM_PROMPTS',l_field_name));
468: hr_multi_message.add (p_associated_column1 => 'TO_VALUE');
469: End;
470:
471: --