eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_IMPORT_INTERFACE_PKG dependencies on FND_FILE

Line 61: FND_FILE.put_line(FND_FILE.LOG, 'Batch ID : '||p_batch_id);

57: l_n_exists VARCHAR2(1);
58:
59: begin
60:
61: FND_FILE.put_line(FND_FILE.LOG, 'Batch ID : '||p_batch_id);
62: FND_FILE.put_line(FND_FILE.LOG, 'Purge Processed Rows : '||p_purge_rows);
63: FND_FILE.put_line(FND_FILE.LOG, 'Gather Statistics on Interface Tables : '||p_gather_stats);
64:
65:

Line 62: FND_FILE.put_line(FND_FILE.LOG, 'Purge Processed Rows : '||p_purge_rows);

58:
59: begin
60:
61: FND_FILE.put_line(FND_FILE.LOG, 'Batch ID : '||p_batch_id);
62: FND_FILE.put_line(FND_FILE.LOG, 'Purge Processed Rows : '||p_purge_rows);
63: FND_FILE.put_line(FND_FILE.LOG, 'Gather Statistics on Interface Tables : '||p_gather_stats);
64:
65:
66: x_return_status := 'S';

Line 63: FND_FILE.put_line(FND_FILE.LOG, 'Gather Statistics on Interface Tables : '||p_gather_stats);

59: begin
60:
61: FND_FILE.put_line(FND_FILE.LOG, 'Batch ID : '||p_batch_id);
62: FND_FILE.put_line(FND_FILE.LOG, 'Purge Processed Rows : '||p_purge_rows);
63: FND_FILE.put_line(FND_FILE.LOG, 'Gather Statistics on Interface Tables : '||p_gather_stats);
64:
65:
66: x_return_status := 'S';
67: x_verify_sites_data := 'S';

Line 256: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details.');

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.');
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:

Line 554: FND_FILE.put_line(FND_FILE.LOG, 'User does not have Create Site Privilege for creating sites. Please contact your Site/System Administrator' );

550: Where Batch_id = p_batch_id
551: and process_status = G_PS_IN_PROCESS
552: and transaction_type = G_TX_TYPE_CREATE;
553:
554: FND_FILE.put_line(FND_FILE.LOG, 'User does not have Create Site Privilege for creating sites. Please contact your Site/System Administrator' );
555: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks. ');
556:
557: END IF;
558:

Line 2137: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details. ');

2133: from table( p_processing_errors)
2134: );
2135:
2136: If ( sql%rowcount ) > 0 then
2137: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details. ');
2138: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks. ');
2139: end if;
2140:
2141:

Line 2275: FND_FILE.put_line(FND_FILE.LOG, 'Total No. of Sites Created : '||to_char(sql%rowcount));

2271:
2272: End;
2273:
2274: If ( sql%rowcount ) > 0 then
2275: FND_FILE.put_line(FND_FILE.LOG, 'Total No. of Sites Created : '||to_char(sql%rowcount));
2276: end if;
2277:
2278: Begin
2279:

Line 2325: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details. ');

2321: end;
2322:
2323: /*
2324: If ( sql%rowcount ) > 0 then
2325: FND_FILE.put_line(FND_FILE.LOG, 'Few records failed the validations. Please check the interface errors table for details. ');
2326: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: One or more rows errored due to validation checks. ');
2327: end if;
2328: */
2329:

Line 2391: FND_FILE.PUT_LINE(FND_FILE.LOG,'User has View Site access for Site : '||c_check_grants.site_id );

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:
2394: end if;
2395:

Line 2425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Site Author Role not Assigned to Site : '||c_check_grants.site_identification_number);

2421: x_return_status => l_return_status,
2422: x_errorcode => l_errorcode,
2423: x_grant_guid => l_grant_guid);
2424: IF l_return_status <> 'T' THEN
2425: FND_FILE.PUT_LINE(FND_FILE.LOG,'Site Author Role not Assigned to Site : '||c_check_grants.site_identification_number);
2426:
2427: END IF;
2428:
2429: l_view_priv := 'N';

Line 3463: FND_FILE.put_line(FND_FILE.LOG, 'Total No. of Sites Updated : '||to_char(sql%rowcount));

3459: and C.Process_status = G_PS_IN_PROCESS
3460: and C.Transaction_type = G_TX_TYPE_UPDATE );
3461:
3462: If ( sql%rowcount ) > 0 then
3463: FND_FILE.put_line(FND_FILE.LOG, 'Total No. of Sites Updated : '||to_char(sql%rowcount));
3464: end if;
3465:
3466:
3467: Update RRS_SITES_TL A