APPS.IEM_CLIENTLAUNCH_PUB dependencies on IEM_ACCOUNT_ROUTE_CLASS

Line 89: select route_classification_id into l_classification_id from iem_account_route_class

85:
86: if l_launched_node = 'EMAIL_ACCOUNT_ID' then
87: l_classification_id := '-1';
88: elsif l_launched_node = 'ACCOUNT_ROUTE_CLASS_ID' then
89: select route_classification_id into l_classification_id from iem_account_route_class
90: where account_route_class_id = l_acct_rt_class_id;
91: elsif l_launched_node = 'MESSAGE_ID' then
92: select rt_classification_id,customer_id,nvl(contact_id,-1) into l_classification_id,l_cust_id,l_contact_id
93: from iem_rt_proc_emails where message_id = l_msg_id;

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

128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: ROLLBACK TO launchInbound_pvt;
131: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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

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

250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: ROLLBACK TO launchInbound_pvt;
253: if( FND_LOG.LEVEL_STATEMENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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