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

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

49: l_proc varchar2(72) := 'OTA_TDB_BUS2 '||'check_person_address';
50: l_dummy varchar2(1);
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: if p_person_id is not null and p_address_id is not null then
56: --
57: open c_address;

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

69: close c_address;
70: --
71: end if;
72: --
73: hr_utility.set_location(' Leaving:'||l_proc, 10);
74: End check_person_address;
75: -- ----------------------------------------------------------------------------
76: -- |-------------------------< other_bookings_clash >-------------------------|
77: -- ----------------------------------------------------------------------------

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

174: l_booking_status varchar2(80);
175: l_dummy varchar2(80);
176: --
177: Begin
178: hr_utility.set_location('Entering:'||l_proc, 5);
179: --
180: -- Modified for bug#5498011
181: -- Common cursor for both person as well as contact
182: For event in csr_event_type

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

217: end if;
218: --
219: return(l_warn);
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End other_bookings_clash;
223: -- ----------------------------------------------------------------------------
224: -- |-------------------------< overdraft_exceeded >---------------------------|
225: -- ----------------------------------------------------------------------------

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

247: 'M');
248: --
249: Begin
250: --
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: -- get overdraft limit.
254: --
255: open c1;

Line 261: hr_utility.set_location('Overdraft Limit '||l_overdraft_limit,10);

257: fetch c1 into l_overdraft_limit;
258: --
259: close c1;
260: --
261: hr_utility.set_location('Overdraft Limit '||l_overdraft_limit,10);
262: hr_utility.set_location('Balance '||l_balance,10);
263: --
264: l_balance := l_balance + l_overdraft_limit;
265: hr_utility.set_location('Balance '||l_balance,10);

Line 262: hr_utility.set_location('Balance '||l_balance,10);

258: --
259: close c1;
260: --
261: hr_utility.set_location('Overdraft Limit '||l_overdraft_limit,10);
262: hr_utility.set_location('Balance '||l_balance,10);
263: --
264: l_balance := l_balance + l_overdraft_limit;
265: hr_utility.set_location('Balance '||l_balance,10);
266: --

Line 265: hr_utility.set_location('Balance '||l_balance,10);

261: hr_utility.set_location('Overdraft Limit '||l_overdraft_limit,10);
262: hr_utility.set_location('Balance '||l_balance,10);
263: --
264: l_balance := l_balance + l_overdraft_limit;
265: hr_utility.set_location('Balance '||l_balance,10);
266: --
267: if l_balance - p_money_amount < 0 then
268: return true;
269: else

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

269: else
270: return false;
271: end if;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 10);
274: --
275: end overdraft_exceeded;
276: --
277: --

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

291: --
292: l_proc varchar2(72) := g_package||'check_person_visible';
293: --
294: Begin
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- only perform the check if the person is specified
298: --
299: if p_person_id is not null then

Line 301: hr_utility.trace(p_person_type||' Person ID -> '||to_char(p_person_id));

297: -- only perform the check if the person is specified
298: --
299: if p_person_id is not null then
300: --
301: hr_utility.trace(p_person_type||' Person ID -> '||to_char(p_person_id));
302: if not ota_tdb_bus.check_person (p_person_id,
303: p_date_booking_placed,
304: p_person_type,
305: p_person_address_type) then

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

319: end if;
320: --
321: end if;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: End check_person_visible;
325: --
326: --
327: -- ----------------------------------------------------------------------------

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

377:
378: --
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: --
383: -- Only perform validation checks if we are dealing with an
384: -- internal enrollment, in other words organization id is not null
385: --

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

481: --
482: end if;
483: end if;
484: end if;
485: hr_utility.set_location(' Leaving:'||l_proc, 10);
486: End check_org_business_group;
487: --
488: --
489: -- ----------------------------------------------------------------------------

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

526:
527:
528: --
529: Begin
530: hr_utility.set_location('Entering:'||l_proc, 5);
531: --
532: -- Only perform validation checks if we are dealing with an
533: -- external enrollment, in other words customer id is not null
534: --

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

