53:
54: BEGIN
55: g_bg_id := p_business_group_id;
56: l_file_name := p_file_name;
57: fnd_profile.get (c_data_exchange_dir, l_location);
58: IF l_location IS NULL
59: THEN
60: -- error : I/O directory not defined
61: RAISE e_fatal_error;
340: X_ATTRIBUTE15 => null,
341: X_MEANING => p_meaning,
342: X_DESCRIPTION => p_description,
343: X_CREATION_DATE => SYSDATE,
344: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
345: X_LAST_UPDATE_DATE => SYSDATE,
346: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
347: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
348:
342: X_DESCRIPTION => p_description,
343: X_CREATION_DATE => SYSDATE,
344: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
345: X_LAST_UPDATE_DATE => SYSDATE,
346: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
347: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
348:
349: hr_utility.set_location ( ' insert row ', 30);
350:
343: X_CREATION_DATE => SYSDATE,
344: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
345: X_LAST_UPDATE_DATE => SYSDATE,
346: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
347: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
348:
349: hr_utility.set_location ( ' insert row ', 30);
350:
351: end insert_row;
391: X_ATTRIBUTE15 => NULL,
392: X_MEANING => p_meaning,
393: X_DESCRIPTION => p_description,
394: X_LAST_UPDATE_DATE => SYSDATE,
395: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
396: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
397:
398: hr_utility.set_location ( ' update row ', 30);
399: end update_row;
392: X_MEANING => p_meaning,
393: X_DESCRIPTION => p_description,
394: X_LAST_UPDATE_DATE => SYSDATE,
395: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
396: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
397:
398: hr_utility.set_location ( ' update row ', 30);
399: end update_row;
400: