APPS.PA_RP_UTIL dependencies on FND_API

Line 21: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

17: END IF;
18:
19: IF x_return_status IS NULL THEN
20: x_msg_count := 0;
21: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
22: END IF;
23:
24:
25: UPDATE pa_rp_job_assignments

Line 72: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

68: END IF;
69:
70: IF x_return_status IS NULL THEN
71: x_msg_count := 0;
72: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
73: END IF;
74:
75: x_is_dt_trimmed := 'N';
76:

Line 130: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

126: END IF;
127:
128: IF x_return_status IS NULL THEN
129: x_msg_count := 0;
130: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
131: END IF;
132:
133: UPDATE PA_RP_DEFINITIONS_B
134: SET dt_process_date = SYSDATE

Line 226: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

222: END IF;
223:
224: IF x_return_status IS NULL THEN
225: x_msg_count := 0;
226: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
227: END IF;
228:
229:
230: l_worker_number := TO_NUMBER(FND_PROFILE.VALUE('PA_RP_WORKER_QUANTITY')); -- this should be read from profile option

Line 276: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

272: END IF;
273:
274: IF x_return_status IS NULL THEN
275: x_msg_count := 0;
276: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
277: END IF;
278: /* When the main program call this procedure, it should already done with its own processing
279: work, which means there is no job left to be done, so the job assignment table should
280: only contain finished job and job under processing*/

Line 469: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

465: END IF;
466:
467: IF x_return_status IS NULL THEN
468: x_msg_count := 0;
469: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
470: END IF;
471:
472: FORALL l_i IN p_param_names.first..p_param_names.last
473: INSERT INTO PA_RP_CONC_PARAMS(REQUEST_ID

Line 537: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

533: END IF;
534:
535: IF x_return_status IS NULL THEN
536: x_msg_count := 0;
537: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
538: END IF;
539:
540:
541: FOR l_email IN c_project_role_emails LOOP

Line 609: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

605: END IF;
606:
607: IF x_return_status IS NULL THEN
608: x_msg_count := 0;
609: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
610: END IF;
611:
612: SELECT
613: MAX(DECODE(ppfo.approved_cost_plan_type_flag, 'Y', fin_plan_type_id, -99)) pApprCostBudgetPTId,

Line 801: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

797: END IF;
798:
799: IF x_return_status IS NULL THEN
800: x_msg_count := 0;
801: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
802: END IF;
803:
804: SELECT project_currency_code, projfunc_currency_code
805: INTO l_proj_currency,l_projfunc_currency

Line 825: x_return_status := Fnd_Api.G_RET_STS_ERROR;

821:
822: EXCEPTION
823: WHEN OTHERS THEN
824: x_msg_count := x_msg_count + 1;
825: x_return_status := Fnd_Api.G_RET_STS_ERROR;
826: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_RP_Util.Derive_Currency_Info');
827: RAISE;
828: END Derive_Currency_Info;
829:

Line 988: x_return_status := Fnd_Api.G_RET_STS_ERROR;

984:
985: EXCEPTION
986: WHEN NO_DATA_FOUND THEN
987: x_msg_count := x_msg_count + 1;
988: x_return_status := Fnd_Api.G_RET_STS_ERROR;
989: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'CURRENT PERIOD');
990: x_report_date :=2;
991: WHEN OTHERS THEN
992: x_msg_count := x_msg_count + 1;

Line 993: x_return_status := Fnd_Api.G_RET_STS_ERROR;

989: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'TOKEN_NAME',p_token1_value=>'CURRENT PERIOD');
990: x_report_date :=2;
991: WHEN OTHERS THEN
992: x_msg_count := x_msg_count + 1;
993: x_return_status := Fnd_Api.G_RET_STS_ERROR;
994: Add_Message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG',p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Rep_Util.Derive_Report_Period');
995: RAISE;
996: END Derive_Calendar_Info;
997: