APPS.OTA_LO_UTILITY dependencies on OTA_UTILITY

Line 3147: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');

3143: If ( (l_status = 'N') or (l_status = 'I') ) Then
3144: If ( l_course_end_date < l_sysdate --Class is expired --Bug 3554773 --Bug 5222464
3145: AND p_mode is null ) Then -- Bug 3594377
3146: l_status := 'E';
3147: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');
3148: End If;
3149: End If;
3150:
3151: --check if the enrollment is part of active certs

Line 3613: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');

3609: If ( (l_status = 'N') or (l_status = 'I') ) Then
3610: If ( l_course_end_date < trunc(sysdate) --Class is expired --Bug 3554773
3611: AND p_mode is null ) Then -- Bug 3594377
3612: l_status := 'E';
3613: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');
3614: End If;
3615: End If;
3616: Else
3617: open c_booking_status;

Line 4210: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');

4206: If ( rec.course_end_date < trunc(sysdate) --Class is expired --Bug 3554773
4207: -- AND p_mode is null ) Then -- Bug 3594377
4208: ) then
4209: l_status := 'E';
4210: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');
4211: End If;
4212: End If;
4213:
4214: hr_utility.set_location('Leaving :'||l_proc,10);