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

Line 281: WHEN FND_API.G_EXC_ERROR THEN

277:
278: --dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Actual_Value_From_PMV' );
279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
284: ,p_data => x_msg_data);
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278: --dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Actual_Value_From_PMV' );
279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
284: ,p_data => x_msg_data);
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
284: ,p_data => x_msg_data);
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
288: ,p_data => x_msg_data);
289: WHEN NO_DATA_FOUND THEN

Line 286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

282: x_return_status := FND_API.G_RET_STS_ERROR;
283: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
284: ,p_data => x_msg_data);
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
288: ,p_data => x_msg_data);
289: WHEN NO_DATA_FOUND THEN
290: x_return_status := FND_API.G_RET_STS_ERROR;

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
288: ,p_data => x_msg_data);
289: WHEN NO_DATA_FOUND THEN
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
292: ,p_data => x_msg_data);
293: WHEN OTHERS THEN
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290: x_return_status := FND_API.G_RET_STS_ERROR;
291: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
292: ,p_data => x_msg_data);
293: WHEN OTHERS THEN
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
296: ,p_data => x_msg_data);
297: --dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
298: END Get_Actual_Value_From_PMV;

Line 771: WHEN FND_API.G_EXC_ERROR THEN

767: FETCH l_cursor INTO x_period_id, x_period_name,l_start_date,l_end_date;
768: CLOSE l_cursor;
769:
770: EXCEPTION
771: WHEN FND_API.G_EXC_ERROR THEN
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
774: ,p_data => x_msg_data);
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 772: x_return_status := FND_API.G_RET_STS_ERROR;

768: CLOSE l_cursor;
769:
770: EXCEPTION
771: WHEN FND_API.G_EXC_ERROR THEN
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
774: ,p_data => x_msg_data);
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

771: WHEN FND_API.G_EXC_ERROR THEN
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
774: ,p_data => x_msg_data);
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
778: ,p_data => x_msg_data);
779: WHEN NO_DATA_FOUND THEN

Line 776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

772: x_return_status := FND_API.G_RET_STS_ERROR;
773: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
774: ,p_data => x_msg_data);
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
778: ,p_data => x_msg_data);
779: WHEN NO_DATA_FOUND THEN
780: x_return_status := FND_API.G_RET_STS_ERROR;

Line 780: x_return_status := FND_API.G_RET_STS_ERROR;

776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
778: ,p_data => x_msg_data);
779: WHEN NO_DATA_FOUND THEN
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
782: ,p_data => x_msg_data);
783: WHEN OTHERS THEN
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

780: x_return_status := FND_API.G_RET_STS_ERROR;
781: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
782: ,p_data => x_msg_data);
783: WHEN OTHERS THEN
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
786: ,p_data => x_msg_data);
787: END Get_Period_Info;
788:

Line 1288: WHEN FND_API.G_EXC_ERROR THEN

1284:
1285: --dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Target_Value_From_PMF' );
1286:
1287: EXCEPTION
1288: WHEN FND_API.G_EXC_ERROR THEN
1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1291: ,p_data => x_msg_data);
1292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1289: x_return_status := FND_API.G_RET_STS_ERROR;

1285: --dbms_output.put_line('End BSC_BIS_WRAPPER_PVT.Get_Target_Value_From_PMF' );
1286:
1287: EXCEPTION
1288: WHEN FND_API.G_EXC_ERROR THEN
1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1291: ,p_data => x_msg_data);
1292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1288: WHEN FND_API.G_EXC_ERROR THEN
1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1291: ,p_data => x_msg_data);
1292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1295: ,p_data => x_msg_data);
1296: WHEN NO_DATA_FOUND THEN

Line 1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1291: ,p_data => x_msg_data);
1292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1295: ,p_data => x_msg_data);
1296: WHEN NO_DATA_FOUND THEN
1297: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1297: x_return_status := FND_API.G_RET_STS_ERROR;

1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1295: ,p_data => x_msg_data);
1296: WHEN NO_DATA_FOUND THEN
1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1299: ,p_data => x_msg_data);
1300: WHEN OTHERS THEN
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1299: ,p_data => x_msg_data);
1300: WHEN OTHERS THEN
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1303: ,p_data => x_msg_data);
1304: END Get_Target_Value_From_PMF;
1305:

Line 1961: WHEN FND_API.G_EXC_ERROR THEN

1957:
1958: COMMIT;
1959:
1960: EXCEPTION
1961: WHEN FND_API.G_EXC_ERROR THEN
1962: ROLLBACK;
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1965: ,p_data => x_msg_data);

Line 1963: x_return_status := FND_API.G_RET_STS_ERROR;

1959:
1960: EXCEPTION
1961: WHEN FND_API.G_EXC_ERROR THEN
1962: ROLLBACK;
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1965: ,p_data => x_msg_data);
1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1967: ROLLBACK;

Line 1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1962: ROLLBACK;
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1965: ,p_data => x_msg_data);
1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1967: ROLLBACK;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1970: ,p_data => x_msg_data);

Line 1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1964: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1965: ,p_data => x_msg_data);
1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1967: ROLLBACK;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1970: ,p_data => x_msg_data);
1971: WHEN NO_DATA_FOUND THEN
1972: ROLLBACK;

Line 1973: x_return_status := FND_API.G_RET_STS_ERROR;

1969: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1970: ,p_data => x_msg_data);
1971: WHEN NO_DATA_FOUND THEN
1972: ROLLBACK;
1973: x_return_status := FND_API.G_RET_STS_ERROR;
1974: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1975: ,p_data => x_msg_data);
1976: WHEN OTHERS THEN
1977: ROLLBACK;

Line 1978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1974: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1975: ,p_data => x_msg_data);
1976: WHEN OTHERS THEN
1977: ROLLBACK;
1978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1979: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1980: ,p_data => x_msg_data);
1981: --dbms_output.put_line('*sqlerrm='||sqlerrm);
1982: END Populate_Measure_Data;

Line 2067: WHEN FND_API.G_EXC_ERROR THEN

2063: -- dbms_output.put_line('*x_page_parameters.value_name='||x_page_parameters(i).value_name);
2064: -- END LOOP;
2065:
2066: EXCEPTION
2067: WHEN FND_API.G_EXC_ERROR THEN
2068: rollback;
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2071: ,p_data => x_msg_data);

Line 2069: x_return_status := FND_API.G_RET_STS_ERROR;

2065:
2066: EXCEPTION
2067: WHEN FND_API.G_EXC_ERROR THEN
2068: rollback;
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2071: ,p_data => x_msg_data);
2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2073: rollback;

Line 2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2068: rollback;
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2071: ,p_data => x_msg_data);
2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2073: rollback;
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2075: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2076: ,p_data => x_msg_data);

Line 2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2070: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2071: ,p_data => x_msg_data);
2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2073: rollback;
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2075: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2076: ,p_data => x_msg_data);
2077: WHEN NO_DATA_FOUND THEN
2078: rollback;

Line 2079: x_return_status := FND_API.G_RET_STS_ERROR;

2075: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2076: ,p_data => x_msg_data);
2077: WHEN NO_DATA_FOUND THEN
2078: rollback;
2079: x_return_status := FND_API.G_RET_STS_ERROR;
2080: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2081: ,p_data => x_msg_data);
2082: WHEN OTHERS THEN
2083: rollback;

Line 2084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2080: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2081: ,p_data => x_msg_data);
2082: WHEN OTHERS THEN
2083: rollback;
2084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2085: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2086: ,p_data => x_msg_data);
2087:
2088: END Get_Page_Parameters;

Line 2437: WHEN FND_API.G_EXC_ERROR THEN

