DBA Data[Home] [Help]

APPS.PAY_CFT_INS dependencies on HR_UTILITY

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

79: l_last_updated_by pay_ca_emp_fed_tax_info_f.last_updated_by%TYPE;
80: l_last_update_login pay_ca_emp_fed_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 259: hr_utility.set_location(' Leaving:'||l_proc, 15);

255: l_last_update_login
256: );
257: --
258: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
259: hr_utility.set_location(' Leaving:'||l_proc, 15);
260: --
261: Exception
262: When hr_api.check_integrity_violated Then
263: -- A check constraint has been violated

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

286: --
287: l_proc varchar2(72) := g_package||'insert_dml';
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: dt_insert_dml(p_rec => p_rec,
293: p_effective_date => p_effective_date,
294: p_datetrack_mode => p_datetrack_mode,

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

294: p_datetrack_mode => p_datetrack_mode,
295: p_validation_start_date => p_validation_start_date,
296: p_validation_end_date => p_validation_end_date);
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 10);
299: End insert_dml;
300: --
301: -- ----------------------------------------------------------------------------
302: -- |------------------------------< pre_insert >------------------------------|

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

348: --
349: Cursor C_Sel1 is select pay_ca_emp_fed_tax_info_s.nextval from sys.dual;
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: --
355: -- Select the next sequence number
356: --

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

358: Fetch C_Sel1 Into p_rec.emp_fed_tax_inf_id;
359: Close C_Sel1;
360: --
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 10);
363: End pre_insert;
364: --
365: -- ----------------------------------------------------------------------------
366: -- |-----------------------------< post_insert >------------------------------|

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

403: --
404: l_proc varchar2(72) := g_package||'post_insert';
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: --
410: -- Start of API User Hook for post_insert.
411: --

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

485: --
486: -- End of API User Hook for post_insert.
487: --
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 10);
490: End post_insert;
491: --
492: -- ----------------------------------------------------------------------------
493: -- |-------------------------------< ins_lck >--------------------------------|

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

537: l_validation_start_date date;
538: l_validation_end_date date;
539: --
540: Begin
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- Validate the datetrack mode mode getting the validation start
544: -- and end dates for the specified datetrack operation.
545: --

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

560: --
561: p_validation_start_date := l_validation_start_date;
562: p_validation_end_date := l_validation_end_date;
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 10);
565: --
566: End ins_lck;
567: --
568: -- ----------------------------------------------------------------------------

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

579: l_validation_start_date date;
580: l_validation_end_date date;
581: --
582: Begin
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Call the lock operation
586: --
587: ins_lck

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

704: from per_assignments_f asg
705: where asg.assignment_id = asg_id;
706:
707: Begin
708: hr_utility.set_location('Entering:'||l_proc, 5);
709: --
710: -- Call conversion function to turn arguments into the
711: -- p_rec structure.
712: --

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

722: -- raise error as assignment_id not found in per_assignments_f
723: -- table.
724: --
725: --dbms_output.put_line('in assignment_id 6');
726: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');
727: hr_utility.raise_error;
728: else
729: -- p_effective_date := l_effective_date;
730: close c1;

Line 727: hr_utility.raise_error;

723: -- table.
724: --
725: --dbms_output.put_line('in assignment_id 6');
726: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');
727: hr_utility.raise_error;
728: else
729: -- p_effective_date := l_effective_date;
730: close c1;
731: end if;

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

805: p_effective_end_date := l_rec.effective_end_date;
806: p_object_version_number := l_rec.object_version_number;
807: --
808: --
809: hr_utility.set_location(' Leaving:'||l_proc, 10);
810: End ins;
811: --
812: end pay_cft_ins;