APPS.PJI_RESOURCE_UTILZ dependencies on FND_API

Line 45: x_return_status := FND_API.G_RET_STS_SUCCESS;

41: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42: )
43: IS
44: BEGIN
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46:
47: IF (p_calendar_type = 'G') THEN
48:
49: SELECT fiin.calendar_id,

Line 1366: x_return_status := FND_API.G_RET_STS_SUCCESS;

1362: l_accnt_period_type VARCHAR2(15);
1363: l_sets_of_books_id NUMBER;
1364: l_msg_index_out NUMBER; -- -- Bug Ref : 7010273
1365: BEGIN
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;
1367: --Get the site level profile option of the user
1368: SELECT fnd_profile.value('PA_RES_UTIL_DEF_PERIOD_TYPE')
1369: INTO l_pa_res_util_def_pd_types
1370: FROM dual;

Line 1390: x_return_status := FND_API.G_RET_STS_ERROR;

1386:
1387: IF (p_org_id IS NULL) THEN
1388: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI',
1389: p_msg_name => 'PJI_MO_PROFILE_OPTION_NOT_FND');
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: RETURN;
1392: END IF;
1393:
1394: --Get the resource id

Line 1456: x_return_status := FND_API.G_RET_STS_ERROR;

1452: END IF;
1453: -- Bug Ref : 7010273
1454: EXCEPTION
1455: WHEN NO_DATA_FOUND THEN
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1458: p_msg_name => 'PA_SU_INFO_MISSING');
1459: x_msg_count := FND_MSG_PUB.Count_Msg;
1460: IF ( x_msg_count > 0 ) THEN

Line 1461: PA_INTERFACE_UTILS_PUB.GET_MESSAGES ( p_encoded => FND_API.G_TRUE

1457: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1458: p_msg_name => 'PA_SU_INFO_MISSING');
1459: x_msg_count := FND_MSG_PUB.Count_Msg;
1460: IF ( x_msg_count > 0 ) THEN
1461: PA_INTERFACE_UTILS_PUB.GET_MESSAGES ( p_encoded => FND_API.G_TRUE
1462: ,p_msg_index => 1
1463: ,p_data => x_msg_data
1464: ,p_msg_index_out => l_msg_index_out );
1465: END IF;

Line 1491: x_return_status := FND_API.G_RET_STS_SUCCESS;

1487: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1488: )
1489: IS
1490: BEGIN
1491: x_return_status := FND_API.G_RET_STS_SUCCESS;
1492:
1493: --Call the API to populate the table PJI_RES_UTILZ_TMP1
1494:
1495: PJI_POPULATE_PERIODS

Line 1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1532: COMMIT;
1533:
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537:
1538: END PJI_POP_UTILIZATION_DATA;
1539:
1540: PROCEDURE GET_PERSON_FROM_RES

Line 1551: x_return_status := FND_API.G_RET_STS_SUCCESS;

1547: )
1548: IS
1549: l_msg_index_out NUMBER; -- Bug Ref : 7010273
1550: BEGIN
1551: x_return_status := FND_API.G_RET_STS_SUCCESS;
1552:
1553: SELECT NVL(person_id,-1)
1554: INTO x_person_id
1555: FROM pa_resource_txn_attributes

Line 1560: x_return_status := FND_API.G_RET_STS_ERROR;

1556: WHERE resource_id = p_resource_id;
1557: -- Bug Ref : 7010273
1558: EXCEPTION
1559: WHEN NO_DATA_FOUND THEN
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1562: p_msg_name => 'PA_SU_INFO_MISSING');
1563: x_msg_count := FND_MSG_PUB.Count_Msg;
1564: IF ( x_msg_count > 0 ) THEN

Line 1565: PA_INTERFACE_UTILS_PUB.GET_MESSAGES ( p_encoded => FND_API.G_TRUE

1561: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1562: p_msg_name => 'PA_SU_INFO_MISSING');
1563: x_msg_count := FND_MSG_PUB.Count_Msg;
1564: IF ( x_msg_count > 0 ) THEN
1565: PA_INTERFACE_UTILS_PUB.GET_MESSAGES ( p_encoded => FND_API.G_TRUE
1566: ,p_msg_index => 1
1567: ,p_data => x_msg_data
1568: ,p_msg_index_out => l_msg_index_out );
1569: END IF;