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_BUCKET_PVT dependencies on BIS_UTILITIES_PUB

Line 73: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

69: IS
70:
71: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
72: l_return_status VARCHAR2(10);
73: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
74:
75: BEGIN
76:
77: l_bis_bucket_rec.short_name := p_short_name;

Line 198: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

194: IS
195:
196: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
197: l_return_status VARCHAR2(10);
198: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
199: l_ret VARCHAR2(10);
200:
201: BEGIN
202:

Line 730: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

726: --It should call BIS_BUCKET_PVT. RETRIEVE _BIS_BUCKET with the short name
727: --and using the record of type BIS_BUCKET_REC_TYPE data obtained from that procedure,
728: --it should populates the out parameters
729: PROCEDURE RETRIEVE_BIS_BUCKET_WRAPPER (
730: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
731: ,x_bucket_id OUT NOCOPY BIS_BUCKET.bucket_id%TYPE
732: ,x_name OUT NOCOPY BIS_BUCKET_TL.name%TYPE
733: ,x_type OUT NOCOPY BIS_BUCKET.type%TYPE
734: ,x_application_id OUT NOCOPY BIS_BUCKET.application_id%TYPE

Line 778: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

774: IS
775:
776: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
777: l_return_status VARCHAR2(10);
778: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
779:
780: BEGIN
781:
782: BIS_BUCKET_PVT.RETRIEVE_BIS_BUCKET (

Line 852: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

848:
849:
850: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
851: PROCEDURE DELETE_BIS_BUCKET_WRAPPER (
852: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
853: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
854: ,x_return_status OUT NOCOPY VARCHAR2
855: ,x_error_msg OUT NOCOPY VARCHAR2
856: )

Line 853: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

849:
850: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
851: PROCEDURE DELETE_BIS_BUCKET_WRAPPER (
852: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
853: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
854: ,x_return_status OUT NOCOPY VARCHAR2
855: ,x_error_msg OUT NOCOPY VARCHAR2
856: )
857: IS

Line 860: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

856: )
857: IS
858:
859: l_return_status VARCHAR2(10);
860: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
861:
862: BEGIN
863: BIS_BUCKET_PVT.DELETE_BIS_BUCKET(
864: p_bucket_id => p_bucket_id

Line 894: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

890: --into the tables BIS_BUCKET, BIS_BUCKET_TL
891: PROCEDURE CREATE_BIS_BUCKET (
892: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
893: ,x_return_status OUT NOCOPY VARCHAR2
894: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
895: )
896: IS
897:
898: l_bucket_id NUMBER;

Line 907: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

903: l_fnd_type_count NUMBER;
904: l_bis_type_count NUMBER;
905: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
906: l_return_status VARCHAR2(10);
907: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
908:
909: BEGIN
910: SAVEPOINT SP_CREATE_BUCKET;
911:

Line 934: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

930: BIS_UTILITIES_PVT.Add_Error_Message (
931: p_error_msg_name => 'BIS_INVALID_SHORT_NAME'
932: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
933: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET'
934: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
935: ,p_error_table => l_error_tbl
936: ,x_error_table => x_error_tbl
937: );
938: RAISE FND_API.G_EXC_ERROR;

Line 1214: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1210: --using the short name or the bucket id as the where clause value
1211: PROCEDURE UPDATE_BIS_BUCKET (
1212: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
1213: ,x_return_status OUT NOCOPY VARCHAR2
1214: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1215: )
1216: IS
1217:
1218: --l_bis_bucket_rec_orig BIS_BUCKET_PUB.bis_bucket_rec_type;

Line 1221: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1217:
1218: --l_bis_bucket_rec_orig BIS_BUCKET_PUB.bis_bucket_rec_type;
1219: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
1220: l_return_status VARCHAR2(10);
1221: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1222: l_user_id NUMBER;
1223: l_login_id NUMBER;
1224: l_ret_name VARCHAR2(200);
1225: l_ret_id VARCHAR2(200);

Line 1241: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_bis_bucket_rec.short_name);

1237: l_login_id := fnd_global.LOGIN_ID;
1238:
1239: l_short_name := p_bis_bucket_rec.short_name;
1240:
1241: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_bis_bucket_rec.short_name);
1242: l_ret_id := BIS_UTILITIES_PUB.Value_Missing(p_bis_bucket_rec.bucket_id);
1243: IF (l_ret_name = FND_API.G_FALSE) THEN
1244: SELECT bucket_id, short_name INTO l_bucket_id, l_short_name
1245: FROM BIS_BUCKET

Line 1242: l_ret_id := BIS_UTILITIES_PUB.Value_Missing(p_bis_bucket_rec.bucket_id);

1238:
1239: l_short_name := p_bis_bucket_rec.short_name;
1240:
1241: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_bis_bucket_rec.short_name);
1242: l_ret_id := BIS_UTILITIES_PUB.Value_Missing(p_bis_bucket_rec.bucket_id);
1243: IF (l_ret_name = FND_API.G_FALSE) THEN
1244: SELECT bucket_id, short_name INTO l_bucket_id, l_short_name
1245: FROM BIS_BUCKET
1246: WHERE SHORT_NAME = p_bis_bucket_rec.short_name;

Line 1257: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

1253: BIS_UTILITIES_PVT.Add_Error_Message (
1254: p_error_msg_name => 'BIS_INVALID_SHORT_NAME'
1255: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1256: ,p_error_proc_name => G_PKG_NAME||'.UPDATE_BIS_BUCKET'
1257: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
1258: ,p_error_table => l_error_tbl
1259: ,x_error_table => x_error_tbl
1260: );
1261: RAISE FND_API.G_EXC_ERROR;

Line 1427: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

1423: BIS_UTILITIES_PVT.Add_Error_Message (
1424: p_error_msg_name => 'BIS_INVALID_BUCKET_ID_NAME'
1425: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1426: ,p_error_proc_name => G_PKG_NAME||'.UPDATE_BIS_BUCKET'
1427: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
1428: ,p_error_table => l_error_tbl
1429: ,x_error_table => x_error_tbl
1430: );
1431: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1458: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

1454: --using the short name or the bucket id as the where clause value
1455: --It should also delete the rows from BIS_BUCKET_CUSTOMIZATIONS and
1456: --BIS_BUCKET_CUSTOMIZATIONS_TL tables.
1457: PROCEDURE DELETE_BIS_BUCKET (
1458: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
1459: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1460: ,x_return_status OUT NOCOPY VARCHAR2
1461: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1462: )

Line 1459: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

1455: --It should also delete the rows from BIS_BUCKET_CUSTOMIZATIONS and
1456: --BIS_BUCKET_CUSTOMIZATIONS_TL tables.
1457: PROCEDURE DELETE_BIS_BUCKET (
1458: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
1459: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1460: ,x_return_status OUT NOCOPY VARCHAR2
1461: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1462: )
1463: IS

Line 1461: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1457: PROCEDURE DELETE_BIS_BUCKET (
1458: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
1459: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1460: ,x_return_status OUT NOCOPY VARCHAR2
1461: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1462: )
1463: IS
1464:
1465: l_dcount NUMBER;

Line 1470: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1466: l_ret_id VARCHAR2(200);
1467: l_ret_name VARCHAR2(200);
1468: l_bucket_id NUMBER;
1469: l_return_status VARCHAR2(10);
1470: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1471:
1472: BEGIN
1473:
1474: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_short_name);

Line 1474: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_short_name);

1470: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1471:
1472: BEGIN
1473:
1474: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_short_name);
1475: l_ret_id := BIS_UTILITIES_PUB.Value_Missing(p_bucket_id);
1476:
1477: IF (l_ret_name = FND_API.G_FALSE) THEN
1478: SELECT bucket_id INTO l_bucket_id FROM BIS_BUCKET

Line 1475: l_ret_id := BIS_UTILITIES_PUB.Value_Missing(p_bucket_id);

1471:
1472: BEGIN
1473:
1474: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_short_name);
1475: l_ret_id := BIS_UTILITIES_PUB.Value_Missing(p_bucket_id);
1476:
1477: IF (l_ret_name = FND_API.G_FALSE) THEN
1478: SELECT bucket_id INTO l_bucket_id FROM BIS_BUCKET
1479: WHERE SHORT_NAME = p_short_name;

Line 1506: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

1502: BIS_UTILITIES_PVT.Add_Error_Message (
1503: p_error_msg_name => 'BIS_INVALID_BUCKET_ID'
1504: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1505: ,p_error_proc_name => G_PKG_NAME||'.DELETE_BUCKET'
1506: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
1507: ,p_error_table => l_error_tbl
1508: ,x_error_table => x_error_tbl
1509: );
1510: RAISE FND_API.G_EXC_ERROR;

Line 1534: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

1530: BIS_UTILITIES_PVT.Add_Error_Message (
1531: p_error_msg_name => 'BIS_INVALID_BUCKET_ID_NAME'
1532: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1533: ,p_error_proc_name => G_PKG_NAME||'.DELETE_BUCKET'
1534: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
1535: ,p_error_table => l_error_tbl
1536: ,x_error_table => x_error_tbl
1537: );
1538: RAISE FND_API.G_EXC_ERROR;

Line 1552: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

1548: BIS_UTILITIES_PVT.Add_Error_Message (
1549: p_error_msg_name => 'BIS_INVALID_SHORT_NAME'
1550: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1551: ,p_error_proc_name => G_PKG_NAME||'.DELETE_BUCKET'
1552: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
1553: ,p_error_table => l_error_tbl
1554: ,x_error_table => x_error_tbl
1555: );
1556: RAISE FND_API.G_EXC_ERROR;

Line 1582: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

1578: --This API should populate a record of type bis_bucket_rec_type based on the bucket short name
1579: -- Modified for bug #3394457 , ankgoel
1580: -- Retrieve the record always from the customization table
1581: PROCEDURE RETRIEVE_BIS_BUCKET (
1582: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1583: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
1584: ,x_return_status OUT NOCOPY VARCHAR2
1585: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1586: )

Line 1585: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1581: PROCEDURE RETRIEVE_BIS_BUCKET (
1582: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1583: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
1584: ,x_return_status OUT NOCOPY VARCHAR2
1585: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1586: )
1587: IS
1588:
1589: l_ret_name VARCHAR2(200);

Line 1592: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1588:
1589: l_ret_name VARCHAR2(200);
1590: l_dcount NUMBER;
1591: l_return_status VARCHAR2(10);
1592: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1593:
1594:
1595: CURSOR c_bucket_cust (p_short_name VARCHAR2) IS
1596: SELECT

Line 1644: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_short_name);

1640:
1641:
1642: BEGIN
1643:
1644: l_ret_name := BIS_UTILITIES_PUB.Value_Missing(p_short_name);
1645:
1646: SELECT count(SHORT_NAME) INTO l_dcount FROM BIS_BUCKET
1647: WHERE SHORT_NAME = p_short_name;
1648:

Line 1655: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

1651: BIS_UTILITIES_PVT.Add_Error_Message (
1652: p_error_msg_name => 'BIS_INVALID_SHORT_NAME'
1653: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1654: ,p_error_proc_name => G_PKG_NAME||'.DELETE_BUCKET'
1655: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
1656: ,p_error_table => l_error_tbl
1657: ,x_error_table => x_error_tbl
1658: );
1659: RAISE FND_API.G_EXC_ERROR;

Line 1742: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1738: PROCEDURE TRANSLATE_BUCKET (
1739: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
1740: ,p_owner IN VARCHAR2
1741: ,x_return_status OUT NOCOPY VARCHAR2
1742: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1743: )
1744: IS
1745:
1746: l_user_id NUMBER;

Line 1751: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1747: l_login_id NUMBER;
1748: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
1749: l_bis_bucket_rec_orig BIS_BUCKET_PUB.bis_bucket_rec_type;
1750: l_return_status VARCHAR2(10);
1751: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1752:
1753: BEGIN
1754:
1755: l_bis_bucket_rec := p_bis_bucket_rec;

Line 1771: IF (p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER) THEN

1767: END IF;
1768:
1769: l_bis_bucket_rec.bucket_id := l_bis_bucket_rec_orig.bucket_id;
1770:
1771: IF (p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER) THEN
1772: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
1773: ELSE
1774: l_user_id := fnd_global.user_id;
1775: END IF;

Line 1772: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

1768:
1769: l_bis_bucket_rec.bucket_id := l_bis_bucket_rec_orig.bucket_id;
1770:
1771: IF (p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER) THEN
1772: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
1773: ELSE
1774: l_user_id := fnd_global.user_id;
1775: END IF;
1776:

Line 1855: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_name)= FND_API.G_TRUE) THEN

1851: l_hash_value binary_integer;
1852:
1853: BEGIN
1854:
1855: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_name)= FND_API.G_TRUE) THEN
1856: l_hash_value :=Dbms_Utility.Get_Hash_Value (
1857: name => p_bis_bucket_rec.range1_name
1858: ,base => 2
1859: ,hash_size => 1048576

Line 1865: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_name)= FND_API.G_TRUE) THEN

1861:
1862: l_range_name(l_hash_value) := p_bis_bucket_rec.range1_name;
1863: END IF;
1864:
1865: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_name)= FND_API.G_TRUE) THEN
1866: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1867: name => p_bis_bucket_rec.range2_name
1868: ,base => 2
1869: ,hash_size => 1048576

Line 1879: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_name)= FND_API.G_TRUE) THEN

1875: l_range_name(l_hash_value) := p_bis_bucket_rec.range2_name;
1876: END IF;
1877: END IF;
1878:
1879: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_name)= FND_API.G_TRUE) THEN
1880: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1881: name => p_bis_bucket_rec.range3_name
1882: ,base => 2
1883: ,hash_size => 1048576

Line 1894: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_name)= FND_API.G_TRUE) THEN

1890: END IF;
1891: END IF;
1892:
1893:
1894: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_name)= FND_API.G_TRUE) THEN
1895: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1896: name => p_bis_bucket_rec.range4_name
1897: ,base => 2
1898: ,hash_size => 1048576

Line 1909: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_name)= FND_API.G_TRUE) THEN

1905: END IF;
1906: END IF;
1907:
1908:
1909: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_name)= FND_API.G_TRUE) THEN
1910: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1911: name => p_bis_bucket_rec.range5_name
1912: ,base => 2
1913: ,hash_size => 1048576

Line 1924: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_name)= FND_API.G_TRUE) THEN

1920: END IF;
1921: END IF;
1922:
1923:
1924: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_name)= FND_API.G_TRUE) THEN
1925: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1926: name => p_bis_bucket_rec.range6_name
1927: ,base => 2
1928: ,hash_size => 1048576

Line 1939: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_name)= FND_API.G_TRUE) THEN

1935: END IF;
1936: END IF;
1937:
1938:
1939: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_name)= FND_API.G_TRUE) THEN
1940: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1941: name => p_bis_bucket_rec.range7_name
1942: ,base => 2
1943: ,hash_size => 1048576

Line 1954: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_name)= FND_API.G_TRUE) THEN

1950: END IF;
1951: END IF;
1952:
1953:
1954: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_name)= FND_API.G_TRUE) THEN
1955: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1956: name => p_bis_bucket_rec.range8_name
1957: ,base => 2
1958: ,hash_size => 1048576

Line 1969: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_name)= FND_API.G_TRUE) THEN

1965: END IF;
1966: END IF;
1967:
1968:
1969: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_name)= FND_API.G_TRUE) THEN
1970: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1971: name => p_bis_bucket_rec.range9_name
1972: ,base => 2
1973: ,hash_size => 1048576

Line 1984: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_name)= FND_API.G_TRUE) THEN

1980: END IF;
1981: END IF;
1982:
1983:
1984: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_name)= FND_API.G_TRUE) THEN
1985: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1986: name => p_bis_bucket_rec.range10_name
1987: ,base => 2
1988: ,hash_size => 1048576

Line 2025: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_low)= FND_API.G_TRUE) THEN

2021: IF((p_bis_bucket_rec.overlapping ='T') OR (p_bis_bucket_rec.discontinuous='T')) THEN
2022: RETURN TRUE;
2023: END IF;
2024:
2025: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_low)= FND_API.G_TRUE) THEN
2026: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2027: name => p_bis_bucket_rec.range1_low
2028: ,base => 2
2029: ,hash_size => 1048576

