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 39: l_return_status VARCHAR2(200) := FND_API.G_RET_STS_SUCCESS;

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

Line 136: WHEN FND_API.G_EXC_ERROR THEN

132: logMessage := '[NO data found when query iem_account_route_class with l_acct_rt_class_id='||l_acct_rt_class_id||']';
133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);
134: end if;
135:
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO launchInbound_pvt;
138: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
139: logMessage := '[ FND_API.G_EXC_ERROR occur!!! ]';
140: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);

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

135:
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO launchInbound_pvt;
138: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
139: logMessage := '[ FND_API.G_EXC_ERROR occur!!! ]';
140: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);
141: end if;
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

139: logMessage := '[ FND_API.G_EXC_ERROR occur!!! ]';
140: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);
141: end if;
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: ROLLBACK TO launchInbound_pvt;
145: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
146: logMessage := '[ FND_API.G_EXC_UNEXPECTED_ERROR occur!!! ]';
147: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);

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

142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: ROLLBACK TO launchInbound_pvt;
145: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
146: logMessage := '[ FND_API.G_EXC_UNEXPECTED_ERROR occur!!! ]';
147: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHINBOUND', logMessage);
148: end if;
149: WHEN OTHERS THEN
150: ROLLBACK TO launchInbound_pvt;

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

180: l_class_name iem_route_classifications.name%type;
181:
182: l_rt_media_item_id IEM_RT_MEDIA_ITEMS.rt_media_item_id%type;
183:
184: l_return_status VARCHAR2(200) := FND_API.G_RET_STS_SUCCESS;
185: l_msg_count NUMBER := 0;
186: l_msg_data VARCHAR2(2000);
187:
188: BEGIN

Line 258: WHEN FND_API.G_EXC_ERROR THEN

254: logMessage := '[NO data found when query iem_account_route_class,IEM_RT_MEDIA_ITEMs with l_msg_id='||l_msg_id||']';
255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);
256: end if;
257:
258: WHEN FND_API.G_EXC_ERROR THEN
259: ROLLBACK TO launchInbound_pvt;
260: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
261: logMessage := '[FND_API.G_EXC_ERROR ]';
262: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);

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

257:
258: WHEN FND_API.G_EXC_ERROR THEN
259: ROLLBACK TO launchInbound_pvt;
260: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
261: logMessage := '[FND_API.G_EXC_ERROR ]';
262: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);
263: end if;
264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

261: logMessage := '[FND_API.G_EXC_ERROR ]';
262: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);
263: end if;
264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO launchInbound_pvt;
267: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
268: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR]';
269: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);

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

264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO launchInbound_pvt;
267: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
268: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR]';
269: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_CLIENTLAUNCH_PUB.LAUNCHACQUIRED', logMessage);
270: end if;
271:
272: WHEN OTHERS THEN