180: BEGIN
181: --hr_utility.trace_on(NULL, 'RMPA');
182: --hr_utility.trace('BEGINNING');
183:
184: P_DEBUG_MODE := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
185: IF (P_DEBUG_MODE ='Y') THEN
186: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_SEARCH_PVT.Run_Search.begin',
187: x_Msg => 'in PA_SEARCH_PVT.Run_Search',
188: x_Log_Level => 6);
661: AND asgn.assignment_id = aor.assignment_id;
662:
663: END IF;
664:
665: P_DEBUG_MODE := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
666: IF (P_DEBUG_MODE ='Y') THEN
667: PA_DEBUG.WRITE_LOG(
668: x_Module =>'pa.plsql.PA_SEARCH_PVT.Run_Search.fetch_values',
669: x_Msg =>'if this is a Requirement Search then fetch the values from the cursor',