DBA Data[Home] [Help]

APPS.PA_BUDGET_CHECK_PVT dependencies on FND_API

Line 179: p_return_status := FND_API.G_RET_STS_SUCCESS;

175: END IF;
176:
177: -- Set API return status to success
178:
179: p_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: -- check business rules related to timephasing
182: -- P = PA period, G = GL period, R = Date Range
183:

Line 213: RAISE FND_API.G_EXC_ERROR;

209: ,p_attribute3 => ''
210: ,p_attribute4 => ''
211: ,p_attribute5 => '');
212: END IF;
213: RAISE FND_API.G_EXC_ERROR;
214: ELSE
215: --try to get the period name related to those dates
216:
217: OPEN l_period_name_csr( l_budget_start_date_in

Line 239: RAISE FND_API.G_EXC_ERROR;

235: ,p_attribute5 => '');
236: END IF;
237:
238: CLOSE l_period_name_csr;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241:
242: CLOSE l_period_name_csr;
243:

Line 276: RAISE FND_API.G_EXC_ERROR;

272: ,p_attribute5 => '');
273: END IF;
274:
275: CLOSE l_budget_periods_csr;
276: RAISE FND_API.G_EXC_ERROR;
277: END IF;
278:
279: CLOSE l_budget_periods_csr;
280:

Line 344: RAISE FND_API.G_EXC_ERROR;

340: ,p_attribute4 => ''
341: ,p_attribute5 => '');
342: END IF;
343:
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347: IF l_budget_end_date_in = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
348: OR l_budget_end_date_in IS NULL

Line 364: RAISE FND_API.G_EXC_ERROR;

360: ,p_attribute4 => ''
361: ,p_attribute5 => '');
362: END IF;
363:
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366: /*
367: The following code is added while doing webADI changes. The following
368: validations are added (which were not being done earlier):

Line 394: RAISE FND_API.G_EXC_ERROR;

390: ,p_attribute4 => ''
391: ,p_attribute5 => '');
392: END IF;
393:
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: IF p_entry_level_code = 'P' THEN
398: OPEN l_project_dates_csr(p_project_id);

Line 415: RAISE FND_API.G_EXC_ERROR;

411: ,p_attribute3 => ''
412: ,p_attribute4 => ''
413: ,p_attribute5 => '');
414:
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417:
418: ELSE /* planning level is 'Task' */
419: OPEN l_task_dates_csr(p_task_id);

Line 436: RAISE FND_API.G_EXC_ERROR;

432: ,p_attribute3 => ''
433: ,p_attribute4 => ''
434: ,p_attribute5 => '');
435:
436: RAISE FND_API.G_EXC_ERROR;
437: END IF;
438:
439: END IF; -- End If for entry level 'Project'
440: -- End of additional validations done as part of webADI changes

Line 492: RAISE FND_API.G_EXC_ERROR;

488: ,p_attribute3 => ''
489: ,p_attribute4 => ''
490: ,p_attribute5 => '');
491: END IF;
492: RAISE FND_API.G_EXC_ERROR;
493:
494: END IF;
495:
496: IF (l_project_end_date IS NULL) THEN

Line 510: RAISE FND_API.G_EXC_ERROR;

506: ,p_attribute3 => ''
507: ,p_attribute4 => ''
508: ,p_attribute5 => '');
509: END IF;
510: RAISE FND_API.G_EXC_ERROR;
511: END IF; -- project end date is not null
512:
513: p_budget_start_date_out := l_project_start_date;
514: p_budget_end_date_out := l_project_end_date;

Line 537: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

533: ,x_msg_data => l_msg_data
534: ,x_msg_count => l_msg_count
535: ,x_return_status => p_return_status);
536:
537: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
538: -- raising execption to show the error messages
539: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
540: END IF;
541:

Line 594: RAISE FND_API.G_EXC_ERROR;

590: ,p_attribute4 => ''
591: ,p_attribute5 => '');
592: END IF;
593:
594: RAISE FND_API.G_EXC_ERROR;
595: END IF;
596:
597: IF (l_project_end_date IS NULL) THEN
598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 611: RAISE FND_API.G_EXC_ERROR;

607: ,p_attribute4 => ''
608: ,p_attribute5 => '');
609: END IF;
610:
611: RAISE FND_API.G_EXC_ERROR;
612: END IF;
613: END IF;
614:
615: p_budget_start_date_out := l_project_start_date;

Line 641: RAISE FND_API.G_EXC_ERROR;

637: ,p_attribute3 => ''
638: ,p_attribute4 => ''
639: ,p_attribute5 => '');
640: END IF;
641: RAISE FND_API.G_EXC_ERROR;
642: END IF;
643: p_budget_start_date_out := l_task_start_date;
644: p_budget_end_date_out := l_project_end_date;
645: p_period_name_out := p_period_name_in;

Line 672: RAISE FND_API.G_EXC_ERROR;

668: ,p_attribute3 => ''
669: ,p_attribute4 => ''
670: ,p_attribute5 => '');
671:
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF p_context = 'WEBADI' THEN
674: x_error_code := 'FP_WEBADI_PLAN_DATE_ERR';
675: p_return_status := FND_API.G_RET_STS_ERROR;
676: RETURN;

Line 675: p_return_status := FND_API.G_RET_STS_ERROR;

671:
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF p_context = 'WEBADI' THEN
674: x_error_code := 'FP_WEBADI_PLAN_DATE_ERR';
675: p_return_status := FND_API.G_RET_STS_ERROR;
676: RETURN;
677: END IF;
678: END IF; -- start date > end date
679: p_budget_start_date_out := l_budget_start_date_in;

Line 697: RAISE FND_API.G_EXC_ERROR;

693: ,p_attribute3 => ''
694: ,p_attribute4 => ''
695: ,p_attribute5 => '');
696:
697: RAISE FND_API.G_EXC_ERROR;
698: ELSIF p_context = 'WEBADI' THEN
699: x_error_code := 'PA_FP_WA_PLAN_DATE_MIS';
700: p_return_status := FND_API.G_RET_STS_ERROR;
701: RETURN;

Line 700: p_return_status := FND_API.G_RET_STS_ERROR;

696:
697: RAISE FND_API.G_EXC_ERROR;
698: ELSIF p_context = 'WEBADI' THEN
699: x_error_code := 'PA_FP_WA_PLAN_DATE_MIS';
700: p_return_status := FND_API.G_RET_STS_ERROR;
701: RETURN;
702: END IF;
703: ELSIF l_budget_start_date_in IS NULL AND
704: l_budget_end_date_in IS NOT NULL THEN

Line 718: RAISE FND_API.G_EXC_ERROR;

714: ,p_attribute3 => ''
715: ,p_attribute4 => ''
716: ,p_attribute5 => '');
717:
718: RAISE FND_API.G_EXC_ERROR;
719: ELSIF p_context = 'WEBADI' THEN
720: x_error_code := 'PA_FP_WA_PLAN_DATE_MIS';
721: p_return_status := FND_API.G_RET_STS_ERROR;
722: RETURN;

Line 721: p_return_status := FND_API.G_RET_STS_ERROR;

717:
718: RAISE FND_API.G_EXC_ERROR;
719: ELSIF p_context = 'WEBADI' THEN
720: x_error_code := 'PA_FP_WA_PLAN_DATE_MIS';
721: p_return_status := FND_API.G_RET_STS_ERROR;
722: RETURN;
723: END IF;
724: ELSIF l_budget_start_date_in IS NULL AND
725: l_budget_end_date_in IS NULL THEN

Line 763: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

759: ,x_msg_data => l_msg_data
760: ,x_msg_count => l_msg_count
761: ,x_return_status => p_return_status);
762:
763: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
764: -- raising execption to show the error messages
765: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
766: END IF;
767:

Line 830: p_return_status := FND_API.G_RET_STS_ERROR;

826: END;
827:
828: IF valid_gl_start_date <> 'Y' THEN
829: x_error_code := 'PA_FP_WA_PLAN_ST_DATE_NOT_VLD';
830: p_return_status := FND_API.G_RET_STS_ERROR;
831: RETURN;
832: END IF;
833:
834: IF valid_gl_end_date <> 'Y' THEN

Line 875: p_return_status := FND_API.G_RET_STS_ERROR;

871: END;
872:
873: IF valid_gl_start_date <> 'Y' THEN
874: x_error_code := 'PA_FP_WA_PLAN_ST_DATE_NOT_VLD';
875: p_return_status := FND_API.G_RET_STS_ERROR;
876: RETURN;
877: END IF;
878:
879: IF valid_gl_end_date <> 'Y' THEN

Line 881: p_return_status := FND_API.G_RET_STS_ERROR;

877: END IF;
878:
879: IF valid_gl_end_date <> 'Y' THEN
880: x_error_code := 'PA_FP_WA_PLAN_EN_DATE_NOT_VLD';
881: p_return_status := FND_API.G_RET_STS_ERROR;
882: RETURN;
883: END IF;
884: END IF;
885:

Line 888: p_return_status := FND_API.G_RET_STS_ERROR;

884: END IF;
885:
886: IF l_budget_start_date > l_budget_end_date THEN
887: x_error_code := 'PA_FP_WA_PLAN_DATE_ERR';
888: p_return_status := FND_API.G_RET_STS_ERROR;
889: RETURN;
890: END IF;
891: p_budget_start_date_out := l_budget_start_date_in;
892: p_budget_end_date_out := l_budget_end_date_in;

Line 898: p_return_status := FND_API.G_RET_STS_ERROR;

894: ELSIF l_budget_start_date_in IS NOT NULL AND
895: l_budget_end_date_in IS NULL THEN
896: -- throw error if one of the date is missing
897: x_error_code := 'PA_FP_WA_PLAN_DATE_MIS';
898: p_return_status := FND_API.G_RET_STS_ERROR;
899: RETURN;
900:
901: ELSIF l_budget_start_date_in IS NULL AND
902: l_budget_end_date_in IS NOT NULL THEN

Line 904: p_return_status := FND_API.G_RET_STS_ERROR;

900:
901: ELSIF l_budget_start_date_in IS NULL AND
902: l_budget_end_date_in IS NOT NULL THEN
903: x_error_code := 'PA_FP_WA_PLAN_DATE_MIS';
904: p_return_status := FND_API.G_RET_STS_ERROR;
905: RETURN;
906: /*ELSIF l_budget_start_date_in IS NULL AND
907: l_budget_end_date_in IS NULL THEN
908: -- call an api to derive the default planning dates

Line 924: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

920: ,x_msg_data => l_msg_data
921: ,x_msg_count => l_msg_count
922: ,x_return_status => p_return_status);
923:
924: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
925: -- raising execption to show the error messages
926: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
927: END IF;
928:

Line 951: (p_encoded => FND_API.G_TRUE

947: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
948: l_msg_count := FND_MSG_PUB.count_msg;
949: IF l_msg_count = 1 THEN
950: PA_INTERFACE_UTILS_PUB.get_messages
951: (p_encoded => FND_API.G_TRUE
952: ,p_msg_index => 1
953: ,p_msg_count => l_msg_count
954: ,p_msg_data => l_msg_data
955: ,p_data => l_data

Line 958: p_return_status := FND_API.G_RET_STS_ERROR;

954: ,p_msg_data => l_msg_data
955: ,p_data => l_data
956: ,p_msg_index_out => l_msg_index_out);
957: END IF;
958: p_return_status := FND_API.G_RET_STS_ERROR;
959:
960: WHEN FND_API.G_EXC_ERROR
961: THEN
962:

Line 960: WHEN FND_API.G_EXC_ERROR

956: ,p_msg_index_out => l_msg_index_out);
957: END IF;
958: p_return_status := FND_API.G_RET_STS_ERROR;
959:
960: WHEN FND_API.G_EXC_ERROR
961: THEN
962:
963: ROLLBACK TO get_valid_period_dates_pvt;
964:

Line 965: p_return_status := FND_API.G_RET_STS_ERROR;

961: THEN
962:
963: ROLLBACK TO get_valid_period_dates_pvt;
964:
965: p_return_status := FND_API.G_RET_STS_ERROR;
966:
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
968: THEN
969:

Line 967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

963: ROLLBACK TO get_valid_period_dates_pvt;
964:
965: p_return_status := FND_API.G_RET_STS_ERROR;
966:
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
968: THEN
969:
970: ROLLBACK TO get_valid_period_dates_pvt;
971:

Line 972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

968: THEN
969:
970: ROLLBACK TO get_valid_period_dates_pvt;
971:
972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973:
974: WHEN OTHERS THEN
975:
976: ROLLBACK TO get_valid_period_dates_pvt;

Line 978: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

974: WHEN OTHERS THEN
975:
976: ROLLBACK TO get_valid_period_dates_pvt;
977:
978: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979:
980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
981: THEN
982: FND_MSG_PUB.add_exc_msg

Line 1092: p_return_status := FND_API.G_RET_STS_SUCCESS;

1088: SAVEPOINT check_entry_method_flags_pvt;
1089:
1090: --Set API return status to success
1091:
1092: p_return_status := FND_API.G_RET_STS_SUCCESS;
1093: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1094: l_module_name := 'check_entry_method_flags_Pvt: ' || g_module_name;
1095:
1096: IF l_debug_mode = 'Y' THEN

Line 1144: p_return_status := FND_API.G_RET_STS_ERROR;

1140: PA_UTILS.ADD_MESSAGE
1141: (p_app_short_name => 'PA',
1142: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1143:
1144: p_return_status := FND_API.G_RET_STS_ERROR;
1145: RETURN;
1146:
1147: END IF;--IF (p_budget_amount_code IS NOT NULL) AND (p_version_type IS NULL)
1148:

Line 1166: p_return_status := FND_API.G_RET_STS_ERROR;

1162: */
1163: PA_UTILS.ADD_MESSAGE
1164: (p_app_short_name => 'PA',
1165: p_msg_name => 'PA_COST_QTY_NOT_ALLOWED');
1166: p_return_status := FND_API.G_RET_STS_ERROR;
1167: END IF;
1168:
1169: --RAISE FND_API.G_EXC_ERROR;
1170: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1169: --RAISE FND_API.G_EXC_ERROR;

1165: p_msg_name => 'PA_COST_QTY_NOT_ALLOWED');
1166: p_return_status := FND_API.G_RET_STS_ERROR;
1167: END IF;
1168:
1169: --RAISE FND_API.G_EXC_ERROR;
1170: p_return_status := FND_API.G_RET_STS_ERROR;
1171: IF l_debug_mode='Y' THEN
1172: pa_debug.g_err_stage:= 'Cost Qty not allowed' ;
1173: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1170: p_return_status := FND_API.G_RET_STS_ERROR;

1166: p_return_status := FND_API.G_RET_STS_ERROR;
1167: END IF;
1168:
1169: --RAISE FND_API.G_EXC_ERROR;
1170: p_return_status := FND_API.G_RET_STS_ERROR;
1171: IF l_debug_mode='Y' THEN
1172: pa_debug.g_err_stage:= 'Cost Qty not allowed' ;
1173: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1174: END IF;

Line 1185: p_return_status := FND_API.G_RET_STS_ERROR;

1181: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1182: END IF;
1183:
1184: x_webadi_error_code := 'PA_FP_WA_COST_QTY_NOT_ALWD';
1185: p_return_status := FND_API.G_RET_STS_ERROR;
1186: RETURN;
1187: END IF;
1188:
1189: END IF;

Line 1202: p_return_status := FND_API.G_RET_STS_ERROR;

1198: */
1199: PA_UTILS.ADD_MESSAGE
1200: (p_app_short_name => 'PA',
1201: p_msg_name => 'PA_RAW_COST_NOT_ALLOWED');
1202: p_return_status := FND_API.G_RET_STS_ERROR;
1203: END IF;
1204:
1205: --RAISE FND_API.G_EXC_ERROR;
1206: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1205: --RAISE FND_API.G_EXC_ERROR;

1201: p_msg_name => 'PA_RAW_COST_NOT_ALLOWED');
1202: p_return_status := FND_API.G_RET_STS_ERROR;
1203: END IF;
1204:
1205: --RAISE FND_API.G_EXC_ERROR;
1206: p_return_status := FND_API.G_RET_STS_ERROR;
1207: IF l_debug_mode='Y' THEN
1208: pa_debug.g_err_stage:= 'Raw Cost not allowed' ;
1209: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1206: p_return_status := FND_API.G_RET_STS_ERROR;

1202: p_return_status := FND_API.G_RET_STS_ERROR;
1203: END IF;
1204:
1205: --RAISE FND_API.G_EXC_ERROR;
1206: p_return_status := FND_API.G_RET_STS_ERROR;
1207: IF l_debug_mode='Y' THEN
1208: pa_debug.g_err_stage:= 'Raw Cost not allowed' ;
1209: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1210: END IF;

Line 1221: p_return_status := FND_API.G_RET_STS_ERROR;

1217: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1218: END IF;
1219:
1220: x_webadi_error_code := 'PA_FP_WA_RAW_COST_NOT_ALWD';
1221: p_return_status := FND_API.G_RET_STS_ERROR;
1222: RETURN;
1223: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1224:
1225: END IF;

Line 1239: --RAISE FND_API.G_EXC_ERROR;

1235: PA_UTILS.ADD_MESSAGE
1236: (p_app_short_name => 'PA',
1237: p_msg_name => 'PA_BURD_COST_NOT_ALLOWED');
1238:
1239: --RAISE FND_API.G_EXC_ERROR;
1240: p_return_status := FND_API.G_RET_STS_ERROR;
1241: END IF;
1242: IF l_debug_mode='Y' THEN
1243: pa_debug.g_err_stage:= 'Burd Cost not allowed' ;

Line 1240: p_return_status := FND_API.G_RET_STS_ERROR;

1236: (p_app_short_name => 'PA',
1237: p_msg_name => 'PA_BURD_COST_NOT_ALLOWED');
1238:
1239: --RAISE FND_API.G_EXC_ERROR;
1240: p_return_status := FND_API.G_RET_STS_ERROR;
1241: END IF;
1242: IF l_debug_mode='Y' THEN
1243: pa_debug.g_err_stage:= 'Burd Cost not allowed' ;
1244: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1255: p_return_status := FND_API.G_RET_STS_ERROR;

1251: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1252: END IF;
1253:
1254: x_webadi_error_code := 'PA_FP_WA_BURD_COST_NOT_ALWD';
1255: p_return_status := FND_API.G_RET_STS_ERROR;
1256: RETURN;
1257: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1258:
1259: END IF;

Line 1272: p_return_status := FND_API.G_RET_STS_ERROR;

1268: */
1269: PA_UTILS.ADD_MESSAGE
1270: (p_app_short_name => 'PA',
1271: p_msg_name => 'PA_REVENUE_NOT_ALLOWED');
1272: p_return_status := FND_API.G_RET_STS_ERROR;
1273: END IF;
1274:
1275: IF l_debug_mode='Y' THEN
1276: pa_debug.g_err_stage:= 'Rev Amt not allowed' ;

Line 1280: --RAISE FND_API.G_EXC_ERROR;

1276: pa_debug.g_err_stage:= 'Rev Amt not allowed' ;
1277: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1278: END IF;
1279:
1280: --RAISE FND_API.G_EXC_ERROR;
1281: p_return_status := FND_API.G_RET_STS_ERROR;
1282: ELSIF p_context = 'WEBADI' THEN
1283: IF l_debug_mode='Y' THEN
1284: pa_debug.g_err_stage:= 'WEBADI: Revenue not allowed';

Line 1281: p_return_status := FND_API.G_RET_STS_ERROR;

1277: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1278: END IF;
1279:
1280: --RAISE FND_API.G_EXC_ERROR;
1281: p_return_status := FND_API.G_RET_STS_ERROR;
1282: ELSIF p_context = 'WEBADI' THEN
1283: IF l_debug_mode='Y' THEN
1284: pa_debug.g_err_stage:= 'WEBADI: Revenue not allowed';
1285: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1291: p_return_status := FND_API.G_RET_STS_ERROR;

1287: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1288: END IF;
1289:
1290: x_webadi_error_code := 'PA_FP_WA_REVENUE_NOT_ALWD';
1291: p_return_status := FND_API.G_RET_STS_ERROR;
1292: RETURN;
1293: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1294: END IF;
1295:

Line 1311: p_return_status := FND_API.G_RET_STS_ERROR;

1307: */
1308: PA_UTILS.ADD_MESSAGE
1309: (p_app_short_name => 'PA',
1310: p_msg_name => 'PA_REV_QTY_NOT_ALLOWED');
1311: p_return_status := FND_API.G_RET_STS_ERROR;
1312: END IF;
1313:
1314: --RAISE FND_API.G_EXC_ERROR;
1315: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1314: --RAISE FND_API.G_EXC_ERROR;

1310: p_msg_name => 'PA_REV_QTY_NOT_ALLOWED');
1311: p_return_status := FND_API.G_RET_STS_ERROR;
1312: END IF;
1313:
1314: --RAISE FND_API.G_EXC_ERROR;
1315: p_return_status := FND_API.G_RET_STS_ERROR;
1316: IF l_debug_mode='Y' THEN
1317: pa_debug.g_err_stage:= 'Rev Qty not allowed' ;
1318: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1315: p_return_status := FND_API.G_RET_STS_ERROR;

1311: p_return_status := FND_API.G_RET_STS_ERROR;
1312: END IF;
1313:
1314: --RAISE FND_API.G_EXC_ERROR;
1315: p_return_status := FND_API.G_RET_STS_ERROR;
1316: IF l_debug_mode='Y' THEN
1317: pa_debug.g_err_stage:= 'Rev Qty not allowed' ;
1318: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1319: END IF;

Line 1330: p_return_status := FND_API.G_RET_STS_ERROR;

1326: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1327: END IF;
1328:
1329: x_webadi_error_code := 'PA_FP_WA_REV_QTY_NOT_ALWD';
1330: p_return_status := FND_API.G_RET_STS_ERROR;
1331: RETURN;
1332: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1333: END IF;
1334:

Line 1346: p_return_status := FND_API.G_RET_STS_ERROR;

1342: */
1343: PA_UTILS.ADD_MESSAGE
1344: (p_app_short_name => 'PA',
1345: p_msg_name => 'PA_REVENUE_NOT_ALLOWED');
1346: p_return_status := FND_API.G_RET_STS_ERROR;
1347: END IF;
1348: IF l_debug_mode='Y' THEN
1349: pa_debug.g_err_stage:= 'Rev Amt not allowed' ;
1350: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1353: --RAISE FND_API.G_EXC_ERROR;

1349: pa_debug.g_err_stage:= 'Rev Amt not allowed' ;
1350: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1351: END IF;
1352:
1353: --RAISE FND_API.G_EXC_ERROR;
1354: p_return_status := FND_API.G_RET_STS_ERROR;
1355: ELSIF p_context = 'WEBADI' THEN
1356: IF l_debug_mode='Y' THEN
1357: pa_debug.g_err_stage:= 'WEBADI: Revenue not allowed';

Line 1354: p_return_status := FND_API.G_RET_STS_ERROR;

1350: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1351: END IF;
1352:
1353: --RAISE FND_API.G_EXC_ERROR;
1354: p_return_status := FND_API.G_RET_STS_ERROR;
1355: ELSIF p_context = 'WEBADI' THEN
1356: IF l_debug_mode='Y' THEN
1357: pa_debug.g_err_stage:= 'WEBADI: Revenue not allowed';
1358: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1364: p_return_status := FND_API.G_RET_STS_ERROR;

1360: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1361: END IF;
1362:
1363: x_webadi_error_code := 'PA_FP_WA_REVENUE_NOT_ALWD';
1364: p_return_status := FND_API.G_RET_STS_ERROR;
1365: RETURN;
1366: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1367: END IF;
1368:

Line 1382: p_return_status := FND_API.G_RET_STS_ERROR;

1378: */
1379: PA_UTILS.ADD_MESSAGE
1380: (p_app_short_name => 'PA',
1381: p_msg_name => 'PA_RAW_COST_NOT_ALLOWED');
1382: p_return_status := FND_API.G_RET_STS_ERROR;
1383: END IF;
1384:
1385: --RAISE FND_API.G_EXC_ERROR;
1386: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1385: --RAISE FND_API.G_EXC_ERROR;

1381: p_msg_name => 'PA_RAW_COST_NOT_ALLOWED');
1382: p_return_status := FND_API.G_RET_STS_ERROR;
1383: END IF;
1384:
1385: --RAISE FND_API.G_EXC_ERROR;
1386: p_return_status := FND_API.G_RET_STS_ERROR;
1387: IF l_debug_mode='Y' THEN
1388: pa_debug.g_err_stage:= 'Raw Cost not allowed' ;
1389: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1386: p_return_status := FND_API.G_RET_STS_ERROR;

1382: p_return_status := FND_API.G_RET_STS_ERROR;
1383: END IF;
1384:
1385: --RAISE FND_API.G_EXC_ERROR;
1386: p_return_status := FND_API.G_RET_STS_ERROR;
1387: IF l_debug_mode='Y' THEN
1388: pa_debug.g_err_stage:= 'Raw Cost not allowed' ;
1389: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1390:

Line 1401: p_return_status := FND_API.G_RET_STS_ERROR;

1397: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1398: END IF;
1399:
1400: x_webadi_error_code := 'PA_FP_WA_RAW_COST_NOT_ALWD';
1401: p_return_status := FND_API.G_RET_STS_ERROR;
1402: RETURN;
1403: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1404:
1405: END IF;

Line 1418: --RAISE FND_API.G_EXC_ERROR;

1414: PA_UTILS.ADD_MESSAGE
1415: (p_app_short_name => 'PA',
1416: p_msg_name => 'PA_BURD_COST_NOT_ALLOWED');
1417:
1418: --RAISE FND_API.G_EXC_ERROR;
1419: p_return_status := FND_API.G_RET_STS_ERROR;
1420: END IF;
1421: IF l_debug_mode='Y' THEN
1422: pa_debug.g_err_stage:= 'Burd Cost not allowed' ;

Line 1419: p_return_status := FND_API.G_RET_STS_ERROR;

1415: (p_app_short_name => 'PA',
1416: p_msg_name => 'PA_BURD_COST_NOT_ALLOWED');
1417:
1418: --RAISE FND_API.G_EXC_ERROR;
1419: p_return_status := FND_API.G_RET_STS_ERROR;
1420: END IF;
1421: IF l_debug_mode='Y' THEN
1422: pa_debug.g_err_stage:= 'Burd Cost not allowed' ;
1423: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1434: p_return_status := FND_API.G_RET_STS_ERROR;

1430: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1431: END IF;
1432:
1433: x_webadi_error_code := 'PA_FP_WA_BURD_COST_NOT_ALWD';
1434: p_return_status := FND_API.G_RET_STS_ERROR;
1435: RETURN;
1436: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1437: END IF;
1438:

Line 1453: p_return_status := FND_API.G_RET_STS_ERROR;

1449: */
1450: PA_UTILS.ADD_MESSAGE
1451: (p_app_short_name => 'PA',
1452: p_msg_name => 'PA_REV_QTY_NOT_ALLOWED');
1453: p_return_status := FND_API.G_RET_STS_ERROR;
1454: END IF;
1455:
1456: --RAISE FND_API.G_EXC_ERROR;
1457: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1456: --RAISE FND_API.G_EXC_ERROR;

1452: p_msg_name => 'PA_REV_QTY_NOT_ALLOWED');
1453: p_return_status := FND_API.G_RET_STS_ERROR;
1454: END IF;
1455:
1456: --RAISE FND_API.G_EXC_ERROR;
1457: p_return_status := FND_API.G_RET_STS_ERROR;
1458: IF l_debug_mode='Y' THEN
1459: pa_debug.g_err_stage:= 'All Qty not allowed' ;
1460: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1457: p_return_status := FND_API.G_RET_STS_ERROR;

1453: p_return_status := FND_API.G_RET_STS_ERROR;
1454: END IF;
1455:
1456: --RAISE FND_API.G_EXC_ERROR;
1457: p_return_status := FND_API.G_RET_STS_ERROR;
1458: IF l_debug_mode='Y' THEN
1459: pa_debug.g_err_stage:= 'All Qty not allowed' ;
1460: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1461: END IF;

Line 1471: p_return_status := FND_API.G_RET_STS_ERROR;

1467: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1468: END IF;
1469:
1470: x_webadi_error_code := 'PA_FP_WA_REV_QTY_NOT_ALWD';
1471: p_return_status := FND_API.G_RET_STS_ERROR;
1472: RETURN;
1473: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1474: END IF;
1475:

Line 1487: p_return_status := FND_API.G_RET_STS_ERROR;

1483: */
1484: PA_UTILS.ADD_MESSAGE
1485: (p_app_short_name => 'PA',
1486: p_msg_name => 'PA_RAW_COST_NOT_ALLOWED');
1487: p_return_status := FND_API.G_RET_STS_ERROR;
1488: END IF;
1489:
1490: --RAISE FND_API.G_EXC_ERROR;
1491: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1490: --RAISE FND_API.G_EXC_ERROR;

1486: p_msg_name => 'PA_RAW_COST_NOT_ALLOWED');
1487: p_return_status := FND_API.G_RET_STS_ERROR;
1488: END IF;
1489:
1490: --RAISE FND_API.G_EXC_ERROR;
1491: p_return_status := FND_API.G_RET_STS_ERROR;
1492: IF l_debug_mode='Y' THEN
1493: pa_debug.g_err_stage:= 'All Raw Cost not allowed' ;
1494: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1491: p_return_status := FND_API.G_RET_STS_ERROR;

1487: p_return_status := FND_API.G_RET_STS_ERROR;
1488: END IF;
1489:
1490: --RAISE FND_API.G_EXC_ERROR;
1491: p_return_status := FND_API.G_RET_STS_ERROR;
1492: IF l_debug_mode='Y' THEN
1493: pa_debug.g_err_stage:= 'All Raw Cost not allowed' ;
1494: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1495: END IF;

Line 1505: p_return_status := FND_API.G_RET_STS_ERROR;

1501: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1502: END IF;
1503:
1504: x_webadi_error_code := 'PA_FP_WA_RAW_COST_NOT_ALWD';
1505: p_return_status := FND_API.G_RET_STS_ERROR;
1506: RETURN;
1507: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1508: END IF;
1509:

Line 1522: --RAISE FND_API.G_EXC_ERROR;

1518: PA_UTILS.ADD_MESSAGE
1519: (p_app_short_name => 'PA',
1520: p_msg_name => 'PA_BURD_COST_NOT_ALLOWED');
1521:
1522: --RAISE FND_API.G_EXC_ERROR;
1523: p_return_status := FND_API.G_RET_STS_ERROR;
1524: END IF;
1525: IF l_debug_mode='Y' THEN
1526: pa_debug.g_err_stage:= 'All Burd Cost not allowed' ;

Line 1523: p_return_status := FND_API.G_RET_STS_ERROR;

1519: (p_app_short_name => 'PA',
1520: p_msg_name => 'PA_BURD_COST_NOT_ALLOWED');
1521:
1522: --RAISE FND_API.G_EXC_ERROR;
1523: p_return_status := FND_API.G_RET_STS_ERROR;
1524: END IF;
1525: IF l_debug_mode='Y' THEN
1526: pa_debug.g_err_stage:= 'All Burd Cost not allowed' ;
1527: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1538: p_return_status := FND_API.G_RET_STS_ERROR;

1534: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1535: END IF;
1536:
1537: x_webadi_error_code := 'PA_FP_WA_BURD_COST_NOT_ALWD';
1538: p_return_status := FND_API.G_RET_STS_ERROR;
1539: RETURN;
1540: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1541:
1542: END IF;

Line 1557: --RAISE FND_API.G_EXC_ERROR;

1553: PA_UTILS.ADD_MESSAGE
1554: (p_app_short_name => 'PA',
1555: p_msg_name => 'PA_REVENUE_NOT_ALLOWED');
1556:
1557: --RAISE FND_API.G_EXC_ERROR;
1558: p_return_status := FND_API.G_RET_STS_ERROR;
1559:
1560: END IF;
1561: IF l_debug_mode='Y' THEN

Line 1558: p_return_status := FND_API.G_RET_STS_ERROR;

1554: (p_app_short_name => 'PA',
1555: p_msg_name => 'PA_REVENUE_NOT_ALLOWED');
1556:
1557: --RAISE FND_API.G_EXC_ERROR;
1558: p_return_status := FND_API.G_RET_STS_ERROR;
1559:
1560: END IF;
1561: IF l_debug_mode='Y' THEN
1562: pa_debug.g_err_stage:= 'All Revenue not allowed' ;

Line 1567: --RAISE FND_API.G_EXC_ERROR;

1563: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1564:
1565: END IF;
1566:
1567: --RAISE FND_API.G_EXC_ERROR;
1568: p_return_status := FND_API.G_RET_STS_ERROR;
1569: ELSIF p_context = 'WEBADI' THEN
1570: IF l_debug_mode='Y' THEN
1571: pa_debug.g_err_stage:= 'WEBADI: Revenue not allowed';

Line 1568: p_return_status := FND_API.G_RET_STS_ERROR;

1564:
1565: END IF;
1566:
1567: --RAISE FND_API.G_EXC_ERROR;
1568: p_return_status := FND_API.G_RET_STS_ERROR;
1569: ELSIF p_context = 'WEBADI' THEN
1570: IF l_debug_mode='Y' THEN
1571: pa_debug.g_err_stage:= 'WEBADI: Revenue not allowed';
1572: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);

Line 1578: p_return_status := FND_API.G_RET_STS_ERROR;

1574: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1575: END IF;
1576:
1577: x_webadi_error_code := 'PA_FP_WA_REVENUE_NOT_ALWD';
1578: p_return_status := FND_API.G_RET_STS_ERROR;
1579: RETURN;
1580: END IF; -- Bug 3986129: FP.M Web ADI Dev changes
1581: END IF;
1582:

Line 1597: p_return_status := FND_API.G_RET_STS_ERROR;

1593:
1594: PA_UTILS.ADD_MESSAGE
1595: (p_app_short_name => 'PA',
1596: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1597: p_return_status := FND_API.G_RET_STS_ERROR;
1598: RETURN;
1599:
1600:
1601: END IF;--IF ( p_budget_amount_code = 'C'

Line 1617: p_return_status := FND_API.G_RET_STS_ERROR;

1613: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1614: END IF;
1615:
1616: x_webadi_error_code := 'PA_FP_WA_RCR_CNG_NOT_ALWD';
1617: p_return_status := FND_API.G_RET_STS_ERROR;
1618: RETURN;
1619: END IF;
1620: END IF;
1621: IF l_burd_cost_rate_flag = 'N' THEN

Line 1632: p_return_status := FND_API.G_RET_STS_ERROR;

1628: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1629: END IF;
1630:
1631: x_webadi_error_code := 'PA_FP_WA_BCR_CNG_NOT_ALWD';
1632: p_return_status := FND_API.G_RET_STS_ERROR;
1633: RETURN;
1634: END IF;
1635: END IF;
1636: -- bill rate should not be allowed to be edited

Line 1647: p_return_status := FND_API.G_RET_STS_ERROR;

1643: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1644: END IF;
1645:
1646: x_webadi_error_code := 'PA_FP_WA_BR_CNG_NOT_ALWD';
1647: p_return_status := FND_API.G_RET_STS_ERROR;
1648: RETURN;
1649: END IF;
1650:
1651:

Line 1664: p_return_status := FND_API.G_RET_STS_ERROR;

1660: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1661: END IF;
1662:
1663: x_webadi_error_code := 'PA_FP_WA_BR_CNG_NOT_ALWD';
1664: p_return_status := FND_API.G_RET_STS_ERROR;
1665: RETURN;
1666: END IF;
1667: END IF;
1668: -- cost rate should not be allowed to be edited

Line 1679: p_return_status := FND_API.G_RET_STS_ERROR;

1675: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1676: END IF;
1677:
1678: x_webadi_error_code := 'PA_FP_WA_RCR_CNG_NOT_ALWD';
1679: p_return_status := FND_API.G_RET_STS_ERROR;
1680: RETURN;
1681: END IF;
1682: IF p_burdened_cost_rate <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
1683: p_burdened_cost_rate IS NOT NULL THEN

Line 1692: p_return_status := FND_API.G_RET_STS_ERROR;

1688: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1689: END IF;
1690:
1691: x_webadi_error_code := 'PA_FP_WA_BCR_CNG_NOT_ALWD';
1692: p_return_status := FND_API.G_RET_STS_ERROR;
1693: RETURN;
1694: END IF;
1695: ELSIF p_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL THEN
1696: IF l_raw_cost_rate_flag = 'N' THEN

Line 1707: p_return_status := FND_API.G_RET_STS_ERROR;

1703: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1704: END IF;
1705:
1706: x_webadi_error_code := 'PA_FP_WA_RCR_CNG_NOT_ALWD';
1707: p_return_status := FND_API.G_RET_STS_ERROR;
1708: RETURN;
1709: END IF;
1710: END IF;
1711: IF l_burd_cost_rate_flag = 'N' THEN

Line 1722: p_return_status := FND_API.G_RET_STS_ERROR;

1718: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1719: END IF;
1720:
1721: x_webadi_error_code := 'PA_FP_WA_BCR_CNG_NOT_ALWD';
1722: p_return_status := FND_API.G_RET_STS_ERROR;
1723: RETURN;
1724: END IF;
1725: END IF;
1726: IF l_bill_rate_flag = 'N' THEN

Line 1737: p_return_status := FND_API.G_RET_STS_ERROR;

1733: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
1734: END IF;
1735:
1736: x_webadi_error_code := 'PA_FP_WA_BR_CNG_NOT_ALWD';
1737: p_return_status := FND_API.G_RET_STS_ERROR;
1738: RETURN;
1739: END IF;
1740: END IF;
1741: END IF;

Line 1750: WHEN FND_API.G_EXC_ERROR

1746: END IF;
1747: EXCEPTION
1748:
1749:
1750: WHEN FND_API.G_EXC_ERROR
1751: THEN
1752:
1753: ROLLBACK TO check_entry_method_flags_pvt;
1754:

Line 1755: p_return_status := FND_API.G_RET_STS_ERROR;

1751: THEN
1752:
1753: ROLLBACK TO check_entry_method_flags_pvt;
1754:
1755: p_return_status := FND_API.G_RET_STS_ERROR;
1756: IF l_debug_mode = 'Y' THEN
1757: pa_debug.reset_curr_function;
1758: END IF;
1759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1755: p_return_status := FND_API.G_RET_STS_ERROR;
1756: IF l_debug_mode = 'Y' THEN
1757: pa_debug.reset_curr_function;
1758: END IF;
1759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1760: THEN
1761:
1762: ROLLBACK TO check_entry_method_flags_pvt;
1763:

Line 1764: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1760: THEN
1761:
1762: ROLLBACK TO check_entry_method_flags_pvt;
1763:
1764: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1765: IF l_debug_mode = 'Y' THEN
1766: pa_debug.reset_curr_function;
1767: END IF;
1768: WHEN OTHERS THEN

Line 1772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1768: WHEN OTHERS THEN
1769:
1770: ROLLBACK TO check_entry_method_flags_pvt;
1771:
1772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1773:
1774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1775: THEN
1776: FND_MSG_PUB.add_exc_msg

Line 1819: x_return_status := FND_API.G_RET_STS_SUCCESS;

1815:
1816: BEGIN
1817: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1818: x_msg_count := 0;
1819: x_return_status := FND_API.G_RET_STS_SUCCESS;
1820:
1821: IF l_debug_mode = 'Y' THEN
1822: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1823: p_debug_mode => l_debug_mode );

Line 1891: (p_encoded => FND_API.G_TRUE

1887: l_msg_count := FND_MSG_PUB.count_msg;
1888:
1889: IF l_msg_count = 1 and x_msg_data IS NULL THEN
1890: PA_INTERFACE_UTILS_PUB.get_messages
1891: (p_encoded => FND_API.G_TRUE
1892: ,p_msg_index => 1
1893: ,p_msg_count => l_msg_count
1894: ,p_msg_data => l_msg_data
1895: ,p_data => l_data

Line 1902: x_return_status := FND_API.G_RET_STS_ERROR;

1898: x_msg_count := l_msg_count;
1899: ELSE
1900: x_msg_count := l_msg_count;
1901: END IF;
1902: x_return_status := FND_API.G_RET_STS_ERROR;
1903:
1904: IF l_debug_mode = 'Y' THEN
1905: pa_debug.reset_curr_function;
1906: END IF;

Line 1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1906: END IF;
1907: RETURN;
1908:
1909: WHEN OTHERS THEN
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1911: x_msg_count := 1;
1912: x_msg_data := SQLERRM;
1913:
1914: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_CHECK_PVT'