APPS.PA_DURATION_UTILS dependencies on FND_API

Line 24: x_return_status := FND_API.G_RET_STS_SUCCESS;

20: l_date DATE;
21: l_week_day VARCHAR2(10);
22:
23: BEGIN
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25: x_duration_days := 0;
26: x_duration_hours :=0;
27:
28: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id => p_calendar_id,

Line 36: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

32: x_return_status => x_return_status,
33: x_msg_count => x_msg_count,
34: x_msg_data => x_msg_data);
35:
36: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
37: IF l_sch_record_tab.COUNT > 0 THEN
38: FOR j IN l_sch_record_tab.FIRST..l_sch_record_tab.LAST LOOP
39:
40: l_date := l_sch_record_tab(j).start_date;

Line 92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

88: WHEN OTHERS THEN
89: FND_MSG_PUB.add_exc_msg
90: (p_pkg_name => 'PA_DURATION_UTILS.get_duration_old',
91: p_procedure_name => PA_DEBUG.G_Err_Stack );
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
93: RAISE;
94: END get_duration_old;
95:
96: FUNCTION get_total_hours(p_calendar_id IN NUMBER,

Line 114: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

110: l_hours,
111: l_return_status,
112: l_msg_count,
113: l_msg_data);
114: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
115: return 0;
116: ELSE
117: return l_hours;
118: END IF;

Line 146: x_return_status := FND_API.G_RET_STS_SUCCESS;

142: l_duration_hours NUMBER :=0;
143:
144:
145: BEGIN
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147: x_duration_days := 0;
148: x_duration_hours :=0;
149:
150: IF (g_calendar_id IS NULL OR g_calendar_id <> p_calendar_id) THEN

Line 160: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

156: x_return_status => x_return_status,
157: x_msg_count => x_msg_count,
158: x_msg_data => x_msg_data);
159:
160: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
161: IF l_sch_record_tab.COUNT > 0 THEN
162: FOR j IN l_sch_record_tab.FIRST..l_sch_record_tab.LAST LOOP
163:
164: l_date := l_sch_record_tab(j).start_date;

Line 295: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

291: x_return_status => x_return_status,
292: x_msg_count => x_msg_count,
293: x_msg_data => x_msg_data);
294:
295: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
296: IF l_sch_record_tab.COUNT > 0 THEN
297: FOR j IN l_sch_record_tab.FIRST..l_sch_record_tab.LAST LOOP
298:
299: l_date := l_sch_record_tab(j).start_date;

Line 362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

358: WHEN OTHERS THEN
359: FND_MSG_PUB.add_exc_msg
360: (p_pkg_name => 'PA_DURATION_UTILS.get_duration',
361: p_procedure_name => PA_DEBUG.G_Err_Stack );
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: RAISE;
364: END get_duration;
365:
366: