DBA Data[Home] [Help]

APPS.PER_PGT_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,'HIER_NODE_TYPE_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 per_pgt_shd.api_updating
193: (p_hier_node_type_id => p_rec.hier_node_type_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_hier_node_type_id => p_rec.hier_node_type_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 (per_pgt_shd.g_old_rec.child_node_type <> nvl(p_rec.child_node_type,hr_api.g_varchar2)) THEN

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 (per_pgt_shd.g_old_rec.child_node_type <> nvl(p_rec.child_node_type,hr_api.g_varchar2)) THEN
203: fnd_message.set_name('PER', 'HR_289899_PGT_CNTYPE_NO_UPD');

Line 203: fnd_message.set_name('PER', 'HR_289899_PGT_CNTYPE_NO_UPD');

199: fnd_message.raise_error;
200: END IF;
201: --
202: IF (per_pgt_shd.g_old_rec.child_node_type <> nvl(p_rec.child_node_type,hr_api.g_varchar2)) THEN
203: fnd_message.set_name('PER', 'HR_289899_PGT_CNTYPE_NO_UPD');
204: fnd_message.raise_error;
205: END IF;
206: --
207: IF (per_pgt_shd.g_old_rec.hierarchy_type <> nvl(p_rec.hierarchy_type,hr_api.g_varchar2)) THEN

Line 204: fnd_message.raise_error;

200: END IF;
201: --
202: IF (per_pgt_shd.g_old_rec.child_node_type <> nvl(p_rec.child_node_type,hr_api.g_varchar2)) THEN
203: fnd_message.set_name('PER', 'HR_289899_PGT_CNTYPE_NO_UPD');
204: fnd_message.raise_error;
205: END IF;
206: --
207: IF (per_pgt_shd.g_old_rec.hierarchy_type <> nvl(p_rec.hierarchy_type,hr_api.g_varchar2)) THEN
208: fnd_message.set_name('PER', 'HR_289900_PGT_HTYPE_NO_UPD');

Line 208: fnd_message.set_name('PER', 'HR_289900_PGT_HTYPE_NO_UPD');

204: fnd_message.raise_error;
205: END IF;
206: --
207: IF (per_pgt_shd.g_old_rec.hierarchy_type <> nvl(p_rec.hierarchy_type,hr_api.g_varchar2)) THEN
208: fnd_message.set_name('PER', 'HR_289900_PGT_HTYPE_NO_UPD');
209: fnd_message.raise_error;
210: END IF;
211: --
212: IF (nvl(per_pgt_shd.g_old_rec.business_group_id,hr_api.g_number)

Line 209: fnd_message.raise_error;

205: END IF;
206: --
207: IF (per_pgt_shd.g_old_rec.hierarchy_type <> nvl(p_rec.hierarchy_type,hr_api.g_varchar2)) THEN
208: fnd_message.set_name('PER', 'HR_289900_PGT_HTYPE_NO_UPD');
209: fnd_message.raise_error;
210: END IF;
211: --
212: IF (nvl(per_pgt_shd.g_old_rec.business_group_id,hr_api.g_number)
213: <> nvl(p_rec.business_group_id,hr_api.g_number)) THEN

Line 214: fnd_message.set_name('PER', 'HR_289901_PGT_BG_NO_UPD');

210: END IF;
211: --
212: IF (nvl(per_pgt_shd.g_old_rec.business_group_id,hr_api.g_number)
213: <> nvl(p_rec.business_group_id,hr_api.g_number)) THEN
214: fnd_message.set_name('PER', 'HR_289901_PGT_BG_NO_UPD');
215: fnd_message.raise_error;
216: END IF;
217: --
218: End chk_non_updateable_args;

Line 215: fnd_message.raise_error;

211: --
212: IF (nvl(per_pgt_shd.g_old_rec.business_group_id,hr_api.g_number)
213: <> nvl(p_rec.business_group_id,hr_api.g_number)) THEN
214: fnd_message.set_name('PER', 'HR_289901_PGT_BG_NO_UPD');
215: fnd_message.raise_error;
216: END IF;
217: --
218: End chk_non_updateable_args;
219:

Line 259: fnd_message.set_name('PER', 'HR_289902_PGT_HTYPE_INV');

255: If HR_API.NOT_EXISTS_IN_HRSTANLOOKUPS(p_effective_date => p_effective_date
256: ,p_lookup_type => 'HIERARCHY_TYPE'
257: ,p_lookup_code => p_hierarchy_type) then
258: --
259: fnd_message.set_name('PER', 'HR_289902_PGT_HTYPE_INV');
260: fnd_message.raise_error;
261: End If;
262: Else
263: fnd_message.set_name('PER', 'HR_289903_PGT_HTYPE_NULL');

Line 260: fnd_message.raise_error;

256: ,p_lookup_type => 'HIERARCHY_TYPE'
257: ,p_lookup_code => p_hierarchy_type) then
258: --
259: fnd_message.set_name('PER', 'HR_289902_PGT_HTYPE_INV');
260: fnd_message.raise_error;
261: End If;
262: Else
263: fnd_message.set_name('PER', 'HR_289903_PGT_HTYPE_NULL');
264: fnd_message.raise_error;

Line 263: fnd_message.set_name('PER', 'HR_289903_PGT_HTYPE_NULL');

259: fnd_message.set_name('PER', 'HR_289902_PGT_HTYPE_INV');
260: fnd_message.raise_error;
261: End If;
262: Else
263: fnd_message.set_name('PER', 'HR_289903_PGT_HTYPE_NULL');
264: fnd_message.raise_error;
265: End If;
266: --
267: Exception

Line 264: fnd_message.raise_error;

260: fnd_message.raise_error;
261: End If;
262: Else
263: fnd_message.set_name('PER', 'HR_289903_PGT_HTYPE_NULL');
264: fnd_message.raise_error;
265: End If;
266: --
267: Exception
268: when app_exception.application_exception then

Line 346: fnd_message.set_name('PER', 'HR_289904_PGT_CNODE_TYPE_NULL');

342: -- check child node is supplied
343: -- and a valid lookup code
344: If p_child_node_type IS NULL then
345: -- child node type requires independent validation here
346: fnd_message.set_name('PER', 'HR_289904_PGT_CNODE_TYPE_NULL');
347: hr_multi_message.add
348: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');
349: Else
350: --

Line 361: fnd_message.set_name('PER', 'HR_289906_PGT_CNODE_TYPE_INV');

357: ,p_lookup_code => p_child_node_type) then
358:
359: --
360: l_err_flag := true;
361: fnd_message.set_name('PER', 'HR_289906_PGT_CNODE_TYPE_INV');
362: -- independently validated
363: hr_multi_message.add
364: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');
365: End If;

