eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ASR_BUS dependencies on HR_UTILITY

Line 31: hr_utility.set_location('Entering:'|| l_proc,5);

27: l_argument varchar2(30);
28: --
29: Begin
30: --
31: hr_utility.set_location('Entering:'|| l_proc,5);
32: --
33: -- Only proceed with validation if a row exists for
34: -- the current record in the HR Schema.
35: if not per_asr_shd.api_updating

Line 40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

36: --
37: (p_assessment_group_id => p_rec.assessment_group_id
38: ,p_object_version_number => p_rec.object_version_number
39: ) then
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP', '5');
43: end if;
44: --

Line 41: hr_utility.set_message_token('PROCEDURE', l_proc);

37: (p_assessment_group_id => p_rec.assessment_group_id
38: ,p_object_version_number => p_rec.object_version_number
39: ) then
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP', '5');
43: end if;
44: --
45: hr_utility.set_location (l_proc, 6);

Line 42: hr_utility.set_message_token('STEP', '5');

38: ,p_object_version_number => p_rec.object_version_number
39: ) then
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP', '5');
43: end if;
44: --
45: hr_utility.set_location (l_proc, 6);
46: --

Line 45: hr_utility.set_location (l_proc, 6);

41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('STEP', '5');
43: end if;
44: --
45: hr_utility.set_location (l_proc, 6);
46: --
47: if p_rec.business_group_id <> per_asn_shd.g_old_rec.business_group_id then
48: l_argument := 'business_group_id';
49: raise l_error;

Line 60: hr_utility.set_location(' Leaving : '|| l_proc, 10);

56: ,p_argument => l_argument);
57: when others then
58: raise;
59: --
60: hr_utility.set_location(' Leaving : '|| l_proc, 10);
61: --
62: end chk_non_updateable_args;
63: --
64: --

Line 112: hr_utility.set_location('Entering:'||l_proc, 5);

108: l_exists varchar2(1);
109: l_api_updating boolean;
110: --
111: begin
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: -- Check that the business_group_id is not null.
115: --
116: hr_api.mandatory_arg_error

Line 132: hr_utility.set_location (l_proc, 2);

128: (p_assessment_group_id => p_assessment_group_id
129: ,p_object_version_number => p_object_version_number
130: );
131: --
132: hr_utility.set_location (l_proc, 2);
133: --
134: if (l_api_updating AND
135: nvl(per_asr_shd.g_old_rec.name, hr_api.g_varchar2)
136: <> nvl(p_name, hr_api.g_varchar2)

Line 140: hr_utility.set_location (l_proc, 3);

136: <> nvl(p_name, hr_api.g_varchar2)
137: or not l_api_updating)
138: then
139: --
140: hr_utility.set_location (l_proc, 3);
141: --
142: -- Check that the name isn't NULL
143: --
144: if p_name is NULL then

Line 145: hr_utility.set_message(801,'HR_51595_ASR_NAME_NULL');

141: --
142: -- Check that the name isn't NULL
143: --
144: if p_name is NULL then
145: hr_utility.set_message(801,'HR_51595_ASR_NAME_NULL');
146: hr_utility.raise_error;
147: end if;
148: --
149: -- Check that the name is unique within the business group.

Line 146: hr_utility.raise_error;

142: -- Check that the name isn't NULL
143: --
144: if p_name is NULL then
145: hr_utility.set_message(801,'HR_51595_ASR_NAME_NULL');
146: hr_utility.raise_error;
147: end if;
148: --
149: -- Check that the name is unique within the business group.
150: --

Line 151: hr_utility.set_location('Cursor open;name:'||l_proc, 5);

147: end if;
148: --
149: -- Check that the name is unique within the business group.
150: --
151: hr_utility.set_location('Cursor open;name:'||l_proc, 5);
152: open csr_chk_name_unique;
153: fetch csr_chk_name_unique into l_exists;
154: if csr_chk_name_unique%found then
155: hr_utility.set_location('name not unique:'||l_proc, 5);

Line 155: hr_utility.set_location('name not unique:'||l_proc, 5);

151: hr_utility.set_location('Cursor open;name:'||l_proc, 5);
152: open csr_chk_name_unique;
153: fetch csr_chk_name_unique into l_exists;
154: if csr_chk_name_unique%found then
155: hr_utility.set_location('name not unique:'||l_proc, 5);
156: -- The name already exists in the business group
157: close csr_chk_name_unique;
158: per_asr_shd.constraint_error
159: (p_constraint_name => 'PER_ASSESSMENT_GROUPS_NAME_UK1');

Line 165: hr_utility.set_location(' Leaving:'||l_proc, 10);

161: close csr_chk_name_unique;
162: --
163: end if;
164: --
165: hr_utility.set_location(' Leaving:'||l_proc, 10);
166: --
167: end chk_name_unique;
168: --
169: -- ----------------------------------------------------------------------------

Line 205: hr_utility.set_location('Entering:'|| l_proc, 1);

201: --
202: l_exists varchar2(1);
203: --
204: begin
205: hr_utility.set_location('Entering:'|| l_proc, 1);
206: --
207: -- Check that the assessment group is not referenced by an assessment
208: --
209: open csr_chk_ref_rows_asn;

Line 215: hr_utility.set_location(l_proc,5);

