APPS.JTF_RS_SKILLS_REPORT_PUB dependencies on FND_FILE

Line 63: fnd_file.new_line(fnd_file.log,1);

59: open c_res_mgr_name (l_resource_id);
60: fetch c_res_mgr_name into l_res_mgr_name;
61: close c_res_mgr_name;
62:
63: fnd_file.new_line(fnd_file.log,1);
64: fnd_file.put_line(fnd_file.log,'Skills Report of HR Hierachy, for a Resource');
65: fnd_file.put_line(fnd_file.log,'--------------------------------------------');
66: fnd_file.new_line(fnd_file.log,1);
67: fnd_file.put_line(fnd_file.log,'Manager : '||l_res_mgr_name);

Line 64: fnd_file.put_line(fnd_file.log,'Skills Report of HR Hierachy, for a Resource');

60: fetch c_res_mgr_name into l_res_mgr_name;
61: close c_res_mgr_name;
62:
63: fnd_file.new_line(fnd_file.log,1);
64: fnd_file.put_line(fnd_file.log,'Skills Report of HR Hierachy, for a Resource');
65: fnd_file.put_line(fnd_file.log,'--------------------------------------------');
66: fnd_file.new_line(fnd_file.log,1);
67: fnd_file.put_line(fnd_file.log,'Manager : '||l_res_mgr_name);
68: fnd_file.put_line(fnd_file.log,'Group : HR Hierarchy');

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

61: close c_res_mgr_name;
62:
63: fnd_file.new_line(fnd_file.log,1);
64: fnd_file.put_line(fnd_file.log,'Skills Report of HR Hierachy, for a Resource');
65: fnd_file.put_line(fnd_file.log,'--------------------------------------------');
66: fnd_file.new_line(fnd_file.log,1);
67: fnd_file.put_line(fnd_file.log,'Manager : '||l_res_mgr_name);
68: fnd_file.put_line(fnd_file.log,'Group : HR Hierarchy');
69: fnd_file.new_line(fnd_file.log,1);

Line 66: fnd_file.new_line(fnd_file.log,1);

62:
63: fnd_file.new_line(fnd_file.log,1);
64: fnd_file.put_line(fnd_file.log,'Skills Report of HR Hierachy, for a Resource');
65: fnd_file.put_line(fnd_file.log,'--------------------------------------------');
66: fnd_file.new_line(fnd_file.log,1);
67: fnd_file.put_line(fnd_file.log,'Manager : '||l_res_mgr_name);
68: fnd_file.put_line(fnd_file.log,'Group : HR Hierarchy');
69: fnd_file.new_line(fnd_file.log,1);
70:

Line 67: fnd_file.put_line(fnd_file.log,'Manager : '||l_res_mgr_name);

63: fnd_file.new_line(fnd_file.log,1);
64: fnd_file.put_line(fnd_file.log,'Skills Report of HR Hierachy, for a Resource');
65: fnd_file.put_line(fnd_file.log,'--------------------------------------------');
66: fnd_file.new_line(fnd_file.log,1);
67: fnd_file.put_line(fnd_file.log,'Manager : '||l_res_mgr_name);
68: fnd_file.put_line(fnd_file.log,'Group : HR Hierarchy');
69: fnd_file.new_line(fnd_file.log,1);
70:
71: open c_res_hier (l_resource_id);

Line 68: fnd_file.put_line(fnd_file.log,'Group : HR Hierarchy');

64: fnd_file.put_line(fnd_file.log,'Skills Report of HR Hierachy, for a Resource');
65: fnd_file.put_line(fnd_file.log,'--------------------------------------------');
66: fnd_file.new_line(fnd_file.log,1);
67: fnd_file.put_line(fnd_file.log,'Manager : '||l_res_mgr_name);
68: fnd_file.put_line(fnd_file.log,'Group : HR Hierarchy');
69: fnd_file.new_line(fnd_file.log,1);
70:
71: open c_res_hier (l_resource_id);
72: fetch c_res_hier into c_res_hier_rec;

Line 69: fnd_file.new_line(fnd_file.log,1);

65: fnd_file.put_line(fnd_file.log,'--------------------------------------------');
66: fnd_file.new_line(fnd_file.log,1);
67: fnd_file.put_line(fnd_file.log,'Manager : '||l_res_mgr_name);
68: fnd_file.put_line(fnd_file.log,'Group : HR Hierarchy');
69: fnd_file.new_line(fnd_file.log,1);
70:
71: open c_res_hier (l_resource_id);
72: fetch c_res_hier into c_res_hier_rec;
73: if c_res_hier%notfound then

Line 74: fnd_file.put_line(fnd_file.log,'This Manager (Resource) does not have any direct reports');

70:
71: open c_res_hier (l_resource_id);
72: fetch c_res_hier into c_res_hier_rec;
73: if c_res_hier%notfound then
74: fnd_file.put_line(fnd_file.log,'This Manager (Resource) does not have any direct reports');
75: fnd_file.new_line(fnd_file.log,1);
76: else
77: fnd_file.put_line(fnd_file.log,'Resource Name '||
78: 'Number '||'Skill Type '||

Line 75: fnd_file.new_line(fnd_file.log,1);

71: open c_res_hier (l_resource_id);
72: fetch c_res_hier into c_res_hier_rec;
73: if c_res_hier%notfound then
74: fnd_file.put_line(fnd_file.log,'This Manager (Resource) does not have any direct reports');
75: fnd_file.new_line(fnd_file.log,1);
76: else
77: fnd_file.put_line(fnd_file.log,'Resource Name '||
78: 'Number '||'Skill Type '||
79: 'Skill Name '||'Level ');

Line 77: fnd_file.put_line(fnd_file.log,'Resource Name '||

73: if c_res_hier%notfound then
74: fnd_file.put_line(fnd_file.log,'This Manager (Resource) does not have any direct reports');
75: fnd_file.new_line(fnd_file.log,1);
76: else
77: fnd_file.put_line(fnd_file.log,'Resource Name '||
78: 'Number '||'Skill Type '||
79: 'Skill Name '||'Level ');
80: fnd_file.put_line(fnd_file.log,'-------------------------------------------------- '||
81: '--------------- '||'-------------------- '||

Line 80: fnd_file.put_line(fnd_file.log,'-------------------------------------------------- '||

76: else
77: fnd_file.put_line(fnd_file.log,'Resource Name '||
78: 'Number '||'Skill Type '||
79: 'Skill Name '||'Level ');
80: fnd_file.put_line(fnd_file.log,'-------------------------------------------------- '||
81: '--------------- '||'-------------------- '||
82: '-------------------------------------------------- '||'-------------------- ');
83: fnd_file.new_line(fnd_file.log,1);
84: while (c_res_hier%found) loop

Line 83: fnd_file.new_line(fnd_file.log,1);

79: 'Skill Name '||'Level ');
80: fnd_file.put_line(fnd_file.log,'-------------------------------------------------- '||
81: '--------------- '||'-------------------- '||
82: '-------------------------------------------------- '||'-------------------- ');
83: fnd_file.new_line(fnd_file.log,1);
84: while (c_res_hier%found) loop
85: p_resource_id := c_res_hier_rec.resource_id;
86: p_level := c_res_hier_rec.level;
87: get_res_skills (p_resource_id,p_level);

Line 97: fnd_file.new_line(fnd_file.log,1);

93: open c_grp_name(l_group_id);
94: fetch c_grp_name into l_group_name;
95: close c_grp_name;
96:
97: fnd_file.new_line(fnd_file.log,1);
98: fnd_file.put_line(fnd_file.log,'Skills Report of all Members, for a Group');
99: fnd_file.put_line(fnd_file.log,'-----------------------------------------');
100: fnd_file.new_line(fnd_file.log,1);
101: fnd_file.put_line(fnd_file.log,'Group Name : '||l_group_name);

Line 98: fnd_file.put_line(fnd_file.log,'Skills Report of all Members, for a Group');

94: fetch c_grp_name into l_group_name;
95: close c_grp_name;
96:
97: fnd_file.new_line(fnd_file.log,1);
98: fnd_file.put_line(fnd_file.log,'Skills Report of all Members, for a Group');
99: fnd_file.put_line(fnd_file.log,'-----------------------------------------');
100: fnd_file.new_line(fnd_file.log,1);
101: fnd_file.put_line(fnd_file.log,'Group Name : '||l_group_name);
102: fnd_file.new_line(fnd_file.log,1);

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

95: close c_grp_name;
96:
97: fnd_file.new_line(fnd_file.log,1);
98: fnd_file.put_line(fnd_file.log,'Skills Report of all Members, for a Group');
99: fnd_file.put_line(fnd_file.log,'-----------------------------------------');
100: fnd_file.new_line(fnd_file.log,1);
101: fnd_file.put_line(fnd_file.log,'Group Name : '||l_group_name);
102: fnd_file.new_line(fnd_file.log,1);
103:

Line 100: fnd_file.new_line(fnd_file.log,1);

96:
97: fnd_file.new_line(fnd_file.log,1);
98: fnd_file.put_line(fnd_file.log,'Skills Report of all Members, for a Group');
99: fnd_file.put_line(fnd_file.log,'-----------------------------------------');
100: fnd_file.new_line(fnd_file.log,1);
101: fnd_file.put_line(fnd_file.log,'Group Name : '||l_group_name);
102: fnd_file.new_line(fnd_file.log,1);
103:
104: open c_grp_mem(l_group_id);

Line 101: fnd_file.put_line(fnd_file.log,'Group Name : '||l_group_name);

97: fnd_file.new_line(fnd_file.log,1);
98: fnd_file.put_line(fnd_file.log,'Skills Report of all Members, for a Group');
99: fnd_file.put_line(fnd_file.log,'-----------------------------------------');
100: fnd_file.new_line(fnd_file.log,1);
101: fnd_file.put_line(fnd_file.log,'Group Name : '||l_group_name);
102: fnd_file.new_line(fnd_file.log,1);
103:
104: open c_grp_mem(l_group_id);
105: fetch c_grp_mem into c_grp_mem_rec;

Line 102: fnd_file.new_line(fnd_file.log,1);

98: fnd_file.put_line(fnd_file.log,'Skills Report of all Members, for a Group');
99: fnd_file.put_line(fnd_file.log,'-----------------------------------------');
100: fnd_file.new_line(fnd_file.log,1);
101: fnd_file.put_line(fnd_file.log,'Group Name : '||l_group_name);
102: fnd_file.new_line(fnd_file.log,1);
103:
104: open c_grp_mem(l_group_id);
105: fetch c_grp_mem into c_grp_mem_rec;
106: if c_grp_mem%notfound then

Line 107: fnd_file.put_line(fnd_file.log,'This Group does not have any members');

103:
104: open c_grp_mem(l_group_id);
105: fetch c_grp_mem into c_grp_mem_rec;
106: if c_grp_mem%notfound then
107: fnd_file.put_line(fnd_file.log,'This Group does not have any members');
108: fnd_file.new_line(fnd_file.log,1);
109: else
110: fnd_file.put_line(fnd_file.log,'Resource Name '||
111: 'Number '||'Skill Type '||

Line 108: fnd_file.new_line(fnd_file.log,1);

104: open c_grp_mem(l_group_id);
105: fetch c_grp_mem into c_grp_mem_rec;
106: if c_grp_mem%notfound then
107: fnd_file.put_line(fnd_file.log,'This Group does not have any members');
108: fnd_file.new_line(fnd_file.log,1);
109: else
110: fnd_file.put_line(fnd_file.log,'Resource Name '||
111: 'Number '||'Skill Type '||
112: 'Skill Name '||'Level ');

Line 110: fnd_file.put_line(fnd_file.log,'Resource Name '||

106: if c_grp_mem%notfound then
107: fnd_file.put_line(fnd_file.log,'This Group does not have any members');
108: fnd_file.new_line(fnd_file.log,1);
109: else
110: fnd_file.put_line(fnd_file.log,'Resource Name '||
111: 'Number '||'Skill Type '||
112: 'Skill Name '||'Level ');
113: fnd_file.put_line(fnd_file.log,'-------------------------------------------------- '||
114: '--------------- '||'-------------------- '||

Line 113: fnd_file.put_line(fnd_file.log,'-------------------------------------------------- '||

109: else
110: fnd_file.put_line(fnd_file.log,'Resource Name '||
111: 'Number '||'Skill Type '||
112: 'Skill Name '||'Level ');
113: fnd_file.put_line(fnd_file.log,'-------------------------------------------------- '||
114: '--------------- '||'-------------------- '||
115: '-------------------------------------------------- '||'-------------------- ');
116: fnd_file.new_line(fnd_file.log,1);
117: while (c_grp_mem%found) loop

Line 116: fnd_file.new_line(fnd_file.log,1);

112: 'Skill Name '||'Level ');
113: fnd_file.put_line(fnd_file.log,'-------------------------------------------------- '||
114: '--------------- '||'-------------------- '||
115: '-------------------------------------------------- '||'-------------------- ');
116: fnd_file.new_line(fnd_file.log,1);
117: while (c_grp_mem%found) loop
118: m_resource_id := c_grp_mem_rec.resource_id;
119: get_res_skills (m_resource_id,2);
120: fetch c_grp_mem into c_grp_mem_rec;

Line 213: fnd_file.put_line(fnd_file.log,rpad(l_resource_name,50,' ')||' '||rpad(l_resource_number,15,' ')||' '||

209:
210: open c_res_skills;
211: fetch c_res_skills into c_res_skills_rec;
212: if c_res_skills%notfound then
213: fnd_file.put_line(fnd_file.log,rpad(l_resource_name,50,' ')||' '||rpad(l_resource_number,15,' ')||' '||
214: rpad(l_skill_type,20,' ') ||' '|| rpad(l_skill_name,50,' ')||' '||
215: rpad(l_skill_level,20,' '));
216: else
217: l_skill_type := '-';

Line 265: fnd_file.put_line(fnd_file.log,rpad(l_resource_name,50,' ')||' '||rpad(l_resource_number,15,' ')||' '||

261: end if;
262: close c_cat_name;
263: end if;
264:
265: fnd_file.put_line(fnd_file.log,rpad(l_resource_name,50,' ')||' '||rpad(l_resource_number,15,' ')||' '||
266: rpad(l_skill_type,20,' ') ||' '|| rpad(l_skill_name,50,' ')||' '||
267: rpad(l_skill_level,20,' '));
268: l_skill_type := '-';
269: l_skill_name := '-';