Line 383: fnd_message.set_name('PER', 'HR_289905_PGT_CNODE_NOT_UNQ');

379: Fetch csr_node into l_dummy;
380: If csr_node%found then
381: Close csr_node;
382: l_err_flag := TRUE;
383: fnd_message.set_name('PER', 'HR_289905_PGT_CNODE_NOT_UNQ');
384: -- conditionally independently validated
385: hr_multi_message.add
386: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');
387: Else

Line 396: fnd_message.set_name('PER', 'HR_289907_PGT_CNODE_IS_PNODE');

392: --
393: -- check that the child_node is not the same as the parent node
394: --
395: If not(l_err_flag) and p_child_node_type = nvl(p_parent_node_type,-999) then
396: fnd_message.set_name('PER', 'HR_289907_PGT_CNODE_IS_PNODE');
397: -- conditionally independently validated
398: l_err_flag := TRUE;
399: hr_multi_message.add
400: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.CHILD_NODE_TYPE');

Line 425: fnd_message.set_name('PER', 'HR_289908_PGT_PNODE_TYPE_INV');

421: ,p_lookup_type => 'HIERARCHY_NODE_TYPE'
422: ,p_lookup_code => p_parent_node_type) then
423: --
424: l_err_parent_flag := TRUE;
425: fnd_message.set_name('PER', 'HR_289908_PGT_PNODE_TYPE_INV');
426: -- independently validated
427: hr_multi_message.add
428: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');
429: --

