APPS.PA_FORECAST_GRC_PVT dependencies on FND_API

Line 97: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

93:
94: BEGIN
95:
96: --initialize
97: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
98: l_no_of_hours := 0;
99: l_total_no_of_hours := 0;
100:
101: --First derive the resource_id from person_id

Line 153: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

149:
150: END IF;
151:
152: --CALL the get_resource_schedule API here
153: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
154: PA_SCHEDULE_PVT.get_resource_schedule(
155: p_source_id => l_resource_id,
156: p_source_type => l_resource_type,
157: p_start_date => l_real_start_date,

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

214: x_return_status := l_x_return_status;
215:
216: EXCEPTION
217: WHEN OTHERS THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: x_msg_count := 1;
220: x_msg_data := SQLERRM;
221: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FORECAST_GRC_PVT',
222: p_procedure_name => 'get_resource_capacity');

Line 348: x_return_status := FND_API.G_RET_STS_SUCCESS;

344:
345: BEGIN
346:
347: -- 4537865 : Initialize return_status to Success
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: l_return_status := FND_API.G_RET_STS_SUCCESS;
350: -- 4537865 : End
351:
352: l_balance_type_code := p_balance_type_code;

Line 349: l_return_status := FND_API.G_RET_STS_SUCCESS;

345: BEGIN
346:
347: -- 4537865 : Initialize return_status to Success
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: l_return_status := FND_API.G_RET_STS_SUCCESS;
350: -- 4537865 : End
351:
352: l_balance_type_code := p_balance_type_code;
353: l_OU_id := p_OU_id;

Line 380: l_return_status := FND_API.G_RET_STS_SUCCESS;

376:
377: -- first loop through the PA periods available
378: IF l_pa_period_flag = 'Y' then
379: FOR pa_periods_cur_rec in PA_PERIODS_CUR LOOP
380: l_return_status := FND_API.G_RET_STS_SUCCESS;
381: IF (
382: ( p_in_res_eff_s_date_tab(i) >= pa_periods_cur_rec.PERIOD_START_DATE
383: and p_in_res_eff_s_date_tab(i) <= pa_periods_cur_rec.PERIOD_END_DATE )
384: OR

Line 425: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

421: x_return_status => l_return_status,
422: x_msg_count => l_msg_count,
423: x_msg_data => l_msg_data);
424:
425: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
426:
427: --get the period_balance
428: begin
429: select bal.period_balance

Line 489: l_return_status := FND_API.G_RET_STS_SUCCESS;

485:
486: -- IF and loop for GL
487: IF l_gl_period_flag = 'Y' then
488: FOR gl_periods_cur_rec in GL_PERIODS_CUR LOOP
489: l_return_status := FND_API.G_RET_STS_SUCCESS;
490: IF (
491: ( p_in_res_eff_s_date_tab(i) >= gl_periods_cur_rec.PERIOD_START_DATE
492: and p_in_res_eff_s_date_tab(i) <= gl_periods_cur_rec.PERIOD_END_DATE )
493: OR

Line 519: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

515: x_return_status => l_return_status,
516: x_msg_count => l_msg_count,
517: x_msg_data => l_msg_data);
518:
519: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
520:
521: --get the period_balance
522: begin
523: select bal.period_balance

Line 584: l_return_status := FND_API.G_RET_STS_SUCCESS;

580:
581: -- IF and loop for GE
582: IF l_ge_period_flag = 'Y' then
583: FOR ge_periods_cur_rec in GE_PERIODS_CUR LOOP
584: l_return_status := FND_API.G_RET_STS_SUCCESS;
585: IF (
586: ( p_in_res_eff_s_date_tab(i) >= ge_periods_cur_rec.PERIOD_START_DATE
587: and p_in_res_eff_s_date_tab(i) <= ge_periods_cur_rec.GE_DATE )
588: OR

Line 614: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

610: x_return_status => l_return_status,
611: x_msg_count => l_msg_count,
612: x_msg_data => l_msg_data);
613:
614: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
615:
616: --get the period_balance
617: begin
618: select bal.period_balance

Line 695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

691: x_qm_number_tab.delete;
692: x_period_num_tab.delete;
693: -- 4537865 : End
694:
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: x_msg_count := 1;
697: x_msg_data := SQLERRM;
698: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FORECAST_GRC_PVT',
699: p_procedure_name => 'Get_Capacity_Vector');