eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on FND_API

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62: API will calculate the end date by adding 10 yrs.
63: If less than 52 periods ( max pds ) to be populated then
64: the p_end_date should be passed with the actual date. */
65:
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: PA_DEBUG.Set_Curr_Function( p_function => 'Maintain_Prj_Period_Profile',
69: p_debug_mode => p_debug_mode );
70:

Line 109: x_return_status := FND_API.G_RET_STS_ERROR;

105: IF P_PA_DEBUG_MODE = 'Y' THEN
106: PA_DEBUG.g_err_stage := 'table count is zero for the given dt range, returning ';
107: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
108: END IF;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: IF p_add_msg_in_stack = 'Y' THEN
111: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
112: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
113: ELSE

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

300: IF P_PA_DEBUG_MODE = 'Y' THEN
301: PA_DEBUG.g_err_stage := 'no record updated for the gievn id';
302: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
303: END IF;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: IF p_add_msg_in_stack = 'Y' THEN
306: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
307: p_msg_name => 'PA_FP_INVALID_PRJ_PROFILE');
308: ELSE

Line 701: x_return_status := FND_API.G_RET_STS_SUCCESS;

697: l_stmt varchar2(1000);
698: l_column_name varchar2(100);
699: l_dummy integer;
700: BEGIN
701: x_return_status := FND_API.G_RET_STS_SUCCESS;
702: PA_DEBUG.Set_Curr_Function( p_function => 'Get_Prj_Period_Profile_Dtls',
703: p_debug_mode => p_debug_mode );
704: BEGIN
705: SELECT Period_Profile_Type,

Line 741: x_return_status := FND_API.G_RET_STS_ERROR;

737: IF P_PA_DEBUG_MODE = 'Y' THEN
738: PA_DEBUG.g_err_stage := 'no data found for the given pd profile id';
739: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
740: END IF;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: IF p_add_msg_in_stack = 'Y' THEN
743: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
744: p_msg_name => 'PA_FP_INVALID_PRJ_PROFILE');
745: ELSE

Line 932: x_return_status := FND_API.G_RET_STS_SUCCESS;

928: nc_gl_number_of_periods := px_gl_number_of_periods;
929:
930: x_conc_req_id := '0';
931: FND_MSG_PUB.Initialize;
932: x_return_status := FND_API.G_RET_STS_SUCCESS;
933: l_gl_return_status := FND_API.G_RET_STS_SUCCESS;
934: l_pa_return_status := FND_API.G_RET_STS_SUCCESS;
935: x_msg_count := 0;
936: l_valid_pa_period_flag := 'Y';

Line 933: l_gl_return_status := FND_API.G_RET_STS_SUCCESS;

929:
930: x_conc_req_id := '0';
931: FND_MSG_PUB.Initialize;
932: x_return_status := FND_API.G_RET_STS_SUCCESS;
933: l_gl_return_status := FND_API.G_RET_STS_SUCCESS;
934: l_pa_return_status := FND_API.G_RET_STS_SUCCESS;
935: x_msg_count := 0;
936: l_valid_pa_period_flag := 'Y';
937: l_valid_gl_period_flag := 'Y';

Line 934: l_pa_return_status := FND_API.G_RET_STS_SUCCESS;

930: x_conc_req_id := '0';
931: FND_MSG_PUB.Initialize;
932: x_return_status := FND_API.G_RET_STS_SUCCESS;
933: l_gl_return_status := FND_API.G_RET_STS_SUCCESS;
934: l_pa_return_status := FND_API.G_RET_STS_SUCCESS;
935: x_msg_count := 0;
936: l_valid_pa_period_flag := 'Y';
937: l_valid_gl_period_flag := 'Y';
938: l_old_pa_profile_id := px_pa_period_profile_id;

Line 954: x_return_status := FND_API.G_RET_STS_ERROR;

950: IF P_PA_DEBUG_MODE = 'Y' THEN
951: PA_DEBUG.g_err_stage := 'Only one of the pa start or end periods are not null..';
952: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
953: END IF;
954: x_return_status := FND_API.G_RET_STS_ERROR;
955: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
956: p_msg_name => 'PA_FP_ENTER_PA_PP_ST_END_DT');
957: END IF;
958:

Line 965: x_return_status := FND_API.G_RET_STS_ERROR;

961: IF P_PA_DEBUG_MODE = 'Y' THEN
962: PA_DEBUG.g_err_stage := 'Only one of the gl start or end periods are not null..';
963: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
964: END IF;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
967: p_msg_name => 'PA_FP_ENTER_GL_PP_ST_END_DT');
968: END IF;
969:

Line 979: x_return_status := FND_API.G_RET_STS_ERROR;

975: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
976: END IF;
977: l_valid_pa_period_flag := 'N';
978: IF p_old_pa_profile_id IS NOT NULL THEN
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
981: p_msg_name => 'PA_FP_ENTER_PA_PERIODS');
982: ELSE
983: l_call_profile_pa_flag := 'N';

Line 994: x_return_status := FND_API.G_RET_STS_ERROR;

990: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
991: END IF;
992: l_valid_gl_period_flag := 'N';
993: IF p_old_gl_profile_id IS NOT NULL THEN
994: x_return_status := FND_API.G_RET_STS_ERROR;
995: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
996: p_msg_name => 'PA_FP_ENTER_GL_PERIODS');
997: ELSE
998: l_call_profile_gl_flag := 'N';

Line 1017: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1013:
1014: /* The following validations need to be done only if the start and end dates are not null
1015: and there was not validation failure before this. */
1016:
1017: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1018:
1019: IF l_valid_pa_period_flag = 'Y' THEN
1020:
1021: BEGIN

Line 1030: x_return_status := FND_API.G_RET_STS_ERROR;

1026: gl.Period_Name = p_pa_start_period AND
1027: gl.Adjustment_Period_Flag = 'N' ;
1028: EXCEPTION
1029: WHEN NO_DATA_FOUND THEN
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: l_valid_pa_period_flag := 'N';
1032: x_msg_count := x_msg_count + 1;
1033: l_call_profile_pa_flag := 'N';
1034: l_pa_return_status := FND_API.G_RET_STS_ERROR;

Line 1034: l_pa_return_status := FND_API.G_RET_STS_ERROR;

1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: l_valid_pa_period_flag := 'N';
1032: x_msg_count := x_msg_count + 1;
1033: l_call_profile_pa_flag := 'N';
1034: l_pa_return_status := FND_API.G_RET_STS_ERROR;
1035: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1036: p_msg_name => 'PA_FP_PP_INVALID_PERIOD',
1037: p_token1 => 'PERIOD',
1038: p_value1 => p_pa_start_period);

Line 1050: x_return_status := FND_API.G_RET_STS_ERROR;

1046: gl.Period_Name = p_pa_end_period AND
1047: gl.Adjustment_Period_Flag = 'N' ;
1048: EXCEPTION
1049: WHEN NO_DATA_FOUND THEN
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: l_valid_pa_period_flag := 'N';
1052: x_msg_count := x_msg_count + 1;
1053: l_call_profile_pa_flag := 'N';
1054: l_pa_return_status := FND_API.G_RET_STS_ERROR;

Line 1054: l_pa_return_status := FND_API.G_RET_STS_ERROR;

1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: l_valid_pa_period_flag := 'N';
1052: x_msg_count := x_msg_count + 1;
1053: l_call_profile_pa_flag := 'N';
1054: l_pa_return_status := FND_API.G_RET_STS_ERROR;
1055: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1056: p_msg_name => 'PA_FP_PP_INVALID_PERIOD',
1057: p_token1 => 'PERIOD',
1058: p_value1 => p_pa_end_period);

Line 1074: x_return_status := FND_API.G_RET_STS_ERROR;

1070: gl.Period_Name = p_gl_start_period AND
1071: gl.Adjustment_Period_Flag = 'N' ;
1072: EXCEPTION
1073: WHEN NO_DATA_FOUND THEN
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: x_msg_count := x_msg_count + 1;
1076: l_valid_gl_period_flag := 'N';
1077: l_call_profile_gl_flag := 'N';
1078: l_gl_return_status := FND_API.G_RET_STS_ERROR;

Line 1078: l_gl_return_status := FND_API.G_RET_STS_ERROR;

1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: x_msg_count := x_msg_count + 1;
1076: l_valid_gl_period_flag := 'N';
1077: l_call_profile_gl_flag := 'N';
1078: l_gl_return_status := FND_API.G_RET_STS_ERROR;
1079: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1080: p_msg_name => 'PA_FP_PP_INVALID_PERIOD',
1081: p_token1 => 'PERIOD',
1082: p_value1 => p_gl_start_period);

Line 1097: x_return_status := FND_API.G_RET_STS_ERROR;

1093: l_para_period_profile_id := px_gl_period_profile_id;
1094: l_para_number_of_periods := px_gl_number_of_periods;
1095: EXCEPTION
1096: WHEN NO_DATA_FOUND THEN
1097: x_return_status := FND_API.G_RET_STS_ERROR;
1098: l_valid_gl_period_flag := 'N';
1099: x_msg_count := x_msg_count + 1;
1100: l_call_profile_gl_flag := 'N';
1101: l_gl_return_status := FND_API.G_RET_STS_ERROR;

Line 1101: l_gl_return_status := FND_API.G_RET_STS_ERROR;

1097: x_return_status := FND_API.G_RET_STS_ERROR;
1098: l_valid_gl_period_flag := 'N';
1099: x_msg_count := x_msg_count + 1;
1100: l_call_profile_gl_flag := 'N';
1101: l_gl_return_status := FND_API.G_RET_STS_ERROR;
1102: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1103: p_msg_name => 'PA_FP_PP_INVALID_PERIOD',
1104: p_token1 => 'PERIOD',
1105: p_value1 => p_gl_end_period);

Line 1118: x_return_status := FND_API.G_RET_STS_ERROR;

1114: gl.Period_Set_Name = l_gl_period_set_name AND
1115: gl.Period_Type = l_pa_period_type AND
1116: gl.Adjustment_Period_Flag = 'N' ;
1117: IF l_periods_count > 52 THEN
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: x_msg_count := x_msg_count + 1;
1120: l_call_profile_pa_flag := 'N';
1121: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1122: p_msg_name => 'PA_FP_PP_EXCEED_MAX_PDS');

Line 1125: x_return_status := FND_API.G_RET_STS_ERROR;

1121: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1122: p_msg_name => 'PA_FP_PP_EXCEED_MAX_PDS');
1123: END IF;
1124: IF l_pa_start_date > l_pa_start_date1 THEN
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: x_msg_count := x_msg_count + 1;
1127: l_call_profile_pa_flag := 'N';
1128: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1129: p_msg_name => 'PA_FP_PP_INVALID_PERIOD_RANGE');

Line 1141: x_return_status := FND_API.G_RET_STS_ERROR;

1137: gl.Period_Set_Name = l_gl_period_set_name AND
1138: gl.Period_Type = l_gl_period_type AND
1139: gl.Adjustment_Period_Flag = 'N' ;
1140: IF l_periods_count > 52 THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: x_msg_count := x_msg_count + 1;
1143: l_call_profile_gl_flag := 'N';
1144: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1145: p_msg_name => 'PA_FP_PP_EXCEED_MAX_PDS_GL');

Line 1148: x_return_status := FND_API.G_RET_STS_ERROR;

1144: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1145: p_msg_name => 'PA_FP_PP_EXCEED_MAX_PDS_GL');
1146: END IF;
1147: IF l_gl_start_date > l_gl_start_date1 THEN
1148: x_return_status := FND_API.G_RET_STS_ERROR;
1149: x_msg_count := x_msg_count + 1;
1150: l_call_profile_gl_flag := 'N';
1151: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1152: p_msg_name => 'PA_FP_PP_INVALID_PD_RANGE_GL');

Line 1220: x_return_status := FND_API.G_RET_STS_ERROR;

1216:
1217: IF ( l_PA_START_date < l_prj_PAper_START_date)
1218: THEN
1219:
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221: x_msg_count := x_msg_count + 1;
1222: l_call_profile_pa_flag := 'N';
1223: l_invalid_prj_dur_PA := 'Y';
1224: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 1281: x_return_status := FND_API.G_RET_STS_ERROR;

1277:
1278: IF ( l_PA_END_Date1 > l_prj_PAper_END_date)
1279: THEN
1280:
1281: x_return_status := FND_API.G_RET_STS_ERROR;
1282: x_msg_count := x_msg_count + 1;
1283: l_call_profile_pa_flag := 'N';
1284: l_invalid_prj_dur_PA := 'Y';
1285: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

1333:
1334: IF ( l_GL_START_date < l_prj_GLper_START_date)
1335: THEN
1336:
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: x_msg_count := x_msg_count + 1;
1339: l_call_profile_gl_flag := 'N';
1340: l_invalid_prj_dur_GL := 'Y';
1341: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 1393: x_return_status := FND_API.G_RET_STS_ERROR;

1389:
1390: IF ( l_GL_END_Date1 > l_prj_GLper_END_date)
1391: THEN
1392:
1393: x_return_status := FND_API.G_RET_STS_ERROR;
1394: x_msg_count := x_msg_count + 1;
1395: l_call_profile_gl_flag := 'N';
1396: l_invalid_prj_dur_GL := 'Y';
1397: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 1412: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS

1408:
1409:
1410: -- Bug 2589885, End: ---------------------------------------------
1411:
1412: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS
1413:
1414:
1415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1416: x_msg_count := fnd_msg_pub.count_msg;

Line 1415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1411:
1412: END IF; -- x_return_status = FND_API.G_RET_STS_SUCCESS
1413:
1414:
1415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1416: x_msg_count := fnd_msg_pub.count_msg;
1417: IF x_msg_count = 1 THEN
1418: PA_INTERFACE_UTILS_PUB.Get_Messages (
1419: p_encoded => FND_API.G_TRUE,

Line 1419: p_encoded => FND_API.G_TRUE,

1415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1416: x_msg_count := fnd_msg_pub.count_msg;
1417: IF x_msg_count = 1 THEN
1418: PA_INTERFACE_UTILS_PUB.Get_Messages (
1419: p_encoded => FND_API.G_TRUE,
1420: p_msg_index => 1,
1421: p_msg_count => 1 ,
1422: p_msg_data => l_msg_data ,
1423: p_data => x_msg_data,

Line 1471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1467: x_plan_end_date => l_para_plan_end_date,
1468: x_return_status => x_return_status,
1469: x_msg_count => x_msg_count,
1470: x_msg_data => x_msg_data );
1471: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1472: ROLLBACK;
1473: RETURN;
1474: END IF;
1475: END IF;

Line 1496: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1492: x_plan_end_date => l_para_plan_end_date,
1493: x_return_status => x_return_status,
1494: x_msg_count => x_msg_count,
1495: x_msg_data => x_msg_data );
1496: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1497: ROLLBACK;
1498: RETURN;
1499: END IF;
1500: END IF;

Line 1546: x_return_status := FND_API.G_RET_STS_ERROR;

1542: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1543: END IF;
1544: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1545: p_msg_name => 'PA_FP_PP_CONC_PGM_ERR');
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: ROLLBACK;
1548: RETURN;
1549: ELSE
1550: /* added for locking the budget versions */

Line 1617: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN

1613: END IF;
1614: END IF;
1615: x_conc_req_id := LTRIM(RTRIM(TO_CHAR(l_rpt_request_id)));
1616: END IF;
1617: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1618: COMMIT;
1619: ELSE
1620: ROLLBACK;
1621: END IF;

Line 1997: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1993: x_return_status => l_return_status,
1994: x_msg_count => l_msg_count,
1995: x_msg_data => l_msg_data );
1996:
1997: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1998: IF p_pa_debug_mode = 'Y' THEN
1999: pa_debug.g_err_stage := ' Maintain_Prj_Period_Profile Errored for PA';
2000: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2001: END IF;

Line 2038: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2034: x_return_status => l_return_status,
2035: x_msg_count => l_msg_count,
2036: x_msg_data => l_msg_data );
2037:
2038: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2039: IF p_pa_debug_mode = 'Y' THEN
2040: pa_debug.g_err_stage := ' Maintain_Prj_Period_Profile Errored for PA';
2041: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2042: END IF;

Line 2093: x_return_status := FND_API.G_RET_STS_SUCCESS;

2089:
2090: BEGIN
2091:
2092: x_msg_count := 0;
2093: x_return_status := FND_API.G_RET_STS_SUCCESS;
2094:
2095: pa_debug.set_err_stack('Get_Curr_Period_Profile_Info');
2096: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2097: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 2198: (p_encoded => FND_API.G_TRUE

2194:
2195: IF l_msg_count = 1 THEN
2196:
2197: PA_INTERFACE_UTILS_PUB.get_messages
2198: (p_encoded => FND_API.G_TRUE
2199: ,p_msg_index => 1
2200: ,p_msg_count => l_msg_count
2201: ,p_msg_data => l_msg_data
2202: ,p_data => l_data

Line 2219: x_return_status:= FND_API.G_RET_STS_ERROR;

2215: IF P_PA_DEBUG_MODE = 'Y' THEN
2216: pa_debug.write('Get_Curr_Period_Profile_Info: ' || g_module_name,pa_debug.g_err_stage,5);
2217: END IF;
2218:
2219: x_return_status:= FND_API.G_RET_STS_ERROR;
2220:
2221: pa_debug.reset_err_stack;
2222:
2223: RAISE;

Line 2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2223: RAISE;
2224:
2225: WHEN Others THEN
2226:
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2228: x_msg_count := 1;
2229: x_msg_data := SQLERRM;
2230:
2231: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_PRJ_PERIOD_PROFILE_UTILS'

Line 2358: x_return_status := FND_API.G_RET_STS_SUCCESS;

2354: IF P_PA_DEBUG_MODE = 'Y' THEN
2355: PA_DEBUG.Set_Curr_Function( p_function => 'Refresh_Period_Profile',
2356: p_debug_mode => l_debug_mode );
2357: END IF;
2358: x_return_status := FND_API.G_RET_STS_SUCCESS;
2359:
2360: IF P_PA_DEBUG_MODE = 'Y' THEN
2361: PA_DEBUG.g_err_stage := 'Entering Refresh Period Profile ' ||
2362: 'for Refreshing the Period Profile';

Line 2387: x_return_status := FND_API.G_RET_STS_ERROR;

2383: END IF;
2384: /* PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2385: p_msg_name => 'NULL_BDGT_VSN_ID');
2386: invalid message code, so commented */
2387: x_return_status := FND_API.G_RET_STS_ERROR;
2388: /* x_msg_data := 'NULL_BDGT_VSN_ID'; */
2389: IF P_PA_DEBUG_MODE = 'Y' THEN
2390: PA_DEBUG.Reset_Curr_Function;
2391: END IF;

Line 2424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2420: x_return_status => x_return_status,
2421: x_msg_count => x_msg_count,
2422: x_msg_data => x_msg_data
2423: );
2424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2425: ROLLBACK TO before_refresh_pd_profile;
2426: UPDATE_BUDGET_VERSION(p_budget_version_id => l_budget_version_id,
2427: p_return_status => x_return_status,
2428: p_project_id => p_project_id,

Line 2459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2455: ,x_return_status => x_return_status
2456: ,x_msg_count => x_msg_count
2457: ,x_msg_data => x_msg_data );
2458:
2459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2460: ROLLBACK TO before_refresh_pd_profile;
2461: UPDATE_BUDGET_VERSION(p_budget_version_id => l_budget_version_id,
2462: p_return_status => x_return_status,
2463: p_project_id => p_project_id,

Line 2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2484: PA_DEBUG.g_err_stage := 'Unexpected error in refresh_period_profile ';
2485: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2486: END IF;
2487: ROLLBACK TO before_refresh_pd_profile;
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2489: UPDATE_BUDGET_VERSION(p_budget_version_id => l_budget_version_id,
2490: p_return_status => x_return_status,
2491: p_project_id => p_project_id,
2492: p_request_id => l_request_id );

Line 2740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2736: x_return_status => l_return_status,
2737: x_msg_count => l_msg_count,
2738: x_msg_data => l_msg_data
2739: ) ;
2740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2741: l_msg_data := 'ERR_CALL_REFRESH_PERIOD_PROFILE';
2742: retcode := '2';
2743: errbuff := l_msg_data;
2744: END IF;

Line 2771: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2767: x_return_status => l_return_status,
2768: x_msg_count => l_msg_count,
2769: x_msg_data => l_msg_data
2770: ) ;
2771: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2772: l_msg_data := 'ERR_CALL_REFRESH_PERIOD_PROFILE';
2773: retcode := '2';
2774: errbuff := l_msg_data;
2775: END IF;

Line 2789: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2785: PA_DEBUG.g_err_stage := 'Unexpected error in wrapper_refresh_pd_profile ';
2786: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2787: END IF;
2788: retcode := '2';
2789: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2790: UPDATE_BUDGET_VERSION(p_budget_version_id => l_budget_version_id,
2791: p_return_status => l_return_status,
2792: p_project_id => p_project_id,
2793: p_request_id => l_request_id );

Line 2879: x_return_status := FND_API.G_RET_STS_SUCCESS;

2875: where period_profile_id = p_period_profile_id;
2876: period_profile_rec period_profile_csr%ROWTYPE;
2877:
2878: BEGIN
2879: x_return_status := FND_API.G_RET_STS_SUCCESS;
2880: select sysdate
2881: into l_current_date
2882: from dual;
2883: open period_profile_csr;

Line 2886: x_return_status := FND_API.G_RET_STS_ERROR;

2882: from dual;
2883: open period_profile_csr;
2884: fetch period_profile_csr into period_profile_rec;
2885: if period_profile_csr%NOTFOUND then
2886: x_return_status := FND_API.G_RET_STS_ERROR;
2887: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2888: p_msg_name => 'PA_FP_INVALID_PRJ_PROFILE');
2889: x_msg_count := fnd_msg_pub.count_msg;
2890: IF x_msg_count = 1 THEN

Line 2892: p_encoded => FND_API.G_TRUE,

2888: p_msg_name => 'PA_FP_INVALID_PRJ_PROFILE');
2889: x_msg_count := fnd_msg_pub.count_msg;
2890: IF x_msg_count = 1 THEN
2891: PA_INTERFACE_UTILS_PUB.Get_Messages (
2892: p_encoded => FND_API.G_TRUE,
2893: p_msg_index => 1,
2894: p_msg_count => 1 ,
2895: p_msg_data => l_msg_data ,
2896: p_data => x_msg_data,

Line 3224: if p_return_status <> FND_API.G_RET_STS_SUCCESS then

3220: p_project_id IN NUMBER,
3221: p_request_id IN NUMBER ) IS
3222: l_plan_proc_code pa_budget_versions.plan_processing_Code%type;
3223: BEGIN
3224: if p_return_status <> FND_API.G_RET_STS_SUCCESS then
3225: l_plan_proc_code := 'PPE';
3226: else
3227: l_plan_proc_code := 'PPG';
3228: end if;