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

Line 37: l_return_status VARCHAR2(200) := FND_API.G_RET_STS_SUCCESS;

33: l_resource_id varchar2(30);
34: l_classification_id number;
35: l_launched_node varchar2(100);
36:
37: l_return_status VARCHAR2(200) := FND_API.G_RET_STS_SUCCESS;
38: l_msg_count NUMBER := 0;
39: l_msg_data VARCHAR2(2000);
40: BEGIN
41:

Line 105: WHEN FND_API.G_EXC_ERROR THEN

101: logMessage := '[NO data found when query iem_account_route_class with l_acct_rt_class_id='||l_acct_rt_class_id||']';
102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);
103: end if;
104:
105: WHEN FND_API.G_EXC_ERROR THEN
106: ROLLBACK TO launchInbound_pvt;
107: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
108: logMessage := '[ FND_API.G_EXC_ERROR occur!!! ]';
109: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);

Line 108: logMessage := '[ FND_API.G_EXC_ERROR occur!!! ]';

104:
105: WHEN FND_API.G_EXC_ERROR THEN
106: ROLLBACK TO launchInbound_pvt;
107: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
108: logMessage := '[ FND_API.G_EXC_ERROR occur!!! ]';
109: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);
110: end if;
111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

108: logMessage := '[ FND_API.G_EXC_ERROR occur!!! ]';
109: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);
110: end if;
111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: ROLLBACK TO launchInbound_pvt;
114: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
115: logMessage := '[ FND_API.G_EXC_UNEXPECTED_ERROR occur!!! ]';
116: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);

Line 115: logMessage := '[ FND_API.G_EXC_UNEXPECTED_ERROR occur!!! ]';

111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: ROLLBACK TO launchInbound_pvt;
114: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
115: logMessage := '[ FND_API.G_EXC_UNEXPECTED_ERROR occur!!! ]';
116: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);
117: end if;
118: WHEN OTHERS THEN
119: ROLLBACK TO launchInbound_pvt;

Line 153: l_return_status VARCHAR2(200) := FND_API.G_RET_STS_SUCCESS;

149: l_class_name iem_route_classifications.name%type;
150:
151: l_rt_media_item_id IEM_RT_MEDIA_ITEMS.rt_media_item_id%type;
152:
153: l_return_status VARCHAR2(200) := FND_API.G_RET_STS_SUCCESS;
154: l_msg_count NUMBER := 0;
155: l_msg_data VARCHAR2(2000);
156:
157: BEGIN

Line 227: WHEN FND_API.G_EXC_ERROR THEN

223: logMessage := '[NO data found when query iem_account_route_class,IEM_RT_MEDIA_ITEMs with l_msg_id='||l_msg_id||']';
224: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);
225: end if;
226:
227: WHEN FND_API.G_EXC_ERROR THEN
228: ROLLBACK TO launchInbound_pvt;
229: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
230: logMessage := '[FND_API.G_EXC_ERROR ]';
231: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);

Line 230: logMessage := '[FND_API.G_EXC_ERROR ]';

226:
227: WHEN FND_API.G_EXC_ERROR THEN
228: ROLLBACK TO launchInbound_pvt;
229: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
230: logMessage := '[FND_API.G_EXC_ERROR ]';
231: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);
232: end if;
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

230: logMessage := '[FND_API.G_EXC_ERROR ]';
231: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);
232: end if;
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO launchInbound_pvt;
236: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
237: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR]';
238: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);

Line 237: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR]';

233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO launchInbound_pvt;
236: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
237: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR]';
238: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);
239: end if;
240:
241: WHEN OTHERS THEN