256: ProfileLoginId VARCHAR2(20);
257: ProfileMsgLevel VARCHAR2(20) := NULL;
258: BEGIN
259: /* Set the values to be used for who columns from profile options. */
260: /* Bug8909490 : Changed FND_PROFILE to FND_GLOBAL */
261: /* FND_PROFILE.get('USER_ID', ProfileUserId);
262: FND_PROFILE.get('CONC_LOGIN_ID', ProfileLoginId);
263: G_UserId := to_number(ProfileUserId);
264: G_LoginId := to_number(ProfileLoginId); */
257: ProfileMsgLevel VARCHAR2(20) := NULL;
258: BEGIN
259: /* Set the values to be used for who columns from profile options. */
260: /* Bug8909490 : Changed FND_PROFILE to FND_GLOBAL */
261: /* FND_PROFILE.get('USER_ID', ProfileUserId);
262: FND_PROFILE.get('CONC_LOGIN_ID', ProfileLoginId);
263: G_UserId := to_number(ProfileUserId);
264: G_LoginId := to_number(ProfileLoginId); */
265:
258: BEGIN
259: /* Set the values to be used for who columns from profile options. */
260: /* Bug8909490 : Changed FND_PROFILE to FND_GLOBAL */
261: /* FND_PROFILE.get('USER_ID', ProfileUserId);
262: FND_PROFILE.get('CONC_LOGIN_ID', ProfileLoginId);
263: G_UserId := to_number(ProfileUserId);
264: G_LoginId := to_number(ProfileLoginId); */
265:
266: G_UserId := FND_GLOBAL.user_id;
268:
269: G_ApplId := 101;
270:
271: /* Get message level from profile option and set local variable */
272: FND_PROFILE.get('RG_LOGFILE_DETAIL_LEVEL', ProfileMsgLevel);
273: IF (ProfileMsgLevel IS NOT NULL) THEN
274: G_MsgLevel := to_number(ProfileMsgLevel);
275: ELSE
276: /* Profile option not set. Set to default the message level */