APPS.PQP_US_SRS_EXTRACTS dependencies on BEN_EXT_FMT

Line 1490: hr_utility.set_location('.....Applying number format mask :ben_ext_fmt.apply_format_mask',50);

1486: hr_utility.set_location('.....Applying the format mask',45);
1487: If i.frmt_mask_lookup_cd Is Not Null And
1488: l_ff_value Is Not Null Then
1489: If substr(i.frmt_mask_lookup_cd,1,1) = 'N' then
1490: hr_utility.set_location('.....Applying number format mask :ben_ext_fmt.apply_format_mask',50);
1491: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(to_number(l_ff_value), i.frmt_mask_cd);
1492: l_ff_value := l_ff_value_fmt;
1493: Elsif substr(i.frmt_mask_lookup_cd,1,1) = 'D' then
1494: hr_utility.set_location('.....Applying Date format mask :ben_ext_fmt.apply_format_mask',55);

Line 1491: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(to_number(l_ff_value), i.frmt_mask_cd);

1487: If i.frmt_mask_lookup_cd Is Not Null And
1488: l_ff_value Is Not Null Then
1489: If substr(i.frmt_mask_lookup_cd,1,1) = 'N' then
1490: hr_utility.set_location('.....Applying number format mask :ben_ext_fmt.apply_format_mask',50);
1491: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(to_number(l_ff_value), i.frmt_mask_cd);
1492: l_ff_value := l_ff_value_fmt;
1493: Elsif substr(i.frmt_mask_lookup_cd,1,1) = 'D' then
1494: hr_utility.set_location('.....Applying Date format mask :ben_ext_fmt.apply_format_mask',55);
1495: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(FND_DATE.canonical_to_date(l_ff_value), i.frmt_mask_cd);

Line 1494: hr_utility.set_location('.....Applying Date format mask :ben_ext_fmt.apply_format_mask',55);

1490: hr_utility.set_location('.....Applying number format mask :ben_ext_fmt.apply_format_mask',50);
1491: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(to_number(l_ff_value), i.frmt_mask_cd);
1492: l_ff_value := l_ff_value_fmt;
1493: Elsif substr(i.frmt_mask_lookup_cd,1,1) = 'D' then
1494: hr_utility.set_location('.....Applying Date format mask :ben_ext_fmt.apply_format_mask',55);
1495: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(FND_DATE.canonical_to_date(l_ff_value), i.frmt_mask_cd);
1496: l_ff_value := l_ff_value_fmt;
1497: End If;
1498: End If;

Line 1495: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(FND_DATE.canonical_to_date(l_ff_value), i.frmt_mask_cd);

1491: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(to_number(l_ff_value), i.frmt_mask_cd);
1492: l_ff_value := l_ff_value_fmt;
1493: Elsif substr(i.frmt_mask_lookup_cd,1,1) = 'D' then
1494: hr_utility.set_location('.....Applying Date format mask :ben_ext_fmt.apply_format_mask',55);
1495: l_ff_value_fmt := ben_ext_fmt.apply_format_mask(FND_DATE.canonical_to_date(l_ff_value), i.frmt_mask_cd);
1496: l_ff_value := l_ff_value_fmt;
1497: End If;
1498: End If;
1499: Exception -- incase l_ff_value is not valid for formatting, just don't format it.