1: PACKAGE body WF_SOA_CTX_PKG AS
2: /* $Header: WFSOACTXB.pls 120.0.12010000.9 2009/07/26 07:09:15 snellepa noship $ */
3:
4:
5: pAppsBaseLang fnd_languages.nls_language%type;
9: return varchar2
10: is
11: begin
12:
13: IF WF_SOA_CTX_PKG.pAppsBaseLang IS NULL THEN
14: SELECT language_code
15: INTO WF_SOA_CTX_PKG.pAppsBaseLang
16: FROM fnd_languages
17: WHERE Installed_flag = 'B';
11: begin
12:
13: IF WF_SOA_CTX_PKG.pAppsBaseLang IS NULL THEN
14: SELECT language_code
15: INTO WF_SOA_CTX_PKG.pAppsBaseLang
16: FROM fnd_languages
17: WHERE Installed_flag = 'B';
18: END IF;
19:
16: FROM fnd_languages
17: WHERE Installed_flag = 'B';
18: END IF;
19:
20: return WF_SOA_CTX_PKG.pAppsBaseLang;
21:
22: end;
23: /* private procedure to get User specific Language Details*/
24:
33: WHERE nls_language = pTemp
34: and Installed_flag in ('B','I');
35: exception
36: WHEN No_Data_found THEN
37: lang_code :=WF_SOA_CTX_PKG.getAppsBaseLang;
38: end;
39:
40:
41:
138: pStage:=2;
139: --Start LangCode
140: IF ( pLang IS NULL ) THEN
141: --No language specified get the details from profile, else default to US
142: WF_SOA_CTX_PKG.getUserLang( pUserID, pLangCode);
143: ELSE -- language is specifed
144: IF pIsLangCode=1 THEN -- and it has been specified as Code
145: SELECT language_code
146: INTO pLangCode
294: IF pStage=1 THEN
295: x_error_code:='INVALID_USER_NAME';
296: ELSIF pStage=2 THEN
297: x_error_code:='INVALID_LANGCODE';
298: WF_SOA_CTX_PKG.getUserLang( pUserID, pLangCode);
299: ELSIF pStage=3 THEN
300: x_error_code:='INVALID_RESP_APP_NAME';
301: ELSIF pStage=4 THEN
302: x_error_code:='INVALID_RESP_NAME';
335:
336:
337:
338:
339: END WF_SOA_CTX_PKG;