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.BIS_UTILITIES_PVT dependencies on FND_API

Line 196: if (p_number = FND_API.G_MISS_NUM) then

192: )
193: is
194: begin
195: --
196: if (p_number = FND_API.G_MISS_NUM) then
197: htp.formText(p_field_name);
198: else
199: htp.formText( cname => p_field_name
200: , cvalue=>p_number

Line 214: if (p_number <> FND_API.G_MISS_NUM) then

210: )
211: is
212: begin
213: --
214: if (p_number <> FND_API.G_MISS_NUM) then
215: if (p_value is null) then
216: htp.formSelectOption(p_number);
217: else
218: htp.formSelectOption(p_number, p_selected, 'VALUE="'||p_value||'"');

Line 231: if (p_number = FND_API.G_MISS_NUM) then

227: )
228: is
229: begin
230: --
231: if (p_number = FND_API.G_MISS_NUM) then
232: htp.formHidden(p_field_name);
233: else
234: htp.formHidden( cname => p_field_name
235: , cvalue=> p_number

Line 248: if (p_varchar = FND_API.G_MISS_NUM) then

244: )
245: is
246: begin
247: --
248: if (p_varchar = FND_API.G_MISS_NUM) then
249: htp.formText(p_field_name);
250: else
251: htp.formText( cname => p_field_name
252: , cvalue=>p_varchar

Line 283: if (p_varchar = FND_API.G_MISS_CHAR) then

279: )
280: is
281: begin
282: --
283: if (p_varchar = FND_API.G_MISS_CHAR) then
284: htp.formHidden(p_field_name);
285: else
286: htp.formHidden( cname => p_field_name
287: , cvalue=> p_varchar

Line 825: if (p_Button_table(i).disabled = FND_API.G_TRUE) then

821: -- put the images etc. for the button
822: x_str := x_str || htf.tableRowOpen;
823: for i in 1 .. p_Button_table.COUNT loop
824: --
825: if (p_Button_table(i).disabled = FND_API.G_TRUE) then
826: l_str := htf.FontOpen(cattributes => 'class=disbutton');
827: elsif(p_Button_table(i).disabled = FND_API.G_FALSE) then
828: l_str := htf.FontOpen(cattributes => 'class=button');
829: end if;

Line 827: elsif(p_Button_table(i).disabled = FND_API.G_FALSE) then

823: for i in 1 .. p_Button_table.COUNT loop
824: --
825: if (p_Button_table(i).disabled = FND_API.G_TRUE) then
826: l_str := htf.FontOpen(cattributes => 'class=disbutton');
827: elsif(p_Button_table(i).disabled = FND_API.G_FALSE) then
828: l_str := htf.FontOpen(cattributes => 'class=button');
829: end if;
830: --
831: l_str := l_str || p_Button_table(i).label;

Line 835: if(p_Button_table(i).disabled = FND_API.G_FALSE) then

831: l_str := l_str || p_Button_table(i).label;
832: l_str := l_str || htf.fontClose;
833: --
834:
835: if(p_Button_table(i).disabled = FND_API.G_FALSE) then
836: l_str := htf.anchor( curl => p_Button_table(i).href
837: , ctext => l_str
838: );
839: end if;

Line 966: if (p_submit_form = FND_API.G_TRUE) then

962: if (p_str is not null) then
963: htp.p(p_str);
964: end if;
965:
966: if (p_submit_form = FND_API.G_TRUE) then
967: htp.p('document.'|| p_form_name||'.submit();');
968: end if;
969:
970: htp.p('}

Line 1131: if (p_submit_form = FND_API.G_TRUE) then

1127: if (p_str is not null) then
1128: htp.p(p_str);
1129: end if;
1130:
1131: if (p_submit_form = FND_API.G_TRUE) then
1132: htp.p('document.'|| p_form_name||'.submit();');
1133: end if;
1134:
1135: htp.p('}');

Line 1164: , p_title_bold IN varchar2 := FND_API.G_FALSE

1160: end putGreyLine;
1161: ---
1162: PROCEDURE getGroupBoxString
1163: ( p_title_string IN varchar2
1164: , p_title_bold IN varchar2 := FND_API.G_FALSE
1165: , p_data_string IN varchar2
1166: , x_str OUT NOCOPY varchar2
1167: )
1168: is

Line 1178: IF p_title_bold = FND_API.G_TRUE THEN

1174: );
1175: x_str := x_str || htf.tableRowOpen;
1176: x_str := x_str || htf.tableData(ccolspan=>3, cattributes=>'height="12"');
1177:
1178: IF p_title_bold = FND_API.G_TRUE THEN
1179: x_str := x_str || htf.tableData( cvalue
1180: => htf.fontOpen(cattributes=>'class=bold')
1181: || '&'||'nbsp;'||p_title_string||'&'||'nbsp;'
1182: || htf.fontClose

Line 1273: , p_title_bold IN varchar2 := FND_API.G_FALSE

1269: end getGroupBoxString;
1270:
1271: PROCEDURE getGroupBoxString
1272: ( p_title_string IN varchar2
1273: , p_title_bold IN varchar2 := FND_API.G_FALSE
1274: , p_data_tbl IN BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1275: , x_data_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1276: )
1277: IS

Line 1289: IF p_title_bold = FND_API.G_TRUE THEN

1285: );
1286: l_str := l_str || htf.tableRowOpen;
1287: l_str := l_str || htf.tableData(ccolspan=>3, cattributes=>'height=12');
1288:
1289: IF p_title_bold = FND_API.G_TRUE THEN
1290: l_str := l_str || htf.tableData( cvalue
1291: => htf.fontOpen(cattributes=>'class=bold')
1292: || '&'||'nbsp;'||p_title_string||'&'||'nbsp;'
1293: || htf.fontClose

Line 1406: if (p_heading = FND_API.G_TRUE) then

1402: l_line_color VARCHAR2(32000);
1403: l_img_src VARCHAR2(32000);
1404: BEGIN
1405:
1406: if (p_heading = FND_API.G_TRUE) then
1407:
1408: --- rounded corners no longer needed
1409:
1410: x_str := x_str || htf.tableData

Line 1457: if (p_heading = FND_API.G_TRUE) then

1453: l_line_color VARCHAR2(32000);
1454: l_img_src VARCHAR2(32000);
1455: BEGIN
1456:
1457: if (p_heading = FND_API.G_TRUE) then
1458: ---rounded corners no longer needed
1459: x_str := x_str || htf.tableData
1460: ( cvalue => htf.img(curl => G_PXC_6699CC_IMG_SRC
1461: , cattributes => 'width=6'

Line 1542: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE

1538: end if;
1539:
1540: l_str := l_rec.display_name;
1541:
1542: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE
1543: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then
1544: l_str := '&'||'nbsp';
1545: end if;
1546:

Line 1543: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then

1539:
1540: l_str := l_rec.display_name;
1541:
1542: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE
1543: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then
1544: l_str := '&'||'nbsp';
1545: end if;
1546:
1547: -- we have a separator line in between columns

Line 1627: -- if(p_heading = FND_API.G_TRUE) then

1623: getLeftEdge(p_row_num, p_heading, x_str);
1624: while (l_rec.row_num = p_row_num) loop
1625: if(x_index > p_index) then
1626: -- put the separation line in the beginning
1627: -- if(p_heading = FND_API.G_TRUE) then
1628: l_color := G_PXC_6699CC;
1629: l_img_src := G_PXC_6699CC_IMG_SRC;
1630: -- else
1631: -- l_color := G_PXC_999999;

Line 1651: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE

1647: , ctext => l_rec.display_name
1648: );
1649: end if;
1650:
1651: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE
1652: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then
1653: l_str := '&'||'nbsp';
1654: end if;
1655:

Line 1652: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then

1648: );
1649: end if;
1650:
1651: if BIS_UTILITIES_PVT.Value_Missing(l_str) = FND_API.G_TRUE
1652: OR BIS_UTILITIES_PVT.Value_NULL(l_str) = FND_API.G_TRUE then
1653: l_str := '&'||'nbsp';
1654: end if;
1655:
1656: -- l_str := 'xx';

Line 1659: if (p_heading = FND_API.G_TRUE) then

1655:
1656: -- l_str := 'xx';
1657: -- take care of the vertical separators between columns
1658: l_rec.col_span := l_rec.col_span + l_rec.col_span - 1;
1659: if (p_heading = FND_API.G_TRUE) then
1660: -- we have a separator line in between columns
1661: -- thus we need to increase the col span to accomodate
1662: x_str := x_str
1663: || htf.tableHeader( cvalue =>

Line 1756: , FND_API.G_TRUE

1752: l_cur_row_p := l_cur_row;
1753: putRowData( p_heading_table
1754: , i
1755: , l_cur_row_p
1756: , FND_API.G_TRUE
1757: , l_width
1758: , l_cur_row
1759: , l_str
1760: );

Line 1779: , FND_API.G_FALSE

1775: l_cur_row_p := l_cur_row;
1776: putRowData( p_data_table
1777: , i
1778: , l_cur_row_p
1779: , FND_API.G_FALSE
1780: , l_width
1781: , l_cur_row
1782: , l_str
1783: );

Line 1868: , FND_API.G_TRUE

1864: l_cur_row_p := l_cur_row;
1865: putRowData( p_heading_table
1866: , i
1867: , l_cur_row_p
1868: , FND_API.G_TRUE
1869: , l_width
1870: , l_cur_row
1871: , l_str
1872: );

Line 1892: , FND_API.G_FALSE

1888: l_cur_row_p := l_cur_row;
1889: putRowData( p_data_table
1890: , i
1891: , l_cur_row_p
1892: , FND_API.G_FALSE
1893: , l_width
1894: , l_cur_row
1895: , l_str
1896: );

Line 1955: IF(p_char = FND_API.G_MISS_CHAR) THEN

1951: )
1952: RETURN VARCHAR2
1953: IS
1954: BEGIN
1955: IF(p_char = FND_API.G_MISS_CHAR) THEN
1956: RETURN NULL;
1957: ELSE
1958: RETURN p_char;
1959: END IF;

Line 1969: IF(p_num = FND_API.G_MISS_NUM) THEN

1965: )
1966: RETURN NUMBER
1967: IS
1968: BEGIN
1969: IF(p_num = FND_API.G_MISS_NUM) THEN
1970: RETURN NULL;
1971: ELSE
1972: RETURN p_num;
1973: END IF;

Line 2000: if BIS_UTILITIES_PVT.Value_Missing(p_str) = FND_API.G_TRUE

1996: return VARCHAR2
1997: is
1998: begin
1999:
2000: if BIS_UTILITIES_PVT.Value_Missing(p_str) = FND_API.G_TRUE
2001: OR BIS_UTILITIES_PVT.Value_NOT_NULL(p_str) = FND_API.G_FALSE then
2002: return htf.tableData( cvalue => '&'||'nbsp'
2003: , calign => p_align
2004: , crowspan => p_rowspan

Line 2001: OR BIS_UTILITIES_PVT.Value_NOT_NULL(p_str) = FND_API.G_FALSE then

1997: is
1998: begin
1999:
2000: if BIS_UTILITIES_PVT.Value_Missing(p_str) = FND_API.G_TRUE
2001: OR BIS_UTILITIES_PVT.Value_NOT_NULL(p_str) = FND_API.G_FALSE then
2002: return htf.tableData( cvalue => '&'||'nbsp'
2003: , calign => p_align
2004: , crowspan => p_rowspan
2005: , ccolspan => p_colspan

Line 2023: IF ((Value_Missing(p_value) = FND_API.G_TRUE)

2019: p_value IN VARCHAR )
2020: RETURN VARCHAR2
2021: IS
2022: BEGIN
2023: IF ((Value_Missing(p_value) = FND_API.G_TRUE)
2024: OR
2025: (Value_Null(p_value) = FND_API.G_TRUE)) THEN
2026: RETURN FND_API.G_TRUE;
2027: ELSE

Line 2025: (Value_Null(p_value) = FND_API.G_TRUE)) THEN

2021: IS
2022: BEGIN
2023: IF ((Value_Missing(p_value) = FND_API.G_TRUE)
2024: OR
2025: (Value_Null(p_value) = FND_API.G_TRUE)) THEN
2026: RETURN FND_API.G_TRUE;
2027: ELSE
2028: RETURN FND_API.G_FALSE;
2029: END IF;

Line 2026: RETURN FND_API.G_TRUE;

2022: BEGIN
2023: IF ((Value_Missing(p_value) = FND_API.G_TRUE)
2024: OR
2025: (Value_Null(p_value) = FND_API.G_TRUE)) THEN
2026: RETURN FND_API.G_TRUE;
2027: ELSE
2028: RETURN FND_API.G_FALSE;
2029: END IF;
2030: END Value_Missing_Or_Null;

Line 2028: RETURN FND_API.G_FALSE;

2024: OR
2025: (Value_Null(p_value) = FND_API.G_TRUE)) THEN
2026: RETURN FND_API.G_TRUE;
2027: ELSE
2028: RETURN FND_API.G_FALSE;
2029: END IF;
2030: END Value_Missing_Or_Null;
2031:
2032:

Line 2039: IF ((Value_Missing(p_value) = FND_API.G_TRUE)

2035: p_value IN NUMBER )
2036: RETURN VARCHAR2
2037: IS
2038: BEGIN
2039: IF ((Value_Missing(p_value) = FND_API.G_TRUE)
2040: OR
2041: (Value_Null(p_value) = FND_API.G_TRUE )) THEN
2042: RETURN FND_API.G_TRUE;
2043: ELSE

Line 2041: (Value_Null(p_value) = FND_API.G_TRUE )) THEN

2037: IS
2038: BEGIN
2039: IF ((Value_Missing(p_value) = FND_API.G_TRUE)
2040: OR
2041: (Value_Null(p_value) = FND_API.G_TRUE )) THEN
2042: RETURN FND_API.G_TRUE;
2043: ELSE
2044: RETURN FND_API.G_FALSE;
2045: END IF;

Line 2042: RETURN FND_API.G_TRUE;

2038: BEGIN
2039: IF ((Value_Missing(p_value) = FND_API.G_TRUE)
2040: OR
2041: (Value_Null(p_value) = FND_API.G_TRUE )) THEN
2042: RETURN FND_API.G_TRUE;
2043: ELSE
2044: RETURN FND_API.G_FALSE;
2045: END IF;
2046: END Value_Missing_Or_Null;

Line 2044: RETURN FND_API.G_FALSE;

2040: OR
2041: (Value_Null(p_value) = FND_API.G_TRUE )) THEN
2042: RETURN FND_API.G_TRUE;
2043: ELSE
2044: RETURN FND_API.G_FALSE;
2045: END IF;
2046: END Value_Missing_Or_Null;
2047:
2048:

Line 2054: IF ((Value_Missing(p_value) = FND_API.G_TRUE)

2050: p_value IN DATE )
2051: RETURN VARCHAR2
2052: IS
2053: BEGIN
2054: IF ((Value_Missing(p_value) = FND_API.G_TRUE)
2055: OR
2056: (Value_Null(p_value) = FND_API.G_TRUE)) THEN
2057: RETURN FND_API.G_TRUE;
2058: ELSE

Line 2056: (Value_Null(p_value) = FND_API.G_TRUE)) THEN

2052: IS
2053: BEGIN
2054: IF ((Value_Missing(p_value) = FND_API.G_TRUE)
2055: OR
2056: (Value_Null(p_value) = FND_API.G_TRUE)) THEN
2057: RETURN FND_API.G_TRUE;
2058: ELSE
2059: RETURN FND_API.G_FALSE;
2060: END IF;

Line 2057: RETURN FND_API.G_TRUE;

2053: BEGIN
2054: IF ((Value_Missing(p_value) = FND_API.G_TRUE)
2055: OR
2056: (Value_Null(p_value) = FND_API.G_TRUE)) THEN
2057: RETURN FND_API.G_TRUE;
2058: ELSE
2059: RETURN FND_API.G_FALSE;
2060: END IF;
2061: END Value_Missing_Or_Null;

Line 2059: RETURN FND_API.G_FALSE;

2055: OR
2056: (Value_Null(p_value) = FND_API.G_TRUE)) THEN
2057: RETURN FND_API.G_TRUE;
2058: ELSE
2059: RETURN FND_API.G_FALSE;
2060: END IF;
2061: END Value_Missing_Or_Null;
2062:
2063:

Line 2069: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)

2065: p_value IN VARCHAR2 )
2066: RETURN VARCHAR2
2067: IS
2068: BEGIN
2069: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)
2070: AND
2071: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2072: RETURN FND_API.G_TRUE;
2073: ELSE

Line 2071: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN

2067: IS
2068: BEGIN
2069: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)
2070: AND
2071: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2072: RETURN FND_API.G_TRUE;
2073: ELSE
2074: RETURN FND_API.G_FALSE;
2075: END IF;

Line 2072: RETURN FND_API.G_TRUE;

2068: BEGIN
2069: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)
2070: AND
2071: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2072: RETURN FND_API.G_TRUE;
2073: ELSE
2074: RETURN FND_API.G_FALSE;
2075: END IF;
2076: END Value_Not_Missing_Not_Null;

Line 2074: RETURN FND_API.G_FALSE;

2070: AND
2071: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2072: RETURN FND_API.G_TRUE;
2073: ELSE
2074: RETURN FND_API.G_FALSE;
2075: END IF;
2076: END Value_Not_Missing_Not_Null;
2077:
2078:

Line 2084: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)

2080: p_value IN NUMBER )
2081: RETURN VARCHAR2
2082: IS
2083: BEGIN
2084: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)
2085: AND
2086: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2087: RETURN FND_API.G_TRUE;
2088: ELSE

Line 2086: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN

2082: IS
2083: BEGIN
2084: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)
2085: AND
2086: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2087: RETURN FND_API.G_TRUE;
2088: ELSE
2089: RETURN FND_API.G_FALSE;
2090: END IF;

Line 2087: RETURN FND_API.G_TRUE;

2083: BEGIN
2084: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)
2085: AND
2086: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2087: RETURN FND_API.G_TRUE;
2088: ELSE
2089: RETURN FND_API.G_FALSE;
2090: END IF;
2091: END Value_Not_Missing_Not_Null;

Line 2089: RETURN FND_API.G_FALSE;

2085: AND
2086: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2087: RETURN FND_API.G_TRUE;
2088: ELSE
2089: RETURN FND_API.G_FALSE;
2090: END IF;
2091: END Value_Not_Missing_Not_Null;
2092:
2093:

Line 2099: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)

2095: p_value IN DATE )
2096: RETURN VARCHAR2
2097: IS
2098: BEGIN
2099: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)
2100: AND
2101: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2102: RETURN FND_API.G_TRUE;
2103: ELSE

Line 2101: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN

2097: IS
2098: BEGIN
2099: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)
2100: AND
2101: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2102: RETURN FND_API.G_TRUE;
2103: ELSE
2104: RETURN FND_API.G_FALSE;
2105: END IF;

Line 2102: RETURN FND_API.G_TRUE;

2098: BEGIN
2099: IF ((Value_Not_Missing(p_value) = FND_API.G_TRUE)
2100: AND
2101: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2102: RETURN FND_API.G_TRUE;
2103: ELSE
2104: RETURN FND_API.G_FALSE;
2105: END IF;
2106: END Value_Not_Missing_Not_Null;

Line 2104: RETURN FND_API.G_FALSE;

2100: AND
2101: (Value_Not_Null(p_value) = FND_API.G_TRUE)) THEN
2102: RETURN FND_API.G_TRUE;
2103: ELSE
2104: RETURN FND_API.G_FALSE;
2105: END IF;
2106: END Value_Not_Missing_Not_Null;
2107:
2108:

Line 2114: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_CHAR) ) THEN --2694965

2110: p_value IN VARCHAR2 )
2111: RETURN VARCHAR2
2112: IS
2113: BEGIN
2114: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_CHAR) ) THEN --2694965
2115: return FND_API.G_FALSE;
2116: else
2117: return FND_API.G_TRUE;
2118: end if;

Line 2115: return FND_API.G_FALSE;

2111: RETURN VARCHAR2
2112: IS
2113: BEGIN
2114: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_CHAR) ) THEN --2694965
2115: return FND_API.G_FALSE;
2116: else
2117: return FND_API.G_TRUE;
2118: end if;
2119: END Value_Not_Missing;

Line 2117: return FND_API.G_TRUE;

2113: BEGIN
2114: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_CHAR) ) THEN --2694965
2115: return FND_API.G_FALSE;
2116: else
2117: return FND_API.G_TRUE;
2118: end if;
2119: END Value_Not_Missing;
2120:
2121: FUNCTION Value_Not_Missing(

Line 2126: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_NUM) ) THEN --2694965

2122: p_value IN NUMBER )
2123: RETURN VARCHAR2
2124: IS
2125: BEGIN
2126: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_NUM) ) THEN --2694965
2127: return FND_API.G_FALSE;
2128: else
2129: return FND_API.G_TRUE;
2130: end if;

Line 2127: return FND_API.G_FALSE;

2123: RETURN VARCHAR2
2124: IS
2125: BEGIN
2126: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_NUM) ) THEN --2694965
2127: return FND_API.G_FALSE;
2128: else
2129: return FND_API.G_TRUE;
2130: end if;
2131: END Value_Not_Missing;

Line 2129: return FND_API.G_TRUE;

2125: BEGIN
2126: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_NUM) ) THEN --2694965
2127: return FND_API.G_FALSE;
2128: else
2129: return FND_API.G_TRUE;
2130: end if;
2131: END Value_Not_Missing;
2132:
2133: FUNCTION Value_Not_Missing(

Line 2138: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_DATE) ) THEN --2694965

2134: p_value IN DATE )
2135: RETURN VARCHAR2
2136: IS
2137: BEGIN
2138: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_DATE) ) THEN --2694965
2139: return FND_API.G_FALSE;
2140: else
2141: return FND_API.G_TRUE;
2142: end if;

Line 2139: return FND_API.G_FALSE;

2135: RETURN VARCHAR2
2136: IS
2137: BEGIN
2138: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_DATE) ) THEN --2694965
2139: return FND_API.G_FALSE;
2140: else
2141: return FND_API.G_TRUE;
2142: end if;
2143: END Value_Not_Missing;

Line 2141: return FND_API.G_TRUE;

2137: BEGIN
2138: if ( (p_value IS NULL) OR (p_value = FND_API.G_MISS_DATE) ) THEN --2694965
2139: return FND_API.G_FALSE;
2140: else
2141: return FND_API.G_TRUE;
2142: end if;
2143: END Value_Not_Missing;
2144:
2145: FUNCTION Value_Missing(

Line 2150: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then

2146: p_value IN VARCHAR2 )
2147: RETURN VARCHAR2
2148: IS
2149: BEGIN
2150: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then
2151: return FND_API.G_FALSE;
2152: else
2153: return FND_API.G_TRUE;
2154: end if;

Line 2151: return FND_API.G_FALSE;

2147: RETURN VARCHAR2
2148: IS
2149: BEGIN
2150: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then
2151: return FND_API.G_FALSE;
2152: else
2153: return FND_API.G_TRUE;
2154: end if;
2155: END Value_Missing;

Line 2153: return FND_API.G_TRUE;

2149: BEGIN
2150: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then
2151: return FND_API.G_FALSE;
2152: else
2153: return FND_API.G_TRUE;
2154: end if;
2155: END Value_Missing;
2156:
2157: FUNCTION Value_Missing(

Line 2162: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then

2158: p_value IN NUMBER )
2159: RETURN VARCHAR2
2160: IS
2161: BEGIN
2162: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then
2163: return FND_API.G_FALSE;
2164: else
2165: return FND_API.G_TRUE;
2166: end if;

Line 2163: return FND_API.G_FALSE;

2159: RETURN VARCHAR2
2160: IS
2161: BEGIN
2162: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then
2163: return FND_API.G_FALSE;
2164: else
2165: return FND_API.G_TRUE;
2166: end if;
2167: END Value_Missing;

Line 2165: return FND_API.G_TRUE;

2161: BEGIN
2162: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then
2163: return FND_API.G_FALSE;
2164: else
2165: return FND_API.G_TRUE;
2166: end if;
2167: END Value_Missing;
2168:
2169: FUNCTION Value_Missing(

Line 2174: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then

2170: p_value IN DATE )
2171: RETURN VARCHAR2
2172: IS
2173: BEGIN
2174: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then
2175: return FND_API.G_FALSE;
2176: else
2177: return FND_API.G_TRUE;
2178: end if;

Line 2175: return FND_API.G_FALSE;

2171: RETURN VARCHAR2
2172: IS
2173: BEGIN
2174: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then
2175: return FND_API.G_FALSE;
2176: else
2177: return FND_API.G_TRUE;
2178: end if;
2179: END Value_Missing;

Line 2177: return FND_API.G_TRUE;

2173: BEGIN
2174: if (Value_Not_Missing(p_value) = FND_API.G_TRUE) then
2175: return FND_API.G_FALSE;
2176: else
2177: return FND_API.G_TRUE;
2178: end if;
2179: END Value_Missing;
2180:
2181: FUNCTION Value_Not_NULL(

Line 2187: return FND_API.G_FALSE;

2183: RETURN VARCHAR2
2184: IS
2185: BEGIN
2186: if (p_value IS NULL) THEN
2187: return FND_API.G_FALSE;
2188: else
2189: return FND_API.G_TRUE;
2190: end if;
2191: END Value_Not_NULL;

Line 2189: return FND_API.G_TRUE;

2185: BEGIN
2186: if (p_value IS NULL) THEN
2187: return FND_API.G_FALSE;
2188: else
2189: return FND_API.G_TRUE;
2190: end if;
2191: END Value_Not_NULL;
2192:
2193: FUNCTION Value_Not_NULL(

Line 2199: return FND_API.G_FALSE;

2195: RETURN VARCHAR2
2196: IS
2197: BEGIN
2198: if (p_value IS NULL) THEN
2199: return FND_API.G_FALSE;
2200: else
2201: return FND_API.G_TRUE;
2202: end if;
2203: END Value_Not_NULL;

Line 2201: return FND_API.G_TRUE;

2197: BEGIN
2198: if (p_value IS NULL) THEN
2199: return FND_API.G_FALSE;
2200: else
2201: return FND_API.G_TRUE;
2202: end if;
2203: END Value_Not_NULL;
2204:
2205: FUNCTION Value_Not_NULL(

Line 2211: return FND_API.G_FALSE;

2207: RETURN VARCHAR2
2208: IS
2209: BEGIN
2210: if (p_value is NULL) THEN
2211: return FND_API.G_FALSE;
2212: else
2213: return FND_API.G_TRUE;
2214: end if;
2215: END Value_Not_NULL;

Line 2213: return FND_API.G_TRUE;

2209: BEGIN
2210: if (p_value is NULL) THEN
2211: return FND_API.G_FALSE;
2212: else
2213: return FND_API.G_TRUE;
2214: end if;
2215: END Value_Not_NULL;
2216:
2217: FUNCTION Value_NULL(

Line 2222: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then

2218: p_value IN VARCHAR2 )
2219: RETURN VARCHAR2
2220: IS
2221: BEGIN
2222: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then
2223: return FND_API.G_FALSE;
2224: else
2225: return FND_API.G_TRUE;
2226: end if;

Line 2223: return FND_API.G_FALSE;

2219: RETURN VARCHAR2
2220: IS
2221: BEGIN
2222: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then
2223: return FND_API.G_FALSE;
2224: else
2225: return FND_API.G_TRUE;
2226: end if;
2227: END Value_NULL;

Line 2225: return FND_API.G_TRUE;

2221: BEGIN
2222: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then
2223: return FND_API.G_FALSE;
2224: else
2225: return FND_API.G_TRUE;
2226: end if;
2227: END Value_NULL;
2228:
2229: FUNCTION Value_NULL(

Line 2234: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then

2230: p_value IN NUMBER )
2231: RETURN VARCHAR2
2232: IS
2233: BEGIN
2234: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then
2235: return FND_API.G_FALSE;
2236: else
2237: return FND_API.G_TRUE;
2238: end if;

Line 2235: return FND_API.G_FALSE;

2231: RETURN VARCHAR2
2232: IS
2233: BEGIN
2234: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then
2235: return FND_API.G_FALSE;
2236: else
2237: return FND_API.G_TRUE;
2238: end if;
2239: END Value_NULL;

Line 2237: return FND_API.G_TRUE;

2233: BEGIN
2234: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then
2235: return FND_API.G_FALSE;
2236: else
2237: return FND_API.G_TRUE;
2238: end if;
2239: END Value_NULL;
2240:
2241: FUNCTION Value_NULL(

Line 2246: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then

2242: p_value IN DATE )
2243: RETURN VARCHAR2
2244: IS
2245: BEGIN
2246: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then
2247: return FND_API.G_FALSE;
2248: else
2249: return FND_API.G_TRUE;
2250: end if;

Line 2247: return FND_API.G_FALSE;

2243: RETURN VARCHAR2
2244: IS
2245: BEGIN
2246: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then
2247: return FND_API.G_FALSE;
2248: else
2249: return FND_API.G_TRUE;
2250: end if;
2251: END Value_NULL;

Line 2249: return FND_API.G_TRUE;

2245: BEGIN
2246: if (Value_Not_NULL(p_value) = FND_API.G_TRUE) then
2247: return FND_API.G_FALSE;
2248: else
2249: return FND_API.G_TRUE;
2250: end if;
2251: END Value_NULL;
2252:
2253:

Line 2272: if (BIS_UTILITIES_PUB.Value_Missing(p_id) = FND_API.G_TRUE

2268: return VARCHAR2
2269: is
2270: BEGIN
2271:
2272: if (BIS_UTILITIES_PUB.Value_Missing(p_id) = FND_API.G_TRUE
2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then
2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE

Line 2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then

2269: is
2270: BEGIN
2271:
2272: if (BIS_UTILITIES_PUB.Value_Missing(p_id) = FND_API.G_TRUE
2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then
2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)

Line 2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE

2272: if (BIS_UTILITIES_PUB.Value_Missing(p_id) = FND_API.G_TRUE
2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then
2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)
2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then

Line 2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)

2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then
2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)
2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then
2281: return FND_API.G_FALSE;

Line 2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE

2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)
2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then
2281: return FND_API.G_FALSE;
2282: else

Line 2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))

2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)
2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then
2281: return FND_API.G_FALSE;
2282: else
2283: return FND_API.G_TRUE;

Line 2281: return FND_API.G_FALSE;

2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)
2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then
2281: return FND_API.G_FALSE;
2282: else
2283: return FND_API.G_TRUE;
2284: end if;
2285: else

Line 2283: return FND_API.G_TRUE;

2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then
2281: return FND_API.G_FALSE;
2282: else
2283: return FND_API.G_TRUE;
2284: end if;
2285: else
2286: return FND_API.G_FALSE;
2287: end if;

Line 2286: return FND_API.G_FALSE;

2282: else
2283: return FND_API.G_TRUE;
2284: end if;
2285: else
2286: return FND_API.G_FALSE;
2287: end if;
2288:
2289: END Convert_to_ID;
2290: --

Line 2301: FND_API.G_MISS_CHAR,'NULL',

2297:
2298: BEGIN
2299: select DECODE(p_string,
2300: NULL,'NULL',
2301: FND_API.G_MISS_CHAR,'NULL',
2302: ''''||p_string||'''')
2303: into x_string
2304: from dual;
2305:

Line 2325: , p_all_info => FND_API.G_FALSE

2321:
2322: BIS_Target_LEVEL_PUB.Retrieve_User_Target_Levels
2323: ( p_api_version => 1.0
2324: , p_user_id => p_user_id
2325: , p_all_info => FND_API.G_FALSE
2326: , x_Target_Level_Tbl => l_temp_Target_Level_tbl
2327: , x_return_status => l_return_status
2328: , x_error_tbl => l_error_tbl
2329: );

Line 2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2336: x_target_level_tbl := l_target_level_tbl;
2337:
2338: EXCEPTION
2339: when others then
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2341: BIS_UTILITIES_PVT.Add_Error_Message
2342: ( p_error_msg_id => SQLCODE
2343: , p_error_description => SQLERRM
2344: , p_error_proc_name => 'Retrieve_User_Target_Level'

Line 2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2342: ( p_error_msg_id => SQLCODE
2343: , p_error_description => SQLERRM
2344: , p_error_proc_name => 'Retrieve_User_Target_Level'
2345: );
2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2347:
2348: END Retrieve_User_Target_Level;
2349: --
2350: --

Line 2369: , p_all_info => FND_API.G_FALSE

2365:
2366: BIS_Target_LEVEL_PUB.Retrieve_User_Target_Levels
2367: ( p_api_version => 1.0
2368: , p_user_id => p_user_id
2369: , p_all_info => FND_API.G_FALSE
2370: , x_Target_Level_Tbl => l_Target_Level_tbl
2371: , x_return_status => l_return_status
2372: , x_error_tbl => l_error_tbl
2373: );

Line 2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2380: x_perf_measure_tbl := l_perf_measure_tbl;
2381:
2382: EXCEPTION
2383: when others then
2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2385: BIS_UTILITIES_PVT.Add_Error_Message
2386: ( p_error_msg_id => SQLCODE
2387: , p_error_description => SQLERRM
2388: , p_error_proc_name => 'Retrieve_User_Perf_Measure'

Line 2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2386: ( p_error_msg_id => SQLCODE
2387: , p_error_description => SQLERRM
2388: , p_error_proc_name => 'Retrieve_User_Perf_Measure'
2389: );
2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2391:
2392: END Retrieve_User_Perf_Measure;
2393: --
2394: function target_level_where_clause

Line 2589: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR

2585: l_time_Seq NUMBER;
2586: BEGIN
2587: x_dim_values_rec := p_dim_Values_rec;
2588: IF (p_sequence_dir = 'N') THEN
2589: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2590: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2591: THEN
2592: OPEN c_seq(p_dim_values_rec.target_level_id
2593: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

Line 2590: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))

2586: BEGIN
2587: x_dim_values_rec := p_dim_Values_rec;
2588: IF (p_sequence_dir = 'N') THEN
2589: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2590: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2591: THEN
2592: OPEN c_seq(p_dim_values_rec.target_level_id
2593: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
2594: ,p_TargetLevelName => NULL));

Line 2661: IF (p_dim_values_rec.dim1_level_value_id = FND_API.G_MISS_CHAR) THEN

2657: x_dim_values_rec.dim7_level_value_name:= p_dim_values_rec.time_level_value_name ;
2658: END IF;
2659: END IF;
2660: /*x_dim_values_rec := p_dim_Values_rec;
2661: IF (p_dim_values_rec.dim1_level_value_id = FND_API.G_MISS_CHAR) THEN
2662: IF ((p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) AND
2663: (p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND
2664: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND
2665: (p_dim_values_rec.dim5_level_value_id = FND_API.G_MISS_CHAR)) THEN

Line 2662: IF ((p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) AND

2658: END IF;
2659: END IF;
2660: /*x_dim_values_rec := p_dim_Values_rec;
2661: IF (p_dim_values_rec.dim1_level_value_id = FND_API.G_MISS_CHAR) THEN
2662: IF ((p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) AND
2663: (p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND
2664: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND
2665: (p_dim_values_rec.dim5_level_value_id = FND_API.G_MISS_CHAR)) THEN
2666: x_dim_values_rec.dim1_level_value_id := p_dim_Values_rec.org_level_value_id;

Line 2663: (p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND

2659: END IF;
2660: /*x_dim_values_rec := p_dim_Values_rec;
2661: IF (p_dim_values_rec.dim1_level_value_id = FND_API.G_MISS_CHAR) THEN
2662: IF ((p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) AND
2663: (p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND
2664: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND
2665: (p_dim_values_rec.dim5_level_value_id = FND_API.G_MISS_CHAR)) THEN
2666: x_dim_values_rec.dim1_level_value_id := p_dim_Values_rec.org_level_value_id;
2667: x_dim_values_rec.dim2_level_value_id := p_dim_Values_rec.time_level_value_id;

Line 2664: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND

2660: /*x_dim_values_rec := p_dim_Values_rec;
2661: IF (p_dim_values_rec.dim1_level_value_id = FND_API.G_MISS_CHAR) THEN
2662: IF ((p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) AND
2663: (p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND
2664: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND
2665: (p_dim_values_rec.dim5_level_value_id = FND_API.G_MISS_CHAR)) THEN
2666: x_dim_values_rec.dim1_level_value_id := p_dim_Values_rec.org_level_value_id;
2667: x_dim_values_rec.dim2_level_value_id := p_dim_Values_rec.time_level_value_id;
2668: RETURN;

Line 2665: (p_dim_values_rec.dim5_level_value_id = FND_API.G_MISS_CHAR)) THEN

2661: IF (p_dim_values_rec.dim1_level_value_id = FND_API.G_MISS_CHAR) THEN
2662: IF ((p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) AND
2663: (p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND
2664: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND
2665: (p_dim_values_rec.dim5_level_value_id = FND_API.G_MISS_CHAR)) THEN
2666: x_dim_values_rec.dim1_level_value_id := p_dim_Values_rec.org_level_value_id;
2667: x_dim_values_rec.dim2_level_value_id := p_dim_Values_rec.time_level_value_id;
2668: RETURN;
2669: END IF;

Line 2671: IF (p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) THEN

2667: x_dim_values_rec.dim2_level_value_id := p_dim_Values_rec.time_level_value_id;
2668: RETURN;
2669: END IF;
2670: END IF;
2671: IF (p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) THEN
2672: IF ((p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND
2673: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND
2674: (p_dim_values_Rec.dim5_level_Value_id = FND_API.G_MISS_CHAR)) THEN
2675: x_Dim_values_rec.dim2_level_Value_id := p_dim_Values_rec.org_level_Value_id;

Line 2672: IF ((p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND

2668: RETURN;
2669: END IF;
2670: END IF;
2671: IF (p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) THEN
2672: IF ((p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND
2673: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND
2674: (p_dim_values_Rec.dim5_level_Value_id = FND_API.G_MISS_CHAR)) THEN
2675: x_Dim_values_rec.dim2_level_Value_id := p_dim_Values_rec.org_level_Value_id;
2676: x_dim_values_rec.dim3_level_value_id := p_dim_Values_rec.time_level_Value_id;

Line 2673: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND

2669: END IF;
2670: END IF;
2671: IF (p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) THEN
2672: IF ((p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND
2673: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND
2674: (p_dim_values_Rec.dim5_level_Value_id = FND_API.G_MISS_CHAR)) THEN
2675: x_Dim_values_rec.dim2_level_Value_id := p_dim_Values_rec.org_level_Value_id;
2676: x_dim_values_rec.dim3_level_value_id := p_dim_Values_rec.time_level_Value_id;
2677: RETURN;

Line 2674: (p_dim_values_Rec.dim5_level_Value_id = FND_API.G_MISS_CHAR)) THEN

2670: END IF;
2671: IF (p_dim_values_rec.dim2_level_value_id = FND_API.G_MISS_CHAR) THEN
2672: IF ((p_dim_values_rec.dim3_level_value_id = FND_API.G_MISS_CHAR) AND
2673: (p_dim_values_Rec.dim4_level_value_id = FND_API.G_MISS_CHAR) AND
2674: (p_dim_values_Rec.dim5_level_Value_id = FND_API.G_MISS_CHAR)) THEN
2675: x_Dim_values_rec.dim2_level_Value_id := p_dim_Values_rec.org_level_Value_id;
2676: x_dim_values_rec.dim3_level_value_id := p_dim_Values_rec.time_level_Value_id;
2677: RETURN;
2678: END IF;

Line 2799: IF ((p_Dim_level_rec.org_level_id <> FND_API.G_MISS_NUM) OR

2795: l_time_Seq NUMBER;
2796: BEGIN
2797: x_dim_level_rec := p_Dim_level_rec;
2798: IF (p_sequence_dir = 'N') THEN
2799: IF ((p_Dim_level_rec.org_level_id <> FND_API.G_MISS_NUM) OR
2800: (p_dim_level_Rec.time_level_id <> FND_API.G_MISS_NUM)) THEN
2801: OPEN c_seq(x_dim_level_rec.target_level_id
2802: , BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_rec.target_level_id
2803: ,p_TargetLevelName => NULL));

Line 2800: (p_dim_level_Rec.time_level_id <> FND_API.G_MISS_NUM)) THEN

2796: BEGIN
2797: x_dim_level_rec := p_Dim_level_rec;
2798: IF (p_sequence_dir = 'N') THEN
2799: IF ((p_Dim_level_rec.org_level_id <> FND_API.G_MISS_NUM) OR
2800: (p_dim_level_Rec.time_level_id <> FND_API.G_MISS_NUM)) THEN
2801: OPEN c_seq(x_dim_level_rec.target_level_id
2802: , BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => x_dim_level_rec.target_level_id
2803: ,p_TargetLevelName => NULL));
2804: FETCH c_seq INTO l_org_seq;

Line 2996: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR

2992: l_time_Seq NUMBER;
2993: BEGIN
2994: x_dim_values_rec := p_Dim_values_rec;
2995: IF (p_sequence_dir = 'N') THEN
2996: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2997: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2998: THEN
2999: OPEN c_seq(p_dim_values_rec.target_level_id
3000: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

Line 2997: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))

2993: BEGIN
2994: x_dim_values_rec := p_Dim_values_rec;
2995: IF (p_sequence_dir = 'N') THEN
2996: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ) OR
2997: (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
2998: THEN
2999: OPEN c_seq(p_dim_values_rec.target_level_id
3000: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
3001: , p_TargetLevelName => NULL));

Line 3097: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ))

3093: BEGIN
3094: x_dim_values_rec := p_Dim_values_rec;
3095: IF (p_sequence_dir = 'N') THEN
3096:
3097: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ))
3098: -- OR (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
3099: THEN
3100: OPEN c_seq(p_dim_values_rec.target_level_id
3101: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id

Line 3098: -- OR (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))

3094: x_dim_values_rec := p_Dim_values_rec;
3095: IF (p_sequence_dir = 'N') THEN
3096:
3097: IF ((BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.org_level_value_id) = FND_API.G_FALSE ))
3098: -- OR (BIS_UTILITIES_PVT.value_missing(p_dim_values_rec.time_level_value_id) = FND_API.G_FALSE))
3099: THEN
3100: OPEN c_seq(p_dim_values_rec.target_level_id
3101: ,BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_TargetLevelId => p_dim_values_rec.target_level_id
3102: ,p_TargetLevelName => NULL));

Line 3544: x_return_status := FND_API.G_RET_STS_ERROR;

3540:
3541: EXCEPTION
3542: WHEN OTHERS THEN
3543: BIS_UTILITIES_PUB.put_line(p_text =>' Error in bisvutlb.get_org_dimension_name_tl_edw ' || l_err_track || sqlerrm);
3544: x_return_status := FND_API.G_RET_STS_ERROR;
3545: END get_org_dim_name_tl_edw;
3546:
3547: --
3548:

Line 3619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3615: OPEN c_dim_name;
3616: FETCH c_dim_name INTO l_Source;
3617: IF c_dim_name%NOTFOUND THEN
3618: CLOSE c_dim_name;
3619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3620: RETURN FALSE;
3621: END IF;
3622:
3623: -- found now

Line 3656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3652: RETURN l_is_total;
3653:
3654: EXCEPTION
3655: when others then
3656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3657:
3658: BIS_UTILITIES_PVT.Add_Error_Message
3659: ( p_error_msg_id => SQLCODE
3660: , p_error_description => SQLERRM

Line 4123: if ( bis_utilities_pub.value_not_missing ( p_org_level_id ) = FND_API.G_TRUE ) then

4119: BEGIN
4120:
4121: if ( p_source = 'OLTP' ) then
4122:
4123: if ( bis_utilities_pub.value_not_missing ( p_org_level_id ) = FND_API.G_TRUE ) then
4124: l_Org_Level_Id := p_Org_Level_Id;
4125: else
4126: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level id is missing ');
4127: l_Org_Level_Id := null;

Line 4130: if ( bis_utilities_pub.value_not_missing ( p_org_level_short_name ) = FND_API.G_TRUE ) then

4126: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level id is missing ');
4127: l_Org_Level_Id := null;
4128: end if;
4129:
4130: if ( bis_utilities_pub.value_not_missing ( p_org_level_short_name ) = FND_API.G_TRUE ) then
4131: l_org_level_short_name := p_org_level_short_name;
4132: else
4133: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level short name is missing ');
4134: l_org_level_short_name := null;

Line 4829: WHEN FND_API.G_EXC_ERROR THEN

4825:
4826: return (l_where_clause);
4827:
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: x_return_status := FND_API.G_RET_STS_ERROR;
4831: l_error_tbl := x_error_tbl;
4832: BIS_UTILITIES_PVT.Add_Error_Message
4833: ( p_error_table => l_error_tbl

Line 4830: x_return_status := FND_API.G_RET_STS_ERROR;

4826: return (l_where_clause);
4827:
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: x_return_status := FND_API.G_RET_STS_ERROR;
4831: l_error_tbl := x_error_tbl;
4832: BIS_UTILITIES_PVT.Add_Error_Message
4833: ( p_error_table => l_error_tbl
4834: , p_error_msg_id => SQLCODE

Line 4842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4838: FND_MSG_PUB.Count_And_Get
4839: ( p_count => x_msg_count,
4840: p_data => x_msg_data
4841: );
4842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4844: l_error_tbl := x_error_tbl;
4845: BIS_UTILITIES_PVT.Add_Error_Message
4846: ( p_error_table => l_error_tbl

Line 4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4839: ( p_count => x_msg_count,
4840: p_data => x_msg_data
4841: );
4842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4844: l_error_tbl := x_error_tbl;
4845: BIS_UTILITIES_PVT.Add_Error_Message
4846: ( p_error_table => l_error_tbl
4847: , p_error_msg_id => SQLCODE

Line 4856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4852: ( p_count => x_msg_count,
4853: p_data => x_msg_data
4854: );
4855: WHEN OTHERS THEN
4856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4857: l_error_tbl := x_error_tbl;
4858: BIS_UTILITIES_PVT.Add_Error_Message
4859: ( p_error_table => l_error_tbl
4860: , p_error_msg_id => SQLCODE

Line 4921: WHEN FND_API.G_EXC_ERROR THEN

4917:
4918: return (l_where_clause);
4919:
4920: EXCEPTION
4921: WHEN FND_API.G_EXC_ERROR THEN
4922: x_return_status := FND_API.G_RET_STS_ERROR;
4923: l_error_tbl := x_error_tbl;
4924: BIS_UTILITIES_PVT.Add_Error_Message
4925: ( p_error_table => l_error_tbl

Line 4922: x_return_status := FND_API.G_RET_STS_ERROR;

4918: return (l_where_clause);
4919:
4920: EXCEPTION
4921: WHEN FND_API.G_EXC_ERROR THEN
4922: x_return_status := FND_API.G_RET_STS_ERROR;
4923: l_error_tbl := x_error_tbl;
4924: BIS_UTILITIES_PVT.Add_Error_Message
4925: ( p_error_table => l_error_tbl
4926: , p_error_msg_id => SQLCODE

Line 4934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4930: FND_MSG_PUB.Count_And_Get
4931: ( p_count => x_msg_count,
4932: p_data => x_msg_data
4933: );
4934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4936: l_error_tbl := x_error_tbl;
4937: BIS_UTILITIES_PVT.Add_Error_Message
4938: ( p_error_table => l_error_tbl

Line 4935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4931: ( p_count => x_msg_count,
4932: p_data => x_msg_data
4933: );
4934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4936: l_error_tbl := x_error_tbl;
4937: BIS_UTILITIES_PVT.Add_Error_Message
4938: ( p_error_table => l_error_tbl
4939: , p_error_msg_id => SQLCODE

Line 4948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4944: ( p_count => x_msg_count,
4945: p_data => x_msg_data
4946: );
4947: WHEN OTHERS THEN
4948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4949: l_error_tbl := x_error_tbl;
4950: BIS_UTILITIES_PVT.Add_Error_Message
4951: ( p_error_table => l_error_tbl
4952: , p_error_msg_id => SQLCODE

Line 5145: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;

5141: , x_return_status OUT NOCOPY VARCHAR2
5142: , x_return_msg OUT NOCOPY VARCHAR2
5143: )
5144: IS
5145: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;
5146: l_return_msg VARCHAR2(10000) := NULL;
5147: l_is_debug_mode BOOLEAN := FALSE;
5148:
5149: BEGIN

Line 5179: x_return_status := FND_API.G_RET_STS_ERROR;

5175: x_return_msg := l_return_msg;
5176:
5177: EXCEPTION
5178: WHEN OTHERS THEN
5179: x_return_status := FND_API.G_RET_STS_ERROR;
5180: x_return_msg := 'Error in BIS_UTILITIES_PUB.init_debug_log : '|| SQLERRM;
5181:
5182: END init_debug_log;
5183:

Line 5190: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;

5186: ( x_return_status OUT NOCOPY VARCHAR2
5187: , x_return_msg OUT NOCOPY VARCHAR2
5188: )
5189: IS
5190: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;
5191: l_return_msg VARCHAR2(10000) := NULL;
5192: l_is_debug_mode BOOLEAN := FALSE;
5193:
5194: BEGIN

Line 5215: x_return_status := FND_API.G_RET_STS_ERROR;

5211: x_return_msg := l_return_msg;
5212:
5213: EXCEPTION
5214: WHEN OTHERS THEN
5215: x_return_status := FND_API.G_RET_STS_ERROR;
5216: x_return_msg := 'Error in BIS_UTILITIES_PUB.init_debug_log : '|| SQLERRM;
5217:
5218: END init_debug_flag;
5219:

Line 5230: x_return_status := FND_API.G_RET_STS_SUCCESS;

5226: ) IS
5227: l_debug_mode VARCHAR2(10) := 'N';
5228: BEGIN
5229:
5230: x_return_status := FND_API.G_RET_STS_SUCCESS;
5231: x_return_msg := NULL;
5232: x_is_debug_mode := FALSE;
5233:
5234: l_debug_mode := NVL ( FND_PROFILE.value(BIS_UTILITIES_PUB.G_DEBUG_LOG_PROFILE) , 'N' ) ;

Line 5242: x_return_status := FND_API.G_RET_STS_ERROR;

5238: END IF;
5239:
5240: EXCEPTION
5241: WHEN OTHERS THEN
5242: x_return_status := FND_API.G_RET_STS_ERROR;
5243: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.get_debug_mode_profile: '|| SQLERRM;
5244: x_is_debug_mode := FALSE;
5245: END get_debug_mode_profile;
5246:

Line 5258: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;

5254: , x_return_status OUT NOCOPY VARCHAR2
5255: , x_return_msg OUT NOCOPY VARCHAR2
5256: )
5257: IS
5258: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;
5259: l_return_msg VARCHAR2(10000) := NULL;
5260: BEGIN
5261:
5262: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5262: x_return_status := FND_API.G_RET_STS_SUCCESS;

5258: l_return_status VARCHAR2(1000) := FND_API.G_RET_STS_SUCCESS;
5259: l_return_msg VARCHAR2(10000) := NULL;
5260: BEGIN
5261:
5262: x_return_status := FND_API.G_RET_STS_SUCCESS;
5263: x_return_msg := NULL;
5264:
5265: BIS_UTILITIES_PUB.G_IS_DEBUG_ON := NVL(p_is_true, FALSE);
5266:

Line 5269: x_return_status := FND_API.G_RET_STS_ERROR;

5265: BIS_UTILITIES_PUB.G_IS_DEBUG_ON := NVL(p_is_true, FALSE);
5266:
5267: EXCEPTION
5268: WHEN OTHERS THEN
5269: x_return_status := FND_API.G_RET_STS_ERROR;
5270: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.set_debug_log_flag: '|| SQLERRM;
5271: END set_debug_log_flag;
5272:
5273:

Line 5356: x_return_status := FND_API.G_RET_STS_SUCCESS;

5352: l_default_dir_name VARCHAR2(512); -- v$parameter%VALUE;
5353: l_default_log_name VARCHAR2(512); -- v$parameter%VALUE;
5354:
5355: BEGIN
5356: x_return_status := FND_API.G_RET_STS_SUCCESS;
5357: x_return_msg := NULL;
5358:
5359: l_default_dir_name := get_default_dir_name; -- ();
5360: l_default_log_name := get_default_log_name; -- () || '.log';

Line 5363: x_return_status := FND_API.G_RET_STS_ERROR;

5359: l_default_dir_name := get_default_dir_name; -- ();
5360: l_default_log_name := get_default_log_name; -- () || '.log';
5361:
5362: IF ( (l_default_dir_name IS NULL ) AND (p_dir_name IS NULL)) THEN
5363: x_return_status := FND_API.G_RET_STS_ERROR;
5364: x_return_msg := 'Error in opening debug log in BIS_UTILITIES_PVT.open_debug_log: Directory for log file is null';
5365: RETURN;
5366: END IF;
5367:

Line 5369: x_return_status := FND_API.G_RET_STS_ERROR;

5365: RETURN;
5366: END IF;
5367:
5368: IF ( (l_default_log_name IS NULL ) AND (p_file_name IS NULL)) THEN
5369: x_return_status := FND_API.G_RET_STS_ERROR;
5370: x_return_msg := 'Error in opening debug log in BIS_UTILITIES_PVT.open_debug_log: Log file name is null';
5371: RETURN;
5372: END IF;
5373:

Line 5385: x_return_status := FND_API.G_RET_STS_ERROR;

5381: );
5382:
5383: EXCEPTION
5384: WHEN OTHERS THEN
5385: x_return_status := FND_API.G_RET_STS_ERROR;
5386: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.open_debug_log: '|| SQLERRM;
5387:
5388: END open_debug_log;
5389:

Line 5399: x_return_status := FND_API.G_RET_STS_SUCCESS;

5395: x_return_msg OUT NOCOPY VARCHAR2)
5396: IS
5397: BEGIN
5398:
5399: x_return_status := FND_API.G_RET_STS_SUCCESS;
5400: x_return_msg := NULL;
5401:
5402: BIS_DEBUG_LOG.close;
5403:

Line 5406: x_return_status := FND_API.G_RET_STS_ERROR;

5402: BIS_DEBUG_LOG.close;
5403:
5404: EXCEPTION
5405: WHEN OTHERS THEN
5406: x_return_status := FND_API.G_RET_STS_ERROR;
5407: x_return_msg := 'Error in setting debug log flag in BIS_UTILITIES_PVT.close_debug_log: '|| SQLERRM;
5408: END close_debug_log;
5409:
5410:

Line 5421: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )

5417: l_is_debug_on := BIS_UTILITIES_PVT.is_debug_on;
5418:
5419: IF (l_is_debug_on) THEN
5420: IF (
5421: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )
5422: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)
5423: ) THEN
5424: BIS_DEBUG_LOG.put(p_text => p_text);
5425: END IF;

Line 5422: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)

5418:
5419: IF (l_is_debug_on) THEN
5420: IF (
5421: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )
5422: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)
5423: ) THEN
5424: BIS_DEBUG_LOG.put(p_text => p_text);
5425: END IF;
5426: END IF;

Line 5443: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )

5439: l_is_debug_on := BIS_UTILITIES_PVT.is_debug_on;
5440:
5441: IF (l_is_debug_on) THEN
5442: IF (
5443: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )
5444: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)
5445: ) THEN
5446: BIS_DEBUG_LOG.put_line(p_text => p_text);
5447: END IF;

Line 5444: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)

5440:
5441: IF (l_is_debug_on) THEN
5442: IF (
5443: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )
5444: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)
5445: ) THEN
5446: BIS_DEBUG_LOG.put_line(p_text => p_text);
5447: END IF;
5448: END IF;

Line 5512: x_return_status := FND_API.G_RET_STS_SUCCESS;

5508: l_dimlevel_name bisfv_dimension_levels.DIMENSION_LEVEL_SHORT_NAME%TYPE;
5509: l_dimshortname_time VARCHAR2(32000);
5510: l_lvlshortname_total VARCHAR2(32000);
5511: BEGIN
5512: x_return_status := FND_API.G_RET_STS_SUCCESS;
5513: IF(c_dims%ISOPEN) THEN
5514: CLOSE c_dims;
5515: END IF;
5516: OPEN c_dims;

Line 5519: x_return_status := FND_API.G_RET_STS_ERROR;

5515: END IF;
5516: OPEN c_dims;
5517: FETCH c_dims INTO l_source,l_dimshort_name,l_dimlevel_name;
5518: IF (c_dims%NOTFOUND) THEN
5519: x_return_status := FND_API.G_RET_STS_ERROR;
5520: RAISE FND_API.G_EXC_ERROR;
5521: END IF;
5522: CLOSE c_dims;
5523: IF (l_source = 'EDW') THEN

Line 5520: RAISE FND_API.G_EXC_ERROR;

5516: OPEN c_dims;
5517: FETCH c_dims INTO l_source,l_dimshort_name,l_dimlevel_name;
5518: IF (c_dims%NOTFOUND) THEN
5519: x_return_status := FND_API.G_RET_STS_ERROR;
5520: RAISE FND_API.G_EXC_ERROR;
5521: END IF;
5522: CLOSE c_dims;
5523: IF (l_source = 'EDW') THEN
5524: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => l_source);

Line 5543: WHEN FND_API.G_EXC_ERROR THEN

5539: END IF;
5540: END IF;
5541: RETURN FALSE;
5542: EXCEPTION
5543: WHEN FND_API.G_EXC_ERROR THEN
5544: IF(c_dims%ISOPEN) THEN
5545: CLOSE c_dims;
5546: END IF;
5547: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5547: x_return_status := FND_API.G_RET_STS_ERROR;

5543: WHEN FND_API.G_EXC_ERROR THEN
5544: IF(c_dims%ISOPEN) THEN
5545: CLOSE c_dims;
5546: END IF;
5547: x_return_status := FND_API.G_RET_STS_ERROR;
5548: RETURN FALSE;
5549: WHEN OTHERS THEN
5550: IF(c_dims%ISOPEN) THEN
5551: CLOSE c_dims;

Line 5553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5549: WHEN OTHERS THEN
5550: IF(c_dims%ISOPEN) THEN
5551: CLOSE c_dims;
5552: END IF;
5553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5554: RETURN FALSE;
5555: END is_valid_time_dimension_level;
5556: --
5557:

Line 5633: IF(BIS_PORTLET_CUSTOM_PUB.c_SWAN_ENABLED=FND_API.G_TRUE)THEN

5629: RETURN BOOLEAN IS
5630: l_swan_enabled BOOLEAN;
5631: BEGIN
5632:
5633: IF(BIS_PORTLET_CUSTOM_PUB.c_SWAN_ENABLED=FND_API.G_TRUE)THEN
5634: l_swan_enabled := TRUE;
5635: ELSE
5636: l_swan_enabled := FALSE;
5637: END IF;