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 1618: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 1998: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2039: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2094: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2199: (p_encoded => FND_API.G_TRUE

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

Line 2220: x_return_status:= FND_API.G_RET_STS_ERROR;

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

Line 2228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2359: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2388: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2425: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2460: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2762: x_return_status => l_return_status,
2763: x_msg_count => l_msg_count,
2764: x_msg_data => l_msg_data
2765: ) ;
2766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2767: l_msg_data := 'ERR_CALL_REFRESH_PERIOD_PROFILE';
2768: retcode := '2';
2769: errbuff := l_msg_data;
2770: END IF;

Line 2797: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2793: x_return_status => l_return_status,
2794: x_msg_count => l_msg_count,
2795: x_msg_data => l_msg_data
2796: ) ;
2797: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2798: l_msg_data := 'ERR_CALL_REFRESH_PERIOD_PROFILE';
2799: retcode := '2';
2800: errbuff := l_msg_data;
2801: END IF;

Line 2806: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2802: END IF;
2803: END IF;
2804: END LOOP;
2805: /* Changes for 7563735 - unsetting the locked_by_person_id here, depending on the return_status code*/
2806: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2807: UPDATE pa_budget_versions SET
2808: plan_processing_code = 'PPE',
2809: locked_by_person_id = null,
2810: record_version_number = nvl(record_version_number,0) + 1,

Line 2846: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2842: PA_DEBUG.g_err_stage := 'Unexpected error in wrapper_refresh_pd_profile ';
2843: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2844: END IF;
2845: retcode := '2';
2846: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2847: UPDATE_BUDGET_VERSION(p_budget_version_id => l_budget_version_id,
2848: p_return_status => l_return_status,
2849: p_project_id => p_project_id,
2850: p_request_id => l_request_id );

Line 2936: x_return_status := FND_API.G_RET_STS_SUCCESS;

2932: where period_profile_id = p_period_profile_id;
2933: period_profile_rec period_profile_csr%ROWTYPE;
2934:
2935: BEGIN
2936: x_return_status := FND_API.G_RET_STS_SUCCESS;
2937: select sysdate
2938: into l_current_date
2939: from dual;
2940: open period_profile_csr;

Line 2943: x_return_status := FND_API.G_RET_STS_ERROR;

2939: from dual;
2940: open period_profile_csr;
2941: fetch period_profile_csr into period_profile_rec;
2942: if period_profile_csr%NOTFOUND then
2943: x_return_status := FND_API.G_RET_STS_ERROR;
2944: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2945: p_msg_name => 'PA_FP_INVALID_PRJ_PROFILE');
2946: x_msg_count := fnd_msg_pub.count_msg;
2947: IF x_msg_count = 1 THEN

Line 2949: p_encoded => FND_API.G_TRUE,

2945: p_msg_name => 'PA_FP_INVALID_PRJ_PROFILE');
2946: x_msg_count := fnd_msg_pub.count_msg;
2947: IF x_msg_count = 1 THEN
2948: PA_INTERFACE_UTILS_PUB.Get_Messages (
2949: p_encoded => FND_API.G_TRUE,
2950: p_msg_index => 1,
2951: p_msg_count => 1 ,
2952: p_msg_data => l_msg_data ,
2953: p_data => x_msg_data,

Line 3281: if p_return_status <> FND_API.G_RET_STS_SUCCESS then

3277: p_project_id IN NUMBER,
3278: p_request_id IN NUMBER ) IS
3279: l_plan_proc_code pa_budget_versions.plan_processing_Code%type;
3280: BEGIN
3281: if p_return_status <> FND_API.G_RET_STS_SUCCESS then
3282: l_plan_proc_code := 'PPE';
3283: else
3284: l_plan_proc_code := 'PPG';
3285: end if;