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

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

8: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:
10: PROCEDURE Load_Task_Assignments
11: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
13: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
14: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
15: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
16: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

9:
10: PROCEDURE Load_Task_Assignments
11: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
13: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
14: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
15: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
16: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
17: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 97: IF NOT FND_API.Compatible_API_Call ( 1.0, --pa_project_pub.g_api_version_number ,

93: SAVEPOINT load_task_asgmts_pub;
94:
95: -- Standard call to check for call compatibility.
96:
97: IF NOT FND_API.Compatible_API_Call ( 1.0, --pa_project_pub.g_api_version_number ,
98: p_api_version_number ,
99: l_api_name ,
100: G_PKG_NAME )
101: THEN

Line 103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

99: l_api_name ,
100: G_PKG_NAME )
101: THEN
102:
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104:
105: END IF;
106:
107: --dbms_output.put_line('FND API Compatible:' || L_FuncProc);

Line 107: --dbms_output.put_line('FND API Compatible:' || L_FuncProc);

103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104:
105: END IF;
106:
107: --dbms_output.put_line('FND API Compatible:' || L_FuncProc);
108:
109: -- Initialize the message table if requested.
110:
111: IF FND_API.TO_BOOLEAN( p_init_msg_list )

Line 111: IF FND_API.TO_BOOLEAN( p_init_msg_list )

107: --dbms_output.put_line('FND API Compatible:' || L_FuncProc);
108:
109: -- Initialize the message table if requested.
110:
111: IF FND_API.TO_BOOLEAN( p_init_msg_list )
112:
113: THEN
114:
115: FND_MSG_PUB.initialize;

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: END IF;
118:
119: -- Set API return status to success
120:
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
124: pa_debug.g_err_stage:='Before Looping through 1000 records.' ;
125: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 540: WHEN FND_API.G_EXC_ERROR

536: END IF;
537:
538: EXCEPTION
539:
540: WHEN FND_API.G_EXC_ERROR
541: THEN
542: ROLLBACK TO load_task_asgmts_pub;
543:
544: x_return_status := FND_API.G_RET_STS_ERROR;

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: WHEN FND_API.G_EXC_ERROR
541: THEN
542: ROLLBACK TO load_task_asgmts_pub;
543:
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: IF P_DEBUG_MODE = 'Y' THEN
546: PA_DEBUG.write_log (x_module => G_PKG_NAME
547: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
548: ,x_log_level => 5);

Line 555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

551: FND_MSG_PUB.Count_And_Get
552: ( p_count => x_msg_count ,
553: p_data => x_msg_data );
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
556: THEN
557: ROLLBACK TO load_task_asgmts_pub;
558:
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
556: THEN
557: ROLLBACK TO load_task_asgmts_pub;
558:
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: IF P_DEBUG_MODE = 'Y' THEN
561: PA_DEBUG.write_log (x_module => G_PKG_NAME
562: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
563: ,x_log_level => 5);

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

577:
578: WHEN OTHERS THEN
579: ROLLBACK TO load_task_asgmts_pub;
580:
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: IF P_DEBUG_MODE = 'Y' THEN
583: PA_DEBUG.write_log (x_module => G_PKG_NAME
584: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
585: ,x_log_level => 5);

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

600:
601:
602: PROCEDURE Load_Task_Asgmt_Periods
603: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
604: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
605: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
606: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
607: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

601:
602: PROCEDURE Load_Task_Asgmt_Periods
603: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
604: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
605: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
606: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
607: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
609: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 652: IF NOT FND_API.Compatible_API_Call ( 1.0, --pa_project_pub.g_api_version_number ,

648: SAVEPOINT Load_Task_Asgmt_Periods;
649:
650: -- Standard call to check for call compatibility.
651:
652: IF NOT FND_API.Compatible_API_Call ( 1.0, --pa_project_pub.g_api_version_number ,
653: p_api_version_number ,
654: l_api_name ,
655: G_PKG_NAME )
656: THEN

Line 658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

654: l_api_name ,
655: G_PKG_NAME )
656: THEN
657:
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659:
660: END IF;
661:
662: -- Initialize the message table if requested.

Line 664: IF FND_API.TO_BOOLEAN( p_init_msg_list )

660: END IF;
661:
662: -- Initialize the message table if requested.
663:
664: IF FND_API.TO_BOOLEAN( p_init_msg_list )
665:
666: THEN
667:
668: FND_MSG_PUB.initialize;

Line 674: x_return_status := FND_API.G_RET_STS_SUCCESS;

670: END IF;
671:
672: -- Set API return status to success
673:
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675:
676:
677:
678: --assign appropriate values to outgoing parameters

Line 915: WHEN FND_API.G_EXC_ERROR

911: END LOOP;
912:
913: EXCEPTION
914:
915: WHEN FND_API.G_EXC_ERROR
916: THEN
917: ROLLBACK TO Load_Task_Asgmt_Periods;
918:
919: x_return_status := FND_API.G_RET_STS_ERROR;

Line 919: x_return_status := FND_API.G_RET_STS_ERROR;

915: WHEN FND_API.G_EXC_ERROR
916: THEN
917: ROLLBACK TO Load_Task_Asgmt_Periods;
918:
919: x_return_status := FND_API.G_RET_STS_ERROR;
920: IF P_DEBUG_MODE = 'Y' THEN
921: PA_DEBUG.write_log (x_module => G_PKG_NAME
922: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
923: ,x_log_level => 5);

Line 930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

926: FND_MSG_PUB.Count_And_Get
927: ( p_count => x_msg_count ,
928: p_data => x_msg_data );
929:
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
931: THEN
932: ROLLBACK TO Load_Task_Asgmt_Periods;
933:
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
931: THEN
932: ROLLBACK TO Load_Task_Asgmt_Periods;
933:
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: IF P_DEBUG_MODE = 'Y' THEN
936: PA_DEBUG.write_log (x_module => G_PKG_NAME
937: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
938: ,x_log_level => 5);

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

951:
952: WHEN OTHERS THEN
953: ROLLBACK TO Load_Task_Asgmt_Periods;
954:
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: IF P_DEBUG_MODE = 'Y' THEN
957: PA_DEBUG.write_log (x_module => G_PKG_NAME
958: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
959: ,x_log_level => 5);

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

985: --
986:
987: PROCEDURE Execute_Create_Task_Asgmts
988: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
990: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
991: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
993: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

986:
987: PROCEDURE Execute_Create_Task_Asgmts
988: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
990: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
991: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
993: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
994: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1024: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,

1020: SAVEPOINT EXECUTE_CREATE_TASK_ASGMTS;
1021:
1022: -- Standard call to check for call compatibility.
1023:
1024: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,
1025: p_api_version_number,
1026: l_api_name,
1027: G_PKG_NAME )
1028: THEN

Line 1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1025: p_api_version_number,
1026: l_api_name,
1027: G_PKG_NAME )
1028: THEN
1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END IF;
1031:
1032:
1033: -- Initialize the message table if requested.

Line 1035: IF FND_API.TO_BOOLEAN( p_init_msg_list )

1031:
1032:
1033: -- Initialize the message table if requested.
1034:
1035: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1036: THEN
1037: FND_MSG_PUB.initialize;
1038: END IF;
1039:

Line 1042: x_return_status := FND_API.G_RET_STS_SUCCESS;

1038: END IF;
1039:
1040: -- Set API return status to success
1041:
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;
1043: --dbms_output.put_line('g_task_asgmts_tbl_count:' || g_task_asgmts_tbl_count);
1044: --dbms_output.put_line('g_asgmts_periods_tbl_count:' || g_asgmts_periods_tbl_count);
1045:
1046:

Line 1051: ,p_commit => FND_API.G_FALSE

1047: IF nvl(g_task_asgmts_tbl_count, 0) > 0 THEN
1048: --dbms_output.put_line('calling create task assignment');
1049: Create_Task_Assignments
1050: ( p_api_version_number => 1.0
1051: ,p_commit => FND_API.G_FALSE
1052: ,p_init_msg_list => FND_API.G_FALSE
1053: ,p_pm_product_code => p_pm_product_code
1054: ,p_pm_project_reference => p_pm_project_reference
1055: ,p_pa_project_id => p_pa_project_id

Line 1052: ,p_init_msg_list => FND_API.G_FALSE

1048: --dbms_output.put_line('calling create task assignment');
1049: Create_Task_Assignments
1050: ( p_api_version_number => 1.0
1051: ,p_commit => FND_API.G_FALSE
1052: ,p_init_msg_list => FND_API.G_FALSE
1053: ,p_pm_product_code => p_pm_product_code
1054: ,p_pm_project_reference => p_pm_project_reference
1055: ,p_pa_project_id => p_pa_project_id
1056: ,p_pa_structure_version_id => p_pa_structure_version_id

Line 1063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1059: ,x_msg_count => l_msg_count
1060: ,x_msg_data => l_msg_data
1061: ,x_return_status => l_return_status
1062: );
1063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1064:
1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1066:
1067: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1061: ,x_return_status => l_return_status
1062: );
1063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1064:
1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1066:
1067: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1068:
1069: RAISE FND_API.G_EXC_ERROR;

Line 1067: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1064:
1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1066:
1067: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1068:
1069: RAISE FND_API.G_EXC_ERROR;
1070:
1071: END IF;

Line 1069: RAISE FND_API.G_EXC_ERROR;

1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1066:
1067: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1068:
1069: RAISE FND_API.G_EXC_ERROR;
1070:
1071: END IF;
1072:
1073: END IF;

Line 1081: ,p_commit => FND_API.G_FALSE

1077:
1078: --dbms_output.put_line('calling create task assignment periods');
1079: Pa_Task_Assignments_Pvt.Create_Task_Assignment_Periods
1080: ( p_api_version_number => 1.0
1081: ,p_commit => FND_API.G_FALSE
1082: ,p_init_msg_list => FND_API.G_FALSE
1083: ,p_pm_product_code => p_pm_product_code
1084: ,p_pm_project_reference => p_pm_project_reference
1085: ,p_pa_project_id => p_pa_project_id

Line 1082: ,p_init_msg_list => FND_API.G_FALSE

1078: --dbms_output.put_line('calling create task assignment periods');
1079: Pa_Task_Assignments_Pvt.Create_Task_Assignment_Periods
1080: ( p_api_version_number => 1.0
1081: ,p_commit => FND_API.G_FALSE
1082: ,p_init_msg_list => FND_API.G_FALSE
1083: ,p_pm_product_code => p_pm_product_code
1084: ,p_pm_project_reference => p_pm_project_reference
1085: ,p_pa_project_id => p_pa_project_id
1086: ,p_pa_structure_version_id => p_pa_structure_version_id

Line 1093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1089: ,x_msg_count => l_msg_count
1090: ,x_msg_data => l_msg_data
1091: ,x_return_status => l_return_status
1092: );
1093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1094:
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096:
1097: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1091: ,x_return_status => l_return_status
1092: );
1093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1094:
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096:
1097: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098:
1099: RAISE FND_API.G_EXC_ERROR;

Line 1097: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1093: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1094:
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096:
1097: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098:
1099: RAISE FND_API.G_EXC_ERROR;
1100:
1101: END IF;

Line 1099: RAISE FND_API.G_EXC_ERROR;

1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096:
1097: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098:
1099: RAISE FND_API.G_EXC_ERROR;
1100:
1101: END IF;
1102:
1103: END IF;

Line 1107: IF FND_API.to_boolean( p_commit ) THEN

1103: END IF;
1104:
1105:
1106:
1107: IF FND_API.to_boolean( p_commit ) THEN
1108: COMMIT;
1109: END IF;
1110:
1111:

Line 1114: WHEN FND_API.G_EXC_ERROR

1110:
1111:
1112: EXCEPTION
1113:
1114: WHEN FND_API.G_EXC_ERROR
1115: THEN
1116: ROLLBACK TO EXECUTE_CREATE_TASK_ASGMTS;
1117:
1118: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1118: x_return_status := FND_API.G_RET_STS_ERROR;

1114: WHEN FND_API.G_EXC_ERROR
1115: THEN
1116: ROLLBACK TO EXECUTE_CREATE_TASK_ASGMTS;
1117:
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: IF P_DEBUG_MODE = 'Y' THEN
1120: PA_DEBUG.write_log (x_module => G_PKG_NAME
1121: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
1122: ,x_log_level => 5);

Line 1128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1124: FND_MSG_PUB.Count_And_Get
1125: ( p_count => x_msg_count ,
1126: p_data => x_msg_data );
1127:
1128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1129: THEN
1130: ROLLBACK TO EXECUTE_CREATE_TASK_ASGMTS;
1131:
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1129: THEN
1130: ROLLBACK TO EXECUTE_CREATE_TASK_ASGMTS;
1131:
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1133: IF P_DEBUG_MODE = 'Y' THEN
1134: PA_DEBUG.write_log (x_module => G_PKG_NAME
1135: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1136: ,x_log_level => 5);

Line 1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1141:
1142: WHEN OTHERS THEN
1143: ROLLBACK TO EXECUTE_CREATE_TASK_ASGMTS;
1144:
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: IF P_DEBUG_MODE = 'Y' THEN
1147: PA_DEBUG.write_log (x_module => G_PKG_NAME
1148: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
1149: ,x_log_level => 5);

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

1164:
1165:
1166: PROCEDURE Execute_Update_Task_Asgmts
1167: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1169: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1170: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1165:
1166: PROCEDURE Execute_Update_Task_Asgmts
1167: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1169: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1170: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1173: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1196: x_return_status := FND_API.G_RET_STS_SUCCESS;

1192: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1193: pa_debug.g_err_stage:='Entered ' || L_FuncProc;
1194: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1195: END IF;
1196: x_return_status := FND_API.G_RET_STS_SUCCESS;
1197: -- Standard begin of API savepoint
1198:
1199: SAVEPOINT EXECUTE_UPDATE_TASK_ASGMTS;
1200:

Line 1203: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,

1199: SAVEPOINT EXECUTE_UPDATE_TASK_ASGMTS;
1200:
1201: -- Standard call to check for call compatibility.
1202:
1203: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,
1204: p_api_version_number,
1205: l_api_name,
1206: G_PKG_NAME )
1207: THEN

Line 1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1204: p_api_version_number,
1205: l_api_name,
1206: G_PKG_NAME )
1207: THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: END IF;
1210:
1211:
1212: -- Initialize the message table if requested.

Line 1214: IF FND_API.TO_BOOLEAN( p_init_msg_list )

1210:
1211:
1212: -- Initialize the message table if requested.
1213:
1214: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1215: THEN
1216: FND_MSG_PUB.initialize;
1217: END IF;
1218:

Line 1223: x_return_status := FND_API.G_RET_STS_SUCCESS;

1219:
1220:
1221: -- Set API return status to success
1222:
1223: x_return_status := FND_API.G_RET_STS_SUCCESS;
1224:
1225: IF nvl(g_task_asgmts_tbl_count, 0) > 0 THEN
1226:
1227: UPDATE_Task_Assignments

Line 1229: ,p_commit => FND_API.G_FALSE

1225: IF nvl(g_task_asgmts_tbl_count, 0) > 0 THEN
1226:
1227: UPDATE_Task_Assignments
1228: ( p_api_version_number => 1.0
1229: ,p_commit => FND_API.G_FALSE
1230: ,p_init_msg_list => FND_API.G_FALSE
1231: ,p_pm_product_code => p_pm_product_code
1232: ,p_pm_project_reference => p_pm_project_reference
1233: ,p_pa_project_id => p_pa_project_id

Line 1230: ,p_init_msg_list => FND_API.G_FALSE

1226:
1227: UPDATE_Task_Assignments
1228: ( p_api_version_number => 1.0
1229: ,p_commit => FND_API.G_FALSE
1230: ,p_init_msg_list => FND_API.G_FALSE
1231: ,p_pm_product_code => p_pm_product_code
1232: ,p_pm_project_reference => p_pm_project_reference
1233: ,p_pa_project_id => p_pa_project_id
1234: ,p_pa_structure_version_id => p_pa_structure_version_id

Line 1241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1237: ,x_msg_count => l_msg_count
1238: ,x_msg_data => l_msg_data
1239: ,x_return_status => l_return_status
1240: );
1241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1242:
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244:
1245: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1239: ,x_return_status => l_return_status
1240: );
1241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1242:
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244:
1245: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1246:
1247: RAISE FND_API.G_EXC_ERROR;

Line 1245: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1242:
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244:
1245: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1246:
1247: RAISE FND_API.G_EXC_ERROR;
1248:
1249: END IF;

Line 1247: RAISE FND_API.G_EXC_ERROR;

1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244:
1245: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1246:
1247: RAISE FND_API.G_EXC_ERROR;
1248:
1249: END IF;
1250:
1251: END IF;

Line 1257: ,p_commit => FND_API.G_FALSE

1253: IF nvl(g_asgmts_periods_tbl_count,0) > 0 THEN
1254:
1255: Pa_Task_Assignments_Pvt.Create_Task_Assignment_Periods
1256: (p_api_version_number => 1.0
1257: ,p_commit => FND_API.G_FALSE
1258: ,p_init_msg_list => FND_API.G_FALSE
1259: ,p_pm_product_code => p_pm_product_code
1260: ,p_pm_project_reference => p_pm_project_reference
1261: ,p_pa_project_id => p_pa_project_id

Line 1258: ,p_init_msg_list => FND_API.G_FALSE

1254:
1255: Pa_Task_Assignments_Pvt.Create_Task_Assignment_Periods
1256: (p_api_version_number => 1.0
1257: ,p_commit => FND_API.G_FALSE
1258: ,p_init_msg_list => FND_API.G_FALSE
1259: ,p_pm_product_code => p_pm_product_code
1260: ,p_pm_project_reference => p_pm_project_reference
1261: ,p_pa_project_id => p_pa_project_id
1262: ,p_pa_structure_version_id => p_pa_structure_version_id

Line 1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1266: ,x_msg_data => l_msg_data
1267: ,x_return_status => l_return_status
1268: );
1269:
1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271:
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1268: );
1269:
1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271:
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275:
1276: RAISE FND_API.G_EXC_ERROR;

Line 1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1270: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271:
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275:
1276: RAISE FND_API.G_EXC_ERROR;
1277:
1278: END IF;

Line 1276: RAISE FND_API.G_EXC_ERROR;

1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273:
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275:
1276: RAISE FND_API.G_EXC_ERROR;
1277:
1278: END IF;
1279: END IF;
1280:

Line 1284: IF FND_API.to_boolean( p_commit ) THEN

1280:
1281:
1282: --assign appropriate values to outgoing parameters
1283:
1284: IF FND_API.to_boolean( p_commit ) THEN
1285: COMMIT;
1286: END IF;
1287:
1288:

Line 1291: WHEN FND_API.G_EXC_ERROR

1287:
1288:
1289: EXCEPTION
1290:
1291: WHEN FND_API.G_EXC_ERROR
1292: THEN
1293: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1294:
1295: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1295: x_return_status := FND_API.G_RET_STS_ERROR;

1291: WHEN FND_API.G_EXC_ERROR
1292: THEN
1293: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1294:
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296:
1297: FND_MSG_PUB.Count_And_Get
1298: ( p_count => x_msg_count ,
1299: p_data => x_msg_data );

Line 1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1297: FND_MSG_PUB.Count_And_Get
1298: ( p_count => x_msg_count ,
1299: p_data => x_msg_data );
1300:
1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1302: THEN
1303: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1304:
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1302: THEN
1303: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1304:
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308: FND_MSG_PUB.add_exc_msg
1309: ( p_pkg_name => G_PKG_NAME

Line 1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1316:
1317: WHEN OTHERS THEN
1318: ROLLBACK TO EXECUTE_UPDATE_TASK_ASGMTS;
1319:
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321:
1322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1323: THEN
1324: FND_MSG_PUB.add_exc_msg

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

1335:
1336:
1337: PROCEDURE Create_Task_Assignments
1338: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1339: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1341: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1343: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1336:
1337: PROCEDURE Create_Task_Assignments
1338: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1339: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1341: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1343: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1344: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1614: IF NOT FND_API.Compatible_API_Call ( 1.0, --pa_project_pub.g_api_version_number ,

1610: SAVEPOINT add_task_asgmts_pub;
1611:
1612: -- Standard call to check for call compatibility.
1613:
1614: IF NOT FND_API.Compatible_API_Call ( 1.0, --pa_project_pub.g_api_version_number ,
1615: p_api_version_number ,
1616: l_api_name ,
1617: G_PKG_NAME )
1618: THEN

Line 1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1616: l_api_name ,
1617: G_PKG_NAME )
1618: THEN
1619:
1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1621:
1622: END IF;
1623:
1624: --dbms_output.put_line('Fnd Api is compatible:');

Line 1624: --dbms_output.put_line('Fnd Api is compatible:');

1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1621:
1622: END IF;
1623:
1624: --dbms_output.put_line('Fnd Api is compatible:');
1625:
1626: -- Initialize the message table if requested.
1627:
1628: IF FND_API.TO_BOOLEAN( p_init_msg_list )

Line 1628: IF FND_API.TO_BOOLEAN( p_init_msg_list )

1624: --dbms_output.put_line('Fnd Api is compatible:');
1625:
1626: -- Initialize the message table if requested.
1627:
1628: IF FND_API.TO_BOOLEAN( p_init_msg_list )
1629: THEN
1630:
1631: FND_MSG_PUB.initialize;
1632:

Line 1637: x_return_status := FND_API.G_RET_STS_SUCCESS;

1633: END IF;
1634:
1635: -- Set API return status to success
1636:
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;
1638:
1639: -- Initialize the message table if requested.
1640: -- pm_product_code is mandatory
1641:

Line 1664: RAISE FND_API.G_EXC_ERROR;

1660: ,p_attribute3 => ''
1661: ,p_attribute4 => ''
1662: ,p_attribute5 => '');
1663: END IF;
1664: RAISE FND_API.G_EXC_ERROR;
1665:
1666: END IF;
1667:
1668: --dbms_output.put_line('Product Code is checked:');

Line 1700: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1696: , p_out_project_id => l_project_id
1697: , p_return_status => l_return_status
1698: );
1699:
1700: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1701:
1702: --dbms_output.put_line('Project_id not successful ');
1703: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1704: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;

Line 1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1703: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1704: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
1705: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1706: END IF;
1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1708:
1709: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1710:
1711: --dbms_output.put_line('Project_id conv. not successful ');

Line 1709: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1705: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1706: END IF;
1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1708:
1709: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1710:
1711: --dbms_output.put_line('Project_id conv. not successful ');
1712: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1713: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;

Line 1716: RAISE FND_API.G_EXC_ERROR;

1712: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1713: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
1714: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1715: END IF;
1716: RAISE FND_API.G_EXC_ERROR;
1717:
1718: END IF;
1719: END IF;
1720:

Line 1758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1754: p_msg_data => l_msg_data,
1755: p_return_status => l_return_status,
1756: p_function_allowed => l_function_allowed);
1757:
1758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1759: THEN
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761:
1762: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1756: p_function_allowed => l_function_allowed);
1757:
1758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1759: THEN
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761:
1762: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1763: THEN
1764: RAISE FND_API.G_EXC_ERROR;

Line 1762: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1759: THEN
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761:
1762: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1763: THEN
1764: RAISE FND_API.G_EXC_ERROR;
1765: END IF;
1766:

Line 1764: RAISE FND_API.G_EXC_ERROR;

1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761:
1762: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1763: THEN
1764: RAISE FND_API.G_EXC_ERROR;
1765: END IF;
1766:
1767: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1768: pa_debug.g_err_stage:=' PA_PM_ADD_TASK_ASSIGNMENT function check successful.' || L_FuncProc;

Line 1783: RAISE FND_API.G_EXC_ERROR;

1779: ,p_attribute2 => ''
1780: ,p_attribute3 => ''
1781: ,p_attribute4 => ''
1782: ,p_attribute5 => '');
1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785: --dbms_output.put_line('PA_FUNCTION_SECURITY_ENFORCED function check successful.');
1786: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1787: pa_debug.g_err_stage:=' PA_FUNCTION_SECURITY_ENFORCED function check successful.' || L_FuncProc;

Line 1816: RAISE FND_API.G_EXC_ERROR;

1812: ,p_attribute2 => ''
1813: ,p_attribute3 => ''
1814: ,p_attribute4 => ''
1815: ,p_attribute5 => '');
1816: RAISE FND_API.G_EXC_ERROR;
1817: END IF;
1818:
1819: --dbms_output.put_line('pa_security.allow_query or update successful..');
1820: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 1843: RAISE FND_API.G_EXC_ERROR;

1839: ,p_attribute3 => ''
1840: ,p_attribute4 => ''
1841: ,p_attribute5 => '');
1842: END IF;
1843: RAISE FND_API.G_EXC_ERROR;
1844: END IF;
1845: exception when others then
1846: null;
1847: end;

Line 1889: RAISE FND_API.G_EXC_ERROR;

1885: ,p_attribute3 => ''
1886: ,p_attribute4 => ''
1887: ,p_attribute5 => '');
1888: END IF;
1889: RAISE FND_API.G_EXC_ERROR;
1890: END IF;
1891:
1892: -- DHI ER: allowing multiple user to update task assignment
1893: -- Removed logic to lock version.

Line 1898: x_return_status := FND_API.G_RET_STS_ERROR;

1894: -- pa_task_assignments_pvt.lock_version(l_project_id, l_struct_elem_version_id);
1895:
1896: -- Bug 3940853: Raise locking error return from structure API
1897: IF FND_MSG_PUB.count_msg > 0 THEN
1898: x_return_status := FND_API.G_RET_STS_ERROR;
1899: RAISE FND_API.G_EXC_ERROR;
1900: END IF;
1901:
1902: IF 'N' = pa_task_assignment_utils.check_edit_task_ok

Line 1899: RAISE FND_API.G_EXC_ERROR;

1895:
1896: -- Bug 3940853: Raise locking error return from structure API
1897: IF FND_MSG_PUB.count_msg > 0 THEN
1898: x_return_status := FND_API.G_RET_STS_ERROR;
1899: RAISE FND_API.G_EXC_ERROR;
1900: END IF;
1901:
1902: IF 'N' = pa_task_assignment_utils.check_edit_task_ok
1903: ( P_PROJECT_ID => l_project_id,

Line 1911: x_return_status := FND_API.G_RET_STS_ERROR;

1907: --PA_UTILS.ADD_MESSAGE
1908: -- (p_app_short_name => 'PA',
1909: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR'
1910: -- );
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: RAISE FND_API.G_EXC_ERROR;
1913: END IF;
1914:
1915: --dbms_output.put_line(' check edit successful' );

Line 1912: RAISE FND_API.G_EXC_ERROR;

1908: -- (p_app_short_name => 'PA',
1909: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR'
1910: -- );
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: RAISE FND_API.G_EXC_ERROR;
1913: END IF;
1914:
1915: --dbms_output.put_line(' check edit successful' );
1916: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 1938: x_return_status := FND_API.G_RET_STS_ERROR;

1934: (p_app_short_name => 'PA',
1935: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
1936: );
1937: END IF;
1938: x_return_status := FND_API.G_RET_STS_ERROR;
1939: RAISE FND_API.G_EXC_ERROR;
1940:
1941: END IF;
1942:

Line 1939: RAISE FND_API.G_EXC_ERROR;

1935: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
1936: );
1937: END IF;
1938: x_return_status := FND_API.G_RET_STS_ERROR;
1939: RAISE FND_API.G_EXC_ERROR;
1940:
1941: END IF;
1942:
1943: -- Check if the resource list is None for the workplan

Line 1966: x_return_status := FND_API.G_RET_STS_ERROR;

1962: ,p_value1 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
1963: ,p_token2 => 'TASK_NUMBER'
1964: ,p_value2 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
1965: );
1966: x_return_status := FND_API.G_RET_STS_ERROR;
1967: RAISE FND_API.G_EXC_ERROR;
1968: ELSE
1969: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1970: ,p_msg_name => 'PA_RES_LIST_NONE_ERR_AMG'

Line 1967: RAISE FND_API.G_EXC_ERROR;

1963: ,p_token2 => 'TASK_NUMBER'
1964: ,p_value2 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
1965: );
1966: x_return_status := FND_API.G_RET_STS_ERROR;
1967: RAISE FND_API.G_EXC_ERROR;
1968: ELSE
1969: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1970: ,p_msg_name => 'PA_RES_LIST_NONE_ERR_AMG'
1971: ,p_token1 => 'TASK_ID' -- Bug 6497559

Line 1974: x_return_status := FND_API.G_RET_STS_ERROR;

1970: ,p_msg_name => 'PA_RES_LIST_NONE_ERR_AMG'
1971: ,p_token1 => 'TASK_ID' -- Bug 6497559
1972: ,p_value1 => p_task_assignments_in(i).pa_task_id
1973: );
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977: END IF;
1978:

Line 1975: RAISE FND_API.G_EXC_ERROR;

1971: ,p_token1 => 'TASK_ID' -- Bug 6497559
1972: ,p_value1 => p_task_assignments_in(i).pa_task_id
1973: );
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977: END IF;
1978:
1979: */

Line 1986: x_return_status := FND_API.G_RET_STS_ERROR;

1982: PA_UTILS.ADD_MESSAGE
1983: (p_app_short_name => 'PA',
1984: p_msg_name => 'PA_RES_LIST_NONE_ERR'
1985: );
1986: x_return_status := FND_API.G_RET_STS_ERROR;
1987: RAISE FND_API.G_EXC_ERROR;
1988: END IF;
1989: --(End) Bug 13358104
1990:

Line 1987: RAISE FND_API.G_EXC_ERROR;

1983: (p_app_short_name => 'PA',
1984: p_msg_name => 'PA_RES_LIST_NONE_ERR'
1985: );
1986: x_return_status := FND_API.G_RET_STS_ERROR;
1987: RAISE FND_API.G_EXC_ERROR;
1988: END IF;
1989: --(End) Bug 13358104
1990:
1991: --dbms_output.put_line(' budget version id: ' || l_budget_version_id );

Line 2160: RAISE FND_API.G_EXC_ERROR;

2156: p_msg_name => 'PA_TASK_REQUIRED'
2157: );
2158: END IF;
2159:
2160: RAISE FND_API.G_EXC_ERROR;
2161: END IF;
2162:
2163: l_task_elem_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_struct_elem_version_id
2164: ,p_task_id => l_d_task_id);

Line 2194: RAISE FND_API.G_EXC_ERROR;

2190: p_msg_name => 'PA_TASK_REQUIRED'
2191: );
2192: END IF;
2193:
2194: RAISE FND_API.G_EXC_ERROR;
2195: END IF;
2196:
2197:
2198:

Line 2217: RAISE FND_API.G_EXC_ERROR;

2213: p_msg_name => 'PA_TASK_VERSION_REQUIRED'
2214: );
2215: END IF;
2216:
2217: RAISE FND_API.G_EXC_ERROR;
2218:
2219: END IF;
2220:
2221: --dbms_output.put_line('task elem version id ' || l_task_elem_version_id );

Line 2260: x_return_status := FND_API.G_RET_STS_ERROR;

2256: ,p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID_MSP'
2257: ,p_token1 => 'PLANNING_RESOURCE_NAME' -- Bug 6497559
2258: ,p_value1 => PA_TASK_UTILS.get_resource_name(p_task_assignments_in(i).resource_list_member_id)
2259: );
2260: x_return_status := FND_API.G_RET_STS_ERROR;
2261: RAISE FND_API.G_EXC_ERROR;
2262: ELSE
2263: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2264: ,p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID_AMG'

Line 2261: RAISE FND_API.G_EXC_ERROR;

2257: ,p_token1 => 'PLANNING_RESOURCE_NAME' -- Bug 6497559
2258: ,p_value1 => PA_TASK_UTILS.get_resource_name(p_task_assignments_in(i).resource_list_member_id)
2259: );
2260: x_return_status := FND_API.G_RET_STS_ERROR;
2261: RAISE FND_API.G_EXC_ERROR;
2262: ELSE
2263: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2264: ,p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID_AMG'
2265: ,p_token1 => 'PLANNING_RESOURCE_ID' -- Bug 6497559

Line 2268: x_return_status := FND_API.G_RET_STS_ERROR;

2264: ,p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID_AMG'
2265: ,p_token1 => 'PLANNING_RESOURCE_ID' -- Bug 6497559
2266: ,p_value1 => p_task_assignments_in(i).resource_list_member_id
2267: );
2268: x_return_status := FND_API.G_RET_STS_ERROR;
2269: RAISE FND_API.G_EXC_ERROR;
2270: END IF;
2271: END IF;
2272: END IF;

Line 2269: RAISE FND_API.G_EXC_ERROR;

2265: ,p_token1 => 'PLANNING_RESOURCE_ID' -- Bug 6497559
2266: ,p_value1 => p_task_assignments_in(i).resource_list_member_id
2267: );
2268: x_return_status := FND_API.G_RET_STS_ERROR;
2269: RAISE FND_API.G_EXC_ERROR;
2270: END IF;
2271: END IF;
2272: END IF;
2273:

Line 2286: x_return_status := FND_API.G_RET_STS_ERROR;

2282: x_msg_count => x_msg_count,
2283: x_msg_data => x_msg_data ) ;
2284:
2285: IF l_valid_member_flag = 'N' THEN
2286: x_return_status := FND_API.G_RET_STS_ERROR;
2287: RAISE FND_API.G_EXC_ERROR;
2288: END IF;
2289: -- ADD CBS VALIDATIONS HERE 16598322
2290: IF l_cbs_enabled_project = 'Y' THEN

Line 2287: RAISE FND_API.G_EXC_ERROR;

2283: x_msg_data => x_msg_data ) ;
2284:
2285: IF l_valid_member_flag = 'N' THEN
2286: x_return_status := FND_API.G_RET_STS_ERROR;
2287: RAISE FND_API.G_EXC_ERROR;
2288: END IF;
2289: -- ADD CBS VALIDATIONS HERE 16598322
2290: IF l_cbs_enabled_project = 'Y' THEN
2291: IF p_task_assignments_in(i).cbs_element_id IS NOT NULL AND

Line 2307: x_return_status := FND_API.G_RET_STS_ERROR;

2303: IF x_return_status <> 'S' THEN
2304: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2305: ,p_msg_name => x_msg_data
2306: );
2307: x_return_status := FND_API.G_RET_STS_ERROR;
2308: RAISE FND_API.G_EXC_ERROR;
2309: END IF;
2310:
2311: ELSE

Line 2308: RAISE FND_API.G_EXC_ERROR;

2304: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2305: ,p_msg_name => x_msg_data
2306: );
2307: x_return_status := FND_API.G_RET_STS_ERROR;
2308: RAISE FND_API.G_EXC_ERROR;
2309: END IF;
2310:
2311: ELSE
2312: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 2317: x_return_status := FND_API.G_RET_STS_ERROR;

2313: ,p_msg_name => 'PA_CBS_WP__COST_CODE_MNDTR'
2314: ,p_token1 => 'RES_NAME'
2315: ,p_value1 => PA_TASK_UTILS.get_resource_name(p_task_assignments_in(i).resource_list_member_id)
2316: );
2317: x_return_status := FND_API.G_RET_STS_ERROR;
2318: RAISE FND_API.G_EXC_ERROR;
2319:
2320: END IF;
2321:

Line 2318: RAISE FND_API.G_EXC_ERROR;

2314: ,p_token1 => 'RES_NAME'
2315: ,p_value1 => PA_TASK_UTILS.get_resource_name(p_task_assignments_in(i).resource_list_member_id)
2316: );
2317: x_return_status := FND_API.G_RET_STS_ERROR;
2318: RAISE FND_API.G_EXC_ERROR;
2319:
2320: END IF;
2321:
2322: END IF;

Line 2341: x_return_status := FND_API.G_RET_STS_ERROR;

2337: ,p_value1 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
2338: ,p_token2 => 'TASK_NUMBER'
2339: ,p_value2 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
2340: );
2341: x_return_status := FND_API.G_RET_STS_ERROR;
2342: RAISE FND_API.G_EXC_ERROR;
2343: ELSE
2344: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2345: ,p_msg_name => 'PA_INVALID_DATES_AMG'

Line 2342: RAISE FND_API.G_EXC_ERROR;

2338: ,p_token2 => 'TASK_NUMBER'
2339: ,p_value2 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
2340: );
2341: x_return_status := FND_API.G_RET_STS_ERROR;
2342: RAISE FND_API.G_EXC_ERROR;
2343: ELSE
2344: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2345: ,p_msg_name => 'PA_INVALID_DATES_AMG'
2346: ,p_token1 => 'TASK_ID' -- Bug 6497559

Line 2349: x_return_status := FND_API.G_RET_STS_ERROR;

2345: ,p_msg_name => 'PA_INVALID_DATES_AMG'
2346: ,p_token1 => 'TASK_ID' -- Bug 6497559
2347: ,p_value1 => p_task_assignments_in(i).pa_task_id
2348: );
2349: x_return_status := FND_API.G_RET_STS_ERROR;
2350: RAISE FND_API.G_EXC_ERROR;
2351: END IF;
2352: END IF;
2353:

Line 2350: RAISE FND_API.G_EXC_ERROR;

2346: ,p_token1 => 'TASK_ID' -- Bug 6497559
2347: ,p_value1 => p_task_assignments_in(i).pa_task_id
2348: );
2349: x_return_status := FND_API.G_RET_STS_ERROR;
2350: RAISE FND_API.G_EXC_ERROR;
2351: END IF;
2352: END IF;
2353:
2354: END IF;

Line 2367: x_return_status := FND_API.G_RET_STS_ERROR;

2363: (p_app_short_name => 'PA',
2364: p_msg_name => 'PA_PM_TASK_ASGMT_REF_REQ'
2365: );
2366: END IF;
2367: x_return_status := FND_API.G_RET_STS_ERROR;
2368: RAISE FND_API.G_EXC_ERROR;
2369:
2370: END IF;
2371:

Line 2368: RAISE FND_API.G_EXC_ERROR;

2364: p_msg_name => 'PA_PM_TASK_ASGMT_REF_REQ'
2365: );
2366: END IF;
2367: x_return_status := FND_API.G_RET_STS_ERROR;
2368: RAISE FND_API.G_EXC_ERROR;
2369:
2370: END IF;
2371:
2372: --dbms_output.put_line('pm_task_asgmt_reference is NULL/G_MISS..check passed');

Line 2392: x_return_status := FND_API.G_RET_STS_ERROR;

2388: );
2389: END IF;
2390: -- Bug 3937017 Moved Close cursor
2391: CLOSE C_Reference_Check;
2392: x_return_status := FND_API.G_RET_STS_ERROR;
2393: RAISE FND_API.G_EXC_ERROR;
2394: END IF;
2395: Close C_Reference_Check;
2396: --dbms_output.put_line('pm_task_asgmt_reference is EXISTING check passed');

Line 2393: RAISE FND_API.G_EXC_ERROR;

2389: END IF;
2390: -- Bug 3937017 Moved Close cursor
2391: CLOSE C_Reference_Check;
2392: x_return_status := FND_API.G_RET_STS_ERROR;
2393: RAISE FND_API.G_EXC_ERROR;
2394: END IF;
2395: Close C_Reference_Check;
2396: --dbms_output.put_line('pm_task_asgmt_reference is EXISTING check passed');
2397:

Line 2442: IF l_raw_cost_tbl(k_index) = FND_API.G_MISS_NUM THEN

2438: /* Bug Fix 5505113
2439: As per the B n F team request started overriding the miss num with NULL.
2440:
2441: */
2442: IF l_raw_cost_tbl(k_index) = FND_API.G_MISS_NUM THEN
2443: l_raw_cost_tbl(k_index) := NULL;
2444: END IF;
2445:
2446: IF l_burdened_cost_tbl(k_index) = FND_API.G_MISS_NUM THEN

Line 2446: IF l_burdened_cost_tbl(k_index) = FND_API.G_MISS_NUM THEN

2442: IF l_raw_cost_tbl(k_index) = FND_API.G_MISS_NUM THEN
2443: l_raw_cost_tbl(k_index) := NULL;
2444: END IF;
2445:
2446: IF l_burdened_cost_tbl(k_index) = FND_API.G_MISS_NUM THEN
2447: l_burdened_cost_tbl(k_index) := NULL;
2448: END IF;
2449:
2450: END IF;

Line 2456: IF l_quantity_tbl(k_index) = FND_API.G_MISS_NUM THEN

2452: /* Bug Fix 5505113
2453: As per the B n F team request started overriding the miss num with NULL.
2454:
2455: */
2456: IF l_quantity_tbl(k_index) = FND_API.G_MISS_NUM THEN
2457: l_quantity_tbl(k_index) := NULL;
2458: END IF;
2459:
2460: END IF;

Line 2528: x_return_status := FND_API.G_RET_STS_ERROR;

2524: END IF;
2525: END IF;
2526: -- Bug 3937017 Moved Close cursor
2527: CLOSE c_unique_res_check;
2528: x_return_status := FND_API.G_RET_STS_ERROR;
2529: RAISE FND_API.G_EXC_ERROR;
2530: END IF;
2531: Close c_unique_res_check;
2532: ELSE

Line 2529: RAISE FND_API.G_EXC_ERROR;

2525: END IF;
2526: -- Bug 3937017 Moved Close cursor
2527: CLOSE c_unique_res_check;
2528: x_return_status := FND_API.G_RET_STS_ERROR;
2529: RAISE FND_API.G_EXC_ERROR;
2530: END IF;
2531: Close c_unique_res_check;
2532: ELSE
2533: open c_unique_res_check_for_cbs( l_struct_elem_version_id,

Line 2557: x_return_status := FND_API.G_RET_STS_ERROR;

2553: );
2554: END IF;
2555:
2556: CLOSE c_unique_res_check_for_cbs;
2557: x_return_status := FND_API.G_RET_STS_ERROR;
2558: RAISE FND_API.G_EXC_ERROR;
2559: END IF;
2560: Close c_unique_res_check_for_cbs;
2561:

Line 2558: RAISE FND_API.G_EXC_ERROR;

2554: END IF;
2555:
2556: CLOSE c_unique_res_check_for_cbs;
2557: x_return_status := FND_API.G_RET_STS_ERROR;
2558: RAISE FND_API.G_EXC_ERROR;
2559: END IF;
2560: Close c_unique_res_check_for_cbs;
2561:
2562:

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

2882: pa_debug.g_err_stage:='Return status after add planning transactions.' ||x_return_status;
2883: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
2884: END IF;
2885:
2886: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2888: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2889: RAISE FND_API.G_EXC_ERROR;
2890: END IF;

Line 2887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2883: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
2884: END IF;
2885:
2886: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2888: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2889: RAISE FND_API.G_EXC_ERROR;
2890: END IF;
2891:

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

2884: END IF;
2885:
2886: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2888: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2889: RAISE FND_API.G_EXC_ERROR;
2890: END IF;
2891:
2892: END IF; --k_index for add planning transactions...

Line 2889: RAISE FND_API.G_EXC_ERROR;

2885:
2886: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2888: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2889: RAISE FND_API.G_EXC_ERROR;
2890: END IF;
2891:
2892: END IF; --k_index for add planning transactions...
2893:

Line 2983: IF FND_API.to_boolean( p_commit ) THEN

2979:
2980: --dbms_output.put_line('End of Create Task Assignments:');
2981:
2982:
2983: IF FND_API.to_boolean( p_commit ) THEN
2984: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2985: pa_debug.g_err_stage:='COMMIT done in Create Task Assignments';
2986: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
2987: END IF;

Line 2993: WHEN FND_API.G_EXC_ERROR

2989: END IF;
2990:
2991: EXCEPTION
2992:
2993: WHEN FND_API.G_EXC_ERROR
2994: THEN
2995: ROLLBACK TO add_task_asgmts_pub;
2996: IF P_DEBUG_MODE = 'Y' THEN
2997: PA_DEBUG.write_log (x_module => G_PKG_NAME

Line 3001: x_return_status := FND_API.G_RET_STS_ERROR;

2997: PA_DEBUG.write_log (x_module => G_PKG_NAME
2998: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
2999: ,x_log_level => 5);
3000: END IF;
3001: x_return_status := FND_API.G_RET_STS_ERROR;
3002:
3003: FND_MSG_PUB.Count_And_Get
3004: ( p_count => x_msg_count ,
3005: p_data => x_msg_data );

Line 3007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3003: FND_MSG_PUB.Count_And_Get
3004: ( p_count => x_msg_count ,
3005: p_data => x_msg_data );
3006:
3007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3008: THEN
3009: ROLLBACK TO add_task_asgmts_pub;
3010:
3011: IF P_DEBUG_MODE = 'Y' THEN

Line 3016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3012: PA_DEBUG.write_log (x_module => G_PKG_NAME
3013: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3014: ,x_log_level => 5);
3015: END IF;
3016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3017:
3018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3019: THEN
3020: FND_MSG_PUB.add_exc_msg

Line 3042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3038: PA_DEBUG.write_log (x_module => G_PKG_NAME
3039: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3040: ,x_log_level => 5);
3041: END IF;
3042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3043:
3044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3045: THEN
3046: FND_MSG_PUB.add_exc_msg

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

3058:
3059:
3060: PROCEDURE Create_Task_Assignment_Periods
3061: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3063: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3064: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3065: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3066: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

3059:
3060: PROCEDURE Create_Task_Assignment_Periods
3061: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3063: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3064: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3065: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3066: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3067: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 3112: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,

3108: SAVEPOINT CREATE_TASK_ASGMT_PERIODS;
3109:
3110: -- Standard call to check for call compatibility.
3111:
3112: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,
3113: p_api_version_number,
3114: l_api_name,
3115: G_PKG_NAME )
3116: THEN

Line 3117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3113: p_api_version_number,
3114: l_api_name,
3115: G_PKG_NAME )
3116: THEN
3117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3118: END IF;
3119:
3120:
3121: -- Initialize the message table if requested.

Line 3123: IF FND_API.TO_BOOLEAN( p_init_msg_list )

3119:
3120:
3121: -- Initialize the message table if requested.
3122:
3123: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3124: THEN
3125: FND_MSG_PUB.initialize;
3126: END IF;
3127:

Line 3129: x_return_status := FND_API.G_RET_STS_SUCCESS;

3125: FND_MSG_PUB.initialize;
3126: END IF;
3127:
3128: -- Set API return status to success
3129: x_return_status := FND_API.G_RET_STS_SUCCESS;
3130:
3131: -- Added for bug 5469303
3132: IF p_pa_structure_version_id IS NOT NULL AND (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3133: l_struct_elem_version_id := p_pa_structure_version_id;

Line 3150: RAISE FND_API.G_EXC_ERROR;

3146: ,p_attribute3 => ''
3147: ,p_attribute4 => ''
3148: ,p_attribute5 => '');
3149: END IF;
3150: RAISE FND_API.G_EXC_ERROR;
3151: END IF;
3152:
3153: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);
3154: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;

Line 3163: x_return_status := FND_API.G_RET_STS_ERROR;

3159: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
3160: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3161: );
3162: END IF;
3163: x_return_status := FND_API.G_RET_STS_ERROR;
3164: RAISE FND_API.G_EXC_ERROR;
3165: END IF;
3166:
3167: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 3164: RAISE FND_API.G_EXC_ERROR;

3160: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3161: );
3162: END IF;
3163: x_return_status := FND_API.G_RET_STS_ERROR;
3164: RAISE FND_API.G_EXC_ERROR;
3165: END IF;
3166:
3167: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
3168: pa_debug.g_err_stage:=' budget version id: ' || l_budget_version_id ;

Line 3189: ,p_commit => FND_API.G_FALSE

3185: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N';
3186:
3187: Create_Task_Assignments
3188: ( p_api_version_number => 1.0
3189: ,p_commit => FND_API.G_FALSE
3190: ,p_init_msg_list => FND_API.G_FALSE
3191: ,p_pm_product_code => p_pm_product_code
3192: ,p_pm_project_reference => p_pm_project_reference
3193: ,p_pa_project_id => p_pa_project_id

Line 3190: ,p_init_msg_list => FND_API.G_FALSE

3186:
3187: Create_Task_Assignments
3188: ( p_api_version_number => 1.0
3189: ,p_commit => FND_API.G_FALSE
3190: ,p_init_msg_list => FND_API.G_FALSE
3191: ,p_pm_product_code => p_pm_product_code
3192: ,p_pm_project_reference => p_pm_project_reference
3193: ,p_pa_project_id => p_pa_project_id
3194: ,p_pa_structure_version_id => p_pa_structure_version_id

Line 3207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3203: g_periodic_mode := null;
3204: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
3205:
3206: --dbms_output.put_line('After Create_Task_Assignments:return status: ' || l_return_status);
3207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3208:
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210:
3211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3205:
3206: --dbms_output.put_line('After Create_Task_Assignments:return status: ' || l_return_status);
3207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3208:
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210:
3211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3212:
3213: RAISE FND_API.G_EXC_ERROR;

Line 3211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3208:
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210:
3211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3212:
3213: RAISE FND_API.G_EXC_ERROR;
3214:
3215: END IF;

Line 3213: RAISE FND_API.G_EXC_ERROR;

3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210:
3211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3212:
3213: RAISE FND_API.G_EXC_ERROR;
3214:
3215: END IF;
3216:
3217: END IF;

Line 3228: ,p_commit => FND_API.G_FALSE

3224: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N';
3225:
3226: Pa_Task_Assignments_pvt.Create_Task_Assignment_Periods
3227: ( p_api_version_number => 1.0
3228: ,p_commit => FND_API.G_FALSE
3229: ,p_init_msg_list => FND_API.G_FALSE
3230: ,p_pm_product_code => p_pm_product_code
3231: ,p_pm_project_reference => p_pm_project_reference
3232: ,p_pa_project_id => p_pa_project_id

Line 3229: ,p_init_msg_list => FND_API.G_FALSE

3225:
3226: Pa_Task_Assignments_pvt.Create_Task_Assignment_Periods
3227: ( p_api_version_number => 1.0
3228: ,p_commit => FND_API.G_FALSE
3229: ,p_init_msg_list => FND_API.G_FALSE
3230: ,p_pm_product_code => p_pm_product_code
3231: ,p_pm_project_reference => p_pm_project_reference
3232: ,p_pa_project_id => p_pa_project_id
3233: ,p_pa_structure_version_id => p_pa_structure_version_id

Line 3244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3240:
3241: -- Bug 4200146
3242: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
3243:
3244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3245:
3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3247:
3248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3242: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
3243:
3244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3245:
3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3247:
3248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3249:
3250: RAISE FND_API.G_EXC_ERROR;

Line 3248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3244: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3245:
3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3247:
3248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3249:
3250: RAISE FND_API.G_EXC_ERROR;
3251:
3252: END IF;

Line 3250: RAISE FND_API.G_EXC_ERROR;

3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3247:
3248: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3249:
3250: RAISE FND_API.G_EXC_ERROR;
3251:
3252: END IF;
3253:
3254: END IF;

Line 3263: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3259: x_msg_code => l_msg_code,
3260: x_return_status => l_return_status);
3261:
3262:
3263: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;

Line 3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3260: x_return_status => l_return_status);
3261:
3262:
3263: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;
3268:

Line 3265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3261:
3262:
3263: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;
3268:
3269: END IF;

Line 3266: RAISE FND_API.G_EXC_ERROR;

3262:
3263: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3266: RAISE FND_API.G_EXC_ERROR;
3267: END IF;
3268:
3269: END IF;
3270:

Line 3271: IF FND_API.to_boolean( p_commit ) THEN

3267: END IF;
3268:
3269: END IF;
3270:
3271: IF FND_API.to_boolean( p_commit ) THEN
3272: COMMIT;
3273: END IF;
3274: --dbms_output.put_line('End of Create_Task_Assignment_Periods return status: ' || l_return_status);
3275:

Line 3278: WHEN FND_API.G_EXC_ERROR

3274: --dbms_output.put_line('End of Create_Task_Assignment_Periods return status: ' || l_return_status);
3275:
3276: EXCEPTION
3277:
3278: WHEN FND_API.G_EXC_ERROR
3279: THEN
3280: ROLLBACK TO CREATE_TASK_ASGMT_PERIODS;
3281:
3282: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3282: x_return_status := FND_API.G_RET_STS_ERROR;

3278: WHEN FND_API.G_EXC_ERROR
3279: THEN
3280: ROLLBACK TO CREATE_TASK_ASGMT_PERIODS;
3281:
3282: x_return_status := FND_API.G_RET_STS_ERROR;
3283: IF P_DEBUG_MODE = 'Y' THEN
3284: PA_DEBUG.write_log (x_module => G_PKG_NAME
3285: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
3286: ,x_log_level => 5);

Line 3292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3288: FND_MSG_PUB.Count_And_Get
3289: ( p_count => x_msg_count ,
3290: p_data => x_msg_data );
3291:
3292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3293: THEN
3294: ROLLBACK TO CREATE_TASK_ASGMT_PERIODS;
3295:
3296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3293: THEN
3294: ROLLBACK TO CREATE_TASK_ASGMT_PERIODS;
3295:
3296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3297: IF P_DEBUG_MODE = 'Y' THEN
3298: PA_DEBUG.write_log (x_module => G_PKG_NAME
3299: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3300: ,x_log_level => 5);

Line 3313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3309: -- Bug 4200146
3310: g_periodic_mode := null;
3311: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
3312:
3313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3314: IF P_DEBUG_MODE = 'Y' THEN
3315: PA_DEBUG.write_log (x_module => G_PKG_NAME
3316: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3317: ,x_log_level => 5);

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

3332:
3333:
3334: PROCEDURE Update_Task_Assignment_Periods
3335: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3336: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3338: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3339: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3340: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

3333:
3334: PROCEDURE Update_Task_Assignment_Periods
3335: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3336: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3338: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3339: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3340: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3341: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 3386: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,

3382: SAVEPOINT UPDATE_TASK_ASGMT_PERIODS;
3383:
3384: -- Standard call to check for call compatibility.
3385:
3386: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,
3387: p_api_version_number,
3388: l_api_name,
3389: G_PKG_NAME )
3390: THEN

Line 3391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3387: p_api_version_number,
3388: l_api_name,
3389: G_PKG_NAME )
3390: THEN
3391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3392: END IF;
3393:
3394: -- Initialize the message table if requested.
3395:

Line 3396: IF FND_API.TO_BOOLEAN( p_init_msg_list )

3392: END IF;
3393:
3394: -- Initialize the message table if requested.
3395:
3396: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3397: THEN
3398: FND_MSG_PUB.initialize;
3399: END IF;
3400:

Line 3405: x_return_status := FND_API.G_RET_STS_SUCCESS;

3401:
3402:
3403: -- Set API return status to success
3404:
3405: x_return_status := FND_API.G_RET_STS_SUCCESS;
3406:
3407: -- Added for bug 5469303
3408: IF p_pa_structure_version_id IS NOT NULL AND (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3409: l_struct_elem_version_id := p_pa_structure_version_id;

Line 3426: RAISE FND_API.G_EXC_ERROR;

3422: ,p_attribute3 => ''
3423: ,p_attribute4 => ''
3424: ,p_attribute5 => '');
3425: END IF;
3426: RAISE FND_API.G_EXC_ERROR;
3427: END IF;
3428:
3429:
3430: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);

Line 3440: x_return_status := FND_API.G_RET_STS_ERROR;

3436: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
3437: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3438: );
3439: END IF;
3440: x_return_status := FND_API.G_RET_STS_ERROR;
3441: RAISE FND_API.G_EXC_ERROR;
3442:
3443: END IF;
3444:

Line 3441: RAISE FND_API.G_EXC_ERROR;

3437: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3438: );
3439: END IF;
3440: x_return_status := FND_API.G_RET_STS_ERROR;
3441: RAISE FND_API.G_EXC_ERROR;
3442:
3443: END IF;
3444:
3445: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 3466: ,p_commit => FND_API.G_FALSE

3462: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N';
3463:
3464: Update_Task_Assignments
3465: ( p_api_version_number => 1.0
3466: ,p_commit => FND_API.G_FALSE
3467: ,p_init_msg_list => FND_API.G_FALSE
3468: ,p_pm_product_code => p_pm_product_code
3469: ,p_pm_project_reference => p_pm_project_reference
3470: ,p_pa_project_id => p_pa_project_id

Line 3467: ,p_init_msg_list => FND_API.G_FALSE

3463:
3464: Update_Task_Assignments
3465: ( p_api_version_number => 1.0
3466: ,p_commit => FND_API.G_FALSE
3467: ,p_init_msg_list => FND_API.G_FALSE
3468: ,p_pm_product_code => p_pm_product_code
3469: ,p_pm_project_reference => p_pm_project_reference
3470: ,p_pa_project_id => p_pa_project_id
3471: ,p_pa_structure_version_id => p_pa_structure_version_id

Line 3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3479: -- Bug 4200146
3480: g_periodic_mode := null;
3481: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
3482:
3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3484:
3485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3486:
3487: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3481: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
3482:
3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3484:
3485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3486:
3487: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3488:
3489: RAISE FND_API.G_EXC_ERROR;

Line 3487: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3484:
3485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3486:
3487: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3488:
3489: RAISE FND_API.G_EXC_ERROR;
3490:
3491: END IF;

Line 3489: RAISE FND_API.G_EXC_ERROR;

3485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3486:
3487: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3488:
3489: RAISE FND_API.G_EXC_ERROR;
3490:
3491: END IF;
3492:
3493: END IF;

Line 3504: ,p_commit => FND_API.G_FALSE

3500: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N';
3501:
3502: Pa_Task_Assignments_pvt.Create_Task_Assignment_Periods
3503: ( p_api_version_number => 1.0
3504: ,p_commit => FND_API.G_FALSE
3505: ,p_init_msg_list => FND_API.G_FALSE
3506: ,p_pm_product_code => p_pm_product_code
3507: ,p_pm_project_reference => p_pm_project_reference
3508: ,p_pa_project_id => p_pa_project_id

Line 3505: ,p_init_msg_list => FND_API.G_FALSE

3501:
3502: Pa_Task_Assignments_pvt.Create_Task_Assignment_Periods
3503: ( p_api_version_number => 1.0
3504: ,p_commit => FND_API.G_FALSE
3505: ,p_init_msg_list => FND_API.G_FALSE
3506: ,p_pm_product_code => p_pm_product_code
3507: ,p_pm_project_reference => p_pm_project_reference
3508: ,p_pa_project_id => p_pa_project_id
3509: ,p_pa_structure_version_id => p_pa_structure_version_id

Line 3520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3516:
3517: -- Bug 4200146
3518: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
3519:
3520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3521:
3522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3523:
3524: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3518: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
3519:
3520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3521:
3522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3523:
3524: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3525:
3526: RAISE FND_API.G_EXC_ERROR;

Line 3524: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3521:
3522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3523:
3524: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3525:
3526: RAISE FND_API.G_EXC_ERROR;
3527:
3528: END IF;

Line 3526: RAISE FND_API.G_EXC_ERROR;

3522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3523:
3524: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3525:
3526: RAISE FND_API.G_EXC_ERROR;
3527:
3528: END IF;
3529:
3530: END IF;

Line 3539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3535: x_msg_code => l_msg_code,
3536: x_return_status => l_return_status);
3537:
3538:
3539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3542: RAISE FND_API.G_EXC_ERROR;
3543: END IF;

Line 3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3536: x_return_status => l_return_status);
3537:
3538:
3539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3542: RAISE FND_API.G_EXC_ERROR;
3543: END IF;
3544:

Line 3541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3537:
3538:
3539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3542: RAISE FND_API.G_EXC_ERROR;
3543: END IF;
3544:
3545: END IF;

Line 3542: RAISE FND_API.G_EXC_ERROR;

3538:
3539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3542: RAISE FND_API.G_EXC_ERROR;
3543: END IF;
3544:
3545: END IF;
3546:

Line 3549: IF FND_API.to_boolean( p_commit ) THEN

3545: END IF;
3546:
3547:
3548:
3549: IF FND_API.to_boolean( p_commit ) THEN
3550: COMMIT;
3551: END IF;
3552:
3553:

Line 3556: WHEN FND_API.G_EXC_ERROR

3552:
3553:
3554: EXCEPTION
3555:
3556: WHEN FND_API.G_EXC_ERROR
3557: THEN
3558: ROLLBACK TO UPDATE_TASK_ASGMT_PERIODS;
3559:
3560: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3560: x_return_status := FND_API.G_RET_STS_ERROR;

3556: WHEN FND_API.G_EXC_ERROR
3557: THEN
3558: ROLLBACK TO UPDATE_TASK_ASGMT_PERIODS;
3559:
3560: x_return_status := FND_API.G_RET_STS_ERROR;
3561: IF P_DEBUG_MODE = 'Y' THEN
3562: PA_DEBUG.write_log (x_module => G_PKG_NAME
3563: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
3564: ,x_log_level => 5);

Line 3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3566: FND_MSG_PUB.Count_And_Get
3567: ( p_count => x_msg_count ,
3568: p_data => x_msg_data );
3569:
3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3571: THEN
3572: ROLLBACK TO UPDATE_TASK_ASGMT_PERIODS;
3573:
3574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3571: THEN
3572: ROLLBACK TO UPDATE_TASK_ASGMT_PERIODS;
3573:
3574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3575: IF P_DEBUG_MODE = 'Y' THEN
3576: PA_DEBUG.write_log (x_module => G_PKG_NAME
3577: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3578: ,x_log_level => 5);

Line 3591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3587: -- Bug 4200146: Reset the masks
3588: g_periodic_mode := null;
3589: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
3590:
3591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3592: IF P_DEBUG_MODE = 'Y' THEN
3593: PA_DEBUG.write_log (x_module => G_PKG_NAME
3594: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3595: ,x_log_level => 5);

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

3609:
3610:
3611: PROCEDURE Delete_Task_Assignments
3612: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3613: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3614: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3615: --Either project reference or project id is required
3616: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3617: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

3610:
3611: PROCEDURE Delete_Task_Assignments
3612: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3613: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3614: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3615: --Either project reference or project id is required
3616: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3617: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3618: --Structure version id is required

Line 3655: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,

3651: SAVEPOINT Delete_Task_Assignments;
3652:
3653: -- Standard call to check for call compatibility.
3654:
3655: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,
3656: p_api_version_number,
3657: l_api_name,
3658: G_PKG_NAME )
3659: THEN

Line 3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3656: p_api_version_number,
3657: l_api_name,
3658: G_PKG_NAME )
3659: THEN
3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3661: END IF;
3662:
3663:
3664: -- Initialize the message table if requested.

Line 3666: IF FND_API.TO_BOOLEAN( p_init_msg_list )

3662:
3663:
3664: -- Initialize the message table if requested.
3665:
3666: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3667: THEN
3668: FND_MSG_PUB.initialize;
3669: END IF;
3670:

Line 3675: x_return_status := FND_API.G_RET_STS_SUCCESS;

3671:
3672:
3673: -- Set API return status to success
3674:
3675: x_return_status := FND_API.G_RET_STS_SUCCESS;
3676:
3677:
3678: IF nvl(p_task_assignments_in.COUNT, 0) > 0 THEN
3679:

Line 3690: ,p_commit => FND_API.G_FALSE

3686: END LOOP;
3687: --dbms_output.put_line('From Delete_Task_Assignments calling Update_Task_Assignments' );
3688: Update_Task_Assignments
3689: ( p_api_version_number => 1.0
3690: ,p_commit => FND_API.G_FALSE
3691: ,p_init_msg_list => FND_API.G_FALSE
3692: ,p_pm_product_code => l_pm_product_code
3693: ,p_pm_project_reference => p_pm_project_reference
3694: ,p_pa_project_id => p_pa_project_id

Line 3691: ,p_init_msg_list => FND_API.G_FALSE

3687: --dbms_output.put_line('From Delete_Task_Assignments calling Update_Task_Assignments' );
3688: Update_Task_Assignments
3689: ( p_api_version_number => 1.0
3690: ,p_commit => FND_API.G_FALSE
3691: ,p_init_msg_list => FND_API.G_FALSE
3692: ,p_pm_product_code => l_pm_product_code
3693: ,p_pm_project_reference => p_pm_project_reference
3694: ,p_pa_project_id => p_pa_project_id
3695: ,p_pa_structure_version_id => p_pa_structure_version_id

Line 3703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3699: ,x_msg_data => l_msg_data
3700: ,x_return_status => l_return_status
3701: );
3702:
3703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3704:
3705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3706:
3707: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3701: );
3702:
3703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3704:
3705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3706:
3707: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3708:
3709: RAISE FND_API.G_EXC_ERROR;

Line 3707: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3704:
3705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3706:
3707: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3708:
3709: RAISE FND_API.G_EXC_ERROR;
3710:
3711: END IF;

Line 3709: RAISE FND_API.G_EXC_ERROR;

3705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3706:
3707: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3708:
3709: RAISE FND_API.G_EXC_ERROR;
3710:
3711: END IF;
3712:
3713: END IF;

Line 3716: IF FND_API.to_boolean( p_commit ) THEN

3712:
3713: END IF;
3714:
3715:
3716: IF FND_API.to_boolean( p_commit ) THEN
3717: COMMIT;
3718: END IF;
3719:
3720: EXCEPTION

Line 3722: WHEN FND_API.G_EXC_ERROR

3718: END IF;
3719:
3720: EXCEPTION
3721:
3722: WHEN FND_API.G_EXC_ERROR
3723: THEN
3724: ROLLBACK TO Delete_Task_Assignments;
3725:
3726: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3726: x_return_status := FND_API.G_RET_STS_ERROR;

3722: WHEN FND_API.G_EXC_ERROR
3723: THEN
3724: ROLLBACK TO Delete_Task_Assignments;
3725:
3726: x_return_status := FND_API.G_RET_STS_ERROR;
3727: IF P_DEBUG_MODE = 'Y' THEN
3728: PA_DEBUG.write_log (x_module => G_PKG_NAME
3729: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
3730: ,x_log_level => 5);

Line 3736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3732: FND_MSG_PUB.Count_And_Get
3733: ( p_count => x_msg_count ,
3734: p_data => x_msg_data );
3735:
3736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3737: THEN
3738: ROLLBACK TO Delete_Task_Assignments;
3739:
3740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3737: THEN
3738: ROLLBACK TO Delete_Task_Assignments;
3739:
3740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3741: IF P_DEBUG_MODE = 'Y' THEN
3742: PA_DEBUG.write_log (x_module => G_PKG_NAME
3743: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3744: ,x_log_level => 5);

Line 3753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3749:
3750: WHEN OTHERS THEN
3751: ROLLBACK TO Delete_Task_Assignments;
3752:
3753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3754: IF P_DEBUG_MODE = 'Y' THEN
3755: PA_DEBUG.write_log (x_module => G_PKG_NAME
3756: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
3757: ,x_log_level => 5);

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

3772:
3773:
3774: PROCEDURE Update_Task_Assignments
3775: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3776: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3777: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3778: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3779: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

3773:
3774: PROCEDURE Update_Task_Assignments
3775: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3776: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3777: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3778: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3779: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3781: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4302: IF NOT FND_API.Compatible_API_Call ( 1.0, --pa_project_pub.g_api_version_number ,

4298: SAVEPOINT UPDATE_task_asgmts_pub;
4299:
4300: -- Standard call to check for call compatibility.
4301:
4302: IF NOT FND_API.Compatible_API_Call ( 1.0, --pa_project_pub.g_api_version_number ,
4303: p_api_version_number ,
4304: l_api_name ,
4305: G_PKG_NAME )
4306: THEN

Line 4308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4304: l_api_name ,
4305: G_PKG_NAME )
4306: THEN
4307:
4308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4309:
4310: END IF;
4311:
4312: -- Initialize the message table if requested.

Line 4314: IF FND_API.TO_BOOLEAN( p_init_msg_list )

4310: END IF;
4311:
4312: -- Initialize the message table if requested.
4313:
4314: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4315: THEN
4316:
4317: FND_MSG_PUB.initialize;
4318:

Line 4325: x_return_status := FND_API.G_RET_STS_SUCCESS;

4321: --dbms_output.put_line('Update Task Asgmts.: API Comp. checked.');
4322:
4323: -- Set API return status to success
4324:
4325: x_return_status := FND_API.G_RET_STS_SUCCESS;
4326:
4327: -- Initialize the message table if requested.
4328: -- pm_product_code is mandatory
4329:

Line 4352: RAISE FND_API.G_EXC_ERROR;

4348: ,p_attribute3 => ''
4349: ,p_attribute4 => ''
4350: ,p_attribute5 => '');
4351: END IF;
4352: RAISE FND_API.G_EXC_ERROR;
4353:
4354: END IF;
4355:
4356: --dbms_output.put_line('Update Task Asgmts.: Product Code checked.');

Line 4397: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4393: , p_out_project_id => l_project_id
4394: , p_return_status => l_return_status
4395: );
4396:
4397: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4398:
4399: --dbms_output.put_line('Project_id not successful ');
4400: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4401: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;

Line 4404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4400: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4401: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
4402: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4403: END IF;
4404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4405:
4406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4407:
4408: --dbms_output.put_line('Project_id conv. not successful ');

Line 4406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

4402: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4403: END IF;
4404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4405:
4406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4407:
4408: --dbms_output.put_line('Project_id conv. not successful ');
4409: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4410: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;

Line 4413: RAISE FND_API.G_EXC_ERROR;

4409: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4410: pa_debug.g_err_stage:=' Project ref to id check not successful.' || L_FuncProc;
4411: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4412: END IF;
4413: RAISE FND_API.G_EXC_ERROR;
4414:
4415: END IF;
4416: END IF;
4417:

Line 4452: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

4448: p_msg_data => l_msg_data,
4449: p_return_status => l_return_status,
4450: p_function_allowed => l_function_allowed);
4451:
4452: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4453: THEN
4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4455:
4456: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4450: p_function_allowed => l_function_allowed);
4451:
4452: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4453: THEN
4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4455:
4456: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4457: THEN
4458: RAISE FND_API.G_EXC_ERROR;

Line 4456: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

4452: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4453: THEN
4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4455:
4456: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4457: THEN
4458: RAISE FND_API.G_EXC_ERROR;
4459: END IF;
4460:

Line 4458: RAISE FND_API.G_EXC_ERROR;

4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4455:
4456: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4457: THEN
4458: RAISE FND_API.G_EXC_ERROR;
4459: END IF;
4460:
4461: IF l_function_allowed = 'N' THEN
4462: pa_interface_utils_pub.map_new_amg_msg

Line 4472: x_return_status := FND_API.G_RET_STS_ERROR;

4468: ,p_attribute2 => ''
4469: ,p_attribute3 => ''
4470: ,p_attribute4 => ''
4471: ,p_attribute5 => '');
4472: x_return_status := FND_API.G_RET_STS_ERROR;
4473: RAISE FND_API.G_EXC_ERROR;
4474: END IF;
4475:
4476: IF FND_API.TO_BOOLEAN( p_init_msg_list )

Line 4473: RAISE FND_API.G_EXC_ERROR;

4469: ,p_attribute3 => ''
4470: ,p_attribute4 => ''
4471: ,p_attribute5 => '');
4472: x_return_status := FND_API.G_RET_STS_ERROR;
4473: RAISE FND_API.G_EXC_ERROR;
4474: END IF;
4475:
4476: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4477: THEN

Line 4476: IF FND_API.TO_BOOLEAN( p_init_msg_list )

4472: x_return_status := FND_API.G_RET_STS_ERROR;
4473: RAISE FND_API.G_EXC_ERROR;
4474: END IF;
4475:
4476: IF FND_API.TO_BOOLEAN( p_init_msg_list )
4477: THEN
4478:
4479: FND_MSG_PUB.initialize;
4480:

Line 4488: x_return_status := FND_API.G_RET_STS_SUCCESS;

4484: --dbms_output.put_line('Update Task Asgmts.: Function Security checked.');
4485:
4486: -- Set API return status to success
4487:
4488: x_return_status := FND_API.G_RET_STS_SUCCESS;
4489:
4490:
4491: -- Now verify whether project security allows the user to update
4492: -- the project

Line 4514: x_return_status := FND_API.G_RET_STS_ERROR;

4510: ,p_attribute2 => ''
4511: ,p_attribute3 => ''
4512: ,p_attribute4 => ''
4513: ,p_attribute5 => '');
4514: x_return_status := FND_API.G_RET_STS_ERROR;
4515: RAISE FND_API.G_EXC_ERROR;
4516: END IF;
4517:
4518: --dbms_output.put_line('Update Task Asgmts.: Project Security checked for: ' || l_project_id);

Line 4515: RAISE FND_API.G_EXC_ERROR;

4511: ,p_attribute3 => ''
4512: ,p_attribute4 => ''
4513: ,p_attribute5 => '');
4514: x_return_status := FND_API.G_RET_STS_ERROR;
4515: RAISE FND_API.G_EXC_ERROR;
4516: END IF;
4517:
4518: --dbms_output.put_line('Update Task Asgmts.: Project Security checked for: ' || l_project_id);
4519:

Line 4542: RAISE FND_API.G_EXC_ERROR;

4538: ,p_attribute3 => ''
4539: ,p_attribute4 => ''
4540: ,p_attribute5 => '');
4541: END IF;
4542: RAISE FND_API.G_EXC_ERROR;
4543: END IF;
4544:
4545: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS Fine..');
4546: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4583: RAISE FND_API.G_EXC_ERROR;

4579: ,p_attribute3 => ''
4580: ,p_attribute4 => ''
4581: ,p_attribute5 => '');
4582: END IF;
4583: RAISE FND_API.G_EXC_ERROR;
4584: END IF;
4585:
4586:
4587: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4598: x_return_status := FND_API.G_RET_STS_ERROR;

4594: -- pa_task_assignments_pvt.lock_version(l_project_id, l_struct_elem_version_id);
4595:
4596: -- Bug 3940853: Raise locking error return from structure API
4597: IF FND_MSG_PUB.count_msg > 0 THEN
4598: x_return_status := FND_API.G_RET_STS_ERROR;
4599: RAISE FND_API.G_EXC_ERROR;
4600: END IF;
4601:
4602:

Line 4599: RAISE FND_API.G_EXC_ERROR;

4595:
4596: -- Bug 3940853: Raise locking error return from structure API
4597: IF FND_MSG_PUB.count_msg > 0 THEN
4598: x_return_status := FND_API.G_RET_STS_ERROR;
4599: RAISE FND_API.G_EXC_ERROR;
4600: END IF;
4601:
4602:
4603:

Line 4617: x_return_status := FND_API.G_RET_STS_ERROR;

4613: --PA_UTILS.ADD_MESSAGE
4614: -- (p_app_short_name => 'PA',
4615: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR'
4616: -- );
4617: x_return_status := FND_API.G_RET_STS_ERROR;
4618: RAISE FND_API.G_EXC_ERROR;
4619: END IF;
4620:
4621: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4618: RAISE FND_API.G_EXC_ERROR;

4614: -- (p_app_short_name => 'PA',
4615: -- p_msg_name => 'PA_UPDATE_PUB_VER_ERR'
4616: -- );
4617: x_return_status := FND_API.G_RET_STS_ERROR;
4618: RAISE FND_API.G_EXC_ERROR;
4619: END IF;
4620:
4621: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4622: pa_debug.g_err_stage:='Check edit task done';

Line 4638: x_return_status := FND_API.G_RET_STS_ERROR;

4634: (p_app_short_name => 'PA',
4635: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
4636: );
4637: END IF;
4638: x_return_status := FND_API.G_RET_STS_ERROR;
4639: RAISE FND_API.G_EXC_ERROR;
4640:
4641: END IF;
4642:

Line 4639: RAISE FND_API.G_EXC_ERROR;

4635: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
4636: );
4637: END IF;
4638: x_return_status := FND_API.G_RET_STS_ERROR;
4639: RAISE FND_API.G_EXC_ERROR;
4640:
4641: END IF;
4642:
4643: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4697: x_return_status := FND_API.G_RET_STS_ERROR;

4693: PA_UTILS.ADD_MESSAGE
4694: (p_app_short_name => 'PA',
4695: p_msg_name => 'PA_RES_LIST_NONE_ERR'
4696: );
4697: x_return_status := FND_API.G_RET_STS_ERROR;
4698: RAISE FND_API.G_EXC_ERROR;
4699: END IF;
4700: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4701: pa_debug.g_err_stage:='l_count'|| l_count;

Line 4698: RAISE FND_API.G_EXC_ERROR;

4694: (p_app_short_name => 'PA',
4695: p_msg_name => 'PA_RES_LIST_NONE_ERR'
4696: );
4697: x_return_status := FND_API.G_RET_STS_ERROR;
4698: RAISE FND_API.G_EXC_ERROR;
4699: END IF;
4700: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4701: pa_debug.g_err_stage:='l_count'|| l_count;
4702: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 4810: RAISE FND_API.G_EXC_ERROR;

4806: p_msg_name => 'PA_TASK_REQUIRED'
4807: );
4808: END IF;
4809:
4810: RAISE FND_API.G_EXC_ERROR;
4811: END IF;
4812:
4813:
4814:

Line 4852: RAISE FND_API.G_EXC_ERROR;

4848: p_msg_name => 'PA_TASK_REQUIRED'
4849: );
4850: END IF;
4851:
4852: RAISE FND_API.G_EXC_ERROR;
4853: END IF;
4854:
4855:
4856:

Line 4877: RAISE FND_API.G_EXC_ERROR;

4873: (p_app_short_name => 'PA',
4874: p_msg_name => 'PA_TASK_VERSION_REQUIRED'
4875: );
4876:
4877: RAISE FND_API.G_EXC_ERROR;
4878: END IF;
4879: END IF;
4880:
4881:

Line 4956: lp_resource_assignment_id_tbl(i) <> FND_API.G_MISS_NUM THEN

4952: -- Added below for Bug 8842724
4953: -- Making the task assignment id as null because for creation the task_assignment_id
4954: -- is always null. For update the task_assignment_id always exist.
4955: IF lp_resource_assignment_id_tbl(i) IS NOT NULL OR
4956: lp_resource_assignment_id_tbl(i) <> FND_API.G_MISS_NUM THEN
4957: l_task_assignments_in(i).pm_task_asgmt_reference := p_task_assignments_in(i).pm_task_asgmt_reference || to_char(sysdate,':DDMMYYHH24MISS') ;
4958: lp_resource_assignment_id_tbl(i) := null;
4959: END IF;
4960: -- End of Bug 8842724

Line 4995: x_return_status := FND_API.G_RET_STS_ERROR;

4991: x_msg_count => x_msg_count,
4992: x_msg_data => x_msg_data ) ;
4993:
4994: IF l_valid_member_flag = 'N' THEN
4995: x_return_status := FND_API.G_RET_STS_ERROR;
4996: RAISE FND_API.G_EXC_ERROR;
4997: END IF;
4998:
4999: ELSIF p_task_assignments_in(i).pa_task_assignment_id IS NULL AND

Line 4996: RAISE FND_API.G_EXC_ERROR;

4992: x_msg_data => x_msg_data ) ;
4993:
4994: IF l_valid_member_flag = 'N' THEN
4995: x_return_status := FND_API.G_RET_STS_ERROR;
4996: RAISE FND_API.G_EXC_ERROR;
4997: END IF;
4998:
4999: ELSIF p_task_assignments_in(i).pa_task_assignment_id IS NULL AND
5000: p_task_assignments_in(i).p_context <> 'D' AND

Line 5012: x_return_status := FND_API.G_RET_STS_ERROR;

5008: ,p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID_MSP'
5009: ,p_token1 => 'PLANNING_RESOURCE_NAME' -- Bug 6497559
5010: ,p_value1 => PA_TASK_UTILS.get_resource_name(p_task_assignments_in(i).resource_list_member_id)
5011: );
5012: x_return_status := FND_API.G_RET_STS_ERROR;
5013: RAISE FND_API.G_EXC_ERROR;
5014: ELSE
5015: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5016: ,p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID_AMG'

Line 5013: RAISE FND_API.G_EXC_ERROR;

5009: ,p_token1 => 'PLANNING_RESOURCE_NAME' -- Bug 6497559
5010: ,p_value1 => PA_TASK_UTILS.get_resource_name(p_task_assignments_in(i).resource_list_member_id)
5011: );
5012: x_return_status := FND_API.G_RET_STS_ERROR;
5013: RAISE FND_API.G_EXC_ERROR;
5014: ELSE
5015: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5016: ,p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID_AMG'
5017: ,p_token1 => 'PLANNING_RESOURCE_ID' -- Bug 6497559

Line 5020: x_return_status := FND_API.G_RET_STS_ERROR;

5016: ,p_msg_name => 'PA_INVALID_RES_LIST_MEM_ID_AMG'
5017: ,p_token1 => 'PLANNING_RESOURCE_ID' -- Bug 6497559
5018: ,p_value1 => p_task_assignments_in(i).resource_list_member_id
5019: );
5020: x_return_status := FND_API.G_RET_STS_ERROR;
5021: RAISE FND_API.G_EXC_ERROR;
5022: END IF;
5023: END IF;
5024: END IF;

Line 5021: RAISE FND_API.G_EXC_ERROR;

5017: ,p_token1 => 'PLANNING_RESOURCE_ID' -- Bug 6497559
5018: ,p_value1 => p_task_assignments_in(i).resource_list_member_id
5019: );
5020: x_return_status := FND_API.G_RET_STS_ERROR;
5021: RAISE FND_API.G_EXC_ERROR;
5022: END IF;
5023: END IF;
5024: END IF;
5025:

Line 5044: x_return_status := FND_API.G_RET_STS_ERROR;

5040: IF x_return_status <> 'S' THEN
5041: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5042: ,p_msg_name => x_msg_data
5043: );
5044: x_return_status := FND_API.G_RET_STS_ERROR;
5045: RAISE FND_API.G_EXC_ERROR;
5046: END IF;
5047:
5048: ELSE

Line 5045: RAISE FND_API.G_EXC_ERROR;

5041: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5042: ,p_msg_name => x_msg_data
5043: );
5044: x_return_status := FND_API.G_RET_STS_ERROR;
5045: RAISE FND_API.G_EXC_ERROR;
5046: END IF;
5047:
5048: ELSE
5049: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 5054: x_return_status := FND_API.G_RET_STS_ERROR;

5050: ,p_msg_name => 'PA_CBS_WP__COST_CODE_MNDTR'
5051: ,p_token1 => 'RES_NAME'
5052: ,p_value1 => PA_TASK_UTILS.get_resource_name(p_task_assignments_in(i).resource_list_member_id)
5053: );
5054: x_return_status := FND_API.G_RET_STS_ERROR;
5055: RAISE FND_API.G_EXC_ERROR;
5056:
5057: END IF;
5058:

Line 5055: RAISE FND_API.G_EXC_ERROR;

5051: ,p_token1 => 'RES_NAME'
5052: ,p_value1 => PA_TASK_UTILS.get_resource_name(p_task_assignments_in(i).resource_list_member_id)
5053: );
5054: x_return_status := FND_API.G_RET_STS_ERROR;
5055: RAISE FND_API.G_EXC_ERROR;
5056:
5057: END IF;
5058:
5059: END IF;

Line 5082: x_return_status := FND_API.G_RET_STS_ERROR;

5078: ,p_value1 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
5079: ,p_token2 => 'TASK_NUMBER'
5080: ,p_value2 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
5081: );
5082: x_return_status := FND_API.G_RET_STS_ERROR;
5083: RAISE FND_API.G_EXC_ERROR;
5084: ELSE
5085: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5086: ,p_msg_name => 'PA_INVALID_DATES_AMG'

Line 5083: RAISE FND_API.G_EXC_ERROR;

5079: ,p_token2 => 'TASK_NUMBER'
5080: ,p_value2 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
5081: );
5082: x_return_status := FND_API.G_RET_STS_ERROR;
5083: RAISE FND_API.G_EXC_ERROR;
5084: ELSE
5085: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5086: ,p_msg_name => 'PA_INVALID_DATES_AMG'
5087: ,p_token1 => 'TASK_ID' -- Bug 6497559

Line 5090: x_return_status := FND_API.G_RET_STS_ERROR;

5086: ,p_msg_name => 'PA_INVALID_DATES_AMG'
5087: ,p_token1 => 'TASK_ID' -- Bug 6497559
5088: ,p_value1 => p_task_assignments_in(i).pa_task_id
5089: );
5090: x_return_status := FND_API.G_RET_STS_ERROR;
5091: RAISE FND_API.G_EXC_ERROR;
5092: END IF;
5093: END IF;
5094:

Line 5091: RAISE FND_API.G_EXC_ERROR;

5087: ,p_token1 => 'TASK_ID' -- Bug 6497559
5088: ,p_value1 => p_task_assignments_in(i).pa_task_id
5089: );
5090: x_return_status := FND_API.G_RET_STS_ERROR;
5091: RAISE FND_API.G_EXC_ERROR;
5092: END IF;
5093: END IF;
5094:
5095: END IF;

Line 5109: x_return_status := FND_API.G_RET_STS_ERROR;

5105: (p_app_short_name => 'PA',
5106: p_msg_name => 'PA_PM_TASK_ASGMT_REF_REQ'
5107: );
5108: END IF;
5109: x_return_status := FND_API.G_RET_STS_ERROR;
5110: RAISE FND_API.G_EXC_ERROR;
5111:
5112: END IF;
5113:

Line 5110: RAISE FND_API.G_EXC_ERROR;

5106: p_msg_name => 'PA_PM_TASK_ASGMT_REF_REQ'
5107: );
5108: END IF;
5109: x_return_status := FND_API.G_RET_STS_ERROR;
5110: RAISE FND_API.G_EXC_ERROR;
5111:
5112: END IF;
5113:
5114: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 5135: RAISE FND_API.G_EXC_ERROR;

5131: ,p_attribute3 => ''
5132: ,p_attribute4 => ''
5133: ,p_attribute5 => '');
5134: END IF;
5135: RAISE FND_API.G_EXC_ERROR;
5136: x_return_status := FND_API.G_RET_STS_SUCCESS;
5137:
5138: END IF;
5139:

Line 5136: x_return_status := FND_API.G_RET_STS_SUCCESS;

5132: ,p_attribute4 => ''
5133: ,p_attribute5 => '');
5134: END IF;
5135: RAISE FND_API.G_EXC_ERROR;
5136: x_return_status := FND_API.G_RET_STS_SUCCESS;
5137:
5138: END IF;
5139:
5140:

Line 5172: RAISE FND_API.G_EXC_ERROR;

5168: ,p_attribute4 => ''
5169: ,p_attribute5 => '');
5170: END IF;
5171: CLOSE C_currency_exists; --Bug 3937017
5172: RAISE FND_API.G_EXC_ERROR;
5173: END IF;
5174: CLOSE C_currency_exists;
5175:
5176: END IF;

Line 5252: x_return_status := FND_API.G_RET_STS_ERROR;

5248: ,p_token2 => 'TASK_NUMBER'
5249: ,p_value2 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
5250: );
5251:
5252: x_return_status := FND_API.G_RET_STS_ERROR;
5253: RAISE FND_API.G_EXC_ERROR;
5254: ELSE
5255: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5256: ,p_msg_name => 'PA_WEIGHTING_NOT_POSITIVE_AMG'

Line 5253: RAISE FND_API.G_EXC_ERROR;

5249: ,p_value2 => PA_TASK_UTILS.get_task_name(p_task_assignments_in(i).pa_task_id)
5250: );
5251:
5252: x_return_status := FND_API.G_RET_STS_ERROR;
5253: RAISE FND_API.G_EXC_ERROR;
5254: ELSE
5255: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
5256: ,p_msg_name => 'PA_WEIGHTING_NOT_POSITIVE_AMG'
5257: ,p_token1 => 'TASK_ID' -- Bug 6497559

Line 5261: x_return_status := FND_API.G_RET_STS_ERROR;

5257: ,p_token1 => 'TASK_ID' -- Bug 6497559
5258: ,p_value1 =>p_task_assignments_in(i).pa_task_id
5259: );
5260:
5261: x_return_status := FND_API.G_RET_STS_ERROR;
5262: RAISE FND_API.G_EXC_ERROR;
5263: END If;
5264: END IF;
5265:

Line 5262: RAISE FND_API.G_EXC_ERROR;

5258: ,p_value1 =>p_task_assignments_in(i).pa_task_id
5259: );
5260:
5261: x_return_status := FND_API.G_RET_STS_ERROR;
5262: RAISE FND_API.G_EXC_ERROR;
5263: END If;
5264: END IF;
5265:
5266: END IF;

Line 5320: RAISE FND_API.G_EXC_ERROR;

5316: ,p_attribute3 => ''
5317: ,p_attribute4 => ''
5318: ,p_attribute5 => '');
5319: END IF;
5320: RAISE FND_API.G_EXC_ERROR;
5321: END IF;
5322:
5323: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5324: pa_debug.g_err_stage:='Cost Type check passed.';

Line 5348: RAISE FND_API.G_EXC_ERROR;

5344: ,p_attribute3 => ''
5345: ,p_attribute4 => ''
5346: ,p_attribute5 => '');
5347: END IF;
5348: RAISE FND_API.G_EXC_ERROR;
5349: END IF;
5350:
5351: IF p_task_assignments_in(i).spread_curve_id IS NOT NULL AND
5352: p_task_assignments_in(i).spread_curve_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 5392: RAISE FND_API.G_EXC_ERROR;

5388: ,p_attribute3 => ''
5389: ,p_attribute4 => ''
5390: ,p_attribute5 => '');
5391: END IF;
5392: RAISE FND_API.G_EXC_ERROR;
5393: END IF;
5394:
5395: IF l_spread_curve_id is NOT NULL THEN
5396: OPEN C_Spread_Curve_Code(l_spread_curve_id);

Line 5418: RAISE FND_API.G_EXC_ERROR;

5414: ,p_attribute3 => ''
5415: ,p_attribute4 => ''
5416: ,p_attribute5 => '');
5417: END IF;
5418: RAISE FND_API.G_EXC_ERROR;
5419: END IF;
5420:
5421:
5422: IF l_spread_curve_code <> 'FIXED_DATE' and l_fixed_date <>

Line 5644: IF l_raw_cost_tbl(u_index) = FND_API.G_MISS_NUM THEN

5640: l_raw_cost_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_raw_cost) ;
5641: l_burdened_cost_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_bur_cost) ;
5642: /* Bug Fix 5505113
5643: */
5644: IF l_raw_cost_tbl(u_index) = FND_API.G_MISS_NUM THEN
5645: l_raw_cost_tbl(u_index) := NULL;
5646: END IF;
5647:
5648: IF l_burdened_cost_tbl(u_index) = FND_API.G_MISS_NUM THEN

Line 5648: IF l_burdened_cost_tbl(u_index) = FND_API.G_MISS_NUM THEN

5644: IF l_raw_cost_tbl(u_index) = FND_API.G_MISS_NUM THEN
5645: l_raw_cost_tbl(u_index) := NULL;
5646: END IF;
5647:
5648: IF l_burdened_cost_tbl(u_index) = FND_API.G_MISS_NUM THEN
5649: l_burdened_cost_tbl(u_index) := NULL;
5650: END IF;
5651:
5652: END IF;

Line 5656: IF l_quantity_tbl(u_index) = FND_API.G_MISS_NUM THEN

5652: END IF;
5653: l_quantity_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_quantity) ;
5654: /* Bug Fix 5505113
5655: */
5656: IF l_quantity_tbl(u_index) = FND_API.G_MISS_NUM THEN
5657: l_quantity_tbl(u_index) := NULL;
5658: END IF;
5659:
5660: END IF;

Line 5731: IF l_raw_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN

5727:
5728: l_burd_cost_rate_override_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).burd_cost_rate_override);
5729: /* Bug Fix 5505113
5730: */
5731: IF l_raw_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN
5732: l_raw_cost_rate_override_tbl(u_index) := NULL;
5733: END IF;
5734:
5735: IF l_burd_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN

Line 5735: IF l_burd_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN

5731: IF l_raw_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN
5732: l_raw_cost_rate_override_tbl(u_index) := NULL;
5733: END IF;
5734:
5735: IF l_burd_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN
5736: l_burd_cost_rate_override_tbl(u_index) := NULL;
5737: END IF;
5738:
5739: elsif C_Res_Asgmt_Data_Rec.rate_based_flag = 'N' AND C_Workplan_Costs_rec.enabled_flag = 'Y' THEN

Line 5745: IF l_burd_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN

5741:
5742: l_burd_cost_rate_override_tbl(u_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).burd_cost_rate_override);
5743: /* Bug Fix 5505113
5744: */
5745: IF l_burd_cost_rate_override_tbl(u_index) = FND_API.G_MISS_NUM THEN
5746: l_burd_cost_rate_override_tbl(u_index) := NULL;
5747: END IF;
5748:
5749: end if;

Line 5878: IF l_supplier_id_tbl(u_index) IS NOT NULL and l_supplier_id_tbl(u_index) <> FND_API.G_MISS_NUM THEN

5874: -- Bug 4246109: Should pass in supplier to update_planning_transaction
5875: l_supplier_id_tbl(u_index) := pa_task_assignments_pvt.pfnum(C_Res_Asgmt_Data_Rec.supplier_id);
5876:
5877: -- Bug 4528392:
5878: IF l_supplier_id_tbl(u_index) IS NOT NULL and l_supplier_id_tbl(u_index) <> FND_API.G_MISS_NUM THEN
5879: l_supplier_name_tbl(u_index) := pa_task_assignments_pvt.pfchar(pa_planning_resource_utils.ret_supplier_name(l_supplier_id_tbl(u_index)));
5880: ELSIF l_supplier_id_tbl(u_index) IS NULL THEN
5881: l_supplier_name_tbl(u_index) := NULL;
5882: ELSE

Line 5883: l_supplier_name_tbl(u_index) := FND_API.G_MISS_CHAR;

5879: l_supplier_name_tbl(u_index) := pa_task_assignments_pvt.pfchar(pa_planning_resource_utils.ret_supplier_name(l_supplier_id_tbl(u_index)));
5880: ELSIF l_supplier_id_tbl(u_index) IS NULL THEN
5881: l_supplier_name_tbl(u_index) := NULL;
5882: ELSE
5883: l_supplier_name_tbl(u_index) := FND_API.G_MISS_CHAR;
5884: END IF;
5885: -- End of Bug 4528392:
5886:
5887: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 5929: x_return_status := FND_API.G_RET_STS_ERROR;

5925: ,p_value2 => l_budget_version_id
5926: );
5927: END IF;
5928: CLOSE C_Reference_Check;--Bug 3937017
5929: x_return_status := FND_API.G_RET_STS_ERROR;
5930: RAISE FND_API.G_EXC_ERROR;
5931: END IF;
5932: Close C_Reference_Check;
5933: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 5930: RAISE FND_API.G_EXC_ERROR;

5926: );
5927: END IF;
5928: CLOSE C_Reference_Check;--Bug 3937017
5929: x_return_status := FND_API.G_RET_STS_ERROR;
5930: RAISE FND_API.G_EXC_ERROR;
5931: END IF;
5932: Close C_Reference_Check;
5933: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5934: pa_debug.g_err_stage:='pm_task_asgmt_reference is EXISTING check passed';

Line 6031: IF lc_raw_cost_tbl(c_index) = FND_API.G_MISS_NUM THEN

6027: lc_raw_cost_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_raw_cost) ;
6028: lc_burdened_cost_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_total_bur_cost) ;
6029: /* Bug Fix 5505113
6030: */
6031: IF lc_raw_cost_tbl(c_index) = FND_API.G_MISS_NUM THEN
6032: lc_raw_cost_tbl(c_index) := NULL;
6033: END IF;
6034:
6035: IF lc_burdened_cost_tbl(c_index) = FND_API.G_MISS_NUM THEN

Line 6035: IF lc_burdened_cost_tbl(c_index) = FND_API.G_MISS_NUM THEN

6031: IF lc_raw_cost_tbl(c_index) = FND_API.G_MISS_NUM THEN
6032: lc_raw_cost_tbl(c_index) := NULL;
6033: END IF;
6034:
6035: IF lc_burdened_cost_tbl(c_index) = FND_API.G_MISS_NUM THEN
6036: lc_burdened_cost_tbl(c_index) := NULL;
6037: END IF;
6038:
6039: END IF;

Line 6044: IF lc_quantity_tbl(c_index) = FND_API.G_MISS_NUM THEN

6040:
6041: lc_quantity_tbl(c_index) := pa_task_assignments_pvt.pfnum(p_task_assignments_in(i).planned_quantity);
6042: /* Bug Fix 5505113
6043: */
6044: IF lc_quantity_tbl(c_index) = FND_API.G_MISS_NUM THEN
6045: lc_quantity_tbl(c_index) := NULL;
6046: END IF;
6047:
6048: END IF;

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

6338: pa_debug.g_err_stage:='After Calling add planning transactions:ret. status' || x_return_status;
6339: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6340: END IF;
6341:
6342: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6344: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6345: RAISE FND_API.G_EXC_ERROR;
6346: END IF;

Line 6343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6339: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6340: END IF;
6341:
6342: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6344: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6345: RAISE FND_API.G_EXC_ERROR;
6346: END IF;
6347:

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

6340: END IF;
6341:
6342: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6344: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6345: RAISE FND_API.G_EXC_ERROR;
6346: END IF;
6347:
6348: END IF; -- IF c_index > 0 THEN

Line 6345: RAISE FND_API.G_EXC_ERROR;

6341:
6342: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6344: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6345: RAISE FND_API.G_EXC_ERROR;
6346: END IF;
6347:
6348: END IF; -- IF c_index > 0 THEN
6349:

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

6409: pa_debug.g_err_stage:='After Calling delete planning transactions:ret. status' || x_return_status;
6410: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6411: END IF;
6412:
6413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6416: RAISE FND_API.G_EXC_ERROR;
6417: END IF;

Line 6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6410: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6411: END IF;
6412:
6413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6416: RAISE FND_API.G_EXC_ERROR;
6417: END IF;
6418: END IF;

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

6411: END IF;
6412:
6413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6416: RAISE FND_API.G_EXC_ERROR;
6417: END IF;
6418: END IF;
6419:

Line 6416: RAISE FND_API.G_EXC_ERROR;

6412:
6413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6416: RAISE FND_API.G_EXC_ERROR;
6417: END IF;
6418: END IF;
6419:
6420:

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

6572: pa_debug.g_err_stage:='Return status after update planning transactions.' ||x_return_status;
6573: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6574: END IF;
6575:
6576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6579: RAISE FND_API.G_EXC_ERROR;
6580: END IF;

Line 6577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6573: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6574: END IF;
6575:
6576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6579: RAISE FND_API.G_EXC_ERROR;
6580: END IF;
6581: END IF;

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

6574: END IF;
6575:
6576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6579: RAISE FND_API.G_EXC_ERROR;
6580: END IF;
6581: END IF;
6582:

Line 6579: RAISE FND_API.G_EXC_ERROR;

6575:
6576: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6578: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6579: RAISE FND_API.G_EXC_ERROR;
6580: END IF;
6581: END IF;
6582:
6583:

Line 6675: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6671: x_msg_code => l_msg_code,
6672: x_return_status => l_return_status);
6673:
6674:
6675: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6677: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
6678: RAISE FND_API.G_EXC_ERROR;
6679: END IF;

Line 6676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6672: x_return_status => l_return_status);
6673:
6674:
6675: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6677: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
6678: RAISE FND_API.G_EXC_ERROR;
6679: END IF;
6680:

Line 6677: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

6673:
6674:
6675: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6677: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
6678: RAISE FND_API.G_EXC_ERROR;
6679: END IF;
6680:
6681: END IF;

Line 6678: RAISE FND_API.G_EXC_ERROR;

6674:
6675: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6677: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
6678: RAISE FND_API.G_EXC_ERROR;
6679: END IF;
6680:
6681: END IF;
6682:

Line 6683: IF FND_API.to_boolean( p_commit ) THEN

6679: END IF;
6680:
6681: END IF;
6682:
6683: IF FND_API.to_boolean( p_commit ) THEN
6684: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
6685: pa_debug.g_err_stage:='COMMIT done in Update Task Assignments';
6686: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
6687: END IF;

Line 6698: WHEN FND_API.G_EXC_ERROR

6694:
6695:
6696: EXCEPTION
6697:
6698: WHEN FND_API.G_EXC_ERROR
6699: THEN
6700: ROLLBACK TO UPDATE_task_asgmts_pub;
6701:
6702:

Line 6703: x_return_status := FND_API.G_RET_STS_ERROR;

6699: THEN
6700: ROLLBACK TO UPDATE_task_asgmts_pub;
6701:
6702:
6703: x_return_status := FND_API.G_RET_STS_ERROR;
6704: IF P_DEBUG_MODE = 'Y' THEN
6705: PA_DEBUG.write_log (x_module => G_PKG_NAME
6706: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
6707: ,x_log_level => 5);

Line 6714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

6710: FND_MSG_PUB.Count_And_Get
6711: ( p_count => x_msg_count ,
6712: p_data => x_msg_data );
6713:
6714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
6715: THEN
6716: ROLLBACK TO UPDATE_task_asgmts_pub;
6717:
6718:

Line 6719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6715: THEN
6716: ROLLBACK TO UPDATE_task_asgmts_pub;
6717:
6718:
6719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6720: IF P_DEBUG_MODE = 'Y' THEN
6721: PA_DEBUG.write_log (x_module => G_PKG_NAME
6722: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
6723: ,x_log_level => 5);

Line 6742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6738:
6739: -- Bug 4200146: Reset the mask.
6740: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
6741:
6742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6743: IF P_DEBUG_MODE = 'Y' THEN
6744: PA_DEBUG.write_log (x_module => G_PKG_NAME
6745: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
6746: ,x_log_level => 5);

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

6764:
6765:
6766: PROCEDURE Fetch_Task_Assignments
6767: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6768: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6769: ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6770: ,p_pm_task_asgmt_reference OUT NOCOPY pa_vc_1000_30
6771: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num
6772: ,p_pm_task_reference OUT NOCOPY pa_vc_1000_30

Line 6820: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,

6816: SAVEPOINT fetch_task_assignments_pub;
6817:
6818: -- Standard call to check for call compatibility.
6819:
6820: IF NOT FND_API.Compatible_API_Call ( 1.0, --g_api_version_number ,
6821: p_api_version_number ,
6822: l_api_name ,
6823: G_PKG_NAME )
6824: THEN

Line 6826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6822: l_api_name ,
6823: G_PKG_NAME )
6824: THEN
6825:
6826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6827:
6828: END IF;
6829:
6830: -- Initialize the message table if requested.

Line 6832: IF FND_API.TO_BOOLEAN( p_init_msg_list )

6828: END IF;
6829:
6830: -- Initialize the message table if requested.
6831:
6832: IF FND_API.TO_BOOLEAN( p_init_msg_list )
6833: THEN
6834: FND_MSG_PUB.initialize;
6835: END IF;
6836:

Line 6839: x_return_status := FND_API.G_RET_STS_SUCCESS;

6835: END IF;
6836:
6837: -- Set API return status to success
6838:
6839: x_return_status := FND_API.G_RET_STS_SUCCESS;
6840:
6841: -- Check Task index value, when they don't provide an index we will error out
6842: FOR i in 1..p_task_asgmt_index.COUNT LOOP
6843:

Line 6866: x_return_status := FND_API.G_RET_STS_ERROR;

6862: ,p_attribute4 => ''
6863: ,p_attribute5 => '');
6864: END IF;
6865:
6866: x_return_status := FND_API.G_RET_STS_ERROR;
6867: RAISE FND_API.G_EXC_ERROR;
6868:
6869: END IF;
6870:

Line 6867: RAISE FND_API.G_EXC_ERROR;

6863: ,p_attribute5 => '');
6864: END IF;
6865:
6866: x_return_status := FND_API.G_RET_STS_ERROR;
6867: RAISE FND_API.G_EXC_ERROR;
6868:
6869: END IF;
6870:
6871: IF g_task_asgmts_out_tbl.exists(p_task_asgmt_index(i)) AND

Line 6948: WHEN FND_API.G_EXC_ERROR

6944: END LOOP;
6945:
6946: EXCEPTION
6947:
6948: WHEN FND_API.G_EXC_ERROR
6949: THEN
6950: ROLLBACK TO fetch_task_assignments_pub;
6951:
6952: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6952: x_return_status := FND_API.G_RET_STS_ERROR;

6948: WHEN FND_API.G_EXC_ERROR
6949: THEN
6950: ROLLBACK TO fetch_task_assignments_pub;
6951:
6952: x_return_status := FND_API.G_RET_STS_ERROR;
6953: IF P_DEBUG_MODE = 'Y' THEN
6954: PA_DEBUG.write_log (x_module => G_PKG_NAME
6955: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
6956: ,x_log_level => 5);

Line 6959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

6955: ,x_msg => 'Expected Error:' || L_FuncProc || SQLERRM
6956: ,x_log_level => 5);
6957: END IF;
6958:
6959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
6960: THEN
6961: ROLLBACK TO fetch_task_assignments_pub;
6962:
6963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
6960: THEN
6961: ROLLBACK TO fetch_task_assignments_pub;
6962:
6963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6964: IF P_DEBUG_MODE = 'Y' THEN
6965: PA_DEBUG.write_log (x_module => G_PKG_NAME
6966: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
6967: ,x_log_level => 5);

Line 6974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6970:
6971: WHEN OTHERS THEN
6972: ROLLBACK TO fetch_task_assignments_pub;
6973:
6974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6975: IF P_DEBUG_MODE = 'Y' THEN
6976: PA_DEBUG.write_log (x_module => G_PKG_NAME
6977: ,x_msg => 'Unexpected Error:' || L_FuncProc || SQLERRM
6978: ,x_log_level => 5);

Line 7125: x_return_status := FND_API.G_RET_STS_SUCCESS;

7121: l_struct_ver_id NUMBER;
7122:
7123: BEGIN
7124:
7125: x_return_status := FND_API.G_RET_STS_SUCCESS;
7126:
7127: -- Bug 3872176 get project information
7128: OPEN l_project_id_csr;
7129: FETCH l_project_id_csr INTO l_dummy, l_template_flag, l_version_enabled_flag;

Line 7151: RAISE FND_API.G_EXC_ERROR;

7147: ,p_attribute4 => ''
7148: ,p_attribute5 => '');
7149: END IF;
7150:
7151: RAISE FND_API.G_EXC_ERROR;
7152: END IF;
7153:
7154: ELSE
7155:

Line 7170: RAISE FND_API.G_EXC_ERROR;

7166: ,p_attribute4 => ''
7167: ,p_attribute5 => '');
7168: END IF;
7169:
7170: RAISE FND_API.G_EXC_ERROR;
7171:
7172: END IF;
7173:
7174: IF p_pa_structure_version_id IS NOT NULL AND

Line 7233: RAISE FND_API.G_EXC_ERROR;

7229: ,p_attribute3 => ''
7230: ,p_attribute4 => ''
7231: ,p_attribute5 => '');
7232: END IF;
7233: RAISE FND_API.G_EXC_ERROR;
7234: END IF;
7235:
7236: IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7237: AND p_pa_task_id IS NOT NULL

Line 7267: RAISE FND_API.G_EXC_ERROR;

7263: ,p_attribute5 => '');
7264: END IF;
7265:
7266:
7267: RAISE FND_API.G_EXC_ERROR;
7268: END IF;
7269:
7270: --p_out_task_id := p_pa_task_id; --JRAJ.
7271: END IF; --IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 7307: RAISE FND_API.G_EXC_ERROR;

7303: ,p_attribute5 => '');
7304: END IF;
7305:
7306: CLOSE l_task_asgmt_id_csr;
7307: RAISE FND_API.G_EXC_ERROR;
7308: END IF;
7309:
7310: CLOSE l_task_asgmt_id_csr;
7311:

Line 7359: RAISE FND_API.G_EXC_ERROR;

7355: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Assignment Reference');
7356: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_asgmt_reference);
7357: FND_MSG_PUB.add;
7358:
7359: RAISE FND_API.G_EXC_ERROR;
7360:
7361: END IF;
7362:
7363: ELSE

Line 7397: RAISE FND_API.G_EXC_ERROR;

7393: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Assignment Reference');
7394: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_asgmt_reference);
7395: FND_MSG_PUB.add;
7396:
7397: RAISE FND_API.G_EXC_ERROR;
7398:
7399: END IF;
7400: ELSE
7401: x_pa_task_assignment_id := l_task_asgmt_id ; --JRAJ.

Line 7424: RAISE FND_API.G_EXC_ERROR;

7420: ,p_attribute4 => ''
7421: ,p_attribute5 => '');
7422: END IF;
7423:
7424: RAISE FND_API.G_EXC_ERROR;
7425:
7426: END IF; -- If p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7427: --dbms_output.put_line('l_task_asgmt_id'||l_task_asgmt_id);
7428: EXCEPTION

Line 7430: WHEN FND_API.G_EXC_ERROR

7426: END IF; -- If p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7427: --dbms_output.put_line('l_task_asgmt_id'||l_task_asgmt_id);
7428: EXCEPTION
7429:
7430: WHEN FND_API.G_EXC_ERROR
7431: THEN
7432:
7433:
7434: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7434: x_return_status := FND_API.G_RET_STS_ERROR;

7430: WHEN FND_API.G_EXC_ERROR
7431: THEN
7432:
7433:
7434: x_return_status := FND_API.G_RET_STS_ERROR;
7435:
7436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
7437: THEN
7438:

Line 7436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

7432:
7433:
7434: x_return_status := FND_API.G_RET_STS_ERROR;
7435:
7436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
7437: THEN
7438:
7439:
7440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
7437: THEN
7438:
7439:
7440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7441:
7442: WHEN OTHERS THEN
7443:
7444:

Line 7445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7441:
7442: WHEN OTHERS THEN
7443:
7444:
7445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7446:
7447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7448: THEN
7449: FND_MSG_PUB.add_exc_msg