307: --
308: if csr_valid_lookup%NOTFOUND then
309: close csr_valid_lookup;
310: if p_batch_line_status in ('V','T') then
311: pay_core_utils.push_message (800,'HR_449107_BEE_UPG_LK_NONE','A');
312: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
313: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
314: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
315: pay_core_utils.push_token ('UOM', p_uom_value);
308: if csr_valid_lookup%NOTFOUND then
309: close csr_valid_lookup;
310: if p_batch_line_status in ('V','T') then
311: pay_core_utils.push_message (800,'HR_449107_BEE_UPG_LK_NONE','A');
312: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
313: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
314: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
315: pay_core_utils.push_token ('UOM', p_uom_value);
316: pay_core_utils.push_token ('VALUE', l_display_value);
309: close csr_valid_lookup;
310: if p_batch_line_status in ('V','T') then
311: pay_core_utils.push_message (800,'HR_449107_BEE_UPG_LK_NONE','A');
312: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
313: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
314: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
315: pay_core_utils.push_token ('UOM', p_uom_value);
316: pay_core_utils.push_token ('VALUE', l_display_value);
317: --hr_utility.raise_error;
310: if p_batch_line_status in ('V','T') then
311: pay_core_utils.push_message (800,'HR_449107_BEE_UPG_LK_NONE','A');
312: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
313: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
314: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
315: pay_core_utils.push_token ('UOM', p_uom_value);
316: pay_core_utils.push_token ('VALUE', l_display_value);
317: --hr_utility.raise_error;
318: raise lov_error;
311: pay_core_utils.push_message (800,'HR_449107_BEE_UPG_LK_NONE','A');
312: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
313: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
314: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
315: pay_core_utils.push_token ('UOM', p_uom_value);
316: pay_core_utils.push_token ('VALUE', l_display_value);
317: --hr_utility.raise_error;
318: raise lov_error;
319: else
312: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
313: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
314: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
315: pay_core_utils.push_token ('UOM', p_uom_value);
316: pay_core_utils.push_token ('VALUE', l_display_value);
317: --hr_utility.raise_error;
318: raise lov_error;
319: else
320: l_formatted_value := p_input_value;
325: --
326: if csr_valid_lookup%FOUND then
327: close csr_valid_lookup;
328: if p_batch_line_status in ('V','T') then
329: pay_core_utils.push_message (800,'HR_449108_BEE_UPG_LK_MANY','A');
330: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
331: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
332: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
333: pay_core_utils.push_token ('UOM', p_uom_value);
326: if csr_valid_lookup%FOUND then
327: close csr_valid_lookup;
328: if p_batch_line_status in ('V','T') then
329: pay_core_utils.push_message (800,'HR_449108_BEE_UPG_LK_MANY','A');
330: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
331: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
332: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
333: pay_core_utils.push_token ('UOM', p_uom_value);
334: pay_core_utils.push_token ('VALUE', l_display_value);
327: close csr_valid_lookup;
328: if p_batch_line_status in ('V','T') then
329: pay_core_utils.push_message (800,'HR_449108_BEE_UPG_LK_MANY','A');
330: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
331: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
332: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
333: pay_core_utils.push_token ('UOM', p_uom_value);
334: pay_core_utils.push_token ('VALUE', l_display_value);
335: --hr_utility.raise_error;
328: if p_batch_line_status in ('V','T') then
329: pay_core_utils.push_message (800,'HR_449108_BEE_UPG_LK_MANY','A');
330: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
331: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
332: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
333: pay_core_utils.push_token ('UOM', p_uom_value);
334: pay_core_utils.push_token ('VALUE', l_display_value);
335: --hr_utility.raise_error;
336: raise lov_error;
329: pay_core_utils.push_message (800,'HR_449108_BEE_UPG_LK_MANY','A');
330: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
331: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
332: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
333: pay_core_utils.push_token ('UOM', p_uom_value);
334: pay_core_utils.push_token ('VALUE', l_display_value);
335: --hr_utility.raise_error;
336: raise lov_error;
337: else
330: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
331: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
332: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
333: pay_core_utils.push_token ('UOM', p_uom_value);
334: pay_core_utils.push_token ('VALUE', l_display_value);
335: --hr_utility.raise_error;
336: raise lov_error;
337: else
338: l_formatted_value := p_input_value;
348: p_value_set_id, l_display_value);
349: --
350: if l_formatted_value is null then
351: if p_batch_line_status in ('V','T') then
352: pay_core_utils.push_message (800,'HR_449109_BEE_UPG_VS_NONE','A');
353: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
354: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
355: pay_core_utils.push_token ('VALUE_SET_ID', p_value_set_id);
356: pay_core_utils.push_token ('UOM', p_uom_value);
349: --
350: if l_formatted_value is null then
351: if p_batch_line_status in ('V','T') then
352: pay_core_utils.push_message (800,'HR_449109_BEE_UPG_VS_NONE','A');
353: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
354: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
355: pay_core_utils.push_token ('VALUE_SET_ID', p_value_set_id);
356: pay_core_utils.push_token ('UOM', p_uom_value);
357: pay_core_utils.push_token ('VALUE', l_display_value);
350: if l_formatted_value is null then
351: if p_batch_line_status in ('V','T') then
352: pay_core_utils.push_message (800,'HR_449109_BEE_UPG_VS_NONE','A');
353: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
354: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
355: pay_core_utils.push_token ('VALUE_SET_ID', p_value_set_id);
356: pay_core_utils.push_token ('UOM', p_uom_value);
357: pay_core_utils.push_token ('VALUE', l_display_value);
358: --hr_utility.raise_error;
351: if p_batch_line_status in ('V','T') then
352: pay_core_utils.push_message (800,'HR_449109_BEE_UPG_VS_NONE','A');
353: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
354: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
355: pay_core_utils.push_token ('VALUE_SET_ID', p_value_set_id);
356: pay_core_utils.push_token ('UOM', p_uom_value);
357: pay_core_utils.push_token ('VALUE', l_display_value);
358: --hr_utility.raise_error;
359: raise lov_error;
352: pay_core_utils.push_message (800,'HR_449109_BEE_UPG_VS_NONE','A');
353: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
354: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
355: pay_core_utils.push_token ('VALUE_SET_ID', p_value_set_id);
356: pay_core_utils.push_token ('UOM', p_uom_value);
357: pay_core_utils.push_token ('VALUE', l_display_value);
358: --hr_utility.raise_error;
359: raise lov_error;
360: else
353: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
354: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
355: pay_core_utils.push_token ('VALUE_SET_ID', p_value_set_id);
356: pay_core_utils.push_token ('UOM', p_uom_value);
357: pay_core_utils.push_token ('VALUE', l_display_value);
358: --hr_utility.raise_error;
359: raise lov_error;
360: else
361: l_formatted_value := p_input_value;
403: --
404: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',4);
405: --
406: if p_batch_line_status in ('V','T') then
407: pay_core_utils.push_message (800,'HR_449110_BEE_UPG_CONV','A');
408: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
409: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
410: pay_core_utils.push_token ('UOM', p_uom_value);
411: pay_core_utils.push_token ('VALUE', l_display_value);
404: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',4);
405: --
406: if p_batch_line_status in ('V','T') then
407: pay_core_utils.push_message (800,'HR_449110_BEE_UPG_CONV','A');
408: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
409: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
410: pay_core_utils.push_token ('UOM', p_uom_value);
411: pay_core_utils.push_token ('VALUE', l_display_value);
412: hr_utility.raise_error;
405: --
406: if p_batch_line_status in ('V','T') then
407: pay_core_utils.push_message (800,'HR_449110_BEE_UPG_CONV','A');
408: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
409: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
410: pay_core_utils.push_token ('UOM', p_uom_value);
411: pay_core_utils.push_token ('VALUE', l_display_value);
412: hr_utility.raise_error;
413: else
406: if p_batch_line_status in ('V','T') then
407: pay_core_utils.push_message (800,'HR_449110_BEE_UPG_CONV','A');
408: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
409: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
410: pay_core_utils.push_token ('UOM', p_uom_value);
411: pay_core_utils.push_token ('VALUE', l_display_value);
412: hr_utility.raise_error;
413: else
414: return p_input_value;
407: pay_core_utils.push_message (800,'HR_449110_BEE_UPG_CONV','A');
408: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
409: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
410: pay_core_utils.push_token ('UOM', p_uom_value);
411: pay_core_utils.push_token ('VALUE', l_display_value);
412: hr_utility.raise_error;
413: else
414: return p_input_value;
415: end if;
677: when others then
678: --
679: payplnk.g_payplnk_call := false;
680: --
681: pay_core_utils.push_message (800,'HR_449111_BEE_UPG_UPD','A');
682: pay_core_utils.push_token ('BATCH_LINE_ID', p_rec.batch_line_id);
683: hr_utility.raise_error;
684: --
685: end;
678: --
679: payplnk.g_payplnk_call := false;
680: --
681: pay_core_utils.push_message (800,'HR_449111_BEE_UPG_UPD','A');
682: pay_core_utils.push_token ('BATCH_LINE_ID', p_rec.batch_line_id);
683: hr_utility.raise_error;
684: --
685: end;
686: --
817: --
818: l_status pay_upgrade_status.status%type;
819: --
820: begin
821: pay_core_utils.get_upgrade_status(p_business_group_id,p_short_name,l_status);
822: --
823: return l_status;
824: --
825: end upgrade_status;