211: --
212: if csr_chk_ref_rows_asn%found then
213: close csr_chk_ref_rows_asn;
214: --
215: hr_utility.set_location(l_proc,5);
216: hr_utility.set_message (801, 'HR_51597_ASR_REF_BY_ASS');
217: hr_utility.raise_error;
218: --
219: end if;

Line 216: hr_utility.set_message (801, 'HR_51597_ASR_REF_BY_ASS');

212: if csr_chk_ref_rows_asn%found then
213: close csr_chk_ref_rows_asn;
214: --
215: hr_utility.set_location(l_proc,5);
216: hr_utility.set_message (801, 'HR_51597_ASR_REF_BY_ASS');
217: hr_utility.raise_error;
218: --
219: end if;
220: close csr_chk_ref_rows_asn;

Line 217: hr_utility.raise_error;

213: close csr_chk_ref_rows_asn;
214: --
215: hr_utility.set_location(l_proc,5);
216: hr_utility.set_message (801, 'HR_51597_ASR_REF_BY_ASS');
217: hr_utility.raise_error;
218: --
219: end if;
220: close csr_chk_ref_rows_asn;
221: --

Line 257: hr_utility.set_location('Entering:'||l_proc, 10);

253: --
254: l_proc varchar2(72) := g_package||'chk_df';
255: --
256: begin
257: hr_utility.set_location('Entering:'||l_proc, 10);
258: --
259: if ((p_rec.assessment_group_id is not null) and (
260: nvl(per_asr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

Line 357: hr_utility.set_location(' Leaving:'||l_proc, 20);

353: ,p_attribute20_value => p_rec.attribute20
354: );
355: end if;
356: --
357: hr_utility.set_location(' Leaving:'||l_proc, 20);
358: --
359: end chk_df;
360: --
361: -- ----------------------------------------------------------------------------

Line 371: hr_utility.set_location('Entering:'||l_proc, 5);

367: --
368: l_proc varchar2(72) := g_package||'insert_validate';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: -- Call all supporting business operations
374: --
375: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 393: hr_utility.set_location(' Leaving:'||l_proc, 10);

389: -- Call descriptive flexfield validation routines
390: --
391: per_asr_bus.chk_df(p_rec => p_rec);
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: End insert_validate;
395: --
396: -- ----------------------------------------------------------------------------
397: -- |---------------------------< update_validate >----------------------------|

Line 406: hr_utility.set_location('Entering:'||l_proc, 5);

402: --
403: l_proc varchar2(72) := g_package||'update_validate';
404: --
405: Begin
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- Call all supporting business operations. Mapping is provided
409: --
410: --

Line 438: hr_utility.set_location(' Leaving:'||l_proc, 10);

434: -- Call descriptive flexfield validation routines
435: --
436: per_asr_bus.chk_df(p_rec => p_rec);
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: End update_validate;
440: --
441: -- ----------------------------------------------------------------------------
442: -- |---------------------------< delete_validate >----------------------------|

Line 449: hr_utility.set_location('Entering:'||l_proc, 5);

445: --
446: l_proc varchar2(72) := g_package||'delete_validate';
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 5);
450: --
451: -- Call all supporting business operations
452: per_asr_bus.chk_ref_rows_asn
453: (p_assessment_group_id => p_rec.assessment_group_id);

Line 455: hr_utility.set_location(' Leaving:'||l_proc, 10);

451: -- Call all supporting business operations
452: per_asr_bus.chk_ref_rows_asn
453: (p_assessment_group_id => p_rec.assessment_group_id);
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 10);
456: End delete_validate;
457: --
458: -- ----------------------------------------------------------------------------
459: -- |-----------------------< return_legislation_code >-------------------------|

Line 478: hr_utility.set_location('Entering:'||l_proc, 5);

474: l_proc varchar2(72) := g_package||'return_legislation_code';
475: l_legislation_code varchar2(150);
476: --
477: Begin
478: hr_utility.set_location('Entering:'||l_proc, 5);
479: --
480: -- Ensure that all the mandatory parameters are not null
481: --
482: hr_api.mandatory_arg_error (p_api_name => l_proc,

Line 492: hr_utility.set_location(l_proc, 10);

488: -- call to this function. Just return the value in the global
489: -- variable.
490: --
491: l_legislation_code := g_legislation_code;
492: hr_utility.set_location(l_proc, 10);
493: else
494: --
495: -- The ID is different to the last call to this function
496: -- or this is the first call to this function.

Line 505: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

501: close csr_leg_code;
502: --
503: -- The primary key is invalid therefore we must error out
504: --
505: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
506: hr_utility.raise_error;
507: end if;
508: --
509: close csr_leg_code;

Line 506: hr_utility.raise_error;

502: --
503: -- The primary key is invalid therefore we must error out
504: --
505: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
506: hr_utility.raise_error;
507: end if;
508: --
509: close csr_leg_code;
510: --

Line 514: hr_utility.set_location(' Leaving:'|| l_proc, 15);

510: --
511: g_assessment_group_id:= p_assessment_group_id;
512: g_legislation_code := l_legislation_code;
513: end if;
514: hr_utility.set_location(' Leaving:'|| l_proc, 15);
515: --
516: return l_legislation_code;
517: --
518: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 518: hr_utility.set_location(' Leaving:'||l_proc, 20);

514: hr_utility.set_location(' Leaving:'|| l_proc, 15);
515: --
516: return l_legislation_code;
517: --
518: hr_utility.set_location(' Leaving:'||l_proc, 20);
519: --
520: End return_legislation_code;
521: --
522: --