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.PER_GB_PENSRV_SVPN dependencies on HR_UTILITY

Line 121: hr_utility.set_location('attrbute_category is :'||l_ass_attribute_category, 10);

117: l_procedure_name := '.create_gb_spn';
118: g_assignment_id := p_assignment_id;
119: g_effective_date := p_effective_date;
120:
121: hr_utility.set_location('attrbute_category is :'||l_ass_attribute_category, 10);
122: hr_utility.set_location('g_assignment_id is :'||g_assignment_id, 20);
123: hr_utility.set_location('g_effective_date is :'||g_effective_date, 30);
124:
125: -- fetching primary assignment details

Line 122: hr_utility.set_location('g_assignment_id is :'||g_assignment_id, 20);

118: g_assignment_id := p_assignment_id;
119: g_effective_date := p_effective_date;
120:
121: hr_utility.set_location('attrbute_category is :'||l_ass_attribute_category, 10);
122: hr_utility.set_location('g_assignment_id is :'||g_assignment_id, 20);
123: hr_utility.set_location('g_effective_date is :'||g_effective_date, 30);
124:
125: -- fetching primary assignment details
126: OPEN csr_get_asg_detials(g_assignment_id,g_effective_date);

Line 123: hr_utility.set_location('g_effective_date is :'||g_effective_date, 30);

119: g_effective_date := p_effective_date;
120:
121: hr_utility.set_location('attrbute_category is :'||l_ass_attribute_category, 10);
122: hr_utility.set_location('g_assignment_id is :'||g_assignment_id, 20);
123: hr_utility.set_location('g_effective_date is :'||g_effective_date, 30);
124:
125: -- fetching primary assignment details
126: OPEN csr_get_asg_detials(g_assignment_id,g_effective_date);
127: FETCH csr_get_asg_detials INTO l_pri_flag;

Line 155: hr_utility.set_location(' l_bg_id :'||l_bg_id,40);

151: OPEN csr_svpn_maintain_flag(l_bg_id);
152: FETCH csr_svpn_maintain_flag INTO g_svpn_flag;
153: CLOSE csr_svpn_maintain_flag;
154:
155: hr_utility.set_location(' l_bg_id :'||l_bg_id,40);
156: hr_utility.set_location('g_svpn_flag'||g_svpn_flag,45);
157:
158: IF g_svpn_flag = 'Yes' THEN
159:

Line 156: hr_utility.set_location('g_svpn_flag'||g_svpn_flag,45);

152: FETCH csr_svpn_maintain_flag INTO g_svpn_flag;
153: CLOSE csr_svpn_maintain_flag;
154:
155: hr_utility.set_location(' l_bg_id :'||l_bg_id,40);
156: hr_utility.set_location('g_svpn_flag'||g_svpn_flag,45);
157:
158: IF g_svpn_flag = 'Yes' THEN
159:
160:

Line 175: hr_utility.set_location('l_query: '||l_query,50);

171: l_query := l_query||
172: 'and to_date('''||TO_CHAR(g_effective_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'') between effective_start_date'||' '||
173: 'and effective_end_date';
174:
175: hr_utility.set_location('l_query: '||l_query,50);
176:
177: -- fetch the value of from the column name
178: OPEN c_base_table FOR l_query;
179: FETCH c_base_table INTO l_value;

Line 183: hr_utility.set_location('value is NULL :', 60);

179: FETCH c_base_table INTO l_value;
180: CLOSE c_base_table;
181:
182: IF l_value IS NULL THEN
183: hr_utility.set_location('value is NULL :', 60);
184: hr_utility.set_location(' l_value'||l_value,70);
185: NULL;
186: ELSE
187: hr_utility.set_location('attribute value is not NULL :', 80);

Line 184: hr_utility.set_location(' l_value'||l_value,70);

180: CLOSE c_base_table;
181:
182: IF l_value IS NULL THEN
183: hr_utility.set_location('value is NULL :', 60);
184: hr_utility.set_location(' l_value'||l_value,70);
185: NULL;
186: ELSE
187: hr_utility.set_location('attribute value is not NULL :', 80);
188: hr_utility.set_location(' l_value'||l_value,90);

Line 187: hr_utility.set_location('attribute value is not NULL :', 80);

183: hr_utility.set_location('value is NULL :', 60);
184: hr_utility.set_location(' l_value'||l_value,70);
185: NULL;
186: ELSE
187: hr_utility.set_location('attribute value is not NULL :', 80);
188: hr_utility.set_location(' l_value'||l_value,90);
189:
190: -- fetch EIT information
191: OPEN cur_get_eit_info(c_assignment_id => g_assignment_id);

Line 188: hr_utility.set_location(' l_value'||l_value,90);

184: hr_utility.set_location(' l_value'||l_value,70);
185: NULL;
186: ELSE
187: hr_utility.set_location('attribute value is not NULL :', 80);
188: hr_utility.set_location(' l_value'||l_value,90);
189:
190: -- fetch EIT information
191: OPEN cur_get_eit_info(c_assignment_id => g_assignment_id);
192: FETCH cur_get_eit_info INTO l_spn;

Line 195: hr_utility.set_location(' spn value :'||l_spn, 100);

191: OPEN cur_get_eit_info(c_assignment_id => g_assignment_id);
192: FETCH cur_get_eit_info INTO l_spn;
193: CLOSE cur_get_eit_info;
194:
195: hr_utility.set_location(' spn value :'||l_spn, 100);
196:
197: -- Check whether service period number is null or not
198:
199: IF l_spn IS NULL THEN

Line 211: hr_utility.set_location(' l_spn value :'||l_spn, 105);

207:
208: OPEN cur_get_svpn(l_ni_number);
209: FETCH cur_get_svpn INTO l_spn;
210: CLOSE cur_get_svpn;
211: hr_utility.set_location(' l_spn value :'||l_spn, 105);
212: IF l_spn IS null THEN
213: l_spn := 1;
214: END IF;
215: -- Inserting the service period number

Line 222: hr_utility.set_location(' inserted successfully :'||l_spn, 100);

218: ,p_aei_information_category => 'PQP_GB_PENSERV_SVPN'
219: ,p_aei_information1 => lpad(l_spn,2,'0')
220: ,p_assignment_extra_info_id => l_assignment_extra_info_id
221: ,p_object_version_number => l_object_version_number);
222: hr_utility.set_location(' inserted successfully :'||l_spn, 100);
223: END IF;
224: ELSE
225: hr_utility.set_location(' Spn calculation not required :',110);
226: END IF;

Line 225: hr_utility.set_location(' Spn calculation not required :',110);

221: ,p_object_version_number => l_object_version_number);
222: hr_utility.set_location(' inserted successfully :'||l_spn, 100);
223: END IF;
224: ELSE
225: hr_utility.set_location(' Spn calculation not required :',110);
226: END IF;
227: END IF;
228: ELSE
229: fnd_file.put_line(fnd_file.log,'Maitain Service Period No. is not set to "Yes" for the configuration PAYPOINT and CUTOVER INFORMATION