[Home] [Help]
267: --Get parameter(s)
268: cursor c_params(p_emailproc_id iem_emailprocs.emailproc_id%type)
269: is
270: select b.parameter1, b.parameter2,b.parameter3, b.parameter_tag
271: from iem_actions a, iem_action_dtls b
272: where a.action_id = b.action_id and a.emailproc_id = p_emailproc_id;
273:
274: --Verify that there are document under category for Document Mapping
275: BEGIN
357:
358: --Check 'All Emails' is set or not. If set, return result without evaluate rules
359: IF v_emailprocs.all_email = 'Y' THEN
360: --Get action name. Currently one rule type corresponding to one action
361: select action into l_action from iem_actions where emailproc_id = v_emailprocs.emailproc_id;
362:
363: --- PK
364: if l_action = 'AUTOCREATESR' then
365:
531: --If the rules got satisfied then return result
532: if satisfied then
533:
534: --Get action name. Currently one rule type corresponding to one action
535: select action into l_action from iem_actions where emailproc_id = v_emailprocs.emailproc_id;
536:
537: --- PK
538: if l_action = 'AUTOCREATESR' then
539:
679:
680: --Check 'All Emails' is set or not. If set, return result without evaluate rules
681: IF v_emailprocs.all_email = 'Y' THEN
682: --Get action name. Currently one rule type corresponding to one action
683: select action into l_action from iem_actions where emailproc_id = v_emailprocs.emailproc_id;
684:
685: --- PK
686: if l_action = 'AUTOCREATESR' then
687:
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);
847: end if;
848:
849: WHEN IEM_UNKNOWN_RULE_TYPE_EXP THEN