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 1373: x_return_status := FND_API.G_RET_STS_SUCCESS;

1369: l_accnt_period_type VARCHAR2(15);
1370: l_sets_of_books_id NUMBER;
1371: l_msg_index_out NUMBER; -- -- Bug Ref : 7010273
1372: BEGIN
1373: x_return_status := FND_API.G_RET_STS_SUCCESS;
1374: --Get the site level profile option of the user
1375: SELECT fnd_profile.value('PA_RES_UTIL_DEF_PERIOD_TYPE')
1376: INTO l_pa_res_util_def_pd_types
1377: FROM dual;

Line 1397: x_return_status := FND_API.G_RET_STS_ERROR;

1393:
1394: IF (p_org_id IS NULL) THEN
1395: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI',
1396: p_msg_name => 'PJI_MO_PROFILE_OPTION_NOT_FND');
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: RETURN;
1399: END IF;
1400:
1401: --Get the resource id

Line 1478: x_return_status := FND_API.G_RET_STS_ERROR;

1474: END IF;Commented for bug 13011859 */
1475: -- Bug Ref : 7010273
1476: EXCEPTION
1477: WHEN NO_DATA_FOUND THEN
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1480: p_msg_name => 'PA_SU_INFO_MISSING');
1481: x_msg_count := FND_MSG_PUB.Count_Msg;
1482: IF ( x_msg_count > 0 ) THEN

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

1479: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1480: p_msg_name => 'PA_SU_INFO_MISSING');
1481: x_msg_count := FND_MSG_PUB.Count_Msg;
1482: IF ( x_msg_count > 0 ) THEN
1483: PA_INTERFACE_UTILS_PUB.GET_MESSAGES ( p_encoded => FND_API.G_TRUE
1484: ,p_msg_index => 1
1485: ,p_data => x_msg_data
1486: ,p_msg_index_out => l_msg_index_out );
1487: END IF;

Line 1513: x_return_status := FND_API.G_RET_STS_SUCCESS;

1509: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1510: )
1511: IS
1512: BEGIN
1513: x_return_status := FND_API.G_RET_STS_SUCCESS;
1514:
1515: --Call the API to populate the table PJI_RES_UTILZ_TMP1
1516:
1517: PJI_POPULATE_PERIODS

Line 1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1554: COMMIT;
1555:
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559:
1560: END PJI_POP_UTILIZATION_DATA;
1561:
1562: PROCEDURE GET_PERSON_FROM_RES

Line 1573: x_return_status := FND_API.G_RET_STS_SUCCESS;

1569: )
1570: IS
1571: l_msg_index_out NUMBER; -- Bug Ref : 7010273
1572: BEGIN
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574:
1575: SELECT NVL(person_id,-1)
1576: INTO x_person_id
1577: FROM pa_resource_txn_attributes

Line 1582: x_return_status := FND_API.G_RET_STS_ERROR;

1578: WHERE resource_id = p_resource_id;
1579: -- Bug Ref : 7010273
1580: EXCEPTION
1581: WHEN NO_DATA_FOUND THEN
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1584: p_msg_name => 'PA_SU_INFO_MISSING');
1585: x_msg_count := FND_MSG_PUB.Count_Msg;
1586: IF ( x_msg_count > 0 ) THEN

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

1583: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1584: p_msg_name => 'PA_SU_INFO_MISSING');
1585: x_msg_count := FND_MSG_PUB.Count_Msg;
1586: IF ( x_msg_count > 0 ) THEN
1587: PA_INTERFACE_UTILS_PUB.GET_MESSAGES ( p_encoded => FND_API.G_TRUE
1588: ,p_msg_index => 1
1589: ,p_data => x_msg_data
1590: ,p_msg_index_out => l_msg_index_out );
1591: END IF;