167: l_auto_msgstatus varchar2(10); -- will store msg status for autoreply/autoxredirect;
168: l_cust_contact_id number;
169: STOP_AUTO_PROCESSING EXCEPTION;
170: begin
171: -- Standard call to check for call compatibility.
172: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
173: p_api_version_number,
174: l_api_name,
175: G_PKG_NAME)
2407: END;
2408: l_count:=l_count+1;
2409: EXIT when l_count>p_count;
2410: END LOOP;
2411: -- Standard Check Of p_commit.
2412: IF FND_API.To_Boolean(p_commit) THEN
2413: COMMIT WORK;
2414: END IF;
2415: EXCEPTION
3861: l_sender varchar2(500);
3862:
3863: begin
3864: l_api_version_number:=1.0;
3865: -- Standard call to check for call compatibility.
3866: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3867: p_api_version_number,
3868: l_api_name,
3869: G_PKG_NAME)
4326: if g_statement_log then
4327: l_logmessage:='End Of Calling Specific Search API and end of Processing for the message ' ;
4328: iem_logger(l_logmessage);
4329: end if;
4330: -- Standard Check Of p_commit.
4331: IF p_commit='T' THEN
4332: COMMIT WORK;
4333: END IF;
4334: -- Standard callto get message count and if count is 1, get message info.
4330: -- Standard Check Of p_commit.
4331: IF p_commit='T' THEN
4332: COMMIT WORK;
4333: END IF;
4334: -- Standard callto get message count and if count is 1, get message info.
4335: FND_MSG_PUB.Count_And_Get
4336: ( p_count => x_msg_count,
4337: p_data => x_msg_data
4338: );