60: WHERE EMAIL_ACCOUNT_ID=p_email_account_id
61: and rownum=1;
62: IF l_grp_cnt = 0 then
63: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_EMAIL_ACCT_ID');
64: APP_EXCEPTION.RAISE_EXCEPTION;
65: END IF;
66: end if;
67: SELECT iem_email_icntr_maps_s1.nextval
68: INTO l_seq_id
304: WHERE EMAIL_ACCOUNT_ID=p_email_account_id
305: and rownum=1;
306: IF l_grp_cnt = 0 then
307: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_EMAIL_ACCT_ID');
308: APP_EXCEPTION.RAISE_EXCEPTION;
309: END IF;
310: end if;
311: if p_email_icntr_map_id is null then
312: update iem_email_icntr_maps