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.

[Home] [Help]

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

43: --
44: begin
45: --
46: --
47: hr_utility.set_location('Entering:'|| l_proc, 5);
48: --
49: -- Check for exceeding max attendees.
50: --
51:

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

116: --
117: end if;
118:
119: --
120: hr_utility.set_location('Leaving:'|| l_proc, 10);
121: --
122: end Check_New_Status;
123: --
124:

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

443:
444: l_currency_code varchar2(40);
445:
446: begin
447: hr_utility.set_location('Entering:'|| l_proc, 10);
448: --
449: -- Issue a savepoint
450: --
451: savepoint create_delegate_booking;

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

826: --
827: end if;
828: --
829: --
830: hr_utility.set_location(l_proc, 7);
831:
832: --
833: -- Reset Event Status
834: --

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

836: ,l_event_rec.object_version_number
837: ,l_event_rec.event_status
838: ,l_event_rec.maximum_attendees);
839: --
840: hr_utility.set_location(l_proc, 8);
841:
842: if ( l_ignore_dff_validation = 'Y' ) then
843: hr_dflex_utility.remove_ignore_df_validation;
844: end if;

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

1065: raise hr_api.validate_enabled;
1066: end if;
1067:
1068: --
1069: hr_utility.set_location(' Leaving:'||l_proc, 70);
1070: exception
1071: when hr_api.validate_enabled then
1072: --
1073: -- As the Validate_Enabled exception has been raised

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

1080: -- when validation only mode is being used.)
1081: --
1082: p_object_version_number := null;
1083: p_booking_id := null;
1084: hr_utility.set_location(' Leaving:'||l_proc, 80);
1085: when others then
1086: --
1087: -- A validation or unexpected error has occured
1088: --

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

1088: --
1089: rollback to create_delegate_booking;
1090: p_object_version_number := null;
1091: p_booking_id := null;
1092: hr_utility.set_location(' Leaving:'||l_proc, 90);
1093: raise;
1094: end create_delegate_booking ;
1095: --
1096: --

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

1151: begin
1152: --
1153: if g_debug then
1154: l_proc := g_package||'check_status_change';
1155: hr_utility.set_location('Entering:'||l_proc, 5);
1156: end if;
1157:
1158: --
1159: -- *** In case of Event Change -- Reset Event Status for Old Event ***

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

1252: --
1253: end if;
1254: --
1255: if g_debug then
1256: hr_utility.set_location('Leaving:'||l_proc, 10);
1257: end if;
1258: --
1259: --
1260: end Check_Status_Change;

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

1294: begin
1295: --
1296: if g_debug then
1297: l_proc := g_package||'deleteForumNotification';
1298: hr_utility.set_location('Entering:'||l_proc, 5);
1299: end if;
1300:
1301: --Delete the forum notification record for this class,for this user
1302: OPEN c_get_forum_id;

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

1318: Close c_get_forum_id;
1319:
1320: --
1321: if g_debug then
1322: hr_utility.set_location('Leaving:'||l_proc, 10);
1323: end if;
1324: --
1325: --
1326: end deleteForumNotification;

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

1362: begin
1363: --
1364: if g_debug then
1365: l_proc := g_package||'createForumNotification';
1366: hr_utility.set_location('Entering:'||l_proc, 5);
1367: end if;
1368:
1369: select Type into l_type from ota_booking_status_types where booking_status_type_id=l_booking_status_type_id;
1370:

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

1391: Close csr_forums_for_class;
1392: end if;
1393: --
1394: if g_debug then
1395: hr_utility.set_location('Leaving:'||l_proc, 10);
1396: end if;
1397: --
1398: /* if therealready exists a frm notif record, and we try to create a new one,
1399: an exception will be thrown which gets caught here.. We ignore the exception and return*/

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

1753: l_contact_user_id ota_attempts.user_id%type;
1754:
1755:
1756: begin
1757: hr_utility.set_location('Entering:'|| l_proc, 10);
1758: --
1759: -- Issue a savepoint
1760: --
1761: savepoint update_delegate_booking ;

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

2870: -- Set all output arguments
2871: --
2872: -- p_object_version_number := l_object_version_number;
2873: --
2874: hr_utility.set_location(' Leaving:'||l_proc, 70);
2875: exception
2876: when hr_api.validate_enabled then
2877: --
2878: -- As the Validate_Enabled exception has been raised

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

2884: -- (Any key or derived arguments must be set to null
2885: -- when validation only mode is being used.)
2886: --
2887: -- p_object_version_number := null;
2888: hr_utility.set_location(' Leaving:'||l_proc, 80);
2889: when others then
2890: --
2891: -- A validation or unexpected error has occured
2892: --

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

2890: --
2891: -- A validation or unexpected error has occured
2892: --
2893: rollback to update_delegate_booking ;
2894: hr_utility.set_location(' Leaving:'||l_proc, 90);
2895: -- p_object_version_number := l_object_version_number;
2896: raise;
2897: end update_delegate_booking ;
2898:

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

2957:
2958: --bug 603768 changes ends
2959: --
2960: begin
2961: hr_utility.set_location('Entering:'|| l_proc, 10);
2962: --
2963: -- Issue a savepoint
2964: --
2965: savepoint delete_delegate_booking ;

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

3068: --
3069: -- Set all output arguments
3070: --
3071: --
3072: hr_utility.set_location(' Leaving:'||l_proc, 170);
3073: exception
3074: when hr_api.validate_enabled then
3075: --
3076: -- As the Validate_Enabled exception has been raised

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

3081: -- Only set output warning arguments
3082: -- (Any key or derived arguments must be set to null
3083: -- when validation only mode is being used.)
3084: --
3085: hr_utility.set_location(' Leaving:'||l_proc, 180);
3086: when others then
3087: --
3088: -- A validation or unexpected error has occured
3089: --

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

3087: --
3088: -- A validation or unexpected error has occured
3089: --
3090: rollback to delete_delegate_booking ;
3091: hr_utility.set_location(' Leaving:'||l_proc, 190);
3092: raise;
3093: end delete_delegate_booking;
3094: --
3095: -- ----------------------------------------------------------------------------

Line 3123: g_debug := hr_utility.debug_enabled;

3119: l_places number;
3120: --
3121: begin
3122: --
3123: g_debug := hr_utility.debug_enabled;
3124:
3125: if g_debug then
3126: l_proc := g_package||'Update_Waitlisted';
3127: hr_utility.set_location('Entering:'|| l_proc, 5);

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

3123: g_debug := hr_utility.debug_enabled;
3124:
3125: if g_debug then
3126: l_proc := g_package||'Update_Waitlisted';
3127: hr_utility.set_location('Entering:'|| l_proc, 5);
3128: end if;
3129: --
3130: -- Call the delegate booking update API.
3131: --

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

3161: --
3162: end if;
3163: --
3164: if g_debug then
3165: hr_utility.set_location('Leaving:'|| l_proc, 10);
3166: end if;
3167: --
3168: end Update_Waitlisted;
3169: