DBA Data[Home] [Help]

APPS.IEM_RULES_ENGINE_PUB dependencies on FND_MSG_PUB

Line 290: FND_MSG_PUB.initialize;

286: END IF;
287:
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean( p_init_msg_list ) THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Initialize API return status to SUCCESS
294: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 823: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

819: COMMIT WORK;
820: End if;
821:
822: --Standard call to get message count and if count is 1 then get message info
823: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
824:
825: EXCEPTION
826: when NO_DATA_FOUND THEN
827: Rollback to Auto_Process_Email_PUB;

Line 830: FND_MSG_PUB.Add;

826: when NO_DATA_FOUND THEN
827: Rollback to Auto_Process_Email_PUB;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ACTION');
830: FND_MSG_PUB.Add;
831: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
832:
833: if l_exception_log then
834: errorMessage := '[There is no action in iem_actions corresponding to the email_proc_id' ||l_emailproc_id||']' ;

Line 831: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

827: Rollback to Auto_Process_Email_PUB;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ACTION');
830: FND_MSG_PUB.Add;
831: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
832:
833: if l_exception_log then
834: errorMessage := '[There is no action in iem_actions corresponding to the email_proc_id' ||l_emailproc_id||']' ;
835: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_RULES_ENGINE_PUB.AUTO_PROCESS_EMAIL', errorMessage);

Line 842: FND_MSG_PUB.Add;

838: WHEN IEM_UNKNOWN_RULE_TYPE_EXP THEN
839: Rollback to Auto_Process_Email_PUB;
840: x_return_status := FND_API.G_RET_STS_ERROR;
841: FND_MESSAGE.SET_NAME('IEM','IEM_UNKNOWN_RULE_TYPE_EXP');
842: FND_MSG_PUB.Add;
843: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
844:
845: if l_exception_log then
846: errorMessage := '[Unknown Rule type... p_rule_type=' || p_rule_type ||']' ;

Line 843: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

839: Rollback to Auto_Process_Email_PUB;
840: x_return_status := FND_API.G_RET_STS_ERROR;
841: FND_MESSAGE.SET_NAME('IEM','IEM_UNKNOWN_RULE_TYPE_EXP');
842: FND_MSG_PUB.Add;
843: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
844:
845: if l_exception_log then
846: errorMessage := '[Unknown Rule type... p_rule_type=' || p_rule_type ||']' ;
847: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_RULES_ENGINE_PUB.AUTO_PROCESS_EMAIL', errorMessage);

Line 853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

849:
850: WHEN FND_API.G_EXC_ERROR THEN
851: Rollback to Auto_Process_Email_PUB;
852: x_return_status := FND_API.G_RET_STS_ERROR;
853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
854:
855: if l_exception_log then
856: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Execution Error';
857: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_RULES_ENGINE_PUB.AUTO_PROCESS_EMAIL.EXEC_ERROR', errorMessage);

Line 863: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

859:
860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
861: Rollback to Auto_Process_Email_PUB;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
864:
865: if l_exception_log then
866: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Unexpected Execution Error';
867: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_RULES_ENGINE_PUB.AUTO_PROCESS_EMAIL.UNEXP_EXEC_ERROR', errorMessage);

Line 873: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

869:
870: WHEN OTHERS THEN
871: Rollback to Auto_Process_Email_PUB;
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
874: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
875: END IF;
876: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
877:

Line 874: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

870: WHEN OTHERS THEN
871: Rollback to Auto_Process_Email_PUB;
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
874: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
875: END IF;
876: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
877:
878: if l_exception_log then

Line 876: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

872: x_return_status := FND_API.G_RET_STS_ERROR;
873: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
874: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
875: END IF;
876: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
877:
878: if l_exception_log then
879: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
880: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_RULES_ENGINE_PUB.AUTO_PROCESS_EMAIL.OTHERS', errorMessage);