APPS.PA_ACCUM_PROJ_LIST dependencies on FND_API

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: select NVL(org_id,-99) into g_org_id
89: from pa_projects_all
90: where project_id = p_project_id; /*4704130 */
91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: l_project_id := p_project_id;
95:
96:

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

333:
334: WHEN OTHERS THEN
335: x_msg_count := 1;
336: x_msg_data := SUBSTR(SQLERRM, 1, 240);
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: ROLLBACK TO Insert_Accum_Pvt;
339: FND_MSG_PUB.add_Exc_msg(
340: p_pkg_name => G_PKG_NAME,
341: p_procedure_name => l_api_name);

Line 437: x_return_status := FND_API.G_RET_STS_SUCCESS;

433: where project_id = p_project_id;
434:
435: SAVEPOINT Upgrade_Accum_Pvt;
436:
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439: l_project_id := p_project_id;
440:
441:

Line 671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

667: WHEN dup_val_on_index THEN
668: null; -- Although should not get this, OK if dup record exists.
669:
670:
671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
672: x_msg_count := 1;
673: x_msg_data := SUBSTR(SQLERRM, 1, 240);
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: ROLLBACK TO Upgrade_Accum_Pvt;

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

670:
671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
672: x_msg_count := 1;
673: x_msg_data := SUBSTR(SQLERRM, 1, 240);
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: ROLLBACK TO Upgrade_Accum_Pvt;
676: FND_MSG_PUB.add_Exc_msg(
677: p_pkg_name => G_PKG_NAME,
678: p_procedure_name => l_api_name);

Line 683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

679:
680: WHEN OTHERS THEN
681: x_msg_count := 1;
682: x_msg_data := SUBSTR(SQLERRM, 1, 240);
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: ROLLBACK TO Upgrade_Accum_Pvt;
685: FND_MSG_PUB.add_Exc_msg(
686: p_pkg_name => G_PKG_NAME,
687: p_procedure_name => l_api_name);