DBA Data[Home] [Help]

APPS.PY_DK_TAX_CARD dependencies on HR_UTILITY

Line 7: g_debug BOOLEAN := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package CONSTANT varchar2(33) := ' hr_dk_taxcard_api.';
7: g_debug BOOLEAN := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_taxcard >----------------------------|
11: -- ----------------------------------------------------------------------------

Line 141: hr_utility.set_location('Entering:'|| l_proc, 1);

137:
138: BEGIN
139:
140: if g_debug then
141: hr_utility.set_location('Entering:'|| l_proc, 1);
142: end if;
143: --Insert row into fnd_Sessions table.
144:
145: OPEN CSR_CHECK_FND_SESSION;

Line 173: hr_utility.set_location('Entering:'|| l_proc, 3);

169: (p_effective_date),
170: l_element_name_tl);
171:
172: if g_debug then
173: hr_utility.set_location('Entering:'|| l_proc, 3);
174: end if;
175:
176: -- fetch all input value id's
177: OPEN input_values_csr;

Line 185: hr_utility.set_location('Entering:'|| l_proc, 6);

181: CLOSE input_values_csr;
182:
183:
184: if g_debug then
185: hr_utility.set_location('Entering:'|| l_proc, 6);
186: end if;
187: --If taxcard type is "NTC", then the tax percentage need not be stored.
188: IF p_tax_card_type = 'NTC' then
189: l_tax_percentage := null;

Line 195: hr_utility.set_location('Entering:'|| l_proc, 7);

191: l_tax_percentage := p_tax_percentage;
192: END IF;
193:
194: if g_debug then
195: hr_utility.set_location('Entering:'|| l_proc, 7);
196: end if;
197:
198:
199: -- insert records into pay_element_entries_f and pay_element_entry_values_f

Line 239: hr_utility.set_location('Entering:'|| l_proc, 10);

235: );
236:
237:
238: if g_debug then
239: hr_utility.set_location('Entering:'|| l_proc, 10);
240: end if;
241:
242: -- Do not COMMIT here. COMMIT should be done thru the OAF Application only.
243: EXCEPTION

Line 245: hr_utility.set_location('Error message : '||SQLERRM, 11);

241:
242: -- Do not COMMIT here. COMMIT should be done thru the OAF Application only.
243: EXCEPTION
244: WHEN OTHERS THEN
245: hr_utility.set_location('Error message : '||SQLERRM, 11);
246: RAISE;
247: END insert_taxcard;
248: --
249: -- ----------------------------------------------------------------------------

Line 360: hr_utility.set_location('Entering:'|| l_proc, 1);

356:
357: l_proc varchar2(72) := g_package||'update_taxcard';
358: BEGIN
359: if g_debug then
360: hr_utility.set_location('Entering:'|| l_proc, 1);
361: end if;
362:
363: --l_start_date := sysdate;
364: l_element_entry_id := to_number(p_element_entry_id);

Line 376: hr_utility.set_location('Entering:'|| l_proc, 2);

372: l_tax_percentage := p_tax_percentage;
373: end if;
374:
375: if g_debug then
376: hr_utility.set_location('Entering:'|| l_proc, 2);
377: end if;
378:
379: -- insert records into pay_element_entries_f and pay_element_entry_values_f
380: /* Modified for to_number to fnd_number.canonical_to_number */

Line 476: hr_utility.set_location('Entering:'|| l_proc, 3);

472: ,p_entry_information29 => hr_api.g_varchar2
473: ,p_entry_information30 => hr_api.g_varchar2);
474:
475: if g_debug then
476: hr_utility.set_location('Entering:'|| l_proc, 3);
477: end if;
478: -- Do not COMMIT here. COMMIT should be done from the OAF Application Only.
479: EXCEPTION
480: WHEN OTHERS THEN

Line 481: hr_utility.set_location('Error message : '||SQLERRM, 12);

477: end if;
478: -- Do not COMMIT here. COMMIT should be done from the OAF Application Only.
479: EXCEPTION
480: WHEN OTHERS THEN
481: hr_utility.set_location('Error message : '||SQLERRM, 12);
482: RAISE;
483: END update_taxcard;
484: --
485: -- ----------------------------------------------------------------------------

Line 551: hr_utility.set_location('Entering:'|| l_proc, 1);

547: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
548:
549: BEGIN
550: if g_debug then
551: hr_utility.set_location('Entering:'|| l_proc, 1);
552: end if;
553: --
554: -- Call the corresponding datetrack api
555: --

Line 574: hr_utility.set_location('Entering:'|| l_proc, 2);

570: ,p_override_end_date => p_override_end_date
571: ,p_upd_chg_start_date => p_upd_chg_start_date
572: ,p_upd_chg_end_date => p_upd_chg_end_date);
573: if g_debug then
574: hr_utility.set_location('Entering:'|| l_proc, 2);
575: end if;
576: --
577: --hr_utility.set_location(' Leaving:'||l_proc, 10);
578: EXCEPTION

Line 577: --hr_utility.set_location(' Leaving:'||l_proc, 10);

573: if g_debug then
574: hr_utility.set_location('Entering:'|| l_proc, 2);
575: end if;
576: --
577: --hr_utility.set_location(' Leaving:'||l_proc, 10);
578: EXCEPTION
579: WHEN OTHERS THEN
580: RAISE;
581: END find_dt_upd_modes;

Line 631: hr_utility.set_location('Entering:'|| l_proc, 1);

627: l_proc varchar2(72) := g_package||'get_global_value';
628:
629: BEGIN
630: if g_debug then
631: hr_utility.set_location('Entering:'|| l_proc, 1);
632: end if;
633:
634: OPEN csr_globals;
635: FETCH csr_globals INTO l_global_value;

Line 639: hr_utility.set_location('Entering:'|| l_proc, 2);

635: FETCH csr_globals INTO l_global_value;
636: CLOSE csr_globals;
637:
638: if g_debug then
639: hr_utility.set_location('Entering:'|| l_proc, 2);
640: end if;
641:
642: RETURN l_global_value;
643: END get_global_value;