2433: END IF;
2434: END LOOP;
2435:
2436: EXCEPTION
2437: WHEN FND_API.G_EXC_ERROR THEN
2438: x_return_status := FND_API.G_RET_STS_ERROR;
2439: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2440: ,p_data => x_msg_data);
2441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2438: x_return_status := FND_API.G_RET_STS_ERROR;

2434: END LOOP;
2435:
2436: EXCEPTION
2437: WHEN FND_API.G_EXC_ERROR THEN
2438: x_return_status := FND_API.G_RET_STS_ERROR;
2439: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2440: ,p_data => x_msg_data);
2441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2437: WHEN FND_API.G_EXC_ERROR THEN
2438: x_return_status := FND_API.G_RET_STS_ERROR;
2439: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2440: ,p_data => x_msg_data);
2441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2443: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2444: ,p_data => x_msg_data);
2445: WHEN NO_DATA_FOUND THEN

Line 2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2438: x_return_status := FND_API.G_RET_STS_ERROR;
2439: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2440: ,p_data => x_msg_data);
2441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2443: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2444: ,p_data => x_msg_data);
2445: WHEN NO_DATA_FOUND THEN
2446: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2446: x_return_status := FND_API.G_RET_STS_ERROR;

2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2443: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2444: ,p_data => x_msg_data);
2445: WHEN NO_DATA_FOUND THEN
2446: x_return_status := FND_API.G_RET_STS_ERROR;
2447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2448: ,p_data => x_msg_data);
2449: WHEN OTHERS THEN
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2446: x_return_status := FND_API.G_RET_STS_ERROR;
2447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2448: ,p_data => x_msg_data);
2449: WHEN OTHERS THEN
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2451: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2452: ,p_data => x_msg_data);
2453: END Get_Kpis_Data_From_PMF_PMV;
2454:

Line 2554: WHEN FND_API.G_EXC_ERROR THEN

2550: x_viewby_level := l_level_view_by.dimension_short_name || '+' || l_level_view_by.level_short_name;
2551: --dbms_output.put_line('*x_viewby_level='||x_viewby_level);
2552:
2553: EXCEPTION
2554: WHEN FND_API.G_EXC_ERROR THEN
2555: x_return_status := FND_API.G_RET_STS_ERROR;
2556: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2557: ,p_data => x_msg_data);
2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2555: x_return_status := FND_API.G_RET_STS_ERROR;

2551: --dbms_output.put_line('*x_viewby_level='||x_viewby_level);
2552:
2553: EXCEPTION
2554: WHEN FND_API.G_EXC_ERROR THEN
2555: x_return_status := FND_API.G_RET_STS_ERROR;
2556: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2557: ,p_data => x_msg_data);
2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2554: WHEN FND_API.G_EXC_ERROR THEN
2555: x_return_status := FND_API.G_RET_STS_ERROR;
2556: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2557: ,p_data => x_msg_data);
2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2560: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2561: ,p_data => x_msg_data);
2562: WHEN NO_DATA_FOUND THEN

Line 2559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2555: x_return_status := FND_API.G_RET_STS_ERROR;
2556: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2557: ,p_data => x_msg_data);
2558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2560: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2561: ,p_data => x_msg_data);
2562: WHEN NO_DATA_FOUND THEN
2563: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2563: x_return_status := FND_API.G_RET_STS_ERROR;

2559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2560: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2561: ,p_data => x_msg_data);
2562: WHEN NO_DATA_FOUND THEN
2563: x_return_status := FND_API.G_RET_STS_ERROR;
2564: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2565: ,p_data => x_msg_data);
2566: WHEN OTHERS THEN
2567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2563: x_return_status := FND_API.G_RET_STS_ERROR;
2564: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2565: ,p_data => x_msg_data);
2566: WHEN OTHERS THEN
2567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2568: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2569: ,p_data => x_msg_data);
2570: END Get_Kpi_view_by;
2571:

Line 2936: WHEN FND_API.G_EXC_ERROR THEN

2932:
2933: COMMIT;
2934:
2935: EXCEPTION
2936: WHEN FND_API.G_EXC_ERROR THEN
2937: ROLLBACK;
2938: x_return_status := FND_API.G_RET_STS_ERROR;
2939: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2940: ,p_data => x_msg_data);

Line 2938: x_return_status := FND_API.G_RET_STS_ERROR;

2934:
2935: EXCEPTION
2936: WHEN FND_API.G_EXC_ERROR THEN
2937: ROLLBACK;
2938: x_return_status := FND_API.G_RET_STS_ERROR;
2939: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2940: ,p_data => x_msg_data);
2941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2942: ROLLBACK;

Line 2941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2937: ROLLBACK;
2938: x_return_status := FND_API.G_RET_STS_ERROR;
2939: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2940: ,p_data => x_msg_data);
2941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2942: ROLLBACK;
2943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2944: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2945: ,p_data => x_msg_data);

Line 2943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2939: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2940: ,p_data => x_msg_data);
2941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2942: ROLLBACK;
2943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2944: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2945: ,p_data => x_msg_data);
2946: WHEN NO_DATA_FOUND THEN
2947: ROLLBACK;

Line 2948: x_return_status := FND_API.G_RET_STS_ERROR;

2944: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2945: ,p_data => x_msg_data);
2946: WHEN NO_DATA_FOUND THEN
2947: ROLLBACK;
2948: x_return_status := FND_API.G_RET_STS_ERROR;
2949: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2950: ,p_data => x_msg_data);
2951: WHEN OTHERS THEN
2952: ROLLBACK;

Line 2953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2949: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2950: ,p_data => x_msg_data);
2951: WHEN OTHERS THEN
2952: ROLLBACK;
2953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2954: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2955: ,p_data => x_msg_data);
2956: --dbms_output.put_line('*sqlerrm='||sqlerrm);
2957: END Post_Measure_Data;

Line 3005: WHEN FND_API.G_EXC_ERROR THEN

3001: x_msg_data);
3002: COMMIT;
3003:
3004: EXCEPTION
3005: WHEN FND_API.G_EXC_ERROR THEN
3006: ROLLBACK;
3007: x_return_status := FND_API.G_RET_STS_ERROR;
3008: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3009: ,p_data => x_msg_data);

Line 3007: x_return_status := FND_API.G_RET_STS_ERROR;

3003:
3004: EXCEPTION
3005: WHEN FND_API.G_EXC_ERROR THEN
3006: ROLLBACK;
3007: x_return_status := FND_API.G_RET_STS_ERROR;
3008: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3009: ,p_data => x_msg_data);
3010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3011: ROLLBACK;

Line 3010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3006: ROLLBACK;
3007: x_return_status := FND_API.G_RET_STS_ERROR;
3008: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3009: ,p_data => x_msg_data);
3010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3011: ROLLBACK;
3012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3013: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3014: ,p_data => x_msg_data);

Line 3012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3008: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3009: ,p_data => x_msg_data);
3010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3011: ROLLBACK;
3012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3013: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3014: ,p_data => x_msg_data);
3015: WHEN NO_DATA_FOUND THEN
3016: ROLLBACK;

Line 3017: x_return_status := FND_API.G_RET_STS_ERROR;

3013: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3014: ,p_data => x_msg_data);
3015: WHEN NO_DATA_FOUND THEN
3016: ROLLBACK;
3017: x_return_status := FND_API.G_RET_STS_ERROR;
3018: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3019: ,p_data => x_msg_data);
3020: WHEN OTHERS THEN
3021: ROLLBACK;

Line 3022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3018: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3019: ,p_data => x_msg_data);
3020: WHEN OTHERS THEN
3021: ROLLBACK;
3022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3023: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3024: ,p_data => x_msg_data);
3025: --dbms_output.put_line('*sqlerrm='||sqlerrm);
3026: END Populate_Measure_Data;