446: IF( p_lifecycle_version_id IS NOT NULL ) and (p_lifecycle_version_id <> FND_API.G_MISS_NUM) AND (l_lifecycle_version_id IS NOT NULL) AND (l_lifecycle_version_id <> p_lifecycle_version_id) THEN
447:
448: /* Bug2760719 -- Added code to populate error message */
449:
450: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
451: p_msg_name => 'PA_LCYL_TRACKING_PROJ');
452:
453:
454: l_msg_count := FND_MSG_PUB.count_msg;
475: AND record_version_number = p_record_version_number
476: FOR UPDATE OF record_version_number NOWAIT;
477: EXCEPTION
478: when TIMEOUT_ON_RESOURCE then
479: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
480: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
481: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
482: when NO_DATA_FOUND then
483: if p_calling_module = 'FORM' then
480: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
481: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
482: when NO_DATA_FOUND then
483: if p_calling_module = 'FORM' then
484: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
485: p_msg_name => 'FORM_RECORD_CHANGED');
486: l_msg_data := 'FORM_RECORD_CHANGED';
487: else
488: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
484: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
485: p_msg_name => 'FORM_RECORD_CHANGED');
486: l_msg_data := 'FORM_RECORD_CHANGED';
487: else
488: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
489: p_msg_name => 'PA_XC_RECORD_CHANGED');
490: l_msg_data := 'PA_XC_RECORD_CHANGED';
491: end if;
492: when OTHERS then
490: l_msg_data := 'PA_XC_RECORD_CHANGED';
491: end if;
492: when OTHERS then
493: if SQLCODE = -54 then
494: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
495: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
496: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
497: else
498: raise;
507: AND record_version_number = p_record_version_number;
508: EXCEPTION
509: when NO_DATA_FOUND then
510: if p_calling_module = 'FORM' then
511: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
512: p_msg_name => 'FORM_RECORD_CHANGED');
513: l_msg_data := 'FORM_RECORD_CHANGED'; else
514: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
515: p_msg_name => 'PA_XC_RECORD_CHANGED');
510: if p_calling_module = 'FORM' then
511: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
512: p_msg_name => 'FORM_RECORD_CHANGED');
513: l_msg_data := 'FORM_RECORD_CHANGED'; else
514: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
515: p_msg_name => 'PA_XC_RECORD_CHANGED');
516: l_msg_data := 'PA_XC_RECORD_CHANGED';
517: end if;
518: when OTHERS then
611:
612: /* Bug2760719 -- Added code to populate error message */
613:
614: IF l_policy_code IN ('CHANGE_ORDER_REQUIRED','NOT_ALLOWED') THEN -- bug 3423005
615: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'EGO',
616: p_msg_name => l_error_message);
617: END IF;
618:
619: IF l_policy_code IN ('CHANGE_ORDER_REQUIRED','NOT_ALLOWED') OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN -- bug 3423005
690: l_dep_in_summary := PA_PROJECT_STRUCTURE_UTILS.Check_Struct_Has_Dep(l_structure_version_id);
691:
692: IF (l_dep_in_summary = 'Y') THEN
693: CLOSE c_get_struc_versions;
694: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
695: p_msg_name => 'PA_DEP_ON_SUMM_TSK');
696: l_msg_count := FND_MSG_PUB.count_msg;
697: IF l_msg_count > 0 THEN
698: x_msg_count := l_msg_count;
906: WHERE proj_element_id = p_proj_element_id
907: FOR UPDATE OF record_version_number NOWAIT;
908: EXCEPTION
909: when TIMEOUT_ON_RESOURCE then
910: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
911: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
912: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
913: when NO_DATA_FOUND then
914: if p_calling_module = 'FORM' then
911: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
912: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
913: when NO_DATA_FOUND then
914: if p_calling_module = 'FORM' then
915: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
916: p_msg_name => 'FORM_RECORD_CHANGED');
917: l_msg_data := 'FORM_RECORD_CHANGED';
918: else
919: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
915: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
916: p_msg_name => 'FORM_RECORD_CHANGED');
917: l_msg_data := 'FORM_RECORD_CHANGED';
918: else
919: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
920: p_msg_name => 'PA_XC_RECORD_CHANGED');
921: l_msg_data := 'PA_XC_RECORD_CHANGED';
922: end if;
923: when OTHERS then
921: l_msg_data := 'PA_XC_RECORD_CHANGED';
922: end if;
923: when OTHERS then
924: if SQLCODE = -54 then
925: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
926: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
927: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
928: else
929: raise;
936: WHERE proj_element_id = p_proj_element_id;
937: EXCEPTION
938: when NO_DATA_FOUND then
939: if p_calling_module = 'FORM' then
940: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
941: p_msg_name => 'FORM_RECORD_CHANGED');
942: l_msg_data := 'FORM_RECORD_CHANGED';
943: else
944: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
940: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
941: p_msg_name => 'FORM_RECORD_CHANGED');
942: l_msg_data := 'FORM_RECORD_CHANGED';
943: else
944: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
945: p_msg_name => 'PA_XC_RECORD_CHANGED');
946: l_msg_data := 'PA_XC_RECORD_CHANGED';
947: end if;
948: when OTHERS then
1064: AND record_version_number = p_record_version_number
1065: FOR UPDATE OF record_version_number NOWAIT;
1066: EXCEPTION
1067: when TIMEOUT_ON_RESOURCE then
1068: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1069: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1070: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1071: when NO_DATA_FOUND then
1072: if p_calling_module = 'FORM' then
1069: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1070: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1071: when NO_DATA_FOUND then
1072: if p_calling_module = 'FORM' then
1073: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1074: p_msg_name => 'FORM_RECORD_CHANGED');
1075: l_msg_data := 'FORM_RECORD_CHANGED';
1076: else
1077: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1073: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1074: p_msg_name => 'FORM_RECORD_CHANGED');
1075: l_msg_data := 'FORM_RECORD_CHANGED';
1076: else
1077: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1078: p_msg_name => 'PA_XC_RECORD_CHANGED');
1079: l_msg_data := 'PA_XC_RECORD_CHANGED';
1080: end if;
1081: when OTHERS then
1079: l_msg_data := 'PA_XC_RECORD_CHANGED';
1080: end if;
1081: when OTHERS then
1082: if SQLCODE = -54 then
1083: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1084: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1085: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1086: else
1087: raise;
1095: AND record_version_number = p_record_version_number;
1096: EXCEPTION
1097: when NO_DATA_FOUND then
1098: if p_calling_module = 'FORM' then
1099: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1100: p_msg_name => 'FORM_RECORD_CHANGED');
1101: l_msg_data := 'FORM_RECORD_CHANGED';
1102: else
1103: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1099: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1100: p_msg_name => 'FORM_RECORD_CHANGED');
1101: l_msg_data := 'FORM_RECORD_CHANGED';
1102: else
1103: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1104: p_msg_name => 'PA_XC_RECORD_CHANGED');
1105: l_msg_data := 'PA_XC_RECORD_CHANGED';
1106: end if;
1107: when OTHERS then