[Home] [Help]
312: -- ensure HR is fully installed, else raise error
313: --
314: IF NOT Get_Installation_Status (
315: p_application_id => g_per_application_id) = 'I' THEN
316: fnd_message.set_name('PER', 'HR_7079_HR_NOT_INSTALLED');
317: RAISE g_fatal_error;
318: ELSE
319: NULL;
320: END IF;
323: --
324: -- ensure OTA is fully installed, else raise error
325: --
326: IF NOT Get_Installation_Status (p_application_id => 810) = 'I' THEN
327: fnd_message.set_name('OTA', 'OTA_13629_WEB_OTA_NOT_INSTALL');
328: RAISE g_fatal_error;
329: ELSE
330: NULL;
331: END IF;
335: --
336: -- ensure BEN is fully installed, else raise error
337: --
338: IF NOT Get_Installation_Status (p_application_id => 805) = 'I' THEN
339: fnd_message.set_name('BEN', 'BEN_CHANGE_ME');
340: RAISE g_fatal_error;
341: ELSE
342: NULL;
343: END IF;
385:
386: -- the WF_SESSION cookie does not exist. a serious error
387: -- has ocurred which must be reported
388: --
389: fnd_message.set_name('PER','HR_51393_WEB_COOKIE_ERROR');
390: RAISE g_fatal_error;
391: END IF;
392: ELSE
393:
418: EXCEPTION
419: -- too many rows will be returned if the csr_iwu returns more than
420: -- one person id for the web user.
421: WHEN TOO_MANY_ROWS then
422: fnd_message.set_name('PER','HR_51776_WEB_TOO_MANY_USERS');
423: RAISE;
424: WHEN g_fatal_error THEN
425: -- messages set, just re-raise
426: RAISE;
425: -- messages set, just re-raise
426: RAISE;
427: WHEN OTHERS THEN
428: -- can't find this message name so uses the given value instead
429: fnd_message.set_name('PER', sqlerrm|| ' '||sqlcode);
430: RAISE;
431: END validate_session;
432: -- ----------------------------------------------------------------------------
433: -- |--< get_language_code >---------------------------------------------------|