DBA Data[Home] [Help]

APPS.PER_ADD_INS dependencies on HR_UTILITY

Line 24: hr_utility.set_location('Entering:'||l_proc, 10);

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_add_ins.g_address_id_i := p_address_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_add_ins.g_address_id_i := p_address_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31:
32: --

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

77: --
78: l_proc varchar2(72) := g_package||'insert_dml';
79: --
80: Begin
81: hr_utility.set_location('Entering:'||l_proc, 5);
82: p_rec.object_version_number := 1; -- Initialise the object version
83: --
84: per_add_shd.g_api_dml := true; -- Set the api dml status
85: --

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

207: );
208: --
209: per_add_shd.g_api_dml := false; -- Unset the api dml status
210: --
211: hr_utility.set_location(' Leaving:'||l_proc, 10);
212: Exception
213: When hr_api.check_integrity_violated Then
214: -- A check constraint has been violated
215: per_add_shd.g_api_dml := false; -- Unset the api dml status

Line 291: hr_utility.set_location('Entering:'||l_proc, 10);

287: l_package_exists boolean;
288: l_package_name varchar2(2000);
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 10);
292: --
293: if per_add_ins.g_address_id_i is not null then
294: --
295: -- Verify registered primary key values not already in use

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

320: Fetch C_Sel1 Into p_rec.address_id;
321: Close C_Sel1;
322: end if;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: --
326: -- Enhancement added for Location Searching
327: --
328: hr_utility.set_location(' Entering:'||l_proc, 11);

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

324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: --
326: -- Enhancement added for Location Searching
327: --
328: hr_utility.set_location(' Entering:'||l_proc, 11);
329: if( (fnd_profile.value('IRC_INSTALLED_FLAG') in ('Y','D')) and
330: (fnd_profile.value('IRC_GEOCODE_HOST')is not null)
331: ) then
332: p_rec.geometry := Irc_location_utility.address2geometry

Line 344: hr_utility.set_location(' Leaving:'||l_proc, 12);

340: ,address_line8 => p_rec.postal_code
341: ,country => p_rec.country
342: );
343: end if;
344: hr_utility.set_location(' Leaving:'||l_proc, 12);
345: -- Set taxation address defaults
346:
347: begin -- Block begin .Bug# 2416832
348: --

Line 349: hr_utility.set_location('Entering:'||l_proc, 15);

345: -- Set taxation address defaults
346:
347: begin -- Block begin .Bug# 2416832
348: --
349: hr_utility.set_location('Entering:'||l_proc, 15);
350: If p_rec.style = 'US' and
351: p_rec.primary_flag = 'Y'and
352: p_rec.add_information17 IS NULL and
353: p_rec.add_information18 IS NULL and

Line 357: hr_utility.set_location('Entering:'||l_proc, 17);

353: p_rec.add_information18 IS NULL and
354: p_rec.add_information19 IS NULL and
355: p_rec.add_information20 IS NULL
356: Then
357: hr_utility.set_location('Entering:'||l_proc, 17);
358: --
359: -- Bug 3363711 Starts Here
360: --
361: l_date := TO_DATE('01/01/'||(TO_CHAR(p_rec.date_from,'YYYY')),

Line 412: hr_utility.set_location(' Leaving:'||l_proc, 17);

408: nvl(date_to, TO_DATE('31/12/4712', 'DD/MM/YYYY')) and
409: region_2 = 'IN';
410: End if;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 17);
413: End if;
414: --
415: EXCEPTION
416: WHEN NO_DATA_FOUND THEN

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

422: end; -- Block end. Bug# 2416832
423: --
424: per_add_shd.derive_locale(p_rec);
425: --
426: hr_utility.set_location(' Leaving:'||l_proc, 15);
427: End pre_insert;
428: --
429: -- ----------------------------------------------------------------------------
430: -- |-----------------------------< post_insert >------------------------------|

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

474: --
475: -- End of Fix for WWBUG 1408379
476: --
477: Begin
478: hr_utility.set_location('Entering:'||l_proc, 5);
479: --
480: -- Start of API User Hook for post_insert.
481: begin
482: per_add_rki.after_insert

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

566: -- End of Fix for WWBUG 1408379
567: --
568: -- End of API User Hook for post_insert.
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 10);
571: End post_insert;
572: --
573: -- ----------------------------------------------------------------------------
574: -- |---------------------------------< ins >----------------------------------|

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

582: --
583: l_proc varchar2(72) := g_package||'ins';
584: --
585: Begin
586: hr_utility.set_location('Entering:'||l_proc, 5);
587: --
588: -- Determine if the business process is to be validated.
589: --
590: If p_validate then

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

626: If p_validate then
627: Raise HR_Api.Validate_Enabled;
628: End If;
629: --
630: hr_utility.set_location(' Leaving:'||l_proc, 10);
631: Exception
632: When HR_Api.Validate_Enabled Then
633: --
634: -- As the Validate_Enabled exception has been raised

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

705: l_rec per_add_shd.g_rec_type;
706: l_proc varchar2(72) := g_package||'ins';
707: --
708: Begin
709: hr_utility.set_location('Entering:'||l_proc, 5);
710: --
711: -- Call conversion function to turn arguments into the
712: -- p_rec structure.
713: --

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

786: --
787: p_address_id := l_rec.address_id;
788: p_object_version_number := l_rec.object_version_number;
789: --
790: hr_utility.set_location(' Leaving:'||l_proc, 10);
791: End ins;
792: --
793: end per_add_ins;