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

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

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

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

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

Line 116: hr_utility.set_message(801, 'HR_51456_PPM_RETURN_DATE_NULL');

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

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

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

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

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

Line 119: hr_utility.raise_error;

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

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

280: p_rec.ppm_information30
281: );
282: --
283: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
284: hr_utility.set_location(' Leaving:'||l_proc, 15);
285: --
286: Exception
287: When hr_api.check_integrity_violated Then
288: -- A check constraint has been violated

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

311: --
312: l_proc varchar2(72) := g_package||'insert_dml';
313: --
314: Begin
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: dt_insert_dml(p_rec => p_rec,
318: p_effective_date => p_effective_date,
319: p_datetrack_mode => p_datetrack_mode,

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

319: p_datetrack_mode => p_datetrack_mode,
320: p_validation_start_date => p_validation_start_date,
321: p_validation_end_date => p_validation_end_date);
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: End insert_dml;
325: --
326: -- ----------------------------------------------------------------------------
327: -- |------------------------------< pre_insert >------------------------------|

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

373: --
374: Cursor C_Sel1 is select pay_personal_payment_methods_s.nextval from sys.dual;
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: --
380: -- Select the next sequence number
381: --

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

390: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
391: p_source_table_name => 'PAY_PERSONAL_PAYMENT_METHODS_F',
392: p_comment_text => p_rec.comments);
393: End If;
394: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: End pre_insert;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |-----------------------------< post_insert >------------------------------|

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

435: --
436: l_proc varchar2(72) := g_package||'post_insert';
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440: --
441: -- Start of API User Hook for post_insert.
442: begin
443: pay_ppm_rki.after_insert

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

519: );
520: end;
521: -- End of API User Hook for post_insert.
522: --
523: hr_utility.set_location(' Leaving:'||l_proc, 10);
524: End post_insert;
525: --
526: -- ----------------------------------------------------------------------------
527: -- |-------------------------------< ins_lck >--------------------------------|

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

541: l_validation_start_date1 date;
542: l_validation_end_date1 date;
543: --
544: Begin
545: hr_utility.set_location('Entering:'||l_proc, 5);
546: begin
547: --
548: -- Need to validate against PAY_ORG_PAYMENT_METHODS_F and
549: -- PAY_ORG_PAY_METHOD_USAGES_F so lock in SHARE mode. This is because the

Line 565: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

561: --
562: -- The object is locked therefore we need to supply a meaningful
563: -- error message.
564: --
565: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
566: hr_utility.set_message_token('TABLE_NAME', l_lock_table);
567: hr_utility.raise_error;
568: end;
569: --

Line 566: hr_utility.set_message_token('TABLE_NAME', l_lock_table);

562: -- The object is locked therefore we need to supply a meaningful
563: -- error message.
564: --
565: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
566: hr_utility.set_message_token('TABLE_NAME', l_lock_table);
567: hr_utility.raise_error;
568: end;
569: --
570: hr_utility.set_location(l_proc, 10);

Line 567: hr_utility.raise_error;

563: -- error message.
564: --
565: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
566: hr_utility.set_message_token('TABLE_NAME', l_lock_table);
567: hr_utility.raise_error;
568: end;
569: --
570: hr_utility.set_location(l_proc, 10);
571: --

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

566: hr_utility.set_message_token('TABLE_NAME', l_lock_table);
567: hr_utility.raise_error;
568: end;
569: --
570: hr_utility.set_location(l_proc, 10);
571: --
572: -- Validate the datetrack mode mode getting the validation start
573: -- and end dates for the specified datetrack operation.
574: --

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

613: greatest(l_validation_start_date, l_validation_start_date1);
614: p_validation_end_date :=
615: least(l_validation_end_date, l_validation_end_date1);
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 15);
618: --
619: End ins_lck;
620: --
621: -- ----------------------------------------------------------------------------

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

633: l_validation_start_date date;
634: l_validation_end_date date;
635: --
636: Begin
637: hr_utility.set_location('Entering:'||l_proc, 5);
638: --
639: -- Determine if the business process is to be validated.
640: --
641: If p_validate then

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

710: If p_validate then
711: Raise HR_Api.Validate_Enabled;
712: End If;
713: --
714: hr_utility.set_location(' Leaving:'||l_proc, 10);
715: Exception
716: When HR_Api.Validate_Enabled Then
717: --
718: -- As the Validate_Enabled exception has been raised

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

801: l_rec pay_ppm_shd.g_rec_type;
802: l_proc varchar2(72) := g_package||'ins';
803: --
804: Begin
805: hr_utility.set_location('Entering:'||l_proc, 5);
806: --
807: -- Call conversion function to turn arguments into the
808: -- p_rec structure.
809: --

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

893: p_effective_end_date := l_rec.effective_end_date;
894: p_object_version_number := l_rec.object_version_number;
895: p_comment_id := l_rec.comment_id;
896: --
897: hr_utility.set_location(' Leaving:'||l_proc, 10);
898: End ins;
899: --
900: end pay_ppm_ins;