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 535: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

Line 637: g_debug := hr_utility.debug_enabled;

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

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

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

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

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

Line 1339: g_debug := hr_utility.debug_enabled;

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

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

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

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

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