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.CSF_RESOURCE_PUB dependencies on FND_LOG

Line 11: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);

7: g_pi CONSTANT NUMBER := 2 * ACOS(0);
8: g_res_add_prof VARCHAR2(200);
9: g_debug VARCHAR2(1):= NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
10:
11: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
12:
13:
14: TYPE qualifier_info_rec_type IS RECORD(
15: qual_usg_id jtf_seeded_qual_usgs_v.qual_usg_id%TYPE

Line 64: fnd_log.string(p_level, 'csf.plsql.CSF_RESOURCE_PUB.' || p_module, p_message);

60:
61: PROCEDURE debug(p_level NUMBER, p_module VARCHAR2, p_message VARCHAR2) IS
62: BEGIN
63: IF g_debug = 'Y' AND p_level >= g_debug_level THEN
64: fnd_log.string(p_level, 'csf.plsql.CSF_RESOURCE_PUB.' || p_module, p_message);
65: END IF;
66: END debug;
67:
68: /**

Line 1318: debug( fnd_log.level_statement, l_api_name, 'Get Resources To Schedule API Started');

1314:
1315:
1316: BEGIN
1317:
1318: debug( fnd_log.level_statement, l_api_name, 'Get Resources To Schedule API Started');
1319:
1320: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1321: RAISE fnd_api.g_exc_unexpected_error;
1322: END IF;

Line 1335: debug( fnd_log.level_statement, l_api_name, ' Task ID:' || p_task_id

1331: csf_util_pvt.add_timer(105, 'Get resources to schedule (init)', 0, NULL);
1332: END IF;
1333:
1334:
1335: debug( fnd_log.level_statement, l_api_name, ' Task ID:' || p_task_id
1336: || ' Incident Id:' || p_incident_id
1337: || ' Scheduling Mode:' || p_scheduling_mode
1338: || ' Start Date:' || to_char(p_start, 'DD-MON-YYYY HH24:MI:SS')
1339: || ' End Date:' || to_char(p_end , 'DD-MON-YYYY HH24:MI:SS')

Line 1362: debug( fnd_log.level_statement, l_api_name, 'No Resource Selection Criteria is specified');

1358: AND l_territory_flag = 'N'
1359: AND l_skills_flag = 'N'
1360: AND NOT l_has_suggested_res
1361: THEN
1362: debug( fnd_log.level_statement, l_api_name, 'No Resource Selection Criteria is specified');
1363: RAISE e_no_res;
1364: END IF;
1365:
1366: -- start with an empty list

Line 1371: debug( fnd_log.level_statement, l_api_name, 'Resource Selection is based on Skills..finding out the skills');

1367: x_res_tbl.DELETE;
1368:
1369: -- Find out whether the Task has any Required Skills Attached.
1370: IF l_skills_flag = 'Y' THEN
1371: debug( fnd_log.level_statement, l_api_name, 'Resource Selection is based on Skills..finding out the skills');
1372: OPEN c_task_skills;
1373: FETCH c_task_skills INTO l_task_has_skill_id;
1374: CLOSE c_task_skills;
1375:

Line 1376: debug( fnd_log.level_statement, l_api_name, 'The Skill ID:' || l_task_has_skill_id);

1372: OPEN c_task_skills;
1373: FETCH c_task_skills INTO l_task_has_skill_id;
1374: CLOSE c_task_skills;
1375:
1376: debug( fnd_log.level_statement, l_api_name, 'The Skill ID:' || l_task_has_skill_id);
1377: IF l_task_has_skill_id IS NULL THEN
1378: -- Task has no Skills attached. Turn off Skills Flag.
1379: debug( fnd_log.level_statement, l_api_name, 'Task has no skills attached..turning off Skills qualifiers');
1380: l_skills_flag := 'N';

Line 1379: debug( fnd_log.level_statement, l_api_name, 'Task has no skills attached..turning off Skills qualifiers');

1375:
1376: debug( fnd_log.level_statement, l_api_name, 'The Skill ID:' || l_task_has_skill_id);
1377: IF l_task_has_skill_id IS NULL THEN
1378: -- Task has no Skills attached. Turn off Skills Flag.
1379: debug( fnd_log.level_statement, l_api_name, 'Task has no skills attached..turning off Skills qualifiers');
1380: l_skills_flag := 'N';
1381: -- If none of the other Flags are set we have an error situation
1382: IF l_contracts_flag = 'N' AND l_ib_flag = 'N' AND l_territory_flag = 'N' AND NOT l_has_suggested_res THEN
1383: fnd_message.set_name('CSF', 'CSF_NO_TASK_SKILL_RES');

Line 1392: debug( fnd_log.level_statement, l_api_name, 'The input resource qualifier table count:'||p_res_qualifier_tbl.COUNT);

1388: END IF;
1389:
1390: -- Convert the given Task ID or the Qualifier Table to SR Task Record
1391: IF l_contracts_flag = 'Y' OR l_ib_flag = 'Y' OR l_territory_flag = 'Y' THEN
1392: debug( fnd_log.level_statement, l_api_name, 'The input resource qualifier table count:'||p_res_qualifier_tbl.COUNT);
1393: IF p_res_qualifier_tbl.COUNT > 0 THEN
1394: IF csf_util_pvt.g_timing_activated THEN
1395: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 0, NULL);
1396: END IF;

Line 1414: debug( fnd_log.level_statement, l_api_name, ' TASK_ID:' || l_sr_task_rec.task_id

1410: l_sr_task_rec.task_id := p_task_id;
1411: l_sr_task_rec.service_request_id := p_incident_id;
1412: END IF;
1413:
1414: debug( fnd_log.level_statement, l_api_name, ' TASK_ID:' || l_sr_task_rec.task_id
1415: || ' SERVICE_REQUEST_ID:' || l_sr_task_rec.SERVICE_REQUEST_ID
1416: || ' PARTY_ID:' || l_sr_task_rec.PARTY_ID
1417: || ' COUNTRY:' || l_sr_task_rec.COUNTRY
1418: || ' PARTY_SITE_ID:' || l_sr_task_rec.PARTY_SITE_ID

Line 1451: debug( fnd_log.level_statement, l_api_name, ' Enforce None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));

1447:
1448:
1449: IF csr_scheduler_pub.get_sch_parameter_value('spEnforcePlanWindow') = 'NONE' THEN
1450: l_end_date := p_end + NVL(csr_scheduler_pub.get_sch_parameter_value('spPlanScope'), 5)/5;
1451: debug( fnd_log.level_statement, l_api_name, ' Enforce None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
1452: ELSE
1453: l_end_date := p_end;
1454: debug( fnd_log.level_statement, l_api_name, ' Enforce is Not None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
1455: END IF;

Line 1454: debug( fnd_log.level_statement, l_api_name, ' Enforce is Not None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));

1450: l_end_date := p_end + NVL(csr_scheduler_pub.get_sch_parameter_value('spPlanScope'), 5)/5;
1451: debug( fnd_log.level_statement, l_api_name, ' Enforce None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
1452: ELSE
1453: l_end_date := p_end;
1454: debug( fnd_log.level_statement, l_api_name, ' Enforce is Not None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
1455: END IF;
1456:
1457: debug( fnd_log.level_statement, l_api_name, 'Resource Search Window Start:'||to_char(p_start, 'DD-MON-YYYY HH24:MI:SS')
1458: || 'Resource Search Window End:' ||to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS')

Line 1457: debug( fnd_log.level_statement, l_api_name, 'Resource Search Window Start:'||to_char(p_start, 'DD-MON-YYYY HH24:MI:SS')

1453: l_end_date := p_end;
1454: debug( fnd_log.level_statement, l_api_name, ' Enforce is Not None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
1455: END IF;
1456:
1457: debug( fnd_log.level_statement, l_api_name, 'Resource Search Window Start:'||to_char(p_start, 'DD-MON-YYYY HH24:MI:SS')
1458: || 'Resource Search Window End:' ||to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS')
1459: );
1460:
1461: -- Retrieve the Resources defined in Contracts / IB

Line 1474: debug( fnd_log.level_statement, l_api_name, 'The Business Process ID used for fetching Contracts Pref Resources:' || l_business_process_id);

1470: OPEN c_business_process;
1471: FETCH c_business_process INTO l_business_process_id;
1472: CLOSE c_business_process;
1473:
1474: debug( fnd_log.level_statement, l_api_name, 'The Business Process ID used for fetching Contracts Pref Resources:' || l_business_process_id);
1475:
1476: l_stic := l_stic + 1;
1477:
1478: END IF;

Line 1512: debug( fnd_log.level_statement, l_api_name, 'The Number of Resources found using Contracts/IB:' || l_contracts_ib_res_tbl.COUNT);

1508: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1509: RAISE fnd_api.g_exc_unexpected_error;
1510: END IF;
1511:
1512: debug( fnd_log.level_statement, l_api_name, 'The Number of Resources found using Contracts/IB:' || l_contracts_ib_res_tbl.COUNT);
1513:
1514: IF l_contracts_ib_res_tbl.COUNT = 0 THEN
1515: l_cont_ib_res_found := FALSE;
1516: END IF;

Line 1520: debug( fnd_log.level_statement, l_api_name, 'Obtained C/IB resource:' || l_contracts_ib_res_tbl(i).resource_id || l_contracts_ib_res_tbl(i).resource_type );

1516: END IF;
1517:
1518: FOR i in 1..l_contracts_ib_res_tbl.COUNT
1519: LOOP
1520: debug( fnd_log.level_statement, l_api_name, 'Obtained C/IB resource:' || l_contracts_ib_res_tbl(i).resource_id || l_contracts_ib_res_tbl(i).resource_type );
1521: debug( fnd_log.level_statement, l_api_name, 'Resource Start:'||to_char(l_contracts_ib_res_tbl(i).start_date, 'DD-MON-YYYY HH24:MI:SS')
1522: || 'Resource End:' ||to_char(l_contracts_ib_res_tbl(i).end_date, 'DD-MON-YYYY HH24:MI:SS')
1523: );
1524: END LOOP;

Line 1521: debug( fnd_log.level_statement, l_api_name, 'Resource Start:'||to_char(l_contracts_ib_res_tbl(i).start_date, 'DD-MON-YYYY HH24:MI:SS')

1517:
1518: FOR i in 1..l_contracts_ib_res_tbl.COUNT
1519: LOOP
1520: debug( fnd_log.level_statement, l_api_name, 'Obtained C/IB resource:' || l_contracts_ib_res_tbl(i).resource_id || l_contracts_ib_res_tbl(i).resource_type );
1521: debug( fnd_log.level_statement, l_api_name, 'Resource Start:'||to_char(l_contracts_ib_res_tbl(i).start_date, 'DD-MON-YYYY HH24:MI:SS')
1522: || 'Resource End:' ||to_char(l_contracts_ib_res_tbl(i).end_date, 'DD-MON-YYYY HH24:MI:SS')
1523: );
1524: END LOOP;
1525:

Line 1572: debug( fnd_log.level_statement, l_api_name, 'The Number of Resources found using Territories:' || l_territory_res_tbl.COUNT);

1568: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1569: RAISE fnd_api.g_exc_unexpected_error;
1570: END IF;
1571:
1572: debug( fnd_log.level_statement, l_api_name, 'The Number of Resources found using Territories:' || l_territory_res_tbl.COUNT);
1573:
1574: IF l_territory_res_tbl.COUNT = 0 THEN
1575: l_terr_res_found := FALSE;
1576: END IF;

Line 1580: debug( fnd_log.level_statement, l_api_name, 'Obtained Terr resource:' || l_territory_res_tbl(i).resource_id || l_territory_res_tbl(i).resource_type );

1576: END IF;
1577:
1578: FOR i in 1..l_territory_res_tbl.COUNT
1579: LOOP
1580: debug( fnd_log.level_statement, l_api_name, 'Obtained Terr resource:' || l_territory_res_tbl(i).resource_id || l_territory_res_tbl(i).resource_type );
1581: debug( fnd_log.level_statement, l_api_name, 'Resource Start:'||to_char(l_territory_res_tbl(i).start_date, 'DD-MON-YYYY HH24:MI:SS')
1582: || 'Resource End:' ||to_char(l_territory_res_tbl(i).end_date, 'DD-MON-YYYY HH24:MI:SS')
1583: );
1584: END LOOP;

Line 1581: debug( fnd_log.level_statement, l_api_name, 'Resource Start:'||to_char(l_territory_res_tbl(i).start_date, 'DD-MON-YYYY HH24:MI:SS')

1577:
1578: FOR i in 1..l_territory_res_tbl.COUNT
1579: LOOP
1580: debug( fnd_log.level_statement, l_api_name, 'Obtained Terr resource:' || l_territory_res_tbl(i).resource_id || l_territory_res_tbl(i).resource_type );
1581: debug( fnd_log.level_statement, l_api_name, 'Resource Start:'||to_char(l_territory_res_tbl(i).start_date, 'DD-MON-YYYY HH24:MI:SS')
1582: || 'Resource End:' ||to_char(l_territory_res_tbl(i).end_date, 'DD-MON-YYYY HH24:MI:SS')
1583: );
1584: END LOOP;
1585:

Line 1600: debug( fnd_log.level_statement, l_api_name, 'Search will not be continued');

1596: -- This is done for two cases: a) when res found in TQ/IB/Cont or b) when TQ/IB/Cont
1597: -- was not used as the resource selection criteria
1598: IF NOT l_terr_res_found AND NOT l_cont_ib_res_found
1599: THEN
1600: debug( fnd_log.level_statement, l_api_name, 'Search will not be continued');
1601: l_continue_search := FALSE;
1602: END IF;
1603:
1604: -- Retrieve the Skilled Resources for the Task

Line 1606: debug( fnd_log.level_statement, l_api_name, 'Retrieving Skilled Resources for the Task');

1602: END IF;
1603:
1604: -- Retrieve the Skilled Resources for the Task
1605: IF l_skills_flag = 'Y' AND l_continue_search THEN
1606: debug( fnd_log.level_statement, l_api_name, 'Retrieving Skilled Resources for the Task');
1607: l_stic := l_stic + 8;
1608: get_skilled_resources(
1609: p_task_id => l_task_has_skill_id
1610: , p_start => p_start

Line 1614: debug( fnd_log.level_statement, l_api_name, 'Retrieving Skilled Resources for the Task');

1610: , p_start => p_start
1611: , p_end => l_end_date
1612: , x_skilled_res_tbl => l_skilled_res_tbl
1613: );
1614: debug( fnd_log.level_statement, l_api_name, 'Retrieving Skilled Resources for the Task');
1615: IF l_skilled_res_tbl.COUNT = 0 THEN
1616: debug( fnd_log.level_statement, l_api_name, 'No Resources Found using Skills Qualifiers');
1617: l_continue_search := FALSE;
1618: END IF;

Line 1616: debug( fnd_log.level_statement, l_api_name, 'No Resources Found using Skills Qualifiers');

1612: , x_skilled_res_tbl => l_skilled_res_tbl
1613: );
1614: debug( fnd_log.level_statement, l_api_name, 'Retrieving Skilled Resources for the Task');
1615: IF l_skilled_res_tbl.COUNT = 0 THEN
1616: debug( fnd_log.level_statement, l_api_name, 'No Resources Found using Skills Qualifiers');
1617: l_continue_search := FALSE;
1618: END IF;
1619:
1620: FOR i in 1..l_skilled_res_tbl.COUNT

Line 1622: debug( fnd_log.level_statement, l_api_name, 'Obtained skills resource:' || l_skilled_res_tbl(i).resource_id || l_skilled_res_tbl(i).resource_type );

1618: END IF;
1619:
1620: FOR i in 1..l_skilled_res_tbl.COUNT
1621: LOOP
1622: debug( fnd_log.level_statement, l_api_name, 'Obtained skills resource:' || l_skilled_res_tbl(i).resource_id || l_skilled_res_tbl(i).resource_type );
1623: END LOOP;
1624:
1625: END IF;
1626:

Line 1627: debug( fnd_log.level_statement, l_api_name, 'l_stic value:' || l_stic);

1623: END LOOP;
1624:
1625: END IF;
1626:
1627: debug( fnd_log.level_statement, l_api_name, 'l_stic value:' || l_stic);
1628:
1629: -- Intersect the results obtained from the three Qualifiers.
1630: IF l_continue_search THEN
1631: IF l_stic > 0 AND l_stic <= 3 THEN --> Only Contracts / IB was chosen

Line 1632: debug( fnd_log.level_statement, l_api_name, 'Only Contracts / IB was chosen');

1628:
1629: -- Intersect the results obtained from the three Qualifiers.
1630: IF l_continue_search THEN
1631: IF l_stic > 0 AND l_stic <= 3 THEN --> Only Contracts / IB was chosen
1632: debug( fnd_log.level_statement, l_api_name, 'Only Contracts / IB was chosen');
1633: x_res_tbl := l_contracts_ib_res_tbl;
1634: ELSIF l_stic = 4 THEN --> Only Territory was chosen
1635: debug( fnd_log.level_statement, l_api_name, 'Only Territory was chosen');
1636: x_res_tbl := l_territory_res_tbl;

Line 1635: debug( fnd_log.level_statement, l_api_name, 'Only Territory was chosen');

1631: IF l_stic > 0 AND l_stic <= 3 THEN --> Only Contracts / IB was chosen
1632: debug( fnd_log.level_statement, l_api_name, 'Only Contracts / IB was chosen');
1633: x_res_tbl := l_contracts_ib_res_tbl;
1634: ELSIF l_stic = 4 THEN --> Only Territory was chosen
1635: debug( fnd_log.level_statement, l_api_name, 'Only Territory was chosen');
1636: x_res_tbl := l_territory_res_tbl;
1637: ELSIF l_stic = 8 THEN --> Only Skills were chosen
1638: debug( fnd_log.level_statement, l_api_name, 'Only Skills were chosen');
1639: x_res_tbl := l_skilled_res_tbl;

Line 1638: debug( fnd_log.level_statement, l_api_name, 'Only Skills were chosen');

1634: ELSIF l_stic = 4 THEN --> Only Territory was chosen
1635: debug( fnd_log.level_statement, l_api_name, 'Only Territory was chosen');
1636: x_res_tbl := l_territory_res_tbl;
1637: ELSIF l_stic = 8 THEN --> Only Skills were chosen
1638: debug( fnd_log.level_statement, l_api_name, 'Only Skills were chosen');
1639: x_res_tbl := l_skilled_res_tbl;
1640: ELSIF l_stic <= 7 THEN --> Both Contracts/IB and Terr were chosen
1641: debug( fnd_log.level_statement, l_api_name, 'Both Contracts/IB and Terr were chosen');
1642: x_res_tbl := union_results(l_contracts_ib_res_tbl, l_territory_res_tbl);

Line 1641: debug( fnd_log.level_statement, l_api_name, 'Both Contracts/IB and Terr were chosen');

1637: ELSIF l_stic = 8 THEN --> Only Skills were chosen
1638: debug( fnd_log.level_statement, l_api_name, 'Only Skills were chosen');
1639: x_res_tbl := l_skilled_res_tbl;
1640: ELSIF l_stic <= 7 THEN --> Both Contracts/IB and Terr were chosen
1641: debug( fnd_log.level_statement, l_api_name, 'Both Contracts/IB and Terr were chosen');
1642: x_res_tbl := union_results(l_contracts_ib_res_tbl, l_territory_res_tbl);
1643: ELSIF l_stic <= 11 THEN --> Both Contracts/IB and Skills where chosen
1644: debug( fnd_log.level_statement, l_api_name, 'Both Contracts/IB and Skills where chosen');
1645: x_res_tbl := intersect_results(l_contracts_ib_res_tbl, l_skilled_res_tbl, p_start, l_end_date);

Line 1644: debug( fnd_log.level_statement, l_api_name, 'Both Contracts/IB and Skills where chosen');

1640: ELSIF l_stic <= 7 THEN --> Both Contracts/IB and Terr were chosen
1641: debug( fnd_log.level_statement, l_api_name, 'Both Contracts/IB and Terr were chosen');
1642: x_res_tbl := union_results(l_contracts_ib_res_tbl, l_territory_res_tbl);
1643: ELSIF l_stic <= 11 THEN --> Both Contracts/IB and Skills where chosen
1644: debug( fnd_log.level_statement, l_api_name, 'Both Contracts/IB and Skills where chosen');
1645: x_res_tbl := intersect_results(l_contracts_ib_res_tbl, l_skilled_res_tbl, p_start, l_end_date);
1646: ELSIF l_stic <= 12 THEN --> Both Terr and SKills were chosen
1647: debug( fnd_log.level_statement, l_api_name, 'Both Terr and SKills were chosen');
1648: x_res_tbl := intersect_results(l_territory_res_tbl, l_skilled_res_tbl, p_start, l_end_date);

Line 1647: debug( fnd_log.level_statement, l_api_name, 'Both Terr and SKills were chosen');

1643: ELSIF l_stic <= 11 THEN --> Both Contracts/IB and Skills where chosen
1644: debug( fnd_log.level_statement, l_api_name, 'Both Contracts/IB and Skills where chosen');
1645: x_res_tbl := intersect_results(l_contracts_ib_res_tbl, l_skilled_res_tbl, p_start, l_end_date);
1646: ELSIF l_stic <= 12 THEN --> Both Terr and SKills were chosen
1647: debug( fnd_log.level_statement, l_api_name, 'Both Terr and SKills were chosen');
1648: x_res_tbl := intersect_results(l_territory_res_tbl, l_skilled_res_tbl, p_start, l_end_date);
1649: ELSIF l_stic <= 15 THEN --> All the Flags were chosen
1650: debug( fnd_log.level_statement, l_api_name, 'All the Flags were chosen');
1651: x_res_tbl := union_results(l_contracts_ib_res_tbl, l_territory_res_tbl);

Line 1650: debug( fnd_log.level_statement, l_api_name, 'All the Flags were chosen');

1646: ELSIF l_stic <= 12 THEN --> Both Terr and SKills were chosen
1647: debug( fnd_log.level_statement, l_api_name, 'Both Terr and SKills were chosen');
1648: x_res_tbl := intersect_results(l_territory_res_tbl, l_skilled_res_tbl, p_start, l_end_date);
1649: ELSIF l_stic <= 15 THEN --> All the Flags were chosen
1650: debug( fnd_log.level_statement, l_api_name, 'All the Flags were chosen');
1651: x_res_tbl := union_results(l_contracts_ib_res_tbl, l_territory_res_tbl);
1652: x_res_tbl := intersect_results(x_res_tbl, l_skilled_res_tbl, p_start, l_end_date);
1653: END IF;
1654: END IF;

Line 1658: debug( fnd_log.level_statement, l_api_name, 'Adding the Suggested Resource');

1654: END IF;
1655:
1656: -- Add the suggested resources at the end (if the resource is not already there)
1657: IF l_has_suggested_res THEN
1658: debug( fnd_log.level_statement, l_api_name, 'Adding the Suggested Resource');
1659: add_suggested_resources(
1660: p_res_tbl => x_res_tbl
1661: , p_suggested_res_id_tbl => p_suggested_res_id_tbl
1662: , p_suggested_res_type_tbl => p_suggested_res_type_tbl

Line 1670: debug( fnd_log.level_statement, l_api_name, 'No Resources Found; Raising Exception!');

1666: END IF;
1667:
1668: -- make sure there were results
1669: IF x_res_tbl.COUNT = 0 THEN
1670: debug( fnd_log.level_statement, l_api_name, 'No Resources Found; Raising Exception!');
1671: RAISE e_no_res;
1672: END IF;
1673:
1674: IF p_scheduling_mode <> 'A' THEN

Line 1675: debug( fnd_log.level_statement, l_api_name, 'Non-Assisted Mode; Sorting by distance');

1671: RAISE e_no_res;
1672: END IF;
1673:
1674: IF p_scheduling_mode <> 'A' THEN
1675: debug( fnd_log.level_statement, l_api_name, 'Non-Assisted Mode; Sorting by distance');
1676: -- Sort the Resources by their distance to the Task.
1677: IF csf_util_pvt.g_timing_activated THEN
1678: csf_util_pvt.add_timer(113, 'sort resources list', 0, NULL);
1679: END IF;

Line 1687: debug( fnd_log.level_statement, l_api_name, 'After Sorting resource:' || x_res_tbl(i).resource_id || x_res_tbl(i).resource_type );

1683: END IF;
1684:
1685: FOR i in 1..x_res_tbl.COUNT
1686: LOOP
1687: debug( fnd_log.level_statement, l_api_name, 'After Sorting resource:' || x_res_tbl(i).resource_id || x_res_tbl(i).resource_type );
1688: END LOOP;
1689:
1690: IF csf_util_pvt.g_timing_activated THEN
1691: csf_util_pvt.add_timer(113, 'sort resources list', 1, NULL);

Line 1706: debug( fnd_log.level_statement, l_api_name, 'After Calendar Check:' || x_res_tbl(i).resource_id || x_res_tbl(i).resource_type );

1702: x_res_tbl := reduce_resource_list(x_res_tbl, p_start, l_end_date);
1703:
1704: FOR i in 1..x_res_tbl.COUNT
1705: LOOP
1706: debug( fnd_log.level_statement, l_api_name, 'After Calendar Check:' || x_res_tbl(i).resource_id || x_res_tbl(i).resource_type );
1707: debug( fnd_log.level_statement, l_api_name, 'x_Resource Start:'||to_char(x_res_tbl(i).start_date, 'DD-MON-YYYY HH24:MI:SS')
1708: || 'x_Resource End:' ||to_char(x_res_tbl(i).end_date, 'DD-MON-YYYY HH24:MI:SS')
1709: );
1710: END LOOP;

Line 1707: debug( fnd_log.level_statement, l_api_name, 'x_Resource Start:'||to_char(x_res_tbl(i).start_date, 'DD-MON-YYYY HH24:MI:SS')

1703:
1704: FOR i in 1..x_res_tbl.COUNT
1705: LOOP
1706: debug( fnd_log.level_statement, l_api_name, 'After Calendar Check:' || x_res_tbl(i).resource_id || x_res_tbl(i).resource_type );
1707: debug( fnd_log.level_statement, l_api_name, 'x_Resource Start:'||to_char(x_res_tbl(i).start_date, 'DD-MON-YYYY HH24:MI:SS')
1708: || 'x_Resource End:' ||to_char(x_res_tbl(i).end_date, 'DD-MON-YYYY HH24:MI:SS')
1709: );
1710: END LOOP;
1711: