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_ASP_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := per_asp_shd.api_updating
47: (p_sec_profile_assignment_id => p_sec_profile_assignment_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_sec_profile_assignment_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.security_profile_id = p_security_profile_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := per_asp_shd.api_updating
119: (p_sec_profile_assignment_id => p_sec_profile_assignment_id,
120: p_object_version_number => p_object_version_number);

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

143: close c1;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: End chk_security_profile_id;
150: --
151: -- ----------------------------------------------------------------------------

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

188: and h1.organization_id = p_business_group_id;
189: --
190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := per_asp_shd.api_updating
195: (p_sec_profile_assignment_id => p_sec_profile_assignment_id,
196: p_object_version_number => p_object_version_number);

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

219: close c1;
220: --
221: end if;
222: --
223: hr_utility.set_location('Leaving:'||l_proc,10);
224: --
225: End chk_business_group_id;
226: --
227: -- ----------------------------------------------------------------------------

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

273: l_error EXCEPTION;
274: l_argument VARCHAR2 (30);
275: --
276: BEGIN
277: hr_utility.set_location('Entering:'||l_proc, 10);
278: --
279: -- Only proceed with validation if a row exists for
280: -- the current record in the HR Schema
281: --

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

283: (p_sec_profile_assignment_id => p_rec.sec_profile_assignment_id
284: ,p_object_version_number => p_rec.object_version_number
285: )
286: THEN
287: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
288: hr_utility.set_message_token('PROCEDURE', l_proc);
289: hr_utility.set_message_token('STEP', '20');
290: END IF;
291: --

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

284: ,p_object_version_number => p_rec.object_version_number
285: )
286: THEN
287: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
288: hr_utility.set_message_token('PROCEDURE', l_proc);
289: hr_utility.set_message_token('STEP', '20');
290: END IF;
291: --
292: hr_utility.set_location(l_proc, 30);

Line 289: hr_utility.set_message_token('STEP', '20');

285: )
286: THEN
287: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
288: hr_utility.set_message_token('PROCEDURE', l_proc);
289: hr_utility.set_message_token('STEP', '20');
290: END IF;
291: --
292: hr_utility.set_location(l_proc, 30);
293: --

Line 292: hr_utility.set_location(l_proc, 30);

288: hr_utility.set_message_token('PROCEDURE', l_proc);
289: hr_utility.set_message_token('STEP', '20');
290: END IF;
291: --
292: hr_utility.set_location(l_proc, 30);
293: --
294: IF p_rec.sec_profile_assignment_id
295: <> per_asp_shd.g_old_rec.sec_profile_assignment_id
296: THEN

Line 303: hr_utility.set_location(l_proc, 40);

299: raise l_error;
300: --
301: END IF;
302: --
303: hr_utility.set_location(l_proc, 40);
304: --
305: IF p_rec.user_id
306: <> per_asp_shd.g_old_rec.user_id
307: THEN

Line 314: hr_utility.set_location(l_proc, 50);

310: raise l_error;
311: --
312: END IF;
313: --
314: hr_utility.set_location(l_proc, 50);
315: --
316: IF p_rec.security_group_id
317: <> per_asp_shd.g_old_rec.security_group_id
318: THEN

Line 325: hr_utility.set_location(l_proc, 55);

321: raise l_error;
322: --
323: END IF;
324: --
325: hr_utility.set_location(l_proc, 55);
326: --
327: IF p_rec.business_group_id
328: <> per_asp_shd.g_old_rec.business_group_id
329: THEN

Line 336: hr_utility.set_location(l_proc, 60);

332: raise l_error;
333: --
334: END IF;
335: --
336: hr_utility.set_location(l_proc, 60);
337: --
338: IF p_rec.security_profile_id
339: <> per_asp_shd.g_old_rec.security_profile_id
340: THEN

Line 347: hr_utility.set_location(l_proc, 70);

343: raise l_error;
344: --
345: END IF;
346: --
347: hr_utility.set_location(l_proc, 70);
348: --
349: IF p_rec.responsibility_id
350: <> per_asp_shd.g_old_rec.responsibility_id
351: THEN

Line 358: hr_utility.set_location(l_proc, 80);

354: raise l_error;
355: --
356: END IF;
357: --
358: hr_utility.set_location(l_proc, 80);
359: --
360: IF p_rec.responsibility_application_id
361: <> per_asp_shd.g_old_rec.responsibility_application_id
362: THEN

Line 369: hr_utility.set_location(l_proc, 90);

365: raise l_error;
366: --
367: END IF;
368: --
369: hr_utility.set_location(l_proc, 90);
370: --
371: EXCEPTION
372: WHEN l_error THEN
373: hr_api.argument_changed_error

Line 379: hr_utility.set_location(' Leaving:'||l_proc, 100);

375: ,p_argument => l_argument
376: );
377: WHEN OTHERS THEN
378: RAISE;
379: hr_utility.set_location(' Leaving:'||l_proc, 100);
380: END chk_non_updateable_args;
381: --
382: -- ----------------------------------------------------------------------------
383: -- |-< chk_assignment_dates >-------------------------------------------------|

Line 418: hr_utility.set_message

414: -- check that the start date is not null
415: --
416: IF p_start_date IS NULL THEN
417: --
418: hr_utility.set_message
419: (800
420: ,'PER_52528_ASP_START_DATE_NULL'
421: );
422: hr_utility.raise_error;

Line 422: hr_utility.raise_error;

418: hr_utility.set_message
419: (800
420: ,'PER_52528_ASP_START_DATE_NULL'
421: );
422: hr_utility.raise_error;
423: --
424: END IF;
425: --
426: -- check that the start date is not on or more than the end date

Line 430: hr_utility.set_message

426: -- check that the start date is not on or more than the end date
427: --
428: IF p_start_date > NVL(p_end_date, hr_general.END_OF_TIME) THEN
429: --
430: hr_utility.set_message
431: (800
432: ,'PER_52525_ASP_DATE_ERROR'
433: );
434: hr_utility.raise_error;

Line 434: hr_utility.raise_error;

430: hr_utility.set_message
431: (800
432: ,'PER_52525_ASP_DATE_ERROR'
433: );
434: hr_utility.raise_error;
435: --
436: END IF;
437: --
438: END chk_assignment_dates;

Line 522: hr_utility.set_message

518: CLOSE c_chk_invalid_dates;
519: --
520: -- record found - raise an exception
521: --
522: hr_utility.set_message
523: (800
524: ,'PER_52529_ASP_ASN_DATE_ERROR'
525: );
526: hr_utility.raise_error;

Line 526: hr_utility.raise_error;

522: hr_utility.set_message
523: (800
524: ,'PER_52529_ASP_ASN_DATE_ERROR'
525: );
526: hr_utility.raise_error;
527: END IF;
528: --
529: CLOSE c_chk_invalid_dates;
530: --

Line 592: hr_utility.set_message

588: ELSE
589: --
590: CLOSE c_exists_duplicate_assignment;
591: --
592: hr_utility.set_message
593: (800
594: ,'PER_52551_ASP_DUP_ASN_ERROR'
595: );
596: hr_utility.raise_error;

Line 596: hr_utility.raise_error;

592: hr_utility.set_message
593: (800
594: ,'PER_52551_ASP_DUP_ASN_ERROR'
595: );
596: hr_utility.raise_error;
597: --
598: END IF;
599: --
600: END chk_duplicate_assignments;

Line 661: hr_utility.set_message

657: IF p_start_date >= l_start_date AND p_start_date <= l_end_date THEN
658: --
659: -- The start date of the inserted/updated record is in error
660: --
661: hr_utility.set_message
662: (800
663: ,'PER_52526_ASP_START_DATE_ERROR'
664: );
665: hr_utility.raise_error;

Line 665: hr_utility.raise_error;

661: hr_utility.set_message
662: (800
663: ,'PER_52526_ASP_START_DATE_ERROR'
664: );
665: hr_utility.raise_error;
666: --
667: ELSIF p_end_date >= l_start_date AND p_end_date <= l_end_date THEN
668: --
669: -- The end date of the inserted/updated record is in error

Line 671: hr_utility.set_message

667: ELSIF p_end_date >= l_start_date AND p_end_date <= l_end_date THEN
668: --
669: -- The end date of the inserted/updated record is in error
670: --
671: hr_utility.set_message
672: (800
673: ,'PER_52527_ASP_END_DATE_ERROR'
674: );
675: hr_utility.raise_error;

Line 675: hr_utility.raise_error;

671: hr_utility.set_message
672: (800
673: ,'PER_52527_ASP_END_DATE_ERROR'
674: );
675: hr_utility.raise_error;
676: --
677: END IF;
678: END IF;
679: --

Line 781: hr_utility.set_message

777: ,p_security_group_id
778: )
779: THEN
780: --
781: hr_utility.set_message
782: (800
783: ,'PER_52524_ASP_ASN_NOT_EXIST'
784: );
785: hr_utility.raise_error;

Line 785: hr_utility.raise_error;

781: hr_utility.set_message
782: (800
783: ,'PER_52524_ASP_ASN_NOT_EXIST'
784: );
785: hr_utility.raise_error;
786: --
787: END IF;
788: --
789: END chk_assignment_exists;

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

870: --
871: l_proc varchar2(72) := g_package||'insert_validate';
872: --
873: Begin
874: hr_utility.set_location('Entering:'||l_proc, 5);
875: --
876: -- Call all supporting business operations
877: --
878: chk_sec_profile_assignment_id

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

955: -- to null... but does not look like it has
956: );
957: END IF;
958: --
959: hr_utility.set_location(' Leaving:'||l_proc, 10);
960: End insert_validate;
961: --
962: -- ----------------------------------------------------------------------------
963: -- |---------------------------< update_validate >----------------------------|

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

966: --
967: l_proc varchar2(72) := g_package||'update_validate';
968: --
969: Begin
970: hr_utility.set_location('Entering:'||l_proc, 5);
971: --
972: -- Call all supporting business operations
973: --
974: chk_non_updateable_args

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

1041: ,p_application_id => p_rec.responsibility_application_id
1042: ,p_security_group_id => p_rec.security_group_id
1043: );
1044: --
1045: hr_utility.set_location(' Leaving:'||l_proc, 10);
1046: End update_validate;
1047: --
1048: -- ----------------------------------------------------------------------------
1049: -- |-< Synchronize_Assignment_Dates >-----------------------------------------|