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.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_LTP_SPACE_ASSIGN_PVT AS
2: /* $Header: AHLVSANB.pls 120.0.12020000.2 2012/12/07 14:35:19 sareepar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SPACE_ASSIGN_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -- PACKAGE
8: -- AHL_LTP_SPACE_ASSIGN_PVT
9: --

Line 1125: AHL_DEBUG_PUB.enable_debug;

1121: -- Standard Start of API savepoint
1122: SAVEPOINT create_space_assignment;
1123: -- Check if API is called in debug mode. If yes, enable debug.
1124: IF G_DEBUG='Y' THEN
1125: AHL_DEBUG_PUB.enable_debug;
1126: END IF;
1127: -- Debug info.
1128: IF G_DEBUG='Y' THEN
1129: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Create Space Assignment','+SPASN+');

Line 1129: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Create Space Assignment','+SPASN+');

1125: AHL_DEBUG_PUB.enable_debug;
1126: END IF;
1127: -- Debug info.
1128: IF G_DEBUG='Y' THEN
1129: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Create Space Assignment','+SPASN+');
1130: END IF;
1131: -- Standard call to check for call compatibility.
1132: IF FND_API.to_boolean(p_init_msg_list)
1133: THEN

Line 1147: AHL_DEBUG_PUB.debug( 'visit_id'||p_x_space_assign_rec.visit_id);

1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: END IF;
1145: --------------------Value OR ID conversion---------------------------
1146: IF G_DEBUG='Y' THEN
1147: AHL_DEBUG_PUB.debug( 'visit_id'||p_x_space_assign_rec.visit_id);
1148: AHL_DEBUG_PUB.debug( 'space number'||p_x_space_assign_rec.space_name);
1149: AHL_DEBUG_PUB.debug( 'space id'||p_x_space_assign_rec.space_id);
1150: AHL_DEBUG_PUB.debug( 'space assign id'||p_x_space_assign_rec.space_assignment_id);
1151: END IF;

Line 1148: AHL_DEBUG_PUB.debug( 'space number'||p_x_space_assign_rec.space_name);

1144: END IF;
1145: --------------------Value OR ID conversion---------------------------
1146: IF G_DEBUG='Y' THEN
1147: AHL_DEBUG_PUB.debug( 'visit_id'||p_x_space_assign_rec.visit_id);
1148: AHL_DEBUG_PUB.debug( 'space number'||p_x_space_assign_rec.space_name);
1149: AHL_DEBUG_PUB.debug( 'space id'||p_x_space_assign_rec.space_id);
1150: AHL_DEBUG_PUB.debug( 'space assign id'||p_x_space_assign_rec.space_assignment_id);
1151: END IF;
1152: --

Line 1149: AHL_DEBUG_PUB.debug( 'space id'||p_x_space_assign_rec.space_id);

1145: --------------------Value OR ID conversion---------------------------
1146: IF G_DEBUG='Y' THEN
1147: AHL_DEBUG_PUB.debug( 'visit_id'||p_x_space_assign_rec.visit_id);
1148: AHL_DEBUG_PUB.debug( 'space number'||p_x_space_assign_rec.space_name);
1149: AHL_DEBUG_PUB.debug( 'space id'||p_x_space_assign_rec.space_id);
1150: AHL_DEBUG_PUB.debug( 'space assign id'||p_x_space_assign_rec.space_assignment_id);
1151: END IF;
1152: --
1153: IF p_reschedule_flag = 'Y' THEN

Line 1150: AHL_DEBUG_PUB.debug( 'space assign id'||p_x_space_assign_rec.space_assignment_id);

1146: IF G_DEBUG='Y' THEN
1147: AHL_DEBUG_PUB.debug( 'visit_id'||p_x_space_assign_rec.visit_id);
1148: AHL_DEBUG_PUB.debug( 'space number'||p_x_space_assign_rec.space_name);
1149: AHL_DEBUG_PUB.debug( 'space id'||p_x_space_assign_rec.space_id);
1150: AHL_DEBUG_PUB.debug( 'space assign id'||p_x_space_assign_rec.space_assignment_id);
1151: END IF;
1152: --
1153: IF p_reschedule_flag = 'Y' THEN
1154: --Check is required during rescheduling

Line 1158: AHL_DEBUG_PUB.debug( 'inside schedule flag:'||p_x_space_assign_rec.space_name);

1154: --Check is required during rescheduling
1155: IF (p_x_space_assign_rec.visit_id IS NOT NULL AND
1156: p_x_space_assign_rec.visit_id <> FND_API.G_MISS_NUM ) THEN
1157: --
1158: AHL_DEBUG_PUB.debug( 'inside schedule flag:'||p_x_space_assign_rec.space_name);
1159: --
1160: DELETE FROM AHL_SPACE_ASSIGNMENTS
1161: WHERE visit_id = p_x_space_assign_rec.visit_id;
1162: --

Line 1167: AHL_DEBUG_PUB.debug( 'number of records space_id'||p_x_space_assign_rec.space_name);

1163: END IF;
1164: --
1165: END IF; --Reschedule flag
1166:
1167: AHL_DEBUG_PUB.debug( 'number of records space_id'||p_x_space_assign_rec.space_name);
1168:
1169: -- Convert Space name to space id
1170: IF (p_x_space_assign_rec.space_name IS NOT NULL AND
1171: p_x_space_assign_rec.space_name <> FND_API.G_MISS_CHAR ) OR

Line 1433: Ahl_Debug_Pub.debug( 'Before insert state'||l_space_assignment_id);

1429: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1430: RAISE Fnd_Api.G_EXC_ERROR;
1431: END IF;
1432:
1433: Ahl_Debug_Pub.debug( 'Before insert state'||l_space_assignment_id);
1434:
1435: ----------------------------DML Operation---------------------------------
1436: --insert the record
1437: INSERT INTO AHL_SPACE_ASSIGNMENTS

Line 1515: Ahl_Debug_Pub.debug( 'End of private api Create Space assignment','+SPANS+');

1511: COMMIT;
1512: END IF;
1513: -- Debug info
1514: IF G_DEBUG='Y' THEN
1515: Ahl_Debug_Pub.debug( 'End of private api Create Space assignment','+SPANS+');
1516: -- Check if API is called in debug mode. If yes, disable debug.
1517: Ahl_Debug_Pub.disable_debug;
1518: END IF;
1519: EXCEPTION

Line 1517: Ahl_Debug_Pub.disable_debug;

1513: -- Debug info
1514: IF G_DEBUG='Y' THEN
1515: Ahl_Debug_Pub.debug( 'End of private api Create Space assignment','+SPANS+');
1516: -- Check if API is called in debug mode. If yes, disable debug.
1517: Ahl_Debug_Pub.disable_debug;
1518: END IF;
1519: EXCEPTION
1520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1521: ROLLBACK TO create_space_assignment;

Line 1528: AHL_DEBUG_PUB.log_app_messages (

1524: p_count => x_msg_count,
1525: p_data => x_msg_data);
1526: IF G_DEBUG='Y' THEN
1527:
1528: AHL_DEBUG_PUB.log_app_messages (
1529: x_msg_count, x_msg_data, 'ERROR' );
1530: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1531: -- Check if API is called in debug mode. If yes, disable debug.
1532: AHL_DEBUG_PUB.disable_debug;

Line 1530: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');

1526: IF G_DEBUG='Y' THEN
1527:
1528: AHL_DEBUG_PUB.log_app_messages (
1529: x_msg_count, x_msg_data, 'ERROR' );
1530: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1531: -- Check if API is called in debug mode. If yes, disable debug.
1532: AHL_DEBUG_PUB.disable_debug;
1533: END IF;
1534: WHEN FND_API.G_EXC_ERROR THEN

Line 1532: AHL_DEBUG_PUB.disable_debug;

1528: AHL_DEBUG_PUB.log_app_messages (
1529: x_msg_count, x_msg_data, 'ERROR' );
1530: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1531: -- Check if API is called in debug mode. If yes, disable debug.
1532: AHL_DEBUG_PUB.disable_debug;
1533: END IF;
1534: WHEN FND_API.G_EXC_ERROR THEN
1535: ROLLBACK TO create_space_assignment;
1536: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1542: AHL_DEBUG_PUB.log_app_messages (

1538: p_count => x_msg_count,
1539: p_data => X_msg_data);
1540: IF G_DEBUG='Y' THEN
1541: -- Debug info.
1542: AHL_DEBUG_PUB.log_app_messages (
1543: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1544: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1545: -- Check if API is called in debug mode. If yes, disable debug.
1546: AHL_DEBUG_PUB.disable_debug;

Line 1544: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');

1540: IF G_DEBUG='Y' THEN
1541: -- Debug info.
1542: AHL_DEBUG_PUB.log_app_messages (
1543: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1544: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1545: -- Check if API is called in debug mode. If yes, disable debug.
1546: AHL_DEBUG_PUB.disable_debug;
1547: END IF;
1548: WHEN OTHERS THEN

Line 1546: AHL_DEBUG_PUB.disable_debug;

1542: AHL_DEBUG_PUB.log_app_messages (
1543: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1544: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1545: -- Check if API is called in debug mode. If yes, disable debug.
1546: AHL_DEBUG_PUB.disable_debug;
1547: END IF;
1548: WHEN OTHERS THEN
1549: ROLLBACK TO create_space_assignment;
1550: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1562: AHL_DEBUG_PUB.log_app_messages (

1558: p_count => x_msg_count,
1559: p_data => X_msg_data);
1560: IF G_DEBUG='Y' THEN
1561: -- Debug info.
1562: AHL_DEBUG_PUB.log_app_messages (
1563: x_msg_count, x_msg_data, 'SQL ERROR' );
1564: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1565: -- Check if API is called in debug mode. If yes, disable debug.
1566: AHL_DEBUG_PUB.disable_debug;

Line 1564: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');

1560: IF G_DEBUG='Y' THEN
1561: -- Debug info.
1562: AHL_DEBUG_PUB.log_app_messages (
1563: x_msg_count, x_msg_data, 'SQL ERROR' );
1564: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1565: -- Check if API is called in debug mode. If yes, disable debug.
1566: AHL_DEBUG_PUB.disable_debug;
1567: END IF;
1568: END Create_Space_assignment;

Line 1566: AHL_DEBUG_PUB.disable_debug;

1562: AHL_DEBUG_PUB.log_app_messages (
1563: x_msg_count, x_msg_data, 'SQL ERROR' );
1564: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Create Space assignment','+SPASN+');
1565: -- Check if API is called in debug mode. If yes, disable debug.
1566: AHL_DEBUG_PUB.disable_debug;
1567: END IF;
1568: END Create_Space_assignment;
1569: --
1570: -- PROCEDURE

Line 1612: AHL_DEBUG_PUB.enable_debug;

1608: -- Standard Start of API savepoint
1609: SAVEPOINT update_space_assignment;
1610: -- Check if API is called in debug mode. If yes, enable debug.
1611: IF G_DEBUG='Y' THEN
1612: AHL_DEBUG_PUB.enable_debug;
1613: END IF;
1614: -- Debug info.
1615: IF G_DEBUG='Y' THEN
1616: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');

Line 1616: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');

1612: AHL_DEBUG_PUB.enable_debug;
1613: END IF;
1614: -- Debug info.
1615: IF G_DEBUG='Y' THEN
1616: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1617: END IF;
1618: -- Standard call to check for call compatibility.
1619: IF FND_API.to_boolean(p_init_msg_list)
1620: THEN

Line 1750: Ahl_Debug_Pub.debug( 'End of private api Update Space assignment','+SPANT+');

1746: COMMIT;
1747: END IF;
1748: -- Debug info
1749: IF G_DEBUG='Y' THEN
1750: Ahl_Debug_Pub.debug( 'End of private api Update Space assignment','+SPANT+');
1751: END IF;
1752: -- Check if API is called in debug mode. If yes, disable debug.
1753: IF G_DEBUG='Y' THEN
1754: Ahl_Debug_Pub.disable_debug;

Line 1754: Ahl_Debug_Pub.disable_debug;

1750: Ahl_Debug_Pub.debug( 'End of private api Update Space assignment','+SPANT+');
1751: END IF;
1752: -- Check if API is called in debug mode. If yes, disable debug.
1753: IF G_DEBUG='Y' THEN
1754: Ahl_Debug_Pub.disable_debug;
1755: END IF;
1756:
1757: EXCEPTION
1758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1766: AHL_DEBUG_PUB.log_app_messages (

1762: p_count => x_msg_count,
1763: p_data => x_msg_data);
1764: IF G_DEBUG='Y' THEN
1765:
1766: AHL_DEBUG_PUB.log_app_messages (
1767: x_msg_count, x_msg_data, 'ERROR' );
1768: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1769: -- Check if API is called in debug mode. If yes, disable debug.
1770: AHL_DEBUG_PUB.disable_debug;

Line 1768: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');

1764: IF G_DEBUG='Y' THEN
1765:
1766: AHL_DEBUG_PUB.log_app_messages (
1767: x_msg_count, x_msg_data, 'ERROR' );
1768: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1769: -- Check if API is called in debug mode. If yes, disable debug.
1770: AHL_DEBUG_PUB.disable_debug;
1771: END IF;
1772: WHEN FND_API.G_EXC_ERROR THEN

Line 1770: AHL_DEBUG_PUB.disable_debug;

1766: AHL_DEBUG_PUB.log_app_messages (
1767: x_msg_count, x_msg_data, 'ERROR' );
1768: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1769: -- Check if API is called in debug mode. If yes, disable debug.
1770: AHL_DEBUG_PUB.disable_debug;
1771: END IF;
1772: WHEN FND_API.G_EXC_ERROR THEN
1773: ROLLBACK TO update_space_assignment;
1774: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1780: AHL_DEBUG_PUB.log_app_messages (

1776: p_count => x_msg_count,
1777: p_data => X_msg_data);
1778: IF G_DEBUG='Y' THEN
1779: -- Debug info.
1780: AHL_DEBUG_PUB.log_app_messages (
1781: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1782: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1783: -- Check if API is called in debug mode. If yes, disable debug.
1784: AHL_DEBUG_PUB.disable_debug;

Line 1782: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');

1778: IF G_DEBUG='Y' THEN
1779: -- Debug info.
1780: AHL_DEBUG_PUB.log_app_messages (
1781: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1782: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1783: -- Check if API is called in debug mode. If yes, disable debug.
1784: AHL_DEBUG_PUB.disable_debug;
1785: END IF;
1786: WHEN OTHERS THEN

Line 1784: AHL_DEBUG_PUB.disable_debug;

1780: AHL_DEBUG_PUB.log_app_messages (
1781: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1782: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignment','+SPANT+');
1783: -- Check if API is called in debug mode. If yes, disable debug.
1784: AHL_DEBUG_PUB.disable_debug;
1785: END IF;
1786: WHEN OTHERS THEN
1787: ROLLBACK TO update_space_assignment;
1788: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1801: AHL_DEBUG_PUB.log_app_messages (

1797: p_data => X_msg_data);
1798:
1799: IF G_DEBUG='Y' THEN
1800: -- Debug info.
1801: AHL_DEBUG_PUB.log_app_messages (
1802: x_msg_count, x_msg_data, 'SQL ERROR' );
1803: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');
1804: -- Check if API is called in debug mode. If yes, disable debug.
1805: AHL_DEBUG_PUB.disable_debug;

Line 1803: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');

1799: IF G_DEBUG='Y' THEN
1800: -- Debug info.
1801: AHL_DEBUG_PUB.log_app_messages (
1802: x_msg_count, x_msg_data, 'SQL ERROR' );
1803: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');
1804: -- Check if API is called in debug mode. If yes, disable debug.
1805: AHL_DEBUG_PUB.disable_debug;
1806: END IF;
1807: END Update_Space_Assignment;

Line 1805: AHL_DEBUG_PUB.disable_debug;

1801: AHL_DEBUG_PUB.log_app_messages (
1802: x_msg_count, x_msg_data, 'SQL ERROR' );
1803: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Update Space Assignemnt','+SPANT+');
1804: -- Check if API is called in debug mode. If yes, disable debug.
1805: AHL_DEBUG_PUB.disable_debug;
1806: END IF;
1807: END Update_Space_Assignment;
1808: --
1809: -- PROCEDURE

Line 1896: AHL_DEBUG_PUB.enable_debug;

1892: -- Standard Start of API savepoint
1893: SAVEPOINT delete_space_assignment;
1894: -- Check if API is called in debug mode. If yes, enable debug.
1895: IF G_DEBUG='Y' THEN
1896: AHL_DEBUG_PUB.enable_debug;
1897: END IF;
1898: -- Debug info.
1899: IF G_DEBUG='Y' THEN
1900: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

Line 1900: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

1896: AHL_DEBUG_PUB.enable_debug;
1897: END IF;
1898: -- Debug info.
1899: IF G_DEBUG='Y' THEN
1900: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
1901: END IF;
1902: -- Standard call to check for call compatibility.
1903: IF FND_API.to_boolean(p_init_msg_list)
1904: THEN

Line 1921: AHL_DEBUG_PUB.debug( 'visit id'||p_space_assign_rec.visit_id);

1917: IF (p_space_assign_rec.visit_id IS NOT NULL AND
1918: p_space_assign_rec.visit_id <> FND_API.G_MISS_NUM) THEN
1919: --
1920: IF G_DEBUG='Y' THEN
1921: AHL_DEBUG_PUB.debug( 'visit id'||p_space_assign_rec.visit_id);
1922: END IF;
1923:
1924: OPEN c_visit_spaces_cur(p_space_assign_rec.visit_id);
1925: LOOP

Line 1931: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);

1927: EXIT WHEN c_visit_spaces_cur%NOTFOUND;
1928: IF l_visit_spaces_rec.space_id IS NOT NULL THEN
1929:
1930: IF G_DEBUG='Y' THEN
1931: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1932: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1933: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1934: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1935: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);

Line 1932: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);

1928: IF l_visit_spaces_rec.space_id IS NOT NULL THEN
1929:
1930: IF G_DEBUG='Y' THEN
1931: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1932: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1933: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1934: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1935: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);
1936: END IF;

Line 1933: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);

1929:
1930: IF G_DEBUG='Y' THEN
1931: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1932: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1933: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1934: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1935: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);
1936: END IF;
1937: --

Line 1934: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);

1930: IF G_DEBUG='Y' THEN
1931: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1932: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1933: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1934: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1935: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);
1936: END IF;
1937: --
1938: IF (nvl(l_visit_spaces_rec.organization_id,-1) <> l_visit_spaces_rec.sporg_id

Line 1935: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);

1931: AHL_DEBUG_PUB.debug( 'Space ID'||l_visit_spaces_rec.space_id);
1932: AHL_DEBUG_PUB.debug( 'org ID'||l_visit_spaces_rec.organization_id);
1933: AHL_DEBUG_PUB.debug( 'dept ID'||l_visit_spaces_rec.department_id);
1934: AHL_DEBUG_PUB.debug( 'sorg ID'||l_visit_spaces_rec.sporg_id);
1935: AHL_DEBUG_PUB.debug( 'sdept ID'||l_visit_spaces_rec.spdept_id);
1936: END IF;
1937: --
1938: IF (nvl(l_visit_spaces_rec.organization_id,-1) <> l_visit_spaces_rec.sporg_id
1939: OR nvl(l_visit_spaces_rec.department_id,-1) <> l_visit_spaces_rec.spdept_id )

Line 1991: AHL_DEBUG_PUB.debug( 'space assign id'||l_space_assignment_id);

1987: RAISE FND_API.g_exc_error;
1988: END IF;
1989: CLOSE c_space_assign_cur;
1990: IF G_DEBUG='Y' THEN
1991: AHL_DEBUG_PUB.debug( 'space assign id'||l_space_assignment_id);
1992: AHL_DEBUG_PUB.debug( 'l ovn number'||l_object_version_number);
1993: AHL_DEBUG_PUB.debug( 'p ovn number'||p_space_assign_rec.object_version_number);
1994: AHL_DEBUG_PUB.debug( '--@>l_object_version_number'||l_object_version_number||' --- '||p_space_assign_rec.object_version_number);
1995: END IF;

Line 1992: AHL_DEBUG_PUB.debug( 'l ovn number'||l_object_version_number);

1988: END IF;
1989: CLOSE c_space_assign_cur;
1990: IF G_DEBUG='Y' THEN
1991: AHL_DEBUG_PUB.debug( 'space assign id'||l_space_assignment_id);
1992: AHL_DEBUG_PUB.debug( 'l ovn number'||l_object_version_number);
1993: AHL_DEBUG_PUB.debug( 'p ovn number'||p_space_assign_rec.object_version_number);
1994: AHL_DEBUG_PUB.debug( '--@>l_object_version_number'||l_object_version_number||' --- '||p_space_assign_rec.object_version_number);
1995: END IF;
1996:

Line 1993: AHL_DEBUG_PUB.debug( 'p ovn number'||p_space_assign_rec.object_version_number);

1989: CLOSE c_space_assign_cur;
1990: IF G_DEBUG='Y' THEN
1991: AHL_DEBUG_PUB.debug( 'space assign id'||l_space_assignment_id);
1992: AHL_DEBUG_PUB.debug( 'l ovn number'||l_object_version_number);
1993: AHL_DEBUG_PUB.debug( 'p ovn number'||p_space_assign_rec.object_version_number);
1994: AHL_DEBUG_PUB.debug( '--@>l_object_version_number'||l_object_version_number||' --- '||p_space_assign_rec.object_version_number);
1995: END IF;
1996:
1997:

Line 1994: AHL_DEBUG_PUB.debug( '--@>l_object_version_number'||l_object_version_number||' --- '||p_space_assign_rec.object_version_number);

1990: IF G_DEBUG='Y' THEN
1991: AHL_DEBUG_PUB.debug( 'space assign id'||l_space_assignment_id);
1992: AHL_DEBUG_PUB.debug( 'l ovn number'||l_object_version_number);
1993: AHL_DEBUG_PUB.debug( 'p ovn number'||p_space_assign_rec.object_version_number);
1994: AHL_DEBUG_PUB.debug( '--@>l_object_version_number'||l_object_version_number||' --- '||p_space_assign_rec.object_version_number);
1995: END IF;
1996:
1997:
1998: --Check for object version number

Line 2025: Ahl_Debug_Pub.debug( 'End of private api Delete Space Assignment','+SPANT+');

2021: COMMIT;
2022: END IF;
2023: -- Debug info
2024: IF G_DEBUG='Y' THEN
2025: Ahl_Debug_Pub.debug( 'End of private api Delete Space Assignment','+SPANT+');
2026: END IF;
2027: -- Check if API is called in debug mode. If yes, disable debug.
2028: IF G_DEBUG='Y' THEN
2029: Ahl_Debug_Pub.disable_debug;

Line 2029: Ahl_Debug_Pub.disable_debug;

2025: Ahl_Debug_Pub.debug( 'End of private api Delete Space Assignment','+SPANT+');
2026: END IF;
2027: -- Check if API is called in debug mode. If yes, disable debug.
2028: IF G_DEBUG='Y' THEN
2029: Ahl_Debug_Pub.disable_debug;
2030: END IF;
2031:
2032: EXCEPTION
2033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2041: AHL_DEBUG_PUB.log_app_messages (

2037: p_count => x_msg_count,
2038: p_data => x_msg_data);
2039: IF G_DEBUG='Y' THEN
2040:
2041: AHL_DEBUG_PUB.log_app_messages (
2042: x_msg_count, x_msg_data, 'ERROR' );
2043: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2044: -- Check if API is called in debug mode. If yes, disable debug.
2045: AHL_DEBUG_PUB.disable_debug;

Line 2043: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

2039: IF G_DEBUG='Y' THEN
2040:
2041: AHL_DEBUG_PUB.log_app_messages (
2042: x_msg_count, x_msg_data, 'ERROR' );
2043: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2044: -- Check if API is called in debug mode. If yes, disable debug.
2045: AHL_DEBUG_PUB.disable_debug;
2046: END IF;
2047: WHEN FND_API.G_EXC_ERROR THEN

Line 2045: AHL_DEBUG_PUB.disable_debug;

2041: AHL_DEBUG_PUB.log_app_messages (
2042: x_msg_count, x_msg_data, 'ERROR' );
2043: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2044: -- Check if API is called in debug mode. If yes, disable debug.
2045: AHL_DEBUG_PUB.disable_debug;
2046: END IF;
2047: WHEN FND_API.G_EXC_ERROR THEN
2048: ROLLBACK TO delete_space_assignment;
2049: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2056: AHL_DEBUG_PUB.log_app_messages (

2052: p_data => X_msg_data);
2053: IF G_DEBUG='Y' THEN
2054:
2055: -- Debug info.
2056: AHL_DEBUG_PUB.log_app_messages (
2057: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2058: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2059: -- Check if API is called in debug mode. If yes, disable debug.
2060: AHL_DEBUG_PUB.disable_debug;

Line 2058: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

2054:
2055: -- Debug info.
2056: AHL_DEBUG_PUB.log_app_messages (
2057: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2058: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2059: -- Check if API is called in debug mode. If yes, disable debug.
2060: AHL_DEBUG_PUB.disable_debug;
2061: END IF;
2062: WHEN OTHERS THEN

Line 2060: AHL_DEBUG_PUB.disable_debug;

2056: AHL_DEBUG_PUB.log_app_messages (
2057: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2058: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2059: -- Check if API is called in debug mode. If yes, disable debug.
2060: AHL_DEBUG_PUB.disable_debug;
2061: END IF;
2062: WHEN OTHERS THEN
2063: ROLLBACK TO delete_space_assignment;
2064: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2077: AHL_DEBUG_PUB.log_app_messages (

2073: p_data => X_msg_data);
2074: IF G_DEBUG='Y' THEN
2075:
2076: -- Debug info.
2077: AHL_DEBUG_PUB.log_app_messages (
2078: x_msg_count, x_msg_data, 'SQL ERROR' );
2079: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2080: -- Check if API is called in debug mode. If yes, disable debug.
2081: AHL_DEBUG_PUB.disable_debug;

Line 2079: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');

2075:
2076: -- Debug info.
2077: AHL_DEBUG_PUB.log_app_messages (
2078: x_msg_count, x_msg_data, 'SQL ERROR' );
2079: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2080: -- Check if API is called in debug mode. If yes, disable debug.
2081: AHL_DEBUG_PUB.disable_debug;
2082: END IF;
2083: END Delete_Space_Assignment;

Line 2081: AHL_DEBUG_PUB.disable_debug;

2077: AHL_DEBUG_PUB.log_app_messages (
2078: x_msg_count, x_msg_data, 'SQL ERROR' );
2079: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Delete Space Assignment','+SPANT+');
2080: -- Check if API is called in debug mode. If yes, disable debug.
2081: AHL_DEBUG_PUB.disable_debug;
2082: END IF;
2083: END Delete_Space_Assignment;
2084: --
2085: -- PROCEDURE

Line 2203: AHL_DEBUG_PUB.enable_debug;

2199: -- Standard Start of API savepoint
2200: SAVEPOINT schedule_visit;
2201: -- Check if API is called in debug mode. If yes, enable debug.
2202: IF G_DEBUG='Y' THEN
2203: AHL_DEBUG_PUB.enable_debug;
2204: END IF;
2205: -- Debug info.
2206: IF G_DEBUG='Y' THEN
2207: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');

Line 2207: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');

2203: AHL_DEBUG_PUB.enable_debug;
2204: END IF;
2205: -- Debug info.
2206: IF G_DEBUG='Y' THEN
2207: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2208: END IF;
2209: -- Standard call to check for call compatibility.
2210: IF FND_API.to_boolean(p_init_msg_list)
2211: THEN

Line 2231: AHL_DEBUG_PUB.debug( 'planned end hour'||p_x_schedule_visit_rec.planned_end_hour);

2227: p_x_schedule_visit_rec.dept_id := null;
2228: END IF;
2229:
2230: IF G_DEBUG='Y' THEN
2231: AHL_DEBUG_PUB.debug( 'planned end hour'||p_x_schedule_visit_rec.planned_end_hour);
2232: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
2233: END IF;
2234:
2235: IF G_DEBUG='Y' THEN

Line 2232: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);

2228: END IF;
2229:
2230: IF G_DEBUG='Y' THEN
2231: AHL_DEBUG_PUB.debug( 'planned end hour'||p_x_schedule_visit_rec.planned_end_hour);
2232: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
2233: END IF;
2234:
2235: IF G_DEBUG='Y' THEN
2236: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.org_name);

Line 2236: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.org_name);

2232: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
2233: END IF;
2234:
2235: IF G_DEBUG='Y' THEN
2236: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.org_name);
2237: END IF;
2238:
2239: -- moved this block of code up, to get acess to l_visit_id
2240: -- Convert Visit Number to visit id

Line 2282: AHL_DEBUG_PUB.debug( 'dept name'||p_x_schedule_visit_rec.dept_name);

2278: END IF;
2279: END IF;
2280:
2281: IF G_DEBUG='Y' THEN
2282: AHL_DEBUG_PUB.debug( 'dept name'||p_x_schedule_visit_rec.dept_name);
2283: END IF;
2284: --DEPT ID
2285: IF ( p_x_schedule_visit_rec.dept_name IS NULL OR
2286: p_x_schedule_visit_rec.dept_name = FND_API.G_MISS_CHAR) THEN

Line 2306: AHL_DEBUG_PUB.debug( 'space mean:'||p_x_schedule_visit_rec.space_category_mean);

2302: END IF;
2303: --
2304:
2305: IF G_DEBUG='Y' THEN
2306: AHL_DEBUG_PUB.debug( 'space mean:'||p_x_schedule_visit_rec.space_category_mean);
2307: AHL_DEBUG_PUB.debug( 'space code:'||p_x_schedule_visit_rec.space_category_code);
2308: END IF;
2309:
2310: --For Space Category

Line 2307: AHL_DEBUG_PUB.debug( 'space code:'||p_x_schedule_visit_rec.space_category_code);

2303: --
2304:
2305: IF G_DEBUG='Y' THEN
2306: AHL_DEBUG_PUB.debug( 'space mean:'||p_x_schedule_visit_rec.space_category_mean);
2307: AHL_DEBUG_PUB.debug( 'space code:'||p_x_schedule_visit_rec.space_category_code);
2308: END IF;
2309:
2310: --For Space Category
2311: IF p_x_schedule_visit_rec.space_category_mean IS NOT NULL AND

Line 2338: AHL_DEBUG_PUB.debug( 'mean:'||p_x_schedule_visit_rec.visit_type_mean);

2334: END IF;
2335: END IF;
2336:
2337: IF G_DEBUG='Y' THEN
2338: AHL_DEBUG_PUB.debug( 'mean:'||p_x_schedule_visit_rec.visit_type_mean);
2339: AHL_DEBUG_PUB.debug( 'visit type code:'||p_x_schedule_visit_rec.visit_type_code);
2340: END IF;
2341:
2342: -- Visit type code

Line 2339: AHL_DEBUG_PUB.debug( 'visit type code:'||p_x_schedule_visit_rec.visit_type_code);

2335: END IF;
2336:
2337: IF G_DEBUG='Y' THEN
2338: AHL_DEBUG_PUB.debug( 'mean:'||p_x_schedule_visit_rec.visit_type_mean);
2339: AHL_DEBUG_PUB.debug( 'visit type code:'||p_x_schedule_visit_rec.visit_type_code);
2340: END IF;
2341:
2342: -- Visit type code
2343: IF p_x_schedule_visit_rec.visit_type_mean IS NOT NULL AND

Line 2395: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.dept_id);

2391: END IF;
2392: */
2393:
2394: IF G_DEBUG='Y' THEN
2395: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.dept_id);
2396: AHL_DEBUG_PUB.debug( 'visit type'||p_x_schedule_visit_rec.visit_type_code);
2397: END IF;
2398: --
2399: IF G_DEBUG='Y' THEN

