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

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

31: l_error exception;
32: l_argument varchar2(30);
33: --
34: Begin
35: hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: -- Only proceed with validation if a row exists for
38: -- the current record in the HR Schema
39: --

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

40: if not per_par_shd.api_updating
41: (p_participant_id => p_rec.participant_id
42: ,p_object_version_number => p_rec.object_version_number
43: ) then
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('STEP', '5');
47: end if;
48: --

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

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

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

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

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

45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('STEP', '5');
47: end if;
48: --
49: hr_utility.set_location(l_proc, 6);
50: --
51: if p_rec.business_group_id <> per_par_shd.g_old_rec.business_group_id then
52: l_argument := 'business_group_id';
53: raise l_error;

Line 58: hr_utility.set_location(l_proc, 7);

54: -- elsif p_rec.questionnaire_template_id <> per_par_shd.g_old_rec.questionnaire_template_id then
55: -- l_argument := 'questionnaire_template_id';
56: -- raise l_error;
57: elsif p_rec.participation_in_table <> per_par_shd.g_old_rec.participation_in_table then
58: hr_utility.set_location(l_proc, 7);
59: l_argument := 'participation_in_table';
60: raise l_error;
61: elsif p_rec.participation_in_column <> per_par_shd.g_old_rec.participation_in_column then
62: hr_utility.set_location(l_proc, 8);

Line 62: hr_utility.set_location(l_proc, 8);

58: hr_utility.set_location(l_proc, 7);
59: l_argument := 'participation_in_table';
60: raise l_error;
61: elsif p_rec.participation_in_column <> per_par_shd.g_old_rec.participation_in_column then
62: hr_utility.set_location(l_proc, 8);
63: l_argument := 'participation_in_column';
64: raise l_error;
65: elsif p_rec.participation_in_id <> per_par_shd.g_old_rec.participation_in_id then
66: hr_utility.set_location(l_proc, 9);

Line 66: hr_utility.set_location(l_proc, 9);

62: hr_utility.set_location(l_proc, 8);
63: l_argument := 'participation_in_column';
64: raise l_error;
65: elsif p_rec.participation_in_id <> per_par_shd.g_old_rec.participation_in_id then
66: hr_utility.set_location(l_proc, 9);
67: l_argument := 'participation_in_id';
68: raise l_error;
69: end if;
70: hr_utility.set_location(l_proc, 11);

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

66: hr_utility.set_location(l_proc, 9);
67: l_argument := 'participation_in_id';
68: raise l_error;
69: end if;
70: hr_utility.set_location(l_proc, 11);
71: --
72: exception
73: when l_error then
74: hr_api.argument_changed_error

Line 80: hr_utility.set_location(' Leaving:'||l_proc, 12);

76: ,p_argument => l_argument
77: ,p_base_table => per_par_shd.g_tab_nam);
78: when others then
79: raise;
80: hr_utility.set_location(' Leaving:'||l_proc, 12);
81: end chk_non_updateable_args;
82: --
83: -- ----------------------------------------------------------------------------
84: -- |------------------------< chk_update_allowed >----------------------------|

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

118: l_proc varchar2(72) := g_package || 'chk_update_allowed';
119: --
120: begin
121: --
122: hr_utility.set_location('Entering: '||l_proc,10);
123: --
124: -- Check that the participation status is not closed.
125: --
126: -- if (p_rec.participation_status = 'CLOSED' or

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

234: fnd_message.raise_error;
235: end if;
236: end if;
237: --
238: hr_utility.set_location('Leaving: '||l_proc,20);
239: end chk_update_allowed;
240: --
241: -- ----------------------------------------------------------------------------
242: -- |---------------------< chk_participation_type >---------------------------|

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

283: l_api_updating boolean;
284: --
285: begin
286: --
287: hr_utility.set_location('Entering: '||l_proc,10);
288: --
289: l_api_updating := per_par_shd.api_updating
290: (p_participant_id => p_participant_id
291: ,p_object_version_number => p_object_version_number

Line 294: hr_utility.set_location(l_proc,20);

290: (p_participant_id => p_participant_id
291: ,p_object_version_number => p_object_version_number
292: );
293: --
294: hr_utility.set_location(l_proc,20);
295: --
296: -- Check that update is allowed
297: --
298: if l_api_updating and (per_par_shd.g_old_rec.participation_type <> null) then

Line 299: hr_utility.set_message(801,'PER_52466_PAR_TYPE_VAL_EXISTS');

295: --
296: -- Check that update is allowed
297: --
298: if l_api_updating and (per_par_shd.g_old_rec.participation_type <> null) then
299: hr_utility.set_message(801,'PER_52466_PAR_TYPE_VAL_EXISTS');
300: hr_utility.raise_error;
301: else
302: if (p_participation_type <> null) and
303: (hr_api.not_exists_in_hr_lookups

Line 300: hr_utility.raise_error;

296: -- Check that update is allowed
297: --
298: if l_api_updating and (per_par_shd.g_old_rec.participation_type <> null) then
299: hr_utility.set_message(801,'PER_52466_PAR_TYPE_VAL_EXISTS');
300: hr_utility.raise_error;
301: else
302: if (p_participation_type <> null) and
303: (hr_api.not_exists_in_hr_lookups
304: (p_effective_date => p_effective_date

Line 309: hr_utility.set_message(800,'PER_52463_PAR_INVAL_PART_TYPE');

305: ,p_lookup_type => 'PARTICIPATION_TYPE'
306: ,p_lookup_code => p_participation_type
307: )) then
308: -- p_participation_type does not exist in lookup, thus error.
309: hr_utility.set_message(800,'PER_52463_PAR_INVAL_PART_TYPE');
310: hr_utility.raise_error;
311: end if;
312: end if;
313: --

Line 310: hr_utility.raise_error;

306: ,p_lookup_code => p_participation_type
307: )) then
308: -- p_participation_type does not exist in lookup, thus error.
309: hr_utility.set_message(800,'PER_52463_PAR_INVAL_PART_TYPE');
310: hr_utility.raise_error;
311: end if;
312: end if;
313: --
314: hr_utility.set_location('Leaving: '||l_proc,20);

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

310: hr_utility.raise_error;
311: end if;
312: end if;
313: --
314: hr_utility.set_location('Leaving: '||l_proc,20);
315: --
316: EXCEPTION
317: when app_exception.application_exception then
318: if hr_multi_message.exception_add

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

359: l_proc varchar2(72) := g_package || 'chk_participation_status';
360: --
361: begin
362: --
363: hr_utility.set_location('Entering: '||l_proc,10);
364: --
365: if (p_participation_status <> null) and
366: (hr_api.not_exists_in_hr_lookups
367: (p_effective_date => p_effective_date

Line 372: hr_utility.set_message(800,'PER_52464_PAR_INVAL_PAR_STATUS');

368: ,p_lookup_type => 'PARTICIPANT_ACCESS'
369: ,p_lookup_code => p_participation_status
370: )) then
371: -- p_participation_status does not exist in lookup, thus error
372: hr_utility.set_message(800,'PER_52464_PAR_INVAL_PAR_STATUS');
373: hr_utility.raise_error;
374: end if;
375: --
376: hr_utility.set_location('Leaving: '||l_proc,20);

Line 373: hr_utility.raise_error;

369: ,p_lookup_code => p_participation_status
370: )) then
371: -- p_participation_status does not exist in lookup, thus error
372: hr_utility.set_message(800,'PER_52464_PAR_INVAL_PAR_STATUS');
373: hr_utility.raise_error;
374: end if;
375: --
376: hr_utility.set_location('Leaving: '||l_proc,20);
377: --

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

372: hr_utility.set_message(800,'PER_52464_PAR_INVAL_PAR_STATUS');
373: hr_utility.raise_error;
374: end if;
375: --
376: hr_utility.set_location('Leaving: '||l_proc,20);
377: --
378: EXCEPTION
379: when app_exception.application_exception then
380: if hr_multi_message.exception_add

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

425: where table_name = upper(p_participation_in_table)
426: and owner = l_per_owner;
427:
428: begin
429: hr_utility.set_location('Entering:'|| l_proc, 1);
430: --
431: if (p_participation_in_table is NULL) then
432: hr_utility.set_message(801, 'HR_52064_PAR_TABLE_NULL');
433: hr_utility.raise_error;

Line 432: hr_utility.set_message(801, 'HR_52064_PAR_TABLE_NULL');

428: begin
429: hr_utility.set_location('Entering:'|| l_proc, 1);
430: --
431: if (p_participation_in_table is NULL) then
432: hr_utility.set_message(801, 'HR_52064_PAR_TABLE_NULL');
433: hr_utility.raise_error;
434: end if;
435: --
436: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 433: hr_utility.raise_error;

429: hr_utility.set_location('Entering:'|| l_proc, 1);
430: --
431: if (p_participation_in_table is NULL) then
432: hr_utility.set_message(801, 'HR_52064_PAR_TABLE_NULL');
433: hr_utility.raise_error;
434: end if;
435: --
436: hr_utility.set_location('Entering:'|| l_proc, 5);
437: --

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

432: hr_utility.set_message(801, 'HR_52064_PAR_TABLE_NULL');
433: hr_utility.raise_error;
434: end if;
435: --
436: hr_utility.set_location('Entering:'|| l_proc, 5);
437: --
438: open chk_table_exists;
439: fetch chk_table_exists into l_exists;
440: if chk_table_exists%notfound then

Line 442: hr_utility.set_message(801,'HR_52065_PAR_INVALID_TABLE');

438: open chk_table_exists;
439: fetch chk_table_exists into l_exists;
440: if chk_table_exists%notfound then
441: close chk_table_exists;
442: hr_utility.set_message(801,'HR_52065_PAR_INVALID_TABLE');
443: hr_utility.raise_error;
444: end if;
445: close chk_table_exists;
446: hr_utility.set_location(l_proc, 3);

Line 443: hr_utility.raise_error;

439: fetch chk_table_exists into l_exists;
440: if chk_table_exists%notfound then
441: close chk_table_exists;
442: hr_utility.set_message(801,'HR_52065_PAR_INVALID_TABLE');
443: hr_utility.raise_error;
444: end if;
445: close chk_table_exists;
446: hr_utility.set_location(l_proc, 3);
447: --

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

442: hr_utility.set_message(801,'HR_52065_PAR_INVALID_TABLE');
443: hr_utility.raise_error;
444: end if;
445: close chk_table_exists;
446: hr_utility.set_location(l_proc, 3);
447: --
448: hr_utility.set_location('Leaving: '|| l_proc, 10);
449: EXCEPTION
450: when app_exception.application_exception then

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

444: end if;
445: close chk_table_exists;
446: hr_utility.set_location(l_proc, 3);
447: --
448: hr_utility.set_location('Leaving: '|| l_proc, 10);
449: EXCEPTION
450: when app_exception.application_exception then
451: if hr_multi_message.exception_add
452: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_IN_TABLE'

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

508: and col.table_name = syn.table_name
509: and col.column_name = upper(p_participation_in_column);
510:
511: begin
512: hr_utility.set_location('Entering:'|| l_proc, 1);
513: --
514: if (p_participation_in_column is NULL) then
515: hr_utility.set_message(801, 'HR_52066_PAR_COLUMN_NULL');
516: hr_utility.raise_error;

Line 515: hr_utility.set_message(801, 'HR_52066_PAR_COLUMN_NULL');

511: begin
512: hr_utility.set_location('Entering:'|| l_proc, 1);
513: --
514: if (p_participation_in_column is NULL) then
515: hr_utility.set_message(801, 'HR_52066_PAR_COLUMN_NULL');
516: hr_utility.raise_error;
517: end if;
518: --
519: open chk_column_exists;

Line 516: hr_utility.raise_error;

512: hr_utility.set_location('Entering:'|| l_proc, 1);
513: --
514: if (p_participation_in_column is NULL) then
515: hr_utility.set_message(801, 'HR_52066_PAR_COLUMN_NULL');
516: hr_utility.raise_error;
517: end if;
518: --
519: open chk_column_exists;
520: fetch chk_column_exists into l_exists;

Line 523: hr_utility.set_message(801,'HR_52067_PAR_INVALID_COLUMN');

519: open chk_column_exists;
520: fetch chk_column_exists into l_exists;
521: if chk_column_exists%notfound then
522: close chk_column_exists;
523: hr_utility.set_message(801,'HR_52067_PAR_INVALID_COLUMN');
524: hr_utility.raise_error;
525: end if;
526: close chk_column_exists;
527: hr_utility.set_location(l_proc, 3);

Line 524: hr_utility.raise_error;

520: fetch chk_column_exists into l_exists;
521: if chk_column_exists%notfound then
522: close chk_column_exists;
523: hr_utility.set_message(801,'HR_52067_PAR_INVALID_COLUMN');
524: hr_utility.raise_error;
525: end if;
526: close chk_column_exists;
527: hr_utility.set_location(l_proc, 3);
528: --

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

523: hr_utility.set_message(801,'HR_52067_PAR_INVALID_COLUMN');
524: hr_utility.raise_error;
525: end if;
526: close chk_column_exists;
527: hr_utility.set_location(l_proc, 3);
528: --
529: hr_utility.set_location('Leaving: '|| l_proc, 10);
530:
531: EXCEPTION

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

525: end if;
526: close chk_column_exists;
527: hr_utility.set_location(l_proc, 3);
528: --
529: hr_utility.set_location('Leaving: '|| l_proc, 10);
530:
531: EXCEPTION
532: when app_exception.application_exception then
533: if hr_multi_message.exception_add

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

595: 'from {p_participation_in_table} par ' ||
596: 'where par.{participation_in_column} = :p_participation_in_id ' ;
597: */
598: --
599: hr_utility.set_location('Entering:'|| l_proc, 1);
600: -- check if the participant_in_id is set as it is a mandatory
601: -- column, if not then error
602: if (p_participation_in_id is NULL) then
603: hr_utility.set_message(801, 'HR_52068_PAR_COLUMN_ID_NULL');

Line 603: hr_utility.set_message(801, 'HR_52068_PAR_COLUMN_ID_NULL');

599: hr_utility.set_location('Entering:'|| l_proc, 1);
600: -- check if the participant_in_id is set as it is a mandatory
601: -- column, if not then error
602: if (p_participation_in_id is NULL) then
603: hr_utility.set_message(801, 'HR_52068_PAR_COLUMN_ID_NULL');
604: hr_utility.raise_error;
605: end if;
606: --
607: -- Check mandatory parameters have been set

Line 604: hr_utility.raise_error;

600: -- check if the participant_in_id is set as it is a mandatory
601: -- column, if not then error
602: if (p_participation_in_id is NULL) then
603: hr_utility.set_message(801, 'HR_52068_PAR_COLUMN_ID_NULL');
604: hr_utility.raise_error;
605: end if;
606: --
607: -- Check mandatory parameters have been set
608: --

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

618: ,p_argument => 'participation_in_column'
619: ,p_argument_value => p_participation_in_column
620: );
621: --
622: hr_utility.set_location(l_proc, 2);
623: --
624: --
625: -- Dynamic literal string replacement
626: --

Line 637: hr_Utility.Set_Location(substr(L_DYNAMIC_SQL, 1,50), 4);

633: l_dynamic_sql := Replace(l_dynamic_sql, '{p_participation_in_column}',
634: p_participation_in_column);
635: */
636: --
637: hr_Utility.Set_Location(substr(L_DYNAMIC_SQL, 1,50), 4);
638: hr_Utility.Set_Location(substr(L_DYNAMIC_SQL, 51), 4);
639:
640: -- Dynamic sql steps:
641: -- ==================

Line 638: hr_Utility.Set_Location(substr(L_DYNAMIC_SQL, 51), 4);

634: p_participation_in_column);
635: */
636: --
637: hr_Utility.Set_Location(substr(L_DYNAMIC_SQL, 1,50), 4);
638: hr_Utility.Set_Location(substr(L_DYNAMIC_SQL, 51), 4);
639:
640: -- Dynamic sql steps:
641: -- ==================
642: -- 1. Open dynamic sql cursor

Line 648: hr_Utility.Set_Location(l_proc, 6);

644: -- 3. Bind dynamic sql variables
645: -- 4. Define dynamic sql columns
646: -- 5. Execute and fetch dynamic sql
647: --
648: hr_Utility.Set_Location(l_proc, 6);
649: l_sql_cursor := dbms_sql.open_cursor; -- Step 1
650: --
651: hr_Utility.Set_Location(l_proc, 10);
652: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7); -- Step 2

Line 651: hr_Utility.Set_Location(l_proc, 10);

647: --
648: hr_Utility.Set_Location(l_proc, 6);
649: l_sql_cursor := dbms_sql.open_cursor; -- Step 1
650: --
651: hr_Utility.Set_Location(l_proc, 10);
652: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7); -- Step 2
653: --
654: hr_Utility.Set_Location(l_proc, 15);
655: dbms_sql.bind_variable(l_sql_cursor, -- Step 3

Line 654: hr_Utility.Set_Location(l_proc, 15);

650: --
651: hr_Utility.Set_Location(l_proc, 10);
652: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7); -- Step 2
653: --
654: hr_Utility.Set_Location(l_proc, 15);
655: dbms_sql.bind_variable(l_sql_cursor, -- Step 3
656: ':p_participation_in_id', p_participation_in_id);
657: --
658: hr_Utility.Set_Location(l_proc, 20);

Line 658: hr_Utility.Set_Location(l_proc, 20);

654: hr_Utility.Set_Location(l_proc, 15);
655: dbms_sql.bind_variable(l_sql_cursor, -- Step 3
656: ':p_participation_in_id', p_participation_in_id);
657: --
658: hr_Utility.Set_Location(l_proc, 20);
659: dbms_sql.define_column(l_sql_cursor, 1, p_business_group_id); -- Step 4
660: --
661: hr_Utility.Set_Location(l_proc, 30);
662: l_rows := dbms_sql.execute_and_fetch(l_sql_cursor, false); -- Step 5

Line 661: hr_Utility.Set_Location(l_proc, 30);

657: --
658: hr_Utility.Set_Location(l_proc, 20);
659: dbms_sql.define_column(l_sql_cursor, 1, p_business_group_id); -- Step 4
660: --
661: hr_Utility.Set_Location(l_proc, 30);
662: l_rows := dbms_sql.execute_and_fetch(l_sql_cursor, false); -- Step 5
663: If (l_rows = 0 ) then
664: -- if no rows are returned that means the id does not exist
665: -- hence error

Line 667: hr_Utility.set_Location(l_proc, 35);

663: If (l_rows = 0 ) then
664: -- if no rows are returned that means the id does not exist
665: -- hence error
666: dbms_sql.close_cursor(l_sql_cursor);
667: hr_Utility.set_Location(l_proc, 35);
668: hr_utility.set_message(801,'HR_52069_PAR_INVALID_COLUMN_ID');
669: hr_utility.raise_error;
670: Else
671: -- check if the business groups match

Line 668: hr_utility.set_message(801,'HR_52069_PAR_INVALID_COLUMN_ID');

664: -- if no rows are returned that means the id does not exist
665: -- hence error
666: dbms_sql.close_cursor(l_sql_cursor);
667: hr_Utility.set_Location(l_proc, 35);
668: hr_utility.set_message(801,'HR_52069_PAR_INVALID_COLUMN_ID');
669: hr_utility.raise_error;
670: Else
671: -- check if the business groups match
672: --

Line 669: hr_utility.raise_error;

665: -- hence error
666: dbms_sql.close_cursor(l_sql_cursor);
667: hr_Utility.set_Location(l_proc, 35);
668: hr_utility.set_message(801,'HR_52069_PAR_INVALID_COLUMN_ID');
669: hr_utility.raise_error;
670: Else
671: -- check if the business groups match
672: --
673: -- Get the column values and close the cursor

Line 675: hr_Utility.set_Location(l_proc, 40);

