DBA Data[Home] [Help]

APPS.BIS_PMV_TIME_LEVELS_PVT dependencies on FND_API

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287: ,x_return_Status => x_return_status
288: ,x_msg_count => x_msg_count
289: ,x_msg_data => x_msg_data );
290: END IF;
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 293: WHEN FND_API.G_EXC_ERROR THEN

289: ,x_msg_data => x_msg_data );
290: END IF;
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

290: END IF;
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
299: WHEN OTHERS THEN
300: IF (x_prev_asof_Date IS NULL or (length(x_prev_asof_date) = 0)) THEN

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

293: WHEN FND_API.G_EXC_ERROR THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
299: WHEN OTHERS THEN
300: IF (x_prev_asof_Date IS NULL or (length(x_prev_asof_date) = 0)) THEN
301: GET_BIS_COMMON_START_DATE

Line 428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

424: x_parameterRecord := l_ParameterRecord;
425:
426: EXCEPTION
427: WHEN OTHERS THEN
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
430: END;
431:
432: /*-----BugFix#2887200 -ansingh-------*/

Line 594: x_return_Status := FND_API.G_RET_STS_SUCCESS;

590: x_nested_pattern := 1;
591: else
592: x_nested_pattern := 119;
593: end if;
594: x_return_Status := FND_API.G_RET_STS_SUCCESS;
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 596: WHEN FND_API.G_EXC_ERROR THEN

592: x_nested_pattern := 119;
593: end if;
594: x_return_Status := FND_API.G_RET_STS_SUCCESS;
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 597: x_return_status := FND_API.G_RET_STS_ERROR;

593: end if;
594: x_return_Status := FND_API.G_RET_STS_SUCCESS;
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
602: WHEN OTHERS THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
602: WHEN OTHERS THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
602: WHEN OTHERS THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
605: END;
606:
607:

Line 678: x_return_Status := FND_API.G_RET_STS_SUCCESS;

674:
675: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_cyr_end(:2); END;';
676: EXECUTE IMMEDIATE l_dynamic_sql USING OUT x_year, IN l_asof_date;
677: END IF;
678: x_return_Status := FND_API.G_RET_STS_SUCCESS;
679:
680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;

Line 681: WHEN FND_API.G_EXC_ERROR THEN

677: END IF;
678: x_return_Status := FND_API.G_RET_STS_SUCCESS;
679:
680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 682: x_return_status := FND_API.G_RET_STS_ERROR;

678: x_return_Status := FND_API.G_RET_STS_SUCCESS;
679:
680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

681: WHEN FND_API.G_EXC_ERROR THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
690: END GET_POPLIST_DATES;
691:
692: END BIS_PMV_TIME_LEVELS_PVT;