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
319: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_TYPE'
320: ) then
321: raise;
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
381: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_STATUS'
382: ) then
383: raise;
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'
453: ) then
454: raise;
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
534: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_IN_COLUMN'
535: ) then
536: raise;
697: -- and close down if necessary.
698: --
699: Exception
700:
701: when app_exception.application_exception then
702: if hr_multi_message.exception_add
703: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPATION_IN_ID'
704: ) then
705: raise;
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
991: (p_associated_column1 => 'PER_PARTICIPANTS.PERSON_ID'
992: ) then
993: raise;
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
1222: (p_associated_column1 => 'PER_PARTICIPANTS.PARTICIPANT_USAGE_STATUS')
1223: THEN
1224: hr_utility.set_location(' Leaving:'|| l_proc, 980);