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.HR_SECURITY_INTERNAL dependencies on FND_FILE

Line 3049: fnd_file.put_line(FND_FILE.log, SUBSTR(l_msg, 1, 70));

3045:
3046: IF g_dbg_type = g_PIPE OR g_debug THEN
3047: hr_utility.trace(SUBSTR(l_msg, 1, 70));
3048: ELSIF g_dbg_type = g_FND_LOG THEN
3049: fnd_file.put_line(FND_FILE.log, SUBSTR(l_msg, 1, 70));
3050: END IF;
3051:
3052: l_msg := SUBSTR(l_msg, 71);
3053:

Line 3083: fnd_file.put_line(FND_FILE.log, SUBSTR(l_msg, 1, 70)

3079:
3080: IF g_dbg_type = g_PIPE OR g_debug THEN
3081: hr_utility.set_location(SUBSTR(l_msg, 1, 70), p_location);
3082: ELSIF g_dbg_type = g_FND_LOG THEN
3083: fnd_file.put_line(FND_FILE.log, SUBSTR(l_msg, 1, 70)
3084: ||', '||to_char(p_location));
3085: END IF;
3086:
3087: l_msg := SUBSTR(l_msg, 71);

Line 9423: fnd_file.put_line(fnd_file.log,'==========================================');

9419: IS
9420: --
9421: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.POPULATE_ASG_PERF_TABLE';
9422: begin
9423: fnd_file.put_line(fnd_file.log,'==========================================');
9424: fnd_file.put_line(fnd_file.log,' Synchronize Security Performance Tables ');
9425: fnd_file.put_line(fnd_file.log,'==========================================');
9426: fnd_file.put_line(fnd_file.log,'----------');
9427: fnd_file.put_line(fnd_file.log,'Parameters');

Line 9424: fnd_file.put_line(fnd_file.log,' Synchronize Security Performance Tables ');

9420: --
9421: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.POPULATE_ASG_PERF_TABLE';
9422: begin
9423: fnd_file.put_line(fnd_file.log,'==========================================');
9424: fnd_file.put_line(fnd_file.log,' Synchronize Security Performance Tables ');
9425: fnd_file.put_line(fnd_file.log,'==========================================');
9426: fnd_file.put_line(fnd_file.log,'----------');
9427: fnd_file.put_line(fnd_file.log,'Parameters');
9428: fnd_file.put_line(fnd_file.log,'----------');

Line 9425: fnd_file.put_line(fnd_file.log,'==========================================');

9421: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.POPULATE_ASG_PERF_TABLE';
9422: begin
9423: fnd_file.put_line(fnd_file.log,'==========================================');
9424: fnd_file.put_line(fnd_file.log,' Synchronize Security Performance Tables ');
9425: fnd_file.put_line(fnd_file.log,'==========================================');
9426: fnd_file.put_line(fnd_file.log,'----------');
9427: fnd_file.put_line(fnd_file.log,'Parameters');
9428: fnd_file.put_line(fnd_file.log,'----------');
9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);

Line 9426: fnd_file.put_line(fnd_file.log,'----------');

9422: begin
9423: fnd_file.put_line(fnd_file.log,'==========================================');
9424: fnd_file.put_line(fnd_file.log,' Synchronize Security Performance Tables ');
9425: fnd_file.put_line(fnd_file.log,'==========================================');
9426: fnd_file.put_line(fnd_file.log,'----------');
9427: fnd_file.put_line(fnd_file.log,'Parameters');
9428: fnd_file.put_line(fnd_file.log,'----------');
9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);
9430: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 9427: fnd_file.put_line(fnd_file.log,'Parameters');

9423: fnd_file.put_line(fnd_file.log,'==========================================');
9424: fnd_file.put_line(fnd_file.log,' Synchronize Security Performance Tables ');
9425: fnd_file.put_line(fnd_file.log,'==========================================');
9426: fnd_file.put_line(fnd_file.log,'----------');
9427: fnd_file.put_line(fnd_file.log,'Parameters');
9428: fnd_file.put_line(fnd_file.log,'----------');
9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);
9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);

Line 9428: fnd_file.put_line(fnd_file.log,'----------');

9424: fnd_file.put_line(fnd_file.log,' Synchronize Security Performance Tables ');
9425: fnd_file.put_line(fnd_file.log,'==========================================');
9426: fnd_file.put_line(fnd_file.log,'----------');
9427: fnd_file.put_line(fnd_file.log,'Parameters');
9428: fnd_file.put_line(fnd_file.log,'----------');
9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);
9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then

Line 9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);

9425: fnd_file.put_line(fnd_file.log,'==========================================');
9426: fnd_file.put_line(fnd_file.log,'----------');
9427: fnd_file.put_line(fnd_file.log,'Parameters');
9428: fnd_file.put_line(fnd_file.log,'----------');
9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);
9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;

Line 9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');

9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9438: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,
9439: SUPERVISOR_ASSIGNMENT_ID,BUSINESS_GROUP_ID)

Line 9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');

9440: SELECT ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9441: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,SUPERVISOR_ASSIGNMENT_ID,
9442: BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F;
9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);
9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');
9445: end if;
9446: hr_utility.set_location('Leaving:'|| l_proc, 90);
9447: exception
9448: when others then

Line 9449: fnd_file.put_line(fnd_file.log,'Error Occured');

9445: end if;
9446: hr_utility.set_location('Leaving:'|| l_proc, 90);
9447: exception
9448: when others then
9449: fnd_file.put_line(fnd_file.log,'Error Occured');
9450: fnd_file.put_line(fnd_file.log,'Error: '|| SQLERRM);
9451: hr_utility.set_location('Error Occured In:'|| l_proc, 80);
9452: hr_utility.set_location('Error:'|| SQLERRM, 85);
9453: retcode := 2;

Line 9450: fnd_file.put_line(fnd_file.log,'Error: '|| SQLERRM);

9446: hr_utility.set_location('Leaving:'|| l_proc, 90);
9447: exception
9448: when others then
9449: fnd_file.put_line(fnd_file.log,'Error Occured');
9450: fnd_file.put_line(fnd_file.log,'Error: '|| SQLERRM);
9451: hr_utility.set_location('Error Occured In:'|| l_proc, 80);
9452: hr_utility.set_location('Error:'|| SQLERRM, 85);
9453: retcode := 2;
9454: errbuf := errbuf||SQLERRM;