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_PVT dependencies on FND_FILE

Line 1563: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');

1559:
1560: BEGIN
1561:
1562: IF p_debug_mode = 'Y' THEN
1563: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1564: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1565: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1566: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);

Line 1564: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);

1560: BEGIN
1561:
1562: IF p_debug_mode = 'Y' THEN
1563: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1564: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1565: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1566: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);

Line 1565: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);

1561:
1562: IF p_debug_mode = 'Y' THEN
1563: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1564: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1565: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1566: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1569: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);

Line 1566: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);

1562: IF p_debug_mode = 'Y' THEN
1563: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1564: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1565: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1566: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1569: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1570: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);

Line 1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);

1563: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1564: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1565: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1566: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1569: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1570: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1571: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);

Line 1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);

1564: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1565: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1566: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1569: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1570: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1571: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1572: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');

Line 1569: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);

1565: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1566: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1569: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1570: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1571: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1572: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');
1573: END IF;

Line 1570: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);

1566: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1569: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1570: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1571: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1572: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');
1573: END IF;
1574:

Line 1571: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);

1567: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1569: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1570: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1571: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1572: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');
1573: END IF;
1574:
1575: OPEN get_auto_search_criteria;

Line 1572: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');

1568: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1569: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1570: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1571: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1572: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');
1573: END IF;
1574:
1575: OPEN get_auto_search_criteria;
1576:

Line 1578: fnd_file.put_line(FND_FILE.LOG,'Cursor has been opened');

1574:
1575: OPEN get_auto_search_criteria;
1576:
1577: IF p_debug_mode = 'Y' THEN
1578: fnd_file.put_line(FND_FILE.LOG,'Cursor has been opened');
1579: END IF;
1580:
1581: LOOP
1582:

Line 1584: fnd_file.put_line(FND_FILE.LOG,' ');

1580:
1581: LOOP
1582:
1583: IF p_debug_mode = 'Y' THEN
1584: fnd_file.put_line(FND_FILE.LOG,' ');
1585: fnd_file.put_line(FND_FILE.LOG,'Looping through requirements');
1586: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1587: END IF;
1588:

Line 1585: fnd_file.put_line(FND_FILE.LOG,'Looping through requirements');

1581: LOOP
1582:
1583: IF p_debug_mode = 'Y' THEN
1584: fnd_file.put_line(FND_FILE.LOG,' ');
1585: fnd_file.put_line(FND_FILE.LOG,'Looping through requirements');
1586: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1587: END IF;
1588:
1589: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,

Line 1586: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');

1582:
1583: IF p_debug_mode = 'Y' THEN
1584: fnd_file.put_line(FND_FILE.LOG,' ');
1585: fnd_file.put_line(FND_FILE.LOG,'Looping through requirements');
1586: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1587: END IF;
1588:
1589: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1590: PA_SEARCH_GLOB.g_search_criteria.project_id,

Line 1610: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');

1606:
1607: EXIT WHEN get_auto_search_criteria%NOTFOUND;
1608:
1609: IF p_debug_mode = 'Y' THEN
1610: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);

Line 1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');

1607: EXIT WHEN get_auto_search_criteria%NOTFOUND;
1608:
1609: IF p_debug_mode = 'Y' THEN
1610: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);

Line 1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);

1608:
1609: IF p_debug_mode = 'Y' THEN
1610: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);

Line 1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);

1609: IF p_debug_mode = 'Y' THEN
1610: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);

Line 1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);

1610: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);

Line 1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);

1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);

Line 1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);

1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);

Line 1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);

1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);

Line 1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);

1614: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);

Line 1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);

1615: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);

Line 1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);

1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);

Line 1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);

1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1625: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);

Line 1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);

1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1625: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);

Line 1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);

1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1625: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);

Line 1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);

1620: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1625: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');

Line 1625: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);

1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1625: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1629: END IF;

Line 1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);

1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1625: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1629: END IF;
1630:

Line 1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);

1623: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1625: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1629: END IF;
1630:
1631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';

Line 1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');

1624: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1625: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1629: END IF;
1630:
1631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';

Line 1644: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');

1640:
1641: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
1642: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN
1643: IF p_debug_mode = 'Y' THEN
1644: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');
1645: END IF;
1646:
1647: ELSE -- Only Process non-end-dated assignments
1648:

Line 1663: fnd_file.put_line(FND_FILE.LOG,'after call to get_competencies');

1659:
1660:
1661:
1662: IF p_debug_mode = 'Y' THEN
1663: fnd_file.put_line(FND_FILE.LOG,'after call to get_competencies');
1664: fnd_file.put_line(FND_FILE.LOG,'requirement has '||l_competency_tbl.COUNT||' competencies');
1665: END IF;
1666:
1667: IF l_competency_tbl.COUNT > 0 THEN

Line 1664: fnd_file.put_line(FND_FILE.LOG,'requirement has '||l_competency_tbl.COUNT||' competencies');

1660:
1661:
1662: IF p_debug_mode = 'Y' THEN
1663: fnd_file.put_line(FND_FILE.LOG,'after call to get_competencies');
1664: fnd_file.put_line(FND_FILE.LOG,'requirement has '||l_competency_tbl.COUNT||' competencies');
1665: END IF;
1666:
1667: IF l_competency_tbl.COUNT > 0 THEN
1668:

Line 1670: fnd_file.put_line(FND_FILE.LOG,'about to loop through competencies');

1666:
1667: IF l_competency_tbl.COUNT > 0 THEN
1668:
1669: IF p_debug_mode = 'Y' THEN
1670: fnd_file.put_line(FND_FILE.LOG,'about to loop through competencies');
1671: END IF;
1672:
1673: --store the competences in the global comp table.
1674: FOR i IN l_competency_tbl.FIRST..l_competency_tbl.LAST LOOP

Line 1677: fnd_file.put_line(FND_FILE.LOG,'in competencies loop');

1673: --store the competences in the global comp table.
1674: FOR i IN l_competency_tbl.FIRST..l_competency_tbl.LAST LOOP
1675:
1676: IF p_debug_mode = 'Y' THEN
1677: fnd_file.put_line(FND_FILE.LOG,'in competencies loop');
1678: END IF;
1679:
1680: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1681: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;

Line 1690: fnd_file.put_line(FND_FILE.LOG,'about to get the rating level');

1686: --and store in global comp table.
1687: IF l_competency_tbl(i).rating_level_id IS NOT NULL THEN
1688:
1689: IF p_debug_mode = 'Y' THEN
1690: fnd_file.put_line(FND_FILE.LOG,'about to get the rating level');
1691: END IF;
1692:
1693: SELECT step_value INTO PA_SEARCH_GLOB.g_competence_criteria(i).rating_level
1694: FROM per_rating_levels

Line 1698: fnd_file.put_line(FND_FILE.LOG,'got the rating level');

1694: FROM per_rating_levels
1695: WHERE rating_level_id = l_competency_tbl(i).rating_level_id;
1696:
1697: IF p_debug_mode = 'Y' THEN
1698: fnd_file.put_line(FND_FILE.LOG,'got the rating level');
1699: END IF;
1700: ELSE
1701: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level := NULL;
1702: END IF;

Line 1709: fnd_file.put_line(FND_FILE.LOG,'about to clear the global temp tables');

1705:
1706: END IF;
1707:
1708: IF p_debug_mode = 'Y' THEN
1709: fnd_file.put_line(FND_FILE.LOG,'about to clear the global temp tables');
1710: END IF;
1711:
1712: DELETE FROM pa_search_results_temp;
1713: DELETE FROM pa_competence_criteria_temp;

Line 1716: fnd_file.put_line(FND_FILE.LOG,'done clearing the global temp tables');

1712: DELETE FROM pa_search_results_temp;
1713: DELETE FROM pa_competence_criteria_temp;
1714:
1715: IF p_debug_mode = 'Y' THEN
1716: fnd_file.put_line(FND_FILE.LOG,'done clearing the global temp tables');
1717: fnd_file.put_line(FND_FILE.LOG,'about to call run search API');
1718: END IF;
1719:
1720: Run_Search(p_search_mode => 'RESOURCE',

Line 1717: fnd_file.put_line(FND_FILE.LOG,'about to call run search API');

1713: DELETE FROM pa_competence_criteria_temp;
1714:
1715: IF p_debug_mode = 'Y' THEN
1716: fnd_file.put_line(FND_FILE.LOG,'done clearing the global temp tables');
1717: fnd_file.put_line(FND_FILE.LOG,'about to call run search API');
1718: END IF;
1719:
1720: Run_Search(p_search_mode => 'RESOURCE',
1721: p_search_criteria => PA_SEARCH_GLOB.g_search_criteria,

Line 1728: fnd_file.put_line(FND_FILE.LOG,'done with run_search API');

1724: p_validate_only => FND_API.G_FALSE,
1725: x_return_status => l_return_status);
1726:
1727: IF p_debug_mode = 'Y' THEN
1728: fnd_file.put_line(FND_FILE.LOG,'done with run_search API');
1729: fnd_file.put_line(FND_FILE.LOG,'about to bulk collect resources matching search criteria');
1730: END IF;
1731:
1732: --bulk collect the resources to be nominated

Line 1729: fnd_file.put_line(FND_FILE.LOG,'about to bulk collect resources matching search criteria');

1725: x_return_status => l_return_status);
1726:
1727: IF p_debug_mode = 'Y' THEN
1728: fnd_file.put_line(FND_FILE.LOG,'done with run_search API');
1729: fnd_file.put_line(FND_FILE.LOG,'about to bulk collect resources matching search criteria');
1730: END IF;
1731:
1732: --bulk collect the resources to be nominated
1733: SELECT resource_id BULK COLLECT INTO l_resource_id_tbl

Line 1738: fnd_file.put_line(FND_FILE.LOG,'done with bulk collect');

1734: FROM pa_search_results_temp
1735: WHERE candidate_score >= l_min_candidate_score;
1736:
1737: IF p_debug_mode = 'Y' THEN
1738: fnd_file.put_line(FND_FILE.LOG,'done with bulk collect');
1739: fnd_file.put_line(FND_FILE.LOG,'number of resources returned = '||l_resource_id_tbl.COUNT);
1740: END IF;
1741:
1742: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN

Line 1739: fnd_file.put_line(FND_FILE.LOG,'number of resources returned = '||l_resource_id_tbl.COUNT);

1735: WHERE candidate_score >= l_min_candidate_score;
1736:
1737: IF p_debug_mode = 'Y' THEN
1738: fnd_file.put_line(FND_FILE.LOG,'done with bulk collect');
1739: fnd_file.put_line(FND_FILE.LOG,'number of resources returned = '||l_resource_id_tbl.COUNT);
1740: END IF;
1741:
1742: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN
1743:

Line 1745: fnd_file.put_line(FND_FILE.LOG,'auto search is enable for this requirement at the project and requirement level');

1741:
1742: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN
1743:
1744: IF p_debug_mode = 'Y' THEN
1745: fnd_file.put_line(FND_FILE.LOG,'auto search is enable for this requirement at the project and requirement level');
1746: END IF;
1747:
1748: --candidates will be nomimated in this run, so delete any
1749: --qualified candidates from the requirement.

Line 1751: fnd_file.put_line(FND_FILE.LOG,'about to call API to delete qualified candidates');

1747:
1748: --candidates will be nomimated in this run, so delete any
1749: --qualified candidates from the requirement.
1750: IF p_debug_mode = 'Y' THEN
1751: fnd_file.put_line(FND_FILE.LOG,'about to call API to delete qualified candidates');
1752: END IF;
1753:
1754: PA_CANDIDATE_PUB.Delete_Candidates
1755: (p_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,

Line 1762: fnd_file.put_line(FND_FILE.LOG,'done with call to API to delete qualified candidates');

1758: x_msg_count => l_msg_count,
1759: x_msg_data => l_msg_data);
1760:
1761: IF p_debug_mode = 'Y' THEN
1762: fnd_file.put_line(FND_FILE.LOG,'done with call to API to delete qualified candidates');
1763: END IF;
1764:
1765: l_cand_system_status_code := 'CANDIDATE_SYSTEM_NOMINATED';
1766:

Line 1777: fnd_file.put_line(FND_FILE.LOG,'about to bulk collect the previous system nominated / qualified candidates who will NOT be system nominated in current run.');

1773: --delete the previous system nominated candidates who will NOT
1774: --be system nominated in current run.
1775:
1776: IF p_debug_mode = 'Y' THEN
1777: fnd_file.put_line(FND_FILE.LOG,'about to bulk collect the previous system nominated / qualified candidates who will NOT be system nominated in current run.');
1778: END IF;
1779:
1780: SELECT candidate_id BULK COLLECT INTO l_candidate_id_tbl
1781: FROM pa_candidates cand,

Line 1794: fnd_file.put_line(FND_FILE.LOG,'number of previous system nominated candidates to be deleted = '||l_candidate_id_tbl.COUNT);

1790: WHERE candidate_score >= l_min_candidate_score)
1791: ;
1792:
1793: IF p_debug_mode = 'Y' THEN
1794: fnd_file.put_line(FND_FILE.LOG,'number of previous system nominated candidates to be deleted = '||l_candidate_id_tbl.COUNT);
1795: END IF;
1796:
1797: IF l_candidate_id_tbl.COUNT > 0 THEN
1798:

Line 1803: fnd_file.put_line(FND_FILE.LOG,'looping through candidates in order to delete');

1799: --** add code to LOOP THROUGH l_candidate_id_tbl AND CALL API TO DELETE CANDIDATES
1800: FOR i IN l_candidate_id_tbl.FIRST .. l_candidate_id_tbl.LAST LOOP
1801:
1802: IF p_debug_mode = 'Y' THEN
1803: fnd_file.put_line(FND_FILE.LOG,'looping through candidates in order to delete');
1804: fnd_file.put_line(FND_FILE.LOG,'calling withdraw_candidate API to delete candidate id '||l_candidate_id_tbl(i));
1805: END IF;
1806:
1807: PA_CANDIDATE_PUB.Withdraw_Candidate

Line 1804: fnd_file.put_line(FND_FILE.LOG,'calling withdraw_candidate API to delete candidate id '||l_candidate_id_tbl(i));

1800: FOR i IN l_candidate_id_tbl.FIRST .. l_candidate_id_tbl.LAST LOOP
1801:
1802: IF p_debug_mode = 'Y' THEN
1803: fnd_file.put_line(FND_FILE.LOG,'looping through candidates in order to delete');
1804: fnd_file.put_line(FND_FILE.LOG,'calling withdraw_candidate API to delete candidate id '||l_candidate_id_tbl(i));
1805: END IF;
1806:
1807: PA_CANDIDATE_PUB.Withdraw_Candidate
1808: (p_candidate_id => l_candidate_id_tbl(i),

Line 1814: fnd_file.put_line(FND_FILE.LOG,'after call to withdraw_candidate');

1810: x_msg_count => l_msg_count,
1811: x_msg_data => l_msg_data);
1812:
1813: IF p_debug_mode = 'Y' THEN
1814: fnd_file.put_line(FND_FILE.LOG,'after call to withdraw_candidate');
1815: END IF;
1816:
1817: END LOOP;
1818:

Line 1823: fnd_file.put_line(FND_FILE.LOG,'about to nominate candidates or qualified candidates');

1819: END IF;
1820:
1821:
1822: IF p_debug_mode = 'Y' THEN
1823: fnd_file.put_line(FND_FILE.LOG,'about to nominate candidates or qualified candidates');
1824: END IF;
1825:
1826:
1827: IF l_resource_id_tbl.COUNT > 0 THEN

Line 1830: fnd_file.put_line(FND_FILE.LOG,'there are candidates or qualified candidates to be nominated');

1826:
1827: IF l_resource_id_tbl.COUNT > 0 THEN
1828:
1829: IF p_debug_mode = 'Y' THEN
1830: fnd_file.put_line(FND_FILE.LOG,'there are candidates or qualified candidates to be nominated');
1831: END IF;
1832:
1833: FOR i IN l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST LOOP
1834:

Line 1836: fnd_file.put_line(FND_FILE.LOG,'in loop: resource_id to be nominated = '||l_resource_id_tbl(i));

1832:
1833: FOR i IN l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST LOOP
1834:
1835: IF p_debug_mode = 'Y' THEN
1836: fnd_file.put_line(FND_FILE.LOG,'in loop: resource_id to be nominated = '||l_resource_id_tbl(i));
1837: END IF;
1838:
1839: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN
1840:

Line 1842: fnd_file.put_line(FND_FILE.LOG,'auto search is enable for this requirement at the project and requirement level');

1838:
1839: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN
1840:
1841: IF p_debug_mode = 'Y' THEN
1842: fnd_file.put_line(FND_FILE.LOG,'auto search is enable for this requirement at the project and requirement level');
1843: END IF;
1844:
1845: IF l_system_nom_candidate_text IS NULL THEN
1846:

Line 1848: fnd_file.put_line(FND_FILE.LOG,'about to get system nominated candidate text');

1844:
1845: IF l_system_nom_candidate_text IS NULL THEN
1846:
1847: IF p_debug_mode = 'Y' THEN
1848: fnd_file.put_line(FND_FILE.LOG,'about to get system nominated candidate text');
1849: END IF;
1850: /* 2590651 - Added two conditions for application id and language code for the
1851: query from fnd_new_messages below */
1852:

Line 1860: fnd_file.put_line(FND_FILE.LOG,'got system nominated candidate text');

1856: and application_id = 275
1857: and language_code = userenv('LANG');
1858:
1859: IF p_debug_mode = 'Y' THEN
1860: fnd_file.put_line(FND_FILE.LOG,'got system nominated candidate text');
1861: END IF;
1862:
1863: END IF;
1864:

Line 1870: fnd_file.put_line(FND_FILE.LOG,'auto search is NOT enabled for this requirement - nominate as qualified canidate');

1866: l_status_code := '113';
1867:
1868: ELSE
1869: IF p_debug_mode = 'Y' THEN
1870: fnd_file.put_line(FND_FILE.LOG,'auto search is NOT enabled for this requirement - nominate as qualified canidate');
1871: END IF;
1872: l_nomination_comments := NULL;
1873: l_status_code := '114';
1874: END IF;

Line 1878: fnd_file.put_line(FND_FILE.LOG,'about to call Add_candidate API');

1874: END IF;
1875:
1876: --nominate the resource
1877: IF p_debug_mode = 'Y' THEN
1878: fnd_file.put_line(FND_FILE.LOG,'about to call Add_candidate API');
1879: fnd_file.put_line(FND_FILE.LOG,'nominate resource '||l_resource_id_tbl(i)||' for assignment '||PA_SEARCH_GLOB.g_search_criteria.assignment_id|| ' on project '||PA_SEARCH_GLOB.g_search_criteria.project_id);
1880: END IF;
1881:
1882: --add candidate API will

Line 1879: fnd_file.put_line(FND_FILE.LOG,'nominate resource '||l_resource_id_tbl(i)||' for assignment '||PA_SEARCH_GLOB.g_search_criteria.assignment_id|| ' on project '||PA_SEARCH_GLOB.g_search_criteria.project_id);

1875:
1876: --nominate the resource
1877: IF p_debug_mode = 'Y' THEN
1878: fnd_file.put_line(FND_FILE.LOG,'about to call Add_candidate API');
1879: fnd_file.put_line(FND_FILE.LOG,'nominate resource '||l_resource_id_tbl(i)||' for assignment '||PA_SEARCH_GLOB.g_search_criteria.assignment_id|| ' on project '||PA_SEARCH_GLOB.g_search_criteria.project_id);
1880: END IF;
1881:
1882: --add candidate API will
1883: --when I nominate as candidate:

Line 1920: fnd_file.put_line(FND_FILE.LOG,'after call to Add_candidate API');

1916: x_msg_count => l_msg_count,
1917: x_msg_data => l_msg_data);
1918:
1919: IF p_debug_mode = 'Y' THEN
1920: fnd_file.put_line(FND_FILE.LOG,'after call to Add_candidate API');
1921: fnd_file.put_line(FND_FILE.LOG,'x_return_status = '||l_return_status);
1922: END IF;
1923:
1924: l_candidates_nom_in_cycle := l_candidates_nom_in_cycle + 1;

Line 1921: fnd_file.put_line(FND_FILE.LOG,'x_return_status = '||l_return_status);

1917: x_msg_data => l_msg_data);
1918:
1919: IF p_debug_mode = 'Y' THEN
1920: fnd_file.put_line(FND_FILE.LOG,'after call to Add_candidate API');
1921: fnd_file.put_line(FND_FILE.LOG,'x_return_status = '||l_return_status);
1922: END IF;
1923:
1924: l_candidates_nom_in_cycle := l_candidates_nom_in_cycle + 1;
1925:

Line 1927: fnd_file.put_line(FND_FILE.LOG,'candidates/qualified candidates nominated in this cycle = '||l_candidates_nom_in_cycle);

1923:
1924: l_candidates_nom_in_cycle := l_candidates_nom_in_cycle + 1;
1925:
1926: IF p_debug_mode = 'Y' THEN
1927: fnd_file.put_line(FND_FILE.LOG,'candidates/qualified candidates nominated in this cycle = '||l_candidates_nom_in_cycle);
1928: END IF;
1929:
1930: END LOOP;
1931:

Line 1935: fnd_file.put_line(FND_FILE.LOG,'about to update last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);

1931:
1932: END IF;
1933:
1934: IF p_debug_mode = 'Y' THEN
1935: fnd_file.put_line(FND_FILE.LOG,'about to update last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1936: END IF;
1937:
1938: --stamp the date/time on the run on the requirement record
1939: UPDATE PA_PROJECT_ASSIGNMENTS

Line 1944: fnd_file.put_line(FND_FILE.LOG,'after updating last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);

1940: SET last_auto_search_date = SYSDATE
1941: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id;
1942:
1943: IF p_debug_mode = 'Y' THEN
1944: fnd_file.put_line(FND_FILE.LOG,'after updating last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1945: END IF;
1946:
1947: IF l_candidates_nom_in_cycle > 100 THEN
1948:

Line 1950: fnd_file.put_line(FND_FILE.LOG,'about to COMMIT');

1946:
1947: IF l_candidates_nom_in_cycle > 100 THEN
1948:
1949: IF p_debug_mode = 'Y' THEN
1950: fnd_file.put_line(FND_FILE.LOG,'about to COMMIT');
1951: END IF;
1952:
1953: COMMIT;
1954:

Line 1956: fnd_file.put_line(FND_FILE.LOG,'COMMIT complete');

1952:
1953: COMMIT;
1954:
1955: IF p_debug_mode = 'Y' THEN
1956: fnd_file.put_line(FND_FILE.LOG,'COMMIT complete');
1957: END IF;
1958:
1959: l_candidates_nom_in_cycle := 0;
1960:

Line 1969: fnd_file.put_line(FND_FILE.LOG,'about to COMMIT');

1965:
1966: CLOSE get_auto_search_criteria;
1967:
1968: IF p_debug_mode = 'Y' THEN
1969: fnd_file.put_line(FND_FILE.LOG,'about to COMMIT');
1970: END IF;
1971:
1972: COMMIT;
1973:

Line 1975: fnd_file.put_line(FND_FILE.LOG,'COMMIT complete');

1971:
1972: COMMIT;
1973:
1974: IF p_debug_mode = 'Y' THEN
1975: fnd_file.put_line(FND_FILE.LOG,'COMMIT complete');
1976: END IF;
1977:
1978: retcode := '0';
1979:

Line 1984: fnd_file.put_line(FND_FILE.LOG,'in when others exception block');

1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: errbuf := SUBSTR(SQLERRM,1,240);
1983: retcode := '2';
1984: fnd_file.put_line(FND_FILE.LOG,'in when others exception block');
1985: fnd_file.put_line(FND_FILE.LOG,SUBSTR(SQLERRM,1,240));
1986:
1987: END Run_Auto_Search;
1988:

Line 1985: fnd_file.put_line(FND_FILE.LOG,SUBSTR(SQLERRM,1,240));

1981: WHEN OTHERS THEN
1982: errbuf := SUBSTR(SQLERRM,1,240);
1983: retcode := '2';
1984: fnd_file.put_line(FND_FILE.LOG,'in when others exception block');
1985: fnd_file.put_line(FND_FILE.LOG,SUBSTR(SQLERRM,1,240));
1986:
1987: END Run_Auto_Search;
1988:
1989: