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;
5701: hr_utility.raise_error;
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
5703: raise;
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;
5730: hr_utility.raise_error;
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
5732: if hr_multi_message.unexpected_error_add(c_proc) then
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
5732: if hr_multi_message.unexpected_error_add(c_proc) then
5733: hr_utility.set_location(' Leaving:' || c_proc,40);
5734: raise;
5735: end if;
5736: end;
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;
5747: hr_utility.raise_error;
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;
5749:
5849: -- check the transaction status
5850: if(lv_status in ('YS','RIS','ROS')) then
5851: -- saved transaction exists set the warning message
5852:
5853: if(hr_multi_message.is_message_list_enabled) then
5854: hr_utility.set_message(800,'HR_SS_SAVED_TXN_DATA_EXISTS');
5855: hr_multi_message.add( p_message_type => hr_multi_message.G_WARNING_MSG);
5856: hr_utility.set_warning;
5857: end if;
5851: -- saved transaction exists set the warning message
5852:
5853: if(hr_multi_message.is_message_list_enabled) then
5854: hr_utility.set_message(800,'HR_SS_SAVED_TXN_DATA_EXISTS');
5855: hr_multi_message.add( p_message_type => hr_multi_message.G_WARNING_MSG);
5856: hr_utility.set_warning;
5857: end if;
5858: end if;
5859: if(lv_state is not null) then
5858: end if;
5859: if(lv_state is not null) then
5860: -- in advertant saved transaction exists set the warning message
5861:
5862: if(hr_multi_message.is_message_list_enabled) then
5863: hr_utility.set_message(800,'HR_SS_INADV_TXN_DATA_EXISTS');
5864: hr_multi_message.add( p_message_type => hr_multi_message.G_WARNING_MSG);
5865: end if;
5866:
5860: -- in advertant saved transaction exists set the warning message
5861:
5862: if(hr_multi_message.is_message_list_enabled) then
5863: hr_utility.set_message(800,'HR_SS_INADV_TXN_DATA_EXISTS');
5864: hr_multi_message.add( p_message_type => hr_multi_message.G_WARNING_MSG);
5865: end if;
5866:
5867: end if;
5868: