[Home] [Help]
661: IEM_RULE_NOT_DELETED EXCEPTION;
662: IEM_ROUTE_RULE_NOT_CREATED EXCEPTION;
663: IEM_ADMIN_EMAILPROC_NO_RULE EXCEPTION;
664: l_IEM_FAIL_TO_CALL EXCEPTION;
665: IEM_ACTION_DTLS_NOT_CREATE EXCEPTION;
666: IEM_ADM_AUTOPRC_NO_PARAMETERS EXCEPTION;
667: IEM_ADM_INVALID_PROC_NAME EXCEPTION;
668: IEM_PROC_REDIRECT_SAME_ACCT EXCEPTION;
669:
843: update iem_actions set action=p_action where action_id = l_action_id;
844: end if;
845:
846: -- updating action dtls
847: delete from iem_action_dtls where action_id = l_action_id;
848:
849: if ( p_parameter2_tbl is not null ) then
850: l_param2_count := p_parameter2_tbl.count;
851: end if;
897: x_msg_count => l_msg_count,
898: x_msg_data => l_msg_data);
899:
900: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
901: raise IEM_ACTION_DTLS_NOT_CREATE;
902: end if;
903: end loop;
904: END IF;
905:
976:
977: x_return_status := FND_API.G_RET_STS_ERROR ;
978: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
979:
980: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
981: ROLLBACK TO update_item_wrap;
982: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
983: FND_MSG_PUB.Add;
984:
978: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
979:
980: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
981: ROLLBACK TO update_item_wrap;
982: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
983: FND_MSG_PUB.Add;
984:
985: x_return_status := FND_API.G_RET_STS_ERROR ;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1052:
1053: IEM_EMAILPROC_NOT_CREATED EXCEPTION;
1054: IEM_EMAILPROC_RULE_NOT_CREATED EXCEPTION;
1055: IEM_ACTION_NOT_CREATED EXCEPTION;
1056: IEM_ACTION_DTLS_NOT_CREATE EXCEPTION;
1057: IEM_ADM_AUTOPRC_NO_PARAMETERS EXCEPTION;
1058: IEM_ADM_INVALID_PROC_NAME EXCEPTION;
1059: BEGIN
1060:
1216: x_msg_count => l_msg_count,
1217: x_msg_data => l_msg_data);
1218:
1219: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1220: raise IEM_ACTION_DTLS_NOT_CREATE;
1221: end if;
1222: end loop;
1223: END IF;
1224:
1260: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');
1261: FND_MSG_PUB.Add;
1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1265:
1266: ROLLBACK TO create_item_wrap;
1267: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1268: FND_MSG_PUB.Add;
1263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1265:
1266: ROLLBACK TO create_item_wrap;
1267: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1268: FND_MSG_PUB.Add;
1269: x_return_status := FND_API.G_RET_STS_ERROR ;
1270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1271:
1364: raise IEM_ADMIN_ACCOUNT_NOT_EXIST;
1365: end if;
1366:
1367: select count(*) into l_redirect_same_acct
1368: from iem_emailprocs a, iem_actions b, iem_action_dtls c
1369: where a.emailproc_id = p_emailproc_id and a.emailproc_id=b.emailproc_id
1370: and a.rule_type='AUTOREDIRECT' and b.action='AUTOREDIRECT_INTERNAL'
1371: and b.action_id=c.action_id and c.parameter1=to_char(p_email_account_id);
1372:
1706: DELETE
1707: FROM IEM_EMAILPROC_RULES
1708: WHERE emailproc_id=p_emailproc_id;
1709:
1710: --remove iem_action_dtls
1711: FOR v_action_id IN action_id_cursor(p_emailproc_id) LOOP
1712: delete from iem_action_dtls where action_id = v_action_id.action_id;
1713: END LOOP;
1714:
1708: WHERE emailproc_id=p_emailproc_id;
1709:
1710: --remove iem_action_dtls
1711: FOR v_action_id IN action_id_cursor(p_emailproc_id) LOOP
1712: delete from iem_action_dtls where action_id = v_action_id.action_id;
1713: END LOOP;
1714:
1715: --remove iem_email_actions
1716: delete from iem_actions where emailproc_id = p_emailproc_id;