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: FND_PROFILE.get('USER_ID', ProfileUserId);
261: FND_PROFILE.get('CONC_LOGIN_ID', ProfileLoginId);
262: G_UserId := to_number(ProfileUserId);
263: G_LoginId := to_number(ProfileLoginId);
264: G_ApplId := 101;
257: ProfileMsgLevel VARCHAR2(20) := NULL;
258: BEGIN
259: /* Set the values to be used for who columns from profile options. */
260: FND_PROFILE.get('USER_ID', ProfileUserId);
261: FND_PROFILE.get('CONC_LOGIN_ID', ProfileLoginId);
262: G_UserId := to_number(ProfileUserId);
263: G_LoginId := to_number(ProfileLoginId);
264: G_ApplId := 101;
265:
263: G_LoginId := to_number(ProfileLoginId);
264: G_ApplId := 101;
265:
266: /* Get message level from profile option and set local variable */
267: FND_PROFILE.get('RG_LOGFILE_DETAIL_LEVEL', ProfileMsgLevel);
268: IF (ProfileMsgLevel IS NOT NULL) THEN
269: G_MsgLevel := to_number(ProfileMsgLevel);
270: ELSE
271: /* Profile option not set. Set to default the message level */