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_TASK_ASSIGNMENT_UTILS dependencies on FND_API

Line 426: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

422: l_resource_rec_tbl l_resource_rec_tbl_type;
423: l_task_rec task_rec_type;
424: l_msg_data VARCHAR2(4000);
425: l_msg_count NUMBER;
426: l_x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
427: l_new_task_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
428: l_new_task_sch_finish SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
429: l_use_task_new_sch_start SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
430: l_use_task_new_sch_end SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 709: WHEN FND_API.G_EXC_ERROR THEN

705: END IF; -- IF p_context = 'UPDATE' OR p_context = 'COPY' THEN
706:
707: EXCEPTION
708:
709: WHEN FND_API.G_EXC_ERROR THEN
710:
711: -- 4537865
712: x_res_assignment_id_tbl := NULL ;
713: x_planning_start_tbl := NULL ;

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713: x_planning_start_tbl := NULL ;
714: x_planning_end_tbl := NULL ;
715: -- 4537865
716:
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
719: PA_DEBUG.write_log (x_module => L_Module,
720: x_msg => 'Error:' || L_FuncProc || SQLERRM,
721: x_log_level => 5);

Line 724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

720: x_msg => 'Error:' || L_FuncProc || SQLERRM,
721: x_log_level => 5);
722: END IF;
723:
724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
725:
726: -- 4537865
727: x_res_assignment_id_tbl := NULL ;
728: x_planning_start_tbl := NULL ;

Line 734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

730: -- 4537865
731: -- Bug 4153366 - clear the temp table
732: DELETE pa_copy_asgmts_temp;
733:
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
736: PA_DEBUG.write_log (x_module => L_Module,
737: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,
738: x_log_level => 6);

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

747: -- 4537865
748: -- Bug 4153366 - clear the temp table
749: DELETE pa_copy_asgmts_temp;
750:
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
753: PA_DEBUG.write_log (x_module => L_Module,
754: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,
755: x_log_level => 6);

Line 835: x_return_status := FND_API.G_RET_STS_SUCCESS;

831:
832: BEGIN
833:
834: L_FuncProc := 'Validate_Create_Assignment';
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836: g_require_progress_rollup := 'N'; -- End of Bug 4492493
837:
838: --Loop through each task record in p_task_rec_tbl
839: --Get default Planning Dates:

Line 885: p_task_rec_tbl(k).start_date <> FND_API.G_MISS_DATE AND

881: FETCH C1_Task_Info INTO l_task_sch_start, l_task_sch_end, l_task_name, l_task_number, l_task_proj_element_id;
882: CLOSE C1_Task_Info;
883:
884: IF (p_task_rec_tbl(k).start_date is not null AND
885: p_task_rec_tbl(k).start_date <> FND_API.G_MISS_DATE AND
886: p_task_rec_tbl(k).end_date is not null AND
887: p_task_rec_tbl(k).end_date <> FND_API.G_MISS_DATE) THEN
888:
889: l_task_sch_start := p_task_rec_tbl(k).start_date;

Line 887: p_task_rec_tbl(k).end_date <> FND_API.G_MISS_DATE) THEN

883:
884: IF (p_task_rec_tbl(k).start_date is not null AND
885: p_task_rec_tbl(k).start_date <> FND_API.G_MISS_DATE AND
886: p_task_rec_tbl(k).end_date is not null AND
887: p_task_rec_tbl(k).end_date <> FND_API.G_MISS_DATE) THEN
888:
889: l_task_sch_start := p_task_rec_tbl(k).start_date;
890: l_task_sch_end := p_task_rec_tbl(k).end_date;
891:

Line 902: IF p_task_assignment_tbl.COUNT > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN

898: l_task_equip_effort := 0;
899: l_people_index := 1;
900: l_equip_index := 1;
901:
902: IF p_task_assignment_tbl.COUNT > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN
903:
904: IF p_one_to_one_mapping_flag <> 'Y' THEN
905:
906: FOR i in 1..p_task_assignment_tbl.COUNT LOOP

Line 912: p_task_assignment_tbl(i).total_quantity <> FND_API.G_MISS_NUM THEN

908: --0. Bug 4492493: Check if Progress Rollup is required on CREATION
909: IF g_require_progress_rollup = 'N' AND
910: l_progress_rollup_required = 'Y' AND
911: p_task_assignment_tbl(i).total_quantity IS NOT NULL AND
912: p_task_assignment_tbl(i).total_quantity <> FND_API.G_MISS_NUM THEN
913: g_require_progress_rollup := 'Y';
914: END IF;
915: -- End of Bug 4492493
916:

Line 937: p_task_assignment_tbl(i).schedule_start_date <> FND_API.G_MISS_DATE THEN

933: -- Should honor Scheduled Dates provided by user before
934: -- defaulting to task scheduled dates
935: -- Should also honor Planning Dates
936: IF p_task_assignment_tbl(i).schedule_start_date IS NOT NULL AND
937: p_task_assignment_tbl(i).schedule_start_date <> FND_API.G_MISS_DATE THEN
938:
939: p_task_assignment_tbl(i).planning_start_date := p_task_assignment_tbl(i).schedule_start_date;
940:
941: ELSIF p_task_assignment_tbl(i).planning_start_date IS NOT NULL AND

Line 942: p_task_assignment_tbl(i).planning_start_date <> FND_API.G_MISS_DATE THEN

938:
939: p_task_assignment_tbl(i).planning_start_date := p_task_assignment_tbl(i).schedule_start_date;
940:
941: ELSIF p_task_assignment_tbl(i).planning_start_date IS NOT NULL AND
942: p_task_assignment_tbl(i).planning_start_date <> FND_API.G_MISS_DATE THEN
943:
944: p_task_assignment_tbl(i).schedule_start_date := p_task_assignment_tbl(i).planning_start_date;
945:
946: ELSE

Line 954: p_task_assignment_tbl(i).schedule_end_date <> FND_API.G_MISS_DATE THEN

950:
951: END IF;
952:
953: IF p_task_assignment_tbl(i).schedule_end_date IS NOT NULL AND
954: p_task_assignment_tbl(i).schedule_end_date <> FND_API.G_MISS_DATE THEN
955:
956: p_task_assignment_tbl(i).planning_end_date := p_task_assignment_tbl(i).schedule_end_date;
957:
958: ELSIF p_task_assignment_tbl(i).planning_end_date IS NOT NULL AND

Line 959: p_task_assignment_tbl(i).planning_end_date <> FND_API.G_MISS_DATE THEN

955:
956: p_task_assignment_tbl(i).planning_end_date := p_task_assignment_tbl(i).schedule_end_date;
957:
958: ELSIF p_task_assignment_tbl(i).planning_end_date IS NOT NULL AND
959: p_task_assignment_tbl(i).planning_end_date <> FND_API.G_MISS_DATE THEN
960:
961: p_task_assignment_tbl(i).schedule_end_date := p_task_assignment_tbl(i).planning_end_date;
962:
963: ELSE

Line 985: x_return_status := FND_API.G_RET_STS_ERROR;

981: p_token2 => 'TASK_NUMBER',
982: p_value2 => l_task_number,
983: p_token3 => 'PL_RES_ALIAS',
984: p_value3 => p_task_assignment_tbl(i).planning_resource_alias);
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: END IF;
987: -- End of fix: Bug 3793623
988:
989: -- scheduled_delay must be positive or null

Line 997: x_return_status := FND_API.G_RET_STS_ERROR;

993: (
994: p_app_short_name => 'PA',
995: p_msg_name => 'PA_SCHED_DELAY_ERR'
996: );
997: x_return_status := FND_API.G_RET_STS_ERROR;
998: END IF;
999:
1000: -- Bug 3818133: Copy the assignment name in the named_role cell
1001: IF (p_task_assignment_tbl(i).project_assignment_id IS NOT NULL) AND

Line 1002: (p_task_assignment_tbl(i).project_assignment_id <> FND_API.G_MISS_NUM) AND

998: END IF;
999:
1000: -- Bug 3818133: Copy the assignment name in the named_role cell
1001: IF (p_task_assignment_tbl(i).project_assignment_id IS NOT NULL) AND
1002: (p_task_assignment_tbl(i).project_assignment_id <> FND_API.G_MISS_NUM) AND
1003: (p_task_assignment_tbl(i).project_assignment_id <> -1) THEN
1004:
1005: OPEN C_Named_Role(p_task_assignment_tbl(i).project_assignment_id);
1006: FETCH C_Named_Role INTO p_task_assignment_tbl(i).named_role, p_task_assignment_tbl(i).project_role_id;

Line 1051: p_task_assignment_tbl(k).schedule_start_date <> FND_API.G_MISS_DATE THEN

1047: -- Should honor Scheduled Dates provided by user before
1048: -- defaulting to task scheduled dates
1049: -- Should also honor Planning Dates
1050: IF p_task_assignment_tbl(k).schedule_start_date IS NOT NULL AND
1051: p_task_assignment_tbl(k).schedule_start_date <> FND_API.G_MISS_DATE THEN
1052:
1053: p_task_assignment_tbl(k).planning_start_date := p_task_assignment_tbl(k).schedule_start_date;
1054:
1055: ELSIF p_task_assignment_tbl(k).planning_start_date IS NOT NULL AND

Line 1056: p_task_assignment_tbl(k).planning_start_date <> FND_API.G_MISS_DATE THEN

1052:
1053: p_task_assignment_tbl(k).planning_start_date := p_task_assignment_tbl(k).schedule_start_date;
1054:
1055: ELSIF p_task_assignment_tbl(k).planning_start_date IS NOT NULL AND
1056: p_task_assignment_tbl(k).planning_start_date <> FND_API.G_MISS_DATE THEN
1057:
1058: p_task_assignment_tbl(k).schedule_start_date := p_task_assignment_tbl(k).planning_start_date;
1059:
1060: ELSE

Line 1068: p_task_assignment_tbl(k).schedule_end_date <> FND_API.G_MISS_DATE THEN

1064:
1065: END IF;
1066:
1067: IF p_task_assignment_tbl(k).schedule_end_date IS NOT NULL AND
1068: p_task_assignment_tbl(k).schedule_end_date <> FND_API.G_MISS_DATE THEN
1069:
1070: p_task_assignment_tbl(k).planning_end_date := p_task_assignment_tbl(k).schedule_end_date;
1071:
1072: ELSIF p_task_assignment_tbl(k).planning_end_date IS NOT NULL AND

Line 1073: p_task_assignment_tbl(k).planning_end_date <> FND_API.G_MISS_DATE THEN

1069:
1070: p_task_assignment_tbl(k).planning_end_date := p_task_assignment_tbl(k).schedule_end_date;
1071:
1072: ELSIF p_task_assignment_tbl(k).planning_end_date IS NOT NULL AND
1073: p_task_assignment_tbl(k).planning_end_date <> FND_API.G_MISS_DATE THEN
1074:
1075: p_task_assignment_tbl(k).schedule_end_date := p_task_assignment_tbl(k).planning_end_date;
1076:
1077: ELSE

Line 1099: x_return_status := FND_API.G_RET_STS_ERROR;

1095: p_token2 => 'TASK_NUMBER',
1096: p_value2 => l_task_number,
1097: p_token3 => 'PL_RES_ALIAS',
1098: p_value3 => p_task_assignment_tbl(k).planning_resource_alias);
1099: x_return_status := FND_API.G_RET_STS_ERROR;
1100: END IF;
1101: -- End of fix: Bug 3793623
1102:
1103: IF nvl(p_task_assignment_tbl(k).scheduled_delay, 0) < 0 THEN

Line 1109: x_return_status := FND_API.G_RET_STS_ERROR;

1105: PA_UTILS.ADD_MESSAGE
1106: ( p_app_short_name => 'PA',
1107: p_msg_name => 'PA_SCHED_DELAY_ERR'
1108: );
1109: x_return_status := FND_API.G_RET_STS_ERROR;
1110:
1111: END IF;
1112:
1113: -- Bug 3818133: Copy the assignment name in the named_role cell

Line 1115: (p_task_assignment_tbl(k).project_assignment_id <> FND_API.G_MISS_NUM) AND

1111: END IF;
1112:
1113: -- Bug 3818133: Copy the assignment name in the named_role cell
1114: IF (p_task_assignment_tbl(k).project_assignment_id IS NOT NULL) AND
1115: (p_task_assignment_tbl(k).project_assignment_id <> FND_API.G_MISS_NUM) AND
1116: (p_task_assignment_tbl(k).project_assignment_id <> -1) THEN
1117:
1118: OPEN C_Named_Role(p_task_assignment_tbl(k).project_assignment_id);
1119: FETCH C_Named_Role INTO p_task_assignment_tbl(k).named_role, p_task_assignment_tbl(k).project_role_id;

Line 1148: END IF; -- p_task_assignment_tbl.COUNT > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS

1144: END IF;
1145:
1146: END IF; -- p_one_to_one_mapping_flag = 'N'
1147:
1148: END IF; -- p_task_assignment_tbl.COUNT > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS
1149:
1150:
1151: ELSE -- check task edit ok
1152:

Line 1157: x_return_status := FND_API.G_RET_STS_ERROR;

1153: -- Bug 4533152
1154: --PA_UTILS.ADD_MESSAGE
1155: -- (p_app_short_name => 'PA',
1156: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR');
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158:
1159: END IF;
1160:
1161: -- Bug 3640647

Line 1191: -- p_task_assignment_tbl(1).unplanned_flag = FND_API.G_MISS_CHAR OR

1187: -- upon creation of unplanned assignment. Due to bug 4354041.
1188:
1189: IF l_task_rec_project_id_tbl.COUNT > 0 THEN
1190: -- (p_task_assignment_tbl(1).unplanned_flag IS NULL OR
1191: -- p_task_assignment_tbl(1).unplanned_flag = FND_API.G_MISS_CHAR OR
1192: -- p_task_assignment_tbl(1).unplanned_flag <> 'Y') THEN
1193:
1194: FORALL k IN l_task_rec_project_id_tbl.FIRST .. l_task_rec_project_id_tbl.LAST
1195: UPDATE pa_resource_assignments

Line 1225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1221: x_return_status => l_return_status,
1222: x_msg_count => l_msg_count,
1223: x_msg_data => l_msg_data
1224: );
1225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1226: x_return_status := l_return_status;
1227: END IF;
1228:
1229: END LOOP;

Line 1246: WHEN FND_API.G_EXC_ERROR THEN

1242: END IF;
1243:
1244: EXCEPTION
1245:
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
1249: PA_DEBUG.write_log (x_module => L_Module,
1250: x_msg => 'Error:' || L_FuncProc || SQLERRM,

Line 1247: x_return_status := FND_API.G_RET_STS_ERROR;

1243:
1244: EXCEPTION
1245:
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
1249: PA_DEBUG.write_log (x_module => L_Module,
1250: x_msg => 'Error:' || L_FuncProc || SQLERRM,
1251: x_log_level => 5);

Line 1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1250: x_msg => 'Error:' || L_FuncProc || SQLERRM,
1251: x_log_level => 5);
1252: END IF;
1253:
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1256: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
1257: PA_DEBUG.write_log (x_module => L_Module,
1258: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,

Line 1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1251: x_log_level => 5);
1252: END IF;
1253:
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1256: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
1257: PA_DEBUG.write_log (x_module => L_Module,
1258: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,
1259: x_log_level => 6);

Line 1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1260: END IF;
1261: RAISE;
1262:
1263: WHEN OTHERS THEN
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1265: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
1266: PA_DEBUG.write_log (x_module => L_Module,
1267: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,
1268: x_log_level => 6);

Line 1442: x_return_status := FND_API.G_RET_STS_SUCCESS;

1438:
1439: BEGIN
1440:
1441: L_FuncProc := 'Validate_Update_Assignment';
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;
1443: g_require_progress_rollup := 'N'; -- End of Bug 4492493
1444:
1445: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1446: pa_debug.g_err_stage:='Beginning of TA:Validate_Update_Assignment';

Line 1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1560: EXCEPTION
1561: WHEN NO_DATA_FOUND THEN
1562: NULL;
1563: WHEN OTHERS THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: END;
1566:
1567: -- Bug 6856934
1568: if nvl(p_calling_context,'X') = 'PA_PROJECT_ASSIGNMENT' then

Line 1617: (p_task_assignment_tbl(i).resource_list_member_id <> FND_API.G_MISS_NUM OR

1613: IF (p_task_assignment_tbl(i).resource_list_member_id IS NOT NULL OR
1614: p_task_assignment_tbl(i).planning_resource_alias IS NOT NULL) AND
1615: (p_task_assignment_tbl(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
1616: p_task_assignment_tbl(i).planning_resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
1617: (p_task_assignment_tbl(i).resource_list_member_id <> FND_API.G_MISS_NUM OR
1618: p_task_assignment_tbl(i).planning_resource_alias <> FND_API.G_MISS_CHAR) AND
1619: nvl(p_task_assignment_tbl(i).resource_list_member_id, -99) <> nvl(R_Res_Assignment_Rec.resource_list_member_id, -99) THEN
1620:
1621: -- Added by clevesqu on 2004/09/03 for bug 3861936

Line 1618: p_task_assignment_tbl(i).planning_resource_alias <> FND_API.G_MISS_CHAR) AND

1614: p_task_assignment_tbl(i).planning_resource_alias IS NOT NULL) AND
1615: (p_task_assignment_tbl(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
1616: p_task_assignment_tbl(i).planning_resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
1617: (p_task_assignment_tbl(i).resource_list_member_id <> FND_API.G_MISS_NUM OR
1618: p_task_assignment_tbl(i).planning_resource_alias <> FND_API.G_MISS_CHAR) AND
1619: nvl(p_task_assignment_tbl(i).resource_list_member_id, -99) <> nvl(R_Res_Assignment_Rec.resource_list_member_id, -99) THEN
1620:
1621: -- Added by clevesqu on 2004/09/03 for bug 3861936
1622: PA_PLANNING_RESOURCE_UTILS.check_list_member_on_list(

Line 1633: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1629: x_valid_member_flag => l_valid_member_flag,
1630: x_return_status => x_return_status,
1631: x_msg_count => x_msg_count,
1632: x_msg_data => x_msg_data);
1633: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1634:
1635: p_task_assignment_tbl(i).resource_list_member_id := l_new_resource_list_member_id ; -- 4537865
1636: END IF ;
1637:

Line 1638: IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1634:
1635: p_task_assignment_tbl(i).resource_list_member_id := l_new_resource_list_member_id ; -- 4537865
1636: END IF ;
1637:
1638: IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1640: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
1641: RAISE FND_API.G_EXC_ERROR;
1642: END IF;

Line 1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1635: p_task_assignment_tbl(i).resource_list_member_id := l_new_resource_list_member_id ; -- 4537865
1636: END IF ;
1637:
1638: IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1640: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
1641: RAISE FND_API.G_EXC_ERROR;
1642: END IF;
1643: -- End added by clevesqu on 2004/09/03 for bug 3861936

Line 1640: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

1636: END IF ;
1637:
1638: IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1640: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
1641: RAISE FND_API.G_EXC_ERROR;
1642: END IF;
1643: -- End added by clevesqu on 2004/09/03 for bug 3861936
1644:

Line 1641: RAISE FND_API.G_EXC_ERROR;

1637:
1638: IF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1640: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
1641: RAISE FND_API.G_EXC_ERROR;
1642: END IF;
1643: -- End added by clevesqu on 2004/09/03 for bug 3861936
1644:
1645: Lr_eligible_rlm_id_tbl.extend(1);

Line 1762: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1758:
1759: -- DHI Fix: override currency
1760: R_Res_Assignment_Rec.rate_based_flag := lr_rate_based_flag_tbl(1);
1761:
1762: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1764: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1765: RAISE FND_API.G_EXC_ERROR;
1766: END IF;

Line 1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1759: -- DHI Fix: override currency
1760: R_Res_Assignment_Rec.rate_based_flag := lr_rate_based_flag_tbl(1);
1761:
1762: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1764: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1765: RAISE FND_API.G_EXC_ERROR;
1766: END IF;
1767:

Line 1764: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1760: R_Res_Assignment_Rec.rate_based_flag := lr_rate_based_flag_tbl(1);
1761:
1762: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1764: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1765: RAISE FND_API.G_EXC_ERROR;
1766: END IF;
1767:
1768: P_task_assignment_tbl(i).resource_class_flag := gchar(lr_resource_class_flag_tbl(1), 'B');

Line 1765: RAISE FND_API.G_EXC_ERROR;

1761:
1762: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1764: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1765: RAISE FND_API.G_EXC_ERROR;
1766: END IF;
1767:
1768: P_task_assignment_tbl(i).resource_class_flag := gchar(lr_resource_class_flag_tbl(1), 'B');
1769: P_task_assignment_tbl(i).resource_class_code := gchar(lr_resource_class_code_tbl(1), 'B');

Line 1805: p_task_assignment_tbl(i).incur_by_resource_code <> FND_API.G_MISS_CHAR)

1801: ELSIF p_task_assignment_tbl(i).resource_list_member_id is not Null Then
1802:
1803: --1. Resource Information
1804: IF (p_task_assignment_tbl(i).incur_by_resource_code IS NOT NULL AND
1805: p_task_assignment_tbl(i).incur_by_resource_code <> FND_API.G_MISS_CHAR)
1806: OR
1807: (p_task_assignment_tbl(i).incur_by_resource_name IS NOT NULL AND
1808: p_task_assignment_tbl(i).incur_by_resource_name <> FND_API.G_MISS_CHAR) THEN
1809:

Line 1808: p_task_assignment_tbl(i).incur_by_resource_name <> FND_API.G_MISS_CHAR) THEN

1804: IF (p_task_assignment_tbl(i).incur_by_resource_code IS NOT NULL AND
1805: p_task_assignment_tbl(i).incur_by_resource_code <> FND_API.G_MISS_CHAR)
1806: OR
1807: (p_task_assignment_tbl(i).incur_by_resource_name IS NOT NULL AND
1808: p_task_assignment_tbl(i).incur_by_resource_name <> FND_API.G_MISS_CHAR) THEN
1809:
1810: L_Incur_By_Resource_Type := gchar(p_task_assignment_tbl(i).res_type_code);
1811:
1812: END IF;

Line 1876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1872: pa_debug.g_err_stage:='After validate_planning_resource, return status='||x_return_status;
1873: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1874: END IF;
1875:
1876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1877: RAISE FND_API.G_EXC_ERROR;
1878: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1880: END IF;

Line 1877: RAISE FND_API.G_EXC_ERROR;

1873: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1874: END IF;
1875:
1876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1877: RAISE FND_API.G_EXC_ERROR;
1878: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1880: END IF;
1881:

Line 1878: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1874: END IF;
1875:
1876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1877: RAISE FND_API.G_EXC_ERROR;
1878: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1880: END IF;
1881:
1882: P_task_assignment_tbl(i).expenditure_type := NULL; --nvl(P_task_assignment_tbl(i).expenditure_type, FND_API.G_MISS_CHAR);

Line 1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1875:
1876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1877: RAISE FND_API.G_EXC_ERROR;
1878: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1880: END IF;
1881:
1882: P_task_assignment_tbl(i).expenditure_type := NULL; --nvl(P_task_assignment_tbl(i).expenditure_type, FND_API.G_MISS_CHAR);
1883: P_task_assignment_tbl(i).expenditure_category := NULL; --nvl(P_task_assignment_tbl(i).expenditure_category,FND_API.G_MISS_CHAR);

Line 1882: P_task_assignment_tbl(i).expenditure_type := NULL; --nvl(P_task_assignment_tbl(i).expenditure_type, FND_API.G_MISS_CHAR);

1878: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1880: END IF;
1881:
1882: P_task_assignment_tbl(i).expenditure_type := NULL; --nvl(P_task_assignment_tbl(i).expenditure_type, FND_API.G_MISS_CHAR);
1883: P_task_assignment_tbl(i).expenditure_category := NULL; --nvl(P_task_assignment_tbl(i).expenditure_category,FND_API.G_MISS_CHAR);
1884: P_task_assignment_tbl(i).event_type := NULL; --nvl(P_task_assignment_tbl(i).event_type, FND_API.G_MISS_CHAR);
1885: P_task_assignment_tbl(i).revenue_category_code := NULL; --nvl(P_task_assignment_tbl(i).revenue_category_code, FND_API.G_MISS_CHAR);
1886: P_task_assignment_tbl(i).fc_res_type_code := NULL; --nvl(p_task_assignment_tbl(i).fc_res_type_code, FND_API.G_MISS_CHAR);

Line 1883: P_task_assignment_tbl(i).expenditure_category := NULL; --nvl(P_task_assignment_tbl(i).expenditure_category,FND_API.G_MISS_CHAR);

1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1880: END IF;
1881:
1882: P_task_assignment_tbl(i).expenditure_type := NULL; --nvl(P_task_assignment_tbl(i).expenditure_type, FND_API.G_MISS_CHAR);
1883: P_task_assignment_tbl(i).expenditure_category := NULL; --nvl(P_task_assignment_tbl(i).expenditure_category,FND_API.G_MISS_CHAR);
1884: P_task_assignment_tbl(i).event_type := NULL; --nvl(P_task_assignment_tbl(i).event_type, FND_API.G_MISS_CHAR);
1885: P_task_assignment_tbl(i).revenue_category_code := NULL; --nvl(P_task_assignment_tbl(i).revenue_category_code, FND_API.G_MISS_CHAR);
1886: P_task_assignment_tbl(i).fc_res_type_code := NULL; --nvl(p_task_assignment_tbl(i).fc_res_type_code, FND_API.G_MISS_CHAR);
1887: P_task_assignment_tbl(i).incur_by_role_id := NULL; --nvl(P_task_assignment_tbl(i).incur_by_role_id, FND_API.G_MISS_NUM);

Line 1884: P_task_assignment_tbl(i).event_type := NULL; --nvl(P_task_assignment_tbl(i).event_type, FND_API.G_MISS_CHAR);

1880: END IF;
1881:
1882: P_task_assignment_tbl(i).expenditure_type := NULL; --nvl(P_task_assignment_tbl(i).expenditure_type, FND_API.G_MISS_CHAR);
1883: P_task_assignment_tbl(i).expenditure_category := NULL; --nvl(P_task_assignment_tbl(i).expenditure_category,FND_API.G_MISS_CHAR);
1884: P_task_assignment_tbl(i).event_type := NULL; --nvl(P_task_assignment_tbl(i).event_type, FND_API.G_MISS_CHAR);
1885: P_task_assignment_tbl(i).revenue_category_code := NULL; --nvl(P_task_assignment_tbl(i).revenue_category_code, FND_API.G_MISS_CHAR);
1886: P_task_assignment_tbl(i).fc_res_type_code := NULL; --nvl(p_task_assignment_tbl(i).fc_res_type_code, FND_API.G_MISS_CHAR);
1887: P_task_assignment_tbl(i).incur_by_role_id := NULL; --nvl(P_task_assignment_tbl(i).incur_by_role_id, FND_API.G_MISS_NUM);
1888: P_task_assignment_tbl(i).incur_by_res_class_code := NULL; --nvl(P_task_assignment_tbl(i).incur_by_res_class_code, FND_API.G_MISS_CHAR);

Line 1885: P_task_assignment_tbl(i).revenue_category_code := NULL; --nvl(P_task_assignment_tbl(i).revenue_category_code, FND_API.G_MISS_CHAR);

1881:
1882: P_task_assignment_tbl(i).expenditure_type := NULL; --nvl(P_task_assignment_tbl(i).expenditure_type, FND_API.G_MISS_CHAR);
1883: P_task_assignment_tbl(i).expenditure_category := NULL; --nvl(P_task_assignment_tbl(i).expenditure_category,FND_API.G_MISS_CHAR);
1884: P_task_assignment_tbl(i).event_type := NULL; --nvl(P_task_assignment_tbl(i).event_type, FND_API.G_MISS_CHAR);
1885: P_task_assignment_tbl(i).revenue_category_code := NULL; --nvl(P_task_assignment_tbl(i).revenue_category_code, FND_API.G_MISS_CHAR);
1886: P_task_assignment_tbl(i).fc_res_type_code := NULL; --nvl(p_task_assignment_tbl(i).fc_res_type_code, FND_API.G_MISS_CHAR);
1887: P_task_assignment_tbl(i).incur_by_role_id := NULL; --nvl(P_task_assignment_tbl(i).incur_by_role_id, FND_API.G_MISS_NUM);
1888: P_task_assignment_tbl(i).incur_by_res_class_code := NULL; --nvl(P_task_assignment_tbl(i).incur_by_res_class_code, FND_API.G_MISS_CHAR);
1889:

Line 1886: P_task_assignment_tbl(i).fc_res_type_code := NULL; --nvl(p_task_assignment_tbl(i).fc_res_type_code, FND_API.G_MISS_CHAR);

1882: P_task_assignment_tbl(i).expenditure_type := NULL; --nvl(P_task_assignment_tbl(i).expenditure_type, FND_API.G_MISS_CHAR);
1883: P_task_assignment_tbl(i).expenditure_category := NULL; --nvl(P_task_assignment_tbl(i).expenditure_category,FND_API.G_MISS_CHAR);
1884: P_task_assignment_tbl(i).event_type := NULL; --nvl(P_task_assignment_tbl(i).event_type, FND_API.G_MISS_CHAR);
1885: P_task_assignment_tbl(i).revenue_category_code := NULL; --nvl(P_task_assignment_tbl(i).revenue_category_code, FND_API.G_MISS_CHAR);
1886: P_task_assignment_tbl(i).fc_res_type_code := NULL; --nvl(p_task_assignment_tbl(i).fc_res_type_code, FND_API.G_MISS_CHAR);
1887: P_task_assignment_tbl(i).incur_by_role_id := NULL; --nvl(P_task_assignment_tbl(i).incur_by_role_id, FND_API.G_MISS_NUM);
1888: P_task_assignment_tbl(i).incur_by_res_class_code := NULL; --nvl(P_task_assignment_tbl(i).incur_by_res_class_code, FND_API.G_MISS_CHAR);
1889:
1890: -- Setting to null for bug 3664052

Line 1887: P_task_assignment_tbl(i).incur_by_role_id := NULL; --nvl(P_task_assignment_tbl(i).incur_by_role_id, FND_API.G_MISS_NUM);

1883: P_task_assignment_tbl(i).expenditure_category := NULL; --nvl(P_task_assignment_tbl(i).expenditure_category,FND_API.G_MISS_CHAR);
1884: P_task_assignment_tbl(i).event_type := NULL; --nvl(P_task_assignment_tbl(i).event_type, FND_API.G_MISS_CHAR);
1885: P_task_assignment_tbl(i).revenue_category_code := NULL; --nvl(P_task_assignment_tbl(i).revenue_category_code, FND_API.G_MISS_CHAR);
1886: P_task_assignment_tbl(i).fc_res_type_code := NULL; --nvl(p_task_assignment_tbl(i).fc_res_type_code, FND_API.G_MISS_CHAR);
1887: P_task_assignment_tbl(i).incur_by_role_id := NULL; --nvl(P_task_assignment_tbl(i).incur_by_role_id, FND_API.G_MISS_NUM);
1888: P_task_assignment_tbl(i).incur_by_res_class_code := NULL; --nvl(P_task_assignment_tbl(i).incur_by_res_class_code, FND_API.G_MISS_CHAR);
1889:
1890: -- Setting to null for bug 3664052
1891: P_task_assignment_tbl(i).Person_Id := NULL;

Line 1888: P_task_assignment_tbl(i).incur_by_res_class_code := NULL; --nvl(P_task_assignment_tbl(i).incur_by_res_class_code, FND_API.G_MISS_CHAR);

1884: P_task_assignment_tbl(i).event_type := NULL; --nvl(P_task_assignment_tbl(i).event_type, FND_API.G_MISS_CHAR);
1885: P_task_assignment_tbl(i).revenue_category_code := NULL; --nvl(P_task_assignment_tbl(i).revenue_category_code, FND_API.G_MISS_CHAR);
1886: P_task_assignment_tbl(i).fc_res_type_code := NULL; --nvl(p_task_assignment_tbl(i).fc_res_type_code, FND_API.G_MISS_CHAR);
1887: P_task_assignment_tbl(i).incur_by_role_id := NULL; --nvl(P_task_assignment_tbl(i).incur_by_role_id, FND_API.G_MISS_NUM);
1888: P_task_assignment_tbl(i).incur_by_res_class_code := NULL; --nvl(P_task_assignment_tbl(i).incur_by_res_class_code, FND_API.G_MISS_CHAR);
1889:
1890: -- Setting to null for bug 3664052
1891: P_task_assignment_tbl(i).Person_Id := NULL;
1892: P_task_assignment_tbl(i).Bom_Resource_Id := NULL;

Line 1964: x_return_status := FND_API.G_RET_STS_ERROR;

1960: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1961: END IF;
1962:
1963: IF Validate_Fin_Cat_For_WP(p_task_assignment_tbl(i).fc_res_type_code ) <> 'Y' THEN
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: END IF;
1966:
1967: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1968: pa_debug.g_err_stage:='B4 Validate Pl_Res_For_WP: ' || L_FuncProc || ':return_status:' || x_return_status;

Line 1973: x_return_status := FND_API.G_RET_STS_ERROR;

1969: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1970: END IF;
1971:
1972: IF Validate_Pl_Res_For_WP(p_task_assignment_tbl(i).resource_list_member_id) <> 'Y' THEN
1973: x_return_status := FND_API.G_RET_STS_ERROR;
1974: END IF;
1975:
1976: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1977: pa_debug.g_err_stage:='After Validate Pl_Res_For_WP: ' || L_FuncProc || ':return_status:' || x_return_status;

Line 2016: x_return_status := FND_API.G_RET_STS_ERROR;

2012: p_value2 => l_task_number,
2013: p_token3 => 'PL_RES_ALIAS',
2014: p_value3 => p_task_assignment_tbl(i).planning_resource_alias
2015: );
2016: x_return_status := FND_API.G_RET_STS_ERROR;
2017:
2018: -- CASE 1: If use_task_schedule_flag is set, make sure task and ta schedule
2019: -- dates are the same
2020: ELSIF ((p_task_assignment_tbl(i).use_task_schedule_flag = 'Y')

Line 2035: x_return_status := FND_API.G_RET_STS_ERROR;

2031: p_value2 => l_task_number,
2032: p_token3 => 'PL_RES_ALIAS',
2033: p_value3 => p_task_assignment_tbl(i).planning_resource_alias
2034: );
2035: x_return_status := FND_API.G_RET_STS_ERROR;
2036:
2037: -- CASE2: otherwise if use_task_schedule_flag is not set,
2038: -- then assignment dates should be within task dates
2039: ELSIF trunc(p_task_assignment_tbl(i).schedule_start_date) < trunc(l_task_sch_start) OR

Line 2055: x_return_status := FND_API.G_RET_STS_ERROR;

2051: p_value2 => l_task_number,
2052: p_token3 => 'PL_RES_ALIAS',
2053: p_value3 => p_task_assignment_tbl(i).planning_resource_alias
2054: );
2055: x_return_status := FND_API.G_RET_STS_ERROR;
2056:
2057: END IF;
2058:
2059: -- scheduled_delay must be positive or null

Line 2067: x_return_status := FND_API.G_RET_STS_ERROR;

2063: (
2064: p_app_short_name => 'PA',
2065: p_msg_name => 'PA_SCHED_DELAY_ERR'
2066: );
2067: x_return_status := FND_API.G_RET_STS_ERROR;
2068: END IF;
2069:
2070: -- CASE3: IB2 Unplanned Actual changes
2071: -- Set planning dates to schedule dates

Line 2087: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2083: x_return_status => l_return_status,
2084: x_error_msg_code => l_error_msg_code
2085: );
2086:
2087: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2088: x_return_status := l_return_status;
2089: END IF;
2090:
2091: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 2123: l_sp_fixed_date = FND_API.G_MISS_DATE) THEN

2119: -- the flow.
2120: l_sp_fixed_date := p_task_assignment_tbl(i).sp_fixed_date;
2121:
2122: IF (l_sp_fixed_date is NULL OR
2123: l_sp_fixed_date = FND_API.G_MISS_DATE) THEN
2124: l_sp_fixed_date := R_Res_Assignment_Rec.sp_fixed_date;
2125: END IF;
2126:
2127: IF l_sp_fixed_date is not NULL AND

Line 2128: l_sp_fixed_date <> FND_API.G_MISS_DATE AND

2124: l_sp_fixed_date := R_Res_Assignment_Rec.sp_fixed_date;
2125: END IF;
2126:
2127: IF l_sp_fixed_date is not NULL AND
2128: l_sp_fixed_date <> FND_API.G_MISS_DATE AND
2129: (l_sp_fixed_date > p_task_assignment_tbl(i).planning_end_date OR
2130: l_sp_fixed_date < p_task_assignment_tbl(i).planning_start_date) THEN
2131:
2132: p_task_assignment_tbl(i).sp_fixed_date := R_Res_Assignment_Rec.sp_fixed_date +

Line 2152: p_task_assignment_tbl(i).override_currency_code <> FND_API.G_MISS_CHAR AND

2148: -- DHI Fix
2149: -- If no progress and no published version exists, override currency is only allowed
2150: -- if override rate also exists for rate based assignments
2151: IF (R_Res_Assignment_Rec.rate_based_flag = 'Y' AND
2152: p_task_assignment_tbl(i).override_currency_code <> FND_API.G_MISS_CHAR AND
2153: p_task_assignment_tbl(i).override_currency_code IS NOT NULL AND
2154: (p_task_assignment_tbl(i).cost_rate_override = FND_API.G_MISS_NUM OR
2155: p_task_assignment_tbl(i).cost_rate_override IS NULL)) THEN
2156:

Line 2154: (p_task_assignment_tbl(i).cost_rate_override = FND_API.G_MISS_NUM OR

2150: -- if override rate also exists for rate based assignments
2151: IF (R_Res_Assignment_Rec.rate_based_flag = 'Y' AND
2152: p_task_assignment_tbl(i).override_currency_code <> FND_API.G_MISS_CHAR AND
2153: p_task_assignment_tbl(i).override_currency_code IS NOT NULL AND
2154: (p_task_assignment_tbl(i).cost_rate_override = FND_API.G_MISS_NUM OR
2155: p_task_assignment_tbl(i).cost_rate_override IS NULL)) THEN
2156:
2157: l_viol_indicator := 8.7;
2158:

Line 2174: x_return_status := FND_API.G_RET_STS_ERROR;

2170: (
2171: p_app_short_name => 'PA',
2172: p_msg_name => 'PA_UP_TA_OVR_CUR_ERR'
2173: );
2174: x_return_status := FND_API.G_RET_STS_ERROR;
2175: END IF;
2176: END IF;
2177:
2178: --4. Financial Summary Validation handled by generic update planning transaction API

Line 2187: x_return_status := FND_API.G_RET_STS_ERROR;

2183: --(
2184: -- p_app_short_name => 'PA',
2185: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR'
2186: --);
2187: x_return_status := FND_API.G_RET_STS_ERROR;
2188: END IF;
2189:
2190: -- Begin fix for Bug # 4319137.
2191:

Line 2192: if (x_return_status = FND_API.G_RET_STS_ERROR) then

2188: END IF;
2189:
2190: -- Begin fix for Bug # 4319137.
2191:
2192: if (x_return_status = FND_API.G_RET_STS_ERROR) then
2193:
2194: l_msg_added_flag := 'Y';
2195:
2196: end if;

Line 2207: x_return_status := FND_API.G_RET_STS_ERROR;

2203: -- Begin fix for Bug # 4319137.
2204:
2205: if (l_msg_added_flag = 'Y') then
2206:
2207: x_return_status := FND_API.G_RET_STS_ERROR;
2208: end if;
2209:
2210: -- End fix for Bug # 4319137.
2211:

Line 2213: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2209:
2210: -- End fix for Bug # 4319137.
2211:
2212: -- Finally, check the progress business rules.
2213: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2214: PA_PROGRESS_UTILS.check_prog_for_update_asgmts
2215: (
2216: p_task_assignment_tbl => p_task_assignment_tbl,
2217: x_return_status => x_return_status

Line 2228: WHEN FND_API.G_EXC_ERROR THEN

2224: END IF;
2225:
2226: EXCEPTION
2227:
2228: WHEN FND_API.G_EXC_ERROR THEN
2229: x_return_status := FND_API.G_RET_STS_ERROR;
2230: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
2231: PA_DEBUG.write_log (x_module => L_Module,
2232: x_msg => 'Error:' || L_FuncProc || SQLERRM,

Line 2229: x_return_status := FND_API.G_RET_STS_ERROR;

2225:
2226: EXCEPTION
2227:
2228: WHEN FND_API.G_EXC_ERROR THEN
2229: x_return_status := FND_API.G_RET_STS_ERROR;
2230: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
2231: PA_DEBUG.write_log (x_module => L_Module,
2232: x_msg => 'Error:' || L_FuncProc || SQLERRM,
2233: x_log_level => 5);

Line 2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2233: x_log_level => 5);
2234:
2235: END IF;
2236:
2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2239: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
2240: PA_DEBUG.write_log (x_module => L_Module,
2241: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,

Line 2238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2234:
2235: END IF;
2236:
2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2239: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
2240: PA_DEBUG.write_log (x_module => L_Module,
2241: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,
2242: x_log_level => 6);

Line 2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2243: END IF;
2244: RAISE;
2245:
2246: WHEN OTHERS THEN
2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2248: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
2249: PA_DEBUG.write_log (x_module => L_Module,
2250: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,
2251: x_log_level => 6);

Line 2376: x_return_status := FND_API.G_RET_STS_SUCCESS;

2372: l_edit_task_ok varchar2(1) := 'N'; -- Bug 6856934
2373:
2374: BEGIN
2375:
2376: x_return_status := FND_API.G_RET_STS_SUCCESS;
2377: g_require_progress_rollup := 'N'; -- End of Bug 4492493
2378: L_FuncProc := 'Validate_Delete_Assignment';
2379:
2380: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 2458: x_return_status := FND_API.G_RET_STS_ERROR;

2454: p_value2 => l_task_number,
2455: p_token3 => 'PL_RES_ALIAS',
2456: p_value3 => l_alias
2457: );
2458: x_return_status := FND_API.G_RET_STS_ERROR;
2459:
2460: ELSE
2461:
2462: x_delete_task_flag_tbl(i) := 'Y';

Line 2485: p_init_msg_list => FND_API.G_FALSE,

2481: x_task_assmt_ids_tbl(x_task_assmt_ids_tbl.COUNT) := l_task_asgmts_tbl(j);
2482:
2483: pa_deliverable_pub.delete_dlv_task_asscn_in_bulk
2484: (
2485: p_init_msg_list => FND_API.G_FALSE,
2486: p_calling_context => 'PA_ASSIGNMENTS',
2487: p_task_element_id => l_task_asgmts_tbl(j),
2488: p_task_version_id => NULL,
2489: p_project_id => l_project_id,

Line 2496: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2492: x_msg_data => l_msg_data
2493: );
2494:
2495: -- Bug 4317547: Should check the return status
2496: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: END IF;
2499:
2500: END LOOP;

Line 2497: x_return_status := FND_API.G_RET_STS_ERROR;

2493: );
2494:
2495: -- Bug 4317547: Should check the return status
2496: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: END IF;
2499:
2500: END LOOP;
2501:

Line 2601: x_return_status := FND_API.G_RET_STS_ERROR;

2597: (
2598: p_app_short_name => 'PA',
2599: p_msg_name => 'PA_DL_TA_PROG_ERR'
2600: );
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: ELSE
2603: x_delete_asgmt_flag_tbl(i) := 'Y';
2604: pa_deliverable_pub.delete_dlv_task_asscn_in_bulk
2605: (

Line 2606: p_init_msg_list => FND_API.G_FALSE,

2602: ELSE
2603: x_delete_asgmt_flag_tbl(i) := 'Y';
2604: pa_deliverable_pub.delete_dlv_task_asscn_in_bulk
2605: (
2606: p_init_msg_list => FND_API.G_FALSE,
2607: p_calling_context => 'PA_ASSIGNMENTS',
2608: p_task_element_id => p_resource_assignment_id_tbl(i),
2609: p_task_version_id => l_wbs_element_version_id,
2610: p_project_id => l_project_id,

Line 2617: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2613: x_msg_data => l_msg_data
2614: );
2615:
2616: -- Bug 4317547: Should check the return status
2617: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2618: x_return_status := FND_API.G_RET_STS_ERROR;
2619: END IF;
2620:
2621: END IF;

Line 2618: x_return_status := FND_API.G_RET_STS_ERROR;

2614: );
2615:
2616: -- Bug 4317547: Should check the return status
2617: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2618: x_return_status := FND_API.G_RET_STS_ERROR;
2619: END IF;
2620:
2621: END IF;
2622:

Line 2631: x_return_status := FND_API.G_RET_STS_ERROR;

2627: --(
2628: -- p_app_short_name => 'PA',
2629: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR'
2630: --);
2631: x_return_status := FND_API.G_RET_STS_ERROR;
2632:
2633: END IF; -- check task edit ok
2634:
2635: END LOOP;

Line 2648: WHEN FND_API.G_EXC_ERROR THEN

2644: END IF;
2645:
2646: EXCEPTION
2647:
2648: WHEN FND_API.G_EXC_ERROR THEN
2649: x_return_status := FND_API.G_RET_STS_ERROR;
2650: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
2651: PA_DEBUG.write_log (x_module => L_Module,
2652: x_msg => 'Error:' || L_FuncProc || SQLERRM,

Line 2649: x_return_status := FND_API.G_RET_STS_ERROR;

2645:
2646: EXCEPTION
2647:
2648: WHEN FND_API.G_EXC_ERROR THEN
2649: x_return_status := FND_API.G_RET_STS_ERROR;
2650: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
2651: PA_DEBUG.write_log (x_module => L_Module,
2652: x_msg => 'Error:' || L_FuncProc || SQLERRM,
2653: x_log_level => 5);

Line 2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2652: x_msg => 'Error:' || L_FuncProc || SQLERRM,
2653: x_log_level => 5);
2654: END IF;
2655:
2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2658: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
2659: PA_DEBUG.write_log (x_module => L_Module,
2660: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,

Line 2657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2653: x_log_level => 5);
2654: END IF;
2655:
2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2658: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
2659: PA_DEBUG.write_log (x_module => L_Module,
2660: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,
2661: x_log_level => 6);

Line 2666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2662: END IF;
2663: RAISE;
2664:
2665: WHEN OTHERS THEN
2666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2667: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
2668: PA_DEBUG.write_log (x_module => L_Module,
2669: x_msg =>'Unexpected Error:' || L_FuncProc || SQLERRM,
2670: x_log_level => 6);

Line 3266: x_return_status := FND_API.G_RET_STS_SUCCESS;

3262: l_progress_rollup_required VARCHAR2(1) := 'N';
3263:
3264: BEGIN
3265:
3266: x_return_status := FND_API.G_RET_STS_SUCCESS;
3267: g_require_progress_rollup := 'N'; -- End of Bug 4492493
3268: L_FuncProc := 'Validate_Copy_Assignment';
3269: x_calculate_flag := 'N';
3270: x_rbs_diff_flag := 'N';

Line 3337: x_return_status := FND_API.G_RET_STS_ERROR;

3333: PA_UTILS.ADD_MESSAGE
3334: (p_app_short_name => 'PA',
3335: p_msg_name => 'PA_RES_LIST_NONE_ERR'
3336: );
3337: x_return_status := FND_API.G_RET_STS_ERROR;
3338: RAISE FND_API.G_EXC_ERROR;
3339: END IF;
3340:
3341: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 3338: RAISE FND_API.G_EXC_ERROR;

3334: (p_app_short_name => 'PA',
3335: p_msg_name => 'PA_RES_LIST_NONE_ERR'
3336: );
3337: x_return_status := FND_API.G_RET_STS_ERROR;
3338: RAISE FND_API.G_EXC_ERROR;
3339: END IF;
3340:
3341: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
3342: PA_DEBUG.write(x_module => L_Module, x_msg => 'l_src_resource_list_id: ' || l_src_resource_list_id, x_log_level => 3);

Line 3751: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3747: x_return_status => x_return_status,
3748: x_msg_count => l_msg_count,
3749: x_msg_data => l_msg_data);
3750:
3751: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3752: RAISE FND_API.G_EXC_ERROR;
3753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3755: END IF;

Line 3752: RAISE FND_API.G_EXC_ERROR;

3748: x_msg_count => l_msg_count,
3749: x_msg_data => l_msg_data);
3750:
3751: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3752: RAISE FND_API.G_EXC_ERROR;
3753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3755: END IF;
3756:

Line 3753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3749: x_msg_data => l_msg_data);
3750:
3751: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3752: RAISE FND_API.G_EXC_ERROR;
3753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3755: END IF;
3756:
3757: IF l_txn_curr_code = l_projfunc_curr_code THEN

Line 3754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3750:
3751: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3752: RAISE FND_API.G_EXC_ERROR;
3753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3755: END IF;
3756:
3757: IF l_txn_curr_code = l_projfunc_curr_code THEN
3758: l_projfunc_cost_exch_rate := 1;

Line 3826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3822: x_return_status => x_return_status,
3823: x_msg_count => l_msg_count,
3824: x_msg_data => l_msg_data);
3825:
3826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3827: RAISE FND_API.G_EXC_ERROR;
3828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3830: END IF;

Line 3827: RAISE FND_API.G_EXC_ERROR;

3823: x_msg_count => l_msg_count,
3824: x_msg_data => l_msg_data);
3825:
3826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3827: RAISE FND_API.G_EXC_ERROR;
3828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3830: END IF;
3831:

Line 3828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3824: x_msg_data => l_msg_data);
3825:
3826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3827: RAISE FND_API.G_EXC_ERROR;
3828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3830: END IF;
3831:
3832: -- Bug 3951947 Should compare the source and target

Line 3829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3825:
3826: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3827: RAISE FND_API.G_EXC_ERROR;
3828: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3830: END IF;
3831:
3832: -- Bug 3951947 Should compare the source and target
3833: -- projects' project currencies

Line 3912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3908: x_return_status => x_return_status,
3909: x_msg_count => l_msg_count,
3910: x_msg_data => l_msg_data);
3911:
3912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3913: RAISE FND_API.G_EXC_ERROR;
3914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3916: END IF;

Line 3913: RAISE FND_API.G_EXC_ERROR;

3909: x_msg_count => l_msg_count,
3910: x_msg_data => l_msg_data);
3911:
3912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3913: RAISE FND_API.G_EXC_ERROR;
3914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3916: END IF;
3917:

Line 3914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3910: x_msg_data => l_msg_data);
3911:
3912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3913: RAISE FND_API.G_EXC_ERROR;
3914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3916: END IF;
3917:
3918: IF l_txn_curr_code = l_projfunc_curr_code THEN

Line 3915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3911:
3912: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3913: RAISE FND_API.G_EXC_ERROR;
3914: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3916: END IF;
3917:
3918: IF l_txn_curr_code = l_projfunc_curr_code THEN
3919: l_projfunc_cost_exch_rate := 1;

Line 3987: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3983: x_return_status => x_return_status,
3984: x_msg_count => l_msg_count,
3985: x_msg_data => l_msg_data);
3986:
3987: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3988: RAISE FND_API.G_EXC_ERROR;
3989: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3991: END IF;

Line 3988: RAISE FND_API.G_EXC_ERROR;

3984: x_msg_count => l_msg_count,
3985: x_msg_data => l_msg_data);
3986:
3987: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3988: RAISE FND_API.G_EXC_ERROR;
3989: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3991: END IF;
3992:

Line 3989: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3985: x_msg_data => l_msg_data);
3986:
3987: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3988: RAISE FND_API.G_EXC_ERROR;
3989: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3991: END IF;
3992:
3993: -- Bug 3951947 Should compare the source and target

Line 3990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3986:
3987: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3988: RAISE FND_API.G_EXC_ERROR;
3989: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3991: END IF;
3992:
3993: -- Bug 3951947 Should compare the source and target
3994: -- projects' project currencies

Line 4328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4324: x_planning_start_tbl => l_c_schedule_start_tbl,
4325: x_planning_end_tbl => l_c_schedule_end_tbl,
4326: x_return_status => x_return_status);
4327:
4328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4329: RAISE FND_API.G_EXC_ERROR;
4330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: END IF;

Line 4329: RAISE FND_API.G_EXC_ERROR;

4325: x_planning_end_tbl => l_c_schedule_end_tbl,
4326: x_return_status => x_return_status);
4327:
4328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4329: RAISE FND_API.G_EXC_ERROR;
4330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: END IF;
4333:

Line 4330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4326: x_return_status => x_return_status);
4327:
4328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4329: RAISE FND_API.G_EXC_ERROR;
4330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: END IF;
4333:
4334: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4327:
4328: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4329: RAISE FND_API.G_EXC_ERROR;
4330: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: END IF;
4333:
4334: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4335: pa_debug.g_err_stage:= 'TA: ' || L_FuncProc || ' Returned count on adjust: ' || l_c_resource_assgt_tbl.COUNT ;

Line 4491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4487: x_msg_data => l_msg_data);
4488:
4489: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
4490:
4491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4492: RAISE FND_API.G_EXC_ERROR;
4493: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4495: END IF;

Line 4492: RAISE FND_API.G_EXC_ERROR;

4488:
4489: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
4490:
4491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4492: RAISE FND_API.G_EXC_ERROR;
4493: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4495: END IF;
4496:

Line 4493: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4489: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
4490:
4491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4492: RAISE FND_API.G_EXC_ERROR;
4493: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4495: END IF;
4496:
4497: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4490:
4491: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4492: RAISE FND_API.G_EXC_ERROR;
4493: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4495: END IF;
4496:
4497: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4498: pa_debug.g_err_stage:='TA: ' || L_FuncProc || 'Add_Planning_Transactions return status: ' || x_return_status;

Line 4546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4542: x_return_status => x_return_status,
4543: x_msg_count => l_msg_count,
4544: x_msg_data => l_msg_data);
4545:
4546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4547: RAISE FND_API.G_EXC_ERROR;
4548: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4550: END IF;

Line 4547: RAISE FND_API.G_EXC_ERROR;

4543: x_msg_count => l_msg_count,
4544: x_msg_data => l_msg_data);
4545:
4546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4547: RAISE FND_API.G_EXC_ERROR;
4548: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4550: END IF;
4551:

Line 4548: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4544: x_msg_data => l_msg_data);
4545:
4546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4547: RAISE FND_API.G_EXC_ERROR;
4548: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4550: END IF;
4551:
4552: END IF;

Line 4549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4545:
4546: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4547: RAISE FND_API.G_EXC_ERROR;
4548: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4550: END IF;
4551:
4552: END IF;
4553: -- \Bug 3974569.

Line 4606: WHEN FND_API.G_EXC_ERROR THEN

4602: DELETE pa_copy_asgmts_temp;
4603:
4604: EXCEPTION
4605:
4606: WHEN FND_API.G_EXC_ERROR THEN
4607: x_return_status := FND_API.G_RET_STS_ERROR;
4608: DELETE pa_copy_asgmts_temp;
4609: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
4610: PA_DEBUG.write_log (x_module => L_Module,

Line 4607: x_return_status := FND_API.G_RET_STS_ERROR;

4603:
4604: EXCEPTION
4605:
4606: WHEN FND_API.G_EXC_ERROR THEN
4607: x_return_status := FND_API.G_RET_STS_ERROR;
4608: DELETE pa_copy_asgmts_temp;
4609: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 5) THEN
4610: PA_DEBUG.write_log (x_module => L_Module,
4611: x_msg => 'Error:' || L_FuncProc || SQLERRM,

Line 4615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4611: x_msg => 'Error:' || L_FuncProc || SQLERRM,
4612: x_log_level => 5);
4613: END IF;
4614:
4615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4617: DELETE pa_copy_asgmts_temp;
4618: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
4619: PA_DEBUG.write_log (x_module => L_Module,

Line 4616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4612: x_log_level => 5);
4613: END IF;
4614:
4615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4617: DELETE pa_copy_asgmts_temp;
4618: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
4619: PA_DEBUG.write_log (x_module => L_Module,
4620: x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM,

Line 4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4622: END IF;
4623: RAISE;
4624:
4625: WHEN OTHERS THEN
4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4627: DELETE pa_copy_asgmts_temp;
4628: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
4629: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
4630: PA_DEBUG.write_log (x_module => L_Module,

Line 4679: p_resource_list_member_id <> FND_API.G_MISS_NUM THEN

4675: END IF;
4676:
4677:
4678: IF p_resource_list_member_id is NOT NULL AND
4679: p_resource_list_member_id <> FND_API.G_MISS_NUM THEN
4680:
4681:
4682: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4683: pa_debug.g_err_stage:='B4 query : ' || L_FuncProc;

Line 4820: p_fc_res_type_code <> FND_API.G_MISS_CHAR THEN

4816:
4817:
4818: IF p_fc_res_type_code is NOT NULL AND
4819:
4820: p_fc_res_type_code <> FND_API.G_MISS_CHAR THEN
4821:
4822:
4823:
4824: OPEN C_Fc_Check(p_fc_res_type_code);

Line 5625: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5621: x_return_status => l_return_status,
5622: x_msg_count => l_msg_count,
5623: x_msg_data => l_msg_data );
5624:
5625: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5626: -- 4537865
5627: l_baselined_version_id := l_new_baselined_version_id ; -- Though not used further ,assigning back to l_baselined_version_id to
5628: -- retain the older meaning
5629: END IF;

Line 5810: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5806: x_msg_data => l_msg_data );
5807:
5808: -- 4537865
5809: -- Though not used further ,assigning l_new_baselined_version_id back to l_baselined_version_id to retain the older meaning
5810: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5811: l_baselined_version_id := l_new_baselined_version_id ;
5812: END IF;
5813: --g_resource_assignment_id := p_resource_assignment_id;
5814: --END IF;

Line 6094: (p_char is NULL OR p_char = fnd_api.g_miss_char) THEN

6090:
6091:
6092: if p_mode = 'F' and
6093:
6094: (p_char is NULL OR p_char = fnd_api.g_miss_char) THEN
6095:
6096:
6097:
6098: return to_char(NULL);

Line 6104: (p_char is NULL OR p_char = fnd_api.g_miss_char) THEN

6100:
6101:
6102: elsif p_mode = 'B' and
6103:
6104: (p_char is NULL OR p_char = fnd_api.g_miss_char) THEN
6105:
6106:
6107:
6108: return fnd_api.g_miss_char;

Line 6108: return fnd_api.g_miss_char;

6104: (p_char is NULL OR p_char = fnd_api.g_miss_char) THEN
6105:
6106:
6107:
6108: return fnd_api.g_miss_char;
6109:
6110:
6111:
6112: elsif p_char is NOT NULL THEN

Line 6144: ( p_num is NULL OR p_num = fnd_api.g_miss_num ) THEN

6140:
6141:
6142: if p_mode = 'F' and
6143:
6144: ( p_num is NULL OR p_num = fnd_api.g_miss_num ) THEN
6145:
6146:
6147:
6148: return to_number(NULL);

Line 6154: ( p_num is NULL OR p_num = fnd_api.g_miss_num ) THEN

6150:
6151:
6152: elsif p_mode = 'B' and
6153:
6154: ( p_num is NULL OR p_num = fnd_api.g_miss_num ) THEN
6155:
6156:
6157:
6158: return fnd_api.g_miss_num;

Line 6158: return fnd_api.g_miss_num;

6154: ( p_num is NULL OR p_num = fnd_api.g_miss_num ) THEN
6155:
6156:
6157:
6158: return fnd_api.g_miss_num;
6159:
6160: elsif p_num is NOT NULL THEN
6161:
6162:

Line 6190: (p_date is NULL OR p_date = fnd_api.g_miss_date ) THEN

6186:
6187:
6188: if p_mode = 'F' and
6189:
6190: (p_date is NULL OR p_date = fnd_api.g_miss_date ) THEN
6191:
6192:
6193:
6194: return to_date(NULL);

Line 6202: (p_date is NULL OR p_date = fnd_api.g_miss_date ) THEN

6198:
6199:
6200: elsif p_mode = 'B' and
6201:
6202: (p_date is NULL OR p_date = fnd_api.g_miss_date ) THEN
6203:
6204:
6205:
6206: return fnd_api.g_miss_date;

Line 6206: return fnd_api.g_miss_date;

6202: (p_date is NULL OR p_date = fnd_api.g_miss_date ) THEN
6203:
6204:
6205:
6206: return fnd_api.g_miss_date;
6207:
6208: elsif p_date is NOT NULL THEN
6209:
6210:

Line 6271: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

6267:
6268:
6269: PROCEDURE CHECK_EDIT_OK(
6270: p_api_version_number IN NUMBER := 1.0
6271: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6272: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6273: , p_project_id IN NUMBER
6274: , p_pa_structure_version_id IN NUMBER
6275: , px_budget_version_id IN OUT NOCOPY NUMBER

Line 6272: , p_commit IN VARCHAR2 := FND_API.G_FALSE

6268:
6269: PROCEDURE CHECK_EDIT_OK(
6270: p_api_version_number IN NUMBER := 1.0
6271: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6272: , p_commit IN VARCHAR2 := FND_API.G_FALSE
6273: , p_project_id IN NUMBER
6274: , p_pa_structure_version_id IN NUMBER
6275: , px_budget_version_id IN OUT NOCOPY NUMBER
6276: , x_return_status OUT NOCOPY VARCHAR2 -- 4537865

Line 6347: x_return_status := FND_API.G_RET_STS_SUCCESS;

6343:
6344: BEGIN
6345:
6346: x_msg_count := 0;
6347: x_return_status := FND_API.G_RET_STS_SUCCESS;
6348:
6349: l_user_id := fnd_global.user_id;
6350: l_login_id := fnd_global.login_id;
6351: l_resp_id := FND_GLOBAL.Resp_id;

Line 6359: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

6355: PA_DEBUG.set_curr_function( p_function => 'CHECK_EDIT_OK',
6356: p_debug_mode => l_debug_mode );
6357: END IF;
6358:
6359: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
6360: FND_MSG_PUB.initialize;
6361: END IF;
6362:
6363: --Print All Input Params

Line 6406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

6402: p_msg_data => l_msg_data,
6403: p_return_status => l_return_status,
6404: p_function_allowed => l_function_allowed);
6405:
6406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
6407: THEN
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
6410: THEN

Line 6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6404: p_function_allowed => l_function_allowed);
6405:
6406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
6407: THEN
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
6410: THEN
6411: RAISE FND_API.G_EXC_ERROR;
6412: END IF;

Line 6409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

6405:
6406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
6407: THEN
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
6410: THEN
6411: RAISE FND_API.G_EXC_ERROR;
6412: END IF;
6413:

Line 6411: RAISE FND_API.G_EXC_ERROR;

6407: THEN
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
6410: THEN
6411: RAISE FND_API.G_EXC_ERROR;
6412: END IF;
6413:
6414: IF l_function_allowed = 'N' THEN
6415: pa_interface_utils_pub.map_new_amg_msg

Line 6425: x_return_status := FND_API.G_RET_STS_ERROR;

6421: ,p_attribute2 => ''
6422: ,p_attribute3 => ''
6423: ,p_attribute4 => ''
6424: ,p_attribute5 => '');
6425: x_return_status := FND_API.G_RET_STS_ERROR;
6426: RAISE FND_API.G_EXC_ERROR;
6427: END IF;
6428: IF l_debug_mode = 'Y' THEN
6429: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: UPDATE_TASK_ASSIGNMENT: Suceess';

Line 6426: RAISE FND_API.G_EXC_ERROR;

6422: ,p_attribute3 => ''
6423: ,p_attribute4 => ''
6424: ,p_attribute5 => '');
6425: x_return_status := FND_API.G_RET_STS_ERROR;
6426: RAISE FND_API.G_EXC_ERROR;
6427: END IF;
6428: IF l_debug_mode = 'Y' THEN
6429: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: UPDATE_TASK_ASSIGNMENT: Suceess';
6430: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);

Line 6458: x_return_status := FND_API.G_RET_STS_ERROR;

6454: ,p_attribute2 => ''
6455: ,p_attribute3 => ''
6456: ,p_attribute4 => ''
6457: ,p_attribute5 => '');
6458: x_return_status := FND_API.G_RET_STS_ERROR;
6459: RAISE FND_API.G_EXC_ERROR;
6460: END IF;
6461: IF l_debug_mode = 'Y' THEN
6462: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Update/Query Project: Success';

Line 6459: RAISE FND_API.G_EXC_ERROR;

6455: ,p_attribute3 => ''
6456: ,p_attribute4 => ''
6457: ,p_attribute5 => '');
6458: x_return_status := FND_API.G_RET_STS_ERROR;
6459: RAISE FND_API.G_EXC_ERROR;
6460: END IF;
6461: IF l_debug_mode = 'Y' THEN
6462: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Update/Query Project: Success';
6463: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);

Line 6482: RAISE FND_API.G_EXC_ERROR;

6478: ,p_attribute3 => ''
6479: ,p_attribute4 => ''
6480: ,p_attribute5 => '');
6481: END IF;
6482: RAISE FND_API.G_EXC_ERROR;
6483: END IF;
6484:
6485: IF (px_budget_version_id is not null and px_budget_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
6486: OPEN C_validate_Budget_Version_Id(px_budget_version_id,p_project_id);

Line 6495: raise FND_API.G_EXC_ERROR;

6491: ,p_msg_name => 'PA_FP_INVALID_VERSION_ID'
6492: ,p_token1 => 'BUDGET_VERSION_ID'
6493: ,p_value1 => px_budget_version_id);
6494: CLOSE C_validate_Budget_Version_Id ;
6495: raise FND_API.G_EXC_ERROR;
6496: END IF;
6497: CLOSE C_validate_Budget_Version_Id ;
6498: ELSIF ( p_pa_structure_version_id IS NOT NULL AND
6499: ( p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) )THEN

Line 6509: RAISE FND_API.G_EXC_ERROR;

6505: ( p_app_short_name => 'PA',
6506: p_msg_name => 'PA_INVALID_STR_VERSION_ID'
6507: );
6508: CLOSE c_validate_str_version_id;
6509: RAISE FND_API.G_EXC_ERROR;
6510: END IF;
6511: CLOSE c_validate_str_version_id;
6512: --Get the budget version_id
6513: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);

Line 6538: x_return_status := FND_API.G_RET_STS_ERROR;

6534: -- PA_UTILS.ADD_MESSAGE
6535: --( p_app_short_name => 'PA',
6536: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR'
6537: --);
6538: x_return_status := FND_API.G_RET_STS_ERROR;
6539: RAISE FND_API.G_EXC_ERROR;
6540: END IF;
6541: IF l_debug_mode = 'Y' THEN
6542: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Calling Check_edit_ok: Success';

Line 6539: RAISE FND_API.G_EXC_ERROR;

6535: --( p_app_short_name => 'PA',
6536: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR'
6537: --);
6538: x_return_status := FND_API.G_RET_STS_ERROR;
6539: RAISE FND_API.G_EXC_ERROR;
6540: END IF;
6541: IF l_debug_mode = 'Y' THEN
6542: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Calling Check_edit_ok: Success';
6543: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);

Line 6555: x_return_status := FND_API.G_RET_STS_ERROR;

6551: (p_app_short_name => 'PA',
6552: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
6553: );
6554: END IF;
6555: x_return_status := FND_API.G_RET_STS_ERROR;
6556: px_budget_version_id := null;
6557: RAISE FND_API.G_EXC_ERROR;
6558: ELSE
6559: px_budget_version_id := l_budget_version_id;

Line 6557: RAISE FND_API.G_EXC_ERROR;

6553: );
6554: END IF;
6555: x_return_status := FND_API.G_RET_STS_ERROR;
6556: px_budget_version_id := null;
6557: RAISE FND_API.G_EXC_ERROR;
6558: ELSE
6559: px_budget_version_id := l_budget_version_id;
6560: END IF;
6561: IF l_debug_mode = 'Y' THEN

Line 6571: WHEN FND_API.G_EXC_ERROR THEN

6567: END IF;
6568:
6569: EXCEPTION
6570:
6571: WHEN FND_API.G_EXC_ERROR THEN
6572:
6573: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6574: l_msg_count := Fnd_Msg_Pub.count_msg;
6575:

Line 6573: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6569: EXCEPTION
6570:
6571: WHEN FND_API.G_EXC_ERROR THEN
6572:
6573: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6574: l_msg_count := Fnd_Msg_Pub.count_msg;
6575:
6576: -- 4537865
6577: px_budget_version_id := NULL ;

Line 6594: ( p_encoded => Fnd_Api.G_TRUE

6590:
6591: IF l_msg_count = 1 AND x_msg_data IS NULL
6592: THEN
6593: Pa_Interface_Utils_Pub.get_messages
6594: ( p_encoded => Fnd_Api.G_TRUE
6595: , p_msg_index => 1
6596: , p_msg_count => l_msg_count
6597: , p_msg_data => l_msg_data
6598: , p_data => l_data

Line 6611: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6607: END IF;
6608:
6609: WHEN OTHERS THEN
6610:
6611: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6612: x_msg_count := 1;
6613: x_msg_data := SQLERRM;
6614: -- 4537865
6615: px_budget_version_id := NULL ;