341: EXCEPTION
342: WHEN OTHERS THEN
343: IF pn_mo_cache_utils.get_multi_org_flag = 'Y' THEN
344: raise_application_error(-20001,'Error: no data found in multi org table' || to_char(sqlcode));
345: app_exception.raise_exception;
346: ELSE -- non multi org
347: raise_application_error(-20001,'Error: no data found in profile_setup table'|| to_char(sqlcode));
348: app_exception.raise_exception;
349: END IF;
344: raise_application_error(-20001,'Error: no data found in multi org table' || to_char(sqlcode));
345: app_exception.raise_exception;
346: ELSE -- non multi org
347: raise_application_error(-20001,'Error: no data found in profile_setup table'|| to_char(sqlcode));
348: app_exception.raise_exception;
349: END IF;
350:
351: END retrieve_globals;
352:
492: EXCEPTION
493: WHEN OTHERS THEN
494: IF get_multi_org_flag = 'Y' THEN
495: raise_application_error(-20001,'Error: no data found in multi org table' || to_char(sqlcode));
496: app_exception.raise_exception;
497: ELSE -- non multi org
498: raise_application_error(-20001,'Error: no data found in profile_setup table' || to_char(sqlcode));
499: app_exception.raise_exception;
500: END IF;
495: raise_application_error(-20001,'Error: no data found in multi org table' || to_char(sqlcode));
496: app_exception.raise_exception;
497: ELSE -- non multi org
498: raise_application_error(-20001,'Error: no data found in profile_setup table' || to_char(sqlcode));
499: app_exception.raise_exception;
500: END IF;
501: END retrieve_org_id_specific;
502:
503: -------------------------------------------------------------------------------