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

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

245: and p_effective_date
246: between pet.effective_start_date and pet.effective_end_date;
247: --
248: Begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- Call the corresponding datetrack api
252: --
253: dt_api.find_dt_upd_modes

Line 273: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

269: Open C_chk_type;
270: Fetch C_chk_type Into l_type;
271: If C_chk_type%notfound then
272: Close C_chk_type;
273: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
274: hr_utility.set_message_token('PROCEDURE', l_proc);
275: hr_utility.set_message_token('STEP','5');
276: hr_utility.raise_error;
277: End If;

Line 274: hr_utility.set_message_token('PROCEDURE', l_proc);

270: Fetch C_chk_type Into l_type;
271: If C_chk_type%notfound then
272: Close C_chk_type;
273: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
274: hr_utility.set_message_token('PROCEDURE', l_proc);
275: hr_utility.set_message_token('STEP','5');
276: hr_utility.raise_error;
277: End If;
278: Close C_chk_type;

Line 275: hr_utility.set_message_token('STEP','5');

271: If C_chk_type%notfound then
272: Close C_chk_type;
273: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
274: hr_utility.set_message_token('PROCEDURE', l_proc);
275: hr_utility.set_message_token('STEP','5');
276: hr_utility.raise_error;
277: End If;
278: Close C_chk_type;
279: --

Line 276: hr_utility.raise_error;

272: Close C_chk_type;
273: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
274: hr_utility.set_message_token('PROCEDURE', l_proc);
275: hr_utility.set_message_token('STEP','5');
276: hr_utility.raise_error;
277: End If;
278: Close C_chk_type;
279: --
280: if l_type = 'N' then

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

282: p_update_override := FALSE;
283: p_update_change_insert := FALSE;
284: end if;
285: --
286: hr_utility.set_location(' Leaving:'||l_proc, 10);
287: End find_dt_upd_modes;
288: --
289: -- ----------------------------------------------------------------------------
290: -- |---------------------------< find_dt_del_modes >--------------------------|

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

328: and p_effective_date
329: between pet.effective_start_date and pet.effective_end_date;
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: Open C_sel1;
334: Fetch C_Sel1 Into
335: l_parent_key_value1
336: ,l_parent_key_value2;

Line 375: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

371: Open C_chk_type;
372: Fetch C_chk_type Into l_type;
373: If C_chk_type%notfound then
374: Close C_chk_type;
375: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
376: hr_utility.set_message_token('PROCEDURE', l_proc);
377: hr_utility.set_message_token('STEP','5');
378: hr_utility.raise_error;
379: End If;

Line 376: hr_utility.set_message_token('PROCEDURE', l_proc);

372: Fetch C_chk_type Into l_type;
373: If C_chk_type%notfound then
374: Close C_chk_type;
375: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
376: hr_utility.set_message_token('PROCEDURE', l_proc);
377: hr_utility.set_message_token('STEP','5');
378: hr_utility.raise_error;
379: End If;
380: Close C_chk_type;

Line 377: hr_utility.set_message_token('STEP','5');

373: If C_chk_type%notfound then
374: Close C_chk_type;
375: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
376: hr_utility.set_message_token('PROCEDURE', l_proc);
377: hr_utility.set_message_token('STEP','5');
378: hr_utility.raise_error;
379: End If;
380: Close C_chk_type;
381: --

Line 378: hr_utility.raise_error;

374: Close C_chk_type;
375: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
376: hr_utility.set_message_token('PROCEDURE', l_proc);
377: hr_utility.set_message_token('STEP','5');
378: hr_utility.raise_error;
379: End If;
380: Close C_chk_type;
381: --
382: if l_type = 'N' then

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

384: p_future_change := FALSE;
385: p_delete_next_change := FALSE;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 10);
389: End find_dt_del_modes;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |-----------------------< upd_effective_end_date >-------------------------|

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

403: l_proc varchar2(72) := g_package||'upd_effective_end_date';
404: l_object_version_number number;
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: -- Because we are updating a row we must get the next object
410: -- version number.
411: --

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

415: ,p_base_key_column => 'element_entry_id'
416: ,p_base_key_value => p_base_key_value
417: );
418: --
419: hr_utility.set_location(l_proc, 10);
420: pay_ele_shd.g_api_dml := true; -- Set the api dml status
421: --
422: -- Update the specified datetrack row setting the effective
423: -- end date to the specified new effective end date.

Line 434: hr_utility.set_location(' Leaving:'||l_proc, 15);

430: between t.effective_start_date and t.effective_end_date;
431: --
432: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
433: p_object_version_number := l_object_version_number;
434: hr_utility.set_location(' Leaving:'||l_proc, 15);
435: --
436: Exception
437: When Others Then
438: pay_ele_shd.g_api_dml := false; -- Unset the api dml status

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

566: for update nowait;
567: --
568:
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Ensure that all the mandatory arguments are not null
573: --
574: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 594: hr_utility.set_location('done arg error check'||l_proc, 51);

590: ,p_argument => 'object_version_number'
591: ,p_argument_value => p_object_version_number
592: );
593:
594: hr_utility.set_location('done arg error check'||l_proc, 51);
595:
596: --
597: -- Check to ensure the datetrack mode is not INSERT.
598: --

Line 615: hr_utility.set_location('Entering ovn check:'||l_proc, 52);

611: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
612: fnd_message.raise_error;
613: End If;
614: Close C_Sel1;
615: hr_utility.set_location('Entering ovn check:'||l_proc, 52);
616:
617: If (p_object_version_number
618: <> pay_ele_shd.g_old_rec.object_version_number) Then
619: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

Line 698: hr_utility.set_location(' Leaving:'||l_proc, 30);

694: --
695: p_validation_start_date := l_validation_start_date;
696: p_validation_end_date := l_validation_end_date;
697: --
698: hr_utility.set_location(' Leaving:'||l_proc, 30);
699: --
700: -- We need to trap the ORA LOCK exception
701: --
702: Exception

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

734: l_meaning varchar2(240) := NULL;
735: l_value_set_id number(10) := NULL;
736: --
737: BEGIN
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: -- Validate the length of the entry
741: --
742: IF LENGTH(p_entry_value) > 60 THEN

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

739: --
740: -- Validate the length of the entry
741: --
742: IF LENGTH(p_entry_value) > 60 THEN
743: hr_utility.set_location('Entering:'||l_proc, 7);
744: hr_utility.set_message(801, 'HR_7049_ELE_ENTRY_LENGTH');
745: hr_utility.raise_error;
746: END IF;
747: --

Line 744: hr_utility.set_message(801, 'HR_7049_ELE_ENTRY_LENGTH');

740: -- Validate the length of the entry
741: --
742: IF LENGTH(p_entry_value) > 60 THEN
743: hr_utility.set_location('Entering:'||l_proc, 7);
744: hr_utility.set_message(801, 'HR_7049_ELE_ENTRY_LENGTH');
745: hr_utility.raise_error;
746: END IF;
747: --
748: hr_utility.set_location('Entering:'||l_proc, 9);

Line 745: hr_utility.raise_error;

741: --
742: IF LENGTH(p_entry_value) > 60 THEN
743: hr_utility.set_location('Entering:'||l_proc, 7);
744: hr_utility.set_message(801, 'HR_7049_ELE_ENTRY_LENGTH');
745: hr_utility.raise_error;
746: END IF;
747: --
748: hr_utility.set_location('Entering:'||l_proc, 9);
749: OPEN C_Lookup;

Line 748: hr_utility.set_location('Entering:'||l_proc, 9);

744: hr_utility.set_message(801, 'HR_7049_ELE_ENTRY_LENGTH');
745: hr_utility.raise_error;
746: END IF;
747: --
748: hr_utility.set_location('Entering:'||l_proc, 9);
749: OPEN C_Lookup;
750: FETCH C_Lookup
751: INTO l_lookup_type, l_value_set_id;
752: IF l_lookup_type IS NOT NULL THEN

Line 753: hr_utility.set_location('Entering:'||l_proc, 11);

749: OPEN C_Lookup;
750: FETCH C_Lookup
751: INTO l_lookup_type, l_value_set_id;
752: IF l_lookup_type IS NOT NULL THEN
753: hr_utility.set_location('Entering:'||l_proc, 11);
754: l_meaning := hr_general.decode_lookup(l_lookup_type, p_entry_value);
755: --
756: IF l_meaning IS NULL THEN
757: --

Line 762: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');

758: -- Bugfix 2678606
759: -- No matching meaning was found, therefore entry value must be
760: -- invalid. Raise appropriate error
761: --
762: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
763: hr_utility.set_message_token('LOOKUP_TYPE',l_lookup_type);
764: hr_utility.raise_error;
765: --
766: END IF;

Line 763: hr_utility.set_message_token('LOOKUP_TYPE',l_lookup_type);

759: -- No matching meaning was found, therefore entry value must be
760: -- invalid. Raise appropriate error
761: --
762: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
763: hr_utility.set_message_token('LOOKUP_TYPE',l_lookup_type);
764: hr_utility.raise_error;
765: --
766: END IF;
767: --

Line 764: hr_utility.raise_error;

760: -- invalid. Raise appropriate error
761: --
762: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
763: hr_utility.set_message_token('LOOKUP_TYPE',l_lookup_type);
764: hr_utility.raise_error;
765: --
766: END IF;
767: --
768: ELSIF l_value_set_id IS NOT NULL THEN

Line 773: hr_utility.set_location('Entering:'||l_proc, 12);

769: --
770: -- Enhancement 2793978
771: -- Convert value set value
772: --
773: hr_utility.set_location('Entering:'||l_proc, 12);
774: l_meaning := pay_input_values_pkg.decode_vset_value(
775: l_value_set_id,
776: p_entry_value);
777: --

Line 783: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');

779: --
780: -- No matching meaning was found, therefore entry value must be
781: -- invalid. Raise appropriate error.
782: --
783: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');
784: hr_utility.set_message_token('VALUE',p_entry_value);
785: hr_utility.raise_error;
786: --
787: END IF;

Line 784: hr_utility.set_message_token('VALUE',p_entry_value);

780: -- No matching meaning was found, therefore entry value must be
781: -- invalid. Raise appropriate error.
782: --
783: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');
784: hr_utility.set_message_token('VALUE',p_entry_value);
785: hr_utility.raise_error;
786: --
787: END IF;
788: --

Line 785: hr_utility.raise_error;

781: -- invalid. Raise appropriate error.
782: --
783: hr_utility.set_message(800, 'HR_34927_ELE_ENTRY_VSET_INVLD');
784: hr_utility.set_message_token('VALUE',p_entry_value);
785: hr_utility.raise_error;
786: --
787: END IF;
788: --
789: ELSE

Line 795: hr_utility.set_location(' Leaving:'||l_proc, 20);

791: END IF;
792: CLOSE C_Lookup;
793: --
794: RETURN(l_meaning);
795: hr_utility.set_location(' Leaving:'||l_proc, 20);
796: --
797: END convert_lookups;
798: --
799: -- ----------------------------------------------------------------------------