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

Line 357: g_debug := hr_utility.debug_enabled;

353: BEGIN --Begin Procedure
354:
355: -- Added for BUG: 5287675
356: IF g_debug is null THEN
357: g_debug := hr_utility.debug_enabled;
358: END IF;
359: -- Addition ends for BUG: 5287675
360: -- hr_utility.trace_on(null,'FTE');
361: hr_utility.trace('Entering '||gv_package_name||'.AUTO_CALC_FTE');

Line 360: -- hr_utility.trace_on(null,'FTE');

356: IF g_debug is null THEN
357: g_debug := hr_utility.debug_enabled;
358: END IF;
359: -- Addition ends for BUG: 5287675
360: -- hr_utility.trace_on(null,'FTE');
361: hr_utility.trace('Entering '||gv_package_name||'.AUTO_CALC_FTE');
362: hr_utility.trace('p_assignment_id :'||p_assignment_id);
363: hr_utility.trace('P_EFFECTIVE_START_DATE :'||P_EFFECTIVE_START_DATE);
364:

Line 361: hr_utility.trace('Entering '||gv_package_name||'.AUTO_CALC_FTE');

357: g_debug := hr_utility.debug_enabled;
358: END IF;
359: -- Addition ends for BUG: 5287675
360: -- hr_utility.trace_on(null,'FTE');
361: hr_utility.trace('Entering '||gv_package_name||'.AUTO_CALC_FTE');
362: hr_utility.trace('p_assignment_id :'||p_assignment_id);
363: hr_utility.trace('P_EFFECTIVE_START_DATE :'||P_EFFECTIVE_START_DATE);
364:
365: BEGIN

Line 362: hr_utility.trace('p_assignment_id :'||p_assignment_id);

358: END IF;
359: -- Addition ends for BUG: 5287675
360: -- hr_utility.trace_on(null,'FTE');
361: hr_utility.trace('Entering '||gv_package_name||'.AUTO_CALC_FTE');
362: hr_utility.trace('p_assignment_id :'||p_assignment_id);
363: hr_utility.trace('P_EFFECTIVE_START_DATE :'||P_EFFECTIVE_START_DATE);
364:
365: BEGIN
366: l_assignment_id := p_assignment_id;

Line 363: hr_utility.trace('P_EFFECTIVE_START_DATE :'||P_EFFECTIVE_START_DATE);

359: -- Addition ends for BUG: 5287675
360: -- hr_utility.trace_on(null,'FTE');
361: hr_utility.trace('Entering '||gv_package_name||'.AUTO_CALC_FTE');
362: hr_utility.trace('p_assignment_id :'||p_assignment_id);
363: hr_utility.trace('P_EFFECTIVE_START_DATE :'||P_EFFECTIVE_START_DATE);
364:
365: BEGIN
366: l_assignment_id := p_assignment_id;
367: l_effective_start_date := P_EFFECTIVE_START_DATE;

Line 376: hr_utility.trace('l_business_group_id :'||l_business_group_id);

372: open get_ass_typ_bus_grp_id(p_assignment_id => l_assignment_id, p_effective_date => l_effective_start_date);
373: fetch get_ass_typ_bus_grp_id into l_assignment_type, l_business_group_id;
374: close get_ass_typ_bus_grp_id;
375:
376: hr_utility.trace('l_business_group_id :'||l_business_group_id);
377: hr_utility.trace('l_assignment_type :'||l_assignment_type);
378: hr_utility.trace('l_legislation_code :'||l_legislation_code);
379:
380:

Line 377: hr_utility.trace('l_assignment_type :'||l_assignment_type);

373: fetch get_ass_typ_bus_grp_id into l_assignment_type, l_business_group_id;
374: close get_ass_typ_bus_grp_id;
375:
376: hr_utility.trace('l_business_group_id :'||l_business_group_id);
377: hr_utility.trace('l_assignment_type :'||l_assignment_type);
378: hr_utility.trace('l_legislation_code :'||l_legislation_code);
379:
380:
381: IF (l_assignment_id IS NOT NULL AND l_assignment_type = 'E')

