5311: end if;
5312:
5313: exception
5314: WHEN g_invalid_responsibility THEN
5315: fnd_message.set_name('PER','HR_SSA_INVALID_RESPONSIBILITY');
5316: hr_utility.raise_error;
5317: when g_wf_error_state then
5318: -- HR_WF_TRANSACTION_ERROR_SS
5319: fnd_message.set_name('PER','HR_WF_TRANSACTION_ERROR_SS');
5315: fnd_message.set_name('PER','HR_SSA_INVALID_RESPONSIBILITY');
5316: hr_utility.raise_error;
5317: when g_wf_error_state then
5318: -- HR_WF_TRANSACTION_ERROR_SS
5319: fnd_message.set_name('PER','HR_WF_TRANSACTION_ERROR_SS');
5320: fnd_message.set_token('ERRORMSG',p_error_message,true);
5321: fnd_message.set_token('ERRORSTACK',p_errstack,true);
5322: hr_utility.raise_error;
5323: when g_no_transaction_id then
5316: hr_utility.raise_error;
5317: when g_wf_error_state then
5318: -- HR_WF_TRANSACTION_ERROR_SS
5319: fnd_message.set_name('PER','HR_WF_TRANSACTION_ERROR_SS');
5320: fnd_message.set_token('ERRORMSG',p_error_message,true);
5321: fnd_message.set_token('ERRORSTACK',p_errstack,true);
5322: hr_utility.raise_error;
5323: when g_no_transaction_id then
5324: null;
5317: when g_wf_error_state then
5318: -- HR_WF_TRANSACTION_ERROR_SS
5319: fnd_message.set_name('PER','HR_WF_TRANSACTION_ERROR_SS');
5320: fnd_message.set_token('ERRORMSG',p_error_message,true);
5321: fnd_message.set_token('ERRORSTACK',p_errstack,true);
5322: hr_utility.raise_error;
5323: when g_no_transaction_id then
5324: null;
5325: -- handle the proper error message propagation
5692: from hr_api_transactions
5693: where transaction_id=p_transaction_id;
5694: exception
5695: when no_data_found then
5696: -- get the fnd message and populate to the fnd message pub
5697: if(hr_multi_message.is_message_list_enabled) then
5698: fnd_message.set_name('PER', 'HR_SS_NO_TXN_DATA');
5699: hr_multi_message.add(p_message_type => hr_multi_message.G_ERROR_MSG );
5700: end if;
5694: exception
5695: when no_data_found then
5696: -- get the fnd message and populate to the fnd message pub
5697: if(hr_multi_message.is_message_list_enabled) then
5698: fnd_message.set_name('PER', 'HR_SS_NO_TXN_DATA');
5699: hr_multi_message.add(p_message_type => hr_multi_message.G_ERROR_MSG );
5700: end if;
5701: hr_utility.raise_error;
5702: when others then
5721: end if;
5722:
5723: exception
5724: when g_wf_not_initialzed then
5725: -- get the fnd message and populate to the fnd message pub
5726: if(hr_multi_message.is_message_list_enabled) then
5727: fnd_message.set_name('PER', 'HR_SS_WF_NOT_INITIALZED');
5728: hr_multi_message.add(p_message_type => hr_multi_message.G_ERROR_MSG );
5729: end if;
5723: exception
5724: when g_wf_not_initialzed then
5725: -- get the fnd message and populate to the fnd message pub
5726: if(hr_multi_message.is_message_list_enabled) then
5727: fnd_message.set_name('PER', 'HR_SS_WF_NOT_INITIALZED');
5728: hr_multi_message.add(p_message_type => hr_multi_message.G_ERROR_MSG );
5729: end if;
5730: hr_utility.raise_error;
5731: when others then
5738: -- finally close the sfl open notifications if any
5739: hr_sflutil_ss.closeopensflnotification(p_transaction_id);
5740:
5741: else
5742: -- get the fnd message and populate to the fnd message pub
5743: if(hr_multi_message.is_message_list_enabled) then
5744: fnd_message.set_name('PER', 'HR_SS_NULL_TXN_ID');
5745: hr_multi_message.add(p_message_type => hr_multi_message.G_ERROR_MSG );
5746: end if;
5740:
5741: else
5742: -- get the fnd message and populate to the fnd message pub
5743: if(hr_multi_message.is_message_list_enabled) then
5744: fnd_message.set_name('PER', 'HR_SS_NULL_TXN_ID');
5745: hr_multi_message.add(p_message_type => hr_multi_message.G_ERROR_MSG );
5746: end if;
5747: hr_utility.raise_error;
5748: end if;
5955:
5956: if(lv_ntf_sub_msg is null) then
5957: lv_process_display_name := hr_workflow_ss.getProcessDisplayName(p_item_type,p_item_key);
5958: else
5959: fnd_message.set_name('PER',lv_ntf_sub_msg);
5960: lv_process_display_name:= fnd_message.get;
5961: end if;
5962:
5963: exception
5956: if(lv_ntf_sub_msg is null) then
5957: lv_process_display_name := hr_workflow_ss.getProcessDisplayName(p_item_type,p_item_key);
5958: else
5959: fnd_message.set_name('PER',lv_ntf_sub_msg);
5960: lv_process_display_name:= fnd_message.get;
5961: end if;
5962:
5963: exception
5964: when others then