DBA Data[Home] [Help]

APPS.OTA_CANCEL_TRAINING_SS dependencies on FND_API

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

225: --
226: hr_utility.set_location('Leaving:'||l_proc, 20);
227: EXCEPTION
228: WHEN OTHERS THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: x_msg_data := SQLCODE||': '||SUBSTR(SQLERRM, 1, 950);
231: --
232: hr_utility.set_location('Leaving:'||l_proc, 30);
233: --

Line 283: (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

279: --
280: -- {End Of Comments}
281: ----------------------------------------------------------------------------
282: PROCEDURE cancel_enrollment
283: (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_booking_id IN NUMBER,

Line 371: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

367: l_hours_until_class_starts NUMBER;
368: l_minimum_advance_notice NUMBER;
369: l_auto_waitlist_days NUMBER;
370: l_sysdate DATE := SYSDATE;
371: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
372: l_msg_data VARCHAR2(1000);
373: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;
374: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;
375: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;

Line 444: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

440: BEGIN
441: --
442: hr_utility.set_location('Entering:'||l_proc, 10);
443:
444: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
445: FND_MSG_PUB.INITIALIZE;
446: END IF;
447: --
448: OPEN event_csr (p_event_id);

Line 628: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

624: p_course_start_date => l_course_start_date,
625: p_course_end_date => l_course_end_date,
626: p_version_name => l_activity_version_name);
627:
628: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
629: RAISE l_wf_exception;
630: END IF;
631: --
632: -- Populate standard return values if cancel enrollment

Line 635: x_return_status := FND_API.G_RET_STS_SUCCESS;

631: --
632: -- Populate standard return values if cancel enrollment
633: -- and work flow creation were successful
634: --
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636: x_msg_count := 1;
637: x_msg_data := 'OTA_CANCEL_ENROLLMENT'; -- return message name
638: --
639: hr_utility.set_location('Leaving:'||l_proc, 20);