Line 446: fnd_message.set_name('PER', 'HR_289909_PGT_PNODE_NOT_CNODE');

442: Open csr_node(p_parent_node_type, p_hierarchy_type);
443: Fetch csr_node into l_dummy;
444: If csr_node%notfound then
445: Close csr_node;
446: fnd_message.set_name('PER', 'HR_289909_PGT_PNODE_NOT_CNODE');
447: hr_multi_message.add
448: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');
449: Else
450: Close csr_node;

Line 460: fnd_message.set_name('PER', 'HR_289907_PGT_CNODE_IS_PNODE');

456: If (not(l_err_flag) and not(l_err_parent_flag)) and
457: (p_hier_node_type_id is not null and
458: per_pgt_shd.g_old_rec.child_node_type = p_parent_node_type)
459: then
460: fnd_message.set_name('PER', 'HR_289907_PGT_CNODE_IS_PNODE');
461: hr_multi_message.add
462: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');
463: End If;
464: End If;

Line 478: fnd_message.set_name('PER', 'HR_289910_PGT_TOP_NODE_DUP');

474: Open csr_top_node(p_hierarchy_type);
475: Fetch csr_top_node into l_dummy;
476: If csr_top_node%found then
477: Close csr_top_node;
478: fnd_message.set_name('PER', 'HR_289910_PGT_TOP_NODE_DUP');
479: hr_multi_message.add
480: (p_associated_column1 => 'PER_GEN_HIER_NODE_TYPES.PARENT_NODE_TYPE');
481: Else
482: Close csr_top_node;

Line 533: fnd_message.set_name('PER', 'HR_289911_PGT_CHILD_VS_NULL');

529: --
530: hr_utility.set_location('Entering:'||l_proc, 5);
531:
532: If p_child_value_set is null then
533: fnd_message.set_name('PER', 'HR_289911_PGT_CHILD_VS_NULL');
534: fnd_message.raise_error;
535: Else
536: If p_hier_node_type_id is null or
537: per_pgt_shd.g_old_rec.child_value_set <> p_child_value_set then

Line 534: fnd_message.raise_error;

530: hr_utility.set_location('Entering:'||l_proc, 5);
531:
532: If p_child_value_set is null then
533: fnd_message.set_name('PER', 'HR_289911_PGT_CHILD_VS_NULL');
534: fnd_message.raise_error;
535: Else
536: If p_hier_node_type_id is null or
537: per_pgt_shd.g_old_rec.child_value_set <> p_child_value_set then
538: -- confirm that VS exist

Line 543: fnd_message.set_name('PER', 'HR_289912_PGT_CHILD_VS_INV');

539: Open csr_vs;
540: Fetch csr_vs into l_dummy;
541: If csr_vs%notfound then
542: Close csr_vs;
543: fnd_message.set_name('PER', 'HR_289912_PGT_CHILD_VS_INV');
544: fnd_message.raise_error;
545: Else
546: Close csr_vs;
547: End If;

Line 544: fnd_message.raise_error;

540: Fetch csr_vs into l_dummy;
541: If csr_vs%notfound then
542: Close csr_vs;
543: fnd_message.set_name('PER', 'HR_289912_PGT_CHILD_VS_INV');
544: fnd_message.raise_error;
545: Else
546: Close csr_vs;
547: End If;
548:

Line 556: fnd_message.set_name('PER', 'HR_289192_PER_CAL_VS_IN_USE');

