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

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

130: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;
131:
132: BEGIN
133: -- if g_debug then
134: hr_utility.set_location('Entering:'|| l_proc, 1);
135: -- end if;
136: --Insert row into fnd_Sessions table.
137: OPEN CSR_CHECK_FND_SESSION;
138: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;

Line 145: hr_utility.set_location( l_proc, 10);

141: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);
142: END IF;
143: CLOSE CSR_CHECK_FND_SESSION;
144:
145: hr_utility.set_location( l_proc, 10);
146: -- fetch element link id from Swedish tax upload package
147: l_element_link_id := pay_se_tax_card.get_element_link_id(
148: p_assignment_id, p_business_group_id,
149: fnd_date.date_to_canonical(p_effective_date),

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

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

Line 160: hr_utility.set_location(l_proc, 3);

156: FETCH input_values_csr INTO l_element_type_id, l_input_value_id1, l_input_value_id2,
157: l_input_value_id3, l_input_value_id4, l_input_value_id5, l_input_value_id6,
158: l_input_value_id7, l_input_value_id8;
159: CLOSE input_values_csr;
160: hr_utility.set_location(l_proc, 3);
161:
162: -- if g_debug then
163: hr_utility.set_location( l_proc, 4);
164: -- end if;

Line 163: hr_utility.set_location( l_proc, 4);

159: CLOSE input_values_csr;
160: hr_utility.set_location(l_proc, 3);
161:
162: -- if g_debug then
163: hr_utility.set_location( l_proc, 4);
164: -- end if;
165: --all validations for swedish tax card are included here
166: --1. Method of Receipt: This will be always Manual
167: --2. Tax Card Type:

Line 184: hr_utility.set_location(l_proc, 5);

180: l_tax_column :=p_tax_column;
181: l_tax_table_number :=p_tax_table_number;
182: l_calculation_code :=p_calculation_code;
183: l_method_of_receipt :='M';
184: hr_utility.set_location(l_proc, 5);
185: IF (p_tax_card_type = 'A') THEN
186: IF (p_tax_table_number is null and p_tax_column is null and p_tax_percentage is null) THEN
187: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
188: hr_utility.raise_error;

Line 188: hr_utility.raise_error;

184: hr_utility.set_location(l_proc, 5);
185: IF (p_tax_card_type = 'A') THEN
186: IF (p_tax_table_number is null and p_tax_column is null and p_tax_percentage is null) THEN
187: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
188: hr_utility.raise_error;
189: ELSIF (p_tax_percentage is null AND (p_tax_table_number is null OR p_tax_column is null)) THEN
190: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
191: hr_utility.raise_error;
192: hr_utility.set_location(l_proc, 6);

Line 191: hr_utility.raise_error;

187: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
188: hr_utility.raise_error;
189: ELSIF (p_tax_percentage is null AND (p_tax_table_number is null OR p_tax_column is null)) THEN
190: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
191: hr_utility.raise_error;
192: hr_utility.set_location(l_proc, 6);
193: END IF;
194: ELSIF(p_tax_card_type = 'AF') THEN
195: IF (p_tax_table_number is null and p_tax_column is null and p_tax_percentage is null) THEN

Line 192: hr_utility.set_location(l_proc, 6);

188: hr_utility.raise_error;
189: ELSIF (p_tax_percentage is null AND (p_tax_table_number is null OR p_tax_column is null)) THEN
190: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
191: hr_utility.raise_error;
192: hr_utility.set_location(l_proc, 6);
193: END IF;
194: ELSIF(p_tax_card_type = 'AF') THEN
195: IF (p_tax_table_number is null and p_tax_column is null and p_tax_percentage is null) THEN
196: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');

Line 197: hr_utility.raise_error;

193: END IF;
194: ELSIF(p_tax_card_type = 'AF') THEN
195: IF (p_tax_table_number is null and p_tax_column is null and p_tax_percentage is null) THEN
196: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
197: hr_utility.raise_error;
198: hr_utility.set_location(l_proc, 7);
199: ELSIF (p_tax_percentage is null AND (p_tax_table_number is null OR p_tax_column is null)) THEN
200: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
201: hr_utility.raise_error;

Line 198: hr_utility.set_location(l_proc, 7);

194: ELSIF(p_tax_card_type = 'AF') THEN
195: IF (p_tax_table_number is null and p_tax_column is null and p_tax_percentage is null) THEN
196: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
197: hr_utility.raise_error;
198: hr_utility.set_location(l_proc, 7);
199: ELSIF (p_tax_percentage is null AND (p_tax_table_number is null OR p_tax_column is null)) THEN
200: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
201: hr_utility.raise_error;
202: hr_utility.set_location(l_proc, 8);

Line 201: hr_utility.raise_error;

197: hr_utility.raise_error;
198: hr_utility.set_location(l_proc, 7);
199: ELSIF (p_tax_percentage is null AND (p_tax_table_number is null OR p_tax_column is null)) THEN
200: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
201: hr_utility.raise_error;
202: hr_utility.set_location(l_proc, 8);
203: END IF;
204: ElSIF (p_tax_card_type = 'TFT') THEN
205: IF (p_tax_free_threshold is NULL) THEN

Line 202: hr_utility.set_location(l_proc, 8);

198: hr_utility.set_location(l_proc, 7);
199: ELSIF (p_tax_percentage is null AND (p_tax_table_number is null OR p_tax_column is null)) THEN
200: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
201: hr_utility.raise_error;
202: hr_utility.set_location(l_proc, 8);
203: END IF;
204: ElSIF (p_tax_card_type = 'TFT') THEN
205: IF (p_tax_free_threshold is NULL) THEN
206: fnd_message.set_name('PER','HR_377233_SE_TFT_PERCENTAGE');

Line 207: hr_utility.raise_error;

203: END IF;
204: ElSIF (p_tax_card_type = 'TFT') THEN
205: IF (p_tax_free_threshold is NULL) THEN
206: fnd_message.set_name('PER','HR_377233_SE_TFT_PERCENTAGE');
207: hr_utility.raise_error;
208:
209: ELSE
210: l_calculation_sum :=null;
211: l_tax_column := null;

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

244: l_tax_percentage := p_tax_percentage;
245: END IF;*/
246:
247: if g_debug then
248: hr_utility.set_location('Entering:'|| l_proc, 4);
249: end if;
250: -- insert records into pay_element_entries_f and pay_element_entry_values_f
251: pay_element_entry_api.create_element_entry
252: (p_effective_date => p_effective_date

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

277: ,p_create_warning => l_warning
278: );
279:
280: if g_debug then
281: hr_utility.set_location('Entering:'|| l_proc, 5);
282: end if;
283: -- Do not COMMIT here. COMMIT should be done thru the OAF Application only.
284: EXCEPTION
285: WHEN OTHERS THEN

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

396:
397: l_proc varchar2(72) := g_package||'update_taxcard';
398: BEGIN
399: if g_debug then
400: hr_utility.set_location('Entering:'|| l_proc, 1);
401: end if;
402:
403: --l_start_date := sysdate;
404: l_element_entry_id := to_number(p_element_entry_id);

Line 430: hr_utility.raise_error;

426:
427: IF (p_tax_card_type = 'A') THEN
428: IF (p_tax_table_number is null and p_tax_column is null and p_tax_percentage is null) THEN
429: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
430: hr_utility.raise_error;
431: ELSIF (p_tax_percentage = null AND (p_tax_table_number = null OR p_tax_column = null)) THEN
432: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
433: hr_utility.raise_error;
434: END IF;

Line 433: hr_utility.raise_error;

429: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
430: hr_utility.raise_error;
431: ELSIF (p_tax_percentage = null AND (p_tax_table_number = null OR p_tax_column = null)) THEN
432: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
433: hr_utility.raise_error;
434: END IF;
435: ELSIF(p_tax_card_type = 'AF') THEN
436: IF (p_tax_table_number is null and p_tax_column is null and p_tax_percentage is null) THEN
437: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');

Line 438: hr_utility.raise_error;

434: END IF;
435: ELSIF(p_tax_card_type = 'AF') THEN
436: IF (p_tax_table_number is null and p_tax_column is null and p_tax_percentage is null) THEN
437: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
438: hr_utility.raise_error;
439: ELSIF (p_tax_percentage is null AND (p_tax_table_number is null OR p_tax_column is null)) THEN
440: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
441: hr_utility.raise_error;
442: END IF;

Line 441: hr_utility.raise_error;

437: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
438: hr_utility.raise_error;
439: ELSIF (p_tax_percentage is null AND (p_tax_table_number is null OR p_tax_column is null)) THEN
440: fnd_message.set_name('PER','HR_377232_SE_ATAXC_MAN_FIELDS');
441: hr_utility.raise_error;
442: END IF;
443: ElSIF (p_tax_card_type = 'TFT') THEN
444: IF (p_tax_free_threshold is NULL) THEN
445: fnd_message.set_name('PER','HR_377233_SE_TFT_PERCENTAGE');

Line 446: hr_utility.raise_error;

442: END IF;
443: ElSIF (p_tax_card_type = 'TFT') THEN
444: IF (p_tax_free_threshold is NULL) THEN
445: fnd_message.set_name('PER','HR_377233_SE_TFT_PERCENTAGE');
446: hr_utility.raise_error;
447:
448: ELSE
449: l_calculation_sum :=null;
450: l_tax_column := null;

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

484: l_tax_percentage := p_tax_percentage;
485: END IF; */
486:
487: if g_debug then
488: hr_utility.set_location('Entering:'|| l_proc, 2);
489: end if;
490:
491: -- insert records into pay_element_entries_f and pay_element_entry_values_f
492:

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

580: ,p_entry_information29 => hr_api.g_varchar2
581: ,p_entry_information30 => hr_api.g_varchar2);
582:
583: if g_debug then
584: hr_utility.set_location('Entering:'|| l_proc, 3);
585: end if;
586: -- Do not COMMIT here. COMMIT should be done from the OAF Application Only.
587: EXCEPTION
588: WHEN OTHERS THEN

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

655: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
656:
657: BEGIN
658: if g_debug then
659: hr_utility.set_location('Entering:'|| l_proc, 1);
660: end if;
661: --
662: -- Call the corresponding datetrack api
663: --

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

678: ,p_override_end_date => p_override_end_date
679: ,p_upd_chg_start_date => p_upd_chg_start_date
680: ,p_upd_chg_end_date => p_upd_chg_end_date);
681: if g_debug then
682: hr_utility.set_location('Entering:'|| l_proc, 2);
683: end if;
684: --
685: --hr_utility.set_location(' Leaving:'||l_proc, 10);
686: EXCEPTION

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

681: if g_debug then
682: hr_utility.set_location('Entering:'|| l_proc, 2);
683: end if;
684: --
685: --hr_utility.set_location(' Leaving:'||l_proc, 10);
686: EXCEPTION
687: WHEN OTHERS THEN
688: RAISE;
689: END find_dt_upd_modes;

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

735: l_proc varchar2(72) := g_package||'get_global_value';
736:
737: BEGIN
738: if g_debug then
739: hr_utility.set_location('Entering:'|| l_proc, 1);
740: end if;
741:
742: OPEN csr_globals;
743: FETCH csr_globals INTO l_global_value;

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

743: FETCH csr_globals INTO l_global_value;
744: CLOSE csr_globals;
745:
746: if g_debug then
747: hr_utility.set_location('Entering:'|| l_proc, 2);
748: end if;
749:
750: RETURN l_global_value;
751: END get_global_value;