APPS.IEM_CLIENTLAUNCH_PUB dependencies on IEM_ACCOUNT_ROUTE_CLASS

Line 77: select route_classification_id into l_classification_id from iem_account_route_class

73:
74: if l_launched_node = 'EMAIL_ACCOUNT_ID' then
75: l_classification_id := '-1';
76: elsif l_launched_node = 'ACCOUNT_ROUTE_CLASS_ID' then
77: select route_classification_id into l_classification_id from iem_account_route_class
78: where account_route_class_id = l_acct_rt_class_id;
79: end if;
80:
81: x_action_type := 2; --NULL;

Line 101: logMessage := '[NO data found when query iem_account_route_class with l_acct_rt_class_id='||l_acct_rt_class_id||']';

97: EXCEPTION
98: WHEN NO_DATA_FOUND THEN
99: ROLLBACK TO launchInbound_pvt;
100: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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

Line 223: logMessage := '[NO data found when query iem_account_route_class,IEM_RT_MEDIA_ITEMs with l_msg_id='||l_msg_id||']';

219: EXCEPTION
220: WHEN NO_DATA_FOUND THEN
221: ROLLBACK TO launchInbound_pvt;
222: if( FND_LOG.LEVEL_STATEMENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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