571: function get_shift_name_for_display(
572: p_shift_num in number) return varchar2 is
573: l_shift_string varchar2(240);
574: begin
575: fnd_message.SET_NAME('WIP', 'WIP_WS_PTP_SHIFT_SINGLE');
576: fnd_message.SET_TOKEN('SHIFT_NUM', p_shift_num);
577: l_shift_string := fnd_message.GET;
578: return l_shift_string;
579:
572: p_shift_num in number) return varchar2 is
573: l_shift_string varchar2(240);
574: begin
575: fnd_message.SET_NAME('WIP', 'WIP_WS_PTP_SHIFT_SINGLE');
576: fnd_message.SET_TOKEN('SHIFT_NUM', p_shift_num);
577: l_shift_string := fnd_message.GET;
578: return l_shift_string;
579:
580: exception when others then
573: l_shift_string varchar2(240);
574: begin
575: fnd_message.SET_NAME('WIP', 'WIP_WS_PTP_SHIFT_SINGLE');
576: fnd_message.SET_TOKEN('SHIFT_NUM', p_shift_num);
577: l_shift_string := fnd_message.GET;
578: return l_shift_string;
579:
580: exception when others then
581: return to_char(p_shift_num);