DBA Data[Home] [Help]

APPS.IGS_AS_SUARC_LGCY_PUB dependencies on FND_API

Line 352: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,

348: BEGIN
349: -- Create a savepoint
350: SAVEPOINT CREATE_SUARC_PUB;
351: -- Check for the Compatible API call
352: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,
353: p_api_version,
354: l_api_name,
355: g_pkg_name) THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

352: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,
353: p_api_version,
354: l_api_name,
355: g_pkg_name) THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: -- If the calling program has passed the parameter for initializing the message list
359: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
360: FND_MSG_PUB.INITIALIZE;

Line 359: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

355: g_pkg_name) THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: -- If the calling program has passed the parameter for initializing the message list
359: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
360: FND_MSG_PUB.INITIALIZE;
361: END IF;
362: -- Set the return status to success
363: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 363: x_return_status := FND_API.G_RET_STS_SUCCESS;

359: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
360: FND_MSG_PUB.INITIALIZE;
361: END IF;
362: -- Set the return status to success
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364: g_suarc_status := 'VALID';
365: --
366: -- 1.Validate Parameters
367: validate_parameters(p_suarc_dtls_rec => p_suarc_dtls_rec);

Line 497: IF ( (FND_API.To_Boolean(p_commit)) AND (g_suarc_status = 'VALID') ) THEN

493: END IF;
494: --
495: -- If the calling program has passed the parameter for committing the data and there
496: -- have been no errors in calling the balances process, then commit the work
497: IF ( (FND_API.To_Boolean(p_commit)) AND (g_suarc_status = 'VALID') ) THEN
498: COMMIT WORK;
499: END IF;
500: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
501: p_data => x_msg_data);

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: --
503: -- Retutn Status to the calling program
504: IF g_suarc_status = 'INVALID' THEN
505: ROLLBACK TO CREATE_SUARC_PUB;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: ELSIF g_suarc_status = 'WARNING' THEN
508: ROLLBACK TO CREATE_SUARC_PUB;
509: x_return_status := 'W';
510: END IF ;

Line 512: WHEN FND_API.G_EXC_ERROR THEN

508: ROLLBACK TO CREATE_SUARC_PUB;
509: x_return_status := 'W';
510: END IF ;
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO CREATE_SUARC_PUB;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
516: p_data => x_msg_data);

Line 514: x_return_status := FND_API.G_RET_STS_ERROR;

510: END IF ;
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO CREATE_SUARC_PUB;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
516: p_data => x_msg_data);
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO CREATE_SUARC_PUB;

Line 517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

513: ROLLBACK TO CREATE_SUARC_PUB;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
516: p_data => x_msg_data);
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO CREATE_SUARC_PUB;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
521: p_data => x_msg_data);

Line 519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

515: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
516: p_data => x_msg_data);
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO CREATE_SUARC_PUB;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
521: p_data => x_msg_data);
522: WHEN OTHERS THEN
523: ROLLBACK TO CREATE_SUARC_PUB;

Line 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

520: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
521: p_data => x_msg_data);
522: WHEN OTHERS THEN
523: ROLLBACK TO CREATE_SUARC_PUB;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
526: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
527: l_api_name);
528: END IF;