76: then RAISE UTL_FILE.invalid_filehandle;
77: END IF;
78:
79: /* Get the DIR set in the profile to local variable */
80: fnd_profile.get (c_data_exchange_dir, l_location);
81:
82: IF l_location IS NULL
83: THEN
84: -- error : I/O directory not defined
366: X_ATTRIBUTE15 => null,
367: X_MEANING => p_lookup_code||' '||p_meaning,
368: X_DESCRIPTION => p_description,
369: X_CREATION_DATE => SYSDATE,
370: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
371: X_LAST_UPDATE_DATE => SYSDATE,
372: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
373: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
374:
368: X_DESCRIPTION => p_description,
369: X_CREATION_DATE => SYSDATE,
370: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
371: X_LAST_UPDATE_DATE => SYSDATE,
372: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
373: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
374:
375: );
376:
369: X_CREATION_DATE => SYSDATE,
370: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
371: X_LAST_UPDATE_DATE => SYSDATE,
372: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
373: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
374:
375: );
376:
377: end INSERT_ROW;
414: X_ATTRIBUTE15 => NULL,
415: X_MEANING => p_lookup_code||' '||p_meaning,
416: X_DESCRIPTION => null,
417: X_LAST_UPDATE_DATE => SYSDATE,
418: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
419: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
420:
421: end UPDATE_ROW;
422:
415: X_MEANING => p_lookup_code||' '||p_meaning,
416: X_DESCRIPTION => null,
417: X_LAST_UPDATE_DATE => SYSDATE,
418: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
419: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
420:
421: end UPDATE_ROW;
422:
423: /*