149: G_PKG_NAME := NVL(G_PKG_NAME,'EGO_ITEM_AML_PVT');
150: --
151: -- user values
152: --
153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;
150: --
151: -- user values
152: --
153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;
158: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
151: -- user values
152: --
153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;
158: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
159: G_SESSION_LANG := USERENV('LANG');
152: --
153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;
158: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
159: G_SESSION_LANG := USERENV('LANG');
160: BEGIN
153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;
158: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
159: G_SESSION_LANG := USERENV('LANG');
160: BEGIN
161: SELECT party_id, party_name
167: -- 3600938 sometimes user_id is not being retrieved
168: SELECT party_id, party_name, user_id
169: INTO G_PARTY_ID, G_PARTY_NAME, G_USER_ID
170: FROM ego_user_v
171: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
172: END;
173: --
174: -- error handler parameters
175: --