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.PA_SEARCH_PUB dependencies on PA_SEARCH_PUB

Line 1: PACKAGE BODY PA_SEARCH_PUB AS

1: PACKAGE BODY PA_SEARCH_PUB AS
2: --$Header: PARISPBB.pls 120.4 2007/10/29 12:13:35 anuragar ship $
3: --
4:
5: PROCEDURE Run_Search(

Line 107: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.begin',

103:
104: BEGIN
105:
106: IF (P_DEBUG_MODE ='Y') THEN
107: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.begin',
108: x_Msg => 'in PA_SEARCH_PUB.Run_Search',
109: x_Log_Level => 6);
110: End if;
111:

Line 108: x_Msg => 'in PA_SEARCH_PUB.Run_Search',

104: BEGIN
105:
106: IF (P_DEBUG_MODE ='Y') THEN
107: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.begin',
108: x_Msg => 'in PA_SEARCH_PUB.Run_Search',
109: x_Log_Level => 6);
110: End if;
111:
112: -- Initialize the return status.

Line 116: PA_DEBUG.init_err_stack('PA_SEARCH_PUB.Run_Search');

112: -- Initialize the return status.
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: -- Initialise the error stack
116: PA_DEBUG.init_err_stack('PA_SEARCH_PUB.Run_Search');
117:
118: -- Issue API savepoint if the transaction is to be committed
119: IF (p_commit = FND_API.G_TRUE) THEN
120: SAVEPOINT SEARCH_PUB_RUN_OA_SEARCH;

Line 146: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.validation',

142: END IF;
143:
144: IF (P_DEBUG_MODE ='Y') THEN
145: PA_DEBUG.WRITE_LOG(
146: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.validation',
147: x_Msg => 'validate input parameters',
148: x_Log_Level => 6);
149: End If;
150:

Line 626: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.get_search_criteria'

622: ELSIF p_get_search_criteria = FND_API.G_TRUE THEN
623:
624: IF (P_DEBUG_MODE ='Y') THEN
625: PA_DEBUG.WRITE_LOG(
626: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.get_search_criteria'
627: ,x_Msg => 'resource search being execute from page OTHER than the resource search criteria page, get search criteria'
628: ,x_Log_Level => 6);
629: End If;
630:

Line 727: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameters',

723: p_get_search_criteria = FND_API.G_FALSE
724: THEN
725: IF (P_DEBUG_MODE ='Y') THEN
726: PA_DEBUG.WRITE_LOG(
727: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameters',
728: x_Msg => 'calling pvt',
729: x_Log_Level => 6);
730: PA_DEBUG.WRITE_LOG(
731: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 731: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

727: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameters',
728: x_Msg => 'calling pvt',
729: x_Log_Level => 6);
730: PA_DEBUG.WRITE_LOG(
731: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
732: x_Msg => 'p_search_mode=' || p_search_mode,
733: x_Log_Level => 6);
734: PA_DEBUG.WRITE_LOG(
735: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 735: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

731: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
732: x_Msg => 'p_search_mode=' || p_search_mode,
733: x_Log_Level => 6);
734: PA_DEBUG.WRITE_LOG(
735: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
736: x_Msg => 'assignment_id=' || PA_SEARCH_GLOB.g_search_criteria.assignment_id,
737: x_Log_Level => 6);
738: PA_DEBUG.WRITE_LOG(
739: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 739: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

735: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
736: x_Msg => 'assignment_id=' || PA_SEARCH_GLOB.g_search_criteria.assignment_id,
737: x_Log_Level => 6);
738: PA_DEBUG.WRITE_LOG(
739: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
740: x_Msg => 'resource_source_id' || PA_SEARCH_GLOB.g_search_criteria.resource_source_id,
741: x_Log_Level => 6);
742: PA_DEBUG.WRITE_LOG(
743: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 743: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

739: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
740: x_Msg => 'resource_source_id' || PA_SEARCH_GLOB.g_search_criteria.resource_source_id,
741: x_Log_Level => 6);
742: PA_DEBUG.WRITE_LOG(
743: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
744: x_Msg => 'project_id=' || PA_SEARCH_GLOB.g_search_criteria.project_id,
745: x_Log_Level => 6);
746: PA_DEBUG.WRITE_LOG(
747: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 747: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

743: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
744: x_Msg => 'project_id=' || PA_SEARCH_GLOB.g_search_criteria.project_id,
745: x_Log_Level => 6);
746: PA_DEBUG.WRITE_LOG(
747: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
748: x_Msg => 'min_job_level=' || PA_SEARCH_GLOB.g_search_criteria.min_job_level,
749: x_Log_Level => 6);
750: PA_DEBUG.WRITE_LOG(
751: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 751: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

747: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
748: x_Msg => 'min_job_level=' || PA_SEARCH_GLOB.g_search_criteria.min_job_level,
749: x_Log_Level => 6);
750: PA_DEBUG.WRITE_LOG(
751: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
752: x_Msg => 'max_job_level=' || PA_SEARCH_GLOB.g_search_criteria.max_job_level,
753: x_Log_Level => 6);
754: PA_DEBUG.WRITE_LOG(
755: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 755: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

751: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
752: x_Msg => 'max_job_level=' || PA_SEARCH_GLOB.g_search_criteria.max_job_level,
753: x_Log_Level => 6);
754: PA_DEBUG.WRITE_LOG(
755: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
756: x_Msg => 'org_hierarchy_version_id=' || PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
757: x_Log_Level => 6);
758: PA_DEBUG.WRITE_LOG(
759: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 759: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

755: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
756: x_Msg => 'org_hierarchy_version_id=' || PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
757: x_Log_Level => 6);
758: PA_DEBUG.WRITE_LOG(
759: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
760: x_Msg => 'organization_id=' || PA_SEARCH_GLOB.g_search_criteria.organization_id,
761: x_Log_Level => 6);
762: PA_DEBUG.WRITE_LOG(
763: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 763: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

759: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
760: x_Msg => 'organization_id=' || PA_SEARCH_GLOB.g_search_criteria.organization_id,
761: x_Log_Level => 6);
762: PA_DEBUG.WRITE_LOG(
763: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
764: x_Msg => 'territory_code=' || PA_SEARCH_GLOB.g_search_criteria.territory_code,
765: x_Log_Level => 6);
766: PA_DEBUG.WRITE_LOG(
767: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 767: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

763: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
764: x_Msg => 'territory_code=' || PA_SEARCH_GLOB.g_search_criteria.territory_code,
765: x_Log_Level => 6);
766: PA_DEBUG.WRITE_LOG(
767: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
768: x_Msg => 'start_date=' || PA_SEARCH_GLOB.g_search_criteria.start_date,
769: x_Log_Level => 6);
770: PA_DEBUG.WRITE_LOG(
771: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 771: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

767: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
768: x_Msg => 'start_date=' || PA_SEARCH_GLOB.g_search_criteria.start_date,
769: x_Log_Level => 6);
770: PA_DEBUG.WRITE_LOG(
771: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
772: x_Msg => 'end_date=' || PA_SEARCH_GLOB.g_search_criteria.end_date,
773: x_Log_Level => 6);
774: PA_DEBUG.WRITE_LOG(
775: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

Line 775: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',

771: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
772: x_Msg => 'end_date=' || PA_SEARCH_GLOB.g_search_criteria.end_date,
773: x_Log_Level => 6);
774: PA_DEBUG.WRITE_LOG(
775: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
776: x_Msg => 'min_availability=' || PA_SEARCH_GLOB.g_search_criteria.min_availability,
777: x_Log_Level => 6);
778: End if;
779:

Line 785: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.call_pvt',x_Msg => 'calling PA_SEARCH_PVT.Run_Search', x_Log_Level => 6);

781:
782: -- Call Private API
783:
784: IF (P_DEBUG_MODE ='Y') THEN
785: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.call_pvt',x_Msg => 'calling PA_SEARCH_PVT.Run_Search', x_Log_Level => 6);
786: End If;
787:
788: PA_SEARCH_PVT.Run_Search(
789: p_search_mode => p_search_mode

Line 843: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_SEARCH_PUB.Run_Search'

839:
840: IF p_commit = FND_API.G_TRUE THEN
841: ROLLBACK TO SEARCH_PUB_RUN_OA_SEARCH;
842: END IF;
843: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_SEARCH_PUB.Run_Search'
844: , p_procedure_name => PA_DEBUG.G_Err_Stack);
845: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
846: RAISE;
847:

Line 850: END PA_SEARCH_PUB;

846: RAISE;
847:
848: END Run_Search;
849:
850: END PA_SEARCH_PUB;