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_CPT_INS dependencies on HR_UTILITY

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

79: l_last_updated_by pay_ca_emp_prov_tax_info_f.last_updated_by%TYPE;
80: l_last_update_login pay_ca_emp_prov_tax_info_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=

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

99: -- If the datetrack_mode is not INSERT then we must populate the WHO
100: -- columns with the 'old' creation values and 'new' updated values.
101: --
102: If (p_datetrack_mode <> 'INSERT') then
103: hr_utility.set_location(l_proc, 10);
104: --
105: -- Select the 'old' created values
106: --
107: Open C_Sel1;

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

111: -- The previous 'old' created row has not been found. We need
112: -- to error as an internal datetrack problem exists.
113: --
114: Close C_Sel1;
115: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
116: hr_utility.set_message_token('PROCEDURE', l_proc);
117: hr_utility.set_message_token('STEP','10');
118: hr_utility.raise_error;
119: End If;

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

112: -- to error as an internal datetrack problem exists.
113: --
114: Close C_Sel1;
115: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
116: hr_utility.set_message_token('PROCEDURE', l_proc);
117: hr_utility.set_message_token('STEP','10');
118: hr_utility.raise_error;
119: End If;
120: Close C_Sel1;

Line 117: hr_utility.set_message_token('STEP','10');

113: --
114: Close C_Sel1;
115: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
116: hr_utility.set_message_token('PROCEDURE', l_proc);
117: hr_utility.set_message_token('STEP','10');
118: hr_utility.raise_error;
119: End If;
120: Close C_Sel1;
121: --

Line 118: hr_utility.raise_error;

114: Close C_Sel1;
115: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
116: hr_utility.set_message_token('PROCEDURE', l_proc);
117: hr_utility.set_message_token('STEP','10');
118: hr_utility.raise_error;
119: End If;
120: Close C_Sel1;
121: --
122: -- Set the AOL updated WHO values

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

273: p_rec.ppip_exempt_flag
274: );
275: --
276: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
277: hr_utility.set_location(' Leaving:'||l_proc, 15);
278: --
279: Exception
280: When hr_api.check_integrity_violated Then
281: -- A check constraint has been violated

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

304: --
305: l_proc varchar2(72) := g_package||'insert_dml';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: dt_insert_dml(p_rec => p_rec,
311: p_effective_date => p_effective_date,
312: p_datetrack_mode => p_datetrack_mode,

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

312: p_datetrack_mode => p_datetrack_mode,
313: p_validation_start_date => p_validation_start_date,
314: p_validation_end_date => p_validation_end_date);
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 10);
317: End insert_dml;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |------------------------------< pre_insert >------------------------------|

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

366: --
367: Cursor C_Sel1 is select pay_ca_emp_prov_tax_info_s.nextval from sys.dual;
368: --
369: Begin
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: --
373: -- Select the next sequence number
374: --

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

376: Fetch C_Sel1 Into p_rec.emp_province_tax_inf_id;
377: Close C_Sel1;
378: --
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 10);
381: End pre_insert;
382: --
383: -- ----------------------------------------------------------------------------
384: -- |-----------------------------< post_insert >------------------------------|

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

421: --
422: l_proc varchar2(72) := g_package||'post_insert';
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --
427: --
428: -- Start of API User Hook for post_insert.
429: --

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

512: --
513: -- End of API User Hook for post_insert.
514: --
515: --
516: hr_utility.set_location(' Leaving:'||l_proc, 10);
517: End post_insert;
518: --
519: -- ----------------------------------------------------------------------------
520: -- |-------------------------------< ins_lck >--------------------------------|

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

564: l_validation_start_date date;
565: l_validation_end_date date;
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- Validate the datetrack mode mode getting the validation start
571: -- and end dates for the specified datetrack operation.
572: --

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

587: --
588: p_validation_start_date := l_validation_start_date;
589: p_validation_end_date := l_validation_end_date;
590: --
591: hr_utility.set_location(' Leaving:'||l_proc, 10);
592: --
593: End ins_lck;
594: --
595: -- ----------------------------------------------------------------------------

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

606: l_validation_start_date date;
607: l_validation_end_date date;
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);
611: --
612: -- Call the lock operation
613: --
614: ins_lck

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

737: from per_assignments_f asg
738: where asg.assignment_id = asg_id;
739: --
740: Begin
741: hr_utility.set_location('Entering:'||l_proc, 5);
742: --
743: -- Call conversion function to turn arguments into the
744: -- p_rec structure.
745: --

Line 757: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');

753: -- raise error as assignment_id not found in per_assignments_f
754: -- table.
755: --
756: --dbms_output.put_line('in assignment_id 6');
757: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');
758: hr_utility.raise_error;
759: else
760: -- p_effective_date := l_effective_date;
761: close c1;

Line 758: hr_utility.raise_error;

754: -- table.
755: --
756: --dbms_output.put_line('in assignment_id 6');
757: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');
758: hr_utility.raise_error;
759: else
760: -- p_effective_date := l_effective_date;
761: close c1;
762: end if;

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

845: p_effective_end_date := l_rec.effective_end_date;
846: p_object_version_number := l_rec.object_version_number;
847: --
848: --
849: hr_utility.set_location(' Leaving:'||l_proc, 10);
850: End ins;
851: --
852: end pay_cpt_ins;