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.AMS_LIST_SRC_TYPES_PVT dependencies on AMS_UTILITY_PVT

Line 40: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_PROCEDURE);

36: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
37: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
38: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
39:
40: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_PROCEDURE);
41: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_exception);
42: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_STATEMENT);
43:
44: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;

Line 41: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_exception);

37: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
38: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
39:
40: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_PROCEDURE);
41: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_exception);
42: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_STATEMENT);
43:
44: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;
45: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;

Line 42: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_STATEMENT);

38: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
39:
40: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_PROCEDURE);
41: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_exception);
42: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(FND_LOG.LEVEL_STATEMENT);
43:
44: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;
45: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;
46: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;

Line 290: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');

286:
287: -- Debug Message
288:
289: IF (AMS_LOG_PROCEDURE_ON) THEN
290: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');
291: END IF;
292:
293: IF (AMS_DEBUG_HIGH_ON) THEN
294: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

Line 303: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'Generating the tar views for :'||p_list_source_type_id);

299: -- Initialize API return status to success
300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301:
302: IF (AMS_LOG_STATEMENT_ON) THEN
303: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'Generating the tar views for :'||p_list_source_type_id);
304: END IF;
305:
306: OPEN c_list_src_type_name;
307: FETCH c_list_src_type_name into i_list_source_name, i_le_ss_type;

Line 393: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'L_SUB_SOURCE_TYPE_ID:'||L_SUB_SOURCE_TYPE_ID);

389: exit when c_all_sub_types%notfound;
390: i_number := i_number + 1;
391:
392: IF (AMS_LOG_STATEMENT_ON) THEN
393: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'L_SUB_SOURCE_TYPE_ID:'||L_SUB_SOURCE_TYPE_ID);
394: END IF;
395:
396:
397: OPEN c_sub_type;

Line 439: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name||'.'||l_api_name,substr(i_sql_string,(2000*i) - 1999,2000));

435: IF (AMS_LOG_STATEMENT_ON) THEN
436: l_no_of_chunks := ceil(length(i_sql_string)/2000 );
437: for i in 1 ..l_no_of_chunks
438: loop
439: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name||'.'||l_api_name,substr(i_sql_string,(2000*i) - 1999,2000));
440: end loop;
441: END IF;
442: EXECUTE IMMEDIATE i_sql_string;
443: /*

Line 463: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');

459: FND_MSG_PUB.Add;
460: END IF;
461:
462: IF (AMS_LOG_PROCEDURE_ON) THEN
463: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');
464: END IF;
465:
466: -- Standard call to get message count AND IF count is 1, get message info.
467: FND_MSG_PUB.Count_AND_Get

Line 474: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,'$$$$$$$$$: END :$$$$$$');

470: p_encoded => FND_API.G_FALSE
471: );
472:
473: IF (AMS_LOG_PROCEDURE_ON) THEN
474: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,'$$$$$$$$$: END :$$$$$$');
475: END IF;
476:
477: EXCEPTION
478:

Line 481: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' execution ERROR has been raised ');

477: EXCEPTION
478:
479: WHEN FND_API.G_EXC_ERROR THEN
480: IF (AMS_LOG_PROCEDURE_ON) THEN
481: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' execution ERROR has been raised ');
482: END IF;
483:
484: x_return_status := FND_API.G_RET_STS_ERROR ;
485: FND_MSG_PUB.Count_AND_Get

Line 493: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' Unexpected error has been raised ');

489: );
490:
491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
492: IF (AMS_LOG_PROCEDURE_ON) THEN
493: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' Unexpected error has been raised ');
494: END IF;
495:
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497: FND_MSG_PUB.Count_AND_Get

Line 508: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');

504: WHEN OTHERS THEN
505:
506:
507: IF (AMS_LOG_PROCEDURE_ON) THEN
508: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');
509: END IF;
510:
511: IF (AMS_LOG_EXCEPTION_ON) THEN
512: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);

Line 512: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);

508: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');
509: END IF;
510:
511: IF (AMS_LOG_EXCEPTION_ON) THEN
512: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
513: END IF;
514:
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

Line 581: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');

577: FND_MSG_PUB.Add;
578: END IF;
579:
580: IF (AMS_LOG_PROCEDURE_ON) THEN
581: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');
582: END IF;
583:
584: -- Initialize API return status to success
585: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 626: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');

622: FND_MSG_PUB.Add;
623: END IF;
624:
625: IF (AMS_LOG_PROCEDURE_ON) THEN
626: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');
627: END IF;
628:
629: -- Standard call to get message count AND IF count is 1, get message info.
630: FND_MSG_PUB.Count_AND_Get

Line 642: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' execution ERROR has been raised ');

638: WHEN FND_API.G_EXC_ERROR THEN
639: x_return_status := FND_API.G_RET_STS_ERROR ;
640:
641: IF (AMS_LOG_PROCEDURE_ON) THEN
642: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' execution ERROR has been raised ');
643: END IF;
644:
645: FND_MSG_PUB.Count_AND_Get
646: ( p_count => x_msg_count,

Line 656: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' Unexpected error has been raised ');

652: END IF;
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: IF (AMS_LOG_PROCEDURE_ON) THEN
656: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' Unexpected error has been raised ');
657: END IF;
658:
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
660: FND_MSG_PUB.Count_AND_Get

Line 673: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');

669:
670: WHEN OTHERS THEN
671:
672: IF (AMS_LOG_PROCEDURE_ON) THEN
673: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');
674: END IF;
675:
676: IF (AMS_LOG_EXCEPTION_ON) THEN
677: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);

Line 677: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);

673: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');
674: END IF;
675:
676: IF (AMS_LOG_EXCEPTION_ON) THEN
677: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
678: END IF;
679:
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
681: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

Line 752: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');

748: END IF;
749:
750:
751: IF (AMS_LOG_PROCEDURE_ON) THEN
752: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');
753: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,'Passed in List Source Type Id is:'||p_list_source_type_id);
754: END IF;
755:
756: -- Initialize API return status to success

Line 753: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,'Passed in List Source Type Id is:'||p_list_source_type_id);

749:
750:
751: IF (AMS_LOG_PROCEDURE_ON) THEN
752: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');
753: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,'Passed in List Source Type Id is:'||p_list_source_type_id);
754: END IF;
755:
756: -- Initialize API return status to success
757: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 768: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'calling the master_source_type_view');

764: IF i_master_flag = 'Y'
765: AND (p_list_source_type_id = 14 OR p_list_source_type_id = 30) ---person or organization contact
766: THEN
767: IF (AMS_LOG_STATEMENT_ON) THEN
768: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'calling the master_source_type_view');
769: END IF;
770:
771: master_source_type_view(
772: l_api_version,

Line 782: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'calling the update_all_master_views');

778: p_list_source_type_id);
779:
780: else
781: IF (AMS_LOG_STATEMENT_ON) THEN
782: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'calling the update_all_master_views');
783: END IF;
784:
785: update_all_master_views(
786: l_api_version,

Line 797: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'Return Status is:'||x_return_status);

793:
794: end if;
795:
796: IF (AMS_LOG_STATEMENT_ON) THEN
797: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'Return Status is:'||x_return_status);
798: END IF;
799:
800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
801: THEN

Line 802: AMS_UTILITY_PVT.debug_message('Error Generating the tar views');

798: END IF;
799:
800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
801: THEN
802: AMS_UTILITY_PVT.debug_message('Error Generating the tar views');
803: FND_MESSAGE.set_name('AMS', 'AMS_ERR_LIST_GEN_TAR_VIEW');
804: FND_MSG_PUB.Add;
805: RAISE FND_API.g_exc_error;
806: END IF;

Line 841: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');

837: FND_MSG_PUB.Add;
838: END IF;
839:
840: IF (AMS_LOG_PROCEDURE_ON) THEN
841: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');
842: END IF;
843:
844:
845: -- Standard call to get message count AND IF count is 1, get message info.

Line 856: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' execution ERROR has been raised ');

852: EXCEPTION
853:
854: WHEN FND_API.G_EXC_ERROR THEN
855: IF (AMS_LOG_PROCEDURE_ON) THEN
856: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' execution ERROR has been raised ');
857: END IF;
858:
859: x_return_status := FND_API.G_RET_STS_ERROR ;
860: FND_MSG_PUB.Count_AND_Get

Line 870: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' Unexpected error has been raised ');

866:
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868:
869: IF (AMS_LOG_PROCEDURE_ON) THEN
870: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' Unexpected error has been raised ');
871: END IF;
872:
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
874: FND_MSG_PUB.Count_AND_Get

Line 883: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');

879:
880: WHEN OTHERS THEN
881:
882: IF (AMS_LOG_PROCEDURE_ON) THEN
883: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');
884: END IF;
885:
886: IF (AMS_LOG_EXCEPTION_ON) THEN
887: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);

Line 887: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);

883: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');
884: END IF;
885:
886: IF (AMS_LOG_EXCEPTION_ON) THEN
887: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
888: END IF;
889:
890:
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;