434: -- Store the technical message which will have been seeded
435: -- if this exception has been raised. This will be used to provide
436: -- the code.
437: --
438: hr_message.provide_error;
439: --
440: -- Now distinguish which error was raised.
441: --
442: IF (hr_message.last_message_name = 'OTA_13667_WEB_STATUS_NOT_SEEDE') THEN
438: hr_message.provide_error;
439: --
440: -- Now distinguish which error was raised.
441: --
442: IF (hr_message.last_message_name = 'OTA_13667_WEB_STATUS_NOT_SEEDE') THEN
443: --
444: -- Seed the user friendly message
445: --
446: fnd_message.set_name ('OTA','OTA_WEB_INCORRECT_CONF');
447: --
448: -- Raise the error for the main procedure exception handler
449: -- to handle
450: --
451: p_message_name := hr_message.last_message_name;
452: p_message_name := SUBSTR(SQLERRM, 1,300);
453: --
454: ELSIF (hr_message.last_message_name = 'HR_51396_WEB_PERSON_NOT_FND')
455: THEN
450: --
451: p_message_name := hr_message.last_message_name;
452: p_message_name := SUBSTR(SQLERRM, 1,300);
453: --
454: ELSIF (hr_message.last_message_name = 'HR_51396_WEB_PERSON_NOT_FND')
455: THEN
456: --
457: -- Seed the user friendly message
458: --
462: -- to handle
463: p_message_name := 'OTA_NO_DELEGATE_INFORMATION';
464: p_message_name := SUBSTR(SQLERRM, 1,300);
465: --
466: /* ELSIF (hr_message.last_message_name = 'OTA_13658_WF_ERR_GETTING_TYPE')
467: THEN
468: --
469: -- Seed the user friendly message
470: --
477: --
478: ELSE
479: -- Raise the error for the main procedure exception handler
480: -- to handle
481: p_message_name := hr_message.get_message_text;
482:
483: --
484: END IF;
485: --
487: --
488: -- Can't store a technical message, as we don't know what it is
489: -- and a message may not have been put on the stack
490: --
491: hr_message.provide_error;
492: --
493: -- Seed the user friendly message
494: --
495: fnd_message.set_name ('OTA','OTA_WEB_ERR_GETTING_INFO');
822: -- p_mode will be changed to indicate an error and,if it's a WF error
823: -- the mode will also indicate this.
824: -- Then the "Confirmation" page will be called from the main handler.
825: --
826: -- It is OK to use hr_message.provide_error as an application
827: -- error will have been raised which will have put an error onto
828: -- the stack
829: --
830: /* IF (hr_message.last_message_name = 'OTA_13668_WEB_NO_TRANMISSION')
826: -- It is OK to use hr_message.provide_error as an application
827: -- error will have been raised which will have put an error onto
828: -- the stack
829: --
830: /* IF (hr_message.last_message_name = 'OTA_13668_WEB_NO_TRANMISSION')
831: THEN
832: --
833: -- The WF may have already be transissioned, so change the mode.
834: l_mode := l_mode || 'BADWF';