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 FND_LOG

Line 186: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

182: x_return_status =>l_return_status,
183: x_msg_count => l_msg_count,
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;

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 293: FND_LOG_REPOSITORY.init(null,null);

289: --Initialize API status return
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: --Actual API starts here
293: FND_LOG_REPOSITORY.init(null,null);
294:
295: l_debug := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
296:
297:

Line 295: l_debug := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;

291:
292: --Actual API starts here
293: FND_LOG_REPOSITORY.init(null,null);
294:
295: l_debug := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
296:
297:
298: l_msg_id := LTRIM(RTRIM(p_message_id));
299:

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 716: FND_LOG_REPOSITORY.init(null,null);

712: --Initialize API status return
713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714:
715: --Actual API starts here
716: FND_LOG_REPOSITORY.init(null,null);
717:
718: l_debug := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
719:
720:

Line 718: l_debug := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

714:
715: --Actual API starts here
716: FND_LOG_REPOSITORY.init(null,null);
717:
718: l_debug := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
719:
720:
721: l_msg_id := LTRIM(RTRIM(p_message_id));
722:

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 834: FND_LOG_REPOSITORY.init(null,null);

830: --Initialize API status return
831: x_return_status := FND_API.G_RET_STS_SUCCESS;
832:
833: --Actual API starts here
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;

Line 836: l_debug := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

832:
833: --Actual API starts here
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

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