549: end if;
550: close l_address;
551: --
552: end if;
553: hr_utility.set_location(' Leaving:'||l_proc, 10);
554: End check_contact_address;
555: --
556: --
557: -- ----------------------------------------------------------------------------

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

574: --
575: l_proc varchar2(72) := g_package||'check_organization_details';
576: --
577: Begin
578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Only perform validation checks if we are dealing with an
581: -- internal enrollment, in other words organization id is not null
582: --

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

602: fnd_message.raise_error;
603: end if;
604: --
605: end if;
606: hr_utility.set_location(' Leaving:'||l_proc, 10);
607: End check_organization_details;
608: --
609: --
610: -- ----------------------------------------------------------------------------

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

628: from ota_events
629: where event_id = p_event_id;
630: --
631: Begin
632: hr_utility.set_location('Entering:'||l_proc, 5);
633: hr_utility.set_location('Event Id:'||to_char(p_event_id),5);
634: --
635: -- only perform the check if the person is specified
636: --

Line 633: hr_utility.set_location('Event Id:'||to_char(p_event_id),5);

629: where event_id = p_event_id;
630: --
631: Begin
632: hr_utility.set_location('Entering:'||l_proc, 5);
633: hr_utility.set_location('Event Id:'||to_char(p_event_id),5);
634: --
635: -- only perform the check if the person is specified
636: --
637: open c1;

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

655: end if;
656: --
657: end if;
658: --
659: hr_utility.set_location(' Leaving:'||l_proc, 10);
660: End check_enrollment_type;
661: --
662: -- ----------------------------------------------------------------------------
663: -- |-------------------------< check_spon_del_validity >----------------------|

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

712: between effective_start_date
713: and nvl(effective_end_date,hr_api.g_eot);
714: --
715: Begin
716: hr_utility.set_location('Entering:'||l_proc, 5);
717: --
718: -- Only perform check if we are dealing with an internal enrollment
719: -- In other words check if p_organization_id is not null
720: --

Line 742: hr_utility.set_location('Delegate start date '||to_char(l_delegate_start_date),5);

738: close c_delegate;
739: --
740: -- Check if delegate is valid for event and date booking placed date
741: --
742: hr_utility.set_location('Delegate start date '||to_char(l_delegate_start_date),5);
743: hr_utility.set_location('Delegate end date '||to_char(l_delegate_end_date),5);
744: hr_utility.set_location('date Booking Placed '||to_char(p_date_booking_placed),5);
745: hr_utility.set_location('Event Start Date'||to_char(l_event_start_date),5);
746:

Line 743: hr_utility.set_location('Delegate end date '||to_char(l_delegate_end_date),5);

739: --
740: -- Check if delegate is valid for event and date booking placed date
741: --
742: hr_utility.set_location('Delegate start date '||to_char(l_delegate_start_date),5);
743: hr_utility.set_location('Delegate end date '||to_char(l_delegate_end_date),5);
744: hr_utility.set_location('date Booking Placed '||to_char(p_date_booking_placed),5);
745: hr_utility.set_location('Event Start Date'||to_char(l_event_start_date),5);
746:
747: /*

Line 744: hr_utility.set_location('date Booking Placed '||to_char(p_date_booking_placed),5);

740: -- Check if delegate is valid for event and date booking placed date
741: --
742: hr_utility.set_location('Delegate start date '||to_char(l_delegate_start_date),5);
743: hr_utility.set_location('Delegate end date '||to_char(l_delegate_end_date),5);
744: hr_utility.set_location('date Booking Placed '||to_char(p_date_booking_placed),5);
745: hr_utility.set_location('Event Start Date'||to_char(l_event_start_date),5);
746:
747: /*
748: if (l_delegate_start_date > p_date_booking_placed) or

Line 745: hr_utility.set_location('Event Start Date'||to_char(l_event_start_date),5);

741: --
742: hr_utility.set_location('Delegate start date '||to_char(l_delegate_start_date),5);
743: hr_utility.set_location('Delegate end date '||to_char(l_delegate_end_date),5);
744: hr_utility.set_location('date Booking Placed '||to_char(p_date_booking_placed),5);
745: hr_utility.set_location('Event Start Date'||to_char(l_event_start_date),5);
746:
747: /*
748: if (l_delegate_start_date > p_date_booking_placed) or
749: (nvl(l_delegate_end_date,hr_api.g_eot)

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

779: fnd_message.raise_error;
780: end if;
781: end if;
782: end if;
783: hr_utility.set_location(' Leaving:'||l_proc, 10);
784: End check_spon_del_validity;
785: --
786: -- ----------------------------------------------------------------------------
787: -- |-------------------------< check_customer_details >-----------------------|

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

845:
846: --
847: --
848: Begin
849: hr_utility.set_location('Entering:'||l_proc, 5);
850: --
851: -- Only perform check if we are dealing with an external enrollment
852: --
853: if p_customer_id is not null then

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

881: end if;
882: close c_sponsor;
883: end if;
884: end if;
885: hr_utility.set_location(' Leaving:'||l_proc, 10);
886: End check_customer_details;
887:
888: --
889: -- ----------------------------------------------------------------------------

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

905: BOOKING_ID = p_booking_id;
906:
907: l_proc varchar2(72) := g_package||'chk_event_changed';
908: BEGIN
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: FOR C_EVENT_REC in C_EVENT
911: LOOP
912: hr_utility.set_location('Entering:'||l_proc, 20);
913: IF C_EVENT_REC.old_event_id is not null then

Line 912: hr_utility.set_location('Entering:'||l_proc, 20);

908: BEGIN
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: FOR C_EVENT_REC in C_EVENT
911: LOOP
912: hr_utility.set_location('Entering:'||l_proc, 20);
913: IF C_EVENT_REC.old_event_id is not null then
914: if p_event_id is not null and
915: p_event_id <> C_EVENT_REC.old_event_id then
916:

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

920:
921: end if;
922: END IF;
923: END LOOP;
924: hr_utility.set_location('Leaving:'||l_proc, 30);
925: END chk_old_event_changed ;
926:
927: --
928: -- ----------------------------------------------------------------------------

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

945: FROM ota_events
946: WHERE event_id = p_event_id;
947: l_proc VARCHAR2(72) := g_package||'check_commitment_date';
948: BEGIN
949: hr_utility.set_location('Entering:'||l_proc,5);
950: FOR c_event_rec IN c_event
951: LOOP
952: hr_utility.set_location('Entering:'||l_proc,20);
953: l_event_end_date := c_event_rec.course_end_date;

Line 952: hr_utility.set_location('Entering:'||l_proc,20);

948: BEGIN
949: hr_utility.set_location('Entering:'||l_proc,5);
950: FOR c_event_rec IN c_event
951: LOOP
952: hr_utility.set_location('Entering:'||l_proc,20);
953: l_event_end_date := c_event_rec.course_end_date;
954: END LOOP;
955: ota_utility.get_commitment_detail(p_line_id,
956: l_commitment_id,

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

962: fnd_message.set_name('OTA','OTA_OM_COMMITMENT');
963: fnd_message.set_token('COMMITMENT_NUMBER',l_commitment_number);
964: fnd_message.set_token('COMMITMENT_END_DATE',fnd_date.date_to_chardate(l_commitment_end_date));
965: END IF;
966: hr_utility.set_location('Leaving:'||l_proc,30);
967: END check_commitment_date;
968:
969: -- ----------------------------------------------------------------------------
970: -- |-------------------------< Check Location >----------------------------|

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

1002: --
1003: begin
1004: --
1005: --
1006: hr_utility.set_location('Entering:'|| l_proc, 5);
1007: --
1008: -- get country for OM org
1009: if p_om_org_id is not null then
1010: --

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

1033: --
1034: END IF;
1035: END IF;
1036: --
1037: hr_utility.set_location('Leaving:'|| l_proc, 10);
1038: --
1039: end Check_location;
1040: --
1041: end ota_tdb_bus2;