[Home] [Help]
658: IEM_RULE_NOT_DELETED EXCEPTION;
659: IEM_ROUTE_RULE_NOT_CREATED EXCEPTION;
660: IEM_ADMIN_EMAILPROC_NO_RULE EXCEPTION;
661: l_IEM_FAIL_TO_CALL EXCEPTION;
662: IEM_ACTION_DTLS_NOT_CREATE EXCEPTION;
663: IEM_ADM_AUTOPRC_NO_PARAMETERS EXCEPTION;
664: IEM_ADM_INVALID_PROC_NAME EXCEPTION;
665: IEM_PROC_REDIRECT_SAME_ACCT EXCEPTION;
666:
840: update iem_actions set action=p_action where action_id = l_action_id;
841: end if;
842:
843: -- updating action dtls
844: delete from iem_action_dtls where action_id = l_action_id;
845:
846: if ( p_parameter2_tbl is not null ) then
847: l_param2_count := p_parameter2_tbl.count;
848: end if;
880: x_msg_count => l_msg_count,
881: x_msg_data => l_msg_data);
882:
883: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
884: raise IEM_ACTION_DTLS_NOT_CREATE;
885: end if;
886: end loop;
887: END IF;
888:
959:
960: x_return_status := FND_API.G_RET_STS_ERROR ;
961: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
962:
963: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
964: ROLLBACK TO update_item_wrap;
965: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
966: FND_MSG_PUB.Add;
967:
961: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
962:
963: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
964: ROLLBACK TO update_item_wrap;
965: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
966: FND_MSG_PUB.Add;
967:
968: x_return_status := FND_API.G_RET_STS_ERROR ;
969: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1032:
1033: IEM_EMAILPROC_NOT_CREATED EXCEPTION;
1034: IEM_EMAILPROC_RULE_NOT_CREATED EXCEPTION;
1035: IEM_ACTION_NOT_CREATED EXCEPTION;
1036: IEM_ACTION_DTLS_NOT_CREATE EXCEPTION;
1037: IEM_ADM_AUTOPRC_NO_PARAMETERS EXCEPTION;
1038: IEM_ADM_INVALID_PROC_NAME EXCEPTION;
1039: BEGIN
1040:
1183: x_msg_count => l_msg_count,
1184: x_msg_data => l_msg_data);
1185:
1186: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1187: raise IEM_ACTION_DTLS_NOT_CREATE;
1188: end if;
1189: end loop;
1190: END IF;
1191:
1227: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');
1228: FND_MSG_PUB.Add;
1229: x_return_status := FND_API.G_RET_STS_ERROR ;
1230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1231: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1232:
1233: ROLLBACK TO create_item_wrap;
1234: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1235: FND_MSG_PUB.Add;
1230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1231: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1232:
1233: ROLLBACK TO create_item_wrap;
1234: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1235: FND_MSG_PUB.Add;
1236: x_return_status := FND_API.G_RET_STS_ERROR ;
1237: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1238:
1331: raise IEM_ADMIN_ACCOUNT_NOT_EXIST;
1332: end if;
1333:
1334: select count(*) into l_redirect_same_acct
1335: from iem_emailprocs a, iem_actions b, iem_action_dtls c
1336: where a.emailproc_id = p_emailproc_id and a.emailproc_id=b.emailproc_id
1337: and a.rule_type='AUTOREDIRECT' and b.action='AUTOREDIRECT_INTERNAL'
1338: and b.action_id=c.action_id and c.parameter1=to_char(p_email_account_id);
1339:
1673: DELETE
1674: FROM IEM_EMAILPROC_RULES
1675: WHERE emailproc_id=p_emailproc_id;
1676:
1677: --remove iem_action_dtls
1678: FOR v_action_id IN action_id_cursor(p_emailproc_id) LOOP
1679: delete from iem_action_dtls where action_id = v_action_id.action_id;
1680: END LOOP;
1681:
1675: WHERE emailproc_id=p_emailproc_id;
1676:
1677: --remove iem_action_dtls
1678: FOR v_action_id IN action_id_cursor(p_emailproc_id) LOOP
1679: delete from iem_action_dtls where action_id = v_action_id.action_id;
1680: END LOOP;
1681:
1682: --remove iem_email_actions
1683: delete from iem_actions where emailproc_id = p_emailproc_id;