1353: END IF;
1354: CLOSE c_get_utl_file_dir;
1355: END IF; -- error_handler.get_debug.
1356:
1357: -- the values are chosen from the FND_GLOBALS
1358: G_USER_ID := FND_GLOBAL.user_id ;
1359: G_LOGIN_ID := FND_GLOBAL.login_id ;
1360: G_PROG_APPID := FND_GLOBAL.prog_appl_id ;
1361: G_PROG_ID := FND_GLOBAL.conc_program_id ;
1354: CLOSE c_get_utl_file_dir;
1355: END IF; -- error_handler.get_debug.
1356:
1357: -- the values are chosen from the FND_GLOBALS
1358: G_USER_ID := FND_GLOBAL.user_id ;
1359: G_LOGIN_ID := FND_GLOBAL.login_id ;
1360: G_PROG_APPID := FND_GLOBAL.prog_appl_id ;
1361: G_PROG_ID := FND_GLOBAL.conc_program_id ;
1362: G_REQUEST_ID := FND_GLOBAL.conc_request_id ;
1355: END IF; -- error_handler.get_debug.
1356:
1357: -- the values are chosen from the FND_GLOBALS
1358: G_USER_ID := FND_GLOBAL.user_id ;
1359: G_LOGIN_ID := FND_GLOBAL.login_id ;
1360: G_PROG_APPID := FND_GLOBAL.prog_appl_id ;
1361: G_PROG_ID := FND_GLOBAL.conc_program_id ;
1362: G_REQUEST_ID := FND_GLOBAL.conc_request_id ;
1363:
1356:
1357: -- the values are chosen from the FND_GLOBALS
1358: G_USER_ID := FND_GLOBAL.user_id ;
1359: G_LOGIN_ID := FND_GLOBAL.login_id ;
1360: G_PROG_APPID := FND_GLOBAL.prog_appl_id ;
1361: G_PROG_ID := FND_GLOBAL.conc_program_id ;
1362: G_REQUEST_ID := FND_GLOBAL.conc_request_id ;
1363:
1364: -- check whether the logged in user is a valid user
1357: -- the values are chosen from the FND_GLOBALS
1358: G_USER_ID := FND_GLOBAL.user_id ;
1359: G_LOGIN_ID := FND_GLOBAL.login_id ;
1360: G_PROG_APPID := FND_GLOBAL.prog_appl_id ;
1361: G_PROG_ID := FND_GLOBAL.conc_program_id ;
1362: G_REQUEST_ID := FND_GLOBAL.conc_request_id ;
1363:
1364: -- check whether the logged in user is a valid user
1365: OPEN c_user_party_id(cp_user_id => G_USER_ID);
1358: G_USER_ID := FND_GLOBAL.user_id ;
1359: G_LOGIN_ID := FND_GLOBAL.login_id ;
1360: G_PROG_APPID := FND_GLOBAL.prog_appl_id ;
1361: G_PROG_ID := FND_GLOBAL.conc_program_id ;
1362: G_REQUEST_ID := FND_GLOBAL.conc_request_id ;
1363:
1364: -- check whether the logged in user is a valid user
1365: OPEN c_user_party_id(cp_user_id => G_USER_ID);
1366: FETCH c_user_party_id INTO l_login_party_id, l_login_party_name;