214: x_return_status := 'E' ;
215: END IF;
216: END;
217: end if;
218: l_msg_count := FND_MSG_PUB.count_msg;
219:
220: IF l_msg_count > 0 THEN
221: x_msg_count := l_msg_count;
222: x_return_status := 'E';
416: x_return_status := 'E' ;
417: END IF;
418: END;
419: END IF;
420: l_msg_count := FND_MSG_PUB.count_msg;
421:
422: IF l_msg_count > 0 THEN
423: x_msg_count := l_msg_count;
424: x_return_status := 'E';
457: THEN
458: ROLLBACK TO Update_Bill_Info;
459: END IF;
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
461: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
462: p_procedure_name => 'Update_Project_Task_Bill_Info',
463: p_error_text => SUBSTRB(SQLERRM,1,240));
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465:
475: THEN
476: ROLLBACK TO Update_Bill_Info;
477: END IF;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
480: p_procedure_name => 'Update_Project_Task_Bill_Info',
481: p_error_text => SUBSTRB(SQLERRM,1,240));
482: RAISE;
483: END Update_Project_Task_Bill_Info;
684: END;
685: END IF;
686: END IF;
687:
688: l_msg_count := FND_MSG_PUB.count_msg;
689:
690: IF l_msg_count > 0 THEN
691: x_msg_count := l_msg_count;
692: x_return_status := 'E';
813: THEN
814: ROLLBACK TO bill_sch_type;
815: END IF;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
818: p_procedure_name => 'update_billing_schedule_type',
819: p_error_text => SUBSTRB(SQLERRM,1,240));
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821:
831: THEN
832: ROLLBACK TO bill_sch_type;
833: END IF;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
836: p_procedure_name => 'update_billing_schedule_type',
837: p_error_text => SUBSTRB(SQLERRM,1,240));
838: RAISE;
839:
920: IF p_labor_multiplier < 0
921: THEN
922: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
923: p_msg_name => 'PA_PRJ_LB_MULT_GR_ZR' );
924: x_msg_count := FND_MSG_PUB.count_msg;
925: x_msg_data := 'PA_PRJ_LB_MULT_GR_ZR';
926: x_return_status := 'E';
927: RAISE FND_API.G_EXC_ERROR;
928: END IF;
1015: THEN
1016: ROLLBACK TO Labor_Multiplier;
1017: END IF;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1020: p_procedure_name => 'create_labor_multiplier',
1021: p_error_text => SUBSTRB(SQLERRM,1,240));
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023:
1035: THEN
1036: ROLLBACK TO Labor_Multiplier;
1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1040: p_procedure_name => 'create_labor_multiplier',
1041: p_error_text => SUBSTRB(SQLERRM,1,240));
1042: RAISE;
1043:
1125: IF p_labor_multiplier < 0
1126: THEN
1127: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1128: p_msg_name => 'PA_PRJ_LB_MULT_GR_ZR' );
1129: x_msg_count := FND_MSG_PUB.count_msg;
1130: x_msg_data := 'PA_PRJ_LB_MULT_GR_ZR';
1131: x_return_status := 'E';
1132: RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1232: x_return_status := 'E' ;
1233: END IF;
1234: END;
1235: end if;
1236: l_msg_count := FND_MSG_PUB.count_msg;
1237:
1238: IF l_msg_count > 0 THEN
1239: x_msg_count := l_msg_count;
1240: x_return_status := 'E';
1274: THEN
1275: ROLLBACK TO Labor_Multiplier;
1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1279: p_procedure_name => 'update_labor_multiplier',
1280: p_error_text => SUBSTRB(SQLERRM,1,240));
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282:
1292: THEN
1293: ROLLBACK TO Labor_Multiplier;
1294: END IF;
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1297: p_procedure_name => 'update_labor_multiplier',
1298: p_error_text => SUBSTRB(SQLERRM,1,240));
1299: RAISE;
1300:
1438: x_return_status := 'E' ;
1439: END IF;
1440: END;
1441: end if;
1442: l_msg_count := FND_MSG_PUB.count_msg;
1443:
1444: IF l_msg_count > 0 THEN
1445: x_msg_count := l_msg_count;
1446: x_return_status := 'E';
1456: THEN
1457: ROLLBACK TO Labor_Multiplier;
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1461: p_procedure_name => 'delete_labor_multiplier',
1462: p_error_text => SUBSTRB(SQLERRM,1,240));
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464:
1474: THEN
1475: ROLLBACK TO Labor_Multiplier;
1476: END IF;
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SCHEDULE_PVT',
1479: p_procedure_name => 'delete_labor_multiplier',
1480: p_error_text => SUBSTRB(SQLERRM,1,240));
1481: RAISE;
1482: