DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on FND_API

Line 8296: l_return_status varchar2(255) := FND_API.G_RET_STS_SUCCESS;

8292: l_last_update_date date;
8293: l_last_updated_by number;
8294: l_last_update_login number;
8295:
8296: l_return_status varchar2(255) := FND_API.G_RET_STS_SUCCESS;
8297: l_msg_data varchar2(2000);
8298: l_err_msg VARCHAR2(100):= 'Error in PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS -> PJI_FM_PLAN_MAINT.POPULATE_FIN8';
8299:
8300: begin

Line 8407: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

8403: p_extraction_type => l_extraction_type,
8404: x_return_status => l_return_status,
8405: x_msg_data => l_msg_data);
8406:
8407: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8408: dbms_standard.raise_application_error(-20105, l_err_msg);
8409: END IF;
8410:
8411:

Line 19454: l_ret_status := FND_API.G_RET_STS_SUCCESS;

19450:
19451: begin
19452:
19453: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
19454: l_ret_status := FND_API.G_RET_STS_SUCCESS;
19455:
19456: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);')) then
19457: return;
19458: end if;

Line 19495: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

19491: x_msg_count => l_msg_count,
19492: x_msg_data => l_msg_data);
19493:
19494:
19495: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
19496: FND_MESSAGE.SET_NAME('PA', l_msg_data);
19497: l_ret_msg_data := FND_MESSAGE.GET;
19498: rollback to S_PROGRESS_ROLLUP;
19499: l_success := 'Y';

Line 19510: , FND_API.G_RET_STS_SUCCESS

19506: forall j in 1..l_project_id_tbl.COUNT
19507: update PJI_PJP_PROJ_BATCH_MAP
19508: set pji_project_status =
19509: decode(l_return_status
19510: , FND_API.G_RET_STS_SUCCESS
19511: , 'S' -- Success
19512: , 'S' -- keeping this for future requirement Pending processing as actuals did not get returned for this project.
19513: ),
19514: act_err_msg= decode(l_return_status

Line 19515: , FND_API.G_RET_STS_SUCCESS

19511: , 'S' -- Success
19512: , 'S' -- keeping this for future requirement Pending processing as actuals did not get returned for this project.
19513: ),
19514: act_err_msg= decode(l_return_status
19515: , FND_API.G_RET_STS_SUCCESS
19516: , act_err_msg
19517: , l_ret_msg_data
19518: )
19519: where WORKER_ID = p_worker_id and

Line 19555: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

19551: p_extr_type => l_extraction_type
19552: , x_return_status => l_return_status
19553: , x_msg_code => l_msg_data ) ;
19554:
19555: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
19556: dbms_standard.raise_application_error(-20120, l_err_msg2);
19557: END IF;
19558:
19559: -- PA_ppr_rollup_PVT.CREATE_CBS_SLICE (p_worker_id, l_extraction_type ); -- This call is not needed since CBS version will not be frozen

Line 19663: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

19659: x_msg_count => l_msg_count,
19660: x_msg_data => l_msg_data);
19661:
19662:
19663: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
19664: dbms_standard.raise_application_error(-20130, 'Error in PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS -> PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS');
19665: end if;
19666:
19667: end if;