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

Line 5: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PY_FI_TAX_CARD AS
2: /* $Header: pyfitaxc.pkb 120.2.12000000.3 2007/02/27 06:16:49 dbehera noship $ */
3:
4: g_package CONSTANT varchar2(33) := 'hr_fi_taxcard_api.';
5: g_debug BOOLEAN := hr_utility.debug_enabled;
6:
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------------< ins >---------------------------------|

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

99: AND fnd_date.canonical_to_date(effective_date) BETWEEN pasg.effective_start_date AND pasg.effective_end_date;
100: BEGIN
101:
102: if g_debug then
103: hr_utility.set_location('Entering:'|| l_proc, 1);
104: end if;
105: -- Check if the assignment is a primary Assignment.
106: -- If 'Yes' then call insert_taxcard and then insert_tax
107: -- If 'No' then call only insert_tax.

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

106: -- If 'Yes' then call insert_taxcard and then insert_tax
107: -- If 'No' then call only insert_tax.
108: IF is_primary_asg(p_assignment_id , p_effective_date) = true THEN
109: if g_debug then
110: hr_utility.set_location('Entering:'|| l_proc, 2);
111: end if;
112: -- Get Primary Assignment Id for the given asg id.
113: -- and pass it to the insert_taxcard procedure
114: OPEN cPrimaryAsg(p_assignment_id , p_effective_date);

Line 137: hr_utility.set_location('Leaving:'|| l_proc, 2);

133: ,p_date_returned => fnd_date.canonical_to_date(p_date_returned)
134: ,p_registration_date => fnd_date.canonical_to_date(p_registration_date)
135: ,p_lower_income_percentage => p_lower_income_percentage);
136: if g_debug then
137: hr_utility.set_location('Leaving:'|| l_proc, 2);
138: end if;
139:
140: if g_debug then
141: hr_utility.set_location('Entering:'|| l_proc, 3);

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

137: hr_utility.set_location('Leaving:'|| l_proc, 2);
138: end if;
139:
140: if g_debug then
141: hr_utility.set_location('Entering:'|| l_proc, 3);
142: end if;
143: -- Now call insert_tax procedure
144: insert_tax (
145: p_legislation_code => p_legislation_code

Line 157: hr_utility.set_location('Leaving:'|| l_proc, 3);

153: ,p_extra_income_add_rate => p_extra_income_add_rate
154: ,p_extra_income_limit => p_extra_income_limit
155: ,p_prev_extra_income => p_prev_extra_income);
156: if g_debug then
157: hr_utility.set_location('Leaving:'|| l_proc, 3);
158: end if;
159: ELSIF is_primary_asg(p_assignment_id , p_effective_date) = false THEN
160: if g_debug then
161: hr_utility.set_location('Entering:'|| l_proc, 4);

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

157: hr_utility.set_location('Leaving:'|| l_proc, 3);
158: end if;
159: ELSIF is_primary_asg(p_assignment_id , p_effective_date) = false THEN
160: if g_debug then
161: hr_utility.set_location('Entering:'|| l_proc, 4);
162: end if;
163: insert_tax (
164: p_legislation_code => p_legislation_code
165: ,p_effective_date => p_effective_date

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

172: ,p_extra_income_add_rate => p_extra_income_add_rate
173: ,p_extra_income_limit => p_extra_income_limit
174: ,p_prev_extra_income => p_prev_extra_income);
175: if g_debug then
176: hr_utility.set_location('Leaving:'|| l_proc, 4);
177: end if;
178: END IF;
179: if g_debug then
180: hr_utility.set_location('Leaving:'|| l_proc, 1);

Line 180: hr_utility.set_location('Leaving:'|| l_proc, 1);

176: hr_utility.set_location('Leaving:'|| l_proc, 4);
177: end if;
178: END IF;
179: if g_debug then
180: hr_utility.set_location('Leaving:'|| l_proc, 1);
181: end if;
182: -- Do not COMMIT here. COMMIT should be done thru the OAF Application only.
183:
184: EXCEPTION

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

312:
313: BEGIN
314:
315: if g_debug then
316: hr_utility.set_location('Entering:'|| l_proc, 1);
317: end if;
318:
319: --Insert row into fnd_Sessions table.
320: OPEN CSR_CHECK_FND_SESSION;

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

329:
330:
331:
332: if g_debug then
333: hr_utility.set_location('Entering:'|| l_proc, 2);
334: end if;
335: -- fetch element link id
336: l_element_link_id := pay_fi_tc_dp_upload.get_element_link_id(
337: p_assignment_id, p_business_group_id,

Line 342: hr_utility.set_location('Leaving:'|| l_proc, 2);

338: fnd_date.date_to_canonical(p_effective_date),
339: 'Tax Card');
340: l_element_entry_id := p_element_entry_id_tc;
341: if g_debug then
342: hr_utility.set_location('Leaving:'|| l_proc, 2);
343: end if;
344:
345: if g_debug then
346: hr_utility.set_location('Entering:'|| l_proc, 3);

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

342: hr_utility.set_location('Leaving:'|| l_proc, 2);
343: end if;
344:
345: if g_debug then
346: hr_utility.set_location('Entering:'|| l_proc, 3);
347: end if;
348: -- fetch all input value id's
349: OPEN input_values_csr;
350: FETCH input_values_csr INTO l_element_type_id, l_input_value_id1, l_input_value_id2,

Line 356: hr_utility.set_location('Leaving:'|| l_proc, 3);

352: l_input_value_id7, l_input_value_id8,l_input_value_id9,l_input_value_id10,l_input_value_id11;
353: CLOSE input_values_csr;
354:
355: if g_debug then
356: hr_utility.set_location('Leaving:'|| l_proc, 3);
357: end if;
358: if g_debug then
359: hr_utility.set_location('Entering:'|| l_proc, 4);
360: end if;

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

355: if g_debug then
356: hr_utility.set_location('Leaving:'|| l_proc, 3);
357: end if;
358: if g_debug then
359: hr_utility.set_location('Entering:'|| l_proc, 4);
360: end if;
361: -- insert records into pay_element_entries_f and pay_element_entry_values_f
362: pay_element_entry_api.create_element_entry
363: (p_effective_date => p_effective_date

Line 398: hr_utility.set_location('Leaving:'|| l_proc, 4);

394: ,p_create_warning => l_warning
395: );
396:
397: if g_debug then
398: hr_utility.set_location('Leaving:'|| l_proc, 4);
399: end if;
400:
401: if g_debug then
402: hr_utility.set_location('Leaving:'|| l_proc, 1);

Line 402: hr_utility.set_location('Leaving:'|| l_proc, 1);

398: hr_utility.set_location('Leaving:'|| l_proc, 4);
399: end if;
400:
401: if g_debug then
402: hr_utility.set_location('Leaving:'|| l_proc, 1);
403: end if;
404: -- Do not COMMIT here. COMMIT should be done thru the OAF Application only.
405: EXCEPTION
406: WHEN OTHERS THEN

Line 534: --hr_utility.trace_on(NULL,'TELL');

530: l_proc varchar2(72) := g_package||'insert_tax.';
531: l_datetrack_update_mode VARCHAR2(255);
532: l_record_started_today BOOLEAN;
533: BEGIN
534: --hr_utility.trace_on(NULL,'TELL');
535: if g_debug then
536: hr_utility.set_location('Entering:'|| l_proc, 1);
537: end if;
538: --Insert row into fnd_Sessions table.

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

532: l_record_started_today BOOLEAN;
533: BEGIN
534: --hr_utility.trace_on(NULL,'TELL');
535: if g_debug then
536: hr_utility.set_location('Entering:'|| l_proc, 1);
537: end if;
538: --Insert row into fnd_Sessions table.
539: OPEN CSR_CHECK_FND_SESSION;
540: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;

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

545:
546: CLOSE CSR_CHECK_FND_SESSION;
547:
548: if g_debug then
549: hr_utility.set_location('Entering:'|| l_proc, 2);
550: end if;
551: -- fetch element link id
552: l_element_link_id := pay_fi_tc_dp_upload.get_element_link_id(
553: p_assignment_id, p_business_group_id,

Line 558: hr_utility.set_location('Leaving:'|| l_proc, 2);

554: fnd_date.date_to_canonical(p_effective_date),
555: 'Tax');
556: l_element_entry_id := p_element_entry_id_t;
557: if g_debug then
558: hr_utility.set_location('Leaving:'|| l_proc, 2);
559: end if;
560:
561: if g_debug then
562: hr_utility.set_location('Entering:'|| l_proc, 3);

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

558: hr_utility.set_location('Leaving:'|| l_proc, 2);
559: end if;
560:
561: if g_debug then
562: hr_utility.set_location('Entering:'|| l_proc, 3);
563: end if;
564: -- fetch all input value id's
565: OPEN input_values_csr;
566: FETCH input_values_csr INTO l_element_type_id, l_input_value_id1, l_input_value_id2,

Line 568: hr_utility.set_location('Entering:'|| l_element_type_id, 1);

564: -- fetch all input value id's
565: OPEN input_values_csr;
566: FETCH input_values_csr INTO l_element_type_id, l_input_value_id1, l_input_value_id2,
567: l_input_value_id3, l_input_value_id4, l_input_value_id5;
568: hr_utility.set_location('Entering:'|| l_element_type_id, 1);
569: hr_utility.set_location('Entering:'|| l_input_value_id1, 1);
570: hr_utility.set_location('Entering:'|| l_input_value_id2, 1);
571: hr_utility.set_location('Entering:'|| l_input_value_id3, 1);
572: hr_utility.set_location('Entering:'|| l_input_value_id4, 1);

Line 569: hr_utility.set_location('Entering:'|| l_input_value_id1, 1);

565: OPEN input_values_csr;
566: FETCH input_values_csr INTO l_element_type_id, l_input_value_id1, l_input_value_id2,
567: l_input_value_id3, l_input_value_id4, l_input_value_id5;
568: hr_utility.set_location('Entering:'|| l_element_type_id, 1);
569: hr_utility.set_location('Entering:'|| l_input_value_id1, 1);
570: hr_utility.set_location('Entering:'|| l_input_value_id2, 1);
571: hr_utility.set_location('Entering:'|| l_input_value_id3, 1);
572: hr_utility.set_location('Entering:'|| l_input_value_id4, 1);
573: hr_utility.set_location('Entering:'|| l_input_value_id5, 1);

Line 570: hr_utility.set_location('Entering:'|| l_input_value_id2, 1);

566: FETCH input_values_csr INTO l_element_type_id, l_input_value_id1, l_input_value_id2,
567: l_input_value_id3, l_input_value_id4, l_input_value_id5;
568: hr_utility.set_location('Entering:'|| l_element_type_id, 1);
569: hr_utility.set_location('Entering:'|| l_input_value_id1, 1);
570: hr_utility.set_location('Entering:'|| l_input_value_id2, 1);
571: hr_utility.set_location('Entering:'|| l_input_value_id3, 1);
572: hr_utility.set_location('Entering:'|| l_input_value_id4, 1);
573: hr_utility.set_location('Entering:'|| l_input_value_id5, 1);
574:

Line 571: hr_utility.set_location('Entering:'|| l_input_value_id3, 1);

567: l_input_value_id3, l_input_value_id4, l_input_value_id5;
568: hr_utility.set_location('Entering:'|| l_element_type_id, 1);
569: hr_utility.set_location('Entering:'|| l_input_value_id1, 1);
570: hr_utility.set_location('Entering:'|| l_input_value_id2, 1);
571: hr_utility.set_location('Entering:'|| l_input_value_id3, 1);
572: hr_utility.set_location('Entering:'|| l_input_value_id4, 1);
573: hr_utility.set_location('Entering:'|| l_input_value_id5, 1);
574:
575: CLOSE input_values_csr;

Line 572: hr_utility.set_location('Entering:'|| l_input_value_id4, 1);

568: hr_utility.set_location('Entering:'|| l_element_type_id, 1);
569: hr_utility.set_location('Entering:'|| l_input_value_id1, 1);
570: hr_utility.set_location('Entering:'|| l_input_value_id2, 1);
571: hr_utility.set_location('Entering:'|| l_input_value_id3, 1);
572: hr_utility.set_location('Entering:'|| l_input_value_id4, 1);
573: hr_utility.set_location('Entering:'|| l_input_value_id5, 1);
574:
575: CLOSE input_values_csr;
576:

Line 573: hr_utility.set_location('Entering:'|| l_input_value_id5, 1);

569: hr_utility.set_location('Entering:'|| l_input_value_id1, 1);
570: hr_utility.set_location('Entering:'|| l_input_value_id2, 1);
571: hr_utility.set_location('Entering:'|| l_input_value_id3, 1);
572: hr_utility.set_location('Entering:'|| l_input_value_id4, 1);
573: hr_utility.set_location('Entering:'|| l_input_value_id5, 1);
574:
575: CLOSE input_values_csr;
576:
577: if g_debug then

Line 578: hr_utility.set_location('Leaving:'|| l_proc, 3);

574:
575: CLOSE input_values_csr;
576:
577: if g_debug then
578: hr_utility.set_location('Leaving:'|| l_proc, 3);
579: end if;
580:
581: if g_debug then
582: hr_utility.set_location('Entering:'|| l_proc, 4);

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

578: hr_utility.set_location('Leaving:'|| l_proc, 3);
579: end if;
580:
581: if g_debug then
582: hr_utility.set_location('Entering:'|| l_proc, 4);
583: end if;
584: -- insert records into pay_element_entries_f and pay_element_entry_values_f
585: OPEN cIsElementAttached(p_assignment_id , p_business_group_id , 'Tax' , p_effective_date);
586: FETCH cIsElementAttached INTO lrIsElementAttached;

Line 611: hr_utility.set_location('is element attached true:', 3);

607: ,p_element_entry_id => l_element_entry_id
608: ,p_object_version_number => l_ovn
609: ,p_create_warning => l_warning);
610: ELSE
611: hr_utility.set_location('is element attached true:', 3);
612:
613: -- Check if the record started today. If yes then
614: -- Change the datetrack mode to correction.
615: l_record_started_today := is_element_started_today(p_assignment_id, 'Tax', p_effective_date);

Line 706: hr_utility.set_location('EE a :'|| lrIsElementAttached.element_entry_id, 1);

702: ,p_entry_information28 => hr_api.g_varchar2
703: ,p_entry_information29 => hr_api.g_varchar2
704: ,p_entry_information30 => hr_api.g_varchar2);
705: ---------------------------------------------
706: hr_utility.set_location('EE a :'|| lrIsElementAttached.element_entry_id, 1);
707: END IF;
708: CLOSE cIsElementAttached;
709:
710: if g_debug then

Line 711: hr_utility.set_location('Leaving:'|| l_proc, 4);

707: END IF;
708: CLOSE cIsElementAttached;
709:
710: if g_debug then
711: hr_utility.set_location('Leaving:'|| l_proc, 4);
712: end if;
713:
714: if g_debug then
715: hr_utility.set_location('Leaving:'|| l_proc, 1);

Line 715: hr_utility.set_location('Leaving:'|| l_proc, 1);

711: hr_utility.set_location('Leaving:'|| l_proc, 4);
712: end if;
713:
714: if g_debug then
715: hr_utility.set_location('Leaving:'|| l_proc, 1);
716: end if;
717: -- Do not COMMIT here. COMMIT should be done thru the OAF Application only.
718: EXCEPTION
719: WHEN OTHERS THEN

Line 858: -- hr_utility.trace_on(null,'T123');

854: l_datetrack_update_mode VARCHAR2(255);
855: l_record_started_today BOOLEAN;
856: BEGIN
857: l_datetrack_update_mode := p_datetrack_update_mode;
858: -- hr_utility.trace_on(null,'T123');
859: if g_debug then
860: hr_utility.set_location('Entering:'|| l_proc, 1);
861: end if;
862: -- Check if the assignment is a primary Assignment.

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

856: BEGIN
857: l_datetrack_update_mode := p_datetrack_update_mode;
858: -- hr_utility.trace_on(null,'T123');
859: if g_debug then
860: hr_utility.set_location('Entering:'|| l_proc, 1);
861: end if;
862: -- Check if the assignment is a primary Assignment.
863: -- If 'Yes' then call update_taxcard and then update_tax
864: -- If 'No' then call only update_tax.

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

863: -- If 'Yes' then call update_taxcard and then update_tax
864: -- If 'No' then call only update_tax.
865: IF is_primary_asg(p_assignment_id , p_effective_date) = true THEN
866: if g_debug then
867: hr_utility.set_location('Entering:'|| l_proc, 2);
868: end if;
869: -- Get Primary Assignment Id for the given asg id.
870: -- and pass it to the update_taxcard procedure
871: OPEN cPrimaryAsg(p_assignment_id , p_effective_date);

Line 938: hr_utility.set_location('Leaving:'|| l_proc, 2);

934:
935:
936: END IF;
937: if g_debug then
938: hr_utility.set_location('Leaving:'|| l_proc, 2);
939: end if;
940: END IF;
941:
942: -- Update Tax Element if tax element already present. Otherwise insert

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

941:
942: -- Update Tax Element if tax element already present. Otherwise insert
943: -- the Tax Element.
944: if g_debug then
945: hr_utility.set_location('Entering:'|| l_proc, 3);
946: end if;
947: IF is_element_attached(p_assignment_id, p_business_group_id, 'Tax', p_effective_date) = true THEN
948: hr_utility.set_location('is element attached true:', 3);
949:

Line 948: hr_utility.set_location('is element attached true:', 3);

944: if g_debug then
945: hr_utility.set_location('Entering:'|| l_proc, 3);
946: end if;
947: IF is_element_attached(p_assignment_id, p_business_group_id, 'Tax', p_effective_date) = true THEN
948: hr_utility.set_location('is element attached true:', 3);
949:
950: -- Check if the record started today. If yes then
951: -- Change the datetrack mode to correction.
952: l_record_started_today := is_element_started_today(p_assignment_id, 'Tax', p_effective_date);

Line 980: hr_utility.set_location('is element attached false:', 3);

976: ,p_datetrack_update_mode => p_datetrack_update_mode
977: ,p_object_version_number => p_object_version_number_t);
978: ELSIF is_element_attached(p_assignment_id, p_business_group_id, 'Tax', p_effective_date) = false THEN
979: -- insert Tax Element.
980: hr_utility.set_location('is element attached false:', 3);
981: insert_tax (
982: p_legislation_code => p_legislation_code
983: ,p_effective_date => p_effective_date
984: ,p_assignment_id => p_assignment_id

Line 995: hr_utility.set_location('Leaving:'|| l_proc, 3);

991: ,p_extra_income_limit => p_extra_income_limit
992: ,p_prev_extra_income => p_prev_extra_income);
993: END IF;
994: if g_debug then
995: hr_utility.set_location('Leaving:'|| l_proc, 3);
996: end if;
997:
998: if g_debug then
999: hr_utility.set_location('Leaving:'|| l_proc, 1);

Line 999: hr_utility.set_location('Leaving:'|| l_proc, 1);

995: hr_utility.set_location('Leaving:'|| l_proc, 3);
996: end if;
997:
998: if g_debug then
999: hr_utility.set_location('Leaving:'|| l_proc, 1);
1000: end if;
1001: -- Do not COMMIT here. COMMIT should be done thru the OAF Application only.
1002:
1003: EXCEPTION

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

1104:
1105: l_proc varchar2(72) := g_package||'update_taxcard';
1106: BEGIN
1107: if g_debug then
1108: hr_utility.set_location('Entering:'|| l_proc, 1);
1109: end if;
1110:
1111: l_ovn := to_number(p_object_version_number);
1112:

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

1212: ,p_entry_information29 => hr_api.g_varchar2
1213: ,p_entry_information30 => hr_api.g_varchar2);
1214:
1215: if g_debug then
1216: hr_utility.set_location('Entering:'|| l_proc, 1);
1217: end if;
1218: -- Do not COMMIT here. COMMIT should be done from the OAF Application Only.
1219: EXCEPTION
1220: WHEN OTHERS THEN

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

1297:
1298: l_proc varchar2(72) := g_package||'update_tax';
1299: BEGIN
1300: if g_debug then
1301: hr_utility.set_location('Entering:'|| l_proc, 1);
1302: end if;
1303:
1304: l_ovn := to_number(p_object_version_number);
1305: --l_element_entry_id := find_element_entry_id(p_assignment_id, p_business_group_id,

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

1391: ,p_entry_information29 => hr_api.g_varchar2
1392: ,p_entry_information30 => hr_api.g_varchar2);
1393:
1394: if g_debug then
1395: hr_utility.set_location('Entering:'|| l_proc, 1);
1396: end if;
1397: -- Do not COMMIT here. COMMIT should be done from the OAF Application Only.
1398: EXCEPTION
1399: WHEN OTHERS THEN

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

1706: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
1707:
1708: BEGIN
1709: if g_debug then
1710: hr_utility.set_location('Entering:'|| l_proc, 1);
1711: end if;
1712: --
1713: -- Call the corresponding datetrack api
1714: --

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

1729: ,p_override_end_date => p_override_end_date
1730: ,p_upd_chg_start_date => p_upd_chg_start_date
1731: ,p_upd_chg_end_date => p_upd_chg_end_date);
1732: if g_debug then
1733: hr_utility.set_location('Entering:'|| l_proc, 2);
1734: end if;
1735: --
1736: --hr_utility.set_location(' Leaving:'||l_proc, 10);
1737: EXCEPTION

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

1732: if g_debug then
1733: hr_utility.set_location('Entering:'|| l_proc, 2);
1734: end if;
1735: --
1736: --hr_utility.set_location(' Leaving:'||l_proc, 10);
1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: RAISE;
1740: END find_dt_upd_modes;