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 616: x_return_status := Fnd_Api.G_RET_STS_ERROR;

612: FROM pji_mt_measures_vl
613: WHERE measure_code = p_measure_codes_tbl(i);
614: EXCEPTION
615: WHEN NO_DATA_FOUND THEN
616: x_return_status := Fnd_Api.G_RET_STS_ERROR;
617: l_sql_errm := SQLERRM();
618: Pji_Rep_Util.Add_Message(
619: p_app_short_name=>'PJI',
620: p_msg_name=> 'PJI_REP_GENERIC_MSG',

Line 627: x_return_status := Fnd_Api.G_RET_STS_ERROR;

623: p_token1_value=>'PJI_REP_MEASURE_UTIL.Get_Measure_Labels; No Data Found Error: '
624: ||l_sql_errm
625: );
626: WHEN OTHERS THEN
627: x_return_status := Fnd_Api.G_RET_STS_ERROR;
628: l_sql_errm := SQLERRM();
629: Pji_Rep_Util.Add_Message(
630: p_app_short_name=>'PJI',
631: p_msg_name=> 'PJI_REP_GENERIC_MSG',

Line 663: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

659: END IF;
660:
661: IF x_return_status IS NULL THEN
662: x_msg_count := 0;
663: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
664: END IF;
665:
666: x_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
667: x_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 695: x_return_status := Fnd_Api.G_RET_STS_ERROR;

691: WHERE measure_code = p_measure_codes_tbl(i);
692:
693: EXCEPTION
694: WHEN NO_DATA_FOUND THEN
695: x_return_status := Fnd_Api.G_RET_STS_ERROR;
696: x_msg_count := x_msg_count + 1;
697: Pji_Rep_Util.Add_Message(
698: p_app_short_name=> 'PJI',
699: p_msg_name=> 'PJI_REP_UNDEFINED_MSR_CODE',

Line 702: x_return_status := Fnd_Api.G_RET_STS_ERROR;

698: p_app_short_name=> 'PJI',
699: p_msg_name=> 'PJI_REP_UNDEFINED_MSR_CODE',
700: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
701: WHEN TOO_MANY_ROWS 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_DUPLICATED_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_DUPLICATED_MSR_CODE',
707: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
708: WHEN OTHERS THEN
709: x_return_status := Fnd_Api.G_RET_STS_ERROR;
710: l_sql_errm := SQLERRM();
711: x_msg_count := x_msg_count + 1;
712: Pji_Rep_Util.Add_Message(
713: p_app_short_name=> 'PJI',

Line 838: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

834: Pji_Utils.WRITE2LOG('entering get_measure_attributes',TRUE, g_msg_level_runtime_info);
835: END IF;
836:
837: x_msg_count := 0;
838: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
839:
840:
841: l_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
842: l_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 884: x_return_status := Fnd_Api.G_RET_STS_ERROR;

880: WHERE measure_code = p_measure_codes_tbl(i);
881:
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: x_return_status := Fnd_Api.G_RET_STS_ERROR;
885: Pji_Rep_Util.Add_Message(
886: p_app_short_name=> 'PJI',
887: p_msg_name=> 'PJI_REP_UNDEFINED_MSR_CODE',
888: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);

Line 890: x_return_status := Fnd_Api.G_RET_STS_ERROR;

886: p_app_short_name=> 'PJI',
887: p_msg_name=> 'PJI_REP_UNDEFINED_MSR_CODE',
888: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);
889: WHEN TOO_MANY_ROWS THEN
890: x_return_status := Fnd_Api.G_RET_STS_ERROR;
891: Pji_Rep_Util.Add_Message(
892: p_app_short_name=> 'PJI',
893: p_msg_name=> 'PJI_REP_DUPLICATED_MSR_CODE',
894: p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR);

Line 1054: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1050: END LOOP;
1051:
1052: IF l_msg_count IS NULL OR l_msg_count = 0 THEN
1053: x_msg_count := 0;
1054: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1055: ELSE
1056: x_msg_count := l_msg_count;
1057: x_return_status := l_return_status;
1058: END IF;

Line 1147: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1143:
1144: BEGIN
1145:
1146: x_msg_count := 0;
1147: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1148:
1149: xActualPlanTypeId := -1;
1150:
1151: -- Cost Forecast

Line 1922: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1918: l_check_plan_versions := 0;
1919:
1920: IF x_return_status IS NULL THEN
1921: x_msg_count := 0;
1922: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1923: END IF;
1924:
1925: l_overview_type := pji_rep_overview_type_tbl();
1926: l_temp_overview_type := pji_rep_overview_type_tbl();