APPS.OTA_TDB_API_UPD2 dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled; -- Global Debug status variable

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ota_tdb_api_upd2.';
7: g_debug boolean := hr_utility.debug_enabled; -- Global Debug status variable
8: --
9: -- ----------------------------------------------------------------------------
10: -- |-------------------------< Check Status Change >--------------------------|
11: -- ----------------------------------------------------------------------------

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

48: begin
49: --
50: if g_debug then
51: l_proc := g_package||'check_status_change';
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: end if;
54:
55: --
56: -- *** In case of Event Change -- Reset Event Status for Old Event ***

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

125: --
126: end if;
127: --
128: if g_debug then
129: hr_utility.set_location('Leaving:'||l_proc, 10);
130: end if;
131: --
132: --
133: end Check_Status_Change;

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

164: begin
165: --
166: if g_debug then
167: l_proc := g_package||'deleteForumNotification';
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: end if;
170:
171: --Delete the forum notification record for this class,for this user
172: OPEN c_get_forum_id;

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

188: Close c_get_forum_id;
189:
190: --
191: if g_debug then
192: hr_utility.set_location('Leaving:'||l_proc, 10);
193: end if;
194: --
195: --
196: end deleteForumNotification;

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

232: begin
233: --
234: if g_debug then
235: l_proc := g_package||'createForumNotification';
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: end if;
238:
239: select Type into l_type from ota_booking_status_types where booking_status_type_id=l_booking_status_type_id;
240:

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

261: Close csr_forums_for_class;
262: end if;
263: --
264: if g_debug then
265: hr_utility.set_location('Leaving:'||l_proc, 10);
266: end if;
267: --
268: /* if therealready exists a frm notif record, and we try to create a new one,
269: an exception will be thrown which gets caught here.. We ignore the exception and return*/

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

530: */
531: --
532: begin
533:
534: hr_utility.set_location('Entering:'||l_proc, 5);
535:
536: ota_delegate_booking_api.update_delegate_booking(
537: p_effective_date => trunc(sysdate)
538: , p_booking_id => p_booking_id

Line 631: hr_utility.set_location('Leaving:'||l_proc, 5);

627: , p_is_history_flag => p_is_history_flag
628: , p_override_learner_access => p_override_learner_access
629: );
630:
631: hr_utility.set_location('Leaving:'||l_proc, 5);
632:
633: /*
634: --
635: g_debug := hr_utility.debug_enabled;

Line 635: g_debug := hr_utility.debug_enabled;

631: hr_utility.set_location('Leaving:'||l_proc, 5);
632:
633: /*
634: --
635: g_debug := hr_utility.debug_enabled;
636:
637: if g_debug then
638: l_proc := g_package||'update_enrollment';
639: hr_utility.set_location('Entering:'||l_proc, 5);

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

635: g_debug := hr_utility.debug_enabled;
636:
637: if g_debug then
638: l_proc := g_package||'update_enrollment';
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: end if;
641: --
642: -- Issue a savepoint if operating in validation only mode.
643: --

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

1287: end if;
1288:
1289: --
1290: if g_debug then
1291: hr_utility.set_location('Leaving:'||l_proc, 10);
1292: end if;
1293: --
1294: exception
1295: when hr_api.validate_enabled then

Line 1337: g_debug := hr_utility.debug_enabled;

1333: l_places number;
1334: --
1335: begin
1336: --
1337: g_debug := hr_utility.debug_enabled;
1338:
1339: if g_debug then
1340: l_proc := g_package||'Update_Waitlisted';
1341: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1337: g_debug := hr_utility.debug_enabled;
1338:
1339: if g_debug then
1340: l_proc := g_package||'Update_Waitlisted';
1341: hr_utility.set_location('Entering:'|| l_proc, 5);
1342: end if;
1343: --
1344: -- Call the delegate booking update API.
1345: --

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

1375: --
1376: end if;
1377: --
1378: if g_debug then
1379: hr_utility.set_location('Leaving:'|| l_proc, 10);
1380: end if;
1381: --
1382: end Update_Waitlisted;
1383: