eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_ENCRYPT_TAGS_PVT dependencies on IEM_ENCRYPTED_TAGS

Line 104: SELECT IEM_ENCRYPTED_TAGS_s1.nextval

100:
101: --DBMS_RANDOM.TERMINATE;
102:
103: --get next sequential number
104: SELECT IEM_ENCRYPTED_TAGS_s1.nextval
105: INTO l_seq_id
106: FROM dual;
107:
108: g_encrypted_id := l_seq_id;

Line 111: INSERT INTO IEM_ENCRYPTED_TAGS

107:
108: g_encrypted_id := l_seq_id;
109:
110:
111: INSERT INTO IEM_ENCRYPTED_TAGS
112: (
113: ENCRYPTED_ID,
114: MESSAGE_ID,
115: AGENT_ID,

Line 188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.CREATE_ITEM', logMessage);

184: x_msg_data => l_msg_data);
185: else
186: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
187: logMessage := '[Miss creating key-val in Encypted tag details table since Key is null.]';
188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.CREATE_ITEM', logMessage);
189: end if;
190: end if;
191:
192: END LOOP;

Line 300: select ENCRYPTED_ID into l_encpt_id from iem_encrypted_tags where message_id = l_msg_id;

296:
297:
298: l_msg_id := LTRIM(RTRIM(p_message_id));
299:
300: select ENCRYPTED_ID into l_encpt_id from iem_encrypted_tags where message_id = l_msg_id;
301:
302: DELETE
303: FROM IEM_ENCRYPTED_TAGS
304: WHERE message_id = l_msg_id;

Line 303: FROM IEM_ENCRYPTED_TAGS

299:
300: select ENCRYPTED_ID into l_encpt_id from iem_encrypted_tags where message_id = l_msg_id;
301:
302: DELETE
303: FROM IEM_ENCRYPTED_TAGS
304: WHERE message_id = l_msg_id;
305:
306: if SQL%NOTFOUND then
307: -- dbms_output.put_line('Delete encypted_tag no msg found!');

Line 321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

317: end if;
318:
319: if l_debug then
320: logMessage := '[Success deleting: MSG_ID = ' || p_message_id ||' from encrypted tag table! ]';
321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
322: end if;
323:
324: --Standard check of p_commit
325: IF FND_API.to_Boolean(p_commit) THEN

Line 340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

336: x_return_status := FND_API.G_RET_STS_ERROR ;
337: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
338: if l_debug then
339: logMessage := '[Not delete (no encrypted tag found)- trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
341: end if;
342:
343: WHEN IEM_MSG_ID_NOT_FOUND THEN
344: ROLLBACK TO delete_item_by_msg_id_PVT;

Line 351: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
348:
349: if l_debug then
350: logMessage := '[Not delete (MSG_ID not found) - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
351: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
352: end if;
353:
354: WHEN FND_API.G_EXC_ERROR THEN
355: ROLLBACK TO delete_item_by_msg_id_PVT;

Line 362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

358: ( p_count => x_msg_count,p_data => x_msg_data);
359:
360: if l_debug then
361: logMessage := '[FND_API.G_EXC_ERROR - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
363: end if;
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO delete_item_by_msg_id_PVT;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

367: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
368:
369: if l_debug then
370: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR in - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
372: end if;
373: WHEN OTHERS THEN
374: ROLLBACK TO delete_item_by_msg_id_PVT;
375: --dbms_output.put_line('Other error in delete_item_on_msg_id ' ||SUBSTR (SQLERRM , 1 , 100));

Line 384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

380: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
381:
382: if l_debug then
383: logMessage := '[Failed (Other exception) - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
385: end if;
386: END delete_item_by_msg_id;
387:
388:

Line 439: update IEM_ENCRYPTED_TAGS

435: -- raise IEM_INVALID_MSG_ID;
436: --end if;
437:
438:
439: update IEM_ENCRYPTED_TAGS
440: set
441: message_id=p_message_id,
442: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),
443: LAST_UPDATE_DATE = sysdate,

Line 723: update iem_encrypted_tags set message_id = null where message_id = l_msg_id;

719:
720:
721: l_msg_id := LTRIM(RTRIM(p_message_id));
722:
723: update iem_encrypted_tags set message_id = null where message_id = l_msg_id;
724:
725: if l_debug then
726: logMessage := '[Success reset: MSG_ID = ' || p_message_id ||' from encrypted tag table! ]';
727: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

Line 727: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

723: update iem_encrypted_tags set message_id = null where message_id = l_msg_id;
724:
725: if l_debug then
726: logMessage := '[Success reset: MSG_ID = ' || p_message_id ||' from encrypted tag table! ]';
727: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
728: end if;
729:
730: --Standard check of p_commit
731: IF FND_API.to_Boolean(p_commit) THEN

Line 746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

742: x_return_status := FND_API.G_RET_STS_ERROR ;
743: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
744: if l_debug then
745: logMessage := '[Not delete (no encrypted tag found)- trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
747: end if;
748:
749: WHEN FND_API.G_EXC_ERROR THEN
750: ROLLBACK TO reset_tag_PVT;

Line 757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

753: ( p_count => x_msg_count,p_data => x_msg_data);
754:
755: if l_debug then
756: logMessage := '[FND_API.G_EXC_ERROR - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
758: end if;
759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
760: ROLLBACK TO reset_tag_PVT;
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 766: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

762: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
763:
764: if l_debug then
765: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR in - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
766: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
767: end if;
768: WHEN OTHERS THEN
769: ROLLBACK TO reset_tag_PVT;
770: --dbms_output.put_line('Other error in delete_item_on_msg_id ' ||SUBSTR (SQLERRM , 1 , 100));

Line 779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);

775: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
776:
777: if l_debug then
778: logMessage := '[Failed (Other exception) - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
779: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DELETE_ITEM_BY_MSG_ID', logMessage);
780: end if;
781: END ;
782:
783: -- Enter further code below as specified in the Package spec.

Line 803: l_encypted_rec IEM_ENCRYPTED_TAGS%ROWTYPE;

799: l_debug boolean;
800: l_seq_id number;
801: l_seq_dtl_id number;
802:
803: l_encypted_rec IEM_ENCRYPTED_TAGS%ROWTYPE;
804: cursor c_tag_dtls (p_encypted_id iem_encrypted_tag_dtls.encrypted_id%type)
805: is
806: select key, value from iem_encrypted_tag_dtls where encrypted_id = p_encypted_id;
807:

Line 838: select * into l_encypted_rec from IEM_ENCRYPTED_TAGS where ENCRYPTED_ID=p_encrypted_id;

834: FND_LOG_REPOSITORY.init(null,null);
835:
836: l_debug := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
837:
838: select * into l_encypted_rec from IEM_ENCRYPTED_TAGS where ENCRYPTED_ID=p_encrypted_id;
839:
840: SELECT IEM_ENCRYPTED_TAGS_S1.nextval
841: INTO l_seq_id
842: FROM dual;

Line 840: SELECT IEM_ENCRYPTED_TAGS_S1.nextval

836: l_debug := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
837:
838: select * into l_encypted_rec from IEM_ENCRYPTED_TAGS where ENCRYPTED_ID=p_encrypted_id;
839:
840: SELECT IEM_ENCRYPTED_TAGS_S1.nextval
841: INTO l_seq_id
842: FROM dual;
843:
844: --l_encypted_rec.ENCRYPTED_ID := l_seq_id;

Line 849: insert into IEM_ENCRYPTED_TAGS

845: --l_encypted_rec.MESSAGE_ID := p_message_id;
846: --l_encypted_rec.CREATION_DATE := SYSDATE;
847: --l_encypted_rec.LAST_UPDATE_DATE := SYSDATE;
848:
849: insert into IEM_ENCRYPTED_TAGS
850: (
851: ENCRYPTED_ID,
852: MESSAGE_ID,
853: AGENT_ID,

Line 989: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DUPLICATE_TAGS', logMessage);

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);
987: if l_debug then
988: logMessage := '[No Data found when duplicate tag records! ]';
989: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DUPLICATE_TAGS', logMessage);
990: end if;
991:
992:
993: WHEN FND_API.G_EXC_ERROR THEN

Line 1001: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DUPLICATE_TAGS', logMessage);

997: ( p_count => x_msg_count,p_data => x_msg_data);
998:
999: if l_debug then
1000: logMessage := '[FND_API.G_EXC_ERROR - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
1001: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DUPLICATE_TAGS', logMessage);
1002: end if;
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: ROLLBACK TO delete_item_by_msg_id_PVT;
1005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1010: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DUPLICATE_TAGS', logMessage);

1006: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1007:
1008: if l_debug then
1009: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR in - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
1010: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DUPLICATE_TAGS', logMessage);
1011: end if;
1012: WHEN OTHERS THEN
1013: ROLLBACK TO delete_item_by_msg_id_PVT;
1014: --dbms_output.put_line('Other error in delete_item_on_msg_id ' ||SUBSTR (SQLERRM , 1 , 100));

Line 1023: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DUPLICATE_TAGS', logMessage);

1019: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1020:
1021: if l_debug then
1022: logMessage := '[Failed (Other exception) - trying to delete Encrypted tag with MSG_ID = ' || p_message_id ||']';
1023: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ENCRYPTED_TAGS_PVT.DUPLICATE_TAGS', logMessage);
1024: end if;
1025: END duplicate_tags;
1026:
1027: END IEM_ENCRYPT_TAGS_PVT; -- Package Body IEM_ENCRYPT_TAGS_PVT