DBA Data[Home] [Help]

APPS.IEM_RULES_ENGINE_PUB dependencies on FND_MSG_PUB

Line 292: FND_MSG_PUB.initialize;

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

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

830: COMMIT WORK;
831: End if;
832:
833: --Standard call to get message count and if count is 1 then get message info
834: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
835:
836: EXCEPTION
837: when NO_DATA_FOUND THEN
838: Rollback to Auto_Process_Email_PUB;

Line 841: FND_MSG_PUB.Add;

837: when NO_DATA_FOUND THEN
838: Rollback to Auto_Process_Email_PUB;
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ACTION');
841: FND_MSG_PUB.Add;
842: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
843:
844: if l_exception_log then
845: errorMessage := '[There is no action in iem_actions corresponding to the email_proc_id' ||l_emailproc_id||']' ;

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

838: Rollback to Auto_Process_Email_PUB;
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ACTION');
841: FND_MSG_PUB.Add;
842: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
843:
844: if l_exception_log then
845: errorMessage := '[There is no action in iem_actions corresponding to the email_proc_id' ||l_emailproc_id||']' ;
846: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_RULES_ENGINE_PUB.AUTO_PROCESS_EMAIL', errorMessage);

Line 853: FND_MSG_PUB.Add;

849: WHEN IEM_UNKNOWN_RULE_TYPE_EXP THEN
850: Rollback to Auto_Process_Email_PUB;
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: FND_MESSAGE.SET_NAME('IEM','IEM_UNKNOWN_RULE_TYPE_EXP');
853: FND_MSG_PUB.Add;
854: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
855:
856: if l_exception_log then
857: errorMessage := '[Unknown Rule type... p_rule_type=' || p_rule_type ||']' ;

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

850: Rollback to Auto_Process_Email_PUB;
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: FND_MESSAGE.SET_NAME('IEM','IEM_UNKNOWN_RULE_TYPE_EXP');
853: FND_MSG_PUB.Add;
854: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
855:
856: if l_exception_log then
857: errorMessage := '[Unknown Rule type... p_rule_type=' || p_rule_type ||']' ;
858: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_RULES_ENGINE_PUB.AUTO_PROCESS_EMAIL', errorMessage);

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

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

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

870:
871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
872: Rollback to Auto_Process_Email_PUB;
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
875:
876: if l_exception_log then
877: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Unexpected Execution Error';
878: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_RULES_ENGINE_PUB.AUTO_PROCESS_EMAIL.UNEXP_EXEC_ERROR', errorMessage);

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

880:
881: WHEN OTHERS THEN
882: Rollback to Auto_Process_Email_PUB;
883: x_return_status := FND_API.G_RET_STS_ERROR;
884: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
885: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
886: END IF;
887: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
888:

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

881: WHEN OTHERS THEN
882: Rollback to Auto_Process_Email_PUB;
883: x_return_status := FND_API.G_RET_STS_ERROR;
884: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
885: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
886: END IF;
887: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
888:
889: if l_exception_log then

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

883: x_return_status := FND_API.G_RET_STS_ERROR;
884: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
885: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
886: END IF;
887: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
888:
889: if l_exception_log then
890: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
891: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_RULES_ENGINE_PUB.AUTO_PROCESS_EMAIL.OTHERS', errorMessage);