APPS.IEM_TAGPROCESS_PUB dependencies on IEM_ENCRYPTED_TAGS

Line 327: logMessage := '[Failed to create data in IEM_ENCRYPTED_TAGS table. ]';

323: ROLLBACK TO getEncryptId_PUB;
324: x_return_status := FND_API.G_RET_STS_ERROR ;
325:
326: if l_log_enabled then
327: logMessage := '[Failed to create data in IEM_ENCRYPTED_TAGS table. ]';
328: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_TAGPROCESS_PUB.getEncryptId', logMessage);
329: end if;
330:
331: WHEN FND_API.G_EXC_ERROR THEN

Line 566: cursor c_key_val (p_encrypted_id iem_encrypted_tags.encrypted_id%type)

562: IEM_FAILED_TO_STAMP_TAG EXCEPTION;
563: IEM_ENCRYPTED_ID_ALREADY_USED EXCEPTION;
564: IEM_FAIL_DUPLICAT_REC_REUSETAG EXCEPTION;
565:
566: cursor c_key_val (p_encrypted_id iem_encrypted_tags.encrypted_id%type)
567: is
568: select
569: a.key,
570: a.value

Line 621: select token into l_token_out from iem_encrypted_tags where encrypted_id = l_encrypt_num;

617:
618: --Security check
619: begin
620: l_encrypt_num := TO_NUMBER( l_encrypt_char );
621: select token into l_token_out from iem_encrypted_tags where encrypted_id = l_encrypt_num;
622:
623: exception
624: when others then
625: raise IEM_TOKEN_NOT_MATCH;

Line 633: select message_id into l_mess_id from iem_encrypted_tags where encrypted_id = l_encrypt_num;

629: raise IEM_TOKEN_NOT_MATCH;
630: end if;
631:
632: -- Check whether this encrypted_id already been used by other message or not
633: select message_id into l_mess_id from iem_encrypted_tags where encrypted_id = l_encrypt_num;
634:
635: l_reuse_tag := FND_PROFILE.VALUE_SPECIFIC('IEM_REPROCESS_ALL_TAGS');
636:
637: -- If reuse tag is not set and tag has been used

Line 685: FROM iem_encrypted_tags

681: end if;
682:
683: SELECT agent_id, interaction_id
684: INTO l_agent_id, l_interaction_id
685: FROM iem_encrypted_tags
686: WHERE encrypted_id = l_encrypt_num;
687:
688: -- Get eMail Center system Tags
689: l_keyVal_tab(1).key := 'IEMNAGENTID';

Line 857: cursor c_key_val (p_msg_id iem_encrypted_tags.message_id%type)

853:
854: IEM_TOKEN_NOT_MATCH EXCEPTION;
855: IEM_INVALID_ENCRYPTED_ID EXCEPTION;
856:
857: cursor c_key_val (p_msg_id iem_encrypted_tags.message_id%type)
858: is
859: select
860: a.key,
861: a.value

Line 863: iem_encrypted_tag_dtls a, iem_encrypted_tags b

859: select
860: a.key,
861: a.value
862: from
863: iem_encrypted_tag_dtls a, iem_encrypted_tags b
864: where
865: a.encrypted_id=b.encrypted_id and b.message_id = p_msg_id;
866: BEGIN
867: SAVEPOINT getTagValues_on_MsgId_PUB;

Line 899: FROM iem_encrypted_tags

895:
896:
897: SELECT agent_id, interaction_id, encrypted_id, token
898: INTO l_agent_id, l_interaction_id, l_encrypted_id, l_token
899: FROM iem_encrypted_tags
900: WHERE message_Id = p_message_id;
901:
902: --First get system tags: agent_id, interaction_id
903: l_keyVal_tab(1).key := 'IEMNAGENTID';