671: -- check if the business groups match
672: --
673: -- Get the column values and close the cursor
674: --
675: hr_Utility.set_Location(l_proc, 40);
676: dbms_sql.column_value(l_sql_cursor, 1, l_business_group_id);
677: dbms_sql.close_cursor(l_sql_cursor);
678:
679: -- bug 1980440 fix starts

Line 686: hr_utility.set_message(801,'HR_52070_PAR_COL_ID_DIFF_BG');

682:
683: if lv_cross_business_group <> 'Y' THEN
684:
685: if p_business_group_id <> l_business_group_id then
686: hr_utility.set_message(801,'HR_52070_PAR_COL_ID_DIFF_BG');
687: hr_utility.raise_error;
688: end if;
689:
690: end if;

Line 687: hr_utility.raise_error;

683: if lv_cross_business_group <> 'Y' THEN
684:
685: if p_business_group_id <> l_business_group_id then
686: hr_utility.set_message(801,'HR_52070_PAR_COL_ID_DIFF_BG');
687: hr_utility.raise_error;
688: end if;
689:
690: end if;
691:

Line 709: Hr_Utility.Set_Location(l_proc, 50);

705: raise;
706: end if;
707:
708: When Others Then
709: Hr_Utility.Set_Location(l_proc, 50);
710: If (dbms_sql.is_open(l_sql_cursor)) then
711: hr_utility.Set_Location(l_proc, 55);
712: dbms_sql.close_cursor(l_sql_cursor);
713: End If;

Line 711: hr_utility.Set_Location(l_proc, 55);

707:
708: When Others Then
709: Hr_Utility.Set_Location(l_proc, 50);
710: If (dbms_sql.is_open(l_sql_cursor)) then
711: hr_utility.Set_Location(l_proc, 55);
712: dbms_sql.close_cursor(l_sql_cursor);
713: End If;
714: Raise;
715: --

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

712: dbms_sql.close_cursor(l_sql_cursor);
713: End If;
714: Raise;
715: --
716: hr_utility.set_location(l_proc, 55);
717: --
718: hr_utility.set_location('Leaving: '|| l_proc, 60);
719:
720:

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

714: Raise;
715: --
716: hr_utility.set_location(l_proc, 55);
717: --
718: hr_utility.set_location('Leaving: '|| l_proc, 60);
719:
720:
721: end chk_participation_in_id;
722: --

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

842: and par.participation_in_id = p_participation_in_id
843: and par.person_id = p_person_id;
844: --
845: begin
846: hr_utility.set_location('Entering:'|| l_proc, 1);
847: --
848: if (p_person_id is NULL) then
849: hr_utility.set_message(801, 'HR_52075_PAR_PERSON_NULL');
850: hr_utility.raise_error;

Line 849: hr_utility.set_message(801, 'HR_52075_PAR_PERSON_NULL');

845: begin
846: hr_utility.set_location('Entering:'|| l_proc, 1);
847: --
848: if (p_person_id is NULL) then
849: hr_utility.set_message(801, 'HR_52075_PAR_PERSON_NULL');
850: hr_utility.raise_error;
851: end if;
852: --
853: -- Check mandatory parameters have been set

Line 850: hr_utility.raise_error;

846: hr_utility.set_location('Entering:'|| l_proc, 1);
847: --
848: if (p_person_id is NULL) then
849: hr_utility.set_message(801, 'HR_52075_PAR_PERSON_NULL');
850: hr_utility.raise_error;
851: end if;
852: --
853: -- Check mandatory parameters have been set
854: --

Line 888: hr_utility.set_location('Entering:'|| l_proc, 2);

884: ,p_argument_value => p_participation_in_id
885: );
886: --
887: --
888: hr_utility.set_location('Entering:'|| l_proc, 2);
889: --
890: --
891: -- bug 1980440 fix starts
892: lv_cross_business_group := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');

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

905: ) or
906: (NOT l_api_updating)
907: ) then
908: --
909: hr_utility.set_location(l_proc, 2);
910: --
911: if p_person_id is not null then
912: -- Bug 1980440 fix
913: -- if Cross Business Group is not enabled use csr_person_bg cursor

Line 920: hr_utility.set_message(801,'HR_52071_PAR_PERSON_NOT_EXIST');

916: open csr_person_bg;
917: fetch csr_person_bg into l_business_group_id;
918: if csr_person_bg%notfound then
919: close csr_person_bg;
920: hr_utility.set_message(801,'HR_52071_PAR_PERSON_NOT_EXIST');
921: hr_utility.raise_error;
922: end if;
923: close csr_person_bg;
924: else -- use the csr_cbg_person_bg cursor to get the Business Group Id

Line 921: hr_utility.raise_error;

917: fetch csr_person_bg into l_business_group_id;
918: if csr_person_bg%notfound then
919: close csr_person_bg;
920: hr_utility.set_message(801,'HR_52071_PAR_PERSON_NOT_EXIST');
921: hr_utility.raise_error;
922: end if;
923: close csr_person_bg;
924: else -- use the csr_cbg_person_bg cursor to get the Business Group Id
925: open csr_cbg_person_bg;

Line 929: hr_utility.set_message(801,'HR_52071_PAR_PERSON_NOT_EXIST');

925: open csr_cbg_person_bg;
926: fetch csr_cbg_person_bg into l_business_group_id;
927: if csr_cbg_person_bg%notfound then
928: close csr_cbg_person_bg;
929: hr_utility.set_message(801,'HR_52071_PAR_PERSON_NOT_EXIST');
930: hr_utility.raise_error;
931: end if;
932: close csr_cbg_person_bg;
933: end if;

Line 930: hr_utility.raise_error;

926: fetch csr_cbg_person_bg into l_business_group_id;
927: if csr_cbg_person_bg%notfound then
928: close csr_cbg_person_bg;
929: hr_utility.set_message(801,'HR_52071_PAR_PERSON_NOT_EXIST');
930: hr_utility.raise_error;
931: end if;
932: close csr_cbg_person_bg;
933: end if;
934: hr_utility.set_location(l_proc, 3);

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

930: hr_utility.raise_error;
931: end if;
932: close csr_cbg_person_bg;
933: end if;
934: hr_utility.set_location(l_proc, 3);
935:
936: -- bug 1980440 fix starts
937: -- do the validation if Cross Business Group profile is not enabled
938: if lv_cross_business_group <> 'Y' THEN

Line 941: hr_utility.set_message(801,'HR_52072_PAR_PERSON_DIFF_BG');

937: -- do the validation if Cross Business Group profile is not enabled
938: if lv_cross_business_group <> 'Y' THEN
939: -- check if business group match
940: if p_business_group_id <> l_business_group_id then
941: hr_utility.set_message(801,'HR_52072_PAR_PERSON_DIFF_BG');
942: hr_utility.raise_error;
943: end if;
944: end if;
945: -- bug 1980440 fix ends

Line 942: hr_utility.raise_error;

938: if lv_cross_business_group <> 'Y' THEN
939: -- check if business group match
940: if p_business_group_id <> l_business_group_id then
941: hr_utility.set_message(801,'HR_52072_PAR_PERSON_DIFF_BG');
942: hr_utility.raise_error;
943: end if;
944: end if;
945: -- bug 1980440 fix ends
946:

Line 947: hr_utility.set_location(l_proc, 4);

943: end if;
944: end if;
945: -- bug 1980440 fix ends
946:
947: hr_utility.set_location(l_proc, 4);
948: -- check if person is valid as of effective date
949: -- bug 1980440 fix starts
950: if lv_cross_business_group <> 'Y' THEN
951: open csr_person_valid_date;

Line 955: hr_utility.set_message(801,'HR_52073_PAR_PERSON_DATE_RANGE');

951: open csr_person_valid_date;
952: fetch csr_person_valid_date into l_exists;
953: if csr_person_valid_date%notfound then
954: close csr_person_valid_date;
955: hr_utility.set_message(801,'HR_52073_PAR_PERSON_DATE_RANGE');
956: hr_utility.raise_error;
957: end if;
958: close csr_person_valid_date;
959: else

Line 956: hr_utility.raise_error;

952: fetch csr_person_valid_date into l_exists;
953: if csr_person_valid_date%notfound then
954: close csr_person_valid_date;
955: hr_utility.set_message(801,'HR_52073_PAR_PERSON_DATE_RANGE');
956: hr_utility.raise_error;
957: end if;
958: close csr_person_valid_date;
959: else
960: open csr_cbg_person_valid_date;

Line 964: hr_utility.set_message(801,'HR_52073_PAR_PERSON_DATE_RANGE');

960: open csr_cbg_person_valid_date;
961: fetch csr_cbg_person_valid_date into l_exists;
962: if csr_cbg_person_valid_date%notfound then
963: close csr_cbg_person_valid_date;
964: hr_utility.set_message(801,'HR_52073_PAR_PERSON_DATE_RANGE');
965: hr_utility.raise_error;
966: end if;
967: close csr_cbg_person_valid_date;
968: end if;

Line 965: hr_utility.raise_error;

961: fetch csr_cbg_person_valid_date into l_exists;
962: if csr_cbg_person_valid_date%notfound then
963: close csr_cbg_person_valid_date;
964: hr_utility.set_message(801,'HR_52073_PAR_PERSON_DATE_RANGE');
965: hr_utility.raise_error;
966: end if;
967: close csr_cbg_person_valid_date;
968: end if;
969: -- bug 1980440 fix ends

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

967: close csr_cbg_person_valid_date;
968: end if;
969: -- bug 1980440 fix ends
970: -- check that the person id is unique
971: hr_utility.set_location(l_proc, 5);
972: open csr_person_id_unique;
973: fetch csr_person_id_unique into l_exists;
974: if csr_person_id_unique%found then
975: close csr_person_id_unique;

Line 976: hr_utility.set_message(801,'HR_52074_PAR_PERSON_NOT_UNIQUE');

972: open csr_person_id_unique;
973: fetch csr_person_id_unique into l_exists;
974: if csr_person_id_unique%found then
975: close csr_person_id_unique;
976: hr_utility.set_message(801,'HR_52074_PAR_PERSON_NOT_UNIQUE');
977: hr_utility.raise_error;
978: end if;
979: close csr_person_id_unique;
980: end if;

