60: PRAGMA AUTONOMOUS_TRANSACTION;
61:
62: BEGIN
63:
64: L_USER_ID := FND_GLOBAL.USER_ID();
65: L_RESP_ID := FND_GLOBAL.RESP_ID();
66: L_RESP_APPL_ID := FND_GLOBAL.RESP_APPL_ID();
67: L_SECURITY_GROUP_ID :=FND_GLOBAL.SECURITY_GROUP_ID();
68: L_NLS_DATE_FORMAT := FND_GLOBAL.NLS_DATE_FORMAT;
61:
62: BEGIN
63:
64: L_USER_ID := FND_GLOBAL.USER_ID();
65: L_RESP_ID := FND_GLOBAL.RESP_ID();
66: L_RESP_APPL_ID := FND_GLOBAL.RESP_APPL_ID();
67: L_SECURITY_GROUP_ID :=FND_GLOBAL.SECURITY_GROUP_ID();
68: L_NLS_DATE_FORMAT := FND_GLOBAL.NLS_DATE_FORMAT;
69: L_NLS_DATE_LANGUAGE := FND_GLOBAL.NLS_DATE_LANGUAGE;
62: BEGIN
63:
64: L_USER_ID := FND_GLOBAL.USER_ID();
65: L_RESP_ID := FND_GLOBAL.RESP_ID();
66: L_RESP_APPL_ID := FND_GLOBAL.RESP_APPL_ID();
67: L_SECURITY_GROUP_ID :=FND_GLOBAL.SECURITY_GROUP_ID();
68: L_NLS_DATE_FORMAT := FND_GLOBAL.NLS_DATE_FORMAT;
69: L_NLS_DATE_LANGUAGE := FND_GLOBAL.NLS_DATE_LANGUAGE;
70: L_NLS_LANGUAGE := FND_GLOBAL.NLS_LANGUAGE;
63:
64: L_USER_ID := FND_GLOBAL.USER_ID();
65: L_RESP_ID := FND_GLOBAL.RESP_ID();
66: L_RESP_APPL_ID := FND_GLOBAL.RESP_APPL_ID();
67: L_SECURITY_GROUP_ID :=FND_GLOBAL.SECURITY_GROUP_ID();
68: L_NLS_DATE_FORMAT := FND_GLOBAL.NLS_DATE_FORMAT;
69: L_NLS_DATE_LANGUAGE := FND_GLOBAL.NLS_DATE_LANGUAGE;
70: L_NLS_LANGUAGE := FND_GLOBAL.NLS_LANGUAGE;
71: L_NLS_NUMERIC_CHARACTERS := FND_GLOBAL.NLS_NUMERIC_CHARACTERS;
64: L_USER_ID := FND_GLOBAL.USER_ID();
65: L_RESP_ID := FND_GLOBAL.RESP_ID();
66: L_RESP_APPL_ID := FND_GLOBAL.RESP_APPL_ID();
67: L_SECURITY_GROUP_ID :=FND_GLOBAL.SECURITY_GROUP_ID();
68: L_NLS_DATE_FORMAT := FND_GLOBAL.NLS_DATE_FORMAT;
69: L_NLS_DATE_LANGUAGE := FND_GLOBAL.NLS_DATE_LANGUAGE;
70: L_NLS_LANGUAGE := FND_GLOBAL.NLS_LANGUAGE;
71: L_NLS_NUMERIC_CHARACTERS := FND_GLOBAL.NLS_NUMERIC_CHARACTERS;
72: L_NLS_SORT := FND_GLOBAL.NLS_SORT;
65: L_RESP_ID := FND_GLOBAL.RESP_ID();
66: L_RESP_APPL_ID := FND_GLOBAL.RESP_APPL_ID();
67: L_SECURITY_GROUP_ID :=FND_GLOBAL.SECURITY_GROUP_ID();
68: L_NLS_DATE_FORMAT := FND_GLOBAL.NLS_DATE_FORMAT;
69: L_NLS_DATE_LANGUAGE := FND_GLOBAL.NLS_DATE_LANGUAGE;
70: L_NLS_LANGUAGE := FND_GLOBAL.NLS_LANGUAGE;
71: L_NLS_NUMERIC_CHARACTERS := FND_GLOBAL.NLS_NUMERIC_CHARACTERS;
72: L_NLS_SORT := FND_GLOBAL.NLS_SORT;
73: L_NLS_TERRITORY := FND_GLOBAL.NLS_TERRITORY;
66: L_RESP_APPL_ID := FND_GLOBAL.RESP_APPL_ID();
67: L_SECURITY_GROUP_ID :=FND_GLOBAL.SECURITY_GROUP_ID();
68: L_NLS_DATE_FORMAT := FND_GLOBAL.NLS_DATE_FORMAT;
69: L_NLS_DATE_LANGUAGE := FND_GLOBAL.NLS_DATE_LANGUAGE;
70: L_NLS_LANGUAGE := FND_GLOBAL.NLS_LANGUAGE;
71: L_NLS_NUMERIC_CHARACTERS := FND_GLOBAL.NLS_NUMERIC_CHARACTERS;
72: L_NLS_SORT := FND_GLOBAL.NLS_SORT;
73: L_NLS_TERRITORY := FND_GLOBAL.NLS_TERRITORY;
74: L_CURRENT_LANG := USERENV('LANG');
67: L_SECURITY_GROUP_ID :=FND_GLOBAL.SECURITY_GROUP_ID();
68: L_NLS_DATE_FORMAT := FND_GLOBAL.NLS_DATE_FORMAT;
69: L_NLS_DATE_LANGUAGE := FND_GLOBAL.NLS_DATE_LANGUAGE;
70: L_NLS_LANGUAGE := FND_GLOBAL.NLS_LANGUAGE;
71: L_NLS_NUMERIC_CHARACTERS := FND_GLOBAL.NLS_NUMERIC_CHARACTERS;
72: L_NLS_SORT := FND_GLOBAL.NLS_SORT;
73: L_NLS_TERRITORY := FND_GLOBAL.NLS_TERRITORY;
74: L_CURRENT_LANG := USERENV('LANG');
75:
68: L_NLS_DATE_FORMAT := FND_GLOBAL.NLS_DATE_FORMAT;
69: L_NLS_DATE_LANGUAGE := FND_GLOBAL.NLS_DATE_LANGUAGE;
70: L_NLS_LANGUAGE := FND_GLOBAL.NLS_LANGUAGE;
71: L_NLS_NUMERIC_CHARACTERS := FND_GLOBAL.NLS_NUMERIC_CHARACTERS;
72: L_NLS_SORT := FND_GLOBAL.NLS_SORT;
73: L_NLS_TERRITORY := FND_GLOBAL.NLS_TERRITORY;
74: L_CURRENT_LANG := USERENV('LANG');
75:
76: --We will log the NLS Parameters in the EVENT Level.
69: L_NLS_DATE_LANGUAGE := FND_GLOBAL.NLS_DATE_LANGUAGE;
70: L_NLS_LANGUAGE := FND_GLOBAL.NLS_LANGUAGE;
71: L_NLS_NUMERIC_CHARACTERS := FND_GLOBAL.NLS_NUMERIC_CHARACTERS;
72: L_NLS_SORT := FND_GLOBAL.NLS_SORT;
73: L_NLS_TERRITORY := FND_GLOBAL.NLS_TERRITORY;
74: L_CURRENT_LANG := USERENV('LANG');
75:
76: --We will log the NLS Parameters in the EVENT Level.
77: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then