Line 378: hr_utility.trace('l_legislation_code :'||l_legislation_code);

374: close get_ass_typ_bus_grp_id;
375:
376: hr_utility.trace('l_business_group_id :'||l_business_group_id);
377: hr_utility.trace('l_assignment_type :'||l_assignment_type);
378: hr_utility.trace('l_legislation_code :'||l_legislation_code);
379:
380:
381: IF (l_assignment_id IS NOT NULL AND l_assignment_type = 'E')
382: THEN

Line 389: hr_utility.trace('Inside '||gv_package_name||'.AUTO_CALC_FTE'||

385: -- This code will attempt to update the FTE value for
386: -- an assignment. It is within its own block because we don't
387: -- want to rollback the update to the assignment in the event that
388: -- the FTE processing fails for some reason.
389: hr_utility.trace('Inside '||gv_package_name||'.AUTO_CALC_FTE'||
390: l_assignment_id||' on '||
391: fnd_date.date_to_canonical(l_effective_start_date)
392: );
393: FOR this_abvm IN csr_abvm_uoms_to_process

Line 400: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_value_id:'||this_abvm.configuration_value_id);

396: )
397: LOOP
398:
399: IF g_debug THEN -- BUG: 5287675
400: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_value_id:'||this_abvm.configuration_value_id);
401: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_name:'||this_abvm.configuration_name);
402: hr_utility.trace('AUTO_CALC_FTE this_abvm.business_group_id:'||this_abvm.business_group_id);
403: hr_utility.trace('AUTO_CALC_FTE this_abvm.legislation_code:'||this_abvm.legislation_code);
404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);

Line 401: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_name:'||this_abvm.configuration_name);

397: LOOP
398:
399: IF g_debug THEN -- BUG: 5287675
400: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_value_id:'||this_abvm.configuration_value_id);
401: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_name:'||this_abvm.configuration_name);
402: hr_utility.trace('AUTO_CALC_FTE this_abvm.business_group_id:'||this_abvm.business_group_id);
403: hr_utility.trace('AUTO_CALC_FTE this_abvm.legislation_code:'||this_abvm.legislation_code);
404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);
405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);

Line 402: hr_utility.trace('AUTO_CALC_FTE this_abvm.business_group_id:'||this_abvm.business_group_id);

398:
399: IF g_debug THEN -- BUG: 5287675
400: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_value_id:'||this_abvm.configuration_value_id);
401: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_name:'||this_abvm.configuration_name);
402: hr_utility.trace('AUTO_CALC_FTE this_abvm.business_group_id:'||this_abvm.business_group_id);
403: hr_utility.trace('AUTO_CALC_FTE this_abvm.legislation_code:'||this_abvm.legislation_code);
404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);
405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);
406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);

Line 403: hr_utility.trace('AUTO_CALC_FTE this_abvm.legislation_code:'||this_abvm.legislation_code);

399: IF g_debug THEN -- BUG: 5287675
400: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_value_id:'||this_abvm.configuration_value_id);
401: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_name:'||this_abvm.configuration_name);
402: hr_utility.trace('AUTO_CALC_FTE this_abvm.business_group_id:'||this_abvm.business_group_id);
403: hr_utility.trace('AUTO_CALC_FTE this_abvm.legislation_code:'||this_abvm.legislation_code);
404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);
405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);
406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);
407: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_name:'||this_abvm.defn_config_name);

Line 404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);

400: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_value_id:'||this_abvm.configuration_value_id);
401: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_name:'||this_abvm.configuration_name);
402: hr_utility.trace('AUTO_CALC_FTE this_abvm.business_group_id:'||this_abvm.business_group_id);
403: hr_utility.trace('AUTO_CALC_FTE this_abvm.legislation_code:'||this_abvm.legislation_code);
404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);
405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);
406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);
407: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_name:'||this_abvm.defn_config_name);
408: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_bg_id:'||this_abvm.defn_bg_id);

Line 405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);

401: hr_utility.trace('AUTO_CALC_FTE this_abvm.configuration_name:'||this_abvm.configuration_name);
402: hr_utility.trace('AUTO_CALC_FTE this_abvm.business_group_id:'||this_abvm.business_group_id);
403: hr_utility.trace('AUTO_CALC_FTE this_abvm.legislation_code:'||this_abvm.legislation_code);
404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);
405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);
406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);
407: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_name:'||this_abvm.defn_config_name);
408: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_bg_id:'||this_abvm.defn_bg_id);
409: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_leg_code:'||this_abvm.defn_leg_code);

Line 406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);

402: hr_utility.trace('AUTO_CALC_FTE this_abvm.business_group_id:'||this_abvm.business_group_id);
403: hr_utility.trace('AUTO_CALC_FTE this_abvm.legislation_code:'||this_abvm.legislation_code);
404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);
405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);
406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);
407: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_name:'||this_abvm.defn_config_name);
408: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_bg_id:'||this_abvm.defn_bg_id);
409: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_leg_code:'||this_abvm.defn_leg_code);
410: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_custom_function:'||this_abvm.defn_custom_function);

Line 407: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_name:'||this_abvm.defn_config_name);

403: hr_utility.trace('AUTO_CALC_FTE this_abvm.legislation_code:'||this_abvm.legislation_code);
404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);
405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);
406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);
407: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_name:'||this_abvm.defn_config_name);
408: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_bg_id:'||this_abvm.defn_bg_id);
409: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_leg_code:'||this_abvm.defn_leg_code);
410: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_custom_function:'||this_abvm.defn_custom_function);
411: END IF;

Line 408: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_bg_id:'||this_abvm.defn_bg_id);

404: hr_utility.trace('AUTO_CALC_FTE this_abvm.uom:'||this_abvm.uom);
405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);
406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);
407: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_name:'||this_abvm.defn_config_name);
408: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_bg_id:'||this_abvm.defn_bg_id);
409: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_leg_code:'||this_abvm.defn_leg_code);
410: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_custom_function:'||this_abvm.defn_custom_function);
411: END IF;
412:

Line 409: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_leg_code:'||this_abvm.defn_leg_code);

405: hr_utility.trace('AUTO_CALC_FTE this_abvm.is_enabled:'||this_abvm.is_enabled);
406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);
407: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_name:'||this_abvm.defn_config_name);
408: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_bg_id:'||this_abvm.defn_bg_id);
409: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_leg_code:'||this_abvm.defn_leg_code);
410: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_custom_function:'||this_abvm.defn_custom_function);
411: END IF;
412:
413:

Line 410: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_custom_function:'||this_abvm.defn_custom_function);

406: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_value_id:'||this_abvm.defn_config_value_id);
407: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_config_name:'||this_abvm.defn_config_name);
408: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_bg_id:'||this_abvm.defn_bg_id);
409: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_leg_code:'||this_abvm.defn_leg_code);
410: hr_utility.trace('AUTO_CALC_FTE this_abvm.defn_custom_function:'||this_abvm.defn_custom_function);
411: END IF;
412:
413:
414: l_abv_uom := this_abvm.uom;

Line 433: hr_utility.trace('l_contract_type_exist: TRUE');

429: CLOSE csr_chk_asg_abv_exist ;
430:
431: IF g_debug THEN -- BUG: 5287675
432: IF l_contract_type_exist IS NOT NULL THEN
433: hr_utility.trace('l_contract_type_exist: TRUE');
434: ELSE
435: hr_utility.trace('l_contract_type_exist: FALSE');
436: END IF;
437: IF l_fte_exist IS NOT NULL THEN

Line 435: hr_utility.trace('l_contract_type_exist: FALSE');

431: IF g_debug THEN -- BUG: 5287675
432: IF l_contract_type_exist IS NOT NULL THEN
433: hr_utility.trace('l_contract_type_exist: TRUE');
434: ELSE
435: hr_utility.trace('l_contract_type_exist: FALSE');
436: END IF;
437: IF l_fte_exist IS NOT NULL THEN
438: hr_utility.trace('l_fte_exist: TRUE');
439: ELSE

Line 438: hr_utility.trace('l_fte_exist: TRUE');

434: ELSE
435: hr_utility.trace('l_contract_type_exist: FALSE');
436: END IF;
437: IF l_fte_exist IS NOT NULL THEN
438: hr_utility.trace('l_fte_exist: TRUE');
439: ELSE
440: hr_utility.trace('l_fte_exist: FALSE');
441: END IF;
442: END IF;

Line 440: hr_utility.trace('l_fte_exist: FALSE');

436: END IF;
437: IF l_fte_exist IS NOT NULL THEN
438: hr_utility.trace('l_fte_exist: TRUE');
439: ELSE
440: hr_utility.trace('l_fte_exist: FALSE');
441: END IF;
442: END IF;
443:
444: IF (l_contract_type_exist IS NOT NULL OR l_fte_exist IS NOT NULL )

Line 472: hr_utility.trace('Leaving '||gv_package_name||'.AUTO_CALC_FTE'||' for '||

468:
469: END LOOP; -- FOR this_abvm IN csr_abvm_uoms_to_process
470:
471: IF g_debug THEN -- BUG: 5287675
472: hr_utility.trace('Leaving '||gv_package_name||'.AUTO_CALC_FTE'||' for '||
473: l_assignment_id||' on '||
474: fnd_date.date_to_canonical(l_effective_start_date)
475: );
476: END IF;

Line 482: hr_utility.trace('Error in '||gv_package_name||'.AUTO_CALC_FTE'||' for '||

478:
479: END;
480: EXCEPTION
481: WHEN OTHERS THEN
482: hr_utility.trace('Error in '||gv_package_name||'.AUTO_CALC_FTE'||' for '||
483: l_assignment_id||' on '||
484: fnd_date.date_to_canonical(l_effective_start_date)
485: );
486: --fnd_message.RETRIEVE;

Line 490: hr_utility.trace(gv_package_name||'.AUTO_CALC_FTE : Error msg '||l_error_message);

486: --fnd_message.RETRIEVE;
487: l_error_message := fnd_message.get;
488: l_error_message := NVL(RTRIM(LTRIM(l_error_message)),'SQLERRM:'||SQLERRM);
489: IF g_debug THEN -- BUG: 5287675
490: hr_utility.trace(gv_package_name||'.AUTO_CALC_FTE : Error msg '||l_error_message);
491: END IF;
492: hr_utility.set_message(8303,'PQP_230514_FTE_FAILURE');
493: fnd_message.set_token('ABVUOM',l_abv_uom);
494: fnd_message.set_token('ERRORMSG',l_error_message);

Line 492: hr_utility.set_message(8303,'PQP_230514_FTE_FAILURE');

488: l_error_message := NVL(RTRIM(LTRIM(l_error_message)),'SQLERRM:'||SQLERRM);
489: IF g_debug THEN -- BUG: 5287675
490: hr_utility.trace(gv_package_name||'.AUTO_CALC_FTE : Error msg '||l_error_message);
491: END IF;
492: hr_utility.set_message(8303,'PQP_230514_FTE_FAILURE');
493: fnd_message.set_token('ABVUOM',l_abv_uom);
494: fnd_message.set_token('ERRORMSG',l_error_message);
495: hr_utility.set_warning;
496:

Line 495: hr_utility.set_warning;

491: END IF;
492: hr_utility.set_message(8303,'PQP_230514_FTE_FAILURE');
493: fnd_message.set_token('ABVUOM',l_abv_uom);
494: fnd_message.set_token('ERRORMSG',l_error_message);
495: hr_utility.set_warning;
496:
497:
498: END AUTO_CALC_FTE;
499: