APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on FND_API

Line 23: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

19: --p_description IN VARCHAR2
20:
21: PROCEDURE Create_Project_Template(
22: p_api_version IN NUMBER :=1.0,
23: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
24: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
25: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
26: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
27: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

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

20:
21: PROCEDURE Create_Project_Template(
22: p_api_version IN NUMBER :=1.0,
23: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
24: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
25: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
26: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
27: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
28: p_debug_mode IN VARCHAR2 :='N',

Line 25: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

21: PROCEDURE Create_Project_Template(
22: p_api_version IN NUMBER :=1.0,
23: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
24: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
25: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
26: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
27: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
28: p_debug_mode IN VARCHAR2 :='N',
29: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 26: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

22: p_api_version IN NUMBER :=1.0,
23: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
24: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
25: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
26: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
27: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
28: p_debug_mode IN VARCHAR2 :='N',
29: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
30: p_project_number IN VARCHAR2,

Line 214: IF (p_commit = FND_API.G_TRUE) THEN

210: IF (p_debug_mode = 'Y') THEN
211: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template begin');
212: END IF;
213:
214: IF (p_commit = FND_API.G_TRUE) THEN
215: savepoint Create_Project_Template;
216: END IF;
217:
218: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 218: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

214: IF (p_commit = FND_API.G_TRUE) THEN
215: savepoint Create_Project_Template;
216: END IF;
217:
218: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END IF;
221:
222: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

215: savepoint Create_Project_Template;
216: END IF;
217:
218: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END IF;
221:
222: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
223: FND_MSG_PUB.initialize;

Line 222: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

218: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END IF;
221:
222: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
223: FND_MSG_PUB.initialize;
224: END IF;
225:
226: --Check for not null

Line 236: IF l_return_status = FND_API.G_RET_STS_ERROR

232: ,x_return_status => l_return_status
233: ,x_error_msg_code => l_error_msg_code
234: );
235:
236: IF l_return_status = FND_API.G_RET_STS_ERROR
237: THEN
238: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
239: p_msg_name => l_error_msg_code);
240: x_msg_data := l_error_msg_code;

Line 242: RAISE FND_API.G_EXC_ERROR;

238: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
239: p_msg_name => l_error_msg_code);
240: x_msg_data := l_error_msg_code;
241: x_return_status := 'E';
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: --check for project number uniqueness
246: IF pa_project_utils.check_unique_project_number (x_project_number => p_project_number

Line 254: RAISE FND_API.G_EXC_ERROR;

250: p_msg_name => 'PA_SETUP_TMPL_NUM_NOT_UNIQUE' );
251: --x_msg_data := 'PA_PR_EPR_PROJ_NUM_NOT_UNIQUE';
252: x_msg_data := 'PA_SETUP_TMPL_NUM_NOT_UNIQUE';
253: x_return_status := 'E';
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: --check for project name uniqueness
258: IF pa_project_utils.check_unique_project_name (x_project_name => p_project_name

Line 266: RAISE FND_API.G_EXC_ERROR;

262: p_msg_name => 'PA_SETUP_TMPL_NAME_NOT_UNIQUE' );
263: --x_msg_data := 'PA_PR_EPR_PROJ_NAME_NOT_UNIQUE';
264: x_msg_data := 'PA_SETUP_TMPL_NAME_NOT_UNIQUE';
265: x_return_status := 'E';
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268:
269: -- anlee
270: -- Project Long Name changes

Line 279: RAISE FND_API.G_EXC_ERROR;

275: p_msg_name => 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE' );
276: --x_msg_data := 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE';
277: x_msg_data := 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE';
278: x_return_status := 'E';
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281: -- End of changes
282:
283: IF p_effective_from_date = TO_DATE( '01-01-1000', 'DD-MM-YYYY' )

Line 307: RAISE FND_API.G_EXC_ERROR;

303: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
304: p_msg_name => 'PA_SETUP_CHK_ST_EN_DATE');
305: x_msg_data := 'PA_SETUP_CHK_ST_EN_DATE';
306: x_return_status := 'E';
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309: ELSIF l_effective_from_date IS NULL AND
310: l_effective_to_date IS NOT NULL
311: THEN

Line 316: RAISE FND_API.G_EXC_ERROR;

312: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
313: p_msg_name => 'PA_SETUP_ST_DT_WO_EN_DT');
314: x_msg_data := 'PA_SETUP_ST_DT_WO_EN_DT';
315: x_return_status := 'E';
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318:
319: PA_PROJ_TEMPLATE_SETUP_UTILS.Get_Project_Type_Defaults(
320: p_project_type => p_project_type

Line 370: IF l_return_status = FND_API.G_RET_STS_ERROR

366: ,x_return_status => l_return_status
367: ,x_error_msg_code => l_error_msg_code
368: );
369:
370: IF l_return_status = FND_API.G_RET_STS_ERROR
371: THEN
372: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
373: p_msg_name => l_error_msg_code);
374: x_msg_data := l_error_msg_code;

Line 376: RAISE FND_API.G_EXC_ERROR;

372: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
373: p_msg_name => l_error_msg_code);
374: x_msg_data := l_error_msg_code;
375: x_return_status := 'E';
376: RAISE FND_API.G_EXC_ERROR;
377: END IF;
378:
379: --Organization Location Validations
380: pa_location_utils.Get_ORG_Location_Details

Line 389: IF l_return_status = FND_API.G_RET_STS_ERROR

385: x_country_code => l_country_code,
386: x_return_status => l_return_status,
387: x_error_message_code => l_error_message_code);
388:
389: IF l_return_status = FND_API.G_RET_STS_ERROR
390: THEN
391: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
392: p_msg_name => l_error_message_code);
393: x_msg_data := l_error_msg_code;

Line 395: RAISE FND_API.G_EXC_ERROR;

391: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
392: p_msg_name => l_error_message_code);
393: x_msg_data := l_error_msg_code;
394: x_return_status := 'E';
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397:
398: pa_location_utils.check_location_exists(
399: p_country_code => l_country_code,

Line 437: IF l_return_status = FND_API.G_RET_STS_ERROR

433: x_return_status => l_return_status,
434: x_msg_count => l_msg_count,
435: x_msg_data => l_msg_data);
436:
437: IF l_return_status = FND_API.G_RET_STS_ERROR
438: THEN
439: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
440: p_msg_name => l_msg_data);
441: x_msg_data := l_msg_data;

Line 443: RAISE FND_API.G_EXC_ERROR;

439: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
440: p_msg_name => l_msg_data);
441: x_msg_data := l_msg_data;
442: x_return_status := 'E';
443: RAISE FND_API.G_EXC_ERROR;
444: END IF;
445:
446:
447: --default public sector flag from profile options.

Line 558: RAISE FND_API.G_EXC_ERROR;

554: p_value1 => t_project_type_class_code);
555: */
556: x_msg_data := x_err_stage;
557: x_return_status := 'E';
558: RAISE FND_API.G_EXC_ERROR;
559:
560: End If;
561:
562: IF t_project_type_class_code <> 'CONTRACT'

Line 807: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

803: -- End of changes
804: END LOOP;
805: END;
806:
807: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
808: x_msg_count := FND_MSG_PUB.count_msg;
809: IF x_msg_count = 1 then
810: pa_interface_utils_pub.get_messages
811: (p_encoded => FND_API.G_TRUE,

Line 811: (p_encoded => FND_API.G_TRUE,

807: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
808: x_msg_count := FND_MSG_PUB.count_msg;
809: IF x_msg_count = 1 then
810: pa_interface_utils_pub.get_messages
811: (p_encoded => FND_API.G_TRUE,
812: p_msg_index => 1,
813: p_msg_count => l_msg_count,
814: p_msg_data => l_msg_data,
815: p_data => l_data,

Line 819: raise FND_API.G_EXC_ERROR;

815: p_data => l_data,
816: p_msg_index_out => l_msg_index_out);
817: x_msg_data := l_data;
818: END IF;
819: raise FND_API.G_EXC_ERROR;
820: END IF;
821:
822: --Call Add quick entry api to add two default quick entries( SEGMENT1 and NAME ) in
823: --pa_project_copy_overrides with the created template.

Line 865: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

861:
862: END LOOP;
863: END;
864:
865: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
866: x_msg_count := FND_MSG_PUB.count_msg;
867: IF x_msg_count = 1 then
868: pa_interface_utils_pub.get_messages
869: (p_encoded => FND_API.G_TRUE,

Line 869: (p_encoded => FND_API.G_TRUE,

865: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
866: x_msg_count := FND_MSG_PUB.count_msg;
867: IF x_msg_count = 1 then
868: pa_interface_utils_pub.get_messages
869: (p_encoded => FND_API.G_TRUE,
870: p_msg_index => 1,
871: p_msg_count => l_msg_count,
872: p_msg_data => l_msg_data,
873: p_data => l_data,

Line 877: raise FND_API.G_EXC_ERROR;

873: p_data => l_data,
874: p_msg_index_out => l_msg_index_out);
875: x_msg_data := l_data;
876: END IF;
877: raise FND_API.G_EXC_ERROR;
878: END IF;
879:
880: --Insert default resource list
881: Open Get_def_Res_List;

Line 1031: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1027: ,x_return_status => l_return_status
1028: ,x_msg_count => l_msg_count
1029: ,x_msg_data => l_msg_data );
1030:
1031: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1032: x_msg_count := FND_MSG_PUB.count_msg;
1033: IF x_msg_count = 1 then
1034: pa_interface_utils_pub.get_messages
1035: (p_encoded => FND_API.G_TRUE,

Line 1035: (p_encoded => FND_API.G_TRUE,

1031: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1032: x_msg_count := FND_MSG_PUB.count_msg;
1033: IF x_msg_count = 1 then
1034: pa_interface_utils_pub.get_messages
1035: (p_encoded => FND_API.G_TRUE,
1036: p_msg_index => 1,
1037: p_msg_count => l_msg_count,
1038: p_msg_data => l_msg_data,
1039: p_data => l_data,

Line 1043: raise FND_API.G_EXC_ERROR;

1039: p_data => l_data,
1040: p_msg_index_out => l_msg_index_out);
1041: x_msg_data := l_data;
1042: END IF;
1043: raise FND_API.G_EXC_ERROR;
1044: END IF;
1045:
1046: /* From FPM we will not be creating any default structure at the time of template creation
1047: Please refer Financial structures in HTML Technical Architecture on files online

Line 1062: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1058: ,x_msg_data => l_msg_data
1059: ,x_return_status => l_return_status
1060: );
1061:
1062: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1063: x_msg_count := FND_MSG_PUB.count_msg;
1064: IF x_msg_count = 1 then
1065: pa_interface_utils_pub.get_messages
1066: (p_encoded => FND_API.G_TRUE,

Line 1066: (p_encoded => FND_API.G_TRUE,

1062: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1063: x_msg_count := FND_MSG_PUB.count_msg;
1064: IF x_msg_count = 1 then
1065: pa_interface_utils_pub.get_messages
1066: (p_encoded => FND_API.G_TRUE,
1067: p_msg_index => 1,
1068: p_msg_count => l_msg_count,
1069: p_msg_data => l_msg_data,
1070: p_data => l_data,

Line 1074: raise FND_API.G_EXC_ERROR;

1070: p_data => l_data,
1071: p_msg_index_out => l_msg_index_out);
1072: x_msg_data := l_data;
1073: END IF;
1074: raise FND_API.G_EXC_ERROR;
1075: END IF;
1076:
1077: --Project Structures Changes
1078: --Creating tasks in pa_proj_elements from pa_tasks

Line 1086: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1082: ,x_msg_count => l_msg_count
1083: ,x_msg_data => l_msg_data
1084: ,x_return_status => l_return_status );
1085:
1086: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1087: x_msg_count := FND_MSG_PUB.count_msg;
1088: IF x_msg_count = 1 then
1089: pa_interface_utils_pub.get_messages
1090: (p_encoded => FND_API.G_TRUE,

Line 1090: (p_encoded => FND_API.G_TRUE,

1086: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1087: x_msg_count := FND_MSG_PUB.count_msg;
1088: IF x_msg_count = 1 then
1089: pa_interface_utils_pub.get_messages
1090: (p_encoded => FND_API.G_TRUE,
1091: p_msg_index => 1,
1092: p_msg_count => l_msg_count,
1093: p_msg_data => l_msg_data,
1094: p_data => l_data,

Line 1098: raise FND_API.G_EXC_ERROR;

1094: p_data => l_data,
1095: p_msg_index_out => l_msg_index_out);
1096: x_msg_data := l_data;
1097: END IF;
1098: raise FND_API.G_EXC_ERROR;
1099: END IF;
1100: */ --bug 3301192
1101:
1102: -- anlee

Line 1120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1116: ,x_msg_data => l_msg_data
1117: ,x_return_status => l_return_status
1118: );
1119:
1120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1121: x_msg_count := FND_MSG_PUB.count_msg;
1122: IF x_msg_count = 1 then
1123: pa_interface_utils_pub.get_messages
1124: (p_encoded => FND_API.G_TRUE,

Line 1124: (p_encoded => FND_API.G_TRUE,

1120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1121: x_msg_count := FND_MSG_PUB.count_msg;
1122: IF x_msg_count = 1 then
1123: pa_interface_utils_pub.get_messages
1124: (p_encoded => FND_API.G_TRUE,
1125: p_msg_index => 1,
1126: p_msg_count => l_msg_count,
1127: p_msg_data => l_msg_data,
1128: p_data => l_data,

Line 1132: raise FND_API.G_EXC_ERROR;

1128: p_data => l_data,
1129: p_msg_index_out => l_msg_index_out);
1130: x_msg_data := l_data;
1131: END IF;
1132: raise FND_API.G_EXC_ERROR;
1133: END IF;
1134: */
1135: -- End of changes
1136:

Line 1137: x_return_status := FND_API.G_RET_STS_SUCCESS;

1133: END IF;
1134: */
1135: -- End of changes
1136:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138:
1139: IF (p_commit = FND_API.G_TRUE) THEN
1140: COMMIT;
1141: END IF;

Line 1139: IF (p_commit = FND_API.G_TRUE) THEN

1135: -- End of changes
1136:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138:
1139: IF (p_commit = FND_API.G_TRUE) THEN
1140: COMMIT;
1141: END IF;
1142:
1143: IF (p_debug_mode = 'Y') THEN

Line 1147: when FND_API.G_EXC_ERROR then

1143: IF (p_debug_mode = 'Y') THEN
1144: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template END');
1145: END IF;
1146: EXCEPTION
1147: when FND_API.G_EXC_ERROR then
1148: if p_commit = FND_API.G_TRUE then
1149: rollback to Create_Project_Template;
1150: end if;
1151: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1148: if p_commit = FND_API.G_TRUE then

1144: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template END');
1145: END IF;
1146: EXCEPTION
1147: when FND_API.G_EXC_ERROR then
1148: if p_commit = FND_API.G_TRUE then
1149: rollback to Create_Project_Template;
1150: end if;
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1151: x_return_status := FND_API.G_RET_STS_ERROR;

1147: when FND_API.G_EXC_ERROR then
1148: if p_commit = FND_API.G_TRUE then
1149: rollback to Create_Project_Template;
1150: end if;
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: when FND_API.G_EXC_UNEXPECTED_ERROR then
1153: if p_commit = FND_API.G_TRUE then
1154: rollback to Create_Project_Template;
1155: end if;

Line 1152: when FND_API.G_EXC_UNEXPECTED_ERROR then

1148: if p_commit = FND_API.G_TRUE then
1149: rollback to Create_Project_Template;
1150: end if;
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: when FND_API.G_EXC_UNEXPECTED_ERROR then
1153: if p_commit = FND_API.G_TRUE then
1154: rollback to Create_Project_Template;
1155: end if;
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1153: if p_commit = FND_API.G_TRUE then

1149: rollback to Create_Project_Template;
1150: end if;
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: when FND_API.G_EXC_UNEXPECTED_ERROR then
1153: if p_commit = FND_API.G_TRUE then
1154: rollback to Create_Project_Template;
1155: end if;
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1152: when FND_API.G_EXC_UNEXPECTED_ERROR then
1153: if p_commit = FND_API.G_TRUE then
1154: rollback to Create_Project_Template;
1155: end if;
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1158: p_procedure_name => 'Create_Project_Template',
1159: p_error_text => SUBSTRB(SQLERRM,1,240));
1160: when OTHERS then

Line 1161: if p_commit = FND_API.G_TRUE then

1157: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1158: p_procedure_name => 'Create_Project_Template',
1159: p_error_text => SUBSTRB(SQLERRM,1,240));
1160: when OTHERS then
1161: if p_commit = FND_API.G_TRUE then
1162: rollback to Create_Project_Template;
1163: end if;
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1160: when OTHERS then
1161: if p_commit = FND_API.G_TRUE then
1162: rollback to Create_Project_Template;
1163: end if;
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1166: p_procedure_name => 'Create_Project_Template',
1167: p_error_text => SUBSTRB(SQLERRM,1,240));
1168: raise;

Line 1188: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

1184: --p_description IN VARCHAR2
1185:
1186: PROCEDURE Update_Project_Template(
1187: p_api_version IN NUMBER :=1.0,
1188: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1189: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1190: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1191: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1192: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

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

1185:
1186: PROCEDURE Update_Project_Template(
1187: p_api_version IN NUMBER :=1.0,
1188: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1189: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1190: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1191: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1192: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1193: p_debug_mode IN VARCHAR2 :='N',

Line 1190: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

1186: PROCEDURE Update_Project_Template(
1187: p_api_version IN NUMBER :=1.0,
1188: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1189: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1190: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1191: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1192: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1193: p_debug_mode IN VARCHAR2 :='N',
1194: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 1191: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

1187: p_api_version IN NUMBER :=1.0,
1188: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1189: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1190: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1191: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1192: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1193: p_debug_mode IN VARCHAR2 :='N',
1194: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1195: p_project_id IN NUMBER,

Line 1405: IF (p_commit = FND_API.G_TRUE) THEN

1401: IF (p_debug_mode = 'Y') THEN
1402: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template begin');
1403: END IF;
1404:
1405: IF (p_commit = FND_API.G_TRUE) THEN
1406: savepoint Update_Project_Template;
1407: END IF;
1408:
1409: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 1409: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

1405: IF (p_commit = FND_API.G_TRUE) THEN
1406: savepoint Update_Project_Template;
1407: END IF;
1408:
1409: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:
1413: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1406: savepoint Update_Project_Template;
1407: END IF;
1408:
1409: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:
1413: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1414: FND_MSG_PUB.initialize;

Line 1413: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

1409: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:
1413: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1414: FND_MSG_PUB.initialize;
1415: END IF;
1416:
1417: --check project type change

Line 1456: IF l_return_status = FND_API.G_RET_STS_ERROR

1452: ,x_return_status => l_return_status
1453: ,x_error_msg_code => l_error_msg_code
1454: );
1455:
1456: IF l_return_status = FND_API.G_RET_STS_ERROR
1457: THEN
1458: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1459: p_msg_name => l_error_msg_code);
1460: x_msg_data := l_error_msg_code;

Line 1462: RAISE FND_API.G_EXC_ERROR;

1458: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1459: p_msg_name => l_error_msg_code);
1460: x_msg_data := l_error_msg_code;
1461: x_return_status := 'E';
1462: RAISE FND_API.G_EXC_ERROR;
1463: END IF;
1464:
1465: --Check proj number change
1466: IF l_proj_number <> p_project_number

Line 1478: RAISE FND_API.G_EXC_ERROR;

1474: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1475: p_msg_name => l_err_stage );
1476: x_msg_data := x_err_stage;
1477: x_return_status := 'E';
1478: RAISE FND_API.G_EXC_ERROR;
1479: end If;
1480: END IF;
1481:
1482: --check for project number uniqueness

Line 1490: RAISE FND_API.G_EXC_ERROR;

1486: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1487: p_msg_name => 'PA_SETUP_TMPL_NUM_NOT_UNIQUE' );
1488: x_msg_data := 'PA_SETUP_TMPL_NUM_NOT_UNIQUE';
1489: x_return_status := 'E';
1490: RAISE FND_API.G_EXC_ERROR;
1491: END IF;
1492:
1493: --check for project name uniqueness
1494: IF pa_project_utils.check_unique_project_name (x_project_name => p_project_name

Line 1501: RAISE FND_API.G_EXC_ERROR;

1497: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1498: p_msg_name => 'PA_SETUP_TMPL_NAME_NOT_UNIQUE' );
1499: x_msg_data := 'PA_SETUP_TMPL_NAME_NOT_UNIQUE';
1500: x_return_status := 'E';
1501: RAISE FND_API.G_EXC_ERROR;
1502: END IF;
1503:
1504: -- anlee
1505: -- Project Long Name changes

Line 1512: RAISE FND_API.G_EXC_ERROR;

1508: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1509: p_msg_name => 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE' );
1510: x_msg_data := 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE';
1511: x_return_status := 'E';
1512: RAISE FND_API.G_EXC_ERROR;
1513: END IF;
1514: -- End of changes
1515:
1516: IF p_effective_from_date = TO_DATE( '01-01-1000', 'DD-MM-YYYY' )

Line 1540: RAISE FND_API.G_EXC_ERROR;

1536: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1537: p_msg_name => 'PA_SETUP_CHK_ST_EN_DATE');
1538: x_msg_data := 'PA_SETUP_CHK_ST_EN_DATE';
1539: x_return_status := 'E';
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: ELSIF l_effective_from_date IS NULL AND
1543: l_effective_to_date IS NOT NULL
1544: THEN

Line 1549: RAISE FND_API.G_EXC_ERROR;

1545: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1546: p_msg_name => 'PA_SETUP_ST_DT_WO_EN_DT');
1547: x_msg_data := 'PA_SETUP_ST_DT_WO_EN_DT';
1548: x_return_status := 'E';
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551:
1552: PA_PROJ_TEMPLATE_SETUP_UTILS.Get_Project_Type_Defaults(
1553: p_project_type => p_project_type

Line 1602: IF l_return_status = FND_API.G_RET_STS_ERROR

1598: ,x_return_status => l_return_status
1599: ,x_error_msg_code => l_error_msg_code
1600: );
1601:
1602: IF l_return_status = FND_API.G_RET_STS_ERROR
1603: THEN
1604: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1605: p_msg_name => l_error_msg_code);
1606: x_msg_data := l_error_msg_code;

Line 1608: RAISE FND_API.G_EXC_ERROR;

1604: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1605: p_msg_name => l_error_msg_code);
1606: x_msg_data := l_error_msg_code;
1607: x_return_status := 'E';
1608: RAISE FND_API.G_EXC_ERROR;
1609: END IF;
1610:
1611: --Validation from Projects form
1612: IF l_unassigned_time = 'N'

Line 1657: RAISE FND_API.G_EXC_ERROR;

1653: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1654: p_msg_name => 'PA_PR_CANT_CHG_DIR_TO_INDIR' );
1655: x_msg_data := 'PA_PR_CANT_CHG_DIR_TO_INDIR';
1656: x_return_status := 'E';
1657: RAISE FND_API.G_EXC_ERROR;
1658: END IF;
1659: l_labor_sch_type := null;
1660: l_non_labor_sch_type := null;
1661: END IF;

Line 1695: RAISE FND_API.G_EXC_ERROR;

1691: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1692: p_msg_name => 'PA_PR_CANT_CHG_PROJ_TYPE' );
1693: x_msg_data := 'PA_PR_CANT_CHG_DIR_TO_INDIR';
1694: x_return_status := 'E';
1695: RAISE FND_API.G_EXC_ERROR;
1696: END IF;
1697: */ --this code is commented in forms PAXPREPR.fmb
1698: END IF;
1699:

Line 1715: IF l_return_status = FND_API.G_RET_STS_ERROR

1711: x_country_code => l_country_code,
1712: x_return_status => l_return_status,
1713: x_error_message_code => l_error_message_code);
1714:
1715: IF l_return_status = FND_API.G_RET_STS_ERROR
1716: THEN
1717: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1718: p_msg_name => l_error_message_code);
1719: x_msg_data := l_error_msg_code;

Line 1721: RAISE FND_API.G_EXC_ERROR;

1717: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1718: p_msg_name => l_error_message_code);
1719: x_msg_data := l_error_msg_code;
1720: x_return_status := 'E';
1721: RAISE FND_API.G_EXC_ERROR;
1722: END IF;
1723:
1724: pa_location_utils.check_location_exists(
1725: p_country_code => l_country_code,

Line 1830: RAISE FND_API.G_EXC_ERROR;

1826: p_value1 => l_project_type_class_code );
1827: */
1828: x_msg_data := x_err_stage;
1829: x_return_status := 'E';
1830: RAISE FND_API.G_EXC_ERROR;
1831: End If;
1832: END IF; --validate attribute change
1833:
1834: --maansari bug 3068806

Line 1844: RAISE FND_API.G_EXC_ERROR;

1840: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1841: p_msg_name => 'PA_PR_CANT_CHG_IC_BIL_PT');
1842: x_msg_data := 'PA_PR_CANT_CHG_IC_BIL_PT';
1843: x_return_status := 'E';
1844: RAISE FND_API.G_EXC_ERROR;
1845: END IF;
1846: --end maansari bug 3068806
1847:
1848: --bug 3068781

Line 2054: IF hghst_ctr_cust_id IS NOT NULL AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2050: , x_return_status => l_return_status
2051: , x_msg_count => l_msg_count
2052: , x_msg_data => l_msg_data );
2053:
2054: IF hghst_ctr_cust_id IS NOT NULL AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2055:
2056: UPDATE pa_project_customers SET customer_bill_split = 100
2057: WHERE customer_id = hghst_ctr_cust_id AND project_id = p_project_id;
2058:

Line 2107: x_return_status := FND_API.G_RET_STS_SUCCESS;

2103: WHERE project_id = p_project_id;
2104:
2105: END IF;
2106:
2107: x_return_status := FND_API.G_RET_STS_SUCCESS;
2108:
2109: IF (p_commit = FND_API.G_TRUE) THEN
2110: COMMIT;
2111: END IF;

Line 2109: IF (p_commit = FND_API.G_TRUE) THEN

2105: END IF;
2106:
2107: x_return_status := FND_API.G_RET_STS_SUCCESS;
2108:
2109: IF (p_commit = FND_API.G_TRUE) THEN
2110: COMMIT;
2111: END IF;
2112:
2113: IF (p_debug_mode = 'Y') THEN

Line 2117: when FND_API.G_EXC_ERROR then

2113: IF (p_debug_mode = 'Y') THEN
2114: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template END');
2115: END IF;
2116: EXCEPTION
2117: when FND_API.G_EXC_ERROR then
2118: if p_commit = FND_API.G_TRUE then
2119: rollback to Update_Project_Template;
2120: end if;
2121: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2118: if p_commit = FND_API.G_TRUE then

2114: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template END');
2115: END IF;
2116: EXCEPTION
2117: when FND_API.G_EXC_ERROR then
2118: if p_commit = FND_API.G_TRUE then
2119: rollback to Update_Project_Template;
2120: end if;
2121: x_return_status := FND_API.G_RET_STS_ERROR;
2122: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2121: x_return_status := FND_API.G_RET_STS_ERROR;

2117: when FND_API.G_EXC_ERROR then
2118: if p_commit = FND_API.G_TRUE then
2119: rollback to Update_Project_Template;
2120: end if;
2121: x_return_status := FND_API.G_RET_STS_ERROR;
2122: when FND_API.G_EXC_UNEXPECTED_ERROR then
2123: if p_commit = FND_API.G_TRUE then
2124: rollback to Update_Project_Template;
2125: end if;

Line 2122: when FND_API.G_EXC_UNEXPECTED_ERROR then

2118: if p_commit = FND_API.G_TRUE then
2119: rollback to Update_Project_Template;
2120: end if;
2121: x_return_status := FND_API.G_RET_STS_ERROR;
2122: when FND_API.G_EXC_UNEXPECTED_ERROR then
2123: if p_commit = FND_API.G_TRUE then
2124: rollback to Update_Project_Template;
2125: end if;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2123: if p_commit = FND_API.G_TRUE then

2119: rollback to Update_Project_Template;
2120: end if;
2121: x_return_status := FND_API.G_RET_STS_ERROR;
2122: when FND_API.G_EXC_UNEXPECTED_ERROR then
2123: if p_commit = FND_API.G_TRUE then
2124: rollback to Update_Project_Template;
2125: end if;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2122: when FND_API.G_EXC_UNEXPECTED_ERROR then
2123: if p_commit = FND_API.G_TRUE then
2124: rollback to Update_Project_Template;
2125: end if;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2128: p_procedure_name => 'Update_Project_Template',
2129: p_error_text => SUBSTRB(SQLERRM,1,240));
2130: when OTHERS then

Line 2131: if p_commit = FND_API.G_TRUE then

2127: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2128: p_procedure_name => 'Update_Project_Template',
2129: p_error_text => SUBSTRB(SQLERRM,1,240));
2130: when OTHERS then
2131: if p_commit = FND_API.G_TRUE then
2132: rollback to Update_Project_Template;
2133: end if;
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2135: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2130: when OTHERS then
2131: if p_commit = FND_API.G_TRUE then
2132: rollback to Update_Project_Template;
2133: end if;
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2135: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2136: p_procedure_name => 'Update_Project_Template',
2137: p_error_text => SUBSTRB(SQLERRM,1,240));
2138: raise;

Line 2153: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

2149: --
2150:
2151: PROCEDURE Delete_Project_Template(
2152: p_api_version IN NUMBER :=1.0,
2153: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2154: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2155: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2156: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2157: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

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

2150:
2151: PROCEDURE Delete_Project_Template(
2152: p_api_version IN NUMBER :=1.0,
2153: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2154: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2155: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2156: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2157: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2158: p_debug_mode IN VARCHAR2 :='N',

Line 2155: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

2151: PROCEDURE Delete_Project_Template(
2152: p_api_version IN NUMBER :=1.0,
2153: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2154: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2155: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2156: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2157: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2158: p_debug_mode IN VARCHAR2 :='N',
2159: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2156: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

2152: p_api_version IN NUMBER :=1.0,
2153: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2154: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2155: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2156: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2157: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2158: p_debug_mode IN VARCHAR2 :='N',
2159: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2160: p_project_id IN NUMBER,

Line 2188: IF (p_commit = FND_API.G_TRUE) THEN

2184: IF (p_debug_mode = 'Y') THEN
2185: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template begin');
2186: END IF;
2187:
2188: IF (p_commit = FND_API.G_TRUE) THEN
2189: savepoint Delete_Project_Template;
2190: END IF;
2191:
2192: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 2192: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

2188: IF (p_commit = FND_API.G_TRUE) THEN
2189: savepoint Delete_Project_Template;
2190: END IF;
2191:
2192: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2194: END IF;
2195:
2196: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 2193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2189: savepoint Delete_Project_Template;
2190: END IF;
2191:
2192: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2194: END IF;
2195:
2196: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2197: FND_MSG_PUB.initialize;

Line 2196: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

2192: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2194: END IF;
2195:
2196: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2197: FND_MSG_PUB.initialize;
2198: END IF;
2199:
2200: --Bug 2947492: The following api call is modified to pass parameters by notation.

Line 2213: RAISE FND_API.G_EXC_ERROR;

2209: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2210: p_msg_name => l_err_stage);
2211: x_msg_data := l_err_stage;
2212: x_return_status := 'E';
2213: RAISE FND_API.G_EXC_ERROR;
2214: END IF;
2215:
2216: x_return_status := FND_API.G_RET_STS_SUCCESS;
2217:

Line 2216: x_return_status := FND_API.G_RET_STS_SUCCESS;

2212: x_return_status := 'E';
2213: RAISE FND_API.G_EXC_ERROR;
2214: END IF;
2215:
2216: x_return_status := FND_API.G_RET_STS_SUCCESS;
2217:
2218: IF (p_commit = FND_API.G_TRUE) THEN
2219: COMMIT;
2220: END IF;

Line 2218: IF (p_commit = FND_API.G_TRUE) THEN

2214: END IF;
2215:
2216: x_return_status := FND_API.G_RET_STS_SUCCESS;
2217:
2218: IF (p_commit = FND_API.G_TRUE) THEN
2219: COMMIT;
2220: END IF;
2221:
2222: IF (p_debug_mode = 'Y') THEN

Line 2226: when FND_API.G_EXC_ERROR then

2222: IF (p_debug_mode = 'Y') THEN
2223: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template END');
2224: END IF;
2225: EXCEPTION
2226: when FND_API.G_EXC_ERROR then
2227: if p_commit = FND_API.G_TRUE then
2228: rollback to Delete_Project_Template;
2229: end if;
2230: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2227: if p_commit = FND_API.G_TRUE then

2223: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template END');
2224: END IF;
2225: EXCEPTION
2226: when FND_API.G_EXC_ERROR then
2227: if p_commit = FND_API.G_TRUE then
2228: rollback to Delete_Project_Template;
2229: end if;
2230: x_return_status := FND_API.G_RET_STS_ERROR;
2231: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2230: x_return_status := FND_API.G_RET_STS_ERROR;

2226: when FND_API.G_EXC_ERROR then
2227: if p_commit = FND_API.G_TRUE then
2228: rollback to Delete_Project_Template;
2229: end if;
2230: x_return_status := FND_API.G_RET_STS_ERROR;
2231: when FND_API.G_EXC_UNEXPECTED_ERROR then
2232: if p_commit = FND_API.G_TRUE then
2233: rollback to Delete_Project_Template;
2234: end if;

Line 2231: when FND_API.G_EXC_UNEXPECTED_ERROR then

2227: if p_commit = FND_API.G_TRUE then
2228: rollback to Delete_Project_Template;
2229: end if;
2230: x_return_status := FND_API.G_RET_STS_ERROR;
2231: when FND_API.G_EXC_UNEXPECTED_ERROR then
2232: if p_commit = FND_API.G_TRUE then
2233: rollback to Delete_Project_Template;
2234: end if;
2235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2232: if p_commit = FND_API.G_TRUE then

2228: rollback to Delete_Project_Template;
2229: end if;
2230: x_return_status := FND_API.G_RET_STS_ERROR;
2231: when FND_API.G_EXC_UNEXPECTED_ERROR then
2232: if p_commit = FND_API.G_TRUE then
2233: rollback to Delete_Project_Template;
2234: end if;
2235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2231: when FND_API.G_EXC_UNEXPECTED_ERROR then
2232: if p_commit = FND_API.G_TRUE then
2233: rollback to Delete_Project_Template;
2234: end if;
2235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2237: p_procedure_name => 'Delete_Project_Template',
2238: p_error_text => SUBSTRB(SQLERRM,1,240));
2239: when OTHERS then

Line 2240: if p_commit = FND_API.G_TRUE then

2236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2237: p_procedure_name => 'Delete_Project_Template',
2238: p_error_text => SUBSTRB(SQLERRM,1,240));
2239: when OTHERS then
2240: if p_commit = FND_API.G_TRUE then
2241: rollback to Delete_Project_Template;
2242: end if;
2243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2239: when OTHERS then
2240: if p_commit = FND_API.G_TRUE then
2241: rollback to Delete_Project_Template;
2242: end if;
2243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2245: p_procedure_name => 'Delete_Project_Template',
2246: p_error_text => SUBSTRB(SQLERRM,1,240));
2247: raise;

Line 2262: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

2258: --
2259:
2260: PROCEDURE Add_Project_Options(
2261: p_api_version IN NUMBER :=1.0,
2262: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2263: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2264: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2265: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2266: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

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

2259:
2260: PROCEDURE Add_Project_Options(
2261: p_api_version IN NUMBER :=1.0,
2262: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2263: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2264: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2265: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2266: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2267: p_debug_mode IN VARCHAR2 :='N',

Line 2264: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

2260: PROCEDURE Add_Project_Options(
2261: p_api_version IN NUMBER :=1.0,
2262: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2263: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2264: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2265: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2266: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2267: p_debug_mode IN VARCHAR2 :='N',
2268: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2265: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

2261: p_api_version IN NUMBER :=1.0,
2262: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2263: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2264: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2265: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2266: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2267: p_debug_mode IN VARCHAR2 :='N',
2268: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2269: p_project_id IN NUMBER,

Line 2305: IF (p_commit = FND_API.G_TRUE) THEN

2301: IF (p_debug_mode = 'Y') THEN
2302: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options begin');
2303: END IF;
2304:
2305: IF (p_commit = FND_API.G_TRUE) THEN
2306: savepoint Add_Project_Options;
2307: END IF;
2308:
2309: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 2309: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

2305: IF (p_commit = FND_API.G_TRUE) THEN
2306: savepoint Add_Project_Options;
2307: END IF;
2308:
2309: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2311: END IF;
2312:
2313: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 2310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2306: savepoint Add_Project_Options;
2307: END IF;
2308:
2309: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2311: END IF;
2312:
2313: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2314: FND_MSG_PUB.initialize;

Line 2313: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

2309: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2311: END IF;
2312:
2313: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2314: FND_MSG_PUB.initialize;
2315: END IF;
2316:
2317: OPEN cur_chk_options;

Line 2349: x_return_status := FND_API.G_RET_STS_SUCCESS;

2345: THEN
2346: enable_disbale_proj_opt( p_project_id, p_option_code, p_action );
2347: END IF;
2348:
2349: x_return_status := FND_API.G_RET_STS_SUCCESS;
2350:
2351: IF (p_commit = FND_API.G_TRUE) THEN
2352: COMMIT;
2353: END IF;

Line 2351: IF (p_commit = FND_API.G_TRUE) THEN

2347: END IF;
2348:
2349: x_return_status := FND_API.G_RET_STS_SUCCESS;
2350:
2351: IF (p_commit = FND_API.G_TRUE) THEN
2352: COMMIT;
2353: END IF;
2354:
2355: IF (p_debug_mode = 'Y') THEN

Line 2359: when FND_API.G_EXC_ERROR then

2355: IF (p_debug_mode = 'Y') THEN
2356: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options END');
2357: END IF;
2358: EXCEPTION
2359: when FND_API.G_EXC_ERROR then
2360: if p_commit = FND_API.G_TRUE then
2361: rollback to Add_Project_Options;
2362: end if;
2363: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2360: if p_commit = FND_API.G_TRUE then

2356: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options END');
2357: END IF;
2358: EXCEPTION
2359: when FND_API.G_EXC_ERROR then
2360: if p_commit = FND_API.G_TRUE then
2361: rollback to Add_Project_Options;
2362: end if;
2363: x_return_status := FND_API.G_RET_STS_ERROR;
2364: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2363: x_return_status := FND_API.G_RET_STS_ERROR;

2359: when FND_API.G_EXC_ERROR then
2360: if p_commit = FND_API.G_TRUE then
2361: rollback to Add_Project_Options;
2362: end if;
2363: x_return_status := FND_API.G_RET_STS_ERROR;
2364: when FND_API.G_EXC_UNEXPECTED_ERROR then
2365: if p_commit = FND_API.G_TRUE then
2366: rollback to Add_Project_Options;
2367: end if;

Line 2364: when FND_API.G_EXC_UNEXPECTED_ERROR then

2360: if p_commit = FND_API.G_TRUE then
2361: rollback to Add_Project_Options;
2362: end if;
2363: x_return_status := FND_API.G_RET_STS_ERROR;
2364: when FND_API.G_EXC_UNEXPECTED_ERROR then
2365: if p_commit = FND_API.G_TRUE then
2366: rollback to Add_Project_Options;
2367: end if;
2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2365: if p_commit = FND_API.G_TRUE then

2361: rollback to Add_Project_Options;
2362: end if;
2363: x_return_status := FND_API.G_RET_STS_ERROR;
2364: when FND_API.G_EXC_UNEXPECTED_ERROR then
2365: if p_commit = FND_API.G_TRUE then
2366: rollback to Add_Project_Options;
2367: end if;
2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2369: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2364: when FND_API.G_EXC_UNEXPECTED_ERROR then
2365: if p_commit = FND_API.G_TRUE then
2366: rollback to Add_Project_Options;
2367: end if;
2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2369: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2370: p_procedure_name => 'Add_Project_Options',
2371: p_error_text => SUBSTRB(SQLERRM,1,240));
2372: when OTHERS then

Line 2373: if p_commit = FND_API.G_TRUE then

2369: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2370: p_procedure_name => 'Add_Project_Options',
2371: p_error_text => SUBSTRB(SQLERRM,1,240));
2372: when OTHERS then
2373: if p_commit = FND_API.G_TRUE then
2374: rollback to Add_Project_Options;
2375: end if;
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2377: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2372: when OTHERS then
2373: if p_commit = FND_API.G_TRUE then
2374: rollback to Add_Project_Options;
2375: end if;
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2377: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2378: p_procedure_name => 'Add_Project_Options',
2379: p_error_text => SUBSTRB(SQLERRM,1,240));
2380: raise;

Line 2396: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

2392: --
2393:
2394: PROCEDURE Delete_Project_Options(
2395: p_api_version IN NUMBER :=1.0,
2396: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2397: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2398: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2399: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2400: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

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

2393:
2394: PROCEDURE Delete_Project_Options(
2395: p_api_version IN NUMBER :=1.0,
2396: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2397: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2398: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2399: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2400: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2401: p_debug_mode IN VARCHAR2 :='N',

Line 2398: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

2394: PROCEDURE Delete_Project_Options(
2395: p_api_version IN NUMBER :=1.0,
2396: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2397: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2398: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2399: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2400: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2401: p_debug_mode IN VARCHAR2 :='N',
2402: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2399: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

2395: p_api_version IN NUMBER :=1.0,
2396: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2397: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2398: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2399: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2400: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2401: p_debug_mode IN VARCHAR2 :='N',
2402: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2403: p_project_id IN NUMBER,

Line 2449: IF (p_commit = FND_API.G_TRUE) THEN

2445: IF (p_debug_mode = 'Y') THEN
2446: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options begin');
2447: END IF;
2448:
2449: IF (p_commit = FND_API.G_TRUE) THEN
2450: savepoint Delete_Project_Options;
2451: END IF;
2452:
2453: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 2453: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

2449: IF (p_commit = FND_API.G_TRUE) THEN
2450: savepoint Delete_Project_Options;
2451: END IF;
2452:
2453: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2455: END IF;
2456:
2457: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 2454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2450: savepoint Delete_Project_Options;
2451: END IF;
2452:
2453: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2455: END IF;
2456:
2457: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2458: FND_MSG_PUB.initialize;

Line 2457: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

2453: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2455: END IF;
2456:
2457: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2458: FND_MSG_PUB.initialize;
2459: END IF;
2460:
2461: --bug

Line 2494: RAISE FND_API.G_EXC_ERROR;

2490: p_msg_name => 'PA_ALL_NO_UPDATE_RECORD');*/
2491: x_msg_data := 'PA_PROJ_CANT_DISBL_OPTN';
2492: -- End of changes for Bug 5643345
2493: x_return_status := 'E';
2494: RAISE FND_API.G_EXC_ERROR;
2495: END IF;
2496:
2497: DELETE FROM pa_project_options WHERE project_id = p_project_id AND option_code = p_option_code;
2498:

Line 2501: x_return_status := FND_API.G_RET_STS_SUCCESS;

2497: DELETE FROM pa_project_options WHERE project_id = p_project_id AND option_code = p_option_code;
2498:
2499: enable_disbale_proj_opt( p_project_id, p_option_code, 'DISABLE' );
2500:
2501: x_return_status := FND_API.G_RET_STS_SUCCESS;
2502:
2503: IF (p_commit = FND_API.G_TRUE) THEN
2504: COMMIT;
2505: END IF;

Line 2503: IF (p_commit = FND_API.G_TRUE) THEN

2499: enable_disbale_proj_opt( p_project_id, p_option_code, 'DISABLE' );
2500:
2501: x_return_status := FND_API.G_RET_STS_SUCCESS;
2502:
2503: IF (p_commit = FND_API.G_TRUE) THEN
2504: COMMIT;
2505: END IF;
2506:
2507: IF (p_debug_mode = 'Y') THEN

Line 2511: when FND_API.G_EXC_ERROR then

2507: IF (p_debug_mode = 'Y') THEN
2508: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options END');
2509: END IF;
2510: EXCEPTION
2511: when FND_API.G_EXC_ERROR then
2512: if p_commit = FND_API.G_TRUE then
2513: rollback to Delete_Project_Options;
2514: end if;
2515: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2512: if p_commit = FND_API.G_TRUE then

2508: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options END');
2509: END IF;
2510: EXCEPTION
2511: when FND_API.G_EXC_ERROR then
2512: if p_commit = FND_API.G_TRUE then
2513: rollback to Delete_Project_Options;
2514: end if;
2515: x_return_status := FND_API.G_RET_STS_ERROR;
2516: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2515: x_return_status := FND_API.G_RET_STS_ERROR;

2511: when FND_API.G_EXC_ERROR then
2512: if p_commit = FND_API.G_TRUE then
2513: rollback to Delete_Project_Options;
2514: end if;
2515: x_return_status := FND_API.G_RET_STS_ERROR;
2516: when FND_API.G_EXC_UNEXPECTED_ERROR then
2517: if p_commit = FND_API.G_TRUE then
2518: rollback to Delete_Project_Options;
2519: end if;

Line 2516: when FND_API.G_EXC_UNEXPECTED_ERROR then

2512: if p_commit = FND_API.G_TRUE then
2513: rollback to Delete_Project_Options;
2514: end if;
2515: x_return_status := FND_API.G_RET_STS_ERROR;
2516: when FND_API.G_EXC_UNEXPECTED_ERROR then
2517: if p_commit = FND_API.G_TRUE then
2518: rollback to Delete_Project_Options;
2519: end if;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2517: if p_commit = FND_API.G_TRUE then

2513: rollback to Delete_Project_Options;
2514: end if;
2515: x_return_status := FND_API.G_RET_STS_ERROR;
2516: when FND_API.G_EXC_UNEXPECTED_ERROR then
2517: if p_commit = FND_API.G_TRUE then
2518: rollback to Delete_Project_Options;
2519: end if;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2516: when FND_API.G_EXC_UNEXPECTED_ERROR then
2517: if p_commit = FND_API.G_TRUE then
2518: rollback to Delete_Project_Options;
2519: end if;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2522: p_procedure_name => 'Delete_Project_Options',
2523: p_error_text => SUBSTRB(SQLERRM,1,240));
2524: when OTHERS then

Line 2525: if p_commit = FND_API.G_TRUE then

2521: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2522: p_procedure_name => 'Delete_Project_Options',
2523: p_error_text => SUBSTRB(SQLERRM,1,240));
2524: when OTHERS then
2525: if p_commit = FND_API.G_TRUE then
2526: rollback to Delete_Project_Options;
2527: end if;
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2529: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2524: when OTHERS then
2525: if p_commit = FND_API.G_TRUE then
2526: rollback to Delete_Project_Options;
2527: end if;
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2529: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2530: p_procedure_name => 'Delete_Project_Options',
2531: p_error_text => SUBSTRB(SQLERRM,1,240));
2532: raise;

Line 2551: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

2547: -- p_required_flag IN VARCHAR2 := 'N',--
2548:
2549: PROCEDURE Add_Quick_Entry_Field(
2550: p_api_version IN NUMBER :=1.0,
2551: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2552: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2553: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2554: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2555: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

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

2548:
2549: PROCEDURE Add_Quick_Entry_Field(
2550: p_api_version IN NUMBER :=1.0,
2551: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2552: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2553: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2554: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2555: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2556: p_debug_mode IN VARCHAR2 :='N',

Line 2553: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

2549: PROCEDURE Add_Quick_Entry_Field(
2550: p_api_version IN NUMBER :=1.0,
2551: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2552: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2553: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2554: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2555: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2556: p_debug_mode IN VARCHAR2 :='N',
2557: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2554: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

2550: p_api_version IN NUMBER :=1.0,
2551: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2552: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2553: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2554: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2555: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2556: p_debug_mode IN VARCHAR2 :='N',
2557: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2558: p_project_id IN NUMBER ,

Line 2614: IF (p_commit = FND_API.G_TRUE) THEN

2610: IF (p_debug_mode = 'Y') THEN
2611: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field begin');
2612: END IF;
2613:
2614: IF (p_commit = FND_API.G_TRUE) THEN
2615: savepoint Add_Quick_Entry_Field;
2616: END IF;
2617:
2618: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 2618: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

2614: IF (p_commit = FND_API.G_TRUE) THEN
2615: savepoint Add_Quick_Entry_Field;
2616: END IF;
2617:
2618: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2620: END IF;
2621:
2622: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2615: savepoint Add_Quick_Entry_Field;
2616: END IF;
2617:
2618: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2620: END IF;
2621:
2622: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2623: FND_MSG_PUB.initialize;

Line 2622: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

2618: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2620: END IF;
2621:
2622: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2623: FND_MSG_PUB.initialize;
2624: END IF;
2625:
2626: --check sort order unique

Line 2636: RAISE FND_API.G_EXC_ERROR;

2632: p_msg_name => 'PA_SETUP_SORT_ORDER_NOT_UNIQ' );
2633: x_msg_data := 'PA_SETUP_SORT_ORDER_NOT_UNIQ';
2634: x_return_status := 'E';
2635: CLOSE cur_chk_sort_order;
2636: RAISE FND_API.G_EXC_ERROR;
2637: ELSE
2638: CLOSE cur_chk_sort_order;
2639: END IF;
2640:

Line 2655: RAISE FND_API.G_EXC_ERROR;

2651: p_msg_name => 'PA_SETUP_DUP_QUICK_ENTRY' );
2652: x_msg_data := 'PA_SETUP_DUP_QUICK_ENTRY';
2653: x_return_status := 'E';
2654: CLOSE cur_dup_quick_entry;
2655: RAISE FND_API.G_EXC_ERROR;
2656: ELSE
2657: CLOSE cur_dup_quick_entry;
2658: END IF;
2659: /* Bug 4139681 - Replaced the ELSE with the new IF condition so that checks for specifications are done for

Line 2680: RAISE FND_API.G_EXC_ERROR;

2676: x_msg_data := 'PA_SETUP_INV_FIELD_NAME';
2677: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2678: p_msg_name => 'PA_SETUP_INV_FIELD_NAME');
2679: x_return_status := 'E';
2680: RAISE FND_API.G_EXC_ERROR;
2681: WHEN OTHERS THEN
2682: null;
2683: END;
2684:

Line 2691: RAISE FND_API.G_EXC_ERROR;

2687: p_token1 => 'FIELD_NAME',
2688: p_value1 => l_field_name_meaning );
2689: x_msg_data := 'PA_SETUP_SPEC_REQ';
2690: x_return_status := 'E';
2691: RAISE FND_API.G_EXC_ERROR;
2692: ELSE
2693: IF p_field_name <> 'CLASSIFICATION'
2694: THEN
2695: BEGIN

Line 2709: RAISE FND_API.G_EXC_ERROR;

2705: p_msg_name => 'PA_SETUP_INV_SPEC',
2706: p_token1 => 'SPECIFICATION',
2707: p_value1 => p_limiting_value );
2708: x_return_status := 'E';
2709: RAISE FND_API.G_EXC_ERROR;
2710: WHEN OTHERS THEN
2711: null;
2712: END;
2713: ELSE

Line 2759: RAISE FND_API.G_EXC_ERROR;

2755: p_msg_name => 'PA_SETUP_INV_SPEC',
2756: p_token1 => 'SPECIFICATION',
2757: p_value1 => p_limiting_value );
2758: x_return_status := 'E';
2759: RAISE FND_API.G_EXC_ERROR;
2760: WHEN OTHERS THEN
2761: null;
2762: END;
2763: END IF; --<< field_name <> 'CLASSIFICATION' >>

Line 2801: x_return_status := FND_API.G_RET_STS_SUCCESS;

2797: );
2798: END IF;
2799: CLOSE cur_overrides;
2800:
2801: x_return_status := FND_API.G_RET_STS_SUCCESS;
2802:
2803: IF (p_commit = FND_API.G_TRUE) THEN
2804: COMMIT;
2805: END IF;

Line 2803: IF (p_commit = FND_API.G_TRUE) THEN

2799: CLOSE cur_overrides;
2800:
2801: x_return_status := FND_API.G_RET_STS_SUCCESS;
2802:
2803: IF (p_commit = FND_API.G_TRUE) THEN
2804: COMMIT;
2805: END IF;
2806:
2807: IF (p_debug_mode = 'Y') THEN

Line 2811: when FND_API.G_EXC_ERROR then

2807: IF (p_debug_mode = 'Y') THEN
2808: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field END');
2809: END IF;
2810: EXCEPTION
2811: when FND_API.G_EXC_ERROR then
2812: if p_commit = FND_API.G_TRUE then
2813: rollback to Add_Quick_Entry_Field;
2814: end if;
2815: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2812: if p_commit = FND_API.G_TRUE then

2808: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field END');
2809: END IF;
2810: EXCEPTION
2811: when FND_API.G_EXC_ERROR then
2812: if p_commit = FND_API.G_TRUE then
2813: rollback to Add_Quick_Entry_Field;
2814: end if;
2815: x_return_status := FND_API.G_RET_STS_ERROR;
2816: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2815: x_return_status := FND_API.G_RET_STS_ERROR;

2811: when FND_API.G_EXC_ERROR then
2812: if p_commit = FND_API.G_TRUE then
2813: rollback to Add_Quick_Entry_Field;
2814: end if;
2815: x_return_status := FND_API.G_RET_STS_ERROR;
2816: when FND_API.G_EXC_UNEXPECTED_ERROR then
2817: if p_commit = FND_API.G_TRUE then
2818: rollback to Add_Quick_Entry_Field;
2819: end if;

Line 2816: when FND_API.G_EXC_UNEXPECTED_ERROR then

2812: if p_commit = FND_API.G_TRUE then
2813: rollback to Add_Quick_Entry_Field;
2814: end if;
2815: x_return_status := FND_API.G_RET_STS_ERROR;
2816: when FND_API.G_EXC_UNEXPECTED_ERROR then
2817: if p_commit = FND_API.G_TRUE then
2818: rollback to Add_Quick_Entry_Field;
2819: end if;
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2817: if p_commit = FND_API.G_TRUE then

2813: rollback to Add_Quick_Entry_Field;
2814: end if;
2815: x_return_status := FND_API.G_RET_STS_ERROR;
2816: when FND_API.G_EXC_UNEXPECTED_ERROR then
2817: if p_commit = FND_API.G_TRUE then
2818: rollback to Add_Quick_Entry_Field;
2819: end if;
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2816: when FND_API.G_EXC_UNEXPECTED_ERROR then
2817: if p_commit = FND_API.G_TRUE then
2818: rollback to Add_Quick_Entry_Field;
2819: end if;
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2822: p_procedure_name => 'Add_Quick_Entry_Field',
2823: p_error_text => SUBSTRB(SQLERRM,1,240));
2824: when OTHERS then

Line 2825: if p_commit = FND_API.G_TRUE then

2821: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2822: p_procedure_name => 'Add_Quick_Entry_Field',
2823: p_error_text => SUBSTRB(SQLERRM,1,240));
2824: when OTHERS then
2825: if p_commit = FND_API.G_TRUE then
2826: rollback to Add_Quick_Entry_Field;
2827: end if;
2828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 2828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2824: when OTHERS then
2825: if p_commit = FND_API.G_TRUE then
2826: rollback to Add_Quick_Entry_Field;
2827: end if;
2828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2830: p_procedure_name => 'Add_Quick_Entry_Field',
2831: p_error_text => SUBSTRB(SQLERRM,1,240));
2832: raise;

Line 2850: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

2846: -- p_required_flag IN VARCHAR2 := 'N',--
2847:
2848: PROCEDURE Update_Quick_Entry_Field(
2849: p_api_version IN NUMBER :=1.0,
2850: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2851: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2852: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2853: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2854: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

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

2847:
2848: PROCEDURE Update_Quick_Entry_Field(
2849: p_api_version IN NUMBER :=1.0,
2850: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2851: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2852: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2853: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2854: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2855: p_debug_mode IN VARCHAR2 :='N',

Line 2852: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

2848: PROCEDURE Update_Quick_Entry_Field(
2849: p_api_version IN NUMBER :=1.0,
2850: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2851: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2852: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2853: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2854: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2855: p_debug_mode IN VARCHAR2 :='N',
2856: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 2853: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

2849: p_api_version IN NUMBER :=1.0,
2850: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
2851: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2852: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
2853: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2854: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
2855: p_debug_mode IN VARCHAR2 :='N',
2856: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
2857: p_project_id IN NUMBER ,

Line 2907: IF (p_commit = FND_API.G_TRUE) THEN

2903: IF (p_debug_mode = 'Y') THEN
2904: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field begin');
2905: END IF;
2906:
2907: IF (p_commit = FND_API.G_TRUE) THEN
2908: savepoint Update_Quick_Entry_Field;
2909: END IF;
2910:
2911: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 2911: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

2907: IF (p_commit = FND_API.G_TRUE) THEN
2908: savepoint Update_Quick_Entry_Field;
2909: END IF;
2910:
2911: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2913: END IF;
2914:
2915: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 2912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2908: savepoint Update_Quick_Entry_Field;
2909: END IF;
2910:
2911: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2913: END IF;
2914:
2915: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2916: FND_MSG_PUB.initialize;

Line 2915: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

2911: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
2912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2913: END IF;
2914:
2915: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2916: FND_MSG_PUB.initialize;
2917: END IF;
2918:
2919: --cant update Project Number or Proejct Name

Line 2927: RAISE FND_API.G_EXC_ERROR;

2923: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2924: p_msg_name => 'PA_SETUP_CANT_MODFY_OVER' );
2925: x_msg_data := 'PA_SETUP_CANT_MODFY_OVER';
2926: x_return_status := 'E';
2927: RAISE FND_API.G_EXC_ERROR;
2928: END IF;
2929:
2930: --check sort order unique
2931: OPEN cur_chk_sort_order;

Line 2940: RAISE FND_API.G_EXC_ERROR;

2936: p_msg_name => 'PA_SETUP_SORT_ORDER_NOT_UNIQ' );
2937: x_msg_data := 'PA_SETUP_SORT_ORDER_NOT_UNIQ';
2938: x_return_status := 'E';
2939: CLOSE cur_chk_sort_order;
2940: RAISE FND_API.G_EXC_ERROR;
2941: ELSE
2942: CLOSE cur_chk_sort_order;
2943: END IF;
2944:

Line 2957: RAISE FND_API.G_EXC_ERROR;

2953: p_msg_name => 'PA_SETUP_DUP_QUICK_ENTRY' );
2954: x_msg_data := 'PA_SETUP_DUP_QUICK_ENTRY';
2955: x_return_status := 'E';
2956: CLOSE cur_dup_quick_entry;
2957: RAISE FND_API.G_EXC_ERROR;
2958: ELSE
2959: CLOSE cur_dup_quick_entry;
2960: END IF;
2961: ELSE

Line 2976: RAISE FND_API.G_EXC_ERROR;

2972: x_msg_data := 'PA_SETUP_INV_FIELD_NAME';
2973: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2974: p_msg_name => 'PA_SETUP_INV_FIELD_NAME');
2975: x_return_status := 'E';
2976: RAISE FND_API.G_EXC_ERROR;
2977: WHEN OTHERS THEN
2978: null;
2979: END;
2980:

Line 2987: RAISE FND_API.G_EXC_ERROR;

2983: p_token1 => 'FIELD_NAME',
2984: p_value1 => l_field_name_meaning );
2985: x_msg_data := 'PA_SETUP_SPEC_REQ';
2986: x_return_status := 'E';
2987: RAISE FND_API.G_EXC_ERROR;
2988: ELSE
2989: IF p_field_name <> 'CLASSIFICATION'
2990: THEN
2991: BEGIN

Line 3005: RAISE FND_API.G_EXC_ERROR;

3001: p_msg_name => 'PA_SETUP_INV_SPEC',
3002: p_token1 => 'SPECIFICATION',
3003: p_value1 => p_limiting_value );
3004: x_return_status := 'E';
3005: RAISE FND_API.G_EXC_ERROR;
3006: WHEN OTHERS THEN
3007: null;
3008: END;
3009: ELSE

Line 3055: RAISE FND_API.G_EXC_ERROR;

3051: p_msg_name => 'PA_SETUP_INV_SPEC',
3052: p_token1 => 'SPECIFICATION',
3053: p_value1 => p_limiting_value );
3054: x_return_status := 'E';
3055: RAISE FND_API.G_EXC_ERROR;
3056: WHEN OTHERS THEN
3057: null;
3058: END;
3059: END IF;

Line 3075: x_return_status := FND_API.G_RET_STS_SUCCESS;

3071: MANDATORY_FLAG = p_required_flag ,
3072: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 1 ) + 1
3073: WHERE rowid = p_row_id;
3074:
3075: x_return_status := FND_API.G_RET_STS_SUCCESS;
3076:
3077: IF (p_commit = FND_API.G_TRUE) THEN
3078: COMMIT;
3079: END IF;

Line 3077: IF (p_commit = FND_API.G_TRUE) THEN

3073: WHERE rowid = p_row_id;
3074:
3075: x_return_status := FND_API.G_RET_STS_SUCCESS;
3076:
3077: IF (p_commit = FND_API.G_TRUE) THEN
3078: COMMIT;
3079: END IF;
3080:
3081: IF (p_debug_mode = 'Y') THEN

Line 3085: when FND_API.G_EXC_ERROR then

3081: IF (p_debug_mode = 'Y') THEN
3082: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field END');
3083: END IF;
3084: EXCEPTION
3085: when FND_API.G_EXC_ERROR then
3086: if p_commit = FND_API.G_TRUE then
3087: rollback to Update_Quick_Entry_Field;
3088: end if;
3089: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3086: if p_commit = FND_API.G_TRUE then

3082: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field END');
3083: END IF;
3084: EXCEPTION
3085: when FND_API.G_EXC_ERROR then
3086: if p_commit = FND_API.G_TRUE then
3087: rollback to Update_Quick_Entry_Field;
3088: end if;
3089: x_return_status := FND_API.G_RET_STS_ERROR;
3090: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 3089: x_return_status := FND_API.G_RET_STS_ERROR;

3085: when FND_API.G_EXC_ERROR then
3086: if p_commit = FND_API.G_TRUE then
3087: rollback to Update_Quick_Entry_Field;
3088: end if;
3089: x_return_status := FND_API.G_RET_STS_ERROR;
3090: when FND_API.G_EXC_UNEXPECTED_ERROR then
3091: if p_commit = FND_API.G_TRUE then
3092: rollback to Update_Quick_Entry_Field;
3093: end if;

Line 3090: when FND_API.G_EXC_UNEXPECTED_ERROR then

3086: if p_commit = FND_API.G_TRUE then
3087: rollback to Update_Quick_Entry_Field;
3088: end if;
3089: x_return_status := FND_API.G_RET_STS_ERROR;
3090: when FND_API.G_EXC_UNEXPECTED_ERROR then
3091: if p_commit = FND_API.G_TRUE then
3092: rollback to Update_Quick_Entry_Field;
3093: end if;
3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3091: if p_commit = FND_API.G_TRUE then

3087: rollback to Update_Quick_Entry_Field;
3088: end if;
3089: x_return_status := FND_API.G_RET_STS_ERROR;
3090: when FND_API.G_EXC_UNEXPECTED_ERROR then
3091: if p_commit = FND_API.G_TRUE then
3092: rollback to Update_Quick_Entry_Field;
3093: end if;
3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3095: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3090: when FND_API.G_EXC_UNEXPECTED_ERROR then
3091: if p_commit = FND_API.G_TRUE then
3092: rollback to Update_Quick_Entry_Field;
3093: end if;
3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3095: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3096: p_procedure_name => 'Update_Quick_Entry_Field',
3097: p_error_text => SUBSTRB(SQLERRM,1,240));
3098: when OTHERS then

Line 3099: if p_commit = FND_API.G_TRUE then

3095: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3096: p_procedure_name => 'Update_Quick_Entry_Field',
3097: p_error_text => SUBSTRB(SQLERRM,1,240));
3098: when OTHERS then
3099: if p_commit = FND_API.G_TRUE then
3100: rollback to Update_Quick_Entry_Field;
3101: end if;
3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3103: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3098: when OTHERS then
3099: if p_commit = FND_API.G_TRUE then
3100: rollback to Update_Quick_Entry_Field;
3101: end if;
3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3103: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3104: p_procedure_name => 'Update_Quick_Entry_Field',
3105: p_error_text => SUBSTRB(SQLERRM,1,240));
3106: raise;

Line 3124: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

3120: -- p_required_flag IN VARCHAR2 := 'N',--
3121:
3122: PROCEDURE Delete_Quick_Entry_Field(
3123: p_api_version IN NUMBER :=1.0,
3124: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
3125: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
3126: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
3127: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
3128: p_calling_module IN VARCHAR2 :='SELF_SERVICE',

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

3121:
3122: PROCEDURE Delete_Quick_Entry_Field(
3123: p_api_version IN NUMBER :=1.0,
3124: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
3125: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
3126: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
3127: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
3128: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
3129: p_debug_mode IN VARCHAR2 :='N',

Line 3126: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,

3122: PROCEDURE Delete_Quick_Entry_Field(
3123: p_api_version IN NUMBER :=1.0,
3124: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
3125: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
3126: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
3127: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
3128: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
3129: p_debug_mode IN VARCHAR2 :='N',
3130: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 3127: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

3123: p_api_version IN NUMBER :=1.0,
3124: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
3125: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
3126: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
3127: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
3128: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
3129: p_debug_mode IN VARCHAR2 :='N',
3130: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3131: p_project_id IN NUMBER ,

Line 3168: IF (p_commit = FND_API.G_TRUE) THEN

3164: IF (p_debug_mode = 'Y') THEN
3165: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field begin');
3166: END IF;
3167:
3168: IF (p_commit = FND_API.G_TRUE) THEN
3169: savepoint Delete_Quick_Entry_Field;
3170: END IF;
3171:
3172: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 3172: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

3168: IF (p_commit = FND_API.G_TRUE) THEN
3169: savepoint Delete_Quick_Entry_Field;
3170: END IF;
3171:
3172: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
3173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3174: END IF;
3175:
3176: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 3173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3169: savepoint Delete_Quick_Entry_Field;
3170: END IF;
3171:
3172: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
3173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3174: END IF;
3175:
3176: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3177: FND_MSG_PUB.initialize;

Line 3176: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

3172: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
3173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3174: END IF;
3175:
3176: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3177: FND_MSG_PUB.initialize;
3178: END IF;
3179:
3180: OPEN cur_chk_dflt_qe;

Line 3191: RAISE FND_API.G_EXC_ERROR;

3187: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3188: p_msg_name => 'PA_SETUP_CANT_MODFY_OVER' );
3189: x_msg_data := 'PA_SETUP_CANT_MODFY_OVER';
3190: x_return_status := 'E';
3191: RAISE FND_API.G_EXC_ERROR;
3192: END IF;
3193:
3194: DELETE FROM pa_project_copy_overrides
3195: WHERE rowid = p_row_id;

Line 3197: x_return_status := FND_API.G_RET_STS_SUCCESS;

3193:
3194: DELETE FROM pa_project_copy_overrides
3195: WHERE rowid = p_row_id;
3196:
3197: x_return_status := FND_API.G_RET_STS_SUCCESS;
3198:
3199: IF (p_commit = FND_API.G_TRUE) THEN
3200: COMMIT;
3201: END IF;

Line 3199: IF (p_commit = FND_API.G_TRUE) THEN

3195: WHERE rowid = p_row_id;
3196:
3197: x_return_status := FND_API.G_RET_STS_SUCCESS;
3198:
3199: IF (p_commit = FND_API.G_TRUE) THEN
3200: COMMIT;
3201: END IF;
3202:
3203: IF (p_debug_mode = 'Y') THEN

Line 3207: when FND_API.G_EXC_ERROR then

3203: IF (p_debug_mode = 'Y') THEN
3204: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field END');
3205: END IF;
3206: EXCEPTION
3207: when FND_API.G_EXC_ERROR then
3208: if p_commit = FND_API.G_TRUE then
3209: rollback to Delete_Quick_Entry_Field;
3210: end if;
3211: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3208: if p_commit = FND_API.G_TRUE then

3204: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field END');
3205: END IF;
3206: EXCEPTION
3207: when FND_API.G_EXC_ERROR then
3208: if p_commit = FND_API.G_TRUE then
3209: rollback to Delete_Quick_Entry_Field;
3210: end if;
3211: x_return_status := FND_API.G_RET_STS_ERROR;
3212: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 3211: x_return_status := FND_API.G_RET_STS_ERROR;

3207: when FND_API.G_EXC_ERROR then
3208: if p_commit = FND_API.G_TRUE then
3209: rollback to Delete_Quick_Entry_Field;
3210: end if;
3211: x_return_status := FND_API.G_RET_STS_ERROR;
3212: when FND_API.G_EXC_UNEXPECTED_ERROR then
3213: if p_commit = FND_API.G_TRUE then
3214: rollback to Delete_Quick_Entry_Field;
3215: end if;

Line 3212: when FND_API.G_EXC_UNEXPECTED_ERROR then

3208: if p_commit = FND_API.G_TRUE then
3209: rollback to Delete_Quick_Entry_Field;
3210: end if;
3211: x_return_status := FND_API.G_RET_STS_ERROR;
3212: when FND_API.G_EXC_UNEXPECTED_ERROR then
3213: if p_commit = FND_API.G_TRUE then
3214: rollback to Delete_Quick_Entry_Field;
3215: end if;
3216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3213: if p_commit = FND_API.G_TRUE then

3209: rollback to Delete_Quick_Entry_Field;
3210: end if;
3211: x_return_status := FND_API.G_RET_STS_ERROR;
3212: when FND_API.G_EXC_UNEXPECTED_ERROR then
3213: if p_commit = FND_API.G_TRUE then
3214: rollback to Delete_Quick_Entry_Field;
3215: end if;
3216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 3216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3212: when FND_API.G_EXC_UNEXPECTED_ERROR then
3213: if p_commit = FND_API.G_TRUE then
3214: rollback to Delete_Quick_Entry_Field;
3215: end if;
3216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3218: p_procedure_name => 'Delete_Quick_Entry_Field',
3219: p_error_text => SUBSTRB(SQLERRM,1,240));
3220: when OTHERS then

Line 3221: if p_commit = FND_API.G_TRUE then

3217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3218: p_procedure_name => 'Delete_Quick_Entry_Field',
3219: p_error_text => SUBSTRB(SQLERRM,1,240));
3220: when OTHERS then
3221: if p_commit = FND_API.G_TRUE then
3222: rollback to Delete_Quick_Entry_Field;
3223: end if;
3224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3225: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

Line 3224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3220: when OTHERS then
3221: if p_commit = FND_API.G_TRUE then
3222: rollback to Delete_Quick_Entry_Field;
3223: end if;
3224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3225: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3226: p_procedure_name => 'Delete_Quick_Entry_Field',
3227: p_error_text => SUBSTRB(SQLERRM,1,240));
3228: raise;