Line 2396: AHL_DEBUG_PUB.debug( 'visit type'||p_x_schedule_visit_rec.visit_type_code);

2392: */
2393:
2394: IF G_DEBUG='Y' THEN
2395: AHL_DEBUG_PUB.debug( 'dept id'||p_x_schedule_visit_rec.dept_id);
2396: AHL_DEBUG_PUB.debug( 'visit type'||p_x_schedule_visit_rec.visit_type_code);
2397: END IF;
2398: --
2399: IF G_DEBUG='Y' THEN
2400: AHL_DEBUG_PUB.debug( 'schedule visits schedule_flag'||p_x_schedule_visit_rec.schedule_flag);

Line 2400: AHL_DEBUG_PUB.debug( 'schedule visits schedule_flag'||p_x_schedule_visit_rec.schedule_flag);

2396: AHL_DEBUG_PUB.debug( 'visit type'||p_x_schedule_visit_rec.visit_type_code);
2397: END IF;
2398: --
2399: IF G_DEBUG='Y' THEN
2400: AHL_DEBUG_PUB.debug( 'schedule visits schedule_flag'||p_x_schedule_visit_rec.schedule_flag);
2401: END IF;
2402:
2403: -- anraj: commented, issue number 144
2404: -- commented since space assigments are taken care of in the AHL_VWP_VISITS_PVT.Process_Visit

Line 2491: AHL_DEBUG_PUB.debug( 'start date'||TO_CHAR(p_x_schedule_visit_rec.start_date, 'DD-MM-YYYY ') ||to_char(p_x_schedule_visit_rec.start_hour) ||':00');

2487: END IF;
2488:
2489: --
2490: IF G_DEBUG='Y' THEN
2491: AHL_DEBUG_PUB.debug( 'start date'||TO_CHAR(p_x_schedule_visit_rec.start_date, 'DD-MM-YYYY ') ||to_char(p_x_schedule_visit_rec.start_hour) ||':00');
2492: AHL_DEBUG_PUB.debug( 'start hour'||p_x_schedule_visit_rec.start_hour);
2493: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
2494: END IF;
2495:

Line 2492: AHL_DEBUG_PUB.debug( 'start hour'||p_x_schedule_visit_rec.start_hour);

2488:
2489: --
2490: IF G_DEBUG='Y' THEN
2491: AHL_DEBUG_PUB.debug( 'start date'||TO_CHAR(p_x_schedule_visit_rec.start_date, 'DD-MM-YYYY ') ||to_char(p_x_schedule_visit_rec.start_hour) ||':00');
2492: AHL_DEBUG_PUB.debug( 'start hour'||p_x_schedule_visit_rec.start_hour);
2493: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
2494: END IF;
2495:
2496: --Check for visit scheduled or not

Line 2493: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);

2489: --
2490: IF G_DEBUG='Y' THEN
2491: AHL_DEBUG_PUB.debug( 'start date'||TO_CHAR(p_x_schedule_visit_rec.start_date, 'DD-MM-YYYY ') ||to_char(p_x_schedule_visit_rec.start_hour) ||':00');
2492: AHL_DEBUG_PUB.debug( 'start hour'||p_x_schedule_visit_rec.start_hour);
2493: AHL_DEBUG_PUB.debug( 'plan end date'||p_x_schedule_visit_rec.planned_end_date);
2494: END IF;
2495:
2496: --Check for visit scheduled or not
2497: -- anraj: commented, issue number 144

Line 2514: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);

2510: RAISE Fnd_Api.G_EXC_ERROR;
2511: END IF;
2512:
2513: IF G_DEBUG='Y' THEN
2514: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2515: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2516: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2517: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2518: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);

Line 2515: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);

2511: END IF;
2512:
2513: IF G_DEBUG='Y' THEN
2514: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2515: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2516: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2517: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2518: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2519: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);

Line 2516: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);

2512:
2513: IF G_DEBUG='Y' THEN
2514: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2515: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2516: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2517: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2518: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2519: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2520: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);

Line 2517: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);

2513: IF G_DEBUG='Y' THEN
2514: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2515: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2516: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2517: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2518: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2519: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2520: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2521: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);

Line 2518: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);

2514: AHL_DEBUG_PUB.debug( 'before assign l_visit_id:'||l_visit_id);
2515: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2516: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2517: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2518: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2519: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2520: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2521: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);
2522: END IF;

Line 2519: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);

2515: AHL_DEBUG_PUB.debug( 'before assign visit number:'||p_x_schedule_visit_rec.visit_number);
2516: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2517: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2518: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2519: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2520: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2521: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);
2522: END IF;
2523:

Line 2520: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);

2516: AHL_DEBUG_PUB.debug( 'before assign org id:'||p_x_schedule_visit_rec.org_id);
2517: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2518: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2519: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2520: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2521: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);
2522: END IF;
2523:
2524: l_Visit_tbl(i).VISIT_ID := l_visit_id;

Line 2521: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);

2517: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2518: AHL_DEBUG_PUB.debug( 'before assign dept:'||p_x_schedule_visit_rec.dept_id);
2519: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2520: AHL_DEBUG_PUB.debug( 'before assign space_category_code:'||p_x_schedule_visit_rec.space_category_code);
2521: AHL_DEBUG_PUB.debug( 'before assign end date:'||p_x_schedule_visit_rec.planned_end_date);
2522: END IF;
2523:
2524: l_Visit_tbl(i).VISIT_ID := l_visit_id;
2525: l_Visit_tbl(i).VISIT_NUMBER := p_x_schedule_visit_rec.visit_number;

Line 2594: AHL_DEBUG_PUB.debug( 'before calling when Org Or Start date change AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials');

2590: trunc(p_x_schedule_visit_rec.start_date) <> l_start_date_time OR
2591: l_dummy IS NOT NULL ) THEN
2592:
2593: IF G_DEBUG='Y' THEN
2594: AHL_DEBUG_PUB.debug( 'before calling when Org Or Start date change AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials');
2595: AHL_DEBUG_PUB.debug( 'before calling Visit ID:'||l_visit_id);
2596: AHL_DEBUG_PUB.debug( 'before calling Start Date:'||p_x_schedule_visit_rec.start_date);
2597: AHL_DEBUG_PUB.debug( 'before calling Org ID:'||p_x_schedule_visit_rec.org_id);
2598: END IF;

Line 2595: AHL_DEBUG_PUB.debug( 'before calling Visit ID:'||l_visit_id);

2591: l_dummy IS NOT NULL ) THEN
2592:
2593: IF G_DEBUG='Y' THEN
2594: AHL_DEBUG_PUB.debug( 'before calling when Org Or Start date change AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials');
2595: AHL_DEBUG_PUB.debug( 'before calling Visit ID:'||l_visit_id);
2596: AHL_DEBUG_PUB.debug( 'before calling Start Date:'||p_x_schedule_visit_rec.start_date);
2597: AHL_DEBUG_PUB.debug( 'before calling Org ID:'||p_x_schedule_visit_rec.org_id);
2598: END IF;
2599:

Line 2596: AHL_DEBUG_PUB.debug( 'before calling Start Date:'||p_x_schedule_visit_rec.start_date);

2592:
2593: IF G_DEBUG='Y' THEN
2594: AHL_DEBUG_PUB.debug( 'before calling when Org Or Start date change AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials');
2595: AHL_DEBUG_PUB.debug( 'before calling Visit ID:'||l_visit_id);
2596: AHL_DEBUG_PUB.debug( 'before calling Start Date:'||p_x_schedule_visit_rec.start_date);
2597: AHL_DEBUG_PUB.debug( 'before calling Org ID:'||p_x_schedule_visit_rec.org_id);
2598: END IF;
2599:
2600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 2597: AHL_DEBUG_PUB.debug( 'before calling Org ID:'||p_x_schedule_visit_rec.org_id);

2593: IF G_DEBUG='Y' THEN
2594: AHL_DEBUG_PUB.debug( 'before calling when Org Or Start date change AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials');
2595: AHL_DEBUG_PUB.debug( 'before calling Visit ID:'||l_visit_id);
2596: AHL_DEBUG_PUB.debug( 'before calling Start Date:'||p_x_schedule_visit_rec.start_date);
2597: AHL_DEBUG_PUB.debug( 'before calling Org ID:'||p_x_schedule_visit_rec.org_id);
2598: END IF;
2599:
2600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2601: fnd_log.string

Line 2642: Ahl_Debug_Pub.debug( 'End of private api Schedule Visit','+SPANT+');

2638: COMMIT;
2639: END IF;
2640: -- Debug info
2641: IF G_DEBUG='Y' THEN
2642: Ahl_Debug_Pub.debug( 'End of private api Schedule Visit','+SPANT+');
2643: END IF;
2644: -- Check if API is called in debug mode. If yes, disable debug.
2645: IF G_DEBUG='Y' THEN
2646: Ahl_Debug_Pub.disable_debug;

Line 2646: Ahl_Debug_Pub.disable_debug;

2642: Ahl_Debug_Pub.debug( 'End of private api Schedule Visit','+SPANT+');
2643: END IF;
2644: -- Check if API is called in debug mode. If yes, disable debug.
2645: IF G_DEBUG='Y' THEN
2646: Ahl_Debug_Pub.disable_debug;
2647: END IF;
2648: EXCEPTION
2649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2650: ROLLBACK TO schedule_visit;

Line 2657: AHL_DEBUG_PUB.log_app_messages (

2653: p_count => x_msg_count,
2654: p_data => x_msg_data);
2655: IF G_DEBUG='Y' THEN
2656:
2657: AHL_DEBUG_PUB.log_app_messages (
2658: x_msg_count, x_msg_data, 'ERROR' );
2659: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2660: -- Check if API is called in debug mode. If yes, disable debug.
2661: AHL_DEBUG_PUB.disable_debug;

Line 2659: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');

2655: IF G_DEBUG='Y' THEN
2656:
2657: AHL_DEBUG_PUB.log_app_messages (
2658: x_msg_count, x_msg_data, 'ERROR' );
2659: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2660: -- Check if API is called in debug mode. If yes, disable debug.
2661: AHL_DEBUG_PUB.disable_debug;
2662: END IF;
2663: WHEN FND_API.G_EXC_ERROR THEN

Line 2661: AHL_DEBUG_PUB.disable_debug;

2657: AHL_DEBUG_PUB.log_app_messages (
2658: x_msg_count, x_msg_data, 'ERROR' );
2659: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2660: -- Check if API is called in debug mode. If yes, disable debug.
2661: AHL_DEBUG_PUB.disable_debug;
2662: END IF;
2663: WHEN FND_API.G_EXC_ERROR THEN
2664: ROLLBACK TO schedule_visit;
2665: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2672: AHL_DEBUG_PUB.log_app_messages (

2668: p_data => X_msg_data);
2669: IF G_DEBUG='Y' THEN
2670:
2671: -- Debug info.
2672: AHL_DEBUG_PUB.log_app_messages (
2673: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2674: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');
2675: -- Check if API is called in debug mode. If yes, disable debug.
2676: AHL_DEBUG_PUB.disable_debug;

Line 2674: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');

2670:
2671: -- Debug info.
2672: AHL_DEBUG_PUB.log_app_messages (
2673: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2674: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');
2675: -- Check if API is called in debug mode. If yes, disable debug.
2676: AHL_DEBUG_PUB.disable_debug;
2677: END IF;
2678: WHEN OTHERS THEN

Line 2676: AHL_DEBUG_PUB.disable_debug;

2672: AHL_DEBUG_PUB.log_app_messages (
2673: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2674: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule visit','+SPANT+');
2675: -- Check if API is called in debug mode. If yes, disable debug.
2676: AHL_DEBUG_PUB.disable_debug;
2677: END IF;
2678: WHEN OTHERS THEN
2679: ROLLBACK TO schedule_visit;
2680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2693: AHL_DEBUG_PUB.log_app_messages (

2689: p_data => X_msg_data);
2690: IF G_DEBUG='Y' THEN
2691:
2692: -- Debug info.
2693: AHL_DEBUG_PUB.log_app_messages (
2694: x_msg_count, x_msg_data, 'SQL ERROR' );
2695: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2696: -- Check if API is called in debug mode. If yes, disable debug.
2697: AHL_DEBUG_PUB.disable_debug;

Line 2695: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');

2691:
2692: -- Debug info.
2693: AHL_DEBUG_PUB.log_app_messages (
2694: x_msg_count, x_msg_data, 'SQL ERROR' );
2695: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2696: -- Check if API is called in debug mode. If yes, disable debug.
2697: AHL_DEBUG_PUB.disable_debug;
2698:
2699: END IF;

Line 2697: AHL_DEBUG_PUB.disable_debug;

2693: AHL_DEBUG_PUB.log_app_messages (
2694: x_msg_count, x_msg_data, 'SQL ERROR' );
2695: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Schedule Visit','+SPANT+');
2696: -- Check if API is called in debug mode. If yes, disable debug.
2697: AHL_DEBUG_PUB.disable_debug;
2698:
2699: END IF;
2700: END Schedule_Visit;
2701: --

Line 2791: AHL_DEBUG_PUB.enable_debug;

2787: -- Standard Start of API savepoint
2788: SAVEPOINT unschedule_visit;
2789: -- Check if API is called in debug mode. If yes, enable debug.
2790: IF G_DEBUG='Y' THEN
2791: AHL_DEBUG_PUB.enable_debug;
2792: END IF;
2793: -- Debug info.
2794: IF G_DEBUG='Y' THEN
2795: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');

Line 2795: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');

2791: AHL_DEBUG_PUB.enable_debug;
2792: END IF;
2793: -- Debug info.
2794: IF G_DEBUG='Y' THEN
2795: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
2796: END IF;
2797: -- Standard call to check for call compatibility.
2798: IF FND_API.to_boolean(p_init_msg_list)
2799: THEN

Line 3003: Ahl_Debug_Pub.debug( 'End of private api Unschedule Visit','+SPANT+');

2999: COMMIT;
3000: END IF;
3001: -- Debug info
3002: IF G_DEBUG='Y' THEN
3003: Ahl_Debug_Pub.debug( 'End of private api Unschedule Visit','+SPANT+');
3004: -- Check if API is called in debug mode. If yes, disable debug.
3005: Ahl_Debug_Pub.disable_debug;
3006: END IF;
3007: EXCEPTION

Line 3005: Ahl_Debug_Pub.disable_debug;

3001: -- Debug info
3002: IF G_DEBUG='Y' THEN
3003: Ahl_Debug_Pub.debug( 'End of private api Unschedule Visit','+SPANT+');
3004: -- Check if API is called in debug mode. If yes, disable debug.
3005: Ahl_Debug_Pub.disable_debug;
3006: END IF;
3007: EXCEPTION
3008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3009: ROLLBACK TO unschedule_visit;

Line 3016: AHL_DEBUG_PUB.log_app_messages (

3012: p_count => x_msg_count,
3013: p_data => x_msg_data);
3014: IF G_DEBUG='Y' THEN
3015:
3016: AHL_DEBUG_PUB.log_app_messages (
3017: x_msg_count, x_msg_data, 'ERROR' );
3018: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
3019: -- Check if API is called in debug mode. If yes, disable debug.
3020: AHL_DEBUG_PUB.disable_debug;

Line 3018: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');

3014: IF G_DEBUG='Y' THEN
3015:
3016: AHL_DEBUG_PUB.log_app_messages (
3017: x_msg_count, x_msg_data, 'ERROR' );
3018: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
3019: -- Check if API is called in debug mode. If yes, disable debug.
3020: AHL_DEBUG_PUB.disable_debug;
3021: END IF;
3022: WHEN FND_API.G_EXC_ERROR THEN

Line 3020: AHL_DEBUG_PUB.disable_debug;

3016: AHL_DEBUG_PUB.log_app_messages (
3017: x_msg_count, x_msg_data, 'ERROR' );
3018: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
3019: -- Check if API is called in debug mode. If yes, disable debug.
3020: AHL_DEBUG_PUB.disable_debug;
3021: END IF;
3022: WHEN FND_API.G_EXC_ERROR THEN
3023: ROLLBACK TO unschedule_visit;
3024: X_return_status := FND_API.G_RET_STS_ERROR;

Line 3031: AHL_DEBUG_PUB.log_app_messages (

3027: p_data => X_msg_data);
3028: IF G_DEBUG='Y' THEN
3029:
3030: -- Debug info.
3031: AHL_DEBUG_PUB.log_app_messages (
3032: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3033: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');
3034: -- Check if API is called in debug mode. If yes, disable debug.
3035: AHL_DEBUG_PUB.disable_debug;

Line 3033: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');

3029:
3030: -- Debug info.
3031: AHL_DEBUG_PUB.log_app_messages (
3032: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3033: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');
3034: -- Check if API is called in debug mode. If yes, disable debug.
3035: AHL_DEBUG_PUB.disable_debug;
3036: END IF;
3037: WHEN OTHERS THEN

Line 3035: AHL_DEBUG_PUB.disable_debug;

3031: AHL_DEBUG_PUB.log_app_messages (
3032: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3033: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule visit','+SPANT+');
3034: -- Check if API is called in debug mode. If yes, disable debug.
3035: AHL_DEBUG_PUB.disable_debug;
3036: END IF;
3037: WHEN OTHERS THEN
3038: ROLLBACK TO unschedule_visit;
3039: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3052: AHL_DEBUG_PUB.log_app_messages (

3048: p_data => X_msg_data);
3049: IF G_DEBUG='Y' THEN
3050:
3051: -- Debug info.
3052: AHL_DEBUG_PUB.log_app_messages (
3053: x_msg_count, x_msg_data, 'SQL ERROR' );
3054: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
3055: -- Check if API is called in debug mode. If yes, disable debug.
3056: AHL_DEBUG_PUB.disable_debug;

Line 3054: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');

3050:
3051: -- Debug info.
3052: AHL_DEBUG_PUB.log_app_messages (
3053: x_msg_count, x_msg_data, 'SQL ERROR' );
3054: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
3055: -- Check if API is called in debug mode. If yes, disable debug.
3056: AHL_DEBUG_PUB.disable_debug;
3057: END IF;
3058: END Unschedule_Visit;

Line 3056: AHL_DEBUG_PUB.disable_debug;

3052: AHL_DEBUG_PUB.log_app_messages (
3053: x_msg_count, x_msg_data, 'SQL ERROR' );
3054: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule Visit','+SPANT+');
3055: -- Check if API is called in debug mode. If yes, disable debug.
3056: AHL_DEBUG_PUB.disable_debug;
3057: END IF;
3058: END Unschedule_Visit;
3059:
3060: END AHL_LTP_SPACE_ASSIGN_PVT;