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 1933: * This function validates the global start date variable on fnd_flex_keyval

1929:
1930: END validate_pjm_project_info;
1931:
1932: /*
1933: * This function validates the global start date variable on fnd_flex_keyval
1934: * against the sysdate given it is not null
1935: * return result as -8 if fails validation, 1 otherwise
1936: */
1937: FUNCTION validate_flex_start_date

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

1940: result NUMBER :=1;
1941:
1942: BEGIN
1943:
1944: if (fnd_flex_keyval.start_date is not null) then
1945: if fnd_flex_keyval.start_date > sysdate then
1946: result := -8;
1947: end if;
1948: end if;

Line 1945: if fnd_flex_keyval.start_date > sysdate then

1941:
1942: BEGIN
1943:
1944: if (fnd_flex_keyval.start_date is not null) then
1945: if fnd_flex_keyval.start_date > sysdate then
1946: result := -8;
1947: end if;
1948: end if;
1949:

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

1950: return result;
1951: END validate_flex_start_date;
1952:
1953: /*
1954: * This function validates the global end date variable on fnd_flex_keyval
1955: * against the sysdate given it is not null
1956: * return result as -7 if fails validation, 1 otherwise
1957: */
1958: FUNCTION validate_flex_end_date

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

1961: result NUMBER :=1;
1962:
1963: BEGIN
1964:
1965: if (fnd_flex_keyval.end_date is not null) then
1966: if fnd_flex_keyval.end_date < sysdate then
1967: result := -7;
1968: end if;
1969: end if;

Line 1966: if fnd_flex_keyval.end_date < sysdate then

1962:
1963: BEGIN
1964:
1965: if (fnd_flex_keyval.end_date is not null) then
1966: if fnd_flex_keyval.end_date < sysdate then
1967: result := -7;
1968: end if;
1969: end if;
1970:

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

1971: return result;
1972: END validate_flex_end_date;
1973:
1974: /*
1975: * This function checks the global enabled flag variable on fnd_flex_keyval
1976: * return result as -6 if false , 1 otherwise
1977: */
1978: FUNCTION validate_flex_enabled
1979: RETURN NUMBER IS

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

1981: result NUMBER :=1;
1982:
1983: BEGIN
1984:
1985: if (fnd_flex_keyval.enabled_flag = FALSE) then
1986: result := -6;
1987: end if;
1988: return result;
1989: END validate_flex_enabled;

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

2004: result := -1;
2005: X_concatSegs := '';
2006:
2007: gl_global.set_aff_validation('XX',null);
2008: res := fnd_flex_keyval.validate_ccid('SQLGL','GL#',X_chartOfAccountsId,X_ccId, 'ALL',null,null,'ENFORCE');
2009:
2010:
2011: if res = TRUE THEN
2012: X_concatSegs := fnd_flex_keyval.concatenated_values;

Line 2012: X_concatSegs := fnd_flex_keyval.concatenated_values;

2008: res := fnd_flex_keyval.validate_ccid('SQLGL','GL#',X_chartOfAccountsId,X_ccId, 'ALL',null,null,'ENFORCE');
2009:
2010:
2011: if res = TRUE THEN
2012: X_concatSegs := fnd_flex_keyval.concatenated_values;
2013: result := 1;
2014: else
2015: result := -1;
2016: end if;

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

2032:
2033: -- validate individual segments based on passed validation date
2034: IF result = 1 THEN
2035: gl_global.set_aff_validation('XX',null);
2036: res := fnd_flex_keyval.validate_segs('CHECK_SEGMENTS','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',NVL(X_validationDate, sysdate));
2037: IF res = FALSE THEN
2038: result := -1;
2039: END IF;
2040: END IF;

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

2053: IF result =1 THEN
2054: result := validate_flex_enabled;
2055: END IF;
2056:
2057: if (result =1 AND fnd_flex_keyval.is_secured) then
2058: result := -5;
2059: end if;
2060:
2061: X_errorMsg := fnd_flex_keyval.error_message;

Line 2061: X_errorMsg := fnd_flex_keyval.error_message;

2057: if (result =1 AND fnd_flex_keyval.is_secured) then
2058: result := -5;
2059: end if;
2060:
2061: X_errorMsg := fnd_flex_keyval.error_message;
2062:
2063: return result;
2064:
2065: EXCEPTION

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

2084: result := -1;
2085:
2086: l_ccId := fnd_flex_ext.get_ccid('SQLGL','GL#',X_chartOfAccountsId, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),X_concatSegs);
2087: gl_global.set_aff_validation('XX',null);
2088: res := fnd_flex_keyval.validate_segs('FIND_COMBINATION','SQLGL','GL#',X_chartOfAccountsId,X_concatSegs,'V',SYSDATE,
2089: 'ALL',
2090: NULL,
2091: vrule => '\nSUMMARY_FLAG\nI \nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED \nN');
2092:

Line 2094: result := fnd_flex_keyval.combination_id;

2090: NULL,
2091: vrule => '\nSUMMARY_FLAG\nI \nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED \nN');
2092:
2093: if res = TRUE THEN
2094: result := fnd_flex_keyval.combination_id;
2095: elsif (fnd_flex_keyval.is_secured) then
2096: result := -5;
2097: elsif(fnd_flex_keyval.is_valid = FALSE) then
2098: result := -4;

Line 2095: elsif (fnd_flex_keyval.is_secured) then

2091: vrule => '\nSUMMARY_FLAG\nI \nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED \nN');
2092:
2093: if res = TRUE THEN
2094: result := fnd_flex_keyval.combination_id;
2095: elsif (fnd_flex_keyval.is_secured) then
2096: result := -5;
2097: elsif(fnd_flex_keyval.is_valid = FALSE) then
2098: result := -4;
2099: if(fnd_flex_keyval.value_error) then

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

2093: if res = TRUE THEN
2094: result := fnd_flex_keyval.combination_id;
2095: elsif (fnd_flex_keyval.is_secured) then
2096: result := -5;
2097: elsif(fnd_flex_keyval.is_valid = FALSE) then
2098: result := -4;
2099: if(fnd_flex_keyval.value_error) then
2100: result := -3;
2101: if (fnd_flex_keyval.error_segment is NULL) then

Line 2099: if(fnd_flex_keyval.value_error) then

2095: elsif (fnd_flex_keyval.is_secured) then
2096: result := -5;
2097: elsif(fnd_flex_keyval.is_valid = FALSE) then
2098: result := -4;
2099: if(fnd_flex_keyval.value_error) then
2100: result := -3;
2101: if (fnd_flex_keyval.error_segment is NULL) then
2102: result := -6;
2103: end if;

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

2097: elsif(fnd_flex_keyval.is_valid = FALSE) then
2098: result := -4;
2099: if(fnd_flex_keyval.value_error) then
2100: result := -3;
2101: if (fnd_flex_keyval.error_segment is NULL) then
2102: result := -6;
2103: end if;
2104: end if;
2105: end if;

Line 2107: X_errorMsg := fnd_flex_keyval.error_message;

2103: end if;
2104: end if;
2105: end if;
2106:
2107: X_errorMsg := fnd_flex_keyval.error_message;
2108:
2109: return result;
2110:
2111: Exception