750: IF p_validate_only = FND_API.G_FALSE AND
751: l_validate_status = FND_API.G_RET_STS_SUCCESS
752: THEN
753:
754: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES;
755:
756: --start the mass WF
757: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
758: p_mode => l_wf_mode
753:
754: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES;
755:
756: --start the mass WF
757: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
758: p_mode => l_wf_mode
759: ,p_project_id => p_project_id
760: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
761: ,p_assignment_id_tbl => p_assignment_id_tbl
756: --start the mass WF
757: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
758: p_mode => l_wf_mode
759: ,p_project_id => p_project_id
760: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
761: ,p_assignment_id_tbl => p_assignment_id_tbl
762: ,p_competence_id_tbl => l_competence_id_tbl
763: ,p_competence_name_tbl => p_competence_name_tbl
764: ,p_competence_alias_tbl => p_competence_alias_tbl
854: IF l_assignment_return_status <> FND_API.G_RET_STS_SUCCESS
855: THEN
856: ROLLBACK TO PROCESS_COMPETENCE_ELEMENTS;
857: PA_MESSAGE_UTILS.save_messages
858: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
859: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
860: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
861: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
862: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
855: THEN
856: ROLLBACK TO PROCESS_COMPETENCE_ELEMENTS;
857: PA_MESSAGE_UTILS.save_messages
858: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
859: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
860: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
861: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
862: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
863: p_context1 => p_project_id,
856: ROLLBACK TO PROCESS_COMPETENCE_ELEMENTS;
857: PA_MESSAGE_UTILS.save_messages
858: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
859: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
860: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
861: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
862: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
863: p_context1 => p_project_id,
864: p_context2 => p_assignment_tbl(I-1),
857: PA_MESSAGE_UTILS.save_messages
858: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
859: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
860: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
861: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
862: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
863: p_context1 => p_project_id,
864: p_context2 => p_assignment_tbl(I-1),
865: p_context3 => NULL,
858: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
859: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
860: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
861: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
862: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
863: p_context1 => p_project_id,
864: p_context2 => p_assignment_tbl(I-1),
865: p_context3 => NULL,
866: p_commit => FND_API.G_TRUE,
952: -- Check if the last assignment got updated
953: IF l_assignment_return_status <> FND_API.G_RET_STS_SUCCESS THEN
954: ROLLBACK TO PROCESS_COMPETENCE_ELEMENTS;
955: PA_MESSAGE_UTILS.save_messages
956: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
957: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
958: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
959: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
960: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
953: IF l_assignment_return_status <> FND_API.G_RET_STS_SUCCESS THEN
954: ROLLBACK TO PROCESS_COMPETENCE_ELEMENTS;
955: PA_MESSAGE_UTILS.save_messages
956: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
957: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
958: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
959: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
960: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
961: p_context1 => p_project_id,
954: ROLLBACK TO PROCESS_COMPETENCE_ELEMENTS;
955: PA_MESSAGE_UTILS.save_messages
956: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
957: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
958: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
959: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
960: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
961: p_context1 => p_project_id,
962: p_context2 => p_assignment_tbl(p_assignment_tbl.count),
955: PA_MESSAGE_UTILS.save_messages
956: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
957: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
958: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
959: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
960: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
961: p_context1 => p_project_id,
962: p_context2 => p_assignment_tbl(p_assignment_tbl.count),
963: p_context3 => NULL,
956: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
957: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
958: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES,
959: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
960: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
961: p_context1 => p_project_id,
962: p_context2 => p_assignment_tbl(p_assignment_tbl.count),
963: p_context3 => NULL,
964: p_commit => FND_API.G_TRUE,