DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on FND_API

Line 191: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;

187: TRUE, g_msg_level_proc_call
188: );
189: END IF;
190: l_msg_count := 0;
191: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
192:
193:
194: --BEGIN
195: -- DELETE PA_PERF_TEMP_OBJ_MEASURE_debug;

Line 546: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

542: END LOOP;
543:
544: IF l_msg_count IS NULL OR l_msg_count = 0 THEN
545: x_msg_count := 0;
546: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
547: ELSE
548: x_msg_count := l_msg_count;
549: x_return_status := l_return_status;
550: END IF;

Line 623: x_return_status := Fnd_Api.G_RET_STS_ERROR;

619: FROM pji_mt_measures_vl
620: WHERE measure_code = p_measure_codes_tbl(i);
621: EXCEPTION
622: WHEN NO_DATA_FOUND THEN
623: x_return_status := Fnd_Api.G_RET_STS_ERROR;
624: l_sql_errm := SQLERRM();
625: Pji_Rep_Util.Add_Message(
626: p_app_short_name=>'PJI',
627: p_msg_name=> 'PJI_REP_GENERIC_MSG',

Line 634: x_return_status := Fnd_Api.G_RET_STS_ERROR;

630: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Measure_Labels; No Data Found Error: '
631: ||l_sql_errm
632: );
633: WHEN OTHERS THEN
634: x_return_status := Fnd_Api.G_RET_STS_ERROR;
635: l_sql_errm := SQLERRM();
636: Pji_Rep_Util.Add_Message(
637: p_app_short_name=>'PJI',
638: p_msg_name=> 'PJI_REP_GENERIC_MSG',

Line 670: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

666: END IF;
667:
668: IF x_return_status IS NULL THEN
669: x_msg_count := 0;
670: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
671: END IF;
672:
673: x_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
674: x_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 702: x_return_status := Fnd_Api.G_RET_STS_ERROR;

698: WHERE measure_code = p_measure_codes_tbl(i);
699:
700: EXCEPTION
701: WHEN NO_DATA_FOUND THEN
702: x_return_status := Fnd_Api.G_RET_STS_ERROR;
703: x_msg_count := x_msg_count + 1;
704: Pji_Rep_Util.Add_Message(
705: p_app_short_name=> 'PJI',
706: p_msg_name=> 'PJI_REP_UNDEFINED_MSR_CODE',

Line 709: x_return_status := Fnd_Api.G_RET_STS_ERROR;

705: p_app_short_name=> 'PJI',
706: p_msg_name=> 'PJI_REP_UNDEFINED_MSR_CODE',
707: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
708: WHEN TOO_MANY_ROWS THEN
709: x_return_status := Fnd_Api.G_RET_STS_ERROR;
710: x_msg_count := x_msg_count + 1;
711: Pji_Rep_Util.Add_Message(
712: p_app_short_name=> 'PJI',
713: p_msg_name=> 'PJI_REP_DUPLICATED_MSR_CODE',

Line 716: x_return_status := Fnd_Api.G_RET_STS_ERROR;

712: p_app_short_name=> 'PJI',
713: p_msg_name=> 'PJI_REP_DUPLICATED_MSR_CODE',
714: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
715: WHEN OTHERS THEN
716: x_return_status := Fnd_Api.G_RET_STS_ERROR;
717: l_sql_errm := SQLERRM();
718: x_msg_count := x_msg_count + 1;
719: Pji_Rep_Util.Add_Message(
720: p_app_short_name=> 'PJI',

Line 845: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

841: Pji_Utils.WRITE2LOG('entering get_measure_attributes',TRUE, g_msg_level_runtime_info);
842: END IF;
843:
844: x_msg_count := 0;
845: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
846:
847:
848: l_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
849: l_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 891: x_return_status := Fnd_Api.G_RET_STS_ERROR;

887: WHERE measure_code = p_measure_codes_tbl(i);
888:
889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN
891: x_return_status := Fnd_Api.G_RET_STS_ERROR;
892: Pji_Rep_Util.Add_Message(
893: p_app_short_name=> 'PJI',
894: p_msg_name=> 'PJI_REP_UNDEFINED_MSR_CODE',
895: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);

Line 897: x_return_status := Fnd_Api.G_RET_STS_ERROR;

893: p_app_short_name=> 'PJI',
894: p_msg_name=> 'PJI_REP_UNDEFINED_MSR_CODE',
895: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
896: WHEN TOO_MANY_ROWS THEN
897: x_return_status := Fnd_Api.G_RET_STS_ERROR;
898: Pji_Rep_Util.Add_Message(
899: p_app_short_name=> 'PJI',
900: p_msg_name=> 'PJI_REP_DUPLICATED_MSR_CODE',
901: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);

Line 1061: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1057: END LOOP;
1058:
1059: IF l_msg_count IS NULL OR l_msg_count = 0 THEN
1060: x_msg_count := 0;
1061: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1062: ELSE
1063: x_msg_count := l_msg_count;
1064: x_return_status := l_return_status;
1065: END IF;

Line 1154: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1150:
1151: BEGIN
1152:
1153: x_msg_count := 0;
1154: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1155:
1156: xActualPlanTypeId := -1;
1157:
1158: -- Cost Forecast

Line 1929: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1925: l_check_plan_versions := 0;
1926:
1927: IF x_return_status IS NULL THEN
1928: x_msg_count := 0;
1929: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1930: END IF;
1931:
1932: l_overview_type := pji_rep_overview_type_tbl();
1933: l_temp_overview_type := pji_rep_overview_type_tbl();

Line 10028: l_sec_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

10024: IS
10025:
10026: x_sec_ret_code VARCHAR2(1);
10027:
10028: l_sec_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10029: l_sec_msg_count NUMBER := 0;
10030: l_sec_msg_data VARCHAR2(1) := NULL;
10031:
10032: l_measure_values_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;