APPS.PJI_RM_SUM_AVL dependencies on FND_API

Line 1441: x_return_status := FND_API.G_RET_STS_SUCCESS;

1437:
1438: delete from PJI_RM_AGGR_AVL1 where worker_id = p_worker_id;
1439: delete from PJI_RM_AGGR_AVL2 where worker_id = p_worker_id;
1440:
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442: savepoint before_calc_starts;
1443: /*PHASE 1*/
1444: /*
1445: The idea is to determine all different periods and quarters for

Line 4030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4026: );
4027:
4028: /*EXCEPTION
4029: WHEN OTHERS THEN
4030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4031: ROLLBACK TO before_calc_starts;*/
4032: END CALCULATE_RES_AVL;
4033:
4034: /**************************************************************************

Line 4497: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

4493: l_process VARCHAR2(30);
4494: l_row_count NUMBER := 0;
4495: l_parallel_processes NUMBER;
4496:
4497: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
4498:
4499: BEGIN
4500: --This call in the loop will take care of:
4501: --PHASE 1

Line 4563: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4559: p_run_mode => 'OLD_FACT_RECORDS',
4560: x_return_status => l_return_status
4561: );
4562: pji_utils.write2log(p_worker_id || ': R1: After Calculating availability');
4563: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4564: /*
4565: UPDATE PJI_RM_RES_BATCH_MAP
4566: SET worker_id = null
4567: WHERE person_id = l_person_id;

Line 4643: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

4639: l_process VARCHAR2(30);
4640: l_row_count NUMBER := 0;
4641: l_parallel_processes NUMBER;
4642:
4643: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
4644:
4645: BEGIN
4646: --This call in the loop will take care of:
4647: --PHASE 1

Line 4711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4707: p_run_mode => 'NEW_FACT_RECORDS',
4708: x_return_status => l_return_status
4709: );
4710: pji_utils.write2log(p_worker_id || ': R2: After Calculating availability');
4711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4712: /*
4713: UPDATE PJI_RM_RES_BATCH_MAP
4714: SET worker_id = null
4715: WHERE person_id = l_person_id;