APPS.PQP_GB_PSI_WPS_HISTORY dependencies on FND_NUMBER

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

1393: debug('Element Name Not Found',30);
1394: END IF;
1395: CLOSE get_wps_element_name;
1396: wps_percent := '0000000';
1397: ELSIF (fnd_number.canonical_to_number(wps_percent) > 100)
1398: THEN
1399: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1400: (p_error_number => 94533
1401: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'

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

1400: (p_error_number => 94533
1401: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1402: ,p_token1 => wps_percent
1403: );
1404: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1405: ELSIF (fnd_number.canonical_to_number(wps_percent) < 0)
1406: THEN
1407: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1408: (p_error_number => 94533

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

1401: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1402: ,p_token1 => wps_percent
1403: );
1404: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1405: ELSIF (fnd_number.canonical_to_number(wps_percent) < 0)
1406: THEN
1407: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1408: (p_error_number => 94533
1409: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'

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

1408: (p_error_number => 94533
1409: ,p_error_text => 'BEN_94533_IMPRACTICABLE_VALUE'
1410: ,p_token1 => wps_percent
1411: );
1412: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'099D99')));
1413: ELSE
1414: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1415: END IF;
1416:

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

1410: ,p_token1 => wps_percent
1411: );
1412: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'099D99')));
1413: ELSE
1414: wps_percent := rtrim(ltrim(to_char(fnd_number.canonical_to_number(wps_percent),'0999D99')));
1415: END IF;
1416:
1417: p_output := wps_percent;
1418: debug('p_output '||p_output);