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_AK_REGION_PUB dependencies on FND_API

Line 1074: WHEN FND_API.G_EXC_ERROR THEN

1070: X_ATTRIBUTE14 => p_ATTRIBUTE14,
1071: X_ATTRIBUTE15 => p_ATTRIBUTE15);
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1077: ,p_data => x_msg_data);
1078: WHEN OTHERS THEN

Line 1075: x_return_status := FND_API.G_RET_STS_ERROR;

1071: X_ATTRIBUTE15 => p_ATTRIBUTE15);
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1077: ,p_data => x_msg_data);
1078: WHEN OTHERS THEN
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1077: ,p_data => x_msg_data);
1078: WHEN OTHERS THEN
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1081: ,p_data => x_msg_data);
1082: if (x_msg_data is null) then
1083: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_ROW: ' || SQLERRM;

Line 1090: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

1086: end INSERT_REGION_ROW;
1087:
1088: -- nbarik 02/10/04 - overloaded for region record type
1089: PROCEDURE INSERT_REGION_ROW
1090: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
1091: , p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type
1092: , x_return_status OUT NOCOPY VARCHAR2
1093: , x_msg_count OUT NOCOPY NUMBER
1094: , x_msg_data OUT NOCOPY VARCHAR2

Line 1100: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1096:
1097: l_rowid VARCHAR2(30);
1098: BEGIN
1099:
1100: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1101:
1102: IF valid_database_object(p_Report_Region_Rec.Database_Object_Name) and not AK_OBJECT_EXISTS(p_Report_Region_Rec.Database_Object_Name) THEN
1103: INSERT_AK_OBJECT(
1104: P_DATABASE_OBJECT_NAME => p_Report_Region_Rec.Database_Object_Name,

Line 1155: IF (p_commit = FND_API.G_TRUE) THEN

1151: , X_ATTRIBUTE14 => NULL
1152: , X_ATTRIBUTE15 => NULL
1153: );
1154:
1155: IF (p_commit = FND_API.G_TRUE) THEN
1156: COMMIT;
1157: END IF;
1158:
1159: EXCEPTION

Line 1160: WHEN FND_API.G_EXC_ERROR THEN

1156: COMMIT;
1157: END IF;
1158:
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: WHEN OTHERS THEN

Line 1161: x_return_status := FND_API.G_RET_STS_ERROR;

1157: END IF;
1158:
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: WHEN OTHERS THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: WHEN OTHERS THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1167: ,p_data => x_msg_data);
1168: IF (x_msg_data IS NULL) THEN
1169: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ROW: ' || SQLERRM;

Line 1427: WHEN FND_API.G_EXC_ERROR THEN

1423: X_ATTRIBUTE14 => l_region_rec.attribute14,
1424: X_ATTRIBUTE15 => l_region_rec.attribute15);
1425:
1426: EXCEPTION
1427: WHEN FND_API.G_EXC_ERROR THEN
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1430: ,p_data => x_msg_data);
1431: WHEN OTHERS THEN

Line 1428: x_return_status := FND_API.G_RET_STS_ERROR;

1424: X_ATTRIBUTE15 => l_region_rec.attribute15);
1425:
1426: EXCEPTION
1427: WHEN FND_API.G_EXC_ERROR THEN
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1430: ,p_data => x_msg_data);
1431: WHEN OTHERS THEN
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1430: ,p_data => x_msg_data);
1431: WHEN OTHERS THEN
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1434: ,p_data => x_msg_data);
1435: if (x_msg_data is null) then
1436: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;

Line 1443: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

1439: end UPDATE_REGION_ROW;
1440:
1441: -- nbarik 02/10/04 - overloaded for region record type
1442: PROCEDURE UPDATE_REGION_ROW
1443: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
1444: , p_Report_Region_Rec IN BIS_AK_REGION_PUB.Bis_Region_Rec_Type
1445: , x_return_status OUT NOCOPY VARCHAR2
1446: , x_msg_count OUT NOCOPY NUMBER
1447: , x_msg_data OUT NOCOPY VARCHAR2

Line 1505: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1501: AND region_application_id = p_Report_Region_Rec.Region_Application_Id;
1502:
1503: BEGIN
1504:
1505: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1506: IF cRegion%ISOPEN THEN
1507: CLOSE cRegion;
1508: END IF;
1509: OPEN cRegion;

Line 1666: IF (p_commit = FND_API.G_TRUE) THEN

1662: X_ATTRIBUTE13 => l_region_rec.attribute13,
1663: X_ATTRIBUTE14 => l_region_rec.attribute14,
1664: X_ATTRIBUTE15 => l_region_rec.attribute15);
1665:
1666: IF (p_commit = FND_API.G_TRUE) THEN
1667: COMMIT;
1668: END IF;
1669:
1670: EXCEPTION

