APPS.BIS_PMV_ACTUAL_PVT dependencies on FND_API

Line 301: x_return_Status := FND_API.G_RET_STS_SUCCESS;

297: end loop;
298: end if;
299: end if; -- end of setting up calculation measure infos
300:
301: x_return_Status := FND_API.G_RET_STS_SUCCESS;
302: -- get main query
303: BIS_PMV_QUERY_PVT.getQuerySql(
304: p_Region_Code => p_region_code,
305: p_function_name => p_function_name,

Line 531: x_return_status := FND_API.G_RET_STS_SUCCESS;

527: end loop;
528: dbms_sql.close_cursor(l_cursor);
529:
530: if (l_row_found <= 0) then
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532: x_msg_data := 'NO DATA FOUND';
533: end if;
534:
535: if (l_actual_val_cnt <=0) and not(l_calculate_actual) then

Line 536: x_return_Status := FND_API.G_RET_STS_ERROR;

532: x_msg_data := 'NO DATA FOUND';
533: end if;
534:
535: if (l_actual_val_cnt <=0) and not(l_calculate_actual) then
536: x_return_Status := FND_API.G_RET_STS_ERROR;
537: x_msg_data := 'Invalid attribute code';
538: end if;
539:
540: x_msg_data := l_debug_msg || x_msg_data;

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545: when others then
546: if (dbms_sql.IS_OPEN(l_cursor)) then
547: dbms_sql.close_cursor(l_cursor);
548: end if;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: END;
551: -- Overloaded procedure to return a table of records for SONAR KPI portlet
552: PROCEDURE GET_ACTUAL_VALUE
553: (p_region_code IN VARCHAR2

Line 884: x_return_Status := FND_API.G_RET_STS_SUCCESS;

880: end if; -- end of setting up calculation measure infos
881:
882:
883: --Now execute the query and get the values back.
884: x_return_Status := FND_API.G_RET_STS_SUCCESS;
885: --dbms_output.put_line ('About to execute the query');
886: BIS_PMV_QUERY_PVT.getQuerySql(
887: p_Region_Code => p_region_code,
888: p_function_name => l_function_name,

Line 1371: x_return_status := FND_API.G_RET_STS_SUCCESS;

1367: end loop;
1368: end if;
1369: dbms_sql.close_cursor(l_cursor);
1370: if (l_row_found <= 0) then
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;
1372: x_msg_data := 'NO DATA FOUND';
1373: end if;
1374: if (l_actual_val_cnt <=0) and not(l_calculate_actual) then
1375: x_return_Status := FND_API.G_RET_STS_ERROR;

Line 1375: x_return_Status := FND_API.G_RET_STS_ERROR;

1371: x_return_status := FND_API.G_RET_STS_SUCCESS;
1372: x_msg_data := 'NO DATA FOUND';
1373: end if;
1374: if (l_actual_val_cnt <=0) and not(l_calculate_actual) then
1375: x_return_Status := FND_API.G_RET_STS_ERROR;
1376: x_msg_data := 'Invalid attribute code';
1377: end if;
1378: x_msg_data := l_debug_msg || x_msg_data;
1379: EXCEPTION

Line 1384: x_return_status := FND_API.G_RET_STS_ERROR;

1380: when others then
1381: if (dbms_sql.IS_OPEN(l_cursor)) then
1382: dbms_sql.close_cursor(l_cursor);
1383: end if;
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385: -- x_return_status := SQLERRM;
1386: --dbms_output.put_line ('The err 2 is '|| x_return_Status);
1387:
1388: END;

Line 1892: x_return_Status := FND_API.G_RET_STS_SUCCESS;

1888: l_debug_msg := l_debug_msg || 'Successfully stored the parameters...';
1889: end if;
1890:
1891: --Now execute the query and get the values back.
1892: x_return_Status := FND_API.G_RET_STS_SUCCESS;
1893: --dbms_output.put_line ('About to execute the query');
1894: BIS_PMV_QUERY_PVT.getQuerySql(
1895: p_Region_Code => p_region_code,
1896: p_function_name => l_function_name,

Line 2232: x_return_status := FND_API.G_RET_STS_SUCCESS;

2228:
2229: dbms_sql.close_cursor(l_cursor);
2230:
2231: if (l_row_found <= 0) then
2232: x_return_status := FND_API.G_RET_STS_SUCCESS;
2233: x_msg_data := 'NO DATA FOUND';
2234: end if;
2235:
2236: x_msg_data := l_debug_msg || x_msg_data;

Line 2243: x_return_status := FND_API.G_RET_STS_ERROR;

2239: when others then
2240: if (dbms_sql.IS_OPEN(l_cursor)) then
2241: dbms_sql.close_cursor(l_cursor);
2242: end if;
2243: x_return_status := FND_API.G_RET_STS_ERROR;
2244: -- x_return_status := SQLERRM;
2245: --dbms_output.put_line ('The err 2 is '|| x_return_Status);
2246: END GET_ACTUAL_VALUE;
2247: