DBA Data[Home] [Help]

APPS.PY_NO_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_no_taxcard_api.';
7: g_debug BOOLEAN := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_taxcard >----------------------------|
11: -- ----------------------------------------------------------------------------

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

125: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;
126:
127: BEGIN
128: if g_debug then
129: hr_utility.set_location('Entering:'|| l_proc, 1);
130: end if;
131: --Insert row into fnd_Sessions table.
132: /*INSERT INTO fnd_sessions(session_id,effective_date)
133: VALUES(userenv('sessionid'), p_effective_date);*/

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

147: p_assignment_id, p_business_group_id,
148: fnd_date.date_to_canonical(p_effective_date),
149: 'Tax Card');
150: if g_debug then
151: hr_utility.set_location('Entering:'|| l_proc, 2);
152: end if;
153: -- fetch all input value id's
154: OPEN input_values_csr;
155: FETCH input_values_csr INTO l_element_type_id, l_input_value_id1, l_input_value_id2,

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

158: CLOSE input_values_csr;
159:
160:
161: if g_debug then
162: hr_utility.set_location('Entering:'|| l_proc, 3);
163: end if;
164: /* Commented out this code as element has Tax Percentage input value mandatory */
165: /*--If taxcard type is "NTC" or "TF" , then the tax percentage need not be stored.
166: /* Uncommented code and modified to ensure Global value is stored if the value passed is null*/

Line 176: hr_utility.set_location('Entering:'|| l_proc, 4);

172: END IF;
173:
174: /*l_entry_value4 := p_entry_value4;*/
175: if g_debug then
176: hr_utility.set_location('Entering:'|| l_proc, 4);
177: end if;
178: -- insert records into pay_element_entries_f and pay_element_entry_values_f
179: pay_element_entry_api.create_element_entry
180: (p_effective_date => p_effective_date

Line 212: hr_utility.set_location('Entering:'|| l_proc, 5);

208: ,p_create_warning => l_warning
209: );
210:
211: if g_debug then
212: hr_utility.set_location('Entering:'|| l_proc, 5);
213: end if;
214: -- Do not COMMIT here. COMMIT should be done thru the OAF Application only.
215: EXCEPTION
216: WHEN OTHERS THEN

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

334:
335: lr_check_fnd_session csr_check_fnd_session%ROWTYPE;
336: BEGIN
337: if g_debug then
338: hr_utility.set_location('Entering:'|| l_proc, 1);
339: end if;
340: --pgopal - Insert row into fnd_Sessions table.
341: OPEN csr_check_fnd_session;
342: FETCH csr_check_fnd_session INTO lr_check_fnd_session;

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

360:
361: l_entry_value4 := p_entry_value4;
362:
363: if g_debug then
364: hr_utility.set_location('Entering:'|| l_proc, 2);
365: end if;
366:
367: -- insert records into pay_element_entries_f and pay_element_entry_values_f
368:

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

458: ,p_entry_information29 => hr_api.g_varchar2
459: ,p_entry_information30 => hr_api.g_varchar2);
460:
461: if g_debug then
462: hr_utility.set_location('Entering:'|| l_proc, 3);
463: end if;
464: -- Do not COMMIT here. COMMIT should be done from the OAF Application Only.
465: EXCEPTION
466: WHEN OTHERS THEN

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

533: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
534:
535: BEGIN
536: if g_debug then
537: hr_utility.set_location('Entering:'|| l_proc, 1);
538: end if;
539: --
540: -- Call the corresponding datetrack api
541: --

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

556: ,p_override_end_date => p_override_end_date
557: ,p_upd_chg_start_date => p_upd_chg_start_date
558: ,p_upd_chg_end_date => p_upd_chg_end_date);
559: if g_debug then
560: hr_utility.set_location('Entering:'|| l_proc, 2);
561: end if;
562: --
563: --hr_utility.set_location(' Leaving:'||l_proc, 10);
564: EXCEPTION

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

559: if g_debug then
560: hr_utility.set_location('Entering:'|| l_proc, 2);
561: end if;
562: --
563: --hr_utility.set_location(' Leaving:'||l_proc, 10);
564: EXCEPTION
565: WHEN OTHERS THEN
566: RAISE;
567: END find_dt_upd_modes;

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

613: l_proc varchar2(72) := g_package||'get_global_value';
614:
615: BEGIN
616: if g_debug then
617: hr_utility.set_location('Entering:'|| l_proc, 1);
618: end if;
619:
620: OPEN csr_globals;
621: FETCH csr_globals INTO l_global_value;

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

621: FETCH csr_globals INTO l_global_value;
622: CLOSE csr_globals;
623:
624: if g_debug then
625: hr_utility.set_location('Entering:'|| l_proc, 2);
626: end if;
627:
628: RETURN l_global_value;
629: END get_global_value;