APPS.PJI_PJP_SUM_ROLLUP dependencies on FND_API

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

5025: l_last_update_date date;
5026: l_last_updated_by number;
5027: l_last_update_login number;
5028:
5029: l_return_status varchar2(255) := FND_API.G_RET_STS_SUCCESS;
5030: l_msg_data varchar2(2000);
5031: l_err_msg VARCHAR2(100):= 'Error in PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS -> PJI_FM_PLAN_MAINT.POPULATE_FIN8';
5032:
5033: begin

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

5136: p_extraction_type => l_extraction_type,
5137: x_return_status => l_return_status,
5138: x_msg_data => l_msg_data);
5139:
5140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5141: dbms_standard.raise_application_error(-20105, l_err_msg);
5142: END IF;
5143:
5144:

Line 17173: l_ret_status := FND_API.G_RET_STS_SUCCESS;

17169:
17170: begin
17171:
17172: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17173: l_ret_status := FND_API.G_RET_STS_SUCCESS;
17174:
17175: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);')) then
17176: return;
17177: end if;

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

17210: x_msg_count => l_msg_count,
17211: x_msg_data => l_msg_data);
17212:
17213:
17214: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
17215: FND_MESSAGE.SET_NAME('PA', l_msg_data);
17216: l_ret_msg_data := FND_MESSAGE.GET;
17217: rollback to S_PROGRESS_ROLLUP;
17218: l_success := 'Y';

Line 17229: , FND_API.G_RET_STS_SUCCESS

17225: forall j in 1..l_project_id_tbl.COUNT
17226: update PJI_PJP_PROJ_BATCH_MAP
17227: set pji_project_status =
17228: decode(l_return_status
17229: , FND_API.G_RET_STS_SUCCESS
17230: , 'S' -- Success
17231: , 'S' -- keeping this for future requirement Pending processing as actuals did not get returned for this project.
17232: ),
17233: act_err_msg= decode(l_return_status

Line 17234: , FND_API.G_RET_STS_SUCCESS

17230: , 'S' -- Success
17231: , 'S' -- keeping this for future requirement Pending processing as actuals did not get returned for this project.
17232: ),
17233: act_err_msg= decode(l_return_status
17234: , FND_API.G_RET_STS_SUCCESS
17235: , act_err_msg
17236: , l_ret_msg_data
17237: )
17238: where WORKER_ID = p_worker_id and

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

17270: p_extr_type => l_extraction_type
17271: , x_return_status => l_return_status
17272: , x_msg_code => l_msg_data ) ;
17273:
17274: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
17275: dbms_standard.raise_application_error(-20120, l_err_msg2);
17276: END IF;
17277:
17278: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);');

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

17376: x_msg_count => l_msg_count,
17377: x_msg_data => l_msg_data);
17378:
17379:
17380: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
17381: dbms_standard.raise_application_error(-20130, 'Error in PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS -> PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS');
17382: end if;
17383:
17384: end if;