258: --
259: hr_utility.set_location(' Leaving:'|| l_proc, 50);
260: --
261: exception
262: when app_exception.application_exception then
263: if hr_multi_message.exception_add
264: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'
265: ) then
266: hr_utility.set_location(' Leaving:'|| l_proc, 60);
322: --
323: hr_utility.set_location(' Leaving:'|| l_proc, 50);
324: --
325: exception
326: when app_exception.application_exception then
327: if hr_multi_message.exception_add
328: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'
329: ) then
330: hr_utility.set_location(' Leaving:'|| l_proc, 60);
393: --
394: hr_utility.set_location(' Leaving:'|| l_proc, 30);
395: --
396: exception
397: when app_exception.application_exception then
398: if hr_multi_message.exception_add
399: (p_associated_column1=>
400: 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_STATUS_TYPE_ID'
401: ) then