552: Open csr_node_used;
553: Fetch csr_node_used into l_dummy;
554: If csr_node_used%found then
555: Close csr_node_used;
556: fnd_message.set_name('PER', 'HR_289192_PER_CAL_VS_IN_USE');
557: fnd_message.raise_error;
558: Else
559: Close csr_node_used;
560: End If;

Line 557: fnd_message.raise_error;

553: Fetch csr_node_used into l_dummy;
554: If csr_node_used%found then
555: Close csr_node_used;
556: fnd_message.set_name('PER', 'HR_289192_PER_CAL_VS_IN_USE');
557: fnd_message.raise_error;
558: Else
559: Close csr_node_used;
560: End If;
561: End if;

Line 722: fnd_message.set_name('PER', 'HR_289913_PER_CAL_CHILD_EXISTS');

718: -- 2) the node's type hierarchy is not used in a generic hierarchy already
719:
720: If 'Y' = hr_calendar_node_type_api.child_exists(p_hierarchy_type => p_rec.hierarchy_type
721: ,p_child_node_type => p_rec.child_node_type) then
722: fnd_message.set_name('PER', 'HR_289913_PER_CAL_CHILD_EXISTS');
723: fnd_message.raise_error;
724: End if;
725:
726: -- bug 2982313 rework this to actually check if the scope record is being used in a generic hierarchy

Line 723: fnd_message.raise_error;

719:
720: If 'Y' = hr_calendar_node_type_api.child_exists(p_hierarchy_type => p_rec.hierarchy_type
721: ,p_child_node_type => p_rec.child_node_type) then
722: fnd_message.set_name('PER', 'HR_289913_PER_CAL_CHILD_EXISTS');
723: fnd_message.raise_error;
724: End if;
725:
726: -- bug 2982313 rework this to actually check if the scope record is being used in a generic hierarchy
727: -- rather than checking if hierarchy type has been used by the open .

Line 729: -- fnd_message.set_name('PER', 'HR_289914_PER_CAL_HIER_EXISTS');

725:
726: -- bug 2982313 rework this to actually check if the scope record is being used in a generic hierarchy
727: -- rather than checking if hierarchy type has been used by the open .
728: --If 'Y' = hr_calendar_node_type_api.gen_hier_exists(p_hierarchy_type => p_rec.hierarchy_type) then
729: -- fnd_message.set_name('PER', 'HR_289914_PER_CAL_HIER_EXISTS');
730: -- fnd_message.raise_error;
731: --End if;
732: open csr_node_used;
733: fetch csr_node_used into l_dummy;

Line 730: -- fnd_message.raise_error;

726: -- bug 2982313 rework this to actually check if the scope record is being used in a generic hierarchy
727: -- rather than checking if hierarchy type has been used by the open .
728: --If 'Y' = hr_calendar_node_type_api.gen_hier_exists(p_hierarchy_type => p_rec.hierarchy_type) then
729: -- fnd_message.set_name('PER', 'HR_289914_PER_CAL_HIER_EXISTS');
730: -- fnd_message.raise_error;
731: --End if;
732: open csr_node_used;
733: fetch csr_node_used into l_dummy;
734: if csr_node_used%found then

Line 736: fnd_message.set_name('PER', 'HR_289914_PER_CAL_HIER_EXISTS');

732: open csr_node_used;
733: fetch csr_node_used into l_dummy;
734: if csr_node_used%found then
735: close csr_node_used;
736: fnd_message.set_name('PER', 'HR_289914_PER_CAL_HIER_EXISTS');
737: fnd_message.raise_error;
738: else
739: close csr_node_used;
740: end if;

Line 737: fnd_message.raise_error;

733: fetch csr_node_used into l_dummy;
734: if csr_node_used%found then
735: close csr_node_used;
736: fnd_message.set_name('PER', 'HR_289914_PER_CAL_HIER_EXISTS');
737: fnd_message.raise_error;
738: else
739: close csr_node_used;
740: end if;
741: -- end bug 2982313.