Line 1671: WHEN FND_API.G_EXC_ERROR THEN

1667: COMMIT;
1668: END IF;
1669:
1670: EXCEPTION
1671: WHEN FND_API.G_EXC_ERROR THEN
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1674: ,p_data => x_msg_data);
1675: WHEN OTHERS THEN

Line 1672: x_return_status := FND_API.G_RET_STS_ERROR;

1668: END IF;
1669:
1670: EXCEPTION
1671: WHEN FND_API.G_EXC_ERROR THEN
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1674: ,p_data => x_msg_data);
1675: WHEN OTHERS THEN
1676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1674: ,p_data => x_msg_data);
1675: WHEN OTHERS THEN
1676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1678: ,p_data => x_msg_data);
1679: IF (x_msg_data IS NULL) THEN
1680: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ROW: ' || SQLERRM;

Line 1692: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1688: ,p_REGION_APPLICATION_ID in NUMBER
1689: ,x_return_status OUT NOCOPY VARCHAR2
1690: ,x_msg_count OUT NOCOPY NUMBER
1691: ,x_msg_data OUT NOCOPY VARCHAR2
1692: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1693: ) IS
1694: BEGIN
1695:
1696: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 1696: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1692: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1693: ) IS
1694: BEGIN
1695:
1696: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1697:
1698: AK_REGIONS_PKG.DELETE_ROW(
1699: X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
1700: X_REGION_CODE => p_REGION_CODE

Line 1703: IF (p_commit = FND_API.G_TRUE) THEN

1699: X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
1700: X_REGION_CODE => p_REGION_CODE
1701: );
1702:
1703: IF (p_commit = FND_API.G_TRUE) THEN
1704: COMMIT;
1705: END IF;
1706:
1707: EXCEPTION

Line 1708: WHEN FND_API.G_EXC_ERROR THEN

1704: COMMIT;
1705: END IF;
1706:
1707: EXCEPTION
1708: WHEN FND_API.G_EXC_ERROR THEN
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1711: ,p_data => x_msg_data);
1712: WHEN OTHERS THEN

Line 1709: x_return_status := FND_API.G_RET_STS_ERROR;

1705: END IF;
1706:
1707: EXCEPTION
1708: WHEN FND_API.G_EXC_ERROR THEN
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1711: ,p_data => x_msg_data);
1712: WHEN OTHERS THEN
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1711: ,p_data => x_msg_data);
1712: WHEN OTHERS THEN
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1715: ,p_data => x_msg_data);
1716: if (x_msg_data is null) then
1717: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ROW: ' || SQLERRM;

Line 1769: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1765: and attribute_application_id = p_ATTRIBUTE_APPLICATION_ID;
1766:
1767: begin
1768:
1769: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1770: if cAttributeExists%ISOPEN then
1771: CLOSE cAttributeExists;
1772: end if;
1773: OPEN cAttributeExists;

Line 1948: WHEN FND_API.G_EXC_ERROR THEN

1944: X_ATTRIBUTE14 => p_ATTRIBUTE14,
1945: X_ATTRIBUTE15 => p_ATTRIBUTE15);
1946:
1947: EXCEPTION
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1951: ,p_data => x_msg_data);
1952: WHEN OTHERS THEN

Line 1949: x_return_status := FND_API.G_RET_STS_ERROR;

1945: X_ATTRIBUTE15 => p_ATTRIBUTE15);
1946:
1947: EXCEPTION
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1951: ,p_data => x_msg_data);
1952: WHEN OTHERS THEN
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1951: ,p_data => x_msg_data);
1952: WHEN OTHERS THEN
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1955: ,p_data => x_msg_data);
1956: if (x_msg_data is null) then
1957: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;

Line 1964: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

1960: end INSERT_REGION_ITEM_ROW;
1961:
1962: -- nbarik 02/10/04 - overloaded for region record type
1963: PROCEDURE INSERT_REGION_ITEM_ROW
1964: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
1965: , p_region_code IN VARCHAR2
1966: , p_region_application_id IN NUMBER
1967: , p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
1968: , x_return_status OUT NOCOPY VARCHAR2

Line 1986: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1982: AND attribute_application_id = p_Region_Item_Rec.Attribute_Application_Id;
1983:
1984: BEGIN
1985:
1986: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1987:
1988: IF cAttributeExists%ISOPEN THEN
1989: CLOSE cAttributeExists;
1990: END IF;

Line 2162: IF (p_commit = FND_API.G_TRUE) THEN

2158: X_ATTRIBUTE13 => p_Region_Item_Rec.Variance,
2159: X_ATTRIBUTE14 => p_Region_Item_Rec.Display_Type,
2160: X_ATTRIBUTE15 => p_Region_Item_Rec.Lov_Table);
2161:
2162: IF (p_commit = FND_API.G_TRUE) THEN
2163: COMMIT;
2164: END IF;
2165:
2166: EXCEPTION