Line 2039: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_low)= FND_API.G_TRUE) THEN

2035: l_range_low(l_hash_value) := p_bis_bucket_rec.range1_low;
2036: END IF;
2037: END IF;
2038:
2039: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_low)= FND_API.G_TRUE) THEN
2040: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2041: name => p_bis_bucket_rec.range2_low
2042: ,base => 2
2043: ,hash_size => 1048576

Line 2053: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_low)= FND_API.G_TRUE) THEN

2049: l_range_low(l_hash_value) := p_bis_bucket_rec.range2_low;
2050: END IF;
2051: END IF;
2052:
2053: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_low)= FND_API.G_TRUE) THEN
2054: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2055: name => p_bis_bucket_rec.range3_low
2056: ,base => 2
2057: ,hash_size => 1048576

Line 2067: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_low)= FND_API.G_TRUE) THEN

2063: l_range_low(l_hash_value) := p_bis_bucket_rec.range3_low;
2064: END IF;
2065: END IF;
2066:
2067: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_low)= FND_API.G_TRUE) THEN
2068: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2069: name => p_bis_bucket_rec.range4_low
2070: ,base => 2
2071: ,hash_size => 1048576

Line 2081: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_low)= FND_API.G_TRUE) THEN

2077: l_range_low(l_hash_value) := p_bis_bucket_rec.range4_low;
2078: END IF;
2079: END IF;
2080:
2081: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_low)= FND_API.G_TRUE) THEN
2082: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2083: name => p_bis_bucket_rec.range5_low
2084: ,base => 2
2085: ,hash_size => 1048576

Line 2095: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_low)= FND_API.G_TRUE) THEN

2091: l_range_low(l_hash_value) := p_bis_bucket_rec.range5_low;
2092: END IF;
2093: END IF;
2094:
2095: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_low)= FND_API.G_TRUE) THEN
2096: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2097: name => p_bis_bucket_rec.range6_low
2098: ,base => 2
2099: ,hash_size => 1048576

Line 2109: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_low)= FND_API.G_TRUE) THEN

2105: l_range_low(l_hash_value) := p_bis_bucket_rec.range6_low;
2106: END IF;
2107: END IF;
2108:
2109: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_low)= FND_API.G_TRUE) THEN
2110: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2111: name => p_bis_bucket_rec.range7_low
2112: ,base => 2
2113: ,hash_size => 1048576

Line 2123: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_low)= FND_API.G_TRUE) THEN

2119: l_range_low(l_hash_value) := p_bis_bucket_rec.range7_low;
2120: END IF;
2121: END IF;
2122:
2123: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_low)= FND_API.G_TRUE) THEN
2124: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2125: name => p_bis_bucket_rec.range8_low
2126: ,base => 2
2127: ,hash_size => 1048576

Line 2137: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_low)= FND_API.G_TRUE) THEN

2133: l_range_low(l_hash_value) := p_bis_bucket_rec.range8_low;
2134: END IF;
2135: END IF;
2136:
2137: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_low)= FND_API.G_TRUE) THEN
2138: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2139: name => p_bis_bucket_rec.range9_low
2140: ,base => 2
2141: ,hash_size => 1048576

Line 2151: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_low)= FND_API.G_TRUE) THEN

2147: l_range_low(l_hash_value) := p_bis_bucket_rec.range9_low;
2148: END IF;
2149: END IF;
2150:
2151: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_low)= FND_API.G_TRUE) THEN
2152: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2153: name => p_bis_bucket_rec.range10_low
2154: ,base => 2
2155: ,hash_size => 1048576

Line 2189: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_high)= FND_API.G_TRUE) THEN

2185: BEGIN
2186: IF((p_bis_bucket_rec.overlapping ='T') OR (p_bis_bucket_rec.discontinuous='T')) THEN
2187: RETURN TRUE;
2188: END IF;
2189: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_high)= FND_API.G_TRUE) THEN
2190: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2191: name => p_bis_bucket_rec.range1_high
2192: ,base => 2
2193: ,hash_size => 1048576

Line 2203: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_high)= FND_API.G_TRUE) THEN

2199: l_range_high(l_hash_value) := p_bis_bucket_rec.range1_high;
2200: END IF;
2201: END IF;
2202:
2203: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_high)= FND_API.G_TRUE) THEN
2204: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2205: name => p_bis_bucket_rec.range2_high
2206: ,base => 2
2207: ,hash_size => 1048576

Line 2217: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_high)= FND_API.G_TRUE) THEN

2213: l_range_high(l_hash_value) := p_bis_bucket_rec.range2_high;
2214: END IF;
2215: END IF;
2216:
2217: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_high)= FND_API.G_TRUE) THEN
2218: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2219: name => p_bis_bucket_rec.range3_high
2220: ,base => 2
2221: ,hash_size => 1048576

Line 2231: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_high)= FND_API.G_TRUE) THEN

2227: l_range_high(l_hash_value) := p_bis_bucket_rec.range3_high;
2228: END IF;
2229: END IF;
2230:
2231: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_high)= FND_API.G_TRUE) THEN
2232: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2233: name => p_bis_bucket_rec.range4_high
2234: ,base => 2
2235: ,hash_size => 1048576

Line 2245: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_high)= FND_API.G_TRUE) THEN

2241: l_range_high(l_hash_value) := p_bis_bucket_rec.range4_high;
2242: END IF;
2243: END IF;
2244:
2245: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_high)= FND_API.G_TRUE) THEN
2246: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2247: name => p_bis_bucket_rec.range5_high
2248: ,base => 2
2249: ,hash_size => 1048576

Line 2259: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_high)= FND_API.G_TRUE) THEN

2255: l_range_high(l_hash_value) := p_bis_bucket_rec.range5_high;
2256: END IF;
2257: END IF;
2258:
2259: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_high)= FND_API.G_TRUE) THEN
2260: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2261: name => p_bis_bucket_rec.range6_high
2262: ,base => 2
2263: ,hash_size => 1048576

Line 2273: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_high)= FND_API.G_TRUE) THEN

2269: l_range_high(l_hash_value) := p_bis_bucket_rec.range6_high;
2270: END IF;
2271: END IF;
2272:
2273: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_high)= FND_API.G_TRUE) THEN
2274: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2275: name => p_bis_bucket_rec.range7_high
2276: ,base => 2
2277: ,hash_size => 1048576

Line 2287: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_high)= FND_API.G_TRUE) THEN

2283: l_range_high(l_hash_value) := p_bis_bucket_rec.range7_high;
2284: END IF;
2285: END IF;
2286:
2287: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_high)= FND_API.G_TRUE) THEN
2288: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2289: name => p_bis_bucket_rec.range8_high
2290: ,base => 2
2291: ,hash_size => 1048576

Line 2301: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_high)= FND_API.G_TRUE) THEN

2297: l_range_high(l_hash_value) := p_bis_bucket_rec.range8_high;
2298: END IF;
2299: END IF;
2300:
2301: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_high)= FND_API.G_TRUE) THEN
2302: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2303: name => p_bis_bucket_rec.range9_high
2304: ,base => 2
2305: ,hash_size => 1048576

Line 2315: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_high)= FND_API.G_TRUE) THEN

2311: l_range_high(l_hash_value) := p_bis_bucket_rec.range9_high;
2312: END IF;
2313: END IF;
2314:
2315: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_high)= FND_API.G_TRUE) THEN
2316: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2317: name => p_bis_bucket_rec.range10_high
2318: ,base => 2
2319: ,hash_size => 1048576

Line 2384: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2380: --=============================================================================
2381: PROCEDURE Validate_Bucket (
2382: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
2383: ,x_return_status OUT NOCOPY VARCHAR2
2384: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2385: ) IS
2386:
2387: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2388: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

Line 2387: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2383: ,x_return_status OUT NOCOPY VARCHAR2
2384: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2385: ) IS
2386:
2387: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2388: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
2389:
2390: l_bucket_ranges_tbl BIS_BUCKET_PVT.BIS_BUCKET_RANGES_TBL;
2391:

Line 2405: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

2401: BIS_UTILITIES_PVT.Add_Error_Message (
2402: p_error_msg_name => 'BIS_INVALID_APPLICATION_ID'
2403: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2404: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET_APPLICATION_ID'
2405: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
2406: ,p_error_table => l_error_tbl
2407: ,x_error_table => x_error_tbl
2408: );
2409: RAISE FND_API.G_EXC_ERROR;

Line 2525: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2521: (
2522: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
2523: ,x_bucket_ranges_tbl OUT NOCOPY BIS_BUCKET_PVT.bis_bucket_ranges_tbl
2524: ,x_return_status OUT NOCOPY VARCHAR2
2525: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2526: )
2527: IS
2528: l_valid_bucket_count NUMBER := 0;
2529: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 2529: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2525: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2526: )
2527: IS
2528: l_valid_bucket_count NUMBER := 0;
2529: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2530:
2531: BEGIN
2532:
2533: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2535: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_name)= FND_API.G_TRUE)

2531: BEGIN
2532:
2533: x_return_status := FND_API.G_RET_STS_SUCCESS;
2534:
2535: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_name)= FND_API.G_TRUE)
2536: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_low)= FND_API.G_TRUE)
2537: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_high)= FND_API.G_TRUE)) THEN
2538: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range1_low;
2539: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range1_high;

Line 2536: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_low)= FND_API.G_TRUE)

2532:
2533: x_return_status := FND_API.G_RET_STS_SUCCESS;
2534:
2535: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_name)= FND_API.G_TRUE)
2536: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_low)= FND_API.G_TRUE)
2537: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_high)= FND_API.G_TRUE)) THEN
2538: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range1_low;
2539: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range1_high;
2540: l_valid_bucket_count := l_valid_bucket_count + 1;

Line 2537: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_high)= FND_API.G_TRUE)) THEN

2533: x_return_status := FND_API.G_RET_STS_SUCCESS;
2534:
2535: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_name)= FND_API.G_TRUE)
2536: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_low)= FND_API.G_TRUE)
2537: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_high)= FND_API.G_TRUE)) THEN
2538: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range1_low;
2539: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range1_high;
2540: l_valid_bucket_count := l_valid_bucket_count + 1;
2541: END IF;

Line 2543: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_name)= FND_API.G_TRUE)

2539: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range1_high;
2540: l_valid_bucket_count := l_valid_bucket_count + 1;
2541: END IF;
2542:
2543: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_name)= FND_API.G_TRUE)
2544: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_low)= FND_API.G_TRUE)
2545: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_high)= FND_API.G_TRUE)) THEN
2546: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range2_low;
2547: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range2_high;

Line 2544: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_low)= FND_API.G_TRUE)

2540: l_valid_bucket_count := l_valid_bucket_count + 1;
2541: END IF;
2542:
2543: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_name)= FND_API.G_TRUE)
2544: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_low)= FND_API.G_TRUE)
2545: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_high)= FND_API.G_TRUE)) THEN
2546: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range2_low;
2547: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range2_high;
2548: l_valid_bucket_count := l_valid_bucket_count + 1;

Line 2545: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_high)= FND_API.G_TRUE)) THEN

2541: END IF;
2542:
2543: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_name)= FND_API.G_TRUE)
2544: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_low)= FND_API.G_TRUE)
2545: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_high)= FND_API.G_TRUE)) THEN
2546: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range2_low;
2547: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range2_high;
2548: l_valid_bucket_count := l_valid_bucket_count + 1;
2549: END IF;

Line 2551: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_name)= FND_API.G_TRUE)

2547: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range2_high;
2548: l_valid_bucket_count := l_valid_bucket_count + 1;
2549: END IF;
2550:
2551: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_name)= FND_API.G_TRUE)
2552: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_low)= FND_API.G_TRUE)
2553: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_high)= FND_API.G_TRUE)) THEN
2554: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range3_low;
2555: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range3_high;

Line 2552: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_low)= FND_API.G_TRUE)

2548: l_valid_bucket_count := l_valid_bucket_count + 1;
2549: END IF;
2550:
2551: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_name)= FND_API.G_TRUE)
2552: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_low)= FND_API.G_TRUE)
2553: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_high)= FND_API.G_TRUE)) THEN
2554: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range3_low;
2555: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range3_high;
2556: l_valid_bucket_count := l_valid_bucket_count + 1;

Line 2553: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_high)= FND_API.G_TRUE)) THEN

2549: END IF;
2550:
2551: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_name)= FND_API.G_TRUE)
2552: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_low)= FND_API.G_TRUE)
2553: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_high)= FND_API.G_TRUE)) THEN
2554: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range3_low;
2555: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range3_high;
2556: l_valid_bucket_count := l_valid_bucket_count + 1;
2557: END IF;

Line 2559: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_name)= FND_API.G_TRUE)

2555: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range3_high;
2556: l_valid_bucket_count := l_valid_bucket_count + 1;
2557: END IF;
2558:
2559: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_name)= FND_API.G_TRUE)
2560: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_low)= FND_API.G_TRUE)
2561: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_high)= FND_API.G_TRUE)) THEN
2562: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range4_low;
2563: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range4_high;

Line 2560: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_low)= FND_API.G_TRUE)

2556: l_valid_bucket_count := l_valid_bucket_count + 1;
2557: END IF;
2558:
2559: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_name)= FND_API.G_TRUE)
2560: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_low)= FND_API.G_TRUE)
2561: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_high)= FND_API.G_TRUE)) THEN
2562: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range4_low;
2563: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range4_high;
2564: l_valid_bucket_count := l_valid_bucket_count + 1;

Line 2561: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_high)= FND_API.G_TRUE)) THEN

2557: END IF;
2558:
2559: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_name)= FND_API.G_TRUE)
2560: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_low)= FND_API.G_TRUE)
2561: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_high)= FND_API.G_TRUE)) THEN
2562: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range4_low;
2563: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range4_high;
2564: l_valid_bucket_count := l_valid_bucket_count + 1;
2565: END IF;

Line 2567: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_name)= FND_API.G_TRUE)

2563: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range4_high;
2564: l_valid_bucket_count := l_valid_bucket_count + 1;
2565: END IF;
2566:
2567: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_name)= FND_API.G_TRUE)
2568: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_low)= FND_API.G_TRUE)
2569: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_high)= FND_API.G_TRUE)) THEN
2570: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range5_low;
2571: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range5_high;

Line 2568: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_low)= FND_API.G_TRUE)

2564: l_valid_bucket_count := l_valid_bucket_count + 1;
2565: END IF;
2566:
2567: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_name)= FND_API.G_TRUE)
2568: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_low)= FND_API.G_TRUE)
2569: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_high)= FND_API.G_TRUE)) THEN
2570: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range5_low;
2571: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range5_high;
2572: l_valid_bucket_count := l_valid_bucket_count + 1;

Line 2569: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_high)= FND_API.G_TRUE)) THEN

2565: END IF;
2566:
2567: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_name)= FND_API.G_TRUE)
2568: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_low)= FND_API.G_TRUE)
2569: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_high)= FND_API.G_TRUE)) THEN
2570: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range5_low;
2571: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range5_high;
2572: l_valid_bucket_count := l_valid_bucket_count + 1;
2573: END IF;

Line 2575: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_name)= FND_API.G_TRUE)

2571: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range5_high;
2572: l_valid_bucket_count := l_valid_bucket_count + 1;
2573: END IF;
2574:
2575: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_name)= FND_API.G_TRUE)
2576: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_low)= FND_API.G_TRUE)
2577: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_high)= FND_API.G_TRUE)) THEN
2578: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range6_low;
2579: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range6_high;

Line 2576: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_low)= FND_API.G_TRUE)

2572: l_valid_bucket_count := l_valid_bucket_count + 1;
2573: END IF;
2574:
2575: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_name)= FND_API.G_TRUE)
2576: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_low)= FND_API.G_TRUE)
2577: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_high)= FND_API.G_TRUE)) THEN
2578: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range6_low;
2579: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range6_high;
2580: l_valid_bucket_count := l_valid_bucket_count + 1;

Line 2577: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_high)= FND_API.G_TRUE)) THEN

