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

Line 1306: when FND_API.G_EXC_ERROR then

1302:
1303: BIS_UTILITIES_PUB.put_line(p_text =>' ........... END : Notification email ........... ');
1304:
1305: EXCEPTION
1306: when FND_API.G_EXC_ERROR then
1307: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Send_Alert: '||sqlerrm);
1308: wf_core.context
1309: ( 'BIS_CORRECTIVE_ACTION_PVT'
1310: , 'Send_Alert'

Line 1315: when FND_API.G_EXC_UNEXPECTED_ERROR then

1311: , l_item_type
1312: , l_wf_item_key
1313: );
1314: RETURN;
1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Send_Alert: '||sqlerrm);
1317: wf_core.context
1318: ( 'BIS_CORRECTIVE_ACTION_PVT'
1319: , 'Send_Alert'

Line 1352: ( BIS_UTILITIES_PUB.Value_Missing(p_recipient_short_name) = FND_API.G_TRUE ) OR

1348:
1349: BEGIN
1350:
1351: IF (
1352: ( BIS_UTILITIES_PUB.Value_Missing(p_recipient_short_name) = FND_API.G_TRUE ) OR
1353: ( BIS_UTILITIES_PUB.Value_Null(p_recipient_short_name) = FND_API.G_TRUE )
1354: ) THEN
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356: x_return_msg := 'Recipient short name is null or missing.';

Line 1353: ( BIS_UTILITIES_PUB.Value_Null(p_recipient_short_name) = FND_API.G_TRUE )

1349: BEGIN
1350:
1351: IF (
1352: ( BIS_UTILITIES_PUB.Value_Missing(p_recipient_short_name) = FND_API.G_TRUE ) OR
1353: ( BIS_UTILITIES_PUB.Value_Null(p_recipient_short_name) = FND_API.G_TRUE )
1354: ) THEN
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356: x_return_msg := 'Recipient short name is null or missing.';
1357: RETURN;

Line 1355: x_return_status := FND_API.G_RET_STS_ERROR;

1351: IF (
1352: ( BIS_UTILITIES_PUB.Value_Missing(p_recipient_short_name) = FND_API.G_TRUE ) OR
1353: ( BIS_UTILITIES_PUB.Value_Null(p_recipient_short_name) = FND_API.G_TRUE )
1354: ) THEN
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356: x_return_msg := 'Recipient short name is null or missing.';
1357: RETURN;
1358: END IF;
1359:

Line 1363: x_return_status := FND_API.G_RET_STS_SUCCESS;

1359:
1360:
1361: wf_directory.GetRoleUsers(p_recipient_short_name, l_user_tbl);
1362: x_user_tbl := l_user_tbl;
1363: x_return_status := FND_API.G_RET_STS_SUCCESS;
1364:
1365:
1366: EXCEPTION
1367: WHEN OTHERS THEN

Line 1368: x_return_status := FND_API.G_RET_STS_ERROR;

1364:
1365:
1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: x_return_msg := 'Exception occurred in BISVCACB.Get_User_List_From_Role : ' || sqlerrm;
1370: END Get_User_List_From_Role;
1371:
1372:

Line 1473: , p_all_info => FND_API.G_FALSE

1469: BIS_UTILITIES_PUB.put_line(p_text =>'Check2: '||p_measure_instance.range1_owner_short_name);
1470: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Target_Owners
1471: ( p_measure_instance => p_measure_instance
1472: , p_dim_level_value_tbl => p_dim_level_value_tbl
1473: , p_all_info => FND_API.G_FALSE
1474: , x_target_Owners_rec => l_target_Owners_rec
1475: );
1476: Get_Result_Owners
1477: ( p_target_Owners_rec => l_target_owners_rec

Line 1611: , p_all_info => FND_API.G_TRUE

1607: --
1608: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Target_Level
1609: ( p_measure_instance => p_measure_instance
1610: , p_dim_level_value_tbl => p_dim_level_value_tbl
1611: , p_all_info => FND_API.G_TRUE
1612: , x_target_level_rec => l_target_level_rec
1613: );
1614: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Target
1615: ( p_measure_instance => p_measure_instance

Line 1617: , p_all_info => FND_API.G_TRUE

1613: );
1614: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Target
1615: ( p_measure_instance => p_measure_instance
1616: , p_dim_level_value_tbl => p_dim_level_value_tbl
1617: , p_all_info => FND_API.G_TRUE
1618: , x_target_rec => l_target_rec
1619: );
1620: l_sent_Date := getdate; -- to_char(sysdate,'DD-MON-YYYY HH24:MM:SS'); -- 2837974
1621:

Line 1749: when FND_API.G_EXC_ERROR then

1745:
1746: null;
1747:
1748: EXCEPTION
1749: when FND_API.G_EXC_ERROR then
1750: RETURN;
1751: when FND_API.G_EXC_UNEXPECTED_ERROR then
1752: RETURN;
1753: when others then

Line 1751: when FND_API.G_EXC_UNEXPECTED_ERROR then

1747:
1748: EXCEPTION
1749: when FND_API.G_EXC_ERROR then
1750: RETURN;
1751: when FND_API.G_EXC_UNEXPECTED_ERROR then
1752: RETURN;
1753: when others then
1754: BIS_UTILITIES_PVT.Add_Error_Message
1755: ( p_error_msg_id => SQLCODE

Line 2008: , p_all_info => FND_API.G_FALSE

2004:
2005: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Target_Level
2006: ( p_measure_instance => p_measure_instance
2007: , p_dim_level_value_tbl => p_dim_level_value_tbl
2008: , p_all_info => FND_API.G_FALSE
2009: , x_target_level_rec => l_target_level_rec
2010: );
2011: x_item_type := l_target_level_rec.Workflow_Item_Type;
2012: x_process := l_target_level_rec.Workflow_Process_Short_Name;

Line 2196: x_return_status := FND_API.G_RET_STS_SUCCESS;

2192:
2193: BEGIN
2194:
2195: x_msg_count := 0;
2196: x_return_status := FND_API.G_RET_STS_SUCCESS;
2197:
2198: SAVEPOINT unSubscribeFromAlerts_pvt;
2199:
2200: l_username := FND_GLOBAL.USER_NAME; -- 'SYSADMIN'; -- 'SADIQ'; --

Line 2238: WHEN FND_API.G_EXC_ERROR THEN

2234: COMMIT;
2235:
2236: EXCEPTION
2237:
2238: WHEN FND_API.G_EXC_ERROR THEN
2239: ROLLBACK TO unSubscribeFromAlerts_pvt;
2240: x_return_status := FND_API.G_RET_STS_ERROR ;
2241: FND_MSG_PUB.Count_And_Get
2242: (p_count => x_msg_count,

Line 2240: x_return_status := FND_API.G_RET_STS_ERROR ;

2236: EXCEPTION
2237:
2238: WHEN FND_API.G_EXC_ERROR THEN
2239: ROLLBACK TO unSubscribeFromAlerts_pvt;
2240: x_return_status := FND_API.G_RET_STS_ERROR ;
2241: FND_MSG_PUB.Count_And_Get
2242: (p_count => x_msg_count,
2243: p_data => x_msg_data
2244: );

Line 2248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2244: );
2245:
2246: WHEN OTHERS THEN
2247: ROLLBACK TO unSubscribeFromAlerts_pvt;
2248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2249: x_msg_count := 1;
2250: x_msg_data := 'Error in BISVCACB.pls in unSubscribeFromAlerts' || sqlerrm;
2251: l_error_tbl_p := l_error_tbl;
2252: BIS_UTILITIES_PVT.Add_Error_Message