Line 977: hr_utility.raise_error;

973: fetch csr_person_id_unique into l_exists;
974: if csr_person_id_unique%found then
975: close csr_person_id_unique;
976: hr_utility.set_message(801,'HR_52074_PAR_PERSON_NOT_UNIQUE');
977: hr_utility.raise_error;
978: end if;
979: close csr_person_id_unique;
980: end if;
981: --

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

980: end if;
981: --
982: end if;
983: --
984: hr_utility.set_location(l_proc, 6);
985: --
986: hr_utility.set_location('Leaving: '|| l_proc, 10);
987: --
988: EXCEPTION

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

982: end if;
983: --
984: hr_utility.set_location(l_proc, 6);
985: --
986: hr_utility.set_location('Leaving: '|| l_proc, 10);
987: --
988: EXCEPTION
989: when app_exception.application_exception then
990: if hr_multi_message.exception_add

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

1026: --
1027: l_proc varchar2(72) := g_package||'chk_df';
1028: --
1029: begin
1030: hr_utility.set_location('Entering:'||l_proc, 10);
1031: --
1032: if ((p_rec.participant_id is not null) and (
1033: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1128: ,p_attribute21_value => p_rec.participant_usage_status
1129: );
1130: end if;
1131: --
1132: hr_utility.set_location(' Leaving:'||l_proc, 20);
1133: --
1134: end chk_df;
1135: --
1136: -- ----------------------------------------------------------------------------

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

1172: --
1173: BEGIN
1174:
1175:
1176: hr_utility.set_location('Entering:'|| l_proc, 10);
1177:
1178:
1179: --
1180: -- Only proceed with validation if :

Line 1199: hr_utility.set_location(l_proc, 20);

1195: IF p_participant_usage_status IS NOT null THEN
1196: --
1197: -- Check that oparticipant_usage_status is valid.
1198: --
1199: hr_utility.set_location(l_proc, 20);
1200: IF hr_api.not_exists_in_hr_lookups
1201: (p_effective_date => p_effective_date
1202: ,p_lookup_type => 'APPRAISAL_OFFLINE_STATUS'
1203: ,p_lookup_code => upper(p_participant_usage_status)

Line 1217: hr_utility.set_location('Leaving:'|| l_proc, 970);

1213: END IF;*/
1214:
1215: END IF;
1216:
1217: hr_utility.set_location('Leaving:'|| l_proc, 970);
1218: EXCEPTION
1219:
1220: WHEN app_exception.application_exception THEN
1221: IF hr_multi_message.exception_add

Line 1224: hr_utility.set_location(' Leaving:'|| l_proc, 980);

1220: WHEN app_exception.application_exception THEN
1221: IF hr_multi_message.exception_add
1222: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPANT_USAGE_STATUS')
1223: THEN
1224: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1225: RAISE;
1226: END IF;
1227: hr_utility.set_location(' Leaving:'|| l_proc, 990);
1228:

Line 1227: hr_utility.set_location(' Leaving:'|| l_proc, 990);

1223: THEN
1224: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1225: RAISE;
1226: END IF;
1227: hr_utility.set_location(' Leaving:'|| l_proc, 990);
1228:
1229: END chk_participant_usage_status;
1230: --
1231: -- ----------------------------------------------------------------------------

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

1236: --
1237: l_proc varchar2(72) := g_package||'insert_validate';
1238: --
1239: Begin
1240: hr_utility.set_location('Entering:'||l_proc, 5);
1241: --
1242: -- Call all supporting business operations
1243: --
1244: hr_api.validate_bus_grp_id(p_rec.business_group_id

Line 1249: hr_utility.set_location(l_proc, 1);

1245: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1246: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1247: hr_multi_message.end_validation_set;
1248: --
1249: hr_utility.set_location(l_proc, 1);
1250: --
1251: per_par_bus.chk_participation_in_table
1252: (p_participation_in_table => p_rec.participation_in_table
1253: );

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

1251: per_par_bus.chk_participation_in_table
1252: (p_participation_in_table => p_rec.participation_in_table
1253: );
1254: --
1255: hr_utility.set_location(l_proc, 2);
1256: --
1257: per_par_bus.chk_participation_in_column
1258: (p_participation_in_table => p_rec.participation_in_table
1259: ,p_participation_in_column => p_rec.participation_in_column

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

1258: (p_participation_in_table => p_rec.participation_in_table
1259: ,p_participation_in_column => p_rec.participation_in_column
1260: );
1261: --
1262: hr_utility.set_location(l_proc, 3);
1263: --
1264: per_par_bus.chk_participation_in_id
1265: (p_participation_in_table => p_rec.participation_in_table
1266: ,p_participation_in_column => p_rec.participation_in_column

Line 1271: hr_utility.set_location(l_proc, 4);

1267: ,p_participation_in_id => p_rec.participation_in_id
1268: ,p_business_group_id => p_rec.business_group_id
1269: );
1270: --
1271: hr_utility.set_location(l_proc, 4);
1272: --
1273: per_par_bus.chk_person_id
1274: (p_participant_id => p_rec.participant_id
1275: ,p_object_version_number => p_rec.object_version_number

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

1280: ,p_participation_in_id => p_rec.participation_in_id
1281: ,p_effective_date => p_effective_date
1282: );
1283: --
1284: hr_utility.set_location(l_proc, 5);
1285: --
1286: per_par_bus.chk_participation_status
1287: (p_participation_status => p_rec.participation_status
1288: ,p_effective_date => p_effective_date

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

1287: (p_participation_status => p_rec.participation_status
1288: ,p_effective_date => p_effective_date
1289: );
1290: --
1291: hr_utility.set_location(l_proc,6);
1292: --
1293: per_par_bus.chk_participation_type
1294: (p_participant_id => p_rec.participant_id
1295: ,p_object_version_number => p_rec.object_version_number

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

1296: ,p_participation_type => p_rec.participation_type
1297: ,p_effective_date => p_effective_date
1298: );
1299: --
1300: hr_utility.set_location(' Leaving:'||l_proc, 10);
1301: --
1302: per_par_bus.chk_participant_usage_status
1303: (p_participant_id => p_rec.participant_id
1304: ,p_object_version_number => p_rec.object_version_number

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

1320: --
1321: l_proc varchar2(72) := g_package||'update_validate';
1322: --
1323: Begin
1324: hr_utility.set_location('Entering:'||l_proc, 1);
1325: --
1326: -- Call all supporting business operations
1327: --
1328: --

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

1336: -- Rule Check non-updateable fields cannot be updated
1337: --
1338: chk_non_updateable_args(p_rec => p_rec);
1339: --
1340: hr_utility.set_location(l_proc, 2);
1341: --
1342: per_par_bus.chk_participation_status
1343: (p_participation_status => p_rec.participation_status
1344: ,p_effective_date => p_effective_date

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

1354: ,p_participation_type => p_rec.participation_type
1355: ,p_effective_date => p_effective_date
1356: );
1357: --
1358: hr_utility.set_location(l_proc,3);
1359: --
1360: per_par_bus.chk_person_id
1361: (p_participant_id => p_rec.participant_id
1362: ,p_object_version_number => p_rec.object_version_number

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

1367: ,p_participation_in_id => p_rec.participation_in_id
1368: ,p_effective_date => p_effective_date
1369: );
1370: --
1371: hr_utility.set_location(l_proc, 5);
1372: --
1373: hr_api.validate_bus_grp_id(p_rec.business_group_id
1374: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1375: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp

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

1375: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1376:
1377: hr_multi_message.end_validation_set;
1378: --
1379: hr_utility.set_location(' Leaving:'||l_proc, 10);
1380: --
1381: per_par_bus.chk_participant_usage_status
1382: (p_participant_id => p_rec.participant_id
1383: ,p_object_version_number => p_rec.object_version_number

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

1398: --
1399: l_proc varchar2(72) := g_package||'delete_validate';
1400: --
1401: Begin
1402: hr_utility.set_location('Entering:'||l_proc, 5);
1403: --
1404: -- Call all supporting business operations
1405: --
1406: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1402: hr_utility.set_location('Entering:'||l_proc, 5);
1403: --
1404: -- Call all supporting business operations
1405: --
1406: hr_utility.set_location(' Leaving:'||l_proc, 10);
1407: End delete_validate;
1408: --
1409: -- ----------------------------------------------------------------------------
1410: -- |-----------------------< return_legislation_code >-------------------------|

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

1425: l_proc varchar2(72) := g_package||'return_legislation_code';
1426: l_legislation_code varchar2(150);
1427: --
1428: Begin
1429: hr_utility.set_location('Entering:'||l_proc, 5);
1430: --
1431: -- Ensure that all the mandatory parameters are not null
1432: --
1433: hr_api.mandatory_arg_error (p_api_name => l_proc,

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

1440: -- call to this function. Just return the value in the global
1441: -- variable.
1442: --
1443: l_legislation_code := g_legislation_code;
1444: hr_utility.set_location(l_proc, 10);
1445: else
1446: --
1447: -- The ID is different to the last call to this function
1448: -- or this is the first call to this function.

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

1453: close csr_leg_code;
1454: --
1455: -- The primary key is invalid therefore we must error out
1456: --
1457: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1458: hr_utility.raise_error;
1459: end if;
1460: --
1461: close csr_leg_code;

Line 1458: hr_utility.raise_error;

1454: --
1455: -- The primary key is invalid therefore we must error out
1456: --
1457: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1458: hr_utility.raise_error;
1459: end if;
1460: --
1461: close csr_leg_code;
1462: g_participant_id := p_participant_id;

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

1461: close csr_leg_code;
1462: g_participant_id := p_participant_id;
1463: g_legislation_code := l_legislation_code;
1464: end if;
1465: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1466:
1467: return l_legislation_code;
1468: --
1469: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 1469: hr_utility.set_location(' Leaving:'||l_proc, 30);

1465: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1466:
1467: return l_legislation_code;
1468: --
1469: hr_utility.set_location(' Leaving:'||l_proc, 30);
1470: --
1471: End return_legislation_code;
1472: --
1473: end per_par_bus;