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 1512: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');

1508:
1509: BEGIN
1510:
1511: IF p_debug_mode = 'Y' THEN
1512: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1513: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1514: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1515: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1516: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);

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

1509: BEGIN
1510:
1511: IF p_debug_mode = 'Y' THEN
1512: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1513: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1514: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1515: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1516: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1517: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);

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

1510:
1511: IF p_debug_mode = 'Y' THEN
1512: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1513: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1514: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1515: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1516: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1517: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1518: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);

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

1511: IF p_debug_mode = 'Y' THEN
1512: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1513: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1514: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1515: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1516: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1517: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1518: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1519: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);

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

1512: fnd_file.put_line(FND_FILE.LOG,'Parameters are:');
1513: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1514: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1515: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1516: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1517: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1518: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1519: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1520: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);

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

1513: fnd_file.put_line(FND_FILE.LOG,'p_auto_search_mode = '||p_auto_search_mode);
1514: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1515: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1516: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1517: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1518: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1519: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1520: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1521: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');

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

1514: fnd_file.put_line(FND_FILE.LOG,'p_project_id = '||p_project_id);
1515: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1516: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1517: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1518: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1519: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1520: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1521: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');
1522: END IF;

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

1515: fnd_file.put_line(FND_FILE.LOG,'p_project_number_from = '||p_project_number_from);
1516: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1517: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1518: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1519: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1520: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1521: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');
1522: END IF;
1523:

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

1516: fnd_file.put_line(FND_FILE.LOG,'p_project_number_to = '||p_project_number_to);
1517: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1518: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1519: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1520: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1521: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');
1522: END IF;
1523:
1524: OPEN get_auto_search_criteria;

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

1517: fnd_file.put_line(FND_FILE.LOG,'p_proj_start_date_days = '||p_proj_start_date_days);
1518: fnd_file.put_line(FND_FILE.LOG,'p_req_start_date_days = '||p_req_start_date_days);
1519: fnd_file.put_line(FND_FILE.LOG,'p_project_status_code = '||p_project_status_code);
1520: fnd_file.put_line(FND_FILE.LOG,'p_debug_mode = '||p_debug_mode);
1521: fnd_file.put_line(FND_FILE.LOG,'about to open get_auto_search_criteria cursor');
1522: END IF;
1523:
1524: OPEN get_auto_search_criteria;
1525:

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

1523:
1524: OPEN get_auto_search_criteria;
1525:
1526: IF p_debug_mode = 'Y' THEN
1527: fnd_file.put_line(FND_FILE.LOG,'Cursor has been opened');
1528: END IF;
1529:
1530: LOOP
1531:

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

1529:
1530: LOOP
1531:
1532: IF p_debug_mode = 'Y' THEN
1533: fnd_file.put_line(FND_FILE.LOG,' ');
1534: fnd_file.put_line(FND_FILE.LOG,'Looping through requirements');
1535: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1536: END IF;
1537:

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

1530: LOOP
1531:
1532: IF p_debug_mode = 'Y' THEN
1533: fnd_file.put_line(FND_FILE.LOG,' ');
1534: fnd_file.put_line(FND_FILE.LOG,'Looping through requirements');
1535: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1536: END IF;
1537:
1538: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,

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

1531:
1532: IF p_debug_mode = 'Y' THEN
1533: fnd_file.put_line(FND_FILE.LOG,' ');
1534: fnd_file.put_line(FND_FILE.LOG,'Looping through requirements');
1535: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1536: END IF;
1537:
1538: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1539: PA_SEARCH_GLOB.g_search_criteria.project_id,

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

1555:
1556: EXIT WHEN get_auto_search_criteria%NOTFOUND;
1557:
1558: IF p_debug_mode = 'Y' THEN
1559: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: 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 1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');

1556: EXIT WHEN get_auto_search_criteria%NOTFOUND;
1557:
1558: IF p_debug_mode = 'Y' THEN
1559: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: 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);
1564: 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 1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);

1557:
1558: IF p_debug_mode = 'Y' THEN
1559: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: 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);
1564: 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);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);

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

1558: IF p_debug_mode = 'Y' THEN
1559: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: 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);
1564: 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);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);

Line 1563: 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);

1559: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: 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);
1564: 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);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);

Line 1564: 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);

1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: 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);
1564: 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);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);

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

1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: 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);
1564: 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);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: 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 1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);

1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: 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);
1564: 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);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: 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);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);

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

1563: 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);
1564: 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);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: 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);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);

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

1564: 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);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: 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);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: 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 1569: 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);

1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: 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);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: 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);
1573: 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 1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);

1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: 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);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: 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);
1573: 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);
1574: 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 1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);

1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: 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);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: 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);
1573: 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);
1574: 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);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);

Line 1572: 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);

1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: 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);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: 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);
1573: 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);
1574: 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);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);

Line 1573: 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);

1569: 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);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: 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);
1573: 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);
1574: 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);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1577: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');

Line 1574: 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);

1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: 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);
1573: 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);
1574: 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);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1577: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1578: END IF;

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

1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: 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);
1573: 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);
1574: 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);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1577: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1578: END IF;
1579:

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

1572: 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);
1573: 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);
1574: 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);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1577: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1578: END IF;
1579:
1580: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';

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

1573: 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);
1574: 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);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1577: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1578: END IF;
1579:
1580: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1581: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';

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

1589:
1590: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
1591: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN
1592: IF p_debug_mode = 'Y' THEN
1593: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');
1594: END IF;
1595:
1596: ELSE -- Only Process non-end-dated assignments
1597:

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

1608:
1609:
1610:
1611: IF p_debug_mode = 'Y' THEN
1612: fnd_file.put_line(FND_FILE.LOG,'after call to get_competencies');
1613: fnd_file.put_line(FND_FILE.LOG,'requirement has '||l_competency_tbl.COUNT||' competencies');
1614: END IF;
1615:
1616: IF l_competency_tbl.COUNT > 0 THEN

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

1609:
1610:
1611: IF p_debug_mode = 'Y' THEN
1612: fnd_file.put_line(FND_FILE.LOG,'after call to get_competencies');
1613: fnd_file.put_line(FND_FILE.LOG,'requirement has '||l_competency_tbl.COUNT||' competencies');
1614: END IF;
1615:
1616: IF l_competency_tbl.COUNT > 0 THEN
1617:

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

1615:
1616: IF l_competency_tbl.COUNT > 0 THEN
1617:
1618: IF p_debug_mode = 'Y' THEN
1619: fnd_file.put_line(FND_FILE.LOG,'about to loop through competencies');
1620: END IF;
1621:
1622: --store the competences in the global comp table.
1623: FOR i IN l_competency_tbl.FIRST..l_competency_tbl.LAST LOOP

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

1622: --store the competences in the global comp table.
1623: FOR i IN l_competency_tbl.FIRST..l_competency_tbl.LAST LOOP
1624:
1625: IF p_debug_mode = 'Y' THEN
1626: fnd_file.put_line(FND_FILE.LOG,'in competencies loop');
1627: END IF;
1628:
1629: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1630: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;

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

1635: --and store in global comp table.
1636: IF l_competency_tbl(i).rating_level_id IS NOT NULL THEN
1637:
1638: IF p_debug_mode = 'Y' THEN
1639: fnd_file.put_line(FND_FILE.LOG,'about to get the rating level');
1640: END IF;
1641:
1642: SELECT step_value INTO PA_SEARCH_GLOB.g_competence_criteria(i).rating_level
1643: FROM per_rating_levels

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

1643: FROM per_rating_levels
1644: WHERE rating_level_id = l_competency_tbl(i).rating_level_id;
1645:
1646: IF p_debug_mode = 'Y' THEN
1647: fnd_file.put_line(FND_FILE.LOG,'got the rating level');
1648: END IF;
1649: ELSE
1650: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level := NULL;
1651: END IF;

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

1654:
1655: END IF;
1656:
1657: IF p_debug_mode = 'Y' THEN
1658: fnd_file.put_line(FND_FILE.LOG,'about to clear the global temp tables');
1659: END IF;
1660:
1661: DELETE FROM pa_search_results_temp;
1662: DELETE FROM pa_competence_criteria_temp;

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

1661: DELETE FROM pa_search_results_temp;
1662: DELETE FROM pa_competence_criteria_temp;
1663:
1664: IF p_debug_mode = 'Y' THEN
1665: fnd_file.put_line(FND_FILE.LOG,'done clearing the global temp tables');
1666: fnd_file.put_line(FND_FILE.LOG,'about to call run search API');
1667: END IF;
1668:
1669: Run_Search(p_search_mode => 'RESOURCE',

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

1662: DELETE FROM pa_competence_criteria_temp;
1663:
1664: IF p_debug_mode = 'Y' THEN
1665: fnd_file.put_line(FND_FILE.LOG,'done clearing the global temp tables');
1666: fnd_file.put_line(FND_FILE.LOG,'about to call run search API');
1667: END IF;
1668:
1669: Run_Search(p_search_mode => 'RESOURCE',
1670: p_search_criteria => PA_SEARCH_GLOB.g_search_criteria,

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

1673: p_validate_only => FND_API.G_FALSE,
1674: x_return_status => l_return_status);
1675:
1676: IF p_debug_mode = 'Y' THEN
1677: fnd_file.put_line(FND_FILE.LOG,'done with run_search API');
1678: fnd_file.put_line(FND_FILE.LOG,'about to bulk collect resources matching search criteria');
1679: END IF;
1680:
1681: --bulk collect the resources to be nominated

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

1674: x_return_status => l_return_status);
1675:
1676: IF p_debug_mode = 'Y' THEN
1677: fnd_file.put_line(FND_FILE.LOG,'done with run_search API');
1678: fnd_file.put_line(FND_FILE.LOG,'about to bulk collect resources matching search criteria');
1679: END IF;
1680:
1681: --bulk collect the resources to be nominated
1682: SELECT resource_id BULK COLLECT INTO l_resource_id_tbl

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

1683: FROM pa_search_results_temp
1684: WHERE candidate_score >= l_min_candidate_score;
1685:
1686: IF p_debug_mode = 'Y' THEN
1687: fnd_file.put_line(FND_FILE.LOG,'done with bulk collect');
1688: fnd_file.put_line(FND_FILE.LOG,'number of resources returned = '||l_resource_id_tbl.COUNT);
1689: END IF;
1690:
1691: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN

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

1684: WHERE candidate_score >= l_min_candidate_score;
1685:
1686: IF p_debug_mode = 'Y' THEN
1687: fnd_file.put_line(FND_FILE.LOG,'done with bulk collect');
1688: fnd_file.put_line(FND_FILE.LOG,'number of resources returned = '||l_resource_id_tbl.COUNT);
1689: END IF;
1690:
1691: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN
1692:

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

1690:
1691: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN
1692:
1693: IF p_debug_mode = 'Y' THEN
1694: fnd_file.put_line(FND_FILE.LOG,'auto search is enable for this requirement at the project and requirement level');
1695: END IF;
1696:
1697: --candidates will be nomimated in this run, so delete any
1698: --qualified candidates from the requirement.

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

1696:
1697: --candidates will be nomimated in this run, so delete any
1698: --qualified candidates from the requirement.
1699: IF p_debug_mode = 'Y' THEN
1700: fnd_file.put_line(FND_FILE.LOG,'about to call API to delete qualified candidates');
1701: END IF;
1702:
1703: PA_CANDIDATE_PUB.Delete_Candidates
1704: (p_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,

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

1707: x_msg_count => l_msg_count,
1708: x_msg_data => l_msg_data);
1709:
1710: IF p_debug_mode = 'Y' THEN
1711: fnd_file.put_line(FND_FILE.LOG,'done with call to API to delete qualified candidates');
1712: END IF;
1713:
1714: l_cand_system_status_code := 'CANDIDATE_SYSTEM_NOMINATED';
1715:

Line 1726: 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.');

1722: --delete the previous system nominated candidates who will NOT
1723: --be system nominated in current run.
1724:
1725: IF p_debug_mode = 'Y' THEN
1726: 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.');
1727: END IF;
1728:
1729: SELECT candidate_id BULK COLLECT INTO l_candidate_id_tbl
1730: FROM pa_candidates cand,

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

1739: WHERE candidate_score >= l_min_candidate_score)
1740: ;
1741:
1742: IF p_debug_mode = 'Y' THEN
1743: fnd_file.put_line(FND_FILE.LOG,'number of previous system nominated candidates to be deleted = '||l_candidate_id_tbl.COUNT);
1744: END IF;
1745:
1746: IF l_candidate_id_tbl.COUNT > 0 THEN
1747:

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

1748: --** add code to LOOP THROUGH l_candidate_id_tbl AND CALL API TO DELETE CANDIDATES
1749: FOR i IN l_candidate_id_tbl.FIRST .. l_candidate_id_tbl.LAST LOOP
1750:
1751: IF p_debug_mode = 'Y' THEN
1752: fnd_file.put_line(FND_FILE.LOG,'looping through candidates in order to delete');
1753: fnd_file.put_line(FND_FILE.LOG,'calling withdraw_candidate API to delete candidate id '||l_candidate_id_tbl(i));
1754: END IF;
1755:
1756: PA_CANDIDATE_PUB.Withdraw_Candidate

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

1749: FOR i IN l_candidate_id_tbl.FIRST .. l_candidate_id_tbl.LAST LOOP
1750:
1751: IF p_debug_mode = 'Y' THEN
1752: fnd_file.put_line(FND_FILE.LOG,'looping through candidates in order to delete');
1753: fnd_file.put_line(FND_FILE.LOG,'calling withdraw_candidate API to delete candidate id '||l_candidate_id_tbl(i));
1754: END IF;
1755:
1756: PA_CANDIDATE_PUB.Withdraw_Candidate
1757: (p_candidate_id => l_candidate_id_tbl(i),

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

1759: x_msg_count => l_msg_count,
1760: x_msg_data => l_msg_data);
1761:
1762: IF p_debug_mode = 'Y' THEN
1763: fnd_file.put_line(FND_FILE.LOG,'after call to withdraw_candidate');
1764: END IF;
1765:
1766: END LOOP;
1767:

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

1768: END IF;
1769:
1770:
1771: IF p_debug_mode = 'Y' THEN
1772: fnd_file.put_line(FND_FILE.LOG,'about to nominate candidates or qualified candidates');
1773: END IF;
1774:
1775:
1776: IF l_resource_id_tbl.COUNT > 0 THEN

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

1775:
1776: IF l_resource_id_tbl.COUNT > 0 THEN
1777:
1778: IF p_debug_mode = 'Y' THEN
1779: fnd_file.put_line(FND_FILE.LOG,'there are candidates or qualified candidates to be nominated');
1780: END IF;
1781:
1782: FOR i IN l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST LOOP
1783:

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

1781:
1782: FOR i IN l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST LOOP
1783:
1784: IF p_debug_mode = 'Y' THEN
1785: fnd_file.put_line(FND_FILE.LOG,'in loop: resource_id to be nominated = '||l_resource_id_tbl(i));
1786: END IF;
1787:
1788: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN
1789:

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

1787:
1788: IF (l_proj_enable_automated_search = 'Y' AND l_req_enable_auto_cand_nom = 'Y') THEN
1789:
1790: IF p_debug_mode = 'Y' THEN
1791: fnd_file.put_line(FND_FILE.LOG,'auto search is enable for this requirement at the project and requirement level');
1792: END IF;
1793:
1794: IF l_system_nom_candidate_text IS NULL THEN
1795:

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

1793:
1794: IF l_system_nom_candidate_text IS NULL THEN
1795:
1796: IF p_debug_mode = 'Y' THEN
1797: fnd_file.put_line(FND_FILE.LOG,'about to get system nominated candidate text');
1798: END IF;
1799: /* 2590651 - Added two conditions for application id and language code for the
1800: query from fnd_new_messages below */
1801:

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

1805: and application_id = 275
1806: and language_code = userenv('LANG');
1807:
1808: IF p_debug_mode = 'Y' THEN
1809: fnd_file.put_line(FND_FILE.LOG,'got system nominated candidate text');
1810: END IF;
1811:
1812: END IF;
1813:

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

1815: l_status_code := '113';
1816:
1817: ELSE
1818: IF p_debug_mode = 'Y' THEN
1819: fnd_file.put_line(FND_FILE.LOG,'auto search is NOT enabled for this requirement - nominate as qualified canidate');
1820: END IF;
1821: l_nomination_comments := NULL;
1822: l_status_code := '114';
1823: END IF;

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

1823: END IF;
1824:
1825: --nominate the resource
1826: IF p_debug_mode = 'Y' THEN
1827: fnd_file.put_line(FND_FILE.LOG,'about to call Add_candidate API');
1828: 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);
1829: END IF;
1830:
1831: --add candidate API will

Line 1828: 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);

1824:
1825: --nominate the resource
1826: IF p_debug_mode = 'Y' THEN
1827: fnd_file.put_line(FND_FILE.LOG,'about to call Add_candidate API');
1828: 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);
1829: END IF;
1830:
1831: --add candidate API will
1832: --when I nominate as candidate:

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

1848: x_msg_count => l_msg_count,
1849: x_msg_data => l_msg_data);
1850:
1851: IF p_debug_mode = 'Y' THEN
1852: fnd_file.put_line(FND_FILE.LOG,'after call to Add_candidate API');
1853: fnd_file.put_line(FND_FILE.LOG,'x_return_status = '||l_return_status);
1854: END IF;
1855:
1856: l_candidates_nom_in_cycle := l_candidates_nom_in_cycle + 1;

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

1849: x_msg_data => l_msg_data);
1850:
1851: IF p_debug_mode = 'Y' THEN
1852: fnd_file.put_line(FND_FILE.LOG,'after call to Add_candidate API');
1853: fnd_file.put_line(FND_FILE.LOG,'x_return_status = '||l_return_status);
1854: END IF;
1855:
1856: l_candidates_nom_in_cycle := l_candidates_nom_in_cycle + 1;
1857:

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

1855:
1856: l_candidates_nom_in_cycle := l_candidates_nom_in_cycle + 1;
1857:
1858: IF p_debug_mode = 'Y' THEN
1859: fnd_file.put_line(FND_FILE.LOG,'candidates/qualified candidates nominated in this cycle = '||l_candidates_nom_in_cycle);
1860: END IF;
1861:
1862: END LOOP;
1863:

Line 1867: 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);

1863:
1864: END IF;
1865:
1866: IF p_debug_mode = 'Y' THEN
1867: 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);
1868: END IF;
1869:
1870: --stamp the date/time on the run on the requirement record
1871: UPDATE PA_PROJECT_ASSIGNMENTS

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

1872: SET last_auto_search_date = SYSDATE
1873: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id;
1874:
1875: IF p_debug_mode = 'Y' THEN
1876: fnd_file.put_line(FND_FILE.LOG,'after updating last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1877: END IF;
1878:
1879: IF l_candidates_nom_in_cycle > 100 THEN
1880:

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

1878:
1879: IF l_candidates_nom_in_cycle > 100 THEN
1880:
1881: IF p_debug_mode = 'Y' THEN
1882: fnd_file.put_line(FND_FILE.LOG,'about to COMMIT');
1883: END IF;
1884:
1885: COMMIT;
1886:

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

1884:
1885: COMMIT;
1886:
1887: IF p_debug_mode = 'Y' THEN
1888: fnd_file.put_line(FND_FILE.LOG,'COMMIT complete');
1889: END IF;
1890:
1891: l_candidates_nom_in_cycle := 0;
1892:

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

1897:
1898: CLOSE get_auto_search_criteria;
1899:
1900: IF p_debug_mode = 'Y' THEN
1901: fnd_file.put_line(FND_FILE.LOG,'about to COMMIT');
1902: END IF;
1903:
1904: COMMIT;
1905:

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

1903:
1904: COMMIT;
1905:
1906: IF p_debug_mode = 'Y' THEN
1907: fnd_file.put_line(FND_FILE.LOG,'COMMIT complete');
1908: END IF;
1909:
1910: retcode := '0';
1911:

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

1912: EXCEPTION
1913: WHEN OTHERS THEN
1914: errbuf := SUBSTR(SQLERRM,1,240);
1915: retcode := '2';
1916: fnd_file.put_line(FND_FILE.LOG,'in when others exception block');
1917: fnd_file.put_line(FND_FILE.LOG,SUBSTR(SQLERRM,1,240));
1918:
1919: END Run_Auto_Search;
1920:

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

1913: WHEN OTHERS THEN
1914: errbuf := SUBSTR(SQLERRM,1,240);
1915: retcode := '2';
1916: fnd_file.put_line(FND_FILE.LOG,'in when others exception block');
1917: fnd_file.put_line(FND_FILE.LOG,SUBSTR(SQLERRM,1,240));
1918:
1919: END Run_Auto_Search;
1920:
1921: