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_TASK_ASSIGNMENTS_PUB dependencies on FND_LOG

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

1: PACKAGE BODY csf_task_assignments_pub AS
2: /* $Header: CSFPTASB.pls 120.38.12020000.3 2013/04/25 11:29:39 aditysin ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_TASK_ASSIGNMENTS_PUB';
5: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
6:
7: g_status VARCHAR2(30);
8: /**
9: * The Trip Information should be corrected so that it reflects

Line 33: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

29: PROCEDURE debug(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER) IS
30: BEGIN
31: IF p_level >= g_debug_level
32: THEN
33: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
34: THEN
35: fnd_log.string(p_level, 'csf.plsql.CSF_TASK_ASSIGNMENTS_PUB.' || p_module, p_message);
36: END IF;
37: END IF;

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

31: IF p_level >= g_debug_level
32: THEN
33: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
34: THEN
35: fnd_log.string(p_level, 'csf.plsql.CSF_TASK_ASSIGNMENTS_PUB.' || p_module, p_message);
36: END IF;
37: END IF;
38: END;
39:

Line 1571: debug('Input Parameters: p_task_assignment_id:'||p_task_assignment_id||',p_assignment_status: '||p_assignment_status, l_api_name, fnd_log.level_statement);

1567: l_debug boolean := TRUE;
1568: BEGIN
1569: IF l_debug
1570: THEN
1571: debug('Input Parameters: p_task_assignment_id:'||p_task_assignment_id||',p_assignment_status: '||p_assignment_status, l_api_name, fnd_log.level_statement);
1572: END IF;
1573: open c_trip_info(p_task_assignment_id);
1574: fetch c_trip_info into c_trip_rec;
1575: close c_trip_info;

Line 1579: debug('Task Id :'||c_trip_rec.task_id, l_api_name, fnd_log.level_statement);

1575: close c_trip_info;
1576:
1577: IF l_debug
1578: THEN
1579: debug('Task Id :'||c_trip_rec.task_id, l_api_name, fnd_log.level_statement);
1580: END IF;
1581: -- Fetch the Geocode information of the task whose status is going to be changed
1582: OPEN c_task_geometry(c_trip_rec.task_id);
1583: FETCH c_task_geometry INTO l_geometry;

Line 1589: debug('l_geometry is null', l_api_name, fnd_log.level_statement);

1585:
1586: IF l_geometry IS NULL THEN
1587: IF l_debug
1588: THEN
1589: debug('l_geometry is null', l_api_name, fnd_log.level_statement);
1590: END IF;
1591: l_longitude := NULL;
1592: l_latitude := NULL;
1593: ELSE

Line 1608: debug('l_geometry is FALSE', l_api_name, fnd_log.level_statement);

1604: l_longitude := NULL;
1605: l_latitude := NULL;
1606: IF l_debug
1607: THEN
1608: debug('l_geometry is FALSE', l_api_name, fnd_log.level_statement);
1609: END IF;
1610: ELSE
1611: IF l_geometry.sdo_ordinates IS NOT NULL
1612: THEN

Line 1617: debug('Longitude : '||l_longitude, l_api_name, fnd_log.level_statement);

1613: l_longitude := l_geometry.sdo_ordinates(1);
1614: l_latitude := l_geometry.sdo_ordinates(2);
1615: IF l_debug
1616: THEN
1617: debug('Longitude : '||l_longitude, l_api_name, fnd_log.level_statement);
1618: debug('Latitude : '||l_latitude, l_api_name, fnd_log.level_statement);
1619: END IF;
1620: END IF;
1621: END IF;

Line 1618: debug('Latitude : '||l_latitude, l_api_name, fnd_log.level_statement);

1614: l_latitude := l_geometry.sdo_ordinates(2);
1615: IF l_debug
1616: THEN
1617: debug('Longitude : '||l_longitude, l_api_name, fnd_log.level_statement);
1618: debug('Latitude : '||l_latitude, l_api_name, fnd_log.level_statement);
1619: END IF;
1620: END IF;
1621: END IF;
1622: END IF;

Line 1625: debug('Object Capacity ID : '||c_trip_rec.object_capacity_id, l_api_name, fnd_log.level_statement);

1621: END IF;
1622: END IF;
1623: IF l_debug
1624: THEN
1625: debug('Object Capacity ID : '||c_trip_rec.object_capacity_id, l_api_name, fnd_log.level_statement);
1626: END IF;
1627: FOR i in c_task_info(c_trip_rec.object_capacity_id,c_trip_rec.task_id)
1628: LOOP
1629: IF l_debug

Line 1631: debug('TaskId in the trip : '||i.task_id, l_api_name, fnd_log.level_statement);

1627: FOR i in c_task_info(c_trip_rec.object_capacity_id,c_trip_rec.task_id)
1628: LOOP
1629: IF l_debug
1630: THEN
1631: debug('TaskId in the trip : '||i.task_id, l_api_name, fnd_log.level_statement);
1632: END IF;
1633: open c_site_info(i.task_id);
1634: fetch c_site_info into l_task_id,l_customer_id,l_address_id;
1635: close c_site_info;

Line 1639: debug('TaskId : '||i.task_id||', Customer id :'||l_customer_id||', Address Id: '||l_address_id, l_api_name, fnd_log.level_statement);

1635: close c_site_info;
1636:
1637: IF l_debug
1638: THEN
1639: debug('TaskId : '||i.task_id||', Customer id :'||l_customer_id||', Address Id: '||l_address_id, l_api_name, fnd_log.level_statement);
1640: END IF;
1641:
1642: --Get Geo code of the task in the trip
1643: OPEN c_task_geometry(i.task_id);

Line 1652: debug('t_geometry is NULL', l_api_name, fnd_log.level_statement);

1648: t_longitude := NULL;
1649: t_latitude := NULL;
1650: IF l_debug
1651: THEN
1652: debug('t_geometry is NULL', l_api_name, fnd_log.level_statement);
1653: END IF;
1654: ELSE
1655: csf_locus_pub.verify_locus(
1656: p_api_version => 1.0

Line 1670: debug('l_valid_geo is false', l_api_name, fnd_log.level_statement);

1666: t_longitude := NULL;
1667: t_latitude := NULL;
1668: IF l_debug
1669: THEN
1670: debug('l_valid_geo is false', l_api_name, fnd_log.level_statement);
1671: END IF;
1672: ELSE
1673: IF t_geometry.sdo_ordinates IS NOT NULL
1674: THEN

Line 1679: debug('Longitude of tasks in the trip: '||t_longitude, l_api_name, fnd_log.level_statement);

1675: t_longitude := t_geometry.sdo_ordinates(1);
1676: t_latitude := t_geometry.sdo_ordinates(2);
1677: IF l_debug
1678: THEN
1679: debug('Longitude of tasks in the trip: '||t_longitude, l_api_name, fnd_log.level_statement);
1680: debug('Latitude of tasks in the trip : '||t_latitude, l_api_name, fnd_log.level_statement);
1681: END IF;
1682: END IF;
1683: END IF;

Line 1680: debug('Latitude of tasks in the trip : '||t_latitude, l_api_name, fnd_log.level_statement);

1676: t_latitude := t_geometry.sdo_ordinates(2);
1677: IF l_debug
1678: THEN
1679: debug('Longitude of tasks in the trip: '||t_longitude, l_api_name, fnd_log.level_statement);
1680: debug('Latitude of tasks in the trip : '||t_latitude, l_api_name, fnd_log.level_statement);
1681: END IF;
1682: END IF;
1683: END IF;
1684: END IF;

Line 1692: debug('Working status ID: '||l_work, l_api_name, fnd_log.level_statement);

1688: CLOSE c_working;
1689:
1690: IF l_debug
1691: THEN
1692: debug('Working status ID: '||l_work, l_api_name, fnd_log.level_statement);
1693: END IF;
1694:
1695: OPEN c_travel;
1696: FETCH c_travel into l_travel;

Line 1701: debug('Traveling status ID: '||l_travel, l_api_name, fnd_log.level_statement);

1697: CLOSE c_travel;
1698:
1699: IF l_debug
1700: THEN
1701: debug('Traveling status ID: '||l_travel, l_api_name, fnd_log.level_statement);
1702: END IF;
1703: IF p_assignment_status = l_work
1704: THEN
1705: IF l_debug

Line 1707: debug('assignment_status of the task: '||i.assignment_status_id, l_api_name, fnd_log.level_statement);

1703: IF p_assignment_status = l_work
1704: THEN
1705: IF l_debug
1706: THEN
1707: debug('assignment_status of the task: '||i.assignment_status_id, l_api_name, fnd_log.level_statement);
1708: END IF;
1709: IF i.assignment_status_id in (l_travel,l_work)
1710: THEN
1711: IF l_debug

Line 1713: debug('Already there is task with status Working or Traveling so return false ', l_api_name, fnd_log.level_statement);

1709: IF i.assignment_status_id in (l_travel,l_work)
1710: THEN
1711: IF l_debug
1712: THEN
1713: debug('Already there is task with status Working or Traveling so return false ', l_api_name, fnd_log.level_statement);
1714: debug('Out parameter p_task:'||i.task_id, l_api_name, fnd_log.level_statement);
1715: END IF;
1716: p_task := i.task_id;
1717: g_status := i.assignment_status_id;

Line 1714: debug('Out parameter p_task:'||i.task_id, l_api_name, fnd_log.level_statement);

1710: THEN
1711: IF l_debug
1712: THEN
1713: debug('Already there is task with status Working or Traveling so return false ', l_api_name, fnd_log.level_statement);
1714: debug('Out parameter p_task:'||i.task_id, l_api_name, fnd_log.level_statement);
1715: END IF;
1716: p_task := i.task_id;
1717: g_status := i.assignment_status_id;
1718: RETURN 'FALSE';

Line 1724: debug('assignment_status of the task: '||i.assignment_status_id, l_api_name, fnd_log.level_statement);

1720: ELSIF p_assignment_status = l_travel
1721: THEN
1722: IF l_debug
1723: THEN
1724: debug('assignment_status of the task: '||i.assignment_status_id, l_api_name, fnd_log.level_statement);
1725: END IF;
1726: IF i.assignment_status_id = l_work
1727: THEN
1728: IF l_debug

Line 1730: debug('Already there is task with status Working or Traveling so return false ', l_api_name, fnd_log.level_statement);

1726: IF i.assignment_status_id = l_work
1727: THEN
1728: IF l_debug
1729: THEN
1730: debug('Already there is task with status Working or Traveling so return false ', l_api_name, fnd_log.level_statement);
1731: debug('Out parameter p_task:'||i.task_id, l_api_name, fnd_log.level_statement);
1732: END IF;
1733: p_task := i.task_id;
1734: g_status := i.assignment_status_id;

Line 1731: debug('Out parameter p_task:'||i.task_id, l_api_name, fnd_log.level_statement);

1727: THEN
1728: IF l_debug
1729: THEN
1730: debug('Already there is task with status Working or Traveling so return false ', l_api_name, fnd_log.level_statement);
1731: debug('Out parameter p_task:'||i.task_id, l_api_name, fnd_log.level_statement);
1732: END IF;
1733: p_task := i.task_id;
1734: g_status := i.assignment_status_id;
1735: RETURN 'FALSE';

Line 1743: debug('Customer ID:'||c_trip_rec.customer_id||', Address ID: '||c_trip_rec.address_id, l_api_name, fnd_log.level_statement);

1739: IF i.assignment_status_id = p_assignment_status
1740: THEN
1741: IF l_debug
1742: THEN
1743: debug('Customer ID:'||c_trip_rec.customer_id||', Address ID: '||c_trip_rec.address_id, l_api_name, fnd_log.level_statement);
1744: END IF;
1745:
1746: IF c_trip_rec.customer_id = l_customer_id and c_trip_rec.address_id = l_address_id
1747: THEN

Line 1750: debug('Already there is task with status Working or Traveling so return false', l_api_name, fnd_log.level_statement);

1746: IF c_trip_rec.customer_id = l_customer_id and c_trip_rec.address_id = l_address_id
1747: THEN
1748: IF l_debug
1749: THEN
1750: debug('Already there is task with status Working or Traveling so return false', l_api_name, fnd_log.level_statement);
1751: END IF;
1752: RETURN 'TRUE';
1753: ELSE
1754: l_geocode := 'Y';

Line 1763: debug('G-code of the tasks are equal', l_api_name, fnd_log.level_statement);

1759: IF l_longitude = t_longitude and l_latitude = t_latitude
1760: THEN
1761: IF l_debug
1762: THEN
1763: debug('G-code of the tasks are equal', l_api_name, fnd_log.level_statement);
1764: END IF;
1765: RETURN 'TRUE';
1766: ELSE
1767: IF l_debug

Line 1769: debug('G-code of the tasks are not equal', l_api_name, fnd_log.level_statement);

1765: RETURN 'TRUE';
1766: ELSE
1767: IF l_debug
1768: THEN
1769: debug('G-code of the tasks are not equal', l_api_name, fnd_log.level_statement);
1770: debug('Out parameter p_task:'||i.task_id, l_api_name, fnd_log.level_statement);
1771: END IF;
1772: p_task := i.task_id;
1773: g_status := i.assignment_status_id;

Line 1770: debug('Out parameter p_task:'||i.task_id, l_api_name, fnd_log.level_statement);

1766: ELSE
1767: IF l_debug
1768: THEN
1769: debug('G-code of the tasks are not equal', l_api_name, fnd_log.level_statement);
1770: debug('Out parameter p_task:'||i.task_id, l_api_name, fnd_log.level_statement);
1771: END IF;
1772: p_task := i.task_id;
1773: g_status := i.assignment_status_id;
1774: RETURN 'FALSE';

Line 1788: debug('Exception encountered: '||substr(sqlerrm,1,200), l_api_name, fnd_log.level_statement);

1784: EXCEPTION
1785: WHEN others THEN
1786: IF l_debug
1787: THEN
1788: debug('Exception encountered: '||substr(sqlerrm,1,200), l_api_name, fnd_log.level_statement);
1789: END IF;
1790: IF c_task_info%isopen
1791: THEN
1792: close c_task_info;

Line 1794: debug('Out parameter p_task:'||p_task, l_api_name, fnd_log.level_statement);

1790: IF c_task_info%isopen
1791: THEN
1792: close c_task_info;
1793: END IF;
1794: debug('Out parameter p_task:'||p_task, l_api_name, fnd_log.level_statement);
1795: RETURN 'TRUE';
1796:
1797: END;
1798: