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_DELEGATE_BOOKING_API 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_DELEGATE_BOOKING_API.';
7: g_debug boolean := hr_utility.debug_enabled; -- Global Debug status variable
8: --
9: --
10: -- ----------------------------------------------------------------------------
11: -- |-------------------------< Check New Status >----------------------------|

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

50: l_sign_flag varchar2(1);
51: begin
52: --
53: --
54: hr_utility.set_location('Entering:'|| l_proc, 5);
55: --
56: -- Check for exceeding max attendees.
57: --
58:

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

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

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

324: --p_sign_eval_status varchar2(2) := 'NN';
325: BEGIN
326: if g_debug then
327: l_proc := g_package||'process_sign_eval_status';
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: hr_utility.trace('p_sign_eval_status:'||p_sign_eval_status);
330: end if;
331:
332: open csr_sign_info;

Line 329: hr_utility.trace('p_sign_eval_status:'||p_sign_eval_status);

325: BEGIN
326: if g_debug then
327: l_proc := g_package||'process_sign_eval_status';
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: hr_utility.trace('p_sign_eval_status:'||p_sign_eval_status);
330: end if;
331:
332: open csr_sign_info;
333: fetch csr_sign_info into l_sign_required;

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

397: return null;
398: end if;
399:
400: if g_debug then
401: hr_utility.set_location('Leaving:'||l_proc, 10);
402: end if;
403:
404: return l_new_sign_eval_status;
405:

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

590: l_currency_code varchar2(40);
591: l_new_sign_eval_status ota_delegate_bookings.sign_eval_status%type;
592:
593: begin
594: hr_utility.set_location('Entering:'|| l_proc, 10);
595: --
596: -- Issue a savepoint
597: --
598: savepoint create_delegate_booking;

Line 987: hr_utility.set_location(l_proc, 7);

983: --
984: end if;
985: --
986: --
987: hr_utility.set_location(l_proc, 7);
988:
989: --
990: -- Reset Event Status
991: --

Line 998: hr_utility.set_location(l_proc, 8);

994: ,l_event_rec.object_version_number
995: ,l_event_rec.event_status
996: ,l_event_rec.maximum_attendees);
997: --
998: hr_utility.set_location(l_proc, 8);
999: end if;
1000:
1001: if ( l_ignore_dff_validation = 'Y' ) then
1002: hr_dflex_utility.remove_ignore_df_validation;

Line 1228: hr_utility.set_location(' Leaving:'||l_proc, 70);

1224: raise hr_api.validate_enabled;
1225: end if;
1226:
1227: --
1228: hr_utility.set_location(' Leaving:'||l_proc, 70);
1229: exception
1230: when hr_api.validate_enabled then
1231: --
1232: -- As the Validate_Enabled exception has been raised

Line 1243: hr_utility.set_location(' Leaving:'||l_proc, 80);

1239: -- when validation only mode is being used.)
1240: --
1241: p_object_version_number := null;
1242: p_booking_id := null;
1243: hr_utility.set_location(' Leaving:'||l_proc, 80);
1244: when others then
1245: --
1246: -- A validation or unexpected error has occured
1247: --

Line 1251: hr_utility.set_location(' Leaving:'||l_proc, 90);

1247: --
1248: rollback to create_delegate_booking;
1249: p_object_version_number := null;
1250: p_booking_id := null;
1251: hr_utility.set_location(' Leaving:'||l_proc, 90);
1252: raise;
1253: end create_delegate_booking ;
1254: --
1255: --

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

1317: begin
1318: --
1319: if g_debug then
1320: l_proc := g_package||'check_status_change';
1321: hr_utility.set_location('Entering:'||l_proc, 5);
1322: end if;
1323:
1324: --
1325: -- *** In case of Event Change -- Reset Event Status for Old Event ***

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

1421: --
1422: end if;
1423: --
1424: if g_debug then
1425: hr_utility.set_location('Leaving:'||l_proc, 10);
1426: end if;
1427: --
1428: --
1429: end Check_Status_Change;

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

1463: begin
1464: --
1465: if g_debug then
1466: l_proc := g_package||'deleteForumNotification';
1467: hr_utility.set_location('Entering:'||l_proc, 5);
1468: end if;
1469:
1470: --Delete the forum notification record for this class,for this user
1471: OPEN c_get_forum_id;

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

1487: Close c_get_forum_id;
1488:
1489: --
1490: if g_debug then
1491: hr_utility.set_location('Leaving:'||l_proc, 10);
1492: end if;
1493: --
1494: --
1495: end deleteForumNotification;

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

1531: begin
1532: --
1533: if g_debug then
1534: l_proc := g_package||'createForumNotification';
1535: hr_utility.set_location('Entering:'||l_proc, 5);
1536: end if;
1537:
1538: select Type into l_type from ota_booking_status_types where booking_status_type_id=l_booking_status_type_id;
1539:

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

1560: Close csr_forums_for_class;
1561: end if;
1562: --
1563: if g_debug then
1564: hr_utility.set_location('Leaving:'||l_proc, 10);
1565: end if;
1566: --
1567: /* if therealready exists a frm notif record, and we try to create a new one,
1568: an exception will be thrown which gets caught here.. We ignore the exception and return*/

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