Line 2167: WHEN FND_API.G_EXC_ERROR THEN

2163: COMMIT;
2164: END IF;
2165:
2166: EXCEPTION
2167: WHEN FND_API.G_EXC_ERROR THEN
2168: x_return_status := FND_API.G_RET_STS_ERROR;
2169: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2170: ,p_data => x_msg_data);
2171: WHEN OTHERS THEN

Line 2168: x_return_status := FND_API.G_RET_STS_ERROR;

2164: END IF;
2165:
2166: EXCEPTION
2167: WHEN FND_API.G_EXC_ERROR THEN
2168: x_return_status := FND_API.G_RET_STS_ERROR;
2169: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2170: ,p_data => x_msg_data);
2171: WHEN OTHERS THEN
2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2168: x_return_status := FND_API.G_RET_STS_ERROR;
2169: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2170: ,p_data => x_msg_data);
2171: WHEN OTHERS THEN
2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2173: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2174: ,p_data => x_msg_data);
2175: IF (x_msg_data IS NULL) THEN
2176: x_msg_data := 'BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW: ' || SQLERRM;

Line 2184: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

2180:
2181: -- nbarik 02/10/04 - overloaded for region record type
2182: -- adrao 05/12/04 -- added Nested Region & Nested Region Application Id
2183: PROCEDURE UPDATE_REGION_ITEM_ROW
2184: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
2185: , p_region_code IN VARCHAR2
2186: , p_region_application_id IN NUMBER
2187: , p_Region_Item_Rec IN BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type
2188: , x_return_status OUT NOCOPY VARCHAR2

Line 2285: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2281: c_region_item_rec cRegionItem%ROWTYPE;
2282:
2283: BEGIN
2284: -- Save the current data
2285: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2286:
2287: IF cRegionItem%ISOPEN THEN
2288: CLOSE cRegionItem;
2289: END IF;

Line 2470: IF (p_commit = FND_API.G_TRUE) THEN

2466: X_ATTRIBUTE13 => p_Region_Item_Rec.Variance,
2467: X_ATTRIBUTE14 => p_Region_Item_Rec.Display_Type,
2468: X_ATTRIBUTE15 => p_Region_Item_Rec.Lov_Table);
2469:
2470: IF (p_commit = FND_API.G_TRUE) THEN
2471: COMMIT;
2472: END IF;
2473:
2474: END IF;

Line 2478: WHEN FND_API.G_EXC_ERROR THEN

2474: END IF;
2475: CLOSE cRegionItem;
2476:
2477: EXCEPTION
2478: WHEN FND_API.G_EXC_ERROR THEN
2479: x_return_status := FND_API.G_RET_STS_ERROR;
2480: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2481: ,p_data => x_msg_data);
2482: WHEN OTHERS THEN

Line 2479: x_return_status := FND_API.G_RET_STS_ERROR;

2475: CLOSE cRegionItem;
2476:
2477: EXCEPTION
2478: WHEN FND_API.G_EXC_ERROR THEN
2479: x_return_status := FND_API.G_RET_STS_ERROR;
2480: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2481: ,p_data => x_msg_data);
2482: WHEN OTHERS THEN
2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2479: x_return_status := FND_API.G_RET_STS_ERROR;
2480: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2481: ,p_data => x_msg_data);
2482: WHEN OTHERS THEN
2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2484: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2485: ,p_data => x_msg_data);
2486: IF (x_msg_data IS NULL) THEN
2487: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ROW: ' || SQLERRM;

Line 2501: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2497: ,p_ATTRIBUTE_APPLICATION_ID in NUMBER
2498: ,x_return_status OUT NOCOPY VARCHAR2
2499: ,x_msg_count OUT NOCOPY NUMBER
2500: ,x_msg_data OUT NOCOPY VARCHAR2
2501: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2502: ) IS
2503: BEGIN
2504:
2505: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 2505: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2501: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2502: ) IS
2503: BEGIN
2504:
2505: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2506:
2507: AK_REGION_ITEMS_PKG.DELETE_ROW(
2508: X_REGION_APPLICATION_ID => p_REGION_APPLICATION_ID,
2509: X_REGION_CODE => p_REGION_CODE,

Line 2514: IF (p_commit = FND_API.G_TRUE) THEN

2510: X_ATTRIBUTE_APPLICATION_ID => p_ATTRIBUTE_APPLICATION_ID,
2511: X_ATTRIBUTE_CODE => p_ATTRIBUTE_CODE
2512: );
2513:
2514: IF (p_commit = FND_API.G_TRUE) THEN
2515: COMMIT;
2516: END IF;
2517:
2518: EXCEPTION

Line 2519: WHEN FND_API.G_EXC_ERROR THEN

2515: COMMIT;
2516: END IF;
2517:
2518: EXCEPTION
2519: WHEN FND_API.G_EXC_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2522: ,p_data => x_msg_data);
2523: WHEN OTHERS THEN

Line 2520: x_return_status := FND_API.G_RET_STS_ERROR;

2516: END IF;
2517:
2518: EXCEPTION
2519: WHEN FND_API.G_EXC_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2522: ,p_data => x_msg_data);
2523: WHEN OTHERS THEN
2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2522: ,p_data => x_msg_data);
2523: WHEN OTHERS THEN
2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2525: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2526: ,p_data => x_msg_data);
2527: if (x_msg_data is null) then
2528: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW: ' || SQLERRM;

Line 2567: p_commit => FND_API.G_FALSE,

2563: x_msg_count => x_msg_count,
2564: x_msg_data =>x_msg_data);
2565:
2566: BIS_REGION_EXTENSION_PVT.DELETE_REGION_EXTN_RECORD(
2567: p_commit => FND_API.G_FALSE,
2568: pRegionCode => p_REGION_CODE,
2569: pRegionAppId => p_REGION_APPLICATION_ID);
2570:
2571: BIS_CUSTOMIZATIONS_PVT.delete_region_customizations

Line 2580: WHEN FND_API.G_EXC_ERROR THEN

2576: , x_msg_data => x_msg_data
2577: );
2578:
2579: EXCEPTION
2580: WHEN FND_API.G_EXC_ERROR THEN
2581: x_return_status := FND_API.G_RET_STS_ERROR;
2582: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2583: ,p_data => x_msg_data);
2584: WHEN OTHERS THEN

Line 2581: x_return_status := FND_API.G_RET_STS_ERROR;

2577: );
2578:
2579: EXCEPTION
2580: WHEN FND_API.G_EXC_ERROR THEN
2581: x_return_status := FND_API.G_RET_STS_ERROR;
2582: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2583: ,p_data => x_msg_data);
2584: WHEN OTHERS THEN
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2581: x_return_status := FND_API.G_RET_STS_ERROR;
2582: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2583: ,p_data => x_msg_data);
2584: WHEN OTHERS THEN
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2587: ,p_data => x_msg_data);
2588: if (x_msg_data is null) then
2589: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_AND_REGION_ITEMS: ' || SQLERRM;

Line 2631: WHEN FND_API.G_EXC_ERROR THEN

2627: close items_cursor;
2628: end if;
2629:
2630: EXCEPTION
2631: WHEN FND_API.G_EXC_ERROR THEN
2632: x_return_status := FND_API.G_RET_STS_ERROR;
2633: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2634: ,p_data => x_msg_data);
2635: WHEN OTHERS THEN

Line 2632: x_return_status := FND_API.G_RET_STS_ERROR;

2628: end if;
2629:
2630: EXCEPTION
2631: WHEN FND_API.G_EXC_ERROR THEN
2632: x_return_status := FND_API.G_RET_STS_ERROR;
2633: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2634: ,p_data => x_msg_data);
2635: WHEN OTHERS THEN
2636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2632: x_return_status := FND_API.G_RET_STS_ERROR;
2633: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2634: ,p_data => x_msg_data);
2635: WHEN OTHERS THEN
2636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2637: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2638: ,p_data => x_msg_data);
2639: if (x_msg_data is null) then
2640: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_REGION_ITEMS: ' || SQLERRM;

Line 2667: p_commit => FND_API.G_FALSE,

2663: end if;
2664:
2665: for cr in items_cursor loop
2666: BIS_REGION_ITEM_EXTENSION_PVT.DELETE_REGION_ITEM_RECORD(
2667: p_commit => FND_API.G_FALSE,
2668: pRegionCode => p_REGION_CODE,
2669: pRegionAppId => p_REGION_APPLICATION_ID,
2670: pAttributeCode => cr.attribute_code,
2671: pAttributeAppId => cr.attribute_application_id);

Line 2679: WHEN FND_API.G_EXC_ERROR THEN

2675: close items_cursor;
2676: end if;
2677:
2678: EXCEPTION
2679: WHEN FND_API.G_EXC_ERROR THEN
2680: x_return_status := FND_API.G_RET_STS_ERROR;
2681: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2682: ,p_data => x_msg_data);
2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2680: x_return_status := FND_API.G_RET_STS_ERROR;

2676: end if;
2677:
2678: EXCEPTION
2679: WHEN FND_API.G_EXC_ERROR THEN
2680: x_return_status := FND_API.G_RET_STS_ERROR;
2681: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2682: ,p_data => x_msg_data);
2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2679: WHEN FND_API.G_EXC_ERROR THEN
2680: x_return_status := FND_API.G_RET_STS_ERROR;
2681: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2682: ,p_data => x_msg_data);
2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2686: ,p_data => x_msg_data);
2687: WHEN NO_DATA_FOUND THEN

Line 2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2680: x_return_status := FND_API.G_RET_STS_ERROR;
2681: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2682: ,p_data => x_msg_data);
2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2686: ,p_data => x_msg_data);
2687: WHEN NO_DATA_FOUND THEN
2688: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2688: x_return_status := FND_API.G_RET_STS_ERROR;

2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2686: ,p_data => x_msg_data);
2687: WHEN NO_DATA_FOUND THEN
2688: x_return_status := FND_API.G_RET_STS_ERROR;
2689: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2690: ,p_data => x_msg_data);
2691: WHEN OTHERS THEN
2692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2688: x_return_status := FND_API.G_RET_STS_ERROR;
2689: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2690: ,p_data => x_msg_data);
2691: WHEN OTHERS THEN
2692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2694: ,p_data => x_msg_data);
2695: if (x_msg_data is null) then
2696: x_msg_data := 'BIS_AK_REGION_PUB.DELETE_EXT_ITEMS: ' || SQLERRM;

Line 2834: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2830: AND attribute_application_id = p_Attribute_Application_Id;
2831:
2832: BEGIN
2833: -- Save the current data
2834: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2835:
2836: x_Region_Item_Rec.Attribute_Code := p_Attribute_Code;
2837: x_Region_Item_Rec.Attribute_Application_Id := p_Attribute_Application_Id;
2838: IF cRegionItem%ISOPEN THEN

Line 2871: x_return_status := FND_API.G_RET_STS_ERROR;

2867: CLOSE cRegionItem;
2868:
2869: EXCEPTION
2870: WHEN NO_DATA_FOUND THEN
2871: x_return_status := FND_API.G_RET_STS_ERROR;
2872: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2873: ,p_data => x_msg_data);
2874: WHEN OTHERS THEN
2875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2871: x_return_status := FND_API.G_RET_STS_ERROR;
2872: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2873: ,p_data => x_msg_data);
2874: WHEN OTHERS THEN
2875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2876: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2877: ,p_data => x_msg_data);
2878: IF (x_msg_data IS NULL) THEN
2879: x_msg_data := 'BIS_AK_REGION_PUB.GET_REGION_ITEM_REC: ' || SQLERRM;

Line 2886: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

2882:
2883:
2884: --deprecated, call the next one with p_type parameter
2885: PROCEDURE UPDATE_REGION_ITEM_ATTR
2886: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
2887: , p_region_code IN VARCHAR2
2888: , p_region_application_id IN NUMBER
2889: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
2890: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

Line 2906: x_return_status := FND_API.G_RET_STS_SUCCESS;

2902: l_ret_status VARCHAR2(10);
2903:
2904: BEGIN
2905: -- Save the current data
2906: x_return_status := FND_API.G_RET_STS_SUCCESS;
2907:
2908: BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR
2909: ( p_commit => p_commit
2910: , p_region_code => p_region_code

Line 2922: WHEN FND_API.G_EXC_ERROR THEN

2918: , x_msg_count => x_msg_count
2919: , x_msg_data => x_msg_data
2920: );
2921: EXCEPTION
2922: WHEN FND_API.G_EXC_ERROR THEN
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2925: ,p_data => x_msg_data);
2926: WHEN OTHERS THEN

Line 2923: x_return_status := FND_API.G_RET_STS_ERROR;

2919: , x_msg_data => x_msg_data
2920: );
2921: EXCEPTION
2922: WHEN FND_API.G_EXC_ERROR THEN
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2925: ,p_data => x_msg_data);
2926: WHEN OTHERS THEN
2927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2925: ,p_data => x_msg_data);
2926: WHEN OTHERS THEN
2927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2928: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
2929: ,p_data => x_msg_data);
2930: IF (x_msg_data IS NULL) THEN
2931: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;

Line 2938: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

2934:
2935: --bug#3859267: overloaded to take in p_type, which is one of
2936: --C_MEASURE, C_MEASURE_NO_TARGET, or C_COMPARE_TO_MEASURE_NO_TARGET
2937: PROCEDURE UPDATE_REGION_ITEM_ATTR
2938: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
2939: , p_region_code IN VARCHAR2
2940: , p_region_application_id IN NUMBER
2941: , p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
2942: , p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

Line 2961: x_return_status := FND_API.G_RET_STS_SUCCESS;

2957: l_type VARCHAR2(30);
2958:
2959: BEGIN
2960: -- Save the current data
2961: x_return_status := FND_API.G_RET_STS_SUCCESS;
2962: --make sure p_type is recognized
2963: IF ((p_type IS NOT NULL) AND
2964: (p_type <> BIS_AK_REGION_PUB.C_MEASURE) AND
2965: (p_type <> BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET) AND

Line 2967: RAISE FND_API.G_EXC_ERROR;

2963: IF ((p_type IS NOT NULL) AND
2964: (p_type <> BIS_AK_REGION_PUB.C_MEASURE) AND
2965: (p_type <> BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET) AND
2966: (p_type <> BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET)) THEN
2967: RAISE FND_API.G_EXC_ERROR;
2968: END IF;
2969:
2970: BIS_AK_REGION_PUB.GET_REGION_ITEM_REC
2971: ( p_region_code => p_region_code

Line 2981: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN

2977: , x_msg_count => l_msg_count
2978: , x_msg_data => l_msg_data
2979: );
2980:
2981: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983: END IF;
2984:
2985: --set type

Line 2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2978: , x_msg_data => l_msg_data
2979: );
2980:
2981: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983: END IF;
2984:
2985: --set type
2986: IF (p_type IS NULL) THEN

Line 2993: IF (BIS_UTILITIES_PUB.Value_Missing(l_Region_Item_Rec.Attribute_Type) = FND_API.G_TRUE) THEN

2989: l_type := p_type;
2990: END IF;
2991:
2992: --check attribute1
2993: IF (BIS_UTILITIES_PUB.Value_Missing(l_Region_Item_Rec.Attribute_Type) = FND_API.G_TRUE) THEN
2994: l_Region_Item_Rec.Attribute_Type := BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET;
2995: END IF;
2996:
2997: --set attribute2

Line 2998: IF (BIS_UTILITIES_PUB.Value_Missing(p_Short_Name) = FND_API.G_TRUE) THEN

2994: l_Region_Item_Rec.Attribute_Type := BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET;
2995: END IF;
2996:
2997: --set attribute2
2998: IF (BIS_UTILITIES_PUB.Value_Missing(p_Short_Name) = FND_API.G_TRUE) THEN
2999: l_Region_Item_Rec.Measure_Level := NULL;
3000: IF (IS_COMPARE_TYPE(l_Region_Item_Rec.Attribute_Type) = TRUE) THEN
3001: l_Region_Item_Rec.Attribute_Type := NULL;
3002: END IF;

Line 3004: IF ((BIS_UTILITIES_PUB.Value_Missing(l_Region_Item_Rec.Measure_Level) = FND_API.G_TRUE) OR

3000: IF (IS_COMPARE_TYPE(l_Region_Item_Rec.Attribute_Type) = TRUE) THEN
3001: l_Region_Item_Rec.Attribute_Type := NULL;
3002: END IF;
3003: ELSE
3004: IF ((BIS_UTILITIES_PUB.Value_Missing(l_Region_Item_Rec.Measure_Level) = FND_API.G_TRUE) OR
3005: (COMPARE_TYPE_AND_SHORTNAME(l_Region_Item_Rec.Attribute_Type, l_Region_Item_Rec.Measure_Level, l_type, p_Short_Name) = TRUE) OR
3006: ((IS_MEASURE_TYPE(l_Region_Item_Rec.Attribute_Type) = TRUE) AND
3007: (VALIDATE_MEASURE(p_short_name=>l_Region_Item_Rec.Measure_Level, x_measure_short_name=>l_measure_short_name, x_measure_name=>l_measure_name) = FALSE)) OR
3008: ((IS_COMPARE_TYPE(l_Region_Item_Rec.Attribute_Type) = TRUE) AND

Line 3014: IF (BIS_UTILITIES_PUB.Value_Missing(l_Region_Item_Rec.Long_Label) = FND_API.G_TRUE) THEN

3010:
3011: l_Region_Item_Rec.Attribute_Type := l_type;
3012: l_Region_Item_Rec.Measure_Level := p_Short_Name;
3013:
3014: IF (BIS_UTILITIES_PUB.Value_Missing(l_Region_Item_Rec.Long_Label) = FND_API.G_TRUE) THEN
3015: l_Region_Item_Rec.Long_Label := substrb(p_Meas_Name, 1, 80);
3016: END IF;
3017: --special handlings for view-based report:
3018: IF (IS_VIEW_BASED_REPORT(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN

Line 3018: IF (IS_VIEW_BASED_REPORT(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN

3014: IF (BIS_UTILITIES_PUB.Value_Missing(l_Region_Item_Rec.Long_Label) = FND_API.G_TRUE) THEN
3015: l_Region_Item_Rec.Long_Label := substrb(p_Meas_Name, 1, 80);
3016: END IF;
3017: --special handlings for view-based report:
3018: IF (IS_VIEW_BASED_REPORT(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN
3019:
3020: --bug#4018318: set node_display_flag to 'N' for compare type for view based report
3021: IF (IS_COMPARE_TYPE(l_Region_Item_Rec.Attribute_Type) = TRUE) THEN
3022: l_Region_Item_Rec.Node_Display_Flag := 'N';

Line 3032: IF (IS_VIEW_BY_REPORT(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN

3028:
3029: --handle measure type here:
3030: IF (IS_MEASURE_TYPE(l_Region_Item_Rec.Attribute_Type) = TRUE) THEN
3031: --if veiw based and view by report, for measure type, if attribute9 is null, set it to 'SUM'
3032: IF (IS_VIEW_BY_REPORT(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN
3033: l_Region_Item_Rec.Aggregate_Function := BIS_AK_REGION_PUB.C_SUM;
3034: ELSIF (IS_AGGREGATE_DEFINED(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN
3035: --if view based and non-view by report, for measure type, if attribute9 is null,
3036: --check if any other column in the same report has non-null attribute9, is so, set this measure column to 'SUM'

Line 3034: ELSIF (IS_AGGREGATE_DEFINED(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN

3030: IF (IS_MEASURE_TYPE(l_Region_Item_Rec.Attribute_Type) = TRUE) THEN
3031: --if veiw based and view by report, for measure type, if attribute9 is null, set it to 'SUM'
3032: IF (IS_VIEW_BY_REPORT(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN
3033: l_Region_Item_Rec.Aggregate_Function := BIS_AK_REGION_PUB.C_SUM;
3034: ELSIF (IS_AGGREGATE_DEFINED(p_region_code, p_region_application_id) = FND_API.G_TRUE) THEN
3035: --if view based and non-view by report, for measure type, if attribute9 is null,
3036: --check if any other column in the same report has non-null attribute9, is so, set this measure column to 'SUM'
3037: l_Region_Item_Rec.Aggregate_Function := BIS_AK_REGION_PUB.C_SUM;
3038: END IF;

Line 3062: WHEN FND_API.G_EXC_ERROR THEN

3058: , x_msg_data => x_msg_data
3059: );
3060:
3061: EXCEPTION
3062: WHEN FND_API.G_EXC_ERROR THEN
3063: x_return_status := FND_API.G_RET_STS_ERROR;
3064: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3065: ,p_data => x_msg_data);
3066: WHEN OTHERS THEN

Line 3063: x_return_status := FND_API.G_RET_STS_ERROR;

3059: );
3060:
3061: EXCEPTION
3062: WHEN FND_API.G_EXC_ERROR THEN
3063: x_return_status := FND_API.G_RET_STS_ERROR;
3064: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3065: ,p_data => x_msg_data);
3066: WHEN OTHERS THEN
3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3063: x_return_status := FND_API.G_RET_STS_ERROR;
3064: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3065: ,p_data => x_msg_data);
3066: WHEN OTHERS THEN
3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3068: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3069: ,p_data => x_msg_data);
3070: IF (x_msg_data IS NULL) THEN
3071: x_msg_data := 'BIS_AK_REGION_PUB.UPDATE_REGION_ITEM_ATTR: ' || SQLERRM;

Line 3199: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;

3195: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
3196: ) RETURN VARCHAR2
3197: IS
3198: l_attribute10 Ak_Regions.ATTRIBUTE10%TYPE;
3199: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;
3200: BEGIN
3201: SELECT attribute10 INTO l_attribute10
3202: FROM ak_regions
3203: WHERE region_code = p_region_code

Line 3207: l_ret_val := FND_API.G_TRUE;

3203: WHERE region_code = p_region_code
3204: AND region_application_id = p_region_app_id;
3205:
3206: IF (l_attribute10 IS NULL) THEN
3207: l_ret_val := FND_API.G_TRUE;
3208: ELSE
3209: l_ret_val := FND_API.G_FALSE;
3210: END IF;
3211:

Line 3209: l_ret_val := FND_API.G_FALSE;

3205:
3206: IF (l_attribute10 IS NULL) THEN
3207: l_ret_val := FND_API.G_TRUE;
3208: ELSE
3209: l_ret_val := FND_API.G_FALSE;
3210: END IF;
3211:
3212: RETURN l_ret_val;
3213: EXCEPTION

Line 3215: RETURN FND_API.G_FALSE;

3211:
3212: RETURN l_ret_val;
3213: EXCEPTION
3214: WHEN OTHERS THEN
3215: RETURN FND_API.G_FALSE;
3216: END IS_VIEW_BASED_REPORT;
3217:
3218:
3219: --return 'T' if given report is view-by, 'F' otherwise

Line 3226: l_ret_val VARCHAR2(1) := FND_API.G_TRUE;

3222: ,p_region_app_id IN Ak_Regions.REGION_APPLICATION_ID%Type
3223: ) RETURN VARCHAR2
3224: IS
3225: l_attribute1 Ak_Regions.ATTRIBUTE1%TYPE;
3226: l_ret_val VARCHAR2(1) := FND_API.G_TRUE;
3227: BEGIN
3228: SELECT attribute1 INTO l_attribute1
3229: FROM ak_regions
3230: WHERE region_code = p_region_code

Line 3234: l_ret_val := FND_API.G_TRUE;

3230: WHERE region_code = p_region_code
3231: AND region_application_id = p_region_app_id;
3232:
3233: IF ((l_attribute1 = 'N') OR (l_attribute1 IS NULL)) THEN
3234: l_ret_val := FND_API.G_TRUE;
3235: ELSIF (l_attribute1 = 'Y') THEN
3236: l_ret_val := FND_API.G_FALSE;
3237: END IF;
3238:

Line 3236: l_ret_val := FND_API.G_FALSE;

3232:
3233: IF ((l_attribute1 = 'N') OR (l_attribute1 IS NULL)) THEN
3234: l_ret_val := FND_API.G_TRUE;
3235: ELSIF (l_attribute1 = 'Y') THEN
3236: l_ret_val := FND_API.G_FALSE;
3237: END IF;
3238:
3239: RETURN l_ret_val;
3240: EXCEPTION

Line 3242: RETURN FND_API.G_TRUE;

3238:
3239: RETURN l_ret_val;
3240: EXCEPTION
3241: WHEN OTHERS THEN
3242: RETURN FND_API.G_TRUE;
3243: END IS_VIEW_BY_REPORT;
3244:
3245: --return 'T' if at least one aggregate function is defined in any column
3246: --for the given report, 'F' otherwise

Line 3253: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;

3249: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
3250: ) RETURN VARCHAR2
3251: IS
3252: l_count NUMBER := 0;
3253: l_ret_val VARCHAR2(1) := FND_API.G_FALSE;
3254: BEGIN
3255: SELECT COUNT(0) INTO l_count
3256: FROM ak_region_items
3257: WHERE region_code = p_region_code

Line 3262: l_ret_val := FND_API.G_TRUE;

3258: AND region_application_id = p_region_app_id
3259: AND attribute9 IS NOT NULL;
3260:
3261: IF (l_count > 0) THEN
3262: l_ret_val := FND_API.G_TRUE;
3263: END IF;
3264:
3265: RETURN l_ret_val;
3266: EXCEPTION

Line 3268: RETURN FND_API.G_FALSE;

3264:
3265: RETURN l_ret_val;
3266: EXCEPTION
3267: WHEN OTHERS THEN
3268: RETURN FND_API.G_FALSE;
3269: END IS_AGGREGATE_DEFINED;
3270:
3271: -- added for Bug#4448994 and as a general utility file.
3272: PROCEDURE Get_Region_Code_TL_Data (

Line 3302: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

3298: WHERE A.REGION_CODE = p_Region_Code
3299: AND A.REGION_APPLICATION_ID = p_Region_Application_Id;
3300: BEGIN
3301: FND_MSG_PUB.Initialize;
3302: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3303:
3304: FOR c_AkRTl IN c_AkRegionsTl LOOP
3305: x_Region_Name := c_AkRTl.NAME;
3306: x_Region_Description := c_AkRTl.DESCRIPTION;

Line 3319: x_Return_Status := FND_API.G_RET_STS_ERROR;

3315: WHEN OTHERS THEN
3316: IF (x_msg_data IS NULL) THEN
3317: x_msg_data := SQLERRM || ' at BIS_AK_REGION_PUB.Get_Region_Code_TL_Data ';
3318: END IF;
3319: x_Return_Status := FND_API.G_RET_STS_ERROR;
3320: END Get_Region_Code_TL_Data;
3321:
3322: -- Bug#5256605 : Reset the display sequence of AK Region Items
3323: -- starting from -1 down below. This is done before updating all AK Items.

Line 3364: x_return_status := FND_API.G_RET_STS_ERROR;

3360: WHEN NO_DATA_FOUND THEN
3361: IF cr_items%ISOPEN THEN
3362: CLOSE cr_items;
3363: END IF;
3364: x_return_status := FND_API.G_RET_STS_ERROR;
3365: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3366: , p_count => x_msg_count
3367: , p_data => x_msg_data);
3368: WHEN OTHERS THEN

Line 3372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3368: WHEN OTHERS THEN
3369: IF cr_items%ISOPEN THEN
3370: CLOSE cr_items;
3371: END IF;
3372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3373: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3374: , p_count => x_msg_count
3375: , p_data => x_msg_data);
3376: IF (x_msg_data IS NULL) THEN