APPS.RRS_IMPORT_INTERFACE_PKG dependencies on FND_API

Line 253: IF ( RETCODE = FND_API.G_RET_STS_SUCCESS ) THEN

249: ,p_data_set_id => l_data_set_id
250: ,p_purge_successful_lines => p_purge_rows
251: );
252:
253: IF ( RETCODE = FND_API.G_RET_STS_SUCCESS ) THEN
254: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS', 'Success: All the rows processed successfully.');
255: ELSIF ( RETCODE = G_RETCODE_SUCCESS_WITH_WARNING ) THEN
256: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details.');
257: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks.');

Line 258: ELSIF ( RETCODE = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

254: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('SUCCESS', 'Success: All the rows processed successfully.');
255: ELSIF ( RETCODE = G_RETCODE_SUCCESS_WITH_WARNING ) THEN
256: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details.');
257: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks.');
258: ELSIF ( RETCODE = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
259: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Error: Unexpected Error happened while processing the Interface rows in this Batch.');
260:
261: END IF;
262:

Line 2389: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => c_check_grants.site_id, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

2385:
2386:
2387: For c_check_grants in c_new_sites(p_batch_id) Loop
2388:
2389: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => c_check_grants.site_id, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
2390:
2391: FND_FILE.PUT_LINE(FND_FILE.LOG,'User has View Site access for Site : '||c_check_grants.site_id );
2392: l_view_priv := 'Y';
2393:

Line 2398: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

2394: end if;
2395:
2396: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_EDIT_SITE',
2397: p_object_name => 'RRS_SITE', p_object_key => c_check_grants.site_id,
2398: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
2399:
2400: l_edit_priv := 'Y';
2401:
2402:

Line 3169: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => site_data.site_id_intf, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

3165: /* RBAC 2 validations start */
3166: if l_security_enabled = 'Y' then
3167:
3168:
3169: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => site_data.site_id_intf, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
3170:
3171: null;
3172: else
3173: l_row_status := 'E';

Line 3193: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

3189: end if;
3190:
3191: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_EDIT_SITE',
3192: p_object_name => 'RRS_SITE', p_object_key => site_data.site_id_intf,
3193: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
3194:
3195: null;
3196: else
3197: l_row_status := 'E';