1940: l_old_booking_status_type ota_booking_status_types.type%TYPE;
1941: l_new_booking_status_type ota_booking_status_types.type%TYPE;
1942:
1943: begin
1944: hr_utility.set_location('Entering:'|| l_proc, 10);
1945: if g_debug then
1946: --hr_utility.set_location('Entering:'||l_proc, 10);
1947: HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);
1948: end if;

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

1942:
1943: begin
1944: hr_utility.set_location('Entering:'|| l_proc, 10);
1945: if g_debug then
1946: --hr_utility.set_location('Entering:'||l_proc, 10);
1947: HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);
1948: end if;
1949: --
1950: -- Issue a savepoint

Line 1947: HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);

1943: begin
1944: hr_utility.set_location('Entering:'|| l_proc, 10);
1945: if g_debug then
1946: --hr_utility.set_location('Entering:'||l_proc, 10);
1947: HR_UTILITY.TRACE ('SIGN_EVAL_STATUS: ' || p_sign_eval_status);
1948: end if;
1949: --
1950: -- Issue a savepoint
1951: --

Line 2947: hr_utility.trace('Entered do nothing');

2943: if l_new_booking_status_type in ('A','P','E') and l_old_booking_status_type in ('A','P','E') AND
2944: l_new_event_id = ota_tdb_shd.g_old_rec.event_id
2945: AND p_number_of_places = ota_tdb_shd.g_old_rec.number_of_places THEN
2946: --- do nothing
2947: hr_utility.trace('Entered do nothing');
2948: null;
2949: else
2950:
2951: hr_utility.trace('Entered lock event');

Line 2951: hr_utility.trace('Entered lock event');

2947: hr_utility.trace('Entered do nothing');
2948: null;
2949: else
2950:
2951: hr_utility.trace('Entered lock event');
2952: ota_evt_bus2.lock_event(l_new_event_id);
2953: --
2954: -- Reset Event Status
2955: --

Line 3107: hr_utility.set_location(' Leaving:'||l_proc, 70);

3103: -- Set all output arguments
3104: --
3105: -- p_object_version_number := l_object_version_number;
3106: --
3107: hr_utility.set_location(' Leaving:'||l_proc, 70);
3108: exception
3109: when hr_api.validate_enabled then
3110: --
3111: -- As the Validate_Enabled exception has been raised

Line 3121: hr_utility.set_location(' Leaving:'||l_proc, 80);

3117: -- (Any key or derived arguments must be set to null
3118: -- when validation only mode is being used.)
3119: --
3120: -- p_object_version_number := null;
3121: hr_utility.set_location(' Leaving:'||l_proc, 80);
3122: when others then
3123: --
3124: -- A validation or unexpected error has occured
3125: --

Line 3127: hr_utility.set_location(' Leaving:'||l_proc, 90);

3123: --
3124: -- A validation or unexpected error has occured
3125: --
3126: rollback to update_delegate_booking ;
3127: hr_utility.set_location(' Leaving:'||l_proc, 90);
3128: -- p_object_version_number := l_object_version_number;
3129: raise;
3130: end update_delegate_booking ;
3131:

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

3198: l_person_id number := -1;
3199:
3200: --
3201: begin
3202: hr_utility.set_location('Entering:'|| l_proc, 10);
3203:
3204: OPEN get_person_info;
3205: FETCH get_person_info INTO l_person_id;
3206: CLOSE get_person_info;

Line 3318: hr_utility.set_location(' Leaving:'||l_proc, 170);

3314: --
3315: -- Set all output arguments
3316: --
3317: --
3318: hr_utility.set_location(' Leaving:'||l_proc, 170);
3319: exception
3320: when hr_api.validate_enabled then
3321: --
3322: -- As the Validate_Enabled exception has been raised

Line 3331: hr_utility.set_location(' Leaving:'||l_proc, 180);

3327: -- Only set output warning arguments
3328: -- (Any key or derived arguments must be set to null
3329: -- when validation only mode is being used.)
3330: --
3331: hr_utility.set_location(' Leaving:'||l_proc, 180);
3332: when others then
3333: --
3334: -- A validation or unexpected error has occured
3335: --

Line 3337: hr_utility.set_location(' Leaving:'||l_proc, 190);

3333: --
3334: -- A validation or unexpected error has occured
3335: --
3336: rollback to delete_delegate_booking ;
3337: hr_utility.set_location(' Leaving:'||l_proc, 190);
3338: raise;
3339: end delete_delegate_booking;
3340: --
3341: -- ----------------------------------------------------------------------------

Line 3369: g_debug := hr_utility.debug_enabled;

3365: l_places number;
3366: --
3367: begin
3368: --
3369: g_debug := hr_utility.debug_enabled;
3370:
3371: if g_debug then
3372: l_proc := g_package||'Update_Waitlisted';
3373: hr_utility.set_location('Entering:'|| l_proc, 5);

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

3369: g_debug := hr_utility.debug_enabled;
3370:
3371: if g_debug then
3372: l_proc := g_package||'Update_Waitlisted';
3373: hr_utility.set_location('Entering:'|| l_proc, 5);
3374: end if;
3375: --
3376: -- Call the delegate booking update API.
3377: --

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

3407: --
3408: end if;
3409: --
3410: if g_debug then
3411: hr_utility.set_location('Leaving:'|| l_proc, 10);
3412: end if;
3413: --
3414: end Update_Waitlisted;
3415: