264: ----------------------------------------------------------------------------------------------
265: -- If this is for Mass schedule update, call Mass Transaction Workflow.
266: IF (p_mass_update_flag = FND_API.G_TRUE AND p_last_row_flag = 'Y') THEN
267: --start the mass WF
268: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
269: p_mode => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE
270: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
271: ,p_project_id => p_project_id
272: ,p_exception_type_code => p_exception_type_code
265: -- If this is for Mass schedule update, call Mass Transaction Workflow.
266: IF (p_mass_update_flag = FND_API.G_TRUE AND p_last_row_flag = 'Y') THEN
267: --start the mass WF
268: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
269: p_mode => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE
270: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
271: ,p_project_id => p_project_id
272: ,p_exception_type_code => p_exception_type_code
273: ,p_assignment_id_tbl => p_assignment_id_array
266: IF (p_mass_update_flag = FND_API.G_TRUE AND p_last_row_flag = 'Y') THEN
267: --start the mass WF
268: PA_MASS_ASGMT_TRX.Start_Mass_Asgmt_Trx_Wf(
269: p_mode => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE
270: ,p_action => PA_MASS_ASGMT_TRX.G_SAVE
271: ,p_project_id => p_project_id
272: ,p_exception_type_code => p_exception_type_code
273: ,p_assignment_id_tbl => p_assignment_id_array
274: ,p_change_start_date => p_change_start_date
868:
869: -- save the error message to the proper table so that we can retrive them later
870: -- from workflow notification page.
871: PA_MESSAGE_UTILS.save_messages
872: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
873: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
874: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
875: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
876: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
869: -- save the error message to the proper table so that we can retrive them later
870: -- from workflow notification page.
871: PA_MESSAGE_UTILS.save_messages
872: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
873: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
874: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
875: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
876: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
877: p_context1 => p_project_id,
870: -- from workflow notification page.
871: PA_MESSAGE_UTILS.save_messages
872: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
873: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
874: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
875: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
876: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
877: p_context1 => p_project_id,
878: p_context2 => p_assignment_id_array(i),
871: PA_MESSAGE_UTILS.save_messages
872: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
873: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
874: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
875: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
876: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
877: p_context1 => p_project_id,
878: p_context2 => p_assignment_id_array(i),
879: p_context3 => NULL,
872: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
873: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
874: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
875: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
876: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
877: p_context1 => p_project_id,
878: p_context2 => p_assignment_id_array(i),
879: p_context3 => NULL,
880: p_commit => FND_API.G_TRUE,
883: WHEN FND_API.G_EXC_ERROR THEN
884: -- save the error message to the proper table so that we can retrive them later
885: -- from workflow notification page.
886: PA_MESSAGE_UTILS.save_messages
887: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
888: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
889: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
890: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
891: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
884: -- save the error message to the proper table so that we can retrive them later
885: -- from workflow notification page.
886: PA_MESSAGE_UTILS.save_messages
887: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
888: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
889: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
890: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
891: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
892: p_context1 => p_project_id,
885: -- from workflow notification page.
886: PA_MESSAGE_UTILS.save_messages
887: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
888: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
889: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
890: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
891: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
892: p_context1 => p_project_id,
893: p_context2 => p_assignment_id_array(i),
886: PA_MESSAGE_UTILS.save_messages
887: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
888: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
889: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
890: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
891: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
892: p_context1 => p_project_id,
893: p_context2 => p_assignment_id_array(i),
894: p_context3 => NULL,
887: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
888: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,
889: p_source_type2 => PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE,
890: p_source_identifier1 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_TYPE,
891: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
892: p_context1 => p_project_id,
893: p_context2 => p_assignment_id_array(i),
894: p_context3 => NULL,
895: p_commit => FND_API.G_TRUE,