eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_UTIL_PKG dependencies on FND_FLEX_KEYVAL

Line 1785: * This function validates the global start date variable on fnd_flex_keyval

1781:
1782: END validate_pjm_project_info;
1783:
1784: /*
1785: * This function validates the global start date variable on fnd_flex_keyval
1786: * against the sysdate given it is not null
1787: * return result as -8 if fails validation, 1 otherwise
1788: */
1789: FUNCTION validate_flex_start_date

Line 1796: if (fnd_flex_keyval.start_date is not null) then

1792: result NUMBER :=1;
1793:
1794: BEGIN
1795:
1796: if (fnd_flex_keyval.start_date is not null) then
1797: if fnd_flex_keyval.start_date > sysdate then
1798: result := -8;
1799: end if;
1800: end if;

Line 1797: if fnd_flex_keyval.start_date > sysdate then

1793:
1794: BEGIN
1795:
1796: if (fnd_flex_keyval.start_date is not null) then
1797: if fnd_flex_keyval.start_date > sysdate then
1798: result := -8;
1799: end if;
1800: end if;
1801:

Line 1806: * This function validates the global end date variable on fnd_flex_keyval

1802: return result;
1803: END validate_flex_start_date;
1804:
1805: /*
1806: * This function validates the global end date variable on fnd_flex_keyval
1807: * against the sysdate given it is not null
1808: * return result as -7 if fails validation, 1 otherwise
1809: */
1810: FUNCTION validate_flex_end_date

Line 1817: if (fnd_flex_keyval.end_date is not null) then

1813: result NUMBER :=1;
1814:
1815: BEGIN
1816:
1817: if (fnd_flex_keyval.end_date is not null) then
1818: if fnd_flex_keyval.end_date < sysdate then
1819: result := -7;
1820: end if;
1821: end if;

Line 1818: if fnd_flex_keyval.end_date < sysdate then

1814:
1815: BEGIN
1816:
1817: if (fnd_flex_keyval.end_date is not null) then
1818: if fnd_flex_keyval.end_date < sysdate then
1819: result := -7;
1820: end if;
1821: end if;
1822:

Line 1827: * This function checks the global enabled flag variable on fnd_flex_keyval

1823: return result;
1824: END validate_flex_end_date;
1825:
1826: /*
1827: * This function checks the global enabled flag variable on fnd_flex_keyval
1828: * return result as -6 if false , 1 otherwise
1829: */
1830: FUNCTION validate_flex_enabled
1831: RETURN NUMBER IS

Line 1837: if (fnd_flex_keyval.enabled_flag = FALSE) then

1833: result NUMBER :=1;
1834:
1835: BEGIN
1836:
1837: if (fnd_flex_keyval.enabled_flag = FALSE) then
1838: result := -6;
1839: end if;
1840: return result;
1841: END validate_flex_enabled;

Line 1859: res := fnd_flex_keyval.validate_ccid('SQLGL','GL#',X_chartOfAccountsId,X_ccId, 'ALL',null,null,'ENFORCE');

1855:
1856: result := -1;
1857: X_concatSegs := '';
1858:
1859: res := fnd_flex_keyval.validate_ccid('SQLGL','GL#',X_chartOfAccountsId,X_ccId, 'ALL',null,null,'ENFORCE');
1860:
1861:
1862: if res = TRUE THEN
1863: X_concatSegs := fnd_flex_keyval.concatenated_values;

Line 1863: X_concatSegs := fnd_flex_keyval.concatenated_values;

1859: res := fnd_flex_keyval.validate_ccid('SQLGL','GL#',X_chartOfAccountsId,X_ccId, 'ALL',null,null,'ENFORCE');
1860:
1861:
1862: if res = TRUE THEN
1863: X_concatSegs := fnd_flex_keyval.concatenated_values;
1864: result := 1;
1865: else
1866: result := -1;
1867: end if;

Line 1886: res := fnd_flex_keyval.validate_segs('CHECK_SEGMENTS','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',NVL(X_validationDate, sysdate));

1882: END IF;
1883:
1884: -- validate individual segments based on passed validation date
1885: IF result = 1 THEN
1886: res := fnd_flex_keyval.validate_segs('CHECK_SEGMENTS','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',NVL(X_validationDate, sysdate));
1887: IF res = FALSE THEN
1888: result := -1;
1889: END IF;
1890: END IF;

Line 1907: if (result =1 AND fnd_flex_keyval.is_secured) then

1903: IF result =1 THEN
1904: result := validate_flex_enabled;
1905: END IF;
1906:
1907: if (result =1 AND fnd_flex_keyval.is_secured) then
1908: result := -5;
1909: end if;
1910:
1911: X_errorMsg := fnd_flex_keyval.error_message;

Line 1911: X_errorMsg := fnd_flex_keyval.error_message;

1907: if (result =1 AND fnd_flex_keyval.is_secured) then
1908: result := -5;
1909: end if;
1910:
1911: X_errorMsg := fnd_flex_keyval.error_message;
1912:
1913: return result;
1914:
1915: EXCEPTION

Line 1938: res := fnd_flex_keyval.validate_segs('FIND_COMBINATION','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',SYSDATE,

1934: result := -1;
1935:
1936: l_ccId := fnd_flex_ext.get_ccid('SQLGL','GL#',X_chartOfAccountsId, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),X_concatSegs);
1937:
1938: res := fnd_flex_keyval.validate_segs('FIND_COMBINATION','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',SYSDATE,
1939: 'ALL',
1940: NULL,
1941: vrule => '\nSUMMARY_FLAG\nI \nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED \nN');
1942:

Line 1944: result := fnd_flex_keyval.combination_id;

1940: NULL,
1941: vrule => '\nSUMMARY_FLAG\nI \nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED \nN');
1942:
1943: if res = TRUE THEN
1944: result := fnd_flex_keyval.combination_id;
1945: elsif (fnd_flex_keyval.is_secured) then
1946: result := -5;
1947: elsif(fnd_flex_keyval.is_valid = FALSE) then
1948: result := -4;

Line 1945: elsif (fnd_flex_keyval.is_secured) then

1941: vrule => '\nSUMMARY_FLAG\nI \nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED \nN');
1942:
1943: if res = TRUE THEN
1944: result := fnd_flex_keyval.combination_id;
1945: elsif (fnd_flex_keyval.is_secured) then
1946: result := -5;
1947: elsif(fnd_flex_keyval.is_valid = FALSE) then
1948: result := -4;
1949: if(fnd_flex_keyval.value_error) then

Line 1947: elsif(fnd_flex_keyval.is_valid = FALSE) then

1943: if res = TRUE THEN
1944: result := fnd_flex_keyval.combination_id;
1945: elsif (fnd_flex_keyval.is_secured) then
1946: result := -5;
1947: elsif(fnd_flex_keyval.is_valid = FALSE) then
1948: result := -4;
1949: if(fnd_flex_keyval.value_error) then
1950: result := -3;
1951: if (fnd_flex_keyval.error_segment is NULL) then

Line 1949: if(fnd_flex_keyval.value_error) then

1945: elsif (fnd_flex_keyval.is_secured) then
1946: result := -5;
1947: elsif(fnd_flex_keyval.is_valid = FALSE) then
1948: result := -4;
1949: if(fnd_flex_keyval.value_error) then
1950: result := -3;
1951: if (fnd_flex_keyval.error_segment is NULL) then
1952: result := -6;
1953: end if;

Line 1951: if (fnd_flex_keyval.error_segment is NULL) then

1947: elsif(fnd_flex_keyval.is_valid = FALSE) then
1948: result := -4;
1949: if(fnd_flex_keyval.value_error) then
1950: result := -3;
1951: if (fnd_flex_keyval.error_segment is NULL) then
1952: result := -6;
1953: end if;
1954: end if;
1955: end if;

Line 1957: X_errorMsg := fnd_flex_keyval.error_message;

1953: end if;
1954: end if;
1955: end if;
1956:
1957: X_errorMsg := fnd_flex_keyval.error_message;
1958:
1959: return result;
1960:
1961: Exception