2573: END IF;
2574:
2575: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_name)= FND_API.G_TRUE)
2576: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_low)= FND_API.G_TRUE)
2577: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_high)= FND_API.G_TRUE)) THEN
2578: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range6_low;
2579: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range6_high;
2580: l_valid_bucket_count := l_valid_bucket_count + 1;
2581: END IF;

Line 2583: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_name)= FND_API.G_TRUE)

2579: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range6_high;
2580: l_valid_bucket_count := l_valid_bucket_count + 1;
2581: END IF;
2582:
2583: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_name)= FND_API.G_TRUE)
2584: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_low)= FND_API.G_TRUE)
2585: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_high)= FND_API.G_TRUE)) THEN
2586: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range7_low;
2587: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range7_high;

Line 2584: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_low)= FND_API.G_TRUE)

2580: l_valid_bucket_count := l_valid_bucket_count + 1;
2581: END IF;
2582:
2583: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_name)= FND_API.G_TRUE)
2584: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_low)= FND_API.G_TRUE)
2585: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_high)= FND_API.G_TRUE)) THEN
2586: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range7_low;
2587: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range7_high;
2588: l_valid_bucket_count := l_valid_bucket_count + 1;

Line 2585: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_high)= FND_API.G_TRUE)) THEN

2581: END IF;
2582:
2583: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_name)= FND_API.G_TRUE)
2584: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_low)= FND_API.G_TRUE)
2585: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_high)= FND_API.G_TRUE)) THEN
2586: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range7_low;
2587: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range7_high;
2588: l_valid_bucket_count := l_valid_bucket_count + 1;
2589: END IF;

Line 2591: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_name)= FND_API.G_TRUE)

2587: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range7_high;
2588: l_valid_bucket_count := l_valid_bucket_count + 1;
2589: END IF;
2590:
2591: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_name)= FND_API.G_TRUE)
2592: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_low)= FND_API.G_TRUE)
2593: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_high)= FND_API.G_TRUE)) THEN
2594: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range8_low;
2595: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range8_high;

Line 2592: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_low)= FND_API.G_TRUE)

2588: l_valid_bucket_count := l_valid_bucket_count + 1;
2589: END IF;
2590:
2591: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_name)= FND_API.G_TRUE)
2592: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_low)= FND_API.G_TRUE)
2593: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_high)= FND_API.G_TRUE)) THEN
2594: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range8_low;
2595: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range8_high;
2596: l_valid_bucket_count := l_valid_bucket_count + 1;

Line 2593: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_high)= FND_API.G_TRUE)) THEN

2589: END IF;
2590:
2591: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_name)= FND_API.G_TRUE)
2592: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_low)= FND_API.G_TRUE)
2593: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_high)= FND_API.G_TRUE)) THEN
2594: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range8_low;
2595: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range8_high;
2596: l_valid_bucket_count := l_valid_bucket_count + 1;
2597: END IF;

Line 2599: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_name)= FND_API.G_TRUE)

2595: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range8_high;
2596: l_valid_bucket_count := l_valid_bucket_count + 1;
2597: END IF;
2598:
2599: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_name)= FND_API.G_TRUE)
2600: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_low)= FND_API.G_TRUE)
2601: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_high)= FND_API.G_TRUE)) THEN
2602: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range9_low;
2603: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range9_high;

Line 2600: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_low)= FND_API.G_TRUE)

2596: l_valid_bucket_count := l_valid_bucket_count + 1;
2597: END IF;
2598:
2599: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_name)= FND_API.G_TRUE)
2600: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_low)= FND_API.G_TRUE)
2601: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_high)= FND_API.G_TRUE)) THEN
2602: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range9_low;
2603: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range9_high;
2604: l_valid_bucket_count := l_valid_bucket_count + 1;

Line 2601: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_high)= FND_API.G_TRUE)) THEN

2597: END IF;
2598:
2599: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_name)= FND_API.G_TRUE)
2600: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_low)= FND_API.G_TRUE)
2601: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_high)= FND_API.G_TRUE)) THEN
2602: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range9_low;
2603: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range9_high;
2604: l_valid_bucket_count := l_valid_bucket_count + 1;
2605: END IF;

Line 2607: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_name)= FND_API.G_TRUE)

2603: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range9_high;
2604: l_valid_bucket_count := l_valid_bucket_count + 1;
2605: END IF;
2606:
2607: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_name)= FND_API.G_TRUE)
2608: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_low)= FND_API.G_TRUE)
2609: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_high)= FND_API.G_TRUE)) THEN
2610: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range10_low;
2611: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range10_high;

Line 2608: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_low)= FND_API.G_TRUE)

2604: l_valid_bucket_count := l_valid_bucket_count + 1;
2605: END IF;
2606:
2607: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_name)= FND_API.G_TRUE)
2608: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_low)= FND_API.G_TRUE)
2609: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_high)= FND_API.G_TRUE)) THEN
2610: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range10_low;
2611: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range10_high;
2612: END IF;

Line 2609: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_high)= FND_API.G_TRUE)) THEN

2605: END IF;
2606:
2607: IF ((BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_name)= FND_API.G_TRUE)
2608: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_low)= FND_API.G_TRUE)
2609: OR (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_high)= FND_API.G_TRUE)) THEN
2610: x_bucket_ranges_tbl(l_valid_bucket_count).range_low := p_bis_bucket_rec.range10_low;
2611: x_bucket_ranges_tbl(l_valid_bucket_count).range_high := p_bis_bucket_rec.range10_high;
2612: END IF;
2613:

Line 2637: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2633: PROCEDURE Validate_Bucket_Overlapping (
2634: p_overlapping IN VARCHAR2
2635: ,p_bucket_ranges_tbl IN BIS_BUCKET_PVT.bis_bucket_ranges_tbl
2636: ,x_return_status OUT NOCOPY VARCHAR2
2637: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2638: )
2639: IS
2640:
2641: l_bucket_count NUMBER := 0;

Line 2643: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2639: IS
2640:
2641: l_bucket_count NUMBER := 0;
2642: l_error_code VARCHAR2(1);
2643: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2644:
2645: BEGIN
2646:
2647: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2674: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

2670: BIS_UTILITIES_PVT.Add_Error_Message (
2671: p_error_msg_name => 'BIS_BUCKET_SET_OVERLAPPING'
2672: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2673: ,p_error_proc_name => G_PKG_NAME||'.Validate_Bucket_Overlapping'
2674: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
2675: ,p_error_table => l_error_tbl
2676: ,x_error_table => x_error_tbl
2677: );
2678: RAISE FND_API.G_EXC_ERROR;

Line 2701: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2697: PROCEDURE Validate_Bucket_Discontinuous (
2698: p_discontinuous IN VARCHAR2
2699: ,p_bucket_ranges_tbl IN BIS_BUCKET_PVT.bis_bucket_ranges_tbl
2700: ,x_return_status OUT NOCOPY VARCHAR2
2701: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2702: )
2703: IS
2704:
2705: l_bucket_count NUMBER := 0;

Line 2707: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2703: IS
2704:
2705: l_bucket_count NUMBER := 0;
2706: l_error_code VARCHAR2(1);
2707: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2708:
2709: BEGIN
2710:
2711: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2736: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

2732: BIS_UTILITIES_PVT.Add_Error_Message (
2733: p_error_msg_name => 'BIS_BUCKET_SET_DISCONTINUOUS'
2734: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2735: ,p_error_proc_name => G_PKG_NAME||'.Validate_Bucket_Discontinuous'
2736: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
2737: ,p_error_table => l_error_tbl
2738: ,x_error_table => x_error_tbl
2739: );
2740: RAISE FND_API.G_EXC_ERROR;

Line 2759: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2755: --=============================================================================
2756: PROCEDURE Validate_From_To (
2757: p_bucket_ranges_tbl IN BIS_BUCKET_PVT.bis_bucket_ranges_tbl
2758: ,x_return_status OUT NOCOPY VARCHAR2
2759: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2760: )
2761: IS
2762:
2763: l_bucket_count NUMBER := 0;

Line 2765: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2761: IS
2762:
2763: l_bucket_count NUMBER := 0;
2764: l_error_code VARCHAR2(1);
2765: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2766: l_error_message VARCHAR2(50);
2767:
2768: BEGIN
2769:

Line 2790: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

2786: BIS_UTILITIES_PVT.Add_Error_Message (
2787: p_error_msg_name => l_error_message
2788: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2789: ,p_error_proc_name => G_PKG_NAME||'.Validate_From_To'
2790: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
2791: ,p_error_table => l_error_tbl
2792: ,x_error_table => x_error_tbl
2793: );
2794: RAISE FND_API.G_EXC_ERROR;

Line 2857: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2853: IS
2854:
2855: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
2856: l_return_status VARCHAR2(10);
2857: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2858:
2859: BEGIN
2860:
2861: l_bis_bucket_rec.short_name := p_short_name;

Line 2956: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2952: --The common validation that good for bucket. (Normal, Customized)
2953: PROCEDURE Validate_Bucket_Common (
2954: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
2955: ,x_return_status OUT NOCOPY VARCHAR2
2956: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2957: ) IS
2958:
2959: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2960: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

Line 2959: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2955: ,x_return_status OUT NOCOPY VARCHAR2
2956: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2957: ) IS
2958:
2959: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2960: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
2961:
2962: l_bucket_ranges_tbl BIS_BUCKET_PVT.BIS_BUCKET_RANGES_TBL;
2963:

Line 2977: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

2973: BIS_UTILITIES_PVT.Add_Error_Message (
2974: p_error_msg_name => 'BIS_INVALID_BUCKET_TYPE'
2975: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2976: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET_TYPE'
2977: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
2978: ,p_error_table => l_error_tbl
2979: ,x_error_table => x_error_tbl
2980: );
2981: RAISE FND_API.G_EXC_ERROR;

Line 2990: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

2986: BIS_UTILITIES_PVT.Add_Error_Message (
2987: p_error_msg_name => 'BIS_DUPLICATE_RANGE_NAME'
2988: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2989: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET'
2990: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
2991: ,p_error_table => l_error_tbl
2992: ,x_error_table => x_error_tbl
2993: );
2994: RAISE FND_API.G_EXC_ERROR;

Line 3003: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

2999: BIS_UTILITIES_PVT.Add_Error_Message (
3000: p_error_msg_name => 'BIS_DUPLICATE_VAL_HIGH'
3001: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3002: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET'
3003: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
3004: ,p_error_table => l_error_tbl
3005: ,x_error_table => x_error_tbl
3006: );
3007: RAISE FND_API.G_EXC_ERROR;

Line 3016: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR

3012: BIS_UTILITIES_PVT.Add_Error_Message (
3013: p_error_msg_name => 'BIS_DUPLICATE_VAL_LOW'
3014: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3015: ,p_error_proc_name => G_PKG_NAME||'.CREATE_BIS_BUCKET'
3016: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
3017: ,p_error_table => l_error_tbl
3018: ,x_error_table => x_error_tbl
3019: );
3020: RAISE FND_API.G_EXC_ERROR;