DBA Data[Home] [Help]

APPS.PAY_COSTING_KFF_UTIL_PKG dependencies on HR_UTILITY

Line 182: Hr_Utility.Set_Location('Entering:' || l_proc, 5);

178: l_allownulls VARCHAR2(1) DEFAULT 'Y';
179: l_num_reqs_in_this_level NUMBER;
180:
181: BEGIN
182: Hr_Utility.Set_Location('Entering:' || l_proc, 5);
183:
184: Fnd_Profile.Get(l_profile_name, l_profile_value);
185: Hr_Utility.Trace(' l_profile_value>' || l_profile_value || '<');
186:

Line 185: Hr_Utility.Trace(' l_profile_value>' || l_profile_value || '<');

181: BEGIN
182: Hr_Utility.Set_Location('Entering:' || l_proc, 5);
183:
184: Fnd_Profile.Get(l_profile_name, l_profile_value);
185: Hr_Utility.Trace(' l_profile_value>' || l_profile_value || '<');
186:
187: --
188: -- user chosen behaviour
189: --

Line 234: Hr_Utility.Trace(' l_chk_qual_segments>' || l_chk_qual_segments || '<');

230: OPEN csr_chk_qual_segments;
231: FETCH csr_chk_qual_segments
232: INTO l_chk_qual_segments;
233: CLOSE csr_chk_qual_segments;
234: Hr_Utility.Trace(' l_chk_qual_segments>' || l_chk_qual_segments || '<');
235:
236: --
237: -- if csr returns no rows, l_chk_qual_segments remains null,
238: -- implement new behaviour,

Line 249: Hr_Utility.Trace(' l_required>' || l_required || '<');

245: END IF;
246:
247: END IF;
248:
249: Hr_Utility.Trace(' l_required>' || l_required || '<');
250: Hr_Utility.Trace(' l_allownulls>' || l_allownulls || '<');
251:
252: p_required := l_required;
253: p_allownulls := l_allownulls;

Line 250: Hr_Utility.Trace(' l_allownulls>' || l_allownulls || '<');

246:
247: END IF;
248:
249: Hr_Utility.Trace(' l_required>' || l_required || '<');
250: Hr_Utility.Trace(' l_allownulls>' || l_allownulls || '<');
251:
252: p_required := l_required;
253: p_allownulls := l_allownulls;
254:

Line 255: Hr_Utility.Set_Location('Leaving:' || l_proc, 10);

251:
252: p_required := l_required;
253: p_allownulls := l_allownulls;
254:
255: Hr_Utility.Set_Location('Leaving:' || l_proc, 10);
256:
257: EXCEPTION
258: WHEN OTHERS THEN
259: Raise;

Line 340: Hr_Utility.Set_Location('Entering: '|| l_proc, 5);

336:
337: l_proc VARCHAR2(72) := g_package||'check_seg_value';
338:
339: BEGIN
340: Hr_Utility.Set_Location('Entering: '|| l_proc, 5);
341:
342: if p_segment_value is not null then
343:
344: Hr_Utility.Set_Location(l_proc, 10);

Line 344: Hr_Utility.Set_Location(l_proc, 10);

340: Hr_Utility.Set_Location('Entering: '|| l_proc, 5);
341:
342: if p_segment_value is not null then
343:
344: Hr_Utility.Set_Location(l_proc, 10);
345:
346: SELECT decode(attribute_value, 'Y', p_segment_value, null)
347: INTO p_segment_value
348: FROM FND_SEGMENT_ATTRIBUTE_VALUES sa1

Line 355: Hr_Utility.Set_Location(l_proc, 15);

351: AND sa1.application_id = 801
352: AND sa1.application_column_name = p_segment
353: AND sa1.segment_attribute_type = p_level;
354:
355: Hr_Utility.Set_Location(l_proc, 15);
356:
357: end if;
358:
359: Hr_Utility.Set_Location('Leaving: ' || l_proc, 20);

Line 359: Hr_Utility.Set_Location('Leaving: ' || l_proc, 20);

355: Hr_Utility.Set_Location(l_proc, 15);
356:
357: end if;
358:
359: Hr_Utility.Set_Location('Leaving: ' || l_proc, 20);
360:
361: END check_seg_value;
362:
363:

Line 365: Hr_Utility.Set_Location('Entering:' || l_proc, 5);

361: END check_seg_value;
362:
363:
364: BEGIN
365: Hr_Utility.Set_Location('Entering:' || l_proc, 5);
366:
367: if (p_level <> 'BALANCING' and
368: p_level <> 'PAYROLL') then
369:

Line 370: Hr_Utility.Set_Location(l_proc, 10);

366:
367: if (p_level <> 'BALANCING' and
368: p_level <> 'PAYROLL') then
369:
370: Hr_Utility.Set_Location(l_proc, 10);
371:
372: check_seg_value('SEGMENT1', p_segment1);
373: check_seg_value('SEGMENT2', p_segment2);
374: check_seg_value('SEGMENT3', p_segment3);

Line 406: Hr_Utility.Set_Location('Leaving:' || l_proc, 20);

402: check_seg_value('SEGMENT30', p_segment30);
403:
404: end if;
405:
406: Hr_Utility.Set_Location('Leaving:' || l_proc, 20);
407:
408: EXCEPTION
409: WHEN OTHERS THEN
410: Raise;