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

Line 129: IF FND_API.to_Boolean( l_debug_flag ) THEN

125: , p_item_key
126: , '.DEBUG_FLAG'
127: );
128:
129: IF FND_API.to_Boolean( l_debug_flag ) THEN
130: x_debug_flag := TRUE ;
131: END IF ;
132:
133:

Line 914: x_return_status := FND_API.G_RET_STS_SUCCESS;

910:
911: BEGIN
912:
913: -- Initialize API return status to success
914: x_return_status := FND_API.G_RET_STS_SUCCESS;
915:
916:
917: IF g_debug_flag THEN
918: Write_Debug('SetAttribute Private API . . .');

Line 1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1124: Write_Debug('When Others in SetAttributes ' || SQLERRM );
1125: END IF ;
1126:
1127:
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129: IF FND_MSG_PUB.Check_Msg_Level
1130: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1131: THEN
1132: FND_MSG_PUB.Add_Exc_Msg

Line 1174: x_return_status := FND_API.G_RET_STS_SUCCESS;

1170: x_msg_count := '';
1171: x_msg_data := '';
1172:
1173: -- Initialize API return status to success
1174: x_return_status := FND_API.G_RET_STS_SUCCESS;
1175:
1176: -- Get Adhoc Party List
1177: list_rest := LTRIM(p_adhoc_party_list) ;
1178: LOOP

Line 1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1240:
1241: return;
1242: EXCEPTION
1243: WHEN OTHERS THEN
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1245: IF FND_MSG_PUB.Check_Msg_Level
1246: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1247: THEN
1248: FND_MSG_PUB.Add_Exc_Msg

Line 1279: x_return_status := FND_API.G_RET_STS_SUCCESS;

1275:
1276: BEGIN
1277:
1278: -- Initialize API return status to success
1279: x_return_status := FND_API.G_RET_STS_SUCCESS;
1280:
1281:
1282: I := I + 1 ;
1283: l_role_names(I) := GetWFAdhocRoleName

Line 1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1296:
1297: EXCEPTION
1298: WHEN OTHERS THEN
1299:
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1301: IF FND_MSG_PUB.Check_Msg_Level
1302: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1303: THEN
1304: FND_MSG_PUB.Add_Exc_Msg

Line 1323: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1319: -- API name : StartWorkflow
1320: -- Type : Public
1321: PROCEDURE StartWorkflow
1322: ( p_api_version IN NUMBER
1323: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1324: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1325: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1326: , x_return_status OUT NOCOPY VARCHAR2
1327: , x_msg_count OUT NOCOPY NUMBER

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

1320: -- Type : Public
1321: PROCEDURE StartWorkflow
1322: ( p_api_version IN NUMBER
1323: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1324: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1325: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1326: , x_return_status OUT NOCOPY VARCHAR2
1327: , x_msg_count OUT NOCOPY NUMBER
1328: , x_msg_data OUT NOCOPY VARCHAR2

Line 1325: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1321: PROCEDURE StartWorkflow
1322: ( p_api_version IN NUMBER
1323: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1324: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1325: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1326: , x_return_status OUT NOCOPY VARCHAR2
1327: , x_msg_count OUT NOCOPY NUMBER
1328: , x_msg_data OUT NOCOPY VARCHAR2
1329: , p_item_type IN VARCHAR2

Line 1341: , p_debug IN VARCHAR2 := FND_API.G_FALSE

1337: , p_report_fwk_region IN VARCHAR2 := NULL
1338: , p_report_custom_code IN VARCHAR2 := NULL
1339: , p_browse_mode IN VARCHAR2 := NULL -- EGO_SUMMARY or EGO_SEQUENTIAL
1340: , p_report_org_id IN NUMBER := NULL
1341: , p_debug IN VARCHAR2 := FND_API.G_FALSE
1342: , p_output_dir IN VARCHAR2 := NULL
1343: , p_debug_filename IN VARCHAR2 := 'EgoReportStartWf.log'
1344: )
1345: IS

Line 1361: IF NOT FND_API.Compatible_API_Call( l_api_version

1357: SAVEPOINT StartWorkflow_Util;
1358:
1359: -- Standard call to check for call compatibility.
1360:
1361: IF NOT FND_API.Compatible_API_Call( l_api_version
1362: , p_api_version
1363: , l_api_name
1364: , G_PKG_NAME )
1365: THEN

Line 1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1362: , p_api_version
1363: , l_api_name
1364: , G_PKG_NAME )
1365: THEN
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: END IF;
1368:
1369: -- Initialize message list if p_init_msg_list is set to TRUE.
1370: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1370: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: END IF;
1368:
1369: -- Initialize message list if p_init_msg_list is set to TRUE.
1370: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1371: FND_MSG_PUB.initialize;
1372: END IF ;
1373:
1374: -- For Test/Debug

Line 1375: IF FND_API.to_Boolean( p_debug ) THEN

1371: FND_MSG_PUB.initialize;
1372: END IF ;
1373:
1374: -- For Test/Debug
1375: IF FND_API.to_Boolean( p_debug ) THEN
1376: Open_Debug_Session(p_output_dir, p_debug_filename ) ;
1377: END IF ;
1378:
1379: IF g_debug_flag THEN

Line 1399: x_return_status := FND_API.G_RET_STS_SUCCESS;

1395: Write_Debug('Initialize return status ' );
1396: END IF ;
1397:
1398: -- Initialize API return status to success
1399: x_return_status := FND_API.G_RET_STS_SUCCESS;
1400:
1401: -----------------------------------------------------------------
1402: -- API body
1403: -----------------------------------------------------------------

Line 1495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1491: , p_report_org_id => p_report_org_id
1492: ) ;
1493:
1494:
1495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1496: THEN
1497: RAISE FND_API.G_EXC_ERROR ;
1498: END IF ;
1499:

Line 1497: RAISE FND_API.G_EXC_ERROR ;

1493:
1494:
1495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1496: THEN
1497: RAISE FND_API.G_EXC_ERROR ;
1498: END IF ;
1499:
1500: IF g_debug_flag THEN
1501: Write_Debug('6. StartProcess. . .');

Line 1529: IF FND_API.To_Boolean( p_commit ) THEN

1525: END IF ;
1526:
1527:
1528: -- Standard check of p_commit.
1529: IF FND_API.To_Boolean( p_commit ) THEN
1530:
1531: IF g_debug_flag THEN
1532: Write_Debug('Do Commit.') ;
1533: END IF ;

Line 1554: WHEN FND_API.G_EXC_ERROR THEN

1550:
1551:
1552: EXCEPTION
1553:
1554: WHEN FND_API.G_EXC_ERROR THEN
1555: ROLLBACK TO StartWorkflow_Util ;
1556: x_return_status := FND_API.G_RET_STS_ERROR ;
1557:
1558: FND_MSG_PUB.Count_And_Get

Line 1556: x_return_status := FND_API.G_RET_STS_ERROR ;

1552: EXCEPTION
1553:
1554: WHEN FND_API.G_EXC_ERROR THEN
1555: ROLLBACK TO StartWorkflow_Util ;
1556: x_return_status := FND_API.G_RET_STS_ERROR ;
1557:
1558: FND_MSG_PUB.Count_And_Get
1559: ( p_count => x_msg_count
1560: , p_data => x_msg_data

Line 1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1564: Write_Debug('RollBack and Finish with Error.') ;
1565: Close_Debug_Session ;
1566: END IF ;
1567:
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO StartWorkflow_Util ;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571:
1572: FND_MSG_PUB.Count_And_Get

Line 1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1566: END IF ;
1567:
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO StartWorkflow_Util ;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571:
1572: FND_MSG_PUB.Count_And_Get
1573: ( p_count => x_msg_count
1574: , p_data => x_msg_data

Line 1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1580: END IF ;
1581:
1582: WHEN OTHERS THEN
1583: ROLLBACK TO StartWorkflow_Util ;
1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1585:
1586: FND_MSG_PUB.Count_And_Get
1587: ( p_count => x_msg_count
1588: , p_data => x_msg_data

Line 1668: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1664: , p_adhoc_party_list => l_adhoc_party_list
1665: ) ;
1666:
1667:
1668: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1669: -- set result
1670: result := 'COMPLETE';
1671: return;
1672:

Line 1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1676: result := 'COMPLETE:NONE';
1677: return;
1678: ELSE
1679: -- Unexpected Exception
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1681:
1682: END IF ;
1683: end if ; -- funcmode : RUN
1684:

Line 1714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1710: return;
1711:
1712: EXCEPTION
1713:
1714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1715: -- The line below records this function call in the error system
1716: -- in the case of an exception.
1717: wf_core.context('EGO_REPORT_WF_UTIL', 'SELECT_ADHOC_PARTY',
1718: itemtype, itemkey, to_char(actid), funcmode);

Line 1764: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1760: ) ;
1761:
1762: -- wf_directory.getroleusers( 'EGO_ADHOC,'||itemtype || '-' ||itemkey,ut);
1763:
1764: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1765:
1766: -- set result
1767: result := 'COMPLETE';
1768: return;

Line 1773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1769:
1770: ELSE
1771:
1772: -- Unexpected Exception
1773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1774:
1775: END IF ;
1776:
1777: end if ; -- funcmode : RUN

Line 1808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1804: return;
1805:
1806: EXCEPTION
1807:
1808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1809: -- The line below records this function call in the error system
1810: -- in the case of an exception.
1811: wf_core.context('EGO_REPORT_WF_UTIL', 'DELETE_ADHOC_ROLES_AND_USERS',
1812: itemtype, itemkey, to_char(actid), funcmode);