DBA Data[Home] [Help]

APPS.FND_TRACE dependencies on FND_GLOBAL

Line 46: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN

42: l_pl_str varchar2(200);
43:
44: BEGIN
45: -- Get the current identifier string
46: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN
47: IDENT_STRING_T:=upper(FND_GLOBAL.USER_NAME);
48: -- change - to _
49: IDENT_STRING_T:=translate( IDENT_STRING_T,'-','_');
50: -- remove special chars, ie all chars other than alphanumeric and _

Line 47: IDENT_STRING_T:=upper(FND_GLOBAL.USER_NAME);

43:
44: BEGIN
45: -- Get the current identifier string
46: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN
47: IDENT_STRING_T:=upper(FND_GLOBAL.USER_NAME);
48: -- change - to _
49: IDENT_STRING_T:=translate( IDENT_STRING_T,'-','_');
50: -- remove special chars, ie all chars other than alphanumeric and _
51: IDENT_STRING_T:=translate( IDENT_STRING_T,'x'||translate( IDENT_STRING_T,

Line 62: IF (FND_GLOBAL.CONC_REQUEST_ID > 0) then

58: -- IDENT_STRING_T:=substr(IDENT_STRING_T,1,instr(IDENT_STRING_T,'@')-1);
59: -- END IF;
60: -- Cap ident_string_g at 12 chars
61: IDENT_STRING_T:=substr(IDENT_STRING_T,1,12);
62: IF (FND_GLOBAL.CONC_REQUEST_ID > 0) then
63: IDENT_STRING_T:=IDENT_STRING_T||'_CR'||FND_GLOBAL.CONC_REQUEST_ID;
64: END IF;
65: ELSE
66: SELECT USER INTO DBUSER FROM DUAL;

Line 63: IDENT_STRING_T:=IDENT_STRING_T||'_CR'||FND_GLOBAL.CONC_REQUEST_ID;

59: -- END IF;
60: -- Cap ident_string_g at 12 chars
61: IDENT_STRING_T:=substr(IDENT_STRING_T,1,12);
62: IF (FND_GLOBAL.CONC_REQUEST_ID > 0) then
63: IDENT_STRING_T:=IDENT_STRING_T||'_CR'||FND_GLOBAL.CONC_REQUEST_ID;
64: END IF;
65: ELSE
66: SELECT USER INTO DBUSER FROM DUAL;
67: IDENT_STRING_T:=substr(DBUSER,1,12);

Line 124: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN

120: -- is set, then we override the default value.
121:
122: PURGE_DATA_L:=NVL(FND_PROFILE.VALUE('FND_PURGE_PROFILER_DATA'),'Y');
123:
124: IF FND_GLOBAL.USER_NAME IS NOT NULL THEN
125: PROF_REQID := FND_REQUEST.SUBMIT_REQUEST(application => 'FND',
126: program => 'FNDPMPRPT',
127: argument1 => PROF_RUNID,
128: argument2 => RELATED_RUNID,

Line 169: IF (FND_GLOBAL.LOGIN_ID > 0) then

165: FROM V$SESSION S
166: WHERE AUDSID=USERENV('SESSIONID');
167:
168:
169: IF (FND_GLOBAL.LOGIN_ID > 0) then
170: RELATED_RUNID:=FND_GLOBAL.LOGIN_ID;
171: ELSE
172: RELATED_RUNID:=SPID;
173: END IF;

Line 170: RELATED_RUNID:=FND_GLOBAL.LOGIN_ID;

166: WHERE AUDSID=USERENV('SESSIONID');
167:
168:
169: IF (FND_GLOBAL.LOGIN_ID > 0) then
170: RELATED_RUNID:=FND_GLOBAL.LOGIN_ID;
171: ELSE
172: RELATED_RUNID:=SPID;
173: END IF;
174: