APPS.PQP_GB_PSI_WPS_HISTORY dependencies on FND_NUMBER

Line 1361: ELSIF (fnd_number.canonical_to_number(wps_percent) > 100)

1357: debug('Element Name Not Found',30);
1358: END IF;
1359: CLOSE get_wps_element_name;
1360: wps_percent := '0000000';
1361: ELSIF (fnd_number.canonical_to_number(wps_percent) > 100)
1362: THEN
1363: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1364: (p_error_number => 94533
1365: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'

Line 1368: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));

1364: (p_error_number => 94533
1365: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1366: ,p_token1 => wps_percent
1367: );
1368: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1369: ELSIF (fnd_number.canonical_to_number(wps_percent) < 0)
1370: THEN
1371: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1372: (p_error_number => 94533

Line 1369: ELSIF (fnd_number.canonical_to_number(wps_percent) < 0)

1365: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1366: ,p_token1 => wps_percent
1367: );
1368: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1369: ELSIF (fnd_number.canonical_to_number(wps_percent) < 0)
1370: THEN
1371: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1372: (p_error_number => 94533
1373: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'

Line 1376: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'099D99')));

1372: (p_error_number => 94533
1373: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1374: ,p_token1 => wps_percent
1375: );
1376: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'099D99')));
1377: ELSE
1378: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1379: END IF;
1380:

Line 1378: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));

1374: ,p_token1 => wps_percent
1375: );
1376: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'099D99')));
1377: ELSE
1378: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1379: END IF;
1380:
1381: p_output := wps_percent;
1382: debug('p_output '||p_output);